html.formcontract.class.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2012-2018  Charlene BENKE  <charlie@patas-monkey.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/>.
 * or see https://www.gnu.org/
 */
 
class FormContract
{
  public $db;
 
  public $error = '';
 
 
  public function __construct($db)
  {
    $this->db = $db;
  }
 
 
  // phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
  public function select_contract($socid = -1, $selected = '', $htmlname = 'contrattid', $maxlength = 16, $showempty = 1, $showRef = 0, $noouput = 0, $morecss = 'minwidth150')
  {
    // phpcs:enable
    global $user, $conf, $langs;
 
    $hideunselectables = false;
    if (getDolGlobalString('CONTRACT_HIDE_UNSELECTABLES')) {
      $hideunselectables = true;
    }
 
    $ret = '';
 
    // Search all contacts
    $sql = "SELECT c.rowid, c.ref, c.fk_soc, c.statut,";
    $sql .= " c.ref_customer, c.ref_supplier";
    $sql .= " FROM ".$this->db->prefix()."contrat as c";
    $sql .= " WHERE c.entity = ".$conf->entity;
    //if ($contratListId) $sql.= " AND c.rowid IN (".$this->db->sanitize($contratListId).")";
    if ($socid > 0) {
      // CONTRACT_ALLOW_TO_LINK_FROM_OTHER_COMPANY is 'all' or a list of ids separated by coma.
      if (!getDolGlobalString('CONTRACT_ALLOW_TO_LINK_FROM_OTHER_COMPANY')) {
        $sql .= " AND (c.fk_soc=".((int) $socid)." OR c.fk_soc IS NULL)";
      } elseif (getDolGlobalString('CONTRACT_ALLOW_TO_LINK_FROM_OTHER_COMPANY') != 'all') {
        $sql .= " AND (c.fk_soc IN (".$this->db->sanitize(((int) $socid).",".((int) $conf->global->CONTRACT_ALLOW_TO_LINK_FROM_OTHER_COMPANY)).")";
        $sql .= " OR c.fk_soc IS NULL)";
      }
    }
    if ($socid == 0) {
      $sql .= " AND (c.fk_soc = 0 OR c.fk_soc IS NULL)";
    }
    $sql .= " ORDER BY c.ref ";
 
    dol_syslog(get_class($this)."::select_contract", LOG_DEBUG);
    $resql = $this->db->query($sql);
    if ($resql) {
      $ret .= '<select class="flat'.($morecss ? ' '.$morecss : '').'" name="'.$htmlname.'">';
      if ($showempty) {
        $ret .= '<option value="0">&nbsp;</option>';
      }
      $num = $this->db->num_rows($resql);
      $i = 0;
      if ($num) {
        while ($i < $num) {
          $obj = $this->db->fetch_object($resql);
          // If we ask to filter on a company and user has no permission to see all companies and project is linked to another company, we hide project.
          if ($socid > 0 && (empty($obj->fk_soc) || $obj->fk_soc == $socid) && !$user->hasRight('societe', 'lire')) {
            // Do nothing
          } else {
            $labeltoshow = dol_trunc($obj->ref, 18);
 
            if ($showRef) {
              if ($obj->ref_customer) {
                $labeltoshow = $labeltoshow." - ".$obj->ref_customer;
              }
              if ($obj->ref_supplier) {
                $labeltoshow = $labeltoshow." - ".$obj->ref_supplier;
              }
            }
 
            //if ($obj->public) $labeltoshow.=' ('.$langs->trans("SharedProject").')';
            //else $labeltoshow.=' ('.$langs->trans("Private").')';
            if (!empty($selected) && $selected == $obj->rowid && $obj->statut > 0) {
              $ret .= '<option value="'.$obj->rowid.'" selected>'.$labeltoshow.'</option>';
            } else {
              $disabled = 0;
              if ($obj->statut == 0) {
                $disabled = 1;
                $labeltoshow .= ' ('.$langs->trans("Draft").')';
              }
              if (!getDolGlobalString('CONTRACT_ALLOW_TO_LINK_FROM_OTHER_COMPANY') && $socid > 0 && (!empty($obj->fk_soc) && $obj->fk_soc != $socid)) {
                $disabled = 1;
                $labeltoshow .= ' - '.$langs->trans("LinkedToAnotherCompany");
              }
 
              if ($hideunselectables && $disabled) {
                $resultat = '';
              } else {
                $resultat = '<option value="'.$obj->rowid.'"';
                if ($disabled) {
                  $resultat .= ' disabled';
                }
                //if ($obj->public) $labeltoshow.=' ('.$langs->trans("Public").')';
                //else $labeltoshow.=' ('.$langs->trans("Private").')';
                $resultat .= '>'.$labeltoshow;
                $resultat .= '</option>';
              }
              $ret .= $resultat;
            }
          }
          $i++;
        }
      }
      $ret .= '</select>';
      $this->db->free($resql);
 
      if (!empty($conf->use_javascript_ajax)) {
        // Make select dynamic
        include_once DOL_DOCUMENT_ROOT.'/core/lib/ajax.lib.php';
        $ret .= ajax_combobox($htmlname);
      }
 
      if ($noouput) {
        return $ret;
      }
 
      print $ret;
 
      return $num;
    } else {
      dol_print_error($this->db);
      return -1;
    }
  }
 
  public function formSelectContract($page, $socid = -1, $selected = '', $htmlname = 'contrattid', $maxlength = 16, $showempty = 1, $showRef = 0, $noouput = 0)
  {
    global $langs;
 
    $ret = '<form method="post" action="'.$page.'">';
    $ret .= '<input type="hidden" name="action" value="setcontract">';
    $ret .= '<input type="hidden" name="token" value="'.newToken().'">';
    $ret .= $this->select_contract($socid, $selected, $htmlname, $maxlength, $showempty, $showRef, 1);
    $ret .= '<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans("Modify").'">';
    $ret .= '</form>';
 
    if ($noouput) {
      return $ret;
    }
 
    print $ret;
  }
}