New files from unstable branch
[fa-stable.git] / reporting / includes / header2.inc
index e1ad9af18889bbd11f8c67a7dc4f49a51beafc7a..cb40430a04050e3a2d6cd6263eba9c4ee2d5f3cc 100644 (file)
@@ -59,7 +59,7 @@
                $this->NewLine();
                if ($this->company['coy_logo'] != '')
                {
-                       $logo = $comp_path .'/'. user_company() . "/images/" . $this->company['coy_logo'];
+                       $logo = company_path() . "/images/" . $this->company['coy_logo'];
                        $this->AddImage($logo, $ccol, $this->row, 0, 40);
                }
                else
                $this->NewLine(3);
                $this->Text($mcol + 100, $doc_Date);
                if ($doctype == ST_SALESQUOTE || $doctype == ST_PURCHORDER || $doctype == ST_SALESORDER)
-                       $this->Text($mcol + 180, sql2date($myrow['ord_date']));
+                       $this->Text($mcol + 180, sql2date($this->formData['ord_date']));
                elseif ($doctype == ST_WORKORDER)       
-                       $this->Text($mcol + 180, sql2date($myrow['date_']));
+                       $this->Text($mcol + 180, sql2date($this->formData['date_']));
                else
-                       $this->Text($mcol + 180, sql2date($myrow['tran_date']));
+                       $this->Text($mcol + 180, sql2date($this->formData['tran_date']));
                $this->NewLine();
                $this->Text($mcol + 100, $doc_Invoice_no);
                if ($doctype == ST_SALESQUOTE || $doctype == ST_PURCHORDER || $doctype == ST_SALESORDER) // QUOTE, PO or SO
                {
                        if ($print_invoice_no == 1)
-                               $this->Text($mcol + 180, $myrow['order_no']);
+                               $this->Text($mcol + 180, $this->formData['order_no']);
                        else    
-                               $this->Text($mcol + 180, $myrow['reference']);
+                               $this->Text($mcol + 180, $this->formData['reference']);
                }               
                elseif ($doctype == ST_WORKORDER)       
