/** * 删除队列信息 */ public function delete() { $idarr = isset($_POST['id']) ? $_POST['id'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $where = to_sqls($idarr, '', 'id'); if ($this->db->delete($where)) { showmessage(L('operation_success'), HTTP_REFERER); } else { showmessage(L('operation_failure'), HTTP_REFERER); } }
/** * 查询多条数据并分页 * @param $where * @param $order * @param $page * @param $pagesize * @return unknown_type */ public final function listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key = '', $setpages = 10, $urlrule = '', $array = array()) { $where = to_sqls($where); $this->number = $this->count($where); $page = max(intval($page), 1); $offset = $pagesize * ($page - 1); $this->pages = pages($this->number, $page, $pagesize, $urlrule, $array, $setpages); $array = array(); return $this->select($where, '*', "{$offset}, {$pagesize}", $order, '', $key); }
/** * 查询多条数据并分页 * @param $where * @param $order * @param $page * @param $pagesize * @return unknown_type */ final public function listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key='', $setpages = 10,$urlrule = '',$array = array(), $data = '*') { $where = to_sqls($where); $this->number = $this->count($where); $page = max(intval($page), 1); $offset = $pagesize*($page-1); $this->pages = pages($this->number, $page, $pagesize, $urlrule, $array, $setpages); $array = array(); if ($this->number > 0) { return $this->select($where, $data, "$offset, $pagesize", $order, '', $key); } else { return array(); } }
/** * 首页 */ public function init() { if (isset($_POST['dosubmit'])) { $denyusername = isset($_POST['denyusername']) ? new_stripslashes(trim($_POST['denyusername'])) : ''; $denyemail = isset($_POST['denyemail']) ? new_stripslashes(trim($_POST['denyemail'])) : ''; $denyemaildata = array2string(explode("\r\n", $denyemail)); $denyusernamedata = array2string(explode("\r\n", $denyusername)); $this->db->insert(array('name' => 'denyemail', 'data' => $denyemaildata), 1, 1); $this->db->insert(array('name' => 'denyusername', 'data' => $denyusernamedata), 1, 1); /*写入缓存*/ setcache('settings', array('denyemail' => explode("\r\n", $denyemail), 'denyusername' => explode("\r\n", $denyusername))); showmessage(L('operation_success'), HTTP_REFERER); } $where = to_sqls(array('denyemail', 'denyusername'), '', 'name'); $settingarr = $this->db->listinfo($where); foreach ($settingarr as $v) { $setting[$v['name']] = string2array($v['data']); } include $this->admin_tpl('system'); }
public final function get_all($data = '*', $from = '', $where = '', $order = '', $limit = '') { if (!$from) { $from = $this->table_name; } $sql = 'SELECT ' . $data . ' FROM ' . $from; if ($where) { $where = to_sqls($where); $sql .= ' WHERE ' . $where; } if ($order) { $sql .= ' ORDER BY ' . $order; } if ($limit) { $limitNums = explode(',', $limit); $sql .= ' LIMIT ' . intval($limitNums[0]) . ',' . $limitNums[1]; } $arr = $this->selectBySql($sql); return $arr; }
public final function my_listinfo($where = '', $order = '', $page = 1, $pagesize = 20, $key = '', $setpages = 10, $urlrule = '', $array = array()) { if (is_array($where)) { $number = $this->query('select count(*) as num ' . substr($where['sql'], strpos($where['sql'], 'from'))); $num = $this->fetch_array($number); $this->number = $num[0]['num']; } else { $where = to_sqls($where); $this->number = $this->count($where); } $page = max(intval($page), 1); $offset = $pagesize * ($page - 1); $this->pages = my_pages($this->number, $page, $pagesize, $urlrule, $array, $setpages); $array = array(); if ($this->number > 0) { if (is_array($where)) { return $this->queryAll($where['sql'] . " order by {$order} limit {$offset}, {$pagesize}"); } else { return $this->select($where, '*', "{$offset}, {$pagesize}", $order, '', $key); } } else { return array(); } }
function getSql($avs, $siteID) { //properties $num = intval($avs['totalNum']); $start = $avs['startNum'] == null ? 0 : intval($avs['startNum']) - 1; $channelSql = ''; if ($avs['channelIndex']) { $channelObj = bpBase::loadAppClass('channelObj', 'channel', 1); $thisChannel = $channelObj->getChannelByIndex($avs['channelIndex'], 1); $channelids = array(); if (intval($thisChannel->id)) { $channelSql = ' AND A.channel_id=' . $thisChannel->id; array_push($channelids, $thisChannel->id); if ($avs['scope'] && $avs['scope'] == 'children') { $channels = $channelObj->getChannelsByParentID($thisChannel->id); if ($channels) { foreach ($channels as $c) { array_push($channelids, $c->id); } } } $channelSql = ' AND ' . to_sqls($channelids, '', 'A.channel_id'); } // } if (!intval($avs['city'])) { return 'SELECT A.autoid,A.id,A.site,A.link,A.externallink,A.thumb,CC.title,CC.title AS subtitle,A.title AS atitle,A.subtitle AS asubtitle,A.intro,A.source,A.author,A.time,A.keywords,A.pagecount FROM ' . TABLE_PREFIX . 'contentgroup_content CC,' . TABLE_PREFIX . 'article A WHERE groupid=' . $avs['id'] . ' AND A.id=CC.contentid' . $channelSql . ' AND A.time<{sysTime} ORDER BY CC.taxis DESC LIMIT ' . $start . ',' . $num; } else { return 'SELECT A.autoid,A.id,A.site,A.link,A.externallink,A.thumb,CC.title,CC.title AS subtitle,A.title AS atitle,A.subtitle AS asubtitle,A.intro,A.source,A.author,A.time,A.keywords,A.pagecount FROM ' . TABLE_PREFIX . 'contentgroup_content CC,' . TABLE_PREFIX . 'article A WHERE groupid=' . $avs['id'] . ' AND CC.geoid=' . intval($avs['city']) . ' AND A.id=CC.contentid' . $channelSql . ' AND A.time<{sysTime} ORDER BY CC.taxis DESC LIMIT ' . $start . ',' . $num; } }
/** * 关键词搜索 */ public function init() { //获取siteid $siteid = isset($_REQUEST['siteid']) && trim($_REQUEST['siteid']) ? intval($_REQUEST['siteid']) : 1; $SEO = seo($siteid); //搜索配置 $search_setting = getcache('search'); $setting = $search_setting[$siteid]; $search_model = getcache('search_model_' . $siteid); $type_module = getcache('type_module_' . $siteid); if (isset($_GET['q'])) { if (trim($_GET['q']) == '') { header('Location: ' . APP_PATH . 'index.php?m=search'); exit; } $typeid = empty($_GET['typeid']) ? 48 : intval($_GET['typeid']); $time = empty($_GET['time']) || !in_array($_GET['time'], array('all', 'day', 'month', 'year')) ? 'all' : trim($_GET['time']); $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $pagesize = 10; $q = safe_replace(trim($_GET['q'])); $q = htmlspecialchars(strip_tags($q)); $q = str_replace('%', '', $q); //过滤'%',用户全文搜索 $search_q = $q; //搜索原内容 //按时间搜索 if ($time == 'day') { $search_time = SYS_TIME - 86400; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'week') { $search_time = SYS_TIME - 604800; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'month') { $search_time = SYS_TIME - 2592000; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'year') { $search_time = SYS_TIME - 31536000; $sql_time = ' AND adddate > ' . $search_time; } else { $search_time = 0; $sql_time = ''; } if ($page == 1 && !$setting['sphinxenable']) { //精确搜索 $commend = $this->db->get_one("`typeid` = '{$typeid}' {$sql_time} AND `data` like '%{$q}%'"); } else { $commend = ''; } //如果开启sphinx if ($setting['sphinxenable']) { $sphinx = pc_base::load_app_class('search_interface', '', 0); $sphinx = new search_interface(); $offset = $pagesize * ($page - 1); $res = $sphinx->search($q, array($siteid), array($typeid), array($search_time, SYS_TIME), $offset, $pagesize, '@weight desc'); $totalnums = $res['total']; //如果结果不为空 if (!empty($res['matches'])) { $result = $res['matches']; } } else { pc_base::load_sys_class('segment', '', 0); $segment = new segment(); //分词结果 $segment_q = $segment->get_keyword($segment->split_result($q)); //如果分词结果为空 if (!empty($segment_q)) { $sql = "`siteid`= '{$siteid}' AND `typeid` = '{$typeid}' {$sql_time} AND MATCH (`data`) AGAINST ('{$segment_q}' IN BOOLEAN MODE)"; } else { $sql = "`siteid`= '{$siteid}' AND `typeid` = '{$typeid}' {$sql_time} AND `data` like '%{$q}%'"; } $result = $this->db->listinfo($sql, 'searchid DESC', $page, 10); } //如果开启相关搜索功能 if ($setting['relationenble']) { //如果关键词长度在8-16之间,保存关键词作为relation search $this->keyword_db = pc_base::load_model('search_keyword_model'); if (strlen($q) < 17 && strlen($q) > 5 && !empty($segment_q)) { $res = $this->keyword_db->get_one(array('keyword' => $q)); if ($res) { //关键词搜索数+1 //$this->keyword_db->update(array('searchnums'=>'+=1'), array('keyword'=>$q)); } else { //关键词转换为拼音 pc_base::load_sys_func('iconv'); $pinyin = gbk_to_pinyin($q); if (is_array($pinyin)) { $pinyin = implode('', $pinyin); } $this->keyword_db->insert(array('keyword' => $q, 'searchnums' => 1, 'data' => $segment_q, 'pinyin' => $pinyin)); } } //相关搜索 if (!empty($segment_q)) { $relation_q = str_replace(' ', '%', $segment_q); } else { $relation_q = $q; } $relation = $this->keyword_db->select("MATCH (`data`) AGAINST ('%{$relation_q}%' IN BOOLEAN MODE)", '*', 10, 'searchnums DESC'); } //如果结果不为空 if (!empty($result) || !empty($commend['id'])) { //开启sphinx后文章id取法不同 if ($setting['sphinxenable']) { foreach ($result as $_v) { $sids[] = $_v['attrs']['id']; } } else { foreach ($result as $_v) { $sids[] = $_v['id']; } } if (!empty($commend['id'])) { $sids[] = $commend['id']; } $sids = array_unique($sids); $where = to_sqls($sids, '', 'id'); //获取模型id $model_type_cache = getcache('type_model_' . $siteid, 'search'); $model_type_cache = array_flip($model_type_cache); $modelid = $model_type_cache[$typeid]; //是否读取其他模块接口 if ($modelid) { $this->content_db->set_model($modelid); /** * 如果表名为空,则为黄页模型 */ if (empty($this->content_db->model_tablename)) { $this->content_db = pc_base::load_model('yp_content_model'); $this->content_db->set_model($modelid); } if ($setting['sphinxenable']) { $data = $this->content_db->listinfo($where, 'id DESC', 1, $pagesize); $pages = pages($totalnums, $page, $pagesize); } else { $data = $this->content_db->select($where, '*'); $pages = $this->db->pages; $totalnums = $this->db->number; } //如果分词结果为空 if (!empty($segment_q)) { $replace = explode(' ', $segment_q); foreach ($replace as $replace_arr_v) { $replace_arr[] = '<font color=red>' . $replace_arr_v . '</font>'; } foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($replace, $replace_arr, $_v['title']); $data[$_k]['description'] = str_replace($replace, $replace_arr, $_v['description']); } } else { foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['title']); $data[$_k]['description'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['description']); } } } else { //读取专辑搜索接口 $special_api = pc_base::load_app_class('search_api', 'special'); $data = $special_api->get_search_data($sids); $totalnums = count($data); } } $execute_time = execute_time(); $pages = isset($pages) ? $pages : ''; $totalnums = isset($totalnums) ? $totalnums : 0; $data = isset($data) ? $data : ''; include template('search', 'list'); } else { include template('search', 'index'); } }
/** * 根据模板中的pageContents标签获取每页的数量值,仅生成静态页时有效 * * @param unknown_type $channelID * @return unknown */ public function getChannelTotalPage($channelID) { $tpl = bpBase::loadAppClass('template', 'template', 1); //channel $channelID = intval($channelID); $thisChannel = $this->getChannelByID($channelID); //分析模板 $template = $tpl->get($thisChannel->channeltemplate); if (!file_exists(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . $template->id . '.parsed.tpl.php')) { $tpl->createChannelPageR($channelid); } //只有生成静态页的情况下,下面的代码才有效 $totalPage = 1; if (file_exists(ABS_PATH . '/templatesCache/' . $template->id . '.tags.tpl.php')) { @(require ABS_PATH . '/templatesCache/' . $template->id . '.tags.tpl.php'); $pageSize = 20; //判断是否有分页标签 $isPagination = false; if ($tagsArr) { foreach ($tagsArr as $t) { if ($t['name'] == 'pageContents') { // $isPagination = true; $pageSize = $t['avs']['pageNum']; } } } if ($isPagination) { $childChannels = $this->getChannelsByParentID($channelID); $channelidArr = array($channelID); if ($childChannels) { foreach ($childChannels as $c) { array_push($channelidArr, $c->id); } } $article_db = bpBase::loadModel('article_model'); $where = to_sqls($channelidArr, '', 'channel_id'); $totalCount = $article_db->get_var($where, 'COUNT(id)', '', ''); $totalPage = $totalCount % $pageSize > 0 ? intval($totalCount / $pageSize) + 1 : $totalCount / $pageSize; $totalPage = $totalPage < 1 ? 1 : $totalPage; } else { $totalPage = 1; } } return $totalPage; }
public function deleteExRelateArticle20130416() { $taskName = 'deleteExRelateArticle20130416'; $thisTask = $this->update_log_db->get_one(array('file' => $taskName)); $this->_executedCheck($taskName, $thisTask); // $content_db = bpBase::loadModel('content_model'); $article_db = bpBase::loadModel('article_model'); $articles = $article_db->select(array('ex' => 1), 'id'); $articleids = array(); if ($articles) { foreach ($articles as $a) { array_push($articleids, $a['id']); } } $content_db->delete(to_sqls($articleids, '', 'contentid')); // $this->_finishTask($taskName, $thisTask); }
/** * 关键词搜索 */ public function init() { //获取siteid $siteid = isset($_REQUEST['siteid']) && trim($_REQUEST['siteid']) ? intval($_REQUEST['siteid']) : 1; $SEO = seo($siteid); //搜索配置 $search_setting = getcache('search'); $setting = $search_setting[$siteid]; $search_model = getcache('search_model_' . $siteid); $type_module = getcache('type_module_' . $siteid); if (isset($_POST['q'])) { if (trim($_POST['q']) == '') { header('Location: ' . APP_PATH . 'index.php?m=search'); exit; } $typeid = empty($_POST['typeid']) ? 0 : intval($_POST['typeid']); $time = empty($_POST['time']) || !in_array($_POST['time'], array('all', 'day', 'month', 'year', 'week')) ? 'all' : trim($_POST['time']); $page = isset($_POST['page']) ? intval($_POST['page']) : 1; $pagesize = 10; $q = safe_replace(trim($_POST['q'])); $q = new_html_special_chars(strip_tags($q)); $q = str_replace('%', '', $q); //过滤'%',用户全文搜索 $search_q = $q; //搜索原内容 $sql_time = $sql_tid = ''; if ($typeid) { $sql_tid = ' AND typeid = ' . $typeid; } //按时间搜索 if ($time == 'day') { $search_time = SYS_TIME - 86400; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'week') { $search_time = SYS_TIME - 604800; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'month') { $search_time = SYS_TIME - 2592000; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'year') { $search_time = SYS_TIME - 31536000; $sql_time = ' AND adddate > ' . $search_time; } else { $search_time = 0; $sql_time = ''; } if ($page == 1 && !$setting['sphinxenable']) { //精确搜索 $commend = $this->db->get_one("`siteid`= '{$siteid}' {$sql_tid} {$sql_time} AND `data` like '%{$q}%'"); } else { $commend = ''; } //如果开启sphinx if ($setting['sphinxenable']) { $sphinx = pc_base::load_app_class('search_interface', '', 0); $sphinx = new search_interface(); $offset = $pagesize * ($page - 1); $res = $sphinx->search($q, array($siteid), array($typeid), array($search_time, SYS_TIME), $offset, $pagesize, '@weight desc'); $totalnums = $res['total']; //如果结果不为空 if (!empty($res['matches'])) { $result = $res['matches']; } } else { $sql = "`siteid`= '{$siteid}' {$sql_tid} {$sql_time} AND `data` like '%{$q}%'"; $result = $this->db->listinfo($sql, 'searchid DESC', $page, 10); //$result = $this->db->listinfo($sql, 'adddate ASC', $page, 10); } //如果结果不为空 if (!empty($result) || !empty($commend['id'])) { foreach ($result as $_v) { if ($_v['typeid']) { $sids[$_v['typeid']][] = $_v['id']; } } if (!empty($commend['id'])) { if ($commend['typeid']) { $sids[$commend['typeid']][] = $commend['id']; } } $model_type_cache = getcache('type_model_' . $siteid, 'search'); $model_type_cache = array_flip($model_type_cache); $data = array(); foreach ($sids as $_k => $_val) { $tid = $_k; $ids = array_unique($_val); $where = to_sqls($ids, '', 'id'); //获取模型id $modelid = $model_type_cache[$tid]; //是否读取其他模块接口 if ($modelid) { $this->content_db->set_model($modelid); /** * 如果表名为空,则为黄页模型 */ if (empty($this->content_db->model_tablename)) { $this->content_db = pc_base::load_model('yp_content_model'); $this->content_db->set_model($modelid); } $datas = $this->content_db->select($where, '*', '', 'inputtime DESC'); } $data = array_merge($data, $datas); } $pages = $this->db->pages; $totalnums = $this->db->number; //如果分词结果为空 if (!empty($segment_q)) { $replace = explode(' ', $segment_q); foreach ($replace as $replace_arr_v) { $replace_arr[] = '' . $replace_arr_v . ''; } foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($replace, $replace_arr, $_v['title']); $data[$_k]['description'] = str_replace($replace, $replace_arr, $_v['description']); } } else { foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($q, '' . $q . '', $_v['title']); $data[$_k]['description'] = str_replace($q, '' . $q . '', $_v['description']); } } } $execute_time = execute_time(); $pages = isset($pages) ? $pages : ''; $totalnums = isset($totalnums) ? $totalnums : 0; $data = isset($data) ? $data : ''; include template('search', 'list'); } else { include template('search', 'index'); } }
function createChannelPageSelect() { $channel_db = bpBase::loadModel('channel_model'); $channel = bpBase::loadAppClass('channelObj', 'channel', 1); if (isset($_POST['doSubmit'])) { //选定栏目 if ($_GET['type'] == 'channel') { $channelIDStr = ''; if ($_POST['channels']) { $comma = ''; foreach ($_POST['channels'] as $c) { //$channelTotalPage=$channel->getChannelTotalPage($c); $channelTotalPage = 1; for ($t = 1; $t < $channelTotalPage + 1; $t++) { $channelIDStr .= $comma . $c . '.' . $t; //,channelid.pageNum $comma = ','; } //清除缓存 $content = bpBase::loadAppClass('articleObj', 'article', 1); $content->clearContentsCache($c); $channel->clearCrumbCache($c); } } file_put_contents(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . 'channels.txt', $channelIDStr); echo '<script>window.location.href=\'?m=template&c=createHtml&a=createChannelPage&siteid=' . $_GET['siteid'] . '&type=channel\';</script>'; } elseif ($_GET['type'] == 'content') { $article_db = bpBase::loadModel('article_model'); $contentIDStr = ''; if ($_POST['channels']) { $where = to_sqls($_POST['channels'], '', 'channel_id'); $contents = $article_db->get_results('id', '', $where, 'time DESC'); $comma = ''; if ($contents) { foreach ($contents as $cc) { $contentIDStr .= $comma . $cc->id; $comma = ','; } } } file_put_contents(ABS_PATH . 'templatesCache' . DIRECTORY_SEPARATOR . 'contents.txt', $contentIDStr); echo '<script>window.location.href=\'?m=template&c=createHtml&a=createChannelPage&siteid=' . $_GET['siteid'] . '&type=content\';</script>'; } } else { /* $channels=$channel_db->select(''); $channelsByID=array();//用栏目id作为数组id来组织栏目数组 if ($channels){ foreach ($channels as $c){ $channelsByID[$c['id']]=$c; } } $rights=$this->rights($user->uid);//根据用户id获取用户的权限数组 $accessChannels=$this->accessChannels($rights); //*******************向上查找哪些父栏目需要在栏目树中显示******************** $showChannels=array();//向上查找哪些父栏目需要在栏目树中显示 foreach ($accessChannels as $channelid){ $pid=$channelid; do { $pid=$channelsByID[$channelid]['parentid']; array_push($showChannels,$pid); array_push($showChannels,$channelid); $channelid=$channelsByID[$pid]['id']; }while ($pid!=0&&!in_array($pid,$showChannels)); } */ ///////////////////////////////////////////////// $selectOptionStr = $channel->channelCreatePageTree($channel->tree(0, $_GET['siteid']), 0, $accessChannels, $showChannels); include $this->showManageTpl('createChannelPageSelect'); } }
/** * 获取专题下内容数据 * @param string/intval $ids 多个id用“,”分开 */ public function get_search_data($ids) { $where = to_sqls($ids, '', 'id'); $data = $this->db->select($where, '`id`, `title`, `thumb`, `description`, `url`, `inputtime`', '', '', '', 'id'); return $data; }
public function exportmobile() { $start_time = isset($_POST['start_time']) ? $_POST['start_time'] : ''; $end_time = isset($_POST['end_time']) ? $_POST['end_time'] : date('Y-m-d', SYS_TIME); $where_start_time = strtotime($start_time) ? strtotime($start_time) : 0; $where_end_time = strtotime($end_time) + 86400; $groupid = isset($_POST['groupid']) && !empty($_POST['groupid']) ? $_POST['groupid'] : ''; $modelid = isset($_POST['modelid']) && !empty($_POST['modelid']) ? $_POST['modelid'] : 10; //开始时间大于结束时间,置换变量 if ($where_start_time > $where_end_time) { $tmp = $where_start_time; $where_start_time = $where_end_time; $where_end_time = $tmp; $tmptime = $start_time; $start_time = $end_time; $end_time = $tmptime; unset($tmp, $tmptime); } $where = ''; if ($groupid) { $where .= "`groupid` = '{$groupid}' AND "; } if ($modelid) { $where .= "`modelid` = '{$modelid}' AND "; } $where .= "`regdate` BETWEEN '{$where_start_time}' AND '{$where_end_time}'"; //根据条件读取会员主表 $total = $this->member_db->count($where); $str = ''; $perpage = 10; for ($i = 0; $i <= floor($total / $perpage); $i++) { $start = $i * $perpage; $data = $this->member_db->select($where, 'userid', "{$start}, {$perpage}"); $userid_arr = array(); foreach ($data as $v) { $userid_arr[] = $v['userid']; } $uids = to_sqls($userid_arr, '', 'userid'); //读取模型表中手机号码字段 $this->member_db->set_model($modelid); $data = $this->member_db->select($uids); foreach ($data as $v) { if (!empty($v['mobile'])) { $str .= $v['mobile'] . "\r\n"; } } $this->member_db->set_model(); } header("Content-type:application/octet-stream"); header("Content-Disposition: attachment; filename=mobile.txt"); echo $str; }
public function export() { if (isset($_POST['doSubmit'])) { //1 创建保存路径 $modelPath = ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'specialModel'; if (!file_exists($modelPath) || !is_dir($modelPath)) { mkdir($modelPath, 777); } $saveFolder = $modelPath . DIRECTORY_SEPARATOR . $_POST['enname']; if (!file_exists($saveFolder) || !is_dir($saveFolder)) { mkdir($saveFolder, 777); } //2 拷贝专题文件到模型路径 recurse_copy(ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'special' . DIRECTORY_SEPARATOR . $_POST['enname'] . DIRECTORY_SEPARATOR, $saveFolder . DIRECTORY_SEPARATOR); //3 保存模型信息:名称、简介等 $modelInfo = array(); $modelInfo['name'] = $_POST['name']; $modelInfo['enname'] = $_POST['enname']; $modelInfo['intro'] = $_POST['intro']; file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'modelInfo.txt', base64_encode(serialize($modelInfo))); //4 创建logo $logoPath = str_replace(array(MAIN_URL_ROOT . '/', '/'), array(ABS_PATH, DIRECTORY_SEPARATOR), $_POST['thumb']); @unlink($saveFolder . DIRECTORY_SEPARATOR . 'logo.jpg'); @rename($logoPath, $saveFolder . DIRECTORY_SEPARATOR . 'logo.jpg'); //5 导出专题首页模板信息 $thisSpecial = $this->special_db->get($_POST['specialid']); $tpl_db = bpBase::loadModel('template_model'); $thisTemplate = $tpl_db->get_one(array('id' => intval($thisSpecial['templateid']))); //保存专题首页模板 $tplFile = ABS_PATH . substr($thisTemplate['path'], 1); $thisTemplate['code'] = file_get_contents($tplFile); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'index.template.info.txt', base64_encode(serialize($thisTemplate))); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'index.template.txt', $thisTemplate['code']); //6 导出专题使用的栏目 $channel_db = bpBase::loadModel('channel_model'); $channels = $channel_db->select(array('site' => intval($_POST['specialid']))); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'channels.data.txt', base64_encode(serialize($channels))); //保存栏目信息 //7 处理栏目及内容用的模板 if ($channels) { //查询出所有用到的栏目和内容templateid $templateids = array(); foreach ($channels as $channel) { array_push($templateids, $channel['channeltemplate']); array_push($templateids, $channel['contenttemplate']); } $templates = $tpl_db->select(to_sqls($templateids, '', 'id')); $templates = arrToArrByKey($templates); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . 'templates.data.txt', base64_encode(serialize($templates))); foreach ($channels as $channel) { if ($channel['channeltype'] == 1) { //只处理普通栏目的模板 //只处理非默认模板 $thisChannelTemplate = $templates[$channel['channeltemplate']]; $thisContentTemplate = $templates[$channel['contenttemplate']]; if (!$thisChannelTemplate['isdefault']) { //栏目模板 $tplFile = ABS_PATH . substr($thisChannelTemplate['path'], 1); $code = file_get_contents($tplFile); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . $channel['cindex'] . '.' . $thisChannelTemplate['id'] . '.channel.template.txt', $code); } if (!$thisContentTemplate['isdefault']) { //内容模板 $tplFile = ABS_PATH . substr($thisContentTemplate['path'], 1); $code = file_get_contents($tplFile); file_put_contents($saveFolder . DIRECTORY_SEPARATOR . $channel['cindex'] . '.' . $thisContentTemplate['id'] . '.content.template.txt', $code); } } } } showMessage('导出完成', '?m=special&c=m_special&a=specials'); } else { $adus = bpBase::loadAppClass('adus', 'manage'); $adus->title = '导出专题为模型'; $adus->formAction = '?m=special&c=m_special&a=export'; $adus->tip = '导出条件:专题所用的图片、js和css均在“/templates/special/当前专题/”文件夹下'; /********************输入项*************************/ //获取专题模板文件夹列表 $specialPathSub = ABS_PATH . 'templates' . DIRECTORY_SEPARATOR . 'special'; $files = scandir($specialPathSub); $folderArr = array(); if ($files) { foreach ($files as $f) { if ($f != '.' && $f != '..' && is_dir($specialPathSub . DIRECTORY_SEPARATOR . $f)) { array_push($folderArr, array('itemValue' => $f, 'itemText' => $f, 'selected' => false)); } } } // $inputs = array(); array_push($inputs, array('name' => '名称', 'type' => 'text', 'validate' => "'required'", 'style' => 'width:180px;', 'field' => 'name', 'value' => '')); array_push($inputs, array('name' => '', 'type' => 'hidden', 'validate' => "'required'", 'field' => 'specialid', 'value' => $_GET['specialid'])); array_push($inputs, array('type' => 'select', 'field' => 'enname', 'name' => '选择文件夹', 'data' => $folderArr, 'complement' => '本专题的css、图片等文件存放文件夹')); array_push($inputs, array('name' => '缩略图', 'type' => 'thumb', 'validate' => "'required'", 'style' => 'width:180px;', 'field' => 'thumb', 'value' => '', 'width' => 800, 'height' => 800)); array_push($inputs, array('name' => '简介', 'type' => 'textarea', 'style' => 'width:80%;font-size:12px;height:60px;', 'field' => 'intro', 'value' => '')); $adus->inputs = $inputs; $adus->outputPage(); } }
/** * 删除用户 * @param string {$uid:用户id;$username:用户名;$email:email} * @return array {-1:删除失败;>0:删除成功} */ public function delete() { $this->uid = isset($this->data['uid']) ? $this->data['uid'] : ''; $this->email = isset($this->data['email']) ? $this->data['email'] : ''; if($this->uid > 0 || is_array($this->uid)) { $where = to_sqls($this->uid, '', 'uid'); //ucenter部份 if ($this->config['ucuse']) { pc_base::load_config('uc_config'); require_once PHPCMS_PATH.'api/uc_client/client.php'; $s = $this->db->select($where, 'ucuserid'); if ($s) { $uc_data = array(); foreach ($s as $k=>$v) { $uc_data[$k] = $v['ucuserid']; } if (!empty($uc_data)) $r = uc_user_delete($uc_data); if (!$r) { exit('-1'); } } else { exit('-1'); } } /*插入消息队列*/ $noticedata['uids'] = $this->uid; messagequeue::add('member_delete', $noticedata); $this->db->delete($where); exit('1'); } elseif(!empty($this->username)) { $this->db->delete(array('username'=>$this->username)); exit('2'); } elseif(!empty($this->email)) { $this->db->delete(array('email'=>$this->email)); exit('3'); } else { exit('-1'); } }
/** * move member */ function move() { if (isset($_POST['dosubmit'])) { $uidarr = isset($_POST['userid']) ? $_POST['userid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $groupid = isset($_POST['groupid']) && !empty($_POST['groupid']) ? $_POST['groupid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $where = to_sqls($uidarr, '', 'userid'); $this->db->update(array('groupid' => $groupid), $where); showmessage(L('member_move') . L('operation_success'), HTTP_REFERER, '', 'move'); } else { $show_header = $show_scroll = true; $grouplist = getcache('grouplist'); foreach ($grouplist as $k => $v) { $grouplist[$k] = $v['name']; } $ids = isset($_GET['ids']) ? explode(',', $_GET['ids']) : showmessage(L('illegal_parameters'), HTTP_REFERER); array_pop($ids); if (!empty($ids)) { $where = to_sqls($ids, '', 'userid'); $userarr = $this->db->listinfo($where); } else { showmessage(L('illegal_parameters'), HTTP_REFERER, '', 'move'); } include $this->admin_tpl('member_move'); } }
function searchContentSql($channelID = 0, $keywords = '', $page = 0, $count = 0, $starttime = 0, $endtime = 0, $exceptChannel = 0, $uid = 0, $siteid = 1) { $channelID = intval($channelID); $keywords = format_bracket($keywords); $starttime = intval($starttime); $endtime = intval($endtime); $exceptChannel = intval($exceptChannel); $keywordsArr = explode(' ', $keywords); $normalWords = array('的', '什么'); $keywordsSql = ''; if ($keywordsArr) { foreach ($keywordsArr as $k) { if (strlen($k) && !in_array($k, $normalWords)) { $keywordsSql .= ' OR content LIKE \'%' . $k . '%\' OR title LIKE \'%' . $k . '%\''; } } } $keywordsSql = substr($keywordsSql, 4); if (strlen($keywordsSql)) { $keywordsSql = ' AND (' . $keywordsSql . ')'; } //time if (!$starttime && !$endtime) { $timeSql = ''; } elseif ($endtime == 0) { $timeSql = ' AND time>' . $starttime . ' AND time<' . SYS_TIME; } else { $timeSql = ' AND time>' . $starttime . ' AND time<' . $endtime; } // //if (strlen($keywordsSql)){ $start = 0; if ($page > 1) { $start = ($page - 1) * $count; } $limitSql = ''; if ($count) { $limitSql .= ' LIMIT ' . $start . ',' . $count; } $channelIDSql = ''; if ($exceptChannel) { $exceptChannelSql = ' AND channel_id!=' . $exceptChannel; } $uid = intval($uid); $uidSql = ''; if ($uid) { $uidSql = ' AND uid=' . $uid; } if ($channelID) { $channelObj = bpBase::loadAppClass('channelObj', 'channel'); $descentChannels = $channelObj->allDescentChannels($channelID); $descentsCount = count($descentChannels); $channelIDArr = array($channelID); if ($descentChannels) { foreach ($descentChannels as $c) { array_push($channelIDArr, $c->id); } } $channelIDSql = ' AND ' . to_sqls($channelIDArr, '', 'channel_id'); } else { $channelIDSql = ''; } $article_db = M('article'); if (!$page && !$count) { $sql = 'SELECT COUNT(id) FROM ' . $article_db->table_name . ' WHERE site=' . $siteid . $channelIDSql . $timeSql . $keywordsSql . $exceptChannelSql . $uidSql; } else { $sql = 'SELECT * FROM ' . $article_db->table_name . ' WHERE site=' . $siteid . $channelIDSql . $timeSql . $keywordsSql . $exceptChannelSql . $uidSql . ' ORDER BY time DESC' . $limitSql; } return $sql; }
/** * ignore member */ function ignore() { if(isset($_POST['userid'])) { $uidarr = isset($_POST['userid']) ? $_POST['userid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $where = to_sqls($uidarr, '', 'userid'); $res = $this->db->update(array('status'=>2, 'message'=>$_POST['message']), $where); //发送 email通知 if($res) { if($_POST['sendemail']) { $memberinfo = $this->db->select($where); pc_base::load_sys_func('mail'); foreach ($memberinfo as $v) { sendmail($v['email'], L('reg_ignore'), $_POST['message']); } } } showmessage(L('ignore').L('operation_success'), HTTP_REFERER); } else { showmessage(L('operation_failure'), HTTP_REFERER); } }
public function check_manage_info() { if (isset($_POST['dosubmit'])) { $userid = $_POST['userid']; if (!isset($userid)) { $userid = $_POST['userids']; } if (!$userid) { showmessage(L('illegal_parameters'), HTTP_REFERER, 1250); } //echo $userid; $where = to_sqls($userid, '', 'userid'); //更新用户企业名称 //$nickname = isset($_POST['nickname']) ? trim($_POST['nickname']) : ''; //$groupid = isset($_POST['groupid']) ? trim($_POST['groupid']) : 10; //$nickname = safe_replace($nickname); $status = $_POST['status']; //echo $nickname; $this->db->update(array('status' => $status), $where); if (!isset($cookietime)) { $get_cookietime = param::get_cookie('cookietime'); } //更新用户状态 /*if(pc_base::load_config('system', 'phpsso')) { //初始化phpsso $this->_init_phpsso(); $res = $this->client->ps_member_edit('', '', '', '', $userid, '',$status); $message_error = array('-1'=>L('user_not_exist'), '-2'=>L('old_password_incorrect'), '-3'=>L('email_already_exist'), '-4'=>L('email_error'), '-5'=>L('param_error')); if ($res < 0) showmessage($message_error[$res]); }*/ $_cookietime = $cookietime ? intval($cookietime) : ($get_cookietime ? $get_cookietime : 0); $cookietime = $_cookietime ? TIME + $_cookietime : 0; param::set_cookie('_status', $status, $cookietime); /**发送短消息**/ $title = ''; $content = ''; $member_db = pc_base::load_model('member_model'); $message_db = pc_base::load_model('message_model'); switch ($status) { case 1: $content = $title = '您的企业资料当前在审核状态'; break; case -1: $title = '您的企业资料被驳回了,请重新填写资料,进行提交'; $content = "驳回意见:" . $_POST['reject_c']; break; case 99: $content = $title = '您企业资料已经审核通过了'; break; default: $content = $title = '您的资料审核状态有了新的变化'; } /**数组审核 发送消息**/ if (is_array($userid)) { foreach ($userid as $k => $u) { $memberinfo = $member_db->get_one(array('userid' => $u), 'userid, username'); $message_db->add_message($memberinfo['username'], 'SYSTEM', $title, $content); } } else { $memberinfo = $member_db->get_one(array('userid' => $userid), 'userid, username'); $message_db->add_message($memberinfo['username'], 'SYSTEM', $title, $content); } //$url=array('返回列表'=>'index.php?&menu=1&m=member&c=index&a=lists&status=2&search=search&steps=1&t=89&pt=78','查看此信息'=>HTTP_REFERER); showmessage("审核成功", HTTP_REFERER); } else { $memberinfo = $this->memberinfo; $memberinfo['userid'] = $_GET['userid']; $memberinfo['modelid'] = $_GET['modelid']; $memberinfo = $this->db->get_one(array('userid' => $memberinfo['userid'])); //获取企业模型表单 require CACHE_MODEL_PATH . 'member_form.class.php'; $member_form = new member_form($memberinfo['modelid']); $this->db->set_model($memberinfo['modelid']); $membermodelinfo = $this->db->get_one(array('userid' => $memberinfo['userid'])); $forminfos = $forminfos_arr = $member_form->get($membermodelinfo); //万能字段过滤 foreach ($forminfos as $field => $info) { if ($info['isomnipotent']) { unset($forminfos[$field]); } else { if ($info['formtype'] == 'omnipotent') { foreach ($forminfos_arr as $_fm => $_fm_value) { if ($_fm_value['isomnipotent']) { $info['form'] = str_replace('{' . $_fm . '}', $_fm_value['form'], $info['form']); } } $forminfos[$field]['form'] = $info['form']; } } } if ($_POST['type'] == 'pro') { } $formValidator = $member_form->formValidator; include template('member', 'check_manage_info'); } }
function channel() { $channelid = $this->channel['id']; //meta if (!$this->channel['metatitle']) { $this->assign('metaTitle', $this->channel['name'] . '_' . $this->site['name']); } else { $this->assign('metaTitle', $this->channel['metatitle']); } $this->assign('metaKeywords', $this->channel['metakeyword']); $this->assign('metaDescription', $this->channel['metades']); //子分类 $page = intval($_GET['page']); $page = $page > 0 ? $page : 1; $pageSize = intval($this->channel['pagesize']); $channelIDs = array($channelid); $subChannels = $this->channel_db->getChannelsByParentID($channelid); if ($subChannels) { $subChannels = objectsToArrByKey($subChannels); $subChannels = $this->convertLinks($subChannels); $this->assign('subChannels', $subChannels); if ($subChannels) { foreach ($subChannels as $sc) { array_push($channelIDs, $sc['id']); } } $contents = $this->article_db->listinfo(to_sqls($channelIDs, '', 'channel_id'), $order = 'taxis DESC', $page, $pageSize); } else { // $contents = $this->article_db->listinfo(array('channel_id' => $channelid), $order = 'taxis DESC', $page, $pageSize); } //如果只有一条信息就链接到该信息 if (count($contents) == 1) { header('Location:?m=site&c=home&a=content&contentid=' . $contents[0]['id']); } // $contents = $this->convertLinks($contents); $this->assign('contents', $contents); // $total = $this->article_db->number; if ($pageSize) { if ($total % $pageSize == 0) { $totalPage = $total / $pageSize; } else { $totalPage = intval($total / $pageSize) + 1; } } $totalPage = $totalPage > 0 ? $totalPage : 1; $this->assign('totalPage', $totalPage); //总页数 $currentPage = $page; $this->assign('currentPage', $currentPage); //当前页码 if ($totalPage == 1 || $currentPage == 1) { $this->assign('previousPageLink', 'javascript:void(0)'); //上页链接 } else { $previousPageNum = $currentPage - 1; $this->assign('previousPageLink', $this->channel['link'] . '&page=' . $previousPageNum); //上页链接 } if ($totalPage == 1 || $currentPage == $totalPage) { $this->assign('nextPageLink', 'javascript:void(0)'); //下页链接 } else { $nextPageNum = $currentPage + 1; $this->assign('nextPageLink', $this->channel['link'] . '&page=' . $nextPageNum); //下页链接 } //template $template_db = M('template'); $channelTemplate = $template_db->get_one(array('id' => $this->channel['channeltemplate'])); $templatePaths = explode('/', $channelTemplate['path']); $templateFileName = $templatePaths[count($templatePaths) - 1]; $this->display($this->smartyDir . $templateFileName, 0); }
/** * 删除会员模型 */ function delete() { $modelidarr = isset($_POST['modelid']) ? $_POST['modelid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $newmodelarr = ''; foreach ($modelidarr as $modelarr) { if ($modelarr != 10) { $newmodelarr[] = intval($modelarr); } } $where = to_sqls($newmodelarr, '', 'modelid'); $modelinfo = $this->db->select($where); foreach ($modelinfo as $v) { $this->db->drop_table($v['tablename']); } if ($this->db->delete($where)) { //删除模型字段 $this->sitemodel_field_db = pc_base::load_model('sitemodel_field_model'); $this->sitemodel_field_db->delete($where); //修改用户模型组为普通会员 $this->member_db = pc_base::load_model('members_model'); $this->member_db->update(array('modelid' => 10), $where); //更新模型缓存 pc_base::load_app_class('member_cache', '', ''); member_cache::update_cache_model(); showmessage(L('operation_success'), HTTP_REFERER); } else { showmessage(L('operation_failure'), HTTP_REFERER); } }
/** * 删除会员 */ public function delete() { $uidarr = isset($_POST['uid']) ? $_POST['uid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $new_arr = array(); foreach ($uidarr as $v) { $v = intval($v); $new_arr[] = $v; //删除头像 $dir = ps_getavatar($v, 1); ps_unlink($dir); } $where = to_sqls($new_arr, '', 'uid'); //ucenter部份 if ($this->config['ucuse']) { pc_base::load_config('uc_config'); include PHPCMS_PATH . 'api/uc_client/client.php'; $s = $this->db->select($where, 'ucuserid'); if ($s) { $uc_data = array(); foreach ($s as $k => $v) { $uc_data[$k] = $v['ucuserid']; } if (!empty($uc_data)) { $r = uc_user_delete($uc_data); } if (!$r) { showmessage(L('operation_failure'), HTTP_REFERER); } } else { showmessage(L('operation_failure'), HTTP_REFERER); } } if ($this->db->delete($where)) { /*插入消息队列*/ $noticedata = array('uids' => $new_arr); messagequeue::add('member_delete', $noticedata); showmessage(L('operation_success'), HTTP_REFERER); } else { showmessage(L('operation_failure'), HTTP_REFERER); } }
public function search() { $this->db = pc_base::load_model('search_model'); $q = safe_replace(trim($_POST['title'])); $typeid = isset($_GET['typeid']) ? intval($_GET['typeid']) : 58; $siteid = isset($_GET['siteid']) ? intval($_GET['siteid']) : 1; $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $q = htmlspecialchars(strip_tags($q)); $q = str_replace('%', '', $q); // 过滤'%',用户全文搜索 $search_q = $q; // 搜索原内容 $time = empty($_GET['time']) || !in_array($_GET['time'], array('all', 'day', 'month', 'year')) ? 'all' : trim($_GET['time']); if ($time == 'day') { $search_time = SYS_TIME - 86400; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'week') { $search_time = SYS_TIME - 604800; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'month') { $search_time = SYS_TIME - 2592000; $sql_time = ' AND adddate > ' . $search_time; } elseif ($time == 'year') { $search_time = SYS_TIME - 31536000; $sql_time = ' AND adddate > ' . $search_time; } else { $search_time = 0; $sql_time = ''; } if ($page == 1 && !$setting['sphinxenable']) { // 精确搜索 $commend = $this->db->get_one("`typeid` = '{$typeid}' {$sql_time} AND `data` like '%{$q}%'"); } else { $commend = ''; } pc_base::load_sys_class('segment', '', 0); $segment = new segment(); // 分词结果 $segment_q = $segment->get_keyword($segment->split_result($q)); // 如果分词结果为空 if (!empty($segment_q)) { $sql = "`siteid`= '{$siteid}' AND `typeid` = '{$typeid}' {$sql_time} AND MATCH (`data`) AGAINST ('{$segment_q}' IN BOOLEAN MODE)"; } else { $sql = "`siteid`= '{$siteid}' AND `typeid` = '{$typeid}' {$sql_time} AND `data` like '%{$q}%'"; } $result = $this->db->listinfo($sql, 'searchid DESC', $page, 7); if (!empty($result) || !empty($commend['id'])) { //开启sphinx后文章id取法不同 if ($setting['sphinxenable']) { foreach ($result as $_v) { $sids[] = $_v['attrs']['id']; } } else { foreach ($result as $_v) { $sids[] = $_v['id']; } } if (!empty($commend['id'])) { $sids[] = $commend['id']; } $sids = array_unique($sids); $where = to_sqls($sids, '', 'id'); //获取模型id $model_type_cache = getcache('type_model_' . $siteid, 'search'); $model_type_cache = array_flip($model_type_cache); $modelid = $model_type_cache[$typeid]; //是否读取其他模块接口 if ($modelid) { $this->content_db->set_model($modelid); /** * 如果表名为空,则为黄页模型 */ if (empty($this->content_db->model_tablename)) { $this->content_db = pc_base::load_model('yp_content_model'); $this->content_db->set_model($modelid); } if ($setting['sphinxenable']) { $data = $this->content_db->listinfo($where, 'id DESC', 1, $pagesize); $pages = wpa_pages($totalnums, $page, $pagesize); } else { $data = $this->content_db->select($where, '*'); $pages = $this->db->pages; $totalnums = $this->db->number; } //如果分词结果为空 if (!empty($segment_q)) { $replace = explode(' ', $segment_q); foreach ($replace as $replace_arr_v) { $replace_arr[] = '<font color=red>' . $replace_arr_v . '</font>'; } foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($replace, $replace_arr, $_v['title']); $data[$_k]['description'] = str_replace($replace, $replace_arr, $_v['description']); } } else { foreach ($data as $_k => $_v) { $data[$_k]['title'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['title']); $data[$_k]['description'] = str_replace($q, '<font color=red>' . $q . '</font>', $_v['description']); } } } else { //读取专辑搜索接口 $special_api = pc_base::load_app_class('search_api', 'special'); $data = $special_api->get_search_data($sids); $totalnums = count($data); } } $execute_time = execute_time(); $totalnums = isset($totalnums) ? $totalnums : 0; $totalpage = $totalnums / 7; $pagesi = wpa_pages($totalpage, $page, 7); $data = isset($data) ? $data : ''; include template('wap', 'list_search'); }
$userinfo['regdate'] = $userinfo['lastdate'] = SYS_TIME; $userinfo['modelid'] = 10; $userinfo['groupid'] = 6; $userid = $db->insert($userinfo, 1); if ($userid) { exit('1'); } else { exit('0'); } } /** * 删除用户 */ if ($action == 'member_delete') { $uidarr = $arr['uids']; $where = to_sqls($uidarr, '', 'phpssouid'); $status = $db->delete($where); if ($status) { exit('1'); } else { exit('0'); } } /** * 编辑用户 */ if ($action == 'member_edit') { if (!isset($arr['uid'])) { exit('0'); } $userinfo = array();
/** * move member */ function move() { if (isset($_POST['dosubmit'])) { $uidarr = isset($_POST['userid']) ? $_POST['userid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $groupid = isset($_POST['groupid']) && !empty($_POST['groupid']) ? $_POST['groupid'] : showmessage(L('illegal_parameters'), HTTP_REFERER); $where = to_sqls($uidarr, '', 'userid'); $title = ''; $content = ''; switch ($groupid) { case 10: $content = $title = '您的企业资料当前在审核状态'; break; case 11: $title = '您的企业资料被驳回了,请重新填写资料,进行提交'; $content = "驳回意见:" . $_POST['reject_c']; break; case 12: $content = $title = '您企业资料已经审核通过了'; break; default: $content = $title = '您的资料有了新的更新'; } $member_db = pc_base::load_model('member_model'); $message_db = pc_base::load_model('message_model'); if (isset($uidarr) && !empty($uidarr)) { foreach ($uidarr as $id) { $memberinfo = $member_db->get_one(array('userid' => $id), 'userid, username'); $message_db->add_message($memberinfo['username'], 'SYSTEM', $title, $content); } } $this->db->update(array('groupid' => $groupid), $where); showmessage('操作成功', HTTP_REFERER); } else { $show_header = $show_scroll = true; $grouplist = getcache('grouplist'); foreach ($grouplist as $k => $v) { $grouplist[$k] = $v['name']; } $ids = isset($_GET['ids']) ? explode(',', $_GET['ids']) : showmessage(L('illegal_parameters'), HTTP_REFERER); array_pop($ids); if (!empty($ids)) { $where = to_sqls($ids, '', 'userid'); $userarr = $this->db->listinfo($where); } else { showmessage(L('illegal_parameters'), HTTP_REFERER, '', 'move'); } include $this->admin_tpl('member_move'); } }