function shift_update()
{
$webmaster_id = permission();
$id = $this->input->post('id');
$GetColumns = GetColumns("kg_jadwal_shift");
$bulan = $this->input->post("bulan");
$tahun = $this->input->post("tahun");
$jml_hari = GetJumHari($bulan, $tahun);
$flag = 0;
foreach ($GetColumns as $r) {
if ($r['Field'] == "tgl_" . $jml_hari) {
$flag = 1;
}
if (!$flag) {
$data[$r['Field']] = $this->input->post($r['Field']);
} else {
if ($r['Field'] == "tgl_" . $jml_hari) {
$data[$r['Field']] = $this->input->post($r['Field']);
}
}
}
//print_mz($data);
$hitung = array_count_values($data);
//print_mz($hitung);
if (!isset($hitung['1'])) {
$hitung['1'] = 0;
}
if (!isset($hitung['2'])) {
$hitung['2'] = 0;
}
if (!isset($hitung['3'])) {
$hitung['3'] = 0;
}
if (!isset($hitung['ns'])) {
$hitung['ns'] = 0;
}
if (!isset($hitung['off'])) {
$hitung['off'] = 0;
}
$data['jum_p'] = $hitung['1'];
$data['jum_s'] = $hitung['2'];
$data['jum_m'] = $hitung['3'];
$data['jum_ns'] = $hitung['ns'];
$data['jum_off'] = $hitung['off'];
//$data['bulan']=$period[0];
//$data['tahun']=$period[1];
$data['modify_date'] = date("Y-m-d H:i:s");
/*$lembur_putus="";
$pts = $this->input->post("pts");
if(is_array($pts)) {
foreach($pts as $val)
{
if($val) $lembur_putus .= "-".$val."-,";
}
}
$lembur_putus = substr($lembur_putus, 0, -1);
$data['lembur_putus'] = $lembur_putus;
$lembur_separo="";
$separo = $this->input->post("separo");
if(is_array($separo)) {
foreach($separo as $val)
{
if($val) $lembur_separo .= "-".$val."-,";
}
}
$lembur_separo = substr($lembur_separo, 0, -1);
$data['lembur_separo'] = $lembur_separo;*/
//die($lembur_putus."S");
//print_mz($data);
if ($id > 0) {
$data['modify_user_id'] = $webmaster_id;
$this->db->where("id", $id);
$this->db->update("kg_jadwal_shift", $data);
//Admin Log
//$logs = $this->db->last_query();
//$this->model_admin_all->LogActivities($webmaster_id,$this->tabel,$this->db->insert_id(),$logs,lang($this->filename),$data[$this->title_table],$this->filename,"Add");
//$this->session->set_flashdata("message", lang('edit')." ".$this->title." ".lang('msg_sukses'));
} else {
$data['create_user_id'] = $webmaster_id;
$data['create_date'] = $data['modify_date'];
//print_mz($data);
$this->db->insert("kg_jadwal_shift", $data);
$id = $this->db->insert_id();
//Admin Log
//$logs = $this->db->last_query();
//$this->model_admin_all->LogActivities($webmaster_id,$this->tabel,$this->db->insert_id(),$logs,lang($this->filename),$data[$this->title_table],$this->filename,"Add");
//$this->session->set_flashdata("message", lang('add')." ".$this->title." ".lang('msg_sukses'));
}
//if($this->input->post("stay")) redirect($this->filename.'/detail/'.$id);
//else redirect($this->filename);
}
function update_shift()
{
$webmaster_id = permission();
$id = $this->input->post('id');
$GetColumns = GetColumns("kg_jadwal_shift");
$bulan = $this->input->post("bulan");
$tahun = $this->input->post("tahun");
$jml_hari = GetJumHari($bulan, $tahun);
$flag = 0;
foreach ($GetColumns as $r) {
if ($r['Field'] == "tgl_" . $jml_hari) {
$flag = 1;
}
if (!$flag) {
$data[$r['Field']] = strtolower($this->input->post($r['Field']));
} else {
if ($r['Field'] == "tgl_" . $jml_hari) {
$data[$r['Field']] = strtolower($this->input->post($r['Field']));
}
}
}
//print_mz($data);
$hitung = array_count_values($data);
//print_mz($hitung);
if (!isset($hitung['1'])) {
$hitung['1'] = 0;
}
if (!isset($hitung['2'])) {
$hitung['2'] = 0;
}
if (!isset($hitung['3'])) {
$hitung['3'] = 0;
}
if (!isset($hitung['reg'])) {
$hitung['reg'] = 0;
}
if (!isset($hitung['off'])) {
$hitung['off'] = 0;
}
$data['jum_p'] = $hitung['1'];
$data['jum_s'] = $hitung['2'];
$data['jum_m'] = $hitung['3'];
$data['jum_ns'] = $hitung['reg'];
$data['jum_off'] = $hitung['off'];
//$data['bulan']=$period[0];
//$data['tahun']=$period[1];
$data['modify_date'] = date("Y-m-d H:i:s");
//print_mz($data);
if ($id > 0) {
$data['modify_user_id'] = $webmaster_id;
$this->db->where("id", $id);
$this->db->update("kg_jadwal_shift", $data);
//Admin Log
//$logs = $this->db->last_query();
//$this->model_admin_all->LogActivities($webmaster_id,$this->tabel,$this->db->insert_id(),$logs,lang($this->filename),$data[$this->title_table],$this->filename,"Add");
//$this->session->set_flashdata("message", lang('edit')." ".$this->title." ".lang('msg_sukses'));
} else {
$data['create_user_id'] = $webmaster_id;
$data['create_date'] = $data['modify_date'];
//print_mz($data);
$this->db->insert("kg_jadwal_shift", $data);
$id = $this->db->insert_id();
//Admin Log
//$logs = $this->db->last_query();
//$this->model_admin_all->LogActivities($webmaster_id,$this->tabel,$this->db->insert_id(),$logs,lang($this->filename),$data[$this->title_table],$this->filename,"Add");
//$this->session->set_flashdata("message", lang('add')." ".$this->title." ".lang('msg_sukses'));
}
$this->detail_shift($id);
}
