0004476: Our Order No is always 0 on customer payment receipt. Fixed by empty column.
[fa-stable.git] / reporting / includes / doctext.inc
index 0208c46beaf0a2b085d74f53f3c430387f294db5..4b87fa6df229df98b78d41ccfc5c18e7b8276c29 100644 (file)
 <?php
-if (isset($header2type))
-{
-       $doc_Cust_no = _("Cust no");
-       $doc_Date = _("Date");
-       $doc_Charge_To = _("Charge To");
-       $doc_Delivered_To = _("Delivered To");
-       $doc_Shipping_Company = _("Shipping Company");
-       if ($doctype == 9)
-               $doc_Due_Date = _("Delivery Date");
-  else
-               $doc_Due_Date = _("Due Date");
-       $doc_Your_Ref = _("Your Ref");
-       $doc_Our_Ref = _("Our Ref.");
-       $doc_Your_VAT_no = _("Your VAT no.");
-       $doc_Our_VAT_no = _("Our VAT No.");
-       $doc_Payment_Terms = _("Payment Terms");
-       $doc_Customers_Ref = _("Customers Reference:");
-       $doc_Our_Order_No = _("Our Order No");
-       $doc_Domicile = _("Domicile");
-       if($doctype == 13 || $doctype == 8 || $doctype == 9) {
-        $doc_Bank_Account = '';
-        $doc_Please_Quote = _("All amounts stated in");
-  } else {
-        $doc_Bank_Account = _("Bank Account");
-        $doc_Please_Quote = _("Please quote Invoice no. when paying. All amounts stated in");
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
+/*****
+*
+*      Set document type dependent elements of common page layout.
+*
+*/
+       global $SysPrefs;
+
+       $Addr1 = array(
+                       'title' => _("Charge To"),
+                       'name' => @$this->formData['br_name'] ? $this->formData['br_name'] : @$this->formData['DebtorName'],
+                       'address' => @$this->formData['br_address'] ? $this->formData['br_address'] : @$this->formData['address']
+       );
+       $Addr2 = array(
+                       'title' => _("Delivered To"),
+                       'name' => @$this->formData['deliver_to'],
+                       'address' => @$this->formData['delivery_address']
+       );
+
+       // default item column headers
+       $this->headers = array(_("Item Code"), _("Item Description"), _("Quantity"),
+               _("Unit"), _("Price"), _("Discount %"), _("Total"));
+
+       // for links use 'text' => 'url'
+       $Footer[0] = _("All amounts stated in") . " - " . @$this->formData['curr_code'];
+
+       if (!in_array($this->formData['doctype'], array(ST_STATEMENT, ST_WORKORDER)))
+       {
+               $row = get_payment_terms($this->formData['payment_terms']);
+               $Payment_Terms = _("Payment Terms") . ': ' . $row["terms"];
+               if ($this->formData['doctype'] == ST_SALESINVOICE && $this->formData['prepaid'])
+                       $this->formData['prepaid'] = ($row['days_before_due'] >= 0) ? 'final' : 'partial';
        }
-       $doc_Address = _("Address");
-       $doc_Phone_Fax_Email = _("Phone/Fax/Email");
-       $doc_Bank = _("Bank");
-       $doc_Bank_Account = _("Bank Account");
-       $doc_Payment_Link = _("You can pay through");
-       if ($doctype == 8 || $doctype == 9 || $doctype == 10 || $doctype == 11 || $doctype == 13)
+
+
+       switch ($this->formData['doctype'])
        {
-               if ($doctype == 8)
-                       $this->title = _("PURCHASE ORDER");
-               else if ($doctype == 13)
-                       $this->title = _("DELIVERY NOTE");
-               else if ($doctype == 9)
-                       $this->title = ($print_as_quote==1 ? _("QUOTE") : _("SALES ORDER"));
-               else if ($doctype == 10)
-                       $this->title = _("INVOICE");
-               else
+               case ST_SALESQUOTE:
+                       $this->title = _("SALES QUOTATION");
+                       $this->formData['document_name'] =_("Quotation No.");
+                       $this->formData['document_date'] = $this->formData['ord_date'];
+                       $this->formData['document_number'] = $SysPrefs->print_invoice_no() == 0 && isset($this->formData['reference'])
+                               ? $this->formData['reference'] : $this->formData['order_no'];
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData["customer_ref"],
+                               _("Sales Person") => get_salesman_name($this->formData['salesman']),
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Quotation No") => $this->formData['order_no'],
+                               _("Valid until") => sql2date($this->formData['delivery_date']),
+                       );
+                       break;
+
+               case ST_SALESORDER:
+                       $this->title = ($this->params['print_quote'] ? _("QUOTE") : ($this->formData['prepaid'] ? _("PREPAYMENT ORDER") : _("SALES ORDER")));
+                       $this->formData['document_name'] =_("Order No.");
+                       $this->formData['document_date'] = $this->formData['ord_date'];
+                       $this->formData['document_number'] = $SysPrefs->print_invoice_no() == 0 && isset($this->formData['reference'])
+                               ? $this->formData['reference'] : $this->formData['order_no'];
+                       $this->formData['document_amount'] = $this->formData['order_no'];
+
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData["customer_ref"],
+                               _("Sales Person") => get_salesman_name($this->formData['salesman']),
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Order No") => $this->formData['order_no'],
+                               _("Delivery Date") => sql2date($this->formData['delivery_date']),
+                       );
+                       break;
+
+               case ST_CUSTDELIVERY:
+                       $this->title = ($this->params['packing_slip'] ? _("PACKING SLIP") : _("DELIVERY NOTE"));
+                       $this->formData['document_name'] = _("Delivery Note No.");
+                       if (@$packing_slip)
+                               $Payment_Terms = '';
+                       $ref = $this->formData['order_'];
+                       if ($SysPrefs->print_invoice_no() == 0)
+                       {
+                               $ref = get_reference(ST_SALESORDER, $this->formData['order_']);
+                               if (!$ref)
+                                       $ref = $this->formData['order_'];
+                       }
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData["customer_ref"],
+                               _("Sales Person") => get_salesman_name($this->formData['salesman']),
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Order No") => $ref,
+                               _("To Be Invoiced Before") => sql2date($this->formData['due_date']),
+                       );
+                       break;
+
+               case ST_CUSTCREDIT:
                        $this->title = _("CREDIT NOTE");
