Changeset 940

Timestamp:

Aug 2, 2022, 10:07:44 AM (2 years ago)

Author:

chronos

Message:

• Fixed: Generation of customer contracts.

File:

• trunk/Modules/Contract/Contract.php (modified) (3 diffs)

trunk/Modules/Contract/Contract.php

@@ -135 +135 @@
     } else die('MainSubjectId not found in Subjects.');
 
-    $DbResult = $this->Database->query('SELECT * FROM `Contract`');
+    $DbResult = $this->Database->query('SELECT * FROM `Contract` WHERE `Id`='.$this->ContractId);
     if ($DbResult->num_rows > 0)
     {
@@ -241 +241 @@
     } else $CustomerPhone = '';
 
-    $DbResult = $this->Database->query('SELECT Contact.Value AS Email FROM User '.
+    $DbResult = $this->Database->query('SELECT Email, Contact.Value AS ContactEmail FROM User '.
       'LEFT JOIN Contact ON Contact.User=User.ID AND Contact.Category=4 '.
       'WHERE User.Id='.$Customer['ResponsibleUser']);
@@ -248 +248 @@
       $CustomerUser = $DbResult->fetch_assoc();
       $CustomerEmail = $CustomerUser['Email'];
-      if ($CustomerEmail == null) $CustomerEmail = '';
+      if ($CustomerEmail == null) 
+      {
+        $CustomerEmail = $CustomerUser['ContactEmail'];
+        if ($CustomerEmail == null) $CustomerEmail = '';
+      }
     } else $CustomerEmail = '';