Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 4.18.0-553.92.1.el8_10.x86_64

PHP Version:

7.4.33

User:

shahshaktiorg.in_y8b7g9a180n

Directory:

/var/www/vhosts/shahshaktiorg.in/httpdocs/includes/classes

Free Space:

504.52 GB

🔧 Quick Actions

✏️ Editing: class_gen_function.php

<?php 
class gen_function extends main_function 
{

var $conn;
	function gen_function()
	{
		$this->conn = parent::main_function();
		parent::setMysqlKeyword("now()");
	}
	
	function data_conn()
	{
		return $this->conn;
	}
	
	function close_mysql()
	{
		parent::close_mysql_connection();
	}
	
	function short_description($descr,$noc="")
	{

$sdescr=strip_tags($descr);
		if(empty($noc))$noc=200;
		if(trim($sdescr)<>'')
		{
			if(strlen($sdescr)>$noc)
				return substr($sdescr, 0, $noc).".....";
			else
				return $sdescr;

}
		else
			return $sdescr;
	}

///////////for redirect url////////

function reDirect($url)
	{
		header("Location: ".$url);
		exit;
	}

/*function goTo($url)

{

echo "<script>window.location.href='$url'</script>";

exit;

}*/

///////////for redirect url////////
	function filterData($data,$strip=1)
	{
		$fdata=parent::data_prepare($data,0);
		if(!$strip)
			return $fdata;
		return stripslashes($fdata);
	}
	function filterData_array($datagiven)
	{
		foreach ($datagiven as $key=>$value)
		{
			if(is_array($value))
			{
				$data[$key]=$this->filterData_array($value);
			}
			else
			{
				$data[$key]=$this->filterData($value);
			}
		}
		return $data;
	}
	
	function filter_numeric($data)
	{
		$dataF = preg_replace('/[^0-9]/', '',$data);
		return $dataF;
	}
	function filter_alphabet($data)
	{
		$dataF = preg_replace('/[^a-zA-Z]/','',$data);
		return $dataF;
	}
	function filter_alphanum($data)
	{
		$dataF = preg_replace('/[^a-zA-Z0-9]/', '',$data);
		return $dataF;
	}
	function filter_mysql($data)
	{
		$dataF = mysqli_real_escape_string($this->conn,$data);
		return $dataF;
	}
	
	
	function filter_mysql_array($datagiven)
	{
		foreach ($datagiven as $key=>$value)
		{
			if(is_array($value))
			{
				$data[$key]=$this->filter_mysql_array($value);
			}
			else
			{
				$data[$key]=$this->filter_mysql($value);
			}
		}
		return $data;
	}

function sendMail($to="", $subject="", $body="",$from="",$fromname="",$type="",$replyto="",$bcc="",$cc="")
	{

if(empty($type))
		{
			$type="html";
		}
		if($type=="plain")
		{
			$body = strip_tags($body);
		}
		if($type=="html")
		{
			$body = "<font face='Verdana, Arial, Helvetica, sans-serif'>".$body."</font>";
		}

/* To send HTML mail*/

$headers = "MIME-Version: 1.0\r\n"; 
		$headers.= "Content-type: text/".$type."; charset=iso-8859-1\r\n";
		/* additional headers */ 
		//$headers .= "To: <".$to.">\r\n"; 
		if(!empty($from))
		{
			$headers .= "From: ".$fromname." <".$from.">\r\n";
		}

if(!empty($replyto))
		{
			$headers .= "Reply-To: <".$replyto.">\r\n"; 
		}

if(!empty($cc))
		{
			$headers .= "Cc: ".$cc."\r\n";
		}

if(!empty($bcc))
		{
			$headers .= "Bcc: ".$bcc."\r\n";
		}
		if(@mail($to, $subject, $body, $headers))
		{
			return 1;
		}
		else
		{
			return $headers;
		}
	}

//////////////////////FILE UPLOAD/////////////////////////////

function uploadFile($file_id, $folder="", $types="",$rename="") 
{

$file_title = $_FILES[$file_id]['name'];
	$file_tmp = $_FILES[$file_id]['tmp_name'];
    if(!$file_title) return array('','No file specified');
    //Get file extension
    $ext_arr = explode(".",basename($file_title));
    $ext = strtolower($ext_arr[count($ext_arr)-1]); //Get the last extension
    if(!empty($types))
    { 
     $all_types = explode(",",strtolower($types));
		if($types) 
		{
			if(in_array($ext,$all_types));
			else {
				$result = "'".$file_title."' is not a valid file."; //Show error if any.
				return array('',$result);
			}
		}
	}

//Not really uniqe - but for all practical reasons, it is

if(!empty($rename))
	{
	 	$file_name=$rename.'.'.$ext; 
	}
	else
	{
		$uniqer = substr(md5(uniqid(rand(),1)),0,5);
		$file_name = $uniqer . '_' . date('YmdHis').'.'.$ext;//Get Unique Name
	}

//Where the file must be uploaded to

if($folder) $folder .= '/';//Add a '/' at the end of the folder
    $uploadfile = $folder . $file_name;
    $result = '';

//Move the file from the stored location to the new location

if (!move_uploaded_file($file_tmp, $uploadfile)) 
	{
        $result = "Cannot upload the file '".$file_title."'"; //Show error if any.
        if(!file_exists($folder)) 
		{
            $result .= " : Folder don't exist.";
        } 
		elseif(!is_writable($folder)) 
		{
            $result .= " : Folder not writable.";
        } 
        $file_name = '';

} else {

if(!$_FILES[$file_id]['size']) { //Check if the file is made
            @unlink($uploadfile);//Delete the Empty file
            $file_name = '';
            $result = "Empty file found - please use a valid file."; //Show the error message
        } else {
            chmod($uploadfile,0777);//Make it universally writable.
        }
    }
    return array($file_name,$result);

}

//////////////////////////////////////PAGING/////////////////////////////////////////////////////

function get_page_name($path='')
{
	$page_path = ($path != "") ? $path : $_SERVER['HTTP_REFERER']; 
	$url_parts = parse_url($page_path);
	$tmp_path = explode("/",$url_parts['path']); //pre($tmp_path);
	$page_name = array_pop($tmp_path);
	$page_name = !empty($page_name) ? $page_name : "index.php";
	$page_name .= ($url_parts['query'] != "") ? "?".$url_parts['query'] : "";
	$page_name .= ($url_parts['fragment'] != "") ? "#".$url_parts['fragment'] : "";
	return $page_name;
}

function randCode($limit)
	{
		$rand=rand();
		$rand1=md5($rand);
		$pass = substr($rand1, 0, $limit);
		return $pass;
	}

function encryptPass($strPass)
	{
		$strPass=trim($strPass);
		$basePass=base64_encode($strPass);
		$revPass=strrev($basePass);
		//echo $oriPass=base64_decode(strrev($revPass));
		$first4=$this->randCode(4);
		$last4=$this->randCode(4);
		$enc_revPass=$first4.$revPass.$last4;
		return $enc_revPass;
	}

function retrievePass($enc_revPass){
		$pass=substr($enc_revPass,4);
		$last4=substr($pass,-4,4);
		$pass1=str_replace($last4,"",$pass);
		$revPass=strrev($pass1);
		$oriPass=base64_decode($revPass);
		return $oriPass;
	//	echo "<br>".$oriPass;
	}

function mailBody($bodypart)
	{

$data='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Rank Your Company</title>
</head>
<body>
<table width="100%" border="0" cellpadding="10" cellspacing="0" background="images/bg.gif">
  <tr>
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="left" valign="top"><img src="'.FURL.'images/logo.png" alt="" /></td>
      </tr>
      <tr>
        <td align="left" valign="top"><table width="100%" border="0" cellpadding="10" cellspacing="0" bgcolor="#fff">
          <tr>
            <td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td align="left" valign="top"><font face="Arial, Helvetica, sans-serif" color="#000000" size="2">'.$bodypart.'<br>Thank you from Bhabimatch</font></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td height="30" align="center" valign="middle"><font size="2" color="#000000" face="Arial, Helvetica, sans-serif">'.'Copyright © '.YEAR.' <a href="'.FURL.'">'.SITE_NAME_FULL.'</a> All Rights Reserved.'/*FOOTER_TEXT*/.'</font></td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>';

return $data;

}

///////////////////School Login Secure///////////////////////////
	
