/** * Run the database seeds. * * @return void */ public function run() { // Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $folderpath = base_path() . '/database/seeds/templates/'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", str_replace('\\', '/', $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; } } $filePath = $folderpath . $latest . '/Masterfile.xlsx'; $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($filePath); DB::table('channel_items')->truncate(); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'MKL Mapping') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($row[0] != '') { if ($cnt > 0) { // dd($row); if (!ctype_digit(trim($row[4])) || !ctype_digit(trim($row[5])) || !ctype_digit(trim($row[6]))) { InvalidMapping::create(['premise_code' => trim($row[0]), 'customer_code' => trim($row[1]), 'store_code' => trim($row[2]), 'sku_code' => trim($row[3]), 'ig' => trim($row[4]), 'multiplier' => trim($row[5]), 'minstock' => trim($row[6]), 'type' => 'MKL Mapping', 'remarks' => 'Invalid mapping']); } else { $channel = ''; if (trim($row[0]) != '') { $channel = Channel::where('channel_code', trim($row[0]))->first(); } $item = Item::where('sku_code', trim($row[3]))->first(); if (!empty($item)) { $item_type = ItemType::where('type', "MKL")->first(); $osa_tagging = 0; if (isset($row[7])) { $osa_tagging = trim($row[7]); } $npi_tagging = 0; if (isset($row[8])) { $npi_tagging = trim($row[8]); } ChannelItem::firstOrCreate(['channel_id' => $channel->id, 'item_id' => $item->id, 'item_type_id' => $item_type->id, 'ig' => trim($row[4]), 'fso_multiplier' => trim($row[5]), 'min_stock' => trim($row[6]), 'osa_tagged' => $osa_tagging, 'npi_tagged' => $npi_tagging]); } } } $cnt++; } } } } $reader->close(); }
public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $folderpath = base_path() . '/database/seeds/seed_files/'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", str_replace('\\', '/', $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; } } $filePath = $folderpath . $latest . '/Masterfile.xlsx'; $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($filePath); echo 'Seeding ' . $filePath . PHP_EOL; // DB::table('other_barcodes')->truncate(); Item::where('active', 1)->update(['cleared' => 0]); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Other Codes') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if (!is_null($row[0]) && trim($row[0]) != '') { if ($cnt > 0) { $item = Item::where('sku_code', trim($row[0]))->first(); if (!empty($item)) { if ($item->cleared == 0) { OtherBarcode::where('item_id', $item->id)->delete(); $item->cleared = 1; $item->save(); } $area = Area::where('area', strtoupper($row[1]))->first(); if (!empty($item) && !empty($area)) { OtherBarcode::firstOrCreate(['item_id' => $item->id, 'area_id' => $area->id, 'other_barcode' => trim($row[2])]); } } else { // dd($row); } } $cnt++; } } } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $folderpath = base_path() . '/database/seeds/seed_files/'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", str_replace('\\', '/', $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; } } $filePath = $folderpath . $latest . '/Masterfile.xlsx'; $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($filePath); // DB::table('store_items'); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Assortment Mapping') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($row[0] != '') { if ($cnt > 0) { if (!ctype_digit(trim($row[4]))) { InvalidMapping::create(['premise_code' => trim($row[0]), 'customer_code' => trim($row[1]), 'store_code' => trim($row[2]), 'sku_code' => trim($row[3]), 'ig' => trim($row[4]), 'multiplier' => trim($row[5]), 'minstock' => trim($row[6]), 'type' => 'Assortment Mapping', 'remarks' => 'Invalid mapping']); } else { $channel = ''; $customer = ''; $store = ''; if (trim($row[0]) != '') { $channel = Channel::where('channel_code', trim($row[0]))->get(); } if (trim($row[1]) != '') { $customer = Customer::where('customer_code', trim($row[1]))->get(); } if (trim($row[2]) != '') { $store = Store::where('store_code', trim($row[2]))->first(); } // dd($store); $stores = Store::where(function ($query) use($channel) { if (!empty($channel)) { $channel_id = []; foreach ($channel as $value) { $channel_id[] = $value->id; } $query->whereIn('channel_id', $channel_id); } })->where(function ($query) use($customer) { if (!empty($customer)) { $customer_id = []; foreach ($customer as $value) { $customer_id[] = $value->id; } $query->whereIn('customer_id', $customer_id); } })->where(function ($query) use($store) { if (!empty($store)) { $query->where('store', $store->id); } })->get(); // dd($stores); $item = Item::where('sku_code', trim($row[3]))->first(); if (!empty($item)) { $item_type = ItemType::where('type', "ASSORTMENT")->first(); foreach ($stores as $store) { $w_mkl = StoreItem::where('store_id', $store->id)->where('item_id', $item->id)->get(); $cw_mkl = ChannelItem::where('channel_id', $store->channel_id)->where('item_id', $item->id)->get(); if (count($w_mkl) == 0) { StoreItem::firstOrCreate(['store_id' => $store->id, 'item_id' => $item->id, 'item_type_id' => $item_type->id, 'ig' => trim($row[4]), 'fso_multiplier' => trim($row[5]), 'min_stock' => trim($row[6]), 'osa_tagged' => 0, 'npi_tagged' => 0]); } if (count($cw_mkl) == 0) { ChannelItem::firstOrCreate(['channel_id' => $store->channel_id, 'item_id' => $item->id, 'item_type_id' => $item_type->id, 'ig' => trim($row[4]), 'fso_multiplier' => trim($row[5]), 'min_stock' => trim($row[6]), 'osa_tagged' => 0, 'npi_tagged' => 0]); } } } } } $cnt++; } } } } $reader->close(); $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(); } DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
public function viewAll() { $error = \Session::get('error'); $messages = \Session::get('messages'); $items = Item::where('active', Constants::ACTIVE)->get(); return view('items.viewAll', ['items' => $items, 'error' => $error, 'messages' => $messages]); }
/** * * @return mixed */ public function siblings() { if (!$this->parent) { return Item::forCurrentUser()->whereNull('parent_id')->where('id', '!=', $this->id)->get(); } return Item::where('parent_id', $this->parent_id)->where('id', '!=', $this->id)->get(); }
public function get_item_by_category(Request $request) { if ($request->ajax()) { $category_id = $request->input('category_id'); $iteminfo = Item::where('itemssubgroupid', $category_id)->get(); return response()->json($iteminfo); } }
/** * Count duplicate fields * If check is done while updating data then check except this id * * @param string $field_name * @param array $fields * @return int */ public function duplicateField($field_name, $fields) { $field_count = Item::where($field_name, $fields['name']); if (!empty($fields['item_id'])) { $field_count = $field_count->where('id', '!=', $fields['item_id']); } $field_count = $field_count->count(); return $field_count; }
public function delete(Request $request, $banqueId, $itemId) { // verify request inputs if (is_null($itemId)) { return response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST); } else { $item = Item::where('id_Item', '=', $itemId)->delete(); return is_null($item) ? response()->json(['error' => 'Bad request'], HttpResponse::HTTP_BAD_REQUEST) : $item; } }
public function add($itemId) { // Cart::add(455, 'Sample Item', 100.99, 2, array()); /* 取得商品信息 */ $item = Item::where('id', '=', $itemId)->first(); // var_dump($item);exit; /* 初始化要插入购物车的基本件数据 */ $parent = array('user_id' => Auth::id(), 'goods_id' => $itemId, 'sku' => $item['sku'], 'item_name' => addslashes($item['name']), 'price' => $item['price']); Cart::add($itemId, addslashes($item['name']), $item['price'], '1', array()); return redirect()->route('cart.index'); }
/** * Run the database seeds. * * @return void */ public function run() { set_time_limit(0); ini_set('memory_limit', -1); $updated_igs = UpdatedIg::all(); foreach ($updated_igs as $row) { $store = Store::where('store_code', $row->store_code)->first(); if (!empty($store)) { $item = Item::where('sku_code', $row->sku_code)->first(); if (!empty($item)) { StoreItem::where('store_id', $store->id)->where('item_id', $item->id)->update(['ig' => $row->ig, 'ig_updated' => 1]); } } } }
public function getDocumentItems(Request $request) { $id = $request->get('document_id'); $document = \App\Models\Document::find($id); $items = \App\Models\Item::where('document_id', '=', $id); if (Auth::user()->username == '1-0275071849') { $datatables = Datatables::of($items)->addColumn('action', function ($item) { return '<a href="/item/' . $item->id . '" class="actions icons"><i class="fa fa-eye"></i></a>'; }); } else { $datatables = Datatables::of($items)->addColumn('action', function ($item) { return '<a href="/item/' . $item->id . '" class="actions icons"><i class="fa fa-eye"></i></a><a href="/item/' . $item->id . '/edit" class="actions icons"><i class="fa fa-pencil-square-o"></i></a><a href="/item/destroy/' . $item->id . '" class="actions icons"><i class="fa fa-trash"></i></a>'; }); } return $datatables->make(true); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('updated_igs', function (Blueprint $table) { $table->string('area')->after('id'); $table->string('region_code')->after('area'); $table->string('region')->after('region_code'); $table->string('distributor_code')->after('region'); $table->string('distributor')->after('distributor_code'); $table->string('agency_code')->after('distributor'); $table->string('agency')->after('agency_code'); $table->string('storeid')->after('agency'); $table->string('channel_code')->after('store_name'); $table->string('channel')->after('channel_code'); $table->string('other_code')->after('channel'); }); set_time_limit(0); ini_set('memory_limit', -1); $updated_igs = UpdatedIg::all(); foreach ($updated_igs as $updated_ig) { $store = Store::where('store_code', $updated_ig->store_code)->first(); $item = Item::where('sku_code', $updated_ig->sku_code)->first(); if (!empty($store) && !empty($item)) { $other_code = OtherBarcode::where('item_id', $item->id)->where('area_id', $store->area->id)->first(); $updated_ig->area = $store->area->area; $updated_ig->region_code = $store->region->region_code; $updated_ig->region = $store->region->region; $updated_ig->distributor_code = $store->distributor->distributor_code; $updated_ig->distributor = $store->distributor->distributor; $updated_ig->agency_code = $store->agency->agency_code; $updated_ig->agency = $store->agency->agency_name; $updated_ig->storeid = $store->storeid; $updated_ig->channel_code = $store->channel->channel_code; $updated_ig->channel = $store->channel->channel_desc; if (!empty($other_code)) { $updated_ig->other_code = $other_code->other_barcode; } $updated_ig->update(); } } }
public function run() { $divisions = ['HPC CATEGORY', 'FOODS CATEGORY']; $inventories = ItemInventories::whereNotIn('division', $divisions)->get(); foreach ($inventories as $inventory) { $item = Item::where('sku_code', $inventory->sku_code)->first(); $inventory->division = $item->division->division; $inventory->category = $item->category->category; $inventory->category_long = $item->category->category_long; $inventory->sub_category = $item->subcategory->sub_category; $inventory->brand = $item->brand->brand; $inventory->update(); } $asinventories = AssortmentItemInventories::whereNotIn('division', $divisions)->get(); foreach ($asinventories as $inventory) { $item = Item::where('sku_code', $inventory->sku_code)->first(); $inventory->division = $item->division->division; $inventory->category = $item->category->category; $inventory->category_long = $item->category->category_long; $inventory->sub_category = $item->subcategory->sub_category; $inventory->brand = $item->brand->brand; $inventory->update(); } }
public function getItems($banqueId) { return Item::where('id_Banque', '=', $banqueId)->get(); }
public function search(Request $request) { $items = Item::where('nombre_item', 'like', '%' . $request->nombre . '%')->get(); return \View::make('list_item', compact('items')); }
public static function total($month, $year) { return Item::where(DB::raw('MONTH(created_at)'), '=', $month)->where(DB::raw('YEAR(created_at)'), '=', $year)->sum('amount'); }
/** * @return \Illuminate\Routing\Route|null|string */ public function ingnoreId() { $id = $this->route('item'); $name = $this->input('name'); return Item::where(compact('id', 'name'))->exists() ? $id : ''; }
public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $folderpath = base_path() . '/database/seeds/seed_files/'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", str_replace('\\', '/', $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; } } $filePath = $folderpath . $latest . '/Masterfile.xlsx'; $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($filePath); // DB::table('divisions')->truncate(); // DB::table('categories')->truncate(); // DB::table('sub_categories')->truncate(); // DB::table('brands')->truncate(); // DB::table('items')->truncate(); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Items') { $cnt = 0; Item::where('active', 1)->update(['active' => 0, 'cleared' => 0]); foreach ($sheet->getRowIterator() as $row) { if ($row[0] != '') { if ($cnt > 0) { $division = Division::firstOrCreate(['division' => strtoupper($row[9])]); $category = Category::firstOrCreate(['category' => strtoupper($row[1]), 'category_long' => strtoupper($row[0])]); $sub_category = SubCategory::firstOrCreate(['category_id' => $category->id, 'sub_category' => strtoupper($row[7])]); $brand = Brand::firstOrCreate(['brand' => strtoupper($row[8])]); $itemExist = Item::where('sku_code', strtoupper($row[2]))->first(); if (empty($itemExist)) { $item = Item::firstOrCreate(['sku_code' => trim($row[2]), 'barcode' => $row[3], 'description' => strtoupper($row[4]), 'description_long' => strtoupper($row[5]), 'conversion' => trim($row[6]), 'lpbt' => trim($row[10]), 'division_id' => $division->id, 'category_id' => $category->id, 'sub_category_id' => $sub_category->id, 'brand_id' => $brand->id, 'active' => 1]); } else { $itemExist->sku_code = trim($row[2]); $itemExist->barcode = $row[3]; $itemExist->description = strtoupper($row[4]); $itemExist->description_long = strtoupper($row[5]); $itemExist->conversion = trim($row[6]); $itemExist->lpbt = trim($row[10]); $itemExist->division_id = $division->id; $itemExist->category_id = $category->id; $itemExist->sub_category_id = $sub_category->id; $itemExist->brand_id = $brand->id; $itemExist->active = 1; $itemExist->save(); } } $cnt++; } } } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $lists = Item::where('type', '=', 'Service')->paginate(10); return view('service.index', compact('lists')); }
/** * Go to next or previous item in the list of items of a plan * or swap between chords and sheetmusic */ function nextItem($plan_id, $item_id, $direction) { // get the full plan $plan = Plan::find($plan_id); // items list sort order depending on direction $orderBy = "asc"; if ($direction == 'previous') { $orderBy = 'desc'; } if (Auth::user()->ownsPlan($plan_id)) { // get all the items for this plan $items = $plan->items()->orderBy('seq_no', $orderBy)->get(); } else { // get all items but not "FLEO" items (for leaders eyes only) $items = $plan->items()->where('forLeadersEyesOnly', false)->orderBy('seq_no', $orderBy)->get(); } // perhaps the item_id is a seq no $Ar_seq_no = explode('-', $item_id); // if item_id actually is a seq_no, then the format is: <text>-<text>-<seq_no> if (count($Ar_seq_no) == 3) { // third element is the actual seq no // but we need to increase it by 1 $cur_seq_no = $Ar_seq_no[2] + 1; // now find item with the new seq no $curItem = Item::where([['plan_id', '=', $plan_id], ['seq_no', '=', $cur_seq_no]])->first(); // return the item id of that item (if we found it!) if ($curItem) { return $curItem->id; } else { return 0; // not found! } } else { $curItem = Item::find($item_id); } // get seq_no of desired next or previous item $new_seq_no = 0; // to prevent unnassigned exception if ($direction == 'next') { if ($curItem->seq_no == count($items)) { $new_seq_no = 1.0; } else { $new_seq_no = $curItem->seq_no + 1; } } elseif ($direction == 'previous') { if ($curItem->seq_no == 1.0) { $new_seq_no = count($items); } else { $new_seq_no = $curItem->seq_no - 1; } } elseif ($direction == 'swap') { $new_seq_no = $curItem->seq_no; } // find the new item id foreach ($items as $item) { if ($direction == 'next' && $item->seq_no >= $new_seq_no) { return $item->id; } elseif ($direction == 'previous' && $item->seq_no <= $new_seq_no) { return $item->id; } elseif ($item->seq_no == $new_seq_no) { return $item->id; } } return $item->id; }
public function postupdateig(Request $request) { if ($request->hasFile('file')) { $file_path = $request->file('file')->move(storage_path() . '/uploads/temp/', $request->file('file')->getClientOriginalName()); \DB::beginTransaction(); try { set_time_limit(0); $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($file_path); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Sheet1') { $cnt = 0; foreach ($sheet->getRowIterator() as $row) { if ($cnt > 0) { if (!empty($row[5])) { // dd($row); $updated_ig = UpdatedIg::where('store_code', $row[8])->where('sku_code', $row[13])->first(); if (!empty($updated_ig)) { $updated_ig->ig = $row[23]; $updated_ig->update(); } else { // dd($row); UpdatedIg::firstOrCreate(['area' => $row[0], 'region_code' => $row[1], 'region' => $row[2], 'distributor_code' => $row[3], 'distributor' => $row[4], 'agency_code' => $row[5], 'agency' => $row[6], 'storeid' => $row[7], 'store_code' => $row[8], 'store_name' => $row[9], 'channel_code' => $row[10], 'channel' => $row[11], 'other_code' => $row[12], 'sku_code' => $row[13], 'description' => $row[14], 'division' => $row[15], 'category' => $row[16], 'sub_category' => $row[17], 'brand' => $row[18], 'conversion' => $row[19], 'min_stock' => $row[20], 'fso_multiplier' => $row[21], 'lpbt' => $row[22], 'ig' => $row[23]]); } $store = Store::where('store_code', $row[8])->first(); if (!empty($store)) { $item = Item::where('sku_code', $row[13])->first(); if (!empty($item)) { StoreItem::where('store_id', $store->id)->where('item_id', $item->id)->update(['ig' => $row[23]]); } } } } $cnt++; } } } $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(); } \DB::commit(); $reader->close(); } catch (\Exception $e) { \DB::rollback(); dd($e); } if (\File::exists($file_path)) { \File::delete($file_path); } Session::flash('flash_message', 'Updated IG successfully updated.'); Session::flash('flash_class', 'alert-success'); } else { Session::flash('flash_message', 'Error updating item IG.'); Session::flash('flash_class', 'alert-danger'); } return redirect()->route("item.updatedig"); }
private function resolveItemsBySloppyName($skins) { $name_count = 0; foreach ($skins as &$skin) { if (isset($skin['items'])) { continue; } $items = Item::where('name_en', 'LIKE', $skin['name'] . '% Skin')->lists('id'); if (count($items) == 0) { continue; } $skin['items'] = $items; $name_count++; } $this->info('Resolved ' . $name_count . ' skins by sloppy name lookup...'); return $skins; }
/** * Get items matching the skin id * * @return array */ public function bySkin() { // Request data $skin_id = $this->getInput('skin_id'); // Grab the item ids that match the skin $ids = Item::where('skin', $skin_id)->lists('id'); return $this->apiResponse($ids); }
public function importFile(Request $request) { $messages = []; $error = Constants::MSG_OK_CODE; $num_successful_import = 0; //============== //Check //============== $inputName = 'csv_file'; if (!$request->hasFile($inputName)) { $error = Constants::MSG_ERROR_CODE; $messages[] = Lang::get('orders.noFile'); return redirect()->route('orders::viewAll')->with('error', $error)->with('messages', $messages); } if (!$request->file($inputName)->isValid()) { $error = Constants::MSG_ERROR_CODE; $messages[] = Lang::get('orders.invalidFile'); return redirect()->route('orders::viewAll')->with('error', $error)->with('messages', $messages); } //============== //Treatment //============== $file = $request->file($inputName); if (($handle = fopen($file, "r")) !== false) { $i = 0; setlocale(LC_ALL, 'fr_FR.UTF-8'); while (($data = fgetcsv($handle, null, ";", "\"")) !== false) { $i++; if ($i == 1) { continue; } //skip the first line $date = $data[0]; $orderNumber = trim(substr($data[1], 7)); $customerName = $data[2]; $adress = $data[3]; //order already exist if (Order::find($orderNumber)) { $messages[] = Lang::get('orders.alreadyExists', ['id' => $orderNumber]); $error = Constants::MSG_WARNING_CODE; continue; } $order = new Order(); $order->date = Carbon::parse($date); $order->id = intval($orderNumber); $order->name = $customerName; $order->address = $adress; $order->user_id = Constants::DEFAULT_USER_ID; $order->status = Constants::ORDER_WAITING; //====================== //Treatment Order lines //====================== $detail = str_getcsv($data[4], ";"); $orderRows = []; $orderHasProducts = false; foreach ($detail as $key => $value) { $item = trim(substr($value, 0, strpos($value, "("))); if (strlen($item) <= 0) { $messages[] = Lang::get('orders.hasNoProducts', ['id' => $orderNumber]); $error = Constants::MSG_WARNING_CODE; continue; } $quantity = rtrim(substr($value, strpos($value, "(") + 1), ")"); $ref = Item::where("name", "=", $item)->first(); if ($ref != null) { $row = new OrderRow(); $row->item_id = $ref->id; $row->order_id = $order->id; $row->quantity = $quantity; $orderRows[] = $row; if ($ref->active == Constants::ARCHIVED) { $messages[] = Lang::get('orders.productArchived', ['produit' => $ref->name, 'id' => $orderNumber]); $error = Constants::MSG_WARNING_CODE; } $orderHasProducts = true; } else { $messages[] = Lang::get('orders.productNotFound', ['produit' => $item, 'id' => $orderNumber]); $error = Constants::MSG_WARNING_CODE; } } if (!$orderHasProducts) { $messages[] = Lang::get('orders.hasNoProducts', ['id' => $orderNumber]); $error = Constants::MSG_WARNING_CODE; continue; } if ($order->save()) { foreach ($orderRows as $key => $value) { $value->save(); } $num_successful_import++; } else { $error = Constants::MSG_ERROR_CODE; $messages[] = Lang::get('orders.saveError'); } } fclose($handle); } else { $error = Constants::MSG_ERROR_CODE; $messages[] = Lang::get('orders.fileError'); } $messages[] = Lang::get('orders.lineImported', ['number' => $num_successful_import]); return redirect()->route('orders::viewAll')->with('error', $error)->with('messages', $messages); }
public function selectTen() { return Item::where('type', '=', 'Product')->paginate(10); }
/** * For moving item to new parent. Make room for the new item. * @param $new_parent * @param $new_index */ public function moveIn($new_parent, $new_index) { if ($new_parent) { Item::where('parent_id', $new_parent->id)->where('index', '>=', $new_index)->increment('index'); } else { //Moving home Item::forCurrentUser()->whereNull('parent_id')->where('index', '>=', $new_index)->increment('index'); } }