Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
21292 ashik.ali 1 
package com.spice.profitmandi.web.controller;
2 
 
22495 amit.gupta 3 
import java.util.Date;
21448 ashik.ali 4 
import java.util.Set;
5 
 
21292 ashik.ali 6 
import javax.servlet.http.HttpServletRequest;
7 
 
8 
import org.slf4j.Logger;
9 
import org.slf4j.LoggerFactory;
10 
import org.springframework.beans.factory.annotation.Autowired;
22355 ashik.ali 11 
import org.springframework.beans.factory.annotation.Qualifier;
21292 ashik.ali 12 
import org.springframework.http.ResponseEntity;
13 
import org.springframework.stereotype.Controller;
21692 amit.gupta 14 
import org.springframework.transaction.annotation.Transactional;
21309 ashik.ali 15 
import org.springframework.web.bind.annotation.RequestBody;
21292 ashik.ali 16 
import org.springframework.web.bind.annotation.RequestMapping;
17 
import org.springframework.web.bind.annotation.RequestMethod;
18 
import org.springframework.web.bind.annotation.RequestParam;
19 
 
20 
import com.spice.profitmandi.common.ResponseCodeHolder;
21 
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
22 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
21463 ashik.ali 23 
import com.spice.profitmandi.common.model.UserInfo;
22473 ashik.ali 24 
import com.spice.profitmandi.common.util.StringUtils;
25 
import com.spice.profitmandi.common.util.Utils;
21740 ashik.ali 26 
import com.spice.profitmandi.common.web.util.ResponseSender;
21735 ashik.ali 27 
import com.spice.profitmandi.dao.entity.dtr.Brand;
22473 ashik.ali 28 
import com.spice.profitmandi.dao.entity.dtr.DistrictMaster;
21735 ashik.ali 29 
import com.spice.profitmandi.dao.entity.dtr.Document;
30 
import com.spice.profitmandi.dao.entity.dtr.Retailer;
31 
import com.spice.profitmandi.dao.entity.dtr.RetailerBrand;
32 
import com.spice.profitmandi.dao.entity.dtr.RetailerRegisteredAddress;
33 
import com.spice.profitmandi.dao.entity.dtr.Shop;
34 
import com.spice.profitmandi.dao.entity.dtr.ShopAddress;
35 
import com.spice.profitmandi.dao.entity.dtr.User;
21768 amit.gupta 36 
import com.spice.profitmandi.dao.entity.dtr.UserAccounts;
37 
import com.spice.profitmandi.dao.entity.dtr.UserRole;
22656 ashik.ali 38 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
39 
import com.spice.profitmandi.dao.entity.fofo.FofoStoreSequenceGeneration;
21735 ashik.ali 40 
import com.spice.profitmandi.dao.entity.user.Address;
22355 ashik.ali 41 
import com.spice.profitmandi.dao.entity.user.Cart;
42 
import com.spice.profitmandi.dao.entity.user.Counter;
43 
import com.spice.profitmandi.dao.entity.user.PrivateDealUser;
44 
import com.spice.profitmandi.dao.entity.user.PrivateDealUserAddressId;
45 
import com.spice.profitmandi.dao.entity.user.PrivateDealUserAddressMapping;
21768 amit.gupta 46 
import com.spice.profitmandi.dao.enumuration.dtr.AccountType;
47 
import com.spice.profitmandi.dao.enumuration.dtr.RoleType;
22495 amit.gupta 48 
import com.spice.profitmandi.dao.model.RetailerFofoInterest;
21735 ashik.ali 49 
import com.spice.profitmandi.dao.repository.dtr.BrandRepository;
22473 ashik.ali 50 
import com.spice.profitmandi.dao.repository.dtr.DistrictMasterRepository;
21735 ashik.ali 51 
import com.spice.profitmandi.dao.repository.dtr.DocumentRepository;
22473 ashik.ali 52 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
53 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreSequenceGenerationRepository;
22495 amit.gupta 54 
import com.spice.profitmandi.dao.repository.dtr.Mongo;
21735 ashik.ali 55 
import com.spice.profitmandi.dao.repository.dtr.RetailerAddressRepository;
56 
import com.spice.profitmandi.dao.repository.dtr.RetailerBrandRepository;
57 
import com.spice.profitmandi.dao.repository.dtr.RetailerRegisteredAddressRepository;
58 
import com.spice.profitmandi.dao.repository.dtr.RetailerRepository;
59 
import com.spice.profitmandi.dao.repository.dtr.ShopAddressRepository;
60 
import com.spice.profitmandi.dao.repository.dtr.ShopRepository;
21768 amit.gupta 61 
import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
21735 ashik.ali 62 
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
21768 amit.gupta 63 
import com.spice.profitmandi.dao.repository.dtr.UserRoleRepository;
21735 ashik.ali 64 
import com.spice.profitmandi.dao.repository.user.AddressRepository;
22355 ashik.ali 65 
import com.spice.profitmandi.dao.repository.user.CartRepository;
66 
import com.spice.profitmandi.dao.repository.user.CounterRepository;
67 
import com.spice.profitmandi.dao.repository.user.PrivateDealUserAddressMappingRepository;
68 
import com.spice.profitmandi.dao.repository.user.PrivateDealUserRepository;
21431 ashik.ali 69 
import com.spice.profitmandi.web.req.Category;
21426 ashik.ali 70 
import com.spice.profitmandi.web.req.CreateRetailerAddressRequest;
71 
import com.spice.profitmandi.web.req.CreateRetailerRequest;
72 
import com.spice.profitmandi.web.req.RetailerAddBrandRequest;
21292 ashik.ali 73 
 
