Gecko [ 43.229.15.234 ]

Name	Size	Permission
promotion.php	5.11 KB	-rw-r--r--
promotion_editor.php	10.24 KB	-rw-r--r--
promotion_list.php	7.86 KB	-rw-r--r--
view.php	5.03 KB	-rw-r--r--

Code Editor : promotion.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"]))
				{
					//Data Insert
					$stmt = $conn->prepare("INSERT INTO promotion (GovtId,designation_id,experiance,pexampass_id,apointDate,pscrecom_id,pscDate,sarokNo,permDate,sgrade_id,timesDate,selectiongrade_id,userinfo_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
                    $stmt->bind_param("sisisisssisii", $_SESSION["pimsid"],
			                                $_REQUEST["designation_id"],
			                                $_REQUEST["experiance"],
			                                $_REQUEST["pexampass_id"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["apointDate"])))),
			                                $_REQUEST["pscrecom_id"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["pscDate"])))),
			                                $_REQUEST["sarokNo"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["permDate"])))),
			                                $_REQUEST["sgrade_id"],
											date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["timesDate"])))),
											$_REQUEST["selectiongrade_id"],
											$_SESSION["user_id"]
			                                );
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					//Data Update
					$stmt = $conn->prepare("UPDATE promotion SET 
														 designation_id = ?, experiance = ?, pexampass_id = ?, apointDate = ?, pscrecom_id = ?, pscDate = ?, sarokNo = ?, permDate = ?, sgrade_id = ?, timesDate = ?, selectiongrade_id=?	 WHERE id = ?");
					$stmt->bind_param("isisisssisii", 
			                                $_REQUEST["designation_id"],
			                                $_REQUEST["experiance"],
			                                $_REQUEST["pexampass_id"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["apointDate"])))),
			                                $_REQUEST["pscrecom_id"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["pscDate"])))),
			                                $_REQUEST["sarokNo"],
			                                date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["permDate"])))),
			                                $_REQUEST["sgrade_id"],
											date("Y-m-d", strtotime(str_replace("/","-",englishnum($_REQUEST["timesDate"])))),
											$_REQUEST["selectiongrade_id"],
			                                $_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../promotion/promotion.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM promotion 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"];
						$designation_id = $row["designation_id"];
						$experiance = $row["experiance"];
						$pexampass_id = $row["pexampass_id"];						
						$apointDate = date("d/m/Y", strtotime(str_replace("-","/",$row["apointDate"])));
						$pscrecom_id = $row["pscrecom_id"];
						$pscDate = date("d/m/Y", strtotime(str_replace("-","/",$row["pscDate"])));
						$sarokNo = $row["sarokNo"];
						$permDate = date("d/m/Y", strtotime(str_replace("-","/",$row["permDate"])));
						$selectiongrade_id = $row["selectiongrade_id"];
						$sgrade_id = $row["sgrade_id"];
						$timesDate = date("d/m/Y", strtotime(str_replace("-","/",$row["timesDate"])));
						
					}					
					$stmt->close();	
			    }
						   
				include("../promotion/promotion_editor.php");						  
				break;
						   
         case "delete": 
				$Id               = $_REQUEST["id"];				
								
				if($Id)
				{
					//$db->delete($info);
				}
				include("../promotion/promotion_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("../promotion/promotion_list.php");
				break; 
        case "search_promotion":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../promotion/promotion_list.php");
				break;  								   
						
	     default :    
		       include("../promotion/promotion_editor.php");		         
	   }

${this.title}

Code Editor : promotion.php