<?php /** * Created by PhpStorm. * User: tangxingguo * Date: 2017/7/25 * Time: 14:33 */ namespace Rpc\Controller\TaskCenter; use Com\PackageValidate; use Common\Common\Constant; use Common\Service\ArticleService; use Common\Service\ClassService; use Common\Service\RightService; class ListController extends \Rpc\Controller\AbstractController { /** * List * @author tangxingguo * @desc 获取课程列表接口 * @param Int page:1 页码 * @param Int limit:20 每页记录数 * @param Int class_id 分类ID * @param String keyword 标题关键字 * @return array array( 'page' => 1, // 页码 'limit' => 20, // 每页记录数 'total' => 200, // 记录总数 'list' => array( array( 'app_data_id' => '8852ce5784c43e6dddd942ae12d78fad', // 数据ID 'title' => '冰糖雪梨', // 标题 'class_name' => '企业文化', // 分类名称 'author' => '张三', // 作者 'status' => '已发布', // 状态 ), ), ) */ public function Index() { $postData = $this->_params; // 验证规则 $rules = [ 'page' => 'integer', 'limit' => 'integer', 'class_id' => 'integer', 'keyword' => 'max:64', ]; // 验证请求数据 $validate = new PackageValidate(); $validate->postData = $postData; $validate->validateParams($rules); // 分页 $postData['page'] = isset($postData['page']) ? $postData['page'] : Constant::PAGING_DEFAULT_PAGE; $postData['limit'] = isset($postData['limit']) ? $postData['limit'] : Constant::PAGING_DEFAULT_LIMIT; list($start, $perpage) = page_limit($postData['page'], $postData['limit']); // 条件 $conds = [ 'course_type' => Constant::COURSE_TYPE_TASK, 'article_status' => Constant::ARTICLE_STATUS_SEND, ]; if (strlen($postData['keyword']) > 0) { $conds['article_title like ?'] = '%' . $postData['keyword'] . '%'; } $classServ = new ClassService(); if ($postData['class_id'] != 0) { // 无限级取出当前分类及所有已启用的子分类ID $classIds = $classServ->getChildClassIds($postData['class_id']); $conds['class_id'] = $classIds; } else { // 最新课程列表,排除被禁用的分类 $isOpenClassIds = $classServ->getOpenClassIds(); $conds['class_id'] = $isOpenClassIds; } // 排序条件 $order_option = ['update_time' => 'desc']; // 课程列表 $list = []; $articleServ = new ArticleService(); $articleList = $articleServ->list_by_conds($conds, [$start, $perpage], $order_option); if (!empty($articleList)) { // 分类数据 $classIds = array_column($articleList, 'class_id'); $classList = $classServ->list_by_conds(['class_id' => $classIds]); if (!empty($classList)) { $classList = array_combine_by_key($classList, 'class_id'); } foreach ($articleList as $article) { $list[] = [ 'app_data_id' => $article['article_id'], 'title' => $article['article_title'], 'class_name' => isset($classList[$article['class_id']]) ? $classList[$article['class_id']]['class_name'] : '', 'author' => $article['ea_name'], 'status' => '已发布', ]; } // 总数 $total = $articleServ->count_by_conds($conds); } return [ 'page' => $postData['page'], 'limit' => $postData['limit'], 'total' => isset($total) ? $total : 0, 'list' => $list, ]; } }