-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSelectYear.php
More file actions
32 lines (31 loc) · 2.63 KB
/
SelectYear.php
File metadata and controls
32 lines (31 loc) · 2.63 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?php
require_once('AdminUser/config/config.php');
if(isset($_POST['idA']) && $_POST['idA']!=""){ $Yid = $_POST['idA'];
if($Yid==1){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company1Status='A'", $con);}
elseif($Yid==2){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company2Status='A'", $con);}
elseif($Yid==3){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company3Status='A'", $con);}
elseif($Yid==4){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company4Status='A'", $con);}
elseif($Yid==5){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company5Status='A'", $con);}
elseif($Yid==6){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company6Status='A'", $con);}
elseif($Yid==7){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company7Status='A'", $con);}
elseif($Yid==8){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company8Status='A'", $con);}
elseif($Yid==9){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company9Status='A'", $con);}
elseif($Yid==10){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company10Status='A'", $con);}
if($Yid>0) {$res = mysql_fetch_assoc($sql); }
if($Yid>0) { echo date("Y",strtotime($res['FromDate'])).' to '.date("Y",strtotime($res['ToDate'])); } else {echo '';}
}
elseif(isset($_POST['idE']) && $_POST['idE']!=""){ $Yid = $_POST['idE'];
if($Yid==1){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company1Status='A'", $con);}
elseif($Yid==2){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company2Status='A'", $con);}
elseif($Yid==3){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company3Status='A'", $con);}
elseif($Yid==4){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company4Status='A'", $con);}
elseif($Yid==5){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company5Status='A'", $con);}
elseif($Yid==6){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company6Status='A'", $con);}
elseif($Yid==7){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company7Status='A'", $con);}
elseif($Yid==8){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company8Status='A'", $con);}
elseif($Yid==9){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company9Status='A'", $con);}
elseif($Yid==10){$sql = mysql_query("SELECT FromDate,ToDate FROM hrm_year where Company10Status='A'", $con);}
if($Yid>0) {$res = mysql_fetch_assoc($sql); }
if($Yid>0) { echo date("Y",strtotime($res['FromDate'])).' to '.date("Y",strtotime($res['ToDate'])); } else {echo '';}
}
?>