' . MENU_REPORT . '
' . MENU_VENDOR_ADDRESS_LIST . '
';
if ($_POST['date_from'] != '') {
$msg .= REPORT_FROM . ': ' . $_POST['date_from'];
}
if ($_POST['date_to'] != '') {
$msg .= ' ' . REPORT_TO . ': ' . $_POST['date_to'];
}
if ($_POST['vendor_code'] != '') {
$msg .= '
' . TABLE_CODE . ': ' . $_POST['vendor_code'];
}
if ($_POST['other'] != '') {
$msg .= ' ' . TABLE_OTHER . ': ' . $_POST['other'];
}
if ($_POST['province'] != '') {
$msg .= '
' . TABLE_PROVINCE . ': ' . getNameById($_POST['province'], 'provinces');
}
if ($_POST['district'] != '') {
$msg .= ' ' . TABLE_DISTRICT . ': ' . getNameById($_POST['district'], 'districts');
}
if ($_POST['commune'] != '') {
$msg .= ' ' . TABLE_COMMUNE . ': ' . getNameById($_POST['commune'], 'communes');
}
if ($_POST['village'] != '') {
$msg .= ' ' . TABLE_VILLAGE . ': ' . getNameById($_POST['village'], 'villages');
}
if ($_POST['created_by'] != '') {
$msg .= ' ' . TABLE_CREATED_BY . ': ' . getUserNameById($_POST['created_by']);
}
echo $this->element('/print/header-report', array('msg' => $msg));
$sql = " SELECT Vendor.id,
Vendor.vendor_code,
Vendor.name,
Vendor.work_telephone,
Vendor.other_number,
Vendor.fax_number,
Vendor.email_address,
Vendor.address
FROM vendors AS Vendor ";
$sql_query = $sql . ($condition != '' ? ' WHERE ' . $condition : $condition) . " LIMIT " . $start . ", " . $_POST['number_show'];
$query = mysql_query($sql_query);
while ($data = mysql_fetch_array($query)) {
?>
|
{$data['name']}" ?>
|
Tel: {$data['work_telephone']}
Email: {$data['email_address']}" ?>
|
