Time Logs 用 CodeX スクリプト

Time Logs 用 CodeX スクリプト

お知らせ：当社は、お客様により充実したサポート情報を迅速に提供するため、本ページのコンテンツは機械翻訳を用いて日本語に翻訳しています。正確かつ最新のサポート情報をご覧いただくには、本内容の英語版を参照してください。

Zoho ProjectsのCodeXスクリプトは、特定のルールや検証を適用するための高度な条件ロジックスクリプトです。ユーザーは、工数を作成、更新、ブロック、移行できる方法やタイミングを制御できます。

使用例

タスクの作業時間に基づく工数の制限

タスクに割り当てられた合計作業時間を超える工数を登録できないようにします。作業時間が割り当てられていないタスクへの工数登録もブロックされます。
コード
  1. function main() {
  2. try {
  3. let url = 'https://projects.zoho.com';
  4. let records = current.record;
  5. let violations = [];

  7. function parseToMinutes(s) {
  8. if (!s) return 0;
  9. let str = String(s);
  10. if (str.indexOf(':') === -1) return (parseFloat(str) || 0) * 60;
  11. let p = str.split(':');
  12. return (parseInt(p[0], 10) || 0) * 60 + (parseInt(p[1], 10) || 0);
  13. }

  15. function formatMinutes(m) {
  16. let h = Math.floor(m / 60);
  17. let mins = m % 60;
  18. return h + ':' + (mins < 10 ? '0' : '') + mins;
  19. }

  21. let taskLogs = [];
  22. let projectTaskMap = {};

  24. for (let i = 0; i < records.length; i++) {
  25. let record = records[i];
  26. let linked = record.module_detail;
  27. if (!linked || linked.name !== 'Task') continue;

  29. taskLogs.push(record);
  30. let projId = String(record.project_id);
  31. if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  32. projectTaskMap[projId][linked.id] = true;
  33. }

  35. if (taskLogs.length === 0) return;

  37. let allTasks = [];
  38. let projectIds = Object.keys(projectTaskMap);

  40. if (projectIds.length === 1) {
  41. let projId = projectIds[0];
  42. let taskIds = Object.keys(projectTaskMap[projId]);
  43. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: taskIds }], pattern: '1' });
  44. let req = new HttpRequest();
  45. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  46. req.method('GET');
  47. req.connection('zprojects');
  48. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  49. } else {
  50. let uniqueMap = {};
  51. for (let i = 0; i < projectIds.length; i++) {
  52. let ids = Object.keys(projectTaskMap[projectIds[i]]);
  53. for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  54. }
  55. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: Object.keys(uniqueMap) }], pattern: '1' });
  56. let req = new HttpRequest();
  57. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  58. req.method('GET');
  59. req.connection('zprojects');
  60. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  62. let returnedIds = {};
  63. for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  65. let missingByProject = {};
  66. for (let i = 0; i < projectIds.length; i++) {
  67. let projId = projectIds[i];
  68. let taskIds = Object.keys(projectTaskMap[projId]);
  69. for (let j = 0; j < taskIds.length; j++) {
  70. if (!returnedIds[taskIds[j]]) {
  71. if (!missingByProject[projId]) missingByProject[projId] = [];
  72. missingByProject[projId].push(taskIds[j]);
  73. }
  74. }
  75. }

  77. let missingProjIds = Object.keys(missingByProject);
  78. for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  79. let projId = missingProjIds[i];
  80. let mFilter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: missingByProject[projId] }], pattern: '1' });
  81. let mReq = new HttpRequest();
  82. mReq.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  83. mReq.method('GET');
  84. mReq.connection('zprojects');
  85. let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  86. for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  87. }
  88. }

  90. let taskWorkMap = {};
  91. let taskNameMap = {};
  92. for (let i = 0; i < allTasks.length; i++) {
  93. let task = allTasks[i];
  94. let id = String(task.id);
  95. taskNameMap[id] = task.name;
  96. taskWorkMap[id] = {
  97. totalWork: parseToMinutes(task.owners_and_work.total_work),
  98. alreadyLogged: parseToMinutes(task.log_hours.total_hours)
  99. };
  100. }

  102. let batchPerTask = {};
  103. for (let i = 0; i < taskLogs.length; i++) {
  104. let record = taskLogs[i];
  105. let taskId = String(record.module_detail.id);
  106. if (!batchPerTask[taskId]) batchPerTask[taskId] = { totalMinutes: 0, logIds: [] };
  107. batchPerTask[taskId].totalMinutes += parseToMinutes(record.log_hour);
  108. batchPerTask[taskId].logIds.push(record.id);
  109. }

  111. let batchTaskIds = Object.keys(batchPerTask);
  112. for (let i = 0; i < batchTaskIds.length; i++) {
  113. let taskId = batchTaskIds[i];
  114. let info = taskWorkMap[taskId];
  115. let batch = batchPerTask[taskId];
  116. if (!info) continue;

  118. if (info.totalWork === 0) {
  119. violations.push({ taskId: taskId, taskName: taskNameMap[taskId], totalWork: '00:00', reason: '作業時間が割り当てられていません' });
  120. continue;
  121. }

  123. let totalAfterLog = info.alreadyLogged + batch.totalMinutes;
  124. if (totalAfterLog > info.totalWork) {
  125. violations.push({ taskId: taskId, taskName: taskNameMap[taskId], totalWork: formatMinutes(info.totalWork), alreadyLogged: formatMinutes(info.alreadyLogged), newBatch: formatMinutes(batch.totalMinutes), reason: '作業時間を超過します' });
  126. }
  127. }

  129. if (violations.length > 0) {
  130. throw new ScriptError(JSON.stringify({ violations: violations }));
  131. }
  132. } catch (err) {
  133. throw new ScriptError(err);
  134. }
  135. }

