public function getCalendarHolidays($CalendarUid) { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_UID); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_NAME); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_START); $Criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_END); $Criteria->add(CalendarHolidaysPeer::CALENDAR_UID, $CalendarUid, CRITERIA::EQUAL); $rs = CalendarHolidaysPeer::doSelectRS($Criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields = array(); $count = 0; while (is_array($row)) { $count++; $a = explode(" ", $row['CALENDAR_HOLIDAY_START']); $row['CALENDAR_HOLIDAY_START'] = $a[0]; $a = explode(" ", $row['CALENDAR_HOLIDAY_END']); $row['CALENDAR_HOLIDAY_END'] = $a[0]; $fields[$count] = $row; $rs->next(); $row = $rs->getRow(); } return $fields; }
/** * Method to do selects. * * @param Criteria $criteria The Criteria object used to build the SELECT statement. * @param Connection $con * @return array Array of selected Objects * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelect(Criteria $criteria, $con = null) { return CalendarHolidaysPeer::populateObjects(CalendarHolidaysPeer::doSelectRS($criteria, $con)); }
public function getCalendarHolidays ($calendarUid = null) { require_once ( 'classes/model/CalendarHolidays.php' ); $calendarUid = (is_null($calendarUid)) ? $this->pmCalendarUid : $calendarUid; $this->pmCalendarUid = $calendarUid; $criteria = new Criteria('workflow'); $criteria->clearSelectColumns ( ); $criteria->addSelectColumn ( CalendarHolidaysPeer::CALENDAR_UID ); $criteria->addSelectColumn ( CalendarHolidaysPeer::CALENDAR_HOLIDAY_NAME ); $criteria->addSelectColumn ( CalendarHolidaysPeer::CALENDAR_HOLIDAY_START ); $criteria->addSelectColumn ( CalendarHolidaysPeer::CALENDAR_HOLIDAY_END ); $criteria->add ( CalendarHolidaysPeer::CALENDAR_UID, $calendarUid , CRITERIA::EQUAL ); $rs = CalendarHolidaysPeer::doSelectRS($criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields=array(); $count=0; while (is_array($row)) { $count++; $a=explode(' ',$row['CALENDAR_HOLIDAY_START']); $row['CALENDAR_HOLIDAY_START']=$a[0]; $a=explode(' ',$row['CALENDAR_HOLIDAY_END']); $row['CALENDAR_HOLIDAY_END']=$a[0]; $fields[$count] = $row; $rs->next(); $row = $rs->getRow(); } return $fields; }