private function queryOrder($out_trade_no, $inStatus = '') { if (isset($out_trade_no) && $out_trade_no != "") { $input = new WxPayOrderQuery(); $input->SetOut_trade_no($out_trade_no); $info = WxPayApi::orderQuery($input); if ($inStatus == 'code') { return $info['trade_state']; } $status = orderState($info['trade_state']); } return $status; }
public function complain_showOp() { $complain_id = intval($_GET['complain_id']); //获取投诉详细信息 $complain_info = $this->get_complain_info($complain_id); //获取订单详细信息 $model_order = Model('order'); $order_info = $model_order->getOrderInfo(array('order_id' => $complain_info['order_id'])); if ($order_info['store_id'] != $_SESSION['store_id']) { showMessage(Language::get('para_error'), '', 'html', 'error'); } $order_info['order_state_text'] = orderState($order_info); //获取投诉的商品列表 $model_complain_goods = Model('complain_goods'); $param = array(); $param['complain_id'] = $complain_id; $complain_goods_list = $model_complain_goods->getComplainGoods($param); $page_name = ''; switch (intval($complain_info['complain_state'])) { case self::STATE_NEW: $page_name = 'complain.info'; break; case self::STATE_APPEAL: $page_name = 'complain.appeal'; break; case self::STATE_TALK: $page_name = 'complain.talk'; break; case self::STATE_HANDLE: $page_name = 'complain.talk'; break; case self::STATE_FINISH: $page_name = 'complain.info'; break; default: showMessage(Language::get('para_error'), '', 'html', 'error'); } Tpl::output('order_info', $order_info); Tpl::output('complain_info', $complain_info); Tpl::output('complain_goods_list', $complain_goods_list); Tpl::output('left_show', 'order_view'); Tpl::showpage($page_name); }
/** * 生成excel * * @param array $data */ private function createExcel($data = array()) { Language::read('export'); import('libraries.excel'); $excel_obj = new Excel(); $excel_data = array(); //设置样式 $excel_obj->setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1'))); //header $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_no')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_store')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_buyer')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_xtimd')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_count')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_yfei')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_paytype')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_state')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_storeid')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_buyerid')); $excel_data[0][] = array('styleid' => 's_title', 'data' => L('exp_od_bemail')); //data foreach ((array) $data as $k => $v) { $tmp = array(); $tmp[] = array('data' => 'NC' . $v['order_sn']); $tmp[] = array('data' => $v['store_name']); $tmp[] = array('data' => $v['buyer_name']); $tmp[] = array('data' => date('Y-m-d H:i:s', $v['add_time'])); $tmp[] = array('format' => 'Number', 'data' => ncPriceFormat($v['order_amount'])); $tmp[] = array('format' => 'Number', 'data' => ncPriceFormat($v['shipping_fee'])); $tmp[] = array('data' => orderPaymentName($v['payment_code'])); $tmp[] = array('data' => orderState($v)); $tmp[] = array('data' => $v['store_id']); $tmp[] = array('data' => $v['buyer_id']); $tmp[] = array('data' => $v['buyer_email']); $excel_data[] = $tmp; } $excel_data = $excel_obj->charset($excel_data, CHARSET); $excel_obj->addArray($excel_data); $excel_obj->addWorksheet($excel_obj->charset(L('exp_od_order'), CHARSET)); $excel_obj->generateXML($excel_obj->charset(L('exp_od_order'), CHARSET) . $_GET['curpage'] . '-' . date('Y-m-d-H', time())); }
/** * 取得订单列表(所有) * @param unknown $condition * @param string $pagesize * @param string $field * @param string $order * @param string $limit * @param unknown $extend 追加返回那些表的信息,如array('order_common','order_goods','store') * @return Ambigous <multitype:boolean Ambigous <string, mixed> , unknown> */ public function getOrderList($condition, $pagesize = '', $field = '*', $order = 'order_id desc', $limit = '', $extend = array(), $master = false) { $list = $this->table('order')->field($field)->where($condition)->page($pagesize)->order($order)->limit($limit)->master($master)->select(); if (empty($list)) { return array(); } $order_list = array(); foreach ($list as $order) { if (isset($order['order_state'])) { $order['state_desc'] = orderState($order); } if (isset($order['payment_code'])) { $order['payment_name'] = orderPaymentName($order['payment_code']); } if (!empty($extend)) { $order_list[$order['order_id']] = $order; } } if (empty($order_list)) { $order_list = $list; } //追加返回订单扩展表信息 if (in_array('order_common', $extend)) { $order_common_list = $this->getOrderCommonList(array('order_id' => array('in', array_keys($order_list)))); foreach ($order_common_list as $value) { $order_list[$value['order_id']]['extend_order_common'] = $value; $order_list[$value['order_id']]['extend_order_common']['reciver_info'] = @unserialize($value['reciver_info']); $order_list[$value['order_id']]['extend_order_common']['invoice_info'] = @unserialize($value['invoice_info']); } } //追加返回店铺信息 if (in_array('store', $extend)) { $store_id_array = array(); foreach ($order_list as $value) { if (!in_array($value['store_id'], $store_id_array)) { $store_id_array[] = $value['store_id']; } } $store_list = Model('store')->getStoreList(array('store_id' => array('in', $store_id_array))); $store_new_list = array(); foreach ($store_list as $store) { $store_new_list[$store['store_id']] = $store; } foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_store'] = $store_new_list[$order['store_id']]; } } //追加返回买家信息 if (in_array('member', $extend)) { foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_member'] = Model('member')->getMemberInfoByID($order['buyer_id']); } } //追加返回商品信息 if (in_array('order_goods', $extend)) { //取商品列表 $order_goods_list = $this->getOrderGoodsList(array('order_id' => array('in', array_keys($order_list)))); if (!empty($order_goods_list)) { foreach ($order_goods_list as $value) { $order_list[$value['order_id']]['extend_order_goods'][] = $value; } } else { $order_list[$value['order_id']]['extend_order_goods'] = array(); } } return $order_list; }
/** * 物流跟踪 */ public function search_deliverOp() { Language::read('member_member_index'); $lang = Language::getLangContent(); $order_sn = $_GET['order_sn']; if (!is_numeric($order_sn)) { showMessage(Language::get('wrong_argument'), '', 'html', 'error'); } $model_order = Model('order'); $condition['order_sn'] = $order_sn; $condition['store_id'] = $_SESSION['store_id']; $order_info = $model_order->getOrderInfo($condition, array('order_common', 'order_goods')); if (empty($order_info) || $order_info['shipping_code'] == '') { showMessage('未找到信息', '', 'html', 'error'); } $order_info['state_info'] = orderState($order_info); Tpl::output('order_info', $order_info); //卖家发货信息 $daddress_info = Model('daddress')->getAddressInfo(array('address_id' => $order_info['extend_order_common']['daddress_id'])); Tpl::output('daddress_info', $daddress_info); //取得配送公司代码 $express = rkcache('express', true); Tpl::output('e_code', $express[$order_info['extend_order_common']['shipping_express_id']]['e_code']); Tpl::output('e_name', $express[$order_info['extend_order_common']['shipping_express_id']]['e_name']); Tpl::output('e_url', $express[$order_info['extend_order_common']['shipping_express_id']]['e_url']); Tpl::output('shipping_code', $order_info['shipping_code']); self::profile_menu('search', 'search'); Tpl::showpage('store_deliver.detail'); }
private function get_order_info($order_id) { if (empty($order_id)) { showMessage(Language::get('para_error'), '', 'html', 'error'); } $model_order = Model('order'); $order_info = $model_order->getOrderInfo(array('order_id' => $order_id), array('order_goods')); if ($order_info['buyer_id'] != $_SESSION['member_id']) { showMessage(Language::get('para_error'), '', 'html', 'error'); } $order_info['order_state_text'] = orderState($order_info); return $order_info; }
echo count($order_info['extend_order_goods']); ?> </strong>种商品</span> <?php } ?> </dt> <dd><span class="order-date">下单时间:<?php echo date('Y-m-d H:i:s', $order_info['add_time']); ?> </span><span class="ncm-order-price">订单金额:<em>¥<?php echo $order_info['order_amount']; ?> </em></span></dd> <dd><span class="order-state">订单状态:<?php echo strip_tags(orderState($order_info)); ?> <?php if ($order_info['if_deliver']) { ?> <a href='index.php?act=member_order&op=search_deliver&order_id=<?php echo $order_info['order_id']; ?> &order_sn=<?php echo $order_info['order_sn']; ?> ' target="_blank"><i class="icon-truck"></i>查看物流</a> <?php } ?> </span> </dd>
:</strong><?php echo $output['order_info']['order_sn']; ?> ( 支付单号 <?php echo $lang['nc_colon']; ?> <?php echo $output['order_info']['pay_sn']; ?> ) </li> <li><strong><?php echo $lang['order_state']; ?> :</strong><?php echo orderState($output['order_info']); ?> </li> <li><strong><?php echo $lang['order_total_price']; ?> :</strong><span class="red_common"><?php echo $lang['currency'] . $output['order_info']['order_amount']; ?> </span> <?php if ($output['order_info']['refund_amount'] > 0) { ?> (<?php echo $lang['order_refund']; ?>
private function get_order_info($order_id) { $model_order = Model('order'); $order_info = $model_order->getOrderInfo(array('order_id' => $order_id), array('order_goods')); if (empty($order_info)) { showMessage(Language::get('param_error')); } $order_info['order_state_text'] = orderState($order_info); return $order_info; }
/** * 取得订单列表 * @param unknown $condition * @param string $pagesize * @param string $field * @param string $order * @param string $limit * @param unknown $extend 追加返回那些表的信息,如array('order_common','order_goods','store') * @return Ambigous <multitype:boolean Ambigous <string, mixed> , unknown> */ public function getOrderList($condition, $pagesize = '', $field = '*', $order = 'order_id desc', $limit = '', $extend = array()) { $list = $this->table('sell_order')->field($field)->where($condition)->order($order)->select(); if (empty($list)) { return array(); } $order_list = array(); foreach ($list as $order) { $order['state_desc'] = orderState($order); //$order['payment_name'] = orderPaymentName($order['payment_code']); if (!empty($extend)) { $order_list[$order['order_id']] = $order; } } if (empty($order_list)) { $order_list = $list; } $orderArr = $order_list[$order['order_id']]; $order_id = $orderArr['order_id']; //print_r($order_list);die; // if (empty($order_list)) $order_list = $list; //$order_list[$order_id]['buyer_id'] = $_SESSION['member_id']; //echo $order_list[0]['member_id'].'====<br />'; //print_r($order_list);die; //追加返回订单扩展表信息 if (in_array('sell_order_common', $extend)) { $order_common_list = $this->getOrderCommonList(array('order_id' => array('in', array_keys($order_list)))); foreach ($order_common_list as $value) { $order_list[$value['order_id']]['extend_order_common'] = $value; $order_list[$value['order_id']]['extend_order_common']['reciver_info'] = @unserialize($value['reciver_info']); // $order_list[$value['order_id']]['extend_order_common']['invoice_info'] = @unserialize($value['invoice_info']); } } /* //追加返回店铺信息 if (in_array('store',$extend)) { $store_id_array = array(); foreach ($order_list as $value) { if (!in_array($value['store_id'],$store_id_array)) $store_id_array[] = $value['store_id']; } $store_list = Model('store')->getStoreList(array('store_id'=>array('in',$store_id_array))); $store_new_list = array(); foreach ($store_list as $store) { $store_new_list[$store['store_id']] = $store; } foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_store'] = $store_new_list[$order['store_id']]; } } //追加返回买家信息 if (in_array('member',$extend)) { $member_id_array = array(); foreach ($order_list as $value) { if (!in_array($value['buyer_id'],$member_id_array)) $member_id_array[] = $value['buyer_id']; } $member_list = Model()->table('member')->where(array('member_id'=>array('in',$member_id_array)))->limit($pagesize)->key('member_id')->select(); foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_member'] = $member_list[$order['buyer_id']]; } }*/ //追加返回该商品官方库存总数信息 if (in_array('goods', $extend)) { foreach ($order_list as $k => $v) { $field = 'goods_storage'; //$where = array('goods_id'=>array('in',self::array_column($order_list,'goods_id'))); $where = 'goods_id = ' . $v['goods_id']; $goods_storage_array = Model('goods')->getGoodsList($where, $field); $order_list[$v['order_id']]['extend_order_common']['goods_storage'] = $goods_storage_array[0]['goods_storage']; } //print_r($order_list[$value['order_id']]); die; foreach ($goods_storage_array as $value) { $order_list[$order_id]['extend_order_common']['goods_storage'] = $value['goods_storage']; // print_r($order_list); die; } } //追加返回分销商库存商品信息 if (in_array('order_goods', $extend)) { //取商品 $table_order = $GLOBALS['config']['tablepre'] . 'order'; $table_order_goods = $GLOBALS['config']['tablepre'] . 'order_goods'; foreach ($order_list as $v) { $field = " SUM({$table_order_goods}.goods_num) as goodsnum "; $wheregoods = " where {$table_order}.order_state='20' and {$table_order}.order_id={$table_order_goods}.order_id and {$table_order_goods}.buyer_id=" . $_SESSION['member_id'] . " and {$table_order_goods}.goods_id={$v['goods_id']}"; $sql = 'SELECT ' . $field . ' FROM ' . $table_order . ',' . $table_order_goods . $wheregoods; $goods_buyer_storage_array = Model()->query($sql); $order_list[$v['order_id']]['extend_order_common']['goods_buyer_storage'] = $goods_buyer_storage_array[0]['goodsnum']; } //$getGoods_idArr=self::array_column($order_list,'goods_id'); //$where = array('order_goods.goods_id'=>array('in',self::array_column($order_list,'goods_id')),'order_goods.order_state'=>'20'); // print_r($sql);die; // $goods_storage_array = Model('goods')->getGoodsList($where, $field); // foreach ($goods_buyer_storage_array as $value) { // $order_list[$order_id]['extend_order_common']['goods_buyer_storage'] = $value['goodsnum']; // print_r($order_list); die; // } } // print_r($goods_id); die; // print_r(array('goods_id'=>array('in',self::array_column($order_list,'goods_id'))));die; //追加返回商品信息 if (in_array('sell_order_goods', $extend)) { //取商品列表 //$order_goods_list = $this->getOrderGoodsList(array('goods_id'=>array('in',array_keys($order_list))); //print_r(array('goods_id'=>$order_list[$order['order_id']]['goods_id'],'buyer_id'=>$order_list[$order['order_id']]['buyer_id']));die; //$order_goods_list = $this->getOrderGoodsList(array('goods_id'=>array('in',self::array_column($order_list,'goods_id')))); $order_goods_list = $this->getOrderGoodsList(array('order_id' => array('in', array_keys($order_list)))); foreach ($order_goods_list as $value) { $value['goods_image_url'] = cthumb($value['goods_image'], 240); $order_list[$value['order_id']]['extend_order_goods'][] = $value; //$order_list[$value['order_id']]['extend_order_goods'][] = $goods_storage; } } // print_r($order_list); die; return $order_list; }
?> </td> <td class="nowrap align-center"><?php echo date('Y-m-d H:i:s', $order['add_time']); ?> </td> <td class="align-center"><?php echo $order['order_amount']; ?> </td> <td class="align-center"><?php echo orderPaymentName($order['payment_code']); ?> </td> <td class="align-center"><?php echo orderState($order); ?> </td> <td class="w144 align-center"><a href="index.php?act=order&op=show_order&order_id=<?php echo $order['order_id']; ?> "><?php echo $lang['nc_view']; ?> </a> <!-- 取消订单 --> <?php if ($order['if_cancel']) { ?> | <a href="javascript:void(0)" onclick="if(confirm('<?php
/** * 取得订单列表 * @param unknown $condition * @param string $pagesize * @param string $field * @param string $order * @param string $limit * @param unknown $extend 追加返回那些表的信息,如array('order_common','order_goods','store') * @return Ambigous <multitype:boolean Ambigous <string, mixed> , unknown> */ public function getOrderList($condition, $pagesize = '', $field = '*', $order = 'order_id desc', $limit = '', $extend = array()) { $list = $this->table('order')->field($field)->where($condition)->page($pagesize)->order($order)->limit($limit)->select(); if (empty($list)) { return array(); } $order_list = array(); foreach ($list as $order) { $order['state_desc'] = orderState($order); $order['payment_name'] = orderPaymentName($order['payment_code']); if (!empty($extend)) { $order_list[$order['order_id']] = $order; } } if (empty($order_list)) { $order_list = $list; } //追加返回订单扩展表信息 if (in_array('order_common', $extend)) { $order_common_list = $this->getOrderCommonList(array('order_id' => array('in', array_keys($order_list)))); foreach ($order_common_list as $value) { $order_list[$value['order_id']]['extend_order_common'] = $value; $order_list[$value['order_id']]['extend_order_common']['reciver_info'] = @unserialize($value['reciver_info']); $order_list[$value['order_id']]['extend_order_common']['invoice_info'] = @unserialize($value['invoice_info']); } } //追加返回店铺信息 if (in_array('store', $extend)) { $store_id_array = array(); foreach ($order_list as $value) { if (!in_array($value['store_id'], $store_id_array)) { $store_id_array[] = $value['store_id']; } } $store_list = Model('store')->getStoreList(array('store_id' => array('in', $store_id_array))); $store_new_list = array(); foreach ($store_list as $store) { $store_new_list[$store['store_id']] = $store; } foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_store'] = $store_new_list[$order['store_id']]; } } //追加返回买家信息 if (in_array('member', $extend)) { $member_id_array = array(); foreach ($order_list as $value) { if (!in_array($value['buyer_id'], $member_id_array)) { $member_id_array[] = $value['buyer_id']; } } $member_list = Model()->table('member')->where(array('member_id' => array('in', $member_id_array)))->limit($pagesize)->key('member_id')->select(); foreach ($order_list as $order_id => $order) { $order_list[$order_id]['extend_member'] = $member_list[$order['buyer_id']]; } } //追加返回商品信息 if (in_array('order_goods', $extend)) { //取商品列表 $order_goods_list = $this->getOrderGoodsList(array('order_id' => array('in', array_keys($order_list)))); foreach ($order_goods_list as $value) { $value['goods_image_url'] = cthumb($value['goods_image'], 240, $value['store_id']); $order_list[$value['order_id']]['extend_order_goods'][] = $value; } } //追加返回商品goods_serial if (in_array('goods', $extend)) { $goods_id_list = $this->getGoodsList(array('goods_id' => array('in', array_keys($order_lis['extend_order_goods'])))); $field = 'goods_serial'; $where = array('goods_id' => array('in', self::array_column($order_list, 'goods_id'))); $goods_storage_array = Model('goods')->getGoodsList($where, $field); foreach ($goods_storage_array as $value) { $order_list[$order_id]['extend_order_common']['goods_serial'] = $value['goods_serial']; } } return $order_list; }
/** * 取单条订单信息 * * @param unknown_type $condition * @param array $extend 追加返回那些表的信息,如array('order_common','order_goods','store') * @return unknown */ public function getself_OrderInfo($condition = array(), $extend = array(), $fields = '*', $order = '', $group = '') { $model_order = Model('sell_order'); $order_info = $model_order->table('sell_order')->field($fields)->where($condition)->group($group)->order($order)->find(); if (empty($order_info)) { return array(); } //print_r($order_info);die; $order_info['state_desc'] = orderState($order_info); // $order_info['payment_name'] = orderPaymentName($order_info['payment_code']); /* //追加返回订单扩展表信息 if (in_array('order_common',$extend)) { $order_info['extend_order_common'] = $this->getOrderCommonInfo(array('order_id'=>$order_info['order_id'])); $order_info['extend_order_common']['reciver_info'] = unserialize($order_info['extend_order_common']['reciver_info']); $order_info['extend_order_common']['invoice_info'] = unserialize($order_info['extend_order_common']['invoice_info']); } //追加返回店铺信息 if (in_array('store',$extend)) { $order_info['extend_store'] = Model('store')->getStoreInfo(array('store_id'=>$order_info['store_id'])); } //返回买家信息 if (in_array('member',$extend)) { $order_info['extend_member'] = Model('member')->getMemberInfo(array('member_id'=>$order_info['buyer_id'])); } */ //追加返回商品信息 if (in_array('goods', $extend)) { //取商品列表 $order_goods_list = $this->getOrderGoodsList(array('goods_id' => $order_info['goods_id'])); foreach ($order_goods_list as $value) { $order_info['extend_order_goods'][] = $value; } } return $order_info; }