สอบถามเกี่ยวกับการคำนวณตัวเลขเพื่อระบุจำนวนกล่องบนพาเลทครับ

Quote:

$SqlLoadDet = "select a.* from packlist_det a where a.packlist_num ='105' and a.packlist_line = '0006' order by a.sort_det ";
$objLoadDet= mssql_query($SqlLoadDet);
$i=0;
while($RCLoadDet = mssql_fetch_array($objLoadDet)){
$i++;
$qty_per = 48;
$cup = ceil($RCLoadDet[carton_qty]/$qty_per);
$cud = floor($RCLoadDet[carton_qty]/$qty_per);
$cfro = ( $cup == $cud )? 0 : 1;
$pallet_fromx = ( $i ==1 ) ? 0 :$cfro;

if($RCLoadDet['packlist_det']=='0001'){
$chcup = 0;
}else{
$chcup = (fmod($RD[carton_qty]/$qty_per, 1) !== 0.00)? 0 : 1;
}

$arr2 = array($cup);
for ( $a = 0; $a < count($arr2); $a++ )
{

$cfromx = ( $pallet_fromx <= 0 ) ? 239 : $pallet_to;
$pallet_from = ( $arr2[$a] > 0 ) ? $cfromx+$chcup: $arr2[$a] + 1;
$pallet_to = $arr2[$a] + ($pallet_from-1);

echo " carton from "; echo $pallet_from; echo " to "; echo $pallet_to;
echo "<br>";

/*
update ข้อมูลลง table ตาม product id
*/

}}

Quote:

AAA carton from 239 to 244
BBB carton from 245 to 311
CCC carton from 312 to 324