22473 ashik.ali 74 
import in.shop2020.model.v1.inventory.StateInfo;
22355 ashik.ali 75 
import in.shop2020.model.v1.user.CartStatus;
21302 ashik.ali 76 
import io.swagger.annotations.ApiImplicitParam;
77 
import io.swagger.annotations.ApiImplicitParams;
78 
import io.swagger.annotations.ApiOperation;
79 
 
21292 ashik.ali 80 
@Controller
22037 amit.gupta 81 
@Transactional(rollbackFor=Throwable.class)
21292 ashik.ali 82 
public class RetailerController {
83 
 
84 
	private static final Logger LOGGER=LoggerFactory.getLogger(RetailerController.class);
85 
 
86 
	@Autowired
22355 ashik.ali 87 
	@Qualifier("userRepository")
22931 ashik.ali 88 
	private UserRepository userRepository;
21463 ashik.ali 89 
 
90 
	@Autowired
22355 ashik.ali 91 
	@Qualifier("userUserRepository")
22931 ashik.ali 92 
	private com.spice.profitmandi.dao.repository.user.UserRepository userUserRepository;
22355 ashik.ali 93 
 
94 
	@Autowired
22931 ashik.ali 95 
	private UserRoleRepository userRoleRepository;
21768 amit.gupta 96 
 
97 
	@Autowired
22931 ashik.ali 98 
	private ResponseSender<?> responseSender;
21440 ashik.ali 99 
 
100 
	@Autowired
22931 ashik.ali 101 
	private RetailerRepository retailerRepository;
21292 ashik.ali 102 
 
21390 ashik.ali 103 
	@Autowired
22931 ashik.ali 104 
	private BrandRepository brandRepository;
21390 ashik.ali 105 
 
106 
	@Autowired
22931 ashik.ali 107 
	private AddressRepository addressRepository;
21390 ashik.ali 108 
 
109 
	@Autowired
22931 ashik.ali 110 
	private DocumentRepository documentRepository;
21390 ashik.ali 111 
 
112 
	@Autowired
22931 ashik.ali 113 
	private ShopRepository shopRepository;
21390 ashik.ali 114 
 
115 
	@Autowired
22931 ashik.ali 116 
	private UserAccountRepository userAccountRepository;
21768 amit.gupta 117 
 
118 
	@Autowired
22931 ashik.ali 119 
	private RetailerRegisteredAddressRepository retailerRegisteredAddressRepository;
21390 ashik.ali 120 
 
121 
	@Autowired
22931 ashik.ali 122 
	private RetailerAddressRepository retailerAddressRepository;
21426 ashik.ali 123 
 
124 
	@Autowired
22931 ashik.ali 125 
	private ShopAddressRepository shopAddressRepository;
21390 ashik.ali 126 
 
127 
	@Autowired
22931 ashik.ali 128 
	private RetailerBrandRepository retailerBrandRepository;
21390 ashik.ali 129 
 
22355 ashik.ali 130 
	@Autowired
22931 ashik.ali 131 
	private CounterRepository counterRepository;
22355 ashik.ali 132 
 
133 
	@Autowired
22931 ashik.ali 134 
	private PrivateDealUserRepository privateDealUserRepository;
22355 ashik.ali 135 
 
136 
	@Autowired
22931 ashik.ali 137 
	private PrivateDealUserAddressMappingRepository privateDealUserAddressMappingRepository;
22355 ashik.ali 138 
 
139 
	@Autowired
22931 ashik.ali 140 
	private CartRepository cartRepository;
22355 ashik.ali 141 
 
22473 ashik.ali 142 
	@Autowired
22931 ashik.ali 143 
	private DistrictMasterRepository districtMasterRepository;
22473 ashik.ali 144 
 
145 
	@Autowired
22931 ashik.ali 146 
	private FofoStoreRepository fofoStoreRepository;
22473 ashik.ali 147 
 
148 
	@Autowired
22495 amit.gupta 149 
	private Mongo mongoClient;
150 
 
151 
	@Autowired
22931 ashik.ali 152 
	private FofoStoreSequenceGenerationRepository fofoStoreSequenceGenerationRepository;
22473 ashik.ali 153 
 
21302 ashik.ali 154 
	@ApiImplicitParams({
155 
		@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token",
156 
				required = true, dataType = "string", paramType = "header")
157 
	})
