summaryrefslogtreecommitdiffstats
path: root/models/exporter.js
diff options
context:
space:
mode:
authorBryan Mutai <mutaiwork@gmail.com>2020-05-26 22:56:47 +0300
committerBryan Mutai <mutaiwork@gmail.com>2020-05-27 01:23:31 +0300
commit8c149da9e920de3c1c15119030d24b0752769cfc (patch)
tree9f7fe1dd46d2dda6fc6e3f3d57ad2ba4f96e06be /models/exporter.js
parent18eafe2fec9368c551a944ecff3354d4339b2c11 (diff)
downloadwekan-8c149da9e920de3c1c15119030d24b0752769cfc.tar.gz
wekan-8c149da9e920de3c1c15119030d24b0752769cfc.tar.bz2
wekan-8c149da9e920de3c1c15119030d24b0752769cfc.zip
Fix vote export to CSV/TSV & export currency custom field.
Diffstat (limited to 'models/exporter.js')
-rw-r--r--models/exporter.js49
1 files changed, 27 insertions, 22 deletions
diff --git a/models/exporter.js b/models/exporter.js
index 39e8aeca..b6188ece 100644
--- a/models/exporter.js
+++ b/models/exporter.js
@@ -37,7 +37,7 @@ export class Exporter {
result.cards = Cards.find(byBoardNoLinked, noBoardId).fetch();
result.swimlanes = Swimlanes.find(byBoard, noBoardId).fetch();
result.customFields = CustomFields.find(
- { boardIds: this.boardId },
+ { boardIds: this._boardId },
{ fields: { boardIds: 0 } },
).fetch();
result.comments = CardComments.find(byBoard, noBoardId).fetch();
@@ -217,7 +217,6 @@ export class Exporter {
const customFieldMap = {};
let i = 0;
result.customFields.forEach(customField => {
- customFieldMap[customField._id] = i;
customFieldMap[customField._id] = {
position: i,
type: customField.type,
@@ -225,11 +224,15 @@ export class Exporter {
if (customField.type === 'dropdown') {
let options = '';
customField.settings.dropdownItems.forEach(item => {
- options = options === '' ? item.name : `/${options + item.name}`;
+ options = options === '' ? item.name : `${`${options}/${item.name}`}`;
});
columnHeaders.push(
`CustomField-${customField.name}-${customField.type}-${options}`,
);
+ } else if (customField.type === 'currency') {
+ columnHeaders.push(
+ `CustomField-${customField.name}-${customField.type}-${customField.settings.currencyCode}`,
+ );
} else {
columnHeaders.push(
`CustomField-${customField.name}-${customField.type}`,
@@ -322,7 +325,7 @@ export class Exporter {
currentRow.push(
card.dateLastActivity ? moment(card.dateLastActivity).format() : ' ',
);
- if (card.vote.question !== undefined) {
+ if (card.vote && card.vote.question !== '') {
let positiveVoters = '';
let negativeVoters = '';
card.vote.positive.forEach(userId => {
@@ -350,23 +353,25 @@ export class Exporter {
//Custom fields
const customFieldValuesToPush = new Array(result.customFields.length);
card.customFields.forEach(field => {
- if (customFieldMap[field._id].type === 'date') {
- customFieldValuesToPush[customFieldMap[field._id].position] = moment(
- field.value,
- ).format();
- } else if (customFieldMap[field._id].type === 'dropdown') {
- const dropdownOptions = result.customFields.find(
- ({ _id }) => _id === field._id,
- ).settings.dropdownItems;
- const fieldValue = dropdownOptions.find(
- ({ _id }) => _id === field.value,
- ).name;
- customFieldValuesToPush[
- customFieldMap[field._id].position
- ] = fieldValue;
- } else {
- customFieldValuesToPush[customFieldMap[field._id].position] =
- field.value;
+ if (field.value !== null) {
+ if (customFieldMap[field._id].type === 'date') {
+ customFieldValuesToPush[
+ customFieldMap[field._id].position
+ ] = moment(field.value).format();
+ } else if (customFieldMap[field._id].type === 'dropdown') {
+ const dropdownOptions = result.customFields.find(
+ ({ _id }) => _id === field._id,
+ ).settings.dropdownItems;
+ const fieldValue = dropdownOptions.find(
+ ({ _id }) => _id === field.value,
+ ).name;
+ customFieldValuesToPush[
+ customFieldMap[field._id].position
+ ] = fieldValue;
+ } else {
+ customFieldValuesToPush[customFieldMap[field._id].position] =
+ field.value;
+ }
}
});
for (
@@ -383,7 +388,7 @@ export class Exporter {
stringifier.write(currentRow);
});
stringifier.end();
- return cardRows;
+ return cardRows[0];
}
canExport(user) {