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

Timestamp:

Sep 22, 2021, 10:34:30 PM (3 years ago)

Author:

chronos

Message:

• Added: Made IS dashboard numbers as links with filters.

File:

• trunk/Modules/Customer/Customer.php (modified) (1 diff)

trunk/Modules/Customer/Customer.php

@@ -249 +249 @@
     $DbResult = $this->Database->select('Member', 'COUNT(*)', '1');
     $DbRow = $DbResult->fetch_row();
-    $Output = 'Zákazníků: registrovaných:'.$DbRow['0'];
-
-    $DbResult = $this->Database->select('Member', 'COUNT(*)', '`Blocked`=0 AND `BillingPeriod`<>1');
+    $Output = 'Zákazníků: registrovaných: <a href="'.$this->System->Link('/is/?a=list&amp;t=Member').'">'.$DbRow['0'].'</a>';
+
+    $DbResult = $this->Database->select('Member', 'COUNT(*)', '(`Blocked`=0) AND (`BillingPeriod`<>1)');
     $DbRow = $DbResult->fetch_row();
-    $Output .= ' platících:'.$DbRow['0'].'<br/>';
+    $Output .= ' aktivních: <a href="'.$this->System->Link('/is/?a=list&t=Member&amp;filter=1&amp;FilterBlocked=0&amp;FilterBillingPeriod=Nikdy&amp;FilterOpBillingPeriod=notequal').'">'.$DbRow['0'].'</a>';
+
+    $DbResult = $this->Database->select('Member', 'COUNT(*)', '(`Blocked`=0) AND (`BillingPeriod`<>1) AND '.
+      '((SELECT SUM(Service.Price) FROM ServiceCustomerRel LEFT JOIN Service ON Service.Id=ServiceCustomerRel.Service WHERE ServiceCustomerRel.Customer=Member.Id) <> 0)');
+    $DbRow = $DbResult->fetch_row();
+    $Output .= ' platících: <a href="'.$this->System->Link('/is/?a=list&t=Member&amp;filter=1&amp;FilterBlocked=0&amp;FilterBillingPeriod=Nikdy&amp;FilterOpBillingPeriod=notequal').'">'.$DbRow['0'].'</a><br/>';
 
     return $Output;