/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('item_inventories')->where('conversion', '>', 0)->update(['min_stock' => 2, 'oos' => 1, 'osa' => 0]);
$areas = ['MDC', 'ROSE PHARMACY', '360 PHARMACY', '360 DRUG', 'ST. JOSEPH DRUG', 'SOUTH STAR DRUG'];
$stores = StoreInventories::select('id')->whereIn('area', $areas)->get();
foreach ($stores as $item) {
ItemInventories::where('store_inventory_id', $item->id)->update(['min_stock' => 3]);
}
DB::statement("update `item_inventories` set `oos` = 0, `osa` = 1 where `sapc` > min_stock");
}
public function areastorelist(Request $request)
{
if (\Request::ajax()) {
$areas = $request->areas;
$type = $request->type;
$report_type = 1;
if (is_null($type) || $type != 'assortment') {
$report_type = 2;
}
if ($report_type == 2) {
$data['selection'] = StoreInventories::select('store_id', 'store_name')->whereIn('area', $areas)->orderBy('store_name')->lists('store_name', 'store_id');
} else {
$data['selection'] = AssortmentInventories::select('store_id', 'store_name')->whereIn('area', $areas)->orderBy('store_name')->lists('store_name', 'store_id');
}
return \Response::json($data, 200);
}
}
