| 28300 |
tejbeer |
1 |
package com.spice.profitmandi.web.controller;
|
|
|
2 |
|
|
|
3 |
import java.time.LocalDateTime;
|
|
|
4 |
import java.util.ArrayList;
|
|
|
5 |
import java.util.HashMap;
|
|
|
6 |
import java.util.List;
|
|
|
7 |
import java.util.Map;
|
|
|
8 |
import java.util.stream.Collectors;
|
|
|
9 |
|
|
|
10 |
import javax.servlet.http.HttpServletRequest;
|
|
|
11 |
|
|
|
12 |
import org.apache.logging.log4j.LogManager;
|
|
|
13 |
import org.apache.logging.log4j.Logger;
|
|
|
14 |
import org.springframework.beans.factory.annotation.Autowired;
|
|
|
15 |
import org.springframework.stereotype.Controller;
|
|
|
16 |
import org.springframework.transaction.annotation.Transactional;
|
|
|
17 |
import org.springframework.ui.Model;
|
|
|
18 |
import org.springframework.web.bind.annotation.RequestMapping;
|
|
|
19 |
import org.springframework.web.bind.annotation.RequestMethod;
|
|
|
20 |
import org.springframework.web.bind.annotation.RequestParam;
|
|
|
21 |
|
| 28499 |
amit.gupta |
22 |
import com.spice.profitmandi.dao.entity.inventory.State;
|
|
|
23 |
import com.spice.profitmandi.dao.entity.inventory.Warehouse;
|
|
|
24 |
import com.spice.profitmandi.dao.entity.transaction.Seller;
|
|
|
25 |
import com.spice.profitmandi.dao.entity.transaction.SellerWarehouse;
|
|
|
26 |
import com.spice.profitmandi.dao.entity.transaction.WarehouseAddressMapping;
|
|
|
27 |
import com.spice.profitmandi.dao.entity.transaction.WarehouseAddressMaster;
|
|
|
28 |
import com.spice.profitmandi.dao.enumuration.inventory.InventoryType;
|
|
|
29 |
import com.spice.profitmandi.dao.enumuration.inventory.WarehouseType;
|
|
|
30 |
import com.spice.profitmandi.dao.repository.inventory.StateRepository;
|
| 28493 |
tejbeer |
31 |
import com.spice.profitmandi.dao.repository.inventory.WarehouseRepository;
|
| 28300 |
tejbeer |
32 |
import com.spice.profitmandi.dao.repository.transaction.SellerRepository;
|
|
|
33 |
import com.spice.profitmandi.dao.repository.transaction.SellerWarehouseRepository;
|
|
|
34 |
import com.spice.profitmandi.dao.repository.transaction.WareHouseAddressMappingRepository;
|
|
|
35 |
import com.spice.profitmandi.dao.repository.transaction.WareHouseAddressMasterRepository;
|
|
|
36 |
|
| 28499 |
amit.gupta |
37 |
|
| 28300 |
tejbeer |
38 |
@Controller
|
|
|
39 |
@Transactional(rollbackFor = Throwable.class)
|
|
|
40 |
public class SellerController {
|
|
|
41 |
|
| 32075 |
tejbeer |
42 |
@Autowired
|
|
|
43 |
private SellerRepository sellerRepository;
|
| 28499 |
amit.gupta |
44 |
|
| 32075 |
tejbeer |
45 |
@Autowired
|
|
|
46 |
private StateRepository stateRepository;
|
| 28493 |
tejbeer |
47 |
|
| 28300 |
tejbeer |
48 |
|
| 32075 |
tejbeer |
49 |
@Autowired
|
|
|
50 |
WarehouseRepository warehouseRepository;
|
| 28300 |
tejbeer |
51 |
|
| 32075 |
tejbeer |
52 |
@Autowired
|
|
|
53 |
WareHouseAddressMasterRepository wareHouseAddressMasterRepository;
|
| 28300 |
tejbeer |
54 |
|
| 32075 |
tejbeer |
55 |
@Autowired
|
|
|
56 |
private SellerWarehouseRepository sellerWarehouseRepository;
|
| 28300 |
tejbeer |
57 |
|
| 32075 |
tejbeer |
58 |
@Autowired
|
|
|
59 |
private WareHouseAddressMappingRepository wareHouseAddressMappingRepository;
|
| 28300 |
tejbeer |
60 |
|
| 32075 |
tejbeer |
61 |
private static final Logger LOGGER = LogManager.getLogger(SellerController.class);
|
| 28300 |
tejbeer |
62 |
|
| 32075 |
tejbeer |
63 |
@RequestMapping(value = "/createNewWarehouse", method = RequestMethod.POST)
|
|
|
64 |
public String getViewOurSales(HttpServletRequest request, @RequestParam(name = "address", required = true, defaultValue = "0") int address, @RequestParam(name = "prefix", required = true, defaultValue = "0") String prefix, @RequestParam(name = "sellerId", required = true, defaultValue = "0") int sellerId, @RequestParam(name = "warehouseName", required = true, defaultValue = "0") String warehouseName, @RequestParam(name = "pin", required = true, defaultValue = "0") String pinCode, Model model)
|
| 28493 |
tejbeer |
65 |
|
| 32075 |
tejbeer |
66 |
throws Exception {
|
| 28493 |
tejbeer |
67 |
|
| 32075 |
tejbeer |
68 |
Seller seller = sellerRepository.selectById(sellerId);
|
|
|
69 |
WarehouseAddressMaster wam = wareHouseAddressMasterRepository.selectById(address);
|
| 28300 |
tejbeer |
70 |
|
| 32075 |
tejbeer |
71 |
Warehouse warehouse = new Warehouse();
|
|
|
72 |
warehouse.setDisplayName(warehouseName);
|
|
|
73 |
warehouse.setLocation(wam.getAddress());
|
|
|
74 |
warehouse.setGstin(seller.getGstin());
|
|
|
75 |
warehouse.setStateId(seller.getStateId());
|
|
|
76 |
warehouse.setStatus(3);
|
|
|
77 |
warehouse.setAddedOn(LocalDateTime.now());
|
|
|
78 |
warehouse.setLastCheckedOn(LocalDateTime.now());
|
|
|
79 |
warehouse.setTinNumber(null);
|
|
|
80 |
warehouse.setPincode(pinCode);
|
|
|
81 |
warehouse.setLogisticsLocation(0);
|
|
|
82 |
warehouse.setVendor(1);
|
|
|
83 |
warehouse.setBillingType(0);
|
|
|
84 |
warehouse.setInventoryType(InventoryType.GOOD);
|
|
|
85 |
warehouse.setWarehouseType(WarehouseType.OURS);
|
|
|
86 |
warehouse.setIsAvailabilityMonitored(1);
|
|
|
87 |
warehouse.setSource(0);
|
|
|
88 |
warehouseRepository.persist(warehouse);
|
|
|
89 |
warehouse.setBillingWarehouseId(warehouse.getId());
|
|
|
90 |
warehouse.setShippingWarehouseId(warehouse.getId());
|
| 28300 |
tejbeer |
91 |
|
| 32075 |
tejbeer |
92 |
LOGGER.info("warehouseId" + warehouse.getId());
|
| 28300 |
tejbeer |
93 |
|
| 32075 |
tejbeer |
94 |
SellerWarehouse sellerWarehouse = new SellerWarehouse();
|
|
|
95 |
sellerWarehouse.setActive(true);
|
|
|
96 |
sellerWarehouse.setWarehouseId(warehouse.getId());
|
|
|
97 |
sellerWarehouse.setChallanSequence(0);
|
|
|
98 |
sellerWarehouse.setCreateTimestamp(LocalDateTime.now());
|
|
|
99 |
sellerWarehouse.setInvoiceSequence(0);
|
|
|
100 |
sellerWarehouse.setPrefix(prefix);
|
|
|
101 |
sellerWarehouse.setOrderType(0);
|
|
|
102 |
sellerWarehouse.setSellerId(sellerId);
|
|
|
103 |
sellerWarehouseRepository.persist(sellerWarehouse);
|
| 28300 |
tejbeer |
104 |
|
| 32075 |
tejbeer |
105 |
WarehouseAddressMapping warehouseAddressMapping = new WarehouseAddressMapping();
|
|
|
106 |
warehouseAddressMapping.setAddressId(address);
|
|
|
107 |
warehouseAddressMapping.setCreated(LocalDateTime.now());
|
|
|
108 |
warehouseAddressMapping.setUpdated(null);
|
|
|
109 |
warehouseAddressMapping.setWarehouseId(warehouse.getId());
|
|
|
110 |
warehouseAddressMapping.setAddressId(address);
|
|
|
111 |
wareHouseAddressMappingRepository.persist(warehouseAddressMapping);
|
| 28300 |
tejbeer |
112 |
|
|
|
113 |
|
| 32075 |
tejbeer |
114 |
return "seller";
|
| 28300 |
tejbeer |
115 |
|
| 32075 |
tejbeer |
116 |
}
|
| 28300 |
tejbeer |
117 |
|
| 32075 |
tejbeer |
118 |
@RequestMapping(value = "/createNewSeller", method = RequestMethod.POST)
|
|
|
119 |
public String getNewSeller(HttpServletRequest request, @RequestParam(name = "label", required = true, defaultValue = "0") String label, @RequestParam(name = "address", required = true, defaultValue = "0") String address, @RequestParam(name = "gst", required = true, defaultValue = "0") String gst, @RequestParam(name = "state", required = true, defaultValue = "0") int state, Model model) throws Exception {
|
| 28300 |
tejbeer |
120 |
|
| 32075 |
tejbeer |
121 |
Seller seller = new Seller();
|
| 28300 |
tejbeer |
122 |
|
| 32075 |
tejbeer |
123 |
seller.setAddress(address);
|
|
|
124 |
seller.setLabel(label);
|
|
|
125 |
seller.setGstin(gst);
|
|
|
126 |
seller.setStateId(state);
|
|
|
127 |
seller.setOrganisationId(7);
|
|
|
128 |
sellerRepository.persist(seller);
|
| 28300 |
tejbeer |
129 |
|
| 32075 |
tejbeer |
130 |
return "seller";
|
| 28300 |
tejbeer |
131 |
|
| 32075 |
tejbeer |
132 |
}
|
| 28300 |
tejbeer |
133 |
|
| 32075 |
tejbeer |
134 |
@RequestMapping(value = "/createNewAddress", method = RequestMethod.POST)
|
|
|
135 |
public String getNewSeller(HttpServletRequest request, @RequestParam(name = "newAddress", required = true, defaultValue = "0") String address, @RequestParam(name = "pin", required = true, defaultValue = "0") String pin, @RequestParam(name = "stateId", required = true, defaultValue = "0") int stateId, Model model) throws Exception {
|
| 28300 |
tejbeer |
136 |
|
| 32075 |
tejbeer |
137 |
WarehouseAddressMaster wham = new WarehouseAddressMaster();
|
|
|
138 |
wham.setAddress(address);
|
|
|
139 |
wham.setPin(pin);
|
|
|
140 |
wham.setStateId(stateId);
|
|
|
141 |
wham.setContacNumber("18002700273");
|
|
|
142 |
wham.setContactPerson("Customer Care");
|
|
|
143 |
wham.setCreated(LocalDateTime.now());
|
|
|
144 |
wareHouseAddressMasterRepository.persist(wham);
|
| 28300 |
tejbeer |
145 |
|
| 32075 |
tejbeer |
146 |
return "seller";
|
| 28300 |
tejbeer |
147 |
|
| 32075 |
tejbeer |
148 |
}
|
| 28300 |
tejbeer |
149 |
|
| 32075 |
tejbeer |
150 |
@RequestMapping(value = "/getAllSeller", method = RequestMethod.GET)
|
|
|
151 |
public String getAllSeller(HttpServletRequest request, Model model) throws Exception {
|
| 28300 |
tejbeer |
152 |
|
| 32075 |
tejbeer |
153 |
List<Seller> sellers = sellerRepository.selectAll().stream().filter(x -> x.getOrganisationId() == 7).collect(Collectors.toList());
|
| 28300 |
tejbeer |
154 |
|
| 32075 |
tejbeer |
155 |
List<WarehouseAddressMaster> warehouseAddressMaster = sellerRepository.selectAllWarehouseAddressMaster();
|
| 28300 |
tejbeer |
156 |
|
| 32075 |
tejbeer |
157 |
List<State> state = stateRepository.selectAll();
|
|
|
158 |
LOGGER.info("statemaster" + state);
|
|
|
159 |
model.addAttribute("state", state);
|
| 28300 |
tejbeer |
160 |
|
| 32075 |
tejbeer |
161 |
LOGGER.info("sellerLabel" + sellers);
|
|
|
162 |
LOGGER.info("warehouseAddressMaster" + warehouseAddressMaster);
|
|
|
163 |
model.addAttribute("sellerLabel", sellers);
|
|
|
164 |
model.addAttribute("warehouseAddressMaster", warehouseAddressMaster);
|
| 28300 |
tejbeer |
165 |
|
| 32075 |
tejbeer |
166 |
return "seller";
|
|
|
167 |
}
|
| 28300 |
tejbeer |
168 |
|
| 32075 |
tejbeer |
169 |
@RequestMapping(value = "/getSellerWareHouse", method = RequestMethod.GET)
|
|
|
170 |
public String getSellerWareHouse(HttpServletRequest request, @RequestParam(name = "sellerId", required = true, defaultValue = "0") int sellerId, Model model) throws Exception {
|
| 28300 |
tejbeer |
171 |
|
| 32075 |
tejbeer |
172 |
List<SellerWarehouse> sellerWarehouse = sellerWarehouseRepository.selectBySellerId(sellerId);
|
| 28300 |
tejbeer |
173 |
|
| 32075 |
tejbeer |
174 |
List<WarehouseAddressMaster> allWarehouseAddressMaster = sellerRepository.selectAllWarehouseAddressMaster();
|
| 28300 |
tejbeer |
175 |
|
| 32075 |
tejbeer |
176 |
Seller seller = sellerRepository.selectById(sellerId);
|
| 28300 |
tejbeer |
177 |
|
|
|
178 |
|
| 32075 |
tejbeer |
179 |
List<Integer> sellerwarehouseIds = sellerWarehouse.stream().map(x -> x.getWarehouseId()).collect(Collectors.toList());
|
| 28300 |
tejbeer |
180 |
|
| 32075 |
tejbeer |
181 |
Map<Integer, WarehouseAddressMaster> wam = null;
|
|
|
182 |
if (sellerwarehouseIds.size() > 0) {
|
|
|
183 |
List<WarehouseAddressMapping> warehouseAddressMapping = wareHouseAddressMappingRepository.selectAllByIds(sellerwarehouseIds);
|
|
|
184 |
wam = mapWarhouseIdAndAddress(warehouseAddressMapping);
|
|
|
185 |
} else {
|
|
|
186 |
wam = new HashMap<>();
|
|
|
187 |
}
|
| 28300 |
tejbeer |
188 |
|
| 32075 |
tejbeer |
189 |
model.addAttribute("allWhm", allWarehouseAddressMaster);
|
|
|
190 |
|
|
|
191 |
model.addAttribute("wam", wam);
|
|
|
192 |
model.addAttribute("seller", seller);
|
|
|
193 |
model.addAttribute("sellerId", sellerId);
|
|
|
194 |
model.addAttribute("sellerWarehouse", sellerWarehouse);
|
|
|
195 |
return "seller-warehouse-container";
|
|
|
196 |
}
|
|
|
197 |
|
|
|
198 |
private Map<Integer, WarehouseAddressMaster> mapWarhouseIdAndAddress(
|
|
|
199 |
List<WarehouseAddressMapping> warehouseAddressMapping) {
|
|
|
200 |
Map<Integer, WarehouseAddressMaster> wam = new HashMap<>();
|
|
|
201 |
for (WarehouseAddressMapping wa : warehouseAddressMapping) {
|
|
|
202 |
WarehouseAddressMaster wm = wareHouseAddressMasterRepository.selectById(wa.getAddressId());
|
|
|
203 |
wam.put(wa.getWarehouseId(), wm);
|
|
|
204 |
}
|
|
|
205 |
|
|
|
206 |
return wam;
|
|
|
207 |
}
|
|
|
208 |
|
| 28300 |
tejbeer |
209 |
}
|