Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/thietkewebvumi.com/admin_new/mod/ |
<?php
class maillist{
function maillist(){
global $CORE;
$arr_mid = array();
switch($CORE->input['code']){
default : $this->goList(); break;
case 'post': $this->goPost(); break;
case 'del' : $this->goDel($arr_mid); break;
}
}
function goList(){
global $CORE, $DB, $smarty, $print, $func;
$smarty->assign('module_name','Quản lý mail list');
$smarty->assign('title','Mail list');
$smarty->assign('status',$CORE->input['status']);
$smarty->assign('section','list');
$smarty->assign('showsection','list');
$keyword = $CORE->input['keyword'];
$where = ($keyword !="") ? "WHERE email LIKE '%".$keyword."%'" : "";
$r_total = $DB->fetch_row($DB->query("SELECT count(*) as total FROM NNCCMS_maillist ".$where.""));
$total = $r_total['total'];
$pageNum = ($CORE->input['pageNum']>0) ? intval($CORE->input['pageNum']) : 1;
$pageSize = 20;
$from = (($pageNum * $pageSize) - $pageSize);
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM NNCCMS_maillist ".$where." LIMIT $from, $pageSize");
while($row = $DB->fetch_row($query)){
$row['joined'] = date('d/m/Y',$row['joined']);
$list[] = $row;
}
$smarty->assign('list',$list);
$nav = $print->Pagination($totalPage,$pageNum,'maillist','index.php?act=maillist&fkeyword='.$CORE->input['fkeyword']);
$smarty->assign('nav',$nav);
$content = $func->editor_jquery('content','','10','tinymce');
$smarty->assign('content',$content);
$arr_mid = $CORE->input['mid_for_del'];
if(!empty($arr_mid)){
$type = $CORE->input['type'];
switch($type){
case 'del':
$this->goDel($arr_mid);
break;
default://send mail
$subject = $CORE->input['subject'];
$content = $CORE->input['content'];
include("lib/class.phpmailer.php");
$mail = new PHPMailer();
$mail->CharSet = 'utf-8';
$mail->IsSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = "ssl";
$mail->Host = "smtp.gmail.com";
$mail->Port = "465";
$mail->Username = "admin@duhoc-o-canada.com";
$mail->Password = "duhoc0canada";
$mail->FromName = $CORE->vars['sitename'];
$mail->Subject = $subject;
$mail->WordWrap = 50;
$mail->MsgHTML($content);
if(!empty($arr_mid)){
foreach($arr_mid as $val){
$row_check = $DB->fetch_row($DB->query("SELECT email FROM NNCCMS_maillist WHERE id = '$val'"));
$arr_email[] = $row_check['email'];
}
}
$list_email = implode(',',$arr_email);
$mail->AddAddress($list_email);
$mail->IsHTML(true);
if(!$mail->Send()) {
$print->page_error('Không thể gởi email!','index.php?act=maillist');
exit();
} else {
$print->refresh('index.php?act=maillist&status=add_success');
}
break;
}
}
}
function goPost(){
global $CORE, $DB, $print;
if(!$CORE->input['submitbt']){
}else{
$postemail = $CORE->input['postemail'];
$query = $DB->query("SELECT * FROM NNCCMS_maillist WHERE `email`='".$postemail."'");
if($DB->get_num_rows($query)>0){
$_SESSION['error'] = 1;
$_SESSION['state'] = $postemail;
return $this->goList();
}else{
if($CORE->input['postid']>0){
$DB->query("UPDATE `NNCCMS_maillist` SET `email` = '$postemail' WHERE `id`='".$CORE->input['postid']."'");
$print->redirect ('Đã cập nhật',$CORE->admin_url.'&act=maillist');
}else{
$DB->query("INSERT INTO `NNCCMS_maillist`(`id`,`email`,`joined`,`ip_address`,`regcode`,`notes`)
VALUES('','".$postemail."','".$CORE->time."','".$CORE->ip."','','');");
$print->redirect ('Đã thêm mới',$CORE->admin_url.'&act=maillist');
}
}
}
}
function goDel($arr_id){
global $CORE, $DB, $print;
if($CORE->admin_user['ug_id']!=4) exit('Chỉ có admin mới có quyền xóa bài!...');
if(empty($arr_id)){
$id = intval($CORE->input['id']);
$DB->query("DELETE FROM NNCCMS_maillist WHERE id='$id'");
$print->refresh("index.php?act=maillist&status=del_success");
exit();
}else{
foreach($arr_id as $val){
$DB->query("DELETE FROM NNCCMS_maillist WHERE id='$val'");
}
}
$print->refresh("index.php?act=maillist&status=del_success");
}
}
$run = new maillist();
?>