<?php
$studentYearDebts = new StudentYearDebts();
$students = $studentYearDebts->getPaymntesBySchoolYear($data['serial_scy'], $data['serial_set'], $data['serial_crs'], $data['serial_month'], $data['serial_pcg']);
$schoolYear = SchoolYear::find($data['serial_scy']);
$schoolSetup = new SchoolSetup();
$schoolSetupInfo = $schoolSetup->getSchoolSetupInfo();
$count = 0;
$totaldebts_dbt = 0;
$payementConceptGroup = PaymentConceptGroup::find($data['serial_pcg']);
setlocale(LC_MONETARY, 'en_US');
?>
<div class="row col-md-offset-1">
    <div class=" col-md-5 col-md-offset-1">
        <div class="form-group">
        </div>
    </div>
    <div class="col-md-6">
        <div class="col-md-9 text-right">
            <div class="input-group" id="reloadPays" >
                <input class="search form-control" type="text" placeholder="Buscar">
                <div class="input-group-addon">
                    <span class="glyphicon glyphicon-search" ></span>
                </div>
            </div>
        </div>
    </div>
</div>
<table class="table table-responsive table-bordered table-hover table-striped results">
    <tr>
    <thead>
    <th>C&oacute;digo</th>
    <th>Estudiante</th>
    <th>Curso</th>
    <th>Rubro</th>
    <th>Valor</th>
    <th>Fecha de pago</th>
    <th>Comentario</th>
