public void generarPedido() throws SQLException {
		Long aux = codigoPedido();
		for (Map<String,Object> rep : getRepuestosEscasos()){
			List<Map<String, Object>> proveedores = findProveedorMasBarato((Long)rep.get("codigo"));
			Map<String,Object> proveedor = proveedores.get(0);
			for (Map<String,Object> proveedor1: proveedores){
				if (proveedorUsadoYPedido((long)proveedor1.get("id"))){
					proveedor = proveedor1;
					break;
				}
			}
				if (!proveedorUsado((Long)proveedor.get("id"))){
					PreparedStatement pst = null;
					try {
						pst = c.prepareStatement(Conf.get("SQLinsertPedido"));
						pst.setLong(1, aux);
						pst.setDate(2,  java.sql.Date.valueOf(java.time.LocalDate.now()));
						pst.setDate(3, null);
						pst.setString(4, "PEDIDO");
						pst.setLong(5,(Long) proveedor.get("id"));
						pst.executeUpdate();
					} catch (SQLException e) {
						throw e;
					} finally {
						Jdbc.close(pst);
					}
				}else {
					//aux = getIdPedidoDeProveedor((Long) proveedor.get("id"));
				}
				PreparedStatement pst = null;
				try {
					pst = c.prepareStatement(Conf.get("SQLinsertRepuestoPedido"));
					pst.setLong(1,(int)rep.get("min_existencias") - (int)rep.get("existencias"));
					pst.setDouble(2, getPrecio((Long) rep.get("id"), (Long) proveedor.get("id")) );
					pst.setLong(3, (Long) rep.get("id"));
					pst.setLong(4, getIdPedido(aux));
					pst.executeUpdate();
				} catch (SQLException e) {
					throw e;
				} finally {
					Jdbc.close(pst);
				}
			}
		}