src/Controller/Master/ContentController.php line 1172

Open in your IDE?
  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\Session\SessionInterface;
  13. use Symfony\Component\HttpFoundation\RedirectResponse;
  14. use Symfony\Component\HttpFoundation\File\UploadedFile;
  15. use Symfony\Component\HttpFoundation\JsonResponse;
  16. use Symfony\Component\Cache\Adapter\FilesystemAdapter;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Component\Form\Forms;
  21. use Doctrine\Common\Collections\Criteria;
  23. use App\Form\Type\ContentType;
  24. use App\Form\Type\ContentAdminType;
  25. use App\Form\Type\CommentType;
  27. use App\Entity\Content;
  28. use App\Entity\Site;
  29. use App\Entity\SiteConfig;
  30. use App\Entity\ContentMeta;
  31. use App\Entity\Comment;
  32. use App\Entity\Category;
  33. use App\Entity\Customer;
  34. use App\Entity\CustomerPhone;
  35. use App\Entity\CustomerAddress;
  36. use App\Entity\Lead;
  37. use App\Entity\User;
  38. use App\Entity\Coupon;
  39. use App\Entity\Product;
  40. use App\Entity\Purchase;
  41. use App\Entity\PurchaseItem;
  42. use App\Entity\PurchaseNote;
  43. use App\Entity\Media;
  44. use App\Entity\MediaGroupItem;
  45. use App\Entity\MediaGroup;
  46. use App\Entity\MediaGroupContainer;
  47. use App\Entity\Contact;
  48. use App\Entity\ContentAnalyticsDaily;
  49. use App\Entity\QuizQuestion;
  51. use App\Form\Type\CustomerType;
  52. use App\Form\Type\LeadType;
  53. use App\Form\DirectoryLeadType;
  55. use App\Utils\CategoryHelper;
  56. use App\Utils\ContentHelper;
  57. use App\Utils\CustomerHelper;
  58. use App\Utils\ContactHelper;
  59. use App\Utils\UserHelper;
  60. use App\Utils\EmailHelper;
  61. use App\Utils\OrderHelper;
  62. use App\Utils\MediaHelper;
  63. use App\Utils\MenuHelper;
  64. use App\Utils\LeadHelper;
  65. use App\Utils\PollHelper;
  66. use App\Utils\QuizHelper;
  67. use App\Utils\MailChimpHelper;
  69. use App\Utils\HootsuiteHelper;
  71. use Vich\UploaderBundle\Storage\StorageInterface;
  72. use Vich\UploaderBundle\Mapping\PropertyMapping;
  74. use \Swift_Mailer as Swift_Mailer;
  75. use \Swift_Message as Swift_Message;
  77. use Symfony\Component\DependencyInjection\ContainerInterface as Container;
  79. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  80. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  83. use Google\Analytics\Data\V1beta\Client\BetaAnalyticsDataClient;
  84. use Google\Analytics\Data\V1beta\DateRange;
  85. use Google\Analytics\Data\V1beta\Dimension;
  86. use Google\Analytics\Data\V1beta\Metric;
  87. use Google\Analytics\Data\V1beta\RunReportRequest;
  90. use Twig\Environment;
  92. //TODO: Clean up uses in all controllers
  94. class ContentController extends DefaultController
  95. {
  96.     /**
  97.     * @Route("/uptime")
  98.     */
  99.     public function uptime(
  100.         Request $request
  101.     ) {
  102.         $stmt = $this->getDoctrine()->getManager()->getConnection()->query("SELECT 1 + 1 as res");
  103.         $res = $stmt->fetch();
  104.         return new JsonResponse($res["res"], 200, [], true);
  105.     }
  107.     /**
  108.     * @Route("/content-queue-test")
  109.     */
  110.     public function contentQueueTest(
  111.         Request $request,
  112.         ContentHelper $contentHelper
  113.     ) {
  114.         $session = $request->getSession();
  115.         $content_ids = $session->get("queued_content_ids", []);
  116.         return new JsonResponse(implode(", ", $content_ids), 200, [], true);
  117.     }
  119.     /**
  120.     * @Route("/content-queue-clear")
  121.     */
  122.     public function contentQueueClear(
  123.         Request $request,
  124.         ContentHelper $contentHelper
  125.     ) {
  126.         $session = $request->getSession();
  127.         $session->remove("queued_content_ids");
  128.         return new JsonResponse("OK", 200, [], true);
  129.     }
  130.     
  131.     
  132.     //TODO: RCS only?
  133.     public function contentMembersOnlyCheck($content) {
  134.         if($content->getMembersOnly() && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
  135.             $this->addFlash("warning", "This page is only accessible to RCS Club members. Continue below to become a member and access this page.");
  136.             return $this->redirectToRoute("rcs-club-sign-up");
  137.         }
  138.     }
  139.     
  140.     //TODO: Why are these needed for admin edit routes?
  141.     //      & move this to a different controller
  142.     /**
  143.      * @Route("/ckeditor_upload", name="ckeditor_upload")
  144.      */
  145.     public function ckeditor_upload (
  146.         Request $request
  147.     ) {
  148.         
  149.     }
  150.     
  151.     /**
  152.      * @Route("/ckeditor_browse", name="ckeditor_browse")
  153.      */
  154.     public function ckeditor_browse (
  155.         Request $request
  156.     ) {
  157.         return $this->defaultRender("easy_admin/file-browse.html.twig", [
  158.         
  159.         ]);
  160.     }
  162.     // displays the meet the rcs influencers page
  163.     // requires a content object to be passed as $content
  164.     public function meetinfluencers(
  165.         Request $request,
  166.         ContentHelper $helper,
  167.         CustomerHelper $customerHelper,
  168.         $content = ""
  169.     ) {
  170.         $cat_id = 479;
  171.         if($this->site_code == 3) {//SiteConfig::SITE_MCS
  172.             $cat_id = 1346;
  173.         }
  174.         if($this->site_code == 4) { //SiteConfig::SITE_CCS
  175.             $cat_id = 1445;
  176.         }
  177.         $customers = $customerHelper->getCustomersByCategory($cat_id, $this->site_code);
  178.         return $this->defaultRender("content/tmpl/meet-rcs-influencers.html.twig", [
  179.             "content" => $content,
  180.             "customers" => $customers,
  181.         ]);
  182.     }
  184.     // displays the podcasts list page
  185.     public function podcasts(
  186.         Request $request,
  187.         ContentHelper $helper,
  188.         MediaHelper $mediaHelper,
  189.         $content = ""
  190.     ) {
  191.         $podcasts = $helper->getContent(Content::PODCAST, $content->getSlug(), "published", "desc", 0, 0, true, "*", true)["content"];
  193.         $images = [];
  194.         foreach($podcasts as $c) {
  195.             $cm = $c->getContentMetaByKey("podcast_image");
  196.             if(is_null($cm) || $cm->getMetavalue() == 0) {
  197.                 $images[] = "";
  198.             }
  199.             else {
  200.                 $m = $mediaHelper->getMediaByOldId($cm->getMetavalue());
  201.                 $images[] = $m;
  202.             }
  203.         }
  205.         return $this->defaultRender("content/tmpl/podcasts.html.twig", [
  206.             "content" => $content,
  207.             "podcasts" => $podcasts,
  208.             "images" => $images,
  209.             "meta" => ["adGroup" => "rlw"],
  210.         ]);
  211.     }
  212.     
  213.     /**
  214.      * @Route("/post/{slug}", name="post_master")
  215.      */
  216.     public function post(
  217.         Request $request,
  218.         ContentHelper $contentHelper,
  219.         $slug = ""
  220.     ) {
  222.         /*if($this->site_code == Content::SITE_CCS && (!$this->user || (!$this->user->isMember() && !$this->user->isAdmin()))) {
  223.             return $this->redirectToRoute("sign-in_ccs");
  224.         }*/
  226.         $post = $contentHelper->getPostBySlug($slug);
  227.         
  228.         $recommendPost = $contentHelper->getRecommendedPosts($post->getCategory() ? $post->getCategory() : (!empty($post->getSecondaryCategories()) ? $post->getSecondaryCategories()[0] : null), 3, $post->getId());
  230.         return $this->contentMembersOnlyCheck($post) ??
  231.         $this->defaultRender("content/content.html.twig", [
  232.             "content" => $post,
  233.             "meta" => [
  234.                 "title" => $post->getTitle(),
  235.                 "recommended" => $recommendPost,
  236.             ],
  237.         ]);
  238.     }
  239.     
  240.     /**
  241.      * @Route("/gallery/{slug}",name="gallery_master")
  242.      */
  243.     public function gallery (
  244.         Request $request,
  245.         ContentHelper $helper,
  246.         $slug
  247.     ) {
  248.         $gallery = $helper->getContentBySlug(Content::GALLERY, $slug);
  249.         
  250.         //TODO: Should we have site specific code here? or override in RCS controller?
  251.         $breadcrumbs = [];
  252.         if($this->site_code == Content::SITE_RCS) {
  253.             $bread_title = "Roofing Galleries";
  254.             $bread_href = "/roofing-galleries";
  255.             $category = $gallery->getCategory();
  256.             if($category && $category->getSlug() == "partner-galleries") {
  257.                 $bread_title = "Partner Galleries";
  258.                 $bread_href = "/partner-galleries";
  259.             }
  260.             $breadcrumbs[] = [
  261.                 "title" => $bread_title,
  262.                 "href" => $bread_href,
  263.             ];
  264.         }
  265.         
  266.         $breadcrumbs[] = [
  267.             "title" => $gallery->getTitle(),
  268.             "href" => "/partner-galleries/{$gallery->getSlug()}",
  269.         ];
  271.         return $this->defaultRender("content/content.html.twig", [
  272.             "content" => $gallery,
  273.             "pagenum" => 1,
  275.             "meta" => [
  276.                 "title" => $gallery->getTitle(),
  277.                 "breadcrumbs" => $breadcrumbs
  278.             ]
  279.         ]);
  280.     }
  281.     
  282.     /**
  283.      * @Route("/podcast/{slug}", name="podcast_master")
  284.      */
  285.     public function podcast (
  286.         Request $request,
  287.         ContentHelper $helper,
  288.         $slug = ""
  289.     ) {
  291.         $podcast = $helper->getContentBySlug(Content::PODCAST, $slug);
  292.         
  293.         $primaryCategory = $podcast->getCategory();
  294.         $categories = $podcast->getSecondaryCategories();
  295.         
  296.         $breadcrumbs = [];
  297.         
  298.         $parent_breadcrumb = "";
  299.         if($primaryCategory && $primaryCategory->getSlug() == "partner-podcast") {
  300.             $breadcrumbs[] = [
  301.                 "title" => "Partner Podcasts",
  302.                 "href" => "/partner-podcast",
  303.             ];
  304.         }
  305.         else {
  306.             $breadcrumbs[] = [
  307.                 "title" => "Podcasts",
  308.                 "href" => "/podcasts",
  309.             ];
  310.         }
  311.         
  312.         foreach($categories as $category) {
  313.             if($category->getTaxonomy() == "rcs-podcast-type") {
  314.                 $parent_breadcrumb = [
  315.                     "title" => $category->getTitle(),
  316.                     "href" => "/podcasts/{$category->getSlug()}",
  317.                 ];
  318.             }
  319.         }
  320.         
  321.         if($parent_breadcrumb) {
  322.             $breadcrumbs[] = $parent_breadcrumb;
  323.         }
  324.         $breadcrumbs[] = [
  325.             "title" => $podcast->getTitle(),
  326.             "href" => "/podcast/{$podcast->getSlug()}",
  327.         ];
  328.         
  329.         return $this->defaultRender("content/content.html.twig", [
  330.             "content" => $podcast,
  331.             "pagenum" => 1, //< is this needed?
  333.             "meta" => array (
  334.                 "title" => $podcast->getTitle(),
  335.                 "breadcrumbs" => $breadcrumbs
  336.             )
  337.         ]);
  339.     }
  340.     
  341.     /**
  342.      * @Route("/webinar/{slug}", name="webinar_master")
  343.      */
  344.     public function webinar (
  345.         Request $request,
  346.         ContentHelper $helper,
  347.         $slug = ""
  348.     ) {
  349.         $webinar = $helper->getContentBySlug(Content::WEBINAR, $slug);
  350.         
  351.         return $this->contentMembersOnlyCheck($webinar) ??
  352.         $this->defaultRender("content/content.html.twig", [
  353.             "content" => $webinar,
  354.             "pagenum" => 1,
  355.             "meta" => [
  356.                 "title" => $webinar->getTitle(),
  357.         "adgroup" => "rlw"
  358.             ],
  359.         ]);
  360.     }
  361.     
  362.     /**
  363.      * @Route("/promos-rebates/{slug}", name="promos_master")
  364.      */
  365.     public function promos (
  366.         Request $request,
  367.         ContentHelper $contentHelper,
  368.         $slug
  369.     ) {
  370.         $promo = $contentHelper->getContentBySlug(Content::PROMOS_REBATES, $slug);
  371.         return $this->defaultRender("content/content.html.twig", [
  372.             "content" => $promo,
  373.             "pagenum" => "",
  375.             "meta" => [
  376.                 "title" => $promo->getTitle(),
  377.                 "breadcrumbs" => [
  378.                     [
  379.                         "title" => "Promos &amp; Rebates", //TODO: rework breadcrumbs?
  380.                         "href" => "/promos-rebates",
  381.                     ],
  382.                     [
  383.                         "title" => $promo->getTitle(),
  384.                         "href" => "/promo/{$promo->getSlug()}",
  385.                     ],
  386.                 ]
  387.             ]
  388.         ]);
  389.     }
  390.     
  391.     /**
  392.      * @Route("/ebooks/{slug}", name="ebook_master")
  393.      */
  394.     public function ebook (
  395.         Request $request,
  396.         ContentHelper $contentHelper,
  397.         $slug
  398.     ) {
  399.         $ebook = $contentHelper->getContentBySlug(Content::EBOOK, $slug);
  401.         $ebooksHref = "/ebooks";
  402.         if($this->site_code == SiteConfig::SITE_AAR) {
  403.             $ebooksHref = "/ebooks-aar";
  404.         }
  405.         elseif($this->site_code == SiteConfig::SITE_MCS) {
  406.             $ebooksHref = "/ebooks-mcs";
  407.         }
  408.         elseif($this->site_code == SiteConfig::SITE_CCS) {
  409.             $ebooksHref = "/ebooks";
  410.         }
  412.         return $this->defaultRender("content/content.html.twig", [
  413.             "content" => $ebook,
  414.             "pagenum" => 1,
  416.             "meta" => [
  417.                 "title" => $ebook->getTitle(),
  418.                 "breadcrumbs" => [
  419.                     [
  420.                         "title" => "eBooks",
  421.                         "href" => $ebooksHref,
  422.                     ],
  423.                     [
  424.                         "title" => $ebook->getTitle(),
  425.                         "href" => "/ebook/{$ebook->getSlug()}",
  426.                     ],
  427.                 ],
  428.             ]
  429.         ]);
  430.     }
  432.     public function ebooks(
  433.         Request $request,
  434.         ContentHelper $contentHelper,
  435.         CategoryHelper $categoryHelper,
  436.         CustomerHelper $customerHelper,
  437.         $slug,
  438.         $content = "",
  439.         $customer = ""
  440.     ) {
  441.         
  442.         if($slug == "partner-ebooks") {
  443.             $eBooks = $contentHelper->getEbooks($customer);
  444.             $customers = $customerHelper->customerHasEbooks();
  445.             return $this->defaultRender("content/tmpl/ebooks.html.twig",[
  446.                 "slug" => $slug,
  447.                 "content" => $content,
  448.                 "customers" => $customers,
  449.                 "eBooks" => $eBooks,
  450.                 "meta" => [
  451.                     "title" => "Partner eBooks",
  452.                     "breadcrumbs" => [
  453.                         [
  454.                             "title" => "Partner eBooks",
  455.                             "href" => "/partner-ebooks",
  456.                         ]
  457.                     ],
  458.                 ]
  459.             ]);
  460.         }
  461.         else {
  462.             $eBooks = $contentHelper->getEbooks();
  463.             if($this->site_code == SiteConfig::SITE_AAR) {
  464.                 $categories = $categoryHelper->getPopulatedCategoriesByTaxonomy('aar_ebook-category', $this->site_code);
  465.             }
  466.             else {
  467.                 $categories = $categoryHelper->getPopulatedCategoriesByTaxonomy('ebook-category', $this->site_code);
  468.             }
  469.             foreach($categories as $key => $category) {
  470.                 if($category->getSlug() == "ebooks-misfits") {
  471.                     unset($categories[$key]);
  472.                 }
  473.             }
  475.             $ebooksHref = "/ebooks";
  476.             if($this->site_code == SiteConfig::SITE_AAR) {
  477.                 $ebooksHref = "/ebooks-aar";
  478.             }
  479.             elseif($this->site_code == SiteConfig::SITE_MCS) {
  480.                 $ebooksHref = "/ebooks-mcs";
  481.             }
  482.             elseif($this->site_code == SiteConfig::SITE_CCS) {
  483.                 $ebooksHref = "/ebooks-ccs";
  484.             }
  485.             
  486.             return $this->defaultRender("content/tmpl/ebooks.html.twig",[
  487.                 "slug" => $slug,
  488.                 "content" => $content,
  489.                 "categories" => $categories,
  490.                 "eBooks" => $eBooks,
  491.                 "meta" => [
  492.                     "title" => "eBooks",
  493.                     "breadcrumbs" => [
  494.                         [
  495.                             "title" => "eBooks",
  496.                             "href" => $ebooksHref,
  497.                         ]
  498.                     ],
  499.                 ]
  500.             ]);
  501.         }
  502.     }
  503.     
  504.     /**
  505.      * @Route("/contests-and-games/{slug}",
  506.      *      requirements={"slug"="^[a-zA-Z0-9\-]+$"},
  507.      *      name="contests_master"
  508.      * )
  509.      */
  510.     public function contests (
  511.         Request $request,
  512.         ContentHelper $contentHelper,
  513.         $slug
  514.     ) {
  515.         $contest = $contentHelper->getContentBySlug(Content::CONTEST_GAMES, $slug);
  516.         return $this->defaultRender("content/content.html.twig", [
  517.             "content" => $contest,
  518.             "pagenum" => 1,
  520.             "meta" => [
  521.                 "title" => $contest->getTitle(),
  522.                 "breadcrumbs" => [
  523.                     [
  524.                         "title" => "Contests &amp; Games",
  525.                         "href" => "/contests-and-games",
  526.                     ],
  527.                     [
  528.                         "title" => $contest->getTitle(),
  529.                         "href" => "/contests-and-games/{$contest->getSlug()}",
  530.                     ]
  531.                 ]
  532.             ]
  533.         ]);
  536.     }
  537.     
  538.     /**
  539.      * @Route("/award/{slug}", name="award_master")
  540.      */
  541.     public function award (
  542.         Request $request,
  543.         ContentHelper $contentHelper,
  544.         $slug
  545.     ) {
  546.         $award = $contentHelper->getContentBySlug(Content::AWARD, $slug);
  547.         return $this->defaultRender("content/content.html.twig", [
  548.             "content" => $award,
  549.             "pagenum" => "",
  551.             "meta" => array (
  552.                 "title" => $award->getTitle(),
  553.                 "breadcrumbs" => array (
  554.                     array (
  555.                         "title" => "Awards",
  556.                         "href" => "/awards",
  557.                     ),
  558.                     array (
  559.                         "title" => $award->getTitle(),
  560.                         "href" => "/award/{$award->getSlug()}",
  561.                     ),
  562.                 )
  563.             )
  564.         ]);
  565.     }
  566.     
  567.     /**
  568.      * @Route("/scholarship/{slug}", name="scholarship_master")
  569.      */
  570.     public function scholarship (
  571.         Request $request,
  572.         ContentHelper $contentHelper,
  573.         $slug
  574.     ) {
  575.         $scholarship = $contentHelper->getContentBySlug(Content::SCHOLARSHIP, $slug);
  576.         return $this->defaultRender("content/content.html.twig", [
  577.             "content" => $scholarship,
  578.             "pagenum" => "",
  580.             "meta" => array (
  581.                 "title" => $scholarship->getTitle(),
  582.                 "breadcrumbs" => array (
  583.                     array (
  584.                         "title" => "Scholarships",
  585.                         "href" => "/scholarships",
  586.                     ),
  587.                     array (
  588.                         "title" => $scholarship->getTitle(),
  589.                         "href" => "/scholarship/{$scholarship->getSlug()}",
  590.                     ),
  591.                 )
  592.             )
  593.         ]);
  594.     }
  596.     /**
  597.      * @Route("/video/{slug}", name="video_master")
  598.      */
  599.     public function video (
  600.         Request $request,
  601.         ContentHelper $contentHelper,
  602.         $slug
  603.     ) {
  604.         $video = $contentHelper->getContentBySlug(Content::VIDEO, $slug);
  605.         return $this->defaultRender("content/content.html.twig", [
  606.             "content" => $video,
  607.             "pagenum" => "",
  609.             "meta" => array (
  610.                 "title" => $video->getTitle(),
  611.                 "breadcrumbs" => array (
  612.                     array (
  613.                         "title" => "Videos",
  614.                         "href" => "/videos",
  615.                     ),
  616.                     array (
  617.                         "title" => $video->getTitle(),
  618.                         "href" => "/video/{$video->getSlug()}",
  619.                     ),
  620.                 )
  621.             )
  622.         ]);
  623.     }
  625.     /**
  626.      * @Route("/r-club-perk/{slug}", name="r-club-perk_master")
  627.      */
  628.     public function rClubPerk (
  629.         Request $request,
  630.         ContentHelper $contentHelper,
  631.         $slug
  632.     ) {
  633.         $perk = $contentHelper->getContentBySlug(Content::R_CLUB_PERK, $slug);
  634.         return $this->defaultRender("content/content.html.twig", [
  635.             "content" => $perk,
  636.             "pagenum" => "",
  638.             "meta" => array (
  639.                 "title" => $perk->getTitle(),
  640.                 "breadcrumbs" => array (
  641.                     array (
  642.                         "title" => "R-Club Perks",
  643.                         "href" => "/members-only",
  644.                     ),
  645.                     array (
  646.                         "title" => $perk->getTitle(),
  647.                         "href" => "/r-club-perk/{$perk->getSlug()}",
  648.                     ),
  649.                 )
  650.             )
  651.         ]);
  652.     }
  653.     
  654.     
  655.     /**
  656.      * Classified Listing Route
  657.      *
  658.      * @Route(
  659.      *      "/our-listings/{page}/{keywords}/{location}/{category}/{areas}",
  660.      *      defaults={ "page"="_", "keywords"="_", "location"="_", "category"="_", "areas"="_" },
  661.      *      name="classifiedIndex_master",
  662.      *      methods={"GET"}
  663.      * )
  664.      */
  665.     public function classifiedIndex (
  666.         Request $request,
  667.         ContentHelper $contentHelper,
  668.         CategoryHelper $categoryHelper,
  669.         $page = "_",
  670.         $keywords = "_",
  671.         $location = "_",
  672.         $category = "_",
  673.         $areas = "_"
  674.     ) {
  676.         try {
  678.             $pagingSize = 25;
  680.             $group = $request->get("c");
  681.             if ($group) {
  682.                  $group = $categoryHelper->getCategoryBySlug($group);
  683.             }
  685.             $records = $contentHelper->getClassifiedListings($page, $keywords, $location, $category, $areas, $group, $pagingSize);
  686.             if(empty($records["listings"])) {
  687.                 //If no listings are found, try again on the first page. Prevents going past the final page due to pressing multiple buttons at once.
  688.                 $page = 0;
  689.                 $records = $contentHelper->getClassifiedListings($page, $keywords, $location, $category, $areas, $group, $pagingSize);
  690.             }
  691.             $listingCategories = $categoryHelper->getCategoriesByTaxonomy("job_listing_category");
  692.             $listingAreas = $categoryHelper->getCategoriesByTaxonomy("job_listing_type");
  696.             return $this->defaultRender("content/classified-index.html.twig", [
  697.                 "listings" => $records["listings"],
  698.                 "totalListings" => $records["total"],
  699.                 "listingCategories" => $listingCategories,
  700.                 "listingAreas" => $listingAreas,
  702.                 "group" => (($group) ? $group->getSlug() : ""),
  704.                 "page" => $page,
  705.                 "pagingSize" => $pagingSize,
  707.                 "keywords" => $keywords == "_" ? "" : $keywords,
  708.                 "location" => $location == "_" ? "" : $location,
  709.                 "category" => $category == "_" ? "" : $category,
  710.                 "areas" => $areas == "_" ? "" : explode("-", $areas),
  712.                 "meta" => [
  713.                     "title" => "Our Classified Listings",
  714.                     "breadcrumbs" => [
  715.                         [
  716.                             "title" => "Our Classified Listings",
  717.                             "href" => "/our-listings" . (($group) ? "?c={$group->getSlug()}" : ""), // make sure to include any sorting categories
  718.                         ]
  719.                     ]
  720.                 ]
  722.             ]);
  724.         } catch (\Exception $e) {
  725.             throw $e;
  726.         }
  727.     }
  728.     
  729.     /**
  730.      * @Route("/listing/{slug}", name="classified_master")
  731.      */
  732.     public function classified(
  733.         Request $request,
  734.         ContentHelper $helper,
  735.         $slug = ""
  736.     ) {
  737.         $listing = $helper->getClassifiedBySlug($slug);
  738.         $meta_collection = $listing->getContentmeta();
  739.         $content_meta = array();
  741.         foreach($meta_collection as $meta) {
  742.             $content_meta[$meta->getMetakey()] = $meta->getMetavalue();
  743.         }
  745.         $category_collection = $listing->getSecondaryCategories();
  746.         $regions = array();
  748.         foreach($category_collection as $category) {
  749.             if($category->getTaxonomy() == "job_listing_type") {
  750.                 $regions[] = $category->getTitle();
  751.             }
  752.         }
  754.         if(count($regions) > 1) {
  755.             $region = "Multiple";
  756.         }
  757.         elseif(count($regions) == 1) {
  758.             $region = $regions[0];
  759.         }
  760.         else {
  761.             //Should never be empty
  762.             $region = "No Region";
  763.         }
  764.         
  765.         return $this->defaultRender("content/content.html.twig", [
  766.             "content" => $listing,
  767.             "content_meta" => $content_meta,
  768.             "region" => $region,
  769.             "autoplay" => isset($_GET['autoplay']) && $_GET["autoplay"] == 1 ? true : false,
  771.             "meta" => [
  772.                 "title" => "Our Classified Listings",
  773.                 "breadcrumbs" => [
  774.                     [
  775.                         "title" => "Our Classified Listings",
  776.                         "href" => "/our-listings",
  777.                     ],
  779.                     [
  780.                         "title" => $listing->getTitle(),
  781.                         "href" => "/listing/{$listing->getSlug()}"
  782.                     ]
  783.                 ]
  784.             ]
  785.         ]);
  786.     }
  787.     
  788.     /**
  789.     * @Route(name="classified_request_info", methods={"POST"})
  790.     */
  791.     public function classifiedRequestInfo(
  792.         Request $request,
  793.         ContentHelper $contentHelper,
  794.         SessionInterface $session,
  795.         EmailHelper $emailHelper
  796.     ) {
  797.         $referer = $request->headers->get('referer');
  798.         
  799.         if($emailHelper->checkCaptcha($request->get("g-recaptcha-response"))) {
  800.             $l = $request->get("lead");
  802.             $lead = new Lead();
  803.             $lead->setFirstname($request->get('fname'));
  804.             $lead->setLastname($request->get('lname'));
  805.             $lead->setEmail($request->get('email'));
  807.             $lead->setIpAddress($request->getClientIp());
  808.             $lead->setRefUrl($request->headers->get("referer"));
  809.             $lead->setUserAgent($request->headers->get("User-Agent"));
  811.             $ref_url = $request->headers->get("referer");
  812.             if($ref_url) {
  813.                 $slug = strtok(substr($ref_url, strrpos($ref_url, '/') + 1), '?');
  814.                 if($slug) {
  815.                     $content = $contentHelper->getContentBySlugRaw($slug);
  816.                     $lead->setContent($content);
  817.                 }
  818.             }
  820.             $em = $this->getDoctrine()->getManager();
  821.             $em->persist($lead);
  822.             $em->flush();
  824.             $pooled = null;
  825.             if($request->get("contact_email")) {
  826.                 $reply_text = $request->get('fname') ? "Click here to respond to {$request->get('fname')}" : "Click here to reply";
  827.                 $pooled = $emailHelper->sendEmail(trim($request->get("contact_email")), "New submission from Classified Listing Contact Form", [
  828.                     ["p" => "Hello {$request->get('contact_name')},"],
  829.                     ["p" => "{$request->get('fname')} {$request->get('lname')} ({$request->get('email')}) has replied to your \"{$request->get('listing_title')}\" classified listing with the following message:"],
  830.                     ["p" => "{$request->get('message')}"],
  831.                     ["button" => ["href" => "mailto:{$request->get('email')}", "text" => $reply_text]],
  832.                 ], $request->files);
  833.             }
  834.             if ($pooled) {
  836.                 $emailHelper->sendEmail($request->get("email"), "Classified Listing Contact Confirmation", [
  837.                     ["p" => "Thanks for contacting us! We will get in touch with you shortly."],
  838.                 ]);
  841.                 $this->addFlash("success", "Thanks for contacting us! We will get in touch with you shortly.");
  842.                 return new RedirectResponse($referer);
  844.                 /*
  845.                 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.
  846.                 print_r($session->get("last_route"));
  847.                 return $this->redirectToRoute($session->get("last_route")["name"], array_merge($session->get("last_route")["params"], ["message" => ["type" => "success", "text" => "Email sent"]]));
  848.                 */
  849.             }
  850.         }
  851.         else {
  852.             //temp2-5
  853.             //$this->addFlash("danger", "The reCAPTCHA was invalid. Please try again.");
  854.             return new RedirectResponse($referer);
  855.         }
  857.         $session->getFlashBag()->add('danger', 'There was an error sending your request. Please try again later.');
  858.         return new RedirectResponse($referer);
  860.     }
  861.     
  862.     //--Directory Start--
  863.     /**
  864.      * @Route(
  865.      *      "/our-directory/{page}/{category}/{type}/{search}/{location}/{state}",
  866.      *      defaults={"page"="", "category"="", "type"="", "search"="", "location"="", "state"=""},
  867.      *      name="directoryIndex_master",
  868.      *      methods={"GET"}
  869.      * )
  870.      */
  871.     public function directoryIndex (
  872.         Request $request,
  873.         ContentHelper $helper,
  874.         $page = "",
  875.         $category = "",
  876.         $type = "",
  877.         $search = "",
  878.         $location = "",
  879.         $state = ""
  880.     ) {
  883.         $page = (int) $page;
  884.         $records = $helper->getDirectoryListings($page, $category, $type, $search, $location, $state);
  885.         $categories = $helper->getDirectoryCategories();
  886.         $stateOptions = Customer::STATES_PROVINCES;
  888.         $search = ($search == "_") ? "" : $search;
  890.         $breadcrumbs = [
  891.             [
  892.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  893.                 "href" => "/our-directory/",
  894.             ]
  895.         ];
  897.         return $this->defaultRender("content/directory.html.twig", [
  898.             "listings" => $records["listings"],
  899.             "total" => $records["total"],
  900.             "page" => $page,
  901.             "limit" => ContentHelper::DEFAULT_LIMIT,
  902.             "search" => $search,
  903.             "locations" => $location,
  904.             "states" => $state,
  905.             "stateOptions" => $stateOptions,
  906.             "categories" => $categories,
  907.             "category" => $category,
  908.             "filters" => $type,
  909.             "show_filters" => $request->query->get("filter") !== "0",
  911.             "meta" => [
  912.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  913.                 "breadcrumbs" => $breadcrumbs,
  914.             ]
  915.         ]);
  917.     }
  918.     
  919.     
  920.     /**
  921.      * @Route(
  922.      *      "/directory/{slug}",
  923.      *      name="directory_page_master",
  924.      *      methods={"GET"}
  925.      * )
  926.      */
  927.     public function directory(
  928.         Request $request,
  929.         ContentHelper $helper,
  930.         CategoryHelper $categoryHelper,
  931.         $slug = ""
  932.     ) {
  934.         $directory = $helper->getDirectoryBySlug($slug);
  935.         //$customer = $directory->getCustomers()->first();
  936.         $customer = $directory->getDirectory();
  938.         $level = $customer->getCustomerLevelString($this->site_code);
  939.         $types = $customer->getCustomerTypeArray();
  941.         // hide or show areas of template
  943.         /*
  944.         $show_promotions = (
  945.             (in_array(Customer::TYPE_DISTRIBUTORS_STRING, $types) && ($level == "Partner" || $level == "Premium" || $level == "Best" || $level == "Better" || $level == "Good")) ||
  946.             (in_array(Customer::TYPE_PRODUCTS_SERVICES_STRING, $types) && ($level == "Partner" || $level == "Premium" || $level == "Best" || $level == "Better" || $level == "Good")) ||
  947.             (in_array(Customer::TYPE_ASSOCIATIONS_STRING, $types)) ||
  948.             (in_array(Customer::TYPE_RCS_PARTNERS_STRING, $types))
  949.         );
  950.         */
  951.         
  952.         $show_promotions = $level && $level != "Standard";
  954.         // In case we want to break this up more
  955.         $show_photos = $show_promotions;
  956.         $show_videos = $show_promotions;
  957.         $show_education = $show_promotions;
  958.         $show_ebooks = $show_promotions;
  959.         $show_contestgames = $show_promotions;
  960.         $show_awards = $show_promotions;
  961.         $show_scholarships = $show_promotions;
  962.         $show_upcoming = $show_promotions;
  963.         $show_newsletters = $show_promotions;
  964.         $show_coffeeblog = $show_promotions;
  965.         $show_literature = $show_promotions;
  966.         $show_podcasts = $show_promotions;
  967.         $show_webinars = $show_promotions;
  968.         $show_classifieds = $show_promotions;
  969.         $show_buy_online = $show_promotions;
  970.         $show_video = $show_promotions;
  971.         $show_products = $show_promotions;
  972.         
  973.         //Todo: use content helper function to pull these
  974.         //Spanish
  975.         try {
  976.           $spanishCat = $categoryHelper->getCategoryBySlug("en-espanol")->getId();
  977.         }catch(\Exception $e) {
  978.           $spanishCat = null;
  979.         }
  980.         $spanish_content = [];
  981.         
  982.         if($spanishCat) {
  983.           $sql = implode(" ", [
  984.             "SELECT content",
  985.             "FROM",
  986.               "App\Entity\Content content",
  987.             "JOIN ",
  988.               "content.secondary_categories sc",
  989.             "LEFT JOIN ",
  990.               "content.customers c",
  991.             "WHERE",
  992.                 "sc.id = :id and content.status = 1 and c.id = :cid",
  993.             "ORDER BY content.created_at DESC",
  994.           ]);
  995.           
  996.           $entityManager = $this->getDoctrine()->getManager();
  997.           $query = $entityManager->createQuery($sql)
  998.             ->setParameter(":id", $spanishCat)
  999.             ->setParameter( ":cid", $customer->getId())
  1000.             ->setFirstResult(0)
  1001.             ->setMaxResults(4);
  1002.             
  1003.           $spanish_content = $query->getResult();
  1004.         }
  1006.         //International
  1007.         try {
  1008.             $intCat = $categoryHelper->getCategoryBySlug("international")->getId();
  1009.           }catch(\Exception $e) {
  1010.             $intCat = null;
  1011.           }
  1012.           $int_content = [];
  1013.           
  1014.           if($intCat) {
  1015.             $sql = implode(" ", [
  1016.               "SELECT content",
  1017.               "FROM",
  1018.                 "App\Entity\Content content",
  1019.               "JOIN ",
  1020.                 "content.secondary_categories sc",
  1021.               "LEFT JOIN ",
  1022.                 "content.customers c",
  1023.               "WHERE",
  1024.                   "sc.id = :id and content.status = 1 and c.id = :cid",
  1025.               "ORDER BY content.created_at DESC",
  1026.             ]);
  1027.             
  1028.             $entityManager = $this->getDoctrine()->getManager();
  1029.             $query = $entityManager->createQuery($sql)
  1030.               ->setParameter(":id", $intCat)
  1031.               ->setParameter( ":cid", $customer->getId())
  1032.               ->setFirstResult(0)
  1033.               ->setMaxResults(4);
  1034.               
  1035.             $int_content = $query->getResult();
  1036.           }
  1038.           //Canada
  1039.           try {
  1040.             $canadaCat = $categoryHelper->getCategoryBySlug("canada")->getId();
  1041.           }catch(\Exception $e) {
  1042.             $canadaCat = null;
  1043.           }
  1044.           $canada_content = [];
  1045.           
  1046.           if($canadaCat) {
  1047.             $sql = implode(" ", [
  1048.               "SELECT content",
  1049.               "FROM",
  1050.                 "App\Entity\Content content",
  1051.               "JOIN ",
  1052.                 "content.secondary_categories sc",
  1053.               "LEFT JOIN ",
  1054.                 "content.customers c",
  1055.               "WHERE",
  1056.                   "sc.id = :id and content.status = 1 and c.id = :cid",
  1057.               "ORDER BY content.created_at DESC",
  1058.             ]);
  1059.             
  1060.             $entityManager = $this->getDoctrine()->getManager();
  1061.             $query = $entityManager->createQuery($sql)
  1062.               ->setParameter(":id", $canadaCat)
  1063.               ->setParameter( ":cid", $customer->getId())
  1064.               ->setFirstResult(0)
  1065.               ->setMaxResults(4);
  1066.               
  1067.             $canada_content = $query->getResult();
  1068.           }
  1069.         
  1070.         
  1071.         
  1072.         // Whether to hide the footer ad - should this be used?
  1073.         //$hide_ad = $row["level"] != "Standard";
  1074.         
  1075.         
  1076.         $breadcrumbs = [
  1077.             [
  1078.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1079.                 "href" => "/our-directory/",
  1080.             ],
  1081.             [
  1082.                 "title" => $directory->getTitle(),
  1083.                 "href" => "/directory/{$directory->getSlug()}",
  1084.             ]
  1085.         ];
  1086.         return $this->defaultRender("content/content.html.twig", [
  1087.             "content" => $directory,
  1088.             "customer" => $customer,
  1089.             "show_promotions" => $show_promotions,
  1090.             "show_photos" => $show_photos,
  1091.             "show_videos" => $show_videos,
  1092.             "show_education" => $show_education,
  1093.             "show_ebooks" => $show_ebooks,
  1094.             "show_contestgames" => $show_contestgames,
  1095.             "show_awards" => $show_awards,
  1096.             "show_scholarships" => $show_scholarships,
  1097.             "show_upcoming" => $show_upcoming,
  1098.             "show_newsletters" => $show_newsletters,
  1099.             "show_coffeeblog" => $show_coffeeblog,
  1100.             "show_literature" => $show_literature,
  1101.             "show_podcasts" => $show_podcasts,
  1102.             "show_webinars" => $show_webinars,
  1103.             "show_classifieds" => $show_classifieds,
  1104.             "show_buy_online" => $show_buy_online,
  1105.             "show_products" => $show_products,
  1106.             "show_video" => $show_video,
  1107.             "buy_online_posts" => $helper->getPaginatedContentByType(Content::POST, 4, 1, "", $customer, "buy-online", false),
  1108.             "video_posts" => $helper->getPaginatedContentByType(Content::POST, 3, 1, "", $customer, "partner-videos", false),
  1109.             "latest_news" => $helper->getPaginatedContentByType(Content::POST, 3, 1, "", $customer, "newsroom", false),
  1110.             "upcoming_events" => $helper->getPaginatedContentByType(Content::EVENT, 3, 1, "", $customer, "", false),
  1111.             "lunch_and_learn" => $helper->getPaginatedContentByType(Content::WEBINAR, 3, 1, "", $customer, "on-demand-lunch-learn", false),
  1112.             "webinars" => $helper->getPaginatedContentByType(Content::WEBINAR, 3, 1, "", $customer, "", false, "on-demand-lunch-learn"),
  1113.             "spanish_content" => $spanish_content,
  1114.             "int_content" => $int_content,
  1115.             "canada_content" => $canada_content,
  1116.             "email_is_valid" => filter_var($customer->getEmail(), FILTER_VALIDATE_EMAIL),
  1117.             "meta" => [
  1118.                 "title" => $directory->getTitle(),
  1119.                 "breadcrumbs" => $breadcrumbs,
  1120.                 "root" => "/directory/".$directory->getSlug(),
  1121.             ]
  1122.         ]);
  1123.     }
  1124.     
  1125.     /**
  1126.      * @Route("/directory/{slug}/posts/{page}", name="directory_posts_master")
  1127.      */
  1128.     public function directoryPosts(
  1129.         Request $request,
  1130.         ContentHelper $helper,
  1131.         $slug = "",
  1132.         $page = 1
  1133.     ) {
  1134.         $directory = $helper->getDirectoryBySlug($slug);
  1135.         $customer = $directory->getDirectory();
  1136.         
  1137.         $length = 10;
  1138.         $posts = $helper->getPaginatedContentByType(Content::POST, $length, $page, "", $customer, "newsroom", false);
  1139.         $total = $helper->countPostsByCustomer($customer);
  1141.         $breadcrumbs = [
  1142.             [
  1143.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1144.                 "href" => "/our-directory/",
  1145.             ],
  1146.             [
  1147.                 "title" => $directory->getTitle(),
  1148.                 "href" => "/directory/{$directory->getSlug()}",
  1149.             ],
  1150.             [
  1151.                 "title" => "Posts",
  1152.                 "href" => "/directory/{$directory->getSlug()}/posts",
  1153.             ]
  1154.         ];
  1155.         return $this->defaultRender("content/post.html.twig", [
  1156.             "customer" => $customer,
  1157.             "posts" => $posts,
  1158.             "total" => $total,
  1159.             "length" => $length,
  1160.             "page" => $page,
  1162.             "meta" => [
  1163.                 "title" => $directory->getTitle(),
  1164.                 "breadcrumbs" => $breadcrumbs,
  1165.                 "root" => "/directory/".$directory->getSlug()."/posts",
  1166.             ]
  1167.         ]);
  1168.     }
  1169.     
  1170.     
  1171.     /**
  1172.        * @Route("/directory/{slug}/content/buy-online/{page}", name="directory_buyonline_content_master")
  1173.        */
  1174.     public function directoryBuyOnlineContent(
  1175.       Request $request,
  1176.       ContentHelper $helper,
  1177.       $slug = "",
  1178.       $type = "2",
  1179.       $page = 1
  1180.     ) {
  1181.         $directory = $helper->getDirectoryBySlug($slug); // get directory from url
  1182.         //$customer = $directory->getCustomers()->first(); // gets the directory customer
  1183.         $customer = $directory->getDirectory();
  1185.         $length = 10; //10 per page
  1186.         
  1187.         $contents = $helper->getContent(
  1188.           "*",
  1189.            "buy-online",
  1190.            "published",
  1191.            "desc",
  1192.            ($page - 1),
  1193.            $length,
  1194.            true,
  1195.            "*",
  1196.            true, //secondary categories
  1197.            false,
  1198.            false,
  1199.            false,
  1200.           $customer->getId()
  1201.           );
  1202.         $total = $contents["total"];
  1203.         $posts = $contents["content"];
  1205.         $breadcrumbs = [
  1206.           [
  1207.             "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1208.             "href" => "/our-directory/",
  1209.           ],
  1210.           [
  1211.             "title" => $directory->getTitle(),
  1212.             "href" => "/directory/{$directory->getSlug()}",
  1213.           ],
  1214.           [
  1215.             "title" => "Buy Online",
  1216.             "href" => "/directory/{$directory->getSlug()}/buy-online",
  1217.           ]
  1218.         ];
  1219.         return $this->defaultRender("content/post.html.twig", [
  1220.           "customer" => $customer,
  1221.           "posts" => $posts,
  1222.           "total" => $total,
  1223.           "length" => $length,
  1224.           "page" => $page,
  1225.           "meta" => [
  1226.             "title" => $directory->getTitle(),
  1227.                     "breadcrumbs" => $breadcrumbs,
  1228.                     "root" => "/directory/".$directory->getSlug()."/content/buy-online",
  1229.           ]
  1230.         ]);
  1231.     }
  1234.     //todo: make these types of routes generic
  1236.     /**
  1237.      * @Route("/directory/{slug}/content/spanish/{page}", name="directory_spanish_content_master")
  1238.      */
  1239.     public function directorySpanishContent(
  1240.     Request $request,
  1241.     ContentHelper $helper,
  1242.     $slug = "",
  1243.     $type = "2",
  1244.     $page = 1
  1245.     ) {
  1246.         $directory = $helper->getDirectoryBySlug($slug); // get directory from url
  1247.         //$customer = $directory->getCustomers()->first(); // gets the directory customer
  1248.         $customer = $directory->getDirectory();
  1250.         $length = 10; //10 per page
  1251.         
  1252.         $contents = $helper->getContent(
  1253.         "*",
  1254.             "en-espanol",
  1255.             "published",
  1256.             "desc",
  1257.             ($page - 1),
  1258.             $length,
  1259.             true,
  1260.             "*",
  1261.             true, //secondary categories
  1262.             false,
  1263.             false,
  1264.             false,
  1265.         $customer->getId()
  1266.         );
  1267.         $total = $contents["total"];
  1268.         $posts = $contents["content"];
  1270.         $breadcrumbs = [
  1271.         [
  1272.             "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1273.             "href" => "/our-directory/",
  1274.         ],
  1275.         [
  1276.             "title" => $directory->getTitle(),
  1277.             "href" => "/directory/{$directory->getSlug()}",
  1278.         ],
  1279.         [
  1280.             "title" => "Spanish Content",
  1281.             "href" => "/directory/{$directory->getSlug()}/spanish",
  1282.         ]
  1283.         ];
  1284.         return $this->defaultRender("content/post.html.twig", [
  1285.         "customer" => $customer,
  1286.         "posts" => $posts,
  1287.         "total" => $total,
  1288.         "length" => $length,
  1289.         "page" => $page,
  1290.         "meta" => [
  1291.             "title" => $directory->getTitle(),
  1292.                     "breadcrumbs" => $breadcrumbs,
  1293.                     "root" => "/directory/".$directory->getSlug()."/content/spanish",
  1294.         ]
  1295.         ]);
  1296.     }
  1298.     
  1299.     /**
  1300.      * @Route("/directory/{slug}/content/international/{page}", name="directory_international_content_master")
  1301.      */
  1302.     public function directoryInternationalContent(
  1303.         Request $request,
  1304.         ContentHelper $helper,
  1305.         $slug = "",
  1306.         $type = "2",
  1307.         $page = 1
  1308.         ) {
  1309.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
  1310.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
  1311.             $customer = $directory->getDirectory();
  1312.     
  1313.             $length = 10; //10 per page
  1314.             
  1315.             $contents = $helper->getContent(
  1316.             "*",
  1317.                 "international",
  1318.                 "published",
  1319.                 "desc",
  1320.                 ($page - 1),
  1321.                 $length,
  1322.                 true,
  1323.                 "*",
  1324.                 true, //secondary categories
  1325.                 false,
  1326.                 false,
  1327.                 false,
  1328.             $customer->getId()
  1329.             );
  1330.             $total = $contents["total"];
  1331.             $posts = $contents["content"];
  1332.     
  1333.             $breadcrumbs = [
  1334.             [
  1335.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1336.                 "href" => "/our-directory/",
  1337.             ],
  1338.             [
  1339.                 "title" => $directory->getTitle(),
  1340.                 "href" => "/directory/{$directory->getSlug()}",
  1341.             ],
  1342.             [
  1343.                 "title" => "International Content",
  1344.                 "href" => "/directory/{$directory->getSlug()}/international",
  1345.             ]
  1346.             ];
  1347.             return $this->defaultRender("content/post.html.twig", [
  1348.             "customer" => $customer,
  1349.             "posts" => $posts,
  1350.             "total" => $total,
  1351.             "length" => $length,
  1352.             "page" => $page,
  1353.             "meta" => [
  1354.                 "title" => $directory->getTitle(),
  1355.                         "breadcrumbs" => $breadcrumbs,
  1356.                         "root" => "/directory/".$directory->getSlug()."/content/international",
  1357.             ]
  1358.             ]);
  1359.         }
  1361.         
  1362.     /**
  1363.      * @Route("/directory/{slug}/content/canada/{page}", name="directory_canada_content_master")
  1364.      */
  1365.     public function directoryCanadaContent(
  1366.         Request $request,
  1367.         ContentHelper $helper,
  1368.         $slug = "",
  1369.         $type = "2",
  1370.         $page = 1
  1371.         ) {
  1372.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
  1373.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
  1374.             $customer = $directory->getDirectory();
  1375.     
  1376.             $length = 10; //10 per page
  1377.             
  1378.             $contents = $helper->getContent(
  1379.             "*",
  1380.                 "canada",
  1381.                 "published",
  1382.                 "desc",
  1383.                 ($page - 1),
  1384.                 $length,
  1385.                 true,
  1386.                 "*",
  1387.                 true, //secondary categories
  1388.                 false,
  1389.                 false,
  1390.                 false,
  1391.             $customer->getId()
  1392.             );
  1393.             $total = $contents["total"];
  1394.             $posts = $contents["content"];
  1395.     
  1396.             $breadcrumbs = [
  1397.             [
  1398.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1399.                 "href" => "/our-directory/",
  1400.             ],
  1401.             [
  1402.                 "title" => $directory->getTitle(),
  1403.                 "href" => "/directory/{$directory->getSlug()}",
  1404.             ],
  1405.             [
  1406.                 "title" => "Canada Content",
  1407.                 "href" => "/directory/{$directory->getSlug()}/canada",
  1408.             ]
  1409.             ];
  1410.             return $this->defaultRender("content/post.html.twig", [
  1411.             "customer" => $customer,
  1412.             "posts" => $posts,
  1413.             "total" => $total,
  1414.             "length" => $length,
  1415.             "page" => $page,
  1416.             "meta" => [
  1417.                 "title" => $directory->getTitle(),
  1418.                         "breadcrumbs" => $breadcrumbs,
  1419.                         "root" => "/directory/".$directory->getSlug()."/content/canada",
  1420.             ]
  1421.             ]);
  1422.         }
  1423.     
  1424.     /**
  1425.      * @Route("/directory/{slug}/content/lunch-and-learn/{page}", name="directory_lunch_and_learn_content_master")
  1426.      */
  1427.     public function directoryLunchAndLearnContent(
  1428.         Request $request,
  1429.         ContentHelper $helper,
  1430.         $slug = "",
  1431.         $type = "8",
  1432.         $page = 1
  1433.         ) {
  1434.             $directory = $helper->getDirectoryBySlug($slug); // get directory from url
  1435.             //$customer = $directory->getCustomers()->first(); // gets the directory customer
  1436.             $customer = $directory->getDirectory();
  1437.     
  1438.             $length = 10; //10 per page
  1439.             
  1440.             $contents = $helper->getContent(
  1441.             "*",
  1442.                 "on-demand-lunch-learn",
  1443.                 "published",
  1444.                 "desc",
  1445.                 ($page - 1),
  1446.                 $length,
  1447.                 true,
  1448.                 "*",
  1449.                 true, //secondary categories
  1450.                 false,
  1451.                 false,
  1452.                 false,
  1453.             $customer->getId()
  1454.             );
  1455.             $total = $contents["total"];
  1456.             $posts = $contents["content"];
  1457.     
  1458.             $breadcrumbs = [
  1459.             [
  1460.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1461.                 "href" => "/our-directory/",
  1462.             ],
  1463.             [
  1464.                 "title" => $directory->getTitle(),
  1465.                 "href" => "/directory/{$directory->getSlug()}",
  1466.             ],
  1467.             [
  1468.                 "title" => "Lunch and Learn Content",
  1469.                 "href" => "/directory/{$directory->getSlug()}/lunch-and-learn",
  1470.             ]
  1471.             ];
  1472.             return $this->defaultRender("content/post.html.twig", [
  1473.             "customer" => $customer,
  1474.             "posts" => $posts,
  1475.             "total" => $total,
  1476.             "length" => $length,
  1477.             "page" => $page,
  1478.             "meta" => [
  1479.                 "title" => $directory->getTitle(),
  1480.                         "breadcrumbs" => $breadcrumbs,
  1481.                         "root" => "/directory/".$directory->getSlug()."/content/lunch-and-learn",
  1482.             ]
  1483.             ]);
  1484.         }
  1487.     /**
  1488.      * @Route("/directory/{slug}/content/{type}/{page}", name="directory_content_master")
  1489.      */
  1490.     public function directoryContent(
  1491.         Request $request,
  1492.         ContentHelper $helper,
  1493.         $slug = "",
  1494.         $type = 2,
  1495.         $page = 1
  1496.     ) {
  1497.         $directory = $helper->getDirectoryBySlug($slug);
  1498.         //$customer = $directory->getCustomers()->first();
  1499.         $customer = $directory->getDirectory();
  1501.         $length = 10;
  1502.         $posts = $helper->getPaginatedContentByType($type, $length, $page, "", $customer);
  1503.         $total = $helper->countContentByCustomer($type, $customer);
  1505.         $breadcrumbs = [
  1506.             [
  1507.                 "title" => strtoupper(SiteConfig::CONFIGS[$this->site_code]["site_code"]) . " Directory",
  1508.                 "href" => "/our-directory/",
  1509.             ],
  1510.             [
  1511.                 "title" => $directory->getTitle(),
  1512.                 "href" => "/directory/{$directory->getSlug()}",
  1513.             ],
  1514.             [
  1515.                 "title" => Content::getTypeTextStatic($type),
  1516.                 "href" => "/directory/{$directory->getSlug()}/content/".$type,
  1517.             ]
  1518.         ];
  1519.         return $this->defaultRender("content/post.html.twig", [
  1520.             "customer" => $customer,
  1521.             "posts" => $posts,
  1522.             "total" => $total,
  1523.             "length" => $length,
  1524.             "page" => $page,
  1526.             "meta" => [
  1527.                 "title" => $directory->getTitle(),
  1528.                 "breadcrumbs" => $breadcrumbs,
  1529.                 "root" => "/directory/".$directory->getSlug()."/content/".$type,
  1530.             ]
  1531.         ]);
  1532.     }
  1533.     
  1534.     /**
  1535.      * @Route(
  1536.      *      "/directory/{slug}",
  1537.      *      name="directory_lead_master",
  1538.      *      methods={"POST"}
  1539.      * )
  1540.      */
  1541.     public function directoryPostLead (
  1542.         Request $request,
  1543.         ContentHelper $helper,
  1544.         Swift_Mailer $mailer,
  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.         $content = ""
  2612.     ) {
  2613.         $limit = ContentHelper::DEFAULT_LIMIT;
  2614.         
  2615.         //Because this is used as an embedded controller, it receives a sub-request instead of the master request (that has the form submission data).
  2616.         //This line will set the request to the master request to allow it to be processed.
  2617.         $request = $this->get('request_stack')->getMasterRequest();
  2618.         
  2619.         $comment = new Comment();
  2620.         $comment->setContent($content);
  2621.         
  2622.         //$form = $this->createForm(CommentType::class, $comment);
  2623.         
  2624.         //$form->handleRequest($request);
  2625.         
  2626.         if ($request->request->has("comment-text")) {
  2627.             
  2628.             //$comment = $form->getData();
  2629.             
  2630.             $comment->setApproved(0);
  2631.             $comment->setAuthorIP($_SERVER['REMOTE_ADDR']);
  2632.             $comment->setAgent($_SERVER['HTTP_USER_AGENT']);
  2633.             $comment->setCommentText($request->request->get("comment-text"));
  2634.             
  2635.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
  2636.                 $user = $this->getUser();
  2638.                 if($user->getRole() == 8) {
  2639.                     $comment->setApproved(1);
  2640.                 }
  2642.                 $comment->setUser($user);
  2643.                 $comment->setAuthor($user->getDisplayname());
  2644.                 $comment->setAuthorEmail($user->getEmail());
  2645.                 $comment->setApproved(1); //Change 3/25/21 to auto-approve per Heidi
  2646.             }
  2647.             else {
  2648.                 $comment->setAuthor($request->request->get("author"));
  2649.                 $comment->setAuthorEmail($request->request->get("email"));
  2650.                 $comment->setAuthorUrl($request->request->get("url"));
  2651.             }
  2652.             
  2653.             $entityManager = $this->getDoctrine()->getManager();
  2654.             $entityManager->persist($comment);
  2655.             $entityManager->flush();
  2656.             
  2657.             $contentType = strtolower($content->getTypeText());
  2658.             
  2659.             $emailHelper->sendEmail(
  2660.                 ["rcs@rooferscoffeeshop.com"],
  2661.                 "New Comment Added - {$content->getTitle()}",
  2662.                 [
  2663.                     ["p" => "A new comment has been added to the {$contentType} \"{$content->getTitle()}\"."],
  2664.                     ["p" => "User \"{$comment->getAuthor()}\" commented: \"{$comment->getCommentText()}\"."],
  2665.                     ["button" => [
  2666.                         "text" => "View Content",
  2667.                         "href" => "{$content->getFullURL($this->site_code)}",
  2668.                     ]],
  2669.                 ]
  2670.             );
  2671.             
  2672.             //redirect back (can't get to work yet bc of embedded controller)
  2673.             //$this->addFlash("success", "Your comment has been submitted and is awaiting approval.");
  2674.             /*
  2675.             $session = $request->getSession();
  2676.             $route = $session->get("this_route");
  2677.             $this->redirect($route["path"]);
  2678.             */
  2679.             
  2680.         }
  2682.         /*
  2683.         if ($form->isSubmitted() && $form->isValid()) {
  2684.             $comment = $form->getData();
  2686.             $comment->setApproved(0);
  2687.             $comment->setAuthorIP($_SERVER['REMOTE_ADDR']);
  2688.             $comment->setAgent($_SERVER['HTTP_USER_AGENT']);
  2690.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
  2691.                 $user = $this->getUser();
  2693.                 if($user->getRole() == 8) {
  2694.                     $comment->setApproved(1);
  2695.                 }
  2697.                 $comment->setUser($user);
  2698.                 $comment->setAuthor($user->getDisplayname());
  2699.                 $comment->setAuthorEmail($user->getEmail());
  2700.             }
  2702.             $entityManager = $this->getDoctrine()->getManager();
  2703.             $entityManager->persist($comment);
  2704.             $entityManager->flush();
  2706.             //redirect back
  2707.             $this->addFlash("success", "Your comment has been submitted and is awaiting approval.");
  2708.         }
  2709.         */
  2711.         return $this->defaultRender("forms/comment.html.twig", [
  2712.             "comments" => $helper->getComments($content),
  2713.             //"form" => $form->createView(),
  2714.         ]);
  2716.     }
  2717.     
  2718.     /**
  2719.      * @Route("/search/{page}",
  2720.      *     name="search_master",
  2721.      *     defaults={"page": 1}
  2722.      * )
  2723.      */
  2724.     public function search (
  2725.        Request $request,
  2726.        ContentHelper $contentHelper,
  2727.        $page = 1
  2728.     ) {
  2729.         $search = $request->get("s");
  2730.         $data = $contentHelper->search($search, $page);
  2731.         
  2732.         return $this->defaultRender("content/search.html.twig", [
  2733.            "total" => $data["count"],
  2734.            "limit" => 15,
  2735.            "results" => $data["content"],
  2736.            "page" => $page,
  2737.            "search" => $search,
  2738.            "meta" => [
  2739.                "title" => "Search Results for {$search}",
  2740.            ]
  2741.         ]);
  2742.     }
  2745.     // requires a content object to be passed as $content
  2746.     public function partnerspage(
  2747.         Request $request,
  2748.         ContentHelper $contentHelper,
  2749.         $content = ""
  2750.     ) {
  2751.         
  2752.         $directories = $contentHelper->getDirectoryListings(0,"_","_","_","_","_",10000);
  2753.         
  2754.         return $this->defaultRender("content/tmpl/partners-page.html.twig", [
  2755.             "content" => $content,
  2756.             "directories" => $directories["listings"],
  2757.         ]);
  2758.     }
  2759.     
  2762.     // requires a content object to be passed as $content
  2763.     public function popoutAd(
  2764.         Request $request,
  2765.         ContentHelper $contentHelper,
  2766.         CustomerHelper $customerHelper,
  2767.         EmailHelper $emailHelper,
  2768.         MediaHelper $mediaHelper,
  2769.         $content = ""
  2770.     ) {
  2771.         if($content instanceof Content) {
  2772.             $customer = $content->getPrimaryCustomer();
  2773.             $popout = $mediaHelper->getPopoutAdByCustomer($customer);
  2774.             if(!$popout) {
  2775.                 $popout = $mediaHelper->getDefaultPopoutAd();
  2776.                 $customer = $customerHelper->getCustomerById(110);
  2777.             }
  2778.         }
  2779.         else {
  2780.             //$content = ""; $customer = ""; $popout = "";
  2781.             $content = "";
  2782.             $popout = $mediaHelper->getDefaultPopoutAd();
  2783.             $customer = $customerHelper->getCustomerById(110);
  2784.         }
  2785.         return $this->defaultRender("elements/popout-ad.html.twig", [
  2786.             "popout" => $popout,
  2787.             "customer" => $customer,
  2788.         ]);
  2789.     }
  2790.     
  2792.     // requires a content object to be passed as $content
  2793.     public function pinnedSidebarAd(
  2794.         Request $request,
  2795.         MediaHelper $mediaHelper,
  2796.         $base_url = "",
  2797.         $uri = "",
  2798.         $current_route = ""
  2799.     ) {
  2800.         //$site_code = $this->site_code;
  2801.         $ad = $mediaHelper->getPinnedAdByPosition($base_url, parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH), $current_route, "ad-sidebar");
  2802.         return $this->defaultRender("elements/sidebar-ad.html.twig", [
  2803.             "ad" => $ad
  2804.             //,"uri" => parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH)
  2805.         ]);
  2806.     }
  2808.     // requires a content object to be passed as $content
  2809.     public function pinnedCurtainAd(
  2810.         Request $request,
  2811.         MediaHelper $mediaHelper,
  2812.         $base_url = "",
  2813.         $uri = "",
  2814.         $current_route = ""
  2815.     ) {
  2816.         $ad = $mediaHelper->getPinnedAdByPosition($base_url, parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH), $current_route, "ad-curtain");
  2817.         return $this->defaultRender("elements/curtain-ad.html.twig", [
  2818.             "ad" => $ad
  2819.         ]);
  2820.     }
  2821.     
  2823.     
  2824.     /**
  2825.     * @Route("/quiz/{slug}", name="Quick Quiz")
  2826.     */
  2827.     public function getQuiz(
  2828.         Request $request,
  2829.         QuizHelper $quizHelper,
  2830.         $slug
  2831.     ){
  2832.         $cookies = $request->cookies;
  2834.         if (!$this->user && !$cookies->has("$slug-quizToken")) {
  2835.             $nt = uniqid();
  2836.             setcookie("$slug-quizToken", $nt,0,'','',true,true);
  2837.         }
  2839.         $quiz = $quizHelper->getLandingPageBySlug($slug);
  2840.         //Static quiz templates:
  2841.         if ($quiz && in_array($slug, ["wdyfir", "certainteed"]) && $this->site_code == Site::SITE_RCS) {
  2842.             return $this->defaultRender("content/quiz/$slug/landing.html.twig",$quiz);
  2843.         }
  2844.         else {
  2845.             //Dynamic Quizzes:
  2846.             $quiz = $quizHelper->getQuizObjectBySlug($slug);
  2847.             if($quiz) {
  2848.                 return $this->defaultRender("content/quiz/dynamic/landing.html.twig", [
  2849.                     "quiz" => $quiz
  2850.                 ]);
  2851.             }
  2852.         }
  2853.     }
  2855.     /**
  2856.     * @Route("/quizExport/{quizId}", name="quiz_export")
  2857.     */
  2858.     public function quizExport(
  2859.         Request $request,
  2860.         QuizHelper $quizHelper,
  2861.         $quizId = ""
  2862.     ) {
  2864.         $access = false;
  2865.         if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
  2866.             $user = $this->getUser();
  2867.             if($user) {
  2868.                 if($this->user->isAdmin()) {
  2869.                     $access = true;
  2870.                 }
  2871.             }
  2872.         }
  2873.         if(!$access) {
  2874.             return $this->defaultRender("errors/404.html.twig", []);
  2875.         }
  2876.         $quiz = $quizHelper->getQuizById($quizId);
  2877.         $responses = $quiz->getQuizResponses()->matching(Criteria::create()->orderBy(["datetaken" => Criteria::DESC]));
  2878.         $questions = $quiz->getQuizQuestions()->matching(Criteria::create()->orderBy(["sort" => Criteria::ASC]));
  2879.         
  2880.         //Export / Spreadsheet
  2881.         $spreadsheet = new Spreadsheet();
  2882.         
  2883.         $spreadsheet = new Spreadsheet();
  2884.         $sheet = $spreadsheet->getActiveSheet();
  2885.         
  2886.         //Sheet 1
  2887.         $rowNum = 1;
  2888.         $sheet->setTitle("Quiz Results");
  2890.         $sheet->setCellValue("A{$rowNum}", "Date Taken");
  2891.         $sheet->setCellValue("B{$rowNum}", "Name");
  2892.         $sheet->setCellValue("C{$rowNum}", "Email");
  2893.         $sheet->setCellValue("D{$rowNum}", "Finished");
  2894.         $sheet->setCellValue("E{$rowNum}", "Score");
  2895.         $colVal = "F";
  2896.         foreach($questions as $question) {
  2897.             $sheet->setCellValue("{$colVal}{$rowNum}", $question->getTitle());
  2898.             $colVal++;
  2899.         }
  2900.         $sheet->getStyle("A1:{$colVal}1")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  2901.         $rowNum++;
  2902.         
  2903.         foreach($responses as $response) {
  2904.             if($questions->first() && !$response->getAnswerByQuestionId($questions->first()->getId())) {
  2905.                 continue; //Skip if first question isn't answered (caused by a bug)
  2906.             }
  2907.             $colVal = "A";
  2908.             $name = $response->getUser() ? $response->getUser()->getFullName() : $response->getNlFullName();
  2909.             $email = $response->getUser() ? $response->getUser()->getEmail() : $response->getNlEmail();
  2910.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getDatetaken()->format("Y-m-d H:i:s")); $colVal++;
  2911.             $sheet->setCellValue("{$colVal}{$rowNum}", $name); $colVal++;
  2912.             $sheet->setCellValue("{$colVal}{$rowNum}", $email); $colVal++;
  2913.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getIsFinished() ? "Yes" : "No"); $colVal++;
  2914.             //$sheet->setCellValue("{$colVal}{$rowNum}", $response->getMessage() ? $response->getMessage() : "N/A"); $colVal++;
  2915.             $sheet->setCellValue("{$colVal}{$rowNum}", $response->getScore()); $colVal++;
  2916.             foreach($questions as $question) {
  2917.                 $answer = $response->getAnswerByQuestionId($question->getId());
  2918.                 $sheet->setCellValue("{$colVal}{$rowNum}", $answer ? $answer : "");
  2919.                 $colVal++;
  2920.             }
  2921.             $rowNum++;
  2922.         }
  2924.         foreach(range("A",$sheet->getHighestColumn()) as $columnID) {
  2925.             $sheet->getColumnDimension($columnID)
  2926.                 ->setAutoSize(true);
  2927.         }
  2928.         
  2929.         //Finish and save
  2930.         //$spreadsheet->setActiveSheetIndexByName("Quiz Results");
  2931.         $writer = new Xlsx($spreadsheet);
  2932.         $filename = "Quiz Export - {$quiz->getTitle()}.xlsx";
  2933.         $writer->save("../var/reports/quizzes/{$filename}");
  2934.         
  2935.         $response = new BinaryFileResponse("../var/reports/quizzes/{$filename}");
  2936.         $disposition = $response->headers->makeDisposition(
  2937.             ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  2938.             $filename
  2939.         );
  2940.         $response->headers->set('Content-Disposition', $disposition);
  2941.         return $response;
  2942.     }
  2945.     /**
  2946.     * @Route("/quiz/{slug}/collect-information", name="Quiz-Lead",methods={"GET"})
  2947.     */
  2948.     public function quizLead(
  2949.         Request $request,
  2950.         QuizHelper $quizHelper,
  2951.         $slug
  2952.     ){
  2953.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
  2955.         $ref = $request->query->get("ref");
  2956.         if (in_array($slug, ["wdyfir", "certainteed"])) {
  2957.             return $this->defaultRender("content/quiz/$slug/infoCollector.html.twig", [
  2958.                 'ref'=>$ref,
  2959.                 'img'=>$quizHelper->getLandingPageBySlug($slug)['img']
  2960.             ]);
  2961.         }
  2962.         return $this->defaultRender("content/quiz/dynamic/infoCollector.html.twig", [
  2963.             'ref' => $ref,
  2964.             'quiz' => $quiz,
  2965.             //'img'=>$quizHelper->getLandingPageBySlug($slug)['img']
  2966.         ]);
  2967.         
  2968.     }
  2970.     /**
  2971.     * @Route("/quiz/{slug}/collect-information", name="Quiz-Lead-data", methods={"POST"})
  2972.     */
  2973.     public function quizLeadData(
  2974.         Request $request,
  2975.         QuizHelper $quizHelper,
  2976.         $slug
  2977.     ){
  2978.         $ref = $request->request->get("ref");
  2979.         $fname = $request->request->get("firstName");
  2980.         $lname = $request->request->get("lastName");
  2981.         $email = $request->request->get("email");
  2982.         $newsletter = $request->request->get("newsletter");
  2983.         
  2984.         // normalize newsletter
  2985.         if($newsletter == "on") {
  2986.             $newsletter = 1;
  2987.         }else{
  2988.             $newsletter = 0;
  2989.         }
  2991.         // process information // save the lead
  2992.         $quizHelper->saveUnauthedQuizLead($fname, $lname, $email, $ref, $newsletter);
  2993.         
  2994.         $quizResponse = $quizHelper->getQuizResponseByRefurl($ref);
  2995.         $quizHelper->sendQuizResultsEmail($quizResponse->getId());
  2996.         
  2997.         return $this->redirectToRoute("Quiz-Results", [
  2998.             "slug" => $slug,
  2999.             "ref" => $ref
  3000.         ]);
  3002.     }
  3006.     /**
  3007.     * @Route("/quiz/{slug}/{question}", name="Quick-Question", methods={"GET"})
  3008.     */
  3009.     public function getQuestionByQuizByNumber(
  3010.         Request $request,
  3011.         QuizHelper $quizHelper,
  3012.         $slug,
  3013.         $question
  3014.     ){
  3015.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
  3017.         if($quiz->getRequiresLogin() && !$this->user) {
  3018.             return $this->redirectToRoute("Quick Quiz", [
  3019.                 "slug" => $slug,
  3020.             ]);
  3021.         }
  3022.         
  3023.         $cookies = $request->cookies;
  3024.         if ($this->user || $cookies->has("$slug-quizToken")) {
  3025.             $uid = $this->user ? $this->user->getID() : $cookies->get("$slug-quizToken");
  3026.             $lastQuestionNumber = $quizHelper->getInProgressQuizByID($slug,$uid);
  3028.             if ($lastQuestionNumber && $lastQuestionNumber+1 != $question) {
  3029.                 return $this->redirectToRoute("Quick-Question", [
  3030.                     "slug" => $slug,
  3031.                     "question" => $lastQuestionNumber+1
  3032.                 ]);
  3033.             }elseif(!$lastQuestionNumber && $question!=1){
  3034.                 return $this->redirectToRoute("Quick-Question", [
  3035.                     "slug" => $slug,
  3036.                     "question" => 1
  3037.                 ]);
  3038.             }
  3039.         }
  3041.         if (in_array($slug, ["wdyfir", "certainteed"])) {
  3042.             $q = $quizHelper->getQuestionOptionsByQuizByNumber($slug, $question);
  3043.             if ($q) {
  3044.                 return $this->defaultRender("content/quiz/$slug/question.html.twig",$q);
  3045.             }else{
  3046.                 return $this->defaultRender("errors/404.html.twig", []);
  3047.             }
  3048.         }
  3049.         else {
  3050.             //Dynamic Quizzes:
  3051.             $number = $question;
  3052.             $quiz = $quizHelper->getQuizObjectBySlug($slug);
  3053.             $question = $quiz->getQuestionByNumber($number);
  3054.             if($question) {
  3055.                 return $this->defaultRender("content/quiz/dynamic/question.html.twig", [
  3056.                     "quiz" => $quiz,
  3057.                     "question" => $question,
  3058.                     "number" => $number
  3059.                 ]);
  3060.             }
  3061.         }
  3063.         
  3064.     }
  3066.     /**
  3067.     * @Route("/quiz/{slug}/{question}", name="Question-Answer", methods={"POST"})
  3068.     */
  3069.     public function saveQuestionResponse(
  3070.         Request $request,
  3071.         QuizHelper $quizHelper,
  3072.         MailChimpHelper $mailChimpHelper,
  3073.         $slug,
  3074.         $question
  3075.     ){
  3076.         $cookies = $request->cookies;
  3077.         $qid = $quizHelper->getQuizBySlug($slug)['id'];
  3078.         if (!$this->user) {
  3079.             $uid = NULL;
  3080.             $nt = $cookies->get("$slug-quizToken");
  3081.         }else{
  3082.             $uid = $this->user->getID();
  3083.             $nt = NULL;
  3084.         }
  3085.         
  3086.         $questionObject = $quizHelper->getQuestionById($request->request->get("questionId"));
  3087.         if($questionObject->getType() == QuizQuestion::RADIO_BUTTONS) {
  3088.             $userAnswer = $quizHelper->getOptionByID($request->request->get("question-$question"));
  3089.             $qoid = $userAnswer['id'];
  3090.             $a = $userAnswer['title'];
  3091.         }
  3092.         else {
  3093.             $qoid = null;
  3094.             $a = $request->request->get("question-$question");
  3095.         }
  3097.         $responseID = $quizHelper->saveResponse($uid, $nt, $qid, $questionObject->getId(), $qoid, $a);
  3098.         
  3099.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
  3101.         if (in_array($slug, ["wdyfir", "certainteed"]) && $question == $quizHelper->getLastQuestionNumberBySlug($slug)) {
  3103.             $ref = $quizHelper->finishQuiz($responseID);
  3105.             if ($this->user) {
  3106.                 $email = $this->user->getEmail();
  3107.                 $fname = $this->user->getFirstName();
  3108.                 $lname = $this->user->getLastName();
  3109.                 // need to add to mailchimp here too 
  3110.                 $mailChimpHelper->subscribe($email,
  3111.                     [
  3112.                         'FNAME'=>$fname,
  3113.                         'LNAME'=>$lname
  3114.                     ],
  3115.                     [
  3116.                         'WIR'
  3117.                     ]
  3118.                 );
  3120.                 $quizHelper->sendQuizResultsEmail($responseID);
  3122.                 return $this->redirectToRoute("Quiz-Results", [
  3123.                     "slug" => $slug,
  3124.                     "ref" => $ref
  3125.                 ]);
  3126.             }else{
  3127.                 return $this->redirectToRoute("Quiz-Lead", [
  3128.                     "slug" => $slug,
  3129.                     "ref" => $ref
  3130.                 ]);
  3131.             }
  3133.         }
  3134.         elseif(!in_array($slug, ["wdyfir", "certainteed"]) && $question == $quiz->countQuizQuestions()) {
  3135.             //Dynamic Quizzes:
  3136.             $ref = $quizHelper->finishQuiz($responseID);
  3137.             if ($this->user) {
  3138.                 $quizHelper->sendQuizResultsEmail($responseID, $ref);
  3140.                 return $this->redirectToRoute("Quiz-Results", [
  3141.                     "slug" => $slug,
  3142.                     "ref" => $ref
  3143.                 ]);
  3144.             }
  3145.             else {
  3146.                 return $this->redirectToRoute("Quiz-Lead", [
  3147.                     "slug" => $slug,
  3148.                     "ref" => $ref
  3149.                 ]);
  3150.             }
  3151.         }
  3152.         else{
  3153.             return $this->redirectToRoute("Quick-Question", [
  3154.                 "slug" => $slug,
  3155.                 "question" => $question+1
  3156.             ]);
  3157.         }
  3159.     }
  3161.     /**
  3162.     * @Route("/quiz/{slug}/results/{ref}", name="Quiz-Results")
  3163.     */
  3164.     public function quizResults(
  3165.         Request $request,
  3166.         QuizHelper $quizHelper,
  3167.         $slug,
  3168.         $ref
  3169.     ){
  3170.         $quiz = $quizHelper->getQuizObjectBySlug($slug);
  3172.         $results = $quizHelper->getResultsByRef($ref);
  3173.         if(in_array($slug, ["wdyfir", "certainteed"])) {
  3174.             return $this->defaultRender("content/quiz/$slug/ending.html.twig", $results);
  3175.         }
  3176.         $response = $quizHelper->getQuizResponseByRefurl($ref);
  3177.         return $this->defaultRender("content/quiz/dynamic/ending.html.twig", [
  3178.             "quiz" => $quiz,
  3179.             "response" => $response,
  3180.             "result" => $response->getQuizResult()
  3181.         ]);
  3182.     }
  3185.     /**
  3186.     * @Route("/quizz/debugger", name="quiz-debugger")
  3187.     */
  3188.     public function quizDebugger(
  3189.         Request $request,
  3190.         QuizHelper $quizHelper
  3191.     ){
  3192.         return new JsonResponse($this->user->getLastname());
  3193.     }
  3196.     
  3197.     //TODO: move all ajax to different controllers
  3198.         
  3199.         /**
  3200.         * @Route("/ajax/social-data")
  3201.         */
  3202.         public function socialDataAjaxAction(
  3203.             Request $request,
  3204.             CustomerHelper $customerHelper
  3205.         ) {
  3206.             return new JsonResponse(json_encode(
  3207.                 [
  3208.                     "facebookHandles" => $customerHelper->getFacebookHandles(),
  3209.                     "linkedinHandles" => $customerHelper->getLinkedinHandles(),
  3210.                     "twitterHandles" => $customerHelper->getTwitterHandles(),
  3211.                     "tags" => $customerHelper->getCustomerTags()
  3212.                 ]
  3213.             ));
  3214.         }
  3216.         /**
  3217.         * @Route("/ajax/link")
  3218.         */
  3219.         public function linkAjaxAction(
  3220.             Request $request,
  3221.             MenuHelper $menuHelper,
  3222.             ContentHelper $contentHelper
  3223.         ) {
  3224.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3225.                 $id = $request->get("id");
  3226.                 $link = $menuHelper->getLinkById($id);
  3227.                 if($link) {
  3228.                     $contentHelper->addImpression($request, "", $link);
  3229.                     return new JsonResponse($link->getRef());
  3230.                 }
  3231.             }
  3232.         }
  3233.         
  3234.         /**
  3235.         * @Route("/ajax/link-catchall")
  3236.         */
  3237.         public function linkCatchallAjaxAction(
  3238.             Request $request,
  3239.             ContentHelper $contentHelper
  3240.         ) {
  3241.             
  3242.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3243.                 
  3244.                 $path = $request->get("path");
  3245.                 $href = $request->get("href");
  3246.                 
  3247.                 $entityManager = $this->getDoctrine()->getManager();
  3248.                 $content = $entityManager
  3249.                     ->getRepository(Content::class)
  3250.                     ->getContentByUrl(
  3251.                         $path,
  3252.                         $this->site_code
  3253.                     );
  3254.                     
  3255.                 //if($content) {
  3256.                     $contentHelper->addImpression($request, $content, "", "", "3", $href);
  3257.                     return new JsonResponse($content ? $content->getId() : null);
  3258.                 //}
  3259.                 
  3260.             }
  3261.             
  3262.         }
  3263.         
  3264.         /**
  3265.         * @Route("/ajax/mitem-click")
  3266.         */
  3267.         public function mitemClickAjaxAction(
  3268.             Request $request,
  3269.             MediaHelper $mediaHelper,
  3270.             ContentHelper $contentHelper
  3271.         ) {
  3273.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3275.                 $id = $request->get("id");
  3276.                 $item = $mediaHelper->getMediaGroupItemById($id);
  3277.                 if($item) {
  3278.                     $contentHelper->addImpression($request, "", "", $item, 2);
  3279.                     return new JsonResponse($item->getExternalUrl());
  3280.                 }
  3282.             }
  3284.         }
  3286.         /**
  3287.         * @Route("/ajax/mitem-impression")
  3288.         */
  3289.         public function mitemImpressionAjaxAction(
  3290.             Request $request,
  3291.             MediaHelper $mediaHelper,
  3292.             ContentHelper $contentHelper
  3293.         ) {
  3295.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3297.                 $id = $request->get("id");
  3298.                 $item = $mediaHelper->getMediaGroupItemById($id);
  3299.                 if($item) {
  3300.                     $contentHelper->addImpression($request, "", "", $item, 1);
  3301.                     return new JsonResponse($item->getExternalUrl());
  3302.                 }
  3304.             }
  3306.         }
  3307.         
  3308.         //New function for multiple impressions below
  3309.         
  3310.         /**
  3311.         * @Route("/ajax/mitem-impressions")
  3312.         */
  3313.         public function mitemImpressionsAjaxAction(
  3314.             Request $request,
  3315.             MediaHelper $mediaHelper,
  3316.             ContentHelper $contentHelper
  3317.         ) {
  3319.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3320.                 
  3321.                 $ids = $request->get("ids");
  3322.                 $return = [];
  3323.                 
  3324.                 foreach($ids as $id) {
  3325.                     $item = $mediaHelper->getMediaGroupItemByIdOrNull($id);
  3326.                     if($item) {
  3327.                         $contentHelper->addImpression($request, "", "", $item, 1);
  3328.                         $return[] = $item->getExternalUrl();
  3329.                     }
  3330.                 }
  3331.                 
  3332.                 return new JsonResponse($return);
  3334.             }
  3336.         }
  3337.         
  3338.         /**
  3339.         * @Route("/ajax/content-impressions")
  3340.         */
  3341.         public function contentImpressionsAjaxAction(
  3342.             Request $request,
  3343.             ContentHelper $contentHelper
  3344.         ) {
  3345.             
  3346.             $contentHelper->storeQueuedImpressions($request);
  3347.             return new JsonResponse("Content Impressions Stored");
  3348.             
  3349.         }
  3351.         /**
  3352.         * @Route("/ajax/like-content")
  3353.         */
  3354.         public function likeAjaxAction(
  3355.             Request $request,
  3356.             ContentHelper $helper
  3357.         ) {
  3359.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
  3361.                 $id = $request->get("id");
  3362.                 if($id) {
  3363.                     $content = $helper->getContentById($id);
  3364.                     $helper->likeContent($content, $this->getUser());
  3365.                     $likes = $helper->countLikes($content);
  3367.                     $entityManager = $this->getDoctrine()->getManager();
  3368.                     $entityManager->persist($content);
  3369.                     $entityManager->flush();
  3371.                     return new JsonResponse($likes);
  3373.                 }
  3374.                 else {
  3375.                     return null;
  3376.                 }
  3378.             } else {
  3380.             }
  3381.         }
  3383.         /**
  3384.         * @Route("/ajax/unlike-content")
  3385.         */
  3386.         public function unlikeAjaxAction(
  3387.             Request $request,
  3388.             ContentHelper $helper
  3389.         ) {
  3391.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
  3393.                 $id = $request->get("id");
  3394.                 if($id) {
  3395.                     $content = $helper->getContentById($id);
  3396.                     $helper->unlikeContent($content, $this->getUser());
  3397.                     $likes = $helper->countLikes($content);
  3399.                     $entityManager = $this->getDoctrine()->getManager();
  3400.                     $entityManager->persist($content);
  3401.                     $entityManager->flush();
  3403.                     return new JsonResponse($likes);
  3405.                 }
  3406.                 else {
  3407.                     return null;
  3408.                 }
  3410.             } else {
  3412.             }
  3413.         }
  3415.         /**
  3416.         * @Route("/ajax/forum-quote-content")
  3417.         */
  3418.         public function forumQuoteAjaxAction(
  3419.             Request $request,
  3420.             ContentHelper $helper
  3421.         ) {
  3423.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
  3425.                 $id = $request->get("id");
  3426.                 if($id) {
  3427.                     $content = $helper->getContentById($id);
  3429.                     return new JsonResponse("<blockquote>".$content->getContentFull()."<br> -".$content->getAuthor()."</blockquote>");
  3431.                 }
  3432.                 else {
  3433.                     return null;
  3434.                 }
  3436.             } else {
  3438.             }
  3439.         }
  3441.         /**
  3442.         * @Route("/ajax/forum-images-upload")
  3443.         */
  3444.         public function forumUploadImage(
  3445.             Request $request,
  3446.             ContentHelper $helper
  3447.         ) {
  3448.             /*
  3449.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED') && ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1)) {
  3450.             $id = $request->get("id");
  3451.             return new JsonResponse("<blockquote>".$content->getContentFull()."<br> -".$content->getAuthor()."</blockquote>");
  3452.             }*/
  3453.             
  3454.             //$accepted_origins = array("http://localhost", "http://192.168.1.1", "http://example.com");
  3455.             
  3456.             $imageFolder = "uploads/forum/";
  3457.             
  3458.             reset ($_FILES);
  3459.             $temp = current($_FILES);
  3460.             if (is_uploaded_file($temp['tmp_name'])){
  3461.                 
  3462.                 // Sanitize input
  3463.                 if (preg_match("/([^\w\s\d\-_~,;:\[\]\(\).])|([\.]{2,})/", $temp['name'])) {
  3464.                     return new JsonResponse(array('error' => "Invalid file name."));
  3465.                 }
  3466.                 
  3467.                 // Verify extension
  3468.                 if (!in_array(strtolower(pathinfo($temp['name'], PATHINFO_EXTENSION)), array("gif", "jpg", "png"))) {
  3469.                     return new JsonResponse(array('error' => "Invalid file type."));
  3470.                 }
  3471.                 
  3472.                 // Make a unique filename
  3473.                 $filename = pathinfo($temp['name'], PATHINFO_FILENAME );
  3474.                 $ext = pathinfo($temp['name'], PATHINFO_EXTENSION);
  3475.                 
  3476.                 $filename = trim(trim(strtolower($filename)), '-');
  3477.                 $filename = str_replace(' ', '-', $filename);
  3478.                 $filename = preg_replace('/-+/', '-', $filename);
  3479.                 $filename = preg_replace('/[^a-z0-9-]/', '', $filename);
  3480.                 
  3481.                 $final_filename = $filename . "." . $ext;
  3482.                 $x = 2;
  3483.                 while(file_exists($imageFolder . $final_filename)) {
  3484.                     $final_filename = $filename . '-' . $x++ . "." . $ext;
  3485.                 }
  3486.                 
  3487.                 // Accept upload if there was no origin, or if it is an accepted origin
  3488.                 $filetowrite = $imageFolder . $final_filename;
  3489.                 move_uploaded_file($temp['tmp_name'], $filetowrite);
  3490.                 
  3491.                 //$filetowrite = $imageFolder . $temp['name'];
  3492.                 //move_uploaded_file($temp['tmp_name'], $filetowrite);
  3493.                 
  3494.                 // Respond to the successful upload with JSON.
  3495.                 // Use a location key to specify the path to the saved image resource.
  3496.                 return new JsonResponse(array('location' => "/".$filetowrite));
  3497.             } else {
  3498.                 // Notify editor that the upload failed
  3499.                 return new JsonResponse(array('error' => "500 Server Error."));
  3500.             }
  3501.             
  3502.         }
  3503.         
  3504.         /**
  3505.         * @Route("/ajax/ckeditor-image-upload")
  3506.         */
  3507.         public function ckeditorUploadImage(
  3508.             Request $request,
  3509.             ContentHelper $helper
  3510.         ) {
  3511.             
  3512.             if ($request->files->get("upload")) { //image field
  3513.                 
  3514.                 $uploaded_image = $request->files->get("upload");
  3515.                 
  3516.                 $mime = $uploaded_image->getMimeType();
  3517.                 if(!in_array($mime, ["image/jpg", "image/jpeg", "image/png", "image/gif"])) {
  3518.                     return new JsonResponse(array('error' => "Only PNG, JPG, and GIF file types are allowed."));
  3519.                 }
  3520.                 
  3521.                 $media = new Media();
  3522.                 $media->setTitle(pathinfo($uploaded_image->getClientOriginalName(), PATHINFO_FILENAME));
  3523.                 $media->setData($uploaded_image);
  3524.                 $media->setDescription("Image uploaded through CKEditor.");
  3525.                 $media->setName($uploaded_image->getClientOriginalName());
  3526.                 
  3527.                 $entityManager = $this->getDoctrine()->getManager();
  3528.                 $entityManager->persist($media);
  3529.                 $entityManager->flush();
  3530.                 
  3531.                 return new JsonResponse(array('url' => $media->getURL()));
  3532.             } else {
  3533.                 // Notify editor that the upload failed
  3534.                 return new JsonResponse(array('error' => "500 Server Error."));
  3535.             }
  3536.             
  3537.         }
  3539.         /**
  3540.         * @Route("/ajax/get-user-lead-info")
  3541.         */
  3542.         public function getUserLeadInfoAjaxAction(
  3543.             Request $request,
  3544.             ContentHelper $helper
  3545.         ) {
  3546.             if($this->user && ($this->user->isMember() || $this->user->isAdmin())) {
  3547.                 
  3548.                 $lead["firstname"] = $this->user->getUserMetaValueByKey("lead_firstname");
  3549.                 $lead["lastname"] = $this->user->getUserMetaValueByKey("lead_lastname");
  3550.                 $lead["company"] = $this->user->getUserMetaValueByKey("lead_company");
  3551.                 $lead["phone"] = $this->user->getUserMetaValueByKey("lead_phone");
  3552.                 $lead["email"] = $this->user->getUserMetaValueByKey("lead_email");
  3553.                 $lead["address1"] = $this->user->getUserMetaValueByKey("lead_address1");
  3554.                 $lead["address2"] = $this->user->getUserMetaValueByKey("lead_address2");
  3555.                 $lead["city"] = $this->user->getUserMetaValueByKey("lead_city");
  3556.                 $lead["state"] = $this->user->getUserMetaValueByKey("lead_state");
  3557.                 $lead["zip"] = $this->user->getUserMetaValueByKey("lead_zip");
  3558.                 $lead["country"] = $this->user->getUserMetaValueByKey("lead_country");
  3559.                 $lead["country_other"] = $this->user->getUserMetaValueByKey("lead_country_other");
  3560.                 $lead["contractor_type"] = $this->user->getUserMetaValueByKey("lead_contractor_type");
  3561.                 $lead["business_type"] = $this->user->getUserMetaValueByKey("lead_business_type");
  3562.                 
  3563.                 return new JsonResponse(json_encode($lead));
  3564.                 
  3565.             } else {
  3566.                 return new JsonResponse("");
  3567.             }
  3568.         }
  3569.         
  3570.         /**
  3571.         * @Route("/ajax/setSessionVariable")
  3572.         */
  3573.         public function setSessionVariableAjaxAction(
  3574.             Request $request
  3575.         ) {
  3576.             
  3577.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3578.                 
  3579.                 $key = $request->get("key");
  3580.                 $value = $request->get("value");
  3581.                 
  3582.                 if($key) {
  3583.                     $session = $request->getSession();
  3584.                     
  3585.                     if($value) {
  3586.                         $session->set($key, $value);
  3587.                     }
  3588.                     else {
  3589.                         $session->remove($key);
  3590.                     }
  3591.                     
  3592.                     return new JsonResponse("Session variable set.");
  3593.                 }
  3594.                 
  3595.             }
  3596.             
  3597.             return new JsonResponse("Session variable set.");
  3598.             
  3599.         }
  3600.         
  3601.         /**
  3602.         * @Route("/pollExport/{pollId}", name="poll_export")
  3603.         */
  3604.         public function pollExport(
  3605.             Request $request,
  3606.             PollHelper $pollHelper,
  3607.             $pollId = ""
  3608.         ) {
  3609.             
  3610.             $access = false;
  3611.             if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
  3612.                 $user = $this->getUser();
  3613.                 if($user) {
  3614.                     if($this->user->isAdmin()) {
  3615.                         $access = true;
  3616.                     }
  3617.                 }
  3618.             }
  3619.             
  3620.             $poll = $pollHelper->getPollById($pollId);
  3621.             $pollOptions = $poll->getPollOptions();
  3622.             $pollResponses = $poll->getPollResponses();
  3623.             
  3624.             //Export / Spreadsheet
  3625.             $spreadsheet = new Spreadsheet();
  3626.             
  3627.             $spreadsheet = new Spreadsheet();
  3628.             $sheet = $spreadsheet->getActiveSheet();
  3629.             
  3630.             //Sheet 1
  3631.             $rowNum = 1;
  3632.             $sheet->setTitle("Poll Results");
  3633.             $sheet->setCellValue("A{$rowNum}", "Poll Option");
  3634.             $sheet->setCellValue("B{$rowNum}", "Votes");
  3635.             $sheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3636.             $sheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3637.             $rowNum++;
  3638.             
  3639.             foreach($pollOptions as $pollOption) {
  3640.                 $sheet->setCellValue("A{$rowNum}", $pollOption->getText());
  3641.                 $sheet->setCellValue("B{$rowNum}", $pollOption->countResponses());
  3642.                 $rowNum++;
  3643.             }
  3644.             $sheet->setCellValue("A{$rowNum}", "Total:");
  3645.             $sheet->setCellValue("B{$rowNum}", $poll->countResponses());
  3646.             $sheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3647.             $sheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3648.             
  3649.             foreach(range("A",$sheet->getHighestColumn()) as $columnID) {
  3650.                 $sheet->getColumnDimension($columnID)
  3651.                     ->setAutoSize(true);
  3652.             }
  3653.             
  3654.             //Sheet 2
  3655.             $indSheet = new \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet($spreadsheet, 'Individual Votes');
  3656.             $spreadsheet->addSheet($indSheet, 0);
  3657.             
  3658.             $rowNum = 1;
  3659.             $indSheet->setTitle("Individual Votes");
  3660.             $indSheet->setCellValue("A{$rowNum}", "User");
  3661.             $indSheet->setCellValue("B{$rowNum}", "Vote");
  3662.             $indSheet->getStyle("A{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3663.             $indSheet->getStyle("B{$rowNum}")->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('FFDDDDDD');
  3664.             $rowNum++;
  3665.             
  3666.             foreach($pollResponses as $pollResponse) {
  3667.                 $indSheet->setCellValue("A{$rowNum}", $pollResponse->getUser() ? $pollResponse->getUser() : "anonymous");
  3668.                 $indSheet->setCellValue("B{$rowNum}", $pollResponse->getPollOption());
  3669.                 $rowNum++;
  3670.             }
  3671.             
  3672.             foreach(range("A",$indSheet->getHighestColumn()) as $columnID) {
  3673.                 $indSheet->getColumnDimension($columnID)
  3674.                     ->setAutoSize(true);
  3675.             }
  3676.             
  3677.             //Finish and save
  3678.             $spreadsheet->setActiveSheetIndexByName("Poll Results");
  3679.             $writer = new Xlsx($spreadsheet);
  3680.             $filename = "Poll Export {$pollId}.xlsx";
  3681.             $writer->save("../var/reports/polls/{$filename}");
  3682.             
  3683.             //return new JsonResponse($filename . " saved");
  3684.             
  3685.             //$filename = $request->request->get("filename");
  3686.             $response = new BinaryFileResponse("../var/reports/polls/{$filename}");
  3687.             $disposition = $response->headers->makeDisposition(
  3688.                 ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  3689.                 $filename
  3690.             );
  3691.             $response->headers->set('Content-Disposition', $disposition);
  3692.             return $response;
  3693.         }
  3695.         /**
  3696.         * @Route("/ajax/pollResponse")
  3697.         */
  3698.         public function addPollResponse(
  3699.             Request $request,
  3700.             PollHelper $pollHelper
  3701.         ) {
  3702.             
  3703.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  3704.                 
  3705.                 $pollId = $request->get("pollId");
  3706.                 $pollOptionId = $request->get("pollOptionId");
  3707.                 $userId = $request->get("userId");
  3708.                 
  3709.                 if($pollOptionId) {
  3710.                     $pollHelper->addPollResponse($pollOptionId, $userId ? $userId : NULL);
  3711.                     $results = $pollHelper->getPollResults($pollId);
  3712.                     //$results = implode(" ", $pollHelper->getPollResults($pollId));
  3713.                     return new JsonResponse($results);
  3714.                 }
  3715.                 
  3716.             }
  3717.             
  3718.             return new JsonResponse("Failure.");
  3719.             
  3720.         }
  3721.         
  3722.         /**
  3723.         * @Route("/ajax/pollResults")
  3724.         */
  3725.         public function getpollResultsAjax(
  3726.             Request $request,
  3727.             PollHelper $pollHelper,
  3728.             Environment $twig,
  3729.             $id = ""
  3730.         ) {
  3731.             try {
  3732.                 $id = $request->get("id");
  3733.                 
  3734.                 $poll = $pollHelper->getPollById($id);
  3735.                 
  3736.                 $tmpl = $twig->load("polls/admin-poll-results-embed.html.twig");
  3737.                 $html = $tmpl->render(
  3738.                 [
  3739.                     "poll" => $poll
  3740.                 ]);
  3741.                 
  3742.                 return new JsonResponse($html);
  3743.             }
  3744.             catch (\Exception $e) {
  3745.                 return new JsonResponse("<div>Error loading poll results.</div>");
  3746.                 //return new JsonResponse($e->getMessage());
  3747.             }
  3748.             
  3749.         }
  3751.         /**
  3752.         * @Route("/ajax/quizResults")
  3753.         */
  3754.         public function getQuizResultsAjax(
  3755.             Request $request,
  3756.             QuizHelper $quizHelper,
  3757.             Environment $twig,
  3758.             $id = ""
  3759.         ) {
  3760.             try {
  3761.                 $id = $request->get("id");
  3762.                 
  3763.                 $quiz = $quizHelper->getQuizById($id);
  3764.                 
  3765.                 $tmpl = $twig->load("quizzes/admin-quiz-results-embed.html.twig");
  3766.                 $html = $tmpl->render(
  3767.                 [
  3768.                     "quiz" => $quiz
  3769.                 ]);
  3770.                 
  3771.                 return new JsonResponse($html);
  3772.             }
  3773.             catch (\Exception $e) {
  3774.                 return new JsonResponse("<div>Error loading quiz results.</div>");
  3775.             }
  3776.             
  3777.         }
  3779.         /**
  3780.         * @Route("/ajax/contentUserViews")
  3781.         */
  3782.         public function getContentUserViews(
  3783.             Request $request,
  3784.             ContentHelper $contentHelper,
  3785.             Environment $twig,
  3786.             $id = ""
  3787.         ) {
  3788.             //return false;
  3789.             try {
  3790.                 $id = $request->get("id");
  3791.                 $content = $contentHelper->getContentById($id);
  3793.                 $entityManager = $this->getDoctrine()->getManager();
  3799.                 //TODO: Make a service for this
  3800.                 
  3801.                 //Google Analytics
  3802.                 $year = date("Y");
  3803.                 $month = date("n");
  3805.                 //$startDate = date("Y-m-d", strtotime($year."-".$month."-"."01"));
  3806.                 $startDate = date("Y-m-d", strtotime("2020-10-"."01")); //when we started using this custom dimension
  3807.                 //$startDate = new \DateTime($startDate);
  3808.                 $endDate = date("Y-m-t", strtotime($year."-".$month."-01"));
  3809.                 //$endDate = new \DateTime($endDate." 23:59:59");
  3810.                 
  3811.                 $client = new \Google_Client();
  3812.                 $client->setApplicationName("RCS Analytic Reports");
  3813.                 $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
  3814.                 $client->setAuthConfig($KEY_FILE_LOCATION);
  3815.                 $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
  3817.                 $analytics = new \Google_Service_AnalyticsReporting($client);
  3818.                 $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  3819.                 $dateRange->setStartDate($startDate);
  3820.                 $dateRange->setEndDate($endDate);
  3822.                 $views = new \Google_Service_AnalyticsReporting_Metric();
  3823.                 $views->setExpression("ga:pageviews");
  3824.                 $views->setAlias("pageviews");
  3826.                 $path = new \Google_Service_AnalyticsReporting_Dimension();
  3827.                 $path->setName("ga:pagePath");
  3829.                 $rcsUserID = new \Google_Service_AnalyticsReporting_Dimension();
  3830.                 $rcsUserID->setName("ga:dimension2");
  3831.                 
  3832.                 // Create the DimensionFilter.
  3833.                 $dimensionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
  3834.                 
  3835.                 //Should be faster. Need to set for each job.
  3836.                 $dimensionFilter->setDimensionName('ga:pagePath');
  3837.                 $dimensionFilter->setOperator('IN_LIST');
  3838.                 $dimensionFilter->setExpressions([$content->getURL(1)]);
  3839.                 //$dimensionFilter->setExpressions(["/news-room"]);
  3840.                 
  3841.                 // Create the DimensionFilterClauses
  3842.                 $dimensionFilterClause = new \Google_Service_AnalyticsReporting_DimensionFilterClause();
  3843.                 $dimensionFilterClause->setFilters(array($dimensionFilter));
  3846.                 $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  3847.                 $request->setViewId("126182454"); //< Unfiltered Website Data
  3848.                 $request->setDateRanges($dateRange);
  3849.                 $request->setDimensions(array($path, $rcsUserID));
  3850.                 $request->setDimensionFilterClauses(array($dimensionFilterClause));
  3851.                 $request->setMetrics(array($views));
  3853.                 $request->setPageSize("10000");
  3854.                 //$request->setPageSize("10");
  3855.                 
  3856.                 $order = new \Google_Service_AnalyticsReporting_OrderBy;
  3857.                 $order->setFieldName("ga:pageviews");
  3858.                 $order->setOrderType("VALUE");
  3859.                 $order->setSortOrder("DESCENDING");
  3860.                 $orders[] = $order;
  3861.                 $request->setOrderBys($orders);
  3863.                 $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  3864.                 $body->setReportRequests(array($request));
  3865.                 $reports = $analytics->reports->batchGet($body);
  3866.                 
  3867.                 
  3868.                 $data = [];
  3869.                 for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
  3870.                     $report = $reports[$reportIndex];
  3871.                     $header = $report->getColumnHeader();
  3872.                     $dimensionHeaders = $header->getDimensions();
  3873.                     $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  3874.                     $rows = $report->getData()->getRows();
  3876.                     for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  3877.                         $row = $rows[$rowIndex];
  3878.                         $dimensions = $row->getDimensions();
  3879.                         $metrics = $row->getMetrics();
  3881.                         $path = "";
  3882.                         $rcsUserID = "";
  3883.                         $count = 0;
  3885.                         for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  3886.                             
  3887.                             if ($dimensionHeaders[$i] == "ga:pagePath") {
  3888.                                 $path = $dimensions[$i];
  3889.                             }
  3891.                             if ($dimensionHeaders[$i] == "ga:dimension2") {
  3892.                                 $rcsUserID = $dimensions[$i];
  3893.                             }
  3895.                         }
  3897.                         
  3898.                         $count = $metrics[0]->getValues()[0];
  3899.                         
  3900.                         
  3901.                         //strip any url parameters
  3902.                         //$path = strtok($path, "?");
  3904.                         //for ($j = 0; $j < count($metricHeaders) && $j < count($metrics); $j++) {
  3905.                         //    $entry = $metricHeaders[$j];
  3906.                         //    $values = $metrics[$j];
  3908.                         //    for ($valueIndex = 0; $valueIndex < count($values->getValues()); $valueIndex++) {
  3909.                         //        $value = $values->getValues()[$valueIndex];
  3910.                         //        $count = $value;
  3911.                         //    }
  3912.                         //}
  3913.                         
  3915.                         //if (!isset($data[$path])) {
  3916.                         //    $data[$path] = array();
  3917.                         //}
  3918.                         //if (!isset($data[$path][$rcsUserID])) {
  3919.                         //    $data[$path][$rcsUserID] = $count;
  3920.                         //}
  3921.                         //else {
  3922.                         //    $data[$path][$rcsUserID] += $count;
  3923.                         //}
  3924.                         
  3925.                         if (!isset($data[$rcsUserID])) {
  3926.                             $user = $entityManager
  3927.                                 ->getRepository(User::class)
  3928.                                 ->findOneBy(["id" => $rcsUserID]);
  3929.                             $data[$rcsUserID] = ["views" => $count, "user" => $user];
  3930.                         }
  3932.                     }
  3933.                 }
  3934.                 foreach($data as $key => $value) {
  3935.                     
  3936.                     /*
  3937.                     if($key == "/") { continue; }
  3938.                     
  3939.                     $pos = strrpos($key, '/');
  3940.                     $slug = $pos === false ? $key : substr($key, $pos + 1);
  3941.                     
  3942.                     $arr = explode("?", $slug, 2);
  3943.                     $slug = $arr[0];
  3944.                     
  3945.                     if(!$slug) { continue; }
  3947.                     $content = $entityManager
  3948.                         ->getRepository(Content::class)
  3949.                         ->findOneBy(["slug" => $slug]);
  3950.                     
  3951.                     if($content) {
  3952.                         $edit_links[$key] = "/admin/content/". $content->getId() . "/edit";
  3953.                         //TODO: Handle switching sites when editing.
  3954.                         //$edit_links[$key] = "/admin/content/". $content->getId() . "/edit?site=". $content->getSite();
  3955.                     }
  3956.                     */
  3957.                 }
  3958.                 
  3965.                 //Just copying above code for single week to get up in time for the meeting. Will clean up later.
  3967.                 $year = date("Y");
  3968.                 $month = date("n");
  3969.                 $day = date("d");
  3970.                 
  3971.                 $startDate = date('Y-m-d', strtotime('-1 week'));
  3972.                 $endDate = date("Y-m-d");
  3973.                 
  3974.                 $client = new \Google_Client();
  3975.                 $client->setApplicationName("RCS Analytic Reports");
  3976.                 $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
  3977.                 $client->setAuthConfig($KEY_FILE_LOCATION);
  3978.                 $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
  3980.                 $analytics = new \Google_Service_AnalyticsReporting($client);
  3981.                 $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  3982.                 $dateRange->setStartDate($startDate);
  3983.                 $dateRange->setEndDate($endDate);
  3985.                 $views = new \Google_Service_AnalyticsReporting_Metric();
  3986.                 $views->setExpression("ga:pageviews");
  3987.                 $views->setAlias("pageviews");
  3989.                 $path = new \Google_Service_AnalyticsReporting_Dimension();
  3990.                 $path->setName("ga:pagePath");
  3992.                 $rcsUserID = new \Google_Service_AnalyticsReporting_Dimension();
  3993.                 $rcsUserID->setName("ga:dimension2");
  3994.                 
  3995.                 $dimensionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
  3996.                 
  3997.                 $dimensionFilter->setDimensionName('ga:pagePath');
  3998.                 $dimensionFilter->setOperator('IN_LIST');
  3999.                 $dimensionFilter->setExpressions([$content->getURL(1)]);
  4000.                 
  4001.                 // Create the DimensionFilterClauses
  4002.                 $dimensionFilterClause = new \Google_Service_AnalyticsReporting_DimensionFilterClause();
  4003.                 $dimensionFilterClause->setFilters(array($dimensionFilter));
  4006.                 $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  4007.                 $request->setViewId("126182454"); //< Unfiltered Website Data
  4008.                 $request->setDateRanges($dateRange);
  4009.                 $request->setDimensions(array($path, $rcsUserID));
  4010.                 $request->setDimensionFilterClauses(array($dimensionFilterClause));
  4011.                 $request->setMetrics(array($views));
  4013.                 $request->setPageSize("10000");
  4014.                 //$request->setPageSize("10");
  4015.                 
  4016.                 $order = new \Google_Service_AnalyticsReporting_OrderBy;
  4017.                 $order->setFieldName("ga:pageviews");
  4018.                 $order->setOrderType("VALUE");
  4019.                 $order->setSortOrder("DESCENDING");
  4020.                 $orders[] = $order;
  4021.                 $request->setOrderBys($orders);
  4023.                 $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  4024.                 $body->setReportRequests(array($request));
  4025.                 $reports = $analytics->reports->batchGet($body);
  4026.                 
  4027.                 
  4028.                 $dataweek = [];
  4029.                 for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
  4030.                     $report = $reports[$reportIndex];
  4031.                     $header = $report->getColumnHeader();
  4032.                     $dimensionHeaders = $header->getDimensions();
  4033.                     $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  4034.                     $rows = $report->getData()->getRows();
  4036.                     for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  4037.                         $row = $rows[$rowIndex];
  4038.                         $dimensions = $row->getDimensions();
  4039.                         $metrics = $row->getMetrics();
  4041.                         $path = "";
  4042.                         $rcsUserID = "";
  4043.                         $count = 0;
  4045.                         for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  4046.                             
  4047.                             if ($dimensionHeaders[$i] == "ga:pagePath") {
  4048.                                 $path = $dimensions[$i];
  4049.                             }
  4051.                             if ($dimensionHeaders[$i] == "ga:dimension2") {
  4052.                                 $rcsUserID = $dimensions[$i];
  4053.                             }
  4055.                         }
  4057.                         $count = $metrics[0]->getValues()[0];
  4058.                         
  4059.                         if (!isset($dataweek[$rcsUserID])) {
  4060.                             $user = $entityManager
  4061.                                 ->getRepository(User::class)
  4062.                                 ->findOneBy(["id" => $rcsUserID]);
  4063.                             $dataweek[$rcsUserID] = ["views" => $count, "user" => $user];
  4064.                         }
  4066.                     }
  4067.                 }
  4077.                 
  4078.                 $tmpl = $twig->load("sonata_admin/content-user-views-embed.html.twig");
  4079.                 $html = $tmpl->render(
  4080.                 [
  4081.                     "content" => $content,
  4082.                     "data" => $data,
  4083.                     "dataweek" => $dataweek,
  4084.                     //"rows" => $rows,
  4085.                 ]);
  4086.                 
  4087.                 return new JsonResponse($html);
  4088.             }
  4089.             catch (\Exception $e) {
  4090.                 //return new JsonResponse("<div>Error loading results.</div>");
  4091.                 return new JsonResponse($e->getMessage());
  4092.             }
  4093.             
  4094.         }
  4096.         /**
  4097.         * @Route("/ajax/accept-cookies")
  4098.         */
  4099.         public function acceptCookiesAjaxAction(
  4100.             Request $request
  4101.         ) {
  4102.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  4103.                 $user = $this->user;
  4104.                 if($user) {
  4105.                     $user->setUsermetum("acceptCookies", "1");
  4106.                     $entityManager = $this->getDoctrine()->getManager();
  4107.                     $entityManager->persist($user);
  4108.                     $entityManager->flush();
  4109.                     return new JsonResponse("1");
  4110.                 }
  4111.             }
  4112.             return new JsonResponse("0");
  4113.         }
  4114.         
  4115.         /**
  4116.         * @Route("/ajax/set-preferred-language")
  4117.         */
  4118.         public function preferredLanguageAjaxAction(
  4119.             Request $request
  4120.         ) {
  4121.             
  4122.             if ($request->isXmlHttpRequest() || $request->query->get('showJson') == 1) {
  4123.                 $user = $this->user;
  4124.                 $language = $request->get("language");
  4125.                 if($user && $language) {
  4126.                     $contact = $user->getContact();
  4127.                     if($contact) {
  4128.                         $contact->setPreferredLanguage($language);
  4129.                         $entityManager = $this->getDoctrine()->getManager();
  4130.                         $entityManager->persist($contact);
  4131.                         $entityManager->flush();
  4132.                         return new JsonResponse("1");
  4133.                     }
  4134.                 }
  4135.             }
  4136.             return new JsonResponse("0");
  4137.             
  4138.         }
  4141.         // @Route("/testtesttest", methods={"POST"})
  4142.         
  4143.         /**
  4144.         * @Route("/testtesttesths")
  4145.         */
  4146.         public function testtesttesths(
  4147.             Request $request,
  4148.             ContentHelper $contentHelper,
  4149.             CustomerHelper $customerHelper,
  4150.             HootsuiteHelper $hootsuiteHelper
  4151.         ) {    
  4152.             // get image from post request
  4153.             // $image = $request->files->get("image");
  4155.             // $imgObj = [
  4156.             //     "image" => $image->getPathname(),
  4157.             //     "mime" => $image->getMimeType(),
  4158.             //     "size" => $image->getSize(),
  4159.             // ];
  4161.             // $respUploadCreate = $hootsuiteHelper->createMediaUploadUri($imgObj);
  4162.             // $respUploadCreate = json_decode($respUploadCreate, true);
  4163.             // $respUploadCreate = $respUploadCreate['data'];
  4164.             // $respUpload = $hootsuiteHelper->uploadMedia($respUploadCreate['uploadUrl'], $imgObj);
  4165.             // sleep(5); // waiting to be sure that it's ready
  4166.             // $uploaded = $hootsuiteHelper->confirmMediaUpload($respUploadCreate['id']);
  4170.             // $resp = [
  4171.             //     "uploadCreate" => $respUploadCreate,
  4172.             //     "upload" => $uploaded,
  4173.             // ];
  4176.             //$resp = $hootsuiteHelper->schedulePost("Test post from RCS \n\n\n@AskARooferRCS ", [$respUploadCreate['id']], [125189773], "2025-01-01T12:12:00Z");
  4177.             //$resp = $hootsuiteHelper->schedulePost("Test post from RCS \n\n\n@AskARooferRCS ", [], [125189773, 7563642], "2025-01-01T12:12:00Z");
  4180.             return $this->defaultRender("test.html.twig", [
  4181.                 //"data" => json_decode($resp)
  4182.             ]);
  4183.         
  4184.             
  4188.             // $code = "q_muwsc8MGw2zqzDnrn37pj4GcVWYrXCVU5o9fsPr0E.ck04oiLoHqmDPSI5TD0va63-qFf_PYa4WJcZmRpwWK4";
  4189.             // $resp = $hootsuiteHelper->getMessage(12882399827);
  4191.             // schedulePost
  4192.             // $resp = $hootsuiteHelper->getSocialProfiles();
  4193.             //$hootsuiteHelper->updateSocialProfiles();
  4194.             // return new JsonResponse(json_encode(print_r($resp)), 200, [], true);
  4195.             // return new JsonResponse($tokens);
  4196.             //return new JsonResponse("testtestteset");
  4197.             
  4198.         }
  4212.         /**
  4213.         * @Route("/testtesttestga")
  4214.         */
  4215.         public function testtesttestga(
  4216.             Request $request,
  4217.             ContentHelper $contentHelper,
  4218.             CustomerHelper $customerHelper
  4219.         ) {
  4220.             //return false;
  4222.             //try {
  4223.             
  4224.                 set_time_limit(600);
  4225.                 
  4226.                 /*
  4227.                 $slug = $request->get("slug");
  4228.                 if(!$slug) {
  4229.                     throw new \Exception('Invalid directory.');
  4230.                 }
  4231.                 */
  4232.                 
  4233.                 if($request->request->has("date_start") && $request->request->has("date_end")
  4234.                     && $request->request->get("date_start") && $request->request->get("date_end")) {
  4235.                     $startDate = date("Y-m-d", strtotime($request->request->get("date_start")));
  4236.                     $startDate = new \DateTime($startDate);
  4237.                     
  4238.                     $endDate = date("Y-m-d", strtotime($request->request->get("date_end")));
  4239.                     $endDate = new \DateTime($endDate." 23:59:59");
  4240.                 }
  4241.                 elseif($request->request->has("date_start_current") && $request->request->has("date_end_current")
  4242.                     && $request->request->get("date_start_current") && $request->request->get("date_end_current")) {
  4243.                     $startDate = date("Y-m-d", strtotime($request->request->get("date_start_current")));
  4244.                     $startDate = new \DateTime($startDate);
  4245.                     
  4246.                     $endDate = date("Y-m-d", strtotime($request->request->get("date_end_current")));
  4247.                     $endDate = new \DateTime($endDate." 23:59:59");
  4248.                 }
  4249.                 else {
  4250.                     $year = date("Y");
  4251.                     $month = date("n");
  4252.                     
  4253.                     $startDate = date("Y-m-d", strtotime($year."-".$month."-"."01"));
  4254.                     $startDate = new \DateTime($startDate);
  4255.                     $endDate = date("Y-m-t", strtotime($year."-".$month."-"."01"));
  4256.                     $endDate = new \DateTime($endDate." 23:59:59");
  4257.                 }
  4258.                 
  4259.                 
  4260.                 $data =[];
  4261.                 foreach(SiteConfig::CONFIGS as $site_config) {
  4262.                     
  4263.                     if($site_config["id"] != 1/*!isset($site_config["ga_view_id"])*/) {
  4264.                         continue;
  4265.                     }
  4266.     
  4267.                     // 3/14/2019 removing source...
  4268.                     $client = new \Google_Client();
  4269.                     $client->setApplicationName("RCS Analytic Reports");
  4270.                     //$KEY_FILE_LOCATION = __DIR__ . '/My Project-4e8eeee2693a.json';
  4271.                     $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS-AnalyticReports-9cf5364bc460.json';
  4272.                     //$KEY_FILE_LOCATION = __DIR__ . '/' . $site_config["analytics_key_file"];
  4273.                     $client->setAuthConfig($KEY_FILE_LOCATION);
  4274.                     $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
  4275.     
  4276.                     $analytics = new \Google_Service_AnalyticsReporting($client);
  4277.                     $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
  4278.                     $dateRange->setStartDate($startDate->format('Y-m-d'));
  4279.                     $dateRange->setEndDate($endDate->format('Y-m-d'));
  4280.     
  4281.                     $avgTimeOnPage = new \Google_Service_AnalyticsReporting_Metric();
  4282.                     $avgTimeOnPage->setExpression("ga:avgTimeOnPage");
  4283.                     $avgTimeOnPage->setAlias("avgTimeOnPage");
  4284.     
  4285.                     $path = new \Google_Service_AnalyticsReporting_Dimension();
  4286.                     $path->setName("ga:pagePath");
  4287.     
  4288.                     //$medium = new \Google_Service_AnalyticsReporting_Dimension();
  4289.                     //$medium->setName("ga:medium");
  4290.     
  4291.     
  4292.                     $request = new \Google_Service_AnalyticsReporting_ReportRequest();
  4293.                     //$request->setViewId("126182454"); //< Unfiltered Website Data
  4294.                     $request->setViewId($site_config["ga_view_id"]); //< Unfiltered Website Data
  4295.                     $request->setDateRanges($dateRange);
  4296.                     $request->setDimensions(array($path));
  4297.                     //$request->setDimensions(array($path, $medium));
  4298.                     $request->setMetrics(array($avgTimeOnPage));
  4299.     
  4300.                     $request->setPageSize("10000");
  4301.     
  4302.                     $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
  4303.                     $body->setReportRequests(array($request));
  4304.                     $reports = $analytics->reports->batchGet($body);
  4305.                     
  4306.     
  4307.     
  4308.                     /*
  4309.                     //If we ever have more than 10,000 results, we'll need to filter them or do something like this
  4310.     
  4311.                     // Remove count if you really want everything.
  4312.                     $cnt = 0;
  4313.                     while ($reports->reports[0]->nextPageToken > 0 && $cnt < 10) {
  4314.                         $body->reportRequests[0]->setPageToken($reports->reports[0]->nextPageToken);
  4315.                         $reports = $analytics->reports->batchGet( $body );
  4316.                         $cnt++;
  4317.                     }
  4318.                     */
  4319.     
  4320.                     
  4321.                     // 3/13/2019 removing source
  4322.                     $data[$site_config['id']] = [];
  4323.     
  4324.                     for ($reportIndex = 0; $reportIndex < count($reports); $reportIndex++) {
  4325.                         $report = $reports[$reportIndex];
  4326.                         $header = $report->getColumnHeader();
  4327.                         $dimensionHeaders = $header->getDimensions();
  4328.                         $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
  4329.                         $rows = $report->getData()->getRows();
  4330.     
  4331.                         for ($rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
  4332.                             $row = $rows[$rowIndex];
  4333.                             $dimensions = $row->getDimensions();
  4334.                             $metrics = $row->getMetrics();
  4335.     
  4336.                             $path = "";
  4337.                             //$medium = "";
  4338.                             $count = 0;
  4339.     
  4340.                             for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
  4341.     
  4342.                                 if ($dimensionHeaders[$i] == "ga:pagePath") {
  4343.                                     $path = $dimensions[$i];
  4344.                                 }
  4345.     
  4346.                                 /*if ($dimensionHeaders[$i] == "ga:medium") {
  4347.                                     $medium = $dimensions[$i];
  4348.                                 }*/
  4349.     
  4350.                             }
  4351.     
  4352.                             //strip any url parameters
  4353.                             $path = strtok($path, "?");
  4354.     
  4355.                             for ($j = 0; $j < count($metricHeaders) && $j < count($metrics); $j++) {
  4356.                                 $entry = $metricHeaders[$j];
  4357.                                 $values = $metrics[$j];
  4358.     
  4359.                                 for ($valueIndex = 0; $valueIndex < count($values->getValues()); $valueIndex++) {
  4360.                                     $value = $values->getValues()[$valueIndex];
  4361.                                     //$count = $value;
  4362.                                 }
  4363.                             }
  4364.     
  4365.                             if (!isset($data[$site_config['id']][$path])) {
  4366.                                 $data[$site_config['id']][$path] = (int)$value;
  4367.                             }
  4368.                             /*if (!isset($data[$path]["avgTimeOnPage"])) {
  4369.                                 $data[$path]["avgTimeOnPage"] = $value;
  4370.                             }*/
  4371.                             /*if (!isset($data[$path][$medium])) {
  4372.                                 $data[$path][$medium] = (int)$count;
  4373.                             }
  4374.                             else {
  4375.                                 $data[$path][$medium] += (int)$count;
  4376.                             }*/
  4377.     
  4378.                         }
  4379.                     }
  4380.                     $data[$site_config['id']] = $reports;
  4381.                     //echo "<pre>";var_dump($data);exit;
  4382.                 }
  4383.             //}
  4389.             return $this->defaultRender("test.html.twig", [
  4390.                 "data" => $data
  4391.             ]);
  4393.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
  4395.         }
  4398.         /**
  4399.         * @Route("/testtesttestga2")
  4400.         */
  4401.         public function testtesttestga2(
  4402.             Request $request,
  4403.             ContentHelper $contentHelper,
  4404.             CustomerHelper $customerHelper
  4405.         ) {
  4406.             //return false;
  4408.             /**
  4409.              * TODO(developer): Replace this variable with your Google Analytics 4
  4410.              *   property ID before running the sample.
  4411.              */
  4412.             //$property_id = 'YOUR-GA4-PROPERTY-ID';
  4413.             $property_id = '320922983';
  4414.             
  4415.             // Using a default constructor instructs the client to use the credentials
  4416.             // specified in GOOGLE_APPLICATION_CREDENTIALS environment variable.
  4417.             //$client = new BetaAnalyticsDataClient();
  4418.             $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS Analytics-70262098a89a.json';
  4419.             $client = new BetaAnalyticsDataClient([
  4420.                 'credentials' => $KEY_FILE_LOCATION
  4421.             ]);
  4422.             
  4423.             // Make an API call.
  4424.             $request = (new RunReportRequest())
  4425.                 ->setProperty('properties/' . $property_id)
  4426.                 ->setDateRanges([
  4427.                     new DateRange([
  4428.                         'start_date' => '2024-03-31',
  4429.                         'end_date' => 'today',
  4430.                     ]),
  4431.                 ])
  4432.                 ->setDimensions([new Dimension([
  4433.                         'name' => 'city',
  4434.                     ]),
  4435.                 ])
  4436.                 ->setMetrics([new Metric([
  4437.                         'name' => 'activeUsers',
  4438.                     ])
  4439.                 ]);
  4440.             $response = $client->runReport($request);
  4441.             
  4442.             // Print results of an API call.
  4443.             
  4444.             $print =  'Report result: ' . PHP_EOL;
  4445.             
  4446.             foreach ($response->getRows() as $row) {
  4447.                 $print .= $row->getDimensionValues()[0]->getValue()
  4448.                     . ' ' . $row->getMetricValues()[0]->getValue() . PHP_EOL;
  4449.             }
  4450.             
  4451.             
  4454.             
  4456.             $data = [];
  4457.             return $this->defaultRender("test.html.twig", [
  4458.                 //"data" => $data
  4459.                 //"data" => $response
  4460.                 "data" => $print
  4461.             ]);
  4463.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
  4465.         }
  4468.         /**
  4469.         * @Route("/testtimeonpage")
  4470.         */
  4471.         public function testtimeonpage(
  4472.             Request $request,
  4473.             ContentHelper $contentHelper,
  4474.             CustomerHelper $customerHelper
  4475.         ) {
  4476.             //return false;
  4477.             $property_id = '320922983';
  4478.             $KEY_FILE_LOCATION = __DIR__ . '/../RCS/RCS Analytics-70262098a89a.json';
  4479.             $client = new BetaAnalyticsDataClient([
  4480.                 'credentials' => $KEY_FILE_LOCATION
  4481.             ]);
  4482.             
  4483.             // Make an API call.
  4484.             $request = (new RunReportRequest())
  4485.                 ->setProperty('properties/' . $property_id)
  4486.                 ->setDateRanges([
  4487.                     new DateRange([
  4488.                         'start_date' => '2024-04-01',
  4489.                         'end_date' => '2024-04-30',
  4490.                     ]),
  4491.                 ])
  4492.                 ->setDimensions([new Dimension([
  4493.                         'name' => 'pagePath',
  4494.                     ]),
  4495.                 ])
  4496.                 ->setMetrics([
  4497.                     new Metric(['name' => 'userEngagementDuration']),
  4498.                     new Metric(['name' => 'activeUsers'])
  4499.                 ]);
  4500.             $response = $client->runReport($request);
  4501.             
  4502.             // Print results of an API call.
  4503.                 
  4504.             $print =  'Report result: ' . PHP_EOL;
  4505.         
  4506.             foreach ($response->getRows() as $row) {
  4507.                 $print .= $row->getDimensionValues()[0]->getValue()
  4508.                     //. ' ' . $row->getMetricValues()[0]->getValue() . PHP_EOL;
  4509.                     . ' ' . $row->getMetricValues()[0]->getValue()
  4510.                     . ' ' . $row->getMetricValues()[1]->getValue() . PHP_EOL;
  4511.             }
  4512.             
  4513.             //$print = \Doctrine\Common\Util\Debug::dump($response, 4);
  4517.             
  4519.             $data = [];
  4520.             return $this->defaultRender("test.html.twig", [
  4521.                 //"data" => $data
  4522.                 //"data" => $response
  4523.                 "data" => $print
  4524.             ]);
  4526.             //return new JsonResponse(json_encode(print_r($data)), 200, [], true);
  4528.         }
  4531.         /**
  4532.         * @Route("/thecoffeeshops")
  4533.         */
  4534.         public function thecoffeeshops(
  4535.             Request $request
  4536.         ) {    
  4537.             return $this->defaultRender("thecoffeeshops.html.twig", [
  4538.                 //"data" => json_decode($resp)
  4539.             ]);
  4540.         }
  4542.     
  4543. }