$str2 = "select sum(b.jumlah) as jumlah,b.kodebarang FROM " . $dbname . ".log_transaksiht a left join " . $dbname . ".log_transaksidt\n b on a.notransaksi=b.notransaksi where kodept='" . $_SESSION['empl']['kodeorganisasi'] . "' and b.kodebarang='" . $bar->kodebarang . "' \n and a.tipetransaksi>4\n and a.post=0\n group by kodebarang";
$res2 = mysql_query($str2);
while ($bar2 = mysql_fetch_object($res2)) {
$qtynotposted = $bar2->jumlah;
}
if ($qtynotposted == '') {
$qtynotposted = 0;
}
$saldoqty = $saldoqty + $qtynotpostedin - $qtynotposted;
//============================================
if ($bar->inactive == 1) {
echo "<tr bgcolor='red' style='cursor:pointer;' title='Inactive' >";
$bar->namabarang = $bar->namabarang . " [Inactive]";
$bgr = " bgcolor='red'";
} else {
echo "<tr class=rowcontent style='cursor:pointer;' onclick=\"setBrg('" . $bar->kodebarang . "','" . changeKutipChar($bar->namabarang) . "','" . $bar->satuan . "')\" title='Click' >";
}
echo " <td class=firsttd >" . $no . "</td>\n <td>" . $bar->kodebarang . "</td>\n <td>" . $bar->namabarang . "</td>\n <td>" . $bar->satuan . "</td>\n <td align=right>" . number_format($saldoqty, 2, ',', '.') . "</td>\n </tr>";
}
echo "</tbody>\n <tfoot>\n </tfoot>\n </table></div></fieldset>";
} else {
echo " Gagal," . addslashes(mysql_error($conn));
}
break;
case 'formPersetujuan':
$kd = substr($nopp, 17, 2);
$unit = substr($nopp, 15, 4);
/*if($kd!='HO')
{
$str="select distinct a.karyawanid,b.namakaryawan,b.lokasitugas from ".$dbname.".setup_approval a
left join ".$dbname.".datakaryawan b on a.karyawanid=b.karyawanid where
$depan[$bar->kodebarang] = $bar->depan;
$samping[$bar->kodebarang] = $bar->samping;
$atas[$bar->kodebarang] = $bar->atas;
}
//if search text is passing then search the item on given group
$txtfind = isset($_POST['txtcari']) ? trim($_POST['txtcari']) : '';
if (isset($_POST['txtcari']) && $txtfind != '' && $kelompok != 'All') {
$str = "select * from " . $dbname . ".log_5masterbarang where namabarang like '%" . $txtfind . "%' and kelompokbarang='" . $kelompok . "' order by namabarang";
} else {
if (isset($_POST['txtcari']) && $txtfind !== '' && $kelompok == 'All') {
$str = "select * from " . $dbname . ".log_5masterbarang where namabarang like '%" . $txtfind . "%' order by namabarang";
} else {
$str = "select * from " . $dbname . ".log_5masterbarang where kelompokbarang='" . $kelompok . "' order by namabarang";
}
}
$res = mysql_query($str);
$no = 0;
while ($bar = mysql_fetch_object($res)) {
$stru = "select * from " . $dbname . ".log_5photobarang where kodebarang='" . $bar->kodebarang . "'";
if (mysql_num_rows(mysql_query($stru)) > 0) {
if (empty($spek[$depan[$bar->kodebarang]]) and empty($samping[$bar->kodebarang]) and empty($atas[$bar->kodebarang]) and empty($spek[$bar->kodebarang])) {
$adx = "<img src=images/tool.png class=resicon height=16px title='Edit Detail' onclick=editDetailbarang('" . $bar->kodebarang . "',event)>";
} else {
$adx = "<img src=images/zoom.png class=resicon height=16px title='View detail' onclick=viewDetailbarang('" . $bar->kodebarang . "',event)>\n\t\t\t\t\t<img src=images/tool.png class=resicon height=16px title='Edit Detail' onclick=editDetailbarang('" . $bar->kodebarang . "',event)>";
}
} else {
$adx = "<img src=images/tool.png class=resicon height=16px title='Edit Detail' onclick=editDetailbarang('" . $bar->kodebarang . "',event)>";
}
$no += 1;
echo "<tr class=rowcontent>\n\t\t<td>" . $no . "</td>\n\t\t<td>" . $bar->kelompokbarang . "</td>\n\t\t<td>" . substr($bar->kodebarang, 0, 5) . "</td>\n\t\t<td>" . $bar->kodebarang . "</td>\n\t\t<td>" . $bar->namabarang . "</td>\n\t\t<td>" . $bar->satuan . "</td>\n\t\t<td>" . (isset($spek[$bar->kodebarang]) ? $spek[$bar->kodebarang] : '') . "</td>\n\t\t<td align=right>" . $bar->minstok . "</td>\n\t\t<td>" . $bar->nokartubin . "</td>\n\t\t<td>" . $bar->konversi . "</td>\n\t\t<td align=center><input type=checkbox id='br" . $bar->kodebarang . "' value='" . $bar->kodebarang . "' " . ($bar->inactive == 0 ? "" : " checked") . " onclick=setInactive(this.value);></td>\n\t\t<td align=center>" . $adx . "</td>\n\t\t<td>\n\t\t\t<img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $bar->kelompokbarang . "','" . substr($bar->kodebarang, 0, 5) . "','" . $bar->kodebarang . "','" . changeKutipChar($bar->namabarang) . "','" . $bar->satuan . "','" . $bar->minstok . "','" . $bar->nokartubin . "','" . $bar->konversi . "');\"> \n\t\t\t<img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delBarang('" . $bar->kodebarang . "','" . $bar->kelompokbarang . "');\">\n\t\t</td>\n\t\t</tr>";
}
