install_impdol Class Reference

Collaboration diagram for install_impdol:

Public Member Functions
	install ($p_cn)

Detailed Description

Definition at line 28 of file class_install_impdol.php.

Member Function Documentation

install_impdol::install

(

$p_cn

)

Definition at line 31 of file class_install_impdol.php.

    {
        try
        {
            $p_cn->start();
            $p_cn->exec_sql("create schema impdol");
            $p_cn->exec_sql("
            create table impdol.version (
                v_id bigint primary key,
                v_date date default now(),
                v_text text
            )
                ");
            $p_cn->exec_sql("insert into impdol.version(v_id,v_text) values ($1,$2)", array(1, "Installation"));

            $p_cn->exec_sql("
                CREATE TABLE impdol.import
                    (
                    i_id serial NOT NULL,
                    temp_file text,
                    send_file text,
                    i_date timestamp with time zone DEFAULT now(),
                    i_row bigint,
                    CONSTRAINT import_pkey PRIMARY KEY (i_id )
                    )");

            $p_cn->exec_sql('
            CREATE TABLE impdol.parameter_tva
                (
                    pt_id serial NOT NULL,
                    tva_id bigint,
                    pt_rate numeric(20,4) DEFAULT 0,
                    CONSTRAINT parameter_tva_pkey PRIMARY KEY (pt_id )
                    )
            ');
            $p_cn->exec_sql("
            CREATE TABLE impdol.operation_tmp
                    (
                    o_id bigserial NOT NULL,
                    o_doli text,
                    o_date text,
                    o_qcode text,
                    f_id text,
                    o_label text,
                    o_pj text,
                    amount_unit text,
                    amount_vat text,
                    number_unit text,
                    vat_rate text,
                    amount_total text,
                    jrn_def_id text,
                    o_message text,
                    i_id bigint,
                    o_result char,
                    tva_id bigint,
                    o_type char,
                    o_poste text,
                    CONSTRAINT operation_tmp_pkey PRIMARY KEY (o_id ),
                    CONSTRAINT operation_tmp_i_id_fkey FOREIGN KEY (i_id)
                        REFERENCES impdol.import (i_id) MATCH SIMPLE
                        ON UPDATE CASCADE ON DELETE CASCADE
                    )
            ");

            $p_cn->exec_sql("
            CREATE TABLE impdol.operation_transfer
                (
                ot_id serial NOT NULL,
                j_id bigint,
                o_id bigint,
                CONSTRAINT operation_transfer_pkey PRIMARY KEY (ot_id ),
                CONSTRAINT operation_transfer_j_id_fkey FOREIGN KEY (j_id)
                    REFERENCES jrnx (j_id) MATCH SIMPLE
                    ON UPDATE CASCADE ON DELETE CASCADE,
                CONSTRAINT operation_transfer_o_id_fkey FOREIGN KEY (o_id)
                    REFERENCES impdol.operation_tmp (o_id) MATCH SIMPLE
                    ON UPDATE CASCADE ON DELETE CASCADE
                )");



            $p_cn->exec_sql("
            COMMENT ON COLUMN impdol.operation_tmp.o_result IS 'result is T can be transferrable, N cannot be transferrable';
            ");

            $p_cn->exec_sql("
            COMMENT ON COLUMN impdol.operation_tmp.o_type IS 'S = marchandise, serviceT = tiers (fournisseurs, client)'
            ");
            $p_cn->commit();
        }
        catch (Exception $e)
        {
            $p_cn->rollback();
            print_r($e->getTraceAsString());
        }
    }

---

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

• import_doli/include/class_install_impdol.php