disctionaries

disctionaries.php

$data_parameters = DB::table('data_parameters')
        ->select('data_parameters.id', 'data_parameters.name', 'data_parameters.groupname', 
        'data_parameters.group_alias', 'data_parameters.parameter_type', 'data_parameters.value_source',
        'data_parameters.operation_act', 'data_parameters.operation', 'data_parameters.repeatable',
        'data_parameters.scope', 'data_parameters.visible_on', 'data_parameters.order_no',
        'data_parameters.error_text', 'data_parameters.dictionary_id',
        )
        ->where([
            ['data_parameters.company_id', $owner->company_id],
            ['data_parameters.isactive', 1],
        ])
        ->orderBy('order_no')
        ->get();

        foreach ($data_parameters as $key => $parameter) {
            $dictionary = DB::table('dictionaries')
            ->where([
                ['dictionaries.company_id', $owner->company_id],
                ['dictionaries.id', $parameter->dictionary_id],
                ['dictionaries.isactive', 1],
            ])
            ->get();
            $data_parameters[$key]->dictionary = $dictionary;
        }

        foreach ($data_parameters as $key => $parameter) {
            $dictionary_data = DB::table('dictionary_data')
            ->where([
                ['dictionary_data.company_id', $owner->company_id],
                ['dictionary_data.isactive', 1],
                ['dictionary_data.dictionary_id', $parameter->dictionary_id],
            ])
            ->get();

            $data_parameters[$key]->items = $dictionary_data;
        }
            
        return response()->json($data_parameters);