<?php
/* -- DEFINED VARIABLE -- */
// REQUEST
$category_id = $_REQUEST['cat_id'];
// CALL FUNCTION
$category = get_city($category_id);
$check = count_job($category_id);
$city = get_cities();
//$category_name =
if (isset($_POST['btn_detail_store_job'])) {
// DEFINED VARIABLE
$active = '1';
$visibility = $_POST['visibility_status'];
$city_name = stripslashes($_POST['category_name']);
$cat_id = $_POST['cat_id'];
$category = $_POST['category_department'];
$desc = stripslashes($_POST['career_description']);
$map = stripslashes($_POST['category_maps']);
if ($_POST['btn_detail_job'] == 'Delete') {
delete($cat_id);
$_SESSION['alert'] = 'success';
$_SESSION['msg'] = 'Item has been successfully deleted.';
} else {
update($city_name, $category, $desc, $map, $visibility, $cat_id);
$_SESSION['alert'] = 'success';
$_SESSION['msg'] = 'Item has been successfully saved.';
}
}
echo "<input type=\"hidden\" name=\"sort_by\" id=\"sort_by\" class=\"hidden\" value=\"" . $sort_by . "\" /> \n";
echo "<input type=\"hidden\" name=\"search\" id=\"search\" class=\"hidden\" value=\"" . $search_parameter . "-" . $search_value . "\" /> \n";
/* -- BUTTON RESET -- */
if (empty($search_parameter)) {
$reset = "hidden";
} else {
$reset = "";
}
if (isset($_POST['btn_index_store_city'])) {
// DEFINED VARIABLE
$id = $_POST['category_id'];
$action = $_POST['option-action'];
$option = $_POST['option-option'];
if ($action == 'delete') {
foreach ($id as $id) {
$check = count_job($id);
if ($check['rows'] > 0) {
$_SESSION['alert'] = 'error';
$_SESSION['msg'] = "Can't delete item(s) because it contains one or more item(s)";
} else {
delete($id);
$_SESSION['alert'] = 'success';
$_SESSION['msg'] = "Item(s) has been successfully removed";
}
}
} else {
if ($action == 'visibility') {
foreach ($id as $id) {
if ($option == 'yes') {
update_visibility(1, $id);
} else {
$pgdata = page_init($equal_search, $default_sort_by);
// static/general.php
$page = $pgdata['page'];
$query_per_page = $pgdata['query_per_page'];
$sort_by = $pgdata['sort_by'];
$first_record = $pgdata['first_record'];
$search_parameter = $pgdata['search_parameter'];
$search_value = $pgdata['search_value'];
$search_query = $pgdata['search_query'];
$search = $pgdata['search'];
if (empty($_REQUEST['cat']) || $_REQUEST['cat'] == 'all') {
$cat = '';
} else {
$cat = "AND category_name = '" . $_REQUEST['cat'] . "' ";
}
$full_order = count_job($search_query, $sort_by, $query_per_page, $cat);
$total_query = $full_order['total_query'];
$total_page = ceil($full_order['total_query'] / $query_per_page);
// CALL FUNCTION
$listing_order = get_job($search_query, $sort_by, $first_record, $query_per_page, $cat);
// OPTION CATEGORY
$category = get_category();
// HANDLING ARROW SORTING
if ($_REQUEST['srt'] == "category_name DESC") {
$arr_order_number = "<span class=\"sort-arrow-up\"></span>";
} else {
if ($_REQUEST['srt'] == "category_name") {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
} else {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
}
<option value="1">Yes</option>
<option value="0">No</option>
</select>
</th>
</tr>
</thead>
<tbody>
<?php
if ($total_query < 1) {
echo '<tr><td class="no-record" colspan="8">No records found.</td></tr>';
}
$row = 0;
foreach ($listing_order as $all_category) {
$row++;
$getTotal = count_job($all_category['category_id']);
?>
<tr id="<?php
echo "row_" . $row;
?>
" onclick="selectRow('<?php
echo $row;
?>
')">
<td><input type="checkbox" name="category_id[]" value="<?php
echo $all_category['category_id'];
?>
" id="<?php
echo "check_" . $row;
?>
| SORTING |
|--------------------|
*/
$equal_search = array('visibility');
$default_sort_by = "filter_name";
$pgdata = page_init($equal_search, $default_sort_by);
// static/general.php
$page = $pgdata['page'];
$query_per_page = $pgdata['query_per_page'];
$sort_by = $pgdata['sort_by'];
$first_record = $pgdata['first_record'];
$search_parameter = $pgdata['search_parameter'];
$search_value = $pgdata['search_value'];
$search_query = $pgdata['search_query'];
$search = $pgdata['search'];
$full_order = count_job($search_query, $query_per_page);
$total_query = $full_order['total_query'];
$total_page = ceil($full_order['total_query'] / $query_per_page);
// CALL FUNCTION
$listing_order = get_job($search_query, $sort_by, $first_record, $query_per_page);
// OPTION CATEGORY
$category = get_category();
// HANDLING ARROW SORTING
if ($_REQUEST['srt'] == "category_name DESC") {
$arr_order_number = "<span class=\"sort-arrow-up\"></span>";
} else {
if ($_REQUEST['srt'] == "category_name") {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
} else {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
}
