Moved all SQL statements from PHP files into relevant *_db.inc files.
[fa-stable.git] / gl / manage / gl_account_classes.php
1 <?php
2 /**********************************************************************
3     Copyright (C) FrontAccounting, LLC.
4         Released under the terms of the GNU General Public License, GPL, 
5         as published by the Free Software Foundation, either version 3 
6         of the License, or (at your option) any later version.
7     This program is distributed in the hope that it will be useful,
8     but WITHOUT ANY WARRANTY; without even the implied warranty of
9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 $page_security = 'SA_GLACCOUNTCLASS';
13 $path_to_root = "../..";
14 include($path_to_root . "/includes/session.inc");
15
16 page(_($help_context = "GL Account Classes"));
17
18 include($path_to_root . "/gl/includes/gl_db.inc");
19
20 include($path_to_root . "/includes/ui.inc");
21
22 simple_page_mode(true);
23 //-----------------------------------------------------------------------------------
24
25 function can_process() 
26 {
27         global $use_oldstyle_convert;
28         if (!is_numeric($_POST['id'])) 
29         {
30                 display_error( _("The account class ID must be numeric."));
31                 set_focus('id');
32                 return false;
33         }
34         if (strlen($_POST['name']) == 0) 
35         {
36                 display_error( _("The account class name cannot be empty."));
37                 set_focus('name');
38                 return false;
39         }
40         if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1)
41                 $_POST['Balance'] = check_value('Balance');
42         return true;
43 }
44
45 //-----------------------------------------------------------------------------------
46
47 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') 
48 {
49
50         if (can_process()) 
51         {
52
53         if ($selected_id != -1) 
54         {
55                 if(update_account_class($selected_id, $_POST['name'], $_POST['ctype']))
56                                 display_notification(_('Selected account class settings has been updated'));
57         } 
58         else 
59         {
60                 if(add_account_class($_POST['id'], $_POST['name'], $_POST['ctype'])) {
61                                 display_notification(_('New account class has been added'));
62                                 $Mode = 'RESET';
63                         }
64         }
65         }
66 }
67
68 //-----------------------------------------------------------------------------------
69
70 function can_delete($selected_id)
71 {
72         if ($selected_id == -1)
73                 return false;
74         if (account_class_in_account_types($selected_id))       
75         {
76                 display_error(_("Cannot delete this account class because GL account types have been created referring to it."));
77                 return false;
78         }
79
80         return true;
81 }
82
83
84 //-----------------------------------------------------------------------------------
85
86 if ($Mode == 'Delete')
87 {
88
89         if (can_delete($selected_id))
90         {
91                 delete_account_class($selected_id);
92                 display_notification(_('Selected account class has been deleted'));
93         }
94         $Mode = 'RESET';
95 }
96
97 //-----------------------------------------------------------------------------------
98 if ($Mode == 'RESET')
99 {
100         $selected_id = -1;
101         $_POST['id']  = $_POST['name']  = $_POST['ctype'] =  '';
102 }
103 //-----------------------------------------------------------------------------------
104
105 $result = get_account_classes(check_value('show_inactive'));
106
107 start_form();
108 start_table($table_style);
109 $th = array(_("Class ID"), _("Class Name"), _("Class Type"), "", "");
110 if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1)
111         $th[2] = _("Balance Sheet");
112 inactive_control_column($th);
113 table_header($th);
114
115 $k = 0;
116 while ($myrow = db_fetch($result)) 
117 {
118
119         alt_table_row_color($k);
120
121         label_cell($myrow["cid"]);
122         label_cell($myrow['class_name']);
123         if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1)
124         {
125                 $myrow['ctype'] = ($myrow["ctype"] >= CL_ASSETS && $myrow["ctype"] < CL_INCOME ? 1 : 0);
126                 label_cell(($myrow['ctype'] == 1 ? _("Yes") : _("No")));
127         }       
128         else    
129                 label_cell($class_types[$myrow["ctype"]]);
130         inactive_control_cell($myrow["cid"], $myrow["inactive"], 'chart_class', 'cid');
131         edit_button_cell("Edit".$myrow["cid"], _("Edit"));
132         delete_button_cell("Delete".$myrow["cid"], _("Delete"));
133         end_row();
134 }
135 inactive_control_row($th);
136 end_table(1);
137 //-----------------------------------------------------------------------------------
138
139 start_table($table_style2);
140
141 if ($selected_id != -1) 
142 {
143  if ($Mode == 'Edit') {
144         //editing an existing status code
145         $myrow = get_account_class($selected_id);
146
147         $_POST['id']  = $myrow["cid"];
148         $_POST['name']  = $myrow["class_name"];
149         if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1)
150                 $_POST['ctype'] = ($myrow["ctype"] >= CL_ASSETS && $myrow["ctype"] < CL_INCOME ? 1 : 0);
151         else
152                 $_POST['ctype']  = $myrow["ctype"];
153         hidden('selected_id', $selected_id);
154  }
155         hidden('id');
156         label_row(_("Class ID:"), $_POST['id']);
157
158
159 else 
160 {
161
162         text_row_ex(_("Class ID:"), 'id', 3);
163 }
164
165 text_row_ex(_("Class Name:"), 'name', 50, 60);
166
167 if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1)
168         check_row(_("Balance Sheet"), 'ctype', null);
169 else
170         class_types_list_row(_("Class Type:"), 'ctype', null);
171
172 end_table(1);
173
174 submit_add_or_update_center($selected_id == -1, '', 'both');
175
176 end_form();
177
178 //------------------------------------------------------------------------------------
179
180 end_page();
181
182 ?>