-               if ($doctype == 8)
+                       $this->formData['document_name'] =_("Credit No.");
+                       $Footer[0] = _("Please quote Credit no. when paying. All amounts stated in") . " - " . $this->formData['curr_code'];
+
+                       $aux_info = array(
+                               _("Customer's Reference") => @$this->formData["customer_ref"],
+                               _("Sales Person") => get_salesman_name($this->formData['salesman']),
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Order No") => $this->formData['order_'],
+                               _("Due Date") => '',
+                       );
+                       break;
+
+               case ST_SALESINVOICE:
+                       $this->title = $this->formData['prepaid']=='partial' ? _("PREPAYMENT INVOICE")
+                               : ($this->formData['prepaid']=='final' ? _("FINAL INVOICE")  : _("INVOICE"));
+                       $this->formData['document_name'] =_("Invoice No.");
+                       $this->formData['domicile'] = $this->company['domicile'];
+                       $Footer[0] = _("Please quote Invoice no. when paying. All amounts stated in"). " - " . $this->formData['curr_code'];
+
+                       $deliveries = get_sales_parent_numbers(ST_SALESINVOICE, $this->formData['trans_no']);
+                       if ($SysPrefs->print_invoice_no() == 0)
+                       {
+                               foreach($deliveries as $n => $delivery) {
+                                       $deliveries[$n] = get_reference(ST_CUSTDELIVERY, $delivery);
+                               }
+                       }
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData["customer_ref"],
+                               _("Sales Person") => get_salesman_name($this->formData['salesman']),
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                       );
+                       if ($this->formData['prepaid']=='partial')
+                       {
+                               $aux_info[_("Date of Payment")] = sql2date(get_oldest_payment_date($this->formData['trans_no']));
+                               $aux_info[_("Our Order No")]  = $this->formData['order_'];
+                       } else {
+                               if ($this->formData['prepaid'] =='final')
+                                       $aux_info[_("Invoice Date")] = sql2date($this->formData['tran_date']);
+                               else
+                                       $aux_info[_("Date of Sale")] = sql2date(get_oldest_delivery_date($this->formData['trans_no']));
+                               $aux_info[_("Due Date")]  = sql2date($this->formData['due_date']);
+                       }
+                       break;
+
+               case ST_SUPPAYMENT:
+                       global $systypes_array;
+
+                       $this->title = _("REMITTANCE");
+                       $this->formData['document_name'] =_("Remittance No.");
+                       $Addr1['title'] = _("Order To");
+                       $Addr1['name'] = $this->formData['supp_name'];
+                       $Addr1['address'] = $this->formData['address'];
+                       $Addr2['title'] = _("Charge To");
+                       $Addr2['name'] = '';
+                       $Addr2['address'] = '';
+
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData['supp_account_no'],
+                               _("Type") =>$systypes_array[$this->formData["type"]],
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Supplier's Reference") => '',
+                               _("Due Date") => sql2date($this->formData['tran_date']),
+                       );
+                       $this->headers = array(_("Trans Type"), _("#"), _("Date"), _("Due Date"), _("Total Amount"), _("Left to Allocate"), _("This Allocation"));
+                       break;
+
+               case ST_PURCHORDER:
+                       $this->title = _("PURCHASE ORDER");
+                       $this->formData['document_name'] =_("Purchase Order No.");
+                       $Addr1['title'] = _("Order To");
+                       $Addr1['name'] = $this->formData['supp_name'];
+                       $Addr1['address'] = $this->formData['address'];
+                       $Addr2['title'] = _("Deliver To");
+                       $Addr2['name'] = $this->company['coy_name'];
+                       //$Addr2['address'] = $this->company['postal_address']; No, don't destroy delivery address!
+                       $this->formData['document_date'] = $this->formData['ord_date'];
+                       $this->formData['document_number'] = $SysPrefs->print_invoice_no() == 0 && isset($this->formData['reference'])
+                               ? $this->formData['reference'] : $this->formData['order_no'];
+
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData['supp_account_no'],
+                               _("Sales Person") => $this->formData['contact'],
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Supplier's Reference") => @$this->formData['requisition_no'],
+                               _("Order Date") => sql2date($this->formData['document_date']),
+                       );
+
                        $this->headers = array(_("Item Code"), _("Item Description"),
                                _("Delivery Date"), _("Quantity"),      _("Unit"), _("Price"), _("Total"));
