/app/controllers/pages_controller.php

Large files files are truncated, but you can click here to view the full file

<?php

/* SVN FILE: $Id: pages_controller.php 4786 2007-04-05 17:57:00Z phpnut $ */



/**

 * Short description for file.

 *

 * This file is application-wide controller file. You can put all

 * application-wide controller-related methods here.

 *

 * PHP versions 4 and 5

 *

 * CakePHP(tm) :  Rapid Development Framework <http://www.cakephp.org/>

 * Copyright 2005-2007, Cake Software Foundation, Inc.

 *								1785 E. Sahara Avenue, Suite 490-204

 *								Las Vegas, Nevada 89104

 *

 * Licensed under The MIT License

 * Redistributions of files must retain the above copyright notice.

 *

 * @filesource

 * @copyright		Copyright 2005-2007, Cake Software Foundation, Inc.

 * @link				http://www.cakefoundation.org/projects/info/cakephp CakePHP(tm) Project

 * @package			cake

 * @subpackage		cake.cake.libs.controller

 * @since			CakePHP(tm) v 0.2.9

 * @version			$Revision: 4786 $

 * @modifiedby		$LastChangedBy: phpnut $

 * @lastmodified	$Date: 2007-04-05 12:57:00 -0500 (Thu, 05 Apr 2007) $

 * @license			http://www.opensource.org/licenses/mit-license.php The MIT License

 */



/**

 * Short description for class.

 *

 * This file is application-wide controller file. You can put all

 * application-wide controller-related methods here.

 *

 * Add your application-wide methods in the class below, your controllers

 * will inherit them.

 *

 * @package		cake

 * @subpackage	cake.cake.libs.controller

 */

class PagesController extends AppController {



    public $filelayoutName='' ;

    public $Totalrecdisplay = 20;



    /**

     * Enter description here...

     *

     * @var unknown_type

     */

    var $name = 'Pages';

    



    /**

     * Enter description here...

     *

     * @var unknown_type

     */

    var $helpers = array('Html','Friendsurl','Ajax','common');



    /**

     * This controller does not use a model

     *

     * @var $uses

     */

    var $uses=array('Xoevent','User','UserAlbum');



    /**

     * Displays a view

     *

     */

    function mywebsite() {

        $this->pageTitle = 'My Home';

        //$this->layout='photo_website';

        //This is for the up

//				if(isset($this->params['url']['usr2']))

//					$userName=$this->params['url']['usr2'];

//				else

//					$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );

//				

       

        $userName=$this->params['url']['subDomain'];

        $this->set('subDmnUserName',$userName);

        //echo "SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'";

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId,UDTL.city,UDTL.state ,UDTL.c_id FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);



            $this->Session->write('PrjUserCityId', $fetchUsers['city']);

            $this->Session->write('PrjUserStateId', $fetchUsers['state']);

            $this->Session->write('PrjUserCountryId', $fetchUsers['c_id']);

            unset($_SESSION['PrjUserCityName']);

            unset($_SESSION['PrjUserStateName']);

            unset($_SESSION['PrjUserCountryName']);

            unset($_SESSION['PrjUserLocation']);



            $this->set('profileviewUid',$fetchUsers['userId']);



            /*if($fetchUsers['GrpId']==1) {



                $this->pageTitle = ucfirst($userName) .' Home';

                $this->layout='userprofilevisit';



                $this->userProfileLeftPanel();

                $this->userProfileLeftPanel(base64_encode($fetchUsers['userId']));

                $this->getMyComments($fetchUsers['userId']);

                $this->render("userweb");

            }		//page for the users



            if($fetchUsers['GrpId']==2 || $fetchUsers['GrpId']==3) {

                $this->pageTitle = ucfirst($userName) .' Home';

                $this->Websitetemplateinfo($fetchUsers['userId']);

                $this->layout=$this->filelayoutName;

                $this->set('profileviewUid',$fetchUsers['userId']);

                $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



                $this->photohome(base64_encode($fetchUsers['userId']));

                $this->eventhome();



                //this is set here beacuse the same CAROUSEL COMPONENT will be used in the view event page (VIEWXOEVENT)

                //this is set in viewxoevent function

                $this->set("caourselType","ALBUM");

                $this->render("photohome");



            }		//page for the photographer

            */

            



            /*	if($fetchUsers['GrpId']==3)

						{

							$this->pageTitle = ucfirst($userName) .' Home';

							$this->layout='userprofilevisit';

							$this->userProfileLeftPanel();

							$this->userProfileLeftPanel(base64_encode($fetchUsers['userId']));

							$this->getMyComments($fetchUsers['userId']);

							$this->render("userweb");

							//$this->render("orgweb");	

						

						}	//page for the organization

            */

