[ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[Summary view] [Print] [Text view]
1 <?xml version='1.0'?> 2 <module> 3 <exporttime>2014-04-17 10:54:22</exporttime> 4 <name>PBXManager</name> 5 <label>PBXManager</label> 6 <parent>Tools</parent> 7 <version>2.2</version> 8 <dependencies> 9 <vtiger_version>6.0.0</vtiger_version> 10 <vtiger_max_version>6.*</vtiger_max_version> 11 </dependencies> 12 <tables> 13 <table> 14 <name>vtiger_pbxmanager</name> 15 <sql><![CDATA[CREATE TABLE `vtiger_pbxmanager` ( 16 `pbxmanagerid` int(20) NOT NULL AUTO_INCREMENT, 17 `direction` varchar(10) DEFAULT NULL, 18 `callstatus` varchar(20) DEFAULT NULL, 19 `starttime` datetime DEFAULT NULL, 20 `endtime` datetime DEFAULT NULL, 21 `totalduration` int(11) DEFAULT NULL, 22 `billduration` int(11) DEFAULT NULL, 23 `recordingurl` varchar(200) DEFAULT NULL, 24 `sourceuuid` varchar(100) DEFAULT NULL, 25 `gateway` varchar(20) DEFAULT NULL, 26 `customer` varchar(100) DEFAULT NULL, 27 `user` varchar(100) DEFAULT NULL, 28 `customernumber` varchar(100) DEFAULT NULL, 29 `customertype` varchar(100) DEFAULT NULL, 30 PRIMARY KEY (`pbxmanagerid`), 31 KEY `index_sourceuuid` (`sourceuuid`), 32 KEY `index_pbxmanager_id` (`pbxmanagerid`) 33 ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8]]></sql> 34 </table> 35 <table> 36 <name>vtiger_pbxmanagercf</name> 37 <sql><![CDATA[CREATE TABLE `vtiger_pbxmanagercf` ( 38 `pbxmanagerid` int(11) NOT NULL, 39 PRIMARY KEY (`pbxmanagerid`) 40 ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql> 41 </table> 42 <table> 43 <name>vtiger_pbxmanager_gateway</name> 44 <sql><![CDATA[CREATE TABLE `vtiger_pbxmanager_gateway` ( 45 `id` int(11) NOT NULL AUTO_INCREMENT, 46 `gateway` varchar(20) DEFAULT NULL, 47 `parameters` text, 48 PRIMARY KEY (`id`) 49 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8]]></sql> 50 </table> 51 <table> 52 <name>vtiger_pbxmanager_phonelookup</name> 53 <sql><![CDATA[CREATE TABLE `vtiger_pbxmanager_phonelookup` ( 54 `crmid` int(20) DEFAULT NULL, 55 `setype` varchar(30) DEFAULT NULL, 56 `fnumber` varchar(100) DEFAULT NULL, 57 `rnumber` varchar(100) DEFAULT NULL, 58 `fieldname` varchar(50) DEFAULT NULL, 59 UNIQUE KEY `unique_key` (`crmid`,`setype`,`fieldname`), 60 KEY `index_phone_number` (`fnumber`,`rnumber`), 61 CONSTRAINT `vtiger_pbxmanager_phonelookup_ibfk_1` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE 62 ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql> 63 </table> 64 </tables> 65 <blocks> 66 <block> 67 <label>LBL_PBXMANAGER_INFORMATION</label> 68 <fields> 69 <field> 70 <fieldname>direction</fieldname> 71 <uitype>1</uitype> 72 <columnname>direction</columnname> 73 <columntype>VARCHAR(10)</columntype> 74 <tablename>vtiger_pbxmanager</tablename> 75 <generatedtype>1</generatedtype> 76 <fieldlabel>Direction</fieldlabel> 77 <readonly>1</readonly> 78 <presence>2</presence> 79 <defaultvalue></defaultvalue> 80 <sequence>1</sequence> 81 <maximumlength>100</maximumlength> 82 <typeofdata>V~O</typeofdata> 83 <quickcreate>1</quickcreate> 84 <quickcreatesequence></quickcreatesequence> 85 <displaytype>1</displaytype> 86 <info_type>BAS</info_type> 87 <helpinfo><![CDATA[]]></helpinfo> 88 <masseditable>1</masseditable> 89 </field> 90 <field> 91 <fieldname>callstatus</fieldname> 92 <uitype>1</uitype> 93 <columnname>callstatus</columnname> 94 <columntype>VARCHAR(20)</columntype> 95 <tablename>vtiger_pbxmanager</tablename> 96 <generatedtype>1</generatedtype> 97 <fieldlabel>Call Status</fieldlabel> 98 <readonly>1</readonly> 99 <presence>2</presence> 100 <defaultvalue></defaultvalue> 101 <sequence>2</sequence> 102 <maximumlength>100</maximumlength> 103 <typeofdata>V~O</typeofdata> 104 <quickcreate>1</quickcreate> 105 <quickcreatesequence></quickcreatesequence> 106 <displaytype>1</displaytype> 107 <info_type>BAS</info_type> 108 <helpinfo><![CDATA[]]></helpinfo> 109 <masseditable>1</masseditable> 110 <summaryfield>1</summaryfield> 111 </field> 112 <field> 113 <fieldname>starttime</fieldname> 114 <uitype>70</uitype> 115 <columnname>starttime</columnname> 116 <columntype>DATETIME</columntype> 117 <tablename>vtiger_pbxmanager</tablename> 118 <generatedtype>1</generatedtype> 119 <fieldlabel>Start Time</fieldlabel> 120 <readonly>1</readonly> 121 <presence>2</presence> 122 <defaultvalue></defaultvalue> 123 <sequence>7</sequence> 124 <maximumlength>100</maximumlength> 125 <typeofdata>DT~O</typeofdata> 126 <quickcreate>1</quickcreate> 127 <quickcreatesequence></quickcreatesequence> 128 <displaytype>1</displaytype> 129 <info_type>BAS</info_type> 130 <helpinfo><![CDATA[]]></helpinfo> 131 <masseditable>1</masseditable> 132 <summaryfield>1</summaryfield> 133 </field> 134 <field> 135 <fieldname>endtime</fieldname> 136 <uitype>70</uitype> 137 <columnname>endtime</columnname> 138 <columntype>DATETIME</columntype> 139 <tablename>vtiger_pbxmanager</tablename> 140 <generatedtype>1</generatedtype> 141 <fieldlabel>End Time</fieldlabel> 142 <readonly>1</readonly> 143 <presence>2</presence> 144 <defaultvalue></defaultvalue> 145 <sequence>8</sequence> 146 <maximumlength>100</maximumlength> 147 <typeofdata>DT~O</typeofdata> 148 <quickcreate>1</quickcreate> 149 <quickcreatesequence></quickcreatesequence> 150 <displaytype>1</displaytype> 151 <info_type>BAS</info_type> 152 <helpinfo><![CDATA[]]></helpinfo> 153 <masseditable>1</masseditable> 154 </field> 155 <field> 156 <fieldname>totalduration</fieldname> 157 <uitype>7</uitype> 158 <columnname>totalduration</columnname> 159 <columntype>INT(11)</columntype> 160 <tablename>vtiger_pbxmanager</tablename> 161 <generatedtype>1</generatedtype> 162 <fieldlabel>Total Duration</fieldlabel> 163 <readonly>1</readonly> 164 <presence>2</presence> 165 <defaultvalue></defaultvalue> 166 <sequence>10</sequence> 167 <maximumlength>100</maximumlength> 168 <typeofdata>I~O</typeofdata> 169 <quickcreate>1</quickcreate> 170 <quickcreatesequence></quickcreatesequence> 171 <displaytype>1</displaytype> 172 <info_type>BAS</info_type> 173 <helpinfo><![CDATA[]]></helpinfo> 174 <masseditable>1</masseditable> 175 </field> 176 <field> 177 <fieldname>billduration</fieldname> 178 <uitype>7</uitype> 179 <columnname>billduration</columnname> 180 <columntype>INT(11)</columntype> 181 <tablename>vtiger_pbxmanager</tablename> 182 <generatedtype>1</generatedtype> 183 <fieldlabel>Bill Duration</fieldlabel> 184 <readonly>1</readonly> 185 <presence>2</presence> 186 <defaultvalue></defaultvalue> 187 <sequence>11</sequence> 188 <maximumlength>100</maximumlength> 189 <typeofdata>I~O</typeofdata> 190 <quickcreate>1</quickcreate> 191 <quickcreatesequence></quickcreatesequence> 192 <displaytype>1</displaytype> 193 <info_type>BAS</info_type> 194 <helpinfo><![CDATA[]]></helpinfo> 195 <masseditable>1</masseditable> 196 </field> 197 <field> 198 <fieldname>recordingurl</fieldname> 199 <uitype>17</uitype> 200 <columnname>recordingurl</columnname> 201 <columntype>VARCHAR(200)</columntype> 202 <tablename>vtiger_pbxmanager</tablename> 203 <generatedtype>1</generatedtype> 204 <fieldlabel>Recording URL</fieldlabel> 205 <readonly>1</readonly> 206 <presence>2</presence> 207 <defaultvalue></defaultvalue> 208 <sequence>9</sequence> 209 <maximumlength>100</maximumlength> 210 <typeofdata>V~O</typeofdata> 211 <quickcreate>1</quickcreate> 212 <quickcreatesequence></quickcreatesequence> 213 <displaytype>1</displaytype> 214 <info_type>BAS</info_type> 215 <helpinfo><![CDATA[]]></helpinfo> 216 <masseditable>1</masseditable> 217 <summaryfield>1</summaryfield> 218 </field> 219 <field> 220 <fieldname>sourceuuid</fieldname> 221 <uitype>1</uitype> 222 <columnname>sourceuuid</columnname> 223 <columntype>VARCHAR(100)</columntype> 224 <tablename>vtiger_pbxmanager</tablename> 225 <generatedtype>1</generatedtype> 226 <fieldlabel>Source UUID</fieldlabel> 227 <readonly>1</readonly> 228 <presence>2</presence> 229 <defaultvalue></defaultvalue> 230 <sequence>12</sequence> 231 <maximumlength>100</maximumlength> 232 <typeofdata>V~O</typeofdata> 233 <quickcreate>1</quickcreate> 234 <quickcreatesequence></quickcreatesequence> 235 <displaytype>1</displaytype> 236 <info_type>BAS</info_type> 237 <helpinfo><![CDATA[]]></helpinfo> 238 <masseditable>1</masseditable> 239 </field> 240 <field> 241 <fieldname>gateway</fieldname> 242 <uitype>1</uitype> 243 <columnname>gateway</columnname> 244 <columntype>VARCHAR(20)</columntype> 245 <tablename>vtiger_pbxmanager</tablename> 246 <generatedtype>1</generatedtype> 247 <fieldlabel>Gateway</fieldlabel> 248 <readonly>1</readonly> 249 <presence>2</presence> 250 <defaultvalue></defaultvalue> 251 <sequence>13</sequence> 252 <maximumlength>100</maximumlength> 253 <typeofdata>V~O</typeofdata> 254 <quickcreate>1</quickcreate> 255 <quickcreatesequence></quickcreatesequence> 256 <displaytype>1</displaytype> 257 <info_type>BAS</info_type> 258 <helpinfo><![CDATA[]]></helpinfo> 259 <masseditable>1</masseditable> 260 </field> 261 <field> 262 <fieldname>customer</fieldname> 263 <uitype>10</uitype> 264 <columnname>customer</columnname> 265 <columntype>VARCHAR(100)</columntype> 266 <tablename>vtiger_pbxmanager</tablename> 267 <generatedtype>1</generatedtype> 268 <fieldlabel>Customer</fieldlabel> 269 <readonly>1</readonly> 270 <presence>2</presence> 271 <defaultvalue></defaultvalue> 272 <sequence>3</sequence> 273 <maximumlength>100</maximumlength> 274 <typeofdata>V~O</typeofdata> 275 <quickcreate>1</quickcreate> 276 <quickcreatesequence></quickcreatesequence> 277 <displaytype>1</displaytype> 278 <info_type>BAS</info_type> 279 <helpinfo><![CDATA[]]></helpinfo> 280 <masseditable>1</masseditable> 281 <summaryfield>1</summaryfield> 282 <relatedmodules> 283 <relatedmodule>Leads</relatedmodule> 284 <relatedmodule>Contacts</relatedmodule> 285 <relatedmodule>Accounts</relatedmodule> 286 </relatedmodules> 287 </field> 288 <field> 289 <fieldname>user</fieldname> 290 <uitype>52</uitype> 291 <columnname>user</columnname> 292 <columntype>VARCHAR(100)</columntype> 293 <tablename>vtiger_pbxmanager</tablename> 294 <generatedtype>1</generatedtype> 295 <fieldlabel>User</fieldlabel> 296 <readonly>1</readonly> 297 <presence>2</presence> 298 <defaultvalue></defaultvalue> 299 <sequence>4</sequence> 300 <maximumlength>100</maximumlength> 301 <typeofdata>V~O</typeofdata> 302 <quickcreate>1</quickcreate> 303 <quickcreatesequence></quickcreatesequence> 304 <displaytype>1</displaytype> 305 <info_type>BAS</info_type> 306 <helpinfo><![CDATA[]]></helpinfo> 307 <masseditable>1</masseditable> 308 <summaryfield>1</summaryfield> 309 </field> 310 <field> 311 <fieldname>customernumber</fieldname> 312 <uitype>11</uitype> 313 <columnname>customernumber</columnname> 314 <columntype>VARCHAR(100)</columntype> 315 <tablename>vtiger_pbxmanager</tablename> 316 <generatedtype>1</generatedtype> 317 <fieldlabel>Customer Number</fieldlabel> 318 <readonly>1</readonly> 319 <presence>2</presence> 320 <defaultvalue></defaultvalue> 321 <sequence>5</sequence> 322 <maximumlength>100</maximumlength> 323 <typeofdata>V~M</typeofdata> 324 <quickcreate>1</quickcreate> 325 <quickcreatesequence></quickcreatesequence> 326 <displaytype>1</displaytype> 327 <info_type>BAS</info_type> 328 <helpinfo><![CDATA[]]></helpinfo> 329 <masseditable>1</masseditable> 330 <entityidentifier> 331 <entityidfield>pbxmanagerid</entityidfield> 332 <entityidcolumn>pbxmanagerid</entityidcolumn> 333 </entityidentifier> 334 </field> 335 <field> 336 <fieldname>customertype</fieldname> 337 <uitype>1</uitype> 338 <columnname>customertype</columnname> 339 <columntype>VARCHAR(100)</columntype> 340 <tablename>vtiger_pbxmanager</tablename> 341 <generatedtype>1</generatedtype> 342 <fieldlabel>Customer Type</fieldlabel> 343 <readonly>1</readonly> 344 <presence>2</presence> 345 <defaultvalue></defaultvalue> 346 <sequence>6</sequence> 347 <maximumlength>100</maximumlength> 348 <typeofdata>V~O</typeofdata> 349 <quickcreate>1</quickcreate> 350 <quickcreatesequence></quickcreatesequence> 351 <displaytype>1</displaytype> 352 <info_type>BAS</info_type> 353 <helpinfo><![CDATA[]]></helpinfo> 354 <masseditable>1</masseditable> 355 </field> 356 <field> 357 <fieldname>assigned_user_id</fieldname> 358 <uitype>53</uitype> 359 <columnname>smownerid</columnname> 360 <columntype>INT(19)</columntype> 361 <tablename>vtiger_crmentity</tablename> 362 <generatedtype>1</generatedtype> 363 <fieldlabel>Assigned To</fieldlabel> 364 <readonly>1</readonly> 365 <presence>2</presence> 366 <defaultvalue></defaultvalue> 367 <sequence>14</sequence> 368 <maximumlength>100</maximumlength> 369 <typeofdata>V~M</typeofdata> 370 <quickcreate>1</quickcreate> 371 <quickcreatesequence></quickcreatesequence> 372 <displaytype>1</displaytype> 373 <info_type>BAS</info_type> 374 <helpinfo><![CDATA[]]></helpinfo> 375 <masseditable>1</masseditable> 376 </field> 377 <field> 378 <fieldname>CreatedTime</fieldname> 379 <uitype>70</uitype> 380 <columnname>createdtime</columnname> 381 <columntype>DATETIME</columntype> 382 <tablename>vtiger_crmentity</tablename> 383 <generatedtype>1</generatedtype> 384 <fieldlabel>Created Time</fieldlabel> 385 <readonly>1</readonly> 386 <presence>2</presence> 387 <defaultvalue></defaultvalue> 388 <sequence>15</sequence> 389 <maximumlength>100</maximumlength> 390 <typeofdata>DT~O</typeofdata> 391 <quickcreate>1</quickcreate> 392 <quickcreatesequence></quickcreatesequence> 393 <displaytype>2</displaytype> 394 <info_type>BAS</info_type> 395 <helpinfo><![CDATA[]]></helpinfo> 396 <masseditable>1</masseditable> 397 </field> 398 <field> 399 <fieldname>ModifiedTime</fieldname> 400 <uitype>70</uitype> 401 <columnname>modifiedtime</columnname> 402 <columntype>DATETIME</columntype> 403 <tablename>vtiger_crmentity</tablename> 404 <generatedtype>1</generatedtype> 405 <fieldlabel>Modified Time</fieldlabel> 406 <readonly>1</readonly> 407 <presence>2</presence> 408 <defaultvalue></defaultvalue> 409 <sequence>16</sequence> 410 <maximumlength>100</maximumlength> 411 <typeofdata>DT~O</typeofdata> 412 <quickcreate>1</quickcreate> 413 <quickcreatesequence></quickcreatesequence> 414 <displaytype>2</displaytype> 415 <info_type>BAS</info_type> 416 <helpinfo><![CDATA[]]></helpinfo> 417 <masseditable>1</masseditable> 418 </field> 419 </fields> 420 </block> 421 </blocks> 422 <customviews> 423 <customview> 424 <viewname>All</viewname> 425 <setdefault>true</setdefault> 426 <setmetrics>false</setmetrics> 427 <fields> 428 <field> 429 <fieldname>callstatus</fieldname> 430 <columnindex>0</columnindex> 431 </field> 432 <field> 433 <fieldname>customernumber</fieldname> 434 <columnindex>1</columnindex> 435 </field> 436 <field> 437 <fieldname>customer</fieldname> 438 <columnindex>2</columnindex> 439 </field> 440 <field> 441 <fieldname>user</fieldname> 442 <columnindex>3</columnindex> 443 </field> 444 <field> 445 <fieldname>recordingurl</fieldname> 446 <columnindex>4</columnindex> 447 </field> 448 <field> 449 <fieldname>totalduration</fieldname> 450 <columnindex>5</columnindex> 451 </field> 452 <field> 453 <fieldname>starttime</fieldname> 454 <columnindex>6</columnindex> 455 </field> 456 </fields> 457 </customview> 458 </customviews> 459 <sharingaccess> 460 <default>private</default> 461 </sharingaccess> 462 <actions> 463 <action> 464 <name><![CDATA[ReceiveIncomingCalls]]></name> 465 <status>enabled</status> 466 </action> 467 <action> 468 <name><![CDATA[MakeOutgoingCalls]]></name> 469 <status>enabled</status> 470 </action> 471 </actions> 472 <crons> 473 </crons> 474 </module>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Fri Nov 28 20:08:37 2014 | Cross-referenced by PHPXref 0.7.1 |