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