-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert.php
124 lines (108 loc) · 4.39 KB
/
insert.php
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
error_reporting(1);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
include_once('db.php');
include_once('./twilio_config.php');
require_once 'vendor/autoload.php';
use SignalWire\Rest\Client;
$client = new Client(SID, TOKEN, array("signalwireSpaceUrl" => SIGNALWIREURL) );
if (isset($_POST["operation"])) {
if ($_POST["action"] == "Add") {
$statement = $connection->prepare("
INSERT INTO member (name, email, phone, created_date)
VALUES (:name, :email, :phone, :created_date)
");
$result = $statement->execute(
array(
':name' => $_POST["name"],
':email' => $_POST["email"],
':phone' => $_POST["phone"],
':created_date' => date("Y-m-d H:i:s"),
)
);
if (!empty($result)) {
echo 'Data Inserted Successfully';
}
}
if ($_POST["action"] == "Update") {
$statement = $connection->prepare(
"UPDATE member
SET name = :name, email = :email, phone = :phone, modify_date = :modify_date , is_active = :status, get_call = :iscall
WHERE uid = :uid
"
);
$result = $statement->execute(
array(
':name' => $_POST["name"],
':email' => $_POST["email"],
':phone' => $_POST["phone"],
':status' => $_POST["status"],
':iscall' => $_POST["get_call"],
':modify_date' => date("Y-m-d H:i:s"),
':uid' => $_POST["user_id"]
)
);
if (!empty($result)) {
echo 'Data Updated Successfully';
}
}
if ($_POST["operation"] == "Send") {
$check_status = $_POST['status'];
try {
if ($check_status == 'active') { // For active user
$stmt = $connection->prepare("SELECT * FROM member WHERE is_active = :active ");
$stmt->execute(array(':active' => "Y"));
} elseif ($check_status == 'inactive') { // for In active User
$stmt = $connection->prepare("SELECT * FROM member WHERE is_active = :active ");
$stmt->execute(array(':active' => "N"));
} elseif ($check_status == 'get_call') { // user who responed YES today
$stmt = $connection->prepare("SELECT * FROM reply WHERE LOWER(`reply_msg`) = :msg AND created_date >= :today");
$stmt->execute(array(':msg' => strtolower("yes"), ':today' => date("Y-m-d") . ' 00:00:00'));
} else { // For all user
$stmt = $connection->prepare("SELECT * FROM member");
$stmt->execute();
}
} catch (Exception $ex) {
echo $ex->getMessage() . "<br />";
}
$all_users = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($all_users as $user) {
try {
if ($check_status == 'get_call') {
$phone_number = $user['m_from'];
} else {
$phone_number = $user['phone'];
}
$twilio_msg = $client->messages->create(
$phone_number, array(
'from' => FROM_NUMBER,
'body' => $_POST["smstext"],
)
);
$statement = $connection->prepare("
INSERT INTO send_sms (sms_sid, body, m_to, m_from, date_created, date_modified)
VALUES (:sms_sid, :body, :m_to, :m_from, :date_created, :date_modified)
");
$result = $statement->execute(
array(
':sms_sid' => $twilio_msg->sid,
':body' => $twilio_msg->body,
':m_to' => $twilio_msg->to,
':m_from' => $twilio_msg->from,
':date_created' => date("Y-m-d H:i:s"),
':date_modified' => date("Y-m-d H:i:s")
)
);
} catch (Exception $ex) {
echo $ex->getMessage() . "<br />";
}
}
echo "Message sent successfully.";
}
}
if (isset($_POST['logout'])) {
session_destroy();
session_unset();
header("Location: " . BASE_URL . "login.php");
}