/**
* 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;
}
}
