<?php

namespace App\Helpers;

use Illuminate\Support\Facades\DB;

class StringHelper
{
    /**
     * Build a query based on the array that contains column names.
     *
     * @param  array  $array
     * @return string
     */
    public static function buildQuery(array $array, string $searchTerm)
    {
        $first = true;
        $queryString = '';
        $searchTerm = DB::connection()->getPdo()->quote('%'.$searchTerm.'%');

        foreach ($array as $column) {
            if ($first) {
                $first = false;
            } else {
                $queryString .= ' or ';
            }
            $queryString .= $column.' LIKE '.$searchTerm;
        }

        return $queryString;
    }
}