var t;


function HaalRelatieData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalrelatie.php", {lang: lang, idc: rlnr, token:token}, function(data){ 
           $('#relatiespinner').css({'visibility':'hidden'});
           for (key in  data ){           
              for (sleutel in key){
                 if (data[key]['veldsoort']=='checkbox'){ if (data[key]['data']==0){ $('#'+data[key]['veldnaam']).attr({'checked':false}); } else { $('#'+data[key]['veldnaam']).attr({'checked':true}); }
                 } else if (data[key]['veldsoort']=='text'){ $('#'+data[key]['veldnaam']).val(data[key]['data']);
                 } else if (data[key]['veldsoort']=='html'){ $('#'+data[key]['veldnaam']).html('|Record:'+data[key]['data']); }
              }
           }
           $('input').attr({'readonly':'true'}); $('.tabinvoer,.tabkeuze').attr({'readonly':''}); SetRelatieIcons(0,$('#allow_edit_relatie').val(),0,1,0);  $('#pagestatus').val('selected'); $('#relationtabs').css({'display':'block'}); $('#relatiestable').html(''); 
    }, "json");
}

function HaalVeldenData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalveld.php", {lang: lang, idc: rlnr, token:token}, function(data){ 
           $('#relatiespinner').css({'visibility':'hidden'}); size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
                    if (key=='record'){ $('#'+key).html('|Record:'+data[i][key]); } else { $('#'+key).val(data[i][key]); }
                 }
		      }
              $('input').attr({'readonly':'true'}); SetInstellingIcons(0,1,0,1,0); $('#pagestatus').val('selected'); 
           } $('#relatiestable').html('');
        }, "json");
}



function HaalKoppelvelden(rlnr, token, lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'}); 
    jQuery.get("jx_haalkoppelvelden.php", {lang: lang, idc: rlnr, token:token}, function(data){ $('#relatiespinner').css({'visibility':'hidden'}); var answer=data.split('|'); if (answer[0]=='OK'){ $('#koppelveld_s01').val(answer[1]); $('#koppelveld_d01').val(answer[2]); SaveOption('text','koppelveld_s01', token); SaveOption('text','koppelveld_d01', token); } else { alert(data); } }, "text");
}


function HaalKoppelenData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalkoppel.php", {lang: lang, idc: rlnr, token:token}, function(data){ 
           $('#relatiespinner').css({'visibility':'hidden'}); size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
                    if (key=='record'){ $('#'+key).html('|Record:'+data[i][key]); } else { $('#'+key).val(data[i][key]); }
                 }
		      }
              $('input').attr({'readonly':'true'}); SetRelatieIcons(0,$('#allow_edit_relatie').val(),0,1,0); jQuery.get("jx_haalkoppeldata.php", {idc: rlnr, lang:lang, token:token}, function(data){  $('#relatiestable').html(data);
              }, "text"); $('#pagestatus').val('selected'); 
           } $('#relatiestable').html('');
        }, "json");
}

function HaalInstellingData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalinstellingen.php", {lang: lang, idc: rlnr, token:token}, function(data){  
           $('#relatiespinner').css({'visibility':'hidden'}); size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
				    $('#'+key).val(data[i][key]);
			     }
		      }
              $('input,.velden').attr({'readonly':true}); SetInstellingIcons(0,1,0,1,1);
           }   
        }, "json");
}

function HaalFormulierData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalformulier.php", {lang: lang, idc: rlnr, token:token}, function(data){ 
           $('#relatiespinner').css({'visibility':'hidden'});
           //size = data.length;
           size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
                    if (key=='afdrukken' && data[i][key]==1) {$('#afdrukken').attr('checked', true);}
                    if (key=='afdrukken' && data[i][key]==0) {$('#afdrukken').attr('checked', false);}
                    if (key=='orientatie' && data[i][key]==0 ){ $('#portrait').attr({'checked':'checked','disabled':'disabled'}); $('#landscape').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='orientatie' && data[i][key]==1 ){ $('#portrait').attr({'checked':'','disabled':'disabled'}); $('#landscape').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='bladnummer' && data[i][key]==0 ){ $('#number_no').attr({'checked':'checked','disabled':'disabled'}); $('#number_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='bladnummer' && data[i][key]==1 ){ $('#number_no').attr({'checked':'','disabled':'disabled'}); $('#number_yes').attr({'checked':'checked','disabled':'disabled'}); }
				    $('#'+key).val(data[i][key]);
			     }
		      }
              $('input').attr({'readonly':'true'}); SetFormulierIcons(0,$('#allow_edit_form').val(),0,1,0); $('#pagestatus').val('selected');    
           }
           $('#relatiestable').html('');
        }, "json");
}

