Changeset 914
- Timestamp:
- Sep 22, 2021, 10:34:30 PM (3 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 9 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/Version.php
r911 r914 1 1 <?php 2 2 3 $Revision = 91 1; // Subversion revision3 $Revision = 914; // Subversion revision 4 4 $DatabaseRevision = 911; // SQL structure revision 5 $ReleaseTime = strtotime('2021-0 7-31');5 $ReleaseTime = strtotime('2021-09-22'); -
trunk/Common/Form/Form.php
r897 r914 452 452 if (!$this->Database->TableExists($Class['Table'])) continue; 453 453 454 echo($Class['Table'].'<br >');454 echo($Class['Table'].'<br/>'); 455 455 $Module = 1; 456 456 $DbResult = $this->Database->select('Model', 'Id', 'Name="'.$Class['Table'].'"'); … … 503 503 } 504 504 } 505 echo('<br >');505 echo('<br/>'); 506 506 } 507 507 } -
trunk/Modules/Customer/Customer.php
r912 r914 249 249 $DbResult = $this->Database->select('Member', 'COUNT(*)', '1'); 250 250 $DbRow = $DbResult->fetch_row(); 251 $Output = 'Zákazníků: registrovaných: '.$DbRow['0'];252 253 $DbResult = $this->Database->select('Member', 'COUNT(*)', ' `Blocked`=0 AND `BillingPeriod`<>1');251 $Output = 'Zákazníků: registrovaných: <a href="'.$this->System->Link('/is/?a=list&t=Member').'">'.$DbRow['0'].'</a>'; 252 253 $DbResult = $this->Database->select('Member', 'COUNT(*)', '(`Blocked`=0) AND (`BillingPeriod`<>1)'); 254 254 $DbRow = $DbResult->fetch_row(); 255 $Output .= ' platících:'.$DbRow['0'].'<br/>'; 255 $Output .= ' aktivních: <a href="'.$this->System->Link('/is/?a=list&t=Member&filter=1&FilterBlocked=0&FilterBillingPeriod=Nikdy&FilterOpBillingPeriod=notequal').'">'.$DbRow['0'].'</a>'; 256 257 $DbResult = $this->Database->select('Member', 'COUNT(*)', '(`Blocked`=0) AND (`BillingPeriod`<>1) AND '. 258 '((SELECT SUM(Service.Price) FROM ServiceCustomerRel LEFT JOIN Service ON Service.Id=ServiceCustomerRel.Service WHERE ServiceCustomerRel.Customer=Member.Id) <> 0)'); 259 $DbRow = $DbResult->fetch_row(); 260 $Output .= ' platících: <a href="'.$this->System->Link('/is/?a=list&t=Member&filter=1&FilterBlocked=0&FilterBillingPeriod=Nikdy&FilterOpBillingPeriod=notequal').'">'.$DbRow['0'].'</a><br/>'; 256 261 257 262 return $Output; -
trunk/Modules/FinanceBankAPI/FinanceBankAPI.php
r901 r914 86 86 $DbResult = $this->Database->select('FinanceBankImport', 'COUNT(*)', '`FinanceOperation` IS NULL'); 87 87 $DbRow = $DbResult->fetch_row(); 88 $Output = 'Nezpárovaných plateb: '.$DbRow['0'].'<br/>';88 $Output = 'Nezpárovaných plateb: <a href="'.$this->System->Link('/is/?a=list&t=FinanceBankImport&filter=1&FilterFinanceOperation=1&FilterOpFinanceOperation=isnull').'">'.$DbRow['0'].'</a><br/>'; 89 89 return $Output; 90 90 } -
trunk/Modules/IS/IS.php
r912 r914 549 549 } 550 550 551 function GetParam(string $Name, string $Default): string 552 { 553 $Result = $Default; 554 if (array_key_exists($Name, $_POST) and ($_POST[$Name] != '')) 555 { 556 $Result = $_POST[$Name]; 557 } 558 if (array_key_exists($Name, $_GET) and ($_GET[$Name] != '')) 559 { 560 $Result = $_GET[$Name]; 561 } 562 return $Result; 563 } 564 551 565 function ShowTable(string $Table, string $Filter = '', string $Title = '', string $RowActions = '', string $ExcludeColumn = ''): string 552 566 { … … 604 618 $FilterName = $this->System->FormManager->Type->ExecuteTypeEvent($UseType, 'OnFilterName', 605 619 array('Name' => $ItemIndex, 'Type' => $FormItem['Type'])); 606 if (array_key_exists('Filter'.$ItemIndex, $_POST) and ($_POST['Filter'.$ItemIndex] != '')) 620 621 $SqlOperator = array( 622 'like' => 'LIKE', 623 'notlike' => 'NOT LIKE', 624 'equal' => '=', 625 'notequal' => '!=', 626 'less' => '<', 627 'lessorequal' => '<=', 628 'greater' => '>', 629 'greaterorequal' => '>=', 630 'isnull' => 'IS NULL', 631 'isnotnull' => 'IS NOT NULL', 632 ); 633 $Operator = $this->GetParam('FilterOp'.$ItemIndex, 'like'); 634 if (array_key_exists($Operator, $SqlOperator)) 635 { 636 $OperatorSql = $SqlOperator[$Operator]; 637 } else $OperatorSql = $SqlOperator['like']; 638 639 $FilterValue = $this->GetParam('Filter'.$ItemIndex, ''); 640 if ($FilterValue != '') 607 641 { 608 642 if ($UserFilter != '') $UserFilter .= ' AND '; 609 $UserFilter .= '('.$FilterName.' LIKE "%'.$_POST['Filter'.$ItemIndex].'%")'; 643 $UserFilter .= '('.$FilterName.' '.$OperatorSql; 644 if (($Operator == 'like') or ($Operator == 'notlike')) $UserFilter .= ' "%'.$FilterValue.'%")'; 645 else if (($Operator == 'isnull') or ($Operator == 'isnotnull')) $UserFilter .= ')'; 646 else $UserFilter .= ' "'.$FilterValue.'")'; 610 647 } 611 648 } 612 649 } 650 echo($UserFilter); 613 651 if ($UserFilter != '') 614 652 { -
trunk/Modules/Network/Network.php
r912 r914 829 829 $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '1'); 830 830 $DbRow = $DbResult->fetch_row(); 831 $Output .= 'Síťových zařízení: registrovaných: '.$DbRow['0'];831 $Output .= 'Síťových zařízení: registrovaných: <a href="'.$this->System->Link('/is/?a=list&t=NetworkDevice').'">'.$DbRow['0'].'</a>'; 832 832 833 833 $DbResult = $this->Database->select('NetworkDevice', 'COUNT(*)', '`Used`=1'); 834 834 $DbRow = $DbResult->fetch_row(); 835 $Output .= ' použitých: '.$DbRow['0'].'<br>';835 $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&t=NetworkDevice&filter=1&FilterUsed=1').'">'.$DbRow['0'].'</a><br/>'; 836 836 837 837 $DbResult = $this->Database->select('NetworkInterface', 'COUNT(*)', '1'); 838 838 $DbRow = $DbResult->fetch_row(); 839 $Output .= 'Síťových rozhraní: '.$DbRow['0'].'<br>'; 839 $Output .= 'Síťových rozhraní: registrovaných: <a href="'.$this->System->Link('/is/?a=list&t=NetworkDevice').'">'.$DbRow['0'].'</a>'; 840 841 $DbResult = $this->Database->select('NetworkInterface', 'COUNT(*)', '`Enabled`=1'); 842 $DbRow = $DbResult->fetch_row(); 843 $Output .= ' použitých: <a href="'.$this->System->Link('/is/?a=list&t=NetworkInterface&filter=1&FilterEnabled=1').'">'.$DbRow['0'].'</a><br/>'; 840 844 841 845 $DbResult = $this->Database->select('NetworkSubnet', 'COUNT(*)', '1'); 842 846 $DbRow = $DbResult->fetch_row(); 843 $Output .= 'Síťových podsítí: '.$DbRow['0'].'<br/>';847 $Output .= 'Síťových podsítí: <a href="'.$this->System->Link('/is/?a=list&t=NetworkSubnet').'">'.$DbRow['0'].'</a><br/>'; 844 848 return $Output; 845 849 } -
trunk/Modules/Subject/Subject.php
r901 r914 145 145 $DbResult = $this->Database->select('Subject', 'COUNT(*)', '1'); 146 146 $DbRow = $DbResult->fetch_row(); 147 $Output = 'Subjektů: '.$DbRow['0'].'<br/>';147 $Output = 'Subjektů: <a href="'.$this->System->Link('/is/?a=list&t=Subject').'">'.$DbRow['0'].'</a><br/>'; 148 148 return $Output; 149 149 } -
trunk/Modules/Task/Task.php
r899 r914 98 98 $DbResult = $this->Database->select('Task', 'COUNT(*)', '`Progress` < 100'); 99 99 $DbRow = $DbResult->fetch_row(); 100 $Output = 'Nedokončených úkolů: '.$DbRow['0'].'<br/>';100 $Output = 'Nedokončených úkolů: <a href="'.$this->System->Link('/is/?a=list&t=Task&filter=1&FilterProgress=100&FilterOpProgress=less').'">'.$DbRow['0'].'</a><br/>'; 101 101 return $Output; 102 102 } -
trunk/Modules/User/User.php
r900 r914 198 198 $DbResult = $this->Database->select('User', 'COUNT(*)', '1'); 199 199 $DbRow = $DbResult->fetch_row(); 200 $Output = 'Uživatelů: '.$DbRow['0'].'<br/>';200 $Output = 'Uživatelů: <a href="'.$this->System->Link('/is/?a=list&t=User&filter=1').'">'.$DbRow['0'].'</a><br/>'; 201 201 return $Output; 202 202 }
Note:
See TracChangeset
for help on using the changeset viewer.