<?php
use lalocespedes\Invprodterm;
use Psr\Http\Message\ServerRequestInterface as Request;
use Psr\Http\Message\ResponseInterface as Response;
$app->get('/api/invprodterm', function (Request $request, Response $response) {
$params = $request->getParams();
if (isset($params['term'])) {
$query = Invprodterm::select('PTNumArticulo', 'PTDesc', 'PTPrecioVta')->where('PTNumArticulo', 'like', '%' . $params['term'] . '%')->orWhere('PTDesc', 'like', '%' . $params['term'] . '%');
} else {
$query = new Invprodterm();
}
$response = $this->response->withStatus(200)->withHeader('Content-type', 'application/json')->write(json_encode(['total' => $query->count(), 'items' => $query->take(5)->get()]));
return $response;
});
<?php
use lalocespedes\Invprodterm;
use Psr\Http\Message\ServerRequestInterface as Request;
use Psr\Http\Message\ResponseInterface as Response;
$app->get('/api/invprodterm/{PTNumArticulo}', function (Request $request, Response $response, $args) {
$query = Invprodterm::select('PTNumArticulo', 'PTDesc', 'PTPrecioVta')->where('PTNumArticulo', $args['PTNumArticulo'])->first();
$response = $this->response->withStatus(200)->withHeader('Content-type', 'application/json')->write(json_encode(['item' => $query]));
return $response;
});