Dynamically Pass lesson_category_id and Store Lessons with id and title in JSON Field in CRUD Form

[avinashtelsa]

This is my code for saving and updating quotes in a JSON field, but it is being saved as follows:

protected function setupCreateOperation()
{
    Widget::add()->type('script')->content('js/admin/lesson_category_quotes.js');

    CRUD::setValidation(LessonCategoryQuotesRequest::class);
    CRUD::field('title');
    CRUD::field('course')
        ->type('select2')
        ->entity('course');
    CRUD::addField([
        'type'          => "relationship",
        'name'          => 'lessonCategory',
        'ajax'          => true,
        'minimum_input_length' => 0,
        'inline_create' => [ 'entity' => 'lesson-category' ] , 
        'data_source' => url('api/lesson-category'),
        'method' => 'GET',
    ]);
    CRUD::addField([
        'name'  => 'quotes',
        'label' => 'Quotes',
        'type'  => 'repeatable',
        'fields' => [
            [
                'name'  => 'title',
                'type'  => 'text',
                'label' => 'Quote Title',
            ],
            [
                'name'  => 'lessons',
                'type'  => 'select2_multiple',
                'label' => 'Lessons',
                'entity' => 'lessons',
                'model' => 'App\Models\Lesson',
                'attribute' => 'title',
                'pivot' => true,
                'default' => null,
                'placeholder' => 'Select lessons',
                'attributes' => [
                    'class' => 'lesson-select',
                ],
                'options' => (function ($query) {
                    return $query->where('lesson_category_id', 1)->get();
                }),
            ],
        ],
        'new_item_label'  => 'Add Quote',
        'init_rows'       => 0,
        'min_rows'        => 0,
        'max_rows'        => 10,
    ]);
}

[
  {
    "title": "Quote 1 Title",
    "lessons": [
      "1"
    ]
  },
  {
    "title": "Quote 2 Title",
    "lessons": [
      "2"
    ]
  }
]

But I want it to be saved like this:

[
    {
        "title": "Quote 1 Title",
        "lessons": [
            { "id": 1, "title": "Lesson 1" },
            { "id": 2, "title": "Lesson 2" }
        ]
    },
    {
        "title": "Quote 2 Title",
        "lessons": [
            { "id": 3, "title": "Lesson 3" }
        ]
    }
]

And if possible, I have statically passed the lesson_category_id here:

'options' => (function ($query) {
    return $query->where('lesson_category_id', 1)->get();
}),

I want to pass the selected value for this field here. Thank you for the help!

CRUD::addField([
    'type'               => "relationship",
    'name'               => 'lessonCategory',
    'ajax'               => true,
    'minimum_input_length' => 0,
    'inline_create'      => ['entity' => 'lesson-category'],
    'data_source'        => url('api/lesson-category'),
    'method'             => 'GET',
]);

[backpack-ai-bot[bot]]

To achieve the desired JSON structure for your quotes and dynamically pass the lesson_category_id, you'll need to make some modifications to your code. Here's how you can approach this:

1. First, let's modify the 'lessons' field in your repeatable field to use select2_from_ajax instead of select2_multiple:

[
    'name'  => 'lessons',
    'type'  => 'select2_from_ajax_multiple',
    'label' => 'Lessons',
    'entity' => 'lessons',
    'attribute' => 'title',
    'data_source' => url('api/lessons'),
    'placeholder' => 'Select lessons',
    'minimum_input_length' => 0,
    'dependencies' => ['lessonCategory'],
    'include_all_form_fields' => true,
]

2. Create a new API endpoint for fetching lessons:

Route::get('api/lessons', 'App\Http\Controllers\Admin\LessonCrudController@fetchLessons');

3. In your LessonCrudController, add the fetchLessons method:

public function fetchLessons()
{
    $lessonCategoryId = request('lessonCategory');
    $term = request('q');

    $results = Lesson::where('lesson_category_id', $lessonCategoryId)
        ->where('title', 'LIKE', '%'.$term.'%')
        ->paginate(10);

    return $results;
}

4. To store the lessons with both id and title in the JSON field, you'll need to modify the saving process. You can do this by adding a mutator to your model:

public function setQuotesAttribute($value)
{
    $quotes = json_decode($value, true);
    foreach ($quotes as &$quote) {
        if (isset($quote['lessons'])) {
            $lessonIds = $quote['lessons'];
            $quote['lessons'] = Lesson::whereIn('id', $lessonIds)
                ->get(['id', 'title'])
                ->toArray();
        }
    }
    $this->attributes['quotes'] = json_encode($quotes);
}

These changes should allow you to:

1. Dynamically load lessons based on the selected lesson category
2. Store the lessons with both id and title in the JSON field

For the lessonCategory field, you're already using the correct setup to make it dynamic. The dependencies attribute in the 'lessons' field will ensure that when the lesson category changes, the lessons field is reset and will load new options based on the selected category.

Remember to adjust the namespaces and paths according to your project structure.

Backpack CRUD Fields Documentation provides more information on using select2_from_ajax fields.

Backpack CRUD How-To Documentation offers guidance on creating dependent fields.

If you need further assistance or clarification, please let me know!

Relevant sources:

