public function users_list()
{
$table = 'users';
$columns = array("username", "nombre", "apellido", "email", "status");
$Searchable = array("username", "nombre", "apellido", "email", "status");
echo TableSearch::get($table, $columns, $Searchable);
}
public function pagos_dt()
{
$table = 'pagos';
$columns = array("clientes.dpi as dpi", "CONCAT_WS(' ',users.nombre,users.apellido) as usuario", "CONCAT_WS(' ',clientes.nombre,clientes.apellido) as cliente", "clientes.direccion_actual as direccion", "meloneras.melonera as melonera", "cuadrillas.cuadrilla as cuadrilla", "pagos.saldo_anterior as saldo_anterior", "pagos.monto as monto", "pagos.saldo_actual as saldo_actual", "pagos.created_at as fecha");
$Searchable = array("clientes.dpi", "clientes.nombre", "clientes.apellido", "clientes.direccion", "meloneras.melonera", "cuadrillas.cuadrilla", "pagos.monto", "pagos.created_at");
$Join = " JOIN users ON (pagos.user_id = users.id) ";
$Join .= " JOIN clientes ON (pagos.cliente_id = clientes.id) ";
$Join .= " JOIN cuadrillas ON (cuadrilla_id = cuadrillas.id) ";
$Join .= " JOIN meloneras ON (melonera_id = meloneras.id) ";
$where = " pagos.monto > 0 ";
echo TableSearch::get($table, $columns, $Searchable, $Join, $where);
}
