Subversion Repositories SmartDukaan

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

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

	public String getselectPartnerBillingSummaryReport(HttpServletRequest request,

//	public String getselectPartnerBillingSummaryReport(HttpServletRequest request,

			Model model) throws Exception {

//			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

//		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

//	

		LocalDateTime currentDate = LocalDate.now().atStartOfDay();

//		LocalDateTime currentDate = LocalDate.now().atStartOfDay();

		LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

//		LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

//		

		List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository.selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

//		List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository.selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

//		

//		

		model.addAttribute("startDate",currentDate.minusMonths(3).toLocalDate());

//		model.addAttribute("startDate",currentDate.minusMonths(3).toLocalDate());

		model.addAttribute("endDate", LocalDate.now());

//		model.addAttribute("endDate", LocalDate.now());

		model.addAttribute("partnerBillingSummaryReports", partnerBillingSummaryReports);

//		model.addAttribute("partnerBillingSummaryReports", partnerBillingSummaryReports);

//		

		return "partner-billing-summary-report";

//		return "partner-billing-summary-report";

	}

//	}

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

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

	public ResponseEntity<?> getdownloadPartnerBillingSummaryReport(HttpServletRequest request,

//	public ResponseEntity<?> getdownloadPartnerBillingSummaryReport(HttpServletRequest request,

			@RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,

//			@RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,

			@RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)

//			@RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)

			throws Exception {

//			throws Exception {

//

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

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

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

//		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

//		

		LocalDateTime currentDate = LocalDate.now().atStartOfDay();

//		LocalDateTime currentDate = LocalDate.now().atStartOfDay();

		LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

//		LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

//		

		List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository.selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

//		List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository.selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

//	

		for (PartnerBillingSummaryModel pbsr : partnerBillingSummaryReports) {

//		for (PartnerBillingSummaryModel pbsr : partnerBillingSummaryReports) {

//			

			rows.add(Arrays.asList(pbsr.getId(), pbsr.getCreateTimestamp(), pbsr.getBillingTimestamp(),pbsr.getDeliveryTimestamp(),

//			rows.add(Arrays.asList(pbsr.getId(), pbsr.getCreateTimestamp(), pbsr.getBillingTimestamp(),pbsr.getDeliveryTimestamp(),

					pbsr.getDeliveryTimestamp(), pbsr.getPartnerGrnTimestamp() ,pbsr.getTransactionId(), pbsr.getLogisticsTransactionId(),

//					pbsr.getDeliveryTimestamp(), pbsr.getPartnerGrnTimestamp() ,pbsr.getTransactionId(), pbsr.getLogisticsTransactionId(),

					pbsr.getAirwayBillNumber(), pbsr.getStatusSubGroup(), pbsr.getStatusName(),pbsr.getRetailerId(), pbsr.getRetailerName(),pbsr.getItemId(), pbsr.getBrand()

//					pbsr.getAirwayBillNumber(), pbsr.getStatusSubGroup(), pbsr.getStatusName(),pbsr.getRetailerId(), pbsr.getRetailerName(),pbsr.getItemId(), pbsr.getBrand()

					         , pbsr.getModelName(),  pbsr.getModelNumber(),pbsr.getColor(),pbsr.getUnitPrice(), pbsr.getQuantity(),

//					         , pbsr.getModelName(),  pbsr.getModelNumber(),pbsr.getColor(),pbsr.getUnitPrice(), pbsr.getQuantity(),

					          pbsr.getTotalPrice(),pbsr.getInvoiceNumber(), pbsr.getIgstRate(),pbsr.getCgstRate(),pbsr.getSgstRate()));

//					          pbsr.getTotalPrice(),pbsr.getInvoiceNumber(), pbsr.getIgstRate(),pbsr.getCgstRate(),pbsr.getSgstRate()));

//

		}

//		}

//

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

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

				.getCSVByteStream(Arrays.asList("OrderId","CREATION_DATE","BILLING_DATE","DELIVERED_ON","SCANNED_IN_ON"

//				.getCSVByteStream(Arrays.asList("OrderId","CREATION_DATE","BILLING_DATE","DELIVERED_ON","SCANNED_IN_ON"

						,"Transaction_id","master_order_id", "airwaybill_no", "statusSubGroupp", "statusName","customer_id"

//						,"Transaction_id","master_order_id", "airwaybill_no", "statusSubGroupp", "statusName","customer_id"

						  ,  "customer_name","Item_Id", "brand", "model_name",  "model_number" ,"color", "selling_price"

//						  ,  "customer_name","Item_Id", "brand", "model_name",  "model_number" ,"color", "selling_price"

						                 ,"Quantity","total_price","invoice_number","igstrate","cgstrate","sgstrate"), rows);

//						                 ,"Quantity","total_price","invoice_number","igstrate","cgstrate","sgstrate"), rows);

//

		ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Billing Statement Report");

//		ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Billing Statement Report");

//

		return responseEntity;

//		return responseEntity;

//

	}

//	}

//