function HaalGebruikerData(rlnr,token,lang){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalgebruiker.php", {lang: lang, idc: rlnr, token:token}, function(data){
           $('#relatiespinner').css({'visibility':'hidden'});
           //size = data.length;
           size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
                    if (key=='bericht') {$('#bericht').html(data[i][key]);}
                    if (key=='addrelatie' && data[i][key]==0 ){ $('#add_relatie_no').attr({'checked':'checked','disabled':'disabled'}); $('#add_relatie_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='addrelatie' && data[i][key]==1 ){ $('#add_relatie_no').attr({'checked':'','disabled':'disabled'}); $('#add_relatie_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='editrelatie' && data[i][key]==0 ){ $('#edit_relatie_no').attr({'checked':'checked','disabled':'disabled'}); $('#edit_relatie_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='editrelatie' && data[i][key]==1 ){ $('#edit_relatie_no').attr({'checked':'','disabled':'disabled'}); $('#edit_relatie_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='editopties' && data[i][key]==0 ){ $('#edit_opties_no').attr({'checked':'checked','disabled':'disabled'}); $('#edit_opties_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='editopties' && data[i][key]==1 ){ $('#edit_opties_no').attr({'checked':'','disabled':'disabled'}); $('#edit_opties_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='addselect' && data[i][key]==0 ){ $('#add_select_no').attr({'checked':'checked','disabled':'disabled'}); $('#add_select_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='addselect' && data[i][key]==1 ){ $('#add_select_no').attr({'checked':'','disabled':'disabled'}); $('#add_select_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='editselect' && data[i][key]==0 ){ $('#edit_select_no').attr({'checked':'checked','disabled':'disabled'}); $('#edit_select_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='editselect' && data[i][key]==1 ){ $('#edit_select_no').attr({'checked':'','disabled':'disabled'}); $('#edit_select_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='addlist' && data[i][key]==0 ){ $('#add_list_no').attr({'checked':'checked','disabled':'disabled'}); $('#add_list_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='addlist' && data[i][key]==1 ){ $('#add_list_no').attr({'checked':'','disabled':'disabled'}); $('#add_list_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='editlist' && data[i][key]==0 ){ $('#edit_list_no').attr({'checked':'checked','disabled':'disabled'}); $('#edit_list_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='editlist' && data[i][key]==1 ){ $('#edit_list_no').attr({'checked':'','disabled':'disabled'}); $('#edit_list_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='emailselect' && data[i][key]==0 ){ $('#emailselect_no').attr({'checked':'checked','disabled':'disabled'}); $('#emailselect_yes').attr({'checked':'','disabled':'disabled'}); }
                    if (key=='emailselect' && data[i][key]==1 ){ $('#emailselect_no').attr({'checked':'','disabled':'disabled'}); $('#emailselect_yes').attr({'checked':'checked','disabled':'disabled'}); }
                    if (key=='FullOpen' && data[i][key]=='Y') {$('#FullOpen').attr({'checked': true,'disabled':'disabled'});}
                    if (key=='FullOpen' && data[i][key]=='N') {$('#FullOpen').attr({'checked': false,'disabled':'disabled'});}
                    if (key=='naam' || key=='email' || key=='relatie_ID'){ $('#'+key).val(data[i][key]);}
			     }
		      }
              $('input').attr({'readonly':'true'}); SetRelatieIcons(0,1,0,1,0); $('#pagestatus').val('selected');    
           }
           $('#relatiestable').html('');
        }, "json");
}

function HaalSelectieData(rlnr,token,pagina){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_haalselectie.php", {idc: rlnr, token:token}, function(data){ 
       $('#relatiespinner').css({'visibility':'hidden'});
       var answer=data.split('|');
       if (answer[0]=='OK'){
           $('#naam').val(answer[10]); $('#veld1').val(answer[1]); $('#divcmbuitvoer').html(answer[15]); $('#divoperand1').html(answer[2]); $('#divwaarde1').html(answer[3]);
           if (answer[4]!=0){
              if (answer[11]==0 ){ $('#regel2_en').attr({'checked':'checked','disabled':'disabled'}); $('#regel2_of').attr({'checked':'','disabled':'disabled'}); } else { $('#regel2_en').attr({'checked':'','disabled':'disabled'}); $('#regel2_of').attr({'checked':'checked','disabled':'disabled'});}
              $('#veld2').val(answer[4]); $('#divoperand2').html(answer[5]); $('#divwaarde2').html(answer[6]);
           } else {
              $('#regel2_en').attr({'checked':'checked','disabled':'disabled'}); $('#veld2').val(0); $('#divoperand2').html(''); $('#divwaarde2').html('');
           }
           if (answer[7]!=1){
              if (answer[11]==0 ){ $('#regel3_en').attr({'checked':'checked','disabled':'disabled'}); $('#regel3_of').attr({'checked':'','disabled':'disabled'}); } else { $('#regel3_en').attr({'checked':'','disabled':'disabled'}); $('#regel3_of').attr({'checked':'checked','disabled':'disabled'}); }
              $('#veld3').val(answer[7]); $('#divoperand3').html(answer[8]); $('#divwaarde3').html(answer[9]);
           } else {
              $('#regel3_en').attr({'checked':'checked','disabled':'disabled'}); $('#veld3').val(0); $('#divoperand3').html(''); $('#divwaarde3').html('');
           }
           HerSelecteer(token);
           if (answer[13]=='lijst'){ $('#divcmbformulieren,#kiesform').css({'display':'block'}); $('#formulier').val(answer[14]); $('#cmbuitvoer').val(answer[13]); }
           $('input,.operand,.velden').attr({'disabled':'true'});
           if ($('#pagestatus').val()!='edit'){ SetSelectieIcons(0,$('#allow_edit_selectie').val(),0,1,0); }
           $('#uitvoeren').attr({'disabled':''}); $('#pagestatus').val('selected'); $('#selectie_ID').val(rlnr);
       } else {
           alert(data);
       }
    }, "text");
}

function HaalRelatieNaw(rlnr,token,pagina){
    if (rlnr==0) {return;}
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_naw_relatie.php", {idc: rlnr, token:token}, function(data){ 
           $('#relatiespinner').css({'visibility':'hidden'});
           size = data.length;
           if (size){
              for (i=0;i<size;i++) {
	             for ( key in data[i] ){ //get key => value
				    $('#'+key).val(data[i][key]);
			     }
		      }
           } 
        }, "json");
}


