Ejemplo n.º 1
0
    $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'=>'售后',
Ejemplo n.º 2
0
    $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 = "";
    }
Ejemplo n.º 3
0
//所有可用的退款类型
$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) {