crfPortal.js 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265
  1. function print(config,msg){
  2. config.document.getElementById(config.debugId).value+="\n"+msg;
  3. }
  4. function drawForm(par){
  5. populateSourceTable(par); //populateSourceTableData
  6. let tableId="entryTable";
  7. generateTable(par,"formDiv",tableId);
  8. generateRow(par,tableId,"User");//generateTableRow
  9. populateSelectTableEntry(par,"User");
  10. }
  11. function generateQConfig(listName){
  12. let qConfig=new Object();
  13. qConfig.containerPath="TECANT/Data";
  14. qConfig.schemaName="lists";
  15. qConfig.queryName=listName;
  16. return qConfig;
  17. }
  18. function sourceVar(crfEntryName,elementId,sourceName){
  19. let f=new Object();
  20. f.masterSelectVarName=crfEntryName;
  21. f.selectId=elementId;
  22. f.inputType="innerHTML";
  23. f.sourceSelectVarName=sourceName;
  24. return f;
  25. }
  26. function getField(config, data, varName){
  27. let debug=false;
  28. if (debug) print(config, "getField");
  29. let fields=data.metaData.fields;
  30. for (f in fields){
  31. if (debug) print(config,"Checking "+f+": name "+fields[f].name+"/"+varName);
  32. if (fields[f].name!=varName) continue;
  33. return fields[f];
  34. }
  35. return null;
  36. }
  37. function generateHead(config, headDivName,divName,title){
  38. print(config,"generateHead");
  39. let tb=config.document.createElement('table');
  40. tb.className='t2';
  41. let row=tb.insertRow();
  42. let cell=config.document.createElement('th');
  43. row.appendChild(cell);
  44. cell.setAttribute("colspan","4");
  45. cell.style.fontSize="20px";
  46. cell.style.textAlign="center";
  47. let cellData=config.document.createTextNode(title);
  48. cell.appendChild(cellData);
  49. cell=row.insertCell();
  50. cell.style.fontSize="20px";
  51. let input=config.document.createElement("input");
  52. input.type="button";
  53. input.value="Show";
  54. input.id="toggle"+divName+"VisbilityButton";
  55. input.onclick=function(){toggleVisibility(config,divName,input.id)};
  56. cell.appendChild(input);
  57. config.document.getElementById(headDivName).appendChild(tb);
  58. print(config,"generateHead: Done");
  59. }
  60. function toggleVisibility(config,divName,buttonName){
  61. let x = config.document.getElementById(divName);
  62. if (x.style.display === "none") {
  63. x.style.display = "block";
  64. config.document.getElementById(buttonName).value="Hide";
  65. } else {
  66. x.style.display = "none";
  67. config.document.getElementById(buttonName).value="Show";
  68. }
  69. }
  70. function selectRowsSuccess(config,data){
  71. print(config,"Select rows on "+data.queryName+" got "+data.rows.length+" rows.");
  72. }
  73. function populateSourceTable(par){
  74. let debug=true;
  75. if (debug){
  76. print(par.config,"populateSourceTable: Starting");
  77. }
  78. let config=generateQConfig(par.source.queryName);
  79. config.schemaName=par.source.schemaName;
  80. if (!("source" in par)) return;
  81. if (debug){
  82. print(par.config,"populateSourceTable ["+par.source.queryName+"]");
  83. }
  84. config.success=function(data){populateSourceTableData(data,par)};
  85. //config.success=function(data){selectRowsSuccess(par.config,data)};
  86. config.failure=function(errorTxt){print(par.config,"populateSourceData:fail"+errorTxt.exception)};
  87. LABKEY.Query.selectRows(config);
  88. }
  89. function populateSourceTableData(data,par){
  90. let debug=true;
  91. if (debug){
  92. print(par.config, "populateSourceTableData: nrow: "+data.rows.length);
  93. }
  94. let entry=data.rows[0];
  95. for (let i=0;i < par.source.vars.length;i++){
  96. let srcVarName=par.source.vars[i];
  97. if (debug){
  98. print(par.config, "populateSourceTable ["+srcVarName+"]");
  99. }
  100. let row=par.vars[srcVarName];
  101. let el=par.config.document.getElementById(row.selectId);
  102. if (debug){
  103. print(par.config, "Element: "+el);
  104. }
  105. el.innerHTML=entry[row.sourceSelectVarName];
  106. }
  107. }
  108. function generateTable(par,divName,elementId){
  109. let debug=true;
  110. if (debug)
  111. print(par.config,"generateTable");
  112. let tb=par.config.document.createElement('table');
  113. tb.className="t2";
  114. tb.id=elementId;
  115. par.config.document.getElementById(divName).appendChild(tb);
  116. if (debug)
  117. print(par.config,"generateTable: Done");
  118. }
  119. function generateRow(parameters, tableId, rowId){
  120. let debug=true;
  121. if (debug)
  122. print(parameters.config,"generateRow: Start");
  123. let config=generateQConfig(parameters.masterQuery);
  124. config.success=function(data){generateTableRow(data, parameters, tableId, rowId)};
  125. LABKEY.Query.selectRows(config);
  126. if (debug)
  127. print(parameters.config,"generateRow: End");
  128. return;
  129. }
  130. function generateTableRow(data, parameters, tableId, rowId){
  131. let debug=true;
  132. if (debug)
  133. print(parameters.config,"generateTableRow: start");
  134. let tb=parameters.config.document.getElementById(tableId);
  135. let row=parameters.vars[rowId];
  136. if (debug)
  137. print(parameters.config,"getField for "+row.masterSelectVarName);
  138. let field=getField(parameters.config,data,row.masterSelectVarName);
  139. let trow=tb.insertRow();
  140. let cell=parameters.config.document.createElement('th');
  141. trow.appendChild(cell);
  142. let text = parameters.config.document.createTextNode(field.shortCaption);
  143. cell.appendChild(text);
  144. cell=trow.insertCell();
  145. let input = parameters.config.document.createElement("select");
  146. input.id = row.selectId;
  147. input.onchange=function(){row.callback(parameters,rowId)};
  148. cell.appendChild(input);
  149. if (debug)
  150. print(parameters.config,"generateTableRow: end");
  151. }
  152. function populateSelectTableEntry(parameters,rowId){
  153. let debug=true;
  154. let row=parameters.vars[rowId];
  155. if (debug)
  156. print(parameters.config,"populateSelectTableEntry:"+parameters.masterQuery+"/"+row.masterSelectVarName);
  157. let config=generateQConfig(parameters.masterQuery);
  158. if ("filter" in row){
  159. //populateSelect on authorizationQuery with authSelectVarName
  160. let filter=row.filter;
  161. if (debug){
  162. print(parameters.config,"Filter:"+filter.queryName);
  163. print(parameters.config,"FilterVar "+filter.filterVarName);
  164. }
  165. config.queryName=filter.queryName;
  166. config.filterArray=[];
  167. for (f in filter.filters){
  168. if (debug) print(parameters.config,"Adding filter: "+f+" val "+filter.filters[f]);
  169. config.filterArray.push(LABKEY.Filter.create(f,filter.filters[f]));
  170. }
  171. }
  172. else{
  173. config.queryName=parameters.masterQuery;
  174. }
  175. config.success=function(data){populateTableRow(data,parameters,rowId)};
  176. LABKEY.Query.selectRows(config);
  177. if (debug)
  178. print(parameters.config,"generateSelect: End");
  179. return;
  180. }
  181. function populateTableRow(data,parameters,rowId){
  182. //data is output of selectRows on either
  183. // * masterQuery looking at masterSelectVarName or
  184. // * authQuery looking at authSelectVarName
  185. //in both cases, query[varName] is a lookup variable, so do populateSelect with lookupData,queryData and parameters
  186. let debug=true;
  187. let row=parameters.vars[rowId];
  188. let varName=row.masterSelectVarName;
  189. if ("filter" in row){
  190. if (row.filter.queryName==data.queryName){
  191. varName=row.filter.filterVarName;
  192. }
  193. }
  194. if (debug)
  195. print(parameters.config,"generateSelectVar: "+data.queryName+"/"+varName+" size "+data.rows.length);
  196. let field=getField(data,varName);
  197. if (!field) {
  198. print("Field "+varName+" not found");
  199. return;
  200. }
  201. if (!("lookup" in field)){
  202. let entry=data.rows[0];
  203. print("Field "+varName+" not a lookup");
  204. //populateSelectNotLookup(data,parameters,rowId, entry);
  205. return;
  206. }
  207. let config=generateQConfig(field.lookup.queryName);
  208. config.schemaName=field.lookup.schemaName;
  209. //config.success=function(lookupData){populateSelect(lookupData,data,parameters,rowId)};
  210. config.success=function(data){selectRowsSuccess(par.config,data)};
  211. LABKEY.Query.selectRows(config);
  212. if (debug)
  213. print(parameters.config,"generateSelectVar: End");
  214. }
  215. //populateSelect, populateSelectNotLookup
  216. function generateListAndPopulateDaughterSelect(parameters,rowId){;}
  217. function generateList(parameters,rowId){;}