Booking-Management-Software/call.php at main · adilk121/Booking-Management-Software · GitHub

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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php require_once("includes/dbsmain.inc.php"); ?>


<?php
if(isset($_REQUEST['emp_dept'])){
$data=db_query("select emp_name from tbl_emp where 1 and emp_dpt='$_REQUEST[emp_dept]' and emp_status='WORKING' ");
?>
<select  name="emp_under" title="Choose employee TL" style="width:183px;padding:3px;"  required="" >
<option>Choose From <?=$_REQUEST['emp_dept']?></option>
<?
if(mysql_num_rows($data)>0){
while($record=mysql_fetch_array($data)){?>
<option><?=$record['emp_name']?></option>
<? }
}else{?>
<option>None</option>
<? }?>
</select>


<?
}


if(isset($_REQUEST['q'])){


$data=db_query("select * from tbl_emp where 1 and emp_name like '$_REQUEST[q]%' ");
if(mysql_num_rows($data)>0){
echo "<ul id='sugg_list' style='list-style-type:none;display:block;'>";
while($record=mysql_fetch_array($data)){
?>
<li onClick="fill_val('<?=$record['emp_name']?>' ,<?=$record['emp_id']?>,'<?=$_REQUEST['f']?>','<?=$_REQUEST['dn']?>')"><?=$record['emp_name']?> </li>

<?
}
}
}
?>
</ul>


<?php

if(isset($_REQUEST['emp_q'])){


$data=db_query("select * from tbl_emp where 1 and emp_name like '$_REQUEST[emp_q]%' ");
if(mysql_num_rows($data)>0){


echo "<ul id='sugg_list' style='list-style-type:none;display:block;'>";
while($record=mysql_fetch_array($data)){
//echo $record['emp_name']."<br />".$record['emp_code']."<br />".$record['emp_dpt']."<br />".$record['emp_desination'];
?>
<li onClick="fill_val('<?=$record['emp_name']?>' ,<?=$record['emp_id']?>,'<?=$_REQUEST['f']?>','<?=$_REQUEST['dn']?>','<?=$record['emp_code']?>','<?=$record['emp_dpt']?>','<?=$record['emp_desination']?>',<?=$record['emp_salary']?>)" >
<?=$record['emp_name']?> &nbsp; &nbsp; <span style='color:#000000;font-weight:300;float:right;'>[ <?="WKN00".$record['emp_code']?> ] </span>
</li>

<?
}
}
}
?>
</ul>