Subversion Repositories SmartDukaan

    @RequestMapping(value = "/orderReport", method = RequestMethod.GET)

    public String getOrderReport(HttpServletRequest request, Model model) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

        LocalDate startDate = LocalDate.now().withDayOfMonth(1);

        LocalDate endDate = LocalDate.now();

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        return "order-report";

    }

    @RequestMapping(value = "/downloadOrderReport", method = RequestMethod.GET)

    public ResponseEntity<?> getDownloadOrderReport(HttpServletRequest request,

                                                    @RequestParam(name = "startDate") LocalDate startDate,

                                                    @RequestParam(name = "endDate") LocalDate endDate,

                                                    @RequestParam(name = "fofoId", required = false) Integer fofoId,

                                                    Model model)

            throws Exception {

        // Period not more than a month (safety net behind the date filter)

        if (endDate.isAfter(startDate.plusMonths(1))) {

            endDate = startDate.plusMonths(1);

        }

        // Scope: an admin may target a partner (blank fofoId = all partners); a non-admin

        // is always restricted to their own store, whatever fofoId the client sends.

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

        Integer scopedFofoId = isAdmin ? fofoId : loginDetails.getFofoId();

        List<com.spice.profitmandi.dao.entity.transaction.Order> orders =

                scopedFofoId == null

                        ? orderRepository.selectAllByDatesBetween(startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX))

                        : orderRepository.selectAllByDatesBetween(scopedFofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        List<List<?>> rows = new ArrayList<>();

        rows.add(Arrays.asList(

                "Order ID", "Created", "Verified", "Invoice No", "Billed By", "Billing Date", "Shipping Date",

                "AWB", "Logistics Provider", "Delivery Date", "Quantity", "Amount", "Type", "Status", "Refund Reason",

                "Customer ID", "Customer Name", "Customer City", "Customer Pincode", "Customer State",

                "Item ID", "Product", "Logistics Txn ID", "Received Return Date", "Refund Date"));

        for (com.spice.profitmandi.dao.entity.transaction.Order o : orders) {

            com.spice.profitmandi.dao.entity.transaction.LineItem li = o.getLineItem();

            float amount = (o.getTotalAmount() == null ? 0f : o.getTotalAmount())

                    + (o.getShippingCost() == null ? 0f : o.getShippingCost());

            String product = li == null ? "" : (defaultString(li.getBrand()) + " "

                    + defaultString(li.getModelName()) + " " + defaultString(li.getModelNumber())).trim();

            rows.add(Arrays.asList(

                    o.getId(),

                    FormattingUtils.format(o.getCreateTimestamp()),

                    FormattingUtils.format(o.getVerificationTimestamp()),

                    o.getInvoiceNumber(),

                    o.getBilledBy(),

                    FormattingUtils.format(o.getBillingTimestamp()),

                    FormattingUtils.format(o.getShippingTimestamp()),

                    o.getAirwayBillNumber(),

                    o.getLogisticsProviderId(),

                    FormattingUtils.format(o.getDeliveryTimestamp()),

                    li == null ? null : li.getQuantity(),

                    amount,

                    Boolean.TRUE.equals(o.getCod()) ? "COD" : "PREPAID",

                    o.getStatusDescription(),

                    o.getRefundReason(),

                    o.getRetailerId(),

                    o.getRetailerName(),

                    o.getRetailerCity(),

                    o.getRetailerPinCode(),

                    o.getRetailerState(),

                    li == null ? null : li.getItemId(),

                    product,

                    o.getLogisticsTransactionId(),

                    FormattingUtils.format(o.getReceiverReturnTimestamp()),

                    FormattingUtils.format(o.getRefundTimestamp())));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil

                .getCSVByteStream(Arrays.asList("Order Report : " + startDate + " to " + endDate), rows);

        return orderService.downloadReportInCsv(baos, rows, "Order Report " + startDate + " to " + endDate);

    }

    private static String defaultString(String value) {

        return value == null ? "" : value;

    }