DbStatement::valueMixed() - Code Metrics - osCommerce/oscommerce2 - Measure and Improve Code Quality continuously with Scrutinizer

DbStatement::valueMixed() B
last analyzed 2016-11-24 16:48 UTC

↳ Parent: DbStatement

Complexity

Conditions	6
Paths	10

Size

Total Lines	24
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	6
eloc	16
nc	10
nop	2
dl	0
loc	24
rs	8.5125
c	0
b	0
f	0

<?php
/**
  * osCommerce Online Merchant
  *
  * @copyright (c) 2016 osCommerce; https://www.oscommerce.com
  * @license MIT; https://www.oscommerce.com/license/mit.txt
  */

namespace OSC\OM;

use OSC\OM\Cache;
use OSC\OM\Db;
use OSC\OM\HTML;
use OSC\OM\Language;
use OSC\OM\OSCOM;
use OSC\OM\Registry;

class DbStatement extends \PDOStatement
{
    protected $pdo;
    protected $is_error = false;
    protected $page_set_keyword = 'page';
    protected $page_set;
    protected $page_set_results_per_page;
    protected $cache;
    protected $cache_expire;
    protected $cache_data;
    protected $cache_read = false;
    protected $cache_empty_results = false;
    protected $query_call;

    public function bindValue($parameter, $value, $data_type = \PDO::PARAM_STR)
    {
        return parent::bindValue($parameter, $value, $data_type);
    }

    public function bindInt($parameter, $value)
    {
// force type to int (see http://bugs.php.net/bug.php?id=44639)
        return $this->bindValue($parameter, (int)$value, \PDO::PARAM_INT);
    }

    public function bindBool($parameter, $value)
    {
// force type to bool (see http://bugs.php.net/bug.php?id=44639)
        return $this->bindValue($parameter, (bool)$value, \PDO::PARAM_BOOL);
    }

    public function bindDecimal($parameter, $value) {
        return $this->bindValue($parameter, (float)$value); // there is no \PDO::PARAM_FLOAT
    }

    public function bindNull($parameter)
    {
        return $this->bindValue($parameter, null, \PDO::PARAM_NULL);
    }

    public function setPageSet($max_results, $page_set_keyword = null, $placeholder_offset = 'page_set_offset', $placeholder_max_results = 'page_set_max_results')
    {
        if (!empty($page_set_keyword)) {
            $this->page_set_keyword = $page_set_keyword;
        }

        $this->page_set = (isset($_GET[$this->page_set_keyword]) && is_numeric($_GET[$this->page_set_keyword]) && ($_GET[$this->page_set_keyword] > 0)) ? $_GET[$this->page_set_keyword] : 1;
        $this->page_set_results_per_page = $max_results;

        $offset = max(($this->page_set * $max_results) - $max_results, 0);

        $this->bindInt(':' . $placeholder_offset, $offset);
        $this->bindInt(':' . $placeholder_max_results, $max_results);
    }

    public function execute($input_parameters = null)
    {
        if (isset($this->cache)) {
            if (isset($this->page_set)) {
                $this->cache->setKey($this->cache->getKey() . '-pageset' . $this->page_set);
            }

            if ($this->cache->exists($this->cache_expire)) {
                $this->cache_data = $this->cache->get();

                if (isset($this->cache_data['data']) && isset($this->cache_data['total'])) {
                    $this->page_set_total_rows = $this->cache_data['total'];

                    $this->cache_data = $this->cache_data['data'];
                }

                $this->cache_read = true;
            }
        }

        if ($this->cache_read === false) {
            if (empty($input_parameters)) {
                $input_parameters = null;
            }

            $this->is_error = !parent::execute($input_parameters);

            if ($this->is_error === true) {
                trigger_error($this->queryString);
            }

            if (strpos($this->queryString, ' SQL_CALC_FOUND_ROWS ') !== false) {
                $this->page_set_total_rows = $this->pdo->query('select found_rows()')->fetchColumn();

            } elseif (isset($this->page_set)) {
                trigger_error('OSC\OM\DbStatement::execute(): Page Set query does not contain SQL_CALC_FOUND_ROWS. Please add it to the query: ' . $this->queryString);
            }
        }
    }

    public function fetch(
        $fetch_style = \PDO::FETCH_ASSOC,
        $cursor_orientation = \PDO::FETCH_ORI_NEXT,
        $cursor_offset = 0
    ) {
        if ($this->cache_read === true) {
            list(, $this->result) = each($this->cache_data);

        } else {
            $this->result = parent::fetch($fetch_style, $cursor_orientation, $cursor_offset);


            if (isset($this->cache) && ($this->result !== false)) {

                if (!isset($this->cache_data)) {
                    $this->cache_data = [];
                }

                $this->cache_data[] = $this->result;

            }
        }

        return $this->result;

    }

