public function getParentalIndex()
{
$parentalIndex = "#" . str_pad($this->getId(), 3, '0', STR_PAD_LEFT);
$this->level = 1;
if ($this->getParent() !== null && $this->getParent() != 0) {
$p = PayerTypePeer::retrieveByPK($this->getParent());
$parentalIndex = str_pad($p->getParentalIndex(), 3, '0', STR_PAD_LEFT) . "_" . $parentalIndex;
$this->level += $p->level;
}
$this->parentalIndex = $parentalIndex;
return $parentalIndex;
}
public function getPayerType($con = null)
{
include_once 'lib/model/om/BasePayerTypePeer.php';
if ($this->aPayerType === null && $this->payer_type_id !== null) {
$this->aPayerType = PayerTypePeer::retrieveByPK($this->payer_type_id, $con);
}
return $this->aPayerType;
}
public function filter($c, $filters)
{
$filters_key = array_keys($filters);
foreach ($filters_key as $key) {
$value = $filters[$key];
if ($value == '' || $value == null) {
continue;
}
if ($key == 'DEPARTMENT_ID') {
$c->addJoin(AcademicCalendarPeer::ID, StudentPeer::ACADEMIC_CALENDAR_ID);
$c->addJoin(DepartmentPeer::ID, AcademicCalendarPeer::DEPARTMENT_ID);
$column = DepartmentPeer::getTableMap()->getColumn('ID');
} elseif ($key == 'PAYER_TYPE_ID') {
$c->addJoin(StudentTypePeer::STUDENT_ID, StudentPeer::ID);
$c->addJoin(PayerTypePeer::ID, StudentTypePeer::PAYER_TYPE_ID);
$column = PayerTypePeer::getTableMap()->getColumn('ID');
} elseif ($key == 'CLASS_NAME') {
$c->addJoin(ClassGroupPeer::ID, StudentPeer::CLASS_GROUP_ID);
$column = ClassGroupPeer::getTableMap()->getColumn('NAME');
} elseif ($key == 'JOB_TITLE') {
$c->addJoin(StudentDetailPeer::ID, StudentPeer::STUDENT_DETAIL_ID);
$column = StudentDetailPeer::getTableMap()->getColumn('JOB_TITLE');
} else {
$column = StudentPeer::getTableMap()->getColumn($key);
}
$name = $column->getFullyQualifiedName();
$creoleType = $column->getCreoleType();
if ($creoleType == CreoleTypes::TIMESTAMP) {
$from = $value['from'];
$to = $value['to'];
if ($from != '' && $from != null) {
$c->add($name, $from, Criteria::GREATER_EQUAL);
}
if ($to != '' && $to != null) {
$c->add($name, $to, Criteria::LESS_EQUAL);
}
} else {
if ($creoleType == CreoleTypes::INTEGER) {
if ($name == StudentPeer::CLASS_GROUP_ID) {
$cg = ClassGroupPeer::retrieveByPK($value);
$c->add($name, $cg->getChildRecurs(), Criteria::IN);
} elseif ($name == PayerTypePeer::ID) {
$pt = PayerTypePeer::retrieveByPK($value);
$c->add($name, $pt->getChildRecurs(), Criteria::IN);
} else {
$c->add($name, $value, Criteria::EQUAL);
}
} else {
if ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) {
$c->add($name, "%{$value}%", Criteria::LIKE);
}
}
}
}
}
public function getPayerTypeRelatedByParent($con = null)
{
include_once 'lib/model/om/BasePayerTypePeer.php';
if ($this->aPayerTypeRelatedByParent === null && $this->parent !== null) {
$this->aPayerTypeRelatedByParent = PayerTypePeer::retrieveByPK($this->parent, $con);
}
return $this->aPayerTypeRelatedByParent;
}
