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; } } ?>

Saas Systems Data wydruku:

$key){ if($wynik[$val]['zaleglosc']>0){ $zal=0; } else { $zal=$wynik[$val]['zaleglosc']; } echo ""; } ?>

INDEKS	NAZWA	SALDO	ZALEGŁOŚĆ	KONTO KS
".$wynik[$val]['index_dbf']."	".$wynik[$val]['name']."	".format_number($wynik[$val]['saldo'])."	".format_number($zal)."	".$wynik[$val]['ksac']."

$key){ if($wynik[$val]['zaleglosc']>0){ $zal=0; } else { $zal=$wynik[$val]['zaleglosc']; } echo ""; 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 ""; } } } ?>

INDEKS	NAZWA		SALDO	ZALEGŁOŚĆ	KONTO KS
".$wynik[$val]['index_dbf']."	".$wynik[$val]['name']."		".format_number($wynik[$val]['saldo'])."	".format_number($zal)."	".$wynik[$val]['ksac']."
	".$wynik[$val]['poz'][$v]['name']."	".$t."	".format_number($wynik[$val]['poz'][$v]['value'])."	".$data."