public function run() { $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/Secondary Display.xlsx"; echo (string) $file_path, "\n"; Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('secondary_display_lookups')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = $file_path; $reader->open($filePath); // Accessing the sheet name when reading foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Sheet1') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($cnt > 0) { // dd($row); $store = Store::where('store_code', trim($row[1]))->first(); $brands = array(); if (!empty($store)) { $x = 1; for ($i = 3; $i < 29; $i++) { if ($row[$i] == "1.0") { $brands[] = $x; } $x++; } foreach ($brands as $value) { SecondaryDisplayLookup::create(['store_id' => $store->id, 'secondary_display_id' => $value]); } } } $cnt++; } } else { } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function run() { $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/Store SOS.xlsx"; echo (string) $file_path, "\n"; Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('store_sos_tags')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = $file_path; $reader->open($filePath); // Accessing the sheet name when reading foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Sheet1') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if (!empty($row[0])) { // dd($row); if ($cnt > 0) { // dd($row); $store = Store::where('store_code', $row[0])->first(); // dd($store); $category = FormCategory::where('category', strtoupper($row[2]))->first(); // dd($category); $sos = SosTagging::where('sos_tag', strtoupper($row[3]))->first(); // dd($sos); StoreSosTag::insert(array('store_id' => $store->id, 'form_category_id' => $category->id, 'sos_tag_id' => $sos->id)); // echo (string)$row[0], "\n"; } $cnt++; } } } else { } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('users')->truncate(); DB::table('store_user')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = 'database/seeds/seed_files/User.xlsx'; $reader->open($filePath); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'File') { $rowcnt = 0; $errorCnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($rowcnt > 0) { if (!is_null($row[0])) { $user = User::where('email', strtolower($row[19]) . '@unilever.com')->first(); if (count($user) == 0) { $user = User::firstOrCreate(['name' => strtoupper($row[18]), 'email' => strtolower($row[19]) . '@unilever.com', 'username' => $row[19], 'password' => Hash::make('password')]); } $store = Store::where('store_code', $row[5])->first(); if (!empty($store)) { $store->users()->attach($user->id); } else { $errorCnt++; } } } $rowcnt++; } } } $reader->close(); echo $errorCnt; DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('store_sku')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = 'database/seeds/seed_files/SKU Mapping.xlsx'; $reader->open($filePath); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Sheet1') { $rowcnt = 0; $errorCnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($rowcnt > 0) { if (!is_null($row[0])) { $premise = Premise::where('premise_code', $row[0])->first(); if (!empty($premise)) { $stores = Store::where('premise_id', $premise->id)->get(); $sku = Sku::where('sku_code', $row[3])->first(); if (!empty($stores) && !empty($sku)) { foreach ($stores as $store) { $store->skus()->attach($sku, array('ig' => $sku->conversion + 20)); } } } } } $rowcnt++; } } } $reader->close(); echo $errorCnt; DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function run() { $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/OSA Target.xlsx"; echo (string) $file_path, "\n"; Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('osa_lookups')->truncate(); DB::table('osa_lookup_targets')->truncate(); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $filePath = $file_path; $reader->open($filePath); // Accessing the sheet name when reading foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Sheet1') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if (!is_null($row[0])) { if ($cnt > 0) { // dd($row); $customer_id = 0; $customer = Customer::where('customer_code', $row[0])->first(); if (!empty($customer)) { $customer_id = $customer->id; } $region_id = 0; $region = Region::where('region_code', $row[1])->first(); if (!empty($region)) { $region_id = $region->id; } $distributor_id = 0; $distributor = Distributor::where('distributor_code', $row[2])->first(); if (!empty($distributor)) { $distributor_id = $distributor->id; } $store_id = 0; $store = Store::where('store_code', $row[3])->first(); if (!empty($store)) { $store_id = $store->id; } $template_id = 0; $template = AuditTemplate::where('template_code', $row[4])->first(); if (!empty($template)) { $template_id = $template->id; } $category = FormCategory::where('category', $row[5])->first(); if (!empty($category)) { $osalookup_id = 0; $osalookup = OsaLookup::where('customer_id', $customer_id)->where('region_id', $region_id)->where('distributor_id', $distributor_id)->where('store_id', $store_id)->where('template_id', $template_id)->first(); if (empty($osalookup)) { $osalookup = new OsaLookup(); $osalookup->customer_id = $customer_id; $osalookup->region_id = $region_id; $osalookup->distributor_id = $distributor_id; $osalookup->store_id = $store_id; $osalookup->template_id = $template_id; $osalookup->save(); } $osalookup_id = $osalookup->id; OsaLookupTarget::create(array('osa_lookup_id' => $osalookup_id, 'category_id' => $category->id, 'target' => $row[8], 'total' => $row[9])); } } $cnt++; } } } else { } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function redeemCoupon(request $request) { $rules = array('client_id' => 'required', 'client_secret' => 'required', 'code' => 'required', 'mobile' => 'required|size:10', 'email' => 'required|email|max:255'); $validator = $this->customValidator($request->all(), $rules, array()); if ($validator->fails()) { return response()->json(['response_code' => 'ERR_RULES', 'message' => $validator->errors()->all()], 400); } $auth = $request->only('client_id', 'client_secret'); $server = ['client_id' => Config::get('custom.client_id'), 'client_secret' => Config::get('custom.client_secret')]; if ($server['client_id'] != $auth['client_id'] || $server['client_secret'] != $auth['client_secret']) { return response()->json(['response_code' => 'ERR_IAC', 'messages' => 'Invalid Api credentials'], 403); } $code = $request->only('code'); $matchThese = ['code' => $code['code'], 'is_active' => true]; $store = Store::where($matchThese)->first(); if ($store == '' || empty($store)) { return response()->json(['response_code' => 'ERR_CCNV', 'message' => 'Coupon Code Not valid'], 409); } if ($this->userExists($request->only('email'))) { return response()->json(['response_code' => 'ERR_UAUC', 'message' => 'User Already Used Coupon'], 409); } $input = $request->only('name', 'email', 'mobile'); $input['store_id'] = $store->id; $customer = Customer::create($input); $data['timer'] = $store->timer; $data['offer_image'] = URL::to('/assets/img/stores/') . $store->offer_image; return response()->json(['response_code' => 'RES_CRS', 'message' => 'Coupon Redeemed successfully', 'data' => $data]); }
public function stores() { $accounts = Account::all(); $data = array(); foreach ($accounts as $account) { $customers = Customer::where('account_id', $account->id)->get(); $account_children = array(); foreach ($customers as $customer) { $areas = Area::where('customer_id', $customer->id)->get(); $customer_children = array(); foreach ($areas as $area) { $regions = Region::where('area_id', $area->id)->get(); $area_children = array(); foreach ($regions as $region) { $distributors = Distributor::where('region_id', $region->id)->get(); $region_children = array(); foreach ($distributors as $distributor) { $stores = Store::where('distributor_id', $distributor->id)->get(); $distributor_children = array(); foreach ($stores as $store) { $distributor_children[] = array('title' => $store->store, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id . "." . $distributor->id . "." . $store->id); } $region_children[] = array('select' => true, 'title' => $distributor->distributor, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id . "." . $distributor->id, 'children' => $distributor_children); } $area_children[] = array('select' => true, 'title' => $region->region, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id . "." . $region->id, 'children' => $region_children); } $customer_children[] = array('select' => true, 'title' => $area->area, 'isFolder' => true, 'key' => $account->id . "." . $customer->id . "." . $area->id, 'children' => $area_children); } $account_children[] = array('select' => true, 'title' => $customer->customer, 'isFolder' => true, 'key' => $account->id . "." . $customer->id, 'children' => $customer_children); } $data[] = array('title' => $account->account, 'isFolder' => true, 'key' => $account->id, 'children' => $account_children); } return response()->json($data); }
/** * @param string $identifier * * @return Store */ public function findByIdOrIdentifier($identifier = '') { $identifier = strtolower($identifier); return Store::where(function ($query) use($identifier) { $query->where('id', $identifier)->orWhereRaw("LOWER(identifier) = '{$identifier}'"); })->where('account_id', \Auth::user()->getAccountId())->first(); }
/** * Run the database seeds. * * @return void */ public function run() { //$all_store = new \App\(); $store_id = \App\Store::where('store_name', '=', 'Walmart')->pluck('id'); DB::table('items')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'item_name' => 'Milk 2%', 'quantity' => '2 Gallon', 'store_aisle_num' => '14a', 'store_id' => $store_id, 'checked' => false]); $store_id = \App\Store::where('store_name', '=', 'Walmart')->pluck('id'); DB::table('items')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'item_name' => 'Banana', 'quantity' => '3 lb', 'store_aisle_num' => '4', 'store_id' => $store_id, 'checked' => true]); $store_id = \App\Store::where('store_name', '=', 'Walmart')->pluck('id'); DB::table('items')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'item_name' => 'Sugar', 'quantity' => '2 lb', 'store_aisle_num' => '2', 'store_id' => $store_id, 'checked' => false]); }
public function getCategory() { $cat = ''; $store = Store::where('user_id', Auth::user()->id)->get(); $i = 1; for ($i = 1; $i <= count($store); $i++) { $x = Store::find($i); $y[$i] = $x; } return view('pages.erp.category', compact('store', 'i', 'cat', 'group', 'y')); }
/** * Run the database seeds. * * @return void */ public function run() { $users = ['Jill' => ['Walmart', 'Whole Foods', 'Trader Joes', 'Wegmans', 'Stop & Shop'], 'Jamal' => ['Whole Foods', 'Target', 'Star Market', 'RocheBros']]; foreach ($users as $firstname => $stores) { # first get the user $user = \App\User::where('firstname', 'LIKE', $firstname)->first(); #loop through all the store names for each user and add to the pivot table foreach ($stores as $storeName) { $store = \App\Store::where('store_name', 'LIKE', $storeName)->first(); # Connect this store to this user $user->stores()->save($store); } } }
/** * Run the database seeds. * * @return void */ public function run() { # An array of all the items we want to associate stores with # The *key* will be the item name, and the *value* will be an array of stores. $items = ['Apples' => ['Whole Foods', 'Shaws', "Russo's"], 'Kale' => ['Whole Foods', "Russo's"], 'Cod' => ['Whole Foods', 'Fish Monger'], 'Granola' => ['Whole Foods', "Russo's"], 'Raisins' => ['Whole Foods'], 'Bread' => ['Whole Foods', 'Shaws'], 'Rugelach' => ['Whole Foods'], 'Coffee' => ['Whole Foods', 'Shaws'], 'Olives' => ['Whole Foods', 'Shaws'], 'Hummus' => ['Whole Foods', 'Shaws']]; # Loop through the above array, creating a new pivot for each item to store foreach ($items as $name => $stores) { # First get the item $item = \App\Item::where('name', 'like', $name)->first(); # Now loop through each store for this item, adding the pivot foreach ($stores as $storeName) { $store = \App\Store::where('name', 'LIKE', $storeName)->first(); # Connect this tag to this book $item->stores()->save($store); } } }
/** * get storeItemsDetails. * * @return Response */ public function storeItemsDetails() { $store = Store::where('recipient_id', Auth::user()->recipient_id)->get(); $arr = array(); foreach ($store as $stock) { $arr[$stock->id] = StoreStock::where('store_id', $stock->id)->get()->load('packaging'); } return json_encode($arr); }
/** * save articles for a page which display list. * @param $url * @param $category_id */ protected function saveCoupons($url, $category_id) { $response = $this->crawlerLink($url); $crawler = new Crawler($response); $coupons = $crawler->filter('div#show_coupons > article'); $data = []; foreach ($coupons as $i => $item) { $itemCrawler = new Crawler($item); $temp = $itemCrawler->filter('div.col-md-10 > div.shop-at > a')->attr('href'); $temp = str_replace('http://www.mostcoupon.com/', '', $temp); $temp = str_replace('-coupons', '', $temp); $store = Store::where('slug', trim($temp))->first(); if (!$store) { $name = $itemCrawler->filter('div.col-md-10 > div.shop-at > a')->text(); $image = $itemCrawler->filter('div.logo > img')->attr('src'); $image = $this->downloadImage($image); $store = Store::create(['name' => $name, 'logo' => $image, 'category_id' => $category_id]); } $data[$i]['event_id'] = 1; $data[$i]['store_id'] = $store->id; $data[$i]['title'] = $itemCrawler->filter('div.col-md-10 > p.title')->text(); try { $expired = $itemCrawler->filter('div.col-md-10 > div.expries > span.note')->text(); $data[$i]['expired_date'] = str_replace('End: ', '', $expired); } catch(InvalidArgumentException $e) {} try { $data[$i]['coupon_code'] = $itemCrawler->filter('div.get-code > div.action-mask div.action-wrap > p')->text(); $data[$i]['coupon_type'] = 'code'; } catch (InvalidArgumentException $e) { if ($itemCrawler->filter('div.get-code > div.action-mask > span.action')->text() == 'Free Shipping') { $data[$i]['coupon_type'] = 'ship'; } else { $data[$i]['coupon_type'] = 'deal'; } } $data[$i]['desc'] = $itemCrawler->filter('div.description > p.description')->html(); $temp = $itemCrawler->filter('div.information > span.expries')->text(); $data[$i]['published_date'] = str_replace('Publish: ', '', $temp); try { Coupon::create($data[$i]); } catch(QueryException $e) { } } }
public function getList() { $r = Request::all(); $sortColumn = $r['columns'][$r['order'][0]['column']]['data']; $sortOrder = $r['order'][0]['dir']; $searchValue = '%' . $r['search']['value'] . '%'; $products = Store::all(); $filtered = Store::where('name', 'LIKE', $searchValue)->orWhere('description', 'LIKE', $searchValue)->orWhere('phone', 'LIKE', $searchValue)->orderBy($sortColumn, $sortOrder); return ['draw' => $r['draw'], 'recordsTotal' => count($filtered->get()), 'recordsFiltered' => count($filtered->get()), 'data' => $filtered->limit($r['length'])->offset($r['start'])->get()]; }
public function run() { $start_date = ''; $end_date = ''; $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/Store Mapping.xlsx"; echo (string) $file_path, "\n"; // dd($file_path); Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('audit_templates')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->template)) { $template = AuditTemplate::where('template', $row->template)->first(); if (count($template) == 0) { $newtemplate = new AuditTemplate(); $newtemplate->template_code = $row->channel_code; $newtemplate->template = $row->template; $newtemplate->save(); } } }); }); DB::table('grade_matrixs')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->enrollment_type)) { $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); if (count($matrix) == 0) { $newmatrix = new GradeMatrix(); $newmatrix->desc = $row->enrollment_type; $newmatrix->save(); } } }); }); DB::table('users')->truncate(); DB::table('role_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->fullname)) { $userlist = explode("/", $row->fullname); $emaillist = explode("/", $row->email); // dd($row); for ($i = 0; $i < count($userlist); $i++) { $user = User::where('username', $row->username)->first(); if (count($user) == 0) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $newuser = User::create(array('name' => strtoupper($userlist[$i]), 'email' => $email, 'username' => $row->username, 'password' => Hash::make('password'))); $newuser->roles()->attach(3); } else { // $user->name = strtoupper($row->fullname); // $user->username = $row->username; // $user->email = strtolower($row->email); // $user->update(); // if(!$user->hasRole('field')){ // $user->roles()->attach(3); // } // echo $user->hasRole('field'); } } } }); }); DB::table('accounts')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (count($account) == 0) { $newaccount = new Account(); $newaccount->account = $row->account; $newaccount->save(); } } }); }); DB::table('customers')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { // var_dump($row); $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (count($customer) == 0) { $newcustomer = new Customer(); $newcustomer->account_id = $account->id; $newcustomer->customer_code = $row->customer_code; $newcustomer->customer = $row->customer; $newcustomer->save(); } } } }); }); DB::table('areas')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $area = Area::where('customer_id', $customer->id)->where('area', $row->area)->first(); if (count($area) == 0) { $newarea = new Area(); $newarea->customer_id = $customer->id; $newarea->area = $row->area; $newarea->save(); } } } } }); }); DB::table('regions')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $region = Region::where('region_code', $row->region_code)->where('region', $row->region)->first(); if (count($region) == 0) { $newregion = new Region(); $newregion->region_code = $row->region_code; $newregion->region = $row->region; $newregion->save(); } } }); }); DB::table('distributors')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $dis = Distributor::where('distributor_code', $row->distributor_code)->where('distributor', $row->distributor)->first(); if (count($dis) == 0) { $newdis = new Distributor(); $newdis->distributor_code = $row->distributor_code; $newdis->distributor = strtoupper($row->distributor); $newdis->save(); } } }); }); DB::table('stores')->truncate(); DB::table('store_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $region = Region::where('region_code', $row->region_code)->first(); $dis = Distributor::where('distributor_code', $row->distributor_code)->first(); $store = Store::where('account_id', $account->id)->where('customer_id', $customer->id)->where('region_id', $region->id)->where('distributor_id', $dis->id)->where('store_code', $row->store_code)->where('store', $row->store_name)->first(); if (count($store) == 0) { $template = AuditTemplate::where('template', $row->template)->first(); $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); $newstore = new Store(); $newstore->account_id = $account->id; $newstore->customer_id = $customer->id; $newstore->region_id = $region->id; $newstore->distributor_id = $dis->id; $newstore->store_code = $row->store_code; $newstore->store = $row->store_name; $newstore->grade_matrix_id = $matrix->id; $newstore->audit_template_id = $template->id; $newstore->save(); $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $newstore->users()->attach($user->id); } } else { $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $store->users()->attach($user->id); } } } } } }); }); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function storeDelete($id) { $store = Store::where('id', $id)->first(); $store->delete(); return redirect('admin/stores'); }