PHP display_workorders示例

示例#1

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

}
if ($date_format == "%m/%d/%Y") {
    $cur_date = $m . "/" . $d . "/" . $Y;
}
$smarty->assign('Y', $Y);
$smarty->assign('m', $m);
$smarty->assign('d', $d);
/* display new Workorders */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(1);
$smarty->assign('new', display_workorders($db, $page_no, $where));
/* display new Workorders */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(2);
$smarty->assign('assigned', display_workorders($db, $page_no, $where));
/* display new Workorders */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(3);
$smarty->assign('awaiting', display_workorders($db, $page_no, $where));
if (isset($VAR['submit'])) {
    if (!insert_new_schedule($db, $VAR)) {
        /* If db insert fails send em the error */
        $day = $VAR['start']['schedule_date'];
        $start_time = $VAR['start']['Time_Hour'] . ":" . $VAR['start']['Time_Minute'] . " " . $VAR['start']['Time_Meridian'];
        $notes = $VAR['schedule_notes'];
        $end_time = $VAR['end']['Time_Hour'] . ":" . $VAR['end']['Time_Minute'] . " " . $VAR['end']['Time_Meridian'];
        $smarty->assign('end_time', $end_time);
        $smarty->assign('start_day', $day);
        $smarty->assign('start_time', $start_time);
        $smarty->assign('schedule_notes', $notes);
        $smarty->assign('tech', $VAR['tech']);
        $smarty->assign('wo_id', $VAR['wo_id']);
        $smarty->display("schedule/new.tpl");
        //force_page('schedule','main&y='.$s_year.'&d='.$s_month.'&m='.$s_day.'&wo_id='.$VAR['wo_id'].'&page_title=schedule&tech='.$VAR['tech']);

示例#2

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

<?php

require_once 'include.php';
if (!xml2php("workorder")) {
    $smarty->assign('error_msg', "Error in language file");
}
// Get the page number we are on if first page set to 1
if (!isset($VAR["page_no"])) {
    $page_no = 1;
} else {
    $page_no = $VAR['page_no'];
}
/* display new Workorders */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(1);
$smarty->assign('new', display_workorders($db, $page_no, $where));
/* display assigned Workorders */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(2);
$smarty->assign('assigned', display_workorders($db, $page_no, $where));
/* display Workorders awaiting parts  */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(3);
$smarty->assign('awaiting', display_workorders($db, $page_no, $where));
/* display work orders that need payment */
$where = "WHERE " . PRFX . "TABLE_WORK_ORDER.WORK_ORDER_CURRENT_STATUS= " . $db->qstr(7);
$smarty->assign('payment', display_workorders($db, $page_no, $where));
//$smarty->assign('new_workorder', display_workorders($db, $page_no,$where));
$smarty->display('workorder' . SEP . 'main.tpl');