Example usage for com.liferay.portal.kernel.util CSVUtil encode

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.util CSVUtil encode.

Prototype

public static String encode(String s) 

Source Link

Usage

From source file:com.liferay.dynamic.data.lists.exporter.impl.DDLCSVExporter.java

License:Open Source License

@Override
protected byte[] doExport(long recordSetId, int status, int start, int end,
        OrderByComparator<DDLRecord> orderByComparator) throws Exception {

    StringBundler sb = new StringBundler();

    DDLRecordSet recordSet = _ddlRecordSetService.getRecordSet(recordSetId);

    DDMStructure ddmStructure = recordSet.getDDMStructure();

    List<DDMFormField> ddmFormFields = getDDMFormFields(ddmStructure);

    for (DDMFormField ddmFormField : ddmFormFields) {
        LocalizedValue label = ddmFormField.getLabel();

        sb.append(CSVUtil.encode(label.getString(getLocale())));

        sb.append(CharPool.COMMA);/*from w  ww. j av a  2  s.c o  m*/
    }

    sb.append(LanguageUtil.get(getLocale(), "status"));
    sb.append(StringPool.NEW_LINE);

    List<DDLRecord> records = _ddlRecordLocalService.getRecords(recordSetId, status, start, end,
            orderByComparator);

    Iterator<DDLRecord> iterator = records.iterator();

    while (iterator.hasNext()) {
        DDLRecord record = iterator.next();

        DDLRecordVersion recordVersion = record.getRecordVersion();

        DDMFormValues ddmFormValues = _storageEngine.getDDMFormValues(recordVersion.getDDMStorageId());

        Fields fields = _ddmFormValuesToFieldsConverter.convert(ddmStructure, ddmFormValues);

        for (DDMFormField ddmFormField : ddmFormFields) {
            String name = ddmFormField.getName();
            String value = StringPool.BLANK;

            if (fields.contains(name)) {
                Field field = fields.get(name);

                value = field.getRenderedValue(getLocale());
            }

            sb.append(CSVUtil.encode(value));
            sb.append(CharPool.COMMA);
        }

        sb.append(getStatusMessage(recordVersion.getStatus()));

        if (iterator.hasNext()) {
            sb.append(StringPool.NEW_LINE);
        }
    }

    String csv = sb.toString();

    return csv.getBytes();
}

---

From source file:com.liferay.dynamic.data.lists.internal.exporter.DDLCSVExporter.java

License:Open Source License

@Override
protected byte[] doExport(long recordSetId, int status, int start, int end,
        OrderByComparator<DDLRecord> orderByComparator) throws Exception {

    StringBundler sb = new StringBundler();

    DDLRecordSet recordSet = _ddlRecordSetService.getRecordSet(recordSetId);

    Map<String, DDMFormField> ddmFormFields = getDistinctFields(recordSetId);

    Locale locale = getLocale();//from   w w  w . jav a 2s  .c  om

    for (DDMFormField ddmFormField : ddmFormFields.values()) {
        LocalizedValue label = ddmFormField.getLabel();

        sb.append(CSVUtil.encode(label.getString(locale)));

        sb.append(CharPool.COMMA);
    }

    sb.append(LanguageUtil.get(locale, "status"));
    sb.append(CharPool.COMMA);
    sb.append(LanguageUtil.get(locale, "modified-date"));
    sb.append(CharPool.COMMA);
    sb.append(LanguageUtil.get(locale, "author"));
    sb.append(StringPool.NEW_LINE);

    List<DDLRecord> records = _ddlRecordLocalService.getRecords(recordSetId, status, start, end,
            orderByComparator);

    Iterator<DDLRecord> iterator = records.iterator();

    DateTimeFormatter dateTimeFormatter = getDateTimeFormatter();

    while (iterator.hasNext()) {
        DDLRecord record = iterator.next();

        DDLRecordVersion recordVersion = record.getRecordVersion();

        DDMFormValues ddmFormValues = _storageEngine.getDDMFormValues(recordVersion.getDDMStorageId());

        Map<String, DDMFormFieldRenderedValue> values = getRenderedValues(recordSet.getScope(),
                ddmFormFields.values(), ddmFormValues);

        for (Map.Entry<String, DDMFormField> entry : ddmFormFields.entrySet()) {

            if (values.containsKey(entry.getKey())) {
                DDMFormFieldRenderedValue ddmFormFieldRenderedValue = values.get(entry.getKey());

                sb.append(CSVUtil.encode(ddmFormFieldRenderedValue.getValue()));
            } else {
                sb.append(StringPool.BLANK);
            }

            sb.append(CharPool.COMMA);
        }

        sb.append(getStatusMessage(recordVersion.getStatus()));

        sb.append(CharPool.COMMA);

        sb.append(formatDate(recordVersion.getStatusDate(), dateTimeFormatter));

        sb.append(CharPool.COMMA);

        sb.append(CSVUtil.encode(recordVersion.getUserName()));

        if (iterator.hasNext()) {
            sb.append(StringPool.NEW_LINE);
        }
    }

    String csv = sb.toString();

    return csv.getBytes();
}

