Advertisement
Guest User

Untitled

a guest
Aug 17th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.42 KB | None | 0 0
  1. // use this script for z_startProposalStart.js
  2. (function() {
  3. var querystring = document.location.search;
  4. //alert("loading z_startProposalStart.js");
  5. //debugger;
  6. // testWhichPage();
  7.  
  8. load_startScript_javascript(); // added by dto 20160925
  9.  
  10. if (/nwr/i.test(querystring)) {
  11.  
  12. $("<iframe>", {
  13. id: "QBU_editform",
  14. name: "QBU_editform"
  15. })
  16. .css({
  17. display: "none"
  18. })
  19. .appendTo("body")
  20. .on("load", function() {
  21. QBbusyHide();
  22. var qbu_rid = this.contentWindow.kRid;
  23. // debugger;
  24. //alert("qbu_rid (" + qbu_rid +")");
  25. if (typeof(qbu_rid) == "undefined") {
  26. // alert("loading page");
  27. } else {
  28. // alert("In Main Module, found qbu_rid " + qbu_rid);
  29. startTask(qbu_rid);
  30. }
  31. // after all logic... go to this page...
  32.  
  33. }); // end of onLoad function
  34.  
  35. $("form[name=editform]").prop({
  36. target: "QBU_editform"
  37. });
  38. } // end of if...
  39.  
  40.  
  41.  
  42. })(); // end of main function
  43.  
  44. function load_startScript_javascript() {
  45. var url_0 = "https://fixandpaint.quickbase.com/db/bkartv25h?a=dbpage&pagename=z_include_api_functions.js";
  46. var promise0 = $.getScript(url_0);
  47. $.when(promise0).then(function() {
  48. // console.dirxml(xml);
  49. //debugger;
  50. stopDup();
  51. }); // end of when promise0
  52. } // end of load_startScript_javascript
  53.  
  54.  
  55. function testWhichPage() {
  56. var querystring = document.location.search;
  57.  
  58. if (/dlta=mog/i.test(querystring)) {
  59. //GRID EDIT PAGE ========================================
  60. alert("You are on the Grid Edit Page");
  61.  
  62. } else if (/a=er/i.test(querystring)) {
  63. //EDIT RECORD PAGE ========================================
  64. alert("You are on the Edit Record Page");
  65.  
  66. } else if (/a=API_GenAddRecordForm/i.test(querystring)) {
  67. //API_GenAddRecordForm PAGE ========================================
  68. alert("You are on the GenAddRecordForm Page!");
  69.  
  70. } else if (/GenNewRecord/i.test(querystring)) {
  71. //ADD RECORD PAGE ========================================
  72. alert("You are on the GenNewRecord Add Record Page");
  73.  
  74. } else if (/nwr/i.test(querystring)) {
  75. //ADD RECORD PAGE ========================================
  76. alert("You are on the NWR Add Record Page");
  77.  
  78. } else if (/a=dr/i.test(querystring)) {
  79. //DISPLAY RECORD PAGE
  80. alert("You are on the Display Record Page");
  81. $("img[qbu=module]").closest("td").css("background-color", "#FFFFFF");
  82.  
  83. } else if (/a=q/i.test(querystring)) {
  84. //REPORT PAGE ========================================
  85. alert("You are on the Report Listing Page");
  86.  
  87. } else if (/a=td/i.test(querystring)) {
  88. //TABLE DASHBOARD PAGE ========================================
  89. alert("You are on the Table Dashboard Page");
  90.  
  91. }
  92. if (/a=FinishEditRecord/i.test(querystring)) {
  93. //FINISH EDIT RECORD PAGE ========================================
  94. alert("You are on the Finish Edit Record Page");
  95.  
  96. } else {
  97. //OTHER PAGE ========================================
  98. alert("You are on the Some Other Page");
  99. }
  100. } // end of function testWhichPage
  101.  
  102. function test(thisPassed) {
  103. debugger;
  104. alert("in Test");
  105. var xx = thisPassed.contentWindow.kRid;
  106. alert("xx=" + xx);
  107.  
  108. }
  109.  
  110. function startTask(qbu_rid) {
  111.  
  112. var showAlerts = "N";
  113. var showAlerts2 = "N";
  114. var activity = "startProposalStart";
  115. // alert("In "+activity+ ", rid("+qbu_rid +")" );
  116. var url_0 = "https://fixandpaint.quickbase.com/db/bkartv25h?a=dbpage&pagename=z_include_api_functions.js";
  117.  
  118. var promise0 = $.getScript(url_0);
  119. $.when(promise0).then(function() {
  120. //console.dirxml(xml);
  121.  
  122. $.ajaxSetup({
  123. data: {
  124. apptoken: qbu_apptoken
  125. }
  126. });
  127.  
  128. //***********************************************************
  129. // get inputFormAssignedTask... then we can start.
  130. //***********************************************************
  131. var promise1 = $.get(projectTableId, {
  132. act: "API_DoQuery",
  133. query: "{3.EX." + qbu_rid + "}",
  134. clist: "133.390.391.371.5.496" // 5 is last modified by,
  135. });
  136.  
  137. $.when(promise1).then(function(xml) {
  138. console.dirxml(xml);
  139.  
  140. // debugger;
  141. var errcode = $("errcode", xml).text();
  142. var errtext = $("errtext", xml).text();
  143. var RelatedLead = $("related_lead", xml).text();
  144. var RelatedProject = qbu_rid;
  145. var RelatedWorkflow = $("related_workflow", xml).text();
  146. var AssignedTask = $("inputformassignedtask", xml).text();
  147. var NumAssignedTasks = $("___assigned_tasks", xml).text();
  148. var RelatedEstimator = $("last_modified_by", xml).text();
  149. var DueOnDate = $("lead___gc_bidopening", xml).text();
  150. var Status = "4";
  151. var Comment = "";
  152. if (showAlerts == "Y") {
  153. alert("in " + activity + ", AssignedTask=(" + AssignedTask + ")");
  154. }
  155. var qbu_criteria_11 = "{'20'.EX." + RelatedLead + "}AND{'6'.EX.2" + "}";
  156. var qbu_url_11 = "";
  157. qbu_url_11 += qbu_domain;
  158. qbu_url_11 += ProjectRoleID;
  159. qbu_url_11 += "?act=API_DoQuery";
  160. qbu_url_11 += "&query=" + qbu_criteria_11;
  161. qbu_url_11 += "&clist=14"; // 14 is the od of the worker role xref.
  162. qbu_url_11 += "&slist=3"; // 9 is the fid of the next task
  163. qbu_url_11 += "&apptoken=" + qbu_apptoken;
  164.  
  165. // ******************************************************
  166. // get the id of the WorkerRoleXrefID for the current person and Estimator
  167. // ******************************************************
  168.  
  169. var promise11 = $.get(qbu_url_11);
  170. $.when(promise11).then(function(xml) {
  171.  
  172. // debugger;
  173. var errcode = $("errcode", xml).text();
  174. var errtext = $("errtext", xml).text();
  175. // var RelatedEstimator = $("related_workerrolexref", xml).text();
  176.  
  177. var recordCount = $(xml).find("record").length;
  178. var ndxRecord = recordCount - 1;
  179. var record = xml.getElementsByTagName("record")[ndxRecord];
  180. var assignedPerson = $("related_workerrolexref", record).text();
  181.  
  182.  
  183.  
  184. if (showAlerts == "Y") {
  185. alert("4. errcode(" + errcode + ",\n errtext(" + errtext + ")");
  186. }
  187.  
  188. // add the estimator to the projectRole table.
  189.  
  190. // debugger;
  191.  
  192. var qbu_url_12 = "";
  193. qbu_url_12 += qbu_domain;
  194. qbu_url_12 += ProjectRoleID;
  195. qbu_url_12 += "?a=API_addRecord";
  196. qbu_url_12 += "&_fid_20=" + RelatedLead; // Related Lead
  197. qbu_url_12 += "&_fid_12=" + RelatedProject; // Related Project
  198. qbu_url_12 += "&_fid_6=2"; // Related Role for Estimator
  199. qbu_url_12 += "&_fid_14=" + assignedPerson; // Related Estimator
  200.  
  201. qbu_url_12 += "&apptoken=" + qbu_apptoken;
  202.  
  203. var promise12 = $.get(qbu_url_12);
  204. $.when(promise12).then(function(xml) {
  205. console.dirxml(xml);
  206.  
  207. // debugger;
  208. var errcode = $("errcode", xml).text();
  209. var errtext = $("errtext", xml).text();
  210. var NextTaskAsssignment = $("rid", xml).text();
  211. if (showAlerts == "Y") {
  212. alert("4. errcode(" + errcode + ",\n errtext(" + errtext + ")");
  213. }
  214.  
  215. if (AssignedTask > "0" && errcode == "0") {
  216. //alert("found AssignedTask... calling updateLeadTaskStatus_1");
  217. var AddFirstTask = "Y";
  218. var firstTaskRelatedProject = RelatedProject;
  219. var firstTaskRelatedWorkflow = RelatedWorkflow;
  220. updateLeadTaskStatus_1(AssignedTask, Status, Comment, DueOnDate, AddFirstTask, RelatedLead, firstTaskRelatedProject, firstTaskRelatedWorkflow);
  221. } else {
  222. alert("ERROR: AssignedTask not found. CAll Support. errtext (" + errtext + ")");
  223. //document.location.href = qbu_home;
  224. } // end of if RelatedWorkflow...
  225.  
  226.  
  227. }); // end of when promise12
  228. }); // end of when promise11
  229.  
  230. }); // end of when promise1
  231.  
  232. }); // end of when promise0
  233.  
  234. } // end of function startAddEstimator
  235.  
  236.  
  237.  
  238.  
  239. //*********************************************************
  240. //*********************************************************
  241. //*
  242. //* End of Script
  243. //*
  244. //*********************************************************
  245. //*********************************************************
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement