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 {