function getResourceInfo($type, $id = 0, $localId = 0, $name = "")
{
$tblEntrance = new DB_Sso_Entrance();
$tblResource = new DB_Sso_Resource();
switch ($type) {
case Common_Config::PUBLIC_SCHOOL_TYPE:
$entrance = $tblEntrance->scalar("customer_name,customer_title,logo", "where id = {$id}");
return $entrance;
case Common_Config::PUBLIC_COURSE_TYPE || Common_Config::PUBLIC_CHAPTER_TYPE || Common_Config::PUBLIC_SECTION_TYPE:
if ($id) {
$course = $tblResource->scalar("name,entrance_id", "where id = {$id}");
$logo = $tblEntrance->scalar("logo", "where id = {$id}");
$course = array_merge($course, $logo);
return $course;
} else {
$schoolId = $tblResource->scalar("entrance_id", "where name='{$name}' and local_id = {$localId}");
//print_r($schoolId);
$logo = $tblEntrance->scalar("logo,customer_name", "where id = {$schoolId['entrance_id']}");
return $logo;
}
}
}
function searchBought($uid, $key)
{
//$key = "金";
$tblBought = new DB_Udo_UserBought();
$tblResource = new DB_Sso_Resource();
$tblEntrance = new DB_Sso_Entrance();
$tblSta = new DB_Udo_SchoolStatistics();
$tradeModel = new TradeModel();
//首先获取用户购买的课程和所在的频道
$bought = $tblBought->fetchAll("id,resourceId,schoolId", "where userId ={$uid} and resourceType = 2 ", "order by id asc");
//print_r($bought);
//print_r($bought);
$resultArray = [];
//接下来对逐个课程，获取频道的具体信息和课程的具体信息
foreach ($bought as $k => $value) {
$entrance = $tblEntrance->scalar("customer_name,customer_title,logo,api_udo_url", "where id = {$value['schoolId']} and (customer_name like '%{$key}%'\r\n or customer_title like '%{$key}%')");
$resource = $tblResource->scalar("name", "where id = {$value['resourceId']} and name like '%{$key}%'");
//如果搜索到了频道或课程包含关键词，再显示该条信息
if ($entrance || $resource) {
$sta = $tblSta->queryCount("where schoolId = {$value['schoolId']} group by userId");
if (!$sta) {
$sta = 0;
}
$entrance = $tblEntrance->scalar("customer_name,customer_title,logo,api_udo_url", "where id = {$value['schoolId']}");
$resource = $tblResource->scalar("name", "where id = {$value['resourceId']} ");
$info = $sta . "人已学";
//获取课程的localId供在列表中进行跳转
$localId = $tradeModel->getLocalId($value['resourceId'], $value['schoolId']);
array_push($resultArray, array("id" => $value['resourceId'], "localId" => $localId['local_id'], "logo" => $entrance['logo'], "name" => $resource['name'], "schoolName" => $entrance['customer_name'], "schoolTitle" => $entrance['customer_title'], "info" => $info, "schoolId" => $value['schoolId'], "apiUdoUrl" => $entrance['api_udo_url'], "courseType" => 0));
}
}
return $resultArray;
}
