Dframe/Database SearchBuilderWhereChunk

SearchBuilderWhereChunk.php

<?php

class Search
{

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

    /**
     * Search constructor.
     *
     * @param $search
     */
    public function __construct($search)
    {
        $inArray = ['type'];
        foreach ($search as $key => $value) {
            if (in_array($key, $inArray)) {
                $this->build($key, $this->$key($value));
            }
        }

    }

    /**
     * @return array
     */
    public function getWhere()
    {

        $where = [];

        foreach ($this->search as $type => $params) {
            $sql = null;
            $arr = [];
            foreach ($params['value'] as $key => $condition) {
                $sql .= $params['column'] . ' ' . $condition['op'] . ' ? OR ';
                $arr[] = $condition['value'];
            }

            if (!empty($arr)) {
                $sql = rtrim($sql, ' OR ');
                $where[] = new WhereStringChunk($sql, $arr);
            }
        }

        return $where;
    }


    /**
     * @param $search
     *
     * @return array
     */
    protected function type($search)
    {
        $data = [
            'column' => 'type',
            'value' => []
        ];

        $values = ['a', 'b'];

        foreach ($search as $key => $value) {
            if (in_array($value, $values)) {
                $data['value'][] = ['op' => '=', 'value' => $value];
            }
        }

        return $data;
    }
}