/admin/app/controllers/classified_cat_masters_controller.php

<?php
class ClassifiedCatMastersController extends AppController
{
	var $name='ClassifiedCatMasters';
	var $components = array('Pagination');
	var $helpers = array('Pagination', 'error');

	function categorylist()
	{
		// 'Auction'=>'Auction', 'ScrapFOTO'=>'ScrapFOTO','Retouch Faces'=>'Retouch Faces',,'Photos'=>'Photos','Passport Photo Online'=>'Passport Photo Online','Musics'=>'Musics'
		$categorylist = array('Project'=>'Project','Vendors'=>'Vendors','Sponsors'=>'Sponsors','Tickets'=>'Tickets','Memberships'=>'Memberships','Backdrops'=>'Backdrops','Xopidia'=>'Xopidia','Event Photos'=>'Event Photos','Stoxfotos'=>'Stoxfotos','Auctxons'=>'Auctxons');
		$this->set('categorylist',$categorylist);
	}

	function editSave($operation=Null,$ParentId=null,$catName=null,$Catid=null)
	{
	
		if($operation=='New')
		{
			$operationsql = " Insert Into " ;
		}
		if($operation=='Edit')
		{
			$operationsql = " Update  " ;
		}
		if($ParentId=='Project')
		{
			$catsql = " project_cat SET cat_name ='".$catName."' ";
		}
		if($ParentId=='Vendors')
		{
			$catsql = " vendor_category SET catname ='".$catName."' ";
		}
		if($ParentId=='Sponsors')
		{
			$catsql = " sponsor_category SET catname ='".$catName."' ";
		}
		if($ParentId=='Tickets')
		{
			$catsql = " ticket_event_category SET cat_name ='".$catName."' ";

		}
		if($ParentId=='Memberships')
		{
			$catsql = " plan_category SET cat_name ='".$catName."' ";
		}
		if($ParentId=='Backdrops')
		{
			$catsql = " backdrop_categories SET backdrop_cat_name ='".$catName."' ";
		}
		if($ParentId=='Xopidia')
		{
			$catsql = " xopidia_category SET catname ='".$catName."' ";
		}
		if($ParentId=='Event Photos')
		{
			$catsql = " xoevent_categorys SET category_name ='".$catName."' ";
		}
		if($ParentId=='Stoxfotos')
		{
			$catsql = " stoxfoto_categories SET category_name ='".$catName."' ";
		}
		if($ParentId=='Auctxons')
		{
			$catsql = " auctxon_categories SET category_name ='".$catName."' ";
		}
		
		
		
		if($Catid)
		{
			$catsql .= " where id=".$Catid ;
		}
		
		
		
		
		
		return $operationsql.$catsql;
		
	}

	function categorySql($ParentId=null,$id=null)
	{
		if($ParentId=='Project')
		{
			$catsql = "SELECT id as CatId, cat_name as CatName, 'Project' as sectioName  from project_cat";
		}
		if($ParentId=='Vendors')
		{
			$catsql = "SELECT id as CatId, catname as CatName, 'Vendors' as sectioName from vendor_category";
		}
		if($ParentId=='Sponsors')
		{
			$catsql = "SELECT id as CatId, catname as CatName, 'Sponsors' as sectioName from sponsor_category";
		}
		if($ParentId=='Tickets')
		{
			$catsql = "SELECT id as CatId, cat_name as CatName, 'Tickets' as sectioName from ticket_event_category";
		}
		if($ParentId=='Memberships')
		{
			$catsql = "SELECT id as CatId, cat_name as CatName, 'Memberships' as sectioName from plan_category";
		}
		if($ParentId=='Backdrops')
		{
			$catsql = "SELECT id as CatId, backdrop_cat_name as CatName, 'Backdrops' as sectioName from backdrop_categories";
		}
		if($ParentId=='Xopidia')
		{
			$catsql = "SELECT id as CatId, catname as CatName, 'Xopidia' as sectioName from xopidia_category";
		}
		if($ParentId=='Event Photos')
		{
			$catsql = "SELECT id as CatId, category_name as CatName, 'Event Photos' as sectioName from xoevent_categorys";
		}
		if($ParentId=='Stoxfotos')
		{
			$catsql = "SELECT id as CatId, category_name as CatName, 'Stoxfotos' as sectioName from stoxfoto_categories";
		}
		if($ParentId=='Auctxons')
		{
			$catsql = "SELECT id as CatId, category_name as CatName, 'Auctxons' as sectioName from auctxon_categories";
		}
		//echo $catsql ;
		if($id)
		{
			$catsql .= " where id=".$id ;
		}
		return $catsql ;
	}
	
