Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
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
}