             $this->redirect('tickets/index');

        }

        else {

            //header ("HTTP/1.0 404 Not Found");

            //die();

            $this->redirect('http://www.xoimages.com/tickets');

        }

    }



    function display() {

        if (!func_num_args()) {

            $this->redirect('/');

        }



        $path=func_get_args();



        if (!count($path)) {

            $this->redirect('/');

        }



        $count  =count($path);

        $page   =null;

        $subpage=null;

        $title  =null;



        if (!empty($path[0])) {

            $page = $path[0];

        }



        if (!empty($path[1])) {

            $subpage = $path[1];

        }



        if (!empty($path[$count - 1])) {

            $title = ucfirst($path[$count - 1]);

        }



        $this->set('page', $page);

        $this->set('subpage', $subpage);

        $this->set('title', $title);

        $this->render(join('/', $path));

    }

    ########################## PHOTO GRAPHER WEB PAGES ####################################

    function Websitetemplateinfo($photoId) {

        ####### QUERY FOR WEBSITE LAYOUT ######

        $websiteQry = "SELECT layout,logoimage,backgroundimage,theme from photographer_website where user_id='".$photoId."'";

        $websiteQry_res = mysql_query($websiteQry);

        $layoutName='photoweblayout1';

        $weblogoimage = 'img/logo.gif';

        $styletheme='blue';

        $webbackimage = '';

        if(mysql_num_rows($websiteQry_res)>0) {

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);



            if($websiteQry_arr['layout']!='')

                $layoutName = 'photoweblayout'.$websiteQry_arr['layout'];



            if($websiteQry_arr['logoimage']!='')

                $weblogoimage = 'photowebsite/logo/'.$websiteQry_arr['logoimage'];



            if($websiteQry_arr['theme']!='')

                $styletheme=$websiteQry_arr['theme'];



            if($websiteQry_arr['backgroundimage']!='')

                $webbackimage = 'photowebsite/background/'.$websiteQry_arr['backgroundimage'];







        }





        $this->filelayoutName=$layoutName;



        $this->set('layoutName',$layoutName);

        $this->set('layoutlogo',$weblogoimage);

        $this->set('styletheme',$styletheme);

        $this->set('layoutbackimage',$webbackimage);

        ########################################

    }



    function photohome($userId) {

        //$userId=base64_decode($userId);

        ############################### About us Txt ##########################

        $websiteQry = "SELECT IFNULL(aboutus,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".base64_decode($userId)."'";

        $websiteQry_res = mysql_query($websiteQry);

        $websiteQry_arr = mysql_fetch_array($websiteQry_res);

        $this->set('content',substr($websiteQry_arr['abouttxt'],0,574));

        #####################################################################



        ################################ Gallery view ####################

        $criteria = " 1 and UserAlbum.user_id =".base64_decode($userId)." and UserAlbum.album_access='public'";

        $order = " id ";



        $this->set('album', $this->UserAlbum->findAll($criteria, NULL, $order, NULL, NULL));



        #################################################################



    }



    function photoaboutus() {

        ############################# URL CHECKING FOR USERNAME

        $userName=$this->params['url']['subDomain'];

        //$userName = 'aniphotoinav';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' About us';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);

            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(aboutus,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            #####################################################################

        }

        #####################################

    }



    function phototestimonial() {

        ############################# URL CHECKING FOR USERNAME

//		if(isset($this->params['url']['usr2']))

//			$userName=$this->params['url']['usr2'];

//		else

//			$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );



        $userName=$this->params['url']['subDomain'];

        //$userName = 'aniphotoinav';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            if($fetchUsers['GrpId']>2)

                $this->pageTitle = ucfirst($userName) .' Admission';

            else

                $this->pageTitle = ucfirst($userName) .' Testimonial';



            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(testimonial,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            #####################################################################

        }

        #####################################

    }



    function photoprice() {

        ############################# URL CHECKING FOR USERNAME

//		if(isset($this->params['url']['usr2']))

//			$userName=$this->params['url']['usr2'];

//		else

//			$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );



        $userName=$this->params['url']['subDomain'];

        //$userName = 'aniphotoinav';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            if($fetchUsers['GrpId']>2)

                $this->pageTitle = ucfirst($userName) .' Academic';

            else

                $this->pageTitle = ucfirst($userName) .' Price';



            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);

            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(price,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            #####################################################################

        }

        #####################################

    }



    function photocontact() {

        ############################# URL CHECKING FOR USERNAME

//		if(isset($this->params['url']['usr2']))

//			$userName=$this->params['url']['usr2'];

//		else

//			$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );



        $userName=$this->params['url']['subDomain'];

        //$userName = 'aniphotoinav';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' Contact Us';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);

            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(contactus,'Text awaiting')as abouttxt,googlelocation FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            $expgoogleloc = explode(':',$websiteQry_arr['googlelocation']);

            if(isset($expgoogleloc[0]) &&$expgoogleloc[0]!=='')

                $googlelat = $expgoogleloc[0] ;

            else

                $googlelat = 48.8567;



            if(isset($expgoogleloc[1]) && $expgoogleloc[1]!=='')

                $googlelong = $expgoogleloc[1] ;

            else

                $googlelong = 2.35099;

            $this->set('googlelat',$googlelat);

            $this->set('googlelong',$googlelong);



            #####################################################################

        }

        #####################################

    }



    function photogallery() {

        ############################# URL CHECKING FOR USERNAME

        $userName=$this->params['url']['subDomain'];

        //$userName = 'aniphotoinav';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' Gallery';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



            $this->set("caourselType","ALBUM");



            ############################### Album image and text ##########################

            $albumtit = "select * from user_albums where user_id='".$fetchUsers['userId']."' AND album_access='public'";

            $res_albumtit = mysql_query($albumtit);

            $album_no = mysql_num_rows($res_albumtit);

            if($album_no>0) {

                $res_albumtit_arr = mysql_fetch_array($res_albumtit);

                $this->set('albuminfo',$res_albumtit_arr['album_name']);

                $this->set('albumNum',$res_albumtit_arr['id']);





                if( isset($this->params['url']['album'])&&  base64_decode($this->params['url']['album']) > 1)

                    $albumid=$this->params['url']['album'];

                else

                    $albumid= base64_encode($res_albumtit_arr['id']);



                /* Category name*/

                $categorySql = "Select album_name  from user_albums where id='".base64_decode($albumid)."'";

                $categorySql_res = mysql_query($categorySql);

                $categorySql_arr = mysql_fetch_array($categorySql_res);

                $this->set('Categoryname',$categorySql_arr['album_name']);

                /**/





                ############################################# Cake AJAX Pagination

                /* Pagination and image listing */

                $select = " Select Xdet.* ";



                $from=" FROM user_albums X

					LEFT JOIN user_photo_albums Xdet ON X.id = Xdet.user_album_id AND X.user_id= Xdet.user_id ";



                $where="WHERE 1";

                if(base64_decode($albumid)>0)

                    $where .="  AND X.id='".base64_decode($albumid)."'";



                $others="  ";



                $PassParameter="album=".$albumid;



                $CountField="X.id";

                $this->set("controller","pages");

                $this->set("action","photogallery");

                $this->set("parameter",$PassParameter);



                $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);



                if(isset($this->params['url']['Page']) || isset($this->params['url']['viewphoto'])) {

                    $this->render("photogallery2","ajax");

                }



                /**/

                ############################################# Cake AJAX Pagination

                $criteria = " 1 and UserAlbum.user_id =".$fetchUsers['userId']." AND album_access='public'";

                $order = " id ";

                $this->set('album', $this->UserAlbum->findAll($criteria, NULL, $order, NULL, NULL));

                ############################### Album image and text ##########################



            }

            else

                $this->set('albuminfo',"No");

        }

        #####################################

    }



    function photoevent() {

        //$userName=$this->params['url']['subDomain'];

        $userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Event';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        $this->eventhome();



        /* EVENT Name*/

        $curDate=date("Y-m-d G:i:s");

        if(isset($_REQUEST['photoeventName']) && $_REQUEST['photoeventName']!='Event Name') {

            $evtname = $_REQUEST['photoeventName'];

            $_SESSION['sesData']['eventname'] = $evtname ;

        }

        else {

            $evtname ='';

            if(!isset($_SESSION['sesData']['eventname']))

                $_SESSION['sesData']['eventname'] = 'Event Name';

        }

        /* EVENT Name*/





        /* EVENT DATE*/

        if(isset($_REQUEST['photoeventDate']) && $_REQUEST['photoeventDate']!='mm/dd/yy') {

            $eventDate=date("Y-m-d",strtotime($_REQUEST['photoeventDate']));

        }

        else {

            $eventDate='';

            if(!isset($_SESSION['sesData']['eventdate']))

                $_SESSION['sesData']['eventdate'] = 'mm/dd/yy';

        }

        /* EVENT DATE*/



        /*EVENT CITY*/

        if(isset($_REQUEST['photoeventCity']) && $_REQUEST['photoeventCity']!='City, State of the Event') {

            $evtcity = $_REQUEST['photoeventCity'];

            $_SESSION['sesData']['photocity'] = 'City, State of the Event' ;

        }

        else {

            $evtcity = '';

            if(!isset($_SESSION['sesData']['photocity']))

                $_SESSION['sesData']['photocity'] = 'City, State of the Event';

        }







        $or1='';



        if(isset($_SESSION['sesData']['eventname']) && $_SESSION['sesData']['eventname']!='Event Name')

            $or1.=" AND ((

					XE.event_user = XU.id

					AND XU.user_group_master_id =3 

					AND EUD.org_name LIKE '%".$_SESSION['sesData']['eventname']."%'

					) OR (

						XE.event_user = XU.id

						AND XU.user_group_master_id =2 

						AND XU.username LIKE '%".$_SESSION['sesData']['eventname']."%' 

					) OR (

						XE.user_id = XU.id

						AND XE.event_name LIKE '%".$_SESSION['sesData']['eventname']."%'

					) )";



        if(isset($_SESSION['sesData']['eventdate']) && $_SESSION['sesData']['eventdate']!='mm/dd/yy')

            $or1.=" AND '".$_SESSION['sesData']['eventdate']."' BETWEEN XE.event_start_date AND XE.event_end_date";





        if(isset($_SESSION['sesData']['photocity']) && $_SESSION['sesData']['photocity']!="City, State of the Event")

            $or1.=" AND ((XE.event_city LIKE '%".$_SESSION['sesData']['photocity']."%') OR (XE.event_state LIKE '%".$_SESSION['sesData']['photocity']."%'))";





        if(isset($fetchUsers['userId']) && $fetchUsers['userId']!="")

            $or1.=" AND XE.user_id=XU.id AND XE.user_id ='".$fetchUsers['userId']."'";





        $or1.=" GROUP BY XE.id";



        $eventSec=" XE.event_cat IS NOT NULL";



        $select="SELECT XE.*,XC.category_name,XU.username";



        $from= " FROM xoevents XE,user_details EUD,users XU,xoevent_categorys XC WHERE XE.event_cat=XC.id AND XU.id= XE.user_id AND $eventSec AND is_temp='1'  AND '".$curDate."' BETWEEN event_start_date AND event_end_date";

        //$from= " FROM xoevents XE,user_details EUD,users XU,xoevent_categorys XC WHERE XE.event_cat=XC.id AND XU.id= XE.user_id AND $eventSec AND is_temp='1'";



        $where=$or1;



        $others="  ";



        $PassParameter="";



        $CountField="XE.id";



        $this->set("controller","pages");

        $this->set("action","photoevent");

        $this->set("parameter",$PassParameter);



        $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

        if(isset($this->params['url']['Page'])) {

            $this->render("photoevent2","ajax");

        }



    }



    /* Organisation Website */

    function orgaboutus() {

        ############################# URL CHECKING FOR USERNAME

        $userName=$this->params['url']['subDomain'];

        //$userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' About us';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);

            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(aboutus,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            #####################################################################

        }

        #####################################

    }



    function orggallery() {

        ############################# URL CHECKING FOR USERNAME

        $userName=$this->params['url']['subDomain'];

        //$userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' Gallery';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



            $this->set("caourselType","ALBUM");



            ############################### Album image and text ##########################

            $albumtit = "select * from user_albums where user_id='".$fetchUsers['userId']."' AND album_access='public'";

            $res_albumtit = mysql_query($albumtit);

            $album_no = mysql_num_rows($res_albumtit);

            if($album_no>0) {

                $res_albumtit_arr = mysql_fetch_array($res_albumtit);

                $this->set('albuminfo',$res_albumtit_arr['album_name']);

                $this->set('albumNum',$res_albumtit_arr['id']);





                ############################################# Cake AJAX Pagination

                if( isset($this->params['url']['album'])&&  base64_decode($this->params['url']['album']) > 1)

                    $albumid=$this->params['url']['album'];

                else

                    $albumid= base64_encode($res_albumtit_arr['id']);



                /* Category name*/

                $categorySql = "Select album_name  from user_albums where id='".base64_decode($albumid)."'";

                $categorySql_res = mysql_query($categorySql);

                $categorySql_arr = mysql_fetch_array($categorySql_res);

                $this->set('Categoryname',$categorySql_arr['album_name']);

                /**/

                /* Pagination and image listing */

                $select = " Select Xdet.* ";



                $from=" FROM user_albums X

					LEFT JOIN user_photo_albums Xdet ON X.id = Xdet.user_album_id AND X.user_id= Xdet.user_id ";



                $where="WHERE 1";

                if(base64_decode($albumid)>0)

                    $where .="  AND X.id='".base64_decode($albumid)."'";



                $others="  ";



                $PassParameter="album=".$albumid;



                $CountField="X.id";

                $this->set("controller","pages");

                $this->set("action","photogallery");

                $this->set("parameter",$PassParameter);



                $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);



                if(isset($this->params['url']['Page']) || isset($this->params['url']['viewphoto'])) {

                    $this->render("photogallery2","ajax");

                }



                /**/

                ############################################# Cake AJAX Pagination

                $criteria = " 1 and UserAlbum.user_id =".$fetchUsers['userId']." AND album_access='public'";

                $order = " id ";

                $this->set('album', $this->UserAlbum->findAll($criteria, NULL, $order, NULL, NULL));

                ############################### Album image and text ##########################

















            }

            else

                $this->set('albuminfo',"No");



        }

        #####################################

    }



    function orgcontact() {

        ############################# URL CHECKING FOR USERNAME

//		if(isset($this->params['url']['usr2']))

//			$userName=$this->params['url']['usr2'];

//		else

//			$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );



        $userName=$this->params['url']['subDomain'];

        $userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            $this->pageTitle = ucfirst($userName) .' Contact Us';

            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);

            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(contactus,'Text awaiting')as abouttxt,googlelocation FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);

            $expgoogleloc = explode(':',$websiteQry_arr['googlelocation']);

            if(isset($expgoogleloc[0]) &&$expgoogleloc[0]!=='')

                $googlelat = $expgoogleloc[0] ;

            else

                $googlelat = 48.8567;



            if(isset($expgoogleloc[1]) && $expgoogleloc[1]!=='')

                $googlelong = $expgoogleloc[1] ;

            else

                $googlelong = 2.35099;

            $this->set('googlelat',$googlelat);

            $this->set('googlelong',$googlelong);



            #####################################################################

        }

        #####################################

    }



    function orgevent() {



        $userName=$this->params['url']['subDomain'];

        //$userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Event';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        $this->eventhome();



        /* EVENT Name*/

        $curDate=date("Y-m-d G:i:s");

        if(isset($_REQUEST['photoeventName']) && $_REQUEST['photoeventName']!='Event Name') {

            $evtname = $_REQUEST['photoeventName'];

            $_SESSION['sesData']['eventname'] = $evtname ;

        }

        else {

            $evtname ='';

            if(!isset($_SESSION['sesData']['eventname']))

                $_SESSION['sesData']['eventname'] = 'Event Name';

        }

        /* EVENT Name*/





        /* EVENT DATE*/

        if(isset($_REQUEST['photoeventDate']) && $_REQUEST['photoeventDate']!='mm/dd/yy') {

            $eventDate=date("Y-m-d",strtotime($_REQUEST['photoeventDate']));

        }

        else {

            $eventDate='';

            if(!isset($_SESSION['sesData']['eventdate']))

                $_SESSION['sesData']['eventdate'] = 'mm/dd/yy';

        }

        /* EVENT DATE*/



        /*EVENT CITY*/

        if(isset($_REQUEST['photoeventCity']) && $_REQUEST['photoeventCity']!='City, State of the Event') {

            $evtcity = $_REQUEST['photoeventCity'];

            $_SESSION['sesData']['photocity'] = 'City, State of the Event' ;

        }

        else {

            $evtcity = '';

            if(!isset($_SESSION['sesData']['photocity']))

                $_SESSION['sesData']['photocity'] = 'City, State of the Event';

        }







        $or1='';



        if(isset($_SESSION['sesData']['eventname']) && $_SESSION['sesData']['eventname']!='Event Name')

            $or1.=" AND ((

					XE.event_user = XU.id

					AND XU.user_group_master_id =3 

					AND EUD.org_name LIKE '%".$_SESSION['sesData']['eventname']."%'

					) OR (

						XE.event_user = XU.id

						AND XU.user_group_master_id =2 

						AND XU.username LIKE '%".$_SESSION['sesData']['eventname']."%' 

					) OR (

						XE.user_id = XU.id

						AND XE.event_name LIKE '%".$_SESSION['sesData']['eventname']."%'

					) )";



        if(isset($_SESSION['sesData']['eventdate']) && $_SESSION['sesData']['eventdate']!='mm/dd/yy')

            $or1.=" AND '".$_SESSION['sesData']['eventdate']."' BETWEEN XE.event_start_date AND XE.event_end_date";





        if(isset($_SESSION['sesData']['photocity']) && $_SESSION['sesData']['photocity']!="City, State of the Event")

            $or1.=" AND ((XE.event_city LIKE '%".$_SESSION['sesData']['photocity']."%') OR (XE.event_state LIKE '%".$_SESSION['sesData']['photocity']."%'))";





        if(isset($fetchUsers['userId']) && $fetchUsers['userId']!="")

            $or1.=" AND XE.user_id=XU.id AND XE.user_id ='".$fetchUsers['userId']."'";





        $or1.=" GROUP BY XE.id";



        $eventSec=" XE.event_cat IS NOT NULL";



        $select="SELECT XE.*,XC.category_name,XU.username";



        $from= " FROM xoevents XE,user_details EUD,users XU,xoevent_categorys XC WHERE XE.event_cat=XC.id AND XU.id= XE.user_id AND $eventSec AND is_temp='1'  AND '".$curDate."' BETWEEN event_start_date AND event_end_date";

        //$from= " FROM xoevents XE,user_details EUD,users XU,xoevent_categorys XC WHERE XE.event_cat=XC.id AND XU.id= XE.user_id AND $eventSec AND is_temp='1'";



        $where=$or1;



        $others="  ";



        $PassParameter="";



        $CountField="XE.id";



        $this->set("controller","pages");

        $this->set("action","photoevent");

        $this->set("parameter",$PassParameter);



        $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

        if(isset($this->params['url']['Page'])) {

            $this->render("photoevent2","ajax");

        }



    }



    function orgschedule() {

        ############################# URL CHECKING FOR USERNAME

//		if(isset($this->params['url']['usr2']))

//			$userName=$this->params['url']['usr2'];

//		else

//			$userName = substr( $this->params['url']['url'], strpos($this->params['url']['url'], "=")+1,( strlen($this->params['url']['url'])-strpos(env("HTTP_HOST"), "=")) );



        $userName=$this->params['url']['subDomain'];

        //$userName='testOrganisation';



        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        if(mysql_num_rows($queryUsers)>0) {

            $fetchUsers=mysql_fetch_array($queryUsers);

            if($fetchUsers['GrpId']>2)

                $this->pageTitle = ucfirst($userName) .' Schedule';

            else

                $this->pageTitle = ucfirst($userName) .' Testimonial';



            //We are setting this variable beaciuse that willl be use in login elemenet

            $this->set("controller",$this->params['controller']);

            $this->set("action",$this->params['action']);



            $this->Websitetemplateinfo($fetchUsers['userId']);

            $this->layout=$this->filelayoutName;

            $this->set('profileviewUid',$fetchUsers['userId']);

            $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



            #################### LOGIN SECTION CODE

            #################### LOGIN SECTION CODE





            ############################### About us Txt ##########################

            $websiteQry = "SELECT IFNULL(testimonial,'Text awaiting')as abouttxt FROM photographer_website WHERE user_id='".$fetchUsers['userId']."'";

            $websiteQry_res = mysql_query($websiteQry);

            $websiteQry_arr = mysql_fetch_array($websiteQry_res);

            $this->set('content',$websiteQry_arr['abouttxt']);



            if(isset($this->data)) {

                $Id=$this->data['Event']['headerEventId'];

                $page=$this->data['Event']['page'];

                $this->set("Id",$Id);

                $this->set("page",$page);

                //pr($this->data);



                $wintype=$this->Login($this->data);

                $this->set("wintype",$wintype);

            }

            #####################################################################

        }

        #####################################

    }



    function orgticevent() {

        $userName=$this->params['url']['subDomain'];

        //$userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Tickets';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        $curDate=date("Y-m-d");



        $this->set("Userid",$fetchUsers['userId']);

        $this->set("controller","pages");

        $this->set("action","orgticevent");



        $select="SELECT T.* ,TV.id tvId,TV.venue_name venueName,USR.username,USR.id as postedbyuser,TCAT.id as ticketcategoryId ,TCAT.cat_name as ticketcategory";

        $from=" FROM tickets T

		LEFT JOIN ticket_event_venue TV ON (T.ticket_venue_section_id=TV.id)

		LEFT JOIN ticket_event_category TCAT  ON (T.ticket_category_id=TCAT.id) 

		LEFT JOIN users USR ON (T.user_id=USR.id)";



        $where="WHERE (NOW() < ticevent_enddate) ";

        $where.=" AND T.user_id='".$fetchUsers['userId']."'";



        $CountField='T.id';

        $others=" order by T.id desc ";

        //	$where='WHERE 1'; /* For testing */

        $PassParameter='';

        $this->set("PassParameter",$PassParameter);



        $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

        if(isset($this->params['url']['Page'])) {

            $this->render("orgticevent2","ajax");

        }

    }



    function orgauctxonevent() {

        $userName=$this->params['url']['subDomain'];

        //$userName = 'testOrganisation';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Tickets';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        $curDate=date("Y-m-d");



        $this->set("Userid",$fetchUsers['userId']);

        $this->set("controller","pages");

        $this->set("action","orgauctxonevent");



        $select =" SELECT auctxons.title,auctxons.objective,auctxons.enddateofdonation,auctxons.enddateofauction ,user_details.user_profile_img ,auctxons.id ,auctxons.is_featured , users.username , users.id as auctxonpostedby  ";



        $from=" from auctxons

			

			LEFT JOIN user_details On (auctxons.user_id =user_details.user_id)

			LEFT JOIN users On (auctxons.user_id =users.id) 

			";





        $where="

		WHERE auctxons.is_temp='1' and auctxons.is_delete='0' and CURDATE()>=auctxons.startdateofauction and auctxons.enddateofauction>=CURDATE() and auctxons.user_id='".$fetchUsers['userId']."'

		";



        $others=" order by auctxons.enddateofdonation  desc ";



        $PassParameter="";



        $fltr='';

        $CountField="auctxons.id";



        $this->set("fltr",$fltr);

        $this->set("PassParameter",$PassParameter);



        $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

        if(isset($this->params['url']['Page'])) {

            $this->render("orgauctxonevent2","ajax");

        }

    }



    function ajaxtimerorgauctxonlist($catId=null,$searchtxt=null,$userId=null) {



        if(isset($_SESSION['CurrentListFrom']))

            $limitfrom = $_SESSION['CurrentListFrom'] ;

        else

            $limitfrom = 0 ;



        if(isset($_SESSION['CurrentListto']))

            $limitTo = $_SESSION['CurrentListto'] ;

        else

            $limitTo = $this->Totalrecdisplay ;







        $timersql ="

		

		SELECT auctxons.title,auctxons.objective,auctxons.enddateofdonation,auctxons.enddateofauction ,user_details.user_profile_img ,auction_donor_product_final.*  

			

		from auctxons

		LEFT JOIN  auction_donor_product_final ON (auction_donor_product_final.auctxon_id=auctxons.id)

		LEFT JOIN user_details On (auctxons.user_id =user_details.user_id)

			

		WHERE auctxons.is_temp='1' and auctxons.is_delete='0'  and CURDATE()>=auctxons.startdateofauction and auctxons.enddateofauction>=CURDATE()  and auctxons.user_id='".$userId."'

		";







        $timersql.=" order by auctxons.enddateofdonation  desc , auction_donor_product_final.id desc LIMIT $limitfrom , $limitTo ";



        echo $timersql ;

        $this->set("Listquery",$timersql);

        $this->render("ajaxtimerauctxonlistdivupdate","ajax");



    }































    function orgsponsorevent() {

        $userName=$this->params['url']['subDomain'];

        //$userName = 'debopamsikder';

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Sponsors Event';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        $curDate=date("Y-m-d");



        $this->set("Userid",$fetchUsers['userId']);

        $this->set("controller","pages");

        $this->set("action","orgsponsorevent");



        ######################################################### SPONSORSHIP QUERY #####################

        $select = "

						SELECT SPON.id as sponsorshipid,SPONplan.id as Planid , SPONplan.sponsor_type_id as planTypeid,IFNULL(DATE_FORMAT(SPON.end_applied_date,'%Y-%m-%d'),CURDATE()) as lastdate , 	

		 

						IF(SPON.ticket_id>0,SPONEVENT.ticevent_name,SPON.event_title) as event_name ,  IF(SPON.ticket_id>0,SPONEVENT.ticevent_desc,SPON.event_desc) as event_desc ,  SPON.terms ,

						 

						CONCAT_WS(' , ',city_master.city_name,state.Name,countries.country_name) as sponLocation,SPONEVENT.ticevent_image , 

						

						IF(SPON.ticket_id>0,SPONEVENT.ticevent_date,SPON.starteventdate) as eventStartdate , 

						

						SPONplan.broucherfile, SPONplan.event_image, SPON.country_id, SPON.state_id , SPON.city_id, sponsor_category.catname ,  

						sponsor_category.id as plancatId  , SPONplan.id as MemberPlanId  , SPONplan.sponsor_type_id as MemberPlanList,

						SPON.is_featured AS sponsorFeatured , SPONuser.username as planowner , SPON.ticket_id ,

						SPONuser.id as planownerId	  



		";		

        $from="

				FROM sponsors SPON 

				LEFT JOIN sponsor_plan SPONplan ON SPON.id = SPONplan.sponsor_id

				LEFT JOIN tickets SPONEVENT ON SPON.ticket_id= SPONEVENT.id

				LEFT JOIN users XU ON XU.id= SPONEVENT.user_id

				LEFT JOIN user_details EUD  ON XU.id = EUD.user_id

				

				LEFT JOIN sponsor_category ON SPON.sponsor_cat_id = sponsor_category.id 

				LEFT JOIN users SPONuser ON SPONplan.user_id = SPONuser.id

				LEFT JOIN countries ON SPON.country_id = countries.id

				LEFT JOIN state ON SPON.state_id = state.id 

				LEFT JOIN city_master ON  SPON.city_id = city_master.city_id 

				"	;			

        $where=" WHERE  SPON.is_temp='0' AND SPONplan.delstatus='0' AND SPONplan.user_id='".$fetchUsers['userId']."'  AND SPON.end_applied_date > CURDATE() ";



        #####################################################



        $CountField='SPON.id';

        $others="  ";

        $PassParameter='';

        $this->set("PassParameter",$PassParameter);



        $this->pagination($select,$from,$where,$others,$CountField,$this->params['url'],$PassParameter);

        if(isset($this->params['url']['Page'])) {

            $this->render("orgticevent2","ajax");

        }

    }







    function orgproject() {

        $userName=$this->params['url']['subDomain'];

        //$userName="testOrganisation";

        $queryUsers=mysql_query("SELECT UDTL.user_id userId,U.user_group_master_id GrpId FROM users U,user_details UDTL WHERE U.id=UDTL.user_id AND U.username='".$userName."'") or die(" Error on line ".__LINE__.mysql_error());

        $fetchUsers=mysql_fetch_array($queryUsers);

        $this->pageTitle = ucfirst($userName) .' Projects';

        $this->Websitetemplateinfo($fetchUsers['userId']);

        $this->layout=$this->filelayoutName;

        $this->eventhome();

        $this->set('profileviewUid',$fetchUsers['userId']);

        $this->set('profileviewUgrpId',$fetchUsers['GrpId']);



        //I am using the same login window for the projects section so the variable name is littke weired

        //$this->data['Event']['headerEventId']

        if(!empty($this->data) && isset($this->data['Event']['headerEventId'])) {



            $projectId=$this->data['Event']['headerEventId'];

            $wintype=$this->Login($this->data);

            if($wintype=="NOT AUTH")

                $this->render("notautho");

        }



        $curDate=date("Y-m-d");



        $this->set("Userid",$fetchUsers['userId']);



        $this->set("controller","pages");

        $this->set("action","orgproject");

        $this->set("parameter",'');





        $this->set("openLoginWindow",true);

        $this->set("UserId",1);

        if(isset($_SESSION['UserId'])) {



            $this->set("openLoginWindow",false);

            $this->set("UserId",$_SESSION['UserId']);

        }



        if(isset($this->params['url']['Page'])) {

            //$this->data['Event']['page']=$this->params['url']['Page'];

            $this->set("arg",$this->params['url']);

            $this->render("orgproject2","ajax");

        }

    }



    /* Organisation Website */



    function pagination($select,$from,$where,$others,$CountField,$arg,$PassParameter) {

        if(isset($arg['Page']))

            $pageFlag=$arg['Page'];

        $this->set("PassParameter",$PassParameter);

        //$SetUserNumberOfVpsPerPage=SHOW_REC; /* Defined in config->paths.php*/

        $SetUserNumberOfVpsPerPage=12; /* Defined in config->paths.php*/



        $this->set("BackgroundClass",'pagination');

        $this->set("SelectedPage",'pagination_over');

        $this->set("Linkpage",'pagination_over');

        $this->set("FirstImage",'fdd.gif');

        $this->set("PreviousImage",'previous.gif');

        $this->set("NextImage",'next.gif');

        $this->set("LastImage",'rewd.gif');



        $UserNumberOfVpsPerPage=12; /* Defined in config->paths.php*/

        if(!is_numeric($UserNumberOfVpsPerPage)|| (intval($UserNumberOfVpsPerPage)!=$UserNumberOfVpsPerPage)||($UserNumberOfVpsPerPage<=0))

            $UserNumberOfVpsPerPage = $SetUserNumberOfVpsPerPage;



        if(!isset($arg['Page'])) $arg['Page']=1;

        if(!isset($arg['Offset'])) $arg['Offset']=0;

        $Query_ForNumber_Records=mysql_query("$select $from $where $others") or die('Line no 120' . mysql_error());

        //$Result_Query_ForNumber_Records=mysql_fetch_object($Query_Fo…