public function upload()
{
$error = false;
$uploaddir = base_path() . '/uploads/images/';
$engineno = Input::get('engineno');
$car = Car::where('engineno', $engineno)->first();
if (Input::hasFile('receivecarfile') && Input::file('receivecarfile')->isValid()) {
$extension = Input::file('receivecarfile')->getClientOriginalExtension();
$fileName = $engineno . '_received' . '.' . $extension;
$upload_success = Input::file('receivecarfile')->move($uploaddir, $fileName);
if ($upload_success) {
$car->receivecarfilepath = '/uploads/images/' . $fileName;
} else {
$error = true;
}
}
if (Input::hasFile('deliverycarfile') && Input::file('deliverycarfile')->isValid()) {
$extension = Input::file('deliverycarfile')->getClientOriginalExtension();
$fileName = $engineno . '_delivered' . '.' . $extension;
$upload_success = Input::file('deliverycarfile')->move($uploaddir, $fileName);
if ($upload_success) {
$car->deliverycarfilepath = '/uploads/images/' . $fileName;
} else {
$error = true;
}
}
$car->save();
$data = $error ? array('error' => 'เกิดข้อผิดพลาดในการอัพโหลดไฟล์') : array('success' => 'อัพโหลดไฟล์สำเร็จ');
echo json_encode($data);
}
public function check_keyslot(Request $request)
{
$input = $request->only('provinceid', 'keyslot');
$maxKeyNo = Car::where('provinceid', $input['provinceid'])->where('issold', false)->max('keyno');
if ($maxKeyNo != null && $input['keyslot'] < $maxKeyNo) {
return "true";
}
}
public function index()
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$provinces = Province::whereHas('branchs', function ($q) {
$q->where('isheadquarter', true);
})->orderBy('name', 'asc')->get(['id', 'name']);
$provinceselectlist = array();
array_push($provinceselectlist, ':เลือกจังหวัด');
foreach ($provinces as $item) {
array_push($provinceselectlist, $item->id . ':' . $item->name);
}
if (Auth::user()->isadmin) {
$customers = Customer::has('redLabels')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
} else {
$customers = Customer::where('provinceid', Auth::user()->provinceid)->has('redLabels')->orderBy('firstname', 'asc')->orderBy('lastname', 'asc')->get(['id', 'title', 'firstname', 'lastname']);
}
$customerselectlist = array();
foreach ($customers as $item) {
array_push($customerselectlist, $item->id . ':' . $item->title . ' ' . $item->firstname . ' ' . $item->lastname);
}
if (Auth::user()->isadmin) {
$cars = Car::has('redLabel')->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
} else {
$cars = Car::where('provinceid', Auth::user()->provinceid)->has('redLabel')->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
}
$carselectlist = array();
array_push($carselectlist, ':เลือกรถ');
foreach ($cars as $item) {
array_push($carselectlist, $item->id . ':' . $item->chassisno . '/' . $item->engineno);
}
if (Auth::user()->isadmin) {
$carpreemptions = CarPreemption::has('redlabelhistories')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']);
} else {
$carpreemptions = CarPreemption::where('provinceid', Auth::user()->provinceid)->has('redlabelhistories')->orderBy('bookno', 'asc')->orderBy('no', 'asc')->get(['id', 'bookno', 'no', 'buyercustomerid', 'salesmanemployeeid']);
}
$carpreemptionselectlist = array();
array_push($carpreemptionselectlist, ':เลือกการจอง');
foreach ($carpreemptions as $item) {
$buyercustomer = Customer::find($item->buyercustomerid);
$buyercustomername = $buyercustomer->title . ' ' . $buyercustomer->firstname . ' ' . $buyercustomer->lastname;
$salesmanemployee = Employee::find($item->salesmanemployeeid);
$salesmanemployeename = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname;
array_push($carpreemptionselectlist, $item->id . ':' . str_pad($item->bookno . '/' . $item->no, strlen($item->bookno . '/' . $item->no) + 15, " ") . str_pad($buyercustomername, strlen($buyercustomername) + 15, " ") . $salesmanemployeename);
}
$defaultProvince = '';
if (Auth::user()->isadmin == false) {
$defaultProvince = Auth::user()->provinceid;
}
return view('redlabel', ['provinceselectlist' => implode(";", $provinceselectlist), 'customerselectlist' => implode(";", $customerselectlist), 'carselectlist' => implode(";", $carselectlist), 'carpreemptionselectlist' => implode(";", $carpreemptionselectlist), 'defaultProvince' => $defaultProvince]);
}
public function getCarinfo()
{
$user = Auth::user();
$attributes = Attribute::where('spec', '=', 'file_upload')
->where('active', '=', 1)
->get();
$carSet = Car::where('uid', '=', $user->id)
->where('active', '=', 1)
->orderBy('last_used', 'desc')
->orderBy('created_at', 'desc')
->get();
$cars = array();
foreach ($carSet as $car) {
array_push($cars, $car);
}
$data = [
'car_hand' => 'one',
'good_attribs' => $attributes,
'cars' => $cars,
'carActive' => true,
'profile' => true,
'wTitle' => '个人中心 － 车辆信息'
];
return view('profile/carInfo', $data);
}
public function edit($id)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$model = CarPayment::find($id);
if (!Auth::user()->isadmin && $model->deliverycarbookno != null && $model->deliverycarbookno != '') {
return "ไม่สามารถแก้ไขข้อมูลการชำระเงินได้ เนื่องจากมีการส่งรถแล้ว!!";
}
$carpreemption = CarPreemption::find($model->carpreemptionid);
$carpreemptionselectlist = array();
$carpreemptionselectlist[$carpreemption->id] = $carpreemption->bookno . '/' . $carpreemption->no;
$model->bookno = $carpreemption->bookno;
$model->no = $carpreemption->no;
$model->purchasetype = $carpreemption->purchasetype;
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;
}
$customer = Customer::find($carpreemption->buyercustomerid);
$model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$model->customer2 = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$carmodel = CarModel::find($carpreemption->carmodelid);
$carsubmodel = CarSubModel::find($carpreemption->carsubmodelid);
$model->carmodel = $carmodel->name . '/' . $carsubmodel->name;
$color = Color::find($carpreemption->colorid);
$model->carcolor = $color->code . ' - ' . $color->name;
$pricelist = Pricelist::find($carpreemption->pricelistid);
$model->carprice = $pricelist->sellingpricewithaccessories + $carpreemption->colorprice;
$carselectlist = array();
$carselectlist[null] = 'เลือกรถ';
if (Auth::user()->isadmin) {
$cars = Car::doesntHave('carPayment')->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orWhere(function ($query) use($model) {
$query->where('id', $model->carid);
})->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
} else {
$cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('carmodelid', $carpreemption->carmodelid)->where('carsubmodelid', $carpreemption->carsubmodelid)->where('colorid', $carpreemption->colorid)->orWhere(function ($query) use($model) {
$query->where('id', $model->carid);
})->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
}
foreach ($cars as $item) {
$carselectlist[$item->id] = $item->chassisno . '/' . $item->engineno;
}
$model->installments = $carpreemption->installments;
$model->interest = $carpreemption->interest;
if ($carpreemption->purchasetype == 1) {
$finacecompany = FinaceCompany::find($carpreemption->finacecompanyid);
$model->finacecompany = $finacecompany->name;
}
if ($carpreemption->purchasetype == 0) {
$model->down = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
$model->yodjud = number_format(0, 2, '.', '');
$model->yodjudwithinsurancepremium = number_format(0, 2, '.', '');
if ($model->overrideopenbill != null && $model->overrideopenbill != '') {
$model->openbill = $model->overrideopenbill;
} else {
$model->openbill = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
}
$model->realprice = number_format($model->carprice - $carpreemption->discount, 2, '.', '');
$model->payinadvanceamount = number_format(0, 2, '.', '');
} else {
$model->down = $carpreemption->down;
$model->yodjud = number_format($model->carprice - $carpreemption->discount - $model->down + $carpreemption->accessories + $model->accessoriesfeeincludeinyodjud, 2, '.', '');
$model->yodjudwithinsurancepremium = number_format($model->yodjud + $model->insurancepremium, 2, '.', '');
$model->openbill = number_format($model->yodjud + $model->down, 2, '.', '');
$model->realprice = number_format($model->carprice - $carpreemption->discount - $carpreemption->subdown, 2, '.', '');
if ($model->firstinstallmentpay) {
$model->firstinstallmentpayamount = number_format($model->amountperinstallment, 2, '.', '');
} else {
$model->firstinstallmentpayamount = number_format(0, 2, '.', '');
}
$model->payinadvanceamount = number_format($model->installmentsinadvance * $model->amountperinstallment, 2, '.', '');
if ($carpreemption->subsidisefree) {
$model->subsidise = number_format(0, 2, '.', '');
} else {
$model->subsidise = $carpreemption->subsidise;
}
}
$model->accessoriesfee = $carpreemption->accessoriesfee;
$insurancecompanies = InsuranceCompany::orderBy('name', 'asc')->get(['id', 'name']);
$insurancecompanyselectlist = array();
$insurancecompanyselectlist[null] = 'เลือกบริษัท';
foreach ($insurancecompanies as $item) {
$insurancecompanyselectlist[$item->id] = $item->name;
}
if ($carpreemption->insurancefeefree) {
$model->insurancefee = number_format(0, 2, '.', '');
} else {
$model->insurancefee = $carpreemption->insurancefee;
}
if ($carpreemption->compulsorymotorinsurancefeefree) {
$model->compulsorymotorinsurancefee = number_format(0, 2, '.', '');
} else {
$model->compulsorymotorinsurancefee = $carpreemption->compulsorymotorinsurancefee;
}
if ($carpreemption->carobjectivetype == 0) {
$registerprovince = Province::find($carpreemption->registerprovinceid);
$model->registerprovince = $registerprovince->name;
} else {
$model->registerprovince = null;
}
$model->registrationtype = $carpreemption->registrationtype;
if ($carpreemption->registrationfeefree) {
$model->registrationfee = number_format(0, 2, '.', '');
} else {
$model->registrationfee = $carpreemption->registrationfee;
}
if ($carpreemption->carobjectivetype == 0) {
$redlabelhistory = Redlabelhistory::where('carpreemptionid', $carpreemption->id)->first();
if ($redlabelhistory != null) {
$redlabel = Redlabel::find($redlabelhistory->redlabelid);
$model->redlabel = $redlabel->no;
} else {
$model->redlabel = "ไม่มีป้าย";
}
} else {
$model->redlabel = null;
}
$model->cashpledgeredlabel = $carpreemption->cashpledgeredlabel;
if ($carpreemption->implementfeefree) {
$model->implementfee = number_format(0, 2, '.', '');
} else {
$model->implementfee = $carpreemption->implementfee;
}
$model->giveawaywithholdingtax = $carpreemption->giveawaywithholdingtax;
$model->otherfee = $carpreemption->otherfee;
$model->otherfeedetail = $carpreemption->otherfeedetail;
$model->otherfee2 = $carpreemption->otherfee2;
$model->otherfeedetail2 = $carpreemption->otherfeedetail2;
$model->otherfee3 = $carpreemption->otherfee3;
$model->otherfeedetail3 = $carpreemption->otherfeedetail3;
if ($model->firstinstallmentpay) {
$model->total = number_format($model->down + $model->amountperinstallment + $model->payinadvanceamount + $model->accessoriesfeeactuallypaid + $model->insurancefee + $model->compulsorymotorinsurancefee + $model->registrationfee + $model->cashpledgeredlabel + $model->implementfee + $model->giveawaywithholdingtax + $model->otherfee + $model->otherfee2 + $model->otherfee3, 2, '.', '');
} else {
$model->total = number_format($model->down + $model->payinadvanceamount + $model->accessoriesfeeactuallypaid + $model->insurancefee + $model->compulsorymotorinsurancefee + $model->registrationfee + $model->cashpledgeredlabel + $model->implementfee + $model->giveawaywithholdingtax + $model->otherfee + $model->otherfee2 + $model->otherfee3, 2, '.', '');
}
$model->subdown = $carpreemption->subdown;
$model->cashpledge = $carpreemption->cashpledge;
$model->oldcarprice = $carpreemption->oldcarprice;
$model->totalpayments = number_format($model->total - $model->subdown - $model->cashpledge - $model->oldcarprice, 2, '.', '');
$salesmanemployee = Employee::find($carpreemption->salesmanemployeeid);
$model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname;
$approversemployee = Employee::find($carpreemption->approversemployeeid);
$model->approversemployee = $approversemployee->title . ' ' . $approversemployee->firstname . ' ' . $approversemployee->lastname;
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;
}
$model->date = date('d-m-Y', strtotime($model->date));
if ($model->overdueinstallmentdate1 != null && $model->overdueinstallmentdate1 != '') {
$model->overdueinstallmentdate1 = date('d-m-Y', strtotime($model->overdueinstallmentdate1));
}
if ($model->overdueinstallmentdate2 != null && $model->overdueinstallmentdate2 != '') {
$model->overdueinstallmentdate2 = date('d-m-Y', strtotime($model->overdueinstallmentdate2));
}
if ($model->overdueinstallmentdate3 != null && $model->overdueinstallmentdate3 != '') {
$model->overdueinstallmentdate3 = date('d-m-Y', strtotime($model->overdueinstallmentdate3));
}
if ($model->overdueinstallmentdate4 != null && $model->overdueinstallmentdate4 != '') {
$model->overdueinstallmentdate4 = date('d-m-Y', strtotime($model->overdueinstallmentdate4));
}
if ($model->overdueinstallmentdate5 != null && $model->overdueinstallmentdate5 != '') {
$model->overdueinstallmentdate5 = date('d-m-Y', strtotime($model->overdueinstallmentdate5));
}
if ($model->overdueinstallmentdate6 != null && $model->overdueinstallmentdate6 != '') {
$model->overdueinstallmentdate6 = date('d-m-Y', strtotime($model->overdueinstallmentdate6));
}
if ($model->oldcarpaydate != null && $model->oldcarpaydate != '') {
$model->oldcarpaydate = date('d-m-Y', strtotime($model->oldcarpaydate));
}
if ($model->deliverycardate != null && $model->deliverycardate != '') {
$model->deliverycardate = date('d-m-Y', strtotime($model->deliverycardate));
}
return view('carpaymentform', ['oper' => 'edit', 'pathPrefix' => '../../', 'carpayment' => $model, 'carpreemptionselectlist' => $carpreemptionselectlist, 'carselectlist' => $carselectlist, 'insurancecompanyselectlist' => $insurancecompanyselectlist, 'payeeemployeeselectlist' => $payeeemployeeselectlist, 'purchasetype0' => $purchasetype0, 'purchasetype1' => $purchasetype1, 'carobjectivetype0' => $carobjectivetype0, 'carobjectivetype1' => $carobjectivetype1, 'registrationtype0' => $registrationtype0, 'registrationtype1' => $registrationtype1, 'registrationtype2' => $registrationtype2]);
}
public function postPay(Request $request)
{
/*
* 防止表单重复提交
*
* Session 存入表单令牌
*/
if (Session::get('order_submit') == $request->input('form_code')) {
$mb = $request->input('mb');
if (empty($mb) || $mb == 'false') {
return redirect('/order/pay?order=' . Session::get('order_code'));
} else {
}
} else {
Session::put('order_submit', $request->input('form_code'));
}
$user = Auth::user();
$carHand = $request->input('car_hand');
$required = null;
if ($carHand == 'one') {
$required = array (
'good' => 'required',
'num' => 'required|min:1',
'car' => 'required',
'receiver' => 'required'
);
} elseif ($carHand == 'second') {
$required = array (
'good' => 'required',
'num' => 'required|min:1',
'receiver' => 'required'
);
}
$validate = Validator::make($request->input(), $required);
if ($validate->fails()) {
$failed = $validate->failed();
return redirect()->back();
}
//获取输入参数
$params = $request->input();
//获取商品价格
$gprice = GoodAttribsInfo::where('gid', '=', $params['good'])
->where('acode', '=', 'price')
->first();
//订单
$newOrder = [
'code' => $this->generateOrderCode($user->id),
'uid' => $user->id,
'rid' => $params['receiver'],
'cid' => $params['car'],
'gid' => $params['good'],
'num' => $params['num'],
'sum' => $gprice->value * $params['num'],
'comment' => empty($params['comment']) ? null : $params['comment'],
'status' => 0,
'active' => 1
];
//新建订单:
$order = Order::create($newOrder);
//记录用户选择的车型
$car = Car::where('uid', '=', $user->id)
->where('last_used', '=', 1)
->where('active', '=', 1)
->first();
if (!empty($car->id) && ($car->id != $params['car'])) {
$car->last_used = 0;
$car->save();
}
Car::where('id', '=', $params['car'])
->where('active', '=', 1)
->update(['last_used' => 1]);
//记录用户选择的收货地址
$receiver = ReceiverInfo::where('uid', '=', $user->id)
->where('last_used', '=', 1)
->where('active', '=', 1)
->first();
if (!empty($receiver->id) && ($receiver->id != $params['receiver'])) {
$receiver->last_used = 0;
$receiver->save();
}
ReceiverInfo::where('id', '=', $params['receiver'])
->where('active', '=', 1)
->update(['last_used' => 1]);
Session::put('order_code', $order->code);
//检测优惠券是否可用
$note = $this->measureDiscount($params);
$reduction = $note['reduction'];
//订单最终价格
$extraFee = 0;
$orderPrices = [
'oid' => $order->id,
'orig_price' => $order->sum,
'cut_fee' => $reduction,
'extra_fee' => $extraFee,
'final_price' => ($order->sum - $reduction + $extraFee),
'active' => 1
];
$op = OrderPrice::create($orderPrices);
//记录优惠券使用信息
foreach ($note['availableBouns'] as $boun) {
$bobj = Boun::where('code', '=', $boun)
->where('active', '=', 1)
->first();
if (!empty($bobj)) {
OrderBoun::create([
'oid' => $order->id,
'uid' => $user->id,
'bcode' => $boun,
'btype' => $bobj->type,
'rewarded' => 0,
'success' => 0,
'owner_id' => $bobj->uid
]);
}
}
$good = Good::where('id', '=', $order->gid)->first();
$receiver = ReceiverInfo::where('id', '=', $order->rid)->first();
$pay_token = md5($order->id . time());
$banks = Bank::all();
$data = [
'reduction' => $reduction,
'order' => $order,
'orderPrice' => $op,
'note' => $note,
'good' => $good,
'receiver' => $receiver,
'pay_token' => $pay_token,
'banks' => $banks,
'is_pay' => true,
'wTitle' => '订单支付'
];
$mb = $request->input('mb');
if ($mb === 'true') {
$car = Car::where('id', '=', $order->cid)->first();
$data['car'] = $car;
$data['step'] = 3;
$data['header'] = '订单支付';
return view('mobile/minipay', $data);
} else {
return view('orders/pay', $data);
}
}
public function check_keyslot(Request $request)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$input = $request->only('provinceid', 'keyslot');
$maxKeyNo = Car::where('provinceid', $input['provinceid'])->where('issold', false)->max('keyno');
if ($maxKeyNo != null && $input['keyslot'] < $maxKeyNo) {
return "true";
}
}
public function upload()
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$error = false;
if (Input::hasFile('receivecarfile') && Input::file('receivecarfile')->isValid()) {
$error = true;
$uploaddir = base_path() . '/uploads/images/';
$engineno = Input::get('engineno');
$chassisno = Input::get('chassisno');
$car = Car::where('engineno', $engineno)->where('chassisno', $chassisno)->first();
$extension = Input::file('receivecarfile')->getClientOriginalExtension();
$fileName = $engineno . '_' . $chassisno . '_received' . '.' . $extension;
$upload_success = Input::file('receivecarfile')->move($uploaddir, $fileName);
if ($upload_success) {
$car->receivecarfilepath = '/uploads/images/' . $fileName;
$car->save();
$error = false;
}
}
$data = $error ? array('error' => 'เกิดข้อผิดพลาดในการอัพโหลดไฟล์') : array('success' => 'อัพโหลดไฟล์สำเร็จ');
echo json_encode($data);
}
public function getbyid($id)
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$model = CarPreemption::find($id);
$customer = Customer::find($model->buyercustomerid);
$model->customer = $customer->title . ' ' . $customer->firstname . ' ' . $customer->lastname;
$carmodel = CarModel::find($model->carmodelid);
$carsubmodel = CarSubModel::find($model->carsubmodelid);
$model->carmodel = $carmodel->name . '/' . $carsubmodel->name;
$color = Color::find($model->colorid);
$model->carcolor = $color->code . ' - ' . $color->name;
$pricelist = Pricelist::find($model->pricelistid);
$model->carprice = $pricelist->sellingpricewithaccessories + $model->colorprice;
if (Auth::user()->isadmin) {
if ($model->carobjectivetype == 0) {
$cars = Car::doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
} else {
$cars = Car::doesntHave('carPayment')->where('objective', '!=', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
}
} else {
if ($model->carobjectivetype == 0) {
$cars = Car::where('provinceid', Auth::user()->provinceid)->doesntHave('carPayment')->where('objective', 0)->where('carmodelid', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->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', $model->carmodelid)->where('carsubmodelid', $model->carsubmodelid)->where('colorid', $model->colorid)->orderBy('chassisno', 'asc')->orderBy('engineno', 'asc')->get(['id', 'chassisno', 'engineno']);
}
}
$model->cars = $cars;
if ($model->finacecompanyid != null && $model->finacecompanyid != '') {
$finacecompany = FinaceCompany::find($model->finacecompanyid);
$model->finacecompany = $finacecompany->name;
}
if ($model->interestratetypeid != null && $model->interestratetypeid != '') {
$interestratetype = InterestRateType::find($model->interestratetypeid);
$model->interestratetype = $interestratetype->name;
}
if ($model->purchasetype == 0) {
$model->yodjud = 0;
$model->realprice = $model->carprice - $model->discount;
} else {
$model->yodjud = $model->carprice - $model->discount - $model->down + $model->accessories;
$model->realprice = $model->carprice - $model->discount - $model->subdown;
}
$salesmanemployee = Employee::find($model->salesmanemployeeid);
$model->salesmanemployee = $salesmanemployee->title . ' ' . $salesmanemployee->firstname . ' ' . $salesmanemployee->lastname;
$approversemployee = Employee::find($model->approversemployeeid);
$model->approversemployee = $approversemployee->title . ' ' . $approversemployee->firstname . ' ' . $approversemployee->lastname;
if ($model->carobjectivetype == 0) {
$registerprovince = Province::find($model->registerprovinceid);
$model->registerprovince = $registerprovince->name;
$redlabelhistory = Redlabelhistory::where('carpreemptionid', $id)->first();
if ($redlabelhistory != null) {
$redlabel = Redlabel::find($redlabelhistory->redlabelid);
$model->redlabel = $redlabel->no;
} else {
$model->redlabel = "ไม่มีป้าย";
}
} else {
$model->redlabel = null;
}
//if($cust->birthdate != null)
//$cust->birthdate = date('d-m-Y', strtotime($cust->birthdate));
return $model;
}
public function getBuy(Request $request)
{
$gcode = $request->input('gcode');
$ch = $request->input('car_hand');
if (empty($ch) || strlen($ch) == 0) {
return redirect('/miniorder/cartype');
}
$user = Auth::user();
$gcode = (empty($gcode) || strlen($gcode) == 0) ? 'beyond-three' : $gcode;
$good = Good::where('code', '=', $gcode)->first();
if (empty($good)) {
//todo
}
$carhand = $ch == 1 ? 'one' : 'second';
$cars = Car::where('uid', '=', $user->id)->where('car_hand', '=', $carhand)->orderBy('last_used', 'desc')->get();
$defaultCar = Car::where('uid', '=', $user->id)->where('car_hand', '=', $carhand)->where('last_used', '=', 1)->first();
$receivers = Receiver::where('uid', '=', $user->id)->orderBy('last_used', 'desc')->get();
$defaultReceiver = Receiver::where('uid', '=', $user->id)->where('last_used', '=', 1)->first();
$bouns = Boun::where('uid', '=', $user->id)
->where('type', '=', 1)
->where('active', '=', 1)
->get();
$goodInfo = GoodAttribsInfo::where('gid', '=', $good->id)->where('acode', '=', 'price')->first();
$data = [
'good' => $good,
'receivers' => $receivers,
'defaultReceiver' => $defaultReceiver,
'cars' => $cars,
'defaultCar' => $defaultCar,
'bouns' => $bouns,
'goodInfo' => $goodInfo,
'formCode' => md5(time()),
'car_hand' => $carhand,
'step' => 2,
'header' => '确认订单'
];
return view('mobile/pay', $data);
}
public function getCarinfo (Request $request)
{
$cid = $request->input('oid');
$car = Car::where('id', '=', $cid)
->where('active', '=', 1)
->first();
if (empty($car->id)) {
return $this->failResponse();
} else {
return $this->successResponse('car', $car);
}
}