-                       $this->Text($mcol + 180, $myrow['id']);
-               else if (isset($myrow['trans_no']) && isset($myrow['reference'])) // INV/CRE/STA
+                       $this->Text($mcol + 180, $this->formData['id']);
+               else if (isset($this->formData['trans_no']) && isset($this->formData['reference'])) // INV/CRE/STA
                {
                        if ($print_invoice_no == 1)
-                               $this->Text($mcol + 180, $myrow['trans_no']);
+                               $this->Text($mcol + 180, $this->formData['trans_no']);
                        else
-                               $this->Text($mcol + 180, $myrow['reference']);
+                               $this->Text($mcol + 180, $this->formData['reference']);
                }
 
                if ($this->pageNumber > 1 && !strstr($this->filename, "Bulk"))
                $temp = $this->row;
                if ($doctype == ST_SALESQUOTE || $doctype == ST_SALESORDER)
                {
-                       $this->Text($ccol, $myrow['name'], $icol);
+                       $this->Text($ccol, $this->formData['name'], $icol);
                }
                elseif ($doctype == ST_WORKORDER)
                {
-                       $this->Text($ccol, $myrow['location_name'], $icol);
+                       $this->Text($ccol, $this->formData['location_name'], $icol);
                        $this->NewLine();
-                       $this->TextWrapLines($ccol, $icol - $ccol, $myrow['delivery_address']);
+                       $this->TextWrapLines($ccol, $icol - $ccol, $this->formData['delivery_address']);
                }
                else
                {
                        if ($doctype == ST_PURCHORDER || $doctype == ST_SUPPAYMENT) {
-                               $name = $myrow['supp_name'];
-                               $addr = $myrow['address'];
+                               $name = $this->formData['supp_name'];
+                               $addr = $this->formData['address'];
                        } else {
-                               if (trim($branch['br_address']) != '') {
-                                       $name = $branch['br_name'];
-                                       $addr = $branch['br_address'];
+                               if (isset($this->formData['br_address']) && 
+                                               trim($this->formData['br_address']) != '') {
+                                       $name = $this->formData['br_name'];
+                                       $addr = $this->formData['br_address'];
                                } else {
-                                       $name = $myrow['DebtorName'];
-                                       $addr = $myrow['address'];
+                                       $name = $this->formData['DebtorName'];
+                                       $addr = $this->formData['address'];
                                }
                        }
                        $this->Text($ccol, $name, $icol);
                        $this->NewLine();
                        $this->TextWrapLines($ccol, $icol - $ccol, $addr);
                }
-               if ($sales_order != NULL)
+               $this->row = $temp;
+               if (isset($this->formData['deliver_to']))
                {
-                       $this->row = $temp;
-                       if ($doctype != ST_SUPPAYMENT && isset($sales_order['deliver_to']))
+                       if ($doctype == ST_PURCHORDER)
+                               $this->Text($mcol, $this->company['coy_name']);
+                       elseif ($doctype != ST_SUPPAYMENT && isset($this->formData['deliver_to']))
                        {
-                               $this->Text($mcol, $sales_order['deliver_to']);
+                               $this->Text($mcol, $this->formData['deliver_to']);
                                $this->NewLine();
                        }       
-                       // if you need the company name in purchase order then write it as first line in location addresss.     
-                       if ($doctype != ST_SUPPAYMENT && isset($sales_order['delivery_address']))
-                               $this->TextWrapLines($mcol, $this->rightMargin - $mcol, $sales_order['delivery_address']);
-               }
+                       if ($doctype != ST_SUPPAYMENT && isset($this->formData['delivery_address']))
+                               $this->TextWrapLines($mcol, $this->rightMargin - $mcol, $this->formData['delivery_address']);
+               }       // if you need the company name in purchase order then write it as first line in location addresss.     
+               elseif ($doctype == ST_PURCHORDER && isset($this->formData['delivery_address']))
+                       $this->TextWrapLines($mcol, $this->rightMargin - $mcol, $this->formData['delivery_address']);
                $this->row = $iline2 - $this->lineHeight - 1;
                $col = $this->leftMargin;
                $this->TextWrap($col, $this->row, $width, $doc_Customers_Ref, 'C');
                $this->row = $iline3 - $this->lineHeight - 1;
                $col = $this->leftMargin;
                if ($doctype == ST_PURCHORDER || $doctype == ST_SUPPAYMENT)
-                       $this->TextWrap($col, $this->row, $width, $myrow['supp_account_no'], 'C');
+                       $this->TextWrap($col, $this->row, $width, $this->formData['supp_account_no'], 'C');
                elseif ($doctype == ST_WORKORDER)
-                       $this->TextWrap($col, $this->row, $width, $myrow['wo_ref'], 'C');
-               elseif (isset($sales_order["customer_ref"]))
-                       $this->TextWrap($col, $this->row, $width, $sales_order["customer_ref"], 'C');
-               elseif (isset($myrow["debtor_ref"]))
-                       $this->TextWrap($col, $this->row, $width, $myrow["debtor_ref"], 'C');
+                       $this->TextWrap($col, $this->row, $width, $this->formData['wo_ref'], 'C');
+               elseif (isset($this->formData["customer_ref"]))
+                       $this->TextWrap($col, $this->row, $width, $this->formData["customer_ref"], 'C');
+               elseif (isset($this->formData["debtor_ref"]))
+                       $this->TextWrap($col, $this->row, $width, $this->formData["debtor_ref"], 'C');
                $col += $width; 
-               if ($branch != null)
+               if (isset($this->formData['salesman']))
                {
-                       $id = $branch['salesman'];
-                       $sql = "SELECT salesman_name  FROM ".TB_PREF."salesman WHERE salesman_code='$id'";
-                       $result = db_query($sql,"could not get sales person");
-                       $row = db_fetch($result);
-                       $this->TextWrap($col, $this->row, $width, $row['salesman_name'], 'C');
+                       $id = $this->formData['salesman'];
+                       //$sql = "SELECT salesman_name  FROM ".TB_PREF."salesman WHERE salesman_code='$id'";
+                       //$result = db_query($sql,"could not get sales person");
+                       //$row = db_fetch($result);
+                       //$this->TextWrap($col, $this->row, $width, $row['salesman_name'], 'C');
+                       $this->TextWrap($col, $this->row, $width, get_salesman_name($id), 'C');
                }               
                elseif ($doctype == ST_SUPPAYMENT || $doctype == ST_CUSTPAYMENT)
