/** * 添加物流单号 */ public function addShippingCode() { $code = Input::get('code'); $id = Input::get('orderid'); $printid = Input::get('printid'); $shippingName = Input::get('shippingName'); $msg = ''; if ($code && $id) { //$data = DB::update("update orders set shipping_code = :code where id = :id", ['code'=>$code, 'id'=>$id]); $item = DB::select("select id from item where order_id = '{$id}' order by id desc limit 1"); $itemId = $item[0]->id; $shippingName = '中通'; //$data = DB::update("insert into order_shipping(order_id,item_id,shipping_code,shipping_name,created_at) values('{$id}','{$itemId}','{$code}','{$shippingName}','".date('Y-m-d H:i:s')."')"); $orderShipping = new OrderShipping(); $orderShipping->order_id = $id; $orderShipping->item_id = $itemId; $orderShipping->shipping_code = $code; $orderShipping->shipping_name = $shippingName; // $orderShipping-> = $date('Y-m-d H:i:s'); $rs = $orderShipping->save(); if ($rs) { //修改状态 $orders = Orders::find($id); $orders->status = 12; $orders->save(); $msg = "{$code}物流单号提交成功"; } else { $msg = "{$code}物流单号提交失败"; } } else { return redirect()->route('order.barcode', ['printid' => $printid, 'err' => "错误的物流号或订单号"]); } return redirect()->route('order.barcode', ['printid' => $printid, 'msg' => $msg]); }