Hi,
I’ve figured out how to display an Id or the Name of an object in relationship with my entity from serverside but if I just load my entity from the api I get this
[object Object]
I was wondering if I was able to do it with webix directly as this doesn’t work:
id: "g_sponsor.name"
Also, I can’t figure how to be able to edit it.
I have a table trial in association with a table sponsor, with sponsor_id as a foreign key in the trial table. I understand this return an object. I can’t figure a way to edit it (select another sponsor from the list).
this is the error I get
Type error: Argument 1 passed to ErpBundle\\Entity\\Trial::setGSponsor()
must be an instance of ErpBundle\\Entity\\Sponsor, string given
Ideally, I’d like to be able to loop in this foreign table and select it from a list like this:
editor: "multiselect",
optionslist: true,
options: [
{id: 1, value: "a"},
{id: 2, value: "b"},
{id: 3, value: "c"},
{id: 4, value: "d"}
],
What is the best way to do it?
My datatable:
var griddef = {
view: "datatable",
id: "dtable",
headermenu: true,
columns: [
{
id: "g_sponsor",
batch: "main",
editor: "text",
header: [null, "Sponsor", {content: "textFilter"}],
width: 150,
sort: "string"
},
{
id: "g_bps",
batch: "main",
editor: "text",
header: [null, "BPS", {content: "selectFilter"}],
width: 50,
sort: "string"
},
{
id: "g_efip",
batch: "main",
editor: "multiselect",
optionslist: true,
options: [
{id: 1, value: "E"},
{id: 2, value: "F"},
{id: 3, value: "I"},
{id: 4, value: "P"}
],
header: [null, "EFIP", {content: "selectFilter"}],
width: 50,
sort: "string"
},
{
id: "g_protocol_number",
batch: "main",
editor: "text",
header: [null, "Protocole Code", {content: "textFilter"}],
width: 150,
sort: "string"
},
{
id: "g_trial_number",
batch: "main",
editor: "text",
header: [null, "Trial Code", {content: "textFilter"}],
width: 150,
sort: "string"
},
],
editable: true,
select: "cell",
blockselect: true,
multiselect: true,
navigation: true,
autoheight: true,
autowidth: true,
save: "rest->{{ path('api_post_t') }}",
url: "rest->{{ path('erp_trialapi_cgetload') }}"
webix.ready(function () {
grida = webix.ui({
container: 'test',
rows: [searchbar, excelexport, griddef],
});
});
Json example:
{
id: 38,
g_project_manager: "Gerard",
g_departement: 12120,
g_country: "France",
g_technician: "Alphonse",
g_cofrac_code: "Code",
g_year: 2017,
g_efip: "2",
g_hfieds: "E",
g_crop_code: "Ma",
g_sponsor: {
id: 13,
sponsor_code: "AGB",
name: "AGRIBIOTEC",
city: "",
zip_code: 0,
address: "",
country: "",
phone_number: "0",
email: "",
creation_date: "-0001-11-30T00:00:00+0100"
}
},
My PUT action:
/**
* @Rest\\Put("/api_t/{id}")
*/
public function putAction(Request $request, int $id)
{
$data = new Trial;
$gSponsor = $request->get('g_sponsor');
$sn = $this->getDoctrine()->getManager();
$trial = $this->getDoctrine()->getRepository('ErpBundle:Trial')->find($id);
if (empty($trial)) {
return new View("user not found", Response::HTTP_NOT_FOUND);
}
$trial->setGSponsor($gSponsor);
$sn->flush();
$response=array("id" => $id, "status" => "success");
return new JsonResponse($response);
}
Thank you very much!
