Subversion Repositories SmartDukaan

Rev

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

Rev 13694 Rev 13709
Line 1... Line 1...
1 
package in.shop2020.support.controllers;
 1 
package in.shop2020.support.controllers;
2 
 
 2 
 
3 
import in.shop2020.model.v1.catalog.CatalogService;
 3 
import in.shop2020.model.v1.catalog.CatalogService;
4 
import in.shop2020.model.v1.catalog.CatalogServiceException;
 4 
import in.shop2020.model.v1.catalog.CatalogServiceException;
- 
 
 5 
import in.shop2020.model.v1.catalog.HsItem;
5 
import in.shop2020.model.v1.catalog.Item;
 6 
import in.shop2020.model.v1.catalog.Item;
6 
import in.shop2020.model.v1.inventory.InventoryService;
 7 
import in.shop2020.model.v1.inventory.InventoryService;
7 
import in.shop2020.model.v1.inventory.InventoryServiceException;
 8 
import in.shop2020.model.v1.inventory.InventoryServiceException;
8 
import in.shop2020.model.v1.inventory.InventoryType;
 9 
import in.shop2020.model.v1.inventory.InventoryType;
9 
import in.shop2020.model.v1.inventory.VendorItemPricing;
 10 
import in.shop2020.model.v1.inventory.VendorItemPricing;
Line 83... Line 84...
83 
	//	ORDER NO Suborder No	Catalogue Name	Billing Name	Shipping Name	Product Id	Item Name	Item Id	Seller SKU Code	Quantity	Suborder Amount	Payment Mode	Suborder Status	Courier Name	Status Date	Pending Days	Sla Days	Overdue Days	Shipping Address	Shipping City	Shipping State	Zip Code	Mobile	Order Date	Desired Date	Remarks
 84 
	//	ORDER NO Suborder No	Catalogue Name	Billing Name	Shipping Name	Product Id	Item Name	Item Id	Seller SKU Code	Quantity	Suborder Amount	Payment Mode	Suborder Status	Courier Name	Status Date	Pending Days	Sla Days	Overdue Days	Shipping Address	Shipping City	Shipping State	Zip Code	Mobile	Order Date	Desired Date	Remarks
84 
	//  0			1				2				3				4				5			6			7		8				9			10				11				12				13				14			15				16			17				18					19				20				21			22		23			24				25
 85 
	//  0			1				2				3				4				5			6			7		8				9			10				11				12				13				14			15				16			17				18					19				20				21			22		23			24				25
85 
	private static final int HS_ORDER_NO_INDEX = 0;
 86 
	private static final int HS_ORDER_NO_INDEX = 0;
86 
	private static final int HS_SUB_ORDER_NO_INDEX = 1;
 87 
	private static final int HS_SUB_ORDER_NO_INDEX = 1;
87 
	private static final int CATALOGUE_NAME_INDEX = 2;
 88 
	private static final int CATALOGUE_NAME_INDEX = 2;
88 
	private static final int SHIPPING_NAME_INDEX = 4;
 89 
	private static final int BILLING_NAME_INDEX = 3;
89 
	private static final int PRODUCT_ID_INDEX = 5;
 90 
	private static final int PRODUCT_ID_INDEX = 5;
90 
	private static final int ITEM_ID_INDEX = 7;
 91 
	private static final int ITEM_ID_INDEX = 7;
91 
	private static final int SELLER_SKU_INDEX = 8;
 92 
	private static final int SELLER_SKU_INDEX = 8;
92 
	private static final int QUANTITY_INDEX = 9;
 93 
	private static final int QUANTITY_INDEX = 9;
93 
	private static final int SUB_ORDER_AMOUNT_INDEX = 10;
 94 
	private static final int SUB_ORDER_AMOUNT_INDEX = 10;
Line 164... Line 165...
164 
			return "authsuccess";
 165 
			return "authsuccess";
165 
 
 166 
 
166 
		Sheet sheet = wb.getSheetAt(0);
 167 
		Sheet sheet = wb.getSheetAt(0);
167 
		Row firstRow = sheet.getRow(0);
 168 
		Row firstRow = sheet.getRow(0);
168 
		Item item;
 169 
		Item item;
- 
 
 170 
		HsItem hsItem;
169 
		in.shop2020.model.v1.catalog.CatalogService.Client catalogClient;
 171 
		in.shop2020.model.v1.catalog.CatalogService.Client catalogClient;
170 
		for (Row row : sheet) {
 172 
		for (Row row : sheet) {
171 
			long orderCountForRow = 0;
 173 
			long orderCountForRow = 0;
172 
			rowId++;
 174 
			rowId++;
173 
			if(row.equals(firstRow))
 175 
			if(row.equals(firstRow))
Line 218... Line 220...
218 
					}
 220 
					}
219 
 
 221 
 
220 
					Order t_order = new Order();
 222 
					Order t_order = new Order();
221 
					t_order.setCustomer_id(user.getUserId());
 223 
					t_order.setCustomer_id(user.getUserId());
222 
					t_order.setCustomer_email(sourceDetail.getEmail());
 224 
					t_order.setCustomer_email(sourceDetail.getEmail());
223 
					row.getCell(SHIPPING_NAME_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 225 
					row.getCell(BILLING_NAME_INDEX).setCellType(Cell.CELL_TYPE_STRING);
224 
					row.getCell(SHIPPING_ADDRESS_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 226 
					row.getCell(SHIPPING_ADDRESS_INDEX).setCellType(Cell.CELL_TYPE_STRING);
225 
					row.getCell(SHIPPING_CITY_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 227 
					row.getCell(SHIPPING_CITY_INDEX).setCellType(Cell.CELL_TYPE_STRING);
226 
					row.getCell(SHIPPING_STATE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 228 
					row.getCell(SHIPPING_STATE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
227 
					row.getCell(MOBILE_NO_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 229 
					row.getCell(MOBILE_NO_INDEX).setCellType(Cell.CELL_TYPE_STRING);
228 
					row.getCell(ZIPCODE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
 230 
					row.getCell(ZIPCODE_INDEX).setCellType(Cell.CELL_TYPE_STRING);
229 
					t_order.setCustomer_name(row.getCell(SHIPPING_NAME_INDEX).getStringCellValue());
 231 
					t_order.setCustomer_name(row.getCell(BILLING_NAME_INDEX).getStringCellValue());
230 
					t_order.setCustomer_mobilenumber(row.getCell(MOBILE_NO_INDEX).getStringCellValue());
 232 
					t_order.setCustomer_mobilenumber(row.getCell(MOBILE_NO_INDEX).getStringCellValue());
231 
					t_order.setCustomer_address1(row.getCell(SHIPPING_ADDRESS_INDEX).getStringCellValue());
 233 
					t_order.setCustomer_address1(row.getCell(SHIPPING_ADDRESS_INDEX).getStringCellValue());
232 
					t_order.setCustomer_address2("");
 234 
					t_order.setCustomer_address2("");
233 
					t_order.setCustomer_city(row.getCell(SHIPPING_CITY_INDEX).getStringCellValue());
 235 
					t_order.setCustomer_city(row.getCell(SHIPPING_CITY_INDEX).getStringCellValue());
234 
					t_order.setCustomer_state(row.getCell(SHIPPING_STATE_INDEX).getStringCellValue());
 236 
					t_order.setCustomer_state(row.getCell(SHIPPING_STATE_INDEX).getStringCellValue());