$namapembuat = ''; $stry = "select namauser from " . $dbname . ".user where karyawanid=" . $bar->user; $resy = mysql_query($stry); while ($bary = mysql_fetch_object($resy)) { $namapembuat = $bary->namauser; } //====================ambil username posting $namaposting = 'Not Posted'; if (intval($bar->postedby) != 0) { $stry = "select namauser from " . $dbname . ".user where karyawanid=" . $bar->postedby; $resy = mysql_query($stry); while ($bary = mysql_fetch_object($resy)) { $namaposting = $bary->namauser; } } if ($namaposting == 'Not Posted' && $bar->post == 1) { $namaposting = " Posted By ???"; } if ($bar->post < 1) { //tambahkan tombol edit dan delete $add = "  <img src=images/application/application_delete.png class=resicon title='delete' onclick=\"delBapb('" . $bar->notransaksi . "');\">"; // $add.="<img src=images/application/book_icon.gif class=resicon title='Post/Close' onclick=\"postingBapb('".$bar->notransaksi."','".$bar->nopo."');\">"; } else { $add = ''; } echo "<tr class=rowcontent>\r\n\t <td>" . $no . "</td>\r\n\t <td>" . $bar->kodegudang . "</td>\r\n\t <td title=\"1=Masuk,2=Pengembalian pengeluaran, 3=penerimaan mutasi,5=Pengeluaran,6=Pengembalian penerimaan,7 pengeluaran mutasi\">" . getDetailTipeMutasi($bar->tipetransaksi) . "</td>\r\n\t <td>" . $bar->notransaksi . "</td>\r\n\t <td>" . tanggalnormal($bar->tanggal) . "</td>\r\n\t <td>" . $bar->kodept . "</td>\r\n\t <td>" . $bar->nopo . "</td>\t\r\n\t <td>" . $bar->idsupplier . "</td> \r\n\t <td>" . $namapembuat . "</td>\r\n\t <td>" . $namaposting . "</td>\r\n\t <td align=center>\r\n\t " . $add . "\r\n\t <img src=images/pdf.jpg class=resicon title='" . $_SESSION['lang']['pdf'] . "' onclick=\"previewBapb('" . $bar->notransaksi . "',event);\"> \r\n\t </td>\r\n\t </tr>"; } echo "<tr><td colspan=11 align=center>\r\n " . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "\r\n\t <br>\r\n <button class=mybutton onclick=cariBapb(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n\t <button class=mybutton onclick=cariBapb(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n\t </td>\r\n\t </tr>"; } else { echo " Error: Transaction Period missing"; }
$page = $_POST['page']; if ($page < 0) { $page = 0; } } $offset = $page * $limit; $str = "select * from " . $dbname . ".log_transaksiht where kodegudang='" . $gudang . "'\r\n\t\t" . $add . "\r\n\t\tand post=0\r\n\t\torder by tanggal asc,notransaksi asc limit " . $offset . ",20"; $res = mysql_query($str); $no = $page * $limit; while ($bar = mysql_fetch_object($res)) { $no += 1; //===================smbil nama supplier $namasupplier = $bar->idsupplier; $strx = "select namasupplier from " . $dbname . ".log_5supplier where supplierid='" . $bar->idsupplier . "'"; $resx = mysql_query($strx); while ($barx = mysql_fetch_object($resx)) { $namasupplier = $barx->namasupplier; } //====================ambil username pembuat $namapembuat = ''; $stry = "select namauser from " . $dbname . ".user where karyawanid=" . $bar->user; $resy = mysql_query($stry); while ($bary = mysql_fetch_object($resy)) { $namapembuat = $bary->namauser; } echo "<tr class=rowcontent id=indukrow" . $no . ">\r\n\t <td>" . $no . "</td>\r\n\t <td>" . $bar->kodegudang . "</td>\r\n\t <td title=\"1=Masuk,2=Pengembalian pengeluaran, 3=penerimaan mutasi,5=Pengeluaran,6=Pengembalian penerimaan,7 pengeluaran mutasi\">" . getDetailTipeMutasi($bar->tipetransaksi) . "</td>\r\n\t <td>" . $bar->notransaksi . "</td>\r\n\t <td>" . tanggalnormal($bar->tanggal) . "</td>\r\n\t <td>" . $bar->kodept . "</td>\r\n\t <td>" . $bar->nopo . "</td>\t\r\n\t <td>" . $namasupplier . "</td> \r\n\t <td>" . $bar->gudangx . "</td> \r\n\t <td>" . $bar->notransaksireferensi . "</td>\t \t \r\n\t <td>" . $namapembuat . "</td>\r\n\t <td align=center>\r\n <button class=mybutton onclick=\"previewPosting(" . $bar->tipetransaksi . ",'" . $bar->notransaksi . "','" . $gudang . "',event);\">" . $_SESSION['lang']['proses'] . "</button>\r\n\t </td>\r\n\t </tr>"; } echo "<tr><td colspan=11 align=center>\r\n " . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "\r\n\t <br>\r\n <button class=mybutton onclick=cariUnconfirmed(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n\t <button class=mybutton onclick=cariUnconfirmed(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n\t </td>\r\n\t </tr>"; } else { echo " Error: Transaction Period missing"; }
} else { $no += 1; $add = '86'; $status = $_SESSION['lang']['sudahditerima']; //continue; } } } } else { if ($bar->post != 0) { $no += 1; //jika sudah di post oleh sumber maka dapat diterima //karena setelah posting baru ada hargasatuan $add = " <img src=images/application/application_go.png class=resicon title='Process' onclick=\"processReceipt('" . $bar->notransaksi . "');\">"; } else { $no += 1; $add = " "; } } $sSj = "select distinct nosj from " . $dbname . ".log_suratjalandt where notransaksireferensi='" . $bar->notransaksi . "'"; $qSj = mysql_query($sSj) or die(mysql_error($conn)); $rSj = mysql_fetch_object($qSj); if ($add != '86') { //menampilkan yang belum diterima saja echo "<tr " . $trHide . " class=rowcontent>\n\t\t\t <td>" . $no . "</td>\n\t\t\t <td>" . $bar->kodegudang . "</td>\n\t\t\t <td title=\"1=Masuk,2=Pengembalian pengeluaran, 3=penerimaan mutasi,5=Pengeluaran,6=Pengembalian penerimaan,7 pengeluaran mutasi\">" . getDetailTipeMutasi($bar->tipetransaksi) . "</td>\n\t\t\t <td>" . (isset($rSj->nosj) ? $rSj->nosj : '') . "</td>\n\t\t\t <td>" . $bar->notransaksi . "</td>\n\t\t\t <td>" . tanggalnormal($bar->tanggal) . "</td>\n\t\t\t <td>" . $bar->kodept . "</td>\n\t\t\t <td>" . $bar->gudangx . "</td>\t\t\t \n\t\t\t <td>" . $namapembuat . "</td>\n\t\t\t <td>" . $namaposting . "</td>\n\t\t\t <td>" . $status . "</td>\n\t\t\t <td align=center>\n\t\t\t\t " . $add . "\n\t\t\t\t <img src=images/pdf.jpg class=resicon title='" . $_SESSION['lang']['pdf'] . "' onclick=\"previewMutasi('" . $bar->notransaksi . "',event);\"> \n\t\t\t </td>\n\t\t\t </tr>"; } } echo "<tr><td colspan=11 align=center>\n\t\t" . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "\n\t\t<br>\n\t\t<button class=mybutton onclick=cariBast(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\n\t\t<button class=mybutton onclick=cariBast(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\n\t\t</td>\n\t\t</tr>"; } else { echo " Error: Transaction Period missing"; }