add_styles_page(); // $html->check_user_type("ADMIN"); $db = new db_safeguard(); // $team_assigned_id = new select(); // $team_assigned_id->class("inputs"); // $team_assigned_id->name("team_assigned_id"); // $team_assigned_id->id("team_assigned_id"); // $team_assigned_id->add_option("", "TEAM"); // $team_assigned_id->fill_from_db("teams", "record_id", "name"); // $team_assigned_id->onchange("search_jobcard()"); // $user_id = new select(); // $user_id->class("inputs"); // $user_id->name("user_assigned"); // $user_id->id("user_assigned"); // $user_id->add_option("", "USER ID"); // $user_id->fill_from_db("users", "record_id", "username"); // $user_id->onchange("search_jobcard()"); // $contact_number = new input(); // $contact_number->class("inputs"); // $contact_number->name("contact_number"); // $contact_number->id("contact_number"); // $contact_number->placeholder("CONTACT NUMBER"); // $contact_number->onkeyup("search_jobcard()"); // $jobcard_id = new input(); // $jobcard_id->class("inputs"); // $jobcard_id->type("text"); // $jobcard_id->placeholder("JOBCARD NUMBER"); // $jobcard_id->name("jc_no"); // $jobcard_id->id("jc_no"); // $jobcard_id->onkeyup("search_jobcard()"); // > //

// // run_on_load(); // $ajax->function_name("search_jobcard"); // $ajax->select("jobcards"); // $ajax->return_columns(['jc_no', 'address', 'contact_number', 'date_created']); // $ajax->redirect("reports.php"); // ?> query("jobcards", "SELECT * FROM jobcards WHERE user_assigned != '0' AND team_assigned_id != '3' ORDER BY jc_no DESC"); if ($jobcards_res->num_rows > 0) { while ($jobcards = $jobcards_res->fetch_assoc()) { $team_assigned_res = $db->query( "teams", "SELECT * FROM teams WHERE record_id = {$jobcards['team_assigned_id']}" ); $team_assigned = $team_assigned_res->fetch_assoc(); $table_data .= " {$jobcards['jc_no']} {$team_assigned['name']} {$jobcards['contact_number']} {$jobcards['address']} {$jobcards['date_created']} "; } } else { $table_data = " NO STOCK BOOKED "; } ?>

JOBCARD ID	TEAM ASSIGNED	CONTACT NUMBER	AREA	DATE CREATED