function getCoursePrice($courseId, $uid) { $tblResource = new DB_Sso_Resource(); $tblUserBought = new DB_Udo_UserBought(); $courseType = Common_Config::UDO_RESOURCE_COURSE; $priceInfo = $tblResource->scalar("cur_price,price_type", "where id = {$courseId} and enabled = 1"); $isBought = $tblUserBought->scalar("id", "where resourceType = {$courseType} and userId = {$uid} and resourceId = {$courseId}"); //print_r($isBought); return array("price" => $priceInfo['cur_price'], "priceType" => $priceInfo['price_type'], "isBought" => $isBought ? 1 : 0); }
function testBought() { $tblUser = new DB_Sso_User(); $tblBought = new DB_Udo_UserBought(); $tblEntrance = new DB_Sso_Entrance(); $tblResource = new DB_Sso_Resource(); $entranceIds = $tblEntrance->fetchAll("id", "where id%3=0"); $entranceIdsPart = $tblEntrance->fetchAll("id", "where id%3=1 or id%3=2"); $userIds = $tblUser->fetchAll("id"); //$entranceId = $tblEntrance->scalar("id"); foreach ($userIds as $k => $value) { //首先对所有模3为0的,全部购买 foreach ($entranceIds as $m => $val) { $resourceIds = $tblResource->fetchAll("id", "where entrance_id = {$val['id']} and type = 6"); $insert = $tblBought->insert(array("userId" => $value['id'], "resourceId" => $val['id'], "resourceType" => 1, "schoolId" => $val['id'], "createTime" => time())); foreach ($resourceIds as $n => $v) { $tblBought->insert(array("userId" => $value['id'], "resourceId" => $v['id'], "resourceType" => 2, "schoolId" => $val['id'], "createTime" => time())); } } foreach ($entranceIdsPart as $l => $v2) { $resourceId = $tblResource->scalar("id", "where entrance_id = {$v2['id']} and type = 6"); $tblBought->insert(array("userId" => $value['id'], "resourceId" => $resourceId['id'], "resourceType" => 2, "schoolId" => $v2['id'], "createTime" => time())); } } }
function alterAccount($uid, $schoolId) { $tblSchoolPrice = new DB_Udo_SchoolPrice(); $tblResource = new DB_Sso_Resource(); $tblBought = new DB_Udo_UserBought(); $tblOrder = new DB_Udo_Order(); $schoolPrice = $tblSchoolPrice->scalar("*", "where resourceId = {$schoolId}"); $courseType = Common_Config::PUBLIC_COURSE_TYPE; $free = Common_Config::UDO_PRICETYPE_FREE; $course = $tblResource->fetchAll("id", "where type = {$courseType} and price_type <> {$free} and entrance_id = {$schoolId}"); $resource = []; foreach ($course as $key => $value) { array_push($resource, array("resourceType" => 2, "resourceId" => $value['id'])); } //print_r($resource); $courseIds = $tblResource->columnRow($course, "id"); $resourceType = Common_Config::UDO_RESOURCE_COURSE; $newOrder = $tblOrder->insert(array("userId" => $uid, "resource" => json_encode($resource), "createTime" => time(), "status" => Common_Config::ORDER_SUCCESS, "payType" => $schoolPrice['priceType'] == 1 ? 2 : 1)); foreach ($courseIds as $key => $value) { $tblBought->insert(array("resourceId" => $value, "userId" => $uid, "schoolId" => $schoolId, "createTime" => time(), "resourceType" => $resourceType, "orderId" => $newOrder)); } return 1; }