/
intern.php
117 lines (113 loc) · 4.55 KB
/
intern.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
<?php
// cek kondisi start/finish
if(isset($_GET['a']) and isset($_GET['x']))
{
$idinter = $_GET['i'];
$aksi = $_GET['a'];
$auth = $_GET['x'];
$idhash = md5($idinter);
// cek kesamaan auth dan idhash
if($idhash != $auth)
{
eksyen('No Trespassing!','?p=intern');
}
else
{
if($aksi == md5("start"))
{
mysql_query("update internship_registration set STATUS='IN PROGRESS', DTMUPD=now(), USRUPD='".$_SESSION['firstname']."' where GUID='$idinter'");
eksyen('It is starting!','?p=intern');
}
elseif($aksi == md5("finish"))
{
// update status internship
mysql_query("update internship_registration set STATUS='DONE', DTMUPD=now(), USRUPD='".$_SESSION['firstname']."' where GUID='$idinter'");
// update quota
$dq = mysql_query("select * from internship_registration where GUID='$idinter'");
$ddq = mysql_fetch_array($dq);
$idtopik = $ddq['MASTER_TOPIC_ID'];
$weeksekarang = findweek(date('d'),'long');
$angkaweek = findweek(date('d'),'short');
$bln = date('m');
$thn = date('Y');
$qw = getdata("quota","TOPIC_ID='$idtopik' and YEAR='$thn' and MONTH='$bln'","WEEK".$angkaweek);
$sql = "update quota set ".$weeksekarang."='$qw'+1 where TOPIC_ID='$idtopik' and YEAR='$thn' and MONTH='$bln'";
mysql_query($sql);
// kirim email finish
$_SESSION['namanya'] = data_user_detail($ddq['USER_DETAIL_ID'],"FIRSTNAME");
$_SESSION['emailnya'] = data_user_detail($ddq['USER_DETAIL_ID'],"EMAIL");
include 'email/finish.php';
eksyen('It is finished! ','?p=intern');
}
else
{
eksyen('No Trespassing!','?p=intern');
}
}
}
?>
<h1>Internship History</h1>
<?=tabel();?>
<table class="table table-condensed" id="tbl">
<thead>
<tr>
<th class="col-md-1 text-center">No</th>
<th class="col-md-2 text-center">Nama</th>
<th class="col-md-2 text-center">Program</th>
<th class="text-center">Topik/Referensi</th>
<th class="col-md-2 text-center">Periode</th>
<th class="col-md-1 text-center">Status</th>
<th class="col-md-2 text-center">Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
if($_SESSION['grup']=="LCU"){
$id = $_SESSION['iddetail'];
$unitid = ambildata($id,'user_detail','UNIT_ID');
$q = mysql_query("select * from internship_registration where UNIT_ID='$unitid' order by DTMUPD desc");
}elseif($_SESSION['grup']=="ADMIN"){
$q = mysql_query("select * from internship_registration order by DTMUPD desc");
}
while($d = mysql_fetch_array($q)){
?>
<tr>
<td class="text-center">
<?=$i;?>
<input type="hidden" name="iduserdetail[]" id="inputIduserdetail" class="form-control" value="<?=$d['USER_DETAIL_ID'];?>">
</td>
<td class="text-center"><?=ambildata($d['USER_DETAIL_ID'],'user_detail','FIRSTNAME');?></td>
<td class="text-center"><?=ambildata($d['PROGRAM_ID'],'internship_program','PROGRAM');?></td>
<td class="text-center">
<?php
$pr = ambildata($d['PROGRAM_ID'],'internship_program','PROGRAM');
if($pr == "Magang Industri"){
echo ambildata($d['INTERNSHIP_PROJECT_ID'],'program','PROGRAM_NAME');
}else{
echo ambildata($d['MASTER_TOPIC_ID'],'master_topic','TOPIC_NAME');
}
?>
</td>
<td class="text-center"><?=$d['START_DATE'];?> / <?=$d['END_DATE'];?></td>
<td class="text-center"><?=$d['STATUS'];?></td>
<td class="text-center">
<div class="btn-group btn-group-justified" role="group" aria-label="...">
<a href="?p=intern_detail&i=<?=$d['GUID'];?>" class="btn btn-info btn-sm" title="Internship Detail">Detail</a>
<?php if($_SESSION['grup']=="LCU"){ ?>
<?php if($d['STATUS']=="APPROVED"){ ?>
<a href="?p=intern&i=<?=$d['GUID'];?>&a=<?=md5('start');?>&x=<?=md5($d['GUID']);?>" class="btn btn-primary btn-sm" title="Start Internship" <?=yakin();?>>Start</a>
<?php } ?>
<?php if($d['STATUS']=="IN PROGRESS"){ ?>
<a href="?p=intern_assessment&i=<?=$d['GUID'];?>" class="btn btn-primary btn-sm" title="Fill in the Assessment">Assessment</a>
<?php } ?>
<?php if($d['STATUS']=="FINISHED"){ ?>
<a href="?p=intern&i=<?=$d['GUID'];?>&a=<?=md5('finish');?>&x=<?=md5($d['GUID']);?>" class="btn btn-success btn-sm" title="Finish Internship" <?php if(cektesti($d['GUID'])==FALSE){ echo "disabled"; }else{ echo "/"; } ?>>Finish</a>
<?php } ?>
<?php } ?>
</div>
</td>
</tr>
<?php $i++; } ?>
</tbody>
</table>