Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/3dotsarchitect.com/public_html/admin

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: project.php

<?php 
session_start();
ob_start();
include("config/db.php");	
include_once 'functions/processes.php';
include 'functions/pagination.class.php';

$Login_Process = new Login_Process;
$Login_Process->check_status($_SERVER['SCRIPT_NAME']);

if($_SESSION['user_level'] >= 5)
{
	$smarty->assign('admin','Admin');
	
	$where='order by sort_order';
}
else
{
	$where='WHERE admin_menu.status=1 order by sort_order';

}

// table
$TABLE_PROJECTS=$smarty->getTemplateVars('TABLE_PROJECTS');
$TABLE_PROJECT_TYPE=$smarty->getTemplateVars('TABLE_PROJECT_TYPE');
$TABLE_PROJECT_FLOORING=$smarty->getTemplateVars('TABLE_PROJECT_FLOORING');
$TABLE_PROJECTSCOST=$smarty->getTemplateVars('TABLE_PROJECTSCOST');
$TABLE_PROJECT_GALLERY=$smarty->getTemplateVars('TABLE_PROJECT_GALLERY');
$TABLE_ADMIN_MENU=$smarty->getTemplateVars('TABLE_ADMIN_MENU');
$TABLE_STATUS=$smarty->getTemplateVars('TABLE_STATUS');

// menu 
 $sql_menu = "SELECT admin_menu_id, menu_name, menu_link, sort_order, status_name FROM ".$TABLE_ADMIN_MENU." LEFT JOIN ".$TABLE_STATUS." ON  ".$TABLE_ADMIN_MENU.".status=".$TABLE_STATUS.".status  ".$where."  ";
 
$result_menu = mysqli_query($_SESSION['con'],$sql_menu) or die('Query failed1.'); 
//print_r($_SESSION['con']);
while($row_menu = mysqli_fetch_array($result_menu))
{
	$menu[] = $row_menu; 
}
// menu

// sortby dropdown 
$sql_filter = "SELECT * FROM ".$TABLE_PROJECT_TYPE." where status_id='1' ";
$result_filter = mysqli_query($_SESSION['con'],$sql_filter) or die('Query failed2.'); 
while($row_filter = mysqli_fetch_array($result_filter))
{
	$datafilter[] = $row_filter; 
}
$smarty->assign('datafilter',$datafilter);
// end dropdown

// select box condition only
$eid2=$_GET['eid'];
$smarty->assign('eid2',$eid2);

