예제 #1
0
 public function lists()
 {
     $mid = intval($_GET['mid']);
     $did = intval($_GET['did']);
     $page = !empty($_GET['p']) ? intval($_GET['p']) : 1;
     $limit = intval(C('user_page_cm'));
     $order = C('db_prefix') . 'comment.addtime desc';
     $join = C('db_prefix') . 'user on ' . C('db_prefix') . 'comment.uid = ' . C('db_prefix') . 'user.id';
     $field = C('db_prefix') . 'comment.*,' . C('db_prefix') . 'user.id as userid,' . C('db_prefix') . 'user.username,' . C('db_prefix') . 'user.face';
     $where[C('db_prefix') . 'comment.did'] = array('eq', $did);
     $where[C('db_prefix') . 'comment.mid'] = array('eq', $mid);
     if (C('user_check')) {
         $where[C('db_prefix') . 'comment.status'] = array('eq', 1);
     }
     $rs = M('comment');
     $count = $rs->field($field)->where($where)->count('id');
     $totalpages = ceil($count / $limit);
     //
     $list = $rs->field($field)->where($where)->join($join)->order($order)->limit($limit)->page($page)->select();
     foreach ($list as $key => $val) {
         $list[$key]['floor'] = $count - (($page - 1) * $limit + $key);
     }
     //分页链接参数
     $pageurl = 'javascript:void(0)" onclick="CommentShow(\'' . U('comment/lists', array('mid' => $mid, 'did' => $did, 'p' => '{!page!}'), false, false) . '\')';
     $pages = '共' . $count . '条评论 当前:' . $page . '/' . $totalpages . '页 ';
     $pages .= get_cms_page_css($page, $totalpages, C('user_page_cm'), $pageurl, false);
     $this->assign('mid', $mid);
     $this->assign('did', $did);
     $this->assign('pages', $pages);
     $this->assign('count', $count);
     $this->assign('list_comment', $list);
     $this->display('comment');
 }
예제 #2
0
 public function lists()
 {
     $id = intval($_GET['id']);
     $page = !empty($_GET['p']) ? intval($_GET['p']) : 1;
     $limit = intval(C('user_page_gb'));
     $order = C('db_prefix') . 'gbook.addtime desc';
     $join = C('db_prefix') . 'user on ' . C('db_prefix') . 'gbook.uid = ' . C('db_prefix') . 'user.id';
     $field = C('db_prefix') . 'gbook.*,' . C('db_prefix') . 'user.id as userid,' . C('db_prefix') . 'user.username,' . C('db_prefix') . 'user.face';
     if (C('user_check')) {
         $where[C('db_prefix') . 'gbook.status'] = array('eq', 1);
     }
     $rs = M('gbook');
     $count = $rs->field($field)->where($where)->count('id');
     $page = get_cms_page_max($count, $limit, $page);
     $list = $rs->field($field)->where($where)->join($join)->order($order)->limit($limit)->page($page)->select();
     //dump($rs->getLastSql());
     foreach ($list as $key => $val) {
         $list[$key]['floor'] = $count - (($page - 1) * $limit + $key);
     }
     //强制栏目为动态模式
     C('url_html_channel', 0);
     //分页展示信息
     $totalpages = ceil($count / $limit);
     $pages = '共' . $count . '篇留言 当前:' . $page . '/' . $totalpages . '页 ';
     $pages .= get_cms_page_css($page, $totalpages, C('web_home_pagenum'), get_show_url('guestbook', '', 2), false);
     if ($id) {
         $rs = M("Video");
         $arr = $rs->field('id,title')->where('status=1 and id=' . $id)->find();
         if ($arr) {
             $this->assign('content', '影片<' . $arr['title'] . '>不能观看,请修复!');
         }
     }
     $this->assign('webtitle', '留言本' . '-' . C('web_name'));
     $this->assign('navtitle', '<a href="' . C('web_path') . '">首页</a> &gt; <span>留言本</span>');
     $this->assign('list_guestbook', $list);
     $this->assign('pages', $pages);
     $this->assign('count', $count);
     $this->assign('id', $id);
     $this->display('guestbook');
 }