function SetRelatieScherm(soort,rlnr,token,lang){
    if (soort=='basis'){
      $('.invoer').val(''); 
      
      SetRelatieIcons($('#allow_add_relatie').val(),0,0,0,1);
      $('input').attr({'readonly':'true'}).css({'borderColor':''});
      $('#Voornaam,#Postcode,#Woonplaats,#Adres,#Land').attr({'readonly':''});
      $('#relatiestable,#record').html('');
      $('#relationtabs,#Voornaam_edit').css({'display':'none'});
      $('#Voornaam').css({'display':'block'});
      $('#GN_nieuwe_adressen').attr({'disabled':'true'}).attr('checked', false);    
      $('#Grenzeloos_Nieuws').attr({'disabled':'true'}).attr('checked', false);    
      $('#pagestatus').val('ready');
      $('#Voornaam_edit').focus();
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('.invoer').val(''); 
          $('#relatie_ID').val('0');
      }
      SetRelatieIcons(0,0,0,1,0);
      $('#Voornaam').attr({'autocomplete':'off'});
      $('#Voornaam_edit').val($('#Voornaam').val()).css({'display':'block'});
      $('#relationtabs,#Voornaam').css({'display':'none'});   
      $('input').attr({'readonly':''});
      $('#Grenzeloos_Nieuws').attr({'disabled':''});    
      $('#GN_nieuwe_adressen').attr({'disabled':''});    
      $('#klantnummer,#dossiernummer,#klantsinds').attr({'readonly':'readonly'});
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
      $('#Voornaam_edit').focus();
    }
}
function SetKoppelScherm(soort,rlnr,token,lang){
    if (soort=='basis'){
      $('.invoer').val(''); 
      SetRelatieIcons($('#allow_add_relatie').val(),0,0,0,1);
      $('input').attr({'readonly':'true'}).css({'borderColor':''});
      $('#tekstveld001,#tekstveld005,#tekstveld007').attr({'readonly':''});
      $('#relatiestable,#record').html('');
      $('#tekstveld001_edit').css({'display':'none'});
      $('#tekstveld001').css({'display':'block'});
      $('#pagestatus').val('ready');
      jQuery.get("jx_listkoppel.php", {lang: lang, idc: rlnr, token:token}, function(data){         $('#relatiespinner').css({'visibility':'hidden'});
           var answer=data.split('|');
           if (answer[0]=='OK'){
              $('#relatiestable').html(answer[1]);
           } else {
              alert(data);     
           }
      }, "text");
      $('#tekstveld001').focus();
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('.invoer').val(''); 
          $('#relatie_ID').val('0');
      }
      SetRelatieIcons(0,0,0,1,0);
      $('#tekstveld001').attr({'autocomplete':'off'});
      $('#tekstveld001_edit').val($('#tekstveld001').val()).css({'display':'block'});
      $('#tekstveld001').css({'display':'none'});   
      $('input').attr({'readonly':''});
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
      $('#tekstveld001_edit').focus();
    }
}

function SetGebruikerScherm(soort,rlnr,token,lang){
    if (soort=='basis'){
      $('.invoer').val(''); 
      
      SetRelatieIcons(1,0,0,0,1);
      $('input').attr({'readonly':'true'}).css({'borderColor':''});
      $('#naam,#email').attr({'readonly':''});
      $('#relatiestable').html('');
      $('#relationtabs,#naam_edit').css({'display':'none'});
      $('#naam').css({'display':'block'});
      $('.keuze').attr({'disabled':'true'});    
      $('#FullOpen').attr({'disabled':'true'}).attr('checked', true);    
      $('#pagestatus').val('ready');
      $('#naam').focus();
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('.invoer').val(''); 
          $('#relatie_ID').val('0');
      }
      SetRelatieIcons(0,0,0,1,0);
      if ($('#bericht').val()==''){
         $('.keuze').attr({'disabled':''});      
      }
      $('#FullOpen').attr({'disabled':''});      
      $('#naam').attr({'autocomplete':'off'});
      $('#naam_edit').val($('#naam').val()).css({'display':'block'});
      $('#relationtabs,#naam').css({'display':'none'});   
      $('input').attr({'readonly':''});
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
      $('#naam_edit').focus();
    }
}

function SetInstellingScherm(soort,rlnr,token,lang){
    if (soort=='basis'){
       SetInstellingIcons(0,1,0,0,0);
       HaalInstellingData(1,token,lang);
       $('.velden').attr({'disabled':'disabled'});
    }  else if (soort=='edit' || soort=='add'){
       $('input,.velden').attr({'disabled':'','readonly':false});
       
       if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
    }       
}

function SetVeldenScherm(soort,token,lang){
    if (soort=='basis'){
      SetInstellingIcons(1,0,0,0,0);
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_listvelden.php", {lang: lang, token: token}, function(data){ $('#relatiespinner').css({'visibility':'hidden'}); var answer=data.split('|'); if (answer[0]=='OK'){ $('#relatiestable').html(answer[1]); } else { alert(data); }}, "text");
      $('.selectveld,.invoerveld').val('').attr({'disabled':true});
      $('#pagestatus').val('ready');
      $('#velden_ID').val('');
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('#velden_ID,#schermnaam').val('');
          $('#regel,#kolom').val(1);
          $('#vervallen,#nietselecteren,#tabblad,#vastevelden').val(0);
          $('#veldsoort').val('checkbox');
      }
      if ($('#vastevelden').val()==1){
          $('#schermnaam').attr({'disabled':'','readonly':false});
      } else {
          $('.selectveld,.invoerveld').attr({'disabled':'','readonly':false});
      }
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
    }
}


