Follow_Up_Other_Concerned Class Reference

Others concerned card in an action. More...

Collaboration diagram for Follow_Up_Other_Concerned:

Public Member Functions
	__construct ($p_database, $p_action_gestion_id)
	button_action_add_concerned_card ()
	Return a HTML string with a button for adding other cards.
	display_linked_count ()
	Display the count of other concerned card (tiers, supplier...) in button which call.
	display_row ($p_fid, $p_row, $pa_Column)
	Display one row for all the option of a card.
	display_table ()
	Display all the person with option in a html table.
	get_ag_id ()
	get_db ()
	get_option ()
	Get Available options.
	insert_linked_card ($p_fiche_id)
	Add another concerned (tiers, supplier...)
	remove_linked_card ($p_fiche_id)
	Remove another concerned (tiers, supplier...)
	set_ag_id ($ag_id)
	set_db ($cn)

Private Attributes
	$ag_id
	$db

Detailed Description

Others concerned card in an action.

See also

Follow_Up

Definition at line 34 of file follow_up_other_concerned.class.php.

Constructor & Destructor Documentation

__construct()

Follow_Up_Other_Concerned::__construct	(		$p_database,
			$p_action_gestion_id )

Definition at line 40 of file follow_up_other_concerned.class.php.

    {
        $this->db=$p_database;
        $this->ag_id=$p_action_gestion_id;
    }

References ag_id, and db.

Member Function Documentation

button_action_add_concerned_card()

Follow_Up_Other_Concerned::button_action_add_concerned_card

(

)

Return a HTML string with a button for adding other cards.

Returns

type

Definition at line 129 of file follow_up_other_concerned.class.php.

    {
        $dossier=Dossier::id();
        $javascript=<<<EOF
                    var obj={dossier:$dossier,ag_id:$this->ag_id};action_concerned_search_card(obj);
EOF;
        $js=HtmlInput::button_action(_('Ajout autres'), $javascript, 'xx', 'smallbutton');
        return $js;
    }

References $dossier, $js, _, and ag_id.

display_linked_count()

Follow_Up_Other_Concerned::display_linked_count

(

)

Display the count of other concerned card (tiers, supplier...) in button which call.

Returns

string

Definition at line 90 of file follow_up_other_concerned.class.php.

    {
        $a_linked=$this->db->get_array('select ap_id,f_id from action_person where ag_id=$1', array($this->ag_id));
        if (count($a_linked)==0)
            return "0";
        $dossier_id=Dossier::id();
        $javascript=<<<EOF
                    var obj={dossier:$dossier_id,ag_id:$this->ag_id};action_concerned_list(obj);
EOF;
        echo HtmlInput::anchor_action(count($a_linked), $javascript, 'linked_card_bt', "button");
    }

References $dossier_id, ag_id, and db.

display_row()

Follow_Up_Other_Concerned::display_row	(		$p_fid,
			$p_row,
			$pa_Column )

Display one row for all the option of a card.

Parameters

int	$p_fid	card if (fiche.f_id)
int	$p_row	index of the row used for alternate the color of the rows
array	$aOther	Column of the options

