<?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'));}
}