1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683 |
- const config=new Object();
- function clear(){
- let el=config.document.getElementById(config.debugId);
- if (el===null) {
- //alert("Debug section not initialized");
- return;
- }
- config.document.getElementById(config.debugId).value="";
- }
- function print(msg){
- let el=config.document.getElementById(config.debugId);
- if (el===null) {
- //alert("Debug section not initialized. Message: "+msg);
- return;
- }
- el.value+="\n"+msg;
- }
- function getCRFrefFirst(){
- //crfRef is part of html call and gets stored in the page
- return config.document.getElementById(config.crfRefId).innerHTML;
- }
- function getCRFref(){
- //'crfRefId'
- return config.formConfig.crfEntry['entryId'];
- }
- function onFailure(errorInfo, options, responseObj){
-
- if (errorInfo && errorInfo.exception)
- alert("Failure: " + errorInfo.exception);
- else
- alert("Failure: " + responseObj.statusText);
- }
- function generateDebugSection(){
- //let debug=true;
- //if (debug) print("generateDebugSection "+sectionName);
- let formName=config.debugDiv;
- let sectionName="debugSection";
- let sectionTitle="Debug Messages";
- let tb=config.document.createElement('table');
- tb.className='t2';
- let row=tb.insertRow();
- let cell=config.document.createElement('th');
- row.appendChild(cell);
- cell.setAttribute("colspan","4");
- cell.style.fontSize="20px";
- cell.style.textAlign="center";
- let cellData=config.document.createTextNode(sectionTitle);
- cell.appendChild(cellData);
- cell=row.insertCell();
- let input=config.document.createElement("input");
- input.type="button";
- input.value="Show";
- input.id="toggle"+sectionName+"VisbilityButton";
- input.onclick=function(){toggleVisibility(sectionName,input.id)};
- cell.appendChild(input);
- config.document.getElementById(formName).appendChild(tb);
-
- let div=config.document.createElement('div');
- div.id=sectionName;
- div.style.display="none";
- config.document.getElementById(formName).appendChild(div);
- let debugArea=config.document.createElement('textarea');
- debugArea.rows=10;
- debugArea.cols=95;
- debugArea.id=config.debugId;
- div.appendChild(debugArea);
- }
- function setAdditionalData(additionalData,entry){
- let debug=true;
- if (debug) print("setAdditionalData");
- if (entry["showFlag"]==="NONE") {
- if (debug) print("Returning empty additionalData");
- return additionalData;
- }
- if (entry["showFlag"]==="REVIEW") {
- //abuse additionalData to signal different segment
- if (debug) print("Returning additionalData that signal review form");
- additionalData.isReview=true;
- return additionalData;
- }
- additionalData.showFlag=entry["showFlag"];
- additionalData.showFlagValue=entry["showFlagValue"];
- additionalData.queryName=entry["showQuery"];
- additionalData.filters=new Object();
- additionalData.filters['crfRef']=getCRFref();
- return additionalData;
- }
- function fullAccessSetup(listName){
- //generate setup object whcih should contain fields:
- //readonlyFlag - whether the dataset is writeable
- //filters - selection fields that allow creation of LABKEY.Filter.create()
- //getInputId - formating of unique ids for html elements
- //addApply - whether a submit/Save button is generated
- //unique - whether entries in list are unique
- let debug=true;
- if (debug) print("fullAccessSetup");
- let setup=new Object();
- setup.readonlyFlag=function(vName){return false};
- setup.filters=new Object();
- setup.filters['crfRef']=getCRFref();
- setup.getInputId=function(vName){return listName+"_"+vName;}
- setup.addApply="Save";
- return setup;
- }
- function readonlySetup(){
- //see definition of setup object above
- let debug=true;
- if (debug) print("readonlySetup");
- let setup=new Object();
- setup.readonlyFlag=function(vName){return true};
- setup.filters=new Object();
- setup.filters['crfRef']=getCRFref();
- setup.getInputId=function(vName){return vName;}
- return setup;
- }
- //afterFormConfig replaced by afterFormSetup
- //afterFormSetupLookup replaced by afterFormDatasets
- function generateSection(sectionName, sectionTitle, listName, additionalData){
- let formName=config.masterForm;//this is HTML designator of area on page
- let debug=true;
- if (debug) print("generateSection "+sectionName);
- let tb=config.document.createElement('table');
- tb.className='t2';
- let row=tb.insertRow();
- let cell=config.document.createElement('th');
- row.appendChild(cell);
- cell.setAttribute("colspan","4");
- cell.style.fontSize="20px";
- cell.style.textAlign="center";
- let cellData=config.document.createTextNode(sectionTitle);
- cell.appendChild(cellData);
- cell=row.insertCell();
- let input=config.document.createElement("input");
- input.type="button";
- input.value="Show";
- input.id="toggle"+sectionName+"VisbilityButton";
- input.onclick=function(){toggleVisibility(sectionName,input.id)};
- cell.appendChild(input);
- config.document.getElementById(formName).appendChild(tb);
- let div=config.document.createElement('div');
- div.id=sectionName;
- div.style.display="none";
- config.document.getElementById(formName).appendChild(div);
- let divTable=config.document.createElement('div');
- divTable.id=sectionName+"Table";
- div.appendChild(divTable);
-
- if ("showFlag" in additionalData) {
- additionalData.divName=sectionName+"SubDiv";
- additionalData.divQueryName=sectionName+"SubDivList";
- let div1=config.document.createElement('div');
- div1.id=additionalData.divName;
- div1.style.display="none";
- div.appendChild(div1);
-
- let div2=config.document.createElement('div');
- div2.id=additionalData.divQueryName;
- div1.appendChild(div2);
- }
- if (debug) print("generate master table");
-
- let setup=fullAccessSetup(listName);
- let formStatus=config.formConfig.formStatus;
- if (formStatus=="Submitted")
- setup=readonlySetup();
- if (formStatus=="Approved")
- setup=readonlySetup();
-
- if ("isReview" in additionalData){
- generateReviewSection(listName,div.id,generateReviewSectionCB);
- return;
- }
- //master table is unique per visit
-
- setup.unique=true;
- generateTable(listName,divTable.id,true,additionalData,setup);
-
- if (debug) print("generate master table: done");
- let generateSubTable=true;
- if (formStatus=="Submitted")
- generateSubTable=false;
- if (formStatus=="Approved")
- generateSubTable=false;
-
- if (! ("showFlag" in additionalData) ) generateSubTable=false;
-
- if (generateSubTable){
- let qName=additionalData.queryName;
- let dName=additionalData.divName;
-
- let setup=fullAccessSetup(qName);
- //if (readonly) setup=readonlySetup(config);
- generateTable(qName,dName,false,additionalData,setup);
- }
- print("generate review");
- let divReviewList=config.document.createElement('div');
- divReviewList.id=sectionName+"ReviewList";
- div.appendChild(divReviewList);
-
- let divReview=config.document.createElement('div');
- divReview.id=sectionName+"Review";
- div.appendChild(divReview);
- //assume we already have listId (content of config.setupQueryName is listId)
- //we need listName also
- //qconfig.queryName=config.setupQueryName;
- generateReview(divReview.id,divReviewList.id,listName);
- }
- //>>>>reviewSection associated routines
- function parseResponseXML(){
- //print(config.config,'Status:' +this.status);
- print('Status:'+this.status);
- if (this.status!=200) return;
- config.loadFileConfig.json=JSON.parse(this.responseText);
- config.loadFileConfig.cb();
- }
- function loadFile(){
- print('YY: '+config.loadFileConfig.url);
- let connRequest=new XMLHttpRequest();
- connRequest.addEventListener("loadend",parseResponseXML);
- //function(e){parseResponseXML(e,config);});
- connRequest.open("GET", config.loadFileConfig.url);
- connRequest.send();
- }
- function getBasePath(){
- let server=LABKEY.ActionURL.getBaseURL();
- let basePath=server+"_webdav";
- basePath+=LABKEY.ActionURL.getContainer();
- return basePath;
- }
- function generateReviewSection(listName,id,callback){
- //callback should be generateReviewSectionCB and it takes no arguments
- print("generateReviewSection");
- //need base path
- config.loadFileConfig=new Object();
-
-
- config.loadFileConfig.cb=callback;
- config.loadFileConfig.id=id;
- config.loadFileConfig.url=getBasePath()+'/@files/reportSetup/'+listName+'.json';
- loadFile();
- //load file and continue in the next function
- }
- function generateErrorMessage(id,listName,msg){
- print('generateErrorMessage:');
- let eid=listName+"_errorMsg";
- let el=config.document.getElementById(eid);
- if (el===null){
- el=config.document.createElement("p");
- config.document.getElementById(id).appendChild(el);
- }
- el.innerHTML=msg;
- }
- function clearErrorMessage(listName){
- let eid=listName+"_errorMsg";
- let el=config.document.getElementById(eid);
- if (el===null) return;
- el.remove();
- }
- function getParticipantCode(pid){
- let selectRows=new Object();
- selectRows.schemaName='lists';
- selectRows.queryName='PET';
- pid.afterId=setParticipantCode;
- selectRows.success=function(data){afterRegistration(pid,data);}
- selectRows.filterArray=[LABKEY.Filter.create("crfRef",getCRFref())];
- LABKEY.Query.selectRows(selectRows);
- }
- function visitCodeFromVisitId(visitId){
- if (visitId<0) return "NONE";
- let project=LABKEY.ActionURL.getContainer();
- print('visitCodeFromVisitId: '+project.search('retro'));
- if (project.search('retro')>-1)
- visitId-=1;
- return 'VISIT_'+visitId.toString();
- }
- function replaceSlash(x){
- return x.replace(/\//,'_');
- }
- function setParticipantCode(pid){
- let rows=pid.registration.rows;
- if (rows.length==1){
- print('setParticipantCode: '+rows[0].participantCode+'/'+rows[0].visitId);
- let visitCode=visitCodeFromVisitId(rows[0].visitId);
- print('setParticipantCode: '+pid.participantId+'/'+visitCode);
- pid.participantCode=replaceSlash(pid.participantId);
- pid.visitCode=visitCode;
- }
- generateReviewSection2(pid);
- }
- function generateReviewSectionCB(){
- let listName=config.loadFileConfig.listName;
- let id=config.loadFileConfig.id;
- clearErrorMessage(listName);
- let pid=new Object();
- pid.participantCode="NONE";
- pid.visitCode="NONE";
- getParticipantCode(pid);
- print('Get participant code sent');
- //involves database search, continue after callback
- }
- function getValueFromElement(id,defaultValue){
- let e=config.document.getElementById(id);
- if (e!=null){
- defaultValue=e.innerHTML;
- }
- return defaultValue;
- }
- function pickParticipantCodeFromPage(){
- let pid=new Object();
- pid.participantCode=getValueFromElement("participantCode","NIX-LJU-D2002-IRAE-A000");
- pid.visitCode=getValueFromElement("visitCode","VISIT_1");
- generateReviewSection2(pid);
- }
- function patternReplace(src,replacements,values){
- for (rep in replacements){
- let txt1=src.replace(new RegExp(rep),values[replacements[rep]]);
- src=txt1;
- }
- return src;
- }
- function plotImage(row,rowVariable,obj,pid){
- let nim=obj.values.length;
- let baseDir=patternReplace(obj.imageDir,obj.replacements,pid);
- print('Base dir: '+pid.basePath);
- for (let im=0;im<nim;im++){
- pid[obj.variable]=obj.values[im];
- let img=config.document.createElement('img');
- let imgSrc=patternReplace(obj.file,obj.replacements,pid);
- print('Image: '+imgSrc);
- let imagePath=pid.basePath+'/'+baseDir+'/'+imgSrc;
-
- img.src=imagePath;
- img.width="300";
- let cell=row.insertCell();
- cell.id=pid[obj.variable]+"_"+rowVariable+pid[rowVariable];
- cell.appendChild(img);
- }
- }
- function showReport(row,rowVariable,obj,pid){
- let nr=obj.values.length;
- for (let ir=0;ir<nr;ir++){
- let cell=row.insertCell();
- cell.id=obj.values[ir]+"_"+rowVariable+pid[rowVariable];
- cell.width="300px";
- let reportConfig=new Object();
- reportConfig.partName="Report";
- reportConfig.renderTo=cell.id;
- //reportConfig.showFrame=false;
- //reportConfig.width="300";
- reportConfig.frame="none";
- reportConfig.partConfig=new Object();
- reportConfig.partConfig.width="300";
- reportConfig.partConfig.title="R Report";
- reportConfig.partConfig.reportName=obj.values[ir];
- for (f in obj.parameters){
- reportConfig.partConfig[f]=pid[f];
- }
- reportConfig.partConfig.showSection="myscatterplot";
- let reportWebPartRenderer = new LABKEY.WebPart(reportConfig);
- print('Render to: '+reportConfig.renderTo);
- reportWebPartRenderer.render();
- }
- }
- function showProbability(row,rowSetup,j,obj,pid){
- print('showProbability: '+rowSetup);
- let np=obj.values.length;
- let probDensity=new Object();
- probDensity.mean=rowSetup.mean[j];
- probDensity.sigma=rowSetup.sigma[j];
- print('showProbability: mean '+probDensity.mean+' sigma '+probDensity.sigma);
- for (let ip=0;ip<np;ip++){
- let cell=row.insertCell();
- probDensity.func=obj.values[ip];
- probDensity.organCode=pid.organCode;
- pid[obj.variable]=rowSetup[obj.variable][j];
- probDensity.percentile=pid.percentile;
- let selectRows=new Object();
- selectRows.queryName=obj.queryName;
- selectRows.schemaName="study";
- selectRows.filterArray=[];
- for (let f in obj.filters){
- selectRows.filterArray.push(LABKEY.Filter.create(f,pid[obj.filters[f]]));
- print('Filter ['+f+']: '+pid[obj.filters[f]]);
- }
- selectRows.success=function(data){drawProbability(data,cell,obj,pid,probDensity);}
- LABKEY.Query.selectRows(selectRows);
- }
- }
- function erf(x){
- let fx=[0,0.02,0.04,0.06,0.08,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,
- 1,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,2,
- 2.1,2.2,2.3,2.4,2.5,3,3.5];
- let fy=[0,0.222702589,0.328626759,0.428392355,0.520499878,
- 0.603856091,0.677801194,0.742100965,0.796908212,
- 0.842700793,0.880205070,0.910313978,0.934007945,
- 0.952285120,0.966105146,0.976348383,
- 0.983790459,0.989090502,0.992790429,0.995322265,
- 0.997020533,0.998137154,0.998856823,0.999311486,
- 0.999593048,0.999977910,0.999999257];
- let n=32;
- let i0=n-1;
- for (let i=1;i<n;i++){
- if (Math.abs(x)>fx[i]) continue;
- i0=i-1;
- break;
- }
- let fval=1;
- if (i0<n-1){
- //interpolate
- let y1=fy[i0+1];
- let y0=fy[i0];
- let x1=fx[i0+1];
- let x0=fx[i0];
- fval=y0+(y1-y0)/(x1-x0)*(Math.abs(x)-x0);
- }
- print('Erf: '+fval);
- if (x<0) return -fval;
- return fval;
- }
- function drawProbability(data,cell,obj,pid,probDensity){
- print('drawProbability');
- if (data.rows.length!=1){
- print("drawProbability row length mismatch: "+data.rows.length);
- return;
- }
- //possible mismatch; I assume the dataset will have a field called value
- let val=data.rows[0].value;
- let prob=0;
- let fz=-100;
- if (probDensity.func=="gaus"){
- fz=(val-probDensity.mean)/probDensity.sigma/Math.sqrt(2);
- prob=0.5+0.5*erf(fz);
- }
- let color="red";
- let fzx=fz*Math.sqrt(2);
- print('drawProbability '+fzx);
- for (let i=1;i<obj.intervals.n;i++){
- if (fzx>obj.intervals.zlimits[i]) continue;
- color=obj.intervals.colors[i-1];
- break;
- }
- let fbox=config.document.createElement("div");
- fbox.style.backgroundColor=color;
- fbox.style.width="180px";
- fbox.style.height="180px";
-
- print('organCode '+probDensity.organCode);
- let organName="Lung";
- if (probDensity.organCode==4){
- organName="Thyroid";
- }
- if (probDensity.organCode==5){
- organName="Bowel";
- }
- let fp4=document.createElement("p");
- fp4.classList.add("center");
- fp4.style.textAlign="center";
- fp4.innerHTML=organName;
- fbox.appendChild(fp4);
-
- let fp=document.createElement("p");
- //fp.innerHTML=prob.toPrecision(3);
- fp.innerHTML=val.toPrecision(3);
- fp.style.fontSize="25px";
- fp.style.textAlign="center";
- fbox.appendChild(fp);
- let fp1=document.createElement("p");
- fp1.classList.add("center");
- fp1.style.textAlign="center";
- //fp1.innerHTML="IRAEMM-probability";
- fp1.innerHTML="SUV("+probDensity.percentile+"%)";
- fbox.appendChild(fp1);
- let fp2=document.createElement("p");
- fp2.innerHTML=fzx.toPrecision(3);
- fp2.style.fontSize="25px";
- fp2.style.textAlign="center";
- fbox.appendChild(fp2);
- let fp3=document.createElement("p");
- fp3.classList.add("center");
- fp3.style.textAlign="center";
- fp3.innerHTML="z-value";
- fbox.appendChild(fp3);
- cell.appendChild(fbox);
- }
- function generateReviewSection2(pid){
-
- let listName=config.loadFileConfig.listName;
- let id=config.loadFileConfig.id;
-
- print('generateReviewSection2: '+pid.participantCode+'/'+
- pid.visitCode);
- if (pid.participantCode=="NONE" || pid.visitCode=="NONE"){
- generateErrorMessage(id,listName,
- "ParticipantId/visitId not set");
- return;
- }
-
- print('JSON: '+config.loadFileConfig.json);
- let json=config.loadFileConfig.json;
- let nrows=json.rows.values.length;
- let ncol=json.columns.length;
- pid.basePath=getBasePath()+"/@files";
-
-
- let el=config.document.getElementById(id);
- let table=config.document.createElement('table');
- table.style.tableLayout="fixed";
- table.style.columnWidth="300px";
- el.appendChild(table);
-
- for (let i=0;i<nrows;i++){
- pid[json.rows.variable]=json.rows.values[i];
- //let organ=organs[i];
- let row=table.insertRow();
- for (let j=0;j<ncol;j++){
- let obj=json.columns[j];
- if (obj.display=="image")
- plotImage(row,json.rows.variable,obj,pid);
- if (obj.display=="report")
- showReport(row,json.rows.variable,obj,pid);
- if (obj.display=="probability"){
- showProbability(row,json.rows,i,obj,pid);
- }
- }
-
- }
- }
- ///>>>>>>>>>>>>>>end of reviewSection(REPORT)
- function generateReview(divReviewId,divReviewListId, listName){
- let listId=config.formConfig.fields[listName].queryId;
- let debug=true;
- if (debug) print("Generate review for: "+listId);
-
- let reviewSetup=new Object();
- reviewSetup.readonlyFlag=function(vName){
- if (vName=="queryName") return true;
- if (vName=="queryname") return true;
- if (vName=="ModifiedBy") return true;
- return false;};
- reviewSetup.addApply="Add Review";
- let generateTableFlag=true;
- let formStatus=config.formConfig.formStatus;
- if (formStatus == "Approved" ){
- delete reviewSetup.addApply;
- reviewSetup.readonlyFlag=function(vName){return false;}
- generateTableFlag=false;
- }
-
- reviewSetup.filters=new Object();
- reviewSetup.filters["crfRef"]=getCRFref();
-
- reviewSetup.filters["queryName"]=listId;//entry in reviewComments list is queryname, all in small caps
- //needs listName, in argument
-
- reviewSetup.getInputId=function(vName){return listName+"_add"+vName};
- reviewSetup.divReviewListId=divReviewListId;
-
- if (debug) {
- let msg="Review: divId: "+divReviewId;
- msg+=" inputId: "+reviewSetup.getInputId;
- print(msg);
- }
- updateListDisplay(divReviewListId,"reviewComments",reviewSetup.filters,true);
-
- if (! generateTableFlag) return;
-
- generateTable("reviewComments",divReviewId,false,new Object(),reviewSetup);
- }
- //>>>>>>>>>>trigger visibility of additional lists
- function setListVisibility(setup,additionalData,readonlyFlag){
- let debug=true;
- if (debug){
- print("Set list visibility ");
- for (f in additionalData){
- print("AdditionalData["+f+"]: "+additionalData[f]);
- }
- }
- let x = config.document.getElementById(additionalData.divName);
- if (debug) print("\n Div: "+x);
- x.style.display="none";
- let eId=setup.getInputId(additionalData.showFlag);
- let e = config.document.getElementById(eId);
-
- let sText;
- if (readonlyFlag) sText=e.innerHTML;
- else sText=e.options[e.selectedIndex].text;
-
- if (debug) print("\n Selected option text: "+sText);
- if (sText == additionalData.showFlagValue){
- let filters=new Object();
- if ("filters" in additionalData) filters=additionalData.filters;
- x.style.display = "block";
- updateListDisplay(additionalData.divQueryName,
- additionalData.queryName,filters,readonlyFlag);
- }
- }
- //>>have list refresh when data is added (not optimal yet)
- function updateListDisplay(divName,queryName,filters,readonlyFlag){
- let debug=true;
- if (debug)
- print("UpdateListDisplay: Query - "+queryName
- +" div - "+divName);
- if (divName=="NONE") return;
- let crfRef=getCRFref();
- let div=config.document.getElementById(divName);
- if (debug)
- print("Enabling display to queryName: "+queryName);
-
- var qconfig=new Object();
- qconfig.renderTo=divName;
- qconfig.containerPath=config.containerPath;
- qconfig.schemaName='lists';
- qconfig.queryName=queryName;
- qconfig.buttonBarPosition='top';
- qconfig.filters=[];
- for (f in filters){
- qconfig.filters.push(LABKEY.Filter.create(f, filters[f]));
- }
- qconfig.success=updateSuccess;
- qconfig.failure=updateFailure;
- //show only print button
- if (readonlyFlag){
- qconfig.buttonBar=new Object();
- qconfig.buttonBar.items=["print"];
- }
- LABKEY.QueryWebPart(qconfig);
-
- }
- function updateSuccess(data){
- print("Update success");
- }
- function updateFailure(data){
- print("Update failed");
- }
- //TODO: this should trigger a data refresh on section, ie populateData(field)
- function toggleVisibility(divName,buttonName){
- let x = config.document.getElementById(divName);
- if (x.style.display === "none") {
- x.style.display = "block";
- config.document.getElementById(buttonName).value="Hide";
- } else {
- x.style.display = "none";
- config.document.getElementById(buttonName).value="Show";
- }
- }
- function generateButtonBU(divName,title,buttonName,callback,
- callbackParameters){
- let debug=true;
- if (debug) print("generateButtonBU");
-
- let tb=config.document.createElement('table');
- tb.className="t2";
-
- let r1=tb.insertRow();
- th=config.document.createElement('th');
- r1.appendChild(th);
- th.innerHTML=title;
- //*!*
- let c2=r1.insertCell();
- let i1=config.document.createElement("input");
- i1.type="button";
- i1.value=buttonName;
- i1.style.fontSize="20px";
- i1.onclick=function(){callback(callbackParameters);}
- c2.appendChild(i1);
- let c1=r1.insertCell();
- c1.setAttribute("colspan","1");
- c1.id=callbackParameters.submitReportId;
- let el=config.document.getElementById(divName);
- if (debug) print("generateButton: element["+divName+"]: "+el);
-
-
- el.appendChild(tb);
-
-
- }
- function generateButton(divName,title,buttonName,callback){
- let debug=true;
- if (debug) print("generateButtonX");
-
- let tb=config.document.createElement('table');
- tb.className="t2";
-
- let r1=tb.insertRow();
- th=config.document.createElement('th');
- r1.appendChild(th);
- th.innerHTML=title;
- //*!*
- let c2=r1.insertCell();
- let i1=config.document.createElement("input");
- i1.type="button";
- i1.value=buttonName;
- i1.style.fontSize="20px";
- i1.onclick=callback;
- c2.appendChild(i1);
- let c1=r1.insertCell();
- c1.setAttribute("colspan","1");
- c1.id=config.submitReportId;
- let el=config.document.getElementById(divName);
- if (debug) print("generateButton: element["+divName+"]: "+el);
-
-
- el.appendChild(tb);
-
-
- }
- //>>populate fields
- //
- function addFieldRow(tb,entry,field,setup,additionalData){
- let vName=field.name;
- let vType=field.type;
- let isLookup=("lookup" in field);
- print("addFieldRow ["+vName+"/"+vType+'/'+isLookup+"]");
-
- let row=tb.insertRow();
- let cell=config.document.createElement('th');
- row.appendChild(cell);
-
- let text = config.document.createTextNode(field.shortCaption);
- cell.appendChild(text);
- cell=row.insertCell();
-
- let varValue="UNDEF";
- if (vName in setup.filters) varValue=setup.filters[vName];
- if (vName in entry) varValue=entry[vName];
-
- //date
- if (vType=="date"){
- if (varValue==="UNDEF") varValue=new Date();
- else varValue=new Date(varValue);
- }
-
- let input=null;
- cell.colSpan="3";
- let cellClass="input";
- let cellType="text";
- let readonlyFlag=setup.readonlyFlag(vName);
- if (isLookup){
- let lookup=field["lookup"];
- //get all values from config.formConfig.lookup[X]
- let lObject=config.formConfig.lookup[lookup.queryName];
- varValue=lObject.LUT[varValue];
- }
- //set the html input object
- while (1){
- if (readonlyFlag){
- input=config.document.createTextNode(varValue);
- break;
- }
-
- //lookup
- if (isLookup){
- input = config.document.createElement("select");
- break;
- }
- //date
- if (vType=="date"){
- input = config.document.createElement("input");
- input.type="date";
- break;
- }
- //string
- if (vType=="string"){
- //we have to make sure UNDEF is carried to below
- //since we are adapting file to either show
- //current file or allow user to select a file
- //
- //TODO change this so one can always select file
- //but also show the selected file
- if (varValue==null) varValue="UNDEF";
- else{
- if (varValue.length==0) varValue="UNDEF";
- }
- if(vName.search("reviewComment")>-1){
- input = config.document.createElement("textarea");
- input.cols="65";
- input.rows="5";
- break;
- }
- input=config.document.createElement('input');
- input.type="text";
-
- if (vName.search('_file_')<0) break;
-
- print('varValue: '+varValue);
- if (varValue!="UNDEF") break;
- input.type="file";
- break;
-
- }
- if (vType=="float"){
- input = config.document.createElement("input");
- input.type="text";
- break;
- }
-
-
- if (vType=="boolean"){
- input = config.document.createElement("input");
- input.type="checkbox";
- print("Creating checkbox");
- break;
- }
- break;
- }
-
- input.id=setup.getInputId(vName);
- cell.appendChild(input);
-
-
- if (varValue != "UNDEF"){
- if (vType=="string")
- input.value=varValue;
- if (vType=="float")
- input.value=varValue;
- if (vType=="date")
- input.valueAsDate=varValue;
- if (vType=="boolean")
- input.checked=varValue;
- }
-
- if (readonlyFlag) return;
-
- if (!isLookup) return;
- let lookup=field["lookup"];
- //get all values from config.formConfig.lookup[X]
- let lObject=config.formConfig.lookup[lookup.queryName];
-
- //debug
- print("Query: "+lookup.queryName);
- print("ElementId: "+input.id);
- print("No of options: " +lObject.LUT.length);
- print("Element: "+input);
- //set the lut value (input is text label) for readonly
- //clear existing fields from input
- for(let i = input.options.length; i >= 0; i--) {
- input.remove(i);
- }
-
- //create option -1
- let opt = config.document.createElement("option");
- opt.text = "<Select>";
- opt.value = -1;
- input.options[0] = opt;
- print( "Adding <Select>");
- //set value
- let fv=entry[vName];//can be undefined
- if (vName in setup.filters) fv=setup.filters[vName];
- input.selectedIndex=0;
- //add other, label them with LUT
- for (let v in lObject.LUT) {
- print('populating '+v+': '+lObject.LUT[v]);
- let opt = config.document.createElement("option");
- opt.text = lObject.LUT[v];
- opt.value = v;
- input.options[input.options.length] = opt;
- if (fv==undefined) continue;
- if (fv==v) input.selectedIndex=input.options.length-1;
-
- }
-
- //add watcher for showFlag field of additionalData
- if (!("showFlag" in additionalData))
- return;
- print("\n Parsing additional data ");
-
- let expId=setup.getInputId(additionalData.showFlag);
- if (expId!=input.id) {
- print("Skipping fields not flagged as showFlag:"+expId+"/"+input.id);
- return;
- }
- print("Setting onChange to "+input.id);
-
- input.onchange=function(){setListVisibility(setup,additionalData,readonlyFlag)};
- setListVisibility(setup,additionalData,readonlyFlag);
- }
-
-
- function generateTable(listName,divName,unique,additionalData,setup){
- let debug=true;
-
- if (debug) print("generateTable: "+listName);
-
- //assume data is set in config.formConfig.dataQueries[data.queryName].rows;
-
- let entry=new Object();
- //data snapshot
- let fQuery=config.formConfig.dataQueries[listName];
- //here I assume that listName was parsed during setDataLayout and setData
- //so that rows was set (even if they are empty)
- print("Nrows "+fQuery.rows.length);
-
- if (fQuery.rows.length>0)
- entry=fQuery.rows[0];
-
- let tb=config.document.createElement('table');
- tb.className="t2";
- config.document.getElementById(divName).appendChild(tb);
- //this are the fields (probably constant)
- let fields=fQuery.fields;
-
- for (f in fields){
- let field=fields[f];
- //each field is a new row
- print("Adding field: "+f+'/'+field.name);
- if (field.hidden) continue;
- if (field.name=="crfRef") continue;
- addFieldRow(tb,entry,field,setup,additionalData);
-
- }
- //add comment field
- if (!("addApply" in setup)) {
- print("populateTable: done");
- return;
- }
-
- let row=tb.insertRow();
- let th=config.document.createElement('th');
- row.appendChild(th);
- th.innerHTML=setup.addApply;
- let cell=row.insertCell();
- //cell.setAttribute("colspan","2");
- let input=config.document.createElement("input");
- input.type="button";
- input.value=setup.addApply;
- cell.appendChild(input);
- let cell1=row.insertCell();
- cell1.setAttribute("colspan","2");
- cell1.id=setup.getInputId("rerviewLastSave");
- cell1.innerHTML="No recent update";
- //saveReview is a generic name for saving content of the html page to a list entry
- input.onclick=function(){saveReview(data.queryName,cell1.id,setup)};
- }
-
- function checkVariable(el,varValue,displayText, parameters,varName,readonlyFlag){
- //set value with a little bit of QA
- //parameters should contain varName or this will return false
- //compares current varValue to value in parameters[varName], if they are equal,
- //sets the selectedIndex to last one
- let debug=true;
- if (!varName in parameters) return false;
- print("Comparing: " + varValue + "/" + parameters[varName]);
-
- if (varValue==parameters[varName]){
- if (readonlyFlag) el.innerHTML=displayText;
- else {
- //last one added?
- el.selectedIndex=el.options.length-1;
- print("Equal; "+el.selectedIndex);
- }
- return true;
- }
- return false;
-
- }
- function saveReview(queryName,elementId,setup){
- let debug=true;
- if (debug) print("saveReview: elementId "+elementId+" queryName "+queryName);
- let qconfig=new Object();
- qconfig.containerPath=config.containerPath;
- qconfig.schemaName='lists';//could be made more generic
- qconfig.queryName=queryName;
- if ("unique" in setup){
- qconfig.filterArray=[LABKEY.Filter.create("crfRef",getCRFref())];
- }
- qconfig.success=function(data){saveReviewToList(data,elementId,setup);}
- //to guess the fields, one must do selectRows first?
- LABKEY.Query.selectRows(qconfig);
- }
- function saveReviewToList(data,elementId,setup){
- let debug=true;
- if (debug) {
- let msg="saveReviewToList: "+" elementId "+elementId;
- msg+=" nrows "+data.rows.length;
- print(msg);
- }
- let useInsert=false;
- if (!("unique" in setup)) useInsert=true;
- if (data.rows.length==0) useInsert=true;
- let entry=new Object();
-
- if (!useInsert){
- entry=data.rows[0];
- }
- entry.crfRef=getCRFref();
- if (debug) print("Set crfRef="+entry.crfRef);
- if ("queryName" in setup.filters) {
- entry.queryName=setup.filters["queryName"];
- if (debug) print("Setting queryName: "+entry.queryName);
- }
- if ("queryname" in setup.filters) {
- entry.queryname=setup.filters["queryname"];
- if (debug) print("Setting queryname: "+entry.queryname);
- }
- let fields=data.metaData.fields;
- for (f in fields){
- let field=fields[f];
- if (debug) print("saveReview field: "+field.name);
- if (field.hidden) continue;
-
- let vName=fields[f].name;
- if (vName=="crfRef") continue;
- if (vName=="queryName") continue;
- if (vName=="queryname") continue;
-
- let eId=setup.getInputId(vName);
-
- let el=config.document.getElementById(eId);
-
- if (!el) {
- if (debug) print("saveReview element: "+eId+" not found");
- continue;
- }
- if (debug) print("saveReview element: "+eId);
-
- let vType=fields[f].type;
- if (debug) print("vType: "+vType);
- if ("lookup" in fields[f]){
- if (el.nodeName==="SELECT"){
- entry[vName]=el.options[el.selectedIndex].value;
- }
- if (el.nodeName==="TD"){
- entry[vName]=el.innerHTML;
- }
- print("Setting lookup to "+entry[vName]);
- continue;
- }
- if (vType=="date"){
- var date=el.valueAsDate;
- if (date==="null") continue;
- date.setUTCHours(12);
- entry[vName]=date.toString();
- print("Setting date to "+entry[vName]);
- }
- if (vType=="string"){
- entry[vName]=el.value;
- let idx=field.name.search('_file_');
- let lg=el.value.length;
- if (idx>-1 && lg>0){
- print('Attachment field: '+el.value);
- //entry[vName]=el.files[0].stream();
- let ctx=new Object();
- ctx['dirName']='consent';
- ctx['ID']=entry['crfRef'];
- ctx['project']=config.containerPath;
- //need ID->crf!
- //assume crfRef will get set before this
- //element is encountered
- uploadFile(el,ctx);
- let suf=entry[vName].split('.').pop();
- entry[vName]=entry['crfRef']+'.'+suf;
- }
- }
- if (vType=="float"){
- entry[vName]=el.value;
- }
- if (vType=="boolean"){
- entry[vName]=el.checked;
- }
- }
-
- let qconfig=new Object();
- qconfig.rows=[entry];
- qconfig.containerPath=config.containerPath;
- qconfig.schemaName=data.schemaName;
- qconfig.queryName=data.queryName;
- //only update comments
- print("modifyRows: useInsert "+useInsert);
- qconfig.success=function(data){updateLastSavedFlag(data,setup,elementId)};
- if (!useInsert){
- LABKEY.Query.updateRows(qconfig);
- }
- else{
- LABKEY.Query.insertRows(qconfig);
- }
- }
- function updateLastSavedFlag(data,setup,elementId){
- let debug=true;
- if (debug) print("Update last saved flag to "+elementId);
- let el=config.document.getElementById(elementId);
- let dt=new Date();
- el.innerHTML="Last saved "+dt.toString();
- if (data.queryName=="reviewComments"){
- updateListDisplay(setup.divReviewListId,"reviewComments",setup.filters,true);
- }
- }
- //******************************************upload to database *********************
- function onDatabaseUpload(){
- print("Database upload");
- configUpload=new Object();
- //figure out the participantId
-
- let qconfig=new Object();
- qconfig.schemaName="lists";
- qconfig.queryName="Forms";
- qconfig.filterArray=[LABKEY.Filter.create('Key',config.formId)];
-
- //qconfig.filterArray=[LABKEY.Filter.create('formStatus',1)]
- qconfig.success=function(data){afterForms(configUpload,data)};
- LABKEY.Query.selectRows(qconfig);
- }
- function afterForms(configUpload,data){
- let formEntry=data.rows[0];
- configUpload.registrationQueryId=formEntry["masterQuery"];
- configUpload.afterId=afterParticipantId;
- let qconfig=new Object();
- qconfig.queryName=config.queryMap[configUpload.registrationQueryId];
- //queryMap holds mapping for queries in visit;
- //masterQuery should be one of them, so this is safe.
- qconfig.schemaName='lists';
- qconfig.filterArray=[LABKEY.Filter.create('crfRef',getCRFref())];
- qconfig.success=function(data){afterRegistration(configUpload,data);}
- LABKEY.Query.selectRows(qconfig);
- //waitForCompleteUpload(config);//
- }
- function afterRegistration(configUpload,data){
- print("afterRegistration: rows:"+data.rows.length);
- configUpload.registration=data;
- let registrationData=configUpload.registration;
- clearErr();
- if (registrationData.rows.length!=1){
- let msg="ERROR: Found "+registrationData.rows.length;
- msg+=" registration entries for crfrefid "+getCRFref();
- print(msg);
- configUpload.afterId(configUpload);
- return;
- }
- print('registration participant field: '+config.registrationParticipantIdField);
- configUpload.participantId=
- registrationData.rows[0][config.registrationParticipantIdField];
- //could be a lookup field
- let fields=registrationData.metaData.fields;
- let field="NONE";
- for (f in fields){
- if (fields[f]["name"]==config.registrationParticipantIdField)
- field=fields[f];
- }
- if ("lookup" in field){
- let pid=configUpload.participantId;
- print("Using lookup for participantId: "+pid);
- let lookup=field["lookup"];
- print("Lookup: ["+lookup.schemaName+','+lookup.queryName+']');
- let qconfig=new Object();
- qconfig.containerPath=config.containerPath;
- qconfig.schemaName=lookup.schemaName;
- qconfig.queryName=lookup.queryName;
- qconfig.filterArray=
- [LABKEY.Filter.create(lookup.keyColumn,pid)];
- qconfig.success=function(data){
- afterRegistrationLookup(configUpload,data,lookup.displayColumn)};
- LABKEY.Query.selectRows(qconfig);
- }
- else{
- //afterParticipantId(configUpload);
- configUpload.afterId(configUpload);
- }
- }
- function afterRegistrationLookup(configUpload,data,displayColumn){
- print("afterRegistrationLookup");
- let entry=data.rows[0];
- configUpload.participantId=entry[displayColumn];
- print('Setting to '+configUpload.participantId);
- configUpload.afterId(configUpload);
- //afterParticipantId(configUpload);
- }
- function afterParticipantId(configUpload){
- print("Setting participantId to "+configUpload.participantId);
- //another select rows to update all queries from setup
- //just use registration for test
- let qconfig=new Object();
- qconfig.schemaName='lists';
- //qconfig.queryName=config.setupQueryName;
- qconfig.queryName="FormSetup";
- qconfig.filterArray=[LABKEY.Filter.create("formName",config.formId)];
- qconfig.success=function(data){afterSetup(configUpload,data);}
- LABKEY.Query.selectRows(qconfig);
- }
- function afterSetup(configUpload,data){
- configUpload.queries=new Array();
- for (let i=0;i<data.rows.length;i++){
- let entry=data.rows[i];
- //skip reviews
- if (entry.showFlag=="REVIEW") continue;
- //use lookup table to convert from id to name
- let queryName=config.queryMap[entry.queryName];
- configUpload.queries.push({queryName:queryName,queryStatus:"QUEUED"});
- if (entry.showQuery=="NONE")
- continue
- configUpload.queries.push({queryName:entry.showQuery,queryStatus:"QUEUED"});
- }
- //add reviews
- configUpload.queries.push({queryName:"reviewComments",queryStatus:"QUEUED"});
- configUpload.queryId=0;
- copyToDataset(configUpload);
- //config.upload["start"]=true;
- //for (u in config.upload){
- // if (u=="start") continue;
- // if (u=="count") continue;
- // copyToDataset(config,u,participantId);
- //}
- //
- //print("Database updated");
- }
- function copyToDataset(configUpload){
- if (configUpload.queryId==configUpload.queries.length) {
- updateFlag(3);//Approved
- return;
- }
- let queryName=configUpload.queries[configUpload.queryId].queryName;
- print("copyToDataset["+configUpload.queryId+"/"+configUpload.queries.length+"]: "+queryName);
- let qconfig=new Object();
- qconfig.queryName=queryName;
- qconfig.schemaName="lists";
- qconfig.filterArray=[LABKEY.Filter.create('crfRef',getCRFref())];
- qconfig.success=function(data){afterListData(configUpload,data)};
- LABKEY.Query.selectRows(qconfig);
- }
- function afterListData(configUpload,data){
- let queryName=configUpload.queries[configUpload.queryId].queryName;
- let msg="["+queryName+"/list]: "+data.rows.length+" entries";
- print(msg);
- configUpload.queries[configUpload.queryId].listData=data;
- let qconfig=new Object();
- qconfig.queryName=queryName;
- qconfig.schemaName="study";
- qconfig.filterArray=[LABKEY.Filter.create('crfRef',getCRFref())];
- qconfig.filterArray.push(LABKEY.Filter.create('ParticipantId',configUpload.participantId));
- qconfig.success=function(data){afterStudyData(configUpload,data)};
- LABKEY.Query.selectRows(qconfig);
- }
- function afterStudyData(configUpload,data){
- configUpload.queries[configUpload.queryId].studyData=data;
- let queryName=configUpload.queries[configUpload.queryId].queryName;
- let msg="["+queryName+"/study]: "+data.rows.length+" entries";
- print(msg);
-
- let listRows=configUpload.queries[configUpload.queryId].listData.rows;
- //skip uploading an empty set
- if (listRows.length==0){
- printErr("List "+queryName+" empty.");
- configUpload.queries[configUpload.queryId].queryStatus="DONE";
- configUpload.queryId+=1;
- copyToDataset(configUpload);
- return;
- }
-
- let studyRows=configUpload.queries[configUpload.queryId].studyData.rows;
- for (let i=0;i<studyRows.length;i++){
- let entry=studyRows[i];
- if (! (i<listRows.length) ) continue;
- let entryList=listRows[i];
- //keeps study only variables (ParticipantId, SequenceNum)
- for (let f in entryList) {
- entry[f]=entryList[f];
- print("Copying ["+f+"]: "+entry[f]+"/"+entryList[f]);
- }
- }
- if (studyRows.length>0) {
- let qconfig=new Object();
- qconfig.queryName=queryName;
- qconfig.schemaName="study";
- qconfig.rows=studyRows;
- qconfig.success=function(data){afterStudyUpload(configUpload,data);}
- LABKEY.Query.updateRows(qconfig)
- }
- else{
- let data=new Object();
- data.rows=new Array();
- afterStudyUpload(configUpload,data);
- }
- }
- function afterStudyUpload(configUpload,data){
-
- //let participantField=config.participantField;
- let participantField=config.formConfig.studyData["SubjectColumnName"];
- let dataObject=configUpload.queries[configUpload.queryId];
- let queryName=dataObject.queryName;
- printErr("Updated "+data.rows.length+" rows to "+queryName);
-
- let studyRows=dataObject.studyData.rows;
- let listRows=dataObject.listData.rows;
-
- let rows=new Array();
- //also updating existing rows, if they exist
- for (let i=studyRows.length;i<listRows.length;i++){
- let entry=listRows[i];
- //make sure you have the participantField right
- //
- entry[participantField]=configUpload.participantId;
- entry.crfRef=getCRFref();
- entry.SequenceNum=getCRFref();
- entry.SequenceNum=entry.SequenceNum % 1000000000;
-
- if (listRows.length>1){
- entry.SequenceNum+=i/100;
- }
- print( "Adding sequence number "+entry.SequenceNum);
- rows.push(entry);
- }
- if (rows.length>0){
- let qconfig=new Object();
- qconfig.queryName=queryName;
- qconfig.schemaName="study";
- qconfig.success=function(data){
- afterListUpload(configUpload,data)};
- qconfig.rows=rows;
- LABKEY.Query.insertRows(qconfig);
- }
- else{
- let data=new Object();
- data.rows=rows;
- afterListUpload(configUpload,data);
- }
-
- }
- function afterListUpload(configUpload,data){
- let queryName=configUpload.queries[configUpload.queryId].queryName;
- printErr("Inserted "+data.rows.length+" rows to "+queryName);
- configUpload.queries[configUpload.queryId].queryStatus="DONE";
- configUpload.queryId+=1;
- copyToDataset(configUpload);
- }
- //*************************update for further review *************************
- function onUpdateForReview(){
- updateFlag(4);//Pending review
- }
- function updateFlag(flag){
- if (flag==4)
- print("Sent to further review");
- let qconfig=new Object();
- qconfig.schemaName='lists';
- qconfig.queryName='crfEntry';
- qconfig.success=function(data){setFlag(data,flag);}
- qconfig.filterArray=[LABKEY.Filter.create("entryId",getCRFref())];
- LABKEY.Query.selectRows(qconfig);
- }
- function setFlag(data,flag){
- let debug=true;
- if (flag==4) print("setFlagToReview");
- if (data.rows.length!=1){
- let msg="ERROR: Found "+data.rows.length;
- msg+=" entries for crfrefid "+getCRFref();
- print(msg);
- return;
- }
- let entry=data.rows[0];
- entry.FormStatus=flag;//Pending Review
- if (debug)
- print("Set form status to "+entry.FormStatus);
-
- let qconfig=new Object();
- qconfig.schemaName='lists';
- qconfig.queryName='crfEntry';
- qconfig.rows=[entry];
- qconfig.success=function(data){completeWithFlag(data,flag);}
- LABKEY.Query.updateRows(qconfig);
-
- }
- function completeWithFlag(data,flag){
- let debug=true;
- if (debug){
- if (flag==4) print("complete with review");
- }
- redirect();
-
-
- }
- //************************************************ submit *******************************************
- function onSubmit(){
- let debug=true;
- hideErr();
- clearErr();
- printErr("onSubmit");
- //the idea of check form is to provide a methodology for form validation
- //it consists of two parts - a routine that initiates the check, and a
- //polling watchdog that waits for its execution.
- //Non-linear approach follows the natural javascript pathway.
- checkForm();
- //watchdog with callback that gets executed when checkForm is done
- let cb=new Object();
- cb.success=finalValidation;
- cb.failure=function(config){printErr("waitForCheckForm failed")};
- waitForCheckForm(cb);
- }
- function finalValidation(){
- let debug=true;
- if (debug) print("validate");
-
- let completed=true;
- for (f in config.fields){
- let field=config.fields[f];
- if (field.status!="DONE") {
- printErr("Missing entry for "+field.title);
- completed=false;
- }
- }
- if (debug) print("valid: "+completed);
- if (completed){
- modifyCRFEntry();
- }
- else{
- let el=document.getElementById(config.submitReportId);
- el.innerHTML="Form invalid";
- }
- }
- function modifyCRFEntry(){
- printErr("Form valid");
- let c1=new Object();
- c1.schemaName='lists';
- c1.queryName='crfEntry';
- c1.filterArray=[LABKEY.Filter.create('entryId',getCRFref())];
- c1.success=changeCRFStatus;
- LABKEY.Query.selectRows(c1);
- }
- function changeCRFStatus(data){
-
- let entry=data.rows[0];
- entry.formStatus=2;//Submitted
- let el=document.getElementById(config.submitReportId);
- el.innerHTML="Submitting form";
- let c1=new Object();
- c1.schemaName=data.schemaName;
- c1.queryName=data.queryName;
- c1.containerPath=config.containerPath;
- c1.rows=[entry];
- //close window upon success
- c1.success=sendEmail;
- LABKEY.Query.updateRows(c1);
- }
- function sendEmail(data){
- print('send email'+data.rows.length);
- let crf=data.rows[0]['entryId'];
- let formId=data.rows[0]['Form'];
- let link=LABKEY.ActionURL.getBaseURL();
- link+=LABKEY.ActionURL.getContainer();
- link+='/crf-visit.view?';
- link+='entryId='+crf;
- link+='&formId='+formId;
- //debug
- let recipients=new Array();
- let typeTo=LABKEY.Message.recipientType.to;
- //from crfManagers list
- let as=LABKEY.Message.createRecipient(typeTo,'andrej.studen@ijs.si');
- recipients.push(as);
- let typeHtml=LABKEY.Message.msgType.html;
- let typePlain=LABKEY.Message.msgType.plain;
- let msg=LABKEY.Message.createMsgContent(typeHtml,'<h2>Test</h2>');
- let msg1=LABKEY.Message.createMsgContent(typePlain,link);
- LABKEY.Message.sendMessage({
- msgFrom:'labkey@fmf.uni-lj.si',
- msgSubject:'Form submitted',
- msgRecipients:recipients,
- msgContent:[msg1],
- success: redirect
- });
- }
- function hideErr(){
- let el=config.document.getElementById("errorDiv");
- el.style.display="none";
- }
- function clearErr(){
- let el=config.document.getElementById("errorTxt");
- el.value="";
- }
- function showErr(){
- let el=config.document.getElementById("errorDiv");
- el.style.display="block";
- }
- function printErr(msg){
- showErr();
- el=config.document.getElementById("errorTxt");
- el.style.color="red";
- el.value+="\n"+msg;
- }
- //validation worker
- function checkForm(){
- let debug=true;
- let crfRef=getCRFref()
- config.status="UNKNOWN";
- //fields are queries that are part of the form
- //this allows validation to be performed on all
- //queries that are part of the form
- for (f in config.formConfig.fields){
- let field=config.formConfig.fields[f];
- field.status="UNKNOWN";
- if (debug)
- print("Setting status for "+f+" to "+ field.status);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName="lists";
- selectRows.queryName=f;
- //select only entry related to present form
- selectRows.filterArray=[LABKEY.Filter.create('crfRef',crfRef)];
- selectRows.success=checkData;
- selectRows.failure=function(errorObj){print("checkData failed.")};
- LABKEY.Query.selectRows(selectRows);
- }
- }
- function waitForCheckForm(cb){
- //watchdog - a timeout function
- //if control reaches the end of the function, it gets re-executed after the timeout
- //the body provides two alternative routes that end with return,
- //one for failure (if timeout gets executed too often)
- //one for success, which looks at the config object, which is in parallel
- //modified by the checkForm and as a daughter process, checkData functions
-
-
- let debug=true;
- //initalize counter
- if (!("i" in config)) config.i=0;
-
- //report execution depth
- if (debug) print("["+config.i+"] checkForm status "+config.status);
-
- //failure route
- if (config.i>100) {
- if (debug) print("executing failure");
- cb.failure(config);
- return;
- }
- //success route; count on other functions to modify config.status
- //this is very non-obviuos for linear programing, but
- //checkData and waitForCheckForm share the same memory space
- if (config.status=="DONE") {
- if (debug) print("executing success");
- cb.success(config);
- if (debug) print("success executed");
- return;
- }
- //this is the repeat route, neither pathway was indicated, stay in loop
- config.i+=1;
- setTimeout(function(){waitForCheckForm(cb);},1000);
- }
- function checkData(data){
- //insulated worker. Data corresponds to entry of a particular query
- let debug=true;
- if (debug) print("checkData ");
- let field=config.formConfig.fields[data.queryName];
- field.status="NONE";
- if (debug) print("Setting status for "+data.queryName+" to "+
- field.status);
- //this is the only test implemented - we should have at least one row in each of the queries
- //we could also have a more targeted functions, but their form escapes me at the moment
- if (data.rows.length>0)
- field.status="DONE";
-
- if (debug)
- print("checkData set status for "+data.queryName+" to "+field.status);
-
- //here we generate the flag/bell for the watchdog
- for (f in config.fields){
- let subField=config.fields[f];
- if (debug)
- print("checkData status["+f+"]: "+subField.status);
- //UNKNOW means we haven't visited it yet
- if (subField.status=="UNKNOWN") {
- if (debug) print("\t Status for "+f+" not set ["+ subField.status+"]");
- //we opt out - clearly, unchecked fields are still present
- return;
- }
-
- }
- //since we didn't exit for any field, we are done, and can set watchdog flag
- config.status="DONE";
- }
- //**************************************************
- //
- function onRemoveCRF(){
- let debug=true;
- if (debug){
- print("Removing CRF");
- }
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName="lists";
- selectRows.queryName="inputLists";
- selectRows.success=afterInputLists;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterInputLists(data){
- let debug=true;
- if (debug)
- print("After input lists");
- config.inputLists=data;
- config.inputListsIterator=0;
- removeCRFLoop();
- }
- function removeCRFLoop(){
- let debug=true;
- let i=config.inputListsIterator;
-
- if (debug)
- print("removeCRFLoop ["+i+"/"+config.inputLists.rows.length+"]");
- if (i>config.inputLists.rows.length){
- if (0) return;
- redirect();
- }
- let queryName="crfEntry";
- let idVar="entryId";
-
- if (i<config.inputLists.rows.length){
- queryName=config.inputLists.rows[i].queryName;
- idVar="crfRef";
- }
- if (debug)
- print("["+i+"/"+config.inputLists.rows.length+"] "+queryName+"/"+idVar);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName="lists";
- selectRows.queryName=queryName;
- selectRows.filterArray=[LABKEY.Filter.create(idVar,getCRFref())];
- selectRows.success=removeListCRF;
- selectRows.failure=skipListCRF;
- LABKEY.Query.selectRows(selectRows);
- }
- function removeListCRF(data){
- let debug=true;
- if (debug)
- print(data.queryName+": "+data.rows.length);
- config.inputListsIterator+=1;
-
- if (data.rows.length==0){
- removeCRFLoop();
- return;
- }
- let deleteRows=new Object();
- deleteRows.containerPath=config.containerPath;
- deleteRows.schemaName=data.schemaName;
- deleteRows.queryName=data.queryName;
- deleteRows.success=function(data){removeCRFLoop()};
- deleteRows.rows=data.rows;
- LABKEY.Query.deleteRows(deleteRows);
-
- }
- function skipListCRF(errorInfo){
- let debug=true;
- if (debug)
- print("Error in removeCRF: "+errorInfo.exception);
- config.inputListsIterator+=1;
-
- removeCRFLoop();
-
- }
- function redirect(){
- let formUrl="begin";
- let params=new Object();
- params.name=formUrl;
- params.pageId="CRF";
- let containerPath= config.containerPath;
-
- // This changes the page after building the URL.
- //Note that the wiki page destination name is set in params.
-
- var homeURL = LABKEY.ActionURL.buildURL("project", formUrl , containerPath, params);
- print("Redirecting to "+homeURL);
-
- window.location = homeURL;
-
- }
- function checkBlob(){
- print("checkBlob: "+config.blob);
- if (config.blob) {
- clearInterval(config.blobInterval);
- config.a.href = config.window.URL.createObjectURL(config.blob);
- print("HREF: "+config.a.href);
- config.a.download = 'test.pdf';
- config.a.click();
- config.window.URL.revokeObjectURL(config.a.href);
- }
- config.count=config.count+1;
- print("Eval: "+config.count);
- if (config.count>100){
- clearInterval(config.blobInterval);
- }
- }
- function printForm(){
- config.doc=new PDFDocument();
- //config.doc.end();
- let stream = config.doc.pipe(blobStream()).on("finish",function(){
- config.blob=stream.toBlob("application/pdf");});
-
- print("BLob: "+config.blob);
- config.a = config.document.createElement("a");
- config.document.body.appendChild(config.a);
- config.a.innerHTML="Download PDF";
- config.a.style = "display: none";
- config.count=0;
- //run until blob is set
- config.blobInterval=setInterval(checkBlob,1000);
- //pick data from crfForm list
- print("Printing form");
- printHeader();
- setData(formatPrintData);
- }
- function printHeader(){
- config.doc.fontSize(25).text(config.formConfig.form['formName']);
- config.doc.moveDown();
- let crfEntry=config.formConfig.crfEntry;
- let site=config.formConfig.site;
- let val=new Object();
- let user=config.formConfig.user;
- val['A']={o:crfEntry,f:'EudraCTNumber',t:'Eudra CT Number'};
- val['B']={o:crfEntry,f:'StudyCoordinator',t:'Study Coordinator'};
- val['C']={o:crfEntry,f:'StudySponsor',t:'Study Sponsor'};
- val['D']={o:site,f:'siteName',t:'Site'};
- val['E']={o:site,f:'sitePhone',t:'Phone'};
- val['F']={o:user,f:'DisplayName',t:'Investigator'};
- for (let f in val){
- print('Printing for '+f);
- let e=val[f];
- let entry=new Object();
- entry[f]=e.o[e.f];
- printPDF(entry,
- {name:f,caption:e.t,type:'string'},null);
- }
- config.doc.moveDown();
- }
- function formatPrintData(){
- qS=config.formConfig.dataQueries;
- for (let q in qS){
- print('Setting up '+q);
- let qData=qS[q];
- print('Number of rows: '+qData.rows.length);
- if (qData.rows.length>0){
- config.doc.fontSize(20).text(qData.title);
- }
- for (let i=0;i<qData.rows.length;i++){
- let entry=qData.rows[i];
- for (let f in qData.fields){
- let field=qData.fields[f];
- let lookup=null;
- if (field.lookup){
- lookup=config.formConfig.lookup[field.lookup.queryName];
- }
- if (field.hidden) continue;
- printPDF(entry,field,lookup);
- }
- }
- config.doc.moveDown();
- }
- print("All done");
- config.doc.end();
- }
- function printPDF(entry,field,lookup){
- //object field should have a name, type, caption
- //entry should have field.name
- //lookup is null or has a lookup table LUT
- //for value v of entry[field.name]
- //
- //the total width of a A4 page is 598 px,
- //left margin is 72. With a right margin of 50,
- //the total available with is 476 px.
-
- let w=476;
- let spacing=25;
- let w1=(w-spacing)*0.5;
- let fontSize=14;
-
- print('printPDF: entry['+field.name+']='+entry[field.name]);
- let v=entry[field.name];
- if (lookup!=null){
- v=lookup.LUT[v];
- }
- print('printPDF: field type:'+field.type);
- if (field.type=="date"){
- let d=new Date(v);
- v=d.getDate()+'/'+(d.getMonth()+1)+'/'+d.getFullYear();
- }
- if (v===null) v=' / ';
- if (v===undefined) v=' / ';
- //measure text
- let label=field.caption;
- let opt={width:w1};
- config.doc.fontSize(fontSize);
-
- //for more eloquent display the height of the text
- //can be measured prior to output
- //use currentLineHeight to scale height
- //let lineH=config.doc.currentLineHeight(1);
- //let h=config.doc.heightOfString(label,opt)/lineH;
- //print label
- config.doc.font('Courier').text(label,opt);
-
- //align last row of description w/ first row of value
- config.doc.moveUp();
- //store x value for later use
- let tx=config.doc.x;
- let ty=config.doc.y;
- //shift for value output
- config.doc.x+=w1+spacing;
-
- config.doc.font('Courier-Bold').text(v,opt);
- //restore x value
- config.doc.x=tx;
-
- }
- function generateMasterForm(){
- generateDebugSection();
- setFormConfig();
- }
- function populateBasicData(){
-
- config.document.getElementById('eudraCTNumber').innerHTML=
- config.formConfig.crfEntry.EudraCTNumber;
- config.document.getElementById('studyCoordinator').innerHTML=
- config.formConfig.crfEntry.StudyCoordinator;
- config.document.getElementById('studySponsor').innerHTML=
- config.formConfig.crfEntry.StudySponsor;
- config.document.getElementById('siteName').innerHTML=
- config.formConfig.site['siteName'];
- config.document.getElementById('sitePhone').innerHTML=
- config.formConfig.site['sitePhone'];
- config.document.getElementById('investigatorName').innerHTML=
- config.formConfig.user['DisplayName'];
- }
- function afterConfig(){
- let debug=true;
- if (debug)
- print("afterConfig");
-
- //schedule basic data for later
- populateBasicData();
- let rows=config.formConfig.formStatusData.rows;
- for (let i=0; i<rows.length; i++){
- let key=rows[i].Key;
- if (config.formConfig.crfEntry["FormStatus"]!=key)
- continue;
- config.formConfig.formStatus=rows[i].formStatus;
- break;
- }
- let formStatus=config.formConfig.formStatus;
- print("Generating buttons for formStatus \""+ formStatus+"\"");
-
- let done="FALSE";
- if (formStatus=="Submitted"){
- generateButton("submitDiv","Complete submission",
- "Upload to database",onDatabaseUpload);
- generateButton("submitDiv","Review submission",
- "Ask for further review",onUpdateForReview);
- generateButton("submitDiv","Remove submission",
- "Remove CRF form",onRemoveCRF);
- done="TRUE";
- }
- if (formStatus=="Approved"){
- generateButton("submitDiv","Review submission",
- "Restore form for further review",onUpdateForReview);
- generateButton("submitDiv","Print form",
- "Generate PDF",printForm);
- done="TRUE";
- }
- if (done=="FALSE"){
- //all other states, particularly Review and In progress
- generateButton("submitDiv","Complete submission",
- "Submit",onSubmit);
- generateButton("submitDiv","Remove submission",
- "Remove CRF form",onRemoveCRF);
-
- }
- generateButton("submitDiv","Done","Exit",redirect);
- print('Here');
- //here we should get data. For now, just initialize objects that will hold data
- //config.formConfig.dataFields=new Object();
- //config.formConfig.entries=new Object();
- setDataLayout(afterDataLayout);//callback is afterDataLayout
- }
-
- function afterDataLayout(){
- setData(afterData);//callback is afterData
- }
- function afterData(){
- let rowsSetup=config.formConfig.formSetup.rows;
- for (let i=0;i<rowsSetup.length;i++){
- let entry=rowsSetup[i];
- print("entry[showFlag]: "+entry["showFlag"]);
- let queryName=config.formConfig.queryMap[entry['queryName']];
-
- let additionalData=new Object();
- setAdditionalData(additionalData,entry);
- //section fits one dataset/list
- generateSection(queryName,entry["title"],queryName, additionalData);
- }
- }
- //entry point from generateMasterForm
- function setFormConfig(){
- //add object to store form related data
- config.formConfig=new Object();
- let debug=true;
- if (debug)
- print("generateMasterForm1");
-
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='lists';
- selectRows.queryName='crfEntry';
- //use first-> we must first establish link to the rigth crf entry
- selectRows.filterArray=[LABKEY.Filter.create('entryId',getCRFrefFirst())];
- //store form related data to this object
- selectRows.success=afterCRFEntry;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterCRFEntry(data){
- config.formConfig.crfEntry=data.rows[0];
- print("Setting crfEntry (x) to "+config.formConfig.crfEntry["entryId"]);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='lists';
- selectRows.queryName='site';
- selectRows.filterArray= [
- LABKEY.Filter.create('siteNumber',config.formConfig.crfEntry.Site)];
- selectRows.success=afterSite;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterSite(data){
- print("afterSite");
- config.formConfig.site=data.rows[0];
- print("Setting site name to "+
- config.formConfig.site["siteName"]
- +" phone: "+config.formConfig.site["sitePhone"]);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='core';
- selectRows.queryName='Users';
- selectRows.filterArray=[
- LABKEY.Filter.create('siteNumber',
- config.formConfig.crfEntry.UserId)];
- selectRows.success=afterUser;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterUser(data){
- config.formConfig.user=data.rows[0];
- print("Setting user to "+config.formConfig.user["DisplayName"]);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='study';
- selectRows.queryName='Study';
- selectRows.columns="SubjectColumnName";
- selectRows.success=afterStudy;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterStudy(data){
- config.formConfig.studyData=data.rows[0];
- print("XSetting participantField to "+config.formConfig.studyData["SubjectColumnName"]);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='lists';
- selectRows.queryName='FormStatus';
- selectRows.filterArray=[];
-
- selectRows.success=afterFormStatus;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterFormStatus(data){
- print("afterFormStatus: ");
- config.formConfig.formStatusData=data;
-
- let qconfig=new Object();
- qconfig.schemaName="lists";
- qconfig.queryName="Forms";
- qconfig.filterArray=[LABKEY.Filter.create('Key',config.formId)];
-
- //qconfig.filterArray=[LABKEY.Filter.create('formStatus',1)]
- qconfig.success=afterForms1;
- LABKEY.Query.selectRows(qconfig);
- }
- function afterForms1(data){
- print("afterForms1: ");
- config.formConfig.form=data.rows[0];
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName='lists';
- selectRows.queryName='FormSetup';
- selectRows.filterArray=[LABKEY.Filter.create('formName',config.formId)];
- selectRows.success=afterFormSetup;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterFormSetup(data){
- config.formConfig.formSetup=data;
- print("Number of datasets for form ["+config.formId+"]: "+
- config.formConfig.formSetup.rows.length);
- let fields=config.formConfig.formSetup.metaData.fields;
- //get the lookup for queryName column
- let formQueryName='queryName';
- let field="NONE";
- for (f in fields){
- if (fields[f]['name']!=formQueryName) continue;
- field=fields[f];
- break;
- }
- let lookup=field.lookup;
- print("Getting dataset names from "+lookup.queryName);
- let selectRows=new Object();
- selectRows.containerPath=config.containerPath;
- selectRows.schemaName=lookup.schemaName;
- selectRows.queryName=lookup.queryName;
- selectRows.success=afterFormDatasets;
- LABKEY.Query.selectRows(selectRows);
- }
- function afterFormDatasets(data){
- print('afterFormDatasets: '+data.rows.length);
- config.formConfig.formDatasets=data;//inputLists
- config.formConfig.fields=new Object();
- config.formConfig.queryMap=new Object();
- let rows=config.formConfig.formSetup.rows;
- //should skip report only rows
- for (let i=0;i<rows.length;i++){
- let entry=rows[i];
- let reviewField=(entry['showFlag']=='REVIEW');
- let queryId=entry['queryName'];
- let lookupRows=config.formConfig.formDatasets.rows;
- print('QueryID['+i+']='+queryId);
- let dentry;
- for (let j=0;j<lookupRows.length;j++){
-
- if (queryId!=lookupRows[j]['Key']) continue;
- dentry=lookupRows[j];
- break;
- }
- let qName=dentry['queryName'];
- //update list of dataset formConfig is observing (fields/queryMap)
- while (1){
- //review contains no data
- if (reviewField) break;
- //already in fields
- if (qName in config.formConfig.fields) break;
- config.formConfig.fields[qName]=new Object();
- break;
- }
- while(1){
- //already done
- if (queryId in config.formConfig.queryMap) break;
- config.formConfig.queryMap[queryId]=qName;
- break;
- }
- if (reviewField) continue;
- //only do this for real lists
- let field=config.formConfig.fields[qName];
- field.title=entry['title'];
- field.queryId=queryId;
- }
- print("List of datasets in form : ");
- for (f in config.formConfig.fields){
- let field=config.formConfig.fields[f];
- print("\t"+f+" ID: "+field.queryId+' title '+field.title);
- }
- afterConfig();
- }
- //>>>>>>>>>>>>>>>>>new>>>>>>>>>>>>
- function setDataLayout(cb){
- let rowsSetup=config.formConfig.formSetup.rows;
- config.formConfig.dataQueries=new Object();
- let dS=config.formConfig.dataQueries;//reference only
- let qMap=config.formConfig.queryMap;
- config.formConfig.lookup=new Object();
- for (let i=0;i<rowsSetup.length;i++){
- let entry=rowsSetup[i];
- //skip review rows
- if (entry['showFlag']=='REVIEW')
- continue;
- let queryId=entry['queryName'];
- let queryName=qMap[entry['queryName']];
- dS[queryName]=new Object();
- dS[queryName].title=entry['title'];
- if (entry['showQuery']!="NONE"){
- let sqName=entry['showQuery'];
- dS[sqName]=new Object();
- dS[sqName].title=findTitle(sqName);
-
- }
- }
- //always add reviews
- //
- config.formConfig.dataQueries['reviewComments']=new Object();
- //perhaps we will need queryId, but this is stuff for later
- for (q in config.formConfig.dataQueries){
- //callback will be a watchdog and will complete only
- //when all data will be gathered
- let dq=config.formConfig.dataQueries[q];
- dq.collectingLayout="INITIALIZED";
- let selectRows=new Object();
- selectRows.queryName=q;
- selectRows.schemaName='lists';
- //we are only interested in metadata
- selectRows.success=function(data){afterDatasets(data,cb);}
- LABKEY.Query.selectRows(selectRows);
- }
- }
- function findTitle(queryName){
- //find by name from formDatasets
- //and set associated title as title
- let rows=config.formConfig.formDatasets.rows;
- for (let i=0;i<rows.length;i++){
- let entry=rows[i];
- if (entry['queryName']!=queryName) continue;
- return entry['title'];
- }
- return "NONE";
- }
- //this happens after the for loop, so all dataQueries objects are set
- function afterDatasets(data,cb){
- let qobject=config.formConfig.dataQueries[data.queryName];
- print("Inspecting layout for "+data.queryName+" "+qobject);
- qobject.fields=data.metaData.fields;
- qobject.collectingLayout="STARTED";
- //qobject.started="TRUE";
- qobject.lookup=new Object();//keep track of objects
- let i=0;
- for (let f in qobject.fields){
- //anything else is simple but lookup
- let field=qobject.fields[f];
- if (!("lookup" in field)) continue;
- qobject.lookup[f]="PENDING";
- print("Adding pending lookup for field "+f);
- if (field.lookup.queryName in config.formConfig.lookup){
- qobject.lookup[f]="DONE";
- continue;
- }
- print("Setting up query for field "+f);
- config.formConfig.lookup[field.lookup.queryName]=new Object();
- let lObject=config.formConfig.lookup[field.lookup.queryName];
- lObject.keyColumn=field.lookup.keyColumn;
- lObject.displayColumn=field.lookup.displayColumn;
- let selectRows=new Object();
- selectRows.schemaName=field.lookup.schemaName;
- selectRows.queryName=field.lookup.queryName;
- selectRows.columns=field.lookup.keyColumn+","+field.lookup.displayColumn;
- //wait for all lookups to return
- selectRows.success=function(data){addLookup(data,qobject,f,cb);};
- print("Sending query: ["+field.lookup.queryName+"] "+field.lookup.keyColumn+'/'+field.lookup.displayColumn);
- LABKEY.Query.selectRows(selectRows);
- i+=1;
- }
- if (i==0){
- print("No lookups for "+data.queryName);
- qobject.collectingLayout="FINISHED";
- }
- //check if done (both here and in lookup
- //this only passes if no lookups are anywhere in the dataset assembly
- if (!dataLayoutSet()) return;
- cb();
- }
- function addLookup(data,qobject,f,cb){
- print("Adding lookup "+data.queryName+' '+qobject+' '+f);
- let lObject=config.formConfig.lookup[data.queryName];
- lObject.LUT=new Array();//key to value
- lObject.ValToKey=new Array();//value to key
- let key=lObject.keyColumn;
- let val=lObject.displayColumn;
- for (let i=0;i<data.rows.length;i++){
- lObject.LUT[data.rows[i][key]]=data.rows[i][val];
- lObject.ValToKey[data.rows[i][val]]=data.rows[i][key];
- }
- qobject.lookup[f]="DONE";
- if (!dataLayoutSet()) return;
- cb();
- }
- function dataLayoutSet(){
- print("Checking layout completeness");
- let dq=config.formConfig.dataQueries;
- for (f in dq){
- print("["+f+"]: "+dq[f].collectingLayout);
- if (dq[f].collectingLayout=="INITIALIZED")
- return 0;
- if (dq[f].collectingLayout=="FINISHED")
- continue; //OK
- let qobject=dq[f];
- for (q in qobject.lookup){
- if (qobject.lookup[q]=="DONE") {
- print("["+f+"/"+q+"]: DONE");
- continue;//OK
- }
- print("["+f+"/"+q+"]: "+qobject.lookup[q]);
- return 0;
- }
- dq[f].collectingLayout="FINISHED";
- }
- print("Success");
- return 1;
- }
- function setData(cb){
- //collect data and execute callback cb for queries in cb.queryList
- for (q in config.formConfig.dataQueries){
- let fQuery=config.formConfig.dataQueries[q];
- fQuery.collectingData="STARTED";
- let selectRows=new Object();
- selectRows.queryName=q;
- selectRows.schemaName='lists';
- selectRows.filterArray=[
- LABKEY.Filter.create("crfRef",getCRFref())
- ];
- selectRows.success=function(data){assembleData(data,cb);};
- LABKEY.Query.selectRows(selectRows);
- }
- }
- function assembleData(data,cb){
- let fQuery=config.formConfig.dataQueries[data.queryName];
- fQuery.rows=data.rows;
- fQuery.collectingData="FINISHED";
- for (q in config.formConfig.dataQueries){
- let dq=config.formConfig.dataQueries[q];
- //print("assembleData ["+q+"]: "+dq.collectingData);
- if (dq.collectingData=="STARTED") return;
- }
- cb();
- }
- function uploadFile(inputElement,context){
- //context should have ID and dirName attributes;
- //path will be dirName/ID/fieldName_ID.suf
- //where suf is identical to localPath content picked from
- //inputElement
- print('uploadFile: '+inputElement.value+'/');
- if (inputElement.type=="text") return;
- print('uploadFile: '+inputElement.files+'/');
- print('uploadFile: '+inputElement.files.length+'/');
- if (inputElement.files.length>0){
- let file=inputElement.files[0];
- print('uploadFile: '+inputElement.value+'/'+file.size);
- }
- let url=LABKEY.ActionURL.getBaseURL();
- url+='_webdav';
- url+=LABKEY.ActionURL.getContainer();
- url+='/@files';
- url+='/'+context['dirName'];
- print('uploadFile url: '+url);
- let uploadConfig=new Object();
- uploadConfig.inputElement=inputElement;
- uploadConfig.context=context;
- uploadConfig.url=url;
- uploadConfig.success=afterBaseDir;
- uploadConfig.failure=tryMakeDir;
- webdavCheck(uploadConfig);
- }
- function afterBaseDir(cfg){
- print('afterBaseDir');
- cfg.url+='/'+cfg.context['ID'];
- cfg.success=afterIDDir;
- cfg.failure=tryMakeDir;
- webdavCheck(cfg);
- }
- function afterIDDir(cfg){
- print('afterIDDir');
- if (cfg.inputElement.files.length==0){
- print('No files found');
- return;
- }
- let file=cfg.inputElement.files[0];
- print('Uploading '+file.name);
- let suf=file.name.split('.').pop();
- cfg.url+='/'+cfg.context['ID']+'.'+suf;
- cfg.success=afterUpload;
- cfg.failure=onFailure;
- cfg.data=file;
- webdavPut(cfg);
- }
- function afterUpload(cfg){
- print('afterUpload');
- }
- function tryMakeDir(cfg){
- print('tryMakeDir '+cfg.url);
- cfg.failure=onFailure;
- webdavMakeDir(cfg);
- }
- function request(cfg,verb,data){
- print('request['+verb+'] '+cfg.url);
- let connRequest=new XMLHttpRequest();
- connRequest.addEventListener("loadend",
- function(){checkResponse(connRequest,cfg);});
- connRequest.open(verb, cfg.url);
- connRequest.send(data);
- //print('request['+verb+'] sent');
- }
- function checkResponse(xrq,cfg){
- //print('checkResponse: readyState '+xrq.readyState);
- //print('checkResponse: status '+xrq.status);
- if (xrq.status<400) {
- //client errors 400-499
- //server errors 500-599
- cfg.success(cfg);
- return;
- }
- cfg.status=xrq.status;
- cfg.failure(cfg);
- }
- function webdavMakeDir(cfg){ request(cfg,'MKCOL',null);}
- function webdavCheck(cfg) { request(cfg,'GET',null);}
- function webdavPut(cfg) { request(cfg,'PUT',cfg.data);}
- function onFailure(cfg){
- print('request failed with status='+cfg.status);
- }
|