exec_query('bins_trans', ['*'], '', '', '', '', "silo_id <> 0", '', false);
$bins_trans = $bins_trans_res->fetch_assoc();
if ($bins_trans_res->num_rows >= 1) {
while ($bins_info = $bins_trans_res->fetch_assoc()) {
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id ={$bins_info['variety_id']}");
$variety_info = $variety_res->fetch_assoc();
$drying_bin_res = $db->exec_query("drying_bins", ['*'], '', '', '', '', "record_id ={$bins_info['bin_id']}");
$drying_bin = $drying_bin_res->fetch_assoc();
$silo_res = $db->exec_query("silos", ['*'], '', '', '', '', "record_id ={$bins_info['silo_id']}");
$silo = $silo_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "
| NO RESULTS |
";
}
$silo_data = $db->exec_query('bins_trans', ['*'], '', '', '', '', '', 'silo_id <> 0', false);
//calculate the total amount of each stilo
$total_data = "";
$total = 0;
$silo_names_res = $db->query("SELECT DISTINCT silo_id FROM bins_trans WHERE silo_id <> 0");
// echo "SELECT DISTINCT silo_id FROM bins_trans
";
while ($silo_ids = $silo_names_res->fetch_assoc()) {
// Get total amount for this silo_id
$silo_id = $silo_ids['silo_id'];
$silo_amount_res = $db->query("SELECT SUM(amount) AS total FROM bins_trans WHERE silo_id = {$silo_id}");
$silo_amount_row = $silo_amount_res->fetch_assoc();
$silo_total = $silo_amount_row['total'];
// echo "SELECT SUM(amount) AS total FROM bins_trans WHERE silo_id = {$silo_id}
";
// Get silo name
$silo_name_res = $db->exec_query("silos", ['*'], '', '', '', '', "record_id = {$silo_id}");
$silo_name = $silo_name_res->fetch_assoc();
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id = {$silo_name['variety_id']}");
$variety = $variety_res->fetch_assoc();
$total += $silo_total;
// Add to output
$total_data .= "
|
|
|
";
}
// echo $total_data;
?>
|
BATCH:
|
VARIETY:
|
AMOUNT:
|
DRYING BIN:
|
DATE:
|
SILO:
|