未割り当てのタスクまたは課題に対する工数記録の制限

担当者が1人以上割り当てられているタスクまたは課題にのみ、工数を記録できるようにします。担当者が割り当てられていない作業項目への工数記録は拒否されます。
コード
  1. function main() {
  2. try {
  3. let url = 'https://projects.zoho.com';
  4. let records = current.record;
  5. let violations = [];

  7. let taskLogs = [];
  8. let projectTaskMap = {};

  10. for (let i = 0; i < records.length; i++) {
  11. let record = records[i];
  12. let linked = record.module_detail;
  13. if (!linked || linked.name !== 'Task') continue;

  15. taskLogs.push(record);
  16. let projId = String(record.project_id);
  17. if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  18. projectTaskMap[projId][linked.id] = true;
  19. }

  21. if (taskLogs.length === 0) return;

  23. let allTasks = [];
  24. let projectIds = Object.keys(projectTaskMap);

  26. if (projectIds.length === 1) {
  27. let projId = projectIds[0];
  28. let taskIds = Object.keys(projectTaskMap[projId]);
  29. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: taskIds }], pattern: '1' });
  30. let req = new HttpRequest();
  31. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  32. req.method('GET');
  33. req.connection('zprojects');
  34. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  35. } else {
  36. let uniqueMap = {};
  37. for (let i = 0; i < projectIds.length; i++) {
  38. let ids = Object.keys(projectTaskMap[projectIds[i]]);
  39. for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  40. }
  41. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: Object.keys(uniqueMap) }], pattern: '1' });
  42. let req = new HttpRequest();
  43. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  44. req.method('GET');
  45. req.connection('zprojects');
  46. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  48. let returnedIds = {};
  49. for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  51. let missingByProject = {};
  52. for (let i = 0; i < projectIds.length; i++) {
  53. let projId = projectIds[i];
  54. let taskIds = Object.keys(projectTaskMap[projId]);
  55. for (let j = 0; j < taskIds.length; j++) {
  56. if (!returnedIds[taskIds[j]]) {
  57. if (!missingByProject[projId]) missingByProject[projId] = [];
  58. missingByProject[projId].push(taskIds[j]);
  59. }
  60. }
  61. }

  63. let missingProjIds = Object.keys(missingByProject);
  64. for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  65. let projId = missingProjIds[i];
  66. let mFilter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: missingByProject[projId] }], pattern: '1' });
  67. let mReq = new HttpRequest();
  68. mReq.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  69. mReq.method('GET');
  70. mReq.connection('zprojects');
  71. let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  72. for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  73. }
  74. }

  76. let taskOwnerMap = {};
  77. for (let i = 0; i < allTasks.length; i++) {
  78. let task = allTasks[i];
  79. let owners = task.owners_and_work.owners || [];
  80. let hasReal = false;
  81. for (let j = 0; j < owners.length; j++) {
  82. if (owners[j].zuid && owners[j].zuid !== 0) { hasReal = true; break; }
  83. }
  84. taskOwnerMap[String(task.id)] = hasReal;
  85. }

  87. for (let i = 0; i < taskLogs.length; i++) {
  88. let record = taskLogs[i];
  89. let taskId = String(record.module_detail.id);
  90. if (taskOwnerMap[taskId] === undefined) continue;

  92. if (!taskOwnerMap[taskId]) {
  93. violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : 'Unknown', reason: 'Task is unassigned' });
  94. }
  95. }

  97. if (violations.length > 0) {
  98. throw new ScriptError(JSON.stringify({ violations: violations }));
  99. }
  100. } catch (err) {
  101. throw new ScriptError(err);
  102. }
  103. }

