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");
16 include_once($path_to_root . "/sales/includes/sales_ui.inc");
18 include_once($path_to_root . "/sales/includes/sales_db.inc");
21 if ($SysPrefs->use_popup_windows)
22 $js .= get_js_open_window(900, 600);
23 page(_($help_context = "View Sales Invoice"), true, false, "", $js);
26 if (isset($_GET["trans_no"]))
28 $trans_id = $_GET["trans_no"];
30 elseif (isset($_POST["trans_no"]))
32 $trans_id = $_POST["trans_no"];
35 // 3 different queries to get the information - what a JOKE !!!!
37 $myrow = get_customer_trans($trans_id, ST_SALESINVOICE);
38 $paym = get_payment_terms($myrow['payment_terms']);
40 $branch = get_branch($myrow["branch_code"]);
42 $sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
44 if (!empty($SysPrefs->prefs['company_logo_on_views']))
45 company_logo_on_view();
47 display_heading(sprintf($myrow['prep_amount'] > 0 ? (
48 $paym['days_before_due']>=0 ? _("FINAL INVOICE #%d") : _("PREPAYMENT INVOICE #%d")) : _("SALES INVOICE #%d"),$trans_id));
51 start_table(TABLESTYLE2, "width='95%'");
52 echo "<tr valign=top><td>"; // outer table
54 /*Now the customer charged to details in a sub table*/
55 start_table(TABLESTYLE, "width='100%'");
56 $th = array(_("Charge To"));
59 label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
63 /*end of the small table showing charge to account details */
65 echo "</td><td>"; // outer table
67 /*end of the main table showing the company name and charge to details */
69 start_table(TABLESTYLE, "width='100%'");
70 $th = array(_("Charge Branch"));
73 label_row(null, $branch["br_name"] . "<br>" . nl2br($branch["br_address"]), "nowrap");
76 echo "</td><td>"; // outer table
78 start_table(TABLESTYLE, "width='100%'");
79 $th = array(_("Payment Terms"));
81 label_row(null, $paym["terms"], "nowrap");
84 echo "</td><td>"; // outer table
86 start_table(TABLESTYLE, "width='100%'");
88 label_cells(_("Reference"), $myrow["reference"], "class='tableheader2'");
89 label_cells(_("Currency"), $sales_order["curr_code"], "class='tableheader2'");
90 label_cells(_("Our Order No"),
91 get_customer_trans_view_str(ST_SALESORDER,$sales_order["order_no"]), "class='tableheader2'");
94 label_cells(_("Customer Order Ref."), $sales_order["customer_ref"], "class='tableheader2'");
95 label_cells(_("Shipping Company"), $myrow["shipper_name"], "class='tableheader2'");
96 label_cells(_("Sales Type"), $myrow["sales_type"], "class='tableheader2'");
99 label_cells(_("Due Date"), sql2date($myrow["due_date"]), "class='tableheader2'", "nowrap");
100 if ($myrow['prep_amount']==0)
101 label_cells(_("Deliveries"), get_customer_trans_view_str(ST_CUSTDELIVERY,
102 get_sales_parent_numbers(ST_SALESINVOICE, $trans_id)), "class='tableheader2'");
103 label_cells(_("Invoice Date"), sql2date($myrow["tran_date"]), "class='tableheader2'", "nowrap");
105 comments_display_row(ST_SALESINVOICE, $trans_id);
109 end_table(1); // outer table
112 $result = get_customer_trans_details(ST_SALESINVOICE, $trans_id);
114 start_table(TABLESTYLE, "width='95%'");
116 if (db_num_rows($result) > 0)
118 $th = array(_("Item Code"), _("Item Description"), _("Quantity"),
119 _("Unit"), _("Price"), _("Discount %"), _("Total"));
122 $k = 0; //row colour counter
124 while ($myrow2 = db_fetch($result))
126 if($myrow2["quantity"]==0) continue;
127 alt_table_row_color($k);
129 $value = round2(((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]),
131 $sub_total += $value;
133 if ($myrow2["discount_percent"] == 0)
135 $display_discount = "";
139 $display_discount = percent_format($myrow2["discount_percent"]*100) . "%";
142 label_cell($myrow2["stock_id"]);
143 label_cell($myrow2["StockDescription"]);
144 qty_cell($myrow2["quantity"], false, get_qty_dec($myrow2["stock_id"]));
145 label_cell($myrow2["units"], "align=right");
146 amount_cell($myrow2["unit_price"]);
147 label_cell($display_discount, "nowrap align=right");
150 } //end while there are line items to print out
152 $display_sub_tot = price_format($sub_total);
153 label_row(_("Sub-total"), $display_sub_tot, "colspan=6 align=right",
154 "nowrap align=right width='15%'");
157 display_note(_("There are no line items on this invoice."), 1, 2);
159 /*Print out the invoice text entered */
160 if ($myrow['ov_freight'] != 0.0)
162 $display_freight = price_format($myrow["ov_freight"]);
163 label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right");
166 $tax_items = get_trans_tax_details(ST_SALESINVOICE, $trans_id);
167 display_customer_trans_tax_details($tax_items, 6);
169 $display_total = price_format($myrow["ov_freight"]+$myrow["ov_gst"]+$myrow["ov_amount"]+$myrow["ov_freight_tax"]);
171 label_row(_("TOTAL INVOICE"), $display_total, "colspan=6 align=right",
172 "nowrap align=right");
173 if ($myrow['prep_amount'])
174 label_row(_("PREPAYMENT AMOUNT INVOICED"), '<b>'.price_format($myrow['prep_amount']).'</b>', "colspan=6 align=right",
175 "nowrap align=right");
178 $voided = is_voided_display(ST_SALESINVOICE, $trans_id, _("This invoice has been voided."));
182 display_allocations_to(PT_CUSTOMER, $myrow['debtor_no'], ST_SALESINVOICE, $trans_id, $myrow['Total']);
185 end_page(true, false, false, ST_SALESINVOICE, $trans_id);