本文整理汇总了PHP中tanggalnormal函数的典型用法代码示例。如果您正苦于以下问题：PHP tanggalnormal函数的具体用法？PHP tanggalnormal怎么用？PHP tanggalnormal使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了tanggalnormal函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: Header
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();
}示例2: Header
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);*/
}示例3: count
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 . "'";示例4: while
$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');示例5: Header
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);
}示例6: while
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>";示例7: Header
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);
}示例8: mysql_query
$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);
}示例9: addslashes
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>";
}示例10: mysql_query
$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));示例11: count
$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:
}示例12: mysql_query
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>";
}示例13: Header
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);
}示例14: Header
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);
}
}示例15: while
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 = '';