Subversion Repositories SmartDukaan

Rev

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