">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Leader</label>
<div class="col-sm-5">
<select name="leader" id="inputLeader" class="form-control" required="required">
<option value="<?php
echo $dx['USER_DETAIL_ID'];
?>
"><?php
echo data_user_detail($udi, 'FIRSTNAME');
?>
<?php
echo data_user_detail($udi, 'LASTNAME');
?>
</option>
<?php
$q = mysql_query("select ud.guid,firstname,lastname from user_detail ud\n\t \t\t\t\t\tjoin ms_group mg\n\t \t\t\t\t\tjoin member_of_group mog\n\t \t\t\t\t\ton ud.guid=mog.user_detail_id\n\t \t\t\t\t\tand mg.guid=mog.ms_group_id\n\t \t\t\t\t\twhere mg.group_name='LCU'\n\t \t\t\t\t\tand ud.guid not in(\n\t \t\t\t\t\t\tselect user_detail_id from unit_leader\n\t \t\t\t\t\t)");
while ($d = mysql_fetch_array($q)) {
?>
<option value="<?php
echo $d['guid'];
?>
"><?php
echo $d['firstname'];
?>
<?php
echo $d['lastname'];
?>
mysql_query("update internship_registration set DTMUPD=now(), USRUPD='" . $_SESSION['username'] . "', STATUS='REJECTED', UNIT_ID='{$unitid}' where GUID='" . $rijek[$y] . "'");
// untuk surat
// ambil unit LCU
$_idunit = ambildata($_SESSION['iddetail'], 'USER_DETAIL', 'UNIT_ID');
$kodeunit = getdata('unit', "GUID='61ddb5a0-7d01-11e5-8cd3-28d244bd1b19'", 'UNIT_CODE');
// urutan surat
$qus = mysql_query("select urut+1 as urut from letter order by urut desc limit 1");
$dqus = mysql_fetch_array($qus);
$nomorurut = $dqus['urut'];
// nomor surat
$nomorsurat = "{$kodeunit}/{$nomorurut}/" . date('Y');
// input ke table LETTER
mysql_query("insert into letter(GUID,NOMOR,IR_ID,JENIS,DTMCRT,USRCRT) values(uuid(),'{$nomorsurat}','" . $rijek[$y] . "','REJECTED',now(),'" . $_SESSION['firstname'] . "')");
// untuk email
$_SESSION['namanya'] = data_user_detail($iduserdetail[$y], "FIRSTNAME") . " " . data_user_detail($iduserdetail[$y], "LASTNAME");
$_SESSION['emailnya'] = data_user_detail($iduserdetail[$y], "EMAIL");
include 'email/rejection.php';
}
}
}
// konfirmasi kalau quota sudah habis
if ($dcq[$qw] == '0') {
eksyen('Sorry! Your weekly quota is up', "?p=intern_pending");
}
eksyen('Saved!', 'home.php#internship');
}
?>
<form action="" method="post">
<table class="table table-condensed" id="tbl">
<thead>
<tr>
// 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>
<?php
echo tabel();
?>
<table class="table table-condensed" id="tbl">
<thead>
<li class="left clearfix"><span class="chat-img pull-left">
<img src="tampil.php?u=<?php
echo $d['SENDER_ID'];
?>
" width="50" alt="<?php
echo data_user_detail($d['SENDER_ID'], "FIRSTNAME");
?>
" class="img-circle" />
</span>
<div class="chat-body clearfix">
<div class="header">
<strong class="primary-font"><?php
echo data_user_detail($d['SENDER_ID'], "FIRSTNAME");
?>
<?php
echo data_user_detail($d['SENDER_ID'], "LASTNAME");
?>
</strong> <small class="pull-right text-muted">
<span class="glyphicon glyphicon-time"></span><?php
echo time_ago($d['DTMCRT']);
?>
</small>
</div>
<p>
<?php
echo $d['MESSAGE'];
?>
</p>
</div>
</li>
<?php
<?php
if (isset($_GET['i'])) {
$i = $_GET['i'];
$q = mysql_query("select * from guestbook where GUID='{$i}'");
$d = mysql_fetch_array($q);
} else {
eksyen('', 'home.php');
}
if (isset($_POST['subjek'])) {
$_SESSION['emailnya'] = $d['EMAIL'];
$_SESSION['namanya'] = $d['FIRSTNAME'];
$_SESSION['judulnya'] = mysql_real_escape_string($_POST['subjek']);
$_SESSION['teks'] = mysql_real_escape_string($_POST['teks']);
$_SESSION['namap'] = $_SESSION['firstname'];
$_SESSION['emailp'] = data_user_detail($_SESSION['iddetail'], 'EMAIL');
mysql_query("update guestbook set REPLY='1' where GUID='{$i}'");
require 'email/guestbook.php';
eksyen('Email sent!', 'home.php#comment');
}
?>
<h1>Reply Guestbook</h1>
<div class="col-md-8">
<form action="" method="POST" role="form">
<div class="form-group">
<label for="subjek">Email Subject</label>
<input type="text" class="form-control" id="subjek" name="subjek" placeholder="Email Subject" required>
</div>
<div class="form-group">
