Changeset 1098

Timestamp:

10/06/08 11:05:03 (2 months ago)

Author:

Pernod

Message:

Added ability to filter videos that have no details available on the Edit Video and TV pages.

Files:

• trunk/swisscenter/base/db_abstract.php (modified) (3 diffs)
• trunk/swisscenter/config/config_movie.php (modified) (7 diffs)
• trunk/swisscenter/config/config_tv.php (modified) (8 diffs)

trunk/swisscenter/base/db_abstract.php

@@ -111 +111 @@
-
-    foreach ($movies as $movie_id)
-
+
+
+
+
+
+
-  }   
- 
@@ -219 +224 @@
-
-    foreach ($tv as $tv_id)
-
+
+
+
+
+
+
-  }   
-  
@@ -253 +263 @@
-  }
-  
+  // ----------------------------------------------------------------------------------------
+  // Determine whether any details other than title are available
+  // ----------------------------------------------------------------------------------------
+
+  function scdb_movie_details_available( $movie_id )
+  {
+    $attribs   = implode('',db_row("select year, certificate, synopsis from movies where file_id=$movie_id"));
+    $actors    = db_value("select count(actor_id) from actors_in_movie where movie_id=$movie_id");
+    $directors = db_value("select count(director_id) from directors_of_movie where movie_id=$movie_id");
+    $genres    = db_value("select count(genre_id) from genres_of_movie where movie_id=$movie_id");
+    if (empty($attribs) && $actors==0 && $directors==0 && $genres==0)
+      return false;
+    else
+      return true;
+  }
+  
+  function scdb_tv_details_available( $tv_id )
+  {
+    $attribs   = implode(db_row('',"select year, certificate, synopsis from tv where file_id=$tv_id"));
+    $actors    = db_value("select count(actor_id) from actors_in_tv where tv_id=$tv_id");
+    $directors = db_value("select count(director_id) from directors_of_tv where tv_id=$tv_id");
+    $genres    = db_value("select count(genre_id) from genres_of_tv where tv_id=$tv_id");
+    if (empty($attribs) && $actors==0 && $directors==0 && $genres==0)
+      return false;
+    else
+      return true;
+  }
+  
-/**************************************************************************************************
-                                               End of file

trunk/swisscenter/config/config_movie.php

@@ -175 +175 @@
-
-    echo '<table class="form_select_tab" width="100%"><tr>
-
+'.($movie["DETAILS_AVAILABLE"]=='Y' ? '' : ' bgcolor="red"').'
-          <td valign="top" width="33%">
-$movie["TITLE"]
+highlight($movie["TITLE"], $_REQUEST["search"])
-             Certificate : '.nvl($cert).'<br>
-             Year : '.nvl($movie["YEAR"]).'<br>
@@ -210 +210 @@
-    $img_url     = img_gen(file_albumart($filename) ,130,400,false,false,false,array('hspace'=>0,'vspace'=>4) );
-    $edit_url    = '?section=movie&action=display_info&movie_id='.$movie["FILE_ID"];
-
+'.($movie["DETAILS_AVAILABLE"]=='Y' ? '' : ' bgcolor="red"').'
-                    <td valign="middle"><a href="'.$edit_url.'">'.$img_url.'</a></td>';
-$movie["TITLE"]
+highlight($movie["TITLE"], $_REQUEST["search"])
-  }
-
@@ -245 +245 @@
-    $where .= "and m.title like '%$_REQUEST[search]%' ";
-
+  if (!empty($_REQUEST["filter"]) )
+    $where .= "and (m.details_available='N' or m.details_available is null)";
+
-  // If the user has changed category, then shunt them back to page 1.
-  if (un_magic_quote($_REQUEST["last_where"]) != $where)
@@ -261 +264 @@
-  message($message);
-
-
+filter='.$_REQUEST["filter"].'&
-
-  echo '<form enctype="multipart/form-data" action="" method="post">
@@ -274 +277 @@
-        <img align="absbottom" border="0" src="/images/select_all.gif" onclick=\'handleClick("movie[]", true)\'>
-        <img align="absbottom" border="0" src="/images/select_none.gif" onclick=\'handleClick("movie[]", false)\'>
+        <a href="'.url_remove_param($this_url,'filter').'"><img align="absbottom" border="0"  src="/images/filter.gif"></a>
+        <a href="'.url_set_param($this_url,'filter','NODETAILS').'"><img align="absbottom" border="0" src="/images/filter_red.gif"></a>
-        </td><td width"50%" align="right">
-        '.str('SEARCH').' :
@@ -531 +536 @@
-    $columns["TITLE"] = $_REQUEST["title"];
-
-  // Update the MOVIES table?
-  if (count($columns)>0)
-  {
-    $columns["DETAILS_AVAILABLE"] = 'Y';
-    scdb_set_movie_attribs($movie_list, $columns);
-  }
-
-  // Add Actors/Genres/Directors?
-  if ($_REQUEST["update_actors"] == 'yes')
@@ -560 +558 @@
-      scdb_add_genres($movie_list,un_magic_quote($_REQUEST["genres"]));
-    if (!empty($_REQUEST["genre_new"]))
-
-
-
+
+
+
+
+
+
-  // Process the "Viewed" checkboxes
-  if ($_REQUEST["update_viewed"] == 'yes')

trunk/swisscenter/config/config_tv.php

@@ -170 +170 @@
-
-    echo '<table class="form_select_tab" width="100%"><tr>
-
+'.($tv["DETAILS_AVAILABLE"]=='Y' ? '' : ' bgcolor="red"').'
-          <td valign="top" width="33%">
-$tv["PROGRAMME"].' - '.$tv["TITLE"]
+highlight($tv["PROGRAMME"], $_REQUEST["search"]).' - '.highlight($tv["TITLE"], $_REQUEST["search"])
-             Series : '.nvl($tv["SERIES"]).'<br>
-             Episode : '.nvl($tv["EPISODE"]).'<br>
@@ -202 +202 @@
-    $img_url     = img_gen(file_albumart($tv["DIRNAME"].$tv["FILENAME"]) ,130,400,false,false,false,array('hspace'=>0,'vspace'=>4) );
-    $edit_url    = '?section=tv&action=display_info&tv_id='.$tv["FILE_ID"];
-
+'.($tv["DETAILS_AVAILABLE"]=='Y' ? '' : ' bgcolor="red"').'
-                    <td valign="middle"><a href="'.$edit_url.'">'.$img_url.'</a></td>';
-$tv["PROGRAMME"].' - '.$tv["TITLE"]
+highlight($tv["PROGRAMME"], $_REQUEST["search"]).' - '.highlight($tv["TITLE"], $_REQUEST["search"])
-  }
-
@@ -237 +237 @@
-    $where .= "and (t.programme like '%$_REQUEST[search]%' or t.title like '%$_REQUEST[search]%') ";
-
+  if (!empty($_REQUEST["filter"]) )
+    $where .= "and (t.details_available='N' or t.details_available is null)";
+
-  // If the user has changed category, then shunt them back to page 1.
-  if (un_magic_quote($_REQUEST["last_where"]) != $where)
@@ -253 +256 @@
-  message($message);
-
-
+filter='.$_REQUEST["filter"].'&
-
-  echo '<form enctype="multipart/form-data" action="" method="post">
@@ -266 +269 @@
-        <img align="absbottom" border="0" src="/images/select_all.gif" onclick=\'handleClick("tv[]", true)\'>
-        <img align="absbottom" border="0" src="/images/select_none.gif" onclick=\'handleClick("tv[]", false)\'>
+        <a href="'.url_remove_param($this_url,'filter').'"><img align="absbottom" border="0"  src="/images/filter.gif"></a>
+        <a href="'.url_set_param($this_url,'filter','NODETAILS').'"><img align="absbottom" border="0" src="/images/filter_red.gif"></a>
-        </td><td width"50%" align="right">
-        '.str('SEARCH').' :
@@ -420 +425 @@
-  foreach ( db_toarray("select * from users order by name") as $row)
-    echo '<input type="checkbox" name="viewed[]" value="'.$row["USER_ID"].'" '.
-6
+MEDIA_TYPE_TV
-         '>'.$row["NAME"].'<br>';
-
@@ -550 +555 @@
-    $columns["EPISODE"] = $_REQUEST["episode"];
-
-  // Update the TV table?
-  if (count($columns)>0)
-  {
-    $columns["DETAILS_AVAILABLE"] = 'Y';
-    scdb_set_tv_attribs($tv_list, $columns);
-  }
-
-  // Add Actors/Genres/Directors?
-  if ($_REQUEST["update_actors"] == 'yes')
@@ -582 +580 @@
-  }
-
+  // Update the TV attributes
+  scdb_set_tv_attribs($tv_list, $columns);
+  
-  // Process the "Viewed" checkboxes
-  if ($_REQUEST["update_viewed"] == 'yes')