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();
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$store = Store::findOrFail($id);
$this->validate($request, ['store_id' => 'required', 'brands' => 'required']);
\DB::beginTransaction();
try {
SecondaryDisplayLookup::where('store_id', $store->id)->delete();
foreach ($request->brands as $value) {
SecondaryDisplayLookup::create(['store_id' => $store->id, 'secondary_display_id' => $value]);
}
\DB::commit();
Session::flash('flash_message', 'Secondary Display Lookup successfully updated!');
return redirect()->route("secondarylookup.edit", [$id]);
} catch (Exception $e) {
DB::rollBack();
return redirect()->back();
}
}
