chore: update image tag to fd17be5 [skip ci]

.gitea/workflows/deploy-api.yaml

@@ -1,23 +1,41 @@
-name: Deploy NestJS API
+name: Build (develop) / Promote (main)
-on: [push]
+on:
+  push:
+    branches: [main]
 
 jobs:
   build-and-push-deploy:
     runs-on: ubuntu-latest
     steps:
       - name: Checkout
-        uses: actions/checkout@v3
+        uses: actions/checkout@v4
+        with:
+          fetch-depth: 0
 
-      - name: Login no Harbor
+      - name: Build and Push
         run: |
-          echo "${{ secrets.HARBOR_PASSWORD }}" | docker login 172.35.0.216 -u ${{ secrets.HARBOR_USERNAME }} --password-stdin
+          REGISTRY="git.simplifiquehc.com.br"
+          IMAGE_NAME="$REGISTRY/simplifique/vendaweb-api"
+          SHA_TAG=$(echo ${{ gitea.sha }} | cut -c1-7)
 
-      - name: Build e Push
+          echo "${{ secrets.K8S }}" | docker login "$REGISTRY" -u "${{ gitea.actor }}" --password-stdin
+
+          docker build -t "$IMAGE_NAME:$SHA_TAG" -t "$IMAGE_NAME:latest" .
+          docker push "$IMAGE_NAME:$SHA_TAG"
+          docker push "$IMAGE_NAME:latest"
+
+      - name: Update Manifest and Push to Git
         run: |
-          TAG=${{ gitea.sha }}
+          SHA_TAG=$(echo ${{ gitea.sha }} | cut -c1-7)
-          docker build -t 172.35.0.216/library/vendaweb-api:$TAG .
+          IMAGE_NAME="git.simplifiquehc.com.br/simplifique/vendaweb-api"
-          docker tag 172.35.0.216/library/vendaweb-api:$TAG 172.35.0.216/library/vendaweb-api:latest
+
-          
+          MANIFEST_FILE="k8s/overlays/prod/deployment-image-digest-patch.yaml"
-          docker push 172.35.0.216/library/vendaweb-api:$TAG
+
-          docker push 172.35.0.216/library/vendaweb-api:latest
+          sed -i "s|image: $IMAGE_NAME:.*|image: $IMAGE_NAME:$SHA_TAG|g" "$MANIFEST_FILE"
-          
+
+          git config user.name "Gitea Action"
+          git config user.email "actions@simplifiquehc.com.br"
+
+          git add "$MANIFEST_FILE"
+          git commit -m "chore: update image tag to $SHA_TAG [skip ci]"
+          git push origin main

Dockerfile

@@ -1,39 +1,55 @@
-# Estágio 1: Build
+ARG NODE_VERSION=16.20
-FROM node:16-bullseye-slim AS builder
+ARG DEBIAN_VARIANT=bullseye
+
+FROM node:${NODE_VERSION}-${DEBIAN_VARIANT} AS builder
 
 WORKDIR /app
-COPY package*.json ./
-RUN npm install --legacy-peer-deps
-COPY . .
-RUN npm run build
 
-FROM node:16-bullseye-slim
+ARG INSTANTCLIENT_ZIP_URL=https://download.oracle.com/otn_software/linux/instantclient/instantclient-basiclite-linuxx64.zip
-# Instalar dependências do Oracle 
+RUN apt-get update \
-RUN apt-get update && apt-get install -y \
+  && apt-get install -y --no-install-recommends ca-certificates wget unzip libaio1 libnsl2 \
-    libaio1 \
+  && rm -rf /var/lib/apt/lists/* \
-    unzip \
+  && mkdir -p /opt/oracle \
-    wget \
+  && wget -q "${INSTANTCLIENT_ZIP_URL}" -O /opt/oracle/instantclient.zip \
-    && mkdir -p /opt/oracle
+  && unzip -q /opt/oracle/instantclient.zip -d /opt/oracle \
+  && rm /opt/oracle/instantclient.zip \
+  && rm -f /opt/oracle/instantclient_*/ojdbc*.jar \
+           /opt/oracle/instantclient_*/ucp*.jar \
+           /opt/oracle/instantclient_*/xstreams.jar \
+           /opt/oracle/instantclient_*/adrci \
+           /opt/oracle/instantclient_*/genezi \
+           /opt/oracle/instantclient_*/uidrvci \
+  && ln -s "$(ls -d /opt/oracle/instantclient_* | head -n 1)" /opt/oracle/instantclient
 
