teste2

.gitea/workflows/deploy-api.yaml

@@ -0,0 +1,30 @@
+name: Deploy NestJS API
+on: [push]
+
+jobs:
+  build-and-push-deploy:
+    runs-on: ubuntu-latest
+    steps:
+      - name: Checkout
+        uses: actions/checkout@v3
+
+      - name: Login no Harbor
+        run: |
+          echo "${{ secrets.HARBOR_PASSWORD }}" | docker login 10.1.1.124:8082 -u ${{ secrets.HARBOR_USERNAME }} --password-stdin
+
+      - name: Build e Push
+        run: |
+          # Usando o short SHA para uma tag mais limpa
+          TAG=$(echo ${{ gitea.sha }} | cut -c1-7)
+          IMAGE_NAME="10.1.1.124:8082/library/vendaweb-api"
+          
+          docker build -t $IMAGE_NAME:$TAG .
+          docker tag $IMAGE_NAME:$TAG $IMAGE_NAME:latest
+          
+          docker push $IMAGE_NAME:$TAG
+          docker push $IMAGE_NAME:latest
+          
+      - name: Notificar Portainer via Webhook
+        run: |
+          # O segredo PORTAINER_WEBHOOK_VENDAWEBAPI deve conter a URL completa gerada na Stack
+          curl -f -X POST "${{ secrets.PORTAINER_WEBHOOK_VENDAWEBAPI }}"

.gitignore

@@ -33,3 +33,5 @@ lerna-debug.log*
 !.vscode/launch.json
 !.vscode/extensions.json
 
+postgres-data/
+.env

Dockerfile

@@ -1,32 +1,24 @@
-FROM node:16
+FROM node:16-bullseye-slim AS builder
+WORKDIR /app
+COPY package*.json ./
+RUN npm install --legacy-peer-deps
+COPY . .
+RUN npm run build
 
+FROM node:16-bullseye-slim
+RUN apt-get update && apt-get install -y libaio1 unzip wget && mkdir -p /opt/oracle
 
-RUN apt-get update && apt-get install -y \
-    apt-transport-https \
-    ca-certificates \
-    libaio1 \
-    unzip \
-    wget \
-    libc6 \
-    libncurses5 && \
-    mkdir -p /opt/oracle && \
-    wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip -O /opt/oracle/instantclient-basic-linuxx64.zip && \
-    unzip /opt/oracle/instantclient-basic-linuxx64.zip -d /opt/oracle && \
-    rm /opt/oracle/instantclient-basic-linuxx64.zip && \
-    ln -s /opt/oracle/instantclient_* /opt/oracle/instantclient && \
-    echo "/opt/oracle/instantclient" > /etc/ld.so.conf.d/oracle-instantclient.conf && \
-    ldconfig
-
+RUN wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip -O /opt/oracle/client.zip && \
+    unzip /opt/oracle/client.zip -d /opt/oracle && \
+    rm /opt/oracle/client.zip && \
+    ln -s /opt/oracle/instantclient_* /opt/oracle/instantclient
 
+ENV LD_LIBRARY_PATH=/opt/oracle/instantclient
 WORKDIR /app
 
+COPY --from=builder /app/dist ./dist
+COPY --from=builder /app/package*.json ./
+COPY --from=builder /app/node_modules ./node_modules
 
-COPY package*.json ./
-
-
-RUN npm install  --legacy-peer-deps
-
-COPY . .
-
-
+EXPOSE 8068
 CMD ["npm", "run", "start:prod"]

docker-compose.yml

@@ -1,14 +1,18 @@
 version: '3.8'
 
 services:
-  vendaweb:
-    image: link70/vendaweb
-    deploy:
-      replicas: 20
-      resources:
-        limits:
-          cpus: '0.5'
-          memory: 512M
+  vendaweb-api:
+    image: 10.1.1.124:8082/library/vendaweb-api:latest
     ports:
-      - "8065:8065"
-    restart: always 
+      - "8068:8068"
+    networks:
+      - simplifique-network
+    deploy:
+      replicas: 4
+      update_config:
+        order: start-first 
+        parallelism: 1
+
+networks:
+  simplifique-network:
+    external: true

src/app.controller.ts

@@ -1,5 +1,5 @@
 import { Controller, Get } from '@nestjs/common';
-import { ApiTags, ApiOperation } from '@nestjs/swagger';
+import { ApiOperation, ApiTags } from '@nestjs/swagger';
 import { APP_VERSION } from './version';
 
 @ApiTags('Main')