Github Issue (closed): [Feature] Ability to define any (nested) fields inside "table" field
Github Issue (closed): Storing Value not ID
Github Issue (closed): select2_from_ajax_multiple multiple population inside repeatable
FAQs for CRUDs|How to add a relationship field that depends on another field Part 3
Github Issue (closed): Ajax for select2
Github Issue (closed): [Bug] Select2_multiple with no pivot
Fields|select2_from_ajax PRO Part 1
Github Issue (closed): [Feature or Documentation Request] - CrudField JavaScript Library with relationship/subfield fields
Github Issue (closed): [Feature Request] select2_from_ajax with optional relationship
Github Issue (closed): Dynamically adding new items to the database via select2
Github Issue (closed): [4.0]Issue: select2_from_ajax with relationship don't save state for edit Operation.

[avinashtelsa]

1. This answer to the previous question is correct.

    public function setQuotesAttribute($value)
    {
        // Check if $value is a string before decoding
        if (is_string($value)) {
            $quotes = json_decode($value, true);
        } else {
            $quotes = $value; // If $value is already an array, use it directly
        }

        foreach ($quotes as &$quote) {
            if (isset($quote['lessons'])) {
                $lessonIds = $quote['lessons'];
                $quote['lessons'] = Lesson::whereIn('id', $lessonIds)
                    ->get(['id', 'title'])
                    ->toArray();
            }
        }

        $this->attributes['quotes'] = json_encode($quotes);
    }

2. I need the selected value for this

CRUD::addField([
    'type'               => "relationship",
    'name'               => 'lessonCategory',
    'ajax'               => true,
    'minimum_input_length' => 0,
    'inline_create'      => [ 'entity' => 'lesson-category' ], // <--- THIS
    'data_source'        => url('api/lesson-category'),
    'method'             => 'GET',
    'attributes'         => [
        'id' => 'lesson-category',
    ],
]);

$lessonCategoryId = request()->input('lessonCategory');
Log::debug('lessonCategoryId: ' . $lessonCategoryId);

I tried this, but it didn’t work.

[jcastroa87]

Hello @avinashtelsa did you try to print all your request to check where did you receive the values?

dd(request());

If not see the value, please share the controller to replicate in my side and try to add the code style here to read it easily, thanks.

Cheers.

[avinashtelsa]

Hello @jcastroa87

Using dd(request()) is not working. I need the value of the lessonCategory field at the time of adding or editing.

Here is my controller code.

protected function setupCreateOperation()
{
Widget::add()->type('script')->content('js/admin/lesson_category_quotes.js');

CRUD::setValidation(LessonCategoryQuotesRequest::class);
CRUD::field('title');
CRUD::field('course')
    ->type('select2')
    ->entity('course');
CRUD::addField([
    'type'          => "relationship",
    'name'          => 'lessonCategory',
    'ajax'          => true,
    'minimum_input_length' => 0,
    'inline_create' => [ 'entity' => 'lesson-category' ] , // <--- THIS
    'data_source' => url('api/lesson-category'),
    'method' => 'GET',
    'attributes' => [
        'id' => 'lesson-category',
    ],
]);
CRUD::addField([
    'name'    => 'character',
    'type'    => 'select2_from_array',
    'label'   => 'Character',
    'options' => [
        'Violence'               => 'Quote for Violence',
        'Ambition'               => 'Quote for Ambition',
        'Guilt'                  => 'Quote for Guilt',
        'Gender'                 => 'Quote for Gender',
        'Appearance vs Reality'  => 'Quote for Appearance vs Reality',
        'Supernatural'           => 'Quote for Supernatural',
        'Quotes 1-4'             => 'Quotes 1-4',
        'Quotes 5-6'             => 'Quotes 5-6',
        'Quotes 7-8'             => 'Quotes 7-8',
        'Quotes 1-6'             => 'Quotes 1-6',
    ],
    'default' => null,
    'placeholder' => 'Select any Character',
]);
CRUD::addField([
    'name'  => 'quote_limits',
    'type'  => 'number',
    'label' => 'Quote Limit',
    'attributes' => [
        'min' => 1,
        'max' => 10,
    ],
    'hint' => 'Set the limit between 1 and 10',
    'default' => null,
]);
CRUD::addField([
    'name'  => 'quotes',
    'label' => 'Quotes',
    'type'  => 'repeatable',
    'fields' => [
        [
            'name'  => 'title',
            'type'  => 'text',
            'label' => 'Quote Title',
        ],
        [
            'name'  => 'lessons',
            'type'  => 'select2_multiple',
            'label' => 'Lessons',
            'entity' => 'lessons',
            'model' => 'App\Models\Lesson',
            'attribute' => 'title',
            'pivot' => true,
            'default' => null,
            'placeholder' => 'Select lessons',
            'attributes' => [
                'class' => 'lesson-select',
            ],
            'options' => function ($query) {
                Log::info(print_r(request()->all(), true));
                Log::debug('---------all---------');;

                $lessonCategoryId = request()->input('lessonCategory');
                if ($lessonCategoryId) {
                    return $query->where('lesson_category_id', $lessonCategoryId)->get();
                }
                return $query->get();
            },
        ],
    ],
    'new_item_label'  => 'Add Quote',
    'init_rows'       => 0,
    'min_rows'        => 0,
    'max_rows'        => 10,
]);

/**
    * Fields can be defined using the fluent syntax:
    * - CRUD::field('price')->type('number');
    */

}

[jcastroa87]

Due to not activity, I will close this issue, but please feel free to re-open or create a new one.

Cheers.