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(); }