-               else
-                       $this->headers = array(_("Item Code"), _("Item Description"),   _("Quantity"),
-                               _("Unit"), _("Price"), _("Discount %"), _("Total"));
-       }
-       else if ($doctype == 12)
-       {
-               $this->title = _("STATEMENT");
-               $this->headers = array(_("Trans Type"), _("#"), _("Date"), _("DueDate"), _("Charges"),
-                       _("Credits"), _("Allocated"), _("Outstanding"));
+                       break;
+
+               case ST_CUSTPAYMENT:
+                       global $systypes_array;
+
+                       $this->title = _("RECEIPT");
+                       $this->formData['document_name'] =_("Receipt No.");
+                       $Addr1['title'] = _("With thanks from");
+                       if ($this->formData['order_'] == "0")
+                               $this->formData['order_'] = "";
+                       $aux_info = array(
+                               _("Customer's Reference") => $this->formData["debtor_ref"],
+                               _("Type") =>$systypes_array[$this->formData["type"]],
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Order No") => $this->formData['order_'],
+                               _("Due Date") => sql2date($this->formData['tran_date']),
+                       );
+                       $this->headers = array(_("Trans Type"), _("#"), _("Date"), _("Due Date"), _("Total Amount"), _("Left to Allocate"), _("This Allocation"));
+                       break;
+
+               case ST_WORKORDER:
+                       global $wo_types_array;
+
+                       $this->title = _("WORK ORDER");
+                       $this->formData['document_name'] =_("Work Order No.");
+                       $this->formData['document_date'] = $this->formData['date_'];
+                       $this->formData['document_number'] = $this->formData['id'];
+                       $Addr1['name'] = $this->formData['location_name'];
+                       $Addr1['address'] = $this->formData['delivery_address'];
+                       $aux_info = array(
+                               _("Reference") => $this->formData['wo_ref'],
+                               _("Type") => $wo_types_array[$this->formData["type"]],
+                               _("Manufactured Item") => $this->formData["StockItemName"],
+                               _("Into Location") => $this->formData["location_name"],
+                               _("Quantity") => $this->formData["units_issued"],
+                       );
+                       $Payment_Terms = _("Required By").": ".sql2date($this->formData["required_by"]);
+                       $this->headers = array(_("Item Code"), _("Item Description"),
+                               _("From Location"), _("Work Centre"),   _("Unit Quantity"), _("Total Quantity"), _("Units Issued"));
+                       unset($Footer[0]);
+                       break;
+
+
+               case ST_STATEMENT:
+                       $this->formData['document_name'] = '';
+                       $this->formData['domicile'] = $this->company['domicile'];
+                       $Payment_Terms = '';
+                       $this->title = _("STATEMENT");
+                       $aux_info = array(
+                               _("Customer's Reference") => '',
+                               _("Sales Person") => '',
+                               _("Your VAT no.") => $this->formData['tax_id'],
+                               _("Our Order No") => '',
+                               _("Delivery Date") => '',
+                       );
+                       $this->headers = array(_("Trans Type"), _("#"), _("Date"), _("DueDate"), _("Charges"),
+                               _("Credits"), _("Allocated"), _("Outstanding"));
        }
