समय लॉग के लिए CodeX Scripts

समय लॉग के लिए CodeX Scripts

इस पृष्ठ का अनुवाद AI उपकरणों का उपयोग करके किया गया है और इसमें त्रुटियाँ हो सकती हैं। सबसे सटीक और नवीनतम विवरण के लिए, कृपया मूल अंग्रेज़ी संस्करण देखें।
Zoho Projects में CodeX Scripts उन्नत शर्तीय तर्क स्क्रिप्ट हैं जो विशिष्ट नियमों और सत्यापनों को लागू करने में मदद करती हैं। उपयोगकर्ता नियंत्रित कर सकते हैं कि समय लॉग कैसे और कब बनाए जा सकते हैं, अपडेट किए जा सकते हैं, अवरुद्ध किए जा सकते हैं या स्थिति बदली जा सकती है।

Info
CodeX Scripts सभी डेटा सेंटर में समर्थित हैं सिवाय CN, JP और AE के।

उपयोग के मामले

Task के कार्य घंटों के आधार पर समय लॉग को प्रतिबंधित करें

उपयोगकर्ताओं को समय लॉग करने से प्रतिबंधित करें जो Task को आवंटित कुल कार्य घंटों से अधिक हो। यह स्क्रिप्ट उन Task के लिए लॉगिंग को भी अवरुद्ध करती है जिन्हें कोई कार्य घंटे निर्दिष्ट नहीं किए गए हैं।
कोड
  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/${current.org.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/${current.org.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/${current.org.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: "No work hours allocated" });
  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: "Would exceed work hours" });
  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. }

अनिर्दिष्ट Task या समस्याओं के लिए समय लॉग को सीमित करें

समय लॉगिंग केवल उन Task या समस्याओं के लिए अनुमति दें जिनके पास कम से कम एक स्वामी निर्दिष्ट है। अनिर्दिष्ट कार्य आइटम्स के विरुद्ध लॉग को अस्वीकार कर दिया जाता है।
कोड
  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/${current.org.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/${current.org.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/${current.org.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 : "Unknown", day: day === 0 ? "Sunday" : "Saturday", reason: "Cannot log time on weekends" });
  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 : "Unknown", holiday: holidayNames[logDate], reason: logDate + " is a holiday (" + 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. }

केवल Task या Issue के स्वामियों के लिए समय लॉग की अनुमति दें

सुनिश्चित करें कि केवल Task या Issue के स्वामी के रूप में निर्दिष्ट उपयोगकर्ता ही इसके विरुद्ध समय लॉग कर सकें। अनिर्दिष्ट Task और अनधिकृत उपयोगकर्ता को अवरुद्ध किया जाता है।
कोड
  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/${current.org.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/${current.org.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/${current.org.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 अनिर्दिष्ट है" });
  98. } else if (ownerZpuids.indexOf(userZpuid) === -1) {
  99. violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : "Unknown", reason: "उपयोगकर्ता Task के स्वामी नहीं हैं" });
  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. }

समीक्षा में Tasks के लिए समय लॉग को प्रतिबंधित करें

उपयोगकर्ताओं को उन Tasks के विरुद्ध समय लॉग करने से प्रतिबंधित करें जिनकी अवस्था है समीक्षा में, सुनिश्चित करते हुए कि कार्य केवल सक्रिय निष्पादन अवस्थाओं के दौरान लॉग किया जाता है।
कोड
  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/${current.org.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/${current.org.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/${current.org.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. }

सामान्य समय लॉग को प्रतिबंधित करें

उन सामान्य समय लॉग को ब्लॉक करें जो Task या समस्या से जुड़े नहीं हैं, यह सुनिश्चित करते हुए कि हर समय प्रविष्टि किसी कार्य आइटम से जुड़ी है।
कोड
  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 : "Unknown", reason: "General timelogs not allowed. Must link to a Task or Issue." });
  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 : "Unknown", reason: logDate < todayStr ? "Cannot log for past dates" : "Cannot log for future dates" });
  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. }

Tasks के लिए समय लॉग को प्रतिबंधित करें

उपयोगकर्ताओं को Tasks के विरुद्ध समय लॉग करने से प्रतिबंधित करें। इसका उपयोग उन परिस्थितियों में किया जा सकता है जहाँ समय लॉगिंग केवल समस्याओं या सामान्य लॉग के लिए अनुमति दी जाती है।
कोड
  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 : "Unknown", reason: "Logging time against Tasks is not allowed" });
  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. }