# --- BEGIN PLUGIN HELP --- For display information visit: http://homeplatewp.com/TextCommerce/article/67/tc_product_display-001 # --- END PLUGIN HELP --- '. n.'.customerEdit legend{'. n.' font-size: 11px;'. n.' font-weight: bold;'. n.'}'. n.'.customerEdit label{'. n.' float: left;'. n.' width: 100px;'. n.' text-align: right;'. n.' padding: 5px;'. n.'}'. n.'.customerEdit br{'. n.' clear: both;'. n.'}'. n.'.customerEdit input{'. n.' margin: 5px 0 5px 0;'. n.' font-size: 11px;'. n.'}'. n.''; doJS(); if(isset($_REQUEST['user_id'])){ $user_id = $_REQUEST['user_id']; $customer = safe_row("*", "txp_users", "user_id = $user_id"); extract($customer); $step = "update_customer"; }else{ $step = "save_customer"; } //DELETE CUSTOMER FORM //==================================== echo n.n.''; echo n.n.'

'; echo hInput('user_id', $user_id). eInput('customers'). sInput($step). ''. startTable('edit'). ''.n; //if ($view == 'text') //{ //-- markup help -------------- echo ''.n; echo "

". n."Customer Details". n.'Username'. n.''.br. n.'Email'. n.''. n.'First name'. n.''.br. n.'Last name'. n.''.br. n.'

'; echo "

". n."Billing Information". n.'Company'. n.''.br. n.'Address 1'. n.''.br. n.'Address 2'. n.''.br. n.'City'. n.''.br. n.'State'. n.''.br. n.'Zip/Postal Code'. n.''.br. n.'Country'. n.''.br. n.'Fax Number'. n.''.br. n.'Phone Number'. n.''.br. n.' '; if($shipping_same_as_billing == "1"){ $checked = "checked='checked'"; }else{ $checked =''; } echo n.' Shipping info same as billing'.br. n.'

'; doJS(); if($shipping_same_as_billing == "1"){ $display = "none"; }else{ $display = "block"; } echo "

". n."Shipping Information". n.'Company'. n.''.br. n.'First name'. n.''.br. n.'Last name'. n.''.br. n.'Address 1'. n.''.br. n.'Address 2'. n.''.br. n.'City'. n.''.br. n.'State'. n.''.br. n.'Zip/Postal Code'. n.''.br. n.'Country'. n.''.br. n.'Fax Number'. n.''.br. n.'Phone Number'. n.''.br. n.'

'; echo ''; echo ''; //start article-col-2 echo 'Add new customer'; if(isset($user_id)){ echo n.br.br.'Delete this customer'.br.br; }else{ echo br.br; } //-- publish button -------------- echo (has_privs('article.publish')) ? fInput('submit','publish',gTxt('save'),"publish", '', '', '', 4) : fInput('submit','publish',gTxt('save'),"publish", '', '', '', 4); if($user_id){ $orders = safe_rows("*", "orders", "user_id = $user_id ORDER BY last_updated DESC"); if(count($orders) > 0){ echo br.br."

". n.'Order History'. n.'

ORDER #'.$order['id'].'

'; echo '

'; } } echo '

