query($out_query); $in_query = " select sum(so.quantity) as qty, sum(so.quantity*price) as total, so.stock_id, p.group_ks from ecmstockoperations as so inner join ecmproducts as p on p.id=so.product_id where so.type = 0 group by so.stock_id, p.group_ks; "; $res = $db->query($in_query); $rd = array(); //report data $total = 0; $total_qty = 0; while ($row = $db->fetchByAssoc($res)) { if (!$rd[$row['stock_id']]) $rd[$row['stock_id']] = array(); if (!$rd[$row['stock_id']][$row['group_ks']]) $rd[$row['stock_id']][$row['group_ks']] = array(); $rd[$row['stock_id']][$row['group_ks']]['qty'] = $row['qty']; $rd[$row['stock_id']][$row['group_ks']]['total'] = $row['total']; $total+=$row['total']; $total_qty+=$row['qty']; } while ($row = $db->fetchByAssoc($res_out)) { $rd[$row['stock_id']][$row['group_ks']]['qty'] -= $row['qty']; $rd[$row['stock_id']][$row['group_ks']]['total'] -= $row['total']; $total-=$row['total']; $total_qty-=$row['qty']; } echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Ilość całkowita	Wartość całkowita
'.$total_qty.'	'.format_number($total).'

'; foreach ($rd as $stock_id=>$stock_data) { $s = $db->fetchByAssoc($db->query("SELECT name FROM ecmstocks WHERE id='$stock_id'")); echo '

'.$s['name'].'

'; echo ''; $stock_total = 0; $stock_qty = 0; foreach ($stock_data as $group_ks=>$value) { echo ''; echo ''; echo ''; echo ''; echo ''; $stock_total+=$value['total']; $stock_qty+=$value['qty']; } //total row echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Grupa KS	Ilość	Wartość
'.$group_ks.'	'.format_number($value['qty']).'	'.format_number($value['total']).'
Suma	'.format_number($stock_qty).'	'.format_number($stock_total).'

'; } ?>