-# Instalar Oracle Instant Client
-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
-
-# Configurar o sistema para encontrar as bibliotecas do Oracle
 ENV LD_LIBRARY_PATH=/opt/oracle/instantclient
-RUN echo "/opt/oracle/instantclient" > /etc/ld.so.conf.d/oracle-instantclient.conf && ldconfig
+ENV PATH=/opt/oracle/instantclient:$PATH
+
+COPY package*.json ./
+ENV NPM_CONFIG_LEGACY_PEER_DEPS=true
+RUN npm ci
+
+COPY . .
+RUN npm run build \
+  && npm prune --omit=dev --legacy-peer-deps \
+  && npm cache clean --force
+
+FROM node:${NODE_VERSION}-${DEBIAN_VARIANT}-slim AS runtime
 
 WORKDIR /app
 
-# Copiar apenas o necessário do estágio anterior
+ENV NODE_ENV=production
-COPY --from=builder /app/dist ./dist
+ENV LD_LIBRARY_PATH=/opt/oracle/instantclient
+ENV PATH=/opt/oracle/instantclient:$PATH
+
+RUN apt-get update \
+  && apt-get install -y --no-install-recommends libaio1 libnsl2 \
+  && rm -rf /var/lib/apt/lists/*
+
+COPY --from=builder /opt/oracle /opt/oracle
 COPY --from=builder /app/package*.json ./
 COPY --from=builder /app/node_modules ./node_modules
+COPY --from=builder /app/dist ./dist
 
-# Variáveis de ambiente padrão para o driver oracledb
+EXPOSE 8065
-ENV OCI_LIB_DIR=/opt/oracle/instantclient
-ENV OCI_INC_DIR=/opt/oracle/instantclient/sdk/include
 
-CMD ["npm", "run", "start:prod"]
+CMD ["node", "dist/main"]

KUBERNETES.md

@@ -31,9 +31,9 @@ O diretório `base` contém as definições padrão dos recursos que são comuns
 ### Deployment (`deployment.yaml`)
 
 - **Nome**: `vendaweb-api`
-- **Replicas**: 15 (Configuração base)
+- **Replicas**: 3 (Base) / 15 (Produção via overlay)
-- **Imagem**: `172.35.0.216/library/vendaweb-api:latest`
+- **Imagem**: `git.simplifiquehc.com.br/simplifique/vendaweb-api:<sha>`
-- **Porta do Container**: 8065
+- **Porta do Container**: 8067
 - **Resources**:
   - Requests: CPU 100m, Memory 256Mi
   - Limits: CPU 500m, Memory 512Mi
@@ -52,7 +52,7 @@ O diretório `base` contém as definições padrão dos recursos que são comuns
 A sobreposição de produção personaliza a configuração base para o ambiente produtivo.
 
 - **Namespace**: `vendaweb-prod`
-- **Patches**: Aplica modificações específicas (ex: digest da imagem, configurações específicas de serviço) via `kustomization.yaml`.
+- **Patches**: Aplica modificações específicas (ex: tag da imagem, NodePort do service, replicas) via `kustomization.yaml`.
 
 ## Deploy com ArgoCD (`k8s/argocd`)
 
@@ -68,7 +68,7 @@ O deploy é gerenciado pelo ArgoCD, que sincroniza o estado do cluster com o rep
   - Path: `k8s/overlays/prod` (Aponta para o overlay de produção)
 - **Destino (Destination)**:
   - Cluster: `https://kubernetes.default.svc`
-  - Namespace: `vendaweb-api` (Nota: O patch define `vendaweb-prod`, verifique a consistência)
+  - Namespace: `vendaweb-prod`
 - **Sync Policy**: Automatizado com `selfHeal` ativado e criação automática de namespace.
 
 ---

WORKFLOWS.md

@@ -14,7 +14,7 @@ Os workflows estão definidos no diretório `.gitea/workflows/`. O principal wor
 
 Este workflow é acionado automaticamente no evento:
 
-- `push`: Em qualquer branch (configuração atual `on: [push]`).
+- `push`: Na branch `main`.
 
 ### Jobs
 
@@ -39,10 +39,13 @@ Este job é responsável por construir a imagem Docker e enviá-la para o regist
 3. **Build e Push**
    - Constrói a imagem Docker da aplicação.
    - Tags geradas:
-     - `172.35.0.216/library/vendaweb-api:$TAG` (onde `$TAG` é o SHA do commit do Gitea `gitea.sha`)
+     - `git.simplifiquehc.com.br/simplifique/vendaweb-api:$TAG` (onde `$TAG` é o SHA curto do commit)
-     - `172.35.0.216/library/vendaweb-api:latest`
+     - `git.simplifiquehc.com.br/simplifique/vendaweb-api:latest`
    - Envia ambas as tags para o registry.
 
+4. **Atualizar Manifest e Push no Git**
+   - Atualiza `k8s/overlays/prod/deployment-image-digest-patch.yaml` para apontar para a tag `$TAG`.
+
 ## Variáveis e Segredos (Secrets)
 
 Para que o workflow funcione corretamente, as seguintes secrets devem estar configuradas nas configurações do repositório no Gitea:

k8s/argocd/application-prod.yaml

@@ -11,9 +11,17 @@ spec:
     path: k8s/overlays/prod
   destination:
     server: https://kubernetes.default.svc
-    namespace: vendaweb-api
+    namespace: vendaweb-prod
   syncPolicy:
     automated:
       selfHeal: true
+      prune: true
+    retry:
+      limit: 2
+      backoff:
+        duration: 5s
+        factor: 2
+        maxDuration: 3m
     syncOptions:
       - CreateNamespace=true
+      - PruneLast=true

k8s/base/deployment.yaml

@@ -5,7 +5,15 @@ metadata:
   labels:
     app: vendaweb-api
 spec:
-  replicas: 15
+  replicas: 3
+  revisionHistoryLimit: 5
+  minReadySeconds: 10
+  progressDeadlineSeconds: 600
+  strategy:
+    type: RollingUpdate
+    rollingUpdate:
+      maxSurge: 1
+      maxUnavailable: 0
   selector:
     matchLabels:
       app: vendaweb-api
@@ -15,10 +23,11 @@ spec:
         app: vendaweb-api
     spec:
       imagePullSecrets:
-        - name: harbor-secret
+        - name: gitea-auth
+      terminationGracePeriodSeconds: 30
       containers:
         - name: api
-          image: 172.35.0.216/library/vendaweb-api:latest
+          image: git.simplifiquehc.com.br/simplifique/vendaweb-api:589fa29
           imagePullPolicy: IfNotPresent
           ports:
             - name: http

k8s/overlays/prod/deployment-image-digest-patch.yaml

@@ -7,4 +7,4 @@ spec:
     spec:
       containers:
         - name: api
-          image: 172.35.0.216/library/vendaweb-api@sha256:aac490fcb4ef7baa95f1df01fa50d2d44bdb4ed12b235e5dd89e1d7dc3cd0a3a
+          image: git.simplifiquehc.com.br/simplifique/vendaweb-api:fd17be5

k8s/overlays/prod/deployment-prod-patch.yaml

@@ -0,0 +1,6 @@
+apiVersion: apps/v1
+kind: Deployment
+metadata:
+  name: vendaweb-api
+spec:
+  replicas: 15

k8s/overlays/prod/kustomization.yaml

@@ -7,5 +7,6 @@ resources:
   - ../../base
 
 patches:
-  - path: deployment-image-digest-patch.yaml
   - path: service-patch.yaml
+  - path: deployment-prod-patch.yaml
+  - path: deployment-image-digest-patch.yaml

src/app.controller.ts

@@ -14,7 +14,7 @@ export class AppController {
   @Get('health')
   @ApiOperation({ summary: 'Health check' })
   healthCheck() {
-    return { status: 'SIMPLIFIQUE HOME CENTER 2026' };
+    return { status: 'SIMPLIFIQUE HOME CENTER 202' };
   }
 
 }

src/main.ts

@@ -16,7 +16,7 @@ async function bootstrap() {
                      do cadastro de parceiros, consulta de venda de movimentação e pagamentos, e fechamento das comissões dos parceiros.`)
     .setVersion("2023.1.2")
     .addTag("VendaWeb")
-    .addTag("Autenticação")
+    .addTag("Auth")
     .build();
   const document = SwaggerModule.createDocument(app, options);
   SwaggerModule.setup("docs", app, document);

src/sales/sales/sales.service.ts

@@ -1448,7 +1448,7 @@ export class SalesService {
         const queryRunner = connectionDb.createQueryRunner();
         await queryRunner.connect();
         try {
-            const sql = 'SELECT  ESVCALCULOFRETE.CODTABELAFRETE as "id"     ' +
+            /*const sql = 'SELECT  ESVCALCULOFRETE.CODTABELAFRETE as "id"     ' +
                 '       ,ESVCALCULOFRETE.CODFILIAL      as "store"              ' +
                 '       ,ESVCALCULOFRETE.CODCIDADE      as "cityId"             ' +
                 '       ,PCCIDADE.NOMECIDADE            as "cityName"           ' +
@@ -1462,7 +1462,22 @@ export class SalesService {
                 '   AND ESVCALCULOFRETE.CODCIDADE = PCCIDADE.CODCIDADE          ' +
                 '   AND ESVCALCULOFRETE.CODCIDADE = :1          ' +
                 '   AND ESVCALCULOFRETE.IDCART = :2             ' +
-                ' ORDER BY VLFRETE';
+                ' ORDER BY VLFRETE';*/
+
+            const sql = `SELECT  0 as "id"     
+                       ,'1'                            as "store"              
+                       ,ESVCALCULOFRETE.CODCIDADE      as "cityId"             
+                       ,PCCIDADE.NOMECIDADE            as "cityName"           
+                       ,NULL                           as "carrierId"          
+                       ,'SIMPLIFIQUE HOMECENTER'       as "carrierName"        
+                       ,0                              as "minSale"            
+                       ,ESVCALCULOFRETE.VLFRETE        as "deliveryValue"      
+                       ,NULL                           as "deliveryTime"       
+                  FROM ESVCALCULOFRETE, PCCIDADE                     
+                 WHERE ESVCALCULOFRETE.CODCIDADE = PCCIDADE.CODCIDADE          
+                   AND ESVCALCULOFRETE.CODCIDADE = :1          
+                   AND ESVCALCULOFRETE.IDCART = :2            
+                 ORDER BY VLFRETE`;
 
             const deliveryTaxTable = await queryRunner.manager
                 .query(sql, [cityId, cartId]);