週末の工数記録の制限

選択した記録日を検証し、土曜日と日曜日には工数を記録できないように制限します。
コード
  1. function main() {
  2. try {
  3. let records = current.record;
  4. let violations = [];

  6. for (let i = 0; i < records.length; i++) {
  7. let record = records[i];
  8. let logDate = record.log_date;
  9. if (!logDate) continue;

  11. let parts = logDate.split('-');
  12. let date = new Date(parseInt(parts[0]), parseInt(parts[1]) - 1, parseInt(parts[2]));
  13. let day = date.getDay();

  15. if (day === 0 || day === 6) {
  16. violations.push({ logId: record.id, logDate: logDate, user: record.user ? record.user.name : '不明', day: day === 0 ? '日曜日' : '土曜日', reason: '週末には工数を記録できません' });
  17. }
  18. }

  20. if (violations.length > 0) {
  21. throw new ScriptError(JSON.stringify({ violations: violations }));
  22. }
  23. } catch (err) {
  24. throw new ScriptError(err);
  25. }
  26. }

祝日の工数記録の制限

Zoho Peopleから祝日情報を取得し、選択した記録日を検証することで、組織の祝日に工数を入力できないようにします。
コード
  1. function main() {
  2. try {
  3. let peopleUrl = 'https://people.zoho.com';
  4. let records = current.record;
  5. let violations = [];

  7. let monthMap = {'Jan':'01','Feb':'02','Mar':'03','Apr':'04','May':'05','Jun':'06','Jul':'07','Aug':'08','Sep':'09','Oct':'10','Nov':'11','Dec':'12'};

  9. function peopleDateToISO(d) {
  10. let p = d.split('-');
  11. if (p.length !== 3) return d;
  12. return p[2] + '-' + (monthMap[p[1]] || '01') + '-' + (p[0].length === 1 ? '0' + p[0] : p[0]);
  13. }

  15. let years = {};
  16. for (let i = 0; i < records.length; i++) {
  17. if (records[i].log_date) years[records[i].log_date.substring(0, 4)] = true;
  18. }

  20. let holidaySet = {};
  21. let holidayNames = {};
  22. let yearKeys = Object.keys(years);
  23. for (let y = 0; y < yearKeys.length; y++) {
  24. let year = yearKeys[y];
  25. let req = new HttpRequest();
  26. req.url(`${peopleUrl}/people/api/leave/v2/holidays/get?from=01-Jan-${year}&to=31-Dec-${year}`);
  27. req.method('GET');
  28. req.connection('zpeople');
  29. let holidays = req.execute().asJson().statusMessage.responseText.data || [];

  31. for (let i = 0; i < holidays.length; i++) {
  32. let isoDate = peopleDateToISO(holidays[i].Date);
  33. holidaySet[isoDate] = true;
  34. holidayNames[isoDate] = holidays[i].Name;
  35. }
  36. }

  38. for (let i = 0; i < records.length; i++) {
  39. let record = records[i];
  40. let logDate = record.log_date;
  41. if (!logDate) continue;

  43. if (holidaySet[logDate]) {
  44. violations.push({ logId: record.id, logDate: logDate, user: record.user ? record.user.name : '不明', holiday: holidayNames[logDate], reason: logDate + 'は祝日です（' + holidayNames[logDate] + '）' });
  45. }
  46. }

  48. if (violations.length > 0) {
  49. throw new ScriptError(JSON.stringify({ violations: violations }));
  50. }
  51. } catch (err) {
  52. throw new ScriptError(err);
  53. }
  54. }

