'; $xml.=''; //normal $db = $GLOBALS['db']; $w=$db->query("select id,name,number,document_no,wz_id,name,register_date,payment_date,sell_date,to_nip,parent_id,parent_name,parent_address_street,parent_address_postalcode,parent_address_country,parent_address_city,currency_value from ecmreceipts where type!='correct' and register_date like '".$year."-".$month."%' and deleted='0' order by date_entered asc"); while($r=$db->fetchByAssoc($w)){ if($r['currency_value'])$waluta="USD"; else $waluta="PLN"; $r_nip=$db->fetchByAssoc($db->query("select vatid,sic_code from accounts where id='".$r['parent_id']."'")); if($r_nip['vatid'])$nip=str_replace("-","",$r_nip['vatid']); elseif($r_nip['sic_code'])$nip=str_replace("-","",$r_nip['sic_code']); else $nip=str_replace("-","",$r['to_nip']); $r_wz=$db->fetchByAssoc($db->query("select id,number,document_no from ecmstockdocouts where id='".$r['wz_id']."'")); $xml.=' '.$r['register_date'].' '.$r['register_date'].' '.$r['register_date'].' '.$r['document_no'].' 0 '.str_replace("-","",$nip).' '.str_replace("<","",str_replace(">","",$r['parent_name'])).' '.$r['parent_address_street'].' '.$r['parent_address_postalcode'].' '.$r['parent_address_city'].' '.$r_wz['document_no'].' '.$r['name'].' '.$r['payment_date'].' 0 '.$waluta.''; $ww=$db->query("select quantity,price,ecmvat_value,ecmvat_name,ecmvat_id from ecmreceiptitems where ecmreceipt_id='".$r['id']."' and deleted='0'"); $sum_netto=0; $sum_brutto=0; $sum_vat=0; $s_netto=array(); $s_brutto=array(); $s_vat=array(); while($rr=$db->fetchByAssoc($ww)){ $sum_netto+=$rr['quantity']*$rr['price']; $sum_brutto+=$rr['quantity']*$rr['price']*(1+$rr['ecmvat_value']/100); $sum_vat+=round($rr['quantity']*$rr['price']*$rr['ecmvat_value']/100,2); $s_netto[$rr['ecmvat_name']]+=$rr['quantity']*$rr['price']; $s_brutto[$rr['ecmvat_name']]+=$rr['quantity']*$rr['price']*(1+$rr['ecmvat_value']/100); $s_vat[$rr['ecmvat_name']]+=round($rr['quantity']*$rr['price']*$rr['ecmvat_value']/100,2); } /*$xml.=' '.$sum_brutto.' '.$r['payment_date'].' 0 ';*/ $xml.=' '.$sum_netto.' '.round($sum_brutto,2).' '.(round($sum_brutto,2)-$sum_netto).' '; foreach($s_netto as $key=>$value){ $xml.=' '.$s_netto[$key].' '.round($s_brutto[$key],2).' '.round((round($s_brutto[$key],2)-$s_netto[$key]),2).' '; } $xml.=' '; } //corrects $w=$db->query("select id,name,document_no,name,register_date,payment_date,sell_date,to_nip,parent_id,parent_name,parent_address_street,parent_address_postalcode,parent_address_country,parent_address_city,ecmreceipt_id,ecmreceipt_name from ecmreceipts where type='correct' and register_date like '".$year."-".$month."%' and deleted='0' order by date_entered asc"); while($r=$db->fetchByAssoc($w)){ $r_nip=$db->fetchByAssoc($db->query("select vatid,sic_code from accounts where id='".$r['parent_id']."'")); if($r_nip['vatid'])$nip=str_replace("-","",$r_nip['vatid']); elseif($r_nip['sic_code'])$nip=str_replace("-","",$r_nip['sic_code']); else $nip=str_replace("-","",$r['to_nip']); $xml.=' '.$r['register_date'].' '.$r['register_date'].' '.$r['register_date'].' '.$r['document_no'].' '.$r['ecmreceipt_name'].' 0 '.str_replace("-","",$nip).' '.str_replace("<","",str_replace(">","",$r['parent_name'])).' '.$r['parent_address_street'].' '.$r['parent_address_postalcode'].' '.$r['parent_address_city'].' '.$r['name'].' '.$r['payment_date'].' 0 PLN'; $ww=$db->query("select quantity,price,ecmvat_value,ecmvat_name,ecmvat_id,ecmreceiptitem_id from ecmreceiptitems where ecmreceipt_id='".$r['id']."' and deleted='0'"); $sum_netto=0; $sum_brutto=0; $sum_vat=0; $s_netto=array(); $s_brutto=array(); $s_vat=array(); while($rr=$db->fetchByAssoc($ww)){ $sum_netto+=round($rr['quantity']*$rr['price'],2); $sum_brutto+=round($rr['quantity']*$rr['price']*(1+$rr['ecmvat_value']/100),2); $sum_vat+=round($rr['quantity']*$rr['price']*$rr['ecmvat_value']/100,2); $s_netto[$rr['ecmvat_name']]+=round($rr['quantity']*$rr['price'],2); $s_brutto[$rr['ecmvat_name']]+=round($rr['quantity']*$rr['price']*(1+$rr['ecmvat_value']/100),2); $s_vat[$rr['ecmvat_name']]+=round($rr['quantity']*$rr['price']*$rr['ecmvat_value']/100,2); $rrr=$db->fetchByAssoc($db->query("select price,quantity,ecmvat_value,ecmvat_name from ecmreceiptitems where id='".$rr['ecmreceiptitem_id']."'")); $sum_netto-=round($rrr['quantity']*$rrr['price'],2); $sum_brutto-=round($rrr['quantity']*$rrr['price']*(1+$rrr['ecmvat_value']/100),2); $sum_vat-=round($rrr['quantity']*$rrr['price']*$rrr['ecmvat_value']/100,2); $s_netto[$rrr['ecmvat_name']]-=round($rrr['quantity']*$rrr['price'],2); $s_brutto[$rrr['ecmvat_name']]-=round($rrr['quantity']*$rrr['price']*(1+$rrr['ecmvat_value']/100),2); $s_vat[$rrr['ecmvat_name']]-=round($rrr['quantity']*$rrr['price']*$rrr['ecmvat_value']/100,2); } /*$xml.=' '.$sum_brutto.' '.$r['payment_date'].' 0 ';*/ $xml.=' '.$sum_netto.' '.round($sum_brutto,2).' '.(round($sum_brutto,2)-$sum_netto).' '; foreach($s_netto as $key=>$value){ $xml.=' '.$s_netto[$key].' '.round($s_brutto[$key],2).' '.(round($s_brutto[$key],2)-$s_netto[$key]).' '; } $xml.=' '; } $xml.=''; return $xml; } //echo createDecree(2009,12) ?>