PHP EmailMarketing::retrieve方法代码示例

 public function testretrieve()
 {
     error_reporting(E_ERROR | E_PARSE);
     $emailMarketing = new EmailMarketing();
     $result = $emailMarketing->retrieve();
     $this->assertInstanceOf('EmailMarketing', $result);
 }

 //fetch user that scheduled the campaign.
 if (empty($current_user) or $row['user_id'] != $current_user->id) {
     $current_user->retrieve($row['user_id']);
 }
 if (!$emailman->verify_campaign($row['marketing_id'])) {
     $GLOBALS['log']->fatal('Error verifying templates for the campaign, exiting');
     continue;
 }
 //verify the email template too..
 //find the template associated with marketing message. make sure that template has a subject and
 //a non-empty body
 if (!isset($template_status[$row['marketing_id']])) {
     if (!class_exists('EmailMarketing')) {
     }
     $current_emailmarketing = new EmailMarketing();
     $current_emailmarketing->retrieve($row['marketing_id']);
     if (!class_exists('EmailTemplate')) {
     }
     $current_emailtemplate = new EmailTemplate();
     $current_emailtemplate->retrieve($current_emailmarketing->template_id);
 }
 //acquire a lock.
 //if the database does not support repeatable read isolation by default, we might get data that does not meet
 //the criteria in the original query, and we care most about the in_queue_date and process_date_time,
 //if they are null or in past(older than 24 horus) then we are okay.
 $lock_query = "UPDATE emailman SET in_queue=1, in_queue_date=" . $db->now() . " WHERE id = " . intval($row['id']);
 $lock_query .= " AND (in_queue ='0' OR in_queue IS NULL OR ( in_queue ='1' AND in_queue_date <= " . $db->convert($db->quoted($timedate->fromString("-1 day")->asDb()), "datetime") . "))";
 //if the query fails to execute.. terminate campaign email process.
 $lock_result = $db->query($lock_query, true, 'Error acquiring a lock for emailman entry.');
 $lock_count = $db->getAffectedRowCount($lock_result);
 //do not process the message if unable to acquire lock.

