widana

Untitled

Jan 29th, 2017
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.91 KB | None | 0 0
  1. package org.jleaf.erp.master.web.controller.upload;
  2.  
  3. import java.io.ByteArrayInputStream;
  4. import java.io.IOException;
  5. import java.io.InputStream;
  6. import java.io.OutputStream;
  7. import java.io.StringWriter;
  8. import java.text.SimpleDateFormat;
  9. import java.util.ArrayList;
  10. import java.util.Date;
  11. import java.util.List;
  12. import java.util.Properties;
  13.  
  14. import javax.annotation.PostConstruct;
  15. import javax.faces.context.FacesContext;
  16. import javax.faces.event.AjaxBehaviorEvent;
  17. import javax.servlet.ServletException;
  18. import javax.servlet.http.HttpServletRequest;
  19. import javax.servlet.http.HttpServletResponse;
  20.  
  21. import org.apache.commons.lang.StringUtils;
  22. import org.bouncycastle.asn1.ocsp.Request;
  23. import org.jleaf.core.GeneralConstants;
  24. import org.jleaf.erp.master.api.MasterApiForXcom;
  25. import org.jleaf.erp.master.web.MasterWebConstants;
  26. import org.jleaf.erp.master.web.MasterWebConstantsForXcom;
  27. import org.jleaf.erp.master.web.model.ViewUploaderLazyModel;
  28. import org.jleaf.util.DateUtil;
  29. import org.jleaf.web.helper.MessageHelper;
  30. import org.jleaf.web.helper.ServiceResult;
  31. import org.jleaf.web.jsf.FacesUtils;
  32. import org.jleaf.web.jsf.WebJsfConstants;
  33. import org.jleaf.web.jsf.template.AbstractBrowseAjaxController;
  34. import org.jleaf.web.jsf.template.AbstractBrowseController;
  35. import org.jleaf.web.jsf.template.BasicController;
  36. import org.jleaf.web.jsf.util.JSONObjectUtil;
  37. import org.jleaf.web.model.ComboItem;
  38. import org.jleaf.web.util.RestUtil;
  39. import org.json.simple.JSONObject;
  40. import org.primefaces.context.RequestContext;
  41. import org.primefaces.model.DefaultStreamedContent;
  42. import org.primefaces.model.StreamedContent;
  43. import org.slf4j.Logger;
  44. import org.slf4j.LoggerFactory;
  45. import org.springframework.context.annotation.Scope;
  46. import org.springframework.stereotype.Controller;
  47.  
  48. import com.microsoft.schemas.office.x2006.encryption.CTKeyEncryptor.Uri;
  49.  
  50. import au.com.bytecode.opencsv.CSVWriter;
  51.  
  52. @SuppressWarnings("serial")
  53. @Controller
  54. @Scope("view")
  55. public class UploadSellPriceProductController extends AbstractBrowseController implements MasterApiForXcom {
  56.  
  57. private final static Logger log = LoggerFactory.getLogger(UploadSellPriceProductController.class);
  58.  
  59. private StreamedContent file;
  60.  
  61. private String dataUploaderUrl;
  62.  
  63. private String messageUpload;
  64.  
  65. public String paramaterText;
  66.  
  67. private ViewUploaderLazyModel model;
  68.  
  69. @SuppressWarnings({ "unchecked" })
  70. public void init() {
  71. log.debug(" INIT CONSTRUCTOR ");
  72.  
  73. filterBean.getData().put("dateFrom", DateUtil.dateNow());
  74. filterBean.getData().put("dateTo", DateUtil.dateNow());
  75. filterBean.getData().put("type", GeneralConstants.EMPTY_VALUE);
  76. filterBean.getData().put("status", GeneralConstants.EMPTY_VALUE);
  77. filterBean.getData().put("type", "sellPriceProduct");
  78.  
  79. // load properties
  80. Properties prop = new Properties();
  81.  
  82. log.debug(" load properties " + prop);
  83.  
  84. try {
  85. prop.load(getClass().getClassLoader().getResourceAsStream("/service-config-local.properties"));
  86. dataUploaderUrl = prop.getProperty("datauploader.url");
  87.  
  88. log.debug(" load properties 2 " + dataUploaderUrl);
  89.  
  90. } catch (IOException e) {
  91. e.printStackTrace();
  92.  
  93. log.warn("User default: http://localhost:5000/");
  94. dataUploaderUrl = "http://localhost:5000/";
  95.  
  96. log.debug(" load properties 3 " + dataUploaderUrl);
  97.  
  98. }
  99.  
  100. log.debug(" INIT FILERBEAN " + filterBean.getData());
  101.  
  102. }
  103.  
  104. @SuppressWarnings({ "unchecked" })
  105. public void doSearch() {
  106.  
  107. String dateFrom = filterBean.getData().get("dateFrom").toString();
  108. String dateTo = filterBean.getData().get("dateTo").toString();
  109. String type = filterBean.getData().get("type").toString();
  110. Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
  111. Long userId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_USER_ID).toString());
  112. String status = filterBean.getData().get("status").toString().equals("ALL")? GeneralConstants.EMPTY_VALUE : filterBean.getData().get("status").toString();
  113.  
  114. JSONObject jsonInput = new JSONObject();
  115. jsonInput.put("dateFrom", dateFrom);
  116. jsonInput.put("dateTo", dateTo);
  117. jsonInput.put("type" , type);
  118. jsonInput.put("tenantId" , tenantId);
  119. jsonInput.put("userId" , userId);
  120. jsonInput.put("status", status);
  121.  
  122. try {
  123. JSONObject result = new JSONObject();
  124.  
  125. result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.COUNT_VIEW_UPLOADER_URL + "?tenantId=" + tenantId + "&type=" + type + "&dateFrom="
  126. + dateFrom + "&dateTo=" + dateTo + "&userId=" + userId + "&status=" + status);
  127.  
  128. Long rowCount = Long.valueOf(result.get("count").toString());
  129. model = new ViewUploaderLazyModel(dataUploaderUrl + MasterWebConstantsForXcom.VIEW_UPLOADER_URL, jsonInput);
  130. model.setRowCount(rowCount.intValue());
  131. model.setPageSize(50);
  132.  
  133. log.debug(" model Data " + model + " COUNT " + rowCount);
  134.  
  135. } catch (Exception e) {
  136.  
  137. e.printStackTrace();
  138.  
  139. }
  140. }
  141.  
  142. @SuppressWarnings("unchecked")
  143. public void downloadAllData(JSONObject item) {
  144. try {
  145. //log.debug("downloadAllData");
  146. Long id = Long.valueOf(item.get("id").toString());
  147. String filename = item.get("file").toString();
  148.  
  149. FacesContext fc = FacesContext.getCurrentInstance();
  150. HttpServletResponse response = (HttpServletResponse) fc
  151. .getExternalContext().getResponse();
  152.  
  153. //log.debug("set type");
  154. response.reset();
  155. response.setContentType("text/csv");
  156. response.setHeader("Content-Disposition", "attachment; filename=\""
  157. + "RESULT_ALL_DATA_"+filename + "\"");
  158.  
  159. OutputStream output = response.getOutputStream();
  160.  
  161. // writing just sample data
  162. List<String> strings = new ArrayList<String>();
  163.  
  164. JSONObject result = new JSONObject();
  165. result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_ALL_URL+ "/" +id);
  166.  
  167. log.debug(" result header " + result);
  168.  
  169. String headers = (String) result.get("header");
  170. String[] columns = headers.split(",");
  171.  
  172. String headersUsingTab = StringUtils.join(columns, "\t");
  173. strings.add(headersUsingTab);
  174. strings.add("\n");
  175.  
  176. List<JSONObject> data = new ArrayList<JSONObject>();
  177. data = (List<JSONObject>) result.get("data");
  178.  
  179. for(JSONObject obj : data){
  180.  
  181. for(int i=0; i<columns.length;i++){
  182. strings.add( obj.get(columns[i]).toString());
  183. if(i==columns.length-1)
  184. strings.add( "\n");
  185. else
  186. strings.add( "\t");
  187. }
  188. }
  189.  
  190. for (String s : strings) {
  191. output.write(s.getBytes());
  192. }
  193.  
  194. output.flush();
  195. output.close();
  196.  
  197. fc.responseComplete();
  198.  
  199. } catch (Exception e) {
  200. log.error(e.getMessage(), e);
  201. }
  202. }
  203.  
  204. @SuppressWarnings("unchecked")
  205. public void downloadFailData(JSONObject item) {
  206. try {
  207. //log.debug("downloadAllData");
  208. Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
  209. Long id = Long.valueOf(item.get("id").toString());
  210. String filename = item.get("file").toString();
  211.  
  212. FacesContext fc = FacesContext.getCurrentInstance();
  213. HttpServletResponse response = (HttpServletResponse) fc
  214. .getExternalContext().getResponse();
  215.  
  216. //log.debug("set type");
  217. response.reset();
  218. response.setContentType("text/csv");
  219. response.setHeader("Content-Disposition", "attachment; filename=\""
  220. + "RESULT_FAIL_DATA_"+filename + "\"");
  221.  
  222. OutputStream output = response.getOutputStream();
  223.  
  224. // writing just sample data
  225. List<String> strings = new ArrayList<String>();
  226.  
  227. JSONObject result = new JSONObject();
  228. result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_FAIL_URL+ "/" +id+"?tenantId="+tenantId);
  229.  
  230. String headers = (String) result.get("header");
  231. String[] columns = headers.split(",");
  232.  
  233. String headersUsingTab = StringUtils.join(columns, "\t");
  234. strings.add(headersUsingTab);
  235. strings.add("\n");
  236.  
  237. List<JSONObject> data = new ArrayList<JSONObject>();
  238. data = (List<JSONObject>) result.get("data");
  239.  
  240. for(JSONObject obj : data){
  241.  
  242. for(int i=0; i<columns.length;i++){
  243. strings.add( obj.get(columns[i]).toString());
  244. if(i==columns.length-1)
  245. strings.add( "\n");
  246. else
  247. strings.add( "\t");
  248. }
  249. }
  250.  
  251. for (String s : strings) {
  252. output.write(s.getBytes());
  253. }
  254.  
  255. output.flush();
  256. output.close();
  257.  
  258. fc.responseComplete();
  259.  
  260. } catch (Exception e) {
  261. log.error(e.getMessage(), e);
  262. }
  263. }
  264.  
  265. @SuppressWarnings("unchecked")
  266. public void downloadErrorData(JSONObject item){
  267. try {
  268. //log.debug("downloadErrorData");
  269. Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
  270. Long id = Long.valueOf(item.get("id").toString());
  271. String filename = item.get("file").toString();
  272.  
  273. FacesContext fc = FacesContext.getCurrentInstance();
  274. HttpServletResponse response = (HttpServletResponse) fc
  275. .getExternalContext().getResponse();
  276.  
  277. //log.debug("set type");
  278. response.reset();
  279. response.setContentType("text/csv");
  280. response.setHeader("Content-Disposition", "attachment; filename=\""
  281. + "RESULT_ERROR_DATA_"+filename + "\"");
  282.  
  283. OutputStream output = response.getOutputStream();
  284.  
  285. // writing just sample data
  286. List<String> strings = new ArrayList<String>();
  287.  
  288. JSONObject result = new JSONObject();
  289. result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_ERROR_URL+ "/" +id+"?tenantId="+tenantId);
  290.  
  291. String headers = (String) result.get("header");
  292. String[] columns = headers.split(",");
  293.  
  294. String headersUsingTab = StringUtils.join(columns, "\t");
  295. strings.add(headersUsingTab);
  296. strings.add("\n");
  297.  
  298. List<JSONObject> data = new ArrayList<JSONObject>();
  299. data = (List<JSONObject>) result.get("data");
  300.  
  301. for(JSONObject obj : data){
  302.  
  303. for(int i=0; i<columns.length;i++){
  304. strings.add( obj.get(columns[i]).toString());
  305. if(i==columns.length-1)
  306. strings.add( "\n");
  307. else
  308. strings.add( "\t");
  309. }
  310. }
  311.  
  312. for (String s : strings) {
  313. output.write(s.getBytes());
  314. }
  315.  
  316. output.flush();
  317. output.close();
  318.  
  319. fc.responseComplete();
  320.  
  321. } catch (Exception e) {
  322. log.error(e.getMessage(), e);
  323. }
  324. }
  325.  
  326. public ViewUploaderLazyModel getModel() {
  327. return model;
  328. }
  329.  
  330.  
  331. public void setModel(ViewUploaderLazyModel model) {
  332. this.model = model;
  333. }
  334.  
  335.  
  336. public StreamedContent getFile() {
  337.  
  338. log.debug(">>>>>>>>>>>>>>>>>>>>>>> GET FILE");
  339. setMessageUpload("none");
  340. String date = new SimpleDateFormat("MM_dd_yyyy").format(DateUtil.convertToDate(DateUtil.dateNow()));
  341. String fileName = "SellPriceProduct"+date+".csv";
  342. List<String[]> csvDataList = getCsvDataToWrite();
  343.  
  344. try {
  345. InputStream inputStream = writeToCsv(csvDataList);
  346. file = new DefaultStreamedContent(inputStream, "text/csv", fileName);
  347. } catch (Exception e) {
  348. MessageHelper.displayError(e.toString());
  349. }
  350.  
  351. return file;
  352.  
  353. }
  354.  
  355. private List<String[]> getCsvDataToWrite(){
  356. List<String[]> outputList = new ArrayList<String[]>();
  357.  
  358. // build header
  359. String[] header = {
  360. "product_code","ou_code","date_from (YYYYMMDD)","date_to (YYYYMMDD)","curr_code","gross_sell_price","min_sell_price","price_level"
  361.  
  362. };
  363. outputList.add(header);
  364.  
  365. return outputList;
  366. }
  367.  
  368. private InputStream writeToCsv(List<String[]> data) throws IOException{
  369. StringWriter writer = new StringWriter();
  370. CSVWriter csvWriter = new CSVWriter(writer,',', '"'); // \u0000Tidak perlu pakai quote character
  371. csvWriter.writeAll(data);
  372. csvWriter.close();
  373.  
  374. return new ByteArrayInputStream(writer.toString().getBytes());
  375. }
  376.  
  377. public void setFile(StreamedContent file) {
  378. this.file = file;
  379. }
  380.  
  381. public String getParamaterText() {
  382. return paramaterText;
  383. }
  384.  
  385. public void setParamaterText(String paramaterText) {
  386. this.paramaterText = paramaterText;
  387. }
  388.  
  389. public String getMessageUpload() {
  390. return messageUpload;
  391. }
  392.  
  393. public void setMessageUpload(String messageUpload) {
  394. this.messageUpload = messageUpload;
  395. }
  396.  
  397. public void ouChanged(AjaxBehaviorEvent evnt) {
  398.  
  399. log.debug(" INIT ouChanged ");
  400.  
  401. }
  402.  
  403. public void makeParameter() {
  404.  
  405. log.debug(" MAKE PARAMETER ");
  406.  
  407. }
  408.  
  409. public String getDataUploaderUrl() {
  410. return dataUploaderUrl;
  411. }
  412.  
  413. public void setDataUploaderUrl(String dataUploaderUrl) {
  414. this.dataUploaderUrl = dataUploaderUrl;
  415. }
  416.  
  417. @Override
  418. public String searchTaskName() {
  419. // TODO Auto-generated method stub
  420. return null;
  421. }
  422.  
  423. @Override
  424. public JSONObject getJsonForSearch() {
  425. // TODO Auto-generated method stub
  426. return null;
  427. }
  428.  
  429. @Override
  430. public void afterSearch(JSONObject result, boolean isOk) {
  431. // TODO Auto-generated method stub
  432.  
  433. }
  434.  
  435.  
  436. }
Advertisement
Add Comment
Please, Sign In to add comment