hc_live/application/api/model/OrderModel.php

<?php
/**
 * Author: luzheng.liu
 * Time: 2020/12/5 19:52
 */

namespace app\api\model;


use app\common\until\Until;
use think\Db;
use think\Model;

class OrderModel  extends BaseModel {

    const IS_PAY = 2;
    const IS_CLOSE = 3;
    const IS_DELETE = 4;

    protected $table = 'order';


    public function getOrderList() {
        $countModel = $this->alias('o')
            ->join('store store', 'store.id = o.store_id','left')
            ->join('staff staff', 'staff.id = o.staff_id','left')
            ->join('write_off wo', 'wo.order_id = o.id','left')
            ->join('admin ad','ad.id = wo.admin_id','left')
            ->join('user u','u.id = o.user_id','left')
            ->join('discuss_order discussOrder','discussOrder.order_id = o.id and discussOrder.user_id = o.user_id','left');
        $selectModel = $this->alias('o')
            ->field('o.*,store.store_name,store.address,discussOrder.id as discussId,staff.staff_name,wo.write_off_code,
            wo.write_off_status,wo.write_off_time,wo.admin_id as writeOffAdminId,wo.over_time as  writeOffOverTime,
            p.product_name,p.product_img,
            u.name as userName,ad.name as writeOffName')
            ->join('store store', 'store.id = o.store_id','left')
            ->join('staff staff', 'staff.id = o.staff_id','left')
            ->join('product p', 'p.id = o.product_id','left')
            ->join('write_off wo', 'wo.order_id = o.id','left')
            ->join('user u','u.id = o.user_id','left')
            ->join('admin ad','ad.id = wo.admin_id','left')
            ->join('discuss_order discussOrder','discussOrder.order_id = o.id and discussOrder.user_id = o.user_id','left')
            ->order('o.id desc');
        return $this->joinModelPageList($countModel, $selectModel);

    }


    public function getOrderInfo() {
        $selectModel = $this->alias('o')
            ->field('o.*,store.store_name,store.address,store.mobile as storeMobile,discussOrder.id as discussId,staff.staff_name,wo.write_off_code,
            wo.write_off_status,wo.write_off_time,wo.admin_id as writeOffAdminId,wo.over_time as writeOffOverTime,wo.create_time as writeOffCreateTime,
            p.product_name,p.product_img,store.latitude,store.longitude,ad.name as writeOffName')
            ->join('store store', 'store.id = o.store_id','left')
            ->join('staff staff', 'staff.id = o.staff_id','left')
            ->join('product p', 'p.id = o.product_id','left')
            ->join('write_off wo', 'wo.order_id = o.id','left')
            ->join('admin ad','ad.id = wo.admin_id','left')
            ->join('discuss_order discussOrder','discussOrder.order_id = o.id and discussOrder.user_id = o.user_id','left')
            ->where($this->getWhere())
            ->find();
        return Until::modelToArray($selectModel);
    }

}