function getCalendarBusinessHours($CalendarUid) { $Criteria = new Criteria('workflow'); $Criteria->clearSelectColumns(); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_UID); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START); $Criteria->addSelectColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_END); $Criteria->add(CalendarBusinessHoursPeer::CALENDAR_UID, $CalendarUid, CRITERIA::EQUAL); $Criteria->addDescendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY); $Criteria->addAscendingOrderByColumn(CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START); //$Criteria->addDescendingOrderByColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START ); $rs = CalendarBusinessHoursPeer::doSelectRS($Criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields = array(); $count = 0; while (is_array($row)) { $count++; $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 CalendarBusinessHoursPeer::populateObjects(CalendarBusinessHoursPeer::doSelectRS($criteria, $con)); }
public function getCalendarBusinessHours ($calendarUid = null) { require_once ( 'classes/model/CalendarBusinessHours.php' ); $calendarUid = (is_null($calendarUid)) ? $this->pmCalendarUid : $calendarUid; $this->pmCalendarUid = $calendarUid; $criteria = new Criteria('workflow'); $criteria->clearSelectColumns ( ); $criteria->addSelectColumn ( CalendarBusinessHoursPeer::CALENDAR_UID ); $criteria->addSelectColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY ); $criteria->addSelectColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START ); $criteria->addSelectColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_END ); $criteria->add ( CalendarBusinessHoursPeer::CALENDAR_UID, $calendarUid , CRITERIA::EQUAL ); $criteria->addDescendingOrderByColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_DAY ); $criteria->addAscendingOrderByColumn ( CalendarBusinessHoursPeer::CALENDAR_BUSINESS_START ); $rs = CalendarBusinessHoursPeer::doSelectRS($criteria); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); $fields = array(); $count = 0; while (is_array($row)) { $count++; $iniTime = (float)str_replace(':', '', $row['CALENDAR_BUSINESS_START']); $finTime = (float)str_replace(':', '', $row['CALENDAR_BUSINESS_END']); $row['DIFF_HOURS'] = (($finTime-$iniTime)/100); $fields[$count] = $row; $rs->next(); $row = $rs->getRow(); } return $fields; }