PHP jmlpeg_bulan Exemples

Exemple #1

Fichier : rekap_penerima_prn.php Projet : abbeet/server39

        $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2);
        $pdf->Cell($w1[5], $ln, $arrTerima[$i], 'LR', 1, 'R');
    }
    if ($pdf->GetY() >= 180) {
        $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 3, $pdf->GetY());
        $pdf->AddPage();
        $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 3, $pdf->GetY());
    } else {
        $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 3, $pdf->GetY());
    }
}
$pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2, $pdf->GetY());
$pdf->SetFont($font, 'B', $size);
$pdf->SetX($margin);
$pdf->Cell($w1[0] + $w1[1], $ln * 2, 'Jumlah', 'LR', 0, 'C');
$pdf->Cell($w1[2], $ln * 2, jmlpeg_bulan($th, $kdbulan, $kdsatker), 'LR', 0, 'C');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$pdf->Cell($w1[5], $ln * 2, number_format($total_tunker, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5]);
$pdf->Cell($w1[4], $ln * 2, number_format($total_pajak, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$pdf->Cell($w1[5], $ln * 2, number_format($total_tunker + $total_pajak, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2);
$pdf->Cell($w1[4], $ln * 2, number_format($total_pajak, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 2 + $w1[5] * 2);
$pdf->Cell($w1[4], $ln * 2, number_format($total_tunker - $total_terima, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 3 + $w1[5] * 2);
$pdf->Cell($w1[4], $ln * 2, number_format($total_tunker - $total_terima + $total_pajak, "0", ",", "."), 'LR', 0, 'R');
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2);
$pdf->Cell($w1[5], $ln * 2, number_format($total_terima, "0", ",", "."), 'LR', 1, 'R');

Exemple #2

Fichier : rapel_penerima_prn.php Projet : abbeet/server39

 } else {
     $kdbulan = $j;
 }
 $oList = mysql_query("SELECT sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM mst_tk WHERE tahun = '{$th}' and bulan = '{$kdbulan}' and kdsatker = '{$kdsatker}' GROUP BY bulan");
 $row = mysql_fetch_array($oList);
 $max = 0;
 $no += 1;
 $total_tunker += $row['jml_tunker'];
 $total_pajak += $row['jml_pajak'];
 $total_terima += $row['jml_terima'];
 if (jmlpeg_bulan($th, $kdbulan, $kdsatker) > $jml_peg) {
     $jml_peg = jmlpeg_bulan($th, $kdbulan, $kdsatker);
 }
 $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
 $arrBulan = $pdf->SplitToArray($w1[1], $ln, strtoupper(nama_bulan($j)));
 $arrPenerima = $pdf->SplitToArray($w1[2], $ln, jmlpeg_bulan($th, $kdbulan, $kdsatker));
 $arrJmlTunker = $pdf->SplitToArray($w1[3], $ln, number_format($row['jml_tunker'], "0", ",", "."));
 $arrJmlPajak = $pdf->SplitToArray($w1[4], $ln, number_format($row['jml_pajak'], "0", ",", "."));
 $arrJumlah = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
 $arrJmlPajak = $pdf->SplitToArray($w1[6], $ln, number_format($row['jml_pajak'], "0", ",", "."));
 $arrJmlTerima = $pdf->SplitToArray($w1[9], $ln, number_format($row['jml_terima'], "0", ",", "."));
 $arrJmlKurang = $pdf->SplitToArray($w1[7], $ln, number_format($row['jml_tunker'] - $row['jml_terima'], "0", ",", "."));
 $arrJmlPotong = $pdf->SplitToArray($w1[8], $ln, number_format($row['jml_tunker'] - $row['jml_terima'] + $row['jml_pajak'], "0", ",", "."));
 if ($max < count($arrBulan)) {
     $max = count($arrBulan);
 }
 for ($i = 0; $i < $max; $i++) {
     $pdf->SetX($margin);
     $pdf->Cell($w1[0], $ln, $arrNo[$i], 'LR', 0, 'C');
     $pdf->SetX($margin + $w1[0]);
     $pdf->Cell($w1[1], $ln, $arrBulan[$i], 'LR', 0, 'L');

Exemple #3

Fichier : rapel_penerima_xls.php Projet : abbeet/server39

    }
    $oList = mysql_query("SELECT kdsatker, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM {$table} WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan = '{$kdbulan}' GROUP BY bulan ");
    $List = mysql_fetch_array($oList);
    $col[0][] = $i;
    $col[1][] = jmlpeg_bulan($th, $kdbulan, $List['kdsatker']);
    $col[4][] = $List['jml_tunker'];
    $col[5][] = $List['jml_pajak'];
    $col[6][] = $List['jml_terima'];
    $col[7][] = $List['jml_tunker'] - $List['jml_terima'];
    $col[8][] = $List['jml_tunker'] - $List['jml_terima'] + $List['jml_pajak'];
    $total_tk += $List['jml_tunker'];
    $total_pj += $List['jml_pajak'];
    $total_trm += $List['jml_terima'];
    $total += jmlpeg_bulan($th, $kdbulan, $List['kdsatker']);
    if (jmlpeg_bulan($th, $kdbulan, $List['kdsatker']) > $jml_peg) {
        $jml_peg = jmlpeg_bulan($th, $kdbulan, $List['kdsatker']);
    }
}
// start export
header("Content-type: application/octet-stream");
$filename = "rapel_penerimaan_" . $kdsatker . "_" . $kdbulan1 . "_" . $kdbulan2 . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Pragma: no-cache");
header("Expires: 0");
print "<b>";
print "<b>";
print "REKAPITULASI PENERIMAAN TUNJANGAN KINERJA PEGAWAI<br>";
$b1 = (int) $kdbulan1;
$b2 = (int) $kdbulan2;
print "BULAN " . strtoupper(nama_bulan($b1)) . " S/D " . strtoupper(nama_bulan($b2)) . " {$th}<br>";
print "SATUAN KERJA : " . strtoupper(nm_satker($kdsatker)) . "<br><br>";