public function executeShow()
{
$userid = $this->getUser()->getAttribute('userid');
$user = UserPeer::retrieveByPK($userid);
$c = new Criteria();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 0);
$this->addressh = AddressPeer::doSelectOne($c);
$c->clear();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 1);
$this->addressw = AddressPeer::doSelectOne($c);
$c->clear();
$c->add(AddressPeer::USER_ID, $user->getId());
$c->add(AddressPeer::TYPE, 2);
$this->addressp = AddressPeer::doSelectOne($c);
$this->userid = $userid;
//$this->address = AddressPeer::retrieveByPk($this->getRequestParameter('id'));
//$this->forward404Unless($this->address);
$c->clear();
$c->add(UserchapterregionPeer::USER_ID, $userid);
$this->ucrs = UserchapterregionPeer::doSelect($c);
$regions = RegionPeer::doSelect(new Criteria());
$regionlist = array();
$regionlist[] = "Select a Region";
foreach ($regions as $region) {
$regionlist[$region->getId()] = $region->getName();
}
$this->regionlist = $regionlist;
}
public static function doSelectOrdered(Criteria $criteria, $con = null)
{
$tmp_regions = RegionPeer::doSelect($criteria);
$regions = array();
foreach ($tmp_regions as $key => $val) {
$pi = $val->getParentalIndex();
$prefix = '';
for ($i = 0; $i < $val->level - 1; $i++) {
$prefix .= ParamsPeer::retrieveByCode('tree_node_mark')->getValue();
}
$val->setName($prefix . $val->getName());
$regions[$pi] = $val;
}
ksort($regions);
$result = array();
foreach ($regions as $r) {
$result[] = $r;
}
return $result;
}
public function executeList()
{
$this->regions = RegionPeer::doSelect(new Criteria());
}
public function getRegionsRelatedByParent($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseRegionPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collRegionsRelatedByParent === null) {
if ($this->isNew()) {
$this->collRegionsRelatedByParent = array();
} else {
$criteria->add(RegionPeer::PARENT, $this->getId());
RegionPeer::addSelectColumns($criteria);
$this->collRegionsRelatedByParent = RegionPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(RegionPeer::PARENT, $this->getId());
RegionPeer::addSelectColumns($criteria);
if (!isset($this->lastRegionRelatedByParentCriteria) || !$this->lastRegionRelatedByParentCriteria->equals($criteria)) {
$this->collRegionsRelatedByParent = RegionPeer::doSelect($criteria, $con);
}
}
}
$this->lastRegionRelatedByParentCriteria = $criteria;
return $this->collRegionsRelatedByParent;
}
public function executeGetList()
{
$region_name = $this->getRequestParameter('region_name');
$c = new Criteria();
$c->add(RegionPeer::NAME, "%{$region_name}%", Criteria::LIKE);
$this->rows = RegionPeer::doSelect($c);
}
public function executeRegions()
{
$c = new Criteria();
$c->addAscendingOrderByColumn(RegionPeer::NAME);
$this->regions = RegionPeer::doSelect($c);
}
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(RegionPeer::ID, $pks, Criteria::IN);
$objs = RegionPeer::doSelect($criteria, $con);
}
return $objs;
}