-                       $this->TextWrap($col, $this->row, $width, $systypes_array[$myrow["type"]], 'C');
+                       $this->TextWrap($col, $this->row, $width, $systypes_array[$this->formData["type"]], 'C');
                elseif ($doctype == ST_WORKORDER)
-                       $this->TextWrap($col, $this->row, $width, $wo_types_array[$myrow["type"]], 'C');
+                       $this->TextWrap($col, $this->row, $width, $wo_types_array[$this->formData["type"]], 'C');
                $col += $width; 
                if ($doctype == ST_WORKORDER)
-                       $this->TextWrap($col, $this->row, $width, $myrow["StockItemName"], 'C');
-               elseif ($doctype != ST_PURCHORDER && isset($myrow['tax_id']))
-                       $this->TextWrap($col, $this->row, $width, $myrow['tax_id'], 'C');
+                       $this->TextWrap($col, $this->row, $width, $this->formData["StockItemName"], 'C');
+               elseif ($doctype != ST_PURCHORDER && isset($this->formData['tax_id']))
+                       $this->TextWrap($col, $this->row, $width, $this->formData['tax_id'], 'C');
                $col += $width; 
                if ($doctype == ST_SALESINVOICE)
                {
-                       $deliveries = get_parent_trans(ST_SALESINVOICE, $myrow['trans_no']);
-                       $line = "";
-                       foreach ($deliveries as $delivery)
+                       $deliveries = get_sales_parent_numbers(ST_SALESINVOICE, $this->formData['trans_no']);
+                       if ($print_invoice_no == 0)
                        {
-                               if ($print_invoice_no == 0)
-                               {
-                                       $ref = get_reference(ST_CUSTDELIVERY, $delivery);
-                                       if ($ref)
-                                               $delivery = $ref;
-                               }               
-                               if ($line == "")
-                                       $line .= "$delivery";
-                               else
-                                       $line .= ",$delivery";
-                       }               
-                       $this->TextWrap($col, $this->row, $width, $line, 'C');
+                               foreach($deliveries as $n => $delivery) {
+                                       $deliveries[$n] = get_reference(ST_CUSTDELIVERY, $delivery);
+                               }
+                       }
+                       $this->TextWrap($col, $this->row, $width, implode(',', $deliveries), 'C');
                }
                elseif ($doctype == ST_CUSTDELIVERY)
                {
-                       $ref = $myrow['order_'];
+                       $ref = $this->formData['order_'];
                        if ($print_invoice_no == 0)
                        {
-                               $ref = get_reference(ST_SALESORDER, $myrow['order_']);
+                               $ref = get_reference(ST_SALESORDER, $this->formData['order_']);
                                if (!$ref)
-                                       $ref = $myrow['order_'];
+                                       $ref = $this->formData['order_'];
                        }               
                        $this->TextWrap($col, $this->row, $width, $ref, 'C');
                }
                elseif ($doctype == ST_WORKORDER)
-                       $this->TextWrap($col, $this->row, $width, $myrow["location_name"], 'C');
-               elseif (isset($myrow['order_']) && $myrow['order_'] != 0)
-                       $this->TextWrap($col, $this->row, $width, $myrow['order_'], 'C');
+                       $this->TextWrap($col, $this->row, $width, $this->formData["location_name"], 'C');
+               elseif (isset($this->formData['order_']) && $this->formData['order_'] != 0)
+                       $this->TextWrap($col, $this->row, $width, $this->formData['order_'], 'C');
                $col += $width; 
                if ($doctype == ST_SALESORDER || $doctype == ST_SALESQUOTE)
