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