ViewManageController.php
bagian controllernya
unknown
php_laravel_blade
2 years ago
11 kB
3
Indexable
<?php
namespace App\Http\Controllers;
use Session;
use Auth;
use Carbon\Carbon;
use App\Market;
use App\User;
use App\Transaction;
use App\TransactionNonPPN;
use Illuminate\Http\Request;
class ViewManageController extends Controller
{
// Show View Dashboard
public function viewDashboard()
{
$id_account = Auth::id();
$role = User::where('id', $id_account)->first();
if ($role->role != 'kasir') {
$kd_transaction = Transaction::select(['kode_transaksi', 'total', 'created_at'])
->latest()
->distinct()
->take(3)
->get();
$kd_transaction_nonppn = TransactionNonPPN::select(['kode_transaksi', 'total', 'created_at'])
->latest()
->distinct()
->take(3)
->get();
$kd_transaction = $kd_transaction->concat($kd_transaction_nonppn);
$kd_transaction = $kd_transaction->sortByDesc('created_at');
// $kd_transaction = $kd_transaction_nonppn->sortByDesc('created_at');
// dump($kd_transaction);
$kd_transaction_uniques = array();
foreach ($kd_transaction as $c) {
$kd_transaction_uniques[$c->kode_transaksi] = $c; // Get unique
}
$transactions = Transaction::where('status', 'lunas')->get();
$transactions_nonppn = TransactionNonPPN::where('status', 'lunas')->get();
$transactions = $transactions->concat($transactions_nonppn);
// dd($transactions);
$array = array();
foreach ($transactions as $no => $transaction) {
array_push($array, $transactions[$no]->created_at->toDateString());
}
$dates = array_unique($array);
rsort($dates);
$arr_ammount = count($dates);
$incomes_data = array();
if ($arr_ammount > 7) {
for ($i = 0; $i < 7; $i++) {
array_push($incomes_data, $dates[$i]);
}
} elseif ($arr_ammount > 0) {
for ($i = 0; $i < $arr_ammount; $i++) {
array_push($incomes_data, $dates[$i]);
}
}
$incomes = array_reverse($incomes_data);
$kode_transaksi_dis = Transaction::select(['kode_transaksi'])
->distinct()
->get();
$kode_transaksi_npp_dis = TransactionNonPPN::select(['kode_transaksi'])
->distinct()
->get();
$kode_transaksi_dis = $kode_transaksi_dis->concat($kode_transaksi_npp_dis);
// $test = $kode_transaksi_dis->merge($kode_transaksi_npp_dis);
// dd(array_unique($kode_transaksi_dis));
// dd($kode_transaksi_dis->items);
// dd($kode_transaksi_dis);
$kode_transaksi_uniques = array();
foreach ($kode_transaksi_dis as $c) {
$kode_transaksi_uniques[$c->kode_transaksi] = $c; // Get unique
}
// dd($kode_transaksi_uniques);
$kode_transaksi_dis_daily = Transaction::whereDate('created_at', Carbon::now())
->select(['kode_transaksi'])
->distinct()
->get();
$kode_transaksi_npp_dis_daily = TransactionNonPPN::whereDate('created_at', Carbon::now())
->select(['kode_transaksi'])
->distinct()
->get();
$kode_transaksi_dis_daily = $kode_transaksi_dis_daily->concat($kode_transaksi_npp_dis_daily);
$kode_transaksi_daily_uniques = array();
foreach ($kode_transaksi_dis_daily as $c) {
$kode_transaksi_daily_uniques[$c->kode_transaksi] = $c; // Get unique
}
// $test = $kode_transaksi_dis;
$all_incomes = 0;
$incomes_daily = 0;
$retur = 0;
foreach ($kode_transaksi_uniques as $kode) {
$transaksi = Transaction::where('kode_transaksi', $kode->kode_transaksi)->first();
if ($transaksi != null) {
$all_incomes += $transaksi->total;
// dump($kode->kode_transaksi);
} else {
$transaksi = TransactionNonPPN::where('kode_transaksi', $kode->kode_transaksi)->first();
$all_incomes += $transaksi->total;
// dump($kode->kode_transaksi);
}
// $total_tr = \App\Transaction::where('status','lunas')->sum('total_barang');
// $total_tr_nppn = \App\TransactionNonPPN::where('status','lunas')->sum('total_barang');
// $all_incomes = (int) $total_tr + $total_tr_nppn;
}
foreach ($kode_transaksi_daily_uniques as $kode) {
// print("masuk");
$transaksi_daily = Transaction::where('kode_transaksi', $kode->kode_transaksi)->first();
if ($transaksi_daily != null) {
$incomes_daily += $transaksi_daily->total;
} else {
$transaksi_daily = TransactionNonPPN::where('kode_transaksi', $kode->kode_transaksi)->first();
$incomes_daily += $transaksi_daily->total;
}
// $transaksi_npp_daily = TransactionNonPPN::where('kode_transaksi', $kode->kode_transaksi)->first();
// $incomes_daily += $transaksi_daily->total;
}
// dd($incomes_daily, $all_incomes);
$retur = Transaction::where('status', 'retur')->whereDate('created_at', Carbon::now())->sum('total_barang');
$retur_nppn = TransactionNonPPN::where('status', 'retur')->whereDate('created_at', Carbon::now())->sum('total_barang');
$retur = $retur + $retur_nppn;
$incomes_daily = $incomes_daily - $retur;
// dd($incomes_daily);
$customers_daily = count($kode_transaksi_dis_daily);
$min_date = Transaction::where('status', 'lunas')->min('created_at');
$max_date = Transaction::where('status', 'lunas')->max('created_at');
$min_date_nppn = TransactionNonPPN::where('status', 'lunas')->min('created_at');
$max_date_nppn = TransactionNonPPN::where('status', 'lunas')->max('created_at');
$min_date = $min_date < $min_date_nppn ? $min_date : $min_date_nppn;
$max_date = $max_date > $max_date_nppn ? $max_date : $max_date_nppn;
// dd($min_date, $max_date);
$market = Market::first();
return view('dashboard', compact('kd_transaction_uniques', 'incomes', 'incomes_daily', 'customers_daily', 'all_incomes', 'min_date', 'max_date', 'market'));
} else {
return view('blank_dashboard');
}
}
// Filter Chart Dashboard
public function filterChartDashboard($filter)
{
if ($filter == 'pemasukan') {
$supplies = Transaction::where('status', 'lunas')->get();
$supplies_nonppn = TransactionNonPPN::where('status', 'lunas')->get();
$supplies = $supplies->concat($supplies_nonppn);
$array = array();
foreach ($supplies as $no => $supply) {
array_push($array, $supplies[$no]->created_at->toDateString());
}
$dates = array_unique($array);
rsort($dates);
$arr_ammount = count($dates);
$incomes_data = array();
if ($arr_ammount > 7) {
for ($i = 0; $i < 7; $i++) {
array_push($incomes_data, $dates[$i]);
}
} elseif ($arr_ammount > 0) {
for ($i = 0; $i < $arr_ammount; $i++) {
array_push($incomes_data, $dates[$i]);
}
}
$incomes = array_reverse($incomes_data);
$total = array();
foreach ($incomes as $no => $income) {
array_push($total, [
Transaction::whereDate('created_at', $income)->where('status', 'lunas')->sum('total'),
TransactionNonPPN::whereDate('created_at', $income)->where('status', 'lunas')->sum('total')
]);
}
// total array sortby last index
$total = array_map(function ($arr) {
return $arr[count($arr) - 1];
}, $total);
return response()->json([
'incomes' => $incomes,
'total' => $total
]);
} else {
$supplies = Transaction::where('status', 'lunas')->get();
$supplies_nonppn = TransactionNonPPN::where('status', 'lunas')->get();
$supplies = $supplies->concat($supplies_nonppn);
$array = array();
foreach ($supplies as $no => $supply) {
array_push($array, $supplies[$no]->created_at->toDateString());
}
$dates = array_unique($array);
rsort($dates);
$arr_ammount = count($dates);
$customer_data = array();
if ($arr_ammount > 7) {
for ($i = 0; $i < 7; $i++) {
array_push($customer_data, $dates[$i]);
}
} elseif ($arr_ammount > 0) {
for ($i = 0; $i < $arr_ammount; $i++) {
array_push($customer_data, $dates[$i]);
}
}
$customers = array_reverse($customer_data);
$jumlah = array();
foreach ($customers as $no => $customer) {
array_push($jumlah, [
Transaction::whereDate('created_at', $customer)->where('status', 'lunas')->count(),
TransactionNonPPN::whereDate('created_at', $customer)->where('status', 'lunas')->count()
]);
}
//jumlah array sortby last index
$jumlah = array_map(function ($arr) {
return $arr[count($arr) - 1];
}, $jumlah);
return response()->json([
'customers' => $customers,
'jumlah' => $jumlah
]);
}
}
// Update Market
public function updateMarket(Request $req)
{
$market = Market::first();
$market->nama_toko = $req->nama_toko;
$market->no_telp = $req->no_telp;
$market->alamat = $req->alamat;
$market->save();
Session::flash('update_success', 'Pengaturan berhasil diubah');
return back();
}
}