X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Falter2.3.php;h=bafd38d71ddaaefc017ac4189abc1f4e253b5685;hb=8127089373814523c323e3e60cd48ea547c1c0f5;hp=338729246b9da887d7f6049f835aeed4cbc4183f;hpb=f2176954901fe9337bff19f2ff070f2f1d276e84;p=fa-stable.git

diff --git a/sql/alter2.3.php b/sql/alter2.3.php
index 33872924..bafd38d7 100644
--- a/sql/alter2.3.php
+++ b/sql/alter2.3.php
@@ -26,7 +26,34 @@ class fa2_3 {
 	//
 	function install($pref, $force) 
 	{
-		// remove old prefereces table after upgrade script has been executed
+		$sql = "SELECT debtor_no, payment_terms FROM {$pref}debtors_master";
+		
+		$result = db_query($sql);
+		if (!$result) {
+			display_error("Cannot read customers"
+			.':<br>'. db_error_msg($db));
+			return false;
+		}
+		// update all sales orders and transactions with customer std payment terms
+		while($cust = db_fetch($result)) {
+			$sql = "UPDATE {$pref}debtor_trans SET "
+				."payment_terms = '" .$cust['payment_terms']
+				."' WHERE debtor_no='".$cust['debtor_no']."'";
+			if (db_query($sql)==false) {
+				display_error("Cannot update cust trans payment"
+				.':<br>'. db_error_msg($db));
+				return false;
+			}
+			$sql = "UPDATE {$pref}sales_orders SET "
+				."payment_terms = '" .$cust['payment_terms']
+				."' WHERE debtor_no='".$cust['debtor_no']."'";
+			if (db_query($sql)==false) {
+				display_error("Cannot update sales order payment"
+				.':<br>'. db_error_msg($db));
+				return false;
+			}
+		}
+		// remove old preferences table after upgrade script has been executed
 		$sql = "DROP TABLE IF EXISTS `".$pref."company`";
 
 		return db_query($sql) && update_company_prefs(array('version_id'=>'2.3'));
@@ -42,16 +69,16 @@ class fa2_3 {
 	//	Test if patch was applied before.
 	//
 	function installed($pref) {
-		$n = 2; // number of patches to be installed
+		$n = 3; // number of patches to be installed
 		$patchcnt = 0;
 
 		if (!check_table($pref, 'comments', 'type', array('Key'=>'MUL'))) $patchcnt++;
 		if (!check_table($pref, 'sys_prefs')) $patchcnt++;
+		if (!check_table($pref, 'sales_orders', 'payment_terms')) $patchcnt++;
 
 		$n -= $patchcnt;
 		return $n == 0 ? true : $patchcnt;
 	}
-};
-
+	
 $install = new fa2_3;
 ?>
\ No newline at end of file