예제 #3
0
 public function lists()
 {
     //获取地址栏参数并读取栏目缓存信息
     $page = !empty($_GET['p']) ? intval($_GET['p']) : 1;
     $order = !empty($_GET['order']) ? get_replace_order($_GET['order']) : 'addtime';
     $list = F('_gxcms/channel');
     $channel['limit'] = $list[999]['special'];
     //查询本类及小类共多少条数据
     $where['status'] = array('eq', 1);
     $rs = M('special');
     $count = $rs->where($where)->count('id');
     //生成翻页链接参数(支持排序所以强制栏目为动态模式)
     C('url_html_channel', 0);
     if ($order != 'addtime') {
         $arrurl['order'] = $order;
     }
     //组合分页信息
     $totalpages = ceil($count / $channel['limit']);
     if ($page > $totalpages) {
         $page = $totalpages;
     }
     $pages = '共' . $count . '篇专题&nbsp;当前:' . $page . '/' . $totalpages . '页&nbsp;';
     $pages .= get_cms_page_css($page, $totalpages, C('web_home_pagenum'), get_show_url('special', $arrurl, 2), false);
     //整理栏目前台标签数组变量
     $channel['order'] = $order;
     $channel['page'] = $page;
     $channel['pages'] = $pages;
     $channel['count'] = $count;
     $channel['navtitle'] = '<a href="' . C('web_path') . '">首页</a> &gt; <span>专题列表</span>';
     if ($page > 1) {
         $channel['webtitle'] = '专题列表-第' . $page . '页-' . C('web_name');
     } else {
         $channel['webtitle'] = '专题列表-' . C('web_name');
     }
     //先给bdlist标签传值后再输出模板
     C('bdlist_page', $page);
     $this->assign($channel);
     $this->display('special_list');
 }
예제 #4
0
파일: common.php 프로젝트: skygunner/ekucms
function get_cms_page($totalrecords, $pagesize, $currentpage, $params, $filename = '条数据', $pagego = true, $halfPer = 5)
{
    $page['totalrecords'] = $totalrecords;
    //总记录数
    $page['totalpages'] = ceil($page['totalrecords'] / $pagesize);
    //总页数
    $page['currentpage'] = $currentpage;
    //当前页数
    $page['urlpage'] = $params . '{!page!}';
    $page['listpages'] = '共' . $page['totalrecords'] . $filename . '&nbsp;当前:' . $page['currentpage'] . '/' . $page['totalpages'] . '页&nbsp;';
    if ($pagego) {
        $pagego = 'jumpurl(\'' . $page['urlpage'] . '\',' . $page['totalpages'] . ')';
    }
    $page['listpages'] .= get_cms_page_css($page['currentpage'], $page['totalpages'], $halfPer, $page['urlpage'], $pagego);
    return $page;
}
예제 #5
0
 public function search()
 {
     //获取地址栏参数并读取缓存信息
     $url = get_url_where();
     $list = F('_gxcms/channel');
     $channel = $list[999];
     //搜索条件
     $where['status'] = array('eq', 1);
     if ($url['wd']) {
         $search['title'] = array('like', '%' . $url['wd'] . '%');
         //$search['intro'] = array('like','%'.$url['wd'].'%');
         $search['actor'] = array('like', '%' . $url['wd'] . '%');
         $search['director'] = array('like', '%' . $url['wd'] . '%');
         $jumpurl['wd'] = urlencode($url['wd']);
     }
     if ($url['year']) {
         $search['year'] = array('eq', $url['year']);
         $jumpurl['year'] = $url['year'];
     }
     if ($url['area']) {
         $search['area'] = array('eq', '.$url["area"].');
         $jumpurl['area'] = urlencode($url['area']);
     }
     if ($url['letter']) {
         $search['letter'] = array('eq', $url['letter']);
         $jumpurl['letter'] = $url['letter'];
     }
     if ($url['id']) {
         if (get_channel_son($url['id'])) {
             $where['cid'] = $url['id'];
         } else {
             $where['cid'] = get_channel_sqlin($url['id']);
         }
         $jumpurl['id'] = $url['id'];
     }
     if (isset($search)) {
         $search['_logic'] = 'or';
         $where['_complex'] = $search;
     }
     if ($url['order'] != 'addtime') {
         $jumpurl['order'] = $url['order'];
     }
     $rs = M('Video');
     $count = $rs->where($where)->count('id');
     //组合分页信息(强制为动态模式)
     C('url_html_channel', 0);
     $jumpurl['p'] = '';
     $totalpages = ceil($count / $channel['video']);
     if ($url['page'] > $totalpages) {
         $url['page'] = $totalpages;
     }
     $pages = '共' . $count . '部影片&nbsp;当前:' . $url['page'] . '/' . $totalpages . '页&nbsp;';
     $pages .= get_cms_page_css($url['page'], $totalpages, C('web_home_pagenum'), str_replace('/lists', '/search', get_show_url('video', $jumpurl, 2)), false);
     //前台模板变量赋值
     $channel['cid'] = $url['id'];
     $channel['year'] = $url['year'];
     $channel['area'] = $url['area'];
     $channel['keyword'] = $url['wd'];
     $channel['order'] = $url['order'];
     $channel['letter'] = $url['letter'];
     $channel['count'] = $count;
     $channel['page'] = $url['page'];
     $channel['pages'] = $pages;
     if ($url['page'] > 1) {
         $channel['webtitle'] = '搜索 ' . $url['wd'] . ' 的结果列表 -第' . $url['page'] . '页-' . C('web_name');
     } else {
         $channel['webtitle'] = '搜索 ' . $url['wd'] . ' 的结果列表 -' . C('web_name');
     }
     $channel['navtitle'] = '<a href="' . C('web_path') . '">首页</a> &gt; <span>搜索页</span>';
     //先给bdsearch标签传值后再输出模板
     C('bdsearch_page', $url['page']);
     C('bdsearch_where', $where);
     $this->assign($channel);
     $this->display('video_search');
 }
