+function view_link($row)
+{
+ return get_dimensions_trans_view_str(systypes::dimension(), $row["id"]);
+}
+
+function is_closed($row)
+{
+ return $row['closed'] ? _('Yes') : _('No');
+}
+
+function sum_dimension($row)
+{
+ $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
+ date2sql($_POST['FromDate']) . "' AND
+ tran_date <= '" . date2sql($_POST['ToDate']) . "' AND (dimension_id = " .
+ $row['id']." OR dimension2_id = " .$row['id'].")";
+ $res = db_query($sql, "Sum of transactions could not be calculated");
+ $row = db_fetch_row($res);
+
+ return $row[0];
+}
+
+function is_overdue($row)
+{
+ return date_diff(Today(), sql2date($row["due_date"]), "d") > 0;
+}
+
+function edit_link($row)
+{
+ return $row["closed"] ? '' :
+ pager_link(_("Edit"),
+ "/dimensions/dimension_entry.php?trans_no=" . $row["id"]);
+}
+
+$sql = "SELECT dim.id,
+ dim.reference,
+ dim.name,
+ dim.type_,
+ dim.date_,
+ dim.due_date,
+ dim.closed
+ FROM ".TB_PREF."dimensions as dim WHERE id > 0";