$processed = true;
}
}
break;
default:
$customers = $gBitDb->Execute("select c.`customers_id`, c.`customers_gender`, c.`customers_firstname`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_lastname`, c.`customers_dob`, c.`customers_email_address`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_company`, a.`entry_street_address`, a.`entry_suburb`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_postcode`, a.`entry_city`, a.`entry_state`, a.`entry_zone_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_country_id`, c.`customers_telephone`, c.`customers_fax`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_newsletter`, c.`customers_default_address_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_email_format`, c.`customers_group_pricing`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_authorization`, c.`customers_referral`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton c.`customers_default_address_id` = a.`address_book_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand a.`customers_id` = c.`customers_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE c.`customers_id` = '" . (int) $_GET['user_id'] . "'");
$cust = $customers->FetchRow();
$cInfo = new objectInfo($cust);
$gBitSmarty->assign('cInfo', $cInfo);
}
} else {
$stats = new CommerceStatistics();
if (empty($_REQUEST['interval'])) {
$_REQUEST['interval'] = '3 years';
}
$gBitSmarty->assign('customers', $stats->getCustomerActivity($_REQUEST));
}
if (!empty($cInfo)) {
$mid = 'bitpackage:bitcommerce/admin_customer_edit.tpl';
$title = tra('Edit Customer');
if ($processed == true) {
if ($cInfo->customers_group_pricing) {
$group_query = $gBitDb->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 {
$groupPricing[] = 'None';
$groupPricing = array_merge($groupPricing, $gBitDb->getAssoc("select `group_id`, `group_name`|| ' ' || `group_percentage` || '%' from " . TABLE_GROUP_PRICING));
$gBitSmarty->assign('groupPricing', $groupPricing);
$gBitSmarty->assign('customerAuth', array(CUSTOMERS_AUTHORIZATION_0, CUSTOMERS_AUTHORIZATION_1, CUSTOMERS_AUTHORIZATION_2, CUSTOMERS_AUTHORIZATION_3));
}