</tr>
</thead>
<?php
$serial_ttl = array();
$serials_cdf = array();
$serials_phy = array();
$sumTotal = 0;
?>
<tbody>
    <?php foreach($students as $key=> $student): ?>
    <tr>
        <td>
            <span class="text-muted"><?php echo $student->serial_std; ?></span>
            <?php
            $serial_ttl[$student->serial_ttl] = $student->serial_ttl;
            if (empty($student->serial_ttl)) {
                $serials_phy[$student->serial_phy]['serial_phy'] = $student->serial_phy;
                if (!empty($student->serial_cdf)) {
                    $serials_phy[$student->serial_phy]['serial_cdf'] = $student->serial_cdf;
                }
            }
            ?>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo $student->name_pct; ?></span>
        </td>
        <td class="text-right">
            <span class="text-muted"><?php echo money_format('%(#10n',$student->total_deb); ?></span>
            <?php $sumTotal+=$student->total_deb; ?>
        </td>
        <td></td>
        <td></td>
    </tr>
    <?php
    $paymentConceptDiscounts = PaymentConcept::find($student->serial_pct);
    $discounts = $paymentConceptDiscounts->getDiscountsByPaymentConcopetAsignedTM($student->serial_scy, $student->serial_std, Date('M', strtotime($student->start_date_deb)));
    ?>
    <?php foreach($discounts as $discount): ?>
    <tr>
        <td>
            <span class="text-muted"><?php echo $student->serial_std; ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($discount->name_dsc); ?></span>
        </td>
        <td class="text-right">
            <span class="text-muted">-<?php echo money_format('%(#10n',$discount->value_ydv); ?></span>
            <?php $sumTotal = ($sumTotal - $discount->value_ydv); ?>
        </td>
        <td>
        </td>
        <td>
        </td>
    </tr>
    <?php endforeach; ?>
    <?php
        $invoice = Invoice::find($student->serial_phy);
        $taxes = $invoice->getTaxes();
        ?>
        <?php foreach($taxes as $tax): ?>
        <tr>
            <td>
            <span class="text-muted"><?php echo $student->serial_std; ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?></span>
        </td>
        <td>
            <span class="text-muted"><?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?></span>
        </td>
            <td>
                <span class="text-muted">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <?php echo $tax->name_txn; ?></span>
            </td>
            <td style="text-align: right;">
                <?php $sumTotal = ($sumTotal + $tax->value_inv); ?>
                <span class="text-muted"><?php echo money_format('%(#10n',$tax->value_inv); ?></span>
            </td>
            <td></td>
            <td></td>
        </tr>
        <?php endforeach; ?>
    <?php if(!isset($students[$key+1]) || ($students[$key+1]->serial_std!==$student->serial_std)): ?>
    <?php if(is_array($serial_ttl)): ?>
    <?php
    $paymentDetailTotalInvoice = new PaymentDetailTotalInvoice();
    $paymentDetails = $paymentDetailTotalInvoice->getPaymentDetailsBySeialsTtlsArrayStartDate($serial_ttl, $student->start_date_deb);
    $serial_ttl = array();
    ?>
    <?php foreach($paymentDetails as $paymentDetail): ?>
    <tr>
        <th>
            <?php echo $student->serial_std; ?>

        </th>
        <th>
            <?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?>

        </th>
        <th>
            <?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?>

        </th>
        <th>
            Paga con  <?php echo ($paymentDetail->name_pym); ?> <?php echo $paymentDetail->name_fin; ?> -<?php echo $paymentDetail->name_ptm; ?>

        </th>
        <th class="text-right">
            -<?php echo money_format('%(#10n',$paymentDetail->amount_pdt); ?>

            <?php $sumTotal+=-$paymentDetail->amount_pdt; ?>
        </th>
        <th>
            <?php echo $paymentDetail->payment_date_pdt; ?>

        </th>
        <td class="col-md-3">
            <span class="text-muted"><?php echo $paymentDetail->comment_pdt; ?></span>
        </td>
    </tr>
    <?php endforeach; ?>
    <?php endif; ?>


    <?php if(is_array($serials_phy)): ?>
    <?php foreach($serials_phy as $serial_phy): ?>
    <?php
    $invoice = Invoice::find($serial_phy['serial_phy']);
    $paymentDetail = new PaymentDetail();
    $paymentDetails = $paymentDetail->getTotalPaisByInvoicesDetail($serial_phy['serial_phy']);
    $totalPaidPdt = 0;
    ?>
    <?php foreach($paymentDetails as $uPaymetntDetaail): ?>
    <tr>
        <th>
            <?php echo $student->serial_std; ?>

        </th>
        <th>
            <?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?>

        </th>
        <th>
            <?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?>

        </th>
        <th>
            <?php echo ($uPaymetntDetaail->name_pym); ?> 
        </th>
        <th class="text-right">
            -<?php echo money_format('%(#10n',$uPaymetntDetaail->amount_pdt); ?>

            <?php $totalPaidPdt+=$uPaymetntDetaail->amount_pdt ?>
            <?php $sumTotal+=-$uPaymetntDetaail->amount_pdt; ?> 
        </th>
        <th>
            <?php echo $uPaymetntDetaail->date_pdt; ?>

        </th>
        <th></th>
    </tr>
    <?php endforeach; ?>
    <?php if(isset($serial_phy['serial_cdf'])): ?>
    <?php
    $currentDederred = CurrentDeferred::find($serial_phy['serial_cdf']);
    ?>
    <tr>
        <th>
            <?php echo $student->serial_std; ?>

        </th>
        <th>
            <?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?>

        </th>
        <th>
            <?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?>

        </th>
        <th>
            Pago con tarjeta de cr&eacute;dito
        </th>
         <th class="text-right">
            -<?php echo money_format('%(#10n',($invoice->total_phy-$totalPaidPdt)); ?>

            <?php $sumTotal+=-($invoice->total_phy - $totalPaidPdt); ?>
        </th>
        <th>
            <?php echo $currentDederred->transaction_date_cdf; ?>

        </th>
    </tr>
    <?php endif; ?>
    <?php endforeach; ?>

    <?php
    $serials_cdf = array();
    $serials_phy = array();
    ?>
    <?php endif; ?>
    <tr>
        <th>
            <?php echo $student->serial_std; ?>

        </th>
        <th>
            <?php echo ($student->last_name_std); ?> <?php echo ($student->first_name_std); ?> <?php echo ($student->status_sty=='RETIRED'?'<span class="text-danger">(RETIRADO)</span>':''); ?>

        </th>
        <th>
            <?php echo ($student->name_lvl); ?> <?php echo ($student->name_set); ?> <?php echo ($student->name_clg); ?>

        </th>
        <th>
            Saldo por pagar
        </th>
        <th class="text-right">
            <?php echo money_format('%(#10n',$sumTotal); ?>

            <?php $sumTotal = 0; ?>
        </th>
        <th>
        </th>
        <th>
        </th>
    </tr>
    <?php endif; ?>
    <?php endforeach; ?>
    </tbody>
</table>
<?php echo HTML::style('css/common/feature-table-sm.css'); ?>

<?php echo HTML::script('js/common/feature-table.js'); ?>