AppealModel::STATUS, ]); } public function listAppeal() { $map = $this->dealEqualInput(['status']); $daterange = input('daterange/s', ""); if (!empty($daterange)) { $daterangearr = explode("~", $daterange); $map[] = ['create_time', '>= time', strtotime(trim($daterangearr[0]))]; $map[] = ['create_time', '<= time', strtotime(trim($daterangearr[1]))]; } $list = AppealModel::where($map) ->order(['status' => 'asc', 'create_time' => 'desc']) ->limit(input('limit')) ->page(input('page')) ->append(['status_text']) ->select(); $count = AppealModel::where($map)->count(); if ($count == 0) { ajax_return(1, '未查询到数据'); } list_return($list, $count); } public function dealAppeal() { $id_arr = input('id_arr/a'); AppealModel::update(['status' => 2], ['id' => $id_arr]); ajax_return(); } public function exportAppeal() { $map = $this->dealInInput(['id'], $this->dealEqualInput(['status'])); $daterange = input('daterange/s', ""); if (!empty($daterange)) { $daterangearr = explode("~", $daterange); $map[] = ['create_time', '>= time', strtotime(trim($daterangearr[0]))]; $map[] = ['create_time', '<= time', strtotime(trim($daterangearr[1]))]; } $list = AppealModel::where($map) ->order(['status' => 'asc', 'create_time' => 'desc']) ->append(['status_text']) ->select(); $xlsCell = [ ['company_name', '企业名称'], ['company_contact', '联系人及职务'], ['street', '镇街'], ['cate', '需求类别'], ['content', '内容'], ['filled_by', '填表人'], ['mobile', '联系电话'], ['status_text', '状态'], ['create_time', '填表时间'], ]; export_exl("诉求管理", $xlsCell, $list); } /** * 政策 */ public function policy() { return view('', [ 'status_list' => PolicyModel::STATUS, 'type_list' => PolicyModel::TYPE, ]); } public function listPolicy() { $map = $this->dealEqualInput(['status', 'type']); $list = PolicyModel::where($map) ->order(['status' => 'desc']) ->limit(input('limit')) ->page(input('page')) ->append(['status_text','type_text']) ->select(); $count = PolicyModel::where($map)->count(); if ($count == 0) { ajax_return(1, '未查询到数据'); } list_return($list, $count); } public function delPolicy() { $id_arr = input('id_arr/a'); PolicyModel::destroy($id_arr); ajax_return(); } /** * 编辑 */ public function policyForm() { $id = input('id/d, 0'); $info = PolicyModel::find($id); return view('', [ 'info' => $info, 'status_list' => PolicyModel::STATUS, 'type_list' => PolicyModel::TYPE, ]); } public function editPolicy() { $data = input('post.'); try { validate(PolicyValidate::class)->check($data); } catch (ValidateException $e) { ajax_return(1, $e->getError()); } if (empty($data['id'])) { PolicyModel::create($data); } else { PolicyModel::update($data, ['id' => $data['id']]); } ajax_return(); } }