'; } //--- end settings function customers_switch($event, $step){ switch(strtolower($step)) { // 'zem_admin_test' will be called to handle the new event case "": customers_list($event, $step); break; case "list": customers_list($event, $step); break; case "customers_change_pageby": customers_list($event, $step); break; case "edit_customer": customer_edit($event, $step); break; case "delete_customer": customer_delete($event, $step); break; case "save_customer": customer_save($event, $step); break; case "update_customer": customer_update($event, $step); break; case "export_customer": customer_export($event, $step); break; } } function customer_save($event, $step){ global $txp_user, $vars, $txpcfg, $prefs; extract($prefs); extract(doSlash($_REQUEST)); $RealName = $billing_firstname . " ". $billing_lastname; if(!isset($shipping_same_as_billing)){ $shipping_same_as_billing = 0; }else{ $shipping_same_as_billing = 1; } if(!function_exists("generate_password")){ require_once txpath.'/include/txp_admin.php'; } if(!function_exists("is_valid_email")){ require_once txpath.'/lib/txplib_misc.php'; } if ($name && is_valid_email($email)) { $password = doSlash(generate_password(6)); $nonce = doSlash(md5(uniqid(rand(), true))); $rs = safe_insert('txp_users', " privs = 0, name = '$name', email = '$email', RealName = '$RealName', pass = password(lower('$password')), nonce = '$nonce', billing_company = '$billing_company', billing_address1 = '$billing_address1', billing_address2 = '$billing_address2', billing_city = '$billing_city', billing_state = '$billing_state', billing_zip = '$billing_zip', billing_country = '$billing_country', billing_fax = '$billing_fax', billing_phone = '$billing_phone', shipping_same_as_billing = $shipping_same_as_billing, shipping_company = '$shipping_company', shipping_address1 = '$shipping_address1', shipping_address2 = '$shipping_address2', shipping_city = '$shipping_city', shipping_state = '$shipping_state', shipping_zip = '$shipping_zip', shipping_country = '$shipping_country', shipping_fax = '$shipping_fax', shipping_phone = '$shipping_phone', shipping_firstname = '$shipping_firstname', shipping_lastname = '$shipping_lastname', billing_firstname = '$billing_firstname', billing_lastname = '$billing_lastname'"); if ($rs) { send_customer_password($RealName, $name, $email, $password); /*admin( gTxt('password_sent_to').sp.$email );*/ customers_list('', '', gTxt('password_sent_to').sp.$email); }else{ echo mysql_error(); } } //admin("There was an error trying to add this customer"); } function customer_delete($event, $step){ global $txp_user, $vars, $txpcfg, $prefs; extract($prefs); extract(doSlash($_REQUEST)); $user_id = assert_int($user_id); safe_delete("txp_users", "user_id = $user_id"); customers_list('', '', "customer deleted"); } function customer_update($event, $step){ global $txp_user, $vars, $txpcfg, $prefs; extract($prefs); extract(doSlash($_REQUEST)); $RealName = $billing_firstname . " ". $billing_lastname; $user_id = assert_int($user_id); if(!isset($shipping_same_as_billing)){ $shipping_same_as_billing = 0; }else{ $shipping_same_as_billing = 1; } if(!function_exists("generate_password")){ require_once txpath.'/include/txp_admin.php'; } if(!function_exists("is_valid_email")){ require_once txpath.'/lib/txplib_misc.php'; } if ($name && is_valid_email($email)) { $password = doSlash(generate_password(6)); $nonce = doSlash(md5(uniqid(rand(), true))); $rs = safe_update('txp_users', " privs = 0, name = '$name', email = '$email', RealName = '$RealName', billing_company = '$billing_company', billing_address1 = '$billing_address1', billing_address2 = '$billing_address2', billing_city = '$billing_city', billing_state = '$billing_state', billing_zip = '$billing_zip', billing_country = '$billing_country', billing_fax = '$billing_fax', billing_phone = '$billing_phone', shipping_same_as_billing = $shipping_same_as_billing, shipping_company = '$shipping_company', shipping_address1 = '$shipping_address1', shipping_address2 = '$shipping_address2', shipping_city = '$shipping_city', shipping_state = '$shipping_state', shipping_zip = '$shipping_zip', shipping_country = '$shipping_country', shipping_fax = '$shipping_fax', shipping_phone = '$shipping_phone', shipping_firstname = '$shipping_firstname', shipping_lastname = '$shipping_lastname', billing_firstname = '$billing_firstname', billing_lastname = '$billing_lastname'", "user_id = $user_id" ); if ($rs) { customers_list('', '', "customer updated"); }else{ customers_list("There was an error trying to update customer"); } } } function customer_export($step='', $message=''){ $customers = safe_rows("RealName,email,billing_company,billing_address1,billing_address2,billing_city,billing_state,billing_zip,billing_country,billing_fax,billing_phone,shipping_same_as_billing,shipping_company,shipping_address1,shipping_address2,shipping_city,shipping_state,shipping_zip,shipping_country,shipping_fax,shipping_phone,shipping_firstname,shipping_lastname,billing_firstname,billing_lastname", "txp_users", "privs = 0"); header("Content-type: application/csv"); header("Content-disposition:attachment;filename=customer_list_".date("Y-m-d").".csv"); echo "RealName,email,billing_company,billing_address1,billing_address2,billing_city,billing_state,billing_zip,billing_country,billing_fax,billing_phone,shipping_same_as_billing,shipping_company,shipping_address1,shipping_address2,shipping_city,shipping_state,shipping_zip,shipping_country,shipping_fax,shipping_phone,shipping_firstname,shipping_lastname,billing_firstname,billing_lastname\n"; foreach($customers as $customer){ echo implode(",", $customer)."\n"; } die(); } function customers_list($event='', $step='', $message=''){ global $statuses, $comments_disabled_after, $step, $txp_user; pagetop("Customers", $message); extract(get_prefs()); extract(gpsa(array('page', 'sort', 'dir', 'crit', 'qty', 'search_method'))); $sesutats = array_flip($statuses); $dir = ($dir == 'desc') ? 'desc' : 'asc'; switch ($sort) { case 'RealName': $sort_sql = 'RealName '.$dir; break; case 'orders': $sort_sql = 'orders '.$dir; break; default: $dir = 'desc'; $sort_sql = 'user_id '.$dir; break; } $switch_dir = ($dir == 'desc') ? 'asc' : 'desc'; $criteria = "privs = 0"; if ($search_method and $crit) { $crit_escaped = doSlash($crit); $critsql = array( 'id' => "ID = '$crit_escaped'", 'title_body' => "Title rlike '$crit_escaped' or Body rlike '$crit_escaped'", 'section' => "Section rlike '$crit_escaped'", 'categories' => "Category1 rlike '$crit_escaped' or Category2 rlike '$crit_escaped'", 'status' => "Status = '".(@$sesutats[gTxt($crit_escaped)])."'", 'author' => "AuthorID rlike '$crit_escaped'", ); if (array_key_exists($search_method, $critsql)) { $criteria = $critsql[$search_method]; $limit = 500; } else { $search_method = ''; $crit = ''; } } else { $search_method = ''; $crit = ''; } $total = safe_count('txp_users', "$criteria"); if(isset($qty)){ $customers_list_pageby = $qty; }else{ $customers_list_pageby = 15; } $limit = max(@$customers_list_pageby, 15); list($page, $offset, $numPages) = pager($total, $limit, $page); $rs = safe_rows_start('*', 'txp_users', "$criteria order by $sort_sql limit $offset, $limit" ); $customersOnPage = $offset+$limit; if ($rs) { echo n.n.'

