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");
15 //-----------------------------------------------------------------------------------
17 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
20 //initialise no input errors assumed initially before we test
23 if (strlen($_POST['name']) == 0)
26 display_error( _("The bank transaction type name cannot be empty."));
30 if ($input_error != 1)
33 if ($selected_id != -1)
35 update_bank_trans_type($selected_id, $_POST['name']);
36 display_notification(_('Selected bank account settings has been updated'));
40 add_bank_trans_type($_POST['name']);
41 display_notification(_('New bank account has been added'));
47 //-----------------------------------------------------------------------------------
49 function can_delete($selected_id)
51 if ($selected_id == -1)
53 $sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_trans WHERE bank_trans_type_id=$selected_id";
54 $result = db_query($sql, "could not query bank transactions");
55 $myrow = db_fetch_row($result);
58 display_error(_("Cannot delete this bank transaction type because bank transactions have been created referring to it."));
66 //-----------------------------------------------------------------------------------
68 if( $Mode == 'Delete')
70 if (can_delete($selected_id))
72 delete_bank_trans_type($selected_id);
73 display_notification(_('Selected bank account has been deleted'));
83 //-----------------------------------------------------------------------------------
85 $result = get_all_bank_trans_type();
88 start_table($table_style);
90 $th = array(_("Description"), "", "");
93 while ($myrow = db_fetch($result))
96 alt_table_row_color($k);
98 label_cell($myrow["name"]);
100 edit_button_cell("Edit".$myrow["id"], _("Edit"));
101 edit_button_cell("Delete".$myrow["id"], _("Delete"));
107 //-----------------------------------------------------------------------------------
111 start_table($table_style2);
113 if ($selected_id != -1)
115 //editing an existing status code
116 if ($Mode == 'Edit') {
117 $myrow = get_bank_trans_type($selected_id);
118 $_POST['name'] = $myrow["name"];
120 hidden('selected_id', $selected_id);
124 text_row_ex(_("Description:"), 'name', 40);
128 submit_add_or_update_center($selected_id == -1, '', true);
132 //------------------------------------------------------------------------------------