add_styles_page(); $date_time = date("Y-m-d H:i", strtotime("+2 Hours")); if (isset($_GET['record_id'])) { $lop_res = $db->query("lop_jobcard", "SELECT * FROM lop_jobcard WHERE record_id = '" . $_GET['record_id'] . "' "); $lop = $lop_res->fetch_assoc(); $lop_record_id = $lop['record_id']; } else { $lop_res = $db->query("lop_jobcard", "SELECT jobcard_no FROM lop_jobcard ORDER BY record_id DESC LIMIT 1"); if ($lop_res->num_rows == 0) { $jobcard_no = 1; } else { $lop = $lop_res->fetch_assoc(); $jobcard_no = $lop['jobcard_no'] + 1; } $lop_record_id = $db->query("lop_jobcard", "INSERT INTO lop_jobcard (jobcard_no) VALUES ('" . $jobcard_no . "')"); echo ""; } $lop_id = new input(); $lop_id->type("hidden"); $lop_id->name("lop_id"); $lop_id->id("lop_id"); $lop_id->placeholder("LOP JC NO"); $lop_id->value($lop_record_id); $record_id = new input(); $record_id->type("hidden"); $record_id->name("record_id"); $record_id->id("record_id"); $record_id->placeholder(""); $record_id->value($lop_record_id); $product_id_label = new label(); $product_id_label->for("product_id_label"); $product_id_label->value("Product Identification"); $product_id = new input(); $product_id->type("text"); $product_id->name("product_id"); $product_id->id("product_id"); $product_id->placeholder("Product ID"); $product_id->style("width: 20%"); $product_id->value($lop['product_no']); $jobcard_date_opened_label = new label(); $jobcard_date_opened_label->for("date_opened_label"); $jobcard_date_opened_label->value("Date Jobcard Opened"); $jobcard_date_opened = new input(); $jobcard_date_opened->type("datetime-local"); $jobcard_date_opened->name("jobcard_date_opened"); $jobcard_date_opened->id("jobcard_date_opened"); $jobcard_date_opened->value($lop['date_jobcard_opened']); $checked_by_production_label = new label(); $checked_by_production_label->for("checked_by_label"); $checked_by_production_label->value("Checked By (Production)"); $checked_by_production = new input(); $checked_by_production->type("text"); $checked_by_production->name("production_checked_by"); $checked_by_production->id("production_checked_by"); $checked_by_production->placeholder("Checked By (Production)"); $checked_by_production->style("width: 40%"); $checked_by_production->value($lop['checked_by_production']); $checked_by_quality_control_label = new label(); $checked_by_quality_control_label->for("checked_by_label"); $checked_by_quality_control_label->value("Checked By (Quality Control)"); $user_id = $_SESSION['user_id']; $username_res = $db->query("users", "SELECT username FROM users WHERE record_id = $user_id"); $username = $username_res->fetch_assoc(); $checked_by_quality_control = new input(); $checked_by_quality_control->type("text"); $checked_by_quality_control->name("quality_control_checked_by"); $checked_by_quality_control->id("quality_control_checked_by"); $checked_by_quality_control->placeholder("Checked By (Quality Control)"); $checked_by_quality_control->value($lop['checked_by_quality_control']); $checked_by_quality_control->style("width: 40%"); $room_number_label = new label(); $room_number_label->for("room_number_label"); $room_number_label->value("Room Number"); $room_number = new input(); $room_number->type("text"); $room_number->name("room_number"); $room_number->id("room_number"); $room_number->placeholder("Room Number"); $room_number->value($lop['room_no']); // $room_number->style("width: 20%"); $trolley_mass_label = new label(); $trolley_mass_label->for("trolley_mass_label"); $trolley_mass_label->value("Mass placed on trolley (Kg)"); $trolley_no_label = new label(); $trolley_no_label->for("trolley_no_label"); $trolley_no_label->value("Number of Trolleys"); $trolley_no = new input(); $trolley_no->type("number"); $trolley_no->name("trolley_no"); $trolley_no->id("trolley_no"); $trolley_no->placeholder("Trolley Number"); $trolley_no->value($lop['number_of_trolleys'] + 0);// $trolley_no->style("width: 20%"); $batch_no_label = new label(); $batch_no_label->for("batch_no_label"); $batch_no_label->value("Batch No"); $batch_no = new input(); $batch_no->type("text"); $batch_no->name("batch_no"); $batch_no->id("batch_no"); $batch_no->placeholder("Batch No"); $batch_no->style("width: 20%"); $batch_no->value($lop['batch_no']); // EQUIPMENT SECTION $equipment_label = new label(); $equipment_label->for("equipment_label"); $equipment_label->value("Equipment"); $equipment_settings_label = new label(); $equipment_settings_label->for("equipment_settings_label"); $equipment_settings_label->value("Equipment Settings & specifications"); $accurate_label = new label(); $accurate_label->for("accurate_label"); $accurate_label->value("Accurate (YES/NO)"); $temperature_settings = new input(); $temperature_settings->type("text"); $temperature_settings->name("temperature_settings"); $temperature_settings->id("temperature_settings"); $temperature_settings->placeholder("C"); $temperature_settings->style("width: 90%"); $temperature_accurate = new select(); $temperature_accurate->name("temperature_accurate"); $temperature_accurate->id("temperature_accurate"); $temperature_accurate->add_option("", "SELECT ACCURATE"); $temperature_accurate->add_option("YES", "YES"); $temperature_accurate->add_option("NO", "NO"); $temperature_accurate->style("width: 90%"); $humidity_settings = new input(); $humidity_settings->type("text"); $humidity_settings->name("humidity_settings"); $humidity_settings->id("humidity_settings"); $humidity_settings->placeholder("List of settings to be verified before start-up"); $humidity_settings->style("width: 90%"); $humidity_accurate = new select(); $humidity_accurate->name("humidity_accurate"); $humidity_accurate->id("humidity_accurate"); $humidity_accurate->add_option("", "SELECT ACCURATE"); $humidity_accurate->add_option("YES", "YES"); $humidity_accurate->add_option("NO", "NO"); $humidity_accurate->style("width: 90%"); $submit_btn = new button(); $submit_btn->class("submit_btn"); $submit_btn->value("Submit"); $submit_btn->id("submit_btn"); ?>

