X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Fdoctext.inc;h=a889e0b86fb77ec36a8d466e75beedb310973410;hb=8e7403ce14f472a895ae1304945d7a9a74b49503;hp=38ba3aa8558b3eeaec938f36d868f01e4db54271;hpb=37f4a02e0f4bea58e5b2097d583bf9395ffc515f;p=fa-stable.git diff --git a/reporting/includes/doctext.inc b/reporting/includes/doctext.inc index 38ba3aa8..a889e0b8 100644 --- a/reporting/includes/doctext.inc +++ b/reporting/includes/doctext.inc @@ -1,83 +1,272 @@ . +***********************************************************************/ +/***** +* +* Set document type dependent elements of common page layout. +* +*/ + $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']; + + switch ($this->formData['doctype']) { - if ($doctype == 8) - $this->title = _("PURCHASE ORDER"); - else if ($doctype == 9) + 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'] = $this->formData['order_no']; + $aux_info = array( + _("Customers Reference") => $this->formData["customer_ref"], + _("Sales Person") => get_salesman_name($this->formData['salesman']), + _("Your VAT no.") => '', + _("Our Order No") => '', + _("Valid until") => sql2date($this->formData['delivery_date']), + ); + break; + + case ST_SALESORDER: $this->title = ($print_as_quote==1 ? _("QUOTE") : _("SALES ORDER")); - else if ($doctype == 10) - $this->title = _("INVOICE"); - else + $this->formData['document_name'] =_("Order No."); + $this->formData['document_date'] = $this->formData['ord_date']; + $this->formData['document_number'] = $this->formData['order_no']; + $this->formData['document_amount'] = $this->formData['order_no']; + + $aux_info = array( + _("Customers Reference") => $this->formData["customer_ref"], + _("Sales Person") => get_salesman_name($this->formData['salesman']), + _("Your VAT no.") => '', + _("Our Order No") => '', + _("Delivery Date") => sql2date($this->formData['delivery_date']), + ); + break; + + case ST_CUSTDELIVERY: + $this->title = ($packing_slip==1 ? _("PACKING SLIP") : _("DELIVERY NOTE")); + $this->formData['document_name'] = _("Delivery Note No."); + if (@$packing_slip) + $Payment_Terms = ''; + $ref = $this->formData['order_']; + if ($print_invoice_no == 0) + { + $ref = get_reference(ST_SALESORDER, $this->formData['order_']); + if (!$ref) + $ref = $this->formData['order_']; + } + $aux_info = array( + _("Customers 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->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->formData['document_name'] =_("Credit No."); + $Footer[0] = _("Please quote Credit no. when paying. All amounts stated in") . " - " . $this->formData['curr_code']; + + $aux_info = array( + _("Customers 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 = _("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 ($print_invoice_no == 0) + { + foreach($deliveries as $n => $delivery) { + $deliveries[$n] = get_reference(ST_CUSTDELIVERY, $delivery); + } + } + $aux_info = array( + _("Customers Reference") => $this->formData["customer_ref"], + _("Sales Person") => get_salesman_name($this->formData['salesman']), + _("Your VAT no.") => $this->formData['tax_id'], + _("Delivery Note No.") => implode(',', $deliveries), + _("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( + _("Customers Reference") => $this->formData['supp_account_no'], + _("Type") =>$systypes_array[$this->formData["type"]], + _("Your VAT no.") => $this->formData['tax_id'], + _("Our Order No") => '', + _("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']; + $this->formData['document_date'] = $this->formData['ord_date']; + $this->formData['document_number'] = $print_invoice_no == 0 && isset($this->formData['reference']) + ? $this->formData['reference'] : $this->formData['order_no']; + + $aux_info = array( + _("Customers Reference") => $this->formData['supp_account_no'], + _("Sales Person") => '', + _("Your VAT no.") => '', + _("Our Order No") => '', + _("Due Date") => '', + ); + + $this->headers = array(_("Item Code"), _("Item Description"), + _("Delivery Date"), _("Quantity"), _("Unit"), _("Price"), _("Total")); + break; + + case ST_CUSTPAYMENT: + global $systypes_array; + + $this->title = _("RECEIPT"); + $this->formData['document_name'] =_("Receipt No."); + $Addr1['title'] = _("With thanks from"); + $aux_info = array( + _("Customers 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( + _("Customers 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")); + } + + // 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'] = $print_invoice_no == 0 && isset($this->formData['reference']) + ? $this->formData['reference'] : @$this->formData['trans_no']; + + if (!isset($Payment_Terms)) { - $this->title = _("STATEMENT"); - $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"); -} -if (isset($header2type) || isset($linetype)) -{ - $doc_Invoice_no = _("Invoice no."); - $doc_Order_no = _("Order no."); -} -if (isset($linetype)) -{ - if ($doctype == 8 || $doctype == 9 || $doctype == 10 || $doctype == 11) + $id = $this->formData['payment_terms']; + $sql = "SELECT terms FROM ".TB_PREF."payment_terms WHERE terms_indicator=".db_escape($id); + $result = db_query($sql,"could not get paymentterms"); + $row = db_fetch($result); + $Payment_Terms = _("Payment Terms") . ': ' . $row["terms"]; + } + + // 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"); + $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"); - } -} -?> \ No newline at end of file + foreach(explode("\n", $this->company['legal_text']) as $line) + $Footer[] = $line; + } + +?>