/
jobs.php
124 lines (106 loc) · 4.37 KB
/
jobs.php
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php include("header.php");?>
<?php
$registration_id=$_SESSION['registration_id'];
if(!isset($_SESSION['registration_id']) || actor_type($conn,$registration_id)!="S")
header('location:index.php');
?>
<?php include("menu.php");?>
<?php
$result=$conn->query("select F.*, I.* from master_feedback F,job_training_list T where F.registration_id='$registration_id' and F.trainer_id=T.registration_id");
$num=$result->num_rows;
?>
<!-- -------------------------------- container starts ------------------------------ -->
<script src="js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" type="text/css" href="css/jquery.dataTables.min.css"/>
<script type="text/javascript">
$(document).ready(function() {
$('#example').DataTable({
"bLengthChange": false,
"iDisplayLength": 10,
"order": [[0, "desc"]]
});
$('#example1').DataTable({
"bLengthChange": false,
"iDisplayLength": 10,
"order": [[0, "desc"]]
});
});
</script>
<div class="page_title"><span>welcome <?php echo getUserName($conn,$registration_id)?></span></div>
<div class="inner_conainer" >
<?php include("personal_dashboard_link.php");?>
<div class="dashboard_right fade_anim">
<div class="content_head">Company Showing Interest Your Profile</div>
<div class="table_main_other table_job" id="no-more-tables-other">
<div class="clear"></div>
<table class="table-bordered-other table-striped table-condensed-other cf" id="example">
<thead>
<tr>
<th> Date </th>
<th> Job Code </th>
<th> Job Description </th>
<th> Designation</th>
<th> Location</th>
</tr>
</thead>
<tbody>
<?php
$result1=$conn->query("select * from job_student_job_interest where registration_id='$registration_id' and employer_acceptance='Y'");
$num1=$result1->num_rows;
while($row1=$result1->fetch_assoc()){
$post_date=$row1['post_date'];
$date=date('Y-m-d',strtotime($post_date));
?>
<tr>
<td data-title="Date" align="center"><?php echo $date;?></td>
<td data-title="Job Code" align="center"><?php echo getJobDetails($conn,$row1['job_id'],'job_code');?></td>
<td data-title="Job Description" align="center"><?php echo getJobDetails($conn,$row1['job_id'],'job_desc');?></td>
<td data-title="Designation" align="center"><?php echo getJobDetails($conn,$row1['job_id'],'designation');?></td>
<td data-title="Location" align="center"><?php echo getCityName($conn,getJobDetails($conn,$row1['job_id'],'job_location'));?> </td>
</tr>
<?php }?>
</tbody>
</table>
<div class="clear"></div>
</div>
<div class="content_head">Your Interest in jobs</div>
<div class="table_main_other table_job" id="no-more-tables-other">
<div class="clear"></div>
<table class="table-bordered-other table-striped table-condensed-other cf" id="example1">
<thead>
<tr>
<th> Date </th>
<th> Job Code </th>
<th> Job Description </th>
<th> Designation</th>
<th> Location</th>
</tr>
</thead>
<tbody>
<?php
$result=$conn->query("select * from job_student_job_interest where registration_id='$registration_id' and employer_acceptance='P'");
$num=$result->num_rows;
while($row=$result->fetch_assoc()){
$post_date=$row['post_date'];
$date=date('Y-m-d',strtotime($post_date));
?>
<tr>
<td data-title="Date" align="center"><?php echo $date;?></td>
<td data-title="Job Code" align="center"><?php echo getJobDetails($conn,$row['job_id'],'job_code');?></td>
<td data-title="Job Description" align="center"><?php echo getJobDetails($conn,$row['job_id'],'job_desc');?></td>
<td data-title="Designation" align="center"><?php echo getJobDetails($conn,$row['job_id'],'designation');?></td>
<td data-title="Location" align="center"><?php echo getCityName($conn,getJobDetails($conn,$row['job_id'],'job_location'));?> </td>
</tr>
<?php }?>
</tbody>
</table>
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
<div class="clear"></div>
</div>
<!-- -------------------------------- container ends ------------------------------ -->
<?php include("footer.php");?>
</body>
</html>