Added missing no_*_list fields in initial sql files
[fa-stable.git] / gl / gl_payment.php
1 <?php
2
3 $page_security = 3;
4 $path_to_root="..";
5 include_once($path_to_root . "/includes/ui/items_cart.inc");
6 include_once($path_to_root . "/includes/session.inc");
7
8 include_once($path_to_root . "/includes/date_functions.inc");
9 include_once($path_to_root . "/includes/data_checks.inc");
10
11 include_once($path_to_root . "/gl/includes/ui/gl_payment_ui.inc");
12 include_once($path_to_root . "/gl/includes/gl_db.inc");
13 include_once($path_to_root . "/gl/includes/gl_ui.inc");
14
15 $js = get_js_form_entry("CodeID2", "code_id", "amount");
16 if ($use_popup_windows)
17         $js .= get_js_open_window(800, 500);
18 if ($use_date_picker)
19         $js .= get_js_date_picker();
20 $js .= get_js_set_focus('CodeID2');
21 page(_("Bank Account Payment Entry"), false, false, "setFocus()", $js);
22
23 //-----------------------------------------------------------------------------------------------
24
25 check_db_has_bank_accounts(_("There are no bank accounts defined in the system."));
26
27 check_db_has_bank_trans_types(_("There are no bank payment types defined in the system."));
28
29 //-----------------------------------------------------------------------------------------------
30
31 if (isset($_GET['AddedID']))
32 {
33         $trans_no = $_GET['AddedID'];
34         $trans_type = systypes::bank_payment();
35
36         display_notification_centered(_("Payment has been entered"));
37
38         display_note(get_gl_view_str($trans_type, $trans_no, _("View the GL Postings for this Payment")));
39
40         hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter Another Payment"));
41
42         display_footer_exit();
43 }
44
45 //--------------------------------------------------------------------------------------------------
46
47 function copy_to_py()
48 {
49         $_SESSION['pay_items']->from_loc = $_POST['bank_account'];
50         $_SESSION['pay_items']->tran_date = $_POST['date_'];
51         $_SESSION['pay_items']->transfer_type = $_POST['type'];
52         $_SESSION['pay_items']->increase = $_POST['PayType'];
53         if (!isset($_POST['person_id']))
54                 $_POST['person_id'] = "";
55         $_SESSION['pay_items']->person_id = $_POST['person_id'];
56         if (!isset($_POST['PersonDetailID']))
57                 $_POST['PersonDetailID'] = "";
58         $_SESSION['pay_items']->branch_id = $_POST['PersonDetailID'];
59         $_SESSION['pay_items']->memo_ = $_POST['memo_'];
60 }
61
62 //--------------------------------------------------------------------------------------------------
63
64 function copy_from_py()
65 {
66         $_POST['bank_account'] = $_SESSION['pay_items']->from_loc;
67         $_POST['date_'] = $_SESSION['pay_items']->tran_date;
68         $_POST['type'] = $_SESSION['pay_items']->transfer_type;
69         $_POST['PayType'] = $_SESSION['pay_items']->increase;
70         $_POST['person_id'] = $_SESSION['pay_items']->person_id;
71         $_POST['PersonDetailID'] = $_SESSION['pay_items']->branch_id;
72         $_POST['memo_'] = $_SESSION['pay_items']->memo_;
73 }
74
75 //-----------------------------------------------------------------------------------------------
76
77 function handle_new_order()
78 {
79         if (isset($_SESSION['pay_items']))
80         {
81                 $_SESSION['pay_items']->clear_items();
82                 unset ($_SESSION['pay_items']);
83         }
84
85         session_register("pay_items");
86
87         $_SESSION['pay_items'] = new items_cart;
88
89         $_POST['date_'] = Today();
90         if (!is_date_in_fiscalyear($_POST['date_']))
91                 $_POST['date_'] = end_fiscalyear();
92         $_SESSION['pay_items']->tran_date = $_POST['date_'];
93 }
94
95 //-----------------------------------------------------------------------------------------------
96
97 if (isset($_POST['Process']))
98 {
99
100         $input_error = 0;
101
102         if (!references::is_valid($_POST['ref']))
103         {
104                 display_error( _("You must enter a reference."));
105                 $input_error = 1;
106         }
107         elseif (!is_new_reference($_POST['ref'], systypes::bank_payment()))
108         {
109                 display_error( _("The entered reference is already in use."));
110                 $input_error = 1;
111         }
112         elseif (!is_date($_POST['date_']))
113         {
114                 display_error(_("The entered date for the payment is invalid."));
115                 $input_error = 1;
116         }
117         elseif (!is_date_in_fiscalyear($_POST['date_']))
118         {
119                 display_error(_("The entered date is not in fiscal year."));
120                 $input_error = 1;
121         }
122
123         if ($input_error == 1)
124                 unset($_POST['Process']);
125 }
126
127 if (isset($_POST['Process']))
128 {
129
130         $trans = add_bank_payment($_POST['bank_account'],
131                 $_SESSION['pay_items'], $_POST['date_'],
132                 $_POST['PayType'], $_POST['person_id'], $_POST['PersonDetailID'],
133                 $_POST['type'], $_POST['ref'], $_POST['memo_']);
134
135         $trans_type = $trans[0];
136         $trans_no = $trans[1];
137
138         $_SESSION['pay_items']->clear_items();
139         unset($_SESSION['pay_items']);
140
141         meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no");
142
143 } /*end of process credit note */
144
145 //-----------------------------------------------------------------------------------------------
146
147 function check_item_data()
148 {
149         if (!is_numeric($_POST['amount']))
150         {
151                 display_error( _("The amount entered is not a valid number."));
152                 return false;
153         }
154
155         if ($_POST['amount'] <= 0)
156         {
157                 display_error( _("The amount entered must be a postitive number."));
158                 return false;
159         }
160
161         if ($_POST['code_id'] == $_POST['bank_account'])
162         {
163                 display_error( _("The source and destination accouts cannot be the same."));
164                 return false;
165         }
166
167         if (is_bank_account($_POST['code_id']))
168         {
169                 display_error( _("You cannot make a payment to a bank account. Please use the transfer funds facility for this."));
170                 return false;
171         }
172
173         return true;
174 }
175
176 //-----------------------------------------------------------------------------------------------
177
178 function handle_update_item()
179 {
180     if($_POST['UpdateItem'] != "" && check_item_data())
181     {
182         $_SESSION['pay_items']->update_gl_item($_POST['Index'], $_POST['dimension_id'],
183                 $_POST['dimension2_id'], $_POST['amount'], $_POST['LineMemo']);
184     }
185 }
186
187 //-----------------------------------------------------------------------------------------------
188
189 function handle_delete_item()
190 {
191         $_SESSION['pay_items']->remove_gl_item($_GET['Delete']);
192 }
193
194 //-----------------------------------------------------------------------------------------------
195
196 function handle_new_item()
197 {
198         if (!check_item_data())
199                 return;
200
201         $_SESSION['pay_items']->add_gl_item($_POST['code_id'], $_POST['dimension_id'],
202                 $_POST['dimension2_id'], $_POST['amount'], $_POST['LineMemo']);
203 }
204
205 //-----------------------------------------------------------------------------------------------
206
207 if (isset($_GET['Delete']) || isset($_GET['Edit']))
208         copy_from_py();
209
210 if (isset($_GET['Delete']))
211         handle_delete_item();
212
213 if (isset($_POST['AddItem']) || isset($_POST['UpdateItem']))
214         copy_to_py();
215
216 if (isset($_POST['AddItem']))
217         handle_new_item();
218
219 if (isset($_POST['UpdateItem']))
220         handle_update_item();
221
222 //-----------------------------------------------------------------------------------------------
223
224 if (isset($_GET['NewPayment']) || !isset($_SESSION['pay_items']))
225 {
226         handle_new_order();
227 }
228
229 //-----------------------------------------------------------------------------------------------
230
231 start_form(false, true);
232
233 display_order_header($_SESSION['pay_items']);
234
235 start_table("$table_style2 width=90%", 10);
236 start_row();
237 echo "<td>";
238 display_gl_items(_("Payment Items"), $_SESSION['pay_items']);
239 gl_options_controls();
240 echo "</td>";
241 end_row();
242 end_table(1);
243
244 if (!isset($_POST['Process']))
245 {
246     submit_center_first('Update', _("Update"));
247         if ($_SESSION['pay_items']->count_gl_items() >= 1)
248             submit_center_last('Process', _("Process Payment"));
249 }
250
251 end_form();
252
253 //------------------------------------------------------------------------------------------------
254
255 end_page();
256
257 ?>