[TOC] # 學堂作答記錄從mongo新集合獲取數據 # https://tower.im/teams/46865/todos/27502/ ## 學堂WEB通信協議 本協議包含： - 服務器向mongo請求統計數據協議 - 客戶端向mongo請求心急數據協議 - 客戶端向服務器請求網頁相關內容協議 https://tower.im/teams/46865/documents/4408/ ## MongoDB類 http://php.net/manual/zh/class.mongodb.php 技術文檔： http://www.mongoing.com/docs/index.html ## 練習記錄 ``` /** @var EMongoClient $mongo */ $mongo = Yii::app()->mongodb; $collection = $mongo->selectCollection(WK::XT_EXER_RECORD_COLLECTION); $args['begin'] = 1548172800; $args['end'] = 1550764800; $res = $collection->aggregate( array( '$match' => array( 'uid' => 474598, 'date' => array( '$gte' => new MongoDate($args['begin']), '$lte' => new MongoDate($args['end']), ) ), ), array( '$project' => array( '_id' => 1, 'exid' => 1, 'eid' => 1, 'tags' => 1, 'score' => 1, 'total' => 1, 'scoreRate' => 1, 'date' => 1, ), ), array( '$sort' => array( 'date' => -1, // 日期倒序 ) ) ); ``` ## ## 接口： http://t.wmxuetang.com/index.php?r=croom/exam/GetSortTagsAndAlias&answerExamID=1913303&examID=140399&_t=t ``` { "tags": [ { "tagid": "53605", "name": "集合的基本運算", "rate": 0, "rate_all": 57 }, { "tagid": "53612", "name": "函數的概念、要素、表示法", "rate": 0, "rate_all": 26 }, { "tagid": "53620", "name": "對數函數", "rate": 0, "rate_all": 16 }, { "tagid": "53627", "name": "函數的綜合應用", "rate": 0, "rate_all": 6 }, { "tagid": "53629", "name": "導數的概念和運算", "rate": 0, "rate_all": 13 }, { "tagid": "53631", "name": "導數的綜合應用（2）", "rate": 0, "rate_all": 6 }, { "tagid": "53634", "name": "簡單幾何體", "rate": 0, "rate_all": 18 }, { "tagid": "53635", "name": "直觀圖與三視圖", "rate": 0, "rate_all": 41 }, { "tagid": "53646", "name": "平面向量的數量積", "rate": 0, "rate_all": 12 }, { "tagid": "53651", "name": "空間向量的基本概念和運算", "rate": 0, "rate_all": 9 }, { "tagid": "53654", "name": "向量的綜合應用", "rate": 0, "rate_all": 9 }, { "tagid": "53662", "name": "圓的位置關系", "rate": 0, "rate_all": 13 }, { "tagid": "53667", "name": "橢圓（2）", "rate": 0, "rate_all": 6 }, { "tagid": "53670", "name": "拋物線（2）", "rate": 0, "rate_all": 8 }, { "tagid": "53672", "name": "雙曲線（1）", "rate": 0, "rate_all": 17 }, { "tagid": "53675", "name": "圓錐曲線綜合問題", "rate": 0, "rate_all": 12 }, { "tagid": "53683", "name": "三角恒等變換", "rate": 100, "rate_all": 38 }, { "tagid": "53686", "name": "解三角形（2）", "rate": 0, "rate_all": 25 }, { "tagid": "53694", "name": "等比數列", "rate": 0, "rate_all": 10 }, { "tagid": "53709", "name": "統計抽樣和圖表", "rate": 0, "rate_all": 11 }, { "tagid": "53712", "name": "變量的相關性與統計案例", "rate": 0, "rate_all": 11 }, { "tagid": "53716", "name": "概率的綜合應用", "rate": 100, "rate_all": 24 }, { "tagid": "53727", "name": "復數的四則運算", "rate": 0, "rate_all": 36 }, { "tagid": "53731", "name": "二項式定理", "rate": 100, "rate_all": 34 }, { "tagid": "67494", "name": "選考內容", "rate": 0, "rate_all": 5 } ], "main_tags": [ { "tagid": "53601", "name": "集合與常用邏輯用語", "rate": 0, "rate_all": 57 }, { "tagid": "53610", "name": "函數與導數", "rate": 0, "rate_all": 11 }, { "tagid": "53632", "name": "立體幾何和向量", "rate": 0, "rate_all": 15 }, { "tagid": "53655", "name": "解析幾何", "rate": 0, "rate_all": 10 }, { "tagid": "53676", "name": "三角函數和解三角形", "rate": 50, "rate_all": 31 }, { "tagid": "53688", "name": "數列和不等式", "rate": 0, "rate_all": 10 }, { "tagid": "53702", "name": "算法、統計、概率", "rate": 17, "rate_all": 13 }, { "tagid": "53721", "name": "推理、復數、計數", "rate": 50, "rate_all": 35 }, { "tagid": "67491", "name": "擴展部分", "rate": 0, "rate_all": 5 } ], "alias": [ { "id": 300, "name": "單選題", "rate": 25, "rate_all": 41 }, { "id": 303, "name": "填空題", "rate": 0, "rate_all": 16 }, { "id": 308, "name": "綜合題", "rate": 0, "rate_all": 11 } ], "score": { "total": 160, "score": 15, "score_obj": 0, "score_avg": 26.42, "score_top": 129, "beat_rate": 0.43, "rate": 50 }, "$diffPer": { "easy": 17.39, "moderate": 56.52, "difficult": 26.09 }, "num": { "unRight": 20, "right": 3 }, "unselfNum": 11 } ``` *D:\wamp\www\xue.test\xuetang\protected\modules\croom\controllers\ExamController.php*