HnrAzevedo\Datamanager\DataTrait

Complexity

Total Complexity

21

Size/Duplication

Total Lines	109
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	mountRemove()	0	16	4
A	mountWhereExec()	0	23	5
A	mountSave()	0	11	4
A	mountOffset()	0	4	2
A	mountLimit()	0	4	2
A	mountSelect()	0	5	1
A	mountBetweenExec()	0	14	3

<?php

namespace HnrAzevedo\Datamanager;

trait DataTrait{
    use CrudTrait, CheckTrait;

    protected ?string $table = null;
    protected ?string $primary = null;
    protected array $data = [];
    protected bool $full = false;

    protected array $result = [];
    protected ?string $clause = null;

    protected ?string $order = null;
    protected ?string $limit = null;
    protected ?int $offset = null;
    protected array $excepts = [];
    protected int $count = 0;
    protected array $select = [];
    protected ?string $query = null;

    protected function mountRemove(): array
    {
        $return = ['data' => '', 'where' => ''];
        foreach($this->where as $clause => $condition){
            if(strlen($clause) === 0){
                $return['where'] .= " {$clause} {$condition[0]} {$condition[1]} :q_{$condition[0]} ";
                $return['data'] .= "q_{$condition[0]}={$condition[2]}&";
                continue;
            }
                
            foreach($condition as $value){
                $return['where'] .= " {$clause} {$value[0]} {$value[1]} :q_{$value[0]} ";
                $return['data'] .= "q_{$value[0]}={$value[2]}&";
            }
        }
        return $return;
    }   

    protected function mountSave(): array
    {
        $return = ['data' => []];

        foreach ($this->data as $key => $value) {
            if($this->upgradeable($key) && !$this->isIncremented($key)){
                $return['data'][$key] = $this->data[$key]['value'];
            }
        }

        return $return;
    }

    protected function mountWhereExec(): array
    {
        $return = ['where' => '', 'data' => []];

        foreach ($this->where as $key => $value) {

            $key = (!$key) ? '' : " {$key} ";

            if(is_array($value[0])){

                foreach ($value as $k => $v) {
                    $return['where'] .= " {$key} {$v[0]} {$v[1]} :q_{$v[0]} ";
                    $return['data']["q_{$v[0]}"] = $v[2];
                }

                continue;
            }
             
            $return['where'] .= " {$key} {$value[0]} {$value[1]} :q_{$value[0]} ";
            $return['data']["q_{$value[0]}"] = $value[2];

        }
        return $return;
    }

    protected function mountBetweenExec(): array
    {
        $return = ['where' => '', 'data' => []];

        foreach($this->between as $field => $value){
            $condition = (count(explode(' ',$field)) > 2) ? ' '.explode(' ',$field)[0].' ' : ' AND ';
            $field = str_replace(['AND','OR',' '],'',$field);
            $return['where'] .= " {$condition} {$field} BETWEEN :q_1{$field} AND :q_2{$field} ";
            $return['data'] = [
                "q_1{$field}" => (date_format( date_create_from_format(DATAMANAGER_CONFIG['dateformat'],$value[0]) , 'Y-m-d')),
                "q_2{$field}" => (date_format( date_create_from_format(DATAMANAGER_CONFIG['dateformat'],$value[1]) , 'Y-m-d'))
            ];
        }
        return $return;
    }

    protected function mountSelect()
    {
        $select = implode(',',array_keys($this->select));

        $this->query = str_replace('*', $select,$this->query);
    }

    protected function mountLimit()
    {
        if(!is_null($this->limit)){
            $this->query .= " LIMIT {$this->limit}";
        }
    }

    protected function mountOffset()
    {
        if(!is_null($this->offset)){
            $this->query .= " OFFSET {$this->offset}";
        }
    }

}