Gecko [ 43.229.15.234 ]

Name	Size	Permission
general.php	20.15 KB	-rw-r--r--
general_editor.php	42.88 KB	-rw-r--r--
general_list.php	11.47 KB	-rw-r--r--

Code Editor : general.php

<?php
       session_start();
       include("../common/config.php");
	   include("../common/functions.php");
	   
	  if(empty($_SESSION["username"])) 
	   {
	     Header("Location: ../login/login.php");
	    }

$cmd = $_REQUEST['cmd'];
	   switch($cmd)
	   {
	     
		  case 'add': 
		  
			// prepare and bind for Maximum Number
			$stmt = $conn->prepare("SELECT IFNULL(max(id),0)+1 AS id FROM general");
			$stmt->execute();

//Result
			$result = $stmt->get_result();	
			$numrows=$result->num_rows;
			
			while($row = $result->fetch_assoc()){ $max = $row[id];}	
			   if($numrows==0) {$max=0;}	
   
			//Photo File   
			if(strlen($_FILES['photo']['name'])>0 && $_FILES['photo']['size']>0)
			{
				
				if(!file_exists("general/photo"))
				{ 
				   mkdir("general/photo",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['photo']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['photo']['name'])));
				}
				$filePath="general/photo/".$file;
				move_uploaded_file($_FILES['photo']['tmp_name'],$filePath);
			   $photo="general/photo/".trim($file);
			 }

//Finger Print    
			if(strlen($_FILES['FringerTham']['name'])>0 && $_FILES['FringerTham']['size']>0)
			{
				
				if(!file_exists("general/FringerTham"))
				{ 
				   mkdir("general/FringerTham",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['FringerTham']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['FringerTham']['name'])));
				}
				$filePath="general/FringerTham/".$file;
				move_uploaded_file($_FILES['FringerTham']['tmp_name'],$filePath);
			   $FringerTham="general/FringerTham/".trim($file);
			 }

//Signataure   
			if(strlen($_FILES['SignetureSample']['name'])>0 && $_FILES['SignetureSample']['size']>0)
			{
				
				if(!file_exists("general/SignetureSample"))
				{ 
				   mkdir("general/SignetureSample",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['SignetureSample']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['SignetureSample']['name'])));
				}
				$filePath="general/SignetureSample/".$file;
				move_uploaded_file($_FILES['SignetureSample']['tmp_name'],$filePath);
			   $SignetureSample="general/SignetureSample/".trim($file);
			 }

//delcrearation   
			if(strlen($_FILES['delcrearation']['name'])>0 && $_FILES['delcrearation']['size']>0)
			{
				
				if(!file_exists("general/delcrearation"))
				{ 
				   mkdir("general/delcrearation",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['delcrearation']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['delcrearation']['name'])));
				}
				$filePath="general/delcrearation/".$file;
				move_uploaded_file($_FILES['delcrearation']['tmp_name'],$filePath);
			   $delcrearation="general/delcrearation/".trim($file);
			 }

//ExpectedLastSal   
			if(strlen($_FILES['ExpectedLastSal']['name'])>0 && $_FILES['ExpectedLastSal']['size']>0)
			{
				
				if(!file_exists("general/ExpectedLastSal"))
				{ 
				mkdir("general/ExpectedLastSal",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				$file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['ExpectedLastSal']['name'])));
				}
				else
				{
				$file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['ExpectedLastSal']['name'])));
				}
				$filePath="general/ExpectedLastSal/".$file;
				move_uploaded_file($_FILES['ExpectedLastSal']['tmp_name'],$filePath);
		 	$ExpectedLastSal="general/ExpectedLastSal/".trim($file);
			}

if (strlen($max)==1)
			{
				$GovtId="00000".$max;
			}
			if (strlen($max)==2)
			{
				$GovtId="0000".$max;
			}
			if (strlen($max)==3)
			{
				$GovtId="000".$max;
			}
			if (strlen($max)==4)
			{
				$GovtId="00".$max;
			}
			if (strlen($max)==5)
			{
				$GovtId="0".$max;
			}

if(empty($_SESSION["pimsid"]))
			{
				$_SESSION["pimsid"]=$GovtId;
			}

