315 lines
13 KiB
PHP
315 lines
13 KiB
PHP
<?php
|
|
/*
|
|
* @copyright QiaoQiaoShiDai Internet Technology(Shanghai)Co.,Ltd
|
|
* @license https://www.oaooa.com/licenses/
|
|
*
|
|
* @link https://www.oaooa.com
|
|
* @author zyx(zyx@oaooa.com)
|
|
*/
|
|
if (!defined('IN_OAOOA')) {
|
|
exit('Access Denied');
|
|
}
|
|
$overt = getglobal('setting/overt');
|
|
if(!$overt && !$overt = C::t('setting')->fetch('overt')){
|
|
Hook::listen('check_login');//检查是否登录，未登录跳转到登录界面
|
|
}
|
|
global $_G;
|
|
$do = isset($_GET['do']) ? trim($_GET['do']):'';
|
|
$tid = isset($_GET['tid']) ? intval($_GET['tid']):0;
|
|
$gid = isset($_GET['gid']) ? intval($_GET['gid']):0;
|
|
//获取标签组数据
|
|
$gdata = C::t('#tab#tab_group')->fetch_by_gid($gid);
|
|
//记录哪个专辑过来得
|
|
$kid = isset($_GET['kid']) ? trim($_GET['kid']):0;
|
|
if($do == 'tabdetail'){//卡片详情页
|
|
//获取tab数据
|
|
$tabdata = [];
|
|
//$tabstatus = 0;
|
|
//获取字段数据
|
|
$formlist=unserialize($gdata['formfiled']);
|
|
$forms = array();
|
|
$temp = array();
|
|
foreach ( $formlist as $key => $val ) {
|
|
if(!$val['status']) continue;
|
|
foreach ( C::t( 'form_setting' )->fetch_all_conditions( $key ) as $value ) {
|
|
$value['labelname']=lang($value['labelname']);
|
|
$value[ 'checked' ] = $val;
|
|
$value[ 'style' ] = $val['style'];
|
|
$value[ 'tofolder' ] = $val['tofolder'];
|
|
$value[ 'writable' ] = intval($val['writable']);
|
|
$value[ 'status' ] = $val['status'];
|
|
$temp[ $value[ 'flag' ] ] = $value;
|
|
|
|
}
|
|
}
|
|
$sorts = array( 'name' ); //允许排序的字段
|
|
//排序
|
|
foreach ( $temp as $k => $v ) {
|
|
if ( $k != 'name' && $temp[ $k ][ 'checked' ][ 'sort' ] > 0 )$sorts[] = $k;
|
|
$forms[ $k ] = $temp[ $k ];
|
|
}
|
|
//获取tab信息及其属性值
|
|
$tabdata = C::t('#tab#tab')->fetch($tid);
|
|
$tabattr = C::t('#tab#tab_attr')->fetch_by_tid($tid);
|
|
if($tabattr)$tabdata = array_merge($tabdata,$tabattr);
|
|
$tabdata['catdata'] = C::t('#tab#tab_cat_relation')->fetch_catname_by_tid($tid);
|
|
if($tabdata['icon']){
|
|
$tabdata['icon'] = $_G['setting']['attachurl'].$tabdata['icon'];
|
|
}else{
|
|
$tabdata['icon'] = $gdata['defaultico'];
|
|
}
|
|
$tabdata['icotype'] = $gdata['icotype'];
|
|
//将tab属性值对应字段信息
|
|
foreach($forms as $key=>$val){
|
|
if(isset($tabdata[$key])){
|
|
$forms[$key]['values'] = $tabdata[$key];
|
|
}
|
|
}
|
|
//获取字段分类信息再组织字段数据
|
|
$filedcatdata = C::t('form_setting_filedcat')->fetch_all_by_tabgroupid($gid);
|
|
$formlists = [];
|
|
foreach($filedcatdata as $k=>$v){
|
|
foreach($forms as $val){
|
|
if($val['filedcat'] == $k){
|
|
$v['fileds'][] = $val;
|
|
}
|
|
}
|
|
$formlists[] = $v;
|
|
}
|
|
$tabdata['forms'] = $formlists;
|
|
//增加浏览次数
|
|
if($tid){
|
|
addTabviewStats($tid);
|
|
}
|
|
//获取各种类型文件数量
|
|
$numdatas = ['image'=>0,'video'=>0,'audio'=>0,'document'=>0,'other'=>0];
|
|
//获取图片类型文件数
|
|
$numdatas['image'] = DB::result_first("select count(DISTINCT r.rid) from %t r
|
|
left join %t rt on rt.rid = r.rid
|
|
where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) ",array('pichome_resources','pichome_resourcestab',$tid,array_merge($Types['commonimage'],$Types['image'])));
|
|
$numdatas['video'] = DB::result_first("select count(DISTINCT r.rid) from %t r
|
|
left join %t rt on rt.rid = r.rid
|
|
where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) ",array('pichome_resources','pichome_resourcestab',$tid,$Types['video']));
|
|
$numdatas['audio'] = DB::result_first("select count(DISTINCT r.rid) from %t r
|
|
left join %t rt on rt.rid = r.rid
|
|
where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) ",array('pichome_resources','pichome_resourcestab',$tid,$Types['audio']));
|
|
$numdatas['document'] = DB::result_first("select count(DISTINCT r.rid) from %t r
|
|
left join %t rt on rt.rid = r.rid
|
|
where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) ",array('pichome_resources','pichome_resourcestab',$tid,$Types['document']));
|
|
$numdatas['other'] = DB::result_first("select count(DISTINCT r.rid) from %t r
|
|
left join %t rt on rt.rid = r.rid
|
|
where r.isdelete = 0 and rt.tid = %d and r.ext not in(%n) ",array('pichome_resources','pichome_resourcestab',$tid,
|
|
array_merge($Types['document'],$Types['commonimage'],$Types['image'],$Types['video'],$Types['document'],$Types['audio'])));
|
|
exit(json_encode(array('tabdata'=>$tabdata,'numdata'=>$numdatas)));
|
|
}elseif($do == 'gettag'){//获取标签数据
|
|
$tid = isset($_GET['tid']) ? intval($_GET['tid']):0;
|
|
$perpage = isset($_GET['perpage']) ? intval($_GET['perpage']) : 10;//每页数量
|
|
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;//页码数
|
|
$start = ($page - 1) * $perpage; //开始条数
|
|
$limitsql = "limit $start,$perpage";
|
|
$params= ['tab_tagnum','pichome_tag',$tid];
|
|
$tagdata = [];
|
|
foreach(DB::fetch_all("select t.tid,t.tagname,tn.nums from %t tn left join %t t on t.tid = tn.tid where tn.tabid = %d order by tn.nums desc $limitsql",$params) as $v){
|
|
$tagdata[$v['tid']]['tagname'] = $v['tagname'];
|
|
$tagdata[$v['tid']]['num'] = $v['nums'];
|
|
$tagdata[$v['tid']]['tid'] = $v['tid'];
|
|
}
|
|
//按照关联文件数进行排序
|
|
usort($tagdata, function($a, $b) {
|
|
return $b['nums'] - $b['nums'];
|
|
});
|
|
$next = false;
|
|
if(count($tagdata) >= $perpage){
|
|
$next = true;
|
|
}
|
|
exit(json_encode(array('tagdata'=>$tagdata,'next'=>$next)));
|
|
}elseif($do == 'getoverviewfile'){//获取概览文件
|
|
$tid = isset($_GET['tid']) ? intval($_GET['tid']):0;
|
|
$limit = isset($_GET['limit']) ? intval($_GET['limit']):6;
|
|
$limitsql = "limit 0,$limit";
|
|
//获取各种类型文件数量
|
|
$datas = ['image'=>[],'video'=>[],'audio'=>[],'document'=>[]];
|
|
//获取图片文件
|
|
$imagerids = [];
|
|
foreach(DB::fetch_all("select DISTINCT r.rid from %t r
|
|
left join %t rt on rt.rid = r.rid where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) $limitsql",
|
|
array('pichome_resources','pichome_resourcestab',$tid,array_merge($Types['commonimage'],$Types['image']))) as $v){
|
|
$imagerids[] = $v['rid'];
|
|
}
|
|
|
|
if (!empty($imagerids)) $datas['image'] = C::t('pichome_resources')->getdatasbyrids($imagerids);
|
|
//获取文档文件
|
|
$videorids = [];
|
|
foreach(DB::fetch_all("select DISTINCT r.rid from %t r
|
|
left join %t rt on rt.rid = r.rid where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) $limitsql",
|
|
array('pichome_resources','pichome_resourcestab',$tid,$Types['video'])) as $v){
|
|
$videorids[] = $v['rid'];
|
|
}
|
|
if (!empty($videorids)) $datas['video'] = C::t('pichome_resources')->getdatasbyrids($videorids);
|
|
//获取音频文件
|
|
//获取文档文件
|
|
$audiorids = [];
|
|
foreach(DB::fetch_all("select DISTINCT r.rid from %t r
|
|
left join %t rt on rt.rid = r.rid where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) $limitsql",
|
|
array('pichome_resources','pichome_resourcestab',$tid,$Types['audio'])) as $v){
|
|
$audiorids[] = $v['rid'];
|
|
}
|
|
if (!empty($audiorids)) $datas['audio'] = C::t('pichome_resources')->getdatasbyrids($audiorids);
|
|
//获取文档文件
|
|
$documentrids = [];
|
|
foreach(DB::fetch_all("select DISTINCT r.rid from %t r
|
|
left join %t rt on rt.rid = r.rid where r.isdelete = 0 and rt.tid = %d and r.ext in(%n) $limitsql",
|
|
array('pichome_resources','pichome_resourcestab',$tid,$Types['document'])) as $v){
|
|
$documentrids[] = $v['rid'];
|
|
}
|
|
if (!empty($documentrids)) $datas['document'] = C::t('pichome_resources')->getdatasbyrids($documentrids);
|
|
exit(json_encode(array('data'=>$datas)));
|
|
}elseif($do == 'getfilelist'){
|
|
$tid = isset($_GET['tid']) ? intval($_GET['tid']):0;
|
|
$perpage = isset($_GET['perpage']) ? intval($_GET['perpage']) : 10;//每页数量
|
|
$keyword = isset($_GET['keyword']) ? trim($_GET['keyword']) : '';
|
|
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;//页码数
|
|
$start = ($page - 1) * $perpage; //开始条数
|
|
$limitsql = "limit $start,$perpage";
|
|
$selectsql = " DISTINCT r.rid ";
|
|
$sql = " from %t r
|
|
left join %t rb on rb.rid = r.rid ";
|
|
$params = ['pichome_resources','pichome_resourcestab'];
|
|
$wheresql = 'where r.isdelete = 0 and rb.tid = %d ';
|
|
$para[] = $tid;
|
|
//标签条件
|
|
if(isset($_GET['tagid'])){
|
|
$tagid = explode(',',$_GET['tagid']);
|
|
$sql .= ' left join %t rt on r.rid = rt.rid ';
|
|
$params[] = 'pichome_resourcestag';
|
|
$wheresql .= ' and rt.tid in(%n) ';
|
|
$para[] = $tagid;
|
|
}
|
|
//后缀条件
|
|
if(isset($_GET['type'])){
|
|
$filetype = trim($_GET['type']);
|
|
$numdatas = ['image'=>0,'video'=>0,'audio'=>0,'document'=>0,'other'=>0];
|
|
switch ($filetype){
|
|
case 'image':
|
|
$wheresql .= ' and r.ext in(%n) ';
|
|
$para[] = array_merge($Types['commonimage'],$Types['image']);
|
|
break;
|
|
case 'video':
|
|
$wheresql .= ' and r.ext in(%n) ';
|
|
$para[] = $Types['video'];
|
|
break;
|
|
case 'audio':
|
|
$wheresql .= ' and r.ext in(%n) ';
|
|
$para[] = $Types['audio'];
|
|
break;
|
|
case 'document':
|
|
$wheresql .= ' and r.ext in(%n) ';
|
|
$para[] = $Types['document'];
|
|
break;
|
|
case 'other':
|
|
$wheresql .= ' and r.ext not in(%n) ';
|
|
$para[] = array_merge($Types['document'],$Types['commonimage'],$Types['image'],$Types['video'],$Types['document'],$Types['audio']);
|
|
break;
|
|
|
|
}
|
|
}
|
|
if ($keyword) {
|
|
if (!in_array('pichome_resources_attr', $params)) {
|
|
$sql .= "left join %t ra on r.rid = ra.rid";
|
|
$params[] = 'pichome_resources_attr';
|
|
}
|
|
$keywords = array();
|
|
$arr1 = explode('+', $keyword);
|
|
foreach ($arr1 as $value1) {
|
|
$value1 = trim($value1);
|
|
$arr2 = explode(' ', $value1);
|
|
$arr3 = array();
|
|
foreach ($arr2 as $value2) {
|
|
|
|
$arr3[] = "ra.searchval LIKE %s";
|
|
$para[] = '%' . $value2 . '%';
|
|
}
|
|
$keywords[] = "(" . implode(" OR ", $arr3) . ")";
|
|
}
|
|
if ($keywords) {
|
|
$wheresql .= " and (" . implode(" AND ", $keywords) . ") ";
|
|
}
|
|
}
|
|
$order = isset($_GET['order']) ? intval($_GET['order']):0;
|
|
if(!$order){//默认最新
|
|
$ordersql = ' r.btime desc,r.rid asc' ;
|
|
}else{//最热文件
|
|
$sql .= ' left join %t v on r.rid=v.idval ';
|
|
$selectsql .= " ,v.nums ";
|
|
$params[] = 'views';
|
|
$ordersql = ' v.nums desc ,r.rid asc ';
|
|
|
|
}
|
|
if (!empty($para)) $params = array_merge($params, $para);
|
|
foreach (DB::fetch_all("select $selectsql $sql $wheresql order by $ordersql $limitsql", $params) as $value) {
|
|
$rids[] = $value['rid'];
|
|
}
|
|
|
|
$data = array();
|
|
if (!empty($rids)) $data = C::t('pichome_resources')->getdatasbyrids($rids);
|
|
$next = false;
|
|
if (count($rids) >= $perpage) {
|
|
$total = $start + $perpage * 2 - 1;
|
|
$next = true;
|
|
} else {
|
|
$total = $start + count($rids);
|
|
}
|
|
//增加统计关键词次数
|
|
if($rids && $keyword){
|
|
$statskeywords = array();
|
|
$arr1 = explode('+', $keyword);
|
|
foreach($arr1 as $v){
|
|
$arr2 = explode(' ', $value1);
|
|
foreach($arr2 as $kval){
|
|
addKeywordStats($kval);
|
|
|
|
}
|
|
}
|
|
|
|
}
|
|
$return = array(
|
|
'appid' => $appid,
|
|
'total' => $total,
|
|
'next'=>$next,
|
|
'data' => $data ? $data : array(),
|
|
'param' => array(
|
|
'order' => $order,
|
|
'page' => $page,
|
|
'perpage' => $perpage,
|
|
'total' => $total,
|
|
'keyword' => $keyword
|
|
)
|
|
);
|
|
updatesession();
|
|
exit(json_encode(array('data' => $return)));
|
|
}elseif($do == 'addviews'){//增加浏览数
|
|
$tid = isset($_GET['tid']) ? intval($_GET['tid']):0;
|
|
if($tid) C::t('#tab#tab')->addviews_by_tid($tid);
|
|
exit(json_encode(array('success'=>true)));
|
|
}else{
|
|
$bannerdata = C::t('pichome_banner')->getbannerlist(0,1);
|
|
$bannerdata = json_encode($bannerdata);
|
|
|
|
$collectlis = Hook::listen('collectlist');
|
|
$collectdata = [];
|
|
if(isset($collectlis[0])){
|
|
if(isset($collectlis[0]['x']) && $collectlis[0]['x']){
|
|
foreach($collectlis[0]['x'] as $value){
|
|
$collectdata[] =['name'=>$value['title'],'url'=>'index.php?mod=fileCollect&op=upload&cid='.$value['cid']];
|
|
}
|
|
// $collectdata[] = ['name'=>'我提交的','url'=>'index.php?mod=fileCollect&type=1'];
|
|
}
|
|
// if(isset($collectlis[0]['m']) && $collectlis[0]['m']){
|
|
// $collectdata[] = ['name'=>'我审核的','url'=>'index.php?mod=fileCollect&type=2'];
|
|
// }
|
|
}
|
|
include template('page/information');
|
|
exit();
|
|
}
|
|
|