echo "\t\t\t\t<td width=\"150\">Nama</td>\n";
echo "\t\t\t\t<td width=\"180\">Alamat</td>\n";
echo "\t\t\t\t<td width=\"90\">Gaji Utama</td>\n";
echo "\t\t\t\t<td width=\"30\" align=\"center\">Gol.</td>\n";
echo "\t\t\t\t<td width=\"90\" align=\"center\">Rekening</td>\n";
echo "\t\t\t</tr>\n";
if (mysql_num_rows($cari) == 0) {
echo "\t\t<tr class=\"no-data\"><td colspan=\"6\">Maaf, belum ada data karyawan saat ini</td></tr>\n";
} else {
$no = 1;
while ($datacari = mysql_fetch_array($cari)) {
echo "\t<tr class=\"data\">\n";
echo "\t\t<td align=\"center\">{$no}</td>\n";
echo "\t\t<td><a href=\"" . URL . "/index.php?page=transfer-gaji&kary_id={$datacari['kary_id']}\" title=\"Transfer Gaji → {$datacari['nama_kar']}\">{$datacari['nama_kar']}</a></td>\n";
echo "\t\t<td>{$datacari['alamat_kar']}</td>\n";
echo "\t\t<td>Rp. " . Rupiah($datacari['gaji_utama']) . "</td>\n";
echo "\t\t<td align=\"center\">{$datacari['gol_kar']}</td>\n";
echo "\t\t<td align=\"center\">{$datacari['no_rek']}</td>\n";
echo "\t</tr>\n";
$no++;
}
}
echo "\t\t\t</table>\n";
echo "\t\t\t<p>Hasil pencarian data.</p>\n";
echo "\t\t</div>\n";
}
} elseif ($page == 'laporan') {
include "laporan.php";
} else {
//echo " <div class=\"box\">\n";
echo "\t\t\t<u>Selamat Datang di Program Penggajian Karyawan</u>\n";
} else {
if ($i == 2) {
echo "<td style='vertical-align:top;'>" . $val[$i] . "</td>";
} else {
echo "<td style='vertical-align:top;text-align:center;'>" . $val[$i] . "</td>";
}
}
}
echo "</tr>";
}
echo "<tr>";
echo "<td colspan='4' style='text-align:center;'>TOTAL</td>";
echo "<td style='text-align:center;'>" . Decimal($tot_act, 1) . "</td>";
echo "<td style='text-align:center;'>" . Decimal($tot_cal) . "</td>";
echo "<td> </td>";
echo "<td style='text-align:right;'>" . Rupiah($tot_amt) . "</td>";
echo "</tr>";
?>
</tbody>
</table>
<br>
<table width="100%">
<tr>
<td colspan="3">
Jakarta, <?php
echo date('M d, Y');
?>
<br/>Prepared By,<br /><br /><br /><br /><br />
<span style="text-decoration:underline;"><?php
echo "";
?>
function ajax_list_ovt($tgl = NULL, $regs = NULL, $div = NULL, $sec = NULL, $pos = NULL, $grade = NULL)
{
permission();
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "regs" => $regs, "divisi" => $div, "section" => $sec, "position" => $pos, "grade" => $grade);
$exp = explode("~", $tgl);
/*$config=array();
$q = GetAll("kg_config");
foreach($q->result_array() as $r) {
if(preg_match('/jam_/', $r['title'])) $config[$r['title']] = $r['value'];
}*/
//print_mz($config);
$list = $this->ovt->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
//Acc Ovt
$acc = 0;
$q = GetAll("kg_view_overtime", array("id_employee" => "where/" . $r->id_employee, "date_full >=" => "where/" . $exp[0], "date_full <=" => "where/" . $exp[1], "date_temp" => "where/0000-00-00"));
foreach ($q->result_array() as $s) {
if ($s['job_level'] != "nonmanagement") {
if ($s['ovt_hour_sum'] >= 2) {
$acc += $s['ovt_hour_sum'];
}
} else {
$acc += $s['ovt_hour_cal'];
}
}
$q = GetAll("kg_view_overtime", array("id_employee" => "where/" . $r->id_employee, "date_temp >=" => "where/" . $exp[0], "date_temp <=" => "where/" . $exp[1]));
foreach ($q->result_array() as $s) {
if ($s['job_level'] != "nonmanagement") {
if ($s['ovt_hour_sum'] >= 2) {
$acc += $s['ovt_hour_sum'];
}
} else {
$acc += $s['ovt_hour_cal'];
}
}
if ($r->job_level != "nonmanagement") {
$upah = $acc * GetConfigDirect('rest_time');
} else {
$upah = $acc * (GetGapok($r->id_employee, $exp[0]) + GetHA($r->id_employee, $exp[0])) / GetConfigDirect('total_hour_ovt');
}
$ot_rasio = GetOTRasio($r->id_employee, $exp[1]);
//$upah / (GetGapok($r->id_employee, $exp[0]) + GetHA($r->id_employee, $exp[0]) + $upah) * 100;
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="detailOvertime(' . "'" . $r->id_employee . "'" . ')"><i class="glyphicon glyphicon-info-sign"></i> Detail</a>';
//$data[] = array($no, $r->ext_id, $r->person_nm, GetMonth(intval(substr($tgl,16,2))).' '.substr($tgl,11,4), $r->ovt_hour_sum, $acc, Decimal($ot_rasio)."%", Rupiah($upah), $edit);
$data[] = array($no, $r->ext_id, $r->person_nm, GetMonth(intval(substr($tgl, 16, 2))) . ' ' . substr($tgl, 11, 4), Decimal($r->ovt_hour_sum, 1), Decimal($acc), $ot_rasio, Rupiah($upah), $edit);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->ovt->count_all($param), "recordsFiltered" => $this->ovt->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