	function addsubcategory()
	{
		$this->checkSession();
		$this->pageTitle = 'Category Management';
		$this->categorylist();
		
		
		$this->layout = 'default_after_login';
		$ParentId  = $_REQUEST['parent_id'];
		if (!empty($this->data))
		{
			$catName = $this->data['ClassifiedCatMaster']['cat_name'] ;
			$ParentId = $this->data['ClassifiedCatMaster']['parent_id'] ;
			$catsql= $this->editSave('New',$ParentId,$catName);
			$catsql_res = mysql_query($catsql);		
			$this->redirect('/classifiedCatMasters/addsubcategory?menu=41&parent_id='.$ParentId);
		}

		################################### section based catgory listing #############
		$catsql = $this->categorySql($ParentId);
		$category = array();
		$catsql_res = mysql_query($catsql);	
		while($catsql_arr = mysql_fetch_array($catsql_res))
		{
			$category[] = array('CatId'=>$catsql_arr['CatId'],'CatName'=>$catsql_arr['CatName'],'sectioName'=>$catsql_arr['sectioName']);
		}
	
	
		$this->set('allcategories',$category);
	}

	function editsub($ParentId=null,$catid=null)
	{
		$this->checkSession();
		$this->pageTitle = 'Edit Classified Sub Category';
		$this->layout = 'default_after_login';
		
		if (empty($this->data))
		{
			$catsql = $this->categorySql($ParentId,$catid);
			$category = array();
			$catsql_res = mysql_query($catsql);	
			while($catsql_arr = mysql_fetch_array($catsql_res))
			{
				$category[] = array('CatId'=>$catsql_arr['CatId'],'CatName'=>$catsql_arr['CatName'],'sectioName'=>$catsql_arr['sectioName']);
			}
			$this->set('allcategories',$category);

			
			
		}
		else
		{
			$catName = $this->data['ClassifiedCatMaster']['cat_name'] ;
			$catsql= $this->editSave('Edit',$ParentId,$catName,$catid);
			$catsql_res = mysql_query($catsql);		
			$this->redirect('/classifiedCatMasters/addsubcategory?menu=41&parent_id='.$ParentId);
		}
	}
	
	function deletesub($ParentId=null,$catid=null)
	{
		if($ParentId=='Project')
		{
			$catsql = " DELETE  from project_cat ";
		}
		if($ParentId=='Vendors')
		{
			$catsql = "DELETE from vendor_category";
		}
		if($ParentId=='Sponsors')
		{
			$catsql = "DELETE from sponsor_category";
		}
		if($ParentId=='Tickets')
		{
			$catsql = "DELETE from ticket_event_category";
		}
		if($ParentId=='Memberships')
		{
			$catsql = "DELETE from plan_category";
		}
		if($ParentId=='Backdrops')
		{
			$catsql = "DELETE from backdrop_categories";
		}
		if($ParentId=='Xopidia')
		{
			$catsql = "DELETE from xopidia_category";
		}
		if($ParentId=='Event Photos')
		{
			$catsql = "DELETE from xoevent_categorys";
		}
		if($catid)
		{
			$catsql .= " where id=".$catid ;
			mysql_query($catsql);
		}
		$this->redirect('/classifiedCatMasters/addsubcategory?menu=41&parent_id='.$ParentId);
		
	}
	
}
?>