Execute($sql); $action = ''; zen_redirect(zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $_GET['cID'] . '&page=' . $_GET['page'], 'NONSSL')); break; default: $customers = "select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, 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, lp.* from " . TABLE_CUSTOMERS . " c left join " . TABLE_LINKPOINT_API . " lp on c.customers_id = lp.customer_id where lp.customer_id = c.customers_id and c.customers_id = '" . (int)$_GET['cID'] . "'" . " order by lp.customer_id, lp.id "; $cInfo = new objectInfo($customers->fields); } } ?> >

' . zen_image_button('button_update.gif', IMAGE_UPDATE) . '  ' : ''); ?> ' . zen_image_button('button_reset.gif', IMAGE_RESET) . '  '; } echo HEADING_TITLE_SEARCH_DETAIL . ' ' . zen_draw_input_field('search') . ' Customers Name or use #customers_id, example: #27275'; if (isset($_GET['search']) && zen_not_null($_GET['search'])) { $keywords = zen_db_input(zen_db_prepare_input($_GET['search'])); zen_draw_hidden_field('disp_order', $disp_order); echo ' ' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords . ' '; } ?> Execute($customers_query_raw); //die('I SEE ' . $testing->RecordCount()); // Split Page // reset page when page is unknown if ($_GET['page'] == '' 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($check_count,MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER) !=0 ? .5 : 0)),0); // zen_redirect(zen_href_link(FILENAME_LINKPOINT_REVIEW, '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'] . "'"); if (!is_array($country->fields)) $country->fields = array(); $customer_info = array_merge($country->fields, $info->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 ' ' . "\n"; } else { echo ' ' . "\n"; } */ echo ' ' . "\n"; ?> MoveNext(); } ?> ' . LPID . '' : LPID); ?> Asc' : 'Asc'); ?>  Desc' : 'Desc'); ?> ' . TABLE_HEADING_ID . '' : TABLE_HEADING_ID); ?> Asc' : 'Asc'); ?>  Desc' : 'Desc'); ?> ' . TABLE_HEADING_LASTNAME . '' : TABLE_HEADING_LASTNAME); ?> Asc' : 'Asc'); ?>  Desc' : 'Desc'); ?> ' . TABLE_HEADING_FIRSTNAME . '' : TABLE_HEADING_FIRSTNAME); ?> Asc' : 'Asc'); ?>  Desc' : 'Desc'); ?> fields['id']; ?> fields['customers_id'], 'NONSSL') . '">#' . ($customers->fields['transaction_result'] != 'APPROVED' ? '' . $customers->fields['customers_id'] . '' : $customers->fields['customers_id']) . ''; ?> fields['customer_id'], 'NONSSL') . '">' . ($customers->fields['transaction_result'] != 'APPROVED' ? '' . $customers->fields['customers_lastname'] . '' : $customers->fields['customers_lastname']) . ''; ?> fields['customer_id'], 'NONSSL') . '">' . ($customers->fields['transaction_result'] != 'APPROVED' ? '' . $customers->fields['customers_firstname'] . '' : $customers->fields['customers_firstname']) . ''; ?> fields['customer_id'], 'NONSSL') . '">' . ($customers->fields['transaction_result'] != 'APPROVED' ? '' . $customers->fields['entry_company'] . '' : $customers->fields['entry_company']) . ''; ?> ' . ($customers->fields['transaction_response_time'] == '' ? 'Not Connected' : $customers->fields['transaction_response_time']) . ''; ?> ' . $customers->fields['date_added'] . ''; ?> format($customers->fields['chargetotal']); ?> fields['date_account_created']); ?> fields['transaction_result'] != 'APPROVED' ? '' . $customers->fields['transaction_result'] . '' : $customers->fields['transaction_result']) . ' ' . $customers->fields['cc_number'] . ' ' . 'Expires: ' . $customers->fields['cc_expire'] . ' ' . $customers->fields['lp_trans_num'] . ' ' . $customers->fields['transaction_reference_number'] . ' ' . ($customers->fields['avs_response'] != 'YYYM' ? '' . $customers->fields['avs_response'] . '' : $customers->fields['avs_response']) . ' ' . ($customers->fields['r_error'] != '' ? '' . $customers->fields['r_error'] . '' : '') . ' ' . $customers->fields['transaction_time']; ?> PREAUTH','SALE'), $customers->fields['cust_info']) . ' '; ?> display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?> 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'))); ?> ' . zen_image_button('button_reset.gif', IMAGE_RESET) . ''; ?>