$contractPeriodName = $row["CONTRACTDURATIONNAME"];
$contractStart = $row["CONTRACTDURATIONSTARTDATE"];
$contractEnd = $row["CONTRACTDURATIONENDDATE"];
$currency = $row["CURRENCYISOCODE"];
$buyPrice = $row["BUYPRICE"];
$margin = $row["MARGIN"];
$sellPrice = $row["SELLING"];
$serviceTypeObj = Models\ServiceType::firstOrCreate(array('name' => $serviceType));
$currencyObj = Models\Currency::firstOrCreate(array('code' => $currency));
$regionObj = Models\Region::firstOrCreate(array('name' => $region));
$supplierObj = $regionObj->suppliers()->firstOrCreate(array('name' => $supplierName, 'ts_id' => $supplierId));
if ($occupancyId) {
$occupancyObj = Models\Occupancy::firstOrCreate(array('id' => $occupancyId, 'name' => $occupancyName));
}
if ($mealName) {
$mealObj = Models\Meal::firstOrCreate(array('name' => $mealName));
}
// Find or Create Service
$serviceParams = array('ts_id' => $serviceId, 'name' => $serviceName, 'region_id' => $regionObj->id, 'currency_id' => $currencyObj->id, 'service_type_id' => $serviceTypeObj->id, 'supplier_id' => $supplierObj->id, 'name' => $serviceName);
$serviceObj = Models\Service::firstOrCreate($serviceParams);
// Find or Create Policies
$policyParams = array('ts_id' => $policyId, 'name' => $policyName);
Models\Policy::firstOrCreate($policyParams);
// Find or Create Contracts
$contractObj = $serviceObj->contracts()->firstOrCreate(array('ts_id' => $contractId, 'name' => $contractName));
$contractPeriodParams = array('ts_id' => $contractPeriodId, 'name' => $contractPeriodName, 'start' => date("Y/m/d", strtotime($contractStart)), 'end' => date("Y/m/d", strtotime($contractEnd)));
$contractPeriodObj = $contractObj->contractPeriods()->firstOrCreate($contractPeriodParams);
// Find or Create Season
$seasonObj = $contractPeriodObj->seasons()->firstOrCreate(array('ts_id' => $seasonId, 'name' => $seasonName));
$seasonPeriodParams = array('start' => date("Y/m/d", strtotime($seasonStart)), 'end' => date("Y/m/d", strtotime($seasonEnd)));
$seasonPeriodObj = $seasonObj->seasonPeriods()->firstOrCreate($seasonPeriodParams);