休暇または休業中の工数記録の制限

Zoho Peopleの休暇データを使用し、承認済みの休暇または休業日にユーザーが工数を記録できないようにします。
コード
  1. function main() {
  2. try {
  3. let peopleUrl = 'https://people.zoho.com';
  4. let records = current.record;
  5. let violations = [];

  7. let monthMap = {'Jan':'01','Feb':'02','Mar':'03','Apr':'04','May':'05','Jun':'06','Jul':'07','Aug':'08','Sep':'09','Oct':'10','Nov':'11','Dec':'12'};

  9. function peopleDateToISO(d) {
  10. let p = d.split('-');
  11. if (p.length !== 3) return d;
  12. return p[2] + '-' + (monthMap[p[1]] || '01') + '-' + (p[0].length === 1 ? '0' + p[0] : p[0]);
  13. }

  15. function isoToPeopleDate(d) {
  16. let p = d.split('-');
  17. let m = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
  18. return p[2] + '-' + m[parseInt(p[1]) - 1] + '-' + p[0];
  19. }

  21. let minDate = null;
  22. let maxDate = null;
  23. let uniqueUsers = {};

  25. for (let i = 0; i < records.length; i++) {
  26. let record = records[i];
  27. let logDate = record.log_date;
  28. if (logDate) {
  29. if (!minDate || logDate < minDate) minDate = logDate;
  30. if (!maxDate || logDate > maxDate) maxDate = logDate;
  31. }
  32. if (record.user && record.user.zuid) {
  33. uniqueUsers[String(record.user.zuid)] = true;
  34. }
  35. }

  37. if (!minDate) return;

  39. let req = new HttpRequest();
  40. req.url(`${peopleUrl}/api/v2/leavetracker/leaves/records?from=${encodeURIComponent(isoToPeopleDate(minDate))}&to=${encodeURIComponent(isoToPeopleDate(maxDate))}`);
  41. req.method('GET');
  42. req.connection('zpeople');
  43. let leaveRecordsMap = req.execute().asJson().statusMessage.responseText.records || {};
  44. let leaveIds = Object.keys(leaveRecordsMap);

  46. let userLeaveDayMap = {};
  47. for (let i = 0; i < leaveIds.length; i++) {
  48. let lr = leaveRecordsMap[leaveIds[i]];
  49. let zuid = String(lr.ZUID);
  50. if (!uniqueUsers[zuid]) continue;

  52. let days = lr.Days || {};
  53. let dayKeys = Object.keys(days);
  54. for (let d = 0; d < dayKeys.length; d++) {
  55. let leaveCount = parseFloat(days[dayKeys[d]].LeaveCount) || 0;
  56. if (leaveCount <= 0) continue;
  57. let isoDate = peopleDateToISO(dayKeys[d]);
  58. if (!userLeaveDayMap[zuid]) userLeaveDayMap[zuid] = {};
  59. userLeaveDayMap[zuid][isoDate] = { leaveType: lr.Leavetype || '', status: lr.ApprovalStatus || '' };
  60. }
  61. }

  63. for (let i = 0; i < records.length; i++) {
  64. let record = records[i];
  65. let logDate = record.log_date;
  66. if (!logDate) continue;
  67. let recordZuid = record.user ? String(record.user.zuid) : '';
  68. if (!recordZuid) continue;

  70. let userDays = userLeaveDayMap[recordZuid];
  71. if (!userDays) continue;
  72. let dayLeave = userDays[logDate];
  73. if (!dayLeave) continue;

  75. violations.push({ logId: record.id, logDate: logDate, user: record.user.name, leaveType: dayLeave.leaveType, status: dayLeave.status, reason: 'User is on ' + dayLeave.leaveType + ' (' + dayLeave.status + ')' });
  76. }

  78. if (violations.length > 0) {
  79. throw new ScriptError(JSON.stringify({ violations: violations }));
  80. }
  81. } catch (err) {
  82. throw new ScriptError(err);
  83. }
  84. }