---

From source file:com.liferay.dynamic.data.mapping.io.internal.exporter.DDMFormCSVExporter.java

License:Open Source License

@Override
protected byte[] doExport(long formInstanceId, int status, int start, int end,
        OrderByComparator<DDMFormInstanceRecord> orderByComparator) throws Exception {

    StringBundler sb = new StringBundler();

    Map<String, DDMFormField> ddmFormFields = getDistinctFields(formInstanceId);

    Locale locale = getLocale();// www . j a  v a2  s .c  o m

    for (DDMFormField ddmFormField : ddmFormFields.values()) {
        LocalizedValue label = ddmFormField.getLabel();

        sb.append(CSVUtil.encode(label.getString(locale)));

        sb.append(CharPool.COMMA);
    }

    sb.append(LanguageUtil.get(locale, "status"));
    sb.append(CharPool.COMMA);
    sb.append(LanguageUtil.get(locale, "modified-date"));
    sb.append(CharPool.COMMA);
    sb.append(LanguageUtil.get(locale, "author"));
    sb.append(StringPool.NEW_LINE);

    List<DDMFormInstanceRecord> formInstanceRecords = _ddmFormInstanceRecordLocalService
            .getFormInstanceRecords(formInstanceId, status, start, end, orderByComparator);

    Iterator<DDMFormInstanceRecord> iterator = formInstanceRecords.iterator();

    DateTimeFormatter dateTimeFormatter = getDateTimeFormatter();

    while (iterator.hasNext()) {
        DDMFormInstanceRecord record = iterator.next();

        DDMFormInstanceRecordVersion recordVersion = record.getFormInstanceRecordVersion();

        DDMFormValues ddmFormValues = _storageEngine.getDDMFormValues(recordVersion.getStorageId());

        Map<String, DDMFormFieldRenderedValue> values = getRenderedValues(ddmFormFields.values(),
                ddmFormValues);

        for (Map.Entry<String, DDMFormField> entry : ddmFormFields.entrySet()) {

            if (values.containsKey(entry.getKey())) {
                DDMFormFieldRenderedValue ddmFormFieldRenderedValue = values.get(entry.getKey());

                sb.append(CSVUtil.encode(ddmFormFieldRenderedValue.getValue()));
            } else {
                sb.append(StringPool.BLANK);
            }

            sb.append(CharPool.COMMA);
        }

        sb.append(getStatusMessage(recordVersion.getStatus()));

        sb.append(CharPool.COMMA);

        sb.append(formatDate(recordVersion.getStatusDate(), dateTimeFormatter));

        sb.append(CharPool.COMMA);

        sb.append(CSVUtil.encode(recordVersion.getUserName()));

        if (iterator.hasNext()) {
            sb.append(StringPool.NEW_LINE);
        }
    }

    String csv = sb.toString();

    return csv.getBytes();
}

---

From source file:com.liferay.portlet.dynamicdatalists.util.DDLCSVExporter.java

License:Open Source License

