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/waste

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: project_booking.php

<?php 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','Web Admin');
	
	$where='order by sort_order';
}
else
{
	$where='WHERE admin_menu.status=1 order by sort_order';
}

// table
$TABLE_PROJECT_BOOKING=$smarty->getTemplateVars('TABLE_PROJECT_BOOKING');
$TABLE_SUB_CATEGORY=$smarty->getTemplateVars('TABLE_SUB_CATEGORY');
$TABLE_CATEGORY=$smarty->getTemplateVars('TABLE_CATEGORY');
$TABLE_booking_SETTINGS=$smarty->getTemplateVars('TABLE_booking_SETTINGS');
$TABLE_ADMIN_MENU=$smarty->getTemplateVars('TABLE_ADMIN_MENU');
$TABLE_STATUS=$smarty->getTemplateVars('TABLE_STATUS');
$TABLE_PROJECTS=$smarty->getTemplateVars('TABLE_PROJECTS');

// 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 = mysql_query($sql_menu) or die('Query failed.'); 
	
while($row_menu = mysql_fetch_array($result_menu))
{
	$menu[] = $row_menu; 
}
$smarty->assign('menu',$menu);	
// menu

// sortby dropdown 
	//~ $sql_filter = "SELECT distinct start_date, event_list_id FROM ".$TABLE_PROJECTS." where status_id='1' GROUP BY start_date order by start_date asc ";
	//~ $result_filter = mysql_query($sql_filter) or die('Query failed.'); 
	//~ while($row_filter = mysql_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")	
	{		
		$sql = "insert into ".$TABLE_PROJECT_BOOKING." (project_id,sort_order,description,booking_status,text_abbrv,status_id) values('".$_POST['event_id']."', '".$_POST['sort_order']."', '".$_POST['desc']."','".$_POST['booking']."','".$_POST['text_abbrv']."','1')";
		//echo $sql;				
		$result = mysql_query($sql) or die('Query failed5.'); 	
											
		$res="<font color=green>Inserted Successfully</font>";
		$smarty->assign('res',$res);
					
		header("Location: project_booking.php");
	}
	else if($_GET['event']=="notsave")	
	{
		// status
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysql_query($qry_status) or die('Query failed.1'); 
		while($row_status = mysql_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);		
		
		// events
		
		$event_id=$_GET['event_id'];
		$smarty->assign('event_id',$event_id);
		
		
		if($event_id!='')
		{
			$qry_event = "SELECT * FROM projects where event_list_id='".$event_id."' AND status_id = 1 ";
		
		}
		else
		{
			$qry_event = "SELECT project_id,project_name FROM projects where status_id = 1 order by sort_order asc";
		}
		
		$res_event = mysql_query($qry_event) or die('Query failed2.'); 
		while($row_event = mysql_fetch_array($res_event))
		{
			$event[] = $row_event; 
			$event_title=$row_event['project_name'];
			$event_list_id=$row_event['project_id'];
		}
		$smarty->assign('events',$event);	
		$smarty->assign('event_title',$event_title);	
		$smarty->assign('event_list_id',$event_list_id);
		
		$smarty->display("project_booking/project_booking_form.tpl");	
	}
}
// update entry
else if($_GET['action']=='edit')
{	
	if($_GET['event']=="save")	
	{
		$sql = "update ".$TABLE_PROJECT_BOOKING." set project_id='".$_POST['event_id']."', status_id='".$_POST['status_id']."', sort_order='".$_POST['sort_order']."', text_abbrv='".$_POST['text_abbrv']."', description='".$_POST['desc']."', booking_status='".$_POST['booking']."' where project_booking_id='".$_GET['id']."' ";	
	
		$result = mysql_query($sql) or die('Query failed.'); 											
			
		$res="<font color=green>Updated Successfully</font>";
		$smarty->assign('res',$res);
		
		header("Location: project_booking.php");
	
	}
	else if($_GET['event']=="notsave")	
	{
		$sql = "SELECT * FROM ".$TABLE_PROJECT_BOOKING." where project_booking_id='".$_GET['id']."'";	
		$result = mysql_query($sql) or die('Query failed.'); 
		while($row = mysql_fetch_array($result))
		{
			 $data[] = $row; 
		}
		 $catid; // for getting sub category
		$smarty->assign('data',$data);
		
		// get status array 
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysql_query($qry_status) or die('Query failed.'); 
		while($row_status = mysql_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}	
		$smarty->assign('status',$status);	
		
		
		
		// events
		$qry_event = "SELECT * FROM projects where status_id = 1";
		$res_event = mysql_query($qry_event) or die('Query failed2.'); 
		while($row_event = mysql_fetch_array($res_event))
		{
			$event[] = $row_event; 
			$event_title=$row_event['project_name'];
			$event_list_id=$row_event['project_id'];
		}
		$smarty->assign('events',$event);	
		$smarty->assign('event_title',$event_title);	
		$smarty->assign('event_list_id',$event_list_id);
		
		
		$smarty->display("project_booking/project_booking_edit_form.tpl");	
	}
}
// delete record
else if($_GET['action']=='delete')
{	
	$sql = "delete from project_booking where project_booking_id='".$_GET['id']."' ";
	$result = mysql_query($sql) or die('Query failed.'); 		
	header("Location: project_booking.php?evid=".$_POST['evid']."");		
}
// delete all record
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_PROJECT_BOOKING." where project_booking_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project_booking.php?evid=".$_POST['evid']."");		
		}
	}
	
	// disable start
	if(isset($_POST['disable']))
   {
		$count= count($_POST['checkbox']);
		
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "update ".$TABLE_PROJECT_BOOKING." set status_id=0  where project_booking_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project_booking.php?evid=".$_POST['evid']."");		
		}
	}
	// 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_PROJECT_BOOKING." set status_id=1  where project_booking_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: project_booking.php?evid=".$_POST['evid']."");		
		}
	}
	// enable end
	$smarty->display("project_booking/project_booking.tpl");	
}
else if($_GET['event_id']!='')
{
	$event_id=$_GET['event_id'];
	
	$sql = "SELECT gallery_id, thumbpath, img_des, sort_order, status_name FROM ".$TABLE_PROJECT_BOOKING." LEFT JOIN ".$TABLE_STATUS." ON ".$TABLE_PROJECT_BOOKING.".status_id=".$TABLE_STATUS.".status where project_id=".$event_id." order by sort_order ";
 
	$result = mysql_query($sql) or die('Query failed.'); 
	while($row = mysql_fetch_array($result))
	{
		$data[] = $row; 				
	}
	$event_id=$_GET['event_id'];
	$smarty->assign('event_id',$event_id);

$smarty->assign('data',$data);	
	
	$smarty->display("project_booking/project_booking.tpl");	
}
// default display
else
{  
	
		
	if($_GET['eid']!='')
	{
		
	 	$sql1 = "SELECT event_list_id FROM event_list where start_date='".$_GET['eid']."' ";
 		$result1 = mysql_query($sql1) or die('Query failed.'); 
		while($row1= mysql_fetch_array($result1))		
		{			
	 		$sql = "SELECT gallery_id, event_id, thumbpath, img_des, sort_order, status_name FROM ".$TABLE_PROJECT_BOOKING." LEFT JOIN ".$TABLE_STATUS." ON ".$TABLE_PROJECT_BOOKING.".status_id=".$TABLE_STATUS.".status where project_id='".$row1['event_list_id']."' ";
			
 			$result = mysql_query($sql) or die('Query failed.'); 
			while($row = mysql_fetch_array($result))
			{
				$data[] = $row; 			
			}
		}					
	}
	else if($_GET['evid']!='')
	{
		
		$sql2 = "SELECT start_date FROM event_list where event_list_id='".$_GET['evid']."' ";
 		$result2 = mysql_query($sql2) or die('Query failed.'); 
		$row2= mysql_fetch_array($result2);	
	    $startdate=$row2['start_date'];
	
		$sql1 = "SELECT event_list_id FROM event_list where start_date='".$startdate."' ";
 		$result1 = mysql_query($sql1) or die('Query failed.'); 
		while($row1= mysql_fetch_array($result1))		
		{			
	 		$sql = "SELECT gallery_id, event_id, thumbpath, img_des, sort_order, status_name FROM ".$TABLE_PROJECT_BOOKING." LEFT JOIN ".$TABLE_STATUS." ON ".$TABLE_PROJECT_BOOKING.".status_id=".$TABLE_STATUS.".status where project_id='".$row1['event_list_id']."' ";
			
 			$result = mysql_query($sql) or die('Query failed.'); 
			while($row = mysql_fetch_array($result))
			{
				$data[] = $row; 			
			}
		}				
	}
	else
	{
		$sql = "SELECT g.*,p.project_name, status_name FROM ".$TABLE_PROJECT_BOOKING." AS g LEFT JOIN ".$TABLE_STATUS." AS s ON s.status = g.status_id LEFT JOIN projects AS p ON p.project_id = g.project_id";
		
 		$result = mysql_query($sql) or die('Query failed.'); 
		while($row = mysql_fetch_array($result))
		{
			$data[] = $row; 			
		}
	}
	//~ print_r($data);
	//~ exit;
	
	// Smarty Pagination Script Start 
		
    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('dataset',$productPages);	
		    $smarty->assign('pageNumbers',$pageNumbers);		
		  }
    }
		// Smarty Pagination Script End 
		
	$smarty->display("project_booking/project_booking.tpl");	
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: project_booking.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation