PHP Decode

ob_end_clean();?><?php
class Kontrol_Menu_Model extends CI_Model { function __construct() { parent::__construct(); } function get_AllData_Parent_Menu() { $data = array(); $this->db->select('*'); $this->db->where('ID_User', $this->input->post('ID_User')); $this->db->where('parent_id', 0); $this->db->from('tView_Menu'); $this->db->order_by('ID_Menu'); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $data[] = $row; } } return $data; } function get_AllData_Child_Menu($parent_id = '') { $data = array(); $this->db->select('*'); $this->db->where('ID_User', $this->input->post('ID_User')); $this->db->where('parent_id', $parent_id); $this->db->from('tView_Menu'); $this->db->order_by('ID_Menu'); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $data[] = $row; } } return $data; } function get_AllData_Child_Menu_From_Parent($parent_id) { $this->db->select('*'); $this->db->where('parent_idmenu', $parent_id); $this->db->from('tuser_semar_menu'); $this->db->order_by('idmenu'); $Q = $this->db->get(); return $Q->num_rows(); } function getAllVariableJSMenuUser() { $result = array(); $gorupid_zs_exmldashboard = $this->session->userdata("gorupid_zs_exmldashboard"); $this->db->select('*'); $this->db->from('tuser_semar_menu_group_menu'); $this->db->join('tuser_semar_menu_group_collections', 'tuser_semar_menu_group_menu.ID_Group_Menu_ID_Group = tuser_semar_menu_group_collections.id_groupcollections', 'left'); $this->db->join('tuser_semar_menu', 'tuser_semar_menu_group_menu.ID_Group_Menu_ID_Menu = tuser_semar_menu.idmenu', 'left'); $this->db->where(array( 'id_groupcollections' => $gorupid_zs_exmldashboard )); $this->db->order_by('ID_Group_Menu_ID_Menu'); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $general_variableprefix = $row['general_variableprefix']; if (strlen($general_variableprefix) > 0) { $result[] = "var " . $general_variableprefix . "_insert = !" . ($row['u_insert'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_update = !" . ($row['u_update'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_delete = !" . ($row['u_delete'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_access = !" . ($row['u_access'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_print = !" . ($row['u_print'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_print_sk = !" . ($row['u_print_sk'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_proses = !" . ($row['u_proses'] == 1 ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_insert_pgw = !" . ($row['u_insert'] ? "true" : "false"); $result[] = "var " . $general_variableprefix . "_delete_pgw = !" . ($row['u_delete'] ? "true" : "false"); } } } return implode("
", $result); } function checkMenuForUser($idmenu) { $status = false; $gorupid_zs_exmldashboard = $this->session->userdata("gorupid_zs_exmldashboard"); $this->db->select('*'); $this->db->from('tuser_semar_menu_group_menu'); $this->db->where('ID_Group_Menu_ID_Menu', $idmenu); $this->db->where('ID_Group_Menu_ID_Group', $gorupid_zs_exmldashboard); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { if ($row['u_access'] == 1 && $status == false) { $status = true; break; } } } return $status; } function get_AllData_Menu_ExtJS($orderby = 'idmenu', $wherex = null) { $resultmenu = array(); $temp = $this->get_AllData_Menu($orderby, $wherex); foreach ($temp as $key => $value) { if ((strtolower($value['general_type']) == 'mainmenu' && $value['general_url'] != "#") || ((strtolower($value['general_type']) == 'tabpage' || strtolower($value['general_type']) == 'popup' || strtolower($value['general_type']) == 'page') && $value['parent_idmenu'] == 0)) { if (((strtolower($value['general_type']) == 'tabpage' || strtolower($value['general_type']) == 'popup' || strtolower($value['general_type']) == 'page') && $value['parent_idmenu'] == 0)) { $temp_handl = 'Load_TabPage'; if (strtolower($value['general_type']) == 'popup') { $temp_handl = 'Load_Popup'; } else if (strtolower($value['general_type']) == 'page') { $temp_handl = 'Load_Page'; } if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true && strlen( $value['general_url'] ) > 0 ) { $resultmenu[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: '" . $value['general_idbutton'] . "', handler: function(){" . $temp_handl . "('" . $value['general_idnewtab_popup'] . "', BASE_URL + '" . $value['general_url'] . "');}}"; } } else { $temp_child = $this->get_AllData_Menu_ExtJS('idmenu', array( 'key' => 'parent_idmenu', 'val' => $value['idmenu'] )); $temp_resultmenu = ""; if (strlen($temp_child) > 7) { $temp_resultmenu = ", menu:{items:[" . $temp_child . "]}"; } if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true) { $resultmenu[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: '" . $value['general_idbutton'] . "'" . $temp_resultmenu . "}"; } } } else if (((strtolower($value['general_type']) == 'mainmenu' && $value['general_url'] == "#") || (strtolower($value['general_type']) == 'tabpage' || strtolower($value['general_type']) == 'popup' || strtolower($value['general_type']) == 'page')) && $wherex != null) { if (strtolower($value['general_type']) == 'mainmenu') { $temp_child = $this->get_AllData_Menu_ExtJS('idmenu', array( 'key' => 'parent_idmenu', 'val' => $value['idmenu'] )); $temp_resultmenu = ""; if (strlen($temp_child) > 7) { $temp_resultmenu = ", menu:{items:[" . $temp_child . "]}"; } if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true) { $resultmenu[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: '" . $value['general_idbutton'] . "'" . $temp_resultmenu . "}"; } } else if ((strtolower($value['general_type']) == 'tabpage' || strtolower($value['general_type']) == 'popup' || strtolower($value['general_type']) == 'page')) { $temp_handl = 'Load_TabPage'; if (strtolower($value['general_type']) == 'popup') { $temp_handl = 'Load_Popup'; } else if (strtolower($value['general_type']) == 'page') { $temp_handl = 'Load_Page'; } if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true && strlen( $value['general_url'] ) > 0 ) { $lp_temp = array(); $lp_temp[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: '" . $value['general_idbutton'] . "', handler: function(){" . $temp_handl . "('" . $value['general_idnewtab_popup'] . "', BASE_URL + '" . $value['general_url'] . "');}}"; if (strtolower($value['general_bottombreak']) == 1) { $lp_temp[] = "'-'"; } $lp_temp = implode(",", $lp_temp); $resultmenu[] = $lp_temp; } } } } return implode(",", $resultmenu); } function get_AllData_Menu_ExtJS_Ref($orderby = 'idmenu', $wherex = null) { $resultmenu = array(); $temp = $this->get_AllData_Menu($orderby, $wherex); foreach ($temp as $key => $value) { if( isset( $value['widget_referensi'] ) ) { if( strlen( $value['widget_referensi'] ) > 0 ) { if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true) { $lp_temp = array(); $lp_temp[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: 'new_tabpanel_MD_" . $value['general_idbutton'] . "', handler: function(){ Load_TabPage_MD('new_tabpanel_MD_" . $value['general_idnewtab_popup'] . "', BASE_URL + '" . $value['widget_referensi'] . "');}, tooltip: {text: '" . $value['general_text'] . "'}}"; $lp_temp = implode(",", $lp_temp); $resultmenu[] = $lp_temp; } } } } return implode(",", $resultmenu); } function get_AllData_Menu_ExtJS_ProfilePNS($orderby = 'idmenu', $wherex = null) { $resultmenu = array(); $resultmenu_btn_true = array(); $resultmenu_btn_false = array(); $temp = $this->get_AllData_Menu($orderby, $wherex); foreach ($temp as $key => $value) { if( isset( $value['widget_profilPNS'] ) ) { if( strlen( $value['widget_profilPNS'] ) > 0 ) { if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true) { $lp_temp = array(); $lp_temp[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: 'new_panel_PPNS_" . $value['general_idbutton'] . "', handler: function(){ Load_Page_PPNS( 'new_panel_PPNS_" . $value['general_idbutton'] . "', 'new_panel_PPNS_" . $value['general_idnewtab_popup'] . "', BASE_URL + '" . $value['widget_profilPNS'] . "');}, tooltip: {text: '" . $value['general_text'] . "'}}"; $lp_temp = implode(",", $lp_temp); $resultmenu[] = $lp_temp; $resultmenu_btn_true[] = 'Ext.getCmp("new_panel_PPNS_' . $value['general_idbutton'] . '").setDisabled(true);'; $resultmenu_btn_false[] = 'Ext.getCmp("new_panel_PPNS_' . $value['general_idbutton'] . '").setDisabled(false);'; } } } } return array( 'menu' => implode(",", $resultmenu), 'btn_true' => implode("
", $resultmenu_btn_true), 'btn_false' => implode("
", $resultmenu_btn_false), ); } function get_AllData_Menu_ExtJS_ESS($orderby = 'idmenu', $wherex = null) { $resultmenu = array(); $temp = $this->get_AllData_Menu($orderby, $wherex); foreach ($temp as $key => $value) { if( isset( $value['widget_ess'] ) ) { if( strlen( $value['widget_ess'] ) > 0 ) { if (strtolower($value['general_status']) == 'active' && $value['general_ismenu'] == 1 && $this->checkMenuForUser($value['idmenu']) == true) { $lp_temp = array(); $lp_temp[] = "{text: '" . $value['general_text'] . "',iconCls: '" . $value['general_iconclass'] . "', id: 'new_tabpanel_ess_" . $value['general_idbutton'] . "', handler: function(){ Load_TabPage_ESS('new_tabpanel_ess_" . $value['general_idnewtab_popup'] . "', BASE_URL + '" . $value['widget_ess'] . "');}, tooltip: {text: '" . $value['general_text'] . "'}}"; $lp_temp = implode(",", $lp_temp); $resultmenu[] = $lp_temp; } } } } return implode(",", $resultmenu); } function get_AllData_Menu($orderby = 'idmenu', $wherex = null) { $data = array(); $this->db->select('*'); $this->db->from('tuser_semar_menu'); $this->db->order_by('ordermenu'); if ($wherex != null) { $this->db->where($wherex['key'], $wherex['val']); } $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $temp_row = $row; if ($row['parent_idmenu'] != 0 && $wherex == null) { $t_row_parent = $this->get_AllData_Menu('idmenu', array( 'key' => 'idmenu', 'val' => $row['parent_idmenu'] )); if (count($t_row_parent) > 0) { $temp_row['parent_text'] = $t_row_parent[0]['general_text']; } } $data[] = $temp_row; } } return $data; } function getUrlMenuByIdentify($identify) { $result = null; $this->db->select('general_url'); $this->db->from('tuser_semar_menu'); $this->db->where('general_identify', $identify); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $result = $row['general_url']; } } return $result; } function Insert_Data_Menu() { $idmenu = $this->input->post('idmenu'); $data = array( 'parent_idmenu' => $this->input->post('parent_idmenu'), 'general_ismenu' => ($this->input->post('general_ismenu') == ('on' || 1) ? 1 : 0), 'general_text' => $this->input->post('general_text'), 'general_variableprefix' => $this->input->post('general_variableprefix'), 'general_iconclass' => $this->input->post('general_iconclass'), 'general_identify' => $this->input->post('general_identify'), 'general_idbutton' => $this->input->post('general_idbutton'), 'general_idnewtab_popup' => $this->input->post('general_idnewtab_popup'), 'general_url' => $this->input->post('general_url'), 'general_type' => $this->input->post('general_type'), 'general_bottombreak' => ($this->input->post('general_bottombreak') == ('on' || 1) ? 1 : 0), 'general_status' => $this->input->post('general_status'), 'process_view' => ($this->input->post('process_view') == ('on' || 1) ? 1 : 0), 'process_tambah' => ($this->input->post('process_tambah') == ('on' || 1) ? 1 : 0), 'process_ubah' => ($this->input->post('process_ubah') == ('on' || 1) ? 1 : 0), 'process_hapus' => ($this->input->post('process_hapus') == ('on' || 1) ? 1 : 0), 'process_proses' => ($this->input->post('process_proses') == ('on' || 1) ? 1 : 0), 'process_cetak' => ($this->input->post('process_cetak') == ('on' || 1) ? 1 : 0), 'process_cetaksk' => ($this->input->post('process_cetaksk') == ('on' || 1) ? 1 : 0) ); if (is_numeric($idmenu) && $idmenu != 0) { $this->db->where('idmenu', $idmenu); $this->db->update('tuser_semar_menu', $data); } else { $this->db->insert('tuser_semar_menu', $data); } return TRUE; } function Delete_Data_Menu() { $records = explode('-', $this->input->post('postdata')); foreach ($records as $id) { $this->db->where('idmenu', $id); $this->db->delete('tuser_semar_menu'); $this->db->close(); } return TRUE; } function get_AllData_Group() { $id_groupcollections = $this->input->post('id_groupcollections'); $data = array(); $this->db->select('*'); $this->db->from('tuser_semar_menu_group_menu'); $this->db->join('tuser_semar_menu_group_collections', 'tuser_semar_menu_group_menu.ID_Group_Menu_ID_Group = tuser_semar_menu_group_collections.id_groupcollections', 'left'); $this->db->join('tuser_semar_menu', 'tuser_semar_menu_group_menu.ID_Group_Menu_ID_Menu = tuser_semar_menu.idmenu', 'left'); if ($id_groupcollections != 0 && $id_groupcollections != null && is_numeric($id_groupcollections)) { $this->db->where('ID_Group_Menu_ID_Group', $id_groupcollections); } $this->db->order_by('ID_Group_Menu'); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $temp_row = $row; if ($row['parent_idmenu'] != 0) { $t_row_parent = $this->get_AllData_Menu('idmenu', array( 'key' => 'idmenu', 'val' => $row['parent_idmenu'] )); if (count($t_row_parent) > 0) { $temp_row['parent_text'] = $t_row_parent[0]['general_text']; } } $data[] = $temp_row; } } return $data; } function Sync_Data_Group($timpah = 0) { $this->db->query('delete from tuser_semar_menu_group_menu'); $status = true; $MenuCollections = $this->get_AllData_Menu('parent_idmenu'); $GroupCollections = $this->get_AllData_GroupCollections(); foreach ($GroupCollections as $key => $value) { $id_groupcollections = $value['id_groupcollections']; foreach ($MenuCollections as $key2 => $value2) { $data = array( 'u_access' => $value2['process_view'], 'u_insert' => $value2['process_tambah'], 'u_update' => $value2['process_ubah'], 'u_delete' => $value2['process_hapus'], 'u_proses' => $value2['process_proses'], 'u_print' => $value2['process_cetak'], 'u_print_sk' => $value2['process_cetaksk'], 'ID_Group_Menu_ID_Menu' => $value2['idmenu'], 'ID_Group_Menu_ID_Group' => $id_groupcollections ); $options = array( 'ID_Group_Menu_ID_Menu' => $value2['idmenu'], 'ID_Group_Menu_ID_Group' => $id_groupcollections ); $Q = $this->db->get_where('tuser_semar_menu_group_menu', $options, 1); if ($Q->num_rows() > 0) { if ($timpah == 1) { foreach ($Q->result_array() as $row) { $this->db->delete('tuser_semar_menu_group_menu', array( 'ID_Group_Menu' => $row['ID_Group_Menu'] )); } $this->db->insert('tuser_semar_menu_group_menu', $data); } } else { $this->db->insert('tuser_semar_menu_group_menu', $data); } } } return $status; } function Insert_Data_Group() { $ID_Group_Menu = $this->input->post('ID_Group_Menu'); $data = array( 'u_access' => ($this->input->post('u_access') != false ? 1 : 0), 'u_insert' => ($this->input->post('u_insert') != false ? 1 : 0), 'u_update' => ($this->input->post('u_update') != false ? 1 : 0), 'u_delete' => ($this->input->post('u_delete') != false ? 1 : 0), 'u_proses' => ($this->input->post('u_proses') != false ? 1 : 0), 'u_print' => ($this->input->post('u_print') != false ? 1 : 0), 'u_print_sk' => ($this->input->post('u_print_sk') != false ? 1 : 0), 'ID_Group_Menu_ID_Menu' => $this->input->post('ID_Group_Menu_ID_Menu'), 'ID_Group_Menu_ID_Group' => $this->input->post('ID_Group_Menu_ID_Group') ); $options = array( 'ID_Group_Menu_ID_Menu' => $this->input->post('ID_Group_Menu_ID_Menu'), 'ID_Group_Menu_ID_Group' => $this->input->post('ID_Group_Menu_ID_Group') ); $Q = $this->db->get_where('tuser_semar_menu_group_menu', $options, 1); if (is_numeric($ID_Group_Menu) && $ID_Group_Menu != 0) { $this->db->where('ID_Group_Menu', $ID_Group_Menu); $this->db->update('tuser_semar_menu_group_menu', $data); return TRUE; } else { if ($Q->num_rows() > 0) { return FALSE; } else { $this->db->insert('tuser_semar_menu_group_menu', $data); return TRUE; } } } function get_AllData_GroupCollections() { $data = array(); $this->db->select('*'); $this->db->from('tuser_semar_menu_group_collections'); $this->db->order_by('id_groupcollections'); $Q = $this->db->get(); if ($Q->num_rows() > 0) { foreach ($Q->result_array() as $row) { $data[] = $row; } } return $data; } function Insert_Data_GroupCollections() { $id_groupcollections = $this->input->post('id_groupcollections'); $data = array( 'general_group_name' => $this->input->post('general_group_name'), 'general_group_active' => ($this->input->post('general_group_active') == ('on' || 1) ? 1 : 0) ); if (is_numeric($id_groupcollections) && $id_groupcollections != 0) { $this->db->where('id_groupcollections', $id_groupcollections); $this->db->update('tuser_semar_menu_group_collections', $data); } else { $this->db->insert('tuser_semar_menu_group_collections', $data); } return TRUE; } function getAllTableFromDatabase() { $data = array(); $tables = $this->db->list_tables(); foreach ($tables as $table) { $data[] = array( 'tablename' => $table ); } return $data; } function getAllFieldsFromTable() { $data1 = array(); $data2 = array(); $data3 = array(); $tablename = $this->input->post('tablename'); if ($tablename != null) { $fields = $this->db->list_fields($tablename); foreach ($fields as $field) { $data1[$field] = false; $data2[$field] = $field; $data3[$field] = 0; } } $data = array( 'boolean' => $data1, 'string' => $data2, 'int' => $data3 ); return $data; } function Sync_Data_Menu_Order( $dataorder ) { $status = false; $dataorder = @json_decode( $dataorder ); if( $dataorder ) { $urutan = 1; foreach( $dataorder as $k ) { $this->Sync_Data_Menu_Order_Update( $k->idmenu, $urutan ); $urutan += 1; } } return $status; } function Sync_Data_Menu_Order_Update( $idmenu, $urutan ) { $this->db->where('idmenu', $idmenu); $this->db->update('tuser_semar_menu', array('ordermenu' => $urutan)); } } ?>