Subversion Repositories SmartDukaan

Rev

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

Rev 11944 Rev 11945
Line 1034... Line 1034...
1034 
			BufferedReader reader = null;
 1034 
			BufferedReader reader = null;
1035 
			File readfile = new File("/tmp/" + fileName + "-leftOutInv.xls");
 1035 
			File readfile = new File("/tmp/" + fileName + "-leftOutInv.xls");
1036 
		    reader = new BufferedReader(new FileReader(readfile));
 1036 
		    reader = new BufferedReader(new FileReader(readfile));
1037 
		    String line;
 1037 
		    String line;
1038 
		    String values[];
 1038 
		    String values[];
- 
 
 1039 
		    int i=1;
1039 
		  //id -0, name -1, sku - 2, vname 3, wh 4, wt 5, mnlc 6, vnlc 7, av8, r9, na 10
 1040 
		  //id -0, name -1, sku - 2, vname 3, wh 4, wt 5, mnlc 6, vnlc 7, av8, r9, na 10
1040 
		    while ((line = reader.readLine()) != null) {
 1041 
		    while ((line = reader.readLine()) != null) {
- 
 
 1042 
		    	if(i==1){
- 
 
 1043 
		    		i= i++;
- 
 
 1044 
		    		continue;
- 
 
 1045 
		    	}
1041 
		        values = line.split("\t");
 1046 
		        values = line.split("\t");
1042 
		        NlcLeftOutInventory nlcLoI = new NlcLeftOutInventory();
 1047 
		        NlcLeftOutInventory nlcLoI = new NlcLeftOutInventory();
1043 
		        nlcLoI.setItemId(Long.parseLong(values[0]));
 1048 
		        nlcLoI.setItemId(Long.parseLong(values[0]));
1044 
		        nlcLoI.setProductName(values[1]);
 1049 
		        nlcLoI.setProductName(values[1]);
1045 
		        nlcLoI.setOurNlc(Double.parseDouble(values[6]));
 1050 
		        nlcLoI.setOurNlc(Double.parseDouble(values[6]));
Line 1066... Line 1071...
1066 
					}
 1071 
					}
1067 
					if (nlcLoI.getWarehouseType().equalsIgnoreCase("THIRD_PARTY")) {
 1072 
					if (nlcLoI.getWarehouseType().equalsIgnoreCase("THIRD_PARTY")) {
1068 
						subNlcLoiItemsListFK2.add(nlcLoI);
 1073 
						subNlcLoiItemsListFK2.add(nlcLoI);
1069 
					}
 1074 
					}
1070 
		        }
 1075 
		        }
- 
 
 1076 
		        i++;
1071 
		    }
 1077 
		    }
1072 
		    StringBuffer sb = new StringBuffer();
 1078 
		    StringBuffer sb = new StringBuffer();
1073 
			sb.append("<html><table border=\"1\" align=\"center\">"
 1079 
			sb.append("<html><table border=\"1\" align=\"center\">"
1074 
					+ "<caption><b>" + "LEFT OUT INVENTORY DETAIL" + "</b></caption>"
 1080 
					+ "<caption><b>" + "LEFT OUT INVENTORY DETAIL" + "</b></caption>"
1075 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>" + "<td><b>"
 1081 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>" + "<td><b>"