21309 ashik.ali 158 
 
21302 ashik.ali 159 
	@ApiOperation(value = "Create Retailer")
160 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER, method=RequestMethod.POST)
22931 ashik.ali 161 
	public ResponseEntity<?> createRetailer(HttpServletRequest request, @RequestBody CreateRetailerRequest createRetailerRequest) throws ProfitMandiBusinessException{
22355 ashik.ali 162 
		LOGGER.info("request received with body [{}] at url {{}}: ", createRetailerRequest, request.getRequestURL().toString());
22931 ashik.ali 163 
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
164 
		LOGGER.info("requestAttribute [userInfo={}]", userInfo);
165 
		User user = userRepository.selectById(userInfo.getUserId());
166 
		this.createRetailer(user, createRetailerRequest);
167 
		return responseSender.ok(ResponseCodeHolder.getMessage("RTLR_OK_1000"));
168 
 
21440 ashik.ali 169 
	}
170 
 
21768 amit.gupta 171 
	private void createRetailer(User user, CreateRetailerRequest createRetailerRequest)
22931 ashik.ali 172 
			throws ProfitMandiBusinessException{
21390 ashik.ali 173 
		Retailer retailer = new Retailer();
21426 ashik.ali 174 
		retailer.setName(createRetailerRequest.getName());
175 
		retailer.setNumber(createRetailerRequest.getNumber());
176 
		retailer.setType(createRetailerRequest.getType());
177 
		retailer.setMonthlySaleValue(createRetailerRequest.getMonthlySaleValue());
22732 ashik.ali 178 
		retailer.setMonthlySaleVolume(createRetailerRequest.getMonthlySaleVolume());
23035 ashik.ali 179 
		retailer.setPrimaryBuyingMode(createRetailerRequest.getPrimaryBuyingMode());
21426 ashik.ali 180 
		retailer.setRecharge(createRetailerRequest.getLineOfBusiness().isRecharge());
181 
		retailer.setMobile(createRetailerRequest.getLineOfBusiness().isMobile());
182 
		retailer.setAccessories(createRetailerRequest.getLineOfBusiness().isAccessories());
21431 ashik.ali 183 
		retailer.setOther1(createRetailerRequest.getLineOfBusiness().getOther1());
184 
		retailer.setOther2(createRetailerRequest.getLineOfBusiness().getOther2());
22964 ashik.ali 185 
		if(createRetailerRequest.getDocumentId() == 0){
186 
			retailer.setDocumentId(null);
187 
		}else{
188 
			Document retailerDocument = documentRepository.selectById(createRetailerRequest.getDocumentId());
189 
			if(retailerRepository.isExistByDocumentId(retailerDocument.getId())){
190 
				LOGGER.error("documet is already mapped with another retailer");
191 
				throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, retailerDocument.getId(), "DCMNT_1000");
192 
			}
193 
			retailer.setDocumentId(retailerDocument.getId());
194 
			documentRepository.markDocumentAsPersisted(retailerDocument.getId());
21440 ashik.ali 195 
		}
22964 ashik.ali 196 
		Shop shop = new Shop();
197 
		shop.setName(createRetailerRequest.getShop().getName());
198 
 
199 
		if(createRetailerRequest.getShop().getDocumentId() == 0){
200 
			shop.setDocumentId(null);
201 
		}else{
202 
			final Document shopDocument = documentRepository.selectById(createRetailerRequest.getShop().getDocumentId());
203 
			if(shopRepository.isExistByDocumentId(shopDocument.getId())){
204 
				throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, shopDocument.getId(), "DCMNT_1000");
205 
			}
206 
			shop.setDocumentId(shopDocument.getId());
207 
			documentRepository.markDocumentAsPersisted(shopDocument.getId());
21440 ashik.ali 208 
		}
22355 ashik.ali 209 
 
210 
		com.spice.profitmandi.dao.entity.user.User saholicUser = null;
211 
		boolean foundRetailer = false;
22954 amit.gupta 212 
		try {
213 
			saholicUser = userUserRepository.selectByEmailId(user.getEmailId());
214 
		}catch (ProfitMandiBusinessException e) {
215 
			LOGGER.info("User doesnt exist in old system");
216 
		}