if(empty($_REQUEST['id']))
				{
					
					$stmt = $conn->prepare("INSERT INTO general ( 
														photo,
														GovtId,		
														NameB,		
														NameE,		
														FatherB,		
														FatherE,		
														MotherB,		
														MotherE,		
														NationalID,		
														PassportNo,		
														PassIssueDate,		
														PassLastDate,		
														dob,		
														BirthCertificateNo,		
														PersonalEmail,		
														OfficialEmail,		
														district_id,		
														designation_id,		
														office_id,		
														CaderName,		
														CaderDate,		
														BatchNo,		
														FredomFighter_id,		
														FredomChildGrand_id,		
														triballist_id,		
														sex_id,		
														MaritualStatus_id,		
														religion_id,		
														profsubject_id,		
														grade_id,		
														CurrScale_id,		
														SalBasic,															
														ProjectName,		
														emptype_id,		
														FirstJoinDate,		
														EedJoinDate,		
														EedCDJoinDate,		
														CLJoinDate,		
														PLJoindate,		
														RegularDate,		
														PermanentDate,		
														GovtResident_id,		
														LprDate,		
														LprDesignation_id,		
														AnutoshikClass,															
														Teliphone_id,		
														ElectricityBill_id,		
														Vhechilefair_id,		
														HouseRent_id,		
														delcrearation,		
														ExpectedLastSal,		
														VheInfo_id,		
														FringerTham,															
														SignetureSample,
														userinfo_id,
														emptypenow_id															
														) 
														VALUES 
														(?,		
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,
														?,														
														?,
														?,
														?,
														?)");
					$stmt->bind_param("ssssssssssssssssiiisssiiiiiiiiidsisssssssisisiiiississii", 
														$photo,
														$GovtId,
														$_REQUEST['NameB'],
														$_REQUEST['NameE'],
														$_REQUEST['FatherB'],
														$_REQUEST['FatherE'],
														$_REQUEST['MotherB'],
														$_REQUEST['MotherE'],
														$_REQUEST['NationalID'],
														$_REQUEST['PassportNo'],
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassIssueDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassLastDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['dob'])))),
														$_REQUEST['BirthCertificateNo'],
														$_REQUEST['PersonalEmail'],
														$_REQUEST['OfficialEmail'],
														$_REQUEST['district_id'],
														$_REQUEST['designation_id'],
														$_REQUEST['office_id'],
														$_REQUEST['CaderName'],
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CaderDate'])))),													
														$_REQUEST['BatchNo'],
														$_REQUEST['FredomFighter_id'],
														$_REQUEST['FredomChildGrand_id'],
														$_REQUEST['triballist_id'],
														$_REQUEST['sex_id'],
														$_REQUEST['MaritualStatus_id'],
														$_REQUEST['religion_id'],
														$_REQUEST['profsubject_id'],
														$_REQUEST['grade_id'],
														$_REQUEST['CurrScale_id'],
														englishnum($_REQUEST['SalBasic']),													
														$_REQUEST['ProjectName'],
														$_REQUEST['emptype_id'],
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['FirstJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedCDJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CLJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PLJoindate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['RegularDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PermanentDate'])))),
														$_REQUEST['GovtResident_id'],
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['LprDate'])))),
														$_REQUEST['LprDesignation_id'],
														$_REQUEST['AnutoshikClass'],														
														$_REQUEST['Teliphone_id'],
														$_REQUEST['ElectricityBill_id'],
														$_REQUEST['Vhechilefair_id'],
														$_REQUEST['HouseRent_id'],
														$delcrearation,
														$ExpectedLastSal,
														$_REQUEST['VheInfo_id'],
														$FringerTham,														
														$SignetureSample,
														$_SESSION["user_id"],
														$_REQUEST["emptypenow_id"]
									  );
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					$stmt = $conn->prepare("UPDATE general SET 	photo = ?,															
																NameB = ?,
																NameE = ?,
																FatherB = ?,
																FatherE = ?,
																MotherB = ?,
																MotherE = ?,
																NationalID = ?,
																PassportNo = ?,
																PassIssueDate = ?,
																PassLastDate = ?,
																dob = ?,
																BirthCertificateNo = ?,
																PersonalEmail = ?,
																OfficialEmail = ?,
																district_id = ?,
																designation_id = ?,
																office_id = ?,
																CaderName = ?,
																CaderDate = ?,
																BatchNo = ?,
																FredomFighter_id = ?,
																FredomChildGrand_id = ?,
																triballist_id = ?,
																sex_id = ?,
																MaritualStatus_id = ?,
																religion_id = ?,
																profsubject_id = ?,
																grade_id = ?,
																CurrScale_id = ?,
																SalBasic = ?,															
																ProjectName = ?,
																emptype_id = ?,
																FirstJoinDate = ?,
																EedJoinDate = ?,
																EedCDJoinDate = ?,
																CLJoinDate = ?,
																PLJoindate = ?,
																RegularDate = ?,
																PermanentDate = ?,
																GovtResident_id = ?,
																LprDate = ?,
																LprDesignation_id = ?,
																AnutoshikClass = ?,																
																Teliphone_id = ?,
																ElectricityBill_id = ?,
																Vhechilefair_id = ?,
																HouseRent_id = ?,
																delcrearation = ?,
																ExpectedLastSal = ?,
																VheInfo_id = ?,
																FringerTham = ?,																
																SignetureSample = ?,
																emptypenow_id = ?
															 WHERE id = ?");
					$stmt->bind_param("sssssssssssssssiiisssiiiiiiiiidsisssssssisisiiiississii", 
					$photo,				
					$_REQUEST['NameB'],
					$_REQUEST['NameE'],
					$_REQUEST['FatherB'],
					$_REQUEST['FatherE'],
					$_REQUEST['MotherB'],
					$_REQUEST['MotherE'],
					$_REQUEST['NationalID'],
					$_REQUEST['PassportNo'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassIssueDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassLastDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['dob'])))),
					$_REQUEST['BirthCertificateNo'],
					$_REQUEST['PersonalEmail'],
					$_REQUEST['OfficialEmail'],
					$_REQUEST['district_id'],
					$_REQUEST['designation_id'],
					$_REQUEST['office_id'],
					$_REQUEST['CaderName'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CaderDate'])))),					
					$_REQUEST['BatchNo'],
					$_REQUEST['FredomFighter_id'],
					$_REQUEST['FredomChildGrand_id'],
					$_REQUEST['triballist_id'],
					$_REQUEST['sex_id'],
					$_REQUEST['MaritualStatus_id'],
					$_REQUEST['religion_id'],
					$_REQUEST['profsubject_id'],
					$_REQUEST['grade_id'],
					$_REQUEST['CurrScale_id'],
					englishnum($_REQUEST['SalBasic']),					
					$_REQUEST['ProjectName'],
					$_REQUEST['emptype_id'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['FirstJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedCDJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CLJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PLJoindate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['RegularDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PermanentDate'])))),
					$_REQUEST['GovtResident_id'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['LprDate'])))),				
					$_REQUEST['LprDesignation_id'],
					$_REQUEST['AnutoshikClass'],				
					$_REQUEST['Teliphone_id'],
					$_REQUEST['ElectricityBill_id'],
					$_REQUEST['Vhechilefair_id'],
					$_REQUEST['HouseRent_id'],
					$delcrearation,
					$ExpectedLastSal,
					$_REQUEST['VheInfo_id'],
					$FringerTham,				
					$SignetureSample,
					$_REQUEST['emptypenow_id'],
					$_REQUEST['id']);
					
					
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../generaladmin/general.php?cmd=list");		   
				break;    
		case "edit":      
				
			    $Id               = $_REQUEST['id'];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM general WHERE id = ?");
					$stmt->bind_param("i",$_REQUEST["id"]);
					$stmt->execute();
					
					//Result
					$result = $stmt->get_result();
					
					//Data Retriving
					while($row = $result->fetch_assoc()) {
						$id = $row['id'];
						$photo = $row['photo'];					
						$NameB = $row['NameB'];
						$NameE = $row['NameE'];
						$FatherB = $row['FatherB'];
						$FatherE = $row['FatherE'];
						$MotherB = $row['MotherB'];
						$MotherE = $row['MotherE'];
						$NationalID = $row['NationalID'];
						$PassportNo = $row['PassportNo'];
						$PassIssueDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['PassIssueDate']))));						
						$PassLastDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['PassLastDate']))));						
						$dob=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['dob']))));					
						$BirthCertificateNo = $row['BirthCertificateNo'];
						$PersonalEmail = $row['PersonalEmail'];
						$OfficialEmail = $row['OfficialEmail'];
						$district_id = $row['district_id'];
						$designation_id = $row['designation_id'];
						$office_id = $row['office_id'];
						$CaderName = $row['CaderName'];
						$CaderDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['CaderDate']))));					
						$BatchNo = $row['BatchNo'];
						$FredomFighter_id = $row['FredomFighter_id'];
						$FredomChildGrand_id = $row['FredomChildGrand_id'];
						$triballist_id = $row['triballist_id'];
						$sex_id = $row['sex_id'];
						$MaritualStatus_id = $row['MaritualStatus_id'];
						$religion_id = $row['religion_id'];
						$profsubject_id = $row['profsubject_id'];
						$grade_id = $row['grade_id'];
						$CurrScale_id = $row['CurrScale_id'];
						$SalBasic = $row['SalBasic'];					
						$ProjectName = $row['ProjectName'];
						$emptype_id = $row['emptype_id'];
						$FirstJoinDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['FirstJoinDate']))));						
						$EedJoinDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['EedJoinDate']))));						
						$EedCDJoinDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['EedCDJoinDate']))));						
						$CLJoinDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['CLJoinDate']))));						
						$PLJoindate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['PLJoindate']))));					
						$RegularDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['RegularDate']))));						
						$PermanentDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['PermanentDate']))));						
						$GovtResident_id = $row['GovtResident_id'];
						$LprDate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['LprDate']))));						
						$LprDesignation_id = $row['LprDesignation_id'];
						$AnutoshikClass = $row['AnutoshikClass'];						
						$Teliphone_id = $row['Teliphone_id'];
						$ElectricityBill_id = $row['ElectricityBill_id'];
						$Vhechilefair_id = $row['Vhechilefair_id'];
						$HouseRent_id = $row['HouseRent_id'];
						$delcrearation = $row['delcrearation'];
						$ExpectedLastSal = $row['ExpectedLastSal'];
						$VheInfo_id = $row['VheInfo_id'];
						$FringerTham = $row['FringerTham'];						
						$SignetureSample = $row['SignetureSample'];
						$emptypenow_id = $row['emptypenow_id'];
						
								  
					}					
					$stmt->close();

}
						   
				include("../generaladmin/general_editor.php");						  
				break;
						   
         case 'delete': 
				$Id               = $_REQUEST['id'];
				
				$info['table']    = "general";
				$info['where']    = "id='$Id'";
				
				if($Id)
				{
					//$db->delete($info);
				}
				include("../generaladmin/general_list.php");						   
				break; 
						   
         case "list" :    	 
			  if(!empty($_REQUEST['page'])&&$_SESSION["search"]=="yes")
				{
				  $_SESSION["search"]="yes";
				}
				else
				{
				   $_SESSION["search"]="no";
				   unset($_SESSION["search"]);
				   unset($_SESSION["field_value"]); 
				}
				include("../generaladmin/general_list.php");
				break; 
		case "allemp" :    	 
			if(!empty($_REQUEST['page'])&&$_SESSION["search"]=="yes")
				{
				$_SESSION["search"]="yes";
				}
				else
				{
					$_SESSION["search"]="no";
					unset($_SESSION["search"]);
					unset($_SESSION["field_value"]); 
				}
				include("../generaladmin/general_allemp.php");
				break; 
		case "search_allemp":
			$_REQUEST['page'] = 1;  
			$_SESSION["search"]="yes";
			$_SESSION["field_value"] = $_REQUEST['field_value'];				
			include("../generaladmin/general_allemp.php");
			break;  
        case "search_general":
				$_REQUEST['page'] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST['field_value'];				
				include("../generaladmin/general_list.php");
				break;  								   
						
	     default :    
		       include("../generaladmin/general_editor.php");		         
	   }

${this.title}

Code Editor : general.php