$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;
}
