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 include_once($path_to_root . "/includes/ui.inc");
13 include_once($path_to_root . "/includes/ui/items_cart.inc");
15 //--------------------------------------------------------------------------------
17 function display_order_header(&$Order)
21 $qes = has_quick_entries(QE_JOURNAL);
22 $new = $Order->order_id==0;
23 start_outer_table(TABLESTYLE2, "width='90%'");
26 date_row(_("Journal Date:"), 'date_', '', $new, 0,0,0,null, true);
27 if (input_changed('date_'))
30 $Ajax->activate('ref');
33 currencies_list_row(_('Currency:'), 'currency', null, true);
34 if (list_updated('currency'))
35 unset($_POST['_ex_rate']);
36 exchange_rate_display(get_company_pref('curr_default'), get_post('currency'), get_post('date_'), true);
38 if (list_updated('currency'))
39 $Order->clear_items();
43 date_row(_("Document Date:"), 'doc_date', '', $new);
44 date_row(_("Event Date:"), 'event_date', '', $new);
45 text_row(_("Source ref:"), 'source_ref', null, 30, 60);
51 ref_row(_("Reference:"), 'ref', null, get_post('ref'), false, ST_JOURNAL, get_post('date_'));
52 hidden('ref_original');
57 quick_entries_list_row(_("Quick Entry").":", 'quick', null, QE_JOURNAL, true);
60 $qid = get_quick_entry(get_post('quick'));
61 if (list_updated('quick')) {
62 unset($_POST['totamount']); // enable default
63 $Ajax->activate('totamount');
66 if ($qid['bal_type'] == 1)
68 $accname = get_gl_account_name($qid['base_desc']);
69 label_row(($qid['base_amount'] == 0 ? _("Yearly") : _("Monthly")) . " ". _("balance from account")." ".
70 $qid['base_desc']." ".$accname." ".submit('go', _("Go"), false, false, true),'', "colspan=2");
74 text_row(_('Additional info:'), 'aux_info', null, 35, 255);
75 amount_row($qid['base_desc'].":", 'totamount', price_format($qid['base_amount']),
76 null, " ".submit('go', _("Go"), false, false, true));
81 check_row(_('Include in tax register:'), 'taxable_trans', null, true);
82 // Query the user to retain the reconciled status
84 $result = get_bank_trans(ST_JOURNAL, $Order->order_id);
85 $row = db_fetch($result);
87 && $row['reconciled']) {
88 check_row(_('Reconciled:'), 'reconciled', 1, true);
89 hidden('reconciled_date', $row['reconciled']);
95 //---------------------------------------------------------------------------------
97 function display_gl_items($title, &$order)
101 display_heading($title);
103 $dim = get_company_pref('use_dimension');
105 $id = find_submit('Edit');
106 $sub_type = is_subledger_account(get_post('code_id'));
107 $has_subaccounts = $order->has_sub_accounts();
109 div_start('items_table');
110 start_table(TABLESTYLE, "width='95%'");
112 $th = array(_("Account Code"), _("Account Description"), _("Dimension")." 1",
113 _("Dimension")." 2", _("Debit"), _("Credit"), _("Memo"), "");
115 $th = array(_("Account Code"), _("Account Description"), _("Dimension"),
116 _("Debit"), _("Credit"), _("Memo"), "");
118 $th = array(_("Account Code"), _("Account Description"),
119 _("Debit"), _("Credit"), _("Memo"), "");
121 if (count($order->gl_items)) $th[] = '';
122 if ($sub_type || $has_subaccounts)
123 array_insert($th, 2, _("Counterparty"));
130 $id = get_post('Index', -1);
132 foreach ($order->gl_items as $line => $item)
136 alt_table_row_color($k);
138 $acc = $item->code_id . ($item->person_id ? sprintf(' %05d', $item->person_id) : '');
139 label_cells($acc, $item->description);
141 if ($sub_type || $has_subaccounts)
142 label_cell($item->person_name);
145 label_cell(get_dimension_string($item->dimension_id, true));
147 label_cell(get_dimension_string($item->dimension2_id, true));
148 if ($item->amount > 0)
150 amount_cell(abs($item->amount));
156 amount_cell(abs($item->amount));
158 label_cell($item->reference);
160 edit_button_cell("Edit$line", _("Edit"),
161 _('Edit journal line'));
162 delete_button_cell("Delete$line", _("Delete"),
163 _('Remove line from journal'));
168 gl_edit_item_controls($order, $dim, $item->person_id, $line);
173 gl_edit_item_controls($order, $dim, $sub_type);
175 if ($order->count_gl_items())
177 $colspan = ($dim == 2 ? "4" : ($dim == 1 ? "3" : "2")) + ($sub_type || $has_subaccounts ? 1 : 0);
179 label_cell(_("Total"), "align=right colspan=" . $colspan);
180 amount_cell($order->gl_items_total_debit());
181 amount_cell(abs($order->gl_items_total_credit()));
182 label_cell('', "colspan=3");
190 //---------------------------------------------------------------------------------
192 function gl_edit_item_controls(&$order, $dim, $sub_accounts, $Index=null)
197 $id = find_submit('Edit');
199 $continue = $id = get_post('Index', -1);
201 if ($Index != -1 && $Index == $id)
203 // Modifying an existing row
204 $item = $order->gl_items[$Index];
205 if (!isset($continue))
207 $_POST['code_id'] = $item->code_id;
208 $_POST['dimension_id'] = $item->dimension_id;
209 $_POST['dimension2_id'] = $item->dimension2_id;
210 $_POST['person_id'] = $item->person_id;
211 if ($item->amount > 0)
213 $_POST['AmountDebit'] = price_format($item->amount);
214 $_POST['AmountCredit'] = "";
218 $_POST['AmountDebit'] = "";
219 $_POST['AmountCredit'] = price_format(abs($item->amount));
221 $_POST['description'] = $item->description;
222 $_POST['LineMemo'] = $item->reference;
224 hidden('Index', $id);
225 $skip_bank = !$_SESSION["wa_current_user"]->can_access('SA_BANKJOURNAL');
226 echo gl_all_accounts_list('code_id', null, $skip_bank, true, _('[Select account]'), true, false, false);
228 if (is_subledger_account(get_post('code_id')))
229 { // for home currency postings show all customers
230 $sel_cur = get_post('currency', $order->currency);
231 subledger_list_cells(null, 'person_id', get_post('code_id'), null, false, false,
232 get_company_currency() == $sel_cur ? null : $sel_cur);
233 } elseif ($order->has_sub_accounts())
236 dimensions_list_cells(null, 'dimension_id', null, true, " ", false, 1);
238 dimensions_list_cells(null, 'dimension2_id', null, true, " ", false, 2);
239 $Ajax->activate('items_table');
243 $skip_bank = !$_SESSION["wa_current_user"]->can_access('SA_BANKJOURNAL');
244 echo gl_all_accounts_list('code_id', null, $skip_bank, true, _('[Select account]'), true, false, false);
247 // for home currency postings show all customers
248 $sel_cur = get_post('currency', $order->currency);
249 subledger_list_cells(null, 'person_id', get_post('code_id'), null, false, false,
250 get_company_currency() == $sel_cur ? null : $sel_cur);
252 elseif ($order->has_sub_accounts())
256 dimensions_list_cells(null, 'dimension_id', null, true, " ", false, 1);
258 dimensions_list_cells(null, 'dimension2_id', null, true, " ", false, 2);
259 $_POST['LineMemo'] = "";
262 if (get_post('_code_id_update'))
264 $Ajax->activate('code_id');
265 set_focus($sub_accounts ? 'person_id' : 'AmountDebit');
268 hidden('dimension_id', 0);
270 hidden('dimension2_id', 0);
272 small_amount_cells(null, 'AmountDebit');
273 small_amount_cells(null, 'AmountCredit');
274 text_cells_ex(null, 'LineMemo', 35, 255);
278 button_cell('UpdateItem', _("Update"),
279 _('Confirm changes'), ICON_UPDATE);
280 button_cell('CancelItemChanges', _("Cancel"),
281 _('Cancel changes'), ICON_CANCEL);
285 submit_cells('AddItem', _("Add Item"), "colspan=2",
286 _('Add new line to journal'), true);
291 //---------------------------------------------------------------------------------
293 function gl_options_controls()
295 echo "<br><table align='center'>";
297 textarea_row(_("Memo"), 'memo_', null, 50, 3);