function SetSelectieScherm(soort,rlnr,token,lang){
    if (soort=='basis'){
      SetSelectieIcons($('#allow_add_selectie').val(),0,0,0,0);
      $('.velden,#regel2_en,#regel2_of,#regel3_en,#regel3_of').val(0).attr({'disabled':true});
      $('#divtotaal1,#divoperand1,#divwaarde1').html('');$('#relatiestable').html('');
      $('#divtotaal2,#divoperand2,#divwaarde2').html('');$('#divtotaal3,#divoperand3,#divwaarde3').html('');
      $('#tabeluitvoer,#divcmbuitvoer').css({'display':'none'});
      $('#naam').val('').attr({'disabled':true});
      $('#relatiespinner').css({'visibility':'visible'});
      jQuery.get("jx_listselecties.php", {lang: lang, idc: rlnr, token:token}, function(data){         $('#relatiespinner').css({'visibility':'hidden'});
           var answer=data.split('|');
           if (answer[0]=='OK'){
              $('#relatiestable').html(answer[1]);
           } else {
              alert(data);     
           }
      }, "text");
        
      $('#pagestatus').val('ready');
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('#selectie_ID').val('0');
          $('#regel2_en,#regel3_en').attr({'checked':'checked'});
          
      }
      $('.operand,.velden').attr({'disabled':''});
      $('#naam,#regel2_en,#regel2_of,#regel3_en,#regel3_of').attr({'disabled':''});
      $('#relatiestable').html('');
   
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}

   } 
}

function SetFormulierScherm(soort,rlnr,token,lang,papier){
    if (soort=='basis'){
      SetFormulierIcons($('#allow_add_form').val(),0,0,0,1);
      $('.velden,#afdrukken,#naam,#papier,#portrait,#landscape,#logo,#number_yes,#number_no').attr({'disabled':true});
      $('.velden,#logo').val(0);
      $('#papier').val(papier);
      $('#logo_pos').val(1);
      $('#portrait').attr({'checked':''});
      $('#landscape').attr({'checked':'checked'});
      $('#naam').val('');
      jQuery.get("jx_listformulieren.php", {lang: lang, idc: rlnr, token:token}, function(data){         $('#relatiespinner').css({'visibility':'hidden'});
           var answer=data.split('|');
           if (answer[0]=='OK'){
              $('#relatiestable').html(answer[1]);
           } else {
              alert(data);     
           }
      }, "text");
        
      $('#pagestatus').val('ready');
    } else if (soort=='edit' || soort=='add'){
      if (soort=='add') {
          $('#formulier_ID').val('0');
          $('#logo_pos').val(1);
          $('#portrait').attr({'checked':''});
          $('#landscape').attr({'checked':'checked'});
          $('#papier').val(papier);
      }
      $('.velden').attr({'disabled':''});
      $('#naam,#afdrukken,#naam,#papier,#portrait,#landscape,#logo,#number_yes,#number_no').attr({'disabled':''});
      $('#relatiestable').html('');
      SetFormulierIcons(0,0,0,1,0);
      if (soort=='add'){ $('#pagestatus').val('add'); } else { $('#pagestatus').val('edit');}
    }
}

function HerSelecteer(token){
    var idc2=''; var opr2=0; var val2=''; var idc3=''; var opr3=0; var val3='';
    var idc1=$('#veld1').val();
    var opr1=$('#operand1').val();
    var val1=$('#waarde1').val();
    var bReg2=0;var bReg3=0;
    if($('#regel2_of').is(':checked')===true){ bReg2=1; }
    if($('#regel3_of').is(':checked')===true){ bReg3=1; }
    idc2=$('#veld2').val(); opr2=$('#operand2').val(); val2=$('#waarde2').val();
    idc3=$('#veld3').val(); opr3=$('#operand3').val(); val3=$('#waarde3').val();
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get('jx_herselecteercriteria.php',{idc1:idc1, idc2:idc2, idc3:idc3, opr1:opr1, opr2:opr2, opr3:opr3, val1:val1, val2:val2, val3:val3, regel2:bReg2, regel3:bReg3, token:token}, function(data){ 
          $('#relatiespinner').css({'visibility':'hidden'});
          var answer=data.split('|');
           if (answer[0]=='OK'){ 
              $('#divtotaal1').html('');
              $('#divtotaal2').html('');$('#divtotaal3').html('');
              $('#divtotaal3').html(answer[2]);
              $('#relatiestable').html(answer[3]);
              $('#tabeluitvoer,#divcmbuitvoer').css({'display':'block'});
              if ($('#pagestatus').val()!='edit'){
                 SetSelectieIcons(0,$('#allow_edit_selectie').val(),0,1,0);
              }
           } else {
              $('#divtotaal1').html('');$('#relatiestable').html('');
              $('#divtotaal2').html('');$('#divtotaal3').html('');
              $('#tabeluitvoer,#divcmbuitvoer').css({'display':'none'});
              alert(data);
            }
        }, 'text');
}

function HaalEmailSelectie(token){
    var idc2=''; var opr2=0; var val2=''; var idc3=''; var opr3=0; var val3='';
    var idc1=$('#veld1').val(); var opr1=$('#operand1').val(); var val1=$('#waarde1').val(); var bReg=1;
    var bReg2=0;var bReg3=0;
    if($('#regel2_of').is(':checked')===true){ bReg2=1; }
    if($('#regel3_of').is(':checked')===true){ bReg3=1; }
    idc2=$('#veld2').val(); opr2=$('#operand2').val(); val2=$('#waarde2').val();
    idc3=$('#veld3').val(); opr3=$('#operand3').val(); val3=$('#waarde3').val();
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get('jx_makeemaillist.php',{idc1:idc1, idc2:idc2, idc3:idc3, opr1:opr1, opr2:opr2, opr3:opr3, val1:val1, val2:val2, val3:val3, regel2:bReg2, regel3:bReg3, token:token}, function(data){ 
          $('#relatiespinner').css({'visibility':'hidden'});
          var answer=data.split('|');
           if (answer[0]=='OK'){
              $('#relatiestable').html(answer[1]);
           } else {
              $('#relatiestable').html('');
              alert(data);
            }
        }, 'text');
}