Definition at line 145 of file follow_up_other_concerned.class.php.

    {
        static $dossier_id;
        $dossier_id=Dossier::id();
 
        $action_person_id=$this->db->get_value("select ap_id from action_person where f_id=$1 and ag_id=$2",
                [$p_fid, $this->ag_id]);
 
        // Name , first & quick code from fiche
        $row=$this->db->get_row("select 
            (select ad_value from fiche_detail fd2 where fd2.f_id=ap.f_id and fd2.ad_id = 1) as xname,
            (select ad_value from fiche_detail fd2 where fd2.f_id=ap.f_id and fd2.ad_id = 32) as xfirst_name,
            (select ad_value from fiche_detail fd2 where fd2.f_id=ap.f_id and fd2.ad_id = 23) as xqcode
            from fiche ap
            where ap.f_id=$1
                ", [$p_fid]);
 
 
        // Detail for this one
        $detail=HtmlInput::anchor($row['xqcode'], "",
                        sprintf("onclick=\"linked_card_option('%s','%s')\"", $action_person_id, $dossier_id),
                        'class="line"', _("Options"));
        // remove card
        $js_remove=sprintf("action_remove_concerned('%s','%s','%s')", dossier::id(), $p_fid, $this->ag_id);
        $remove=Icon_Action::trash(uniqid(), $js_remove);
        $r=<<<EOF
    <tr id="other_{$action_person_id}">
       
        <td>
            {$detail}
        </td>
        <td>
            {$row['xname']}
        </td>
        <td>
            {$row['xfirst_name']}
        </td>
EOF;
        $nb_other=count($pa_Column);
        for ($i=0; $i<$nb_other; $i++)
        {
            $value=$this->db->get_value("
                        select  apo2.ap_value
                        from action_person_option apo2 
                        join action_person ap on (apo2.action_person_id=ap.ap_id) 
                        where 
                        apo2.contact_option_ref_id =$1
                        and ap.f_id=$2
                        and ap.ag_id=$3
                        ", array($pa_Column[$i]['cor_id'], $p_fid, $this->ag_id));
            $r.=td($value);
        }
        $r.='<td>'.$remove.'</td>';
        $r.='</tr>';
        return $r;
    }

References $action_person_id, $detail, $dossier_id, $i, $js_remove, $nb_other, $r, $row, $value, _, ag_id, db, td(), tr(), and Icon_Action\trash().

Here is the call graph for this function:

display_table()

Follow_Up_Other_Concerned::display_table

(

)

Display all the person with option in a html table.

Definition at line 205 of file follow_up_other_concerned.class.php.

    {
        require_once NOALYSS_TEMPLATE."/follow_up_other_concerned_display_table.php";
    }

get_ag_id()

Follow_Up_Other_Concerned::get_ag_id

(

)

Definition at line 46 of file follow_up_other_concerned.class.php.

    {
        return $this->ag_id;
    }

References $ag_id.

get_db()

Follow_Up_Other_Concerned::get_db

(

)

Definition at line 57 of file follow_up_other_concerned.class.php.

    {
        return $this->db;
    }

References $db.

get_option()

Follow_Up_Other_Concerned::get_option

(

)

Get Available options.

Definition at line 213 of file follow_up_other_concerned.class.php.

    {
        $aColumn=$this->db->get_array("select cor_id,cor_label,jdoc.jdoc_enable 
    from contact_option_ref cor 
    join jnt_document_option_contact jdoc on (cor.cor_id=jdoc.contact_option_ref_id ) 
    join action_gestion ag on (ag.ag_type=jdoc.document_type_id ) 
    where ag_id=$1 and jdoc.jdoc_enable=1
    order by upper(cor_label)", [$this->ag_id]);
        return $aColumn;
    }

References $aColumn, ag_id, and db.

insert_linked_card()

Follow_Up_Other_Concerned::insert_linked_card

(

$p_fiche_id

)

Add another concerned (tiers, supplier...)

Remarks

type $g_user

Parameters

type

$p_fiche_id

insert into action_person

Definition at line 107 of file follow_up_other_concerned.class.php.

    {
        global $g_user;
        if ($g_user->can_write_action($this->ag_id))
        {
            /**
             * insert into action_person
             */
            $count=$this->db->get_value('select count(*) from action_person where f_id=$1 and ag_id=$2',
                    array($p_fiche_id, $this->ag_id));
            if ($count==0)
            {
                $this->db->exec_sql('insert into action_person (ag_id,f_id) values ($1,$2)',
                        array($this->ag_id, $p_fiche_id));
            }
        }
    }

References $count, $g_user, ag_id, and db.

remove_linked_card()

Follow_Up_Other_Concerned::remove_linked_card

(

$p_fiche_id

)

Remove another concerned (tiers, supplier...)

Remarks

type $g_user

Parameters

type

$p_fiche_id

Definition at line 73 of file follow_up_other_concerned.class.php.

    {
        global $g_user;
        if ($g_user->can_write_action($this->ag_id))
        {
            $this->db->exec_sql('delete from action_person where ag_id = $1 and f_id = $2',
                    array($this->ag_id, $p_fiche_id));
            return true;
        }
        return false;
    }

References $g_user, ag_id, and db.

set_ag_id()

Follow_Up_Other_Concerned::set_ag_id

(

$ag_id

)

Definition at line 51 of file follow_up_other_concerned.class.php.

    {
        $this->ag_id=$ag_id;
        return $this;
    }

References $ag_id, and ag_id.

set_db()

Follow_Up_Other_Concerned::set_db

(

$cn

)

Definition at line 62 of file follow_up_other_concerned.class.php.

    {
        $this->db=$cn;
        return $this;
    }

References $cn, and db.

Field Documentation

$ag_id

Follow_Up_Other_Concerned::$ag_id

private

Definition at line 37 of file follow_up_other_concerned.class.php.

Referenced by get_ag_id(), and set_ag_id().

$db

Follow_Up_Other_Concerned::$db

private

Definition at line 38 of file follow_up_other_concerned.class.php.

Referenced by get_db().

---

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

• include/class/follow_up_other_concerned.class.php