<?php

namespace domain\upgrade;

use domain\device\models\Device                 as DeviceModel;
use domain\manufacturer\models\Manufacturer     as ManufacturerModel;
use domain\model\models\Model;
use domain\project\models\Project;
use domain\upgrade\models\UpgradeLog            as UpgradeLogModel;


/**

 * Class UpgradeLogRepository
 * @package domain\model
 */
class UpgradeLogRepository
{
    /**
     * 获取分页数据
     * @param $where
     * @param $offset
     * @param $limit
     * @return array|\yii\db\ActiveRecord[]
     */
    static function getPageList($where, $offset, $limit)
    {
        $upgradeFind = UpgradeLogModel::find()->alias("ul")
                            ->select([
                                "ul.*",
                                "mf.name as manufacture_name",
                                'de.serial_no',
                                'de.device_id as device_device_id',
                                'pj.name as project_name',
                                'md.name as model_name',
                            ]);
        $upgradeFind->leftJoin(ManufacturerModel::tableName() . " mf", "mf.id = ul.manufacture_id");
        $upgradeFind->leftJoin(DeviceModel::tableName() . " de", "de.id = ul.device_id");
        $upgradeFind->leftJoin(Project::tableName() . " pj", "pj.id = ul.project_id");
        $upgradeFind->leftJoin(Model::tableName() . " md", "md.id = ul.model_id");

        if (!empty($where)) {
            $upgradeFind->where($where);
        }
        if ($offset) {
            $upgradeFind->offset($offset);
        }
        if ($limit) {
            $upgradeFind->limit($limit);
        }
        $upgradeFind->orderBy("ul.id desc");
        $upgradeFind->asArray();
        $dataList = $upgradeFind->all();

        return $dataList;
    }

    /**
     * 列表页面分页器数量
     * @param string $map
     */
    static function getPageCount($map = '')
    {
        $upgradeFind = UpgradeLogModel::find()->alias("ul");
        $upgradeFind->leftJoin(ManufacturerModel::tableName() . " mf", "mf.id = ul.manufacture_id");
        $upgradeFind->leftJoin(DeviceModel::tableName() . " de", "de.id = ul.device_id");
        $upgradeFind->leftJoin(Project::tableName() . " pj", "pj.id = ul.project_id");
        $upgradeFind->leftJoin(Model::tableName() . " md", "md.id = ul.model_id");
        if (!empty($map)) {
            $upgradeFind->where($map);
        }
        $pageCount = $upgradeFind->count();

        return $pageCount;
    }

    /**
     * @param $id
     * @param bool|false $asArr
     * @return null|static
     */
    static function selectOne($id, $asArr = false)
    {
        $model = UpgradeLogModel::findOne($id);
        if ($asArr && $model) {
            $model = $model->toArray();
        }
        return $model;
    }

    /**
     * @param $id
     * @param bool|false $asArr
     * @return null|static
     */
    static function findOne($condition)
    {
        $model = UpgradeLogModel::findOne($condition);
        return $model;
    }
}