タスクまたは課題の担当者のみに工数記録を許可

タスクまたは課題の担当者として割り当てられたユーザーのみが、そのタスクまたは課題に工数を記録できるようにします。担当者が割り当てられていないタスクや、権限のないユーザーによる工数記録はブロックされます。
コード
  1. function main() {
  2. try {

  4. let url = 'https://projects.zoho.com';
  5. let records = current.record;
  6. let violations = [];

  8. let taskLogs = [];
  9. let projectTaskMap = {};

  11. for (let i = 0; i < records.length; i++) {
  12. let record = records[i];
  13. let linked = record.module_detail;
  14. if (!linked || linked.name === 'general') continue;

  16. taskLogs.push(record);
  17. let projId = String(record.project_id);
  18. if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  19. projectTaskMap[projId][linked.id] = true;
  20. }

  22. if (taskLogs.length === 0) return;

  24. let allTasks = [];
  25. let projectIds = Object.keys(projectTaskMap);

  27. if (projectIds.length === 1) {
  28. let projId = projectIds[0];
  29. let taskIds = Object.keys(projectTaskMap[projId]);
  30. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: taskIds }], pattern: '1' });
  31. let req = new HttpRequest();
  32. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  33. req.method('GET');
  34. req.connection('zprojects');
  35. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  36. } else {
  37. let uniqueMap = {};
  38. for (let i = 0; i < projectIds.length; i++) {
  39. let ids = Object.keys(projectTaskMap[projectIds[i]]);
  40. for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  41. }
  42. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: Object.keys(uniqueMap) }], pattern: '1' });
  43. let req = new HttpRequest();
  44. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  45. req.method('GET');
  46. req.connection('zprojects');
  47. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  49. let returnedIds = {};
  50. for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  52. let missingByProject = {};
  53. for (let i = 0; i < projectIds.length; i++) {
  54. let projId = projectIds[i];
  55. let taskIds = Object.keys(projectTaskMap[projId]);
  56. for (let j = 0; j < taskIds.length; j++) {
  57. if (!returnedIds[taskIds[j]]) {
  58. if (!missingByProject[projId]) missingByProject[projId] = [];
  59. missingByProject[projId].push(taskIds[j]);
  60. }
  61. }
  62. }

  64. let missingProjIds = Object.keys(missingByProject);
  65. for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  66. let projId = missingProjIds[i];
  67. let mFilter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: missingByProject[projId] }], pattern: '1' });
  68. let mReq = new HttpRequest();
  69. mReq.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  70. mReq.method('GET');
  71. mReq.connection('zprojects');
  72. let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  73. for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  74. }
  75. }

  77. let taskOwnerMap = {};
  78. for (let i = 0; i < allTasks.length; i++) {
  79. let task = allTasks[i];
  80. let owners = task.owners_and_work.owners || [];
  81. let realZpuids = [];
  82. for (let j = 0; j < owners.length; j++) {
  83. if (owners[j].zuid && owners[j].zuid !== 0) realZpuids.push(String(owners[j].zpuid));
  84. }
  85. taskOwnerMap[String(task.id)] = realZpuids;
  86. }

  88. for (let i = 0; i < taskLogs.length; i++) {
  89. let record = taskLogs[i];
  90. let taskId = String(record.module_detail.id);
  91. let userZpuid = record.user ? String(record.user.id) : String(current.user.id);
  92. let ownerZpuids = taskOwnerMap[taskId];

  94. if (!ownerZpuids) continue;

  96. if (ownerZpuids.length === 0) {
  97. violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : 'Unknown', reason: 'Task is unassigned' });
  98. } else if (ownerZpuids.indexOf(userZpuid) === -1) {
  99. violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : 'Unknown', reason: 'User is not the task owner' });
  100. }
  101. }

  103. if (violations.length > 0) {
  104. throw new ScriptError(JSON.stringify({ violations: violations }));
  105. }
  106. } catch (err) {
  107. throw new ScriptError(err);
  108. }
  109. }

