function getTemplateInfo()
{
header("Content-Type: text/plain; charset=UTF-8");
jincimport('core.messagefactory');
jincimport('utility.jsonresponse');
$tem_id = JRequest::getInt('id', 0);
$minstance = MessageFactory::getInstance();
if (!($template = $minstance->loadTemplate($tem_id))) {
$template = new MessageTemplate(0);
}
// Building JSON response
$response = new JSONResponse();
$response->set('subject', $template->get('subject'));
$response->set('body', $template->get('body'));
echo $response->toString();
}
function getDefaultTemplate()
{
header("Content-Type: text/plain; charset=UTF-8");
jincimport('core.newsletterfactory');
jincimport('utility.jsonresponse');
jincimport('utility.jinchtmlhelper');
$id = JRequest::getInt('id', 0);
$tem_id = 0;
$tag_string = '';
$ninstance = NewsletterFactory::getInstance();
if ($newsletter = $ninstance->loadNewsletter($id, false)) {
$tem_id = $newsletter->get('default_template');
}
// Building JSON response
$response = new JSONResponse();
$response->set('tem_id', (int) $tem_id);
echo $response->toString();
}
function removeAttribute($attr_name)
{
jincimport('utility.servicelocator');
jincimport('utility.jsonresponse');
$servicelocator = ServiceLocator::getInstance();
$logger = $servicelocator->getLogger();
$response = new JSONResponse();
if (strlen($attr_name) == 0) {
$response->set('status', -1);
$response->set('errcode', 'COM_JINC_ERR044');
$response->set('errmsg', JText::_('COM_JINC_ERR044'));
return $response->toString();
}
$dbo =& JFactory::getDBO();
$attr_name_db = $dbo->escape($attr_name);
$query = 'SELECT name FROM #__jinc_newsletter ' . 'WHERE attribs LIKE ' . $dbo->quote('%' . $attr_name_db . '%', false);
$dbo->setQuery($query);
$logger->debug('JINCModelAttributes: Executing query: ' . $query);
$result = $dbo->loadAssoc();
if ($result == null) {
$query = 'DROP TABLE IF EXISTS `#__jinc_attribute_' . $attr_name_db . '`';
$logger->debug('JINCModelAttributes: Executing query: ' . $query);
$dbo->setQuery($query);
if (!$dbo->query()) {
$response->set('status', -1);
$response->set('errcode', 'COM_JINC_ERR046');
$response->set('errmsg', JText::_('COM_JINC_ERR046'));
return $response->toString();
}
$query = 'DELETE FROM #__jinc_attribute ' . 'WHERE name = ' . $dbo->quote($attr_name_db, false);
$logger->debug('JINCModelAttributes: Executing query: ' . $query);
$dbo->setQuery($query);
if ($dbo->query()) {
$response->set('status', 0);
$this->storeAttributeForm();
} else {
$response->set('status', -1);
$response->set('errcode', 'COM_JINC_ERR046');
$response->set('errmsg', JText::_('COM_JINC_ERR046'));
}
} else {
$response->set('status', -1);
$response->set('errcode', 'COM_JINC_ERR045');
$response->set('errmsg', JText::_('COM_JINC_ERR045') . ' ' . $result['name']);
}
return $response->toString();
}
function deleteReport($proc_id)
{
jincimport('core.messagefactory');
jincimport('utility.jsonresponse');
jincimport('utility.servicelocator');
$servicelocator = ServiceLocator::getInstance();
$logger = $servicelocator->getLogger();
$response = new JSONResponse();
$minstance = MessageFactory::getInstance();
if ($minstance->deleteReport($proc_id)) {
$response->set('status', 0);
} else {
$response->set('status', -1);
}
$logger->debug('JSON: ' . $response->toString());
return $response->toString();
}
