public function loadByCategoryId($sCategoryUid) { $c = new Criteria('workflow'); $del = DBAdapter::getStringDelimiter(); $c->clearSelectColumns(); $c->addSelectColumn(ProcessCategoryPeer::CATEGORY_NAME); $c->add(ProcessCategoryPeer::CATEGORY_UID, $sCategoryUid); $dataset = ProcessCategoryPeer::doSelectRS($c); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); $aRow = $dataset->getRow(); return $aRow['CATEGORY_NAME']; }
function getCategoryArray() { global $oAppCache; require_once 'classes/model/ProcessCategory.php'; $category[] = array("", G::LoadTranslation("ID_ALL_CATEGORIES")); $criteria = new Criteria('workflow'); $criteria->addSelectColumn(ProcessCategoryPeer::CATEGORY_UID); $criteria->addSelectColumn(ProcessCategoryPeer::CATEGORY_NAME); $dataset = ProcessCategoryPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $dataset->next(); while ($row = $dataset->getRow()) { $category[] = array($row['CATEGORY_UID'], $row['CATEGORY_NAME']); $dataset->next(); } return $category; }
/** * creates an Application row * * @param array $aData * @return variant * */ public function createRow($aData) { $con = Propel::getConnection(ProcessPeer::DATABASE_NAME); //$con->begin(); //does not allow dual BEGIN $this->setProUid($aData['PRO_UID']); $this->setProParent($aData['PRO_PARENT']); $this->setProTime($aData['PRO_TIME']); $this->setProTimeunit($aData['PRO_TIMEUNIT']); $this->setProStatus($aData['PRO_STATUS']); $this->setProTypeDay($aData['PRO_TYPE_DAY']); $this->setProType($aData['PRO_TYPE']); $this->setProAssignment($aData['PRO_ASSIGNMENT']); $this->setProShowMap($aData['PRO_SHOW_MAP']); $this->setProShowMessage($aData['PRO_SHOW_MESSAGE']); $this->setProSubprocess(isset($aData['PRO_SUBPROCESS']) ? $aData['PRO_SUBPROCESS'] : ''); $this->setProTriDeleted(isset($aData['PRO_TRI_DELETED']) ? $aData['PRO_TRI_DELETED'] : ''); $this->setProTriCanceled(isset($aData['PRO_TRI_CANCELED']) ? $aData['PRO_TRI_CANCELED'] : ''); $this->setProTriPaused(isset($aData['PRO_TRI_PAUSED']) ? $aData['PRO_TRI_PAUSED'] : ''); $this->setProTriReassigned(isset($aData['PRO_TRI_REASSIGNED']) ? $aData['PRO_TRI_REASSIGNED'] : ''); $this->setProTriUnpaused(isset($aData['PRO_TRI_UNPAUSED']) ? $aData['PRO_TRI_UNPAUSED'] : ''); $this->setProShowDelegate($aData['PRO_SHOW_DELEGATE']); $this->setProShowDynaform($aData['PRO_SHOW_DYNAFORM']); $this->setProDerivationScreenTpl(isset($aData['PRO_DERIVATION_SCREEN_TPL']) ? $aData['PRO_DERIVATION_SCREEN_TPL'] : ''); // validate if the category exists $criteria = new Criteria('workflow'); $criteria->add(ProcessCategoryPeer::CATEGORY_UID, $aData['PRO_CATEGORY']); $ds = ProcessCategoryPeer::doSelectRS($criteria, Propel::getDbConnection('workflow_ro')); $ds->setFetchmode(ResultSet::FETCHMODE_ASSOC); $ds->next(); // if it is not set, set value as empty "No Category" if (!$ds->getRow()) { $aData['PRO_CATEGORY'] = ''; } $this->setProCategory($aData['PRO_CATEGORY']); $this->setProSubCategory($aData['PRO_SUB_CATEGORY']); $this->setProIndustry($aData['PRO_INDUSTRY']); $this->setProCreateDate($aData['PRO_CREATE_DATE']); $this->setProCreateUser($aData['PRO_CREATE_USER']); $this->setProHeight($aData['PRO_HEIGHT']); $this->setProWidth($aData['PRO_WIDTH']); $this->setProTitleX($aData['PRO_TITLE_X']); $this->setProTitleY($aData['PRO_TITLE_Y']); $this->setProDynaforms(isset($aData['PRO_DYNAFORMS']) ? is_array($aData['PRO_DYNAFORMS']) ? serialize($aData['PRO_DYNAFORMS']) : $aData['PRO_DYNAFORMS'] : ''); if ($this->validate()) { $con->begin(); $res = $this->save(); if (isset($aData['PRO_TITLE']) && trim($aData['PRO_TITLE']) != '') { $this->setProTitle($aData['PRO_TITLE']); } else { $this->setProTitle('Default Process Title'); } if (isset($aData['PRO_DESCRIPTION'])) { $this->setProDescription($aData['PRO_DESCRIPTION']); } else { $this->setProDescription('Default Process Description'); } $con->commit(); $this->memcachedDelete(); return $this->getProUid(); } else { $msg = ''; foreach ($this->getValidationFailures() as $objValidationFailure) { $msg .= $objValidationFailure->getMessage() . "<br/>"; } throw new PropelException('The row cannot be created!', new PropelException($msg)); } }
/** * Gets processCategory record, if the process had one * * @param $sProUid string for the process Uid * @return $processCategory array */ public function getProcessCategoryRow ($sProUid) { $process = ProcessPeer::retrieveByPK( $sProUid ); if ($process->getProCategory() == '') { return null; } $oCriteria = new Criteria( 'workflow' ); $oCriteria->add( ProcessCategoryPeer::CATEGORY_UID, $process->getProCategory() ); $oDataset = ProcessCategoryPeer::doSelectRS( $oCriteria ); $oDataset->setFetchmode( ResultSet::FETCHMODE_ASSOC ); $oDataset->next(); return $oDataset->getRow(); }
$pcat->save(); G::auditLog("CreateCategory", "Category Name: " . $catName); echo '{success: true}'; } catch (Exception $ex) { echo '{success: false, error: ' . $ex->getMessage() . '}'; } break; case 'checkEditCategoryName': require_once 'classes/model/ProcessCategory.php'; $catUID = $_REQUEST['cat_uid']; $catName = $_REQUEST['cat_name']; $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(ProcessCategoryPeer::CATEGORY_NAME); $oCriteria->add(ProcessCategoryPeer::CATEGORY_NAME, $catName); $oCriteria->add(ProcessCategoryPeer::CATEGORY_UID, $catUID, Criteria::NOT_EQUAL); $oDataset = ProcessCategoryPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $row = $oDataset->getRow(); $response = isset($row['CATEGORY_NAME']) ? 'false' : 'true'; echo $response; break; case 'updateCategory': try { require_once 'classes/model/ProcessCategory.php'; $catUID = $_REQUEST['cat_uid']; $catName = trim($_REQUEST['category']); $pcat = new ProcessCategory(); $pcat->setNew(false); $pcat->setCategoryUid($catUID); $pcat->setCategoryName($catName);
/** * GET return array category * * @return array */ public function getCategoryList () { $category = array (); $category[] = array ("", G::LoadTranslation( "ID_ALL_CATEGORIES" )); $criteria = new Criteria( 'workflow' ); $criteria->addSelectColumn( \ProcessCategoryPeer::CATEGORY_UID ); $criteria->addSelectColumn( \ProcessCategoryPeer::CATEGORY_NAME ); $criteria->addAscendingOrderByColumn(\ProcessCategoryPeer::CATEGORY_NAME); $dataset = \ProcessCategoryPeer::doSelectRS( $criteria ); $dataset->setFetchmode( \ResultSet::FETCHMODE_ASSOC ); $dataset->next(); while ($row = $dataset->getRow()) { $category[] = array ($row['CATEGORY_UID'],$row['CATEGORY_NAME']); $dataset->next(); } return $category; }
/** * Get data of a Category * * @param string $categoryUid Unique id of Category * @param bool $flagGetRecord Value that set the getting * * return array Return an array with data of a Category */ public function getCategory($categoryUid, $flagGetRecord = false) { try { //Verify data $this->throwExceptionIfNotExistsCategory($categoryUid, $this->arrayFieldNameForException["categoryUid"]); //Set variables if (!$flagGetRecord) { $process = new \Process(); $arrayTotalProcessesByCategory = $process->getAllProcessesByCategory(); } //Get data //SQL $criteria = $this->getCategoryCriteria(); $criteria->add(\ProcessCategoryPeer::CATEGORY_UID, $categoryUid, \Criteria::EQUAL); $rsCriteria = \ProcessCategoryPeer::doSelectRS($criteria); $rsCriteria->setFetchmode(\ResultSet::FETCHMODE_ASSOC); $rsCriteria->next(); $row = $rsCriteria->getRow(); if (!$flagGetRecord) { $row["CATEGORY_TOTAL_PROCESSES"] = isset($arrayTotalProcessesByCategory[$row["CATEGORY_UID"]]) ? (int) $arrayTotalProcessesByCategory[$row["CATEGORY_UID"]] : 0; } //Return return !$flagGetRecord ? $this->getCategoryDataFromRecord($row) : $row; } catch (\Exception $e) { throw $e; } }
/** * 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 ProcessCategoryPeer::populateObjects(ProcessCategoryPeer::doSelectRS($criteria, $con)); }