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 '無資料';
}
}
