public function sku($type = null) { ini_set('max_input_vars', 3000); set_time_limit(0); $frm = date("m-d-Y"); $to = date("m-d-Y"); $report_type = 1; $sel_av = []; $sel_tag = []; $availability = ['1' => 'oos', '2' => 'osa']; $tags = ['1' => 'OSA', '2' => 'NPI']; if (is_null($type) || $type != 'assortment') { $report_type = 2; } if ($report_type == 2) { $areas = StoreInventories::getAreaList(); $sel_ar = StoreInventories::getStoreCodes('area'); $sel_st = StoreInventories::getStoreCodes('store_id'); } else { $areas = AssortmentInventories::getAreaList(); $sel_ar = AssortmentInventories::getStoreCodes('area'); $sel_st = AssortmentInventories::getStoreCodes('store_id'); } if (!empty($sel_ar)) { $data['areas'] = $sel_ar; } if (!empty($sel_st)) { $data['store'] = $sel_st; } if (!empty($frm)) { $data['from'] = $frm; } if (!empty($to)) { $data['to'] = $to; } if (!empty($sel_av)) { $data['availability'] = $sel_av; } if (!empty($sel_tag)) { $data['tags'] = $sel_tag; } if ($report_type == 2) { $header = 'MKL OOS SKU Report'; $inventories = ItemInventories::getOosPerStore($data); } else { $header = 'Assortment OOS SKU Report'; $inventories = AssortmentItemInventories::getOosPerStore($data); } return view('oos.sku', compact('inventories', 'frm', 'to', 'areas', 'sel_ar', 'sel_st', 'header', 'type', 'availability', 'sel_av', 'sel_tag', 'tags')); }
public function area($type = null) { $frm = date("m-d-Y"); $to = date("m-d-Y"); $report_type = 1; $sel_tag = []; $sel_av = []; $availability = ['1' => 'oos', '2' => 'osa']; $tags = ['1' => 'OSA', '2' => 'NPI']; if (is_null($type) || $type != 'assortment') { $report_type = 2; } if ($report_type == 2) { $areas = StoreInventories::getAreaList(); $sel_ar = StoreInventories::getStoreCodes('area'); } else { $areas = AssortmentInventories::getAreaList(); $sel_ar = AssortmentInventories::getStoreCodes('area'); } if (!empty($sel_br)) { $data['areas'] = $sel_ar; } if (!empty($frm)) { $data['from'] = $frm; } if (!empty($to)) { $data['to'] = $to; } if (!empty($sel_av)) { $data['availability'] = $sel_av; } if (!empty($sel_tag)) { $data['tags'] = $sel_tag; } if ($report_type == 2) { $header = 'MKL OSA Per Area Report'; $inventories = ItemInventories::getOsaPerArea($data); } else { $header = 'Assortment OSA Per Area Report'; $inventories = AssortmentItemInventories::getOsaPerArea($data); } return view('osa.area', compact('inventories', 'frm', 'to', 'areas', 'sel_ar', 'header', 'type', 'availability', 'sel_av', 'sel_tag', 'tags')); }