# 學習統計功能（新版） #
## 1. 獲取mongodb數組
*D:\wamp\www\xue.test\xuetang\protected\modules\croom\controllers\ManageController.php*
~~~
/**
* 學習統計：掌握考點情況數據統計
* @author wangbo 2019-1-21
* @method GET
* @url croom/manage/myExerTagStatistics
* @param
* userID 必填
* end 默認當前日期
* begin 默認30天內
* @return json
*/
public function actionMyExerTagStatistics()
{
$userID = RequestUtils::getNormalRequest('userID'); //學生ID
$end = RequestUtils::getNormalRequest('end', (time() + 3600 * 24) * 1000);
$begin = RequestUtils::getNormalRequest('begin', (time() - 3600 * 24 * 30) * 1000); //默認是30天
$args['begin'] = $begin;
$args['end'] = $end;
$args['uid'] = $userID;
if (!$userID) {
//判斷是否是學生
ResponseUtils::json( null, 21, ResponseUtils::$rmsg[ 21 ] );
}
// 獲取學生的考點樹形數組（一級，三級）
$tagTree = V2StatisticsService::factory()->getTagTree($args);
$exers = V2StatisticsService::factory()->getAnswerExerRecordByUserID($args);
foreach ($exers as $v) {
foreach ($v['tags'] as $tag) {
if ($tag['tid'] == 3 && $tag['level'] == 1) {
$tagTree[$tag['tv']]['totalQuestion']++;
$tagTree[$tag['tv']]['totalScore']+=$v['total'];
$tagTree[$tag['tv']]['myTotalScore']+=$v['score'];
}
if ($tag['tid'] == 3 && $tag['level'] == 3) {
// 在樹形數組中找到對應的三級考點
foreach ($tagTree as $k => $item) {
if (in_array($tag['tv'], array_keys($item['subTag']))) {
$tagTree[$k]['subTag'][$tag['tv']]['totalQuestion']++;
$tagTree[$k]['subTag'][$tag['tv']]['totalScore']+=$v['total'];
$tagTree[$k]['subTag'][$tag['tv']]['myTotalScore']+=$v['score'];
}
}
}
}
}
// 計算得分率
foreach ($tagTree as $k => $v) {
if ($v['totalScore'] != 0) {
$tagTree[$k]['rate'] = round(($v['myTotalScore'] / $v['totalScore']) * 100);
}
foreach ($v['subTag'] as $i => $j) {
if ($j['totalScore'] != 0) {
$tagTree[$k]['subTag'][$i]['rate'] = round(($j['myTotalScore'] / $j['totalScore']) * 100);
}
}
}
// 去掉數組索引
$data = StatisticsService::factory()->unsetArrIndex($tagTree);
// 數組按照得分率rate進行從高到低的排序
$data = StatisticsService::factory()->sortDataArr($data);
foreach ($data as $k => $v) {
if ($v['subTag']) {
$data[$k]['subTag'] = StatisticsService::factory()->sortDataArr($v['subTag']);
}
}
if (!$tagTree) {
ResponseUtils::json(null, 1, 'error');
}
ResponseUtils::json(['data' => $data]);
}
~~~
*D:\wamp\www\xue.test\xuetang\protected\service\service2\V2StatisticsService.php*
~~~
/**
* 查找該用戶練習記錄的考點，組裝成二維數組
* @param $args
* @return array
*/
public function getTagTree($args)
{
/** @var EMongoClient $mongo */
$mongo = Yii::app()->mongodb;
$collection = $mongo->selectCollection(WK::XT_EXER_RECORD_COLLECTION);
$res = $this->getAnswerExerRecordByUserID($args);
$arr = []; //三級考點
foreach ($res as $v) {
foreach ($v['tags'] as $index => $item) {
if ($item['tid'] == 3 && $item['level'] == 3) {
if (!in_array($item['tv'], array_keys($arr))) {
$temp = [];
$temp['id'] = $parentID = $item['tv'];
$tag = Tag::model()->findByPk($item['tv']);
$temp['fdName'] = $tag->fdName;
$temp['totalQuestion'] = 0;
$temp['totalScore'] = 0;
$temp['myTotalScore'] = 0;
$arr[$item['tv']] = $temp;
}
}
}
}
$arr2 = []; //一級考點
foreach ($arr as $k => $v) {
$parent = TagService::factory()->getParentTag($v['id']);
if (!in_array($parent->id, array_keys($arr2))) {
$arr2[$parent->id]['id'] = $parent->id;
$arr2[$parent->id]['fdName'] = $parent->fdName;
$arr2[$parent->id]['totalQuestion'] = 0;
$arr2[$parent->id]['totalScore'] = 0;
$arr2[$parent->id]['myTotalScore'] = 0;
}
$arr2[$parent->id]['subTag'][$k] = $v;
}
return $arr2;
}
~~~
~~~
/* *
* 通過MongoDB獲取用戶的練習記錄
* @param $args
* @author wangbo 2019-2-21
*/
public function getAnswerExerRecordByUserID($args)
{
/** @var EMongoClient $mongo */
$mongo = Yii::app()->mongodb;
$collection = $mongo->selectCollection(WK::XT_EXER_RECORD_COLLECTION);
$args['begin'] = $args['begin'] ? new MongoDate($args['begin'] / 1000 + 8 * 60 * 60) : new MongoDate(strtotime('-1 year'));
$args['end'] = $args['end'] ? new MongoDate($args['end'] / 1000 + 8 * 60 * 60) : new MongoDate(time() + 8 * 60 * 60);
$res = $collection->aggregate(array(
array(
'$match' => array(
'uid' => (int)$args['uid'], //必須強制轉換為整型，如果是string類型，數據無法匹配
'date' => array(
'$gte' => $args['begin'],
'$lte' => $args['end'],
)
),
),
array(
'$project' => array(
'_id' => 0,
'exid' => 1,
'eid' => 1,
'tags' => 1,
'score' => 1,
'total' => 1,
'scoreRate' => 1,
'date' => 1,
),
),
array(
'$sort' => array(
'date' => -1, // 日期倒序
)
)
));
return (array)$res['result'];
}
~~~
## 2. 操作數組
*D:\wamp\www\xue.test\xuetang\protected\service\StatisticsService.php*
~~~
/**
* 將數組的值，按照數組中的rate值，從高到低進行排序
* @param $data
* @return array
* @author wangbo 2019-2-22
*/
public function sortDataArr($data)
{
$key = [];
//第一步：獲取rate數組并排序
foreach ($data as $k => $v) {
if (!in_array($v['rate'], array_values($key))) {
$key[] = $v['rate'];
}
}
rsort($key); //獲取到要排序的索引值得排序
//第二步：組裝數組
$arr2 = [];
foreach ($key as $v) {
foreach ($data as $i => $j) {
if ($j['rate'] == $v) {
$arr2[] = $j;
}
}
}
return $arr2;
}
/* *
* 去掉數組索引
* @param $tagTree
* @author wangbo 2019-2-22
*/
public function unsetArrIndex($tagTree)
{
$data = [];
foreach ($tagTree as $k => $v) {
$data[] = $v;
}
foreach ($data as $k => $v) {
$temp = [];
foreach ($v['subTag'] as $item) {
$temp[] = $item;
}
$data[$k]['subTag'] = $temp;
}
return $data;
}
~~~
- 說明
- 開發任務
- 星課-真光
- 課表
- Excel Down
- 調課
- 課表修改
- 課表代碼分析
- 課堂
- 課堂：應用商店通信管理協議
- 教師賬號強制綁定手機或郵箱
- 強制綁定手機和修改密碼的規則
- 學堂
- 課程學習：討論功能
- 后臺：課程討論管理
- 課程直播接口
- 學習統計功能(舊版)
- 學習統計功能(新版)
- 同步課程統計功能
- 同步課程編輯-新增視頻
- 第三方接口
- 學科網
- 安徽第三方
- 大賽
- 管控系統
- 日志管理
- 設備日志
- 平板接口
- 渝教
- 教學總結
- 空白目錄
- Yii 1.1
- 學堂架構
- Yii 1.1一些方法的解讀
- MVCS結構
- 基礎使用語法
- 創建1個新模塊
- 關聯模型
- CDbCriteria
- 學生-課堂記錄
- 學生端頁面展示
- 教師端頁面展示
- 編輯課程文檔
- SQL
- 課堂項目運行入口
- 上傳資源示意圖
- 行為
- PHPStorm
- 源碼閱讀
- 會診答卷頁面
- 考點練習
- 資源首頁
- 同步課程
- 同步課程：章節信息
- 升學復習
- 統計圖-范例
- 模塊
- 非法詞
- 服務層
- MongoDB類
- 學堂作答記錄從Mongo新集合獲取數據
- MongoYii
- 錯題集
- 小技巧
- 完善資料
- 郵件發送
- K12
- JSpang視頻課程
- MongoDB
- 創業
- 項目
- 包包