/**
* function to delete the Message Templates
*
* @access public
* @static
*
* @return object
*/
static function del($messageTemplatesID)
{
// make sure messageTemplatesID is an integer
if (!CRM_Utils_Rule::positiveInteger($messageTemplatesID)) {
CRM_Core_Error::fatal(ts('Invalid Message template'));
}
// set membership_type to null
$query = "UPDATE civicrm_membership_type\n SET renewal_msg_id = NULL\n WHERE renewal_msg_id = %1";
$params = array(1 => array($messageTemplatesID, 'Integer'));
CRM_Core_DAO::executeQuery($query, $params);
$query = "UPDATE civicrm_mailing\n SET msg_template_id = NULL\n WHERE msg_template_id = %1";
CRM_Core_DAO::executeQuery($query, $params);
$messageTemplates = new CRM_Core_DAO_MessageTemplates();
$messageTemplates->id = $messageTemplatesID;
$messageTemplates->delete();
CRM_Core_Session::setStatus(ts('Selected message templates has been deleted.'));
}
