Is it possible to modify a set function of an entity based on a field from another entity?
I have a field in table 1 (column E) that could contain either the value from column C or D (although having two fields with the same information seems messy, I am trying to make it work for now). The value in field E depends on another table (2).
For example: If in table 2, either "crit1" or "crit2" are "localisation", then in table 1, column "tri_id" (column F) will take the value from column D, otherwise it will take the value from column E.
Here is an example of the structure of these tables:
=> "adapte_gaucher" means "left-handed adapted"
https://i.stack.imgur.com/rzXZH.png
This is what I was attempting in my entity:
/**
* @param int $triId
*/
public function setTriId(int $shopId, int $triId): void
{
$entityManager = $this->getDoctrine()->getManager();
$products = $this->getDoctrine()
->getRepository(Table1::class)
->find($shopId)
if(Table1->crit1 != "localisation" || Table1->crit2 != "localisation" ) {
$triId = $this->tri21 ;
} else {
$triId = $this->tri12 ;
}
$this->triId = $triId;
$entityManager->persist($triId);
$entityManager->flush();
}
Would this be a suitable solution? As a beginner, I'm unsure if this is a good approach or if I should avoid it altogether. This project is part of my internship and I only have one year of programming experience without any framework training. Apologies for the dramatic plea, but your guidance would greatly assist me in succeeding.
Thank you in advance.