cangjin/application/Admin/controller/Order.php

<?php


namespace app\Admin\controller;
use think\Db;

class Order extends Base
{
 public function __construct()
 {
     parent::__construct();
 }

 public function list(){
     $page = isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) : 1;
     $size = isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :10;
     $status = isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']) :"";
     $where=[];
     if($status!==""){
         $where['status'] = $status;
     }
     $username =  isset($this->post['username'])&&$this->post['username']!=="" ? trim($this->post['username']) :"";
     if($username!=""){
         $where['username'] = ["like","%{$username}%"];
     }
     $nickname =  isset($this->post['nickname'])&&$this->post['nickname']!=="" ? trim($this->post['nickname']) :"";
     if($nickname!=""){
         $where['nickname'] = ["like","%{$nickname}%"];
     }
     $mobile =  isset($this->post['mobile'])&&$this->post['mobile']!=="" ? trim($this->post['mobile']) :"";
     if($mobile!=""){
         $where['mobile'] = ["like","%{$mobile}%"];
     }
     $order_low =  isset($this->post['order_low'])&&$this->post['order_low']!=="" ? $this->post['order_low'] :"";
     if($order_low!="") {
         $order_low = date("Y-m-d H:i:s", strtotime($order_low . " 00:00:00"));
     }else{
         $order_low = "1970-01-01 00:00:00";
     }
     $order_up =  isset($this->post['order_up'])&&$this->post['order_up']!=="" ? $this->post['order_up'] :"";
     if($order_up!=""){
         $order_up = date("Y-m-d H:i:s",strtotime($order_up." 23:59:59"));
     }else{
         $order_up = date("Y-m-d H:i:s");
     }
     $where['order_time'] = ["between",[$order_low,$order_up]];
     $count= Db::name("order_info")->where($where)->count();
     $total = ceil($count/$size);
     $page = $page>=$total? $total:$page;
     $list = Db::name("order_info")->where($where)->page($page,$size)->field("id,order_sn,username,nickname,order_num,
     post_code,post_name,status,contector,contector_mobile,provice_name,city_name,area_name,addr,delivery_time,order_time")
         ->order("order_time desc")
         ->select();
     return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
 }

    /**
     * @param ordersn
     * @param post_code
     * @param post_company
     */
 public function OrderDelivery(){
     $ordersn = isset($this->post['ordersn'])&&$this->post['ordersn']!="" ? trim($this->post['ordersn']):"";
     if($ordersn==""){
        return error_show(1004,"参数ordersn 不能为空");
     }
     $orderinfo = Db::name("order")->where(["order_sn"=>$ordersn])->find();
     if(empty($orderinfo)){
         return error_show(1005,"订单不存在");
     }
     if($orderinfo['is_del']==1){
         return error_show(1005,"订单已删除");
     }
     if($orderinfo['status']!=1){
         return error_show(1005,"订单状态有误");
     }
     $orderpost = Db::name("order_post")->where(["order_sn"=>$ordersn,"is_del"=>0])->find();
     if(empty($orderpost)){
         return error_show(1005,"订单地址信息不存在");
     }
     $post_code = isset($this->post['post_code'])&&$this->post['post_code']!="" ? trim($this->post['post_code']):"";
     if($post_code==""){
         return error_show(1004,"参数post_code 不能为空");
     }
     $post_company = isset($this->post['post_company'])&&$this->post['post_company']!="" ? trim($this->post['post_company']):"";
     if($post_company==""){
         return error_show(1004,"参数post_company 不能为空");
     }
     $orderpost['post_code']=$post_code;
     $orderpost['post_name']=$post_company;
     $orderpost['updatetime']=date("Y-m-d H:i:s");
     Db::startTrans();
     try {
         $psot=Db::name("order_post")->update($orderpost);
         if($psot){
             $orderinfo['status']=2;
             $orderinfo['delivery_time']=date("Y-m-d H:i:s");
            $order= Db::name("order")->update($orderinfo);
            if($order){
                write_log("订单{$ordersn}发货",$this->userinfo,"order","edit","0");
                Db::commit();
                return app_show(0,"订单物流信息新建成功");
            }
         }
         Db::rollback();
         return error_show(1004,"物流信息新建失败");
     }catch (\Exception $e){
         Db::rollback();
         return error_show(1004,$e->getMessage());
     }
 }
}