public function getParentalIndex()
{
$parentalIndex = "#" . str_pad($this->getId(), 3, '0', STR_PAD_LEFT);
$this->level = 1;
if ($this->getParent() !== null && $this->getParent() != 0) {
$p = MemberJobPeer::retrieveByPK($this->getParent());
$parentalIndex = str_pad($p->getParentalIndex(), 3, '0', STR_PAD_LEFT) . "_" . $parentalIndex;
$this->level += $p->level;
}
$this->parentalIndex = $parentalIndex;
return $parentalIndex;
}
public static function doSelectOrdered(Criteria $criteria, $con = null)
{
$tmp_depts = MemberJobPeer::doSelect($criteria);
$depts = array();
foreach ($tmp_depts 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());
$val->setCode($prefix . $val->getCode());
$depts[$pi] = $val;
}
ksort($depts);
$result = array();
foreach ($depts as $r) {
$result[] = $r;
}
return $result;
}
public function executeEdit()
{
$group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
$c = new Criteria();
$c->add(JobPeer::CODE, $this->getModuleName());
$job = JobPeer::doSelectOne($c);
$acl = AclPeer::retrieveByPK($group_id, $job->getId());
if (!$acl) {
$this->forward('default', 'error404');
}
$this->can_add = $acl->getAddPriv() == 1;
$this->can_edit = $acl->getEditPriv() == 1;
$this->can_remove = $acl->getRemovePriv() == 1;
$member_type = MemberTypePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($member_type);
$actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")));
// if ($acl->getAddPriv()) array_push($actions, array('name'=>'copy','type'=>'submit', 'options'=>array('class'=>'save_button', 'onclick'=>"action_type.value=this.value")));
if ($acl->getRemovePriv()) {
array_push($actions, array('name' => 'delete', 'url' => 'member_type/delete?id=' . $member_type->getId(), 'color' => 'red'));
}
array_push($actions, array('name' => 'cancel', 'url' => 'member_type/list', 'color' => 'black'));
$this->subtitle = $member_type->toString() . ' - id:' . $member_type->getId();
$this->type = 'edit';
$this->member_type = $member_type;
$this->forward404Unless($this->member_type);
$c = new Criteria();
$this->member_jobs = MemberJobPeer::doSelect($c);
foreach ($this->member_jobs as $member_job) {
$c = new Criteria();
$c->add(MemberJobPeer::PARENT, $member_job->getId());
$c->add(MemberJobPeer::DISPLAY_MENU, true);
$member_job->child = MemberJobPeer::doCount($c);
$c = new Criteria();
$c->add(MemberAclPeer::MEMBER_TYPE_ID, $this->member_type->getId(), Criteria::EQUAL);
$c->add(MemberAclPeer::MEMBER_JOB_ID, $member_job->getId(), Criteria::EQUAL);
$member_job->member_acl = MemberAclPeer::doSelectOne($c);
$member_job->level = $member_job->getLevel();
$member_job->order = $member_job->getMenuOrderRecursive();
}
function sortOrder($a, $b)
{
if ($a->order == $b->order) {
return 0;
}
return $a->order < $b->order ? -1 : 1;
}
usort($this->member_jobs, 'sortOrder');
$this->actions = $actions;
}
public static function doSelectJoinAll(Criteria $c, $con = null)
{
$c = clone $c;
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
MemberJobI18nPeer::addSelectColumns($c);
$startcol2 = MemberJobI18nPeer::NUM_COLUMNS - MemberJobI18nPeer::NUM_LAZY_LOAD_COLUMNS + 1;
MemberJobPeer::addSelectColumns($c);
$startcol3 = $startcol2 + MemberJobPeer::NUM_COLUMNS;
$c->addJoin(MemberJobI18nPeer::ID, MemberJobPeer::ID);
$rs = BasePeer::doSelect($c, $con);
$results = array();
while ($rs->next()) {
$omClass = MemberJobI18nPeer::getOMClass();
$cls = Propel::import($omClass);
$obj1 = new $cls();
$obj1->hydrate($rs);
$omClass = MemberJobPeer::getOMClass();
$cls = Propel::import($omClass);
$obj2 = new $cls();
$obj2->hydrate($rs, $startcol2);
$newObject = true;
for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
$temp_obj1 = $results[$j];
$temp_obj2 = $temp_obj1->getMemberJob();
if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
$newObject = false;
$temp_obj2->addMemberJobI18n($obj1);
break;
}
}
if ($newObject) {
$obj2->initMemberJobI18ns();
$obj2->addMemberJobI18n($obj1);
}
$results[] = $obj1;
}
return $results;
}
public function getMemberJob($con = null)
{
include_once 'lib/model/om/BaseMemberJobPeer.php';
if ($this->aMemberJob === null && $this->id !== null) {
$this->aMemberJob = MemberJobPeer::retrieveByPK($this->id, $con);
}
return $this->aMemberJob;
}
public function countMemberJobsRelatedByParent($criteria = null, $distinct = false, $con = null)
{
include_once 'lib/model/om/BaseMemberJobPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
$criteria->add(MemberJobPeer::PARENT, $this->getId());
return MemberJobPeer::doCount($criteria, $distinct, $con);
}
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(MemberJobPeer::ID, $pks, Criteria::IN);
$objs = MemberJobPeer::doSelect($criteria, $con);
}
return $objs;
}
