我有三个表，
Business:
id
name
Office:
id
name
business_id
Employee:
id
name
office_id
Employee的office_id作为外键，Offices的business_id作为主键。
我有一个与每一个相关的域对象/实体，以及一个与每个相关的数据库映射器对象。
现在，当我有企业名称、办公室名称和员工名称时，如何插入新员工？
最初，我认为逻辑应该是这样的：
$businessMapper = new businessMapper();
$business = $businessMapper->findBusinessByName($business_name);
if ($business == false) {
$business = new businessEntity(array(
'businessName' => $business_name,
));
$businessMapper->save($business);
}
$officeMapper = new officeMapper();
$office = $officeMapper->getOfficeByName($office_name, $business);
.......etc.......
但后来我意识到，如果我必须拯救一家新企业，我就不可能有办公室或员工，所以试图找到他们是徒劳的。所以我想我应该创建一个if/else结构。
get business entity by business_name
if ($business == false) {
create business entity
save business entity
create office entity
save office entity
create employee entity
save employee entity
} else {
get office entity by office_name + business_id
if (office == false) {
create office entity
save office entity
create employee entity
save employee entity
} else {
......etc......
}
}
但有太多重复的逻辑，而且非常不可扩展/肮脏。
那么应该如何实现呢？
其次，逻辑应该走向何方？它应该放在员工的映射器中吗？或者"添加员工"操作的控制器，或者它应该有一个新的模型？
我使用Zend作为我的框架，但我认为这个问题适用于所有MVC风格的结构，所以无论你的框架偏好如何，请随时回复：）
如果在If（）块中使用OR语句，并将查询放入If语句中，则只有在If语句的第一部分失败时才会执行该语句，从而确保不会不必要地执行查询。就我们个人而言，我们也做了类似的事情，但当我们创建一个新域时，我们在域new=1中设置了一个标志，我们检查了这个标志，同样的方法只是消除了对这些脏变量的需要；-）
$businessMapper = Factory::getMapper('business');
if (!$business = $businessMapper->findByName("Business Name"))
{
$business = $businessMapper->create();
$business->setName("Business Name");
$businessMapper->save($business);
$newBusiness = true;
}
$officeMapper = Factory::getMapper('office');
if (isset($newBusiness) || !$office = $officeMapper->findByName("Office Name"))
{
$office = $officeMapper->create();
$office->setName("Office Name");
$office->setBusiness($business->getId());
$officeMapper->save($office);
$newOffice = true;
}
$employeeMapper = Factory::getMapper('employee');
if (isset($newOffice) || !$employee = $employeeMapper->findByName("Employee"))
{
$employee = $employeeMapper->create();
$employee->setName("Employee Name");
$employee->setOffice($office->getId());
$employeeMapper->save($employee);
}