getSchoolSetupInfo(); $count = 0; $totaldebts_dbt = 0; $data = Input::all(); $payementConceptGroup = PaymentConceptGroup::find($data['serial_pcg']); $paymentConcepts = $payementConceptGroup->getPaymentConceptsBySchoolYearPaymentConceptGroup($data['serial_scy']); $typeStd = array('' => '', 'NEW' => 'NUEVO', 'OLD' => 'ANTIGUO'); $glovalVars = new GlobalVars; $month = Date('M', strtotime($data['serial_month'])); $totalInvoiced = 0; $totalForRecover = 0; $totalInvoicedDebted = 0; $totalPaid = 0; $totalPaidStudent = 0; $totalCreditNote = 0; $totalCreditCard = 0; $travelStudent = new TravelStudent(); $paids = 0; $noPaids = 0; $totalYpc = 0; $totaldiscountsDsc = 0; $studentDataCourse = new Student(); $studentsArray = array(); ?>
name_sst); ?> | |||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AÑO LECTIVO name_scy; ?> | |||||||||||||||||||||||||||||||||||||||||||||||||||||
FECHA DEL INFORME: | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Rubros description_name_pcg; ?> - Factura N0. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
DATOS DE LA MADRE | DATOS DEL PADRE | RECORRIDO/DIRECCIÓN DE ENTRADA | RECORRIDOS/DIRECCIÓN DE SALIDA | ||||||||||||||||||||||||||||||||||||||||||||||||||
# | Código | Estudiante | Curso | NUEVO/ANTIGUO | HIJO DE EMPEADO | NOMBRE | CORREO 1 | CORREO 2 | CORREO 3 | CELULAR | NOMBRE | CORREO 1 | CORREO 2 | CORREO 3 | CELULAR | RECORRIDO | CANTON | PARROQUIA | CALLE PRINCIPAL | CALLE SECUNDARIA | RECORRIDO | CANTON | PARROQUIA | CALLE PRINCIPAL | CALLE SECUNDARIA | RUBRO ASIGNADO | VALOR | DESCUENTOS | TOTAL | TOTAL PAGADO | ESTADO | ||||||||||||||||||||||
serial_std; ?> | last_name_std); ?> first_name_std); ?> | name_set); ?> name_lvl); ?> name_clg); ?> | type_std]; ?> | serial_emp)?'SI':'NO'; ?> | mother ? explode('$', $student->mother) : ''; $father = $student->father ? explode('$', $student->father) : ''; ?>payment ? explode('$', $student->payment) : ''; $studentDiscountsArray = $student->discounts ? explode('@', $student->discounts) : array(); $discountStudents = array(); foreach ($studentDiscountsArray as $studentDiscount) { $studentDiscountArray = explode('*', $studentDiscount); $studemntYearDiscopuntValues = new StudentYearDiscountValues(); $studemntYearDiscopuntValues->serial_pct = $studentDiscountArray[0]; $studemntYearDiscopuntValues->value_ydv = $studentDiscountArray[1]; $discountStudents[$studentDiscountArray[0]] = $studemntYearDiscopuntValues; } $travelPaymentConcpet = new TravelPaymentConcept; if (!empty($payment)) { $travelPaymentConcpet->name_pct = $payment[0]; $travelPaymentConcpet->value_ypc = $payment[1]; } $entrance_address = $student->entrance_address ? explode('@', $student->entrance_address) : array(); $esxit_address = $student->esxit_address ? explode('@', $student->esxit_address) : array(); ?> entrance; ?> | entrance_address): ?>exit; ?> | esxit_address): ?>name_pct; ?> name_pct; ?> | serial_pct==$paymntConeptGroupsStuden->serial_pct): ?> totalPct+=$paymntConeptGroupsStuden->total_deb; $total+= $paymntConeptGroupsStuden->total_deb; $serialPcts[$paymntConeptGroupsStuden->serial_pct] = $paymntConeptGroupsStuden->serial_pct; $serial_ttl[$paymntConeptGroupsStuden->serial_ttl] = $paymntConeptGroupsStuden->serial_ttl; if (empty($paymntConeptGroupsStuden->serial_ttl)) { $serials_phy[$paymntConeptGroupsStuden->serial_phy]['serial_phy'] = $paymntConeptGroupsStuden->serial_phy; if (!empty($paymntConeptGroupsStuden->serial_cdf)) { $serials_phy[$paymntConeptGroupsStuden->serial_phy]['serial_cdf'] = $paymntConeptGroupsStuden->serial_cdf; } } ?> value_ydv; $totalDiscounts+= $discountStudent->value_ydv; $totaldiscountsDsc+= $discountStudent->value_ydv; ?>value_ypc; ?> 0): ?> value_ypc; ?> value_ypc - $totalDiscounts ?> value_ypc; ?> | value_ypc-$totalDiscounts; ?> | getPaymentDetailsBySeialsTtlsArrayStartDateTotal($serial_ttl, $data['serial_month']); $bank = array(); ?> serial_pym==$paymentDetailTotalInvoice->serial_pym): ?> type_pym=='CARD'): ?> name_fin)): ?> serial_cdf)): ?> serial_cdf); if ($currentDeferredBanck->banck_cdf) $bank[$currentDeferredBanck->banck_cdf] = $currentDeferredBanck->banck_cdf; else $bank[$currentDeferredBanck->card_cdf] = $currentDeferredBanck->card_cdf; ?> name_fin] = $paymentDetail->name_fin; ?> amount_pdt; $totalPaidStudent+=$paymentDetail->amount_pdt; $paymentDetailTotalInvoice->totalPdt+=$paymentDetail->amount_pdt; ?> 0): ?> getTotalPaisByInvoicesDetail($serial_phy['serial_phy']); $totalPaidPdt = 0; ?> 0): ?> amount_pdt; $totalPaidStudent+=$uPaymetntDetaail->amount_pdt; $totalCreditNote+=$uPaymetntDetaail->amount_pdt; $totalPaidPdt+=$uPaymetntDetaail->amount_pdt; $sumTotal+=-$uPaymetntDetaail->amount_pdt; ?> total_phy - $totalPaidPdt); $total = $total - ($invoice->total_phy - $totalPaidPdt); $totalCreditCard+=$invoice->total_phy - $totalPaidPdt; $totalPaidStudent+=($invoice->total_phy - $totalPaidPdt); ?>0): ?> | PAGADO NO PAGADO NO PAGADO | ||||||||||||||||||||||||||||||||||||||||||
***serial_std; ?> | last_name_std); ?> first_name_std); ?> | name_set); ?> name_lvl); ?> name_clg); ?> | type_std]; ?> | serial_emp)?'SI':'NO'; ?> | last_name_grd); ?> first_name_grd); ?> | email_grd; ?> | email2_grd; ?> | email3_grd; ?> | mobile_grd; ?> | last_name_grd); ?> first_name_grd); ?> | email_grd; ?> | email2_grd; ?> | email3_grd; ?> | mobile_grd; ?> | getTravelByStudentShiftSchoolYear($student->serial_std, $data['serial_scy'], 'ENTRANCE'); $exit = $travelStudent->getTravelByStudentShiftSchoolYear($student->serial_std, $data['serial_scy'], 'EXIT'); $travelPaymentConcpet = $travelStudent->getPaymentConcpetByStudentShiftSchoolYear($student->serial_std, $data['serial_scy']); //Debug::print_r($travelPaymentConcpet); $totalDeb = 0; ?> name; ?> | name; ?> | name_pct; ?> name_pct; ?> | serial_pct==$paymntConeptGroupsStuden->serial_pct): ?> totalPct+=$paymntConeptGroupsStuden->total_deb; $total+= $paymntConeptGroupsStuden->total_deb; $totalDeb+= $paymntConeptGroupsStuden->total_deb; $totalYpc+=$totalDeb; $serialPcts[$paymntConeptGroupsStuden->serial_pct] = $paymntConeptGroupsStuden->serial_pct; $serial_ttl[$paymntConeptGroupsStuden->serial_ttl] = $paymntConeptGroupsStuden->serial_ttl; if (empty($paymntConeptGroupsStuden->serial_ttl)) { $serials_phy[$paymntConeptGroupsStuden->serial_phy]['serial_phy'] = $paymntConeptGroupsStuden->serial_phy; if (!empty($paymntConeptGroupsStuden->serial_cdf)) { $serials_phy[$paymntConeptGroupsStuden->serial_phy]['serial_cdf'] = $paymntConeptGroupsStuden->serial_cdf; } } $dsicountsStudnet = 0; ?> totalDsc+=$discountStudent->value_ydv; $total = $total - $totalnvoiceDiscounts->total_dicounts_ttl; $dsicountsStudnet = $dsicountsStudnet + $totalnvoiceDiscounts->total_dicounts_ttl; $totaldiscountsDsc = $totaldiscountsDsc + $totalnvoiceDiscounts->total_dicounts_ttl; ?>0): ?> value_ypc; ?> value_ypc ?> | 0): ?> value_ypc-$dsicountsStudnet; ?> | getPaymentDetailsBySeialsTtlsArrayStartDateTotal($serial_ttl, $data['serial_month']); $bank = array(); ?> serial_pym==$paymentDetailTotalInvoice->serial_pym): ?> type_pym=='CARD'): ?> name_fin)): ?> serial_cdf)): ?> serial_cdf); if ($currentDeferredBanck->banck_cdf) $bank[$currentDeferredBanck->banck_cdf] = $currentDeferredBanck->banck_cdf; else $bank[$currentDeferredBanck->card_cdf] = $currentDeferredBanck->card_cdf; ?> name_fin] = $paymentDetail->name_fin; ?> amount_pdt; $totalPaidStudent+=$paymentDetail->amount_pdt; $paymentDetailTotalInvoice->totalPdt+=$paymentDetail->amount_pdt; ?>0): ?> | PAGADO NO PAGADO NO PAGADO | ||||||||||||||||||||||||||||||||
TOTAL | |||||||||||||||||||||||||||||||||||||||||||||||||||||
RESUMEN | |||||||||||||||||||||||||||||||||||||||||||||||||||||
TOTAL | |||||||||||||||||||||||||||||||||||||||||||||||||||||
DESCUENTOS | |||||||||||||||||||||||||||||||||||||||||||||||||||||
VALOR FACTURADO | |||||||||||||||||||||||||||||||||||||||||||||||||||||
VALOR POR COBRAR | |||||||||||||||||||||||||||||||||||||||||||||||||||||
PAGADOS | |||||||||||||||||||||||||||||||||||||||||||||||||||||
NO PAGADOS |