LOP ROOMS JOBCARD

add(); $jobcard_date_opened_label->add(); $jobcard_date_opened->add(); $product_id_label->add(); $product_id->add(); $checked_by_quality_control_label->add(); $checked_by_quality_control->add(); $checked_by_production_label->add(); $checked_by_production->add(); $trolley_mass_label->add(); ?>
add(); $room_number->add(); ?>
add(); $trolley_no->add(); ?>
add(); $batch_no->add(); ?>


EQUIPMENT CHECKLIST


query("lop_equipment_check_list", "SELECT * FROM lop_equipment_check_list WHERE lop_id = '" . $lop_record_id . "' ORDER BY record_id, equipment_id ASC"); if ($equipment_check_res->num_rows > 0) { while ($equipment_check = $equipment_check_res->fetch_assoc()) { // check if equipment is already checked $show = 0; ?> query("equipment_list", "SELECT * FROM equipment_list WHERE 1 ORDER BY record_id ASC"); while ($equipment = $equipment_res->fetch_assoc()) { $show = 1; // check if equipment is already checked ?> "> []" value="Equipment appears clean and free from damage">
EQUIPMENT QUESTION ANSWER DATE USER
get_equipment($equipment_check["equipment_id"]); ?> get_username($equipment_check["user_id"]); ?>
Equipment appears clean and free from damage
[]" value="No signs of excessive wear, rust, or corrosion"> No signs of excessive wear, rust, or corrosion
[]" value="All guards, covers, and shields are securely fitted"> All guards, covers, and shields are securely fitted
[]" value="Moving parts operate smoothly without obstruction"> Moving parts operate smoothly without obstruction
[]" value="Power cables and plugs are intact and undamaged"> Power cables and plugs are intact and undamaged
>


Standard Operating procedure: Sampling of nuts for evaluation
Step 1 Take a random sample of cracked nuts per batch daily on the different trolleys
Step 2 Measure the moisture %
Step 3 Record the moisture on the job card
Step 4 Report any deviations


query("lop_food_safety_inspections", "SELECT * FROM lop_food_safety_inspections WHERE lop_jobcard_no = '$lop_record_id' ORDER BY record_id DESC LIMIT 1"); if ($check_res->num_rows > 0) { $check = $check_res->fetch_assoc(); $comment_res = $db->query("lop_food_comments", "SELECT * FROM lop_food_comments WHERE lop_jobcard_no = '$lop_record_id' ORDER BY record_id DESC LIMIT 1"); if ($comment_res->num_rows > 0) { $comment = $comment_res->fetch_assoc(); } else { $comment[] = ""; } } else { $check[] = ""; } ?>
Food Safety Inspections
Food safety Inspection criteria/ points: Select/ complete: Comment:
Equipment Clean & sanitized
LOP room clean?
No pest acitivity noted?
No off smells or taints?
Air/ dust extraction system operational?
No visual contamination risks in room such as cobwebs, loose silicone, dust, water vapour, visble mould etc.?
Cheese Crates clean & free from foreign objects?
Is there traceability available for each trolley?


QUALITY CHECKS


query("lop_quality_process_control", "SELECT * FROM lop_quality_process_control WHERE lop_id = '$lop_record_id'"); if ($quality_results->num_rows > 0) { while ($quality = $quality_results->fetch_assoc()) { ?>
0% 0% < 1% 18 -24°C 45 - 55 RH
Mouldy Kernel Rancid/off-smell kernel Kernel Moisture % Env. Temperature Env. Humidity Discolouration Person Inspecting Signature
query("users", "SELECT * FROM users WHERE record_id = '" . $quality['person_inspecting'] . "'"); $user = $user_res->fetch_assoc()['username']; ?> signature
× add(); ?>

QUALIITY & PROCESS CONTROL TRACK INFORMATION:

for("datetime_label"); $datetime->value("Date & time"); $datetime->add(); ?>
for("shift_label"); $shift_label->value("Shift (Day / Night)"); $shift_label->add(); ?>
for("sample_size_label"); $sample_size_label->value("Sample Size (Kg)"); $sample_size_label->add(); ?>

SPECIFICATION / GUIDANCE ON ELEVATION

for("trolley_number_label"); $trolley_number_label->value("Trolley Number"); $trolley_number_label->add(); ?>
for("trolley_position_label"); $trolley_position_label->value("Trolley Position"); $trolley_position_label->add(); ?>



0% 0% < 1% 18 -24°C 45 - 55 RH
Mouldy Kernel Rancid/off-smell kernel Kernel Moisture % Env. Temperature Env. Humidity Discolouration Person Inspecting
name("person_inspecting"); $person_inspecting->id("person_inspecting"); $person_inspecting->class("inputs"); $person_inspecting->style("margin: 0vw;width: 100%;"); $person_inspecting->fill_from_db("users", "record_id", "username"); $person_inspecting->add(); ?>

SIGNATURE



for("date_jobcard_closed"); $date_jobcard_closed_label->value("Date Jobcard Closed"); $date_jobcard_closed_label->add(); $date_jobcard_closed = new input(); $date_jobcard_closed->type("datetime-local"); $date_jobcard_closed->id("jobcard_closed"); $date_jobcard_closed->name("jobcard_closed"); $date_jobcard_closed->value($lop['jobcard_date_closed']); $date_jobcard_closed->add(); ?>