forked from edwardjrp/license_manager
/
licensing_list_events.php
executable file
·169 lines (142 loc) · 5.77 KB
/
licensing_list_events.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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
<?php
// //Events @1-F81417CB
//licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow @9-920D98BC
function licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow(& $sender)
{
$licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow
//Retrieve number of records @10-ABE656B4
$Component->SetValue($Container->DataSource->RecordsCount);
//End Retrieve number of records
//Close licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow @9-7F78D83F
return $licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow;
}
//End Close licensing_list_alm_customers_alm_customers_TotalRecords_BeforeShow
//licensing_list_alm_customers_custid_BeforeShow @17-8E3C4D8C
function licensing_list_alm_customers_custid_BeforeShow(& $sender)
{
$licensing_list_alm_customers_custid_BeforeShow = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_custid_BeforeShow
//DLookup @18-1046A5AB
global $DBdbConnection;
$Page = CCGetParentPage($sender);
$ccs_result = CCDLookUp("contact", "alm_customers_contacts", "customer_id =".$sender->GetValue()." and maincontact = 1 limit 1", $Page->Connections["dbConnection"]);
$Component->SetValue($ccs_result);
//End DLookup
//Close licensing_list_alm_customers_custid_BeforeShow @17-1254F363
return $licensing_list_alm_customers_custid_BeforeShow;
}
//End Close licensing_list_alm_customers_custid_BeforeShow
//licensing_list_alm_customers_assigned_to_BeforeShow @19-6027F8B8
function licensing_list_alm_customers_assigned_to_BeforeShow(& $sender)
{
$licensing_list_alm_customers_assigned_to_BeforeShow = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_assigned_to_BeforeShow
//DLookup @20-6B2D8B96
global $DBdbConnection;
$Page = CCGetParentPage($sender);
$ccs_result = CCDLookUp("fullname", "alm_users", "id = ".$sender->GetValue(), $Page->Connections["dbConnection"]);
$Component->SetValue($ccs_result);
//End DLookup
//Close licensing_list_alm_customers_assigned_to_BeforeShow @19-E44DA586
return $licensing_list_alm_customers_assigned_to_BeforeShow;
}
//End Close licensing_list_alm_customers_assigned_to_BeforeShow
//licensing_list_alm_customers_city_BeforeShow @21-E21BF43F
function licensing_list_alm_customers_city_BeforeShow(& $sender)
{
$licensing_list_alm_customers_city_BeforeShow = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_city_BeforeShow
//DLookup @22-F591DF25
global $DBdbConnection;
$Page = CCGetParentPage($sender);
$ccs_result = CCDLookUp("city", "alm_city", "id = ".$sender->getValue(), $Page->Connections["dbConnection"]);
$Component->SetValue($ccs_result);
//End DLookup
//Close licensing_list_alm_customers_city_BeforeShow @21-C38C102A
return $licensing_list_alm_customers_city_BeforeShow;
}
//End Close licensing_list_alm_customers_city_BeforeShow
//licensing_list_alm_customers_BeforeShowRow @8-DA3EFFFB
function licensing_list_alm_customers_BeforeShowRow(& $sender)
{
$licensing_list_alm_customers_BeforeShowRow = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_BeforeShowRow
//Set Row Style @31-982C9472
$styles = array("Row", "AltRow");
if (count($styles)) {
$Style = $styles[($Component->RowNumber - 1) % count($styles)];
if (strlen($Style) && !strpos($Style, "="))
$Style = (strpos($Style, ":") ? 'style="' : 'class="'). $Style . '"';
$Component->Attributes->SetValue("rowStyle", $Style);
}
//End Set Row Style
//Close licensing_list_alm_customers_BeforeShowRow @8-CADB503B
return $licensing_list_alm_customers_BeforeShowRow;
}
//End Close licensing_list_alm_customers_BeforeShowRow
//licensing_list_alm_customers_ds_BeforeExecuteSelect @8-EDD23AE9
function licensing_list_alm_customers_ds_BeforeExecuteSelect(& $sender)
{
$licensing_list_alm_customers_ds_BeforeExecuteSelect = true;
$Component = & $sender;
$Container = & CCGetParentContainer($sender);
global $licensing_list; //Compatibility
//End licensing_list_alm_customers_ds_BeforeExecuteSelect
//Custom Code @33-2A29BDB7
// -------------------------
// Write your own code here.
//Special search for contacts since its stored on a separate table
$where = trim($licensing_list->alm_customers->ds->Where);
$search = trim(CCGetFromGet("s_search",""));
if (strlen($search) > 0) {
$sql = "select customer_id from alm_customers_contacts where contact like '%$search%' ";
$db = new clsDBdbConnection();
$db->query($sql);
$id = "0";
while($db->next_record()) {
$id .= $db->f("customer_id").",";
}
$id = trim($id,",");
$db->close();
if (strlen($where) > 0) {
//The parenthesis is needed to properly filter the search and users own customers
$where = "( $where ";
$where .= " or id in ($id) ) ";
} else {
$where .= " id in ($id) ";
}
$licensing_list->alm_customers->ds->Where = $where;
}
//Filtering grid content for users group
if (CCGetGroupID() == 1) {
$userid = CCGetUserID();
if (strlen($where) > 0) {
$where .= " and assigned_to = $userid ";
} else {
$where .= " assigned_to = $userid ";
}
$customers_list->alm_customers->ds->Where = $where;
}
// -------------------------
//End Custom Code
//Close licensing_list_alm_customers_ds_BeforeExecuteSelect @8-6CF15527
return $licensing_list_alm_customers_ds_BeforeExecuteSelect;
}
//End Close licensing_list_alm_customers_ds_BeforeExecuteSelect
?>