X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Fdoctext.inc;h=16db8df5c0ab6f9d999043f371d4007ab6b59b3b;hb=a67b7a07178dd92bb8e8bf60b6f7b474a1cbf433;hp=0208c46beaf0a2b085d74f53f3c430387f294db5;hpb=f12dbe7523bb1abc6cd69b009ef8f0be838f5348;p=fa-stable.git diff --git a/reporting/includes/doctext.inc b/reporting/includes/doctext.inc index 0208c46b..16db8df5 100644 --- a/reporting/includes/doctext.inc +++ b/reporting/includes/doctext.inc @@ -1,96 +1,288 @@ . +***********************************************************************/ +/***** +* +* 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"), _("Debits"), + _("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'];