<?php
session_start();
$var_form="lapkaryawan";
include "../Function/fnc_MoneySeparator.php";
include "../Function/fnc_MoneyTerbilang.php";
include "../Config/cfg_Koneksi.php";
include "../Function/fnc_TimeoutSession.php";
include "../Function/fnc_ResetForm.php";
define('FPDF_FONTPATH','../Component/fpdf/font/');
require('../Component/fpdf/fpdf.php');

if (!empty($_SESSION['username']))
{
$var_bulanaktif=$_SESSION['bulan'];
$var_tahunaktif=$_SESSION['tahun'];
if ((!empty($_POST['tanggalawal'])) && (!empty($_POST['tanggalakhir'])))
{
$var_tanggalawal=date("Y-m-d",strtotime($_POST['tanggalawal']));
$var_tanggalakhir=date("Y-m-d",strtotime($_POST['tanggalakhir']));

$var_tanggalawalcetak=date("d-m-Y",strtotime($_POST['tanggalawal']));
$var_tanggalakhircetak=date("d-m-Y",strtotime($_POST['tanggalakhir']));

$var_tanggal=date("Y-m-d");
$var_Query = "select * from tab_obat as a, tab_jeniskemasan as b, tab_dpengadaan as c, tab_hpengadaan as d, tab_penerimaan as e, tab_sumberdana as f where a.fld_kodejeniskemasan=b.fld_kodejeniskemasan and a.fld_kodeobat=c.fld_kodeobat and c.fld_kodepengadaan=d.fld_kodepengadaan and d.fld_kodepenerimaan=e.fld_kodepenerimaan and d.fld_kodesumberdana=f.fld_kodesumberdana and (d.fld_tglmasuk between '$var_tanggalawal' and '$var_tanggalakhir') order by a.fld_namaobat asc";
class PDF extends FPDF {
function Header() {
$this->SetFont('Arial','B',10);
$this->Cell(10,1,'Laporan Pengadaan Barang','',0,'C');
$this->Cell(10,2,'Periode Tanggal '.$var_tanggalawalcetak.' S/D '.$var_tanggalakhircetak.'','',0,'C');
$this->Cell(10,3,'Tahun Anggaran : '.$var_tahunaktif.'','',0,'C');
$this->Ln();
$this->SetFont('Arial','B',6);
$this->SetFillColor(0,0,0);
$this->SetTextColor(255);
$this->Cell(1,0.5,'No',1,0,'C',1);
$this->Cell(2,0.5,'Kode Pengadaan',1,0,'C',1);
$this->Cell(2,0.5,'Kode Barang',1,0,'C',1);
$this->Cell(4,0.5,'Nama Barang',1,0,'C',1);
$this->Cell(2,0.5,'Kemasan',1,0,'C',1);
$this->Cell(2,0.5,'Jenis Barang',1,0,'C',1);
$this->Cell(2,0.5,'Sumber Penerimaan',1,0,'C',1);
$this->Cell(2,0.5,'Sumber Dana',1,0,'C',1);
$this->Cell(2,0.5,'Tanggal Masuk',1,0,'C',1);
$this->Cell(2,0.5,'Tanggal Expired',1,0,'C',1);
$this->Cell(2,0.5,'Status',1,0,'C',1);
$this->Cell(2,0.5,'Keterangan',1,0,'C',1);
$this->Cell(2,0.5,'Stock',1,0,'C',1);
$this->Cell(2,0.5,'Sisa Stock',1,0,'C',1);
$this->Cell(2,0.5,'Harga',1,0,'C',1);
$this->Cell(2,0.5,'Total Harga',1,0,'C',1);
$this->Cell(2,0.5,'Total Harga Sisa Stock',1,0,'C',1);
$this->Ln();
}
function Footer() {
$this->SetY(-1.5);
$this->SetFont('Arial','I',6);
$this->Cell(0,1,'Halaman : '.$this->PageNo(),0,0,'L');
}
}
$var_No = 0;
$var_SQL=mysql_query($var_Query);
$var_Jml=mysql_num_rows($var_SQL);
if ($var_Jml <> 0)
{
$var_PDF=new PDF('L','cm','A4');
$var_PDF->open();
$var_PDF->AddPage();
$var_PDF->SetFont('Arial','',5);
$var_PDF->SetFillColor(224,235,255);
$var_PDF->SetTextColor(0);
$var_Color = 0;
$var_stocked=0;
$var_totalhargaed=0;
while ($var_Record=mysql_fetch_array($var_SQL))
{
$var_No++;
$var_PDF->Cell(1,0.5,$var_No,'LRUB',0,'R',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_kodepengadaan'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_kodeobat'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(4,0.5,$var_Record['fld_namaobat'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_jeniskemasan'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_jenisobat'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_penerimaan'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_sumberdana'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,date("d-m-Y",strtotime($var_Record['fld_tglmasuk'])),'LRUB',0,'C',$var_Color);
$var_PDF->Cell(2,0.5,date("d-m-Y",strtotime($var_Record['fld_tglexpired'])),'LRUB',0,'C',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_status'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_keterangan'],'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,$var_Record['fld_jumlah'],'LRUB',0,'L',$var_Color);
$var_cmdqueryinv="select * from tab_inventory where fld_kodepengadaan='$var_Record[fld_kodepengadaan]'";
$var_cmdhasilinv=mysql_query($var_cmdqueryinv);
while ($var_recordinv=mysql_fetch_array($var_cmdhasilinv))
{
$var_sisastock=$var_recordinv['fld_sisastok'];
}
$var_PDF->Cell(2,0.5,$var_sisastock,'LRUB',0,'L',$var_Color);
$var_PDF->Cell(2,0.5,'Rp. '.format_angka($var_Record['fld_harga']),'LRUB',0,'R',$var_Color);
$var_PDF->Cell(2,0.5,'Rp. '.format_angka($var_Record['fld_jumlah']*$var_Record['fld_harga']),'LRUB',0,'R',$var_Color);
$var_PDF->Cell(2,0.5,'Rp. '.format_angka($var_sisastock*$var_Record['fld_harga']),'LRUB',0,'R',$var_Color);
$var_PDF->lN();
}
}
$var_PDF->Output();
exit;
}
else
{
echo "
<html>
<head>
<meta http-equiv='Content-Type' content='text/html'; 'charset=iso-8859-1' />
<link rel='stylesheet' type='text/css' href='../Component/css/style.css'>
[removed][removed]

<title>-:: Ketersediaan Obat Instalasi Farmasi Dinas Kesehatan Provinsi Kalimantan Tengah Application ::-</title>
</head>
<body bgcolor=#F5FAF9>
<center>
<table width='100%' class='outter'>
<tr>
<td>
<table class='text' border='0' cellpadding='4' cellspacing='3' width='100%'>
<tr height='40px'>
<td colspan='2' class='formHeading'>Laporan Pengadaan Barang</td>
</tr>
<tr>
<td colspan='2' class='note' bgcolor='#E0F0E8'>Field yg diberi tanda <span style='color:#FF0000'>*</span> harus diisi</td>
</tr>
<tr height='10px'>
<td colspan='2'></td>
</tr>
<FORM METHOD=POST ACTION='lap_Pengadaan.php'>
<tr>
<td align='right' width='32%'>Tanggal Awal : </td>
<td align='left' width='68%'>";
?>
<input type='Text' id='demo1' name='tanggalawal' maxlength='20' size='20' value=<?PHP if(!empty($_POST['tanggalawal'])) {echo $_POST['tanggalawal'];}?>>
<a href="[removed]NewCal('demo1','ddmmmyyyy',true,24)"><img src="../Images/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a>

<?php
echo " </td>
</tr>
<tr>
<td align='right' width='32%'>Tanggal Akhir : </td>
<td align='left' width='68%'>";
?>
<input type='Text' id='demo2' name='tanggalakhir' maxlength='20' size='20' value=<?PHP if(!empty($_POST['tanggalakhir'])) {echo $_POST['tanggalakhir'];}?>>
<a href="[removed]NewCal('demo2','ddmmmyyyy',true,24)"><img src="../Images/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a>

<?php
echo " </td>
</tr>
<tr>
<td></td>
<td align='left'><input type='submit' name='tombol' value='Tampilkan'></td>
</tr>
</form>
<tr height='10px'>
<td colspan='2'></td>
</tr>
</table>
<table class='text' border='0' cellpadding='4' cellspacing='3' width='100%'>
<tr>
<td colspan='2' class='note' align=left> Bulan Aktif : ".$_SESSION['bulan']." Tahun Aktif : ".$_SESSION['tahun']."</td>";
echo "<td colspan='2' class='note' align=right>".getcwd()."</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>";
}
}
else
{
print "[removed]";
print "window.top.location = '../Index.php' ";
print "[removed]";
}
?>