Пример #1
0
 function loadByCode($langId)
 {
     try {
         $oCriteria = new Criteria('workflow');
         $oCriteria->addSelectColumn(LanguagePeer::LAN_NAME);
         $oCriteria->add(LanguagePeer::LAN_ID, $langId);
         $oDataset = LanguagePeer::doSelectRS($oCriteria);
         $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
         $oDataset->next();
         $aRow = $oDataset->getRow();
         $aRow['LANGUAGE_NAME'] = $aRow['LAN_NAME'];
         if (is_array($aRow)) {
             return $aRow;
         } else {
             throw new Exception("The language '{$langId}' doesn\\'t exist!");
         }
     } catch (exception $oError) {
         throw $oError;
     }
 }
Пример #2
0
    public function findLocationByLanId($languageId)
    {
        try {
            if (!isset(self::$arrayRecord[$languageId])) {
                $criteria = new Criteria("workflow");

                $criteria->addSelectColumn(LanguagePeer::LAN_LOCATION);
                $criteria->add(LanguagePeer::LAN_ID, $languageId, Criteria::LIKE);

                $rsCriteria = LanguagePeer::doSelectRS($criteria);
                $rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC);

                $rsCriteria->next();

                self::$arrayRecord[$languageId] = $rsCriteria->getRow();
            }

            $record = self::$arrayRecord[$languageId];

            //Return
            return $record;
        } catch (Exception $e) {
            throw $e;
        }
    }
Пример #3
0
 public function findByLanName($LAN_NAME)
 {
     $oCriteria = new Criteria('workflow');
     $oCriteria->addSelectColumn(LanguagePeer::LAN_ID);
     $oCriteria->addSelectColumn(LanguagePeer::LAN_NAME);
     $oCriteria->add(LanguagePeer::LAN_NAME, $LAN_NAME, Criteria::LIKE);
     $oDataset = LanguagePeer::doSelectRS($oCriteria);
     $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
     $oDataset->next();
     return $oDataset->getRow();
 }
Пример #4
0
 /**
  * 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 LanguagePeer::populateObjects(LanguagePeer::doSelectRS($criteria, $con));
 }