public function getParentRecurs($relate = array()) { $relate[] = $this->getId(); $parent = PayerTypePeer::retrieveByPk($this->getParent()); if ($parent) { $relate = $parent->getParentRecurs($relate); } return $relate; }
public static function getParents() { $parents = array(); foreach (PayerTypePeer::doSelect(new Criteria()) as $d) { if (count($d->getPayerTypesRelatedByParent()) > 0) { $parents[] = $d->getId(); } } return $parents; }
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 executeDelete() { $payer_type = PayerTypePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($payer_type); $ref_error = 0; foreach ($payer_type->getRefCountMethods() as $ref) { $method = "count" . $ref['affix']; $count = $payer_type->{$method}(); if ($count > 0) { ++$ref_error; $this->getRequest()->setError('payer_type/delete/' . sfInflector::camelize($ref['table']), $count); } } if ($ref_error > 0) { $this->getRequest()->setError('payer_type/delete', '_ERR_DELETE_ (' . $payer_type->getCode() . ' - id:' . $payer_type->getId() . ')'); } else { $payer_type->delete(); } return $this->forward('payer_type', 'list'); }
public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VStudentTypePeer::addSelectColumns($c); $startcol2 = VStudentTypePeer::NUM_COLUMNS - VStudentTypePeer::NUM_LAZY_LOAD_COLUMNS + 1; AcademicCalendarPeer::addSelectColumns($c); $startcol3 = $startcol2 + AcademicCalendarPeer::NUM_COLUMNS; PayerTypePeer::addSelectColumns($c); $startcol4 = $startcol3 + PayerTypePeer::NUM_COLUMNS; $c->addJoin(VStudentTypePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(VStudentTypePeer::PAYER_TYPE_ID, PayerTypePeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VStudentTypePeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = AcademicCalendarPeer::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->getAcademicCalendar(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVStudentType($obj1); break; } } if ($newObject) { $obj2->initVStudentTypes(); $obj2->addVStudentType($obj1); } $omClass = PayerTypePeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getPayerType(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addVStudentType($obj1); break; } } if ($newObject) { $obj3->initVStudentTypes(); $obj3->addVStudentType($obj1); } $results[] = $obj1; } return $results; }
<td width="2%" style="text-align:center; vertical-align:middle;">:</td> <td style="vertical-align:middle;"> <p class="detail" style="font-weight: bold;"> <?php echo $student->getTestApplicant() ? $student->getTestApplicant()->getCode() : '-'; ?> </p> </td> <td style="vertical-align:middle;"><label ><?php echo __('Tipe Siswa'); ?> </label></td> <td width="2%" style="text-align:center; vertical-align:middle;">:</td> <td style="vertical-align:middle;"> <?php echo my_object_select_tag($student_type, 'getPayerTypeId', PayerTypePeer::getParents(), array('related_class' => 'PayerType', 'include_blank' => true, 'peer_method' => 'doSelectFiltered')); ?> <?php echo form_error('payer_type_id'); ?> </td> </tr> <tr><td colspan="6"><div class="subtitle">Profil Siswa</div></td></tr> <tr> <td style="vertical-align:middle;"><label ><?php echo __('Short name'); ?> </label></td> <td width="2%" style="text-align:center; vertical-align:middle;">:</td>
public static function doSelectJoinAll(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VPayerTypePeer::addSelectColumns($c); $startcol2 = VPayerTypePeer::NUM_COLUMNS - VPayerTypePeer::NUM_LAZY_LOAD_COLUMNS + 1; PayerTypePeer::addSelectColumns($c); $startcol3 = $startcol2 + PayerTypePeer::NUM_COLUMNS; $c->addJoin(VPayerTypePeer::PARENT, PayerTypePeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VPayerTypePeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = PayerTypePeer::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->getPayerType(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVPayerType($obj1); break; } } if ($newObject) { $obj2->initVPayerTypes(); $obj2->addVPayerType($obj1); } $results[] = $obj1; } return $results; }
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 static function doSelectJoinAllExceptClassGroup(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VAcaCostElsePeer::addSelectColumns($c); $startcol2 = VAcaCostElsePeer::NUM_COLUMNS - VAcaCostElsePeer::NUM_LAZY_LOAD_COLUMNS + 1; PayerTypePeer::addSelectColumns($c); $startcol3 = $startcol2 + PayerTypePeer::NUM_COLUMNS; AcademicCalendarPeer::addSelectColumns($c); $startcol4 = $startcol3 + AcademicCalendarPeer::NUM_COLUMNS; AcademicCostComponentPeer::addSelectColumns($c); $startcol5 = $startcol4 + AcademicCostComponentPeer::NUM_COLUMNS; AcademicProcessPeer::addSelectColumns($c); $startcol6 = $startcol5 + AcademicProcessPeer::NUM_COLUMNS; BankAccountPeer::addSelectColumns($c); $startcol7 = $startcol6 + BankAccountPeer::NUM_COLUMNS; $c->addJoin(VAcaCostElsePeer::PAYER_TYPE_ID, PayerTypePeer::ID); $c->addJoin(VAcaCostElsePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(VAcaCostElsePeer::ACADEMIC_COST_COMPONENT_ID, AcademicCostComponentPeer::ID); $c->addJoin(VAcaCostElsePeer::ACADEMIC_PROCESS_ID, AcademicProcessPeer::ID); $c->addJoin(VAcaCostElsePeer::BANK_ACCOUNT_ID, BankAccountPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VAcaCostElsePeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = PayerTypePeer::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->getPayerType(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVAcaCostElse($obj1); break; } } if ($newObject) { $obj2->initVAcaCostElses(); $obj2->addVAcaCostElse($obj1); } $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getAcademicCalendar(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addVAcaCostElse($obj1); break; } } if ($newObject) { $obj3->initVAcaCostElses(); $obj3->addVAcaCostElse($obj1); } $omClass = AcademicCostComponentPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getAcademicCostComponent(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addVAcaCostElse($obj1); break; } } if ($newObject) { $obj4->initVAcaCostElses(); $obj4->addVAcaCostElse($obj1); } $omClass = AcademicProcessPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getAcademicProcess(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addVAcaCostElse($obj1); break; } } if ($newObject) { $obj5->initVAcaCostElses(); $obj5->addVAcaCostElse($obj1); } $omClass = BankAccountPeer::getOMClass(); $cls = Propel::import($omClass); $obj6 = new $cls(); $obj6->hydrate($rs, $startcol6); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj6 = $temp_obj1->getBankAccount(); if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) { $newObject = false; $temp_obj6->addVAcaCostElse($obj1); break; } } if ($newObject) { $obj6->initVAcaCostElses(); $obj6->addVAcaCostElse($obj1); } $results[] = $obj1; } return $results; }
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(PayerTypePeer::ID, $pks, Criteria::IN); $objs = PayerTypePeer::doSelect($criteria, $con); } return $objs; }
public function filterPayment($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(DepartmentPeer::ID, AcademicCalendarPeer::DEPARTMENT_ID); $c->addJoin(VInfaqPaymentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $column = DepartmentPeer::getTableMap()->getColumn('ID'); } elseif ($key == 'USER_NAME') { $c->addJoin(VInfaqPaymentPeer::USER_ID, UserPeer::ID); $column = UserPeer::getTableMap()->getColumn('LOGIN'); } elseif ($key == 'NAME') { $c->addJoin(VInfaqPaymentPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'CODE') { $c->addJoin(VInfaqPaymentPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('CODE'); } elseif ($key == 'STUDENT_TYPE_ID') { $c->addJoin(VInfaqPaymentPeer::STUDENT_TYPE_ID, PayerTypePeer::ID); $column = PayerTypePeer::getTableMap()->getColumn('ID'); } else { $column = VInfaqPaymentPeer::getTableMap()->getColumn($key); } $name = $column->getFullyQualifiedName(); $creoleType = $column->getCreoleType(); if ($creoleType == CreoleTypes::TIMESTAMP) { $from = $value['from']; $to = $value['to']; $c2 = null; if ($from != '' && $from != null) { $c->add($name, $from, Criteria::GREATER_EQUAL); $c2 = $c->getCriterion($name); } if ($from != '' && $from != null && $to != '' && $to != null) { $c3 = new Criterion($c, $name, $to, Criteria::LESS_EQUAL); $c2->addAnd($c3); } if (($from == '' || $from == null) && $to != '' && $to != null) { $c->add($name, $to, Criteria::LESS_EQUAL); } } else { if ($creoleType == CreoleTypes::DATE) { $from = $value['from']; $to = $value['to']; $c2 = null; if ($from != '' && $from != null) { $c->add($name, $from, Criteria::GREATER_EQUAL); $c2 = $c->getCriterion($name); } if ($from != '' && $from != null && $to != '' && $to != null) { $c3 = new Criterion($c, $name, $to, Criteria::LESS_EQUAL); $c2->addAnd($c3); } if (($from == '' || $from == null) && $to != '' && $to != null) { $c->add($name, $to, Criteria::LESS_EQUAL); } #$c->add($name, $value, Criteria::LIKE ); } else { if ($creoleType == CreoleTypes::INTEGER || $creoleType == CreoleTypes::NUMERIC || $creoleType == CreoleTypes::CHAR) { $c->add($name, $value, Criteria::EQUAL); } else { if ($creoleType == CreoleTypes::VARCHAR) { $c->add($name, "%{$value}%", Criteria::LIKE); } } } } } }
public function countPayerTypesRelatedByParent($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BasePayerTypePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(PayerTypePeer::PARENT, $this->getId()); return PayerTypePeer::doCount($criteria, $distinct, $con); }