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_employee()
{
$webmaster_id = permission();
$id = $this->input->post('id');
$GetColumns = GetColumns("hris_persons");
foreach ($GetColumns as $r) {
if ($this->input->post($r['Field'] . "_file") || isset($_FILES[$r['Field']]['name'])) {
if ($_FILES[$r['Field']]['name']) {
$data[$r['Field']] = InputFile($r['Field'], 1000);
if ($data[$r['Field']] == "2") {
$this->session->set_flashdata("message", lang('msg_err_size'));
redirect($this->filename . '/detail/' . $id);
} else {
if ($data[$r['Field']] == "3") {
$this->session->set_flashdata("message", lang('msg_err_ext'));
redirect($this->filename . '/detail/' . $id);
}
}
$file_old = $this->input->post($r['Field'] . "_file");
if (file_exists("./" . $this->config->item('path_upload') . "/" . $file_old) && $file_old) {
unlink("./" . $this->config->item('path_upload') . "/" . $file_old);
}
$thumb = GetThumb($file_old);
if (file_exists("./" . $this->config->item('path_upload') . "/" . $thumb) && $thumb) {
unlink("./" . $this->config->item('path_upload') . "/" . $thumb);
}
}
} else {
$data[$r['Field']] = $this->input->post($r['Field']);
$data[$r['Field'] . "_temp"] = $this->input->post($r['Field'] . "_temp");
if ($r['Field'] == "userpass") {
if ($data[$r['Field']] != $data[$r['Field'] . "_temp"]) {
$data[$r['Field']] = md5($this->config->item('encryption_key') . $data[$r['Field']]);
}
}
if (!$data[$r['Field']] && !$data[$r['Field'] . "_temp"]) {
unset($data[$r['Field']]);
}
unset($data[$r['Field'] . "_temp"]);
}
}
$dt = date("Y-m-d H:i:s");
//$data['group_shift'] = $this->input->post("group_shift");
//print_mz($data);
if ($id > 0) {
//Insert ke tabel history
/*$q = GetAll($this->tabel, array("id"=> "where/".$id));
$history = $q->result_array();
$history[0]['modify_date'] = date("Y-m-d H:i:s");
$this->db->insert($this->tabel."_history", $history[0]);*/
//$data['modify_user_id'] = $webmaster_id;
$this->db->where("person_id", $id);
$this->db->update("hris_persons", $data);
$this->exe_shift($id, $this->input->post('group_shift_active'));
//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['created_dttm'] = $dt;
$this->db->insert("hris_persons", $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->list_employee();
}
$Context->WarningCollector->Add("An error occurred while querying for an unauthenticated role. MySQL returned the following error message: <code>" . mysql_error($Context) . "</code>");
} else {
if (mysql_num_rows($RoleData) == 0) {
// Insert a new unauthenticated role
$InsertSQL = "insert into " . $DatabaseTables['Role'] . "\r\n(`Name`, `Active`, `PERMISSION_SIGN_IN`, `PERMISSION_HTML_ALLOWED`, `PERMISSION_RECEIVE_APPLICATION_NOTIFICATION`, `Permissions`, `Priority`, `UnAuthenticated`)\r\nVALUES ('Unauthenticated','1','1','1','1','a:32:{s:23:\"PERMISSION_ADD_COMMENTS\";N;s:27:\"PERMISSION_START_DISCUSSION\";N;s:28:\"PERMISSION_STICK_DISCUSSIONS\";N;s:27:\"PERMISSION_HIDE_DISCUSSIONS\";N;s:28:\"PERMISSION_CLOSE_DISCUSSIONS\";N;s:27:\"PERMISSION_EDIT_DISCUSSIONS\";N;s:34:\"PERMISSION_VIEW_HIDDEN_DISCUSSIONS\";N;s:24:\"PERMISSION_EDIT_COMMENTS\";N;s:24:\"PERMISSION_HIDE_COMMENTS\";N;s:31:\"PERMISSION_VIEW_HIDDEN_COMMENTS\";N;s:44:\"PERMISSION_ADD_COMMENTS_TO_CLOSED_DISCUSSION\";N;s:25:\"PERMISSION_ADD_CATEGORIES\";N;s:26:\"PERMISSION_EDIT_CATEGORIES\";N;s:28:\"PERMISSION_REMOVE_CATEGORIES\";N;s:26:\"PERMISSION_SORT_CATEGORIES\";N;s:28:\"PERMISSION_VIEW_ALL_WHISPERS\";N;s:29:\"PERMISSION_APPROVE_APPLICANTS\";N;s:27:\"PERMISSION_CHANGE_USER_ROLE\";N;s:21:\"PERMISSION_EDIT_USERS\";N;s:31:\"PERMISSION_IP_ADDRESSES_VISIBLE\";N;s:30:\"PERMISSION_MANAGE_REGISTRATION\";N;s:21:\"PERMISSION_SORT_ROLES\";N;s:20:\"PERMISSION_ADD_ROLES\";N;s:21:\"PERMISSION_EDIT_ROLES\";N;s:23:\"PERMISSION_REMOVE_ROLES\";N;s:28:\"PERMISSION_CHECK_FOR_UPDATES\";N;s:38:\"PERMISSION_CHANGE_APPLICATION_SETTINGS\";N;s:28:\"PERMISSION_MANAGE_EXTENSIONS\";N;s:26:\"PERMISSION_MANAGE_LANGUAGE\";N;s:24:\"PERMISSION_MANAGE_STYLES\";N;s:27:\"PERMISSION_ALLOW_DEBUG_INFO\";N;s:27:\"PERMISSION_DATABASE_CLEANUP\";N;}',0,'1')";
if (!@mysql_query($InsertSQL, $Connection)) {
$Context->WarningCollector->Add("An error occurred while inserting a new unauthenticated role. MySQL returned the following error message: <code>" . mysql_error($Context) . "</code>");
}
}
}
}
if ($Context->WarningCollector->Count() == 0) {
// Retrieve Category Columns
$CategoryColumns = GetColumns($Connection, $DatabaseTables['Category']);
$DiscussionColumns = GetColumns($Connection, $DatabaseTables['Discussion']);
$UserColumns = GetColumns($Connection, $DatabaseTables['User']);
// Make remaining table alterations
if (in_array('Order', $CategoryColumns) && !in_array('Priority', $CategoryColumns)) {
$AlterSQL = "alter table " . $DatabaseTables['Category'] . " change `Order` Priority int not null default '0'";
if (!@mysql_query($AlterSQL, $Connection)) {
$Context->WarningCollector->Add("An error occurred renaming LUM_Category.Order to LUM_Category.Priority. MySQL reported the following error: <code>" . mysql_error($Connection) . '</code>');
}
}
if ($Context->WarningCollector->Count() == 0) {
if (in_array('Settings', $UserColumns) && !in_array('Preferences', $UserColumns)) {
$AlterSQL = "alter table " . $DatabaseTables['User'] . " change Settings Preferences text";
if (!@mysql_query($AlterSQL, $Connection)) {
$Context->WarningCollector->Add("An error occurred renaming LUM_User.Settings to LUM_User.Preferences. MySQL reported the following error: <code>" . mysql_error($Connection) . '</code>');
}
}
}
function add()
{
permissionUser();
//print_mz($this->input->post());
$webmaster_id = $this->session->userdata('user_id');
$id = $this->input->post('id');
$GetColumns = GetColumns($this->file_name);
foreach ($GetColumns as $r) {
$data[$r['Field']] = $this->input->post($r['Field']);
$data[$r['Field'] . "_temp"] = $this->input->post($r['Field'] . "_temp");
if (!$data[$r['Field']] && !$data[$r['Field'] . "_temp"]) {
unset($data[$r['Field']]);
}
unset($data[$r['Field'] . "_temp"]);
}
//konversi mata uang
$data['amount'] = str_replace(',', '', $data['amount']);
$data['kurs'] = str_replace(',', '', $data['kurs']);
if ($data['kurs'] == '' || $data['kurs'] == NULL) {
$data['kurs'] == 1;
}
$data['rv'] = $data['amount'];
if ($data['currency'] == '1') {
$data['amount'] = $data['rv'] * $data['kurs'];
} elseif ($data['currency'] == '2') {
$data['amount'] = $data['rv'] * $data['kurs'];
}
//$data['rv']=$data['amount'];
///$data['kurs']=getkurs($data['rc']);
//$data['amount']=$data['rv']*$data['kurs'];
//--------konversi mata uang
/* if(!$this->input->post('global')){$data['global']='N';}
else{$data['global']='Y';} */
if ($id > 0) {
/* if(!$this->input->post('password')){unset($data['password']);}
else{$data['password']=md5($this->config->item('encryption_key').$this->input->post("password"));} */
$data['modify_by'] = $webmaster_id;
$data['modify_on'] = date("Y-m-d");
$this->db->where("id", $id);
$this->db->update($this->file_name, $data);
$this->session->set_flashdata("message", 'Sukses diedit');
} else {
//$data['number']=generatenumbering('petty'.$webmaster_id); //if($this->input->post('password')){$data['password']=md5($this->config->item('encryption_key').$this->input->post("password"));}
//if(!$this->input->post('avatar')){$data['avatar']='default.png';}
$data['created_by'] = $webmaster_id;
$data['created_on'] = date("Y-m-d H:i:s");
$this->db->insert($this->file_name, $data);
$id = $this->db->insert_id();
//addnumbering('petty'.$webmaster_id);
$this->session->set_flashdata("message", 'Sukses ditambahkan');
}
rekening('cash_transfer', $id, $data['dari'], 'out', $data['amount'], $data['kurs'], $data['currency']);
rekening('cash_transfer', $id, $data['ke'], 'in', $data['amount'], $data['kurs'], $data['currency']);
redirect($this->module . '/' . $this->file_name, 'refresh');
}
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);
}
function update()
{
$webmaster_id = $this->session->userdata('user_id');
$id = $this->input->post('id');
$GetColumns = GetColumns($this->file_name);
foreach ($GetColumns as $r) {
$data[$r['Field']] = $this->input->post($r['Field']);
$data[$r['Field'] . "_temp"] = $this->input->post($r['Field'] . "_temp");
if (!$data[$r['Field']] && !$data[$r['Field'] . "_temp"]) {
unset($data[$r['Field']]);
}
unset($data[$r['Field'] . "_temp"]);
}
$data['is_active'] = $this->input->post('is_active') ? 'Active' : 'inActive';
echo $id;
/* if(!$this->input->post('global')){$data['global']='N';}
else{$data['global']='Y';} */
if ($id != NULL && $id != '') {
/* if(!$this->input->post('password')){unset($data['password']);}
else{$data['password']=md5($this->config->item('encryption_key').$this->input->post("password"));} */
$data['modify_user_id'] = $webmaster_id;
$data['modify_date'] = date("Y-m-d");
$this->db->where("id", $id);
$this->db->update($this->file_name, $data);
$this->session->set_flashdata("message", 'Sukses diedit');
} else {
//$data['number']=generatenumbering('ledger');
//if($this->input->post('password')){$data['password']=md5($this->config->item('encryption_key').$this->input->post("password"));}
//if(!$this->input->post('avatar')){$data['avatar']='default.png';}
$data['create_user_id'] = $webmaster_id;
$data['create_date'] = date("Y-m-d H:i:s");
$this->db->insert($this->file_name, $data);
$id = $this->db->insert_id();
//addnumbering('ledger');
$this->session->set_flashdata("message", 'Sukses ditambahkan');
}
redirect($this->module . '/' . $this->file_name);
}
if ($query === null || preg_match($query, $match[4])) {
// ...or if the file name matches what's being searched for
array_push($packs, new Pack($botName, $match[1], $match[2], $match[3], $match[4]));
// create Pack object and add it to pack array
}
}
unset($botName);
}
fclose($handle);
}
}
usort($packs, function ($a, $b) {
return strcmp($a->name, $b->name);
// not UTF-8 aware yet
});
$columns = GetColumns();
// get an array of Column objects
// output actual HTML
?>
<form role="search" method="get" class="search-form" action="<?php
echo plugin_dir_url(__FILE__);
?>
search-redirect.php">
<label>
<span class="screen-reader-text"><?php
echo _x('Search for:', 'label');
?>
</span>
<input type="search" class="search-field" placeholder="<?php
echo esc_attr_x('Search …', 'placeholder');
?>
function email_alert_update()
{
$webmaster_id = permission();
$id = $this->input->post('id');
$GetColumns = GetColumns("kg_config_email_alert");
foreach ($GetColumns as $r) {
if ($this->input->post($r['Field'])) {
$data[$r['Field']] = $this->input->post($r['Field']);
}
}
//print_mz($data);
if ($id > 0) {
$this->db->where("id", $id);
$this->db->update("kg_config_email_alert", $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 {
//print_mz($data);
$this->db->insert("kg_config_email_alert", $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->email_alert();
}
