add_styles_page(); $db = new db_safeguard(); //get all batches $batch_tot_res = $db->query("batch_data", "SELECT batch_no FROM batch_data"); $batch_tot = $batch_tot_res->num_rows; $date = new DateTime(); $year = $date->format("y"); $month = $date->format("m"); $day = $date->format("d"); $batch_no_res = $db->query("batch_data", "SELECT batch_no FROM batch_data ORDER BY batch_no DESC LIMIT 1"); $no_batch = $batch_no_res->num_rows; if ($no_batch > 0) { if ($batch_no_data = $batch_no_res->fetch_assoc()) { $batch_no_count = substr($batch_no_data['batch_no'], strpos($batch_no_data['batch_no'], "-") + 1); // echo $batch_no_count; $batch_no_count = $batch_no_count + 1; // echo $batch_no_count; $batch_no = $year . "-" . $batch_no_count . "-" . $month . $day . "-" . $batch_tot; } } else { $batch_no_count = "01"; //generate 3 random letters $unique_letters = chr(rand(65, 90)) . chr(rand(65, 90)) . chr(rand(65, 90)); $batch_number = $unique_letters . "-" . $day . $month . $year . "-" . $batch_no_count; //convert batch_no to string $batch_num = strval($batch_number); // echo $batch_no; } $silo_data_res = $db->query("silos", "SELECT * FROM silos"); $silo_data = []; $silo_data[] = " "; if ($silo_data_res->num_rows > 0) { while ($silo_data_row = $silo_data_res->fetch_assoc()) { // echo $silo_data_row['name']; $silo_data[] = $silo_data_row['name']; } } $batch_no_label = new label(); $batch_no_label->for("batch_no_label"); $batch_no_label->value("BATCH NO"); $batch_no = new input(); $batch_no->class("inputs"); $batch_no->type("text"); $batch_no->name("batch_no"); $batch_no->id("batch_no"); // $batch_no->value($batch_num); $silo_label = new label(); $silo_label->for("silo_id_label"); $silo_label->value("SILO"); $silo = new select(); $silo->name("silo_id"); $silo->class("inputs"); $silo->id("silo_id"); $silo->add_option("1", "1"); $silo->add_option("2", "2"); $silo->fill_from_db("silos", "record_id", "name"); $amount_label = new label(); $amount_label->for("amount_label"); $amount_label->value("AMOUNT"); $amount = new input(); $amount->class("inputs"); $amount->type("number"); $amount->name("amount"); $amount->id("amount"); $amount->value(""); $submit_btn = new button(); // $submit_btn->type("submit"); $submit_btn->class("submit_btn"); $submit_btn->value("SUBMIT"); ?>

ADD BATCH