X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fview%2Fgl_trans_view.php;h=64e585a5a16b8f2530bfa84d9f0cc3d028b0dc26;hb=510d6e1925c4d1621ae3efd85e117cc9bb4320f0;hp=0aec1027b07948a3ee0953ba7e4ab3d93377c1f1;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/gl/view/gl_trans_view.php b/gl/view/gl_trans_view.php index 0aec1027..64e585a5 100644 --- a/gl/view/gl_trans_view.php +++ b/gl/view/gl_trans_view.php @@ -1,7 +1,16 @@ . +***********************************************************************/ +$page_security = 'SA_GLTRANSVIEW'; +$path_to_root = "../.."; include_once($path_to_root . "/includes/session.inc"); page(_("General Ledger Transaction Details"), true); @@ -20,8 +29,8 @@ if (!isset($_GET['type_id']) || !isset($_GET['trans_no'])) function display_gl_heading($myrow) { - global $table_style; - $trans_name = systypes::name($_GET['type_id']); + global $table_style, $systypes_array; + $trans_name = $systypes_array[$_GET['type_id']]; start_table("$table_style width=95%"); $th = array(_("General Ledger Transaction Details"), _("Date"), _("Person/Item")); @@ -29,7 +38,7 @@ function display_gl_heading($myrow) start_row(); label_cell("$trans_name #" . $_GET['trans_no']); label_cell(sql2date($myrow["tran_date"])); - label_cell(payment_person_types::person_name($myrow["person_type_id"],$myrow["person_id"])); + label_cell(payment_person_name($myrow["person_type_id"],$myrow["person_id"])); end_row(); @@ -38,13 +47,17 @@ function display_gl_heading($myrow) end_table(1); } -$sql = "SELECT ".TB_PREF."gl_trans.*, account_name FROM ".TB_PREF."gl_trans, ".TB_PREF."chart_master WHERE ".TB_PREF."gl_trans.account = ".TB_PREF."chart_master.account_code AND type= " . $_GET['type_id'] . " AND type_no = " . $_GET['trans_no'] . " ORDER BY counter"; +$sql = "SELECT ".TB_PREF."gl_trans.*, account_name FROM " + .TB_PREF."gl_trans, ".TB_PREF."chart_master WHERE " + .TB_PREF."gl_trans.account = ".TB_PREF."chart_master.account_code AND type= " + .db_escape($_GET['type_id']) . " AND type_no = ".db_escape($_GET['trans_no']) + . " ORDER BY counter"; $result = db_query($sql,"could not get transactions"); //alert("sql = ".$sql); if (db_num_rows($result) == 0) { - echo "