Method filters

models/db.php:80–195

* Filters helper. * @param array filters * [ array ('name' => $name, 'value' => $value, * 'operator' => '=', 'condition' => 'AND', 'type' = '' ) ] */

($filters)

     * 'operator' => '=', 'condition' => 'AND', 'type' = '' ) ]
     */
    private static function filters($filters){

        // Our goal is to output SQL and params.
        $output = array(
            'sql' => '',
            'params' => array()
        );
        
        // Let's start a count so we can tell when our
        // loop ends.
        $filter_count = count($filters);

        // We only need to prepare SQL if filters exist.
        if($filter_count > 0){
            
            // We start a loop to set up our filters.
            $output['sql'] = ' WHERE ';
            $filter_iteration = 0;
            foreach ($filters as $filter){

                // Filters without type have the standard 
                // markup
                if(empty($filter['type'])){

                    // The default condition 'AND'.
                    if(empty($filter['condition'])){
                        $condition = 'AND';

                    // You can use other conditions like 'OR'.
                    }else{
                        $condition = $filter['condition'];
                    }

                    // The default operator is '='.
                    if(empty($filter['operator'])){
                        $operator = '=';

                    // You can use other operators like 'IS'.
                    }else{
                        $operator = $filter['operator'];
                    }

                    // You can nest filters in filter values.
                    if(is_array($filter['value'])){

                        // Start the sub filter SQL.
                        $sub_filter_iteration = 0;
                        $sub_filter_count = count($filter['value']);
                        $output['sql'].= '(';

                        // We only support one sub filter.
                        foreach($filter['value'] as $sub_filter){

                            // Like we did before, let's build the
                            // sql and add to params.
                            if(empty($sub_filter['condition'])){
                                $sub_condition = 'AND';
                            }else{