private function getEndingContracts() { $endingContracts = array(); $c = new oqc_ExternalContract(); $contracts = $c->get_full_list('', 'already_notified=0 and enddate >= NOW()'); $nowTimestamp = time(); if (!empty($contracts)) { foreach ($contracts as $contract) { $enddate = date_parse($contract->enddate); // make sure that foreach contract the notification is sent only once && if this contract ends in the warning interval if (!$contract->already_notified && $nowTimestamp >= mktime(0, 0, 0, $enddate['month'] - $contract->warn_in_months, $enddate['day'], $enddate['year'])) { $endingContracts[] = $contract; } } } return $endingContracts; }
public static function getBiggestExternalContract() { $externalContract = new oqc_ExternalContract(); $list = $externalContract->get_full_list("finalcosts desc", "deleted=0"); return $list[0]; }