sales/view/view_invoice.php

   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 $page_security = 'SA_SALESTRANSVIEW';
  13 $path_to_root = "../..";
  14 include_once($path_to_root . "/includes/session.inc");
  15
  16 include_once($path_to_root . "/sales/includes/sales_ui.inc");
  17
  18 include_once($path_to_root . "/sales/includes/sales_db.inc");
  19
  20 $js = "";
  21 if ($use_popup_windows)
  22         $js .= get_js_open_window(900, 600);
  23 page(_($help_context = "View Sales Invoice"), true, false, "", $js);
  24
  25
  26 if (isset($_GET["trans_no"]))
  27 {
  28         $trans_id = $_GET["trans_no"];
  29 }
  30 elseif (isset($_POST["trans_no"]))
  31 {
  32         $trans_id = $_POST["trans_no"];
  33 }
  34
  35 // 3 different queries to get the information - what a JOKE !!!!
  36
  37 $myrow = get_customer_trans($trans_id, ST_SALESINVOICE);
  38
  39 $branch = get_branch($myrow["branch_code"]);
  40
  41 $sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
  42
  43 display_heading(sprintf(_("SALES INVOICE #%d"),$trans_id));
  44
  45 echo "<br>";
  46 start_table(TABLESTYLE2, "width='95%'");
  47 echo "<tr valign=top><td>"; // outer table
  48
  49 /*Now the customer charged to details in a sub table*/
  50 start_table(TABLESTYLE, "width='100%'");
  51 $th = array(_("Charge To"));
  52 table_header($th);
  53
  54 label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
  55
  56 end_table();
  57
  58 /*end of the small table showing charge to account details */
  59
  60 echo "</td><td>"; // outer table
  61
  62 /*end of the main table showing the company name and charge to details */
  63
  64 start_table(TABLESTYLE, "width='100%'");
  65 $th = array(_("Charge Branch"));
  66 table_header($th);
  67
  68 label_row(null, $branch["br_name"] . "<br>" . nl2br($branch["br_address"]), "nowrap");
  69 end_table();
  70
  71 echo "</td><td>"; // outer table
  72
  73 start_table(TABLESTYLE, "width='100%'");
  74 $th = array(_("Payment Terms"));
  75 table_header($th);
  76 $paym = get_payment_terms($myrow['payment_terms']);
  77 label_row(null, $paym["terms"], "nowrap");
  78 end_table();
  79
  80 echo "</td><td>"; // outer table
  81
  82 start_table(TABLESTYLE, "width='100%'");
  83 start_row();
  84 label_cells(_("Reference"), $myrow["reference"], "class='tableheader2'");
  85 label_cells(_("Currency"), $sales_order["curr_code"], "class='tableheader2'");
  86 label_cells(_("Our Order No"),
  87         get_customer_trans_view_str(ST_SALESORDER,$sales_order["order_no"]), "class='tableheader2'");
  88 end_row();
  89 start_row();
  90 label_cells(_("Customer Order Ref."), $sales_order["customer_ref"], "class='tableheader2'");
  91 label_cells(_("Shipping Company"), $myrow["shipper_name"], "class='tableheader2'");
  92 label_cells(_("Sales Type"), $myrow["sales_type"], "class='tableheader2'");
  93 end_row();
  94 start_row();
  95 label_cells(_("Invoice Date"), sql2date($myrow["tran_date"]), "class='tableheader2'", "nowrap");
  96 label_cells(_("Due Date"), sql2date($myrow["due_date"]), "class='tableheader2'", "nowrap");
  97 label_cells(_("Deliveries"), get_customer_trans_view_str(ST_CUSTDELIVERY,
  98         get_sales_parent_numbers(ST_SALESINVOICE, $trans_id)), "class='tableheader2'");
  99 end_row();
 100 comments_display_row(ST_SALESINVOICE, $trans_id);
 101 end_table();
 102
 103 echo "</td></tr>";
 104 end_table(1); // outer table
 105
 106
 107 $result = get_customer_trans_details(ST_SALESINVOICE, $trans_id);
 108
 109 start_table(TABLESTYLE, "width='95%'");
 110
 111 if (db_num_rows($result) > 0)
 112 {
 113         $th = array(_("Item Code"), _("Item Description"), _("Quantity"),
 114                 _("Unit"), _("Price"), _("Discount %"), _("Total"));
 115         table_header($th);
 116
 117         $k = 0; //row colour counter
 118         $sub_total = 0;
 119         while ($myrow2 = db_fetch($result))
 120         {
 121             if($myrow2["quantity"]==0) continue;
 122                 alt_table_row_color($k);
 123
 124                 $value = round2(((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]),
 125                    user_price_dec());
 126                 $sub_total += $value;
 127
 128             if ($myrow2["discount_percent"] == 0)
 129             {
 130                         $display_discount = "";
 131             }
 132             else
 133             {
 134                         $display_discount = percent_format($myrow2["discount_percent"]*100) . "%";
 135             }
 136
 137             label_cell($myrow2["stock_id"]);
 138                 label_cell($myrow2["StockDescription"]);
 139         qty_cell($myrow2["quantity"], false, get_qty_dec($myrow2["stock_id"]));
 140         label_cell($myrow2["units"], "align=right");
 141         amount_cell($myrow2["unit_price"]);
 142         label_cell($display_discount, "nowrap align=right");
 143         amount_cell($value);
 144                 end_row();
 145         } //end while there are line items to print out
 146
 147         $display_sub_tot = price_format($sub_total);
 148         label_row(_("Sub-total"), $display_sub_tot, "colspan=6 align=right",
 149                 "nowrap align=right width='15%'");
 150 }
 151 else
 152         display_note(_("There are no line items on this invoice."), 1, 2);
 153
 154
 155 /*Print out the invoice text entered */
 156 if ($myrow['ov_freight'] != 0.0)
 157 {
 158         $display_freight = price_format($myrow["ov_freight"]);
 159         label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right");
 160 }
 161 $tax_items = get_trans_tax_details(ST_SALESINVOICE, $trans_id);
 162 display_customer_trans_tax_details($tax_items, 6);
 163
 164 $display_total = price_format($myrow["ov_freight"]+$myrow["ov_gst"]+$myrow["ov_amount"]+$myrow["ov_freight_tax"]);
 165
 166 label_row(_("TOTAL INVOICE"), $display_total, "colspan=6 align=right",
 167         "nowrap align=right");
 168 end_table(1);
 169
 170 $voided = is_voided_display(ST_SALESINVOICE, $trans_id, _("This invoice has been voided."));
 171
 172 if (!$voided)
 173 {
 174         display_allocations_to(PT_CUSTOMER, $myrow['debtor_no'], ST_SALESINVOICE, $trans_id, $myrow['Total']);
 175 }
 176
 177 end_page(true, false, false, ST_SALESINVOICE, $trans_id);
 178
 179 ?>