show_array_actions_to_do()

Complexity

Conditions	25
Paths	1040

Size

Total Lines	108
Code Lines	73

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function show_array_actions_to_do($max = 5)
{
    global $langs, $conf, $user, $db, $socid;

    $now = dol_now();

    include_once DOL_DOCUMENT_ROOT . '/comm/action/class/actioncomm.class.php';

    $sql = "SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent";
    $sql .= ", c.code, c.libelle as type_label";
    $sql .= ", s.rowid as socid, s.nom as name, s.name_alias";
    $sql .= ", s.code_client, s.code_compta, s.client";
    $sql .= ", s.logo, s.email, s.entity";
    $sql .= " FROM " . MAIN_DB_PREFIX . "actioncomm as a LEFT JOIN ";
    $sql .= " " . MAIN_DB_PREFIX . "c_actioncomm as c ON c.id = a.fk_action";
    $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "societe as s ON a.fk_soc = s.rowid";
    if (!$user->hasRight('societe', 'client', 'voir')) {
        $sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
    }
    $sql .= " WHERE a.entity IN (" . getEntity('agenda') . ")";
    $sql .= " AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > '" . $db->idate($now) . "'))";
    if (!$user->hasRight('societe', 'client', 'voir')) {
        $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = " . ((int) $user->id);
    }
    if ($socid) {
        $sql .= " AND s.rowid = " . ((int) $socid);
    }
    $sql .= " ORDER BY a.datep DESC, a.id DESC";
    $sql .= $db->plimit($max, 0);

    $resql = $db->query($sql);
    if ($resql) {
        $num = $db->num_rows($resql);

        print '<div class="div-table-responsive-no-min">';
        print '<table class="noborder centpercent">';
        print '<tr class="liste_titre"><th colspan="2">' . $langs->trans("LastActionsToDo", $max) . '</th>';
        print '<th colspan="2" class="right"><a class="commonlink" href="' . constant('BASE_URL') . '/comm/action/list.php?mode=show_list&status=todo">' . $langs->trans("FullList") . '</a></th>';
        print '</tr>';

        $i = 0;

        $staticaction = new ActionComm($db);
        $customerstatic = new Client($db);

        while ($i < $num) {
            $obj = $db->fetch_object($resql);


            print '<tr class="oddeven">';

            $staticaction->type_code = $obj->code;
            $staticaction->label = ($obj->label ? $obj->label : $obj->type_label);
            $staticaction->id = $obj->id;
            print '<td>' . $staticaction->getNomUrl(1, 34) . '</td>';

            // print '<td>'.dol_trunc($obj->label,22).'</td>';

            print '<td>';
            if ($obj->socid > 0) {
                $customerstatic->id = $obj->socid;
                $customerstatic->name = $obj->name;
                //$customerstatic->name_alias = $obj->name_alias;
                $customerstatic->code_client = $obj->code_client;
                $customerstatic->code_compta = $obj->code_compta;

The property Dolibarr\Code\Societe\Classes\Societe::$code_compta has been deprecated: Use $code_compta_client

                $customerstatic->client = $obj->client;
                $customerstatic->logo = $obj->logo;
                $customerstatic->email = $obj->email;
                $customerstatic->entity = $obj->entity;
                print $customerstatic->getNomUrl(1, '', 40);
            }
            print '</td>';

            $datep = $db->jdate($obj->dp);
            $datep2 = $db->jdate($obj->dp2);

            // Date
            print '<td width="100" class="right tddate">' . dol_print_date($datep, 'day') . '&nbsp;';
            $late = 0;
            if ($obj->percent == 0 && $datep && $datep < time()) {
                $late = 1;
            }
            if ($obj->percent == 0 && !$datep && $datep2 && $datep2 < time()) {
                $late = 1;
            }
            if ($obj->percent > 0 && $obj->percent < 100 && $datep2 && $datep2 < time()) {
                $late = 1;
            }
            if ($obj->percent > 0 && $obj->percent < 100 && !$datep2 && $datep && $datep < time()) {
                $late = 1;
            }
            if ($late) {
                print img_warning($langs->trans("Late"));
            }
            print "</td>";

            // Statut
            print '<td class="right" width="14">' . $staticaction->LibStatut($obj->percent, 3) . "</td>\n";

            print "</tr>\n";

            $i++;
        }
        print "</table></div><br>";

        $db->free($resql);
    } else {
        dol_print_error($db);
    }