22355 ashik.ali 217 
		if(saholicUser == null){
218 
			Cart cart = new Cart();
219 
			cart.setCartStatus(CartStatus.ACTIVE);
220 
			cartRepository.persist(cart);
221 
			saholicUser = new com.spice.profitmandi.dao.entity.user.User();
222 
			saholicUser.setEmailId(user.getEmailId());
223 
			saholicUser.setName(createRetailerRequest.getName());
224 
			saholicUser.setActiveCartId(cart.getId());
225 
			userUserRepository.persist(saholicUser);
226 
		}else{
227 
			foundRetailer = true;
228 
		}
23039 ashik.ali 229 
		try{
230 
			retailerRepository.selectById(saholicUser.getId());
231 
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
232 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.EMAIL_ID, saholicUser.getEmailId(), "RTLR_1011");
233 
		}
22355 ashik.ali 234 
		//in.shop2020.model.v1.user.User saholicUser = Utils.createSaholicUser(user.getEmailId());
235 
		retailer.setId(saholicUser.getId());
21440 ashik.ali 236 
		retailerRepository.persist(retailer);
22355 ashik.ali 237 
 
22965 ashik.ali 238 
		shop.setRetailerId(retailer.getId());
23038 ashik.ali 239 
		LOGGER.info("Shop is persisting ... [{}]",shop);
22965 ashik.ali 240 
		shopRepository.persist(shop);
22964 ashik.ali 241 
 
21448 ashik.ali 242 
		this.addBrandWithRetailer(retailer.getId(), createRetailerRequest.getCategories());
21440 ashik.ali 243 
		final Address addressRetailer = this.createAddress(createRetailerRequest.getAddress());
21706 amit.gupta 244 
		addressRetailer.setRetaierId(retailer.getId());
22041 amit.gupta 245 
		addressRepository.persist(addressRetailer);
22355 ashik.ali 246 
 
21440 ashik.ali 247 
		final RetailerRegisteredAddress retailerRegisteredAddress = new RetailerRegisteredAddress();
248 
		retailerRegisteredAddress.setRetailerId(retailer.getId());
249 
		retailerRegisteredAddress.setAddressId(addressRetailer.getId());
250 
		retailerRegisteredAddressRepository.persist(retailerRegisteredAddress);
21463 ashik.ali 251 
		if(!createRetailerRequest.isShopAddressSameAsRetailerAddress() && createRetailerRequest.getAddress() == null){
252 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ADDRESS, "", "");
21440 ashik.ali 253 
		}
21463 ashik.ali 254 
		if(createRetailerRequest.isShopAddressSameAsRetailerAddress()){
255 
			ShopAddress shopAddress = new ShopAddress();
256 
			shopAddress.setShopId(shop.getId());
257 
			shopAddress.setAddressId(addressRetailer.getId());
258 
			shopAddressRepository.persist(shopAddress);
259 
		}else{
260 
			final Address addressShop = this.createAddress(createRetailerRequest.getShop().getAddress());
22855 amit.gupta 261 
			addressShop.setRetaierId(retailer.getId());
22041 amit.gupta 262 
			addressRepository.persist(addressShop);
21463 ashik.ali 263 
			ShopAddress shopAddress = new ShopAddress();
264 
			shopAddress.setShopId(shop.getId());
265 
			shopAddress.setAddressId(addressShop.getId());
266 
			shopAddressRepository.persist(shopAddress);
267 
		}
21768 amit.gupta 268 
		UserAccounts ua = new UserAccounts();
22355 ashik.ali 269 
		ua.setAccount_key(String.valueOf(saholicUser.getId()));
21768 amit.gupta 270 
		ua.setUser_id(user.getId());
21769 amit.gupta 271 
		ua.setAccount_type(AccountType.saholic);
21768 amit.gupta 272 
		userAccountRepository.persist(ua);
273 
 
274 
		UserAccounts ua2 = new UserAccounts();
275 
		ua2.setAccount_key(String.valueOf(saholicUser.getActiveCartId()));
276 
		ua2.setUser_id(user.getId());
277 
		ua2.setAccount_type(AccountType.cartId);
278 
		userAccountRepository.persist(ua2);
279 
 
280 
		UserRole ur = new UserRole();
22011 ashik.ali 281 
		ur.setRoleType(RoleType.RETAILER);
21768 amit.gupta 282 
		ur.setUserId(user.getId());
283 
		userRoleRepository.persist(ur);
22355 ashik.ali 284 
 
