PHP get_nama_pegawai示例

示例#1

文件： download-lpj.php 项目： chanif/aplpj

    $result = mysql_query($query);
    while ($fetch_r = mysql_fetch_array($result)) {
        $tabel_rekap = '';
        $bku_kr = $fetch_r['BKU_KODE_REK'];
        $query = "SELECT \t\t*\n\t\t\t\t\t    FROM \t\tTB_BUKU_KAS_UMUM\n\t\t\t\t\t\tWHERE \t\tBKU_KODE_REK='{$bku_kr}'\n\t\t\t\t\t\tORDER BY \tBKU_NO_URUT";
        $result_rkp = mysql_query($query);
        // Get data rekap
        $tot_up_gu_tu = 0;
        $tot_jml = 0;
        while ($fetch_rkp = mysql_fetch_array($result_rkp)) {
            $data_rekap['no_urut'] = $fetch_rkp['BKU_NO_URUT'];
            $data_rekap['tgl'] = date_format(date_create($fetch_rkp['BKU_TGL_SUB_KEG']), 'd/m/Y');
            if (empty($fetch_rkp['BKU_ATAS_NAMA']) || $fetch_rkp['BKU_ATAS_NAMA'] == NULL) {
                $atas_nama = '';
            } else {
                $atas_nama = ' an. ' . get_nama_pegawai($fetch_rkp['BKU_ATAS_NAMA']);
            }
            $data_rekap['uraian'] = $fetch_rkp['BKU_URAIAN'] . $atas_nama;
            $data_rekap['ls'] = '';
            $data_rekap['up_gu_tu'] = number_format($fetch_rkp['BKU_PENGELUARAN'], 0, ',', '.');
            $data_rekap['jml'] = number_format($fetch_rkp['BKU_PENGELUARAN'], 0, ',', '.');
            // Hitung totalUP/GU/TU dan Jumlah Pengeluaran
            $tot_up_gu_tu += $fetch_rkp['BKU_PENGELUARAN'];
            $tot_jml += $fetch_rkp['BKU_PENGELUARAN'];
            $tabel_rekap = $tabel_rekap . '
			<tr>
				<td style="font-size: 9pt;">' . $data_rekap['no_urut'] . '</td>
				<td style="font-size: 9pt;">' . $data_rekap['tgl'] . '</td>
				<td style="text-align: justify; font-size: 9pt;">' . $data_rekap['uraian'] . '</td>
				<td style="text-align: right; font-size: 9pt;">' . $data_rekap['ls'] . '</td>
				<td style="text-align: right; font-size: 9pt;">' . $data_rekap['up_gu_tu'] . '</td>

示例#2

文件： form-data-sptj-bl.php 项目： chanif/aplpj

					<tr>
						<th>No. Urut</th>
						<th>Tanggal</th>
					</tr>
				</thead>
				<tbody>
			<?php 
    foreach ($data_bku_sptjbl as $val) {
        ?>
					<tr>
						<td><?php 
        echo $i;
        ?>
</td>
						<td><?php 
        echo get_nama_pegawai($val['BKU_ATAS_NAMA']);
        ?>
</td>
						<td><?php 
        echo $val['BKU_URAIAN'];
        ?>
</td>
						<td class='center'><?php 
        echo $val['BKU_NO_URUT'];
        ?>
</td>
						<td><?php 
        echo date_format(date_create($val['BKU_TGL_SUB_KEG']), 'd/m/Y');
        ?>
</td>
						<td style='text-align: right;'><?php 

示例#3

文件： form-data-rekapitulasi.php 项目： chanif/aplpj

			<?php 
$query = "SELECT BKU_NO_URUT,BKU_TGL_SUB_KEG,BKU_PENGELUARAN,BKU_URAIAN,BKU_ATAS_NAMA,\n\t\t\t\t\t\t\t\t\t  BPP_LPJ_LS_GAJI,BPP_LPJ_LS_BRNG_JASA,BPP_LPJ_UP_GU_TU\n\t\t\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t  TB_BUKU_KAS_UMUM,TB_LPJ_BNDHRA_PNGLUARAN_PMBNTU \n\t\t\t\t\t\t\t\t\t    WHERE TB_LPJ_BNDHRA_PNGLUARAN_PMBNTU.LPJ_ID={$lpj_id} AND TB_BUKU_KAS_UMUM.BKU_KODE_REK='{$bku_kr}' AND TB_LPJ_BNDHRA_PNGLUARAN_PMBNTU.KODE_REK='{$bku_kr}' \n\t\t\t\t\t\t\t\t\t\tORDER BY TB_BUKU_KAS_UMUM.BKU_NO_URUT";
$result = mysql_query($query);
while ($td = mysql_fetch_array($result)) {
    ?>
					<tr>
						<td><?php 
    echo $td['BKU_NO_URUT'];
    ?>
</td>
						<td><?php 
    echo date_format(date_create($td['BKU_TGL_SUB_KEG']), 'd/m/Y');
    ?>
</td>
						<td><?php 
    echo $td['BKU_URAIAN'] . ' an. ' . get_nama_pegawai($td['BKU_ATAS_NAMA']);
    ?>
</td>
						<td><?php 
    echo $td['BPP_LPJ_LS_GAJI'] + $td['BPP_LPJ_LS_BRNG_JASA'];
    ?>
</td>
						<td><?php 
    echo number_format($td['BKU_PENGELUARAN'], 0, ',', '.');
    ?>
</td>
						<td><?php 
    echo number_format($td['BKU_PENGELUARAN'], 0, ',', '.');
    ?>
</td>
					</tr>