// add entry
if($_GET['action']=='add')
{
	if($_GET['event']=="save")	
	{
   
		// echo "<pre>";
		// print_r($_POST);
		// print_r($_FILES);
		//~ print_r(implode('|||',$_POST['structure']));
		//~ print_r($_FILES['file']['tmp_name']);
		//~ print_r($_FILES['floor_plan_files']['tmp_name']);
		//~ echo "</pre>";
		
		//$smarty->display("tour/tour.tpl");				
		$specifications = '';
		$overview = '';
		$imageName_map = '';
		$thumbName_map = '';
		
		// if(isset($_POST['special_feature']) && !empty($_POST['special_feature'])){
		// 	$special_feature = implode('|||',$_POST['special_feature']); 
		// }
		// if(isset($_POST['structure']) && !empty($_POST['structure'])){
		// 	$structure = implode('|||',$_POST['structure']); 
		// }
		// if(isset($_POST['flooring']) && !empty($_POST['flooring'])){
		// 	$flooring = implode('|||',$_POST['flooring']); 
		// }
		// if(isset($_POST['doors_and_windows']) && !empty($_POST['doors_and_windows'])){
		// 	$doors_and_windows = implode('|||',$_POST['doors_and_windows']); 
		// }
		// if(isset($_POST['plumbing_and_sanitary']) && !empty($_POST['plumbing_and_sanitary'])){
		// 	$plumbing_and_sanitary = implode('|||',$_POST['plumbing_and_sanitary']); 
		// }
		// if(isset($_POST['electrical']) && !empty($_POST['electrical'])){
		// 	$electrical = implode('|||',$_POST['electrical']); 
		// }
		// if(isset($_POST['painting']) && !empty($_POST['painting'])){
		// 	$painting = implode('|||',$_POST['painting']); 
		// }
		//~ echo $structure_final;
		//~ EXIT;
		
		$errors=0;
		if(isset($_FILES['file']['tmp_name']) && !empty($_FILES['file']['tmp_name']))
		{	
			
			$image=$_FILES['file']['tmp_name'];
			$filename = time().'_'.str_replace(' ','',$_FILES['file']['name']);
			$mainPath = "project/";
			$newname=$mainPath.''.$filename;
			copy($_FILES['file']['tmp_name'], $newname);
			// $thumbPath = "project/thumb/";
			// $thumb_name=$thumbPath.''.$filename;
			//~ $thumb=$Login_Process->make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
			
			// if(isset($_FILES['map_file']['tmp_name']) && !empty($_FILES['map_file']['tmp_name'])){
			// 	$image = $_FILES['map_file']['tmp_name'];
			// 	$filename = time().'_'.str_replace(' ','',$_FILES['map_file']['name']);
			// 	$mainPath = "project/";
				
			// 	$imageName_map = $mainPath.$filename;
	
			// 	copy($_FILES['map_file']['tmp_name'], $imageName_map);
			// 	// $thumbPath = "project/thumb/";
			// 	// $thumbName_map = $thumbPath.$filename;
			// 	// $thumb = $Login_Process->make_thumb($imageName_map,$thumbName_map,WIDTH,HEIGHT);
			// }

if(isset($_FILES['detail_view_file']['tmp_name']) && !empty($_FILES['detail_view_file']['tmp_name'])){
				$image = $_FILES['detail_view_file']['tmp_name'];
				$detail_view_filename = time().'_'.str_replace(' ','',$_FILES['detail_view_file']['name']);
				$mainPath = "project/";
				
				$detailview_file_name = $mainPath.$detail_view_filename;
				copy($_FILES['detail_view_file']['tmp_name'], $detailview_file_name);
				//~ $thumbPath = "project/thumb/";
				//~ $thumbName_over = $thumbPath.$filename;
				//~ $thumb = $Login_Process->make_thumb($imageName_over,$thumbName_over,WIDTH,HEIGHT);
			}

// if(isset($_FILES['overview_file']['tmp_name']) && !empty($_FILES['overview_file']['tmp_name'])){
			// 	$image = $_FILES['overview_file']['tmp_name'];
			// 	$filename = time().'_'.str_replace(' ','',$_FILES['overview_file']['name']);
			// 	$mainPath = "project/";
				
			// 	$imageName_over = $mainPath.$filename;
			// 	copy($_FILES['overview_file']['tmp_name'], $imageName_over);
			// 	//~ $thumbPath = "project/thumb/";
			// 	//~ $thumbName_over = $thumbPath.$filename;
			// 	//~ $thumb = $Login_Process->make_thumb($imageName_over,$thumbName_over,WIDTH,HEIGHT);
			// }
			
			// $sql = "INSERT INTO ".$TABLE_PROJECTS." 
			// (
			// project_name,project_type,overview_details,address,status_id,sort_order,thumbpath,imgpath,img_location_map,thumb_location_map,img_location_over,thumb_location_over,display_status)VALUES('".$_POST['project_name']."','".$_POST['project_type_id']."',
			//  '".$_POST['overview_details']."','".$_POST['address']."','".$_POST['status_id']."','".$_POST['sort_order']."','".$thumb_name."','".$newname."','".$imageName_map."','".$thumbName_map."','".$imageName_over."','".$thumbName_over."','".$_POST['display_status']."')";
					
			//$video_link = $_POST['video_link'];

$video_allowedExts = array("mp4");
			$video_extension = pathinfo($_FILES['video_link']['name'], PATHINFO_EXTENSION);
			//if (($_FILES["video_link"]["type"] == "video/mp4") && ($_FILES["video_link"]["size"] < 500000) && in_array($extension, $allowedExts))  {
			if (($_FILES["video_link"]["type"] == "video/mp4") && in_array($video_extension, $video_allowedExts))  {

$detail_view_videoname = time().'_'.str_replace(' ','',$_FILES['video_link']['name']);
				$mainPath = "upload_video/";
			    move_uploaded_file($_FILES["video_link"]["tmp_name"],$mainPath.''.$detail_view_videoname);
			    $video_link = $mainPath.''.$detail_view_videoname;

}else{
			  	//echo "Not Valid";
			}

$sql = "INSERT INTO ".$TABLE_PROJECTS."  ( project_name, project_type, overview_details, video_link, thumbpath, imgpath,detailview_imgpath, location, site_area, bulit_area,  display_status, status_id, sort_order) VALUES ('".$_POST['project_name']."', '".$_POST['project_type']."', '".addslashes($_POST['overview_details'])."', '".$video_link."' ,'".$thumb_name."', '".$newname."', '".$detailview_file_name."', '".$_POST['location']."', '".$_POST['site_area']."', '".$_POST['bulit_area']."', '1', '".$_POST['status_id']."', '".$_POST['sort_order']."')";

$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed3.');
			$last_id = mysqli_insert_id();
			header("Location: project.php");
			// if(isset($_FILES['floor_plan_files']['tmp_name']) && !empty($_FILES['floor_plan_files']['tmp_name'])){
			// 	$num_files = count($_FILES['floor_plan_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		$image = $_FILES['floor_plan_files']['tmp_name'][$i];
			// 		$filename = time().'_'.str_replace(' ','',$_FILES['floor_plan_files']['name'][$i]);
			// 		$mainPath = "project_flooring/";
					
			// 		$imageName = $mainPath.$filename;
			// 		copy($_FILES['floor_plan_files']['tmp_name'][$i], $imageName);
			// 		$thumbPath = "project_flooring/thumb/";
			// 		$thumbName = $thumbPath.$filename;
			// 		$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
					
			// 		$sql1 = "INSERT ".$TABLE_PROJECT_FLOORING." 
			// 				SET 
			// 					project_id = '".$last_id."',
			// 					imgpath = '".$imageName."',
			// 					thumbpath = '".$thumbName."'";
			// 		mysqli_query($_SESSION['con'],$sql1) or die('Query failed2.');
			// 	}
			// }
			
			// if(isset($_FILES['spec_files']['tmp_name']) && !empty($_FILES['spec_files']['tmp_name'])){
			// 	$num_files = count($_FILES['spec_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		$image = $_FILES['spec_files']['tmp_name'][$i];
			// 		$filename = time().'_'.str_replace(' ','',$_FILES['spec_files']['name'][$i]);
			// 		$mainPath = "project_specification/";
					
			// 		$imageName = $mainPath.$filename;
			// 		copy($_FILES['spec_files']['tmp_name'][$i], $imageName);
			// 		$thumbPath = "project_specification/thumb/";
			// 		$thumbName = $thumbPath.$filename;
			// 		$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
					
			// 		$sql2 = "INSERT project_specification 
			// 				SET 
			// 					project_id = '".$last_id."',
			// 					imgpath = '".$imageName."',
			// 					thumbpath = '".$thumbName."'";
			// 		mysqli_query($_SESSION['con'],$sql2) or die('Query failed2.');
			// 	}
			// }
			
			// if(isset($_FILES['brochure_files']['tmp_name']) && !empty($_FILES['brochure_files']['tmp_name'])){
			// 	$num_files = count($_FILES['brochure_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		$image = $_FILES['brochure_files']['tmp_name'][$i];
			// 		$filename = time().'_'.str_replace(' ','',$_FILES['brochure_files']['name'][$i]);
			// 		$mainPath = "project_e-brochure/";
					
			// 		$imageName = $mainPath.$filename;
					
			// 		copy($_FILES['brochure_files']['tmp_name'][$i], $imageName);
			// 		/*
			// 		$thumbPath = "project_e-brochure/thumb/";
			// 		$thumbName = $thumbPath.$filename;
			// 		$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
			// 		*/
					
			// 		$sql3 = "INSERT project_ebrochure 
			// 				SET 
			// 					project_id = '".$last_id."',
			// 					imgpath = '".$imageName."'";
			// 		mysqli_query($_SESSION['con'],$sql3) or die('Query failed2.');
			// 	}
				
			// }
				
		} else{			
 			// $sql = "insert into ".$TABLE_PROJECTS." (project_name,project_type,overview_details,address,status_id,sort_order,display_status) values('".$_POST['project_name']."','".$_POST['project_type_id']."','".$_POST['overview_details']."','".$_POST['address']."','".$_POST['status_id']."','".$_POST['sort_order']."','".$_POST['display_status']."')";
 			$sql = "INSERT INTO ".$TABLE_PROJECTS."  ( project_name, project_type, overview_details, video_link, thumbpath, imgpath, detailview_imgpath , location, site_area, bulit_area,  display_status, status_id, sort_order) VALUES ('".$_POST['project_name']."', '".$_POST['project_type_id']."', '".addslashes($_POST['overview_details'])."', '".$_POST['video_link']."' ,'".$thumb_name."', '".$newname."', '".$detailview_imgpath."', '".$_POST['location']."', '".$_POST['site_area']."', '".$_POST['bulit_area']."', '1', '".$_POST['status_id']."', '".$_POST['sort_order']."')";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed66.');
			$last_id = mysqli_insert_id();
		}
		header("Location: project.php");		
	}
	
	else if($_GET['event']=="notsave")	
	{
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysqli_query($_SESSION['con'],$qry_status) or die('Query failed4.'); 
		while($row_status = mysqli_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);
		
		$sql = "SELECT * FROM ".$TABLE_PROJECT_TYPE." ";
		$res_project_type = mysqli_query($_SESSION['con'],$sql) or die('Query failed5.'); 
		while($row_project_type = mysqli_fetch_array($res_project_type))
		{
			$project_type[] = $row_project_type; 
		}
		
		$smarty->assign('project_type',$project_type);
			
		$smarty->assign('menu',$menu);
		$smarty->display("project/project_form.tpl");
		
	}
	
}

