561 lines
27 KiB
PHP
561 lines
27 KiB
PHP
<?php
|
|
namespace SAI;
|
|
class saimod_mail extends \SYSTEM\SAI\sai_module{
|
|
const EMAILLIST_TEST = 1;
|
|
|
|
const EMAIL_PLACEHOLDER_TYPE_TEXT = 1;
|
|
const EMAIL_PLACEHOLDER_TYPE_SWITCH = 2;
|
|
const EMAIL_PLACEHOLDER_TYPE_NAME = 3;
|
|
|
|
public static function subscribe($email,$list){
|
|
return \SQL\SUBSCRIBE::QI(array($email,$list));
|
|
}
|
|
|
|
public static function contact($email,$sex=null,$name_first=null,$name_last=null){
|
|
return \SQL\CONTACT_INSERT_EMAIL_NAME::QI(array($email,$sex,$name_first,$name_last));
|
|
}
|
|
|
|
public static function send_mail($email,$email_id,$list=null,$resend=false,$data=[],$replyto=null){
|
|
\LIB\lib_mail_cannon::php();
|
|
|
|
// Prevent Double send
|
|
if(!$resend && $list != self::EMAILLIST_TEST){
|
|
$sent = \SQL\EMAIL_SENT_IS_SENT::Q1(array($email_id,$email));
|
|
if($sent['count'] > 0){
|
|
return false;}
|
|
}
|
|
|
|
$contact_data = \SQL\CONTACT_SELECT::Q1(array($email));
|
|
$email_data = \SQL\EMAIL_SELECT::Q1(array($email_id));
|
|
$template_text = \SQL\EMAIL_TEMPLATE_SELECT::Q1(array($email_data['template_text']));
|
|
$template_html = \SQL\EMAIL_TEMPLATE_SELECT::Q1(array($email_data['template_html']));
|
|
$placeholders_qq= \SQL\EMAIL_PLACEHOLDER_SELECT_EMAIL::QQ(array($email_id));
|
|
$images_qq = \SQL\EMAIL_IMAGE_SELECT_EMAIL::QQ(array($email_id));
|
|
|
|
$smtp = \SQL\EMAIL_ACCOUNT_SELECT::Q1(array($email_data['account']));
|
|
if(!$smtp){
|
|
throw new \SYSTEM\LOG\ERROR('No EMail Account selected');
|
|
}
|
|
|
|
$replacements = [];
|
|
while($placeholder = $placeholders_qq->next()){
|
|
switch($placeholder['type']){
|
|
case self::EMAIL_PLACEHOLDER_TYPE_TEXT:
|
|
$value = json_decode($placeholder['data'],true)['value'];
|
|
$value = str_replace('\\n', "\n", $value);
|
|
$replacements[$placeholder['name']] = $value;
|
|
break;
|
|
case self::EMAIL_PLACEHOLDER_TYPE_SWITCH:
|
|
$data = json_decode($placeholder['data'],true);
|
|
$d = null;
|
|
switch($data['table']){
|
|
case 'contact':
|
|
$d = $contact_data[$data['field']];
|
|
break;
|
|
}
|
|
$value = $data['default'];
|
|
foreach($data['values'] as $k => $v){
|
|
if($d == $k){
|
|
$value = $v;}
|
|
}
|
|
$replacements[$placeholder['name']] = $value;
|
|
break;
|
|
case self::EMAIL_PLACEHOLDER_TYPE_NAME:
|
|
$value = json_decode($placeholder['data'],true)['default'];
|
|
if($contact_data['name_first'] || $contact_data['name_last']){
|
|
$value = trim($contact_data['name_first'].' '.$contact_data['name_last']);
|
|
}
|
|
$replacements[$placeholder['name']] = $value;
|
|
break;
|
|
}
|
|
}
|
|
$replacements['emoji_mobile'] = '📱';
|
|
foreach($data as $k => $v){
|
|
$replacements['data_'.$k] = $v;}
|
|
if($contact_data){
|
|
foreach($contact_data as $k => $v){
|
|
$replacements['contact_'.$k] = $v;}
|
|
}
|
|
if($list){
|
|
$replacements['unsubscribe_link'] = \SYSTEM\CONFIG\config::get(\SYSTEM\CONFIG\config_ids::SYS_CONFIG_PATH_BASEURL).
|
|
'#!unsubscribe;token.'.
|
|
\SYSTEM\TOKEN\token::request( 'token_saimod_mail_unsubscribe',
|
|
array( 'email' => $email,'list' => $list),
|
|
true);
|
|
}
|
|
$to = $email;
|
|
$from = \SYSTEM\PAGE\replace::replace($email_data['sender'],$replacements);
|
|
$subject = \SYSTEM\PAGE\replace::replace($email_data['subject'],$replacements);
|
|
$text = \SYSTEM\PAGE\replace::replace($template_text['value'], $replacements);
|
|
$html = \SYSTEM\PAGE\replace::replace($template_html['value'], $replacements);
|
|
|
|
$images = [];
|
|
while($image = $images_qq->next()){
|
|
$images[$image['name']] = [ 'file' => (new \PSAI('saimod_mail/files/'.$image['file']))->SERVERPATH(),
|
|
'mime' => $image['mime']];
|
|
}
|
|
//TODO
|
|
$attachments = [];
|
|
|
|
try {
|
|
$sent = \mailcannon::send( $smtp,
|
|
$from, $to, 'democracy-deutschland.de',
|
|
$subject, $text, $html,
|
|
$images, $attachments);
|
|
} catch(\Exception $e) {
|
|
$sent = false;
|
|
}
|
|
if($list != self::EMAILLIST_TEST){
|
|
\SQL\EMAIL_SENT_INSERT::QI(array($email_id,$email));}
|
|
|
|
return $sent ? true : false;
|
|
}
|
|
|
|
public static function send_list($email_id,$list){
|
|
$list_handle = \SQL\CONTACT_EMAIL_LIST_SELECT_LIST::QA(array($email_id,$list));
|
|
foreach($list_handle as $row){
|
|
\set_time_limit(30);
|
|
self::send_mail($row['email'], $email_id, $list);
|
|
\sleep(1);
|
|
}
|
|
return \SYSTEM\LOG\JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail(){
|
|
$vars = array();
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_overview(){
|
|
$vars = array();
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_overview.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_contacts($search='%',$page=0,$list=null){
|
|
$vars = array();
|
|
$vars['list'] = $list;
|
|
$vars['search'] = $search;
|
|
$vars['page'] = $page;
|
|
//menu
|
|
$vars['menu'] = '';
|
|
$vars['active_all'] = $list ? '' : 'active';
|
|
$res = \SQL\EMAIL_LISTS_SELECT::QQ();
|
|
while($row = $res->next()){
|
|
$row['active'] = $row['id'] == $list ? 'active' : '';
|
|
$row['search'] = $search;
|
|
$vars['menu'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contacts_menu.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
|
|
//data
|
|
$vars['data'] = '';
|
|
if($list){
|
|
$res = \SQL\CONTACTS_SELECT_LIST::QQ(array($list,$search,$search,$search,$search));
|
|
$count = \SQL\CONTACTS_COUNT_LIST::Q1(array($list,$search,$search,$search,$search))['count'];
|
|
} else {
|
|
$res = \SQL\CONTACTS_SELECT::QQ(array($search,$search,$search,$search));
|
|
$count = \SQL\CONTACTS_COUNT::Q1(array($search,$search,$search,$search))['count'];
|
|
}
|
|
$res->seek(25*$page);
|
|
$count_filtered = 0;
|
|
while(($row = $res->next()) && ($count_filtered < 25)){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contacts_tr.tpl'))->SERVERPATH(),$row);
|
|
$count_filtered++;
|
|
}
|
|
// Pagintation
|
|
$vars['pagination'] = '';
|
|
$vars['page_last'] = floor($count/25);
|
|
for($i=0;$i < ceil($count/25);$i++){
|
|
$data = array('page' => $i,'search' => $search, 'list' => $list, 'active' => ($i == $page) ? 'active' : '');
|
|
$vars['pagination'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contacts_pagination.tpl'))->SERVERPATH(), $data);
|
|
}
|
|
$vars['count'] = ($count_filtered+$page*25).'/'.$count;
|
|
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contacts.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_contact($email){
|
|
$vars = \SQL\CONTACT_SELECT::Q1(array($email));
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\EMAIL_LISTS_SELECT_CONTACT::QQ(array($email));
|
|
while($row = $res->next()){
|
|
$row['checked'] = $row['list'] ? 'checked' : '';
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contact_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contact.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_contact_new(){
|
|
$vars = array();
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\EMAIL_LISTS_SELECT::QQ();
|
|
while($row = $res->next()){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contact_new_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_contact_new.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_update_contact($data){
|
|
\SQL\CONTACT_UPDATE::QI(array($data['sex'],$data['name_first'],$data['name_last'],$data['organization'],$data['email']));
|
|
foreach($data['email_lists'] as $list){
|
|
if($list['subscribed']){
|
|
self::subscribe($data['email'],$list['id']);
|
|
} else {
|
|
\SQL\UNSUBSCRIBE::QI(array($data['email'],$list['id']));
|
|
}
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_insert_contact($data){
|
|
if($data['email'] == ''){
|
|
throw new \SYSTEM\LOG\ERROR('Please provide an EMail');
|
|
}
|
|
\SQL\CONTACT_INSERT::QI(array($data['email'],$data['sex'],$data['name_first'],$data['name_last'],$data['organization']));
|
|
foreach($data['email_lists'] as $list){
|
|
if($list['subscribed']){
|
|
\SQL\SUBSCRIBE::QI(array($data['email'],$list['id']));
|
|
} else {
|
|
\SQL\UNSUBSCRIBE::QI(array($data['email'],$list['id']));
|
|
}
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_delete_contact($data){
|
|
foreach($data as $email){
|
|
\SQL\CONTACT_DELETE::QI(array($email));
|
|
\SQL\CONTACT_EMAIL_LIST_DELETE::QI(array($email));
|
|
\SQL\EMAIL_SENT_DELETE::QI(array($email));
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_lists(){
|
|
$vars = array();
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\EMAIL_LISTS_SELECT_COUNT::QQ();
|
|
while($row = $res->next()){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_lists_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_lists.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_list($id){
|
|
$vars = \SQL\EMAIL_LIST_SELECT::Q1(array($id));
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\CONTACT_EMAIL_LIST_CONTACT_SELECT::QQ(array($id));
|
|
while($row = $res->next()){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_list_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_list.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_list_new(){
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_list_new.tpl'))->SERVERPATH());
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_update_list($data){
|
|
\SQL\LIST_UPDATE::QI(array($data['name'],$data['id']));
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_insert_list($data){
|
|
\SQL\EMAIL_LIST_INSERT::QI(array($data['name']));
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_delete_list($data){
|
|
foreach($data as $id){
|
|
\SQL\EMAIL_LIST_DELETE::QI(array($id));
|
|
\SQL\CONTACT_EMAIL_LIST_DELETE_LIST::QI(array($id));
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_emails(){
|
|
$vars = array();
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\EMAILS_SELECT::QQ();
|
|
while($row = $res->next()){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_emails_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_emails.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_email($id){
|
|
$vars = \SQL\EMAIL_SELECT::Q1(array($id));
|
|
$vars['template_lock'] = $vars['system_lock'] ? 'disabled' : '';
|
|
$vars['account_options'] = '';
|
|
$res = \SQL\EMAIL_ACCOUNTS_SELECT::QQ();
|
|
while($row = $res->next()){
|
|
$row['selected'] = $row['email'] == $vars['account'] ? 'selected' : '';
|
|
$vars['account_options'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_account_option.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//text template
|
|
$vars['text_options'] = '';
|
|
$res = \SQL\EMAIL_TEMPLATES_SELECT::QQ(array(0));
|
|
while($row = $res->next()){
|
|
$row['selected'] = $row['id'] == $vars['template_text'] ? 'selected' : '';
|
|
$vars['text_options'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_template_option.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//html template
|
|
$vars['html_options'] = '';
|
|
$res = \SQL\EMAIL_TEMPLATES_SELECT::QQ(array(1));
|
|
while($row = $res->next()){
|
|
$row['selected'] = $row['id'] == $vars['template_html'] ? 'selected' : '';
|
|
$vars['html_options'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_template_option.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//placeholders
|
|
$vars['placeholders'] = '';
|
|
$res = \SQL\EMAIL_PLACEHOLDER_SELECT_EMAIL::QQ(array($id));
|
|
while($row = $res->next()){
|
|
$data = json_decode($row['data'],true);
|
|
$row['selected_1'] = $row['selected_2'] = $row['selected_3'] = '';
|
|
$row['selected_'.$row['type']] = 'selected';
|
|
$row['new_placeholder'] = '';
|
|
$row['text_value'] = $row['type'] == self::EMAIL_PLACEHOLDER_TYPE_TEXT ? $data['value'] : '';
|
|
$row['name_default'] = $row['type'] == self::EMAIL_PLACEHOLDER_TYPE_NAME ? $data['default'] : '';
|
|
$row['switch_table'] = $row['type'] == self::EMAIL_PLACEHOLDER_TYPE_SWITCH ? $data['table'] : '';
|
|
$row['switch_field'] = $row['type'] == self::EMAIL_PLACEHOLDER_TYPE_SWITCH ? $data['field'] : '';
|
|
$row['switch_default'] = $row['type'] == self::EMAIL_PLACEHOLDER_TYPE_SWITCH ? $data['default'] : '';
|
|
$row['switch_values'] = '';
|
|
if($row['type'] == self::EMAIL_PLACEHOLDER_TYPE_SWITCH){
|
|
if(!array_key_exists('values', $data)){
|
|
$data['values'] = [];
|
|
}
|
|
foreach($data['values'] as $k=>$v){
|
|
$d = ['k' => $k, 'v' => $v, 'new_switch_value' => ''];
|
|
$row['switch_values'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_placeholder_switch_value.tpl'))->SERVERPATH(),$d);
|
|
}
|
|
$d = ['k' => '', 'v' => '', 'new_switch_value' => 'email-placeholder-switch-value-new'];
|
|
$row['switch_values'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_placeholder_switch_value.tpl'))->SERVERPATH(),$d);
|
|
}
|
|
//new value
|
|
$vars['placeholders'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_placeholder.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//placeholder new
|
|
$new_placeholder = ['id' => '',
|
|
'selected_1' => 'selected', 'selected_2' => '', 'selected_3' => '',
|
|
'name' => '',
|
|
'text_value' => '', 'name_default' => '',
|
|
'switch_table' => '', 'switch_field' => '', 'switch_default' => '',
|
|
'new_placeholder' => 'email-placeholder-new'];
|
|
$d = ['k' => '', 'v' => '', 'new_switch_value' => 'email-placeholder-switch-value-new'];
|
|
$new_placeholder['switch_values'] = \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_placeholder_switch_value.tpl'))->SERVERPATH(),$d);
|
|
$vars['placeholders'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_placeholder.tpl'))->SERVERPATH(),$new_placeholder);
|
|
|
|
//files
|
|
$files = \SYSTEM\FILES\files::get('email');
|
|
//images
|
|
$vars['images'] = '';
|
|
$res = \SQL\EMAIL_IMAGE_SELECT_EMAIL::QQ(array($id));
|
|
while($row = $res->next()){
|
|
$row['files'] = '';
|
|
$row['new_image'] = '';
|
|
foreach($files as $file){
|
|
$f = ['name' => $file, 'selected' => $row['file'] == $file ? 'selected' : ''];
|
|
$row['files'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_image_file.tpl'))->SERVERPATH(),$f);
|
|
}
|
|
$vars['images'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_image.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//image new
|
|
$new_image = ['name' => '', 'id' => '', 'mime' => 'image/png', 'files' => '', 'new_image' => 'email-image-new'];
|
|
foreach($files as $file){
|
|
$f = ['name' => $file, 'selected' => ''];
|
|
$new_image['files'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_image_file.tpl'))->SERVERPATH(),$f);
|
|
}
|
|
$vars['images'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_image.tpl'))->SERVERPATH(),$new_image);
|
|
//send
|
|
$vars['send'] = '';
|
|
$res = \SQL\EMAIL_LISTS_SELECT_AND_SENT_COUNT::QQ(array($id));
|
|
while($row = $res->next()){
|
|
$row['disabled'] = $row['id'] == self::EMAILLIST_TEST ? '' : 'disabled';
|
|
$row['btn-color'] = $row['id'] == self::EMAILLIST_TEST ? 'success' : 'danger';
|
|
$row['email'] = $id;
|
|
$vars['send'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_send.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_email_new(){
|
|
//text template
|
|
$vars['text_options'] = '';
|
|
$res = \SQL\EMAIL_TEMPLATES_SELECT::QQ(array(0));
|
|
while($row = $res->next()){
|
|
$row['selected'] = '';
|
|
$vars['text_options'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_template_option.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
//html template
|
|
$vars['html_options'] = '';
|
|
$res = \SQL\EMAIL_TEMPLATES_SELECT::QQ(array(1));
|
|
while($row = $res->next()){
|
|
$row['selected'] = '';
|
|
$vars['html_options'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_template_option.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_email_new.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_send_email($data){
|
|
//Send early response & end Call since it will take longer then the timeout
|
|
ignore_user_abort(true);
|
|
ob_start();
|
|
echo \SYSTEM\LOG\JsonResult::ok();
|
|
header(filter_input(INPUT_SERVER, 'SERVER_PROTOCOL', FILTER_SANITIZE_STRING) . ' 200 OK');
|
|
header('Content-Length: '.ob_get_length());
|
|
header('Connection: close');
|
|
ob_end_flush();
|
|
ob_flush();
|
|
flush();
|
|
if(session_id()){
|
|
session_write_close();}
|
|
if (is_callable('fastcgi_finish_request')) {
|
|
fastcgi_finish_request();}
|
|
|
|
//Start Process
|
|
self::send_list($data['email'],$data['list']);
|
|
|
|
//Make sure we dont have stray processes?
|
|
die();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_update_email($data){
|
|
\SQL\EMAIL_UPDATE::QI(array($data['name'],$data['account'],$data['sender'],$data['subject'],$data['text_template'],$data['html_template'],$data['id']));
|
|
if(array_key_exists('images', $data)){
|
|
foreach($data['images'] as $image){
|
|
if($image['deleted'] && $image['id']){
|
|
\SQL\EMAIL_IMAGE_DELETE::QI(array($data['id'],$image['id']));
|
|
} else if($image['id']){
|
|
\SQL\EMAIL_IMAGE_UPDATE::QI(array($image['name'],$image['file'],$image['mime'],$data['id'],$image['id']));
|
|
} else if(!$image['deleted']){
|
|
\SQL\EMAIL_IMAGE_INSERT::QI(array($image['id'],$data['id'],$image['name'],$image['file'],$image['mime']));
|
|
}
|
|
}
|
|
}
|
|
if(array_key_exists('placeholders', $data)){
|
|
foreach($data['placeholders'] as $placeholder){
|
|
if($placeholder['deleted'] && $placeholder['id']){
|
|
\SQL\EMAIL_PLACEHOLDER_DELETE::QI(array($data['id'],$placeholder['id']));
|
|
} else if($placeholder['id']){
|
|
\SQL\EMAIL_PLACEHOLDER_UPDATE::QI(array($placeholder['name'],$placeholder['type'],json_encode($placeholder['data']),$data['id'],$placeholder['id']));
|
|
} else if(!$placeholder['deleted']){
|
|
\SQL\EMAIL_PLACEHOLDER_INSERT::QI(array($placeholder['id'],$data['id'],$placeholder['name'],$placeholder['type'],json_encode($placeholder['data'])));
|
|
}
|
|
}
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_insert_email($data){
|
|
\SQL\EMAIL_INSERT::QI(array($data['name'],$data['account'],$data['sender'],$data['subject'],$data['text_template'],$data['html_template']));
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_delete_email($data){
|
|
foreach($data as $id){
|
|
\SQL\EMAIL_DELETE::QI(array($id));
|
|
\SQL\EMAIL_SENT_DELETE_EMAIL::QI(array($id));
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_clone_email($data){
|
|
foreach($data as $id){
|
|
$new_id = \SQL\EMAIL_CLONE::QI(array($id),true);
|
|
\SQL\EMAIL_PLACEHOLDER_CLONE::QI(array($new_id,$id));
|
|
\SQL\EMAIL_IMAGE_CLONE::QI(array($new_id,$id));
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_templates($type=0){
|
|
$vars = array();
|
|
$vars['active_text'] = $type == 0 ? 'active' : '';
|
|
$vars['active_html'] = $type == 1 ? 'active' : '';
|
|
//data
|
|
$vars['data'] = '';
|
|
$res = \SQL\EMAIL_TEMPLATES_SELECT::QQ(array($type));
|
|
while($row = $res->next()){
|
|
$vars['data'] .= \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_templates_tr.tpl'))->SERVERPATH(),$row);
|
|
}
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_templates.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_template($id){
|
|
$vars = \SQL\EMAIL_TEMPLATE_SELECT::Q1(array($id));
|
|
$vars['selected_text'] = $vars['type'] == 0 ? 'selected' : '';
|
|
$vars['selected_html'] = $vars['type'] == 1 ? 'selected' : '';
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_template.tpl'))->SERVERPATH(),$vars);
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_template_new(){
|
|
return \SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/saimod_mail_template_new.tpl'))->SERVERPATH());
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_update_template($data){
|
|
\SQL\EMAIL_TEMPLATE_UPDATE::QI(array($data['type'],$data['name'],$data['value'],$data['id']));
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_insert_template($data){
|
|
\SQL\EMAIL_TEMPLATE_INSERT::QI(array($data['type'],$data['name'],$data['value']));
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_delete_template($data){
|
|
foreach($data as $id){
|
|
\SQL\EMAIL_TEMPLATE_DELETE::QI(array($id));
|
|
}
|
|
return \JsonResult::ok();
|
|
}
|
|
|
|
public static function sai_mod__SAI_saimod_mail_action_csvimport($list){
|
|
$handle = fopen($_FILES['datei']['tmp_name'],'r');
|
|
while ( ($data = fgetcsv($handle,0,';') ) !== FALSE ) {
|
|
$email = $data[0];
|
|
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
|
|
continue;}
|
|
$db = \SQL\CONTACT_SELECT::Q1(array($email));
|
|
$sex = $db ? $db['sex'] : null;
|
|
if(count($data) >= 2 && $data[1]){
|
|
$sex = $data[1];
|
|
}
|
|
$name_first = $db ? $db['name_first'] : null;
|
|
if(count($data) >= 3 && $data[2]){
|
|
$name_first = $data[2];
|
|
}
|
|
$name_last = $db ? $db['name_last'] : null;
|
|
if(count($data) >= 4 && $data[3]){
|
|
$name_last = $data[3];
|
|
}
|
|
$organization = $db ? $db['organization'] : null;
|
|
if(count($data) >= 5 && $data[4]){
|
|
$organization = $data[4];
|
|
}
|
|
|
|
if($db){
|
|
\SQL\CONTACT_UPDATE::QI(array($sex,$name_first,$name_last,$organization,$email));
|
|
} else {
|
|
\SQL\CONTACT_INSERT::QI(array($email,$sex,$name_first,$name_last,$organization));
|
|
}
|
|
|
|
\SQL\SUBSCRIBE::QI(array($email,$list));
|
|
}
|
|
}
|
|
|
|
public static function menu(){
|
|
return new \SYSTEM\SAI\sai_module_menu( 101,
|
|
\SYSTEM\SAI\sai_module_menu::POISITION_LEFT,
|
|
\SYSTEM\SAI\sai_module_menu::DIVIDER_NONE,
|
|
\SYSTEM\PAGE\replace::replaceFile((new \PSAI('saimod_mail/tpl/menu.tpl'))->SERVERPATH()));}
|
|
public static function right_public(){return false;}
|
|
public static function right_right(){return \SYSTEM\SECURITY\security::check(\SYSTEM\SECURITY\RIGHTS::SYS_SAI);}
|
|
|
|
public static function js(){
|
|
return array(new \PSAI('saimod_mail/js/saimod_mail.js'));}
|
|
} |