/** * 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');