sql_impdol Class Reference

Inheritance diagram for sql_impdol:

Collaboration diagram for sql_impdol:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	getp ($p_string)
	setp ($p_string, $p_value)
	insert ()
	delete ()
	update ()
	load ()
	get_info ()
	verify ()
	from_array ($p_array)
	next ($ret, $i)

Detailed Description

Definition at line 20 of file class_sql_impdol.php.

Constructor & Destructor Documentation

sql_impdol::__construct	(		$p_cn,
			$p_id = -1
	)

Definition at line 23 of file class_sql_impdol.php.

References $key, load(), and name.

    {
        $this->cn = $p_cn;
        $pk=$this->primary_key;
        $this->$pk= $p_id;

        if ($p_id == -1)
        {
            /* Initialize an empty object */
            foreach ($this->name as $key )
            {
                $this->$key= null;
            }
            $this->$pk= $p_id;
        }
        else
        {
            /* load it */
            $this->load();
        }
    }

Member Function Documentation

sql_impdol::delete

(

)

Definition at line 99 of file class_sql_impdol.php.

References $sql, and table.

    {
        $pk=$this->primary_key;
        $sql = " delete from " . $this->table . " where " . $this->primary_key . "=" . sql_string($this->$pk);
        $this->cn->exec_sql($sql);
    }

sql_impdol::from_array

(

$p_array

)

Definition at line 180 of file class_sql_impdol.php.

References $key, and name.

Referenced by next().

    {
        foreach ($this->name as $key=>$value)
        {
            if ( isset ($p_array[$value]))
            {
                $this->$value=$p_array[$value];
            }
        }
    }

sql_impdol::get_info

(

)

Definition at line 168 of file class_sql_impdol.php.

    {
        return var_export($this, true);
    }

sql_impdol::getp

(

$p_string

)

Definition at line 45 of file class_sql_impdol.php.

References name.

    {
        if (array_key_exists( $p_string,$this->name))
        {
            $idx = $this->name[$p_string];
            return $this->$idx;
        }
        else
            throw new Exception(__FILE__ . ":" . __LINE__ . $p_string . 'Erreur attribut inexistant '.$p_string);
    }

sql_impdol::insert

(

)

Definition at line 67 of file class_sql_impdol.php.

References $array, $key, $sql, name, table, and verify().

    {
        $this->verify();
        $sql = "insert into " . $this->table . " ( ";
        $sep = "";
        $par = "";
        $idx = 1;
        $array = array();
        foreach ($this->name as $key=>$value)
        {
            if (isset($this->default[$value]) && $this->default[$value] == "auto" && $this->$value ==null )
                continue;
            if ( $value==$this->primary_key && $this->$value == -1 ) continue;
            $sql.=$sep.$value;
            switch ($this->type[$value])
            {
                case "date":
                    $par .=$sep. 'to_date($' . $idx . ",'" . $this->date_format . "')" ;
                    break;
                default:
                    $par .= $sep."$" . $idx ;
            }

            $array[] = $this->$value;
            $sep = ",";
            $idx++;
        }
        $sql.=") values (" . $par . ") returning " . $this->primary_key;
        $pk=$this->primary_key;
        $this->$pk = $this->cn->get_value($sql, $array);
    }

sql_impdol::load

(

)

Definition at line 136 of file class_sql_impdol.php.

References $key, $sql, and name.

Referenced by __construct().

    {
        $sql = " select ";
        $sep="";$par="";

        foreach ($this->name as $key)
        {

            switch ($this->type[$key])
            {
                case "date":
                    $sql .= $sep.'to_char(' . $key . ",'" . $this->date_format . "') as ".$key ;
                    break;
                default:
                    $sql.=$sep.$key ;
            }
            $sep = ",";
        }
        $pk=$this->primary_key;
        $sql.=" from ".$this->table;
        $sql.=" where " . $this->primary_key . " = " . $this->$pk;
        $result = $this->cn->get_array($sql);
        if ($this->cn->count() == 0 ) {
            $this->$pk=-1;
            return;
        }

        foreach ($result[0] as $key=>$value) {
            $this->$key=$value;
        }
    }

sql_impdol::next	(		$ret,
			$i
	)

Definition at line 190 of file class_sql_impdol.php.

References $array, $cn, $ret, and from_array().

                                  {
        global $cn;
        $array=$this->cn->fetch_array($ret,$i);
        $this->from_array($array);
    }

sql_impdol::setp	(		$p_string,
			$p_value
	)

Definition at line 56 of file class_sql_impdol.php.

References name.

    {
        if (array_key_exists( $p_string,$this->name))
        {
            $idx = $this->name[$p_string];
            $this->$idx = $p_value;
        }
        else
            throw new Exception(__FILE__ . ":" . __LINE__ . $p_string . 'Erreur attribut inexistant '.$p_string);
    }

sql_impdol::update

(

)

Definition at line 106 of file class_sql_impdol.php.

References $array, $key, $sql, name, table, and verify().

    {
        $this->verify();
        $pk=$this->primary_key;
        $sql = "update " . $this->table . "  ";
        $sep = "";
        $idx = 1;
        $array = array();
        $set=" set ";
        foreach ($this->name as $key=>$value)
        {
            if (isset($this->default[$value]) && $this->default[$value] == "auto"  )
                continue;
            switch ($this->type[$value])
            {
                case "date":
                    $par =$value. '=to_date($' . $idx . ",'" . $this->date_format . "')" ;
                    break;
                default:
                    $par = $value."= $" . $idx ;
            }
            $sql.=$sep." $set " . $par ;
            $array[] = $this->$value;
            $sep = ",";$set="";$idx++;
        }
        $sql.=" where " . $this->primary_key . " =" . $this->$pk;
        $this->cn->exec_sql($sql, $array);

    }

sql_impdol::verify

(

)

Definition at line 173 of file class_sql_impdol.php.

References $key, and name.

Referenced by insert(), and update().

    {
        foreach($this->name as $key){
            if ( trim($this->$key)=='') $this->$key=null;
        }
        return 0;
    }

---

The documentation for this class was generated from the following file:

• import_doli/include/class_sql_impdol.php