Gecko [ 43.229.15.234 ]

Name	Size	Permission
atpaper1	[ DIR ]	drwxr-xr-x
atpaper2	[ DIR ]	drwxr-xr-x
atpaper3	[ DIR ]	drwxr-xr-x
postingrecord.php	7.16 KB	-rw-r--r--
postingrecord_editor.php	7.72 KB	-rw-r--r--
postingrecord_list.php	7.4 KB	-rw-r--r--
view.php	3.71 KB	-rw-r--r--

Code Editor : postingrecord.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": 
		  
			if(!empty($_REQUEST["id"])){
				// prepare and bind for Maximum Number
				$stmt = $conn->prepare("SELECT * FROM postingrecord WHERE id = ?");
				$stmt->bind_param("i",$_REQUEST["id"]);
				$stmt->execute();

//Result
				$result = $stmt->get_result();						
				while($row = $result->fetch_assoc()){
					$atpaper1 = $row["atpaper1"];	
					$atpaper2 = $row["atpaper2"];
					$atpaper3 = $row["atpaper3"];									
				}
			}

// prepare and bind for Maximum Number
			$stmt = $conn->prepare("SELECT IFNULL(max(id),0)+1 AS id FROM postingrecord");		
			$stmt->execute();

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

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

if(empty($_REQUEST["id"]))
				{
					//Data Insert
					$stmt = $conn->prepare("INSERT INTO postingrecord (GovtId,postingtype_id,office_id,plocattion,
																	   stratDate,endDate,payscal_id,userinfo_id,
																	   postcomments,atpaper1,atpaper2,atpaper3)
					                        VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"); 
                    $stmt->bind_param("siisssiissss", $_SESSION["pimsid"],
			                                $_REQUEST["postingtype_id"],
			                                $_REQUEST["office_id"],
			                                $_REQUEST["plocattion"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["stratDate"])))),
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["endDate"])))),
											$_REQUEST["payscal_id"],
											$_SESSION["user_id"],
											$_REQUEST["postcomments"],
											$atpaper1,
											$atpaper2,
											$atpaper3
			                                );
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					//Data Update
					$stmt = $conn->prepare("UPDATE postingrecord SET 
														    postingtype_id = ?,
															office_id = ?,
															plocattion = ?,
															stratDate = ?,
															endDate = ?,
															payscal_id = ?,
															postcomments=?,
															atpaper1=?,
															atpaper2=?,
															atpaper3=?	 WHERE id = ?");
					$stmt->bind_param("iisssissssi", 
			                                $_REQUEST["postingtype_id"],
			                                $_REQUEST["office_id"],
			                                $_REQUEST["plocattion"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["stratDate"])))),
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["endDate"])))),
			                                $_REQUEST["payscal_id"],
											$_REQUEST["postcomments"],			                               
											$atpaper1,
											$atpaper2,
											$atpaper3,
											$_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../postingrecord/postingrecord.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM postingrecord 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"];
						$GovtId = $row["GovtId"];
						$postingtype_id = $row["postingtype_id"];
						$office_id = $row["office_id"];
						$plocattion = $row["plocattion"];						
						$stratDate = ddateremove($row["stratDate"]);
						$endDate = ddateremove($row["endDate"]);
						$payscal_id = $row["payscal_id"];
						$postcomments = $row["postcomments"];

$atpaper1 = $row["atpaper1"];
						$atpaper2 = $row["atpaper2"];
						$atpaper3 = $row["atpaper3"];
						
					}					
					$stmt->close();	
			    }
						   
				include("../postingrecord/postingrecord_editor.php");						  
				break;
						   
         case "delete": 
				$Id               = $_REQUEST["id"];				
								
				if($Id)
				{
					//$db->delete($info);
				}
				include("../postingrecord/postingrecord_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("../postingrecord/postingrecord_list.php");
				break; 
        case "search_postingrecord":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../postingrecord/postingrecord_list.php");
				break;  								   
						
	     default :    
		       include("../postingrecord/postingrecord_editor.php");		         
	   }

${this.title}

Code Editor : postingrecord.php