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 simple_page_mode();
  15 //-----------------------------------------------------------------------------------
  16
  17 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  18 {
  19
  20         //initialise no input errors assumed initially before we test
  21         $input_error = 0;
  22
  23         if (strlen($_POST['name']) == 0)
  24         {
  25                 $input_error = 1;
  26                 display_error( _("The bank transaction type name cannot be empty."));
  27                 set_focus('name');
  28         }
  29
  30         if ($input_error != 1)
  31         {
  32
  33         if ($selected_id != -1)
  34         {
  35                 update_bank_trans_type($selected_id, $_POST['name']);
  36                         display_notification(_('Selected bank account settings has been updated'));
  37         }
  38         else
  39         {
  40                 add_bank_trans_type($_POST['name']);
  41                         display_notification(_('New bank account has been added'));
  42         }
  43                 $Mode = 'RESET';
  44         }
  45 }
  46
  47 //-----------------------------------------------------------------------------------
  48
  49 function can_delete($selected_id)
  50 {
  51         if ($selected_id == -1)
  52                 return false;
  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);
  56         if ($myrow[0] > 0)
  57         {
  58                 display_error(_("Cannot delete this bank transaction type because bank transactions have been created referring to it."));
  59                 return false;
  60         }
  61
  62         return true;
  63 }
  64
  65
  66 //-----------------------------------------------------------------------------------
  67
  68 if( $Mode == 'Delete')
  69 {
  70         if (can_delete($selected_id))
  71         {
  72                 delete_bank_trans_type($selected_id);
  73                 display_notification(_('Selected bank account has been deleted'));
  74         }
  75         $Mode = 'RESET';
  76 }
  77
  78 if ($Mode == 'RESET')
  79 {
  80         $selected_id = -1;
  81         $_POST['name']  = '';
  82 }
  83 //-----------------------------------------------------------------------------------
  84
  85 $result = get_all_bank_trans_type();
  86
  87 start_form();
  88 start_table($table_style);
  89
  90 $th = array(_("Description"), "", "");
  91 table_header($th);
  92 $k = 0;
  93 while ($myrow = db_fetch($result))
  94 {
  95
  96         alt_table_row_color($k);
  97
  98         label_cell($myrow["name"]);
  99
 100         edit_button_cell("Edit".$myrow["id"], _("Edit"));
 101         edit_button_cell("Delete".$myrow["id"], _("Delete"));
 102         end_row();
 103 }
 104 end_table();
 105 end_form();
 106 echo '<br>';
 107 //-----------------------------------------------------------------------------------
 108
 109 start_form();
 110
 111 start_table($table_style2);
 112
 113 if ($selected_id != -1)
 114 {
 115         //editing an existing status code
 116         if ($Mode == 'Edit') {
 117                 $myrow = get_bank_trans_type($selected_id);
 118                 $_POST['name']  = $myrow["name"];
 119         }
 120         hidden('selected_id', $selected_id);
 121 }
 122
 123 set_focus('name');
 124 text_row_ex(_("Description:"), 'name', 40);
 125
 126 end_table(1);
 127
 128 submit_add_or_update_center($selected_id == -1, '', true);
 129
 130 end_form();
 131
 132 //------------------------------------------------------------------------------------
 133
 134 end_page();
 135
 136 ?>