> getParameters(); } else $search_params = array(); $show_q = ""; if ($search_params['show']) { $show = $search_params['show']; if ($show == 'paid') { $show_q = 'and i.paid is not null'; } else if ($show == 'unpaid') { $show_q = 'and i.paid is null'; } } switch ($search_params['hold']) { case 'on': $show_q .= " and i.on_hold = '1'"; break; case 'not': $show_q .= " and i.on_hold = '0'"; break; } $benf_sql = ''; if (is_array($search_params['benf']) && sizeof($search_params['benf'])) { foreach ($search_params['benf'] as $key => $value) { if ($value != '-') { if ($benf_sql) $benf_sql .= " or "; $benf_sql .= "i.receiver = '".addslashes($value)."'"; } } if ($benf_sql) $show_q .= " and ($benf_sql)"; } if (!$benf_sql && $search_params['recv']) { $show_q .= " and i.receiver like '%".addslashes($search_params['recv'])."%'"; } if ($search_params['inv']) $show_q .= " and i.invoices_id = '".(int)$search_params['inv']."'"; if ($search_params['comm']) $show_q .= " and i.comment like '%".addslashes($search_params['comm'])."%'"; if ($search_params['sumfr']) { $sum_from = (float)str_replace(',', '.', $search_params['sumfr']); $show_q .= " and i.sum >= ".$sum_from; } if ($search_params['sumto']) { $sum_to = (float)str_replace(',', '.', $search_params['sumto']); $show_q .= " and i.sum <= ".$sum_to; } if ($search_params['invfr']) $show_q .= " and i.invoice_date >= '".addslashes($search_params['invfr'])."'"; if ($search_params['invto']) $show_q .= " and i.invoice_date <= '".addslashes($search_params['invto'])." 23:59:59'"; if ($search_params['expfr']) $show_q .= " and i.expires >= '".addslashes($search_params['expfr'])."'"; if ($search_params['expto']) $show_q .= " and i.expires <= '".addslashes($search_params['expto'])." 23:59:59'"; if ($search_params['paidfr']) $show_q .= " and i.paid >= '".addslashes($search_params['paidfr'])."'"; if ($search_params['paidto']) $show_q .= " and i.paid <= '".addslashes($search_params['paidto'])." 23:59:59'"; $sort = $HTTP_GET_VARS['sort']; $desc = $HTTP_GET_VARS['d']; $orderq = "order by expires"; if ($sort != "") { $orderq = "order by $sort" .($desc? ' desc': ''); } $n = 0; $sum_total = 0; $invoices_query = tep_db_query("select i.invoices_id, i.deb_cred, i.receiver, i.specifikation, i.account_class_booked, i.sum, i.vat_osuus, i.vat_percent, i.invoice_date, i.expires, i.paid, i.on_hold, i.comment, i.sum_vat_no from " .TABLE_ACCOUNTING ." as i where 1 $show_q $orderq"); while ($invoices = tep_db_fetch_array($invoices_query)) { $sum_total1 += $invoices['sum_vat_no']; $sum_total2 += $invoices['vat_osuus']; $sum_total3 += $invoices['sum']; echo ' ' . "\n". ' \n". ' \n". ' \n". ' \n". ' \n". ' \n". ' \n". ' \n". ' \n". // ' \n". ' \n". // ' \n". " \n"; } ?> BOX_FUNDS_INVOICES, 'module'=>'invoices', 'subtype'=>'0', 'enabled'=>(array_key_exists('invoices', $status_select)? true: false)); $status_rows[] = array('text'=>BOX_FUNDS_STOCKVALUE, 'module'=>'stock', 'subtype'=>'0', 'enabled'=>(array_key_exists('stock', $status_select)? true: false)); $status_rows[] = array('text'=>BOX_FUNDS_CASHBOX, 'module'=>'funds', 'subtype'=>'0', 'enabled'=>(array_key_exists('funds', $status_select) && in_array('0', $status_select['funds'])? true: false)); ?>

'.tep_date_short($invoices['invoice_date'])."	'.$invoices['invoices_id']."	'.$invoices['specifikation']."	'.$invoices['deb_cred']."	'.$invoices['receiver']."	'.$invoices['vat_percent'].',00%'."	'.$currencies->format($invoices['sum_vat_no'])."	'.$currencies->format($invoices['vat_osuus'])."	'.$currencies->format($invoices['sum'])."	'.tep_date_short($invoices['expires'])."	'; if ($invoices['paid']) { echo tep_date_short($invoices['paid']); } else if ($invoices['on_hold']) { echo TEXT_ON_HOLD; } else echo ' '; echo "	'.$currencies->format($invoices['sum'])."
						format($sum_total1); ?>	format($sum_total2); ?>	format($sum_total3); ?>
	format($value); ?>
	format($sum); ?>

' .tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED, 10, 10) .""; } else { echo '' .tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) ." "; echo tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10) ." "; } ?>