// +---------------------------------------------------------------------- namespace app\admin\controller\setting; use app\admin\model\special\Grade; use app\admin\model\special\RecommendBanner; use app\admin\model\special\Special; use app\admin\model\system\Recommend; use app\admin\model\system\RecommendRelation; use app\admin\model\user\Group; use service\FormBuilder as Form; use service\JsonService as Json; use service\UploadService as Upload; use think\Request; use think\Url; use app\admin\model\system\SystemGroup as GroupModel; use app\admin\model\system\SystemGroupData as GroupDataModel; use app\admin\controller\AuthController; use app\admin\model\system\SystemAttachment; /** * 数据列表控制器 在组合数据中 * Class SystemGroupData * @package app\admin\controller\system */ class SystemGroupData extends AuthController { /** * 显示资源列表 * @return \think\Response */ public function index($gid) { $where = parent::getMore([ ['status', ''] ], $this->request); $this->assign('where', $where); $this->assign(compact("gid")); $this->assign(GroupModel::getField($gid)); $where['gid'] = $gid; $this->assign(GroupDataModel::getList($where)); return $this->fetch(); } /** * 显示创建资源表单页. * @return \think\Response */ public function create($gid) { $Fields = GroupModel::getField($gid); $f = array(); foreach ($Fields["fields"] as $key => $value) { $info = []; if (!empty($value["param"])) { $value["param"] = str_replace("\r\n", "\n", $value["param"]);//防止不兼容 $params = explode("\n", $value["param"]); if (is_array($params) && !empty($params)) { foreach ($params as $index => $v) { if (strstr($v, '=>') !== false) { list($left, $right) = explode('=>', $v); } else if (strstr($v, '=') !== false) { list($left, $right) = explode('=', $v); } $val["value"] = $left; $val["label"] = $right; $info[] = $val; } } } switch ($value["type"]) { case 'input': $f[] = Form::input($value["title"], $value["name"]); break; case 'textarea': $f[] = Form::input($value["title"], $value["name"])->type('textarea')->placeholder($value['param']); break; case 'radio': $f[] = Form::radio($value["title"], $value["name"], isset($info[0]["value"]) ? $info[0]["value"] : '')->options($info); break; case 'checkbox': $f[] = Form::checkbox($value["title"], $value["name"], isset($info[0]) ? $info[0] : '')->options($info); break; case 'select': $f[] = Form::select($value["title"], $value["name"], isset($info[0]) ? $info[0] : '')->options($info)->multiple(false); break; case 'upload': $f[] = Form::frameImageOne($value["title"], $value["name"], Url::build('admin/widget.images/index', array('fodder' => $value["title"])))->icon('image')->width('100%')->height('500px'); break; case 'uploads': $f[] = Form::frameImages($value["title"], $value["name"], Url::build('admin/widget.images/index', array('fodder' => $value["title"])))->maxLength(5)->icon('images')->width('100%')->height('500px')->spin(0); break; default: $f[] = Form::input($value["title"], $value["name"]); break; } } $f[] = Form::number('sort', '排序', 1); $f[] = Form::radio('status', '状态', 1)->options([['value' => 1, 'label' => '显示'], ['value' => 2, 'label' => '隐藏']]); $form = Form::make_post_form('添加数据', $f, Url::build('save', compact('gid')), 2); $this->assign(compact('form')); return $this->fetch('public/form-builder'); } /** * 保存新建的资源 * * @param \think\Request $request * @return \think\Response */ public function save(Request $request, $gid) { $Fields = GroupModel::getField($gid); $params = $request->post(); $value = array(); foreach ($params as $key => $param) { foreach ($Fields['fields'] as $index => $field) { if ($key == $field["title"]) { if($param == "") return Json::fail($field["name"]."不能为空!"); else { $value[$key]["type"] = $field["type"]; $value[$key]["value"] = $param; } } } } $data = array("gid" => $gid, "add_time" => time(), "value" => json_encode($value), "sort" => $params["sort"], "status" => $params["status"]); GroupDataModel::set($data); return Json::successful('添加数据成功!'); } /** * 显示指定的资源 * * @param int $id * @return \think\Response */ public function read($id) { } /** * 显示编辑资源表单页. * * @param int $id * @return \think\Response */ public function edit($gid, $id) { $GroupData = GroupDataModel::get($id); $GroupDataValue = json_decode($GroupData["value"], true); $Fields = GroupModel::getField($gid); $f = array(); foreach ($Fields['fields'] as $key => $value) { $info = []; if (!empty($value["param"])) { $value["param"] = str_replace("\r\n", "\n", $value["param"]);//防止不兼容 $params = explode("\n", $value["param"]); if (is_array($params) && !empty($params)) { foreach ($params as $index => $v) { if (strstr($v, '=>') !== false) { list($left, $right) = explode('=>', $v); } else if (strstr($v, '=') !== false) { list($left, $right) = explode('=', $v); } $val["value"] = $left; $val["label"] = $right; $info[] = $val; } } } switch ($value['type']) { case 'input': $f[] = Form::input($value['title'], $value['name'], $GroupDataValue[$value['title']]['value']); break; case 'textarea': $f[] = Form::input($value['title'], $value['name'], $GroupDataValue[$value['title']]['value'])->type('textarea'); break; case 'radio': $f[] = Form::radio($value['title'], $value['name'], $GroupDataValue[$value['title']]['value'])->options($info); break; case 'checkbox': if(array_key_exists($value['title'],$GroupDataValue)){ $f[] = Form::checkbox($value['title'], $value['name'], $GroupDataValue[$value['title']]['value'])->options($info); }else{ $f[] = Form::checkbox($value["title"], $value["name"], isset($info[0]) ? $info[0] : '')->options($info); } break; case 'upload': if (!empty($GroupDataValue[$value['title']]['value'])) { $image = is_string($GroupDataValue[$value['title']]['value']) ? $GroupDataValue[$value['title']]['value'] : $GroupDataValue[$value['title']]['value'][0]; } else { $image = ''; } $f[] = Form::frameImageOne($value['title'], $value['name'], Url::build('admin/widget.images/index', array('fodder' => $value['title'])), $image)->icon('image')->width('100%')->height('500px'); break; case 'uploads': $images = !empty($GroupDataValue[$value['title']]['value']) ? $GroupDataValue[$value['title']]['value'] : []; $f[] = Form::frameImages($value['title'], $value['name'], Url::build('admin/widget.images/index', array('fodder' => $value['title'])), $images)->maxLength(5)->icon('images')->width('100%')->height('550px')->spin(0); break; case 'select': $f[] = Form::select($value['title'], $value['name'], $GroupDataValue[$value['title']]['value'])->setOptions($info); break; default: $f[] = Form::input($value['title'], $value['name'], $GroupDataValue[$value['title']]['value']); break; } } $f[] = Form::input('sort', '排序', $GroupData["sort"]); $f[] = Form::radio('status', '状态', $GroupData["status"])->options([['value' => 1, 'label' => '显示'], ['value' => 2, 'label' => '隐藏']]); $form = Form::make_post_form('编辑', $f, Url::build('update', compact('id')), 2); $this->assign(compact('form')); return $this->fetch('public/form-builder'); } /** * 保存更新的资源 * * @param \think\Request $request * @param int $id * @return \think\Response */ public function update(Request $request, $id) { $GroupData = GroupDataModel::get($id); $Fields = GroupModel::getField($GroupData["gid"]); $params = $request->post(); foreach ($params as $key => $param) { foreach ($Fields['fields'] as $index => $field) { if ($key == $field["title"]) { if ($param == "" || !$param || empty($param)) return Json::fail($field["name"] . "不能为空!"); else { $value[$key]["type"] = $field["type"]; $value[$key]["value"] = $param; } } } } $data = array("value" => json_encode($value), "sort" => $params["sort"], "status" => $params["status"]); GroupDataModel::edit($data, $id); return Json::successful('修改成功!'); } /** * 删除指定资源 * * @param int $id * @return \think\Response */ public function delete($id) { if (!GroupDataModel::del($id)) return Json::fail(GroupDataModel::getErrorInfo('删除失败,请稍候再试!')); else return Json::successful('删除成功!'); } public function upload() { $res = Upload::image('file', 'common'); $thumbPath = Upload::thumb($res->dir); //产品图片上传记录 $fileInfo = $res->fileInfo->getinfo(); SystemAttachment::attachmentAdd($res->fileInfo->getSaveName(), $fileInfo['size'], $fileInfo['type'], $res->dir, $thumbPath, 6); if ($res->status == 200) return Json::successful('图片上传成功!', ['name' => $res->fileInfo->getSaveName(), 'url' => Upload::pathToUrl($thumbPath)]); else return Json::fail($res->error); } public function recommend() { $this->assign('fixedList', Recommend::fixedList()); return $this->fetch(); } public function recommend_list() { $where = parent::getMore([ ['page', 1], ['limit', 20], ['order', ''], ['is_fixed', $this->request->param('is_fixed', 0)] ]); return Json::successlayui(Recommend::getRecommendList($where)); } public function create_recemmend($id = 0) { if ($id) $this->assign('recemmend', Recommend::get($id)); $this->assign('is_fixed', 1); $this->assign('grade_list', Grade::getAll()); $this->assign('id', $id); return $this->fetch(); } public function create_recemmend_v1($id = 0) { if ($id) $this->assign('recemmend', Recommend::get($id)); $this->assign('is_fixed', 0); $this->assign('grade_list', Grade::getAll()); $this->assign('is_fixed', 0); $this->assign('id', $id); return $this->fetch(); } public function save_recemmend($id = 0) { $post = parent::postMore([ ['icon', ''], ['image', ''], ['title', ''], ['type', ''], ['sort', 0], ['is_fixed', 0], ['is_show', 0], ['grade_id', 0], ['show_count', 0], ['typesetting', ''], ]); if ($id) { $post['is_show'] = $post['is_fixed'] ? 1 : $post['is_show']; $rescomm = Recommend::get($id); if (!$rescomm) return Json::fail('修改的信息不存在'); if($post['typesetting']==5){ unset($post['type'],$post['icon'],$post['image'],$post['is_fixed'],$post['is_show'],$post['grade_id'],$post['show_count']); } Recommend::update($post, ['id' => $id]); return Json::successful('修改成功'); } else { $post['add_time'] = time(); if (Recommend::set($post)) return Json::successful('保存成功'); else return Json::fail('保存失败'); } } public function recemmend_content($id = 0) { if (!$id) return Json::fail('缺少参数'); if ($this->request->isAjax()) { $where = parent::getMore([ ['page', 1], ['limit', 20], ]); return Json::successlayui(RecommendRelation::getAll($where, $id)); } else { $this->assign('id', $id); return $this->fetch(); } } public function recemmed_delete($id = 0) { if (!$id) return Json::fail('缺少参数'); if (RecommendRelation::del($id)) return Json::successful('删除成功'); else return Json::fail('删除失败'); } /** * 设置单个产品上架|下架 * * @return json */ public function set_show($is_show = '', $id = '') { ($is_show == '' || $id == '') && Json::fail('缺少参数'); $res = Recommend::where(['id' => $id])->update(['is_show' => (int)$is_show]); if ($res) { return Json::successful($is_show == 1 ? '显示成功' : '隐藏成功'); } else { return Json::fail($is_show == 1 ? '显示失败' : '隐藏失败'); } } public function set_show_banner($is_show = '', $id = '') { ($is_show == '' || $id == '') && Json::fail('缺少参数'); $res = RecommendBanner::where(['id' => $id])->update(['is_show' => (int)$is_show]); if ($res) { return Json::successful($is_show == 1 ? '显示成功' : '隐藏成功'); } else { return Json::fail($is_show == 1 ? '显示失败' : '隐藏失败'); } } /** * 快速编辑 * * @return json */ public function set_value($field = '', $id = '', $value = '') { $field == '' || $id == '' || $value == '' && Json::fail('缺少参数'); if (Recommend::where(['id' => $id])->update([$field => $value])) return Json::successful('保存成功'); else return Json::fail('保存失败'); } /** * 快速编辑 * * @return json */ public function set_recemmend_value($field = '', $id = '', $value = '') { $field == '' || $id == '' || $value == '' && Json::fail('缺少参数'); if(bcsub($value,0,0)<0) Json::fail('不能为负数'); if (RecommendRelation::where(['id' => $id])->update([$field => $value])) return Json::successful('保存成功'); else return Json::fail('保存失败'); } public function set_value_banner($field = '', $id = '', $value = '') { $field == '' || $id == '' || $value == '' && Json::fail('缺少参数'); if (RecommendBanner::where(['id' => $id])->update([$field => $value])) return Json::successful('保存成功'); else return Json::fail('保存失败'); } /** * 删除指定资源 * * @param int $id * @return \think\Response */ public function delete_recomm($id) { if (RecommendBanner::be(['recommend_id' => $id])) return Json::fail('删除失败,请先删除Banner图'); if (RecommendRelation::be(['recommend_id' => $id])) return Json::fail('删除失败,请先删除内容管理里面的列表'); if (!Recommend::del($id)) return Json::fail('删除失败'); else return Json::successful('删除成功!'); } /** * 删除导航推荐 * @param string $id */ public function delete_banner($id = '') { if (!RecommendBanner::del($id)) return Json::fail('删除失败'); else return Json::successful('删除成功!'); } public function recemmend_banner($id = '') { if ($id == '') return $this->failed('缺少参数'); $this->assign('id', $id); $this->assign('type', 1); return $this->fetch(); } public function recemmend_banner_list() { $where = parent::getMore([ ['id', ''], ['page', ''], ['limit', ''], ]); if ($where['id'] == '') return Json::fail('缺少参数'); return Json::successlayui(RecommendBanner::getRecemmodBannerList($where)); } /* * 创建banner图 * */ public function create_recemmend_banner($id = '', $banner_id = 0) { $this->assign('id', $id); if ($banner_id) { $banner = RecommendBanner::get($banner_id); if (!$banner) return $this->failed('缺少修改的banner'); $banner['pic_key'] = get_key_attr($banner['pic'], false); $this->assign('banner', $banner); } $this->assign('banner_id', (int)$banner_id); $this->assign('type', 2); return $this->fetch(); } public function save_recemmend_banner($id = '', $banner_id = '') { $post = parent::postMore([ ['url', ''], ['sort', ''], ['is_show', 0], ['pic', ''], ]); if ($id == '') return Json::fail('缺少参数'); if ($post['pic'] == '') return Json::fail('请上传封面图!'); if ($post['is_show'] == 'on') $post['is_show'] = 1; else $post['is_show'] = 0; $post['recommend_id'] = $id; if ($banner_id) { RecommendBanner::edit($post, $banner_id); return Json::successful('修改成功'); } else { $post['add_time'] = time(); RecommendBanner::set($post); return Json::successful('保存成功'); } } /** * 首页导航固定跳转添加 * @return mixed */ public function navigation() { return $this->fetch(); } /** * 自定义跳转导航添加和修改页面 * @param int $id * @return mixed|void * @throws \FormBuilder\exception\FormBuilderException * @throws \think\exception\DbException */ public function create_recemmend_custom($id = 0) { if ($id) { $recommend = Recommend::get($id); if (!$recommend) { return $this->failed('您修改的导航不存在'); } } $f[] = Form::input('title', '导航名称', isset($recommend) ? $recommend->title : ''); $f[] = Form::frameImageOne('icon', '图标(100*100px)', get_image_Url('icon'), isset($recommend) ? $recommend->icon : '')->icon('image')->width('100%')->height('500px'); $f[] = Form::input('link', '跳转路径', isset($recommend) ? $recommend->link : ''); $f[] = Form::input('sort', '排序', isset($recommend) ? $recommend->sort : 0); $f[] = Form::radio('is_show', '状态', isset($recommend) ? $recommend->is_show : 0)->options([['value' => 1, 'label' => '显示'], ['value' => 0, 'label' => '隐藏']]); $form = Form::make_post_form('编辑', $f, Url::build('save_recemmend_custom', compact('id')), 2); $this->assign(compact('form')); return $this->fetch('public/form-builder'); } /** * 保存自定义导航链接 * @param int $id */ public function save_recemmend_custom($id = 0) { $data = parent::postMore([ ['title', ''], ['icon', ''], ['link', ''], ['sort', 0], ['is_show', 0], ['type', 3], ['is_fixed', 1], ]); if (!$data['title']) { return Json::fail('请填写导航名称'); } if (!$data['icon']) { return Json::fail('请选择导航图标'); } if (!$data['link']) { return Json::fail('请填写导航跳转地址'); } if ($id) { Recommend::where('id', $id)->update($data); return Json::successful('修改成功'); } else { $data['add_time'] = time(); $res = Recommend::set($data); if ($res) { return Json::successful('添加成功'); } else { return Json::fail('修改失败'); } } } /** * 显示资源列表 * @return \think\Response */ public function index_v1($gid) { $this->assign(compact("gid")); return $this->fetch(); } /** * 获取某个组合数据列表 * @param int $gid * @param int $page * @param int $limit * @throws \think\Exception */ public function get_group_data_list($gid = 0, $status = '', $page = 1, $limit = 10) { $model = GroupDataModel::where(function ($query) use ($gid, $status) { $query->where('gid', $gid); if ($status != '') { $query->where('status', $status); } }); $data = $model->order('sort desc,id desc')->page($page, $limit)->select(); $data = count($data) ? $data->toArray() : []; foreach ($data as &$item) { $value = json_decode($item['value'], true); foreach ($value as $key => $val) { $item[$key] = $value[$key]['value']; } } $count = $model->count(); return Json::successlayui(compact('data', 'count')); } /** * 修改某个字段 * @param string $field * @param int $id * @param string $value */ public function set_group_data($field = '', $id = 0, $value = '') { if ('id' == $field) { return Json::fail('修改失败,主键不允许修改'); } if (!$field && !$value) { return Json::fail('缺少修改参数'); } $info = GroupDataModel::where('id', $id)->find(); if (!$info) { return Json::fail('修改的信息不存在'); } if (in_array($field, ['sort', 'status'])) { $info->{$field} = $value; $res = $info->save(); } else { $infoVale = json_decode($info->value, true); $infoVale[$field]['value'] = $value; $info->value = json_encode($infoVale); $res = $info->save(); } if ($res) { return Json::successful('修改成功'); } else { return Json::fail('修改失败'); } } /** * 添加组合数据页面 * @return mixed */ public function create_v1($id = 0) { $this->assign([ 'specialList' => json_encode(Special::PreWhere()->field(['id', 'title'])->order('sort desc,id desc')->select()), 'cateList' => json_encode(Grade::where(['is_del' => 0,'is_show'=>1])->field(['id', 'name as title'])->order('sort desc,id desc')->select()), ]); if ($id) { $info = GroupDataModel::get($id); if ($info) { $infoValue = json_decode($info->value, true); $this->assign('data', [ 'title' => isset($infoValue['title']['value']) ? $infoValue['title']['value'] : "", 'pic' => isset($infoValue['pic']['value']) ? $infoValue['pic']['value'] : "", 'info' => isset($infoValue['info']['value']) ? $infoValue['info']['value'] : '', 'sort' => $info->sort, 'status' => $info->status, 'type' => isset($infoValue['type']['value']) ? $infoValue['type']['value'] : "''", 'select_id' => isset($infoValue['select_id']['value']) ? $infoValue['select_id']['value'] : "''", 'id' => $id ]); } } return $this->fetch(); } public function save_group_data($name = '') { $data = parent::postMore([ ['title', ''], ['id', ''], ['image', ''], ['info', ''], ['type', 0], ['select_id', 0], ['sort', 0], ['status', 0], ]); $gid = GroupModel::where(['config_name' => $name])->value('id'); if (!isset($data['id']) || !$data['id']) { if (GroupDataModel::where('gid', $gid)->count() >= 3) { return Json::fail('最多能添加3条信息'); } } if (!$data['title']) { return Json::fail('请输入标题'); } if (!$data['image']) { return Json::fail('请选择图片'); } if (!$data['info']) { return Json::fail('请输入简介'); } if (!$data['select_id']) { return Json::fail('请选择' . ($data['type'] ? '分类' : "专题")); } $info = '{"pic":{"type":"upload","value":""},"title":{"type":"input","value":""},"info":{"type":"input","value":""},"wap_link":{"type":"select","value":""}}'; $info = json_decode($info, true); $info['pic']['value'] = $data['image']; $info['title']['value'] = $data['title']; $info['info']['value'] = $data['info']; $info['select_id']['value'] = $data['select_id']; $info['select_id']['type'] = 'select'; $info['type']['type'] = 'radio'; $info['type']['value'] = $data['type']; if ($data['type']) { $info['wap_link']['value'] = '/wap/special/special_cate?cate_id=' . $data['select_id']; } else { $info['wap_link']['value'] = '/wap/special/details?id=' . $data['select_id']; } if (isset($data['id']) && $data['id']) { $res = GroupDataModel::update([ 'gid' => $gid, 'value' => json_encode($info), 'sort' => $data['sort'], 'status' => $data['status'], ],['id' => $data['id']]); }else{ $res = GroupDataModel::set([ 'gid' => $gid, 'value' => json_encode($info), 'add_time' => time(), 'sort' => $data['sort'], 'status' => $data['status'], ]); } if ($res) { return Json::successful('编辑成功'); } else { return Json::fail('编辑失败'); } } }