// update entry
else if($_GET['action']=='edit')
{	
	if($_GET['event']=="save")	
	{	
		//~ echo "<pre>";
		//~ print_r($_POST);
		//~ print_r($_FILES['floor_plan_files']['tmp_name']);
		//~ print_r($_FILES['map_file']['tmp_name']);
		//~ print_r($_FILES['files']['tmp_name']);
		//~ echo "</pre>";
		//EXIT;
				
				
		$special_feature = '';
		$imageName_map = '';
		$thumbName_map = '';
		$imageName_over = '';
		$thumbName_over = '';
		
		
				
		if(isset($_FILES['file']['tmp_name']) && !empty($_FILES['file']['tmp_name'])){
			$image=$_FILES['file']['tmp_name'];
			$filename = time().'_'.str_replace(' ','',$_FILES['file']['name']);
			$mainPath = "project/";
			
			$newname=$mainPath.''.$filename;
			copy($_FILES['file']['tmp_name'], $newname);
			$thumbPath = "project/thumb/";
			$thumb_name=$thumbPath.''.$filename;
			$thumb=$Login_Process->make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
		}else{
			$thumb_name = $_POST['project_thumb'];
			$newname = $_POST['project_img'];
		}

// if(isset($_FILES['map_file']['tmp_name']) && !empty($_FILES['map_file']['tmp_name'])){
			
			// 	$image = $_FILES['map_file']['tmp_name'];
			// 	$filename = time().'_'.str_replace(' ','',$_FILES['map_file']['name']);
			// 	$mainPath = "project/";
				
			// 	$imageName_map = $mainPath.$filename;
			// 	copy($_FILES['map_file']['tmp_name'], $imageName_map);
			// 	$thumbPath = "project/thumb/";
			// 	$thumbName_map = $thumbPath.$filename;
			// 	$thumb = $Login_Process->make_thumb($imageName_map,$thumbName_map,WIDTH,HEIGHT);
				
			// }else{
				
			// 	$thumbName_map = $_POST['map_thumb'];
			// 	$imageName_map = $_POST['map_img'];
			// }
			
			// if(isset($_FILES['overview_file']['tmp_name']) && !empty($_FILES['overview_file']['tmp_name'])){
			
			// 	$image = $_FILES['overview_file']['tmp_name'];
			// 	$filename = time().'_'.str_replace(' ','',$_FILES['overview_file']['name']);
			// 	$mainPath = "project/";
				
			// 	$imageName_over = $mainPath.$filename;
			// 	copy($_FILES['overview_file']['tmp_name'], $imageName_over);
			// 	$thumbPath = "project/thumb/";
			// 	$thumbName_over = $thumbPath.$filename;
			// 	$thumb = $Login_Process->make_thumb($imageName_over,$thumbName_over,WIDTH,HEIGHT);
				
			// }else{
				
			// 	$thumbName_over = $_POST['over_thumb'];
			// 	$imageName_over = $_POST['over_img'];
			// }

//$video_link = $_POST['video_link'];
			if(isset($_FILES['video_link']['tmp_name']) && !empty($_FILES['video_link']['tmp_name'])){				
				$video_allowedExts = array("mp4");
				$video_extension = pathinfo($_FILES['video_link']['name'], PATHINFO_EXTENSION);
				//if (($_FILES["video_link"]["type"] == "video/mp4") && ($_FILES["video_link"]["size"] < 500000) && in_array($extension, $allowedExts))  {
				if (($_FILES["video_link"]["type"] == "video/mp4") && in_array($video_extension, $video_allowedExts))  {

$detail_view_videoname = time().'_'.str_replace(' ','',$_FILES['video_link']['name']);
					$mainPath = "upload_video/";
				    move_uploaded_file($_FILES["video_link"]["tmp_name"],$mainPath.''.$detail_view_videoname);
				    $video_link = $mainPath.''.$detail_view_videoname;

}else{
				  	//echo "Not Valid";
				}
			}else{
				$video_link = $_POST['hdn_video_link'];
			}

$sql = "UPDATE ".$TABLE_PROJECTS." 
					SET 
						project_name = '".$_POST['project_name']."',
						project_type = '".$_POST['project_type_id']."',
						video_link = '".$video_link."', 
						overview_details = '".addslashes($_POST['overview_details'])."', 
						status_id = '".$_POST['status_id']."',
						sort_order = '".$_POST['sort_order']."',
						thumbpath = '".$thumb_name."',
						imgpath = '".$newname."',
						detailview_imgpath = '".$detailview_file_name."',
						location = '".$_POST['location']."',
						site_area = '".$_POST['site_area']."',
						bulit_area = '".$_POST['bulit_area']."',
						display_status = '1'
					WHERE project_id = '".$_GET['id']."'";
						
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed6.');
			$last_id = mysqli_insert_id();
			
			// if(isset($_FILES['floor_plan_files']['tmp_name']) && !empty($_FILES['floor_plan_files']['tmp_name'])){
			// 	$con_qry = "delete from ".$TABLE_PROJECT_FLOORING." where project_id='".$_GET['id']."' ";	
			// 	$con_res = mysqli_query($_SESSION['con'],$con_qry); 
			// 	$num_files = count($_FILES['floor_plan_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		if(isset($_FILES['floor_plan_files']['tmp_name'][$i]) && !empty($_FILES['floor_plan_files']['tmp_name'][$i])){
			// 			$image = $_FILES['floor_plan_files']['tmp_name'][$i];
			// 			$filename = time().'_'.str_replace(' ','',$_FILES['floor_plan_files']['name'][$i]);
			// 			$mainPath = "project_flooring/";
						
			// 			$imageName = $mainPath.$filename;
			// 			copy($_FILES['floor_plan_files']['tmp_name'][$i], $imageName);
			// 			$thumbPath = "project_flooring/thumb/";
			// 			$thumbName = $thumbPath.$filename;
			// 			$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
			// 		}else{
			// 			$imageName = $_POST['floor_img'][$i];
			// 			$thumbName = $_POST['floor_thumb'][$i];
			// 		}
			// 		$sql1 = "INSERT ".$TABLE_PROJECT_FLOORING." 
			// 				SET 
			// 					project_id = '".$_GET['id']."',
			// 					imgpath = '".$imageName."',
			// 					thumbpath = '".$thumbName."'";
			// 		mysqli_query($_SESSION['con'],$sql1) or die('Query failed2.');
			// 	}
			// }	
			
			// if(isset($_FILES['brochure_files']['tmp_name']) && !empty($_FILES['brochure_files']['tmp_name'])){
			// 	$con_qry = "delete from project_ebrochure where project_id='".$_GET['id']."' ";	
			// 	$con_res = mysqli_query($_SESSION['con'],$con_qry); 
			// 	$num_files = count($_FILES['brochure_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		if(isset($_FILES['brochure_files']['tmp_name'][$i]) && !empty($_FILES['brochure_files']['tmp_name'][$i])){
			// 			$image = $_FILES['brochure_files']['tmp_name'][$i];
			// 			$filename = time().'_'.str_replace(' ','',$_FILES['brochure_files']['name'][$i]);
			// 			$mainPath = "project_e-brochure/";
						
			// 			$imageName = $mainPath.$filename;
			// 			copy($_FILES['brochure_files']['tmp_name'][$i], $imageName);
			// 		/*
			// 			$thumbPath = "project_flooring/thumb/";
			// 			$thumbName = $thumbPath.$filename;
			// 			$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
			// 		*/
			// 		}else{
			// 			$imageName = $_POST['brochure_img'][$i];
			// 		}
			// 		$sql3 = "INSERT project_ebrochure 
			// 				SET 
			// 					project_id = '".$_GET['id']."',
			// 					imgpath = '".$imageName."'";
			// 		mysqli_query($_SESSION['con'],$sql3) or die('Query failed2.');
			// 	}
			// }
			
			// if(isset($_FILES['spec_files']['tmp_name']) && !empty($_FILES['spec_files']['tmp_name'])){
			// 	$con_qry = "delete from project_specification where project_id='".$_GET['id']."' ";	
			// 	$con_res = mysqli_query($_SESSION['con'],$con_qry); 
			// 	$num_files = count($_FILES['spec_files']['tmp_name']);
			// 	for($i=0; $i < $num_files; $i++) {
			// 		if(isset($_FILES['spec_files']['tmp_name'][$i]) && !empty($_FILES['spec_files']['tmp_name'][$i])){
			// 			$image = $_FILES['spec_files']['tmp_name'][$i];
			// 			$filename = time().'_'.str_replace(' ','',$_FILES['spec_files']['name'][$i]);
			// 			$mainPath = "project_specification/";
						
			// 			$imageName = $mainPath.$filename;
			// 			copy($_FILES['spec_files']['tmp_name'][$i], $imageName);
			// 			$thumbPath = "project_specification/thumb/";
			// 			$thumbName = $thumbPath.$filename;
			// 			$thumb = $Login_Process->make_thumb($imageName,$thumbName,WIDTH,HEIGHT);
			// 		}else{
			// 			$imageName = $_POST['spec_img'][$i];
			// 			$thumbName = $_POST['spec_thumb'][$i];
			// 		}
			// 		$sql2 = "INSERT project_specification 
			// 				SET 
			// 					project_id = '".$_GET['id']."',
			// 					imgpath = '".$imageName."',
			// 					thumbpath = '".$thumbName."'";
			// 		mysqli_query($_SESSION['con'],$sql2) or die('Query failed2.');
			// 	}
			// }
		
		header("Location: project.php");
	}
	else if($_GET['event']=="notsave")	
	{
		$sql = "SELECT * FROM ".$TABLE_PROJECTS." where project_id='".$_GET['id']."'";
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed2.'); 
		while($row = mysqli_fetch_array($result))
		{
			$data[] = $row;
		}
		
		$smarty->assign('data',$data);		
		$smarty->assign('special_feature',$special_feature);
		$smarty->assign('structure',$structure);
		$smarty->assign('flooring',$flooring);
		$smarty->assign('doors_and_windows',$doors_and_windows);
		$smarty->assign('plumbing_and_sanitary',$plumbing_and_sanitary);
		$smarty->assign('electrical',$electrical);
		$smarty->assign('painting',$painting);
		
		//Project flooring images
// 		$sql = "SELECT * FROM ".$TABLE_PROJECT_FLOORING." where project_id='".$_GET['id']."'";
// 		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed12.'); 
// 		while($row = mysqli_fetch_array($result))
// 		{
// 			$project_flooring[] = $row; 
// 		}
// 		$smarty->assign('project_flooring',$project_flooring);
		
		//Project specification images
// 		$sql = "SELECT * FROM project_specification where project_id='".$_GET['id']."'";
// 		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed13.'); 
// 		while($row = mysqli_fetch_array($result))
// 		{
// 			$project_specification[] = $row; 
// 		}
// 		$smarty->assign('project_specification',$project_specification);
		
		//Project flooring images
// 		$sql = "SELECT * FROM project_ebrochure where project_id='".$_GET['id']."'";
// 		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed14.'); 
// 		while($row = mysqli_fetch_array($result))
// 		{
// 			$project_ebrochure[] = $row; 
// 		}
// 		$smarty->assign('project_ebrochure',$project_ebrochure);
// 				//echo "<pre>";
// 		//print_r($project_flooring);
// 		//print_r($structure);
// 		// get status array 
		
		$qry_project_type = "SELECT * FROM ".$TABLE_PROJECT_TYPE." ";
		$res_project_type = mysqli_query($_SESSION['con'],$qry_project_type) or die('Query failed3.'); 
		while($row_project_type = mysqli_fetch_array($res_project_type))
		{
			$project_type[] = $row_project_type; 
		}
		$smarty->assign('project_type',$project_type);
		
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysqli_query($_SESSION['con'],$qry_status) or die('Query failed4.'); 
		while($row_status = mysqli_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);
		
		$smarty->assign('menu',$menu);			
		$smarty->display("project/project_edit_form.tpl");	
	}
}
// delete record
else if($_GET['action']=='delete')
{	
	$sql = "delete from ".$TABLE_PROJECTS." where project_id='".$_GET['id']."' ";
	$result = mysqli_query($_SESSION['con'],$sql) or die('Query faileds.'); 		
	
	
	// delete travel cost 
	//~ $con_qry = "delete from ".$TABLE_PROJECTSCOST." where project_id='".$_GET['id']."' ";	
	//~ $con_res = mysqli_query($_SESSION['con'],$con_qry) or die('Query failed7.'); 
	
	
	// delete travel cost 
	$con_qry = "delete from ".$TABLE_PROJECT_GALLERY." where project_id='".$_GET['id']."' ";	
	$con_res = mysqli_query($_SESSION['con'],$con_qry) or die('Query failed8.');  
	
	//~ while($con_row = mysqli_fetch_array($con_res))
	//~ {
		
		//~ $del_con = "delete from consultant where consultant_id='".$con_row['consultant_id']."' ";
		//~ mysqli_query($_SESSION['con'],$del_con) or die('Query failed9.'); 		
		
	//~ }
	
	//end
	
	header("Location: project.php");		
}

