<?php
/**********************************************************************
Copyright (C) FrontAccounting, LLC.
- Released under the terms of the GNU Affero General Public License,
- AGPL, as published by the Free Software Foundation, either version
- 3 of the License, or (at your option) any later version.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
- See the License here <http://www.gnu.org/licenses/agpl-3.0.html>.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
-$page_security = 2;
+$page_security = 'SA_DIMTRANSVIEW';
$path_to_root="../..";
include($path_to_root . "/includes/db_pager.inc");
//--------------------------------------------------------------------------------------
-start_form(false, true, $_SERVER['PHP_SELF'] ."?outstanding_only=" . $outstanding_only . SID);
+start_form(false, false, $_SERVER['PHP_SELF'] ."?outstanding_only=$outstanding_only");
start_table("class='tablestyle_noborder'");
start_row();
else
$_POST['OpenOnly'] = 1;
-submit_cells('SearchOrders', _("Search"), '', '', true);
+submit_cells('SearchOrders', _("Search"), '', '', 'default');
end_row();
end_table();
function view_link($row)
{
- return get_dimensions_trans_view_str(systypes::dimension(), $row["id"]);
+ return get_dimensions_trans_view_str(ST_DIMENSION, $row["id"]);
}
function is_closed($row)
function is_overdue($row)
{
- return date_diff(Today(), sql2date($row["due_date"]), "d") > 0;
+ return date_diff2(Today(), sql2date($row["due_date"]), "d") > 0;
}
function edit_link($row)
{
- return $row["closed"] ? '' :
- pager_link(_("Edit"),
+ //return $row["closed"] ? '' :
+ // pager_link(_("Edit"),
+ // "/dimensions/dimension_entry.php?trans_no=" . $row["id"], ICON_EDIT);
+ return pager_link(_("Edit"),
"/dimensions/dimension_entry.php?trans_no=" . $row["id"], ICON_EDIT);
}
if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
{
- $sql .= " AND reference LIKE '%". $_POST['OrderNumber'] . "%'";
+ $sql .= " AND reference LIKE ".db_escape("%". $_POST['OrderNumber'] . "%");
} else {
if ($dim == 1)
if (isset($_POST['type_']) && ($_POST['type_'] > 0))
{
- $sql .= " AND type_=" . $_POST['type_'];
+ $sql .= " AND type_=".db_escape($_POST['type_']);
}
if (isset($_POST['OverdueOnly']))
{
$today = date2sql(Today());
- $sql .= " AND due_date < '$today' ";
+ $sql .= " AND due_date < '$today'";
}
$sql .= " AND date_ >= '" . date2sql($_POST['FromDate']) . "'
_("Name"),
_("Type"),
_("Date") =>'date',
- _("Due Date") => array('name'=>'due_date', 'date', 'ord'=>'asc'),
+ _("Due Date") => array('name'=>'due_date', 'type'=>'date', 'ord'=>'asc'),
_("Closed") => array('fun'=>'is_closed'),
_("Balance") => array('type'=>'amount', 'insert'=>true, 'fun'=>'sum_dimension'),
array('insert'=>true, 'fun'=>'edit_link')
$table =& new_db_pager('dim_tbl', $sql, $cols);
$table->set_marker('is_overdue', _("Marked dimensions are overdue."));
-if (get_post('SearchOrders')) {
- $table->set_sql($sql);
- $table->set_columns($cols);
-}
$table->width = "80%";
start_form();