1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / ststephensauh / www / controllers /
Filename : homeController.php
back
<?php

use PHPMailer\PHPMailer\Exception;
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;

require 'vendor/autoload.php';

Flight::route('/', function () {
    require 'config.php';

    $db->where('is_delete', "0");
    $banner = $db->get('banner ', null, '*');
    $location = $db->get('location ', null, '*');
    $prayergroup = $db->get('prayergroup ', null, '*');
    $family_member = $db->get('family_member ', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


    $db->where('is_delete', "0");
    $spirituality = $db->get('spirituality ', null, '*');


    $db->where('is_delete', "0");
    $db->where('is_upcoming', '0');
        $db->orderBy('id','desc');

    $db->where("type",'News');
   // $db->where('id', $id);
    $latnews = $db->get('news_events as a', null, 'a.*,DATE_FORMAT(date,"%M  %d ") as dates ');


    $db->where('is_delete', "0");
    $db->where('is_upcoming', '1');
    $db->where('type', 'Events');
        $db->orderBy('id','desc');

    $Events = $db->get('news_events as a', null, 'a.*,DATE_FORMAT(date,"%M  %d , %y") as dates ');

    $db->where('is_delete', "0");
    $db->where('type', "About");
    $about = $db->getOne('about', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "Vicar's Message");
    $abouts = $db->getOne('about', null, '*');
	
	 $db->where('is_delete', "0");
    $db->where('type', "Secretary’s Message");
    $aboutsec  = $db->getOne('about', null, '*');
    
   include 'views/index.php';
});

Flight::route('/about-trust', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('page', "About Us");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "About Trust");
    $about = $db->getOne('about', null, '*');


    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');



    $db->where('is_delete', "0");
    $db->where('type', "Vicar's Message");
    $abouts = $db->getOne('about', null, '*');

   include 'views/about-trust.php';
});


Flight::route('/about', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('page', "About Us");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "About");
    $about = $db->getOne('about', null, '*');


    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');



    $db->where('is_delete', "0");
    $db->where('type', "Vicar's Message");
    $abouts = $db->getOne('about', null, '*');

   include 'views/about.php';
});

Flight::route('/hierarchy', function () {
    require 'config.php';

    $db->where('is_delete', "0");
    $db->where('is_main', "1");
    $hierarchy = $db->get('hierarchy ', null, '*');

    $db->where('is_delete', "0");
    $db->where('is_main', "0");
    $main = $db->get('hierarchy ', null, '*');


    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');



    $db->where('is_delete', "0");
    $db->where('page', "hierarchy");
    $banners = $db->getOne('banner', null, '*');


   include 'views/hierarchy.php';
});

Flight::route('/career', function () {
    require 'config.php';
    $career = $db->get('career ', null, '*');
    $db->where('is_delete', "0");
    $db->where('page', "career");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');



   include 'views/career.php';
});



Flight::route('/apply/@id', function ($id) {
    require 'config.php';
    $db->where('career_id', $id);
    $career = $db->get('career ', null, '*');


    $db->where('is_delete', "0");
    $db->where('page', "career");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/apply.php';
});


Flight::route('/administration/@id', function ($id) {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('year', $id);
    $administration = $db->get('administration ', null, '*');


    $db->where('is_delete', "0");
    $db->where('page', "Administration");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/administration.php';
});


Flight::route('/timing', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('page', "Holy Mass Timing");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/timing.php';
});


Flight::route('/gallery-inner/@id', function ($id) {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('parent', $id);
    $db->orderBy('img_order','asc');
    $gallery = $db->get('gallery ', null, '*');
    $db->where('is_delete', "0");
    $db->where('page', "Gallery");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/gallery-inner.php';
});

Flight::route('/gallery', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('parent', "0");
    $db->orderBy('img_order','asc');
    $gallery = $db->get('gallery ', null, '*');
    $db->where('is_delete', "0");
    $db->where('page', "Gallery");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/gallery.php';
});

Flight::route('/projects', function () {
    require 'config.php';

    $db->where('is_delete', "0");
    $Events = $db->get('project', null, 'project.*');


    $db->where('is_delete', "0");
    $db->where('page', "project");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

    include 'views/projects.php';
});

Flight::route('/project-details/@id', function ($id) {
    require 'config.php'; 

    $db->where('is_delete', "0");
    $db->where('page', "project");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_upcoming', "1");
    $db->where('is_delete', "0");
    $db->where('id', $id,'<>');
	$db->where('type', 'News');
    $db->orderBy('id','desc');
    $Events = $db->get('news_events as a', array(0,3),'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');


    $db->where('is_delete', "0");
    $db->where('project_id', $id);    
    $Ev = $db->getOne('project as a', 'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/project-details.php';
});


Flight::route('/news-event', function () {
    require 'config.php';

    $db->where('is_delete', "0");
    $db->where('is_upcoming', "0");
	$db->where('type <> "VisionNews&Events" ');
	    $db->orderBy('id','desc');

    $Events = $db->get('news_events', null, '*');


    $db->where('is_delete', "0");
    $db->where('page', "News & Events");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

    include 'views/news-event.php';
});

Flight::route('/vision-news-event', function () {
    require 'config.php';

    $db->where('is_delete', "0");
    $db->where('is_upcoming', "1");
	$db->where('type <> "VisionNews&Events" ');    $db->orderBy('id','desc');

    $Events = $db->get('news_events', null, '*');


    $db->where('is_delete', "0");
    $db->where('page', "News & Events");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

    include 'views/vision-news-event.php';
});

Flight::route('/former-vicars', function () {
    require 'config.php';

    $vicar = $db->get('vicar', null, '*');

    $db->where('is_delete', "0");
    $db->where('page', "vicar");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/former-vicars.php';
});

Flight::route('/store', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('type', "video");
    $store_video = $db->get('store', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "audio");
    $store_audio = $db->get('store', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "pdf");
    $store_pdf = $db->get('store', null, '*');

    $db->where('is_delete', "0");
    $db->where('type', "image");
    $store_image = $db->get('store', null, '*');

    $db->where('is_delete', "0");
    $db->where('page', "store");
    $banners = $db->getOne('banner', null, '*');


    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/store.php';
});


