$dtAkhir = mktime($h, $m, $s, intval($mth), $dy, $thn);
$dtSelisih = $dtAkhir - $dtAwal;
//exit("Error:".$dtSelisih."___".$dtAkhir."___".$dtAwal."___".$mth."__".$dy."__".$thn);
$totalmenit = $dtSelisih / 60;
$jam = explode(".", $totalmenit / 60);
$sisamenit = $totalmenit / 60 - $jam[0];
$sisamenit2 = $sisamenit * 60;
$jml_jam = $jam[0];
//end ambil selisih waktu
$sUpdate = "update " . $dbname . ".it_request set jumlah='" . $jml_jam . "',waktuselesai='" . $tlgjmskrng . "',saranpelaksana='" . $saran . "'\r\n where notransaksi='" . $notransaksi . "'";
if (mysql_query($sUpdate)) {
#send an email to incharge person
$to = getUserEmail($rGet['karyawanid']);
$namakaryawan = getNamaKaryawan($rGet['karyawanid']);
$subject = "[Notifikasi]Permintaan layanan " . $rGet['keterangan'] . " a/n " . $namakaryawan;
$body = "<html>\r\n <head>\r\n <body>\r\n <dd>Dengan Hormat,</dd><br>\r\n <p align=justify>\r\n Permintaan layanan " . $rGet['keterangan'] . " pada tanggal " . tanggalnormal($rGet['tanggal']) . " oleh saudara ke departemen IT\r\n dengan deskripsi " . $rGet['deskripsi'] . ".\r\n <br>\r\n <br>\r\n Telah selesai dilaksanakan pada tanggal " . tanggalnormald($tlgjmskrng) . ", mohon kesediaan saudara untuk memberi penilaian terhadap layanan kami dari menuIT->Permintaan Layanan\r\n <br>\r\n <br>\r\n Regards,<br>\r\n Owl-Plantation System.\r\n </body>\r\n </head>\r\n </html>\r\n ";
$kirim = kirimEmail($to, '', $subject, $body);
#this has return but disobeying;
}
break;
case 'getDetail':
$sData = "select distinct * from " . $dbname . ".it_request where notransaksi='" . $notransaksi . "' ";
$qData = mysql_query($sData) or die(mysql_error($conn));
$rData = mysql_fetch_assoc($qData);
$dataTab .= "<div style=overflow:auto;width:420px;height:880px;>";
$dataTab .= "<fieldset><legend>" . $_SESSION['lang']['desc'] . "</legend>";
$dataTab .= "<div align=justify>" . $rData['deskripsi'] . "</p>";
$dataTab .= "</fieldset><br />";
$dataTab .= "<fieldset><legend>" . $_SESSION['lang']['saran'] . " " . $arrNmkary[$rData['karyawanid']] . " [user] </legend>";
$dataTab .= "<div align=justify>" . $rData['saranuser'] . "</p>";
$dataTab .= "</fieldset><br />";
$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();
?>
</td>
<td><?php
echo $arrNmkary[$rlvhc['persetujuan1']];
?>
</td>
<td><?php
echo $arrKeputusan[$rlvhc['stpersetujuan1']];
?>
</td>
<td><?php
echo tanggalnormald($rlvhc['darijam']);
?>
</td>
<td><?php
echo tanggalnormald($rlvhc['sampaijam']);
?>
</td>
<?php
if ($rlvhc['stpersetujuan1'] == 0 and $rlvhc['stpersetujuanrd'] == 0) {
echo "<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $rlvhc['keperluan'] . "','" . tanggalnormal($rlvhc['tanggal']) . "','" . $rlvhc['jenisijin'] . "','" . $rlvhc['persetujuan1'] . "','" . $rlvhc['stpersetujuan1'] . "','" . $rlvhc['darijam'] . "','" . $rlvhc['sampaijam'] . "','" . $rlvhc['hrd'] . "','" . $rlvhc['jumlahhari'] . "','" . $rlvhc['periodecuti'] . "');\">\r\n <img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delData('" . tanggalnormal($rlvhc['tanggal']) . "');\" ></td>";
//<img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_ijin','".$rlvhc['tanggal'].",".$rlvhc['karyawanid']."','','sdm_slave_ijin_meninggalkan_kantor',event)\">";
} else {
echo "<td>" . $arrKeputusan[$rlvhc['stpersetujuan1']] . "</td>";
// echo"<td> <img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_ijin','".$rlvhc['tanggal'].",".$rlvhc['karyawanid']."','','sdm_slave_ijin_meninggalkan_kantor',event)\"></td>";
}
?>
</tr>
<?php
case 'getData':
if ($periode == '0') {
$sql = "select a.*,b.* from " . $dbname . ".pabrik_rawatmesinht a left join " . $dbname . ".pabrik_rawatmesindt b on a.notransaksi=b.notransaksi \r\n where a.pabrik='" . $pbrkId . "' and a.statasiun='" . $statId . "' order by a.tanggal asc";
//echo"warning:".$sql;
} elseif ($periode != '0') {
$sql = "select a.*,b.* from " . $dbname . ".pabrik_rawatmesinht a left join " . $dbname . ".pabrik_rawatmesindt b on a.notransaksi=b.notransaksi \r\n where a.pabrik='" . $pbrkId . "' and a.statasiun='" . $statId . "' and tanggal like '%" . $periode . "%' order by a.tanggal asc";
}
$query = mysql_query($sql) or die(mysql_error());
echo "<div style=\"width:100%; height:300px; overflow:scroll;\">";
echo "<table cellspacing=1 border=0 width=1500px>\r\n <thead><tr class=rowheader>\r\n <td>No</td>\r\n <td>" . $_SESSION['lang']['notransaksi'] . "</td>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td>" . $_SESSION['lang']['kegiatan'] . "</td>\r\n <td>" . $_SESSION['lang']['jammulai'] . "</td>\r\n <td>" . $_SESSION['lang']['jamselesai'] . "</td>\r\n <td>" . $_SESSION['lang']['mesin'] . "</td>\r\n <td>" . $_SESSION['lang']['nmmesin'] . "</td>\r\n <td>" . $_SESSION['lang']['kodebarang'] . "</td>\r\n <td>" . $_SESSION['lang']['namabarang'] . "</td>\r\n <td>" . $_SESSION['lang']['satuan'] . "</td>\r\n <td>" . $_SESSION['lang']['jumlah'] . "</td>\r\n <td>" . $_SESSION['lang']['keterangan'] . "</td></tr></thead><tbody>";
while ($res = mysql_fetch_assoc($query)) {
$sBrg = "select namabarang,kodebarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $res['kodebarang'] . "'";
$qBrg = mysql_query($sBrg) or die(mysql_error());
$rBrg = mysql_fetch_assoc($qBrg);
$no += 1;
echo "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $res['notransaksi'] . "</td>\r\n <td>" . tanggalnormal($res['tanggal']) . "</td>\r\n <td>" . $res['kegiatan'] . "</td>\r\n <td>" . tanggalnormald($res['jammulai']) . "</td>\r\n <td>" . tanggalnormald($res['jamselesai']) . "</td>\r\n <td>" . $res['mesin'] . "</td>\r\n <td>" . $optNmMsn[$res['mesin']] . "</td>\r\n <td>" . $res['kodebarang'] . "</td>\r\n <td>" . $rBrg['namabarang'] . "</td>\r\n <td>" . $res['satuan'] . "</td>\r\n <td>" . $res['jumlah'] . "</td>\r\n <td>" . $res['keterangan'] . "</td>\r\n </tr>";
}
echo "</tbody></table></div>";
break;
case 'get_result_cari':
$sql = "select a.*,b.* from " . $dbname . ".pabrik_rawatmesinht a inner join " . $dbname . ".pabrik_rawatmesindt b on a.notransaksi=b.notransaksi \r\n where a.pabrik='" . $pbrkId . "' and tanggal like '%" . $periode . "%' and b.kodebarang='" . $kdBrg . "' order by a.tanggal asc";
//echo"warning:".$sql;
$query = mysql_query($sql) or die(mysql_error());
echo "<div style=\"width:850px; height:300px; overflow:auto;\">";
echo "<table cellspacing=1 border=0>\r\n <thead><tr class=rowheader>\r\n <td>No</td>\r\n <td>" . $_SESSION['lang']['notransaksi'] . "</td>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td>" . $_SESSION['lang']['mesin'] . "</td>\r\n </thead><tbody>";
while ($res = mysql_fetch_assoc($query)) {
$no += 1;
echo "<tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $res['notransaksi'] . "</td>\r\n <td>" . tanggalnormal($res['tanggal']) . "</td>\r\n <td>" . $res['mesin'] . "</td>\r\n </tr>";
}
echo "</tbody></table></div>";
break;
$query = mysql_query($sql) or die(mysql_error());
while ($jsl = mysql_fetch_object($query)) {
$jlhbrs = $jsl->jmlhrow;
}
if ($res = mysql_query($strx)) {
$numrows = mysql_num_rows($res);
if ($numrows < 1) {
echo "<tr class=rowcontent><td colspan=9>Not Found</td></tr>";
} else {
while ($rlvhc = mysql_fetch_assoc($res)) {
$dtJamMulai = explode(" ", $rlvhc['jammulai']);
$jamMulai = explode(":", $dtJamMulai[1]);
$dtJamSlsi = explode(" ", $rlvhc['jamselesai']);
$jamSlsi = explode(":", $dtJamSlsi[1]);
$no += 1;
echo "\r\n <tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . $rlvhc['notransaksi'] . "</td>\r\n <td>" . tanggalnormal($rlvhc['tanggal']) . "</td>\r\n <td>" . $rlvhc['shift'] . "</td>\r\n <td>" . $rlvhc['statasiun'] . "</td>\r\n <td>" . $rlvhc['mesin'] . "</td>\r\n <td>" . tanggalnormald($rlvhc['jammulai']) . "</td>\r\n <td>" . tanggalnormald($rlvhc['jamselesai']) . "</td>";
if ($rlvhc['updateby'] == $userOnline) {
echo "<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $rlvhc['notransaksi'] . "','" . tanggalnormal($rlvhc['tanggal']) . "','" . $rlvhc['pabrik'] . "','" . $rlvhc['shift'] . "','" . $rlvhc['statasiun'] . "','" . $rlvhc['mesin'] . "','" . $rlvhc['kegiatan'] . "','" . tanggalnormal($dtJamMulai[0]) . "','" . tanggalnormal($dtJamSlsi[0]) . "','" . $jamMulai[0] . "','" . $jamMulai[1] . "','" . $jamSlsi[0] . "','" . $jamSlsi[1] . "');\">\r\n <img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delData('" . $rlvhc['notransaksi'] . "');\" >\r\n <img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('pabrik_rawatmesinht','" . $rlvhc['notransaksi'] . "','','pabrik_slavePemeliharaanPdf',event)\"></td>";
} else {
echo "\r\n <td><img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('pabrik_rawatmesinht','" . $rlvhc['notransaksi'] . "','','pabrik_slavePemeliharaanPdf',event)\"></td>";
}
}
echo "\r\n </tr><tr class=rowheader><td colspan=9 align=center>\r\n " . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "<br />\r\n <button class=mybutton onclick=cariBast(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n <button class=mybutton onclick=cariBast(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n </td>\r\n </tr>";
}
} else {
echo "Gagal," . mysql_error($conn);
}
break;
case 'deletData':
$sDel = "delete from " . $dbname . ".pabrik_rawatmesinht where notransaksi='" . $noTrans . "'";
if (mysql_query($sDel)) {
} else {
$tmbhBrs = 45;
$tmbhBrs2 = 65;
$tmbhBrs3 = 55;
$tmbhBrs5 = 95;
}
# kalo terlalu ke bawah, pindah halaman aja
if ($akhirY >= 175) {
$akhirY = 0;
$pdf->AddPage();
}
# $dz
$pdf->SetY($akhirY + $tmbhBrs);
$pdf->SetFont('Arial', '', 8);
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(126, 5, $_SESSION['lang']['tgl_kirim'] . ": " . tanggalnormald($rlopoht->tanggalkirim), 0, 1, 'L', 0);
$pdf->Cell(126, 5, $_SESSION['lang']['almt_kirim'] . ": " . $rlopoht->lokasipengiriman, 0, 1, 'L', 0);
$pdf->Cell(126, 5, $_SESSION['lang']['syaratPem'] . ": " . $rlopoht->syaratbayar, 0, 1, 'L', 0);
$pdf->Cell(126, 5, $_SESSION['lang']['norekeningbank'] . ": " . $norek_sup, 0, 1, 'L', 0);
$pdf->Cell(126, 5, $_SESSION['lang']['npwp'] . ": " . $npwp_sup, 0, 1, 'L', 0);
$pdf->Cell(126, 5, $_SESSION['lang']['purchaser'] . ": " . $nm_kary, 0, 1, 'L', 0);
$pdf->Cell(190, 4, $namapt, 0, 0, 'R');
$pdf->SetY($akhirY + $tmbhBrs5);
$sPo = "select persetujuan1,persetujuan2 from " . $dbname . ".log_poht where nopo='" . $nopo . "'";
$qPo = mysql_query($sPo) or die(mysql_error($conn));
$rPo = mysql_fetch_assoc($qPo);
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(10, 4, strtoupper($_SESSION['lang']['purchaser']) . ": " . strtoupper($nm_kary), 0, 0, 'L', 0);
$pdf->SetFont('Arial', '', 8);
$sql_kry = "select namakaryawan, b.namajabatan from " . $dbname . ".datakaryawan a inner join " . $dbname . ".sdm_5jabatan b on a.kodejabatan=b.kodejabatan where a.karyawanid='" . $user_release . "' ";
//echo $sql_kry;
function Header()
{
global $conn;
global $dbname;
global $userid;
global $noTrans;
global $rtgl;
global $shift;
global $sts;
global $msn;
global $jmMulai;
global $jmAkhir;
global $kegiatan;
global $posting;
$noTrans = $_GET['column'];
$sql = "select * from " . $dbname . "." . $_GET['table'] . " where notransaksi='" . $noTrans . "' ";
// echo $sql; exit();
//echo $str;exit();
$res = mysql_query($sql);
$bar = mysql_fetch_object($res);
$rtgl = tanggalnormal($bar->tanggal);
$shift = $bar->shift;
$sts = $bar->statasiun;
$msn = $bar->mesin;
$jmMulai = tanggalnormald($bar->jammulai);
$jmAkhir = tanggalnormald($bar->jamselesai);
$kegiatan = $bar->kegiatan;
$posting = $bar->statPost;
$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;
}
$kdDiv = substr($noTrans, 5, 6);
$str = "select namaorganisasi from " . $dbname . ".organisasi where kodeorganisasi='" . $kdDiv . "'";
$namapt = 'COMPANY NAME';
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$namapt = strtoupper($bar->namaorganisasi);
}
$path = 'images/logo.jpg';
$this->Image($path, 15, 5, 0, 25);
$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->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 13);
$this->Cell(190, 5, strtoupper($_SESSION['lang']['pemeliharaanMesin']), 0, 1, 'C');
$this->Ln();
if ($posting < 1) {
$this->Cell(190, 5, $_SESSION['lang']['belumposting'], 0, 1, 'C');
}
$this->SetFont('Arial', 'B', 8);
$this->Cell(20, 5, $namapt, '', 1, 'L');
$this->SetFont('Arial', '', 8);
$this->Cell(35, 5, $_SESSION['lang']['notransaksi'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(100, 5, $noTrans, '', 0, 'L');
$this->Cell(15, 5, $_SESSION['lang']['tanggal'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, $rtgl, 0, 1, 'L');
// $this->Cell(140,5,' ','',0,'R');
$this->Cell(35, 5, $_SESSION['lang']['shift'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(100, 5, $shift, '', 0, 'L');
$this->Cell(15, 5, $_SESSION['lang']['statasiun'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, $sts, '', 1, 'L');
// $this->Cell(140,5,' ','',0,'R');
$this->Cell(35, 5, $_SESSION['lang']['dari'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(100, 5, $jmMulai, '', 0, 'L');
$this->Cell(15, 5, $_SESSION['lang']['sampai'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, $jmAkhir, '', 1, 'L');
// $this->Ln();
$this->Cell(35, 5, $_SESSION['lang']['mesin'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(100, 5, $msn, '', 0, 'L');
$this->Cell(15, 5, 'User', '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(35, 5, $_SESSION['standard']['username'], '', 1, 'L');
$this->Line(10, 30, 205, 30);
$this->Cell(35, 5, $_SESSION['lang']['kegiatan'], '', 0, 'L');
$this->Cell(2, 5, ':', '', 0, 'L');
$this->Cell(100, 5, $kegiatan, '', 0, 'L');
$this->Ln();
}
$page = 0;
}
}
$offset = $page * $limit;
$ql2 = "select count(*) as jmlhrow from " . $dbname . ".sdm_ijin where karyawanid='" . $_SESSION['standard']['userid'] . "' order by `tanggal` desc";
// echo $ql2;
$query2 = mysql_query($ql2) or die(mysql_error());
while ($jsl = mysql_fetch_object($query2)) {
$jlhbrs = $jsl->jmlhrow;
}
$slvhc = "select * from " . $dbname . ".sdm_ijin where karyawanid='" . $_SESSION['standard']['userid'] . "' order by `tanggal` desc limit " . $offset . "," . $limit . " ";
$qlvhc = mysql_query($slvhc) or die(mysql_error());
$user_online = $_SESSION['standard']['userid'];
while ($rlvhc = mysql_fetch_assoc($qlvhc)) {
$no += 1;
echo "\r\n <tr class=rowcontent>\r\n <td>" . $no . "</td>\r\n <td>" . tanggalnormal($rlvhc['tanggal']) . "</td>\r\n <td>" . $rlvhc['keperluan'] . "</td>\r\n <td>" . $rlvhc['jenisijin'] . "</td>\r\n <td>" . $arrNmkary[$rlvhc['persetujuan1']] . "</td>\r\n <td>" . $arrKeputusan[$rlvhc['stpersetujuan1']] . "</td>\r\n <td>" . tanggalnormald($rlvhc['darijam']) . "</td>\r\n <td>" . tanggalnormald($rlvhc['sampaijam']) . "</td>";
if ($rlvhc['stpersetujuan1'] == 0 and empty($rlvhc['stpersetujuanrd'])) {
echo "<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $rlvhc['keperluan'] . "','" . tanggalnormal($rlvhc['tanggal']) . "','" . $rlvhc['jenisijin'] . "','" . $rlvhc['persetujuan1'] . "','" . $rlvhc['stpersetujuan1'] . "','" . $rlvhc['darijam'] . "','" . $rlvhc['sampaijam'] . "','" . $rlvhc['hrd'] . "','" . $rlvhc['jumlahhari'] . "','" . $rlvhc['periodecuti'] . "');\">\r\n <img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delData('" . tanggalnormal($rlvhc['tanggal']) . "');\" ></td>";
//<img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_ijin','".$rlvhc['tanggal'].",".$rlvhc['karyawanid']."','','sdm_slave_ijin_meninggalkan_kantor',event)\"></td>";
} else {
echo "<td>" . $arrKeputusan[$rlvhc['stpersetujuan1']] . "</td>";
// echo"<td> <img src=images/pdf.jpg class=resicon title='Print' onclick=\"masterPDF('sdm_ijin','".$rlvhc['tanggal'].",".$rlvhc['karyawanid']."','','sdm_slave_ijin_meninggalkan_kantor',event)\"></td>";
}
//end if updateby
}
//end while
echo "\r\n </tr><tr class=rowheader><td colspan=9 align=center>\r\n " . ($page * $limit + 1) . " to " . ($page + 1) * $limit . " Of " . $jlhbrs . "<br />\r\n <button class=mybutton onclick=cariBast(" . ($page - 1) . ");>" . $_SESSION['lang']['pref'] . "</button>\r\n <button class=mybutton onclick=cariBast(" . ($page + 1) . ");>" . $_SESSION['lang']['lanjut'] . "</button>\r\n </td>\r\n </tr>";
break;
case 'getKet':
$sket = "select distinct keterangan from " . $dbname . ".sdm_ijin where " . $where . "";
$qKet = mysql_query($sket) or die(mysql_error($conn));
$ql2 = "select count(*) as jmlhrow from " . $dbname . ".sdm_ruangrapat " . $whr . " order by `id` desc";
// echo $ql2;
$query2 = mysql_query($ql2) or die(mysql_error());
while ($jsl = mysql_fetch_object($query2)) {
$jlhbrs = $jsl->jmlhrow;
}
$no = 0;
$str = "select * from " . $dbname . ". sdm_ruangrapat " . $whr . " order by id desc";
//echo $str;
$res = mysql_query($str);
$rowd = mysql_num_rows($res);
if ($rowd == 0) {
echo "<tr class=rowcontent><td colspan=8>" . $_SESSION['lang']['dataempty'] . "</td></tr>";
} else {
while ($bar = mysql_fetch_assoc($res)) {
echo "<tr class=rowcontent>\r\n <td>" . $bar['tanggal'] . "</td>\r\n <td>" . $bar['roomname'] . "</td>\r\n <td>" . tanggalnormald($bar['mulai']) . "</td>\r\n <td>" . tanggalnormald($bar['sampai']) . "</td>\r\n <td>" . $bar['agenda'] . "</td>\r\n <td>" . $optNm[$bar['pic']] . "</td>\r\n <td>" . $optNm[$bar['reservedby']] . "</td>\r\n <td>" . $bar['status'] . "</td>\r\n <td>" . $bar['reservetime'] . "</td>\r\n\r\n </tr>";
}
echo "\r\n </tr><tr class=rowheader><td colspan=8 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>";
}
break;
case 'updateData':
$sUpd = "update " . $dbname . ".sdm_ruangrapat set `tanggal`='" . $tanggalDt . "',`mulai`='" . $jamDr1 . "',`sampai`='" . $jamSmp1 . "'\r\n ,`agenda`='" . $agenda . "',`roomname`='" . $room . "',`reservedby`='" . $_SESSION['standard']['userid'] . "',`pic`='" . $pic . "'\r\n where id='" . $idData . "'";
if (!mysql_query($sUpd)) {
echo "Gagal" . mysql_error($conn);
}
break;
case 'kancelDat':
$sUpd = "update " . $dbname . ".sdm_ruangrapat set `status`='Canceled'\r\n where id='" . $idData . "'";
if (!mysql_query($sUpd)) {
echo "Gagal" . mysql_error($conn);
}
exit;
}
break;
case 'load_data':
//echo "warning:Masuk";
$str = "select * from " . $dbname . ".pabrik_5jampengolahan order by koderorg desc";
//echo "warning:".$str;exit();
if ($res = mysql_query($str)) {
while ($bar = mysql_fetch_object($res)) {
$noakun = $bar->noakun;
$spr = "select * from " . $dbname . ".organisasi where kodeorganisasi='" . $bar->koderorg . "'";
$rep = mysql_query($spr) or die(mysql_error($conn));
$bas = mysql_fetch_object($rep);
$no += 1;
//echo $minute_selesai; exit();
echo "<tr class=rowcontent id='tr_" . $no . "'>\r\n\t\t<td>" . $no . "</td>\r\n\t\t<td id='nmorg_" . $no . "'>" . $bas->namaorganisasi . "</td>\r\n\t\t<td id='kpsits_" . $no . "'>" . $bar->kapasitasolah . "</td>\r\n\t\t<td id='strt_" . $no . "'>" . tanggalnormald($bar->jammulai) . "</td>\r\n\t\t<td id='end_" . $no . "'>" . tanggalnormald($bar->jamselesai) . "</td>\r\n\t\t<td id='tglex_" . $no . "'>" . tanggalnormald($bar->berlakusampai) . "</td>\r\n\t\t<td id='kplori_" . $no . "'>" . $bar->kapasitaslori . "</td>\r\n\t\t<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('" . $bar->koderorg . "','" . $bar->kapasitasolah . "','" . tanggalnormald($bar->jammulai) . "','" . tanggalnormald($bar->jamselesai) . "','" . tanggalnormald($bar->berlakusampai) . "','" . $bar->kapasitaslori . "');\"></td>\r\n\t\t<td><img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delJampeng('" . $bar->koderorg . "');\"></td>\r\n\t\t</tr>";
}
} else {
echo " Gagal," . mysql_error($conn);
}
break;
default:
break;
}
/* if(mysql_query($strx))
{}
else
{
echo " Gagal,".addslashes(mysql_error($conn));
}
$nil_diskon = $rlopoht->nilaidiskon; $nppn = $rlopoht->ppn; $stat_release = $rlopoht->stat_release; $user_release = $rlopoht->useridreleasae; $gr_total = $sb_tot - $nil_diskon + $nppn; $pdf->Cell(168, 5, $_SESSION['lang']['subtotal'], 1, 0, 'C', 1); $pdf->Cell(25, 5, number_format($rlopoht->subtotal, 2, '.', ','), 1, 1, 'R', 1); $pdf->Cell(168, 5, 'Discount(%)', 1, 0, 'C', 1); $pdf->Cell(25, 5, $rlopoht->diskonpersen, 1, 1, 'R', 1); $pdf->Cell(168, 5, 'PPh/PPn(%)', 1, 0, 'C', 1); $pdf->Cell(25, 5, number_format($rlopoht->ppn, 2, '.', ','), 1, 1, 'R', 1); $pdf->Cell(168, 5, $_SESSION['lang']['grnd_total'], 1, 0, 'C', 1); $pdf->Cell(25, 5, number_format($gr_total, 2, '.', ','), 1, 1, 'R', 1); $pdf->Ln(); $pdf->Cell(30, 4, $_SESSION['lang']['tgl_kirim'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . tanggalnormald($rlopoht->tanggalkirim), 0, 1, 'L'); $pdf->Cell(30, 4, $_SESSION['lang']['almt_kirim'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $rlopoht->lokasipengiriman, 0, 1, 'L'); $pdf->Cell(30, 4, $_SESSION['lang']['syaratPem'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $rlopoht->syaratbayar, 0, 1, 'L'); $pdf->Cell(30, 4, $_SESSION['lang']['norekeningbank'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $norek_sup, 0, 1, 'L'); $pdf->Cell(30, 4, $_SESSION['lang']['npwp'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $npwp_sup, 0, 1, 'L'); $pdf->Cell(30, 4, $_SESSION['lang']['purchaser'], 0, 0, 'L'); $pdf->Cell(40, 4, ": " . $nm_kary, 0, 1, 'L'); $pdf->Ln(); $pdf->Ln(); $pdf->Cell(193, 4, $nm_pt, 0, 0, 'R'); //$pdf->MultiCell(170,5,"Note: ".$_SESSION['lang']['note_permintaan'],0,'L'); //footer================================
$strx = "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";
}
//echo"warning:".$strx;
$stream .= "<table><tr><td colspan=11 align=center>" . $_SESSION['lang']['pemeliharaanMesinReport'] . "</td></tr>\r\n\t\t\t<tr><td colspan=3>" . $_SESSION['lang']['pabrik'] . ":" . $namapt . "</td><td colspan=2> </td>\r\n\t\t\t<td colspan=3>" . $_SESSION['lang']['statasiun'] . ":" . $rNm['namaorganisasi'] . "</td></tr>\r\n\t\t\t";
if ($periode != '0') {
$stream .= "<tr><td colspan=3>" . $_SESSION['lang']['periode'] . ":" . $periode . "</td></tr>";
}
$stream .= "</table>\r\n\t\t\t<table border=1>\r\n\t\t\t\t\t\t<tr>\r\n <td bgcolor=#DEDEDE align=center>No.</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['notransaksi'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['kegiatan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jammulai'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jamselesai'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['kodebarang'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['namabarang'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['satuan'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['jumlah'] . "</td>\t\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['shift'] . "</td>\t\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['mesin'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['nmmesin'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['keterangan'] . "</td>\r\n\t\t\t\t\t\t</tr>";
$resx = mysql_query($strx);
$no = 0;
while ($barx = mysql_fetch_assoc($resx)) {
$no += 1;
$sBrg = "select namabarang,kodebarang from " . $dbname . ".log_5masterbarang where kodebarang='" . $barx['kodebarang'] . "'";
$qBrg = mysql_query($sBrg) or die(mysql_error());
$rBrg = mysql_fetch_assoc($qBrg);
$stream .= "\t<tr class=rowcontent>\r\n\t\t\t\t<td>" . $no . "</td>\r\n\t\t\t\t<td>" . $barx['notransaksi'] . "</td>\r\n\t\t\t\t<td>" . tanggalnormal($barx['tanggal']) . "</td>\r\n <td>" . $barx['kegiatan'] . "</td>\r\n <td>" . tanggalnormald($barx['jammulai']) . "</td>\r\n <td>" . tanggalnormald($barx['jamselesai']) . "</td>\r\n\t\t\t\t<td>" . $barx['kodebarang'] . "</td>\r\n\t\t\t\t<td>" . $rBrg['namabarang'] . "</td>\r\n\t\t\t\t<td>" . $barx['satuan'] . "</td>\r\n\t\t\t\t<td>" . $barx['jumlah'] . "</td>\r\n\t\t\t\t<td>" . $barx['shift'] . "</td>\t\r\n\t\t\t\t<td>" . $barx['mesin'] . "</td>\t\r\n\t\t\t\t<td>" . $optNmMsn[$barx['mesin']] . "</td>\r\n <td>" . $barx['keterangan'] . "</td>\r\n\t\t\t\t</tr>";
}
//echo "warning:".$strx;
//=================================================
$stream .= "</table>Print Time:" . date('YmdHis') . "<br>By:" . $_SESSION['empl']['name'];
$nop_ = "ReportPemeliharaanMesin";
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');
$pdf->Cell(35, 4, $bar->hasil, 0, 0, 'L', 0);
$pdf->MultiCell(95, 4, $bar->catatan, 0, 'J');
}
$pdf->Cell(30, 4, $_SESSION['lang']['keputusan'] . " " . $_SESSION['lang']['interviewer'], 1, 0, 'L', 0);
$pdf->Cell(160, 4, $rdrTest['hasiliview'], 1, 1, 'L', 0);
$pdf->Ln(10);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(25, 5, strtoupper($_SESSION['lang']['psikotest']) . " :", 0, 1, 'L');
$pdf->SetFont('Arial', '', 7);
$pdf->SetFillColor(220, 220, 220);
$pdf->Cell(30, 4, $_SESSION['lang']['tanggal'], 1, 0, 'C', 1);
$pdf->Cell(25, 4, $_SESSION['lang']['provider'], 1, 0, 'C', 1);
$pdf->Cell(25, 4, $_SESSION['lang']['namaprovider'], 1, 0, 'C', 1);
$pdf->Cell(35, 4, $_SESSION['lang']['hasil'], 1, 0, 'C', 1);
$pdf->Cell(75, 4, $_SESSION['lang']['catatan'], 1, 1, 'C', 1);
$pdf->Cell(30, 4, tanggalnormald($rdrTest['tglpsy']), 'B', 0, 'L', 0);
$pdf->Cell(25, 4, $rdrTest['provider'], 'B', 0, 'L', 0);
$pdf->Cell(25, 4, $rdrTest['namaprovider'], 'B', 0, 'L', 0);
$pdf->Cell(35, 4, $rdrTest['hasilpsy'], 'B', 0, 'L', 0);
$pdf->MultiCell(75, 4, $rdrTest['keteranganpsy'], 'B', 'J');
$pdf->Ln(10);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Cell(25, 5, strtoupper("medical") . " :", 0, 1, 'L');
$pdf->SetFont('Arial', '', 7);
$pdf->SetFillColor(220, 220, 220);
$pdf->Cell(30, 4, $_SESSION['lang']['tanggal'], 1, 0, 'C', 1);
$pdf->Cell(30, 4, $_SESSION['lang']['provider'], 1, 0, 'C', 1);
$pdf->Cell(35, 4, $_SESSION['lang']['hasil'], 1, 0, 'C', 1);
$pdf->Cell(95, 4, $_SESSION['lang']['catatan'], 1, 1, 'C', 1);
//loop isinya
$pdf->Cell(30, 4, tanggalnormal($rdrTest['tglmedical']), 'B', 0, 'L', 0);
