public function getAll($start = 0, $limit = 20, $filter = '', $process = null) { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_UID); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_NAME); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_DESCRIPTION); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_TYPE); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_TAG); $oCriteria->addSelectColumn(AdditionalTablesPeer::PRO_UID); $oCriteria->addSelectColumn(AdditionalTablesPeer::DBS_UID); if (isset($process)) { foreach ($process as $key => $pro_uid) { if ($key == 'equal') { $oCriteria->add(AdditionalTablesPeer::PRO_UID, $pro_uid, Criteria::EQUAL); } else { $oCriteria->add(AdditionalTablesPeer::PRO_UID, $pro_uid, Criteria::NOT_EQUAL); } } } if ($filter != '' && is_string($filter)) { $oCriteria->add( $oCriteria->getNewCriterion(AdditionalTablesPeer::ADD_TAB_NAME, '%' . $filter . '%', Criteria::LIKE)->addOr( $oCriteria->getNewCriterion(AdditionalTablesPeer::ADD_TAB_DESCRIPTION, '%' . $filter . '%', Criteria::LIKE)) ); } if (isset($_POST['sort'])) { if ($_POST['dir'] == 'ASC') { eval('$oCriteria->addAscendingOrderByColumn(AdditionalTablesPeer::' . $_POST['sort'] . ');'); } else { eval('$oCriteria->addDescendingOrderByColumn(AdditionalTablesPeer::' . $_POST['sort'] . ');'); } } else { $oCriteria->addAscendingOrderByColumn(AdditionalTablesPeer::ADD_TAB_NAME); } $criteriaCount = clone $oCriteria; $count = AdditionalTablesPeer::doCount($criteriaCount); $oCriteria->setLimit($limit); $oCriteria->setOffset($start); $oDataset = AdditionalTablesPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $addTables = Array(); $proUids = Array(); while ($oDataset->next()) { $row = $oDataset->getRow(); $row['PRO_TITLE'] = $row['PRO_DESCRIPTION'] = ''; $addTables[] = $row; if ($row['PRO_UID'] != '') { $proUids[] = $row['PRO_UID']; } } //process details will have the info about the processes $procDetails = Array(); if (count($proUids) > 0) { //now get the labels for all process, using an array of Uids, $c = new Criteria('workflow'); //$c->add ( ContentPeer::CON_CATEGORY, 'PRO_TITLE', Criteria::EQUAL ); $c->add(ContentPeer::CON_LANG, defined('SYS_LANG') ? SYS_LANG : 'en', Criteria::EQUAL); $c->add(ContentPeer::CON_ID, $proUids, Criteria::IN); $dt = ContentPeer::doSelectRS($c); $dt->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($dt->next()) { $row = $dt->getRow(); $procDetails[$row['CON_ID']][$row['CON_CATEGORY']] = $row['CON_VALUE']; } foreach ($addTables as $i => $addTable) { if (isset($procDetails[$addTable['PRO_UID']]['PRO_TITLE'])) { $addTables[$i]['PRO_TITLE'] = $procDetails[$addTable['PRO_UID']]['PRO_TITLE']; } if (isset($procDetails[$addTable['PRO_UID']]['PRO_DESCRIPTION'])) { $addTables[$i]['PRO_DESCRIPTION'] = $procDetails[$addTable['PRO_UID']]['PRO_DESCRIPTION']; } } } return array('rows' => $addTables, 'count' => $count); }
public function exportList() { require_once 'classes/model/AdditionalTables.php'; $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_UID); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_NAME); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_DESCRIPTION); $oCriteria->addSelectColumn("'" . G::LoadTranslation('ID_ACTION_EXPORT') . "' as 'CH_SCHEMA'"); $oCriteria->addSelectColumn("'" . G::LoadTranslation('ID_ACTION_EXPORT') . "' as 'CH_DATA'"); $uids = explode(',', $_GET['id']); foreach ($uids as $UID) { if (!isset($CC)) { $CC = $oCriteria->getNewCriterion(AdditionalTablesPeer::ADD_TAB_UID, $UID, Criteria::EQUAL); } else { $CC->addOr($oCriteria->getNewCriterion(AdditionalTablesPeer::ADD_TAB_UID, $UID, Criteria::EQUAL)); } } $oCriteria->add($CC); $oCriteria->addAnd($oCriteria->getNewCriterion(AdditionalTablesPeer::ADD_TAB_UID, '', Criteria::NOT_EQUAL)); $oDataset = AdditionalTablesPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $addTables = array(); while ($oDataset->next()) { $addTables[] = $oDataset->getRow(); } return $addTables; }
public function reportTableDeleteRecord($applicationUid) { $criteria1 = new Criteria("workflow"); //SELECT $criteria1->addSelectColumn(ApplicationPeer::PRO_UID); //FROM //WHERE $criteria1->add(ApplicationPeer::APP_UID, $applicationUid); //QUERY $rsCriteria1 = ApplicationPeer::doSelectRS($criteria1); $rsCriteria1->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rsCriteria1->next(); $row1 = $rsCriteria1->getRow(); $processUid = $row1["PRO_UID"]; $criteria2 = new Criteria("workflow"); //SELECT $criteria2->addSelectColumn(AdditionalTablesPeer::ADD_TAB_NAME); //FROM //WHERE $criteria2->add(AdditionalTablesPeer::PRO_UID, $processUid); //QUERY $rsCriteria2 = AdditionalTablesPeer::doSelectRS($criteria2); $rsCriteria2->setFetchmode(ResultSet::FETCHMODE_ASSOC); G::LoadClass("pmTable"); $pmTable = new PmTable(); while ($rsCriteria2->next()) { try { $row2 = $rsCriteria2->getRow(); $tableName = $row2["ADD_TAB_NAME"]; $pmTableName = $pmTable->toCamelCase($tableName); //DELETE require_once (PATH_WORKSPACE . "classes" . PATH_SEP . "$pmTableName.php"); $criteria3 = new Criteria("workflow"); eval("\$criteria3->add(" . $pmTableName . "Peer::APP_UID, \$applicationUid);"); eval($pmTableName . "Peer::doDelete(\$criteria3);"); } catch (Exception $e) { throw $e; } } }
* along with this program. If not, see <http://www.gnu.org/licenses/>. * * For more information, contact Colosa Inc, 2566 Le Jeune Rd., * Coral Gables, FL, 33134, USA, or email info@colosa.com. */ if (($RBAC_Response = $RBAC->userCanAccess("PM_FACTORY")) != 1) { return $RBAC_Response; } //G::genericForceLogin( 'WF_MYINFO' , 'login/noViewPage', $urlLogin = '******' ); require_once 'classes/model/Dynaform.php'; require_once 'classes/model/AdditionalTables.php'; $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_UID); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_NAME); $oCriteria->add(AdditionalTablesPeer::ADD_TAB_UID, '', Criteria::NOT_EQUAL); $oDataset = AdditionalTablesPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $aTablesList = array(); array_push($aTablesList, array('ADD_TAB_UID' => '', 'ADD_TAB_NAME' => '----------------')); while ($oDataset->next()) { array_push($aTablesList, $oDataset->getRow()); } $filedNames = array("ADD_TAB_UID", "ADD_TAB_NAME"); $aTablesList = array_merge(array($filedNames), $aTablesList); $_DBArray['ADDITIONAL_TABLES'] = $aTablesList; $_SESSION['_DBArray'] = $_DBArray; $dynUid = isset($_GET['DYN_UID']) ? urldecode($_GET['DYN_UID']) : ''; $dynaform = new dynaform(); if ($dynUid == '') { $aFields['DYN_UID'] = $dynUid; } else {
/** * Return the Additional PM tables list created by user * @return object **/ public function getExtAdditionalTablesList($sTab_UID = '') { $aAdditionalTables = array(); $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_UID); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_NAME); $oCriteria->addSelectColumn(AdditionalTablesPeer::ADD_TAB_DESCRIPTION); $oCriteria->add(AdditionalTablesPeer::ADD_TAB_UID, '', Criteria::NOT_EQUAL); $oDataset = AdditionalTablesPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); while ($aRow = $oDataset->getRow()) { $aAdditionalTables[] = array('ADD_TAB_UID' => $aRow['ADD_TAB_UID'], 'ADD_TAB_NAME' => $aRow['ADD_TAB_NAME'], 'ADD_TAB_DESCRIPTION' => $aRow['ADD_TAB_DESCRIPTION']); $oDataset->next(); } return $aAdditionalTables; }
/** * 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 AdditionalTablesPeer::populateObjects(AdditionalTablesPeer::doSelectRS($criteria, $con)); }
/** * Validate Report Table Connection * @var string $rep_tab_connection. Connection for report table * @var string $pro_uid. Uid for process * * @author Brayan Pereyra (Cochalo) <*****@*****.**> * @copyright Colosa - Bolivia * * @return string */ public function validateRepConnection($rep_tab_connection, $pro_uid) { $rep_tab_connection = trim($rep_tab_connection); if ($rep_tab_connection == '') { throw new \Exception("The property rep_tab_connection: '{$rep_tab_connection}' is incorrect."); } $connections = array('workflow', 'rp'); $oCriteria = new \Criteria('workflow'); $oCriteria->addSelectColumn(\DbSourcePeer::DBS_UID); $oCriteria->add(\DbSourcePeer::PRO_UID, $pro_uid, \Criteria::EQUAL); $oDataset = \AdditionalTablesPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(\ResultSet::FETCHMODE_ASSOC); while ($oDataset->next()) { $row = $oDataset->getRow(); $connections[] = $row['DBS_UID']; } if (!in_array($rep_tab_connection, $connections)) { throw new \Exception("The property rep_tab_connection: '{$rep_tab_connection}' is incorrect."); } return $rep_tab_connection; }