### 根据订单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; } ~~~