var xmlHttp = getXmlHttpObject();

function loadList(tb, idl, idc){
xmlHttp.open('GET', 'request.php?table='+tb+'&id='+idl+'&idc='+idc, true);
xmlHttp.onreadystatechange = stateChanged;
xmlHttp.send(null);
}
function loadTable(tb, idl, idc){
xmlHttp.open('GET', 'request2.php?table='+tb+'&id='+idl+'&idc='+idc, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTable2(tb, idl, idc){
xmlHttp.open('GET', 'request4.php?table='+tb+'&id='+idl+'&idc='+idc, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTableSim(tb, idconc,pid,cid,lim,cam,ord){
xmlHttp.open('GET', 'requestSim.php?table='+tb+'&idconc='+idconc+'&pid='+pid+'&cid='+cid+'&lim='+lim+'&cam='+cam+'&ord='+ord, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTableConc(tb, idconc,pid,cid,lim,cam,ord){
xmlHttp.open('GET', 'requestConc.php?table='+tb+'&idconc='+idconc+'&pid='+pid+'&cid='+cid+'&lim='+lim+'&cam='+cam+'&ord='+ord, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTable2l(tb, idl, idc, lim){
xmlHttp.open('GET', 'request4.php?table='+tb+'&id='+idl+'&idc='+idc+'&limiti='+lim, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTableOrd(tb, idl, idc,campo,ordine,lim){
xmlHttp.open('GET', 'requestOrd.php?table='+tb+'&id='+idl+'&idc='+idc+'&campo='+campo+'&ordine='+ordine+'&limiti='+lim, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadTableOrdL(tb, idl, idc,campo,ordine,lim){
xmlHttp.open('GET', 'requestOrd.php?table='+tb+'&id='+idl+'&idc='+idc+'&campo='+campo+'&ordine='+ordine+'&limiti='+lim, true);
xmlHttp.onreadystatechange = stateChangedTable;
xmlHttp.send(null);
}
function loadSession(id){
xmlHttp.open('GET', 'request3.php?id='+id, true);
/*xmlHttp.onreadystatechange = stateChangedTable;*/
xmlHttp.send(null);
}
function addOption(select, value, text) {
    //Aggiunge un elemento <option> ad una lista <select>
    var option = document.createElement("option");
    option.value = value,
    option.text = text;
    try {
        select.add(option, null);
    } catch(e) {
        //Per Internet Explorer
        select.add(option);
    }
}
function getSelected(select) {
    //Ritorna il valore dell'elemento <option> selezionato in una lista
    return select.options[select.selectedIndex].value;
}
function stateChanged() {
    if(xmlHttp.readyState == 4) {
        //Stato OK
        if (xmlHttp.status == 200) {
            var resp = xmlHttp.responseText;
            
            if(resp) {
                //Le coppie di valori nella striga di risposta sono separate da ;
                var values = resp.split(';');
                //Il primo elemento è l'ID della lista.
                var listId = values.shift();

                
                var select = document.getElementById(listId);
                //Elimina i valori precedenti
                while (select.options.length) {
                    select.remove(0);
                } 
                
                if(listId == 'codart') {
                    addOption (select, 0, '..Seleziona codice articolo..');
                }              
                var limit = values.length;
                
                for(i=0; i < limit; i++) {
                    var pair = values[i].split('|');
                    //aggiunge un elemento <option>
                    addOption(select, pair[0], pair[1]);
                }
            }
        } else {
            //alert(xmlHttp.responseText);
        }
    }
}

function stateChangedTable() {
    if(xmlHttp.readyState == 4) {
        //Stato OK
        if (xmlHttp.status == 200) {
            var resp = xmlHttp.responseText;
            
            if(resp) {
                //Le coppie di valori nella striga di risposta sono separate da ;
                var values = resp.split(';');
                //Il primo elemento è l'ID della lista.
                var listId = values.shift();
                var table = document.getElementById(listId);
                //Elimina i valori precedenti
                while (table.rows.length!=1) {
                    table.deleteRow(1);
                } 
                
              
                var limit = values.length;
                var vaidietro = '0';
                for(i=0; i < limit; i++) {
                    var pair = values[i].split('|');
                    //aggiunge un elemento <option>
                    if(pair[2]!='1' && pair[3]!='1') 
                    {
                        if(pair[16]=='123456789')
                        {
                                if(vaidietro!='1')
                                {    
                                vaidietro=1;    
                                var riga2=table.insertRow(table.rows.length);
                                 
                                indietro = document.createElement("div");
                                indietro.setAttribute('id','BackToDelete');
                                var te2;
                                    if(pair[13]!='')
                                    {
                                        
                                    te2='<center><b onclick="attesa();loadTableOrd(\'tabella1\',\''+pair[10]+'\',\''+pair[11]+'\',\''+pair[13]+'\',\''+pair[14]+'\',\''+pair[12]+'\');visualizzaOrdini();document.getElementById(\'nascostoBack\').innerHTML=\'\';" style="font-size:12px;line-height:12px;cursor:pointer;" title="Torna alla lista articoli"><- Torna alla lista articoli</b></center>'; 
                                    }
                                    else
                                    {
                                    
                                    te2='<center><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[10]+'\',\''+pair[11]+'\',\''+pair[12]+'\');visualizzaOrdini();document.getElementById(\'nascostoBack\').innerHTML=\'\';" style="font-size:12px;line-height:12px;cursor:pointer;" title="Torna alla lista articoli"><- Torna alla lista articoli</b></center>';   
                                        
                                    }                   
                                indietro.innerHTML=te2;
                                document.getElementById('nascostoBack').innerHTML=''; 
                                document.getElementById('nascostoBack').appendChild(indietro); 
                        
                                } 
                        }                        
                    var riga=table.insertRow(table.rows.length);
                    if(i % 2 == 0){ 
                    riga.className = "even";
                    riga.style.fontSize='12px';
                    }else{
                    riga.className = "odd";
                    riga.style.fontSize='12px';
                    } 
                    

                    
                    var img8=new Image();
                    img8.src=pair[8];
                    if(pair[8].match("red")!=null)
                    { 
                    img8.title='Prodotto non disponibile';
                    }
                    else
                    {
                    img8.title='Prodotto disponibile'; 
                    }
                    img8.style.height='20px';
                    img8.style.width='10px';
                    riga.insertCell(0).appendChild(img8); 
                    
                    
                    var img7=new Image();
                    img7.src=pair[7];
                    if(pair[7].match("red")!=null)
                    { 
                    img7.title='Prodotto non disponibile';
                    }
                    else
                    {
                    img7.title='Prodotto disponibile'; 
                    }                    
                    img7.style.height='20px';
                    img7.style.width='10px';                     
                    riga.insertCell(0).appendChild(img7); 
                    
                    
                    var img6=new Image();
                    img6.src=pair[6];
                    if(pair[6].match("red")!=null)
                    { 
                    img6.title='Prodotto non disponibile';
                    }
                    else
                    {
                    img6.title='Prodotto disponibile'; 
                    }                    
                    img6.style.height='20px';
                    img6.style.width='10px';                     
                    riga.insertCell(0).appendChild(img6); 
                    if(pair[9]!='0')
                    {
                    alternative = document.createElement("div");
                    
                    var te;
                    te='<b onclick="attesa();loadTableSim(\'tabella1\',\''+pair[9]+'\',\''+pair[10]+'\',\''+pair[11]+'\',\''+pair[12]+'\',\''+pair[13]+'\',\''+pair[14]+'\');nascondiOrdini();" style="font-size:10px;line-height:12px;cursor:pointer;color:#008000;" title="Mostra prodotti sostituenti">mostra<br />sostituenti</b>';                    
                    alternative.innerHTML=te;
                    riga.insertCell(0).appendChild(alternative); 
                    
                    }
                    else
                    {
                    riga.insertCell(0).appendChild(document.createTextNode(''));     
                    } 
                    if(pair[15]!='0')
                    {
                    alternative3 = document.createElement("div");
                    
                    var te3;
                    te3='<b onclick="attesa();loadTableConc(\'tabella1\',\''+pair[15]+'\',\''+pair[10]+'\',\''+pair[11]+'\',\''+pair[12]+'\',\''+pair[13]+'\',\''+pair[14]+'\');nascondiOrdini();" style="font-size:10px;line-height:12px;cursor:pointer;color:#008000;" title="Mostra prodotti concorrenti">mostra<br />concorrenti</b>';                    
                    alternative3.innerHTML=te3;
                    riga.insertCell(0).appendChild(alternative3); 
                    
                    }
                    else
                    {
                    riga.insertCell(0).appendChild(document.createTextNode(''));     
                    }                                                              
                    
                    riga.insertCell(0).appendChild(document.createTextNode(pair[4])); 
                    riga.insertCell(0).appendChild(document.createTextNode(pair[3])); 
                    riga.insertCell(0).appendChild(document.createTextNode(pair[2]));
                    riga.insertCell(0).appendChild(document.createTextNode(pair[1])); 
                    
                    
                    riga.cells[6].style.cursor='pointer'; 
                    riga.cells[7].style.cursor='pointer'; 
                    riga.cells[8].style.cursor='pointer';   
                    if(pair[9]!='0')
                    {
                    riga.cells[4].style.width='30px';
                    }
                    if(pair[15]!='0')
                    {
                    riga.cells[5].style.width='30px';
                    }  
                    riga.cells[3].style.textAlign='right';                  
                    riga.cells[4].style.textAlign='left';
                    riga.cells[5].style.textAlign='left';
                    riga.cells[6].style.textAlign='center';   
                    riga.cells[7].style.textAlign='center';
                    riga.cells[8].style.textAlign='center';  
                    /*riga.cells[6].style.textAlign='center'; */

                    }
                    else
                    {
                        if(pair[4]!='0')
                        {
                        var riga=table.insertRow(table.rows.length); 
                        riga.className = "even";
                        riga.insertCell(0).appendChild(document.createTextNode('Nessuna corrispondenza'));
                        riga.cells[0].colSpan='9';  
                        riga.cells[0].style.textAlign='center';        
                        }
                        else
                        {
                            if(pair[8]!='')
                            {                            
                            var riga=table.insertRow(table.rows.length); 
                            riga.className = "even";
                            linklim = document.createElement("div");
                            linklim.setAttribute('id','linkOltre');
                            if(pair[12]!='1')
                            {  
                                var te;
                                if(pair[5]<20)
                                te=''
                                else
                                te='<center><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\'0,999999\');ordiniNoL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');">Clicca qui per vedere tutti i '+pair[5]+' risultati</b></center>';
                                if(pair[11]=='1') 
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[10]+','+pair[9]+'\');ordiniL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');" style=\"float:left;\"><- Precedenti</b><br />';  
                                else                            
                                if(pair[8]!='20')
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[10]+','+pair[9]+'\');ordiniL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');" style=\"float:left;\"><- Precedenti</b><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[8]+','+pair[9]+'\');ordiniL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');"  style=\"float:right;\">Prossimi -></b><br />';
                                else
                                if(pair[11]!='2')  
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[8]+','+pair[9]+'\');ordiniL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');"style=\"float:right;\">Prossimi -></b><br />';
                                
                                
                                linklim.style.cursor='pointer';  
                                
                                riga.insertCell(0).appendChild(linklim);
                                riga.cells[0].colSpan='9';  
                            }
                            else
                            {
                                var te;
                                if(pair[5]<20)
                                te=''
                                else
                                te='<center><b onclick="attesa();loadTable2l(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\'0,999999\');ordiniNoL(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\');">Clicca qui per vedere tutti i '+pair[5]+' risultati</b></center>';
                                                                
                                if(pair[11]=='1') 
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTableOrd(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[13]+'\',\''+pair[14]+'\',\''+pair[10]+','+pair[9]+'\');" style=\"float:left;\"><- Precedenti</b><br />';  
                                else                            
                                if(pair[8]!='20')
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTableOrd(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[13]+'\',\''+pair[14]+'\',\''+pair[10]+','+pair[9]+'\');" style=\"float:left;\"><- Precedenti</b><b onclick="attesa();loadTableOrd(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[13]+'\',\''+pair[14]+'\',\''+pair[8]+','+pair[9]+'\');"  style=\"float:right;\">Prossimi -></b><br />';
                                else
                                if(pair[11]!='2')  
                                linklim.innerHTML=te+'<br /><b onclick="attesa();loadTableOrd(\'tabella1\',\''+pair[6]+'\',\''+pair[7]+'\',\''+pair[13]+'\',\''+pair[14]+'\',\''+pair[8]+','+pair[9]+'\');"style=\"float:right;\">Prossimi -></b><br />';
                                
                                
                                linklim.style.cursor='pointer';  
                                
                                riga.insertCell(0).appendChild(linklim);
                                riga.cells[0].colSpan='9';                                   
                            }
                            /*riga.cells[0].style.textAlign='center'; */    
                            }
                        }
                    } 

                }

            }
        } else {
            //alert(xmlHttp.responseText);
        }
    }
}

function getXmlHttpObject()
{
  var xmlHttp=null;
  try
    {
    // Firefox, Opera 8.0+, Safari
    xmlHttp=new XMLHttpRequest();
    }
  catch (e)
    {
    // Internet Explorer
    try
      {
      xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
      }
    catch (e)
      {
      xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
      }
    }
  return xmlHttp;
}