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: department.php

<?php ob_start();
include("config/db.php");	
include_once 'functions/processes.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_DEPARTMENT=$smarty->getTemplateVars('TABLE_DEPARTMENT');

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

// add entry
if($_GET['action']=='add')
{	
	if($_GET['event']=="save")	
	{
		$smarty->display("departments/department.tpl");

$sql = "insert into ".$TABLE_DEPARTMENT." (department,status_id,sort_order) values('".$_POST['department']."', '".$_POST['status_id']."', '".$_POST['sort_order']."')";
		$result = mysql_query($sql) or die('Query failed.'); 		
		header("Location: department.php");
	}
	else if($_GET['event']=="notsave")	
	{
		$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);	
		$smarty->assign('menu',$menu);
		$smarty->display("departments/department_form.tpl");	
	}
}
// update entry
else if($_GET['action']=='edit')
{	
	if($_GET['event']=="save")	
	{			
		
		$sql = "update ".$TABLE_DEPARTMENT." set department='".$_POST['department']."', status_id='".$_POST['status_id']."', sort_order='".$_POST['sort_order']."' where department_id='".$_GET['id']."' ";
		$result = mysql_query($sql) or die('Query failed.'); 		
		header("Location: department.php");
	}
	else if($_GET['event']=="notsave")	
	{
		$sql = "SELECT * FROM ".$TABLE_DEPARTMENT." where department_id='".$_GET['id']."'";
		$result = mysql_query($sql) or die('Query failed.'); 
		while($row = mysql_fetch_array($result))
		{
			$data[] = $row; 
		}
		$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);
		$smarty->assign('menu',$menu);			
		$smarty->display("departments/department_edit_form.tpl");	
	}
}
// delete record
else if($_GET['action']=='delete')
{	
	$sql = "delete from ".$TABLE_DEPARTMENT." where department_id='".$_GET['id']."' ";
	$result = mysql_query($sql) or die('Query failed.'); 		
	
	
	// delete consultant 
	$con_qry = "select consultant_id from consultant where department_id='".$_GET['id']."' ";	
	
	$con_res = mysql_query($con_qry) or die('Query failed.'); 
	while($con_row = mysql_fetch_array($con_res))
	{
		
		$del_con = "delete from consultant where consultant_id='".$con_row['consultant_id']."' ";
		mysql_query($del_con) or die('Query failed.'); 		
		
	}
	
	//end
	
	header("Location: department.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_DEPARTMENT." where department_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: department.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_DEPARTMENT." set status_id=0  where department_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: department.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_DEPARTMENT." set status_id=1  where department_id='".$del_id."' ";
			$result = mysql_query($sql) or die('Query failed.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: department.php");		
		}
	}
	// enable end

// order by id
	if($_GET['orderby']=='id')
	{
		$orderby='order by department_id asc ';
	}
	// order by title
	else if($_GET['orderby']=='name')
	{
		$orderby='order by department asc ';
	}
	// order by sort order
	else if($_GET['orderby']=='sortorder')
	{
		$orderby='order by sort_order asc ';
	}
	// order by status
	else if($_GET['orderby']=='status')
	{
		$orderby='order by department.status_id asc ';
	}
	// default
	else 
	{
		$orderby='order by sort_order asc ';
	}
	
	
		$sql = "SELECT department_id, department, sort_order, status_name FROM ".$TABLE_DEPARTMENT." LEFT JOIN ".$TABLE_STATUS." ON
 ".$TABLE_DEPARTMENT.".status_id=".$TABLE_STATUS.".status ".$orderby." ";
	 
		$result = mysql_query($sql) or die('Query failed.'); 
		while($row = mysql_fetch_array($result))
		{
			$data[] = $row; 		
			
		}
		
		$smarty->assign('data',$data);
		$smarty->assign('menu',$menu);	
		$smarty->display("departments/department.tpl");	
	//orderby end
}

// default display
else
{
	$sql = "SELECT department_id, department, sort_order, status_name FROM ".$TABLE_DEPARTMENT." LEFT JOIN ".$TABLE_STATUS." ON
 ".$TABLE_DEPARTMENT.".status_id=".$TABLE_STATUS.".status order by sort_order ";	
	
	$result = mysql_query($sql) or die('Query failed.'); 
	while($row = mysql_fetch_array($result))
	{
		$data[] = $row; 
	}
	$smarty->assign('data',$data);
	$smarty->assign('menu',$menu);
	$smarty->display("departments/department.tpl");	
}		
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: department.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation