Subversion Repositories SmartDukaan

import java.io.File;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileNotFoundException;

import java.time.LocalDate;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.LocalDateTime;

import java.util.*;

import java.util.*;

import java.util.stream.Collectors;

import java.util.stream.Collectors;

@Controller

@Controller

@Transactional(rollbackOn = Throwable.class)

@Transactional(rollbackOn = Throwable.class)

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

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

    public String purchaseSaleRatioPanal(Model model) throws JsonProcessingException {

    public String purchaseSaleRatioPanal(Model model) throws JsonProcessingException {

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

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

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

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

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

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

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

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

        ObjectMapper objectMapper = new ObjectMapper();

        ObjectMapper objectMapper = new ObjectMapper();

        String purchaseSaleQuantitiesJSON = objectMapper.writeValueAsString(purchaseSaleQuantities);

        String purchaseSaleQuantitiesJSON = objectMapper.writeValueAsString(purchaseSaleQuantities);

        model.addAttribute("brands", brands);

        model.addAttribute("brands", brands);

    @GetMapping(value = "/brandSuppliers")

    @GetMapping(value = "/brandSuppliers")

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

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

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

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

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime startDate1 = startDate.atStartOfDay();

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

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

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

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

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

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

        response.put("brandWiseSuppliers", brandWiseSuppliers);

        response.put("brandWiseSuppliers", brandWiseSuppliers);

        response.put("purchaseSaleQuantities", purchaseSaleQuantities);

        response.put("purchaseSaleQuantities", purchaseSaleQuantities);

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

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

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

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

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

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

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime startDate1 = startDate.atStartOfDay();

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

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

        return ResponseEntity.ok(purchaseSaleQuantities);

        return ResponseEntity.ok(purchaseSaleQuantities);

    }

    }

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

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

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

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

                                                 @RequestParam String brand, @RequestParam int supplierId,

                                                 @RequestParam String brand, @RequestParam int supplierId,

                                                 @RequestParam CatalogMovingEnum label) {

                                                 @RequestParam CatalogMovingEnum label) {

        LocalDateTime startDate1 = startDate.atStartOfDay();

        LocalDateTime startDate1 = startDate.atStartOfDay();

        CatalogMovingEnum status;

        CatalogMovingEnum status;

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

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

            status = null;

            status = null;

        } else {

        } else {

            status = label;

            status = label;