@Override
protected byte[] doExport(long recordSetId, int status, int start, int end, OrderByComparator orderByComparator)
        throws Exception {

    DDLRecordSet recordSet = DDLRecordSetServiceUtil.getRecordSet(recordSetId);

    DDMStructure ddmStructure = recordSet.getDDMStructure();

    Map<String, Map<String, String>> fieldsMap = ddmStructure.getFieldsMap();

    StringBundler sb = new StringBundler();

    for (Map<String, String> fieldMap : fieldsMap.values()) {
        String label = fieldMap.get(FieldConstants.LABEL);

        sb.append(label);/*ww w .  ja  v  a 2 s  . c  o  m*/
        sb.append(CharPool.COMMA);
    }

    sb.setIndex(sb.index() - 1);
    sb.append(StringPool.NEW_LINE);

    List<DDLRecord> records = DDLRecordLocalServiceUtil.getRecords(recordSetId, status, start, end,
            orderByComparator);

    for (DDLRecord record : records) {
        Fields fields = record.getFields();

        for (Map<String, String> fieldMap : fieldsMap.values()) {
            String name = fieldMap.get(FieldConstants.NAME);

            Field field = fields.get(name);

            Serializable value = field.getValue();

            sb.append(CSVUtil.encode(value));
            sb.append(CharPool.COMMA);
        }

        sb.setIndex(sb.index() - 1);
        sb.append(StringPool.NEW_LINE);
    }

    String csv = sb.toString();

    return csv.getBytes();
}

---

From source file:com.liferay.portlet.usersadmin.action.ExportUsersAction.java

License:Open Source License

protected String getUserCSV(User user) {
    StringBundler sb = new StringBundler(PropsValues.USERS_EXPORT_CSV_FIELDS.length * 2);

    for (int i = 0; i < PropsValues.USERS_EXPORT_CSV_FIELDS.length; i++) {
        String field = PropsValues.USERS_EXPORT_CSV_FIELDS[i];

        if (field.equals("fullName")) {
            sb.append(CSVUtil.encode(user.getFullName()));
        } else if (field.startsWith("expando:")) {
            String attributeName = field.substring(8);

            ExpandoBridge expandoBridge = user.getExpandoBridge();

            sb.append(CSVUtil.encode(expandoBridge.getAttribute(attributeName)));
        } else {//from ww  w . ja  v a  2s .co  m
            sb.append(CSVUtil.encode(BeanPropertiesUtil.getString(user, field)));
        }

        if ((i + 1) < PropsValues.USERS_EXPORT_CSV_FIELDS.length) {
            sb.append(StringPool.COMMA);
        }
    }

    sb.append(StringPool.NEW_LINE);

    return sb.toString();
}

---

From source file:com.liferay.users.admin.web.internal.portlet.action.ExportUsersMVCResourceCommand.java

License:Open Source License

protected String getUserCSV(User user) {
    StringBundler sb = new StringBundler(PropsValues.USERS_EXPORT_CSV_FIELDS.length * 2);

    for (int i = 0; i < PropsValues.USERS_EXPORT_CSV_FIELDS.length; i++) {
        String field = PropsValues.USERS_EXPORT_CSV_FIELDS[i];

        if (field.startsWith("expando:")) {
            String attributeName = field.substring(8);

            ExpandoBridge expandoBridge = user.getExpandoBridge();

            sb.append(CSVUtil.encode(expandoBridge.getAttribute(attributeName)));
        } else if (field.contains("Date")) {
            Date date = (Date) BeanPropertiesUtil.getObject(user, field);

            if (date instanceof Timestamp) {
                date = new Date(date.getTime());
            }//from w w  w. ja  v  a2s.  com

            sb.append(CSVUtil.encode(String.valueOf(date)));
        } else if (field.equals("fullName")) {
            sb.append(CSVUtil.encode(user.getFullName()));
        } else {
            sb.append(CSVUtil.encode(BeanPropertiesUtil.getString(user, field)));
        }

        if ((i + 1) < PropsValues.USERS_EXPORT_CSV_FIELDS.length) {
            sb.append(StringPool.COMMA);
        }
    }

    sb.append(StringPool.NEW_LINE);

    return sb.toString();
}

---