Subversion Repositories SmartDukaan

Rev

Rev 30702 | Rev 31437 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21561 ashik.ali 1
package com.spice.profitmandi.web.controller;
21555 kshitij.so 2
 
30289 amit.gupta 3
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
4
import com.spice.profitmandi.common.model.ProfitMandiConstants;
30694 amit.gupta 5
import com.spice.profitmandi.common.model.ScanSerializedRequest;
30289 amit.gupta 6
import com.spice.profitmandi.common.web.client.RestClient;
30694 amit.gupta 7
import com.spice.profitmandi.common.web.util.ResponseSender;
8
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
30289 amit.gupta 9
import com.spice.profitmandi.dao.entity.transaction.Order;
30694 amit.gupta 10
import com.spice.profitmandi.dao.model.ImeiInoviceModel;
11
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
30715 amit.gupta 12
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
30289 amit.gupta 13
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
14
import com.spice.profitmandi.service.authentication.RoleManager;
15
import com.spice.profitmandi.service.inventory.PurchaseService;
30380 amit.gupta 16
import com.spice.profitmandi.service.transaction.invoicing.InvoiceService;
30289 amit.gupta 17
import com.spice.profitmandi.web.model.LoginDetails;
18
import com.spice.profitmandi.web.util.CookiesProcessor;
30394 amit.gupta 19
import org.apache.commons.io.IOUtils;
30289 amit.gupta 20
import org.apache.http.HttpResponse;
30394 amit.gupta 21
import org.apache.http.entity.ContentType;
30289 amit.gupta 22
import org.apache.logging.log4j.LogManager;
23569 govind 23
import org.apache.logging.log4j.Logger;
21574 ashik.ali 24
import org.springframework.beans.factory.annotation.Autowired;
30289 amit.gupta 25
import org.springframework.core.io.InputStreamResource;
26
import org.springframework.http.HttpHeaders;
27
import org.springframework.http.HttpStatus;
30380 amit.gupta 28
import org.springframework.http.MediaType;
30289 amit.gupta 29
import org.springframework.http.ResponseEntity;
21555 kshitij.so 30
import org.springframework.stereotype.Controller;
21636 ashik.ali 31
import org.springframework.transaction.annotation.Transactional;
21574 ashik.ali 32
import org.springframework.ui.Model;
30694 amit.gupta 33
import org.springframework.web.bind.annotation.*;
21555 kshitij.so 34
 
30289 amit.gupta 35
import javax.servlet.http.HttpServletRequest;
30394 amit.gupta 36
import java.io.ByteArrayInputStream;
30380 amit.gupta 37
import java.io.ByteArrayOutputStream;
30289 amit.gupta 38
import java.io.File;
30394 amit.gupta 39
import java.io.InputStream;
30289 amit.gupta 40
import java.time.LocalDateTime;
30380 amit.gupta 41
import java.util.*;
30387 amit.gupta 42
import java.util.stream.Collectors;
30380 amit.gupta 43
import java.util.zip.ZipEntry;
44
import java.util.zip.ZipOutputStream;
21555 kshitij.so 45
 
30395 amit.gupta 46
import static org.springframework.util.FileCopyUtils.BUFFER_SIZE;
47
 
