public function executeSave() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $params = array(); foreach (explode('&', $this->getRequestParameter('month_list_ser')) as $p) { $p = explode('=', $p); $params[rawurldecode($p[0])][] = rawurldecode($p[1]); } if (array_key_exists('months', $params)) { foreach ($params['months'] as $month_id) { $payment_student = new PaymentJournal(); $student = StudentPeer::retrieveByPK($this->getRequestParameter('student_id')); $c = new Criteria(); $c->add(StudentTypePeer::STUDENT_ID, $student->getId()); $stu_type = StudentTypePeer::doSelectOne($c); $cr = new Criteria(); $cton1 = $cr->getNewCriterion(AcademicCostPeer::PAYER_TYPE_ID, $stu_type->getPayerTypeId(), Criteria::IN); $cton2 = $cr->getNewCriterion(AcademicCostPeer::ACADEMIC_PROCESS_ID, 2, Criteria::IN); $cton3 = $cr->getNewCriterion(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $student->getAcademicCalendarId(), Criteria::IN); $cton4 = $cr->getNewCriterion(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $student->getAcademicCalendar()->getParent(), Criteria::IN); $cton3->addOr($cton4); $cton2->addAnd($cton3); $cton1->addAnd($cton2); $cr->add($cton1); $ac_cost = AcademicCostPeer::doSelectOne($cr); $payment_student->setPayer($this->getRequestParameter('student_id')); $payment_student->setAcademicCostId($ac_cost->getId()); $payment_student->setAcademicProcessId($ac_cost->getAcademicProcessId()); $payment_student->setAmount($ac_cost->getAmount()); $payment_student->setPaid($ac_cost->getAmount()); $payment_student->setReceivable($ac_cost->getAmount() - $ac_cost->getAmount()); $payment_student->setPaidAt($this->getRequestParameter('paid_at')); $payment_student->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); $payment_student->setPaymentModelId($this->getRequestParameter('payment_model_id')); $payment_student->setYear($this->getRequestParameter('year')); $payment_student->setMonth($month_id); $payment_student->setStatus('S'); $payment_student->save(); $amount_changed = $ac_cost->getAmount(); if ($amount_changed != 0) { $ph = new PaymentHistory(); $ph->setPaymentJournal($payment_student); $ph->setAmount($amount_changed); $ph->save(); } } } return $this->redirect('payment_student/list'); #return $this->forward('payment_student', 'preview?student_id='.$this->getRequestParameter('student_id').'&paid_at='.$this->getRequestParameter('paid_at').'&payment_model_id='.$this->getRequestParameter('payment_model_id').'&year='.$this->getRequestParameter('year')); #return $this->redirect('payment_student/preview?student_id='.$this->getRequestParameter('student_id').'&paid_at='.$this->getRequestParameter('paid_at').'&payment_model_id='.$this->getRequestParameter('payment_model_id').'&year='.$this->getRequestParameter('year')); #return $this->redirect('payment_student/list', # 'before'=>"window.open('".$this->getController()->genUrl('/payment_student/printForm'). # "?student_id='+$('student_id').value+'&paid_at='+$('paid_at').value+'&payment_model_id='+$('payment_model_id').value+'&year='+$('year').value, # 'link', # 'height=480,width=640,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,location=no,directories=no,status=no' # )") }
public function executeUpdate() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $student = StudentPeer::retrieveByPK($this->getRequestParameter('student_id')); $this->forward404Unless($student); $this->student = $student; if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $student_leave = new StudentLeave(); $student_leave->setStatus(StudentLeave::STATUS_PROPOSED); } else { $student_leave = StudentLeavePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($student_leave); $student_leave->setStatus(StudentLeave::STATUS_CANCELED); } $student_leave->setId($this->getRequestParameter('id')); $student_leave->setStudentId($this->getRequestParameter('student_id')); $student_leave->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $student_leave->save(); $stu = $student_leave->getStudent(); if ($student_leave->getStatus() == StudentLeave::STATUS_ACTIVE) { // add payment journal $job = JobPeer::retrieveByCode($this->getModuleName()); $academic_process = $job->getAcademicProcess(); $c = new Criteria(); $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, $academic_process->getId()); $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $student_leave->getAcademicCalendarId()); $costs = AcademicCostPeer::doSelect($c); foreach ($costs as $c) { $pj = new PaymentJournal(); $pj->setPayer($stu->getId()); $pj->setAcademicCost($c); $pj->setJob($job); $pj->setAmount($c->getAmount()); $pj->setPaid($c->getAmount()); $pj->setReceivable(0); $pj->setAcademicProcess($academic_process); $pj->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); $pj->save(); $ph = new PaymentHistory(); $ph->setPaymentJournal($pj); $ph->setAmount($c->getAmount()); $ph->save(); } // set student status $stu->setStatus(Student::STATUS_INACTIVE); $stu->save(); // cancelled all student course $c = new Criteria(); $c->add(StudentCoursePeer::STUDENT_ID, $stu->getId()); $c->add(StudentCoursePeer::STATUS, array(StudentCourse::STATUS_PLANNED, StudentCourse::STATUS_APPROVED, StudentCourse::STATUS_ACTIVE), Criteria::IN); $scs = StudentCoursePeer::doSelect($c); foreach ($scs as $sc) { $sc->setStatus(StudentCourse::STATUS_CANCELED); $sc->save(); } } elseif ($student_leave->getStatus() == StudentLeave::STATUS_DONE) { $stu->setStatus(Student::STATUS_ACTIVE); $stu->save(); } return $this->redirect('student_leave_s/list?student_id=' . $student->getId()); }
public function executeInsertPaymentJournal() { $student_course = StudentCoursePeer::retrieveByPK($this->getRequestParameter('id')); $stu = StudentPeer::retrieveByPK($this->getRequestParameter('student_id')); $accal = $student_course->getAcademicCalendar(); $job = JobPeer::retrieveByCode($this->getModuleName()); $academic_process = $job->getAcademicProcess(); $this->forward404Unless($student_course && $stu && $accal && $job && $academic_process); // $c = new Criteria(); // $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $accal->getId()); // $c->add(AcademicProcessPeer::CODE, $academic_process->getCode()); // $c->addJoin(AcademicProcessPeer::ID, AcademicCostPeer::ACADEMIC_PROCESS_ID); // $costs = AcademicCostPeer::doSelect($c); #$c = new Criteria(); #$c->add(StudentCoursePeer::STUDENT_ID, $stu->getId()); #$c->add(SubjectAccalPeer::ACADEMIC_CALENDAR_ID, $accal->getId()); #$c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_APPROVED); #$c->addJoin(SubjectAccalPeer::ID, StudentCoursePeer::SUBJECT_ACCAL_ID); #$scs = StudentCoursePeer::doSelect($c); $paids = $this->getRequestParameter('paid'); foreach ($paids as $key => $val) { $c = AcademicCostPeer::retrieveByPK($key); $payment_journal = new PaymentJournal(); $payment_journal->setAcademicCost($c); $payment_journal->setJob($job); $payment_journal->setPayer($stu->getId()); #$amount = 0; #if ($c->getAcademicCostComponent()->getUnit() == AcademicCostComponent::UNIT_CREDIT) { # foreach ($scs as $sc) { # $amount += $c->getAmount() * $sc->getSubjectAccal()->getSubject()->getCredit(); # } #} elseif ($c->getAcademicCostComponent()->getUnit() == AcademicCostComponent::UNIT_SUBJECT) { # foreach ($scs as $sc) { # $amount += $c->getAmount(); # } #} else { $amount = $c->getAmount(); #} $payment_journal->setAmount($amount); $payment_journal->setPaid($val); $payment_journal->setReceivable($amount - $val); $payment_journal->setAcademicProcess($academic_process); $payment_journal->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); if ($amount - $val == 0) { $payment_journal->setStatus('S'); } elseif ($amount - $val > 0) { $payment_journal->setStatus('M'); } elseif ($amount - $val < 0) { $payment_journal->setStatus('P'); } $payment_journal->save(); $ph = new PaymentHistory(); $ph->setPaymentJournal($payment_journal); $ph->setAmount($val); $ph->save(); } // activate all paid credit if ($this->hasRequestParameter('status[student_course]') && $this->getRequestParameter('status[student_course]') == 1) { $c = new Criteria(); $c->add(StudentCoursePeer::STUDENT_ID, $stu->getId()); $c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_APPROVED); $approved_scs = StudentCoursePeer::doSelect($c); foreach ($approved_scs as $asc) { $asc->setStatus(StudentCourse::STATUS_ACTIVE); $asc->save(); } } // change student status to active if ($this->hasRequestParameter('status[student]') && $this->getRequestParameter('status[student]') == Student::STATUS_ACTIVE) { $stu->setStatus(Student::STATUS_ACTIVE); $stu->setAcademicCalendarId($accal->getId()); $stu->save(); } return $this->redirect('student_course/list?student_id=' . $stu->getId()); }
public function savePaymentHistory($client_id, $payment_amount, $paid_date, $employee_id, $note) { $payment_id = 0; if ($payment_amount != 0) { $payment_history = new PaymentHistory(); $payment_history->client_id = $client_id; $payment_history->payment_amount = $payment_amount; $payment_history->date_paid = $paid_date; $payment_history->note = $note; $payment_history->employee_id = $employee_id; $payment_history->save(); $payment_id = $payment_history->id; } return $payment_id; }
public function executeUpdate() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $comprehensive_exam = new ComprehensiveExam(); } else { $comprehensive_exam = ComprehensiveExamPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($comprehensive_exam); } $comprehensive_exam->setId($this->getRequestParameter('id')); $comprehensive_exam->setStudentId($this->getRequestParameter('student_id')); if ($this->getRequestParameter('exam_date')) { $comprehensive_exam->setExamDate($this->getRequestParameter('exam_date')); } $comprehensive_exam->setStatus($this->getRequestParameter('status')); $comprehensive_exam->save(); $c = new Criteria(); $c->add(ComprehensiveReviewerPeer::COMPREHENSIVE_EXAM_ID, $comprehensive_exam->getId()); ComprehensiveReviewerPeer::doDelete($c); $reviewers = $this->getRequestParameter('isSelected'); if ($reviewers) { foreach ($reviewers as $id) { $cr = new ComprehensiveReviewer(); $cr->setComprehensiveExam($comprehensive_exam); $cr->setEmployeeId($id); $cr->save(); } } if ($comprehensive_exam->getStatus() == ComprehensiveExam::STATUS_ACTIVE) { // add payment journal $job = JobPeer::retrieveByCode($this->getModuleName()); $academic_process = $job->getAcademicProcess(); $c = new Criteria(); $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, $academic_process->getId()); $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $comprehensive_exam->getAcademicCalendarId()); $costs = AcademicCostPeer::doSelect($c); foreach ($costs as $c) { $pj = new PaymentJournal(); $pj->setPayer($comprehensive_exam->getStudent()->getId()); $pj->setAcademicCost($c); $pj->setJob($job); $pj->setAmount($c->getAmount()); $pj->setPaid($c->getAmount()); $pj->setReceivable(0); $pj->setAcademicProcess($academic_process); $pj->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); $pj->save(); $ph = new PaymentHistory(); $ph->setPaymentJournal($pj); $ph->setAmount($pj->getPaid()); $ph->save(); } } elseif ($comprehensive_exam->getStatus() == ComprehensiveExam::STATUS_PASSED) { $s = $comprehensive_exam->getStudent(); $s->setStatus(Student::STATUS_GRADUATE); $s->save(); $gc = new GradCeremony(); $gc->setStudent($s); $gc->setStatus(GradCeremony::STATUS_UNLISTED); $gc->setAcademicCalendarId($comprehensive_exam->getAcademicCalendarId()); $gc->save(); } return $this->redirect('comprehensive_exam/list'); }
public function executeSaveElse() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $student = StudentPeer::retrieveByPk($this->getRequestParameter('student_id')); $this->forward404Unless($student); $payment_journal = PaymentJournalPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($payment_journal); $is_new = false; $amount_changed = $this->getRequestParameter('paid'); $payment_journal->setId($this->getRequestParameter('id')); $payment_journal->setPayer($student->getId()); $payment_journal->setAcademicCostId($this->getRequestParameter('academic_cost_id')); $ac_cost = AcademicCostPeer::retrieveByPK($this->getRequestParameter('academic_cost_id')); $payment_journal->setAcademicProcessId($ac_cost->getAcademicProcessId()); $payment_journal->setMonth($this->getRequestParameter('month')); $payment_journal->setYear($this->getRequestParameter('year')); $payment_journal->setAmount($this->getRequestParameter('amount')); $payment_journal->setPaid($this->getRequestParameter('paid1') + $this->getRequestParameter('paid')); $payment_journal->setReceivable($this->getRequestParameter('receivable')); $payment_journal->setStatus($this->getRequestParameter('status')); $payment_journal->setComments($this->getRequestParameter('comments')); $payment_journal->setPaidAt($this->getRequestParameter('paid_at')); $payment_journal->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); $payment_journal->setPaymentModelId($this->getRequestParameter('payment_model_id')); $payment_journal->save(); if ($amount_changed != 0) { $ph = new PaymentHistory(); $ph->setPaymentJournal($payment_journal); $ph->setAmount($amount_changed); $ph->setReceivable($payment_journal->getReceivable()); $ph->setStatus($payment_journal->getStatus()); $ph->setAcademicCostId($payment_journal->getAcademicCostId()); $ph->setMonth($payment_journal->getMonth()); $ph->setCredit($payment_journal->getMonth()); $ph->save(); } return $this->redirect('student_payment/listElse?student_id=' . $student->getId()); }
public function executeUpdate() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $grad_ceremony = new GradCeremony(); } else { $grad_ceremony = GradCeremonyPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($grad_ceremony); } $old_status = $grad_ceremony->getStatus(); $grad_ceremony->setId($this->getRequestParameter('id')); $grad_ceremony->setStudentId($this->getRequestParameter('student_id')); $grad_ceremony->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $grad_ceremony->setStatus($this->getRequestParameter('status')); $grad_ceremony->save(); if ($grad_ceremony->getStatus() != $old_status && $grad_ceremony->getStatus() == GradCeremony::STATUS_ENROLLED) { // add payment journal $job = JobPeer::retrieveByCode($this->getModuleName()); $academic_process = $job->getAcademicProcess(); $c = new Criteria(); $c->add(AcademicCostPeer::ACADEMIC_PROCESS_ID, $academic_process->getId()); $c->add(AcademicCostPeer::ACADEMIC_CALENDAR_ID, $grad_ceremony->getAcademicCalendarId()); $costs = AcademicCostPeer::doSelect($c); foreach ($costs as $c) { $pj = new PaymentJournal(); $pj->setPayer($grad_ceremony->getStudent()->getId()); $pj->setAcademicCost($c); $pj->setJob($job); $pj->setAmount($c->getAmount()); $pj->setPaid($c->getAmount()); $pj->setReceivable(0); $pj->setAcademicProcess($academic_process); $pj->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); $pj->save(); $ph = new PaymentHistory(); $ph->setPaymentJournal($pj); $ph->setAmount($pj->getPaid()); $ph->save(); } } return $this->redirect('grad_ceremony/list'); }
public function storeStudent() { $cre = ["first_group" => Input::get('first_group'), 'name' => Input::get('name'), 'dob' => Input::get('dob'), 'gender' => Input::get('gender'), 'father_name' => Input::get('father_name'), 'month_plan' => Input::get('month_plan'), 'dor' => Input::get('dor'), 'doe' => Input::get('doe'), 'dos' => Input::get('dos')]; $rules = ["first_group" => 'required', 'name' => 'required', 'dob' => 'required', 'gender' => 'required', 'father_name' => 'required', 'month_plan' => 'required', 'dor' => 'required', 'doe' => 'required', 'dos' => 'required']; $validator = Validator::make($cre, $rules); if ($validator->passes()) { $student = new Student(); $student->name = Input::get('name'); $student->dob = Input::get('dob'); $student->gender = Input::get('gender'); $student->first_group = Input::get('first_group'); $student->dos = Input::get('dos'); $student->doe = Input::get('doe'); $student->added_by = Auth::User()->id; $student->add_date = strtotime("now"); $student->save(); $student_details = new StudentDetails(); $student_details->student_id = $student->id; $student_details->school = Input::get('school_name'); $student_details->status_email = Input::get('status_email'); $student_details->status_mob = Input::get('status_mob'); $student_details->father = Input::get('father_name'); $student_details->mother = Input::get('mother'); $student_details->father_mob = Input::get('father_mob'); $student_details->father_email = Input::get('father_email'); $student_details->mother_mob = Input::get('mother_mob'); $student_details->mother_email = Input::get('mother_email'); $student_details->address = Input::get('address'); $student_details->city = Input::get('city'); $student_details->state = Input::get('state'); if (Input::hasFile('picture')) { $picture = Input::file('picture'); $filename = Input::file('picture')->getClientOriginalName(); Input::file('picture')->move('uploads/', 'st_' . $filename); $student_details->pic = 'st_' . $filename; } $student_details->father_status_email = Input::get('father_status_email'); $student_details->father_status_mob = Input::get('father_status_mob'); $student_details->mother_status_mob = Input::get('mother_status_mob'); $student_details->mother_status_email = Input::get('mother_status_email'); $student_details->save(); $payment = new PaymentHistory(); $payment->student_id = $student->id; $payment->dos = Input::get('dos'); $payment->dor = Input::get('dor'); $payment->doe = Input::get('doe'); $payment->reg_fee = Input::get('reg_fee'); $payment->sub_fee = Input::get('sub_fee'); $payment->kit_fee = Input::get('kit_fee'); $payment->amount = Input::get('amount'); $payment->months = Input::get('month_plan'); $payment->adjustment = Input::get('adjustment'); $payment->p_remark = Input::get('p_remark'); $payment->a_remark = Input::get('a_remark'); $payment->date = strtotime("now"); $payment->payment_mode = Input::get('payment_mode'); $payment->save(); return Redirect::Back()->with('success', 'New Student Added Successfully'); } return "error"; }
public function executeUpdate() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $amount_changed = 0; if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $payment = new PaymentJournal(); $amount_changed = $this->getRequestParameter('paid'); } else { $payment = PaymentJournalPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($payment); $is_new = false; $amount_changed = $this->getRequestParameter('paid') - $payment->getPaid(); } $payment->setId($this->getRequestParameter('id')); $payment->setPayer($this->getRequestParameter('payer')); $payment->setAcademicCostId($this->getRequestParameter('academic_cost_id')); $payment->setJobId($this->getRequestParameter('job_id')); $ac_cost = AcademicCostPeer::retrieveByPK($this->getRequestParameter('academic_cost_id')); $payment->setAcademicProcessId($ac_cost->getAcademicProcessId()); $payment->setAmount($this->getRequestParameter('amount')); $payment->setPaid($this->getRequestParameter('paid')); $payment->setReceivable($this->getRequestParameter('amount') - $this->getRequestParameter('paid')); $payment->setStatus($this->getRequestParameter('status')); $payment->setComments($this->getRequestParameter('comments')); $payment->setPaidAt($this->getRequestParameter('paid_at')); $payment->setPayerType(PaymentJournal::PAYER_TYPE_STUDENT); /* if ($this->getRequestParameter('amount')-$this->getRequestParameter('paid') == 0) { $payment->setStatus('S'); } elseif ($this->getRequestParameter('amount')-$this->getRequestParameter('paid') > 0) { $payment->setStatus('M'); } elseif ($this->getRequestParameter('amount')-$this->getRequestParameter('paid') < 0) { $payment->setStatus('P'); } */ $payment->save(); if ($amount_changed != 0) { $ph = new PaymentHistory(); $ph->setPaymentJournal($payment); $ph->setAmount($amount_changed); $ph->save(); } return $this->redirect('payment/list'); }