alxarafe / alixar

public/htdocs/core/modules/supplier_order/doc/pdf_cornas.modules.php

Spacing +1 added lines, -1 removed lines

@@ -90,7 +90,7 @@
         $this->db = $db;
         $this->name = "cornas";
         $this->description = $langs->trans('SuppliersCommandModel');
-        $this->update_main_doc_field = 1;       // Save the name of generated file as the main doc when generating a doc with this template
+        $this->update_main_doc_field = 1; // Save the name of generated file as the main doc when generating a doc with this template
 
         // Page size for A4 format
         $this->type = 'pdf';

public/htdocs/core/modules/modFacture.class.php

Spacing +1 added lines, -1 removed lines

@@ -689,7 +689,7 @@
         $keyforaliasextra = 'extra';
         include DOL_DOCUMENT_ROOT . '/core/extrafieldsinexport.inc.php';
         $this->export_sql_start[$r] = 'SELECT DISTINCT ';
-        $this->export_sql_end[$r]  = ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
+        $this->export_sql_end[$r] = ' FROM ' . MAIN_DB_PREFIX . 'societe as s';
         if (!empty($user) && !$user->hasRight('societe', 'client', 'voir')) {
             $this->export_sql_end[$r] .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
         }

public/htdocs/core/modules/contract/doc/doc_generic_contract_odt.modules.php

Spacing +1 added lines, -1 removed lines

@@ -174,7 +174,7 @@
         $maxfilesizearray = getMaxFileSizeArray();
         $maxmin = $maxfilesizearray['maxmin'];
         if ($maxmin > 0) {
-            $texte .= '<input type="hidden" name="MAX_FILE_SIZE" value="' . ($maxmin * 1024) . '">';    // MAX_FILE_SIZE must precede the field type=file
+            $texte .= '<input type="hidden" name="MAX_FILE_SIZE" value="' . ($maxmin * 1024) . '">'; // MAX_FILE_SIZE must precede the field type=file
         }
         $texte .= ' <input type="file" name="uploadfile">';
         $texte .= '<input type="hidden" value="CONTRACT_ADDON_PDF_ODT_PATH" name="keyforuploaddir">';

public/htdocs/core/modules/modExpedition.class.php

Spacing +2 added lines, -2 removed lines

