$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";
}
