Equals'; break; case 'ne': $options .= 'Not Equal'; break; case 'gt': $options .= 'Greater than'; break; case 'gte': $options .= 'Greater than or equal to'; break; case 'lt': $options .= 'Less than'; break; case 'lte': $options .= 'Less than or equal to'; break; case 'lk': $options .= 'Contains'; break; case 'in': $options .= 'IN (...)'; break; case 'nin': $options .= 'NOT IN (...)'; break; case 'bt': $options .= 'BETWEEN'; break; case 'nbt': $options .= 'NOT BETWEEN'; break; case 'n': $options .= 'IS BLANK'; break; case 'nn': $options .= 'IS NOT BLANK'; break; } } echo $options; } } } /*Query Filter*/ if (!function_exists('datatableFilterQuery')) { function datatableFilterQuery($query, $column, $operator, $input = null, $input_from = null, $input_to = null, $rawQuery = false) { if( isset($operator) && $operator != "" ){ switch ($operator) { case ">" : return $query->where( $column, $operator, $input); case ">=" : return $query->where( $column, $operator, $input); case "<" : return $query->where( $column, $operator, $input); case "<=" : return $query->where( $column, $operator, $input); case "=" : if ($rawQuery) { return $query->whereRaw($column. ' = "' . $input . '"'); } else { return $query->where( $column, $operator, $input); } case "!=" : if ($rawQuery) { return $query->whereRaw($column. ' != "' . $input . '"'); } else { return $query->where( $column, $operator, $input); } case "IN (...)" : $input = explode(',', $input); if ($rawQuery) { return $query->whereRaw($column. ' IN ("' .implode('","', $input). '")'); } else { return $query->whereIn($column, $input); } case "NOT IN (...)" : $input = explode(',', $input); if ($rawQuery) { return $query->whereRaw($column. ' NOT IN ("' .implode('","', $input). '")'); } else { return $query->whereNotIn($column, $input); } case "=''" : if ($rawQuery) { return $query->whereRaw($column. ' IS NULL '); } else { return $query->whereNull($column); } case "!=''" : if ($rawQuery) { return $query->whereRaw($column. ' IS NOT NULL '); } else { return $query->whereNotNull($column); } case "LIKE '%...%'" : if ($rawQuery) { return $query->whereRaw($column. ' like "%' . $input . '%"'); } else { return $query->where($column, 'like', "%" . $input . "%"); } case "BETWEEN" : $input = array($input_from, $input_to); return $query->whereBetween($column, $input); case "NOT BETWEEN" : $input = array($input_from, $input_to); return $query->whereNotBetween($column, $input); } } } }