WebSVN – SmartDukaan – Diff – /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

 import javax.mail.MessagingException;
 import javax.mail.internet.InternetAddress;
 import javax.mail.internet.MimeMessage;
 import com.smartdukaan.cron.itelImeiActivation.ItelImeiActivationNewService;
+import com.spice.profitmandi.common.model.*;
+import com.spice.profitmandi.dao.entity.warehouse.*;
 import com.spice.profitmandi.dao.enumuration.transaction.SchemePayoutStatus;
+import com.spice.profitmandi.dao.enumuration.warehouse.WarehouseInvoiceStatus;
+import com.spice.profitmandi.dao.repository.warehouse.*;
 import com.spice.profitmandi.service.*;
+import com.spice.profitmandi.service.warehouse.PurchaseOrderService;
 import org.apache.commons.io.output.ByteArrayOutputStream;
 import org.apache.commons.lang.StringUtils;
 import org.apache.http.client.methods.CloseableHttpResponse;
 import org.apache.http.client.methods.HttpPost;
 import org.apache.http.conn.HttpHostConnectException;
 import com.spice.profitmandi.common.enumuration.ActivationType;
 import com.spice.profitmandi.common.enumuration.MessageType;
 import com.spice.profitmandi.common.enumuration.RechargeStatus;
 import com.spice.profitmandi.common.enumuration.ReporticoProject;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
-import com.spice.profitmandi.common.model.CustomRetailer;
-import com.spice.profitmandi.common.model.FocusedModelShortageModel;
-import com.spice.profitmandi.common.model.GstRate;
-import com.spice.profitmandi.common.model.InvoicePdfModel;
-import com.spice.profitmandi.common.model.ProfitMandiConstants;
-import com.spice.profitmandi.common.model.RechargeCredential;
-import com.spice.profitmandi.common.model.SendNotificationModel;
 import com.spice.profitmandi.common.services.ReporticoService;
 import com.spice.profitmandi.common.services.mandii.AccountStatusResponseOut;
 import com.spice.profitmandi.common.services.mandii.EligibilityStatusEnum;
 import com.spice.profitmandi.common.services.mandii.MandiiService;
 import com.spice.profitmandi.common.util.FileUtil;
 import com.spice.profitmandi.dao.repository.transaction.TransactionRepository;
 import com.spice.profitmandi.dao.repository.transaction.UserWalletHistoryRepository;
 import com.spice.profitmandi.dao.repository.transaction.UserWalletRepository;
 import com.spice.profitmandi.dao.repository.user.AddressRepository;
 import com.spice.profitmandi.dao.repository.user.UserRepository;
-import com.spice.profitmandi.dao.repository.warehouse.BilledImeiModel;
-import com.spice.profitmandi.dao.repository.warehouse.BrandRegionMappingRepository;
-import com.spice.profitmandi.dao.repository.warehouse.WarehouseInventoryItemRepository;
 import com.spice.profitmandi.dao.service.solr.FofoSolr;
 import com.spice.profitmandi.service.integrations.CCAvenuePaymentService;
 import com.spice.profitmandi.service.integrations.RazorpayPaymentService;
 import com.spice.profitmandi.service.integrations.bharti.model.BAGInsuranceModel;
 import com.spice.profitmandi.service.integrations.toffee.ToffeeService;
+        }
+    }
     public void test() throws Exception {
         try {
-            this.sendUnscheduledFollowUpMail();
+            this.migrateDebitNote();
             //itelImeiActivationNewService.checkItelImeiActivationNew(LocalDate.now(), 15);
         } catch (Throwable e) {
             throw new Exception(e);
+        }
         //this.sendMailForAgeingAlert();
         //System.out.println(brandRegionMappingRepository.getAvailabilityToVendorWarehouse(Arrays.asList(33353), 7720));
+    }
+    @Autowired
+    WarehouseDebitNoteRepository warehouseDebitNoteRepository;
+    @Autowired
+    WarehouseDebitNoteLineRepository warehouseDebitNoteLineRepository;
+    @Autowired
+    WarehouseInvoiceItemRepository warehouseInvoiceItemRepository;
+    @Autowired
+    WarehouseSupplierInvoiceRepository warehouseSupplierInvoiceRepository;
+    @Autowired
+    PurchaseOrderService purchaseOrderService;
+    public void migrateDebitNote() {
+        //Delete all debit notes table and then run this
+        List<WarehouseInvoiceItem> warehouseInvoiceItems = warehouseInvoiceItemRepository.selectAll();
+        List<WarehouseSupplierInvoice> invoices = warehouseSupplierInvoiceRepository.selectAllByIds(warehouseInvoiceItems.stream().map(x -> x.getInvoiceId()).distinct().collect(Collectors.toList()));
+        invoices = invoices.stream().filter(x -> x.getStatus().equals(WarehouseInvoiceStatus.received)).collect(Collectors.toList());
+        invoices.stream().forEach(x -> {
+            GrnModel grnModel = new GrnModel();
+            grnModel.setInvoiceId(x.getId());
+            try {
+                purchaseOrderService.generateDebitNote(Arrays.asList(grnModel));
+            } catch (Exception e) {
+                LOGGER.info("Could not create debit note for invoice - ", x.getInvoiceNumber());
+            }
+        });
+    }
 //    private void checkItelImeiActivationNew(LocalDate now, int i) {
 //    }
     @Autowired
     SessionFactory sessionFactory;
             vendorCatalogPricingModel.setAuthId(13);
             vendorCatalogPricingModel.setDp(vendorItemPricing.getDp());
             vendorCatalogPricingModel.setTp(vendorItemPricing.getTp());
             vendorCatalogPricingModel.setMop(vendorItemPricing.getMop());
-            vendorCatalogPricingModel.setEffectedOn(LocalDate.of(2023,8, 22));
+            vendorCatalogPricingModel.setEffectedOn(LocalDate.of(2023, 8, 22));
             vendorCatalogPricingModel.setVendorId(vendorItemPricing.getVendorId());
             try {
                 vendorCatalogPricingService.createVendorCatalogPricingLog(vendorCatalogPricingModel);

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java – Rev 32350 → 32384