impdol_operation_transfer_sql Class Reference

Inheritance diagram for impdol_operation_transfer_sql:

Collaboration diagram for impdol_operation_transfer_sql:

Public Member Functions
	__construct ($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 355 of file class_sql_impdol.php.

Constructor & Destructor Documentation

impdol_operation_transfer_sql::__construct

(

$p_id = -1

)

Definition at line 357 of file class_sql_impdol.php.

References $cn, name, and table.

    {
        $this->table = "impdol.operation_transfer";
        $this->primary_key = "ot_id";

        $this->name=array(
            "id"=>"ot_id",
            "j_id"=>"j_id",
            "o_id"=>"o_id"
        );

        $this->type = array(
            "ot_id"=>'numeric',
            "j_id"=>'numeric',
            "o_id"=>'numeric',
            );

        $this->default = array(
            "i_id" => "auto"
        );
        $this->date_format = "DD.MM.YYYY";
        global $cn;

        parent::__construct($cn,$p_id);
    }

Member Function Documentation

sql_impdol::delete ( )

inherited

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 )

inherited

Definition at line 180 of file class_sql_impdol.php.

References $key, and name.

Referenced by sql_impdol\next().

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

sql_impdol::get_info ( )

inherited

Definition at line 168 of file class_sql_impdol.php.

    {
        return var_export($this, true);
    }

sql_impdol::getp (   $p_string )

inherited

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 ( )

inherited

Definition at line 67 of file class_sql_impdol.php.

References $array, $key, $sql, name, table, and sql_impdol\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 ( )

inherited

Definition at line 136 of file class_sql_impdol.php.

References $key, $sql, and name.

Referenced by sql_impdol\__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  )

inherited

Definition at line 190 of file class_sql_impdol.php.

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

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

sql_impdol::setp (   $p_string,   $p_value  )

inherited

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 ( )

inherited

Definition at line 106 of file class_sql_impdol.php.

References $array, $key, $sql, name, table, and sql_impdol\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 ( )

inherited

Definition at line 173 of file class_sql_impdol.php.

References $key, and name.

Referenced by sql_impdol\insert(), and sql_impdol\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