exec_query('batches', ['*'], '', '', '', '', "status = 'COMPLETE'", '', false);
// if ($batches->num_rows > 0) {
// while ($batch = $batches->fetch_assoc()) {
// $bins_trans_res = $db->exec_query('bins_trans', ['*'], '', '', '', '', "silo_id <> 0", 'order by record_id desc', false);
// while ($bins_trans = $bins_trans_res->fetch_assoc()) {
// $variety_res = $db->exec_query('variety', ['*'], '', '', '', '', "record_id = {$bins_trans['variety_id']}", '', false);
// $variety = $variety_res->fetch_assoc();
// $silo_res = $db->exec_query('silos', ['*'], '', '', '', '', "record_id = {$bins_trans['silo_id']}", '', false);
// $silo = $silo_res->fetch_assoc();
// $table_data = $table_data . "
// |
// |
// |
// |
// |
//
// ";
// $data = $data . ["BA {$bins_trans['batch_id']}", "{$variety['name']}", "{$bins_trans['amount']}", "{$bins_trans['date']}", "{$silo['name']}"];
// }
// }
// } else {
// $table_data = "
// | NO RESULTS |
//
";
// }
//GET ALL THE SILIOS
// $silo_name = $db->exec_query('silos', ['*'], '', '', '', '', '', '', false);
// while ($silo = $silo_name->fetch_assoc()) {
// $batch_res = $db->exec_query('batch', ['*'], '', '', '', '', "variety_id = {$silo['variety_id']}", '', false);
// $batch = $batch_res->fetch_assoc();
// $data = $data . "
//
// {$silo['name']}
//
// |
// |
// |
// |
// |
//
// exec_query('batches', ['*'], '', '', '', 'order by record_id DESC', "status = 'COMPLETE'", '', false);
if ($batches->num_rows > 0) {
while ($batch = $batches->fetch_assoc()) {
$bins_trans_res = $db->exec_query('bins_trans', ['*'], '', '', '', '', "silo_id <> 0", 'order by record_id desc', false);
if ($bins_trans_res->num_rows > 0) {
while ($bins_trans = $bins_trans_res->fetch_assoc()) {
$variety_res = $db->exec_query('variety', ['*'], '', '', '', '', "record_id = {$bins_trans['variety_id']}", '', false);
$variety = $variety_res->fetch_assoc();
$silo_res = $db->exec_query('silos', ['*'], '', '', '', '', "record_id = {$bins_trans['silo_id']}", '', false);
$silo = $silo_res->fetch_assoc();
$silo_data = $silo_data . "
|
|
|
|
|
";
}
} else {
$silo_data = $silo_data . "
| NO RESULTS |
";
}
}
} else {
$silo_data = "
| NO RESULTS |
";
}
//GET THE TOTAL NUMBER OF SILOS
$silo_count_res = $db->exec_query('silos', ['*'], '', '', '', '', 1, '', false);
$silo_count = $silo_count_res->num_rows;
$silo_table = $silo_table . "
| BATCH ID |
VARIETY |
AMOUNT |
DATE |
SILO |
$silo_data
";
// create a table of each and every silo
// for ($i = 1; $i <= $silo_count; $i++) {
// $silo_table;
// }
?>