getUserID();
}
$adminid = $cuserLogin->getUserID();
$maintable = '#@__archives';
setcookie('ENV_GOBACK_URL', $dedeNowurl, time()+3600, '/');
$tl = new TypeLink($cid);
//----------------------------------------
//在不指定排序条件和关键字的情况下直接统计微表
//----------------------------------------
if(empty($totalresult) && empty($keyword) && empty($orderby) && empty($flag))
{
$tinyQuerys = array();
if(!empty($userCatalogSql))
{
$tinyQuerys[] = str_replace('arc.', '', $userCatalogSql);
}
if(!empty($channelid) && empty($cid))
{
$tinyQuerys[] = " channel = '$channelid' ";
}
else
{
$tinyQuerys[] = " channel>0 ";
}
if(!empty($arcrank))
{
$tinyQuerys[] = " arcrank='$arcrank' ";
}
else
{
// 软件列表默认显示审核通过的
if($channelid == 3) {
$tinyQuerys[] = " arcrank = 0 ";
} else {
$tinyQuerys[] = " arcrank > -2 ";
}
}
if(!empty($mid))
{
$tinyQuerys[] = " mid='$mid' ";
}
if(!empty($duty_mid))
{
$tinyQuerys[] = " dutyadmin='$duty_mid' ";
}
if(!empty($cid))
{
$tinyQuerys[] = " typeid in(".GetSonIds($cid).") ";
}
if(!empty($f_cid))
{
$tinyQuerys[] = " typeid2='{$f_cid}' or typeid2 like '{$f_cid},%' or typeid2 like '%,{$f_cid},%' or typeid2 like '%,{$f_cid}' ";
}
if(count($tinyQuerys)>0)
{
$tinyQuery = "WHERE ".join(' AND ',$tinyQuerys);
}
// 缓存处理
// $sql = "SELECT COUNT(*) AS dd FROM `#@__arctiny` $tinyQuery ";
$sql = "SELECT COUNT(*) AS dd FROM `#@__archives` $tinyQuery ";
// echo $sql,'
';
$cachekey = md5($sql);
$arr = GetCache('listcache', $cachekey);
if (empty($arr))
{
$arr = $dsql->GetOne($sql);
SetCache('listcache', $cachekey, $arr);
}
$totalresult = $arr['dd'];
}
if($cid==0)
{
if($channelid==0)
{
$positionname = '所有栏目>';
}
else
{
$row = $tl->dsql->GetOne("SELECT id,typename,maintable FROM `#@__channeltype` WHERE id='$channelid'");
$positionname = $row['typename']." > ";
$maintable = $row['maintable'];
$channelid = $row['id'];
}
}
else
{
$positionname = str_replace($cfg_list_symbol," > ",$tl->GetPositionName())." > ";
}
//当选择的是单表模型栏目时，直接跳转到单表模型管理区
if(empty($channelid)
&& isset($tl->TypeInfos['channeltype']))
{
$channelid = $tl->TypeInfos['channeltype'];
}
if($channelid < -1 )
{
header("location:content_sg_list.php?cid=$cid&channelid=$channelid&keyword=$keyword");
exit();
}
// 栏目大于800则需要缓存数据
$optHash = md5($cid.$admin_catalogs.$channelid);
$optCache = DEDEDATA."/tplcache/inc_option_$optHash.inc";
$typeCount = 0;
if (file_exists($cache1)) require_once($cache1);
else $cfg_Cs = array();
$typeCount = count($cfg_Cs);
if ( $typeCount > 800)
{
if (file_exists($optCache))
{
$optionarr = file_get_contents($optCache);
} else {
$optionarr = $tl->GetOptionArray($cid, $admin_catalogs, 0); // 显示所有分类
file_put_contents($optCache, $optionarr);
}
} else {
$optionarr = $tl->GetOptionArray($cid, $admin_catalogs, 0); // 显示所有分类
}
if (empty($channelid)) {
$whereSql = " WHERE arc.channel > 0 ";
} else{
$whereSql = " WHERE arc.channel = '{$channelid}' ";
}
if (empty($arcrank)) {
// 软件默认不显示未审核的资料
if ($channelid == 3) {
$whereSql .= " AND arc.arcrank > -1 ";
} else {
$whereSql .= " AND arc.arcrank > -2 ";
}
}
$flagsArr = '';
$dsql->Execute('f', 'SELECT * FROM `#@__arcatt` ORDER BY sortid ASC');
while($frow = $dsql->GetArray('f'))
{
$flagsArr .= ($frow['att']==$flag ? "\r\n" : "\r\n");
}
if(!empty($startdate))
{
$whereSql .= " AND arc.pubdate >= ". strtotime($startdate);
}
if(!empty($enddate))
{
$whereSql .= " AND arc.pubdate <= ". (strtotime($enddate)+86400);
}
if(!empty($userCatalogSql))
{
$whereSql .= " AND ".$userCatalogSql;
}
if(!empty($mid))
{
$whereSql .= " AND arc.mid = '$mid' ";
}
if(!empty($duty_mid)){
$whereSql .= " AND arc.dutyadmin = '$duty_mid' ";
}
if($keyword != '')
{
if ($flag != '' && $flag == 'tag') {
$tag = $keyword;
} else {
$whereSql .= " AND arc.title LIKE '%$keyword%' ";
}
}
if($flag != '' && $flag != 'tag')
{
$whereSql .= " AND FIND_IN_SET('$flag', arc.flag) ";
}
if($column)
{
$whereSql .= " AND FIND_IN_SET('z', arc.flag) ";
}
if($cid != 0)
{
$whereSql .= ' AND arc.typeid IN ('.GetSonIds($cid).')';
}
if($f_cid != 0)
{
$whereSql .= " AND arc.typeid2='{$f_cid}' or arc.typeid2 like '{$f_cid},%' or arc.typeid2 like '%,{$f_cid},%' or arc.typeid2 like '%,{$f_cid}' ";
}
if($arcrank != '')
{
$whereSql .= " AND arc.arcrank = '$arcrank' ";
$CheckUserSend = "";
}
else
{
$CheckUserSend = "";
}
if($channelid==3 && empty($arcrank)){//mark wang
$CheckUserSend.="";
// $whereSql.= " AND arc.arcrank>-1";
}
//筛选发布方式
if ($publiced_type > 0) {
switch ($publiced_type) {
case 1:
$whereSql .= " AND arc.arc_from = 2 AND arc.store_flag not in (15,12,13,14) ";
break;
case 2:
$whereSql .= " AND arc.arc_from = 1 AND arc.store_flag not in (15,12,13,14) ";
break;
case 3:
$whereSql .= " AND arc.store_flag = 12 ";
break;
case 4:
$whereSql .= " AND arc.store_flag = 14 ";
break;
case 5:
$whereSql .= " AND arc.store_flag = 13 ";
break;
case 6:
$whereSql .= " AND FIND_IN_SET('g', arc.flag) ";
break;
case 7:
$whereSql .= " AND arc.store_flag = 15 ";
break;
case 8:
$whereSql .= " AND arc.store_flag = 15 and arc.evip_type = 1";
break;
case 9:
$whereSql .= " AND arc.store_flag = 15 and arc.evip_type = 2";
break;
case 10:
$whereSql .= " AND arc.store_flag = 16";
case 11: //企业号资料
$whereSql .= " AND channel = 3 AND arc.store_flag = 15";
break;
case 12: //爬虫采集资料
$whereSql .= " AND channel = 3 AND arc.store_flag = 17";
break;
}
}
if ($publiced_uid > 0) {
$whereSql .= " AND arc.mid = {$publiced_uid} ";
}
$start_time = $end_time = 0;
if (!empty($date_type)) {
switch ($date_type) {
case 'yesterday':
$start_time = strtotime(date('Y-m-d') . '-1 days');
$end_time = $start_time + 86399;
$startdate = date('Ymd', $start_time);
$enddate = date('Ymd', $end_time);
$whereSql .= " AND arc.store_flag = 12 AND arc.pubdate between {$start_time} and {$end_time}";
break;
}
}
if ($arcrank == '-1'){
$orderby = empty($orderby) ? 'u_time' : $orderby;
$orderbyField = 'arc.'.$orderby;
} else {
$orderby = empty($orderby) ? 'id' : preg_replace("#[^a-z0-9]#", "", $orderby);
$orderbyField = 'arc.'.$orderby;
}
$baseField = "arc.id,arc.typeid,arc.typeid2,arc.senddate,arc.flag,arc.ismake,arc.store_flag,arc.evip_type,arc.arc_from,
arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,arc.keywords,arc.unionid,";
$query = "SELECT {$baseField} arc.dutyadmin
FROM `$maintable` arc
$whereSql
ORDER BY $orderbyField DESC";
//按照文章点赞数排序 start
if($orderby=='praise'){
$query = "SELECT {$baseField} arc.dutyadmin,count(ap.aid) as praisenum
FROM `$maintable` arc left join `#@__arc_praise` ap on arc.id = ap.aid
$whereSql group by arc.id
ORDER BY praisenum DESC";
}
//按照文章点赞数排序 end
if($channelid == 17) {
$query = "SELECT {$baseField} arc.dutyadmin, count(et.aid) as downnum
FROM `$maintable` arc left join ea_tekaxiazai et on et.aid = arc.id
$whereSql group by arc.id
ORDER BY $orderbyField DESC";
} elseif (!empty($tag)) {
//按标签筛选
$taginfo = $dsql->GetOne("SELECT id,tag from `#@__tagindex` where tag='{$tag}' limit 1");
if (!$taginfo) {
ShowMsg('该标签不存在', '-1');
die;
}
$query = "SELECT {$baseField} arc.dutyadmin,
FROM `$maintable` arc inner join `#@__taglist` tl on tl.aid=arc.id
$whereSql and tl.tid = {$taginfo['id']}
ORDER BY $orderbyField DESC";
$tag_count_sql = "SELECT COUNT(*) AS dd FROM FROM `$maintable` arc inner join `#@__taglist` tl on tl.aid=arc.id
$whereSql and tl.tid = {$taginfo['id']}";
$tag_count_arr = $dsql->GetOne($tag_count_sql);
$totalresult = $tag_count_arr['dd'];
}
if($channelid == 3){
$file_flag = isset($file_flag) ? intval($file_flag) : 0;//资料类型
$weight_num = isset($weight_num) ? intval($weight_num) : 0;//是否推荐
if($file_flag == 1){
$whereSql .= " AND soft.file_flag in(0,1) ";
}
if($file_flag == 2){
$whereSql .= " AND soft.file_flag = 2 ";
}
if($weight_num == 1){
$whereSql .= " AND soft.weight_num > 0 ";
}
if($weight_num == 2){
$whereSql .= " AND soft.weight_num = 0 ";
}
if($order_weight_num == 1){
$tmp_order = ' soft.weight_num asc, soft.aid desc';
}elseif ($order_weight_num == 2){
$tmp_order = ' soft.weight_num desc,soft.aid desc ';
}else{
$tmp_order = " $orderbyField DESC ";
}
$query = "select arc.id,arc.typeid,arc.typeid2,arc.senddate,arc.flag,arc.ismake, arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,arc.keywords,arc.dutyadmin,soft.weight_num,soft.file_flag,soft.new_title,arc.store_flag,arc.arc_from,arc.unionid
from `#@__archives` arc
left join `#@__addonsoft` soft on arc.id = soft.aid
$whereSql
ORDER BY $tmp_order";
}
if($channelid == -1){
$weight_num = isset($weight_num) ? intval($weight_num) : 0;//是否推荐
$sc_id = isset($sc_id) ? intval($sc_id) : 0;//前端类目查找
if($sc_id > 0){
$whereSql .= " AND spec.sc_id = $sc_id ";
}
if($weight_num == 1){
$whereSql .= " AND spec.weight_num > 0 ";
}
if($weight_num == 2){
$whereSql .= " AND spec.weight_num = 0 ";
}
if($order_weight_num == 1){
$tmp_order = ' spec.weight_num asc ';
}elseif ($order_weight_num == 2){
$tmp_order = ' spec.weight_num desc ';
}else{
$tmp_order = " $orderbyField DESC ";
}
$query = "select arc.id,arc.typeid,arc.typeid2,arc.senddate,arc.flag,arc.ismake, arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,arc.keywords,arc.dutyadmin,spec.weight_num,spec.sc_id,arc.store_flag,arc.arc_from,arc.unionid
from `#@__archives` arc
join `#@__addonspec` spec on arc.id = spec.aid
$whereSql
ORDER BY $tmp_order";
}
// echo $query;
if(empty($f) || !preg_match("#form#", $f)) $f = 'form1.arcid1';
//如果关键词搜索 批量修改tag的支持 start
$keyword_id_arr = array();
if(($keyword != '')&&!$tag&&($channelid!=17)){
$keyword_query = "SELECT arc.id
FROM `$maintable` arc
$whereSql";
$dsql->SetQuery($keyword_query);
$dsql->Execute('keyword_query');
while($keyword_query_row=$dsql->GetArray('keyword_query')){
$keyword_id_arr[] = $keyword_query_row['id'];
}
if($keyword_id_arr){
$keyword_id_arr = json_encode($keyword_id_arr);
}
}
$publicedTypes = \hqjfmanage\logic\article\PostTypeLogic::getPublicedTypes();
$publicedSoftTypes = \hqjfmanage\logic\article\PostTypeLogic::getPublicedSoftTypes();
//如果关键词搜索 批量修改tag的支持 end
//初始化
$dlist = new DataListCP();
$dlist->pageSize = 30;
//GET参数
$dlist->SetParameter('dopost', 'listArchives');
$dlist->SetParameter('publicedTypes', $publicedTypes);
$dlist->SetParameter('publicedSoftTypes', $publicedSoftTypes);
$dlist->SetParameter('publiced_type', $publiced_type);
$dlist->SetParameter('publiced_uid', $publiced_uid);
$dlist->SetParameter('date_type', $date_type);
$dlist->SetParameter('keyword', $keyword);
$dlist->SetParameter('order_weight_num', $order_weight_num);
$dlist->SetParameter('startdate', $startdate);
$dlist->SetParameter('enddate', $enddate);
if(!empty($mid)) $dlist->SetParameter('mid', $mid);
$dlist->SetParameter('cid', $cid);
$dlist->SetParameter('f_cid', $f_cid);
$dlist->SetParameter('flag', $flag);
$dlist->SetParameter('orderby', $orderby);
$dlist->SetParameter('arcrank', $arcrank);
$dlist->SetParameter('channelid', $channelid);
$dlist->SetParameter('tag', $tag);
$dlist->SetParameter('duty_mid', $duty_mid);
$dlist->SetParameter('column', $column);
$dlist->SetParameter('f', $f);
$dlist->SetParameter('file_flag', $file_flag);
$dlist->SetParameter('weight_num', $weight_num);
//模板
////
if($channelid == 17)
$s_tmplets = 'templets/content_list_17.htm';
elseif(empty($s_tmplets))
$s_tmplets = 'templets/content_list.htm';
$dlist->SetTemplate(DEDEADMIN.'/'.$s_tmplets);
//查询
//支持按照id查询
if($aid){
$query = "SELECT arc.id,arc.typeid,arc.typeid2,arc.senddate,arc.flag,arc.ismake,arc.store_flag,arc.arc_from,arc.channel,
arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,arc.keywords,arc.dutyadmin,arc.evip_type,arc.unionid
FROM `$maintable` arc WHERE arc.id = {$aid} ";
}
$dlist->SetSource($query);
//显示
$dlist->Display();
$dlist->Close();
function getTagList($aid, $pagename = 'content_list.php')
{
global $dsql;
if (!$aid) {
return '';
}
$sql = "SELECT tag from `#@__taglist` where aid={$aid}";
$dsql->SetQuery($sql);
$dsql->Execute('onetag');
$str = '';
$comma = '';
while ($onetag = $dsql->GetArray('onetag')) {
if (!$onetag['tag']) {
continue;
}
$str .= $comma.''.$onetag['tag'].'';
$comma = ',';
}
return $str;
}
/**
* 获取文件大小
* @param integer $aid 文章ID
* @param integer $channel 类型ID
* @return [type] [description]
*/
function getFileSize($aid, $channel = 3)
{
global $dsql;
if (!$aid) {
return '';
}
$query = "SELECT addtable FROM `#@__channeltype` WHERE id='" . $channel . "'";
$cInfos = $dsql->GetOne($query);
if (!is_array($cInfos)) {
return '';
}
$addtable = $cInfos['addtable'];
$addQuery = "SELECT softsize FROM `$addtable` WHERE aid='$aid'";
$addRow = $dsql->GetOne($addQuery);
return $addRow['softsize'];
}
/**
* 获取附加表信息
*/
function getAddonSoftRow($aid, $field)
{
global $dsql;
$cachekey = 'addonsoft_row_' . $aid;
$row = GetCache('addonsoft', $cachekey);
if (empty($row)) {
$query = "SELECT new_title,softsize FROM `#@__addonsoft` WHERE aid='$aid'";
$row = $dsql->GetOne($query);
if($row){
SetCache('addonsoft', $cachekey, $row, 5);
}
}
if($field == 'new_title' && empty($row[$field])){
$row['new_title'] = '- -';
}
return $row[$field];
}
function get_admin_name($adminid)
{
global $dsql;
static $user = array();
$adminid = intval($adminid);
if (!isset($user[$adminid])) {
$mem = $dsql->GetOne("SELECT * from `#@__admin` where id=$adminid limit 1");
$user[$adminid] = $mem['userid'];
}
return $user[$adminid];
}
/**
* 获取审核人笔名
* @param $adminid
* @param string $field
* @return mixed|string
*/
function get_admin_uname($adminid,$field = 'uname')
{
if(empty($adminid)){
$res = '';
}else{
global $dsql;
static $user = array();
$adminid = intval($adminid);
if (!isset($user[$adminid])) {
$mem = $dsql->GetOne("SELECT $field from `#@__admin` where id=$adminid limit 1");
$user[$adminid] = $mem[$field];
}
$res = $user[$adminid];
}
return $res;
}
function get_admin_list()
{
global $dsql;
$sql = "SELECT id,uname from `#@__admin` ";
$dsql->SetQuery($sql);
$dsql->Execute('admin');
$admin = array();
while ($row = $dsql->GetArray('admin')) {
$admin[] = $row;
}
return $admin;
}
/**
* @param $aid
*/
function getAuthName($info)
{
//1: 获取uid
if (empty($info['mid']) || !isset($info['flag']) || !isset($info['store_flag']) || !isset($info['channel'])) {
return '';
}
$userLogic = new \hqjfmanage\logic\user\UserLogic();
$unionid = empty($info['unionid']) ? 0 : $info['unionid'];
$uid = $userLogic->changeMidToUid($info['mid'], $unionid, $info['channel']);
global $dsql;
//如果是专栏，获取专栏用户名
$auth_name = '';
//如果是专栏
if (strstr($info['flag'], 'z') !== false) {
$row = $dsql->GetOne("SELECT ch_name FROM `#@__wx_mp_list` WHERE uid='{$uid}' ");
if ($row) {
$auth_name = $row['ch_name'];
}
return $auth_name;
}
//企业号
if (15 == $info['store_flag']) {
$evipLogic = new \hqjfmanage\logic\evip\EvipLogic();
$info = $evipLogic->getBaseInfoUids([$uid]);
$info = current($info);
if (!empty($info)) {
$auth_name = $info['enterprise_name'] . ' - ' .
(isset($info['ver_text']) ? $info['ver_text'] : $evipLogic->getVerText($info['ver_id']));
}
return $auth_name;
}
//如果是文章
if($info['channel'] == 1){
$rs = $dsql->GetOne("SELECT uname,userid FROM `#@__admin` WHERE id='{$info['mid']}' ");
if(!$rs){
$rs = $dsql->GetOne("SELECT uname,userid FROM `#@__member` WHERE uid='{$info['mid']}' ");
}
$auth_name = $rs['uname'] ? $rs['uname'] : $rs['userid'];
return $auth_name;
}
if ($info['channel'] == 3){
//优先找前端用户
$rs = $dsql->GetOne("SELECT uname,userid FROM `#@__member` WHERE mid='{$info['mid']}' ");
if (!empty($rs)) {
$auth_name = empty($rs['uname']) ? $rs['userid'] : $rs['uname'];
return $auth_name;
}
//后台管理员
$rs = $dsql->GetOne("SELECT uname,userid FROM `#@__admin` WHERE id='{$info['mid']}' ");
if (!empty($rs)) {
$auth_name = empty($rs['uname']) ? $rs['userid'] : $rs['uname'];
}
return $auth_name;
}
//非文章走原来的逻辑
$auth_name = GetMemberName($info['mid']);
return $auth_name;
}