PHP display_workorder_status示例

示例#1

文件： view.php 项目： jewelhuq/myitcrm1

/* Lets Grab Technicians Names */
$q = "SELECT EMPLOYEE_LOGIN, EMPLOYEE_ID FROM " . PRFX . "TABLE_EMPLOYEE WHERE EMPLOYEE_STATUS=1";
if (!($rs = $db->execute($q))) {
    force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
    exit;
}
$tech = $rs->GetMenu2('assign_val', $login, $login_id);
$smarty->assign('tech', $tech);
if (!($single_work_order = display_single_open_workorder($db, $VAR['wo_id']))) {
    force_page('core', "error&menu=1&error_msg=The Work Order you requested was not found&type=error");
    exit;
}
$smarty->assign('single_workorder_array', $single_work_order);
$smarty->assign('work_order_notes', display_workorder_notes($db, $VAR['wo_id']));
$smarty->assign('order', display_parts($db, $VAR['wo_id']));
$smarty->assign('work_order_status', display_workorder_status($db, $VAR['wo_id']));
$smarty->assign('work_order_sched', get_work_order_schedule($db, $VAR['wo_id']));
$smarty->assign('resolution', display_resolution($db, $VAR['wo_id']));
if (isset($VAR['submit'])) {
    $sql = "DELETE FROM " . PRFX . "TABLE_WORK_ORDER WHERE WORK_ORDER_ID=" . $db->qstr($wo_id);
    if (!($result = $db->Execute($sql))) {
        force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
        exit;
    }
    //Write comment to log
    $month = date("M");
    $day = date("d");
    $year = date("Y");
    $time = date("H") . ":" . date("i") . ":" . date("s");
    //get environment variables
    $hostname = gethostbyaddr($_SERVER['REMOTE_ADDR']);

示例#2

文件： include.php 项目： jewelhuq/myitcrm1

    return $work_order_notes;
}
#############################
# Display Work Order Status #
#############################
function display_workorder_status($db, $wo_id)
{
    $sql = "SELECT " . PRFX . "TABLE_WORK_ORDER_STATUS.*, " . PRFX . "TABLE_EMPLOYEE.EMPLOYEE_DISPLAY_NAME \n\t\t\t\tFROM " . PRFX . "TABLE_WORK_ORDER_STATUS, " . PRFX . "TABLE_EMPLOYEE \n\t\t\t\tWHERE  " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_ID=" . $db->qstr($wo_id) . " \n\t\t\t\tAND " . PRFX . "TABLE_EMPLOYEE.EMPLOYEE_ID = " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_STATUS_ENTER_BY ORDER BY " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_STATUS_ID";
    if (!($result = $db->Execute($sql))) {
        force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
        exit;
    }
    $work_order_status = $result->GetArray();
    return $work_order_status;
}
$smarty->assign('wo_stat', display_workorder_status($db, $wo_id));
#########################################
# Display Customer Contact Information	#
#########################################
function display_customer_info($db, $customer_id)
{
    $sql = "SELECT * FROM " . PRFX . "TABLE_CUSTOMER WHERE CUSTOMER_ID=" . $db->qstr($customer_id);
    if (!($result = $db->Execute($sql))) {
        force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
        exit;
    }
    $customer_array = $result->GetArray();
    return $customer_array;
}
#############################################################
# Display all open Work orders to                           #

示例#3

文件： print.php 项目： jewelhuq/myitcrm1

<?php

require_once "include.php";
if (!($single_work_order = display_single_open_workorder($db, $VAR['wo_id']))) {
    force_page('core', "error&menu=1&error_msg=The Work Order you Requested was not found&type=error");
    exit;
} else {
    /* get company Information */
    $q = "SELECT * FROM " . PRFX . "TABLE_COMPANY";
    $rs = $db->execute($q);
    $company = $rs->GetArray();
    /* Work order notes */
    $work_order_notes = display_workorder_notes($db, $VAR['wo_id']);
    /* work order Status */
    $work_order_status = display_workorder_status($db, $VAR['wo_id']);
    /* work order schedule */
    $work_order_sched = get_work_order_schedule($db, $VAR['wo_id']);
    /* work order resolution */
    $work_order_res = display_resolution($db, $VAR['wo_id']);
}
/* get printing options */
$q = "SELECT  HTML_PRINT, PDF_PRINT FROM " . PRFX . "SETUP";
$rs = $db->execute($q);
$html_print = $rs->fields['HTML_PRINT'];
$pdf_print = $rs->fields['PDF_PRINT'];
if ($html_print == 1) {
    /* htm print page */
    $smarty->assign('company', $company);
    $smarty->assign('single_workorder_array', $single_work_order);
    $smarty->assign('work_order_notes', $work_order_notes);
    $smarty->assign('work_order_status', $work_order_status);