gl/manage/bank_trans_types.php

   1 <?php
   2
   3 $page_security = 3;
   4 $path_to_root="../..";
   5
   6 include($path_to_root . "/includes/session.inc");
   7
   8 page(_("Bank Transaction Types"));
   9
  10 include($path_to_root . "/gl/includes/gl_db.inc");
  11
  12 include($path_to_root . "/includes/ui.inc");
  13
  14 if (isset($_GET['selected_id']))
  15 {
  16         $selected_id = $_GET['selected_id'];
  17 }
  18 elseif(isset($_POST['selected_id']))
  19 {
  20         $selected_id = $_POST['selected_id'];
  21 }
  22 else
  23         $selected_id = -1;
  24 //-----------------------------------------------------------------------------------
  25
  26 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
  27 {
  28
  29         //initialise no input errors assumed initially before we test
  30         $input_error = 0;
  31
  32         if (strlen($_POST['name']) == 0)
  33         {
  34                 $input_error = 1;
  35                 display_error( _("The bank transaction type name cannot be empty."));
  36                 set_focus('name');
  37         }
  38
  39         if ($input_error != 1)
  40         {
  41
  42         if ($selected_id != -1)
  43         {
  44
  45                 update_bank_trans_type($selected_id, $_POST['name']);
  46
  47         }
  48         else
  49         {
  50
  51                 add_bank_trans_type($_POST['name']);
  52         }
  53
  54                 meta_forward($_SERVER['PHP_SELF']);
  55         }
  56 }
  57
  58 //-----------------------------------------------------------------------------------
  59
  60 function can_delete($selected_id)
  61 {
  62         if ($selected_id == -1)
  63                 return false;
  64         $sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_trans WHERE bank_trans_type_id=$selected_id";
  65         $result = db_query($sql, "could not query bank transactions");
  66         $myrow = db_fetch_row($result);
  67         if ($myrow[0] > 0)
  68         {
  69                 display_error(_("Cannot delete this bank transaction type because bank transactions have been created referring to it."));
  70                 return false;
  71         }
  72
  73         return true;
  74 }
  75
  76
  77 //-----------------------------------------------------------------------------------
  78
  79 if (isset($_GET['delete']))
  80 {
  81
  82         if (can_delete($selected_id))
  83         {
  84                 delete_bank_trans_type($selected_id);
  85                 meta_forward($_SERVER['PHP_SELF']);
  86         }
  87 }
  88
  89 //-----------------------------------------------------------------------------------
  90
  91 $result = get_all_bank_trans_type();
  92
  93 start_table($table_style);
  94
  95 $th = array(_("Description"), "", "");
  96 table_header($th);
  97
  98 $k = 0;
  99 while ($myrow = db_fetch($result))
 100 {
 101
 102         alt_table_row_color($k);
 103
 104         label_cell($myrow["name"]);
 105         edit_link_cell("selected_id=" . $myrow["id"]);
 106         delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
 107         end_row();
 108 }
 109
 110 end_table();
 111
 112 //-----------------------------------------------------------------------------------
 113
 114 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Bank Transaction Type"));
 115
 116 start_form();
 117
 118 start_table($table_style2);
 119
 120 if ($selected_id != -1)
 121 {
 122         //editing an existing status code
 123
 124         $myrow = get_bank_trans_type($selected_id);
 125
 126         $_POST['name']  = $myrow["name"];
 127
 128         hidden('selected_id', $selected_id);
 129 }
 130
 131 text_row_ex(_("Description:"), 'name', 40);
 132
 133 end_table(1);
 134
 135 submit_add_or_update_center($selected_id == -1);
 136
 137 end_form();
 138
 139 //------------------------------------------------------------------------------------
 140
 141 end_page();
 142
 143 ?>