123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524 |
- <?php
- /**
- * 易优CMS
- * ============================================================================
- * 版权所有 2016-2028 海南赞赞网络科技有限公司,并保留所有权利。
- * 网站地址: http://www.eyoucms.com
- * ----------------------------------------------------------------------------
- * 如果商业用途务必到官方购买正版授权, 以免引起不必要的法律纠纷.
- * ============================================================================
- * Author: 小虎哥 <1105415366@qq.com>
- * Date: 2018-4-3
- */
- namespace app\admin\controller;
- use think\Page;
- use think\Db;
- use app\admin\logic\FieldLogic;
- /**
- * 模型字段控制器
- */
- class Field extends Base
- {
- public $fieldLogic;
- public $arctype_channel_id;
- public function _initialize()
- {
- parent::_initialize();
- $this->language_access(); // 多语言功能操作权限
- $this->fieldLogic = new FieldLogic();
- $this->arctype_channel_id = config('global.arctype_channel_id');
- $userConfig = getUsersConfigData('users');
- $this->assign('userConfig', $userConfig);
- }
- /**
- * 模型字段管理
- */
- public function channel_index()
- {
- /*同步栏目绑定的自定义字段*/
- $this->syn_channelfield_bind();
- /*--end*/
- $channel_id = input('param.channel_id/d', 1);
- $assign_data = array();
- $condition = array();
- // 获取到所有GET参数
- $param = input('param.');
- /*同步更新附加表字段到自定义模型字段表中*/
- if (empty($param['searchopt'])) {
- $this->fieldLogic->synChannelTableColumns($channel_id);
- }
- /*--end*/
- // 应用搜索条件
- foreach (['keywords'] as $key) {
- if (isset($param[$key]) && $param[$key] !== '') {
- if ($key == 'keywords') {
- $condition['a.name|a.title'] = array('LIKE', "%{$param[$key]}%");
- // 过滤指定字段
- // $banFields = ['id'];
- // $condition['a.name'] = array(
- // array('LIKE', "%{$param[$key]}%"),
- // array('notin', $banFields),
- // );
- } else {
- $condition['a.' . $key] = array('eq', $param[$key]);
- }
- }
- }
- /*显示主表与附加表*/
- $condition['a.channel_id'] = array('IN', [$channel_id]);
- /*模型列表*/
- $channeltype_list = model('Channeltype')->getAll('*', [], 'id');
- $assign_data['channeltype_list'] = $channeltype_list;
- /*--end*/
- $condition['a.ifcontrol'] = 0;
- $cfieldM = M('channelfield');
- $count = $cfieldM->alias('a')->where($condition)->count('a.id');// 查询满足要求的总记录数
- $Page = $pager = new Page($count, config('paginate.list_rows'));// 实例化分页类 传入总记录数和每页显示的记录数
- $list = $cfieldM->field('a.*')
- ->alias('a')
- ->where($condition)
- ->order('a.sort_order asc, a.ifmain asc, a.ifcontrol asc, a.id desc')
- ->limit($Page->firstRow . ',' . $Page->listRows)
- ->select();
- $show = $Page->show();// 分页显示输出
- $assign_data['page'] = $show; // 赋值分页输出
- $assign_data['list'] = $list; // 赋值数据集
- $assign_data['pager'] = $Page; // 赋值分页对象
- /*字段类型列表*/
- $assign_data['fieldtypeList'] = M('field_type')->field('name,title')->getAllWithIndex('name');
- /*--end*/
- /*模型ID*/
- $assign_data['channel_id'] = $channel_id;
- /*--end*/
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 同步栏目绑定的自定义字段
- */
- private function syn_channelfield_bind()
- {
- $field_ids = Db::name('channelfield')->where([
- 'ifmain' => 0,
- 'channel_id' => ['NEQ', -99],
- ])->column('id');
- if (!empty($field_ids)) {
- $totalRow = Db::name('channelfield_bind')->count();
- if (empty($totalRow)) {
- $sveData = [];
- foreach ($field_ids as $key => $val) {
- $sveData[] = [
- 'typeid' => 0,
- 'field_id' => $val,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- ];
- }
- model('ChannelfieldBind')->saveAll($sveData);
- }
- }
- }
- /**
- * 新增-模型字段
- */
- public function channel_add()
- {
- $channel_id = input('param.channel_id/d', 0);
- if (empty($channel_id)) {
- $this->error('参数有误!');
- }
- if (IS_POST) {
- $post = input('post.', '', 'trim');
- // 判断是否存在|杠
- $IsData = strstr($post['dfvalue'], '|');
- if (!empty($IsData)) {
- $this->error("不可输入 | 杠");
- }
- if (empty($post['dtype']) || empty($post['title']) || empty($post['name'])) {
- $this->error("缺少必填信息!");
- }
- if (1 == preg_match('/^([_]+|[0-9]+)$/', $post['name'])) {
- $this->error("字段名称格式不正确!");
- } else if (preg_match('/^type/', $post['name'])) {
- $this->error("字段名称不允许以type开头!");
- } else if (preg_match('/^ey_/', $post['name'])) {
- $this->error("字段名称不允许以 ey_ 开头!");
- }
- // 字段类型是否具备筛选功能
- if (empty($post['IsScreening_status'])) {
- $post['is_screening'] = 0;
- }
- /*去除中文逗号,过滤左右空格与空值、以及单双引号*/
- $dfvalue = str_replace(',', ',', $post['dfvalue']);
- $dfvalue = func_preg_replace(['"', '\'', ';'], '', $dfvalue);
- $dfvalueArr = explode(',', $dfvalue);
- foreach ($dfvalueArr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($dfvalueArr[$key]);
- continue;
- }
- $dfvalueArr[$key] = $tmp_val;
- }
- $dfvalueArr = array_unique($dfvalueArr);
- $dfvalue = implode(',', $dfvalueArr);
- /*--end*/
- if ('region' == $post['dtype']) {
- if (!empty($post['region_data'])) {
- $post['dfvalue'] = $post['region_data']['region_id'];
- $post['region_data'] = serialize($post['region_data']);
- } else {
- $this->error("请选择区域范围!");
- }
- } else {
- /*默认值必填字段*/
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title,ifoption', 'name');
- if (isset($fieldtype_list[$post['dtype']]) && 1 == $fieldtype_list[$post['dtype']]['ifoption']) {
- if (empty($dfvalue)) {
- $this->error("你设定了字段为【" . $fieldtype_list[$post['dtype']]['title'] . "】类型,默认值不能为空! ");
- }
- }
- /*--end*/
- unset($post['region_data']);
- }
- /*当前模型对应的数据表*/
- $table = M('channeltype')->where('id', $channel_id)->getField('table');
- $table = PREFIX . $table . '_content';
- /*--end*/
- /*检测字段是否存在于主表与附加表中*/
- if (true == $this->fieldLogic->checkChannelFieldList($table, $post['name'], $channel_id)) {
- $this->error("字段名称 " . $post['name'] . " 与系统字段冲突!");
- }
- /*--end*/
- if (empty($post['typeids'])) {
- $this->error('请选择可见栏目!');
- }
- /*组装完整的SQL语句,并执行新增字段*/
- $fieldinfos = $this->fieldLogic->GetFieldMake($post['dtype'], $post['name'], $dfvalue, $post['title']);
- $ntabsql = $fieldinfos[0];
- $buideType = $fieldinfos[1];
- $maxlength = $fieldinfos[2];
- $sql = " ALTER TABLE `$table` ADD $ntabsql ";
- if (false !== Db::execute($sql)) {
- if (!empty($post['region_data'])) {
- $dfvalue = $post['region_data'];
- unset($post['region_data']);
- }
- /*保存新增字段的记录*/
- $newData = array(
- 'dfvalue' => $dfvalue,
- 'maxlength' => $maxlength,
- 'define' => $buideType,
- 'ifcontrol' => 0,
- 'sort_order' => 100,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- );
- $data = array_merge($post, $newData);
- M('channelfield')->save($data);
- $field_id = M('channelfield')->getLastInsID();
- /*--end*/
- /*保存栏目与字段绑定的记录*/
- $typeids = $post['typeids'];
- if (!empty($typeids)) {
- /*多语言*/
- if (is_language()) {
- $attr_name_arr = [];
- foreach ($typeids as $key => $val) {
- $attr_name_arr[] = 'tid' . $val;
- }
- $new_typeid_arr = Db::name('language_attr')->where([
- 'attr_name' => ['IN', $attr_name_arr],
- 'attr_group' => 'arctype',
- ])->column('attr_value');
- !empty($new_typeid_arr) && $typeids = $new_typeid_arr;
- }
- /*--end*/
- $addData = [];
- foreach ($typeids as $key => $val) {
- if (1 < count($typeids) && empty($val)) {
- continue;
- }
- $addData[] = [
- 'typeid' => $val,
- 'field_id' => $field_id,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- ];
- }
- !empty($addData) && model('ChannelfieldBind')->saveAll($addData);
- }
- /*--end*/
- /*重新生成数据表字段缓存文件*/
- try {
- schemaTable($table);
- } catch (\Exception $e) {}
- /*--end*/
- \think\Cache::clear('channelfield');
- $this->success("操作成功!", url('Field/channel_index', array('channel_id' => $channel_id)));
- }
- $this->error('操作失败');
- }
- /*字段类型列表*/
- $assign_data['fieldtype_list'] = model('Field')->getFieldTypeAll('name,title,ifoption');
- /*--end*/
- /*允许发布文档列表的栏目*/
- $select_html = allow_release_arctype(0, [$channel_id]);
- $this->assign('select_html', $select_html);
- /*--end*/
- /*模型ID*/
- $assign_data['channel_id'] = $channel_id;
- /*--end*/
- $China[] = [
- 'id' => 0,
- 'name' => '全国',
- ];
- $Province = get_province_list();
- $assign_data['Province'] = array_merge($China, $Province);
- $this->assign($assign_data);
- return $this->fetch();
- }
- // 联动地址获取
- public function get_region_data()
- {
- $parent_id = input('param.parent_id/d');
- // 获取指定区域ID下的城市并判断是否需要处理特殊市返回值
- $RegionData = $this->SpecialCityDealWith($parent_id);
- // 处理数据
- $region_html = $region_names = $region_ids = '';
- if ($RegionData) {
- // 拼装下拉选项
- foreach ($RegionData as $key => $value) {
- $region_html .= "<option value='{$value['id']}'>{$value['name']}</option>";
- if ($key > '0') {
- $region_names .= ',';
- $region_ids .= ',';
- }
- $region_names .= $value['name'];
- $region_ids .= $value['id'];
- }
- }
- $return = [
- 'region_html' => $region_html,
- 'region_names' => $region_names,
- 'region_ids' => $region_ids,
- 'parent_array' => config('global.field_region_all_type'),
- ];
- echo json_encode($return);
- }
- // 获取指定区域ID下的城市并判断是否需要处理特殊市返回值
- // 特殊市:北京市,上海市,天津市,重庆市
- function SpecialCityDealWith($parent_id = 0)
- {
- empty($parent_id) && $parent_id = 0;
- /*parent_id在特殊范围内则执行*/
- // 处理北京市,上海市,天津市,重庆市逻辑
- $RegionData = Db::name('region')->where("parent_id", $parent_id)->select();
- $parent_array = config('global.field_region_type');
- if (in_array($parent_id, $parent_array)) {
- $region_ids = get_arr_column($RegionData, 'id');
- $RegionData = Db::name('region')->where('parent_id', 'IN', $region_ids)->select();
- }
- /*结束*/
- return $RegionData;
- }
- /**
- * 编辑-模型字段
- */
- public function channel_edit()
- {
- $channel_id = input('param.channel_id/d', 0);
- if (empty($channel_id)) {
- $this->error('参数有误!');
- }
- if (IS_POST) {
- $post = input('post.', '', 'trim');
- if ('checkbox' == $post['old_dtype'] && in_array($post['dtype'], ['radio', 'select'])) {
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title', 'name');
- $this->error("{$fieldtype_list['checkbox']['title']}不能更改为{$fieldtype_list[$post['dtype']]['title']}!");
- }
- if (empty($post['dtype']) || empty($post['title']) || empty($post['name'])) {
- $this->error("缺少必填信息!");
- }
- if (1 == preg_match('/^([_]+|[0-9]+)$/', $post['name'])) {
- $this->error("字段名称格式不正确!");
- } else if (preg_match('/^type/', $post['name'])) {
- $this->error("字段名称不允许以type开头!");
- } else if (preg_match('/^ey_/', $post['name'])) {
- $this->error("字段名称不允许以 ey_ 开头!");
- }
- $info = model('Channelfield')->getInfo($post['id'], 'ifsystem');
- if (!empty($info['ifsystem'])) {
- $this->error('系统字段不允许更改!');
- }
- // 字段类型是否具备筛选功能
- if (empty($post['IsScreening_status'])) {
- $post['is_screening'] = 0;
- }
- $old_name = $post['old_name'];
- /*去除中文逗号,过滤左右空格与空值*/
- $dfvalue = str_replace(',', ',', $post['dfvalue']);
- $dfvalue = func_preg_replace(['"', '\'', ';'], '', $dfvalue);
- $dfvalueArr = explode(',', $dfvalue);
- foreach ($dfvalueArr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($dfvalueArr[$key]);
- continue;
- }
- $dfvalueArr[$key] = $tmp_val;
- }
- $dfvalueArr = array_unique($dfvalueArr);
- $dfvalue = implode(',', $dfvalueArr);
- /*--end*/
- if ('region' == $post['dtype']) {
- if (!empty($post['region_data'])) {
- $post['dfvalue'] = $post['region_data']['region_id'];
- $post['region_data'] = serialize($post['region_data']);
- } else {
- $this->error("请选择区域范围!");
- }
- } else {
- /*默认值必填字段*/
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title,ifoption', 'name');
- if (isset($fieldtype_list[$post['dtype']]) && 1 == $fieldtype_list[$post['dtype']]['ifoption']) {
- if (empty($dfvalue)) {
- $this->error("你设定了字段为【" . $fieldtype_list[$post['dtype']]['title'] . "】类型,默认值不能为空! ");
- }
- }
- /*--end*/
- unset($post['region_data']);
- }
- /*当前模型对应的数据表*/
- $table = M('channeltype')->where('id', $post['channel_id'])->getField('table');
- $tableName = $table . '_content';
- $table = PREFIX . $tableName;
- /*--end*/
- /*检测字段是否存在于主表与附加表中*/
- if (true == $this->fieldLogic->checkChannelFieldList($table, $post['name'], $channel_id, array($old_name))) {
- $this->error("字段名称 " . $post['name'] . " 与系统字段冲突!");
- }
- /*--end*/
- if (empty($post['typeids'])) {
- $this->error('请选择可见栏目!');
- }
- /*针对单选项、多选项、下拉框:修改之前,将该字段不存在的值都更新为默认值第一个*/
- if (in_array($post['old_dtype'], ['radio', 'select', 'checkbox']) && in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $whereArr = [];
- $dfvalueArr = explode(',', $dfvalue);
- foreach($dfvalueArr as $key => $val){
- $whereArr[] = "`{$post['name']}` <> '{$val}'";
- }
- $whereStr = implode(' OR ', $whereArr);
- if (in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $new_dfvalue = NULL;
- } else {
- $new_dfvalue = '';
- }
- Db::name($tableName)->where($whereStr)->update([$post['name']=>$new_dfvalue]);
- }
- /*end*/
- /*组装完整的SQL语句,并执行编辑字段*/
- $fieldinfos = $this->fieldLogic->GetFieldMake($post['dtype'], $post['name'], $dfvalue, $post['title']);
- $ntabsql = $fieldinfos[0];
- $buideType = $fieldinfos[1];
- $maxlength = $fieldinfos[2];
- $sql = " ALTER TABLE `$table` CHANGE COLUMN `{$old_name}` $ntabsql ";
- if (false !== Db::execute($sql)) {
- /*针对单选项、多选项、下拉框:修改之前,将该字段不存在的值都更新为默认值第一个*/
- if (in_array($post['old_dtype'], ['radio', 'select', 'checkbox']) && in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $whereArr = [];
- $new_dfvalue = '';
- $dfvalueArr = explode(',', $dfvalue);
- foreach($dfvalueArr as $key => $val){
- if ($key == 0) {
- $new_dfvalue = $val;
- }
- $whereArr[] = "`{$post['name']}` <> '{$val}'";
- }
- $whereArr[] = "`{$post['name']}` is NULL";
- $whereArr[] = "`{$post['name']}` = ''";
- $whereStr = implode(' OR ', $whereArr);
- Db::name($tableName)->where($whereStr)->update([$post['name']=>$new_dfvalue]);
- }
- /*end*/
- /*保存更新字段的记录*/
- if (!empty($post['region_data'])) {
- $dfvalue = $post['region_data'];
- unset($post['region_data']);
- }
- $newData = array(
- 'dfvalue' => $dfvalue,
- 'maxlength' => $maxlength,
- 'define' => $buideType,
- 'update_time' => getTime(),
- );
- $data = array_merge($post, $newData);
- M('channelfield')->where('id', $post['id'])->cache(true, null, "channelfield")->save($data);
- /*--end*/
- /*保存栏目与字段绑定的记录*/
- $field_id = $post['id'];
- model('ChannelfieldBind')->where(['field_id' => $field_id])->delete();
- $typeids = $post['typeids'];
- if (!empty($typeids)) {
- /*多语言*/
- if (is_language()) {
- $attr_name_arr = [];
- foreach ($typeids as $key => $val) {
- $attr_name_arr[] = 'tid' . $val;
- }
- $new_typeid_arr = Db::name('language_attr')->where([
- 'attr_name' => ['IN', $attr_name_arr],
- 'attr_group' => 'arctype',
- ])->column('attr_value');
- !empty($new_typeid_arr) && $typeids = $new_typeid_arr;
- }
- /*--end*/
- $addData = [];
- foreach ($typeids as $key => $val) {
- if (1 < count($typeids) && empty($val)) {
- continue;
- }
- $addData[] = [
- 'typeid' => $val,
- 'field_id' => $field_id,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- ];
- }
- !empty($addData) && model('ChannelfieldBind')->saveAll($addData);
- }
- /*--end*/
- /*重新生成数据表字段缓存文件*/
- try {
- schemaTable($table);
- } catch (\Exception $e) {}
- /*--end*/
- $this->success("操作成功!", url('Field/channel_index', array('channel_id' => $post['channel_id'])));
- } else {
- $sql = " ALTER TABLE `$table` ADD $ntabsql ";
- if (false === Db::execute($sql)) {
- $this->error('操作失败!');
- }
- }
- }
- $id = input('param.id/d', 0);
- $info = array();
- if (!empty($id)) {
- $info = model('Channelfield')->getInfo($id);
- }
- if (!empty($info['ifsystem'])) {
- $this->error('系统字段不允许更改!');
- }
- /*字段类型列表*/
- $assign_data['fieldtype_list'] = model('Field')->getFieldTypeAll('name,title,ifoption');
- /*--end*/
- /*允许发布文档列表的栏目*/
- $typeids = Db::name('channelfield_bind')->where(['field_id' => $id])->column('typeid');
- $select_html = allow_release_arctype($typeids, [$channel_id]);
- $this->assign('select_html', $select_html);
- $this->assign('typeids', $typeids);
- /*--end*/
- /*模型ID*/
- $assign_data['channel_id'] = $channel_id;
- /*--end*/
- /*区域字段处理*/
- // 初始化参数
- $assign_data['region'] = [
- 'parent_id' => '-1',
- 'region_id' => '-1',
- 'region_names' => '',
- 'region_ids' => '',
- ];
- // 定义全国参数
- $China[] = [
- 'id' => 0,
- 'name' => '全国',
- ];
- // 查询省份信息并且拼装上$China数组
- $Province = get_province_list();
- $assign_data['Province'] = array_merge($China, $Province);
- // 区域选择时,指定不出现下级地区列表
- $assign_data['parent_array'] = "[]";
- // 如果是区域类型则执行
- if ('region' == $info['dtype']) {
- // 反序列化默认值参数
- $dfvalue = unserialize($info['dfvalue']);
- if (0 == $dfvalue['region_id']) {
- $parent_id = $dfvalue['region_id'];
- } else {
- // 查询当前选中的区域父级ID
- $parent_id = Db::name('region')->where("id", $dfvalue['region_id'])->getField('parent_id');
- if (0 == $parent_id) {
- $parent_id = $dfvalue['region_id'];
- }
- }
- // 查询市\区\县信息
- $assign_data['City'] = Db::name('region')->where("parent_id", $parent_id)->select();
- // 加载数据到模板
- $assign_data['region'] = [
- 'parent_id' => $parent_id,
- 'region_id' => $dfvalue['region_id'],
- 'region_names' => $dfvalue['region_names'],
- 'region_ids' => $dfvalue['region_ids'],
- ];
- // 删除默认值,防止切换其他类型时使用到
- unset($info['dfvalue']);
- // 区域选择时,指定不出现下级地区列表
- $assign_data['parent_array'] = convert_js_array(config('global.field_region_all_type'));
- }
- /*区域字段处理结束*/
- $assign_data['info'] = $info;
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 删除-模型字段
- */
- public function channel_del()
- {
- $channel_id = input('channel_id/d', 0);
- $id = input('del_id/d', 0);
- if (!empty($id)) {
- /*删除表字段*/
- $row = $this->fieldLogic->delChannelField($id);
- /*--end*/
- if (0 < $row['code']) {
- $map = array(
- 'id' => array('eq', $id),
- 'channel_id' => $channel_id,
- );
- $result = M('channelfield')->field('channel_id,name')->where($map)->select();
- $name_list = get_arr_column($result, 'name');
- /*删除字段的记录*/
- M('channelfield')->where($map)->delete();
- /*--end*/
- /*删除栏目与字段绑定的记录*/
- model('ChannelfieldBind')->where(['field_id' => $id])->delete();
- /*--end*/
- /*获取模型标题*/
- $channel_title = '';
- if (!empty($channel_id)) {
- $channel_title = M('channeltype')->where('id', $channel_id)->getField('title');
- }
- /*--end*/
- adminLog('删除' . $channel_title . '字段:' . implode(',', $name_list));
- $this->success('删除成功');
- }
- \think\Cache::clear('channelfield');
- respose(array('status' => 0, 'msg' => $row['msg']));
- } else {
- $this->error('参数有误');
- }
- }
- /**
- * 栏目字段 - 删除多图字段的图集
- */
- public function del_arctypeimgs()
- {
- $typeid = input('typeid/d', '0');
- if (!empty($typeid)) {
- $path = input('filename', ''); // 图片路径
- $fieldname = input('fieldname/s', ''); // 多图字段
- /*除去多图字段值中的图片*/
- $info = M('arctype')->field("{$fieldname}")->where("id", $typeid)->find();
- $valueArr = explode(',', $info[$fieldname]);
- foreach ($valueArr as $key => $val) {
- if ($path == $val) {
- unset($valueArr[$key]);
- }
- }
- $value = implode(',', $valueArr);
- M('arctype')->where('id', $typeid)->update(array($fieldname => $value, 'update_time' => getTime()));
- /*--end*/
- }
- }
- /**
- * 模型字段 - 删除多图字段的图集
- */
- public function del_channelimgs()
- {
- $aid = input('aid/d', '0');
- $channel = input('channel/d', ''); // 模型ID
- if (!empty($aid) && !empty($channel)) {
- $path = input('filename', ''); // 图片路径
- $fieldname = input('fieldname/s', ''); // 多图字段
- /*模型附加表*/
- $table = M('channeltype')->where('id', $channel)->getField('table');
- $tableExt = $table . '_content';
- /*--end*/
- /*除去多图字段值中的图片*/
- $info = M($tableExt)->field("{$fieldname}")->where("aid", $aid)->find();
- $valueArr = explode(',', $info[$fieldname]);
- foreach ($valueArr as $key => $val) {
- if ($path == $val) {
- unset($valueArr[$key]);
- }
- }
- $value = implode(',', $valueArr);
- M($tableExt)->where('aid', $aid)->update(array($fieldname => $value, 'update_time' => getTime()));
- /*--end*/
- }
- }
- /**
- * 显示与隐藏
- */
- public function ajax_channel_show()
- {
- if (IS_POST) {
- $id = input('id/d');
- $ifeditable = input('ifeditable/d');
- if (!empty($id)) {
- $row = Db::name('channelfield')->where([
- 'id' => $id,
- ])->find();
- if (!empty($row) && 1 == intval($row['ifcontrol'])) {
- $this->error('系统内置表单,禁止操作!');
- }
- $r = Db::name('channelfield')->where([
- 'id' => $id,
- ])->update([
- 'ifeditable' => $ifeditable,
- 'update_time' => getTime(),
- ]);
- if ($r) {
- adminLog('操作自定义模型表单:' . $row['name']);
- $this->success('操作成功');
- } else {
- $this->error('操作失败');
- }
- } else {
- $this->error('参数有误');
- }
- }
- $this->error('非法访问');
- }
- /**
- * 栏目字段管理
- */
- public function arctype_index()
- {
- $channel_id = $this->arctype_channel_id;
- $assign_data = array();
- $condition = array();
- // 获取到所有GET参数
- $param = input('param.');
- /*同步更新栏目主表字段到自定义字段表中*/
- if (empty($param['searchopt'])) {
- $this->fieldLogic->synArctypeTableColumns($channel_id);
- }
- /*--end*/
- // 应用搜索条件
- foreach (['keywords'] as $key) {
- if (isset($param[$key]) && $param[$key] !== '') {
- if ($key == 'keywords') {
- $condition['name|title'] = array('LIKE', "%{$param[$key]}%");
- } else {
- $condition[$key] = array('eq', $param[$key]);
- }
- }
- }
- // 模型ID
- $condition['channel_id'] = array('eq', $channel_id);
- $condition['ifsystem'] = array('neq', 1);
- $cfieldM = M('channelfield');
- $count = $cfieldM->where($condition)->count('id');// 查询满足要求的总记录数
- $Page = $pager = new Page($count, config('paginate.list_rows'));// 实例化分页类 传入总记录数和每页显示的记录数
- $list = $cfieldM->where($condition)->order('sort_order asc, ifsystem asc, id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
- $show = $Page->show();// 分页显示输出
- $assign_data['page'] = $show; // 赋值分页输出
- $assign_data['list'] = $list; // 赋值数据集
- $assign_data['pager'] = $Page; // 赋值分页对象
- /*字段类型列表*/
- $assign_data['fieldtypeList'] = M('field_type')->field('name,title')->getAllWithIndex('name');
- /*--end*/
- $assign_data['channel_id'] = $channel_id;
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 新增-栏目字段
- */
- public function arctype_add()
- {
- $channel_id = $this->arctype_channel_id;
- if (empty($channel_id)) {
- $this->error('参数有误!');
- }
- if (IS_POST) {
- $post = input('post.', '', 'trim');
- if (empty($post['dtype']) || empty($post['title']) || empty($post['name'])) {
- $this->error("缺少必填信息!");
- }
- if (1 == preg_match('/^([_]+|[0-9]+)$/', $post['name'])) {
- $this->error("字段名称格式不正确!");
- } else if (preg_match('/^ey_/', $post['name'])) {
- $this->error("字段名称不允许以 ey_ 开头!");
- }
- /*去除中文逗号,过滤左右空格与空值*/
- $dfvalue = str_replace(',', ',', $post['dfvalue']);
- $dfvalue = func_preg_replace(['"', '\'', ';'], '', $dfvalue);
- $dfvalueArr = explode(',', $dfvalue);
- foreach ($dfvalueArr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($dfvalueArr[$key]);
- continue;
- }
- $dfvalueArr[$key] = $tmp_val;
- }
- $dfvalueArr = array_unique($dfvalueArr);
- $dfvalue = implode(',', $dfvalueArr);
- /*--end*/
- /*默认值必填字段*/
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title,ifoption', 'name');
- if (isset($fieldtype_list[$post['dtype']]) && 1 == $fieldtype_list[$post['dtype']]['ifoption']) {
- if (empty($dfvalue)) {
- $this->error("你设定了字段为【" . $fieldtype_list[$post['dtype']]['title'] . "】类型,默认值不能为空! ");
- }
- }
- /*--end*/
- /*栏目对应的单页表*/
- $tableExt = PREFIX . 'single_content';
- /*--end*/
- /*检测字段是否存在于主表与附加表中*/
- if (true == $this->fieldLogic->checkChannelFieldList($tableExt, $post['name'], 6)) {
- $this->error("字段名称 " . $post['name'] . " 与系统字段冲突!");
- }
- /*--end*/
- /*组装完整的SQL语句,并执行新增字段*/
- $fieldinfos = $this->fieldLogic->GetFieldMake($post['dtype'], $post['name'], $dfvalue, $post['title']);
- $ntabsql = $fieldinfos[0];
- $buideType = $fieldinfos[1];
- $maxlength = $fieldinfos[2];
- $table = PREFIX . 'arctype';
- $sql = " ALTER TABLE `$table` ADD $ntabsql ";
- if (false !== Db::execute($sql)) {
- /*保存新增字段的记录*/
- $newData = array(
- 'dfvalue' => $dfvalue,
- 'maxlength' => $maxlength,
- 'define' => $buideType,
- 'ifmain' => 1,
- 'ifsystem' => 0,
- 'sort_order' => 100,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- );
- $data = array_merge($post, $newData);
- M('channelfield')->save($data);
- /*--end*/
- /*重新生成数据表字段缓存文件*/
- try {
- schemaTable($table);
- } catch (\Exception $e) {}
- /*--end*/
- \think\Cache::clear('channelfield');
- \think\Cache::clear("arctype");
- $this->success("操作成功!", url('Field/arctype_index'));
- }
- $this->error('操作失败');
- }
- /*字段类型列表*/
- $fieldtype_list = [];
- $fieldtype_list_tmp = model('Field')->getFieldTypeAll('name,title,ifoption');
- foreach ($fieldtype_list_tmp as $key => $val) {
- if (!in_array($val['name'], ['file','media'])) {
- $fieldtype_list[] = $val;
- }
- }
- $assign_data['fieldtype_list'] = $fieldtype_list;
- /*--end*/
- /*模型ID*/
- $assign_data['channel_id'] = $channel_id;
- /*--end*/
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 编辑-栏目字段
- */
- public function arctype_edit()
- {
- $channel_id = $this->arctype_channel_id;
- if (empty($channel_id)) {
- $this->error('参数有误!');
- }
- if (IS_POST) {
- $post = input('post.', '', 'trim');
- if ('checkbox' == $post['old_dtype'] && in_array($post['dtype'], ['radio', 'select'])) {
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title', 'name');
- $this->error("{$fieldtype_list['checkbox']['title']}不能更改为{$fieldtype_list[$post['dtype']]['title']}!");
- }
- if (empty($post['dtype']) || empty($post['title']) || empty($post['name'])) {
- $this->error("缺少必填信息!");
- }
- if (1 == preg_match('/^([_]+|[0-9]+)$/', $post['name'])) {
- $this->error("字段名称格式不正确!");
- } else if (preg_match('/^ey_/', $post['name'])) {
- $this->error("字段名称不允许以 ey_ 开头!");
- }
- $info = model('Channelfield')->getInfo($post['id'], 'ifsystem');
- if (!empty($info['ifsystem'])) {
- $this->error('系统字段不允许更改!');
- }
- $old_name = $post['old_name'];
- /*去除中文逗号,过滤左右空格与空值*/
- $dfvalue = str_replace(',', ',', $post['dfvalue']);
- $dfvalue = func_preg_replace(['"', '\'', ';'], '', $dfvalue);
- $dfvalueArr = explode(',', $dfvalue);
- foreach ($dfvalueArr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($dfvalueArr[$key]);
- continue;
- }
- $dfvalueArr[$key] = $tmp_val;
- }
- $dfvalueArr = array_unique($dfvalueArr);
- $dfvalue = implode(',', $dfvalueArr);
- /*--end*/
- /*默认值必填字段*/
- $fieldtype_list = model('Field')->getFieldTypeAll('name,title,ifoption', 'name');
- if (isset($fieldtype_list[$post['dtype']]) && 1 == $fieldtype_list[$post['dtype']]['ifoption']) {
- if (empty($dfvalue)) {
- $this->error("你设定了字段为【" . $fieldtype_list[$post['dtype']]['title'] . "】类型,默认值不能为空! ");
- }
- }
- /*--end*/
- /*栏目对应的单页表*/
- $tableExt = PREFIX . 'single_content';
- /*--end*/
- /*检测字段是否存在于主表与附加表中*/
- if (true == $this->fieldLogic->checkChannelFieldList($tableExt, $post['name'], 6, array($old_name))) {
- $this->error("字段名称 " . $post['name'] . " 与系统字段冲突!");
- }
- /*--end*/
- /*针对单选项、多选项、下拉框:修改之前,将该字段不存在的值都更新为默认值第一个*/
- if (in_array($post['old_dtype'], ['radio', 'select', 'checkbox']) && in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $whereArr = [];
- $dfvalueArr = explode(',', $dfvalue);
- foreach($dfvalueArr as $key => $val){
- $whereArr[] = "`{$post['name']}` <> '{$val}'";
- }
- $whereStr = implode(' OR ', $whereArr);
- if (in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $new_dfvalue = NULL;
- } else {
- $new_dfvalue = '';
- }
- Db::name('single_content')->where($whereStr)->update([$post['name']=>$new_dfvalue]);
- }
- /*end*/
- /*组装完整的SQL语句,并执行编辑字段*/
- $fieldinfos = $this->fieldLogic->GetFieldMake($post['dtype'], $post['name'], $dfvalue, $post['title']);
- $ntabsql = $fieldinfos[0];
- $buideType = $fieldinfos[1];
- $maxlength = $fieldinfos[2];
- $table = PREFIX . 'arctype';
- $sql = " ALTER TABLE `$table` CHANGE COLUMN `{$old_name}` $ntabsql ";
- if (false !== Db::execute($sql)) {
- /*针对单选项、多选项、下拉框:修改之前,将该字段不存在的值都更新为默认值第一个*/
- if (in_array($post['old_dtype'], ['radio', 'select', 'checkbox']) && in_array($post['dtype'], ['radio', 'select', 'checkbox'])) {
- $whereArr = [];
- $new_dfvalue = '';
- $dfvalueArr = explode(',', $dfvalue);
- foreach($dfvalueArr as $key => $val){
- if ($key == 0) {
- $new_dfvalue = $val;
- }
- $whereArr[] = "`{$post['name']}` <> '{$val}'";
- }
- $whereArr[] = "`{$post['name']}` is NULL";
- $whereArr[] = "`{$post['name']}` = ''";
- $whereStr = implode(' OR ', $whereArr);
- Db::name('single_content')->where($whereStr)->update([$post['name']=>$new_dfvalue]);
- }
- /*end*/
- /*保存更新字段的记录*/
- $newData = array(
- 'dfvalue' => $dfvalue,
- 'maxlength' => $maxlength,
- 'define' => $buideType,
- 'ifmain' => 1,
- 'ifsystem' => 0,
- 'update_time' => getTime(),
- );
- $data = array_merge($post, $newData);
- M('channelfield')->where('id', $post['id'])->cache(true, null, "channelfield")->save($data);
- /*--end*/
- /*重新生成数据表字段缓存文件*/
- try {
- schemaTable($table);
- } catch (\Exception $e) {}
- /*--end*/
- \think\Cache::clear("arctype");
- $this->success("操作成功!", url('Field/arctype_index'));
- } else {
- $sql = " ALTER TABLE `$table` ADD $ntabsql ";
- if (false === Db::execute($sql)) {
- $this->error('操作失败!');
- }
- }
- }
- $id = input('param.id/d', 0);
- $info = array();
- if (!empty($id)) {
- $info = model('Channelfield')->getInfo($id);
- }
- if (!empty($info['ifsystem'])) {
- $this->error('系统字段不允许更改!');
- }
- $assign_data['info'] = $info;
- /*字段类型列表*/
- $fieldtype_list = [];
- $fieldtype_list_tmp = model('Field')->getFieldTypeAll('name,title,ifoption');
- foreach ($fieldtype_list_tmp as $key => $val) {
- if (!in_array($val['name'], ['file','media'])) {
- $fieldtype_list[] = $val;
- }
- }
- $assign_data['fieldtype_list'] = $fieldtype_list;
- /*--end*/
- /*模型ID*/
- $assign_data['channel_id'] = $channel_id;
- /*--end*/
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 删除-栏目字段
- */
- public function arctype_del()
- {
- $channel_id = $this->arctype_channel_id;
- $id = input('del_id/d', 0);
- if (!empty($id)) {
- /*删除表字段*/
- $row = $this->fieldLogic->delArctypeField($id);
- /*--end*/
- if (0 < $row['code']) {
- $map = array(
- 'id' => array('eq', $id),
- 'channel_id' => $channel_id,
- );
- $result = M('channelfield')->field('channel_id,name')->where($map)->select();
- $name_list = get_arr_column($result, 'name');
- /*删除字段的记录*/
- M('channelfield')->where($map)->delete();
- /*--end*/
- adminLog('删除栏目字段:' . implode(',', $name_list));
- $this->success('删除成功');
- }
- \think\Cache::clear('channelfield');
- \think\Cache::clear("arctype");
- respose(array('status' => 0, 'msg' => $row['msg']));
- } else {
- $this->error('参数有误');
- }
- }
- /**
- * 留言表单表单列表
- */
- public function attribute_index()
- {
- $assign_data = array();
- $condition = array();
- // 获取到所有GET参数
- $get = input('get.');
- $typeid = input('typeid/d');
- // 应用搜索条件
- foreach (['keywords', 'typeid'] as $key) {
- if (isset($get[$key]) && $get[$key] !== '') {
- if ($key == 'keywords') {
- $condition['a.attr_name'] = array('LIKE', "%{$get[$key]}%");
- } else if ($key == 'typeid') {
- $typeids = model('Arctype')->getHasChildren($get[$key]);
- $condition['a.typeid'] = array('IN', array_keys($typeids));
- } else {
- $condition['a.' . $key] = array('eq', $get[$key]);
- }
- }
- }
- $condition['b.id'] = ['gt', 0];
- $condition['a.is_del'] = 0;
- // 多语言
- $condition['a.lang'] = $this->admin_lang;
- /**
- * 数据查询,搜索出主键ID的值
- */
- $count = DB::name('guestbook_attribute')->alias('a')
- ->join('__ARCTYPE__ b', 'a.typeid = b.id', 'LEFT')
- ->where($condition)
- ->count();// 查询满足要求的总记录数
- $Page = new Page($count, config('paginate.list_rows'));// 实例化分页类 传入总记录数和每页显示的记录数
- $list = DB::name('guestbook_attribute')
- ->field("a.attr_id")
- ->alias('a')
- ->join('__ARCTYPE__ b', 'a.typeid = b.id', 'LEFT')
- ->where($condition)
- ->order('a.typeid desc, a.sort_order asc, a.attr_id asc')
- ->limit($Page->firstRow . ',' . $Page->listRows)
- ->getAllWithIndex('attr_id');
- /**
- * 完善数据集信息
- * 在数据量大的情况下,经过优化的搜索逻辑,先搜索出主键ID,再通过ID将其他信息补充完整;
- */
- if ($list) {
- $attr_ida = array_keys($list);
- $fields = "b.*, a.*";
- $row = DB::name('guestbook_attribute')
- ->field($fields)
- ->alias('a')
- ->join('__ARCTYPE__ b', 'a.typeid = b.id', 'LEFT')
- ->where('a.attr_id', 'in', $attr_ida)
- ->getAllWithIndex('attr_id');
- /*获取多语言关联绑定的值*/
- $row = model('LanguageAttr')->getBindValue($row, 'guestbook_attribute', $this->main_lang); // 多语言
- /*--end*/
- foreach ($row as $key => $val) {
- $val['fieldname'] = 'attr_' . $val['attr_id'];
- $row[$key] = $val;
- }
- foreach ($list as $key => $val) {
- $list[$key] = $row[$val['attr_id']];
- }
- }
- $show = $Page->show(); // 分页显示输出
- $assign_data['page'] = $show; // 赋值分页输出
- $assign_data['list'] = $list; // 赋值数据集
- $assign_data['pager'] = $Page; // 赋值分页对象
- /*获取当前模型栏目*/
- $select_html = allow_release_arctype($typeid, array(8));
- $typeidNum = substr_count($select_html, '</option>');
- $this->assign('select_html', $select_html);
- $this->assign('typeidNum', $typeidNum);
- /*--end*/
- // 栏目ID
- $assign_data['typeid'] = $typeid; // 栏目ID
- /*当前栏目信息*/
- $arctype_info = array();
- if ($typeid > 0) {
- $arctype_info = Db::name('arctype')->field('typename')->find($typeid);
- }
- $assign_data['arctype_info'] = $arctype_info;
- /*--end*/
- $assign_data['attrInputTypeArr'] = config('global.guestbook_attr_input_type'); // 表单类型
- //留言模型的栏目数量
- $assign_data['arctypeCount'] = Db::name('arctype')->where([
- 'current_channel' => 6,
- 'is_del' => 0,
- 'lang' => $this->admin_lang,
- ])->count();
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 新增留言表单
- */
- public function attribute_add()
- {
- //防止php超时
- function_exists('set_time_limit') && set_time_limit(0);
- $this->language_access(); // 多语言功能操作权限
- if (IS_AJAX && IS_POST)//ajax提交验证
- {
- $model = model('GuestbookAttribute');
- $attr_values = str_replace('_', '', input('attr_values')); // 替换特殊字符
- $attr_values = str_replace('@', '', $attr_values); // 替换特殊字符
- $attr_values = trim($attr_values);
- /*过滤重复值*/
- $attr_values_arr = explode(PHP_EOL, $attr_values);
- foreach ($attr_values_arr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($attr_values_arr[$key]);
- continue;
- }
- $attr_values_arr[$key] = $tmp_val;
- }
- $attr_values_arr = array_unique($attr_values_arr);
- $attr_values = implode(PHP_EOL, $attr_values_arr);
- /*end*/
- $post_data = input('post.');
- $post_data['attr_values'] = $attr_values;
- $attr_input_type = isset($post_data['attr_input_type']) ? $post_data['attr_input_type'] : 0;
- /*前台输入是否JS验证*/
- $validate_type = 0;
- $validate_type_list = config("global.validate_type_list"); // 前台输入验证类型
- if (!empty($validate_type_list[$attr_input_type])) {
- $validate_type = $attr_input_type;
- }
- /*end*/
- $savedata = array(
- 'attr_name' => $post_data['attr_name'],
- 'typeid' => $post_data['typeid'],
- 'attr_input_type' => $attr_input_type,
- 'attr_values' => isset($post_data['attr_values']) ? $post_data['attr_values'] : '',
- 'sort_order' => 100,
- 'is_showlist' => $post_data['is_showlist'],
- 'required' => $post_data['required'],
- 'validate_type' => $validate_type,
- 'lang' => $this->admin_lang,
- 'add_time' => getTime(),
- 'update_time' => getTime(),
- );
- // 数据验证
- $validate = \think\Loader::validate('GuestbookAttribute');
- if (!$validate->batch()->check($savedata)) {
- $error = $validate->getError();
- $error_msg = array_values($error);
- $return_arr = array(
- 'status' => -1,
- 'msg' => $error_msg[0],
- 'data' => $error,
- );
- respose($return_arr);
- } else {
- $model->data($savedata, true);// 收集数据
- $model->save(); // 写入数据到数据库
- $insertId = $model->getLastInsID();
- /*同步留言属性ID到多语言的模板变量里*/
- model('GuestbookAttribute')->syn_add_language_attribute($insertId);
- /*--end*/
- $return_arr = array(
- 'status' => 1,
- 'msg' => '操作成功',
- 'data' => array('url' => url('Field/attribute_index', array('typeid' => $post_data['typeid']))),
- );
- adminLog('新增留言表单:' . $savedata['attr_name']);
- respose($return_arr);
- }
- }
- $typeid = input('param.typeid/d', 0);
- if ($typeid > 0) {
- $select_html = M('arctype')->where('id', $typeid)->getField('typename');
- $select_html = !empty($select_html) ? $select_html : '该栏目不存在';
- } else {
- $select_html = allow_release_arctype($typeid, array(8));
- }
- $assign_data['select_html'] = $select_html; //
- $assign_data['typeid'] = $typeid; // 栏目ID
- $assign_data['attrInputTypeArr'] = config('global.guestbook_attr_input_type'); // 表单类型
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 编辑留言表单
- */
- public function attribute_edit()
- {
- if (IS_AJAX && IS_POST)//ajax提交验证
- {
- $model = model('GuestbookAttribute');
- $attr_values = str_replace('_', '', input('attr_values')); // 替换特殊字符
- $attr_values = str_replace('@', '', $attr_values); // 替换特殊字符
- $attr_values = trim($attr_values);
- /*过滤重复值*/
- $attr_values_arr = explode(PHP_EOL, $attr_values);
- foreach ($attr_values_arr as $key => $val) {
- $tmp_val = trim($val);
- if (empty($tmp_val)) {
- unset($attr_values_arr[$key]);
- continue;
- }
- $attr_values_arr[$key] = $tmp_val;
- }
- $attr_values_arr = array_unique($attr_values_arr);
- $attr_values = implode(PHP_EOL, $attr_values_arr);
- /*end*/
- $post_data = input('post.');
- $post_data['attr_values'] = $attr_values;
- $attr_input_type = isset($post_data['attr_input_type']) ? $post_data['attr_input_type'] : 0;
- /*前台输入是否JS验证*/
- $validate_type = 0;
- $validate_type_list = config("global.validate_type_list"); // 前台输入验证类型
- if (!empty($validate_type_list[$attr_input_type])) {
- $validate_type = $attr_input_type;
- }
- /*end*/
- $savedata = array(
- 'attr_id' => $post_data['attr_id'],
- 'attr_name' => $post_data['attr_name'],
- 'typeid' => $post_data['typeid'],
- 'attr_input_type' => $attr_input_type,
- 'attr_values' => isset($post_data['attr_values']) ? $post_data['attr_values'] : '',
- 'is_showlist' => $post_data['is_showlist'],
- 'required' => $post_data['required'],
- 'validate_type' => $validate_type,
- 'sort_order' => 100,
- 'update_time' => getTime(),
- );
- // 数据验证
- $validate = \think\Loader::validate('GuestbookAttribute');
- if (!$validate->batch()->check($savedata)) {
- $error = $validate->getError();
- $error_msg = array_values($error);
- $return_arr = array(
- 'status' => -1,
- 'msg' => $error_msg[0],
- 'data' => $error,
- );
- respose($return_arr);
- } else {
- $model->data($savedata, true); // 收集数据
- $model->isUpdate(true, [
- 'attr_id' => $post_data['attr_id'],
- 'lang' => $this->admin_lang,
- ])->save(); // 写入数据到数据库
- $return_arr = array(
- 'status' => 1,
- 'msg' => '操作成功',
- 'data' => array('url' => url('Field/attribute_index', array('typeid' => $post_data['typeid']))),
- );
- adminLog('编辑留言表单:' . $savedata['attr_name']);
- respose($return_arr);
- }
- }
- $assign_data = array();
- $id = input('id/d');
- /*获取多语言关联绑定的值*/
- $new_id = model('LanguageAttr')->getBindValue($id, 'guestbook_attribute'); // 多语言
- !empty($new_id) && $id = $new_id;
- /*--end*/
- $info = M('GuestbookAttribute')->where([
- 'attr_id' => $id,
- 'lang' => $this->admin_lang,
- ])->find();
- if (empty($info)) {
- $this->error('数据不存在,请联系管理员!');
- exit;
- }
- $assign_data['field'] = $info;
- // 所在栏目
- $select_html = M('arctype')->where('id', $info['typeid'])->getField('typename');
- $select_html = !empty($select_html) ? $select_html : '该栏目不存在';
- $assign_data['select_html'] = $select_html;
- $assign_data['attrInputTypeArr'] = config('global.guestbook_attr_input_type'); // 表单类型
- $this->assign($assign_data);
- return $this->fetch();
- }
- /**
- * 删除留言表单
- */
- public function attribute_del()
- {
- $this->language_access(); // 多语言功能操作权限
- $id_arr = input('del_id/a');
- $id_arr = eyIntval($id_arr);
- if (!empty($id_arr)) {
- /*多语言*/
- if (is_language()) {
- $attr_name_arr = [];
- foreach ($id_arr as $key => $val) {
- $attr_name_arr[] = 'attr_' . $val;
- }
- $new_id_arr = Db::name('language_attr')->where([
- 'attr_name' => ['IN', $attr_name_arr],
- 'attr_group' => 'guestbook_attribute',
- ])->column('attr_value');
- !empty($new_id_arr) && $id_arr = $new_id_arr;
- }
- /*--end*/
- $r = Db::name('GuestbookAttribute')->where([
- 'attr_id' => ['IN', $id_arr],
- ])->update([
- 'is_del' => 1,
- 'update_time' => getTime(),
- ]);
- if ($r) {
- adminLog('删除留言表单-id:' . implode(',', $id_arr));
- $this->success('删除成功');
- } else {
- $this->error('删除失败');
- }
- } else {
- $this->error('参数有误');
- }
- }
- /**
- * 检测列表显示字段数量是都超过4个
- */
- public function ajax_attribute_show()
- {
- if (IS_AJAX_POST) {
- $typeid = input('post.typeid/d');
- $is_showlist = input('post.is_showlist/d');
- if ($is_showlist == 1){
- $count = Db::name('guestbook_attribute')->where([
- 'typeid' => $typeid,
- 'is_showlist' => $is_showlist,
- 'lang' => $this->admin_lang,
- ])->count();
- if ($count >= 4) {
- $this->error('所属栏目的列表字段显示数量已达4个');
- } else {
- $this->success('正常');
- }
- }
- $this->success('正常');
- }
- $this->error('非法访问');
- }
- }
|