@@ -1514,7 +1529,22 @@ export class SalesService {
         const queryRunner = connectionDb.createQueryRunner();
         await queryRunner.connect();
         try {
-            const sql = 'SELECT  ESVCALCULOFRETE.CODTABELAFRETE as "id"             ' +
+            const sql = `SELECT  0 as "id"     
+                       ,'1'                            as "store"              
+                       ,ESVCALCULOFRETE.CODCIDADE      as "cityId"             
+                       ,PCCIDADE.NOMECIDADE            as "cityName"           
+                       ,NULL                           as "carrierId"          
+                       ,'SIMPLIFIQUE HOMECENTER'       as "carrierName"        
+                       ,0                              as "minSale"            
+                       ,ESVCALCULOFRETE.VLFRETE        as "deliveryValue"      
+                       ,NULL                           as "deliveryTime"       
+                  FROM ESVCALCULOFRETE, PCCIDADE                     
+                 WHERE ESVCALCULOFRETE.CODCIDADE = PCCIDADE.CODCIDADE          
+                   AND ESVCALCULOFRETE.CODCIDADE = :1          
+                   AND ESVCALCULOFRETE.IDCART = :2            
+                 ORDER BY VLFRETE`;
+
+            /*const sql = 'SELECT  ESVCALCULOFRETE.CODTABELAFRETE as "id"             ' +
                 '       ,ESVCALCULOFRETE.CODFILIAL          as "store"              ' +
                 '       ,ESVCALCULOFRETE.CODCIDADE          as "cityId"             ' +
                 '       ,PCCIDADE.NOMECIDADE                as "cityName"           ' +
@@ -1528,7 +1558,7 @@ export class SalesService {
                 '   AND ESVCALCULOFRETE.CODCIDADE = PCCIDADE.CODCIDADE              ' +
                 '   AND ESVCALCULOFRETE.CODCIDADE = :1                              ' +
                 '   AND ESVCALCULOFRETE.IDCART = :2                                 ' +
-                ' ORDER BY VLFRETE';
+                ' ORDER BY VLFRETE';*/
 
             let deliveryTaxTable = await queryRunner.manager
                 .query(sql, [dataDeliveryTax.cityId, dataDeliveryTax.cartId]);