add_styles_page(); // $html->check_user_type("ADMIN"); //get all batches $all_batches_res = $db->query("batches", "SELECT * FROM batches WHERE status != 'COMPLETE' AND status != 'LOADED BEFORE' AND sound_not_sound = 'YES' ORDER BY batch_id DESC"); echo "SELECT * FROM batches WHERE status != 'COMPLETE' AND status != 'LOADED BEFORE' ORDER BY batch_id DESC"; if ($all_batches_res->num_rows > 0) { while ($all_batches = $all_batches_res->fetch_assoc()) { if ($all_batches['status'] == "BATCH RECEIVED") { $table_data = $table_data . " {$all_batches['batch_id']} {$all_batches['variety_id']} {$all_batches['date']} {$all_batches['moisture']}% {$all_batches['status']} {$all_batches['weight']} "; } else if ($all_batches['status'] == "DEHUSKING") { $table_data = $table_data . " BA {$all_batches['record_id']} {$all_batches['variety_id']} {$all_batches['date']} {$all_batches['moisture']}% {$all_batches['status']} {$all_batches['weight']} "; } else if ($all_batches['status'] == "DRYING BINS") { $table_data = $table_data . " BA {$all_batches['record_id']} {$all_batches['variety_id']} {$all_batches['date']} {$all_batches['moisture']}% {$all_batches['status']} {$all_batches['weight']} "; } else if ($all_batches['status'] == "SILO") { $table_data = $table_data . " BA {$all_batches['record_id']} {$all_batches['variety_id']} {$all_batches['date']} {$all_batches['moisture']}% {$all_batches['status']} {$all_batches['weight']} "; } else if ($all_batches['status'] == "SILO") { $table_data = $table_data . " BA {$all_batches['record_id']} {$all_batches['variety_id']} {$all_batches['date']} {$all_batches['moisture']}% {$all_batches['status']} {$all_batches['weight']} "; } } } else { $table_data = " NO BATCHES FOUND "; } ?>

CURRENT BATCHES IN TRANSITION

BATCH ID:

VARIETY:

DATE RECEIVED:

MOISTURE:

WEIGHT: