Twill

that will be nice, I have one pdf upload from user in frontend and want to show them in the admin cms when editing the item

You can do something like this:

```php
$file = new \A17\Twill\Models\File([ you need to check this by yourself, which fields are required]);

$model = \App\Models\YourModel::find(1);

$model->files()->save($file);
```
Or more easier with Repository

```php
$record = app(YourModuleRepository::class)->find(1);
$record->files()->create([...]);
```

Or use `DB` facade and append everything manualy.

```php
$fileId = DB::table('files')->insertGetId([
    'uuid' => $uuid . '/' . $filename,
    'filename' => $filename,
    'size' => $size,
    'created_at' => Carbon::now()->format('Y-m-d H:i:s'),
    'updated_at' => Carbon::now()->format('Y-m-d H:i:s')
]);

//Insert to fileables table
DB::table('fileables')->insert([
    'fileable_id' => $id,
    'fileable_type' => 'App\Models\Warranty',
    'file_id' => $fileId,
    'role' => 'customer_proof',
    'locale' => app()->getLocale(),
    'created_at' => Carbon::now()->format('Y-m-d H:i:s'),
    'updated_at' => Carbon::now()->format('Y-m-d H:i:s')
]);
```

Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1364 Field 'locale' doesn't have a default value (SQL: insert into `fileables` (`created_at`, `file_id`, `fileable_id`, `fileable_type`, `updated_at`) values (2022-11-16 08:40:49, 1, 9, App\Models\ProfileOrder, 2022-11-16 08:40:49)) in file /vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 712

what I missed ? how can I send the 'locale' required there ?

You didnt append field `locale` with value in your query.
Laravel way to get current locale is `app()->getLocale()`

```
/**
     * Handle an incoming registration request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\RedirectResponse
     *
     * @throws \Illuminate\Validation\ValidationException
     */
    public function save(Request $request)
    {
        $request->validate([
            'order_created_date' => ['required', 'date'],
            'order_file' => ['required', 'mimes:pdf'],
        ]);

        $filename = $request->order_file->getClientOriginalName();

        $cleanFilename = preg_replace("/\s+/i", "-", $filename);

        $fileDirectory = "uploads";

        $uuid = "uploads" . '/' . $cleanFilename;

        $disk = Config()->get('twill.file_library.disk');

        $request->file('order_file')->storeAs($fileDirectory, $cleanFilename, $disk);

        $fields = [
            'uuid' => $uuid,
            'filename' => $cleanFilename,
            'size' => $request->file('order_file')->getSize()
        ];

        $profileOrder = ProfileOrder::create([
            'order_created_date' => $request->order_created_date,
            'published' => true,
            'profile_id' => Auth::user()->profile->id,
            'title' => "Encomenda " . $request->order_created_date
        ]);

        $file = new \A17\Twill\Models\File($fields);

        $profileOrder->files()->save($file);

        return redirect(RouteServiceProvider::HOME);
    }
```

```php
$profileOrder->files()->save($file, [
                              'locale' => app()->getLocale(), 
                              'role' => 'your_file_input_name_on_module_form'
                            ]);
```
This should work, but I'm not 100% sure. If this fails, you can backup to the Repository create.

its possible add function to obtain string in $indexColumns ? I want to get status from checking if value exists and what value have ...

Do these options are good for your usage? 

```php
        'relationName' => [ // relation column
            // Take a look at the example in the next section fot the implementation of the sort
            'title' => 'Relation name',
            'sort' => true,
            'relationship' => 'relationName',
            'field' => 'relationFieldToDisplay'
        ],
        'presenterMethodField' => [ // presenter column
            'title' => 'Field title',
            'field' => 'presenterMethod',
            'present' => true,
        ],
```

How can I use present ? 
I have this function to get my status inside the Model
public function status()
    {
        if ($this->order_verified_date == null) {
            return "Por verificar";
        }

        if ($this->order_production_date == null) {
            return "Aguardar produção";
        }
    }
How can I use that function inside indexColumn ?

You are on a good track. Just need to adjust model method name.

```php
public function getStatusAttribute()
{
        if ($this->order_verified_date == null) {
            return "Por verificar";
        }

        if ($this->order_production_date == null) {
            return "Aguardar produção";
        }
}
```

Make sure that you have a default return value if conditions above fail.


```
'status' => [ // presenter column
      'title' => 'Status',
      'field' => 'status',
],
```

<@951507936449024071> sorry this is the real thread.

