1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
<?php
$page_settings = array(
'formid' => 'Teacher', // for permission
'section' => 'System Setting', // parent/page title
'subsection' => 'Teacher', // page title
'domain' => 'teacher', // table/model name
'access' => 'GNu', // for permission
);
require_once "check_login.php";
$nowdate = date("Y-m-d H:i:s");
$id = (int)$_GET["id"];
//$sql = "update tutor_main set status=case when status = 3 then 4 else 3 end, lastupdate=?, lastupby=? where id = ?";
$sql = "update tutor_main set approved = 1, approved_date=?, approved_by=? where id = ?";
$parameters = array($nowdate, $_SESSION['cmsloginid'], $id);
bind_pdo($sql, $parameters);
$sql = "SELECT cmsloginid,email,nickname as name,status FROM tutor_main WHERE id=? AND deleted = 0";
$parameters = array($id);
$record_member = bind_pdo($sql, $parameters, "selectone");
//$lang = get_langcode();
$lang = 'cn';
$to = aes_crypt($record_member['email'],2);
$sender_name = $site_info['companyname_'.$lang];
$sender_email = $site_info['enquiryemail'];
//$content_arr = $data;
$content_arr['member_name'] = $record_member['name'];
if($lang == 'en'){
$subject = 'Tutor Modify 【Approved successfully】';
}else if($lang == 'cn'){
$subject = $site_info['companyname_'.$lang].' - 導師資料更新批核狀況';
}
$sql = "select cmsloginname from sys_cms_login as tb
where `cmsloginid` = ? and deleted = ? LIMIT 1";
$parameters = array($record_member['cmsloginid'],0);
$record_cmslogin = bind_pdo($sql, $parameters, "selectone");
$sender_name = $site_info['companyname_'.$lang];
if($lang=='en'){
$content_arr['titlename'] = 'MusicCircle - Tutor Modify 【Approved successfully】';
$content_arr['msg'] = 'Approved successfully';
}else if($lang=='cn'){
$content_arr['titlename'] = 'MusicCircle - 導師資料更新批核狀況';
$content_arr['msg'] = '你好,<br><br>
你的導師資料更新已通過批核，多謝支持MusicCircle。
<br<br>
請登入<a href="www.musiccircle.hk" target="_blank">www.musiccircle.hk</a>繼續享用我們為你提供的服務。
<br><br>
如有任何問題，請電郵至cs@musiccircle.hk跟我們的客戶服務部聯絡。
<br><br>
MusicCircle 客戶服務
';
}
$content_arr['date'] = date('Y-m-d');
$content_arr['time'] = date('H:i:s');
$map_file = '../email/page.html';
$result = sendEmail( $to, $subject, $content_arr, $sender_name, $sender_email, $map_file );
$send = $result ? 'success' : 'fail';
update_approval_list('tutor_main', $id);
insert_notification('TUTOR', 'tutor_main', $id, $record_member['cmsloginid']);
if($_GET['type']=='detail'){
header("Location: teacher_form.php?id=".$id);
}else{
if($record_member['status'] > 2){
$status = 2;
}else if($record_member['status'] <= 2){
$status = 1;
}
header("Location: teacher_index.php?status=".$status."&msg=2");
}
?>
|