|
|
|
' . tep_image_button('button_back.gif', IMAGE_BACK) . ''; ?> |
|
|
receiver, $beneficiary_array)) {
$beneficiary_dropdown = $oInfo->receiver;
$receiver = '';
} else {
$beneficiary_dropdown = '';
$receiver = $oInfo->receiver;
}
?>
|
|
' . tep_image_button('button_back.gif', IMAGE_BACK) . ''; ?> |
|
|
| |
| invoices_id); ?> |
|
|
|
|
|
sum, 2, ',', ''), 'size="18" class="flatField"'); ?> |
|
|
|
|
comment, 'class="flatField"'); ?> |
|
|
|
'', 'text'=>'-'),
array('id'=>'on', 'text'=>TEXT_MENU_ON_HOLD),
array('id'=>'not', 'text'=>TEXT_MENU_NOT_HOLD)
);
$paid_menu = array(
array ('id'=>'', 'text'=>'-'),
array ('id'=>'paid', 'text'=>TEXT_PAID_INVOICES),
array ('id'=>'unpaid', 'text'=>TEXT_UNPAID_INVOICES)
);
?>
|
|
|
| '', 'text'=>TEXT_ALL_INVOICES);
$show_o[] = array ('id'=>'paid', 'text'=>TEXT_PAID_INVOICES);
$show_o[] = array ('id'=>'unpaid', 'text'=>TEXT_UNPAID_INVOICES);
echo ' ' . tep_draw_pull_down_menu('show', $show_o, '', 'onChange="this.form.submit();"');
?> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$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 (!$benf_sql && $search_params['aclass']) {
$show_q .= " and i.account_class_booked like '%".addslashes($search_params['aclass'])."%'";
}
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['month'])
$show_q .= " and i.invoice_date = '".addslashes($search_params['month'])."'";
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'";
$orderq = "order by expires";
if ($sort != "") {
$orderq = "order by $sort" .($desc? ' desc': '');
}
$invoices_query_raw = "select i.invoices_id, i.deb_cred, i.receiver, i.specifikation,i.account_class_booked, i.sum,i.sum_vat_no, i.vat_percent, i.vat_osuus, i.invoice_date, i.expires, i.paid, i.on_hold, i.comment from " .TABLE_ACCOUNTING ." as i where 1 $show_q $orderq";
$invoices_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $invoices_query_raw, $invoices_query_numrows);
$invoices_query = tep_db_query($invoices_query_raw);
while ($invoices = tep_db_fetch_array($invoices_query)) {
if (((!$_GET['oID']) || ($_GET['oID'] == $invoices['invoices_id'])) && (!$oInfo)) {
$oInfo = new objectInfo($invoices);
}
if ( (is_object($oInfo)) && ($invoices['invoices_id'] == $oInfo->invoices_id) ) {
echo ' ' . "\n";
} else {
echo ' ' . "\n";
}
?>
|
|
|
|
|
format($invoices['sum_vat_no']); ?> |
% |
format($invoices['vat_osuus']); ?> |
format($invoices['sum']); ?> |
$t";
// echo $t;
?> |
|
invoices_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?> |
| display_count($invoices_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_INVOICES); ?> |
display_links($invoices_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?> |
|
|
' .''. '';?>
' .''. '';?>
|
' .''. '';?>
|
|
'' . TEXT_INFO_HEADING_DELETE_INVOICE . '');
$contents = array('form' => tep_draw_form('invoices', FILENAME_ACCOUNTING, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->invoices_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '
');
$contents[] = array('align' => 'center', 'text' => '
' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' ' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '');
break;
default:
if (is_object($oInfo)) {
$heading[] = array('text' => '[' . $oInfo->invoices_id . '] ' . tep_date_short($oInfo->expires) . '');
$contents[] = array('align' => 'center', 'text' => '' . tep_image_button('button_edit.gif', IMAGE_EDIT) . ' ' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '');
if ($oInfo->paid == "") {
$_t = '' . tep_image_button('button_pay.gif', IMAGE_PAY) . '';
if (!$oInfo->on_hold)
$_t .= ' ' . tep_image_button('button_put_on_hold.gif', IMAGE_PUT_ON_HOLD) . '';
else
$_t .= ' ' . tep_image_button('button_release.gif', IMAGE_RELEASE) . '';
$contents[] = array('align' => 'center', 'text' => $_t);
}
$contents[] = array('text' => '
' . TEXT_INFO_COMMENT . '
' . $oInfo->comment);
}
break;
}
if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
echo ' ' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' | ' . "\n";
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
- |
|
|
|
|
|
|
| '.tep_image_button('button_reset.gif', IMAGE_RESET).' '.tep_image_submit('button_search.gif', IMAGE_SEARCH).' '; ?> |
|
|
|
|
| '.tep_image_button('button_reset.gif', IMAGE_RESET).' '.tep_image_submit('button_search.gif', IMAGE_SEARCH).' '; ?> |
|
|