Can anyone help me to fix the search functionality in Twill so that the search is case in-sensitive (I'm using Postgres, which is a bit more strict with upper/lower case where conditions). Is there a way to overwrite the search endpoint?

This is not for the global search, but the search for a specific Module.

you could override `cmsSearch` on your module repository

to your point about case sensitivity, Twill is aware of the difference between mysql and postgres

https://github.com/area17/twill/blob/41e617e92f829b43712bd71b898fd579639461e0/src/Repositories/ModuleRepository.php#L930

Any way to hook up Algolia/Scout to that search?

Is there an example or documentation for it?

Not specifically about that but it's really simple by overriding cmsSearch to call scout and return the structure that it currently returns

also, are you sure it's cmsSearch? That method is only called from the DashboardController and not from the Module page.

This is the Dashboard Search (global search?)

yeah my bad forgot you were talking about that one. This would happen in the filter method of your repository class. The value of the search input is provided in its parameters and from there you can call scout on the model instead of the simple DB "like" query it is doing by default.

So then this is also for the global search and not for the module search

but it doesn't seem to work. The query that is generated is: 

`select
  count(*) as aggregate
from
  "members"
where
  ("name" :: text LIKE '%test%')
  and "members"."deleted_at" is null`

when I add the filter method in the repository:

`public function filter(Builder $query, array $scopes = []): Builder
    {
        if ($filter = request()->get('filter')) {
            if ($search = data_get(json_decode($filter), 'search')) {
                return $query->where('name', 'ILIKE', sprintf('%%%s%%',
                    trim($search)
                ));
            }
        }

        return parent::filter($query, $scopes);
    }`

This generates:
`select
  count(*) as aggregate
from
  "members"
where
  "name" :: text ILIKE '%test%'
  and ("name" :: text LIKE '%test%')
  and "members"."deleted_at" is null`

Now how do I remove the second where condition `and ("name" :: text LIKE '%test%')` ?

you're manually dealing with that scope, so you need to remove it to avoid having twill deal with it. I don't get why you're getting LIKE by default though. What does `getLikeOperator` return?

I tried deleting the scope, same result. The scope is actually an empty array anyways.

that depends on what you're doing in your controller, it's not empty by default

I think it somehow going through  `FreeTextSearch extends TwillBaseFilter`

https://github.com/area17/twill/blob/1ba5b7a0698b5e96f3b532c047c1f53457effb90/src/Services/Listings/Filters/FreeTextSearch.php#L25 this should use `getLikeOperator` <@385142776674910238>

ok, added an issue https://github.com/area17/twill/issues/1922 so I can fix it

Fixed in https://github.com/area17/twill/pull/1928

is it possible to remove those links or change the request?

Hi <@247785559529881600>, on 2.x you can customize the filters by overriding these 2 methods in your module controller:

`getIndexTableMainFilters()` - https://github.com/area17/twill/blob/2.x/src/Http/Controllers/Admin/ModuleController.php#L1273
You can remove filters or add new filters here.

`filterScope()` - https://github.com/area17/twill/blob/2.x/src/Http/Controllers/Admin/ModuleController.php#L1447
This is only needed if you want to add a new filter.

In Twill 3.x: https://twill.io/docs/3.x/crud-modules/tables.html#filters

I think this is possible in the 3.x version, but Im not sure. cc <@385142776674910238>

this feels like i am missing something very obvious, but how do i redirect to the main page of a module?  my module is `dealers`, i tried to `redirect->route('dealers.show')`  but i get a Route not defined error

~~Try with `dealers.show.index` if you want index table (list)~~

Probably more likely to be `admin.dealers.index`

Also you can check all the routes with `artisan route:list` and there you can find all registered Twill module routes.

ahh excellent, thank you. building with Twill has been my first major Laravel project as well so there's a lot of those little things that i'm still learning

Hello, what are these good for?
```
@twillPropGroup('foo') @twillBlockGroup('foo')
@twillRepeaterGroup('foo')
```
In docs those are called with default string `'app'` but does it have any use? I failed to understand from the docs 🙏🏼

Hi <@423826082584723456> the `block_editor` field has a `group` parameter you can use to reference all the blocks of a certain group

Reference in what sense? I think `renderBlocks()` function can use it as a parameter, right?

`@formField('block_editor', ['group' => 'some-group'])`

is equivalent to:
```php
@formField('block_editor', [
  'blocks' => [
    'a-block-from-some-group', 
    'another-block-from-that-group'
  ]
])
```