crm.twinpol.com/modules/EcmPaymentStates/rap2.php

<?php 
$id=array();
$ids=explode(',',$_REQUEST['idToPdf']);
foreach ($ids as $key){
    if($ids[$key]!=''){
        $id=$ids[$key];
    }
}
$db=$GLOBALS['db'];
$zap=$db->query("
select 
    a.name,
        a.id,
    a.index_dbf,
	a.ks_account,
    (sum(CASE
        WHEN t.type = 1 and t.settled!=1  THEN t.value else 0
    END)-
    sum(CASE
        WHEN t.type = 0 and t.settled!=1  THEN t.value else 0
    END)) as saldo,
   (sum(CASE
        WHEN t.type = 1 and t.settled!=1 and t.payment_date< now() then t.value else 0
    END)-
    sum(CASE
        WHEN t.type = 0 and t.settled!=1 and t.payment_date< now() THEN t.value else 0
    END)) as zaleglosc
from
    accounts a
        inner join
    ecmtransactions t ON t.parent_id = a.id
where
    a.id in ('".implode("','",$ids)."')
group by a.id order by a.index_dbf");
$wynik=array();
while($dane=$db->fetchByAssoc($zap)){
    $tmp=array();
    if($dane['saldo']=='0.00')continue;
    $wynik[$dane['index_dbf']]['name']=$dane['name'];
    $wynik[$dane['index_dbf']]['index_dbf']=$dane['index_dbf'];
    $wynik[$dane['index_dbf']]['saldo']=$dane['saldo'];
    $wynik[$dane['index_dbf']]['zaleglosc']=$dane['zaleglosc'];
    $wynik[$dane['index_dbf']]['ksac']=$dane['ks_account'];

  

    $zap2=$db->query("select name,value,payment_date,type from ecmtransactions where parent_id='".$dane['id']."' and settled!=1");
    while($dane2=$db->fetchByAssoc($zap2)){
        $tmp=array();
        $tmp['name']=$dane2['name'];
        $tmp['value']=$dane2['value'];
        $tmp['payment_date']=$dane2['payment_date'];
        $tmp['type']=$dane2['type'];
        $wynik[$dane['index_dbf']]['poz'][]=$tmp;
    }
}

?>
<style>
.boldtable, .boldtable TD, .boldtable TH
{
font-family:sans-serif;
font-size:8pt;
border-collapse: collapse;

}
tr.separated td {
    /* set border style for separated rows */
    border-bottom: 1px solid black;
    border-top: 1px solid black;
} 

</style>
<table>
<tr>
<td>Saas Systems<br>
Data wydruku: <?php echo date("d.m.Y");?><br>
<?php echo $_REQUEST['title'];?></td>
</tr>
</table>

<table width="100%" class="boldtable">
<tr class='separated'>
<td>INDEKS</td>
<td>NAZWA</td>
<td style="text-align:right;">SALDO</td>
<td style="text-align:right;">ZALEGŁOŚĆ</td>
<td style="text-align:right;">KONTO KS</td>
</tr>


<?php 
foreach ($wynik as $val=>$key){
    if($wynik[$val]['zaleglosc']>0){
        $zal=0;
    } else {
        $zal=$wynik[$val]['zaleglosc'];
    }
    echo "<tr>
    <td>".$wynik[$val]['index_dbf']."</td>
    <td>".$wynik[$val]['name']."</td>
    <td style='text-align:right;'>".format_number($wynik[$val]['saldo'])."</td>
    <td style='text-align:right;'>".format_number($zal)."</td>
    <td style='text-align:right;'>".$wynik[$val]['ksac']."</td>
    </tr>";
}
?>
</table>
<br>
<table width="100%" class="boldtable">
<tr class='separated'>
<td>INDEKS</td>
<td>NAZWA</td>
<td style="text-align:right;"></td>
<td style="text-align:right;">SALDO</td>
<td style="text-align:right;">ZALEGŁOŚĆ</td>
<td style="text-align:right;">KONTO KS</td>
</tr>
<?php 
foreach ($wynik as $val=>$key){
    if($wynik[$val]['zaleglosc']>0){
        $zal=0;
    } else {
       $zal=$wynik[$val]['zaleglosc'];
    }
    echo "<tr class='separated'>
    <td>".$wynik[$val]['index_dbf']."</td>
    <td>".$wynik[$val]['name']."</td><td style='text-align:right;'></td>
    <td style='text-align:right;'>".format_number($wynik[$val]['saldo'])."</td>
    <td style='text-align:right;'>".format_number($zal)."</td>
    <td style='text-align:right;'>".$wynik[$val]['ksac']."</td>
    </tr>";
    if(count($wynik[$val]['poz'])>0){

        foreach ($wynik[$val]['poz'] as $v=>$k){
            if($wynik[$val]['poz'][$v]['type']==0){
                $t="(Wn)";
            } else {
                $t="(Ma)";
            }
            if(date("d.m.Y",strtotime($wynik[$val]['poz'][$v]['payment_date']))=='01.01.1970'){
                $data='';
            } else {
                $data=date("d.m.Y",strtotime($wynik[$val]['poz'][$v]['payment_date']));
            }
            echo "<tr>
    <td></td>
    <td>".$wynik[$val]['poz'][$v]['name']."</td><td style='text-align:right;'>".$t."</td>
    <td style='text-align:right;'>".format_number($wynik[$val]['poz'][$v]['value'])."</td>
    <td style='text-align:right;'>".$data."</td>
    <td style='text-align:right;'></td>
    </tr>";
        }
    }
}
?>