Dependant for editor - Separate script not populated select list

peterbrowne

I have two dependant selects on my Editor. One is working fine, the new one (assessments) is not working:

This is the separate script to get assessments when the learning_event.unit_group_fk select is selected:

<?php
require_once( '../../../maps/cm_mjd_plmed/connection/connect.php' );

$unit = $_POST['values']['learning_event.unit_group_fk'];

$data = array();

$query = "SELECT * FROM assessment WHERE unit_group_fk = '$unit'";
$result = $connection->query( $query );

while ($row = mysqli_fetch_array($result)) {
    $data[] = array("label"=>$row['assessment'], "value"=>$row['assessment_pk']);
}

$temp = array('assessment[].assessment_pk'=>$data);
$json = array('options'=>$temp);
echo json_encode($json);
?>

The client side:

        <div id="learning_event_form">
            <editor-field name="learning_event.learning_event_name"></editor-field>
            <editor-field name="learning_event.outline"></editor-field>
            <editor-field name="learning_event.length"></editor-field>
            <editor-field name="program_outcome[].program_outcome_pk"></editor-field>
            <editor-field name="learning_event.unit_group_fk"></editor-field>
            <editor-field name="learning_event.week_fk"></editor-field>
            <editor-field name="assessment[].assessment_pk"></editor-field>
            <editor-field name="learning_event_type[].learning_event_type_pk"></editor-field>
        </div>

var editor = new $.fn.dataTable.Editor( {
                ajax: "program_data/learning_event_data.php",
                table: "#learning_event_table",
                template: '#learning_event_form',
                fields: [ {
                    label: "Learning Event:",
                    name: "learning_event.learning_event_name"
                }, {
                    label: "Outline:",
                    name: "learning_event.outline",
                    type: "ckeditor"
                },{
                    label: "Length (minutes):",
                    name: "learning_event.length"
                }, {
                    label: "Program Outcome:",
                    name: "program_outcome[].program_outcome_pk",
                    type: "select",
                    placeholder: 'No selection',
                    placeholderDisabled: false,
                    placeholderValue: 0,
                    multiple: true
                }, {
                    label: "Unit Group:",
                    name: "learning_event.unit_group_fk",
                    type: "select",
                    placeholder: "Select Unit Group..."
                }, {
                    label: "Week:",
                    name: "learning_event.week_fk",
                    type: "select",
                    placeholder: "Select Week..."
                },{
                    label: "Assessment:",
                    name: "assessment[].assessment_pk",
                    type: "select",
                    placeholder: "Select Assessments...",
                    placeholderDisabled: false,
                    placeholderValue: 0,
                    multiple: true
                }, {
                    label: "Type:",
                    name: "learning_event_type[].learning_event_type_pk",
                    type: "select",
                    placeholder: 'No selection',
                    placeholderDisabled: false,
                    placeholderValue: 0,
                    multiple: true,
                        attr: {
                            size: 1
                        }
                } ]
            } );
            
            
            
                editor.dependent('learning_event.unit_group_fk', 'program_data/get_weeks.php');
            
                editor.dependent('learning_event.unit_group_fk', 'program_data/get_assessments.php');
            
            

            var table = $( '#learning_event_table' ).DataTable( {
                responsive: true,
                "autoWidth": false,
                "lengthMenu": [
                    [ 5, 10, 25, 50, -1 ],
                    [ 5, 10, 25, 50, "All" ]
                ],
                columnDefs: [ {
                    targets: 1,
                    render: $.fn.dataTable.render.ellipsis( 150, true )
                } ],
                ajax: "program_data/learning_event_data.php",
                dom: "Blfrtip",
                columns: [ {
                    data: "learning_event.learning_event_name",
                }, {
                    data: "learning_event.outline",
                }, {
                    data: "learning_event.length",
                }, {
                    data: "program_outcome",
                    render: "[, ].program_outcome"
                }, {
                    data: "unit_group.unit_group"
                }, {
                    data: "week.week_full_name"
                }, {
                    data: "assessment.assessment",
                    render: "[, ].assessment"
                }, {
                    data: "learning_event_type",
                    render: "[, ].learning_event_type_name"
                }, {
                    data: "learning_event.modified"
                }, {
                    data: "learning_event.modified_by"
                }, {
                    data: null,
                    className: "center",
                    defaultContent: '<a href="" class="editor_edit">Edit</a>'
                } ],
                select: {
                    style: 'os',
                    selector: 'td:first-child'
                },
                buttons: []
            } );

