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