public function index(){ $data = [ 'auth'=>false, 'recentAdded'=>Customer::orderBy('created_at', 'desc')->take(5)->get() ]; return view('home', $data); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $customers = Customer::orderBy('CUSTCODE', 'ASC')->paginate(15); return view('frontend.customers.index', compact('customers')); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // $this->validate($request, ['area_id' => 'required', 'enrollment_id' => 'required', 'distributor_id' => 'required', 'client_id' => 'required', 'channel_id' => 'required', 'customer_id' => 'required', 'region_id' => 'required', 'agency_id' => 'required', 'store_name' => 'required', 'store_id' => 'required']); // $diff_items = array_diff( $channel_items, $store_items ); // $same_items = array_intersect( $channel_items, $store_items ); // $add_store_items = ChannelItem::select('item_id', // 'item_type_id', // 'ig', // 'fso_multiplier', // 'min_stock', // 'ig_updated', // 'osa_tagged', // 'npi_tagged' ) // ->whereIn('item_id',$diff_items) // ->where('channel_id',$request->channel_id) // ->get(); // foreach ($add_store_items as &$data) { // $data->store_id = $id; // } // $delete = StoreItem::where('store_id',$id)->whereNotIn('item_id',$same_items)->delete(); // foreach ($add_store_items as $data) { // $check[] = StoreItem::firstOrCreate([ // 'store_id' => $data->store_id, // 'item_id' => $data->item_id, // 'item_type_id' => $data->item_type_id, // 'ig' => $data->ig, // 'fso_multiplier' => $data->fso_multiplier, // 'min_stock' => $data->min_stock, // 'ig_updated' => $data->ig_updated, // 'osa_tagged' => $data->npi_tagged ]); // } $store = Store::findOrFail($id); //for mkl $mkl_store_items = StoreItem::where('store_id', $id)->where('item_type_id', 1)->get()->pluck('item_id')->toArray(); //get all the item from store mkl $mkl_channel_items = ChannelItem::where('channel_id', $request->channel_id)->where('item_type_id', 1)->get()->pluck('item_id')->toArray(); //for assortment $assortment_store_items = StoreItem::where('store_id', $id)->where('item_type_id', 2)->get()->pluck('item_id')->toArray(); //get all the item from store assortment $assortment_channel_items = ChannelItem::where('channel_id', $request->channel_id)->where('item_type_id', 2)->get()->pluck('item_id')->toArray(); //for mkl foreach ($mkl_store_items as $value) { if (!in_array($value, $mkl_channel_items)) { $delete = StoreItem::where('store_id', $id)->where('item_type_id', 1)->where('item_id', $value)->delete(); } } $mkl_remaining_items = StoreItem::where('store_id', $id)->where('item_type_id', 1)->get()->pluck('item_id')->toArray(); foreach ($mkl_channel_items as $value) { if (!in_array($value, $mkl_remaining_items)) { $data = ChannelItem::where('item_id', $value)->where('channel_id', $request->channel_id)->where('item_type_id', 1)->first(); StoreItem::firstOrCreate(['store_id' => $id, 'item_id' => $data->item_id, 'item_type_id' => $data->item_type_id, 'ig' => $data->ig, 'fso_multiplier' => $data->fso_multiplier, 'min_stock' => $data->min_stock, 'ig_updated' => $data->ig_updated, 'osa_tagged' => $data->npi_tagged]); } } //for assortment foreach ($assortment_store_items as $value) { if (!in_array($value, $assortment_channel_items)) { $delete = StoreItem::where('store_id', $id)->where('item_type_id', 2)->where('item_id', $value)->delete(); } } $assortment_remaining_items = StoreItem::where('store_id', $id)->where('item_type_id', 2)->get()->pluck('item_id')->toArray(); foreach ($assortment_channel_items as $value) { if (!in_array($value, $assortment_remaining_items)) { $data = ChannelItem::where('item_id', $value)->where('channel_id', $request->channel_id)->where('item_type_id', 2)->first(); $w_mkl = StoreItem::where('store_id', $id)->where('item_id', $value)->get(); if (count($w_mkl) == 0) { StoreItem::firstOrCreate(['store_id' => $id, 'item_id' => $data->item_id, 'item_type_id' => $data->item_type_id, 'ig' => $data->ig, 'fso_multiplier' => $data->fso_multiplier, 'min_stock' => $data->min_stock, 'ig_updated' => $data->ig_updated, 'osa_tagged' => $data->npi_tagged]); } } } //end $store->area_id = $request->area_id; $store->enrollment_id = $request->enrollment_id; $store->distributor_id = $request->distributor_id; $store->client_id = $request->client_id; $store->channel_id = $request->channel_id; $store->customer_id = $request->customer_id; $store->region_id = $request->region_id; $store->agency_id = $request->agency_id; $store->store_name = $request->store_name; $store->storeid = $request->store_id; $store->store_code = $request->store_code; $store->store_code_psup = $request->store_code_psup; $store->active = $request->status; $store->update(); \DB::table('store_users')->where('user_id', $request->userid)->where('store_id', $id)->update(['user_id' => $request->user_id]); $store = Store::findOrFail($id); $area = Area::orderBy('area', 'ASC')->lists('area', 'id'); $enrollment = Enrollment::orderBy('enrollment', 'ASC')->lists('enrollment', 'id'); $distributor = Distributor::orderBy('distributor', 'ASC')->lists('distributor', 'id'); $client = Client::orderBy('client_name', 'ASC')->lists('client_name', 'id'); $channel = channel::orderBY('channel_desc', 'ASC')->lists('channel_desc', 'id'); $customer = Customer::orderBy('customer_name', 'ASC')->lists('customer_name', 'id'); $region = Region::orderBy('region_short', 'ASC')->lists('region_short', 'id'); $agency = Agency::orderBy('agency_name', 'ASC')->lists('agency_name', 'id'); $status = ['0' => 'In-active', '1' => 'Active']; $user = StoreUser::where('store_id', $id)->first(); $alluser = User::all()->lists('username', 'id'); $hash = UpdateHash::find(1); if (empty($hash)) { UpdateHash::create(['hash' => \Hash::make(date('Y-m-d H:i:s'))]); } else { $hash->hash = md5(date('Y-m-d H:i:s')); $hash->update(); } Session::flash('flash_class', 'alert-success'); Session::flash('flash_message', 'Store successfully updated.'); return view('store.edit', ['store' => $store, 'area' => $area, 'enrollment' => $enrollment, 'distributor' => $distributor, 'client' => $client, 'channel' => $channel, 'customer' => $customer, 'region' => $region, 'agency' => $agency, 'status' => $status, 'user' => $user, 'alluser' => $alluser]); }
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]); }