/admin/app/controllers/homepage_text_controller.php
PHP | 195 lines | 157 code | 25 blank | 13 comment | 16 complexity | d719ff1f31d08861b32ecc60cc63d5ab MD5 | raw file
Possible License(s): LGPL-2.1, AGPL-1.0, GPL-2.0, MIT
- <?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);
- }
-
-
-
-
- }
- ?>