if (isset($_REQUEST['from_wiz'])) {
    $from_wiz = true;
}
//if campaign status is 'sending' disallow this step.
if (!empty($campaign->status) && $campaign->status == 'sending') {
    $err_messages[] = $mod_strings['ERR_SENDING_NOW'];
}
$current_date = $campaign->db->now();
//start scheduling now.....
foreach ($_POST['mass'] as $message_id) {
    //fetch email marketing definition.
    if (!class_exists('EmailMarketing')) {
        require_once 'modules/EmailMarketing/EmailMarketing.php';
    }
    $marketing = new EmailMarketing();
    $marketing->retrieve($message_id);
    //make sure that the marketing message has a mailbox.
    //
    if (empty($marketing->inbound_email_id)) {
        echo "<p>";
        echo "<h4>{$mod_strings['ERR_NO_MAILBOX']}</h4>";
        echo "<BR><a href='index.php?module=EmailMarketing&action=EditView&record={$marketing->id}'>{$marketing->name}</a>";
        echo "</p>";
        sugar_die('');
    }
    global $timedate;
    $mergedvalue = $timedate->merge_date_time($marketing->date_start, $marketing->time_start);
    if ($test) {
        $send_date_time = $timedate->getNow()->get("-60 seconds")->asDb();
    } else {
        $send_date_time = $timedate->to_db($mergedvalue);

function create_marketing_summary($focus)
{
    global $mod_strings, $app_strings;
    $colorclass = '';
    //create new marketing button input
    $new_mrkt_input = "<input id='wiz_new_mrkt_button' name='SUBMIT' ";
    $new_mrkt_input .= "onclick=\"this.form.return_module.value='Campaigns';";
    $new_mrkt_input .= "this.form.module.value='Campaigns';";
    $new_mrkt_input .= "this.form.record.value='';";
    $new_mrkt_input .= "this.form.return_module.value='Campaigns';";
    $new_mrkt_input .= "this.form.action.value='WizardMarketing';";
    $new_mrkt_input .= "this.form.return_action.value='WizardHome';";
    $new_mrkt_input .= "this.form.direct_step.value='1';";
    $new_mrkt_input .= "this.form.campaign_id.value='" . $focus->id . "';";
    $new_mrkt_input .= "this.form.return_id.value='" . $focus->id . "';\" ";
    $new_mrkt_input .= "class='button' value='" . $mod_strings['LBL_CREATE_NEW_MARKETING_EMAIL'] . "' type='submit'>";
    //create marketing email table
    $mrkt_tbl = '';
    $focus->load_relationship('emailmarketing');
    $mrkt_lists = $focus->emailmarketing->get();
    $mrkt_tbl = "<p><table  class='list view' width='100%' border='0' cellspacing='1' cellpadding='1'>";
    $mrkt_tbl .= "<tr class='detail view'><td colspan='3'><h4> " . $mod_strings['LBL_WIZ_MARKETING_TITLE'] . " </h4></td>" . "<td colspan=2 align='right'>{$new_mrkt_input}</td></tr>";
    $mrkt_tbl .= "<tr  class='listViewHRS1'><td scope='col' width='15%'><b>" . $mod_strings['LBL_MRKT_NAME'] . "</b></td><td width='15%' scope='col'><b>" . $mod_strings['LBL_FROM_MAILBOX_NAME'] . "</b></td><td width='15%' scope='col'><b>" . $mod_strings['LBL_STATUS_TEXT'] . "</b></td><td scope='col' colspan=2>&nbsp;</td></tr>";
    if (count($mrkt_lists) > 0) {
        $mrkt_focus = new EmailMarketing();
        foreach ($mrkt_lists as $mrkt_id) {
            $mrkt_focus->retrieve($mrkt_id);
            //create send test marketing button input
            $test_mrkt_input = "<input id='wiz_new_mrkt_button' name='SUBMIT'  ";
            $test_mrkt_input .= "onclick=\"this.form.return_module.value='Campaigns'; ";
            $test_mrkt_input .= "this.form.module.value='Campaigns'; ";
            $test_mrkt_input .= "this.form.record.value='';";
            $test_mrkt_input .= "this.form.return_module.value='Campaigns'; ";
            $test_mrkt_input .= "this.form.action.value='QueueCampaign'; ";
            $test_mrkt_input .= "this.form.return_action.value='WizardHome'; ";
            $test_mrkt_input .= "this.form.wiz_mass.value='" . $mrkt_focus->id . "'; ";
            $test_mrkt_input .= "this.form.mode.value='test'; ";
            $test_mrkt_input .= "this.form.direct_step.value='1'; ";
            $test_mrkt_input .= "this.form.record.value='" . $focus->id . "'; ";
            $test_mrkt_input .= "this.form.return_id.value='" . $focus->id . "';\" ";
            $test_mrkt_input .= "class='button' value='" . $mod_strings['LBL_TEST_BUTTON_LABEL'] . "' type='submit'>";
            //create send marketing button input
            $send_mrkt_input = "<input id='wiz_new_mrkt_button' name='SUBMIT'  ";
            $send_mrkt_input .= "onclick=\"this.form.return_module.value='Campaigns'; ";
            $send_mrkt_input .= "this.form.module.value='Campaigns'; ";
            $send_mrkt_input .= "this.form.record.value='';";
            $send_mrkt_input .= "this.form.return_module.value='Campaigns'; ";
            $send_mrkt_input .= "this.form.action.value='QueueCampaign'; ";
            $send_mrkt_input .= "this.form.return_action.value='WizardHome'; ";
            $send_mrkt_input .= "this.form.wiz_mass.value='" . $mrkt_focus->id . "'; ";
            $send_mrkt_input .= "this.form.mode.value='send'; ";
            $send_mrkt_input .= "this.form.direct_step.value='1'; ";
            $send_mrkt_input .= "this.form.record.value='" . $focus->id . "'; ";
            $send_mrkt_input .= "this.form.return_id.value='" . $focus->id . "';\" ";
            $send_mrkt_input .= "class='button' value='" . $mod_strings['LBL_SEND_EMAIL'] . "' type='submit'>";
            if ($colorclass == "class='evenListRowS1'") {
                $colorclass = "class='oddListRowS1'";
            } else {
                $colorclass = "class='evenListRowS1'";
            }
            if (isset($mrkt_focus->name) && !empty($mrkt_focus->name)) {
                $mrkt_tbl .= "<tr {$colorclass}>";
                $mrkt_tbl .= "<td scope='row' width='40%'><a href='index.php?action=WizardMarketing&module=Campaigns&return_module=Campaigns&return_action=WizardHome";
                $mrkt_tbl .= "&return_id=" . $focus->id . "&campaign_id=" . $focus->id . "&record=" . $mrkt_focus->id . "'>" . $mrkt_focus->name . "</a></td>";
                $mrkt_tbl .= "<td scope='row' width='25%'>" . $mrkt_focus->from_name . "</td>";
                $mrkt_tbl .= "<td scope='row' width='15%'>" . $mrkt_focus->status . "</td>";
                $mrkt_tbl .= "<td scope='row' width='10%'>{$test_mrkt_input}</td>";
                $mrkt_tbl .= "<td scope='row' width='10%'>{$send_mrkt_input}</td>";
                $mrkt_tbl .= "</tr>";
            }
        }
    } else {
        $mrkt_tbl .= "<tr><td colspan='3'>" . $mod_strings['LBL_NONE'] . "</td></tr>";
    }
    $mrkt_tbl .= "</table></p>";
    return $mrkt_tbl;
}

}
if (isset($_REQUEST['return_id'])) {
    $ss->assign("RETURN_ID", $_REQUEST['return_id']);
}
// handle Create $module then Cancel
$ss->assign('CAMPAIGN_ID', $campaign_focus->id);
$seps = get_number_seperators();
$ss->assign("NUM_GRP_SEP", $seps[0]);
$ss->assign("DEC_SEP", $seps[1]);
/**************************** MARKETING UI DIV Stuff *******************/
//$campaign_focus->load_relationship('emailmarketing');
//$mrkt_ids = $campaign_focus->emailmarketing->get();
$mrkt_focus = new EmailMarketing();
//if record param exists and it is not empty, then retrieve this bean
if (isset($_REQUEST['record']) and !empty($_REQUEST['record'])) {
    $mrkt_focus->retrieve($_REQUEST['record']);
} else {
    //check to see if this campaign has an email marketing already attached, and if so, create duplicate
    $campaign_focus->load_relationship('emailmarketing');
    $mrkt_lists = $campaign_focus->emailmarketing->get();
    if (!empty($mrkt_lists)) {
        //reverse array so we always use the most recent one:
        $mrkt_lists = array_reverse($mrkt_lists);
        $mrkt_focus->retrieve($mrkt_lists[0]);
        $mrkt_focus->id = '';
        $mrkt_focus->name = $mod_strings['LBL_COPY_OF'] . ' ' . $mrkt_focus->name;
    }
}
$ss->assign("CALENDAR_LANG", "en");
$ss->assign("USER_DATEFORMAT", '(' . $timedate->get_user_date_format() . ')');
$ss->assign("CALENDAR_DATEFORMAT", $timedate->get_cal_date_format());

 function verify_campaign($marketing_id)
 {
     if (!isset($this->verified_email_marketing_ids[$marketing_id])) {
         if (!class_exists('EmailMarketing')) {
         }
         $email_marketing = new EmailMarketing();
         $ret = $email_marketing->retrieve($marketing_id);
         if (empty($ret)) {
             $GLOBALS['log']->fatal('Error retrieving marketing message for the email campaign. marketing_id = ' . $marketing_id);
             return false;
         }
         //verify the email template.
         if (empty($email_marketing->template_id)) {
             $GLOBALS['log']->fatal('Error retrieving template for the email campaign. marketing_id = ' . $marketing_id);
             return false;
         }
         if (!class_exists('EmailTemplate')) {
         }
         $emailtemplate = new EmailTemplate();
         $ret = $emailtemplate->retrieve($email_marketing->template_id);
         if (empty($ret)) {
             $GLOBALS['log']->fatal('Error retrieving template for the email campaign. template_id = ' . $email_marketing->template_id);
             return false;
         }
         if (empty($emailtemplate->subject) and empty($emailtemplate->body) and empty($emailtemplate->body_html)) {
             $GLOBALS['log']->fatal('Email template is empty. email_template_id=' . $email_marketing->template_id);
             return false;
         }
     }
     $this->verified_email_marketing_ids[$marketing_id] = 1;
     return true;
 }

        $master = 'send';
    } elseif ($_REQUEST['wiz_home_next_step'] == 2) {
        //user has chosen to save and send this campaign in test mode
        $master = 'test';
    } else {
        //user has chosen to simply save
        $master = 'save';
    }
} else {
    //default to just saving and exiting wizard
    $master = 'save';
}
$prefix = 'wiz_step3_';
$marketing = new EmailMarketing();
if (isset($_REQUEST['record']) && !empty($_REQUEST['record'])) {
    $marketing->retrieve($_REQUEST['record']);
}
if (!$marketing->ACLAccess('Save')) {
    ACLController::displayNoAccess(true);
    sugar_cleanup(true);
}
if (!empty($_REQUEST['assigned_user_id']) && $marketing->assigned_user_id != $_REQUEST['assigned_user_id'] && $_POST['assigned_user_id'] != $current_user->id) {
    $check_notify = TRUE;
} else {
    $check_notify = FALSE;
}
foreach ($_REQUEST as $key => $val) {
    if (strstr($key, $prefix) && strpos($key, $prefix) == 0) {
        $newkey = substr($key, strlen($prefix));
        $_REQUEST[$newkey] = $val;
    }

 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/
/*********************************************************************************
 * Description:  TODO: To be written.
 * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
 * All Rights Reserved.
 * Contributor(s): ______________________________________..
 ********************************************************************************/
$focus = new EmailMarketing();
if (!isset($_REQUEST['record'])) {
    sugar_die("A record number must be specified to delete the marketing campaign.");
}
$focus->retrieve($_REQUEST['record']);
if (!$focus->ACLAccess('Delete')) {
    ACLController::displayNoAccess(true);
    sugar_cleanup(true);
}
$focus->mark_deleted($_REQUEST['record']);
if (isset($_REQUEST['record'])) {
    $query = "DELETE FROM emailman WHERE marketing_id ='" . $_REQUEST['record'] . "'";
    $focus->db->query($query);
}
header("Location: index.php?module=" . $_REQUEST['return_module'] . "&action=" . $_REQUEST['return_action'] . "&record=" . $_REQUEST['return_id']);

        $query .= " and prospect_lists.deleted=0 ";
        $query .= " and prospect_lists.list_type='test' ";
        $query .= " and plc.deleted=0 ";
        $query .= " and plc.campaign_id='{$campaign_id}'";
        $query .= " and email_marketing.campaign_id='{$campaign_id}'";
        $query .= " and email_marketing.deleted=0 ";
        $query .= " and email_marketing.all_prospect_lists=0 ";
        $seed = array();
        $result = $focus->db->query($query);
        while (($row = $focus->db->fetchByAssoc($result)) != null) {
            $bean = new EmailMarketing();
            $bean->retrieve($row['email_marketing_id']);
            $bean->mode = 'test';
            $seed[] = $bean;
        }
        $query = " select email_marketing.id email_marketing_id from email_marketing ";
        $query .= " WHERE email_marketing.campaign_id='{$campaign_id}'";
        $query .= " and email_marketing.deleted=0 ";
        $query .= " and email_marketing.all_prospect_lists=1 ";
        $result = $focus->db->query($query);
        while (($row = $focus->db->fetchByAssoc($result)) != null) {
            $bean = new EmailMarketing();
            $bean->retrieve($row['email_marketing_id']);
            $bean->mode = 'test';
            $seed[] = $bean;
        }
        $ListView->processListView($seed, "main", "EMAILMARKETING");
    } else {
        $ListView->processListView($focus, "main", "EMAILMARKETING");
    }
}

 ********************************************************************************/
