$params = array(":idboletin" => $_REQUEST["b"], ":posicion" => $_REQUEST["n"]);
$sql =
"SELECT ba_ano, ba_emailscontacto, ba_fecha, ba_numero, na_altoimagenes, na_anchoimagenes, na_colortitulo, na_id, na_nota, na_numeroplantilla, na_titulo
FROM rrhh.rna_noticiasarteria, rrhh.rba_boletinesarteria
WHERE na_idboletin = ba_id
AND na_idboletin = :idboletin
AND na_posicion = :posicion";
$stmt = DBExecSql($conn, $sql, $params);
$row = DBGetQuery($stmt);
$numeroPlantilla = 1;
if ($row["NA_NUMEROPLANTILLA"] != "")
$numeroPlantilla = $row["NA_NUMEROPLANTILLA"];
$vals = split("/", $row["BA_FECHA"]);
$fecha = GetDayName(date("N", strtotime($vals[2]."-".$vals[1]."-".$vals[0])))." ".$vals[0]." de ".GetMonthName($vals[1])." de ".$vals[2];
$ano = "Año ".decimalToRomana($row["BA_ANO"]);
$numero = "Número ".decimalToRomana($row["BA_NUMERO"]);
$modo = "r"; // Real..
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>ARTeria Noticias - <?php
echo $row["NA_TITULO"];
?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Author" content="Gerencia de Sistemas" />
function ajax_list_detail_att($tgl = NULL, $id_emp = NULL)
{
permission();
$this->load->model('attendance_model', 'att');
$param = array("tgl" => $tgl, "id_emp" => $id_emp, "detailz_grafik" => 1);
$list = $this->att->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$shift = GetValue("tgl_" . intval($r->tanggal), "kg_jadwal_shift", array("id_employee" => "where/" . $id_emp, "bulan" => "where/" . $r->bulan, "tahun" => "where/" . $r->tahun));
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="editAtt(' . "'" . $r->id . "'" . ', ' . "'" . $tgl . "'" . ')"><i class="glyphicon glyphicon-pencil"></i> Edit</a>';
$data[] = array($no, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), $r->jh, $r->off, $r->alpa, $r->scan_masuk, $r->scan_pulang, strtoupper($shift));
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->att->count_all($param), "recordsFiltered" => $this->att->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function ajax_list_cuti($tgl = NULL)
{
permission();
$this->load->model('cuti_model', 'cuti');
if ($this->session->userdata('person_id') > 1) {
$person_id = $this->session->userdata('person_id');
} else {
$person_id = 0;
}
$param = array("tgl" => $tgl, "history" => 1, "person_id" => $person_id);
$list = $this->cuti->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
if ($r->cuti_status == "Waiting") {
$status = '<a class="error" href="javascript:void(0);" onclick="detailCuti(' . "'" . $r->id . "'" . ')">Waiting</a>';
} else {
$status = $r->cuti_status;
}
$data[] = array($no, GetDayName($r->tgl_start_ref) . ", " . FormatTanggalShort($r->tgl_start_ref) . " - " . GetDayName($r->tgl_end_ref) . ", " . FormatTanggalShort($r->tgl_end_ref), $r->hari_ref, $r->reason, $r->keterangan, $r->feedback);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->cuti->count_all($param), "recordsFiltered" => $this->cuti->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
<?
require_once($_SERVER["DOCUMENT_ROOT"]."/constants.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/database/db_funcs.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/miscellaneous/date_utils.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/miscellaneous/general.php");
$today = GetDayName(date("N"))." ".date("j")." de ".GetMonthName(date("n"))." de ".date("Y");
?>
<img border="0" id="imagen2HomePage" src="images/entrenos.jpg">
<span id="fechaHomePage"><?php
echo $today;
?>
</span>
<map name="FPMap0"><area href="/" shape="rect" coords="62, 4, 206, 51"></map>
<img border="0" id="cube" name="cube" src="images/logo_provart.jpg" style="filter:progid:DXImageTransform.Microsoft.Stretch(stretchStyle='PUSH')" usemap="#FPMap0">
function ajax_list_detail_ovt($tgl = NULL, $id_emp = NULL)
{
$person_id = permission();
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "id_emp" => $id_emp, "detailz" => 1);
$list = $this->ovt->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$data[] = array($no, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), $r->ovt_hour_sum, $r->ovt_flag, $r->ovt_reason, $r->ovt_detail_reason);
}
$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);
}
function ajax_list_holiday($year = NULL)
{
permission();
$this->load->model('config_holiday_model', 'holiday');
$param = array("tahun" => $year);
$list = $this->holiday->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="editHoliday(' . "'" . $r->id . "'" . ')"><i class="glyphicon glyphicon-pencil"></i> Edit</a>';
$data[] = array($no, GetDayName($r->tanggal) . ", " . FormatTanggalShort($r->tanggal), $r->ket, $edit);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->holiday->count_all($param), "recordsFiltered" => $this->holiday->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function export_ovt_full($tgl = NULL, $regs = NULL, $div = NULL, $sec = NULL, $pos = NULL, $grade = NULL)
{
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "rekap" => "full", "regs" => $regs, "divisi" => $div, "section" => $sec, "position" => $pos, "grade" => $grade);
$exp = explode("~", $tgl);
$list = $this->ovt->get_datatables($param);
$dataz = array();
$no = 0;
//$_POST['start'];
foreach ($list->result() as $r) {
$no++;
$dataz[] = array($no, $r->ext_id, $r->person_nm, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), Decimal($r->ovt_hour_sum, 1), Decimal($r->ovt_hour_cal), $r->ovt_reason, $r->ovt_detail_reason);
}
$data['list'] = $dataz;
//print_mz($data['list']);
$html = $this->load->view('export_overtime_full', $data);
to_excel($html, 'ReportOvertimeFull');
}
