"> </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">