@@ -45,7 +45,7 @@ 
      */
     public function __construct($db)
     {
-        global $conf, $user;    // $conf is required by /core/extrafieldsinexport.inc.php
+        global $conf, $user; // $conf is required by /core/extrafieldsinexport.inc.php
 
         $this->db = $db;
         $this->numero = 80;
@@ -248,7 +248,7 @@ 
         $this->export_fields_array[$r] = array(
             's.rowid' => "IdCompany", 's.nom' => 'ThirdParty', 's.address' => 'Address', 's.zip' => 'Zip', 's.town' => 'Town', 'd.nom' => 'State', 'co.label' => 'Country',
             'co.code' => 'CountryCode', 's.phone' => 'Phone', 's.siren' => 'ProfId1', 's.siret' => 'ProfId2', 's.ape' => 'ProfId3', 's.idprof4' => 'ProfId4', 's.idprof5' => 'ProfId5',
-            's.idprof6' => 'ProfId6', 'c.rowid' => "Id", 'c.ref' => "Ref", 'c.ref_customer' => "RefCustomer", 'c.fk_soc' => "IdCompany", 'c.date_creation' => "DateCreation",  'c.date_valid' => "DateValidation",
+            's.idprof6' => 'ProfId6', 'c.rowid' => "Id", 'c.ref' => "Ref", 'c.ref_customer' => "RefCustomer", 'c.fk_soc' => "IdCompany", 'c.date_creation' => "DateCreation", 'c.date_valid' => "DateValidation",
             'c.date_delivery' => "DateDeliveryPlanned", 'c.tracking_number' => "TrackingNumber", 'c.height' => "Height", 'c.width' => "Width", 'c.size' => "Depth",
             'c.size_units' => 'SizeUnits', 'c.weight' => "Weight", 'c.weight_units' => "WeightUnits", 'c.fk_statut' => 'Status', 'c.note_public' => "NotePublic",
             'ed.rowid' => 'LineId', 'cd.description' => 'Description', 'ed.qty' => "Qty", 'p.rowid' => 'ProductId', 'p.ref' => 'ProductRef', 'p.label' => 'ProductLabel',

public/htdocs/core/modules/modEventOrganization.class.php

Spacing +42 added lines, -42 removed lines

@@ -233,82 +233,82 @@ 
         /* END MODULEBUILDER TOPMENU */
         /* BEGIN MODULEBUILDER LEFTMENU CONFERENCEORBOOTH*/
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project',     // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'EventOrganizationMenuLeft',
             'prefix' => img_picto('', 'eventorganization', 'class="paddingright pictofixedwidth"'),
             'mainmenu' => 'project',
             'leftmenu' => 'eventorganization',
             'url' => '',
-            'langs' => 'eventorganization',         // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "read")',                          // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "read")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganization',       // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganization', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'New',
             'url' => '/projet/card.php?leftmenu=projects&action=create&usage_organize_event=1&usage_opportunity=0',
-            'langs' => 'eventorganization@eventorganization',           // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization@eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "write")',                         // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "write")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganization',       // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganization', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'List',
             'url' => '/projet/list.php?search_usage_event_organization=1&search_status=99&mainmenu=project&contextpage=organizedevents',
-            'langs' => 'eventorganization@eventorganization',           // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization@eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "write")',                         // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "write")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project',     // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'ConferenceOrBooth',
             'prefix' => img_picto('', 'conferenceorbooth', 'class="paddingright pictofixedwidth"'),
             'mainmenu' => 'project',
             'leftmenu' => 'eventorganizationconforbooth',
             'url' => '',
-            'langs' => 'eventorganization',         // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "read")',                          // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "read")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganizationconforbooth',        // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganizationconforbooth', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'New',
             'url' => '/eventorganization/conferenceorbooth_card.php?leftmenu=projects&action=create',
-            'langs' => 'eventorganization',         // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "write")',                         // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "write")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         $this->menu[$r++] = array(
-            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganizationconforbooth',        // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
-            'type' => 'left',                           // This is a Left menu entry
+            'fk_menu' => 'fk_mainmenu=project,fk_leftmenu=eventorganizationconforbooth', // '' if this is a top menu. For left menu, use 'fk_mainmenu=xxx' or 'fk_mainmenu=xxx,fk_leftmenu=yyy' where xxx is mainmenucode and yyy is a leftmenucode
+            'type' => 'left', // This is a Left menu entry
             'titre' => 'List',
             'url' => '/eventorganization/conferenceorbooth_list.php?mainmenu=project',
-            'langs' => 'eventorganization',         // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
+            'langs' => 'eventorganization', // Lang file to use (without .lang) by module. File must be in langs/code_CODE/ directory.
             'position' => 1000 + $r,
-            'enabled' => 'isModEnabled("eventorganization")',  // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
-            'perms' => '$user->hasRight("eventorganization", "read")',                          // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
+            'enabled' => 'isModEnabled("eventorganization")', // Define condition to show or hide menu entry. Use '$conf->eventorganization->enabled' if entry must be visible if module is enabled. Use '$leftmenu==\'system\'' to show if leftmenu system is selected.
+            'perms' => '$user->hasRight("eventorganization", "read")', // Use 'perms'=>'$user->rights->eventorganization->level1->level2' if you want your menu with a permission rules
             'target' => '',
-            'user' => 2,                                // 0=Menu for internal users, 1=external users, 2=both
+            'user' => 2, // 0=Menu for internal users, 1=external users, 2=both
         );
         /* END MODULEBUILDER LEFTMENU CONFERENCEORBOOTH */
 
@@ -326,8 +326,8 @@ 
         $keyforelement = 'conferenceorboothattendee';
         include DOL_DOCUMENT_ROOT . '/core/commonfieldsinexport.inc.php';
         $this->export_entities_array[$r]['t.fk_invoice'] = 'invoice';
-        unset($this->export_fields_array[$r]['t.fk_project']);  // Remove field so we can add it at end just after
-        unset($this->export_fields_array[$r]['t.fk_soc']);  // Remove field so we can add it at end just after
+        unset($this->export_fields_array[$r]['t.fk_project']); // Remove field so we can add it at end just after
+        unset($this->export_fields_array[$r]['t.fk_soc']); // Remove field so we can add it at end just after
         $this->export_fields_array[$r]['t.fk_invoice'] = 'InvoiceId';
         $this->export_fields_array[$r]['t.fk_project'] = 'ProjectId';
         $this->export_fields_array[$r]['p.ref'] = 'ProjectRef';
@@ -359,16 +359,16 @@ 
         /* BEGIN MODULEBUILDER EXPORT CONFERENCEORBOOTH */
         $langs->load("eventorganization");
         $this->export_code[$r] = $this->rights_class . '_' . $r;
-        $this->export_label[$r] = 'ListOfConfOrBoothOfEvent';   // Translation key (used only if key ExportDataset_xxx_z not found)
+        $this->export_label[$r] = 'ListOfConfOrBoothOfEvent'; // Translation key (used only if key ExportDataset_xxx_z not found)
         $this->export_icon[$r] = 'conferenceorbooth';
         // Define $this->export_fields_array, $this->export_TypeFields_array and $this->export_entities_array
         $keyforclass = 'ConferenceOrBooth';
         $keyforclassfile = '/eventorganization/class/conferenceorbooth.class.php';
         $keyforelement = 'conferenceorbooth';
         include DOL_DOCUMENT_ROOT . '/core/commonfieldsinexport.inc.php';
-        unset($this->export_fields_array[$r]['t.fk_action']);   // Remove field so we can add it at end just after
-        unset($this->export_fields_array[$r]['t.fk_project']);  // Remove field so we can add it at end just after
-        unset($this->export_fields_array[$r]['t.fk_soc']);  // Remove field so we can add it at end just after
+        unset($this->export_fields_array[$r]['t.fk_action']); // Remove field so we can add it at end just after
+        unset($this->export_fields_array[$r]['t.fk_project']); // Remove field so we can add it at end just after
+        unset($this->export_fields_array[$r]['t.fk_soc']); // Remove field so we can add it at end just after
         $this->export_fields_array[$r]['t.fk_action'] = 'ConferenceOrBoothFormatID';
         $this->export_fields_array[$r]['ca.code'] = 'ConferenceOrBoothFormatCode';
         $this->export_fields_array[$r]['ca.libelle'] = 'ConferenceOrBoothFormatLabel';

public/htdocs/core/modules/modResource.class.php

Spacing +1 added lines, -1 removed lines

@@ -43,7 +43,7 @@
      */
     public function __construct($db)
     {
-        global $langs, $conf;   // $langs may be used by the tpl files.
+        global $langs, $conf; // $langs may be used by the tpl files.
 
         $this->db = $db;
 

public/htdocs/core/modules/modApi.class.php

Spacing +5 added lines, -5 removed lines

@@ -143,11 +143,11 @@ 
 
         // Add here list of permission defined by an id, a label, a boolean and two constant strings.
         // Example:
-        $this->rights[$r][0] = $this->numero + $r;  // Permission id (must not be already used)
+        $this->rights[$r][0] = $this->numero + $r; // Permission id (must not be already used)
         $this->rights[$r][1] = 'Generate/modify users API key'; // Permission label
-        $this->rights[$r][3] = 0;                   // Permission by default for new user (0/1)
-        $this->rights[$r][4] = 'apikey';                // In php code, permission will be checked by test if ($user->hasRight('permkey','level1','level2'))
-        $this->rights[$r][5] = 'generate';              // In php code, permission will be checked by test if ($user->hasRight('permkey','level1','level2'))
+        $this->rights[$r][3] = 0; // Permission by default for new user (0/1)
+        $this->rights[$r][4] = 'apikey'; // In php code, permission will be checked by test if ($user->hasRight('permkey','level1','level2'))
+        $this->rights[$r][5] = 'generate'; // In php code, permission will be checked by test if ($user->hasRight('permkey','level1','level2'))
         $r++;
 
 
@@ -230,7 +230,7 @@ 
     {
         // Remove old constants with entity fields different of 0
         $sql = array(
-            "DELETE FROM " . MAIN_DB_PREFIX . "const WHERE name = " . $this->db->encrypt('MAIN_MODULE_API'),      // API can't be enabled per environment. Why ?
+            "DELETE FROM " . MAIN_DB_PREFIX . "const WHERE name = " . $this->db->encrypt('MAIN_MODULE_API'), // API can't be enabled per environment. Why ?
             "DELETE FROM " . MAIN_DB_PREFIX . "const WHERE name = " . $this->db->encrypt('API_PRODUCTION_MODE')   // Not in production mode by default at activation
         );
 

public/htdocs/core/modules/security/generate/modGeneratePassPerso.class.php

Spacing +2 added lines, -2 removed lines

@@ -175,7 +175,7 @@ 
             return $pass;
         }
 
-        return $this->getNewGeneratedPassword();    // warning, may generate infinite loop if conditions are not possible
+        return $this->getNewGeneratedPassword(); // warning, may generate infinite loop if conditions are not possible
     }
 
     /**
@@ -189,7 +189,7 @@ 
     {
         global $langs;
 
-        $this->initAll();   // For the case this method is called alone
+        $this->initAll(); // For the case this method is called alone
 
         $password_a = preg_split('//u', $password, 0, PREG_SPLIT_NO_EMPTY);
         $maj = preg_split('//u', $this->Maj, 0, PREG_SPLIT_NO_EMPTY);

public/htdocs/core/modules/modProduct.class.php

Spacing +3 added lines, -3 removed lines

@@ -208,7 +208,7 @@ 
             'p.duration' => "Duration",
             'p.finished' => 'Nature',
             'p.price_base_type' => "PriceBase", 'p.price' => "UnitPriceHT", 'p.price_ttc' => "UnitPriceTTC",
-            'p.price_min' => "MinPriceHT",'p.price_min_ttc' => "MinPriceTTC",
+            'p.price_min' => "MinPriceHT", 'p.price_min_ttc' => "MinPriceTTC",
             'p.tva_tx' => 'VATRate',
             'p.datec' => 'DateCreation', 'p.tms' => 'DateModification'
         );
@@ -306,7 +306,7 @@ 
             $this->export_dependencies_array[$r] = array('category' => 'p.rowid');
         }
         $this->export_sql_start[$r] = 'SELECT DISTINCT ';
-        $this->export_sql_end[$r]  = ' FROM ' . MAIN_DB_PREFIX . 'product as p';
+        $this->export_sql_end[$r] = ' FROM ' . MAIN_DB_PREFIX . 'product as p';
         if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
             $this->export_sql_end[$r] .= " LEFT JOIN " . MAIN_DB_PREFIX . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int) $conf->entity);
         }
@@ -461,7 +461,7 @@ 
             $this->export_fields_array[$r] = array_merge($this->export_fields_array[$r], array('p2.rowid' => "Id", 'p2.ref' => "Ref", 'p2.label' => "Label", 'p2.description' => "Description"));
             $this->export_entities_array[$r] = array_merge($this->export_entities_array[$r], array('p2.rowid' => "subproduct", 'p2.ref' => "subproduct", 'p2.label' => "subproduct", 'p2.description' => "subproduct"));
             $this->export_sql_start[$r] = 'SELECT DISTINCT ';
-            $this->export_sql_end[$r]  = ' FROM ' . MAIN_DB_PREFIX . 'product as p';
+            $this->export_sql_end[$r] = ' FROM ' . MAIN_DB_PREFIX . 'product as p';
             if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
                 $this->export_sql_end[$r] .= " LEFT JOIN " . MAIN_DB_PREFIX . "product_perentity as ppe ON ppe.fk_product = p.rowid AND ppe.entity = " . ((int) $conf->entity);
             }