1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 

<?php
/**
 * Lead Data Query
 * @name Lead Queries
 * @description Definitions and Lookup Maps for Lead Data
 * @uthor Inbound Now
 * @contributors Hudson Atwell
 * @package Automation
 * @subpackage Queries
 *
*/



if ( !class_exists( 'Inbound_Automation_Query_Lead' ) ) {

    class Inbound_Automation_Query_Lead {

        /**
        *   Build Query Loopup Dataset. Keys in th queries array should also have a corresponding method inside of this class prefixed with the query_ namespace.
        */
        public static function get_key_map( ) {

            $queries['page_view_count'] = __( 'Page view count' , 'inbound-pro' );
            $queries['form_submissions_count'] = __( 'Form submission count' , 'inbound-pro' );
            $queries['email_open_count'] = __( 'Email open count' , 'inbound-pro' );
            $queries['email_click_count'] = __( 'Email click count' , 'inbound-pro' );
            $queries['viewed_page_id'] = __( 'Lead has viewed this content (Page/Post ID)' , 'inbound-pro' );
            $queries['opened_email_id'] = __( 'Lead has opening this email (Email ID)' , 'inbound-pro' );
            $queries['clicked_cta_id'] = __( 'Lead has clicked this CTA (CTA ID)' , 'inbound-pro' );

            return $queries;
        }


        /**
         * Look up how many email links the user has clicked
         * @param ARRAY $trigger_data dataset of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */

        public static function query_page_view_count( $filter , $arguments ) {
            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            if ( !isset($lead_id) && !$lead_id ) {
                return null;
            }

            $results = Inbound_Events::get_page_views_count_by('lead_id' , array('lead_id'=>$lead_id) );

            return $results;
        }

        /**
         * Look up how many forms the user has submissed
         * @param arguments ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_email_click_count(  $filter , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            if ( !isset($lead_id) && !$lead_id ) {
                return null;
            }

            $results = Inbound_Events::get_all_email_clicks($lead_id);

            return count($results);
        }

        /**
         * Look up how many emails the lead has opened
         * @param lead_data ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_email_open_count(  $filter  , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            if ( !isset($lead_id) || !$lead_id ) {
                return null;
            }

            $results = Inbound_Events::get_all_email_opens($lead_id);

            return count($results);
        }

        /**
         * Look up how many emails the lead has opened
         * @param lead_data ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_form_submissions_count(  $filter , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            if ( !isset($lead_id) || !$lead_id ) {
                return null;
            }

            $results = Inbound_Events::get_form_submissions_by('lead_id' , array('lead_id'=>$lead_id));

            return count($results);
        }

        /**
         * Lookup if lead has viewed a specific page or not
         * @param lead_data ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_viewed_page_id(  $filter , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            /* discover email id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['page_id'])) {
                    $email_id = $args['page_id'];
                    break;
                }
            }

            /* bail if data not set or set to 0 */
            if ( (!isset($lead_id) || !$lead_id )
                ||
                (!isset($page_id) || !$page_id )
            ) {
                return null;
            }

            $result = Inbound_Events::check_page_view(array(
                'lead_id'=>$lead_id,
                'page_id' => $filter['action_filter_value']
            ));

            return $result;
        }

        /**
         * Lookup if lead has opened a specific email
         * @param tracked_data ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_opened_email_id(  $filter , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            /* bail if data not set or set to 0 */
            if ( !isset($lead_id) || !$lead_id ) {
                return null;
            }

            $result = Inbound_Events::check_email_open(array(
                'lead_id'=>$lead_id,
                'email_id' => $filter['action_filter_value']
            ));

            return $result;
        }


        /**
         * Lookup if lead has opened a specific email
         * @param tracked_data ARRAY of arguments sent over by trigger. One of the arguments must contain key 'lead_id'
         * @return INT
        */
        public static function query_clicked_cta_id(  $filter , $arguments ) {

            /* discover lead id */
            foreach ($arguments as $key=> $args) {
                if (isset($args['lead_id'])) {
                    $lead_id = $args['lead_id'];
                    break;
                }
            }

            /* bail if data not set or set to 0 */
            if ( !isset($lead_id) || !$lead_id ) {
                return null;
            }

            $result = Inbound_Events::check_cta_click(array(
                'lead_id'=>$lead_id,
                'cta_id' => $filter['action_filter_value']
            ));

            return $result;
        }

    }
}