public function loadCaseByNumber($sCaseNumber)
{
//('SELECT * FROM APP_DELEGATION WHERE APP_PROC_CODE="'.$sCaseNumber.'" ');
try {
$aCases = array();
$c = new Criteria();
$c->add(ApplicationPeer::APP_PROC_CODE, $sCaseNumber);
$rs = ApplicationPeer::doSelectRs($c);
$rs->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$rs->next();
$row = $rs->getRow();
while (is_array($row)) {
$case['APP_UID'] = $row['APP_UID'];
$case['APP_NUMBER'] = $row['APP_NUMBER'];
$case['APP_STATUS'] = $row['APP_STATUS'];
$case['PRO_UID'] = $row['PRO_UID'];
$case['APP_PARALLEL'] = $row['APP_PARALLEL'];
$case['APP_CUR_USER'] = $row['APP_CUR_USER'];
$aCases[] = $case;
$rs->next();
$row = $rs->getRow();
}
return $aCases;
} catch (exception $e) {
throw ($e);
}
}
// $docVersion;
$aFields['APP_DOC_UID'] = $oAppDocument->getAppDocUid();
//$appDocUid;
$appDocUid = $aFields['APP_DOC_UID'];
$oAppDocument->update($aFields);
//$option = 'pmDrive';
//add permissions
$criteria = new Criteria('workflow');
$criteria->addSelectColumn(ApplicationPeer::PRO_UID);
$criteria->addSelectColumn(TaskUserPeer::TAS_UID);
$criteria->addSelectColumn(TaskUserPeer::USR_UID);
$criteria->addSelectColumn(TaskUserPeer::TU_RELATION);
$criteria->add(ApplicationPeer::APP_UID, $applicationUid);
$criteria->addJoin(ApplicationPeer::PRO_UID, TaskPeer::PRO_UID, Criteria::LEFT_JOIN);
$criteria->addJoin(TaskPeer::TAS_UID, TaskUserPeer::TAS_UID, Criteria::LEFT_JOIN);
$dataset = ApplicationPeer::doSelectRs($criteria);
$dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$userPermission = array();
$case = new Cases();
while ($dataset->next()) {
$row = $dataset->getRow();
if ($row['TU_RELATION'] == 1) {
//users
$dataUser = $user->load($row['USR_UID']);
if (array_search($dataUser['USR_EMAIL'], $userPermission) === false) {
$objectPermissions = $case->getAllObjects($row['PRO_UID'], $applicationUid, $row['TAS_UID'], $row['USR_UID']);
if (array_search($appDocUid, $objectPermissions['OUTPUT_DOCUMENTS']) !== false) {
$userPermission[] = $dataUser['USR_EMAIL'];
}
}
} else {
