WooYun.org

<?php
namespace Topxia\WebBundle\Controller;
use Symfony\Component\HttpFoundation\Request;
use Topxia\Common\Paginator;
use Topxia\Common\ArrayToolkit;
class SearchController extends BaseController
{
    public function indexAction(Request $request)
    {
        $courses = $paginator = null;
        $code = 'Vip';
        $currentUser = $this->getCurrentUser();
        $keywords = $request->query->get('q');
        $keywords=trim($keywords);
        
        $vip = $this->getAppService()->findInstallApp($code);
        $isShowVipSearch = $vip && version_compare($vip['version'], "1.0.7", ">=");
        
        $currentUserVipLevel = "";
        $vipLevelIds = "";
        if($isShowVipSearch){
            $currentUserVip = $this->getVipService()->getMemberByUserId($currentUser['id']);
            $currentUserVipLevel = $this->getLevelService()->getLevel($currentUserVip['levelId']);
            $vipLevels = $this->getLevelService()->findAllLevelsLessThanSeq($currentUserVipLevel['seq']);
            $vipLevelIds = ArrayToolkit::column($vipLevels, "id");
        }
        $parentId = 0;
        $categories = $this->getCategoryService()->findAllCategoriesByParentId($parentId);
        
        $categoryIds=array();
        for($i=0;$i<count($categories);$i++){
            $id = $categories[$i]['id'];
            $name = $categories[$i]['name'];
            $categoryIds[$id] = $name;
        }
        $categoryId = $request->query->get('categoryIds');
        $coursesTypeChoices = $request->query->get('coursesTypeChoices');       
        if (!$keywords) {
            goto response;
        }
        if($coursesTypeChoices == 'vipCourses'){
            $conditions = array(
                'status' => 'published',
                'title' => $keywords,
                'categoryId' => $categoryId,
                'vipLevelIds' =>  $vipLevelIds
            );
        }elseif($coursesTypeChoices == 'liveCourses'){
            $conditions = array(
                'status' => 'published',
                'title' => $keywords,
                'categoryId' => $categoryId,
                'type' => 'live'
            );
        }else{
            $conditions = array(
                'status' => 'published',
                'title' => $keywords,
                'categoryId' => $categoryId
            );
        }
        $paginator = new Paginator(
            $this->get('request'),
            $this->getCourseService()->searchCourseCount($conditions)
            , 10
        );
        $courses = $this->getCourseService()->searchCourses(
            $conditions,
            'latest',
            $paginator->getOffsetCount(),
            $paginator->getPerPageCount()
        );
        response:
        return $this->render('TopxiaWebBundle:Search:index.html.twig', array(
            'courses' => $courses,
            'paginator' => $paginator,
            'keywords' => $keywords,
            'isShowVipSearch' => $isShowVipSearch,
            'currentUserVipLevel' => $currentUserVipLevel,
            'categoryIds' => $categoryIds,
            'coursesTypeChoices' => $coursesTypeChoices
        ));
    }
...