<?php

  class sml_data_licences extends mw_data{

    public function licences($start = null){
      $sgbd = $this->sgbd();
      $env = $this->env();
      $licences = array("list" => array(), "total" => 0);
      if($rst = $sgbd->open_data("sml_licences")){
        while($v_rst = $sgbd->fetch_data($rst)){
          if(isset($v_rst)){
            $licences["total"]++;
            if(!isset($start) || !$env->config("max_list") || ($licences["total"] > $start && $licences["total"] < ($start + $env->config("max_list")))){
              $licences["list"][$v_rst["id"]] = $v_rst;
            }
          }
          else{
            $licences = false;
            break;
          }
        }
        $sgbd->close_data($rst);
      }
      else $licences = false;
      return $licences;
    }

    public function licence($id){
      if($id == 0) return $id;
      $sgbd = $this->sgbd();
      return $sgbd->get_data("sml_licences", $id);
    }

    public function add_licence($nom, $url){
      $sgbd = $this->sgbd();
      return $sgbd->add_data(
        "sml_licences",
        array(
          "nom" => $nom,
          "url" => $url
        )
      );
    }

    public function set_licence($id, $nom, $url){
      if(($licence = $this->licence($id)) !== false){
        $sgbd = $this->sgbd();
        if($nom != $licence["nom"] || $url != $licence["url"]){
          $licence["nom"] = $nom;
          $licence["url"] = $url;
          if(!$this->maj_source_xml_licence($licence)) return false;
        }
        return $sgbd->set_data(
          "sml_licences",
          $id,
          array
          ( "nom" => $nom,
            "url" => $url
          )
        );
      }
      return false;
    }

    public function del_licence($id){
      $OK = true;
      $USED = false;
      $sgbd = $this->sgbd();
      $env = $this->env();
      if($rst = $sgbd->open_data("sml_sources")){
        while($source = $sgbd->fetch_data($rst)){
          if(isset($source)){
            if($source["licence"] == $id){
              $USED = true;
              break;
            }
          }
          else{
            $OK = false;
            break;
          }
        }
        $sgbd->close_data($rst);
      }
      else $OK = false;
      if($OK){
        if($USED) return 1;
        return $sgbd->del_data("sml_licences", $id) ? true : false;
      }
      return false;
    }

  }