public function bank()
{
$banks = Bank::where('ppk_id', Auth::user()->ppk_id)->get();
if ($banks->isEmpty()) {
$banks = [];
}
// dd($banks);
return View('ppk.rekod.bank', compact('banks'));
}
public function loadEASTWEST(Request $request)
{
if ($request->ajax()) {
$bank = Bank::where('account_id', '200009019676')->select('account_id', 'name', 'account_name')->first();
$mop = $bank->name;
$account_name = $bank->account_name;
$account_id = $bank->account_id;
$address = null;
return \Response::json(\View::make('layouts.forms.paymentdetails')->with(compact('mop', 'account_name', 'account_id', 'address'))->render());
}
}
/**
* 申请提现页面
*
* @date 2015-10-07
* @return [type] [description]
*/
public function withdraw()
{
$data = [];
$user = Auth::user();
$data['username'] = $user->username;
$userBank = UserBank::where('user_id', $user->id)->where('is_lock', 1)->first();
$data['userBank'] = $userBank;
if (!$userBank) {
$data['banks'] = Bank::where('withdraw_status', 1)->select(['name', 'alias'])->get();
}
$data['is_payment'] = $user->payment_password == '' ? true : false;
$data['cashes'] = $user->cashes;
return view('banks.withdraw', $data);
}
public function withdraw()
{
$user = Auth::user();
$input = Input::get('amount');
$bank = Bank::where('name', '=', $user->name)->first();
if ($input <= $bank->money) {
$bank->money -= $input;
$bank->save();
$user->money += $input;
$user->save();
session()->flash('flash_message', 'You withdrew your money!');
return redirect('/bank');
} else {
session()->flash('flash_message_important', 'You failed to withdraw your money!');
return redirect('/bank');
}
}
public function closeOrder($id)
{
if (Gate::denies('order.close')) {
return view(config('app.template') . '.error.403');
}
$order = Order::with(['karyawan', 'detail.produk', 'detail.detailReturn', 'place.place.kategori'])->find($id);
if (!$order) {
return view(config('app.template') . '.error.404');
}
// Detail Order
$orderDetail = [];
foreach ($order->detail->toArray() as $od) {
$odQty = $od['qty'] - ($od['detail_return'] != null ? $od['detail_return']['qty'] : 0);
$in = array_only($od, ['harga_jual', 'satuan']) + ['nama' => $od['produk']['nama'], 'qty' => $odQty, 'subtotal' => $od['harga_jual'] * $odQty];
array_push($orderDetail, $in);
}
$current_place = implode(', ', array_column(array_column($order->place->toArray(), 'place'), 'nama'));
$orderPlaces = [];
foreach ($order->place as $op) {
if ($op->harga > 0) {
array_push($orderPlaces, ['nama' => $op->place->nama . ' - ' . $op->place->kategori->nama, 'harga' => $op->harga]);
}
}
$data = ['order' => $order, 'orderDetail' => $orderDetail, 'orderPlaces' => $orderPlaces, 'tanggal' => $order->tanggal->format('Y-m-d'), 'current_place' => $current_place, 'init_tax' => Tax::where('active', 1)->first(), 'taxes' => Tax::where('active', 1)->lists('type', 'id'), 'banks' => Bank::where('active', 1)->lists('nama_bank', 'id')];
return view(config('app.template') . '.order.close', $data);
}
public function banks()
{
$data['banks'] = Bank::where('status', 1)->get();
$data['adminBanks'] = AdminBank::paginate(10);
return view('backend.systems.banks', $data);
}
protected function _jurnalBank($request)
{
$bank = $request->get('bank') ? $request->get('bank') : Bank::where('active', 1)->first()->id;
$tanggal = $request->get('tanggal') ? $request->get('tanggal') : date('Y-m-d');
$CTanggal = Carbon::createFromFormat('Y-m-d', $tanggal);
$to_tanggal = $request->get('to_tanggal') ? $request->get('to_tanggal') : $tanggal;
$CToTanggal = Carbon::createFromFormat('Y-m-d', $to_tanggal);
$CYesterday = $CTanggal->copy()->addDays(-1);
$yesterday = $CYesterday->format('Y-m-d');
$banks = Bank::where('active', 1)->lists('nama_bank', 'id')->toArray();
$start = $CTanggal->copy();
$end = $CToTanggal->copy();
$dates = [];
while ($start->lte($end)) {
$dates[] = $start->copy();
$start->addDay();
}
// Account Saldo for sisa saldo
$totalAccountSaldo = 0;
$firstAccountSaldo = AccountSaldo::orderBy('tanggal')->limit(1)->first();
if ($firstAccountSaldo) {
if ($firstAccountSaldo->tanggal->lte($CYesterday)) {
$firstDate = $firstAccountSaldo->tanggal->format('Y-m-d');
$where = "(account_saldos.`tanggal` BETWEEN '{$firstDate}' AND '{$yesterday}') and relation_id = '{$bank}' AND";
$column = "IF(account_saldos.`type` = 'kredit', account_saldos.`nominal`, -ABS(account_saldos.`nominal`))";
$totalAccountSaldo = ConvertRawQueryToArray(Account::TotalAccountSaldo($column, $where, 'jurnal'))[0]['total'];
}
}
$tableTemp = [];
// Sisa Saldo Pertanggal $tanggal (-1)
$sisaSaldo = $totalAccountSaldo;
$saldo = $sisaSaldo;
array_push($tableTemp, ['tanggal' => $CYesterday->format('Y-m-d'), 'keterangan' => 'Sisa Saldo ' . $CYesterday->format('d M Y'), 'debet' => '', 'kredit' => '', 'saldo' => $sisaSaldo]);
// Account Saldo range $tanggal s/d $to_tanggal
$accountSaldos = AccountSaldo::with('bank')->join('accounts', 'account_saldos.account_id', '=', 'accounts.id')->leftJoin(DB::raw("(SELECT accounts.`id` AS account_id, accounts.`nama_akun`, reports.display\n FROM accounts\n INNER JOIN account_report ON accounts.`id` = account_report.`account_id`\n INNER JOIN reports ON account_report.`report_id` = reports.id\n WHERE reports.key = 'jurnal')temp_report"), function ($join) {
$join->on('accounts.id', '=', 'temp_report.account_id');
})->where('relation_id', $bank)->whereBetween('tanggal', [$tanggal, $to_tanggal])->whereNotNull('temp_report.account_id')->select(['account_saldos.*', DB::raw('accounts.nama_akun as nama_akun'), DB::raw('tanggal as _date')])->get()->groupBy('_date');
foreach ($dates as $date) {
// Account Saldo
if (isset($accountSaldos[$date->format('Y-m-d')])) {
$acs = $accountSaldos[$date->format('Y-m-d')];
foreach ($acs as $as) {
$bankName = $as['bank'] != null ? $as['bank']['nama_bank'] : '';
if ($as['type'] == 'debet') {
$saldo -= $as['nominal'];
array_push($tableTemp, ['tanggal' => $date->format('Y-m-d'), 'keterangan' => $as['nama_akun'] . ' ' . $bankName, 'debet' => '', 'kredit' => $as['nominal'], 'saldo' => $saldo]);
} else {
// kredit
$saldo += $as['nominal'];
array_push($tableTemp, ['tanggal' => $date->format('Y-m-d'), 'keterangan' => $as['nama_akun'] . ' ' . $bankName, 'debet' => $as['nominal'], 'kredit' => '', 'saldo' => $saldo]);
}
}
}
}
$tableTemp = collect($tableTemp)->groupBy('tanggal');
return ['tanggal' => $CTanggal, 'to_tanggal' => $CToTanggal, 'bank' => $bank, 'banks' => $banks, 'table' => $tableTemp];
}
