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         }
  37
  38         if ($input_error != 1)
  39         {
  40
  41         if ($selected_id != -1)
  42         {
  43
  44                 update_bank_trans_type($selected_id, $_POST['name']);
  45
  46         }
  47         else
  48         {
  49
  50                 add_bank_trans_type($_POST['name']);
  51         }
  52
  53                 meta_forward($_SERVER['PHP_SELF']);
  54         }
  55 }
  56
  57 //-----------------------------------------------------------------------------------
  58
  59 function can_delete($selected_id)
  60 {
  61         if ($selected_id == -1)
  62                 return false;
  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);
  66         if ($myrow[0] > 0)
  67         {
  68                 display_error(_("Cannot delete this bank transaction type because bank transactions have been created referring to it."));
  69                 return false;
  70         }
  71
  72         return true;
  73 }
  74
  75
  76 //-----------------------------------------------------------------------------------
  77
  78 if (isset($_GET['delete']))
  79 {
  80
  81         if (can_delete($selected_id))
  82         {
  83                 delete_bank_trans_type($selected_id);
  84                 meta_forward($_SERVER['PHP_SELF']);
  85         }
  86 }
  87
  88 //-----------------------------------------------------------------------------------
  89
  90 $result = get_all_bank_trans_type();
  91
  92 start_table($table_style);
  93
  94 $th = array(_("Description"), "", "");
  95 table_header($th);
  96
  97 $k = 0;
  98 while ($myrow = db_fetch($result))
  99 {
 100
 101         alt_table_row_color($k);
 102
 103         label_cell($myrow["name"]);
 104         edit_link_cell("selected_id=" . $myrow["id"]);
 105         delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
 106         end_row();
 107 }
 108
 109 end_table();
 110
 111 //-----------------------------------------------------------------------------------
 112
 113 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Bank Transaction Type"));
 114
 115 start_form();
 116
 117 start_table($table_style2);
 118
 119 if ($selected_id != -1)
 120 {
 121         //editing an existing status code
 122
 123         $myrow = get_bank_trans_type($selected_id);
 124
 125         $_POST['name']  = $myrow["name"];
 126
 127         hidden('selected_id', $selected_id);
 128 }
 129
 130 text_row_ex(_("Description:"), 'name', 40);
 131
 132 end_table(1);
 133
 134 submit_add_or_update_center($selected_id == -1);
 135
 136 end_form();
 137
 138 //------------------------------------------------------------------------------------
 139
 140 end_page();
 141
 142 ?>