function peticionesByCliente(Request $request, Response $response)
{
$response = $response->withHeader('Content-type', 'application/json');
$email = $request->getAttribute('email');
$data = Peticion::select("peticion.*", "categoria.nombre as categoria")->join("categoria", "categoria.id", "=", "peticion.idCategoria")->where("peticion.idCliente", "=", $email)->get();
formatearFecha($data);
if (count($data) == 0) {
$response = $response->withStatus(404);
}
$response->getBody()->write($data);
return $response;
}
function OfertasDePeticiones(Request $request, Response $response)
{
$response = $response->withHeader('Content-type', 'application/json');
$email = $request->getAttribute('email');
$pet = Peticion::select("id", "nombre", "descripcion")->where("idCliente", "=", $email)->get();
$data = null;
if (count($pet) == 0) {
$response = $response->withStatus(404);
} else {
foreach ($pet as $item) {
$ofe = Oferta::select("empresa.nombre as empresa", "empresa.foto as fotoEmpresa", "sucursal.nombre as sucursal", "sucursal.direccion", "sucursal.latitud", "sucursal.longitud", "oferta.*")->join("usuario", "usuario.id", "=", "oferta.idUsuario")->join("sucursal", "sucursal.id", "=", "usuario.idSucursal")->join("empresa", "sucursal.idEmpresa", "=", "empresa.email")->where("idPeticion", "=", $item['id'])->get();
formatearFecha($ofe);
$data[] = array("Peticion" => $item, "Ofertas" => $ofe);
}
}
$response->getBody()->write(json_encode($data));
return $response;
}
