- $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
- date2sql($_POST['FromDate']) . "' AND
- tran_date <= '" . date2sql($_POST['ToDate']) . "' AND dimension_id = " .
- $myrow['id'];
- $res = db_query($sql, "Transactions could not be calculated");
- $row = db_fetch_row($res);
-
- if ($k == 1)
- {
- $row_text = "class='oddrow'";
- $k = 0;
- }
- else
- {
- $row_text = "class='evenrow'";
- $k++;
- }
-
- // check if it's an overdue work order
- if (date_diff(Today(), sql2date($myrow["due_date"]), "d") > 0)
- {
- $row_text = "class='overduebg'";
- }
-
- start_row($row_text);
-
- $mpage = $path_to_root . "/dimensions/dimension_entry.php?" . SID . "trans_no=" . $myrow["id"];
-
- label_cell(get_dimensions_trans_view_str(systypes::dimension(), $myrow["id"]));
- label_cell(get_dimensions_trans_view_str(systypes::dimension(), $myrow["id"], $myrow["reference"]));
- label_cell($myrow["name"]);
- label_cell($myrow["type_"]);
- label_cell(sql2date($myrow["date_"]));
- label_cell(sql2date($myrow["due_date"]));
- if (!$outstanding_only)
- label_cell(($myrow["closed"] ? _("Yes") : _("No")));
- amount_cell($row[0]);
- if ($myrow["closed"] == 0)
- label_cell("<a href='$mpage'>" . _("Edit") . "</a>");
- end_row();
-
- $j++;
- If ($j == 12)
- {
- $j = 1;
- table_header($th);
- }
- //end of page full new headings if
+ return pager_link(_("Edit"),
+ "/dimensions/dimension_entry.php?trans_no=" . $row["id"], ICON_EDIT);
+}
+
+$sql = get_sql_for_search_dimensions($dim, $_POST['FromDate'], $_POST['ToDate'],
+ $_POST['OrderNumber'], $_POST['type_'], check_value('OpenOnly'), check_value('OverdueOnly'));
+
+$cols = array(
+ _("#") => array('fun'=>'view_link'),
+ _("Reference"),
+ _("Name"),
+ _("Type"),
+ _("Date") =>'date',
+ _("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')
+);
+
+if ($outstanding_only) {
+ $cols[_("Closed")] = 'skip';