-                       $this->TextWrap($col, $this->row, $width, sql2date($myrow['delivery_date']), 'C');
+                       $this->TextWrap($col, $this->row, $width, sql2date($this->formData['delivery_date']), 'C');
                elseif ($doctype == ST_WORKORDER)       
-                       $this->TextWrap($col, $this->row, $width, $myrow["units_issued"], 'C');
+                       $this->TextWrap($col, $this->row, $width, $this->formData["units_issued"], 'C');
                elseif ($doctype != ST_PURCHORDER && $doctype != ST_CUSTCREDIT && $doctype != ST_CUSTPAYMENT &&
-                       $doctype != ST_SUPPAYMENT && isset($myrow['due_date']))
-                       $this->TextWrap($col, $this->row, $width, sql2date($myrow['due_date']), 'C');
-               if (!isset($packing_slip) || $packing_slip == 0)
+                       $doctype != ST_SUPPAYMENT && isset($this->formData['due_date']))
+                       $this->TextWrap($col, $this->row, $width, sql2date($this->formData['due_date']), 'C');
+               if ((!isset($packing_slip) || $packing_slip == 0) && ($doctype != ST_STATEMENT)) //!
                {
                        $this->row -= (2 * $this->lineHeight);
                        if ($doctype == ST_WORKORDER)
-                               $str = sql2date($myrow["required_by"]);
+                               $str = sql2date($this->formData["required_by"]);
                        else
                        {
-                               $id = $myrow['payment_terms'];
-                               $sql = "SELECT terms FROM ".TB_PREF."payment_terms WHERE terms_indicator='$id'";
+                               $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);
                                $str = $row["terms"];
                $this->Font('italic');
                $this->row = $iline7 - $this->lineHeight - 6;
                if ($doctype != ST_WORKORDER)
-                       $this->TextWrap($ccol, $this->row, $right - $ccol, $doc_Please_Quote . " - " . $myrow['curr_code'], 'C');
+                       $this->TextWrap($ccol, $this->row, $right - $ccol, $doc_Please_Quote . " - " . $this->formData['curr_code'], 'C');
                $this->row -= $this->lineHeight;
 
-               if (isset($bankaccount['bank_name']))
+               if (isset($this->formData['bank_name']))
                {
-                       $txt = $doc_Bank . ": ".$bankaccount['bank_name']. ", " . $doc_Bank_Account . ": " . $bankaccount['bank_account_number'];
+                       $txt = $doc_Bank . ": ".$this->formData['bank_name']. ", " . $doc_Bank_Account . ": " . $this->formData['bank_account_number'];
                        $this->TextWrap($ccol, $this->row, $right - $ccol, $txt, 'C');
                        $this->row -= $this->lineHeight;
                }       
-               if ($doctype == ST_SALESINVOICE && $branch['disable_branch'] > 0) // payment links
+               if ($doctype == ST_SALESINVOICE && $this->formData['disable_branch'] > 0) // payment links
                {
-                       if ($branch['disable_branch'] == 1)
+                       if ($this->formData['disable_branch'] == 1)
                        {
-                               $amt = number_format($myrow["ov_freight"] + $myrow["ov_gst"] +  $myrow["ov_amount"], user_price_dec());
+                               $amt = number_format($this->formData["ov_freight"] + $this->formData["ov_gst"] +        $this->formData["ov_amount"], user_price_dec());
                                $txt = $doc_Payment_Link . " PayPal: ";
-                               $name = urlencode($this->title . " " . $myrow['reference']);
+                               $name = urlencode($this->title . " " . $this->formData['reference']);
                                $url = "https://www.paypal.com/xclick/business=" . $this->company['email'] . "&item_name=" .
-                                       $name . "&amount=" . $amt . "&currency_code=" . $myrow['curr_code'];
+                                       $name . "&amount=" . $amt . "&currency_code=" . $this->formData['curr_code'];
                                $this->fontSize -= 2;
                                $this->TextWrap($ccol, $this->row, $right - $ccol, $txt, 'C');
                                $this->row -= $this->lineHeight;