$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');