else if($_GET['action']=='viewrecords')
{	
   if(isset($_POST['delete']))
   {
		$count= count($_POST['checkbox']);
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "delete from ".$TABLE_PROJECTS." where project_id='".$del_id."' ";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed10.');
			
			// delete travel cost 
			$con_qry = "delete from ".$TABLE_PROJECTSCOST." where project_id='".$_GET['id']."' ";	
			//$con_res = mysqli_query($_SESSION['con'],$con_qry) or die('Query failed11.');

// delete travel cost 
			$con_qry = "delete from ".$TABLE_PROJECTSPLACE." where project_id='".$_GET['id']."' ";	
			//$con_res = mysqli_query($_SESSION['con'],$con_qry) or die('Query failed12.');

}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project.php");		
		}
	}
	
	// disable start
	if(isset($_POST['disable']))
   {
		$count= count($_POST['checkbox']);
		
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "update ".$TABLE_PROJECTS." set status_id=0  where project_id='".$del_id."' ";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed13.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project.php");		
		}
	}
	// disable end
	
	
	// enable start
	if(isset($_POST['enable']))
   {
		$count= count($_POST['checkbox']);
		
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "update ".$TABLE_PROJECTS." set status_id=1  where project_id='".$del_id."' ";
			
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed14.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project.php");		
		}
	}
	// enable end

