X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Frecurrent_invoices_db.inc;h=7d74dd20d8675bd915394e7511596129a04516ae;hb=df671df0181c7b578bb75e07e581c5e9878e2aaa;hp=a80aac071bfb1133af9ae63adce9b25623a28f4b;hpb=f4e4bc5a2ff9f97a20b3a62265926a4c677163f9;p=fa-stable.git

diff --git a/sales/includes/db/recurrent_invoices_db.inc b/sales/includes/db/recurrent_invoices_db.inc
index a80aac07..7d74dd20 100644
--- a/sales/includes/db/recurrent_invoices_db.inc
+++ b/sales/includes/db/recurrent_invoices_db.inc
@@ -108,13 +108,15 @@ function recurrent_invoice_ready($selected_id, $date)
 function recurrent_invoice_count($id)
 {
 
-	$sql1 = "SELECT branch.* FROM ".TB_PREF."recurrent_invoices rec
-		LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.group_no AND NOT branch.inactive
+	$sql1 = "SELECT branch.*
+		FROM ".TB_PREF."recurrent_invoices rec
+			LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.group_no AND NOT branch.inactive
 			LEFT JOIN ".TB_PREF."debtors_master debtor ON debtor.debtor_no = branch.debtor_no AND NOT debtor.inactive
 		WHERE rec.debtor_no=0 AND !ISNULL(debtor.debtor_no) AND rec.id=".db_escape($id);
 
-	$sql2 = "SELECT branch.* FROM ".TB_PREF."recurrent_invoices rec 
-		LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.branch_code AND NOT branch.inactive
+	$sql2 = "SELECT branch.*
+		FROM ".TB_PREF."recurrent_invoices rec 
+			LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.branch_code AND NOT branch.inactive
 			LEFT JOIN ".TB_PREF."debtors_master debtor ON rec.debtor_no = debtor.debtor_no AND NOT debtor.inactive
 		WHERE rec.debtor_no!=0 AND !ISNULL(debtor.debtor_no) AND rec.id=".db_escape($id);
 
@@ -129,13 +131,15 @@ function check_recurrent_invoice_prices($id)
 	$errors = 0;
 	$inv = get_recurrent_invoice($id);
 
-	$sql1 = "SELECT debtor.curr_code FROM ".TB_PREF."recurrent_invoices rec
-		LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.group_no AND NOT branch.inactive
+	$sql1 = "SELECT debtor.curr_code
+		FROM ".TB_PREF."recurrent_invoices rec
+			LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.group_no AND NOT branch.inactive
 			LEFT JOIN ".TB_PREF."debtors_master debtor ON debtor.debtor_no = branch.debtor_no AND NOT debtor.inactive
 		WHERE rec.debtor_no=0 AND !ISNULL(debtor.debtor_no) AND rec.id=".db_escape($id);
 
-	$sql2 = "SELECT debtor.curr_code FROM ".TB_PREF."recurrent_invoices rec 
-		LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.branch_code AND NOT branch.inactive
+	$sql2 = "SELECT debtor.curr_code
+		FROM ".TB_PREF."recurrent_invoices rec 
+			LEFT JOIN ".TB_PREF."cust_branch branch ON rec.group_no = branch.branch_code AND NOT branch.inactive
 			LEFT JOIN ".TB_PREF."debtors_master debtor ON rec.debtor_no = debtor.debtor_no AND NOT debtor.inactive
 		WHERE rec.debtor_no!=0 AND !ISNULL(debtor.debtor_no) AND rec.id=".db_escape($id);