<div class="hrm-update-notification"></div> <?php //search form $search['language'] = array('label' => __('Language', 'hrm'), 'type' => 'text', 'value' => isset($_POST['language']) ? $_POST['language'] : '', 'desc' => 'please insert language'); $search['type'] = array('type' => 'hidden', 'value' => '_search'); $search['action'] = 'hrm_search'; $search['table_option'] = 'hrm_language'; echo Hrm_Settings::getInstance()->get_serarch_form($search, 'Language'); ?> <div id="hrm-language"></div> <?php $pagenum = hrm_pagenum(); $limit = hrm_result_limit(); if (isset($_POST['type']) && $_POST['type'] == '_search') { $post = $_POST; $results = Hrm_Settings::getInstance()->search_query($post, $limit, $pagenum); $search_satus = true; } else { $results = Hrm_Settings::getInstance()->hrm_query('hrm_language', $limit, $pagenum); $search_satus = false; } $total = $results['total_row']; unset($results['total_row']); $add_permission = hrm_user_can_access($tab, $subtab, 'add') ? true : false; $delete_permission = hrm_user_can_access($tab, $subtab, 'delete') ? true : false; foreach ($results as $key => $value) { if ($delete_permission) { $del_checkbox = '<input name="hrm_check[' . $value->id . ']" value="" type="checkbox">'; } else { $del_checkbox = '';
function hrm_query($table, $limit = 0, $pagenum = 1) { global $wpdb; $tabledb = $wpdb->prefix . $table; $offset = ($pagenum - 1) * $limit; if ($limit) { $limit = "LIMIT {$offset},{$limit}"; } else { $limit = hrm_result_limit(); $limit = "LIMIT 0,{$limit}"; } $results = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS * FROM {$tabledb} ORDER BY id desc {$limit}"); $results['total_row'] = $wpdb->get_var("SELECT FOUND_ROWS()"); return $results; }