<?php
/*
 *   This file is part of NOALYSS.
 *
 *   NOALYSS is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *   NOALYSS is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with NOALYSS; if not, write to the Free Software
 *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
/**
 * @file
 * @brief Objec to check a double insert into the database, this duplicate occurs after
 * a refresh of the web page
 */
// Copyright Author Dany De Bontridder danydb@aevalys.eu

define ('CODE_EXCP_DUPLICATE',901);
/**
 * @brief Objec to check a double insert into the database, this duplicate occurs after
 * a refresh of the web page
 */

class Single_Record
{
    public $name;
    public $id;
    private $dbconx; //!< database connexion
    /**
     *  @brief  Constructor $p_name will be set to $this->name, it is also the name
     * of the tag hidden in a form
     * @remark $cn Db connexion
     * @param $p_name (string) name of the HIDDEN INPUT 
     * @param $dbconx Database connx , if not given; use global $cn;
     */
    function __construct($p_name,$dbconx=-1)
    {
        $this->name=$p_name;
        $this->id=0;
        if ( is_numeric($dbconx )  ) {
            global $cn;
            $this->dbconx=$cn;
        }else {
            $this->dbconx=$dbconx;
        }
        
    }
    function __toString(): string {
        return "Single_Record[name=" . $this->name
                . ", id=" . $this->id
                . ", dbconx=" . $this->dbconx
                . "]";
    }
    /**
     * @brief return a string with a tag hidden and a uniq value
     * @param $hHidden is the name of the tag hidden
     * @return string : tag hidden
     */
    function hidden()
    {
        $this->id=$this->dbconx->get_next_seq('uos_pk_seq');
        return HtmlInput::hidden($this->name,$this->id);
    }
    /**
     * @brief Try to insert into the table Single_Record
     * @remark global $cn Database connexion
     * @throws Exception if the value $p_id is not unique
     */
    function save($p_array=null)
    {
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        $sql="insert into tool_uos(uos_value) values ($1)";
        try {
            $this->dbconx->exec_sql($sql,array($this->id));
        } catch (Exception $e)
        {
            throw new Exception('Duplicate value');
        }
    }
    /**
     * @brief Count how many time we have this->id into the table tool_uos
     * @remark global $cn Database connexion
     * @param $p_array is the array where to find the key name, usually it is
     * $_POST. The default value is $_POST
     * @return integer : 0 or 1
     */
    function get_count($p_array=null)
    {
        global $cn;
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        $count=$this->dbconx->get_value('select count(*) from tool_uos where uos_value=$1',
                array($this->id));
        return $count;
    }
    function check ($p_array=null)
    {
        global $cn;
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        try
        {
            $count=$this->dbconx->get_value('select count(*) from tool_uos where uos_value=$1',
                    array($this->id));
            if ($count != 0 ) throw new Exception ('DUPLICATE',CODE_EXCP_DUPLICATE);
        }catch (Exception $e)
        {
            throw $e;
        }
    }
}
?>