Changeset 446 for trunk/tv

Timestamp:

Oct 15, 2012, 9:32:09 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Tabulky Správy dat pro TV kanály.
• Upraveno: Systém tabulek produktů a skladových položek.

File:

• trunk/tv/index.php (modified) (2 diffs)

trunk/tv/index.php

@@ -19 +19 @@
 
     $Where = 
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `TV` WHERE (`Stream` <> "") OR (`StreamWeb` <> "")');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM `TV` LEFT JOIN `TVGroup` ON `TVGroup`.`Id` = `TV`.`Category` '.
+      ' LEFT JOIN `Language` ON `Language`.`Id` = `TV`.`Language` WHERE (`TV`.`Stream` <> "") OR (`TV`.`StreamWeb` <> "")');
     $DbRow = $DbResult->fetch_row();
     $PageList = GetPageList($DbRow[0]);    
@@ -36 +37 @@
     $Output .= $Order['Output'];
 
-    $Query = 'SELECT * FROM `TV` WHERE (`Stream` <> "") OR (`StreamWeb` <> "") '.$Order['SQL'].$PageList['SQLLimit'];
+    $Query = 'SELECT `TV`.*, `TVGroup`.`Name` AS `Category`, `Language`.`Name` AS `Language` FROM `TV` LEFT JOIN `TVGroup` ON `TVGroup`.`Id` = `TV`.`Category` '.
+      ' LEFT JOIN `Language` ON `Language`.`Id` = `TV`.`Language` WHERE (`TV`.`Stream` <> "") OR (`TV`.`StreamWeb` <> "") '.$Order['SQL'].$PageList['SQLLimit'];
 
     $DbResult = $this->Database->query($Query);