protected function action_addToProspectList()
{
global $beanList;
require_once 'modules/Relationships/Relationship.php';
require_once 'modules/ProspectLists/ProspectList.php';
$prospectList = new ProspectList();
$prospectList->retrieve($_REQUEST['prospect_id']);
$module = new $beanList[$this->bean->report_module]();
$key = Relationship::retrieve_by_modules($this->bean->report_module, 'ProspectLists', $GLOBALS['db']);
if (!empty($key)) {
$sql = $this->bean->build_report_query();
$result = $this->bean->db->query($sql);
$beans = array();
while ($row = $this->bean->db->fetchByAssoc($result)) {
if (isset($row[$module->table_name . '_id'])) {
$beans[] = $row[$module->table_name . '_id'];
}
}
if (!empty($beans)) {
foreach ($prospectList->field_defs as $field => $def) {
if ($def['type'] == 'link' && !empty($def['relationship']) && $def['relationship'] == $key) {
$prospectList->load_relationship($field);
$prospectList->{$field}->add($beans);
}
}
}
}
die;
}
public function action_add_to_list()
{
$ids = $_POST['subpanel_id'];
$event_id = $_POST['return_id'];
$type = $_POST['pop_up_type'];
if (!is_array($ids)) {
$ids = array($ids);
}
//Target lists. Can incliude contacts, leads and targets as part of the target list
if ($type = 'target_list') {
foreach ($ids as $list) {
$event = new FP_events();
$event->retrieve($event_id);
$event->load_relationship('fp_events_prospects_1');
$event->load_relationship('fp_events_contacts');
$event->load_relationship('fp_events_leads_1');
$target_list = new ProspectList();
$target_list->retrieve($list);
$target_list->load_relationship('prospects');
$target_list->load_relationship('contacts');
$target_list->load_relationship('leads');
//add prospects/targets
foreach ($target_list->prospects->getBeans() as $contact) {
$contact_id_list = $event->fp_events_prospects_1->get();
if (!in_array($contact->id, $contact_id_list)) {
//check if its already related
$event->fp_events_prospects_1->add($contact->id);
}
}
//add contacts
foreach ($target_list->contacts->getBeans() as $contact) {
$contact_id_list = $event->fp_events_contacts->get();
if (!in_array($contact->id, $contact_id_list)) {
$event->fp_events_contacts->add($contact->id);
}
}
//add leads
foreach ($target_list->leads->getBeans() as $contact) {
$contact_id_list = $event->fp_events_leads_1->get();
if (!in_array($contact->id, $contact_id_list)) {
$event->fp_events_leads_1->add($contact->id);
}
}
}
}
//Targets
if ($type = 'targets') {
foreach ($ids as $target) {
$event = new FP_events();
$event->retrieve($event_id);
$event->load_relationship('fp_events_prospects_1');
$contact_id_list = $event->fp_events_prospects_1->get();
//get array of currently linked targets
if (!in_array($target, $contact_id_list)) {
//check if its already in the array
$event->fp_events_prospects_1->add($target);
//if not add relationship
}
}
}
//leads
if ($type = 'leads') {
foreach ($ids as $lead) {
$event = new FP_events();
$event->retrieve($event_id);
$event->load_relationship('fp_events_leads_1');
$contact_id_list = $event->fp_events_leads_1->get();
//get array of currently linked leads
if (!in_array($lead, $contact_id_list)) {
//check if its already in the array
$event->fp_events_leads_1->add($lead);
//if not add relationship
}
}
}
//contacts
if ($type = 'contacts') {
foreach ($ids as $contact) {
$event = new FP_events();
$event->retrieve($event_id);
$event->load_relationship('fp_events_contacts');
$contact_id_list = $event->fp_events_contacts->get();
//get array of currently linked contacts
if (!in_array($contact, $contact_id_list)) {
$event->fp_events_contacts->add($contact);
}
}
}
die;
}
function unsubscribe($campaign, $focus) {
$relationship = strtolower($focus->getObjectName()).'s';
//--grab all the list for this campaign id
$pl_qry ="select id, list_type from prospect_lists where id in (select prospect_list_id from prospect_list_campaigns ";
$pl_qry .= "where campaign_id = '$campaign') and deleted = 0 ";
$pl_qry_result = $focus->db->query($pl_qry);
//build the array with list information
$pl_arr = array();
$GLOBALS['log']->debug("In Campaigns Util, about to run query: ".$pl_qry);
while ($row = $focus->db->fetchByAssoc($pl_qry_result)){$pl_arr[] = $row;}
//retrieve lists that this user belongs to
$curr_pl_qry ="select prospect_list_id, related_id from prospect_lists_prospects ";
$curr_pl_qry .="where related_id = '$focus->id' and deleted = 0 ";
$GLOBALS['log']->debug("In Campaigns Util, unsubscribe function about to run query: ".$curr_pl_qry );
$curr_pl_qry_result = $focus->db->query($curr_pl_qry);
//build the array with current user list information
$curr_pl_arr = array();
while ($row = $focus->db->fetchByAssoc($curr_pl_qry_result)){$curr_pl_arr[] = $row;}
//check to see if user is already there in prospect list
$already_here = 'false';
$exempt_id = '';
foreach($curr_pl_arr as $user_list){
foreach($pl_arr as $v){
//if list is exempt list
if($v['list_type'] == 'exempt'){
//save the exempt list id for later use
$exempt_id = $v['id'];
//check to see if user is already in this exempt list
if(in_array($v['id'], $user_list)){
$already_here = 'true';
}
break 2;
}
}
}
//unsubscribe subscripted newsletter
foreach($pl_arr as $subscription_list){
//create a new instance of the prospect list
$exempt_list = new ProspectList();
$exempt_list->retrieve($subscription_list['id']);
$exempt_list->load_relationship($relationship);
//if list type is default, then delete the relationship
//if list type is exempt, then add the relationship to unsubscription list
if($subscription_list['list_type'] == 'exempt') {
$exempt_list->$relationship->add($focus->id);
}elseif($subscription_list['list_type'] == 'default' || $subscription_list['list_type'] == 'test'){
//if list type is default or test, then delete the relationship
//$exempt_list->$relationship->delete($subscription_list['id'],$focus->id);
}
}
if($already_here =='true'){
//do nothing, user is already exempted
}else{
//user is not exempted yet , so add to unsubscription list
$exempt_result = $exempt_list->retrieve($exempt_id);
if($exempt_result == null)
{//error happened while retrieving this list
return;
}
$GLOBALS['log']->debug("In Campaigns Util, loading relationship: ".$relationship);
$exempt_list->load_relationship($relationship);
$exempt_list->$relationship->add($focus->id);
}
}
function unsubscribe($campaign, $focus)
{
$relationship = strtolower($focus->getObjectName()) . 's';
//--grab the exempt list for this campaign id
$pl_qry = "select id from prospect_lists where id in (select prospect_list_id from prospect_list_campaigns ";
$pl_qry .= "where campaign_id = '{$campaign}') and deleted = 0 ";
$pl_qry .= "and list_type like 'exempt%' and deleted = 0 ";
$pl_qry_result = $focus->db->query($pl_qry);
//build the array with list information
$pl_arr = array();
$GLOBALS['log']->debug("In Campaigns Util, about to run query: " . $pl_qry);
$pl_arr = $focus->db->fetchByAssoc($pl_qry_result);
//retrieve lists that this user belongs to
$curr_pl_qry = "select prospect_list_id, related_id from prospect_lists_prospects ";
$curr_pl_qry .= "where related_id = '{$focus->id}' and deleted = 0 ";
$GLOBALS['log']->debug("In Campaigns Util, unsubscribe function about to run query: " . $curr_pl_qry);
$curr_pl_qry_result = $focus->db->query($curr_pl_qry);
//build the array with current user list information
$curr_pl_arr = array();
while ($row = $focus->db->fetchByAssoc($curr_pl_qry_result)) {
$curr_pl_arr[] = $row;
}
//check to see if user is already there in prospect list
$already_here = 'false';
foreach ($curr_pl_arr as $user_list) {
if (in_array($pl_arr['id'], $user_list)) {
$already_here = 'true';
}
}
if ($already_here == 'true') {
//do nothing, user is already exempted
} else {
//user is not exempted yet , so add to unsubscription list
$exempt_list = new ProspectList();
$exempt_result = $exempt_list->retrieve($pl_arr['id']);
if ($exempt_result == null) {
//error happened while retrieving this list
return;
}
$GLOBALS['log']->debug("In Campaigns Util, loading relationship: " . $relationship);
$exempt_list->load_relationship($relationship);
$exempt_list->{$relationship}->add($focus->id);
}
}