Mpdf. Foreach does not work, to generate a pdf of a select

0

I have this code, it works for a record. then I need to do it automatically according to a select response and I put it inside a foreach, now it generates the first pdf, and then it does not get more pdfs. What can I check? This is a php 5.3 and in drupal 7.59

$pathth = drupal_get_path('theme', 'theme811');
drupal_add_css($pathth.'/css/reset.css');
drupal_add_css($pathth.'/css/destinar_reportes.css');
$sql = ("SELECT * FROM saldomensual WHERE Cedula IN ('1', '2', '3','5', '4') and fecha LIKE 'el select real trae 3000 registros'");
//print($sql.'<br>');
$result=db_query($sql);
foreach ($result as $objR) 
{
    $objR->mensaje_mensual = utf8_decode(variable_get('destinar_core_formato_mensual_msg1'));
    $objR->mensaje_footer = utf8_decode(variable_get('destinar_core_formato_mensual_msg2'));
    $ahoValor = intval($objR->valpesos) - intval($objR->totpesos);
    $cedms  = utf8_decode($objR->cedula);
    $sql = ("select * from prestamo where cedula = '".$cedms."' order by id desc" ) or die(mysql_error());

    $resultc=db_query($sql);
    $TotReg = 0;
        foreach ($resultc as $objRc) {
            $TotReg = $TotReg +1;  //select count no me funciono. me toco hacer un contador
            $htmlMov.='<tr class="ift-col-oddn">
            <td align="center">'.$objRc->fecha.'</td>
            <td align="right">'.number_format($objRc->Totalprestamo,   2,',','.').'</td>
            <td align="right">'.$objRc->cuotade.'</td>
            <td align="right">'.number_format($objRc->cuota,   2,',','.').'</td>
            <td align="right">'.number_format($objRc->saldo,2,',','.').'</td></tr>';
            }

    db_set_active('default');
    //print_r($objR);
    $tr1 = '
    <tr>
        <td style=" width:60%; vertical-align: top;">
        <table style=" width:500px; " cellspacing="5" cellpadding="3">
        <tr><td>
            <table style=" width:500px;" border="0" cellspacing="5" cellpadding="0">
              <tr>
                <td><strong>CEDULA:</strong> '.$objR->cedula.'</td>
                <td><strong>EMPRESA:</strong> '.$values[3].'</td>
              </tr>
              <tr>
                <td colspan="2"><strong>NOMBRE:</strong> '.$objR->nombre.'</td>
                </tr>
            </table>
            <table style=" width:500px;" border="1" bordercolor="#265F50" cellspacing="5" cellpadding="0" class="grid-green">
              <tr>
                <td class="ift-titulo2 ift-middle">FECHA DE</td>
                <td class="ift-titulo2 ift-middle">PORCENTAJE DE</td>
              </tr>
              <tr>
                <td>Ingreso: '.$objR->fecingreso.'</td>
                <td>Aporte Legal: '.$objR->porapoleg.'</td>
              </tr>
              <tr>
                <td>Ultimo Retiro: '.$objR->fecretiro.'</td>
                <td>Aporte Adicional: '.$objR->porapoadi.'</td>
              </tr>
            </table>
            <table style=" width:500px;" border="1" bordercolor="#265F50" cellspacing="5" cellpadding="0" class="grid-green">
              <tr>
                <td class="ift-titulo1">VALOR UNIDAD: '.number_format($objR->valorunidad, 6,',','.').'</td>
                <td class="ift-titulo1">CUOTAS: '.$objR->cuotas.'</td>
              </tr>
              <tr>
                <td colspan="2"><p>NOTAS:</p>
                  <p>'.$objR->nota.'</p></td>
                </tr>
            </table>
        </td></tr></table>
        </td>
        <td  style=" width:40%; text-align:center;">
        <table style=" width:40%; "  cellspacing="5" cellpadding="3">
                <tr>
                <td>
                <div class="ift-logo"><img src="'.$logo.'" width="258px" height="101px" /></div>
            <table width="60%" border="1" cellspacing="5" cellpadding="3" align="center">
                <tr><td colspan="2" style="text-align:center;">EXTRACTO MENSUAL</td>
                <tr><td colspan="2" class="ift-titulo2">SALDOS A</td></tr>
                <tr><td colspan="2">'.$objR->fecha.'</td></tr>
            </table><div style=" font-size:10px; width:60%; text-align:center;">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$doc_nombre_formato.'</div>
        </td></tr></table>
        </td>
    </tr>
    ';

    $tr2 = '
    <tr>
        <td colspan="2" align="center">
            <table cellspacing="5" cellpadding="3" bgcolor="#CFEFE8"><tr><td>'.$objR->mensaje_mensual.'</td></tr></table>
        </td>
    </tr>
    ';
    $tr3 = '
    <tr>
       <td align="center" colspan="2">
            <table width="650px" border="0" cellpadding="0" cellspacing="5">
            <tr>
            <td colspan="5" class="ift-titulo2">SALDO</td>
            </tr>
            <tr class="ift-col-odd">
            <td align="center"><span>CONCEPTO</span></td>
            <td align="center"><span>AHORRO EN PESOS</span></td>
            <td align="center"><span>AHORRO EN UNIDADES</span></td>
            <td align="center"><span>AJUSTE VALORIZACION EN PESOS</span></td>
            </tr>
            <tr class="ift-col-oddn"><td align="left">Aporte Legal</td>                     <td align="right">'.number_format($objR->pesoslegal, 2,',','.').'</td> <td align="right">'.number_format($objR->unidadlega, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajustelega, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Aporte Adicional</td>                 <td align="right">'.number_format($objR->pesosadici, 2,',', '.').'</td> <td align="right">'.number_format($objR->unidadadic, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajusteadic, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Aporte Extra</td>                     <td align="right">'.number_format($objR->pesosextra, 2,',','.').'</td> <td align="right">'.number_format($objR->unidadextr, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajusteextr, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Contribuci&#243;n Adicional Empresa</td>   <td align="right">'.number_format($objR->pesosadicia,2,',','.').'</td><td  align="right">'.number_format($objR->unidadadicia, 6,',','.').'</td><td align="right">'.number_format($objR->ajusteadicia, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Contribuci&#243;n Empresa</td>             <td align="right">'.number_format($objR->pesosconso, 2,',','.').'</td> <td align="right">'.number_format($objR->unidadcons, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajustecons, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Contribuci&#243;n Empresa x Consolidar</td><td align="right">'.number_format($objR->pesosxcons, 2,',','.').'</td> <td align="right">'.number_format($objR->unidadxcon, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajustexcon, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Fondo Perseverancia</td>              <td align="right">'.number_format($objR->pesosfonpe, 2,',','.').'</td> <td align="right">'.number_format($objR->unidadxfon, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajustexfon, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left">Rendimiento</td>                      <td align="right">'.number_format($objR->pesosutil, 2,',', '.').'</td> <td align="right">'.number_format($objR->unidadutil, 6,',','.').'</td>  <td align="right">'.number_format($objR->ajusteutil, 2,',','.').'</td></tr>
            <tr class="ift-col-oddn"><td align="left"><strong>Total Ahorro</strong></td>
            <td align="right"><strong>'.number_format($objR->totpesos, 2,',','.').'</strong></td><td align="right"><strong>'.number_format($objR->totunidad, 2,',','.').'</strong></td><td align="right"><strong>'.number_format($ahoValor, 2,',','.').'</strong></td></tr>
            </table>
            <hr />
       </td>
    </tr>
    ';

    $tr4 = '
        <tr>
        <td colspan="2" align="center">
        <table width="650px"  border="0" cellspacing="5" cellpadding="0">
        <tr>
        <td colspan="5" class="ift-titulo2">DETALLE DE PRESTAMOS</td>
        </tr>
        <tr class="ift-col-odd">
        <td align="center" width="20%"><span>FECHA DESEMBOLSO</span></td>
        <td align="center" width="20%"><span>VALOR DESEMBOLSADO</span></td>
        <td align="center" width="20%"><span>CUOTA NUMERO</span></td>
        <td align="center" width="20%"><span>CUOTA ACTUAL</span></td>
        <td align="center" width="20%"><span>SALDO</span></td>
        </tr>
        '.$htmlMov.'
        </table>
        <hr />
        </td>
        </tr>
        ';

    $tr5 = '
    <tr>
        <td  align="center" colspan="2" >'.$objR->mensaje_footer.'</td>
    </tr>
    ';
    //valida si no hay data. Tenia ajusteutil pero en afiliados de pocas cuotas siempre es o cambio a 
    if($objR->pesoslegal == "" || empty($objR->pesoslegal)){
        $html2 = 'Su extracto mensual de '.$values[1].' Del '.$values[0].', seg\xfan lo que escogi\xf3 en el combo. No esta disponible.';
        drupal_goto("node/119", array('query' => array('msg'=> $html2 )));
    }else{
        $html = '<table style="width:800px;" border="0" cellspacing="0" cellpadding="0">';
        $html.= $tr1;
        $html.= $tr2;
        $html.= $tr3;
        if($TotReg>0){
        $html.= $tr4;}

        $html.= $tr5;
        $html.= '</table>';
        $html2 = '<table style="width:800px; " border="0" cellspacing="0" cellpadding="0">';
        $html2.= '<tr>
        <td><img src="'.$vigila.'" width="30px" height="auto" /></td>
        <td>'.$html.'</td>
        </tr>';
        $html2.= '</table>';
        $nombrepdf = $cedms;
        $mpdf=new mPDF();
        $html3 = mb_convert_encoding($html2, 'UTF-8', 'UTF-8');
        $mpdf->WriteHTML($html3,2);
        $mpdf -> SetProtection(array('copy','print'), '1', '1');
        $mpdf -> Output('/usr/home/sitioweb/web/documentos/' . $nombrepdf.'.pdf', 'F'); 
        exit;   
    }
}

ERROR THAT COMES IN THE LOG

    
asked by nikolay 10.08.2018 в 15:02
source

0 answers