Anonymous

<?php
$rowlimit=50;
//Ok first did we get any variables? 
if ($_GET['type'] || $_GET['status']) {
   //Alright we're filtering by a type and/or status
   $sql = "SELECT node.nid as nid, node.title as title, 
      i18n_node.language as language, CASE i18n_node.status
      WHEN  4 THEN 'Source Updated'
      WHEN 3 THEN 'Translated Content'
      WHEN 2 THEN 'Translation in Progress'
      WHEN 1 THEN 'Source content'
      WHEN 0 THEN 'None'
      END  as status
      FROM i18n_node 
      JOIN node on i18n_node.nid = node.nid ";
    //Now lets figure out what we're filtering by 
    if ($_GET['type'] && ($_GET['status'] != null)) {
       //both 
        $sql .= "WHERE node.type = '". mysql_escape_string($_GET['type'])."'
                 AND i18n_node.status = '". mysql_escape_string($_GET['status'])."'";

    } elseif ($_GET['type']) {
        $sql .= "WHERE node.type = '". mysql_escape_string($_GET['type'])."'";
    } elseif ($_GET['status']) {
        $sql .= "WHERE i18n_node.status = '". mysql_escape_string($_GET['status'])."'";
    }

   

   $header = array(
       array('data' => t("nid"), field=> 'node.title'),
       array('data' => t("Title"), field=> 'node.title', 'sort' => asc),
       array('data' => t("Language"), field=> 'language'),
       array('data' => t("Status"), field=> 'status'),
   );
   $rows = array();
   $tablesort = tablesort_sql($header);
   $result = pager_query($sql . $tablesort, $rowlimit); 
   while ($row = mysql_fetch_array($result)) {
        $rows[] = array(
             $row['nid'],
             "<a href=\"/node/". $row['nid']. "\">".
             $row['title']."</a>",

             $row['language'],
             $row['status']
         );
   }
   print "<a href=\"?\">Back to overview<br></a>";
}else {
   //Show it all 

$sql = " 
SELECT node.type as type, count(node.type) as number, 

(SELECT count(i18n.language) 
FROM i18n_node as i18n 
JOIN node as nd on i18n.nid = nd.nid
WHERE nd.type = node.type
AND i18n.status = 4
) as SourceUpdated,

(SELECT count(i18n.language) 
FROM i18n_node as i18n 
JOIN node as nd on i18n.nid = nd.nid
WHERE nd.type = node.type
AND i18n.status = 3
) as Translated_Content,

(SELECT count(i18n.language) 
FROM i18n_node as i18n 
JOIN node as nd on i18n.nid = nd.nid
WHERE nd.type = node.type
AND i18n.status = 2
) as Translation_in_progress,

(SELECT count(i18n.language) 
FROM i18n_node as i18n 
JOIN node as nd on i18n.nid = nd.nid
WHERE nd.type = node.type
AND i18n.status = 1
) as Source_Content,

(SELECT count(i18n.language) 
FROM i18n_node as i18n 
JOIN node as nd on i18n.nid = nd.nid
WHERE nd.type = node.type
AND i18n.status = 0
) as None

FROM i18n_node
JOIN node on i18n_node.nid = node.nid
GROUP BY node.type
";

//lets throw the data into a table
$header=array(
       array('data' => t("Type"), field=> 'node.type', 'sort' => asc),
       array('data' => t("# of Nodes"), field=> 'number'),
       array('data' => t("Source Updated"), field=> 'SourceUpdated'),
       array('data' => t("Translated Content"), field=> 'Translated_Content'),
       array('data' => t("Translation in Progress"), field=> 'Translation_in_progress'),
       array('data' => t("Source Content"), field=> 'Source_Content'),
       array('data' => t("None"), field=> 'None')
       );

$tablesort = tablesort_sql($header);
$result = pager_query($sql . $tablesort, $rowlimit); 
$rows = array();

while ($row = mysql_fetch_array($result)) {
    $rows[] = array(
       "<a href=\"?type="
.$row['type']."\">".$row['type']."</a>",
       "<a href=\"?type="
.$row['type']."\">".$row['number']."</a>",
       "<a href=\"?status=4&type="
.$row['type']."\">".$row['SourceUpdated']."</a>",
       "<a href=\"?status=3&type="
.$row['type']."\">".$row['Translated_Content']."</a>",
       "<a href=\"?status=2&type="
.$row['type']."\">".$row['Translation_in_progress']."</a>",
       "<a href=\"?status=1&type="
.$row['type']."\">".$row['Source_Content']."</a>",
       "<a href=\"?status=0&type="
.$row['type']."\">".$row['None']."</a>",
    );  
}



}
$output .= theme('table', $header, $rows);
$output .= theme('pager', NULL, $limit, 0);
//$table = theme_table($header,$rows);
print $output;

?>