<?php
if (!defined('IN_OAOOA')) {
    exit('Access Denied');
}
$overt = getglobal('setting/overt');
if(!$overt && !$overt = C::t('setting')->fetch('overt')){
    Hook::listen('check_login');//检查是否登录，未登录跳转到登录界面
}
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$do = isset($_GET['do']) ? trim($_GET['do']) : '';
if ($do == 'gettagdata') {//获取标签位文件列表数据
    $tdid = isset($_GET['tdid']) ? intval($_GET['tdid']) : 0;
    $tagdata = C::t('pichome_templatetagdata')->fetch($tdid);

    $reurn = [];
    if ($tagdata) {
        //获取类型
        $tag = C::t('pichome_templatetag')->fetch($tagdata['tid']);
        $tagtype = $tag['tagtype'];

        if ($tagtype == 'file_rec' || $tagtype == 'db_ids') {//如果是文件推荐
            $tagval = unserialize($tagdata['tdata']);
            $tagval = $tagval[0];
            $limitnum = $tagval['number'];
            $cachename = 'templatetagdata_'.$tdid;
            $processname = 'templatetagdatalock_'.$tdid;
            $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
            $perpage = isset($_GET['perpage']) ? intval($_GET['perpage']) : 200;
            if($tagtype == 'db_ids' && $page == 1 && $limitnum && $perpage > $limitnum) $perpage = $limitnum;
            if($tagtype == 'db_ids' && $page > 1){
                $count =($page - 1) * $perpage;
                if($limitnum && $count > $limitnum) $perpage = 0;
                elseif( $limitnum && (($count+$perpage) > $limitnum)){
                    $perpage = (($limitnum - $count) < 0) ? 0:intval($limitnum - $count);
                }
            }

            $start = ($page - 1) * $perpage;
            $limitsql = "limit $start," . $perpage;

            if($tagtype == 'db_ids' && $page == 1 && $tagdata['cachetime'] &&  $cachedata = C::t('cache')->fetch_cachedata_by_cachename($cachename,$tagdata['cachetime'])){
                $rids = $cachedata;
            }
            elseif($tagtype != 'db_ids' && $tagdata['cachetime'] &&  $cachedata = C::t('cache')->fetch_cachedata_by_cachename($cachename,$tagdata['cachetime'])){
                $rids = $cachedata;
            }
            else{

                $sql = " from %t r  ";
                //$selectsql = "  distinct r.rid,r.name ";
                $selectsql = "   r.rid,r.name ";
                $wheresql = " r.appid = %s and r.isdelete = 0 ";
                $params = ['pichome_resources'];
                $para[] = trim($tagval['id']);
                //}
                $countsql = " count(distinct(r.rid))";
                if($tagval['type'] == 2){//标签
                    $tagarr = explode(',',$tagval['value']);
                    $tids = [];
                    foreach(DB::fetch_all("select tid from %t where tagname in(%n)",array('pichome_tag',$tagarr)) as $tid){
                        $tids[] = $tid['tid'];
                    }
                    $sql .= "left join %t rt on rt.rid=r.rid ";
                    $params[] = 'pichome_resourcestag';
                    $wheresql .= ' and rt.tid in(%n) ';
                    $para[] = $tids;
                }
                elseif($tagval['type'] == 3){//评分
                    switch ($tagval['gradetype']) {
                        case 0:
                            $wheresql .= ' and r.grade = %d ';
                            $para[] = intval($tagval['value']);
                            break;
                        case 1:
                            $wheresql .= ' and r.grade != %d ';
                            $para[] = intval($tagval['value']);
                            break;
                        case 2:
                            $wheresql .= ' and r.grade <= %d ';
                            $para[] = intval($tagval['value']);
                            break;
                        case 3:
                            $wheresql .= ' and r.grade >= %d ';
                            $para[] = intval($tagval['value']);
                            break;
                    }
                }
                elseif($tagval['type'] == 4){//分类
                    $fidarr = $tagval['classify']['checked'];
                    /*$wheresql .= ' and r.fids in(%n) ';
                    $para[] = $fidarr;*/
                    $sql .= "left join %t fr on fr.rid=r.rid ";
                    $params[] = 'pichome_folderresources';
                    $wheresql .= ' and fr.fid in(%n) ';
                    $para[] = $fidarr;
                }
                if ($tagval['sort'] == 1) {//最新推荐
                    $ordersql = '  r.dateline desc ';
                }
                elseif ($tagval['sort'] == 2) {//热门排序
                    $sql .= ' left join %t v on r.rid=v.idval and v.idtype = 0 ';
                    $selectsql .= " ,v.nums as num  ";
                    $params[] = 'views';
                    $ordersql = '  num desc ,r.dateline desc ';
                }
                elseif ($tagval['sort'] == 3) {//名字排序
                    //$ordersql = ' r.dateline desc ';
                    $ordersql = '   cast((r.name) as unsigned) asc, CONVERT((r.name) USING gbk) asc';

                }
                elseif ($tagval['type'] == 4) {//最新排序

                    $ordersql = ' r.dateline desc ';
                }else{
                    $ordersql = ' r.dateline desc ';
                }

                if ($para) $params = array_merge($params, $para);
                $count = DB::result_first("select $countsql $sql where  $wheresql  ", $params);
                $rids = [];

                foreach (DB::fetch_all(" select  $selectsql $sql where  $wheresql  group by r.rid  order by $ordersql  $limitsql", $params) as $value) {
                    $rids[] = $value['rid'];
                }
                if ((($tagtype == 'db_ids' && $page == 1) || $tagtype == 'file_rec') && $tagdata['cachetime'] && !empty($rids)){
                    $cachearr = [
                        'cachekey'=>$cachename,
                        'cachevalue'=>serialize($rids),
                        'dateline'=>TIMESTAMP
                    ];
                    C::t('cache')->insert_cachedata_by_cachename($cachearr,$tagdata['cachetime'],1);
                }
            }
            if (!empty($rids)) {
                $data = C::t('pichome_resources')->getdatasbyrids($rids,1);
            }

            $next = true;
            //获取已查询总数
            if (count($rids) >= $perpage) {
                $total = $start + $perpage * 2 - 1;
                if (!$limitnum || $total >= $limitnum) {
                    $next = true;
                }else{
                    $next = false;
                }
            } else {
                $total = $start + count($rids);
                $next = false;
            }

            $return = array(
                'tdid' => $tdid,
                'next' => $next,
                'count' => $count,
                'data' => $data ? $data : array(),
                'param' => array(
                    'page' => $page,
                    'perpage' => $perpage,
                )
            );

        }
        elseif($tagtype == 'tab_rec'){//如果是专辑推荐
            $tagval = unserialize($tagdata['tdata']);
            $limitnum = $tagval['number'];
            $cachename = 'templatetagdata_'.$tdid;
            $processname = 'templatetagdatalock_'.$tdid;
            $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
            $perpage = isset($_GET['perpage']) ? intval($_GET['perpage']) : 100;
            if($limitnum && $perpage > $limitnum) $perpage = $limitnum;
            $start = ($page - 1) * $perpage;
            $limitsql = "limit $start," . $perpage;
            $tagval = $tagval[0];
            if($tagdata['cachetime'] &&  $cachedata = C::t('cache')->fetch_cachedata_by_cachename($cachename,$tagdata['cachetime'])){
                $tids =$cachedata;

            }
            else{

                // print_r($tagval);die;
                $sql = " from %t t  ";
                $selectsql = "   t.tid ";
                $wheresql = " t.gid = %d and t.isdelete < 1 ";
                $params = ['tab'];
                $para[] = intval($tagval['id']);
                //}
                $countsql = " count(distinct(t.tid))";
                if(isset($tagval['classify']['checked'])){//如果分类有值
                    $cidarr = $tagval['classify']['checked'];
                    $sql .= ' LEFT JOIN %t tabcatrelation ON tabcatrelation.tid = t.tid ';
                    $params[] = 'tab_cat_relation';
                    $wheresql .= ' and tabcatrelation.cid in(%n) ';
                    $para[]= $cidarr;
                }

                if ($tagval['sort'] == 1) {//最新推荐
                    $ordersql = '  t.dateline desc ';
                }
                elseif ($tagval['sort'] == 2) {//热门排序
                    $sql .= ' left join %t v on t.tid=v.idval and v.idtype = 2 ';
                    $selectsql .= " ,v.nums as num  ";
                    $params[] = 'views';
                    $ordersql = '  num desc ,t.dateline desc ';
                }


                if ($para) $params = array_merge($params, $para);
                $count = DB::result_first("select $countsql $sql where  $wheresql  ", $params);
                $tiddata = [];
                /* echo " select  $selectsql $sql where  $wheresql  group by t.tid order by $ordersql  $limitsql";
                 print_r($params);die;*/
                foreach (DB::fetch_all(" select  $selectsql $sql where  $wheresql  group by t.tid order by $ordersql  $limitsql", $params) as $value) {
                    $tids[] = $value['tid'];
                }

                if ($tids && $tagdata['cachetime'] && !empty($tids)){
                    $cachearr = [
                        'cachekey'=>$cachename,
                        'cachevalue'=>serialize($tids),
                        'dateline'=>TIMESTAMP
                    ];
                    C::t('cache')->insert_cachedata_by_cachename($cachearr,$tagdata['cachetime'],1);
                }
            }
            if (!empty($tids)) {
                $data = C::t('#tab#tab')->fetch_by_tids($tids);
            }
            $next = true;
            //获取已查询总数
            if (count($tids) >= $perpage) {
                $total = $start + $perpage * 2 - 1;
                if (!$limitnum || $total <= $limitnum) {
                    $next = true;
                }else{
                    $next = false;
                }
            } else {
                $total = $start + count($tids);
                $next = false;
            }
            $gid = intval($tagval['id']);
            $gdata =C::t('#tab#tab_group')->fetch_by_gid($gid);
            $return = array(
                'tdid' => $tdid,
                'next' => $next,
                'count' => $count,
                'data' => $data ? $data : array(),
                'gdata'=>$gdata,
                'param' => array(
                    'page' => $page,
                    'perpage' => $perpage,
                )
            );
        }

    }
    exit(json_encode(['success' => true, 'data' => $return]));
} elseif ($do == 'getdata') {
    $pagedata = C::t('pichome_templatepage')->fetch_pagedata_by_id($id);
    exit(json_encode(['success' => true, 'data' => $pagedata]));
}else{
    include template('page/view');
}