hc_live/application/api/model/CompanyModel.php

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

namespace app\api\model;

use app\common\until\Until;

class CompanyModel  extends BaseModel {

    protected $table = 'company';

    public function getCompanyList() {
        $countModel = $this->alias('c')
            ->join('group g','g.id = c.group_id')
            ->join('pay_config p','p.pay_code = c.pay_code','left');

        $selectModel = $this->alias('c')
            ->field('c.*,g.group_name,p.pay_code')
            ->join('group g','g.id = c.group_id')
            ->join('pay_config p','p.pay_code = c.pay_code','left')
            ->order(['c.id' => 'desc']);
        return $this->joinModelPageList($countModel, $selectModel);
    }

    public function getCompanyInfo() {
        $selectModel = $this->alias('c')
            ->field('c.*,g.group_name,p.pay_code')
            ->join('group g','g.id = c.group_id','left')
            ->join('pay_config p','p.id = c.pay_id','left')
            ->where($this->getWhere())
            ->find();
        return Until::modelToArray($selectModel);
    }
}