<?php include('../connection.php');
$sql = "SELECT * FROM empleados ";
$query = mysqli_query($con, $sql);
$count_all_rows = mysqli_num_rows($query);
if (isset($_POST['search']['value'])) {
$search_value = $_POST['search']['value'];
$sql .= "WHERE cedula LIKE '%" . $search_value . "%' ";
$sql .= "OR nombre LIKE '%" . $search_value . "%' ";
$sql .= "OR apellido LIKE '%" . $search_value . "%' ";
$sql .= "OR rh LIKE '%" . $search_value . "%' ";
$sql .= "OR ccosto LIKE '%" . $search_value . "%' ";
$sql .= "OR descripcion LIKE '%" . $search_value . "%' ";
$sql .= "OR cargo LIKE '%" . $search_value . "%' ";
$sql .= "OR area LIKE '%" . $search_value . "%' ";
$sql .= "OR rango LIKE '%" . $search_value . "%' ";
}
if (isset($_POST['order'])) {
$column = $_POST['order'][0]['column'];
$order = $_POST['order'][0]['dir'];
$sql .= " ORDER BY '" . $column . "' " . $order;
} else {
$sql .= " ORDER BY id ASC";
}
$length = (isset($_POST["length"])) ? $_POST["length"] : -1;
$start = (isset($_POST["start"])) ? $_POST["start"] : 0;
if ($_POST['length'] != -1) {
$start = $_POST['start'];
$length = $_POST['length'];
$sql .= " LIMIT " . $start . ", " . $length;
}
$data = array();
$run_query = mysqli_query($con, $sql);
$filtered_rows = mysqli_num_rows($run_query);
while ($row = mysqli_fetch_assoc($run_query)) {
$subarray = array();
$subarray[] = $row['id'];
$subarray[] = $row['cedula'];
$subarray[] = $row['nombre'];
$subarray[] = $row['apellido'];
$subarray[] = $row['rh'];
$subarray[] = $row['ccosto'];
$subarray[] = $row['descripcion'];
$subarray[] = $row['cargo'];
$subarray[] = $row['area']; // <-- nuevo campo
$subarray[] = $row['rango'];
$subarray[] = '<a href="javascript:void(0);" data-id="' . $row['id'] . '" class="btn btn-md btn-info p-2 m-2 editBtn">Editar</a>'
. '<a href="javascript:void(0);" data-id="' . $row['id'] . '" class="btn btn-md btn-danger p-2 m-2 btnDelete">Eliminar</a>';
$data[] = $subarray;
}
$output = array(
'data' => $data,
'draw' => intval($_POST['draw']),
'recordsTotal' => $count_all_rows,
'recordsFiltered' => $filtered_rows,
);
print json_encode($output);