public static Map<String, SNInventory> getMap(User user, String startTime) {
// startTime = "2015-05-03";
Map<String, SNInventory> map = new HashMap<String, SNInventory>();
try {
String tempPath = PathUtill.getXMLpath();
tempPath +=
"data"
+ File.separator
+ "DownloadInventory"
+ File.separator
+ startTime
+ File.separator
+ "SuNing";
File file = new File(tempPath);
if (!file.exists()) {
file.mkdirs();
}
File file2 = new File(tempPath + File.separator + "model.csv");
logger.info(file2.getAbsolutePath());
if (file2.exists()) {
logger.info("model.csv");
CsvReader reader =
new CsvReader(file2.getPath(), ',', Charset.forName("GBK")); // 一般用这编码读就可以了
map = getMapByreader(reader);
}
logger.info(map.size());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} // 跳过表头 如果需要表头的话，不要写这句。
return map;
}
// 型号 , 状态
public static Map<String, List<SNInventory>> getMapBranchType(
User user, String startTime, int branchid) {
// startTime = "2015-05-03";
// List<Inventory> list = new ArrayList<Inventory>();
Branch branch = BranchService.getMap().get(branchid);
String bnum = "";
if (null != branch) {
bnum = branch.getEncoded();
}
// logger.info()
Map<String, Product> mapp = ProductService.gettypeNUmmap();
// logger.info(mapp);
Map<String, List<SNInventory>> map = new HashMap<String, List<SNInventory>>();
if (null != branch && branch.getBranchtype().getSaletype() == SaleModel.Model.苏宁.getValue()) {
try {
String tempPath = PathUtill.getXMLpath();
tempPath +=
"data"
+ File.separator
+ "DownloadInventory"
+ File.separator
+ startTime
+ File.separator
+ "SuNing";
logger.info(tempPath);
File file = new File(tempPath);
if (!file.exists()) {
file.mkdirs();
}
File file2 = new File(tempPath + File.separator + "model.csv");
// file2.createNewFile();
CsvReader reader =
new CsvReader(file2.getPath(), ',', Charset.forName("GBK")); // 一般用这编码读就可以了
reader.readHeaders();
while (reader.readRecord()) { // 逐行读入除表头的数据
String[] strs = reader.getValues();
if (null != strs) {
SNInventory in = new SNInventory();
for (int i = 0; i < strs.length; i++) {
// logger.info(i);
String str = strs[i];
// logger.info(str);
if (i == 0) {
// logger.info(str);
in.setGoodType("样机");
} else if (i == 2) {
in.setBranchName(str);
} else if (i == 3) {
in.setBranchNum(str);
} else if (i == 6) {
in.setGoodGroupName(str);
} else if (i == 7) {
in.setGoodGroupNum(str);
} else if (i == 10) {
in.setGoodpName(str);
} else if (i == 11) {
in.setGoodNum(str);
} else if (i == 12) {
double realnum = Double.valueOf(str);
int re = (int) realnum;
in.setNum(re);
} else if (i == 13) {
in.setSerialNumber(str);
}
}
// logger.info(in.getBranchNum());
String bnu = in.getBranchNum();
// logger.info(bnu);
// logger.info(in.getBranchNum());
if (bnum.equals(bnu)) {
String key = in.getGoodNum();
// logger.info(key);
Product p = mapp.get(key);
// logger.info(p);
if (null != p) {
String pname = mapp.get(key).getType();
List<SNInventory> inmap = map.get(pname);
if (inmap == null) {
inmap = new ArrayList<SNInventory>();
map.put(pname, inmap);
}
inmap.add(in);
}
}
}
}
logger.info(map.size());
reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} // 跳过表头 如果需要表头的话，不要写这句。
}
return map;
}
public static void save() {
URI uri;
try {
uri = new URI(url);
HttpUriRequest request =
RequestBuilder.post()
.setUri(uri)
.addParameter("productCode", "")
// .addParameter("formName", "reportQueryConditon")
// .addParameter("receiveCode", "")
// .addParameter("buyerProductcode", "101123403")
.build();
CloseableHttpResponse response2 = MyMainClient.getHttpclient().execute(request);
int statusCode = response2.getStatusLine().getStatusCode();
if (statusCode == HttpStatus.SC_MOVED_PERMANENTLY
|| statusCode == HttpStatus.SC_MOVED_TEMPORARILY) {
try {
MyLogin.loginpost(new URI(MyLogin.url));
} catch (URISyntaxException e) {
logger.info(e);
}
response2 = MyMainClient.getHttpclient().execute(request);
}
MyMainClient.mapreturn.put("InventoryModelDownLoadstatue", statusCode + "");
HttpEntity entity = response2.getEntity();
// EntityUtils.consume(entity);
InputStream in = entity.getContent();
String tempPath = PathUtill.getXMLpath();
tempPath +=
"data"
+ File.separator
+ "DownloadInventory"
+ File.separator
+ TimeUtill.getdateString()
+ File.separator
+ "SuNing";
logger.info(tempPath);
File file = new File(tempPath);
if (!file.exists()) {
file.mkdirs();
}
File file2 = new File(tempPath + File.separator + "model.csv");
file2.createNewFile();
try {
FileOutputStream fout = new FileOutputStream(file2);
int l = -1;
byte[] tmp = new byte[1024];
while ((l = in.read(tmp)) != -1) {
fout.write(tmp, 0, l);
// 注意这里如果用OutputStream.write(buff)的话，图片会失真，大家可以试试
}
fout.flush();
fout.close();
response2.close();
} finally {
// 关闭低层流。
in.close();
}
} catch (URISyntaxException e) {
// TODO Auto-generated catch block
logger.info(e);
} catch (ClientProtocolException e) {
// TODO Auto-generated catch block
logger.info(e);
} catch (IOException e) {
// TODO Auto-generated catch block
logger.info(e);
}
}
public static List<SNInventory> getMap() {
// startTime = "2015-05-03";
List<SNInventory> list = new ArrayList<SNInventory>();
Map<Integer, Map<String, Map<Integer, InventoryBranch>>> mapin =
InventoryBranchManager.getInventoryMap();
try {
String tempPath = PathUtill.getXMLpath();
tempPath +=
"data"
+ File.separator
+ "DownloadInventory"
+ File.separator
+ TimeUtill.getdateString()
+ File.separator
+ "SuNing";
logger.info(tempPath);
File file = new File(tempPath);
if (!file.exists()) {
file.mkdirs();
}
File file2 = new File(tempPath + File.separator + "model.csv");
// file2.createNewFile();
CsvReader reader = new CsvReader(file2.getPath(), ',', Charset.forName("GBK")); // 一般用这编码读就可以了
reader.readHeaders();
int count = 0;
while (reader.readRecord()) { // 逐行读入除表头的数据
String[] strs = reader.getValues();
if (null != strs) {
SNInventory in = new SNInventory();
for (int i = 0; i < strs.length; i++) {
// logger.info(i);
String str = strs[i];
// logger.info(str);
if (i == 0) {
// logger.info(str);
in.setGoodType("样机");
} else if (i == 2) {
in.setBranchName(str);
} else if (i == 3) {
in.setBranchNum(str);
} else if (i == 6) {
in.setGoodGroupName(str);
} else if (i == 7) {
in.setGoodGroupNum(str);
} else if (i == 10) {
in.setGoodpName(str);
} else if (i == 11) {
in.setGoodNum(str);
} else if (i == 12) {
double realnum = Double.valueOf(str);
int re = (int) realnum;
in.setNum(re);
} else if (i == 13) {
in.setSerialNumber(str);
}
}
count++;
int branchid = -1;
int type = -1;
try {
branchid = BranchService.getNumMap(Model.苏宁.getValue()).get(in.getBranchNum()).getId();
// logger.info(in.getBranchNum());
} catch (Exception e) {
logger.info("转化门店出错");
}
try {
type = ProductService.gettypeNUmmap().get(in.getGoodNum()).getId();
// logger.info(in.getGoodNum());
} catch (Exception e) {
logger.info("转化型号出错");
}
if (branchid != -1 && type != -1) {
in.setBid(branchid);
in.setTid(type);
Map<String, Map<Integer, InventoryBranch>> mapb = mapin.get(branchid);
if (null == mapb) {
list.add(in);
} else {
Map<Integer, InventoryBranch> mapt = mapb.get(type + "");
if (null == mapt) {
list.add(in);
} else {
InventoryBranch inb = mapt.get(OrderGoods.prototype);
if (null == inb) {
list.add(in);
}
}
}
}
}
}
logger.info("count" + count);
reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
logger.info(e);
} // 跳过表头 如果需要表头的话，不要写这句。
logger.info("list" + list.size());
return list;
}