sales/includes/ui/sales_credit_ui.inc

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