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>"