@@ -1270,7 +1270,7 @@  | 
                                                    ||
| 1270 | 1270 | |
| 1271 | 1271 | // TODO prendre en compte le filtre  | 
                                                        
| 1272 | 1272 |  		foreach ($pragmas as $var) { | 
                                                        
| 1273 | - $sql = "PRAGMA $var";  | 
                                                        |
| 1273 | + $sql = "pragma $var";  | 
                                                        |
| 1274 | 1274 | $resql = $this->query($sql);  | 
                                                        
| 1275 | 1275 |  			if ($resql) { | 
                                                        
| 1276 | 1276 | $obj = $this->fetch_row($resql);  | 
                                                        
@@ -263,7 +263,7 @@  | 
                                                    ||
| 263 | 263 | echo '<div>';  | 
                                                        
| 264 | 264 | echo '<table class="noborder centpercent">';  | 
                                                        
| 265 | 265 | echo '<thead>';  | 
                                                        
| 266 | -echo '<tr class="liste_titre"><th>' . $langs->trans('Parameter') . '</th><th>' . $langs->trans('Value') . '</th></tr>'; | 
                                                        |
| 266 | +echo '<tr class="liste_titre"><th>'.$langs->trans('Parameter').'</th><th>'.$langs->trans('Value').'</th></tr>'; | 
                                                        |
| 267 | 267 | echo '</thead>';  | 
                                                        
| 268 | 268 | echo '<tbody>';  | 
                                                        
| 269 | 269 | |
@@ -24,7 +24,7 @@ discard block  | 
                                                    ||
| 24 | 24 | * \brief Module to show box of members  | 
                                                        
| 25 | 25 | */  | 
                                                        
| 26 | 26 | |
| 27 | -include_once DOL_DOCUMENT_ROOT . '/core/boxes/modules_boxes.php';  | 
                                                        |
| 27 | +include_once DOL_DOCUMENT_ROOT.'/core/boxes/modules_boxes.php';  | 
                                                        |
| 28 | 28 | |
| 29 | 29 | |
| 30 | 30 | /**  | 
                                                        
@@ -83,8 +83,8 @@ discard block  | 
                                                    ||
| 83 | 83 | |
| 84 | 84 | $this->max = $max;  | 
                                                        
| 85 | 85 | |
| 86 | - include_once DOL_DOCUMENT_ROOT . '/adherents/class/adherent.class.php';  | 
                                                        |
| 87 | - require_once DOL_DOCUMENT_ROOT . '/adherents/class/adherent_type.class.php';  | 
                                                        |
| 86 | + include_once DOL_DOCUMENT_ROOT.'/adherents/class/adherent.class.php';  | 
                                                        |
| 87 | + require_once DOL_DOCUMENT_ROOT.'/adherents/class/adherent_type.class.php';  | 
                                                        |
| 88 | 88 | $memberstatic = new Adherent($this->db);  | 
                                                        
| 89 | 89 | $statictype = new AdherentType($this->db);  | 
                                                        
| 90 | 90 | |
@@ -100,8 +100,8 @@ discard block  | 
                                                    ||
| 100 | 100 | $numb = 0;  | 
                                                        
| 101 | 101 | |
| 102 | 102 | $sql = "SELECT c.subscription, c.dateadh as dateh";  | 
                                                        
| 103 | - $sql .= " FROM " . MAIN_DB_PREFIX . "adherent as d, " . MAIN_DB_PREFIX . "subscription as c";  | 
                                                        |
| 104 | -			$sql .= " WHERE d.entity IN (" . getEntity('adherent') . ")"; | 
                                                        |
| 103 | + $sql .= " FROM ".MAIN_DB_PREFIX."adherent as d, ".MAIN_DB_PREFIX."subscription as c";  | 
                                                        |
| 104 | +			$sql .= " WHERE d.entity IN (".getEntity('adherent').")"; | 
                                                        |
| 105 | 105 | $sql .= " AND d.rowid = c.fk_adherent";  | 
                                                        
| 106 | 106 | |
| 107 | 107 | |
@@ -216,7 +216,7 @@ discard block  | 
                                                    ||
| 216 | 216 | $this->info_box_contents[0][0] = array(  | 
                                                        
| 217 | 217 | 'td' => '',  | 
                                                        
| 218 | 218 | 'maxlength' => 500,  | 
                                                        
| 219 | - 'text' => ($this->db->error() . ' sql=' . $sql),  | 
                                                        |
| 219 | + 'text' => ($this->db->error().' sql='.$sql),  | 
                                                        |
| 220 | 220 | );  | 
                                                        
| 221 | 221 | }  | 
                                                        
| 222 | 222 |  		} else { | 
                                                        
@@ -100,7 +100,7 @@  | 
                                                    ||
| 100 | 100 |  				while ($line < $num) { | 
                                                        
| 101 | 101 | $objp = $this->db->fetch_object($result);  | 
                                                        
| 102 | 102 | $date = $this->db->jdate($objp->date_movement);  | 
                                                        
| 103 | - $journal = $objp->code_journal;  | 
                                                        |
| 103 | + $journal = $objp->code_journal;  | 
                                                        |
| 104 | 104 | $label = $objp->label_operation;  | 
                                                        
| 105 | 105 | $amount = $objp->amount;  | 
                                                        
| 106 | 106 | |
@@ -43,7 +43,7 @@  | 
                                                    ||
| 43 | 43 | * View  | 
                                                        
| 44 | 44 | */  | 
                                                        
| 45 | 45 | |
| 46 | -$form = new Form($db); // $form is required as global value into dol_banner_tab  | 
                                                        |
| 46 | +$form = new Form($db); // $form is required as global value into dol_banner_tab  | 
                                                        |
| 47 | 47 | |
| 48 | 48 |  llxHeader('', $langs->trans("CronInfo")); | 
                                                        
| 49 | 49 | |
@@ -335,10 +335,10 @@  | 
                                                    ||
| 335 | 335 |  			if (in_array($element, ['context1', 'context2'])) { | 
                                                        
| 336 | 336 | $datacount = 0;  | 
                                                        
| 337 | 337 | |
| 338 | -				$parameters['head'][$counter][0] = dol_buildpath('/mymodule/mymodule_tab.php', 1) . '?id=' . $id . '&module='.$element; | 
                                                        |
| 338 | +				$parameters['head'][$counter][0] = dol_buildpath('/mymodule/mymodule_tab.php', 1).'?id='.$id.'&module='.$element; | 
                                                        |
| 339 | 339 |  				$parameters['head'][$counter][1] = $langs->trans('MyModuleTab'); | 
                                                        
| 340 | 340 |  				if ($datacount > 0) { | 
                                                        
| 341 | - $parameters['head'][$counter][1] .= '<span class="badge marginleftonlyshort">' . $datacount . '</span>';  | 
                                                        |
| 341 | + $parameters['head'][$counter][1] .= '<span class="badge marginleftonlyshort">'.$datacount.'</span>';  | 
                                                        |
| 342 | 342 | }  | 
                                                        
| 343 | 343 | $parameters['head'][$counter][2] = 'mymoduleemails';  | 
                                                        
| 344 | 344 | $counter++;  | 
                                                        
@@ -102,8 +102,8 @@  | 
                                                    ||
| 102 | 102 | |
| 103 | 103 | |
| 104 | 104 | // List of targets fields  | 
                                                        
| 105 | -$headerlinefields = array(); // Array of fields (label to show)  | 
                                                        |
| 106 | -$contentlinevalues = array(); // Array of example values  | 
                                                        |
| 105 | +$headerlinefields = array(); // Array of fields (label to show)  | 
                                                        |
| 106 | +$contentlinevalues = array(); // Array of example values  | 
                                                        |
| 107 | 107 | $i = 0;  | 
                                                        
| 108 | 108 |  foreach ($fieldstarget as $code => $label) { | 
                                                        
| 109 | 109 |  	$withoutstar = preg_replace('/\*/', '', $fieldstarget[$code]); | 
                                                        
@@ -81,12 +81,12 @@  | 
                                                    ||
| 81 | 81 | $response = array();  | 
                                                        
| 82 | 82 |  		while ($i < $num) { | 
                                                        
| 83 | 83 | $obj = $db->fetch_object($resql);  | 
                                                        
| 84 | -			$response[] = array('title'=>$obj->question,'ref'=>$obj->ref,'answer'=>dol_escape_htmltag(preg_replace('/\\r|\\r\\n|\\n/', "", $obj->answer)),'url'=>$obj->url); | 
                                                        |
| 84 | +			$response[] = array('title'=>$obj->question, 'ref'=>$obj->ref, 'answer'=>dol_escape_htmltag(preg_replace('/\\r|\\r\\n|\\n/', "", $obj->answer)), 'url'=>$obj->url); | 
                                                        |
| 85 | 85 | $i++;  | 
                                                        
| 86 | 86 | }  | 
                                                        
| 87 | 87 |  	} else { | 
                                                        
| 88 | 88 | dol_print_error($db);  | 
                                                        
| 89 | 89 | }  | 
                                                        
| 90 | - $response =json_encode($response);  | 
                                                        |
| 90 | + $response = json_encode($response);  | 
                                                        |
| 91 | 91 | echo $response;  | 
                                                        
| 92 | 92 | }  | 
                                                        
@@ -214,16 +214,16 @@  | 
                                                    ||
| 214 | 214 | print '<table class="border tableforfield centpercent">';  | 
                                                        
| 215 | 215 | |
| 216 | 216 | print "<tr>";  | 
                                                        
| 217 | -	print '<td class="titlefield">' . $langs->trans("DateStartPeriod") . '</td><td>'; | 
                                                        |
| 217 | +	print '<td class="titlefield">'.$langs->trans("DateStartPeriod").'</td><td>'; | 
                                                        |
| 218 | 218 | print dol_print_date($object->datesp, 'day');  | 
                                                        
| 219 | 219 | print '</td></tr>';  | 
                                                        
| 220 | 220 | |
| 221 | 221 | print "<tr>";  | 
                                                        
| 222 | -	print '<td>' . $langs->trans("DateEndPeriod") . '</td><td>'; | 
                                                        |
| 222 | +	print '<td>'.$langs->trans("DateEndPeriod").'</td><td>'; | 
                                                        |
| 223 | 223 | print dol_print_date($object->dateep, 'day');  | 
                                                        
| 224 | 224 | print '</td></tr>';  | 
                                                        
| 225 | 225 | |
| 226 | -	print '<tr><td>' . $langs->trans("Amount") . '</td><td><span class="amount">' . price($object->amount, 0, $langs, 1, -1, -1, $conf->currency) . '</span></td></tr>'; | 
                                                        |
| 226 | +	print '<tr><td>'.$langs->trans("Amount").'</td><td><span class="amount">'.price($object->amount, 0, $langs, 1, -1, -1, $conf->currency).'</span></td></tr>'; | 
                                                        |
| 227 | 227 | |
| 228 | 228 |  	print '<tr><td class="titlefield">'.$langs->trans("NbOfAttachedFiles").'</td><td>'.count($filearray).'</td></tr>'; | 
                                                        
| 229 | 229 | |