/admin/app/controllers/homepage_text_controller.php

<?php
class HomepageTextController  extends AppController
{
	var $name='HomepageText';
	var $components = array('Pagination','Upload','Image');
	var $helpers = array('Pagination', 'error');
	
	function index()
	{
		$this->checkSession();
		$this->layout = 'default_user_cat';
		if($_SESSION['Admin_role']==1)
		{
			$criteria= "1";
			$this->categorylist();
			//***/
			$categorysql = "SELECT category,count(*) as Noofpages from homepage_texts group by category order by category";
			$categorysql_res = mysql_query($categorysql);
			$categorysql_num = mysql_num_rows($categorysql_res);
			if($categorysql_num>0)
			{
				$listarr=array();
				while($categorysql_array = mysql_fetch_array($categorysql_res))
				{
					$listarr[]=array('categoryName'=>$categorysql_array['category'],'nooflinks'=> $categorysql_array['Noofpages']) ; 
				}
				
				$this->set('categoryarr',$listarr);
			}
			$this->set('categoryNumber',$categorysql_num);
		}
		else
			$this->redirect('/sitehelp/index');
	}
	
	function categorylist()
	{
		$categorylist = array('Home'=>'Home','Projects'=>'Projects','Vendors'=>'Vendors','Sponsors'=>'Sponsors','Auctxon'=>'Auctxon','Tickets'=>'Tickets','Memberships'=>'Memberships','Backdrops'=>'Backdrops','ScrapFOTO'=>'ScrapFOTO','Xopidia'=>'Xopidia','Event Photos'=>'Event Photos','Retouch Faces'=>'Retouch Faces','Musics'=>'Musics','Photos'=>'Photos','Passport Photo Online'=>'Passport Photo Online');
		$this->set('categorylist',$categorylist);
	}
	
	function deleteallslides()
	{
		$this->checkSession();
		if($_SESSION['Admin_role']==1)
		{
			foreach($_REQUEST['box'] as $boxindex=>$boxindexval)
			{
				$delquery = "Delete from homepage_texts where category='".$boxindexval."'";
				$delquery_res = mysql_query($delquery);
			}
		}
		$this->redirect($_SERVER['HTTP_REFERER']);
	}
	function deleteslide($category=null)
	{
		$this->checkSession();
		if($_SESSION['Admin_role']==1)
		{
			if($category)
			{
				$delquery = "Delete from homepage_texts where category='".$category."'";
				$delquery_res = @mysql_query($delquery);
			}
		}
		$this->redirect($_SERVER['HTTP_REFERER']);
	
	}
	
	function delslide($Slideid=null)
	{
		$this->checkSession();
		if($_SESSION['Admin_role']==1)
		{
			if($Slideid)
			{
				$delquery = "Delete from homepage_texts where id='".$Slideid."'";
				$delquery_res = @mysql_query($delquery);
			}
		}
		$this->redirect($_SERVER['HTTP_REFERER']);
	
	}
	function addslide($category=null)
	{
		$this->checkSession();
		$this->categorylist();
		$this->layout = 'default_user_cat';
		if($category)
			$this->set('catName',$category);
	
	}
	function saveslide($slideid=null)
	{
		if($slideid)
		{
			$destination = realpath('../../../app/webroot/homepageslide/images/') . '/';
			$file = $this->data['homepageText']['screenshot'];
			$Uploadfile = '';
		//	pr($this->data);
			$result = $this->Image->upload_image_and_thumbnail($this->data,'screenshot',300,300,'aaaa',1);
		//	echo $result ;
		///	exit();
			// upload the image using the upload component
			//$result = $this->Upload->upload($file, $destination, null, array('type' => 'resizecrop', 'size' => array('300', '200'), 'output' => 'jpg'));
			if($result!='')
			$Uploadfile = basename($result); 
			
			//$this->Upload_video->eventheader_upload($destination,'1'); 
			
			
			$insertssql = "UPDATE homepage_texts SET category = '".$this->data['homepageText']['category']."' , helptitle = '".$this->data['homepageText']['helptitle']."' , 
			helpdescription='".$this->data['homepageText']['helpdescription']."' , morelink ='".$this->data['homepageText']['morelink']."'" ;
			if($Uploadfile!='')
			$insertssql .= " , helpimage ='".$Uploadfile."' "  ;
			
			
			$insertssql .= "  where id='".$slideid."' "  ;

			$insertssql_sql = mysql_query($insertssql);	
		}
		else 
		{
			################# UPLOADING FILE <br />
			$destination = realpath('../../../app/webroot/homepageslide/images/') . '/';
			$file = $this->data['homepageText']['screenshot'];
			$Uploadfile = '';
			// upload the image using the upload component
		//	$result = $this->Upload->upload($file, $destination, null, array('type' => 'resizecrop', 'size' => array('300', '200'), 'output' => 'jpg'));
			$result = $this->Image->upload_image_and_thumbnail($this->data,'screenshot',300,300,'aaaa',1);

			if($result!='')
			$Uploadfile = basename($result);  
			//exit();
			
			/* INSERTINO in the sitehelp_group_topic_qa Table */	
			$insertssql = "INSERT INTO homepage_texts SET category = '".$this->data['homepageText']['category']."' , helptitle = '".$this->data['homepageText']['helptitle']."' , 
			helpdescription='".$this->data['homepageText']['helpdescription']."' , morelink ='".$this->data['homepageText']['morelink']."' , helpimage ='".$Uploadfile."' " ;
			
			$insertssql_sql = mysql_query($insertssql);	
			############
		
		}
		$this->redirect('homepageText/index');
	}
	
	function viewslide($category=null)
	{
				$this->checkSession();
		$this->categorylist();
		$this->layout = 'default_user_cat';

		$selectTextimg = " SELECT * FROM homepage_texts ";
		if($category)
		{
			$selectTextimg .= " where category='".$category."'";
			$this->set('categoryName',$category);
		}
		$categorysql_res = mysql_query($selectTextimg);
		$categorysql_num = mysql_num_rows($categorysql_res);
		if($categorysql_num>0)
		{
			$listarr=array();
			while($categorysql_array = mysql_fetch_array($categorysql_res))
			{
				$listarr[]=array('id'=>$categorysql_array['id'],'categoryName'=>$categorysql_array['category'],'helpimage'=>$categorysql_array['helpimage'],'helptitle'=>$categorysql_array['helptitle'],'helpdescription'=>$categorysql_array['helpdescription'],'morelink'=>$categorysql_array['morelink']) ; 
			}
					$this->set('slidearr',$listarr);

		}	
		$this->set('slideNumber',$categorysql_num);
	}
	function editslide($slideId=null)
	{
		$this->checkSession();
		$this->categorylist();
		$this->layout = 'default_user_cat';
		$selectTextimg = " SELECT * FROM homepage_texts where id='".$slideId."' ";
		$categorysql_res = mysql_query($selectTextimg);
		$categorysql_num = mysql_num_rows($categorysql_res);
		if($categorysql_num>0)
		{
			$listarr=array();
			$categorysql_array = mysql_fetch_array($categorysql_res);
				$listarr[]=array('id'=>$categorysql_array['id'],'categoryName'=>$categorysql_array['category'],'helpimage'=>$categorysql_array['helpimage'],'helptitle'=>$categorysql_array['helptitle'],'helpdescription'=>$categorysql_array['helpdescription'],'morelink'=>$categorysql_array['morelink']) ; 
		}	
		$this->set('slidearr',$listarr);
		$this->set('slideNumber',$categorysql_num);
	}
	
	
	
	
}
?>