コード例 #1
0
        ?>
">
					<td rowspan="3" align="center" valign="top"><?php 
        echo $limit * ($pagess - 1) + ($k + 1);
        ?>
</td>
					<td rowspan="3" align="left" valign="top"><?php 
        echo 'Kelas Jabatan ' . $col[0][$k];
        ?>
</td>
			        <td rowspan="3" align="center" valign="top"><?php 
        echo jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $col[0][$k]);
        ?>
</td>
			        <td rowspan="3" align="right" valign="top"><?php 
        echo number_format(rp_grade($col[0][$k]), "0", ",", ".");
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo number_format($col[2][$k], "0", ",", ".");
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo number_format($col[3][$k], "0", ",", ".");
        ?>
</td>
				</tr>
				<tr class="<?php 
        echo $class;
        ?>
">
コード例 #2
0
        ?>
">
					<td rowspan="3" align="center" valign="top"><?php 
        echo $limit * ($pagess - 1) + ($k + 1);
        ?>
</td>
					<td rowspan="3" align="left" valign="top"><?php 
        echo 'GRADE ' . $col[0][$k];
        ?>
</td>
			        <td rowspan="3" align="center" valign="top"><?php 
        echo jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $col[0][$k]);
        ?>
</td>
			        <td rowspan="3" align="right" valign="top"><?php 
        echo rp_grade($col[0][$k]);
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[4][$k];
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[5][$k];
        ?>
</td>
				</tr>
				<tr class="<?php 
        echo $class;
        ?>
">
コード例 #3
0
    ?>
">
					<td align="center" valign="top"><?php 
    echo $no . '.';
    ?>
</td>
					<td align="left" valign="top"><?php 
    echo 'Kelas Jabatan ' . $col_1;
    ?>
</td>
			        <td align="center" valign="top"><?php 
    echo $col_2 . ' ' . $col_10;
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo rp_grade($col_4, $col_1, 1);
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo $col_5;
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo $col_6;
    ?>
</td>
				    <td align="right" valign="top"><?php 
    echo $col_5 + $col_6;
    ?>
</td>
				    <td align="right" valign="top"><?php 
コード例 #4
0
">

					<!-- cetak rekap masing-masing grade -->
					<!-- cetak nomer -->
					<td align="center" valign="top"><?php 
    echo 18 - $k;
    ?>
</td>
					<!-- cetak grade -->
					<td align="center" valign="top"><?php 
    echo $k;
    ?>
</td>
					<!-- cetak nominal -->
					<td align="right" valign="top"><?php 
    echo number_format(rp_grade($cunit[$k], $k, 1), "0", ",", ".");
    ?>
</td>
					
					<!-- cetak banyaknya penerima   -->
			        <!--td align="center" valign="top"><?php 
    echo $cpenerima[1][$k];
    ?>
