model.itop-config-mgmt.php 72 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196
  1. <?php
  2. // Copyright (C) 2010 Combodo SARL
  3. //
  4. // This program is free software; you can redistribute it and/or modify
  5. // it under the terms of the GNU General Public License as published by
  6. // the Free Software Foundation; version 3 of the License.
  7. //
  8. // This program is distributed in the hope that it will be useful,
  9. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  10. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  11. // GNU General Public License for more details.
  12. //
  13. // You should have received a copy of the GNU General Public License
  14. // along with this program; if not, write to the Free Software
  15. // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  16. /**
  17. * Persistent classes for a CMDB
  18. *
  19. * @author Erwan Taloc <erwan.taloc@combodo.com>
  20. * @author Romain Quetiez <romain.quetiez@combodo.com>
  21. * @author Denis Flaven <denis.flaven@combodo.com>
  22. * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL
  23. */
  24. require_once('../application/cmdbabstract.class.inc.php');
  25. require_once('../application/template.class.inc.php');
  26. class Organization extends cmdbAbstractObject
  27. {
  28. public static function Init()
  29. {
  30. $aParams = array
  31. (
  32. "category" => "bizmodel,searchable,structure",
  33. "key_type" => "autoincrement",
  34. "name_attcode" => "name",
  35. "state_attcode" => "",
  36. "reconc_keys" => array("name"),
  37. "db_table" => "organization",
  38. "db_key_field" => "id",
  39. "db_finalclass_field" => "",
  40. "display_template" => "",
  41. );
  42. MetaModel::Init_Params($aParams);
  43. MetaModel::Init_InheritAttributes();
  44. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  45. MetaModel::Init_AddAttribute(new AttributeString("code", array("allowed_values"=>null, "sql"=>"code", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  46. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('active,inactive'), "sql"=>"status", "default_value"=>"active", "is_null_allowed"=>true, "depends_on"=>array())));
  47. MetaModel::Init_AddAttribute(new AttributeExternalKey("parent_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"parent_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  48. MetaModel::Init_AddAttribute(new AttributeExternalField("parent_name", array("allowed_values"=>null, "extkey_attcode"=>"parent_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  49. MetaModel::Init_SetZListItems('details', array('name', 'code', 'status', 'parent_id'));
  50. MetaModel::Init_SetZListItems('advanced_search', array('name', 'code', 'status'));
  51. MetaModel::Init_SetZListItems('standard_search', array('name', 'code', 'status'));
  52. MetaModel::Init_SetZListItems('list', array('status', 'parent_id'));
  53. }
  54. }
  55. class Location extends cmdbAbstractObject
  56. {
  57. public static function Init()
  58. {
  59. $aParams = array
  60. (
  61. "category" => "bizmodel,searchable,structure",
  62. "key_type" => "autoincrement",
  63. "name_attcode" => "name",
  64. "state_attcode" => "",
  65. "reconc_keys" => array("name"),
  66. "db_table" => "location",
  67. "db_key_field" => "id",
  68. "db_finalclass_field" => "",
  69. "icon" => "../business/templates/location.png",
  70. );
  71. MetaModel::Init_Params($aParams);
  72. MetaModel::Init_InheritAttributes();
  73. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  74. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('active,inactive'), "sql"=>"status", "default_value"=>"active", "is_null_allowed"=>true, "depends_on"=>array())));
  75. MetaModel::Init_AddAttribute(new AttributeExternalKey("org_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"org_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  76. MetaModel::Init_AddAttribute(new AttributeExternalField("org_name", array("allowed_values"=>null, "extkey_attcode"=>"org_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  77. MetaModel::Init_AddAttribute(new AttributeText("address", array("allowed_values"=>null, "sql"=>"address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  78. MetaModel::Init_AddAttribute(new AttributeString("country", array("allowed_values"=>null, "sql"=>"country", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  79. MetaModel::Init_AddAttribute(new AttributeExternalKey("parent_id", array("targetclass"=>"Location", "jointype"=>null, "allowed_values"=>null, "sql"=>"parent_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  80. MetaModel::Init_AddAttribute(new AttributeExternalField("parent_name", array("allowed_values"=>null, "extkey_attcode"=>"parent_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  81. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'address', 'country', 'parent_id'));
  82. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'country'));
  83. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'country'));
  84. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'country'));
  85. }
  86. }
  87. abstract class Contact extends cmdbAbstractObject
  88. {
  89. public static function Init()
  90. {
  91. $aParams = array
  92. (
  93. "category" => "bizmodel,searchable,structure",
  94. "key_type" => "autoincrement",
  95. "name_attcode" => "name",
  96. "state_attcode" => "",
  97. "reconc_keys" => array("name"),
  98. "db_table" => "contact",
  99. "db_key_field" => "id",
  100. "db_finalclass_field" => "",
  101. "icon" => "../business/templates/team.png",
  102. );
  103. MetaModel::Init_Params($aParams);
  104. MetaModel::Init_InheritAttributes();
  105. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  106. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('active,inactive'), "sql"=>"status", "default_value"=>"active", "is_null_allowed"=>true, "depends_on"=>array())));
  107. MetaModel::Init_AddAttribute(new AttributeExternalKey("org_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"org_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  108. MetaModel::Init_AddAttribute(new AttributeExternalField("org_name", array("allowed_values"=>null, "extkey_attcode"=>"org_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  109. MetaModel::Init_AddAttribute(new AttributeEmailAddress("email", array("allowed_values"=>null, "sql"=>"email", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  110. MetaModel::Init_AddAttribute(new AttributeString("phone", array("allowed_values"=>null, "sql"=>"phone", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  111. MetaModel::Init_AddAttribute(new AttributeExternalKey("location_id", array("targetclass"=>"Location", "jointype"=>null, "allowed_values"=>null, "sql"=>"location_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  112. MetaModel::Init_AddAttribute(new AttributeExternalField("location_name", array("allowed_values"=>null, "extkey_attcode"=>"location_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  113. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("contract_list", array("linked_class"=>"lnkContractToContact", "ext_key_to_me"=>"contact_id", "ext_key_to_remote"=>"contract_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  114. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ticket_list", array("linked_class"=>"lnkTicketToContact", "ext_key_to_me"=>"contact_id", "ext_key_to_remote"=>"ticket_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  115. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ci_list", array("linked_class"=>"lnkCIToContact", "ext_key_to_me"=>"contact_id", "ext_key_to_remote"=>"ci_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  116. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'contract_list', 'ticket_list', 'ci_list'));
  117. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  118. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  119. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id'));
  120. }
  121. }
  122. class Person extends Contact
  123. {
  124. public static function Init()
  125. {
  126. $aParams = array
  127. (
  128. "category" => "bizmodel,searchable,structure",
  129. "key_type" => "autoincrement",
  130. "name_attcode" => "name",
  131. "state_attcode" => "",
  132. "reconc_keys" => array("name"),
  133. "db_table" => "person",
  134. "db_key_field" => "id",
  135. "db_finalclass_field" => "",
  136. "icon" => "../business/templates/person.png",
  137. );
  138. MetaModel::Init_Params($aParams);
  139. MetaModel::Init_InheritAttributes();
  140. MetaModel::Init_AddAttribute(new AttributeString("first_name", array("allowed_values"=>null, "sql"=>"first_name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  141. MetaModel::Init_AddAttribute(new AttributeString("employee_id", array("allowed_values"=>null, "sql"=>"employee_id", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  142. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'contract_list', 'ticket_list', 'ci_list', 'first_name', 'employee_id'));
  143. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'first_name', 'employee_id'));
  144. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'first_name', 'employee_id'));
  145. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id', 'first_name', 'employee_id'));
  146. }
  147. }
  148. class Team extends Contact
  149. {
  150. public static function Init()
  151. {
  152. $aParams = array
  153. (
  154. "category" => "bizmodel,searchable,structure",
  155. "key_type" => "autoincrement",
  156. "name_attcode" => "name",
  157. "state_attcode" => "",
  158. "reconc_keys" => array("name"),
  159. "db_table" => "team",
  160. "db_key_field" => "id",
  161. "db_finalclass_field" => "",
  162. "icon" => "../business/templates/team.png",
  163. );
  164. MetaModel::Init_Params($aParams);
  165. MetaModel::Init_InheritAttributes();
  166. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'contract_list', 'ticket_list', 'ci_list'));
  167. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  168. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  169. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id'));
  170. }
  171. }
  172. abstract class Document extends cmdbAbstractObject
  173. {
  174. public static function Init()
  175. {
  176. $aParams = array
  177. (
  178. "category" => "bizmodel,searchable,documentation",
  179. "key_type" => "autoincrement",
  180. "name_attcode" => "name",
  181. "state_attcode" => "",
  182. "reconc_keys" => array("name"),
  183. "db_table" => "document",
  184. "db_key_field" => "id",
  185. "db_finalclass_field" => "",
  186. "icon" => "../business/templates/document.png",
  187. );
  188. MetaModel::Init_Params($aParams);
  189. MetaModel::Init_InheritAttributes();
  190. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  191. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  192. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("allowed_values"=>new ValueSetEnum('contract,networkmap,presentation,training,whitePaper,workinginstructions'), "sql"=>"type", "default_value"=>"presentation", "is_null_allowed"=>true, "depends_on"=>array())));
  193. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('draft,published,obsolete'), "sql"=>"status", "default_value"=>"draft", "is_null_allowed"=>true, "depends_on"=>array())));
  194. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("contract_list", array("linked_class"=>"lnkContractToDoc", "ext_key_to_me"=>"document_id", "ext_key_to_remote"=>"contract_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  195. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ticket_list", array("linked_class"=>"lnkTicketToDoc", "ext_key_to_me"=>"document_id", "ext_key_to_remote"=>"ticket_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  196. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ci_list", array("linked_class"=>"lnkCIToDoc", "ext_key_to_me"=>"document_id", "ext_key_to_remote"=>"ci_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  197. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list'));
  198. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status'));
  199. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status'));
  200. MetaModel::Init_SetZListItems('list', array('type', 'status'));
  201. }
  202. }
  203. class ExternalDoc extends Document
  204. {
  205. public static function Init()
  206. {
  207. $aParams = array
  208. (
  209. "category" => "bizmodel,searchable,documentation",
  210. "key_type" => "autoincrement",
  211. "name_attcode" => "name",
  212. "state_attcode" => "",
  213. "reconc_keys" => array("name"),
  214. "db_table" => "externaldoc",
  215. "db_key_field" => "id",
  216. "db_finalclass_field" => "",
  217. "icon" => "../business/templates/document.png",
  218. );
  219. MetaModel::Init_Params($aParams);
  220. MetaModel::Init_InheritAttributes();
  221. MetaModel::Init_AddAttribute(new AttributeURL("url", array("target"=>"_blank", "allowed_values"=>null, "sql"=>"url", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  222. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'url'));
  223. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status', 'url'));
  224. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status', 'url'));
  225. MetaModel::Init_SetZListItems('list', array('type', 'status', 'url'));
  226. }
  227. }
  228. class Note extends Document
  229. {
  230. public static function Init()
  231. {
  232. $aParams = array
  233. (
  234. "category" => "bizmodel,searchable,documentation",
  235. "key_type" => "autoincrement",
  236. "name_attcode" => "name",
  237. "state_attcode" => "",
  238. "reconc_keys" => array("name"),
  239. "db_table" => "note",
  240. "db_key_field" => "id",
  241. "db_finalclass_field" => "",
  242. "icon" => "../business/templates/document.png",
  243. );
  244. MetaModel::Init_Params($aParams);
  245. MetaModel::Init_InheritAttributes();
  246. MetaModel::Init_AddAttribute(new AttributeWikiText("note", array("allowed_values"=>null, "sql"=>"note", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  247. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'note'));
  248. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status', 'note'));
  249. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status', 'note'));
  250. MetaModel::Init_SetZListItems('list', array('type', 'status', 'note'));
  251. }
  252. }
  253. class FileDoc extends Document
  254. {
  255. public static function Init()
  256. {
  257. $aParams = array
  258. (
  259. "category" => "bizmodel,searchable,documentation",
  260. "key_type" => "autoincrement",
  261. "name_attcode" => "name",
  262. "state_attcode" => "",
  263. "reconc_keys" => array("name"),
  264. "db_table" => "filedoc",
  265. "db_key_field" => "id",
  266. "db_finalclass_field" => "",
  267. "icon" => "../business/templates/document.png",
  268. );
  269. MetaModel::Init_Params($aParams);
  270. MetaModel::Init_InheritAttributes();
  271. MetaModel::Init_AddAttribute(new AttributeBlob("contents", array("depends_on"=>array())));
  272. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'contents'));
  273. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status'));
  274. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status'));
  275. MetaModel::Init_SetZListItems('list', array('type', 'status', 'contents'));
  276. }
  277. /**
  278. * Overload the display of the properties to add a tab (the first one)
  279. * with the preview of the document
  280. */
  281. public function DisplayBareProperties(WebPage $oPage)
  282. {
  283. $oPage->SetCurrentTab(Dict::S('Class:Document:PreviewTab'));
  284. $oPage->add($this->DisplayDocumentInline($oPage, 'contents'));
  285. $oPage->SetCurrentTab(Dict::S('UI:PropertiesTab'));
  286. parent::DisplayBareProperties($oPage);
  287. }
  288. }
  289. class Licence extends cmdbAbstractObject
  290. {
  291. public static function Init()
  292. {
  293. $aParams = array
  294. (
  295. "category" => "bizmodel,searchable,configmgmt",
  296. "key_type" => "autoincrement",
  297. "name_attcode" => "provider",
  298. "state_attcode" => "",
  299. "reconc_keys" => array("name"),
  300. "db_table" => "licence",
  301. "db_key_field" => "id",
  302. "db_finalclass_field" => "",
  303. "icon" => "../business/templates/licence.png",
  304. );
  305. MetaModel::Init_Params($aParams);
  306. MetaModel::Init_InheritAttributes();
  307. MetaModel::Init_AddAttribute(new AttributeString("provider", array("allowed_values"=>null, "sql"=>"provider", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  308. MetaModel::Init_AddAttribute(new AttributeString("product", array("allowed_values"=>null, "sql"=>"product", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  309. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  310. MetaModel::Init_AddAttribute(new AttributeDate("start", array("allowed_values"=>null, "sql"=>"start", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  311. MetaModel::Init_AddAttribute(new AttributeDate("end", array("allowed_values"=>null, "sql"=>"end", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  312. MetaModel::Init_AddAttribute(new AttributeString("key", array("allowed_values"=>null, "sql"=>"key", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  313. MetaModel::Init_AddAttribute(new AttributeText("scope", array("allowed_values"=>null, "sql"=>"scope", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  314. MetaModel::Init_SetZListItems('details', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  315. MetaModel::Init_SetZListItems('advanced_search', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  316. MetaModel::Init_SetZListItems('standard_search', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  317. MetaModel::Init_SetZListItems('list', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  318. }
  319. }
  320. class Subnet extends cmdbAbstractObject
  321. {
  322. public static function Init()
  323. {
  324. $aParams = array
  325. (
  326. "category" => "bizmodel,searchable,configmgmt",
  327. "key_type" => "autoincrement",
  328. "name_attcode" => "name",
  329. "state_attcode" => "",
  330. "reconc_keys" => array("name"),
  331. "db_table" => "subnet",
  332. "db_key_field" => "id",
  333. "db_finalclass_field" => "",
  334. "icon" => "../business/templates/subnet.png",
  335. );
  336. MetaModel::Init_Params($aParams);
  337. MetaModel::Init_InheritAttributes();
  338. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  339. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  340. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip", array("allowed_values"=>null, "sql"=>"ip", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  341. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_mask", array("allowed_values"=>null, "sql"=>"ip_mask", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  342. MetaModel::Init_SetZListItems('details', array('name', 'description', 'ip', 'ip_mask'));
  343. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'ip', 'ip_mask'));
  344. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'ip', 'ip_mask'));
  345. MetaModel::Init_SetZListItems('list', array('description', 'ip', 'ip_mask'));
  346. }
  347. public function ComputeValues()
  348. {
  349. $sName = $this->Get('ip').'/'.$this->Get('ip_mask');
  350. $this->Set('name', $sName);
  351. }
  352. function DisplayBareRelations(WebPage $oPage)
  353. {
  354. parent::DisplayBareRelations($oPage);
  355. $oPage->SetCurrentTab(Dict::S('Class:Subnet/Tab:IPUsage'));
  356. $bit_ip = ip2long($this->Get('ip'));
  357. $bit_mask = ip2long($this->Get('ip_mask'));
  358. $iIPMin = $bit_ip & $bit_mask;
  359. $iIPMax = ($bit_ip | (~$bit_mask)) - 1;
  360. $sIPMin = long2ip($iIPMin);
  361. $sIPMax = long2ip($iIPMax);
  362. $oPage->p(Dict::Format('Class:Subnet/Tab:IPUsage-explain', $sIPMin, $sIPMax));
  363. $oIfSet = new CMDBObjectSet(DBObjectSearch::FromOQL("SELECT NetworkInterface AS if WHERE INET_ATON(if.ip_address) >= INET_ATON('$sIPMin') AND INET_ATON(if.ip_address) <= INET_ATON('$sIPMax')"));
  364. self::DisplaySet($oPage, $oIfSet);
  365. $iCountUsed = $oIfSet->Count();
  366. $iCountRange = $iIPMax - $iIPMin;
  367. $iFreeCount = $iCountRange - $iCountUsed;
  368. $oPage->SetCurrentTab(Dict::S('Class:Subnet/Tab:FreeIPs'));
  369. $oPage->p(Dict::Format('Class:Subnet/Tab:FreeIPs-count', $iFreeCount));
  370. $oPage->p(Dict::S('Class:Subnet/Tab:FreeIPs-explain'));
  371. $aUsedIPs = $oIfSet->GetColumnAsArray('ip_address', false);
  372. $iAnIP = $iIPMin;
  373. $iFound = 0;
  374. while (($iFound < min($iFreeCount, 10)) && ($iAnIP <= $iIPMax))
  375. {
  376. $sAnIP = long2ip($iAnIP);
  377. if (!in_array($sAnIP, $aUsedIPs))
  378. {
  379. $iFound++;
  380. $oPage->p($sAnIP);
  381. }
  382. else
  383. {
  384. }
  385. $iAnIP++;
  386. }
  387. }
  388. }
  389. class Patch extends cmdbAbstractObject
  390. {
  391. public static function Init()
  392. {
  393. $aParams = array
  394. (
  395. "category" => "bizmodel,searchable,configmgmt",
  396. "key_type" => "autoincrement",
  397. "name_attcode" => "name",
  398. "state_attcode" => "",
  399. "reconc_keys" => array("name"),
  400. "db_table" => "patch",
  401. "db_key_field" => "id",
  402. "db_finalclass_field" => "",
  403. "icon" => "../business/templates/patch.png",
  404. );
  405. MetaModel::Init_Params($aParams);
  406. MetaModel::Init_InheritAttributes();
  407. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  408. MetaModel::Init_AddAttribute(new AttributeString("target_sw", array("allowed_values"=>null, "sql"=>"target_sw", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  409. MetaModel::Init_AddAttribute(new AttributeString("version", array("allowed_values"=>null, "sql"=>"version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  410. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("allowed_values"=>new ValueSetEnum('security,servicepack,fix'), "sql"=>"type", "default_value"=>"fix", "is_null_allowed"=>true, "depends_on"=>array())));
  411. MetaModel::Init_SetZListItems('details', array('name', 'target_sw', 'version', 'type'));
  412. MetaModel::Init_SetZListItems('advanced_search', array('name', 'target_sw', 'version', 'type'));
  413. MetaModel::Init_SetZListItems('standard_search', array('name', 'target_sw', 'version', 'type'));
  414. MetaModel::Init_SetZListItems('list', array('target_sw', 'version', 'type'));
  415. }
  416. }
  417. class Application extends cmdbAbstractObject
  418. {
  419. public static function Init()
  420. {
  421. $aParams = array
  422. (
  423. "category" => "bizmodel,searchable,configmgmt",
  424. "key_type" => "autoincrement",
  425. "name_attcode" => "name",
  426. "state_attcode" => "",
  427. "reconc_keys" => array("name"),
  428. "db_table" => "application",
  429. "db_key_field" => "id",
  430. "db_finalclass_field" => "",
  431. "icon" => "../business/templates/software.png",
  432. );
  433. MetaModel::Init_Params($aParams);
  434. MetaModel::Init_InheritAttributes();
  435. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  436. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  437. MetaModel::Init_SetZListItems('details', array('name', 'description'));
  438. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description'));
  439. MetaModel::Init_SetZListItems('standard_search', array('name', 'description'));
  440. MetaModel::Init_SetZListItems('list', array('description'));
  441. }
  442. }
  443. class lnkPatchToCI extends cmdbAbstractObject
  444. {
  445. public static function Init()
  446. {
  447. $aParams = array
  448. (
  449. "category" => "bizmodel,configmgmt",
  450. "key_type" => "autoincrement",
  451. "name_attcode" => "patch_id",
  452. "state_attcode" => "",
  453. "reconc_keys" => array("name"),
  454. "db_table" => "lnkpatchtoci",
  455. "db_key_field" => "id",
  456. "db_finalclass_field" => "",
  457. "display_template" => "",
  458. );
  459. MetaModel::Init_Params($aParams);
  460. MetaModel::Init_InheritAttributes();
  461. MetaModel::Init_AddAttribute(new AttributeExternalKey("patch_id", array("targetclass"=>"Patch", "jointype"=>null, "allowed_values"=>null, "sql"=>"patch_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  462. MetaModel::Init_AddAttribute(new AttributeExternalField("patch_name", array("allowed_values"=>null, "extkey_attcode"=>"patch_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  463. MetaModel::Init_AddAttribute(new AttributeExternalKey("ci_id", array("targetclass"=>"Device", "jointype"=>null, "allowed_values"=>null, "sql"=>"ci_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  464. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_name", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  465. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_status", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"status", "is_null_allowed"=>true, "depends_on"=>array())));
  466. MetaModel::Init_SetZListItems('details', array('patch_id', 'ci_id', 'ci_status'));
  467. MetaModel::Init_SetZListItems('advanced_search', array('patch_id', 'ci_id'));
  468. MetaModel::Init_SetZListItems('standard_search', array('patch_id', 'ci_id'));
  469. MetaModel::Init_SetZListItems('list', array('patch_id', 'ci_id', 'ci_status'));
  470. }
  471. }
  472. abstract class FunctionalCI extends cmdbAbstractObject
  473. {
  474. public static function Init()
  475. {
  476. $aParams = array
  477. (
  478. "category" => "bizmodel,searchable,configmgmt",
  479. "key_type" => "autoincrement",
  480. "name_attcode" => "name",
  481. "state_attcode" => "",
  482. "reconc_keys" => array("name"),
  483. "db_table" => "functionalci",
  484. "db_key_field" => "id",
  485. "db_finalclass_field" => "",
  486. "icon" => "../business/templates/server.png",
  487. );
  488. MetaModel::Init_Params($aParams);
  489. MetaModel::Init_InheritAttributes();
  490. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  491. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('implementation,production,obsolete'), "sql"=>"status", "default_value"=>"implementation", "is_null_allowed"=>true, "depends_on"=>array())));
  492. MetaModel::Init_AddAttribute(new AttributeExternalKey("owner_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"owner_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  493. MetaModel::Init_AddAttribute(new AttributeExternalField("owner_name", array("allowed_values"=>null, "extkey_attcode"=>"owner_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  494. MetaModel::Init_AddAttribute(new AttributeEnum("importance", array("allowed_values"=>new ValueSetEnum('low,medium,high'), "sql"=>"importance", "default_value"=>"medium", "is_null_allowed"=>false, "depends_on"=>array())));
  495. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("contact_list", array("linked_class"=>"lnkCIToContact", "ext_key_to_me"=>"ci_id", "ext_key_to_remote"=>"contact_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  496. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("document_list", array("linked_class"=>"lnkCIToDoc", "ext_key_to_me"=>"ci_id", "ext_key_to_remote"=>"document_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  497. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("solution_list", array("linked_class"=>"lnkSolutionToCI", "ext_key_to_me"=>"ci_id", "ext_key_to_remote"=>"solution_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  498. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'contact_list', 'document_list', 'solution_list'));
  499. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance'));
  500. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance'));
  501. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance'));
  502. }
  503. }
  504. class ApplicationInstance extends FunctionalCI
  505. {
  506. public static function Init()
  507. {
  508. $aParams = array
  509. (
  510. "category" => "bizmodel,searchable,configmgmt",
  511. "key_type" => "autoincrement",
  512. "name_attcode" => "name",
  513. "state_attcode" => "",
  514. "reconc_keys" => array("name"),
  515. "db_table" => "applicationinstance",
  516. "db_key_field" => "id",
  517. "db_finalclass_field" => "",
  518. "icon" => "../business/templates/application.png",
  519. );
  520. MetaModel::Init_Params($aParams);
  521. MetaModel::Init_InheritAttributes();
  522. MetaModel::Init_AddAttribute(new AttributeExternalKey("device_id", array("targetclass"=>"Device", "jointype"=>null, "allowed_values"=>null, "sql"=>"device_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  523. MetaModel::Init_AddAttribute(new AttributeExternalField("device_name", array("allowed_values"=>null, "extkey_attcode"=>"device_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  524. MetaModel::Init_AddAttribute(new AttributeExternalKey("licence_id", array("targetclass"=>"Licence", "jointype"=>null, "allowed_values"=>null, "sql"=>"licence_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  525. MetaModel::Init_AddAttribute(new AttributeExternalField("licence_name", array("allowed_values"=>null, "extkey_attcode"=>"licence_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  526. MetaModel::Init_AddAttribute(new AttributeExternalKey("application_id", array("targetclass"=>"Application", "jointype"=>null, "allowed_values"=>null, "sql"=>"application_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  527. MetaModel::Init_AddAttribute(new AttributeExternalField("application_name", array("allowed_values"=>null, "extkey_attcode"=>"application_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  528. MetaModel::Init_AddAttribute(new AttributeString("version", array("allowed_values"=>null, "sql"=>"version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  529. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  530. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  531. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  532. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  533. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  534. }
  535. }
  536. class DatabaseInstance extends FunctionalCI
  537. {
  538. public static function Init()
  539. {
  540. $aParams = array
  541. (
  542. "category" => "bizmodel,searchable,configmgmt",
  543. "key_type" => "autoincrement",
  544. "name_attcode" => "name",
  545. "state_attcode" => "",
  546. "reconc_keys" => array("name"),
  547. "db_table" => "databaseinstance",
  548. "db_key_field" => "id",
  549. "db_finalclass_field" => "",
  550. "icon" => "../business/templates/database-instance.png",
  551. );
  552. MetaModel::Init_Params($aParams);
  553. MetaModel::Init_InheritAttributes();
  554. MetaModel::Init_AddAttribute(new AttributeExternalKey("application_id", array("targetclass"=>"ApplicationInstance", "jointype"=>null, "allowed_values"=>null, "sql"=>"application_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  555. MetaModel::Init_AddAttribute(new AttributeExternalField("application_name", array("allowed_values"=>null, "extkey_attcode"=>"application_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  556. MetaModel::Init_AddAttribute(new AttributePassword("admin_login", array("allowed_values"=>null, "sql"=>"admin_login", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  557. MetaModel::Init_AddAttribute(new AttributePassword("admin_password", array("allowed_values"=>null, "sql"=>"admin_password", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  558. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  559. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'application_id', 'admin_login', 'admin_password', 'description'));
  560. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'application_id', 'description'));
  561. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'application_id', 'description'));
  562. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'application_id'));
  563. }
  564. }
  565. class ApplicationSolution extends FunctionalCI
  566. {
  567. public static function Init()
  568. {
  569. $aParams = array
  570. (
  571. "category" => "bizmodel,searchable,configmgmt",
  572. "key_type" => "autoincrement",
  573. "name_attcode" => "name",
  574. "state_attcode" => "",
  575. "reconc_keys" => array("name"),
  576. "db_table" => "applicationsolution",
  577. "db_key_field" => "id",
  578. "db_finalclass_field" => "",
  579. "icon" => "../business/templates/solution.png",
  580. );
  581. MetaModel::Init_Params($aParams);
  582. MetaModel::Init_InheritAttributes();
  583. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  584. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ci_list", array("linked_class"=>"lnkSolutionToCI", "ext_key_to_me"=>"solution_id", "ext_key_to_remote"=>"ci_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  585. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("process_list", array("linked_class"=>"lnkProcessToSolution", "ext_key_to_me"=>"solution_id", "ext_key_to_remote"=>"process_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  586. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'description', 'ci_list', 'process_list'));
  587. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  588. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  589. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'description'));
  590. }
  591. }
  592. class BusinessProcess extends FunctionalCI
  593. {
  594. public static function Init()
  595. {
  596. $aParams = array
  597. (
  598. "category" => "bizmodel,searchable,configmgmt",
  599. "key_type" => "autoincrement",
  600. "name_attcode" => "name",
  601. "state_attcode" => "",
  602. "reconc_keys" => array("name"),
  603. "db_table" => "businessprocess",
  604. "db_key_field" => "id",
  605. "db_finalclass_field" => "",
  606. "icon" => "../business/templates/business-process.png",
  607. );
  608. MetaModel::Init_Params($aParams);
  609. MetaModel::Init_InheritAttributes();
  610. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  611. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("solution_list", array("linked_class"=>"lnkProcessToSolution", "ext_key_to_me"=>"process_id", "ext_key_to_remote"=>"solution_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  612. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'description', 'solution_list'));
  613. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  614. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  615. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'description'));
  616. }
  617. }
  618. class ConnectableCI extends FunctionalCI
  619. {
  620. public static function Init()
  621. {
  622. $aParams = array
  623. (
  624. "category" => "bizmodel,searchable,configmgmt",
  625. "key_type" => "autoincrement",
  626. "name_attcode" => "name",
  627. "state_attcode" => "",
  628. "reconc_keys" => array("name"),
  629. "db_table" => "connectableci",
  630. "db_key_field" => "id",
  631. "db_finalclass_field" => "",
  632. "display_template" => "",
  633. );
  634. MetaModel::Init_Params($aParams);
  635. MetaModel::Init_InheritAttributes();
  636. MetaModel::Init_AddAttribute(new AttributeString("brand", array("allowed_values"=>null, "sql"=>"brand", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  637. MetaModel::Init_AddAttribute(new AttributeString("model", array("allowed_values"=>null, "sql"=>"model", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  638. MetaModel::Init_AddAttribute(new AttributeString("serial_number", array("allowed_values"=>null, "sql"=>"serial_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  639. MetaModel::Init_AddAttribute(new AttributeString("asset_ref", array("allowed_values"=>null, "sql"=>"asset_ref", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  640. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  641. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  642. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  643. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  644. }
  645. }
  646. class NetworkInterface extends ConnectableCI
  647. {
  648. public static function Init()
  649. {
  650. $aParams = array
  651. (
  652. "category" => "bizmodel,searchable,configmgmt",
  653. "key_type" => "autoincrement",
  654. "name_attcode" => "name",
  655. "state_attcode" => "",
  656. "reconc_keys" => array("name"),
  657. "db_table" => "networkinterface",
  658. "db_key_field" => "id",
  659. "db_finalclass_field" => "",
  660. "icon" => "../business/templates/interface.png",
  661. );
  662. MetaModel::Init_Params($aParams);
  663. MetaModel::Init_InheritAttributes();
  664. MetaModel::Init_AddAttribute(new AttributeExternalKey("device_id", array("targetclass"=>"Device", "jointype"=>null, "allowed_values"=>null, "sql"=>"device_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  665. MetaModel::Init_AddAttribute(new AttributeExternalField("device_name", array("allowed_values"=>null, "extkey_attcode"=>"device_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  666. MetaModel::Init_AddAttribute(new AttributeEnum("logical_type", array("allowed_values"=>new ValueSetEnum('backup,logical,port,primary,secondary'), "sql"=>"logical_type", "default_value"=>"primary", "is_null_allowed"=>false, "depends_on"=>array())));
  667. MetaModel::Init_AddAttribute(new AttributeEnum("physical_type", array("allowed_values"=>new ValueSetEnum('atm,ethernet,framerelay,vlan'), "sql"=>"physical_type", "default_value"=>"ethernet", "is_null_allowed"=>false, "depends_on"=>array())));
  668. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_address", array("allowed_values"=>null, "sql"=>"ip_address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  669. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_mask", array("allowed_values"=>null, "sql"=>"ip_mask", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  670. MetaModel::Init_AddAttribute(new AttributeString("mac_address", array("allowed_values"=>null, "sql"=>"mac_address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  671. MetaModel::Init_AddAttribute(new AttributeInteger("speed", array("allowed_values"=>null, "sql"=>"speed", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  672. MetaModel::Init_AddAttribute(new AttributeEnum("duplex", array("allowed_values"=>new ValueSetEnum('full,half,unknown'), "sql"=>"duplex", "default_value"=>"full", "is_null_allowed"=>true, "depends_on"=>array())));
  673. MetaModel::Init_AddAttribute(new AttributeExternalKey("connected_if", array("targetclass"=>"NetworkInterface", "jointype"=>null, "allowed_values"=>null, "sql"=>"connected_if", "is_null_allowed"=>true, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  674. MetaModel::Init_AddAttribute(new AttributeExternalField("connected_name", array("allowed_values"=>null, "extkey_attcode"=>"connected_if", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  675. MetaModel::Init_AddAttribute(new AttributeExternalField("connected_if_device_id", array("allowed_values"=>null, "extkey_attcode"=>"connected_if", "target_attcode"=>"device_id", "is_null_allowed"=>true, "depends_on"=>array())));
  676. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'device_id', 'logical_type', 'physical_type', 'ip_address', 'ip_mask', 'mac_address', 'speed', 'duplex', 'connected_if', 'connected_if_device_id'));
  677. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'device_id', 'logical_type', 'physical_type', 'ip_address', 'ip_mask', 'mac_address', 'speed', 'duplex', 'connected_if', 'connected_if_device_id'));
  678. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'device_id', 'logical_type', 'physical_type', 'ip_address', 'ip_mask', 'mac_address', 'speed', 'duplex', 'connected_if', 'connected_if_device_id'));
  679. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'device_id', 'logical_type', 'physical_type', 'ip_address', 'ip_mask', 'mac_address', 'speed', 'duplex', 'connected_if', 'connected_if_device_id'));
  680. }
  681. }
  682. class Device extends ConnectableCI
  683. {
  684. public static function Init()
  685. {
  686. $aParams = array
  687. (
  688. "category" => "bizmodel,searchable,configmgmt",
  689. "key_type" => "autoincrement",
  690. "name_attcode" => "name",
  691. "state_attcode" => "",
  692. "reconc_keys" => array("name"),
  693. "db_table" => "device",
  694. "db_key_field" => "id",
  695. "db_finalclass_field" => "",
  696. "icon" => "../business/templates/server.png",
  697. );
  698. MetaModel::Init_Params($aParams);
  699. MetaModel::Init_InheritAttributes();
  700. //MetaModel::Init_AddAttribute(new AttributeLinkedSet("application_list", array("linked_class"=>"ApplicationInstance", "ext_key_to_me"=>"device_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  701. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'application_list'));
  702. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  703. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  704. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  705. }
  706. }
  707. class PC extends Device
  708. {
  709. public static function Init()
  710. {
  711. $aParams = array
  712. (
  713. "category" => "bizmodel,searchable,configmgmt",
  714. "key_type" => "autoincrement",
  715. "name_attcode" => "name",
  716. "state_attcode" => "",
  717. "reconc_keys" => array("name"),
  718. "db_table" => "pc",
  719. "db_key_field" => "id",
  720. "db_finalclass_field" => "",
  721. "icon" => "../business/templates/laptop.png",
  722. );
  723. MetaModel::Init_Params($aParams);
  724. MetaModel::Init_InheritAttributes();
  725. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("allowed_values"=>null, "sql"=>"cpu", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  726. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  727. MetaModel::Init_AddAttribute(new AttributeString("hdd", array("allowed_values"=>null, "sql"=>"hdd", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  728. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  729. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  730. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  731. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  732. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  733. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  734. }
  735. }
  736. class MobileCI extends Device
  737. {
  738. public static function Init()
  739. {
  740. $aParams = array
  741. (
  742. "category" => "bizmodel,searchable,configmgmt",
  743. "key_type" => "autoincrement",
  744. "name_attcode" => "name",
  745. "state_attcode" => "",
  746. "reconc_keys" => array("name"),
  747. "db_table" => "mobileci",
  748. "db_key_field" => "id",
  749. "db_finalclass_field" => "",
  750. "icon" => "../business/templates/mobile-phone.png",
  751. );
  752. MetaModel::Init_Params($aParams);
  753. MetaModel::Init_InheritAttributes();
  754. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  755. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  756. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  757. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  758. }
  759. }
  760. class MobilePhone extends MobileCI
  761. {
  762. public static function Init()
  763. {
  764. $aParams = array
  765. (
  766. "category" => "bizmodel,searchable,configmgmt",
  767. "key_type" => "autoincrement",
  768. "name_attcode" => "name",
  769. "state_attcode" => "",
  770. "reconc_keys" => array("name"),
  771. "db_table" => "mobilephone",
  772. "db_key_field" => "id",
  773. "db_finalclass_field" => "",
  774. "icon" => "../business/templates/mobile-phone.png",
  775. );
  776. MetaModel::Init_Params($aParams);
  777. MetaModel::Init_InheritAttributes();
  778. MetaModel::Init_AddAttribute(new AttributeString("number", array("allowed_values"=>null, "sql"=>"number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  779. MetaModel::Init_AddAttribute(new AttributeString("imei", array("allowed_values"=>null, "sql"=>"IMIE", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  780. MetaModel::Init_AddAttribute(new AttributePassword("hw_pin", array("allowed_values"=>null, "sql"=>"hw_pin", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  781. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei', 'hw_pin'));
  782. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei'));
  783. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei'));
  784. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei', 'hw_pin'));
  785. }
  786. }
  787. class InfrastructureCI extends Device
  788. {
  789. public static function Init()
  790. {
  791. $aParams = array
  792. (
  793. "category" => "bizmodel,searchable,configmgmt",
  794. "key_type" => "autoincrement",
  795. "name_attcode" => "name",
  796. "state_attcode" => "",
  797. "reconc_keys" => array("name"),
  798. "db_table" => "infrastructureci",
  799. "db_key_field" => "id",
  800. "db_finalclass_field" => "",
  801. "icon" => "../business/templates/server.png",
  802. );
  803. MetaModel::Init_Params($aParams);
  804. MetaModel::Init_InheritAttributes();
  805. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  806. MetaModel::Init_AddAttribute(new AttributeExternalKey("location_id", array("targetclass"=>"Location", "jointype"=>null, "allowed_values"=>null, "sql"=>"location_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  807. MetaModel::Init_AddAttribute(new AttributeExternalField("location_name", array("allowed_values"=>null, "extkey_attcode"=>"location_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  808. MetaModel::Init_AddAttribute(new AttributeText("location_details", array("allowed_values"=>null, "sql"=>"location_details", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  809. MetaModel::Init_AddAttribute(new AttributeIPAddress("management_ip", array("allowed_values"=>null, "sql"=>"management_ip", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  810. MetaModel::Init_AddAttribute(new AttributeString("default_gateway", array("allowed_values"=>null, "sql"=>"default_gateway", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  811. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway'));
  812. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway'));
  813. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway'));
  814. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway'));
  815. }
  816. }
  817. class NetworkDevice extends InfrastructureCI
  818. {
  819. public static function Init()
  820. {
  821. $aParams = array
  822. (
  823. "category" => "bizmodel,searchable,configmgmt",
  824. "key_type" => "autoincrement",
  825. "name_attcode" => "name",
  826. "state_attcode" => "",
  827. "reconc_keys" => array("name"),
  828. "db_table" => "networkdevice",
  829. "db_key_field" => "id",
  830. "db_finalclass_field" => "",
  831. "display_template" => "",
  832. );
  833. MetaModel::Init_Params($aParams);
  834. MetaModel::Init_InheritAttributes();
  835. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("allowed_values"=>new ValueSetEnum('WANaccelerator,firewall,hub,loadbalancer,router,switch'), "sql"=>"type", "default_value"=>"switch", "is_null_allowed"=>true, "depends_on"=>array())));
  836. MetaModel::Init_AddAttribute(new AttributeString("ios_version", array("allowed_values"=>null, "sql"=>"ios_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  837. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  838. MetaModel::Init_AddAttribute(new AttributePassword("snmp_read", array("allowed_values"=>null, "sql"=>"snmp_read", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  839. MetaModel::Init_AddAttribute(new AttributePassword("snmp_write", array("allowed_values"=>null, "sql"=>"snmp_write", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  840. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'ios_version', 'ram', 'snmp_read', 'snmp_write'));
  841. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'ios_version', 'ram'));
  842. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'ios_version', 'ram'));
  843. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'ios_version', 'ram', 'snmp_read', 'snmp_write'));
  844. }
  845. }
  846. class Server extends InfrastructureCI
  847. {
  848. public static function Init()
  849. {
  850. $aParams = array
  851. (
  852. "category" => "bizmodel,searchable,configmgmt",
  853. "key_type" => "autoincrement",
  854. "name_attcode" => "name",
  855. "state_attcode" => "",
  856. "reconc_keys" => array("name"),
  857. "db_table" => "server",
  858. "db_key_field" => "id",
  859. "db_finalclass_field" => "",
  860. "icon" => "../business/templates/server.png",
  861. );
  862. MetaModel::Init_Params($aParams);
  863. MetaModel::Init_InheritAttributes();
  864. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("allowed_values"=>null, "sql"=>"cpu", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  865. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  866. MetaModel::Init_AddAttribute(new AttributeString("hdd", array("allowed_values"=>null, "sql"=>"hdd", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  867. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  868. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  869. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  870. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  871. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  872. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  873. }
  874. }
  875. class Printer extends InfrastructureCI
  876. {
  877. public static function Init()
  878. {
  879. $aParams = array
  880. (
  881. "category" => "bizmodel,searchable,configmgmt",
  882. "key_type" => "autoincrement",
  883. "name_attcode" => "name",
  884. "state_attcode" => "",
  885. "reconc_keys" => array("name"),
  886. "db_table" => "printer",
  887. "db_key_field" => "id",
  888. "db_finalclass_field" => "",
  889. "icon" => "../business/templates/printer.png",
  890. );
  891. MetaModel::Init_Params($aParams);
  892. MetaModel::Init_InheritAttributes();
  893. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("allowed_values"=>new ValueSetEnum('Mopier,Printer'), "sql"=>"type", "default_value"=>"Printer", "is_null_allowed"=>true, "depends_on"=>array())));
  894. MetaModel::Init_AddAttribute(new AttributeEnum("technology", array("allowed_values"=>new ValueSetEnum('Laser,Inkjet,Tracer'), "sql"=>"technology", "default_value"=>"Laser", "is_null_allowed"=>true, "depends_on"=>array())));
  895. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'technology'));
  896. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'technology'));
  897. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'technology'));
  898. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway', 'type', 'technology'));
  899. }
  900. }
  901. class lnkCIToDoc extends cmdbAbstractObject
  902. {
  903. public static function Init()
  904. {
  905. $aParams = array
  906. (
  907. "category" => "bizmodel,configmgmt",
  908. "key_type" => "autoincrement",
  909. "name_attcode" => "ci_id",
  910. "state_attcode" => "",
  911. "reconc_keys" => array("name"),
  912. "db_table" => "lnkcitodoc",
  913. "db_key_field" => "id",
  914. "db_finalclass_field" => "",
  915. "display_template" => "",
  916. );
  917. MetaModel::Init_Params($aParams);
  918. MetaModel::Init_InheritAttributes();
  919. MetaModel::Init_AddAttribute(new AttributeExternalKey("ci_id", array("targetclass"=>"FunctionalCI", "jointype"=>null, "allowed_values"=>null, "sql"=>"ci_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  920. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_name", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  921. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_status", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"status", "is_null_allowed"=>true, "depends_on"=>array())));
  922. MetaModel::Init_AddAttribute(new AttributeExternalKey("document_id", array("targetclass"=>"Document", "jointype"=>null, "allowed_values"=>null, "sql"=>"document_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  923. MetaModel::Init_AddAttribute(new AttributeExternalField("document_name", array("allowed_values"=>null, "extkey_attcode"=>"document_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  924. MetaModel::Init_AddAttribute(new AttributeExternalField("document_type", array("allowed_values"=>null, "extkey_attcode"=>"document_id", "target_attcode"=>"type", "is_null_allowed"=>true, "depends_on"=>array())));
  925. MetaModel::Init_AddAttribute(new AttributeExternalField("document_status", array("allowed_values"=>null, "extkey_attcode"=>"document_id", "target_attcode"=>"status", "is_null_allowed"=>true, "depends_on"=>array())));
  926. MetaModel::Init_SetZListItems('details', array('ci_id', 'ci_status', 'document_id', 'document_type', 'document_status'));
  927. MetaModel::Init_SetZListItems('advanced_search', array('ci_id', 'document_id'));
  928. MetaModel::Init_SetZListItems('standard_search', array('ci_id', 'document_id'));
  929. MetaModel::Init_SetZListItems('list', array('ci_id', 'ci_status', 'document_id', 'document_type', 'document_status'));
  930. }
  931. }
  932. class lnkCIToContact extends cmdbAbstractObject
  933. {
  934. public static function Init()
  935. {
  936. $aParams = array
  937. (
  938. "category" => "bizmodel,configmgmt",
  939. "key_type" => "autoincrement",
  940. "name_attcode" => "ci_id",
  941. "state_attcode" => "",
  942. "reconc_keys" => array("name"),
  943. "db_table" => "lnkcitocontact",
  944. "db_key_field" => "id",
  945. "db_finalclass_field" => "",
  946. "icon" => "../business/templates/contact.png",
  947. );
  948. MetaModel::Init_Params($aParams);
  949. MetaModel::Init_InheritAttributes();
  950. MetaModel::Init_AddAttribute(new AttributeExternalKey("ci_id", array("targetclass"=>"FunctionalCI", "jointype"=>null, "allowed_values"=>null, "sql"=>"ci_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  951. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_name", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  952. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_status", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"status", "is_null_allowed"=>true, "depends_on"=>array())));
  953. MetaModel::Init_AddAttribute(new AttributeExternalKey("contact_id", array("targetclass"=>"Contact", "jointype"=>null, "allowed_values"=>null, "sql"=>"contact_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  954. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_name", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  955. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_email", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"email", "is_null_allowed"=>true, "depends_on"=>array())));
  956. MetaModel::Init_AddAttribute(new AttributeString("role", array("allowed_values"=>null, "sql"=>"role", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  957. MetaModel::Init_SetZListItems('details', array('ci_id', 'ci_status', 'contact_id', 'contact_email', 'role'));
  958. MetaModel::Init_SetZListItems('advanced_search', array('ci_id', 'contact_id', 'role'));
  959. MetaModel::Init_SetZListItems('standard_search', array('ci_id', 'contact_id', 'role'));
  960. MetaModel::Init_SetZListItems('list', array('ci_id', 'ci_status', 'contact_id', 'contact_email', 'role'));
  961. }
  962. }
  963. class lnkSolutionToCI extends cmdbAbstractObject
  964. {
  965. public static function Init()
  966. {
  967. $aParams = array
  968. (
  969. "category" => "bizmodel,configmgmt",
  970. "key_type" => "autoincrement",
  971. "name_attcode" => "solution_id",
  972. "state_attcode" => "",
  973. "reconc_keys" => array("name"),
  974. "db_table" => "lnksolutiontoci",
  975. "db_key_field" => "id",
  976. "db_finalclass_field" => "",
  977. "display_template" => "",
  978. );
  979. MetaModel::Init_Params($aParams);
  980. MetaModel::Init_InheritAttributes();
  981. MetaModel::Init_AddAttribute(new AttributeExternalKey("solution_id", array("targetclass"=>"ApplicationSolution", "jointype"=>null, "allowed_values"=>null, "sql"=>"solution_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  982. MetaModel::Init_AddAttribute(new AttributeExternalField("solution_name", array("allowed_values"=>null, "extkey_attcode"=>"solution_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  983. MetaModel::Init_AddAttribute(new AttributeExternalKey("ci_id", array("targetclass"=>"FunctionalCI", "jointype"=>null, "allowed_values"=>null, "sql"=>"ci_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  984. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_name", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  985. MetaModel::Init_AddAttribute(new AttributeExternalField("ci_status", array("allowed_values"=>null, "extkey_attcode"=>"ci_id", "target_attcode"=>"status", "is_null_allowed"=>true, "depends_on"=>array())));
  986. MetaModel::Init_AddAttribute(new AttributeString("utility", array("allowed_values"=>null, "sql"=>"utility", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  987. MetaModel::Init_SetZListItems('details', array('solution_id', 'ci_id', 'ci_status', 'utility'));
  988. MetaModel::Init_SetZListItems('advanced_search', array('solution_id', 'ci_id', 'utility'));
  989. MetaModel::Init_SetZListItems('standard_search', array('solution_id', 'ci_id', 'utility'));
  990. MetaModel::Init_SetZListItems('list', array('solution_id', 'ci_id', 'ci_status', 'utility'));
  991. }
  992. }
  993. class lnkProcessToSolution extends cmdbAbstractObject
  994. {
  995. public static function Init()
  996. {
  997. $aParams = array
  998. (
  999. "category" => "bizmodel,configmgmt",
  1000. "key_type" => "autoincrement",
  1001. "name_attcode" => "solution_id",
  1002. "state_attcode" => "",
  1003. "reconc_keys" => array("name"),
  1004. "db_table" => "lnkprocesstosolution",
  1005. "db_key_field" => "id",
  1006. "db_finalclass_field" => "",
  1007. "display_template" => "",
  1008. );
  1009. MetaModel::Init_Params($aParams);
  1010. MetaModel::Init_InheritAttributes();
  1011. MetaModel::Init_AddAttribute(new AttributeExternalKey("solution_id", array("targetclass"=>"ApplicationSolution", "jointype"=>null, "allowed_values"=>null, "sql"=>"solution_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1012. MetaModel::Init_AddAttribute(new AttributeExternalField("solution_name", array("allowed_values"=>null, "extkey_attcode"=>"solution_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  1013. MetaModel::Init_AddAttribute(new AttributeExternalKey("process_id", array("targetclass"=>"BusinessProcess", "jointype"=>null, "allowed_values"=>null, "sql"=>"process_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1014. MetaModel::Init_AddAttribute(new AttributeExternalField("process_name", array("allowed_values"=>null, "extkey_attcode"=>"process_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  1015. MetaModel::Init_AddAttribute(new AttributeString("reason", array("allowed_values"=>null, "sql"=>"reason", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1016. MetaModel::Init_SetZListItems('details', array('solution_id', 'process_id', 'reason'));
  1017. MetaModel::Init_SetZListItems('advanced_search', array('solution_id', 'process_id', 'reason'));
  1018. MetaModel::Init_SetZListItems('standard_search', array('solution_id', 'process_id', 'reason'));
  1019. MetaModel::Init_SetZListItems('list', array('solution_id', 'process_id', 'reason'));
  1020. }
  1021. }
  1022. //////////////////////////////////////////////////////////////////////////////
  1023. // Menu:
  1024. // +----------------------------------------+
  1025. // | My Module |
  1026. // +----------------------------------------+
  1027. // + All items
  1028. // + ...
  1029. // + ...
  1030. ////////////////////////////////////////////////////////////////////////////////////
  1031. // Create the top-level group. fRank = 1, means it will be inserted after the group '0', which is usually 'Welcome'
  1032. $oAdminMenu = new MenuGroup('AdminTools', 999);
  1033. $iAdminGroup = $oAdminMenu->GetIndex();
  1034. new OQLMenuNode('Organization', 'SELECT Organization', $iAdminGroup, 10 /* fRank */);
  1035. new OQLMenuNode('Application', 'SELECT Application', $iAdminGroup, 20 /* fRank */);
  1036. $oToolsMenu = new MenuGroup('AdvancedToolsMenu', 998);
  1037. $iToolsGroup = $oToolsMenu->GetIndex();
  1038. new WebPageMenuNode('Audit', '../pages/audit.php', $iToolsGroup, 33 /* fRank */);
  1039. $oConfigManagementGroup = new MenuGroup('ConfigManagement', 1 /* fRank */);
  1040. // Create an entry, based on a custom template, for the Configuration management overview, under the top-level group
  1041. new TemplateMenuNode('ConfigManagementOverview', '../business/templates/configuration_management_menu.html', $oConfigManagementGroup->GetIndex(), 0 /* fRank */);
  1042. $oContactNode = new TemplateMenuNode('Contact', '../business/templates/contacts_menu.html', $oConfigManagementGroup->GetIndex(), 1 /* fRank */);
  1043. new OQLMenuNode('Person', 'SELECT Person', $oContactNode->GetIndex(), 1 /* fRank */);
  1044. new OQLMenuNode('Team', 'SELECT Team', $oContactNode->GetIndex(), 2 /* fRank */);
  1045. new OQLMenuNode('FileDoc', 'SELECT FileDoc', $oConfigManagementGroup->GetIndex(), 2 /* fRank */);
  1046. new OQLMenuNode('Location', 'SELECT Location', $oConfigManagementGroup->GetIndex(), 3 /* fRank */);
  1047. $oCINode = new TemplateMenuNode('ConfigManagementCI', '../business/templates/configuration_items_menu.html', $oConfigManagementGroup->GetIndex(), 2 /* fRank */);
  1048. new OQLMenuNode('BusinessProcess', 'SELECT BusinessProcess', $oCINode->GetIndex(), 0 /* fRank */);
  1049. new OQLMenuNode('ApplicationSolution', 'SELECT ApplicationSolution', $oCINode->GetIndex(), 1 /* fRank */);
  1050. $oSWNode = new TemplateMenuNode('ConfigManagementSoftware', '', $oCINode->GetIndex(), 2 /* fRank */);
  1051. new OQLMenuNode('Licence', 'SELECT Licence', $oSWNode->GetIndex(), 0 /* fRank */);
  1052. new OQLMenuNode('Patch', 'SELECT Patch', $oSWNode->GetIndex(), 1 /* fRank */);
  1053. new OQLMenuNode('ApplicationInstance', 'SELECT ApplicationInstance', $oSWNode->GetIndex(), 2 /* fRank */);
  1054. new OQLMenuNode('DatabaseInstance', 'SELECT DatabaseInstance', $oSWNode->GetIndex(), 3 /* fRank */);
  1055. $oHWNode = new TemplateMenuNode('ConfigManagementHardware', '', $oCINode->GetIndex(), 3 /* fRank */);
  1056. new OQLMenuNode('Subnet', 'SELECT Subnet', $oHWNode->GetIndex(), 0 /* fRank */);
  1057. new OQLMenuNode('NetworkDevice', 'SELECT NetworkDevice', $oHWNode->GetIndex(), 1 /* fRank */);
  1058. new OQLMenuNode('Server', 'SELECT Server', $oHWNode->GetIndex(), 2 /* fRank */);
  1059. new OQLMenuNode('Printer', 'SELECT Printer', $oHWNode->GetIndex(), 3 /* fRank */);
  1060. new OQLMenuNode('MobilePhone', 'SELECT MobilePhone', $oHWNode->GetIndex(), 4 /* fRank */);
  1061. new OQLMenuNode('PC', 'SELECT PC', $oHWNode->GetIndex(), 5 /* fRank */);
  1062. ?>