src/NCBS/WebsiteBundle/Controller/DefaultController.php line 596

Open in your IDE?
  1. <?php
  3. namespace NCBS\WebsiteBundle\Controller;
  5. use Symfony\Component\HttpFoundation\Request;
  6. //s33: what else because constants?
  7. // use Symfony\Bundle\FrameworkBundle\Controller\Controller as SymCon;
  8. // class DefaultController extends SymCon // NCBSWController
  9. // cant, because:  consts 
  11. use Symfony\Component\Yaml\Yaml;
  13. class DefaultController extends NCBSWController
  14. {
  15.     protected $prefix = 'Default';
  16.     
  17.     public function indexAction(Request $request)
  18.     {    
  19.         $locale = $request->getLocale();
  20.         $this->onloadPage($request);
  21.         $bibleTranslationUrl = $this->DEFAULT_BIBLE_VERSION;
  22.         $nBibleTransID = $request->getSession()->get('current_bible_translation_id');
  23.         if($nBibleTransID != '')
  24.         {   
  25.                $bibleTranslation = $this->getBibleTranslationByID($nBibleTransID);
  26.                if(!empty($bibleTranslation))
  27.                    $bibleTranslationUrl = $bibleTranslation['url'];
  28.         } 
  29.         else
  30.         {
  31.             $bibleTranslation = $this->getDefaultBibleTranslationByLocale($locale);
  32.             if(!empty($bibleTranslation))
  33.                    $bibleTranslationUrl = $bibleTranslation['url'];
  34.         } 
  35.         
  36.         $nFeaturedNum = 6;
  37.         $nSeeMore = $request->query->get('mfc');
  38.         $bSeeMore = ($nSeeMore == 1);
  39.         if($bSeeMore)
  40.             $nFeaturedNum += 20;
  41.         
  42.         $featureData = $this->getFeaturedContentList($locale, $nFeaturedNum, false); 
  43.         if(empty($featureData))
  44.             $featureData = $this->getFeaturedContentList($locale, $nFeaturedNum, true);
  45.     
  46.         $indexData = array(
  47.             'feature_data' => $featureData,           
  48.             'bible_translation_url' => $bibleTranslationUrl,
  49.             'see_more' => $bSeeMore   
  50.         );
  51.         
  52.         $request->getSession()->set('searched_bible_story_list', array());
  53.         $request->getSession()->set('searched_topic_list', array());
  54.         
  55.         return $this->renderView('index', $indexData);
  56.     }
  57.     public function aboutAction(Request $request)
  58.     {
  59.         $this->setCurrentUrl($request); 
  60.         $this->onloadPage($request);
  61.         return $this->renderView('about', array());
  62.     }
  63.     public function no_contentAction(Request $request)
  64.     {
  65.         $this->setCurrentUrl($request); 
  66.         $this->onloadPage($request);
  67.         return $this->renderView('no_content', array());
  68.     }
  69.     public function the_planAction(Request $request)
  70.     {
  71.         $this->setCurrentUrl($request); 
  72.         $this->onloadPage($request);
  73.         return $this->renderView('the_plan', array());
  74.     }
  75.     public function mobile_appAction(Request $request)
  76.     {
  77.         $this->setCurrentUrl($request); 
  78.         $this->onloadPage($request);
  79.         return $this->renderView('mobile_app', array());
  80.     }
  81.     public function biblenavtestAction(Request $request)
  82.     {
  83.         $this->setCurrentUrl($request); 
  84.         $this->onloadPage($request);
  85.         return $this->renderView('biblenavtest', array());
  86.     }
  87.     public function swedenborg_nav_widgetAction(Request $request)
  88.     {
  89.         $this->setCurrentUrl($request); 
  90.         $this->onloadPage($request);
  91.         return $this->renderView('swedenborg_nav_widget', array());
  92.     }
  93.     public function swedenborg_testAction(Request $request)
  94.     {
  95.         $this->setCurrentUrl($request); 
  96.         $this->onloadPage($request);
  97.         $locale = $request->getLocale();
  98.         $nLocaleLanguageID = $this->getLanguageIDByShortCode($locale);
  99.         
  100.         $nSelectedLangID = $request->query->get('l');
  101.         
  102.         return $this->renderView('swedenborg_test', array(          
  103.             'works' => $this->getSwedenborgWorks($request, $nLocaleLanguageID, $nSelectedLangID),
  104.             'languages' => $this->getSwedenborgWorkLanguages($request),
  105.             'selected_language_id' => $nSelectedLangID,
  106.             'search_domain' => 'w'
  107.         ));
  108.     }
  109.     public function new_church_mapAction(Request $request)
  110.     {
  111.         $this->setCurrentUrl($request); 
  112.         $this->onloadPage($request);
  113.         return $this->renderView('new_church_map', array());
  114.     }
  115.     public function bible_studiesAction(Request $request)
  116.     {
  117.         $this->setCurrentUrl($request); 
  118.         $this->onloadPage($request);
  119.         return $this->renderView('bible_studies', array());
  120.     }
  121.     public function newsAction(Request $request)
  122.     {
  123.         $this->setCurrentUrl($request); 
  124.         $this->onloadPage($request);
  125.         return $this->renderView('news', array());
  126.     }
  127.     public function site_searchAction(Request $request)
  128.     {
  129.         $this->setCurrentUrl($request); 
  130.         $this->onloadPage($request);
  131.         return $this->renderView('site_search', array());
  132.     }    
  133.     public function neosearchAction(Request $request)
  134.     {
  135.         $this->setCurrentUrl($request); 
  136.         $this->onloadPage($request);
  137.         return $this->renderView('neosearch', array());
  138.     }
  139.     public function donateAction(Request $request)
  140.     {
  141.         $this->setCurrentUrl($request); 
  142.         $this->onloadPage($request);
  143.         return $this->renderView('donate', array());
  144.     }
  145.     public function donation_thank_youAction()
  146.     {
  147.         return $this->renderView('donation_thank_you', array());
  148.     }    
  149.     public function contactAction(Request $request)
  150.     {
  151.         return $this->renderView('contact', array());
  152.     }
  153.     public function resourcesAction(Request $request)
  154.     {
  155.         $this->setCurrentUrl($request); 
  156.         $this->onloadPage($request);
  157.         return $this->renderView('resources', array());
  158.     }
  159.     public function additional_translationsAction(Request $request)
  160.     {
  161.         $this->setCurrentUrl($request); 
  162.         $this->onloadPage($request);
  163.         return $this->renderView('additional_translations', array());
  164.     }
  165.     public function swedenborg_research_toolsAction(Request $request)
  166.     {
  167.         $this->setCurrentUrl($request); 
  168.         $this->onloadPage($request);
  169.         return $this->renderView('swedenborg_research_tools', array());
  170.     }
  171.     public function explanatory_worksAction(Request $request)
  172.     {
  173.         $this->setCurrentUrl($request); 
  174.         $this->onloadPage($request);
  175.         return $this->renderView('explanatory_works', array());
  176.     }
  177.     public function bible_commentaryAction(Request $request)
  178.     {
  179.         $this->setCurrentUrl($request); 
  180.         $this->onloadPage($request);
  181.         return $this->renderView('bible_commentary', array());
  182.     }
  183.     public function swedenborg_glossaryAction(Request $request)
  184.     {
  185.         $this->setCurrentUrl($request); 
  186.         $this->onloadPage($request);
  187.         return $this->renderView('swedenborg_glossary', array());
  188.     }
  189.     public function new_church_lifeAction(Request $request)
  190.     {
  191.         $this->setCurrentUrl($request); 
  192.         $this->onloadPage($request);
  193.         return $this->renderView('new_church_life', array());
  194.     }    
  195.     public function get_involvedAction(Request $request)
  196.     {
  197.         $this->setCurrentUrl($request); 
  198.         $this->onloadPage($request);
  199.         return $this->renderView('get_involved', array());
  200.     }    
  201.     public function partnersAction(Request $request)
  202.     {
  203.         $this->setCurrentUrl($request); 
  204.         $this->onloadPage($request);
  205.         return $this->renderView('partners', array());
  206.     }
  207.     public function terms_of_useAction(Request $request)
  208.     {
  209.         $this->setCurrentUrl($request); 
  210.         $this->onloadPage($request);
  211.         return $this->renderView('terms_of_use', array());
  212.     }
  213.     public function privacy_policyAction(Request $request)
  214.     {
  215.         $this->setCurrentUrl($request); 
  216.         $this->onloadPage($request);
  217.         return $this->renderView('privacy_policy', array());
  218.     }
  219.     public function storeAction(Request $request)
  220.     {
  221.         $this->setCurrentUrl($request); 
  222.         $this->onloadPage($request);
  223.         return $this->renderView('store', array());
  224.     }         
  225.     public function explanation_formAction(Request $request)
  226.     {
  227.         $this->setCurrentUrl($request); 
  228.         $this->onloadPage($request);
  229.         return $this->renderView('explanation_form', array());
  230.     } 
  231.     public function spiritual_topic_formAction(Request $request)
  232.     {
  233.         $this->setCurrentUrl($request); 
  234.         $this->onloadPage($request);
  235.         return $this->renderView('spiritual_topic_form', array());
  236.     }
  237.     public function bible_story_formAction(Request $request)
  238.     {
  239.         $this->setCurrentUrl($request); 
  240.         $this->onloadPage($request);
  241.         return $this->renderView('bible_story_form', array());
  242.     }
  243.     public function mailing_listAction(Request $request)
  244.     {
  245.         $this->setCurrentUrl($request); 
  246.         $this->onloadPage($request);
  247.         return $this->renderView('mailing_list', array());
  248.     }
  249.     public function daily_verseAction(Request $request)
  250.     {
  251.         $this->setCurrentUrl($request); 
  252.         $this->onloadPage($request);
  253.         $sText = $this->getDailyVerse($request);   
  254.         $data = array(
  255.                'daily_verse_text' => $sText            
  256.         );
  257.         return $this->renderView('daily_verse', $data);
  258.     }
  259. /*    public function q_and_aAction(Request $request)
  260.     {
  261.         $this->setCurrentUrl($request); 
  262.         $this->onloadPage($request);
  263.         return $this->renderView('q_and_a', array());
  264.     } */
  265.     public function classes_and_groupsAction(Request $request)
  266.     {
  267.         $this->setCurrentUrl($request); 
  268.         $this->onloadPage($request);
  269.         $aLanguage = $this->getLanguageListForClassHub();   
  270.         $data = array(
  271.                'language_list' => $aLanguage            
  272.         );
  273.         return $this->renderView('classes_and_groups', $data);
  274.     }
  275.     public function noteAction($status_code)
  276.     {        
  277.         $noteData = array(
  278.             'status_code' => $status_code        
  279.         );
  280.         return $this->renderView('note', $noteData);
  281.     }   
  282.     
  283.     public function work_translationAction(Request $request)
  284.     {      
  285.         $this->setCurrentUrl($request); 
  286.         $this->onloadPage($request);
  287.         return $this->renderView('work_translation', array());
  288.     }  
  289.     
  290.     public function conceptsAllAction(Request $request)
  291.     {      
  292.         $this->setCurrentUrl($request); 
  293.         $this->onloadPage($request);
  294.         return $this->renderView('all_concepts', array());
  295.     } 
  296.     
  297.     public function loginAction(Request $request)
  298.     {          
  299.         $this->onloadPage($request);
  300.           return $this->goToLoginPage($request);
  301.     } 
  302.     
  303.     public function registerAction(Request $request)
  304.     {
  305.         $this->onloadPage($request);
  306.         return $this->renderView('register', array());
  307.     }
  308.     
  309.     public function forgotpwdAction(Request $request)
  310.     {
  311.         $this->onloadPage($request);
  312.         return $this->renderView('forgotpwd', array());
  313.     }
  314.     
  315.     public function resendactivationcodeAction(Request $request)
  316.     {
  317.         $this->onloadPage($request);
  318.         return $this->renderView('resendactivationcode', array());
  319.     }
  320.     
  321.     public function changepwdAction(Request $request)
  322.     {
  323.         $this->onloadPage($request);
  324.         return $this->renderView('changepwd', array());
  325.     }
  326.     
  327.     public function get_session_from_admin_siteAction($user_id, $user_level, $user_lang_id, $user_bible_trans_id, Request $request)
  328.     {      
  329.         $audio_rate = @$_GET['audio_rate'];
  330.         if(empty($audio_rate))
  331.             $audio_rate = 1.0;
  332.         
  333.         $this->setsessionswhenlogin($user_id, $user_level, $user_lang_id, $user_bible_trans_id, $audio_rate, $request);
  334.         return $this->renderView('blankpage', array());       
  335.     } 
  336.     
  337.     public function reset_session_from_admin_siteAction(Request $request)
  338.     {      
  339.         self::resetPortalSession($request);
  340.         return $this->renderView('blankpage', array());       
  341.     } 
  342.     
  343.     public function myprofileAction(Request $request)
  344.     {     
  345.         //$this->setCurrentUrl($request); 
  346.         $this->onloadPage($request);
  347.         if($this->getCurrUserID($request) == '')
  348.         {
  349.             return $this->goToLoginPage($request);
  350.         } 
  351.         return $this->renderView('myprofile', array());       
  352.     } 
  353.     
  354.     public function mypreferenceAction(Request $request)
  355.     {     
  356.         //$this->setCurrentUrl($request); 
  357.         $this->onloadPage($request);        
  358.           if($this->getCurrUserID($request) == '')
  359.         {
  360.             return $this->goToLoginPage($request);
  361.         }        
  362.         return $this->renderView('mypreference', array());       
  363.     } 
  364.     
  365.     public function bookmarkAction(Request $request)
  366.     {             
  367.         //$this->setCurrentUrl($request); 
  368.         $this->onloadPage($request);
  369.         if($this->getCurrUserID($request) == '')
  370.         {
  371.             return $this->goToLoginPage($request);
  372.         } 
  373.         return $this->renderView('mybookmark', array());
  374.     }
  375.     
  376.     public function portal_homeAction()
  377.     {     
  378.         $frameData = array(
  379.             'file_name' => 'homepage'        
  380.         );
  381.         return $this->renderView('frame', $frameData);
  382.     }
  383.     
  384.     public function logoutAction(Request $request)
  385.     {   
  386.         $sCurrentPageUrl = $this->getCurrentUrl($request);     
  387.         self::resetPortalSession($request);         
  388.         $frameData = array(
  389.             'file_name' => 'sc_logout', 
  390.             'current_url' => $sCurrentPageUrl      
  391.         );
  392.         return $this->renderView('frame_logout', $frameData);
  393.     }
  394.             
  395.     public function resetPortalSession($request)
  396.     {     
  397.         $request->getSession()->set("user_id", "");  
  398.         $request->getSession()->set("user_level", ""); 
  399.         $request->getSession()->set("current_language", "");
  400.         $request->getSession()->set("current_bible_translation_id", "");
  401.         $request->getSession()->set("user_receive_verse_of_day", "");
  402.         $request->getSession()->set("audio_rate", "");    
  403.     }
  404.     
  405.     public function mynoteAction(Request $request)
  406.     {                    
  407.     //    $this->setCurrentUrl($request); 
  408.         $this->onloadPage($request);
  409.         if($this->getCurrUserID($request) == '')
  410.         {
  411.             return $this->goToLoginPage($request);
  412.         } 
  413.         
  414.         $args = @$_SERVER['QUERY_STRING'];
  415.         if(!empty($args)) 
  416.         {                
  417.             $args = '?'.$args;                   
  418.         } 
  419.         $frameData = array(
  420.             'url_param' => $args      
  421.         );
  422.         
  423.         return $this->renderView('mynote', $frameData);
  424.     }
  425.     
  426.     public function mysubjectAction(Request $request)
  427.     {                    
  428.         //$this->setCurrentUrl($request); 
  429.         $this->onloadPage($request);
  430.         if($this->getCurrUserID($request) == '')
  431.         {
  432.             return $this->goToLoginPage($request);
  433.         } 
  434.              
  435.         $frameData = array(                
  436.         );
  437.         
  438.         return $this->renderView('mysubject', $frameData);
  439.     }
  440.     
  441.     public function searchwordsAction(Request $request)
  442.     {     
  443.         $this->setCurrentUrl($request); 
  444.         $this->onloadPage($request);
  445.         $frameData = array(
  446.             'file_name' => 'searchword'        
  447.         );
  448.         return $this->renderView('searchwords', $frameData);
  449.     }
  450.     
  451.     public function swedenborgworkAction(Request $request)
  452.     {     
  453.         $this->setCurrentUrl($request); 
  454.         $this->onloadPage($request);
  455.         $frameData = array(
  456.             'file_name' => 'vexpositiontransforpubliclist'        
  457.         );
  458.         return $this->renderView('frame_works_in_language', $frameData);
  459.     }
  460.     
  461.     public function swedenborgglossaryAction(Request $request)
  462.     {     
  463.         $this->setCurrentUrl($request); 
  464.         $this->onloadPage($request);
  465.         $frameData = array();
  466.         return $this->renderView('swedenborg_glossary', $frameData);
  467.     } 
  468.     
  469.     public function myreadingplanAction(Request $request)
  470.     {     
  471.         //$this->setCurrentUrl($request); 
  472.         $this->onloadPage($request);
  473.         if($this->getCurrUserID($request) == '')
  474.         {
  475.             return $this->goToLoginPage($request);
  476.         } 
  477.         return $this->renderView('myreadingplan', array());       
  478.     }    
  479.     
  480.     public function testAction(Request $request)
  481.     {   
  482.         $this->onloadPage($request);    
  483.         $indexData = array(
  484.             'user_agent' => @$_SERVER['HTTP_USER_AGENT'],
  485.             'is_mobile' => $this->isOnMobile()
  486.         );
  487.                             
  488. /*        $aReplace = array(
  489.                 '_8100_' => "Test Book",
  490.                 '_8210_' => "2",
  491.                 '_8220_' => "6"
  492.             );    
  493.         
  494.         $indexData['range_name2'] = $this->ui_string_replace($request->getSession()->get('ui_str')["bible.chapternav.bookchapterrange"], $aReplace);  */
  495.             
  496.         return $this->renderView('test', $indexData);
  497.     }
  498.     
  499.     public function explainchapterAction(Request $request)
  500.     {                    
  501.         $this->setCurrentUrl($request); 
  502.         $this->onloadPage($request);
  503.         if($this->getCurrUserID($request) == '')
  504.         {
  505.             return $this->goToLoginPage($request);
  506.         } 
  507.              
  508.         $frameData = array(                
  509.         );
  510.         
  511.         return $this->renderView('explainchapter', $frameData);
  512.     }
  513.     
  514.     public function loginredirectAction($user_id, $user_level, $user_lang_id, $user_bible_trans_id, $signed_up_verse_of_day, Request $request)
  515.     {            
  516.         //$nUserID = $request->getSession()->get('user_id'); 
  517.         if($user_id != '')
  518.         {
  519.             $audio_rate = @$_GET['audio_rate'];
  520.             if(empty($audio_rate))
  521.                 $audio_rate = 1.0;
  522.             
  523.             $this->setsessionswhenlogin($user_id, $user_level, $user_lang_id, $user_bible_trans_id, $audio_rate, $request);
  524.             
  525.             if($signed_up_verse_of_day == 1)
  526.             {
  527.                 $request->getSession()->set("user_signed_up_verse_of_day", "1");
  528.             }            
  529.         }
  530.                 
  531.         $sFromLogin = $request->getSession()->get('from_login');
  532.            if($sFromLogin != '')
  533.            {
  534.                $request->getSession()->set("from_login", "");
  535.             $sCurrentPageUrl = $this->getCurrentUrl($request);     
  536.                                      
  537.             if($sCurrentPageUrl != '')
  538.             {            
  539.                 $request->getSession()->set("current_page_url", "");
  540.                 return $this->redirect($sCurrentPageUrl, 301); 
  541.             }
  542.         }
  543.         
  544.         return $this->redirect($this->get('router')->generate('homepage', array()), 301); 
  545.     }
  546.     
  547.     public function relatedworkpassagesAction(Request $request)
  548.     {     
  549.         $this->setCurrentUrl($request); 
  550.         $this->onloadPage($request);
  551.         $locale = $request->getLocale();
  552.         $nLanguageID = $this->getLanguageIDByShortCode($locale); 
  553.         $frameData = array(
  554.             'language_id' => $nLanguageID        
  555.         );
  556.         return $this->renderView('frame_related_passages', $frameData);
  557.     }
  558.     
  559.     public function searchtermsAction(Request $request)
  560.     {     
  561.         $this->setCurrentUrl($request); 
  562.         $this->onloadPage($request);
  563.         $frameData = array(                 
  564.         );
  565.         return $this->renderView('searchterms', $frameData);
  566.     }
  567.     
  568.     public function logoutredirectAction(Request $request)
  569.     {                     
  570.         $sCurrentPageUrl = @$_GET['cu'];             
  571.         if($sCurrentPageUrl != '')
  572.         {                    
  573.             return $this->redirect($sCurrentPageUrl, 301); 
  574.         }        
  575.         else
  576.             return $this->redirect($this->get('router')->generate('homepage', array()), 301); 
  577.     }
  578.     
  579.     public function explainchaptersumAction($cchapterID, $translationID, Request $request)
  580.     {                    
  581.         $this->setCurrentUrl($request); 
  582.         $this->onloadPage($request);
  583.         if($this->getCurrUserID($request) == '')
  584.         {
  585.             return $this->goToLoginPage($request);
  586.         } 
  587.              
  588.         $frameData = array(    
  589.             'cchapter_id' => $cchapterID,
  590.             'translation_id' => $translationID           
  591.         );
  592.         
  593.         return $this->renderView('explainchaptersum', $frameData);
  594.     }
  595.     
  596.     public function crossrefAction(Request $request)
  597.     {     
  598.         $this->setCurrentUrl($request); 
  599.         $this->onloadPage($request);
  600.         $frameData = array(
  601.                  
  602.         );
  603.         return $this->renderView('frame_cross_ref', $frameData);
  604.     }
  605.     
  606.     public function crossref2Action(Request $request)
  607.     {     
  608.         $this->setCurrentUrl($request); 
  609.         $this->onloadPage($request);
  610.         $frameData = array(
  611.                  
  612.         );
  613.         return $this->renderView('frame_cross_ref2', $frameData);
  614.     }
  615.     
  616.     public function editexplanationAction(Request $request, $translationID)
  617.     {       
  618.         $this->onloadPage($request);
  619.         if($this->getCurrUserID($request) == '')
  620.         {
  621.             return $this->goToLoginPage($request);
  622.         } 
  623.              
  624.         $frameData = array(  
  625.             'translation_id_for_update' => $translationID              
  626.         );
  627.         
  628.         return $this->renderView('editexplanation', $frameData);
  629.     }
  630.     
  631.     public function editworkAction(Request $request, $translationID, $passageNumber)
  632.     {       
  633.         $this->onloadPage($request);
  634.         if($this->getCurrUserID($request) == '')
  635.         {
  636.             return $this->goToLoginPage($request);
  637.         } 
  638.              
  639.         $frameData = array(  
  640.             'translation_id_to_edit' => $translationID,
  641.             'passage_num_to_edit' => $passageNumber              
  642.         );
  643.         
  644.         return $this->renderView('editwork', $frameData);
  645.     }
  646.     
  647.     public function checkuiAction(Request $request, $languageID)
  648.     {     
  649.         $locale = $request->getLocale();       
  650.         $sLocaleForAlert = null;   
  651.         $sUILocaleForTrans = $this->getUILocale($languageID);
  652.         if($sUILocaleForTrans != $locale)
  653.             $sLocaleForAlert = $sUILocaleForTrans;
  654.         
  655.         $data = array(  
  656.             'locale_for_alert' => $sLocaleForAlert                         
  657.         );
  658.         
  659.         return $this->renderView('checkui', $data);
  660.     }
  661.     
  662.     public function showvideoAction($YoutubeID, $ShowTimeInSeconds)
  663.     {        
  664.         $data = array(  
  665.             'youtube_id' => $YoutubeID,
  666.             'show_time_in_seconds' => $ShowTimeInSeconds                        
  667.         );
  668.         return $this->renderView('showvideo', $data);
  669.     }
  670.     
  671.     public function pageredirectAction(Request $request)
  672.     {                     
  673.         $user_id = $this->getCurrUserID($request);
  674.         if($user_id != '')
  675.         {
  676.             $bReceive = $this->getVerseOfDayStatus($user_id);
  677.             $request->getSession()->set('user_receive_verse_of_day', $bReceive);
  678.             
  679.             $nAudioRate = $this->getAudioRate($user_id);
  680.             $request->getSession()->set('current_audio_rate', $nAudioRate);
  681.         }
  682.         
  683.         $sCurrentPageUrl = $this->getCurrentUrl($request);        
  684.         if($sCurrentPageUrl != '')
  685.         {                    
  686.             return $this->redirect($sCurrentPageUrl, 301); 
  687.         }        
  688.         else
  689.             return $this->redirect($this->get('router')->generate('homepage', array()), 301); 
  690.     }
  691.     
  692.     // For the popup form to allow users to ask questions
  693.     public function ask_questionAction(Request $request)
  694.     {        
  695.         return $this->renderView('ask_question', array());
  696.     }
  697.            
  698.     public function set_sessionAction($index, Request $request)
  699.     {         
  700.         if($index == 1)
  701.         {
  702.             $request->getSession()->set('user_receive_verse_of_day', true);
  703.         }     
  704.         return $this->renderView('blankpage', array());       
  705.     }
  706.     
  707.     public function sermonhubAction(Request $request)
  708.     {
  709.         $this->setCurrentUrl($request); 
  710.         $this->onloadPage($request);
  711.         $aLanguage = $this->getLanguageListForSermonHub(); 
  712.         $aTopic = $this->getTopicListForSermonHub();
  713.         $aAuthor = $this->getAuthorListForSermonHub();  
  714.         $data = array(
  715.                'language_list' => $aLanguage,
  716.                'topic_list' => $aTopic,
  717.                'author_list' => $aAuthor            
  718.         );
  719.         return $this->renderView('sermonhub', $data);
  720.     }
  721.     
  722.     public function sermon_storehouseAction(Request $request)
  723.     {
  724.         //copy front end "Sermons" page to a new page as "Sermons"
  725.         // in the menu (url=sermon-storehouse).
  726.         // new page will only show type=gneral public
  727.         $this->setCurrentUrl($request); 
  728.         $this->onloadPage($request);
  729.         $aLanguage = $this->getLanguageListForSermonStorehouse(); 
  730.         $aTopic = $this->getTopicListForSermonStorehouse();
  731.         $aAuthor = $this->getAuthorListForSermonStorehouse();  
  732.         $data = array(
  733.                'language_list' => $aLanguage,
  734.                'topic_list' => $aTopic,
  735.                'author_list' => $aAuthor            
  736.         );
  737.         return $this->renderView('sermon_storehouse', $data);
  738.     }
  739.     
  740.     public function latin_wordsAction(Request $request)
  741.     {
  742.         $this->setCurrentUrl($request); 
  743.         $this->onloadPage($request);
  744.         return $this->renderView('latin_words', array());
  745.     }
  746.     
  747.     /**
  748.      * Show logged-in menu item list on a popup
  749.      */
  750.     public function selectloggedinmenuAction(Request $request)
  751.     {    
  752.       $data = array();         
  753.       return $this->renderView('selectloggedinmenu', $data);
  754.     }
  755.     
  756.     public function setshowbiblelinksAction($index, Request $request)
  757.     {    
  758.         $request->getSession()->set('show_bible_links', $index);
  759.         return $this->renderView('blankpage', array());       
  760.     }
  761.     
  762.     public function concepthubAction(Request $request)
  763.     {
  764.         $this->setCurrentUrl($request); 
  765.         $this->onloadPage($request);
  766.         $locale = $request->getLocale();
  767.         $nLocaleLanguageID = $this->getLanguageIDByShortCode($locale);
  768.         $aLanguage = $this->getLanguageListForConceptHub();         
  769.         $data = array(
  770.                'language_list' => $aLanguage,
  771.                'ui_language_id' => $nLocaleLanguageID      
  772.         );
  773.         return $this->renderView('concepthub', $data);
  774.     }
  775.     
  776.     public function unsubscribeAction(Request $request)
  777.     {         
  778.         $this->onloadPage($request);
  779.         $idx = $request->query->get('msg');  
  780.         if(empty($idx))
  781.         {
  782.             $sEmail = $request->query->get('em');
  783.             if(!empty($sEmail))
  784.             {                
  785.                 $sLink = "/dbadmin/unsubscribe.php?em=".$sEmail;
  786.                 return $this->redirect($sLink, 301);
  787.             }
  788.             else
  789.             {                
  790.                 $idx = 2;
  791.             }
  792.         }        
  793.         
  794.         $data = array(
  795.                'unsubscribe_idx' => $idx     
  796.         );
  797.         
  798.         return $this->renderView('unsubscribe', $data);
  799.     }
  800.     
  801.     public function gotowebsiteAction(Request $request)
  802.     {         
  803.         $nUserID = $request->getSession()->get('user_id'); 
  804.         $sLink = "";
  805.         if($nUserID != '')
  806.         {                            
  807.             $sLink = "/";                        
  808.         }
  809.         else
  810.         {
  811.             $sLink = "/dbadmin/checklogin.php";
  812.         }    
  813.         
  814.         return $this->redirect($sLink, 301);        
  815.     }
  816.     
  817.     public function mygroupAction(Request $request)
  818.     {                         
  819.         $this->onloadPage($request);
  820.         if($this->getCurrUserID($request) == '')
  821.         {
  822.             return $this->goToLoginPage($request);
  823.         } 
  824.         
  825.         $args = @$_SERVER['QUERY_STRING'];
  826.         if(!empty($args)) 
  827.         {                
  828.             $args = '?'.$args;                   
  829.         } 
  830.         $frameData = array(
  831.             'url_param' => $args      
  832.         );
  833.         
  834.         return $this->renderView('mygroup', $frameData);
  835.     }
  836.     
  837.     public function popup_formAction($typeName, Request $request)
  838.     {              
  839.         return $this->renderView($typeName, array());
  840.     }   
  841.     
  842.     public function chatbotAction(Request $request)
  843.     {                      
  844.         $locale = $request->getLocale();
  845.         $this->setCurrentUrl($request);
  846.         $this->onloadPage($request);
  847.         $nLanguageID = $this->getLanguageIDByShortCode($locale);
  848.         $rval = array();
  849.         $rval['text_to_speech'] = $this->getTextToSpeech($nLanguageID);
  850.         if($this->canUseSpeechToText())
  851.         {
  852.             $rval['speech_to_text'] = 1;
  853.             $rval['language_for_speech'] = $this->getLanguageForSpeech($locale);
  854.         }    
  855.         
  856.         // $rval['on_new_window'] = 1;
  857.                 
  858.         return $this->renderView('chatbot', $rval);        
  859.     } 
  860.     
  861.     public function chatbothelpAction(Request $request)
  862.     {         
  863.         return $this->renderView('chatbothelp', array());
  864.     } 
  865.     
  866.     public function chatbotdevAction(Request $request)
  867.     {                  
  868.         $this->onloadPage($request);
  869.         $this->setCurrentUrl($request);
  870.         $locale = $request->getLocale();
  871.         $nLanguageID = $this->getLanguageIDByShortCode($locale);
  872.         $rval = array();
  873.         $rval['text_to_speech'] = $this->getTextToSpeech($nLanguageID);        
  874.         if($this->canUseSpeechToText())
  875.         {            
  876.             $rval['speech_to_text'] = 1;
  877.             $rval['language_for_speech'] = $this->getLanguageForSpeech($locale);
  878.         }    
  879.             
  880.         return $this->renderView('chatbotdev', $rval);
  881.     }  
  882.     
  883.     public function gotoworkAction(Request $request)
  884.     {
  885.         $nTransID = @$_GET['t'];
  886.         $bTranslation = !empty($nTransID);
  887.         $nWorkID = @$_GET['w'];
  888.         $nPassageNum = @$_GET['p'];
  889.         $nSectionNum = @$_GET['s'];
  890.         $sLanguage = @$_GET['l'];
  891.         $nLanguageID = null;
  892.         $sLocale = null;
  893.         if(is_numeric($sLanguage))
  894.         {
  895.             $nLanguageID = $sLanguage;
  896.             $sSql = "select shortcode FROM language where id = " . $sLanguage;
  897.             $sLocale = $this->getSingleData($sSql);
  898.         }
  899.         else
  900.         {
  901.             $sLocale = $sLanguage;
  902.             $nLanguageID = $this->getLanguageIDByShortCode($sLocale);
  903.         }
  904.         
  905.         $bValidUrl = true;
  906.         if(!$bTranslation && empty($nWorkID)) 
  907.             $bValidUrl = false;
  908.             
  909.         if($bValidUrl && $nPassageNum == '')
  910.             $bValidUrl = false;
  911.             
  912.         if(!$bValidUrl)
  913.         {
  914.             return $this->redirect("/", 301);
  915.         }    
  916.     
  917.         $sOrderStr = "";
  918.         $sLocaleForLink = "";
  919.         if($sLocale == 'en' || empty($sLocale))
  920.         {        
  921.             
  922.         }
  923.         else
  924.         {
  925.             $sLocaleForLink = "/".$sLocale;        
  926.         }    
  927.         
  928.         if(!$bTranslation)
  929.         {
  930.             if($sLocale == 'en' || empty($sLocale))
  931.             {        
  932.                 $sOrderStr = "case when language_id=". $this->LANGUAGE_ID_ENGLISH . " then 1 else 2 end";
  933.             }
  934.             else
  935.             {    
  936.                 $sOrderStr = "case when language_id=". $nLanguageID . " then 1 else case when language_id=" . $this->LANGUAGE_ID_ENGLISH . " then 2 else 3 end end";
  937.             }
  938.         }
  939.                 
  940.         if($bTranslation)
  941.         {
  942.             if($nPassageNum == 'i')
  943.             {
  944.                 $sSql = "select '" . $sLocaleForLink . "/exposition/translation/' || t.url || '/index' from expositiontranslation t where t.id=".$nTransID;
  945.             }
  946.             else
  947.             {
  948.                 $sSql = "select '" . $sLocaleForLink . "/exposition/translation/' || t.url || '/' || d.url || '/' || p.ordering from expositiontranslation t, expositionwork w, expositionpassage p, expositiondivision d where t.id=".$nTransID." and t.ispublic and t.work_id = w.id and w.ispublic and type_id = " . $this->TRANSLATION_TYPE_ID_TEXT . " and d.work_id = w.id and p.division_id = d.id and p.swedenborgsection = " . $this->dbstr($nPassageNum);
  949.             }
  950.         }
  951.         else
  952.         {
  953.             $sSql = "select '" . $sLocaleForLink . "/exposition/translation/' || t.url || '/' || d.url || '/' || p.ordering from expositiontranslation t, expositionwork w, expositionpassage p, expositiondivision d where t.work_id=".$nWorkID." and t.ispublic and t.work_id = w.id and w.ispublic and type_id = " . $this->TRANSLATION_TYPE_ID_TEXT . " and d.work_id = w.id and p.division_id = d.id and p.swedenborgsection = " . $this->dbstr($nPassageNum) . " order by " . $sOrderStr . ", islanguagedefault desc limit 1";
  954.         }    
  955.     //    echo $sSql;
  956.         $sUrl = $this->getSingleData($sSql);
  957.     
  958.         if(!empty($nSectionNum) && $nSectionNum != 1)
  959.             $sUrl .= "#subsection-0-".$nSectionNum;
  960.                     
  961.     //echo $sUrl;    
  962.         if($sUrl != '')
  963.             return $this->redirect($sUrl, 301);
  964.         else
  965.         {
  966.             $sUrl2 = $sLocaleForLink."/no-content";
  967.             return $this->redirect($sUrl2, 301);
  968.         }        
  969.     }
  970.     
  971.     public function gotobibleAction(Request $request)
  972.     {                 
  973.         $nCBookID = $request->query->get('b'); 
  974.         $nChapternum = $request->query->get('c');
  975.         $sVerses = $request->query->get('v');
  976.         $nLanguageID = $request->query->get('l');
  977.         $nTransID = $request->query->get('t');
  978.         $nBookID = $request->query->get('nb');        
  979.         $sSql = "select shortcode FROM language where id = " . $nLanguageID;
  980.         $sLocale = $this->getSingleData($sSql);
  981.         $bFullChapter = (empty($sVerses));
  982.         $nVerseNum1 = "";
  983.         $nVerseNum2 = "";
  984.         if(!$bFullChapter)
  985.         {
  986.             $aVerse = explode("-", $sVerses);
  987.             if(count($aVerse) > 1)
  988.             {
  989.                 $nVerseNum2 = $aVerse[1];
  990.             }
  991.             
  992.             $nVerseNum1 = $aVerse[0];    
  993.         }
  994.                         
  995.         $sOrderStr = "";
  996.         $sLocaleForLink = "";
  997.         if(!empty($sLocale) && $sLocale != 'en')        
  998.         {
  999.             $sLocaleForLink = "/".$sLocale;        
  1000.         }
  1001.         
  1002.         if(!empty($nBookID))
  1003.         {
  1004.             $sSql = "";
  1005.             if($bFullChapter)
  1006.                {
  1007.                    $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where b.id = " . $nBookID . " and cc1.ordering = " . $nChapternum . " and cc1.book_id = cb.id and cv1.chapter_id = cc1.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1008.                }
  1009.                else
  1010.                {        
  1011.                 if(empty($nVerseNum2) || $nVerseNum1 == $nVerseNum2)
  1012.                 {            
  1013.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where b.id = " . $nBookID . " and cc1.ordering = " . $nChapternum . " and cv1.ordering = " . $nVerseNum1 . " and cc1.book_id = cb.id and cv1.chapter_id = cc1.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1014.                }
  1015.                else
  1016.                {
  1017.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering || '-' || cv2.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t, canonicalbiblebook cb where b.id = " . $nBookID . " and cc1.ordering = " . $nChapternum . " and cv1.ordering = " . $nVerseNum1 . " and cv2.ordering = " . $nVerseNum2 . " and cc2.id = cc1.id and cv1.chapter_id = cc1.id and cv2.chapter_id = cc2.id and cc1.book_id = cb.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";               
  1018.                }
  1019.            }
  1020.            
  1021.            $sSql .= " and t.enabled";
  1022.         }
  1023.         else
  1024.         {
  1025.             if(empty($sLocaleForLink))
  1026.             {        
  1027.                 $sOrderStr = "case when language_id=". $this->LANGUAGE_ID_ENGLISH . " then 1 else 2 end";
  1028.             }
  1029.             else
  1030.             {
  1031.                 $sSql1 = "select id from language where shortcode = '" . trim(str_replace("'", "''", $sLocale)) . "'";
  1032.                 $nUILanguageID = $this->getSingleData($sSql1);
  1033.             
  1034.                 $sOrderStr = "case when language_id=". $nUILanguageID . " then 1 else case when language_id=" . $this->LANGUAGE_ID_ENGLISH . " then 2 else 3 end end";
  1035.             }    
  1036.             
  1037.             $sSql = "";
  1038.             if($bFullChapter)
  1039.                {
  1040.                    $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where cb.id = " . $nCBookID . " and cc1.ordering = " . $nChapternum . " and cc1.book_id = cb.id and cv1.chapter_id = cc1.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1041.                }
  1042.                else
  1043.                {        
  1044.                 if(empty($nVerseNum2) || $nVerseNum1 == $nVerseNum2)
  1045.                 {            
  1046.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where cb.id = " . $nCBookID . " and cc1.ordering = " . $nChapternum . " and cv1.ordering = " . $nVerseNum1 . " and cc1.book_id = cb.id and cv1.chapter_id = cc1.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1047.                }
  1048.                else
  1049.                {
  1050.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering || '-' || cv2.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t, canonicalbiblebook cb where cb.id = " . $nCBookID . " and cc1.ordering = " . $nChapternum . " and cv1.ordering = " . $nVerseNum1 . " and cv2.ordering = " . $nVerseNum2 . " and cc2.id = cc1.id and cv1.chapter_id = cc1.id and cv2.chapter_id = cc2.id and cc1.book_id = cb.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";               
  1051.                }
  1052.            }
  1053.            
  1054.             $sSql .= " and t.enabled";
  1055.             if(!empty($nTransID))
  1056.             {
  1057.                 $sSql .= " and t.id = " . $nTransID;
  1058.             }            
  1059.             else
  1060.             {
  1061.                $sSql .= " order by " . $sOrderStr . ", languagedefault desc limit 1";
  1062.             }
  1063.        } 
  1064.  
  1065.    // echo $sSql."<br>";   
  1066.        $sLink = $this->getSingleData($sSql);
  1067.        if(!empty($sLink))
  1068.                return $this->redirect($sLink, 301);            
  1069.        else
  1070.             return $this->redirect("/", 301);            
  1071.     }
  1072.     
  1073.     public function gotobiblelinkAction(Request $request)
  1074.     {                 
  1075.         $nRefID = $request->query->get('linkid'); 
  1076.         $nTLang = $request->query->get('tlang'); // Translation Language ID
  1077.         $sLocale = $request->query->get('uilang');
  1078.         
  1079.         $sOrderStr = "";
  1080.         $sLocaleForLink = "";
  1081.         if(!empty($sLocale) && $sLocale != 'en')        
  1082.         {
  1083.             $sLocaleForLink = "/".$sLocale;            
  1084.         }    
  1085.         
  1086.         if(empty($nTLang))
  1087.         {        
  1088.             $sOrderStr = "case when language_id=". $this->LANGUAGE_ID_ENGLISH . " then 1 else 2 end";
  1089.         }
  1090.         else
  1091.         {
  1092.             $sOrderStr = "case when language_id=". $nTLang . " then 1 else case when language_id=" . $this->LANGUAGE_ID_ENGLISH . " then 2 else 3 end end";
  1093.         }
  1094.                     
  1095.         $sSql1 = "SELECT startverse_id, endverse_id FROM refbible WHERE container_id = " . $nRefID;            
  1096.     //    echo $sSql1."<br>";
  1097.         $aData = $this->getRowData($sSql1);        
  1098.         if(!empty($aData))
  1099.         {        
  1100.             $sSql = "";
  1101.             $startverse_id = trim($aData['startverse_id']); 
  1102.             $endverse_id = trim($aData['endverse_id']); 
  1103.             if($startverse_id == $endverse_id)
  1104.             {            
  1105.                    $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where cv1.id = " . $startverse_id . " and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1106.            }
  1107.            else
  1108.            {      
  1109.                    if($this->isBibleFullChapter($startverse_id, $endverse_id))
  1110.                    {
  1111.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, biblebook b, bibletranslation t, canonicalbiblebook cb where cv1.id = " . $startverse_id . " and cv1.chapter_id = cc1.id and cc1.book_id = cb.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1112.                    }
  1113.                    else
  1114.                    {      
  1115.                        $sSql .= "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc1.ordering || '/' || cv1.ordering || '-' || cv2.ordering FROM canonicalbibleverse cv1, canonicalbiblechapter cc1, canonicalbibleverse cv2, canonicalbiblechapter cc2, biblebook b, bibletranslation t, canonicalbiblebook cb where cv1.id = " . $startverse_id . " and cv2.id = " . $endverse_id . " and cc2 = cc1 and cv1.chapter_id = cc1.id and cv2.chapter_id = cc2.id and cc1.book_id = cb.id and b.canonicalization_id = cc1.book_id and b.translation_id = t.id";
  1116.                    }    
  1117.            }
  1118.            
  1119.            $sSql .= " and t.enabled order by " . $sOrderStr . ", languagedefault desc limit 1";
  1120.        // echo $sSql."<br>";   
  1121.            $sLink = $this->getSingleData($sSql);
  1122.            return $this->redirect($sLink, 301);
  1123.         }    
  1124.         else
  1125.             return $this->redirect("/", 301);        
  1126.     }
  1127.     
  1128.     public function mynotesAction(Request $request)
  1129.     {
  1130.         $nUserID = $this->getCurrUserID($request);
  1131.         if(empty($nUserID))
  1132.         {            
  1133.             return $this->redirect($this->get('router')->generate('login', array()), 301);
  1134.         }
  1135.         
  1136.         $this->setCurrentUrl($request); 
  1137.         $this->onloadPage($request);          
  1138.         $data = array(                      
  1139.         );
  1140.         return $this->renderView('mynotes', $data);
  1141.     }
  1142.     
  1143.     public function search_mynoteAction(Request $request)
  1144.     {           
  1145.         $locale = $request->getLocale();
  1146.         $searchedResults = array();
  1147.         $sSearchTerm = $request->query->get('searchTerm');  
  1148.         $nStartNum = $request->query->get('startnum'); 
  1149.         $searchedResults = $this->getMynoteList($nStartNum, $locale, $request);            
  1150.                          
  1151.         return $this->renderView('mynote_searched', array(     
  1152.             'searched_mynote' => $searchedResults['results'],
  1153.             'total_record' => $searchedResults['total_record'],
  1154.             'has_filter' => $searchedResults['has_filter'],
  1155.             'has_more' => $searchedResults['has_more'],
  1156.             'start_num' => $nStartNum           
  1157.         ));
  1158.     }
  1159.     
  1160.     public function mybookmarksAction(Request $request)
  1161.     {
  1162.         $nUserID = $this->getCurrUserID($request);
  1163.         if(empty($nUserID))
  1164.         {            
  1165.             return $this->redirect($this->get('router')->generate('login', array()), 301);
  1166.         }
  1167.         $this->setCurrentUrl($request); 
  1168.         $this->onloadPage($request);          
  1169.         $aLinkType = $this->getLinkTypeList($request);   
  1170.         $data = array(
  1171.                'linktype_list' => $aLinkType            
  1172.         );
  1173.         return $this->renderView('mybookmarks', $data);
  1174.     }
  1175.     
  1176.     public function search_mybookmarkAction(Request $request)
  1177.     {      
  1178.         $locale = $request->getLocale();
  1179.         $searchedResults = array();
  1180.         $sSearchTerm = $request->query->get('searchTerm');  
  1181.         $nStartNum = $request->query->get('startnum'); 
  1182.         $searchedResults = $this->getMybookmarkList($nStartNum, $locale, $request);            
  1183.                          
  1184.         return $this->renderView('mybookmark_searched', array(     
  1185.             'searched_mybookmark' => $searchedResults['results'],
  1186.             'total_record' => $searchedResults['total_record'],
  1187.             'has_filter' => $searchedResults['has_filter'],
  1188.             'has_more' => $searchedResults['has_more'],
  1189.             'start_num' => $nStartNum           
  1190.         ));
  1191.     }
  1192.     
  1193.     public function chatbot_widgetAction(Request $request)
  1194.     {                      
  1195.         $locale = $request->getLocale();
  1196.         $this->onloadPage($request);
  1197.         $nLanguageID = $this->getLanguageIDByShortCode($locale);
  1198.         $rval = array();
  1199.         $rval['text_to_speech'] = $this->getTextToSpeech($nLanguageID);
  1200.         if($this->canUseSpeechToText())
  1201.         {
  1202.             $rval['speech_to_text'] = 1;
  1203.             $rval['language_for_speech'] = $this->getLanguageForSpeech($locale);
  1204.         }    
  1205.         
  1206.         $rval['on_new_window'] = 1;
  1207.                 
  1208.         return $this->renderView('chatbot_widget', $rval);        
  1209.     }
  1210.     
  1211.     public function chatbotdevstreamlitAction(Request $request)
  1212.     {                  
  1213.         $this->onloadPage($request);
  1214.         $this->setCurrentUrl($request);    
  1215.         
  1216.         $nUserID = $this->getCurrUserID($request);
  1217.         $nUserIDForChat = null;
  1218.         if(empty($nUserID))
  1219.         {
  1220.             $nUserIDForChat = "t".$this->getRandomNum(); // temporary user ID
  1221.         }
  1222.         else
  1223.         {
  1224.             $nUserIDForChat = $this->simpleEncrypt($nUserID);
  1225.         }
  1226.         $bHasSessionHistory = false;
  1227.     //    $bHasChatHistory = false;
  1228.         $nSessionID = $request->getSession()->get('current_chatbot_session');
  1229.         if(empty($nSessionID))
  1230.         {
  1231.             $nSessionID = $this->getRandomNum();
  1232.             $request->getSession()->set('current_chatbot_session', $nSessionID);
  1233.         }
  1234.         else
  1235.         {
  1236.             $bHasSessionHistory = $this->hasSessionHistory($nSessionID);            
  1237.         }
  1238.         
  1239.    /*     if(!empty($nUserID))
  1240.         {
  1241.             $bHasChatHistory = $this->hasChatHistory($nUserID);
  1242.         } */
  1243.                 
  1244.         $locale = $request->getLocale();
  1245.         $nLanguageID = $this->getLanguageIDByShortCode($locale);
  1246.         $rval = array();
  1247.     //    $rval['text_to_speech'] = $this->getTextToSpeech($nLanguageID);
  1248.         $rval['user_id_for_chat'] = $nUserIDForChat;
  1249.         $rval['session_id'] = $nSessionID;
  1250.         $rval['ui_language_id'] = $nLanguageID;
  1251.         $rval['has_session_history'] = $bHasSessionHistory;
  1252.     //    $rval['has_chat_history'] = $bHasChatHistory;
  1253.     /*    if($this->canUseSpeechToText())
  1254.         {
  1255.             $locale = $request->getLocale();
  1256.             $rval['speech_to_text'] = 1;
  1257.             $rval['language_for_speech'] = $this->getLanguageForSpeech($locale);
  1258.         }    */
  1259.             
  1260.         return $this->renderView('chatbotdevstreamlit', $rval);
  1261.     }
  1262.     
  1263.     public function reset_chatsAction(Request $request)
  1264.     {  
  1265.         $nUserForChat = @$_GET['u'];
  1266.         $nLanguageID = @$_GET['l'];
  1267.         $nSessionID = $this->getRandomNum();
  1268.         $request->getSession()->set('current_chatbot_session', $nSessionID);
  1269.         $sLink = "https://newchristianchatbot.org/?u=" . $nUserForChat . "&q=&s=" . $nSessionID . "&q=&l=" . $nLanguageID;
  1270.         return $this->redirect($sLink, 301);       
  1271.     }
  1272.     
  1273.     public function selectchathistoryAction(Request $request)
  1274.     {
  1275.         $nUserIDForChat = @$_GET['u'];
  1276.         $nUILangID = @$_GET['l'];
  1277.         $nUserID = $this->getCurrUserID($request); 
  1278.         $aChat = $this->getChatHistoryList($nUserID, 20);
  1279.           $data['chat_history_list'] = $aChat['chat_list'];
  1280.      //     $data['show_more'] = $aChat['show_more'];
  1281.           $data['user_id_for_chat'] = $nUserIDForChat;
  1282.           $data['ui_language_id'] = $nUILangID;
  1283.           return $this->renderView('selectchathistory', $data);
  1284.     }
  1285.     
  1286.     public function set_chat_sessionAction(Request $request)
  1287.     {            
  1288.         $nSessionID = @$_GET['s'];
  1289.           $request->getSession()->set('current_chatbot_session', $nSessionID);
  1290.           return $this->renderView('blankpage', array());
  1291.     }
  1292.     
  1293.     public function goto_chatbot_pageAction(Request $request)
  1294.     {            
  1295.         $nUserForChat = @$_GET['u'];
  1296.         $nLanguageID = @$_GET['l'];
  1297.         $nSessionID = @$_GET['s'];
  1298.         if(empty($nSessionID))
  1299.         {
  1300.             $nSessionID = $request->getSession()->get('current_chatbot_session');
  1301.         }
  1302.         else
  1303.         {
  1304.             $request->getSession()->set('current_chatbot_session', $nSessionID);
  1305.         }    
  1306.           $sLink = "https://newchristianchatbot.org/?u=" . $nUserForChat . "&q=&s=" . $nSessionID . "&q=&l=" . $nLanguageID;
  1307.         return $this->redirect($sLink, 301);
  1308.     }
  1309.     
  1310.     public function mychatAction(Request $request)
  1311.     {                    
  1312.     //    $this->setCurrentUrl($request); 
  1313.         $this->onloadPage($request);
  1314.         if($this->getCurrUserID($request) == '')
  1315.         {
  1316.             return $this->goToLoginPage($request);
  1317.         } 
  1318.         $args = @$_SERVER['QUERY_STRING'];
  1319.         if(!empty($args)) 
  1320.         {                
  1321.             $args = '?'.$args;                   
  1322.         } 
  1323.         $frameData = array(
  1324.             'url_param' => $args      
  1325.         );
  1326.         
  1327.         return $this->renderView('mychat', $frameData);
  1328.     }
  1329.     
  1330.     public function open_chatbot_sessionAction(Request $request)
  1331.     {   
  1332.         $nSessionID = @$_GET['s'];
  1333.         if(!empty($nSessionID))        
  1334.         {
  1335.             $request->getSession()->set('current_chatbot_session', $nSessionID);
  1336.         }    
  1337.           
  1338.         return $this->redirect($this->get('router')->generate('chatbot', array()), 301);
  1339.     }
  1340.     
  1341.     public function gotobibleverseAction(Request $request)
  1342.     {                 
  1343.         $nCVerseID = $request->query->get('v');                
  1344.         $nLanguageID = $request->query->get('l');
  1345.         $nTransID = $request->query->get('t'); 
  1346.         if(empty($nLanguageID))
  1347.         {
  1348.             $nLanguageID = $this->LANGUAGE_ID_ENGLISH;
  1349.         }              
  1350.         $sSql = "select shortcode FROM language where id = " . $nLanguageID;
  1351.         $sLocale = $this->getSingleData($sSql);
  1352.                                 
  1353.         $sOrderStr = "";
  1354.         $sLocaleForLink = "";
  1355.         if(!empty($sLocale) && $sLocale != 'en')        
  1356.         {
  1357.             $sLocaleForLink = "/".$sLocale;        
  1358.         }
  1359.         
  1360.         if(empty($sLocaleForLink))
  1361.         {        
  1362.             $sOrderStr = "case when language_id=". $this->LANGUAGE_ID_ENGLISH . " then 1 else 2 end";
  1363.         }
  1364.         else
  1365.         {
  1366.             $sSql1 = "select id from language where shortcode = '" . trim(str_replace("'", "''", $sLocale)) . "'";
  1367.             $nUILanguageID = $this->getSingleData($sSql1);
  1368.         
  1369.             $sOrderStr = "case when language_id=". $nUILanguageID . " then 1 else case when language_id=" . $this->LANGUAGE_ID_ENGLISH . " then 2 else 3 end end";
  1370.         }
  1371.                     
  1372.         $sSql = "select '" . $sLocaleForLink . "/bible/' || t.url || '/' || cb.url || '/' || cc.ordering || '/' || cv.ordering FROM canonicalbibleverse cv, canonicalbiblechapter cc, biblebook b, bibletranslation t, canonicalbiblebook cb where cv.id = " . $nCVerseID . " and cv.chapter_id = cc.id and cc.book_id = cb.id and b.canonicalization_id = cc.book_id and b.translation_id = t.id";
  1373.             
  1374.         $sSql .= " and t.enabled";
  1375.         if(!empty($nTransID))
  1376.         {
  1377.             $sSql .= " and t.id = " . $nTransID;
  1378.         }            
  1379.         else
  1380.         {
  1381.            $sSql .= " order by " . $sOrderStr . ", languagedefault desc limit 1";
  1382.         }
  1383.         
  1384.    // echo $sSql."<br>";   
  1385.        $sLink = $this->getSingleData($sSql);
  1386.        if(!empty($sLink))
  1387.                return $this->redirect($sLink, 301);            
  1388.        else
  1389.             return $this->redirect("/", 301);            
  1390.     }
  1391.     
  1392.     public function gotoqbiblelinkAction(Request $request)
  1393.     {                 
  1394.         $nCVerseID = $request->query->get('v');                
  1395.         $sLink = $this->getQBibleLinkByCVerse($nCVerseID);
  1396.         if(!empty($sLink))
  1397.                return $this->redirect($sLink, 301);            
  1398.         else
  1399.             return $this->redirect("/", 301);            
  1400.     }
  1401. } // end of class