@@ -8,13 +8,13 @@ export class AppController {
   @Get('version')
   @ApiOperation({ summary: 'Get App Version' })
   getVersion() {
-    return { version: APP_VERSION };
+     return { version: APP_VERSION };
   }
 
-  @Get('health')
+@Get('health')
 @ApiOperation({ summary: 'Health check' })
 healthCheck() {
-  return { status: 'ok' };
+  return { status: 'TESTE COM Felipe2 ' };
 }
 
 }

src/configs/typeorm.config.ts

@@ -7,12 +7,12 @@ export const typeOrmConfig: TypeOrmModuleOptions = {
   //  username: "LIVIA",  
   //  password: "LIVIA", 
   host: "10.1.1.241",
-  username: "SEVEN",
-  password: "USR54SEV",
+  username: "teste",
+  password: "teste",
   // username: "API", 
   // password: "E05H5KIEQV3YKDJR", 
   port: 1521,
-  sid: "WINT",
+  sid: "BDTESTE",
   synchronize: false,
   logging: false,
   entities: [__dirname + '/../**/*.entity.{js,ts}'],
@@ -22,10 +22,10 @@ export const typeOrmConfig: TypeOrmModuleOptions = {
 export const connectionOptions: ConnectionOptions = {
   type: "oracle",
   host: "10.1.1.241",
-  username: "SEVEN",
-  password: "USR54SEV",
+  username: "teste",
+  password: "teste",
   port: 1521,
-  sid: "WINT",
+  sid: "BDTESTE",
   synchronize: false,
   logging: false,
   entities: [__dirname + '/../**/*.entity.{js,ts}'],

src/main.ts

@@ -20,6 +20,6 @@ async function bootstrap() {
     .build();
   const document = SwaggerModule.createDocument(app, options);
   SwaggerModule.setup("docs", app, document);
-  await app.listen(8065);
-}
+await app.listen(8068, '0.0.0.0');}
+console.log('API rodando na porta 8065 test 4');
 bootstrap();

src/sales/customer/customer.controller.ts

@@ -1,109 +1,148 @@
-import { Body, Controller, Get, HttpException, HttpStatus, Param, Post, Query } from '@nestjs/common';
-import { CustomerService } from './customer.service';
-import { ResultModel } from '../../domain/models/result.model';
+import {
+  Body,
+  Controller,
+  Get,
+  HttpException,
+  HttpStatus,
+  Param,
+  Post,
+  Query,
+} from '@nestjs/common';
+import { ApiTags } from '@nestjs/swagger';
 import { error } from 'console';
 import { Customer } from 'src/domain/models/customer.model';
-import { ApiTags } from '@nestjs/swagger';
+import { ResultModel } from '../../domain/models/result.model';
+import { CustomerService } from './customer.service';
 
 @ApiTags('Customer')
 @Controller('api/v1/customer')
-export class CustomerController { 
+export class CustomerController {
+  constructor(private readonly customerService: CustomerService) {}
 
-    constructor(private readonly customerService: CustomerService){}
+  @Get(':name')
+  async getCustomerByName(@Param('name') name: string) {
+    try {
+      const customers = await this.customerService.findCustomerByName(name);
+      return new ResultModel(true, null, customers, null);
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(
+          false,
+          'Não foi possível consultar o cadastro de clientes.',
+          {},
+          error,
+        ),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
+    }
+  }
 
-    @Get(':name')
-    async getCustomerByName(@Param('name') name: string){
-        try{
-            const customers = await this.customerService.findCustomerByName(name);
-            return new ResultModel(true, null, customers, null);
-        } catch(err){
-            throw new HttpException(new ResultModel(false, 'Não foi possível consultar o cadastro de clientes.', {}, error),
-                 HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Get('categories/fechAll')
+  async getCategories() {
+    try {
+      const categories = await this.customerService.getCategory();
+      return categories;
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(false, err.message, {}, error),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
+  }
 
-    @Get('categories/fechAll')
-    async getCategories(){
-        try{
-            const categories = await this.customerService.getCategory();
-            return categories;
-        } catch(err){
-            throw new HttpException(new ResultModel(false, err.message, {}, error),
-                        HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Get('subcategories/fechAll')
+  async getSubCategories() {
+    try {
+      const subCategories = await this.customerService.getSubCategory();
+      return subCategories;
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(false, err.message, {}, error),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
+  }
 
-    @Get('subcategories/fechAll')
-    async getSubCategories(){
-        try{
-            const subCategories = await this.customerService.getSubCategory();
-            return subCategories;
-        } catch(err){
-            throw new HttpException(new ResultModel(false, err.message, {}, error),
-                        HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Get()
+  async getCustomer(@Query() query) {
+    try {
+      const field = query['field'];
+      const textSearch = query['textsearch'];
+      const customers = await this.customerService.findCustomerByQuery(
+        field,
+        textSearch,
+      );
+      return new ResultModel(true, null, customers, null);
+    } catch (err) {
+      // 'Não foi possível consultar o cadastro de clientes.'
+      throw new HttpException(
+        new ResultModel(false, err.message, {}, error),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
+  }
 
-  
-    @Get()
-    async getCustomer(@Query() query){
-        try{
-            const field = query['field'];
-            const textSearch = query['textsearch'];
-            const customers = await this.customerService.findCustomerByQuery(field, textSearch);
-            return new ResultModel(true, null, customers, null);
-        } catch(err){
-            // 'Não foi possível consultar o cadastro de clientes.'
-            throw new HttpException(new ResultModel(false, err.message, {}, error),
-                 HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Get(':id')
+  async getCustomerById(@Param('id') id: number) {
+    try {
+      const customers = await this.customerService.findCustomerById(id);
+      return new ResultModel(true, null, customers, null);
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(
+          false,
+          'Não foi possível consultar o cadastro de clientes.',
+          {},
+          error,
+        ),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
+  }
 
-    @Get(':id')
-    async getCustomerById(@Param('id') id: number){
-        try{
-            const customers = await this.customerService.findCustomerById(id);
-            return new ResultModel(true, null, customers, null);
-        } catch(err){
-            throw new HttpException(new ResultModel(false, 'Não foi possível consultar o cadastro de clientes.', {}, error),
-                 HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Get('cpf/:cpf')
+  async getCustomerByCpf(@Param('cpf') cpf: string) {
+    try {
+      console.log('pesquisando por cpf');
+      const customer = await this.customerService.findCustomerByCpf(cpf);
+      if (!customer)
+        return new ResultModel(false, 'Cliente não cadastrado', null, null);
+      return new ResultModel(true, null, customer, null);
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(
+          false,
+          'Não foi possível consultar o cadastro de clientes.',
+          {},
+          error,
+        ),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
-    
-    @Get('cpf/:cpf')
-    async getCustomerByCpf(@Param('cpf') cpf: string){
-        try{
-            console.log("pesquisando por cpf");
-            const customer = await this.customerService.findCustomerByCpf(cpf);
-            if (!customer) return new ResultModel(false, 'Cliente não cadastrado', null, null);
-            return new ResultModel(true, null, customer, null);
-        } catch(err){
-            throw new HttpException(new ResultModel(false, 'Não foi possível consultar o cadastro de clientes.', {}, error),
-                 HttpStatus.INTERNAL_SERVER_ERROR);
-        }
-    }
-    @Get('create/proxnumcli')
-    async IdCustomer(){
-        try{
-            console.log('proxnumcli');
-            const id = await this.customerService.generateIdCustomer();
-            return new ResultModel(true, null, id, null);
-        } catch(err){
-            throw err;
-        }
+  }
+  @Get('create/proxnumcli')
+  async IdCustomer() {
+    try {
+      console.log('proxnumcli');
+      const id = await this.customerService.generateIdCustomer();
+      return new ResultModel(true, null, id, null);
+    } catch (err) {
+      throw err;
     }
+  }
 
-
-    @Post('create')
-    async createCustomer(@Body() customer: Customer){
-        try{
-            console.log(customer);
-            const result = await this.customerService.createCustomer(customer);
-            return new ResultModel(true, null, result, null);
-            //return new ResultModel(true, null, id, null);
-        } catch(err){
-            throw new HttpException(new ResultModel(false, 'Erro ao cadastrar cliente.', {}, err),
-                 HttpStatus.INTERNAL_SERVER_ERROR);
-        }
+  @Post('create')
+  async createCustomer(@Body() customer: Customer) {
+    try {
+      console.log(customer);
+      const result = await this.customerService.createCustomer(customer);
+      return new ResultModel(true, null, result, null);
+      //return new ResultModel(true, null, id, null);
+    } catch (err) {
+      throw new HttpException(
+        new ResultModel(false, 'Erro ao cadastrar cliente.', {}, err),
+        HttpStatus.INTERNAL_SERVER_ERROR,
+      );
     }
-}
+  }
+}

src/sales/sales/sales.service.ts

@@ -1503,6 +1503,7 @@ export class SalesService {
 
     async calculateDeliveryTaxOrder(dataDeliveryTax: any) {
         let cityId = await this.customerService.findCity(dataDeliveryTax.ibgeCode);
+        
         await this.updatePriorityDelivery(dataDeliveryTax.cartId, dataDeliveryTax.priorityDelivery);
 
         if (cityId == 0) {