Fixed edit line total, price update after date change
[fa-stable.git] / sales / includes / ui / sales_credit_ui.inc
1 <?php
2
3 include_once($path_to_root . "/includes/ui.inc");
4
5 // ------------------------------------------------------------------------------
6
7 function display_credit_header(&$order)
8 {
9         global $table_style, $Ajax;
10         start_table("width=80% $table_style");
11         echo "<tr><td valign=top>"; // outer table
12         echo "<table>";
13
14         $customer_error = "";
15         $change_prices = 0;
16
17     if (!isset($_POST['customer_id']) && (get_global_customer() != reserved_words::get_all()))
18         $_POST['customer_id'] = get_global_customer();
19
20         customer_list_row(_("Customer:"), 'customer_id', null, false, true);
21
22         if ($order->customer_id != $_POST['customer_id'] /*|| $order->sales_type != $_POST['sales_type_id']*/)
23         {
24                 // customer has changed
25                 $Ajax->activate('branch_id');
26         }
27
28         customer_branches_list_row(_("Branch:"), $_POST['customer_id'], 
29           'branch_id', null, false, true, true);
30
31         //if (($_SESSION['credit_items']->order_no == 0) ||
32         //      ($order->customer_id != $_POST['customer_id']) ||
33         //      ($order->Branch != $_POST['branch_id']))
34         //      $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']);
35         if (($order->customer_id != $_POST['customer_id']) ||
36                 ($order->Branch != $_POST['branch_id']))
37           {
38
39                                 $old_order = (PHP_VERSION<5) ? $order : clone( $order );
40                                 $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']);
41
42                                 $_POST['Location'] = $order->Location;
43                                 $_POST['deliver_to'] = $order->deliver_to;
44                                 $_POST['delivery_address'] = $order->delivery_address;
45                                 $_POST['phone'] = $order->phone;
46                                 $Ajax->activate('Location');
47                                 $Ajax->activate('deliver_to');
48                                 $Ajax->activate('phone');
49                                 $Ajax->activate('delivery_address');
50                                 // change prices if necessary
51                                 // what about discount in template case?
52                                 if ($old_order->customer_currency != $order->customer_currency) {
53                                     $change_prices = 1;
54                                 }
55                                 if ($old_order->sales_type != $order->sales_type) {
56                                 //  || $old_order->default_discount!=$order->default_discount
57                                         $_POST['sales_type_id'] = $order->sales_type;
58                                     $Ajax->activate('sales_type_id');
59                                     $change_prices = 1;
60                                 }
61                                 unset($old_order);
62           }
63         set_global_customer($_POST['customer_id']);
64
65         if (!isset($_POST['ref']))
66                 $_POST['ref'] = references::get_next(11);
67         if ($_SESSION['Items']->trans_no==0)
68             ref_row(_("Reference").':', 'ref');
69         else
70             label_row(_("Reference").':', $_POST['ref'] );
71
72
73
74         echo "</table>";
75
76         echo "</td><td>"; // outer table
77
78         if (!is_company_currency($order->customer_currency))
79         {
80             div_start('currency');
81                 echo "<table height='5'>";
82                 label_row(_("Customer Currency:"), $order->customer_currency);
83                 exchange_rate_display($order->customer_currency, get_company_currency(),
84                         $_POST['OrderDate']);
85                 echo "</table>";
86                 echo "</td><td>"; // outer table
87             div_end();
88         }
89
90         echo "<table height='5'>";
91
92     if (!isset($_POST['sales_type_id']))
93         $_POST['sales_type_id'] = $order->sales_type;
94     sales_types_list_row(_("Sales Type"), 'sales_type_id', $_POST['sales_type_id'], true);
95         
96         if ($order->sales_type != $_POST['sales_type_id']) {
97                 $myrow = get_sales_type($_POST['sales_type_id']);
98                 $order->set_sales_type($myrow['id'], $myrow['sales_type'],
99                 $myrow['tax_included'], $myrow['factor']);
100                 $Ajax->activate('sales_type_id');
101                 $change_prices = 1;
102         }
103
104         label_row(_("Customer Discount:"), ($order->default_discount * 100) . "%");
105         echo "</table>";
106
107         echo "</td><td>"; // outer table
108
109         echo "<table height='5'>";
110
111         if (!isset($_POST['OrderDate']) || $_POST['OrderDate'] == "")
112                 $_POST['OrderDate'] = $order->document_date;
113
114         date_row(_("Date:"), 'OrderDate', '', null, 0, 0, 0, null, true);
115         if (isset($_POST['_OrderDate_changed'])) {
116                 $change_prices = 1;
117                 $Ajax->activate('currency');
118         }
119     shippers_list_row(_("Shipping Company:"), 'ShipperID', $order->ship_via);
120
121         echo "</table>";
122
123         echo "</td></tr>";
124
125         end_table(1); // outer table
126
127         if ($change_prices != 0) {
128                 foreach ($order->line_items as $line_no=>$item) {
129                         $line = &$order->line_items[$line_no];
130                         $line->price = get_price($line->stock_id, $order->customer_currency,
131                                 $order->sales_type, $order->price_factor, get_post('OrderDate'));
132                 //              $line->discount_percent = $order->default_discount;
133                 }
134             $Ajax->activate('items_table');
135         }
136
137
138         return $customer_error;
139 }
140
141 //---------------------------------------------------------------------------------
142
143 function display_credit_items($title, &$order)
144 {
145     global $table_style, $path_to_root;
146
147     display_heading($title);
148     div_start('items_table');
149     start_table("$table_style width=90%");
150     $th = array(_("Item Code"), _("Item Description"), _("Quantity"), _("Unit"),
151         _("Price"), _("Discount %"), _("Total"),'');
152
153     if (count($order->line_items)) $th[]= '';
154
155     table_header($th);
156
157     $subtotal = 0;
158     $k = 0;  //row colour counter
159
160     $id = find_submit('Edit');
161
162     foreach ($order->line_items as $line_no=>$line)
163     {
164         $line_total =   round($line->qty_dispatched * $line->price * (1 - $line->discount_percent),
165            user_price_dec());
166
167         if ( $id != $line_no)
168         {
169             alt_table_row_color($k);
170
171             label_cell("<a target='_blank' href='$path_to_root/inventory/inquiry/stock_status.php?" . SID . "stock_id=" . $line->stock_id . "'>$line->stock_id</a>");
172             label_cell($line->item_description, "nowrap");
173             qty_cell($line->qty_dispatched, false, get_qty_dec($line->stock_id));
174             label_cell($line->units);
175             amount_cell($line->price);
176
177             amount_cell($line->discount_percent * 100);
178             amount_cell($line_total);
179
180             edit_button_cell("Edit$line_no", _('Edit'),
181                                 _('Edit document line'));
182             edit_button_cell("Delete$line_no", _('Delete'),
183                                 _('Remove line from document'));
184
185             end_row();
186         }
187         else
188         {
189             credit_edit_item_controls($order, $k, $line_no);
190         }
191
192         $subtotal += $line_total;
193     }
194
195     if ($id==-1)
196         credit_edit_item_controls($order, $k);
197
198     $display_sub_total = price_format($subtotal);
199     label_row(_("Sub-total"), $display_sub_total, "colspan=6 align=right", "align=right", 2);
200
201     if (!isset($_POST['ChargeFreightCost']) OR ($_POST['ChargeFreightCost'] == ""))
202         $_POST['ChargeFreightCost'] = price_format(0);
203
204     amount_cells_ex(_("Shipping"), 'ChargeFreightCost', 8, 8, $_POST['ChargeFreightCost'], "colspan=6 align=right");
205     label_cell('', 'colspan=2');
206
207     $taxes = $order->get_taxes($_POST['ChargeFreightCost']);
208
209     $tax_total = display_edit_tax_items($taxes, 6, $_SESSION['Items']->tax_included);
210
211     $display_total = price_format(($subtotal + $_POST['ChargeFreightCost'] + $tax_total));
212
213     label_row(_("Credit Note Total"), $display_total, "colspan=6 align=right","class='amount'", 2);
214
215     end_table();
216     div_end();
217 }
218
219 //---------------------------------------------------------------------------------
220
221 function credit_edit_item_controls(&$order, $rowcounter, $line_no=-1)
222 {
223         global $Ajax;
224         alt_table_row_color($rowcounter);
225         $id = find_submit('Edit');
226
227         if ($line_no!=-1 && $line_no == $id)
228         {
229                 $_POST['stock_id'] = $order->line_items[$id]->stock_id;
230                 $_POST['qty'] = qty_format($order->line_items[$id]->qty_dispatched, $_POST['stock_id'], $dec);
231                 $_POST['price'] = price_format($order->line_items[$id]->price);
232                 $_POST['Disc'] = percent_format(($order->line_items[$id]->discount_percent)*100);
233                 $_POST['units'] = $order->line_items[$id]->units;
234                 hidden('stock_id', $_POST['stock_id']);
235                 label_cell($_POST['stock_id']);
236                 label_cell($order->line_items[$id]->item_description, "nowrap");
237             $Ajax->activate('items_table');
238         }
239         else
240         {
241                 stock_items_list_cells(null,'stock_id', null, false, true);
242                 if (list_updated('stock_id')) {
243                             $Ajax->activate('price');
244                             $Ajax->activate('qty');
245                             $Ajax->activate('units');
246                             $Ajax->activate('line_total');
247                 }
248                 $item_info = get_item_edit_info($_POST['stock_id']);
249
250                 $_POST['units'] = $item_info["units"];
251                 $_POST['qty'] = qty_format(0, $_POST['stock_id'], $dec);
252                 $_POST['price'] = price_format(get_price($_POST['stock_id'], $order->customer_currency,
253                     $order->sales_type, $order->price_factor, $order->document_date));
254
255                 // default to the customer's discount %
256                 $_POST['Disc'] = percent_format($order->default_discount * 100);
257         }
258
259         qty_cells(null, 'qty', $_POST['qty'], null, null, $dec);
260
261         label_cell($_POST['units']);
262         amount_cells(null, 'price',  null);
263         small_amount_cells(null, 'Disc', percent_format(0), null, null, user_percent_dec());
264
265         amount_cell(input_num('qty') * input_num('price') * (1 - input_num('Disc')/100));
266
267         if ($id!=-1)
268         {
269                 edit_button_cell('UpdateItem', _("Update"),
270                                 _('Confirm changes'));
271                 edit_button_cell('CancelItemChanges', _("Cancel"),
272                                 _('Cancel changes'));
273                 hidden('line_no', $line_no);
274                 set_focus('qty');
275         }
276         else
277         {
278                 submit_cells('AddItem', _("Add Item"), "colspan=2",
279                     _('Add new item to document'), true);
280         }
281
282         end_row();
283 }
284
285
286 //---------------------------------------------------------------------------------
287
288 function credit_options_controls()
289 {
290         global $table_style2, $Ajax;
291         echo "<br>";
292
293 if (isset($_POST['_CreditType_update']))
294         $Ajax->activate('options');
295
296  div_start('options');
297         start_table("$table_style2");
298
299         credit_type_list_row(_("Credit Note Type"), 'CreditType', null, true);
300
301         if ($_POST['CreditType'] == "Return")
302         {
303
304                 /*if the credit note is a return of goods then need to know which location to receive them into */
305                 if (!isset($_POST['Location']))
306                         $_POST['Location'] = $_SESSION['Items']->Location;
307                 locations_list_row(_("Items Returned to Location"), 'Location', $_POST['Location']);
308         }
309         else
310         {
311                 /* the goods are to be written off to somewhere */
312                 gl_all_accounts_list_row(_("Write off the cost of the items to"), 'WriteOffGLCode', null);
313         }
314
315         textarea_row(_("Memo"), "CreditText", null, 51, 3);
316         echo "</table>";
317  div_end();
318 }
319
320
321 //---------------------------------------------------------------------------------
322
323 ?>