html.formsocialcontrib.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2012 Laurent Destailleur   <eldy@users.sourceforge.net>
 * Copyright (C) 2024   MDW           <mdeweerd@users.noreply.github.com>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */
 
class FormSocialContrib
{
  public $db;
 
  public $error = '';
 
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function select_type_socialcontrib($selected = 0, $htmlname = 'actioncode', $useempty = 0, $maxlen = 40, $help = 1, $morecss = 'minwidth300', $noerrorifempty = 0, $noout = 0)
  {
    // phpcs:enable
    global $conf, $langs, $user, $mysoc;
 
    if (empty($mysoc->country_id) && empty($mysoc->country_code)) {
      $out = $langs->trans("ErrorSetupOfCountryMustBeDone");
      if (empty($noout)) {
        print $out;
      }
      return $out;
    }
 
    if (!empty($mysoc->country_id)) {
      $sql = "SELECT c.id, c.libelle as type";
      $sql .= " FROM ".$this->db->prefix()."c_chargesociales as c";
      $sql .= " WHERE c.active = 1";
      $sql .= " AND c.fk_pays = ".((int) $mysoc->country_id);
      $sql .= " ORDER BY c.libelle ASC";
    } else {
      $sql = "SELECT c.id, c.libelle as type";
      $sql .= " FROM ".$this->db->prefix()."c_chargesociales as c, ".$this->db->prefix()."c_country as co";
      $sql .= " WHERE c.active = 1 AND c.fk_pays = co.rowid";
      $sql .= " AND co.code = '".$this->db->escape($mysoc->country_code)."'";
      $sql .= " ORDER BY c.libelle ASC";
    }
 
    dol_syslog("Form::select_type_socialcontrib", LOG_DEBUG);
 
    $out = '';
 
    $resql = $this->db->query($sql);
    if ($resql) {
      $num = $this->db->num_rows($resql);
      if ($num) {
        $out .= '<select class="'.($morecss ? $morecss : '').'" id="'.$htmlname.'" name="'.$htmlname.'">';
        $i = 0;
 
        if ($useempty) {
          $out .= '<option value="-1">';
          if (!is_numeric($useempty)) {
            $out .= $useempty;
          } else {
            $out .= '&nbsp;';
          }
          $out .= '</option>';
        }
        while ($i < $num) {
          $obj = $this->db->fetch_object($resql);
          $out .= '<option value="'.$obj->id.'"';
          if ($obj->id == $selected) {
            $out .= ' selected';
          }
          $out .= '>'.dol_trunc($obj->type, $maxlen);
          $i++;
        }
        $out .= '</select>';
        if ($user->admin && $help) {
          $out .= info_admin($langs->trans("YouCanChangeValuesForThisListFromDictionarySetup"), 1);
        }
        if (!empty($conf->use_javascript_ajax)) {
          $out .= ajax_combobox($htmlname);
        }
      } else {
        if (empty($noerrorifempty)) {
          $out .= $langs->trans("ErrorNoSocialContributionForSellerCountry", $mysoc->country_code);
        }
      }
    } else {
      dol_print_error($this->db);
    }
 
    if (empty($noout)) {
      print $out;
    }
 
    return $out;
  }
}