function Header()
{
global $conn;
global $dbname;
global $userid;
global $kdOrg;
global $tgl;
global $akhirY;
global $akhirYline;
$sInduk = "select induk from " . $dbname . ".organisasi where kodeorganisasi='" . $kdOrg . "'";
$qInduk = mysql_query($sInduk) or die(mysql_error());
$rInduk = mysql_fetch_assoc($qInduk);
// $str1="select * from ".$dbname.".organisasi where kodeorganisasi='".$rInduk['induk']."'";
$str1 = "select * from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'";
$res1 = mysql_query($str1);
while ($bar1 = mysql_fetch_object($res1)) {
$nama = $bar1->namaorganisasi;
$alamatpt = $bar1->alamat . ", " . $bar1->wilayahkota;
$telp = $bar1->telepon;
}
$sIsi = "select * from " . $dbname . ".sdm_absensiht where kodeorg='" . $kdOrg . "' and tanggal='" . tanggalsystem($tgl) . "'";
$qIsi = mysql_query($sIsi) or die(mysql_error());
$rIsi = mysql_fetch_assoc($qIsi);
$sOrg = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $rIsi['kodeorg'] . "'";
$qOrg = mysql_query($sOrg) or die(mysql_error());
$rOrg = mysql_fetch_assoc($qOrg);
$path = 'images/logo.jpg';
$this->Image($path, 15, 10, 20);
$this->SetFont('Arial', 'B', 10);
$this->SetFillColor(255, 255, 255);
$this->SetX(40);
$this->Cell(60, 5, $nama, 0, 1, 'L');
$this->SetX(40);
$this->MultiCell(150, 5, $alamatpt, 0);
//$this->Cell(60,5,$alamatpt,0,1,'L');
$this->SetX(40);
$this->Cell(60, 5, "Tel: " . $telp, 0, 1, 'L');
$this->Ln();
$this->SetFont('Arial', 'B', 8);
$this->Cell(20, 5, $nama, '', 1, 'L');
$this->SetFont('Arial', '', 8);
$akhirY = $this->GetY() - 5;
$this->Line(10, $akhirY, 200, $akhirY);
$akhirYline = $this->GetY();
$this->SetY($akhirYline);
$this->Cell(35, 5, $_SESSION['lang']['kodeorg'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(75, 5, $rIsi['kodeorg'], '', 0, 'L');
$this->Cell(25, 5, $_SESSION['lang']['nm_perusahaan'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, $rOrg['namaorganisasi'], 0, 1, 'L');
$this->Cell(35, 5, $_SESSION['lang']['tanggal'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(75, 5, $tgl, '', 0, 'L');
$this->Cell(25, 5, $_SESSION['lang']['periode'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, substr(tanggalnormal($rIsi['periode']), 1, 7), 0, 1, 'L');
$this->Ln();
}
function Header()
{
global $conn;
global $dbname;
global $userid;
global $posting;
global $noKontrak;
global $kodePt;
global $kdBrg;
global $tlgKontrk;
global $kdCust;
global $nmBrg;
global $wilKota;
global $nama;
global $bar;
global $arrStatPPn;
$noKontrak = $_GET['column'];
//$nospb=substr($noSpb,0,4);
$str = "select * from " . $dbname . "." . $_GET['table'] . " where nokontrak='" . $noKontrak . "' ";
//echo $str;exit();
$res = mysql_query($str);
$bar = mysql_fetch_assoc($res);
$kodePt = $bar['kodept'];
$kdBrg = $bar['kodebarang'];
$tlgKontrk = tanggalnormal($bar['tanggalkontrak']);
$kdCust = $bar['koderekanan'];
//echo $posting; exit();
//ambil nama pt
$str1 = "select * from " . $dbname . ".organisasi where kodeorganisasi='" . $kodePt . "'";
$res1 = mysql_query($str1);
while ($bar1 = mysql_fetch_object($res1)) {
$nama = $bar1->namaorganisasi;
$alamatpt = $bar1->alamat . ", " . $bar1->wilayahkota;
$telp = $bar1->telepon;
$wilKota = $bar1->wilayahkota;
}
$sBrg = "select namabarang,kodebarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $kdBrg . "'";
$qBrg = mysql_query($sBrg) or die(mysql_error());
$rBrg = mysql_fetch_assoc($qBrg);
$nmBrg = $rBrg['namabarang'];
/* $path='images/logo.jpg';
$this->Image($path,15,5,40);
$this->SetFont('Arial','B',10);
$this->SetFillColor(255,255,255);
$this->SetX(55);
$this->Cell(60,5,$nama,0,1,'L');
$this->SetX(55);
$this->Cell(60,5,$alamatpt,0,1,'L');
$this->SetX(55);
$this->Cell(60,5,"Tel: ".$telp,0,1,'L');
$this->Line(10,30,200,30);
$this->Ln(10);*/
}
if ($page < 0) {
$page = 0;
}
}
$offset = $page * $limit;
$sql2 = "select count(*) as jmlhrow from " . $dbname . ".sdm_kondisi_prasarana a left join " . $dbname . ".sdm_prasarana b on a.kodeprasarana=b.kodeprasarana where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'\r\n order by tahunperolehan,bulanperolehan desc";
//exit("Error".$sql2);
$query2 = mysql_query($sql2) or die(mysql_error());
while ($jsl = mysql_fetch_object($query2)) {
$jlhbrs = $jsl->jmlhrow;
}
$str = "select a.*,b.jenisprasarana,b.lokasi from " . $dbname . ".sdm_kondisi_prasarana a left join " . $dbname . ".sdm_prasarana b on a.kodeprasarana=b.kodeprasarana where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'\r\n order by tahunperolehan,bulanperolehan desc limit " . $offset . "," . $limit . " ";
$res = mysql_query($str) or die(mysql_error());
while ($bar = mysql_fetch_assoc($res)) {
$no += 1;
echo "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $bar['kodeprasarana'] . "</td>\r\n <td>" . $orgNmKlmpk2[$bar['jenisprasarana']] . "</td>\r\n <td>" . $bar['lokasi'] . "</td>\r\n <td>" . tanggalnormal($bar['tanggal']) . "</td>\r\n <td>" . $bar['kondisi'] . "</td>\r\n <td>" . $arrProgrs[$bar['progress']] . "</td>\r\n <td align=right>" . number_format($bar['jumlah'], 0) . "</td>\r\n <td>" . $arrSat[$bar['jenisprasarana']] . "</td>\r\n <td>\r\n <img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $bar['kodeprasarana'] . "','" . tanggalnormal($bar['tanggal']) . "');\"> \r\n <img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delData('" . $bar['kodeprasarana'] . "','" . tanggalnormal($bar['tanggal']) . "');\">\r\n </td>\r\n </tr>";
}
echo " <tr><td colspan=10 align=center>\r\n " . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "<br />\r\n <button class=mybutton onclick=cariBast2(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n <button class=mybutton onclick=cariBast2(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n </td>\r\n </tr>";
} else {
echo "<tr class=rowcontent><td colspan=10>" . $_SESSION['lang']['dataempty'] . "</td></tr>";
}
break;
case 'update':
if ($kdSarana == '' || $tglKonSarana == '' || $kondId == '' || $idProgress == '') {
echo "warning:Semua Field tidak boleh kosong";
exit;
}
if ($jmlhSarana == '' || $jmlhSarana == '0') {
exit("Error:Jumlah tidak boleh kosong");
}
$sCek2 = "select distinct jumlah,jenisprasarana from " . $dbname . ".sdm_prasarana where kodeprasarana='" . $kdSarana . "'";
$no = 0;
$saldo = $sawal;
$masuk = 0;
$keluar = 0;
while ($barx = mysql_fetch_object($resx)) {
$no += 1;
if ($barx->tipetransaksi < 5) {
$saldo = $saldo + $barx->jumlah;
$masuk = $barx->jumlah;
$keluar = 0;
} else {
$saldo = $saldo - $barx->jumlah;
$keluar = $barx->jumlah;
$masuk = 0;
}
$stream .= " <tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td align=center>" . tanggalnormal($barx->tanggal) . "</td>\r\n <td align=center>" . number_format($sawal, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($sawalrp / $sawal, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($sawalrp, 2, '.', ',') . "</td> \r\n <td align=center>" . number_format($masuk, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($barx->hargasatuan, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($masuk * $barx->hargasatuan, 2, '.', ',') . "</td> \r\n <td align=center>" . number_format($keluar, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($barx->hargarata, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($keluar * $barx->hargarata, 2, '.', ',') . "</td> \r\n <td align=center>" . number_format($saldo, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($barx->hargarata, 2, '.', ',') . "</td>\r\n <td align=center>" . number_format($saldo * $barx->hargarata, 2, '.', ',') . "</td> \r\n </tr>";
$sawal = $saldo;
$sawalrp = $saldo * $barx->hargarata;
}
$stream .= "</table>Print Time:" . date('YmdHis') . "<br>By:" . $_SESSION['empl']['name'];
$nop_ = "ReportBalance";
if (strlen($stream) > 0) {
if ($handle = opendir('tempExcel')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
@unlink('tempExcel/' . $file);
}
}
closedir($handle);
}
$handle = fopen("tempExcel/" . $nop_ . ".xls", 'w');
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $jmlHari;
global $test;
global $klmpkAbsn;
global $tglDari;
global $tglSmp;
$cols = 247.5;
# Alamat & No Telp
$query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
$orgData = fetchData($query);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 15;
$path = 'images/logo.jpg';
$this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(255, 255, 255);
$this->SetX(100);
$this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
$this->SetX(100);
$this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
$this->SetX(100);
$this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
$this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->SetFont('Arial', 'B', 10);
$this->Cell($width, $height, strtoupper("Payroll Remise I"), '', 0, 'C');
$this->Ln();
$this->Cell($width, $height, strtoupper($_SESSION['lang']['tanggal']) . " :" . tanggalnormal($tglDari) . " " . $_SESSION['lang']['sampai'] . " " . tanggalnormal($tglSmp), '', 0, 'C');
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 6);
$this->SetFillColor(220, 220, 220);
$this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(13 / 100 * $width, $height, $_SESSION['lang']['namakaryawan'], 1, 0, 'C', 1);
$this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['tipekaryawan'], 1, 0, 'C', 1);
$this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['gaji'], 1, 0, 'C', 1);
foreach ($test as $ar => $isi) {
$this->Cell(1.5 / 100 * $width, $height, substr($isi, 8, 2), 1, 0, 'C', 1);
$akhirX = $this->GetX();
}
$this->SetY($this->GetY());
$this->SetX($akhirX);
$sAbsen = "select kodeabsen from " . $dbname . ".sdm_5absensi order by kodeabsen";
$qAbsen = mysql_query($sAbsen) or die(mysql_error());
while ($rAbsen = mysql_fetch_assoc($qAbsen)) {
$this->Cell(2 / 100 * $width, $height, $rAbsen['kodeabsen'], 1, 0, 'C', 1);
}
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['total'], 1, 1, 'C', 1);
}
while ($r_realstsdbi = mysql_fetch_assoc($q_realstsdbi)) {
$kodeblok[] = $r_realstsdbi['kdblok'];
$sdbi_realst[$r_realstsdbi['kdblok']] = $r_realstsdbi['realst_sdbi'];
}
# Budget Station SDBI
$s_budstsdbi = "select left(kodeorg,6) as korg,sum(" . $fld_st5 . ") as bgt_st from " . $dbname . ".bgt_budget_detail\r\n where noakun like '632%' and kodeorg like '" . $kdOrg . "%' and tahunbudget='" . substr($periode, 0, 4) . "' \r\n group by left(kodeorg,6)";
//echo $s_budstsdbi;
$q_budstsdbi = mysql_query($s_budstsdbi) or die(mysql_error($conn));
while ($r_budstsdbi = mysql_fetch_assoc($q_budstsdbi)) {
$kode[] = $r_budstsdbi['korg'];
$sdbi_budst[$r_budstsdbi['korg']] = $r_budstsdbi['bgt_st'];
}
if ($proses == 'excel') {
$bgcoloraja = "bgcolor=#DEDEDE ";
$brdr = 1;
$tab .= "\r\n <table>\r\n <tr><td colspan=7 align=center><b>" . $_GET['judul'] . "</b></td></tr>\r\n <tr><td colspan=3 align=left><b>" . $_SESSION['lang']['organisasi'] . " : " . $kdOrg . "</b></td>\r\n <td colspan=4 align=right><b>" . $_SESSION['lang']['periode'] . " : " . substr(tanggalnormal($periode), 1, 7) . "</b></td></tr>\r\n <tr><td colspan=7 align=left> </td></tr>\r\n </table>";
} else {
$brdr = 0;
}
$tab .= "<table cellspacing=1 cellpadding=1 border=" . $brdr . " class=sortable>\r\n\t<thead class=rowheader>";
$tab .= "<tr align=center>";
$tab .= "<td rowspan=2>" . $_SESSION['lang']['uraian'] . "</td>";
$tab .= "<td colspan=3>" . $_SESSION['lang']['bulanini'] . "</td>";
$tab .= "<td colspan=3>" . $_SESSION['lang']['sdbulanini'] . "</td></tr>";
$tab .= "<tr align=center><td>" . $_SESSION['lang']['realisasi'] . "</td><td>" . $_SESSION['lang']['anggaran'] . "</td><td>" . $_SESSION['lang']['selisih'] . "</td>";
$tab .= "<td>" . $_SESSION['lang']['realisasi'] . "</td><td>" . $_SESSION['lang']['anggaran'] . "</td><td>" . $_SESSION['lang']['selisih'] . "</td>";
$tab .= "</tr></thead>";
// $tab.="<tr class=rowcontent>";
// $tab.="<td>".$_SESSION['lang']['tbsdiolah']."</td>";
// $tab.="<td align=right>".number_format($bireal_tbsdiolah,0)."</td>";
// $tab.="<td align=right>".number_format($bibudget_tbsdiolah,0)."</td>";
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $tipeIntex;
global $periode;
global $unit;
global $kdPabrik;
global $tgl_2;
global $tgl_1;
global $tglPeriode;
global $tanggal;
global $rNamaSupp;
$tglPeriode = explode("-", $periode);
$tanggal = $tglPeriode[1] . "-" . $tglPeriode[0];
# Alamat & No Telp
/* $query = selectQuery($dbname,'organisasi','namaorganisasi,alamat,telepon',
"kodeorganisasi='".$kdPt."'");
$orgData = fetchData($query);*/
$sAlmat = "select namaorganisasi,alamat,telepon from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'";
$qAlamat = mysql_query($sAlmat) or die(mysql_error());
$rAlamat = mysql_fetch_assoc($qAlamat);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 11;
$path = 'images/logo.jpg';
$this->Image($path, $this->lMargin, $this->tMargin, 0, 43);
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(255, 255, 255);
$this->SetX(90);
$this->Cell($width - 90, $height, $rAlamat['namaorganisasi'], 0, 1, 'L');
$this->SetX(90);
$this->Cell($width - 90, $height, $rAlamat['alamat'], 0, 1, 'L');
$this->SetX(90);
$this->Cell($width - 90, $height, "Tel: " . $rAlamat['telepon'], 0, 1, 'L');
$this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 11);
$this->Cell($width, $height, $_SESSION['lang']['rPenerimaanTbs'], 0, 1, 'C');
$this->SetFont('Arial', '', 8);
$sNm = "select namasupplier,kodetimbangan from " . $dbname . ".log_5supplier order by namasupplier asc";
$qNm = mysql_query($sNm) or die(mysql_error());
while ($rNm = mysql_fetch_assoc($qNm)) {
$rNamaSupp[$rNm['kodetimbangan']] = $rNm;
}
$sBrg = "select kodebarang,namabarang from " . $dbname . ".log_5masterbarang where kelompokbarang='400'";
$qBrg = mysql_query($sBrg) or die(mysql_error($conn));
while ($rBrg = mysql_fetch_assoc($qBrg)) {
$rNmBrg[$rBrg['kodebarang']] = $rBrg;
}
if ($kdPabrik != '' && $unit != '') {
$this->Cell($width, $height, $_SESSION['lang']['terimaTbs'] . " : " . $kdPabrik . " atas " . $rNmBrg[40000003]['namabarang'] . " " . $_SESSION['lang']['dari'] . " " . $rNamaSupp[$unit]['namasupplier'] . " " . $_SESSION['lang']['periode'] . " :" . $tgl_1 . "-" . $tgl_2, 0, 1, 'C');
} else {
$this->Cell($width, $height, $_SESSION['lang']['terimaTbs'] . " : " . $kdPabrik . " atas " . $rNmBrg[40000003]['namabarang'] . " " . $_SESSION['lang']['dari'] . " : " . $_SESSION['lang']['all'] . ", " . $_SESSION['lang']['periode'] . " :" . tanggalnormal($tgl_1) . " - " . tanggalnormal($tgl_2), 0, 1, 'C');
}
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 5);
$this->SetFillColor(220, 220, 220);
$this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['tanggal'], 1, 0, 'C', 1);
$this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['namasupplier'], 1, 0, 'C', 1);
$this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['noTiket'], 1, 0, 'C', 1);
$this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['kodenopol'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['beratBersih'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['potongankg'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['beratnormal'], 1, 0, 'C', 1);
$this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['sopir'], 1, 0, 'C', 1);
// if($tipeIntex==0)$this->Cell(10/100*$width,$height,$_SESSION['lang']['harga'],1,0,'C',1); else
$this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['nospb'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['jmlhTandan'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['tahuntanam'], 1, 1, 'C', 1);
}
$resx = mysql_query($strx);
while ($barx = mysql_fetch_assoc($resx)) {
$no += 1;
$sKdOrg = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $barx['kodeorg'] . "'";
$qKdOrg = mysql_query($sKdOrg) or die(mysql_error($conn));
$rKdOrg = mysql_fetch_assoc($qKdOrg);
$sKeg = "select kelompok,namakegiatan from " . $dbname . ".setup_kegiatan where kodekegiatan='" . $barx['kodekegiatan'] . "'";
$qKeg = mysql_query($sKeg) or die(mysql_error($conn));
$rKeg = mysql_fetch_assoc($qKeg);
$sCust = "select namacustomer from " . $dbname . ".pmn_4customer where kodecustomer='" . $barx['pembeliluar'] . "'";
$qCust = mysql_query($sCust) or die(mysql_error($conn));
$rCust = mysql_fetch_assoc($qCust);
$sKdOrg2 = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $barx['orgtujuan'] . "'";
$qKdOrg2 = mysql_query($sKdOrg2) or die(mysql_error($conn));
$rKdOrg2 = mysql_fetch_assoc($qKdOrg2);
$stream .= "\t<tr class=rowcontent>\r\n\t\t\t\t\t\t\t<td>" . $no . "</td>\r\n\t\t\t\t\t\t\t<td>" . $barx['notransaksi'] . "</td>\r\n\t\t\t\t\t\t\t<td>" . $rKdOrg['namaorganisasi'] . "</td>\r\n\t\t\t\t\t\t\t<td>" . $rCust['namacustomer'] . "</td>\r\n\t\t\t\t\t\t\t<td>" . $rKdOrg2['namaorganisasi'] . "</td>\r\n\t\t\t\t\t\t\t<td>" . tanggalnormal($barx['tanggal']) . "</td>\r\n\t\t\t\t\t\t\t<td>" . $barx['jenisbibit'] . "</td>\r\n\t\t\t\t\t\t\t<td>" . $barx['jumlah'] . "</td>\t\r\n\t\t\t\t\t\t\t<td>" . $rKeg['kelompok'] . "-" . $rKeg['namakegiatan'] . "</td>\t\r\n\t\t\t\t\t</tr>";
}
}
//echo "warning:".$strx;
//=================================================
$stream .= "</table>Print Time:" . date('YmdHis') . "<br>By:" . $_SESSION['empl']['name'];
$nop_ = "PengirimanBibit";
if (strlen($stream) > 0) {
if ($handle = opendir('tempExcel')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
@unlink('tempExcel/' . $file);
}
}
closedir($handle);
}
if ($res = mysql_query($str)) {
} else {
echo " Gagal," . addslashes(mysql_error($conn));
exit;
}
default:
break;
}
//==============Free
$str1 = "select a.*,b.nama,b.alamat,b.desa,c.namakaryawan from " . $dbname . ".pad_lahan a\r\n left join " . $dbname . ".pad_5masyarakat b on a.pemilik=b.padid \r\n left join " . $dbname . ".datakaryawan c on a.updateby=c.karyawanid \r\n where posting=0 and unit='" . $unit . "' order by b.nama,b.desa limit 500";
if ($res1 = mysql_query($str1)) {
echo "<table class=sortable cellspacing=1 border=0 width=2500px>\r\n <thead>\r\n <tr class=rowheader>\r\n <td style='width:30px;' rowspan=2>*</td> \r\n <td rowspan=2>" . $_SESSION['lang']['id'] . "</td>\r\n <td rowspan=2>" . $_SESSION['lang']['unit'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['pemilik'] . "</td>\r\n <td rowspan=2>" . $_SESSION['lang']['lokasi'] . "/(No.Persil)</td> \r\n <td rowspan=2>" . $_SESSION['lang']['desa'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['luas'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['bisaditanam'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['blok'] . "</td> \r\n <td colspan=4 align=center>" . $_SESSION['lang']['batas'] . "</td> \r\n <td colspan=7 align=center>" . $_SESSION['lang']['biaya'] . "-" . $_SESSION['lang']['biaya'] . "</td> \r\n <td colspan=4 align=center>" . $_SESSION['lang']['status'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['nomor'] . " " . $_SESSION['lang']['dokumen'] . "</td>\r\n <td rowspan=2>" . $_SESSION['lang']['keterangan'] . "</td> \r\n <td rowspan=2>" . $_SESSION['lang']['updateby'] . "</td> \r\n </tr><tr class=rowheader> \r\n <td>" . $_SESSION['lang']['batastimur'] . "</td> \r\n <td>" . $_SESSION['lang']['batasbarat'] . "</td> \r\n <td>" . $_SESSION['lang']['batasutara'] . "</td>\r\n <td>" . $_SESSION['lang']['batasselatan'] . "</td> \r\n \r\n <td>" . $_SESSION['lang']['tanamtumbuh'] . " (Rp)</td> \r\n <td>" . $_SESSION['lang']['gantilahan'] . " (Rp)</td> \r\n <td>" . $_SESSION['lang']['total'] . "<br>" . $_SESSION['lang']['gantilahan'] . " (Rp)</td> \r\n <td>" . $_SESSION['lang']['biaya'] . "<br>" . $_SESSION['lang']['camat'] . " (Rp)</td> \r\n <td>" . $_SESSION['lang']['biaya'] . "<br>" . $_SESSION['lang']['kades'] . " (Rp)</td>\r\n <td>" . $_SESSION['lang']['biaya'] . "<br>Matrai (Rp)</td>\r\n <td>" . $_SESSION['lang']['total'] . "<br>" . $_SESSION['lang']['biaya'] . " (Rp)</td> \r\n \r\n <td>" . $_SESSION['lang']['status'] . "<br>" . $_SESSION['lang']['permintaandana'] . "</td>\r\n <td>" . $_SESSION['lang']['status'] . "<br>" . $_SESSION['lang']['pembayaran'] . "</td>\r\n <td>" . $_SESSION['lang']['status'] . "<br>" . $_SESSION['lang']['desa'] . "</td>\r\n <td>" . $_SESSION['lang']['status'] . "<br>" . $_SESSION['lang']['camat'] . "</td>\r\n </tr></thead>\r\n <tbody>";
while ($bar1 = mysql_fetch_object($res1)) {
$stdana = $bar1->statuspermintaandana == 1 ? tanggalnormal($bar1->tanggalpengajuan) : "";
if ($bar1->statuspermbayaran == 1) {
$stbayar = tanggalnormal($bar1->tanggalbayar) . " Belum Lunas";
} else {
if ($bar1->statuspermbayaran == 0) {
$stbayar = 'Belum Bayar';
} else {
if ($bar1->statuspermbayaran == 2) {
$stbayar = tanggalnormal($bar1->tanggalbayar) . " Lunas";
}
}
}
$stkades = $bar1->statuskades == 1 ? tanggalnormal($bar1->tanggalkades) : "";
$stcamat = $bar1->statuscamat == 1 ? tanggalnormal($bar1->tanggalcamat) : "";
echo "<tr class=rowcontent> \r\n <td width='100px;'>\r\n <img src='images/application/application_view_gallery.png' class='resicon' title='Upload Document' onclick=uploadDocument('" . $bar1->idlahan . "','" . $bar1->pemilik . "',event)>\r\n <img src='images/skyblue/pdf.jpg' class='resicon' onclick=\"ptintPDF('" . $bar1->idlahan . "','" . $bar1->pemilik . "',event);\" title='Print Data Detail'>\r\n <img src='images/skyblue/edit.png' class=resicon caption='Edit' onclick=\"fillField('" . $bar1->idlahan . "','" . $bar1->pemilik . "','" . $bar1->unit . "','" . $bar1->lokasi . "','" . $bar1->luas . "','" . $bar1->luasdapatditanam . "','" . $bar1->rptanaman . "','" . $bar1->rptanah . "','" . $bar1->statuspermintaandana . "','" . $bar1->statuspermbayaran . "','" . $bar1->kodeblok . "','" . $bar1->statuskades . "','" . $bar1->statuscamat . "','" . tanggalnormal($bar1->tanggalpengajuan) . "','" . tanggalnormal($bar1->tanggalbayar) . "','" . tanggalnormal($bar1->tanggalkades) . "','" . tanggalnormal($bar1->tanggalcamat) . "','" . $bar1->biayakades . "','" . $bar1->biayacamat . "','" . $bar1->biayamatrai . "','" . $bar1->keterangan . "','" . $bar1->nosurat . "','" . $bar1->batastimur . "','" . $bar1->batasbarat . "','" . $bar1->batasutara . "','" . $bar1->batasselatan . "');\">\r\n <img src='images/skyblue/posting.png' class='resicon' onclick=\"postingData('" . $bar1->idlahan . "','" . $bar1->unit . "')\" title='Posting'>\r\n <img src='images/skyblue/delete.png' class='resicon' onclick=\"deleteData('" . $bar1->idlahan . "','" . $bar1->unit . "');\" title='Delete'>\r\n </td>\r\n <td>" . $bar1->idlahan . "</td>\r\n <td>" . $bar1->unit . "</td>\r\n <td>" . $bar1->nama . "</td>\r\n <td>" . $bar1->lokasi . "</td> \r\n <td>" . $bar1->desa . "</td>\r\n <td align=right>" . $bar1->luas . "</td> \r\n <td align=right>" . $bar1->luasdapatditanam . "</td>\r\n <td>" . $bar1->kodeblok . "</td> \r\n <td>" . $bar1->batastimur . "</td>\r\n <td>" . $bar1->batasbarat . "</td>\r\n <td>" . $bar1->batasutara . "</td>\r\n <td>" . $bar1->batasselatan . "</td> \r\n <td align=right>" . number_format($bar1->rptanaman, 0) . "</td> \r\n <td align=right>" . number_format($bar1->rptanah, 0) . "</td>\r\n <td align=right>" . number_format($bar1->totalgantirugi, 0) . "</td> \r\n <td align=right>" . number_format($bar1->biayakades, 0) . "</td>\r\n <td align=right>" . number_format($bar1->biayacamat, 0) . "</td>\r\n <td align=right>" . number_format($bar1->biayamatrai, 0) . "</td>\r\n <td align=right>" . number_format($bar1->totalgantirugi + $bar1->biayakades + $bar1->biayacamat + $bar1->biayamatrai, 0) . "</td>\r\n <td>" . $stdana . "</td>\r\n <td>" . $stbayar . "</td>\r\n <td>" . $stkades . "</td>\r\n <td>" . $stcamat . "</td> \r\n <td>" . $bar1->nosurat . "</td> \r\n <td>" . $bar1->keterangan . "</td> \r\n <td>" . $bar1->namakaryawan . "</td> \r\n </td></tr>";
}
echo "\t \r\n </tbody>\r\n <tfoot>\r\n </tfoot>\r\n </table>";
}
$i = "select * from " . $dbname . ".log_packinght where " . $kdPtLoad . " " . $perLoad . " order by tanggal desc limit " . $offset . "," . $limit . "";
//echo $i;
$n = mysql_query($i) or die(mysql_error());
$no = $maxdisplay;
while ($d = mysql_fetch_assoc($n)) {
$no += 1;
echo "<tr class=rowcontent>";
echo "<td align=center>" . $no . "</td>";
echo "<td align=left>" . $d['notransaksi'] . "</td>";
echo "<td align=left>" . tanggalnormal($d['tanggal']) . "</td>";
echo "<td align=left>" . $d['kodept'] . "</td>";
echo "<td align=left>" . $nmKar[$d['createby']] . "</td>";
echo "<td>" . $nmKar[$d['menyerahkan']] . "</td>";
echo "<td>" . $d['menerima'] . "</td>";
if ($d['posting'] == '0') {
$post = "<td align=center>\r\n\t\t\t\t\t\t\t\t\t<img src=images/application/application_edit.png title='update' class=resicon caption='Edit' onclick=\"edit('" . $d['notransaksi'] . "','" . $d['kodept'] . "','" . tanggalnormal($d['tanggal']) . "','" . $d['ukuranpeti'] . "','" . $d['keterangan'] . "','" . $d['menyerahkan'] . "','" . $d['menerima'] . "');\">\r\n\t\t\t\t\t\t\t\t\t<img src=images/application/application_delete.png title='delete' class=resicon caption='Delete' onclick=\"delHead('" . $d['notransaksi'] . "');\">\r\n\t\t\t\t\t\t\t\t\t<img src=images/hot.png title='Posting' class=zImgBtn caption='Posting' onclick=\"posting('" . $d['notransaksi'] . "');\">\r\n\t\t\t\t\t\t\t\t\t<img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_splht','" . $d['notransaksi'] . "','','log_slave_packing_pdf',event)\">\r\n\t\t\t\t\t\t\t\t</td>";
} else {
$post = "<td align=center>\r\n\t\t\t\t\t\t\t\t<img src=images/buttongreen.png class=zImgBtn>\r\n\t\t\t\t\t\t\t\t<img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_splht','" . $d['notransaksi'] . "','','log_slave_packing_pdf',event)\">\r\n\t\t\t\t\t\t\t </td>";
}
echo $post;
echo "</tr>";
}
echo "\r\n\t\t\t<tr class=rowheader><td colspan=43 align=center>\r\n\t\t\t" . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "<br />\r\n\t\t\t<button class=mybutton onclick=cariBast(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n\t\t\t<button class=mybutton onclick=cariBast(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n\t\t\t</td>\r\n\t\t\t</tr>";
echo "</tbody></table>";
break;
case 'delHead':
$i = "delete from " . $dbname . ".log_packinght where notransaksi='" . $notran . "'";
//exit("Error:$i");
if (mysql_query($i)) {
} else {
echo " Gagal," . addslashes(mysql_error($conn));
$txt = "and nosj like '%" . $txt . "%'";
} else {
$txt = "";
}
$ql2 = "select count(*) as jmlhrow from " . $dbname . ".log_suratjalanht where posting='1' " . $txt . " order by tanggal desc";
// echo $ql2;notran
$query2 = mysql_query($ql2) or die(mysql_error());
while ($jsl = mysql_fetch_object($query2)) {
$jlhbrs = $jsl->jmlhrow;
}
$ha = "SELECT * FROM " . $dbname . ".log_suratjalanht where posting='1' " . $txt . " order by tanggal desc limit " . $offset . "," . $limit . "";
//echo $ha;
$hi = mysql_query($ha) or die(mysql_error());
$no = $maxdisplay;
while ($hu = mysql_fetch_assoc($hi)) {
$no += 1;
//<td>".$nmFranco[$hu['franco']]."</td>
echo "\r\n\t\t\t<tr class=rowcontent>\r\n\t\t\t\t<td>" . $no . "</td>\r\n\t\t\t\t<td>" . $hu['nosj'] . "</td>\r\n\t\t\t\t<td>" . $hu['kodept'] . "</td>\r\n\t\t\t\t<td>" . $hu['kodeorg'] . "</td>\r\n\t\t\t\t<td>" . tanggalnormal($hu['tanggal']) . "</td>\r\n\t\t\t\t<td>" . tanggalnormal($hu['tanggalkirim']) . "</td>\r\n\t\t\t\t<td>" . $nmSup[$hu['expeditor']] . "</td>\r\n <td>" . $optKend[$hu['jeniskend']] . "</td>\r\n\t\t\t\t<td>" . $hu['nopol'] . "</td>\r\n <td>" . $hu['driver'] . "</td>\r\n <td>" . $nmKar[$hu['pengirim']] . "</td>";
if ($hu['postingpenerimaan'] == '0') {
$post = "<td align=center><img src=images/zoom.png title='" . $_SESSION['lang']['find'] . "' id=a class=resicon onclick=listBarang('" . $hu['nosj'] . "','" . $_SESSION['lang']['find'] . "',event)></td>";
} else {
$post = "<td align=center>" . $_SESSION['lang']['posted'] . " " . $hu['penerima'] . "</td>";
}
echo $post;
echo "</tr>";
}
echo "\r\n\t\t<tr class=rowheader><td colspan=18 align=center>\r\n\t\t" . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "<br />\r\n\t\t<button class=mybutton onclick=cariBast(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n\t\t<button class=mybutton onclick=cariBast(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n\t\t</td>\r\n\t\t</tr>";
echo "</tbody></table>";
break;
default:
}
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
$param = $_POST;
if ($param['kodeorg'] != '' and $param['periode'] != '') {
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".rencana_gis_file a\r\n left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n where unit='" . $param['kodeorg'] . "' and tanggal like '" . $param['periode'] . "%' \r\n and kode='" . $param['kode'] . "' \r\n order by a.lastupdate desc";
} else {
if ($param['kodeorg'] != '' and $param['periode'] == '') {
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".rencana_gis_file a\r\n left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n where unit='" . $param['kodeorg'] . "' and kode='" . $param['kode'] . "' \r\n order by a.lastupdate desc";
} else {
if ($param['kodeorg'] == '' and $param['periode'] != '') {
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".rencana_gis_file a\r\n left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n where tanggal like '" . $param['periode'] . "%' and \r\n kode='" . $param['kode'] . "' and a.karyawanid='" . $_SESSION['standard']['userid'] . "'\r\n order by a.lastupdate desc";
} else {
if ($param['kodeorg'] == '' and $param['periode'] == '' and $param['kode'] == '') {
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".rencana_gis_file a\r\n left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n order by a.lastupdate desc limit 100";
} else {
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".rencana_gis_file a\r\n left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n where kode='" . $param['kode'] . "' \r\n order by a.lastupdate desc";
}
}
}
}
$res1 = mysql_query($str1);
$no = 0;
while ($bar1 = mysql_fetch_object($res1)) {
$no += 1;
echo "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $bar1->unit . "</td>\r\n <td>" . $bar1->kode . "</td>\r\n <td>" . tanggalnormal($bar1->tanggal) . "</td>\r\n <td>" . $bar1->namakaryawan . "</td>\r\n <td>" . $bar1->lastupdate . "</td>\r\n <td>" . $bar1->keterangan . "</td>\r\n <td>" . $bar1->namafile . "</td>\r\n <td align=right>" . $bar1->ukuran . "</td>\r\n <td>" . $bar1->namakaryawan . "</td>\r\n <td>";
if ($bar1->karyawanid == $_SESSION['standard']['userid']) {
echo "<img class=zImgBtn src=images/skyblue/delete.png title='Edit' onclick=\"delFile('" . $bar1->unit . "','" . $bar1->kode . "','" . $bar1->namafile . "');\">      ";
}
echo "<img class=zImgBtn src=images/skyblue/save.png title='Save' onclick=\"download('" . $bar1->namafile . "');\"></td></tr>";
}
function Header()
{
global $periode;
global $kdUnit;
global $optNmOrg;
global $dbname;
global $thn;
global $tot;
$this->SetFont('Arial', 'B', 8);
$this->Cell($width, $height, strtoupper("25.3 TRANSIT KENDARAAN"), 0, 1, 'L');
$this->Cell($width, $height, $_SESSION['lang']['bulan'] . ' : ' . substr(tanggalnormal($periode), 1, 7), 0, 1, 'R');
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell($width, $height, $_SESSION['lang']['unit'] . ' : ' . $optNmOrg[$kdUnit], 0, 1, 'L');
$this->Cell(790, $height, ' ', 0, 1, 'R');
$height = 10;
$this->SetFillColor(220, 220, 220);
$this->SetFont('Arial', 'B', 5);
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell(15, $height, "No.", TLR, 0, 'C', 1);
$this->Cell(35, $height, "Jenis", TLR, 0, 'C', 1);
$this->Cell(80, $height, "Nama KEND", TLR, 0, 'C', 1);
$this->Cell(50, $height, "KODE MESIN", TLR, 0, 'C', 1);
$this->Cell(25, $height, "THN ", TLR, 0, 'C', 1);
$this->Cell(45, $height, "ANGGARAN ", TLR, 0, 'C', 1);
$this->Cell(80, $height, "REALISASI PEMAKAIAN FISIK", TLR, 0, 'C', 1);
$this->Cell(50, $height, "RASIO ", TLR, 0, 'C', 1);
$this->Cell(50, $height, "ANGGARAN ", TLR, 0, 'C', 1);
$this->Cell(280, $height, "Realisasi Biaya Operasi (000) ", TLR, 0, 'C', 1);
$this->Cell(80, $height, "COST / UNIT", TLR, 1, 'C', 1);
$this->Cell(15, $height, " ", LR, 0, 'C', 1);
$this->Cell(35, $height, " ", LR, 0, 'C', 1);
$this->Cell(80, $height, " ", LR, 0, 'C', 1);
$this->Cell(50, $height, "MESIN/KEND ", LR, 0, 'C', 1);
$this->Cell(25, $height, "PER", LR, 0, 'C', 1);
$this->Cell(45, $height, "SETAHUN ", LR, 0, 'C', 1);
$this->Cell(40, $height, "KM", TLR, 0, 'C', 1);
$this->Cell(40, $height, "LTR", TLR, 0, 'C', 1);
$this->Cell(50, $height, "S/D BLN INI", LR, 0, 'C', 1);
$this->Cell(50, $height, "SETAHUN", LR, 0, 'C', 1);
$this->Cell(140, $height, "BI", TLR, 0, 'C', 1);
$this->Cell(140, $height, "SBI", TLR, 0, 'C', 1);
$this->Cell(40, $height, "ANGGARAN", TLR, 0, 'C', 1);
$this->Cell(40, $height, "REALISASI", TLR, 1, 'C', 1);
$this->Cell(15, $height, " ", BLR, 0, 'C', 1);
$this->Cell(35, $height, " ", BLR, 0, 'C', 1);
$this->Cell(80, $height, " ", BLR, 0, 'C', 1);
$this->Cell(50, $height, "", BLR, 0, 'C', 1);
$this->Cell(25, $height, "OLEHAN", BLR, 0, 'C', 1);
$this->Cell(45, $height, "(KM)", BLR, 0, 'C', 1);
$this->Cell(20, $height, "BI", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "SBI", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "BI", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "SBI", TBLR, 0, 'C', 1);
$this->Cell(50, $height, "(LTR/KM)", BLR, 0, 'C', 1);
$this->Cell(50, $height, " (Rp.000,-) ", BLR, 0, 'C', 1);
$this->SetFont('Arial', 'B', 4);
$this->Cell(20, $height, "Gaji", TBLR, 0, 'C', 1);
$this->SetFont('Arial', 'B', 3.5);
$this->Cell(20, $height, "Pre/Lembur", TBLR, 0, 'L', 1);
$this->Cell(20, $height, "BBM/Plumas", TBLR, 0, 'L', 1);
$this->Cell(20, $height, "S.Cadang", TBLR, 0, 'L', 1);
$this->SetFont('Arial', 'B', 4);
$this->Cell(20, $height, "Reprasi", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "Asuransi", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "Total", TBLR, 0, 'C', 1);
$this->SetFont('Arial', 'B', 4);
$this->Cell(20, $height, "Gaji", TBLR, 0, 'C', 1);
$this->SetFont('Arial', 'B', 3.5);
$this->Cell(20, $height, "Pre/Lembur", TBLR, 0, 'L', 1);
$this->Cell(20, $height, "BBM/Plumas", TBLR, 0, 'L', 1);
$this->Cell(20, $height, "S.Cadang", TBLR, 0, 'L', 1);
$this->SetFont('Arial', 'B', 4);
$this->Cell(20, $height, "Reprasi", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "Asuransi", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "Total", TBLR, 0, 'C', 1);
$this->SetFont('Arial', 'B', 5);
$this->Cell(40, $height, "SETAHUN ", BLR, 0, 'C', 1);
$this->Cell(20, $height, "BI", TBLR, 0, 'C', 1);
$this->Cell(20, $height, "SBI", TBLR, 1, 'C', 1);
}
function Header()
{
global $periode;
global $dataAfd;
global $kdUnit;
global $optNmOrg;
global $dbname;
global $thn;
global $kbnSndri;
global $lstPlnggan;
global $tot;
global $colsPertama;
global $colsKedua;
$cold = count($kbnSndri) * 55;
$tot = count($lstPlnggan);
$cold2 = count($lstPlnggan) * 55;
$this->SetFont('Arial', 'B', 8);
$this->Cell($width, $height, strtoupper("17.2 " . strtoupper($_SESSION['lang']['pengiriman']) . " (NURSERY) BIBIT"), 0, 1, 'L');
$this->Cell($width, $height, $_SESSION['lang']['bulan'] . ' : ' . substr(tanggalnormal($periode), 1, 7), 0, 1, 'R');
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell($width, $height, $_SESSION['lang']['unit'] . ' : ' . $optNmOrg[$kdUnit], 0, 1, 'L');
$this->Cell(790, $height, ' ', 0, 1, 'R');
$height = 15;
$this->SetFillColor(220, 220, 220);
$this->SetFont('Arial', 'B', 7);
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell(30, $height, "No.", TLR, 0, 'C', 1);
$this->Cell(130, $height, strtoupper($_SESSION['lang']['tujuan']), TLR, 0, 'C', 1);
$this->Cell(100, $height, "BIBIT", TLR, 0, 'C', 1);
$this->Cell($cold, $height, "INTERNAL DELIVERY", TLR, 0, 'C', 1);
$this->Cell($cold2, $height, "INTERNAL DELIVERY", TLR, 1, 'C', 1);
$this->Cell(30, $height, ".", BLR, 0, 'C', 1);
$this->Cell(130, $height, " ", BLR, 0, 'C', 1);
$this->Cell(100, $height, " ", BLR, 0, 'C', 1);
if ($colsPertama != 0) {
if (!empty($kbnSndri)) {
foreach ($kbnSndri as $dtKbn) {
$this->Cell(55, $height, $dtKbn, TBLR, 0, 'C', 1);
}
}
} else {
$this->Cell($cold, $height, $_SESSION['lang']['dataempty'], TBLR, 0, 'C', 1);
}
if ($colsKedua != 0) {
if (!empty($lstPlnggan)) {
foreach ($lstPlnggan as $dtPlgn) {
$ard += 1;
if ($ard != $tot) {
$this->Cell(55, $height, $dtPlgn, TBLR, 0, 'C', 1);
} else {
$this->Cell(55, $height, $dtPlgn, TBLR, 1, 'C', 1);
}
}
}
} else {
$this->Cell($cold2, $height, $_SESSION['lang']['dataempty'], TBLR, 1, 'C', 1);
}
}
while ($bar = mysql_fetch_object($res)) {
$jabatan = '';
$namakaryawan = '';
$bagian = '';
$karyawanid = '';
$strc = "select a.namakaryawan,a.karyawanid,a.bagian,b.namajabatan \r\n\t\t from " . $dbname . ".datakaryawan a left join " . $dbname . ".sdm_5jabatan b\r\n\t\t\ton a.kodejabatan=b.kodejabatan\r\n\t\t\twhere a.karyawanid=" . $bar->karyawanid;
$resc = mysql_query($strc);
while ($barc = mysql_fetch_object($resc)) {
$jabatan = $barc->namajabatan;
$namakaryawan = $barc->namakaryawan;
$bagian = $barc->bagian;
$karyawanid = $barc->karyawanid;
}
//===============================
$perstatus = $bar->stpersetujuan1;
$tgl = tanggalnormal($bar->tanggal);
$kperluan = $bar->keperluan;
$persetujuan = $bar->persetujuan1;
$jns = $bar->jenisijin;
$jmDr = $bar->darijam;
$jmSmp = $bar->sampaijam;
$koments = $bar->komenst1;
$ket = $bar->keterangan;
$periode = $bar->periodecuti;
$sthrd = $bar->stpersetujuanhrd;
$hk = $bar->jumlahhari;
$hrd = $bar->hrd;
$koments2 = $bar->komenst2;
//ambil bagian,jabatan persetujuan atasan
$perjabatan = '';
$perbagian = '';
function Header()
{
global $periode;
global $dataAfd;
global $kdUnit;
global $optNmOrg;
global $dbname;
global $thn;
global $dtBarang;
global $cols;
global $lstKodeOrg9;
global $lstKodeOrg8;
global $dtKodeorg;
global $afdId;
$this->SetFont('Arial', 'B', 8);
$this->Cell($width, $height, strtoupper("13.3 " . strtoupper($_SESSION['lang']['distribusi']) . " " . strtoupper($_SESSION['lang']['pupuk']) . ", AGROCHEMICAL"), 0, 1, 'L');
$this->Cell(790, $height, $_SESSION['lang']['bulan'] . ' : ' . substr(tanggalnormal($periode), 1, 7), 0, 1, 'R');
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell($width, $height, $_SESSION['lang']['unit'] . ' : ' . $optNmOrg[$kdUnit], 0, 1, 'L');
if ($afdId != '') {
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell($width, $height, $_SESSION['lang']['afdeling'] . ' : ' . $optNmOrg[$afdId], 0, 1, 'L');
}
$this->Cell(790, $height, ' ', 0, 1, 'R');
$height = 15;
$this->SetFillColor(220, 220, 220);
$this->SetFont('Arial', 'B', 7);
$wit = 45 * $cols;
$witda = 45 * $cols;
$tinggiAkr = $this->GetY();
$ksamping = $this->GetX();
$this->SetY($tinggiAkr + 20);
$this->SetX($ksamping);
$this->Cell(120, $height, $_SESSION['lang']['nama'], TLR, 0, 'C', 1);
$this->Cell(35, $height, $_SESSION['lang']['satuan'], TLR, 0, 'C', 1);
$this->Cell($wit, $height, $_SESSION['lang']['bi'], TLR, 0, 'C', 1);
$this->Cell($wit, $height, $_SESSION['lang']['sbi'], TLR, 1, 'C', 1);
$this->Cell(120, $height, $_SESSION['lang']['material'], BLR, 0, 'C', 1);
$this->Cell(35, $height, " ", BLR, 0, 'C', 1);
if (!empty($dtKodeorg)) {
foreach ($dtKodeorg as $lstKodeOrg8) {
$this->Cell(45, $height, $lstKodeOrg8, TBLR, 0, 'C', 1);
}
}
if (!empty($dtKodeorg)) {
foreach ($dtKodeorg as $lstKodeOrg9) {
$ar += 1;
if ($ar != $cols) {
$this->Cell(45, $height, $lstKodeOrg9, TBLR, 0, 'C', 1);
} else {
$this->Cell(45, $height, $lstKodeOrg9, TBLR, 1, 'C', 1);
}
}
}
}
$tglPO = "";
$statPo = "";
$rSup['namasupplier'] = "";
$rRapb['notransaksi'] = "";
$rRapb['tanggal'] = "0000-00-00";
}
if ($res['hasilpersetujuan1'] == 3 or $res['hasilpersetujuan2'] == 3 or $res['hasilpersetujuan3'] == 3 or $res['hasilpersetujuan4'] == 3 or $res['hasilpersetujuan5'] == 3 or $res['status'] == 3) {
$npo = '';
}
$stream .= "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $res['nopp'] . "</td>\r\n <td>" . tanggalnormal($res['tanggal']) . "</td>\r\n <td>" . $res['kodevhc'] . "</td>\r\n <td>" . $res['kodebarang'] . "</td>\r\n <td>" . $rBrg['namabarang'] . "</td>\r\n <td>" . $rBrg['satuan'] . "</td>\r\n <td align=right>" . $res['jumlah'] . "</td>\r\n <td align=right>" . $res['realisasi'] . "</td>\r\n <td align=left>" . $res['keterangan'] . "</td>\r\n ";
$stream .= "<td>" . $statPp . "</td>";
$stream .= "\r\n <td>" . $npo . "</td>\r\n <td>" . $tglPO . "</td>";
$stream .= "<td>" . $statPo . "</td>";
$stream .= "<td>" . $rSup['namasupplier'] . "</td>\r\n <td>" . $rRapb['notransaksi'] . "</td>";
if ($rRapb['tanggal'] != 00 - 00 - 00) {
$stream .= "<td>" . tanggalnormal($rRapb['tanggal']) . "</td></tr>";
} else {
$stream .= "<td></td></tr>";
}
}
$stream .= "</table>";
} else {
$stream .= "<tr class=rowcontent><td colspan=16 align=center>Not Found</td></tr></table>";
}
$stream .= "<tr class=rowcontent><td colspan=16 align=left><table cellpadding=1 cellspacing=1 border=1 class=sortable>";
$stream .= "<thead><tr class=rowheader>";
$stream .= "<td bgcolor=#DEDEDE align=center>Purchased</td>";
$stream .= "<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['ditolak'] . "</td>";
$stream .= "<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['wait_approval'] . "</td>";
$stream .= "<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['belumdiajukan'] . "</td>";
$stream .= "<td bgcolor=#DEDEDE align=center>Purchasing Process</td>";
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
OPEN_BOX();
$lksiTugas = substr($_SESSION['empl']['lokasitugas'], 0, 4);
$sPeriode = "select distinct periode from " . $dbname . ".sdm_5periodegaji where kodeorg='" . $lksiTugas . "' order by periode desc";
$optPeriode = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$qPeriode = mysql_query($sPeriode) or die(mysql_error());
while ($rPeriode = mysql_fetch_assoc($qPeriode)) {
$optPeriode .= "<option value=" . $rPeriode['periode'] . ">" . substr(tanggalnormal($rPeriode['periode']), 1, 7) . "</option>";
}
$sBagian = "select distinct * from " . $dbname . ".sdm_5departemen order by nama asc";
$qBagian = mysql_query($sBagian) or die(mysql_error());
$optBagian = "";
while ($rBagian = mysql_fetch_assoc($qBagian)) {
$optBagian .= "<option value=" . $rBagian['kode'] . ">" . $rBagian['nama'] . "</option>";
}
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') {
$sOrg = "select namaorganisasi,kodeorganisasi from " . $dbname . ".organisasi where tipe in ('KEBUN','PABRIK','KANWIL','TRAKSI') order by namaorganisasi asc ";
} elseif ($_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
$sOrg = "select namaorganisasi,kodeorganisasi from " . $dbname . ".organisasi \r\n where tipe in ('KEBUN','PABRIK','KANWIL','TRAKSI') or induk='" . $_SESSION['empl']['lokasitugas'] . "' order by namaorganisasi asc ";
} else {
$sOrg = "select namaorganisasi,kodeorganisasi from " . $dbname . ".organisasi where induk='" . $_SESSION['empl']['lokasitugas'] . "' or kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "' order by kodeorganisasi asc";
}
$optOrg = "<option value=''>" . $_SESSION['lang']['pilihdata'] . "</option>";
$qOrg = mysql_query($sOrg) or die(mysql_error($conn));
$arrIdKompPls[] = $rKomp['id'];
$arrNmKomPls[$rKomp['id']] = $rKomp['name'];
}
$totPlus = count($arrIdKompPls);
$brsPlus = 0;
$sKomp = "select id,name from " . $dbname . ".sdm_ho_component where plus='0' ";
$qKomp = mysql_query($sKomp) or die(mysql_error());
while ($rKomp = mysql_fetch_assoc($qKomp)) {
$arrIdKompMin[] = $rKomp['id'];
$arrNmKomMin[$rKomp['id']] = $rKomp['name'];
}
$sPeriod = "select tanggalmulai,tanggalsampai from " . $dbname . ".sdm_5periodegaji where jenisgaji='B' and periode='" . $perod . "' and kodeorg='" . substr($idAfd, 0, 4) . "'";
$qPeriod = mysql_query($sPeriod) or die(mysql_error());
$rPeriod = mysql_fetch_assoc($qPeriod);
$mulai = tanggalnormal($rPeriod['tanggalmulai']);
$selesi = tanggalnormal($rPeriod['tanggalsampai']);
$stream .= "\r\n <table>\r\n <tr><td colspan=15 align=center>List Data Gaji Harian, Unit : " . $idAfd . "</td></tr>\r\n <tr><td colspan=15 align=center>Periode : " . $mulai . " s.d. " . $selesi . "</td></tr>\r\n </table>\r\n <table border=1>\r\n <tr>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>No.</td>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['nik'] . "/" . $_SESSION['lang']['tmk'] . "</td>";
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING' || $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
$stream .= "<td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['subbagian'] . "</td>";
}
$stream .= "<td bgcolor=#DEDEDE align=center rowspan='2'>No. Rekening</td>";
$stream .= "<td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['tipekaryawan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['totLembur'] . "</td>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['unit'] . "/" . $_SESSION['lang']['bagian'] . "</td>\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['statuspajak'] . "</td>\r\n\r\n <td bgcolor=#DEDEDE align=center rowspan='2'>" . $_SESSION['lang']['jabatan'] . "</td>";
//absen di bayar
$shkdbyr = "select distinct kodeabsen from " . $dbname . ".sdm_5absensi where kelompok=1 order by kodeabsen";
$qhkdbyr = mysql_query($shkdbyr) or die(mysql_error($conn));
$rowabs = mysql_num_rows($qhkdbyr);
//absen tidak di bayar
$shkdbyr2 = "select distinct kodeabsen from " . $dbname . ".sdm_5absensi where kelompok=0 order by kodeabsen";
$qhkdbyr2 = mysql_query($shkdbyr2) or die(mysql_error($conn));
$rowabs2 = mysql_num_rows($qhkdbyr2);
$stream .= "<td bgcolor=#DEDEDE align=center colspan='" . ($rowabs + 1) . "'>" . $_SESSION['lang']['hkdibayar'] . "</td>";
$pdf->Cell(25, 5, $_SESSION['lang']['mesin'], 1, 0, 'C', 1);
$pdf->Cell(30, 5, $_SESSION['lang']['jammulai'], 1, 0, 'C', 1);
$pdf->Cell(30, 5, $_SESSION['lang']['jamselesai'], 1, 1, 'C', 1);
//$pdf->Cell(25,5,'Total',1,1,'C',1);
$pdf->SetFillColor(255, 255, 255);
$pdf->SetFont('Arial', '', 9);
if ($periode == '0') {
$str = "select a.*,b.* from " . $dbname . ".pabrik_rawatmesinht a inner join " . $dbname . ".pabrik_rawatmesindt b on a.notransaksi=b.notransaksi \r\n\t\twhere a.pabrik='" . $pabrik . "' and a.statasiun='" . $statId . "' order by a.tanggal asc";
} elseif ($periode != '0') {
$str = "select a.*,b.* from " . $dbname . ".pabrik_rawatmesinht a inner join " . $dbname . ".pabrik_rawatmesindt b on a.notransaksi=b.notransaksi \r\n\t\twhere a.pabrik='" . $pabrik . "' and a.statasiun='" . $statId . "' and tanggal like '%" . $periode . "%' order by a.tanggal asc";
}
$re = mysql_query($str);
$no = 0;
while ($res = mysql_fetch_assoc($re)) {
$no += 1;
$sBrg = "select namabarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $res['kodebarang'] . "'";
$qBrg = mysql_query($sBrg) or die(mysql_error());
$rBrg = mysql_fetch_assoc($qBrg);
$pdf->Cell(8, 5, $no, 1, 0, 'L', 1);
$pdf->Cell(40, 5, $res['notransaksi'], 1, 0, 'C', 1);
$pdf->Cell(20, 5, tanggalnormal($res['tanggal']), 1, 0, 'C', 1);
$pdf->Cell(25, 5, $res['kodebarang'], 1, 0, 'C', 1);
$pdf->Cell(60, 5, $rBrg['namabarang'], 1, 0, 'L', 1);
$pdf->Cell(15, 5, $res['satuan'], 1, 0, 'C', 1);
$pdf->Cell(15, 5, $res['jumlah'], 1, 0, 'C', 1);
$pdf->Cell(15, 5, $res['shift'], 1, 0, 'C', 1);
$pdf->Cell(25, 5, $res['mesin'], 1, 0, 'C', 1);
$pdf->Cell(30, 5, tanggalnormald($res['jammulai']), 1, 0, 'C', 1);
$pdf->Cell(30, 5, tanggalnormald($res['jamselesai']), 1, 1, 'C', 1);
}
$pdf->Output();
} else {
if ($method == 'insert') {
$str = "insert into " . $dbname . ".sdm_penggantiantransport \r\n\t (`notransaksi`,`karyawanid`,`periode`,\r\n\t\t `keterangan`,`toll`,`trans`,\r\n\t\t `perawatan`,`kodeorg`,`alokasi`,\r\n\t\t `updateby`,`bylain`,`totalklaim`)\r\n\t\t values(\r\n\t\t '" . $notransaksi . "'," . $karyawanid . ",'" . $periode . "',\r\n\t\t '" . $keterangan . "'," . $bytoll . "," . $bytransport . ",\r\n\t\t " . $byperawatan . ",'" . $kodeorg . "','" . $pt . "',\r\n\t\t " . $userid . "," . $bylain . "," . $total . "\r\n\t\t )";
} else {
if ($method == 'update') {
$str = "update " . $dbname . ".sdm_penggantiantransport\r\n\t set \r\n\t\t `karyawanid`=" . $karyawanid . ",\r\n\t\t `periode`='" . $periode . "',\r\n\t\t `keterangan`='" . $keterangan . "',\r\n\t\t `toll`=" . $bytoll . ",\r\n\t\t `trans`=" . $bytransport . ",\r\n\t\t `perawatan`=" . $byperawatan . ",\r\n\t\t `kodeorg`='" . $kodeorg . "',\r\n\t\t `alokasi`='" . $pt . "',\r\n\t\t `updateby`=" . $userid . ",\r\n\t\t `bylain`=" . $bylain . ",\r\n\t\t `totalklaim`=" . $total . "\r\n\t\t where notransaksi='" . $notransaksi . "'";
} else {
$str = "select 1=1";
}
}
}
if (mysql_query($str)) {
if ($periode == '') {
$periode = date('Y-m');
}
$str = "select a.*,sum(b.jlhbbm) as bbm,c.namakaryawan from " . $dbname . ".sdm_penggantiantransport a\r\n\t left join " . $dbname . ".sdm_penggantiantransportdt b \r\n\t\t on a.notransaksi=b.notransaksi\r\n\t\t left join " . $dbname . ".datakaryawan c\r\n\t\t on a.karyawanid=c.karyawanid\r\n\t\t where periode='" . $periode . "' and \r\n\t\t kodeorg='" . substr($_SESSION['empl']['lokasitugas'], 0, 4) . "'\r\n\t\t group by notransaksi";
$res = mysql_query($str);
$no = 0;
while ($bar = mysql_fetch_object($res)) {
$no += 1;
$add = '';
if ($bar->posting == 0) {
$add .= " <img src='images/close.png' class=resicon onclick=deleteBBM('" . $bar->notransaksi . "') title='delete'>";
//$add.=" <img src='images/tool.png' class=resicon onclick=editBBM('".$bar->notransaksi."') title='edit'>";
}
$add .= " <img src='images/pdf.jpg' class=resicon onclick=previewBBM('" . $bar->notransaksi . "',event) title='view'>";
echo "<tr class=rowcontent>\r\n\t\t <td>" . $no . "</td>\r\n\t\t\t <td>" . $bar->notransaksi . "</td>\r\n\t\t\t <td>" . substr($bar->periode, 5, 2) . "-" . substr($bar->periode, 0, 4) . "</td>\r\n\t\t\t <td>" . $bar->alokasi . "</td>\r\n\t\t\t <td>" . $bar->namakaryawan . "</td>\r\n\t\t\t <td align=right>" . number_format($bar->totalklaim, 2, ',', '.') . "</td>\r\n\t\t\t <td align=right>" . number_format($bar->dibayar, 2, ',', '.') . "</td>\r\n\t\t\t <td>" . tanggalnormal($bar->tanggalbayar) . "</td>\r\n\t\t\t <td align=right>" . number_format($bar->bbm, 2, ',', '.') . "</td>\r\n\t\t\t <td>" . $bar->keterangan . "</td>\t\r\n\t\t\t <td>" . $add . "</td>\t \r\n\t\t </tr>";
}
} else {
echo " Gagal " . addslashes(mysql_error($conn));
}
//total karyawan
$total = 0;
//total per karyawan
while ($bar = mysql_fetch_object($res)) {
$valPerusahaan = $bar->value * -1 / $angka * 100 * $perusahaan;
$tvp += $valPerusahaan;
$kar += $bar->value * -1;
$total = $valPerusahaan + $bar->value * -1;
$stru = "select sum(value) as gjk from " . $dbname . ".sdm_ho_detailmonthly where (component=1 or component=2)\r\n\t\t\t and updatedby='" . $_SESSION['standard']['username'] . "'\r\n\t\t\t and periode='" . $val . "' and karyawanid=" . $bar->karyawanid;
$resu = mysql_query($stru);
$gjkotor = 0;
while ($baru = mysql_fetch_object($resu)) {
$gjkotor = $baru->gjk;
}
$no += 1;
$stream .= "<tr class=rowcontent>\r\n\t\t\t <td class=firsttd>" . $no . "</td>\r\n\t\t\t <td>'" . $bar->karyawanid . "</td>\r\n\t\t\t\t<td>" . $bar->name . "</td>\r\n\t\t\t\t<td>" . $bar->nojms . "</td>\r\n\t\t\t\t<td align=right>" . tanggalnormal($bar->startdate) . "</td>\r\n\t\t\t\t<td align=center>" . $bar->periode . "</td>\r\n\t\t\t\t<td align=right>" . number_format($bar->value * -1, 2, '.', '') . "</td>\r\n\t\t\t\t<td align=right>" . number_format($valPerusahaan, 2, '.', '') . "</td>\r\n\t\t\t\t<td align=right>" . number_format($total, 2, '.', '') . "</td>\r\n\t\t\t\t<td align=right>" . number_format($gjkotor, 2, '.', '') . "</td>\r\n\t\t\t </tr>";
$ttl += $total;
}
$stream .= "</tbody>\r\n\t\t\t <tfoot></tfoot>\r\n\t\t\t <tr class=rowcontent>\r\n\t\t\t <td class=firsttd colspan=6 align=center>TOTAL</td>\r\n\t\t\t\t<td align=right>" . number_format($kar, 2, '.', '') . "</td>\r\n\t\t\t\t<td align=right>" . number_format($tvp, 2, '.', '') . "</td>\t\t\t\t\r\n\t\t\t\t<td align=right>" . number_format($ttl, 2, '.', '') . "</td>\r\n\t\t\t </tr>\r\n\t\t </table>";
$nop_ = "jamsostek" . $val1;
if (strlen($stream) > 0) {
if ($handle = opendir('tempExcel')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
@unlink('tempExcel/' . $file);
}
}
closedir($handle);
}
$handle = fopen("tempExcel/" . $nop_ . ".xls", 'w');
if (!fwrite($handle, $stream)) {
$stru2 = "select distinct(a.tanggal), a.notransaksi from " . $dbname . ".kebun_prestasi_vw a left join \r\n " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid\r\n where b.tipekaryawan in(2,3,4,6) and b.lokasitugas='" . $param['kodeorg'] . "' \r\n and (b.tanggalkeluar>='" . $tanggal1 . "' or b.tanggalkeluar='0000-00-00') and b.alokasi=0\r\n and a.unit like '" . $param['kodeorg'] . "%' and a.jurnal=0\r\n and a.tanggal>='" . $tanggal1 . "' and a.tanggal<='" . $tanggal2 . "' \r\n and sistemgaji='Harian' order by tanggal";
$resu2 = mysql_query($stru2);
#posting traksi
$stru3 = "select distinct(a.tanggal), a.notransaksi\r\n from " . $dbname . ".vhc_runhk_vw a left join \r\n " . $dbname . ".datakaryawan b on a.idkaryawan=b.karyawanid\r\n where b.tipekaryawan in(2,3,4,6) and b.lokasitugas='" . $param['kodeorg'] . "' \r\n and (b.tanggalkeluar>='" . $tanggal1 . "' or b.tanggalkeluar='0000-00-00') and b.alokasi=0\r\n and a.tanggal>='" . $tanggal1 . "' and a.tanggal<='" . $tanggal2 . "' \r\n and posting=0 and sistemgaji='Harian' order by tanggal";
$resu3 = mysql_query($stru3);
if (mysql_num_rows($resu1) > 0 or mysql_num_rows($resu2) > 0 or mysql_num_rows($resu3) > 0) {
echo "Masih ada data yang belum di posting/There still unconfirmed transaction:";
echo "<table class=sortable border=0 cellspacing=1>\r\n <thead><tr class=rowheader>\r\n <td>" . $_SESSION['lang']['jenis'] . "</td>\r\n <td>" . $_SESSION['lang']['notransaksi'] . "</td>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n </tr></thead><tbody>";
while ($bar = mysql_fetch_object($resu1)) {
echo "<tr class=rowcontent><td>Perawatan Kebun</td><td>" . $bar->notransaksi . "</td><td>" . tanggalnormal($bar->tanggal) . "</td></tr>";
}
while ($bar = mysql_fetch_object($resu2)) {
echo "<tr class=rowcontent><td>Panen</td><td>" . $bar->notransaksi . "</td><td>" . tanggalnormal($bar->tanggal) . "</td></tr>";
}
while ($bar = mysql_fetch_object($resu3)) {
echo "<tr class=rowcontent><td>Traksi Pekerjaan</td><td>" . $bar->notransaksi . "</td><td>" . tanggalnormal($bar->tanggal) . "</td></tr>";
}
echo "</tbody><tfoot></tfoot></table>";
exit;
//keluar dari proses
}
#6.3.1 Get Premi Kegiatan Perawatan dan gaji pokok BHL
$premi = array();
$penalty = array();
$gapokbhl = array();
$penaltykehadiran = array();
$query5 = "select sum(a.umr) as gaji,a.karyawanid,sum(a.insentif) as premi from " . $dbname . ".kebun_kehadiran_vw a left join \r\n " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid\r\n where b.tipekaryawan in(2,3,4,6) and b.lokasitugas='" . $param['kodeorg'] . "' \r\n and (b.tanggalkeluar>='" . $tanggal1 . "' or b.tanggalkeluar='0000-00-00') and b.alokasi=0\r\n and a.unit like '" . $param['kodeorg'] . "%'\r\n and a.tanggal>='" . $tanggal1 . "' and a.tanggal<='" . $tanggal2 . "' \r\n and sistemgaji='Harian' group by a.karyawanid";
$premRes = fetchData($query5);
foreach ($premRes as $idx => $val) {
if ($val['premi'] > 0) {
$premi[$val['karyawanid']] = $val['premi'];
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $tipeIntex;
global $periode;
global $unit;
global $kdPabrik;
global $tgl_2;
global $tgl_1;
global $tglPeriode;
global $TGL;
global $optSupp;
global $optNm;
global $blnA;
$tglPeriode = explode("-", $periode);
$tanggal = count($tglPeriode) > 1 ? $tglPeriode[1] . "-" . $tglPeriode[0] : '';
# Alamat & No Telp
/* $query = selectQuery($dbname,'organisasi','namaorganisasi,alamat,telepon',
"kodeorganisasi='".$kdPt."'");
$orgData = fetchData($query);*/
$sAlmat = "select namaorganisasi,alamat,telepon from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'";
$qAlamat = mysql_query($sAlmat) or die(mysql_error());
$rAlamat = mysql_fetch_assoc($qAlamat);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 11;
$path = 'images/logo.jpg';
$this->Image($path, $this->lMargin, $this->tMargin, 0, 43);
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(255, 255, 255);
$this->SetX(90);
$this->Cell($width - 90, $height, $rAlamat['namaorganisasi'], 0, 1, 'L');
$this->SetX(90);
$this->Cell($width - 90, $height, $rAlamat['alamat'], 0, 1, 'L');
$this->SetX(90);
$this->Cell($width - 90, $height, "Tel: " . $rAlamat['telepon'], 0, 1, 'L');
$this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 11);
$this->Cell($width, $height, $_SESSION['lang']['rePenerimaanTbs'], 0, 1, 'C');
$this->SetFont('Arial', '', 8);
$this->Ln(5);
if ($_SESSION['language'] == 'EN') {
// $this->Cell($width,$height,"FFB receive from ".tanggalnormal($TGL[0])." to ".tanggalnormal($TGL[count($TGL)-1])." PKS:".$kdPabrik." (not include grading deduction)",0,1,'C');
$this->Cell($width, $height, "FFB receive month " . $blnA . " to " . tanggalnormal($TGL[count($TGL) - 1]) . " PKS:" . $kdPabrik . " (not include grading deduction)", 0, 1, 'C');
} else {
// $this->Cell($width,$height,"Penerimaan TBS dari Tanggal ".tanggalnormal($TGL[0])." s/d Tanggal ".tanggalnormal($TGL[count($TGL)-1])." PKS:".$kdPabrik." (belum dikurangi potongan sortasi)",0,1,'C');
$this->Cell($width, $height, "Penerimaan TBS Bulan " . $blnA . " s/d Tanggal " . tanggalnormal($TGL[count($TGL) - 1]) . " PKS:" . $kdPabrik . " (belum dikurangi potongan sortasi)", 0, 1, 'C');
}
$this->Ln(10);
}
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include 'lib/nangkoelib.php';
require_once 'config/connection.php';
$periode = $_POST['periode'];
$karyawanid = $_POST['karyawanid'];
$kodeorg = $_POST['kodeorg'];
$namakaryawan = $_POST['namakaryawan'];
$outstanding = $_POST['outstanding'];
echo "<fieldset>\r\n\t\t<label style='font-weight:bold'>Total Outstanding : " . $outstanding . "</label> \r\n\t</fieldset>";
echo "<fieldset><legend>" . $_SESSION['lang']['form'] . "</legend>\r\n <table>\r\n\t\t<tr>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=hidden class=myinputtext id=kodeorgJ value='" . $kodeorg . "'>\r\n\t\t\t\t<input type=hidden class=myinputtext id=karyawanidJ value='" . $karyawanid . "'>\r\n\t\t\t\t<input type=hidden class=myinputtext id=periodeJ value='" . $periode . "'>\r\n\t\t\t\t" . $_SESSION['lang']['namakaryawan'] . "\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t:\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=text class=myinputtext id=namakaryawan disabled value='" . $namakaryawan . "' size=25>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>\r\n\t\t\t\t" . $_SESSION['lang']['tangalcuti'] . "\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t:\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=text class=myinputtext id=dariJ onmouseover=setCalendar(this) onkeypress=\"return false;\" size=15>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>\r\n\t\t\t\t" . $_SESSION['lang']['tglcutisampai'] . "\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t:\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=text class=myinputtext id=sampaiJ onmouseover=setCalendar(this) onkeypress=\"return false;\" size=15>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>\r\n\t\t\t\t" . $_SESSION['lang']['diambil'] . " (Hari)\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t:\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=text class=myinputtextnumber id=diambilJ size=10 onkeypress=\"return angka_doang(event);\" size=3 maxlength=2>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td>\r\n\t\t\t\t" . $_SESSION['lang']['keterangan'] . " (Hari)\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t:\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type=text class=myinputtext id=keteranganJ onkeypress=\"return tanpa_kutip(event);\" size=35 maxlength=45>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td colspan=2>\r\n\t\t\t</td>\r\n\t\t\t<td>\r\n\t\t\t\t<input type='hidden' id='outstanding' value='" . $outstanding . "'>\r\n\t\t\t\t<button class=mybutton onclick=simpanJ()>" . $_SESSION['lang']['save'] . "</button>\r\n\t\t\t</td>\r\n\t\t</tr>\r\n\t</table>\r\n\t </fieldset>\r\n\t<fieldset>\r\n\t<legend>" . $_SESSION['lang']['cuti'] . "->[" . $namakaryawan . "] " . $_SESSION['lang']['periode'] . ":" . $periode . "</legend>\r\n\t<div style='width:750px;height:220px;overflow:scroll;' id=containerlist3>\r\n\t<table class=sortable cellspacing=1 border=0>\r\n\t<thead>\r\n\t<tr class=rowheader>\r\n\t <td>\r\n\t No\r\n\t </td>\r\n\t <td>" . $_SESSION['lang']['tangalcuti'] . "</td>\r\n\t <td>" . $_SESSION['lang']['tglcutisampai'] . "</td>\r\n\t <td>" . $_SESSION['lang']['diambil'] . "</td>\r\n\t <td>" . $_SESSION['lang']['keterangan'] . "</td>\r\n\t <td></td>\r\n\t</tr>\r\n\t</thead>\r\n\t<tbody>\r\n\t";
$str = "select * from " . $dbname . ".sdm_cutidt where karyawanid=" . $karyawanid . "\r\n\t and periodecuti='" . $periode . "' and kodeorg='" . $kodeorg . "'";
$res = mysql_query($str);
$no = 0;
$ttl = 0;
while ($bar = mysql_fetch_object($res)) {
$no += 1;
echo "<tr class=rowcontent id=barisJ" . $no . ">\r\n\t <td>" . $no . "</td>\r\n\t <td>" . tanggalnormal($bar->daritanggal) . "</td>\r\n\t <td>" . tanggalnormal($bar->sampaitanggal) . "</td>\r\n\t <td align=right>" . $bar->jumlahcuti . "</td>\r\n\t <td>" . $bar->keterangan . "</td>\r\n\t <td>\r\n\t <img src='images/application/application_delete.png' title='" . $_SESSION['lang']['delete'] . "' class=resicon onclick=\"hapusData('" . $periode . "','" . $karyawanid . "','" . $kodeorg . "','" . $bar->daritanggal . "','" . $bar->sampaitanggal . "','barisJ" . $no . "'," . $bar->jumlahcuti . ");\">\r\n\t </td>\r\n\t </tr>";
$ttl += $bar->jumlahcuti;
}
echo "<tr class=rowcontent>\r\n\t <td></td>\r\n\t <td>TOTAL</td>\r\n\t <td></td>\r\n\t <td align=right id=cellttl>" . $ttl . "</td>\r\n\t <td></td>\r\n\t <td></td>\r\n\t </tr>";
echo "</tbody>\r\n <tfoot>\r\n\t </tfoot>\r\n </div>\r\n\t</fieldset> \r\n\t";
//echo $qp;
$qyr = fetchData($qp);
foreach ($qyr as $hsl) {
for ($i = 1; $i < 6; $i++) {
if ($hsl['hasilpersetujuan' . $i] == 1) {
$b['status'] = $_SESSION['lang']['disetujui'];
} elseif ($hsl['hasilpersetujuan' . $i] == 3) {
$b['status'] = $_SESSION['lang']['ditolak'];
} elseif ($hsl['hasilpersetujuan' . $i] == '' || $hsl['hasilpersetujuan' . $i] == 0) {
$b['status'] = $_SESSION['lang']['wait_approve'];
}
if ($hsl['persetujuan' . $i] != 00) {
$sql = "select * from " . $dbname . ".`datakaryawan` where `karyawanid`='" . $hsl['persetujuan' . $i] . "'";
//echo $sql;//exit();
$keterangan = $hsl['komentar' . $i];
$tanggal = tanggalnormal($hsl['tglp' . $i]);
$query = mysql_query($sql) or die(mysql_error());
$res3 = mysql_fetch_object($query);
$sql2 = "select * from " . $dbname . ".`sdm_5jabatan` where kodejabatan='" . $res3->kodejabatan . "'";
$query2 = mysql_query($sql2) or die(mysql_error());
$res2 = mysql_fetch_object($query2);
$height = 12;
##ini untuk akalin biar dinamis, jadi kita taro keterangan di atas dahulu agar
## mendapatkan panjang heightnya, biar rapih
$awalY2 = $pdf->GetY();
$pdf->SetX(10000);
//di taro di 10000 agar sampai ujung jadi hilang dari kertas
$pdf->MultiCell(240, $height, $keterangan, '0', 'L');
$akhirY2 = $pdf->GetY();
$tinggiKet2 = $akhirY2 - $awalY2;
$height2 = $tinggiKet2;
$thnData = substr($rDataBatch['tanggaltanam'], 0, 4);
$starttime = strtotime($rDataBatch['tanggaltanam']);
//time();// tanggal sekarang
$endtime = strtotime($tglSkrng);
//tanggal pembuatan dokumen
$timediffSecond = abs($endtime - $starttime);
$base_year = min(date("Y", $thnData), date("Y", $thnSkrng));
$diff = mktime(0, 0, $timediffSecond, 1, 1, $base_year);
$jmlHari = date("j", $diff) - 1;
$no += 1;
$pdf->Cell(3 / 100 * $width, $height, $no, 1, 0, 'C', 1);
$pdf->Cell(8 / 100 * $width, $height, $rData['batch'], 1, 0, 'C', 1);
$pdf->Cell(17 / 100 * $width, $height, $optNm[$rData['kodeorg']], 1, 0, 'C', 1);
$pdf->Cell(8 / 100 * $width, $height, number_format($rData['jumlah'], 0), 1, 0, 'R', 1);
$pdf->Cell(11 / 100 * $width, $height, $rDataBatch['jenisbibit'], 1, 0, 'C', 1);
$pdf->Cell(8 / 100 * $width, $height, tanggalnormal($rDataBatch['tanggaltanam']), 1, 0, 'C', 1);
$pdf->Cell(8 / 100 * $width, $height, $jmlHari, 1, 1, 'C', 1);
$total += $rData['jumlah'];
}
$pdf->Cell(28 / 100 * $width, $height, $_SESSION['lang']['total'], 1, 0, 'C', 1);
$pdf->Cell(8 / 100 * $width, $height, number_format($total), 1, 0, 'R', 1);
$pdf->Cell(27 / 100 * $width, $height, "", 1, 1, 'R', 1);
$pdf->Output();
break;
case 'excel':
$tab = "\n <table>\n <tr><td colspan=7 align=center>" . $_SESSION['lang']['laporanStockBIbit'] . "</td></tr>\n <tr><td colspan=7></td><td></td></tr>\n </table>\n <table cellpadding=1 cellspacing=1 border=1 class=sortable>\n <thead>\n <tr class=rowheader>\n <td bgcolor=#DEDEDE align=center>" . substr($_SESSION['lang']['nomor'], 0, 2) . "</td>\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['batch'] . "</td>\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['kodeorg'] . "</td>\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['saldo'] . "</td>\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jenisbibit'] . "</td>\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['tgltanam'] . "</td> \n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['umur'] . " " . substr($_SESSION['lang']['afkirbibit'], 5) . "</td>\n </tr>\n </thead><tbody id=containDataStock>";
$where = "";
if ($kdBatch != '') {
$where = " and batch='" . $kdBatch . "'";
}
$sData = "select distinct batch,kodeorg,sum(jumlah) as jumlah from " . $dbname . ".bibitan_mutasi where kodeorg like '%" . $kdUnit . "%' " . $where . " and post = 1 group by batch,kodeorg order by tanggal desc ";
$no = 0;
while ($bar = mysql_fetch_object($res)) {
$no += 1;
echo $no . ". No " . $bar->notransaksi . ":" . tanggalnormal($bar->tanggal) . "\n";
}
exit('Error');
}
#Periksa TRAKSI
$str = "select notransaksi,tanggal from " . $dbname . ".vhc_runht where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'\n and tanggal between '" . $currstart . "' and '" . $currend . "' and posting=0";
$res = mysql_query($str);
if (mysql_num_rows($res) > 0) {
echo " There still Vehicle Runn transaction that has not been posted:\n";
$no = 0;
while ($bar = mysql_fetch_object($res)) {
$no += 1;
echo $no . ". No " . $bar->notransaksi . ":" . tanggalnormal($bar->tanggal) . "\n";
}
exit('Error');
}
}
#PERIKSA akun transit yang belum nol=============================
$str = "select sum(debet)-sum(kredit) as saldo FROM " . $dbname . ".keu_jurnalsum_vw where periode ='" . $param['periode'] . "' \n and kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' AND noakun like '4%'";
//exit('error'.$str);
$res = mysql_query($str);
$transit = 0;
if (mysql_num_rows($res) > 0) {
while ($bar = mysql_fetch_object($res)) {
$transit = abs($bar->saldo);
}
}
if ($transit > 10 && $transit != '') {
function Header()
{
global $conn;
global $dbname;
global $userid;
global $posted;
global $tanggal;
global $norek_sup;
global $npwp_sup;
global $nm_kary;
global $nm_pt;
global $nmSupplier;
global $almtSupplier;
global $tlpSupplier;
global $faxSupplier;
global $nopo;
global $tglPo;
global $kdBank;
global $an;
global $optNmkry;
global $kota;
global $cp;
$optNmkry = makeOption($dbname, 'datakaryawan', 'karyawanid,namakaryawan');
$str = "select kodeorg,kodesupplier,purchaser,nopo,tanggal from " . $dbname . ".log_poht where nopo='" . $_GET['column'] . "'";
//echo $str;exit();
$res = mysql_query($str);
$bar = mysql_fetch_object($res);
//ambil nama pt
if ($bar->kodeorg == '') {
$bar->kodeorg = $_SESSION['org']['kodeorganisasi'];
}
$str1 = "select namaorganisasi,alamat,wilayahkota,telepon from " . $dbname . ".organisasi where kodeorganisasi='" . $bar->kodeorg . "'";
$res1 = mysql_query($str1);
while ($bar1 = mysql_fetch_object($res1)) {
if (substr($bar1->namaorganisasi, 0, 8) == 'KOPERASI' || substr($bar1->namaorganisasi, 0, 8) == 'koperasi') {
$scek = "select distinct regional from " . $dbname . ".bgt_regional_assignment \r\n where kodeunit in (select kodeorganisasi from " . $dbname . ".organisasi where induk='" . $bar->kodeorg . "')";
//exit("Error:".$scek);
$qcek = mysql_query($scek) or die(mysql_error($conn));
$rcek = mysql_fetch_assoc($qcek);
if ($rcek['regional'] == 'KALTIM') {
$bar->kodeorg = 'DPA';
}
if ($rcek['regional'] == 'SUMSEL' || $rcek['regional'] == 'LAMPUNG') {
$bar->kodeorg = 'PMO';
}
$str1 = "select namaorganisasi,alamat,wilayahkota,telepon from " . $dbname . ".organisasi where kodeorganisasi='" . $bar->kodeorg . "'";
$res1 = mysql_query($str1);
$bar1 = mysql_fetch_object($res1);
}
$namapt = $bar1->namaorganisasi;
$alamatpt = $bar1->alamat . ", " . $bar1->wilayahkota;
$telp = $bar1->telepon;
}
$sNpwp = "select npwp,alamatnpwp from " . $dbname . ".setup_org_npwp where kodeorg='" . $bar->kodeorg . "'";
$qNpwp = mysql_query($sNpwp) or die(mysql_error());
$rNpwp = mysql_fetch_assoc($qNpwp);
$sql = "select * from " . $dbname . ".log_5supplier where supplierid='" . $bar->kodesupplier . "'";
//echo $sql;
$query = mysql_query($sql) or die(mysql_error());
$res = mysql_fetch_object($query);
$sql2 = "select namakaryawan from " . $dbname . ".datakaryawan where karyawanid='" . $bar->purchaser . "'";
$query2 = mysql_query($sql2) or die(mysql_error());
$res2 = mysql_fetch_object($query2);
$sql3 = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $bar->kodeorg . "'";
$query3 = mysql_query($sql3) or die(mysql_error());
$res3 = mysql_fetch_object($query3);
$norek_sup = isset($res->rekening) ? $res->rekening : '';
$kdBank = isset($res->bank) ? $res->bank : '';
$npwp_sup = isset($res->npwp) ? $res->npwp : '';
$an = isset($res->an) ? $res->an : '';
$nm_kary = isset($res2->namakaryawan) ? $res2->namakaryawan : '';
$nm_pt = isset($res3->namaorganisasi) ? $res3->namaorganisasi : '';
//data PO
$nopo = isset($bar->nopo) ? $bar->nopo : '';
$tglPo = isset($bar->tanggal) ? tanggalnormal($bar->tanggal) : '';
//data supplier
$nmSupplier = isset($res->namasupplier) ? $res->namasupplier : '';
$almtSupplier = isset($res->alamat) ? $res->alamat : '';
$tlpSupplier = isset($res->telepon) ? $res->telepon : '';
$faxSupplier = isset($res->fax) ? $res->fax : '';
$kota = isset($res->kota) ? $res->kota : '';
$cp = isset($res->kontakperson) ? $res->kontakperson : '';
$this->SetMargins(15, 10, 0);
$path = 'images/logo.jpg';
$this->Image($path, 15, 5, 0, 30);
$this->SetFont('Arial', 'B', 9);
$this->SetFillColor(255, 255, 255);
$this->SetX(55);
$this->Cell(60, 5, $namapt, 0, 1, 'L');
$this->SetX(55);
$this->Cell(60, 5, $alamatpt, 0, 1, 'L');
$this->SetX(55);
$this->Cell(60, 5, "Tel: " . $telp, 0, 1, 'L');
$this->SetFont('Arial', 'B', 7);
$this->SetX(55);
$this->Cell(60, 5, "NPWP: " . $rNpwp['npwp'], 0, 1, 'L');
$this->SetX(55);
$this->Cell(60, 5, $_SESSION['lang']['alamat'] . " NPWP: " . $rNpwp['alamatnpwp'], 0, 1, 'L');
$this->SetFont('Arial', 'B', 9);
$this->Line(15, 35, 205, 35);
$this->SetX(155);
$this->Cell(30, 10, "No. PO: " . $nopo, 0, 1, 'L');
}
$jumlah = checkPostGet('jumlah', '');
if ($jumlahhrd == '') {
$jumlahhrd = 0;
}
if ($method == 'update') {
$str = "update " . $dbname . ".sdm_pjdinasdt\r\n\t set jumlahhrd=" . $jumlahhrd . "\r\n\t where jenisbiaya=" . $jenisby . " and notransaksi='" . $notransaksi . "'\r\n\t\t and tanggal=" . $tanggal . " and jumlah='" . $jumlah . "'";
//echo "Error:".$str;
if (mysql_query($str)) {
} else {
echo " Gagal:" . addslashes(mysql_error($conn));
exit(0);
}
}
if ($method == 'finish') {
$str = "update " . $dbname . ".sdm_pjdinasht\r\n\t set statuspertanggungjawaban=1\r\n\t where notransaksi='" . $notransaksi . "'";
if (mysql_query($str)) {
} else {
echo " Gagal:" . addslashes(mysql_error($conn));
exit(0);
}
}
$str = "select a.*,b.keterangan as jns,b.id as bid from " . $dbname . ".sdm_pjdinasdt a\r\n left join " . $dbname . ".sdm_5jenisbiayapjdinas b on a.jenisbiaya=b.id\r\n\t where a.notransaksi='" . $notransaksi . "'";
$res = mysql_query($str);
$no = 0;
$total = 0;
while ($bar = mysql_fetch_object($res)) {
$no += 1;
echo "<tr class=rowcontent>\r\n\t \t<td>" . $no . "</td>\r\n\t\t <td>" . $bar->jns . "</td>\r\n <td>" . tanggalnormal($bar->tanggal) . "</td>\r\n\t\t\t<td>" . $bar->keterangan . "</td>\r\n\t\t\t<td align=right>" . number_format($bar->jumlah, 2, '.', '.') . "</td>\r\n\t\t\t<td align=right>\r\n\t\t\t<img src='images/puzz.png' style='cursor:pointer;' title='click to get value' onclick=\"document.getElementById('jumlahhrd" . $bar->bid . $no . "').value='" . $bar->jumlah . "'\">\r\n\t\t\t<input type=text id='jumlahhrd" . $bar->bid . $no . "' class=myinputtextnumber size=15 onkeypress=\"return angka_doang(event);\" onblur=change_number(this) value='" . number_format($bar->jumlahhrd, 2, '.', ',') . "'>\r\n\t\t\t<img src='images/save.png' title='Save' class=resicon onclick=saveApprvPJD('" . $bar->bid . "','" . $bar->notransaksi . "','" . tanggalnormal($bar->tanggal) . "','" . $bar->jumlah . "','" . $no . "')></td>\r\n\t\t\t</tr>";
$total += $bar->jumlah;
}
echo "<tr class=rowcontent>\r\n\t \t<td colspan=4 align=center>TOTAL</td>\r\n\t\t\t<td align=right>" . number_format($total, 2, '.', '.') . "</td>\r\n\t\t <td></td>\r\n\t\t\t</tr>";