function VindRelatie(token, lang,srcoptions){
    var postcode=$('#Postcode').val(); var relafirma=$('#Organisatie').val(); var relanaam=$('#Voornaam').val(); var relaplaats=$('#Woonplaats').val(); var relafamilienaam=$('#Achternaam').val(); var relaadres=$('#Adres').val(); var relaland=$('#Land').val();  var sroptions=false; if (postcode.length>1 || relafirma.length>1 || relanaam.length>1){ sroptions=true;} if (relafamilienaam.length>0 || relaland.length>1 || relaplaats.length>1 || relaadres.length>0){ sroptions=true;}
    if (sroptions===false){ alert(srcoptions); return false; } 
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_vindrelatie.php", {lang: lang, idpc: postcode, idrf: relafirma, idnm:relanaam, idpl:relaplaats, idhn:relafamilienaam,idad:relaadres, idlnd:relaland, token:token}, function(data){ 
        var answer=data.split('|');
        if (answer[0]=='OK'){
           if (answer[1]==0){ 
              SetRelatieIcons(5,5,5,1,0);
              $('#relatiespinner').css({'visibility':'hidden'});
              $('#relatiestable').html(answer[2]);
              $('#pagestatus').val('list');    
           } else {
              $('#relatiestable,#record').html('');    
              HaalRelatieData(answer[1],token);
           }
        } else if (answer[0]=='ERROR'){
            $('#relatiespinner').css({'visibility':'hidden'});
            alert (answer[1]);
        } else {
            $('#relatiespinner').css({'visibility':'hidden'});
            alert(data);
        }
        }, "text");
}

function VindKoppelen(token, lang,srcoptions){
    var relaproject=$('#tekstveld001').val(); var relacontact=$('#tekstveld002').val(); var relacity=$('#tekstveld005').val(); var relaland=$('#tekstveld007').val();var sroptions=false; if (relaproject.length>1 || relacontact.length>1){ sroptions=true; } if (relaland.length>1 || relacity.length>1){ sroptions=true; }
    if (sroptions===false){ alert(srcoptions); return false; } 
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_vindkoppel.php", {lang: lang, idpr: relaproject, idct: relacontact, idpl:relacity, idlnd:relaland, token:token}, function(data){ 
        var answer=data.split('|');
        if (answer[0]=='OK'){
           if (answer[1]==0){ 
              SetRelatieIcons(5,5,5,1,0);
              $('#relatiespinner').css({'visibility':'hidden'});
              $('#relatiestable').html(answer[2]);
              $('#pagestatus').val('list');    
           } else {
              $('#relatiestable,#record').html('');    
              HaalKoppelenData(answer[1],token);
           }
        } else if (answer[0]=='ERROR'){
            $('#relatiespinner').css({'visibility':'hidden'});
            alert (answer[1]);
        } else {
            $('#relatiespinner').css({'visibility':'hidden'});
            alert(data);
        }
        }, "text");
}

function VindGebruiker(token, lang,srcoptions){
    var relanaam=$('#naam').val(); var relaemail=$('#email').val(); var sroptions=false; if (relanaam.length>1 || relaemail.length>1){ sroptions=true;}
    if (sroptions===false){ alert(srcoptions); return false;} 
    $('#relatiespinner').css({'visibility':'visible'});
    jQuery.get("jx_vindgebruiker.php", {lang: lang, idnm:relanaam, idem:relaemail, token:token}, function(data){ 
        var answer=data.split('|');
        if (answer[0]=='OK'){
           if (answer[1]==0){ 
              SetRelatieIcons(5,5,5,1,0);
              $('#relatiespinner').css({'visibility':'hidden'});
              $('#relatiestable').html(answer[2]);
              $('#pagestatus').val('list');    
           } else {
              $('#relatiestable,#record').html('');    
              HaalGebruikerData(answer[1],token);
           }
        } else if (answer[0]=='ERROR'){
            $('#relatiespinner').css({'visibility':'hidden'});
            alert (answer[1]);
        } else {
            $('#relatiespinner').css({'visibility':'hidden'});
            alert(data);
        }
        }, "text");
}

function UitvoerSelectie(){
    if($('#cmbuitvoer').val()=='lijst'){
        $('#divcmbformulieren,#kiesform').css({'display':'block'}); $('#formulier').val(0); $('#uitvoeren').attr({'disabled':'true'});    
    } else {
        $('#divcmbformulieren,#kiesform').css({'display':'none'});
        if($('#cmbuitvoer').val()=='stickers' || $('#cmbuitvoer').val()=='email'){ $('#uitvoeren').attr({'disabled':''}); } else { $('#uitvoeren').attr({'disabled':'true'}); }
    }
}

function SetChanged(token){
    if ($('#pagestatus').val()=='edit' || $('#pagestatus').val()=='add'){
       SetRelatieIcons(0,0,$('#allow_edit_relatie').val(),1,0);
       $('#pagestatus').val('changed');
    }
}

function LostPassword(){
   answer=EmailFormat('username','Dit is geen geldig emailadres.');   
   if (answer===true){ jQuery.get("jx_lostpassword.php", {idc: $('#username').val()}, function(data){ alert(data); }, "text"); }
}

