03/09/2025 12:04:46 - TYPE ERROR:PHP warning 03/09/2025 12:04:46 - MESSAGE:Use of undefined constant FORMAZIONE_DL8108 - assumed 'FORMAZIONE_DL8108' (this will throw an Error in a future version of PHP) 03/09/2025 12:04:46 - Error File LINE: 03/09/2025 12:04:46 - /var/www/html/dev/yii/framework/web/CWebApplication.php(359) 03/09/2025 12:04:46 - Error SOURCE CODE: 03/09/2025 12:04:46 -

347 
348             if($owner->controllerNamespace!==null)
349                 $className=$owner->controllerNamespace.'\\'.str_replace('/','\\',$controllerID).$className;
350 
351             if(is_file($classFile))
352             {
353                 if(!class_exists($className,false))
354                     require($classFile);
355                 if(class_exists($className,false) && is_subclass_of($className,'CController'))
356                 {
357                     $id[0]=strtolower($id[0]);
358                     return array(
359                         new $className($controllerID.$id,$owner===$this?null:$owner),
360                         $this->parseActionParams($route),
361                     );
362                 }
363                 return null;
364             }
365             $controllerID.=$id;
366             $basePath.=DIRECTORY_SEPARATOR.$id;
367         }
368     }
369 
370     /**
371      * Parses a path info into an action ID and GET variables.

03/09/2025 12:04:46 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => adminDl8108/ ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => MusaFormazioniDett/adminDl8108 ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 18/09/2025 14:51:19 - TYPE ERROR:ParseError 18/09/2025 14:51:19 - MESSAGE:syntax error, unexpected 'if' (T_IF) 18/09/2025 14:51:19 - Error File LINE: 18/09/2025 14:51:19 - /var/www/html/dev/musa_app/protected/controllers/MusaFormazioniRichiesteController.php(2310) 18/09/2025 14:51:19 - Error SOURCE CODE: 18/09/2025 14:51:19 -

2298         if ($model->enabled == 1) {
2299             //Cerco gli idformazione che sono assorbite dalla categoria della qualifica appena abilitata.
2300             $sql_assorbite = "SELECT id_formazione_assorbita
2301                       FROM musa_formazioni_assorbimenti
2302                       WHERE id_formazione_assorbente = :id_formazione_assorbente";
2303             
2304             $command_assorbite = Yii::app()->db->createCommand($sql_assorbite);
2305             $command_assorbite->bindValue(":id_formazione_assorbente", $model->idformazione, PDO::PARAM_INT);
2306             $lista_id_formazioni_assorbite = $command_assorbite->queryColumn();
2307             d($lista_id_formazioni_assorbite)
2308             
2309             //Se esistono categorie assorbite vengono disattivate
2310             if (!empty($lista_id_formazioni_assorbite)) {
2311                 
2312                 //Prepara i criteri per aggiornare le vecchie qualifiche dell'utente.
2313                 $condition = 'idanautente = :idanautente AND enabled = 1 AND idformazionerichiesta != :current_richiesta_id';
2314                 $params = array(
2315                     ':idanautente' => $model->idanautente,
2316                     ':current_richiesta_id' => $model->idformazionerichiesta,
2317                 );
2318                 
2319                 //Aggiungi dinamicamente alla condizione la parte IN (...) e i relativi parametri.
2320                 $in_placeholders = [];
2321                 foreach ($lista_id_formazioni_assorbite as $key => $id_formazione) {
2322                     $placeholder = ':id_formazione' . $key;

18/09/2025 14:51:19 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => adminFormRspp/ ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => musaFormazioniRichieste/adminFormRspp ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 22/09/2025 12:48:45 - TYPE ERROR:ParseError 22/09/2025 12:48:45 - MESSAGE:syntax error, unexpected 'ry' (T_STRING) 22/09/2025 12:48:45 - Error File LINE: 22/09/2025 12:48:45 - /var/www/html/dev/musa_app/protected/controllers/MusaFormazioniRichiesteController.php(983) 22/09/2025 12:48:45 - Error SOURCE CODE: 22/09/2025 12:48:45 -

971     // $criteriaCrediti = new CDbCriteria;
972     // $criteriaCrediti->join = 'JOIN musa_formazioni_richieste r ON t.idformazionerichiesta = r.idformazionerichiesta';
973     // $criteriaCrediti->addCondition('r.idanautente = :userId');
974     // $criteriaCrediti->addCondition('r.idformazione = :formationId');
975     // $criteriaCrediti->params = [
976     //     ':userId' => $model->idanautente,
977     //     ':formationId' => $model->idformazione
978     // ];
979     // $criteriaCrediti->with = ['file', 'allegato']; 
980     // $criteriaCrediti->order = 'r.datastart DESC'; // Ordina i crediti dal più recente al più vecchio
981     // $creditiDetails = MusaFormazioniRichiesteCrediti::model()->findAll($criteriaCrediti);
982     // dd($id);
983     $que ry = 'select mfr.idformazionerichiesta, mfr.idanautente, mfr.idformazione, mfr.idformazionedett, mfr.descrizione, mfa.crediti 
984 from musa_formazioni_richieste mfr join musa_formazioni_allegati mfa 
985 on mfr.idformazionerichiesta = mfa.idformazionerichiesta
986 where mfr.idformazionerichiesta = 126277 and mfa.crediti > 0;';
987 $command = Yii::app()->db->createCommand($query);
988 // $command->bindValue(':id', $id);
989     $creditiDetails= $command->query();
990     dd($creditiDetails);
991 
992 
993 
994 
995     // $criteriaRichieste = new CDbCriteria;

22/09/2025 12:48:45 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => updateDl8108/ ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => musaFormazioniRichieste/updateDl8108 ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 05/11/2025 13:03:18 - TYPE ERROR:ParseError 05/11/2025 13:03:18 - MESSAGE:syntax error, unexpected '2' (T_LNUMBER), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' 05/11/2025 13:03:18 - Error File LINE: 05/11/2025 13:03:18 - /var/www/html/dev/musa_app/protected/controllers/app/SiteAppController.php(786) 05/11/2025 13:03:18 - Error SOURCE CODE: 05/11/2025 13:03:18 -

774                       //recupero dati riga
775                       $cell = $SheetImport->getCellByColumnAndRow($mapping['first_col']+$propertycol['idx'], $row);
776 
777                       $utentestg->$namecolstg = trim($cell->getCalculatedValue());
778 
779                       // Gestione eventuali DEFAULT
780                       //20251021 - TICKET: 0010218 - AT
781                       if($utentestg->$namecolstg === null || $utentestg->$namecolstg === ''){
782                           if(isset($propertycol['defaultvalue'])){
783                             $utentestg->$namecolstg = $propertycol['defaultvalue'];
784                           }
785                       }
786                       dd($cell->2);
787 
788                       // Gestione dati di tipo DATA
789                       if ($propertycol['datatype'] == 'datetime'){
790                         if(!empty($utentestg->$namecolstg)){
791 
792                           //recupero formato date MySQL ("yyyy-mm-dd")
793                           $dateFormat = getDTFormatter('mysql','D');
794 
795                           if (is_numeric($utentestg->$namecolstg)) {
796                             //SE CELLA DATA RICONOSCIUTA COME NUMERO -> conversione da UNIXTIME a stringa in formato MySQL
797                             $utentestg->$namecolstg = date($dateFormat, PHPExcel_Shared_Date::ExcelToPHP($utentestg->$namecolstg));
798                           } else {

05/11/2025 13:03:18 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/YiiBase.php [line] => 204 [function] => import [class] => YiiBase [type] => :: [args] => Array ( [0] => application.controllers.app.SiteAppController [1] => 1 ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 332 [function] => createComponent [class] => YiiBase [type] => :: [args] => Array ( [0] => Array ( ) [1] => siteApp [2] => ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => ImportUtentiAutomatico/ ) ) [3] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => siteApp/ImportUtentiAutomatico ) ) [4] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 05/11/2025 13:12:22 - TYPE ERROR:ParseError 05/11/2025 13:12:22 - MESSAGE:syntax error, unexpected ')' 05/11/2025 13:12:22 - Error File LINE: 05/11/2025 13:12:22 - /var/www/html/dev/musa_app/protected/controllers/app/SiteAppController.php(786) 05/11/2025 13:12:22 - Error SOURCE CODE: 05/11/2025 13:12:22 -

774                       //recupero dati riga
775                       $cell = $SheetImport->getCellByColumnAndRow($mapping['first_col']+$propertycol['idx'], $row);
776 
777                       $utentestg->$namecolstg = trim($cell->getCalculatedValue());
778 
779                       // Gestione eventuali DEFAULT
780                       //20251021 - TICKET: 0010218 - AT
781                       if($utentestg->$namecolstg === null || $utentestg->$namecolstg === ''){
782                           if(isset($propertycol['defaultvalue'])){
783                             $utentestg->$namecolstg = $propertycol['defaultvalue'];
784                           }
785                       }
786 dd($mapping['attributes']); if ($namecolstg == )
787                       // Gestione dati di tipo DATA
788                       if ($propertycol['datatype'] == 'datetime'){
789                         if(!empty($utentestg->$namecolstg)){
790 
791                           //recupero formato date MySQL ("yyyy-mm-dd")
792                           $dateFormat = getDTFormatter('mysql','D');
793 
794                           if (is_numeric($utentestg->$namecolstg)) {
795                             //SE CELLA DATA RICONOSCIUTA COME NUMERO -> conversione da UNIXTIME a stringa in formato MySQL
796                             $utentestg->$namecolstg = date($dateFormat, PHPExcel_Shared_Date::ExcelToPHP($utentestg->$namecolstg));
797                           } else {
798                             //SE CELLA DATA RICONOSCIUTA COME STRINGA -> formattazione stringa da formato in lingia a formato MySQL

05/11/2025 13:12:22 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/YiiBase.php [line] => 204 [function] => import [class] => YiiBase [type] => :: [args] => Array ( [0] => application.controllers.app.SiteAppController [1] => 1 ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 332 [function] => createComponent [class] => YiiBase [type] => :: [args] => Array ( [0] => Array ( ) [1] => siteApp [2] => ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => ImportUtentiAutomatico/ ) ) [3] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => siteApp/ImportUtentiAutomatico ) ) [4] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 05/11/2025 13:13:23 - TYPE ERROR:ParseError 05/11/2025 13:13:23 - MESSAGE:syntax error, unexpected 'if' (T_IF) 05/11/2025 13:13:23 - Error File LINE: 05/11/2025 13:13:23 - /var/www/html/dev/musa_app/protected/controllers/app/SiteAppController.php(786) 05/11/2025 13:13:23 - Error SOURCE CODE: 05/11/2025 13:13:23 -

774                       //recupero dati riga
775                       $cell = $SheetImport->getCellByColumnAndRow($mapping['first_col']+$propertycol['idx'], $row);
776 
777                       $utentestg->$namecolstg = trim($cell->getCalculatedValue());
778 
779                       // Gestione eventuali DEFAULT
780                       //20251021 - TICKET: 0010218 - AT
781                       if($utentestg->$namecolstg === null || $utentestg->$namecolstg === ''){
782                           if(isset($propertycol['defaultvalue'])){
783                             $utentestg->$namecolstg = $propertycol['defaultvalue'];
784                           }
785                       }
786 dd(if($mapping['attributes'] == 'data_inizio') {$cell->getvalue();}); 
787                       // Gestione dati di tipo DATA
788                       if ($propertycol['datatype'] == 'datetime'){
789                         if(!empty($utentestg->$namecolstg)){
790 
791                           //recupero formato date MySQL ("yyyy-mm-dd")
792                           $dateFormat = getDTFormatter('mysql','D');
793 
794                           if (is_numeric($utentestg->$namecolstg)) {
795                             //SE CELLA DATA RICONOSCIUTA COME NUMERO -> conversione da UNIXTIME a stringa in formato MySQL
796                             $utentestg->$namecolstg = date($dateFormat, PHPExcel_Shared_Date::ExcelToPHP($utentestg->$namecolstg));
797                           } else {
798                             //SE CELLA DATA RICONOSCIUTA COME STRINGA -> formattazione stringa da formato in lingia a formato MySQL

05/11/2025 13:13:23 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/YiiBase.php [line] => 204 [function] => import [class] => YiiBase [type] => :: [args] => Array ( [0] => application.controllers.app.SiteAppController [1] => 1 ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 332 [function] => createComponent [class] => YiiBase [type] => :: [args] => Array ( [0] => Array ( ) [1] => siteApp [2] => ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => ImportUtentiAutomatico/ ) ) [3] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => siteApp/ImportUtentiAutomatico ) ) [4] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 11/11/2025 11:03:50 - TYPE ERROR:ParseError 11/11/2025 11:03:50 - MESSAGE:syntax error, unexpected '}' 11/11/2025 11:03:50 - Error File LINE: 11/11/2025 11:03:50 - /var/www/html/dev/musa_app/protected/controllers/FrmAnaUtentiController.php(1825) 11/11/2025 11:03:50 - Error SOURCE CODE: 11/11/2025 11:03:50 -

1813     
1814     //inizializzazioni
1815     $utente = new FrmAnaUtenti;
1816     
1817     //recupero parametri GET/POST
1818     $frmanautentiparams = Yii::app()->request->getParam('FrmAnaUtenti');
1819     
1820     //20190218 - TICKET:0003512
1821     //aggiornamento stato Utente (Cruge/frm_ana_utenti)
1822     $utente->setstateutente($frmanautentiparams['idanautente'],$frmanautentiparams['state']);
1823     $utente->DeleteContractEndDate($frmanautentiparams['idanautente']);
1824     $FrmAnaUtenti['nologin']==1
1825   }
1826   
1827   /**
1828    * Funzione eseguita all'onblur del campo C.F. per eseguirne la validazione
1829    * 
1830    * @param object $txt
1831    * 
1832    * Modifiche:
1833    * 20180725 - TICKET:0002911 - antonio.mattis@sophiainformatica.it
1834    * Creazione
1835    */
1836   public function actionvalidacf(){
1837

11/11/2025 11:03:50 - Stack Trace:Array ( [0] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 276 [function] => createController [class] => CWebApplication [type] => -> [args] => Array ( [0] => updateCensimento/ ) ) [1] => Array ( [file] => /var/www/html/dev/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> [args] => Array ( [0] => FrmAnaUtenti/updateCensimento ) ) [2] => Array ( [file] => /var/www/html/dev/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /var/www/html/dev/musa_app/index.php [line] => 46 [function] => run [class] => CApplication [type] => -> [args] => Array ( ) ) ) 20/11/2025 12:25:54 - TYPE ERROR:CDbException 20/11/2025 12:25:54 - MESSAGE:CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] Connection refused 20/11/2025 12:25:54 - Error File LINE: 20/11/2025 12:25:54 - /var/www/html/dev/musa_app/protected/extensions/costanti.php(49) 20/11/2025 12:25:54 - Error SOURCE CODE: 20/11/2025 12:25:54 -

37  * errore nel caricamento costanti corretto
38  *
39  * 20141007 - TICKET:0000155 - giacomo.gallo@sohpiainformatica.it
40  * aggiunta porzione di codice che definisce FRM_IDSOCIETA e FRM_IDSTABILIMENTO per 
41  * l'utente loggato 
42  */
43 
44 //20180412 - TICKET:0002605
45 //recupero caratteri da sostituire
46 $charactersToReplace = getArrayCharactersToReplace();
47 
48 $query_costanti = 'select nome,label,value from frm_sys_costanti UNION select nome,label,value from frm_sys_costanti_applicazione';
49 $res_costanti = Yii::app()->db->createCommand($query_costanti)->queryAll();
50 foreach ($res_costanti as $costante) {
51   define("".$costante['nome'], $costante['value']);
52   
53   //20151030 - TICKET:0000635
54   define("".$costante['nome'].'_label', $costante['label']);
55 }
56 define("VERSION","2.2_55");
57 
58 //20141007 - TICKET:0000155
59 if(defined('FRM_VERSION')){
60     if(FRM_VERSION!=VERSION){
61         $q_update = 'UPDATE frm_sys_costanti SET value='.VERSION.' '