Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package org.jleaf.erp.master.web.controller.upload;
- import java.io.ByteArrayInputStream;
- import java.io.IOException;
- import java.io.InputStream;
- import java.io.OutputStream;
- import java.io.StringWriter;
- import java.text.SimpleDateFormat;
- import java.util.ArrayList;
- import java.util.Date;
- import java.util.List;
- import java.util.Properties;
- import javax.annotation.PostConstruct;
- import javax.faces.context.FacesContext;
- import javax.faces.event.AjaxBehaviorEvent;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import org.apache.commons.lang.StringUtils;
- import org.bouncycastle.asn1.ocsp.Request;
- import org.jleaf.core.GeneralConstants;
- import org.jleaf.erp.master.api.MasterApiForXcom;
- import org.jleaf.erp.master.web.MasterWebConstants;
- import org.jleaf.erp.master.web.MasterWebConstantsForXcom;
- import org.jleaf.erp.master.web.model.ViewUploaderLazyModel;
- import org.jleaf.util.DateUtil;
- import org.jleaf.web.helper.MessageHelper;
- import org.jleaf.web.helper.ServiceResult;
- import org.jleaf.web.jsf.FacesUtils;
- import org.jleaf.web.jsf.WebJsfConstants;
- import org.jleaf.web.jsf.template.AbstractBrowseAjaxController;
- import org.jleaf.web.jsf.template.AbstractBrowseController;
- import org.jleaf.web.jsf.template.BasicController;
- import org.jleaf.web.jsf.util.JSONObjectUtil;
- import org.jleaf.web.model.ComboItem;
- import org.jleaf.web.util.RestUtil;
- import org.json.simple.JSONObject;
- import org.primefaces.context.RequestContext;
- import org.primefaces.model.DefaultStreamedContent;
- import org.primefaces.model.StreamedContent;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.context.annotation.Scope;
- import org.springframework.stereotype.Controller;
- import com.microsoft.schemas.office.x2006.encryption.CTKeyEncryptor.Uri;
- import au.com.bytecode.opencsv.CSVWriter;
- @SuppressWarnings("serial")
- @Controller
- @Scope("view")
- public class UploadSellPriceProductController extends AbstractBrowseController implements MasterApiForXcom {
- private final static Logger log = LoggerFactory.getLogger(UploadSellPriceProductController.class);
- private StreamedContent file;
- private String dataUploaderUrl;
- private String messageUpload;
- public String paramaterText;
- private ViewUploaderLazyModel model;
- @SuppressWarnings({ "unchecked" })
- public void init() {
- log.debug(" INIT CONSTRUCTOR ");
- filterBean.getData().put("dateFrom", DateUtil.dateNow());
- filterBean.getData().put("dateTo", DateUtil.dateNow());
- filterBean.getData().put("type", GeneralConstants.EMPTY_VALUE);
- filterBean.getData().put("status", GeneralConstants.EMPTY_VALUE);
- filterBean.getData().put("type", "sellPriceProduct");
- // load properties
- Properties prop = new Properties();
- log.debug(" load properties " + prop);
- try {
- prop.load(getClass().getClassLoader().getResourceAsStream("/service-config-local.properties"));
- dataUploaderUrl = prop.getProperty("datauploader.url");
- log.debug(" load properties 2 " + dataUploaderUrl);
- } catch (IOException e) {
- e.printStackTrace();
- log.warn("User default: http://localhost:5000/");
- dataUploaderUrl = "http://localhost:5000/";
- log.debug(" load properties 3 " + dataUploaderUrl);
- }
- log.debug(" INIT FILERBEAN " + filterBean.getData());
- }
- @SuppressWarnings({ "unchecked" })
- public void doSearch() {
- String dateFrom = filterBean.getData().get("dateFrom").toString();
- String dateTo = filterBean.getData().get("dateTo").toString();
- String type = filterBean.getData().get("type").toString();
- Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
- Long userId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_USER_ID).toString());
- String status = filterBean.getData().get("status").toString().equals("ALL")? GeneralConstants.EMPTY_VALUE : filterBean.getData().get("status").toString();
- JSONObject jsonInput = new JSONObject();
- jsonInput.put("dateFrom", dateFrom);
- jsonInput.put("dateTo", dateTo);
- jsonInput.put("type" , type);
- jsonInput.put("tenantId" , tenantId);
- jsonInput.put("userId" , userId);
- jsonInput.put("status", status);
- try {
- JSONObject result = new JSONObject();
- result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.COUNT_VIEW_UPLOADER_URL + "?tenantId=" + tenantId + "&type=" + type + "&dateFrom="
- + dateFrom + "&dateTo=" + dateTo + "&userId=" + userId + "&status=" + status);
- Long rowCount = Long.valueOf(result.get("count").toString());
- model = new ViewUploaderLazyModel(dataUploaderUrl + MasterWebConstantsForXcom.VIEW_UPLOADER_URL, jsonInput);
- model.setRowCount(rowCount.intValue());
- model.setPageSize(50);
- log.debug(" model Data " + model + " COUNT " + rowCount);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- @SuppressWarnings("unchecked")
- public void downloadAllData(JSONObject item) {
- try {
- //log.debug("downloadAllData");
- Long id = Long.valueOf(item.get("id").toString());
- String filename = item.get("file").toString();
- FacesContext fc = FacesContext.getCurrentInstance();
- HttpServletResponse response = (HttpServletResponse) fc
- .getExternalContext().getResponse();
- //log.debug("set type");
- response.reset();
- response.setContentType("text/csv");
- response.setHeader("Content-Disposition", "attachment; filename=\""
- + "RESULT_ALL_DATA_"+filename + "\"");
- OutputStream output = response.getOutputStream();
- // writing just sample data
- List<String> strings = new ArrayList<String>();
- JSONObject result = new JSONObject();
- result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_ALL_URL+ "/" +id);
- log.debug(" result header " + result);
- String headers = (String) result.get("header");
- String[] columns = headers.split(",");
- String headersUsingTab = StringUtils.join(columns, "\t");
- strings.add(headersUsingTab);
- strings.add("\n");
- List<JSONObject> data = new ArrayList<JSONObject>();
- data = (List<JSONObject>) result.get("data");
- for(JSONObject obj : data){
- for(int i=0; i<columns.length;i++){
- strings.add( obj.get(columns[i]).toString());
- if(i==columns.length-1)
- strings.add( "\n");
- else
- strings.add( "\t");
- }
- }
- for (String s : strings) {
- output.write(s.getBytes());
- }
- output.flush();
- output.close();
- fc.responseComplete();
- } catch (Exception e) {
- log.error(e.getMessage(), e);
- }
- }
- @SuppressWarnings("unchecked")
- public void downloadFailData(JSONObject item) {
- try {
- //log.debug("downloadAllData");
- Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
- Long id = Long.valueOf(item.get("id").toString());
- String filename = item.get("file").toString();
- FacesContext fc = FacesContext.getCurrentInstance();
- HttpServletResponse response = (HttpServletResponse) fc
- .getExternalContext().getResponse();
- //log.debug("set type");
- response.reset();
- response.setContentType("text/csv");
- response.setHeader("Content-Disposition", "attachment; filename=\""
- + "RESULT_FAIL_DATA_"+filename + "\"");
- OutputStream output = response.getOutputStream();
- // writing just sample data
- List<String> strings = new ArrayList<String>();
- JSONObject result = new JSONObject();
- result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_FAIL_URL+ "/" +id+"?tenantId="+tenantId);
- String headers = (String) result.get("header");
- String[] columns = headers.split(",");
- String headersUsingTab = StringUtils.join(columns, "\t");
- strings.add(headersUsingTab);
- strings.add("\n");
- List<JSONObject> data = new ArrayList<JSONObject>();
- data = (List<JSONObject>) result.get("data");
- for(JSONObject obj : data){
- for(int i=0; i<columns.length;i++){
- strings.add( obj.get(columns[i]).toString());
- if(i==columns.length-1)
- strings.add( "\n");
- else
- strings.add( "\t");
- }
- }
- for (String s : strings) {
- output.write(s.getBytes());
- }
- output.flush();
- output.close();
- fc.responseComplete();
- } catch (Exception e) {
- log.error(e.getMessage(), e);
- }
- }
- @SuppressWarnings("unchecked")
- public void downloadErrorData(JSONObject item){
- try {
- //log.debug("downloadErrorData");
- Long tenantId = Long.valueOf(FacesUtils.getSessionMap().get(WebJsfConstants.SESS_LOGGED_TENANT_ID).toString());
- Long id = Long.valueOf(item.get("id").toString());
- String filename = item.get("file").toString();
- FacesContext fc = FacesContext.getCurrentInstance();
- HttpServletResponse response = (HttpServletResponse) fc
- .getExternalContext().getResponse();
- //log.debug("set type");
- response.reset();
- response.setContentType("text/csv");
- response.setHeader("Content-Disposition", "attachment; filename=\""
- + "RESULT_ERROR_DATA_"+filename + "\"");
- OutputStream output = response.getOutputStream();
- // writing just sample data
- List<String> strings = new ArrayList<String>();
- JSONObject result = new JSONObject();
- result = RestUtil.get(dataUploaderUrl + MasterWebConstantsForXcom.DOWNLOAD_ERROR_URL+ "/" +id+"?tenantId="+tenantId);
- String headers = (String) result.get("header");
- String[] columns = headers.split(",");
- String headersUsingTab = StringUtils.join(columns, "\t");
- strings.add(headersUsingTab);
- strings.add("\n");
- List<JSONObject> data = new ArrayList<JSONObject>();
- data = (List<JSONObject>) result.get("data");
- for(JSONObject obj : data){
- for(int i=0; i<columns.length;i++){
- strings.add( obj.get(columns[i]).toString());
- if(i==columns.length-1)
- strings.add( "\n");
- else
- strings.add( "\t");
- }
- }
- for (String s : strings) {
- output.write(s.getBytes());
- }
- output.flush();
- output.close();
- fc.responseComplete();
- } catch (Exception e) {
- log.error(e.getMessage(), e);
- }
- }
- public ViewUploaderLazyModel getModel() {
- return model;
- }
- public void setModel(ViewUploaderLazyModel model) {
- this.model = model;
- }
- public StreamedContent getFile() {
- log.debug(">>>>>>>>>>>>>>>>>>>>>>> GET FILE");
- setMessageUpload("none");
- String date = new SimpleDateFormat("MM_dd_yyyy").format(DateUtil.convertToDate(DateUtil.dateNow()));
- String fileName = "SellPriceProduct"+date+".csv";
- List<String[]> csvDataList = getCsvDataToWrite();
- try {
- InputStream inputStream = writeToCsv(csvDataList);
- file = new DefaultStreamedContent(inputStream, "text/csv", fileName);
- } catch (Exception e) {
- MessageHelper.displayError(e.toString());
- }
- return file;
- }
- private List<String[]> getCsvDataToWrite(){
- List<String[]> outputList = new ArrayList<String[]>();
- // build header
- String[] header = {
- "product_code","ou_code","date_from (YYYYMMDD)","date_to (YYYYMMDD)","curr_code","gross_sell_price","min_sell_price","price_level"
- };
- outputList.add(header);
- return outputList;
- }
- private InputStream writeToCsv(List<String[]> data) throws IOException{
- StringWriter writer = new StringWriter();
- CSVWriter csvWriter = new CSVWriter(writer,',', '"'); // \u0000Tidak perlu pakai quote character
- csvWriter.writeAll(data);
- csvWriter.close();
- return new ByteArrayInputStream(writer.toString().getBytes());
- }
- public void setFile(StreamedContent file) {
- this.file = file;
- }
- public String getParamaterText() {
- return paramaterText;
- }
- public void setParamaterText(String paramaterText) {
- this.paramaterText = paramaterText;
- }
- public String getMessageUpload() {
- return messageUpload;
- }
- public void setMessageUpload(String messageUpload) {
- this.messageUpload = messageUpload;
- }
- public void ouChanged(AjaxBehaviorEvent evnt) {
- log.debug(" INIT ouChanged ");
- }
- public void makeParameter() {
- log.debug(" MAKE PARAMETER ");
- }
- public String getDataUploaderUrl() {
- return dataUploaderUrl;
- }
- public void setDataUploaderUrl(String dataUploaderUrl) {
- this.dataUploaderUrl = dataUploaderUrl;
- }
- @Override
- public String searchTaskName() {
- // TODO Auto-generated method stub
- return null;
- }
- @Override
- public JSONObject getJsonForSearch() {
- // TODO Auto-generated method stub
- return null;
- }
- @Override
- public void afterSearch(JSONObject result, boolean isOk) {
- // TODO Auto-generated method stub
- }
- }
Add Comment
Please, Sign In to add comment