function SaveOption(veldsoort,veldnaam,token){
   $('#relatiespinner').css({'visibility':'visible'});
   if (veldsoort=='text'){
        var soSel=$('#'+veldnaam).val();
   } else if (veldsoort=='checkbox') {
        var soSel=0;
        if($('#'+veldnaam).is(':checked')===true){ soSel=1; }
   } 
   jQuery.get("jx_updateopties.php", {idc: $('#relatie_ID').val(),veld:veldnaam,waarde:soSel,token:token }, function(data){ $('#relatiespinner').css({'visibility':'hidden'}); if (data!='OK'){ alert(data); } }, "text");
}

function GetotherPage(newUrl){
   window.location = newUrl;
}

function SetReferrer(){
    // If referrer cookie present skip it
    if (!GetCookie ('referrer')){  var temp; var cookie_ok=false; if (document.referrer=='' || !document.referrer){ temp='manual'; SetCookie('referrer',temp); cookie_ok=true; } else { temp=document.referrer; SetCookie('referrer',temp); cookie_ok=true; } if (cookie_ok){ jQuery.get("set"+"ref"+"er"+"rer.p"+"hp");  }
    }   
}

function SetCookie(cookieName,cookieValue,nDays) {
    // all cookies are deleted at closing browser/session
    var today = new Date();
    var expire = new Date();
    if (nDays==null || nDays==0) {nDays=1};
    expire.setTime(today.getTime() + 3600000*2*nDays);
    document.cookie = cookieName+'='+escape(cookieValue);
}	 
function GetCookie(check_name) {
	// first we'll split this cookie up into name/value pairs
	// note: document.cookie only returns name=value, not the other components
	var a_all_cookies = document.cookie.split( ';' );
	var a_temp_cookie = '';
	var cookie_name = '';
	var cookie_value = '';
	var b_cookie_found = false; // set boolean t/f default f
	for ( i = 0; i < a_all_cookies.length; i++ ){
		// now we'll split apart each name=value pair
		a_temp_cookie = a_all_cookies[i].split( '=' );
		// and trim left/right whitespace while we're at it
		cookie_name = a_temp_cookie[0].replace(/^\s+|\s+$/g, '');
		// if the extracted name matches passed check_name
		if ( cookie_name == check_name ) {
			b_cookie_found = true;
			//we need to handle case where cookie has no value but exists (no = sign, that is):
			if ( a_temp_cookie.length > 1 )	{
				cookie_value = unescape( a_temp_cookie[1].replace(/^\s+|\s+$/g, '') );
			}
			// note that in cases where cookie is initialized but no value, null is returned
			return cookie_value;
			//break;
		}
		a_temp_cookie = null;
		cookie_name = '';
	}
	if ( !b_cookie_found ){
		return null;
	}
}				

function CountLeft(field, count, max) {
// if the length of the string in the input field is greater than the max value, trim it
if (field.value.length > max) {
  field.value = field.value.substring(0, max);
} else {
// calculate the remaining characters
count.value = max - field.value.length;
}
}

function checkTimeZone() {
    // current date and time of user
    var rightNow = new Date();
    var date5 = rightNow;
    // first januari 1st for this user
    var date1 = new Date(rightNow.getFullYear(), 0, 1, 0, 0, 0, 0);
    // find july 1st for this user
    var date2 = new Date(rightNow.getFullYear(), 6, 1, 0, 0, 0, 0);
    // convert januari 1st to GMT
    var temp = date1.toGMTString();
    var date3 = new Date(temp.substring(0, temp.lastIndexOf(" ")-1));
    // convert july 1st to GMT 
    temp = date2.toGMTString();
    var date4 = new Date(temp.substring(0, temp.lastIndexOf(" ")-1));
    // convert current time to GMT    
    temp = date5.toGMTString();
    var date6 = new Date(temp.substring(0, temp.lastIndexOf(" ")-1));
    // find the difference in hours between januari 1 user and januari 1 GMT
    var hoursDiffStdTime = (date1 - date3) / (1000 * 60 * 60);
    // find the difference in hours between juli 1 user and juli 1 GMT 
    var hoursDiffDaylightTime = (date2 - date4) / (1000 * 60 * 60);
    // If the hours differ the user uses Daylight Saving Time
    if (hoursDiffDaylightTime>hoursDiffStdTime) { DstValidForThisUser=1;} else{ DstValidForThisUser=0;}
    // Calculate the minutes difference between user en GMT
    var minsDiffCurrentTime = Math.round((date5 - date6) / (1000 * 60));
    SetCookie("TimeZone",hoursDiffStdTime);
    SetCookie("DST_Difference",hoursDiffDaylightTime);
    SetCookie("DST_Used",DstValidForThisUser);
    SetCookie("Current_difference",minsDiffCurrentTime);
}
function getURLParam(strParamName){
  var strReturn = "";
  var strHref = window.location.href;
  if ( strHref.indexOf("?") > -1 ){
    var strQueryString = strHref.substr(strHref.indexOf("?")).toLowerCase();
    var aQueryString = strQueryString.split("&");
    for ( var iParam = 0; iParam < aQueryString.length; iParam++ ){
      if (aQueryString[iParam].indexOf(strParamName.toLowerCase() + "=") > -1 ){
        var aParam = aQueryString[iParam].split("=");
        strReturn = aParam[1];
        break;
      }
    }
  }
  return unescape(strReturn);
} 
function getURLQuery(){
  var strReturn = "";
  var strHref = window.location.href;
  if ( strHref.indexOf("?") > -1 ){
    var strQueryString = strHref.substr(strHref.indexOf("?"));
    strReturn = strQueryString.toUpperCase();
  }
  return unescape(strReturn);
} 

