Subversion Repositories SmartDukaan

import com.fasterxml.jackson.core.JsonProcessingException;

import com.fasterxml.jackson.databind.ObjectMapper;

import com.spice.profitmandi.dao.enumuration.inventory.CatalogMovingEnum;

import com.spice.profitmandi.dao.model.purchaseSaleRatio.BrandWiseSupplier;

import com.spice.profitmandi.dao.model.purchaseSaleRatio.CatalogPurchaseSaleModel;

import com.spice.profitmandi.dao.model.purchaseSaleRatio.PurchaseSaleQuantity;

    @GetMapping(value = "/pur-sale-ratio-panel")

    public String purchaseSaleRatioPanal(Model model) throws JsonProcessingException {

        List<String> brands = Arrays.asList("Vivo", "Oppo", "Samsung", "Realme", "Xiaomi");

        LocalDateTime startDate = LocalDate.now().minusDays(30).atStartOfDay();

        LocalDateTime endDate = LocalDate.now().plusDays(1).atStartOfDay();

        List<PurchaseSaleQuantity> purchaseSaleQuantities = warehouseSupplierInvoiceRepository.selectPurchaseSaleQuantity(startDate, endDate, "Vivo", 0);

        List<BrandWiseSupplier> brandWiseSuppliers = warehouseSupplierInvoiceRepository.selectPeriodAndBrandWiseSuppliers(startDate, endDate, "Vivo");

        ObjectMapper objectMapper = new ObjectMapper();

        String purchaseSaleQuantitiesJSON = objectMapper.writeValueAsString(purchaseSaleQuantities);

        model.addAttribute("brands", brands);

        model.addAttribute("selectedBrand", "Vivo");

        model.addAttribute("startDate", startDate.toLocalDate());

        model.addAttribute("endDate", endDate.toLocalDate());

        model.addAttribute("purchaseSaleQuantities", purchaseSaleQuantitiesJSON);

        model.addAttribute("brandWiseSuppliers", brandWiseSuppliers);

        return "analysis/purchase-sale-ratio-panel";

    }

    @GetMapping(value = "/brandSuppliers")

    public ResponseEntity<?> brandWiseSuppliers(@RequestParam LocalDate startDate, @RequestParam LocalDate endDate,

                                                @RequestParam String brand, @RequestParam(required = false, defaultValue = "0") int supplierId, Model model) {

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime endDate1 = endDate.plusDays(1).atStartOfDay();

        List<BrandWiseSupplier> brandWiseSuppliers = warehouseSupplierInvoiceRepository.selectPeriodAndBrandWiseSuppliers(startDate1, endDate1, brand);

        List<PurchaseSaleQuantity> purchaseSaleQuantities = warehouseSupplierInvoiceRepository.selectPurchaseSaleQuantity(startDate1, endDate1, brand, supplierId);

        Map<String, Object> response = new HashMap<>();

        response.put("brandWiseSuppliers", brandWiseSuppliers);

        response.put("purchaseSaleQuantities", purchaseSaleQuantities);

        return ResponseEntity.ok(response);

    }

    @GetMapping(value = "/pur-sale-quantity")

    public ResponseEntity<?> purchaseSaleQuantity(@RequestParam LocalDate startDate, @RequestParam LocalDate endDate,

                                                  @RequestParam String brand, @RequestParam int supplierId, Model model) {

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime endDate1 = endDate.plusDays(1).atStartOfDay();

        List<PurchaseSaleQuantity> purchaseSaleQuantities = warehouseSupplierInvoiceRepository.selectPurchaseSaleQuantity(startDate1, endDate1, brand, supplierId);

        return ResponseEntity.ok(purchaseSaleQuantities);

    }

    @GetMapping(value = "/catalog-pur-sale-quantity")

    public ResponseEntity<?> catalogSaleQuantity(@RequestParam LocalDate startDate, @RequestParam LocalDate endDate,

                                                 @RequestParam String brand, @RequestParam int supplierId,

                                                 @RequestParam CatalogMovingEnum label) {

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime endDate1 = endDate.atStartOfDay().plusDays(1);

        CatalogMovingEnum status;

        if (label.equals(CatalogMovingEnum.OTHER)) {

            status = null;

        } else {

            status = label;

        }

        List<CatalogPurchaseSaleModel> catalogPurchaseSaleModels =

                warehouseSupplierInvoiceRepository.selectCatalogPurchaseSale(startDate1, endDate1, brand, supplierId, status);

        return ResponseEntity.ok(catalogPurchaseSaleModels);

    }