レビュー中のタスクへの工数登録の制限

ステータスがレビュー中のタスクには工数を登録できないようにし、実際に作業を行っている段階でのみ工数が登録されるようにします。
コード
  1. function main() {
  2. try {
  3.         
  4. let url = ' https://projects.zoho.com';
  5. let records = current.record;
  6. let violations = [];

  8. let taskLogs = [];
  9. let projectTaskMap = {};

  11. for (let i = 0; i < records.length; i++) {
  12. let record = records[i];
  13. let linked = record.module_detail;
  14. if (!linked || linked.name !== 'Task') continue;

  16. taskLogs.push(record);
  17. let projId = String(record.project_id);
  18. if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  19. projectTaskMap[projId][linked.id] = true;
  20. }

  22. if (taskLogs.length === 0) return;

  24. let allTasks = [];
  25. let projectIds = Object.keys(projectTaskMap);

  27. if (projectIds.length === 1) {
  28. let projId = projectIds[0];
  29. let taskIds = Object.keys(projectTaskMap[projId]);
  30. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: taskIds }], pattern: '1' });
  31. let req = new HttpRequest();
  32. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  33. req.method('GET');
  34. req.connection('zprojects');
  35. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  36. } else {
  37. let uniqueMap = {};
  38. for (let i = 0; i < projectIds.length; i++) {
  39. let ids = Object.keys(projectTaskMap[projectIds[i]]);
  40. for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  41. }
  42. let filter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: Object.keys(uniqueMap) }], pattern: '1' });
  43. let req = new HttpRequest();
  44. req.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  45. req.method('GET');
  46. req.connection('zprojects');
  47. allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  49. let returnedIds = {};
  50. for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  52. let missingByProject = {};
  53. for (let i = 0; i < projectIds.length; i++) {
  54. let projId = projectIds[i];
  55. let taskIds = Object.keys(projectTaskMap[projId]);
  56. for (let j = 0; j < taskIds.length; j++) {
  57. if (!returnedIds[taskIds[j]]) {
  58. if (!missingByProject[projId]) missingByProject[projId] = [];
  59. missingByProject[projId].push(taskIds[j]);
  60. }
  61. }
  62. }

  64. let missingProjIds = Object.keys(missingByProject);
  65. for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  66. let projId = missingProjIds[i];
  67. let mFilter = JSON.stringify({ criteria: [{ field_name: 'id', criteria_condition: 'contains', value: missingByProject[projId] }], pattern: '1' });
  68. let mReq = new HttpRequest();
  69. mReq.url(`${url}/api/v3/portal/${##PROTECTED_0##.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  70. mReq.method('GET');
  71. mReq.connection('zprojects');
  72. let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  73. for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  74. }
  75. }

  77. let taskStatusMap = {};
  78. let taskNameMap = {};
  79. for (let i = 0; i < allTasks.length; i++) {
  80. let task = allTasks[i];
  81. let id = String(task.id);
  82. taskStatusMap[id] = task.status;
  83. taskNameMap[id] = task.name;
  84. }

  86. for (let i = 0; i < taskLogs.length; i++) {
  87. let record = taskLogs[i];
  88. let taskId = String(record.module_detail.id);
  89. let status = taskStatusMap[taskId];
  90. if (!status) continue;

  92. if (status.name === 'In Review') {
  93. violations.push({ logId: record.id, taskId: taskId, taskName: taskNameMap[taskId], status: status.name, reason: 'Task is in review' });
  94. }
  95. }

  97. if (violations.length > 0) {
  98. throw new ScriptError(JSON.stringify({ violations: violations }));
  99. }
  100. } catch (err) {
  101. throw new ScriptError(err);
  102. }
  103. }

一般工数の登録制限

タスクや課題に関連付けられていない一般工数の登録を禁止し、すべての工数が作業項目に関連付けられるようにします。
コード
  1. function main() {
  2. try {
  3. let records = current.record;
  4. let violations = [];

  6. for (let i = 0; i < records.length; i++) {
  7. let record = records[i];
  8. let linked = record.module_detail;

  10. if (linked && linked.name === 'general') {
  11. violations.push({ logId: record.id, user: record.user ? record.user.name : '不明', reason: '一般のタイムログは許可されていません。タスクまたは課題に関連付ける必要があります。' });
  12. }
  13. }

  15. if (violations.length > 0) {
  16. throw new ScriptError(JSON.stringify({ violations: violations }));
  17. }
  18. } catch (err) {
  19. throw new ScriptError(err);
  20. }
  21. }

時間記録を当日に制限

当日のみ時間を記録できるようにします。このスクリプトにより、過去の日付と未来の日付の時間記録がいずれもブロックされます。
コード
  1. function main() {
  2. try {
  3. let records = current.record;
  4. let violations = [];

  6. let now = new Date();
  7. let todayStr = now.getFullYear() + '-' +
  8. (now.getMonth() + 1 < 10 ? '0' : '') + (now.getMonth() + 1) + '-' +
  9. (now.getDate() < 10 ? '0' : '') + now.getDate();

  11. for (let i = 0; i < records.length; i++) {
  12. let record = records[i];
  13. let logDate = record.log_date;
  14. if (!logDate) continue;

  16. if (logDate !== todayStr) {
  17. violations.push({ logId: record.id, logDate: logDate, today: todayStr, user: record.user ? record.user.name : '不明', reason: logDate < todayStr ? '過去の日付には時間を記録できません' : '未来の日付には時間を記録できません' });
  18. }
  19. }

  21. if (violations.length > 0) {
  22. throw new ScriptError(JSON.stringify({ violations: violations }));
  23. }
  24. } catch (err) {
  25. throw new ScriptError(err);
  26. }
  27. }

タスクへの時間記録の制限

ユーザーがタスクに時間を記録できないようにします。時間の記録を課題または一般ログに対してのみ許可する場合に使用できます。
コード
  1. function main() {
  2. try {
  3. let records = current.record;
  4. let violations = [];

  6. for (let i = 0; i < records.length; i++) {
  7. let record = records[i];
  8. let linked = record.module_detail;

  10. if (linked && linked.name === 'Task') {
  11. violations.push({ logId: record.id, user: record.user ? record.user.name : '不明', reason: 'タスクに時間を記録することはできません' });
  12. }
  13. }

  15. if (violations.length > 0) {
  16. throw new ScriptError(JSON.stringify({ violations: violations }));
  17. }
  18. } catch (err) {
  19. throw new ScriptError(err);
  20. }
  21. }