public function getStockDetail() { $tran = Data::getTran(); $defaultInch = $_GET['inch']; if (strlen($defaultInch) > 2) { $defaultSpec = $_GET['inch']; } else { $builder = Tire::select('spec')->where('spec', 'LIKE', '%' . $defaultInch)->orderBy('spec', 'ASC'); $defaultSpec = $builder->first()->spec; } //$defaultSpec = '175/70/13'; $details = Detail::allGroup($defaultSpec); foreach ($details as $detail) { $sales = Sell::pairGroup($detail)->first(); $sellQ = empty($sales) ? 0 : $sales->Q; $detailQ = $detail->Q; $detail->Q = $detailQ - $sellQ; } $trRows = trRows($details, $tran); echo $trRows; }