# 后臺：課程討論管理 # 獲取課程討論內容 - 支持分頁 - 支持條件查詢：按舉報情況、按狀態、按關鍵字(姓名、賬號、內容) 查看評論 批量刪除 修改舉報狀態 ## 獲取課程評價 CourseCenterService::factory()->countCourseComments($args) ``` public function findCourseComment( $args ) { $criteria = new CDbCriteria(); $with = array(); if ( $args[ "keyWord" ] ) { $with[ ] = "course"; $with[ ] = "user"; $criteria->addSearchCondition( "course.fdName", $args[ "keyWord" ], true ); $criteria->addSearchCondition( "user.fdName", $args[ "keyWord" ], true, "OR" ); } if ( $args['id'] ) $criteria->compare( 't.id', $args['id'] ); if ( $args[ "courseID" ] ) $criteria->compare( "t.fdCourseID", $args[ "courseID" ] ); // 評論對象類型 if (is_numeric($args['type'])) $criteria->compare( "t.fdType", $args[ "type" ] ); // 課程小節 if ( $args['courseCatalogID'] ) $criteria->compare( "t.fdCourseCatalogID", $args[ "courseCatalogID" ] ); // 評論父ID if ( is_numeric($args['parentID']) ) $criteria->compare( "t.fdParentID", $args[ "parentID" ] ); if ( $args[ "courseUserID" ] ) { $with[ ] = "course"; $criteria->compare( "course.fdUserID", $args[ "courseUserID" ] ); } // add is_numeric function to fix zero by wuzhc 2018-12-17 if ( is_numeric( $args[ "status" ] ) ) $criteria->compare( "t.fdStatus", $args[ "status" ] ); if ( $args[ "star" ] ) $criteria->compare( "t.fdStar", $args[ "star" ] ); if ( $args[ "appraiseLevel" ] ) { ( $args[ "appraiseLevel" ] == 3 ) && $criteria->addCondition( "t.fdStar>=1 and t.fdStar<=2" ); ( $args[ "appraiseLevel" ] == 2 ) && $criteria->addCondition( "t.fdStar=3" ); ( $args[ "appraiseLevel" ] == 1 ) && $criteria->addCondition( "t.fdStar>=4 and t.fdStar<=5" ); } if ( $args[ 'select' ] ) { $criteria->select = $args[ 'select' ]; } if ( $args[ 'group' ] ) { $criteria->group = $args[ 'group' ]; } if ($args['order']) { $criteria->order = $args['order']; } else { $criteria->order = "t.fdCreate desc"; } $criteria->offset = $args[ "start" ] ? : 0; $criteria->limit = $args[ "len" ] ? : 10; $criteria->with = is_array( $args[ 'with' ] ) ? array_merge( $with, $args[ 'with' ] ) : $with; return $criteria; } ```