1142 lines
58 KiB
PHP
Executable File
1142 lines
58 KiB
PHP
Executable File
<?php
|
|
//
|
|
// +----------------------------------------------------------------------+
|
|
// |zen-cart Open Source E-commerce |
|
|
// +----------------------------------------------------------------------+
|
|
// | Copyright (c) 2003 The zen-cart developers |
|
|
// | |
|
|
// | http://www.zen-cart.com/index.php |
|
|
// | |
|
|
// | Portions Copyright (c) 2003 osCommerce |
|
|
// +----------------------------------------------------------------------+
|
|
// | This source file is subject to version 2.0 of the GPL license, |
|
|
// | that is bundled with this package in the file LICENSE, and is |
|
|
// | available through the world-wide-web at the following url: |
|
|
// | http://www.zen-cart.com/license/2_0.txt. |
|
|
// | If you did not receive a copy of the zen-cart license and are unable |
|
|
// | to obtain it through the world-wide-web, please send a note to |
|
|
// | license@zen-cart.com so we can mail you a copy immediately. |
|
|
// +----------------------------------------------------------------------+
|
|
// $Id: customers.php 3474 2006-04-21 02:20:40Z drbyte $
|
|
//
|
|
|
|
require('includes/application_top.php');
|
|
|
|
require(DIR_WS_CLASSES . 'currencies.php');
|
|
$currencies = new currencies();
|
|
|
|
$action = (isset($_GET['action']) ? $_GET['action'] : '');
|
|
|
|
$error = false;
|
|
$processed = false;
|
|
|
|
if (zen_not_null($action)) {
|
|
switch ($action) {
|
|
case 'status':
|
|
if ($_GET['current'] == CUSTOMERS_APPROVAL_AUTHORIZATION) {
|
|
$sql = "update " . TABLE_CUSTOMERS . " set customers_authorization=0 where customers_id='" . $_GET['cID'] . "'";
|
|
} else {
|
|
$sql = "update " . TABLE_CUSTOMERS . " set customers_authorization='" . CUSTOMERS_APPROVAL_AUTHORIZATION . "' where customers_id='" . $_GET['cID'] . "'";
|
|
}
|
|
$db->Execute($sql);
|
|
$action = '';
|
|
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $_GET['cID'] . '&page=' . $_GET['page'], 'NONSSL'));
|
|
break;
|
|
case 'update':
|
|
$customers_id = zen_db_prepare_input($_GET['cID']);
|
|
$customers_firstname = zen_db_prepare_input($_POST['customers_firstname']);
|
|
$customers_lastname = zen_db_prepare_input($_POST['customers_lastname']);
|
|
$customers_email_address = zen_db_prepare_input($_POST['customers_email_address']);
|
|
$customers_telephone = zen_db_prepare_input($_POST['customers_telephone']);
|
|
$customers_fax = zen_db_prepare_input($_POST['customers_fax']);
|
|
$customers_newsletter = zen_db_prepare_input($_POST['customers_newsletter']);
|
|
$customers_group_pricing = zen_db_prepare_input($_POST['customers_group_pricing']);
|
|
$customers_email_format = zen_db_prepare_input($_POST['customers_email_format']);
|
|
$customers_gender = zen_db_prepare_input($_POST['customers_gender']);
|
|
$customers_dob = (empty($_POST['customers_dob']) ? zen_db_prepare_input('0001-01-01 00:00:00') : zen_db_prepare_input($_POST['customers_dob']));
|
|
|
|
$customers_authorization = zen_db_prepare_input($_POST['customers_authorization']);
|
|
$customers_referral= zen_db_prepare_input($_POST['customers_referral']);
|
|
|
|
if (CUSTOMERS_APPROVAL_AUTHORIZATION == 2 and $customers_authorization == 1) {
|
|
$customers_authorization = 2;
|
|
$messageStack->add_session(ERROR_CUSTOMER_APPROVAL_CORRECTION2, 'caution');
|
|
}
|
|
|
|
if (CUSTOMERS_APPROVAL_AUTHORIZATION == 1 and $customers_authorization == 2) {
|
|
$customers_authorization = 1;
|
|
$messageStack->add_session(ERROR_CUSTOMER_APPROVAL_CORRECTION1, 'caution');
|
|
}
|
|
|
|
$default_address_id = zen_db_prepare_input($_POST['default_address_id']);
|
|
$entry_street_address = zen_db_prepare_input($_POST['entry_street_address']);
|
|
$entry_suburb = zen_db_prepare_input($_POST['entry_suburb']);
|
|
$entry_postcode = zen_db_prepare_input($_POST['entry_postcode']);
|
|
$entry_city = zen_db_prepare_input($_POST['entry_city']);
|
|
$entry_country_id = zen_db_prepare_input($_POST['entry_country_id']);
|
|
|
|
$entry_company = zen_db_prepare_input($_POST['entry_company']);
|
|
$entry_state = zen_db_prepare_input($_POST['entry_state']);
|
|
if (isset($_POST['entry_zone_id'])) $entry_zone_id = zen_db_prepare_input($_POST['entry_zone_id']);
|
|
|
|
if (strlen($customers_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_firstname_error = true;
|
|
} else {
|
|
$entry_firstname_error = false;
|
|
}
|
|
|
|
if (strlen($customers_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_lastname_error = true;
|
|
} else {
|
|
$entry_lastname_error = false;
|
|
}
|
|
|
|
if (ACCOUNT_DOB == 'true') {
|
|
if (ENTRY_DOB_MIN_LENGTH >0) {
|
|
if (checkdate(substr(zen_date_raw($customers_dob), 4, 2), substr(zen_date_raw($customers_dob), 6, 2), substr(zen_date_raw($customers_dob), 0, 4))) {
|
|
$entry_date_of_birth_error = false;
|
|
} else {
|
|
$error = true;
|
|
$entry_date_of_birth_error = true;
|
|
}
|
|
} else {
|
|
$customers_dob = '0001-01-01 00:00:00';
|
|
}
|
|
}
|
|
|
|
if (strlen($customers_email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_email_address_error = true;
|
|
} else {
|
|
$entry_email_address_error = false;
|
|
}
|
|
|
|
if (!zen_validate_email($customers_email_address)) {
|
|
$error = true;
|
|
$entry_email_address_check_error = true;
|
|
} else {
|
|
$entry_email_address_check_error = false;
|
|
}
|
|
|
|
if (strlen($entry_street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_street_address_error = true;
|
|
} else {
|
|
$entry_street_address_error = false;
|
|
}
|
|
|
|
if (strlen($entry_postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_post_code_error = true;
|
|
} else {
|
|
$entry_post_code_error = false;
|
|
}
|
|
|
|
if (strlen($entry_city) < ENTRY_CITY_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_city_error = true;
|
|
} else {
|
|
$entry_city_error = false;
|
|
}
|
|
|
|
if ($entry_country_id == false) {
|
|
$error = true;
|
|
$entry_country_error = true;
|
|
} else {
|
|
$entry_country_error = false;
|
|
}
|
|
|
|
if (ACCOUNT_STATE == 'true') {
|
|
if ($entry_country_error == true) {
|
|
$entry_state_error = true;
|
|
} else {
|
|
$zone_id = 0;
|
|
$entry_state_error = false;
|
|
$check_value = $db->Execute("select count(*) as total
|
|
from " . TABLE_ZONES . "
|
|
where zone_country_id = '" . (int)$entry_country_id . "'");
|
|
|
|
$entry_state_has_zones = ($check_value->fields['total'] > 0);
|
|
if ($entry_state_has_zones == true) {
|
|
$zone_query = $db->Execute("select zone_id
|
|
from " . TABLE_ZONES . "
|
|
where zone_country_id = '" . (int)$entry_country_id . "'
|
|
and zone_name = '" . zen_db_input($entry_state) . "'");
|
|
|
|
if ($zone_query->RecordCount() > 0) {
|
|
$entry_zone_id = $zone_query->fields['zone_id'];
|
|
} else {
|
|
$error = true;
|
|
$entry_state_error = true;
|
|
}
|
|
} else {
|
|
if ($entry_state == false) {
|
|
$error = true;
|
|
$entry_state_error = true;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
if (strlen($customers_telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
|
|
$error = true;
|
|
$entry_telephone_error = true;
|
|
} else {
|
|
$entry_telephone_error = false;
|
|
}
|
|
|
|
$check_email = $db->Execute("select customers_email_address
|
|
from " . TABLE_CUSTOMERS . "
|
|
where customers_email_address = '" . zen_db_input($customers_email_address) . "'
|
|
and customers_id != '" . (int)$customers_id . "'");
|
|
|
|
if ($check_email->RecordCount() > 0) {
|
|
$error = true;
|
|
$entry_email_address_exists = true;
|
|
} else {
|
|
$entry_email_address_exists = false;
|
|
}
|
|
|
|
if ($error == false) {
|
|
|
|
$sql_data_array = array('customers_firstname' => $customers_firstname,
|
|
'customers_lastname' => $customers_lastname,
|
|
'customers_email_address' => $customers_email_address,
|
|
'customers_telephone' => $customers_telephone,
|
|
'customers_fax' => $customers_fax,
|
|
'customers_group_pricing' => $customers_group_pricing,
|
|
'customers_newsletter' => $customers_newsletter,
|
|
'customers_email_format' => $customers_email_format,
|
|
'customers_authorization' => $customers_authorization,
|
|
'customers_referral' => $customers_referral
|
|
);
|
|
|
|
if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $customers_gender;
|
|
if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = ($customers_dob == '0001-01-01 00:00:00' ? '0001-01-01 00:00:00' : zen_date_raw($customers_dob));
|
|
|
|
zen_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("update " . TABLE_CUSTOMERS_INFO . "
|
|
set customers_info_date_account_last_modified = now()
|
|
where customers_info_id = '" . (int)$customers_id . "'");
|
|
|
|
if ($entry_zone_id > 0) $entry_state = '';
|
|
|
|
$sql_data_array = array('entry_firstname' => $customers_firstname,
|
|
'entry_lastname' => $customers_lastname,
|
|
'entry_street_address' => $entry_street_address,
|
|
'entry_postcode' => $entry_postcode,
|
|
'entry_city' => $entry_city,
|
|
'entry_country_id' => $entry_country_id);
|
|
|
|
if (ACCOUNT_COMPANY == 'true') $sql_data_array['entry_company'] = $entry_company;
|
|
if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $entry_suburb;
|
|
|
|
if (ACCOUNT_STATE == 'true') {
|
|
if ($entry_zone_id > 0) {
|
|
$sql_data_array['entry_zone_id'] = $entry_zone_id;
|
|
$sql_data_array['entry_state'] = '';
|
|
} else {
|
|
$sql_data_array['entry_zone_id'] = '0';
|
|
$sql_data_array['entry_state'] = $entry_state;
|
|
}
|
|
}
|
|
|
|
zen_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "customers_id = '" . (int)$customers_id . "' and address_book_id = '" . (int)$default_address_id . "'");
|
|
|
|
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $customers_id, 'NONSSL'));
|
|
|
|
} else if ($error == true) {
|
|
$cInfo = new objectInfo($_POST);
|
|
$processed = true;
|
|
}
|
|
|
|
break;
|
|
case 'deleteconfirm':
|
|
// demo active test
|
|
if (zen_admin_demo()) {
|
|
$_GET['action']= '';
|
|
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
|
|
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
|
|
}
|
|
$customers_id = zen_db_prepare_input($_GET['cID']);
|
|
|
|
if (isset($_POST['delete_reviews']) && ($_POST['delete_reviews'] == 'on')) {
|
|
$reviews = $db->Execute("select reviews_id
|
|
from " . TABLE_REVIEWS . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
|
|
while (!$reviews->EOF) {
|
|
$dbExecute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
|
|
where reviews_id = '" . (int)$reviews['reviews_id'] . "'");
|
|
$reviews->MoveNext();
|
|
}
|
|
|
|
$db->Execute("delete from " . TABLE_REVIEWS . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
} else {
|
|
$db->Execute("update " . TABLE_REVIEWS . "
|
|
set customers_id = null
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
}
|
|
|
|
$db->Execute("delete from " . TABLE_ADDRESS_BOOK . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("delete from " . TABLE_CUSTOMERS . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "
|
|
where customers_info_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
|
|
where customers_id = '" . (int)$customers_id . "'");
|
|
|
|
$db->Execute("delete from " . TABLE_WHOS_ONLINE . "
|
|
where customer_id = '" . (int)$customers_id . "'");
|
|
|
|
|
|
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
|
|
break;
|
|
default:
|
|
$customers = $db->Execute("select c.customers_id, c.customers_gender, c.customers_firstname,
|
|
c.customers_lastname, c.customers_dob, c.customers_email_address,
|
|
a.entry_company, a.entry_street_address, a.entry_suburb,
|
|
a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,
|
|
a.entry_country_id, c.customers_telephone, c.customers_fax,
|
|
c.customers_newsletter, c.customers_default_address_id,
|
|
c.customers_email_format, c.customers_group_pricing,
|
|
c.customers_authorization, c.customers_referral
|
|
from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a
|
|
on c.customers_default_address_id = a.address_book_id
|
|
where a.customers_id = c.customers_id
|
|
and c.customers_id = '" . (int)$_GET['cID'] . "'");
|
|
|
|
$cInfo = new objectInfo($customers->fields);
|
|
}
|
|
}
|
|
?>
|
|
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
|
|
<html <?php echo HTML_PARAMS; ?>>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
|
|
<title><?php echo TITLE; ?></title>
|
|
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
|
|
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
|
|
<script language="javascript" src="includes/menu.js"></script>
|
|
<script language="javascript" src="includes/general.js"></script>
|
|
<?php
|
|
if ($action == 'edit' || $action == 'update') {
|
|
?>
|
|
<script language="javascript"><!--
|
|
|
|
function check_form() {
|
|
var error = 0;
|
|
var error_message = "<?php echo JS_ERROR; ?>";
|
|
|
|
var customers_firstname = document.customers.customers_firstname.value;
|
|
var customers_lastname = document.customers.customers_lastname.value;
|
|
<?php if (ACCOUNT_COMPANY == 'true') echo 'var entry_company = document.customers.entry_company.value;' . "\n"; ?>
|
|
<?php if (ACCOUNT_DOB == 'true') echo 'var customers_dob = document.customers.customers_dob.value;' . "\n"; ?>
|
|
var customers_email_address = document.customers.customers_email_address.value;
|
|
var entry_street_address = document.customers.entry_street_address.value;
|
|
var entry_postcode = document.customers.entry_postcode.value;
|
|
var entry_city = document.customers.entry_city.value;
|
|
var customers_telephone = document.customers.customers_telephone.value;
|
|
|
|
<?php if (ACCOUNT_GENDER == 'true') { ?>
|
|
if (document.customers.customers_gender[0].checked || document.customers.customers_gender[1].checked) {
|
|
} else {
|
|
error_message = error_message + "<?php echo JS_GENDER; ?>";
|
|
error = 1;
|
|
}
|
|
<?php } ?>
|
|
|
|
if (customers_firstname == "" || customers_firstname.length < <?php echo ENTRY_FIRST_NAME_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_FIRST_NAME; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
if (customers_lastname == "" || customers_lastname.length < <?php echo ENTRY_LAST_NAME_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_LAST_NAME; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
<?php if (ACCOUNT_DOB == 'true' && ENTRY_DOB_MIN_LENGTH !='') { ?>
|
|
if (customers_dob == "" || customers_dob.length < <?php echo ENTRY_DOB_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_DOB; ?>";
|
|
error = 1;
|
|
}
|
|
<?php } ?>
|
|
|
|
if (customers_email_address == "" || customers_email_address.length < <?php echo ENTRY_EMAIL_ADDRESS_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_EMAIL_ADDRESS; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
if (entry_street_address == "" || entry_street_address.length < <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_ADDRESS; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
if (entry_postcode == "" || entry_postcode.length < <?php echo ENTRY_POSTCODE_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_POST_CODE; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
if (entry_city == "" || entry_city.length < <?php echo ENTRY_CITY_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_CITY; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
<?php
|
|
if (ACCOUNT_STATE == 'true') {
|
|
?>
|
|
if (document.customers.elements['entry_state'].type != "hidden") {
|
|
if (document.customers.entry_state.value == '' || document.customers.entry_state.value.length < <?php echo ENTRY_STATE_MIN_LENGTH; ?> ) {
|
|
error_message = error_message + "<?php echo JS_STATE; ?>";
|
|
error = 1;
|
|
}
|
|
}
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
if (document.customers.elements['entry_country_id'].type != "hidden") {
|
|
if (document.customers.entry_country_id.value == 0) {
|
|
error_message = error_message + "<?php echo JS_COUNTRY; ?>";
|
|
error = 1;
|
|
}
|
|
}
|
|
|
|
if (customers_telephone == "" || customers_telephone.length < <?php echo ENTRY_TELEPHONE_MIN_LENGTH; ?>) {
|
|
error_message = error_message + "<?php echo JS_TELEPHONE; ?>";
|
|
error = 1;
|
|
}
|
|
|
|
if (error == 1) {
|
|
alert(error_message);
|
|
return false;
|
|
} else {
|
|
return true;
|
|
}
|
|
}
|
|
//--></script>
|
|
<?php
|
|
}
|
|
?>
|
|
<script type="text/javascript">
|
|
<!--
|
|
function init()
|
|
{
|
|
cssjsmenu('navbar');
|
|
if (document.getElementById)
|
|
{
|
|
var kill = document.getElementById('hoverJS');
|
|
kill.disabled = true;
|
|
}
|
|
}
|
|
// -->
|
|
</script>
|
|
</head>
|
|
<body onload="init()">
|
|
<!-- header //-->
|
|
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
|
|
<!-- header_eof //-->
|
|
|
|
<!-- body //-->
|
|
<table border="0" width="100%" cellspacing="2" cellpadding="2">
|
|
<tr>
|
|
<!-- body_text //-->
|
|
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
|
|
<?php
|
|
if ($action == 'edit' || $action == 'update') {
|
|
$newsletter_array = array(array('id' => '1', 'text' => ENTRY_NEWSLETTER_YES),
|
|
array('id' => '0', 'text' => ENTRY_NEWSLETTER_NO));
|
|
?>
|
|
<tr>
|
|
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
|
|
<tr>
|
|
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
|
|
<td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr><?php echo zen_draw_form('customers', FILENAME_CUSTOMERS, zen_get_all_get_params(array('action')) . 'action=update', 'post', 'onsubmit="return check_form(customers);"', true) . zen_draw_hidden_field('default_address_id', $cInfo->customers_default_address_id); ?>
|
|
<td class="formAreaTitle"><?php echo CATEGORY_PERSONAL; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
|
|
<?php
|
|
if (ACCOUNT_GENDER == 'true') {
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_GENDER; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true && $entry_gender_error == true) {
|
|
echo zen_draw_radio_field('customers_gender', 'm', false, $cInfo->customers_gender) . ' ' . MALE . ' ' . zen_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender) . ' ' . FEMALE . ' ' . ENTRY_GENDER_ERROR;
|
|
} else {
|
|
echo zen_draw_radio_field('customers_gender', 'm', false, $cInfo->customers_gender) . ' ' . MALE . ' ' . zen_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender) . ' ' . FEMALE;
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
<?php
|
|
$customers_authorization_array = array(array('id' => '0', 'text' => CUSTOMERS_AUTHORIZATION_0),
|
|
array('id' => '1', 'text' => CUSTOMERS_AUTHORIZATION_1),
|
|
array('id' => '2', 'text' => CUSTOMERS_AUTHORIZATION_2),
|
|
array('id' => '3', 'text' => CUSTOMERS_AUTHORIZATION_3)
|
|
);
|
|
// array('id' => '3', 'text' => CUSTOMERS_AUTHORIZATION_3)
|
|
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo CUSTOMERS_AUTHORIZATION; ?></td>
|
|
<td class="main">
|
|
<?php echo zen_draw_pull_down_menu('customers_authorization', $customers_authorization_array, $cInfo->customers_authorization); ?>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_FIRST_NAME; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_firstname_error == true) {
|
|
echo zen_draw_input_field('customers_firstname', $cInfo->customers_firstname, zen_set_field_length(TABLE_CUSTOMERS, 'customers_firstname', 50)) . ' ' . ENTRY_FIRST_NAME_ERROR;
|
|
} else {
|
|
echo $cInfo->customers_firstname . zen_draw_hidden_field('customers_firstname');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('customers_firstname', $cInfo->customers_firstname, zen_set_field_length(TABLE_CUSTOMERS, 'customers_firstname', 50), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_LAST_NAME; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_lastname_error == true) {
|
|
echo zen_draw_input_field('customers_lastname', $cInfo->customers_lastname, zen_set_field_length(TABLE_CUSTOMERS, 'customers_lastname', 50)) . ' ' . ENTRY_LAST_NAME_ERROR;
|
|
} else {
|
|
echo $cInfo->customers_lastname . zen_draw_hidden_field('customers_lastname');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('customers_lastname', $cInfo->customers_lastname, zen_set_field_length(TABLE_CUSTOMERS, 'customers_lastname', 50), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
if (ACCOUNT_DOB == 'true') {
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_DATE_OF_BIRTH; ?></td>
|
|
<td class="main">
|
|
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_date_of_birth_error == true) {
|
|
echo zen_draw_input_field('customers_dob', ($cInfo->customers_dob == '0001-01-01 00:00:00' ? '' : zen_date_short($cInfo->customers_dob)), 'maxlength="10"') . ' ' . ENTRY_DATE_OF_BIRTH_ERROR;
|
|
} else {
|
|
echo $cInfo->customers_dob . ($customers_dob == '0001-01-01 00:00:00' ? 'N/A' : zen_draw_hidden_field('customers_dob'));
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('customers_dob', ($customers_dob == '0001-01-01 00:00:00' ? '' : zen_date_short($cInfo->customers_dob)), 'maxlength="10"', true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_email_address_error == true) {
|
|
echo zen_draw_input_field('customers_email_address', $cInfo->customers_email_address, zen_set_field_length(TABLE_CUSTOMERS, 'customers_email_address', 50)) . ' ' . ENTRY_EMAIL_ADDRESS_ERROR;
|
|
} elseif ($entry_email_address_check_error == true) {
|
|
echo zen_draw_input_field('customers_email_address', $cInfo->customers_email_address, zen_set_field_length(TABLE_CUSTOMERS, 'customers_email_address', 50)) . ' ' . ENTRY_EMAIL_ADDRESS_CHECK_ERROR;
|
|
} elseif ($entry_email_address_exists == true) {
|
|
echo zen_draw_input_field('customers_email_address', $cInfo->customers_email_address, zen_set_field_length(TABLE_CUSTOMERS, 'customers_email_address', 50)) . ' ' . ENTRY_EMAIL_ADDRESS_ERROR_EXISTS;
|
|
} else {
|
|
echo $customers_email_address . zen_draw_hidden_field('customers_email_address');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('customers_email_address', $cInfo->customers_email_address, zen_set_field_length(TABLE_CUSTOMERS, 'customers_email_address', 50), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<?php
|
|
if (ACCOUNT_COMPANY == 'true') {
|
|
?>
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formAreaTitle"><?php echo CATEGORY_COMPANY; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_COMPANY; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_company_error == true) {
|
|
echo zen_draw_input_field('entry_company', $cInfo->entry_company, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_company', 50)) . ' ' . ENTRY_COMPANY_ERROR;
|
|
} else {
|
|
echo $cInfo->entry_company . zen_draw_hidden_field('entry_company');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_company', $cInfo->entry_company, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_company', 50));
|
|
}
|
|
?></td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formAreaTitle"><?php echo CATEGORY_ADDRESS; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_street_address_error == true) {
|
|
echo zen_draw_input_field('entry_street_address', $cInfo->entry_street_address, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_street_address', 50)) . ' ' . ENTRY_STREET_ADDRESS_ERROR;
|
|
} else {
|
|
echo $cInfo->entry_street_address . zen_draw_hidden_field('entry_street_address');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_street_address', $cInfo->entry_street_address, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_street_address', 50), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
if (ACCOUNT_SUBURB == 'true') {
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_SUBURB; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_suburb_error == true) {
|
|
echo zen_draw_input_field('suburb', $cInfo->entry_suburb, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_suburb', 50)) . ' ' . ENTRY_SUBURB_ERROR;
|
|
} else {
|
|
echo $cInfo->entry_suburb . zen_draw_hidden_field('entry_suburb');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_suburb', $cInfo->entry_suburb, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_suburb', 50));
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_POST_CODE; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_post_code_error == true) {
|
|
echo zen_draw_input_field('entry_postcode', $cInfo->entry_postcode, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_postcode', 10)) . ' ' . ENTRY_POST_CODE_ERROR;
|
|
} else {
|
|
echo $cInfo->entry_postcode . zen_draw_hidden_field('entry_postcode');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_postcode', $cInfo->entry_postcode, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_postcode', 10), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_CITY; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_city_error == true) {
|
|
echo zen_draw_input_field('entry_city', $cInfo->entry_city, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_city', 50)) . ' ' . ENTRY_CITY_ERROR;
|
|
} else {
|
|
echo $cInfo->entry_city . zen_draw_hidden_field('entry_city');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_city', $cInfo->entry_city, zen_set_field_length(TABLE_ADDRESS_BOOK, 'entry_city', 50), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
if (ACCOUNT_STATE == 'true') {
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_STATE; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
$entry_state = zen_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state);
|
|
if ($error == true) {
|
|
if ($entry_state_error == true) {
|
|
if ($entry_state_has_zones == true) {
|
|
$zones_array = array();
|
|
$zones_values = $db->Execute("select zone_name
|
|
from " . TABLE_ZONES . "
|
|
where zone_country_id = '" . zen_db_input($cInfo->entry_country_id) . "'
|
|
order by zone_name");
|
|
|
|
while (!$zones_values->EOF) {
|
|
$zones_array[] = array('id' => $zones_values->fields['zone_name'], 'text' => $zones_values->fields['zone_name']);
|
|
$zones_values->MoveNext();
|
|
}
|
|
echo zen_draw_pull_down_menu('entry_state', $zones_array) . ' ' . ENTRY_STATE_ERROR;
|
|
} else {
|
|
echo zen_draw_input_field('entry_state', zen_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)) . ' ' . ENTRY_STATE_ERROR;
|
|
}
|
|
} else {
|
|
echo $entry_state . zen_draw_hidden_field('entry_zone_id') . zen_draw_hidden_field('entry_state');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('entry_state', zen_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state));
|
|
}
|
|
|
|
?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_COUNTRY; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_country_error == true) {
|
|
echo zen_draw_pull_down_menu('entry_country_id', zen_get_countries(), $cInfo->entry_country_id) . ' ' . ENTRY_COUNTRY_ERROR;
|
|
} else {
|
|
echo zen_get_country_name($cInfo->entry_country_id) . zen_draw_hidden_field('entry_country_id');
|
|
}
|
|
} else {
|
|
echo zen_draw_pull_down_menu('entry_country_id', zen_get_countries(), $cInfo->entry_country_id);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formAreaTitle"><?php echo CATEGORY_CONTACT; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($error == true) {
|
|
if ($entry_telephone_error == true) {
|
|
echo zen_draw_input_field('customers_telephone', $cInfo->customers_telephone, zen_set_field_length(TABLE_CUSTOMERS, 'customers_telephone', 15)) . ' ' . ENTRY_TELEPHONE_NUMBER_ERROR;
|
|
} else {
|
|
echo $cInfo->customers_telephone . zen_draw_hidden_field('customers_telephone');
|
|
}
|
|
} else {
|
|
echo zen_draw_input_field('customers_telephone', $cInfo->customers_telephone, zen_set_field_length(TABLE_CUSTOMERS, 'customers_telephone', 15), true);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($processed == true) {
|
|
echo $cInfo->customers_fax . zen_draw_hidden_field('customers_fax');
|
|
} else {
|
|
echo zen_draw_input_field('customers_fax', $cInfo->customers_fax, zen_set_field_length(TABLE_CUSTOMERS, 'customers_fax', 15));
|
|
}
|
|
?></td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formAreaTitle"><?php echo CATEGORY_OPTIONS; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
|
|
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_EMAIL_PREFERENCE; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($processed == true) {
|
|
if ($cInfo->customers_email_format) {
|
|
echo $customers_email_format . zen_draw_hidden_field('customers_email_format');
|
|
}
|
|
} else {
|
|
$email_pref_text = ($cInfo->customers_email_format == 'TEXT') ? true : false;
|
|
$email_pref_html = !$email_pref_text;
|
|
echo zen_draw_radio_field('customers_email_format', 'HTML', $email_pref_html) . ' ' . ENTRY_EMAIL_HTML_DISPLAY . ' ' . zen_draw_radio_field('customers_email_format', 'TEXT', $email_pref_text) . ' ' . ENTRY_EMAIL_TEXT_DISPLAY ;
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_NEWSLETTER; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($processed == true) {
|
|
if ($cInfo->customers_newsletter == '1') {
|
|
echo ENTRY_NEWSLETTER_YES;
|
|
} else {
|
|
echo ENTRY_NEWSLETTER_NO;
|
|
}
|
|
echo zen_draw_hidden_field('customers_newsletter');
|
|
} else {
|
|
echo zen_draw_pull_down_menu('customers_newsletter', $newsletter_array, (($cInfo->customers_newsletter == '1') ? '1' : '0'));
|
|
}
|
|
?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="main"><?php echo ENTRY_PRICING_GROUP; ?></td>
|
|
<td class="main">
|
|
<?php
|
|
if ($processed == true) {
|
|
if ($cInfo->customers_group_pricing) {
|
|
$group_query = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . " where group_id = '" . $cInfo->customers_group_pricing . "'");
|
|
echo $group_query->fields['group_name'].' '.$group_query->fields['group_percentage'].'%';
|
|
} else {
|
|
echo ENTRY_NONE;
|
|
}
|
|
echo zen_draw_hidden_field('customers_newsletter');
|
|
} else {
|
|
$group_array_query = $db->execute("select group_id, group_name, group_percentage from " . TABLE_GROUP_PRICING);
|
|
$group_array[] = array('id'=>0, 'text'=>TEXT_NONE);
|
|
while (!$group_array_query->EOF) {
|
|
$group_array[] = array('id'=>$group_array_query->fields['group_id'], 'text'=>$group_array_query->fields['group_name'].' '.$group_array_query->fields['group_percentage'].'%');
|
|
$group_array_query->MoveNext();
|
|
}
|
|
echo zen_draw_pull_down_menu('customers_group_pricing', $group_array, $cInfo->customers_group_pricing);
|
|
}
|
|
?></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td class="main"><?php echo CUSTOMERS_REFERRAL; ?></td>
|
|
<td class="main">
|
|
<?php echo zen_draw_input_field('customers_referral', $cInfo->customers_referral, zen_set_field_length(TABLE_CUSTOMERS, 'customers_referral', 15)); ?>
|
|
</td>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="right" class="main"><?php echo zen_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('action')), 'NONSSL') .'">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
|
|
</tr></form>
|
|
<?php
|
|
} else {
|
|
?>
|
|
<tr>
|
|
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
|
|
<tr><?php echo zen_draw_form('search', FILENAME_CUSTOMERS, '', 'get', '', true); ?>
|
|
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
|
|
<td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
|
|
<td class="smallText" align="right">
|
|
<?php
|
|
// show reset search
|
|
if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
|
|
echo '<a href="' . zen_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '">' . zen_image_button('button_reset.gif', IMAGE_RESET) . '</a> ';
|
|
}
|
|
echo HEADING_TITLE_SEARCH_DETAIL . ' ' . zen_draw_input_field('search') . zen_hide_session_id();
|
|
if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
|
|
$keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
|
|
echo '<br/ >' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords;
|
|
}
|
|
?>
|
|
</td>
|
|
</form></tr>
|
|
</table></td>
|
|
</tr>
|
|
<tr>
|
|
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
|
|
<tr>
|
|
<?php
|
|
// Sort Listing
|
|
switch ($_GET['list_order']) {
|
|
case "id-asc":
|
|
$disp_order = "ci.customers_info_date_account_created";
|
|
break;
|
|
case "firstname":
|
|
$disp_order = "c.customers_firstname";
|
|
break;
|
|
case "firstname-desc":
|
|
$disp_order = "c.customers_firstname DESC";
|
|
break;
|
|
case "group-asc":
|
|
$disp_order = "c.customers_group_pricing";
|
|
break;
|
|
case "group-desc":
|
|
$disp_order = "c.customers_group_pricing DESC";
|
|
break;
|
|
case "lastname":
|
|
$disp_order = "c.customers_lastname, c.customers_firstname";
|
|
break;
|
|
case "lastname-desc":
|
|
$disp_order = "c.customers_lastname DESC, c.customers_firstname";
|
|
break;
|
|
case "company":
|
|
$disp_order = "a.entry_company";
|
|
break;
|
|
case "company-desc":
|
|
$disp_order = "a.entry_company DESC";
|
|
break;
|
|
case "login-asc":
|
|
$disp_order = "ci.customers_info_date_of_last_logon";
|
|
break;
|
|
case "login-desc":
|
|
$disp_order = "ci.customers_info_date_of_last_logon DESC";
|
|
break;
|
|
case "approval-asc":
|
|
$disp_order = "c.customers_authorization";
|
|
break;
|
|
case "approval-desc":
|
|
$disp_order = "c.customers_authorization DESC";
|
|
break;
|
|
default:
|
|
$disp_order = "ci.customers_info_date_account_created DESC";
|
|
}
|
|
?>
|
|
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
|
|
<tr class="dataTableHeadingRow">
|
|
<td class="dataTableHeadingContent" align="center" valign="top">
|
|
<?php echo TABLE_HEADING_ID; ?>
|
|
</td>
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='lastname' or $_GET['list_order']=='lastname-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_LASTNAME . '</span>' : TABLE_HEADING_LASTNAME); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=lastname', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='lastname' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=lastname-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='lastname-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='firstname' or $_GET['list_order']=='firstname-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_FIRSTNAME . '</span>' : TABLE_HEADING_FIRSTNAME); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=firstname', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='firstname' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=firstname-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='firstname-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
|
|
</td>
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='company' or $_GET['list_order']=='company-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_COMPANY . '</span>' : TABLE_HEADING_COMPANY); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=company', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='company' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=company-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='company-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='id-asc' or $_GET['list_order']=='id-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_ACCOUNT_CREATED . '</span>' : TABLE_HEADING_ACCOUNT_CREATED); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=id-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='id-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=id-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='id-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='login-asc' or $_GET['list_order']=='login-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_LOGIN . '</span>' : TABLE_HEADING_LOGIN); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=login-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='login-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=login-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='login-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
|
|
<td class="dataTableHeadingContent" align="left">
|
|
<?php echo (($_GET['list_order']=='group-asc' or $_GET['list_order']=='group-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_PRICING_GROUP . '</span>' : TABLE_HEADING_PRICING_GROUP); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=group-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='group-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=group-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='group-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
|
|
<td class="dataTableHeadingContent" align="center">
|
|
<?php echo (($_GET['list_order']=='approval-asc' or $_GET['list_order']=='approval-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_AUTHORIZATION_APPROVAL . '</span>' : TABLE_HEADING_AUTHORIZATION_APPROVAL); ?><br>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=approval-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='approval-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>
|
|
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=approval-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='approval-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
|
|
</td>
|
|
|
|
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
|
|
</tr>
|
|
<?php
|
|
$search = '';
|
|
if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
|
|
$keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
|
|
// $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'";
|
|
$search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike '" . $keywords . "' or a.entry_company rlike '" . $keywords . "' or a.entry_street_address rlike '" . $keywords . "' or a.entry_city rlike '" . $keywords . "' or a.entry_postcode rlike '" . $keywords . "'";
|
|
}
|
|
$new_fields=', c.customers_telephone, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, c.customers_authorization, c.customers_referral';
|
|
$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, a.entry_country_id, a.entry_company, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created " . $new_fields . " from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id= ci.customers_info_id left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $disp_order";
|
|
|
|
// Split Page
|
|
// reset page when page is unknown
|
|
if (($_GET['page'] == '' or $_GET['page'] == '1') and $_GET['cID'] != '') {
|
|
$check_page = $db->Execute($customers_query_raw);
|
|
$check_count=1;
|
|
if ($check_page->RecordCount() > MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER) {
|
|
while (!$check_page->EOF) {
|
|
if ($check_page->fields['customers_id'] == $_GET['cID']) {
|
|
break;
|
|
}
|
|
$check_count++;
|
|
$check_page->MoveNext();
|
|
}
|
|
$_GET['page'] = round((($check_count/MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER)+(fmod_round($check_count,MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER) !=0 ? .5 : 0)),0);
|
|
// zen_redirect(zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $_GET['cID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'NONSSL'));
|
|
} else {
|
|
$_GET['page'] = 1;
|
|
}
|
|
}
|
|
|
|
$customers_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER, $customers_query_raw, $customers_query_numrows);
|
|
$customers = $db->Execute($customers_query_raw);
|
|
while (!$customers->EOF) {
|
|
$info = $db->Execute("select customers_info_date_account_created as date_account_created,
|
|
customers_info_date_account_last_modified as date_account_last_modified,
|
|
customers_info_date_of_last_logon as date_last_logon,
|
|
customers_info_number_of_logons as number_of_logons
|
|
from " . TABLE_CUSTOMERS_INFO . "
|
|
where customers_info_id = '" . $customers->fields['customers_id'] . "'");
|
|
|
|
if ((!isset($_GET['cID']) || (isset($_GET['cID']) && ($_GET['cID'] == $customers->fields['customers_id']))) && !isset($cInfo)) {
|
|
$country = $db->Execute("select countries_name
|
|
from " . TABLE_COUNTRIES . "
|
|
where countries_id = '" . (int)$customers->fields['entry_country_id'] . "'");
|
|
|
|
$reviews = $db->Execute("select count(*) as number_of_reviews
|
|
from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers->fields['customers_id'] . "'");
|
|
|
|
$customer_info = array_merge($country->fields, $info->fields, $reviews->fields);
|
|
|
|
$cInfo_array = array_merge($customers->fields, $customer_info);
|
|
$cInfo = new objectInfo($cInfo_array);
|
|
}
|
|
|
|
$group_query = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . " where
|
|
group_id = '" . $customers->fields['customers_group_pricing'] . "'");
|
|
|
|
if ($group_query->RecordCount() < 1) {
|
|
$group_name_entry = TEXT_NONE;
|
|
} else {
|
|
$group_name_entry = $group_query->fields['group_name'];
|
|
}
|
|
|
|
if (isset($cInfo) && is_object($cInfo) && ($customers->fields['customers_id'] == $cInfo->customers_id)) {
|
|
echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit', 'NONSSL') . '\'">' . "\n";
|
|
} else {
|
|
echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID')) . 'cID=' . $customers->fields['customers_id'], 'NONSSL') . '\'">' . "\n";
|
|
}
|
|
?>
|
|
<td class="dataTableContent" align="right"><?php echo $customers->fields['customers_id']; ?></td>
|
|
<td class="dataTableContent"><?php echo $customers->fields['customers_lastname']; ?></td>
|
|
<td class="dataTableContent"><?php echo $customers->fields['customers_firstname']; ?></td>
|
|
<td class="dataTableContent"><?php echo $customers->fields['entry_company']; ?></td>
|
|
<td class="dataTableContent"><?php echo zen_date_short($info->fields['date_account_created']); ?></td>
|
|
<td class="dataTableContent"><?php echo zen_date_short($customers->fields['customers_info_date_of_last_logon']); ?></td>
|
|
<td class="dataTableContent"><?php echo $group_name_entry; ?></td>
|
|
<td class="dataTableContent" align="center"><?php echo ($customers->fields['customers_authorization'] == 0 ? '<a href="' . zen_href_link(FILENAME_CUSTOMERS, 'action=status¤t=' . $customers->fields['customers_authorization'] . '&cID=' . $customers->fields['customers_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_CUSTOMERS, 'action=status¤t=' . $customers->fields['customers_authorization'] . '&cID=' . $customers->fields['customers_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
|
|
<td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($customers->fields['customers_id'] == $cInfo->customers_id)) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID')) . 'cID=' . $customers->fields['customers_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
|
|
</tr>
|
|
<?php
|
|
$customers->MoveNext();
|
|
}
|
|
?>
|
|
<tr>
|
|
<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
|
|
<tr>
|
|
<td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td>
|
|
<td class="smallText" align="right"><?php echo $customers_split->display_links($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?></td>
|
|
</tr>
|
|
<?php
|
|
if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
|
|
?>
|
|
<tr>
|
|
<td align="right" colspan="2"><?php echo '<a href="' . zen_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '">' . zen_image_button('button_reset.gif', IMAGE_RESET) . '</a>'; ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table></td>
|
|
</tr>
|
|
</table></td>
|
|
<?php
|
|
$heading = array();
|
|
$contents = array();
|
|
|
|
switch ($action) {
|
|
case 'confirm':
|
|
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CUSTOMER . '</b>');
|
|
|
|
$contents = array('form' => zen_draw_form('customers', FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=deleteconfirm', 'post', '', true));
|
|
$contents[] = array('text' => TEXT_DELETE_INTRO . '<br><br><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
|
|
if (isset($cInfo->number_of_reviews) && ($cInfo->number_of_reviews) > 0) $contents[] = array('text' => '<br />' . zen_draw_checkbox_field('delete_reviews', 'on', true) . ' ' . sprintf(TEXT_DELETE_REVIEWS, $cInfo->number_of_reviews));
|
|
$contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id, 'NONSSL') . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
|
|
break;
|
|
default:
|
|
if (isset($cInfo) && is_object($cInfo)) {
|
|
$customers_orders = $db->Execute("select orders_id, date_purchased, order_total, currency, currency_value from " . TABLE_ORDERS . " where customers_id='" . $cInfo->customers_id . "' order by date_purchased desc");
|
|
|
|
$heading[] = array('text' => '<b>' . TABLE_HEADING_ID . $cInfo->customers_id . ' ' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
|
|
|
|
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=confirm', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a><br />' . ($customers_orders->RecordCount() != 0 ? '<a href="' . zen_href_link(FILENAME_ORDERS, 'cID=' . $cInfo->customers_id, 'NONSSL') . '">' . zen_image_button('button_orders.gif', IMAGE_ORDERS) . '</a>' : '') . ' <a href="' . zen_href_link(FILENAME_MAIL, 'origin=customers.php&mode=NONSSL&selected_box=tools&customer=' . $cInfo->customers_email_address.'&cID=' . $cInfo->customers_id, 'NONSSL') . '">' . zen_image_button('button_email.gif', IMAGE_EMAIL) . '</a>');
|
|
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_CREATED . ' ' . zen_date_short($cInfo->date_account_created));
|
|
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . zen_date_short($cInfo->date_account_last_modified));
|
|
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_LAST_LOGON . ' ' . zen_date_short($cInfo->date_last_logon));
|
|
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $cInfo->number_of_logons);
|
|
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_ORDERS . ' ' . $customers_orders->RecordCount());
|
|
if ($customers_orders->RecordCount() != 0) {
|
|
$contents[] = array('text' => TEXT_INFO_LAST_ORDER . ' ' . zen_date_short($customers_orders->fields['date_purchased']) . '<br />' . TEXT_INFO_ORDERS_TOTAL . ' ' . $currencies->format($customers_orders->fields['order_total'], true, $customers_orders->fields['currency'], $customers_orders->fields['currency_value']));
|
|
}
|
|
$contents[] = array('text' => '<br />' . TEXT_INFO_COUNTRY . ' ' . $cInfo->countries_name);
|
|
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_REVIEWS . ' ' . $cInfo->number_of_reviews);
|
|
$contents[] = array('text' => '<br />' . CUSTOMERS_REFERRAL . ' ' . $cInfo->customers_referral);
|
|
}
|
|
break;
|
|
}
|
|
|
|
if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) {
|
|
echo ' <td width="25%" valign="top">' . "\n";
|
|
|
|
$box = new box;
|
|
echo $box->infoBox($heading, $contents);
|
|
|
|
echo ' </td>' . "\n";
|
|
}
|
|
?>
|
|
</tr>
|
|
</table></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table></td>
|
|
<!-- body_text_eof //-->
|
|
</tr>
|
|
</table>
|
|
<!-- body_eof //-->
|
|
|
|
<!-- footer //-->
|
|
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
|
|
<!-- footer_eof //-->
|
|
<br>
|
|
</body>
|
|
</html>
|
|
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
|