peterbrowne

Server side:

Editor::inst( $db_cm_mjd_plmed, 'learning_event', 'learning_event_pk' )    
    ->field(
        Field::inst( 'learning_event.learning_event_name' ),
        Field::inst( 'learning_event.outline' ),
        Field::inst( 'learning_event.length' ),
        Field::inst( 'learning_event.modified' ),
        Field::inst( 'learning_event.modified_by' )->setValue( $user),
        Field::inst( 'learning_event.unit_group_fk' )
            ->options( Options::inst()
                ->table( 'unit_group' )
                ->value( 'unit_group_pk' )
                ->label( 'unit_group' )
                ->where( function ($q) {
            $q->where( 'unit_group.type', 'learning_event' );
                })
            ),
        Field::inst( 'unit_group.unit_group' ), 
        Field::inst( 'learning_event.week_fk' )
            ->options( Options::inst()
                ->table( 'week' )
                ->value( 'week_pk' )
                ->label( 'week_full_name' )
            ),
        Field::inst( 'week.week_full_name' )    
    )
     ->leftJoin( 'unit_group', 'unit_group.unit_group_pk', '=', 'learning_event.unit_group_fk' )
     ->leftJoin( 'week', 'week.week_pk', '=', 'learning_event.week_fk' )
        ->join(
        Mjoin::inst( 'program_outcome' )
            ->link( 'learning_event.learning_event_pk', 'learning_event_program_outcome_lookup.learning_event_fk' )
            ->link( 'program_outcome.program_outcome_pk', 'learning_event_program_outcome_lookup.program_outcome_fk' )
            ->order( 'program_outcome.program_outcome asc' )
            ->fields(
                Field::inst( 'program_outcome_pk' )
                    ->options( Options::inst()
                        ->table( 'program_outcome' )
                        ->value( 'program_outcome_pk' )
        ->label( array('type', 'program_outcome') )
        ->render( function ( $row ) {
            return $row['type'] . ' - ' . $row['program_outcome'];
        } )
                        ->order( 'type' )
                    ),
                Field::inst( 'program_outcome' )
            )
    )
    ->join(
        Mjoin::inst( 'assessment' )
            ->link( 'learning_event.learning_event_pk', 'learning_event_assessment_lookup.learning_event_fk' )
            ->link( 'assessment.assessment_pk', 'learning_event_assessment_lookup.assessment_fk' )
           ->order( 'assessment.assessment asc' )
            ->fields(
                Field::inst( 'assessment_pk' )
                    ->options( Options::inst()
                        ->table( 'assessment' )
                        ->value( 'assessment_pk' )
                        ->label( 'assessment' )       
                    ),
                Field::inst( 'assessment' )
            )
    )
    ->join(
        Mjoin::inst( 'learning_event_type' )
            ->link( 'learning_event.learning_event_pk', 'learning_event_type_lookup.learning_event_fk' )
            ->link( 'learning_event_type.learning_event_type_pk', 'learning_event_type_lookup.learning_event_type_fk' )
           ->order( 'learning_event_type.learning_event_type_name asc' )
            ->fields(
                Field::inst( 'learning_event_type_pk' )
                    ->options( Options::inst()
                        ->table( 'learning_event_type' )
                        ->value( 'learning_event_type_pk' )
                        ->label( 'learning_event_type_name' )         
                    ),
                Field::inst( 'learning_event_type_name' )
            )
    )
    ->process($_POST)
    ->json();

allan

In what way does it not work? Does it not make the second Ajax request, or is there an error or something else? If you could link to a test case showing the issue, that would be really useful.

Thanks,
Allan

peterbrowne

The problem was with the script that populates the assessment select. I was sending data that needed to be used sub queries in that script to get the correct data. Fixed!