var idchoiced={};idchoiced.selected=false;idchoiced.thumb=[0,1,2,3,4,5];

//====
function send_a_request_to_exports(title,page,what,subwhat){
if(!TableDB_verify_if_selected())return(false);
var time=1000;
///alert("ljs:10 "+chrrc+title+chrrc+page+chrrc+what);
switch(what){
    case "ebook":
         js_get_form_waiting(1200,"97vh","Création d'un ebook");break;
    case "excel":
    default:
         js_get_form_waiting(600,"30vh");break;
}
js_get_form_loadingEnd(title,greenLight,true);
switch(what){
    case "ebook":
         setTimeout(send_a_request_into_a_page.bind(null,page,what,subwhat),time);break;
    case "excel":
         setTimeout(send_a_request_an_export.bind(null,page,what,subwhat),time);break;
    default:
}
}//c function send_a_request_to_exports(title,page,what)
//====
function send_a_request_an_export(page,action){
// appel ajax
var xhr=getXMLHttpRequest(),color=greenLight,errmessage="Success";//!	ranslate 07/08/2020 07:55:25

xhr.onreadystatechange = function() {
var arr=checkXMLHttpRequest(xhr);
if(arr[0]){
if(arr[1]==='exists'){
     js_get_form_loadingEnd('<a href="'+arr[3]+'" download>'+arr[2]+'</a>',greenLight,false);
     return(true);
}//c if(action==='ebook')
js_get_form_loadingEnd("Création",greenLight,false);
}
};

var call=encodeURI(page+"&action="+action);
xhr.open("GET", call, false);
///xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.send(null);

}
//====
function send_a_request_into_a_page(page,action,subwhat){
// appel ajax
var status=set_header_action(action);if(status===false){update_TitleMessage(action,"stopC");return(status);}
var num=document.getElementById('identifiant_du_haut');
num=num.value;
/*
if(!num){
alert(et["choose_a_line_to_modify_below"]);
js_get_form_no_display();
return(false);
}
*/
page=page.replace('num=xxx','num='+num);

var xhr=getXMLHttpRequest(),color=greenLight,errmessage="Success";//!	ranslate 07/08/2020 07:55:25

xhr.onreadystatechange = function() {
var arr=checkXMLHttpRequest(xhr);
if(arr[0]){
if(arr[1]==='ebook'){///action==='ebook'){
     send_a_request_into_a_page(page+'&file='+arr[2],'display');
}//c if(action==='ebook')
if(arr[1]==='display'){///action==='display'){
///var arr=xhr.responseText.split('/');//c arr[2]  non du fichier PDF
/*
var msg=document.getElementById('id_div_js_get_form_waiting');
msg.innerHTML=xhr.responseText;
msg.src='../documents/files/78/CALC-ARCHITECTE - Construction de 26 logements.pdf';
*/

//c #toolbar=0 empêche l'affichage des outils en haut mais pas le enregistrer sous
//c width=1000px  inopérant    
//c https://fr.w3docs.com/snippets/html/comment-integrer-pdf-dans-html.html
var src=arr[3].replace("../",""); /// ../../documents/files/78/CALC-ARCHITECTE - Construction de 26 logements.pdf '../documents/files/78/CALC-ARCHITECTE - Construction de 26 logements.pdf';
///alert("ljs:84 source: "+src);
//..//appRes/wiw/documents/files/40/docs/NOM_SOCIETE - Ensemble de logements et de bureaux.pdf
var obj=document.getElementById('id_object_js_get_form_waiting');
obj.src=src;///obj.data=src;

var href=document.getElementById('id_href_js_get_form_waiting');
if(href)href.href=src;

///var msg=document.getElementById('message_for_help');
///msg.innerHTML=src;
var arr2=src.split('/');//c arr[2]  non du fichier PDF

js_get_form_loadingEnd("Lecture de "+arr2[arr2.length-1],greenLight,false);//!	ranslate 07/08/2020 08:24:51
///id_object_js_get_form_waiting=data   id_href_js_get_form_waiting=href
}
///js_get_form_no_display();
    }//c if(arr[0])
else{
    var errmessage="échec de la demande ->"+xhr.responseText+ "(voir page.html)";//!	ranslate 07/08/2020 08:09:16
    color=redLight;
    js_get_form_loadingEnd(errmessage,color,false);
}
////alert("errmessage 3: "+errmessage);
///spanmsg.innerHTML=errmessage;
///spanmsg.style.backgroundColor=color;    
///   return(xhr.responseText);
///    document.location=document.location;
};
// C:\labo\calcweb\administration\scripts\login.php
/*
action='ebook';
if(action==='ebook'){
   js_get_form_loadingEnd('Lecture du fichier PDF',greenLight,true);   
}
if(0&&action==='display'){
   js_get_form_loadingEnd('Création du fichier PDF',greenLight,true);   
}
*/
///alert('affiché? 1');
///js_get_form_loadingEnd('Création du fichier PDF',greenLight,true);   
//alert('affiché? 2');
var formDatas=new FormData();
formDatas.append('line',status[5]);
formDatas.append('table',status[8]);
formDatas.append('num',num);
formDatas.append('action',action);
formDatas.append('subwhat',subwhat);

////alert(action);
sendXMLHttpRequest(xhr,"POST",null,cst['DocumentRoot']+page,formDatas,action);//// ajax/ajax_logout.php");

/*
///alert(msg.innerHTML);
var call=encodeURI(page+"&action="+action);
xhr.open("GET", call, false);
///xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.send(null);
*/
///}

}//c function send_a_request_into_a_page(page,action)
//====
function update_TitleMessage(what,status){
var spanmsg=document.getElementById('idTitleMessage');
if(!spanmsg)return(false);
switch(status){
    case "stopU":
        var bgColor=greenLight;
        var color=blueLight;
        var msg="is stopped by user";
        break;
    case "stopC":
        var bgColor='pink';
        var color='red';
        var msg="must configured"
        break;
    case "start":
        var bgColor='orange';
        var color='brown';
        var msg="is running"
        break;
    case "error":
        var bgColor='red';
        var color='white';
        var msg="is present"
        break;
    case "success":
        var bgColor=greenLight;
        var color='blue';
        var msg="is "+status
        break;
}
        spanmsg.style.backgroundColor=bgColor;
        spanmsg.style.color=color;
        spanmsg.innerHTML=what+" "+msg;
}
//====
function send_a_simple_request(sql,action){
// appel ajax
js_get_form_waiting();
var xhr = getXMLHttpRequest(),color=greenLight,errmessage="Success";

xhr.onreadystatechange = function() {
var arr=checkXMLHttpRequest(xhr);
alert(action+chrrc+xhr.responseText);
if(arr[0]){
///   if(xhr.responseText.substr(0,4)==='done'){
var spanmsg=document.getElementById('idmessageajax');
////document.getElementById('idmessageajax').innerHTML=xhr.responseText;
///var thatTR=idchoiced.thisradio.parentNode.parentNode;
///thatTR.style.backgroundColor=greenLight;
var radio=idchoiced.thisradio;
///radio.setAttribute("checked",false);
///radio.checked = false;

if(action==='updateTable'){//c if(action==='updateTable'){
var cells=idchoiced.values.getElementsByTagName('th');
var oldvalues=idchoiced.tds;
for (var i = 1; i < cells.length; i++) {
    var input= cells[i].getElementsByTagName('input')[0];
    if(typeof input!="undefined"&&input.value!==oldvalues[i].innerHTML){
    
        oldvalues[i].innerHTML=input.value;
    }
}
///idchoiced.thisradio.click();//c inilialiser pour des modifications supplémentaires
    update_TitleMessage("update","success");//c prépare les lignes en vue d'un update
}//c if(action==='update')

if(action==='insertTable'){
////message="échec de la demande "+xhr.responseText;
/*
thatTR.style.backgroundColor="white";
var clone=thatTR.parentNode.getElementsByTagName('tr')[1];
clone.style.backgroundColor=greenLight;
*/
    update_TitleMessage("insert","success");//c prépare les lignes en vue d'une insertion
////c.style.backgroundColor=greenLight;
    
    
}//c if(action==='insert')

///idchoiced.thisradio=that;

if(action==='deleteTable'){
var child=radio.parentNode.parentNode;
var node=child.parentNode;
////alert(req+' - '+node+' - '+child);
node.removeChild(child);
    update_TitleMessage("delete","success");//c prépare les lignes en vue d'une insertion
///row.remove();
}//c if(action==='delete')

js_get_form_no_display();
    }//c if(arr[0])
else{
    ///errmessage="échec de la demande ->"+xhr.responseText;//!	ranslate 07/08/2020 08:09:44
    ////color=redLight;
    update_TitleMessage(action,"error");//c prépare les lignes en vue d'un update
}


/*
spanmsg.innerHTML=errmessage;
spanmsg.style.backgroundColor=color;
*/
///   return(xhr.responseText);
///    document.location=document.location;
};
/*
// C:\labo\calcweb\administration\scripts\login.php
///xhr.open("GET", "scripts/ajax_send_a_simple_request.php?sql="+sql.replace(chrrc," ")+"&action="+action, false);
xhr.open("GET", "ajax/ajax_send_a_ simple_request.php?sql="+sql.replace(chrrc," ")+"&action="+action, false);
///xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.send(null);
*/
var formDatas=new FormData();
formDatas.append('sql',sql.replace(chrrc," "));
////alert(action);
sendXMLHttpRequest(xhr,"POST",null,cst['DocumentRoot']+"/res/scripts/php/ajax/ajax_field_different_input.php",formDatas,action);//// ajax/ajax_logout.php");

///}
}//c function send_a_simple_request(sql)
//====
function TableDB_verify_if_selected(){
if(!idchoiced||!idchoiced.selected){
alert(iconWarning+et["choose_a_line_to_modify_below"]);
return(false);
}
return(true);
}
//====
function js_get_form_find_thumb_to_check(form,tablename,num){
js_get_form_loadingEnd("Changement de miniature",greenLight,false);//!	ranslate 09/08/2020 11:35:42
var page='ajax/ajax_field_different_input.php';
var formData=new FormData(form);
formData.append("action", "uploadThumb");
formData.append("tablename", "tablename");
////formData.append("id", "77");

// appel ajax
/*
https://developer.mozilla.org/fr/docs/Web/Guide/Using_FormData_Objects
var formElement = document.getElementById("myFormElement");
var request = new XMLHttpRequest();
request.open("POST", "submitform.php");
request.send(new FormData(formElement));
*/
var xhr=getXMLHttpRequest(),color=greenLight,errmessage="Success";//!	ranslate 07/08/2020 07:55:25
xhr.onreadystatechange = function() {
var arr=checkXMLHttpRequest(xhr);
if(arr[0]){
    var tableImage=idchoiced.thisradio.parentNode.parentNode.getElementsByTagName('td')[Number(num)].getElementsByTagName('img')[0];
    alert(xhr.responseText+chrrc+idchoiced.thumb[Number(num)].src+chrrc+tableImage);
//c https://stackoverflow.com/questions/1077041/refresh-image-with-a-new-one-at-the-same-url
    var src=arr[2];
    idchoiced.thumb[Number(num)].src=src;///+"&t=" + new Date().getTime();//c newImage.src = "image.jpg?t=" + new Date().getTime();
    tableImage.src=src;
    js_get_form_loadingEnd("Miniature changée",greenLight,false);//!	ranslate 09/08/2020 11:34:57
}//c if(arr[0])
return(null);
};
sendXMLHttpRequest(xhr,"POST",form,page,formData);
return(null);
}
//====
function TableDB_Thumb_fileChange(thatFile){
var tdate=String(thatFile.files[0].lastModifiedDate);
var datearr=tdate.split(' ');
/*
var msg=thatFile.files[0].name+'<br>'+thatFile.files[0].size+'<br>'+thatFile.files[0].lastModified+'<br>'+datearr[3]+' - '+thatFile.files[0].lastModifiedDate+'<br>'+thatFile.files[0].webkitRelativePath+'<br>';
///msg+=new Date(thatFile.files[0].lastModified)+'<br>'
//c  Thu Jul 23 2020 16:36:40 GMT+0200 (heure d’été d’Europe centrale)
msg+=datearr[3]+'<br>';
*/
var msg='Nom: '+thatFile.files[0].name+'<br>';
msg+='Date: '+datearr[2]+'/'+datearr[1]+'/'+datearr[3]+' '+datearr[4]+'<br>';
msg+='Taille: '+thatFile.files[0].size+' octets';
var o=document.getElementById('id_tdInfosThumb');
if(o){
  o.innerHTML=msg;
}
}
//====
function TableDB_Thumb_onChange(thatImage,tablename,num){
//c num= n° de ligne de table sélectionnée
if(!TableDB_verify_if_selected())return(false);
//c afficher un interface de upload d'1 fichier
idchoiced.thumb[Number(num)]=thatImage.parentNode.getElementsByTagName('img')[0];
var formName='FormThumb';
js_get_form_waiting(500,'50vh','Choisir une image miniature',formName);//!	ranslate 09/08/2020 00:00:37   lastModifiedDate
js_get_form_display_imgWaiting(false);
//c envoie vers ajax upload
var body='<table>';
body+='<tr><td>';
body+='<label for="thumb">&nbsp;</label>';
body+='</td></tr>';
body+='<tr><td>';
//c https://developer.mozilla.org/fr/docs/Web/HTML/Element/Input/file
body+='<input type="file" id="thumb" name="thumb" onchange="TableDB_Thumb_fileChange(this);" accept="image/png, image/jpeg" multiple="false" style="width:100%;"/>';
body+='</td></tr>';
body+='<tr><td id="id_tdInfosThumb">';
body+='</td></tr>';
body+='<tr><td align="right">';
body+=js_get_form_buttons("js_get_form_find_thumb_to_check(this.form,'"+tablename+"',"+num+");","Valider");//!	ranslate 09/08/2020 00:00:37 
body+='</td></tr>';
body+='</table>';
////body+='<input type="hidden" name="id" value="'+document.getElementById('identifiant_du_haut').value+'" />';
body+=js_get_form_inputHidden('id',document.getElementById('identifiant_du_haut').value);
var o=document.getElementById(formName);
if(o){o.innerHTML=body;o.setAttribute("enctype","multipart/form-data");}
}//c function TableDB_Thumb_onChange(thatImage,tablename,num)
//====
function set_header_action(action){/////thatButton,tablename){
if(!TableDB_verify_if_selected())return(false);
update_TitleMessage(action,"start");
if(!idchoiced)idchoiced={};
var status=get_status_inputs().split("|");////thatButton).split("|");
var o=document.getElementById('visu_seizure_id');
o.innerHTML=status[5];
return(status);
}
//====
function TableDB_delete_rec(){/////thatButton,tablename){
/*
if(!TableDB_verify_if_selected())return(false);
update_TitleMessage("delete","start");
if(!idchoiced)idchoiced={};
var status=get_status_inputs().split("|");////thatButton).split("|");
var o=document.getElementById('visu_seizure_id');
o.innerHTML=status[5];
*/
//!	ranslate 07/08/2020 07:55:25
var action="delete";
var status=set_header_action(action);if(status===false){update_TitleMessage(action,"stopC");return(status);}
var msg1=iconWarning+" "+"Etes-vous sûr de vouloir détruire cet enregistrement?";
if(!confirm(msg1)){update_TitleMessage(action,"stopU");return(false);}
var req=action+' from '+status[8]+chrrc+'where '+status[7]+"";
send_a_simple_request(encodeURI(req),action+"Table");
/*  sans where toute la table est supprimée
DELETE FROM `utilisateur`
WHERE `id` = 1
*/
}
//====
function TableDB_display_ebook_rec(thatButton,tablename){

}//c function TableDB_display_ebook_rec(thatButton,tablename)
//====
function TableDB_select_onChange(thatSelect){
var parentNode=thatSelect.parentNode;
parentNode.getElementsByTagName('input')[0].value=thatSelect.options[thatSelect.selectedIndex].text;
}
//====
function get_status_inputs(thatButton){////thatButton){//node){
if(thatButton){
     var table=thatButton.parentNode.parentNode.parentNode.parentNode;
     var trthead2=table.getElementsByTagName('thead')[2].getElementsByTagName('tr')[0];
     idchoiced.values=trthead2;
}
//===
if(!idchoiced.msi)idchoiced.msi=document.getElementById('memo_status_inputs');
//===
var o=document.getElementById('idDefTable');if(o)idchoiced.thisDefTable=o.value;
var elemTable=idchoiced.thisDefTable.split(","),tablename=elemTable[0],elemTable=elemTable.slice(1);
//===
var inputs = idchoiced.values.getElementsByTagName('th');///trthead2.getElementsByTagName('th');
var total=0,emptyFields=0,placeholder=changeInsert=where="",allValues="'',",sqlTag=elemTable[0]+",";
for (var i = 1; i < inputs.length; i++) {
    inp=inputs[i].getElementsByTagName('input')[0];
    if(inp){
        if(inp.getAttribute("disabled")===''){
            ////        inp.setAttribute("disabled",false);// ou element.removeAttribute("disabled");  ou removeAttribute('readonly')
            inp.disabled=null;
            inp.style.backgroundColor="white";
        }
        if(inp.value===""){
             //c champs non remplis
             placeholder+="<"+inp.getAttribute("placeholder")+">,";
             emptyFields++;
        }
        total++;

        
        changeInsert+=elemTable[i]+"="+"'"+inp.value+"',";
        allValues+="'"+inp.value+"',";
        sqlTag+=elemTable[i]+",";
    }
}
var results="";
///if(allValues!==""){
    placeholder=placeholder.substring(0,placeholder.length-1);//c table,civilité,...
    sqlTag=sqlTag.substring(0,sqlTag.length-1);//c cu_wiw,cu_id,cu_civilite,cu_nom...
    allValues=allValues.substring(0,allValues.length-1);//c wiw_demo,1, nom, prénom...
    changeInsert=changeInsert.substring(0,changeInsert.length-1); //c wiw_demo,1, nom, prénom...
    var radioId=document.getElementById('identifiant_du_haut').value;  //c   5
    where=elemTable[0]+"="+""+radioId+"";//c   cu_id=5
    results=(total-emptyFields)+"|"+emptyFields+"|"+total+"|"+placeholder+"|"+sqlTag+"|"+allValues+"|"+changeInsert+"|"+where+"|"+tablename;
///}
if(idchoiced.msi.value=="")idchoiced.msi.value=results;
/*
if(msi){
    results=msi.value=(emptyFields==total&&total==0)+"|"+emptyFields+"|"+total+"|"+placeholder+"|"+sqlTag+"|"+allValues+"|"+changeInsert+"|"+where+"|"+tablename;
}
*/
///alert("ljs:408 "+results);
return(results);
}
//====
function TableDB_insert_prepare(thatButton){///thatButton,tablename){
var action="insert";
var status=set_header_action(action);if(status===false){update_TitleMessage(action,"stopC");return(status);}
/*
update_TitleMessage("insert","start");//c prépare les lignes en vue d'une insertion
if(!idchoiced)idchoiced={};
*/
/*
var table=thatButton.parentNode.parentNode.parentNode.parentNode;
var trthead2=table.getElementsByTagName('thead')[2].getElementsByTagName('tr')[0];//c opérations pour la ligne sélectionnée
var status=get_status_inputs(trthead2).split("|");//c 
*/
///var status=get_status_inputs(thatButton).split("|");//c 
//!	ranslate 07/08/2020 07:55:25
var msg1=iconWarning+" "+"Aucun champ n'est renseigné pour cette opération!"+chrrc+"Veuillez faire le nécessaire et relancez!";
var msg2=" Le champ "+status[3]+" est vide!";
var msg3=Number(status[1])+" champs "+status[3]+" sont vides!";
var msg4="Vous poursuivez l'insertion d'une ligne quand même?";
var msg5=iconWarning+" "+"Vous voulez dupliquer la ligne sélectionnée ?";
var msg6=iconWarning+" "+"Vous devez cocher la case d'insertion pour cette opération!"+chrrc+"Veuillez faire le nécessaire et recommencez!";
//===
if(Number(status[0])===0){alert(msg1);update_TitleMessage(action,"stopC");return(false);}
if(Number(status[1])!==0){
    var msg=(Number(status[1])===1?msg2:msg3);
    if(!confirm(iconWarning+" "+msg+chrrc+chrrc+msg4)){update_TitleMessage(action,"stopU");return(false);}
}
if(status.join("|")==idchoiced.msi.value)if(!confirm(msg5)){update_TitleMessage(action,"stopU");return(false);}
var o=document.getElementById('idInsertEnabled');
if(o&&!o.checked){alert(msg6);update_TitleMessage(action,"stopC");return(false);}
//===
var req=action+" into "+status[8]+chrrc+"("+status[4]+")"+chrrc+"values"+chrrc+"("+status[5]+")";
//===
idchoiced.thisradio.parentNode.parentNode.style.backgroundColor="white";
idchoiced.thisradio.checked=false;
//===
var table=thatButton.parentNode.parentNode.parentNode.parentNode;
var trtbody=table.getElementsByTagName('tbody')[0].getElementsByTagName('tr')[0];
var R = trtbody; ///table.getElementsByTagName('tbody')[0].getElementsByTagName('tr')[0];
var C = R.cloneNode(true);
table.getElementsByTagName('tbody')[0].insertBefore(C, R);
R.style.backgroundColor=greenLight;
///R.getElementsByTagName('td')[0].getElementsByTagName('input')[0].checked=true;
tds = trtbody.getElementsByTagName('td');
//===
var radio=tds[0].getElementsByTagName('input')[0];
var o=document.getElementById('memo_num_maxId');
var max=Number(o.innerHTML);max++;
o.innerHTML=max;
o=document.getElementById('memo_num_id');
o.innerHTML=max;

radio.setAttribute("onclick","click_radio(this,"+max+");");
///alert(max+chrrc+radio.onclick+chrrc+$('.DataListe').DataTable+chrrc+$('.DataListe').DataTable.fn);
radio.checked=true;////"checked";
status[5]=status[5].split(",");
for (var j = 1; j < tds.length; j++) {
    tds[j].innerHTML=status[5][j].substring(1).replace("'","");
}
///return(false);
//====
send_a_simple_request(encodeURI(req),action+"Table");
return(false);
}
//====
function click_radio(that,id){
idchoiced.selected=true;
if(idchoiced.thisradio&&idchoiced.thisradio!=that){
     var thatTR=idchoiced.thisradio.parentNode.parentNode;
     thatTR.style.backgroundColor="white";
}
idchoiced.thisradio=that;
var thatTR=that.parentNode.parentNode;
thatTR.style.backgroundColor="#ffb347";///orange pastel

idchoiced.thisDefTable="";
var test=TableDB_radio_get_values(that);
////alert('test: '+test);
if(test)
var o=document.getElementById('memo_num_id');
if(o){
    o.innerHTML=id;
    o=document.getElementById('identifiant_du_haut');if(o)o.value=id;
    o=document.getElementById('idDefTable');if(o)idchoiced.thisDefTable=o.value;
}
}
//====
function TableDB_radio_get_values(thatRADIO){
//c 
var thatTR=thatRADIO.parentNode.parentNode;
var tds=thatTR.getElementsByTagName('td');
idchoiced.tds=tds;
var radioId=document.getElementById('identifiant_du_haut');
radioId.value=tds[0].innerHTML;
var table=thatRADIO.parentNode.parentNode.parentNode.parentNode;
var thead0=table.getElementsByTagName('thead')[0];
var thead2=table.getElementsByTagName('thead')[2];
///alert(thead0+'-'+thead2);
if(!thead2)return(false);
idchoiced.values=thead2;
idchoiced.titles=sep;idchoiced.recs=sep;
////for (var i = 0; i < tds.length-1; i++) {
////for (var i = 1; i < tds.length-1; i++) {
for (var i = 1; i < tds.length; i++) {
    var thisTh=thead2.getElementsByTagName('th')[i];
    var select= thisTh.getElementsByTagName('select')[0];
    var intitule=thead0.getElementsByTagName('th')[i].innerHTML;
    var input=thisTh.getElementsByTagName('input')[0];
    var is_input=(input);
    var head=tds[i].innerHTML.trim().substr(0,5); //c '<img '
    if(!is_input&&head==='<img '){
         var src=tds[i].getElementsByTagName('img')[0].src;
         thisTh.getElementsByTagName('img')[0].src=src;
    }
    else{
         input.value=mjsreplaceall(tds[i].innerHTML,'html');///tds[i].innerHTML.replace(/<.*?>/g," ");
         input.style.minWidth='100%';
    }
    tds[i].innerHTML=tds[i].innerHTML.replace('-','##');
    if(intitule!=='?'){
      idchoiced.titles+=sep+intitule;
      idchoiced.recs+=sep+(is_input?input.value:'NC');
    }
//====  update select éventuel
    if(is_input&&select){
        if(select.value!==input.value){
            for (var j = 0; j < select.options.length; j++) {
                 if(select.options[j].value===input.value){
////        alert("select: "+chrrc+j+chrrc+select.options[j].value+chrrc+input.value+chrrc+select.id+chrrc+$('#'+select.id));
                     $('#'+select.id).val(input.value);
                     $('#'+select.id).trigger('change.select2');
                     break;
                 }
            }
        }
    }//c if(is_input&&select)
//====
    if(is_input&&intitule.substring(0,1)==='*'){
         idchoiced.id=input.value;
         idchoiced.idtitle=intitule.replace('*','');
         input.style.backgroundColor=redLight;
///    input..getAttribute("data-status")='red';
         input.disabled=true;
    }
///    alert(intitule);  ///getAttribute("data-status");
    /*
    if ( status == "open" ) { 
        // saisit les données 
    }
    */
        tds[i].innerHTML=tds[i].innerHTML.replace('##','-');

}
///alert('idchoiced.titles 1: '+idchoiced.titles);
idchoiced.titles=idchoiced.titles.replace(sep+sep,''); ///idchoiced.titles='toto';///intitules;
idchoiced.titles=idchoiced.titles.replace('*',''); ///idchoiced.titles='toto';///intitules;
idchoiced.recs=idchoiced.recs.replace(sep+sep,''); ///idchoiced.titles='toto';///intitules;
///idchoiced.values=idchoiced.values.replace(';;',''); ///idchoiced.titles='toto';///intitules;
///alert('idchoiced.titles 2: '+idchoiced.titles);
return(true);
}//c function TableDB_radio_get_values(thatRADIO)
//====
function visualize_rec_of_table(){
/*
update_TitleMessage("visualize","start");
if(!TableDB_verify_if_selected())return(false);
var status=get_status_inputs().split("|");//c idchoiced.values
*/
var action="visualize";
var status=set_header_action(action);if(status===false){update_TitleMessage(action,"stopC");return(status);}
js_get_form_person(status[5],"/appRes/wiw/documents/photos/demo");//!
eview in details

return(false);
}//c function visualize_rec_of_table()
//====
////function update_rec_of_table(tablename,identifiant){
function update_rec_of_table(){
/*
update_TitleMessage("update","start");//c prépare les lignes en vue d'un update
if(!TableDB_verify_if_selected())return(false);
var status=get_status_inputs().split("|");//c idchoiced.values
*/
var action="update";
var status=set_header_action(action);if(status===false){update_TitleMessage(action,"stopC");return(status);}
//!	ranslate 07/08/2020 07:55:25
var msg1=iconWarning+" "+"Vous n'avez pas modifié la ligne sélectionnée?"+chrrc+"Le processus va s'arrêter!";
var msg2=iconWarning+" "+"Faut-il effectuer les modifications suivantes?"+chrrc+"new"+" =>(remplace) "+"old"+chrrc+chrrc;
var msg3=iconWarning+" "+"Vous n'avez apporté aucune modification à la ligne!";
var newvalues=status[5].split("','").join(",").replace("',","");
newvalues=newvalues.substring(0,newvalues.length-1).split(",");
var oldvalues=idchoiced.recs.split(sep);
var changesforalert='';
for (var i = 0; i < newvalues.length; i++) {
     if(newvalues[i]!==oldvalues[i])
         changesforalert+=newvalues[i]+" => "+oldvalues[i]+chrrc;
}
//===
if(changesforalert===""){//c rien n'a été modifié ////===idchoiced.recs){
    // "Vous n'avez pas modifié la ligne sélectionnée?"+chrrc+"Le processus va s'arrêter!"
    alert(msg1);update_TitleMessage(action,"stopC");return(false);
}
//===
if(changesforalert&&confirm(msg2+changesforalert)){
    var radioId=document.getElementById('identifiant_du_haut').value;
    //c update
    var req=action+" "+status[8]+chrrc
       +" SET"+chrrc
          +status[6]+chrrc
            +"WHERE "+chrrc+status[7]+"";
    send_a_simple_request(encodeURI(req),action+"Table");
    return(false);
}//c if(changesforalert&&confirm('\u26a0 '.toUpperCase()+"Faut-il
else
   {update_TitleMessage(action,"stopU");alert(msg3);}
}//c function update_rec_of_table(tablename,identifiant)

alert("666 variales out "+cst['DocumentRoot']+" - "+redLight);