Hello @johnny , how to use setRelationNtoN ? I followed the documentation and got this error when i click add :
This is my table structure :
And this is my code :
public function index()
{
$crud = $this->_getGroceryCrudEnterprise();
$crud->setTable('akd_formulirpmb');
$crud->unsetCssTheme();
$crud->unsetExport();
$crud->unsetPrint();
//$crud->where(['per_info_personal.id_payroll >= ?' => 0]);
$crud->setSubject('Formulir PMB', 'Daftar Formulir PMB');
$crud->columns(['nama', 'harga', 'ujian', 'keterangan', 'urutan']);
$crud->addFields(['nama', 'harga', 'ujian', 'keterangan', 'urutan', 'program', 'inserted_by', 'inserted_time']);
$crud->editFields(['nama', 'harga', 'ujian', 'keterangan', 'urutan', 'program', 'updated_by', 'updated_time']);
$crud->fieldType('ujian', 'dropdown_search', [
'Y' => 'Ya',
'N' => 'Tidak'
]);
//$crud->displayAs('fk_id_projects', 'Nama Project');
$crud->fieldType('inserted_by', 'hidden');
$crud->fieldType('inserted_time', 'hidden');
$crud->fieldType('updated_by', 'hidden');
$crud->fieldType('updated_time', 'hidden');
$crud->setRelationNtoN('program', 'akd_formulirpmb_program', 'akd_program', 'fk_id_formulir', 'fk_id_program', 'nama');
$crud->callbackAddForm(function ($data) {
$data['inserted_by'] = Auth::user()->id;
$data['inserted_time'] = date('Y-m-d H:i:s');
return $data;
});
$crud->callbackEditForm(function ($data) {
$data['updated_by'] = Auth::user()->id;
$data['updated_time'] = date('Y-m-d H:i:s');
return $data;
});
$crud->setCsrfTokenName('_token');
$crud->setCsrfTokenValue(csrf_token());
$output = $crud->render();
return $this->_showOutput($output);
}
