src/AppBundle/Controller/SearchController.php line 222

Open in your IDE?
  1. <?php
  2. namespace AppBundle\Controller;
  4. use Doctrine\ORM\Query\Expr\Func;
  5. use Symfony\Component\Routing\Annotation\Route;
  7. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\HttpFoundation\Session\Session;
  12. use AppBundle\Includes\Database;
  13. use AppBundle\Includes\Settings;
  14. use AppBundle\Includes\Helper;
  15. use AppBundle\Includes\Tracker;
  16. use AppBundle\Includes\Users;
  17. use AppBundle\Includes\Functions;
  18. use AppBundle\Includes\Constants;
  21. class SearchController extends AbstractController
  22. {
  23.     /*
  24.      * @Route("/{one_type}/", name="search_results_comm_type_only", methods={"GET", "POST"})
  25.      */
  26.     /* TODO: disabled this
  27.     public function resultsCommTypeOnlyAction(Request $request, $one_type)
  28.     {
  29.         if (in_array($one_type, Constants::all_url_types())) {
  30.             if (in_array($one_type, Constants::all_url_types_com())) {
  31.                 $type = 'entreprises-commerces';
  32.             } elseif (in_array($one_type, Constants::all_url_types_murs())) {
  33.                 $type = 'murs-locaux-terrains';
  34.             } else {
  35.                 throw $this->createNotFoundException('PAGE NON TROUVÉE');
  36.             }
  37.             $commerce_type = $one_type;
  38.             $region = Constants::generic_region;
  39.             $dep = Constants::generic_departement;
  40.         } else {
  41.             throw $this->createNotFoundException('PAGE NON TROUVÉE');
  42.         }
  43.         $response = $this->forward('AppBundle:Search:results',
  44.             array(
  45.                 'type' => $type,
  46.                 'region' => $region,
  47.                 'departement' => $dep,
  48.                 'commerce_type' => $commerce_type,
  49.                 '_route' => 'search_results',
  50.                 '_route_params' => array_merge($request->attributes->get('_route_params'),
  51.                     array('type' => $type,
  52.                         'commerce_type' => $commerce_type,
  53.                         'region' => $region,
  54.                         'departement' => $dep,)
  55.                 )),
  56.             $request->query->all());
  57.         #'_route' => $request->attributes->get('_route'),
  58.         #'_route_params' => $request->attributes->get('_route_params')
  59.         return $response;
  60.     }*/
  62.     /**
  63.      * @Route("/{type}/",
  64.      * requirements={"type": "entreprises-commerces|murs-locaux-terrains"},
  65.      * name="search_results_type_only",
  66.      * methods={"GET", "POST"})
  67.      */
  68.     public function resultsTypeOnlyAction (Request $request, $type)
  69.     {
  70.         $type_new = '';
  71.         if ($type == 'entreprises-commerces') {
  72.             $type_new = 'vente';
  73.         } elseif ($type == 'murs-locaux-terrains') {
  74.             $type_new = 'tout';
  75.         }
  77.         $dep = Constants::generic_departement;
  78.         $commerce_type = Constants::generic_commerce_type;
  79.         $response = $this->forward('AppBundle:Search:results',
  80.             array(
  81.                 'type' => $type_new,
  82.                 'departement' => $dep,
  83.                 'commerce_type' => $commerce_type,
  84.                 '_route' => 'search_results',
  85.                 '_route_params' => array_merge($request->attributes->get('_route_params'),
  86.                     array('type' => $type_new,
  87.                         'commerce_type' => $commerce_type,
  88.                         'departement' => $dep,)
  89.                 )),
  90.             $request->query->all());
  92.         return $response;
  93.     }
  95.     /**
  96.      * @Route("/{type}/{one_type}/",
  97.      * requirements={"type": "entreprises-commerces|murs-locaux-terrains"},
  98.      * name="search_results_comm_type",
  99.      * methods={"GET", "POST"})
  100.      */
  101.     public function resultsCommTypeAction(Request $request, $type, $one_type)
  102.     {
  103.         $type_new = '';
  104.         if ($type == 'entreprises-commerces') {
  105.             $type_new = 'vente';
  106.         } elseif ($type == 'murs-locaux-terrains') {
  107.             $type_new = 'tout';
  108.         }
  110.         if (in_array($one_type, Constants::all_url_types())) {
  111.             $commerce_type = $one_type;
  112.             $region = Constants::generic_region;
  113.             $dep = Constants::generic_departement;
  114.         } elseif (in_array($one_type, Constants::all_url_regions())) {
  115.             $commerce_type = Constants::generic_commerce_type;
  116.             $region = $one_type;
  117.             $dep = Constants::generic_departement;
  118.         } else {
  119.             throw $this->createNotFoundException('PAGE NON TROUVÉE');
  120.         }
  122.         $response = $this->forward('AppBundle:Search:results',
  123.             array(
  124.                 'type' => $type_new,
  125.                 'departement' => $dep,
  126.                 'commerce_type' => $commerce_type,
  127.                 '_route' => 'search_results',
  128.                 '_route_params' => array_merge($request->attributes->get('_route_params'),
  129.                     array('type' => $type_new,
  130.                         'commerce_type' => $commerce_type,
  131.                         'departement' => $dep,)
  132.                 )),
  133.             $request->query->all());
  135.         return $response;
  136.     }
  138.     # Handle region/department
  139.     /**
  140.      * @Route("/{type}/{region}/{departement}/",
  141.      * requirements={"type": "entreprises-commerces|murs-locaux-terrains"},
  142.      * name="search_results_dep_type",
  143.      * methods={"GET", "POST"})
  144.      */
  145.     public function resultsDepTypeAction(Request $request, $type, $region, $departement)
  146.     {
  147.         if (in_array($region, Constants::all_url_regions()) && in_array($departement, Constants::all_url_deps())) {
  148.             $commerce_type = Constants::generic_commerce_type;
  149.             $region = $region;
  150.             $dep = $departement;
  151.         } else {
  152.             throw $this->createNotFoundException('PAGE NON TROUVÉE');
  153.         }
  155.         $response = $this->forward('AppBundle:Search:results',
  156.             array(
  157.                 'type' => $type,
  158.                 'region' => $region,
  159.                 'departement' => $dep,
  160.                 'commerce_type' => $commerce_type,
  161.                 '_route' => 'search_results',
  162.                 '_route_params' => array_merge($request->attributes->get('_route_params'),
  163.                     array('type' => $type,
  164.                         'commerce_type' => $commerce_type,
  165.                         'region' => $region,
  166.                         'departement' => $dep,)
  167.                 )),
  168.             $request->query->all());
  170.         return $response;
  171.     }
  174.     /**
  175.      * @Route("/{type}/{region}/{departement}/{commerce_type}/",
  176.      * requirements={"type": "entreprises-commerces|murs-locaux-terrains"},
  177.      * name="search_results_old",
  178.      * methods={"GET", "POST"})
  179.      */
  180.     public function resultsOldAction(Request $request, $type, $region, $departement, $commerce_type)
  181.     {
  182.         $type_new = '';
  183.         if ($type == 'entreprises-commerces') {
  184.             $type_new = 'vente';
  185.         } elseif ($type == 'murs-locaux-terrains') {
  186.             if (!empty($_GET['transaction'])) {
  187.                 if ($_GET['transaction'] == 'vente') {
  188.                     $type_new = 'vente-immobilier';
  189.                 } elseif ($_GET['transaction'] == 'location') {
  190.                     $type_new = 'location';
  191.                 } elseif ($_GET['transaction'] == 'cession-de-droit-au-bail') {
  192.                     $type_new = 'opportunites-investisseurs';
  193.                 } elseif ($_GET['transaction'] == 'tout') {
  194.                     $type_new = 'tout';
  195.                 }
  196.             } else {
  197.                 $type_new = 'tout';
  198.             }
  199.         }
  201.         # Remove default departement
  202.         if ($departement == Constants::generic_departement) {
  203.             $departement = null;
  204.         }
  206.         # This should redirect to new
  207.         $input = [
  208.             'type' => $type_new,
  209.             'commerce_type' => $commerce_type,
  210.             'departement' => $departement
  211.         ];
  212.         return $this->redirectToRoute('search_results', $input, 301);
  213.     }
  215.     /**
  216.      * @Route("/{type}/{commerce_type}/{departement}",
  217.      * requirements={"type": "vente|vente-immobilier|location|opportunites-investisseurs|tout"},
  218.      * defaults={"commerce_type"=null, "departement"=null},
  219.      * name="search_results",
  220.      * methods={"GET", "POST"})
  221.      */
  222.     public function resultsAction(Request $request, $type, $commerce_type=null, $departement=null)
  223.     {
  224.         # Instant redirect /vente/commerce_type/departement -> remove departement
  225.         if ($departement == Constants::generic_departement && $commerce_type != null) {
  226.             $input_red = [
  227.                 'type' => $type,
  228.                 'commerce_type' => $commerce_type,
  229.                 'departement' => null
  230.             ];
  231.             return $this->redirectToRoute('search_results', $input_red, 301);
  232.         } elseif ($departement == Constants::generic_departement && $commerce_type == null) {
  233.             $input_red = [
  234.                 'type' => $type,
  235.                 'commerce_type' => null,
  236.                 'departement' => null
  237.             ];
  238.             return $this->redirectToRoute('search_results', $input_red, 301);
  239.         }
  241.         if ($commerce_type == Constants::generic_commerce_type && !$departement) {
  242.             $input_red = [
  243.                 'type' => $type,
  244.                 'commerce_type' => null,
  245.                 'departement' => null
  246.             ];
  247.             return $this->redirectToRoute('search_results', $input_red, 301);
  248.         }
  250.         # Handle the case of optional commerce_type
  251.         if (!$commerce_type) {
  252.             $commerce_type = Constants::generic_commerce_type;
  253.         }
  255.         $users = new Users();
  256.         $helper = new Helper($this->get('router'));
  257.         # This gets $_GET params
  258.         $get_params = $request->query->all();
  259.         $session = $request->getSession();
  261.         # Changed links
  262.         if ($commerce_type == 'boutiques-diverses-pret-a-porter-chaussures') {
  263.             $input = array_merge(
  264.                 Array('type' => $type,
  265.                     'departement' => $departement,
  266.                     'commerce-type' => $commerce_type,
  267.                     'found_communes' => isset($_GET['ville']) ? Functions::str_filter($_GET['ville']) : null),
  268.                 $get_params);
  269.             $input['commerce_type'] = 'boutiques-diverses';
  270.             unset($input['commerce-type']);
  271.             return $this->redirectToRoute('search_results', $input, 301);
  272.         }
  274.         # Handle malformed urls
  275.         if (# !in_array($departement, Constants::all_url_deps()) ||  # Make departement optional
  276.             !in_array($commerce_type, Constants::all_url_types())
  277.         ) {
  278.             throw $this->createNotFoundException('PAGE NON TROUVÉE');
  279.         }
  281.         $seo_strategy = 'index';
  282.         # Decide canonical, or noindex
  283.         if ($type == 'tout') {  # In case of tout, do no-index
  284.             $seo_strategy = 'noindex';
  285.         } elseif ($departement == Constants::generic_departement && $commerce_type == Constants::generic_commerce_type) {
  286.             $seo_strategy = 'noindex';
  287.         } elseif ($commerce_type == Constants::generic_commerce_type && $departement) {
  288.             # vente/commerce-a-vendre/3-allier no index
  289.             $seo_strategy = 'noindex';
  290.         } elseif (isset($_GET['order']) && $_GET['order'] != 'default'){
  291.             $seo_strategy = 'noindex';
  292.         } elseif (isset($_GET['ville']) && strpos($_GET['ville'], ',')) {
  293.             # In case of multiple ville, do not index
  294.             $seo_strategy = 'noindex';
  295.         } elseif (isset($_GET['agent_id'])) {
  296.             $seo_strategy = 'noindex';
  297.         } elseif (isset($_GET['price-low']) || isset($_GET['price-high'])) {
  298.             $seo_strategy = 'noindex';
  299.         } elseif (isset($_GET['surface-min']) || isset($_GET['surface-max'])) {
  300.             $seo_strategy = 'noindex';
  301.         } elseif (isset($_GET['mode'])) {
  302.             $seo_strategy = 'noindex';
  303.         } else {
  304.             $seo_strategy = 'index';
  305.         }
  307.         if ($departement == Constants::generic_departement) {
  308.             $departement = Null;
  309.         }
  311.         if ($commerce_type == Constants::generic_commerce_type){
  312.             $commerce_type = Null;
  313.         }
  315.         # Check if page is viewall
  316.         if (isset($get_params['mode']) && $get_params['mode'] == 'viewall') {
  317.             $viewall = True;
  318.         } else {
  319.             $viewall = False;
  320.         }
  322.         $input = array_merge(
  323.             Array('type' => $type,
  324.                 'departement' => $departement,
  325.                 'commerce-type' => $commerce_type,
  326.                 'found_communes' => isset($_GET['ville']) ? Functions::str_filter($_GET['ville']) : null),
  327.             $get_params);
  328.         $results = $helper->db_select($input, 'bulk', $viewall);
  330.         $num_results = Functions::euro_num($helper->total_results);
  331.         # Empty $results means some error, redirect to homepage
  332.         if (empty($results)) {
  333.             # if dep set, go to comm_type
  334.             if (!empty($input['departement']) && !empty($input['commerce-type'])) {
  335.                 # $input['region'] = Constants::generic_region;
  336.                 $input['departement'] = Constants::generic_departement;
  337.                 $input['commerce_type'] = $input['commerce-type'];
  338.                 unset($input['commerce-type']);
  339.                 return $this->redirectToRoute('search_results', $input, 301);
  340.             }
  342.             $session->set('error', $helper->error_obj);
  343.             return $this->redirect('/', 301);
  344.         }
  346.         $tracker = new Tracker($helper->refined_input);
  348.         # Handle problematic agents with their images:
  349.         for ($i=0; $i<count($results); $i++) {
  350.             if (in_array($results[$i]['site_id'], Constants::$block_images_agents)) {
  351.                 $agents_info = $users->get_agents_list($results[$i]['site_id']);
  352.                 $replace_img = !empty($agents_info['logo']) ? $agents_info['logo'] : '/images/agents/default.png';
  353.                 $results[$i] = $helper->replace_image($results[$i], $replace_img);
  354.             }
  355.         }
  357.         # Do some stuff before sending results array to screen
  358.         $results_refined = $helper->refine_results($results);
  360.         # Create title and H1
  361.         if (isset($input_arr['transaction'])) {
  362.             if ($input_arr['transaction'] == 'vente' || $input_arr['transaction'] == 1) {
  363.                 $pre_com_type = 'Vente';
  364.             }
  365.             elseif ($input_arr['transaction'] == 'location' || $input_arr['transaction'] == 2) {
  366.                 $pre_com_type = 'Location';
  367.             }
  368.             elseif ($input_arr['transaction'] == 'cession-de-droit-au-bail' || $input_arr['transaction'] == 3) {
  369.                 $pre_com_type = 'Cession du droit au bail';
  370.             }
  371.         }
  372.         #$page_title_ch = implode(' - ', array_filter(array($commerce_type, $region, $departement)));
  373.         #<title>Vente bar-snack (63)puy-de-dome, auvergne</title>
  375.         $page_title_part = Array();
  377.         # Look for most important keywords and use them to create title
  378.         foreach(array('com_type', 'dep1', 'dep2') as $ctrl) {
  379.             if (isset($helper->keywords[$ctrl]['text'])) {
  380.                 $page_title_part[] = $helper->keywords[$ctrl]['text'];
  381.             }
  382.         }
  383.         if (isset($_GET['ville'])) {
  384.             $page_title_part[] = Functions::str_filter($_GET['ville']);
  385.         }
  387.         $page_title_ch = implode(' - ', $page_title_part);
  389.         if (!isset($helper->keywords['com_type'])) {
  390.             if ($input['type'] == 'location') {
  391.                 $page_title_ch = 'Local commercial à louer ' . $page_title_ch;
  392.             } elseif ($input['type'] == 'opportunites-investisseurs') {
  393.                 $page_title_ch = 'Cession droit au bail ' . $page_title_ch;
  394.             } else {
  395.                 $page_title_ch = 'Fonds de commerce à vendre ' . $page_title_ch;
  396.             }
  397.         }
  399.         if (isset($_GET['page']) && $_GET['page'] > 1) {
  400.             $page_title_ch .= ' - ' . $_GET['page'];
  401.         }
  403.         # Save last search setting to a session cookie, so the form is pre-set already
  404.         $session->set('last_search', $input);
  406.         # In case of agent_id set, display only annonces of a specif agent + some info
  407.         $agent_info = [];
  408.         if (isset($_GET['agent_id'])) {
  409.             $agent_info = $users->ret_user_info(null, intval($_GET['agent_id']));
  410.             # $agent_info = $users->ret_user_info(null, -45);  # Test sql injection, bad input
  411.         }
  413.         # print_r($results_refined);
  414.         # $session->set('last_search_results', $results_refined);
  416.         $output = array(
  417.             'page_title'    => $page_title_ch,
  418.             'page_description' => $page_title_ch,
  419.             'page'          => 'search',
  420.             'h1_main'       => $page_title_ch,
  421.             'loggedin'      => $users->loggedin(),
  422.             'items'            => $results_refined,
  423.             'number_results' => $num_results,
  424.             'seo_strategy'  => $seo_strategy,
  425.             'pagination'    => $helper->list_pagination(),
  426.             'keywords'        => $helper->keywords,
  427.             'keywords_suggestions' => $helper->keywords_suggestions,
  428.             'order_select'  => $helper->list_order_select(),
  429.             'agent_info'    => $agent_info,
  430.             );
  431.         # Check for errors to display
  432.         if ($session->get('error')) {
  433.             $output['error'] = $session->get('error');
  434.             $session->set('error', null);
  435.         }
  436.         return $this->render('search/results.html.twig', $output);
  437.     }
  438. }