<?php

namespace Common\Model;
//[1.8.20]
class RetailPlugStoreModel extends BaseModel
{
    protected $tableName = 'plug_store';
    const ID = 'id';   //int(10) unsigned NOT NULL AUTO_INCREMENT,
    const STORE_ID = 'storeid';   //int(11) DEFAULT NULL COMMENT '门店id',
    const PLUG_ID = 'plug_id';   //int(11) DEFAULT NULL COMMENT '插件id',
    const ADD_TIME = 'addtime';   //varchar(20) DEFAULT NULL COMMENT '添加时间',
    const OPEN_TIME = 'opentime';   // varchar(20) DEFAULT NULL,
    const S_STATUS = 's_status';   // tinyint(1) DEFAULT '0' COMMENT '插件权限状态  0未开启  1开启',
    const STATUS = 'status';   //  tinyint(1) DEFAULT NULL COMMENT '预留字段',

    /**
     * 查询门店是否拥有插件的权限
     * @param $param
     * [
     * storeid
     * identification_arr 插件唯一标识集合
     * ]
     * @return mixed
     */
    public function plug_permissions($fields, $where)
    {
        $list = $this->alias('s')
            ->join('ls_plug as p on p.id=s.plug_id')
            ->field($fields)
            ->where($where)
            ->select();
        return $list;
    }

}