<tr>
<td colspan="2"></td>
<td><input name="Cek" type="submit" value="Cek" id="ceks">
</td>
</tr>
</table>
</form>
<br>
<?php
#cek date button
#===============================================================
if (isset($_POST['Cek'])) {
$tanggaltujuanpost = tglSQL2($_POST['tanggal']);
$tanggaltujuan = new DateTime($_POST['tanggal']);
$tanggalsekarang = new DateTime();
#cek tanggal tukar
#========================================
if ($tanggaltujuan >= $tanggalsekarang) {
$diff = $tanggaltujuan->diff($tanggalsekarang);
#cek tanggal tukar lebih dari toleransi hari dari hari ini
#==================================================
if ($diff->days >= $_SESSION['toleransi']) {
#cek status message
#=========================================
$status = mysql_query("SELECT a.*, b.username FROM mdl_message a INNER JOIN mdl_user b ON a.useridfrom=b.id WHERE a.useridfrom='" . $_SESSION['user_id'] . "' AND a.message='request'");
if (mysql_num_rows($status) !== 0) {
echo "<center>jika ingin membatalkan pertukaran silahkan klik ";
?>
echo " <b>" . $hal . "</b> ";
} else {
echo " <a href='" . $_SERVER['PHP_SELF'] . "?page=datauser&hal=" . $hal . "'>" . $hal . "</a> ";
}
$showhal = $hal;
}
}
// menampilkan link next
if ($nohal < $jumhal) {
echo "<a href='" . $_SERVER['PHP_SELF'] . "?page=datauser&hal=" . ($nohal + 1) . "'>Next >></a>";
}
echo '</div>';
} else {
if (isset($_POST['cek'])) {
if (!empty($_POST['tanggal']) || !empty($_POST['urutan'])) {
$tanggal = tglSQL2($_POST['tanggal']);
$urutan = $_POST['urutan'];
$showhal = '';
// jumlah data yang akan ditampilkan per halaman
$dataPerhal = 10;
// apabila $_GET['hal'] sudah didefinisikan, gunakan nomor halaman tersebut,
// sedangkan apabila belum, nomor halamannya 1.
if (isset($_GET['hal'])) {
$nohal = $_GET['hal'];
} else {
$nohal = 1;
}
// perhitungan offset
$offset = ($nohal - 1) * $dataPerhal;
// query SQL untuk menampilkan data perhalaman sesuai offset
$query = mysql_query("SELECT *,DATE(uploaddate)as tanggal,TIME(uploaddate) as jam from mdl_user WHERE DATE(uploaddate)='{$tanggal}' AND role=6 AND uploadnumber='{$urutan}' order by uploaddate desc, uploadnumber asc LIMIT {$offset}, {$dataPerhal} ");
