Ejemplo n.º 1
0
<?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;
});
Ejemplo n.º 2
0
<?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;
});