### 根據訂單ID和訂單類型獲取訂單詳細信息 **位置：** Common\Lib\FlowLib.class.php **參數：** * @param $order_id int 訂單ID * @param $order_type int 訂單類型 * @return $order array 訂單信息 **調用：** * $flow = new FlowLib(); * $order_arr = $flow->orderInfo($order_id, $order_type); **完整代碼：** ~~~ /** * 訂單詳情信息 * @param $order_id int 訂單ID * @param $order_type int 訂單類型 * @return array 訂單信息 * whz 2018-01-25 * */ public function orderInfo($order_id, $order_type) { //1、訂單信息 $order_info = M("wms_flow") ->where(array('order_type'=>$order_type, 'id'=>$order_id)) ->find(); $order['order_info'] = $order_info; //2、訂單錄入的SKU信息 $order_sku = M('wms_sku as s') ->field('s.id,s.sku,n.name_zh,u.color_id,u.size_id,s.num') ->join('coscia_goods_sku as u on s.sku_id = u.id','left') ->join('coscia_goods_menu as n on u.menu_id = n.id','left') ->where(array('s.type'=>$order_type, 's.order_id'=>$order_id)) ->select(); foreach ($order_sku as $kk => $vv) { //通過SKU表里面的color_id和size_id查詢名字 $goods = new GoodsLib(); $color = $goods->getBaseValue($vv['color_id'], 'name'); $size = $goods->getBaseValue($vv['size_id'], 'name'); $order_sku[$kk]['color'] = $color; $order_sku[$kk]['size'] = $size; } //3、統計SKU商品掃描數量統計 foreach ($order_sku as $key => $value) { $goods_id = $value['id']; //當前SKU已經配貨掃描的數量 $exit_count = M('wms_no') ->where(array('goods_id'=>$goods_id, 'is_delete'=>0)) ->count(); //當前SKU差異數 $order_sku[$key]['variance'] = $value['num'] - $exit_count; } $order['order_sku'] = $order_sku; //4、訂單錄入的唯一碼信息 $order_no = M("wms_no") ->where(array('type'=>$order_type, 'order_id'=>$order_id)) ->select(); $order['order_no'] = $order_no; //5、訂單裝箱單信息 $order_box = M("wms_box") ->where(array("type"=>$order_type, "order_id"=>$order_id)) ->select(); foreach ($order_box as $k => $v) { $no_num = M('wms_no') ->where(array('box_id'=>$v['id'], 'is_delete'=>0)) ->count(); $order_box[$k]['num'] = $no_num; } foreach ($order_box as $key => $value) { $num = M('wms_no') ->where(array('box_id'=>$value['id'], 'status'=>2)) ->count(); $order_box[$key]['scanning'] = $num; } $order['order_box'] = $order_box; //6、訂單的日志信息 $order_log = M('wms_log as log') ->order("create_time desc") ->where(array('order_id'=>$order_id, 'type'=>$order_type)) ->select(); $order['order_log'] = $order_log; //7、已錄入的唯一碼信息 $no_list = M('wms_no as o') ->field('o.*,o.status,no.no,u.supply_style_no,u.name_zh,no.color_name,no.color,no.size') ->join('coscia_goods_no as no on o.no_id = no.id','left') ->join('coscia_goods_menu as u on no.menu_id = u.id','left') ->where(array('o.order_id'=>$order_id, 'o.type'=>$order_type, 'o.is_delete'=>0)) ->select(); $order['no_list'] = $no_list; return $order; } ~~~