function AmountFormat(AmountField,DecPlaces){
     var newPrice=""; var valPrices=$('#'+AmountField).val(); var lenPrices=valPrices.length; if (lenPrices==0) return; var strTemp =""; var chrAllowed="0123456789.,-"; var dotcount=0; var negnumber=0;
     for (i = lenPrices; i>=0; i--){ 
         if(chrAllowed.indexOf(valPrices.charAt(i)) != -1) { 
             if (valPrices.charAt(i)!='.' && valPrices.charAt(i)!=',') {
                     newPrice = valPrices.charAt(i) + newPrice;
                  if (valPrices.charAt(i)=='-'){ break; }
             } else { 
                  strTemp='.'; 
                  if (dotcount==0 && newPrice!=""){ newPrice = strTemp + newPrice ; dotcount=1; } 
             } 
         } 
     }
     newPrice = parseFloat(newPrice).toFixed(DecPlaces); 
     if (newPrice==='NaN') { newPrice="0"; } 
     newPrice = parseFloat(newPrice).toFixed(DecPlaces); 
     if (newPrice!=valPrices){ $('#'+AmountField).val(newPrice); return; } 
}

function EmailFormat(eField,msgWrong){
    if ($('#'+eField).val().length==0) {return true; }
    var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/;
    if($('#'+eField).val().match(emailExp)){
       $('#'+eField).css({'borderColor':''}); return true;
    } else {
       alert(msgWrong); $('#'+eField).css({'borderColor':'red'}); return false;
    } 
}

function PasswordStrength(PassField,answerField,minLength){
     var strPassfield=$('#'+PassField).val(); var lenPassfield=strPassfield.length; var valchar=0; var Numbers=0;var LowCase=0;var UpCase=0; var Others=0;
     if (lenPassfield==0) { $('#'+answerField).html(''); return; }
     var strTemp =""; var chrNotAllowed=";=%()[]{}:'`,"; 
     var strength=0;
     for (i =0; i<lenPassfield; i++){ 
         if(chrNotAllowed.indexOf(strPassfield.charAt(i)) != -1) { $('#'+PassField).val('');  alert('Er is een ongeldig letterteken gebruikt in het wachtwoord.\n\nDe volgende lettertekens mogen niet gebruikt worden. ; : , = % ( ) [ ] { }  \' ` " '); }         
         valchar=strPassfield.charCodeAt(i); 
         if (valchar>=97 && valchar<=122){ if (LowCase==0){ strength++; }
             LowCase++;
         } else if (valchar>=65 && valchar<=90){ if (UpCase==0){ strength++; }
             UpCase++; 
         } else if (valchar>=48 && valchar<=57) { if (Numbers==0){ strength++; }
             Numbers++; 
         } else {
             if (Others==0){ strength++; }
             Others++;       
         }
     }
     if (lenPassfield<minLength){  var xtra=' te kort'; } else { var xtra=''; }  
     if (strength==4){ $('#'+answerField).html('<span style="color:green;">Zeer sterk'+xtra+'</span>');       
     } else if (strength==3){ $('#'+answerField).html('<span style="color:blue;">Sterk'+xtra+'</span');       
     } else if (strength==2){ $('#'+answerField).html('<span style="color:orange;">Zwak'+xtra+'</span>');       
     } else if (strength==1){ $('#'+answerField).html('<span style="color:red;">Zeer zwak'+xtra+'</span>'); }
}

function SelectedMenuItem(){
    var choice=$('#menuselect').val();
    for (i=0;i<=9;i++){ if (choice!=i){ $('#menu_item'+i).addClass('href_menu'); } else { $('#menu_item'+i).addClass('href_menu_select'); } }
}

function stringifyObj(o) {
  var stringified = "";
  if (typeof(o) == "object") {
     stringified = "{";
    var first =true;
    for (var key in o) {
      if(!first) { stringified +=","; }
      else { first =false; }
      stringified +=(typeof(o[key]) == "object") ? stringifyObj(o[key]) : '"' +key +'":"' +o[key] +'"';
    }
    stringified +="}";
  }
  return stringified;
}

