hc_live/application/api/model/OrderRoomModel.php

<?php
/**
 * Author: luzheng.liu
 * Time: 2021/4/26 14:45
 */

namespace app\api\model;


use app\common\until\Until;

class OrderRoomModel extends BaseModel {

    protected $table = 'order_room';

    public function getRoomList() {
        $rs = $this->alias('or')
            ->field('or.*,
            as.server_start_time,as.status as asStatus,as.server_end_time,s.staff_name,op.product_snap,
            u.name,u.real_name,o.order_type')
            ->join('room r','r.id = or.room_id')
            ->join('order o','o.id = or.order_id')
            ->join('allocate_staff as','as.order_id = o.id')
            ->join('staff s','s.id = as.staff_id')
            ->join('order_product op','op.order_id = o.id')
            ->join('user u','u.id = o.user_id','left')
            ->where($this->getWhere())
            ->select();
        return Until::modelToArray($rs);
    }

    public function getfreeRoomList() {
        $model = new OrderModel();
        $rs = $model->alias('o')
            ->field('o.id as orderId,o.staff_id')
            ->join('order_room or','o.id = or.order_id','left')
            ->join('allocate_staff as','as.order_id = o.id')
            ->join('staff s','s.id = as.staff_id')
            ->where($this->getWhere())
            ->select();
        return Until::modelToArray($rs);
    }

}