Admin Control Panel v2.0

✎ Editing: TeamController.php ← Back

<?php
class TeamController extends BaseController {
	
	public function __construct(){
		$this->is_admin_login();
		parent::__construct();
	}
	
	public function index(){
		$this->data['teamList']= DB::table('team')
								->where('home_page_section','=',1)
								->orderBy('team_priority','asc')
								->get();	
		// dd($this->data['teamList']);			
		return View::make('admin.team.list',$this->data);		 
	}
	
	public function create(){		
				
		$this->data['messages']='';
		if(Input::get('createbtnsubmit')){			 
				// $this->data = Input::get();
				// echo "DD";exit();
				$file = Input::file('team_image_name');
				$insertDatas = array();
				
					$insertDatas = array(
									'team_member_name' =>Input::get('team_member_name'),
									'team_member_designation' =>Input::get('team_member_designation'),
									'team_image_alt_tag' =>Input::get('team_image_alt_tag'),
									'team_member_short_description' =>Input::get('team_member_short_description'),
									'team_email'=>Input::get('team_member_email'),
									'team_phone_no'=>Input::get('team_member_phone'),
									
									'team_member_description' =>Input::get('team_member_description'),
									'team_status' =>Input::get('team_status'),
									'team_priority' =>Input::get('team_priority'),																		
									'team_page_id' =>Input::get('team_page_id'),
								);
				if($file){
					$filename = $this->resize_and_crop_image('team_image_name','assets/uploads/team',array(array('width'=>350,'height'=>250,'folder'=>'recomended'),array('width'=>100,'height'=>110,'folder'=>'small')),null);
					$insertDatas['team_image_name'] = $filename;				
				} // end file checking loop
				DB::table('team')->insert($insertDatas);
				$this->data['messages'] =$this->custom_message('Person Added Successfully','success');		
			}
		 // $this->data['teamMenuList'] = DB::table('menus')->where('menu_status','=',1)->get();						$this->get_menus();
		 return View::make('admin.team.add',$this->data);			 
	}

public function edit($editID){	 
		if(empty($editID)) { return Redirect::to('admin/our-people');}		
		$this->data['messages']	='';
		if(Input::get('updatebtnsubmit')){			 
				$this->datasupdate = array(
									'team_member_name' =>Input::get('team_member_name'),
									'team_member_short_description' =>Input::get('team_member_short_description'),
									'team_member_designation' =>Input::get('team_member_designation'),
									'team_image_alt_tag' =>Input::get('team_image_alt_tag'),
									'team_member_description' =>Input::get('team_member_description'),
									'team_email'=>Input::get('team_member_email'),
									'team_phone_no'=>Input::get('team_member_phone'),									
									'team_status' =>Input::get('team_status'),
									'team_priority' =>Input::get('team_priority'),
									'team_page_id' =>Input::get('team_page_id'),
									);
									
			 	$file = Input::file('team_image_name');
				if($file){
					$filename = $this->resize_and_crop_image('team_image_name','assets/uploads/team',array(array('width'=>350,'height'=>250,'folder'=>'recomended'),array('width'=>100,'height'=>110,'folder'=>'small')),Input::get('team_image_old_name'));		
					$this->datasupdate['team_image_name'] = $filename;
				}				
				DB::table('team')->where('team_id', '=',$editID)->update($this->datasupdate);
				$this->data['messages'] = $this->custom_message('Section updated successfully','success');		
			}
		// $this->data['teamMenuList'] = DB::table('menus')->where('menu_status','=',1)->get();		
		$this->data['rsTeam'] = DB::table('team')->where('team_id','=',$editID)->first();$this->get_menus();
	 return View::make('admin.team.edit',$this->data);			 
	}

public function changestatus($statusID,$currentStatus){
		$currentStatus = ($currentStatus==0)?1:0;
		 $currentStatusdatas = array("team_status"=>$currentStatus);
		 DB::table('team')->where('team_id', '=',$statusID)->where('home_page_section','=',1)->update($currentStatusdatas);	
		return Redirect::to('admin/our-people')->with('flash_error','deleted');
	}
	
	public function delete($deleteID){	 
		if(empty($deleteID)) { return Redirect::to('admin/our-people');}
		$teamList = DB::table('team')
					->where('team_id','=',$deleteID)
					->where('home_page_section','=',1)
					->get();
		foreach($teamList as $team){
			if(File::exists('assets/uploads/team/'.$team->team_image_name)){
				File::delete('assets/uploads/team/'.$team->team_image_name);
				File::delete('assets/uploads/team/small/'.$team->team_image_name);
				File::delete('assets/uploads/team/recomended/'.$team->team_image_name);
			}
		}
		 DB::table('team')->where('team_id', '=',$deleteID)->delete();	
		 $this->data['messages'] = $this->custom_message('Deleted Successfully','success');
		 return Redirect::to('admin/our-people')->with('flash_error','deleted');
	 }	 
	
	
	//------------------------------------GALLERYY
	
	
	public function image_gallery(){
		
		$this->data['categoryList'] = DB::Table('category_master')
									  ->get();	
		return View::make('admin.gallery.add',$this->data);	
	}
	
