['property_head_id', 'activity_name', 'activity_start_time', 'activity_end_time','page_type'], ]; } /** * 获取数据权限 * $this->adminInfo['data_rules'] * province city admin_id sale_group_id sale_id property_head_id */ public function queryDataWhere(){ $where = []; $data_rules = $this->adminInfo['data_rules']; if (isset($data_rules['province']) && !empty($data_rules['province'])) { $where[] = ['province','in' ,$data_rules['province']]; } if (isset($data_rules['city']) && !empty($data_rules['city'])) { $where[] = ['city','in' ,$data_rules['city']]; } if(!empty($where)){ $head_ids = PropertyHead::where($where)->column('id')??[0]; $where = [['property_head_id','in' ,$head_ids]]; } return $where; } /** * @notes 获取列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author likeadmin * @date 2024/11/21 15:04 */ public function lists(): array { return PropertyActivity::with(['propertyHeadInfo']) ->where($this->searchWhere)->where($this->queryDataWhere()) ->field(['id', 'property_head_id', 'activity_name', 'activity_start_time', 'activity_end_time','block_data','coupon_data','url_page','page_type','images']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2024/11/21 15:04 */ public function count(): int { return PropertyActivity::where($this->searchWhere)->where($this->queryDataWhere())->count(); } }