private function getExceptionData($exception) { $data = []; $data['host'] = Request::server('HTTP_HOST'); $data['method'] = Request::method(); $data['fullUrl'] = Request::fullUrl(); if (php_sapi_name() === 'cli') { $data['host'] = parse_url(config('app.url'), PHP_URL_HOST); $data['method'] = 'CLI'; } $data['exception'] = $exception->getMessage(); $data['error'] = $exception->getTraceAsString(); $data['line'] = $exception->getLine(); $data['file'] = $exception->getFile(); $data['class'] = get_class($exception); $data['storage'] = array('SERVER' => Request::server(), 'GET' => Request::query(), 'POST' => $_POST, 'FILE' => Request::file(), 'OLD' => Request::hasSession() ? Request::old() : [], 'COOKIE' => Request::cookie(), 'SESSION' => Request::hasSession() ? Session::all() : [], 'HEADERS' => Request::header()); $data['storage'] = array_filter($data['storage']); $count = $this->config['count']; $data['exegutor'] = []; $data['file_lines'] = []; $file = new SplFileObject($data['file']); for ($i = -1 * abs($count); $i <= abs($count); $i++) { list($line, $exegutorLine) = $this->getLineInfo($file, $data['line'], $i); $data['exegutor'][] = $exegutorLine; $data['file_lines'][$data['line'] + $i] = $line; } // to make Symfony exception more readable if ($data['class'] == 'Symfony\\Component\\Debug\\Exception\\FatalErrorException') { preg_match("~^(.+)' in ~", $data['exception'], $matches); if (isset($matches[1])) { $data['exception'] = $matches[1]; } } return $data; }
public function newcancelcarpreemption() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } if (Auth::user()->isadmin) { $carpreemptions = CarPreemption::where('status', 0)->doesntHave('carPayment')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no']); } else { $carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->where('status', 0)->doesntHave('carPayment')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no']); } $carpreemptionselectlist = array(); $carpreemptionselectlist[null] = 'เลือกการจอง'; foreach ($carpreemptions as $item) { $carpreemptionselectlist[$item->id] = $item->bookno . '/' . $item->no; } $carpreemptionid = SupportRequest::old('carpreemptionid'); if ($carpreemptionid != null && $carpreemptionid != '') { $carpreemption = CarPreemption::find($carpreemptionid); $model = Customer::find($carpreemption->buyercustomerid); $customer = $model->title . ' ' . $model->firstname . ' ' . $model->lastname; $model = CarModel::find($carpreemption->carmodelid); $model2 = CarSubModel::find($carpreemption->carsubmodelid); $carmodel = $model->name . '/' . $model2->name; $date = date('d-m-Y', strtotime($carpreemption->date)); $cashpledge = $carpreemption->cashpledge; $model = Employee::find($carpreemption->salesmanemployeeid); $salesmanemployee = $model->title . ' ' . $model->firstname . ' ' . $model->lastname; } else { $customer = null; $carmodel = null; $date = null; $cashpledge = null; $salesmanemployee = null; } if (Auth::user()->isadmin) { $toemployees = Employee::where('departmentid', 5)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $toemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 5)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $toemployeeselectlist = array(); $toemployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($toemployees as $item) { $toemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } if (Auth::user()->isadmin) { $accountandfinanceemployees = Employee::where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $accountandfinanceemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $accountandfinanceemployeeselectlist = array(); $accountandfinanceemployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($accountandfinanceemployees as $item) { $accountandfinanceemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } $cancelcarpreemption = new CancelCarPreemption(); return view('cancelcarpreemptionform', ['oper' => 'new', 'pathPrefix' => '../', 'cancelcarpreemption' => $cancelcarpreemption, 'carpreemptionselectlist' => $carpreemptionselectlist, 'toemployeeselectlist' => $toemployeeselectlist, 'accountandfinanceemployeeselectlist' => $accountandfinanceemployeeselectlist, 'customer' => $customer, 'carmodel' => $carmodel, 'date' => $date, 'cashpledge' => $cashpledge, 'salesmanemployee' => $salesmanemployee]); }
/** * Handle the signup with invite. * * @param string|null $code * * @return \Illuminate\View\View */ public function getSignup($code = null) { if ($code === null) { //throw new NotFoundHttpException(); } $invite = Invite::where('code', '=', $code)->first(); if (!$invite || $invite->claimed()) { //throw new BadRequestHttpException(); } return View::make('signup')->withCode($invite ? $invite->code : '')->withPageTitle('signup')->withUsername(Request::old('username'))->withEmail(Request::old('emai', $invite ? $invite->email : '')); }
public function newcarpayment() { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } if (Auth::user()->isadmin) { $carpreemptions = CarPreemption::where('status', 0)->where(function ($query) { $query->where('carobjectivetype', 1)->orWhere(function ($query) { $query->where('cashpledgeredlabel', 0)->orWhereHas('redlabelhistories', function ($q) { $q->whereNull('returndate'); }); }); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no']); } else { $carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->where('status', 0)->where(function ($query) { $query->where('carobjectivetype', 1)->orWhere(function ($query) { $query->where('cashpledgeredlabel', 0)->orWhereHas('redlabelhistories', function ($q) { $q->whereNull('returndate'); }); }); })->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no']); } $carpreemptionselectlist = array(); $carpreemptionselectlist[null] = 'เลือกการจอง'; foreach ($carpreemptions as $item) { $carpreemptionselectlist[$item->id] = $item->bookno . '/' . $item->no; } $carpreemptionid = SupportRequest::old('carpreemptionid'); $carselectlist = array(); $carselectlist[null] = 'เลือกรถ'; $purchasetype0 = false; $purchasetype1 = false; $carobjectivetype0 = false; $carobjectivetype1 = false; $registrationtype0 = false; $registrationtype1 = false; $registrationtype2 = false; if ($carpreemptionid != null && $carpreemptionid != '') { $carpreemption = CarPreemption::find($carpreemptionid); if ($carpreemption->purchasetype == 0) { $purchasetype0 = true; $purchasetype1 = false; } elseif ($carpreemption->purchasetype == 1) { $purchasetype0 = false; $purchasetype1 = true; } if ($carpreemption->carobjectivetype == 0) { $carobjectivetype0 = true; $carobjectivetype1 = false; } elseif ($carpreemption->carobjectivetype == 1) { $carobjectivetype0 = false; $carobjectivetype1 = true; } if ($carpreemption->registrationtype == 0) { $registrationtype0 = true; $registrationtype1 = false; $registrationtype2 = false; } elseif ($carpreemption->registrationtype == 1) { $registrationtype0 = false; $registrationtype1 = true; $registrationtype2 = false; } elseif ($carpreemption->registrationtype == 2) { $registrationtype0 = false; $registrationtype1 = false; $registrationtype2 = true; } if (Auth::user()->isadmin) { if ($carpreemption->carobjectivetype == 0) { $cars = Car::doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } else { $cars = Car::doesntHave('carPayment')->where('objective', '!=', 0)->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } } else { if ($carpreemption->carobjectivetype == 0) { $cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } else { $cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('objective', '!=', 0)->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']); } } foreach ($cars as $item) { $carselectlist[$item->id] = $item->chassisno . '/' . $item->engineno; } } $insurancecompanies = InsuranceCompany::orderBy('name', 'asc')->get(['id', 'name']); $insurancecompanyselectlist = array(); $insurancecompanyselectlist[null] = 'เลือกบริษัท'; foreach ($insurancecompanies as $item) { $insurancecompanyselectlist[$item->id] = $item->name; } if (Auth::user()->isadmin) { $payeeemployees = Employee::where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $payeeemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 4)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $payeeemployeeselectlist = array(); $payeeemployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($payeeemployees as $item) { $payeeemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } $carpayment = new CarPayment(); $carpayment->date = date('d-m-Y'); return view('carpaymentform', ['oper' => 'new', 'pathPrefix' => '../', 'carpayment' => $carpayment, 'carpreemptionselectlist' => $carpreemptionselectlist, 'carselectlist' => $carselectlist, 'insurancecompanyselectlist' => $insurancecompanyselectlist, 'payeeemployeeselectlist' => $payeeemployeeselectlist, 'purchasetype0' => $purchasetype0, 'purchasetype1' => $purchasetype1, 'carobjectivetype0' => $carobjectivetype0, 'carobjectivetype1' => $carobjectivetype1, 'registrationtype0' => $registrationtype0, 'registrationtype1' => $registrationtype1, 'registrationtype2' => $registrationtype2]); }
public function view($id) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $tempModel = AccountingDetail::find($id); $accountingdetail = (new CarPaymentController())->getforaccountingdetailbyid($tempModel->carpaymentid, 0); $accountingdetail->id = $tempModel->id; $accountingdetail->invoiceno = $tempModel->invoiceno; $accountingdetail->date = date('d-m-Y', strtotime($tempModel->date)); $accountingdetail->additionalopenbill = $tempModel->additionalopenbill; $accountingdetail->insurancefeereceiptcondition = $tempModel->insurancefeereceiptcondition; if ($tempModel->payinadvanceamountreimbursementdate != null) { $accountingdetail->payinadvanceamountreimbursementdate = date('d-m-Y', strtotime($tempModel->payinadvanceamountreimbursementdate)); } else { $accountingdetail->payinadvanceamountreimbursementdate = null; } $accountingdetail->payinadvanceamountreimbursementdocno = $tempModel->payinadvanceamountreimbursementdocno; $accountingdetail->insurancebilldifferent = $tempModel->insurancebilldifferent; if ($tempModel->insurancebilldifferent > 0) { $accountingdetail->note1insurancefeeincludevat = $accountingdetail->note1insurancefeeincludevat + $tempModel->insurancebilldifferent; $accountingdetail->note1insurancefee = $accountingdetail->note1insurancefeeincludevat * 100 / 107.0; $accountingdetail->note1insurancefeevat = $accountingdetail->note1insurancefeeincludevat - $accountingdetail->note1insurancefee; $accountingdetail->incasefinaceinsurancefee = $accountingdetail->incasefinaceinsurancefee + $tempModel->insurancebilldifferent; $accountingdetail->totalincasefinace = $accountingdetail->totalincasefinace + $tempModel->insurancebilldifferent; $accountingdetail->incasefinacereceivedcash = $accountingdetail->incasefinacereceivedcash - $tempModel->insurancebilldifferent; $accountingdetail->incasefinacehassubsidisereceivedcash = $accountingdetail->incasefinacehassubsidisereceivedcash - $tempModel->insurancebilldifferent; $accountingdetail->note2insurancefeewhtax = $accountingdetail->note1insurancefee / 100.0; $accountingdetail->ins = $accountingdetail->ins + $tempModel->insurancebilldifferent; } $accountingdetail->note1insurancefeereceiptcondition = $tempModel->note1insurancefeereceiptcondition; $accountingdetail->insurancefeepayment = $tempModel->insurancefeepayment; if ($tempModel->insurancefeepayment == 1) { $accountingdetail->note2insurancefeewhtax = 0; $accountingdetail->totalincasefinace = $accountingdetail->totalincasefinace - $accountingdetail->incasefinaceinsurancefee; $accountingdetail->incasefinacereceivedcash = $accountingdetail->incasefinacereceivedcash + $accountingdetail->incasefinaceinsurancefee; $accountingdetail->incasefinacehassubsidisereceivedcash = $accountingdetail->incasefinacehassubsidisereceivedcash + $accountingdetail->incasefinaceinsurancefee; $accountingdetail->incasefinaceinsurancefee = 0; } if ($tempModel->insurancefeepaidseparatelydate != null) { $accountingdetail->insurancefeepaidseparatelydate = date('d-m-Y', strtotime($tempModel->insurancefeepaidseparatelydate)); } else { $accountingdetail->insurancefeepaidseparatelydate = null; } $accountingdetail->insurancepremiumnet = $tempModel->insurancepremiumnet; $accountingdetail->insurancepremiumcom = $tempModel->insurancepremiumcom; $accountingdetail->insurancefeepaidseparatelytotal = $tempModel->insurancefeepaidseparatelytotal; if ($tempModel->insurancefeereceiptcondition == 0 || $tempModel->insurancefeereceiptcondition == 1) { $accountingdetail->hasinsurancefee = 1; if ($tempModel->insurancefeereceiptcondition == 0) { $accountingdetail->note2insurancefeewhtax = 0; $accountingdetail->ins = 0; } } else { $accountingdetail->hasinsurancefee = 0; } $accountingdetail->compulsorymotorinsurancefeereceiptcondition = $tempModel->compulsorymotorinsurancefeereceiptcondition; $accountingdetail->note1compulsorymotorinsurancefeereceiptcondition = $tempModel->note1compulsorymotorinsurancefeereceiptcondition; $accountingdetail->compulsorymotorinsurancefeepayment = $tempModel->compulsorymotorinsurancefeepayment; if ($tempModel->compulsorymotorinsurancefeepayment == 1) { $accountingdetail->note2compulsorymotorinsurancefeewhtax = 0; $accountingdetail->totalincasefinace = $accountingdetail->totalincasefinace - $accountingdetail->incasefinacecompulsorymotorinsurancefee; $accountingdetail->incasefinacereceivedcash = $accountingdetail->incasefinacereceivedcash + $accountingdetail->incasefinacecompulsorymotorinsurancefee; $accountingdetail->incasefinacehassubsidisereceivedcash = $accountingdetail->incasefinacehassubsidisereceivedcash + $accountingdetail->incasefinacecompulsorymotorinsurancefee; $accountingdetail->incasefinacecompulsorymotorinsurancefee = 0; } if ($tempModel->compulsorymotorinsurancefeepaidseparatelydate != null) { $accountingdetail->compulsorymotorinsurancefeepaidseparatelydate = date('d-m-Y', strtotime($tempModel->compulsorymotorinsurancefeepaidseparatelydate)); } else { $accountingdetail->compulsorymotorinsurancefeepaidseparatelydate = null; } $accountingdetail->compulsorymotorinsurancepremiumnet = $tempModel->compulsorymotorinsurancepremiumnet; $accountingdetail->compulsorymotorinsurancepremiumcom = $tempModel->compulsorymotorinsurancepremiumcom; $accountingdetail->compulsorymotorinsurancefeepaidseparatelytotal = $tempModel->compulsorymotorinsurancefeepaidseparatelytotal; if ($tempModel->compulsorymotorinsurancefeereceiptcondition == 0 || $tempModel->compulsorymotorinsurancefeereceiptcondition == 1) { $accountingdetail->hascompulsorymotorinsurancefee = 1; if ($tempModel->compulsorymotorinsurancefeereceiptcondition == 0) { $accountingdetail->note2compulsorymotorinsurancefeewhtax = 0; $accountingdetail->prb = 0; } } else { $accountingdetail->hascompulsorymotorinsurancefee = 0; } $note2totalwhtax = $accountingdetail->note2insurancefeewhtax + $accountingdetail->note2compulsorymotorinsurancefeewhtax + $accountingdetail->note2subsidisewhtax; $accountingdetail->note2totalwhtax = $note2totalwhtax; $accountingdetail->cashpledgeredlabelreceiptbookno = $tempModel->cashpledgeredlabelreceiptbookno; $accountingdetail->cashpledgeredlabelreceiptno = $tempModel->cashpledgeredlabelreceiptno; if ($tempModel->cashpledgeredlabelreceiptdate != null) { $accountingdetail->cashpledgeredlabelreceiptdate = date('d-m-Y', strtotime($tempModel->cashpledgeredlabelreceiptdate)); } else { $accountingdetail->cashpledgeredlabelreceiptdate = null; } $accountingdetail->cashpledgereceiptbookno = $tempModel->cashpledgereceiptbookno; $accountingdetail->cashpledgereceiptno = $tempModel->cashpledgereceiptno; $accountingdetail->cashpledgereceiptdate = date('d-m-Y', strtotime($tempModel->cashpledgereceiptdate)); $accountingdetail->oldcarcomamount = $tempModel->oldcarcomamount; if ($tempModel->oldcarcomdate != null) { $accountingdetail->oldcarcomdate = date('d-m-Y', strtotime($tempModel->oldcarcomdate)); } else { $accountingdetail->oldcarcomdate = null; } $accountingdetail->adj = $tempModel->adj; $accountingdetail->incasefinacecomfinamount = $tempModel->incasefinacecomfinamount; $accountingdetail->incasefinacecomfinvat = $tempModel->incasefinacecomfinvat; $accountingdetail->incasefinacecomfinamountwithvat = $tempModel->incasefinacecomfinamountwithvat; $accountingdetail->incasefinacecomfinwhtax = $tempModel->incasefinacecomfinwhtax; $accountingdetail->incasefinacecomfintotal = $tempModel->incasefinacecomfintotal; $accountingdetail->systemcalincasefinacecomfinamount = $tempModel->systemcalincasefinacecomfinamount; $accountingdetail->systemcalincasefinacecomfinvat = $tempModel->systemcalincasefinacecomfinvat; $accountingdetail->systemcalincasefinacecomfinamountwithvat = $tempModel->systemcalincasefinacecomfinamountwithvat; $accountingdetail->systemcalincasefinacecomfinwhtax = $tempModel->systemcalincasefinacecomfinwhtax; $accountingdetail->systemcalincasefinacecomfintotal = $tempModel->systemcalincasefinacecomfintotal; $accountingdetail->receivedcashfromfinace = $tempModel->receivedcashfromfinacenet; $accountingdetail->receivedcashfromfinacenet = $tempModel->receivedcashfromfinacenet; $accountingdetail->receivedcashfromfinaceshort = $tempModel->receivedcashfromfinacenetshort; $accountingdetail->receivedcashfromfinacenetshort = $tempModel->receivedcashfromfinacenetshort; $accountingdetail->receivedcashfromfinaceover = $tempModel->receivedcashfromfinacenetover; $accountingdetail->receivedcashfromfinacenetover = $tempModel->receivedcashfromfinacenetover; $accountingdetail->totalacc1 = $tempModel->totalaccount1; $accountingdetail->totalaccount1 = $tempModel->totalaccount1; $accountingdetail->totalacc1short = $tempModel->totalaccount1short; $accountingdetail->totalaccount1short = $tempModel->totalaccount1short; $accountingdetail->totalacc1over = $tempModel->totalaccount1over; $accountingdetail->totalaccount1over = $tempModel->totalaccount1over; $accountingdetail->totalacc2 = $tempModel->totalaccount2; $accountingdetail->totalaccount2 = $tempModel->totalaccount2; $accountingdetail->totalacc2short = $tempModel->totalaccount2short; $accountingdetail->totalaccount2short = $tempModel->totalaccount2short; $accountingdetail->totalacc2over = $tempModel->totalaccount2over; $accountingdetail->totalaccount2over = $tempModel->totalaccount2over; $accountingdetail->totalaccs = $tempModel->totalaccounts; $accountingdetail->totalaccounts = $tempModel->totalaccounts; $accountingdetail->totalaccsshort = $tempModel->totalaccountsshort; $accountingdetail->totalaccountsshort = $tempModel->totalaccountsshort; $accountingdetail->totalaccsover = $tempModel->totalaccountsover; $accountingdetail->totalaccountsover = $tempModel->totalaccountsover; $finalopenbill = $accountingdetail->openbill; if ($accountingdetail->additionalopenbill != null && $accountingdetail->additionalopenbill > 0) { $finalopenbill = $finalopenbill + $accountingdetail->additionalopenbill; } if ($finalopenbill == 0) { $accountingdetail->finalopenbill = 0; $accountingdetail->vatoffinalopenbill = 0; $accountingdetail->finalopenbillwithoutvat = 0; $accountingdetail->realsalespricewithoutvat = $accountingdetail->realsalesprice; } else { $accountingdetail->finalopenbill = $finalopenbill; $vat = $finalopenbill * 7.0 / 107.0; $accountingdetail->vatoffinalopenbill = $vat; $accountingdetail->finalopenbillwithoutvat = $finalopenbill - $vat; $realsalesprice = $accountingdetail->realsalesprice; $accountingdetail->realsalespricewithoutvat = $realsalesprice - $vat; } $incasefinacereceivedcash = $accountingdetail->incasefinacereceivedcash; $tradereceivableaccount1amount = $finalopenbill - $incasefinacereceivedcash; $accountingdetail->tradereceivableaccount1amount = $tradereceivableaccount1amount; $accountingdetail->ar = $tradereceivableaccount1amount; $cash = $tradereceivableaccount1amount - $accountingdetail->ins - $accountingdetail->prb - $accountingdetail->dc + $accountingdetail->adj; $accountingdetail->cash = $cash; $carpayment = CarPayment::where('id', $tempModel->carpaymentid)->with('carpreemption')->first(); $carpaymentselectlist = array(); $carpaymentselectlist[$carpayment->id] = $carpayment->carpreemption->bookno . '/' . $carpayment->carpreemption->no; $banks = Bank::orderBy('accountgroup', 'asc')->orderBy('name', 'asc')->get(); $bankselectlist = array(); $bankselectlist[null] = 'เลือกบัญชี'; foreach ($banks as $item) { $bankselectlist[$item->id] = $item->name . ' ' . substr($item->accountno, -4); } $bankselectlist2 = array(); array_push($bankselectlist2, ':เลือกบัญชี'); foreach ($banks as $item) { array_push($bankselectlist2, $item->id . ':' . $item->name . ' ' . substr($item->accountno, -4)); } $receiveAndPayDatas0 = array(); $receiveAndPayData0 = SupportRequest::old('receiveAndPayData0'); if ($receiveAndPayData0 != null && $receiveAndPayData0 != '') { $receiveAndPayData0 = json_decode($receiveAndPayData0, true); foreach ($receiveAndPayData0 as $data) { $obj = (object) array("id" => $data["id"], "date" => $data["date"], "type" => $data["type"], "amount" => $data["amount"], "accountgroup" => $data["accountgroup"], "bankid" => $data["bankid"], "note" => $data["note"]); array_push($receiveAndPayDatas0, $obj); } } else { $receiveAndPays0 = AccountingDetailReceiveAndPay::where('accountingdetailid', $id)->where('sectiontype', 0)->get(['id', 'date', 'type', 'amount', 'accountgroup', 'bankid', 'note']); foreach ($receiveAndPays0 as $data) { $obj = (object) array("id" => $data->id, "date" => $data->date, "type" => $data->type, "amount" => $data->amount, "accountgroup" => $data->accountgroup, "bankid" => $data->bankid, "note" => $data->note); array_push($receiveAndPayDatas0, $obj); } } $receiveAndPayDatas1 = array(); $receiveAndPayData1 = SupportRequest::old('receiveAndPayData1'); if ($receiveAndPayData1 != null && $receiveAndPayData1 != '') { $receiveAndPayData1 = json_decode($receiveAndPayData1, true); foreach ($receiveAndPayData1 as $data) { $obj = (object) array("id" => $data["id"], "date" => $data["date"], "type" => $data["type"], "amount" => $data["amount"], "accountgroup" => $data["accountgroup"], "bankid" => $data["bankid"], "note" => $data["note"]); array_push($receiveAndPayDatas1, $obj); } } else { $receiveAndPays1 = AccountingDetailReceiveAndPay::where('accountingdetailid', $id)->where('sectiontype', 1)->get(['id', 'date', 'type', 'amount', 'accountgroup', 'bankid', 'note']); foreach ($receiveAndPays1 as $data) { $obj = (object) array("id" => $data->id, "date" => $data->date, "type" => $data->type, "amount" => $data->amount, "accountgroup" => $data->accountgroup, "bankid" => $data->bankid, "note" => $data->note); array_push($receiveAndPayDatas1, $obj); } } foreach ($accountingdetail->toArray() as $key => $value) { if (!in_array($key, $this->arrNotFormatted)) { if (is_numeric($value) && (double) $value != 0.0) { $value = number_format($value, 2, '.', ','); } else { if ($value == null || $value == '' || is_numeric($value) && (double) $value == 0.0) { $value = '-'; } } $accountingdetail->{$key} = $value; } } return view('accountingdetailform', ['oper' => 'view', 'pathPrefix' => '../../', 'accountingdetail' => $accountingdetail, 'carpaymentselectlist' => $carpaymentselectlist, 'bankselectlist' => $bankselectlist, 'bankselectlist2' => implode(";", $bankselectlist2), 'receiveAndPayDatas0' => $receiveAndPayDatas0, 'receiveAndPayDatas1' => $receiveAndPayDatas1]); }
/** * Show the form for finalizing a password reset. * * @return \Illuminate\View\View */ public function reset() { $token = Request::query('token') ?: Request::old('token'); if (!$token) { return $this->redirect('login'); } return $this->view('c::auth.reset', ['formAction' => $this->url('attemptReset'), 'token' => $token]); }
public function edit($id) { if (!$this->hasPermission($this->menuPermissionName)) { return view($this->viewPermissiondeniedName); } $model = CarPreemption::find($id); $carPayment = CarPayment::where('carpreemptionid', $id)->first(); if (!Auth::user()->isadmin && $carPayment != null && $carPayment->deliverycarbookno != null && $carPayment->deliverycarbookno != '') { return "ไม่สามารถแก้ไขข้อมูลการจองได้ เนื่องจากมีการส่งรถแล้ว!!"; } $bookingcustomer = Customer::find($model->bookingcustomerid); $model->bookingcustomername = $bookingcustomer->title . ' ' . $bookingcustomer->firstname . ' ' . $bookingcustomer->lastname; $model->provincebranchid = $bookingcustomer->provinceid; $model->bookingcustomeraddress = $bookingcustomer->address; $model->bookingcustomerprovinceid = $bookingcustomer->addprovinceid; $model->bookingcustomeramphurid = $bookingcustomer->amphurid; $model->bookingcustomerdistrictid = $bookingcustomer->districtid; $model->bookingcustomerzipcode = $bookingcustomer->zipcode; $model->bookingcustomerphone1 = $bookingcustomer->phone1; $model->bookingcustomerphone2 = $bookingcustomer->phone2; $model->bookingcustomeroccupationid = $bookingcustomer->occupationid; if ($bookingcustomer->birthdate != null && $bookingcustomer->birthdate != '') { $model->bookingcustomerbirthdate = date('d-m-Y', strtotime($bookingcustomer->birthdate)); } if ($model->bookingcustomerid != $model->buyercustomerid) { $model->buyertype = 1; $buyercustomer = Customer::find($model->buyercustomerid); $model->buyercustomeraddress = $buyercustomer->address; $model->buyercustomerprovinceid = $buyercustomer->addprovinceid; $model->buyercustomeramphurid = $buyercustomer->amphurid; $model->buyercustomerdistrictid = $buyercustomer->districtid; $model->buyercustomerzipcode = $buyercustomer->zipcode; $model->buyercustomerphone1 = $buyercustomer->phone1; $model->buyercustomerphone2 = $buyercustomer->phone2; $model->buyercustomeroccupationid = $buyercustomer->occupationid; if ($buyercustomer->birthdate != null && $buyercustomer->birthdate != '') { $model->buyercustomerbirthdate = date('d-m-Y', strtotime($buyercustomer->birthdate)); } } else { $model->buyertype = 0; } $provincebranchs = Province::whereHas('branchs', function ($q) { $q->where('isheadquarter', true); })->orderBy('name', 'asc')->get(['id', 'name']); $provincebranchselectlist = array(); foreach ($provincebranchs as $item) { $provincebranchselectlist[$item->id] = $item->name; } if (Auth::user()->isadmin) { $customers = Customer::orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $customers = Customer::where('provinceid', Auth::user()->provinceid)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $customerselectlist = array(); $customerselectlist[null] = 'เลือกชื่อลูกค้า'; foreach ($customers as $item) { $customerselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } $provinces = Province::orderBy('name', 'asc')->get(['id', 'name']); $provinceselectlist = array(); $provinceselectlist[null] = 'เลือกจังหวัด'; foreach ($provinces as $item) { $provinceselectlist[$item->id] = $item->name; } $bookingcustomeramphurs = Amphur::where('provinceid', $model->bookingcustomerprovinceid)->orderBy('name', 'asc')->get(['id', 'name']); $bookingcustomeramphurselectlist = array(); $bookingcustomeramphurselectlist[null] = 'เลือกเขต/อำเภอ'; foreach ($bookingcustomeramphurs as $item) { $bookingcustomeramphurselectlist[$item->id] = $item->name; } $buyercustomeramphurselectlist = array(); if ($model->bookingcustomerid != $model->buyercustomerid) { $buyercustomeramphurs = Amphur::where('provinceid', $model->buyercustomerprovinceid)->orderBy('name', 'asc')->get(['id', 'name']); $buyercustomeramphurselectlist[null] = 'เลือกเขต/อำเภอ'; foreach ($buyercustomeramphurs as $item) { $buyercustomeramphurselectlist[$item->id] = $item->name; } } $bookingcustomerdistricts = District::where('amphurid', $model->bookingcustomeramphurid)->orderBy('name', 'asc')->get(['id', 'name']); $bookingcustomerdistrictselectlist = array(); $bookingcustomerdistrictselectlist[null] = 'เลือกแขวง/ตำบล'; foreach ($bookingcustomerdistricts as $item) { $bookingcustomerdistrictselectlist[$item->id] = $item->name; } $buyercustomerdistrictselectlist = array(); if ($model->bookingcustomerid != $model->buyercustomerid) { $buyercustomerdistricts = District::where('amphurid', $model->buyercustomeramphurid)->orderBy('name', 'asc')->get(['id', 'name']); $buyercustomerdistrictselectlist[null] = 'เลือกแขวง/ตำบล'; foreach ($buyercustomerdistricts as $item) { $buyercustomerdistrictselectlist[$item->id] = $item->name; } } $occupations = Occupation::orderBy('name', 'asc')->get(['id', 'name']); $occupationselectlist = array(); $occupationselectlist[null] = 'เลือกอาชีพ'; foreach ($occupations as $item) { $occupationselectlist[$item->id] = $item->name; } $carmodels = CarModel::whereHas("carbrand", function ($q) { $q->where('ismain', true); })->orderBy('name', 'asc')->get(['id', 'name']); $carmodelselectlist = array(); $carmodelselectlist[null] = 'เลือกแบบ'; foreach ($carmodels as $item) { $carmodelselectlist[$item->id] = $item->name; } $carsubmodels = CarSubModel::where('carmodelid', $model->carmodelid)->orderBy('name', 'asc')->get(['id', 'name']); $carsubmodelselectlist = array(); $carsubmodelselectlist[null] = 'เลือกรุ่น'; foreach ($carsubmodels as $item) { $carsubmodelselectlist[$item->id] = $item->name; } $colorprices = array(); $colors = Color::with(['carModelColors' => function ($query) use($model) { $query->where('carmodelid', $model->carmodelid); }])->whereHas('carModelColors', function ($q) use($model) { $q->where('carmodelid', $model->carmodelid); })->orderBy('code', 'asc')->get(['id', 'code', 'name']); $colorselectlist = array(); $colorselectlist[null] = 'เลือกสี'; foreach ($colors as $item) { $colorselectlist[$item->id] = $item->code . ' - ' . $item->name; $obj = (object) array("colorid" => $item->id, "price" => $item->carModelColors[0]->price); array_push($colorprices, $obj); } $provinceregistrationfee = array(); $provinces = Province::with(['carModelRegisters' => function ($query) use($model) { $query->where('carmodelid', $model->carmodelid); }])->whereHas('carModelRegisters', function ($q) use($model) { $q->where('carmodelid', $model->carmodelid); })->orderBy('name', 'asc')->get(['id', 'name']); $registerprovinceselectlist = array(); $registerprovinceselectlist[null] = 'เลือกจังหวัด'; foreach ($provinces as $item) { $registerprovinceselectlist[$item->id] = $item->name; $registrationfee = array(); array_push($registrationfee, (object) array("type" => 0, "price" => $item->carModelRegisters[0]->individualregistercost)); array_push($registrationfee, (object) array("type" => 1, "price" => $item->carModelRegisters[0]->companyregistercost)); array_push($registrationfee, (object) array("type" => 2, "price" => $item->carModelRegisters[0]->governmentregistercost)); $obj = (object) array("provinceid" => $item->id, "registrationfee" => $registrationfee); array_push($provinceregistrationfee, $obj); } $oldcarbrands = CarBrand::where('ismain', false)->orderBy('name', 'asc')->get(['id', 'name']); $oldcarbrandselectlist = array(); $oldcarbrandselectlist[null] = 'เลือกยี่ห้อรถ'; foreach ($oldcarbrands as $item) { $oldcarbrandselectlist[$item->id] = $item->name; } $oldcarmodels = CarModel::where('carbrandid', $model->oldcarbrandid)->orderBy('name', 'asc')->get(['id', 'name']); $oldcarmodelselectlist = array(); $oldcarmodelselectlist[null] = 'เลือกแบบ'; foreach ($oldcarmodels as $item) { $oldcarmodelselectlist[$item->id] = $item->name; } if (Auth::user()->isadmin) { $saleemployees = Employee::where('departmentid', 6)->where('teamid', '<>', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $saleemployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 6)->where('teamid', '<>', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $saleemployeeselectlist = array(); $saleemployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($saleemployees as $item) { $saleemployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } if (Auth::user()->isadmin) { $salemanageremployees = Employee::where('departmentid', 6)->where('teamid', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $salemanageremployees = Employee::where('provinceid', Auth::user()->provinceid)->where('departmentid', 6)->where('teamid', 1)->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $salemanageremployeeselectlist = array(); $salemanageremployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($salemanageremployees as $item) { $salemanageremployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } if (Auth::user()->isadmin) { $approveremployees = Employee::where('departmentid', 5)->orWhere(function ($query) { $query->where('departmentid', 6)->where('teamid', 1); })->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } else { $approveremployees = Employee::where('provinceid', Auth::user()->provinceid)->where(function ($query) { $query->where('departmentid', 5)->orWhere(function ($query) { $query->where('departmentid', 6)->where('teamid', 1); }); })->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']); } $approveremployeeselectlist = array(); $approveremployeeselectlist[null] = 'เลือกพนักงาน'; foreach ($approveremployees as $item) { $approveremployeeselectlist[$item->id] = $item->title . ' ' . $item->firstname . ' ' . $item->lastname; } $giveaways = Giveaway::orderBy('name', 'asc')->orderBy('saleprice', 'asc')->get(['id', 'name', 'saleprice']); $giveawayselectlist = array(); array_push($giveawayselectlist, ':เลือกของแถม'); foreach ($giveaways as $ct) { array_push($giveawayselectlist, $ct->id . ':' . $ct->name . ' (' . $ct->saleprice . ' บาท)'); } $giveawayFreeDatas = array(); $giveawayBuyDatas = array(); $giveawayFreeData = SupportRequest::old('giveawayFreeData'); $giveawayBuyData = SupportRequest::old('giveawayBuyData'); if ($giveawayFreeData != null && $giveawayFreeData != '') { $giveawayFreeData = json_decode($giveawayFreeData, true); foreach ($giveawayFreeData as $data) { $obj = (object) array("id" => $data["id"], "giveawayid" => $data["giveawayid"], "price" => $data["price"]); array_push($giveawayFreeDatas, $obj); } } else { $giveawayFrees = CarPreemptionGiveaway::where('free', true)->where('carpreemptionid', $id)->get(['id', 'giveawayid', 'price']); foreach ($giveawayFrees as $data) { $obj = (object) array("id" => $data->id, "giveawayid" => $data->giveawayid, "price" => $data->price); array_push($giveawayFreeDatas, $obj); } } if ($giveawayBuyData != null && $giveawayBuyData != '') { $giveawayBuyData = json_decode($giveawayBuyData, true); foreach ($giveawayBuyData as $data) { $obj = (object) array("id" => $data["id"], "giveawayid" => $data["giveawayid"]); array_push($giveawayBuyDatas, $obj); } } else { $giveawayBuys = CarPreemptionGiveaway::where('free', false)->where('carpreemptionid', $id)->get(['id', 'giveawayid']); foreach ($giveawayBuys as $data) { $obj = (object) array("id" => $data->id, "giveawayid" => $data->giveawayid); array_push($giveawayBuyDatas, $obj); } } $finacecompanies = FinaceCompany::orderBy('name', 'asc')->get(['id', 'name']); $finacecompanyselectlist = array(); $finacecompanyselectlist[null] = 'เลือกบริษัท'; foreach ($finacecompanies as $item) { $finacecompanyselectlist[$item->id] = $item->name; } $interestratetypes = InterestRateType::where('finacecompanyid', $model->finacecompanyid)->orderBy('name', 'asc')->get(['id', 'name']); $interestratetypeselectlist = array(); $interestratetypeselectlist[null] = 'เลือกประเภทอัตราดอกเบี้ย'; foreach ($interestratetypes as $item) { $interestratetypeselectlist[$item->id] = $item->name; } $carprices = array(); $priceselectlist = array(); $pricelists = Pricelist::where('carsubmodelid', $model->carsubmodelid)->where('effectivefrom', '<=', $model->date)->where('effectiveTo', '>=', $model->date)->orderBy('sellingpricewithaccessories', 'asc')->get(['id', 'sellingpricewithaccessories', 'promotion']); foreach ($pricelists as $item) { if ($item->promotion != null && $item->promotion != '') { $priceselectlist[$item->id] = $item->sellingpricewithaccessories . ' (' . $item->promotion . ')'; } else { $priceselectlist[$item->id] = $item->sellingpricewithaccessories; } $obj = (object) array("pricelistid" => $item->id, "price" => $item->sellingpricewithaccessories); array_push($carprices, $obj); } $model->date = date('d-m-Y', strtotime($model->date)); $model->datewantgetcar = date('d-m-Y', strtotime($model->datewantgetcar)); $model->approvaldate = date('d-m-Y', strtotime($model->approvaldate)); if ($model->contractdate != null && $model->contractdate != '') { $model->contractdate = date('d-m-Y', strtotime($model->contractdate)); } return view('carpreemptionform', ['oper' => 'edit', 'pathPrefix' => '../../', 'carpreemption' => $model, 'carprices' => $carprices, 'colorprices' => $colorprices, 'provinceregistrationfee' => $provinceregistrationfee, 'giveawayFreeDatas' => $giveawayFreeDatas, 'giveawayBuyDatas' => $giveawayBuyDatas, 'provincebranchselectlist' => $provincebranchselectlist, 'customerselectlist' => $customerselectlist, 'provinceselectlist' => $provinceselectlist, 'bookingcustomeramphurselectlist' => $bookingcustomeramphurselectlist, 'buyercustomeramphurselectlist' => $buyercustomeramphurselectlist, 'bookingcustomerdistrictselectlist' => $bookingcustomerdistrictselectlist, 'buyercustomerdistrictselectlist' => $buyercustomerdistrictselectlist, 'occupationselectlist' => $occupationselectlist, 'carmodelselectlist' => $carmodelselectlist, 'carsubmodelselectlist' => $carsubmodelselectlist, 'colorselectlist' => $colorselectlist, 'oldcarbrandselectlist' => $oldcarbrandselectlist, 'oldcarmodelselectlist' => $oldcarmodelselectlist, 'giveawayselectlist' => implode(";", $giveawayselectlist), 'saleemployeeselectlist' => $saleemployeeselectlist, 'salemanageremployeeselectlist' => $salemanageremployeeselectlist, 'approveremployeeselectlist' => $approveremployeeselectlist, 'finacecompanyselectlist' => $finacecompanyselectlist, 'interestratetypeselectlist' => $interestratetypeselectlist, 'priceselectlist' => $priceselectlist, 'registerprovinceselectlist' => $registerprovinceselectlist]); }