<?php
|
/**
|
* 微课堂搜索页
|
* ============================================================================
|
* 版权所有 2015-2020 ，并保留所有权利。
|
* 网站地址:
|
* ----------------------------------------------------------------------------
|
|
* ============================================================================
|
*/
|
|
if((!$userAgent && in_array('search', $login_visit)) || ($userAgent && !$comsetting['hidden_login'])){
|
checkauth();
|
}
|
|
$systemType = $site_common->checkSystenType(); /* 手机操作系统 */
|
$site_common->check_black_list('visit', $_W['member']['uid']);
|
|
/* 自定义字体 */
|
$index_page = $common['index_page'];
|
$already_study = $common['index_page']['studyNum'] ? $common['index_page']['studyNum'] : '人已学习';
|
|
/* 全部分类图标 */
|
$all_category_ico = $setting['category_ico'] ? $_W['attachurl'].$setting['category_ico'] : MODULE_URL."template/mobile/{$template}/images/ico-allcategory.png";
|
|
$pindex = max(1, intval($_GPC['page']));
|
$psize = 10;
|
|
/* 全部分类 */
|
$hot_category = pdo_fetchall("SELECT * FROM " . tablename($this -> table_category) . " WHERE uniacid=:uniacid AND is_hot=:is_hot AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid' => $uniacid, ':is_hot' => 1,':search_show'=>1));
|
$categorylist = pdo_fetchall("SELECT * FROM " . tablename($this -> table_category) . " WHERE uniacid=:uniacid AND parentid=:parentid AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid'=>$uniacid, ':parentid'=>0,':search_show'=>1));
|
|
foreach ($categorylist as $k => $v) {
|
$categorylist[$k]['child'] = pdo_fetchall("SELECT * FROM " . tablename($this -> table_category) . " WHERE uniacid=:uniacid AND parentid=:parentid AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid'=>$uniacid, ':parentid'=>$v['id'],':search_show'=>1));
|
}
|
|
/* 知识点分类 */
|
$hot_knowledge = pdo_fetchall("SELECT * FROM " . tablename("fy_lesson_knowledge_point") . " WHERE uniacid=:uniacid AND is_hot=:is_hot AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid' => $uniacid, ':is_hot' => 1,':search_show'=>1));
|
$knowledgelist = pdo_fetchall("SELECT * FROM " . tablename("fy_lesson_knowledge_point") . " WHERE uniacid=:uniacid AND parentid=:parentid AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid'=>$uniacid, ':parentid'=>0,':search_show'=>1));
|
|
foreach ($knowledgelist as $k => $v) {
|
$knowledgelist[$k]['child'] = pdo_fetchall("SELECT * FROM " . tablename("fy_lesson_knowledge_point") . " WHERE uniacid=:uniacid AND parentid=:parentid AND search_show=:search_show ORDER BY displayorder DESC", array(':uniacid'=>$uniacid, ':parentid'=>$v['id'],':search_show'=>1));
|
}
|
|
if ($op == 'display') {
|
|
$keyword = trim($_GPC['keyword']);
|
$pid = $_GPC['pid'];
|
$cat_id = $_GPC['cat_id'];
|
$sort = trim($_GPC['sort']);
|
$attr1 = $_GPC['attr1'];
|
$attr2 = $_GPC['attr2'];
|
$know_id = $_GPC['knowledge_id'];
|
|
$condition = " a.uniacid = '{$uniacid}' AND a.status=1 ";
|
$order = " ORDER BY a.displayorder DESC, a.id DESC ";
|
|
if (!empty($keyword)) {
|
$condition .= " AND (a.bookname LIKE '%{$keyword}%' OR b.teacher LIKE '%{$keyword}%') ";
|
}
|
if ($cat_id > 0) {
|
$condition .= " AND (a.pid='{$cat_id}' OR a.cid='{$cat_id}')";
|
$nowcat = pdo_fetch("SELECT name FROM " . tablename($this -> table_category) . " WHERE uniacid='{$uniacid}' AND id='{$cat_id}'");
|
$catname = $nowcat['name'];
|
} else {
|
$catname = $common['page_title']['search'] ? $common['page_title']['search'] : '全部分类';
|
}
|
|
/* 按知识点搜索 */
|
if ($know_id > 0) {
|
$condition .= " AND (a.knowledge_pid='{$know_id}' OR a.knowledge_id='{$know_id}')";
|
$nowknow = pdo_fetch("SELECT name FROM " . tablename("fy_lesson_knowledge_point") . " WHERE uniacid='{$uniacid}' AND id='{$know_id}'");
|
$knowledgename = $nowknow['name'];
|
} else {
|
$knowledgename = $common['page_title']['search'] ? $common['page_title']['search'] : '知识点';
|
}
|
|
/* 综合排序 */
|
if ($sort == 'general') {
|
$condition .= " AND a.lesson_type=0";
|
$sortname = '普通课程';
|
} elseif ($sort == 'apply') {
|
$condition .= " AND a.lesson_type=1";
|
$sortname = '报名课程';
|
} elseif ($sort == 'live') {
|
$condition .= " AND a.lesson_type=3";
|
$sortname = '直播课程';
|
} elseif ($sort == 'knowledge') {
|
$condition .= " AND a.lesson_type=5";
|
$sortname = '知识点课';
|
} elseif ($sort == 'price') {
|
$order = " ORDER BY a.price ASC, a.displayorder DESC ";
|
$sortname = '价格优先';
|
} elseif ($sort == 'price') {
|
$order = " ORDER BY a.price ASC, a.displayorder DESC ";
|
$sortname = '价格优先';
|
} elseif ($sort == 'hot') {
|
$order = " ORDER BY (a.buynum+a.virtual_buynum) DESC, a.displayorder DESC ";
|
$sortname = '人气优先';
|
} elseif ($sort == 'score') {
|
$order = " ORDER BY a.score DESC, a.displayorder DESC ";
|
$sortname = '好评优先';
|
} else {
|
$sortname = '综合排序';
|
}
|
|
/* 课程属性 */
|
$lesson_attribute = $common['lesson_attribute'];
|
$attribute1 = pdo_fetchall("SELECT * FROM " .tablename($this->table_attribute). " WHERE uniacid=:uniacid AND attr_type=:attr_type ORDER BY displayorder DESC", array(':uniacid'=>$uniacid,':attr_type'=>'attribute1'));
|
$attribute2 = pdo_fetchall("SELECT * FROM " .tablename($this->table_attribute). " WHERE uniacid=:uniacid AND attr_type=:attr_type ORDER BY displayorder DESC", array(':uniacid'=>$uniacid,':attr_type'=>'attribute2'));
|
if($attr1){
|
$condition .= " AND attribute1={$attr1}";
|
$now_attr1 = pdo_get($this->table_attribute, array('uniacid'=>$uniacid,'id'=>$attr1), array('name'));
|
$attr1_name = $now_attr1['name'];
|
}else{
|
$attr1_name = $lesson_attribute['attribute1'];
|
}
|
if($attr2){
|
$condition .= " AND attribute2={$attr2}";
|
$now_attr2 = pdo_get($this->table_attribute, array('uniacid'=>$uniacid,'id'=>$attr2), array('name'));
|
$attr2_name = $now_attr2['name'];
|
}else{
|
$attr2_name = $lesson_attribute['attribute2'];
|
}
|
|
$list = pdo_fetchall("SELECT a.* FROM " . tablename($this -> table_lesson_parent) . " a LEFT JOIN " . tablename($this -> table_teacher) . " b ON a.teacherid=b.id WHERE {$condition} {$order} LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
|
foreach ($list as $k=>$v) {
|
$v['soncount'] = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename($this -> table_lesson_son) . " WHERE parentid=:parentid", array(':parentid'=>$v['id']));
|
if($v['price']>0){
|
$v['buyTotal'] = $v['buynum'] + $v['virtual_buynum'] + $v['vip_number'] + $v['teacher_number'];
|
}else{
|
$v['buyTotal'] = $v['buynum'] + $v['virtual_buynum'] + $v['visit_number'] + $v['teacher_number'] + $v['vip_number'];
|
}
|
|
$v['score_rate'] = $v['score'] ? $v['score']*100 : '';
|
$v['score_rate'] = $v['score_rate']>100 ? 100 : $v['score_rate'];
|
|
$v['discount'] = $site_common->getLessonDiscount($v['id']);
|
$v['price'] = round($v['price']*$v['discount'], 2);
|
if($v['discount']<1 && !$v['ico_name']){
|
$v['ico_name'] = 'ico-discount';
|
}
|
|
if($v['lesson_type']==3){
|
$live_info = json_decode($v['live_info'], true);
|
$starttime = strtotime($live_info['starttime']);
|
$endtime = strtotime($live_info['endtime']);
|
if(time() < $starttime){
|
$v['icon_live_status'] = 'icon-live-nostart';
|
}elseif(time() > $endtime){
|
$v['icon_live_status'] = 'icon-live-ended';
|
}elseif(time() > $starttime && time() < $endtime){
|
$v['icon_live_status'] = 'icon-live-starting';
|
}
|
$v['learned_hide'] = 'hide';
|
unset($v['soncount']);
|
}
|
|
$list[$k] = $v;
|
}
|
|
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename($this->table_lesson_parent) . " a LEFT JOIN " .tablename($this->table_teacher). " b ON a.teacherid=b.id WHERE {$condition} ");
|
|
if (!empty($keyword)) {
|
$title = $keyword;
|
} else{
|
$title = $catname;
|
}
|
|
if($_W['isajax']){
|
$this->resultJson($list);
|
}
|
|
}elseif ($op == 'allcategory') {
|
$title = "全部分类";
|
}
|
|
include $this->template("../mobile/{$template}/search");
|