// order by id
	if($_GET['orderby']=='id')
	{
		$orderby='order by project_id asc ';
	}
	// order by title
	else if($_GET['orderby']=='project_name')
	{
		$orderby='order by project_name asc ';
	}
	else if($_GET['orderby']=='project_type')
	{
		$orderby='order by project_type asc ';
	}
	// order by sort order
	else if($_GET['orderby']=='sort_order')
	{
		$orderby='order by sort_order asc ';
	}
	// order by status
	else if($_GET['orderby']=='status')
	{
		$orderby='order by project.status_id asc ';
	}
	// default
	else 
	{
		$orderby='order by sort_order asc ';
	}	
		$sql = "SELECT ".$TABLE_PROJECTS.".*, status_name, t.project_type FROM ".$TABLE_PROJECTS." LEFT JOIN ".$TABLE_STATUS." ON
 ".$TABLE_PROJECTS.".status_id=".$TABLE_STATUS.".status LEFT JOIN ".$TABLE_PROJECT_TYPE." AS t ON t.project_type_id = ".$TABLE_PROJECTS.".project_type ".$orderby." ";
	 
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed15.'); 
		while($row = mysqli_fetch_array($result))
		{
			$data[] = $row; 		
			
		}
		
		$smarty->assign('data',$data);
		
		$qry_package = "SELECT * FROM ".$TABLE_PROJECT_TYPE." ";
		$res_package = mysqli_query($_SESSION['con'],$qry_package) or die('Query failed16.'); 
		while($row_package = mysqli_fetch_array($res_package))
		{
			$package[] = $row_package; 
		}
		
		$smarty->assign('project_type',$package);
	
		$smarty->assign('menu',$menu);	
		$smarty->display("project/project.tpl");	
	//orderby end
}

