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;
}
/**
* Method to do selects.
*
* @param Criteria $criteria The Criteria object used to build the SELECT statement.
* @param Connection $con
* @return array Array of selected Objects
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelect(Criteria $criteria, $con = null)
{
return LogCasesSchedulerPeer::populateObjects(LogCasesSchedulerPeer::doSelectRS($criteria, $con));
}
$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');
