/** * Rebind an event to a new Cal Event * @param [type] $oldEventId * @param [type] $newEventId * @param [type] $splitDate * @param [type] $untilEnd_yn */ function churchservice_rebindServicesToNewEvent($oldEventId, $newEventId, $splitDate, $untilEnd_yn) { ct_log("Split CSEvent {$oldEventId} to {$newEventId} at " . $splitDate->format('Y-m-d H:i:s') . " until end: {$untilEnd_yn}", 2); db_update("cs_event")->fields(array("cc_cal_id" => $newEventId))->condition('cc_cal_id', $oldEventId, "=")->condition('DATE(startdate)', $splitDate->format('Y-m-d'), $untilEnd_yn ? ">=" : "=")->execute(); }
/** * [setPassedPrestations description] * @param [type] $date [description] * @param [type] $day [description] * @param [type] $status [description] * @param [type] $newStatus [description] */ public function getPassedPrestation($date, $status) { $qb = $this->_em->createQueryBuilder(); $qb->select('p')->from('MainCommonBundle:Prestations\\Prestation', 'p')->where('p.startTime < :day')->andWhere('p.status = :status')->setParameters(array('day' => $date->format('Y-m-d'), 'status' => $status)); $query = $qb->getQuery(); return $query->getResult(); }
/** * is Day date (without Time) in $event * @param [type] $date * @param [type] $event */ function dateInCCEvent($date, $event) { $ret = false; if ($event == null) { return false; } $ds = getAllDatesWithRepeats((object) $event, 0, 9999, new DateTime($event["startdate"])); if ($ds) { foreach ($ds as $d) { if ($date->format("Ymd") == $d->format("Ymd")) { $ret = true; } } } return $ret; }