// default display
else
{
	$sql = "SELECT p.*,p.project_name,p.imgpath,t.project_type,s.status_name FROM ".$TABLE_PROJECTS." AS p 
		LEFT JOIN ".$TABLE_STATUS." AS s ON p.status_id = s.status
		LEFT JOIN ".$TABLE_PROJECT_TYPE." AS t ON t.project_type_id = p.project_type 
	ORDER BY p.sort_order ";	
	$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed1.'); 
	
	while($row = mysqli_fetch_array($result))
	{
		$data[] = $row; 
	}
	//$smarty->assign('data',$data);
	
	$qry_project = "SELECT * FROM ".$TABLE_PROJECT_TYPE." ";
	$res_project = mysqli_query($_SESSION['con'],$qry_project) or die('Query failed17.'); 
	while($row_project = mysqli_fetch_array($res_project))
	{
		$project[] = $row_project; 
	}
	
	$smarty->assign('project_type',$project);
		
    if (count($data))
	{
    	$pagination = new pagination($data, (isset($_GET['page']) ? $_GET['page'] : 1), 10);
    	$pagination->setShowFirstAndLast(false);
        $pagination->setMainSeperator('  ');
          // Parse through the pagination class
          $productPages = $pagination->getResults();
          // If we have items 
          if (count($productPages) != 0) 
		  {
          	$pageNumbers = '<div class="numbers">'.$pagination->getLinks($_GET).'</div>';
           	$smarty->assign('data',$productPages);	
		    $smarty->assign('pageNumbers',$pageNumbers);	
		  }
    }
	
	
	$smarty->assign('menu',$menu);
	$smarty->display("project/project.tpl");	
}		
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: project.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation