Filter to ignore null fields

[JakeOcean]

I would love to add product_id => whereNotNull to recommendation_data_table_filter[] to exclude rows that have incomplete data - is there a way to do this?

[umutphp]

@JakeOcean Let me check and update you.

[JakeOcean]

maybe something like this?

if (is_array($config['recommendation_data_table_filter'])) {
                foreach ($config['recommendation_data_table_filter'] as $field => $value) {
                    if (is_array($value) && count($value) >= 1) {
                        $operator = strtoupper((string)$value[0]);
                        $filterValue = $value[1] ?? null;
                        
                        if ($operator === 'NULL') {
                            $data = $data->whereNull($field);
                        } elseif ($operator === 'NOT NULL') {
                            $data = $data->whereNotNull($field);
                        } elseif ($operator === 'IN') {
                            $data = $data->whereIn($field, $filterValue);
                        } elseif ($operator === 'NOT IN') {
                            $data = $data->whereNotIn($field, $filterValue);
                        } elseif (in_array($operator, ['=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE'])) {
                            $data = $data->where($field, $operator, $filterValue);
                        } else {
                            $data = $data->where($field, $value);
                        }
                    } else {
                        $data = $data->where($field, $value);
                    }
                }
            }

[umutphp]

@JakeOcean Yes, It looks reasonable. Can you please create a PR with your solution?

[JakeOcean]

@umutphp Created! #37