query("users", "SELECT * FROM users WHERE record_id = $user_id");
$data = $results->fetch_assoc();
return $data['username'];
}
function get_user_email($user_id)
{
$db = new db_safeguard();
$results = $db->query("users", "SELECT * FROM users WHERE record_id = $user_id");
$data = $results->fetch_assoc();
return $data['email'];
}
function get_job_card_status($status_id)
{
switch ($status_id) {
case 0:
$status = 'INACTIVE';
break;
case 1:
$status = 'SEND TO TECHNICIAN';
break;
case 2:
$status = 'SEND TO PJ';
break;
case 3:
$status = 'SEND TO QUOTATION';
break;
case 4:
$status = 'WAITING FOR PO';
break;
case 5:
$status = 'WAITING FOR PARTS';
break;
case 6:
$status = 'CLIENT DECLINED';
break;
case 7:
$status = 'SEND TO TECHNICIAN FOR WORK';
break;
case 8:
$status = 'SEND FOR INVOICING';
break;
case 9:
$status = 'INVOICED';
break;
case 10:
$status = 'PJ TO ASSIGN';
break;
case 11:
$status = 'WARRANTY NO CHARGE';
break;
}
return $status;
}
function get_stock_name($stock_id)
{
$db = new db_safeguard();
$results = $db->query("stock", "SELECT * FROM stock WHERE record_id = $stock_id");
$data = $results->fetch_assoc();
return $data['description'];
}
function get_po_number($po_id)
{
$db = new db_safeguard();
$results = $db->query("orders", "SELECT * FROM orders WHERE record_id = $po_id");
$data = $results->fetch_assoc();
return $data['po_number'];
}
function get_stock_price($stock_id)
{
$db = new db_safeguard();
$results = $db->query("stock", "SELECT * FROM stock WHERE record_id = $stock_id");
$data = $results->fetch_assoc();
return $data['cost_price'];
}
function send_for_email(array $emails, array $names, $subject, $message)
{
// implode array into string
$emails = implode(",", $emails);
// implode names into string
$names = implode(",", $names);
// send email
$db = new db_safeguard();
$message = str_replace("'", "*", $message);
$message = str_replace('"', "~", $message);
$db->query("events_manager", "INSERT INTO `events_manager`(`email_accounts`, `email_names`, `subject`, `message_html`, `sent`,`user_id`) VALUES ('$emails','$names','$subject','$message',0,{$_SESSION['user_id']})");
}
function get_supplier_name($supplier_id)
{
$db = new db_safeguard();
$results = $db->query("suppliers", "SELECT * FROM suppliers WHERE record_id = $supplier_id");
if ($results->num_rows > 0) {
$row = $results->fetch_assoc();
return $row["name"];
} else {
return "NO SUPPLIER NAME FOUND";
}
}
function stock_datalist()
{
$db = new db_safeguard();
$datalist = "";
return $datalist;
}
function stock_datalist_into_session()
{
$db = new db_safeguard();
$datalist = "";
$_SESSION['stock_datalist'] = $datalist;
}
function get_job_card_datalist()
{
$db = new db_safeguard();
$jobcard_numbers_res = $db->query("job_cards", "SELECT * FROM job_cards WHERE `status` = 1");
$job_card_datalist = "";
return $job_card_datalist;
}
function get_job_cards_into_session()
{
$db = new db_safeguard();
$jobcard_numbers_res = $db->query("job_cards", "SELECT * FROM job_cards WHERE `status` = 1");
$job_card_datalist = "";
$_SESSION['job_cards_list'] = $job_card_datalist;
}
}
class signature
{
function __construct($html_input_for_file_name = '', $save_is_submit = 0, $width = 300, $height = 200)
{
?>
Signature Pad