src/Controller/HomeController.php line 886

Open in your IDE?
  1. <?php namespace App\Controller;
  3. use App\Entity\Clients;
  4. use App\Entity\KeywordPage;
  5. use App\Entity\TalentGroup;
  6. use App\Repository\JobCallRepository;
  7. use App\Repository\JobCallStageRepository;
  8. use App\Repository\LightboxRepository;
  9. use App\Services\ImageService;
  10. use App\Services\MailerService;
  11. use Doctrine\ORM\Tools\Pagination\Paginator;
  12. use Symfony\Component\HttpFoundation\JsonResponse;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\HttpFoundation\Session\Session;
  16. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  18. class HomeController extends BaseController {
  19. //    /**
  20. //     * @var MailerService
  21. //     */
  22. //    private $sesmail;
  23. //
  24. //    public function __construct(MailerService $ms)
  25. //    {
  26. //        $this->sesmail =  null;//$ms;
  27. //    }
  28.     /*
  29.     |--------------------------------------------------------------------------
  30.     | Default Home Controller
  31.     |--------------------------------------------------------------------------
  32.     |
  33.     | You may wish to use controllers instead of, or in addition to, Closure
  34.     | based routes. That's great! Here is an example controller method to
  35.     | get you started. To route to this controller, just add the route:
  36.     |
  37.     |    Route::get('/', 'HomeController@showWelcome');
  38.     |
  39.     */
  41.     public function showMobileClients(Request $request, $paged = 0){
  43.       //  var_dump($paged);
  44.         if(isset($request->request->all()['paged'])) $paged = $request->request->all()['paged'];
  46.         $clients = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  47.         $clients2 = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  48.         $clients2->where('o.password IS NOT NULL');
  49.         // dd($clients2);
  50.         $clients->where('o.password IS NOT NULL');
  51.         $clients->andWhere('o.incompleteProfile = :incompleteProfile');
  52.         $clients->setParameter('incompleteProfile', 'false');
  54.         $clients->setFirstResult( $paged * 30);
  55.         $clients->setMaxResults(30);
  57.         $form_params = [
  58.             'incompleteProfile', 'ethnicity', 'age', 'real_age', 'display_name', 'first_name', 'sir_name',
  59.             'languages', 'infobox', 'description_of_client', 'gender_two', 'height', 'accent', 'real_families',
  60.             'userRegistered', 'location','talents', 'area'
  61.             ,
  62.         ];
  64.         foreach($form_params as $param)
  65.         {
  66.             if(
  67.                 (isset( $_REQUEST[$param] ))
  68.                 && (!empty( $_REQUEST[$param] ))
  69.                 && ( 1 == 1 )
  70.                 && ( $_REQUEST[$param] != '-1' )
  71.             ) {
  72.                 $clients->andWhere("o.$param LIKE :$param");
  73.                 $clients->setParameter($param, '%'.$_REQUEST[$param].'%');
  74.                 $clients2->andWhere("o.$param LIKE :$param");
  75.                 $clients2->setParameter($param, '%'.$_REQUEST[$param].'%');
  76.             }
  77.         }
  82.         $clients = $clients->getQuery()->getResult();
  86.         $clients2->andWhere('o.incompleteProfile = :incompleteProfile');
  87.         $clients2->setParameter('incompleteProfile', 'false');
  88.         $clients2->orderBy('o.userRegistered', 'DESC');
  89.         $clients2 = $clients2->getQuery()->getResult();
  91. //        dd(count($clients2) / 30);
  92.         return $this->render('theme::views.mobile.all_clients', [
  93.             'clients' =>$clients,
  94.             'paged' => $paged,
  95.             'dataAjaxFalse' => 'data-ajax="false"' ,
  96.             'last_page' => count($clients2) / 30,
  97.             ]);
  99.         return "ddd";
  100.         $this->showClients($paged, true);
  101.     }
  102.     public function showClients(Request $request, $page = 0, $isMobileView = false)
  103.     {
  105. //        dump($request->request->all()['search_page_num'] ?? "no");
  106. //        die;
  107.         if(isset($request->request->all()['paged'])) $paged = $request->request->all()['paged'];
  108.         $clients = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  109.         $clients2 = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  111.        // dd($clients2);
  112.         $clients->where('o.password IS NOT NULL');
  113.         $clients->andWhere('o.incompleteProfile = :incompleteProfile');
  114.         $clients->setParameter('incompleteProfile', 'false');
  115.         $clients->orderBy('o.userRegistered', 'DESC');
  117.         $clients2->where('o.password IS NOT NULL');
  118.         $clients2->andWhere('o.incompleteProfile = :incompleteProfile');
  119.         $clients2->setParameter('incompleteProfile', 'false');
  121.         $form_params = [
  122.             'incompleteProfile', 'ethnicity', 'age', 'real_age', 'display_name', 'first_name', 'sir_name',
  123.             'languages', 'infobox', 'description_of_client', 'gender_two', 'height', 'accent', 'real_families',
  124.             'userRegistered', 'location', 'area', 'is_beautiful', 'has_spotlight'
  125.             ,
  126.         ];
  128. //        $jobs = $this->getDoctrine()->getRepository('App\Entity\Jobs');
  129. //        $jobs->findAll()
  131.         foreach($form_params as $param)
  132.         {
  133.             if(
  134.                 (isset( $_REQUEST[$param] ))
  135.                 && (!empty( $_REQUEST[$param] ))
  136.                 && ( 1 == 1 )
  137.                 && ( $_REQUEST[$param] != '-1' )
  138.             ) {
  139.                 $clients->andWhere("o.$param LIKE :$param");
  140.                 $clients->setParameter($param, '%'.$_REQUEST[$param].'%');
  141.                 $clients2->andWhere("o.$param LIKE :$param");
  142.                 $clients2->setParameter($param, '%'.$_REQUEST[$param].'%');
  143.             }
  144.         }
  146.         $limit = 18;
  147.         $offset = $page * $limit;
  150. //dump('$_REQUEST', $_REQUEST);
  151. //die;
  152.         if(  isset($request->request->all()['paged'])  )
  153.         {
  154.             $paged = $request->request->all()['paged'];
  155.         }
  156.         $clients->setFirstResult($offset);
  158.         //$clients->setFirstResult( $paged );
  159.         $clients->setMaxResults($limit);
  162.         $q = $clients->getQuery();
  163.         $clients = $q->getResult();
  165.         $count = count($clients2->getQuery()->getResult());
  167.         $paginator = new Paginator($q);
  170.         $talent_groups = $this->getDoctrine()->getRepository('App\Entity\TalentGroup');
  171.         $settings = $this->getDoctrine()->getRepository('App\Entity\SiteSetting')->findAll()[0];
  173.         $pagination_info = array(
  174.             'total' => (int) $count,
  175.             'current' => (int) $page,
  176.             'pages' => (int) ceil($count / $limit),
  177.             'path' =>  'all-clients'
  178.         );
  180.         $talent_groups_repo = $this->getDoctrine()->getRepository('App\Entity\TalentGroup');
  181.         $talent_repo = $this->getDoctrine()->getRepository('App\Entity\Talent');
  183.         return
  184.             $this->render('new/clients.html.twig', [
  185.                 'paginator' => $paginator,
  186.                 'settings' => $settings,
  187.                 'talent-groups' => $talent_groups,
  188.                 'last_page' => $count / 30,
  189.                 'is_search' => $request->request->all()['search_active'] ?? 'no',
  190.                 'clients' => $clients,
  191.                 'page' => $page,
  192.                 'pagi' => $pagination_info,
  193.                 'talent_groups' => $talent_groups_repo->findAll(),
  194.                 'talents' => $talent_repo->findAll(),
  197.             ]);
  198.     }
  200.     public function showExtras(Request $request, $paged = 0)
  201.     {
  202.         return $this->showClientsByType("","extras", $paged = 0);
  203.     }
  205.     public function showClientsByTypeMobile(Request $request, $slug, $paged = 0, $group = "actors")
  206.     {
  207.         if(isset($request->request->all()['paged'])) $paged = $request->request->all()['paged'];
  208.         $clients2 = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  209.         $clients2->where('o.password IS NOT NULL');
  210.         $clients2->andWhere('o.incompleteProfile = :incompleteProfile');
  211.         $clients2->setParameter('incompleteProfile', 'false');
  212.         $clients2->andWhere('o.talents like :talent');
  213.         $clients2->setParameter('talent', "%".$slug."%");
  215.         $clients = $this->getDoctrine()->getRepository('App\Entity\Clients')->createQueryBuilder('o');
  216.         $clients->where('o.password IS NOT NULL');
  217.         $clients->andWhere('o.incompleteProfile = :incompleteProfile');
  218.         $clients->setParameter('incompleteProfile', 'false');
  219.         $clients->andWhere('o.talents like :talent');
  220.         $clients->setParameter('talent', "%".$slug."%");
  221.         $clients->orderBy('o.userRegistered', 'DESC');
  222.         $clients->setFirstResult( $paged * 30);
  223.         $clients->setMaxResults(30);
  225.         $form_params = [
  226.             'incompleteProfile', 'ethnicity', 'age', 'real_age', 'display_name', 'first_name', 'sir_name',
  227.             'languages', 'infobox', 'description_of_client', 'gender_two', 'height', 'accent', 'real_families',
  228.             'userRegistered', 'location','talents', 'area'
  229.             ,
  230.         ];
  232.         foreach($form_params as $param)
  233.         {
  234.             if(
  235.                 (isset( $_REQUEST[$param] ))
  236.                 && (!empty( $_REQUEST[$param] ))
  237.                 && ( 1 == 1 )
  238.                 && ( $_REQUEST[$param] != '-1' )
  239.             ) {
  240.                 $clients->andWhere("o.$param LIKE :$param");
  241.                 $clients->setParameter($param, '%'.$_REQUEST[$param].'%');
  242.                 $clients2->andWhere("o.$param LIKE :$param");
  243.                 $clients2->setParameter($param, '%'.$_REQUEST[$param].'%');
  244.             }
  245.         }
  248.         $clients = $clients->getQuery()->getResult();
  253.         $clients2->orderBy('o.userRegistered', 'DESC');
  254.         $clients2 = $clients2->getQuery()->getResult();
  257.         return
  258.             $this->render('theme::views.mobile.by_type', [
  259.                 'clients' => $clients ,
  260.                 'slug' => $slug,
  261.                 'group' => $group,
  262.                 'paged' => $paged,
  263.                 'last_page' => count($clients2) / 30]
  264.             );
  265.     }
  267.     public function showClientsByGroup(Request $request, $talentGroupSlug, $page = 0) {
  268. //        dump('$talentGroupSlug', $talentGroupSlug);
  269. //        die;
  270.         return $this->showClientsByType($request, $talentGroupSlug, null, $page);
  271.     }
  273.     public function showClientsByTalent(Request $request, $talentGroupSlug, $talentSlug, $page = 0) {
  274. //        dump('$talentSlug', $talentSlug);
  275. //        die;
  276. //        die;
  277.         return $this->showClientsByType($request, $talentGroupSlug, $talentSlug, $page);
  278.     }
  280.     public function showClientsByType(Request $request, $talentGroupSlug, $talentSlug = "", $page = 0)
  281.     {
  282. //dump('$_REQUEST', $_REQUEST);
  283. //die;
  284.         $is_search = $request->request->all()['search_active'] ?? false;
  286.         if($is_search) {
  287.             $page = $request->request->all()['search_page'];
  288.         }
  290. //        die;
  291.         $clients_repo = $this->getDoctrine()->getRepository('App\Entity\Clients');
  292.         $talent_groups_repo = $this->getDoctrine()->getRepository('App\Entity\TalentGroup');
  293.         $talent_repo = $this->getDoctrine()->getRepository('App\Entity\Talent');
  295.         if(isset($request->request->all()['page'])) $page = $request->request->all()['page'];
  296.         $clients2 = $clients_repo->createQueryBuilder('o');
  297.         $clients2->where('o.password IS NOT NULL');
  298.         $clients2->andWhere('o.incompleteProfile = :incompleteProfile');
  299.         $clients2->setParameter('incompleteProfile', '0');
  300.         $clients2->andWhere('o.talents like :talent');
  301.         $clients2->setParameter('talent', "%".$talentGroupSlug."%");
  303.         $clients = $clients_repo->createQueryBuilder('o');
  304.         $clients->where('o.password IS NOT NULL');
  305.         $clients->andWhere('o.incompleteProfile = :incompleteProfile');
  306.         $clients->setParameter('incompleteProfile', '0');
  310.         if($talentGroupSlug == "extras") {
  311. //            dump("extras where o.talents like %$talentGroupSlug%");
  312.             $clients->andWhere('o.talents like :talent');
  313.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  314.             $talentSlug = $talentGroupSlug;
  315.         } else if($talentGroupSlug == "disabilities") {
  316. //            dump("where o.talents like %$talentSlug%");
  317.             $clients->andWhere('o.talents like :talent');
  318.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  319.             $talentSlug = $talentGroupSlug;
  320.         } else if($talentGroupSlug == "athletes") {
  321. //            dump("where o.talents like %$talentSlug%");
  322.             $clients->andWhere('o.talents like :talent');
  323.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  324.             $talentSlug = $talentGroupSlug;
  325.         } else if($talentGroupSlug == "musicians") {
  326. //            dump("where o.talents like %$talentSlug%");
  327.             $clients->andWhere('o.talents like :talent');
  328.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  329.             $talentSlug = $talentGroupSlug;
  330.         } else if($talentGroupSlug == "speciality") {
  331. //            dump("where o.talents like %$talentSlug%");
  332.             $clients->andWhere('o.talents like :talent');
  333.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  334.             $talentSlug = $talentGroupSlug;
  335.         } else {
  336.             if(empty($talentSlug)) {
  337.                 $clients->andWhere('o.talents like :talent');
  338.                 $clients->setParameter('talent', "%".$talentGroupSlug."%");
  339.                 $talentSlug = $talentGroupSlug;
  340.             } else {
  341.                 if ($talentGroupSlug === "dancers" && $talentSlug === "theatrical")
  342.                 {
  343.                     $talentx = "theatre";
  345.                     //theater,
  346.                     $clients->andWhere('o.talents LIKE :talents1');
  347.                     $clients->setParameter('talents1', "$talentx,%");
  349.                     //.+ ,theater$
  350.                     $clients->orWhere('o.talents LIKE :talents2');
  351.                     $clients->setParameter('talents2', "%,$talentx");
  353.                     //,theater,
  354.                     $clients->orWhere('o.talents LIKE :talents3');
  355.                     $clients->setParameter('talents3', "%,$talentx,%");
  357.                     //theater
  358.                     $clients->orWhere('o.talents = :talents4');
  359.                     $clients->setParameter('talents4', "$talentx");
  360.                 } else {
  361.                     $clients->andWhere('o.talents like :talent');
  362.                     $clients->setParameter('talent', "%".$talentSlug."%");
  363.                 }
  364. //
  366.             }
  368.         }
  370. //        dump('$talentSlug', $talentSlug);
  371. //        dump('$talentGroupSlug', $talentGroupSlug);
  372. //        die;
  374.         $form_params = [
  375.             'ethnicity', 'age', 'real_age', 'displayName', 'first_name', 'sir_name', 'genderTwo',
  376.             'location', 'languages', 'infobox', 'descriptionOfClient',  'height', 'accent', 'real_families',
  377.             'userRegistered', 'location', 'area', 'is_beautiful', 'has_spotlight'
  378.         ];
  380.         foreach($form_params as $param)
  381.         {
  382.             if(
  383.                 (isset( $_REQUEST[$param] ))
  384.                 && (!empty( $_REQUEST[$param] ))
  385.                 && ( 1 == 1 )
  386.                 && ( $_REQUEST[$param] != '-1' )
  387.             ) {
  388.                 $clients->andWhere("o.$param LIKE :$param");
  389.                 $clients->setParameter($param, '%'.$_REQUEST[$param].'%');
  390.                 $clients2->andWhere("o.$param LIKE :$param");
  391.                 $clients2->setParameter($param, '%'.$_REQUEST[$param].'%');
  392.             }
  393.         }
  395.         $limit = 18;
  397. //        $page = (int) $page;
  398. //        if(!is_int($page)) {
  399. //            $page = 1;
  400. //        }
  401.         $offset = $page * $limit;
  404.         $clients->orderBy('o.id', 'DESC');
  405.         $clients->setFirstResult( $offset );
  406.         $clients->setMaxResults($limit);
  409.         $q = $clients->getQuery();
  410.         $clients = $q->getResult();
  411.         $paginator = new Paginator($q);
  413.         $path = ($talentSlug) ? "talents/".$talentGroupSlug."/".$talentSlug : "talent-directory/".$talentGroupSlug;
  415.         $count = $paginator->count();
  416.         $pagination_info = array(
  417.             'total' => (int) $count,
  418.             'current' => (int) $page,
  419.             'pages' => (int) ceil($count / $limit),
  420.             'path' =>  $path
  421.         );
  423.         if($talentSlug) {
  424.             $talent =  $talent_repo->findOneBy(['slug' => $talentSlug]);
  425.         } else {
  426.             $talent = false;
  427.         }
  429.         $count = count($clients2->getQuery()->getResult());
  431.         $last_page = $clients2->getQuery()->getResult();
  432.         $settings = $this->getDoctrine()->getRepository('App\Entity\SiteSetting')->findAll();
  434.         if(!$settings) {
  435.             die;
  436.         }
  438.         $settings = $settings[0];
  440.         $data_for_view = [
  441.             'settings' => $settings,
  442.             'by_type' => true,
  443.             'is_search' => $request->request->all()['search_active'] ?? false,
  444.             'pagi' => $pagination_info,
  445.             'paginator' => $paginator->count(),
  446.             'group' => $talent_groups_repo->findOneBy(['slug' => $talentGroupSlug]),
  447.             'talent_groups' => $talent_groups_repo->findAll(),
  448.             'talent' => $talent,
  449.             'slug' => $talentSlug,
  450.             'slug_group' => $talentGroupSlug,
  451.             'clients' => $clients ,
  452.             'page' => $page,
  453.             'last_page' => $count / 30,
  454.             'talents' => $talent_repo->findAll(),
  456.         ];
  458.         return
  459.             $this->render('new/clients.html.twig', $data_for_view);
  460.     }
  462.     public function showKeywordPage(Request $request, $keyword_slug, $paged = 0)
  463.     {
  464.         $keyword_pages_repo = $this->getDoctrine()->getRepository('App\Entity\KeywordPage');
  466.         /** @var KeywordPage $page */
  467.         $page = $keyword_pages_repo->findOneBy(['slug'=>$keyword_slug]);
  469.         $page_talents = $page->getTalents();
  471.         $talentSlug = $page->getTalents()[0]->getSlug();
  472.         $talentGroupSlug = $page->getTalentGroups()[0]->getSlug();
  473. //        $talentGroupSlug = $page->
  474.         $clients_repo = $this->getDoctrine()->getRepository('App\Entity\Clients');
  475.         $talent_groups_repo = $this->getDoctrine()->getRepository('App\Entity\TalentGroup');
  476.         $talent_repo = $this->getDoctrine()->getRepository('App\Entity\Talent');
  479.         $clients2 = $clients_repo->createQueryBuilder('o');
  480.         $clients2->where('o.password IS NOT NULL');
  481.         $clients2->andWhere('o.incompleteProfile = :incompleteProfile');
  482.         $clients2->setParameter('incompleteProfile', 'false');
  483.         $clients2->andWhere('o.talents like :talent');
  484.         $clients2->setParameter('talent', "%".$talentGroupSlug."%");
  486.         $clients = $clients_repo->createQueryBuilder('o');
  487.         $clients->where('o.password IS NOT NULL');
  488.         $clients->andWhere('o.incompleteProfile = :incompleteProfile');
  489.         $clients->setParameter('incompleteProfile', 'false');
  492.         if($talentSlug != "") {
  493.             $clients->andWhere('o.talents like :talent');
  494.             $clients->setParameter('talent', "%".$talentSlug."%");
  495.         } else {
  496.             $clients->andWhere('o.talents like :talent');
  497.             $clients->setParameter('talent', "%".$talentGroupSlug."%");
  498.         }
  501.         $form_params = [
  502.             'ethnicity', 'age', 'real_age', 'display_name', 'first_name', 'sir_name', 'gender_two',
  503.             'location', 'languages', 'infobox', 'description_of_client',  'height', 'accent', 'real_families',
  504.             'userRegistered', 'location', 'area', 'is_beautiful', 'has_spotlight'
  505.         ];
  507.         foreach($form_params as $param)
  508.         {
  509.             if(
  510.                 (isset( $_REQUEST[$param] ))
  511.                 && (!empty( $_REQUEST[$param] ))
  512.                 && ( 1 == 1 )
  513.                 && ( $_REQUEST[$param] != '-1' )
  514.             ) {
  515.                 $clients->andWhere("o.$param LIKE :$param");
  516.                 $clients->setParameter($param, '%'.$_REQUEST[$param].'%');
  517.                 $clients2->andWhere("o.$param LIKE :$param");
  518.                 $clients2->setParameter($param, '%'.$_REQUEST[$param].'%');
  519.             }
  520.         }
  522.         $clients->orderBy('o.userRegistered', 'DESC');
  523.         $clients->setFirstResult( $paged * 50 );
  524.         $clients->setMaxResults(50);
  527.         $clients = $clients->getQuery()->getResult();
  529.         if($talentSlug) {
  530.             $talent =  $talent_repo->findOneBy(['slug' => $talentSlug]);
  531.         } else {
  532.             $talent = false;
  533.         }
  535. //
  538.         $count = count($clients2->getQuery()->getResult());
  540.         $last_page = $clients2->getQuery()->getResult();
  542.         $settings = $this->getDoctrine()->getRepository('App\Entity\SiteSetting')->findAll()[0];
  544.         $data_for_view = [
  545.             'settings' => $settings,
  546.             'keyword_page' => $page,
  547.             'by_type' => true,
  548.             'group' => $talent_groups_repo->findOneBy(['slug' => $talentGroupSlug]),
  549.             'talent' => $talent,
  550.             'slug' => $talentSlug,
  551.             'clients' => $clients ,
  552.             'paged' => $paged,
  553.             'last_page' => $count / 30,
  554.         ];
  556. //        dump('$data_for_view', $data_for_view);
  557. //        dump('$talentSlug', $talentSlug);
  558. //        die;
  561.         return
  562.             $this->render('new/clients.html.twig', $data_for_view);
  564.         return
  565.             $this->render('theme::views.original.by_type', [
  566.                     'clients' => $clients ,
  567.                     'group' => $group,
  568.                     'slug' => $talentGroupSlug,
  569.                     'paged' => $paged,
  570.                     'last_page' => count($last_page) / 30
  571.                 ]
  572.             );
  573. //                ->withInput($request->request->all());
  575.     }
  578.     public function showMobileJobs(Request $request, $paged = 0)
  579.     {
  580.         $jobs = $this->getDoctrine()->getRepository('App\Entity\Jobs')->createQueryBuilder('o');
  581.         $jobs->where('o.statuz = :statuz');
  582.         $jobs->setParameter('statuz', 'publish');
  583.         $jobs->orderBy('o.id', 'DESC');
  584. //        $jobs->setFirstResult( $paged * 30 );
  585. //        $jobs->setMaxResults(50);
  586.         $jobs = $jobs->getQuery()->getResult();
  588.         return $this->render('theme::views.mobile.jobs', ['jobs' =>$jobs ]);
  589.     }
  591.     public function getLightboxSingle(Request $request, $id)
  592.     {
  593.         $clients = $this->getDoctrine()->getRepository('App\Entity\Clients')->find($id);
  595.         return new JsonResponse([
  596.             'html' => $this->get('twig')->render('new/partials/client_lightbox.html.twig', ['client' => $clients])
  597.         ]);
  599.     }
  601.     public function getLightboxClientsPreview(Request $request)
  602.     {
  603.         $ids = array_values(json_decode($request->request->get("clients"), false) ?? []);
  606.         $ret = $this->get_lbox_clients($ids, 'new/partials/client_lightbox_preview.html.twig');
  608.         return new JsonResponse([
  609.             'html' => $ret
  610.         ]);
  611.     }
  613.     public function getLightboxClients(Request $request)
  614.     {
  615.         $ids = array_values($request->request->get("clients") ?? []);
  616.         $ret = $this->get_lbox_clients($ids);
  619.         return new JsonResponse([
  620.             'html' => $ret
  621.                 ]);
  622.     }
  624.     public function sendGetLigthboxClients(Request $request)
  625.     {
  626.         $ids = array_values(json_decode($request->request->get("clients"), false) ?? []);
  627.         $lightbox_html = $this->get_lbox_clients($ids);
  630.     }
  632.     private function get_lbox_clients($ids, $template = 'new/partials/client_lightbox_new.html.twig')
  633.     {
  634.         $ret = "";
  635.         if(!empty($ids)) {
  636.             $clients = $this->getDoctrine()->getRepository('App\Entity\Clients')
  637.                 ->findBy(['id' => $ids]);
  639.             foreach($clients as $client) {
  640.                 $ret .= $this->get('twig')->render($template, ['client' => $client]);
  641.             }
  642.         }
  644.         return $ret;
  645.     }
  647.     public function showJobCallSelection($lightbox_id = 0, LightboxRepository $lrepo, JobCallStageRepository $jobCallStageRepository) {
  648.         $lightbox = $lrepo->findOneBy(['unique_id' => $lightbox_id]);
  649.         $jobCallStage = $jobCallStageRepository->findOneBy(['lightbox' => $lightbox->getId()]);
  652.         $clients = $lightbox->getClients();
  654.         $priorities = json_decode($lightbox->getPriorities(), true);
  656.         if(!empty($priorities)) {
  657.             $newClientIds = [];
  658.             $newClients = [];
  659.             $prioClients = [];
  660.             $nonPrioClients = [];
  661.             foreach($clients as $client) {
  662.                 $prioFound = false;
  663.                 foreach($priorities as $priority_set) {
  665.                     if($client->getId() == $priority_set['clientId']) {
  666.                         //                    dump("got prio to set");
  667.                         $client->priority = $priority_set['priority'];
  668.                         $prioFound = true;
  669.                         break;
  670.                     }
  671.                 }
  673.                 if($prioFound == true) {
  674.                     $prioClients[] = $client;
  675.                 } else {
  676.                     $nonPrioClients[] = $client;
  677.                 }
  680.                 $newClients[] = $client;
  681.             }
  684.             $clients = $newClients;
  687.             usort($prioClients, function($a, $b)
  688.             {
  689.                 return intval($a->priority) > intval($b->priority);
  690.             });
  692.             usort($nonPrioClients, function($a, $b)
  693.             {
  694.                 return intval($a->getId()) > intval($b->getId());
  695.             });
  697.             $clients = array_merge($prioClients, $nonPrioClients);
  699.         }  else {
  700.             $newClients = [];
  702.             foreach ($clients as $client) {
  703.                 $newClients[] = $client;
  705.             }
  706.             $clients = $newClients;
  707.             usort($clients, function($a, $b)
  708.             {
  709.                 return intval($a->getId()) < intval($b->getId());
  710.             });
  711.         }
  714.         if($jobCallStage) {
  715.             $jobCall = $jobCallStage->getJobCall();
  717.             return $this->render('new/lightbox_job_call.html.twig', [
  718.                 'lightbox' => $lightbox,
  719.                 'job_call' => $jobCall,
  720.                 'clients_sorted' => $clients,
  721.                 'job_call_stage' => $jobCallStage->toJson()
  722.             ]);
  723.         } else {
  724.             return $this->render('new/lightbox_new.html.twig', [
  725.                 'lightbox' => $lightbox,
  726.             ]);
  727.         }
  728.     }
  730.     public function showClientsSelection($lightbox_id = 0, LightboxRepository $lrepo, JobCallStageRepository $jobCallStageRepository)
  731.     {
  732.         $lightbox = $lrepo->findOneBy(['unique_id' => $lightbox_id]);
  734.         $clients = $lightbox->getClients();
  736.         $priorities = json_decode($lightbox->getPriorities(), true);
  738.         if(!empty($priorities)) {
  739.             $newClientIds = [];
  740.             $newClients = [];
  741.             $prioClients = [];
  742.             $nonPrioClients = [];
  743.             foreach($clients as $client) {
  744.                 $prioFound = false;
  745.                 foreach($priorities as $priority_set) {
  747.                     if($client->getId() == $priority_set['clientId']) {
  748.     //                    dump("got prio to set");
  749.                         $client->priority = $priority_set['priority'];
  750.                         $prioFound = true;
  751.                         break;
  752.                     }
  753.                 }
  755.                 if($prioFound == true) {
  756.                     $prioClients[] = $client;
  757.                 } else {
  758.                     $nonPrioClients[] = $client;
  759.                 }
  762.                 $newClients[] = $client;
  763.             }
  766.             $clients = $newClients;
  769.             usort($prioClients, function($a, $b)
  770.             {
  771.                 return intval($a->priority) > intval($b->priority);
  772.             });
  774.             usort($nonPrioClients, function($a, $b)
  775.             {
  776.                     return intval($a->getId()) < intval($b->getId());
  777.             });
  779.             $clients = array_merge($prioClients, $nonPrioClients);
  781.         }  else {
  782.             $newClients = [];
  784.             foreach ($clients as $client) {
  785.                 $newClients[] = $client;
  787.             }
  788.             $clients = $newClients;
  789.             usort($clients, function($a, $b)
  790.             {
  791.                 return intval($a->getId()) < intval($b->getId());
  792.             });
  793.         }
  794.         return $this->render('new/lightbox_clients.html.twig', [
  795.             'lightbox' => $lightbox,
  796.             'clients_sorted' => $clients
  797.         ]);
  799.     }
  800.     public function showEnquiryLightboxByUniqueId($lightbox_id = 0, LightboxRepository $lrepo) {
  801.         $lightbox = $lrepo->findOneBy(['unique_id' => $lightbox_id]);
  803.         return $this->render('new/lightbox_enquire.html.twig', ['lightbox' => $lightbox]);
  804.     }
  806.     public function showLightbox(Request $request, $paged = 0) {
  808.         return $this->render('new/lightbox.html.twig', ['settings' => $this->getSettings()]);
  809.     }
  811.     public function showLightboxEnquiry(Request $request, $paged = 0) {
  813.         return $this->render('new/lightbox_enquire.html.twig', ['settings' => $this->getSettings()]);
  814.     }
  817.     public function showTermsAndConditions(Request $request) {
  818.         return $this->render('new/terms_and_conditions.html.twig', ['settings' => $this->getSettings()]);
  819.     }
  820.     public function showPrivacyPolicy(Request $request) {
  821.         return $this->render('new/privacy_policy.html.twig', ['settings' => $this->getSettings()]);
  822.     }
  824.     public function showProjects(Request $request, ImageService $is, $paged = 0) {
  826.         $images = $this->getDoctrine()->getRepository('App\Entity\ProjectImage')->findAll();
  828.         foreach($images as $image) {
  829. //            dump('$image', $image->getImage());
  830.             $is->resize_to_fit("/usr/share/nginx/fusion/public/images/theme_images/".$image->getImage());
  831.         }
  833.         return $this->render('new/projects.html.twig', [
  834.             'settings' => $this->getSettings(),
  835.             'project_videos' => $this->getDoctrine()->getRepository('App\Entity\ProjectVideo')->findAll(),
  836.             'project_images' => $images,
  837.             'talent_groups' => $this->getDoctrine()->getRepository('App\Entity\TalentGroup')->findAll(),
  838.         ]);
  839.     }
  841.     public function showJobs(Request $request, $paged = 0)
  842.     {
  843.         $jobs = $this->getDoctrine()->getRepository('App\Entity\Jobs')->createQueryBuilder('o');
  844.         $jobs->where('o.statuz = :statuz');
  845.         $jobs->setParameter('statuz', 'publish');
  846.         $jobs->orderBy('o.id', 'DESC');
  849. //        $jobs->setFirstResult( $paged * 30 );
  850. //        $jobs->setMaxResults(100);
  851.         $jobs = $jobs->getQuery()->getResult();
  854. //        dump(count($jobs));
  855. //        die;
  857.         $return  = array();
  859.         foreach($jobs as $job) {
  860.             if ($job->isExpired() == 1) continue;
  861.             $return[] = $job;
  862.         }
  864. //        dump('$return', $return);
  865. //        die;
  866.         return $this->render('new/jobs.html.twig', ['jobs' =>$return,
  867.             'settings' => $this->getSettings()
  868.             ]);
  869.     }
  874.     public function showClient(Request $request, $userNicename)
  875.     {
  876.         if($this->getUser() && $this->getUser()->getIsAdmin()) {
  877. //        die('fss2');
  878.         }
  879.         /** @var Clients $client */
  880.         $client = $this->getDoctrine()->getRepository('App\Entity\Clients')
  881.             ->findOneBy(array('userNicename' => $userNicename),
  882.                 array('id' => 'DESC')
  883.             );
  885.         $credits = $this->getDoctrine()->getRepository('App\Entity\Credits')
  886.             ->findBy(array('userId' => $client->getId()));
  888.         $trainings = $this->getDoctrine()->getRepository('App\Entity\Trainings')
  889.             ->findBy(array('id' => $client->getTrainings()));
  892.         $talent_groups = $this->getDoctrine()->getRepository('App\Entity\TalentGroup')->findAll();
  894.         if($client->getIsArchived() == true) {
  895.             if ($_SERVER['REMOTE_ADDR']=='90.248.44.247') {
  896.                 echo $client->getId();
  897.                 die("ffff");
  898.             }
  899.             return $this->redirect("https://fusionmng.com", 301);
  900.         }
  901.         $response =
  902.             $this->render('/new/client_public.html.twig', ['talent_groups' => $talent_groups, 'client' => $client, 'credits' => $credits, 'trainings' => $trainings, 'settings' => $this->getSettings()] );
  904.         $response->headers->addCacheControlDirective('no-cache', true);
  905.         $response->headers->addCacheControlDirective('must-revalidate', true);
  907.         return $response;
  908.     }
  910.     public function showClientMobile(Request $request, $userNicename)
  911.     {
  912.         $client = $this->getDoctrine()->getRepository('App\Entity\Clients')
  913.             ->findOneBy(array('userNicename' => $userNicename));
  915.         return
  916.             $this->render('theme::views.mobile.profile', ['client' => $client ]);
  918.     }
  920.     public function showForgot(Request $request)
  921.     {
  922.         return $this->render('new/forgot-password.html.twig',[
  923.             'settings' => $this->getSettings()
  924.         ]);
  925.     }
  927.     public function showMobileForgot(Request $request){
  928.         return $this->render('theme::views.mobile.forgot-password');
  929.     }
  931.     public function showReset(Request $request, $rememberToken)
  932.     {
  933.         $client = $this->getDoctrine()->getRepository('App\Entity\Clients')->findOneByRememberToken($rememberToken);
  935.         $session = $this->get('session');
  936. //        $session->getFlashBag()->set('success_reset', true);
  938. //        dump($session->get("success_reset"));
  939. //        die;
  941.         return $this->render('new/forgot-password-reset.html.twig', ['user' => $client, 'settings' => $this->getSettings()]);
  942.     }
  944.     public function doReset(Request $request, UserPasswordEncoderInterface $enc)
  945.     {
  946.         $client = $this->getDoctrine()->getRepository('App\Entity\Clients')->findOneById($request->request->all()['user']);
  947.         $new_pass = $request->request->all()['password'];
  948.         $new_pass_confirm = $request->request->all()['password_confirm'];
  950.         if($new_pass !== $new_pass_confirm) die('Bad password');
  952.         $encoded = $enc->encodePassword($client, $new_pass);
  954.         $client->setPassword($encoded);
  955.         $this->getDoctrine()->getManager()->persist($client);
  956.         $this->getDoctrine()->getManager()->flush();
  958.         $session = $this->get('session');
  959. $session->getFlashBag()->set('success_reset', true);
  962.         return $this->render('new/forgot-password-reset.html.twig', ['user' => $client->getId(), 'settings' => $this->getSettings()]);
  963.     }
  966.     public function doForgot(Request $request)
  967.     {
  969.         $client = $this->getDoctrine()->getRepository('App\Entity\Clients')->findOneByEmail($request->request->all()['email']);
  970.         $token = uniqid();
  971.         $client->setRememberToken($token);
  972. //        $new_pass = str_random(12);
  973. //        $client->setPassword($new_pass);
  975.         $this->getDoctrine()->getManager()->persist($client);
  976.         $this->getDoctrine()->getManager()->flush();
  977. //        dd($client);
  978. //        dd($client->getRememberToken());
  979. //        die;
  980.         if(!is_null($client))
  981.         {
  982.             $url = $this->getParameter('url');
  983.            $this->get("ses_mailer")->mailForgot(
  984.                 $client->getId() ,
  985.                 [
  986.                     'from'=>'admin@fusionmng.com',
  987.                     'subject' => 'Password reset instructions',
  988.                     'body' => "<a href='$url/password-reset/{$client->getRememberToken()}'>Click here</a> to change your password.<br/>You can as well visit link below:<br/>$url/password-reset/{$client->getRememberToken()}",
  989.                 ]);
  990.         } else {
  992.             die("Email incorrect, please double check it");
  993.         }
  995.         /** @var Session $session */
  996.         $session = $this->get('session');
  997.         $session->getFlashBag()->set('success', true);
  998. //        $session = $this->get('session');
  999. $session->getFlashBag()->set('success', true);
  1000.         return $this->redirect($request->server->get("HTTP_REFERER"));
  1001.     }
  1003.     public function showLogin(Request $request)
  1004.     {
  1005.         return $this->render('new/login.html.twig', ['settings' => $this->getSettings()]);
  1006.     }
  1008.     public function doLogout(Request $request){
  1009.         \Auth::logout();
  1010.         return $this->render('theme::views.original.login');
  1011.     }
  1013.     /** todo: remove or refactor */
  1014.     public function doLogin(Request $request)
  1015.     {
  1016.         dump('$request', $request);
  1017.         die;
  1018. // validate the info, create rules for the inputs
  1019.         $rules = array(
  1020.             //'email'    => 'required|email', // make sure the email is an actual email
  1021.             'password' => 'required|min:3' // password can only be alphanumeric and has to be greater than 3 characters
  1022.         );
  1024. // run the validation rules on the inputs from the form
  1025.         $validator = \Validator::make($request->request->all(), $rules);
  1027. // if the validator fails, redirect back to the form
  1028.         if ($validator->fails()) {
  1029.            // dd("Due to website version switch we require that you reset");
  1031.             return \Redirect::to('https://fusionmng.com/login')
  1032.                 ->withErrors($validator) // send back all errors to the login form
  1033.                 ->withInput($request->request->except('password')); // send back the input (not the password) so that we can repopulate the form
  1034.         } else {
  1037.             $userdata = array(
  1038.                 'email'     => trim($request->request->get('email')),
  1039.                 'password'  => trim($request->request->get('password'))
  1040.             );
  1042.             if (\Auth::attempt($userdata)) {
  1045.                 return \Redirect::intended('profile');
  1047.             } else {
  1049.                 return \Redirect::to('https://fusionmng.com/login');
  1051.             }
  1053.         }
  1054.     }
  1056.     public function updateSelectedClientsPriorities(Request $request)
  1057.     {
  1058.         $selectionName = null;
  1059.         $clientName = null;
  1060.         $clientToAdd = null;
  1061.         $clientImage = null;
  1062.         $priority = null;
  1063.         $clients_to_update = null;
  1065.         $redis = new \Redis();
  1066.         $redis->connect('localhost');
  1067.         $redis->auth("vanXGmC9kHuLRaSfn2QmtG8Pgxc7N7BPnLKam2hdM");
  1068.         $clients_to_update = json_decode($request->request->all()['clients'], true);
  1071.         if(isset($_REQUEST['selection_name'])) {
  1072.             $selectionName = $_REQUEST['selection_name'];
  1073.         } else if($clients_to_update && count($clients_to_update) > 0 && isset($clients_to_update[0]['user_id'])) {
  1074.             $selectionName = $clients_to_update[0]['user_id'];
  1075.         }
  1077.         $clients_selection = unserialize($redis->get($selectionName));
  1081.         $updated_selection = [];
  1083.         foreach($clients_to_update as $client_to_update) {
  1084.             unset($client_to_update['user_id']);
  1085.             $updated_selection[] = $client_to_update;
  1086.         }
  1088.         $redis->set($selectionName, serialize($updated_selection));
  1091.         return new JsonResponse([
  1092.             'updated' => $updated_selection,
  1093.             'original' => $clients_selection
  1094.         ]);
  1097.     }
  1099.     public function selectedClient(Request $request)
  1100.     {
  1101.         $selectionName = null;
  1102.         $clientName = null;
  1103.         $clientToAdd = null;
  1104.         $clientImage = null;
  1105.         $priority = null;
  1107.         if(isset($_REQUEST['selection_name'])) {
  1108.             $selectionName = $_REQUEST['selection_name'];
  1109.         } else  if(isset($_REQUEST['user_id'])) {
  1110.             $selectionName = $_REQUEST['user_id'];
  1111.         }
  1113.         if(isset($_REQUEST['clientName'])) {
  1114.             $clientName = $_REQUEST['clientName'];
  1115.         } else {
  1116.             $clientName = 'noClientName';
  1117.         }
  1119.         if(isset($_REQUEST['priority'])) {
  1120.             $priority = $_REQUEST['priority'];
  1121.         } else {
  1122.             $priority = 0;
  1123.         }
  1125.         if(isset($_REQUEST['client_image'])) {
  1126.             $client_image = $_REQUEST['client_image'];
  1127.         } else {
  1128.             $client_image = "noimg";
  1129.         }
  1131.         $redis = new \Redis();
  1132.         $redis->connect('localhost');
  1133.         $redis->auth("vanXGmC9kHuLRaSfn2QmtG8Pgxc7N7BPnLKam2hdM");
  1134.         $arr = unserialize($redis->get($selectionName));
  1136.         if(!is_array($arr)) {
  1137.             $arr = [];
  1138.         }
  1140.         $respo = '';
  1142.         if(isset($_REQUEST['clientId'])) {
  1143.             $clientToAdd = $_REQUEST['clientId'];
  1144.             $newArr = [];
  1145.             $clientFound = false;
  1146.             foreach ($arr as $client ) {
  1147.                 if($client['clientId'] != $clientToAdd) {
  1148.                     $newArr[] = $client;
  1149.                 } else {
  1150.                     $clientFound = true;
  1151.                     $newArr[] = [
  1152.                         'clientId' => $clientToAdd,
  1153.                         'clientName' => $clientName,
  1154.                         'priority' => $priority,
  1155.                         'client_image' => $client_image
  1156.                     ];
  1157.                 }
  1158.             }
  1159.             if($clientFound == false) {
  1160.                 $newArr[] = [
  1161.                     'clientId' => $clientToAdd,
  1162.                     'clientName' => $clientName,
  1163.                     'priority' => $priority,
  1164.                     'client_image' => $client_image
  1165.                 ];
  1166.             }
  1167.             $respo = $newArr;
  1168.             $arr = $newArr;
  1170.         } else if(isset($_REQUEST['client_to_remove'])) {
  1171.             //remove from array
  1172.             $newArr = [];
  1173.             foreach ($arr as $client ) {
  1174.                 if($client['clientId'] !== $_REQUEST['client_to_remove']){
  1175.                     $newArr[] = $client;
  1176.                 }
  1177.             }
  1178.             $respo = $newArr;
  1179.             $arr = $newArr;
  1180.         } else if(isset($_REQUEST['ClearSelection'])) {
  1181.             //clear array
  1182.             $arr = [];
  1183.         }
  1185.         $redis->set($selectionName, serialize($arr));
  1186.         return new JsonResponse($respo);
  1188.     }
  1190.     public function getSelectedClients(Request $request)
  1191.     {
  1192.         $selectionName = null;
  1193.         $clientName = null;
  1194.         $clientToAdd = null;
  1196.         if(isset($_REQUEST['user_id'])) {
  1197.             $selectionName = $_REQUEST['user_id'];
  1198.         }
  1200.         $redis = new \Redis();
  1201.         $redis->connect('localhost');
  1202.         $redis->auth("vanXGmC9kHuLRaSfn2QmtG8Pgxc7N7BPnLKam2hdM");
  1203.         $arr = unserialize($redis->get($selectionName));
  1204.         if(!is_array($arr)) {
  1205.             $arr = [];
  1206.         }
  1208. //        return $arr;
  1210.         usort($arr, function ($a, $b) {
  1211.             if (intval($a['priority']) == intval($b['priority'])) return 0;
  1212.             return (intval($a['priority']) > intval($b['priority'])) ? -1 : 1;
  1213.         });
  1215.         return new JsonResponse($arr);
  1216.     }
  1218.     public function showAboutUs(Request $request)
  1219.     {
  1220.         return $this->render('new/about_us.html.twig', ['settings' => $this->getSettings()]);
  1221.     }
  1222.     
  1223.     public function showSitemap(Request $request)
  1224.     {
  1225.         if ($_SERVER['REMOTE_ADDR']=='79.118.101.15.5') {
  1226.             $look_in='/usr/share/nginx/fusion';
  1227.             $allowed_files=array('twig');
  1228.             $search_for='the work we get our actors';
  1229.             function search_in_files ($search_for, $look_in, $allowed_files) {
  1230.                 $files=scandir($look_in);
  1231.                 foreach ($files as $key => $value) {
  1232.                     if (is_dir($look_in.'/'.$value) && !in_array(substr($value, 0, 1), array('.'))) {
  1233.                         search_in_files($search_for, $look_in.'/'.$value, $allowed_files);
  1234.                     } elseif (is_file($look_in.'/'.$value) && in_array(substr($value, strlen($value)-4), $allowed_files)) {
  1235.                         $fc=file_get_contents($look_in.'/'.$value);
  1236.                         if (strpos($fc, $search_for)!==false) {
  1237.                             echo $look_in.'/'.$value."<br>";
  1238.                         }
  1239.                     }
  1240.                 }
  1241.             }
  1242.             search_in_files($search_for, $look_in, $allowed_files);
  1243.             die("done");
  1244.         }
  1245.         return $this->render('new/sitemap.html.twig', ['settings' => $this->getSettings()]);
  1246.     }
  1248.     public function showHireTalents(Request $request)
  1249.     {
  1250.         return $this->render('new/hire_talents.html.twig', ['settings' => $this->getSettings()]);
  1251.     }
  1253.     public function showAgencyApplication(Request $request)
  1254.     {
  1255.         $session = $this->get('session');
  1257.             $suc = false;
  1258.             $success = $session->getFlashBag()->get('success_application');
  1259.             if(empty($success)) {
  1260.                 $suc = false;
  1261.             } else {
  1262.                 $suc = true;
  1263.             }
  1265.         return $this->render('new/application.html.twig', ['settings' => $this->getSettings(), 'success' => $suc]);
  1266.     }
  1269.     public function showSubmitJob(Request $request)
  1270.     {
  1271.         if($this->getUser() && $this->getUser()->getIsAdmin()) {
  1272.             return $this->render('new/submit-job.html.twig', ['settings' => $this->getSettings()]);
  1273.         } else {
  1274.             return $this->render('new/submit-job-non-admin.html.twig', ['settings' => $this->getSettings()]);
  1275.         }
  1276.     }
  1278.     public function showContact(Request $request)
  1279.     {
  1280.         return $this->render('new/contact.html.twig', ['settings' => $this->getSettings()]);
  1281.     }
  1283.     public function doContact(Request $request)
  1284.     {
  1285.         $mail = $this->get('ses_mailer')->mailContactForm($request, $this->get('twig'));
  1287.         return $this->render('new/contact.html.twig',['success'=>true,'settings' => $this->getSettings()]);
  1291.     }
  1292. }