5 include_once($path_to_root . "/includes/session.inc");
7 include_once($path_to_root . "/sales/includes/sales_ui.inc");
9 include_once($path_to_root . "/sales/includes/sales_db.inc");
12 if ($use_popup_windows)
13 $js .= get_js_open_window(900, 600);
14 page(_("View Sales Dispatch"), true, false, "", $js);
17 if (isset($_GET["trans_no"]))
19 $trans_id = $_GET["trans_no"];
21 elseif (isset($_POST["trans_no"]))
23 $trans_id = $_POST["trans_no"];
26 // 3 different queries to get the information - what a JOKE !!!!
28 $myrow = get_customer_trans($trans_id, 13);
30 $branch = get_branch($myrow["branch_code"]);
32 $sales_order = get_sales_order_header($myrow["order_"]);
34 display_heading(sprintf(_("DISPATCH NOTE #%d"),$trans_id));
37 start_table("$table_style2 width=95%");
38 echo "<tr valign=top><td>"; // outer table
40 /*Now the customer charged to details in a sub table*/
41 start_table("$table_style width=100%");
42 $th = array(_("Charge To"));
45 label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
49 /*end of the small table showing charge to account details */
51 echo "</td><td>"; // outer table
53 /*end of the main table showing the company name and charge to details */
55 start_table("$table_style width=100%");
56 $th = array(_("Charge Branch"));
59 label_row(null, $branch["br_name"] . "<br>" . nl2br($branch["br_address"]), "nowrap");
62 echo "</td><td>"; // outer table
64 start_table("$table_style width=100%");
65 $th = array(_("Delivered To"));
68 label_row(null, $sales_order["deliver_to"] . "<br>" . nl2br($sales_order["delivery_address"]),
72 echo "</td><td>"; // outer table
74 start_table("$table_style width=100%");
76 label_cells(_("Reference"), $myrow["reference"], "class='tableheader2'");
77 label_cells(_("Currency"), $sales_order["curr_code"], "class='tableheader2'");
78 label_cells(_("Our Order No"),
79 get_customer_trans_view_str(systypes::sales_order(),$sales_order["order_no"]), "class='tableheader2'");
82 label_cells(_("Customer Order Ref."), $sales_order["customer_ref"], "class='tableheader2'");
83 label_cells(_("Shipping Company"), $myrow["shipper_name"], "class='tableheader2'");
84 label_cells(_("Sales Type"), $myrow["sales_type"], "class='tableheader2'");
87 label_cells(_("Dispatch Date"), sql2date($myrow["tran_date"]), "class='tableheader2'", "nowrap");
88 label_cells(_("Due Date"), sql2date($myrow["due_date"]), "class='tableheader2'", "nowrap");
90 comments_display_row(13, $trans_id);
94 end_table(1); // outer table
97 $result = get_customer_trans_details(13, $trans_id);
99 start_table("$table_style width=95%");
101 if (db_num_rows($result) > 0)
103 $th = array(_("Item Code"), _("Item Description"), _("Quantity"),
104 _("Unit"), _("Price"), _("Discount %"), _("Total"));
107 $k = 0; //row colour counter
109 while ($myrow2 = db_fetch($result))
111 if($myrow2['quantity']==0) continue;
112 alt_table_row_color($k);
114 $value = ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]);
115 $sub_total += $value;
117 if ($myrow2["discount_percent"] == 0)
119 $display_discount = "";
123 $display_discount = percent_format($myrow2["discount_percent"]*100) . "%";
126 label_cell($myrow2["stock_id"]);
127 label_cell($myrow2["StockDescription"]);
128 qty_cell($myrow2["quantity"]);
129 label_cell($myrow2["units"], "align=right");
130 amount_cell($myrow2["unit_price"]);
131 label_cell($display_discount, "nowrap align=right");
134 } //end while there are line items to print out
138 display_note(_("There are no line items on this dispatch."), 1, 2);
140 $display_sub_tot = price_format($sub_total);
141 $display_freight = price_format($myrow["ov_freight"]);
143 /*Print out the delivery note text entered */
144 label_row(_("Sub-total"), $display_sub_tot, "colspan=6 align=right",
145 "nowrap align=right width=15%");
146 label_row(_("Shipping"), $display_freight, "colspan=6 align=right", "nowrap align=right");
148 $tax_items = get_customer_trans_tax_details(13, $trans_id);
149 display_customer_trans_tax_details($tax_items, 6);
151 $display_total = price_format($myrow["ov_freight"]+$myrow["ov_amount"]+$myrow["ov_freight_tax"]+$myrow["ov_gst"]);
153 label_row(_("TOTAL VALUE"), $display_total, "colspan=6 align=right",
154 "nowrap align=right");
157 is_voided_display(13, $trans_id, _("This dispatch has been voided."));