$ordersId_arr[] = $orderid_result->fields['orders_id']; $orderid_result->MoveNext(); } //所有可用的投诉类型 /** $type_query = "select * from 2011user_complaint_type where type_status=1 "; $db->Execute('set names utf8'); $type = $db->Execute($type_query); $type_arr = array(); while(!$type->EOF) { $type_arr[] = array('type_id'=>$type->fields['type_id'],'type_name'=>$type->fields['type_name']); $type->MoveNext(); } /**/ $complaint_type_str = getCustomConfig('complaint_type'); $complaint_type_arr = explode(",", $complaint_type_str); $type_arr = array(); foreach ($complaint_type_arr as $complaint_row) { if (strpos($complaint_row, "|") !== false) { $tmp = explode("|", $complaint_row); $type_arr[$tmp[0]] = $tmp[1]; } } /** $type_arr=array( 'ORD_CPT_QUAL_FLAW'=>'质量问题', 'ORD_CPT_PRICE'=>'销售价格', 'ORD_CPT_DAMAGE'=>'物流服务', 'ORD_CPT_OTHER'=>'客服质量', 'ORD_CPT_OTHER1'=>'售后',
$query = "select orders_status_id from " . TABLE_ORDERS_STATUS . " where orders_status_name='Canceled'"; $result = $db->Execute($query); if ($result->RecordCount() == 0) { echo CANNT_CANCELED_NOW; } else { $status_id = (int) $result->fields['orders_status_id']; $query = "update " . TABLE_ORDERS . " set orders_status=" . $status_id . " where orders_id=:orders_id and customers_id =:customers_id "; $query = $db->bindVars($query, ':customers_id', $_SESSION['customer_id'], 'integer'); $query = $db->bindVars($query, ':orders_id', $orders_id, 'integer'); $db->Execute($query); zen_redirect(zen_href_link('my_orders', 'ucenter=1', 'SSL')); } } $orders_total = zen_count_customer_orders(); //所有的订单状态 $my_order_status = getCustomConfig('order_status'); $my_order_status_arr = explode(",", $my_order_status); $order_status_arr = array(); foreach ($my_order_status_arr as $status_str) { $tmp_arr = explode("=", $status_str); if (count($tmp_arr) == 2) { $order_status_arr[$tmp_arr[0]] = $tmp_arr[1]; } } if ($orders_total > 0) { if ($action == "find_order") { $find_orders_id = (int) $_REQUEST['find_orders_id']; $find_str = " and o.orders_id=" . $find_orders_id . " "; } else { $find_str = ""; }
//所有可用的退款类型 $refund_types_query = "select * from 2011refund_types where refund_type_status=1 "; $refund_types = $db->Execute($refund_types_query); $refund_types_arr = array(); while(!$refund_types->EOF) { $refund_types_arr[] = array('refund_type_id'=>$refund_types->fields['refund_type_id'],'refund_type'=>$refund_types->fields['refund_type']); $refund_types->MoveNext(); } /**/ //退换货注意提示信息 $exchange_return_tip = trim(getCustomConfig('exchange_return_tip')); //退换货类型(退货或者返修) $types_arr = getCustomConfig('refund_types', 1); //退换货状态(退货或者返修) $refund_staus_arr = getCustomConfig('refund_status', 1); //所有的订单id $orderid_query = "SELECT orders_id from " . TABLE_ORDERS . " where orders_status=4 and customers_id = :customersID ORDER BY orders_id DESC"; $orderid_query = $db->bindVars($orderid_query, ':customersID', $_SESSION['customer_id'], 'integer'); $orderid_result = $db->Execute($orderid_query); $ordersId_arr = array(); while (!$orderid_result->EOF) { $ordersId_arr[] = $orderid_result->fields['orders_id']; $orderid_result->MoveNext(); } //用户所有的退款申请 $refund_query = "select ra.refund_apply_id,ra.orders_id,ra.add_time,ra.refund_apply_reason,ra.refund_status_id,ra.refund_apply_reply \n\t\t\t\tfrom 2011refund_apply ra \n\t\t\t\twhere customers_id=:customers_id \n\t\t\t\torder by add_time desc"; $refund_query = $db->bindVars($refund_query, ":customers_id", $_SESSION['customer_id'], "integer"); $refund = $db->Execute($refund_query); $refund_arr = array(); while (!$refund->EOF) {