21555 kshitij.so 48
@Controller
30289 amit.gupta 49
@Transactional(rollbackFor = Throwable.class)
21582 kshitij.so 50
public class PurchaseController {
21555 kshitij.so 51
 
23569 govind 52
	private static final Logger LOGGER = LogManager.getLogger(PurchaseController.class);
30289 amit.gupta 53
 
21574 ashik.ali 54
	@Autowired
22927 ashik.ali 55
	private PurchaseService purchaseService;
30289 amit.gupta 56
 
23076 ashik.ali 57
	@Autowired
30715 amit.gupta 58
	private PurchaseRepository purchaseRepository;
59
 
60
	@Autowired
30694 amit.gupta 61
	private InventoryItemRepository inventoryItemRepository;
62
 
63
	@Autowired
23076 ashik.ali 64
	private OrderRepository orderRepository;
21640 kshitij.so 65
 
21574 ashik.ali 66
	@Autowired
30289 amit.gupta 67
	RestClient restClient;
68
	@Autowired
69
	private RoleManager roleManager;
70
 
71
	@Autowired
30694 amit.gupta 72
	private ResponseSender responseSender;
73
 
74
	@Autowired
22927 ashik.ali 75
	private CookiesProcessor cookiesProcessor;
21640 kshitij.so 76
 
30380 amit.gupta 77
	@Autowired
78
	private InvoiceService invoiceService;
21640 kshitij.so 79
 
21587 kshitij.so 80
	@RequestMapping(value = "/purchase", method = RequestMethod.GET)
30289 amit.gupta 81
	public String purchase(HttpServletRequest request) throws Exception {
21587 kshitij.so 82
		return "purchase";
83
	}
30289 amit.gupta 84
 
23076 ashik.ali 85
	@RequestMapping(value = "/pendingGrn", method = RequestMethod.GET)
30289 amit.gupta 86
	public String pendingGrn(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
23076 ashik.ali 87
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
88
		LOGGER.info("Request Received at url {}", request.getRequestURI());
89
		List<Order> pendingGrns = orderRepository.selectShipmentToDeliveredByRetailerId(fofoDetails.getFofoId());
90
		model.addAttribute("pendingGrns", pendingGrns);
91
		return "pending-grn";
92
	}
30289 amit.gupta 93
 
30694 amit.gupta 94
	@RequestMapping(value = "/purchase/validate-imeis", method = RequestMethod.POST)
95
	public ResponseEntity<?> validatePurchaseImeis(HttpServletRequest request, @RequestBody ImeiInoviceModel imeiInoviceModel, Model model) throws ProfitMandiBusinessException {
96
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
97
		return responseSender.ok(this.getImeiValidationMap(fofoDetails.getFofoId(), imeiInoviceModel));
98
	}
99
 
100
	private Map<String, Boolean> getImeiValidationMap(int fofoId, ImeiInoviceModel imeiInoviceModel) throws ProfitMandiBusinessException {
101
		LOGGER.info("serialNumbers - {}", imeiInoviceModel.getSerialNumbers());
102
		Set<String> serialNumbers = new HashSet<>(orderRepository.selectSerialNumbers(imeiInoviceModel.getInvoiceNumber(), fofoId, imeiInoviceModel.getSerialNumbers()));
103
		Map<String, Boolean> imeiValidationMap = new HashMap<>();
104
		imeiInoviceModel.getSerialNumbers().stream().forEach(x -> {
30715 amit.gupta 105
			imeiValidationMap.put(x, true);
30694 amit.gupta 106
		});
107
		if (serialNumbers.size() > 0) {
108
			List<InventoryItem> inventoryItems = inventoryItemRepository.selectByFofoIdSerialNumbers(fofoId, new HashSet<>(serialNumbers), false);
30715 amit.gupta 109
			Set<String> grnedSerialNumberSet = inventoryItems.stream().filter(x -> x.getPurchase().getPurchaseReference().equals(imeiInoviceModel.getInvoiceNumber()))
110
					.map(x -> x.getSerialNumber()).collect(Collectors.toSet());
111
			imeiInoviceModel.getSerialNumbers().stream().forEach(imei -> {
112
				if (grnedSerialNumberSet.contains(imei)) {
113
					imeiValidationMap.put(imei, false);
114
				}
30694 amit.gupta 115
			});
30715 amit.gupta 116
 
30694 amit.gupta 117
		}
118
		return imeiValidationMap;
119
	}
120
 
121
	@RequestMapping(value = "/purchase/grn-imeis", method = RequestMethod.POST)
122
	public ResponseEntity<?> grnImeis(HttpServletRequest request, @RequestBody ImeiInoviceModel imeiInoviceModel, Model model) throws ProfitMandiBusinessException {
123
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
124
		Map<String, Boolean> imeiValidationMap = this.getImeiValidationMap(fofoDetails.getFofoId(), imeiInoviceModel);
125
		if (imeiValidationMap.values().stream().filter(x -> !x).findFirst().isPresent()) {
126
			throw new ProfitMandiBusinessException("Found invalid imeis cant proceed", "invalid imeis", "invalid imeis");
127
		}
128
 
129
		Map<Integer, List<String>> itemSerialNumberMap = orderRepository.selectItemSerialNumberMap(imeiInoviceModel.getInvoiceNumber(), fofoDetails.getFofoId(), imeiInoviceModel.getSerialNumbers());
130
		for (Map.Entry<Integer, List<String>> itemSerialNumberEntry : itemSerialNumberMap.entrySet()) {
131
			ScanSerializedRequest scanSerializedRequest = new ScanSerializedRequest();
132
			scanSerializedRequest.setSerialNumbers(itemSerialNumberEntry.getValue());
133
			scanSerializedRequest.setInvoiceNumber(imeiInoviceModel.getInvoiceNumber());
134
			scanSerializedRequest.setItemId(itemSerialNumberEntry.getKey());
135
			purchaseService.scanSerializedItems(scanSerializedRequest, fofoDetails.getFofoId());
136
		}
137
		return responseSender.ok(true);
138
	}
139
 
30701 amit.gupta 140
	@RequestMapping(value = "/purchase/get-imeis", method = RequestMethod.GET)
30702 amit.gupta 141
	public ResponseEntity<?> getImeis(HttpServletRequest request, @RequestParam String invoiceNumber, @RequestParam int itemId) throws ProfitMandiBusinessException {
30701 amit.gupta 142
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
143
		List<String> serialNumbers = orderRepository.selectSerialNumbersByInvoiceItem(invoiceNumber, itemId, fofoDetails.getFofoId());
144
		ImeiInoviceModel imeiInoviceModel = new ImeiInoviceModel();
145
		imeiInoviceModel.setInvoiceNumber(invoiceNumber);
146
		imeiInoviceModel.setSerialNumbers(serialNumbers);
147
		List<String> validSerialNumbers = this.getImeiValidationMap(fofoDetails.getFofoId(), imeiInoviceModel).entrySet().stream().filter(x -> x.getValue()).map(x -> x.getKey()).collect(Collectors.toList());
148
		return responseSender.ok(validSerialNumbers);
149
	}
30694 amit.gupta 150
 
30701 amit.gupta 151
 
23076 ashik.ali 152
	@RequestMapping(value = "/pendingGrnDetails", method = RequestMethod.GET)
30289 amit.gupta 153
	public String pendingGrnDetails(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, Model model) throws ProfitMandiBusinessException {
23076 ashik.ali 154
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
155
		LOGGER.info("Request Received at url [{}] with orderId [{}]", request.getRequestURI(), orderId);
156
		model.addAttribute("pendingGrnDetails", purchaseService.getShippingDetailByOrderId(orderId, fofoDetails.getFofoId()));
157
		return "pending-grn-details";
158
	}
30289 amit.gupta 159
 
30380 amit.gupta 160
	@RequestMapping(value = "/purchaseByInvoiceNumber", method = RequestMethod.GET)
161
	public String purchaseByAirwayBillOrInvoiceNumber(HttpServletRequest request,
162
													  @RequestParam(name = ProfitMandiConstants.AIRWAY_BILL_OR_INVOICE_NUMBER)
163
													  String airwayBillOrInvoiceNumber, Model model) throws ProfitMandiBusinessException {
164
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
165
		LOGGER.info("Request Received at url {} with airwayBillOrInvoiceNumber {}", request.getRequestURI(), airwayBillOrInvoiceNumber);
166
		Map<String, Object> map = purchaseService.purchaseByInvoiceNumber(airwayBillOrInvoiceNumber, fofoDetails.getFofoId());
167
		model.addAllAttributes(map);
168
		return "purchase";
169
	}
170
 
30289 amit.gupta 171
	@RequestMapping(value = "/purchase-invoice/{invoiceNumber}", method = RequestMethod.GET)
30380 amit.gupta 172
	public ResponseEntity<?> downloadInvoice(HttpServletRequest request, @PathVariable String invoiceNumber, Model model) throws Exception {
30289 amit.gupta 173
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
30380 amit.gupta 174
		List<String> invoiceNumbers = Arrays.asList(invoiceNumber.replaceAll(" ", "").split(","));
30387 amit.gupta 175
		Map<String, List<Order>> invoiceOrdersMap = orderRepository.selectByInvoiceNumbers(invoiceNumbers).stream().collect(Collectors.groupingBy(x -> x.getInvoiceNumber()));
176
		if (invoiceOrdersMap.size() > 0) {
177
			if (roleManager.isAdmin(fofoDetails.getRoleIds()) || invoiceOrdersMap.get(invoiceNumbers.get(0)).get(0).getRetailerId() == fofoDetails.getFofoId()) {
30289 amit.gupta 178
 
30380 amit.gupta 179
				final HttpHeaders headers = new HttpHeaders();
180
				headers.setContentType(MediaType.APPLICATION_PDF);
30289 amit.gupta 181
				headers.set("Content-Type", "application/pdf");
182
				headers.set("Content-disposition", "inline; filename=" + invoiceNumber + ".pdf");
30380 amit.gupta 183
 
30381 amit.gupta 184
				if (false) {
185
					/*InvoicePdfModel invoicePdfModel = invoiceService.getInvoicePdfModel(orders);
30380 amit.gupta 186
 
187
					ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
188
					List<InvoicePdfModel> pdfModels = new ArrayList<>();
189
					pdfModels.add(invoicePdfModel);
190
					PdfUtils.generateAndWrite(pdfModels, byteArrayOutputStream);
191
					final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
192
					final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
193
					LOGGER.info("Before stream - {}", pdfModels);
30381 amit.gupta 194
					return new ResponseEntity<>(inputStreamResource, headers, HttpStatus.OK);*/
30380 amit.gupta 195
				} else {
196
					Map<String, String> headersMap = new HashMap<>();
30566 amit.gupta 197
					headersMap.put("Authorization", "Basic " + Base64.getEncoder().encodeToString("smartdukaan:$smart@123#".getBytes()));
30380 amit.gupta 198
					if (invoiceNumbers.size() == 1) {
30387 amit.gupta 199
						String invoicePath = this.getInvoicePath(invoiceOrdersMap.get(invoiceNumbers.get(0)).get(0));
30570 amit.gupta 200
						HttpResponse response = restClient.getResponse("http://45.79.106.95/" + invoicePath, null, headersMap);
30380 amit.gupta 201
						InputStreamResource is = new InputStreamResource(response.getEntity().getContent());
202
						return new ResponseEntity<>(is, headers, HttpStatus.OK);
203
 
204
					} else {
205
 
206
						ByteArrayOutputStream fos = new ByteArrayOutputStream();
207
						ZipOutputStream zipOut = new ZipOutputStream(fos);
208
 
209
						for (String invoice : invoiceNumbers) {
30387 amit.gupta 210
							List<Order> orders = invoiceOrdersMap.get(invoice);
30380 amit.gupta 211
							String invoicePath = this.getInvoicePath(orders.get(0));
30570 amit.gupta 212
							HttpResponse response = restClient.getResponse("http://45.79.106.95/" + invoicePath, null, headersMap);
30395 amit.gupta 213
							this.addFileToZip(zipOut, response.getEntity().getContent(), invoice + ".pdf");
30380 amit.gupta 214
						}
30395 amit.gupta 215
						zipOut.close();
30380 amit.gupta 216
						byte[] byteArray = fos.toByteArray();
30394 amit.gupta 217
						headers.set("Content-Type", ContentType.APPLICATION_OCTET_STREAM.getMimeType());
30389 amit.gupta 218
						headers.set("Content-disposition", "attachment; filename=invoices.zip");
30380 amit.gupta 219
						headers.setContentLength(byteArray.length);
30394 amit.gupta 220
						final InputStream inputStream = new ByteArrayInputStream(fos.toByteArray());
221
						return new ResponseEntity<>(new InputStreamResource(inputStream), headers, HttpStatus.OK);
30380 amit.gupta 222
					}
223
				}
224
 
30289 amit.gupta 225
			}
226
		} else {
227
			throw new ProfitMandiBusinessException("Invalid Invoice", invoiceNumber, "Please check with your manager");
228
		}
229
		return null;
230
	}
231
 
30395 amit.gupta 232
	private void addFileToZip(ZipOutputStream outZip, InputStream inputStream, String fileName) throws Exception {
233
		byte data[] = new byte[BUFFER_SIZE];
234
		ZipEntry entry = new ZipEntry(fileName);
235
		outZip.putNextEntry(entry);
236
		IOUtils.copy(inputStream, outZip);
237
		outZip.closeEntry();
238
	}
239
 
30289 amit.gupta 240
	private String getInvoicePath(Order order) {
241
		LocalDateTime billTime = order.getBillingTimestamp();
242
		String dirPath = billTime.getYear() + "-" + (billTime.getMonthValue() - 1) + File.separator + order.getRetailerId();
243
		String filename = dirPath + File.separator + order.getInvoiceNumber() + ".pdf";
244
		return filename;
245
	}
21636 ashik.ali 246
}