/** * 影片重名检测 * @param int $len * @return array */ function RepeatCheck($Get) { $len = $Get['len']; //先查询$len内不同影片的title $arr = $this->VideoDB->field('title')->Group("Left(title,{$len})")->Having('count(*)>1')->select(); foreach ($arr as $key => $val) { $arrTitle[] .= $val['title']; } //$where['status']=array('neq',-1); $where = $this->SearchCon($Get); $where["left(title, {$len})"] = array('in', $arrTitle); $video_count = $this->VideoDB->where($where)->count('id'); $video_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $video_page = get_cms_page_max($video_count, C('web_admin_pagenum'), $video_page); $video_url = U('Admin-Datacheck/VideoCheck', array('check_sub' => 'ok', 'len' => urlencode($len), 'p' => ''), false, false); $pagelist = get_cms_page($video_count, C('web_admin_pagenum'), $video_page, $video_url, '部影片'); $_SESSION['video_repurl'] = $video_url . $video_page; //order by $video['type'] = !empty($_GET['type']) ? $_GET['type'] : 'title'; $video['order'] = !empty($_GET['order']) ? $_GET['order'] : 'desc'; $order = $video["type"] . ' ' . $video['order']; $VResult = $this->VideoDB->field('id,title,cid,serial,addtime,hits,stars,status,picurl')->where($where)->order($order)->limit(C('web_admin_pagenum'))->page($video_page)->select(); foreach ($VResult as $key => $val) { $VResult[$key]['cname'] = get_channel_name($VResult[$key]['cid']); $VResult[$key]['channelurl'] = U('Admin-Video/Show', array('cid' => $VResult[$key]['cid']), false, false); $VResult[$key]['videourl'] = get_read_url('video', $VResult[$key]['id'], $VResult[$key]['cid']); $VResult[$key]['stararr'] = get_star_arr($VResult[$key]['stars']); } return array('vresult' => $VResult, 'pagelist' => $pagelist, 'len' => $len, 'order' => $order, 'cid' => $Get['cid']); }
public function show() { $request['wd'] = urldecode(trim($_REQUEST['wd'])); $request['status'] = intval($_GET['status']); if (!empty($request['wd'])) { $where[C('db_prefix') . 'comment.ip'] = array('like', '%' . $request["wd"] . '%'); $where[C('db_prefix') . 'comment.content'] = array('like', '%' . $request["wd"] . '%'); $where[C('db_prefix') . 'user.username'] = array('like', '%' . $request["wd"] . '%'); $where[C('db_prefix') . 'video.title'] = array('like', '%' . $request["wd"] . '%'); $where['_logic'] = 'or'; } if ($request['status']) { $where[C('db_prefix') . 'comment.status'] = 0; } $join = C('db_prefix') . 'user on ' . C('db_prefix') . 'comment.uid = ' . C('db_prefix') . 'user.id'; //查询影片名称 $join_video = C('db_prefix') . 'video on ' . C('db_prefix') . 'comment.did = ' . C('db_prefix') . 'video.id'; $field = C('db_prefix') . 'comment.*,' . C('db_prefix') . 'user.id as userid,' . C('db_prefix') . 'user.username,' . C('db_prefix') . 'video.title'; $order = C('db_prefix') . 'comment.id desc'; $cm_count = $this->CommDB->field($field)->where($where)->join($join)->join($join_video)->count(); $cm_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $cm_page = get_cms_page_max($cm_count, C('web_admin_pagenum'), $cm_page); $cm_url = U('Admin-Comment/Show', array('status' => $request['status'], 'wd' => urlencode($request['wd']), 'p' => ''), false, false); $listpages = get_cms_page($cm_count, C('web_admin_pagenum'), $cm_page, $cm_url, '条评论'); $list_comment = $this->CommDB->field($field)->where($where)->join($join)->join($join_video)->order($order)->limit(C('web_admin_pagenum'))->page($cm_page)->select(); // $_SESSION['comment_reurl'] = $cm_url . $cm_page; $this->assign($listpages); $this->assign('wd', $request['wd']); $this->assign('list_comment', $list_comment); $this->display('./views/admin/comment_show.html'); }
public function mana() { $status = $_REQUEST['status']; if ($status) { $where['status'] = $status; } if (isset($_GET['cid'])) { $where['cid'] = $_GET['cid']; } $special['type'] = !empty($_GET['type']) ? $_GET['type'] : C('web_admin_ordertype'); $special['order'] = !empty($_GET['order']) ? $_GET['order'] : 'desc'; $order = $special['type'] . ' ' . $special['order']; //分页开始 $special_count = $this->SelfDB->where($where)->count('id'); $special_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $special_page = get_cms_page_max($special_count, C('web_admin_pagenum'), $special_page); $special_url = U('Admin-Self/Mana', array('status' => $status, 'type' => $video['type'], 'order' => $video['order'], 'p' => ''), false, false); $listpages = get_cms_page($special_count, C('web_admin_pagenum'), $special_page, $special_url, '篇专辑'); $list = $this->SelfDB->where($where)->order('id DESC')->limit(C('web_admin_pagenum'))->page($special_page)->select(); //var_dump(C('web_admin_pagenum')); $_SESSION['special_reurl'] = $special_url . $special_page; foreach ($list as $key => $val) { $list[$key]['countvideo'] = !empty($val['mids']) ? count(explode(',', $val['mids'])) : 0; $list[$key]['countinfo'] = !empty($val['aids']) ? count(explode(',', $val['aids'])) : 0; $list[$key]['specialurl'] = get_read_url('special', $list[$key]['id']); $list[$key]['cname'] = $this->getType($list[$key]['cid']); } $this->assign($listpages); $this->assign('order', $order); $this->assign('list_special', $list); $this->assign('list_type', $this->getType(NULL)); //var_dump($this->getType(NULL)); $this->display('views/admin/self_show.html'); }
public function replaceKey() { $keyword = trim($_REQUEST['keyword']); if ($keyword) { $where['name'] = $keyword; } $this->weiDB = M('replacekeys'); $treecount = $this->weiDB->where($where)->count('id'); $link_page = !empty($_GET['p']) ? $_GET['p'] : 1; $link_url = U('Admin-Wei/replaceKey', array('keyword' => urlencode($keyword), 'p' => ''), false, false); $listpages = get_cms_page($treecount, C('web_admin_pagenum'), $link_page, $link_url, '条替换关键词'); $list = $this->weiDB->where($where)->limit(C('web_admin_pagenum'))->page($link_page)->select(); if (empty($list)) { // $this->error('没有查询到您所筛选的内链关键词!'); } $this->assign('keyword', $keyword); $this->assign($listpages); $this->assign('tree', $list); $this->assign('treecount', $treecount); $this->display('./views/admin/replacekey_show.html'); }
public function show() { $join = C('db_prefix') . 'video on ' . C('db_prefix') . 'userview.did = ' . C('db_prefix') . 'video.id'; $join2 = C('db_prefix') . 'user on ' . C('db_prefix') . 'userview.uid = ' . C('db_prefix') . 'user.id'; $field = C('db_prefix') . 'userview.*,' . C('db_prefix') . 'video.id as videoid,' . C('db_prefix') . 'video.title,' . C('db_prefix') . 'user.username'; $order = C('db_prefix') . 'video.id desc'; // $user_count = $this->UserVDB->field($field)->join($join)->join($join2)->count(); $user_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $totalPages = ceil($user_count / C('web_admin_pagenum')); if ($user_page > $totalPages) { $user_page = $totalPages; } $user_url = U('Admin-Userview/Show', array('p' => ''), false, false); $listpages = get_cms_page($user_count, C('web_admin_pagenum'), $user_page, $user_url, '条记录'); // $list_view = $this->UserVDB->field($field)->join($join)->join($join2)->order($order)->limit(C('web_admin_pagenum'))->page($user_page)->select(); $this->assign($listpages); $this->assign('list_view', $list_view); $this->assign('list_channel_video', F('_gxcms/channelvideo')); $this->display('./views/admin/userview_show.html'); }
public function show() { $keyword = trim($_REQUEST['keyword']); if ($keyword) { $where['username'] = array('like', '%' . $keyword . '%'); $where['binary email'] = array('like', '%' . $keyword . '%'); $where['_logic'] = 'or'; } $user_count = $this->UserDB->where($where)->count('id'); $user_page = !empty($_GET['p']) ? $_GET['p'] : 1; $user_url = U('Admin-User/Show', array('keyword' => urlencode($keyword), 'p' => ''), false, false); $listpages = get_cms_page($user_count, C('web_admin_pagenum'), $user_page, $user_url, '位用户'); // $list = $this->UserDB->where($where)->order('jointime desc')->limit(C('web_admin_pagenum'))->page($user_page)->select(); if (empty($list)) { $this->error('没有查询到您所筛选的用户!'); } $this->assign('keyword', $keyword); $this->assign($listpages); $this->assign('list_user', $list); $this->display('./views/admin/user_show.html'); }
public function show() { $request['eid'] = $_REQUEST['eid']; $request['wd'] = urldecode(trim($_REQUEST['wd'])); $request['status'] = intval($_GET['status']); if ($request['eid']) { $where[C('db_prefix') . 'gbook.errid'] = array('gt', 0); $request['showname'] = '报错'; } else { $where[C('db_prefix') . 'gbook.errid'] = array('eq', 0); $request['showname'] = '留言'; } if ($request['status']) { $where[C('db_prefix') . 'gbook.status'] = array('eq', 0); } if (!empty($request['wd'])) { $search[C('db_prefix') . 'gbook.ip'] = array('like', '%' . $request['wd'] . '%'); $search[C('db_prefix') . 'gbook.content'] = array('like', '%' . $request['wd'] . '%'); $search[C('db_prefix') . 'user.username'] = array('like', '%' . $request['wd'] . '%'); $search['_logic'] = 'or'; $where['_complex'] = $search; } $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'; $order = C('db_prefix') . 'gbook.id desc'; $gb_count = $this->GbookDB->field($field)->where($where)->join($join)->count(); $gb_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $gb_page = get_cms_page_max($gb_count, C('web_admin_pagenum'), $gb_page); $gb_url = U('Admin-Guestbook/Show', array('status' => $request['status'], 'eid' => $request['eid'], 'wd' => urlencode($request['wd']), 'p' => ''), false, false); $listpages = get_cms_page($gb_count, C('web_admin_pagenum'), $gb_page, $gb_url, '条留言'); $list_gbook = $this->GbookDB->field($field)->where($where)->join($join)->order($order)->limit(C('web_admin_pagenum'))->page($gb_page)->select(); // $_SESSION['guestbook_reurl'] = $gb_url . $gb_page; $this->assign($listpages); $this->assign($request); $this->assign('list_gbook', $list_gbook); $this->display('./views/admin/guestbook_show.html'); }
public function showspecial() { $specialid = intval($_REQUEST['id']); $keyword = urldecode(trim($_REQUEST['keyword'])); if ($keyword) { $search['title'] = array('like', '%' . $keyword . '%'); $search['intro'] = array('like', '%' . $keyword . '%'); $search['actor'] = array('like', '%' . $keyword . '%'); $map = $search; $map['_logic'] = 'or'; $where['_complex'] = $map; } $where['status'] = 1; $video_count = $this->VideoDB->where($where)->count('id'); $video_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $video_url = U('Admin-Video/Showspecial', array('id' => $specialid, 'keyword' => urlencode($keyword), 'p' => ''), false, false); $listpages = get_cms_page($video_count, C('web_admin_pagenum'), $video_page, $video_url, '部影片'); $list = $this->VideoDB->field('id,cid,title,intro,actor')->where($where)->limit(C('web_admin_pagenum'))->page($video_page)->order('addtime desc')->select(); $this->assign($listpages); $this->assign('list_video', $list); $this->assign('keyword', $keyword); $this->display('views/admin/special_video.html'); }
public function comment() { $arr = $this->checklogin(); $where['uid'] = $arr['id']; $rs = M('Comment'); $comment_count = $rs->where($where)->count('id'); $comment_page = !empty($_GET['p']) ? $_GET['p'] : 1; $comment_page = intval($comment_page); $comment_url = U('User/Comment', array('p' => ''), false, false); $listpages = get_cms_page($comment_count, C('user_page_cm'), $comment_page, $comment_url, '条评论', false); $listcomment = $rs->where($where)->order('addtime desc,id desc')->limit(C('user_page_cm'))->page($comment_page)->select(); $this->assign('pages', $listpages['listpages']); $this->assign('list_comment', $listcomment); $this->assign('count_comment', $comment_count); $this->display('./views/user/comment.html'); }
function ChannelList($where) { $count = $this->CDB->where($where)->count('id'); $page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $page = get_cms_page_max($count, C('web_admin_pagenum'), $page); $url = U('Admin-CustomCollect/AutoChannel', array('cname' => $where['cname'], 'reid' => $where['reid'], 'nid' => $where['nid'], 'p' => ''), false, false); $pagelist = get_cms_page($count, C('web_admin_pagenum'), $page, $url, '条记录'); $_SESSION['reurl'] = $url . $page; $Arr = $this->CDB->where($where)->order('id desc')->limit(C('web_admin_pagenum'))->page($page)->select(); $CacheData = F('_gxcms/channel_999'); if (!empty($CacheData)) { foreach ($CacheData as $key => $val) { $Cache[] = explode('_', $val['cname']); } $Cache = array_unique($Cache); foreach ($Cache as $k => $v) { $Cache[$k][1] = collect::get_node_name($v[1]); } } $Result = array('arr' => $Arr, 'cache' => $Cache, 'pagelist' => $pagelist, 'search' => $where); return $Result; }
/** * 采集影片入库list * @param $where */ function ColVideoList($where) { if (!empty($where['title'])) { $title = $where['title']; $where['title'] = array('like', '%' . $title . '%'); } $order = empty($_GET['order']) ? 'addtime' : $_GET['order']; $sort = empty($_GET['sort']) ? 'desc' : $_GET['sort']; $order = $order . ' ' . $sort; $where['status'] = array('neq', 0); $video_count = $this->ContDB->where($where)->count('id'); $video_page = !empty($_GET['p']) ? intval($_GET['p']) : 1; $video_page = get_cms_page_max($video_count, C('web_admin_pagenum'), $video_page); $video_url = U('Admin-CustomCollect/ColVideo', array('nid' => urlencode($where['nid']), 'title' => urlencode($title), 'p' => ''), false, false); $pagelist = get_cms_page($video_count, C('web_admin_pagenum'), $video_page, $video_url, '条记录'); $_SESSION['video_reurl'] = $video_url . $video_page; $Arr = $this->ContDB->field(C('db_prefix') . 'co_content.id,nid,name,status,url,data,addtime')->join(C('db_prefix') . 'co_node on ' . C('db_prefix') . 'co_node.id=nid')->where($where)->order(C('db_prefix') . 'co_content.' . $order)->limit(C('web_admin_pagenum'))->page($video_page)->select(); //echo $this->ContDB->getLastSql(); foreach ($Arr as $key => $val) { if (!empty($val['data'])) { $val['data'] = stripslashes($val['data']); $Arr[$key]['data'] = collect::string2array($val['data']); $Arr[$key]['base'] = $this->ConvShow($Arr[$key]['data']); } } $ArrReturn = array('video' => $Arr, 'pagelist' => $pagelist, 'order' => $order, 'title' => $title, 'nid' => $where['nid']); return $ArrReturn; }