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;
}
