/*
 * JSMin
 * Javascript Compressor
 * http://www.crockford.com/
 * http://www.smallsharptools.com/Projects/Packer/
*/

// V:\1.1.007\js\query.js

GEARS_DEL_ALL="DELETE FROM ?";GEARS_REPLACE="REPLACE INTO ? (?) VALUES (?)";GEARS_SELECT="SELECT ? FROM ? WHERE ?";SEL_UTENTE_LOGIN="SELECT * FROM UTENTI WHERE UTENTE = '?' AND PASSWORD = '?'";SEL_UTENTE_LOCAL="SELECT UTENTE FROM UTENTI WHERE UTENTE = '?' ORDER BY LASTLOGIN";SEL_UTENTE_CONF="SELECT * FROM UTENTI WHERE UTENTE = '?'";INS_UTENTE_LOCAL="INSERT INTO UTENTI (UTENTE,PASSWORD,DB,CAF,CONFIG,LASTLOGIN,ADMIN,COMPUTER) VALUES('?','?','?','?','?','?','?','?')";DEL_UTENTI_LOCAL="DELETE FROM UTENTI";UPD_CONF_UTENTE="UPDATE UTENTI SET CONFIG='?' WHERE UTENTE='?'";INS_UTENTE_SERIALID="UPDATE UTENTI SET SERIALID='?' WHERE UTENTE = '?'";UPD_UTENTE="UPDATE UTENTI SET CAF='?',LASTLOGIN='?',COMPUTER='?',ADMIN='?', PASSWORD='?' WHERE UTENTE = '?'";SEL_LOCAL_ANAG="SELECT * FROM ANAGRAFI WHERE CFISC = '?'";SEL_ALL_ANAG="SELECT * FROM ANAGRAFI";SEL_LOCAL_ANAG_AND_CONIUGE="SELECT A.CFISC AS CFISC,A.COGNOME AS COGNOME,A.NOME AS NOME,A.CCFISC,B.CFISC AS CFISC_CON,B.COGNOME AS COGNOME_CON,B.NOME AS NOME_CON,B.CONIUGE FROM ANAGRAFI AS A LEFT OUTER JOIN ANAGRAFI AS B ON A.CCFISC = B.CFISC WHERE A.CFISC = '?'";SEL_NUOVA_ANAG="SELECT * FROM NuoveDichiarazioni WHERE CFISC = '?'";SEL_LOCAL_TUTORI="SELECT * FROM TUTORI WHERE CFISC = '?'";GEARS_DEL="DELETE FROM ? WHERE CFISC = '?'";CHECK_ANAG_NUOVA="SELECT CFISC FROM ANAGRAFI WHERE [CFISC] = '?'";UPD_CAF_ANAG="UPDATE ANAGRAFI SET CAF='?' WHERE CFISC ='?'";SET_A_VALIDATO="UPDATE ANAGRAFI SET A_VALIDATO='' WHERE CFISC ='?'";SET_GRUPPO="UPDATE ANAGRAFI SET INTMATR='?' WHERE CFISC='?'";INS_LOCK="INSERT INTO _sys_LOCKS (CFISC,UTENTE,SERIALID,COMPUTER,BROWSER,DATA) VALUES ('?','?','?','?','?','?')";CONFIRM_LOCK="UPDATE _sys_LOCKS SET DATA = '?' WHERE CFISC = '?' AND UTENTE = '?'";RECOVER_LOCK="UPDATE _sys_LOCKS SET DATA = '?', SERIALID='?', COMPUTER='?', BROWSER='?' WHERE CFISC = '?' AND UTENTE = '?'";DEL_LOCK="DELETE _sys_LOCKS WHERE CFISC='?'"
CHECK_LOCK="SELECT * FROM _sys_LOCKS WHERE CFISC = '?'"
INS_LOCK_SOSTITUTI="INSERT INTO _sys_LOCKS_SOSTITUTI (S4, SUBCODICE, UTENTE, DATA) VALUES ('?','?','?','?')";DEL_LOCK_SOSTITUTI="DELETE _sys_LOCKS_SOSTITUTI WHERE S4='?' AND SUBCODICE='?' AND UTENTE='?'";CHECK_LOCK_SOSTITUTI="SELECT * FROM _sys_LOCKS_SOSTITUTI WHERE S4='?' AND SUBCODICE='?'";CHECK_LOCK_SID="SELECT * FROM _sys_LOCKS WHERE CFISC='?' AND SERIALID='?'";CHECK_CFISC="SELECT A.*, B.CFISC FROM _sys_LOCKS A FULL OUTER JOIN ANAGRAFI B ON A.CFISC = B.CFISC WHERE (A.CFISC = '?') OR (B.CFISC = '?')";INS_GRUPPO="INSERT INTO _sys_GROUPS (UTENTE,GRUPPO,COLLABORATORE) VALUES ('?','?','?')";DEL_COLLABORATORE="DELETE FROM _sys_GROUPS WHERE UTENTE ='?' AND GRUPPO='?' AND COLLABORATORE='?'";DEL_GRUPPO="DELETE FROM _sys_GROUPS WHERE (UTENTE ='?' AND GRUPPO='?') OR (GRUPPO='?' AND COLLABORATORE='?')";SEL_RIS730_3="SELECT * FROM RIS730_3 where CFISC='?'";SEL_RIS730_3I="SELECT * FROM RIS730_3I where CFISC='?'";SEL_ANAGRAFI="SELECT * FROM ANAGRAFI where CFISC='?'";SEL_ANAGRAFI_BY_CFISC="SELECT COGNOME,NOME,CFISC,DATA_7302,INTEGRATIVA,RIC_INFO,TIPO_INTEG from ANAGRAFI where CFISC='?'";SEL_DOCUMENT="SELECT * FROM DOCUMENT WHERE CFISC='?' ORDER BY RIGO,DD1";SEL_DTNAS="SELECT DNASCITA FROM ANAGRAFI where CFISC='?'";DEL_FAMILIARE="DELETE FROM FAMILIA WHERE keyId ='?' ";SEL_FAMILIA="SELECT * FROM FAMILIA WHERE CFISC='?' ";UPD_FAMILIARE_ESTERO="UPDATE FAMILIA SET (DNASCITA='?',SS='?',CNASCITA='?',PNASCITA='?',CCAT='?') WHERE CFISC='?'"
INS_CONIUGE_EMPTY="INSERT INTO FAMILIA (CFISC,F1,F2,F3,F3_3ANNI,CONIUGE,TIPO,ESTERO,STUDENTE,CANONE,DISABILE,F4,F4_DEAD,CNASCITA,PNASCITA,CCAT,SS) VALUES ('?','?','C','','','1','1/1','0','1','0','','','','','','','')"
DEL_CONIUGE="DELETE FROM FAMILIA WHERE CFISC='?' AND F2='C'";UPD_CONIUGE_INFO="UPDATE FAMILIA SET CANONE='?' WHERE CFISC='?' AND F2='C'";SEL_CONIUGE_INFO="SELECT * FROM FAMILIA WHERE CFISC='?' AND F2='C'";COUNT_ESTERO="SELECT * FROM FAMILIA WHERE CFISC='?' AND F2<>'C' AND ESTERO='1'";UPD_RIGO="UPDATE FAMILIA SET TIPO='?' WHERE keyId=?";UPD_STUDENTE="UPDATE FAMILIA SET STUDENTE=? WHERE keyId=?";UPD_PERC_FIGLI="UPDATE FAMILIA SET CANONE_PERC='?' WHERE F2='C' AND CFISC='?'";SEL_FIGLI="SELECT * FROM FAMILIA WHERE F2='C' AND CFISC='?'";DEL_TERRENO="DELETE FROM QA WHERE keyId ='?' ";UPD_CONT_TERRENO="UPDATE QA SET A10='?' WHERE keyId='?'"
DEL_SOSTITUTI="DELETE FROM SOSIMPW WHERE S4='?' AND SUBCODICE ?"
CHECK_SOSTITUTO_USATO="SELECT SOSTIMP, SUBCODICE FROM ANAGRAFI WHERE SOSTIMP = '?' AND SUBCODICE ?"
SEL_SOSTITUTI_SUBCOD="SELECT SUBCODICE FROM SOSIMPW WHERE [S4] = '?'"
SEL_SOSTITUTO="SELECT * FROM SOSIMPW WHERE [S4] = '?' AND [SUBCODICE] = '?'"
DEL_TUTORI="DELETE TUTORI WHERE CFISC='?'"
SEL_TUTORI="SELECT * FROM TUTORI"
DEL_FABBRICATO="DELETE FROM QB WHERE keyId ='?' ";SEL_FABBRICATO="SELECT * FROM QB WHERE DENSCOD ='?'";UPD_CONT_FABBRICATO="UPDATE QB SET B29='?' WHERE keyId='?'";SEL_ICI="SELECT B29,ICI_DOVUTA,ICI_TOTALE,ID FROM QB WHERE CFISC = '?' ORDER BY CFISC,ID DESC";UPD_ICI_FABBR="UPDATE QB SET ICI_TOTALE='?' WHERE ID='?'";SEL_TABLES="SELECT * FROM ? WHERE CFISC='?'";SEL_QBDENS="SELECT * FROM QBDENS WHERE CFISC='?' AND DENSCOD='?'";SEL_COUNT_QBDENS="SELECT * FROM QBDENS WHERE CFISC='?' ORDER BY NORDINE DESC";DEL_QBDENS="DELETE FROM QBDENS WHERE CFISC='?' AND DENSCOD='?'";INS_QE="INSERT INTO QE (CFISC) VALUES ('?')";UPD_QE="UPDATE QE SET ? = '?' WHERE CFISC = '?'"
UPD_QE16="UPDATE QE16 SET ? = '?' WHERE CFISC = '?'"
UPD_QEIII="UPDATE QEIII SET ? = '?' WHERE CFISC = '?'"
DEL_QEIII="DELETE FROM QEIII WHERE E_ID = '?'";DEL_QEV="DELETE FROM QEV WHERE E_ID = '?'";UPD_QEV="UPDATE QEIII SET ? = '?' WHERE CFISC = '?'"
DEL_QE_DETT="DELETE FROM QEDETT WHERE DETTAGLIO = '?' AND CFISC = '?'"
DEL_QE_DETT_ID="DELETE FROM QEDETT WHERE DETTAGLIO = '?' AND CFISC = '?' AND ID = '?'"
DEL_QE_DETT_QEV="DELETE FROM QEDETT WHERE DETTAGLIO LIKE '?' AND CFISC = '?' AND ID = '?'"
SEL_QE="SELECT * FROM QE WHERE CFISC ='?' ";SEL_QE_1="SELECT E7_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_2="SELECT E7_PERC, E7_CONTRIBUTI, E7_STIPULA FROM QE WHERE CFISC ='?' ";SEL_QE_3="SELECT E8_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_4="SELECT E8_PERC, E8_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_5="SELECT E9_PERC, E9_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_6="SELECT E17_PERC FROM QE WHERE CFISC ='?' ";SEL_QE_7="SELECT E10_PERC, E10_CONTRIBUTI, E10_STIPULA FROM QE WHERE CFISC ='?' ";SEL_QE_8="SELECT E11_PERC, E11_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_9="SELECT E27_1_CONTRIBUTI FROM QE WHERE CFISC ='?' ";SEL_QE_14="SELECT * FROM QEDETT WHERE CFISC ='?' AND DETTAGLIO='E14'";DEL_QEIII_DETT="DELETE FROM QEDETT WHERE DETTAGLIO = '?' AND CFISC = '?' AND ID = '?'"
SEL_QE_DOC="SELECT * FROM QE_DOC WHERE RIGO = '?' AND CODICE = '?'"
DEL_QC1="DELETE FROM QC1 WHERE keyId ='?' ";DEL_QC5="DELETE FROM QC5 WHERE keyId ='?' ";DEL_QC2="DELETE FROM QC2 WHERE keyId ='?' ";INS_QC3="INSERT INTO QC3 (CFISC) VALUES ('?')";UPD_QC3="UPDATE QC3 SET C9='?',C10='?',C11='?',C12='?',C13='?' WHERE CFISC='?'";SEL_QC1="SELECT C1_2 FROM QC1 WHERE CFISC ='?' ";SEL_QC2="SELECT C2_2 FROM QC2 WHERE CFISC ='?' ";SEL_QC1_TIPO3="SELECT C1_2 FROM QC1 WHERE CFISC ='?' AND C1_1='3'";SEL_QC3="SELECT * FROM QC3 WHERE CFISC ='?'";SEL_QC5="SELECT * FROM QC5 WHERE CFISC ='?'";UPD_QC3_C5="UPDATE QC3 SET C5_REDDITI_AP='?' WHERE CFISC='?'";INS_QC3_C5="INSERT INTO QC3 (C5_REDDITI_AP,CFISC) VALUES ('?','?')";SEL_QC1_SUM="SELECT SUM([C1_3]) AS F2_5, SUM([C1_5]) AS F2_6 FROM QC1 WHERE [C1_1] = '3' AND CFISC = '?'";DEL_QDD1="DELETE FROM QD1 WHERE keyId ='?' ";DEL_QDD2="DELETE FROM QD2 WHERE keyId ='?' ";DEL_QDD3="DELETE FROM QD3 WHERE keyId ='?' ";DEL_QDD4="DELETE FROM QD4 WHERE keyId ='?' ";DEL_QDD5="DELETE FROM QD5 WHERE keyId ='?' ";DEL_QDD6="DELETE FROM QD6 WHERE keyId ='?' ";DEL_QDD7="DELETE FROM QD7 WHERE keyId ='?' ";SEL_QD1="SELECT D1_UTILI FROM QD1 WHERE CFISC ='?' ";SEL_QD2="SELECT D2_2 FROM QD2 WHERE CFISC ='?' ";SEL_QD3="SELECT D3_2 FROM QD3 WHERE CFISC ='?' ";SEL_QD4="SELECT D4_2 FROM QD4 WHERE CFISC ='?' ";SEL_QD5="SELECT D5_2 FROM QD5 WHERE CFISC ='?' ";SEL_QD4_TIPO7="SELECT D4_2 FROM QD4 WHERE CFISC ='?' AND D4_1 = '7'";SEL_QD1_4="SELECT D1_4 FROM QD1 WHERE CFISC ='?' ";SEL_QD2_4="SELECT D2_4 FROM QD2 WHERE CFISC ='?' ";SEL_QD3_4="SELECT D3_4 FROM QD3 WHERE CFISC ='?' ";SEL_QD4_4="SELECT D4_4 FROM QD4 WHERE CFISC ='?' ";SEL_QD5_4="SELECT D5_4 FROM QD5 WHERE CFISC ='?' ";SEL_QF="SELECT * FROM QF WHERE CFISC ='?' ";INS_QF="INSERT INTO QF (F2_5,F2_6,CFISC) VALUES ('?','?','?')";UPD_QF="UPDATE QF SET F2_5='?',F2_6='?' WHERE CFISC='?'";INS_VERSION="INSERT INTO VERSION ('VERSION','AGGIORNATO') VALUES ('?',?)";UPD_VERSION="UPDATE VERSION SET AGGIORNATO=? WHERE keyId=?";SEL_VERSION="SELECT * FROM VERSION";sp_ANAGRAFI_PERMISSIONS="exec sp_ANAGRAFI_PERMISSIONS '?','?','?','?'";INS_CONF="INSERT INTO _SYS_CONF (LINGUA,HELP,UTENTE) VALUES ('?','?','?')";CHECK_CONF="SELECT * FROM _SYS_CONF WHERE UTENTE='?'";UPD_CONF="UPDATE _SYS_CONF SET LINGUA='?',HELP='?' WHERE UTENTE='?'";WHERE_UTENTE="WHERE UTENTE = '?' OR COLLABORATORE = '?'";WHERE_UTENTE_NOT="WHERE UTENTE <> '?'";WHERE_GRUPPO="WHERE GRUPPO = '?'";WHERE_CODOP="WHERE UTENTE = '?'";DEL_ANAG_NUOVA="DELETE FROM NuoveDichiarazioni WHERE CFISC='?'";INS_TEMP_ANAG="INSERT INTO NuoveDichiarazioni (CFISC, data) VALUES ('?', '?')"
DEL_QG4="DELETE FROM QG4 WHERE keyId ='?' ";DEL_QG="DELETE FROM QG WHERE keyId ='?' ";INS_QG="INSERT INTO QG (CFISC) VALUES ('?')";INS_QR="INSERT INTO QR (CFISC) VALUES ('?')";DEL_SYNC="DELETE FROM ? WHERE [CFISC] = '?' AND [tabella] = '?'";INS_MSG="INSERT INTO MESSAGGI (UTENTE,MESSAGGIO,VOTO) VALUES('?','?',?)";INS_CALCE10="INSERT INTO CalcE10 (CFISC) VALUES ('?')";function getQuery(query,params,apici){apici=apici||false;try{if(params!=null){for(var i=0;i<params.length;i++){var valore=(apici)?escapeApici(params[i]):params[i]
query=query.replace('?',valore);}}
return query;}catch(e){log.error("query#1 -> ",e);}}
function generateQueryFromForm(tab,form,type,where,esclusioni,tForm){try{var lstEsclusioni=(esclusioni==undefined)?new Array():esclusioni;var fields=(tForm=='basicform')?form.items.items:form.getForm().items.items;if(!Ext.isEmpty(type)){switch(type.toUpperCase()){case'UPDATE':case'UPD':var query="UPDATE "+tab+" SET ";for(var i=0;i<fields.length;i++){if(lstEsclusioni.indexOf(fields[i].getName())==-1&&fields[i].escludi==false){var endStr=((i<fields.length-1)?',':' ');switch(fields[i].getXType()){case'textfield':case'namirial_textfield':case'namirial_numberfield':case'namirial_checkbox':query+=fields[i].getName()+"="+"'"+escapeApici(fields[i].getValue())+"'"+endStr;break;case'combo':case'namirial_combo':var comboValue=fields[i].getValue();query+=fields[i].getName()+"="+"'"+escapeApici(comboValue)+"'"+endStr;break;case'checkbox':var valueCheck=(fields[i].getValue())?1:0;query+=fields[i].getName()+"="+valueCheck+endStr;break;case'namirial_datefield':case'datefield':var valueDate=fields[i].value.replace(/[\/]/g,"");query+=fields[i].getName()+"="+"'"+escapeApici(valueDate)+"'"+endStr;break;case'numberfield':var valueNum=fields[i].value==""?0:fields[i].value;query+=fields[i].getName()+"="+valueNum+endStr;break;}}}
query+="WHERE "+where;log.debug('generateQueryFromForm -> SQL : '+query);return query;break;case'INSERT':case'INS':var campi='(';var valori='(';for(var i=0;i<fields.length;i++){if(lstEsclusioni.indexOf(fields[i].getName())==-1&&fields[i].escludi==false){var endStr=((i<fields.length-1)?',':' ) ');switch(fields[i].getXType()){case'textfield':case'namirial_textfield':case'namirial_numberfield':case'namirial_checkbox':campi+=fields[i].getName()+endStr
valori+="'"+escapeApici(fields[i].getValue())+"'"+endStr
break;case'combo':case'namirial_combo':var comboValue=fields[i].getValue();campi+=fields[i].getName()+endStr
valori+="'"+escapeApici(comboValue)+"'"+endStr
break;case'checkbox':var valueCheck=(fields[i].getValue())?1:0;campi+=fields[i].getName()+endStr
valori+=valueCheck+endStr
break;case'namirial_datefield':case'datefield':var valueDate=fields[i].value.replace(/[\/]/g,"");campi+=fields[i].getName()+endStr
valori+="'"+escapeApici(valueDate)+"'"+endStr
break;case'numberfield':var valueNum=fields[i].value==""?0:fields[i].value;campi+=fields[i].getName()+endStr
valori+=valueNum+endStr
break;}}}
var query="INSERT INTO "+tab+" "+campi+" VALUES "+valori;log.debug('generateQueryFromForm -> SQL : '+query);return query;break;}}}
catch(e){log.error("query#2 -> ",e);}}
function getValuesFromForm(form,all,esclusioni,tab,sqltype,where){all=Ext.isEmpty(all)?true:all;var lstEsclusioni=(esclusioni==undefined)?new Array():esclusioni;var values='{';var fields=form.items.items;var data='';for(var i=0,len=fields.length;i<len;i++){if(all||!fields[i].disabled){var name=fields[i].name;if(lstEsclusioni.indexOf(name)==-1&&!fields[i].escludi){var type=fields[i].getXType();var value=fields[i].getValue();switch(type){case'numberfield':case'namirial_numberfield':if(Ext.isEmpty(value)&&value!==0)value='';data+=encodeURIComponent(name)+'='+encodeURIComponent(fields[i].getRawValue())+'&';break
case'datefield':data+=encodeURIComponent(name)+'='+encodeURIComponent((Ext.isEmpty(value))?'':value.format('dmY'))+'&';break
case'checkbox':data+=encodeURIComponent(name)+'='+encodeURIComponent((value)?'1':'0')+'&';break
default:if(value==undefined)value='';data+=encodeURIComponent(name)+'='+encodeURIComponent(value)+'&';break;}}}}
data=data.substr(0,data.length-1);var values=Ext.urlDecode(data);if(Ext.isEmpty(tab)||Ext.isEmpty(sqltype)){return values;}else{switch(sqltype.toUpperCase()){case'UPDATE':case'UPD':return getArrayUpdateQuery(tab,values,where)
break;case'INSERT':case'INS':return getArrayInsertQuery(tab,values)
break}}}
function getArrayUpdateQuery(tab,list,where){try{var query="UPDATE "+tab+" SET ";for(var key in list){if(list.hasOwnProperty(key)){var value=checkNull(list[key]);query+=key+"="+escapeApici(value)+",";}}
query=query.substr(0,query.length-1)+' ';query+="WHERE "+where;return query;}catch(e){log.error("query#3 -> ",e);}}
function getArrayInsertQuery(tab,list){try{var fields='';var values='';for(var key in list){if(list.hasOwnProperty(key)){var value=checkNull(list[key]);fields+=key+",";values+=escapeApici(value)+",";}}
fields=fields.slice(0,-1);values=values.slice(0,-1);var query="INSERT INTO "+tab+" ("+fields+") VALUES ("+values+")";return query;}catch(e){log.error("query#4 -> ",e);}}
function queryVO(query,arrayParams){this.query=query;this.arrayParams=arrayParams;}
function getQueryArray(arrQueryVO){try{var returnQuery='';if(arrQueryVO!=null){for(var i=0;i<arrQueryVO.length;i++){for(var k=0;k<arrQueryVO[i].arrayParams.length;k++){var valore=escape(arrQueryVO[i].arrayParams[k]);arrQueryVO[i].query=arrQueryVO[i].query.replace('?',valore);}
returnQuery+=arrQueryVO[i].query+"\n";}}
log.debug('getQueryArray-> SQL: '+returnQuery);return returnQuery;}catch(e){log.error("query#5 -> ",e);}}
function generateQuery(type,tabella,campi,typeSql,where){try{switch(typeSql){case'INSERT':var fields='';var values='';for(var key in campi){var value;if(campi.hasOwnProperty(key)){var typeObj=Ext.type(campi[key]);if(typeObj=='string'){value=(type==SERVER)?checkNull(campi[key]):"'"+escapeApici(campi[key])+"'";}else{value=campi[key];}
fields+="["+key+"],";values+=value+",";}}
fields=fields.slice(0,-1);values=values.slice(0,-1);var query="INSERT INTO "+tabella+" ("+fields+") VALUES ("+values+")";return query;break;case'UPDATE':var query="UPDATE "+tabella+" SET ";for(var key in campi){if(campi.hasOwnProperty(key)){var value;var typeObj=Ext.type(campi[key]);if(typeObj=='string'){value=(type==SERVER)?checkNull(campi[key]):"'"+escapeApici(campi[key])+"'";}else{value=campi[key];}
query+="["+key+"]="+value+",";}}
query=query.substr(0,query.length-1)+' ';query+="WHERE "+where;return query;break;}}catch(e){log.error("query#6 -> ",e);}}