<?php

namespace domain\manufacturer;

use common\models\SysUser                   as SysUserModel;
use domain\manufacturer\models\Manufacturer as ManufacturerModel;


/**

 * Class ManufacturerRepository
 * @package domain\manufacturer
 */
class ManufacturerRepository
{
    /**
     * @param $where
     * @param $offset
     * @param $limit
     * @return array|\yii\db\ActiveRecord[]
     */
    static function getPageList($where, $offset, $limit)
    {
        $manufacturerFind = ManufacturerModel::find()->alias("m")
                            ->select([
                                "m.*",
                                "su.username",
                                "su.password_hash"
                            ]);
        $manufacturerFind->leftJoin(SysUserModel::tableName() . " su", "su.id = m.sys_user_id");

        if (!empty($where)) {
            $manufacturerFind->where($where);
        }
        if ($offset) {
            $manufacturerFind->offset($offset);
        }
        if ($limit) {
            $manufacturerFind->limit($limit);
        }

        $manufacturerFind->orderBy("m.id desc");
        $manufacturerFind->asArray();
        $dataList = $manufacturerFind->all();

        return $dataList;
    }

    /**
     * 列表页面分页器数量
     * @param string $map
     */
    static function getPageCount($map = '')
    {
        $manufacturerFind = ManufacturerModel::find()->alias("m");
        $manufacturerFind->leftJoin(SysUserModel::tableName() . " su", "su.id = m.sys_user_id");
        if (!empty($map)) {
            $manufacturerFind->where($map);
        }
        $pageCount = $manufacturerFind->count();

        return $pageCount;
    }

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

    /**
     * @param $id
     * @param bool|false $asArr
     * @return null|static
     */
    static function selectInfoById($id, $asArr = false)
    {
        if (empty($id)) {
            return $asArr ? [] : null;
        }
        $manufacturer = ManufacturerModel::find();
        $manufacturer->alias("mf");
        $manufacturer->select(["mf.*", "su.username"]);
        $manufacturer->leftJoin(SysUserModel::tableName() . " su", "su.id = mf.sys_user_id");
        $manufacturer->where("mf.id = " . $id);
        if ($asArr && $manufacturer) {
            $manufacturer = $manufacturer->asArray();
        }
        $resultData = $manufacturer->one();
        return $resultData;
    }

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