case 'countryList': require_once "classes/model/IsoCountry.php"; $c = new Criteria(); $c->add(IsoCountryPeer::IC_UID, null, Criteria::ISNOTNULL); $countries = IsoCountryPeer::doSelect($c); foreach ($countries as $rowid => $row) { $oData[] = array('IC_UID' => $row->getICUid(), 'IC_NAME' => $row->getICName()); } print G::json_encode($oData); break; case 'stateList': require_once "classes/model/IsoSubdivision.php"; $c = new Criteria(); $country = $_POST['IC_UID']; $c->add(IsoSubdivisionPeer::IC_UID, $country, Criteria::EQUAL); $locations = IsoSubdivisionPeer::doSelect($c); $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);
/** * Retrieve object using using composite pkey values. * @param string $ic_uid @param string $is_uid * @param Connection $con * @return IsoSubdivision */ public static function retrieveByPK($ic_uid, $is_uid, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(IsoSubdivisionPeer::IC_UID, $ic_uid); $criteria->add(IsoSubdivisionPeer::IS_UID, $is_uid); $v = IsoSubdivisionPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }