This repository has been archived by the owner on Aug 25, 2020. It is now read-only.
/
ajax.contact.php
145 lines (140 loc) · 4.22 KB
/
ajax.contact.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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php
header("Content-type: application/json");
$project = (int)$_POST['project'];
require_once 'functions.php';
require_once 'functions.omat.php';
$contact = (int)$_POST['contact'];
$source = (int)$_POST['source'];
if ($_POST['action'] == 'addcontact') {
// If this contact already exists, then we just add a lead, but we
// don't repeat adding the same contact again
$name = html(trim($_POST['name']));
$check = $db->record("SELECT * FROM mfa_contacts WHERE dataset = $project AND name = '$name' LIMIT 1");
if (!$check->id) {
$post = array(
'name' => html(trim($_POST['name'])),
'organization' => (int)$_POST['organization'],
'belongs_to' => (int)$_POST['works_for_referral_organization'] ? $contact : NULL,
'dataset' => $project,
'status' => 1,
);
$db->insert("mfa_contacts",$post);
$id = $db->lastInsertId();
} else {
$id = $check->id;
}
$post = array(
'to_contact' => $id,
);
if ($contact) {
$post['from_contact'] = $contact;
} else {
$post['from_source'] = $source;
}
$db->insert("mfa_leads",$post);
$icon = $_POST['organization'] ? 'building-o' : 'user';
$data['response'] = 'OK';
$data['message'] =
"<a class='list-group-item active' href='omat/{$project}/viewcontact/{$id}'>
<i class='fa fa-{$icon}'></i> {$_POST['name']}</a>";
}
if ($_POST['action'] == 'addsource') {
$name = html(trim($_POST['name']));
$check = $db->record("SELECT * FROM mfa_sources WHERE dataset = $project AND name = '$name' LIMIT 1");
if (!$check->id) {
$post = array(
'name' => html(trim($_POST['name'])),
'dataset' => $project,
'status' => 1,
);
$db->insert("mfa_sources",$post);
$id = $db->lastInsertId();
} else {
$id = $check->id;
}
$post = array(
'to_source' => $id,
);
if ($contact) {
$post['from_contact'] = $contact;
} else {
$post['from_source'] = $source;
}
$db->insert("mfa_leads",$post);
$data['response'] = 'OK';
$data['message'] =
"<a class='list-group-item active' href='omat/{$project}/viewsource/{$id}'>{$_POST['name']}</a>";
}
if ($_POST['action'] == 'addactivity') {
$explode = explode(":", $_POST['time']);
if ($explode[1]) {
$time = $explode[0]*60 + $explode[1];
} else {
$time = (int)$_POST['time'];
}
if ($_POST['timer']) {
$post = array(
'activity' => (int)$_POST['type'],
'start' => date("Y-m-d H:i:s"),
);
$icon = '<i class="fa fa-clock-o"></i>';
$min = "<em>ongoing</em>";
} else {
$post = array(
'activity' => (int)$_POST['type'],
'time' => $time,
'end' => date("Y-m-d H:i:s"),
);
$min = "$time min";
}
if ($contact) {
$post['contact'] = $contact;
} else {
$post['source'] = $source;
}
$type = (int)$_POST['type'];
$getname = $db->record("SELECT * FROM mfa_activities WHERE dataset = $project AND id = $type");
$db->insert("mfa_activities_log",$post);
$id = $db->lastInsertId();
$data['response'] = 'OK';
$data['message'] =
"<a class='list-group-item active' href='omat/{$project}/viewactivity/{$id}'>
$icon
{$getname->name} ($min)</a>";
} elseif ($_POST['flag']) {
$flag = (int)$_POST['flag'];
$id = (int)$_POST['id'];
$post = array(
'contact' => $id,
'flag' => $flag,
);
$db->insert("mfa_contacts_flags",$post);
$data['response'] = 'OK';
} elseif ($_POST['belongs_to']) {
$belongs_to = (int)$_POST['belongs_to'];
$id = (int)$_POST['id'];
if ($_POST['contact']) {
$db->query("UPDATE mfa_contacts SET belongs_to = $belongs_to WHERE id = $id AND dataset = $project");
} elseif ($_POST['source']) {
$db->query("UPDATE mfa_sources SET belongs_to = $belongs_to WHERE id = $id AND dataset = $project");
}
$data['response'] = 'OK';
}
// For CT MFA only, can be removed when done.
if ($_POST['nature']) {
$id = (int)$_POST['id'];
$nature = (int)$_POST['nature'];
$db->query("UPDATE mfa_contacts SET folder = $nature WHERE id = $id");
$data['response'] = 'OK';
} elseif ($_POST['success']) {
$id = (int)$_POST['id'];
$success = (int)$_POST['success'];
$db->query("UPDATE mfa_contacts SET success = $success WHERE id = $id");
$data['response'] = 'OK';
}
// End CT block
if (!$data) {
$data['reponse'] = 'Fail';
}
echo json_encode($data);
?>