			function schoolSecure()
			{
				$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
				if(!$this->isSchoolLogged())
				{
					header("location:".FURL.'school/index.php');
					exit;
				}
			}
			
			function isSchoolLogged()
			{
				global $obj;
				if(isset($_SESSION['school']))
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentSchool()
			{
				return $_SESSION['school']['id'];
			}
			
			///////////////////District Login Secure///////////////////////////
	
			function distSecure()
			{
				$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
				if(!$this->isDistLogged())
				{
					header("location:".FURL.'dist/index.php');
					exit;
				}
			}
			
			function isDistLogged()
			{
				global $obj;
				if(isset($_SESSION['adminuser']['id']) && ($_SESSION['adminuser']['admin_type']>=1 && $_SESSION['adminuser']['admin_type']<=4))
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentDist()
			{
				return $_SESSION['adminuser']['id'];
			}
	
		 	function get_my_dist($dist_login_id)
			{
				$res=parent::selectData(TABLE_ADMIN_USER,"","status='Active' and id='".$dist_login_id."'",1);
				if($res['dist_id']!='') return $res['dist_id'];
				else return "";
			}
	////////////////////////////////////////////////////////////////
	///////////////////State Login Secure///////////////////////////
	
			function stateSecure()
			{
				$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
				if(!$this->isStateLogged())
				{
					header("location:".FURL.'state/index.php');
					exit;
				}
			}
			
			function isStateLogged()
			{
				global $obj;
				if(isset($_SESSION['adminuser']['id']) && ($_SESSION['adminuser']['admin_type']>=5 && $_SESSION['adminuser']['admin_type']<=6))
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentState()
			{
				return $_SESSION['adminuser']['id'];
			}
	
	////////////////////////////////////////////////////////////////
	
	///////////////////Sub Director Login Secure///////////////////////////
	
			function subdirSecure()
			{
				$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
				if(!$this->isSubDirectorLogged())
				{
					header("location:".FURL.'sub_director/index.php');
					exit;
				}
			}
			
			function isSubDirectorLogged()
			{
				global $obj;
				if(isset($_SESSION['adminuser']['id']) && ($_SESSION['adminuser']['admin_type']>=8 && $_SESSION['adminuser']['admin_type']<=11))
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentSubDirector()
			{
				return $_SESSION['adminuser']['id'];
			}
			
			function getCurrentSubDirectorType()
			{
				return $_SESSION['adminuser']['admin_type'];
			}
	
	////////////////////////////////////////////////////////////////
	///////////////////Sub Director Login Secure///////////////////////////
	
			function dirSecure()
			{
				$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
				if(!$this->isDirectorLogged())
				{
					header("location:".FURL.'director/index.php');
					exit;
				}
			}
			
			function isDirectorLogged()
			{
				global $obj;
				if(isset($_SESSION['adminuser']['id']) && $_SESSION['adminuser']['admin_type']==7)
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentDirector()
			{
				return $_SESSION['adminuser']['id'];
			}
			
			
	
	////////////////////////////////////////////////////////////////
	
		 ///////////////////Admin Login Secure///////////////////////////
	
			function adminSecure()
			{
				$_SESSION['admin_request_path']= basename($_SERVER['REQUEST_URI']);
				if(!$this->isAdminLogged())
				{
					header("location:".FURL.'admin/index.php');
					exit;
				}
			}
			
			function isAdminLogged()
			{

if(isset($_SESSION['master']))
				{
						return true;
					
				}
				else
				{
					    return false;
				}
			}
			
			
			function getCurrentAdmin()
			{
				return $_SESSION['master'];
			}
	
	////////////////////////////////////////////////////////////////
	
	///////////////////District Tag Dept Login Secure///////////////////////////

function deptagSecure()
		{
			$_SESSION['user_request_path']=basename($_SERVER['REQUEST_URI']);
			if(!$this->isdeptagLogged())
			{
				header("location:".FURL.'dist/index.php');
				exit;
			}
		}

function isdeptagLogged()
		{
			global $obj;
			if(isset($_SESSION['adminuser']['id']))
			{
				return true;			
			}
			else
			{
			   return false;
			}
		}

function getCurrentdeptag()
		{
			return $_SESSION['adminuser']['id'];
		}

//////////////////////////////////////////////////////////////// 
	
		function show_drop_down_approved_bugts($sch_id,$selVal='')
		{
			$str = "<option value=''> Select Approved Salary Budget </option>";
			$bugt_procss = $this->school_budget_processes_permit($sch_id);
			if($bugt_procss=="") $bugt_procss = "0";
			$sqlBP  =  parent::selectData(TABLE_SALARY_BUDGET,"","procl_id in (".$bugt_procss.") and sch_id='".$sch_id."'");
			while($dataBP = mysqli_fetch_array($sqlBP))
			{
				$str.="<option value='".$dataBP['bugts_id']."'";
				if($dataBP['bugts_id']==$selVal)
				{
					$str.=' selected';
				}
				$str.=">".$this->get_budget_process($dataBP['procl_id'])." - ".$this->get_financial_year($dataBP['finy_id'])."</option>";
			}
			return $str;
		}
		
		function show_drop_down_approved_bugte($sch_id,$selVal='')
		{
			$str = "<option value=''> Select Approved Expense Budget </option>";
			$bugt_procss = $this->school_budget_processes_permit($sch_id);
			if($bugt_procss=="") $bugt_procss = "0";
			$sqlBP  =  parent::selectData(TABLE_EXPENSE_BUDGET,"","procl_id in (".$bugt_procss.")");
			while($dataBP = mysqli_fetch_array($sqlBP))
			{
				$str.="<option value='".$dataBP['bugte_id']."'";
				if($dataBP['bugte_id']==$selVal)
				{
					$str.=' selected';
				}
				$str.=">".$this->get_financial_year($dataBP['finy_id'])."</option>";
			}
			return $str;
		}
	
	    function getTeacherQualifications($teach_id)
		{
			$dataT = "";
			$sqlTQ  =  parent::selectData(TABLE_TEACHER_QUALIFICATION,"","teach_id='".$teach_id."' ");
			while($dataTQ = mysqli_fetch_array($sqlTQ))
			{
				$dataT .= $dataTQ['teachq_qualification']."-";
			}
			return rtrim($dataT,"-");
		}
		
		
		function show_drop_down_fin_year($selVal='')
		{
			$str = "<option value=''> Select Financial Year </option>";
			$res=parent::selectData(TABLE_FIN_YEAR,"","finy_status='Active'","","finy_id asc");
			while($row=mysqli_fetch_array($res))
			{
				$str.="<option value='".$row['finy_id']."'";
				if($row['finy_id']==$selVal)
				{
					$str.=' Selected="Selected"';
				}
				$str.=">".$row['finy_title']."</option>";
			}
			return $str;		
		}
		
		function show_drop_down_qtr($selVal='')
		{
			$str = "";
			//$str = "<option value=''> Select Month </option>";
			$res=parent::selectData(TABLE_QUARTER,"","","","qtr_id asc");
			while($row=mysqli_fetch_array($res))
			{
				$str.="<option value='".$row['qtr_id']."'";
				if($row['qtr_id']==$selVal)
				{
					$str.=' selected';
				}
				$str.=">".$row['qtr_mon']."</option>";
			}
			return $str;		
		}
		
		function get_qtr_name($qtr_id)
		{
			$res=parent::selectData(TABLE_QUARTER,"","qtr_id='".$qtr_id."'",1);
			if($res['qtr_id']!='') return $res['qtr_mon'];
		}
		
		function get_qtr_details($qtr_id)
		{
			$res=parent::selectData(TABLE_QUARTER,"","qtr_id='".$qtr_id."'",1);
			if($res['qtr_id']!='') return $res['qtr_mon']."";
		}
		
		function get_financial_year($finy_id)
		{
			$res=parent::selectData(TABLE_FIN_YEAR,"","finy_status='Active' and finy_id='".$finy_id."'",1);
			if($res['finy_title']!='') return $res['finy_title'];
			else return "";
		}
		
		function get_qtr_date_range($qtr_id,$finy_id)
		{
			$resFY=parent::selectData(TABLE_FIN_YEAR,"","finy_status='Active' and finy_id='".$finy_id."'",1);
			$resQ=parent::selectData(TABLE_QUARTER,"","qtr_id='".$qtr_id."'",1);
			$start_date = "";
			$end_date = "";
			if($qtr_id<4)
			{
				$start_date =  $resQ['qtr_from_date']."-".$resQ['qtr_from_mond']."-".$resFY['finy_start'];
				$end_date   =  $resQ['qtr_to_date']."-".$resQ['qtr_to_mond']."-".$resFY['finy_start'];		
			}
			else
			{
				$start_date =  $resQ['qtr_from_date']."-".$resQ['qtr_from_mond']."-".$resFY['finy_start'];
				$end_date   =  $resQ['qtr_to_date']."-".$resQ['qtr_to_mond']."-".$resFY['finy_end'];
			}
			
			return $start_date." to ".$end_date;
		}
		
		//////////////////////Master Table Drop Down Field///////////////
	
		function show_drop_down_managed_by($selVal)
		{
			$str.= "<option value=''>--Select Managed By--</option>";
			$res=parent::selectData(TABLE_MANAGED_BY,"","mngb_status='Active'","");
			while($row=mysqli_fetch_array($res))
			{
				$str.="<option value='".$row['mngb_id']."'";
				if($row['mngb_id']==$selVal)
				{
					$str.=' selected';
				}
				$str.=">".$row['mngb_title']."</option>";
			}
			return $str;		
		}
	
		
		function getSchoolName($school_id)
		{
			$dataSch  =  parent::selectData(TABLE_SCHOOL,"","sch_id='".$school_id."'",1);
			return $dataSch['sch_name'];
		}
		
		function getSchoolCode($school_id)
		{
			$dataSch  =  parent::selectData(TABLE_SCHOOL,"","sch_id='".$school_id."'",1);
			return $dataSch['sch_code'];
		}
		
		
		function school_budget_processes_permit($school_id)
		{
			$schS = parent::selectData(TABLE_SCHOOL_MAP,"","status='Active' and sch_id='".$school_id."'",1);
			if(isset($schS['sch_id']) && $schS['sch_id']!='')
			{
				return trim($schS['procl_id_permit'],",");
			}
			else
			{
				return "";
			}
		}
		
		function school_budget_processes_assign($school_id)
		{
			$schS = parent::selectData(TABLE_SCHOOL_MAP,"","status='Active' and sch_id='".$school_id."'",1);
			if(isset($schS['sch_id']) && $schS['sch_id']!='')
			{
				return trim($schS['procl_id_assign'],",");
			}
			else
			{
				return "";
			}
		}
		
		function school_exp_budget_processes_permit($school_id)
		{
			$schS = parent::selectData(TABLE_SCHOOL_MAP,"","status='Active' and sch_id='".$school_id."'",1);
			if(isset($schS['sch_id']) && $schS['sch_id']!='')
			{
				return trim($schS['expb_permit']," ");
			}
			else
			{
				return "";
			}
		}
		
		function school_budget_process_top($school_id)
		{
			$bugt_procsses = explode(",",$this->school_budget_processes_assign($school_id));
			$bugte_arr['procl_id'] 	 = max($bugt_procsses);
			return $bugte_arr['procl_id'];
		}
		
		function get_budget_process($procl_id)
		{
			$res=parent::selectData(TABLE_PROCESS_LINK,"","procl_status='Active' and procl_id='".$procl_id."'",1);
			if($res['procl_title']!='') return $res['procl_title'];
			else return "";
		}
		
		function get_mapped_teachers($school_id,$procl_id)
		{
			$teachs = '';
			$teacherMS = parent::selectData(TABLE_SCHOOL_TEACHER_MAP,"","status='Active' and sch_id='".$school_id."' and procl_id='".$procl_id."'");
			while($teacherMD = mysqli_fetch_array($teacherMS))
			{
				$teachs .= $teacherMD['teacher_id'].",";
			}
			$teachs = rtrim($teachs,",");
			return $teachs;
		}
		
		
		function get_all_school_by_dist($dist_id)
		{
			$schools = '';
			$resS=parent::selectData(TABLE_SCHOOL,"","sch_dist_id='".$dist_id."' and sch_status='Active'");
			while($dataS = mysqli_fetch_array($resS))
			{
				$schools .= $dataS['sch_id'].",";
			}
			$schools = rtrim($schools,",");
			return $schools;
		}		
		
		function get_school_category($scat_id)
		{
			$sql_scat = parent::selectData(TABLE_SCHOOL_CATEGORY,"","scat_id='".$scat_id."'",1);
			return $sql_scat['scat_title'];
		}
		
		function get_school_category_by_sch_id($sch_id)
		{
			$dataSch  =  parent::selectData(TABLE_SCHOOL_MAP,"","sch_id='".$sch_id."'",1);
			if(isset($dataSch['scat_id']) && $dataSch['scat_id']!='')
			{
				$scat_id  =  $dataSch['scat_id'];
				$dataSC   =  parent::selectData(TABLE_SCHOOL_CATEGORY,"","scat_id='".$scat_id."'",1);
				return $dataSC['scat_title'];
			}
			else
			{
				return "";
			}	
		}
		
		function school_budget_amount($school,$procl_id,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugts = parent::selectData(TABLE_SALARY_BUDGET,"","sch_id='".$school."' and procl_id='".$procl_id."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugts['bugts_salary'])) return $sql_bugts['bugts_salary'];
			else return "";
		}
		function school_expense_budget_amount($school,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugte = parent::selectData(TABLE_EXPENSE_BUDGET,"","sch_id='".$school."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugte['bugte_expense'])) return $sql_bugte['bugte_expense'];
			else return "";
		}
		function school_budget_status($school,$procl_id,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugts = parent::selectData(TABLE_SALARY_BUDGET,"","sch_id='".$school."' and procl_id='".$procl_id."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugts['bugts_fwd_1_status']) && $sql_bugts['bugts_fwd_1_status']!="") return $sql_bugts['bugts_fwd_1_status'];
			else return "";
		}
		function school_expense_budget_status($school,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugts = parent::selectData(TABLE_EXPENSE_BUDGET,"","sch_id='".$school."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugts['bugte_fwd_1_status']) && $sql_bugts['bugte_fwd_1_status']!="") return $sql_bugts['bugte_fwd_1_status'];
			else return "";
		}
		
		function school_budget_exist($school,$procl_id,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugts = parent::selectData(TABLE_SALARY_BUDGET,"","sch_id='".$school."' and procl_id='".$procl_id."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugts['bugts_id']) && $sql_bugts['bugts_id']!="") return $sql_bugts['bugts_id'];
			else return false;
		}
		
		function school_sal_budget_is_approved($school,$procl_id,$finy_id)
		{
			$sql_bugts = parent::selectData(TABLE_SALARY_BUDGET,"","sch_id='".$school."' and procl_id='".$procl_id."' and finy_id='".$finy_id."' and bugts_status='FA'",1);
			if(isset($sql_bugts['bugts_id']) && $sql_bugts['bugts_id']!="") return $sql_bugts['bugts_id'];
			else return false;
		}
		
		function school_exp_budget_is_approved($school,$finy_id)
		{
			$sql_bugte = parent::selectData(TABLE_EXPENSE_BUDGET,"","sch_id='".$school."'  and finy_id='".$finy_id."' and bugte_status='FA'",1);
			if(isset($sql_bugte['bugte_id']) && $sql_bugte['bugte_id']!="") return $sql_bugte['bugte_id'];
			else return false;
		}
		
		
		function school_sal_fund_app_exists($school,$bugts_id,$qtr_id)
		{
			$sql_funds = parent::selectData(TABLE_FUNDS_APPLY,"","sch_id='".$school."' and bugts_id='".$bugts_id."' and qtr_id='".$qtr_id."'",1);
			if(isset($sql_funds['funda_id']) && $sql_funds['funda_id']!="") return $sql_funds['funda_id'];
			else return false;
		}
		
		function school_exp_fund_app_exists($school,$bugte_id,$qtr_id)
		{
			$sql_funds = parent::selectData(TABLE_FUNDE_APPLY,"","sch_id='".$school."' and qtr_id='".$qtr_id."'",1);
			if(isset($sql_funds['funda_id']) && $sql_funds['funda_id']!="") return $sql_funds['funda_id'];
			else return false;
		}
		
		function get_sal_fund_app_amt($school,$bugts_id,$qtr_id)
		{
			$sql_funds = parent::selectData(TABLE_FUNDS_APPLY,"","sch_id='".$school."' and bugts_id='".$bugts_id."' and qtr_id='".$qtr_id."'",1);
			if(isset($sql_funds['funda_amt_total']) && $sql_funds['funda_amt_total']!="") return $sql_funds['funda_amt_total'];
			else return "0";
		}
		function get_exp_fund_app_amt($school,$bugte_id,$qtr_id)
		{
			$sql_funds = parent::selectData(TABLE_FUNDE_APPLY,"","sch_id='".$school."' and bugte_id='".$bugte_id."' and qtr_id='".$qtr_id."'",1);
			if(isset($sql_funds['funda_amt_total']) && $sql_funds['funda_amt_total']!="") return $sql_funds['funda_amt_total'];
			else return "0";
		}
		
		function school_expense_budget_exist($school,$finy_id)
		{
			//echo $school."=".$procl_id."=".$finy_id;
			$sql_bugte = parent::selectData(TABLE_EXPENSE_BUDGET,"","sch_id='".$school."' and finy_id='".$finy_id."'",1);
			if(isset($sql_bugte['bugte_id']) && $sql_bugte['bugte_id']!="") return $sql_bugte['bugte_id'];
			else return false;
		}
		
		
		
		function school_expense_amount($school)
		{
			$sql_bugte = parent::selectData(TABLE_EXPENSE_BUDGET,"","sch_id='".$school."'",1);
			if(isset($sql_bugte['bugte_expense'])) return $sql_bugte['bugte_expense'];
			else return "";
		}
		
		
		function get_notification_count($noti_for,$noti_id='')
		{
			$where = "";
			if($noti_for!='DSEL') $where = " and noti_for_id='".$noti_id."'";
			$dataN = parent::selectData(TABLE_NOTIFICATION,"count(noti_id) as totalN","noti_status='UR' and noti_for='".$noti_for."' ".$where,1);
			if($dataN['totalN']!='') return $dataN['totalN'];
			else return "0";
			 
		}
		
		function esanc_order_exist($funda_id,$fund_type)
		{
			$sql_funds = parent::selectData(TABLE_ESANC_APPLY,"","fund_id='".$funda_id."' and es_type='".$fund_type."' and es_status!='FR'",1);
			if($sql_funds['es_id']!='') return $sql_funds['es_id'];
			else return false;
		}
		
		// ===================== Surajit =========================
	
	function show_drop_down_budget_process($selVal)
	{
		$str.= "<option value=''>--Select School Category--</option>";
		$res=parent::selectData(TABLE_PROCESS_LINK,"","procl_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['procl_id']."'";
			if(strpos($selVal,","))
			{
				$selValarr=explode(",",$selVal);
				if(in_array($row['procl_id'],$selValarr))
				{
				$str.=' selected';
				}
			}
			else
			{
				if($row['procl_id']==$selVal)
				{
					$str.=' selected';
				}
			}
			$str.=">".$row['procl_title']."</option>";
		}
		return $str;
	}
	
	function show_drop_down_school_budget_process($selVal,$selectval)
	{
		     $procl_id_assign=$selVal;
		     $procl_id_assign_f1=substr($procl_id_assign,1);
			 $procl_id_assign_arr=explode(",",$procl_id_assign_f1);
		
		//$selVal_arr=explode(",",$selVal);
		//pre($selVal_arr);
		$str.= "<option value=''>--Select School Budget Process--</option>";
		$res=parent::selectData(TABLE_PROCESS_LINK,"","procl_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			
			if(in_array($row['procl_id'],$procl_id_assign_arr)){
				
				$str.="<option value='".$row['procl_id']."'";
				if($row['procl_id']==$selectval)
				{
					$str.=' selected';
				}
				$str.=">".$row['procl_title']."</option>";
			}
			
		}
		return $str;		
	}
	function show_drop_down_school_category($selVal)
	{
		$str.= "<option value=''>--Select School Category--</option>";
		$res=parent::selectData(TABLE_SCHOOL_CATEGORY,"","scat_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['scat_id']."'";
			if($row['scat_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['scat_title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_appoinment_nature($selVal)
	{
		$str.= "<option value=''>--Select Nature Of Appoinment--</option>";
		$res=parent::selectData(TABLE_APPOINMENT_NATURE,"","aptn_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['aptn_id']."'";
			if($row['aptn_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['aptn_title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_post_nature($selVal)
	{
		$str.= "<option value=''>--Select Nature Of Post--</option>";
		$res=parent::selectData(TABLE_POST_NATURE,"","postn_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['postn_id']."'";
			if($row['postn_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['postn_title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_staff_category($selVal)
	{
		$str.= "<option value=''>--Select Staff Category--</option>";
		$res=parent::selectData(TABLE_STAFF_CATEGORY,"","staffc_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['staffc_id']."'";
			if($row['staffc_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['staffc_title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_appointed_category($selVal)
	{
		$str.= "<option value=''>--Select Appointed Category--</option>";
		$res=parent::selectData(TABLE_APPOINTED_CATEGORY,"","appc_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['appc_id']."'";
			if($row['appc_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['appc_title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_district($selVal)
	{
		$str.= "<option value=''>--Select District--</option>";
		$res=parent::selectData(TABLE_DISTRICT,"","dist_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['dist_id']."'";
			if($row['dist_id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['dist_name']."</option>";
		}
		return $str;		
	}
	function get_district_name($dist_id)
	{
		$res=parent::selectData(TABLE_DISTRICT,"","dist_status='Active' and dist_id='".$dist_id."'",1);
			if($res['dist_name']!='') return $res['dist_name'];
			else return "";
	}
	function get_school_dist_id($school_id)
	{
		$res=parent::selectData(TABLE_SCHOOL,"sch_dist_id","sch_id='".$school_id."' and sch_status='Active'",1);
		if($res['sch_dist_id']!='') return $res['sch_dist_id'];
		else return "0";
	}
	function get_school_block_id($school_id)
	{
		$res=parent::selectData(TABLE_SCHOOL,"sch_blk_id","sch_id='".$school_id."' and sch_status='Active'",1);
		if($res['sch_blk_id']!='') return $res['sch_blk_id'];
		else return "0";
	}
	
	function get_dseo_by_dist_id($dist_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"fullname","status='Active' and admin_type='1' and dist_id='".$dist_id."'",1);
		if(isset($res['fullname'])) return $res['fullname'];
		else "";
	}
	
	function get_dist_user_fullname($dist_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"fullname","status='Active' and id='".$dist_id."'",1);
		if(isset($res['fullname'])) return $res['fullname'];
		else "";
	}		
	
	function get_dseo_id_by_dist($dist_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"id","status='Active' and admin_type='1' and dist_id='".$dist_id."'",1);
		if(isset($res['id'])) return $res['id'];
		else "";
	}
		
	function get_sdseo_by_dist_id($dist_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"fullname","status='Active' and admin_type='3' and dist_id='".$dist_id."'",1);
		if(isset($res['fullname'])) return $res['fullname'];
		else "";
	}	
	
	function get_sdseo_id_by_dist_block($dist_id,$blk_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"id","status='Active' and admin_type='3' and dist_id='".$dist_id."' and blck_id like '%,".$blk_id.",%'",1);
		if(isset($res['id'])) return $res['id'];
		else "";
	}	
	function show_drop_down_admintype($selVal)
	{
		$str.= "<option value=''>--Select District--</option>";
		$res=parent::selectData(TABLE_ADMIN_TYPE,"","status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['id']."'";
			if($row['id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['title']."</option>";
		}
		return $str;		
	}
	function show_drop_down_admintype_sanction_received($selVal)
	{
		$str.= "<option value=''>--Select Head--</option>";
		$res=parent::selectData(TABLE_ADMIN_TYPE,"","status='Active' and id>7","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['id']."'";
			if($row['id']==$selVal)
			{
				$str.=' selected';
			}
			$str.=">".$row['title']."</option>";
		}
		return $str;		
	}
	
	function show_drop_down_block($dist,$selVal='')
	{
		$str = "";
		$str.= "<option value=''>--Select Block--</option>";
		$res=parent::selectData(TABLE_BLOCK,"","dist_id='".$dist."' and blk_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['blk_id']."'";
			
			if(strpos($selVal,","))
			{
				$selValarr=explode(",",$selVal);
				if(in_array($row['blk_id'],$selValarr))
				{
				$str.=' selected';
				}
			}
			else
			{
				if($row['blk_id']==$selVal)
				{
					$str.=' selected';
				}
			}
			//if($selVal==$row['blk_id']) $str.= " selected";
			
			$str.=">".$row['blk_name']."</option>";
		}
		return $str;
	}

function show_drop_down_my_block($dist,$selVal='',$admin_user)
	{
		$where = "";
		if($admin_user!="")
		{			
			$my_blocks = trim($this->get_my_blockid($admin_user),",");
			if($my_blocks!="") $where = " and blk_id in (".$my_blocks.")";
			else $where = " and blk_id in (0)";
		}

$str = "";
		$selVals = array();
		if($selVal!="") $selVals = explode(",",trim($selVal,","));
		$str.= "<option value=''>--Select Block--</option>";
		$res=parent::selectData(TABLE_BLOCK,"","dist_id='".$dist."' and blk_status='Active' ".$where,"");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['blk_id']."' ";
			
			if(in_array($row['blk_id'],$selVals)) $str.=  "selected";
			
			$str.=" >".$row['blk_name']."</option>";
		}
		return $str;		
	}
	
	function get_block_name($blk_id)
	{
		$res=parent::selectData(TABLE_BLOCK,""," blk_id='".$blk_id."'",1);
			if($res['blk_id']!='') return $res['blk_name'];
			else return "";
	}
	function show_drop_down_school($dist_id='',$block='', $school='')
	{
		$str = "";
		$where = '1';
		if(isset($dist_id) && $dist_id!='') $where .= " and sch_dist_id='".$dist_id."'";
		if(isset($block) && $block!='') $where .= " and sch_blk_id='".$block."'";
		$str.= "<option value=''>--Select School--</option>";		
		$res=parent::selectData(TABLE_SCHOOL,"",$where." and sch_status='Active'");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['sch_id']."'";
			if($row['sch_id'] == $school) $str.= "selected";
			$str.=">".$row['sch_name']."</option>";
		}
		return $str;		
	}
	
	function show_dist_drop_down_school($dist_id='',$block='', $school='',$admin_user_id,$daType)
	{
		$str = "";
		$where = '1';
		$process= "";		
		
		$admin_type = $_SESSION['adminuser']['admin_type'];
		$adminType = parent::selectData(TABLE_ADMIN_TYPE,"","id='".$admin_type."'",1);
		$admin_type_stitle = $adminType['title_short'];
		$admin_type_main = str_replace("DA","",$admin_type_stitle);
		$daType = false;
		if($admin_type_stitle!=$admin_type_main) $daType = true;
		$dseo = false;

if($admin_type_main=='DSEO') $dseo = true;

if($daType==true) $process = $this->get_my_processid($admin_user_id);
		else if($dseo) $process = ",3,4,7,8,";
		else $process = ",1,2,5,6,";
		if($process=="") $process = "0";
		$processes = explode(",",trim($process,","));		
		$extra = "";
		for($i=0;isset($processes[$i]);$i++)
		{
			$extra .= " procl_id like '%,".$processes[$i].",%' or";
		}
		$extra = " and (".rtrim($extra,"or")." )";
		if(isset($dist_id) && $dist_id!='') $where .= " and sch_dist_id='".$dist_id."'";
		if(isset($block) && $block!='') $where .= " and sch_blk_id='".$block."'";
		$str.= "<option value=''>--Select School--</option>";		
		$res=parent::selectData(TABLE_SCHOOL,"",$where." and sch_status='Active' ".$extra);
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['sch_id']."'";
			if($row['sch_id'] == $school) $str.= "selected";
			$str.=">".$row['sch_name']."</option>";
		}
		return $str;		
	}
	
	function IsSchoolMapped($schl_id)
	{
		//echo parent::selectData(TABLE_SCHOOL_MAP,"count(*) counter","sch_id='".$schl_id."' and status='Active'",2);
		$data=parent::selectData(TABLE_SCHOOL_MAP,"count(*) counter","sch_id='".$schl_id."' and status='Active'",1);
		if($data['counter']>0)
			return true;
		else
			return false;
	}
	function IsTeacherMapped($teach_id)
	{
		//echo parent::selectData(TABLE_SCHOOL_MAP,"count(*) counter","sch_id='".$schl_id."' and status='Active'",2);
		$data=parent::selectData(TABLE_SCHOOL_TEACHER_MAP,"count(*) counter","teacher_id='".$teach_id."' and status='Active'",1);
		if($data['counter']>0)
			return true;
		else
			return false;
	}
	function show_drop_down_tagging_category($selVal='')
	{
		$str = "";
		$str.= "<option value=''>--Select Status--</option>";
		$res=parent::selectData(TABLE_TEACHER_EMP_STATUS,"","empstat_id IN(3,4,5,6) and empstat_status='Active'","");
		while($row=mysqli_fetch_array($res))
		{
			$str.="<option value='".$row['empstat_id']."'";
			
			if($selVal==$row['empstat_id']) $str.= " selected";
			
			$str.=">".$row['empstat_title']."</option>";
		}
		return $str;		
	}	
		
	function get_my_processid($admin_user_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"prcl_id","status='Active' and id='".$admin_user_id."'",1);
		if($res['prcl_id']!='') return $res['prcl_id'];
		else return "";
	}
	
	function get_my_blockid($admin_user_id)
	{
		$res=parent::selectData(TABLE_ADMIN_USER,"blck_id","status='Active' and id='".$admin_user_id."'",1);
		if($res['blck_id']!='') return $res['blck_id'];
		else return "";
	}
	
	function get_teacher_name($teach_id)
	{
		$res=parent::selectData(TABLE_TEACHER,"","teach_id='".$teach_id."'",1);
		if($res['teach_id']!='') return $res['teach_first_name']." ".$res['teach_middle_name']." ".$res['teach_last_name'];
		else return "";
	}
	
	function display_salary_budget_status($bugt_id)
	{
			$status = "";
			$budgetD = parent::selectData(TABLE_SALARY_BUDGET,"","bugts_id='".$bugt_id."'",1);
			
			//if($budgetD['bugts_fwd_1']=='DSEO') $fwdedby = "Budget is seen by Dealing Assistant";
			//else $fwdedby = $budgetD['bugts_fwd_1'];
			
		if($budgetD['bugts_status'] == 'UP') 
			$status = "Budget is uploaded";
		else if($budgetD['bugts_status']=='FWD' && ($budgetD['bugts_fwd_1'] == 'SDSEO' || $budgetD['bugts_fwd_1'] == 'DSEO' || $budgetD['bugts_fwd_1'] == 'DSEL') &&  $budgetD['bugts_fwd_1_status']=='W' &&  $budgetD['bugts_up_by']=='SC') 
			$status = "Budget is submitted by school";
			
		else if($budgetD['bugts_status']=='FWD' && ($budgetD['bugts_fwd_1'] == 'SDSEO' || $budgetD['bugts_fwd_1'] == 'DSEO') &&  $budgetD['bugts_fwd_1_status']=='S') 
			$status = "Budget is seen by Dealing Assistant";		
			
		else if($budgetD['bugts_status']=='FWD' && ($budgetD['bugts_fwd_1'] == 'SDSEO' || $budgetD['bugts_fwd_1'] == 'DSEO') &&  $budgetD['bugts_fwd_1_status']=='V') 
			$status = "Budget is verified by Dealing Assistant";	
			
		else if($budgetD['bugts_status']=='FWD' && (($budgetD['bugts_fwd_1'] == 'DSEL' && $budgetD['bugts_fwd_1_status']=='S') || ($budgetD['bugts_fwd_2'] == 'DSEL' && $budgetD['bugts_fwd_2_status']=='S'))  ) 	        	
		     $status = "Budget is seen by Dealing Assistant (State)";	
				
		else if($budgetD['bugts_status']=='FWD' && ($budgetD['bugts_fwd_1'] == 'SDSEO' || $budgetD['bugts_fwd_1'] == 'DSEO') &&  $budgetD['bugts_fwd_1_status']=='F' ) 
			$status = "Budget is submitted by ".$budgetD['bugts_fwd_1'];	
				
				
		else if($budgetD['bugts_status']=='FA') $status = "Budget is verified by State";
		else if($budgetD['bugts_status']=='FR') $status = "Resubmission of School Budget <a href='javascript:void(0)' onClick='resubmit_reason(".$bugt_id.")'><i class='fa fa-question-circle' aria-hidden='true'></i></a>";
		
		return $status;
	}
	
	
	function display_expense_budget_status($bugt_id)
	{
			$status = "";
			$budgetD = parent::selectData(TABLE_EXPENSE_BUDGET,"","bugte_id='".$bugt_id."'",1);
			
			//if($budgetD['bugte_fwd_1']=='DSEO') $fwdedby = "Budget is seen by Dealing Assistant";
			//else $fwdedby = $budgetD['bugte_fwd_1'];
			
		if($budgetD['bugte_status'] == 'UP') 
			$status = "Budget is uploaded";
			
		else if($budgetD['bugte_status']=='FWD' && ($budgetD['bugte_fwd_1'] == 'SDSEO' || $budgetD['bugte_fwd_1'] == 'DSEO' || $budgetD['bugte_fwd_1'] == 'DSEL') &&  $budgetD['bugte_fwd_1_status']=='W' &&  $budgetD['bugte_up_by']=='SC') 
			$status = "Budget is submitted by school";
			
		else if($budgetD['bugte_status']=='FWD' && ($budgetD['bugte_fwd_1'] == 'SDSEO' || $budgetD['bugte_fwd_1'] == 'DSEO') &&  $budgetD['bugte_fwd_1_status']=='S') 
			$status = "Budget is seen by Dealing Assistant";		
			
		else if($budgetD['bugte_status']=='FWD' && ($budgetD['bugte_fwd_1'] == 'SDSEO' || $budgetD['bugte_fwd_1'] == 'DSEO') &&  $budgetD['bugte_fwd_1_status']=='V') 
			$status = "Budget is verified by Dealing Assistant";	
				
		else if($budgetD['bugte_status']=='FWD' && ($budgetD['bugte_fwd_1'] == 'SDSEO' || $budgetD['bugte_fwd_1'] == 'DSEO') &&  $budgetD['bugte_fwd_1_status']=='F' ) 
			$status = "Budget is submitted by ".$budgetD['bugte_fwd_1'];	
				
		else if($budgetD['bugte_status']=='FWD' && ($budgetD['bugte_fwd_2'] == 'DSEL' || $budgetD['bugte_fwd_1'] == 'DSEL') &&  $budgetD['bugte_fwd_1_status']=='S') 	        	
		     $status = "Budget is seen by State";
				
		else if($budgetD['bugte_status']=='FA') $status = "Budget is verified by State";
		else if($budgetD['bugte_status']=='FR') $status = "Resubmission of School Budget <a href='javascript:void(0)' onClick='resubmit_reason_e(".$bugt_id.")'><i class='fa fa-question-circle' aria-hidden='true'></i></a>";
		
		return $status;
	}
	
	
	function display_salary_funds_status($funda_id )
	{
			$status = "";
			$fundsD = parent::selectData(TABLE_FUNDS_APPLY,"","funda_id ='".$funda_id ."'",1);
			
			//if($fundsD['bugts_fwd_1']=='DSEO') $fwdedby = "Budget is seen by Dealing Assistant";
			//else $fwdedby = $fundsD['bugts_fwd_1'];
			
		if($fundsD['funda_status'] == 'UP') 
			$status = "Fund Requirement is uploaded";
		else if($fundsD['funda_status']=='FWD' && ($fundsD['funda_fwd_1'] == 'SDSEO' || $fundsD['funda_fwd_1'] == 'DSEO' || $fundsD['funda_fwd_1'] == 'DSEL') &&  $fundsD['funda_fwd_1_status']=='W' &&  $fundsD['funda_up_by']=='SC') 
			$status = "Fund Requirement is submitted by school";
			
		else if($fundsD['funda_status']=='FWD' && ($fundsD['funda_fwd_1'] == 'SDSEO' || $fundsD['funda_fwd_1'] == 'DSEO') &&  $fundsD['funda_fwd_1_status']=='V') 
			$status = "Fund Requirement is verified by Dealing Assistant";	
			
		else if($fundsD['funda_status']=='FWD' && (($fundsD['funda_fwd_1'] == 'DSEL' && $fundsD['funda_fwd_1_status']=='S') || ($fundsD['funda_fwd_2'] == 'DSEL' && $fundsD['funda_fwd_2_status']=='S'))  ) 	        	
		     $status = "Fund Requirement is seen by Dealing Assistant (State)";	
				
		else if($fundsD['funda_status']=='FWD' && ($fundsD['funda_fwd_1'] == 'SDSEO' || $fundsD['funda_fwd_1'] == 'DSEO') &&  $fundsD['funda_fwd_1_status']=='F' ) 
			$status = "Fund Requirement is submitted by ".$fundsD['funda_fwd_1'];	
				
				
		else if($fundsD['funda_status']=='FA') $status = "Fund Requirement is verified by State";
		else if($fundsD['funda_status']=='FR') $status = "Resubmission of Fund Requirement <a href='javascript:void(0)' onClick='resubmit_reason(".$funda_id.")'><i class='fa fa-question-circle' aria-hidden='true'></i></a>";
		
		return $status;
	}
	
	function display_expense_funds_status($funda_id )
	{
			$status = "";
			$fundsD = parent::selectData(TABLE_FUNDE_APPLY,"","funda_id ='".$funda_id ."'",1);
			
			//if($fundsD['bugts_fwd_1']=='DSEO') $fwdedby = "Budget is seen by Dealing Assistant";
			//else $fwdedby = $fundsD['bugts_fwd_1'];

if($fundsD['funda_status'] == 'UP') 
			$status = "Fund Requirement is uploaded";
		else if($fundsD['funda_status']=='FWD' && ($fundsD['funda_fwd_1'] == 'SDSEO' || $fundsD['funda_fwd_1'] == 'DSEO' || $fundsD['funda_fwd_1'] == 'DSEL') &&  $fundsD['funda_fwd_1_status']=='W' &&  $fundsD['funda_up_by']=='SC') 
			$status = "Fund Requirement is submitted by school";
			
		else if($fundsD['funda_status']=='FWD' && $fundsD['funda_fwd_1'] != 'DSEL' &&  $fundsD['funda_fwd_1_status']=='A') 
			$status = "Fund Requirement is verified by Dealing Assistant";	
			
		else if($fundsD['funda_status']=='FWD' && (($fundsD['funda_fwd_1'] == 'DSEL' && $fundsD['funda_fwd_1_status']=='S') || ($fundsD['funda_fwd_2'] == 'DSEL' && $fundsD['funda_fwd_2_status']=='S'))  ) 	        	
		     $status = "Fund Requirement is seen by Dealing Assistant (State)";	
				
		else if($fundsD['funda_status']=='FWD' && ($fundsD['funda_fwd_1'] == 'SDSEO' || $fundsD['funda_fwd_1'] == 'DSEO') &&  $fundsD['funda_fwd_1_status']=='F' ) 
			$status = "Fund Requirement is submitted by ".$fundsD['funda_fwd_1'];	
				
				
		else if($fundsD['funda_status']=='FA') $status = "Fund Requirement is verified by State";
		else if($fundsD['funda_status']=='FR') $status = "Resubmission of Fund Requirement <a href='javascript:void(0)' onClick='resubmit_reason(".$funda_id.")'><i class='fa fa-question-circle' aria-hidden='true'></i></a>";
		
		return $status;
	}
	
	function get_my_fund_processed($bprocess,$qtr,$finy)
	{
		$fund_ids = "";
		$sql_fundA = parent::selectData(TABLE_CONESANC_APPLY,"","procl_id='".$bprocess."' and finy_id='".$finy."' and qtr_id='".$qtr."' and ces_status!='FR' and ces_type='S'","","");
		 while($data_fundA = mysqli_fetch_array($sql_fundA))
		 {
		 	$fund_ids = $fund_ids.",".trim($data_fundA['fund_id'],",");
		 }
		 return trim($fund_ids,",");
	}
	
	function get_my_exp_fund_processed($bprocess,$qtr,$finy)
	{
		$fund_ids = "";
		$sql_fundA = parent::selectData(TABLE_CONESANC_APPLY,"","procl_id='".$bprocess."' and finy_id='".$finy."' and qtr_id='".$qtr."' and ces_status!='FR' and ces_type='E'","","");
		 while($data_fundA = mysqli_fetch_array($sql_fundA))
		 {
		 	$fund_ids = $fund_ids.",".trim($data_fundA['fund_id'],",");
		 }
		 return trim($fund_ids,",");
	}
	
	
	function get_my_esanc_fund_processed($bprocess,$qtr,$finy)
	{
		$fund_ids = "";
		$sql_fundA = parent::selectData(TABLE_ESANC_APPLY,"","procl_id='".$bprocess."' and finy_id='".$finy."' and qtr_id='".$qtr."' and es_status!='FR' and es_type='S'","","");
		 while($data_fundA = mysqli_fetch_array($sql_fundA))
		 {
		 	$fund_ids = $fund_ids.",".trim($data_fundA['fund_id'],",");
		 }
		 return trim($fund_ids,",");
	}
	
	function get_my_esanc_exp_fund_processed($bprocess,$qtr,$finy)
	{
		$fund_ids = "";
		$sql_fundA = parent::selectData(TABLE_ESANC_APPLY,"","procl_id='".$bprocess."' and finy_id='".$finy."' and qtr_id='".$qtr."' and es_status!='FR' and es_type='E'","","");
		 while($data_fundA = mysqli_fetch_array($sql_fundA))
		 {
		 	$fund_ids = $fund_ids.",".trim($data_fundA['fund_id'],",");
		 }
		 return trim($fund_ids,",");
	}
	
	function get_cons_dist_wise_sch_cnt($fund_ids,$dist_id)
	{
		$sqlCFG = parent::selectData(TABLE_FUNDS_APPLY,"count(funda_id) as totalS","funda_id in (".$fund_ids.") and dist_id='".$dist_id."'",1);
		return $sqlCFG['totalS'];
	}
	
	function get_cons_dist_wise_fund_sum($fund_ids,$dist_id,$funda_type)
	{
		if($funda_type=='S') $sqlCFG = parent::selectData(TABLE_FUNDS_APPLY,"sum(funda_amt_total) as totalFA","funda_id in (".$fund_ids.") and dist_id='".$dist_id."'",1);
		if($funda_type=='E') $sqlCFG = parent::selectData(TABLE_FUNDE_APPLY,"sum(funda_amt_total) as totalFA","funda_id in (".$fund_ids.") and dist_id='".$dist_id."'",1);
		return $sqlCFG['totalFA'];
	}
	
	function get_cons_dist_wise_staff_cnt($fund_ids,$dist_id,$funda_type)
	{
		if($funda_type=='S') $sqlCFG = parent::selectData(TABLE_FUNDS_APPLY,"sum(funda_staff_cnt) as totalSC","funda_id in (".$fund_ids.") and dist_id='".$dist_id."'",1);
		if($funda_type=='E') $sqlCFG = parent::selectData(TABLE_FUNDE_APPLY,"sum(funda_staff_cnt) as totalSC","funda_id in (".$fund_ids.") and dist_id='".$dist_id."'",1);
		return $sqlCFG['totalSC'];
	}
	
	function get_school_management($sch_id)
	{
		$dataSch  =  parent::selectData(TABLE_SCHOOL_MAP,"","sch_id='".$sch_id."'",1);
		if(isset($dataSch['mngb_id']) && $dataSch['mngb_id']!='')
		{
			$mngb_id  =  $dataSch['mngb_id'];
			$dataMNG  =  parent::selectData(TABLE_MANAGED_BY,"","mngb_id='".$mngb_id."'",1);
			return $dataMNG['mngb_title'];
		}
		else
		{
			return "";
		}	
	}
	
	function get_school_management_2($sch_id)
	{
		$dataSMAP  =  parent::selectData(TABLE_SCHOOL_MAP,"","sch_id='".$sch_id."'",1);
		if(isset($dataSMAP['mngb_id']) && $dataSMAP['mngb_id']!='')
		{
			$mngb_id  =  $dataSMAP['mngb_id'];
			$dataMNG  =  parent::selectData(TABLE_MANAGED_BY,"","mngb_id='".$mngb_id."'",1);
			return $dataMNG['mngb_title'];
		}	
		else
		{
			return "";
		}	
	}
	
	function cesanc_dist_app_exist_1($cesId,$adminId)
	{		
		 $dataCESD = parent::selectData(TABLE_CONESANC_APPLY_DIST,"","ces_id='".$cesId."' and admin_id_1='".$adminId."'",1);
		 if(isset($dataCESD['cesd_id']) && $dataCESD['cesd_id']!='')
		 {
		 	return $dataCESD['cesd_id'];
		 }
		 else
		 {
		 	return false;
		 }
	}
	
	function cesanc_dist_app_exist_2($cesId,$adminId)
	{		
		 $dataCESD = parent::selectData(TABLE_CONESANC_APPLY_DIST,"","ces_id='".$cesId."' and admin_id_2='".$adminId."'",1);
		 if(isset($dataCESD['cesd_id']) && $dataCESD['cesd_id']!='')
		 {
		 	return $dataCESD['cesd_id'];
		 }
		 else
		 {
		 	return false;
		 }
	}
	
	function cesanc_dist_app_exist_school($cesId,$sch_id)
	{		
		 $dataCESD = parent::selectData(TABLE_CONESANC_APPLY_DIST,"","ces_id='".$cesId."' and sch_id like '%".$sch_id."%'",1);
		 if(isset($dataCESD['cesd_id']) && $dataCESD['cesd_id']!='')
		 {
		 	return $dataCESD['cesd_id'];
		 }
		 else
		 {
		 	return false;
		 }
	}
	
		function show_drop_down_hra_cat($selVal='')
		{
			$str = "<option value=''> Select HRA Category</option>";
			$res=parent::selectData(TABLE_HRA_CAT,"","hrac_status='Active'","","hrac_id asc");
			while($row=mysqli_fetch_array($res))
			{
				$str.="<option value='".$row['hrac_id']."'";
				if($row['hrac_id']==$selVal)
				{
					$str.=' Selected="Selected"';
				}
				$str.=">".$row['hrac_title']."</option>";
			}
			return $str;		
		}
		
		function get_hra_cat($hrac_id)
		{
			$res=parent::selectData(TABLE_HRA_CAT,"","hrac_id='".$hrac_id."'",1);
			if($res['hrac_id']!='') return $res['hrac_title']."";
		}
		
		
		function show_drop_down_cpf($selVal='')
		{
			$str = "<option value=''> Select CPF</option>";
			$res=parent::selectData(TABLE_CPF,"","cpf_status='Active'","","cpf_id asc");
			while($row=mysqli_fetch_array($res))
			{
				$str.="<option value='".$row['cpf_id']."'";
				if($row['cpf_id']==$selVal)
				{
					$str.=' Selected="Selected"';
				}
				$str.=">".$row['cpf_title']."</option>";
			}
			return $str;		
		}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: class_gen_function.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation