/** * Implementation for 'POST' method for Rest API * * @param mixed $calendarUid 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 post($calendarUid, $calendarName, $calendarCreateDate, $calendarUpdateDate, $calendarWorkDays, $calendarDescription, $calendarStatus) { try { $result = array(); $obj = new CalendarDefinition(); $obj->setCalendarUid($calendarUid); $obj->setCalendarName($calendarName); $obj->setCalendarCreateDate($calendarCreateDate); $obj->setCalendarUpdateDate($calendarUpdateDate); $obj->setCalendarWorkDays($calendarWorkDays); $obj->setCalendarDescription($calendarDescription); $obj->setCalendarStatus($calendarStatus); $obj->save(); } catch (Exception $e) { throw new RestException(412, $e->getMessage()); } }
/** * get calendar list */ public function getCaledarList() { G::LoadClass('calendar'); $calendar = new CalendarDefinition(); $calendarObj = $calendar->getCalendarList(true, true); $calendarObj['array'][0] = array('CALENDAR_UID' => '', 'CALENDAR_NAME' => ''); $this->rows = $calendarObj['array']; }
public function getCaledarList() { G::LoadClass('calendar'); $calendar = new CalendarDefinition(); $calendarObj = $calendar->getCalendarList(true, true); $calendarObj['array'][0] = array('CALENDAR_UID' => '', 'CALENDAR_NAME' => ''); $response->rows = $calendarObj['array']; print G::json_encode($response); }
function saveCalendarInfo($aData) { $CalendarUid = $aData['CALENDAR_UID']; $CalendarName = $aData['CALENDAR_NAME']; $CalendarDescription = $aData['CALENDAR_DESCRIPTION']; $CalendarStatus = isset($aData['CALENDAR_STATUS']) ? $aData['CALENDAR_STATUS'] : "INACTIVE"; $defaultCalendars[] = '00000000000000000000000000000001'; if (in_array($aData['CALENDAR_UID'], $defaultCalendars)) { $CalendarStatus = 'ACTIVE'; $CalendarName = 'Default'; } $CalendarWorkDays = isset($aData['CALENDAR_WORK_DAYS']) ? implode("|", $aData['CALENDAR_WORK_DAYS']) : ""; //if exists the row in the database propel will update it, otherwise will insert. $tr = CalendarDefinitionPeer::retrieveByPK($CalendarUid); if (!(is_object($tr) && get_class($tr) == 'CalendarDefinition')) { $tr = new CalendarDefinition(); $tr->setCalendarCreateDate('now'); } $tr->setCalendarUid($CalendarUid); $tr->setCalendarName($CalendarName); $tr->setCalendarUpdateDate('now'); $tr->setCalendarDescription($CalendarDescription); $tr->setCalendarStatus($CalendarStatus); $tr->setCalendarWorkDays($CalendarWorkDays); if ($tr->validate()) { // we save it, since we get no validation errors, or do whatever else you like. $res = $tr->save(); //Calendar Business Hours Save code. //First Delete all current records $CalendarBusinessHoursObj = new CalendarBusinessHours(); $CalendarBusinessHoursObj->deleteAllCalendarBusinessHours($CalendarUid); //Save all the sent records foreach ($aData['BUSINESS_DAY'] as $key => $objData) { $objData['CALENDAR_UID'] = $CalendarUid; $CalendarBusinessHoursObj->saveCalendarBusinessHours($objData); } //Holiday Save code. //First Delete all current records $CalendarHolidayObj = new CalendarHolidays(); $CalendarHolidayObj->deleteAllCalendarHolidays($CalendarUid); //Save all the sent records foreach ($aData['HOLIDAY'] as $key => $objData) { if ($objData['CALENDAR_HOLIDAY_NAME'] != "" && $objData['CALENDAR_HOLIDAY_START'] != "" && $objData['CALENDAR_HOLIDAY_END'] != "") { $objData['CALENDAR_UID'] = $CalendarUid; $CalendarHolidayObj->saveCalendarHolidays($objData); } } } 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 ); } //return array ( 'codError' => 0, 'rowsAffected' => $res, 'message' => ''); //to do: uniform coderror structures for all classes //if ( $res['codError'] < 0 ) { // G::SendMessageText ( $res['message'] , 'error' ); //} }
public function calendarValidate($httpData) { $httpData = array_unique((array) $httpData); $message = ''; $oldName = isset($_POST['oldName']) ? $_POST['oldName'] : ''; switch ($_POST['action']) { case 'calendarName': require_once 'classes/model/CalendarDefinition.php'; $oCalendar = new CalendarDefinition(); $aCalendars = $oCalendar->getCalendarList(false, true); $aCalendarDefinitions = end($aCalendars); foreach ($aCalendarDefinitions as $aDefinitions) { if (trim($_POST['name']) == '') { $validated = false; $message = G::loadTranslation('ID_CALENDAR_INVALID_NAME'); break; } if ($aDefinitions['CALENDAR_NAME'] != $_POST['name']) { $validated = true; } else { if ($aDefinitions['CALENDAR_NAME'] != $oldName) { $validated = false; $message = G::loadTranslation('ID_CALENDAR_INVALID_NAME'); break; } } } break; case 'calendarDates': $validated = false; $message = G::loadTranslation('ID_CALENDAR_INVALID_WORK_DATES'); break; } return $message; }
public function saveCalendarInfo($aData) { $CalendarUid = $aData['CALENDAR_UID']; $CalendarName = $aData['CALENDAR_NAME']; $CalendarDescription = $aData['CALENDAR_DESCRIPTION']; $CalendarStatus = isset($aData['CALENDAR_STATUS']) ? $aData['CALENDAR_STATUS'] : "INACTIVE"; $defaultCalendars[] = '00000000000000000000000000000001'; if (in_array($aData['CALENDAR_UID'], $defaultCalendars)) { $CalendarStatus = 'ACTIVE'; $CalendarName = G::LoadTranslation('ID_DEFAULT_CALENDAR'); } $CalendarWorkDays = isset($aData['CALENDAR_WORK_DAYS']) ? implode("|", $aData['CALENDAR_WORK_DAYS']) : ""; $msgCalendarDescriptionStatus = $aData["CALENDAR_DESCRIPTION"] != "" ? ", Description: " . $aData["CALENDAR_DESCRIPTION"] . ", Status: " . ucwords(strtolower($aData["CALENDAR_STATUS"])) : ", Status: " . ucwords(strtolower($aData["CALENDAR_STATUS"])); //if exists the row in the database propel will update it, otherwise will insert. $tr = CalendarDefinitionPeer::retrieveByPK($CalendarUid); if (!(is_object($tr) && get_class($tr) == 'CalendarDefinition')) { $tr = new CalendarDefinition(); $tr->setCalendarCreateDate('now'); G::auditLog("CreateCalendar", "Calendar Name: " . $aData['CALENDAR_NAME'] . $msgCalendarDescriptionStatus); } else { G::auditLog("UpdateCalendar", "Calendar Name: " . $aData['CALENDAR_NAME'] . $msgCalendarDescriptionStatus . ", Calendar ID: (" . $CalendarUid . ") "); } $tr->setCalendarUid($CalendarUid); $tr->setCalendarName($CalendarName); $tr->setCalendarUpdateDate('now'); $tr->setCalendarDescription($CalendarDescription); $tr->setCalendarStatus($CalendarStatus); $tr->setCalendarWorkDays($CalendarWorkDays); if ($tr->validate()) { // we save it, since we get no validation errors, or do whatever else you like. $res = $tr->save(); //Calendar Business Hours Save code. //First Delete all current records $CalendarBusinessHoursObj = new CalendarBusinessHours(); $CalendarBusinessHoursObj->deleteAllCalendarBusinessHours($CalendarUid); //Save all the sent records foreach ($aData['BUSINESS_DAY'] as $key => $objData) { $objData['CALENDAR_UID'] = $CalendarUid; $CalendarBusinessHoursObj->saveCalendarBusinessHours($objData); } //Holiday Save code. //First Delete all current records $CalendarHolidayObj = new CalendarHolidays(); $CalendarHolidayObj->deleteAllCalendarHolidays($CalendarUid); //Save all the sent records foreach ($aData['HOLIDAY'] as $key => $objData) { if ($objData['CALENDAR_HOLIDAY_NAME'] != "" && $objData['CALENDAR_HOLIDAY_START'] != "" && $objData['CALENDAR_HOLIDAY_END'] != "") { $objData['CALENDAR_UID'] = $CalendarUid; $CalendarHolidayObj->saveCalendarHolidays($objData); } } } 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 ); } }
/** * Validates all modified columns of given CalendarDefinition object. * If parameter $columns is either a single column name or an array of column names * than only those columns are validated. * * NOTICE: This does not apply to primary or foreign keys for now. * * @param CalendarDefinition $obj The object to validate. * @param mixed $cols Column name or array of column names. * * @return mixed TRUE if all columns are valid or the error message of the first invalid column. */ public static function doValidate(CalendarDefinition $obj, $cols = null) { $columns = array(); if ($cols) { $dbMap = Propel::getDatabaseMap(CalendarDefinitionPeer::DATABASE_NAME); $tableMap = $dbMap->getTable(CalendarDefinitionPeer::TABLE_NAME); if (!is_array($cols)) { $cols = array($cols); } foreach ($cols as $colName) { if ($tableMap->containsColumn($colName)) { $get = 'get' . $tableMap->getColumn($colName)->getPhpName(); $columns[$colName] = $obj->{$get}(); } } } else { if ($obj->isNew() || $obj->isColumnModified(CalendarDefinitionPeer::CALENDAR_STATUS)) { $columns[CalendarDefinitionPeer::CALENDAR_STATUS] = $obj->getCalendarStatus(); } } return BasePeer::doValidate(CalendarDefinitionPeer::DATABASE_NAME, CalendarDefinitionPeer::TABLE_NAME, $columns); }
G::header('location: ../login/login'); die; break; case -1: G::SendTemporalMessage('ID_USER_HAVENT_RIGHTS_PAGE', 'error', 'labels'); G::header('location: ../login/login'); die; break; } // validating the fields $message = array(); $oldName = isset($_POST['oldName']) ? $_POST['oldName'] : ''; switch ($_POST['action']) { case 'calendarName': require_once 'classes/model/CalendarDefinition.php'; $oCalendar = new CalendarDefinition(); $aCalendars = $oCalendar->getCalendarList(false, true); // var_dump($_POST['name']); // var_dump($aCalendars); //$count = 0; $aCalendarDefinitions = end($aCalendars); // var_dump($aCalendarDefinitions); foreach ($aCalendarDefinitions as $aDefinitions) { if (trim($_POST['name']) == '') { $validated = false; $message = G::loadTranslation('ID_CALENDAR_INVALID_NAME'); break; } if ($aDefinitions['CALENDAR_NAME'] != $_POST['name']) { $validated = true; } else {
/** * Get data of a Calendar * * @param string $calendarUid Unique id of Calendar * * return array Return an array with data of a Calendar */ public function getCalendar($calendarUid) { try { //Verify data $this->throwExceptionIfNotExistsCalendar($calendarUid, $this->arrayFieldNameForException["calendarUid"]); //Get data //Set variables $calendar = new \CalendarDefinition(); $arrayTotalUsersByCalendar = $calendar->getAllCounterByCalendar("USER"); $arrayTotalProcessesByCalendar = $calendar->getAllCounterByCalendar("PROCESS"); $arrayTotalTasksByCalendar = $calendar->getAllCounterByCalendar("TASK"); //SQL $criteria = $this->getCalendarCriteria(); $criteria->add(\CalendarDefinitionPeer::CALENDAR_UID, $calendarUid, \Criteria::EQUAL); $rsCriteria = \CalendarDefinitionPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $rsCriteria->next(); $row = $rsCriteria->getRow(); $row["CALENDAR_TOTAL_USERS"] = isset($arrayTotalUsersByCalendar[$calendarUid]) ? $arrayTotalUsersByCalendar[$calendarUid] : 0; $row["CALENDAR_TOTAL_PROCESSES"] = isset($arrayTotalProcessesByCalendar[$calendarUid]) ? $arrayTotalProcessesByCalendar[$calendarUid] : 0; $row["CALENDAR_TOTAL_TASKS"] = isset($arrayTotalTasksByCalendar[$calendarUid]) ? $arrayTotalTasksByCalendar[$calendarUid] : 0; //Return return $this->getCalendarDataFromRecord($row); } catch (\Exception $e) { throw $e; } }