Changeset 901 for trunk/Modules/Customer/Customer.php

Timestamp:

Feb 17, 2021, 9:27:32 PM (3 years ago)

Author:

chronos

Message:

• Added: Documents section accessible from users panel.
• Added: Contract model moved to separate module Contract.
• Added: New action to generate PDF from Contract.
• Fixed: Allow users to download files only by hash instead of direct id.
• Added: Support for SHA1 as allowed mysql function.

File:

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

trunk/Modules/Customer/Customer.php

@@ -37 +37 @@
         'SupportActivity' => array('Type' => 'TSupportActivityListCustomer', 'Caption' => 'Zákaznická podpora', 'Default' => ''),
         'Consumption' => array('Type' => 'TCustomerStockSerialNumber', 'Caption' => 'Spotřeba zařízení', 'Default' => ''),
+        'Contract' => array('Type' => 'TContract', 'Caption' => 'Smlouva', 'Default' => '', 'Null' => true),
         'ChangeAction' => array('Type' => 'TActionEnum', 'Caption' => 'Změna - akce', 'Default' => '', 'Null' => true),
         'ChangeTime' => array('Type' => 'DateTime', 'Caption' => 'Změna - čas', 'Default' => '', 'Null' => true, 'NotInList' => true),
@@ -196 +197 @@
       ),
     ));
+    $this->System->FormManager->RegisterFormType('TCustomerListContract', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'Member',
+      'Id' => 'Id',
+      'Ref' => 'Contract',
+      'Filter' => '1',
+    ));
+
+    $this->System->RegisterPage(['user', 'dokumenty'], 'PageCustomerDocuments');
 
     ModuleIS::Cast(Core::Cast($this->System)->GetModule('IS'))->RegisterDashboardItem('Customer',
@@ -211 +221 @@
     $Output .= ' platících:'.$DbRow['0'].'<br/>';
 
+    return $Output;
+  }
+}
+
+class PageCustomerDocuments extends Page
+{
+  function __construct(System $System)
+  {
+    parent::__construct($System);
+    $this->FullTitle = 'Dokumenty klienta';
+    $this->ShortTitle = 'Dokumenty';
+    $this->ParentClass = 'PageUser';
+  }
+
+  function Show(): string
+  {
+    $Output = '<br/><div><strong>Dostupné dokumenty:</strong></div><br/>';
+
+    $User = &ModuleUser::Cast($this->System->GetModule('User'))->User;
+
+    // Determine which customer should be displayed
+    if (array_key_exists('i', $_GET))
+    {
+      if (!$User->CheckPermission('Finance', 'Manage')) return 'Nemáte oprávnění';
+      $CustomerId = $_GET['i'];
+    } else
+    {
+      if (!$User->CheckPermission('Customer', 'DisplayCustomerDocuments')) return 'Nemáte oprávnění';
+      $UserId = ModuleUser::Cast($this->System->GetModule('User'))->User->User['Id'];
+      $DbResult = $this->Database->query('SELECT `Customer` FROM `UserCustomerRel` WHERE `User`='.$UserId.' LIMIT 1');
+      if ($DbResult->num_rows > 0)
+      {
+        $CustomerUserRel = $DbResult->fetch_assoc();
+        $CustomerId = $CustomerUserRel['Customer'];
+      } else return $this->SystemMessage('Chyba', 'Nejste zákazníkem');
+    }
+
+    // Load customer info
+    $DbResult = $this->Database->query('SELECT * FROM `Member` WHERE `Id`='.$CustomerId);
+    if ($DbResult->num_rows == 1)
+    {
+      $Customer = $DbResult->fetch_assoc();
+    } else return $this->SystemMessage('Položka nenalezena', 'Zákazník nenalezen');
+
+    if ($Customer['Contract'] != '')
+    {
+      $DbResult = $this->Database->query('SELECT Contract.*, File.Hash AS FileHash, DocumentLineCode.Name AS BillCodeText FROM Contract '.
+        'LEFT JOIN File ON File.Id=Contract.File '.
+        'LEFT JOIN DocumentLineCode ON DocumentLineCode.Id=Contract.BillCode '.
+        'WHERE (Contract.Id='.$Customer['Contract'].')');
+      if ($DbResult->num_rows > 0)
+      {
+        $Contract = $DbResult->fetch_assoc();
+        if ($Contract['File'] > 0) $Output .= 'Smlouva: <a href="'.$this->System->Link('/file?h='.$Contract['FileHash']).'">'.$Contract['BillCodeText'].'</a><br/>';
+          else $Output .= 'Smlouva: '.$Contract['BillCodeText'].'<br/>';
+        $Output .= 'Všeobecné smluvní podmínky: <a href="http://www.zdechov.net/docs/V%C5%A1eobecn%C3%A9%20smluvn%C3%AD%20podm%C3%ADnky.pdf">PDF</a><br/>';
+      }
+    }
     return $Output;
   }