/**
* Implementation for 'GET' method for Rest API
*
* @param mixed $logCaseUid 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($logCaseUid = 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(LogCasesSchedulerPeer::LOG_CASE_UID);
$criteria->addSelectColumn(LogCasesSchedulerPeer::PRO_UID);
$criteria->addSelectColumn(LogCasesSchedulerPeer::TAS_UID);
$criteria->addSelectColumn(LogCasesSchedulerPeer::USR_NAME);
$criteria->addSelectColumn(LogCasesSchedulerPeer::EXEC_DATE);
$criteria->addSelectColumn(LogCasesSchedulerPeer::EXEC_HOUR);
$criteria->addSelectColumn(LogCasesSchedulerPeer::RESULT);
$criteria->addSelectColumn(LogCasesSchedulerPeer::SCH_UID);
$criteria->addSelectColumn(LogCasesSchedulerPeer::WS_CREATE_CASE_STATUS);
$criteria->addSelectColumn(LogCasesSchedulerPeer::WS_ROUTE_CASE_STATUS);
$dataset = AppEventPeer::doSelectRS($criteria);
$dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
while ($dataset->next()) {
$result[] = $dataset->getRow();
}
} else {
$record = LogCasesSchedulerPeer::retrieveByPK($logCaseUid);
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 LogCasesScheduler ({$paramValues})");
}
}
} catch (RestException $e) {
throw new RestException($e->getCode(), $e->getMessage());
} catch (Exception $e) {
throw new RestException(412, $e->getMessage());
}
return $result;
}
public function getAll()
{
$oCriteria = $this->getAllCriteria();
$oDataset = LogCasesSchedulerPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$oDataset->next();
$aRows = array();
while ($aRow = $oDataset->getRow()) {
$aRows[] = $aRow;
$oDataset->next();
}
/*foreach($aRows as $k => $aRow){
$oProcess = new Process();
$aProcessRow = $oProcess->load($aRow['PRO_UID']);
$oTask = new Task();
$aTaskRow = $oTask->load($aRow['TAS_UID']);
$aRows[$k] = array_merge($aRow, $aProcessRow, $aTaskRow);
}*/
return $aRows;
}
/**
* 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 = LogCasesSchedulerPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setLogCaseUid($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setProUid($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setTasUid($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setUsrName($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setExecDate($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setExecHour($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setResult($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setSchUid($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setWsCreateCaseStatus($arr[$keys[8]]);
}
if (array_key_exists($keys[9], $arr)) {
$this->setWsRouteCaseStatus($arr[$keys[9]]);
}
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param Connection $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(LogCasesSchedulerPeer::LOG_CASE_UID, $pks, Criteria::IN);
$objs = LogCasesSchedulerPeer::doSelect($criteria, $con);
}
return $objs;
}
$oCriteria->addSelectColumn(LogCasesSchedulerPeer::EXEC_HOUR);
$oCriteria->addSelectColumn(LogCasesSchedulerPeer::RESULT);
$oCriteria->addSelectColumn(LogCasesSchedulerPeer::SCH_UID);
$oCriteria->addSelectColumn(LogCasesSchedulerPeer::WS_CREATE_CASE_STATUS);
$oCriteria->addSelectColumn(LogCasesSchedulerPeer::WS_ROUTE_CASE_STATUS);
if ($filter != '') {
$c_or = $oCriteria->getNewCriterion(LogCasesSchedulerPeer::WS_CREATE_CASE_STATUS, '%' . $filter . '%', Criteria::LIKE)->addOr($oCriteria->getNewCriterion(LogCasesSchedulerPeer::WS_ROUTE_CASE_STATUS, '%' . $filter . '%', Criteria::LIKE));
$oCriteria->add($c_or);
}
$oDataset = LogCasesSchedulerPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$addTables = array();
while ($oDataset->next()) {
$addTables[] = $oDataset->getRow();
}
$results = count($addTables);
$oCriteria->setOffset($start);
$oCriteria->setLimit($limit);
$oCriteria->addDescendingOrderByColumn(LogCasesSchedulerPeer::EXEC_DATE);
$oCriteria->addDescendingOrderByColumn(LogCasesSchedulerPeer::EXEC_HOUR);
$oDataset = LogCasesSchedulerPeer::doSelectRS($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
//$oDataset = LogCasesSchedulerPeer::doSelectRS ( $oCriteria );
//$oDataset->setFetchmode ( ResultSet::FETCHMODE_ASSOC );
$addTables = array();
while ($oDataset->next()) {
$addTables[] = $oDataset->getRow();
}
//$oLogCasesScheduler = new LogCasesScheduler();
//$arrData = $oLogCasesScheduler->getAll();
echo '{results: ' . $results . ', rows: ' . G::json_encode($addTables) . '}';
$aFields['MESSAGE5'] = str_replace("\r\n","<br>",G::LoadTranslation('ID_MSG_ERROR_USR_LASTNAME'));
// the default role variable sets the value that will be showed as the default for the role field.
$aFields['DEFAULT_ROLE'] = 'PROCESSMAKER_OPERATOR';
$aFields['START_DATE'] = date('Y-m-d');
$aFields['END_DATE'] = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y') + 5));
$aFields['USR_DUE_DATE']= date('Y-m-d', mktime(0, 0, 0, date('m'), date('d'), date('Y') + 1));
*/
if (!class_exists('LogCasesSchedulerPeer')) {
require_once 'classes/model/LogCasesScheduler.php';
}
$G_PUBLISH = new Publisher();
$oCriteria = new Criteria('workflow');
// var_dump(htmlspecialchars($_GET['WS_ROUTE']));
// var_dump(htmlentities($_GET['WS_ROUTE']));
$oCriteria->add(LogCasesSchedulerPeer::LOG_CASE_UID, $_REQUEST['LOG_CASE_UID']);
$result = LogCasesSchedulerPeer::doSelectRS($oCriteria);
$result->next();
$row = $result->getRow();
$aFields['PRO_UID'] = $row[1];
$aFields['TAS_UID'] = $row[2];
$aFields['SCH_UID'] = $row[7];
$aFields['USR_NAME'] = $row[3];
$aFields['EXEC_DATE'] = $row[4];
$aFields['EXEC_HOUR'] = $row[5];
$aFields['RESULT'] = $row[6];
$aFields['WS_CREATE_CASE_STATUS'] = $row[8];
$aFields['WS_ROUTE_CASE_STATUS'] = htmlentities($row[9]);
//var_dump($aFields);
//$aFields = $_GET;
$G_PUBLISH->AddContent('xmlform', 'xmlform', 'cases/cases_Scheduler_Log_Detail.xml', '', $aFields, '');
G::RenderPage('publishBlank', 'blank');