global $timedate;
global $current_user;
if (!empty($_POST['meridiem'])) {
    $_POST['time_start'] = $timedate->merge_time_meridiem($_POST['time_start'], $timedate->get_time_format(), $_POST['meridiem']);
}
if (empty($_REQUEST['time_start'])) {
    $_REQUEST['date_start'] = $_REQUEST['date_start'] . ' 00:00';
    $_POST['date_start'] = $_POST['date_start'] . ' 00:00';
} else {
    $_REQUEST['date_start'] = $_REQUEST['date_start'] . ' ' . $_REQUEST['time_start'];
    $_POST['date_start'] = $_POST['date_start'] . ' ' . $_POST['time_start'];
}
$marketing = new EmailMarketing();
if (isset($_POST['record']) && !empty($_POST['record'])) {
    $marketing->retrieve($_POST['record']);
}
if (!$marketing->ACLAccess('Save')) {
    ACLController::displayNoAccess(true);
    sugar_cleanup(true);
}
if (!empty($_POST['assigned_user_id']) && $marketing->assigned_user_id != $_POST['assigned_user_id'] && $_POST['assigned_user_id'] != $current_user->id) {
    $check_notify = TRUE;
} else {
    $check_notify = FALSE;
}
foreach ($marketing->column_fields as $field) {
    if ($field == 'all_prospect_lists') {
        if (isset($_POST[$field]) && ($_POST[$field] = 'on')) {
            $marketing->{$field} = 1;
        } else {

        $master = 'send';
    } elseif ($_REQUEST['wiz_home_next_step'] == 2) {
        //user has chosen to save and send this campaign in test mode
        $master = 'test';
    } else {
        //user has chosen to simply save
        $master = 'save';
    }
} else {
    //default to just saving and exiting wizard
    $master = 'save';
}
$prefix = 'wiz_step3_';
$marketing = new EmailMarketing();
if (isset($_REQUEST['record']) && !empty($_REQUEST['record'])) {
    $marketing->retrieve($_REQUEST['record']);
} else {
    if (!empty($_SESSION['campaignWizard'][$_REQUEST['campaign_id']]['defaultSelectedMarketingId'])) {
        $marketing->retrieve($_SESSION['campaignWizard'][$_REQUEST['campaign_id']]['defaultSelectedMarketingId']);
    }
}
if (!$marketing->ACLAccess('Save')) {
    ACLController::displayNoAccess(true);
    sugar_cleanup(true);
}
if (!empty($_REQUEST['assigned_user_id']) && $marketing->assigned_user_id != $_REQUEST['assigned_user_id'] && $_POST['assigned_user_id'] != $current_user->id) {
    $check_notify = TRUE;
} else {
    $check_notify = FALSE;
}
foreach ($_REQUEST as $key => $val) {

if(!empty($_SESSION['campaignWizardSelectedMarketingId']) && !in_array($_SESSION['campaignWizardSelectedMarketingId'], $mrkt_lists)) {
    unset($_SESSION['campaignWizardSelectedMarketingId']);
}

if(!empty($_SESSION['campaignWizardSelectedMarketingId'])) {
    if(!empty($_REQUEST['record']) && in_array($_SESSION['campaignWizardSelectedMarketingId'], $mrkt_lists)) {
        $_REQUEST['record'] = $_SESSION['campaignWizardSelectedMarketingId'];
    }
    if(!empty($_REQUEST['marketing_id']) && in_array($_SESSION['campaignWizardSelectedMarketingId'], $mrkt_lists)) {
        $_REQUEST['marketing_id'] = $_SESSION['campaignWizardSelectedMarketingId'];
    }
}

//if record param exists and it is not empty, then retrieve this bean
if(isset($_REQUEST['record']) and !empty($_REQUEST['record'])){
    $mrkt_focus->retrieve($_REQUEST['record']);
    $_SESSION['campaignWizardSelectedMarketingId'] = $mrkt_focus->id;
}
else if(isset($_REQUEST['marketing_id']) and !empty($_REQUEST['marketing_id'])) {
    $mrkt_focus->retrieve($_REQUEST['marketing_id']);
    $_SESSION['campaignWizardSelectedMarketingId'] = $mrkt_focus->id;
}else{



    if(!isset($mrkt_lists) || !$mrkt_lists) {
        unset($_SESSION['campaignWizardSelectedMarketingId']);
    }
    else if(count($mrkt_lists) == 1){
        $mrkt_focus->retrieve($mrkt_lists[0]);
        $_SESSION['campaignWizardSelectedMarketingId'] = $mrkt_lists[0];

 *
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for  technical reasons, the Appropriate Legal Notices must
 * display the words  "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 ********************************************************************************/

global $db;

$campaignId = $db->quote($_POST['campaignId']);
$marketingId = $db->quote($_POST['marketingId']);
if(!empty($_POST['templateId'])) {
    $templateId = $db->quote($_POST['templateId']);
}

//$campaign = new Campaign();
//$campaign->retrieve($campaignId);

$marketing = new EmailMarketing();
$marketing->retrieve($marketingId);
$marketing->campaign_id = $campaignId;
if(!empty($_POST['templateId'])) {
    $marketing->template_id = $templateId;
}
$marketing->save();

$_SESSION['campaignWizardSelectedMarketingId'] = $marketing->id;

echo json_encode($_POST);