exec("SET NAMES $cfg_db_language;"); } catch (PDOException $e) { echo 11; exit(12); } try { $sku_s = new PDO($sku_dsn, $sku_cfg_dbuser, $sku_cfg_dbpwd); $sku_s->exec("SET NAMES $cfg_db_language;"); } catch (PDOException $e) { echo 22; exit(34); } echo 33; $schoolCode = $schoolArr[$schoolId]['code']; $schoolName = $schoolArr[$schoolId]['name']; $departmentName = getNameById($common_s, $departmentId); $departmentName = str_replace("學習中心", "", $departmentName); $departmentList = getDepartments($common_s, $schoolId); switch ($examWay . $examTypeId) { case "B19": $file = "zpbs"; break; case "M19": $file = "zpms"; break; case "B20": $file = "zgbs"; break; case "M20": $file = "zgms"; break; default: $file = ""; } $urlList = "/mianshou/{$schoolCode}/{$file}{$departmentId}.html"; $courses = []; $courseList = []; $now = date('Y-m-d', time()); $sql = <<= '{$now}' GROUP BY c.id ORDER BY c.create_time DESC SQL; $stmt = $sku_s->prepare($sql); $stmt->execute(array(':exam_type_id' => $examTypeId, ':exam_way' => $examWay, ':branch_department_id' => $departmentId)); $courses = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($courses as $course) { $courseList[] = getCourseInfo($sku_s, $course['id']); } function getCourseInfo($sku_s, $courseId) { $sqlInfo = <<prepare($sqlInfo); $stmt->execute(array(':course_id' => $courseId)); $courseInfo = $stmt->fetch(PDO::FETCH_ASSOC); $sqlContent = <<prepare($sqlContent); $stmt->execute(array(':id' => $courseInfo['description_id'])); $description = $stmt->fetch(PDO::FETCH_COLUMN); $description = str_replace(array("\r\n", "\r", "\n", " "), "", $description); $course = array( 'id' => $courseInfo['id'], 'code' => $courseInfo['code'], 'name' => $courseInfo['name'], 'description' => $description, 'subject' => getSubjectNameByCourseId($sku_s, $courseId), 'goods' => getGoodsByCourseId($sku_s, $courseId) ); return $course; } function getSubjectNameByCourseId($sku_s, $courseId) { global $departmentId, $common_s, $now; $subjectIds = <<= '{$now}' SQL; $stmt = $sku_s->prepare($subjectIds); $stmt->execute(array(':course_id' => $courseId, ':branch_department_id' => $departmentId)); $subjectIds = $stmt->fetchAll(PDO::FETCH_COLUMN); $subject_ids = implode(",", $subjectIds); $sqlSubject = <<prepare($sqlSubject); $stmt->execute(array(':course_id' => $courseId)); $Subject = $stmt->fetchAll(PDO::FETCH_COLUMN); $SubjectName = implode(",", $Subject); return $SubjectName; } function getGoodsByCourseId($sku_s, $courseId) { global $departmentId, $now; $sql = <<= '{$now}' SQL; $stmt = $sku_s->prepare($sql); $stmt->execute(array(':course_id' => $courseId, ':branch_department_id' => $departmentId)); $goodsList = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($goodsList as &$goods) { $goods['info'] = getGoodsInfoByGoodsName($sku_s, $courseId, $goods['name']); } unset($goods); return $goodsList; } function getGoodsInfoByGoodsName($sku_s, $courseId, $goodsName) { global $departmentId, $now; $sql = <<= '{$now}' AND g.branch_department_id=:branch_department_id AND cg.course_id=:course_id SQL; $stmt = $sku_s->prepare($sql); $stmt->execute(array(':name' => $goodsName, ':course_id' => $courseId, ':branch_department_id' => $departmentId)); $goodsInfo = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($goodsInfo as &$item) { $item['refunds'] = getRefund($sku_s, $item['id']); } unset($item); return $goodsInfo; } function getRefund($sku_s, $goodsId) { $goodsRufundSql = <<prepare($goodsRufundSql); $stmt->execute(array(':goods_id' => $goodsId)); $goodsItem = $stmt->fetchAll(PDO::FETCH_ASSOC); $refunds = array(); foreach ($goodsItem as $item) { $price = $item['refund_amount'] / (float) 10000; $refunds[] = $item['result_desc'] . "退{$price}元"; } $refunds = implode(",", $refunds); return $refunds; } ?> 2020考試-培訓-教師考試輔導班-華圖教師網

Warning: count(): Parameter must be an array or an object that implements Countable in /data/www.2806499.live/mianshou/zsjz.php on line 276
查看全部地點

Warning: count(): Parameter must be an array or an object that implements Countable in /data/www.2806499.live/mianshou/zsjz.php on line 299
很抱歉!

暫時沒有面授課程

您可以選擇:

1、查看鄰近城市的面授課程!

2、點擊這里查看視頻課程信息!

3、點擊這里查看直播課程信息!

請選擇上課地點

所在城市:(已選)


    Warning: Invalid argument supplied for foreach() in /data/www.2806499.live/mianshou/zsjz.php on line 443
篮球比分直播网球探 福彩开奖直播现场 华鼎股份股票最新消 秒速赛车人工计划 福建麻将有金的规则 十一运夺金出号走势 西甲积分表 北京快中彩开奖号码公告 熊猫棋牌官网游戏下载安装 平码公式加7加12加22加9 东方6+1开奖查询