<?php

namespace domain\manufacturer;

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


/**

 * Class ManufacturerRepository
 * @package domain\marketing\engineernotice
 */
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(SysUser::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();
        $noticeList = $manufacturerFind->all();

        return $noticeList;
    }

    /**
     * 列表页面分页器数量
     * @param string $map
     */
    static function getPageCount($map = '')
    {
        $manufacturerFind = ManufacturerModel::find()->alias("m");
        $manufacturerFind->leftJoin(SysUser::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;
    }
}