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]);
}