예제 #6
0
 /**
  * 将资源站抓取的值整理成数组变量(飞飞+光线)
  * 
  * @param  $array_url
  * @param  $xml
  */
 public function ff_gx_xml($array_url, $xml)
 {
     //组合分页信息
     preg_match('<list page="([0-9]+)" pagecount="([0-9]+)" pagesize="([0-9]+)" recordcount="([0-9]+)">', $xml, $page_array);
     $xml_page['recordcount'] = $page_array[4];
     $xml_page['pagecount'] = $page_array[2];
     $xml_page['pagesize'] = $page_array[3];
     $xml_page['pageindex'] = $page_array[1];
     $array_url['p'] = '{!page!}';
     $array_tpl['pageurl'] = U('Admin-Collect/Gxcms', $array_url);
     $array_tpl['pagelist'] = '共' . $xml_page['recordcount'] . '条数据&nbsp;页次:' . $xml_page['pageindex'] . '/' . $xml_page['pagecount'] . '页&nbsp;' . get_cms_page_css($xml_page['pageindex'], $xml_page['pagecount'], 5, $array_tpl['pageurl'], 'pagego(\'' . $array_tpl['pageurl'] . '\',' . $xml_page['pagecount'] . ')');
     //组合绑定分类
     preg_match_all('/<ty id="([0-9]+)">([\\s\\S]*?)<\\/ty>/', $xml, $array_list);
     foreach ($array_list[1] as $key => $value) {
         $list[$key]['cid'] = $value;
         $list[$key]['cname'] = $array_list[2][$key];
         $list[$key]['bind_id'] = $array_url['fid'] . '_' . $value;
     }
     //组合单个影视数据
     preg_match_all('/<video><last>([\\s\\S]*?)<\\/last><id>([0-9]+)<\\/id><tid>([0-9]+)<\\/tid><name><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/name><type>([\\s\\S]*?)<\\/type><dt>([\\s\\S]*?)<\\/dt><pic>([\\s\\S]*?)<\\/pic><lang>([\\s\\S]*?)<\\/lang><area>([\\s\\S]*?)<\\/area><year>([\\s\\S]*?)<\\/year><state>([\\s\\S]*?)<\\/state><note><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/note><actor><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/actor><director><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/director><dl>([\\s\\S]*?)<\\/dl><des><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/des><reurl>([\\s\\S]*?)<\\/reurl><\\/video>/', $xml, $array_vod);
     foreach ($array_vod[1] as $key => $value) {
         $vod[$key]['addtime'] = $value;
         $vod[$key]['id'] = $array_vod[2][$key];
         $vod[$key]['iid'] = $array_vod[2][$key];
         $vod[$key]['cid'] = getbindval($array_url['fid'] . '_' . $array_vod[3][$key]);
         $vod[$key]['title'] = htmlspecialchars_decode($array_vod[4][$key]);
         $vod[$key]['cname'] = $array_vod[5][$key];
         $vod[$key]['picurl'] = $array_vod[7][$key];
         $vod[$key]['language'] = $array_vod[8][$key];
         $vod[$key]['area'] = $array_vod[9][$key];
         $vod[$key]['year'] = $array_vod[10][$key];
         $vod[$key]['serial'] = $array_vod[11][$key];
         $vod[$key]['intro'] = htmlspecialchars_decode($array_vod[12][$key]);
         $vod[$key]['actor'] = htmlspecialchars_decode($array_vod[13][$key]);
         $vod[$key]['director'] = htmlspecialchars_decode($array_vod[14][$key]);
         $vod[$key]['content'] = htmlspecialchars_decode($array_vod[16][$key]);
         $vod[$key]['inputer'] = $array_url['fid'] . '_' . $vod[$key]['id'];
         $vod[$key]['reurl'] = $array_vod[17][$key];
         if (!$vod[$key]['reurl']) {
             $vod[$key]['reurl'] = str_replace('@', '/', $array_url['reurl']) . $vod[$key]['id'];
         }
         preg_match_all('/<dd flag="([\\s\\S]*?)"><\\!\\[CDATA\\[([\\s\\S]*?)\\]\\]><\\/dd>/', $array_vod[15][$key], $url_arr);
         $vod[$key]['playurl'] = htmlspecialchars_decode(implode('$$$', $url_arr[2]));
     }
     $array['url'] = $array_url;
     //远程URL变量
     $array['tpl'] = $array_tpl;
     //本地模板变量
     $array['page'] = $xml_page;
     //远程分页信息
     $array['listclass'] = $list;
     //远程分类变量
     $array['listvod'] = $vod;
     //远程数据变量
     return $array;
 }
