11,13d10
< // https://www.rjmprogramming.com.au/PHP/CalendarChart/calendar_chart.php?title=Red%20Sox%20Attendance&desc=Red%20Sox%20Attendance&data=[newDate(2023,11,03),34],[newDate(2023,11,18),56]
< // https://www.rjmprogramming.com.au/PHP/TimelineChart/timeline_chart.php?title=US%20President&desc=US%20President&data=[~one~,newDate(2023,11,10),newDate(2023,11,12)],[~two~,newDate(2023,11,24),newDate(2023,11,26)]
< // https://www.rjmprogramming.com.au/PHP/AnnotatedTimelineChart/index.php?title=Sold%20Pencils%20and%20Sold%20Pens&desc1=Sold%20Pencils&title1=Sold%20Pencils%20title1&text1=Sold%20Pencils%20text1&desc2=Sold%20Pens&title2=Sold%20Pens%20title2&text2=Sold%20Pens%20text2&data=[newDate(2023,11,10),5,~adbh~,~teh~,7,~trh~,~trh~],[newDate(2023,11,20),3,~teh~,~teh~,8,~tqh~,~trh~]
27c24
<  var arrflds=[], dtarrflds=[];
---
>  var arrflds=[];
48c45
<  var formhtml="<hr><div style='width:100%;background-color:cyan;margin:5 5 5 5;border-radius:10px;'>" + prefix + "<h1>&nbsp;Google Chart Histogram &amp; Pie Chart XML Data Twinning <select id=selsug onchange=populate(this);><option value=''>Ideas ...</option><option value=\"//data.cityofnewyork.us/api/views/c3uy-2p5r/rows.xml#/response/row/row[name='Nitrogen dioxide (NO2)' and geo_place_name='Bedford Stuyvesant - Crown Heights']/*[self::start_date or self::data_value]#Air Quality - Nitrogen dioxide (NO2) - Bedford Stuyvesant - Crown Heights - City of New York USA#~\">Air Quality - Nitrogen dioxide (NO2) - Bedford Stuyvesant - Crown Heights - City of New York USA</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/make#Electric Vehicle Population Data - State of Washington USA - Make#~\">Electric Vehicle Population Data - State of Washington USA - Make</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/model#Electric Vehicle Population Data - State of Washington USA - Model#~\">Electric Vehicle Population Data - State of Washington USA - Model</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/*[self::make or self::model]#Electric Vehicle Population Data - State of Washington USA - Make and Model#~#Make/Model\">Electric Vehicle Population Data - State of Washington USA - Make and Model</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/*[self::geocoded_column]#Electric Vehicle Population Data - State of Washington USA - Locations#~\">Electric Vehicle Population Data - State of Washington USA - Locations</option><option value=\"//data.ny.gov/api/views/d6yy-54nr/rows.xml#/response/row/row/winning_numbers#Powerball Winning Numbers Since 2010 - State of New York USA#+\">Powerball Winning Numbers Since 2010 - State of New York USA</option><option value=\"//data.ny.gov/api/views/d6yy-54nr/rows.xml#/response/row/row/child::*#Powerball Winning Numbers Since 2010 - State of New York USA#+###true\">Powerball Winning Numbers Since 2010 - State of New York USA - Prompted</option></select></h1><h3>&nbsp;RJM Programming - December, 2023</h3><h4>&nbsp;Thanks to https://catalog.data.gov/dataset?q=&sort=views_recent+desc and https://data.ny.gov/api/views/d6yy-54nr/rows.xml and https://www.w3schools.com/xml/xpath_examples.asp</h4><br><br><form id=myfis method=GET action='" + formurl + "'><div id=dfis></div><br>&nbsp;<input onblur=titletweak(this); type=text name=xtitle id=xtitle title='Histogram and Pie Chart title' placeholder='Histogram and Pie Chart title' value='" + xtitleis + "' style=width:50%;background-color:#f0f0f0;></input>&nbsp;title&nbsp;for<br>&nbsp;<input type=text name=xurl id=xurl title='Public data XML URL' placeholder='Public data XML URL' value='" + xurlis + "' style=width:50%;background-color:#f0f0f0;></input>&nbsp;XML&nbsp;public&nbsp;data&nbsp;items&nbsp;URL<br>&nbsp;<select onchange=titletweak(this); id=xbasis name=xbasis title='Measure basis' style=background-color:#f0f0f0;>" + ("<option value=count>Count</option><option value=mean>Mean (for numeric)</option><option value=median>Median (for numeric)</option><option value=mode>Mode (for numeric)</option><option value=range>Range (for numeric)</option><option value=sum>Sum (for numeric)</option><option value=deviation>Standard Deviation (for numeric)</option>").replace(froms,tos) + "</select>&nbsp;of&nbsp;position&nbsp;<input onchange=titletweak(this); onblur=titletweak(this); type=" + typepos + " " + dataprefix + "onclick=\"if (this.value.length == 0) { this.value='0'; } this.type='number';\" placeholder='Not applicable (ie all) [0]' id=xcountbasisposition name=xcountbasisposition value='" + xposis + "' min=0 step=1 style=width:10%;background-color:#f0f0f0;></input><br>&nbsp;<input type=text name=xpath id=xpath title='XML XPath' placeholder='XML XPath' value=\"" + xpathis + "\" style=width:40%;background-color:#f0f0f0;></input>&nbsp;XML&nbsp;XPath&nbsp;<span id=sask><input onchange=promptabout(this); type=checkbox id=xask" + cbextra + ">Prompted About</input></span><span id=spanflds>" + fieldsel + "</span><br>&nbsp;<input type=text name=xdelim id=xdelim title='XML Data Member delimiter' placeholder='XML Data Member delimiter' value='" + xdelimis + "' style=width:40px;background-color:#f0f0f0;></input>&nbsp;delimits&nbsp;data&nbsp;items&nbsp;regarding&nbsp;position<br><br>&nbsp;<input type=submit value=Display style=background-color:yellow;border-radius:100px;></input>&nbsp;<input type=submit name=email id=email value=Email style=background-color:yellow;border-radius:100px;></input>&nbsp;<input onclick=\"var smsis=doprompt(this); if (smsis != null) { if (smsis.trim() != '') { this.value=smsis; } }\" name=sms id=sms type=submit value=SMS style=background-color:yellow;border-radius:100px;></input><br><br></form>" + suffix + "</div><iframe id=iffld style=display:none; onload=checkif(this); src='" + xurlis.replace('/' + xurlis.split('/')[eval(-1 + xurlis.split('/').length)], '/') + "'></iframe>";
---
>  var formhtml="<hr><div style='width:100%;background-color:cyan;margin:5 5 5 5;border-radius:10px;'>" + prefix + "<h1>&nbsp;Google Chart Histogram &amp; Pie Chart XML Data Twinning <select id=selsug onchange=populate(this);><option value=''>Ideas ...</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/make#Electric Vehicle Population Data - State of Washington USA - Make#~\">Electric Vehicle Population Data - State of Washington USA - Make</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/model#Electric Vehicle Population Data - State of Washington USA - Model#~\">Electric Vehicle Population Data - State of Washington USA - Model</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/*[self::make or self::model]#Electric Vehicle Population Data - State of Washington USA - Make and Model#~#Make/Model\">Electric Vehicle Population Data - State of Washington USA - Make and Model</option><option value=\"//data.wa.gov/api/views/f6w7-q2d2/rows.xml#/response/row/row/*[self::geocoded_column]#Electric Vehicle Population Data - State of Washington USA - Locations#~\">Electric Vehicle Population Data - State of Washington USA - Locations</option><option value=\"//data.ny.gov/api/views/d6yy-54nr/rows.xml#/response/row/row/winning_numbers#Powerball Winning Numbers Since 2010 - State of New York USA#+\">Powerball Winning Numbers Since 2010 - State of New York USA</option><option value=\"//data.ny.gov/api/views/d6yy-54nr/rows.xml#/response/row/row/child::*#Powerball Winning Numbers Since 2010 - State of New York USA#+###true\">Powerball Winning Numbers Since 2010 - State of New York USA - Prompted</option></select></h1><h3>&nbsp;RJM Programming - December, 2023</h3><h4>&nbsp;Thanks to https://catalog.data.gov/dataset?q=&sort=views_recent+desc and https://data.ny.gov/api/views/d6yy-54nr/rows.xml and https://www.w3schools.com/xml/xpath_examples.asp</h4><br><br><form id=myfis method=GET action='" + formurl + "'><div id=dfis></div><br>&nbsp;<input onblur=titletweak(this); type=text name=xtitle id=xtitle title='Histogram and Pie Chart title' placeholder='Histogram and Pie Chart title' value='" + xtitleis + "' style=width:50%;background-color:#f0f0f0;></input>&nbsp;title&nbsp;for<br>&nbsp;<input type=text name=xurl id=xurl title='Public data XML URL' placeholder='Public data XML URL' value='" + xurlis + "' style=width:50%;background-color:#f0f0f0;></input>&nbsp;XML&nbsp;public&nbsp;data&nbsp;items&nbsp;URL<br>&nbsp;<select onchange=titletweak(this); id=xbasis name=xbasis title='Measure basis' style=background-color:#f0f0f0;>" + ("<option value=count>Count</option><option value=mean>Mean (for numeric)</option><option value=median>Median (for numeric)</option><option value=mode>Mode (for numeric)</option><option value=range>Range (for numeric)</option><option value=sum>Sum (for numeric)</option><option value=deviation>Standard Deviation (for numeric)</option>").replace(froms,tos) + "</select>&nbsp;of&nbsp;position&nbsp;<input onchange=titletweak(this); onblur=titletweak(this); type=" + typepos + " " + dataprefix + "onclick=\"if (this.value.length == 0) { this.value='0'; } this.type='number';\" placeholder='Not applicable (ie all) [0]' id=xcountbasisposition name=xcountbasisposition value='" + xposis + "' min=0 step=1 style=width:10%;background-color:#f0f0f0;></input><br>&nbsp;<input type=text name=xpath id=xpath title='XML XPath' placeholder='XML XPath' value='" + xpathis + "' style=width:40%;background-color:#f0f0f0;></input>&nbsp;XML&nbsp;XPath&nbsp;<span id=sask><input onchange=promptabout(this); type=checkbox id=xask" + cbextra + ">Prompted About</input></span><span id=spanflds>" + fieldsel + "</span><br>&nbsp;<input type=text name=xdelim id=xdelim title='XML Data Member delimiter' placeholder='XML Data Member delimiter' value='" + xdelimis + "' style=width:40px;background-color:#f0f0f0;></input>&nbsp;delimits&nbsp;data&nbsp;items&nbsp;regarding&nbsp;position<br><br>&nbsp;<input type=submit value=Display style=background-color:yellow;border-radius:100px;></input>&nbsp;<input type=submit name=email id=email value=Email style=background-color:yellow;border-radius:100px;></input>&nbsp;<input onclick=\"var smsis=doprompt(this); if (smsis != null) { if (smsis.trim() != '') { this.value=smsis; } }\" name=sms id=sms type=submit value=SMS style=background-color:yellow;border-radius:100px;></input><br><br></form>" + suffix + "</div><iframe id=iffld style=display:none; onload=checkif(this); src='" + xurlis.replace('/' + xurlis.split('/')[eval(-1 + xurlis.split('/').length)], '/') + "'></iframe>";
114,115c111,112
<     if (path.indexOf(' or self:') != -1) {
<       ixatatime=eval('' + path.split(' or self:').length);
---
>     if (path.indexOf(' or ') != -1) {
>       ixatatime=eval('' + path.split(' or ').length);
173c170
<               askp=prompt('Is this type of field "' + arrflds[eval('' + firstset.length)] + '" ' + ('[' + dtarrflds[eval('' + firstset.length)] + ']').replace(/^\[\]$/g, '') + ' data to be output ... ' + result.childNodes[0].nodeValue, result.childNodes[0].nodeValue);
---
>               askp=prompt('Is this type of field "' + arrflds[eval('' + firstset.length)] + '" data to be output ... ' + result.childNodes[0].nodeValue, result.childNodes[0].nodeValue);
431c428
<               askp=prompt('Is this type of field "' + arrflds[eval('' + firstset.length)] + '" ' + ('[' + dtarrflds[eval('' + firstset.length)] + ']').replace(/^\[\]$/g, '') + ' data to be output ... ' + nodes[eval(i + iioff)].childNodes[0].nodeValue, nodes[eval(i + iioff)].childNodes[0].nodeValue);
---
>               askp=prompt('Is this type of field "' + arrflds[eval('' + firstset.length)] + '" data to be output ... ' + nodes[eval(i + iioff)].childNodes[0].nodeValue, nodes[eval(i + iioff)].childNodes[0].nodeValue);
609d605
<     var numtabcols=[], recsare=[], kin=0, okayhere=true, swaponeandzero=false;
613,678d608
<          numtabcols=datasofar.split('~')[1].split('~')[0].split(String.fromCharCode(32));
<          if (eval('' + numtabcols.length) >= 2) {
<                    if (eval('' + numtabcols.length) > 2) {
<                      for (kin=2; kin<eval('' + numtabcols.length); kin++) {
<                        if (numtabcols[kin].trim() == '') {  
<                           okayhere=false;
<                        } else if (numtabcols[kin].trim().replace(/\./g,'').replace(/\-/g,'').replace(/0/g,'').replace(/1/g,'').replace(/2/g,'').replace(/3/g,'').replace(/4/g,'').replace(/5/g,'').replace(/6/g,'').replace(/7/g,'').replace(/8/g,'').replace(/9/g,'') != '') {
<                           okayhere=false;
<                        }
<                      }
<                    }
<                 console.log('okayhere=' + okayhere + ' and numtabs.length=' + numtabcols.length);
<            if (numtabcols[1].trim() != '' && okayhere) {
<              if (numtabcols[1].indexOf('T') == 10) { swaponeandzero=true;  }
<                 console.log('Okayhere=' + okayhere + ' and numtabs.length=' + numtabcols.length + ' +++ ' + datasofar.split('~')[1].split('~')[0] + ' ... ' + numtabcols[1]);
<              if (swaponeandzero || numtabcols[1].trim().replace(/\./g,'').replace(/\-/g,'').replace(/0/g,'').replace(/1/g,'').replace(/2/g,'').replace(/3/g,'').replace(/4/g,'').replace(/5/g,'').replace(/6/g,'').replace(/7/g,'').replace(/8/g,'').replace(/9/g,'') == '') {
<                 console.log('OkayHere=' + okayhere + ' and numtabs.length=' + numtabcols.length);
<                console.log(datasofar);
<                // [~2011-12-01T00:00:00 22.88~,2]
<                var inpts=datasofar.split('[');
<                var origst='', newst='', arrorig=[];
<                for (var jinpts=1; jinpts<inpts.length; jinpts++) {
<                  origst='[' + inpts[jinpts].split(']')[0] + ']';
<                  arrorig=origst.split(' ');
<                  if (eval('' + arrorig.length) >= 2) {
<                    //newst=arrorig[0] + '~,' + arrorig[1].split('~')[0].replace(/\ /g, ',') + ']';
<                    if (swaponeandzero) {
<                    newst='[~' + arrorig[1] + '~,' + arrorig[0].replace('[~','') + ',' + origst.split(arrorig[1] + ' ')[1].split('~')[0].replace(/\ /g, ',') + ']';
<                    } else {
<                    newst=arrorig[0] + '~,' + origst.replace(arrorig[0] + ' ','').split('~')[0].replace(/\ /g, ',') + ']';
<                    }
<                    datasofar=datasofar.replace(origst, newst);
<                    document.getElementById('xlvalue').value='Measure';
<                    document.getElementById('xbvalue').value='Measure';
<                    if (eval('' + arrorig.length) > 2) {
<                      for (kin=2; kin<=eval('' + arrorig.length); kin++) {
<                    document.getElementById('xlvalue').value+=',Measure';
<                    document.getElementById('xbvalue').value+=',Measure';
<                      }
<                    }
<                  }
<                }
<                    recsare=datasofar.split(',[');
<                    //alert(datasofar.substring(0,40).replace(/\ /g,'x') + ' ... ' + recsare.length);
<                    recsare.sort();
<                    datasofar='';
<                    for (kin=1; kin<recsare.length; kin++) {
<                     datasofar+=',[' + recsare[kin].trim() + ' ';
<                    }
<                    //alert(datasofar);
<                    console.log('sort=' + datasofar);
<              }
<            }
<          }
<          
<          if (datasofar.split('~')[1].split('~')[0].indexOf('T') == 10 && eval('' + recsare.length) == 0) {
<                    recsare=datasofar.split(',[');
<                    //alert(datasofar.substring(0,40).replace(/\ /g,'x') + ' ... ' + recsare.length);
<                    recsare.sort();
<                    datasofar='';
<                    for (kin=1; kin<recsare.length; kin++) {
<                     datasofar+=',[' + recsare[kin].trim() + ' ';
<                    }
<                    console.log('sort=' + datasofar);
<          }
<          //console.log('thingo' + numtabcols.length + datasofar.split('~')[1].split('~')[0].split(String.fromCharCode(32)).length + '=' + datasofar.split('~')[1].split('~')[0]);
728c658
<     if (1 == 6) { document.getElementById('mybutm').click(); }
---
>     document.getElementById('mybutm').click();
960d889
< 
962d890
<   var wc='', little=osel.value.replace(/\=$/g, ''), andw=' and ', dotdot='';
964,991d891
<    if (osel.value.slice(-1) == '=') {
<    if (document.getElementById('xpath').value.indexOf(']/') == -1) {
<    wc=prompt('Optionally enter a "where" type of clause (adding to our start for you) ... ' + String.fromCharCode(10) + ' eg. ' + little + '="lookfor"' + String.fromCharCode(10) + ' eg. ' + little + '!="notlookfor"' + String.fromCharCode(10) + ' eg. ' + little + '<998', little);
<    } else {
<    little=' and ' + osel.value.replace(/\=$/g, '');
<    wc=prompt('Optionally add an "and" subclause to your existant "where" type of clause (adding to our subclause start for you) ... ' + String.fromCharCode(10) + ' eg. ' + little + '="lookfor"' + String.fromCharCode(10) + ' eg. ' + little + '!="notlookfor"' + String.fromCharCode(10) + ' eg. ' + little + '<998', little);
<    }
<    if (wc == null) { wc=''; }
<    if (wc.trim() != '' && wc != little) {
<     if (document.getElementById('xpath').value.indexOf(']/') == -1) {
<     document.getElementById('xpath').value=document.getElementById('xpath').value.replace('/' + document.getElementById('xpath').value.split('/')[eval(-1 +  document.getElementById('xpath').value.split('/').length)], '[]/' + document.getElementById('xpath').value.split('/')[eval(-1 +  document.getElementById('xpath').value.split('/').length)]);     
<     document.getElementById('xpath').value=document.getElementById('xpath').value.replace(']/', wc.replace(/\]$/g,'').replace(/^\[/g,'') + ']/');     
<     document.getElementById('myfldselopt').innerText=('Optionally display selected field name(s) value(s)').replace('Optionally display selected field name(s) value(s)','Optionally display selected field name(s) [' + document.getElementById('xpath').value.split('[')[1].split(']')[0] + '] value(s)') + ' ...' + document.getElementById('myfldselopt').innerText.split(' ...')[1]
<     } else {
<     if (wc.toLowerCase().replace(/^\ or\ /g, ' and ').indexOf(' and ') == 0) { 
<     andw=''; 
<     } else {
<     document.getElementById('xpath').value=document.getElementById('xpath').value.replace(']/' + document.getElementById('xpath').value.split('/')[eval(-1 +  document.getElementById('xpath').value.split('/').length)], andw + ']/' + document.getElementById('xpath').value.split('/')[eval(-1 +  document.getElementById('xpath').value.split('/').length)]);     
<     }
<     document.getElementById('xpath').value=document.getElementById('xpath').value.replace(']/', wc.replace(/\]$/g,'').replace(/^\[/g,'') + ']/');     
<     document.getElementById('myfldselopt').innerText=('Optionally display selected field name(s) value(s)').replace('Optionally display selected field name(s) value(s)','Optionally display selected field name(s) [' + document.getElementById('xpath').value.split('[')[1].split(']')[0] + '] value(s)') + ' ...' + document.getElementById('myfldselopt').innerText.split(' ...')[1]
<     }
<     dotdot=document.getElementById('xtitle').value.replace(document.getElementById('xtitle').value.split(' .. ')[0], '');
<     //alert(dotdot + ' ... ' + document.getElementById('xtitle').value);
<     document.getElementById('xtitle').value=document.getElementById('xtitle').value.split(' -- ')[0].split((' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. '))[0] + (' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. ') + dotdot;
<    }
<    osel.value='';
<    } else {
995,996c895
<     document.getElementById('myfldselopt').innerText=document.getElementById('myfldselopt').innerText.split(' ...')[0] + ' ... ' + osel.value;
<     document.getElementById('xtitle').value=document.getElementById('xtitle').value.split(' -- ')[0].split((' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. '))[0] + (' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. ') + osel.value;
---
>     document.getElementById('myfldselopt').innerText='Optionally display selected field name(s) value(s) ... ' + osel.value;
998c897
<     document.getElementById('xpath').value=document.getElementById('xpath').value.replace(/\]$/g, ' or self::' + osel.value + ']');     
---
>     document.getElementById('xpath').value=document.getElementById('xpath').value.replace(']', ' or self::' + osel.value + ']');     
1000,1001d898
<     dotdot=document.getElementById('xtitle').value.replace(document.getElementById('xtitle').value.split(' .. ')[0], '');
<     document.getElementById('xtitle').value=document.getElementById('xtitle').value.split(' -- ')[0].split((' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. '))[0] + (' .... ' + (document.getElementById('myfldselopt').innerText + '[]').split('[')[1].split(']')[0] + ' .. ').replace(/^\ \.\.\.\ \ \.\.\ /g, ' .. ') + dotdot + ',' + osel.value;
1004d900
<    }
1012d907
<          var dtfns=myxhr.responseText.split('"dataTypeName" : "');
1014d908
<          var isokay=eval('' + dtfns.length);
1018d911
<             dtarrflds=[];
1023,1028c916
<            if (isokay > eval('' + dtarrflds.length)) {
<            dtarrflds.push(dtfns[ifns].split('"')[0]);
<            } else {
<            dtarrflds.push('');
<            }
<            fieldsel=fieldsel.replace('</select>', '<option value="' + fns[ifns].split('"')[0] + '">' + fns[ifns].split('"')[0] + (' [' + dtarrflds[eval(-1 + dtarrflds.length)] + ']').replace(/^\ \[\]$/g, '') + '</option><option value="' + fns[ifns].split('"')[0] + '=">' + fns[ifns].split('"')[0] + ' where clause?</option></select>');
---
>            fieldsel=fieldsel.replace('</select>', '<option value="' + fns[ifns].split('"')[0] + '">' + fns[ifns].split('"')[0] + '</option></select>');
1091c979
< <input type=hidden value=Count name=value id=xlvalue></input>
---
> <input type=hidden value=Count name=value></input>
1101c989
< <input type=hidden value=Count name=value id=xbvalue></input>
---
> <input type=hidden value=Count name=value></input>