function loadAbeRequest($AbeRequestsUid) { require_once 'classes/model/AbeRequests.php'; $criteria = new Criteria(); $criteria->add(AbeRequestsPeer::ABE_REQ_UID, $AbeRequestsUid); $resultRequests = AbeRequestsPeer::doSelectRS($criteria); $resultRequests->setFetchmode(ResultSet::FETCHMODE_ASSOC); $resultRequests->next(); $abeRequests = $resultRequests->getRow(); return $abeRequests; }
/** * * @url GET /viewForm */ public function viewForm($params) { //coment if (!isset($_REQUEST['REQ_UID'])) { $_REQUEST['REQ_UID'] = ''; } $criteria = new Criteria(); $criteria->addSelectColumn(AbeConfigurationPeer::ABE_UID); $criteria->addSelectColumn(AbeConfigurationPeer::PRO_UID); $criteria->addSelectColumn(AbeConfigurationPeer::TAS_UID); $criteria->addSelectColumn(AbeConfigurationPeer::DYN_UID); $criteria->addSelectColumn(AbeConfigurationPeer::ABE_ACTION_FIELD); $criteria->addSelectColumn(AbeRequestsPeer::ABE_REQ_UID); $criteria->addSelectColumn(AbeRequestsPeer::APP_UID); $criteria->addSelectColumn(AbeRequestsPeer::DEL_INDEX); $criteria->addSelectColumn(AbeResponsesPeer::ABE_RES_UID); $criteria->addSelectColumn(AbeResponsesPeer::ABE_RES_DATA); $criteria->add(AbeRequestsPeer::ABE_REQ_UID, $_REQUEST['REQ_UID']); $criteria->addJoin(AbeRequestsPeer::ABE_UID, AbeConfigurationPeer::ABE_UID); $criteria->addJoin(AbeResponsesPeer::ABE_REQ_UID, AbeRequestsPeer::ABE_REQ_UID); $resultRes = AbeRequestsPeer::doSelectRS($criteria); $resultRes->setFetchmode(ResultSet::FETCHMODE_ASSOC); $resultRes->next(); $dataRes = Array(); $message = 'The user has not responded to this request.'; if ($dataRes = $resultRes->getRow()) { $_SESSION['CURRENT_DYN_UID'] = trim($dataRes['DYN_UID']); $dynaform = new Form($dataRes['PRO_UID'] . PATH_SEP . trim($dataRes['DYN_UID']), PATH_DYNAFORM, SYS_LANG, false); $dynaform->mode = 'view'; if ($dataRes['ABE_RES_DATA'] != '') { $value = unserialize($dataRes['ABE_RES_DATA']); if (is_array($value)) { $dynaform->values = $value; foreach ($dynaform->fields as $fieldName => $field) { if ($field->type == 'submit') { unset($dynaform->fields[$fieldName]); } } $message = $dynaform->render(PATH_CORE . 'templates/xmlform.html', $scriptCode); } else { $response = $dynaform->render(PATH_CORE . 'templates/xmlform.html', $scriptCode); $field = $dynaform->fields[$dataRes['ABE_ACTION_FIELD']]; $message = '<b>Type: </b>' . $field->type . '<br>'; switch ($field->type) { case 'dropdown': case 'radiogroup': $message .=$field->label . ' - '; $message .= $field->options[$value]; break; case 'yesno': $message .= '<b>' . $field->label . ' </b>- '; $message .= ($value == 1) ? 'Yes' : 'No'; break; case 'checkbox': $message .= '<b>' . $field->label . '</b> - '; $message .= ($value == 'On') ? 'Check' : 'Uncheck'; break; } } } } return $message; }
/** * 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 AbeRequestsPeer::populateObjects(AbeRequestsPeer::doSelectRS($criteria, $con)); }