Flight::route('/validate', function () {
    require 'config.php';
   $name = $_POST['name'];
   $pwd = $_POST['pwd'];

   $db->where('password', $pwd );
   $db->where('emailid', $name);
   $user = $db->getOne('family_member', null, '*');
   if($user){
        $session_data = array(
            'user_id'=>$user['fam_id'],
            'username' =>$user['fname'],
            'email' =>$user['emailid'],
        );
        $_SESSION["member"] =$session_data ;
        Flight::redirect('/');
   }else{
        $db->where('is_delete', "0");
        $db->groupby('year', "0");
        $adm = $db->get('administration ', null, '*');
        $text = 'Invalid username or password';
        include 'views/login.php';
   }

});

Flight::route('/contact', function () {
    require 'config.php';
    $db->where('is_delete', "0");
    $db->where('page', "Contact");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

   include 'views/contact.php';
});

Flight::route('/spiritual/@id', function ($id) {
    require 'config.php'; 

    $db->where('is_delete', "0");
    $db->where('page', "News & Event details");
    $banners = $db->getOne('banner', null, '*');

  

    $db->where('spirituality_id', $id);    
    $spirituality = $db->getOne('spirituality as a', 'a.*');

    $db->where('is_delete', "0");
    $db->where('spirituality_id', $id);
    $spirituality_member = $db->get('spirituality_member', null, '*');


    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/spiritual.php';
});


Flight::route('/news-event-details/@id', function ($id) {
    require 'config.php'; 

    $db->where('is_delete', "0");
    $db->where('page', "News & Event details");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_upcoming', "0");
    $db->where('is_delete', "0");
    $db->where('id', $id,'<>');
	$db->where('type', 'News');
    $db->orderBy('id','desc');
    $Events = $db->get('news_events as a', array(0,3),'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');


    $db->where('is_delete', "0");
    $db->where('id', $id);    
        $db->orderBy('id','desc');

    $Ev = $db->getOne('news_events as a', 'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/event-news-details.php';
});


Flight::route('/vision-news-event-details/@id', function ($id) {
    require 'config.php'; 

    $db->where('is_delete', "0");
    $db->where('page', "News & Event details");
    $banners = $db->getOne('banner', null, '*');

    $db->where('is_upcoming', "1");
    $db->where('is_delete', "0");
    $db->where('id', $id,'<>');
	$db->where('type', 'News');
    $db->orderBy('id','desc');
    $Events = $db->get('news_events as a', array(0,3),'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');


    $db->where('is_delete', "0");
    $db->where('id', $id);    
        $db->orderBy('id','desc');

    $Ev = $db->getOne('news_events as a', 'a.*,DATE_FORMAT(date,"%b  %d , %Y") as dates');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');


   include 'views/vision-event-news-details.php';
});

// Flight::route('/perunnal', function () {
//     require 'config.php';
//     include 'views/perunnal.php' ;

// });

// Flight::route('/nombu', function (){
//      require 'config.php';
//      include 'views/valiyanombu.php';

// });

// Flight::route('/easter', function(){
//     require 'config.php';
//     include 'views/easterservices.php';
    
// });

// Flight::route('/hosanna', function (){
//     require 'config.php';
//     include 'views/hosannaservices.php';
    
// });

Flight::route('/search(/@prayer(/@location(/@family)))', function ($prayer,$location ,$family){
    require 'config.php';

    if (isset($_SESSION["member"]['user_id'])) {
        if($prayer !='' && $prayer !='0'){
            $db->where('a.prayergroup',$prayer);
        }
        if($location !='' && $location !='0'){
            $db->where('a.location',$location);
        }
        if($family !='' && $family !='0'){
            $db->where('fam_id',$family);
        }
        $db->join('prayergroup as b','b.id = a.prayergroup','left');
        $db->join('location as c','c.id = a.location','left');
        $family_members = $db->get('family_member as a ', null, 'a.*, b.prayergroup');
    
        $db->where('is_delete', "0");
        $db->groupby('year', "0");
        $adm = $db->get('administration ', null, '*');
    
        include 'views/search.php';
    } else {
        $db->where('is_delete', "0");
        $db->groupby('year', "0");
        $adm = $db->get('administration ', null, '*');
        $text = '';
        include 'views/login.php';
    }
    
    
});

Flight::route('/search_inner/@fam_id', function ($fam_id){
    require 'config.php';
    $db->join('prayergroup as b','b.id = a.prayergroup','left');
    $db->where('a.fam_id',$fam_id);
    $family_members = $db->get('family_member as a',null ,'a.*,b.prayergroup');

    $db->join('dependency as b','b.id = a.dependency','left');
    $db->where('a.fam_id',$fam_id);
    $fam_members = $db->get('fam_members as a',null ,'a.*, b.name,DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(),dob)), "%Y") 
    + 0 AS age');

    $db->where('is_delete', "0");
    $db->groupby('year', "0");
    $adm = $db->get('administration ', null, '*');

    
    include 'views/search_inner.php';
    
});