| Total Amount Required |
db->where('school_id',$this->session->userdata('school_id'));
$get=$this->db->get('payers');
foreach($get->result() as $row){
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('payment_id',$row->payment_id);
$fee_type=$this->db->get('payments_type');
foreach($fee_type->result() as $ro){
$name=$ro->name;
}
if($row->schoolars_type==2){
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('status',0);
$this->db->where('class_level',$row->class_level);
$this->db->where('category',$row->students_type);
$this->db->where('academic_year',$year);
$countt1=$this->db->count_all_results('classes');
//selecting from the register fees table
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('academic_year',$year);
$this->db->where('payer_id',$row->payer_id);
$this->db->where('payment_id',$row->payment_id);
$get_fee=$this->db->get('register_fees');
foreach($get_fee->result() as $rowf){
$total_amount1=$rowf->amount*$countt1;
// echo 'Total= '.number_format($total_amount1).'
';
echo 'Amount = '.$rowf->amount.' '. $name.' |'. $row->payment_id.' '.$row->payer_id.' '.$row->class_level.' '.$row->students_type.' '.$row->schoolars_type.' both schoolar type = '.$countt1.'
';
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('status',0);
$this->db->where('class_level',$row->class_level);
$this->db->where('category',$row->students_type);
$this->db->where('academic_year',$year);
$get_reg=$this->db->get('classes');
foreach($get_reg->result() as $reg){
echo $reg->reg_number.'
';
}
}
}else{
$total_amount2=0;
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('status',0);
$this->db->where('class_level',$row->class_level);
$this->db->where('schoolar_type',$row->schoolars_type);
$this->db->where('category',$row->students_type);
$this->db->where('academic_year',$year);
$countt2=$this->db->count_all_results('classes');
//selecting from the register fees table
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('academic_year',$year);
$this->db->where('payer_id',$row->payer_id);
$this->db->where('payment_id',$row->payment_id);
$get_feee=$this->db->get('register_fees');
foreach($get_feee->result() as $rowff){
$total_amount2=$rowff->amount*$countt2;
// echo ' Total= '.number_format($total_amount2).' '.'
';
echo 'Amount = '.$rowff->amount.' '. $name.' |'.$row->payment_id.' '.$row->payer_id.' '.$row->class_level.' '.$row->schoolars_type.' schoolar ='.$countt2.'
';
$this->db->where('school_id',$this->session->userdata('school_id'));
$this->db->where('status',0);
$this->db->where('class_level',$row->class_level);
$this->db->where('schoolar_type',$row->schoolars_type);
$this->db->where('category',$row->students_type);
$this->db->where('academic_year',$year);
$get_reg=$this->db->get('classes');
foreach($get_reg->result() as $reg){
echo $reg->reg_number.'
';
}
}
}
}
$required=$sum+ $sum1;
echo 'Tsh '. number_format(($required));
?>
|