Subversion Repositories SmartDukaan

Rev

Rev 28981 | Rev 28991 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 28981 Rev 28990
Line 165... Line 165...
165 
import com.spice.profitmandi.dao.repository.fofo.PendingOrderService;
 165 
import com.spice.profitmandi.dao.repository.fofo.PendingOrderService;
166 
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
 166 
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
167 
import com.spice.profitmandi.dao.repository.fofo.RazorPayRepository;
 167 
import com.spice.profitmandi.dao.repository.fofo.RazorPayRepository;
168 
import com.spice.profitmandi.dao.repository.fofo.ScanRecordRepository;
 168 
import com.spice.profitmandi.dao.repository.fofo.ScanRecordRepository;
169 
import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
 169 
import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
- 
 
 170 
import com.spice.profitmandi.dao.repository.inventory.StateRepository;
170 
import com.spice.profitmandi.dao.repository.inventory.WarehouseRepository;
 171 
import com.spice.profitmandi.dao.repository.inventory.WarehouseRepository;
171 
import com.spice.profitmandi.dao.repository.transaction.HdfcPaymentRepository;
 172 
import com.spice.profitmandi.dao.repository.transaction.HdfcPaymentRepository;
172 
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
 173 
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
173 
import com.spice.profitmandi.dao.repository.transaction.PriceDropIMEIRepository;
 174 
import com.spice.profitmandi.dao.repository.transaction.PriceDropIMEIRepository;
174 
import com.spice.profitmandi.dao.repository.transaction.PriceDropRepository;
 175 
import com.spice.profitmandi.dao.repository.transaction.PriceDropRepository;
Line 1296... Line 1297...
1296 
 
 1297 
 
1297 
			}
 1298 
			}
1298 
		}
 1299 
		}
1299 
 
 1300 
 
1300 
	}
 1301 
	}
- 
 
 1302
- 
 
 1303 
	@Autowired
- 
 
 1304 
	StateRepository stateRepository;
1301 
 
 1305 
 
1302 
	public void gst() throws Exception {
 1306 
	public void gst() throws Exception {
1303 
		List<FofoOrder> fofoOrders = fofoOrderRepository.selectBetweenSaleDate(LocalDate.of(2019, 1, 26).atStartOfDay(),
 1307 
		List<FofoOrder> fofoOrders = fofoOrderRepository.selectBetweenSaleDate(LocalDate.of(2021, 4, 1).atStartOfDay(),
1304 
				LocalDate.of(2019, 1, 27).atTime(LocalTime.MAX));
 1308 
				LocalDateTime.now());
1305 
		for (FofoOrder fofoOrder : fofoOrders) {
 1309 
		for (FofoOrder fofoOrder : fofoOrders) {
1306 
			int retailerAddressId = retailerRegisteredAddressRepository
 1310 
			int retailerAddressId = retailerRegisteredAddressRepository
1307 
					.selectAddressIdByRetailerId(fofoOrder.getFofoId());
 1311 
					.selectAddressIdByRetailerId(fofoOrder.getFofoId());
1308 
 
 1312 
 
1309 
			Address retailerAddress = addressRepository.selectById(retailerAddressId);
 1313 
			Address retailerAddress = addressRepository.selectById(retailerAddressId);
1310 
			CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
 1314 
			CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
1311 
			Integer stateId = null;
 1315 
			Integer stateId = null;
1312 
			if (customerAddress.getState().equals(retailerAddress.getState())) {
 1316 
			if (customerAddress.getState().equals(retailerAddress.getState())) {
1313 
				try {
 1317 
				try {
1314 
					stateId = Long.valueOf(Utils.getStateInfo(customerAddress.getState()).getId()).intValue();
 1318 
					stateId = stateRepository.selectByName(customerAddress.getState()).getId();
1315 
				} catch (Exception e) {
 1319 
				} catch (Exception e) {
1316 
					LOGGER.error("Unable to get state rates");
 1320 
					LOGGER.error("Cannot found state named {}", customerAddress.getState());
- 
 
 1321 
					continue;
1317 
				}
 1322 
				}
1318 
			}
 1323 
			}
1319 
			Map<Integer, GstRate> itemIdStateTaxRateMap = null;
 1324 
			Map<Integer, GstRate> itemIdStateTaxRateMap = null;
1320 
			Map<Integer, Float> itemIdIgstTaxRateMap = null;
 1325 
			Map<Integer, Float> itemIdIgstTaxRateMap = null;
1321 
 
 1326 
 
Line 1326... Line 1331...
1326 
			} else {
 1331 
			} else {
1327 
				itemIdIgstTaxRateMap = stateGstRateRepository.getIgstTaxRate(itemIds);
 1332 
				itemIdIgstTaxRateMap = stateGstRateRepository.getIgstTaxRate(itemIds);
1328 
			}
 1333 
			}
1329 
 
 1334 
 
1330 
			for (FofoOrderItem foi : fofoOrderItems) {
 1335 
			for (FofoOrderItem foi : fofoOrderItems) {
- 
 
 1336 
				float sgstRate = foi.getSgstRate();
- 
 
 1337 
				float cgstRate = foi.getCgstRate();
- 
 
 1338 
				float igstRate = foi.getIgstRate();
1331 
				if (stateId == null) {
 1339 
				if (stateId == null && igstRate==0) {
- 
 
 1340 
					/*
- 
 
 1341 
					 * foi.setSgstRate(0); foi.setCgstRate(0);
1332 
					foi.setIgstRate(itemIdIgstTaxRateMap.get(foi.getItemId()));
 1342 
					 * foi.setIgstRate(itemIdIgstTaxRateMap.get(foi.getItemId()));
1333 
				} else {
 1343 
					 */
- 
 
 1344 
					LOGGER.info("customerAddress.getState() {}, ", customerAddress.getState(), retailerAddress.getState());
- 
 
 1345 
					LOGGER.info("Rates getIgstRate() {}", itemIdIgstTaxRateMap.get(foi.getItemId()));
- 
 
 1346
- 
 
 1347 
				} else if (stateId != null && sgstRate==0 && cgstRate == 0){
- 
 
 1348 
					/*
- 
 
 1349 
					 * foi.setIgstRate(0);
1334 
					foi.setCgstRate(itemIdStateTaxRateMap.get(foi.getItemId()).getCgstRate());
 1350 
					 * foi.setCgstRate(itemIdStateTaxRateMap.get(foi.getItemId()).getCgstRate());
1335 
					foi.setSgstRate(itemIdStateTaxRateMap.get(foi.getItemId()).getSgstRate());
 1351 
					 * foi.setSgstRate(itemIdStateTaxRateMap.get(foi.getItemId()).getSgstRate());
- 
 
 1352 
					 */
- 
 
 1353 
					LOGGER.info("customerAddress.getState() {}, ", customerAddress.getState(), retailerAddress.getState());
- 
 
 1354 
					LOGGER.info("Rates getCgstRate() {}, getSgstRate() {}", itemIdStateTaxRateMap.get(foi.getItemId()).getCgstRate(), itemIdStateTaxRateMap.get(foi.getItemId()).getSgstRate());
1336 
				}
 1355 
				}
1337 
				fofoOrderItemRepository.persist(foi);
 - 
 
1338 
			}
 1356 
			}
1339 
		}
 1357 
		}
1340 
 
 1358 
 
1341 
	}
 1359 
	}
1342 
 
 1360