Newer
Older
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
import("system.translate");
import("system.result");
import("system.vars");
import("Sql_lib");
var channelType = vars.get("$field.CHANNEL_TYPE");
var medium = vars.get("$field.MEDIUM");
var channelId = vars.get("$field.CHANNEL_ID");
var alreadyExistsQuery = new SqlBuilder()
.selectCount()
.from("COMMUNICATIONSETTINGS")
.where("COMMUNICATIONSETTINGS.CONTACT_ID", vars.get("$field.CONTACT_ID"))
.and("COMMUNICATIONSETTINGS.COMMUNICATIONSETTINGSID", vars.get("$field.COMMUNICATIONSETTINGSID"), SqlBuilder.NOT_EQUAL())
.and("COMMUNICATIONSETTINGS.CHANNEL_TYPE", channelType);
if (medium)
{
alreadyExistsQuery.and("COMMUNICATIONSETTINGS.MEDIUM", medium);
}
else
{
alreadyExistsQuery.and("COMMUNICATIONSETTINGS.MEDIUM is null");
}
if (channelId)
{
alreadyExistsQuery.and("COMMUNICATIONSETTINGS.CHANNEL_ID", channelId);
}
else
{
alreadyExistsQuery.and("COMMUNICATIONSETTINGS.CHANNEL_ID is null");
}
if (alreadyExistsQuery.cell() > 0)
{
result.string(translate.text("A communication setting for this channel already exists!"));
}