    public function fetchAll($fetch_style = \PDO::FETCH_ASSOC, $fetch_argument = null, $ctor_args = [])
    {
        if ($this->cache_read === true) {
            $this->result = $this->cache_data;

        } else {
// fetchAll() fails if second argument is passed in a fetch style that does not
// use the optional argument
            if (in_array($fetch_style, array(\PDO::FETCH_COLUMN, \PDO::FETCH_CLASS, \PDO::FETCH_FUNC))) {
                $this->result = parent::fetchAll($fetch_style, $fetch_argument, $ctor_args);

            } else {
                $this->result = parent::fetchAll($fetch_style);

            }

            if (isset($this->cache) && ($this->result !== false)) {

                $this->cache_data = $this->result;

            }
        }

        return $this->result;

    }

    public function check()
    {
        if (!isset($this->result)) {
            $this->fetch();
        }

        return $this->result !== false;

    }

    public function toArray()
    {
        if (!isset($this->result)) {
            $this->fetch();
        }

        return $this->result;

    }

    public function setCache($key, $expire = null, $cache_empty_results = false)
    {
        if (!is_numeric($expire)) {
            $expire = 0;
        }

        if (!is_bool($cache_empty_results)) {
            $cache_empty_results = false;
        }

        $this->cache = new Cache($key);
        $this->cache_expire = $expire;
        $this->cache_empty_results = $cache_empty_results;

        if ($this->query_call != 'prepare') {
            trigger_error('OSC\\OM\\DbStatement::setCache(): Cannot set cache (\'' . $key . '\') on a non-prepare query. Please change the query to a prepare() query.');
        }
    }

    protected function valueMixed($column, $type = 'string')
    {
        if (!isset($this->result)) {
            $this->fetch();
        }

        switch ($type) {
            case 'protected':
                return HTML::outputProtected($this->result[$column]);

                break;
switch ($x) {
    case 1:
        return 'foo';
        break; // This break is not necessary and can be left off.
}

            case 'int':
                return (int)$this->result[$column];

                break;
switch ($x) {
    case 1:
        return 'foo';
        break; // This break is not necessary and can be left off.
}

            case 'decimal':
                return (float)$this->result[$column];

                break;
switch ($x) {
    case 1:
        return 'foo';
        break; // This break is not necessary and can be left off.
}

            case 'string':
            default:
                return $this->result[$column];

        }
    }

    public function value($column)
    {
        return $this->valueMixed($column, 'string');
    }

    public function valueProtected($column)
    {
        return $this->valueMixed($column, 'protected');
    }

    public function valueInt($column)
    {
        return $this->valueMixed($column, 'int');
    }

    public function valueDecimal($column)
    {
        return $this->valueMixed($column, 'decimal');
    }

    public function hasValue($column) {
        if (!isset($this->result)) {
            $this->fetch();
        }

        return isset($this->result[$column]);

    }

    public function isError()
    {
        return $this->is_error;
    }

    public function getQuery()
    {
        return $this->queryString;
    }

    public function setQueryCall($type)
    {
        $this->query_call = $type;
    }

    public function getQueryCall()
    {
        return $this->query_call;
    }

    public function getCurrentPageSet() {
        return $this->page_set;
    }

    public function getPageSetResultsPerPage()
    {
        return $this->page_set_results_per_page;
    }

    public function getPageSetTotalRows()
    {
        return $this->page_set_total_rows;

    }

    public function setPDO(\PDO $instance)
    {
        $this->pdo = $instance;
    }

    public function getPageSetLabel($text)
    {
        if ($this->page_set_total_rows < 1) {

            $from = 0;
        } else {
            $from = max(($this->page_set * $this->page_set_results_per_page) - $this->page_set_results_per_page, 1);
        }

        $to = min($this->page_set * $this->page_set_results_per_page, $this->page_set_total_rows);


        if ($to > $this->page_set_results_per_page) {
            $from++;
        }

        return '<span class="pagination">' . Language::parseDefinition($text, [
            'listing_from' => $from,
            'listing_to' => $to,
            'listing_total' => $this->page_set_total_rows

        ]) . '</span>';
    }

