public function search($input)
{
$query = Occupancy::query();
$columns = Schema::getColumnListing('occupancies');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
$contractId = $row["ORGANISATIONSUPPLIERCONTRACTID"];
$contractName = $row["ORGANISATIONSUPPLIERCONTRACTNAME"];
$contractPeriodId = $row["CONTRACTDURATIONID"];
$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