'. n.startTable('list','','','','700'). n.tr( n.tda("Displaying $offset - $customersOnPage of $total customers", ' colspan="2" style="border: none; padding-bottom: 15px;"'). n.tda('Add a new customer Export customers', ' colspan="2" style="text-align: right; border: none; padding-bottom: 15px;"') ). n.tr( n.column_head('Customer', 'RealName', 'customers', true, $switch_dir, $crit, $search_method). column_head('Phone', 'shipping_phone', 'customers', true, $switch_dir, $crit, $search_method). column_head('Email', 'email', 'customers', true, $switch_dir, $crit, $search_method). column_head('Orders', 'order_num', 'customers', true, $switch_dir, $crit, $search_method) ); include_once txpath.'/publish/taghandlers.php'; while ($a = nextRow($rs)) { extract($a); $order_num = safe_count("orders", "user_id = $user_id"); $RealName = eLink('customers', 'edit_customer', 'user_id', $user_id, $RealName); $Orders = eLink('order', 'edit', 'customer', $name, $order_num); echo n.n.tr( n.td($RealName, "25%"). td($billing_phone, "25%"). td($email, "25%"). td($Orders, "25%") ); } echo n.endTable(). n.'

'. n.nav_form('customers', $page, $numPages, $sort, $dir, $crit, $search_method). n.pageby_form('customers', $customers_list_pageby); } }//---- end customers_list() ?>