src/AppBundle/Controller/BienController.php line 91

Open in your IDE?
  1. <?php
  2. namespace AppBundle\Controller;
  4. use Symfony\Component\Routing\Annotation\Route;
  5. # use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  6. 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;
  20. //http://bizenco2/entreprises-commerces/provence-alpes-azur/13-bouches-du-rhone/commerce-a-vendre/vente-bouches-du-rhone-provence-alpes-azur----66-1324.html
  21. //http://bizenco2/entreprises-commerces/provence-alpes-azur/13-bouches-du-rhone/commerce-a-vendre/
  23. class BienController extends AbstractController
  24. {
  25.     //entreprises-commerces/basse-normandie/14-calvados/bar-tabac/vente-bar-licence-iv-petite-restauration-geo_situtation--1-3412.html
  26.     /**
  27.      * @Route("/{type}/{region}/{departement}/{commerce_type}/{title}--{geo_situation}--{id}.html",
  28.      * requirements={"type": "entreprises-commerces|murs-locaux-terrains", "title": "[a-zA-Z0-9\-]+", "geo_situation": "[a-zA-Z0-9\-]*"},
  29.      * defaults={"departement": "departement", "commerce_type": "commerce-type"},
  30.      * name="bien_display_old", methods={"GET", "POST"})
  31.      */
  32.     public function displayOldAction(Request $request, $type, $region, $departement, $commerce_type, $title, $geo_situation, $id)
  33.     {
  34.         $helper = new Helper($this->get('router'));
  36.         $input = Array('id' => $id);
  37.         $bien = $helper->db_select($input, 'id');
  39.         if (empty($bien)) {
  40.             $session = $request->getSession();
  41.             # Bien not found
  42.             $error_obj = Functions::alert_obj('Référence invalide!', 'Ce bien n’est pas présent dans notre base de donnée', 0);
  44.             # Get commerce text and department text
  45.             $com_id = Functions::com_type2id($commerce_type);
  46.             $dep_id = Functions::departement2id("$departement");
  48.             $com_str = "";
  49.             if ($com_id) {
  50.                 $com_str = Functions::id2com_type($com_id, false);
  51.             }
  52.             $departement_str = "";
  53.             if ($dep_id) {
  54.                 $dep_strs = Functions::id2departement($dep_id, false, false);
  55.                 $departement_str = "{$dep_strs[0]}";
  56.             }
  58.             if ($type == 'murs-locaux-terrains') {
  59.                 $type = 'tout';
  60.             } else {
  61.                 $type = 'vente';
  62.             }
  64.             $session->set('error', $error_obj);
  65.             if ($com_str && $com_str) {
  66.                 $session->set('redirect_page', "/$type/$commerce_type/$departement/");
  67.                 $session->set('redirect_text', "$com_str à vendre en $departement_str");
  68.             } else {
  69.                 $session->set('redirect_text', "");
  70.             }
  73.             # Cause an better 404 error with more info using session variables
  74.             # Use the throw, or else it really causes a blank 404 error
  75.             throw $this->createNotFoundException('Ce bien n’est pas présent dans notre base de donnée');
  76.         }
  77.         $bien = $bien[0]; # We have only one bien
  79.         $params = $helper->bien_url_params($bien);
  81.         return $this->redirect($this->get('router')->generate('bien_display', $params), 301);
  82.     }
  84.     //entreprises-commerces/basse-normandie/14-calvados/bar-tabac/vente-bar-licence-iv-petite-restauration-geo_situtation--1-3412.html
  85.     /**
  86.      * @Route("/{type}/{commerce_type}/{departement}/{title}--{geo_situation}--{id}.html",
  87.      * requirements={"type": "vente|vente-immobilier|location|opportunites-investisseurs", "title": "[a-zA-Z0-9\-]+", "geo_situation": "[a-zA-Z0-9\-]*"},
  88.      * defaults={"departement": "departement", "commerce_type": "commerce-type"},
  89.      * name="bien_display", methods={"GET", "POST"})
  90.      */
  91.     public function displayAction(Request $request, $type, $departement, $commerce_type, $title, $geo_situation, $id)
  92.     {
  93.         $helper = new Helper($this->get('router'));
  94.         $user = $this->get('app.users');
  95.         $tracker = new Tracker();
  97.           $input = Array('id' => $id);
  98.         $bien = $helper->db_select($input, 'id');
  99.         $session = $request->getSession();
  101.         if (empty($bien)) {
  102.             # Bien not found
  103.             $error_obj = Functions::alert_obj('Référence invalide!', 'Ce bien n’est pas présent dans notre base de donnée', 0);
  105.             # Get commerce text and department text
  106.             $com_id = Functions::com_type2id($commerce_type);
  107.             $dep_id = Functions::departement2id("$departement");
  109.             $com_str = "";
  110.             if ($com_id) {
  111.                 $com_str = Functions::id2com_type($com_id, false);
  112.             }
  114.             $departement_str = "";
  115.             if ($dep_id) {
  116.                 $dep_strs = Functions::id2departement($dep_id, false, false);
  117.                 $departement_str = "{$dep_strs[0]}";
  118.             }
  120.             $session->set('error', $error_obj);
  121.             if ($com_str && $departement_str) {
  122.                 $session->set('redirect_page', "/$type/$commerce_type/$departement/");
  123.                 $session->set('redirect_text', "$com_str à vendre en $departement_str");
  124.             }
  126.             # Cause an better 404 error with more info using session variables
  127.             # Use the throw, or else it really causes a blank 404 error
  128.             throw $this->createNotFoundException('Ce bien n’est pas présent dans notre base de donnée');
  129.         }
  130.         $bien = $bien[0]; # We have only one bien
  132.         if ($geo_situation == 'n-a') {
  133.             # url contains geo_situation, which could be empty. Correct and redirect
  134.             $geo_situation = '';
  135.             #print_r($bien);
  136.             $params = $helper->bien_url_params($bien);
  137.             return $this->redirect($this->get('router')->generate('bien_display', $params), 301);
  138.         }
  139.         
  140.         $params = $helper->bien_url_params($bien);
  141.         if ($params['departement']         != $departement     ||
  142.             $params['commerce_type']     != $commerce_type     ||
  143.             $params['title']             != $title            ||
  144.             $params['geo_situation']     != $geo_situation)
  145.         {
  146.             # Instead of doing an error, redirect to correct page!
  147.             #$error_obj = Functions::alert_obj('Paramètres de l’URL non valides!', 'Une erreur est intervenue lors de la construction de l’URL', 0);
  148.             #$session->set('error', $error_obj);
  149.             #return $this->redirect('/', 301);
  150.             $params = $helper->bien_url_params($bien);
  151.             return $this->redirect($this->get('router')->generate('bien_display', $params), 301);
  152.         }
  154.         # $bien variable is used later, but I need title set
  155.         $bien['title']                    = $helper->bien_title($bien);
  156.         $bien_refined['title']              = $helper->bien_title($bien);
  157.         $bien_refined['id']                 = $id;
  158.         $bien_refined['biz_id']           = $bien['biz_id'];
  159.         $bien_refined['reference']        = $bien['reference'];
  160.         $bien_refined['date']             = $bien['date'];
  161.         $bien_refined['type']               = $bien['type'];
  162.         $bien_refined['type_transaction'] = $bien['type_transaction'];
  163.         $bien_refined['forme_juridique']  = $bien['forme_juridique'];
  164.         $bien_refined['licence']          = $bien['licence'];
  165.         $bien_refined['rent_price']       = Functions::euro_num($bien['rent_price']);
  166.         $bien_refined['designation']      = $bien['designation'];
  167.         $bien_refined['geo_situation']    = $bien['geo_situation'];
  168.         $bien_refined['departement']       = $bien['departement'];
  169.         $bien_refined['commerce_type']       = $bien['commerce_type'];
  170.         $bien_refined['ca_ht']            = Functions::euro_num($bien['price_ht']);
  171.         $bien_refined['profit']           = Functions::euro_num($bien['profit']);
  172.         $bien_refined['salaire_dirigeant']= Functions::euro_num($bien['salaire_dirigeant']);
  173.         $bien_refined['price']            = Functions::euro_num($bien['price']);
  174.         $bien_refined['price_com']        = Functions::euro_num($bien['price_com']);
  175.         $bien_refined['price_fonds']      = Functions::euro_num($bien['price_fonds']);
  176.         $bien_refined['price_murs']       = Functions::euro_num($bien['price_murs']);
  177.         $bien_refined['description']      = Functions::str_filter(strip_tags($bien['description']));
  178.         $bien_refined['conditions']       = $bien['conditions'];
  179.         $bien_refined['picture1']         = $bien['picture1'];
  180.         $bien_refined['stationnement']    = $bien['stationnement'];
  181.         $bien_refined['appartement']      = $bien['appartement'];
  182.         $bien_refined['superficie']       = $bien['superficie'];
  183.         $bien_refined['achat_marchandise'] = Functions::euro_num($bien['achat_marchandise']);
  184.         if ($bien['logement'] == 1)
  185.             $bien_refined['logement'] = 'Oui';
  186.         else
  187.             $bien_refined['logement'] = 'Non';
  188.         $bien_refined['motif_cession']    = $bien['motif_cession'];
  189.         $bien_refined['detail_bail']      = $bien['detail_bail'] ? $bien['detail_bail'] : 'N/A';
  190.         $bien_refined['locaux']           = $bien['locaux'];
  191.         $bien_refined['materiel']         = $bien['materiel'];
  192.         $bien_refined['horaire_ouverture']= $bien['horaire_ouverture'];
  193.         $bien_refined['fermeture_hebdo']  = $bien['fermeture_hebdo'];
  194.         $bien_refined['fermeture_an']     = $bien['fermeture_an'];
  195.         $bien_refined['salaire']          = Functions::euro_num($bien['salaire']);
  196.         $bien_refined['ebe']              = Functions::euro_num($bien['ebe']);
  197.         # Calculate Loyer Annuel HT et HC / m2
  198.         $bien_refined['ht_m2']               = Functions::euro_num('');
  199.         $bien_refined['found_communes']   = $bien['found_communes'];
  200.         $bien_refined['url']              = $request->getUri();
  202.         $bien_refined['region_ld']        = Functions::id2region($bien['departement']);
  203.         $bien_refined['departement_ld']   = Functions::id2departement($bien['departement'], False)[0];
  204.         $bien_refined['commerce_type_ld'] = Functions::id2com_type($bien['commerce_type'], False);
  206.         # Mail nego stuff
  207.         if (!empty($bien_refined['superficie']) && $bien_refined['superficie'] != 0)
  208.             $bien_refined['ht_m2'] = Functions::euro_num(intval($bien['rent_price']) * 12 / intval($bien['superficie']));
  209.                         
  210.         foreach ($bien_refined as $key => $value) {
  211.             if ($value == '') {
  212.                 if ($key == 'picture1') {  # In case of empty image, place a filler at least
  213.                     $bien_refined["$key"] = '/images/bizenco_b.png';
  214.                 } else {
  215.                     $bien_refined["$key"] = 'N/A';
  216.                 }
  217.             } else {
  218.                 $bien_refined["$key"] = Functions::str_filter($value);
  219.             }
  220.         }
  222.         # Comparer section
  223.         if (in_array($bien_refined['id'], $helper->cookie['comparer']))
  224.             $in_comparer = True;
  225.         else
  226.             $in_comparer = False;
  228.         # most likely will use agent data already in bien (specific agent), else use agent defaults!
  229.         $ag_keys = Array(
  230.             'tele_portable' => 'portable_nego',
  231.             'tele_fixe' => 'tel_nego',
  232.             'prenom' => 'prenom_nego',
  233.             'nom' => 'nom_nego',
  234.             'email' => 'mail_nego'
  235.         );
  236.         $agents_info = $user->get_agents_list($bien['site_id']);
  238.         # Handle problematic agents with their images:
  239.         if (in_array($agents_info['id'], Constants::$block_images_agents)) {
  240.             $replace_img = !empty($agents_info['logo']) ? $agents_info['logo'] : '/images/agents/default.png';
  241.             $bien_refined = $helper->replace_image($bien_refined, $replace_img);
  242.         }
  244.         foreach ($ag_keys as $key => $value) {
  245.             if (isset($bien[$value]) && $bien[$value] != '') {
  246.                 $agents_info[$key] = $bien[$value];
  247.             }
  248.         }
  250.         # In some formats, they only have NOM for agence
  251.         if (!empty($bien['nom_nego']) && empty($bien['prenom_nego'])) {
  252.             $agents_info['prenom'] = '';
  253.         }
  255.         # Also add agent email to bien_refined, used later
  256.         $bien_refined['email'] = $agents_info['email'];
  258.         # Add bien to the visited list
  259.         $helper->history_add($id, $bien);
  260.         # print_r($helper->breadcrumb($bien_refined)); exit();
  261.         # Limit page description & remove html tags
  262.         $page_description = "{$bien_refined['description']}";
  263.         $page_description = Functions::str_filter($page_description);
  264.         $page_description = substr($page_description, 0, 50);
  266.         $output = array(
  267.             'page_title'    => Functions::str_filter("{$bien_refined['title']} - $id"),
  268.             'page_description' => $page_description,
  269.             'social_title'    => Functions::str_filter("{$bien_refined['title']}"),
  270.             'social_image'    => $bien_refined['picture1'],
  271.             'social_description' => $bien_refined['description'],
  272.             'breadcrumb'    => $helper->breadcrumb($bien_refined),
  273.             'page'          => 'display',
  274.             'loggedin'      => $user->loggedin(),
  275.             'bien'            => $bien_refined,
  276.             'history'        => $helper->history_get(),
  277.             'in_comparer'    => $in_comparer,
  278.             'agent_info'    => $agents_info,
  279.             );
  281.         # Handle user interest in Bien
  282.         if (isset($_POST) && !empty($_POST)) {
  283.             // TODO: check bien_interest function that handles the email
  284.             $output['error'] = $user->bien_interest($_POST, $bien_refined);
  285.         }
  287.         $session = $request->getSession();
  289.         # If logged in, can prepare some info to sent mail fast
  290.         if ($session->get('email') && !$session->get('user_info')) {
  291.             $session_userinfo = Array();
  292.             $user_info = $user->ret_user_info($session->get('email') );
  293.             $session_userinfo['name'] = "{$user_info['nom']} {$user_info['prenom']}";
  294.             $session_userinfo['email'] = $session->get('email');
  295.             $session_userinfo['subject'] = "Demande d’information sur la réf. {$bien_refined['reference']}";
  296.             $session_userinfo['telephone'] = "";
  297.             $session_userinfo['message'] = "";
  299.             $session->set('user_info', $session_userinfo);
  300.         }
  301.         
  302.         # Auto-fill some info
  303.         if ($session->get('user_info'))
  304.             $output['user_info'] = $session->get('user_info');
  305.         
  306.         # Pick between print or normal mode
  307.         if (isset($_GET['mode']) && $_GET['mode'] == 'print') {
  308.             return $this->render('display/bien_printable.html.twig', $output);
  309.         } else {
  310.             $lsrcInput = $session->get('last_search');
  312.             if (is_array($lsrcInput)) {
  313.                 # print_r($lsrcInput);
  314.                 $results = $helper->db_select($lsrcInput, 'similar');
  315.                 $srcRes = $helper->refine_results($results);
  317.                 # Handle similar pages
  318.                 $prev = null;
  319.                 if (is_array($srcRes) && !empty($srcRes)) {
  320.                     # Find current ID
  321.                     foreach ($srcRes as $key => $res) {
  322.                         if ($bien_refined['biz_id'] == $res['biz_id']) {
  323.                             $numIt = 5;
  324.                             if ($numIt > count($srcRes)) $numIt = count($srcRes);
  325.                             # Emulate circular relation for array
  326.                             $slice = array_slice($srcRes, $key+1, $numIt);
  327.                             if ($numIt > count($slice)) {
  328.                                 $slice2 = array_slice($srcRes, 0, $numIt - count($slice));
  329.                                 $slice = array_merge($slice, $slice2);
  330.                             }
  331.                             $output['last_search_results'] = $slice;
  333.                             # Next item for nagivate prev, next
  334.                             if (count($slice)) {
  335.                                 $output['next_search'] = $slice[0]['url'];
  336.                             } else {
  337.                                 $output['next_search'] = Array();
  338.                             }
  339.                             $output['prev_search'] = $prev;
  340.                             break;
  341.                         }
  342.                         $prev = $res['url'];
  343.                     }
  344.                 }
  345.             }
  347.             # Do those things only in normal mode
  348.             # Add bien to the visited list
  349.             $helper->history_add($id, $bien_refined);
  350.             # Latest Entries Display
  351.             $tracker->add_bien($bien_refined);
  353.             return $this->render('display/bien.html.twig', $output);
  354.         }
  355.     }
  356. }