GL acounts in seletors always grouped by type.
[fa-stable.git] / gl / includes / ui / gl_bank_ui.inc
1 <?php
2 /**********************************************************************
3     Copyright (C) FrontAccounting, LLC.
4         Released under the terms of the GNU Affero General Public License,
5         AGPL, as published by the Free Software Foundation, either version 
6         3 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/agpl-3.0.html>.
11 ***********************************************************************/
12 function display_bank_header(&$order)
13 {
14         global $table_style2, $Ajax;
15         $payment = $order->trans_type == systypes::bank_payment();
16
17         div_start('pmt_header');
18
19         start_outer_table("width=90% $table_style2"); // outer table
20
21         table_section(1);
22         
23     bank_accounts_list_row( $payment ? _("From:") : _("To:"), 'bank_account', null, true);
24
25     date_row(_("Date:"), 'date_', '', null, 0, 0, 0, null, true);
26
27         table_section(2, "33%");
28
29         if (!isset($_POST['PayType']))
30         {
31                 if (isset($_GET['PayType']))
32                         $_POST['PayType'] = $_GET['PayType'];
33                 else
34                         $_POST['PayType'] = "";
35         }
36         if (!isset($_POST['person_id']))
37         {
38                 if (isset($_GET['PayPerson']))
39                         $_POST['person_id'] = $_GET['PayPerson'];
40                 else
41                         $_POST['person_id'] = "";
42         }
43         if (isset($_POST['_PayType_update'])) {
44                 $_POST['person_id'] = '';
45                 $Ajax->activate('pmt_header');
46                 $Ajax->activate('code_id');
47         }
48     payment_person_types_list_row( $payment ? _("Pay To:"):_("From:"),
49                  'PayType', $_POST['PayType'], true);
50     switch ($_POST['PayType'])
51     {
52                 case payment_person_types::misc() :
53                 text_row_ex($payment ?_("To the Order of:"):_("Name:"),
54                                  'person_id', 40, 50);
55                 break;
56                 case payment_person_types::WorkOrder() :
57                 workorders_list_row(_("Work Order:"), 'person_id', null);
58                 break;
59                 case payment_person_types::supplier() :
60                 supplier_list_row(_("Supplier:"), 'person_id', null, false, true);
61                 break;
62                 case payment_person_types::customer() :
63                 customer_list_row(_("Customer:"), 'person_id', null, false, true);
64
65                 if (db_customer_has_branches($_POST['person_id']))
66                 {
67                         customer_branches_list_row(_("Branch:"), $_POST['person_id'], 'PersonDetailID', null, false, true, true);
68                 }
69                 else
70                 {
71                                 $_POST['PersonDetailID'] = reserved_words::get_any_numeric();
72                         hidden('PersonDetailID');
73                 }
74                 break;
75                 case payment_person_types::QuickEntry() :
76                         quick_entries_list_row(_("Description:"), 'person_id', null, ($payment ? 0 : 1), 1);
77                         amount_row(_("Total Amount"), 'totamount', null, null, "&nbsp;&nbsp;".submit('go', _("Go"), false, false, true));                       
78                         break;  
79                 //case payment_person_types::Project() :
80         //      dimensions_list_row(_("Dimension:"), 'person_id', $_POST['person_id'], false, null, true);
81         //      break;
82     }
83
84         $person_currency = payment_person_types::person_currency($_POST['PayType'], $_POST['person_id']);
85         $bank_currency = get_bank_account_currency($_POST['bank_account']);
86
87         exchange_rate_display($bank_currency, $person_currency, $_POST['date_']);
88
89         table_section(3, "33%");
90
91         if (isset($_GET['NewPayment']))
92         ref_row(_("Reference:"), 'ref', '', references::get_next(systypes::bank_payment()));
93     else
94         ref_row(_("Reference:"), 'ref', '', references::get_next(systypes::bank_deposit()));
95
96         end_outer_table(1); // outer table
97
98         div_end();
99 }
100 //---------------------------------------------------------------------------------
101
102 function display_gl_items($title, &$order)
103 {
104         global $table_style, $path_to_root;
105
106         $dim = get_company_pref('use_dimension');
107         $colspan = ($dim == 2 ? 4 : ($dim == 1 ? 3 : 2));
108         display_heading($title);
109
110     div_start('items_table');
111         start_table("$table_style colspan=7 width=95%");
112
113         if ($dim == 2)
114                 $th = array(_("Account Code"), _("Account Description"), _("Dimension")." 1",
115                         _("Dimension")." 2", _("Amount"), _("Memo"), "");
116         else if ($dim == 1)
117                 $th = array(_("Account Code"), _("Account Description"), _("Dimension"),
118                         _("Amount"), _("Memo"), "");
119         else
120                 $th = array(_("Account Code"), _("Account Description"),
121                         _("Amount"), _("Memo"), "");
122
123         if (count($order->gl_items)) $th[] = '';
124
125         table_header($th);
126         $k = 0;  //row colour counter
127
128         $id = find_submit('Edit');
129         foreach ($order->gl_items as $item)
130         {
131                 if ($id != $item->index)
132                 {
133                 alt_table_row_color($k);
134
135                         label_cell($item->code_id);
136                         label_cell($item->description);
137                 if ($dim >= 1)
138                                 label_cell(get_dimension_string($item->dimension_id, true));
139                 if ($dim > 1)
140                                 label_cell(get_dimension_string($item->dimension2_id, true));
141                         //amount_cell(abs($item->amount));
142                         if ($order->trans_type == systypes::bank_deposit())
143                                 amount_cell(-$item->amount);
144                         else            
145                                 amount_cell($item->amount);
146                         label_cell($item->reference);
147
148                         edit_button_cell("Edit$item->index", _("Edit"),
149                                 _('Edit document line'));
150                         delete_button_cell("Delete$item->index", _("Delete"),
151                                 _('Remove line from document'));
152                 end_row();
153                 }
154                 else
155                 {
156                         gl_edit_item_controls($order, $dim, $item->index);
157                 }
158         }
159
160         if ($id == -1)
161                 gl_edit_item_controls($order, $dim);
162
163         if ($order->count_gl_items())
164                 label_row(_("Total"), number_format2(abs($order->gl_items_total()), user_price_dec()),"colspan=" . $colspan . " align=right", "align=right");
165
166     end_table();
167         div_end();
168 }
169
170 //---------------------------------------------------------------------------------
171
172 function gl_edit_item_controls(&$order, $dim, $Index=null)
173 {
174         global $Ajax;
175         $payment = $order->trans_type == systypes::bank_payment();
176
177         start_row();
178         $id = find_submit('Edit');
179         if ($Index != -1 && $Index == $id)
180         {
181                 $item = $order->gl_items[$Index];
182                 $_POST['code_id'] = $item->code_id;
183                 $_POST['dimension_id'] = $item->dimension_id;
184                 $_POST['dimension2_id'] = $item->dimension2_id;
185                 $_POST['amount'] = price_format(abs($item->amount));
186                 $_POST['description'] = $item->description;
187                 $_POST['LineMemo'] = $item->reference;
188
189                 hidden('Index', $item->index);
190                 hidden('code_id', $item->code_id);
191                 label_cell($_POST['code_id']);
192                 label_cell($item->description);
193                 if ($dim >= 1)
194                         dimensions_list_cells(null, 'dimension_id', null, true, " ", false, 1);
195                 if ($dim > 1)
196                         dimensions_list_cells(null, 'dimension2_id', null, true, " ", false, 2);
197             $Ajax->activate('items_table');
198         }
199         else
200         {
201                 $_POST['amount'] = price_format(0);
202                 $_POST['dimension_id'] = 0;
203                 $_POST['dimension2_id'] = 0;
204                 $_POST['LineMemo'] = "";
205                 if(isset($_POST['_code_id_update'])) {
206                             $Ajax->activate('code_id');
207                 }
208
209                 if ($_POST['PayType'] == payment_person_types::customer())
210                 {
211                         $acc = get_branch_accounts($_POST['PersonDetailID']);
212                         $_POST['code_id'] = $acc['receivables_account'];
213                 }
214                 elseif ($_POST['PayType'] == payment_person_types::supplier())
215                 {
216                         $acc = get_supplier_accounts($_POST['person_id']);
217                         $_POST['code_id'] = $acc['payable_account'];
218                 }
219                 elseif ($_POST['PayType'] == payment_person_types::WorkOrder())
220                         $_POST['code_id'] = get_company_pref('default_assembly_act');
221                 else {
222                         $_POST['code_id'] =
223                                 get_company_pref($payment ? 'default_cogs_act':'default_inv_sales_act');
224                 }
225                 gl_all_accounts_list('code_id', null, false, true);
226                 if ($dim >= 1)
227                         dimensions_list_cells(null, 'dimension_id', null, true, " ", false, 1);
228                 if ($dim > 1)
229                         dimensions_list_cells(null, 'dimension2_id', null, true, " ", false, 2);
230         }
231         if ($dim < 1)
232                 hidden('dimension_id', 0);
233         if ($dim < 2)
234                 hidden('dimension2_id', 0);
235
236         amount_cells(null, 'amount');
237         text_cells_ex(null, 'LineMemo', 35, 50);
238
239         if ($id != -1)
240         {
241                 button_cell('UpdateItem', _("Update"),
242                                 _('Confirm changes'), ICON_UPDATE);
243                 button_cell('CancelItemChanges', _("Cancel"),
244                                 _('Cancel changes'), ICON_CANCEL);
245                 set_focus('amount');
246         }
247         else
248         {
249                 submit_cells('AddItem', _("Add Item"), "colspan=2",
250                     _('Add new item to document'), true);
251         }
252
253         end_row();
254 }
255
256
257 //---------------------------------------------------------------------------------
258
259 function gl_options_controls()
260 {
261         echo "<br><table align='center'>";
262
263         textarea_row(_("Memo"), 'memo_', null, 50, 3);
264
265         echo "</table>";
266 }
267
268
269 //---------------------------------------------------------------------------------
270
271 ?>