X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep205.php;h=4b27c182c697804ba060d71be0d8473f254d3c5c;hb=a9e7141956ef0a60b58e9a627beee93cd35ed43c;hp=f6da337f05d83671e928acec5f14312742a1e55f;hpb=1571869d54be48452fdbe08f25130972ff0a7b5a;p=fa-stable.git diff --git a/reporting/rep205.php b/reporting/rep205.php index f6da337f..4b27c182 100644 --- a/reporting/rep205.php +++ b/reporting/rep205.php @@ -30,20 +30,11 @@ print_supplier_details_listing(); function get_supplier_details_for_report() { - $sql = "SELECT ".TB_PREF."suppliers.supplier_id, - ".TB_PREF."suppliers.supp_name, - ".TB_PREF."suppliers.address, - ".TB_PREF."suppliers.supp_address, - ".TB_PREF."suppliers.supp_ref, - ".TB_PREF."suppliers.contact, - ".TB_PREF."suppliers.curr_code, - ".TB_PREF."suppliers.dimension_id, - ".TB_PREF."suppliers.dimension2_id, - ".TB_PREF."suppliers.notes, - ".TB_PREF."suppliers.gst_no - FROM ".TB_PREF."suppliers - WHERE inactive = 0 - ORDER BY supp_name"; + $sql = "SELECT supplier_id, supp_name, address, supp_address, supp_ref, + contact, curr_code, dimension_id, dimension2_id, notes, gst_no + FROM ".TB_PREF."suppliers + WHERE inactive = 0 + ORDER BY supp_name"; return db_query($sql,"No transactions were returned"); } @@ -133,7 +124,7 @@ function print_supplier_details_listing() { $newrow = 0; $rep->NewLine(); - // Here starts the new report lines 2013-01-28 Joe Hunt + // Here starts the new report lines $contacts = get_supplier_contacts($myrow['supplier_id']); $rep->TextCol(0, 1, $myrow['supp_name']); $rep->TextCol(1, 2, _('Tax_Id') . ": " . $myrow['gst_no']); @@ -176,7 +167,7 @@ function print_supplier_details_listing() { $oldrow = $rep->row; $rep->NewLine(); - $rep->TextColLines(1, 2, _("Gereral Notes:")." ".$myrow['notes'], -2); + $rep->TextColLines(1, 2, _("General Notes:")." ".$myrow['notes'], -2); $newrow = $rep->row; $rep->row = $oldrow; } @@ -206,4 +197,3 @@ function print_supplier_details_listing() $rep->End(); } -?> \ No newline at end of file