$oData = array(); foreach ($locations as $rowid => $row) { if ($row->getISUid() != '' && $row->getISName() != '') { $oData[] = array('IS_UID' => $row->getISUid(), 'IS_NAME' => $row->getISName()); } } print G::json_encode($oData); break; case 'locationList': require_once "classes/model/IsoLocation.php"; $c = new Criteria(); $country = $_POST['IC_UID']; $state = $_POST['IS_UID']; $c->add(IsoLocationPeer::IC_UID, $country, Criteria::EQUAL); $c->add(IsoLocationPeer::IS_UID, $state, Criteria::EQUAL); $locations = IsoLocationPeer::doSelect($c); $oData = array(); foreach ($locations as $rowid => $row) { if ($row->getILUid() != '' && $row->getILName() != '') { $oData[] = array('IL_UID' => $row->getILUid(), 'IL_NAME' => $row->getILName()); } } print G::json_encode($oData); break; case 'usersList': require_once 'classes/model/Users.php'; $oCriteria = new Criteria(); $oCriteria->addSelectColumn(UsersPeer::USR_UID); $oCriteria->addSelectColumn(UsersPeer::USR_USERNAME); $oCriteria->addSelectColumn(UsersPeer::USR_FIRSTNAME); $oCriteria->addSelectColumn(UsersPeer::USR_LASTNAME);
/** * Retrieve object using using composite pkey values. * @param string $ic_uid @param string $il_uid * @param Connection $con * @return IsoLocation */ public static function retrieveByPK($ic_uid, $il_uid, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(IsoLocationPeer::IC_UID, $ic_uid); $criteria->add(IsoLocationPeer::IL_UID, $il_uid); $v = IsoLocationPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }