Card_Multiple Class Reference

in follow-up , add multiple cards to an event, an action More...

Collaboration diagram for Card_Multiple:

Public Member Functions
	__construct ()
	build_sql ($sql_array)
	count_sql ($sql_array)
	display_option ($p_action_person_id)
	@global type $g_user More...

Private Member Functions
	filter_enable_card ()

Private Attributes
	$sql
	SQL with the right column name. More...

Detailed Description

in follow-up , add multiple cards to an event, an action

Definition at line 31 of file card_multiple.class.php.

Constructor & Destructor Documentation

__construct()

Card_Multiple::__construct

(

)

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

    {
        $this->sql="select f_id,quick_code,vw_name,accounting,vw_first_name,vw_description,
            (select ad_value from fiche_detail fd where fd.f_id=vw_fiche_attr.f_id and fd.ad_id=25) as company
                  from vw_fiche_attr  ";
    }

Member Function Documentation

build_sql()

Card_Multiple::build_sql

(

$sql_array

)

Parameters

type

$sql_array

Returns

type

Definition at line 45 of file card_multiple.class.php.

    {
        $cn=Dossier::connect();
        $filter="";
        if ( $sql_array["inactive_card"]==0) {
            $filter=" and ".$this->filter_enable_card();
        }
        // By Cat of card
        $sql_cat="";
        if ( $sql_array['search_cat']!=-1) {
            $sql_cat=' and fd_id = '.sql_string($sql_array['search_cat']);
        }
        $query=sql_string($sql_array['query']);
        if ( $sql_array['search_in'] == "-1")
        {
            $string_sql=$this->sql."
                  where 
                  (vw_name ilike '%$query%' 
                  or quick_code ilike '%$query%')
                     ".$filter.$sql_cat."
                  order by vw_name 
                  limit 
                  ".MAX_CARD_SEARCH;
        } else {
            $string_sql=sprintf($this->sql." where f_id in (select f_id from fiche_detail where 
                    ad_id = '%s' and ad_value ilike '%%%s%%')  %s %s"
                    , sql_string($sql_array["search_in"]),$query,$filter,$sql_cat);
        }
        return $string_sql;
    }

References $cn, $filter, $query, $sql_array, Dossier\connect(), MAX_CARD_SEARCH, and sql_string().

Here is the call graph for this function:

count_sql()

Card_Multiple::count_sql

(

$sql_array

)

Parameters

type

$sql_array

Returns

type

Definition at line 80 of file card_multiple.class.php.

    {
        $cn=Dossier::connect();
        $query=sql_string($sql_array['query']);
        $filter="";
        if ( $sql_array["inactive_card"]==0) {
            $filter="and ".$this->filter_enable_card();
        }
        // By Cat of card
        $sql_cat="";
        if ( $sql_array['search_cat']!=-1) {
            $sql_cat=' and fd_id = '.sql_string($sql_array['search_cat']);
        }
 
        $string_sql="select count(*) 
              from vw_fiche_attr  
              where 
              ( vw_name ilike '%$query%' 
              or quick_code ilike '%$query%')
                     ".$filter.$sql_cat;
 
 
        return $cn->get_value($string_sql); 
    }

References $cn, $filter, $query, $sql_array, Dossier\connect(), and sql_string().

Here is the call graph for this function:

display_option()

Card_Multiple::display_option

(

$p_action_person_id

)

@global type $g_user

Parameters

type

$ap_id

Returns

type

Definition at line 119 of file card_multiple.class.php.

    {
        global $g_user;
        $cn=Dossier::connect();
        // retrieve card id (fiche.f_id) and the ag_id (action_gestion.ag_id)
        $tmp=$cn->get_row("select f_id,ag_id from action_person where ap_id=$1 ", [$p_action_person_id]);
        if ($tmp==NULL)
        {
            record_log("CMDO.01nothing found ".var_export($_REQUEST, true));
            return;
        }
        $fiche_id=$tmp['f_id'];
        $ag_id=$tmp['ag_id'];
        if ( ! $g_user->can_read_action($ag_id)) {
            throw new Exception (_("CMCDO01"."Security"));
        }
        // Retrieve Name, first Name and QCODE
        $aIdentity=$cn->get_row("select (select ad_value from fiche_detail where f_id=$1 and ad_id=1) as name , 
            (select ad_value from fiche_detail where f_id=$1 and ad_id=32) as first_name , 
            (select ad_value from fiche_detail where f_id=$1 and ad_id=23) as qcode ",[$fiche_id]); 
            
        // insert new , synchronized
        $cn->exec_sql("insert into action_person_option (ap_value,contact_option_ref_id ,action_person_id ) 
            select null,cor_id,$1
            from contact_option_ref 
            where 
            cor_id not in (
                select contact_option_ref_id 
                from action_person_option 
                join action_person a on (a.ap_id=action_person_id) 
                where f_id=$2 and ag_id=$3)",[$p_action_person_id,$fiche_id,$ag_id]);
 
        // delete disable
        $cn->exec_sql("delete 
                from action_person_option apo 
                where contact_option_ref_id  not in 
               (select contact_option_ref_id from jnt_document_option_contact jdoc join action_gestion on   
               (ag_type=document_type_id) 
                    where ag_id=$1 and jdoc_enable=1)",[$ag_id]);
        
        // First select the option
        $sql="select ap_id,cor_id,ap_value,cor_type ,cor_label,cor_value_select
              from contact_option_ref cor 
              join action_person_option apo on (cor.cor_id=apo.contact_option_ref_id) 
              where action_person_id=$1 order by cor_label  ";
        
        $a_option=$cn->get_array($sql,[$p_action_person_id]);
        require NOALYSS_TEMPLATE."/card_multiple_display_option.php";
        
    }

References $_REQUEST, $ag_id, $cn, $fiche_id, $g_user, $sql, $tmp, Dossier\connect(), and record_log().

Here is the call graph for this function:

filter_enable_card()

Card_Multiple::filter_enable_card ( )

private

Returns

string

Definition at line 108 of file card_multiple.class.php.

    {
        $filter_enable_card="  f_enable='1' ";
        return $filter_enable_card;
    }

Field Documentation

$sql

Card_Multiple::$sql

private

SQL with the right column name.

Definition at line 33 of file card_multiple.class.php.

Referenced by display_option().

---

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

• include/class/card_multiple.class.php