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

// V:\1.1.007\js\struttura.js

var structStore;var comuni;function initStruct(callback){showLoading('Inizializzazione struttura',IMG_STRUTTURA);structStore=new Ext.ux.Namirial.data.StructureStore({id:GDATABASE+'_struttura',dbname:GDATABASE,url:STRUCTURL,gearsConn:conn,structTable:'struttura'});structStore.on('initexception',function(e,t){log.error("struttura.js structStore.oninitexception")})
structStore.on('initialize',function(o){storeFrazioni=new Ext.ux.Namirial.data.ScriptTagStore({url:PAGEDATAURL,root:'rows',totalProperty:'totalRows',selectFrom:'Frazioni',remoteSort:true,id:'storeFrazioni',fields:structStore.getFields('Frazioni'),sortInfo:{field:'FRAZIONE',direction:'ASC'},baseParams:{limit:12,key:'keyId'},pageSize:12});if(session.isOnline){sysconn.createTable({name:NUOVE_DICHIARAZIONI,key:'CFISC',fields:[{name:'CFISC',type:'string',primaryKey:true},{name:'data',type:'date'}]});sysconn.createTable({name:E37_3_TAB,key:'keyId',fields:[{name:'keyId',type:'int',primaryKey:true},{name:'POTENZA',type:'text'},{name:'ACQUISTO',type:'int'},{name:'INSTALLAZIONE',type:'int'}]});sysconn.createTable({name:E37_4_TAB,key:'keyId',fields:[{name:'keyId',type:'int',primaryKey:true},{name:'POTENZA',type:'text'},{name:'ACQUISTO',type:'int'},{name:'INSTALLAZIONE',type:'int'}]});getE37_3Combo();function caricaEsenzioniQf(callbackfunction){var check=conn.query('SELECT * FROM ESENZIONI_QF');if(check.totalRows==0){var gearsFillerQE=new Ext.ux.Namirial.data.GearsFiller({gearsConn:conn,url:GEARDATAURL});gearsFillerQE.on('loadsingle',function(){hideLoading();if(callbackfunction){callbackfunction();}},this)
gearsFillerQE.loadSingle({table:'ESENZIONI_QF',fields:structStore.getFields('ESENZIONI_QF')})}
else{hideLoading();if(callback){callback();}}}
var check=conn.query('SELECT * FROM QE_DOC');if(check.totalRows==0){var gearsFillerQE=new Ext.ux.Namirial.data.GearsFiller({gearsConn:conn,url:GEARDATAURL});gearsFillerQE.on('loadsingle',function(){var add;add=generateQuery(LOCAL,QE_DOC_TAB,E17_DOC,INSERT);conn.exec(add);for(var i=0,len=E25_DOC.length;i<len;i++){add=generateQuery(LOCAL,QE_DOC_TAB,E25_DOC[i],INSERT);conn.exec(add);}
caricaEsenzioniQf(callback);},this)
gearsFillerQE.loadSingle({table:"QE_DOC",filter:"RIGO <> 'E17'",fields:structStore.getFields('QE_DOC')})}
else{var add;conn.exec("DELETE FROM QE_DOC WHERE RIGO = 'E17' OR RIGO = 'E25'");add=generateQuery(LOCAL,QE_DOC_TAB,E17_DOC,INSERT);conn.exec(add);for(var i=0,len=E25_DOC.length;i<len;i++){add=generateQuery(LOCAL,QE_DOC_TAB,E25_DOC[i],INSERT);conn.exec(add);}
hideLoading();if(callback){callback();}}}
isServerAvailable()})
structStore.init(RESET);if(!session.isOnline)
hideLoading();if(EMPTYTABLES)
structStore.emptyTables();}
function createStore(tab,cod,pref){var store=new Ext.ux.Namirial.data.GearsStore({gearsConn:conn,dbname:GDATABASE,selectFrom:tab,tableId:'keyId',id:cod+'_store',fields:structStore.getFields(tab,pref),cfisc:cod});return store;}
function getE37_3Combo(){var rec=sysconn.query('SELECT * FROM '+E37_3_TAB);if(!rec||rec.totalRows==0){Ext.Ajax.request({url:FIELDSURL,params:{field:'E37_3_TAB',output:'ARRAY',db:session.userDb},scriptTag:true,success:function(response){var responseObj=Ext.decode(response.responseText);var fields=unescape(responseObj.fields);var records=responseObj.rows
var sql=[];for(var j=0,len=responseObj.totalRows;j<len;j++){var values='';var rec=records[j];for(var k=0,m=rec.length;k<m;k++){values+='"'+unescape(rec[k])+'",';}
values=values.slice(0,-1);var query="INSERT INTO "+E37_3_TAB+" ("+fields+") VALUES ("+values+")";sql.push(query);}
sysconn.transaction(sql);getE37_4Combo();},failure:function(){log.error("struttura.js getE37_3Combo");},scope:this})}
else{getE37_4Combo();}}
function getE37_4Combo(){var rec=sysconn.query('SELECT * FROM '+E37_4_TAB);if(!rec||rec.totalRows==0){Ext.Ajax.request({url:FIELDSURL,params:{field:'E37_4_TAB',output:'ARRAY',db:session.userDb},scriptTag:true,success:function(response){var responseObj=Ext.decode(response.responseText);var fields=unescape(responseObj.fields);var records=responseObj.rows
var sql=[];for(var j=0,len=responseObj.totalRows;j<len;j++){var values='';var rec=records[j];for(var k=0,m=rec.length;k<m;k++){values+='"'+unescape(rec[k])+'",';}
values=values.slice(0,-1);var query="INSERT INTO "+E37_4_TAB+" ("+fields+") VALUES ("+values+")";sql.push(query);}
sysconn.transaction(sql);getAssiste();},failure:function(){log.error("struttura.js getE37_4Combo");},scope:this})}
else{getAssiste();}}
function getAssiste(){var rec=conn.query("SELECT * FROM "+ASSISTE_TAB+" WHERE CFISC = '"+session.caf+"'");if(!rec||rec.totalRows==0){var gearsFillerAssiste=new Ext.ux.Namirial.data.GearsFiller({gearsConn:conn,url:GEARDATAURL});gearsFillerAssiste.loadSingle({table:'ASSISTE',filter:"CFISC = '"+session.caf+"'",fields:structStore.getFields('ASSISTE')})}}