6 include($path_to_root . "/includes/session.inc");
8 page(_("Bank Transaction Types"));
10 include($path_to_root . "/gl/includes/gl_db.inc");
12 include($path_to_root . "/includes/ui.inc");
14 if (isset($_GET['selected_id']))
16 $selected_id = $_GET['selected_id'];
18 elseif(isset($_POST['selected_id']))
20 $selected_id = $_POST['selected_id'];
24 //-----------------------------------------------------------------------------------
26 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
29 //initialise no input errors assumed initially before we test
32 if (strlen($_POST['name']) == 0)
35 display_error( _("The bank transaction type name cannot be empty."));
38 if ($input_error != 1)
41 if ($selected_id != -1)
44 update_bank_trans_type($selected_id, $_POST['name']);
50 add_bank_trans_type($_POST['name']);
53 meta_forward($_SERVER['PHP_SELF']);
57 //-----------------------------------------------------------------------------------
59 function can_delete($selected_id)
61 if ($selected_id == -1)
63 $sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_trans WHERE bank_trans_type_id=$selected_id";
64 $result = db_query($sql, "could not query bank transactions");
65 $myrow = db_fetch_row($result);
68 display_error(_("Cannot delete this bank transaction type because bank transactions have been created referring to it."));
76 //-----------------------------------------------------------------------------------
78 if (isset($_GET['delete']))
81 if (can_delete($selected_id))
83 delete_bank_trans_type($selected_id);
84 meta_forward($_SERVER['PHP_SELF']);
88 //-----------------------------------------------------------------------------------
90 $result = get_all_bank_trans_type();
92 start_table($table_style);
94 $th = array(_("Description"), "", "");
98 while ($myrow = db_fetch($result))
101 alt_table_row_color($k);
103 label_cell($myrow["name"]);
104 edit_link_cell("selected_id=" . $myrow["id"]);
105 delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
111 //-----------------------------------------------------------------------------------
113 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Bank Transaction Type"));
117 start_table($table_style2);
119 if ($selected_id != -1)
121 //editing an existing status code
123 $myrow = get_bank_trans_type($selected_id);
125 $_POST['name'] = $myrow["name"];
127 hidden('selected_id', $selected_id);
130 text_row_ex(_("Description:"), 'name', 40);
134 submit_add_or_update_center($selected_id == -1);
138 //------------------------------------------------------------------------------------