285 
		if(foundRetailer){
286 
			LOGGER.info("\n\n\n****retailer found\n\n\n");
22604 ashik.ali 287 
			PrivateDealUser privateDealUser = null;
288 
			try{
289 
				privateDealUser = privateDealUserRepository.selectById(saholicUser.getId());
290 
			}catch(ProfitMandiBusinessException profitMandiBusinessException){
291 
				LOGGER.error("PrivateDealUser not found : ", profitMandiBusinessException);
292 
			}
22503 amit.gupta 293 
			if(privateDealUser == null) {
294 
				privateDealUser = new PrivateDealUser();
295 
				privateDealUser.setActive(true);
296 
				privateDealUser.setBulkShipmentAmountLimit(50000);
297 
				privateDealUser.setId(saholicUser.getId());
298 
				privateDealUserRepository.persist(privateDealUser);
299 
				PrivateDealUserAddressMapping privateDealUserAddressMapping = new PrivateDealUserAddressMapping();
300 
				PrivateDealUserAddressId privateDealUserAddressId = new PrivateDealUserAddressId();
301 
				privateDealUserAddressId.setUserId(retailer.getId());
302 
				privateDealUserAddressId.setAddressId(addressRetailer.getId());
303 
				privateDealUserAddressMapping.setId(privateDealUserAddressId);
304 
				privateDealUserAddressMappingRepository.persist(privateDealUserAddressMapping);
305 
			}
22355 ashik.ali 306 
			if(privateDealUser.getCounterId() == null){
307 
				Integer counterId = this.createCounter(user.getEmailId(), createRetailerRequest.getGstNumber(), user.getMobileNumber(), retailer.getName(), addressRetailer.getId());
308 
				privateDealUser.setCounterId(counterId);
309 
				privateDealUserRepository.persist(privateDealUser);
310 
			}
311 
		}else{
312 
			LOGGER.info("retailer not found");
313 
			//gst number intergration with counter
314 
			Integer counterId = this.createCounter(user.getEmailId(), createRetailerRequest.getGstNumber(), user.getMobileNumber(), retailer.getName(), addressRetailer.getId());
315 
 
316 
 
22604 ashik.ali 317 
			PrivateDealUser privateDealUser = null;
318 
			try{
319 
				privateDealUser = privateDealUserRepository.selectById(saholicUser.getId());
320 
			}catch(ProfitMandiBusinessException profitMandiBusinessException){
22875 amit.gupta 321 
				LOGGER.warn("PrivateDealUser not found");
22604 ashik.ali 322 
			}
323 
 
22355 ashik.ali 324 
			if(privateDealUser != null){
325 
				//LOGGER.info("PrivateDealUser found with id [{}]", saholicUser.getId());
326 
				privateDealUser.setCounterId(counterId);
327 
				privateDealUserRepository.update(privateDealUser);
328 
			}else{
22875 amit.gupta 329 
				LOGGER.info("PrivateDealUser not found with id [{}], creating it", saholicUser.getId());
22355 ashik.ali 330 
				privateDealUser = new PrivateDealUser();
331 
				privateDealUser.setActive(true);
332 
				privateDealUser.setBulkShipmentAmountLimit(50000);
333 
				privateDealUser.setId(saholicUser.getId());
334 
				privateDealUser.setCounterId(counterId);
335 
				privateDealUserRepository.persist(privateDealUser);
336 
			}
337 
			PrivateDealUserAddressMapping privateDealUserAddressMapping = new PrivateDealUserAddressMapping();
338 
			PrivateDealUserAddressId privateDealUserAddressId = new PrivateDealUserAddressId();
339 
			privateDealUserAddressId.setUserId(retailer.getId());
340 
			privateDealUserAddressId.setAddressId(addressRetailer.getId());
341 
			privateDealUserAddressMapping.setId(privateDealUserAddressId);
342 
			privateDealUserAddressMappingRepository.persist(privateDealUserAddressMapping);
343 
 
344 
			saholicUser.setAddressId(addressRetailer.getId());
345 
			userUserRepository.persist(saholicUser);
346 
		}
21292 ashik.ali 347 
	}
348 
 
22355 ashik.ali 349 
	private Integer createCounter(String emailId, String gstNumber, String mobileNumber, String name, int addressId){
350 
		if(gstNumber != null && !gstNumber.isEmpty()){
351 
			Counter counter = new Counter();
352 
			counter.setEmailId(emailId);
353 
			counter.setGstin(gstNumber);
354 
			counter.setMobileNumber(mobileNumber);
355 
			counter.setName(name);
356 
			counter.setAddressId(addressId);
357 
			counterRepository.persist(counter);
358 
			return counter.getId();
359 
		}else{
360 
			return null;
361 
		}
21463 ashik.ali 362 
	}
22355 ashik.ali 363 
 
