galette/lib/Galette/Core/Preferences.php

   1 <?php
   2
   3 /* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
   4
   5 /**
   6  * Preferences handling
   7  *
   8  * PHP version 5
   9  *
  10  * Copyright © 2007-2014 The Galette Team
  11  *
  12  * This file is part of Galette (http://galette.tuxfamily.org).
  13  *
  14  * Galette is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU General Public License as published by
  16  * the Free Software Foundation, either version 3 of the License, or
  17  * (at your option) any later version.
  18  *
  19  * Galette is distributed in the hope that it will be useful,
  20  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  21  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  22  *  GNU General Public License for more details.
  23  *
  24  * You should have received a copy of the GNU General Public License
  25  * along with Galette. If not, see <http://www.gnu.org/licenses/>.
  26  *
  27  * @category  Core
  28  * @package   Galette
  29  * @author    Johan Cwiklinski <johan@x-tnd.be>
  30  * @copyright 2007-2014 The Galette Team
  31  * @license   http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
  32  * @link      http://galette.tuxfamily.org
  33  * @since     Available since 0.7dev - 2007-10-14
  34  */
  35
  36 namespace Galette\Core;
  37
  38 use Analog\Analog;
  39 use Galette\Entity\Adherent;
  40 use Galette\Entity\Status;
  41 use Galette\Core\Db;
  42 use Galette\IO\PdfMembersCards;
  43 use Galette\Repository\Members;
  44
  45 /**
  46  * Preferences for galette
  47  *
  48  * @category  Core
  49  * @name      Preferences
  50  * @package   Galette
  51  * @author    Johan Cwiklinski <johan@x-tnd.be>
  52  * @copyright 2007-2014 The Galette Team
  53  * @license   http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
  54  * @link      http://galette.tuxfamily.org
  55  * @since     Available since 0.7dev - 2007-10-14
  56  *
  57  * @property string $pref_admin_login Super admin login
  58  * @property string $pref_admin_pass Super admin password
  59  * @property string $pref_nom Association name
  60  * @property string $pref_slogan Association slogan
  61  * @property string $pref_adresse Address
  62  * @property string $pref_adresse2 Address continuation
  63  * @property string $pref_cp Association zipcode
  64  * @property string $pref_ville Association town
  65  * @property string $pref_pays Country
  66  * @property integer $pref_postal_adress Postal adress to use, one of self::POSTAL_ADDRESS*
  67  * @property integer $pref_postal_staff_member Staff member ID from which retrieve postal address
  68  * @property string $pref_lang Default instance language
  69  * @property integer $pref_numrows Default number of rows in lists
  70  * @property integer $pref_log History, one of self::LOG_*
  71  * @property interger $pref_statut Default status for new members
  72  * @property string $pref_email_nom
  73  * @property string $pref_email
  74  * @property string $pref_email_newadh
  75  * @property boolean $pref_bool_mailadh
  76  * @property boolean $pref_editor_enabled
  77  * @property integer $pref_mail_method Mail method, see GaletteMail::METHOD_*
  78  * @property string $pref_mail_smtp
  79  * @property string $pref_mail_smtp_host
  80  * @property boolean $pref_mail_smtp_auth
  81  * @property boolean $pref_mail_smtp_secure
  82  * @property integer $pref_mail_smtp_port
  83  * @property string $pref_mail_smtp_user
  84  * @property string $pref_mail_smtp_password
  85  * @property integer $pref_membership_ext
  86  * @property string $pref_beg_membership
  87  * @property integer $pref_membership_offermonths
  88  * @property string $pref_email_reply_to
  89  * @property string $pref_website
  90  * @property integer $pref_etiq_marges_v
  91  * @property string $pref_etiq_marges_h
  92  * @property string $pref_etiq_hspace
  93  * @property string $pref_etiq_vspace
  94  * @property string $pref_etiq_hsize
  95  * @property string $pref_etiq_vsize
  96  * @property string $pref_etiq_cols
  97  * @property string $pref_etiq_rows
  98  * @property string $pref_etiq_corps
  99  * @property string $pref_card_abrev
 100  * @property string $pref_card_strip
 101  * @property string $pref_card_tcol
 102  * @property string $pref_card_scol
 103  * @property string $pref_card_bcol
 104  * @property string $pref_card_hcol
 105  * @property string $pref_bool_display_title
 106  * @property integer $pref_card_address
 107  * @property string $pref_card_year
 108  * @property integer $pref_card_marges_v
 109  * @property integer $pref_card_marges_h
 110  * @property integer $pref_card_vspace
 111  * @property integer $pref_card_hspace
 112  * @property string $pref_card_self
 113  * @property string $pref_theme Prefered theme
 114  * @property boolean $pref_bool_publicpages
 115  * @property integer $pref_publicpages_visibility
 116  * @property boolean $pref_bool_selfsubscribe
 117  * @property string $pref_googleplus
 118  * @property string $pref_facebook
 119  * @property string $pref_twitter
 120  * @property string $pref_viadeo
 121  * @property string $pref_linkedin
 122  * @property string $pref_mail_sign
 123  * @property string $pref_new_contrib_script
 124  * @property boolean $pref_bool_wrap_mails
 125  * @property string $pref_rss_url
 126  * @property boolean $pref_show_id
 127  * @property string $pref_adhesion_form
 128  * @property boolean $pref_mail_allow_unsecure
 129  * @property string $pref_instance_uuid
 130  * @property string $pref_registration_uuid
 131  * @property string $pref_telemetry_date
 132  * @property string $pref_registration_date
 133  * @property string $pref_footer
 134  * @property integer $pref_filter_account
 135  * @property string $pref_galette_url
 136  * @property integer $pref_redirect_on_create
 137  * @property integer $pref_password_length
 138  * @property boolean $pref_password_blacklist
 139  * @property integer $pref_password_strength
 140  * @property-read string $vpref_email_newadh Comma separated list of mail senders
 141  */
 142 class Preferences
 143 {
 144     private $zdb;
 145     private $prefs;
 146     private $errors = [];
 147
 148     public const TABLE = 'preferences';
 149     public const PK = 'nom_pref';
 150
 151     /** Postal address will be the one given in the preferences */
 152     public const POSTAL_ADDRESS_FROM_PREFS = 0;
 153     /** Postal address will be the one of the selected staff member */
 154     public const POSTAL_ADDRESS_FROM_STAFF = 1;
 155
 156     /** Public pages stuff */
 157     /** Public pages are publically visibles */
 158     public const PUBLIC_PAGES_VISIBILITY_PUBLIC = 0;
 159     /** Public pages are visibles for up to date members only */
 160     public const PUBLIC_PAGES_VISIBILITY_RESTRICTED = 1;
 161     /** Public pages are visibles for admin and staff members only */
 162     public const PUBLIC_PAGES_VISIBILITY_PRIVATE = 2;
 163
 164     public const LOG_DISABLED = 0;
 165     public const LOG_ENABLED = 1;
 166
 167     /** No password strength */
 168     public const PWD_NONE = 0;
 169     /** Weak password strength */
 170     public const PWD_WEAK = 1;
 171     /** Medium password strength */
 172     public const PWD_MEDIUM = 2;
 173     /** Strong password strength */
 174     public const PWD_STRONG = 3;
 175     /** Very strong password strength */
 176     public const PWD_VERY_STRONG = 4;
 177
 178     private static $fields = array(
 179         'nom_pref',
 180         'val_pref'
 181     );
 182
 183     private static $defaults = array(
 184         'pref_admin_login'    =>    'admin',
 185         'pref_admin_pass'    =>    'admin',
 186         'pref_nom'        =>    'Galette',
 187         'pref_slogan'        =>    '',
 188         'pref_adresse'        =>    '-',
 189         'pref_adresse2'        =>    '',
 190         'pref_cp'        =>    '',
 191         'pref_ville'        =>    '',
 192         'pref_pays'        =>    '',
 193         'pref_postal_adress'  => self::POSTAL_ADDRESS_FROM_PREFS,
 194         'pref_postal_staff_member' => '',
 195         'pref_lang'        =>    I18n::DEFAULT_LANG,
 196         'pref_numrows'        =>    30,
 197         'pref_log'        =>    self::LOG_ENABLED,
 198         'pref_statut'        =>    Status::DEFAULT_STATUS,
 199         /* Preferences for emails */
 200         'pref_email_nom'    =>    'Galette',
 201         'pref_email'        =>    'mail@domain.com',
 202         'pref_email_newadh'    =>    'mail@domain.com',
 203         'pref_bool_mailadh'    =>    false,
 204         'pref_editor_enabled'    =>    false,
 205         'pref_mail_method'    =>    GaletteMail::METHOD_DISABLED,
 206         'pref_mail_smtp'    =>    '',
 207         'pref_mail_smtp_host'   => '',
 208         'pref_mail_smtp_auth'   => false,
 209         'pref_mail_smtp_secure' => false,
 210         'pref_mail_smtp_port'   => '',
 211         'pref_mail_smtp_user'   => '',
 212         'pref_mail_smtp_password'   => '',
 213         'pref_membership_ext'    =>    12,
 214         'pref_beg_membership'    =>    '',
 215         'pref_membership_offermonths' => 0,
 216         'pref_email_reply_to'    =>    '',
 217         'pref_website'        =>    '',
 218         /* Preferences for labels */
 219         'pref_etiq_marges_v'    =>    10,
 220         'pref_etiq_marges_h'    =>    10,
 221         'pref_etiq_hspace'    =>    10,
 222         'pref_etiq_vspace'    =>    5,
 223         'pref_etiq_hsize'    =>    90,
 224         'pref_etiq_vsize'    =>    35,
 225         'pref_etiq_cols'    =>    2,
 226         'pref_etiq_rows'    =>    7,
 227         'pref_etiq_corps'    =>    12,
 228         /* Preferences for members cards */
 229         'pref_card_abrev'    =>    'GALETTE',
 230         'pref_card_strip'    =>    'Gestion d\'Adherents en Ligne Extrêmement Tarabiscotée',
 231         'pref_card_tcol'    =>    'FFFFFF',
 232         'pref_card_scol'    =>    '8C2453',
 233         'pref_card_bcol'    =>    '53248C',
 234         'pref_card_hcol'    =>    '248C53',
 235         'pref_bool_display_title'    =>    false,
 236         'pref_card_address'    =>    1,
 237         'pref_card_year'    =>    '',
 238         'pref_card_marges_v'    =>    15,
 239         'pref_card_marges_h'    =>    20,
 240         'pref_card_vspace'    =>    5,
 241         'pref_card_hspace'    =>    10,
 242         'pref_card_self'    =>    1,
 243         'pref_theme'        =>    'default',
 244         'pref_bool_publicpages' => true,
 245         'pref_publicpages_visibility' => self::PUBLIC_PAGES_VISIBILITY_RESTRICTED,
 246         'pref_bool_selfsubscribe' => true,
 247         'pref_googleplus' => '',
 248         'pref_facebook' => '',
 249         'pref_twitter' => '',
 250         'pref_viadeo' => '',
 251         'pref_linkedin' => '',
 252         'pref_mail_sign' => "{NAME}\r\n\r\n{WEBSITE}\r\n{GOOGLEPLUS}\r\n{FACEBOOK}\r\n{TWITTER}\r\n{LINKEDIN}\r\n{VIADEO}",
 253         /* New contribution script */
 254         'pref_new_contrib_script' => '',
 255         'pref_bool_wrap_mails' => true,
 256         'pref_rss_url' => 'http://galette.eu/dc/index.php/feed/atom',
 257         'pref_show_id' => false,
 258         'pref_adhesion_form' => '\Galette\IO\PdfAdhesionForm',
 259         'pref_mail_allow_unsecure' => false,
 260         'pref_instance_uuid' => '',
 261         'pref_registration_uuid' => '',
 262         'pref_telemetry_date' => '',
 263         'pref_registration_date' => '',
 264         'pref_footer' => '',
 265         'pref_filter_account' => Members::ALL_ACCOUNTS,
 266         'pref_galette_url' => '',
 267         'pref_redirect_on_create' => Adherent::AFTER_ADD_DEFAULT,
 268         /* Security related */
 269         'pref_password_length' => 6,
 270         'pref_password_blacklist' => false,
 271         'pref_password_strength' => self::PWD_NONE
 272     );
 273
 274     // flagging required fields
 275     private $required = array(
 276         'pref_nom',
 277         'pref_lang',
 278         'pref_numrows',
 279         'pref_log',
 280         'pref_etiq_marges_v',
 281         'pref_etiq_marges_h',
 282         'pref_etiq_hspace',
 283         'pref_etiq_vspace',
 284         'pref_etiq_hsize',
 285         'pref_etiq_vsize',
 286         'pref_etiq_cols',
 287         'pref_etiq_rows',
 288         'pref_etiq_corps',
 289         'pref_card_abrev',
 290         'pref_card_strip',
 291         'pref_card_marges_v',
 292         'pref_card_marges_h',
 293         'pref_card_hspace',
 294         'pref_card_vspace'
 295     );
 296
 297     /**
 298      * Default constructor
 299      *
 300      * @param Db      $zdb  Db instance
 301      * @param boolean $load Automatically load preferences on load
 302      *
 303      * @return void
 304      */
 305     public function __construct(Db $zdb, $load = true)
 306     {
 307         $this->zdb = $zdb;
 308         if ($load) {
 309             $this->load();
 310             $this->checkUpdate();
 311         }
 312     }
 313
 314     /**
 315      * Check if all fields referenced in the default array does exists,
 316      * create them if not
 317      *
 318      * @return void
 319      */
 320     private function checkUpdate()
 321     {
 322         $proceed = false;
 323         $params = array();
 324         foreach (self::$defaults as $k => $v) {
 325             if (!isset($this->prefs[$k])) {
 326                 $this->prefs[$k] = $v;
 327                 Analog::log(
 328                     'The field `' . $k . '` does not exists, Galette will attempt to create it.',
 329                     Analog::INFO
 330                 );
 331                 $proceed = true;
 332                 $params[] = array(
 333                     'nom_pref'  => $k,
 334                     'val_pref'  => $v
 335                 );
 336             }
 337         }
 338         if ($proceed !== false) {
 339             try {
 340                 $insert = $this->zdb->insert(self::TABLE);
 341                 $insert->values(
 342                     array(
 343                         'nom_pref'  => ':nom_pref',
 344                         'val_pref'  => ':val_pref'
 345                     )
 346                 );
 347                 $stmt = $this->zdb->sql->prepareStatementForSqlObject($insert);
 348
 349                 foreach ($params as $p) {
 350                     $stmt->execute(
 351                         array(
 352                             'nom_pref' => $p['nom_pref'],
 353                             'val_pref' => $p['val_pref']
 354                         )
 355                     );
 356                 }
 357             } catch (\Exception $e) {
 358                 Analog::log(
 359                     'Unable to add missing preferences.' . $e->getMessage(),
 360                     Analog::WARNING
 361                 );
 362                 return false;
 363             }
 364
 365             Analog::log(
 366                 'Missing preferences were successfully stored into database.',
 367                 Analog::INFO
 368             );
 369         }
 370     }
 371
 372     /**
 373      * Load current preferences from database.
 374      *
 375      * @return boolean
 376      */
 377     public function load()
 378     {
 379         $this->prefs = array();
 380
 381         try {
 382             $result = $this->zdb->selectAll(self::TABLE);
 383             foreach ($result as $pref) {
 384                 $this->prefs[$pref->nom_pref] = $pref->val_pref;
 385             }
 386             return true;
 387         } catch (\Exception $e) {
 388             Analog::log(
 389                 'Preferences cannot be loaded. Galette should not work without ' .
 390                 'preferences. Exiting.',
 391                 Analog::URGENT
 392             );
 393             return false;
 394         }
 395     }
 396
 397     /**
 398      * Set default preferences at install time
 399      *
 400      * @param string $lang      language selected at install screen
 401      * @param string $adm_login admin login entered at install time
 402      * @param string $adm_pass  admin password entered at install time
 403      *
 404      * @return boolean|\Exception
 405      */
 406     public function installInit($lang, $adm_login, $adm_pass)
 407     {
 408         try {
 409             //first, we drop all values
 410             $delete = $this->zdb->delete(self::TABLE);
 411             $this->zdb->execute($delete);
 412
 413             //we then replace default values with the ones user has selected
 414             $values = self::$defaults;
 415             $values['pref_lang'] = $lang;
 416             $values['pref_admin_login'] = $adm_login;
 417             $values['pref_admin_pass'] = $adm_pass;
 418             $values['pref_card_year'] = date('Y');
 419
 420             $insert = $this->zdb->insert(self::TABLE);
 421             $insert->values(
 422                 array(
 423                     'nom_pref'  => ':nom_pref',
 424                     'val_pref'  => ':val_pref'
 425                 )
 426             );
 427             $stmt = $this->zdb->sql->prepareStatementForSqlObject($insert);
 428
 429             foreach ($values as $k => $v) {
 430                 $stmt->execute(
 431                     array(
 432                         'nom_pref' => $k,
 433                         'val_pref' => $v
 434                     )
 435                 );
 436             }
 437
 438             Analog::log(
 439                 'Default preferences were successfully stored into database.',
 440                 Analog::INFO
 441             );
 442             return true;
 443         } catch (\Exception $e) {
 444             Analog::log(
 445                 'Unable to initialize default preferences.' . $e->getMessage(),
 446                 Analog::WARNING
 447             );
 448             return $e;
 449         }
 450     }
 451
 452     /**
 453      * Returns all preferences keys
 454      *
 455      * @return array
 456      */
 457     public function getFieldsNames()
 458     {
 459         return array_keys($this->prefs);
 460     }
 461
 462     /**
 463      * Check values
 464      *
 465      * @param array $values Values
 466      * @param Login $login  Logged in user
 467      *
 468      * @return boolean
 469      */
 470     public function check(array $values, Login $login)
 471     {
 472         $insert_values = array();
 473         if ($login->isSuperAdmin() && GALETTE_MODE !== 'DEMO') {
 474             $this->required[] = 'pref_admin_login';
 475         }
 476
 477         // obtain fields
 478         foreach ($this->getFieldsNames() as $fieldname) {
 479             if (isset($values[$fieldname])) {
 480                 $value = trim($values[$fieldname]);
 481             } else {
 482                 $value = "";
 483             }
 484
 485             // now, check validity
 486             if ($value != '') {
 487                 switch ($fieldname) {
 488                     case 'pref_admin_login':
 489                         if (GALETTE_MODE === 'DEMO') {
 490                             Analog::log(
 491                                 'Trying to set superadmin login while in DEMO.',
 492                                 Analog::WARNING
 493                             );
 494                         } else {
 495                             if (strlen($value) < 4) {
 496                                 $this->errors[] = _T("- The username must be composed of at least 4 characters!");
 497                             } else {
 498                                 //check if login is already taken
 499                                 if ($login->loginExists($value)) {
 500                                     $this->errors[] = _T("- This username is already used by another member !");
 501                                 }
 502                             }
 503                         }
 504                         break;
 505                     case 'pref_numrows':
 506                         if (!is_numeric($value) || $value < 0) {
 507                             $this->errors[] = _T("- The numbers and measures have to be integers!");
 508                         }
 509                         break;
 510                     case 'pref_etiq_marges_h':
 511                     case 'pref_etiq_marges_v':
 512                     case 'pref_etiq_hspace':
 513                     case 'pref_etiq_vspace':
 514                     case 'pref_etiq_hsize':
 515                     case 'pref_etiq_vsize':
 516                     case 'pref_etiq_cols':
 517                     case 'pref_etiq_rows':
 518                     case 'pref_etiq_corps':
 519                     case 'pref_card_marges_v':
 520                     case 'pref_card_marges_h':
 521                     case 'pref_card_hspace':
 522                     case 'pref_card_vspace':
 523                         // prevent division by zero
 524                         if ($fieldname == 'pref_numrows' && $value == '0') {
 525                             $value = '10';
 526                         }
 527                         if (!is_numeric($value) || $value < 0) {
 528                             $this->errors[] = _T("- The numbers and measures have to be integers!");
 529                         }
 530                         break;
 531                     case 'pref_card_tcol':
 532                         // Set strip text color to white
 533                         if (!preg_match("/#([0-9A-F]{6})/i", $value)) {
 534                             $value = '#FFFFFF';
 535                         }
 536                         break;
 537                     case 'pref_card_scol':
 538                     case 'pref_card_bcol':
 539                     case 'pref_card_hcol':
 540                         // Set strip background colors to black
 541                         if (!preg_match("/#([0-9A-F]{6})/i", $value)) {
 542                             $value = '#000000';
 543                         }
 544                         break;
 545                     case 'pref_admin_pass':
 546                         if (GALETTE_MODE == 'DEMO') {
 547                             Analog::log(
 548                                 'Trying to set superadmin pass while in DEMO.',
 549                                 Analog::WARNING
 550                             );
 551                         } else {
 552                             $pwcheck = new \Galette\Util\Password($this);
 553                             $pwcheck->addPersonalInformation(['pref_admin_login' => $this->pref_admin_login]);
 554                             if (!$pwcheck->isValid($value)) {
 555                                 $this->errors = array_merge(
 556                                     $this->errors,
 557                                     $pwcheck->getErrors()
 558                                 );
 559                             }
 560                         }
 561                         break;
 562                     case 'pref_membership_ext':
 563                         if (!is_numeric($value) || $value < 0) {
 564                             $this->errors[] = _T("- Invalid number of months of membership extension.");
 565                         }
 566                         break;
 567                     case 'pref_beg_membership':
 568                         $beg_membership = explode("/", $value);
 569                         if (count($beg_membership) != 2) {
 570                             $this->errors[] = _T("- Invalid format of beginning of membership.");
 571                         } else {
 572                             $now = getdate();
 573                             if (!checkdate($beg_membership[1], $beg_membership[0], $now['year'])) {
 574                                 $this->errors[] = _T("- Invalid date for beginning of membership.");
 575                             }
 576                         }
 577                         break;
 578                     case 'pref_membership_offermonths':
 579                         if (!is_numeric($value) || $value < 0) {
 580                             $this->errors[] = _T("- Invalid number of offered months.");
 581                         }
 582                         break;
 583                     case 'pref_card_year':
 584                         if ($value !== 'DEADLINE' && !preg_match('/^(?:\d{4}|\d{2})(\D?)(?:\d{4}|\d{2})$/', $value)) {
 585                             $this->errors[] = _T("- Invalid year for cards.");
 586                         }
 587                         break;
 588                 }
 589             }
 590
 591             $insert_values[$fieldname] = $value;
 592         }
 593
 594         // missing relations
 595         if (
 596             GALETTE_MODE !== 'DEMO'
 597             && isset($insert_values['pref_mail_method'])
 598         ) {
 599             if ($insert_values['pref_mail_method'] > GaletteMail::METHOD_DISABLED) {
 600                 if (
 601                     !isset($insert_values['pref_email_nom'])
 602                     || $insert_values['pref_email_nom'] == ''
 603                 ) {
 604                     $this->errors[] = _T("- You must indicate a sender name for emails!");
 605                 }
 606                 if (
 607                     !isset($insert_values['pref_email'])
 608                     || $insert_values['pref_email'] == ''
 609                 ) {
 610                     $this->errors[] = _T("- You must indicate an email address Galette should use to send emails!");
 611                 }
 612                 if ($insert_values['pref_mail_method'] == GaletteMail::METHOD_SMTP) {
 613                     if (
 614                         !isset($insert_values['pref_mail_smtp_host'])
 615                         || $insert_values['pref_mail_smtp_host'] == ''
 616                     ) {
 617                         $this->errors[] = _T("- You must indicate the SMTP server you want to use!");
 618                     }
 619                 }
 620                 if (
 621                     $insert_values['pref_mail_method'] == GaletteMail::METHOD_GMAIL
 622                     || ($insert_values['pref_mail_method'] == GaletteMail::METHOD_SMTP
 623                     && $insert_values['pref_mail_smtp_auth'])
 624                 ) {
 625                     if (
 626                         !isset($insert_values['pref_mail_smtp_user'])
 627                         || trim($insert_values['pref_mail_smtp_user']) == ''
 628                     ) {
 629                         $this->errors[] = _T("- You must provide a login for SMTP authentication.");
 630                     }
 631                     if (
 632                         !isset($insert_values['pref_mail_smtp_password'])
 633                         || ($insert_values['pref_mail_smtp_password']) == ''
 634                     ) {
 635                         $this->errors[] = _T("- You must provide a password for SMTP authentication.");
 636                     }
 637                 }
 638             }
 639         }
 640
 641         if (
 642             isset($insert_values['pref_beg_membership'])
 643             && $insert_values['pref_beg_membership'] != ''
 644             && isset($insert_values['pref_membership_ext'])
 645             && $insert_values['pref_membership_ext'] != ''
 646         ) {
 647             $this->errors[] = _T("- Default membership extention and beginning of membership are mutually exclusive.");
 648         }
 649
 650         if (
 651             isset($insert_values['pref_membership_offermonths'])
 652             && (int)$insert_values['pref_membership_offermonths'] > 0
 653             && isset($insert_values['pref_membership_ext'])
 654             && $insert_values['pref_membership_ext'] != ''
 655         ) {
 656             $this->errors[] = _T("- Offering months is only compatible with beginning of membership.");
 657         }
 658
 659         // missing required fields?
 660         foreach ($this->required as $val) {
 661             if (!isset($values[$val]) || isset($values[$val]) && trim($values[$val]) == '') {
 662                 $this->errors[] = str_replace(
 663                     '%field',
 664                     $val,
 665                     _T("- Mandatory field %field empty.")
 666                 );
 667             }
 668         }
 669
 670         if (GALETTE_MODE !== 'DEMO' && isset($values['pref_admin_pass_check'])) {
 671             // Check passwords. Hash will be done into the Preferences class
 672             if (strcmp($insert_values['pref_admin_pass'], $values['pref_admin_pass_check']) != 0) {
 673                 $this->errors[] = _T("Passwords mismatch");
 674             }
 675         }
 676
 677         //postal address
 678         if (isset($insert_values['pref_postal_adress'])) {
 679             $value = $insert_values['pref_postal_adress'];
 680             if ($value == Preferences::POSTAL_ADDRESS_FROM_PREFS) {
 681                 if (isset($insert_values['pref_postal_staff_member'])) {
 682                     unset($insert_values['pref_postal_staff_member']);
 683                 }
 684             } elseif ($value == Preferences::POSTAL_ADDRESS_FROM_STAFF) {
 685                 if (!isset($value) || $value < 1) {
 686                     $this->errors[] = _T("You have to select a staff member");
 687                 }
 688             }
 689         }
 690
 691         // update preferences
 692         foreach ($insert_values as $champ => $valeur) {
 693             if (
 694                 $login->isSuperAdmin()
 695                 || (!$login->isSuperAdmin()
 696                 && ($champ != 'pref_admin_pass' && $champ != 'pref_admin_login'))
 697             ) {
 698                 if (
 699                     ($champ == "pref_admin_pass" && $_POST['pref_admin_pass'] != '')
 700                     || ($champ != "pref_admin_pass")
 701                 ) {
 702                     $this->$champ = $valeur;
 703                 }
 704             }
 705         }
 706
 707         return 0 === count($this->errors);
 708     }
 709
 710     /**
 711      * Will store all preferences in the database
 712      *
 713      * @return boolean
 714      */
 715     public function store()
 716     {
 717         try {
 718             $this->zdb->connection->beginTransaction();
 719             $update = $this->zdb->update(self::TABLE);
 720             $update->set(
 721                 array(
 722                     'val_pref'  => ':val_pref'
 723                 )
 724             )->where->equalTo('nom_pref', ':nom_pref');
 725
 726             $stmt = $this->zdb->sql->prepareStatementForSqlObject($update);
 727
 728             foreach (self::$defaults as $k => $v) {
 729                 if (
 730                     GALETTE_MODE == 'DEMO'
 731                     && in_array($k, ['pref_admin_pass', 'pref_admin_login', 'pref_mail_method'])
 732                 ) {
 733                     continue;
 734                 }
 735                 Analog::log('Storing ' . $k, Analog::DEBUG);
 736
 737                 $value = $this->prefs[$k];
 738                 //do not store pdf_adhesion_form, it's designed to be overriden by plugin
 739                 if ($k === 'pref_adhesion_form') {
 740                     if (trim($v) == '') {
 741                         //Reset to default, should not be empty
 742                         $v = self::$defaults['pref_adhesion_form'];
 743                     }
 744                     $value = $v;
 745                 }
 746
 747                 $stmt->execute(
 748                     array(
 749                         'val_pref'  => $value,
 750                         'where1'    => $k
 751                     )
 752                 );
 753             }
 754             $this->zdb->connection->commit();
 755             Analog::log(
 756                 'Preferences were successfully stored into database.',
 757                 Analog::INFO
 758             );
 759             return true;
 760         } catch (\Exception $e) {
 761             $this->zdb->connection->rollBack();
 762
 763             $messages = array();
 764             do {
 765                 $messages[] = $e->getMessage();
 766             } while ($e = $e->getPrevious());
 767
 768             Analog::log(
 769                 'Unable to store preferences | ' . print_r($messages, true),
 770                 Analog::WARNING
 771             );
 772             return false;
 773         }
 774     }
 775
 776     /**
 777      * Returns postal address
 778      *
 779      * @return string postal address
 780      */
 781     public function getPostalAddress()
 782     {
 783         $regs = array(
 784             '/%name/',
 785             '/%complement/',
 786             '/%address/',
 787             '/%zip/',
 788             '/%town/',
 789             '/%country/',
 790         );
 791
 792         $replacements = null;
 793
 794         if ($this->prefs['pref_postal_adress'] == self::POSTAL_ADDRESS_FROM_PREFS) {
 795             $_address = $this->prefs['pref_adresse'];
 796             if ($this->prefs['pref_adresse2'] && $this->prefs['pref_adresse2'] != '') {
 797                 $_address .= "\n" . $this->prefs['pref_adresse2'];
 798             }
 799             $replacements = array(
 800                 $this->prefs['pref_nom'],
 801                 "\n",
 802                 $_address,
 803                 $this->prefs['pref_cp'],
 804                 $this->prefs['pref_ville'],
 805                 $this->prefs['pref_pays']
 806             );
 807         } else {
 808             //get selected staff member address
 809             $adh = new Adherent($this->zdb, (int)$this->prefs['pref_postal_staff_member']);
 810             $_complement = preg_replace(
 811                 array('/%name/', '/%status/'),
 812                 array($this->prefs['pref_nom'], $adh->sstatus),
 813                 _T("%name association's %status")
 814             ) . "\n";
 815             $_address = $adh->address;
 816             if ($adh->address_continuation && $adh->address_continuation != '') {
 817                 $_address .= "\n" . $adh->address_continuation;
 818             }
 819             $replacements = array(
 820                 $adh->sfullname . "\n",
 821                 $_complement,
 822                 $_address,
 823                 $adh->zipcode,
 824                 $adh->town,
 825                 $adh->country
 826             );
 827         }
 828
 829         /*FIXME: i18n fails :/ */
 830         /*$r = preg_replace(
 831             $regs,
 832             $replacements,
 833             _T("%name\n%complement\n%address\n%zip %town - %country")
 834         );*/
 835         $r = preg_replace(
 836             $regs,
 837             $replacements,
 838             "%name%complement%address\n%zip %town - %country"
 839         );
 840         return $r;
 841     }
 842
 843     /**
 844      * Are public pages visibles?
 845      *
 846      * @param Authentication $login Authenticaqtion instance
 847      *
 848      * @return boolean
 849      */
 850     public function showPublicPages(Authentication $login)
 851     {
 852         if ($this->prefs['pref_bool_publicpages']) {
 853             //if public pages are actives, let's check if we
 854             //display them for curent call
 855             switch ($this->prefs['pref_publicpages_visibility']) {
 856                 case self::PUBLIC_PAGES_VISIBILITY_PUBLIC:
 857                     //pages are publically visibles
 858                     return true;
 859                     break;
 860                 case self::PUBLIC_PAGES_VISIBILITY_RESTRICTED:
 861                     //pages should be displayed only for up to date members
 862                     if (
 863                         $login->isUp2Date()
 864                         || $login->isAdmin()
 865                         || $login->isStaff()
 866                     ) {
 867                         return true;
 868                     } else {
 869                         return false;
 870                     }
 871                     break;
 872                 case self::PUBLIC_PAGES_VISIBILITY_PRIVATE:
 873                     //pages should be displayed only for staff and admins
 874                     if ($login->isAdmin() || $login->isStaff()) {
 875                         return true;
 876                     } else {
 877                         return false;
 878                     }
 879                     break;
 880                 default:
 881                     //should never be there
 882                     return false;
 883                     break;
 884             }
 885         } else {
 886             return false;
 887         }
 888     }
 889
 890     /**
 891      * Global getter method
 892      *
 893      * @param string $name name of the property we want to retrive
 894      *
 895      * @return false|object the called property
 896      */
 897     public function __get($name)
 898     {
 899         $forbidden = array('defaults');
 900         $virtuals = array('vpref_email_newadh');
 901
 902         if (!in_array($name, $forbidden) && isset($this->prefs[$name])) {
 903             if (
 904                 GALETTE_MODE === 'DEMO'
 905                 && $name == 'pref_mail_method'
 906             ) {
 907                 return GaletteMail::METHOD_DISABLED;
 908             } else {
 909                 if ($name == 'pref_adhesion_form' && $this->prefs[$name] == '') {
 910                     $this->prefs[$name] = self::$defaults['pref_adhesion_form'];
 911                 }
 912                 $value = $this->prefs[$name];
 913                 if (TYPE_DB === \Galette\Core\Db::PGSQL) {
 914                     if ($value === 'f') {
 915                         $value = false;
 916                     }
 917                 }
 918
 919                 if (in_array($name, ['pref_email_newadh'])) {
 920                     $values = explode(',', $value);
 921                     $value = $values[0]; //take first as default
 922                 }
 923
 924                 return $value;
 925             }
 926         } elseif (in_array($name, $virtuals)) {
 927             $virtual = str_replace('vpref_', 'pref_', $name);
 928             return explode(',', $this->prefs[$virtual]);
 929         } else {
 930             Analog::log(
 931                 'Preference `' . $name . '` is not set or is forbidden',
 932                 Analog::INFO
 933             );
 934             return false;
 935         }
 936     }
 937
 938     /**
 939      * Get default preferences
 940      *
 941      * @return array
 942      */
 943     public function getDefaults()
 944     {
 945         return self::$defaults;
 946     }
 947
 948     /**
 949      * Global setter method
 950      *
 951      * @param string $name  name of the property we want to assign a value to
 952      * @param object $value a relevant value for the property
 953      *
 954      * @return void
 955      */
 956     public function __set($name, $value)
 957     {
 958         //does this pref exists ?
 959         if (!array_key_exists($name, self::$defaults)) {
 960             Analog::log(
 961                 'Trying to set a preference value which does not seem to exist ('
 962                 . $name . ')',
 963                 Analog::WARNING
 964             );
 965             return false;
 966         }
 967
 968         if (
 969             $name == 'pref_email'
 970             || $name == 'pref_email_newadh'
 971             || $name == 'pref_email_reply_to'
 972         ) {
 973             if (GALETTE_MODE === 'DEMO') {
 974                 Analog::log(
 975                     'Trying to set pref_email while in DEMO.',
 976                     Analog::WARNING
 977                 );
 978                 return;
 979             }
 980
 981             //check emails validity
 982             //may be a comma separated list of valid emails identifiers:
 983             //"The Name <mail@domain.com>,The Other <other@mail.com>" expect for reply_to.
 984             $addresses = [];
 985             if (trim($value) != '') {
 986                 if ($name == 'pref_email_newadh') {
 987                     $addresses = explode(',', $value);
 988                 } else {
 989                     $addresses = [$value];
 990                 }
 991             }
 992             foreach ($addresses as $address) {
 993                 if (!GaletteMail::isValidEmail($address)) {
 994                     $msg = str_replace('%s', $address, _T("Invalid E-Mail address: %s"));
 995                     Analog::log($msg, Analog::WARNING);
 996                     $this->errors[] = $msg;
 997                 }
 998             }
 999         }
1000
1001         //some values need to be changed (eg. passwords)
1002         if ($name == 'pref_admin_pass') {
1003             $value = password_hash($value, PASSWORD_BCRYPT);
1004         }
1005
1006         //okay, let's update value
1007         $this->prefs[$name] = $value;
1008     }
1009
1010     /**
1011      * Get instance URL from configuration (if set) or guessed if not
1012      *
1013      * @return string
1014      */
1015     public function getURL()
1016     {
1017         $url = null;
1018         if (isset($this->prefs['pref_galette_url']) && !empty($this->prefs['pref_galette_url'])) {
1019             $url = $this->prefs['pref_galette_url'];
1020         } else {
1021             $url = $this->getDefaultURL();
1022         }
1023         return $url;
1024     }
1025
1026     /**
1027      * Get default URL (when not setted by user in preferences)
1028      *
1029      * @return string
1030      */
1031     public function getDefaultURL()
1032     {
1033         $scheme = (isset($_SERVER['HTTPS']) ? 'https' : 'http');
1034         $uri = $scheme . '://' . $_SERVER['HTTP_HOST'];
1035         return $uri;
1036     }
1037
1038     /**
1039      * Check member cards sizes
1040      * Always a A4/portrait
1041      *
1042      * @return array
1043      */
1044     public function checkCardsSizes()
1045     {
1046         $warning_detected = [];
1047         //check page width
1048         $max = 210;
1049         //margins
1050         $size = $this->pref_card_marges_h * 2;
1051         //cards
1052         $size += PdfMembersCards::getWidth() * PdfMembersCards::getCols();
1053         //spacing
1054         $size += $this->pref_card_hspace * (PdfMembersCards::getCols() - 1);
1055         if ($size > $max) {
1056             $warning_detected[] = _T('Current cards configuration may exceed page width!');
1057         }
1058
1059         $max = 297;
1060         //margins
1061         $size = $this->pref_card_marges_v * 2;
1062         //cards
1063         $size += PdfMembersCards::getHeight() * PdfMembersCards::getRows();
1064         //spacing
1065         $size += $this->pref_card_vspace * (PdfMembersCards::getRows() - 1);
1066         if ($size > $max) {
1067             $warning_detected[] = _T('Current cards configuration may exceed page height!');
1068         }
1069
1070         return $warning_detected;
1071     }
1072
1073     /**
1074      * Get errors
1075      *
1076      * @return array
1077      */
1078     public function getErrors()
1079     {
1080         return $this->errors;
1081     }
1082 }