function bannerData($schoolId, $uid) { $tblUserBought = new DB_Udo_UserBought(); $resourceCourse = Common_Config::UDO_RESOURCE_COURSE; //$boughtCount = $tblUserBought->queryCount("where schoolId = {$schoolId} group by userId"); $boughtCount = count($tblUserBought->fetchAll("*", "where schoolId = {$schoolId} group by userId")); //print_r("model:".$boughtCount." ;"); $courseCount = $tblUserBought->queryCount("where schoolId = {$schoolId} and resourceType ={$resourceCourse} \n and userId = {$uid}"); //print_r($courseCount); return array("boughtCount" => $boughtCount, "courseCount" => $courseCount); }
function getCustomerNumber($schoolId, $courseId = 0) { $tblUserBought = new DB_Udo_UserBought(); $where = "where schoolId = {$schoolId}"; $resourceCourse = Common_Config::UDO_RESOURCE_COURSE; if ($courseId) { $where .= " and resourceId = {$courseId} and resourceType = {$resourceCourse}"; } $queryCount = $tblUserBought->queryCount($where); return $queryCount; }
function getBought($uid = 0, $previousId = 0, $pageSize = 20, $startTime = 0, $endTime = 0, $page = 1) { $tblBought = new DB_Udo_UserBought(); $tblResource = new DB_Sso_Resource(); $tblEntrance = new DB_Sso_Entrance(); $tblSta = new DB_Udo_SchoolStatistics(); $tradeModel = new TradeModel(); $userModel = new UserModel(); if (!$previousId) { $previousId = 0; } $where = "where resourceType = 2"; if ($uid) { $where .= " and userId = {$uid}"; } if ($previousId) { $where .= " and id<{$previousId}"; } if ($startTime || $endTime) { if (!$endTime) { $where .= " and createTime >= {$startTime}"; } else { $where .= " and createTime >={$startTime} and createTime <= {$endTime}"; } } $boughtCount = $tblBought->queryCount($where); //首先获取用户购买的课程和所在的频道 $bought = $tblBought->fetchLimit("userId,id,resourceId,schoolId,orderId,createTime", $where, "order by id desc", $page, $pageSize); //print_r($bought); $newArray = []; //接下来对逐个课程,获取频道的具体信息和课程的具体信息 foreach ($bought as $k => $value) { $entrance = $tblEntrance->scalar("customer_name,customer_title,logo,api_udo_url", "where id = {$value['schoolId']}"); //$sta = $tblSta->queryCount("where schoolId = {$value['schoolId']} group by userId"); $staResult = $tblSta->fetchAll("*", "where schoolId = {$value['schoolId']} group by userId"); $sta = count($staResult); //print_r($sta." "); if (!$sta) { $sta = 0; } $info = $sta . "人已学"; $resource = $tblResource->scalar("name", "where id = {$value['resourceId']}"); //获取课程的localId供在列表中进行跳转 $localId = $tradeModel->getLocalId($value['resourceId'], $value['schoolId']); $value['mobile'] = $userModel->getUserName($value['userId'])['mobile']; $value['userName'] = $userModel->getUserName($value['userId'])['name']; $newArray[$k] = array("listId" => $value['id'], "id" => $value['resourceId'], "userId" => $value['userId'], "mobile" => $value['mobile'], "userName" => $value['userName'], "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, "orderId" => $value['orderId'], "createTime" => date("Y-m-d H:i:s", $value['createTime'])); } return array("bought" => $newArray, "boughtCount" => $boughtCount); }