function urlencode(str) {
return escape(str).replace(/\+/g,'%2B').replace(/%20/g, '+').replace(/\*/g, '%2A').replace(/\//g, '%2F').replace(/@/g, '%40');
}

function SetRelatieIcons(iAdd,iEdit,iSave, iRepeat,iSearch){
    if (iAdd==1){ $('#icon_add').removeClass('icondisable').addClass('iconhover').attr({'src':'images/add.png'}); } else if (iAdd==0){ $('#icon_add').removeClass('iconhover').addClass('icondisable').attr({'src':'images/add_disable.png'}); }
    if (iEdit==1){ $('#icon_edit').removeClass('icondisable').addClass('iconhover').attr({'src':'images/user_edit.png'}); $('#icon_delete').removeClass('icondisable').addClass('iconhover').attr({'src':'images/delete.png'}); } else if (iEdit==0){ $('#icon_edit').removeClass('iconhover').addClass('icondisable').attr({'src':'images/user_edit_disable.png'}); $('#icon_delete').removeClass('iconhover').addClass('icondisable').attr({'src':'images/delete_disable.png'}); }
    if (iSave==1){ $('#icon_save').removeClass('icondisable').addClass('iconhover').attr({'src':'images/accept.png'}); } else if (iSave==0){ $('#icon_save').removeClass('iconhover').addClass('icondisable').attr({'src':'images/accept_disable.png'}); }
    if (iRepeat==1){ $('#icon_repeat').removeClass('icondisable').addClass('iconhover').attr({'src':'images/repeat.png'}); } else if (iRepeat==0){ $('#icon_repeat').removeClass('iconhover').addClass('icondisable').attr({'src':'images/repeat_disable.png'}); }
    if (iSearch==1){ $('#icon_search').removeClass('icondisable').addClass('iconhover').attr({'src':'images/search.png'}); } else if (iSearch==0){ $('#icon_search').removeClass('iconhover').addClass('icondisable').attr({'src':'images/search_disable.png'}); }
}

function SetSelectieIcons(iAdd,iEdit,iSave, iRepeat,iSearch){
    if (iAdd==1){ $('#icon_add').removeClass('icondisable').addClass('iconhover').attr({'src':'images/add.png'}); } else if (iAdd==0){ $('#icon_add').removeClass('iconhover').addClass('icondisable').attr({'src':'images/add_disable.png'}); }
    if (iEdit==1){ $('#icon_edit').removeClass('icondisable').addClass('iconhover').attr({'src':'images/p_edit.png'}); $('#icon_delete').removeClass('icondisable').addClass('iconhover').attr({'src':'images/delete.png'}); } else if (iEdit==0){ $('#icon_edit').removeClass('iconhover').addClass('icondisable').attr({'src':'images/p_edit_disable.png'}); $('#icon_delete').removeClass('iconhover').addClass('icondisable').attr({'src':'images/delete_disable.png'}); }
    if (iSave==1){ $('#icon_save').removeClass('icondisable').addClass('iconhover').attr({'src':'images/accept.png'}); } else if (iSave==0){ $('#icon_save').removeClass('iconhover').addClass('icondisable').attr({'src':'images/accept_disable.png'}); }
    if (iRepeat==1){ $('#icon_repeat').removeClass('icondisable').addClass('iconhover').attr({'src':'images/repeat.png'}); } else if (iRepeat==0){ $('#icon_repeat').removeClass('iconhover').addClass('icondisable').attr({'src':'images/repeat_disable.png'}); }
    if (iSearch==1){ $('#icon_search').removeClass('icondisable').addClass('iconhover').attr({'src':'images/search.png'}); } else if (iSearch==0){ $('#icon_search').removeClass('iconhover').addClass('icondisable').attr({'src':'images/search_disable.png'}); }
}

function SetFormulierIcons(iAdd,iEdit,iSave, iRepeat,iSearch){
    if (iAdd==1){ $('#icon_add').removeClass('icondisable').addClass('iconhover').attr({'src':'images/add.png'}); } else if (iAdd==0){ $('#icon_add').removeClass('iconhover').addClass('icondisable').attr({'src':'images/add_disable.png'}); }
    if (iEdit==1){ $('#icon_edit').removeClass('icondisable').addClass('iconhover').attr({'src':'images/form_edit.png'}); $('#icon_delete').removeClass('icondisable').addClass('iconhover').attr({'src':'images/delete.png'}); } else if (iEdit==0){ $('#icon_edit').removeClass('iconhover').addClass('icondisable').attr({'src':'images/form_edit_disable.png'}); $('#icon_delete').removeClass('iconhover').addClass('icondisable').attr({'src':'images/delete_disable.png'}); }
    if (iSave==1){ $('#icon_save').removeClass('icondisable').addClass('iconhover').attr({'src':'images/accept.png'}); } else if (iSave==0){ $('#icon_save').removeClass('iconhover').addClass('icondisable').attr({'src':'images/accept_disable.png'}); }
    if (iRepeat==1){ $('#icon_repeat').removeClass('icondisable').addClass('iconhover').attr({'src':'images/repeat.png'}); } else if (iRepeat==0){ $('#icon_repeat').removeClass('iconhover').addClass('icondisable').attr({'src':'images/repeat_disable.png'}); }
    if (iSearch==1){ $('#icon_search').removeClass('icondisable').addClass('iconhover').attr({'src':'images/search.png'}); } else if (iSearch==0){ $('#icon_search').removeClass('iconhover').addClass('icondisable').attr({'src':'images/search_disable.png'}); }
}

function SetInstellingIcons(iAdd,iEdit,iSave, iRepeat,iSearch){
    if (iAdd==1){ $('#icon_add').removeClass('icondisable').addClass('iconhover').attr({'src':'images/add.png'}); } else if (iAdd==0){ $('#icon_add').removeClass('iconhover').addClass('icondisable').attr({'src':'images/add_disable.png'}); }
    if (iEdit==1){ $('#icon_edit').removeClass('icondisable').addClass('iconhover').attr({'src':'images/p_edit.png'}); } else if (iEdit==0){ $('#icon_edit').removeClass('iconhover').addClass('icondisable').attr({'src':'images/p_edit_disable.png'}); }
    if (iSave==1){ $('#icon_save').removeClass('icondisable').addClass('iconhover').attr({'src':'images/accept.png'}); } else if (iSave==0){ $('#icon_save').removeClass('iconhover').addClass('icondisable').attr({'src':'images/accept_disable.png'}); }
    if (iRepeat==1){ $('#icon_repeat').removeClass('icondisable').addClass('iconhover').attr({'src':'images/repeat.png'}); } else if (iRepeat==0){ $('#icon_repeat').removeClass('iconhover').addClass('icondisable').attr({'src':'images/repeat_disable.png'}); }
    if (iSearch==1){ $('#icon_search').removeClass('icondisable').addClass('iconhover').attr({'src':'images/velden.png'}); } else if (iSearch==0){ $('#icon_search').removeClass('iconhover').addClass('icondisable').attr({'src':'images/velden_disable.png'}); }
}