Subversion Repositories SmartDukaan

        // Feeds the brand-filter dropdown on the "Warehouse Wise Report" widget.

        // Filter itself is applied via AJAX to /getWarehouseStockByBrand; loading is unaffected.

        model.addAttribute("whrBrandList", saholicInventoryCISRepository.selectAllBrand());

    /**

     * Reproduces the Warehouse Wise Report data-fetch used by {@link #adminPanel} but

     * with an optional brand filter, so the main dashboard can swap the widget's rows

     * without a full page reload. Permission scope (fofoIds) is resolved with the

     * same rules as adminPanel so a user only ever sees their own warehouse territory.

     *

     * @param email  logged-in user's email — used for fofoId scope resolution

     * @param brands non-empty → filter to these brands; null/empty → all brands (identical to adminPanel behavior)

     */

    public LinkedHashMap<Integer, WarehouseWiseStockModel> getWarehouseStockMap(String email, List<String> brands) throws Exception {

        LinkedHashMap<Integer, WarehouseWiseStockModel> warehouseStockSortedMap = new LinkedHashMap<>();

        AuthUser authUser = authRepository.selectByEmailOrMobile(email);

        List<Position> positions = positionRepository.selectAllByAuthUserId(authUser.getId());

        boolean isRbmL3OrAbove = positions.stream().anyMatch(pos ->

                pos.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_RBM

                        && pos.getEscalationType() != null

                        && pos.getEscalationType() != EscalationType.L1

                        && pos.getEscalationType() != EscalationType.L2);

        boolean isSalesL5OrAbove = positions.stream().anyMatch(pos ->

                pos.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_SALES

                        && pos.getEscalationType() != null

                        && pos.getEscalationType() != EscalationType.L1

                        && pos.getEscalationType() != EscalationType.L2

                        && pos.getEscalationType() != EscalationType.L3

                        && pos.getEscalationType() != EscalationType.L4);

        boolean canSeeAllStores = isRbmL3OrAbove || isSalesL5OrAbove;

        Set<Integer> fofoIds;

        if (canSeeAllStores) {

            fofoIds = fofoStoreRepository.selectActiveStores().stream().map(x -> x.getId()).collect(Collectors.toSet());

        } else {

            fofoIds = csService1.getAuthFofoIds(email, true);

        }

        if (fofoIds == null || fofoIds.isEmpty()) return warehouseStockSortedMap;

        Map<Integer, List<Integer>> warehouseIdFofoIdMap = getWarehouseIdFofoIdMap(fofoIds);

        List<Integer> warehouseIds = new ArrayList<>(warehouseIdFofoIdMap.keySet());

        List<WarehouseWiseStockModel> warehouseStocks;

        if (brands == null || brands.isEmpty()) {

            warehouseStocks = saholicInventoryCISRepository.selectGroupByWarehouse(warehouseIds);

        } else {

            warehouseStocks = saholicInventoryCISRepository.selectGroupByWarehouseFilteredByBrands(warehouseIds, brands);

        }

        Map<Integer, WarehouseWiseStockModel> warehouseStockMap =

                warehouseStocks.stream().collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));

        if (!warehouseStockMap.isEmpty()) {

            long stockValue = 0, stockQty = 0, pendingIndent = 0, tertiary = 0;

            for (Entry<Integer, WarehouseWiseStockModel> e : warehouseStockMap.entrySet()) {

                stockValue += e.getValue().getStockValue();

                stockQty += e.getValue().getStockQty();

                pendingIndent += e.getValue().getPendingIndent();

                tertiary += e.getValue().getTertiary();

            }

            WarehouseWiseStockModel totals = new WarehouseWiseStockModel();

            totals.setStockQty(stockQty);

            totals.setStockValue(stockValue);

            totals.setPendingIndent(pendingIndent);

            totals.setTertiary(tertiary);

            totals.setWarehouseId(0);

            warehouseStockMap.put(0, totals);

        }

        warehouseStockMap.entrySet().stream()

                .sorted(Map.Entry.comparingByKey(Comparator.reverseOrder()))

                .forEachOrdered(x -> warehouseStockSortedMap.put(x.getKey(), x.getValue()));

        return warehouseStockSortedMap;

    }