	public function video_gallery(){
			
		if(Input::get('createbtnsubmit')){
			
			DB::table('video_gallery')->delete();
			$links = Input::get('shows_link');
			
			foreach($links as $url){
				if(!empty($url)){
					parse_str( parse_url( $url, PHP_URL_QUERY ), $my_array_of_vars );
					if(!empty($my_array_of_vars['v'])){
						$insertDatas = array(
											'vg_video_link' =>$url,
											'vg_youtube_id' =>$my_array_of_vars['v'],
											'vg_status' =>2,
											'vg_date' =>date('Y-m-d'),
											'vg_status' =>1
										);
						DB::table('video_gallery')->insertGetId($insertDatas);
					}else{
						$this->data['message'] = 'Invalid Youtube URL'; 
					}
				}
			}
			
		}

$this->data['videoList'] = DB::table('video_gallery')->get();	
		return View::make('admin.gallery.addVideo',$this->data);
	}
	
	public function delete_video_gallery($deleteID){
		if(empty($deleteID)) { return Redirect::to('admin/video-gallery');}
		 DB::table('video_gallery')->where('vg_id', '=',$deleteID)->delete();	
		 $this->data['messages'] = $this->custom_message('Deleted Successfully','success');
		 return Redirect::to('admin/video-gallery')->with('flash_error','deleted');
	}
	
	
	public function create_category(){
		// echo "DD";exit();
		// echo Input::get('category_en');exit();
		$validator = Validator::make(
						array(
							'category_en' => Input::get('category_en'), 
							// 'category_ar' => Input::get('category_ar'), 
						),
						array(
							'category_en' => 'required',
						));
		if($validator->fails()){	
			return  Response::json(array('status'=>false));
		}
		  $insertDatas = array(
								'category_name'=>Input::get('category_en'),
								'category_slug'=>Str::slug(Input::get('category_en')),
								'category_name_arabic'=>Input::get('category_ar'),
						 );	
		  $newID = DB::table('category_master')->insertGetId($insertDatas);
		  return  Response::json(array('status'=>true,'category_id'=>$newID,'category_name'=>Input::get('category_en')));
	}
	
	public function get_old_files(){
		$categoryID = Input::get('categoryID');
		$oldFiles = array();
		if(!empty($categoryID)){
			// echo json_encode(array('status'=>false,'message'=>'Please select a parent.'));
			// exit(); 	
			$oldFiles	= DB::table('gallery_images AS GI ')
						  -> select(DB::raw('GI.*,CI.category_name'))
						  ->join('category_master AS CI','CI.category_id','=','GI.gallery_cat_id')
						  ->where('gallery_image_type','=',1)
						  ->where('gallery_cat_id','=',$categoryID)
						  ->orderBy(DB::raw('GI.gallery_cat_id'),'DESC')
						  ->get();
		}else{
			$oldFiles	= DB::table('gallery_images AS GI ')
						  -> select(DB::raw('GI.*,CI.category_name'))
						  ->join('category_master AS CI','CI.category_id','=','GI.gallery_cat_id')
						  ->where('gallery_image_type','=',1)
						  // ->where('gallery_cat_id','=',$categoryID)
						  ->orderBy(DB::raw('GI.gallery_cat_id'),'DESC')
						  ->get();
	    }
	   echo json_encode(array('status'=>true, 'gallery'=>$oldFiles));
	   exit();
	}
	
	
	public function file_upload($categoryid){
		// echo $categoryid;exit();
		if(Request::hasFile('file')){
				// $parentID = $id; //Input::get('parentIDE');
				if(empty($categoryid)){
					echo json_encode(array('status'=>false,'message'=>'Please select a category.'));
					exit(); 	
				}
				$fileName = $this->resize_and_crop_image('file','assets/uploads/image_gallery/',array(array('width'=> 235,'height'=>156,'folder'=>'thumb'),array('width'=>322,'height'=>242,'folder'=>'small'),array('width'=> 600,'height'=>450,'folder'=>'large')),null);
				$insertDatas = array(
									'gallery_cat_id' =>$categoryid,
									'gallery_image_name' =>$fileName,
									'gallery_image_type' =>1,
									'gallery_image_date' =>date('Y-m-d H:i:s'),
									'gallery_image_status' =>1
								);
				$id = DB::table('gallery_images')->insertGetId($insertDatas);
				$data = DB::table('gallery_images AS GI ')
						  -> select(DB::raw('GI.*,CI.category_name'))
						  ->join('category_master AS CI','CI.category_id','=','GI.gallery_cat_id')
						  ->where('gallery_image_type','=',1)
						  ->where('gallery_id','=',$id)
						  ->first();
				echo json_encode(array('status'=>true,'fileName'=>$data->gallery_image_name,'id'=>$data->gallery_id,'category_name'=>$data->category_name));
				exit();
		}
	}
	
	public function delete_gallery_image($id){
		 $imageDetail = 	DB::table('gallery_images')
							->where('gallery_id','=',$id)
							->first();
		 if(!empty($imageDetail)){
				if(!empty($imageDetail->gallery_image_name) && File::exists('assets/uploads/image_gallery/'.$imageDetail->gallery_image_name) ){
					
					File::delete('assets/uploads/image_gallery/'.$imageDetail->gallery_image_name);	
					File::delete('assets/uploads/image_gallery/thumb/'.$imageDetail->gallery_image_name);	
					File::delete('assets/uploads/image_gallery/small/'.$imageDetail->gallery_image_name);	
					File::delete('assets/uploads/image_gallery/large/'.$imageDetail->gallery_image_name);	
					DB::table('gallery_images')->where('gallery_id', '=', $id)->delete();			
				}
		 }
	  echo json_encode(array('status'=>true,'Message'=>'File Deleted'));
	}
	
	public function download_image($imageName){
		if(!empty($imageName) && File::exists('assets/uploads/image_gallery/large/'.$imageName) ){
			return Response::download('assets/uploads/image_gallery/large/'.$imageName, $imageName);
		}	
		return Redirect::to('/admin/image-gallery');
		
	}
}

Cancel