</td-->

					<?php 
    //  cetak jumlah tunjangan kinerja
    $tk = 0;
    for ($b = 1; $b <= 13; $b++) {
        echo "<td align=right valign=top>";
        echo number_format($ctk[$b][$k], "0", ",", ".");
コード例 #5
0
$w1 = array(10, 50, 35, 40, 50, 7);
//	$w1 = array(10,50,35,35,35);
$pdf->SetFont($font, '', $size - 1);
$xx = 0;
$no = 0;
$ln = 4;
$xkdunit = substr($kdunit, 0, 5);
if ($kdunit == '2320100') {
    $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and ( kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ) GROUP BY grade ORDER BY grade desc");
} else {
    $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and kdunitkerja LIKE '{$xkdunit}%' GROUP BY grade ORDER BY grade desc");
}
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nilGrade = rp_grade($row['grade']);
    $total_tunker += $row['jml_tunker'];
    $total_pajak += $row['jml_pajak'];
    $total += jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']);
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'GRADE ' . $row['grade']);
    $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format(jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']), "0", ",", "."));
    $arrUrut = $pdf->SplitToArray($w1[5], $ln, '1.' . "\n" . '2.' . "\n" . '3.');
    $arrUrut1 = $pdf->SplitToArray($w1[5], $ln, '' . "\n" . '1.' . "\n" . '2.');
    $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", "."));
    $arrJmlTunker = $pdf->SplitToArray($w1[4] - $w1[5], $ln, number_format($row['jml_tunker'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
    //	$arrJmlPajak  = $pdf->SplitToArray($w1[4],$ln,number_format($row['jml_pajak'],"0",",","."));
    $arrJumlah = $pdf->SplitToArray($w1[4], $ln, '' . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'], "0", ",", "."));
    if ($max < count($arrJmlTunker)) {
        $max = count($arrJmlTunker);
    }
コード例 #6
0
					<td align="left" valign="top"><?php 
        if ($col[7][$k] != $col[7][$k - 1]) {
            echo 'Kelas Jabatan ' . $col[7][$k];
        }
        ?>
</td>
			        <td align="center" valign="top"><?php 
        echo 1;
        ?>
</td>
			        <td align="center" valign="top"><?php 
        echo $col[6][$k];
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[4][$k] . '<br>' . '( ' . $col[6][$k] . '/' . hari_bulan($th, $kdbulan) . ' x ' . number_format(rp_grade($col[3][$k], $col[7][$k], $col[2][$k]), "0", ",", ".") . ' )';
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[5][$k];
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[4][$k] + $col[5][$k];
        ?>
</td>
				</tr>
<?php 
        $grade = $col[7][$k];
    }
}
コード例 #7
0
ファイル: simpan_hasil.php プロジェクト: abbeet/server39
$xmenu_p = xmenu_id($p);
$p_next = $xmenu_p->parent;
if (isset($form)) {
    if ($err != true) {
        $tahun = $_REQUEST['tahun'];
        $bulan = bulan_data($_REQUEST['bulan']);
        $tgl_status = date('Y-m-d');
        $sql = "SELECT id,nib,grade,gaji,kdunitkerja,kdkawin,iwp,pajak_gaji,kdpeg,jml_hari,tfungsi FROM mst_tk WHERE tahun = '{$tahun}' AND bulan = '{$bulan}' AND kdsatker = '{$xusername}'";
        $qu = mysql_query($sql);
        while ($row = mysql_fetch_array($qu)) {
            $id = $row['id'];
            if ($row['jml_hari'] == 0) {
                $tunker = rp_grade(substr($row['kdunitkerja'], 0, 2), $row['grade'], $row['kdpeg']);
            }
            if ($row['jml_hari'] != 0) {
                $tunker = rp_grade(substr($row['kdunitkerja'], 0, 2), $row['grade'], $row['kdpeg']) * ($row['jml_hari'] / hari_bulan($tahun, $bulan));
            }
            if ($xusename = '524334') {
                $tunker = $tunker - $row['tfungsi'];
            }
            $gaji_bruto = $row['gaji'] + $tunker;
            $pajak_total = nil_pajak($gaji_bruto, $row['kdkawin'], $row['iwp']);
            $pajak_gaji = $row['pajak_gaji'];
            $pajak_tunker = $pajak_total - $pajak_gaji;
            $sql_inp = "UPDATE mst_tk SET tunker = '{$tunker}' , pajak_tunker = '{$pajak_tunker}' WHERE id = '{$id}' ";
            mysql_query($sql_inp);
            #}
        }
        ?>
			
			<meta http-equiv="refresh" content="0;URL=index.php?p=<?php 
コード例 #8
0
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 6;
$margin = 10;
$tinggi = 275;
$w1 = array(10, 30, 20, 32, 22, 32);
$pdf->SetFont($font, '', $size - 1);
$xx = 0;
$no = 0;
$oList = mysql_query("SELECT grade, count(nib) as jumlah, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM mst_tk WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan = '{$kdbulan}' GROUP BY grade ORDER BY grade desc");
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nilGrade = rp_grade($kdunit, $row['grade'], 1);
    $total_tunker += $row['jml_tunker'];
    $total_pajak += $row['jml_pajak'];
    $total_terima += $row['jml_terima'];
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'Kelas Jabatan ' . $row['grade']);
    if ($nilGrade * $row['jumlah'] != $row['jml_tunker']) {
        $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", ".") . ' (*)');
        $xx = 1;
    } else {
        $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", "."));
    }
    $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", "."));
    $arrJmlTunker = $pdf->SplitToArray($w1[5], $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", ",", "."));
コード例 #9
0
ファイル: rekap_penerima_TK.php プロジェクト: abbeet/server39
    ?>
">
					<td align="center" valign="top"><?php 
    echo $no . '.';
    ?>
</td>
					<td align="left" valign="top"><?php 
    echo 'Kelas Jabatan ' . $col_1;
    ?>
</td>
			        <td align="center" valign="top"><?php 
    echo $col_2 . ' ' . $col_10;
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo number_format(rp_grade($col_4, $col_1, 1), "0", ",", ".");
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo number_format($col_5, "0", ",", ".");
    ?>
</td>
			        <td align="right" valign="top"><?php 
    echo number_format($col_6, "0", ",", ".");
    ?>
</td>
				    <td align="right" valign="top"><?php 
    echo number_format($col_5 + $col_6, "0", ",", ".");
    ?>
</td>
				    <td align="right" valign="top"><?php 
コード例 #10
0
 if ($row['jml_hari'] == 0) {
     $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan']));
 }
 if ($row['jml_hari'] != 0) {
     $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan']) . "\n" . ' (' . $row['jml_hari'] . ' hari dari ' . hari_bulan($th, $kdbl) . ' hari kerja)');
 }
 $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']);
 $arrTGrade = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']), "0", ",", "."));
 $arrFPot = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']) - $row['tunker'], "0", ",", "."));
 $arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'], "0", ",", "."));
 $arrPajak = $pdf->SplitToArray($w1[5], $ln, number_format($row['pajak_tunker'], "0", ",", "."));
 $arrMinta = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] + $row['pajak_tunker'], "0", ",", "."));
 $total_tunker += $row['tunker'];
 $total_pajak += $row['pajak_tunker'];
 $total_tgrade += rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']);
 $total_fpot += rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']) - $row['tunker'];
 if ($max < count($arrNama)) {
     $max = count($arrNama);
 }
 if ($max < count($arrJabatan)) {
     $max = count($arrJabatan);
 }
 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, $arrNama[$i], 'LR', 0, 'L');
     $pdf->SetX($margin + $w1[0] + $w1[1]);
     $pdf->Cell($w1[2], $ln, $arrGol[$i], 'LR', 0, 'C');
     $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
     $pdf->Cell($w1[3], $ln, $arrJabatan[$i], 'LR', 0, 'L');
コード例 #11
0
        ?>
">
					<td rowspan="3" align="center" valign="top"><?php 
        echo $limit * ($pagess - 1) + ($k + 1);
        ?>
</td>
					<td rowspan="3" align="left" valign="top"><?php 
        echo 'Kelas Jabatan ' . $col[0][$k];
        ?>
</td>
			        <td rowspan="3" align="center" valign="top"><?php 
        echo $col[1][$k];
        ?>
</td>
			        <td rowspan="3" align="right" valign="top"><?php 
        echo rp_grade($col[3][$k], $col[0][$k], 1);
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo $col[4][$k];
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo 0;
        ?>
</td>
				</tr>
				<tr class="<?php 
        echo $class;
        ?>
">
コード例 #12
0
ファイル: hitung_potongan.php プロジェクト: abbeet/server39
            $nilpot_12 = $row['kdpot_12'] * persen_pot('12');
            $nilpot_13 = $row['kdpot_13'] * persen_pot('13');
            $nilpot_14 = $row['kdpot_14'] * persen_pot('14');
            $nilpot_15 = $row['kdpot_15'] * persen_pot('15');
            $nilpot_16 = $row['kdpot_16'] * persen_pot('16');
            $nilpot_21 = $row['kdpot_21'] * persen_pot('21');
            $nilpot_22 = $row['kdpot_22'] * persen_pot('22');
            $nilpot_40 = $row['kdpot_40'] * persen_pot('40');
            $nilpot_tk = $row['kdpot_tk'] * persen_pot('tk');
            $nilpot_cm = $row['kdpot_cm'] * persen_pot('cm');
            //				$selisih_nilpot_tk = $row['kdpot_tk'] * 2;
            //				$selisih_nilpot_cm = $row['kdpot_cm'] * 1;
            $totpot = $nilpot_10 + $nilpot_11 + $nilpot_12 + $nilpot_13 + $nilpot_14 + $nilpot_15 + $nilpot_16 + $nilpot_01 + $nilpot_02 + $nilpot_03 + $nilpot_04 + $nilpot_05 + $nilpot_06 + $nilpot_07 + $nilpot_08 + $nilpot_31 + $nilpot_32 + $nilpot_33 + $nilpot_34 + $nilpot_21 + $nilpot_22 + $nilpot_40 + $nilpot_tk + $nilpot_cm;
            //						  $nilpot_40 -
            //						  $selisih_nilpot_tk - selisih_nilpot_cm;
            $rp_grade = rp_grade($kdunit, $grade, $kdpeg);
            $rp_pot = $tunker * ($totpot / 100);
            if ($bulan != 13) {
                $nil_terima = $tunker - $rp_pot;
            } else {
                $nil_terima = $tunker;
            }
            //					if ( $status == '0' )
            //					{
            //							$_SESSION['errmsg'] = "Persetujuan dari KPPN belum diupdate ke sistem ";
            //							exit();
            ?>
							<meta http-equiv="refresh" content="0;URL=index.php?p=<?php 
            echo $p_next;
            ?>
"><?php 
コード例 #13
0
while ($row = mysql_fetch_array($oList)) {
    $max = 0;
    $no += 1;
    $nilGrade = rp_grade($kdunit, $row['grade'], 1);
    $total_tunker += $row['jml_tunker'];
    $total_pajak += $row['jml_pajak'];
    $total_tk += rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'];
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'Kelas Jabatan ' . $row['grade']);
    $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", "."));
    $arrUrut = $pdf->SplitToArray($w1[5], $ln, '1.' . "\n" . '2.' . "\n" . '3.');
    $arrUrut1 = $pdf->SplitToArray($w1[5], $ln, '' . "\n" . '1.' . "\n" . '2.');
    $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", "."));
    $arrJmlTunker = $pdf->SplitToArray($w1[4] - $w1[5], $ln, number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] + $row['jml_pajak'], "0", ",", "."));
    //	$arrJmlPajak  = $pdf->SplitToArray($w1[4],$ln,number_format($row['jml_pajak'],"0",",","."));
    $arrJumlah = $pdf->SplitToArray($w1[4], $ln, number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] - $row['jml_tunker'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] + $row['jml_pajak'] - $row['jml_pajak'] - (rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] - $row['jml_tunker']), "0", ",", "."));
    if ($max < count($arrJmlTunker)) {
        $max = count($arrJmlTunker);
    }
    for ($i = 0; $i < $max; $i++) {
        $pdf->SetX($margin);
        if ($i == 1) {
            $pdf->Cell($w1[0], $ln, $arrNo[$i - 1], 'LR', 0, 'C');
        } else {
            $pdf->Cell($w1[0], $ln, '', 'LR', 0, 'C');
        }
        $pdf->SetX($margin + $w1[0]);
        if ($i == 1) {
            $pdf->Cell($w1[1], $ln, $arrGrade[$i - 1], 'LR', 0, 'L');
        } else {
            $pdf->Cell($w1[1], $ln, '', 'LR', 0, 'L');