public function saveCalendarHolidays($aData)
{
$CalendarUid = $aData['CALENDAR_UID'];
$CalendarHolidayName = $aData['CALENDAR_HOLIDAY_NAME'];
$CalendarHolidayStart = $aData['CALENDAR_HOLIDAY_START'];
$CalendarHolidayEnd = $aData['CALENDAR_HOLIDAY_END'];
//if exists the row in the database propel will update it, otherwise will insert.
$tr = CalendarHolidaysPeer::retrieveByPK($CalendarUid, $CalendarHolidayName);
if (!(is_object($tr) && get_class($tr) == 'CalendarHolidays')) {
$tr = new CalendarHolidays();
}
$tr->setCalendarUid($CalendarUid);
$tr->setCalendarHolidayName($CalendarHolidayName);
$tr->setCalendarHolidayStart($CalendarHolidayStart);
$tr->setCalendarHolidayEnd($CalendarHolidayEnd);
if ($tr->validate()) {
$res = $tr->save();
} else {
// Something went wrong. We can now get the validationFailures and handle them.
$msg = '';
$validationFailuresArray = $tr->getValidationFailures();
foreach ($validationFailuresArray as $objValidationFailure) {
$msg .= $objValidationFailure->getMessage() . "<br/>";
}
//return array ( 'codError' => -100, 'rowsAffected' => 0, 'message' => $msg );
}
//to do: uniform coderror structures for all classes
}
/**
* Implementation for 'GET' method for Rest API
*
* @param mixed $calendarUid, $calendarHolidayName Primary key
*
* @return array $result Returns array within multiple records or a single record depending if
* a single selection was requested passing id(s) as param
*/
protected function get($calendarUid = null, $calendarHolidayName = null)
{
$result = array();
try {
$noArguments = true;
$argumentList = func_get_args();
foreach ($argumentList as $arg) {
if (!is_null($arg)) {
$noArguments = false;
}
}
if ($noArguments) {
$criteria = new Criteria('workflow');
$criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_UID);
$criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_NAME);
$criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_START);
$criteria->addSelectColumn(CalendarHolidaysPeer::CALENDAR_HOLIDAY_END);
$dataset = AppEventPeer::doSelectRS($criteria);
$dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
while ($dataset->next()) {
$result[] = $dataset->getRow();
}
} else {
$record = CalendarHolidaysPeer::retrieveByPK($calendarUid, $calendarHolidayName);
if ($record) {
$result = $record->toArray(BasePeer::TYPE_FIELDNAME);
} else {
$paramValues = "";
foreach ($argumentList as $arg) {
$paramValues .= strlen($paramValues) ? ', ' : '';
if (!is_null($arg)) {
$paramValues .= "{$arg}";
} else {
$paramValues .= "NULL";
}
}
throw new RestException(417, "table CalendarHolidays ({$paramValues})");
}
}
} catch (RestException $e) {
throw new RestException($e->getCode(), $e->getMessage());
} catch (Exception $e) {
throw new RestException(412, $e->getMessage());
}
return $result;
}
/**
* Retrieve object using using composite pkey values.
* @param string $calendar_uid
@param string $calendar_holiday_name
* @param Connection $con
* @return CalendarHolidays
*/
public static function retrieveByPK($calendar_uid, $calendar_holiday_name, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$criteria = new Criteria();
$criteria->add(CalendarHolidaysPeer::CALENDAR_UID, $calendar_uid);
$criteria->add(CalendarHolidaysPeer::CALENDAR_HOLIDAY_NAME, $calendar_holiday_name);
$v = CalendarHolidaysPeer::doSelect($criteria, $con);
return !empty($v) ? $v[0] : null;
}
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants TYPE_PHPNAME, TYPE_COLNAME, TYPE_FIELDNAME,
* TYPE_NUM. The default key type is the column's phpname (e.g. 'authorId')
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = CalendarHolidaysPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setCalendarUid($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setCalendarHolidayName($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setCalendarHolidayStart($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setCalendarHolidayEnd($arr[$keys[3]]);
}
}
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;
}