qimall/addons/Mch/common/models/MchCate.php

<?php

namespace addons\Mch\common\models;

use common\enums\StatusEnum;
use Yii;

/**
 * This is the model class for table "{{%addons_mch_cate}}".
 *
 * @property int $id
 * @property int $mall_id
 * @property int $parent_id 父级ID
 * @property string $name 分类名称
 * @property string $pic
 * @property string $big_pic
 * @property string|null $advert_pic 广告图片
 * @property string|null $advert_url 广告链接
 * @property string $advert_open_type 打开方式
 * @property string|null $advert_params 导航参数
 * @property int $is_show 是否显示
 * @property int $status 状态[0禁用 1启用 -1删除]
 * @property int $sort 排序
 * @property int $created_at 创建时间
 * @property int $updated_at 修改时间
 */
class MchCate extends \common\models\base\BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_mch_cate}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'parent_id', 'is_show', 'status', 'sort', 'created_at', 'updated_at'], 'integer'],
            [['advert_pic', 'advert_url', 'advert_params'], 'string'],
            [['name'], 'string', 'max' => 45],
            [['pic', 'big_pic'], 'string', 'max' => 255],
            [['advert_open_type'], 'string', 'max' => 65],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => 'Mall ID',
            'parent_id' => '父级ID',
            'name' => '分类名称',
            'pic' => 'Pic',
            'big_pic' => 'Big Pic',
            'advert_pic' => '广告图片',
            'advert_url' => '广告链接',
            'advert_open_type' => '打开方式',
            'advert_params' => '导航参数',
            'is_show' => '是否显示',
            'status' => '状态[0禁用 1启用 -1删除]',
            'sort' => '排序',
            'created_at' => '创建时间',
            'updated_at' => '修改时间',
        ];
    }


    public static function getCates(array $cond = [], array $with = [], bool $is_array = true, string $select = '*')
    {
        $default_cond = [['<>', 'status', StatusEnum::DELETE]];
        $cond = array_merge($default_cond, $cond);
        $query = self::find()->select($select);
        self::paramPack(['where' => $cond, 'with' => $with], $query);
        $cates = $query->asArray($is_array)->all();
        return $cates;
    }
    /**
     * 获取树状分类
     * @Author ewgof
     * @DateTime 2021-08-26 13:00:40
     * @copyright: Copyright (c) 2020 广东七件事集团
     * @param array $cates
     * @param integer $parent_id
     * @return void
     */
    public static function getTreeCate(array $cates, int  $parent_id = 0)
    {
        $tree = [];
        foreach ($cates as $k => $v) {
            $v['value'] = $v['id'];
            $v['label'] = $v['name'];
            if ($v['parent_id'] == $parent_id) {
                $tmp = $v;
                // 当前路由的菜单被选中
                $children = self::getTreeCate($cates, $v['id']);
                $children && $tmp['children'] = $children;
                $tree[] = $tmp;
            }
        }
        return $tree;
    }

    // 关联模型
    public function getParent()
    {
        return $this->hasOne(self::class, ['id' => 'parent_id'])->andWhere(['<>', 'status', StatusEnum::DELETE]);
    }

    public function getChild()
    {
        return $this->hasMany(self::class, ['parent_id' => 'id'])->andWhere(['<>', 'status', StatusEnum::DELETE])->orderBy(['sort' => SORT_ASC, 'created_at' => SORT_DESC]);
    }

    /**
     * 排序
     * @Author ewgof
     * @DateTime 2021-11-12 10:16:01
     * @copyright: Copyright (c) 2020 广东七件事集团
     * @param array $post
     * @return void
     */
    public static function sort(array $post)
    {
        try {
            $first_list = json_decode($post['first_list'], true);
            $second_list = json_decode($post['second_list'], true);
            $third_list = json_decode($post['third_list'], true);
            $t = \Yii::$app->db->beginTransaction();
            self::saveSort($first_list);
            self::saveSort($second_list);
            self::saveSort($third_list);
            $t->commit();
            return true;
        } catch (\Exception $e) {
            self::setStaticError($e->getMessage());
            return false;
        }
    }


    /**
     * 保存分类
     * @Author ewgof
     * @DateTime 2021-11-12 10:18:43
     * @copyright: Copyright (c) 2020 广东七件事集团
     * @param [type] $sort_cates
     * @return void
     */
    private static function saveSort($sort_cates)
    {
        foreach ($sort_cates as $index => $cate) {
            $model = self::findOne($cate['id']);
            if (!$model)  throw new \Exception('分类不存在');
            $model->sort = $index;
            $res = $model->save();
            if (!$res) throw new \Exception($model->getErrorMessage());
        }
    }


    /**
     * 保存数据
     * @Author ewgof
     * @DateTime 2021-08-26 14:16:24
     * @copyright: Copyright (c) 2020 广东七件事集团
     * @param array $params
     * @return object|boolean
     */
    public static function setData(array $params)
    {
        try {
            if (!empty($params['id'])) {
                $model = self::findOne(['and', ['id' => $params['id'], 'mall_id' => $params['mall_id']], ['<>', 'status', StatusEnum::DELETE]]);
                if (empty($model)) throw new \Exception('分类不存在或已删除');
            } else {
                $model = new self();
                $model->loadDefaultValues();
                $model->mall_id = $params['mall_id'];
                $model->parent_id = $params['parent_id'] ?? 0;
            }
            isset($params['advert_params']) && $params['advert_params'] = json_encode($params['advert_params']);
            if (!$model->load($params, '') || !$model->save()) {
                throw new \Exception($model->getErrorMessage());
            }
            return $model;
        } catch (\Exception $e) {
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    /**
     * 获取树状菜单
     * @Author bing
     * @DateTime 2021-08-10 18:22:16
     * @param array $menu 菜单
     * @param integer $parentId
     * @param string $app_id APP_ID
     * @return array
     * @copyright: Copyright (c) 2020 广东七件事集团
     */
    public static function getTreeMenu(array $menu, int $pid = 0)
    {
        $tree = [];
        foreach ($menu as $k => $v) {
            $v['value'] = $v['id'];
            if ($v['parent_id'] == $pid) {
                $tmp = $v;
                $children = self::getTreeMenu($menu, $v['id']);
                $children && $tmp['children'] = $children;
                $tree[] = $tmp;
            }
        }
        return $tree;
    }


    public static function getCateListInDiy(int $mall_id, array $params)
    {
        $wheres[] = ['mall_id' => $mall_id, 'status' => StatusEnum::ENABLED];
        if (!empty($params['keyword'])) {
            $wheres[] = ['like', 'name', $params['keyword']];
        }
        $params = [
            'where' => $wheres,
            'order' => 'sort asc,created_at desc',
            'page' => $params['page'] ?? 1,
            'limit' => $params['limit'] ?? 15,
        ];
        $list = self::listPage($params);
        if (false === $list) {
            return self::$static_error;
        }
        foreach ($list['list'] as &$lv) {
            $lv['title'] = $lv['name'];
        }
        return $list;
    }
}