48 lines
1.5 KiB
PHP
Executable File
48 lines
1.5 KiB
PHP
Executable File
<?php
|
|
|
|
namespace Modules\Erp\Controllers;
|
|
|
|
use App\Controllers\BaseAdminController;
|
|
use Modules\Erp\Models\Customer;
|
|
use Symfony\Component\HttpFoundation\Request;
|
|
use Symfony\Component\HttpFoundation\Response;
|
|
|
|
class CustomerController extends BaseAdminController
|
|
{
|
|
public function index(Request $request): Response
|
|
{
|
|
$page = (int)$request->query->get('page', 1);
|
|
$perPage = 15;
|
|
$offset = ($page - 1) * $perPage;
|
|
|
|
$query = Customer::query();
|
|
|
|
// Busca
|
|
$search = $request->query->get('q');
|
|
if (!empty($search)) {
|
|
$query->where(function($q) use ($search) {
|
|
$q->where('cliente_razaosocial', 'like', "%{$search}%")
|
|
->orWhere('cliente_nfantasia', 'like', "%{$search}%")
|
|
->orWhere('cliente_email', 'like', "%{$search}%")
|
|
->orWhere('cliente_cnpj', 'like', "%{$search}%")
|
|
->orWhere('cliente_ccpf', 'like', "%{$search}%");
|
|
});
|
|
}
|
|
|
|
$total = $query->count();
|
|
$customers = $query->orderBy('cliente_id', 'desc')
|
|
->skip($offset)
|
|
->take($perPage)
|
|
->get();
|
|
|
|
return $this->renderAdminView('@erp/admin/customers/index.twig', [
|
|
'customers' => $customers,
|
|
'total' => $total,
|
|
'page' => $page,
|
|
'perPage' => $perPage,
|
|
'totalPages' => ceil($total / $perPage),
|
|
'search' => $search
|
|
]);
|
|
}
|
|
}
|