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