    public function getPageSetLinks($parameters = null)
    {
        global $PHP_SELF;

        $number_of_pages = ceil($this->page_set_total_rows / $this->page_set_results_per_page);


        if (empty($parameters)) {
            $parameters = '';
        }

        if (!empty($parameters)) {
            parse_str($parameters, $p);

            if (isset($p[$this->page_set_keyword])) {
                unset($p[$this->page_set_keyword]);
            }

            $parameters = !empty($p) ? http_build_query($p) . '&' : '';
        }

        $pages = [];

        for ($i = 1; $i <= $number_of_pages; $i++) {
            $pages[] = [
                'id' => $i,
                'text' => $i
            ];
        }

        $output = '<ul class="pagination">';

        if ($number_of_pages > 1) {

            $output .= '<li>' . HTML::selectField('pageset' . $this->page_set_keyword, $pages, $this->page_set, 'style="vertical-align: top; display: inline-block; float: left; width: 80px;" data-pageseturl="' . HTML::output(OSCOM::link($PHP_SELF, $parameters . $this->page_set_keyword . '=PAGESETGOTO')) . '"') . '</li>';
        } else {
            $output .= '<li class="disabled"><a class="text-center" style="width: 80px;">1</a></li>';
        }

// previous button
        if ($this->page_set > 1) {

            $output .= '<li><a href="' . OSCOM::link($PHP_SELF, $parameters . $this->page_set_keyword . '=' . ($this->page_set - 1)) . '" title="' . OSCOM::getDef('prevnext_title_previous_page') . '" class="text-center" style="width: 80px;"><span class="fa fa-fw fa-chevron-left"></span></a></li>';
        } else {
            $output .= '<li class="disabled"><a class="text-center" style="width: 80px;"><span class="fa fa-fw fa-chevron-left"></span></a></li>';
        }

// next button
        if (($this->page_set < $number_of_pages) && ($number_of_pages != 1)) {
            $output .= '<li><a href="' . OSCOM::link($PHP_SELF, $parameters . $this->page_set_keyword . '=' . ($this->page_set + 1)) . '" title="' . OSCOM::getDef('prevnext_title_next_page') . '" class="text-center" style="width: 80px;"><span class="fa fa-fw fa-chevron-right"></span></a></li>';
        } else {
            $output .= '<li class="disabled"><a class="text-center" style="width: 80px;"><span class="fa fa-fw fa-chevron-right"></span></a></li>';
        }

        $output .= '</ul>';

        if ($number_of_pages > 1) {
          $output .= <<<EOD
<script>
$(function() {
  $('select[name="pageset{$this->page_set_keyword}"]').on('change', function() {
    window.location = $(this).data('pageseturl').replace('PAGESETGOTO', $(this).children(':selected').val());
  });
});
</script>
EOD;
        }

        return $output;
    }

    public function __destruct()
    {
        if (($this->cache_read === false) && isset($this->cache) && is_array($this->cache_data)) {
            if ($this->cache_empty_results || (isset($this->cache_data[0]) && ($this->cache_data[0] !== false))) {
                $cache_data = $this->cache_data;

                if (isset($this->page_set_total_rows)) {
                    $cache_data = [
                        'data' => $cache_data,
                        'total' => $this->page_set_total_rows

                    ];
                }

                $this->cache->save($cache_data);
            }
        }
    }
}


1			<?php
2			/**
3			* osCommerce Online Merchant
4			*
5			* @copyright (c) 2016 osCommerce; https://www.oscommerce.com
6			* @license MIT; https://www.oscommerce.com/license/mit.txt
7			*/
8
9			namespace OSC\OM;
10
11			use OSC\OM\Cache;
12			use OSC\OM\Db;
13			use OSC\OM\HTML;
14			use OSC\OM\Language;
15			use OSC\OM\OSCOM;
16			use OSC\OM\Registry;
17
18			class DbStatement extends \PDOStatement
19			{
20			protected $pdo;
21			protected $is_error = false;
22			protected $page_set_keyword = 'page';
23			protected $page_set;
24			protected $page_set_results_per_page;
25			protected $cache;
26			protected $cache_expire;
27			protected $cache_data;
28			protected $cache_read = false;
29			protected $cache_empty_results = false;
30			protected $query_call;
31
32			public function bindValue($parameter, $value, $data_type = \PDO::PARAM_STR)
33			{
34			return parent::bindValue($parameter, $value, $data_type);
35			}
36
37			public function bindInt($parameter, $value)
38			{
39			// force type to int (see http://bugs.php.net/bug.php?id=44639)
40			return $this->bindValue($parameter, (int)$value, \PDO::PARAM_INT);

osCommerce / oscommerce2

DbStatement::valueMixed() B last analyzed 2016-11-24 16:48 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DbStatement::valueMixed() B
last analyzed 2016-11-24 16:48 UTC