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