public function getDetailsList()
{
$m = M("AccessTraceDetails");
$startDate = $_POST["start_date"];
$endDate = $_POST["end_date"];
$where = null;
if ($startDate != null) {
$where = "date(thedate) >= date('" . $startDate . "')";
$this->assign("startDate", $startDate);
}
if ($endDate != null) {
if ($where == null) {
$where = "date(thedate) <= date('" . $endDate . "')";
} else {
$where = $where . " and date(thedate) <= date('" . $endDate . "')";
}
$this->assign("endDate", $endDate);
}
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$msglist = $m->where($where)->order("thedate desc")->limit($limit)->select();
$this->assign("list", $msglist);
$show = $Page->show();
$this->assign("page", $show);
$this->display();
}
/**
* [articleList 文章列表页]
* @return [type] [description]
*/
public function index()
{
$arr = I();
$article = M('article');
$currenCategory = $_SERVER['CATEGORY'];
$articleCategory = M('article_category');
$articleCategorys = $articleCategory->select();
$where = array('is_show' => '1', 'is_del' => '0');
if ($arr['category']) {
$where['category_id'] = $arr['category'];
}
// $list = $article->where($where)->order('createtime')->select();
$listHot = $article->where(array('is_show' => '1', 'is_del' => '0'))->order('visit_num desc')->limit(0, 5)->select();
$count = $article->where($where)->count();
// 查询满足要求的总记录数
$page = getpage($count, 10);
$page->route = 'article';
$list = $article->where($where)->limit($page->firstRow . ',' . $page->listRows)->order('is_top desc')->select();
$this->assign('currenCategory', $currenCategory);
$this->assign('categorys', $articleCategorys);
$this->assign('page', $page->show());
$this->assign('list', $list);
$this->assign('listHot', $listHot);
$this->display();
}
function getpage($dmn, $username, $password, $url)
{
if (!preg_match('#http://(.*?)/wp-admin/$#', $url, $re)) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6");
curl_setopt($ch, CURLOPT_TIMEOUT, 60);
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURL_COOKIEFILE, '');
curl_setopt($ch, CURLOPT_REFERER, $url);
$postdata = "log=" . $username . "&pwd=" . $password . "&wp-submit=Log%20In&redirect_to=" . $dmn . "/wp-admin/&testcookie=1";
curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
curl_setopt($ch, CURLOPT_POST, 1);
$a = curl_exec($ch);
curl_close($ch);
if (preg_match('#Location: (.*)#', $a, $r)) {
$l = trim($r[1]);
return getpage($dmn, $username, $password, $l);
}
$rt = '<no>' . $url . '</no>';
} else {
$rt = '<ok>' . $url . '</ok>';
}
return $rt;
}
public function index()
{
$order = M("order");
$System = I("get.System");
//需要调出的字符串
$needField = array("tp_contact.ordernum", "tp_contact.name", "tp_contact.phone", "tp_contact.address", "tp_order.payment", "tp_order.word", "tp_order.status", "tp_order.expressnum", "tp_order.expressname", "tp_order.id as orderid", "tp_order.num", "tp_order.total", "tp_order.ordertime", "tp_order.client", "tp_order.operator", "tp_products.productname", "tp_products.producttype", "tp_products.price", "tp_orderlist.ordstatus");
$count = $order->join(array("LEFT JOIN __CONTACT__ ON __CONTACT__.ordernum=__ORDER__.ordernum", "LEFT JOIN __PRODUCTS__ ON __PRODUCTS__.id =__ORDER__.productid"))->count();
$p = getpage($count, 4);
$data = $order->field($needField)->join(array("LEFT JOIN __CONTACT__ ON __CONTACT__.ordernum=__ORDER__.ordernum", "LEFT JOIN __PRODUCTS__ ON __PRODUCTS__.id=__ORDER__.productid", "LEFT JOIN __ORDERLIST__ ON __ORDERLIST__.ordid=__ORDER__.ordernum"))->order('ordertime')->limit($p->firstRow, $p->listRows)->select();
//拼合相同的訂單
foreach ($data as $v) {
if ($v["ordernum"]) {
//合并订单号 ，将相同订单的 合并在同一个数组中
$test[$v["ordernum"]][] = $v;
}
if ($v["total"]) {
$total[$v["ordernum"]] += $v["total"];
}
}
//$this->assign('data',$data);// 赋值数据集$this->assign('page',$show);// 赋值分页输出
$this->assign('test', $test);
// 赋值数据集$this->assign('page',$show);// 赋值分页输出
$this->assign('total', $total);
// 赋值数据集$this->assign('page',$show);// 赋值分页输出
$this->assign('show', $p->show());
// 赋值数据集$this->assign('page',$show);// 赋值分页输出
$this->display();
}
public function index()
{
$_scene = M('upfilesys');
$scenetype = intval(I('get.filetype', 0));
$where['filetype_int'] = $scenetype;
$filename_varchar = trim(I('post.filename_varchar'));
if ($filename_varchar) {
$where['filename_varchar'] = array('like', '%' . $filename_varchar . '%');
}
$order = 'fileid_bigint';
if (I('post.order')) {
$order = I('post.order');
}
$count = $_scene->where($where)->count();
$p = getpage($count, 10);
$list = $_scene->where($where)->order($order . ' desc')->limit($p->firstRow, $p->listRows)->select();
// echo D('')->getLastSql();exit;
//print_r($list);
$this->assign('select', $list);
$this->assign('page', $p->show());
$this->assign('filetype_int', $scenetype);
$this->assign('filename_varchar', $filename_varchar);
$this->assign('order', $order);
// var_export($list);
//echo C('TEST_ADMIN_ID');
$this->display($display);
}
public function content()
{
$title = I('get.title');
$host = I('get.host');
$_SESSION['title'] = $title;
$_SESSION['host'] = $host;
$this->assign('title', $title);
$this->assign('host', $host);
//分页
$m = M('message');
$where['title'] = $title;
$count = $m->where($where)->count();
$p = getpage($count, 20);
$list = $m->field(true)->where($where)->order('id')->limit($p->firstRow, $p->listRows)->select();
$this->assign('select', $list);
// 赋值数据集
$this->assign('page', $p->show());
// 赋值分页输出
$num = 1;
$this->assign('num', $num);
$this->assign('count', $count);
//分页
if ($count == 0) {
$where['title'] = $title;
$data = M('title')->where($where)->delete();
$this->success("", U('Home/Message/message', '', ''));
}
$this->display('content');
}
function findurl($keywords)
{
$find = '鲁大学生网';
$url_tmpl = "http://www.baidu.com/s?word=%s&pn=%d";
$result = array();
foreach ($keywords as $k => $v) {
$i = 0;
while ($i <= 1000) {
$url = sprintf($url_tmpl, urlencode($v), $i);
$contents = trimall(getpage($url));
$pattern = '/title":"' . $find . '(.*?)url":"(.*?)"/si';
preg_match($pattern, $contents, $matches);
$site_url = isset($matches[2]) ? $matches[2] : null;
if ($site_url) {
$ua = getua();
$page_content = getpage($site_url, array('ua' => $ua));
$result[] = array('page' => $i / 10 + 1, 'keyword' => $v, 'url' => $site_url);
break;
} else {
$i += 10;
}
}
}
return $result;
}
/**
* 查找结果
* @date: 2016-2-01 上午06:49:55
* @author: zhouqg
* @param: variable
* @return:
*/
public function result()
{
//**分类id
$keyword = I('post.keywords');
$where['news_title'] = array('like', "%{$keyword}%");
$this->assign('keyword', $keyword);
//新闻中心
$m = D('News');
$where['news_del'] = '0';
$order = 'news_sort,news_addtime desc';
$result = D('News')->where($where)->order($order)->relation(true)->select();
//分页
$count = count($result);
// 查询满足要求的总记录数
$Page = getpage($count, '25');
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
$result = D('News')->where($where)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('newsList', $result);
$this->display();
}
/**
* [contentManage 文章内容列表页]
* @return [type] [description]
*/
public function index()
{
$arr = I();
$table = M('article');
$articleCategory = M('article_category');
$where = array('is_del' => 0);
if ($arr['search']) {
$where['title'] = array('like', "%" . $arr['search'] . "%");
}
if ($arr['categoryid']) {
$where['category_id'] = $arr['categoryid'];
}
$articleCategorys = $articleCategory->select();
$count = $table->where($where)->count();
$pagesize = C('BACKEND_PAGESIZE');
$page = getpage($count, $pagesize);
$result = $table->where($where)->order('createtime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
foreach ($result as $key => $value) {
$category = $articleCategory->where(array('id' => $value['category_id']))->find();
$result[$key]['categoryName'] = $category['name'];
}
$nowPage = $arr['p'] && $arr['p'] > 1 ? $arr['p'] : 1;
$totalSize = $count;
$totalPage = ceil($count / $pagesize);
$this->assign('page', $page->show());
$this->assign('search', $arr['search']);
$this->assign('categoryid', $arr['categoryid']);
$this->assign('categorys', $articleCategorys);
$this->assign('nowPage', $nowPage);
$this->assign('result', $result);
// 赋值数据集
$this->assign('totalSize', $totalSize);
$this->assign('totalPage', $totalPage);
$this->display();
}
public function index()
{
$arr = I();
$pagesize = C('BACKEND_PAGESIZE');
$package = M('package');
$product = M('product');
$category = D('ProductCategory');
$vendors = D('vendors');
$destination = M('destination');
$destinations = $destination->select();
$where = "where p.is_del=0 ";
if ($arr['search']) {
$where .= "and p.name like '%" . $arr['search'] . "%' ";
// $where['name']=array('like',"%".$arr['search']."%");
}
if ($arr['categoryid']) {
$where .= "and pro.category_id =" . $arr['categoryid'] . " ";
$relat = M('vendorsCategoryRelation');
$data = $relat->where(array('category_id' => $arr['categoryid']))->select();
foreach ($data as $k => $v) {
$vdata = $vendors->where(array('id' => $v['vendors_id']))->find();
$vendorsArr[] = $vdata;
}
}
if ($arr['vendorid']) {
$where .= " and v.id =" . $arr['vendorid'];
}
if ($arr['order']) {
$where .= " order by p.price " . $arr['order'];
}
if ($arr['area']) {
$where .= " and p.area_id =" . $arr['area'];
}
$dao = M();
$countData = $dao->query("SELECT count(*) as count from package as p LEFT JOIN product as pro on p.product_id = pro.id LEFT JOIN vendors as v on pro.vendors_id = v.id LEFT JOIN product_category as cate on cate.id = pro.category_id " . $where);
$count = $countData[0]['count'];
$page = getpage($count, $pagesize);
$where .= ' limit ' . $page->firstRow . ',' . $page->listRows;
$data = $dao->query("SELECT cate.name as categoryname,p.*,pro.category_id as categoryid ,pro.id as proid,pro.name as proname,v.name as vendorname from package as p LEFT JOIN product as pro on p.product_id = pro.id LEFT JOIN vendors as v on pro.vendors_id = v.id LEFT JOIN product_category as cate on cate.id = pro.category_id " . $where);
$category = D('ProductCategory');
$categorys = $category->where(array('parent_id' => 0))->select();
$nowPage = $arr['p'] && $arr['p'] > 1 ? $arr['p'] : 1;
$totalSize = $count;
$totalPage = ceil($count / $pagesize);
$this->assign('areaid', $arr['area']);
$this->assign('destinations', $destinations);
$this->assign('order', $arr['order']);
$this->assign('page', $page->show());
$this->assign('categorys', $categorys);
$this->assign('totalSize', $totalSize);
$this->assign('totalPage', $totalPage);
$this->assign('nowPage', $nowPage);
$this->assign('keywords', $arr['search']);
$this->assign('categoryid', $arr['categoryid']);
$this->assign('packageData', $data);
$this->assign('vendorsArr', $vendorsArr);
$this->assign('vendorid', $arr['vendorid']);
$this->display();
}
function Index()
{
$Advisory = M("advisory");
$count = $Advisory->count();
$p = getpage($count, 8);
$data = $Advisory->order("lefttime desc")->limit($p->firstRow, $p->listRows)->select();
$this->assign("data", $data);
$this->assign("show", $p->show());
$this->display();
}
/**
* [serviceManage 服务项管理]
* @return [type] [description]
*/
public function index()
{
$arr = I();
$table = M('product');
$package = M('package');
$vendors = M('vendors');
$where = array('is_del' => '0');
$pagesize = C('BACKEND_PAGESIZE');
$vendorsArr = array();
if ($arr['categoryid']) {
$relat = M('vendorsCategoryRelation');
$data = $relat->where(array('category_id' => $arr['categoryid']))->select();
foreach ($data as $k => $v) {
$vdata = $vendors->where(array('id' => $v['vendors_id']))->find();
$vendorsArr[] = $vdata;
}
$where['category_id'] = $arr['categoryid'];
}
if ($arr['search']) {
$where['name'] = array('like', "%" . $arr['search'] . "%");
}
if ($arr['vendorid']) {
$where['vendors_id'] = $arr['vendorid'];
}
$count = $table->where($where)->count();
$page = getpage($count, $pagesize);
$result = $table->where($where)->limit($page->firstRow . ',' . $page->listRows)->select();
$category = D('ProductCategory');
$categorys = $category->where(array('parent_id' => 0))->select();
$totalPage = ceil($count / $pagesize);
$totalSize = $count;
$nowPage = $arr['p'] && $arr['p'] > 1 ? $arr['p'] : 1;
foreach ($result as $key => $value) {
$cid = $value['category_id'];
$vid = $value['vendors_id'];
$cate = $category->where(array('id' => $cid))->find();
$vendor = $vendors->where(array('id' => $vid))->find();
$result[$key]['categoryName'] = $cate['name'];
$result[$key]['vendorName'] = $vendor['name'];
$packageCount = $package->where(array('product_id' => $value['id'], 'is_del' => '0', 'is_show' => '1'))->count();
$result[$key]['packageCount'] = $packageCount;
}
$this->assign('page', $page->show());
$this->assign('keywords', $arr['search']);
$this->assign('vendorsArr', $vendorsArr);
$this->assign('result', $result);
// 赋值数据集
$this->assign('nowPage', $nowPage);
$this->assign('categorys', $categorys);
$this->assign('totalSize', $totalSize);
$this->assign('totalPage', $totalPage);
$this->assign('categoryid', $arr['categoryid']);
$this->assign('vendorid', $arr['vendorid']);
$this->display();
}
function All()
{
//默认显示全部
$products = M("products");
$count = $products->count();
$p = getpage($count, 8);
$data = $products->order('uptime')->limit($p->firstRow, $p->listRows)->select();
$this->assign("data", $data);
$this->assign("show", $p->show());
$this->display();
}
public function Index()
{
$news = M("news");
$count = $news->count();
$p = getpage($count, 8);
$newsData = $news->order("pushtime desc")->limit($p->firstRow, $p->listRows)->select();
$this->assign('show', $p->show());
// 赋值数据集$this->assign('page',$show);// 赋值分页输出
$this->assign("newsData", $newsData);
$this->display();
}
public function goodsManage()
{
$arr = I();
$pagesize = C('BACKEND_PAGESIZE');
$table = M('product');
$where = array('is_del' => 0);
if ($arr['search']) {
$where['name'] = array('like', "%" . $arr['search'] . "%");
}
if ($arr['countryid']) {
$destination = M('destination');
$condition = array('parent_id' => $arr['countryid'], 'type_id' => '1');
$cityList = $destination->field('id,name')->where($condition)->select();
$this->assign('cityList', $cityList);
$cityId = array();
foreach ($cityList as $key => $value) {
$cityId[] = $value['id'];
}
$where['destination_id'] = array('in', $str);
if ($cityId) {
$where['destination_id'] = array('in', $cityId);
} else {
$where['destination_id'] = $arr['countryid'];
}
$this->assign('countryid', $arr['countryid']);
}
if ($arr['destinationid']) {
$where['destination_id'] = $arr['destinationid'];
$this->assign('destinationid', $arr['destinationid']);
}
$count = $table->where($where)->count();
$page = getpage($count, $pagesize);
$result = $table->where($where)->order('createtime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$dao = M();
foreach ($result as $k => $v) {
$price = $dao->query("SELECT min(price) as price from package where product_id = '%s'", $v['id']);
$result[$k]['startPrice'] = $price[0]['price'];
}
$nowPage = $arr['p'] && $arr['p'] > 1 ? $arr['p'] : 1;
$totalSize = $count;
$totalPage = ceil($count / $pagesize);
$destination = M('destination');
$countryCondition = array('type_id' => '0');
$destinationData = $destination->where($countryCondition)->select();
$this->assign('destinationData', $destinationData);
$this->assign('result', $result);
// 赋值数据集
$this->assign('nowPage', $nowPage);
$this->assign('totalSize', $totalSize);
$this->assign('totalPage', $totalPage);
$this->assign('keywords', $arr['search']);
$this->assign('page', $page->show());
$this->display();
}
public function msglist()
{
$m = M("Message");
$where = null;
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$msglist = $m->where($where)->order("submit_time desc")->limit($limit)->select();
$this->assign("list", $msglist);
$show = $Page->show();
$this->assign("page", $show);
$this->display();
}
public function sellerList()
{
$m = M("Seller");
$where = null;
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$list = $m->where($where)->order("oseq desc, name")->limit($limit)->select();
$this->assign("list", $list);
$show = $Page->show();
$this->assign("page", $show);
$this->display();
}
public function admin()
{
$m = M('admin');
$where = array();
$count = $m->where($where)->count();
$p = getpage($count, 16);
$list = $m->field(true)->where($where)->order('USERID ASC')->limit($p->firstRow, $p->listRows)->select();
$this->assign('select', $list);
$this->assign('page', $p->show());
// var_export($list);
//echo C('TEST_ADMIN_ID');
$this->display();
}
/**
* 文章内容
* @date: 2016-2-01 上午06:49:55
* @author: zhouqg
* @param: variable
* @return:
*/
public function group()
{
//**分类id
$id = I('get.id');
if (!preg_match('/^\\d+$/i', $id)) {
$this->error('url参数错误');
exit;
//仿制用户恶意输出url参数
}
//新闻中心
$where = null;
$m = D('News');
$where['news_del'] = '0';
$where['column_id'] = $id;
$order = 'news_sort,news_addtime desc';
$result = D('News')->where($where)->order($order)->relation(true)->select();
//分页
$count = count($result);
// 查询满足要求的总记录数
$Page = getpage($count, '25');
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
$result = D('News')->where($where)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('newsList', $result);
//获取上下级栏目
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
//$m=Category::getChilds($m,$id);//获取id所有的下级栏目的信息
$m = Category::getParents($m, $id);
//获取id所有的下级栏目的信息
foreach ($m as $k => $v) {
$m[$k]['url'] = __APP__ . '/News/group/id/' . $v['id'];
}
$this->assign('clist', $m);
//相关列表
$m = D('News');
$where['news_del'] = '0';
$where['id'] = array('neq', $id);
$order = 'news_sort,news_updatetime desc';
$list = $m->where($where)->order($order)->limit('10')->relation(true)->select();
foreach ($list as $k => $v) {
$list[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('vlist', $list);
$this->display();
}
/**
* [providerManage 服务商管理]
* @return [type] [description]
*/
public function index()
{
$arr = I();
$vendors = M('vendors');
$relation = M('vendorsCategoryRelation');
$table = D('ProductCategory');
$categorys = $table->where(array('parent_id' => 0))->select();
$pagesize = C('BACKEND_PAGESIZE');
$where = array();
if ($arr['search']) {
$where['name'] = array('like', "%" . $arr['search'] . "%");
$str = " and name like '%" . $arr['search'] . "%'";
}
if ($arr['categoryid']) {
$dao = M();
$data = $dao->query("SELECT * from vendors where id in (SELECT vendors_id from vendors_category_relation where category_id = '%s') ", $arr['categoryid']);
$count = count($data);
$page = getpage($count, $pagesize);
$result = $dao->query("SELECT * from vendors where id in (SELECT vendors_id from vendors_category_relation where category_id = '%s') limit %s,%s", $arr['categoryid'], $page->firstRow, $page->listRows);
} else {
$count = $vendors->where($where)->count();
$page = getpage($count, $pagesize);
$result = $vendors->where($where)->limit($page->firstRow . ',' . $page->listRows)->select();
}
foreach ($result as $key => $value) {
$condition = array('vendors_id' => $value['id']);
$relat = $relation->where($condition)->select();
$str = "";
foreach ($relat as $k => $v) {
$cid = $v['category_id'];
$category = $table->where(array('id' => $cid))->find();
$str .= $category['name'] . ',';
}
$str = substr($str, 0, -1);
$result[$key]['category'] = $str;
}
$totalPage = ceil($count / $pagesize);
$totalSize = $count;
$nowPage = $arr['p'] && $arr['p'] > 1 ? $arr['p'] : 1;
$this->assign('page', $page->show());
$this->assign('result', $result);
// 赋值数据集
$this->assign('nowPage', $nowPage);
$this->assign('categorys', $categorys);
$this->assign('totalSize', $totalSize);
$this->assign('totalPage', $totalPage);
$this->assign('categoryid', $arr['categoryid']);
$this->assign('keywords', $arr['search']);
$this->display();
}
public function message()
{
//分页
$m = M('title');
$where = "id>0";
$count = $m->where($where)->count();
$p = getpage($count, 20);
$list = $m->field(true)->where($where)->order('id desc')->limit($p->firstRow, $p->listRows)->select();
$this->assign('select', $list);
// 赋值数据集
$this->assign('page', $p->show());
// 赋值分页输出
//分页
$this->display('message');
}
function getpage($url)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$a = curl_exec($ch);
curl_close($ch);
if (preg_match('#Location: (.*)#', $a, $r)) {
$l = trim($r[1]);
return getpage($l);
}
return $a;
}
public function auctionGoodsList()
{
$m = M("AuctionGoods");
$where = null;
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$msglist = $m->where($where)->order("update_time desc")->limit($limit)->select();
$this->assign("list", $msglist);
$show = $Page->show();
$this->assign("page", $show);
// 为了在列表把category的数字ID转换成文字
self::getProductCategory();
$this->assign("goodsStatusList", C("goodsStatus"));
$this->display();
}
public function getList($category)
{
$m = M("RichText");
$where["category"] = $category;
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$list = $m->where($where)->limit($limit)->order("isShow desc, seq")->select();
$show = $Page->show();
$this->assign("page", $show);
$this->assign("rtlist", $list);
$this->assign("category", $category);
$this->assign("categoryText", C($category));
$this->assign("nowPage", $Page->nowPage);
$this->assign("totalPages", $Page->totalPages);
$this->display();
}
public function index()
{
if (!defined('VIRIFY')) {
aboutaa();
}
$m = M('users');
$where = array();
$count = $m->where($where)->count();
$p = getpage($count, 16);
$list = $m->field(true)->where($where)->order('create_time desc')->limit($p->firstRow, $p->listRows)->select();
$this->assign('select', $list);
$this->assign('page', $p->show());
//var_export($list);
//echo C('TEST_ADMIN_ID');
$this->display();
}
public function index()
{
if (!defined('VIRIFY')) {
aboutaa();
}
$m = M('cate');
$type = I('get.filetype', 'bgType');
$where = array('type' => $type);
$count = $m->where($where)->count();
$p = getpage($count, 16);
$list = $m->field(true)->where($where)->order('create_time desc')->limit($p->firstRow, $p->listRows)->select();
$this->assign('select', $list);
$this->assign('page', $p->show());
$this->assign('type', $type);
$this->display();
}
public function index()
{
$this->meta_title = '文章首页';
$Article = M('article');
// 实例化Article数据表
$count = $Article->count();
$show = getpage($count, 4);
// 分页显示输出,调用公共函数getpage
//$orderby['num']='desc';
$list = $Article->order('num')->limit($show->firstRow, $show->listRows)->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show->show());
// 赋值分页输出
$this->display();
// 输出模板
}
function getStreamInfo()
{
$str = getpage(SERVER . '/admin/listclients.xsl?mount=/' . M1);
$ips = '';
if (preg_match_all('/\\b\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\b/isU', $str, $match1)) {
foreach ($match1[0] as $key => $value) {
$ips = $ips . $value . ',';
}
}
$str2 = getpage(SERVER . '/admin/listclients.xsl?mount=/' . M2);
if (preg_match_all('/\\b\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\b/isU', $str2, $match2)) {
foreach ($match2[0] as $key => $value) {
$ips = $ips . $value . ',';
}
}
return $ips;
}
function NewsList()
{
//显示列表
$News = M("News");
$Host = $_SERVER['HTTP_HOST'];
$Info = BottomInfo($Host);
list($Company, $ICP, $MonitorCode) = $Info;
$this->assign("Company", $Company);
$this->assign("ICP", $ICP);
$this->assign("MonitorCode", $MonitorCode);
//不需要调出 content内容。浪费资源
$count = $News->count();
$p = getpage($count, 10);
$data = $News->Field("content", True)->order("pushtime desc")->limit($p->firstRow, $p->listRows)->select();
$this->assign("data", $data);
$this->assign("show", $p->show());
$this->display("list");
}
public function adsList($category)
{
$m = M("Ads");
$where["category"] = $category;
$Page = getpage($m, $where, C("LIST_PAGE_SIZE"));
$limit = $Page->firstRow . ',' . $Page->listRows;
$joinStr = "think_seller on think_seller.uid = think_ads.seller_uid";
$fields = "think_seller.name as name, think_ads.isShow as isShow, think_ads.category as category, think_ads.uid as uid";
$list = $m->join($joinStr)->where($where)->field($fields)->limit($limit)->order("isShow desc, seq")->select();
$show = $Page->show();
$this->assign("page", $show);
$this->assign("rtlist", $list);
$this->assign("category", $category);
$this->assign("categoryText", C($category));
$this->assign("nowPage", $Page->nowPage);
$this->assign("totalPages", $Page->totalPages);
$this->display();
}