public function stock() { $tran = $this->data->tran; $inches = $this->data->inch; $defaulInch = 15; $storages = Detail::group(); $sells = Sell::group(); $tires = Tire::defaultInch($defaulInch); $defaultSpec = $tires->first()->spec; $details = Detail::allGroup($defaultSpec); foreach ($details as $detail) { $sales = Sell::pairGroup($detail); $salesQ = empty($sales) ? 0 : $sales->Q; $detailQ = $detail->Q; $detail->Q = $detailQ - $salesQ; } foreach ($storages as $storage) { $storageCom[$storage->location][$storage->state] = $storage->Q; } foreach ($sells as $sell) { $sellCom[$sell->location][$sell->state] = $sell->Q; } //$array = [ 'home'=>['a','b'], 'next'=>'b', 'ware'=> 'b']; $array = ['home' => ['a', 'b']]; foreach ($array as $k1 => $v1) { if (is_array($array[$k1])) { foreach ($array[$k1] as $v2) { isset($storageCom[$k1][$v2]) or $storageCom[$k1][$v2] = 0; isset($sellCom[$k1][$v2]) or $sellCom[$k1][$v2] = 0; $comString = $k1 . strtoupper($v2); $comStorage[$comString] = $storageCom[$k1][$v2] - $sellCom[$k1][$v2]; } } else { isset($storageCom[$k1][$v1]) or $storageCom[$k1][$v1] = 0; $comString = $k1 . strtoupper($v1); $comStorage[$comString] = $storageCom[$k1][$v1] - $sellCom[$k1][$v1]; } } $aCompact = compact('inches', 'comStorage', 'tires', 'details', 'tran'); return view('f.stock', $aCompact); }
public function postSearchResult() { if ($_POST['q']) { $tran = Data::getTran(); !isset($_POST['state']) and $_POST['state'] = null; $data = [$_POST['q'], $_POST['state']]; $details = Detail::allGroup($data); foreach ($details as $detail) { $sales = Sell::pairGroup($detail)->first(); $salesQ = empty($sales) ? 0 : $sales->Q; $detailQ = $detail->Q; $detail->Q = $detailQ - $salesQ; } $results = trRows($details, $tran, $grids = 3); echo $results; } else { echo '無資料'; } }