-}
-if (isset($emailtype))
-{
-       $doc_Dear_Sirs = _("Dear Sirs");
-       $doc_AttachedFile = _("Attached you will find ");
-       $doc_Kindest_regards = _("Kindest regards");
-       $doc_Payment_Link = _("You can pay through");
-}
-if (isset($header2type) || isset($linetype))
-{
-       $doc_Invoice_no = ($doctype==13 ? _("Delivery Note No.") : (($doctype==8 || $doctype==9) ? _("Order no.") : _("Invoice No.")));
-       $doc_Delivery_no = "Delivery Note No.";
-       $doc_Order_no = _("Order no.");
-}
-if (isset($linetype))
-{
-       if ($doctype == 8 || $doctype == 9 || $doctype == 10 || $doctype == 11 || $doctype == 13)
+
+       // default values
+       if (!isset($this->formData['document_date']))
+               $this->formData['document_date'] = $this->formData['tran_date'];
+
+       if (!isset($this->formData['document_number']))
+               $this->formData['document_number'] = $SysPrefs->print_invoice_no() == 0 && isset($this->formData['reference'])
+                       ? $this->formData['reference'] : @$this->formData['trans_no'];
+
+       // footer generic content
+       if (@$this->formData['bank_name'])
+               $Footer[] = _("Bank"). ": ".$this->formData['bank_name']. ", " . _("Bank Account") . ": " . $this->formData['bank_account_number'];
+
+       if (@$this->formData['payment_service'])        //payment link
        {
-               $doc_Sub_total = _("Sub-total");
-               $doc_Shipping = _("Shipping");
-               $doc_Included = _("Included");
-               $doc_Amount = _("Amount");
-               $doc_TOTAL_INVOICE = _("TOTAL INVOICE");
-               $doc_TOTAL_ORDER = _("TOTAL ORDER EX VAT");
-               $doc_TOTAL_PO = _("TOTAL PO EX VAT");
-               $doc_TOTAL_DELIVERY = _("TOTAL DELIVERY INCL. VAT");
+               $amt = number_format($this->formData["ov_freight"] + $this->formData["ov_gst"] + $this->formData["ov_amount"], user_price_dec());
+               $service = $this->formData['payment_service'];
+               $url = payment_link($service, array(
+                       'company_email' => $this->company['email'],
+                       'amount' => $amt,
+                       'currency' => $this->formData['curr_code'],
+                       'comment' => $this->title . " " . $this->formData['reference']
+                       ));
+               $Footer[_("You can pay through"). " $service: "] = "$url";
        }
-       else if ($doctype == 12)
+
+       if ($this->formData['doctype'] == ST_CUSTPAYMENT)
+               $Footer[] = _("* Subject to Realisation of the Cheque.");
+
+       if ($this->params['comments'] != '')
+               $Footer[] = $this->params['comments'];
+
+       if (($this->formData['doctype'] == ST_SALESINVOICE || $this->formData['doctype'] == ST_STATEMENT) && $this->company['legal_text'] != "") 
        {
-               $doc_Outstanding = _("Outstanding Transactions");
-               $doc_Current = _("Current");
-               $doc_Total_Balance = _("Total Balance");
-               $doc_Statement = _("Statement");
-               $doc_as_of = _("as of");
-               $doc_Days = _("Days");
-               $doc_Over = _("Over");
+               foreach(explode("\n", $this->company['legal_text']) as $line)
+                       $Footer[] = $line;
        }
-}
-?>
\ No newline at end of file
+
+       $this->formData['recipient_name'] = $Addr1['name'];