Pommo_Mailing::delete PHP Method

delete() public method

returns the # of deleted subscribers (int). 0 (false) if none.
public delete ( &$id )
    function delete(&$id)
    {
        $dbo =& Pommo::$_dbo;
        $query = "\n            DELETE\n            FROM " . $dbo->table['mailings'] . "\n            WHERE mailing_id IN(%c)";
        $query = $dbo->prepare($query, array($id));
        $deleted = $dbo->affected($query);
        $query = "\n            DELETE\n            FROM " . $dbo->table['mailing_current'] . "\n            WHERE current_id IN(%c)";
        $query = $dbo->prepare($query, array($id));
        $dbo->query($query);
        $query = "\n            DELETE\n            FROM " . $dbo->table['mailing_notices'] . "\n            WHERE mailing_id IN(%c)";
        $query = $dbo->prepare($query, array($id));
        $dbo->query($query);
        return $deleted;
    }

Usage Example

Example #1
0
        $mailing = current(Pommo_Mailing::get(array('id' => $_REQUEST['mailings'])));
        // change group name to ID
        $groups = Pommo_Groups::getNames();
        $gid = 'all';
        foreach ($groups as $group) {
            if ($group['name'] == $mailing['group']) {
                $gid = $group['id'];
            }
        }
        Pommo_Api::stateReset(array('mailing'));
        // if this is a plain text mailing, switch body + altbody.
        if ($mailing['ishtml'] == 'off') {
            $mailing['altbody'] = $mailing['body'];
            $mailing['body'] = null;
        }
        // Initialize page state with default values overriden by those held in $_REQUEST
        $state =& Pommo_Api::stateInit('mailing', array('fromname' => $mailing['fromname'], 'fromemail' => $mailing['fromemail'], 'frombounce' => $mailing['frombounce'], 'list_charset' => $mailing['charset'], 'mailgroup' => $gid, 'subject' => $mailing['subject'], 'body' => $mailing['body'], 'altbody' => $mailing['altbody']));
        Pommo::redirect(Pommo::$_baseUrl . 'mailings_start.php');
        break;
    case 'delete':
        $deleted = Pommo_Mailing::delete($mailingIDS);
        $logger->addMsg(Pommo::_T('Please Wait') . '...');
        $params = $json->encode(array('ids' => $mailingIDS));
        $view->assign('callbackFunction', 'deleteMailing');
        $view->assign('callbackParams', $params);
        break;
    default:
        $logger->AddErr('invalid call');
        break;
}
$view->display('admin/rpc');