/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$frm = date("m-d-Y");
$to = date("m-d-Y");
$agencies = AssortmentInventories::getAgencyList();
$sel_ag = AssortmentInventories::getStoreCodes('agency_code');
$sel_cl = AssortmentInventories::getStoreCodes('client_code');
$sel_ch = AssortmentInventories::getStoreCodes('channel_code');
$sel_ds = AssortmentInventories::getStoreCodes('distributor_code');
$sel_en = AssortmentInventories::getStoreCodes('enrollment_type');
$sel_rg = AssortmentInventories::getStoreCodes('region_code');
$sel_st = AssortmentInventories::getStoreCodes('store_id');
$divisions = AssortmentItemInventories::getDivisionList();
$sel_dv = AssortmentItemInventories::getItemCodes('division');
$sel_cat = AssortmentItemInventories::getItemCodes('category');
$sel_scat = AssortmentItemInventories::getItemCodes('sub_category');
$sel_br = AssortmentItemInventories::getItemCodes('brand');
$data = array();
if (!empty($sel_ag)) {
$data['agencies'] = $sel_ag;
}
if (!empty($sel_cl)) {
$data['clients'] = $sel_cl;
}
if (!empty($sel_ch)) {
$data['channels'] = $sel_ch;
}
if (!empty($sel_ds)) {
$data['distributors'] = $sel_ds;
}
if (!empty($sel_en)) {
$data['enrollments'] = $sel_en;
}
if (!empty($sel_rg)) {
$data['regions'] = $sel_rg;
}
if (!empty($sel_st)) {
$data['stores'] = $sel_st;
}
if (!empty($sel_dv)) {
$data['divisions'] = $sel_dv;
}
if (!empty($sel_cat)) {
$data['categories'] = $sel_cat;
}
if (!empty($sel_scat)) {
$data['sub_categories'] = $sel_scat;
}
if (!empty($sel_br)) {
$data['brands'] = $sel_br;
}
if (!empty($frm)) {
$data['from'] = $frm;
}
if (!empty($to)) {
$data['to'] = $to;
}
$items = AssortmentItemInventories::filter($data);
return view('inventory.assortment', compact('frm', 'to', 'agencies', 'sel_ag', 'sel_cl', 'sel_ch', 'sel_ds', 'sel_en', 'sel_rg', 'sel_st', 'divisions', 'sel_dv', 'sel_cat', 'sel_scat', 'sel_br', 'items'));
}
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'));
}
