Dolibarr\Code\BloquedLog\Classes\BlockedLog::getLog()

Complexity

Conditions	15
Paths	2048

Size

Total Lines	75
Code Lines	42

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getLog($element, $fk_object, $limit = 0, $sortfield = '', $sortorder = '', $search_fk_user = -1, $search_start = -1, $search_end = -1, $search_ref = '', $search_amount = '', $search_code = '')
    {
        global $conf;
        //global $cachedlogs;

        /* $cachedlogs allow fastest search */
        //if (empty($cachedlogs)) $cachedlogs = array();

        if ($element == 'all') {
            $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "blockedlog
			 WHERE entity=" . $conf->entity;
        } elseif ($element == 'not_certified') {
            $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "blockedlog
			 WHERE entity=" . $conf->entity . " AND certified = 0";
        } elseif ($element == 'just_certified') {
            $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "blockedlog
			 WHERE entity=" . $conf->entity . " AND certified = 1";
        } else {
            $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "blockedlog
			 WHERE entity=" . $conf->entity . " AND element = '" . $this->db->escape($element) . "'";
        }

        if ($fk_object) {
            $sql .= natural_search("rowid", $fk_object, 1);
        }
        if ($search_fk_user > 0) {
            $sql .= natural_search("fk_user", $search_fk_user, 2);
        }
        if ($search_start > 0) {
            $sql .= " AND date_creation >= '" . $this->db->idate($search_start) . "'";
        }
        if ($search_end > 0) {
            $sql .= " AND date_creation <= '" . $this->db->idate($search_end) . "'";
        }
        if ($search_ref != '') {
            $sql .= natural_search("ref_object", $search_ref);
        }
        if ($search_amount != '') {
            $sql .= natural_search("amounts", $search_amount, 1);
        }
        if ($search_code != '' && $search_code != '-1') {
            $sql .= natural_search("action", $search_code, 3);
        }

        $sql .= $this->db->order($sortfield, $sortorder);
        $sql .= $this->db->plimit($limit + 1); // We want more, because we will stop into loop later with error if we reach max

        $res = $this->db->query($sql);
        if ($res) {
            $results = array();

            $i = 0;
            while ($obj = $this->db->fetch_object($res)) {
                $i++;
                if ($i > $limit) {
                    // Too many record, we will consume too much memory
                    return -2;
                }

                //if (!isset($cachedlogs[$obj->rowid]))
                //{
                $b = new BlockedLog($this->db);
                $b->fetch($obj->rowid);
                //$b->loadTrackedEvents();
                //$cachedlogs[$obj->rowid] = $b;
                //}

                //$results[] = $cachedlogs[$obj->rowid];
                $results[] = $b;
            }

            return $results;
        }

        return -1;
    }