364 
 
21448 ashik.ali 365 
	private void addBrandWithRetailer(int retailerId, Set<Category> categories)
366 
		throws ProfitMandiBusinessException{
367 
		for(Category category : categories){
368 
			for(com.spice.profitmandi.web.req.Brand brandModel : category.getBrands()){
369 
				Brand brand = brandRepository.selectByIdAndName(brandModel.getId(), brandModel.getName());
370 
				final RetailerBrand retailerBrand = new RetailerBrand();
371 
				retailerBrand.setRetailerId(retailerId);
372 
				retailerBrand.setBrandId(brand.getId());
373 
				retailerBrandRepository.persist(retailerBrand);
374 
			}
375 
		}
376 
	}
22524 ashik.ali 377 
 
378 
	@ApiOperation(value = "Create Fofo Store")
379 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_FOFO_FOFO_STORE, method=RequestMethod.POST)
380 
	public ResponseEntity<?> createFofoStore(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.DISTRICT_NAME) String districtName) throws ProfitMandiBusinessException, Exception{
22931 ashik.ali 381 
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
382 
		LOGGER.info("requestAttribute [userInfo={}]", userInfo);
383 
		User user = userRepository.selectById(userInfo.getUserId());
384 
		// = userAccountRepository.selectRetailerIdByUserId(user.getId());
385 
		UserAccounts userAccounts = userAccountRepository.selectSaholicByUserId(user.getId());
386 
		Retailer retailer = retailerRepository.selectById(Integer.parseInt(userAccounts.getAccount_key()));
22524 ashik.ali 387 
		try{
22931 ashik.ali 388 
			userRoleRepository.selectByUserIdAndRoleType(user.getId(), RoleType.FOFO);
389 
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
390 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.USER_ID, user.getId(), "USR_1013");
391 
		}
392 
 
393 
		boolean foundFofoStore = false;
394 
		try{
395 
			fofoStoreRepository.selectByRetailerId(retailer.getId());
396 
			foundFofoStore = true;
397 
		}catch (ProfitMandiBusinessException profitMandiBusinessException) {
22604 ashik.ali 398 
 
22524 ashik.ali 399 
		}
22931 ashik.ali 400 
 
401 
		if(foundFofoStore){
402 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.RETAILER_ID, retailer.getId(), "USR_1014");
403 
		}
404 
 
405 
		int retailerAddressId = retailerRegisteredAddressRepository.selectAddressIdByRetailerId(retailer.getId());
406 
		Address retailerAddress = addressRepository.selectById(retailerAddressId);
407 
 
408 
		StateInfo stateInfo = Utils.getStateInfo(retailerAddress.getState());
409 
		DistrictMaster districtMaster = districtMasterRepository.selectByNameAndStateShortName(districtName, stateInfo.getShortName());
410 
		FofoStoreSequenceGeneration fofoStoreSequenceGeneration = null;
411 
		boolean foundFofoStoreSequence = false;
412 
		try{
413 
			fofoStoreSequenceGeneration = fofoStoreSequenceGenerationRepository.selectByStateShortName(stateInfo.getShortName());
414 
			foundFofoStoreSequence = true;
415 
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
416 
			fofoStoreSequenceGeneration = new FofoStoreSequenceGeneration();
417 
			fofoStoreSequenceGeneration.setSequence(1);
418 
			fofoStoreSequenceGeneration.setStateShortName(stateInfo.getShortName());
419 
			fofoStoreSequenceGenerationRepository.persist(fofoStoreSequenceGeneration);
420 
		}
421 
 
422 
		FofoStore fofoStore = new FofoStore();
423 
		fofoStore.setId(retailer.getId());
424 
		String fofoStoreCode = StringUtils.generateFofoStoreSequence(districtMaster.getStateShortName() + districtMaster.getShortName(), fofoStoreSequenceGeneration.getSequence());
425 
		if(foundFofoStoreSequence){
426 
			fofoStoreSequenceGeneration.setSequence(fofoStoreSequenceGeneration.getSequence() + 1);
427 
			fofoStoreSequenceGenerationRepository.persist(fofoStoreSequenceGeneration);
428 
		}
429 
		fofoStore.setCode(fofoStoreCode);
430 
		fofoStoreRepository.persist(fofoStore);
431 
 
432 
		return responseSender.ok(ResponseCodeHolder.getMessage("RTLR_OK_1003"));
433 
 
22524 ashik.ali 434 
	}
435 
 
21292 ashik.ali 436 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ALL,method=RequestMethod.GET)
21496 ashik.ali 437 
	public ResponseEntity<?> getAll(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.PAGE_NUMBER) int pageNumber, @RequestParam(name = ProfitMandiConstants.PAGE_SIZE) int pageSize){
21292 ashik.ali 438 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
21496 ashik.ali 439 
		return responseSender.ok(retailerRepository.selectAll(pageNumber, pageSize));
21292 ashik.ali 440 
	}
