1. <?php
3. namespace App\Controller\Master;
5. use App\Controller\Master\DefaultController as DefaultController;
8. use Symfony\Component\HttpFoundation\BinaryFileResponse;
9. use Symfony\Component\HttpFoundation\Request;
10. use Symfony\Component\HttpFoundation\Response;
11. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
12. use Symfony\Component\HttpFoundation\RedirectResponse;
13. use Symfony\Component\HttpFoundation\File\UploadedFile;
14. use Symfony\Component\HttpFoundation\JsonResponse;
15. use Symfony\Component\Cache\Adapter\FilesystemAdapter;
16. use Symfony\Component\HttpFoundation\RequestStack;
19. use Symfony\Component\Routing\Annotation\Route;
20. use Symfony\Component\Form\Forms;
22. use Doctrine\Common\Collections\Criteria;
24. use App\Form\Type\ContentType;
25. use App\Form\Type\ContentAdminType;
26. use App\Form\Type\CommentType;
28. use App\Entity\Content;
29. use App\Entity\Site;
30. use App\Entity\SiteConfig;
31. use App\Entity\ContentMeta;
32. use App\Entity\Comment;
33. use App\Entity\Category;
34. use App\Entity\Customer;
35. use App\Entity\CustomerPhone;
36. use App\Entity\CustomerAddress;
37. use App\Entity\Lead;
38. use App\Entity\User;
39. use App\Entity\Coupon;
40. use App\Entity\Product;
41. use App\Entity\Purchase;
42. use App\Entity\PurchaseItem;
43. use App\Entity\PurchaseNote;
44. use App\Entity\Media;
45. use App\Entity\MediaGroupItem;
46. use App\Entity\MediaGroup;
47. use App\Entity\MediaGroupContainer;
48. use App\Entity\Contact;
49. use App\Entity\ContentAnalyticsDaily;
50. use App\Entity\QuizQuestion;
52. use App\Form\Type\CustomerType;
53. use App\Form\Type\LeadType;
54. use App\Form\DirectoryLeadType;
56. use App\Utils\CategoryHelper;
57. use App\Utils\ContentHelper;
58. use App\Utils\CustomerHelper;
59. use App\Utils\ContactHelper;
60. use App\Utils\UserHelper;
61. use App\Utils\EmailHelper;
62. use App\Utils\OrderHelper;
63. use App\Utils\MediaHelper;
64. use App\Utils\MenuHelper;
65. use App\Utils\LeadHelper;
66. use App\Utils\PollHelper;
67. use App\Utils\QuizHelper;
68. use App\Utils\MailChimpHelper;
70. use App\Utils\HootsuiteHelper;
72. use Vich\UploaderBundle\Storage\StorageInterface;
73. use Vich\UploaderBundle\Mapping\PropertyMapping;
75. use Symfony\Component\DependencyInjection\ContainerInterface as Container;
77. use PhpOffice\PhpSpreadsheet\Spreadsheet;
78. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
81. use Google\Analytics\Data\V1beta\Client\BetaAnalyticsDataClient;
82. use Google\Analytics\Data\V1beta\DateRange;
83. use Google\Analytics\Data\V1beta\Dimension;
84. use Google\Analytics\Data\V1beta\Metric;
85. use Google\Analytics\Data\V1beta\RunReportRequest;
88. use Twig\Environment;
90. //TODO: Clean up uses in all controllers
92. class ContentController extends DefaultController
93. {
94.     /**
95.     * @Route("/uptime")
96.     */
97.     public function uptime(
98.         Request $request
99.     ) {
100.         $stmt = $this->getDoctrine()->getManager()->getConnection()->query("SELECT 1 + 1 as res");
101.         $res = $stmt->fetch();
102.         return new JsonResponse($res["res"], 200, [], true);
103.     }
105.     /**
106.     * @Route("/content-queue-test")
107.     */
108.     public function contentQueueTest(
109.         Request $request,
110.         ContentHelper $contentHelper
111.     ) {
112.         $session = $request->getSession();
113.         $content_ids = $session->get("queued_content_ids", []);
114.         return new JsonResponse(implode(", ", $content_ids), 200, [], true);
115.     }
117.     /**
118.     * @Route("/content-queue-clear")
119.     */
120.     public function contentQueueClear(
121.         Request $request,
122.         ContentHelper $contentHelper
123.     ) {
124.         $session = $request->getSession();
125.         $session->remove("queued_content_ids");
126.         return new JsonResponse("OK", 200, [], true);
127.     }
128.     
129.     
130.     //TODO: RCS only?
131.     public function contentMembersOnlyCheck($content) {
132.         if($content->getMembersOnly() && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
133.             $this->addFlash("warning", "This page is only accessible to RCS Club members. Continue below to become a member and access this page.");
134.             return $this->redirectToRoute("rcs-club-sign-up");
135.         }
136.     }
137.     
138.     //TODO: Why are these needed for admin edit routes?
139.     //      & move this to a different controller
140.     /**
141.      * @Route("/ckeditor_upload", name="ckeditor_upload")
142.      */
143.     public function ckeditor_upload (
144.         Request $request
145.     ) {
146.         
147.     }
148.     
149.     /**
150.      * @Route("/ckeditor_browse", name="ckeditor_browse")
151.      */
152.     public function ckeditor_browse (
153.         Request $request
154.     ) {
155.         return $this->defaultRender("easy_admin/file-browse.html.twig", [
156.         
157.         ]);
158.     }
160.     // displays the meet the rcs influencers page
161.     // requires a content object to be passed as $content
162.     public function meetinfluencers(
163.         Request $request,
164.         ContentHelper $helper,
165.         CustomerHelper $customerHelper,
166.         $content = ""
167.     ) {
168.         $cat_id = 479;
169.         if($this->site_code == 3) {//SiteConfig::SITE_MCS
170.             $cat_id = 1346;
171.         }
172.         if($this->site_code == 4) { //SiteConfig::SITE_CCS
173.             $cat_id = 1445;
174.         }
175.         $customers = $customerHelper->getCustomersByCategory($cat_id, $this->site_code);
176.         return $this->defaultRender("content/tmpl/meet-rcs-influencers.html.twig", [
177.             "content" => $content,
178.             "customers" => $customers,
179.         ]);
180.     }
182.     // displays the podcasts list page
183.     public function podcasts(
184.         Request $request,
185.         ContentHelper $helper,
186.         MediaHelper $mediaHelper,
187.         $content = ""
188.     ) {
189.         $podcasts = $helper->getContent(Content::PODCAST, $content->getSlug(), "published", "desc", 0, 0, true, "*", true)["content"];
191.         $images = [];
192.         foreach($podcasts as $c) {
193.             $cm = $c->getContentMetaByKey("podcast_image");
194.             if(is_null($cm) || $cm->getMetavalue() == 0) {
195.                 $images[] = "";
196.             }
197.             else {
198.                 $m = $mediaHelper->getMediaByOldId($cm->getMetavalue());
199.                 $images[] = $m;
200.             }
201.         }
203.         return $this->defaultRender("content/tmpl/podcasts.html.twig", [
204.             "content" => $content,
205.             "podcasts" => $podcasts,
206.             "images" => $images,
207.             "meta" => ["adGroup" => "rlw"],
208.         ]);
209.     }
210.     
211.     /**
212.      * @Route("/post/{slug}", name="post_master")
213.      */
214.     public function post(
215.         Request $request,
216.         ContentHelper $contentHelper,
217.         $slug = ""
218.     ) {
220.         /*if($this->site_code == Content::SITE_CCS && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
221.             return $this->redirectToRoute("sign-in_ccs");
222.         }*/
224.         $post = $contentHelper->getPostBySlug($slug);
225.         
226.         $recommendPost = $contentHelper->getRecommendedPosts($post->getCategory() ? $post->getCategory() : (!empty($post->getSecondaryCategories()) ? $post->getSecondaryCategories()[0] : null), 3, $post->getId());
228.         return $this->contentMembersOnlyCheck($post) ??
229.         $this->defaultRender("content/content.html.twig", [
230.             "content" => $post,
231.             "meta" => [
232.                 "title" => $post->getTitle(),
233.                 "recommended" => $recommendPost,
234.             ],
235.         ]);
236.     }
237.     
238.     /**
239.      * @Route("/gallery/{slug}",name="gallery_master")
240.      */
241.     public function gallery (
242.         Request $request,
243.         ContentHelper $helper,
244.         $slug
245.     ) {
246.         $gallery = $helper->getContentBySlug(Content::GALLERY, $slug);
247.         
248.         //TODO: Should we have site specific code here? or override in RCS controller?
249.         $breadcrumbs = [];
250.         if($this->site_code == Content::SITE_RCS) {
251.             $bread_title = "Roofing Galleries";
252.             $bread_href = "/roofing-galleries";
253.             $category = $gallery->getCategory();
254.             if($category && $category->getSlug() == "partner-galleries") {
255.                 $bread_title = "Partner Galleries";
256.                 $bread_href = "/partner-galleries";
257.             }
258.             $breadcrumbs[] = [
259.                 "title" => $bread_title,
260.                 "href" => $bread_href,
261.             ];
262.         }
263.         
264.         $breadcrumbs[] = [
265.             "title" => $gallery->getTitle(),
266.             "href" => "/partner-galleries/{$gallery->getSlug()}",
267.         ];
269.         return $this->defaultRender("content/content.html.twig", [
270.             "content" => $gallery,
271.             "pagenum" => 1,
273.             "meta" => [
274.                 "title" => $gallery->getTitle(),
275.                 "breadcrumbs" => $breadcrumbs
276.             ]
277.         ]);
278.     }
279.     
280.     /**
281.      * @Route("/podcast/{slug}", name="podcast_master")
282.      */
283.     public function podcast (
284.         Request $request,
285.         ContentHelper $helper,
286.         $slug = ""
287.     ) {
289.         $podcast = $helper->getContentBySlug(Content::PODCAST, $slug);
290.         
291.         $primaryCategory = $podcast->getCategory();
292.         $categories = $podcast->getSecondaryCategories();
293.         
294.         $breadcrumbs = [];
295.         
296.         $parent_breadcrumb = "";
297.         if($primaryCategory && $primaryCategory->getSlug() == "partner-podcast") {
298.             $breadcrumbs[] = [
299.                 "title" => "Partner Podcasts",
300.                 "href" => "/partner-podcast",
301.             ];
302.         }
303.         else {
304.             $breadcrumbs[] = [
305.                 "title" => "Podcasts",
306.                 "href" => "/podcasts",
307.             ];
308.         }
309.         
310.         foreach($categories as $category) {
311.             if($category->getTaxonomy() == "rcs-podcast-type") {
312.                 $parent_breadcrumb = [
313.                     "title" => $category->getTitle(),
314.                     "href" => "/podcasts/{$category->getSlug()}",
315.                 ];
316.             }
317.         }
318.         
319.         if($parent_breadcrumb) {
320.             $breadcrumbs[] = $parent_breadcrumb;
321.         }
322.         $breadcrumbs[] = [
323.             "title" => $podcast->getTitle(),
324.             "href" => "/podcast/{$podcast->getSlug()}",
325.         ];
326.         
327.         return $this->defaultRender("content/content.html.twig", [
328.             "content" => $podcast,
329.             "pagenum" => 1, //< is this needed?
331.             "meta" => array (
332.                 "title" => $podcast->getTitle(),
333.                 "breadcrumbs" => $breadcrumbs
334.             )
335.         ]);
337.     }
338.     
339.     /**
340.      * @Route("/webinar/{slug}", name="webinar_master")
341.      */
342.     public function webinar (
343.         Request $request,
344.         ContentHelper $helper,
345.         $slug = ""
346.     ) {
347.         $webinar = $helper->getContentBySlug(Content::WEBINAR, $slug);
348.         
349.         return $this->contentMembersOnlyCheck($webinar) ??
350.         $this->defaultRender("content/content.html.twig", [
351.             "content" => $webinar,
352.             "pagenum" => 1,
353.             "meta" => [
354.                 "title" => $webinar->getTitle(),
355.         "adgroup" => "rlw"
356.             ],
357.         ]);
358.     }
359.     
360.     /**
361.      * @Route("/promos-rebates/{slug}", name="promos_master")
362.      */
363.     public function promos (
364.         Request $request,
365.         ContentHelper $contentHelper,
366.         $slug
367.     ) {
368.         $promo = $contentHelper->getContentBySlug(Content::PROMOS_REBATES, $slug);
369.         return $this->defaultRender("content/content.html.twig", [
370.             "content" => $promo,
371.             "pagenum" => "",
373.             "meta" => [
374.                 "title" => $promo->getTitle(),
375.                 "breadcrumbs" => [
376.                     [
377.                         "title" => "Promos & Rebates", //TODO: rework breadcrumbs?
378.                         "href" => "/promos-rebates",
379.                     ],
380.                     [
381.                         "title" => $promo->getTitle(),
382.                         "href" => "/promo/{$promo->getSlug()}",
383.                     ],
384.                 ]
385.             ]
386.         ]);
387.     }
388.     
389.     /**
390.      * @Route("/ebooks/{slug}", name="ebook_master")
391.      */
392.     public function ebook (
393.         Request $request,
394.         ContentHelper $contentHelper,
395.         $slug
396.     ) {
397.         $ebook = $contentHelper->getContentBySlug(Content::EBOOK, $slug);
399.         $ebooksHref = "/ebooks";
400.         if($this->site_code == SiteConfig::SITE_AAR) {
401.             $ebooksHref = "/ebooks-aar";
402.         }
403.         elseif($this->site_code == SiteConfig::SITE_MCS) {
404.             $ebooksHref = "/ebooks-mcs";
405.         }
406.         elseif($this->site_code == SiteConfig::SITE_CCS) {
407.             $ebooksHref = "/ebooks";
408.         }
410.         return $this->defaultRender("content/content.html.twig", [
411.             "content" => $ebook,
412.             "pagenum" => 1,
414.             "meta" => [
415.                 "title" => $ebook->getTitle(),
416.                 "breadcrumbs" => [
417.                     [
418.                         "title" => "eBooks",
419.                         "href" => $ebooksHref,
420.                     ],
421.                     [
422.                         "title" => $ebook->getTitle(),
423.                         "href" => "/ebook/{$ebook->getSlug()}",
424.                     ],
425.                 ],
426.             ]
427.         ]);
428.     }
430.     public function ebooks(
431.         Request $request,
432.         ContentHelper $contentHelper,
433.         CategoryHelper $categoryHelper,
434.         CustomerHelper $customerHelper,
435.         $slug,
436.         $content = "",
437.         $customer = ""
438.     ) {
439.         
440.         if($slug == "partner-ebooks") {
441.             $eBooks = $contentHelper->getEbooks($customer);
442.             $customers = $customerHelper->customerHasEbooks();
443.             return $this->defaultRender("content/tmpl/ebooks.html.twig",[
444.                 "slug" => $slug,
445.                 "content" => $content,
446.                 "customers" => $customers,
447.                 "eBooks" => $eBooks,
448.                 "meta" => [
449.                     "title" => "Partner eBooks",
450.                     "breadcrumbs" => [
451.                         [
452.                             "title" => "Partner eBooks",
453.                             "href" => "/partner-ebooks",
454.                         ]
455.                     ],
456.                 ]
457.             ]);
458.         }
459.         else {
460.             $eBooks = $contentHelper->getEbooks();
461.             if($this->site_code == SiteConfig::SITE_AAR) {
462.                 $categories = $categoryHelper->getPopulatedCategoriesByTaxonomy('aar_ebook-category', $this->site_code);
463.             }
464.             else {
465.                 $categories = $categoryHelper->getPopulatedCategoriesByTaxonomy('ebook-category', $this->site_code);
466.             }
467.             foreach($categories as $key => $category) {
468.                 if($category->getSlug() == "ebooks-misfits") {
469.                     unset($categories[$key]);
470.                 }
471.             }
473.             $ebooksHref = "/ebooks";
474.             if($this->site_code == SiteConfig::SITE_AAR) {
475.                 $ebooksHref = "/ebooks-aar";
476.             }
477.             elseif($this->site_code == SiteConfig::SITE_MCS) {
478.                 $ebooksHref = "/ebooks-mcs";
479.             }
480.             elseif($this->site_code == SiteConfig::SITE_CCS) {
481.                 $ebooksHref = "/ebooks-ccs";
482.             }
483.             
484.             return $this->defaultRender("content/tmpl/ebooks.html.twig",[
485.                 "slug" => $slug,
486.                 "content" => $content,
487.                 "categories" => $categories,
488.                 "eBooks" => $eBooks,
489.                 "meta" => [
490.                     "title" => "eBooks",
491.                     "breadcrumbs" => [
492.                         [
493.                             "title" => "eBooks",
494.                             "href" => $ebooksHref,
495.                         ]
496.                     ],
497.                 ]
498.             ]);
499.         }
500.     }
501.     
502.     /**
503.      * @Route("/contests-and-games/{slug}",
504.      *      requirements={"slug"="^[a-zA-Z0-9\-]+$"},
505.      *      name="contests_master"
506.      * )
507.      */
508.     public function contests (
509.         Request $request,
510.         ContentHelper $contentHelper,
511.         $slug
512.     ) {
513.         $contest = $contentHelper->getContentBySlug(Content::CONTEST_GAMES, $slug);
514.         return $this->defaultRender("content/content.html.twig", [
515.             "content" => $contest,
516.             "pagenum" => 1,
518.             "meta" => [
519.                 "title" => $contest->getTitle(),
520.                 "breadcrumbs" => [
521.                     [
522.                         "title" => "Contests & Games",
523.                         "href" => "/contests-and-games",
524.                     ],
525.                     [
526.                         "title" => $contest->getTitle(),
527.                         "href" => "/contests-and-games/{$contest->getSlug()}",
528.                     ]
529.                 ]
530.             ]
531.         ]);
534.     }
535.     
536.     /**
537.      * @Route("/award/{slug}", name="award_master")
538.      */
539.     public function award (
540.         Request $request,
541.         ContentHelper $contentHelper,
542.         $slug
543.     ) {
544.         $award = $contentHelper->getContentBySlug(Content::AWARD, $slug);
545.         return $this->defaultRender("content/content.html.twig", [
546.             "content" => $award,
547.             "pagenum" => "",
549.             "meta" => array (
550.                 "title" => $award->getTitle(),
551.                 "breadcrumbs" => array (
552.                     array (
553.                         "title" => "Awards",
554.                         "href" => "/awards",
555.                     ),
556.                     array (
557.                         "title" => $award->getTitle(),
558.                         "href" => "/award/{$award->getSlug()}",
559.                     ),
560.                 )
561.             )
562.         ]);
563.     }
564.     
565.     /**
566.      * @Route("/scholarship/{slug}", name="scholarship_master")
567.      */
568.     public function scholarship (
569.         Request $request,
570.         ContentHelper $contentHelper,
571.         $slug
572.     ) {
573.         $scholarship = $contentHelper->getContentBySlug(Content::SCHOLARSHIP, $slug);
574.         return $this->defaultRender("content/content.html.twig", [
575.             "content" => $scholarship,
576.             "pagenum" => "",
578.             "meta" => array (
579.                 "title" => $scholarship->getTitle(),
580.                 "breadcrumbs" => array (
581.                     array (
582.                         "title" => "Scholarships",
583.                         "href" => "/scholarships",
584.                     ),
585.                     array (
586.                         "title" => $scholarship->getTitle(),
587.                         "href" => "/scholarship/{$scholarship->getSlug()}",
588.                     ),
589.                 )
590.             )
591.         ]);
592.     }
594.     /**
595.      * @Route("/video/{slug}", name="video_master")
596.      */
597.     public function video (
598.         Request $request,
599.         ContentHelper $contentHelper,
600.         $slug
601.     ) {
602.         $video = $contentHelper->getContentBySlug(Content::VIDEO, $slug);
603.         return $this->defaultRender("content/content.html.twig", [
604.             "content" => $video,
605.             "pagenum" => "",
607.             "meta" => array (
608.                 "title" => $video->getTitle(),
609.                 "breadcrumbs" => array (
610.                     array (
611.                         "title" => "Videos",
612.                         "href" => "/videos",
613.                     ),
614.                     array (
615.                         "title" => $video->getTitle(),
616.                         "href" => "/video/{$video->getSlug()}",
617.                     ),
618.                 )
619.             )
620.         ]);
621.     }
623.     /**
624.      * @Route("/r-club-perk/{slug}", name="r-club-perk_master")
625.      */
626.     public function rClubPerk (
627.         Request $request,
628.         ContentHelper $contentHelper,
629.         $slug
630.     ) {
631.         $perk = $contentHelper->getContentBySlug(Content::R_CLUB_PERK, $slug);
632.         return $this->defaultRender("content/content.html.twig", [
633.             "content" => $perk,
634.             "pagenum" => "",
636.             "meta" => array (
637.                 "title" => $perk->getTitle(),
638.                 "breadcrumbs" => array (
639.                     array (
640.                         "title" => "R-Club Perks",
641.                         "href" => "/members-only",
642.                     ),
643.                     array (
644.                         "title" => $perk->getTitle(),
645.                         "href" => "/r-club-perk/{$perk->getSlug()}",
646.                     ),
647.                 )
648.             )
649.         ]);
650.     }
651.     
652.     
653.     /**
654.      * Classified Listing Route
655.      *
656.      * @Route(
657.      *      "/our-listings/{page}/{keywords}/{location}/{category}/{areas}",
658.      *      defaults={ "page"="_", "keywords"="_", "location"="_", "category"="_", "areas"="_" },
659.      *      name="classifiedIndex_master",
660.      *      methods={"GET"}
661.      * )
662.      */
663.     public function classifiedIndex (
664.         Request $request,
665.         ContentHelper $contentHelper,
666.         CategoryHelper $categoryHelper,
667.         $page = "_",
668.         $keywords = "_",
669.         $location = "_",
670.         $category = "_",
671.         $areas = "_"
672.     ) {
674.         try {
676.             $pagingSize = 25;
678.             $group = $request->get("c");
679.             if ($group) {
680.                  $group = $categoryHelper->getCategoryBySlug($group);
681.             }
683.             $records = $contentHelper->getClassifiedListings($page, $keywords, $location, $category, $areas, $group, $pagingSize);
684.             if(empty($records["listings"])) {
685.                 //If no listings are found, try again on the first page. Prevents going past the final page due to pressing multiple buttons at once.
686.                 $page = 0;
687.                 $records = $contentHelper->getClassifiedListings($page, $keywords, $location, $category, $areas, $group, $pagingSize);
688.             }
689.             $listingCategories = $categoryHelper->getCategoriesByTaxonomy("job_listing_category");
690.             $listingAreas = $categoryHelper->getCategoriesByTaxonomy("job_listing_type");
692.             $dynamic_content = $contentHelper->getStaticPageBySlug("static-rcs-classified-index");
693.             if($dynamic_content) {
694.                 $dynamic_content = $dynamic_content->getContentFull();
695.             }
697.             return $this->defaultRender("content/classified-index.html.twig", [
698.                 "dynamic_content" => $dynamic_content,
699.                 "listings" => $records["listings"],
700.                 "totalListings" => $records["total"],
701.                 "listingCategories" => $listingCategories,
702.                 "listingAreas" => $listingAreas,
704.                 "group" => (($group) ? $group->getSlug() : ""),
706.                 "page" => $page,
707.                 "pagingSize" => $pagingSize,
709.                 "keywords" => $keywords == "_" ? "" : $keywords,
710.                 "location" => $location == "_" ? "" : $location,
711.                 "category" => $category == "_" ? "" : $category,
712.                 "areas" => $areas == "_" ? "" : explode("-", $areas),
714.                 "meta" => [
715.                     "title" => "Our Classified Listings",
716.                     "breadcrumbs" => [
717.                         [
718.                             "title" => "Our Classified Listings",
719.                             "href" => "/our-listings" . (($group) ? "?c={$group->getSlug()}" : ""), // make sure to include any sorting categories
720.                         ]
721.                     ]
722.                 ]
724.             ]);
726.         } catch (\Exception $e) {
727.             throw $e;
728.         }
729.     }
730.     
731.     /**
732.      * @Route("/listing/{slug}", name="classified_master")
733.      */
734.     public function classified(
735.         Request $request,
736.         ContentHelper $helper,
737.         $slug = ""
738.     ) {
739.         $listing = $helper->getClassifiedBySlug($slug);
740.         $meta_collection = $listing->getContentmeta();
741.         $content_meta = array();
743.         foreach($meta_collection as $meta) {
744.             $content_meta[$meta->getMetakey()] = $meta->getMetavalue();
745.         }
747.         $category_collection = $listing->getSecondaryCategories();
748.         $regions = array();
750.         foreach($category_collection as $category) {
751.             if($category->getTaxonomy() == "job_listing_type") {
752.                 $regions[] = $category->getTitle();
753.             }
754.         }
756.         if(count($regions) > 1) {
757.             $region = "Multiple";
758.         }
759.         elseif(count($regions) == 1) {
760.             $region = $regions[0];
761.         }
762.         else {
763.             //Should never be empty
764.             $region = "No Region";
765.         }
766.         
767.         return $this->defaultRender("content/content.html.twig", [
768.             "content" => $listing,
769.             "content_meta" => $content_meta,
770.             "region" => $region,
771.             "autoplay" => isset($_GET['autoplay']) && $_GET["autoplay"] == 1 ? true : false,
773.             "meta" => [
774.                 "title" => "Our Classified Listings",
775.                 "breadcrumbs" => [
776.                     [
777.                         "title" => "Our Classified Listings",
778.                         "href" => "/our-listings",
779.                     ],
781.                     [
782.                         "title" => $listing->getTitle(),
783.                         "href" => "/listing/{$listing->getSlug()}"
784.                     ]
785.                 ]
786.             ]
787.         ]);
788.     }
789.     
790.     /**
791.     * @Route(name="classified_request_info", methods={"POST"})
792.     */
793.     public function classifiedRequestInfo(
794.         Request $request,
795.         ContentHelper $contentHelper,
796.         EmailHelper $emailHelper
797.     ) {
798.         $referer = $request->headers->get('referer');
799.         
800.         if($emailHelper->checkCaptcha($request->get("g-recaptcha-response"))) {
801.             $l = $request->get("lead");
803.             $lead = new Lead();
804.             $lead->setFirstname($request->get('fname'));
805.             $lead->setLastname($request->get('lname'));
806.             $lead->setEmail($request->get('email'));
808.             $lead->setIpAddress($request->getClientIp());
809.             $lead->setRefUrl($request->headers->get("referer"));
810.             $lead->setUserAgent($request->headers->get("User-Agent"));
812.             $ref_url = $request->headers->get("referer");
813.             if($ref_url) {
814.                 $slug = strtok(substr($ref_url, strrpos($ref_url, '/') + 1), '?');
815.                 if($slug) {
816.                     $content = $contentHelper->getContentBySlugRaw($slug);
817.                     $lead->setContent($content);
818.                 }
819.             }
821.             $em = $this->getDoctrine()->getManager();
822.             $em->persist($lead);
823.             $em->flush();
825.             $pooled = null;
826.             if($request->get("contact_email")) {
827.                 $reply_text = $request->get('fname') ? "Click here to respond to {$request->get('fname')}" : "Click here to reply";
828.                 $pooled = $emailHelper->sendEmail(trim($request->get("contact_email")), "New submission from Classified Listing Contact Form", [
829.                     ["p" => "Hello {$request->get('contact_name')},"],
830.                     ["p" => "{$request->get('fname')} {$request->get('lname')} ({$request->get('email')}) has replied to your \"{$request->get('listing_title')}\" classified listing with the following message:"],
831.                     ["p" => "{$request->get('message')}"],
832.                     ["button" => ["href" => "mailto:{$request->get('email')}", "text" => $reply_text]],
833.                 ], $request->files);
834.             }
835.             if ($pooled) {
837.                 $emailHelper->sendEmail($request->get("email"), "Classified Listing Contact Confirmation", [
838.                     ["p" => "Thanks for contacting us! We will get in touch with you shortly."],
839.                 ]);
842.                 $this->addFlash("success", "Thanks for contacting us! We will get in touch with you shortly.");
843.                 return new RedirectResponse($referer);
845.                 /*
846.                 The flash message isn't being displayed with this method... and if you opened another page in a different tab, it will mess up last_route.
847.                 print_r($session->get("last_route"));
848.                 return $this->redirectToRoute($session->get("last_route")["name"], array_merge($session->get("last_route")["params"], ["message" => ["type" => "success", "text" => "Email sent"]]));
849.                 */
850.             }
851.         }
852.         else {
853.             //temp2-5
854.             //$this->addFlash("danger", "The reCAPTCHA was invalid. Please try again.");
855.             return new RedirectResponse($referer);
856.         }
857.         $session = $request->getSession();
858.         $session->getFlashBag()->add('danger', 'There was an error sending your request. Please try again later.');
859.         return new RedirectResponse($referer);
861.     }
862.     
863.     //--Directory Start--
864.     /**
865.      * @Route(
866.      *      "/our-directory/{page}/{category}/{type}/{search}/{location}/{state}",
867.      *      defaults={"page"="", "category"="", "type"="", "search"="", "location"="", "state"=""},
868.      *      name="directoryIndex_master",
869.      *      methods={"GET"}
870.      * )
871.      */
872.     public function directoryIndex (
873.         Request $request,
874.         ContentHelper $helper,
875.         $page = "",
876.         $category = "",
877.         $type = "",
878.         $search = "",
879.         $location = "",
880.         $state = ""
881.     ) {
884.         $page = (int) $page;
885.         $records = $helper->getDirectoryListings($page, $category, $type, $search, $location, $state);
886.         $categories = $helper->getDirectoryCategories();
887.         $stateOptions = Customer::STATES_PROVINCES;
889.         $search = ($search == "_") ? "" : $search;
891.         $breadcrumbs = [
892.             [
893.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
894.                 "href" => "/our-directory/",
895.             ]
896.         ];
898.         return $this->defaultRender("content/directory.html.twig", [
899.             "listings" => $records["listings"],
900.             "total" => $records["total"],
901.             "page" => $page,
902.             "limit" => ContentHelper::DEFAULT_LIMIT,
903.             "search" => $search,
904.             "locations" => $location,
905.             "states" => $state,
906.             "stateOptions" => $stateOptions,
907.             "categories" => $categories,
908.             "category" => $category,
909.             "filters" => $type,
910.             "show_filters" => $request->query->get("filter") !== "0",
912.             "meta" => [
913.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
914.                 "breadcrumbs" => $breadcrumbs,
915.             ]
916.         ]);
918.     }
919.     
920.     
921.     /**
922.      * @Route(
923.      *      "/directory/{slug}",
924.      *      name="directory_page_master",
925.      *      methods={"GET"}
926.      * )
927.      */
928.     public function directory(
929.         Request $request,
930.         ContentHelper $helper,
931.         CategoryHelper $categoryHelper,
932.         $slug = ""
933.     ) {
935.         $directory = $helper->getDirectoryBySlug($slug);
936.         //$customer = $directory->getCustomers()->first();
937.         $customer = $directory->getDirectory();
939.         $level = $customer->getCustomerLevelString($this->site_code);
940.         $types = $customer->getCustomerTypeArray();
942.         // hide or show areas of template
944.         /*
945.         $show_promotions = (
946.             (in_array(Customer::TYPE_DISTRIBUTORS_STRING, $types) && ($level == "Partner" || $level == "Premium" || $level == "Best" || $level == "Better" || $level == "Good")) ||
947.             (in_array(Customer::TYPE_PRODUCTS_SERVICES_STRING, $types) && ($level == "Partner" || $level == "Premium" || $level == "Best" || $level == "Better" || $level == "Good")) ||
948.             (in_array(Customer::TYPE_ASSOCIATIONS_STRING, $types)) ||
949.             (in_array(Customer::TYPE_RCS_PARTNERS_STRING, $types))
950.         );
951.         */
952.         
953.         $show_promotions = $level && $level != "Standard";
955.         // In case we want to break this up more
956.         $show_photos = $show_promotions;
957.         $show_videos = $show_promotions;
958.         $show_education = $show_promotions;
959.         $show_ebooks = $show_promotions;
960.         $show_contestgames = $show_promotions;
961.         $show_awards = $show_promotions;
962.         $show_scholarships = $show_promotions;
963.         $show_upcoming = $show_promotions;
964.         $show_newsletters = $show_promotions;
965.         $show_coffeeblog = $show_promotions;
966.         $show_literature = $show_promotions;
967.         $show_podcasts = $show_promotions;
968.         $show_webinars = $show_promotions;
969.         $show_classifieds = $show_promotions;
970.         $show_buy_online = $show_promotions;
971.         $show_video = $show_promotions;
972.         $show_products = $show_promotions;
973.         
974.         //Todo: use content helper function to pull these
975.         //Spanish
976.         try {
977.           $spanishCat = $categoryHelper->getCategoryBySlug("en-espanol")->getId();
978.         }catch(\Exception $e) {
979.           $spanishCat = null;
980.         }
981.         $spanish_content = [];
982.         
983.         if($spanishCat) {
984.           $sql = implode(" ", [
985.             "SELECT content",
986.             "FROM",
987.               "App\Entity\Content content",
988.             "JOIN ",
989.               "content.secondary_categories sc",
990.             "LEFT JOIN ",
991.               "content.customers c",
992.             "WHERE",
993.                 "sc.id = :id and content.status = 1 and c.id = :cid",
994.             "ORDER BY content.created_at DESC",
995.           ]);
996.           
997.           $entityManager = $this->getDoctrine()->getManager();
998.           $query = $entityManager->createQuery($sql)
999.             ->setParameter(":id", $spanishCat)
1000.             ->setParameter( ":cid", $customer->getId())
1001.             ->setFirstResult(0)
1002.             ->setMaxResults(4);
1003.             
1004.           $spanish_content = $query->getResult();
1005.         }
1007.         //International
1008.         try {
1009.             $intCat = $categoryHelper->getCategoryBySlug("international")->getId();
1010.           }catch(\Exception $e) {
1011.             $intCat = null;
1012.           }
1013.           $int_content = [];
1014.           
1015.           if($intCat) {
1016.             $sql = implode(" ", [
1017.               "SELECT content",
1018.               "FROM",
1019.                 "App\Entity\Content content",
1020.               "JOIN ",
1021.                 "content.secondary_categories sc",
1022.               "LEFT JOIN ",
1023.                 "content.customers c",
1024.               "WHERE",
1025.                   "sc.id = :id and content.status = 1 and c.id = :cid",
1026.               "ORDER BY content.created_at DESC",
1027.             ]);
1028.             
1029.             $entityManager = $this->getDoctrine()->getManager();
1030.             $query = $entityManager->createQuery($sql)
1031.               ->setParameter(":id", $intCat)
1032.               ->setParameter( ":cid", $customer->getId())
1033.               ->setFirstResult(0)
1034.               ->setMaxResults(4);
1035.               
1036.             $int_content = $query->getResult();
1037.           }
1039.           //Canada
1040.           try {
1041.             $canadaCat = $categoryHelper->getCategoryBySlug("canada")->getId();
1042.           }catch(\Exception $e) {
1043.             $canadaCat = null;
1044.           }
1045.           $canada_content = [];
1046.           
1047.           if($canadaCat) {
1048.             $sql = implode(" ", [
1049.               "SELECT content",
1050.               "FROM",
1051.                 "App\Entity\Content content",
1052.               "JOIN ",
1053.                 "content.secondary_categories sc",
1054.               "LEFT JOIN ",
1055.                 "content.customers c",
1056.               "WHERE",
1057.                   "sc.id = :id and content.status = 1 and c.id = :cid",
1058.               "ORDER BY content.created_at DESC",
1059.             ]);
1060.             
1061.             $entityManager = $this->getDoctrine()->getManager();
1062.             $query = $entityManager->createQuery($sql)
1063.               ->setParameter(":id", $canadaCat)
1064.               ->setParameter( ":cid", $customer->getId())
1065.               ->setFirstResult(0)
1066.               ->setMaxResults(4);
1067.               
1068.             $canada_content = $query->getResult();
1069.           }
1070.         
1071.         
1072.         
1073.         // Whether to hide the footer ad - should this be used?
1074.         //$hide_ad = $row["level"] != "Standard";
1075.         
1076.         
1077.         $breadcrumbs = [
1078.             [
1079.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1080.                 "href" => "/our-directory/",
1081.             ],
1082.             [
1083.                 "title" => $directory->getTitle(),
1084.                 "href" => "/directory/{$directory->getSlug()}",
1085.             ]
1086.         ];
1087.         return $this->defaultRender("content/content.html.twig", [
1088.             "content" => $directory,
1089.             "customer" => $customer,
1090.             "show_promotions" => $show_promotions,
1091.             "show_photos" => $show_photos,
1092.             "show_videos" => $show_videos,
1093.             "show_education" => $show_education,
1094.             "show_ebooks" => $show_ebooks,
1095.             "show_contestgames" => $show_contestgames,
1096.             "show_awards" => $show_awards,
1097.             "show_scholarships" => $show_scholarships,
1098.             "show_upcoming" => $show_upcoming,
1099.             "show_newsletters" => $show_newsletters,
1100.             "show_coffeeblog" => $show_coffeeblog,
1101.             "show_literature" => $show_literature,
1102.             "show_podcasts" => $show_podcasts,
1103.             "show_webinars" => $show_webinars,
1104.             "show_classifieds" => $show_classifieds,
1105.             "show_buy_online" => $show_buy_online,
1106.             "show_products" => $show_products,
1107.             "show_video" => $show_video,
1108.             "buy_online_posts" => $helper->getPaginatedContentByType(Content::POST, 4, 1, "", $customer, "buy-online", false),
1109.             "video_posts" => $helper->getPaginatedContentByType(Content::POST, 3, 1, "", $customer, "partner-videos", false),
1110.             "latest_news" => $helper->getPaginatedContentByType(Content::POST, 3, 1, "", $customer, "newsroom", false),
1111.             "upcoming_events" => $helper->getPaginatedContentByType(Content::EVENT, 3, 1, "", $customer, "", false),
1112.             "lunch_and_learn" => $helper->getPaginatedContentByType(Content::WEBINAR, 3, 1, "", $customer, "on-demand-lunch-learn", false),
1113.             "webinars" => $helper->getPaginatedContentByType(Content::WEBINAR, 3, 1, "", $customer, "", false, "on-demand-lunch-learn"),
1114.             "spanish_content" => $spanish_content,
1115.             "int_content" => $int_content,
1116.             "canada_content" => $canada_content,
1117.             "email_is_valid" => filter_var($customer->getEmail(), FILTER_VALIDATE_EMAIL),
1118.             "meta" => [
1119.                 "title" => $directory->getTitle(),
1120.                 "breadcrumbs" => $breadcrumbs,
1121.                 "root" => "/directory/".$directory->getSlug(),
1122.             ]
1123.         ]);
1124.     }
1125.     
1126.     /**
1127.      * @Route("/directory/{slug}/posts/{page}", name="directory_posts_master")
1128.      */
1129.     public function directoryPosts(
1130.         Request $request,
1131.         ContentHelper $helper,
1132.         $slug = "",
1133.         $page = 1
1134.     ) {
1135.         $directory = $helper->getDirectoryBySlug($slug);
1136.         $customer = $directory->getDirectory();
1137.         
1138.         $length = 10;
1139.         $posts = $helper->getPaginatedContentByType(Content::POST, $length, $page, "", $customer, "newsroom", false);
1140.         $total = $helper->countPostsByCustomer($customer);
1142.         $breadcrumbs = [
1143.             [
1144.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1145.                 "href" => "/our-directory/",
1146.             ],
1147.             [
1148.                 "title" => $directory->getTitle(),
1149.                 "href" => "/directory/{$directory->getSlug()}",
1150.             ],
1151.             [
1152.                 "title" => "Posts",
1153.                 "href" => "/directory/{$directory->getSlug()}/posts",
1154.             ]
1155.         ];
1156.         return $this->defaultRender("content/post.html.twig", [
1157.             "customer" => $customer,
1158.             "posts" => $posts,
1159.             "total" => $total,
1160.             "length" => $length,
1161.             "page" => $page,
1163.             "meta" => [
1164.                 "title" => $directory->getTitle(),
1165.                 "breadcrumbs" => $breadcrumbs,
1166.                 "root" => "/directory/".$directory->getSlug()."/posts",
1167.             ]
1168.         ]);
1169.     }
1170.     
1171.     
1172.     /**
1173.        * @Route("/directory/{slug}/content/buy-online/{page}", name="directory_buyonline_content_master")
1174.        */
1175.     public function directoryBuyOnlineContent(
1176.       Request $request,
1177.       ContentHelper $helper,
1178.       $slug = "",
1179.       $type = "2",
1180.       $page = 1
1181.     ) {
1182.         $directory = $helper->getDirectoryBySlug($slug); // get directory from url
1183.         //$customer = $directory->getCustomers()->first(); // gets the directory customer
1184.         $customer = $directory->getDirectory();
1186.         $length = 10; //10 per page
1187.         
1188.         $contents = $helper->getContent(
1189.           "*",
1190.            "buy-online",
1191.            "published",
1192.            "desc",
1193.            ($page - 1),
1194.            $length,
1195.            true,
1196.            "*",
1197.            true, //secondary categories
1198.            false,
1199.            false,
1200.            false,
1201.           $customer->getId()
1202.           );
1203.         $total = $contents["total"];
1204.         $posts = $contents["content"];
1206.         $breadcrumbs = [
1207.           [
1208.             "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1209.             "href" => "/our-directory/",
1210.           ],
1211.           [
1212.             "title" => $directory->getTitle(),
1213.             "href" => "/directory/{$directory->getSlug()}",
1214.           ],
1215.           [
1216.             "title" => "Buy Online",
1217.             "href" => "/directory/{$directory->getSlug()}/buy-online",
1218.           ]
1219.         ];
1220.         return $this->defaultRender("content/post.html.twig", [
1221.           "customer" => $customer,
1222.           "posts" => $posts,
1223.           "total" => $total,
1224.           "length" => $length,
1225.           "page" => $page,
1226.           "meta" => [
1227.             "title" => $directory->getTitle(),
1228.                     "breadcrumbs" => $breadcrumbs,
1229.                     "root" => "/directory/".$directory->getSlug()."/content/buy-online",
1230.           ]
1231.         ]);
1232.     }
1235.     //todo: make these types of routes generic
1237.     /**
1238.      * @Route("/directory/{slug}/content/spanish/{page}", name="directory_spanish_content_master")
1239.      */
1240.     public function directorySpanishContent(
1241.     Request $request,
1242.     ContentHelper $helper,
1243.     $slug = "",
1244.     $type = "2",
1245.     $page = 1
1246.     ) {
1247.         $directory = $helper->getDirectoryBySlug($slug); // get directory from url
1248.         //$customer = $directory->getCustomers()->first(); // gets the directory customer
1249.         $customer = $directory->getDirectory();
1251.         $length = 10; //10 per page
1252.         
1253.         $contents = $helper->getContent(
1254.         "*",
1255.             "en-espanol",
1256.             "published",
1257.             "desc",
1258.             ($page - 1),
1259.             $length,
1260.             true,
1261.             "*",
1262.             true, //secondary categories
1263.             false,
1264.             false,
1265.             false,
1266.         $customer->getId()
1267.         );
1268.         $total = $contents["total"];
1269.         $posts = $contents["content"];
1271.         $breadcrumbs = [
1272.         [
1273.             "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1274.             "href" => "/our-directory/",
1275.         ],
1276.         [
1277.             "title" => $directory->getTitle(),
1278.             "href" => "/directory/{$directory->getSlug()}",
1279.         ],
1280.         [
1281.             "title" => "Spanish Content",
1282.             "href" => "/directory/{$directory->getSlug()}/spanish",
1283.         ]
1284.         ];
1285.         return $this->defaultRender("content/post.html.twig", [
1286.         "customer" => $customer,
1287.         "posts" => $posts,
1288.         "total" => $total,
1289.         "length" => $length,
1290.         "page" => $page,
1291.         "meta" => [
1292.             "title" => $directory->getTitle(),
1293.                     "breadcrumbs" => $breadcrumbs,
1294.                     "root" => "/directory/".$directory->getSlug()."/content/spanish",
1295.         ]
1296.         ]);
1297.     }
1299.     
1300.     /**
1301.      * @Route("/directory/{slug}/content/international/{page}", name="directory_international_content_master")
1302.      */
1303.     public function directoryInternationalContent(
1304.         Request $request,
1305.         ContentHelper $helper,
1306.         $slug = "",
1307.         $type = "2",
1308.         $page = 1
1309.         ) {
1310.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
1311.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
1312.             $customer = $directory->getDirectory();
1313.     
1314.             $length = 10; //10 per page
1315.             
1316.             $contents = $helper->getContent(
1317.             "*",
1318.                 "international",
1319.                 "published",
1320.                 "desc",
1321.                 ($page - 1),
1322.                 $length,
1323.                 true,
1324.                 "*",
1325.                 true, //secondary categories
1326.                 false,
1327.                 false,
1328.                 false,
1329.             $customer->getId()
1330.             );
1331.             $total = $contents["total"];
1332.             $posts = $contents["content"];
1333.     
1334.             $breadcrumbs = [
1335.             [
1336.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1337.                 "href" => "/our-directory/",
1338.             ],
1339.             [
1340.                 "title" => $directory->getTitle(),
1341.                 "href" => "/directory/{$directory->getSlug()}",
1342.             ],
1343.             [
1344.                 "title" => "International Content",
1345.                 "href" => "/directory/{$directory->getSlug()}/international",
1346.             ]
1347.             ];
1348.             return $this->defaultRender("content/post.html.twig", [
1349.             "customer" => $customer,
1350.             "posts" => $posts,
1351.             "total" => $total,
1352.             "length" => $length,
1353.             "page" => $page,
1354.             "meta" => [
1355.                 "title" => $directory->getTitle(),
1356.                         "breadcrumbs" => $breadcrumbs,
1357.                         "root" => "/directory/".$directory->getSlug()."/content/international",
1358.             ]
1359.             ]);
1360.         }
1362.         
1363.     /**
1364.      * @Route("/directory/{slug}/content/canada/{page}", name="directory_canada_content_master")
1365.      */
1366.     public function directoryCanadaContent(
1367.         Request $request,
1368.         ContentHelper $helper,
1369.         $slug = "",
1370.         $type = "2",
1371.         $page = 1
1372.         ) {
1373.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
1374.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
1375.             $customer = $directory->getDirectory();
1376.     
1377.             $length = 10; //10 per page
1378.             
1379.             $contents = $helper->getContent(
1380.             "*",
1381.                 "canada",
1382.                 "published",
1383.                 "desc",
1384.                 ($page - 1),
1385.                 $length,
1386.                 true,
1387.                 "*",
1388.                 true, //secondary categories
1389.                 false,
1390.                 false,
1391.                 false,
1392.             $customer->getId()
1393.             );
1394.             $total = $contents["total"];
1395.             $posts = $contents["content"];
1396.     
1397.             $breadcrumbs = [
1398.             [
1399.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1400.                 "href" => "/our-directory/",
1401.             ],
1402.             [
1403.                 "title" => $directory->getTitle(),
1404.                 "href" => "/directory/{$directory->getSlug()}",
1405.             ],
1406.             [
1407.                 "title" => "Canada Content",
1408.                 "href" => "/directory/{$directory->getSlug()}/canada",
1409.             ]
1410.             ];
1411.             return $this->defaultRender("content/post.html.twig", [
1412.             "customer" => $customer,
1413.             "posts" => $posts,
1414.             "total" => $total,
1415.             "length" => $length,
1416.             "page" => $page,
1417.             "meta" => [
1418.                 "title" => $directory->getTitle(),
1419.                         "breadcrumbs" => $breadcrumbs,
1420.                         "root" => "/directory/".$directory->getSlug()."/content/canada",
1421.             ]
1422.             ]);
1423.         }
1424.     
1425.     /**
1426.      * @Route("/directory/{slug}/content/lunch-and-learn/{page}", name="directory_lunch_and_learn_content_master")
1427.      */
1428.     public function directoryLunchAndLearnContent(
1429.         Request $request,
1430.         ContentHelper $helper,
1431.         $slug = "",
1432.         $type = "8",
1433.         $page = 1
1434.         ) {
1435.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
1436.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
1437.             $customer = $directory->getDirectory();
1438.     
1439.             $length = 10; //10 per page
1440.             
1441.             $contents = $helper->getContent(
1442.             "*",
1443.                 "on-demand-lunch-learn",
1444.                 "published",
1445.                 "desc",
1446.                 ($page - 1),
1447.                 $length,
1448.                 true,
1449.                 "*",
1450.                 true, //secondary categories
1451.                 false,
1452.                 false,
1453.                 false,
1454.             $customer->getId()
1455.             );
1456.             $total = $contents["total"];
1457.             $posts = $contents["content"];
1458.     
1459.             $breadcrumbs = [
1460.             [
1461.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1462.                 "href" => "/our-directory/",
1463.             ],
1464.             [
1465.                 "title" => $directory->getTitle(),
1466.                 "href" => "/directory/{$directory->getSlug()}",
1467.             ],
1468.             [
1469.                 "title" => "Lunch and Learn Content",
1470.                 "href" => "/directory/{$directory->getSlug()}/lunch-and-learn",
1471.             ]
1472.             ];
1473.             return $this->defaultRender("content/post.html.twig", [
1474.             "customer" => $customer,
1475.             "posts" => $posts,
1476.             "total" => $total,
1477.             "length" => $length,
1478.             "page" => $page,
1479.             "meta" => [
1480.                 "title" => $directory->getTitle(),
1481.                         "breadcrumbs" => $breadcrumbs,
1482.                         "root" => "/directory/".$directory->getSlug()."/content/lunch-and-learn",
1483.             ]
1484.             ]);
1485.         }
1488.     /**
1489.      * @Route("/directory/{slug}/content/{type}/{page}", name="directory_content_master")
1490.      */
1491.     public function directoryContent(
1492.         Request $request,
1493.         ContentHelper $helper,
1494.         $slug = "",
1495.         $type = 2,
1496.         $page = 1
1497.     ) {
1498.         $directory = $helper->getDirectoryBySlug($slug);
1499.         //$customer = $directory->getCustomers()->first();
1500.         $customer = $directory->getDirectory();
1502.         $length = 10;
1503.         $posts = $helper->getPaginatedContentByType($type, $length, $page, "", $customer);
1504.         $total = $helper->countContentByCustomer($type, $customer);
1506.         $breadcrumbs = [
1507.             [
1508.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
1509.                 "href" => "/our-directory/",
1510.             ],
1511.             [
1512.                 "title" => $directory->getTitle(),
1513.                 "href" => "/directory/{$directory->getSlug()}",
1514.             ],
1515.             [
1516.                 "title" => Content::getTypeTextStatic($type),
1517.                 "href" => "/directory/{$directory->getSlug()}/content/".$type,
1518.             ]
1519.         ];
1520.         return $this->defaultRender("content/post.html.twig", [
1521.             "customer" => $customer,
1522.             "posts" => $posts,
1523.             "total" => $total,
1524.             "length" => $length,
1525.             "page" => $page,
1527.             "meta" => [
1528.                 "title" => $directory->getTitle(),
1529.                 "breadcrumbs" => $breadcrumbs,
1530.                 "root" => "/directory/".$directory->getSlug()."/content/".$type,
1531.             ]
1532.         ]);
1533.     }
1534.     
1535.     /**
1536.      * @Route(
1537.      *      "/directory/{slug}",
1538.      *      name="directory_lead_master",
1539.      *      methods={"POST"}
1540.      * )
1541.      */
1542.     public function directoryPostLead (
1543.         Request $request,
1544.         ContentHelper $helper,
1545.         EmailHelper $emailHelper,
1546.         ContentHelper $contentHelper,
1547.         $slug = ""
1548.     ) {
1549.         
1550.         if($emailHelper->checkCaptcha($request->get("g-recaptcha-response"))) {
1551.             
1552.             $firstname = $request->get("firstname");
1553.             $lastname = $request->get("lastname");
1554.             $email = $request->get("email");
1555.             $message = $request->get("comments");
1556.             
1557.             
1558.             if( $contentHelper->isSpam($message) ||  $contentHelper->isSpam($email) ) {
1559.                 //temporarily hiding this
1560.                 //$this->addFlash("danger", "Invalid characters used.");
1561.                 return new RedirectResponse($request->headers->get('referer'));
1562.             }
1563.             
1564.             // update lead items
1565.             $lead = new Lead();
1566.             $lead->setFirstname($firstname);
1567.             $lead->setLastname($lastname);
1568.             $lead->setEmail($email);
1569.             $lead->setComments($message);
1570.             
1571.             $lead->setIpAddress($request->getClientIp());
1572.             $lead->setRefUrl($request->headers->get("referer"));
1573.             $lead->setUserAgent($request->headers->get("User-Agent"));
1574.             $content = $contentHelper->getContentBySlugRaw($slug);
1575.             $lead->setContent($content);
1576.             
1577.             $em = $this->getDoctrine()->getManager();
1578.             $em->persist($lead);
1579.             $em->flush();
1580.             
1581.             
1582.             // send e-mail
1583.             
1584.             $directory = $helper->getDirectoryBySlug($slug);
1585.             $customers = $directory->getCustomers();
1586.             
1587.             //$recipients = array ("forms@intradatech.com");
1589.             foreach ($customers as $customer) {
1590.                 $recipients[] = $customer->getEmail();
1591.             }
1593.             //$recipients = implode(",", $recipients);
1595.             
1597.             $emailHelper->sendEmail(
1598.                 $recipients,
1599.                 "Contact Form Received",
1600.                 [
1601.                     ["p" => "Contact Form Received"],
1602.                     ["table" => [
1603.                         "First Name" => $firstname,
1604.                         "Last Name" => $lastname,
1605.                         "Email Address" => $email,
1606.                         "Message" => $message,
1607.                     ]],
1608.                 ]
1609.             );
1610.             $this->addFlash("success", "Thanks for contacting us! We will get in touch with you shortly.");
1611.             return new RedirectResponse($request->headers->get('referer'));
1612.         }
1613.         $this->addFlash("danger", "The reCAPTCHA was invalid. Please try again.");
1614.         return new RedirectResponse($request->headers->get('referer'));
1616.         // set invalid flag for javascript to show form again...
1618.     }
1619.     
1620.     /**
1621.      * @Route("/ebooks-by/{slug}", name="customerEbooks_master")
1622.     */
1623.     public function customerEBooks(
1624.         Request $request,
1625.         ContentHelper $contentHelper,
1626.         $slug
1627.     ){
1629.         $directory = $contentHelper->getDirectoryBySlug($slug);
1630.         $customer = $directory->getDirectory();
1633.         // $customer = $directory->getDirectory();
1634.         $eBooks = $contentHelper->getEbooks($customer->getId());
1637.         return $this->defaultRender("content/tmpl/ebooks-list.html.twig",[
1638.             "eBooks" => $eBooks,
1639.             "customer" => $customer,
1640.             "meta" => [
1641.                 "title" => $customer->getTitle(),
1642.                 "breadcrumbs" => [
1643.                     [
1644.                         "title" => "Partner eBooks",
1645.                         "href" => "/partner-ebooks",
1646.                     ],
1647.                     [
1648.                         "title" => $customer->getTitle(),
1649.                         "href" => "/ebooks-by/{$customer->getDirectoryContent()->getSlug()}",
1650.                     ],
1651.                 ],
1652.             ]
1653.         ]);
1654.     }
1655.     //--Directory End--
1656.     
1657.     
1658.     //--Events Start--
1659.     /**
1660.      * @Route("/events/month/{month}/{year}", name="events_month_master")
1661.      */
1662.     public function events_month(
1663.         Request $request,
1664.         ContentHelper $helper,
1665.         $slug = "",
1666.         $month = 0,
1667.         $year = 0
1668.     ) {
1669.         if(!$month){$month = date("n");}
1670.         if(!$year){$year = date("Y");}
1672.         $date = date("Y-m-d", strtotime("$year-$month-01"));
1673.         $p_month = date("Y-m-d", strtotime("-1 month", strtotime($date)));
1674.         $n_month = date("Y-m-d", strtotime("+1 month", strtotime($date)));
1676.         return $this->defaultRender("content/tmpl/event-month.html.twig", [
1677.             "meta" => [
1678.                 "title" => "Events",
1679.             ],
1680.             "events_by_day" => $helper->getEventsByMonth($month, $year),
1681.             "month" => $month,
1682.             "year" => $year,
1683.             "date" => $date,
1684.             "previous_month" => $p_month,
1685.             "next_month" => $n_month,
1686.         ]);
1687.     }
1689.     /**
1690.      * @Route("/events/day/{month}/{day}/{year}/{search}", name="events_day_master")
1691.      */
1692.     public function events_day(
1693.         Request $request,
1694.         ContentHelper $helper,
1695.         $slug = "",
1696.         $day = 0,
1697.         $month = 0,
1698.         $year = 0,
1699.         $search = ""
1700.     ) {
1701.         if(!$day){$day = date("j");}
1702.         if(!$month){$month = date("n");}
1703.         if(!$year){$year = date("Y");}
1705.         $date = date("Y-m-d", strtotime("$year-$month-$day"));
1706.         $p_day = date("Y-m-d", strtotime("-1 day", strtotime($date)));
1707.         $n_day = date("Y-m-d", strtotime("+1 day", strtotime($date)));
1709.         $events = $helper->getEventsByDay($date, $search);
1710.         $events_meta = array();
1712.         foreach($events as $event) {
1713.             $meta_collection = $event->getContentmeta();
1714.             $content_meta = array();
1715.             foreach($meta_collection as $meta) {
1716.                 $content_meta[$meta->getMetakey()] = $meta->getMetavalue();
1717.             }
1718.             $events_meta[$event->getId()] = $content_meta;
1719.         }
1721.         return $this->defaultRender("content/tmpl/event-day.html.twig", [
1722.             "meta" => [
1723.                 "title" => "Events",
1724.             ],
1725.             "events" => $events,
1726.             "date" => $date,
1727.             "previous_day" => $p_day,
1728.             "next_day" => $n_day,
1729.             "events_meta" => $events_meta,
1730.             "search" => $search,
1731.         ]);
1732.     }
1735.     /**
1736.      * @Route("/events/{page}/{search}", name="events_master")
1737.      */
1738.     public function events(
1739.         Request $request,
1740.         ContentHelper $helper,
1741.         $slug = "",
1742.         $page = 1,
1743.         $search = ""
1744.     ) {
1745.         $limit = ContentHelper::DEFAULT_LIMIT;
1747.         if($request->request->has("eventSearch")) {
1748.             $search = $request->request->get("eventSearch");
1749.         }
1750.         if($request->request->has("eventDate")) {
1751.             $date = $request->request->get("eventDate");
1752.             if(strtotime($date)) {
1753.                 $date = date("m/d/Y", strtotime($date));
1754.                 return $this->redirectToRoute("events_day_master", [
1755.                     "day" => date("d", strtotime($date)),
1756.                     "month" => date("m", strtotime($date)),
1757.                     "year" => date("Y", strtotime($date)),
1758.                     "search" => $search
1759.                 ]);
1760.             }
1761.             else {
1762.                 $date = "";
1763.             }
1764.         }
1766.         if($search) {
1767.             $events = $helper->getPaginatedContentByType(Content::EVENT, $limit, $page, $search);
1768.         }
1769.         else {
1770.             $events = $helper->getPaginatedContentByType(Content::EVENT, $limit, $page);
1771.         }
1773.         if($page == 0) {$page = 1;}
1775.         if($page == 1) {
1776.             $p_page = -1;
1777.         }
1778.         else {
1779.             $p_page = $page - 1;
1780.         }
1782.         if($page == -1) {
1783.             $n_page = 1;
1784.         }
1785.         else {
1786.             $n_page = $page + 1;
1787.         }
1789.         if($page < 0 && abs($p_page) > ceil($helper->countPreviousEvents($search) / $limit)) {
1790.             $p_page = 0;
1791.         }
1793.         if($page > 0 && $n_page > ceil($helper->countUpcomingEvents($search) / $limit)) {
1794.             $n_page = 0;
1795.         }
1797.         $events_meta = array();
1799.         foreach($events as $event) {
1800.             $meta_collection = $event->getContentmeta();
1801.             $content_meta = array();
1802.             foreach($meta_collection as $meta) {
1803.                 $content_meta[$meta->getMetakey()] = $meta->getMetavalue();
1804.             }
1805.             $events_meta[$event->getId()] = $content_meta;
1806.         }
1808.         return $this->defaultRender("content/tmpl/event-list.html.twig", [
1809.             "meta" => [
1810.                 "title" => "Events",
1811.             ],
1812.             "events" => $events,
1813.             "pagenum" => $page,
1814.             "previous_pagenum" => $p_page,
1815.             "next_pagenum" => $n_page,
1816.             "events_meta" => $events_meta,
1817.             "search" => $search,
1818.         ]);
1819.     }
1821.     /**
1822.      * @Route("/event/{slug}", name="event_master")
1823.      */
1824.     public function event(
1825.         Request $request,
1826.         ContentHelper $helper,
1827.         $slug = ""
1828.     ) {
1829.         $event = $helper->getEventBySlug($slug);
1830.         $meta_collection = $event->getContentmeta();
1831.         $content_meta = array();
1833.         foreach($meta_collection as $meta) {
1834.             $content_meta[$meta->getMetakey()] = $meta->getMetavalue();
1835.         }
1837.         return $this->defaultRender("content/tmpl/event-single.html.twig", [
1838.             "meta" => [
1839.                 "title" => $event->getTitle(),
1840.             ],
1841.             "content" => $event,
1842.             "content_meta" => $content_meta,
1843.             "previous_event" => $helper->getPreviousEvent($event),
1844.             "next_event" => $helper->getNextEvent($event),
1845.         ]);
1846.     }
1848.     /**
1849.      * @Route("/download-ics", name="download_ics_file")
1850.     **/
1851.     public function downloadICSFileAction(
1852.         Request $request,
1853.         ContentHelper $helper
1854.     ){
1855.         //if ($request->request->has("date_start")) {
1856.             $ics_file = $helper->make_ics_file($request->request->get("location"), $request->request->get("description"), $request->request->get("dtstart"),
1857.             $request->request->get("dtend"), $request->request->get("summary"), $request->request->get("url"));
1858.         //}
1860.         $filename = 'rooferscoffeshop-event.ics';
1861.         $response  = new Response($ics_file);
1862.          $disposition = $response->headers->makeDisposition(
1863.             ResponseHeaderBag::DISPOSITION_ATTACHMENT,
1864.             $filename
1865.         );
1866.         $response->headers->set('Content-Disposition', $disposition);
1867.         return $response;
1868.     }
1869.     //--Events End
1870.     
1871.     
1872.     //--Forums Start--
1873.     
1874.     /**
1875.      * @Route("/forum", name="forums_master")
1876.      */
1877.     public function forums(
1878.         Request $request,
1879.         ContentHelper $contentHelper,
1880.         $slug = ""
1881.     ) {
1882.         $forums = array();
1883.         foreach($contentHelper->getContentByType(Content::FORUM) as $forum) {
1884.             $counts = $contentHelper->countTopicsPostsByForum($forum->getSlug());
1885.             $topics = $contentHelper->getTopicsByForum($forum, 1, 1);
1886.             $topic = "";
1887.             foreach($topics as $t) {
1888.                 $topic = $t;
1889.             }
1890.             $featured = $forum->getFeatured();
1891.             $forums[] = [
1892.                 "forum" => $forum,
1893.                 "num_topics" => $counts["num_topics"],
1894.                 "num_posts" => $counts["num_posts"],
1895.                 "recent_topic" => $topic,
1896.                 "featured" => $featured,
1897.             ];
1898.         }
1899.         $num_topics = array();
1900.         foreach($forums as $key => $row) {
1901.             $num_topics[$key] = $row["num_topics"] + ($row["featured"] * 100000);
1902.         }
1903.         array_multisort($num_topics, SORT_DESC, $forums);
1904.         
1905.         return $this->defaultRender("content/forums-page.html.twig", [
1906.             "meta" => [
1907.                 "title" => "Forums Archive",
1908.                 "breadcrumbs" => [
1909.                     [
1910.                         "title" => "Our Forums",
1911.                         "href" => "/forum",
1912.                     ]
1913.                 ]
1914.             ],
1915.             "forums" => $forums,
1916.         ]);
1917.     }
1918.     
1919.     /**
1920.      * @Route("/forum/topic/{slug}/edit", name="forum_topic_edit_master")
1921.      */
1922.      public function forumTopicEdit(
1923.         Request $request,
1924.         ContentHelper $helper,
1925.         $slug = ""
1926.      ) {
1927.         $topic = $helper->getTopicBySlug($slug);
1929.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
1930.             $user = $this->getUser();
1931.             if($user) {
1932.                 //$unrestricted = $user->getUserMetaValueByKey("rich_editing");
1933.                 if($this->user->isAdmin()) {
1934.                     //fully edit topic
1935.                     if ($request->request->has("content")) {
1936.                         $topic->setTitle($request->request->get("title"));
1937.                         $topic->setContentFull($request->request->get("content"));
1938.                         $topic->setPrnt($helper->getContentById($request->request->get("forum")));
1939.                         $topic->setStatus($request->request->get("status"));
1941.                         $em = $this->getDoctrine()->getManager();
1942.                         $em->persist($topic);
1943.                         $em->flush();
1945.                         $this->addFlash("success", "Topic has been updated.");
1946.                         return $this->redirectToRoute("forum_topic_master", ["slug" => $topic->getSlug(), "page" => "1"]);
1947.                     }
1949.                     return $this->defaultRender("content/tmpl/forum-topic-edit.html.twig", [
1950.                         "content" => $topic,
1951.                         //"unrestricted" => isset($unrestricted) ? $unrestricted : "",
1952.                         "unrestricted" => true,
1953.                         "forums" => $helper->getContentByType(Content::FORUM),
1954.                         "admin" => true,
1955.                     ]);
1956.                 }
1957.                 elseif($topic->getAuthor() == $user) {
1958.                     //just allow them to edit the content and title
1959.                     if ($request->request->has("content")) {
1960.                         $topic->setTitle($request->request->get("title"));
1961.                         $topic->setContentFull($request->request->get("content"));
1963.                         $em = $this->getDoctrine()->getManager();
1964.                         $em->persist($topic);
1965.                         $em->flush();
1967.                         $this->addFlash("success", "Topic has been updated.");
1968.                         return $this->redirectToRoute("forum_topic_master", ["slug" => $topic->getSlug(), "page" => "1"]);
1969.                     }
1971.                     return $this->defaultRender("content/tmpl/forum-topic-edit.html.twig", [
1972.                         "content" => $topic,
1973.                         //"unrestricted" => isset($unrestricted) ? $unrestricted : "",
1974.                         "unrestricted" => true,
1975.                         "admin" => false,
1976.                     ]);
1977.                 }
1978.             }
1979.         }
1981.         return $this->redirectToRoute("forum_topic_master", ["slug" => $topic->getSlug(), "page" => "1"]);
1982.      }
1983.      
1984.      /**
1985.      * @Route("/forum/topic/{slug}/delete", name="forum_topic_delete_master")
1986.      */
1987.      public function forumTopicDelete(
1988.         Request $request,
1989.         ContentHelper $helper,
1990.         $slug = ""
1991.      ) {
1992.         $topic = $helper->getTopicBySlug($slug);
1994.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
1995.             $user = $this->getUser();
1996.             if($user) {
1997.                 if($this->user->isAdmin()) {
1998.                     $topic->setStatus(Content::STATUS_INACTIVE);
1999.                     $em = $this->getDoctrine()->getManager();
2000.                     $em->persist($topic);
2001.                     $em->flush();
2003.                     foreach($topic->getChildren() as $child) {
2004.                         $child->setStatus(Content::STATUS_INACTIVE);
2005.                         $em->persist($child);
2006.                         $em->flush();
2007.                     }
2009.                     $this->addFlash("success", "Topic has been deleted.");
2010.                     return $this->redirectToRoute("forum_master", ["slug" => $topic->getPrnt()->getSlug(), "page" => "1"]);
2011.                 }
2012.             }
2013.         }
2014.      }
2016.      /**
2017.      * @Route("/forum/topic/{slug}/unsubscribe/{userid}", name="forum_topic_unsubscribe_master")
2018.      */
2019.      public function forumTopicUnsubscribe(
2020.         Request $request,
2021.         ContentHelper $helper,
2022.         UserHelper $userhelper,
2023.         $slug = "",
2024.         $userid = ""
2025.      ) {
2026.         $topic = $helper->getTopicBySlug($slug);
2027.         $user = $userhelper->getUserById($userid);
2028.         $entityManager = $this->getDoctrine()->getManager();
2030.         if($topic->getAuthor() == $user) {
2031.             $topic->setContentmetum("_notify_of_replies", "0");
2032.             $entityManager->persist($topic);
2033.             $entityManager->flush();
2034.         }
2036.         foreach($topic->getActiveChildren() as $reply) {
2037.             if($reply->getAuthor() == $user) {
2038.                 $reply->setContentmetum("_notify_of_replies", "0");
2039.                 $entityManager->persist($reply);
2040.                 $entityManager->flush();
2041.             }
2042.         }
2044.         $this->addFlash("success", "You will no longer receive email notifications about the \"{$topic->getTitle()}\" forum topic.");
2045.         return $this->redirectToRoute("forum_master", ["slug" => $topic->getPrnt()->getSlug(), "page" => "1"]);
2046.      }
2048.      /**
2049.      * @Route("/forum/topic/{slug}/spam", name="forum_topic_spam_master")
2050.      */
2051.      public function forumTopicSpam(
2052.         Request $request,
2053.         ContentHelper $helper,
2054.         $slug = ""
2055.      ) {
2056.         $topic = $helper->getTopicBySlug($slug);
2058.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2059.             $user = $this->getUser();
2060.             if($user) {
2061.                 if($this->user->isAdmin()) {
2062.                     $forumUser = $topic->getAuthor();
2063.                     if($forumUser) {
2064.                         $forumUser->markAsSpam();
2066.                         $em = $this->getDoctrine()->getManager();
2067.                         $em->persist($forumUser);
2068.                         $em->flush();
2070.                         /* //Should we do this?
2071.                         foreach($topic->getChildren() as $child) {
2072.                             $child->setStatus(Content::STATUS_INACTIVE);
2073.                             $em->persist($child);
2074.                             $em->flush();
2075.                         }
2076.                         */
2077.                         $this->addFlash("success", "User has been marked as spam.");
2078.                     }
2079.                     else {
2080.                         $this->addFlash("warning", "There was a problem marking this user as spam.");
2081.                     }
2083.                     return $this->redirectToRoute("forum_master", ["slug" => $topic->getPrnt()->getSlug(), "page" => "1"]);
2084.                 }
2085.             }
2086.         }
2087.      }
2089.     /**
2090.      * @Route("/forum/topic/{slug}/{page}", name="forum_topic_master")
2091.      */
2092.     public function forumTopic(
2093.         Request $request,
2094.         ContentHelper $helper,
2095.         EmailHelper $emailHelper,
2096.         $slug = "",
2097.         $page = 1
2098.     ) {
2099.         $topic = $helper->getTopicBySlug($slug);
2100.         $limit = ContentHelper::FORUM_LIMIT;
2101.         $forum = $topic->getPrnt();
2103.         //Members only check
2104.         /*if($forum && $forum->getMembersOnly() && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
2105.             $this->addFlash("warning", "This forum is only accessible to RCS Club members. Continue below to become a member and access this forum.");
2106.             return $this->redirectToRoute("rcs-club-sign-up");
2107.         }*/
2109.         if($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2110.             
2111.             //if ($form->isSubmitted() && $form->isValid()) {
2112.             if ($request->request->has("reply-content")) {
2114.                 $content = new Content();
2115.                 
2116.                 $entityManager = $this->getDoctrine()->getManager();
2117.                 $site = $entityManager //TODO: test, add to default controller?
2118.                     ->getRepository(Site::class)
2119.                     ->findOneBy([
2120.                         "id" => $this->site_code
2121.                     ]);
2122.                 $content->addSite($site);
2123.                 
2124.                 $content->setType(Content::FORUM_REPLY);
2125.                 $content->setPrnt($topic);
2126.                 $content->setPermission(1);
2128.                 $user = $this->getUser();
2129.                 if($user) {
2130.                     $content->setAuthor($user);
2131.                 }
2132.                 
2133.                 if($emailHelper->checkInvisibleCaptcha($request->get("g-recaptcha-response"))) {
2134.                     $notify = new ContentMeta();
2135.                     $notify->setMetakey("_notify_of_replies");
2136.                     $request->request->has("notify") ? $notify->setMetavalue(1) : $notify->setMetavalue(0);
2137.                     $content->addContentmetum($notify);
2138.                     $content_full = $request->request->get("reply-content");
2139.                     if(!$this->user->isAdmin()) {
2140.                         $content_full = preg_replace('/<a[^>]+>([^<]+)<\/a>/i','\1',$content_full);
2141.                     }
2142.                     $content->setContentFull($content_full);
2144.                     if($helper->isSpam($request->request->get("reply-content"))) {
2145.                         $content->setStatus(Content::STATUS_IN_REVIEW);
2146.                     }
2147.                     else {
2148.                         $content->setStatus(Content::STATUS_ACTIVE);
2149.                     }
2151.                     $entityManager = $this->getDoctrine()->getManager();
2152.                     $entityManager->persist($content);
2153.                     $entityManager->flush();
2155.                     $this->addFlash("success", "Your reply has been added.");
2156.                     
2157.                     if($topic->getContentMetaValueByKey("_notify_of_replies")) {
2158.                         //forum_email
2159.                         $pooled = $emailHelper->sendEmail($topic->getAuthor()->getEmail(), "New Reply to one of your Forum Topics", [
2160.                             ["p" => "Hello {$topic->getAuthor()},"],
2161.                             ["p" => "{$content->getAuthor()} has replied to your forum topic <a href=\"{$topic->getFullURL($this->site_code)}\">\"{$topic->getTitle()}\"</a> with the following reply:"],
2162.                             ["p" => "{$content->getContentFull()}"],
2163.                             //["a" => ["href" => "dev.askaroofer.com/forum/topic/{$topic->getSlug()}/unsubscribe/{$topic->getAuthor()->getId()}", "text" => "Click Here to stop receiving these notifications"]],
2164.                             ["a" => ["href" => "{$topic->getFullURL($this->site_code)}/unsubscribe/{$topic->getAuthor()->getId()}", "text" => "Click Here to stop receiving these notifications"]],
2165.                         ], [], "", "lauren@rooferscoffeeshop.com");
2166.                     }
2168.                     $notify_users = array();
2170.                     foreach($topic->getActiveChildren() as $reply) {
2171.                         if($reply != $content) {
2172.                             if($reply->getContentMetaValueByKey("_notify_of_replies") && !in_array($reply->getAuthor(), $notify_users)
2173.                                 && $reply->getAuthor() != $topic->getAuthor() && $reply->getAuthor() != $content->getAuthor()) {
2174.                                 $notify_users[] = $reply->getAuthor();
2175.                             }
2176.                         }
2177.                     }
2179.                     foreach($notify_users as $notify_user) {
2180.                         //forum_email
2181.                         $pooled = $emailHelper->sendEmail($notify_user->getEmail(), "New Reply to one of your Forum Topics", [
2182.                             ["p" => "Hello {$notify_user},"],
2183.                             ["p" => "{$content->getAuthor()} has replied to the forum topic <a href=\"{$topic->getFullURL($this->site_code)}\">\"{$topic->getTitle()}\"</a> with the following reply:"],
2184.                             ["p" => "{$content->getContentFull()}"],
2185.                             //["a" => ["href" => "dev.askaroofer.com/forum/topic/{$topic->getSlug()}/unsubscribe/{$notify_user->getId()}", "text" => "Click Here to stop receiving these notifications"]],
2186.                             ["a" => ["href" => "{$topic->getFullURL($this->site_code)}/unsubscribe/{$notify_user->getId()}", "text" => "Click Here to stop receiving these notifications"]],
2187.                         ], [], "", "lauren@rooferscoffeeshop.com");
2188.                     }
2190.                     $session = $request->getSession();
2191.                     $route = $session->get("this_route");
2193.                     // return $this->redirectToRoute('task_success');
2194.                     return $this->redirect($route["path"]);
2195.                 }
2196.                 else {
2197.                     //failed the recaptcha check
2198.                     $session = $request->getSession();
2199.                     $route = $session->get("this_route");
2200.                     return $this->redirect($route["path"]);
2201.                 }
2202.             }
2203.         }
2205.         $count = $helper->countActiveChildren($topic);
2207.         return $this->defaultRender("content/content.html.twig", [
2208.             "meta" => [
2209.                 "title" => $topic->getTitle(),
2210.                 "breadcrumbs" => [
2211.                     [
2212.                         "title" => "Our Forums",
2213.                         "href" => "/forum",
2214.                     ],
2215.                     [
2216.                         "title" => $forum->getTitle(),
2217.                         "href" => "/forum/{$forum->getSlug()}",
2218.                     ],
2219.                     [
2220.                         "title" => $topic->getTitle(),
2221.                         "href" => "/forum/topic/{$topic->getSlug()}",
2222.                     ],
2223.                 ],
2224.             ],
2225.             "content" => $topic,
2226.             "replies" => $helper->getPaginatedChildren($topic, $limit, $page, true),
2227.             "limit" => $limit,
2228.             "pagenum" => $page,
2229.             "totalcount" => $count,
2230.             "totalpages" => ceil($count / $limit),
2231.             "baseurl" => $this->generateUrl('forum_topic_master', ['slug' => $slug]),
2232.             //"form" => $form->createView(),
2233.             //"unrestricted" => isset($unrestricted) ? $unrestricted : "",
2234.             //let everyone be unrestricted (Vickie wants everyone to be able to post images for now)
2235.             "unrestricted" => true,
2236.         ]);
2237.     }
2239.     /**
2240.      * @Route("/forum/reply/{id}/{action}", name="forum_reply_master")
2241.      */
2242.     public function forumReply(
2243.         Request $request,
2244.         ContentHelper $helper,
2245.         $id = "",
2246.         $action = ""
2247.     ) {
2248.         $reply = $helper->getContentById($id);
2250.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2251.             $user = $this->getUser();
2252.             if($user) {
2253.                 if($reply->getAuthor() == $user || $this->user->isAdmin()) {
2254.                     //access granted
2255.                     //$unrestricted = $user->getUserMetaValueByKey("rich_editing");
2257.                     if($action == "edit") {
2259.                         if ($request->request->has("reply-content")) {
2260.                             $content_full = $request->request->get("reply-content");
2261.                             if(!$this->user->isAdmin()) {
2262.                                 $content_full = preg_replace('/<a[^>]+>([^<]+)<\/a>/i','\1',$content_full);
2263.                             }
2264.                             $reply->setContentFull($content_full);
2266.                             $em = $this->getDoctrine()->getManager();
2267.                             $em->persist($reply);
2268.                             $em->flush();
2270.                             $this->addFlash("success", "Reply has been updated.");
2271.                             return $this->redirectToRoute("forum_topic_master", ["slug" => $reply->getPrnt()->getSlug(), "page" => "1"]);
2272.                         }
2274.                         return $this->defaultRender("content/tmpl/forum-reply-edit.html.twig", [
2275.                             "content" => $reply,
2276.                             //"unrestricted" => isset($unrestricted) ? $unrestricted : "",
2277.                             "unrestricted" => true,
2278.                         ]);
2279.                     }
2280.                     elseif ($action == "delete"){
2281.                         $reply->setStatus(Content::STATUS_INACTIVE);
2283.                         $em = $this->getDoctrine()->getManager();
2284.                         $em->persist($reply);
2285.                         $em->flush();
2287.                         $this->addFlash("success", "Reply has been deleted.");
2288.                         return $this->redirectToRoute("forum_topic_master", ["slug" => $reply->getPrnt()->getSlug(), "page" => "1"]);
2289.                     }
2290.                     elseif ($action == "spam"){
2291.                         $user = $reply->getAuthor();
2292.                         if($user) {
2293.                             $user->markAsSpam();
2294.                             $em = $this->getDoctrine()->getManager();
2295.                             $em->persist($user);
2296.                             $em->flush();
2298.                             $this->addFlash("success", "User has been marked as spam.");
2299.                         }
2300.                         else {
2301.                             $this->addFlash("warning", "There was a problem marking this user as spam.");
2302.                         }
2304.                         return $this->redirectToRoute("forum_topic_master", ["slug" => $reply->getPrnt()->getSlug(), "page" => "1"]);
2305.                     }
2306.                 }
2307.             }
2308.         }
2310.         // no action was taken, return to the single reply view
2311.          return $this->defaultRender("content/tmpl/forum-reply-single.html.twig", [ // or content/content
2312.             "content" => $reply,
2313.         ]);
2315.     }
2317.     /**
2318.      * @Route(
2319.      *        "/forum/search/{search}/{page}",
2320.      *      defaults={"search"="", "page"=1},
2321.      *        name="forum_search_master",
2322.      *      methods={"GET"}
2323.      * )
2324.      */
2325.     public function forumSearch(
2326.         Request $request,
2327.         ContentHelper $helper,
2328.         $search = "",
2329.         $page = 1
2330.     ) {
2331.         $limit = ContentHelper::FORUM_LIMIT;
2333.         return $this->defaultRender("content/forum-search.html.twig", [
2334.             "meta" => [
2335.                 "title" => "Forum Search Results",
2336.             ],
2337.             "results" => $helper->getForumSearchResults($search, $limit, $page),
2338.             "search" => $search,
2339.             "limit" => $limit,
2340.             "pagenum" => $page,
2341.             "totalcount" => $helper->countForumSearchResults($search),
2342.             "totalpages" => ceil($helper->countForumSearchResults($search) / $limit),
2343.             "baseurl" => $this->generateUrl('forum_search_master', ['search' => $search]),
2344.         ]);
2345.     }
2347.     /**
2348.      * @Route("/forum/{slug}/{page}", name="forum_master")
2349.      */
2350.     public function forum(
2351.         Request $request,
2352.         ContentHelper $helper,
2353.         UserHelper $userhelper,
2354.         EmailHelper $emailHelper,
2355.         $slug = "",
2356.         $page = 1
2357.     ) {
2358.         $forum = $helper->getForumBySlug($slug);
2359.         $limit = ContentHelper::FORUM_LIMIT;
2361.         //Members only check
2362.         /*if($forum->getMembersOnly() && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
2363.             $this->addFlash("warning", "This forum is only accessible to RCS Club members. Continue below to become a member and access this forum.");
2364.             return $this->redirectToRoute("rcs-club-sign-up");
2365.         }*/
2367.         //if ($form->isSubmitted() && $form->isValid()) {
2368.         if ($request->request->has("content") && $request->request->has("title")) {
2370.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2371.                 $content = new Content();
2372.                 
2373.                 $entityManager = $this->getDoctrine()->getManager();
2374.                 $site = $entityManager
2375.                     ->getRepository(Site::class)
2376.                     ->findOneBy([
2377.                         "id" => $this->site_code
2378.                     ]);
2379.                 $content->addSite($site);
2380.                 
2381.                 $content->setType(Content::FORUM_TOPIC);
2382.                 $content->setPrnt($forum);
2383.                 $content->setPermission(1);
2385.                 $user = $this->getUser();
2386.                 if($user) {
2387.                     $content->setAuthor($user);
2388.                     //$unrestricted = $user->getUserMetaValueByKey("rich_editing");
2389.                 }
2391.                 if($emailHelper->checkInvisibleCaptcha($request->get("g-recaptcha-response"))) {
2392.                     $notify = new ContentMeta();
2393.                     $notify->setMetakey("_notify_of_replies");
2394.                     $request->request->has("notify") ? $notify->setMetavalue(1) : $notify->setMetavalue(0);
2395.                     $content->addContentmetum($notify);
2396.                     $content->setTitle($request->request->get("title"));
2397.                     $content->setContentFull($request->request->get("content"));
2398.                     $content->setSlug($helper->getUniqueSlug($content->getTitle(), "", $this->site_code));
2400.                     if($helper->isSpam($request->request->get("title")) || $helper->isSpam($request->request->get("content"))) {
2401.                         //Just preventing posting entirely for now instead of marking as in review since there is so much Korean spam.
2402.                         //$content->setStatus(Content::STATUS_IN_REVIEW);
2403.                         //$this->addFlash("warning", "Your new topic has triggered our automatic spam filter. If you believe this is an error, please contact a site administrator.");
2404.                         $session = $request->getSession();
2405.                         $route = $session->get("this_route");
2406.                         return $this->redirect($route["path"]);
2407.                     }
2408.                     else {
2409.                         //Not spam
2410.                         $content->setStatus(Content::STATUS_ACTIVE);
2412.                         $entityManager = $this->getDoctrine()->getManager();
2413.                         $entityManager->persist($content);
2414.                         $entityManager->flush();
2416.                         $this->addFlash("success", "Your new topic \"{$content->getTitle()}\" has been added.");
2418.                         //If it's a members only topic, notify members who are set to receive notifications
2419.                         /*
2420.                         if($forum->getMembersOnly()) {
2421.                             $notify_users = $userhelper->getMembersToNotify("member_notification_forum");
2423.                             if($notify_users) {
2424.                                 foreach($notify_users as $notify_user) {
2425.                                     //forum_email
2426.                                     $pooled = $emailHelper->sendEmail($notify_user->getEmail(), "New Members Only Forum Topic", [
2427.                                         ["p" => "Hello {$notify_user},"],
2428.                                         ["p" => "{$content->getAuthor()} has posted a new topic to the R-Club forum: \"<a href='{$content->getFullURL()}'>{$content->getTitle()}</a>\"."],
2429.                                         ["p" => "{$content->getContentFull()}"],
2430.                                         ["a" => ["href" => "askaroofer.com/account", "text" => "Update your membership notification setting here to stop receiving these notifications"]],
2431.                                     ]);
2432.                                 }
2433.                             }
2434.                         }
2435.                         */
2437.                         //forum_email
2438.                         $pooled = $emailHelper->sendEmail(SiteConfig::CONFIGS[$this->site_code]["email_group"], "New Forum Topic", [
2439.                             //["p" => "Hello {$notify_user},"],
2440.                             ["p" => "{$content->getAuthor()} has posted a new topic to the forum: \"<a href='{$content->getFullURL($this->site_code)}'>{$content->getTitle()}</a>\"."],
2441.                             ["p" => "{$content->getContentFull()}"],
2442.                         ]);
2443.                             
2444.                     }
2446.                 }
2447.                 else {
2448.                     //failed the recaptcha check
2449.                     $session = $request->getSession();
2450.                     $route = $session->get("this_route");
2451.                     return $this->redirect($route["path"]);
2452.                 }
2453.             }
2455.         }
2456.         $count = $helper->countActiveChildren($forum);
2458.         return $this->defaultRender("content/content.html.twig", [
2459.             "meta" => [
2460.                 "title" => $forum->getTitle(),
2461.                 "breadcrumbs" => [
2462.                     [
2463.                         "title" => "Our Forums",
2464.                         "href" => "/forum",
2465.                     ],
2466.                     [
2467.                         "title" => $forum->getTitle(),
2468.                         "href" => "/forum/{$forum->getSlug()}",
2469.                     ],
2470.                 ],
2471.             ],
2472.             "content" => $forum,
2473.             //"topics" => $helper->getPaginatedChildren($forum, $limit, $page),
2474.             "topics" => $helper->getTopicsByForum($forum, $limit, $page),
2475.             "limit" => $limit,
2476.             "pagenum" => $page,
2477.             "totalcount" => $count,
2478.             "totalpages" => ceil($count / $limit),
2479.             "baseurl" => $this->generateUrl('forum_master', ['slug' => $slug]),
2480.             //"form" => $form->createView(),
2481.             //"unrestricted" => isset($unrestricted) ? $unrestricted : "", //if the user can post unrestricted HTML content
2482.             "unrestricted" => true,
2483.         ]);
2484.     }
2485.     
2486.     /* End Forums */
2487.     
2488.     
2489.     
2490.     /**
2491.      * @route("/rlw/{slug}",
2492.      *     name="rlw-posts_master",
2493.      *     defaults={"slug": ""}
2494.      * )
2495.      *
2496.      */
2497.     public function showRLWPage (
2498.        Request $request,
2499.        ContentHelper $contentHelper,
2500.        $slug = ""
2501.     ) {
2502.         
2503.         try {
2504.             if (!$slug || is_numeric($slug)) {
2505.                 // show all rlw content...
2506.                 
2507.                 $page = 1;
2508.                 $limit = 10;
2509.                 
2510.                 if (is_numeric($slug)) {
2511.                     $page = $slug;
2512.                 }
2513.                 
2514.                 $data = $contentHelper->getContent(
2515.                    Content::THE_HUB,
2516.                    "*",
2517.                    "created",
2518.                    "desc",
2519.                    $page - 1,
2520.                    $limit
2521.                 );
2522.                 
2523.                 $category = [
2524.                     "title" => "Read Listen Watch - All Learning Resources<span id=\"spacer\"></span>",
2525.                     "href" => "/rlw",
2526.                 ];
2527.                 
2528.                 return $this->defaultRender("content/post.html.twig", array (
2529.                    "posts" => $data["content"],
2530.                    "total" => $data["total"],
2531.                    "length" => $limit,
2532.                    "page" => $page,
2533.                    "category" => $category,
2534.                    "meta" => array (
2535.                        "root" => "/rlw",
2536.                        "breadcrumbs" => [
2537.                            [
2538.                                "title" => "Learn Your Way",
2539.                                "href" => "/read-listen-watch",
2540.                            ],
2541.                            [
2542.                                "title" => "Read Listen Watch - All Learning Resources",
2543.                                "href" => "/rlw",
2544.                            ]
2545.                        ]
2546.                    )
2547.                 ));
2548.             }
2549.             
2550.             else {
2551.                 $content = $contentHelper->getContentBySlug(Content::THE_HUB, $slug);
2552.                 return $this->defaultRender("content/page.html.twig", [
2553.                    "content" => $content,
2554.                    
2555.                    "meta" => [
2556.                         "title" => $content->getTitle(),
2557.                         "breadcrumbs" => [
2558.                             [
2559.                                 "title" => "Learn Your Way",
2560.                                 "href" => "/read-listen-watch",
2561.                             ],
2562.                             [
2563.                                 "title" => $content->getTitle(),
2564.                                 "href" => $content->getURL(),
2565.                             ]
2566.                         ]
2567.                     ],
2568.                 ]);
2569.             }
2570.         }
2571.         
2572.         catch (Exception $e) {
2573.             throw $e;
2574.         }
2575.     }
2577.     /**
2578.      * @Route("/thank-you/{slug}", name="thank-you-landing-page_master")
2579.      *
2580.      */
2581.     public function showThankYouPage (
2582.         ContentHelper $contentHelper,
2583.         Request $request,
2584.         $slug
2585.     ) {
2586.         //Thank you landing page
2587.         try {
2588.             $page = $contentHelper->getThankYouPageBySlug($slug);
2589.             return $this->defaultRender("content/thank-you-landing-page.html.twig", [
2590.                 "page" => $page,
2591.                 "meta" => [
2592.                     "title" => $page->getTitle(),
2593.                 ],
2594.             ]);
2595.         }
2597.         catch (ResourceNotFoundException $e) {
2599.         }
2601.         return $this->defaultRender("errors/404.html.twig", [
2603.         ]);
2604.     }
2605.     
2606.     // requires a content object to be passed as $content
2607.     public function comment(
2608.         Request $request,
2609.         ContentHelper $helper,
2610.         EmailHelper $emailHelper,
2611.         RequestStack $requestStack,
2612.         $content = ""
2613.     ) {
2614.         //$limit = ContentHelper::DEFAULT_LIMIT;
2615.         
2616.         //The below code for handling comment submissions stopped working in Symfony 6
2617.         //Comment submissions are now handled by the submitCommentAjaxAction function.
2619.         /*
2620.         //Because this is used as an embedded controller, it receives a sub-request instead of the master request (that has the form submission data).
2621.         //This line will set the request to the master request to allow it to be processed.
2622.         $request = $requestStack->getCurrentRequest();
2624.         $comment = new Comment();
2625.         $comment->setContent($content);
2626.         
2627.         if ($request->request->has("comment-text")) {
2628.             
2629.             $comment->setApproved(0);
2630.             $comment->setAuthorIP($_SERVER['REMOTE_ADDR']);
2631.             $comment->setAgent($_SERVER['HTTP_USER_AGENT']);
2632.             $comment->setCommentText($request->request->get("comment-text"));
2633.             
2634.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2635.                 $user = $this->getUser();
2637.                 if($user->getRole() == 8) {
2638.                     $comment->setApproved(1);
2639.                 }
2641.                 $comment->setUser($user);
2642.                 $comment->setAuthor($user->getDisplayname());
2643.                 $comment->setAuthorEmail($user->getEmail());
2644.                 $comment->setApproved(1); //Change 3/25/21 to auto-approve per Heidi
2645.             }
2646.             else {
2647.                 $comment->setAuthor($request->request->get("author"));
2648.                 $comment->setAuthorEmail($request->request->get("email"));
2649.                 $comment->setAuthorUrl($request->request->get("url"));
2650.             }
2651.             
2652.             $entityManager = $this->getDoctrine()->getManager();
2653.             $entityManager->persist($comment);
2654.             $entityManager->flush();
2655.             
2656.             $contentType = strtolower($content->getTypeText());
2657.             
2658.             $emailHelper->sendEmail(
2659.                 ["rcs@rooferscoffeeshop.com"],
2660.                 "New Comment Added - {$content->getTitle()}",
2661.                 [
2662.                     ["p" => "A new comment has been added to the {$contentType} \"{$content->getTitle()}\"."],
2663.                     ["p" => "User \"{$comment->getAuthor()}\" commented: \"{$comment->getCommentText()}\"."],
2664.                     ["button" => [
2665.                         "text" => "View Content",
2666.                         "href" => "{$content->getFullURL($this->site_code)}",
2667.                     ]],
2668.                 ]
2669.             );
2670.             
2671.         }
2672.         */
2674.         return $this->defaultRender("forms/comment.html.twig", [
2675.             "comments" => $helper->getComments($content),
2676.             "content" => $content
2677.         ]);
2679.     }
2680.     
2681.     /**
2682.      * @Route("/search/{page}",
2683.      *     name="search_master",
2684.      *     defaults={"page": 1}
2685.      * )
2686.      */
2687.     public function search (
2688.        Request $request,
2689.        ContentHelper $contentHelper,
2690.        $page = 1
2691.     ) {
2692.         $search = $request->get("s");
2693.         $data = $contentHelper->search($search, $page);
2694.         
2695.         return $this->defaultRender("content/search.html.twig", [
2696.            "total" => $data["count"],
2697.            "limit" => 15,
2698.            "results" => $data["content"],
2699.            "page" => $page,
2700.            "search" => $search,
2701.            "meta" => [
2702.                "title" => "Search Results for {$search}",
2703.            ]
2704.         ]);
2705.     }
2708.     // requires a content object to be passed as $content
2709.     public function partnerspage(
2710.         Request $request,
2711.         ContentHelper $contentHelper,
2712.         $content = ""
2713.     ) {
2714.         
2715.         $directories = $contentHelper->getDirectoryListings(0,"_","_","_","_","_",10000);
2716.         
2717.         return $this->defaultRender("content/tmpl/partners-page.html.twig", [
2718.             "content" => $content,
2719.             "directories" => $directories["listings"],
2720.         ]);
2721.     }
2722.     
2725.     // requires a content object to be passed as $content
2726.     public function popoutAd(
2727.         Request $request,
2728.         ContentHelper $contentHelper,
2729.         CustomerHelper $customerHelper,
2730.         EmailHelper $emailHelper,
2731.         MediaHelper $mediaHelper,
2732.         $content = ""
2733.     ) {
2734.         if($content instanceof Content) {
2735.             $customer = $content->getPrimaryCustomer();
2736.             $popout = $mediaHelper->getPopoutAdByCustomer($customer);
2737.             if(!$popout) {
2738.                 $popout = $mediaHelper->getDefaultPopoutAd();
2739.                 $customer = $customerHelper->getCustomerById(110);
2740.             }
2741.         }
2742.         else {
2743.             //$content = ""; $customer = ""; $popout = "";
2744.             $content = "";
2745.             $popout = $mediaHelper->getDefaultPopoutAd();
2746.             $customer = $customerHelper->getCustomerById(110);
2747.         }
2748.         return $this->defaultRender("elements/popout-ad.html.twig", [
2749.             "popout" => $popout,
2750.             "customer" => $customer,
2751.         ]);
2752.     }
2753.     
2755.     // requires a content object to be passed as $content
2756.     public function pinnedSidebarAd(
2757.         Request $request,
2758.         MediaHelper $mediaHelper,
2759.         $base_url = "",
2760.         $uri = "",
2761.         $current_route = ""
2762.     ) {
2763.         //$site_code = $this->site_code;
2764.         $ad = $mediaHelper->getPinnedAdByPosition($base_url, parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH), $current_route, "ad-sidebar");
2765.         return $this->defaultRender("elements/sidebar-ad.html.twig", [
2766.             "ad" => $ad
2767.             //,"uri" => parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH)
2768.         ]);
2769.     }
2771.     // requires a content object to be passed as $content
2772.     public function pinnedCurtainAd(
2773.         Request $request,
2774.         MediaHelper $mediaHelper,
2775.         $base_url = "",
2776.         $uri = "",
2777.         $current_route = ""
2778.     ) {
2779.         $ad = $mediaHelper->getPinnedAdByPosition($base_url, parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH), $current_route, "ad-curtain");
2781.         //Temporarily hard-coding to remove specific ad from specific page per ticket #186003
2782.         if($ad && $ad->getId() == 13296 && str_starts_with($uri, "/webinar/maximizing-solar-rooftop-durability")) {
2783.             $ad = "";
2784.         }
2786.         return $this->defaultRender("elements/curtain-ad.html.twig", [
2787.             "ad" => $ad
2788.         ]);
2789.     }
2790.     
2792.     
2793.     /**
2794.     * @Route("/quiz/{slug}", name="Quick Quiz")
2795.     */
2796.     public function getQuiz(
2797.         Request $request,
2798.         QuizHelper $quizHelper,
2799.         $slug
2800.     ){
2801.         $cookies = $request->cookies;
2803.         if (!$this->user && !$cookies->has("$slug-quizToken")) {
2804.             $nt = uniqid();
2805.             setcookie("$slug-quizToken", $nt,0,'','',true,true);
2806.         }
2808.         $quiz = $quizHelper->getLandingPageBySlug($slug);
2809.         //Static quiz templates:
2810.         if ($quiz && in_array($slug, ["wdyfir", "certainteed"]) && $this->site_code == Site::SITE_RCS) {
2811.             return $this->defaultRender("content/quiz/$slug/landing.html.twig",$quiz);
2812.         }
2813.         else {
2814.             //Dynamic Quizzes:
2815.             $quiz = $quizHelper->getQuizObjectBySlug($slug);
2816.             if($quiz) {
2817.                 return $this->defaultRender("content/quiz/dynamic/landing.html.twig", [
2818.                     "quiz" => $quiz
2819.                 ]);
2820.             }
2821.         }
2822.     }
2824.     /**
2825.     * @Route("/quizExport/{quizId}", name="quiz_export")
2826.     */
2827.     public function quizExport(
2828.         Request $request,
2829.         QuizHelper $quizHelper,
2830.         $quizId = ""
2831.     ) {
2833.         $access = false;
2834.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
2835.             $user = $this->getUser();
2836.             if($user) {
2837.                 if($this->user->isAdmin()) {
2838.                     $access = true;
2839.                 }
2840.             }
2841.         }
2842.         if(!$access) {
2843.             return $this->defaultRender("errors/404.html.twig", []);
2844.         }
2845.         $quiz = $quizHelper->getQuizById($quizId);
2846.         $responses = $quiz->getQuizResponses()->matching(Criteria::create()->orderBy(["datetaken" => Criteria::DESC]));
2847.         $questions = $quiz->getQuizQuestions()->matching(Criteria::create()->orderBy(["sort" => Criteria::ASC]));
2848.         
2849.         //Export / Spreadsheet
2850.         $spreadsheet = new Spreadsheet();
2851.         
2852.         $spreadsheet = new Spreadsheet();
2853.         $sheet = $spreadsheet->getActiveSheet();
2854.         
2855.         //Sheet 1
2856.         $rowNum = 1;
2857.         $sheet->setTitle("Quiz Results");
2859.         $sheet->setCellValue("A{$rowNum}", "Date Taken");
2860.         $sheet->setCellValue("B{$rowNum}", "Name");
2861.         $sheet->setCellValue("C{$rowNum}", "Email");
2862.         $sheet->setCellValue("D{$rowNum}", "Finished");
2863.         $sheet->setCellValue("E{$rowNum}", "Score");
2864.         $colVal = "F";
2865.         foreach($questions as $question) {
2866.             $sheet->setCellValue("{$colVal}{$rowNum}", $question->getTitle());
2867.             $colVal++;
2868.         }
2869.         $sheet->getStyle("A1:{$colVal}1")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
2870.         $rowNum++;
2871.         
2872.         foreach($responses as $response) {
2873.             if($questions->first() && !$response->getAnswerByQuestionId($questions->first()->getId())) {
2874.                 continue; //Skip if first question isn't answered (caused by a bug)
2875.             }
2876.             $colVal = "A";
2877.             $name = $response->getUser() ? $response->getUser()->getFullName() : $response->getNlFullName();
2878.             $email = $response->getUser() ? $response->getUser()->getEmail() : $response->getNlEmail();
2879.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getDatetaken()->format("Y-m-d H:i:s")); $colVal++;
2880.             $sheet->setCellValue("{$colVal}{$rowNum}", $name); $colVal++;
2881.             $sheet->setCellValue("{$colVal}{$rowNum}", $email); $colVal++;
2882.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getIsFinished() ? "Yes" : "No"); $colVal++;
2883.             //$sheet->setCellValue("{$colVal}{$rowNum}", $response->getMessage() ? $response->getMessage() : "N/A"); $colVal++;
2884.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getScore()); $colVal++;
2885.             foreach($questions as $question) {
2886.                 $answer = $response->getAnswerByQuestionId($question->getId());
2887.                 $sheet->setCellValue("{$colVal}{$rowNum}", $answer ? $answer : "");
2888.                 $colVal++;
2889.             }
2890.             $rowNum++;
2891.         }
2893.         foreach(range("A",$sheet->getHighestColumn()) as $columnID) {
2894.             $sheet->getColumnDimension($columnID)
2895.                 ->setAutoSize(true);
2896.         }
2897.         
2898.         //Finish and save
2899.         //$spreadsheet->setActiveSheetIndexByName("Quiz Results");
2900.         $writer = new Xlsx($spreadsheet);
2901.         $filename = "Quiz Export - {$quiz->getTitle()}.xlsx";
2902.         $writer->save("../var/reports/quizzes/{$filename}");
2903.         
2904.         $response = new BinaryFileResponse("../var/reports/quizzes/{$filename}");
2905.         $disposition = $response->headers->makeDisposition(
2906.             ResponseHeaderBag::DISPOSITION_ATTACHMENT,
2907.             $filename
2908.         );
2909.         $response->headers->set('Content-Disposition', $disposition);
2910.         return $response;
2911.     }
2914.     /**
2915.     * @Route("/quiz/{slug}/collect-information", name="Quiz-Lead",methods={"GET"})
2916.     */
2917.     public function quizLead(
2918.         Request $request,
2919.         QuizHelper $quizHelper,
2920.         $slug
2921.     ){
2922.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
2924.         $ref = $request->query->get("ref");
2925.         if (in_array($slug, ["wdyfir", "certainteed"])) {
2926.             return $this->defaultRender("content/quiz/$slug/infoCollector.html.twig", [
2927.                 'ref'=>$ref,
2928.                 'img'=>$quizHelper->getLandingPageBySlug($slug)['img']
2929.             ]);
2930.         }
2931.         return $this->defaultRender("content/quiz/dynamic/infoCollector.html.twig", [
2932.             'ref' => $ref,
2933.             'quiz' => $quiz,
2934.             //'img'=>$quizHelper->getLandingPageBySlug($slug)['img']
2935.         ]);
2936.         
2937.     }
2939.     /**
2940.     * @Route("/quiz/{slug}/collect-information", name="Quiz-Lead-data", methods={"POST"})
2941.     */
2942.     public function quizLeadData(
2943.         Request $request,
2944.         QuizHelper $quizHelper,
2945.         $slug
2946.     ){
2947.         $ref = $request->request->get("ref");
2948.         $fname = $request->request->get("firstName");
2949.         $lname = $request->request->get("lastName");
2950.         $email = $request->request->get("email");
2951.         $newsletter = $request->request->get("newsletter");
2952.         
2953.         // normalize newsletter
2954.         if($newsletter == "on") {
2955.             $newsletter = 1;
2956.         }else{
2957.             $newsletter = 0;
2958.         }
2960.         // process information // save the lead
2961.         $quizHelper->saveUnauthedQuizLead($fname, $lname, $email, $ref, $newsletter);
2962.         
2963.         $quizResponse = $quizHelper->getQuizResponseByRefurl($ref);
2964.         $quizHelper->sendQuizResultsEmail($quizResponse->getId());
2965.         
2966.         return $this->redirectToRoute("Quiz-Results", [
2967.             "slug" => $slug,
2968.             "ref" => $ref
2969.         ]);
2971.     }
2975.     /**
2976.     * @Route("/quiz/{slug}/{question}", name="Quick-Question", methods={"GET"})
2977.     */
2978.     public function getQuestionByQuizByNumber(
2979.         Request $request,
2980.         QuizHelper $quizHelper,
2981.         $slug,
2982.         $question
2983.     ){
2984.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
2986.         if($quiz->getRequiresLogin() && !$this->user) {
2987.             return $this->redirectToRoute("Quick Quiz", [
2988.                 "slug" => $slug,
2989.             ]);
2990.         }
2991.         
2992.         if (!in_array($slug, ["wdyfir", "certainteed"])) {
2993.             $cookies = $request->cookies;
2994.             if ($this->user || $cookies->has("$slug-quizToken")) {
2995.                 $uid = $this->user ? $this->user->getID() : $cookies->get("$slug-quizToken");
2996.                 $lastQuestionNumber = $quizHelper->getInProgressQuizByID($slug,$uid);
2998.                 if ($lastQuestionNumber && $lastQuestionNumber+1 != $question) {
2999.                     return $this->redirectToRoute("Quick-Question", [
3000.                         "slug" => $slug,
3001.                         "question" => $lastQuestionNumber+1
3002.                     ]);
3003.                 }elseif(!$lastQuestionNumber && $question!=1){
3004.                     return $this->redirectToRoute("Quick-Question", [
3005.                         "slug" => $slug,
3006.                         "question" => 1
3007.                     ]);
3008.                 }
3009.             }
3010.         }
3012.         if (in_array($slug, ["wdyfir", "certainteed"])) {
3013.             $q = $quizHelper->getQuestionOptionsByQuizByNumber($slug, $question);
3014.             if ($q) {
3015.                 return $this->defaultRender("content/quiz/$slug/question.html.twig",$q);
3016.             }else{
3017.                 return $this->defaultRender("errors/404.html.twig", []);
3018.             }
3019.         }
3020.         else {
3021.             //Dynamic Quizzes:
3022.             $number = $question;
3023.             $quiz = $quizHelper->getQuizObjectBySlug($slug);
3024.             $question = $quiz->getQuestionByNumber($number);
3025.             if($question) {
3026.                 return $this->defaultRender("content/quiz/dynamic/question.html.twig", [
3027.                     "quiz" => $quiz,
3028.                     "question" => $question,
3029.                     "number" => $number
3030.                 ]);
3031.             }
3032.         }
3034.         
3035.     }
3037.     /**
3038.     * @Route("/quiz/{slug}/{question}", name="Question-Answer", methods={"POST"})
3039.     */
3040.     public function saveQuestionResponse(
3041.         Request $request,
3042.         QuizHelper $quizHelper,
3043.         MailChimpHelper $mailChimpHelper,
3044.         $slug,
3045.         $question
3046.     ){
3047.         $cookies = $request->cookies;
3048.         $qid = $quizHelper->getQuizBySlug($slug)['id'];
3049.         if (!$this->user) {
3050.             $uid = NULL;
3051.             $nt = $cookies->get("$slug-quizToken");
3052.         }else{
3053.             $uid = $this->user->getID();
3054.             $nt = NULL;
3055.         }
3056.         
3057.         $questionObject = $quizHelper->getQuestionById($request->request->get("questionId"));
3058.         if($questionObject->getType() == QuizQuestion::RADIO_BUTTONS) {
3059.             $userAnswer = $quizHelper->getOptionByID($request->request->get("question-$question"));
3060.             $qoid = $userAnswer['id'];
3061.             $a = $userAnswer['title'];
3062.         }
3063.         else {
3064.             $qoid = null;
3065.             $a = $request->request->get("question-$question");
3066.         }
3068.         $responseID = $quizHelper->saveResponse($uid, $nt, $qid, $questionObject->getId(), $qoid, $a);
3069.         
3070.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
3072.         if (in_array($slug, ["wdyfir", "certainteed"]) && $question == $quizHelper->getLastQuestionNumberBySlug($slug)) {
3074.             $ref = $quizHelper->finishQuiz($responseID);
3076.             if ($this->user) {
3077.                 $email = $this->user->getEmail();
3078.                 $fname = $this->user->getFirstName();
3079.                 $lname = $this->user->getLastName();
3080.                 // need to add to mailchimp here too 
3081.                 $mailChimpHelper->subscribe($email,
3082.                     [
3083.                         'FNAME'=>$fname,
3084.                         'LNAME'=>$lname
3085.                     ],
3086.                     [
3087.                         'WIR'
3088.                     ]
3089.                 );
3091.                 $quizHelper->sendQuizResultsEmail($responseID);
3093.                 return $this->redirectToRoute("Quiz-Results", [
3094.                     "slug" => $slug,
3095.                     "ref" => $ref
3096.                 ]);
3097.             }else{
3098.                 return $this->redirectToRoute("Quiz-Lead", [
3099.                     "slug" => $slug,
3100.                     "ref" => $ref
3101.                 ]);
3102.             }
3104.         }
3105.         elseif(!in_array($slug, ["wdyfir", "certainteed"]) && $question == $quiz->countQuizQuestions()) {
3106.             //Dynamic Quizzes:
3107.             $ref = $quizHelper->finishQuiz($responseID);
3108.             if ($this->user) {
3109.                 $quizHelper->sendQuizResultsEmail($responseID, $ref);
3111.                 return $this->redirectToRoute("Quiz-Results", [
3112.                     "slug" => $slug,
3113.                     "ref" => $ref
3114.                 ]);
3115.             }
3116.             else {
3117.                 return $this->redirectToRoute("Quiz-Lead", [
3118.                     "slug" => $slug,
3119.                     "ref" => $ref
3120.                 ]);
3121.             }
3122.         }
3123.         else{
3124.             return $this->redirectToRoute("Quick-Question", [
3125.                 "slug" => $slug,
3126.                 "question" => $question+1
3127.             ]);
3128.         }
3130.     }
3132.     /**
3133.     * @Route("/quiz/{slug}/results/{ref}", name="Quiz-Results")
3134.     */
3135.     public function quizResults(
3136.         Request $request,
3137.         QuizHelper $quizHelper,
3138.         $slug,
3139.         $ref
3140.     ){
3141.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
3143.         $results = $quizHelper->getResultsByRef($ref);
3144.         if(in_array($slug, ["wdyfir", "certainteed"])) {
3145.             return $this->defaultRender("content/quiz/$slug/ending.html.twig", $results);
3146.         }
3147.         $response = $quizHelper->getQuizResponseByRefurl($ref);
3148.         return $this->defaultRender("content/quiz/dynamic/ending.html.twig", [
3149.             "quiz" => $quiz,
3150.             "response" => $response,
3151.             "result" => $response->getQuizResult()
3152.         ]);
3153.     }
3156.     /**
3157.     * @Route("/quizz/debugger", name="quiz-debugger")
3158.     */
3159.     public function quizDebugger(
3160.         Request $request,
3161.         QuizHelper $quizHelper
3162.     ){
3163.         return new JsonResponse($this->user->getLastname());
3164.     }
3167.     
3168.     //TODO: move all ajax to different controllers
3169.         
3170.         /**
3171.         * @Route("/ajax/social-data")
3172.         */
3173.         public function socialDataAjaxAction(
3174.             Request $request,
3175.             CustomerHelper $customerHelper
3176.         ) {
3177.             return new JsonResponse(json_encode(
3178.                 [
3179.                     "facebookHandles" => $customerHelper->getFacebookHandles(),
3180.                     "linkedinHandles" => $customerHelper->getLinkedinHandles(),
3181.                     "twitterHandles" => $customerHelper->getTwitterHandles(),
3182.                     "tags" => $customerHelper->getCustomerTags()
3183.                 ]
3184.             ));
3185.         }
3187.         /**
3188.         * @Route("/ajax/link")
3189.         */
3190.         public function linkAjaxAction(
3191.             Request $request,
3192.             MenuHelper $menuHelper,
3193.             ContentHelper $contentHelper
3194.         ) {
3195.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3196.                 $id = $request->get("id");
3197.                 $link = $menuHelper->getLinkById($id);
3198.                 if($link) {
3199.                     $contentHelper->addImpression($request, "", $link);
3200.                     return new JsonResponse($link->getRef());
3201.                 }
3202.             }
3203.         }
3204.         
3205.         /**
3206.         * @Route("/ajax/link-catchall")
3207.         */
3208.         public function linkCatchallAjaxAction(
3209.             Request $request,
3210.             ContentHelper $contentHelper
3211.         ) {
3212.             
3213.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3214.                 
3215.                 $path = $request->get("path");
3216.                 $href = $request->get("href");
3217.                 
3218.                 $entityManager = $this->getDoctrine()->getManager();
3219.                 $content = $entityManager
3220.                     ->getRepository(Content::class)
3221.                     ->getContentByUrl(
3222.                         $path,
3223.                         $this->site_code
3224.                     );
3225.                     
3226.                 //if($content) {
3227.                     $contentHelper->addImpression($request, $content, "", "", "3", $href);
3228.                     return new JsonResponse($content ? $content->getId() : null);
3229.                 //}
3230.                 
3231.             }
3232.             
3233.         }
3234.         
3235.         /**
3236.         * @Route("/ajax/mitem-click")
3237.         */
3238.         public function mitemClickAjaxAction(
3239.             Request $request,
3240.             MediaHelper $mediaHelper,
3241.             ContentHelper $contentHelper
3242.         ) {
3244.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3246.                 $id = $request->get("id");
3247.                 $item = $mediaHelper->getMediaGroupItemById($id);
3248.                 if($item) {
3249.                     $contentHelper->addImpression($request, "", "", $item, 2);
3250.                     return new JsonResponse($item->getExternalUrl());
3251.                 }
3253.             }
3255.         }
3257.         /**
3258.         * @Route("/ajax/mitem-impression")
3259.         */
3260.         public function mitemImpressionAjaxAction(
3261.             Request $request,
3262.             MediaHelper $mediaHelper,
3263.             ContentHelper $contentHelper
3264.         ) {
3266.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3268.                 $id = $request->get("id");
3269.                 $item = $mediaHelper->getMediaGroupItemById($id);
3270.                 if($item) {
3271.                     $contentHelper->addImpression($request, "", "", $item, 1);
3272.                     return new JsonResponse($item->getExternalUrl());
3273.                 }
3275.             }
3277.         }
3278.         
3279.         //New function for multiple impressions below
3280.         
3281.         /**
3282.         * @Route("/ajax/mitem-impressions")
3283.         */
3284.         public function mitemImpressionsAjaxAction(
3285.             Request $request,
3286.             MediaHelper $mediaHelper,
3287.             ContentHelper $contentHelper
3288.         ) {
3290.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3291.                 
3292.                 $ids = $request->get("ids");
3293.                 $return = [];
3294.                 
3295.                 foreach($ids as $id) {
3296.                     $item = $mediaHelper->getMediaGroupItemByIdOrNull($id);
3297.                     if($item) {
3298.                         $contentHelper->addImpression($request, "", "", $item, 1);
3299.                         $return[] = $item->getExternalUrl();
3300.                     }
3301.                 }
3302.                 
3303.                 return new JsonResponse($return);
3305.             }
3307.         }
3308.         
3309.         /**
3310.         * @Route("/ajax/content-impressions")
3311.         */
3312.         public function contentImpressionsAjaxAction(
3313.             Request $request,
3314.             ContentHelper $contentHelper
3315.         ) {
3316.             
3317.             $contentHelper->storeQueuedImpressions($request);
3318.             return new JsonResponse("Content Impressions Stored");
3319.             
3320.         }
3322.         /**
3323.         * @Route("/ajax/like-content")
3324.         */
3325.         public function likeAjaxAction(
3326.             Request $request,
3327.             ContentHelper $helper
3328.         ) {
3330.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
3332.                 $id = $request->get("id");
3333.                 if($id) {
3334.                     $content = $helper->getContentById($id);
3335.                     $helper->likeContent($content, $this->getUser());
3336.                     $likes = $helper->countLikes($content);
3338.                     $entityManager = $this->getDoctrine()->getManager();
3339.                     $entityManager->persist($content);
3340.                     $entityManager->flush();
3342.                     return new JsonResponse($likes);
3344.                 }
3345.                 else {
3346.                     return null;
3347.                 }
3349.             } else {
3351.             }
3352.         }
3354.         /**
3355.         * @Route("/ajax/unlike-content")
3356.         */
3357.         public function unlikeAjaxAction(
3358.             Request $request,
3359.             ContentHelper $helper
3360.         ) {
3362.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
3364.                 $id = $request->get("id");
3365.                 if($id) {
3366.                     $content = $helper->getContentById($id);
3367.                     $helper->unlikeContent($content, $this->getUser());
3368.                     $likes = $helper->countLikes($content);
3370.                     $entityManager = $this->getDoctrine()->getManager();
3371.                     $entityManager->persist($content);
3372.                     $entityManager->flush();
3374.                     return new JsonResponse($likes);
3376.                 }
3377.                 else {
3378.                     return null;
3379.                 }
3381.             } else {
3383.             }
3384.         }
3386.         /**
3387.         * @Route("/ajax/forum-quote-content")
3388.         */
3389.         public function forumQuoteAjaxAction(
3390.             Request $request,
3391.             ContentHelper $helper
3392.         ) {
3394.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
3396.                 $id = $request->get("id");
3397.                 if($id) {
3398.                     $content = $helper->getContentById($id);
3400.                     return new JsonResponse("<blockquote>".$content->getContentFull()."<br> -".$content->getAuthor()."</blockquote>");
3402.                 }
3403.                 else {
3404.                     return null;
3405.                 }
3407.             } else {
3409.             }
3410.         }
3412.         /**
3413.         * @Route("/ajax/forum-images-upload")
3414.         */
3415.         public function forumUploadImage(
3416.             Request $request,
3417.             ContentHelper $helper
3418.         ) {
3419.             /*
3420.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
3421.             $id = $request->get("id");
3422.             return new JsonResponse("<blockquote>".$content->getContentFull()."<br> -".$content->getAuthor()."</blockquote>");
3423.             }*/
3424.             
3425.             //$accepted_origins = array("http://localhost", "http://192.168.1.1", "http://example.com");
3426.             
3427.             $imageFolder = "uploads/forum/";
3428.             
3429.             reset ($_FILES);
3430.             $temp = current($_FILES);
3431.             if (is_uploaded_file($temp['tmp_name'])){
3432.                 
3433.                 // Sanitize input
3434.                 if (preg_match("/([^\w\s\d\-_~,;:\[\]\(\).])|([\.]{2,})/", $temp['name'])) {
3435.                     return new JsonResponse(array('error' => "Invalid file name."));
3436.                 }
3437.                 
3438.                 // Verify extension
3439.                 if (!in_array(strtolower(pathinfo($temp['name'], PATHINFO_EXTENSION)), array("gif", "jpg", "png"))) {
3440.                     return new JsonResponse(array('error' => "Invalid file type."));
3441.                 }
3442.                 
3443.                 // Make a unique filename
3444.                 $filename = pathinfo($temp['name'], PATHINFO_FILENAME );
3445.                 $ext = pathinfo($temp['name'], PATHINFO_EXTENSION);
3446.                 
3447.                 $filename = trim(trim(strtolower($filename)), '-');
3448.                 $filename = str_replace(' ', '-', $filename);
3449.                 $filename = preg_replace('/-+/', '-', $filename);
3450.                 $filename = preg_replace('/[^a-z0-9-]/', '', $filename);
3451.                 
3452.                 $final_filename = $filename . "." . $ext;
3453.                 $x = 2;
3454.                 while(file_exists($imageFolder . $final_filename)) {
3455.                     $final_filename = $filename . '-' . $x++ . "." . $ext;
3456.                 }
3457.                 
3458.                 // Accept upload if there was no origin, or if it is an accepted origin
3459.                 $filetowrite = $imageFolder . $final_filename;
3460.                 move_uploaded_file($temp['tmp_name'], $filetowrite);
3461.                 
3462.                 //$filetowrite = $imageFolder . $temp['name'];
3463.                 //move_uploaded_file($temp['tmp_name'], $filetowrite);
3464.                 
3465.                 // Respond to the successful upload with JSON.
3466.                 // Use a location key to specify the path to the saved image resource.
3467.                 return new JsonResponse(array('location' => "/".$filetowrite));
3468.             } else {
3469.                 // Notify editor that the upload failed
3470.                 return new JsonResponse(array('error' => "500 Server Error."));
3471.             }
3472.             
3473.         }
3474.         
3475.         /**
3476.         * @Route("/ajax/ckeditor-image-upload")
3477.         */
3478.         public function ckeditorUploadImage(
3479.             Request $request,
3480.             ContentHelper $helper
3481.         ) {
3482.             
3483.             if ($request->files->get("upload")) { //image field
3484.                 
3485.                 $uploaded_image = $request->files->get("upload");
3486.                 
3487.                 $mime = $uploaded_image->getMimeType();
3488.                 if(!in_array($mime, ["image/jpg", "image/jpeg", "image/png", "image/gif"])) {
3489.                     return new JsonResponse(array('error' => "Only PNG, JPG, and GIF file types are allowed."));
3490.                 }
3491.                 
3492.                 $media = new Media();
3493.                 $media->setTitle(pathinfo($uploaded_image->getClientOriginalName(), PATHINFO_FILENAME));
3494.                 $media->setData($uploaded_image);
3495.                 $media->setDescription("Image uploaded through CKEditor.");
3496.                 $media->setName($uploaded_image->getClientOriginalName());
3497.                 
3498.                 $entityManager = $this->getDoctrine()->getManager();
3499.                 $entityManager->persist($media);
3500.                 $entityManager->flush();
3501.                 
3502.                 return new JsonResponse(array('url' => $media->getURL()));
3503.             } else {
3504.                 // Notify editor that the upload failed
3505.                 return new JsonResponse(array('error' => "500 Server Error."));
3506.             }
3507.             
3508.         }
3510.         /**
3511.         * @Route("/ajax/get-user-lead-info")
3512.         */
3513.         public function getUserLeadInfoAjaxAction(
3514.             Request $request,
3515.             ContentHelper $helper
3516.         ) {
3517.             if($this->user && ($this->user->isMember() || $this->user->isAdmin())) {
3518.                 
3519.                 $lead["firstname"] = $this->user->getUserMetaValueByKey("lead_firstname");
3520.                 $lead["lastname"] = $this->user->getUserMetaValueByKey("lead_lastname");
3521.                 $lead["company"] = $this->user->getUserMetaValueByKey("lead_company");
3522.                 $lead["phone"] = $this->user->getUserMetaValueByKey("lead_phone");
3523.                 $lead["email"] = $this->user->getUserMetaValueByKey("lead_email");
3524.                 $lead["address1"] = $this->user->getUserMetaValueByKey("lead_address1");
3525.                 $lead["address2"] = $this->user->getUserMetaValueByKey("lead_address2");
3526.                 $lead["city"] = $this->user->getUserMetaValueByKey("lead_city");
3527.                 $lead["state"] = $this->user->getUserMetaValueByKey("lead_state");
3528.                 $lead["zip"] = $this->user->getUserMetaValueByKey("lead_zip");
3529.                 $lead["country"] = $this->user->getUserMetaValueByKey("lead_country");
3530.                 $lead["country_other"] = $this->user->getUserMetaValueByKey("lead_country_other");
3531.                 $lead["contractor_type"] = $this->user->getUserMetaValueByKey("lead_contractor_type");
3532.                 $lead["business_type"] = $this->user->getUserMetaValueByKey("lead_business_type");
3533.                 
3534.                 return new JsonResponse(json_encode($lead));
3535.                 
3536.             } else {
3537.                 return new JsonResponse("");
3538.             }
3539.         }
3540.         
3541.         /**
3542.         * @Route("/ajax/setSessionVariable")
3543.         */
3544.         public function setSessionVariableAjaxAction(
3545.             Request $request
3546.         ) {
3547.             
3548.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3549.                 
3550.                 $key = $request->get("key");
3551.                 $value = $request->get("value");
3552.                 
3553.                 if($key) {
3554.                     $session = $request->getSession();
3555.                     
3556.                     if($value) {
3557.                         $session->set($key, $value);
3558.                     }
3559.                     else {
3560.                         $session->remove($key);
3561.                     }
3562.                     
3563.                     return new JsonResponse("Session variable set.");
3564.                 }
3565.                 
3566.             }
3567.             
3568.             return new JsonResponse("Session variable set.");
3569.             
3570.         }
3571.         
3572.         /**
3573.         * @Route("/pollExport/{pollId}", name="poll_export")
3574.         */
3575.         public function pollExport(
3576.             Request $request,
3577.             PollHelper $pollHelper,
3578.             $pollId = ""
3579.         ) {
3580.             
3581.             $access = false;
3582.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
3583.                 $user = $this->getUser();
3584.                 if($user) {
3585.                     if($this->user->isAdmin()) {
3586.                         $access = true;
3587.                     }
3588.                 }
3589.             }
3590.             
3591.             $poll = $pollHelper->getPollById($pollId);
3592.             $pollOptions = $poll->getPollOptions();
3593.             $pollResponses = $poll->getPollResponses();
3594.             
3595.             //Export / Spreadsheet
3596.             $spreadsheet = new Spreadsheet();
3597.             
3598.             $spreadsheet = new Spreadsheet();
3599.             $sheet = $spreadsheet->getActiveSheet();
3600.             
3601.             //Sheet 1
3602.             $rowNum = 1;
3603.             $sheet->setTitle("Poll Results");
3604.             $sheet->setCellValue("A{$rowNum}", "Poll Option");
3605.             $sheet->setCellValue("B{$rowNum}", "Votes");
3606.             $sheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3607.             $sheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3608.             $rowNum++;
3609.             
3610.             foreach($pollOptions as $pollOption) {
3611.                 $sheet->setCellValue("A{$rowNum}", $pollOption->getText());
3612.                 $sheet->setCellValue("B{$rowNum}", $pollOption->countResponses());
3613.                 $rowNum++;
3614.             }
3615.             $sheet->setCellValue("A{$rowNum}", "Total:");
3616.             $sheet->setCellValue("B{$rowNum}", $poll->countResponses());
3617.             $sheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3618.             $sheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3619.             
3620.             foreach(range("A",$sheet->getHighestColumn()) as $columnID) {
3621.                 $sheet->getColumnDimension($columnID)
3622.                     ->setAutoSize(true);
3623.             }
3624.             
3625.             //Sheet 2
3626.             $indSheet = new \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet($spreadsheet, 'Individual Votes');
3627.             $spreadsheet->addSheet($indSheet, 0);
3628.             
3629.             $rowNum = 1;
3630.             $indSheet->setTitle("Individual Votes");
3631.             $indSheet->setCellValue("A{$rowNum}", "User");
3632.             $indSheet->setCellValue("B{$rowNum}", "Vote");
3633.             $indSheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3634.             $indSheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
3635.             $rowNum++;
3636.             
3637.             foreach($pollResponses as $pollResponse) {
3638.                 $indSheet->setCellValue("A{$rowNum}", $pollResponse->getUser() ? $pollResponse->getUser() : "anonymous");
3639.                 $indSheet->setCellValue("B{$rowNum}", $pollResponse->getPollOption());
3640.                 $rowNum++;
3641.             }
3642.             
3643.             foreach(range("A",$indSheet->getHighestColumn()) as $columnID) {
3644.                 $indSheet->getColumnDimension($columnID)
3645.                     ->setAutoSize(true);
3646.             }
3647.             
3648.             //Finish and save
3649.             $spreadsheet->setActiveSheetIndexByName("Poll Results");
3650.             $writer = new Xlsx($spreadsheet);
3651.             $filename = "Poll Export {$pollId}.xlsx";
3652.             $writer->save("../var/reports/polls/{$filename}");
3653.             
3654.             //return new JsonResponse($filename . " saved");
3655.             
3656.             //$filename = $request->request->get("filename");
3657.             $response = new BinaryFileResponse("../var/reports/polls/{$filename}");
3658.             $disposition = $response->headers->makeDisposition(
3659.                 ResponseHeaderBag::DISPOSITION_ATTACHMENT,
3660.                 $filename
3661.             );
3662.             $response->headers->set('Content-Disposition', $disposition);
3663.             return $response;
3664.         }
3666.         /**
3667.         * @Route("/ajax/pollResponse")
3668.         */
3669.         public function addPollResponse(
3670.             Request $request,
3671.             PollHelper $pollHelper
3672.         ) {
3673.             
3674.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
3675.                 
3676.                 $pollId = $request->get("pollId");
3677.                 $pollOptionId = $request->get("pollOptionId");
3678.                 $userId = $request->get("userId");
3679.                 
3680.                 if($pollOptionId) {
3681.                     $pollHelper->addPollResponse($pollOptionId, $userId ? $userId : NULL);
3682.                     $results = $pollHelper->getPollResults($pollId);
3683.                     //$results = implode(" ", $pollHelper->getPollResults($pollId));
3684.                     return new JsonResponse($results);
3685.                 }
3686.                 
3687.             }
3688.             
3689.             return new JsonResponse("Failure.");
3690.             
3691.         }
3692.         
3693.         /**
3694.         * @Route("/ajax/pollResults")
3695.         */
3696.         public function getpollResultsAjax(
3697.             Request $request,
3698.             PollHelper $pollHelper,
3699.             Environment $twig,
3700.             $id = ""
3701.         ) {
3702.             try {
3703.                 $id = $request->get("id");
3704.                 
3705.                 $poll = $pollHelper->getPollById($id);
3706.                 
3707.                 $tmpl = $twig->load("polls/admin-poll-results-embed.html.twig");
3708.                 $html = $tmpl->render(
3709.                 [
3710.                     "poll" => $poll
3711.                 ]);
3712.                 
3713.                 return new JsonResponse($html);
3714.             }
3715.             catch (\Exception $e) {
3716.                 return new JsonResponse("<div>Error loading poll results.</div>");
3717.                 //return new JsonResponse($e->getMessage());
3718.             }
3719.             
3720.         }
3722.         /**
3723.         * @Route("/ajax/quizResults")
3724.         */
3725.         public function getQuizResultsAjax(
3726.             Request $request,
3727.             QuizHelper $quizHelper,
3728.             Environment $twig,
3729.             $id = ""
3730.         ) {
3731.             try {
3732.                 $id = $request->get("id");
3733.                 
3734.                 $quiz = $quizHelper->getQuizById($id);
3735.                 
3736.                 $tmpl = $twig->load("quizzes/admin-quiz-results-embed.html.twig");
3737.                 $html = $tmpl->render(
3738.                 [
3739.                     "quiz" => $quiz
3740.                 ]);
3741.                 
3742.                 return new JsonResponse($html);
3743.             }
3744.             catch (\Exception $e) {
3745.                 return new JsonResponse("<div>Error loading quiz results.</div>");
3746.             }
3747.             
3748.         }
3750.         /**
3751.         * @Route("/ajax/contentUserViews")
3752.         */
3753.         public function getContentUserViews(
3754.             Request $request,
3755.             ContentHelper $contentHelper,
3756.             Environment $twig,
3757.             $id = ""
3758.         ) {
3759.             //return false;
3760.             try {
3761.                 $id = $request->get("id");
3762.                 $content = $contentHelper->getContentById($id);
3764.                 $entityManager = $this->getDoctrine()->getManager();
3770.                 //TODO: Make a service for this
3771.                 
3772.                 //Google Analytics
3773.                 $year = date("Y");
3774.                 $month = date("n");
3776.                 //$startDate = date("Y-m-d", strtotime($year."-".$month."-"."01"));
3777.                 $startDate = date("Y-m-d", strtotime("2020-10-"."01")); //when we started using this custom dimension
3778.                 //$startDate = new \DateTime($startDate);
3779.                 $endDate = date("Y-m-t", strtotime($year."-".$month."-01"));
3780.                 //$endDate = new \DateTime($endDate." 23:59:59");
3781.                 
3782.                 $client = new \Google_Client();
3783.                 $client->setApplicationName("RCS Analytic Reports");
3784.                 $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
3785.                 $client->setAuthConfig($KEY_FILE_LOCATION);
3786.                 $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
3788.                 $analytics = new \Google_Service_AnalyticsReporting($client);
3789.                 $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
3790.                 $dateRange->setStartDate($startDate);
3791.                 $dateRange->setEndDate($endDate);
3793.                 $views = new \Google_Service_AnalyticsReporting_Metric();
3794.                 $views->setExpression("ga:pageviews");
3795.                 $views->setAlias("pageviews");
3797.                 $path = new \Google_Service_AnalyticsReporting_Dimension();
3798.                 $path->setName("ga:pagePath");
3800.                 $rcsUserID = new \Google_Service_AnalyticsReporting_Dimension();
3801.                 $rcsUserID->setName("ga:dimension2");
3802.                 
3803.                 // Create the DimensionFilter.
3804.                 $dimensionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
3805.                 
3806.                 //Should be faster. Need to set for each job.
3807.                 $dimensionFilter->setDimensionName('ga:pagePath');
3808.                 $dimensionFilter->setOperator('IN_LIST');
3809.                 $dimensionFilter->setExpressions([$content->getURL(1)]);
3810.                 //$dimensionFilter->setExpressions(["/news-room"]);
3811.                 
3812.                 // Create the DimensionFilterClauses
3813.                 $dimensionFilterClause = new \Google_Service_AnalyticsReporting_DimensionFilterClause();
3814.                 $dimensionFilterClause->setFilters(array($dimensionFilter));
3817.                 $request = new \Google_Service_AnalyticsReporting_ReportRequest();
3818.                 $request->setViewId("126182454"); //< Unfiltered Website Data
3819.                 $request->setDateRanges($dateRange);
3820.                 $request->setDimensions(array($path, $rcsUserID));
3821.                 $request->setDimensionFilterClauses(array($dimensionFilterClause));
3822.                 $request->setMetrics(array($views));
3824.                 $request->setPageSize("10000");
3825.                 //$request->setPageSize("10");
3826.                 
3827.                 $order = new \Google_Service_AnalyticsReporting_OrderBy;
3828.                 $order->setFieldName("ga:pageviews");
3829.                 $order->setOrderType("VALUE");
3830.                 $order->setSortOrder("DESCENDING");
3831.                 $orders[] = $order;
3832.                 $request->setOrderBys($orders);
3834.                 $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
3835.                 $body->setReportRequests(array($request));
3836.                 $reports = $analytics->reports->batchGet($body);
3837.                 
3838.                 
3839.                 $data = [];
3840.                 for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
3841.                     $report = $reports[$reportIndex];
3842.                     $header = $report->getColumnHeader();
3843.                     $dimensionHeaders = $header->getDimensions();
3844.                     $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
3845.                     $rows = $report->getData()->getRows();
3847.                     for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
3848.                         $row = $rows[$rowIndex];
3849.                         $dimensions = $row->getDimensions();
3850.                         $metrics = $row->getMetrics();
3852.                         $path = "";
3853.                         $rcsUserID = "";
3854.                         $count = 0;
3856.                         for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
3857.                             
3858.                             if ($dimensionHeaders[$i] == "ga:pagePath") {
3859.                                 $path = $dimensions[$i];
3860.                             }
3862.                             if ($dimensionHeaders[$i] == "ga:dimension2") {
3863.                                 $rcsUserID = $dimensions[$i];
3864.                             }
3866.                         }
3868.                         
3869.                         $count = $metrics[0]->getValues()[0];
3870.                         
3871.                         
3872.                         //strip any url parameters
3873.                         //$path = strtok($path, "?");
3875.                         //for ($j = 0; $j < count($metricHeaders) && $j < count($metrics); $j++) {
3876.                         //    $entry = $metricHeaders[$j];
3877.                         //    $values = $metrics[$j];
3879.                         //    for ($valueIndex = 0; $valueIndex < count($values->getValues()); $valueIndex++) {
3880.                         //        $value = $values->getValues()[$valueIndex];
3881.                         //        $count = $value;
3882.                         //    }
3883.                         //}
3884.                         
3886.                         //if (!isset($data[$path])) {
3887.                         //    $data[$path] = array();
3888.                         //}
3889.                         //if (!isset($data[$path][$rcsUserID])) {
3890.                         //    $data[$path][$rcsUserID] = $count;
3891.                         //}
3892.                         //else {
3893.                         //    $data[$path][$rcsUserID] += $count;
3894.                         //}
3895.                         
3896.                         if (!isset($data[$rcsUserID])) {
3897.                             $user = $entityManager
3898.                                 ->getRepository(User::class)
3899.                                 ->findOneBy(["id" => $rcsUserID]);
3900.                             $data[$rcsUserID] = ["views" => $count, "user" => $user];
3901.                         }
3903.                     }
3904.                 }
3905.                 foreach($data as $key => $value) {
3906.                     
3907.                     /*
3908.                     if($key == "/") { continue; }
3909.                     
3910.                     $pos = strrpos($key, '/');
3911.                     $slug = $pos === false ? $key : substr($key, $pos + 1);
3912.                     
3913.                     $arr = explode("?", $slug, 2);
3914.                     $slug = $arr[0];
3915.                     
3916.                     if(!$slug) { continue; }
3918.                     $content = $entityManager
3919.                         ->getRepository(Content::class)
3920.                         ->findOneBy(["slug" => $slug]);
3921.                     
3922.                     if($content) {
3923.                         $edit_links[$key] = "/admin/content/". $content->getId() . "/edit";
3924.                         //TODO: Handle switching sites when editing.
3925.                         //$edit_links[$key] = "/admin/content/". $content->getId() . "/edit?site=". $content->getSite();
3926.                     }
3927.                     */
3928.                 }
3929.                 
3936.                 //Just copying above code for single week to get up in time for the meeting. Will clean up later.
3938.                 $year = date("Y");
3939.                 $month = date("n");
3940.                 $day = date("d");
3941.                 
3942.                 $startDate = date('Y-m-d', strtotime('-1 week'));
3943.                 $endDate = date("Y-m-d");
3944.                 
3945.                 $client = new \Google_Client();
3946.                 $client->setApplicationName("RCS Analytic Reports");
3947.                 $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
3948.                 $client->setAuthConfig($KEY_FILE_LOCATION);
3949.                 $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
3951.                 $analytics = new \Google_Service_AnalyticsReporting($client);
3952.                 $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
3953.                 $dateRange->setStartDate($startDate);
3954.                 $dateRange->setEndDate($endDate);
3956.                 $views = new \Google_Service_AnalyticsReporting_Metric();
3957.                 $views->setExpression("ga:pageviews");
3958.                 $views->setAlias("pageviews");
3960.                 $path = new \Google_Service_AnalyticsReporting_Dimension();
3961.                 $path->setName("ga:pagePath");
3963.                 $rcsUserID = new \Google_Service_AnalyticsReporting_Dimension();
3964.                 $rcsUserID->setName("ga:dimension2");
3965.                 
3966.                 $dimensionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
3967.                 
3968.                 $dimensionFilter->setDimensionName('ga:pagePath');
3969.                 $dimensionFilter->setOperator('IN_LIST');
3970.                 $dimensionFilter->setExpressions([$content->getURL(1)]);
3971.                 
3972.                 // Create the DimensionFilterClauses
3973.                 $dimensionFilterClause = new \Google_Service_AnalyticsReporting_DimensionFilterClause();
3974.                 $dimensionFilterClause->setFilters(array($dimensionFilter));
3977.                 $request = new \Google_Service_AnalyticsReporting_ReportRequest();
3978.                 $request->setViewId("126182454"); //< Unfiltered Website Data
3979.                 $request->setDateRanges($dateRange);
3980.                 $request->setDimensions(array($path, $rcsUserID));
3981.                 $request->setDimensionFilterClauses(array($dimensionFilterClause));
3982.                 $request->setMetrics(array($views));
3984.                 $request->setPageSize("10000");
3985.                 //$request->setPageSize("10");
3986.                 
3987.                 $order = new \Google_Service_AnalyticsReporting_OrderBy;
3988.                 $order->setFieldName("ga:pageviews");
3989.                 $order->setOrderType("VALUE");
3990.                 $order->setSortOrder("DESCENDING");
3991.                 $orders[] = $order;
3992.                 $request->setOrderBys($orders);
3994.                 $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
3995.                 $body->setReportRequests(array($request));
3996.                 $reports = $analytics->reports->batchGet($body);
3997.                 
3998.                 
3999.                 $dataweek = [];
4000.                 for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
4001.                     $report = $reports[$reportIndex];
4002.                     $header = $report->getColumnHeader();
4003.                     $dimensionHeaders = $header->getDimensions();
4004.                     $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
4005.                     $rows = $report->getData()->getRows();
4007.                     for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
4008.                         $row = $rows[$rowIndex];
4009.                         $dimensions = $row->getDimensions();
4010.                         $metrics = $row->getMetrics();
4012.                         $path = "";
4013.                         $rcsUserID = "";
4014.                         $count = 0;
4016.                         for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
4017.                             
4018.                             if ($dimensionHeaders[$i] == "ga:pagePath") {
4019.                                 $path = $dimensions[$i];
4020.                             }
4022.                             if ($dimensionHeaders[$i] == "ga:dimension2") {
4023.                                 $rcsUserID = $dimensions[$i];
4024.                             }
4026.                         }
4028.                         $count = $metrics[0]->getValues()[0];
4029.                         
4030.                         if (!isset($dataweek[$rcsUserID])) {
4031.                             $user = $entityManager
4032.                                 ->getRepository(User::class)
4033.                                 ->findOneBy(["id" => $rcsUserID]);
4034.                             $dataweek[$rcsUserID] = ["views" => $count, "user" => $user];
4035.                         }
4037.                     }
4038.                 }
4048.                 
4049.                 $tmpl = $twig->load("sonata_admin/content-user-views-embed.html.twig");
4050.                 $html = $tmpl->render(
4051.                 [
4052.                     "content" => $content,
4053.                     "data" => $data,
4054.                     "dataweek" => $dataweek,
4055.                     //"rows" => $rows,
4056.                 ]);
4057.                 
4058.                 return new JsonResponse($html);
4059.             }
4060.             catch (\Exception $e) {
4061.                 //return new JsonResponse("<div>Error loading results.</div>");
4062.                 return new JsonResponse($e->getMessage());
4063.             }
4064.             
4065.         }
4067.         /**
4068.         * @Route("/ajax/accept-cookies")
4069.         */
4070.         public function acceptCookiesAjaxAction(
4071.             Request $request
4072.         ) {
4073.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
4074.                 $user = $this->user;
4075.                 if($user) {
4076.                     $user->setUsermetum("acceptCookies", "1");
4077.                     $entityManager = $this->getDoctrine()->getManager();
4078.                     $entityManager->persist($user);
4079.                     $entityManager->flush();
4080.                     return new JsonResponse("1");
4081.                 }
4082.             }
4083.             return new JsonResponse("0");
4084.         }
4085.         
4086.         /**
4087.         * @Route("/ajax/set-preferred-language")
4088.         */
4089.         public function preferredLanguageAjaxAction(
4090.             Request $request
4091.         ) {
4092.             
4093.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
4094.                 $user = $this->user;
4095.                 $language = $request->get("language");
4096.                 if($user && $language) {
4097.                     $contact = $user->getContact();
4098.                     if($contact) {
4099.                         $contact->setPreferredLanguage($language);
4100.                         $entityManager = $this->getDoctrine()->getManager();
4101.                         $entityManager->persist($contact);
4102.                         $entityManager->flush();
4103.                         return new JsonResponse("1");
4104.                     }
4105.                 }
4106.             }
4107.             return new JsonResponse("0");
4108.             
4109.         }
4112.         /**
4113.         * @Route("/ajax/submit-comment")
4114.         */
4115.         public function submitCommentAjaxAction(
4116.             Request $request,
4117.             MediaHelper $mediaHelper,
4118.             ContentHelper $contentHelper,
4119.             EmailHelper $emailHelper
4120.         ) {
4122.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
4123.                 
4124.                 if ($request->get("commentText") && $request->get("contentId")) {
4125.                     $contentId = $request->get("contentId");
4126.                     $content = $contentHelper->getContentById($contentId);
4127.                     $comment = new Comment();
4128.                     $comment->setContent($content);
4129.                     
4130.                     $comment->setApproved(0);
4131.                     $comment->setAuthorIP($_SERVER['REMOTE_ADDR']);
4132.                     $comment->setAgent($_SERVER['HTTP_USER_AGENT']);
4133.                     $comment->setCommentText($request->get("commentText"));
4134.                     
4135.                     if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
4136.                         $user = $this->getUser();
4138.                         if($user->getRole() == 8) {
4139.                             $comment->setApproved(1);
4140.                         }
4142.                         $comment->setUser($user);
4143.                         $comment->setAuthor($user->getDisplayname());
4144.                         $comment->setAuthorEmail($user->getEmail());
4145.                         $comment->setApproved(1);
4146.                     }
4147.                     else {
4148.                         return false;
4149.                         //No longer allowing comments from non-logged in users
4150.                         //$comment->setAuthor($request->request->get("author"));
4151.                         //$comment->setAuthorEmail($request->request->get("email"));
4152.                         //$comment->setAuthorUrl($request->request->get("url"));
4153.                     }
4154.                     
4155.                     $entityManager = $this->getDoctrine()->getManager();
4156.                     $entityManager->persist($comment);
4157.                     $entityManager->flush();
4158.                     
4159.                     $contentType = strtolower($content->getTypeText());
4160.                     
4161.                     $emailHelper->sendEmail(
4162.                         ["rcs@rooferscoffeeshop.com"],
4163.                         "New Comment Added - {$content->getTitle()}",
4164.                         [
4165.                             ["p" => "A new comment has been added to the {$contentType} \"{$content->getTitle()}\"."],
4166.                             ["p" => "User \"{$comment->getAuthor()}\" commented: \"{$comment->getCommentText()}\"."],
4167.                             ["button" => [
4168.                                 "text" => "View Content",
4169.                                 "href" => "{$content->getFullURL($this->site_code)}",
4170.                             ]],
4171.                         ]
4172.                     );
4173.                     
4174.                     return new JsonResponse(1);
4175.                 }
4176.             }
4177.         }
4179.         // @Route("/testtesttest", methods={"POST"})
4180.         
4181.         /**
4182.         * @Route("/testtesttesths")
4183.         */
4184.         public function testtesttesths(
4185.             Request $request,
4186.             ContentHelper $contentHelper,
4187.             CustomerHelper $customerHelper,
4188.             HootsuiteHelper $hootsuiteHelper
4189.         ) {    
4190.             // get image from post request
4191.             // $image = $request->files->get("image");
4193.             // $imgObj = [
4194.             //     "image" => $image->getPathname(),
4195.             //     "mime" => $image->getMimeType(),
4196.             //     "size" => $image->getSize(),
4197.             // ];
4199.             // $respUploadCreate = $hootsuiteHelper->createMediaUploadUri($imgObj);
4200.             // $respUploadCreate = json_decode($respUploadCreate, true);
4201.             // $respUploadCreate = $respUploadCreate['data'];
4202.             // $respUpload = $hootsuiteHelper->uploadMedia($respUploadCreate['uploadUrl'], $imgObj);
4203.             // sleep(5); // waiting to be sure that it's ready
4204.             // $uploaded = $hootsuiteHelper->confirmMediaUpload($respUploadCreate['id']);
4208.             // $resp = [
4209.             //     "uploadCreate" => $respUploadCreate,
4210.             //     "upload" => $uploaded,
4211.             // ];
4214.             //$resp = $hootsuiteHelper->schedulePost("Test post from RCS \n\n\n@AskARooferRCS ", [$respUploadCreate['id']], [125189773], "2025-01-01T12:12:00Z");
4215.             //$resp = $hootsuiteHelper->schedulePost("Test post from RCS \n\n\n@AskARooferRCS ", [], [125189773, 7563642], "2025-01-01T12:12:00Z");
4217.             return $this->defaultRender("test.html.twig", [
4218.                 //"data" => json_decode($resp)
4219.                 "data" => date('Y-m-d H:i:s')
4220.                 //"data" => date_default_timezone_get()
4221.             ]);
4222.         
4223.             
4227.             // $code = "q_muwsc8MGw2zqzDnrn37pj4GcVWYrXCVU5o9fsPr0E.ck04oiLoHqmDPSI5TD0va63-qFf_PYa4WJcZmRpwWK4";
4228.             // $resp = $hootsuiteHelper->getMessage(12882399827);
4230.             // schedulePost
4231.             // $resp = $hootsuiteHelper->getSocialProfiles();
4232.             //$hootsuiteHelper->updateSocialProfiles();
4233.             // return new JsonResponse(json_encode(print_r($resp)), 200, [], true);
4234.             // return new JsonResponse($tokens);
4235.             //return new JsonResponse("testtestteset");
4236.             
4237.         }
4251.         /**
4252.         * @Route("/testtesttestga")
4253.         */
4254.         public function testtesttestga(
4255.             Request $request,
4256.             ContentHelper $contentHelper,
4257.             CustomerHelper $customerHelper
4258.         ) {
4259.             return false;
4261.             //try {
4262.             
4263.                 set_time_limit(600);
4264.                 
4265.                 /*
4266.                 $slug = $request->get("slug");
4267.                 if(!$slug) {
4268.                     throw new \Exception('Invalid directory.');
4269.                 }
4270.                 */
4271.                 
4272.                 if($request->request->has("date_start") && $request->request->has("date_end")
4273.                     && $request->request->get("date_start") && $request->request->get("date_end")) {
4274.                     $startDate = date("Y-m-d", strtotime($request->request->get("date_start")));
4275.                     $startDate = new \DateTime($startDate);
4276.                     
4277.                     $endDate = date("Y-m-d", strtotime($request->request->get("date_end")));
4278.                     $endDate = new \DateTime($endDate." 23:59:59");
4279.                 }
4280.                 elseif($request->request->has("date_start_current") && $request->request->has("date_end_current")
4281.                     && $request->request->get("date_start_current") && $request->request->get("date_end_current")) {
4282.                     $startDate = date("Y-m-d", strtotime($request->request->get("date_start_current")));
4283.                     $startDate = new \DateTime($startDate);
4284.                     
4285.                     $endDate = date("Y-m-d", strtotime($request->request->get("date_end_current")));
4286.                     $endDate = new \DateTime($endDate." 23:59:59");
4287.                 }
4288.                 else {
4289.                     $year = date("Y");
4290.                     $month = date("n");
4291.                     
4292.                     $startDate = date("Y-m-d", strtotime($year."-".$month."-"."01"));
4293.                     $startDate = new \DateTime($startDate);
4294.                     $endDate = date("Y-m-t", strtotime($year."-".$month."-"."01"));
4295.                     $endDate = new \DateTime($endDate." 23:59:59");
4296.                 }
4297.                 
4298.                 
4299.                 $data =[];
4300.                 foreach(SiteConfig::CONFIGS as $site_config) {
4301.                     
4302.                     if($site_config["id"] != 1/*!isset($site_config["ga_view_id"])*/) {
4303.                         continue;
4304.                     }
4305.     
4306.                     // 3/14/2019 removing source...
4307.                     $client = new \Google_Client();
4308.                     $client->setApplicationName("RCS Analytic Reports");
4309.                     //$KEY_FILE_LOCATION = __DIR__ . '/My Project-4e8eeee2693a.json';
4310.                     $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
4311.                     //$KEY_FILE_LOCATION = __DIR__ . '/' . $site_config["analytics_key_file"];
4312.                     $client->setAuthConfig($KEY_FILE_LOCATION);
4313.                     $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
4314.     
4315.                     $analytics = new \Google_Service_AnalyticsReporting($client);
4316.                     $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
4317.                     $dateRange->setStartDate($startDate->format('Y-m-d'));
4318.                     $dateRange->setEndDate($endDate->format('Y-m-d'));
4319.     
4320.                     $avgTimeOnPage = new \Google_Service_AnalyticsReporting_Metric();
4321.                     $avgTimeOnPage->setExpression("ga:avgTimeOnPage");
4322.                     $avgTimeOnPage->setAlias("avgTimeOnPage");
4323.     
4324.                     $path = new \Google_Service_AnalyticsReporting_Dimension();
4325.                     $path->setName("ga:pagePath");
4326.     
4327.                     //$medium = new \Google_Service_AnalyticsReporting_Dimension();
4328.                     //$medium->setName("ga:medium");
4329.     
4330.     
4331.                     $request = new \Google_Service_AnalyticsReporting_ReportRequest();
4332.                     //$request->setViewId("126182454"); //< Unfiltered Website Data
4333.                     $request->setViewId($site_config["ga_view_id"]); //< Unfiltered Website Data
4334.                     $request->setDateRanges($dateRange);
4335.                     $request->setDimensions(array($path));
4336.                     //$request->setDimensions(array($path, $medium));
4337.                     $request->setMetrics(array($avgTimeOnPage));
4338.     
4339.                     $request->setPageSize("10000");
4340.     
4341.                     $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
4342.                     $body->setReportRequests(array($request));
4343.                     $reports = $analytics->reports->batchGet($body);
4344.                     
4345.     
4346.     
4347.                     /*
4348.                     //If we ever have more than 10,000 results, we'll need to filter them or do something like this
4349.     
4350.                     // Remove count if you really want everything.
4351.                     $cnt = 0;
4352.                     while ($reports->reports[0]->nextPageToken > 0 && $cnt < 10) {
4353.                         $body->reportRequests[0]->setPageToken($reports->reports[0]->nextPageToken);
4354.                         $reports = $analytics->reports->batchGet( $body );
4355.                         $cnt++;
4356.                     }
4357.                     */
4358.     
4359.                     
4360.                     // 3/13/2019 removing source
4361.                     $data[$site_config['id']] = [];
4362.     
4363.                     for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
4364.                         $report = $reports[$reportIndex];
4365.                         $header = $report->getColumnHeader();
4366.                         $dimensionHeaders = $header->getDimensions();
4367.                         $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
4368.                         $rows = $report->getData()->getRows();
4369.     
4370.                         for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
4371.                             $row = $rows[$rowIndex];
4372.                             $dimensions = $row->getDimensions();
4373.                             $metrics = $row->getMetrics();
4374.     
4375.                             $path = "";
4376.                             //$medium = "";
4377.                             $count = 0;
4378.     
4379.                             for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
4380.     
4381.                                 if ($dimensionHeaders[$i] == "ga:pagePath") {
4382.                                     $path = $dimensions[$i];
4383.                                 }
4384.     
4385.                                 /*if ($dimensionHeaders[$i] == "ga:medium") {
4386.                                     $medium = $dimensions[$i];
4387.                                 }*/
4388.     
4389.                             }
4390.     
4391.                             //strip any url parameters
4392.                             $path = strtok($path, "?");
4393.     
4394.                             for ($j = 0; $j < count($metricHeaders) && $j < count($metrics); $j++) {
4395.                                 $entry = $metricHeaders[$j];
4396.                                 $values = $metrics[$j];
4397.     
4398.                                 for ($valueIndex = 0; $valueIndex < count($values->getValues()); $valueIndex++) {
4399.                                     $value = $values->getValues()[$valueIndex];
4400.                                     //$count = $value;
4401.                                 }
4402.                             }
4403.     
4404.                             if (!isset($data[$site_config['id']][$path])) {
4405.                                 $data[$site_config['id']][$path] = (int)$value;
4406.                             }
4407.                             /*if (!isset($data[$path]["avgTimeOnPage"])) {
4408.                                 $data[$path]["avgTimeOnPage"] = $value;
4409.                             }*/
4410.                             /*if (!isset($data[$path][$medium])) {
4411.                                 $data[$path][$medium] = (int)$count;
4412.                             }
4413.                             else {
4414.                                 $data[$path][$medium] += (int)$count;
4415.                             }*/
4416.     
4417.                         }
4418.                     }
4419.                     $data[$site_config['id']] = $reports;
4420.                     //echo "<pre>";var_dump($data);exit;
4421.                 }
4422.             //}
4428.             return $this->defaultRender("test.html.twig", [
4429.                 "data" => $data
4430.             ]);
4432.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
4434.         }
4437.         /**
4438.         * @Route("/testtesttestga2")
4439.         */
4440.         public function testtesttestga2(
4441.             Request $request,
4442.             ContentHelper $contentHelper,
4443.             CustomerHelper $customerHelper
4444.         ) {
4445.             return false;
4447.             /**
4448.              * TODO(developer): Replace this variable with your Google Analytics 4
4449.              *   property ID before running the sample.
4450.              */
4451.             //$property_id = 'YOUR-GA4-PROPERTY-ID';
4452.             $property_id = '320922983';
4453.             
4454.             // Using a default constructor instructs the client to use the credentials
4455.             // specified in GOOGLE_APPLICATION_CREDENTIALS environment variable.
4456.             //$client = new BetaAnalyticsDataClient();
4457.             $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS Analytics-70262098a89a.json';
4458.             $client = new BetaAnalyticsDataClient([
4459.                 'credentials' => $KEY_FILE_LOCATION
4460.             ]);
4461.             
4462.             // Make an API call.
4463.             $request = (new RunReportRequest())
4464.                 ->setProperty('properties/' . $property_id)
4465.                 ->setDateRanges([
4466.                     new DateRange([
4467.                         'start_date' => '2024-03-31',
4468.                         'end_date' => 'today',
4469.                     ]),
4470.                 ])
4471.                 ->setDimensions([new Dimension([
4472.                         'name' => 'city',
4473.                     ]),
4474.                 ])
4475.                 ->setMetrics([new Metric([
4476.                         'name' => 'activeUsers',
4477.                     ])
4478.                 ]);
4479.             $response = $client->runReport($request);
4480.             
4481.             // Print results of an API call.
4482.             
4483.             $print =  'Report result: ' . PHP_EOL;
4484.             
4485.             foreach ($response->getRows() as $row) {
4486.                 $print .= $row->getDimensionValues()[0]->getValue()
4487.                     . ' ' . $row->getMetricValues()[0]->getValue() . PHP_EOL;
4488.             }
4489.             
4490.             
4493.             
4495.             $data = [];
4496.             return $this->defaultRender("test.html.twig", [
4497.                 //"data" => $data
4498.                 //"data" => $response
4499.                 "data" => $print
4500.             ]);
4502.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
4504.         }
4507.         /**
4508.         * @Route("/testtimeonpage")
4509.         */
4510.         public function testtimeonpage(
4511.             Request $request,
4512.             ContentHelper $contentHelper,
4513.             CustomerHelper $customerHelper
4514.         ) {
4515.             return false;
4516.             $property_id = '320922983';
4517.             $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS Analytics-70262098a89a.json';
4518.             $client = new BetaAnalyticsDataClient([
4519.                 'credentials' => $KEY_FILE_LOCATION
4520.             ]);
4521.             
4522.             // Make an API call.
4523.             $request = (new RunReportRequest())
4524.                 ->setProperty('properties/' . $property_id)
4525.                 ->setDateRanges([
4526.                     new DateRange([
4527.                         'start_date' => '2024-04-01',
4528.                         'end_date' => '2024-04-30',
4529.                     ]),
4530.                 ])
4531.                 ->setDimensions([new Dimension([
4532.                         'name' => 'pagePath',
4533.                     ]),
4534.                 ])
4535.                 ->setMetrics([
4536.                     new Metric(['name' => 'userEngagementDuration']),
4537.                     new Metric(['name' => 'activeUsers'])
4538.                 ]);
4539.             $response = $client->runReport($request);
4540.             
4541.             // Print results of an API call.
4542.                 
4543.             $print =  'Report result: ' . PHP_EOL;
4544.         
4545.             foreach ($response->getRows() as $row) {
4546.                 $print .= $row->getDimensionValues()[0]->getValue()
4547.                     //. ' ' . $row->getMetricValues()[0]->getValue() . PHP_EOL;
4548.                     . ' ' . $row->getMetricValues()[0]->getValue()
4549.                     . ' ' . $row->getMetricValues()[1]->getValue() . PHP_EOL;
4550.             }
4551.             
4552.             //$print = \Doctrine\Common\Util\Debug::dump($response, 4);
4556.             
4558.             $data = [];
4559.             return $this->defaultRender("test.html.twig", [
4560.                 //"data" => $data
4561.                 //"data" => $response
4562.                 "data" => $print
4563.             ]);
4565.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
4567.         }
4570.         /**
4571.         * @Route("/thecoffeeshops")
4572.         */
4573.         public function thecoffeeshops(
4574.             Request $request
4575.         ) {    
4576.             return false;
4577.             return $this->defaultRender("thecoffeeshops.html.twig", [
4578.                 //"data" => json_decode($resp)
4579.             ]);
4580.         }
4582.     
4583. }