public function render($data)
{
$m_product = M('product');
$m_member = M('member');
$end_time = time();
$this_time = $end_time - 86400 * 30;
while (date('Y-m-d', $this_time) <= date('Y-m-d', $end_time)) {
$day_count_array[] = "'" . date('m/d', $this_time) . "'";
$time1 = strtotime(date('Y-m-d', $this_time));
$time2 = $time1 + 86400;
$where_day_create['create_time'] = array(array('lt', $time2), array('gt', $time1), 'and');
$day_product_count[] = $m_product->where($where_day_create)->count();
$where_day_create['reg_time'] = array(array('lt', $time2), array('gt', $time1), 'and');
$day_member_count[] = $m_member->where($where_day_create)->count();
$this_time += 86400;
}
$i = 5;
while ($i >= 0) {
$time_array = GetMonth(-$i);
$start_time = $time_array['start_time'];
$end_time = $time_array['end_time'];
$month_member_count[] = "'" . date('y/m', $start_time) . "'";
$where_moon_member['reg_time'] = array('lt', $end_time);
$month_member_create_count[] = $m_member->where($where_moon_member)->count();
$where_moon_product['create_time'] = array('lt', $end_time);
$month_product_create_count[] = $m_product->where($where_moon_product)->count();
$i--;
}
$data['month_member_count'] = implode(',', $month_member_count);
$data['month_member_create_count'] = implode(',', $month_member_create_count);
$data['month_product_create_count'] = implode(',', $month_product_create_count);
$data['day_count'] = implode(',', $day_count_array);
$data['day_product_count'] = implode(',', $day_product_count);
$data['day_member_count'] = implode(',', $day_member_count);
return $this->renderFile("index", $data);
}
<div id="horo_pack">
<div class="item_header">Horoscopul pentru astazi</div>
<div class="data">
' . GetMonth(date('m', strtotime($signData['horoscope_date']))) . ' ' . date('d', strtotime($signData['horoscope_date'])) . ', ' . date('Y', time()) . ' </div>
<div class="text">
<p>
<strong>General</strong>
<br /> ' . $signData['description'] . '
</p>
</div>
</div>';
if (count($signDataTomorrow) != 0) {
echo '<div id = "horo_pack" >
<div class="item_header" > Horoscopul pentru ziua de miine </div >
<div class="data" >
' . GetMonth(date('m', strtotime($signDataTomorrow['horoscope_date']))) . ' ' . date('d', strtotime($signDataTomorrow['horoscope_date'])) . ', ' . date('Y', time()) . ' </div >
<div class="text" >
<p >
<strong > General</strong >
<br /> ' . $signDataTomorrow['description'] . '
</p >
</div >
</div >';
}
echo '</div>
<div class="soc_line">
<div data-user="******" class="pluso" data-background="transparent" data-options="big,round,line,horizontal,nocounter,theme=04" data-services="vkontakte,facebook,twitter,email"></div>
</div>
</div>';
echo $ac;
?>
&fileurl=<?php
echo $fileurl;
?>
&ym=<?php
echo GetMonth($yms[0] . $yms[1], 1);
?>
" class="prev" hidefocus="true" title="前一个月"></a><a id="lnk_next" href="admin.php?ac=<?php
echo $ac;
?>
&fileurl=<?php
echo $fileurl;
?>
&ym=<?php
echo GetMonth($yms[0] . $yms[1], 0);
?>
" hidefocus="true" class="next" title="后一个月"></a></div>
<?php
if ($yms[0] . $yms[1] != get_date('Ym', PHP_TIME)) {
?>
<a href="admin.php?ac=workdate&fileurl=workbench" class="today_btn" hidefocus="true" title="切换回今天">本月</a>
<?php
}
?>
</div>
<div class="month_view_title">
<?php
if (is_superadmin()) {
if ($_GET['type'] == 1) {
echo '<a href="admin.php?ac=' . $ac . '&fileurl=workbench&ym=' . $ym . '&type=2"><p class="on">只显示我的日程</p></a>';
function FormatTanggalShort($tgl)
{
$exp = explode("-", $tgl);
//$tgl = $exp[2]." ".GetMonth(intval($exp[1]))." ".substr($exp[0],2,2);
$tgl = substr($exp[2], 0, 2) . " " . GetMonth(intval($exp[1])) . " " . $exp[0];
return $tgl;
}
<center>
<h2>Profit and Loss</h2>
</center>
<span style="float:right;"><?php
echo GetMonth((int) $periode[1]) . ' ' . (int) $periode[0];
?>
</span>
<table width="100%" border="1" cellspacing="0">
<tr class="theader">
<td width="9%">No</td>
<td width="61%">Account</td>
<td width="14%"> </td>
<td width="16%">Saldo</td>
</tr>
<tr>
<td colspan="4"><strong>AKTIVA LANCAR : </strong></td>
</tr><?php
$a = 1;
$aktiva1 = 0;
foreach ($profit1 as $untung) {
$l = $this->db->query("SELECT SUM(" . $untung['transaksi'] . ") as untung FROM sv_jurnal_detail LEFT JOIN sv_jurnal ON sv_jurnal_detail.id_jur=sv_jurnal.id WHERE MONTH(sv_jurnal.post_tgl)='" . $periode[1] . "' AND YEAR(sv_jurnal.post_tgl)='" . $periode[0] . "' AND sv_jurnal_detail.akun='" . $untung['coa'] . "' ")->row_array();
$aktiva1 = $l['untung'];
$totaktiva1 += $aktiva1;
?>
<tr>
<td><?php
echo $a;
?>
</td>
<td><?php
echo $untung['title'];
function approval_cuti()
{
permission();
$data['path_file'] = $this->filename;
if ($this->input->post("start_att")) {
$data['start_date'] = $this->input->post("start_att");
if (!$this->input->post("end_att")) {
$data['end_date'] = $data['start_date'];
} else {
$data['end_date'] = $this->input->post("end_att");
}
$data['period'] = GetMonth(substr($data['end_date'], 5, 2)) . " " . substr($data['end_date'], 0, 4);
} else {
$dt = $this->period;
//date("M Y");
$period = GetPeriod($dt);
$data['start_date'] = substr($period, 0, 10);
$data['end_date'] = substr($period, 11, 10);
$data['period'] = $dt;
}
$this->load->view('approval_cuti', $data);
}
include '../includes/navigation-admin.php';
?>
<div id="content" data-role="content">
<?php
include '../includes/navigation-admin-events.php';
?>
<h1>Event Detail</h1>
<?php
if (!$error) {
?>
<div class="Menu_Item_Header"><?php
echo $Event['Title'];
?>
</div>
<p class="BodyType"><strong>When</strong>: <?php
echo GetMonth($Event['Month']) . " " . $Event['Day'] . " " . $Event['Year'];
?>
</p>
<p class="BodyType"><strong>Whats going on?</strong> <br />
<?php
echo str_replace("\n", "<br>", $Event['Description']);
?>
</p>
<div style="height:15px;width:10px;"></div>
<?php
} else {
?>
<div class="Menu_Item_Header">Error</div>
<p class="BodyType" align="center"><strong> <?php
echo $error;
?>
function CreateSignRightpanel($sign, $Content)
{
echo '<div class="sign_item">
<div id="sign_img">
<img src="' . ROOT_HOST . 'view/images/big/' . $sign['sign_name'] . '.png" />
</div>
<div class="item_header"><span>' . $Content[$sign['sign_name']] . '</span>
<br />' . $sign['sign_date'] . '</div>
<div class="clear"></div>
<div class="sign_item_header">' . $Content[$sign['sign_name']] . ' — horscopul pentru astazi</div>
<div class="data">
' . GetMonth(date('m', strtotime($sign['horoscope_date']))) . ' ' . date('d', strtotime($sign['horoscope_date'])) . ', ' . date('Y', time()) . ' </div>
<div class="text">
' . substr($sign['description'], 0, 200) . ' ... <a href="' . ROOT_HOST . 'horoscope/' . $sign['sign_name'] . '">mai mult →</a></div>
<div class="button" style="bottom:45px;">
<div class="button_left"></div>
<div class="button_content"><a id="sign-all-horoscoper" href="' . ROOT_HOST . 'horoscope/' . $sign['sign_name'] . '">Toate pentru ' . $Content[$sign['sign_name']] . '</a></div>
<div class="button_right"></div>
</div>
<div class="clear"></div>
</div>';
}
function overtime($user = "******", $tgl = "0000-00-00", $dep = "0", $status = "0")
{
//Set Global
permission();
$data['filename'] = 'overtime';
$data['title'] = 'Overtime';
//if($user == 0 && $tgl == "0000-00-00" && !$this->uri->segment(5)) $tgl = date("Y-m-d");
$data['tgl'] = $tgl;
$exp = explode("~", $tgl);
if ($exp[0] != "0000-00-00") {
$data['start_date'] = $exp[0];
if (!isset($exp[1])) {
$data['end_date'] = $exp[0];
} else {
if (!$exp[1]) {
$data['end_date'] = $exp[0];
} else {
$data['end_date'] = $exp[1];
}
}
} else {
$data['start_date'] = $data['end_date'] = "";
}
$path_paging = base_url() . $this->filename . "/main/" . $user . "/" . $tgl . "/" . $dep . "/" . $status;
$uri_segment = 7;
$pg = $this->uri->segment($uri_segment);
$per_page = 15;
//End Global
$filter_where_in = array();
$data['opt_pic'] = GetOptPIC();
$data['opt_pic'][''] = "";
$data['opt_dep'] = GetOptDepartment();
//$data['opt_dep'][''] = "";
$data['opt_tgl'] = GetOptDate();
$data['opt_bln'] = GetOptMonth();
$data['opt_thn'] = GetOptYear();
$exp = explode("-", $exp[0]);
if (!isset($exp[0])) {
$exp[0] = "";
}
if (!isset($exp[1])) {
$exp[1] = "";
}
if (!isset($exp[2])) {
$exp[2] = "";
}
//if($exp[2] > 0) $filter = array("tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
//else $filter = array("id_employee"=> "order/asc", "tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
//Grup Admin
$id_grup = $this->session->userdata("webmaster_grup");
if ($id_grup == 3) {
$filter['urut_position <'] = "where/40";
}
if ($status) {
/*if($status == "alpa2")
{
$kemarin = date("Y-m-d", mktime(0, 0, 0, $exp[1], $exp[2]-1, $exp[0]));
$exp_alpa = explode("-", $kemarin);
$filter["alpa"] = "where/1";
}
else */
if ($status == "jh") {
$filter['terlambat !='] = "where/1";
}
$filter[$status] = "where/1";
}
$kondisi = "";
if ($status == "alpa2") {
$tgl_alpa = array($exp[2], $exp_alpa[2]);
$filter_where_in['tanggal'] = $tgl_alpa;
$bln_alpa = array($exp[1], $exp_alpa[1]);
$filter_where_in['bulan'] = $bln_alpa;
$thn_alpa = array($exp[0], $exp_alpa[0]);
$filter_where_in['tahun'] = $thn_alpa;
} else {
if ($data['start_date'] == $data['end_date']) {
if ($exp[0] > 0) {
$filter['tahun'] = "where/" . $exp[0];
$data['title'] = $this->title . " ( " . $exp[0] . " )";
if ($exp[1] > 0) {
$filter['bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
} else {
if ($exp[1] > 0) {
$exp[0] = date("Y");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
} else {
if ($exp[2] > 0) {
$exp[0] = date("Y");
$exp[1] = date("m");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
}
}
}
if ($dep) {
/*$ex = explode("-",$dep);
$dep=array();
foreach($ex as $r)
{
$dep[] = $r;
}
$filter_where_in['id_department'] = $dep;*/
$filter['id_department'] = "where/" . $dep;
}
//else $dep=array();
if ($user) {
$temp_user = $user;
$ex = explode("-", $user);
$user = array();
foreach ($ex as $r) {
$user[] = $r;
}
$filter_where_in['id_employee'] = $user;
$user = $temp_user;
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
}
//else $user=array();
$data['spic'] = $user;
$data['sdep'] = $dep;
/*$data['stgl'] = $exp[2];
$data['sbln'] = $exp[1];
$data['sthn'] = $exp[0];*/
$filter['name'] = "order/asc";
$filter['lembur'] = "where/1";
//if(count($user) > 0 || $exp[2] > 0)
if ($exp[2] > 0 && $data['start_date'] == $data['end_date'] || $user) {
$data['flag_tgl'] = 1;
$data['grid'] = array("Nama Karyawan", "Tanggal", "OT. Incidental", "Kelebihan Jam Kerja", "Tunjangan Hari Kerja", "Alasan Lembur", "Scan Masuk", "Scan Pulang", "Keterangan");
$data['list'] = array("id_employee", "tgl", "ot_incidental", "ot_allow_shift", "ot_cont_allow", "alasan_lembur", "scan_masuk", "scan_pulang", "keterangan");
if ($status == "alpa2") {
$sql = "select * from kg_view_kehadiran where tanggal='" . $exp[2] . "' AND bulan='" . $exp[1] . "' AND tahun='" . $exp[0] . "' AND alpa='1'\n AND id_employee in (select id_employee from kg_view_kehadiran where tanggal='" . $exp_alpa[2] . "' AND bulan='" . $exp_alpa[1] . "' AND tahun='" . $exp_alpa[0] . "' AND alpa='1')";
$data['query_all'] = $this->db->query($sql);
if (!$pg) {
$pg = 0;
}
$data['query_list'] = $this->db->query($sql . " LIMIT {$pg}, {$per_page}");
} else {
$data['query_all'] = GetAll("kg_view_kehadiran", $filter, $filter_where_in);
$filter['limit'] = $pg . "/" . $per_page;
$data['query_list'] = GetAll("kg_view_kehadiran", $filter, $filter_where_in);
//lastq();
}
} else {
/*$temp = $filter['id_employee'];
unset($filter['id_employee']);
$filter['id_employee'] = $temp;
$temp = $filter['tanggal'];
unset($filter['tanggal']);
$filter['tanggal'] = $temp;
$temp = $filter['bulan'];
unset($filter['bulan']);
$filter['bulan'] = $temp;
$temp = $filter['tahun'];
unset($filter['tahun']);
if($temp == "order/asc") $temp = "where/".date("Y");
$filter['tahun'] = $temp;*/
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
$data['flag_tgl'] = 0;
$data['grid'] = array("Nama Karyawan", "Overtime", "OT. Incidental", "Kelebihan Jam Kerja", "Tunjangan Hari Kerja");
$data['list'] = array("name", "jhk", "ot_incidental", "ot_allow_shift", "ot_cont_allow");
/*if($exp[1] > 0) $filter['group'] = array("employee.id","bulan","tahun");
elseif($exp[0] > 0) $filter['group'] = array("employee.id","tahun");
else */
//$filter['group'] = array("employee.id","tahun");
$filter['id_employee'] = "group";
//else $filter['group'] = array("employee.id");
/*$select = "employee.id as a_id,employee.name, kg_kehadirandetil.id, SUM(kg_kehadirandetil.jhk) as jhk, SUM(kg_kehadirandetil.sakit) as sakit,
SUM(kg_kehadirandetil.cuti) as cuti,SUM(kg_kehadirandetil.ijin) as ijin,,SUM(kg_kehadirandetil.alpa) as alpa,SUM(kg_kehadirandetil.off) as off,
SUM(kg_kehadirandetil.potong_gaji) as potong_gaji, SUM(kg_kehadirandetil.pc) as pc,SUM(kg_kehadirandetil.jh) as jh";
$data['query_all'] = GetJoin("employee","kehadirandetil","kehadirandetil.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);*/
$select = "id, name, id_employee as a_id, SUM(jhk) as jhk, SUM(ot_incidental) as ot_incidental,\n SUM(ot_allow_shift) as ot_allow_shift,SUM(ot_cont_allow) as ot_cont_allow";
$data['query_all'] = GetAllSelect("kg_view_kehadiran", $select, $filter);
//lastq();
$filter['limit'] = $pg . "/" . $per_page;
//$data['query_list'] = GetJoin("employee","kehadirandetil","kehadirandetil.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);
$data['query_list'] = GetAllSelect("kg_view_kehadiran", $select, $filter);
//die($this->db->last_query());
}
if (!$this->uri->segment(3) && !$this->uri->segment(4) && !$this->uri->segment(5)) {
$data['dis_tgl'] = "display:none;";
} else {
$data['dis_tgl'] = "display:''";
}
//Page
$pagination = Page($data['query_all']->num_rows(), $per_page, $pg, $path_paging, $uri_segment);
if (!$pagination) {
$pagination = "<strong>1</strong>";
}
$data['pagination'] = $pagination;
//End Page
$this->load->view('overtime', $data);
}
function ajax_list_ovt($tgl = NULL, $regs = NULL, $div = NULL, $sec = NULL)
{
permission();
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "regs" => $regs, "divisi" => $div, "section" => $sec);
$list = $this->ovt->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="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, $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);
}
$a = 0;
while ($a < $num) {
$b = 0;
$sokvag = mysql_result($result, $a, "sokvag");
$namn = mysql_result($result, $a, "namn");
$result4 = mysql_query("SELECT * FROM mesure where sensor='{$sokvag}' AND manad='{$manad}' order by id ASC");
$num4 = mysql_numrows($result4);
$sensor = substr($sokvag, 11);
$sensor = str_replace("/", "_", $sensor);
$ydata = array();
while ($b < $num4) {
$value = mysql_result($result4, $b, "value");
$ydata[$b] = $value;
$b++;
}
$month = GetMonth();
$file3 = "/var/www/andrix/images/jpgraph/month/" . $sensor . "_" . $month . ".png";
drawdiagram($ydata, $namn, $file3);
$a++;
}
$result5 = mysql_query("SELECT * FROM mesure where sensor='energi' AND timme='{$timme}' order by id ASC");
$num5 = mysql_numrows($result5);
$timmep = $timme - 1;
if ($timmep == '-1') {
$timmep = '23';
}
$namn = "Energi f�rbrukning " . $timmep . ":00 - " . $timme . ":00 kwh";
$file = "/var/www/andrix/images/jpgraph/energihour/energi_" . $timme . ":00.png";
$ydata = array();
$c = 0;
while ($c < $num5) {
<table width="100%" border="0" cellspacing="0">
<tr>
<td width="25%"> </td>
<td width="50%"><div align="center"><strong>Laporan Petty </strong></div></td>
<td width="25%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>Periode : <?php
echo GetMonth((int) substr($periode, 5, 2)) . ' ' . (int) substr($periode, 0, 4);
?>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>From : <?php
echo $this->input->post('from');
?>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0">
<tr class="theader">
<!--td>Code </td-->
echo "<th>" . $r . "</th>";
}
?>
<th class='action'>Action</th>
</tr>
<?php
$style = '';
foreach ($query_list->result_array() as $r) {
/*$getdep=GetValue("id_department", "employee", array("id"=> "where/".$r['id_employee']));
//print_mz($dep);
if($dep){if(in_array($getdep,$dep)){$style.='';}else{$style.='style="display:none;"'; }}*/
echo "<tr {$style} id='listz-" . $r['id'] . "' >";
echo "<td class='box_delete'><input type='checkbox' class='delete' id='del" . $r['id'] . "' value='" . $r['id'] . "'></td>";
foreach ($list as $s) {
if ($s == 'bulan') {
$r['bulan'] = GetMonth(intval($r['bulan'])) . ' ' . $r['tahun'];
}
echo "<td>" . $r[$s] . "</td>";
}
echo "<td class='action'>";
//echo "<a href='".site_url($filename.'/detail/'.$r)."'>Edit</a>";
echo '<a class="btn btn-sm btn-primary" href="javascript:void(0);" title="detail" onclick="editShift(' . "'" . $r['id'] . "'" . ')"><i class="fa fa-edit"></i></a>';
echo "</tr>";
}
?>
</table>
</div>
</form>
</div>
</div>
</div>
function shift_detail($id = 0)
{
//Set Global
permission();
$data = GetHeaderFooter();
$data['path_file'] = $this->filename;
$cont = $data['path_file'] . '_form';
if ($id > 0) {
$cont .= '_old';
}
$data['main_content'] = $cont;
$data['filename'] = $this->filename;
$data['title'] = $this->title;
if ($id > 0) {
$data['val_button'] = lang("edit");
} else {
$data['val_button'] = lang("add");
}
//End Global
$q = GetAll("kg_jadwal_shift", array("id" => "where/" . $id));
$r = $q->result_array();
if ($q->num_rows() > 0) {
$data['val'] = $r[0];
$data['selbul'] = $r[0]['bulan'] . '-' . $r[0]['tahun'];
$data['tgl'] = $r[0];
/*$exp = explode(",", str_replace("-","",$r[0]['lembur_putus']));
foreach($exp as $x) {
$data['pts'][$x] = $x;
}
$exp = explode(",", str_replace("-","",$r[0]['lembur_separo']));
foreach($exp as $x) {
$data['separo'][$x] = $x;
}*/
$data['person_nm'] = GetValue("person_nm", "hris_persons", array("person_id" => "where/" . $r[0]['id_employee']));
$data['group'] = GetValue("employee_grup", "kg_hris_employee", array("person_id" => "where/" . $r[0]['id_employee']));
$data['periode'] = GetMonth(intval($r[0]['bulan'])) . "%20" . $r[0]['tahun'];
} else {
$data['val'] = array();
$data['selbul'] = "";
$data['tgl'] = $data['pts'] = array();
$data['person_nm'] = $data['group'] = "";
}
$this->load->view('shift_detail', $data);
}
<tr>
<th style="width:5%" rowspan="2">No</th>
<th style="width:5%" rowspan="2">NIK</th>
<th style="width:15%" rowspan="2">Name</th>
<th colspan="<?php
echo $cols_start;
?>
"><?php
echo GetMonth(substr($start_date, 5, 2)) . " " . substr($start_date, 0, 4);
?>
</th>
<th colspan="<?php
echo $cols_end;
?>
"><?php
echo GetMonth(substr($end_date, 5, 2)) . " " . substr($end_date, 0, 4);
?>
</th>
</tr>
<tr>
<?php
for ($i = substr($start_date, 8, 2); $i <= $jml_hari_start; $i++) {
echo "<th align='center'>" . $i . "</th>";
}
for ($i = 1; $i <= substr($end_date, 8, 2); $i++) {
echo "<th align='center'>" . $i . "</th>";
}
?>
</tr>
</thead>
<tbody>
$R_Day = mysql_real_escape_string($_POST['R_Day']);
$R_Month = mysql_real_escape_string($_POST['R_Month']);
$R_Year = mysql_real_escape_string($_POST['R_Year']);
switch ($Recurr) {
case 'Week':
$sql_InsertEvent = "INSERT INTO Events (Title,Description,Month,Day,Year,Weight) VALUES ('" . $Title . "','" . $Des . "','" . $Month . "','" . $Day . "','" . $Year . "','" . $Weight . "')";
//Put into Database
if (!mysql_query($sql_InsertEvent)) {
//Issue error if one happens
$Error = "A problem occured will trying to insert the information into the database: " . mysql_error();
} else {
$Recurr_id = mysql_insert_id();
$Month = GetMonth($Month);
$Ref_Time = strtotime($Day . ' ' . $Month . ' ' . $Year);
//Figure out how many weeks are between start date and end date
$R_Month = GetMonth($R_Month);
$End_Time = strtotime($R_Day . ' ' . $R_Month . ' ' . $R_Year);
if ($End_Time - $Ref_Time < 604800) {
//Recurr untill time is set for less then a week, don't recurr
$weeks = 0;
} else {
$weeks = ($End_Time - $Ref_Time) / 604800;
//set recurr id on the original record
$sql_setRecurr = "UPDATE Events SET recurr_id = '" . $Recurr_id . "' WHERE id='" . $Recurr_id . "'";
mysql_query($sql_setRecurr);
}
for ($i = 1; $i <= $weeks; $i++) {
$Ref_Time += 604800;
$Day = date('j', $Ref_Time);
$Month = date('m', $Ref_Time);
$Year = date('Y', $Ref_Time);
function list_shift($report = NULL, $tgl = NULL, $div = NULL, $sec = NULL, $pos = NULL, $grade = NULL)
{
permission();
$data['path_file'] = $this->filename;
if ($this->input->post("start_att") || $tgl) {
if ($tgl) {
$exp = explode("~", $tgl);
$data['start_date'] = $exp[0];
$data['end_date'] = $exp[1];
} else {
$data['start_date'] = $this->input->post("start_att");
if (!$this->input->post("end_att")) {
$data['end_date'] = $data['start_date'];
} else {
$data['end_date'] = $this->input->post("end_att");
}
}
$data['period'] = GetMonth(substr($data['end_date'], 5, 2)) . " " . substr($data['end_date'], 0, 4);
} else {
$dt = "Dec 2015";
//date("M Y");
$period = GetPeriod($dt);
$data['start_date'] = substr($period, 0, 10);
$data['end_date'] = substr($period, 11, 10);
$data['period'] = $dt;
}
$data['jum_kolom'] = 5;
$tgl = $data['start_date'] . "~" . $data['end_date'];
$data['div'] = $this->input->post('s_div') ? $this->input->post('s_div') : $div;
$data['sec'] = $this->input->post('s_sec') ? $this->input->post('s_sec') : $sec;
$data['pos'] = $this->input->post('s_pos') ? $this->input->post('s_pos') : $pos;
$data['grade'] = $this->input->post('s_grade') ? $this->input->post('s_grade') : $grade;
$this->load->model('shift_model', 'shift');
$param = array("bulan" => substr($data['start_date'], 5, 2), "tahun" => substr($data['start_date'], 0, 4), "report" => 1, "divisi" => $data['div'], "section" => $data['sec'], "position" => $data['pos'], "grade" => $data['grade']);
$list = $this->shift->get_datatables($param);
$dataz = array();
$no = 0;
foreach ($list->result_array() as $r) {
$no++;
$dataz[$r['id_employee']][] = $r;
}
$param = array("bulan" => substr($data['end_date'], 5, 2), "tahun" => substr($data['end_date'], 0, 4), "report" => 1, "divisi" => $data['div'], "section" => $data['sec'], "position" => $data['pos'], "grade" => $data['grade']);
$list = $this->shift->get_datatables($param);
foreach ($list->result_array() as $r) {
$dataz[$r['id_employee']][] = $r;
}
//print_mz($dataz);
$data['list'] = $dataz;
$data['report'] = $report;
if (!$report) {
$this->load->view('r_list_shift', $data);
} else {
to_excel($this->load->view('r_list_shift', $data), 'ReportSummaryOfShift');
}
}
