123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525 |
- <?php
- require('include/glob.php');
- require('include/muoribene.php');
- require('include/sessionstart.php');
- require('include/menu.php');
- buildmenu($menu);
- require('include/myconn.php');
- // praticamente una macro
- function hspech($str) {
- return(htmlspecialchars($str,ENT_QUOTES|ENT_HTML5,'UTF-8'));
- }
- function nully($val,$fem,$filter,$ntext=null) {
- if (!is_null($val)) {
- if ($filter=='strip') {
- return(strip_tags($val,'<a><br><ol><ul><li><p><i><b><strong><em><small>'));
- } elseif ($filter=='htmlchars') {
- return(hspech($val));
- } elseif ($filter=='timestamp') {
- return(strftime('%a %d %b %Y, %T',$val));
- } elseif ($filter=='email') {
- return('<a href="mailto:'.strip_tags($val).'">'.strip_tags($val).'</a>');
- } elseif ($filter=='url') {
- return('<a href="'.strip_tags($val).'" target="_blank">'.strip_tags($val).'</a>');
- } elseif ($filter=='image') {
- return('<img src="'.str_replace('"','\\"',strip_tags($val)).'">');
- } elseif ($filter=='boolt') {
- if ($val)
- return('<span class="good">Si</span>');
- else
- return('<span class="bad">No</span>');
- } elseif ($filter=='boolf') {
- if ($val)
- return('<span class="bad">Si</span>');
- else
- return('<span class="good">No</span>');
- } else {
- return($val);
- }
- } else {
- if (is_null($ntext)) {
- if ($fem)
- return('<span class="nully">Non definita</span>');
- else
- return('<span class="nully">Non definito</span>');
- }
- else {
- return('<span class="nully">'.$ntext.'</span>');
- }
- }
- }
- function booly($pre,$val,$nottoobad=false,$invcol=false) {
- if ($val) {
- if (!$invcol) {
- $p='<p class="good">';
- } else {
- if (!$nottoobad) {
- $p='<p class="bad">';
- } else {
- $p='<p class="neut">';
- }
- }
- return($p.$pre.'SI</p>');
- } else {
- if (!$invcol) {
- if (!$nottoobad) {
- $p='<p class="bad">';
- } else {
- $p='<p class="neut">';
- }
- } else {
- $p='<p class="good">';
- }
- return($p.$pre.'NO</p>');
- }
- }
- $cols=array(
- 'New'=>array('name'=>'Nuova','type'=>'bool'),
- 'Good'=>array('name'=>'Papabile','type'=>'bool'),
- 'Chosen'=>array('name'=>'Scelta','type'=>'bool'),
- 'Visible'=>array('name'=>'Visibile','type'=>'bool'),
- 'Blacklisted'=>array('name'=>'Blacklistata','type'=>'bool'),
- 'URI'=>array('name'=>'URI','type'=>'text'),
- 'Title'=>array('name'=>'Titolo','type'=>'text'),
- 'ShortDesc'=>array('name'=>'Descrizione breve','type'=>'text'),
- 'LongDesc'=>array('name'=>'Descrizione lunga','type'=>'text'),
- 'OurDesc'=>array('name'=>'Descrizione nostra','type'=>'text'),
- 'PlaceID'=>array('name'=>'Località','type'=>'select'),
- 'Email'=>array('name'=>'Email di contatto','type'=>'text'),
- 'Software'=>array('name'=>'Software','type'=>'text'),
- 'Version'=>array('name'=>'Versione','type'=>'text'),
- 'UserCount'=>array('name'=>'Utenti','type'=>'int'),
- 'StatusCount'=>array('name'=>'Stati','type'=>'int'),
- 'DomainCount'=>array('name'=>'Istanze note','type'=>'int'),
- 'ActiveUsersMonth'=>array('name'=>'Utenti attivi (mese)','type'=>'int'),
- 'ActiveUsersHalfYear'=>array('name'=>'Utenti attivi (6 mesi)','type'=>'int'),
- 'Thumb'=>array('name'=>'Logo','type'=>'text'),
- 'RegOpen'=>array('name'=>'Registrazioni aperte','type'=>'bool'),
- 'RegReqApproval'=>array('name'=>'Approvazione registrazioni','type'=>'bool'),
- 'MaxTootChars'=>array('name'=>'Limite caratteri','type'=>'int'),
- 'AdmAccount'=>array('name'=>'Account admin','type'=>'text'),
- 'AdmDisplayName'=>array('name'=>'Nome account admin','type'=>'text'),
- 'AdmCreatedAt'=>array('name'=>'Data creazione account admin','type'=>'time'),
- 'AdmURL'=>array('name'=>'Pagina dell’admin','type'=>'text'),
- 'AdmAvatar'=>array('name'=>'Avatar admin','type'=>'text'),
- 'AdmNote'=>array('name'=>'Note dell’admin','type'=>'text'),
- 'InstLangs'=>array('name'=>'Lingue dichiarate','type'=>'select'),
- 'InstOurLangs'=>array('name'=>'Lingue impostate da noi','type'=>'select'),
- 'InstFinancing'=>array('name'=>'Modalità di finanziamento','type'=>'select'),
- 'InstPolicies'=>array('name'=>'Restrizioni sui contenuti','type'=>'select'),
- 'InstTags'=>array('name'=>'Tags','type'=>'select'),
- );
- $fieldselopts='';
- foreach ($cols as $key=>$val) {
- $fieldselopts.='<option value="'.$key.'§'.$val['type'].'">'.$val['name'].'</option>';
- }
- $res=mysqli_query($link,'SELECT *, Instances.ID AS IID FROM Instances LEFT JOIN Places ON Places.ID=PlaceID ORDER BY URI ASC LIMIT 50')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($res)<1) {
- $out='<p>Nessuna istanza da mostrare.</p>'.N;
- } else {
- $out='';
- while ($row=mysqli_fetch_assoc($res)) {
- $out.='<table class="bigtab">'.N;
- // $out.='<thead><tr><th class="tdattr">Attributi</th><th>Info</th></thead>'.N;
- $out.='<tbody>'.N;
- $out.='<tr><td colspan="2" class="insthead">'.$row['URI'].'</td></tr>'.N;
- $attr=booly($cols['Blacklisted']['name'].': ',$row['Blacklisted'],false,true).N;
- $attr.=booly($cols['New']['name'].': ',$row['New'],true).N;
- $attr.=booly($cols['Good']['name'].': ',$row['Good']).N;
- $attr.=booly($cols['Chosen']['name'].': ',$row['Chosen']).N;
- $attr.=booly($cols['Visible']['name'].': ',$row['Visible']).N;
- /* $attr.=booly($cols['RegOpen']['name'].': ',$row['RegOpen']).N;
- $attr.=booly($cols['RegReqApproval']['name'].': ',$row['RegReqApproval'],true,true).N;*/
- $sres=mysqli_query($link,'SELECT * FROM InstChecks WHERE InstID='.$row['IID'].' ORDER BY Time DESC')
- or muoribene(mysqli_error($link),false);
- $csres=mysqli_num_rows($sres);
- if ($csres>0) {
- $bene=0;
- while ($srow=mysqli_fetch_assoc($sres)) {
- if ($srow['Status']==1)
- $bene++;
- }
- $width=str_replace(',','.',100/$csres*$bene);
- $attr.='<div class="colsectheader">Percentuale di risposta ai nostri check: '.round($width,1).'%</div>';
- $attr.='<div class="percbg"><div class="percfg" style="width:'.$width.'%;"></div></div>'.N;
- mysqli_data_seek($sres,0);
- $srow=mysqli_fetch_assoc($sres);
- $attr.='<div class="colsectcont">Ultimo check '.strftime('%e %b %Y, %T',$srow['Time']).': '.(($srow['Status']) ? '<span class="good">OK</span>' : '<span class="bad">KO</span>').'</div>';
- } else {
- $attr.='<div class="colsectheader">Percentuale di risposta ai nostri check</div>';
- $attr.='<div class="colsectcont nully">Non disponibile (?!?!?!)</div>'.N;
- }
- $attr.='<div class="colsectheader">Attività delle ultime 12 settimane</div>'.N;
- $sres=mysqli_query($link,'SELECT SUM(Statuses) AS tstatuses, SUM(Logins) AS tlogins, SUM(Registrations) AS tregs FROM InstActivity WHERE InstID='.$row['IID'])
- or muoribene(mysqli_error($link),false);
- $tot=mysqli_fetch_assoc($sres);
- $sres=mysqli_query($link,'SELECT * FROM InstActivity WHERE InstID='.$row['IID'].' ORDER BY Week DESC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $attr.='<div class="colsectcont">Stati: '.$tot['tstatuses'].'<br>Accessi: '.$tot['tlogins'].'<br>Registrazioni: '.$tot['tregs'].'</div>'.N;
- while ($srow=mysqli_fetch_assoc($sres)) {
- $attr.='<div class="colsectcontb">'.strftime('%e %b %Y',$srow['Week']).'</div>'.N;
- ($tot['tstatuses']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tstatuses']*$srow['Statuses']);
- $attr.='<div class="percstatuses" style="width:'.$width.'%;">'.$srow['Statuses'].' stati</div>'.N;
- ($tot['tlogins']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tlogins']*$srow['Logins']);
- $attr.='<div class="perclogins" style="width:'.$width.'%;">'.$srow['Logins'].' accessi</div>'.N;
- ($tot['tregs']==0) ? $width=0 : $width=str_replace(',','.',100/$tot['tregs']*$srow['Registrations']);
- $attr.='<div class="percregs" style="width:'.$width.'%;">'.$srow['Registrations'].' registrazioni</div>'.N;
- }
- } else {
- $attr.='<div class="colsectcont nully">Non disponibile</div>'.N;
- }
- $attr.='<div class="colsectheader">Hashtags più usati durante l’ultima settimana</div>'.N;
- $sres=mysqli_query($link,'SELECT * FROM InstTrends WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $attr.='<div class="colsectcont"><ol>'.N;
- while ($srow=mysqli_fetch_assoc($sres)) {
- $attr.='<li><a href="'.$srow['URL'].'">'.hspech($srow['Name']).'</a></li>'.N;
- }
- $attr.='</ol></div>'.N;
- } else {
- $attr.='<div class="colsectcont nully">Non disponibili</div>'.N;
- }
- $out.='<tr><td class="tdattr">'.$attr.'</td><td>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['URI']['name'].':</span> <a href="https://'.$row['URI'].'" target="_blank">'.$row['URI'].'</a></div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['Title']['name'].':</span> '.nully($row['Title'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['Thumb']['name'].':</span> '.nully($row['Thumb'],true,'image').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['ShortDesc']['name'].':</span> '.nully($row['ShortDesc'],true,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['LongDesc']['name'].':</span> '.nully($row['LongDesc'],true,'strip').'</div>'.N;
- // 'strip' o 'htmlent' per la descrizione nostra?
- $out.='<div class="baloo"><span class="ourfield">'.$cols['OurDesc']['name'].':</span> '.nully($row['OurDesc'],true,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="ourfield">'.$cols['PlaceID']['name'].':</span> '.nully($row['PlaceID'],true,'strip').'</div>'.N;
- $sres=mysqli_query($link,'SELECT * FROM InstLangs LEFT JOIN Languages ON Languages.ID=LangID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $i=0;
- $buf=array();
- while ($srow=mysqli_fetch_assoc($sres)) {
- $i++;
- $buf[]=$i.': '.hspech($srow['Code'].' ['.ucfirst(locale_get_display_name($srow['Code'])).']');
- }
- $out.='<div class="baloo"><span class="field">'.$cols['InstLangs']['name'].':</span> '.implode('; ',$buf).'</div>'.N;
- } else {
- $out.='<div class="baloo"><span class="field">'.$cols['InstLangs']['name'].':</span> <span class="nully">Non definite</span></div>'.N;
- }
- $sres=mysqli_query($link,'SELECT * FROM InstOurLangs LEFT JOIN Languages ON Languages.ID=LangID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $i=0;
- $buf=array();
- while ($srow=mysqli_fetch_assoc($sres)) {
- $i++;
- $buf[]=$i.': '.hspech($srow['Code'].' ['.ucfirst(locale_get_display_name($srow['Code'],'it')).']');
- }
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstOurLangs']['name'].':</span> '.implode('; ',$buf).'</div>'.N;
- } else {
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstOurLangs']['name'].':</span> <span class="nully">Non definite</span></div>'.N;
- }
- $sres=mysqli_query($link,'SELECT * FROM InstFinancing LEFT JOIN Financing ON Financing.ID=FinID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $i=0;
- $buf=array();
- while ($srow=mysqli_fetch_assoc($sres)) {
- $i++;
- $buf[]=$i.': '.hspech($srow['Type']).' ('.hspech($row['Details']).')';
- }
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstFinancing']['name'].':</span> '.implode('; ',$buf).'</div>'.N;
- } else {
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstFinancing']['name'].':</span> <span class="nully">Non definite</span></div>'.N;
- }
- $sres=mysqli_query($link,'SELECT * FROM InstPolicies LEFT JOIN Policies ON Policies.ID=PolID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $i=0;
- $buf=array();
- while ($srow=mysqli_fetch_assoc($sres)) {
- $i++;
- $buf[]=$i.': '.hspech($srow['Name']);
- }
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstPolicies']['name'].':</span> '.implode('; ',$buf).'</div>'.N;
- } else {
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstPolicies']['name'].':</span> <span class="nully">Non definite</span></div>'.N;
- }
- $sres=mysqli_query($link,'SELECT * FROM InstTags LEFT JOIN Tags ON Tags.ID=TagID WHERE InstID='.$row['IID'].' ORDER BY Pos ASC')
- or muoribene(mysqli_error($link),false);
- if (mysqli_num_rows($sres)>0) {
- $i=0;
- $buf=array();
- while ($srow=mysqli_fetch_assoc($sres)) {
- $i++;
- $buf[]=$i.': '.hspech($srow['Name']);
- }
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstTags']['name'].':</span> '.implode('; ',$buf).'</div>'.N;
- } else {
- $out.='<div class="baloo"><span class="ourfield">'.$cols['InstTags']['name'].':</span> <span class="nully">Non definite</span></div>'.N;
- }
- $out.='<div class="baloo"><span class="field">'.$cols['Email']['name'].':</span> '.nully($row['Email'],true,'email').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['Software']['name'].':</span> '.nully($row['Software'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['Version']['name'].':</span> '.nully($row['Version'],true,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['UserCount']['name'].':</span> '.nully($row['UserCount'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['StatusCount']['name'].':</span> '.nully($row['StatusCount'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['DomainCount']['name'].':</span> '.nully($row['DomainCount'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['ActiveUsersMonth']['name'].':</span> '.nully($row['ActiveUsersMonth'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['ActiveUsersHalfYear']['name'].':</span> '.nully($row['ActiveUsersHalfYear'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['RegOpen']['name'].':</span> '.nully($row['RegOpen'],false,'boolt').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['RegReqApproval']['name'].':</span> '.nully($row['RegReqApproval'],false,'boolf').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['MaxTootChars']['name'].':</span> '.nully($row['MaxTootChars'],false,'strip','500').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['AdmAccount']['name'].':</span> '.nully($row['AdmAccount'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['AdmDisplayName']['name'].':</span> '.nully($row['AdmDisplayName'],false,'strip').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['AdmCreatedAt']['name'].':</span> '.nully($row['AdmCreatedAt'],true,'timestamp').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['AdmURL']['name'].':</span> '.nully($row['AdmURL'],true,'url').'</div>'.N;
- $out.='<div class="baloo"><span class="field">'.$cols['AdmAvatar']['name'].':</span> '.nully($row['AdmAvatar'],false,'image').'</div>'.N;
- $out.='<div><span class="field">'.$cols['AdmNote']['name'].':</span> '.nully($row['AdmNote'],false,'strip').'</div>'.N;
- $out.='</td></tr>'.N;
- $out.='</tbody>'.N;
- $out.='</table>'.N;
- }
- $out.='<div style="height:36px;"></div>';
- }
- mysqli_close($link);
- ?>
- <!DOCTYPE HTML>
- <html lang="it">
- <head>
- <title>Mastodon Startpage Admin - Istanze</title>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <meta name="description" content="Admin pages for Mastodon Startpage">
- <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
- <link rel="icon" type="image/png" href="imgs/icona-32.png" sizes="32x32">
- <link rel="icon" type="image/png" href="imgs/icona-192.png" sizes="192x192">
- <link rel="icon" type="image/png" href="imgs/icona-512.png" sizes="512x512">
- <link rel="apple-touch-icon-precomposed" href="imgs/icona-180.png">
- <link rel="stylesheet" type="text/css" href="theme.css?v=<?php echo($cjrand); ?>">
- <script language="JavaScript">
- <!--
- function chulsh(el,sh) {
- if (sh)
- el.querySelector('ul').style='display:block';
- else
- el.querySelector('ul').style='display:none';
- }
- function ulsh(el,sh) {
- if (sh)
- el.style='display:block';
- else
- el.style='display:none';
- }
- function golang(lang) {
- var loc=document.location.href;
- loc=loc.replace(/#.*$/,'');
- loc=loc.replace(/\/$/,'');
- if (document.documentElement.lang=='en') {
- if (lang!='en')
- document.location.href=loc+'/'+lang;
- } else {
- if (lang!='en')
- document.location.href=loc.substr(0,loc.length-3)+'/'+lang;
- else
- document.location.href=loc.substr(0,loc.length-3);
- }
- }
- function truncsel(el) {
- var sel=document.getElementById(el), len=sel.length, i=0;
- for (i=len-1; i>=0; i--)
- sel.remove(i);
- }
- function addselopt(el,val,txt) {
- option=document.createElement('option');
- option.value=val;
- option.text=txt;
- el.add(option);
- }
- function inpdisif(index) {
- var source=document.getElementById('condsel'+index);
- var dest=document.getElementById('valueinp'+index);
- var conds=['IS NULL','IS NOT NULL'];
- if (conds.includes(source.value)) {
- dest.disabled=true;
- // dest.style='display:none';
- } else {
- dest.disabled=false;
- // dest.style='display:block';
- }
- }
- function popusels(index) {
- console.log('Index: '+index);
- var val=document.getElementById('fieldsel'+index).value, type=val.replace(/^.*§/,''), option;
- val=val.replace(/§.*$/,'');
- var condsel=document.getElementById('condsel'+index);
- var valsel=document.getElementById('valuesel'+index);
- var valinp=document.getElementById('valueinp'+index);
- if (type=='bool') {
- truncsel('condsel'+index);
- addselopt(condsel,'IS','è');
- addselopt(condsel,'IS NOT','non è');
- truncsel('valuesel'+index);
- addselopt(valsel,'TRUE','vero');
- addselopt(valsel,'FALSE','falso');
- addselopt(valsel,'NULL','non definito');
- valinp.style='display:none';
- valinp.disabled=true;
- valsel.style='display:block';
- valsel.disabled=false;
- condsel.removeAttribute('onchange');
- } else if (type=='text') {
- truncsel('condsel'+index);
- addselopt(condsel,'LIKE','contiene');
- addselopt(condsel,'NOT LIKE','non contiene');
- addselopt(condsel,'=','è uguale a');
- addselopt(condsel,'!=','è diverso da');
- addselopt(condsel,'IS NOT NULL','è definito');
- addselopt(condsel,'IS NULL','non è definito');
- valsel.style='display:none';
- valsel.disabled=true;
- valinp.style='display:block';
- valinp.disabled=false;
- condsel.setAttribute('onchange','inpdisif('+index+');');
- } else if (type=='int' || type=='time') {
- truncsel('condsel'+index);
- addselopt(condsel,'>=','maggiore o uguale a');
- addselopt(condsel,'<=','minore o uguale a');
- addselopt(condsel,'>','maggiore di');
- addselopt(condsel,'<','minore di');
- addselopt(condsel,'=','uguale a');
- addselopt(condsel,'!=','diverso da');
- addselopt(condsel,'IS NOT NULL','è definito');
- addselopt(condsel,'IS NULL','non è definito');
- valsel.style='display:none';
- valsel.disabled=true;
- valinp.style='display:block';
- valinp.disabled=false;
- condsel.setAttribute('onchange','inpdisif('+index+');');
- } else {
- alert('Attenziò: non so che farmene del tipo "'+type+'": diglielo, al programmatore.');
- }
- }
- function addrow(index) {
- var table=document.getElementById('plancia');
- var newrow=table.insertRow(index);
- var newcell0=newrow.insertCell(0);
- var newcell1=newrow.insertCell(1);
- var newcell2=newrow.insertCell(2);
- var newcell3=newrow.insertCell(3);
- var newcell4=newrow.insertCell(4);
- var newcell5=newrow.insertCell(5);
- var newcell6=newrow.insertCell(6);
- var newcell7=newrow.insertCell(7);
- newcell0.innerHTML='<select class="openpar"><option value="null"></option><option value="(">(</option><option value="((">((</option><option value="(((">(((</option></select>';
- newcell1.innerHTML='<select class="fieldsel"><?php echo($fieldselopts); ?></select>';
- newcell2.innerHTML='<select class="condsel"></select>';
- newcell3.innerHTML='<select class="valuesel" style="display:none;"></select>\n<input type="text" class="valueinp" maxlength="256" style="display:none;">';
- newcell4.innerHTML='<select class="closepar"><option value="null"></option><option value=")">)</option><option value="))">))</option><option value=")))">)))</option></select>';
- newcell5.innerHTML='<select class="andor"><option value="AND">E</option><option value="OR">O</option></select>';
- newcell6.innerHTML='<img class="plus" src="imgs/plus.svg">';
- newcell7.innerHTML='<img class="minus" src="imgs/minus.svg">';
- synctai();
- popusels(index);
- }
- function synctai() {
- var i=0;
- var table=document.getElementById('plancia');
- var nodes=table.querySelectorAll('.minus');
- var cnodes=nodes.length;
- for (i=0; i<cnodes; i++)
- // +1 sempre per via della row iniziale
- nodes[i].setAttribute('onclick','remrow('+(i+1)+');');
- nodes=table.querySelectorAll('.plus');
- for (i=0; i<cnodes; i++)
- // +2 perché la devi aggiungere dopo la corrente
- nodes[i].setAttribute('onclick','addrow('+(i+2)+');');
- // da qui in poi faccio a scendere per non avere mai id e nomi duplicati
- cnodes--;
- nodes=table.querySelectorAll('.openpar');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','openpar'+(i+1));
- nodes[i].setAttribute('name','openpar'+(i+1));
- }
- nodes=table.querySelectorAll('.fieldsel');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','fieldsel'+(i+1));
- nodes[i].setAttribute('name','fieldsel'+(i+1));
- nodes[i].setAttribute('onchange','popusels('+(i+1)+');');
- }
- nodes=table.querySelectorAll('.condsel');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','condsel'+(i+1));
- nodes[i].setAttribute('name','condsel'+(i+1));
- }
- nodes=table.querySelectorAll('.valuesel');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','valuesel'+(i+1));
- nodes[i].setAttribute('name','valuesel'+(i+1));
- }
- nodes=table.querySelectorAll('.valueinp');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','valueinp'+(i+1));
- nodes[i].setAttribute('name','valueinp'+(i+1));
- }
- nodes=table.querySelectorAll('.closepar');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','closepar'+(i+1));
- nodes[i].setAttribute('name','closepar'+(i+1));
- }
- nodes=table.querySelectorAll('.andor');
- for (i=cnodes; i>-1; i--) {
- nodes[i].setAttribute('id','andor'+(i+1));
- nodes[i].setAttribute('name','andor'+(i+1));
- nodes[i].disabled=false;
- }
- if (cnodes>0)
- nodes[cnodes].disabled=true;
- }
- function remrow(index) {
- var table=document.getElementById('plancia');
- table.deleteRow(index);
- synctai();
- }
- //-->
- </script>
- </head>
- <body>
- <nav>
- <div id="hmenu">
- <ul>
- <?php echo($menuout); ?>
- </ul>
- </div>
- </nav>
- <div id="footer">
- <form action="edinst.php" name="addinst" method="post">
- <table><tr><td>Aggiungi un’istanza:</td><td><input type="text" name="URI" maxlength="512"></td><td><input type="button" value="Vai" onClick="ckaif();"></td></tr></table>
- </form>
- </div>
- <div id="fullscreen">
- <div id="middlerow">
- <form method="post" id="f">
- <table id="plancia">
- <tr><td colspan="8"><input type="button" value="Aggiungi condizioni" class="ctrlbut" onclick="addrow(document.getElementById('plancia').rows.length);"></td></tr>
- </table>
- </form>
- <?php echo($out); ?>
- </div>
- </div>
- </body>
- </html>
|