$q = "SELECT * FROM " . PRFX . "TABLE_CUSTOMER_EMAILS WHERE CUSTOMER_ID ='" . $customer_id . "' ORDER BY CUSTOMER_EMAIL_ID DESC"; $rs = $db->Execute($q); $customer_emails = $rs->GetArray(); $smarty->assign('customer_emails', $customer_emails); /*Get Customer Info */ $q = "SELECT * FROM " . PRFX . "TABLE_CUSTOMER WHERE CUSTOMER_ID ='" . $customer_id . "'"; $rs = $db->Execute($q); $customer_details = $rs->GetArray(); $smarty->assign('customer_details', $customer_details); /*Get Employee Info */ $q = "SELECT * FROM " . PRFX . "TABLE_EMPLOYEE WHERE EMPLOYEE_DISPLAY_NAME ='" . $login . "'"; $rs = $db->Execute($q); $employee_details = $rs->FetchRow(); $smarty->assign('employee_details', $employee_details); // assign the arrays $smarty->assign('open_work_orders', display_open_workorders($db, $customer_id)); $smarty->assign('closed_work_orders', display_closed_workorders($db, $customer_id)); //$smarty->assign('customer_details', display_customer_info($db, $customer_id)); $smarty->assign('customer_details', $customer_details); $smarty->assign('unpaid_invoices', display_unpaid_invoices($db, $customer_id)); $smarty->assign('paid_invoices', display_paid_invoices($db, $customer_id)); $smarty->assign('memo', display_memo($db, $customer_id)); $smarty->assign('gift', display_gift($db, $customer_id)); $smarty->assign('company_details', display_company_info($db, $company_id)); //Lets Get the file downloaded to have a look at it from the database if (isset($download_id)) { /*Get All customer Emails */ $q = "SELECT CUSTOMER_EMAIL_ATT_NAME1, CUSTOMER_EMAIL_ATT_TYPE1, CUSTOMER_EMAIL_ATT_SIZE1, CUSTOMER_EMAIL_ATT_FILE1, FROM " . PRFX . "TABLE_CUSTOMER_EMAILS WHERE CUSTOMER_EMAIL_ID ='" . $download_id . "'"; $rs = $db->Execute($q); //header("Content-length: $rs->fields['CUSTOMER_EMAIL_ATT_SIZE1']"); //header("Content-type: $rs->fields['CUSTOMER_EMAIL_ATT_TYPE1']");
<?php require_once 'modules' . SEP . 'workorder' . SEP . 'include.php'; $smarty->assign('return_array', display_open_workorders($db)); $smarty->display('workorder' . SEP . 'blocks' . SEP . 'open_work_orders_block.tpl');
<?php require_once "include.php"; if (!xml2php("employees")) { $smarty->assign('error_msg', "Error in language file"); } // Get the customers id from the url $employee_id = $VAR['employee_id']; // assign the arrays $smarty->assign('open_work_orders', display_open_workorders($db, $employee_id)); $smarty->assign('employee_details', display_employee_info($db, $employee_id)); $smarty->display('employees' . SEP . 'employee_details.tpl');