Dolibarr\Code\Core\Classes\FormProjets::select_element()

Complexity

Conditions	35
Paths	17285

Size

Total Lines	144
Code Lines	108

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function select_element($table_element, $socid = 0, $morecss = '', $limitonstatus = -2, $projectkey = "fk_projet", $placeholder = '')
    {
		// phpcs:enable
        global $conf, $langs;

        if ($table_element == 'projet_task') {
            return ''; // Special cas of element we never link to a project (already always done)
        }

        $linkedtothirdparty = false;
        if (
            !in_array(
            $table_element,
            array(
                'don',
                'expensereport_det',
                'expensereport', 'loan',
                'stock_mouvement',
                'payment_salary',
                'payment_various',
                'salary',
                'chargesociales',
                'entrepot')
            )
        ) {
            $linkedtothirdparty = true;
        }

        $sqlfilter = '';

        //print $table_element;
        switch ($table_element) {
            case "loan":
                $sql = "SELECT t.rowid, t.label as ref";
                break;
            case "facture":
                $sql = "SELECT t.rowid, t.ref as ref";
                break;
            case "facture_fourn":
                $sql = "SELECT t.rowid, t.ref, t.ref_supplier";
                break;
            case "commande_fourn":
            case "commande_fournisseur":
                $sql = "SELECT t.rowid, t.ref, t.ref_supplier";
                break;
            case "facture_rec":
                $sql = "SELECT t.rowid, t.titre as ref";
                break;
            case "actioncomm":
                $sql = "SELECT t.id as rowid, t.label as ref";
                $projectkey = "fk_project";
                break;
            case "expensereport":
                return '';
            case "expensereport_det":
                /*$sql = "SELECT rowid, '' as ref"; // table is llx_expensereport_det
                $projectkey="fk_projet";
                break;*/
                return '';
            case "commande":
            case "contrat":
            case "fichinter":
                $sql = "SELECT t.rowid, t.ref";
                break;
            case 'stock_mouvement':
                $sql = "SELECT t.rowid, t.label as ref";
                $projectkey = 'fk_origin';
                break;
            case "payment_salary":
                $sql = "SELECT t.rowid, t.num_payment as ref"; // TODO In a future fill and use real ref field
                break;
            case "payment_various":
                $sql = "SELECT t.rowid, t.num_payment as ref";
                break;
            case "chargesociales":
            default:
                $sql = "SELECT t.rowid, t.ref";
                break;
        }
        if ($linkedtothirdparty) {
            $sql .= ", s.nom as name";
        }
        $sql .= " FROM " . $this->db->prefix() . $table_element . " as t";
        if ($linkedtothirdparty) {
            $sql .= ", " . $this->db->prefix() . "societe as s";
        }
        $sql .= " WHERE " . $projectkey . " is null";
        if (!empty($socid) && $linkedtothirdparty) {
            if (is_numeric($socid)) {
                $sql .= " AND t.fk_soc = " . ((int) $socid);
            } else {
                $sql .= " AND t.fk_soc IN (" . $this->db->sanitize($socid) . ")";
            }
        }
        if (!in_array($table_element, array('expensereport_det', 'stock_mouvement'))) {
            $sql .= ' AND t.entity IN (' . getEntity('project') . ')';
        }
        if ($linkedtothirdparty) {
            $sql .= " AND s.rowid = t.fk_soc";
        }
        if ($sqlfilter) {
            $sql .= " AND " . $sqlfilter;
        }
        $sql .= " ORDER BY ref DESC";

        dol_syslog(get_class($this) . '::select_element', LOG_DEBUG);
        $resql = $this->db->query($sql);
        if ($resql) {
            $num = $this->db->num_rows($resql);
            $i = 0;
            $sellist = '';

            if ($num > 0) {
                $sellist = '<select class="flat elementselect css' . $table_element . ($morecss ? ' ' . $morecss : '') . '" name="elementselect">';
                $sellist .= '<option value="-1"' . ($placeholder ? ' class="optiongrey"' : '') . '>' . $placeholder . '</option>';
                while ($i < $num) {
                    $obj = $this->db->fetch_object($resql);
                    $ref = $obj->ref ? $obj->ref : $obj->rowid;
                    if (!empty($obj->ref_supplier)) {
                        $ref .= ' (' . $obj->ref_supplier . ')';
                    }
                    if (!empty($obj->name)) {
                        $ref .= ' - ' . $obj->name;
                    }
                    $sellist .= '<option value="' . $obj->rowid . '">' . $ref . '</option>';
                    $i++;
                }
                $sellist .= '</select>';
            }
            /*else
            {
                $sellist = '<select class="flat" name="elementselect">';
                $sellist.= '<option value="0" disabled>'.$langs->trans("None").'</option>';
                $sellist.= '</select>';
            }*/
            $this->db->free($resql);

            return $sellist;
        } else {
            dol_print_error($this->db);
            $this->error = $this->db->lasterror();
            $this->errors[] = $this->db->lasterror();
            dol_syslog(get_class($this) . "::select_element " . $this->error, LOG_ERR);
            return -1;
        }