我有如下表所以有優先級和平方英尺，我想開始制造計劃（從當前日期開始），每天將處理 1700 平方英尺，如下圖所示但正如你所看到的，它不起作用我試過下面的代碼foreach($priorityArraySum as $key=>$val){ $totalDays=ceil($val/1700); $cutSQFT=$val; for($j=1;$j<=$totalDays;$j++) { if($cutSQFT>1700) { echo '1700'; $cutDate=date('Y-m-d', strtotime($cutDate. ' + 1 days')); $cutSQFT=$cutSQFT-1700; } else { echo $cutSQFT; $cutSQFT=$cutSQFT-$cutSQFT; } }}@Nigel，為了使這種動態化，我已將代碼更改為下面的代碼，但它不起作用。$pln_qry=mysql_query("select * from tbl_mfg_schedule where ms_date='".$today."'") or die(mysql_error()); $pln_data=mysql_fetch_array($pln_qry); $max = $pln_data['ms_po_sqft']; $dailyLeft = $max; $current = reset($priorityArraySum); $output = []; //$day = date('Y-m-d'); $day = date('Y-m-d'); while (true) { $pln_qry=mysql_query("select * from tbl_mfg_schedule where ms_date='".$today."'") or die(mysql_error()); $pln_data=mysql_fetch_array($pln_qry); $max = $pln_data['ms_po_sqft']; if ( $current >= $dailyLeft ) { //$day=date('Y-m-d', strtotime($day. ' + 1 days')); $output[] = ["priority" => key($priorityArraySum), "amount" => $dailyLeft, "day" => $day ]; $day=date('Y-m-d', strtotime($day. ' + 1 days')); $current -= $dailyLeft; $dailyLeft = $max; }
1 回答
UYOU
TA貢獻1878條經驗 獲得超4個贊
此代碼使用while()循環創建工作天數的輸出數組。它用于$current跟蹤每個項目以及剩余的分配量。它還用于$dailyLeft跟蹤特定日期剩余的容量。它會檢查兩者，如果當前小于剩余的每日容量，則會為該項目分配一整天并重置每日容量。如果當天有額外容量，則會將此項目分配給該天并獲取下一個項目。
$day++僅當當天的容量已滿時，該天才會增加（使用）...
$max = 1700;
$dailyLeft = $max;
$current = reset($priorityArraySum);
$output = [];
$day = 1;
while (true) {
// echo $current."/".$dailyLeft."=".$day.PHP_EOL;
if ( $current >= $dailyLeft ) {
$output[] = ["priority" => key($priorityArraySum),
"amount" => $dailyLeft,
"day" => $day++
];
$current -= $dailyLeft;
$dailyLeft = $max;
}
else {
$output[] = ["priority" => key($priorityArraySum),
"amount" => $current,
"day" => $day
];
$dailyLeft -= $current;
if ( ($current = next($priorityArraySum)) === false ) {
break;
}
}
}
print_r($output);
- 1 回答
- 0 關注
- 100 瀏覽
添加回答
舉報
0/150
提交
取消