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