441 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ID, method=RequestMethod.GET)
22931 ashik.ali 442 
	public ResponseEntity<?> getById(HttpServletRequest request, @RequestParam(name = "id") int id) throws ProfitMandiBusinessException{
21292 ashik.ali 443 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 444 
		return responseSender.ok(retailerRepository.selectById(id));
21292 ashik.ali 445 
	}
446 
 
447 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_NAME, method=RequestMethod.GET)
22931 ashik.ali 448 
	public ResponseEntity<?> getByName(HttpServletRequest request, @RequestParam(name = "name") String name) throws ProfitMandiBusinessException{
21292 ashik.ali 449 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 450 
		return responseSender.ok(retailerRepository.selectByName(name));
21292 ashik.ali 451 
	}
452 
 
453 
 
454 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ID,method=RequestMethod.DELETE)
22931 ashik.ali 455 
	public ResponseEntity<?> removeById(HttpServletRequest request, @RequestParam(name = "id") int id) throws ProfitMandiBusinessException{
21292 ashik.ali 456 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 457 
		retailerRepository.deleteById(id);
458 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21292 ashik.ali 459 
	}
460 
 
21426 ashik.ali 461 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_ADD, method=RequestMethod.POST)
22931 ashik.ali 462 
	public ResponseEntity<?> addShop(HttpServletRequest request, @RequestBody com.spice.profitmandi.web.req.Shop createShop, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 463 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 464 
		Document document = documentRepository.selectById(createShop.getDocumentId());
465 
		if(shopRepository.isExistByDocumentId(createShop.getDocumentId())){
466 
			LOGGER.error("documet is already mapped with another shop");
467 
			throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, document.getId(), "");
21426 ashik.ali 468 
		}
22931 ashik.ali 469 
		retailerRepository.selectById(retailerId);
470 
		Shop shop = new Shop();
471 
		shop.setRetailerId(retailerId);
472 
		Address address = this.createAddress(createShop.getAddress());
473 
		addressRepository.persist(address);
474 
		shop.setAddressId(address.getId());
475 
		shop.setDocumentId(document.getId());
476 
		shopRepository.persist(shop);
477 
		ShopAddress shopAddress = new ShopAddress();
478 
		shopAddress.setAddressId(address.getId());
479 
		shopAddress.setShopId(shop.getId());
480 
		shopAddressRepository.persist(shopAddress);
481 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
482 
 
21426 ashik.ali 483 
	}
484 
 
485 
 
21302 ashik.ali 486 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 487 
	public ResponseEntity<?> removeShop(HttpServletRequest request, @RequestParam(name = "shopId") int shopId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21292 ashik.ali 488 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 489 
		retailerRepository.removeShop(shopId, retailerId);
490 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21292 ashik.ali 491 
	}
492 
 
21426 ashik.ali 493 
	private Address createAddress(com.spice.profitmandi.web.req.Address createAddress){
494 
		Address address = new Address();
495 
		address.setName(createAddress.getName());
496 
		address.setLine1(createAddress.getLine1());
497 
		address.setLine2(createAddress.getLine2());
498 
		address.setLandmark(createAddress.getLandmark());
499 
		address.setCity(createAddress.getCity());
500 
		address.setState(createAddress.getState());
501 
		address.setPinCode(createAddress.getPinCode());
502 
		address.setCountry(createAddress.getCountry());
503 
		address.setPhoneNumber(createAddress.getPhoneNumber());
21706 amit.gupta 504 
 
21426 ashik.ali 505 
		return address;
506 
	}
21440 ashik.ali 507 
 
21426 ashik.ali 508 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_ADD, method=RequestMethod.POST)
22931 ashik.ali 509 
	public ResponseEntity<?> addAddress(HttpServletRequest request, @RequestBody CreateRetailerAddressRequest createRetailerAddress) throws ProfitMandiBusinessException{
21426 ashik.ali 510 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 511 
		retailerRepository.addAddress(this.createAddress(createRetailerAddress.getAddress()), createRetailerAddress.getRetailerId());
512 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
513 
 
21426 ashik.ali 514 
	}
21292 ashik.ali 515 
 
21426 ashik.ali 516 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 517 
	public ResponseEntity<?> removeAddress(HttpServletRequest request, @RequestParam(name = "addressId") int addressId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 518 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 519 
		retailerRepository.removeAddress(addressId, retailerId);
520 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21426 ashik.ali 521 
	}
522 
 
