$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); // Find or Create Service Extras $extraObj = null; if ($extraId) { $extraParams = array('name' => $extraName, 'ts_id' => $extraId);