Base

Complexity

Total Complexity

31

Size/Duplication

Total Lines	210
Duplicated Lines	10 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes	6
Bugs	2	Features	0

16 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	get()	0	20	4
A	get_one()	0	4	1
A	add()	0	5	1
A	all()	5	15	4
A	get_item_comments_status()	0	17	3
A	update()	0	6	1
A	setYes()	8	8	2
A	setNo()	8	8	2
B	delete()	0	25	3
A	changeVotesAfterDelete()	0	8	2
A	setVoutesAfterDelete()	0	13	2
A	count_by_status()	0	6	1
A	get_settings()	0	6	1
A	save_settings()	0	4	1
A	get_many()	0	5	2

<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Base extends CI_Model
{

Opening brace of a class must be on the same line as the definition

    /**
     * @var array
     */
    public $comments_product_id = [];

    public function __construct() {
        parent::__construct();
    }

    /**
     * @param int $item_id
     * @param int $status
     * @param string $module
     * @param int $limit
     * @param string $order_by
     * @return bool|array
     */
    public function get($item_id, $status = 0, $module, $limit = 999999, $order_by) {

Parameters which have default values should be placed at the end.

        if ($this->db->table_exists('comments')) {

            $this->db->where('item_id', $item_id);
            $this->db->where('status', $status);
            $this->db->where('module', $module);

            $order_by = $order_by ?: 'date.desc';
            $order_column = array_shift(explode('.', $order_by));

explode('.', $order_by) cannot be passed to array_shift() as the parameter $array expects a reference.

            $order_way = array_pop(explode('.', $order_by));

explode('.', $order_by) cannot be passed to array_pop() as the parameter $array expects a reference.

            $this->db->order_by($order_column, $order_way);
            $query = $this->db->get('comments', $limit);

            if ($query->num_rows() > 0) {
                return $query->result_array();
            }
        }

        return FALSE;
    }

    public function get_one($id) {
        $this->db->limit(1);
        return $this->db->get_where('comments', ['id' => $id])->row_array();
    }

    public function add($data) {
        $this->db->insert('comments', $data);

        return $this->db->insert_id();
    }

    public function all($row_count, $offset) {
        $this->db->order_by('date', 'desc');

        if ($row_count > 0 AND $offset >= 0) {
            $query = $this->db->get('comments', $row_count, $offset);
        } else {
            $query = $this->db->get('comments');
        }

        if ($query->num_rows() > 0) {
            return $query->result_array();
        } else {
            return FALSE;
        }
    }

    public function get_item_comments_status($item_id) {
        $this->db->select('id, comments_status');
        $this->db->where('id', $item_id);
        $query = $this->db->get('content', 1);

        if ($query->num_rows() == 1) {
            $status = $query->row_array();

            if ($status['comments_status'] == 1) {

The if-else statement can be simplified to return $status['comments_status'] == 1;.

                return TRUE;
            } else {
                return FALSE;
            }
        } else {
            return FALSE;
        }
    }

    public function update($id, $data = []) {
        $this->db->where('id', $id);
        $this->db->update('comments', $data);

        return TRUE;
    }

    public function setYes($id) {
        $row = $this->db->where('id', $id)->get('comments')->row();
        $like = $row->like + 1;
        $data = ['like' => $like];
        $this->db->where('id', $id);
        $res = $this->db->update('comments', $data);
        return $res ? $like : false;
    }

    public function setNo($id) {
        $row = $this->db->where('id', $id)->get('comments')->row();
        $disslike = $row->disslike + 1;
        $data = ['disslike' => $disslike];
        $this->db->where('id', $id);
        $res = $this->db->update('comments', $data);
        return $res ? $disslike : false;
    }

    /**
     * @param int $id
     * @return bool
     */
    public function delete($id) {
        if (is_array($id)) {
            foreach ($id as $item) {
                $this->changeVotesAfterDelete($item);
            }

            $this->db->where_in('id', $id);
            $this->db->delete('comments');
            //delete child comments
            $this->db->where_in('parent', $id);
            $this->db->delete('comments');
        } else {
            $this->changeVotesAfterDelete($id);
            $this->db->limit(1);
            $this->db->where('id', $id);
            $this->db->delete('comments');
            //delete child comments
            $this->db->where('parent', $id);
            $this->db->delete('comments');
        }

        $this->setVoutesAfterDelete();

        return TRUE;
    }

    /**
     * @param int $id
     */
    public function changeVotesAfterDelete($id) {

            $comments = $this->db->get_where('comments', ['id' => (int) $id])->row_array();

        if (!in_array($comments['item_id'], $this->comments_product_id)) {
            $this->comments_product_id[] = $comments['item_id'];
        }
    }

    /**
     * @throws \Propel\Runtime\Exception\PropelException

Comment missing or not on the next line for @throws tag in function comment

     */
    public function setVoutesAfterDelete() {

        foreach ($this->comments_product_id as $item) {

                $count_result = count($this->db->get_where('comments', ['item_id' => (int) $item ])->result_array());

                $products = SProductsRatingQuery::create()
                    ->findOneByProductId($item);
                $products->setVotes($count_result);
                $products->save();

        }
    }

    /**
     * @param int $status
     * @return int
     */
    public function count_by_status($status = 0) {
        $this->db->where('status', $status);
        $this->db->from('comments');

        return $this->db->count_all_results();
    }

    /**
     * @return array
     */
    public function get_settings() {
        $this->db->where('name', 'comments');
        $query = $this->db->get('components')->row_array();

        return unserialize($query['settings']);
    }

    /**
     * @param array $data
     */
    public function save_settings($data) {
        $this->db->where('name', 'comments');
        $this->db->update('components', ['settings' => serialize($data)]);
    }

    /**
     * @param array $ids
     * @return mixed
     */
    public function get_many($ids) {
        if (is_array($ids)) {
            return $this->db->where_in('id', $ids)->get('comments')->row_array();
        }
    }

}

/* End of base.php */