<?php
 
include_once('include/common.inc.php');
include_header('Website Licensing');
 
echo "<table>
    <tr><th>name</th><th>licencing terms</th></tr>";
$agenciesdb = $server->get_db('disclosr-agencies');
try {
    $rows = $agenciesdb->get_view("app", "all", null, true)->rows;
 
 
    if ($rows) {
        
        foreach ($rows as $row) {
             $rowArray = object_to_array($row->value);
             if (isset($rowArray['name'])&& isset($rowArray['website']) && !isset($rowArray['status'])) {
 echo "<tr><td><a href='" . $rowArray['website'] ."'>". $rowArray['name'] . "</a></td>";
           
           
            
            $licences = Array(
                "hasCrownCopyright"=>"Crown Copyright",
                "hasCCBY"=>"Creative Commons Attribution",
                "hasCCBYND" =>"Creative Commons No Derivatives",        
"hasCCBYNCND" =>"Creative Commons No Derivatives Non-Commercial",       
                "hasRestrictiveLicense" => "ERRRRRRRRRRRRRRRRRRR",
"hasRestrictiveLicence" => "Bespoke restrictive (permission for reuse) licences",
"hasRestricitiveLicence"=>"ERRRRRRRRRRRR");
            $websiteLicences = Array();
            foreach ($rowArray as $fieldName => $rowField) {
                foreach($licences as $licenceID => $licenceName) {
                if (strstr($fieldName,$licenceID)) {
                    $websiteLicences[$licenceName] = $rowField[0];
                }
                }
            }
            echo "<td>";
            foreach ($websiteLicences as $name => $url) {
                echo '<A href="' .$url.'">'.$name.'</a><br>';
            }
        
        echo "</td></tr>";
             }
        }
    }
 
} catch (SetteeRestClientException $e) {
    setteErrorHandler($e);
}
include_footer();
?>