/**
* {@inheritdoc}
*/
public function getPager(array $criteria, $page, $limit = 10, array $sort = array())
{
$parameters = array();
$query = $this->getRepository()->createQueryBuilder('t')->select('t');
if (isset($criteria['enabled'])) {
$query->andWhere('t.enabled = :enabled');
$parameters['enabled'] = (bool) $criteria['enabled'];
}
$query->setParameters($parameters);
$pager = new Pager();
$pager->setMaxPerPage($limit);
$pager->setQuery(new ProxyQuery($query));
$pager->setPage($page);
$pager->init();
return $pager;
}
}
$type = -1;
if ($_GET['type'] == '') {
$type = -1;
} else {
$type = intval($_GET['type']);
}
if ($type > -1) {
$cond .= " and type={$type}";
}
if (in_array($orderby, array('id', 'posttime', 'hits'))) {
$orderbystr = $orderby . ' desc';
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(20, $curPage, "admin.php?inc=article&action=list&k={$keyword}&channelid={$channelid}&orderby={$orderby}&page={page}");
$rows = $pager->queryRows($db, "articles", $cond, "*", $orderbystr);
$recstr = _LANG($_AL['all.totalrecords'], array($pager->recordNum));
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$keyword}" id="keyword" />
<select id="orderby"><option value="id">{$_AL['all.orderby']}</option><option value="posttime">{$_AL['all.posttime']}</option><option value="hits">{$_AL['all.hits']}</option></select>
<input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searcharticle()" />
{$recstr}</div>
\t<table class="table_1" width="100%">
\t\t<tr><td class="td_6"><a class="td_5_1a" href="admin.php?inc=article&action=add&channelid={$channelid}"><img src="images/ico_add.gif" border="0" /> {$_AL['article.add']}</a></td></tr>
\t</table>
EOT;
echo "<form id=\"articlesform\" onsubmit=\"return false;\">";
//product channel
foreach ($cache_channels as $cache_prochannel) {
if ($cache_prochannel['systemtype'] == '1') {
break;
}
}
$k = trim($_GET['k']);
$curPage = intval($_GET["page"]);
$cid = intval($_GET["cid"]);
$pagerlink = $webcore->genUrl("productlist.php?cid={$cid}&page={page}" . (empty($k) ? "" : "&k={$k}"));
$condition = "langid={$_SYS['langid']}";
$condition .= empty($k) ? "" : " and name like '%{$k}%'";
$condition .= empty($cid) ? "" : " and cid in (select id from {$db->pre}procates where id={$cid} or pid={$cid})";
$orderstr = "ordernum,id desc";
$pager = new Pager();
$pager->init(intval($cache_settings['perpagepro']), $curPage, $pagerlink);
$products = $pager->queryRows($db, "products", $condition, "id,cid,type,hits,posttime,alias,name,price1,picids,picpaths", $orderstr);
foreach ($products as $key => $product) {
$product['link'] = $webcore->genUrl("product.php?id={$product['id']}");
$product['name'] = htmlFilter($product['name']);
$product['price1'] = number_format($product['price1'], 2);
$protmppic = $webcore->getPics($product['picids'], $product['picpaths'], 0, true, true);
$product['picpath'] = $protmppic['picpath'];
$products[$key] = $product;
}
unset($protmppic);
if (!empty($cid)) {
$procate = $cache_procates[$cid];
empty($procate) && $webcore->checkViewLang('productlist', $cid);
$headtitle = empty($procate['seotitle']) ? strip_tags($procate['title']) : strip_tags(str_replace(array("\r", "\n"), array('', ''), $procate['seotitle']));
$headkeywords = empty($procate['metakeywords']) ? $headtitle : strip_tags(str_replace(array("\r", "\n"), array('', ''), $procate['metakeywords']));
}
$type = -1;
if ($_GET['type'] == '') {
$type = -1;
} else {
$type = intval($_GET['type']);
}
if ($type > -1) {
$cond .= " and type={$type}";
}
if (in_array($orderby, array('ordernum,id', 'posttime', 'hits', 'price1', 'level'))) {
$orderbystr = $orderby . ' desc';
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(15, $curPage, "admin.php?inc=products&action=list&k={$keyword}&cid={$cid}&type={$type}&orderby={$orderby}&page={page}");
$rows = $pager->queryRows($db, "products", $cond, "*", $orderbystr);
$recstr = _LANG($_AL['all.totalrecords'], array($pager->recordNum));
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
<select id="cid"><option value="0">{$_AL['products.choosecate']}</option>{$cache_procates_option}</select>
{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$keyword}" id="keyword" />
<select id="orderby"><option value="ordernum,id">{$_AL['all.orderby']}</option><option value="posttime">{$_AL['all.posttime']}</option><option value="hits">{$_AL['all.hits']}</option><option value="price1">{$_AL['products.price']}</option><option value="level">{$_AL['products.level']}</option></select>
<select id="type"><option value="-1">{$_AL['all.property']}</option><option value="1">{$_AL['products.types'][1]}</option><option value="2">{$_AL['products.types'][2]}</option></select>
<input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searchproducts()" />
{$recstr}</div>
\t<table class="table_1" width="100%">
\t\t<tr><td class="td_6"><a class="td_5_1a" href="admin.php?inc=products&action=add"><img src="images/ico_add.gif" border="0" /> {$_AL['products.add']}</a></td></tr>
\t</table>
exit($_AL['all.notlogin']);
}
$curPage = intval($_GET["page"]);
$folderid = intval($_GET["folderid"]);
if ($folderid > 0) {
setCookies("lastfolderid", $folderid);
} else {
$folderid = intval(getCookies("lastfolderid"));
}
//preview
setCookies("lastfoldertype", 2);
$pagerlink = "files.php?page={page}&folderid={$folderid}";
$condition = "folderid={$folderid}";
$orderstr = "id desc";
$pager = new Pager();
$pager->init(10, $curPage, $pagerlink);
$attachements = $pager->queryRows($db, "attachments", $condition, "*", $orderstr);
foreach ($attachements as $key => $att) {
$att['shortfilename'] = htmlFilter(cutStr($att['filename'], 12));
$att['filename'] = htmlFilter($att['filename']);
$att['uploadtime'] = getDateStr($att['uploadtime']);
$attachements[$key] = $att;
}
$folderrow = $cache_folders[$folderid];
$folderrow['title'] = htmlFilter($folderrow['title']);
print <<<EOT
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>IMAGE</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
echo <<<EOT
\t<table class="settop"><tr><td class="settop_left"><img src="../language/{$cache_langs[$_SYS['alangid']]['directory']}/flag.gif" title="{$effect_lang}" /></td><td><div id="smalltab_container"></div></td></tr></table>
\t<div class="smalltab_line"></div>
\t<div id="t1">
EOT;
$dwidth = array(0, 35, 200, 300, 100, 150, 60, 80, 150);
$cond = "langid={$_SYS['alangid']}";
$keyword = trim($_GET['k']);
$orderbystr = 'ordernum,id desc';
$keyword = str_replace("*", "%", $keyword);
if (!empty($keyword)) {
$cond .= " and (title like '%{$keyword}%' or content like '%{$keyword}%')";
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(15, $curPage, "admin.php?inc=vote&action=list&k={$keyword}&page={page}");
$rows = $pager->queryRows($db, "votes", $cond, "*", $orderbystr);
$recstr = _LANG($_AL['all.totalrecords'], array($pager->recordNum));
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$keyword}" id="keyword" />
<input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searchvotes()" />
{$recstr}</div>
\t<table class="table_1" width="100%">
\t\t<tr><td class="td_6"><a class="td_5_1a" href="admin.php?inc=vote&action=add"><img src="images/ico_add.gif" border="0" /> {$_AL['vote.add']}</a></td></tr>
\t</table>
EOT;
echo "<form id=\"votesform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
\t<div class="smalltab_line"></div>
\t<div id="t1">
EOT;
$dwidth = array(0, 30, 300, 180, 300, 80, 100);
$cond = "langid={$_SYS['alangid']}";
$keyword = trim($_GET['k']);
$state = $_GET['state'];
$orderby = "id desc";
$orderbystr = $orderby;
$keyword = str_replace("*", "%", $keyword);
!empty($keyword) && ($cond .= " and (name like '%{$keyword}%' or title like '%{$keyword}%' or remark like '%{$keyword}%' or replier like '%{$keyword}%' or reply like '%{$keyword}%')");
$state == 'y' && ($cond .= " and state=1");
$state == 'n' && ($cond .= " and state=0");
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(10, $curPage, "admin.php?inc=msg&action=list&k={$keyword}&state={$state}&page={page}");
$rows = $pager->queryRows($db, "msgs", $cond, "*", $orderbystr);
$recstr = _LANG($_AL['all.totalrecords'], array($pager->recordNum));
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$keyword}" id="keyword" /> <select id="state"><option value="all">{$_AL['msg.cond0']}</option><option value="y">{$_AL['msg.cond1']}</option><option value="n">{$_AL['msg.cond2']}</option></select> <input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searchmsg()" />
{$recstr}</div>
EOT;
echo "<form id=\"msgsform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
echo "<tr style=\"font-weight:bold;color:#333333;\"><td class=\"row_0\">" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[1]}px;\">{$_AL['all.select']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[2]}px;padding:0px 10px;\">{$_AL['msg.title']}/{$_AL['msg.user']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[3]}px;\">{$_AL['msg.email']}/{$_AL['msg.contact']}/{$_AL['msg.ip']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[4]}px;padding:0px 10px;\">{$_AL['msg.lastreply']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[5]}px;\"> {$_AL['msg.verify.state']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[6]}px;\">{$_AL['all.control']}</div>" . "";
for ($i = 0; $i < count($rows); $i++) {
$row = $rows[$i];
$row['posttime'] = $row['posttime'] == 0 ? "——" : getDateStr($row['posttime']);
$row['replytime'] = $row['replytime'] == 0 ? "——" : getDateStr($row['replytime']);
echo <<<EOT
\t<table class="settop"><tr><td class="settop_left"><img src="../language/{$cache_langs[$_SYS['alangid']]['directory']}/flag.gif" title="{$effect_lang}" /></td><td><div id="smalltab_container"></div></td></tr></table>
\t<div class="smalltab_line"></div>
\t<div id="t1"></div>
\t<div id="t2">
EOT;
$dwidth = array(0, 35, 300, 300, 100, 130, 80, 80, 150);
$cond = "langid={$_SYS['alangid']}";
$keyword = $_GET['k'];
$keyword = str_replace("*", "%", $keyword);
if (!empty($keyword)) {
$cond .= " and (tkey like '%{$keyword}%' or tvalue like '%{$keyword}%')";
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(10, $curPage, "admin.php?inc=template&action=varlist&k={$keyword}&page={page}");
$rows = $pager->queryRows($db, "templatevars", $cond, "*", "tkey");
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$keyword}" id="keyword" />
<input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searchvar()" />
</div>
\t<table class="table_1" width="100%">
\t\t<tr><td class="td_6"><a class="td_5_1a" href="admin.php?inc=template&action=addvar"><img src="images/ico_add.gif" border="0" /> {$_AL['template.addvar']}</a></td></tr>
\t</table>
EOT;
echo "<form id=\"varform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
echo "<tr style=\"font-weight:bold;color:#333333;\"><td class=\"row_0\">" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[1]}px;\">{$_AL['all.select']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[2]}px;\">{$_AL['template.varname']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[3]}px;\">{$_AL['template.vardesc']}</div>" . "<div class=\"rowdiv_0\" style=\"width:{$dwidth[4]}px;\">{$_AL['all.control']}</div>" . "";
\t<div id="smalltab_container"></div>
\t<div class="smalltab_line"></div>
\t<div id="t1">
EOT;
$dwidth = array(0, 35, 190, 130, 160, 160, 130, 100);
$membername = $_GET['membername'];
$cond .= empty($membername) ? "" : "membername like '%{$membername}%'";
$orderby = $_GET['orderby'];
$orderby = empty($orderby) ? "id" : $orderby;
$orderbystr = '';
if (in_array($orderby, array('id', 'signuptime', 'logintime'))) {
$orderbystr = $orderby . ' desc';
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$pager->init(10, $curPage, "admin.php?inc=member&action=search&membername={$membername}&orderby={$orderby}&page={page}");
$rows = $pager->queryRows($db, "members", $cond, "*", $orderbystr);
$recstr = _LANG($_AL['all.totalrecords'], array($pager->recordNum));
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
\t<div class="tips_1">
\t{$_AL['all.keyword']}: <input class="text_css" type="text" size="20" value="{$membername}" id="membername" /> <select id="orderby"><option value="id">{$_AL['all.orderby']}</option><option value="signuptime">{$_AL['member.signuptime']}</option><option value="logintime">{$_AL['member.lastlogin.time']}</option></select> <input class="button_css" type="button" value=" {$_AL['all.search']} " onclick="searchmember()" /> {$recstr}</div>
EOT;
echo "<form id=\"membersform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
echo "<tr style=\"font-weight:bold;color:#333333;\"><td class=\"row_0\"><div class=\"rowdiv_0\" style=\"width:{$dwidth[1]}px;\"><span class=\"warning\">{$_AL['all.delete']}</span></div><div class=\"rowdiv_0\" style=\"width:{$dwidth[2]}px;\">{$_AL['member.name']}/{$_AL['member.email']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[3]}px;\">{$_AL['member.realname']}/{$_AL['member.phone']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[4]}px;\">{$_AL['member.qq']}/{$_AL['member.msn']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[5]}px;\">{$_AL['member.signuptime']}/{$_AL['member.lastlogin.time']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[6]}px;\">{$_AL['member.signupip']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[7]}px;\">{$_AL['all.control']}</div></td></tr>";
for ($i = 0; $i < count($rows); $i++) {
$row = $rows[$i];
$row['signuptime'] = getDateStr($row['signuptime']);
$row['logintime'] = empty($row['logintime']) ? '--' : getDateStr($row['logintime']);
$row['membername'] = htmlFilter($row['membername']);
/************************************** adduser END ************************************************/
/************************************** manager/search BEGIN ************************************************/
/************************************** adduser END ************************************************/
/************************************** manager/search BEGIN ************************************************/
case "manager":
require_once './../inc/pager.php';
echo <<<EOT
\t<div id="smalltab_container"></div>
\t<div class="smalltab_line"></div>
\t<div id="t1">
EOT;
$dwidth = array(0, 35, 120, 100, 140, 160, 160, 150);
$curPage = intval($_GET["page"]);
$pager = new Pager();
$cond = "ishidden=0";
$pager->init(10, $curPage, "admin.php?inc=user&action=search&username={$username}&userid={$userid}&groupid={$groupid}&page={page}");
$rows = $pager->queryRows($db, "users", $cond, "*", "id desc");
echo <<<EOT
\t<div class="div_clear" style="height:10px;"></div>
EOT;
echo "<form id=\"usersform\" onsubmit=\"return false;\">";
echo "<table class=\"table_1\" width=\"100%\">";
echo "<tr style=\"font-weight:bold;color:#333333;\"><td class=\"row_0\"><div class=\"rowdiv_0\" style=\"width:{$dwidth[1]}px;\"><span class=\"warning\">{$_AL['all.delete']}</span></div><div class=\"rowdiv_0\" style=\"width:{$dwidth[2]}px;\">{$_AL['user.username']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[3]}px;\">{$_AL['user.realname']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[4]}px;\">{$_AL['user.lastip']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[5]}px;\">{$_AL['user.lastlogin']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[6]}px;\">{$_AL['user.addtime']}</div><div class=\"rowdiv_0\" style=\"width:{$dwidth[7]}px;\">{$_AL['all.control']}</div></td></tr>";
for ($i = 0; $i < count($rows); $i++) {
$row = $rows[$i];
$row['lastip'] = empty($row['lastip']) ? '--' : $row['lastip'];
$row['lasttime'] = empty($row['lasttime']) ? '--' : getDateStr($row['lasttime']);
$row['addtime'] = empty($row['addtime']) ? '--' : getDateStr($row['addtime']);
$row['username'] = htmlFilter($row['username']);
$row['realname'] = htmlFilter($row['realname']);
$checkboxstr = '';
$state = -1;
if ($_GET['state'] == '') {
$state = -1;
} else {
$state = intval($_GET['state']);
}
if ($state > -1) {
$cond .= " and state={$state}";
}
if (in_array($orderby, array('id', 'createtime', 'total'))) {
$orderbystr = $orderby . ' desc';
}
$curPage = intval($_GET["page"]);
$pager = new Pager();
$countrow = $db->row_select_one("orders", $cond, "count(1) as total");
$pager->init(10, $curPage, "admin.php?inc=order&action=list&k={$keyword}&state={$state}&orderby={$orderby}&page={page}");
/*
$rows = $pager->queryRowsBySQL($db,"
SELECT * FROM `{$db->pre}orders` OT,
(SELECT orderid,
GROUP_CONCAT(proid ORDER BY id DESC SEPARATOR '{$SPRT}') as proids,
GROUP_CONCAT(price ORDER BY id DESC SEPARATOR '{$SPRT}') as prices,
GROUP_CONCAT(proname ORDER BY id DESC SEPARATOR '{$SPRT}') as pronames,
GROUP_CONCAT(pronum ORDER BY id DESC SEPARATOR '{$SPRT}') as pronums
FROM `{$db->pre}orderdetails` WHERE langid={$_SYS['alangid']} GROUP BY orderid) ODT
WHERE {$cond} AND OT.id=ODT.orderid ORDER BY {$orderbystr}",$countrow['total']);
$recstr=_LANG($_AL['all.totalrecords'], array($pager->recordNum));
*/
$rows = $pager->queryRows($db, "orders", "{$cond} AND langid={$_SYS['alangid']}", "*", "{$orderbystr}");
echo <<<EOT
t<div class="div_clear" style="height:10px;"></div>