523 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_ADD, method=RequestMethod.POST)
22931 ashik.ali 524 
	public ResponseEntity<?> addBrand(HttpServletRequest request, @RequestBody RetailerAddBrandRequest retailerAddBrandRequest) throws ProfitMandiBusinessException{
21426 ashik.ali 525 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 526 
		retailerRepository.selectById(retailerAddBrandRequest.getRetailerId());
527 
		this.addBrandWithRetailer(retailerAddBrandRequest.getRetailerId(), retailerAddBrandRequest.getCategories());
528 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
529 
 
21426 ashik.ali 530 
	}
531 
 
532 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 533 
	public ResponseEntity<?> removeBrand(HttpServletRequest request, @RequestParam(name = "brandId") int brandId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 534 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 535 
		brandRepository.selectById(brandId);
536 
		retailerRepository.selectById(retailerId);
537 
		retailerBrandRepository.deleteByRetailerAndBrandId(retailerId, brandId);
538 
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
539 
 
21426 ashik.ali 540 
	}
541 
 
542 
 
21448 ashik.ali 543 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_DOCUMENT, method=RequestMethod.GET)
22931 ashik.ali 544 
	public ResponseEntity<?> getDocumentById(HttpServletRequest request, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 545 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 546 
		return responseSender.ok(retailerRepository.selectDocumentById(retailerId));
547 
 
21426 ashik.ali 548 
	}
549 
 
21448 ashik.ali 550 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_REGISTERED_ADDRESS, method=RequestMethod.GET)
22931 ashik.ali 551 
	public ResponseEntity<?> getRegisteredAddressById(HttpServletRequest request, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21448 ashik.ali 552 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 553 
		return responseSender.ok(retailerRegisteredAddressRepository.selectAddressIdByRetailerId(retailerId));
554 
 
21448 ashik.ali 555 
	}
556 
 
21426 ashik.ali 557 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_ALL, method=RequestMethod.GET)
22931 ashik.ali 558 
	public ResponseEntity<?> getAllShops(HttpServletRequest request, @RequestParam(name = "id") int id)throws ProfitMandiBusinessException{
21426 ashik.ali 559 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 560 
		return responseSender.ok(shopRepository.selectByRetailerId(id));
561 
 
21426 ashik.ali 562 
	}
563 
 
564 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_ALL, method=RequestMethod.GET)
21431 ashik.ali 565 
	public ResponseEntity<?> getAllAddresses(HttpServletRequest request, @RequestParam(name = "id") int id){
21426 ashik.ali 566 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
21440 ashik.ali 567 
		return responseSender.ok(retailerAddressRepository.selectAddressesByRetailerId(id));
21426 ashik.ali 568 
	}
569 
 
570 
 
571 
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_ALL, method=RequestMethod.GET)
21431 ashik.ali 572 
	public ResponseEntity<?> getAllBrads(HttpServletRequest request, @RequestParam(name = "id") int id){
21426 ashik.ali 573 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
21440 ashik.ali 574 
		return responseSender.ok(retailerBrandRepository.selectBrandNamesByRetailerId(id));
21426 ashik.ali 575 
	}
22495 amit.gupta 576 
 
577 
	@RequestMapping(value = "/retailer/showFofoInterest", method=RequestMethod.GET)
22931 ashik.ali 578 
	public ResponseEntity<?> showFofoInterest(HttpServletRequest request) throws ProfitMandiBusinessException{
22495 amit.gupta 579 
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
580 
		User user = userRepository.selectById(userInfo.getUserId());
581 
		RetailerFofoInterest retailerInterest = new RetailerFofoInterest();
582 
		retailerInterest.setCity(user.getCity());
583 
		retailerInterest.setMobile(user.getMobileNumber());
584 
		retailerInterest.setPinCode(user.getPinCode());
585 
		retailerInterest.setUserId(userInfo.getUserId());
22876 amit.gupta 586 
		if(user.getPinCode()!=null){
587 
			retailerInterest.setPinCode(user.getPinCode());
588 
		}
22495 amit.gupta 589 
		retailerInterest.setInterestShownOn(new Date());
590 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
591 
		return responseSender.ok(mongoClient.saveRetailerInterestOnFofo(retailerInterest));
592 
	}
593 
 
594 
	@RequestMapping(value = "/retailer/hasRetailerShownInterest", method=RequestMethod.GET)
595 
	public ResponseEntity<?> getAllBrads(HttpServletRequest request) throws Throwable{
596 
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
597 
		LOGGER.info("requested url : "+request.getRequestURL().toString());
598 
		return responseSender.ok(mongoClient.hasRetailerShownInterest(userInfo.getUserId()));
599 
	}
21426 ashik.ali 600 
 
21292 ashik.ali 601 
}