-while ($myrow = db_fetch($result))
-{
- $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']." OR dimension2_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]);
-
- label_cell($myrow["closed"] == 0 ? ("<a href='$mpage'>" . _("Edit") . "</a>") :'');
- end_row();
-
- $j++;
- If ($j == 12)
- {
- $j = 1;
- table_header($th);
- }
- //end of page full new headings if
-}
-//end of while loop