예제 #7
0
 public function specialshow()
 {
     $go = intval($_GET['go']);
     $this->checkhtml(C('url_html_channel'), '专题栏目', '?s=Admin/Html/Maps/go/' . $go);
     $list = F('_gxcms/channel');
     $channel['limit'] = $list[999]['special'];
     //查询本类及小类共多少条数据
     $rs = M("Special");
     $where['status'] = array('eq', 1);
     $count = $rs->where($where)->count('id');
     //计算出该栏目需要生成的总页数
     $totalpages = ceil($count / $channel['limit']);
     if ($totalpages < 1) {
         $totalpages = 1;
     }
     //准备生成
     echo '<div class="htmllist" id="show" style="font-size:12px;">';
     echo '<li>网站专题共需要生成<span>' . $totalpages . '</span>页</li>';
     for ($ii = 1; $ii <= $totalpages; $ii++) {
         //当前专题分页前台标签数组变量-------------------------------------------------------------------
         $pageurl = get_show_url('special', array('id' => $cid), 2);
         $pages = '共' . $count . '篇专题&nbsp;当前:' . $ii . '/' . $totalpages . '页&nbsp;';
         $pages .= get_cms_page_css($ii, $totalpages, 5, $pageurl, false);
         $channel['page'] = $ii;
         $channel['pages'] = $pages;
         $channel['count'] = $count;
         if ($ii > 1) {
             $channel['webtitle'] = '专题列表-第' . $ii . '页-' . C('web_name');
         } else {
             $channel['webtitle'] = '专题列表-' . C('web_name');
         }
         $channel['navtitle'] = '<a href="' . C('web_path') . '">首页</a> &gt; <span>专题列表</span>';
         //先给bdlist标签传值后再生成模板
         C('bdlist_page', $page);
         $this->assign($channel);
         $listdir = str_replace('{!page!}', $ii, get_show_url_dir('special', $cid, $ii));
         //保存路径
         $this->buildHtml($listdir, './', 'Home:special_list');
         $specialurl = C('webpath') . $listdir . C('html_file_suffix');
         //预览路径
         echo '<li>专题列表第<span>' . $ii . '</span>页 <a href="' . $specialurl . '" target="_blank">' . $specialurl . '</a> 操作成功</li>';
     }
     echo '</div><script>document.getElementById("show").style.display="none";</script>';
     if ($go) {
         $this->assign("jumpUrl", C('cms_admin') . '?s=Admin/Html/Maps/go/' . $go);
         $this->success('专题列表已经生成完毕,正在准备生成网站地图,请稍等!');
     } else {
         $this->assign("jumpUrl", C('cms_admin') . '?s=Admin/Html/Show');
         $this->success('恭喜您,专题列表页已经生成完毕!');
     }
 }