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 search(Request $request) { $areas = Area::where('nombre_area', 'like', '%' . $request->nombre . '%')->get(); return \View::make('Area/list_area', compact('areas')); }