Symfony Profiler

<?php
namespace AppBundle\Controller;
use AppBundle\Common\ArrayToolkit;
use AppBundle\Common\Paginator;
use AppBundle\Component\MediaParser\ParserProxy;
use Biz\CloudLive\Service\LiveService;
use Biz\Course\Service\CourseService;
use Biz\Course\Service\MaterialService;
use Biz\File\Service\UploadFileService;
use Biz\User\Service\UserService;
use Symfony\Component\HttpFoundation\Request;
/**
* Class MediaProccessController
* 用来处理活动中文件选取(上传，从资料库选择，从课程文件选择，导入网络文件)逻辑.
*/
class FileChooserController extends BaseController
{
public function materialChooseAction(Request $request)
{
$currentUser = $this->getUser();
if (!$currentUser->isTeacher() && !$currentUser->isAdmin()) {
throw $this->createAccessDeniedException('Permission denied, you can not access this page!');
}
$conditions = $request->query->all();
$conditions = $this->filterMaterialConditions($conditions, $currentUser);
$paginator = new Paginator(
$request,
$this->getUploadFileService()->searchFileCount($conditions),
20
);
$files = $this->getUploadFileService()->searchFiles(
$conditions,
['createdTime' => 'DESC'],
$paginator->getOffsetCount(),
$paginator->getPerPageCount()
);
$createdUsers = $this->getUserService()->findUsersByIds(ArrayToolkit::column($files, 'createdUserId'));
$createdUsers = ArrayToolkit::index($createdUsers, 'id');
return $this->render(
'file-chooser/widget/choose-table.html.twig',
[
'files' => $files,
'createdUsers' => $createdUsers,
'paginator' => $paginator,
]
);
}
public function findMySharingContactsAction(Request $request)
{
$user = $this->getUser();
if (!$user->isTeacher() && !$user->isAdmin()) {
throw $this->createAccessDeniedException('Permission denied, you can not access this page!');
}
$mySharingContacts = $this->getUploadFileService()->findMySharingContacts($user['id']);
return $this->createJsonResponse($mySharingContacts);
}
public function courseFileChooseAction(Request $request, $courseId)
{
$currentUser = $this->getUser();
if (!$currentUser->isTeacher() && !$currentUser->isAdmin()) {
throw $this->createAccessDeniedException('Permission denied, you can not access this page!');
}
$query = $request->query->all();
$courseMaterials = $this->findCourseMaterials($request, $courseId);
$conditions = [];
$conditions['page'] = $request->query->get('page', 1);
$conditions['ids'] = $courseMaterials ? ArrayToolkit::column($courseMaterials, 'fileId') : [-1];
$conditions['type'] = (empty($query['type']) || 'all' == $query['type']) ? null : $query['type'];
$conditions['filenameLike'] = empty($query['keyword']) ? null : $query['keyword'];
$paginator = new Paginator(
$request,
$this->getUploadFileService()->searchFileCount($conditions),
20
);
$files = $this->getUploadFileService()->searchFiles(
$conditions,
['createdTime' => 'DESC'],
$paginator->getOffsetCount(),
$paginator->getPerPageCount()
);
$createdUsers = $this->getUserService()->findUsersByIds(ArrayToolkit::column($files, 'createdUserId'));
$createdUsers = ArrayToolkit::index($createdUsers, 'id');
return $this->render(
'file-chooser/widget/choose-table.html.twig',
[
'files' => $files,
'createdUsers' => $createdUsers,
'paginator' => $paginator,
]
);
}
public function importAction(Request $request, $courseId)
{
$url = $request->query->get('url');
try {
$proxy = new ParserProxy();
$item = $proxy->parseItem($url);
} catch (\Exception $e) {
return $this->createJsonResponse(['error' => $e->getMessage()]);
}
return $this->createJsonResponse($item);
}
public function liveReplayAction(Request $request)
{
$conditions = $this->buildLiveReplaySearchConditions($request);
$paginator = new Paginator(
$request,
$this->getLiveService()->countLive($conditions),
5
);
$replays = $this->getLiveService()->searchLive(
$conditions,
['id' => 'DESC'],
$paginator->getOffsetCount(),
$paginator->getPerPageCount()
);
return $this->render('file-chooser/widget/live-replay-table.html.twig', [
'lives' => $replays,
'paginator' => $paginator,
]);
}
protected function buildLiveReplaySearchConditions($request)
{
$type = $request->query->get('type', 'manage');
if (!in_array($type, ['manage', 'teach'], true)) {
$type = 'manage';
}
$conditions = [
'title' => $request->query->get('title', ''),
'excludeReplayId' => 0,
'isFinished' => 1,
];
if ('teach' == $type) {
$conditions['userId'] = $this->getCurrentUser()->getId();
}
if ('manage' == $type) {
$conditions['ids'] = $this->getLiveService()->getManageableLiveIds($conditions);
}
return $conditions;
}
protected function filterMaterialConditions($conditions, $currentUser)
{
$conditions['status'] = 'ok';
$conditions['currentUserId'] = $currentUser['id'];
$conditions['noTargetType'] = 'attachment';
if (!empty($conditions['keyword'])) {
$conditions['filename'] = $conditions['keyword'];
unset($conditions['keyword']);
}
if ('live' == $conditions['type']) {
unset($conditions['type']);
$conditions['types'] = ['ppt', 'document'];
} else {
$conditions['type'] = (empty($conditions['type']) || ('all' == $conditions['type'])) ? null : $conditions['type'];
}
return $conditions;
}
protected function findCourseMaterials($request, $courseId)
{
$courseType = $request->query->get('courseType', 'course');
$conditions = ['type' => $courseType];
if ('openCourse' == $courseType) {
$conditions['courseId'] = $courseId;
} else {
$course = $this->getCourseService()->getCourse($courseId);
$conditions['courseSetId'] = $course['courseSetId'];
}
//FIXME 同一个courseId下文件可能存在重复，所以需考虑去重，但没法直接根据groupbyFileId去重（sql_mode）
$courseMaterials = $this->getMaterialService()->searchMaterials(
$conditions,
['createdTime' => 'DESC'],
0,
PHP_INT_MAX
);
return $courseMaterials;
}
/**
* @return UploadFileService
*/
protected function getUploadFileService()
{
return $this->createService('File:UploadFileService');
}
/**
* @return UserService
*/
protected function getUserService()
{
return $this->createService('User:UserService');
}
/**
* @return MaterialService
*/
protected function getMaterialService()
{
return $this->createService('Course:MaterialService');
}
/**
* @return CourseService
*/
protected function getCourseService()
{
return $this->createService('Course:CourseService');
}
/**
* @return LiveService
*/
protected function getLiveService()
{
return $this->createService('CloudLive:LiveService');
}
}

src/AppBundle/Controller/FileChooserController.php line 64