db = $wpdb; $this->table = $this->db->prefix . 'adfoin_integration'; $this->integrations = $this->all(); } public function all() { $all = $this->db->get_results( "SELECT * FROM {$this->table}", 'ARRAY_A' ); return $all; } public function get( $id ) { foreach( $this->integrations as $single_integration ) { if( $id == $single_integration['id'] ) { return $single_integration; } } } public function get_title( $id ) { $integration = $this->get( $id ); if( $integration && isset( $integration['title'] ) ) { return $integration['title']; } } public function get_by_trigger( $trigger_platform, $form = false ) { $sql = "SELECT * FROM {$this->table} WHERE status = 1 AND form_provider = '{$trigger_platform}'"; // $sql = $this->db->prepare( "SELECT * FROM {$this->table} WHERE status = 1 AND form_provider = %s", $trigger_platform ); if( $form ) { $sql .= " AND form_id = '{$form}'"; } $saved_records = $this->db->get_results( $sql, ARRAY_A ); return $saved_records; } public function get_by_trigger_partial( $trigger_platform, $form = false ) { $sql = "SELECT * FROM {$this->table} WHERE status = 1 AND form_provider = '{$trigger_platform}'"; if( $form ) { $sql .= " AND form_id LIKE '%_{$form}'"; } $saved_records = $this->db->get_results( $sql, ARRAY_A ); return $saved_records; } public function send( $saved_records, $posted_data ) { // get job queue settings $job_queue = get_option( 'adfoin_general_settings_job_queue' ); foreach ( $saved_records as $record ) { $action_provider = $record['action_provider']; if ( $job_queue ) { as_enqueue_async_action( "adfoin_{$action_provider}_job_queue", array( 'data' => array( 'record' => $record, 'posted_data' => $posted_data ) ) ); } else { call_user_func( "adfoin_{$action_provider}_send_data", $record, $posted_data ); } } } }