src/NCBS/WebsiteBundle/Controller/ExpositionController.php line 133

Open in your IDE?
  1. <?php
  3. namespace NCBS\WebsiteBundle\Controller;
  5. use Doctrine\ORM\EntityManager;
  6. use Doctrine\ORM\Query\ResultSetMapping;
  7. use NCBS\WebsiteBundle\Controller\SearchController;
  8. use NCBS\WebsiteBundle\Entity\Exposition;
  9. use NCBS\WebsiteBundle\Tools\DataAssembly;
  10. use NCBS\WebsiteBundle\Tools\PostgresSearch;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\HttpFoundation\Request;
  14. class ExpositionController extends NCBSWController
  15. {
  16.   
  17.     protected $prefix = 'Exposition';
  19.     // Overriding this to automatically pass list of Swedenborg works to every template
  20.     // (easier to program than trying to figure out which ones need it and which don't)
  21.     public function renderView($view, array $parameters = array(), Response $response = null)
  22.     {    
  23.         return parent::renderView($view, $parameters, $response);
  24.     }
  26.     // Given a Work or Translation, checks whether it would be better to view as some other entity type
  27.     // (currently can redirect only to concepts)
  28.     // Returns null if no redirect is necessary or a null argument is provided, or false if an unknown argument type is supplied
  29.     // Otherwise, returns url to redirect to
  30.     protected function checkRedirect($target)
  31.     {
  32.    /*     if($target === null) {
  33.             return null;
  34.         } elseif($target instanceof Exposition\Translation) {
  35.             $targetTranslation = $target;
  36.         } elseif($target instanceof Exposition\Work) {
  37.             $targetTranslation = $target->selectTranslation();
  38.         } else {
  39.             return null;
  40.         }
  41.         
  42.         if($targetTranslation == null)
  43.             return null;
  44.             
  45.         $sConceptUrl = $this->checkConcept($targetTranslation->getId());    
  46.         if(!empty($sConceptUrl))
  47.         {
  48.             $url = $this->get('router')->generate('concept', array(
  49.                     'conceptUrl' => $sConceptUrl
  50.                 ));
  51.                 
  52.             $args = @$_SERVER['QUERY_STRING'];
  53.             if(!empty($args)) 
  54.             {                
  55.                 $url .= '?'.$args;                   
  56.             } 
  57.             
  58.             return $url;
  59.         }    */
  60.                     
  61.         return null;
  62.     }
  64.     protected function selectSelectorList($work, $languageName = 'English', $currentTranslation = null)
  65.     {
  66.         if($work === null) {
  67.             return null;
  68.         }
  70.         if($work->getSwedenborgType() !== null) {
  71.             return $this->buildSwedenborgSelectorList($languageName, $currentTranslation);
  72.         }
  74.         $list = array();
  75.         foreach($work->getCategories() as $category) {
  76.             if($category->getIndexPage() !== null) {
  77.                 $catName = $category->getName();
  78.                 $list[$catName] = array();
  79.                 foreach($category->getWorks() as $w) {
  80.                     $t = $w->selectTranslation($languageName);
  81.                     if($t != null)
  82.                         $list[$catName][$t->getTranslatedTitle()] = ($work == $w) ? null : $t;
  83.                 }
  84.                 ksort($list[$catName]);
  85.             }
  86.         }
  88.         if(empty($list)) {
  89.             return null;
  90.         } else {
  91.             return $list;
  92.         }
  93.     }
  95.     protected function buildSwedenborgSelectorList($languageName = 'English', $currentTranslation = null)
  96.     {
  97.         $allWorks = $this->expositionData('Work')->findByIsPublic(true);
  98.         $swedenborgBooks = array(
  99. //            'Published Theological Works' => array(),
  100. //            'Posthumous Theological Works' => array(),
  101. //            'Pre-Revelatory Works' => array()
  102.         );
  103.         foreach($allWorks as $work) {
  104.             if($work->getSwedenborgType() !== null) {
  105.                 if($currentTranslation !== null && $currentTranslation->getWork() == $work) {
  106.                     $translation = $currentTranslation;
  107.                 } else {
  108.                     $translation = $work->selectTranslation($languageName);
  109.                 }
  110.                 if($translation !== null) {
  111.                     $title = $translation->getTranslatedTitle();
  112.                     $swedenborgBooks[$title] = $translation;
  113. /*
  114.                     if($work->getSwedenborgType() == 'published revelatory') {
  115.                         $swedenborgBooks['Published Theological Works'][$title] = $translation;
  116.                     } elseif($work->getSwedenborgType() == 'posthumous revelatory') {
  117.                         $swedenborgBooks['Posthumous Theological Works'][$title] = $translation;
  118.                     } else { // 'published pre-revelatory' or 'posthumous pre-revelatory'
  119.                         $swedenborgBooks['Pre-Revelatory Works'][$title] = $translation;
  120.                     }
  121. */
  122.                 }
  123.             }
  124.         }
  125.         ksort($swedenborgBooks);
  126. //        ksort($swedenborgBooks['Published Theological Works']);
  127. //        ksort($swedenborgBooks['Posthumous Theological Works']);
  128. //        ksort($swedenborgBooks['Pre-Revelatory Works']);
  130.         return array("Swedenborg's Theological Works" => $swedenborgBooks);
  131.     }
  133.     public function swedenborgIndexAction(Request $request)
  134.     {
  135.     /*    
  136.         $locale = $request->getLocale();
  137.         $nLanguageID = $this->getLanguageIDByShortCode($locale);
  138.         return $this->renderView('index/swedenborg', array(          
  139.             'selector_data' => $this->getCategorizedSwedenborgWorks($request, $nLanguageID),
  140.             'illustration' => $this->getRepository('Media\Image')->findOneByFile('quill-pen.jpg'),
  141.             'index_path' => 'swedenborg'
  142.         )); */
  143.         
  144.         $this->setCurrentUrl($request); 
  145.         $this->onloadPage($request);
  146.         $locale = $request->getLocale();
  147.         $nLocaleLanguageID = $this->getLanguageIDByShortCode($locale);
  148.         
  149.         $nSelectedLangID = $request->query->get('l');
  150.         
  151.         return $this->renderView('index/swedenborg', array(          
  152.             'works' => $this->getSwedenborgWorks($request, $nLocaleLanguageID, $nSelectedLangID),
  153.             'works2' => $this->getSwedenborgWorks2($request, $nLocaleLanguageID, $nSelectedLangID),
  154.             'languages' => $this->getSwedenborgWorkLanguages($request),
  155.             'selected_language_id' => $nSelectedLangID,
  156.             'search_domain' => 'w'
  157.         ));
  158.     }
  160.     public function conceptsIndexAction(Request $request)
  161.     {        
  162.         $this->setCurrentUrl($request); 
  163.         $this->onloadPage($request);
  164.         return $this->renderView('index/concepts', array('index_path' => 'concepts', 'selector_data' => array('Bible Words Explained' => $conceptSelection)));
  165.     }
  166.         
  167.     public function considerIndexAction(Request $request)
  168.     {                       
  169.         $this->setCurrentUrl($request); 
  170.         $this->onloadPage($request);
  171.         $locale = $request->getLocale();
  172.         $aPathway = $this->getTopPathList($locale);
  173.         return $this->renderView('index/spiritual_topics', array(     
  174.             'pathway_list' => $aPathway            
  175.         ));
  176.     }
  178.     public function educationalMaterialsIndexAction(Request $request)
  179.     {
  180.         $this->setCurrentUrl($request); 
  181.         $this->onloadPage($request);
  182.         $categoryUrls = array('vineyard-collection-concept-articles');
  183.         $selectorData = array();
  184.         foreach($categoryUrls as $url) {
  185.             $category = $this->expositionData('Category')->findOneByUrl($url);
  186.             $selectorData[$category->getName()] = $this->singleCategorySelectorData($category);
  187.         }
  188.         return $this->renderView('index/educational_materials', array(
  189.             'index_path' => 'educational_materials',
  190.             'selector_data' => $selectorData,
  191.             'illustration' => $this->getRepository('Media\Image')->findOneByFile('nc-vineyard.jpg')
  192.         ));
  193.     }
  195.     function singleCategorySelectorData($category)
  196.     {
  197.         if($category === null) {
  198.             return array();
  199.         }
  201.         $categoryData = array();
  202.         foreach($category->getWorks() as $work) {
  203.             $translation = $work->selectTranslation();
  204.             $categoryData[$translation->getTranslatedTitle()] = $translation;
  205.         }
  206.         foreach($category->getTranslations() as $translation) {
  207.             $categoryData[$translation->getTranslatedTitle()] = $translation;
  208.         }
  209.         ksort($categoryData);
  210.         return $categoryData;
  211.     }
  213.     public function categoryAction($categoryUrl, Request $request)
  214.     {
  215.         $category = $this->expositionData('Category')->findOneByUrl($categoryUrl);
  217.         $response = null;
  218.         if($category === null) {
  219.             $response = new Response();
  220.             $response->setStatusCode(404);
  221.             return $this->renderView('no_work_content', array(), $response);
  222.         }
  223.         $this->setCurrentUrl($request); 
  224.         $this->onloadPage($request);
  225.         return $this->renderView('category', array('category' => $category), $response);
  226.     }
  228.     // Note: If $passageSeparator is null (e.g. due to being unspecified) then the template file will use <p></p> tags to separate passages
  229.     public function excerptAction($excerptId, Request $request, $translationUrl = null, $textUnitSeparator = "\n", $passageSeparator = null, $userSelected = false)
  230.     {
  231.         $excerpt = $this->expositionData('Excerpt')->findOneById($excerptId);
  232.         if($excerpt === null) {
  233.             $response = new Response();
  234.             $response->setStatusCode(404);
  235.             return $this->renderView('no_work_content', array(), $response);
  236.         }
  237.         
  238.         if($translationUrl === null) {
  239.             $translation = $excerpt->getStartArea()->getTranslation();
  240.         } else {
  241.             $translation = $this->expositionData('Translation')->findOneBy(array('url' => $translationUrl, 'isPublic' => true));
  242.         }
  243.         if($userSelected) {
  244.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  245.         }
  246.         $translationId = $translation->getId();
  247.         $excerptPassages = array();
  249.         $startTextArea = $excerpt->getStartArea();
  250.         $endTextArea = $excerpt->getEndArea();
  251.         if($startTextArea->getId() === $endTextArea->getId()) {
  252.             // Entire excerpt is in a single text unit
  253.             if($excerpt->getStartChar() > $excerpt->getEndChar()) {
  254.                 // Error! Invalid Excerpt: Start character comes after end character
  255.             }
  256.             $excerptPassages[] = substr($startTextArea->getText(), $excerpt->getStartChar(), 1+$excerpt->getEndChar()-$excerpt->getStartChar());
  257.         } else {
  258.             $startTextUnit = $startTextArea->getPlacement();
  259.             $startPassage = $startTextUnit->getPassage();
  260.             $endTextUnit = $endTextArea->getPlacement();
  261.             $endPassage = $endTextUnit->getPassage();
  263.             if($startPassage->getId() == $endPassage->getId()) {
  264.                 // Entire excerpt is in a single passage
  265.                 $startTextOrdering = $startTextUnit->getOrdering();
  266.                 $endTextOrdering = $endTextArea->getOrdering();
  267.                 if($startTextOrdering > $endTextOrdering) {
  268.                     // Error! Invalid Excerpt: Start text unit comes after end text unit
  269.                 }
  270.                 $text = substr($startTextArea->getText(), $excerpt->getStartChar());
  271.                 foreach($startPassage->getTextUnits() as $textUnit) {
  272.                     if($textUnit->getOrdering() > $startTextOrdering && $textUnit->getOrdering() < $endTextOrdering) {
  273.                         $text .= $textUnitSeparator.$textUnit->findTranslatedVersion($translationId)->getText();
  274.                     }
  275.                 }
  276.                 $text .= $textUnitSeparator.substr($endTextArea->getText(), 0, $excerpt->getEndChar() + 1);
  277.                 $excerptPassages[] = $text;
  278.             } else {
  279.                 $startText = substr($startTextArea->getText(), $excerpt->getStartChar());
  280.                 foreach($startPassage->getTextUnits() as $textUnit) {
  281.                     if($textUnit->getOrdering() > $startTextUnit->getOrdering()) {
  282.                         $startText .= $textUnitSeparator.$textUnit->findTranslatedVersion($translationId)->getText();
  283.                     }
  284.                 }
  285.                 $excerptPassages[] = $startText;
  287.                 // Add text for intermediate passages
  288.                 for($currentPassage = $startPassage->findNextPassage(); $currentPassage != null && $currentPassage->getId() != $endPassage->getId(); $currentPassage = $currentPassage->findNextPassage()) {
  289.                     $excerptPassages[] = $currentPassage->textInTranslation($translationId);
  290.                 }
  292.                 if($currentPassage == null) {
  293.                     // Error! Invalid Excerpt: End passage can't be reached by moving forward from start passage
  294.                 }
  296.                 // Build text for end of passage
  297.                 $endText = "";
  298.                 foreach($endPassage->getTextUnits() as $textUnit) {
  299.                     if($textUnit->getOrdering() < $endTextUnit->getOrdering()) {
  300.                         $endText .= $textUnit->findTranslatedVersion($translationId)->getText().$textUnitSeparator;
  301.                     }
  302.                 }
  303.                 $endText .= substr($endTextArea->getText(), 0, $excerpt->getEndChar() + 1);
  304.                 $excerptPassages[] = $endText;
  305.             }
  306.         }
  308.         $excerptData = array(
  309.             'excerpt' => $excerpt,
  310.             'excerpt_passages' => $excerptPassages,
  311.             'passage_separator' => $passageSeparator,
  312.             'nav_mode' => 'translation'
  313.         );
  314.         if($translation->getWork()->getSwedenborgType() !== null) {
  315.             $excerptData['selector_data'] = $this->buildSwedenborgSelectorList($translation->getLanguage()->getName(), $translation);
  316.         }
  318.         $this->setCurrentUrl($request); 
  319.         $this->onloadPage($request);
  320.         return $this->renderView('excerpt', $excerptData);
  321.     } // end function excerptAction
  323.     public function workIndexAction($workUrl, Request $request)
  324.     {
  325.         $this->onloadPage($request);
  326.         $work = $this->expositionData('Work')->findOneBy(array('url' => $workUrl, 'isPublic' => true));
  327.         
  328.         $translation = ($work === null) ? null : $work->selectTranslation();
  329.         if($translation === null) {
  330.             $response = new Response();
  331.             $response->setStatusCode(404);
  332.             return $this->renderView('no_work_content', array(), $response);
  333.         }
  334.         else 
  335.         {      
  336.             $this->setCurrentUrl($request);            
  337.             $translationUrl = $translation->getUrl(); 
  338.             return $this->redirect($this->get('router')->generate('exposition_translation_index', array(
  339.                     'translationUrl' => $translationUrl
  340.                 )), 301);            
  341.         }
  342.     }
  343.    
  344.     public function workPassageAction($workUrl, Request $request, $passageId = null)
  345.     {
  346.         $this->onloadPage($request);
  347.         $work = $this->expositionData('Work')->findOneBy(array('url' => $workUrl, 'isPublic' => true));
  348.         if($work === null) {
  349.             $response = new Response();
  350.             $response->setStatusCode(404);
  351.             return $this->renderView('no_work_content', array(), $response);
  352.         }
  353.         
  354.         $redir = $this->checkRedirect($work);
  355.         if($redir !== null) {
  356.             return $this->redirect($redir, 301);
  357.         }
  358.                      
  359.          $locale = $request->getLocale();
  360.          $aTranslation = $this->getTranslationInfo($workUrl,$locale,$passageId);         
  361.         if(empty($aTranslation)) {
  362.             $response = new Response();
  363.             $response->setStatusCode(404);
  364.             return $this->renderView('no_work_content', array(), $response);
  365.         }
  366.         else 
  367.         {       
  368.             $this->setCurrentUrl($request);             
  369.             $translationUrl = $aTranslation['translation_url'];
  370.             $divisionUrl = $aTranslation['division_url'];
  371.             $passageNum = $aTranslation['passage_order'];
  372.             return $this->redirect($this->get('router')->generate('exposition_translation_division_passage', array(
  373.                     'translationUrl' => $translationUrl,
  374.                     'divisionUrls' => $divisionUrl,
  375.                     'passageNumber' => $passageNum
  376.                 )), 301);        
  377.         }    
  378.     }
  380.     public function workDivisionPassageAction($workUrl, $divisionUrls, Request $request, $passageNumber = null)
  381.     {
  382.         $this->onloadPage($request);
  383.         $work = $this->expositionData('Work')->findOneBy(array('url' => $workUrl, 'isPublic' => true));
  384.         $redir = $this->checkRedirect($work);
  385.         if($redir !== null) {
  386.             return $this->redirect($redir, 301);
  387.         }
  389.         // Google seems to still be indexing results from /contents/<ordering> in Arcana Coelestia, so we'll redirect those to the URLs that are used for it now
  390.  /*       if($work !== null && $work->getUrl() === 'arcana-coelestia' && $divisionUrls === 'contents' && $passageNumber !== null && substr($passageNumber, -1) === '0') {
  391.             $passage = $this->expositionData('Passage')->findSwedenborgSection($work, substr($passageNumber, 0, -1));
  392.             return $this->passageCanonicalRedirect($passage);
  393.         } */
  395.         $passage = $this->findPassageByWorkAndDivisions($work, $divisionUrls, $passageNumber);        
  396.         $translation = ($work === null) ? null : $work->selectTranslation();
  397.         if($translation === null) {
  398.             $response = new Response();
  399.             $response->setStatusCode(404);
  400.             return $this->renderView('no_work_content', array(), $response);
  401.         }
  402.         else 
  403.         {      
  404.             $this->setCurrentUrl($request);            
  405.             $translationUrl = $translation->getUrl(); 
  406.             if($passageNumber != null)
  407.             {
  408.                 return $this->redirect($this->get('router')->generate('exposition_translation_division_passage', array(
  409.                     'translationUrl' => $translationUrl,
  410.                     'divisionUrls' => $divisionUrls,
  411.                     'passageNumber' => $passageNumber
  412.                 )), 301);
  413.                 //return $this->redirect('/exposition/translation/'.$translationUrl.'/'.$divisionUrls.'/'.$passageNumber);
  414.             }
  415.             else
  416.             {
  417.                 return $this->redirect($this->get('router')->generate('exposition_translation_division', array(
  418.                     'translationUrl' => $translationUrl,
  419.                     'divisionUrls' => $divisionUrls
  420.                 )), 301);
  421.                 //return $this->redirect('/exposition/translation/'.$translationUrl.'/'.$divisionUrls);
  422.             }    
  423.         }                
  424.     }
  426.     protected function workPassageView($passage, $work = null, $request)
  427.     {
  428.         $this->onloadPage($request);
  429.         if($work === null && $passage !== null) {
  430.             $work = $passage->findWork();
  431.         }
  432.         // Once we have user preferences implemented, we should use the user's preferred translation (or the default for the user's preferred language) instead of the original, where applicable
  433.         $translation = ($work === null) ? null : $work->selectTranslation();
  434.         
  435.         $sUrlCompareTo = $request->query->get('compareTo');
  436.         $aCompare = explode(";;", $sUrlCompareTo);
  437.         $nCompareLen = count($aCompare);
  438.         $compareTo = null;
  439.         $compareTo2 = null;        
  440.         if($nCompareLen > 0 && $aCompare[0] != '')
  441.             $compareTo = $this->expositionData('Translation')->findOneByUrl($aCompare[0]);        
  442.         
  443.         if($nCompareLen == 2 && $aCompare[1] != '')            
  444.             $compareTo2 = $this->expositionData('Translation')->findOneByUrl($aCompare[1]);
  445.                
  446.         $data = array(
  447.             'work' => $work,
  448.             'passage' => $passage,
  449.             'translation' => $translation,
  450.             'compare_to' => $compareTo,
  451.             'compare_to2' => $compareTo2,
  452.             'nav_mode' => 'work',
  453.             'text_style_override' => $this->getTextStyleOverride($translation->getLanguage()->getId())
  454.         );
  455.    /*     $selectorData = $this->selectSelectorList($work);
  456.         if($selectorData !== null) {
  457.             $data['selector_data'] = $selectorData;
  458.         } */
  460.         $this->setCurrentUrl($request);         
  461.         return $this->createPassageView($data, 'work', $work, $request);
  462.     }
  464.     public function workDivisionAction($workUrl, $divisionUrls)
  465.     {
  466.         $this->onloadPage($request);
  467.         $work = $this->expositionData('Work')->findOneBy(array('url' => $workUrl, 'isPublic' => true));
  468.         $translation = ($work === null) ? null : $work->selectTranslation();
  469.         if($translation === null) {
  470.             $response = new Response();
  471.             $response->setStatusCode(404);
  472.             return $this->renderView('no_work_content', array(), $response);
  473.         }
  474.         else 
  475.         {      
  476.             $this->setCurrentUrl($request);             
  477.             $translationUrl = $translation->getUrl(); 
  478.             return $this->redirect($this->get('router')->generate('exposition_translation_division', array(
  479.                     'translationUrl' => $translationUrl,
  480.                     'divisionUrls' => $divisionUrls
  481.                 )), 301);
  482.             //return $this->redirect('/exposition/translation/'.$translationUrl.'/'.$divisionUrls);
  483.         } 
  484.     }
  486.     public function collectionIndexAction($collectionUrl, Request $request)
  487.     {
  488.         $this->onloadPage($request);
  489.         $collection = $this->expositionData('Collection')->findOneByUrl($collectionUrl);
  491.         $response = null;
  492.         if($collection === null) {
  493.             $response = new Response();
  494.             $response->setStatusCode(404);
  495.             return $this->renderView('no_work_content', array(), $response);
  496.         }
  498.         $this->setCurrentUrl($request);         
  499.         return $this->renderView('collection_index', array('collection' => $collection), $response);
  500.     }
  502.     public function translationIndexAction($translationUrl, Request $request, $userSelected = true)
  503.     {
  504.         $this->onloadPage($request);
  505.         $translation = $this->expositionData('Translation')->findOneBy(array('url' => $translationUrl, 'isPublic' => true));
  506.         $response = null;
  507.         if($translation === null) {
  508.             $response = new Response();
  509.             $response->setStatusCode(404);
  510.             return $this->renderView('no_work_content', array(), $response);
  511.         }
  512.             
  513.         if($userSelected && $translation !== null) {
  514.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  515.         }
  516.         $data = array('translation' => $translation, 'nav_mode' => 'translation');
  517.         
  518.         $type_id = $translation->getTypeId();
  519.         
  520.         if($type_id == $this->TRANSLATION_TYPE_ID_FILE) 
  521.         {
  522.             $file = $translation->getFile();
  523.             if($file !== null) {
  524.                 $data['file'] = $file;
  525.             }
  526.         }
  527.         if($type_id == $this->TRANSLATION_TYPE_ID_LINK) // link
  528.         {
  529.             $doc_link = $translation->getDocLink();
  530.             if($doc_link !== null) {
  531.                 $data['doc_link'] = $doc_link;
  532.             }
  533.         }
  534.         
  535.         $data['type_id'] = $type_id;
  536.         
  537.         $nTransID = $translation->getId();
  538.         $data['biblio'] = $this->getBiblio($nTransID, $translation->getIsOriginal());
  539.         $data['work_biblio_orig'] = null;
  540.         if(!$translation->getIsOriginal())
  541.             $data['work_biblio_orig'] = $this->getBiblioOriginal($nTransID);
  542.             
  543.         $data['translation_index'] = '1';    
  544.         
  545.         $this->setCurrentUrl($request);         
  546.         return $this->renderView('translation_index', $data, $response);
  547.     }
  548.     
  549.     public function translationPassageAction($translationUrl, Request $request, $passageId = null, $userSelected = true, $inFrame = false)
  550.     {
  551.         $this->onloadPage($request);
  552.         $translation = $this->expositionData('Translation')->findOneBy(array('url' => $translationUrl, 'isPublic' => true));
  553.          if($translation == null) {
  554.             $response = new Response();
  555.             $response->setStatusCode(404);
  556.             return $this->renderView('no_work_content', array(), $response);
  557.         }
  558.         
  559.         if($userSelected && $translation !== null) {
  560.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  561.         }
  562.         $redir = $this->checkRedirect($translation);
  563.         if($redir !== null) {
  564.             return $this->redirect($redir, 301);
  565.         }
  566.         $passage = ($passageId !== null)
  567.             ? $this->expositionData('Passage')->findOneById($passageId)
  568.             : (($translation !== null) ? $translation->getWork()->findFirstNonEmptyPassage($translation) : null);
  569.  /*       if($passage !== null && $passage->findWork() === $translation->getWork()) {
  570.             return $this->passageCanonicalRedirect($passage, $translation);
  571.         } */
  572.         
  573.         if(!$inFrame)
  574.             $this->setCurrentUrl($request); 
  575.                         
  576.         return $this->translationPassageView($passage, $translation, $request, $inFrame);
  577.     }
  579.     public function translationDivisionPassageAction($translationUrl, $divisionUrls, Request $request, $passageNumber = null, $userSelected = true, $inFrame = false)
  580.     {
  581.         $this->onloadPage($request);
  582.         $response = null;
  583.         if(strlen($passageNumber) > 8) {
  584.             $response = new Response();
  585.             $response->setStatusCode(404);
  586.             return $this->renderView('no_work_content', array(), $response);
  587.         }
  588.         
  589.         if(!$this->IsSwedenborgWork($translationUrl))
  590.         {
  591.             return $this->redirect($this->get('router')->generate('exposition_translation', array(
  592.                     'translationUrl' => $translationUrl
  593.                 )), 301);
  594.         }
  595.     
  596.         $translation = $this->expositionData('Translation')->findOneBy(array('url' => $translationUrl, 'isPublic' => true));
  597.         if($translation == null) {
  598.             $response = new Response();
  599.             $response->setStatusCode(404);
  600.             return $this->renderView('no_work_content', array(), $response);
  601.         }
  602.         
  603.         if($userSelected && $translation !== null) {
  604.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  605.         }
  606.         $redir = $this->checkRedirect($translation);
  607.         if($redir !== null) {
  608.             return $this->redirect($redir, 301);
  609.         }
  610.         $work = ($translation === null) ? null : $translation->getWork();
  611.         
  612.         if(!$work->getIsPublic()) {
  613.             $response = new Response();
  614.             $response->setStatusCode(404);
  615.             return $this->renderView('no_work_content', array(), $response);
  616.         }
  618.         // Google seems to still be indexing results from /contents/<ordering> in Arcana Coelestia, so we'll redirect those to the URLs that are used for it now
  619.         if($work !== null && $work->getUrl() === 'arcana-coelestia' && $divisionUrls === 'contents' && $passageNumber !== null && substr($passageNumber, -1) === '0') {
  620.             $passage = $this->expositionData('Passage')->findSwedenborgSection($work, substr($passageNumber, 0, -1));
  621.             return $this->passageCanonicalRedirect($passage, $translation);
  622.         }
  624.         $passage = $this->findPassageByWorkAndDivisions($work, $divisionUrls, $passageNumber);
  625.         
  626.         if(!$inFrame)
  627.             $this->setCurrentUrl($request); 
  628.             
  629.         return $this->translationPassageView($passage, $translation, $request, $inFrame);
  630.     }
  632.     protected function translationPassageView($passage, $translation, $request, $inFrame = false)
  633.     {    
  634.         $this->checkIfOnMobile($request);        
  635.         $locale = $request->getLocale();
  636.         $nTranslationID = $translation->getId();
  637.         $sUrlCompareTo = $request->query->get('compareTo');
  638.         $aCompare = explode(";;", $sUrlCompareTo);
  639.         $nCompareLen = count($aCompare);
  640.         $compareTo = null;
  641.         $compareTo2 = null;    
  642.         $text_to_speech2 = null;
  643.         $text_to_speech3 = null;
  644.         $text_style_override_compare_to = null;   
  645.         $text_style_override_compare_to2 = null; 
  646.         $translation_shortname2 = null;
  647.         $translation_shortname3 = null;
  648.         if($nCompareLen > 0 && $aCompare[0] != '')
  649.         {
  650.             $compareTo = $this->expositionData('Translation')->findOneBy(array('url' => $aCompare[0], 'isPublic' => true));   
  651.             if($compareTo != null)    
  652.             {
  653.                 $nLanguageID2 = $compareTo->getLanguage()->getId();
  654.                 $text_style_override_compare_to = $this->getTextStyleOverride($nLanguageID2);
  655.                 $text_to_speech2 = $this->getTextToSpeech($nLanguageID2);
  656.                 
  657.                 $translation_shortname2 = $this->getWorkTranslationShortName($compareTo->getId());                
  658.             }    
  659.         }         
  660.         
  661.         if($nCompareLen == 2 && $aCompare[1] != '') 
  662.         {           
  663.             $compareTo2 = $this->expositionData('Translation')->findOneBy(array('url' => $aCompare[1], 'isPublic' => true)); 
  664.             if($compareTo2 != null)    
  665.             {
  666.                 $nLanguageID3 = $compareTo2->getLanguage()->getId();
  667.                 $text_style_override_compare_to2 = $this->getTextStyleOverride($nLanguageID3);
  668.                 $text_to_speech3 = $this->getTextToSpeech($nLanguageID3);
  669.                 $translation_shortname3 = $this->getWorkTranslationShortName($compareTo2->getId());
  670.             }    
  671.         }    
  672.         
  673.         $bSwedenborg = $this->isSwedenborg($nTranslationID);
  674.         $chapterExplanations = null;
  675.         $chapterExplanationsForCombo = null;
  676.         $prev_chapter_explanation = array();
  677.         $next_chapter_explanation = array();
  678.         $explained_cbook_id = null;
  679.         if(!$bSwedenborg)
  680.         {    
  681.             $chapterExplanations = $this->getChapterExplanationsForNav($translation);       
  682.             $chapterExplanationsForCombo = $this->getChapterExplanationsForTextForCombo($translation); 
  683.             
  684.             if(!empty($chapterExplanations))
  685.             {
  686.                 $bHasPass = false;
  687.                 foreach($chapterExplanations as $ce)
  688.                 {
  689.                     if($ce['translation_id'] == $nTranslationID)
  690.                         $bHasPass = true;
  691.                     else
  692.                     {    
  693.                         if(!$bHasPass)
  694.                         {
  695.                             $prev_chapter_explanation['url'] = $ce['translation_url'];
  696.                             $prev_chapter_explanation['title'] = $ce['explanationtitle'];
  697.                         }    
  698.                         else
  699.                         {
  700.                             $next_chapter_explanation['url'] = $ce['translation_url'];
  701.                             $next_chapter_explanation['title'] = $ce['explanationtitle'];
  702.                             break;
  703.                         }        
  704.                     }                            
  705.                 }
  706.                 
  707.                 $explained_cbook_id = $chapterExplanations[0]['book_id'];
  708.             }
  709.         }
  710.         $ref_column_spec = '';
  711.         if($bSwedenborg)
  712.             $ref_column_spec = $this->MULTI_URL_INDICATOR_SWEDENBORG_WORK;    
  713.         else
  714.             $ref_column_spec = $this->MULTI_URL_INDICATOR_EXPLANATION;    
  715.         
  716.         $ref_column_spec .= '_' . $translation->getUrl();
  717.         if($passage != null && $bSwedenborg)
  718.             $ref_column_spec .= '_' . $passage->getSwedenborgSection();
  719.             
  720.         $nPassageID = null;    
  721.         if($passage != null)
  722.             $nPassageID = $passage->getId();
  723.             
  724.         $nLanguageID = $translation->getLanguage()->getId();      
  725.         $data = array(
  726.             'translation' => $translation,
  727.             'passage' => $passage,
  728.             'compare_to' => $compareTo,
  729.             'compare_to2' => $compareTo2,
  730.             'nav_mode' => 'translation',            
  731.           //  'chapter_explanations' => $chapterExplanations,
  732.             'chapter_explanations_for_combo' => $chapterExplanationsForCombo,
  733.             'prev_chapter_explanation' => $prev_chapter_explanation,
  734.             'next_chapter_explanation' => $next_chapter_explanation,
  735.             'explained_cbook_id' => $explained_cbook_id,
  736.             'ref_column_spec' => $ref_column_spec,
  737.             'text_style_override' => $this->getTextStyleOverride($nLanguageID),
  738.             'text_style_override_compare_to' => $text_style_override_compare_to,
  739.             'text_style_override_compare_to2' => $text_style_override_compare_to2,
  740.             'text_to_speech1' => $this->getTextToSpeech($nLanguageID),
  741.             'text_to_speech2' => $text_to_speech2,
  742.             'text_to_speech3' => $text_to_speech3,            
  743.             'translation_shortname2' => $translation_shortname2,
  744.             'translation_shortname3' => $translation_shortname3            
  745.         );
  746.         
  747.         $data['is_ipad'] = $this->isIPad();
  748.         
  749.         if($translation !== null) {
  750.        /*     $selectorData = $this->selectSelectorList($translation->getWork(), $translation->getLanguage()->getName(), $translation);
  751.             if($selectorData !== null) {
  752.                 $data['selector_data'] = $selectorData;
  753.             } */
  755.             $work = $translation->getWork();
  756.             
  757.             $bSwedenborgWork = ($work->getSwedenborgType() !== null);
  758.             $data['is_swedenborg'] = $bSwedenborgWork;
  759.             if($bSwedenborgWork)
  760.             {
  761.                 $data['linktype_id'] = $this->LINK_TYPE_ID_SWEDENBORG;
  762.             }
  763.             else
  764.             {
  765.                 $data['linktype_id'] = $this->LINK_TYPE_ID_OTHER;
  766.             }
  768.             if($bSwedenborgWork && $nLanguageID == $request->getSession()->get('work_search_language_id'))
  769.             {
  770.                 $data['work_searchterm'] = $request->getSession()->get('work_searchterm');
  771.                 $data['work_search_phrase'] = $request->getSession()->get('work_search_phrase');
  772.                 if($nLanguageID == $this->LANGUAGE_ID_LATIN)
  773.                 {
  774.                     $data['work_search_internal_amb'] = $request->getSession()->get('work_search_internal_amb');                    
  775.                     $data['work_search_external_amb'] = $request->getSession()->get('work_search_external_amb');
  776.                     $data['work_search_int_ext_amb'] = $request->getSession()->get('work_search_int_ext_amb');
  777.                 }
  778.                 else
  779.                 {
  780.                     $data['work_search_internal_amb'] = null;
  781.                     $data['work_search_external_amb'] = null;
  782.                     $data['work_search_int_ext_amb'] = null;
  783.                 }
  784.             }
  785.             else
  786.             {
  787.                 $data['work_searchterm'] = null;
  788.                 $data['work_search_phrase'] = null;
  789.                 $data['work_search_internal_amb'] = null;
  790.                 $data['work_search_external_amb'] = null;
  791.                 $data['work_search_int_ext_amb'] = null;
  792.             }
  793.             
  794.             $bConsider = false;
  795.             $bBibleStudy = false;
  796.             $bConcept = false;
  797.             $bQA = false;
  798.             $bConcordance = false;
  799.             if(!$bSwedenborgWork)
  800.             {
  801.                 foreach($work->getCategories() as $category) {
  802.                     if($category->getId() == $this->CATEGORY_ID_SPIRITUAL_TOPIC) {
  803.                         $bConsider = true;
  804.                     }
  805.                     elseif($category->getId() == $this->CATEGORY_ID_BIBLE_STUDY) {
  806.                         $bBibleStudy = true;
  807.                     }
  808.                     elseif($category->getId() == $this->CATEGORY_ID_CONCEPT) {
  809.                         $bConcept = true;
  810.                         $data['category_concept'] = 1;
  811.                     }
  812.                     elseif($category->getId() == $this->CATEGORY_ID_QA) {
  813.                         $bQA = true;
  814.                     }
  815.                     elseif($category->getId() == $this->CATEGORY_ID_CONCORDANCE) {
  816.                         $bConcordance = true;
  817.                     }
  818.                 }
  819.             }
  820.             
  821.             $nLanguageID = $translation->getLanguage()->getId();
  822.             if($bQA)
  823.             {                
  824.                 $data['prev_next'] = $this->getPrevNextLink($translation->getId(), $this->CATEGORY_ID_QA, $request);
  825.             }
  826.             else
  827.             {
  828.                 if($bConsider)
  829.                 {                
  830.                     $aAllTopic = array();
  831.                     $sTranslationUrl = $translation->getUrl();
  832.                     $aSearchedTopic = $request->getSession()->get('searched_topic_list');
  833.                     if(!empty($aSearchedTopic))
  834.                     {                
  835.                         foreach($aSearchedTopic as $s)
  836.                         {                
  837.                             if($s['translation_url'] == $sTranslationUrl)
  838.                             {
  839.                                 $aAllTopic = $aSearchedTopic;
  840.                                 break;
  841.                             }
  842.                         }
  843.                     }
  844.                     
  845.                     if(empty($aAllTopic))
  846.                     {                    
  847.                         $aAllTopic = $this->getCategoryList($nLanguageID, $this->CATEGORY_ID_SPIRITUAL_TOPIC, $locale);
  848.                     }                
  849.                 
  850.                     $data['consider_data'] = $aAllTopic;
  851.                     $data['prev_next'] = $this->getPrevNextLinkFromList($translation->getId(), $data['consider_data']);                    
  852.                 }
  853.                 
  854.                 if($bBibleStudy)
  855.                 {
  856.                     $data['biblestudy_data'] = $this->getCategoryList($nLanguageID, $this->CATEGORY_ID_BIBLE_STUDY, $locale);
  857.                     $data['prev_next'] = $this->getPrevNextLinkFromList($translation->getId(), $data['biblestudy_data']);                    
  858.                 }
  859.                 
  860.                 if($bConcordance)
  861.                 {            
  862.                     $aAllConcordance = array();
  863.                     $sTranslationUrl = $translation->getUrl();
  864.                     $aSearchedConcordance = $request->getSession()->get('searched_concordance_list');
  865.                     if(!empty($aSearchedConcordance))
  866.                     {                
  867.                         foreach($aSearchedConcordance as $s)
  868.                         {                
  869.                             if($s['translation_url'] == $sTranslationUrl)
  870.                             {
  871.                                 $aAllConcordance = $aSearchedConcordance;
  872.                                 break;
  873.                             }
  874.                         }
  875.                         $data['prev_next'] = $this->getPrevNextLinkFromList($translation->getId(), $aAllConcordance);
  876.                     }
  878.                     if(empty($aAllConcordance))
  879.                     {                    
  880.                         $data['prev_next'] = $this->getNextPrevCategoryUrl($translation->getId(), $nLanguageID, $this->CATEGORY_ID_CONCORDANCE, $locale);
  881.                     }                
  882.                 }
  883.                 
  884.                 if($bConcept)
  885.                 {                
  886.                     $data['concept_prev_next'] = $this->getNextPrevConceptUrl($translation->getId(), $nLanguageID, $locale);
  887.                 }                
  888.             }
  889.                         
  890.             if(!$bSwedenborgWork)                
  891.                 $data['authors'] = $this->getAuthorInfo($request, $translation->getId());
  892.             else
  893.                 $data['IsSwedenborgWork'] = 1;    
  894.                 
  895.             $type_id = $translation->getTypeId();
  896.         
  897.             if($type_id == $this->TRANSLATION_TYPE_ID_FILE) 
  898.             {
  899.                 $file = $translation->getFile();
  900.                 if($file !== null) {
  901.                     $data['file'] = $file;
  902.                 }
  903.             }
  904.             if($type_id == $this->TRANSLATION_TYPE_ID_LINK) 
  905.             {
  906.                 $doc_link = $translation->getDocLink();
  907.                 if($doc_link !== null) {
  908.                     $data['doc_link'] = $doc_link;
  909.                 }
  910.             }
  911.             
  912.             $data['type_id'] = $type_id;
  913.             
  914.             $data['in_frame'] = $inFrame;
  915.             
  916.             if($passage != null)
  917.             {            
  918.                 $nTranslationID = $translation->getId();
  919.                 
  920.                 if(!$bSwedenborgWork)
  921.                     $data['passage_ref'] = $this->getWorkPassageRefs($nPassageID,$nTranslationID, $request);
  922.                 
  923.                 if($bSwedenborgWork)
  924.                     $data['related_bible_ref'] = $this->getRelatedBibleRefForWork($nPassageID,$nTranslationID, $request);
  925.                 $data['passage_footnote'] = $this->getPassageFootnotes($nPassageID,$nTranslationID);
  926.                 $data['passage_multilink'] = $this->getWorkPassageMultiLink($nPassageID,$nTranslationID, $request);
  927.                 if($translation->getLanguage()->getId() == $this->LANGUAGE_ID_LATIN || ($compareTo != null && $compareTo->getLanguage()->getId() == $this->LANGUAGE_ID_LATIN) || ($compareTo2 != null && $compareTo2->getLanguage()->getId() == $this->LANGUAGE_ID_LATIN))
  928.                 {                
  929.                     $data['passage_scanimage'] = $this->getWorkPassageScanImageFileName($nPassageID);
  930.                     $data['define_latin_icon'] = 1;
  931.                 }
  932.                 
  933.            //     $data['work_references'] = $this->getWorkRefForWork($nPassageID, $nLanguageID);
  934.            //     $data['explanation_references'] = $this->getExplanationRefForWork($nPassageID, $nLanguageID);
  935.            //     $data['gced_ref'] = $this->getGCEDRefForWork($nPassageID);
  936.            //     $data['otle_ref'] = $this->getOTLERefForWork($nPassageID);
  937.            //     $data['related_passages'] = $this->getRelatedPassages($nPassageID, $nLanguageID);
  938.                 
  939.                 $request->getSession()->set('current_explanation_cchapter_id', '');                
  940.                 $nExplainChapterID = $this->getExplainChapterID($nTranslationID, $this->getCurrUserID($request)); 
  941.                   if(!empty($nExplainChapterID))
  942.                   {                  
  943.                       $data['cchapter_id'] = $nExplainChapterID;
  944.                     $request->getSession()->set('current_explanation_cchapter_id', $nExplainChapterID); 
  945.                       $request->getSession()->set('current_explanation_translation_id', $nTranslationID);
  946.                   }
  947.                                     
  948.                   if(!$bSwedenborgWork)
  949.                   {
  950.                       if ($this->canEditExplanation($request))                  
  951.                           $data['explanation_translation_id_to_edit'] = $nTranslationID;
  952.                   }    
  953.                   else if ($this->canEditWork($request))
  954.                   {
  955.                       $data['work_translation_id_to_edit'] = $nTranslationID;    
  956.                       $data['work_passage_num_to_edit'] = $passage->getSwedenborgSection();        
  957.                       //$data['has_slider_item_for_work'] = $this->hasSliderItemForWork($nPassageID, $nTranslationID, $request, $nLanguageID);
  958.         
  959.                     $data['slider_url'] = $this->get('router')->generate('exposition_slider', array(
  960.                             'translationId' => $nTranslationID,
  961.                             'passageId' => $nPassageID
  962.                         ));
  963.                   }    
  964.                   
  965.                   if($bSwedenborgWork)
  966.                   {                              
  967.                       $data['has_slider_item_for_work'] = $this->hasSliderItemForWork($nPassageID, $nTranslationID, $request, $nLanguageID);
  968.         
  969.                     $data['slider_url'] = $this->get('router')->generate('exposition_slider', array(
  970.                             'translationId' => $nTranslationID,
  971.                             'passageId' => $nPassageID
  972.                         ));
  973.                     
  974.                     if($passage->emptyInTranslation($translation))
  975.                     {    
  976.                         $data['last_passage_num'] = $this->getLastAvailablePassageNum($nTranslationID);
  977.                     }   
  978.                   }    
  979.                   
  980.                   // check table of contents
  981.                   $aTOC = $this->getWorkTranslationTOC($nTranslationID, true); 
  982.                   if(!empty($aTOC))
  983.                   {                  
  984.                       $data['has_work_toc'] = true;
  985.                   }              
  986.             }
  987.             $data['text_to_speech'] = $this->getTextToSpeech($translation->getLanguage()->getId());    
  988.             
  989.             if($bSwedenborgWork)   
  990.             {     
  991.                 $data['biblio_info'] = $this->getBiblioForTranslation($translation->getId());
  992.             //    $data['swedenborg_works'] = $this->getCategorizedSwedenborgWorksForTranslation($request, $translation->getId(), $translation->getLanguage()->getId());
  993.             }
  994.             else
  995.             {
  996.                 // check concept image
  997.                 if($compareTo == null)
  998.                 {
  999.                     $conceptUrl = $this->getConceptUrl($translation->getWork()->getId());                    
  1000.                     if(!empty($conceptUrl))
  1001.                     {
  1002.                         $concept = $this->getRepository('Concepts\Concept')->findOneByUrl($conceptUrl);
  1003.                         $illustrations = $concept->getIllustrations();
  1004.                         $data['image'] = ($illustrations->isEmpty()) ? null : $illustrations[0]->getImage();
  1005.                     }
  1006.                 }
  1007.             }    
  1008.         } else {
  1009.             $work = null;
  1010.         }
  1012.         return $this->createPassageView($data, 'translation', $work, $request);
  1013.     }
  1015.     public function translationDivisionAction($translationUrl, $divisionUrls, $userSelected = true, Request $request)
  1016.     {
  1017.         $this->onloadPage($request);
  1018.         $translation = $this->expositionData('Translation')->findOneBy(array('url' => $translationUrl, 'isPublic' => true));
  1019.         if($userSelected) {
  1020.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  1021.         }
  1022.         $redir = $this->checkRedirect($translation);
  1023.         if($redir !== null) {
  1024.             return $this->redirect($redir, 301);
  1025.         }
  1026.         $work = ($translation === null) ? null : $translation->getWork();
  1027.         $division = $this->findDivisionByWorkAndUrls($work, $divisionUrls);
  1028.         $data = array('translation' => $translation, 'division' => $division, 'nav_mode' => 'translation');
  1029.   /*      $selectorData = $this->selectSelectorList($translation->getWork(), $translation->getLanguage()->getName(), $translation);
  1030.         if($selectorData !== null) {
  1031.             $data['selector_data'] = $selectorData;
  1032.         } */
  1034.         $response = null;
  1035.         if($division === null) {
  1036.             $response = new Response();
  1037.             $response->setStatusCode(404);
  1038.             return $this->renderView('no_work_content', array(), $response);
  1039.         }
  1041.         $this->setCurrentUrl($request);         
  1042.         return $this->renderView('translation_division', $data, $response);
  1043.     }
  1045.     // Final tasks to be performed when rendering a passage, whether accessed via work or via translation
  1046.     protected function createPassageView($data, $mode, $work, $request)
  1047.     {
  1048.         $locale = $request->getLocale();
  1049.         $response = null;
  1050.         if($work === null || $data['translation'] === null || $data['passage'] === null || $data['passage']->findWork() !== $work) {
  1051.             $response = new Response();
  1052.             $response->setStatusCode(404);
  1053.             return $this->renderView('no_work_content', array(), $response);
  1054.         }
  1055.         
  1056.         $nPassageID = $data['passage']->getId();
  1057.         $nTranslationID = $data['translation']->getId();
  1058.         $nLanguageID = $data['translation']->getLanguage()->getId();
  1059.         $data['translation_shortname'] = $this->getWorkTranslationShortName($nTranslationID);
  1060.         
  1061.         $nBibleBookIDForSummary = $this->getBibleBookIDForSummary($nTranslationID);
  1062.         $bBibleBookSummary = ($nBibleBookIDForSummary != '');
  1063.         if($bBibleBookSummary)
  1064.             $data['is_book_summary'] = '1';
  1065.         
  1066.         if($work !== null) {              
  1067.                $nLevelID = '';
  1068.                $aStory = $this->getStoryInfo($nTranslationID);
  1069.             if(!empty($aStory))
  1070.             {                   
  1071.                 $nStoryID = $aStory['story_id'];
  1072.                 $nLevelID = $aStory['level_id'];               
  1073.                 if($nLevelID == $this->STORY_LEVEL_ID_BIBLE)
  1074.                 {  
  1075.                     $aAllStory = array();
  1076.             /*        $aSearchedStory = $request->getSession()->get('searched_bible_story_list');
  1077.                     if(!empty($aSearchedStory))
  1078.                     {
  1079.                         $sTranslationUrl = $data['translation']->getUrl();
  1080.                         foreach($aSearchedStory as $s)
  1081.                         {                
  1082.                             if($s['commentary_url'] == $sTranslationUrl)
  1083.                             {
  1084.                                 $aAllStory = $aSearchedStory;
  1085.                                 break;
  1086.                             }
  1087.                         }
  1088.                     }
  1089.                     
  1090.                     if(empty($aAllStory))
  1091.                     {
  1092.                         $aAllStory = $this->getExplainedStoryList($locale);
  1093.                     }
  1094.             //        print_r($aAllStory); */
  1095.                     $data['all_stories'] = $aAllStory;
  1096.                     
  1097.                     $data['story_explanations'] = $this->getWorkListForStory($locale, $nStoryID);
  1098.                     $data['commentary_type'] = 'storyexplanation';                                            
  1099.                 }
  1100.                 elseif($nLevelID == $this->STORY_LEVEL_ID_CHAPTER)
  1101.                     $data['is_chapter_explanation'] = '1';
  1102.                 elseif($nLevelID == $this->STORY_LEVEL_ID_VERSE)
  1103.                     $data['is_verse_explanation'] = '1';    
  1104.                                
  1105.                 $data['story_id'] = $nStoryID;
  1106.             }  
  1108.             // We can override the 'storyexplanation' commentary type because some "story" explanations are really verse explanations.
  1109.             // There shouldn't be any similar situation with concept explanations, so if we have an associated concept, then we'll skip the category check below.
  1110.             // The reason for not using just the category check and nothing else is in case a work or translation doesn't get put in the appropriate category.
  1111.             if($this->getConceptID($data['translation']->getId()) !== null) {
  1112.                 $data['commentary_type'] = 'conceptexplanation';
  1113.             } else {
  1114.                 $containingCategories = $work->getCategories()->toArray();
  1115.                 if($data['translation'] !== null) {
  1116.                     $containingCategories = array_merge($containingCategories, $data['translation']->getCategories()->toArray());
  1117.                 }
  1118.                 $categoryUrlToCommentaryTypeMap = array(
  1119.                     'doctrinal-topic-explanations' => 'doctrinaltopic',
  1120.                     'verse-explanations' => 'verseexplanation',
  1121.                     // The story-explanation category doesn't exist at the time of writing this as far as I know, but if it gets added later then we'll want this
  1122.                     'story-explanations' => 'storyexplanation'
  1123.                 );
  1124.                 // If the content doesn't belong to the Category for any major commentary type, then $data['commentary_type'] can just remain unset.
  1125.                 foreach($containingCategories as $cat) {
  1126.                     if(array_key_exists($cat->getUrl(), $categoryUrlToCommentaryTypeMap)) {
  1127.                         $data['commentary_type'] = $categoryUrlToCommentaryTypeMap[$cat->getUrl()];
  1128.                         // At the time of coding this, there shouldn't be anything which belongs to more than one major commentary type.
  1129.                         break;
  1130.                     }
  1131.                 }
  1132.             }
  1133.         }
  1134.                 
  1135.         if($work->getSwedenborgType() !== null)
  1136.         {              
  1137.             $data['previous_passage'] = $this->getPreviousPassageWithContent($data['passage'], $data['translation']);
  1138.             $data['next_passage'] = $this->getNextPassageWithContent($data['passage'], $data['translation']); 
  1139.             
  1140.             // Get meta description
  1141.             $nTextLength = 140;            
  1142.             $sPassageText = $this->getWorkPassageContents($nPassageID,$nTranslationID); 
  1143.             $sMetaDesc = $this->fixWorkText($sPassageText);
  1144.               $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "...");          
  1145.               $data['work_meta_desc'] = $sMetaDesc;
  1146.         } 
  1147.         else
  1148.         {
  1149.             // Get meta description
  1150.             $nTextLength = 140;
  1151.             $sPassageText = '';
  1152.             if($nLevelID == $this->STORY_LEVEL_ID_CHAPTER)
  1153.             {            
  1154.                 $sPassageText = $this->getWorkPassageContents($nPassageID,$nTranslationID);
  1155.             }
  1156.             else
  1157.             {
  1158.                 $sPassageText = $this->getWorkTranslationDesc($nTranslationID); 
  1159.                 if(empty($sPassageText))
  1160.                 {
  1161.                     $sPassageText = $this->getWorkPassageContents($nPassageID,$nTranslationID); 
  1162.                 }
  1163.             }
  1164.             $sMetaDesc = $this->fixWorkText($sPassageText);
  1165.               $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "...");          
  1166.               $data['work_meta_desc'] = $sMetaDesc;
  1167.         }      
  1168.         
  1169.         $data['work'] = $work;
  1170.                      
  1171.         return $this->renderView($mode.'_passage', $data, $response);
  1172.     }
  1174.     protected function findDivisionByWorkAndUrls($work, $divisionUrls)
  1175.     {
  1176.         if($work === null) {
  1177.             return null;
  1178.         }
  1179.         $divisionUrlList = explode('/', $divisionUrls);
  1180.         $divisionData = $this->expositionData('Division');
  1181.         $division = $divisionData->findOneBy(array(
  1182.             'work' => $work->getId(), 'url' => array_shift($divisionUrlList)));
  1183.         foreach($divisionUrlList as $url) {
  1184.             if($division === null) {
  1185.                 return null;
  1186.             }
  1187.             $division = $divisionData->findOneBy(array('superdivision' => $division->getId(), 'url' => $url));
  1188.         }
  1189.         return $division;
  1190.     }
  1192.     protected function findPassageByWorkAndDivisions($work, $divisionUrls, $passageNumber = null)
  1193.     {
  1194.         $division = $this->findDivisionByWorkAndUrls($work, $divisionUrls);
  1195.         if($division === null) {
  1196.             return null;
  1197.         }
  1198.         return ($passageNumber === null)
  1199.             ? $division->findFirstPassage()
  1200.             : $this->expositionData('Passage')->findOneBy(array(
  1201.                 'division' => $division->getId(),
  1202.                 'ordering' => $passageNumber
  1203.             ));
  1204.     }
  1206.     public function conceptAction($conceptUrl, Request $request, $languageCode = '', $asOverlay = false)
  1207.     {
  1208.       // $memcache = $this->get('cache');  // it's actually apccache, but behaves the same way
  1209.       // $apccache = $this->get('cache');    
  1210.       
  1211.           // The client requested to use translation url instead of concept url (3/16/2020)
  1212.           
  1213.           $this->onloadPage($request);          
  1214.         if(!$asOverlay)
  1215.         {
  1216.             $sTranslationUrl = $this->getConceptTranslationUrl($conceptUrl, $languageCode);
  1217.             if(!empty($sTranslationUrl))
  1218.             {
  1219.                 return $this->redirect($this->get('router')->generate('exposition_translation', array(
  1220.                         'translationUrl' => $sTranslationUrl
  1221.                     )), 301);
  1222.             }        
  1223.         }
  1224.       
  1225.           $locale = $request->getLocale();
  1227.         $displayInfo = array('nav_mode' => 'translation', 'commentary_type' => 'conceptexplanation');
  1229.         $concept = $this->getRepository('Concepts\Concept')->findOneByUrl($conceptUrl);
  1230.         
  1231.         if(!empty($languageCode))
  1232.         {
  1233.             $language = $this->getLanguageByBibliographicCode($languageCode);
  1234.             $nLanguageID = $language['id'];
  1235.         }
  1236.         else
  1237.         {
  1238.             $nLanguageID = $this->getLanguageIDByShortCode($locale);            
  1239.         }
  1240.         
  1241.         $sTranslationUrl = $this->getConceptTranslationUrl($conceptUrl, $languageCode);
  1242.                  
  1243.         if(!empty($sTranslationUrl)) 
  1244.         {     
  1245.             $translation =  $this->expositionData('Translation')->findOneByUrl($sTranslationUrl); 
  1246.             $displayInfo['translation'] = $translation;               
  1247.             $displayInfo['title'] = $translation->getNameOrTitle();
  1248.             $illustrations = $concept->getIllustrations();
  1249.             $displayInfo['image'] = ($illustrations->isEmpty()) ? null : $illustrations[0]->getImage();
  1250.             
  1251.             $displayInfo['passage'] = $translation->getWork()->findFirstPassage();
  1252.             $displayInfo['text_style_override'] = $this->getTextStyleOverride($translation->getLanguage()->getId());
  1253.             
  1254.             $displayInfo['passage_ref'] = $this->getWorkPassageRefs($displayInfo['passage']->getId(),$translation->getId(), $request); 
  1255.             $displayInfo['ref_column_spec'] = $this->getExplanationUrl($translation->getId());
  1256.             $displayInfo['passage_footnote'] = $this->getPassageFootnotes($displayInfo['passage']->getId(),$translation->getId());
  1257.             $displayInfo['passage_multilink'] = $this->getWorkPassageMultiLink($displayInfo['passage']->getId(),$translation->getId(), $request);
  1259.         } elseif($concept !== null) {
  1260.             // If the concept exists but not in this language, then we probably want a 404 with a list of languages that do have this concept
  1261.         } else {
  1262.             $displayInfo['translation'] = null;
  1263.             $displayInfo['passage'] = null;
  1264.         }
  1266.         $response = null;
  1267.         if(empty($sTranslationUrl) || $displayInfo['translation'] === null) {
  1268.             $response = new Response();
  1269.             $response->setStatusCode(404);
  1270.             return $this->renderView('no_work_content', array(), $response);
  1271.         }
  1272.     
  1273.         $templateName = $asOverlay ? 'overlay/passage' : 'translation_passage';
  1274.         
  1275.         if(!$asOverlay)
  1276.         {
  1277.             $this->setCurrentUrl($request);
  1278.             $displayInfo['concept_prev_next'] = $this->getNextPrevConcept($concept->getId());
  1279.         }     
  1280.                         
  1281.         return $this->renderView($templateName, $displayInfo, $response);
  1282.     }
  1284.     protected function passageCanonicalRedirect($passage, $translation, $code = 301)
  1285.     {    
  1286.           $redirectUrl = $this->get('router')->generate('exposition_translation_division_passage', array(
  1287.                     'translationUrl' => $translation->getUrl(),
  1288.                     'divisionUrls' => $passage->getDivision()->getUrl(),
  1289.                     'passageNumber' => $passage->getOrdering()
  1290.                 )); 
  1291.               
  1292.         $args = @$_SERVER['QUERY_STRING'];
  1293.         if(!empty($args)) 
  1294.         {                
  1295.             $redirectUrl .= '?'.$args;                   
  1296.         }
  1297.         return $this->redirect($redirectUrl, $code);
  1298.     }
  1300.     public function swedenborgGotoAction(Request $request)
  1301.     {
  1302.         $this->onloadPage($request);
  1303.         $statusCode = 200;
  1305.         $query = $request->query;
  1306.         if(!$query->has('translation') && !$query->has('work')) {
  1307.             // If we aren't told what book to show, then we'll redirect to the list of all Swedenborg books
  1308.             return $this->redirect($this->get('router')->generate('swedenborg'));
  1309.         }
  1310.         
  1311.         $translation = $this->expositionData('Translation')->findOneByUrl($query->get('translation'));
  1312.         if($translation !== null) {
  1313.             $request->getSession()->set('current_language', $translation->getLanguage()->getBibliographicCode());
  1314.             $work = $translation->getWork();
  1315.             $params = array('translation' => $translation, 'nav_mode' => 'translation');
  1316.      /*       if($work->getSwedenborgType() !== null) {
  1317.                 $params['selector_data'] = $this->buildSwedenborgSelectorList($translation->getLanguage()->getName(), $translation); 
  1318.             }*/
  1319.         } else {
  1320.             $work = $this->expositionData('Work')->findOneByUrl($query->get('work'));
  1321.             $params = array('work' => $work, 'nav_mode' => 'work');
  1322.             $translation = $work->selectTranslation();
  1323.     /*        if($work->getSwedenborgType() !== null) {
  1324.                 $params['selector_data'] = $this->buildSwedenborgSelectorList();
  1325.             } */
  1326.         }
  1327.         if($query->has('section')) {
  1328.             $targetSectionNumber = $query->get('section');
  1329.             $targetSection = $this->expositionData('Passage')->findSwedenborgSection($work, $targetSectionNumber);
  1330.             
  1331.             $inframe = $query->get('inframe');
  1332.             if($inframe == 1)
  1333.             {
  1334.                 return $this->redirect($this->get('router')->generate('exposition_frame_passage', array(
  1335.                         'translationUrl' => $translation->getUrl(),
  1336.                         'divisionUrls' => $targetSection->getDivision()->getUrl(),
  1337.                         'passageNumber' => $targetSection->getOrdering()
  1338.                     )), 301);                
  1339.             } 
  1340.         } else {
  1341.             $targetSection = $work->findFirstPassage();
  1342.         }
  1343.         if($targetSection !== null) {
  1344.             return $this->passageCanonicalRedirect($targetSection, $translation);
  1345.         } else {
  1346.             $fromSection = $query->get('fromSection');
  1347.             if($fromSection !== null) {
  1348.                 $params['passage'] = $this->expositionData('Passage')->findSwedenborgSection($work, $fromSection);
  1349.                 $template = $params['nav_mode'].'_passage';
  1350.             } else {
  1351.                 $template = $params['nav_mode'].'_index';
  1352.             }
  1353.             $title = ($translation !== null) ? $translation->getTranslatedTitle() : $work->selectTranslation()->getTranslatedTitle();
  1354.             // "%title% does not contain a section numbered _2000_"
  1355.      /*       $params['error_message'] = $this->get('translator')->trans($request->getSession()->get('ui_str')["exposition.passage.outofrange"], array(
  1356.                 '_1000_' => $title,
  1357.                 '_2000_' => $targetSectionNumber
  1358.             )); // $title." does not contain a section numbered ".$targetSectionNumber;
  1359.             */
  1360.             
  1361.             $aReplace = array(
  1362.                 '_1000_' => $title,
  1363.                 '_2000_' => $targetSectionNumber
  1364.             );
  1365.             $params['error_message'] = $this->ui_string_replace($request->getSession()->get('ui_str')["bible.chapternav.bookchapterrange"], $aReplace);
  1366.             
  1367.             $statusCode = 404;
  1368.         }
  1369.         
  1370.         $sUrlCompareTo = $request->query->get('compareTo');
  1371.         $aCompare = explode(";;", $sUrlCompareTo);
  1372.         $nCompareLen = count($aCompare);
  1373.         $compareTo = null;
  1374.         $compareTo2 = null;        
  1375.         if($nCompareLen > 0 && $aCompare[0] != '')
  1376.             $compareTo = $this->expositionData('Translation')->findOneByUrl($aCompare[0]);        
  1377.         
  1378.         if($nCompareLen == 2 && $aCompare[1] != '')            
  1379.             $compareTo2 = $this->expositionData('Translation')->findOneByUrl($aCompare[1]);
  1380.             
  1381.         $params['compare_to'] = $compareTo;
  1382.         $params['compare_to2'] = $compareTo2;
  1384.         $response = null;
  1385.         if($statusCode !== 200) {
  1386.             $response = new Response();
  1387.             $response->setStatusCode($statusCode);
  1388.         }
  1390.         $this->setCurrentUrl($request);         
  1391.         return $this->renderView($template, $params, $response);
  1392.     }
  1394.     public function quickviewTranslationPassageAction($passageId, $translationId, Request $request)
  1395.     {
  1396.         $translation = $this->expositionData('Translation')->findOneById($translationId);
  1397.         $nTranslationID = $translation->getId();
  1398.         $work = $translation->getWork();
  1399.         $nLanguageID = $translation->getLanguage()->getId();
  1400.   /*      $sUrlCompareTo = $request->query->get('compareTo');
  1401.         $aCompare = explode(";;", $sUrlCompareTo);
  1402.         $nCompareLen = count($aCompare);
  1403.         $compareTo = null;
  1404.         $compareTo2 = null;        
  1405.         if($nCompareLen > 0 && $aCompare[0] != '')        
  1406.             $compareTo = $this->expositionData('Translation')->findOneByUrl($aCompare[0]);        
  1407.         
  1408.         if($nCompareLen == 2 && $aCompare[1] != '')             
  1409.             $compareTo2 = $this->expositionData('Translation')->findOneByUrl($aCompare[1]);
  1410.       */  
  1411.         $passage = $this->expositionData('Passage')->findOneById($passageId);    
  1412.         $quickviewData = array(
  1413.             'translation' => $translation,
  1414.        //     'compare_to' => $compareTo,
  1415.        //     'compare_to2' => $compareTo2,
  1416.             'passage' => $passage,
  1417.             'text_style_override' => $this->getTextStyleOverride($nLanguageID)
  1418.         );
  1419.         
  1420.         if($passage != null && $translation != null)
  1421.         {           
  1422.             $quickviewData['passage_footnote'] = $this->getPassageFootnotes($passage->getId(),$nTranslationID);
  1423.             $quickviewData['passage_multilink'] = $this->getWorkPassageMultiLink($passage->getId(),$nTranslationID, $request);
  1424.             $quickviewData['previous_passage'] = $this->getPreviousPassageWithContent($passage,$translation);     
  1425.             $quickviewData['next_passage'] = $this->getNextPassageWithContent($passage,$translation);     
  1426.             
  1427.             $nWorkID = $work->getId();
  1428.             
  1429.             if($nLanguageID != $this->LANGUAGE_ID_LATIN)
  1430.             {
  1431.                 $request->getSession()->set('last_quickview_language_id', $nLanguageID); 
  1432.             }
  1433.             
  1434.             $sLanguages = "";
  1435.             $nLastLangID = $request->getSession()->get('last_quickview_language_id');
  1436.             if($nLanguageID == $this->LANGUAGE_ID_LATIN)
  1437.             {          
  1438.                 if(empty($nLastLangID))
  1439.                     $sLanguages = $nLanguageID;
  1440.                 else
  1441.                     $sLanguages = $nLanguageID . "," . $request->getSession()->get('last_quickview_language_id');     
  1442.             }          
  1443.             else
  1444.                 $sLanguages = $nLanguageID . ", " . $this->LANGUAGE_ID_LATIN;
  1445.                 
  1446.             $quickviewData['translations_by_language'] = $this->getWorkTranslationsByLanguage($nWorkID, $sLanguages);  
  1447.             
  1448.             $quickviewData['shortname'] = $this->getWorkTranslationShortName($nTranslationID);  
  1449.             $quickviewData['translation_id'] = $nTranslationID;
  1450.             $quickviewData['passage_id'] = $passage->getId(); 
  1451.             
  1452.             $bSwedenborgWork = ($work->getSwedenborgType() !== null);
  1453.             if(!$bSwedenborgWork)                
  1454.                 $quickviewData['authors'] = $this->getAuthorInfo($request, $translation->getId());
  1455.             else
  1456.                 $quickviewData['IsSwedenborgWork'] = 1;      
  1457.         }
  1458.         
  1459.         return $this->renderView('quickview/passage', $quickviewData);
  1460.     }
  1462.     public function quickviewSwedenborgTranslationGotoAction(Request $request)
  1463.     {
  1464.         $query = $request->query;
  1465.         if(!$query->has('translation')) {
  1466.             // We haven't been told what book to show; maybe someone tried to access this directly rather than via AJAX from the search page?
  1467.             // We'll redirect to the search page
  1468.             return $this->redirect($this->get('router')->generate('advanced_search'));
  1469.         }
  1471.         $translation = $this->expositionData('Translation')->findOneByUrl($query->get('translation'));
  1472.         if($query->has('section')) {
  1473.             $targetSection = $this->expositionData('Passage')->findSwedenborgSection($translation->getWork(), $query->get('section'));
  1474.         } else {
  1475.             $targetSection = $translation->getWork()->findFirstPassage();
  1476.         }
  1477.         return $this->quickviewTranslationPassageAction($targetSection->getId(), $translation->getId(), $request);
  1478.     }
  1480.     public function expositionSearchPostAction(Request $request)
  1481.     {
  1482.         // $query = $this->getRequest()->query;
  1483.         // $searchTerm = $query['searchTerm'];
  1484.         $params = $request->request->all();
  1485.         if ( array_key_exists( 'searchTerm', $params ) ) {
  1486.             $searchTerm = $params['searchTerm'];
  1487.         } else {
  1488.             $searchTerm = '';
  1489.         }
  1490.         return $this->expositionSearchAction($searchTerm);
  1491.     }
  1493.     public function expositionSearchAction($searchTerm, $start=1) {
  1494.         // $templateName = 'explanation_search';
  1495.         // return $this->sharedSearchAction( $searchTerm, 'is', $templateName, $start );
  1496.         return $this->renderView('search/exposition_search', array('searchTerm' => $searchTerm, 'content_class' => 'explanation', 'start' => $start));
  1497.     }
  1499.     public function expositionSearchResultsAction($searchTerm, $pageNum = 1)
  1500.     {
  1501.         return $this->renderView('search/search_results', $this->expositionSearchResults($searchTerm, false, 'locale', $pageNum));
  1502.     }
  1504.     public function swedenborgSearchPostAction(Request $request)
  1505.     {
  1506.         // $query = $this->getRequest()->query;
  1507.         // $searchTerm = $query['searchTerm'];
  1508.         $params = $request->request->all();
  1509.         if ( array_key_exists( 'searchTerm', $params ) ) {
  1510.             $searchTerm = $params['searchTerm'];
  1511.         } else {
  1512.             $searchTerm = '';
  1513.         }
  1514.         return $this->swedenborgSearchAction($searchTerm);
  1515.     }
  1517.     public function swedenborgSearchAction($searchTerm, $start=1)
  1518.     {
  1519.         // $templateName = 'swedenborg_search';
  1520.         // return $this->sharedSearchAction( $searchTerm, 'is not', $templateName, $start );
  1521.         return $this->renderView('search/exposition_search', array('searchTerm' => $searchTerm, 'content_class' => 'swedenborg', 'start' => $start));
  1522.     }
  1524.     public function swedenborgSearchResultsAction($searchTerm, $pageNum = 1)
  1525.     {
  1526.         // $templateName = 'swedenborg_search';
  1527.         // return $this->sharedSearchAction( $searchTerm, 'is not', $templateName, $start );
  1528.         return $this->renderView('search/search_results', $this->expositionSearchResults($searchTerm, true, 'locale', $pageNum));
  1529.     }
  1531.     public function expositionSearchResults(Request $request, $searchTerm, $isSwedenborg, $forceLanguage = null, $start = 1)
  1532.     {
  1533.         $search = new PostgresSearch();
  1534.         $em = $this->getDoctrine()->getManager();
  1535.         $search->setManager($em);
  1536.         return $search->getExpositionSearchResults($request, $searchTerm, $isSwedenborg, array('language' => $forceLanguage, 'page' => $start));
  1537.     }         
  1538.             
  1539.     public function topicalPathIndexAction(Request $request)
  1540.     {
  1541.         $this->onloadPage($request);
  1542.         $locale = $request->getLocale();
  1543.         $topicData = $this->getTopPathList($locale);
  1544.         $data = array(
  1545.             'topic_data' => $topicData        
  1546.         );
  1547.         $this->setCurrentUrl($request);         
  1548.         return $this->renderView('index/topical_paths', $data);
  1549.     }
  1550.     
  1551.     public function topPathAction($TopPathUrl, Request $request)
  1552.     {
  1553.         $this->onloadPage($request);
  1554.         $locale = $request->getLocale();
  1555.         $topPath = $this->getTopPathInfo($TopPathUrl,$locale);
  1556.         $subPathList = $this->getSubPathList($TopPathUrl,$locale);
  1557.         $data = array(
  1558.             'sub_path_list' => $subPathList,
  1559.             'top_path' => $topPath,
  1560.             'top_path_url' => $TopPathUrl       
  1561.         );
  1562.         $this->setCurrentUrl($request);         
  1563.         return $this->renderView('top_path', $data);
  1564.     }
  1565.     
  1566.     public function subPathAction($TopPathUrl, $SubPathUrl, Request $request)
  1567.     {
  1568.         $this->onloadPage($request);
  1569.         $locale = $request->getLocale();
  1570.         $bibleTranslationUrl = $this->DEFAULT_BIBLE_VERSION;
  1571.         $nBibleTransID = $request->getSession()->get('current_bible_translation_id');
  1572.         if($nBibleTransID != '')
  1573.         {   
  1574.                $bibleTranslation = $this->getBibleTranslationByID($nBibleTransID);
  1575.                $bibleTranslationUrl = $bibleTranslation['url'];
  1576.         }
  1577.         $topPath = $this->getTopPathInfo($TopPathUrl,$locale);
  1578.         $subPath = $this->getSubPathInfo($SubPathUrl,$locale);
  1579.         $explanationList = $this->getExplanationListForTopAndSubPath($TopPathUrl, $SubPathUrl,$locale);
  1580.         $data = array(
  1581.             'explanation_list' => $explanationList,
  1582.             'top_path' => $topPath,
  1583.             'sub_path' => $subPath,
  1584.             'sub_path_url' => $SubPathUrl,
  1585.             'top_path_url' => $TopPathUrl,
  1586.             'bible_translation_url' => $bibleTranslationUrl       
  1587.         );
  1588.         $this->setCurrentUrl($request);         
  1589.         return $this->renderView('sub_path', $data);
  1590.     }
  1591.     
  1592.     public function topicIndexAction(Request $request)
  1593.     {
  1594.         $locale = $request->getLocale();
  1595.         $topicData = $this->getTopicList($locale);
  1596.         $data = array(
  1597.             'topic_data' => $topicData        
  1598.         );
  1599.       
  1600.            $this->setCurrentUrl($request); 
  1601.            $this->onloadPage($request);
  1602.         return $this->renderView('index/topics', $data);
  1603.     }
  1604.     
  1605.     public function topicAction($TopicUrl,Request $request)
  1606.     {        
  1607.         $this->onloadPage($request);
  1608.         $locale = $request->getLocale(); 
  1609.         $bibleTranslationUrl = $this->DEFAULT_BIBLE_VERSION;
  1610.         $nBibleTransID = $request->getSession()->get('current_bible_translation_id');
  1611.         if($nBibleTransID != '')
  1612.         {   
  1613.                $bibleTranslation = $this->getBibleTranslationByID($nBibleTransID);
  1614.                $bibleTranslationUrl = $bibleTranslation['url'];
  1615.         }   
  1616.         $topic = $this->getSubPathInfo($TopicUrl,$locale);
  1617.         $explanationList = $this->getExplanationListForTopic($TopicUrl,$locale);
  1618.         $data = array(
  1619.             'explanation_list' => $explanationList,            
  1620.             'topic' => $topic,
  1621.             'topic_url' => $TopicUrl,
  1622.             'bible_translation_url' => $bibleTranslationUrl        
  1623.         );
  1624.         $this->setCurrentUrl($request);         
  1625.         return $this->renderView('topic', $data);
  1626.     }
  1627.     
  1628.     public function viewscanimagesAction($PassageID, Request $request)
  1629.     {             
  1630.         $this->onloadPage($request);
  1631.         $aImage = array(
  1632.             'scanimage' => $this->getWorkPassageScanImageFileName($PassageID),
  1633.             'translation_info' => $this->getCurrentPassageForLatin($PassageID),
  1634.             'next_passage' => $this->getNextPassageWithScan($PassageID),
  1635.             'previous_passage' => $this->getPreviousPassageWithScan($PassageID)       
  1636.         );
  1637.         return $this->renderView('view_scanimages', $aImage);
  1638.     }
  1639.     
  1640.     public function popoverconceptAction($explanationID, $conceptID, Request $request)
  1641.     {         
  1642.           $locale = $request->getLocale();        
  1643.         $sPopupText = $this->getBibleWordPopupText($explanationID, $conceptID);
  1644.         $aConceptInfo = $this->getBibleWordPopupConceptInfo($explanationID, $conceptID);
  1645.         $data = array(
  1646.             'popup_text' => $sPopupText,
  1647.             'title' => $aConceptInfo['title'],
  1648.             'concept_url' => $aConceptInfo['concept_url']
  1649.         );
  1650.          
  1651.         return $this->renderView('word_popup', $data);
  1652.     }
  1653.     
  1654.     /**
  1655.      * Show chapter summary list on a popup for multi page
  1656.      */
  1657.     public function selectchaptersummaryAction($explanationID, $bibleBookID, Request $request)
  1658.     {             
  1659.       $data['chapter_summary_list'] = $this->getChapterSummaryList($explanationID, $bibleBookID);
  1660.                        
  1661.       return $this->renderView('selectchaptersummary', $data);
  1662.     }
  1663.     
  1664.     /**
  1665.      * Show chapter summary list on a popup for single chapter summary page
  1666.      */
  1667.     public function selectchaptersummarysinglepageAction($explanationID, $cBibleBookID, Request $request)
  1668.     {             
  1669.       $data['chapter_summary_list'] = $this->getChapterSummaryListForSinglePage($explanationID, $cBibleBookID);
  1670.                        
  1671.       return $this->renderView('selectchaptersummarysinglepage', $data);
  1672.     }
  1673.     
  1674.     public function featured_spiritual_topicsAction(Request $request)
  1675.     {                       
  1676.     //    $this->setCurrentUrl($request); 
  1677.         $this->onloadPage($request);
  1678.         $locale = $request->getLocale();
  1679.         $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_SPIRITUAL_TOPIC, $locale, 9);
  1680.         if(empty($featuredList))
  1681.             $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_SPIRITUAL_TOPIC, $locale, 9, true);
  1682.         $request->getSession()->set('searched_topic_list', array());
  1683.         return $this->renderView('index/spiritual_topics_featured', array(     
  1684.             'featured_topic' => $featuredList            
  1685.         ));
  1686.     }
  1687.     
  1688.     public function searched_spiritual_topicsAction(Request $request)
  1689.     {                       
  1690.     //    $this->setCurrentUrl($request); 
  1691.         $this->onloadPage($request);
  1692.         $locale = $request->getLocale();
  1693.         $sSearchTerm = $request->query->get('searchTerm');
  1694.         $searchedResults = null;   
  1695.         if($sSearchTerm != '')
  1696.         {
  1697.             $searchedResults = $this->getSearchedListByCategory($this->CATEGORY_ID_SPIRITUAL_TOPIC, $locale, $request);
  1698.         }        
  1699.         else
  1700.         {
  1701.             $nPathwayID = $request->query->get('pathwayid');
  1702.             if(!empty($nPathwayID))
  1703.             {
  1704.                 $searchedResults = $this->getSearchedListByCategoryAndPathway($locale, $request, $this->CATEGORY_ID_SPIRITUAL_TOPIC, $nPathwayID);
  1705.             }
  1706.             else
  1707.             {
  1708.                 $nAll = $request->query->get('all');
  1709.                 if($nAll == '1')
  1710.                 {
  1711.                     $searchedResults = $this->getAllListByCategory($this->CATEGORY_ID_SPIRITUAL_TOPIC, $locale, $request);
  1712.                 }
  1713.             }
  1714.         }
  1715.         return $this->renderView('index/spiritual_topics_searched', array(     
  1716.             'searched_topic' => $searchedResults            
  1717.         ));
  1718.     }
  1719.     
  1720.     public function getSearchedListByCategory($vCategoryId, $locale, $request)
  1721.     {
  1722.         $search = new PostgresSearch();
  1723.         $em = $this->getDoctrine()->getManager();
  1724.         $search->setManager($em);
  1725.         return $search->getCategorySearchResults($vCategoryId, $locale, $request);
  1726.     }
  1727.     
  1728.     public function getSearchedOTLEVideos($locale, $request)
  1729.     {
  1730.         $search = new PostgresSearch();
  1731.         $em = $this->getDoctrine()->getManager();
  1732.         $search->setManager($em);
  1733.         return $search->getOTLESearchResults($locale, $request);
  1734.     }
  1735.     
  1736.     public function expositionSliderAction($translationId, Request $request, $passageId, $userSelected = true, $inFrame = false)
  1737.     {
  1738.   /*      $translation = $this->expositionData('Translation')->findOneBy(array('id' => $translationId, 'isPublic' => true));
  1739.          if($translation == null) {
  1740.             $response = new Response();
  1741.             $response->setStatusCode(404);
  1742.             return $this->renderView('no_work_content', array(), $response);
  1743.         }
  1744.         
  1745.         $passage = ($passageId !== null)
  1746.             ? $this->expositionData('Passage')->findOneById($passageId)
  1747.             : (($translation !== null) ? $translation->getWork()->findFirstNonEmptyPassage($translation) : null); */
  1748.             
  1749.         $aTranslation = $this->getTranslationData($translationId);    
  1750.         $aPassage = $this->getPassageData($passageId);  
  1751.              
  1752.         $this->checkIfOnMobile($request);
  1753.     //    $locale = $request->getLocale();
  1754.              
  1755.         $ref_column_spec = '';
  1756.      //   $work = $translation->getWork();
  1757.         $bSwedenborgWork = ($aTranslation['swedenborgtype'] != null);
  1758.         if($bSwedenborgWork)
  1759.             $ref_column_spec = $this->MULTI_URL_INDICATOR_SWEDENBORG_WORK;    
  1760.         else
  1761.             $ref_column_spec = $this->MULTI_URL_INDICATOR_EXPLANATION;    
  1762.         
  1763.         $ref_column_spec .= '_' . $aTranslation['url'];
  1764.         if($bSwedenborgWork)
  1765.             $ref_column_spec .= '_' . $aPassage['swedenborgsection'];
  1766.                     
  1767.         $nLanguageID = $aTranslation['language_id'];      
  1768.         $data = array(
  1769.            // 'translation' => $translation,
  1770.            // 'passage' => $passage,  
  1771.             'ref_column_spec' => $ref_column_spec,  
  1772.             'passage_order' => $aPassage['ordering'],  
  1773.             'passage_id' => $passageId,                     
  1774.         );
  1776.      //   $data['passage_ref'] = $this->getWorkPassageRefs($passageId,$translationId, $request);
  1777.         
  1778.     //    if($bSwedenborgWork)
  1779.     //        $data['related_bible_ref'] = $this->getRelatedBibleRefForWork($passageId,$translationId, $request);
  1780.     //    $data['passage_footnote'] = $this->getPassageFootnotes($passageId,$translationId);
  1781.     //    $data['passage_multilink'] = $this->getWorkPassageMultiLink($passageId,$translationId, $request);
  1782.                     
  1783.         $data['work_references'] = $this->getWorkRefForWork($passageId, $translationId, $nLanguageID);
  1784.       
  1785.         $data['explanation_references'] = $this->getExplanationRefForWork($passageId, $nLanguageID);
  1786.         $data['gced_ref'] = $this->getGCEDRefForWork($passageId);
  1787.         $data['otle_ref'] = $this->getOTLERefForWork($passageId);
  1788.         $data['related_passages'] = $this->getRelatedPassages($passageId, $nLanguageID);                                        
  1789.           // get table of contents
  1790.           $aTOC = $this->getWorkTranslationTOC($translationId); 
  1791.           if(!empty($aTOC))
  1792.           {                  
  1793.               $data['work_toc'] = $aTOC;
  1794.           }
  1795.                    
  1796.         return $this->renderView('refsidrw', $data);
  1797.     }
  1799.     public function selecttopicAction(Request $request)
  1800.     {       
  1801.       $locale = $request->getLocale();  
  1802.       $sSearchText = $request->query->get('st');
  1803.                        
  1804.       $data['consider_data'] = $this->getConsiderList($locale, $sSearchText); 
  1805.                     
  1806.       return $this->renderView('selecttopic', $data);
  1807.     } 
  1808.     
  1809.     public function otlevideosAction(Request $request)
  1810.     {            
  1811.         $this->onloadPage($request);
  1812.         $locale = $request->getLocale();
  1813.         $aBrand = $this->getBrandList();
  1814.         $aShowTopic = $this->getShowTopicList();
  1815.         $aShowType = $this->getShowTypeList();   
  1816.         $data = array(
  1817.               'brand_list' => $aBrand,
  1818.               'topic_list' => $aShowTopic,
  1819.                'type_list' => $aShowType            
  1820.         );
  1821.         $this->setCurrentUrl($request);         
  1822.         return $this->renderView('otle_videos', $data);
  1823.     }
  1824.     
  1825.     public function searched_otle_videosAction(Request $request)
  1826.     {            
  1827.         $locale = $request->getLocale();
  1828.         $searchedResults = array();
  1829.         $sSearchTerm = $request->query->get('searchTerm');
  1830.         $nBrandID = $request->query->get('brandid');
  1831.         if($sSearchTerm != '')
  1832.         {
  1833.             $searchedResults = $this->getSearchedOTLEVideos($locale, $request);
  1834.         }        
  1835.         else
  1836.         {
  1837.             $nStartNum = $request->query->get('startnum');            
  1838.             $searchedResults = $this->getOTLEVideos($nStartNum, $request);            
  1839.         }            
  1840.         
  1841.         return $this->renderView('otle_videos_searched', array(     
  1842.             'searched_video' => $searchedResults['results'],
  1843.             'total_record' => $searchedResults['total_record'],
  1844.             'has_more' => $searchedResults['has_more'],
  1845.             'start_num' => $searchedResults['start_num']            
  1846.         ));
  1847.     }
  1848.     
  1849.     public function otlevideopageAction($showID, Request $request)
  1850.     {            
  1851.         //$locale = $request->getLocale();        
  1852.         $aShow = $this->getShowInfo($showID);
  1853.         $aShowRef = $this->getShowRefs($showID, $request);    
  1854.         
  1855.         $nTextLength = 150;
  1856.         $sDesc = $aShow['description'];
  1857.         $sMetaDesc = $this->fixWorkText($sDesc);
  1858.           $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "...");          
  1859.               
  1860.         return $this->renderView('otle_video_page', array(  
  1861.             'show_id' => $showID,   
  1862.             'show_info' => $aShow,
  1863.             'show_ref' => $aShowRef,
  1864.             'meta_desc' => $sMetaDesc           
  1865.         ));
  1866.     }
  1867.     
  1868.     public function audiohubAction(Request $request)
  1869.     {            
  1870.         $this->onloadPage($request);
  1871.         $locale = $request->getLocale();        
  1872.         $aLanguage = $this->getLanguageListForAudioHub(); 
  1873.         $aCategory = $this->getCategoryListForAudioHub();   
  1874.         $data = array(
  1875.                'language_list' => $aLanguage,
  1876.                'category_list' => $aCategory            
  1877.         );
  1878.         $this->setCurrentUrl($request);        
  1879.         return $this->renderView('audiohub', $data);
  1880.     }
  1881.     
  1882.     public function search_audioAction(Request $request)
  1883.     {            
  1884.         $locale = $request->getLocale();
  1885.         $searchedResults = array();
  1886.         $sSearchTerm = $request->query->get('searchTerm');  
  1887.         $nStartNum = $request->query->get('startnum');      
  1888.         if($sSearchTerm != '')
  1889.         {
  1890.             $searchedResults = $this->getSearchedAudio($locale, $request);
  1891.         }    
  1892.         else
  1893.         {
  1894.             $nFormatID = $this->PRIMARY_FORMAT_ID_AUDIO;
  1895.             $searchedResults = $this->getExplanationList($nStartNum, $locale, $request, $nFormatID);            
  1896.         }            
  1897.         
  1898.         return $this->renderView('audio_searched', array(     
  1899.             'searched_audio' => $searchedResults,
  1900.             'start_num' => $nStartNum           
  1901.         ));
  1902.     }
  1903.         
  1904.     public function getSearchedAudio($locale, $request)
  1905.     {        
  1906.         $search = new PostgresSearch();
  1907.         $em = $this->getDoctrine()->getManager();
  1908.         $search->setManager($em);
  1909.         $sCategoryId = 'any';
  1910.         return $search->getCategorySearchResults($sCategoryId, $locale, $request);
  1911.     } 
  1912.     
  1913.     public function qahubAction(Request $request)
  1914.     {            
  1915.         $locale = $request->getLocale(); 
  1916.         $data = array(                         
  1917.         );
  1918.         $this->setCurrentUrl($request); 
  1919.         $this->onloadPage($request);
  1920.         return $this->renderView('qahub', $data);
  1921.     }
  1922.     
  1923.     public function search_qaAction(Request $request)
  1924.     {            
  1925.         $locale = $request->getLocale();
  1926.         $searchedResults = array();
  1927.         $sSearchTerm = $request->query->get('searchTerm');  
  1928.         $nStartNum = $request->query->get('startnum');      
  1929.         if($sSearchTerm != '')
  1930.         {
  1931.             $searchedResults = $this->getSearchedQA($locale, $request);
  1932.         }    
  1933.         else
  1934.         {            
  1935.             $searchedResults = $this->getExplanationList($nStartNum, $locale, $request);
  1936.         }            
  1937.         
  1938.         return $this->renderView('qa_searched', array(     
  1939.             'searched_qa' => $searchedResults,
  1940.             'start_num' => $nStartNum           
  1941.         ));
  1942.     }
  1943.         
  1944.     public function getSearchedQA($locale, $request)
  1945.     {        
  1946.         $search = new PostgresSearch();
  1947.         $em = $this->getDoctrine()->getManager();
  1948.         $search->setManager($em);
  1949.         $sCategoryId = 47;
  1950.         return $search->getCategorySearchResults($sCategoryId, $locale, $request);
  1951.     } 
  1952.     
  1953.     public function search_classAction(Request $request)
  1954.     {            
  1955.         $locale = $request->getLocale();
  1956.         $searchedResults = array();
  1957.         $sSearchTerm = $request->query->get('searchTerm');  
  1958.         $nStartNum = $request->query->get('startnum');      
  1959.         if($sSearchTerm != '')
  1960.         {
  1961.             $searchedResults = $this->getSearchedClass($locale, $request);
  1962.         }    
  1963.         else
  1964.         {            
  1965.             $searchedResults = $this->getClassList($nStartNum, $request);            
  1966.         }            
  1967.         
  1968.         return $this->renderView('class_searched', array(     
  1969.             'searched_class' => $searchedResults['results'],
  1970.             'total_record' => $searchedResults['total_record'],
  1971.             'has_filter' => $searchedResults['has_filter'],
  1972.             'has_more' => $searchedResults['has_more'],
  1973.             'start_num' => $nStartNum           
  1974.         ));
  1975.     }
  1976.     
  1977.     public function getSearchedClass($locale, $request)
  1978.     {
  1979.         $search = new PostgresSearch();
  1980.         $em = $this->getDoctrine()->getManager();
  1981.         $search->setManager($em);
  1982.         return $search->getClassSearchResults($locale, $request);
  1983.     }
  1984.     
  1985.     public function coursepageAction($courseID, Request $request)
  1986.     {        
  1987.         $aCourse = $this->getCourseInfo($courseID);         
  1988.         if(empty($aCourse))
  1989.         {
  1990.             $response = new Response();
  1991.             $response->setStatusCode(404);
  1992.             return $this->renderView('no_work_content', array(), $response);
  1993.         }
  1994.         $aLeader = $this->getLeadersForCourse($courseID);
  1995.         $aAudience = $this->getAudienceForCourse($courseID);    
  1996.         
  1997.         $nTextLength = 150;
  1998.         $sDesc = $aCourse['full_description'];
  1999.         $sMetaDesc = $this->fixWorkText($sDesc);
  2000.           $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "..."); 
  2001.                               
  2002.         return $this->renderView('course_page', array(     
  2003.             'course_info' => $aCourse,
  2004.             'leader_list' => $aLeader,
  2005.             'audience_list' => $aAudience,
  2006.             'meta_desc' => $sMetaDesc          
  2007.         ));
  2008.     }
  2009.     
  2010.     public function search_sermonAction(Request $request)
  2011.     {            
  2012.         $locale = $request->getLocale();
  2013.         $searchedResults = array();
  2014.         $sSearchTerm = $request->query->get('searchTerm');  
  2015.         $nStartNum = $request->query->get('startnum'); 
  2016.         $nStorehouse = $request->query->get('storehouse');     
  2017.         if($sSearchTerm != '')
  2018.         {
  2019.             $searchedResults = $this->getSearchedSermon($locale, $request);
  2020.         }    
  2021.         else
  2022.         {            
  2023.             $searchedResults = $this->getSermonList($nStartNum, $request);            
  2024.         }            
  2025.         
  2026.         return $this->renderView('sermon_searched', array(     
  2027.             'searched_sermon' => $searchedResults['results'],
  2028.             'total_record' => $searchedResults['total_record'],
  2029.             'has_more' => $searchedResults['has_more'],
  2030.             'has_filter' => $searchedResults['has_filter'],
  2031.             'start_num' => $nStartNum,
  2032.             'is_storehouse' => $nStorehouse          
  2033.         ));
  2034.     }
  2035.     
  2036.     public function getSearchedSermon($locale, $request)
  2037.     {
  2038.         $search = new PostgresSearch();
  2039.         $em = $this->getDoctrine()->getManager();
  2040.         $search->setManager($em);
  2041.         return $search->getSermonSearchResults($locale, $request);
  2042.     }
  2043.     
  2044.     public function sermonpageAction($sermonID, Request $request)
  2045.     {        
  2046.         if(!$this->userCanSeeAllSermons($request))
  2047.         {
  2048.             $nTypeID = $this->getSermonTypeID($sermonID);
  2049.             if($nTypeID != $this->LNCSERMON_TYPE_ID_PUBLIC)
  2050.             {
  2051.                 $bCanView = false;
  2052.                 if($this->userCanSeeLNCSermons($request) && $nTypeID == $this->LNCSERMON_TYPE_ID_LNC_MEMBER)
  2053.                 {
  2054.                     $bCanView = true;
  2055.                 }
  2056.                 
  2057.                 if(!$bCanView)
  2058.                 {
  2059.                     return $this->redirect($this->get('router')->generate('sermons', array()), 301);
  2060.                 }
  2061.             }        
  2062.         }
  2063.     
  2064.         $aSermon = $this->getSermonInfo($sermonID);
  2065.         $aAuthor = $this->getAuthorsForSermon($sermonID);
  2066.         $aTopic = $this->getTopicsForSermon($sermonID);
  2067.         $aSermonRef = $this->getSermonRefs($sermonID, $request);
  2068.         
  2069.         $nTextLength = 150;
  2070.         $sDesc = $aSermon['searchsummary'];
  2071.         $sMetaDesc = $this->fixWorkText($sDesc);
  2072.           $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "...");
  2073.        
  2074.         return $this->renderView('sermon_page', array(   
  2075.             'sermon_id' => $sermonID,  
  2076.             'sermon_info' => $aSermon,
  2077.             'author_list' => $aAuthor,
  2078.             'topic_list' => $aTopic,
  2079.             'sermon_ref' => $aSermonRef,
  2080.             'meta_desc' => $sMetaDesc        
  2081.         ));
  2082.     }
  2083.     
  2084.     public function sermonstorehousepageAction($sermonID, Request $request)
  2085.     {   
  2086.         $nTypeID = $this->getSermonTypeID($sermonID);
  2087.         if($nTypeID != $this->LNCSERMON_TYPE_ID_PUBLIC)
  2088.         {            
  2089.             return $this->redirect($this->get('router')->generate('sermon_storehouse', array()), 301);
  2090.         }   
  2091.     
  2092.         $aSermon = $this->getSermonInfo($sermonID);
  2093.         $aAuthor = $this->getAuthorsForSermon($sermonID);
  2094.         $aTopic = $this->getTopicsForSermon($sermonID);
  2095.         $aSermonRef = $this->getSermonRefs($sermonID, $request);
  2096.         
  2097.         $nTextLength = 150;
  2098.         $sDesc = $aSermon['searchsummary'];
  2099.         $sMetaDesc = $this->fixWorkText($sDesc);
  2100.           $sMetaDesc = $this->getTextWithinLength($sMetaDesc, $nTextLength, "...");
  2101.        
  2102.         return $this->renderView('sermon_storehouse_page', array(   
  2103.             'sermon_id' => $sermonID,  
  2104.             'sermon_info' => $aSermon,
  2105.             'author_list' => $aAuthor,
  2106.             'topic_list' => $aTopic,
  2107.             'sermon_ref' => $aSermonRef,
  2108.             'meta_desc' => $sMetaDesc        
  2109.         ));
  2110.     }
  2111.     
  2112.     /**
  2113.      * Show chapter list on a popup
  2114.      */
  2115.     public function selectworkcompareAction($workID, $translationUrl, $translationUrl2, $divisionUrl, $passageNumber, Request $request)
  2116.     {         
  2117.       $data['translation_url'] = $translationUrl;
  2118.       $data['translation_url2'] = $translationUrl2; 
  2119.       $data['division_url'] = $divisionUrl; 
  2120.       $data['passage_number'] = $passageNumber;      
  2121.       $data['work_id'] = $workID;   
  2122.                    
  2123.       $data['translations_by_language'] = $this->getWorkTranslationsByLanguage($workID);    
  2124.                                    
  2125.       return $this->renderView('selectworkcompare', $data);
  2126.     }
  2127.     
  2128.     /**
  2129.      * Show translation list on a popup
  2130.      */
  2131.     public function selectworktranslationAction($workID, $translationUrl, $passageNumber, $passageOrder, Request $request)
  2132.     {    
  2133.           $data['translation_url'] = $translationUrl;          
  2134.           $data['passage_number'] = $passageNumber;  
  2135.           $data['passage_order'] = $passageOrder;    
  2136.           $data['work_id'] = $workID;   
  2137.                        
  2138.           $data['translations_by_language'] = $this->getWorkTranslationsByLanguageAllType($workID);
  2139.                    
  2140.           return $this->renderView('selectworktranslation', $data);
  2141.     }
  2142.     
  2143.     /**
  2144.      * Show translation list on a popup
  2145.      */
  2146.     public function selectworkpassageAction($workID, $translationUrl, Request $request)
  2147.     {    
  2148.           $data['translation_url'] = $translationUrl;                       
  2149.           $data['passage_list'] = $this->getWorkPassages($workID);
  2150.           $data['work_id'] = $workID;
  2151.                    
  2152.           return $this->renderView('selectpassage', $data);
  2153.     }
  2154.     
  2155.     /**
  2156.      * Show work list on a popup
  2157.      */
  2158.     public function selectworkAction($workID, $translationID, $languageID, Request $request)
  2159.     {    
  2160.           $data['translation_id'] = $translationID;          
  2161.           $data['language_id'] = $languageID;      
  2162.           $data['work_id'] = $workID;   
  2163.                        
  2164.           $data['swedenborg_works'] = $this->getCategorizedSwedenborgWorksForTranslation($request, $translationID, $languageID);
  2165.                    
  2166.           return $this->renderView('selectwork', $data);
  2167.     }
  2168.     
  2169.     /**
  2170.      * Show translation list on a popup
  2171.      */
  2172.     public function selectsearchtranslationAction($workID, $translationID, $passageID, Request $request)
  2173.     {    
  2174.           $data['translation_id'] = $translationID;          
  2175.           $data['passage_id'] = $passageID;      
  2176.           $data['work_id'] = $workID;   
  2177.            
  2178.           $nLanguageID = $this->getLanguageIDByTranslation($translationID); 
  2179.           if($nLanguageID != $this->LANGUAGE_ID_LATIN)          
  2180.             $request->getSession()->set('last_quickview_language_id', $nLanguageID); 
  2181.                   
  2182.           $sLanguages = "";
  2183.           if($nLanguageID == $this->LANGUAGE_ID_LATIN)            
  2184.             $sLanguages = $nLanguageID . ", " . $request->getSession()->get('last_quickview_language_id');           
  2185.           else
  2186.             $sLanguages = $nLanguageID . ", " . $this->LANGUAGE_ID_LATIN;
  2187.                                  
  2188.           $data['translations_by_language'] = $this->getWorkTranslationsByLanguage($workID, $sLanguages);
  2189.                    
  2190.           return $this->renderView('selectsearchtranslation', $data);
  2191.     }
  2192.     
  2193.     /**
  2194.      * Show translation list on a popup
  2195.      */
  2196.     public function selectstorytranslationforworkAction($workID, $storyID, $translationID, Request $request)
  2197.     {    
  2198.       $locale = $request->getLocale();
  2199.       $data['work_id'] = $workID;  
  2200.       $data['translation_id'] = $translationID;       
  2201.       $data['story_id'] = $storyID;   
  2202.                            
  2203.       $data['story_explanations'] = $this->getWorkListForStory($locale, $storyID);
  2204.                
  2205.       return $this->renderView('selectstorytranslationforwork', $data);
  2206.     }
  2207.     
  2208.     public function search_conceptAction(Request $request)
  2209.     {            
  2210.         $locale = $request->getLocale();
  2211.         $searchedResults = array();
  2212.         $sSearchTerm = $request->query->get('searchTerm');  
  2213.         $nStartNum = $request->query->get('startnum');      
  2214.         if($sSearchTerm != '')
  2215.         {
  2216.             //$searchedResults = $this->getSearchedConcept($locale, $request);
  2217.             $searchedResults = $this->getSearchedListByCategory($this->CATEGORY_ID_CONCEPT, $locale, $request);
  2218.         }    
  2219.         else
  2220.         {            
  2221.             //$searchedResults = $this->getConceptList($nStartNum, $request);
  2222.             $searchedResults = $this->getAllListByCategory($this->CATEGORY_ID_CONCEPT, $locale, $request);            
  2223.         }            
  2224.         
  2225.         return $this->renderView('concept_searched', array(     
  2226.             'searched_results' => $searchedResults           
  2227.         ));
  2228.     }    
  2229.     
  2230.     public function featured_conceptsAction(Request $request)
  2231.     {                   
  2232.         $this->onloadPage($request);
  2233.         $locale = $request->getLocale();
  2234.         $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_CONCEPT, $locale, 9, false);
  2235.         if(empty($featuredList))
  2236.             $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_CONCEPT, $locale, 9, true);
  2237.         return $this->renderView('concepts_featured', array(     
  2238.             'featured_records' => $featuredList            
  2239.         ));
  2240.     }    
  2241.     
  2242.     /**
  2243.      * Show translation list on a popup
  2244.      */
  2245.     public function selectbiblebooksummaryAction($translationID, $BibleBookIDForSummary, Request $request)
  2246.     {           
  2247.       $data['translation_id'] = $translationID;                               
  2248.       $data['book_summaries'] = $this->getBibleBookSummaryList($BibleBookIDForSummary);
  2249.                
  2250.       return $this->renderView('selectbiblebooksummary', $data);
  2251.     }
  2252.     
  2253.     /**
  2254.      * Show translation list on a popup
  2255.      */
  2256.     public function selectbiblechaptersummarytranslationAction($translationID, Request $request)
  2257.     {           
  2258.       $data['translation_id'] = $translationID;                               
  2259.       $data['chapter_summary_translations'] = $this->getChapterExplanationsForPopup($translationID);
  2260.                
  2261.       return $this->renderView('selectbiblechaptersummarytranslation', $data);
  2262.     }
  2263.     
  2264.     public function selectbiblestudyAction(Request $request)
  2265.     {       
  2266.       $locale = $request->getLocale();  
  2267.       //$sSearchText = $request->query->get('st');
  2268.                        
  2269.       $data['biblestudy_data'] = $this->getBibleStudyList($locale); 
  2270.                     
  2271.       return $this->renderView('selectbiblestudy', $data);
  2272.     } 
  2273.     
  2274.     /**
  2275.      * Show translation list on a popup
  2276.      */
  2277.     public function selectbibleversesummaryAction($workID, $chapterID, $languageID, Request $request)
  2278.     {                  
  2279.           $data['work_id'] = $workID;     
  2280.           $data['verse_explanations'] = $this->getVerseExplanations($chapterID, $languageID, $request);
  2281.                    
  2282.           return $this->renderView('selectbibleversesummary', $data);
  2283.     }
  2284.     
  2285.     /**
  2286.      * Show work list on a popup for search
  2287.      */
  2288.     public function selectworksforsearchAction(Request $request)
  2289.     {    
  2290.           $nLanguageID = $request->query->get('lang');    
  2291.                        
  2292.           $data['swedenborg_works'] = $this->getCategorizedSwedenborgWorksForTranslation($request, null, $nLanguageID);
  2293.                    
  2294.           return $this->renderView('selectworksforsearch', $data);
  2295.     }
  2296.     
  2297.     /**
  2298.      * Show work translation list on a popup for search
  2299.      */
  2300.     public function selectworktranslationsforsearchAction(Request $request)
  2301.     {    
  2302.           $nLanguageID = $request->query->get('lang'); 
  2303.           $sSelectedWorkIDs = $request->query->get('selectedworkids');  
  2304.           $sWorkType = $request->query->get('worktype'); 
  2305.                        
  2306.           $data['work_translations'] = $this->getSWWorkTranslations($sSelectedWorkIDs, $nLanguageID, $sWorkType);
  2307.                    
  2308.           return $this->renderView('selectworktranslationsforsearch', $data);
  2309.     }
  2310.     
  2311.     /**
  2312.      * Show work translation list on a popup for reading plan step
  2313.      */
  2314.     public function selectworktranslationforreadingplanAction(Request $request)
  2315.     {    
  2316.           $nWorkID = $request->query->get('wid'); 
  2317.           $sTranslationUrl = $request->query->get('turl');
  2318.           $sReadingPlanUrl = $request->query->get('rpurl'); 
  2319.           $nStepOrder = $request->query->get('step'); 
  2320.           $nSW = $request->query->get('sw');  
  2321.           
  2322.           $data['work_id'] = $nWorkID;
  2323.           $data['translation_url'] = $sTranslationUrl;          
  2324.           $data['readingplan_url'] = $sReadingPlanUrl;  
  2325.           $data['step_order'] = $nStepOrder; 
  2326.                                  
  2327.           $data['translations_by_language'] = $this->getWorkTranslationsByLanguageAllType($nWorkID);
  2328.                    
  2329.           return $this->renderView('selectworktranslationforreadingplan', $data);
  2330.     }
  2331.     
  2332.     /**
  2333.      * Show work translation list on a popup for reading plan step
  2334.      */
  2335.     public function selectexplanationtranslationforreadingplanAction(Request $request)
  2336.     {    
  2337.           $nWorkID = $request->query->get('wid'); 
  2338.           $sTranslationUrl = $request->query->get('turl');
  2339.           $sReadingPlanUrl = $request->query->get('rpurl'); 
  2340.           $nStepOrder = $request->query->get('step');   
  2341.           
  2342.           $data['work_id'] = $nWorkID;
  2343.           $data['translation_url'] = $sTranslationUrl;          
  2344.           $data['readingplan_url'] = $sReadingPlanUrl;  
  2345.           $data['step_order'] = $nStepOrder; 
  2346.                                  
  2347.           $data['translations_by_language'] = $this->getWorkTranslationsByLanguageAllType($nWorkID);
  2348.                    
  2349.           return $this->renderView('selectexplanationtranslationforreadingplan', $data);
  2350.     }
  2351.     
  2352.     /**
  2353.      * Show work list on a popup
  2354.      */
  2355.     public function selectbiblechaptersummaryworkAction($translationID, Request $request)
  2356.     {           
  2357.       $aTrans = $this->getWorkTranslationData($translationID);        
  2358.       $nWorkID = $aTrans['work_id'];
  2359.       $data['translation_id'] = $translationID;     
  2360.       $data['work_id'] = $nWorkID;                              
  2361.       $data['chapter_summary_works'] = $this->getChapterExplanationWorksForPopup($translationID);
  2362.                
  2363.       return $this->renderView('selectbiblechaptersummarywork', $data);
  2364.     }
  2365.     
  2366.     public function fullviewTranslationPassageAction($passageId, $translationId, Request $request)
  2367.     {        
  2368.            $sSql = "select url FROM expositiontranslation where id = " . $translationId;
  2369.            
  2370.  //   echo $sSql."<br>";   
  2371.        $sUrl = $this->getSingleData($sSql);
  2372.        
  2373.        $sLink = $this->get('router')->generate('exposition_translation_passage', array(
  2374.                         'translationUrl' => $sUrl,
  2375.                         'passageId' => $passageId                      
  2376.                     ));
  2377.             
  2378.        if(!empty($sLink))
  2379.                return $this->redirect($sLink, 301);            
  2380.        else
  2381.             return $this->redirect("/", 301);
  2382.     }
  2383.     
  2384.     public function projecthubAction(Request $request)
  2385.     {            
  2386.         $locale = $request->getLocale(); 
  2387.         $data = array(                         
  2388.         );
  2389.         $this->setCurrentUrl($request); 
  2390.         $this->onloadPage($request);
  2391.         return $this->renderView('projecthub', $data);
  2392.     }
  2393.     
  2394.     public function search_projectAction(Request $request)
  2395.     {            
  2396.         $locale = $request->getLocale();
  2397.         $searchedResults = array();
  2398.         $sSearchTerm = $request->query->get('searchTerm');  
  2399.         $nStartNum = $request->query->get('startnum');      
  2400.         if($sSearchTerm != '')
  2401.         {
  2402.             $searchedResults = $this->getSearchedProject($locale, $request);
  2403.         }    
  2404.         else
  2405.         {            
  2406.             $searchedResults = $this->getExplanationList($nStartNum, $locale, $request);
  2407.         }            
  2408.         
  2409.         return $this->renderView('project_searched', array(     
  2410.             'searched_project' => $searchedResults,
  2411.             'start_num' => $nStartNum           
  2412.         ));
  2413.     }
  2414.         
  2415.     public function getSearchedProject($locale, $request)
  2416.     {        
  2417.         $search = new PostgresSearch();
  2418.         $em = $this->getDoctrine()->getManager();
  2419.         $search->setManager($em);
  2420.         $sCategoryId = 52;
  2421.         return $search->getCategorySearchResults($sCategoryId, $locale, $request);
  2422.     }
  2423.     
  2424.     public function featured_projectsAction(Request $request)
  2425.     {                   
  2426.         $this->onloadPage($request);
  2427.         $locale = $request->getLocale();
  2428.         $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_PROJECT, $locale, 9, false);
  2429.         if(empty($featuredList))
  2430.             $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_PROJECT, $locale, 9, true);
  2431.         return $this->renderView('projects_featured', array(     
  2432.             'featured_records' => $featuredList            
  2433.         ));
  2434.     }
  2435.     
  2436.     public function search_concordanceAction(Request $request)
  2437.     {            
  2438.         $locale = $request->getLocale();
  2439.         $searchedResults = array();
  2440.         $sSearchTerm = $request->query->get('searchTerm');  
  2441.         //$nStartNum = $request->query->get('startnum');      
  2442.         if($sSearchTerm != '')
  2443.         {            
  2444.             //$searchedResults = $this->getSearchedListByCategory($this->CATEGORY_ID_CONCORDANCE, $locale, $request);
  2445.             $searchedResults = $this->getListByCategoryWithSearchTerm($request, $locale, $this->CATEGORY_ID_CONCORDANCE, $sSearchTerm);
  2446.         }    
  2447.         else
  2448.         {
  2449.             $searchedResults = $this->getAllListByCategory($this->CATEGORY_ID_CONCORDANCE, $locale, $request);
  2450.         }            
  2451.         
  2452.         return $this->renderView('concordance_searched', array(     
  2453.             'searched_results' => $searchedResults           
  2454.         ));
  2455.     }
  2456.     
  2457.     public function featured_concordanceAction(Request $request)
  2458.     {                       
  2459.     //    $this->setCurrentUrl($request); 
  2460.         $this->onloadPage($request);
  2461.         $locale = $request->getLocale();        
  2462.         $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_CONCORDANCE, $locale, 9);
  2463.         if(empty($featuredList))
  2464.             $featuredList = $this->getFeaturedListByCategory($this->CATEGORY_ID_CONCORDANCE, $locale, 9, true);
  2465.         $request->getSession()->set('searched_concordance_list', array());
  2466.         return $this->renderView('concordance_featured', array(     
  2467.             'featured_concordance' => $featuredList            
  2468.         ));
  2469.     }
  2470. }