model.itop-config-mgmt.php 82 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354
  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. MetaModel::RegisterRelation("impacts", array("description"=>"Objects impacted by", "verb_down"=>"impacts", "verb_up"=>"is impacted by"));
  27. class Organization extends cmdbAbstractObject
  28. {
  29. public static function Init()
  30. {
  31. $aParams = array
  32. (
  33. "category" => "bizmodel,searchable,structure",
  34. "key_type" => "autoincrement",
  35. "name_attcode" => "name",
  36. "state_attcode" => "",
  37. "reconc_keys" => array("name"),
  38. "db_table" => "organization",
  39. "db_key_field" => "id",
  40. "db_finalclass_field" => "",
  41. "display_template" => "",
  42. );
  43. MetaModel::Init_Params($aParams);
  44. MetaModel::Init_InheritAttributes();
  45. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  46. MetaModel::Init_AddAttribute(new AttributeString("code", array("allowed_values"=>null, "sql"=>"code", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  47. 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())));
  48. 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())));
  49. 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())));
  50. MetaModel::Init_SetZListItems('details', array('name', 'code', 'status', 'parent_id'));
  51. MetaModel::Init_SetZListItems('advanced_search', array('name', 'code', 'status'));
  52. MetaModel::Init_SetZListItems('standard_search', array('name', 'code', 'status'));
  53. MetaModel::Init_SetZListItems('list', array('status', 'parent_id'));
  54. }
  55. }
  56. class Location extends cmdbAbstractObject
  57. {
  58. public static function Init()
  59. {
  60. $aParams = array
  61. (
  62. "category" => "bizmodel,searchable,structure",
  63. "key_type" => "autoincrement",
  64. "name_attcode" => "name",
  65. "state_attcode" => "",
  66. "reconc_keys" => array("name"),
  67. "db_table" => "location",
  68. "db_key_field" => "id",
  69. "db_finalclass_field" => "",
  70. "icon" => "../business/templates/location.png",
  71. );
  72. MetaModel::Init_Params($aParams);
  73. MetaModel::Init_InheritAttributes();
  74. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  75. 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())));
  76. 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())));
  77. 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())));
  78. MetaModel::Init_AddAttribute(new AttributeText("address", array("allowed_values"=>null, "sql"=>"address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  79. MetaModel::Init_AddAttribute(new AttributeString("postal_code", array("allowed_values"=>null, "sql"=>"postal_code", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  80. MetaModel::Init_AddAttribute(new AttributeString("city", array("allowed_values"=>null, "sql"=>"city", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  81. MetaModel::Init_AddAttribute(new AttributeString("country", array("allowed_values"=>null, "sql"=>"country", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  82. 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())));
  83. 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())));
  84. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'address', 'postal_code', 'city', 'country', 'parent_id'));
  85. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'country'));
  86. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'city', 'country'));
  87. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'city', 'country'));
  88. }
  89. }
  90. abstract class Contact extends cmdbAbstractObject
  91. {
  92. public static function Init()
  93. {
  94. $aParams = array
  95. (
  96. "category" => "bizmodel,searchable,structure",
  97. "key_type" => "autoincrement",
  98. "name_attcode" => "name",
  99. "state_attcode" => "",
  100. "reconc_keys" => array("name"),
  101. "db_table" => "contact",
  102. "db_key_field" => "id",
  103. "db_finalclass_field" => "",
  104. "icon" => "../business/templates/team.png",
  105. );
  106. MetaModel::Init_Params($aParams);
  107. MetaModel::Init_InheritAttributes();
  108. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  109. 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())));
  110. 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())));
  111. 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())));
  112. MetaModel::Init_AddAttribute(new AttributeEmailAddress("email", array("allowed_values"=>null, "sql"=>"email", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  113. MetaModel::Init_AddAttribute(new AttributeString("phone", array("allowed_values"=>null, "sql"=>"phone", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  114. MetaModel::Init_AddAttribute(new AttributeExternalKey("location_id", array("targetclass"=>"Location", "jointype"=>null, "allowed_values"=>new ValueSetObjects('SELECT Location AS L WHERE L.org_id = :this->org_id'), "sql"=>"location_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array('org_id'))));
  115. 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())));
  116. 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())));
  117. 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())));
  118. 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())));
  119. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("team_list", array("linked_class"=>"lnkTeamToContact", "ext_key_to_me"=>"contact_id", "ext_key_to_remote"=>"team_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  120. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'contract_list', 'ticket_list', 'ci_list', 'team_list'));
  121. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  122. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  123. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id'));
  124. }
  125. }
  126. class Person extends Contact
  127. {
  128. public static function Init()
  129. {
  130. $aParams = array
  131. (
  132. "category" => "bizmodel,searchable,structure",
  133. "key_type" => "autoincrement",
  134. "name_attcode" => "name",
  135. "state_attcode" => "",
  136. "reconc_keys" => array("name"),
  137. "db_table" => "person",
  138. "db_key_field" => "id",
  139. "db_finalclass_field" => "",
  140. "icon" => "../business/templates/person.png",
  141. );
  142. MetaModel::Init_Params($aParams);
  143. MetaModel::Init_InheritAttributes();
  144. MetaModel::Init_AddAttribute(new AttributeString("first_name", array("allowed_values"=>null, "sql"=>"first_name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  145. MetaModel::Init_AddAttribute(new AttributeString("employee_id", array("allowed_values"=>null, "sql"=>"employee_id", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  146. MetaModel::Init_SetZListItems('details', array('first_name', 'name', 'org_id', 'status', 'location_id', 'email', 'phone', 'employee_id', 'contract_list', 'ticket_list', 'ci_list'));
  147. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'first_name', 'employee_id'));
  148. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id', 'first_name', 'employee_id'));
  149. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id', 'employee_id'));
  150. }
  151. public function GetName()
  152. {
  153. return $this->Get('first_name').' '.$this->Get('name');
  154. }
  155. }
  156. class Team extends Contact
  157. {
  158. public static function Init()
  159. {
  160. $aParams = array
  161. (
  162. "category" => "bizmodel,searchable,structure",
  163. "key_type" => "autoincrement",
  164. "name_attcode" => "name",
  165. "state_attcode" => "",
  166. "reconc_keys" => array("name"),
  167. "db_table" => "team",
  168. "db_key_field" => "id",
  169. "db_finalclass_field" => "",
  170. "icon" => "../business/templates/team.png",
  171. );
  172. MetaModel::Init_Params($aParams);
  173. MetaModel::Init_InheritAttributes();
  174. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("member_list", array("linked_class"=>"lnkTeamToContact", "ext_key_to_me"=>"team_id", "ext_key_to_remote"=>"contact_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  175. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'location_id', 'email', 'phone', 'member_list','contract_list', 'ticket_list', 'ci_list'));
  176. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  177. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'org_id', 'email', 'phone', 'location_id'));
  178. MetaModel::Init_SetZListItems('list', array('status', 'org_id', 'email', 'phone', 'location_id'));
  179. }
  180. }
  181. class lnkTeamToContact extends cmdbAbstractObject
  182. {
  183. public static function Init()
  184. {
  185. $aParams = array
  186. (
  187. "category" => "bizmodel,searchable,structure",
  188. "key_type" => "autoincrement",
  189. "name_attcode" => "team_id",
  190. "state_attcode" => "",
  191. "reconc_keys" => array("name"),
  192. "db_table" => "lnk",
  193. "db_key_field" => "id",
  194. "db_finalclass_field" => "",
  195. "display_template" => "",
  196. );
  197. MetaModel::Init_Params($aParams);
  198. MetaModel::Init_InheritAttributes();
  199. MetaModel::Init_AddAttribute(new AttributeExternalKey("team_id", array("targetclass"=>"Team", "jointype"=>null, "allowed_values"=>null, "sql"=>"team_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  200. MetaModel::Init_AddAttribute(new AttributeExternalField("team_name", array("allowed_values"=>null, "extkey_attcode"=>"team_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  201. 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())));
  202. 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())));
  203. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_location_id", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"location_id", "is_null_allowed"=>true, "depends_on"=>array())));
  204. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_location_name", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"location_name", "is_null_allowed"=>true, "depends_on"=>array())));
  205. 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())));
  206. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_phone", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"phone", "is_null_allowed"=>true, "depends_on"=>array())));
  207. MetaModel::Init_SetZListItems('details', array('team_id', 'contact_id'));
  208. MetaModel::Init_SetZListItems('advanced_search', array('team_id', 'contact_id'));
  209. MetaModel::Init_SetZListItems('standard_search', array('team_id', 'contact_id'));
  210. MetaModel::Init_SetZListItems('list', array('team_id', 'contact_id', 'contact_location_id', 'contact_email', 'contact_phone'));
  211. }
  212. }
  213. abstract class Document extends cmdbAbstractObject
  214. {
  215. public static function Init()
  216. {
  217. $aParams = array
  218. (
  219. "category" => "bizmodel,searchable,documentation",
  220. "key_type" => "autoincrement",
  221. "name_attcode" => "name",
  222. "state_attcode" => "",
  223. "reconc_keys" => array("name"),
  224. "db_table" => "document",
  225. "db_key_field" => "id",
  226. "db_finalclass_field" => "",
  227. "icon" => "../business/templates/document.png",
  228. );
  229. MetaModel::Init_Params($aParams);
  230. MetaModel::Init_InheritAttributes();
  231. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  232. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  233. 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())));
  234. 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())));
  235. 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())));
  236. 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())));
  237. 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())));
  238. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list'));
  239. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status'));
  240. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status'));
  241. MetaModel::Init_SetZListItems('list', array('type', 'status'));
  242. }
  243. }
  244. class ExternalDoc extends Document
  245. {
  246. public static function Init()
  247. {
  248. $aParams = array
  249. (
  250. "category" => "bizmodel,searchable,documentation",
  251. "key_type" => "autoincrement",
  252. "name_attcode" => "name",
  253. "state_attcode" => "",
  254. "reconc_keys" => array("name"),
  255. "db_table" => "externaldoc",
  256. "db_key_field" => "id",
  257. "db_finalclass_field" => "",
  258. "icon" => "../business/templates/document.png",
  259. );
  260. MetaModel::Init_Params($aParams);
  261. MetaModel::Init_InheritAttributes();
  262. MetaModel::Init_AddAttribute(new AttributeURL("url", array("target"=>"_blank", "allowed_values"=>null, "sql"=>"url", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  263. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'url'));
  264. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status', 'url'));
  265. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status', 'url'));
  266. MetaModel::Init_SetZListItems('list', array('type', 'status', 'url'));
  267. }
  268. }
  269. class Note extends Document
  270. {
  271. public static function Init()
  272. {
  273. $aParams = array
  274. (
  275. "category" => "bizmodel,searchable,documentation",
  276. "key_type" => "autoincrement",
  277. "name_attcode" => "name",
  278. "state_attcode" => "",
  279. "reconc_keys" => array("name"),
  280. "db_table" => "note",
  281. "db_key_field" => "id",
  282. "db_finalclass_field" => "",
  283. "icon" => "../business/templates/document.png",
  284. );
  285. MetaModel::Init_Params($aParams);
  286. MetaModel::Init_InheritAttributes();
  287. MetaModel::Init_AddAttribute(new AttributeWikiText("note", array("allowed_values"=>null, "sql"=>"note", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  288. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'note'));
  289. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status', 'note'));
  290. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status', 'note'));
  291. MetaModel::Init_SetZListItems('list', array('type', 'status', 'note'));
  292. }
  293. }
  294. class FileDoc extends Document
  295. {
  296. public static function Init()
  297. {
  298. $aParams = array
  299. (
  300. "category" => "bizmodel,searchable,documentation",
  301. "key_type" => "autoincrement",
  302. "name_attcode" => "name",
  303. "state_attcode" => "",
  304. "reconc_keys" => array("name"),
  305. "db_table" => "filedoc",
  306. "db_key_field" => "id",
  307. "db_finalclass_field" => "",
  308. "icon" => "../business/templates/document.png",
  309. );
  310. MetaModel::Init_Params($aParams);
  311. MetaModel::Init_InheritAttributes();
  312. MetaModel::Init_AddAttribute(new AttributeBlob("contents", array("depends_on"=>array())));
  313. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'contract_list', 'ticket_list', 'ci_list', 'contents'));
  314. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status'));
  315. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status'));
  316. MetaModel::Init_SetZListItems('list', array('type', 'status', 'contents'));
  317. }
  318. /**
  319. * Overload the display of the properties to add a tab (the first one)
  320. * with the preview of the document
  321. */
  322. public function DisplayBareProperties(WebPage $oPage)
  323. {
  324. $oPage->SetCurrentTab(Dict::S('Class:Document:PreviewTab'));
  325. $oPage->add($this->DisplayDocumentInline($oPage, 'contents'));
  326. $oPage->SetCurrentTab(Dict::S('UI:PropertiesTab'));
  327. parent::DisplayBareProperties($oPage);
  328. }
  329. }
  330. class Licence extends cmdbAbstractObject
  331. {
  332. public static function Init()
  333. {
  334. $aParams = array
  335. (
  336. "category" => "bizmodel,searchable,configmgmt",
  337. "key_type" => "autoincrement",
  338. "name_attcode" => "provider",
  339. "state_attcode" => "",
  340. "reconc_keys" => array("name"),
  341. "db_table" => "licence",
  342. "db_key_field" => "id",
  343. "db_finalclass_field" => "",
  344. "icon" => "../business/templates/licence.png",
  345. );
  346. MetaModel::Init_Params($aParams);
  347. MetaModel::Init_InheritAttributes();
  348. MetaModel::Init_AddAttribute(new AttributeString("provider", array("allowed_values"=>null, "sql"=>"provider", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  349. MetaModel::Init_AddAttribute(new AttributeString("product", array("allowed_values"=>null, "sql"=>"product", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  350. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  351. MetaModel::Init_AddAttribute(new AttributeDate("start", array("allowed_values"=>null, "sql"=>"start", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  352. MetaModel::Init_AddAttribute(new AttributeDate("end", array("allowed_values"=>null, "sql"=>"end", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  353. MetaModel::Init_AddAttribute(new AttributeString("key", array("allowed_values"=>null, "sql"=>"key", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  354. MetaModel::Init_AddAttribute(new AttributeText("scope", array("allowed_values"=>null, "sql"=>"scope", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  355. MetaModel::Init_SetZListItems('details', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  356. MetaModel::Init_SetZListItems('advanced_search', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  357. MetaModel::Init_SetZListItems('standard_search', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  358. MetaModel::Init_SetZListItems('list', array('provider', 'product', 'name', 'start', 'end', 'key', 'scope'));
  359. }
  360. }
  361. class Subnet extends cmdbAbstractObject
  362. {
  363. public static function Init()
  364. {
  365. $aParams = array
  366. (
  367. "category" => "bizmodel,searchable,configmgmt",
  368. "key_type" => "autoincrement",
  369. "name_attcode" => "name",
  370. "state_attcode" => "",
  371. "reconc_keys" => array("name"),
  372. "db_table" => "subnet",
  373. "db_key_field" => "id",
  374. "db_finalclass_field" => "",
  375. "icon" => "../business/templates/subnet.png",
  376. );
  377. MetaModel::Init_Params($aParams);
  378. MetaModel::Init_InheritAttributes();
  379. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  380. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  381. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip", array("allowed_values"=>null, "sql"=>"ip", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  382. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_mask", array("allowed_values"=>null, "sql"=>"ip_mask", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  383. MetaModel::Init_SetZListItems('details', array('name', 'description', 'ip', 'ip_mask'));
  384. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'ip', 'ip_mask'));
  385. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'ip', 'ip_mask'));
  386. MetaModel::Init_SetZListItems('list', array('description', 'ip', 'ip_mask'));
  387. }
  388. public function ComputeValues()
  389. {
  390. $sName = $this->Get('ip').'/'.$this->Get('ip_mask');
  391. $this->Set('name', $sName);
  392. }
  393. function DisplayBareRelations(WebPage $oPage)
  394. {
  395. parent::DisplayBareRelations($oPage);
  396. $oPage->SetCurrentTab(Dict::S('Class:Subnet/Tab:IPUsage'));
  397. $bit_ip = ip2long($this->Get('ip'));
  398. $bit_mask = ip2long($this->Get('ip_mask'));
  399. $iIPMin = $bit_ip & $bit_mask;
  400. $iIPMax = ($bit_ip | (~$bit_mask)) - 1;
  401. $sIPMin = long2ip($iIPMin);
  402. $sIPMax = long2ip($iIPMax);
  403. $oPage->p(Dict::Format('Class:Subnet/Tab:IPUsage-explain', $sIPMin, $sIPMax));
  404. $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')"));
  405. self::DisplaySet($oPage, $oIfSet);
  406. $iCountUsed = $oIfSet->Count();
  407. $iCountRange = $iIPMax - $iIPMin;
  408. $iFreeCount = $iCountRange - $iCountUsed;
  409. $oPage->SetCurrentTab(Dict::S('Class:Subnet/Tab:FreeIPs'));
  410. $oPage->p(Dict::Format('Class:Subnet/Tab:FreeIPs-count', $iFreeCount));
  411. $oPage->p(Dict::S('Class:Subnet/Tab:FreeIPs-explain'));
  412. $aUsedIPs = $oIfSet->GetColumnAsArray('ip_address', false);
  413. $iAnIP = $iIPMin;
  414. $iFound = 0;
  415. while (($iFound < min($iFreeCount, 10)) && ($iAnIP <= $iIPMax))
  416. {
  417. $sAnIP = long2ip($iAnIP);
  418. if (!in_array($sAnIP, $aUsedIPs))
  419. {
  420. $iFound++;
  421. $oPage->p($sAnIP);
  422. }
  423. else
  424. {
  425. }
  426. $iAnIP++;
  427. }
  428. }
  429. }
  430. class Patch extends cmdbAbstractObject
  431. {
  432. public static function Init()
  433. {
  434. $aParams = array
  435. (
  436. "category" => "bizmodel,searchable,configmgmt",
  437. "key_type" => "autoincrement",
  438. "name_attcode" => "name",
  439. "state_attcode" => "",
  440. "reconc_keys" => array("name"),
  441. "db_table" => "patch",
  442. "db_key_field" => "id",
  443. "db_finalclass_field" => "",
  444. "icon" => "../business/templates/patch.png",
  445. );
  446. MetaModel::Init_Params($aParams);
  447. MetaModel::Init_InheritAttributes();
  448. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  449. MetaModel::Init_AddAttribute(new AttributeString("target_sw", array("allowed_values"=>null, "sql"=>"target_sw", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  450. MetaModel::Init_AddAttribute(new AttributeString("version", array("allowed_values"=>null, "sql"=>"version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  451. 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())));
  452. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ci_list", array("linked_class"=>"lnkPatchToCI", "ext_key_to_me"=>"patch_id", "ext_key_to_remote"=>"ci_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  453. MetaModel::Init_SetZListItems('details', array('name', 'target_sw', 'version', 'type', 'ci_list'));
  454. MetaModel::Init_SetZListItems('advanced_search', array('name', 'target_sw', 'version', 'type'));
  455. MetaModel::Init_SetZListItems('standard_search', array('name', 'target_sw', 'version', 'type'));
  456. MetaModel::Init_SetZListItems('list', array('target_sw', 'version', 'type'));
  457. }
  458. }
  459. class Application extends cmdbAbstractObject
  460. {
  461. public static function Init()
  462. {
  463. $aParams = array
  464. (
  465. "category" => "bizmodel,searchable,configmgmt",
  466. "key_type" => "autoincrement",
  467. "name_attcode" => "name",
  468. "state_attcode" => "",
  469. "reconc_keys" => array("name"),
  470. "db_table" => "application",
  471. "db_key_field" => "id",
  472. "db_finalclass_field" => "",
  473. "icon" => "../business/templates/software.png",
  474. );
  475. MetaModel::Init_Params($aParams);
  476. MetaModel::Init_InheritAttributes();
  477. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  478. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  479. MetaModel::Init_AddAttribute(new AttributeLinkedSet("instance_list", array("linked_class"=>"ApplicationInstance", "ext_key_to_me"=>"application_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  480. MetaModel::Init_SetZListItems('details', array('name', 'description', 'instance_list'));
  481. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description'));
  482. MetaModel::Init_SetZListItems('standard_search', array('name', 'description'));
  483. MetaModel::Init_SetZListItems('list', array('description'));
  484. }
  485. }
  486. class DBServer extends Application
  487. {
  488. public static function Init()
  489. {
  490. $aParams = array
  491. (
  492. "category" => "bizmodel,searchable,configmgmt",
  493. "key_type" => "autoincrement",
  494. "name_attcode" => "name",
  495. "state_attcode" => "",
  496. "reconc_keys" => array("name"),
  497. "db_table" => "application_db",
  498. "db_key_field" => "id",
  499. "db_finalclass_field" => "",
  500. "icon" => "../business/templates/software.png",
  501. );
  502. MetaModel::Init_Params($aParams);
  503. MetaModel::Init_InheritAttributes();
  504. MetaModel::Init_SetZListItems('details', array('name', 'description', 'instance_list'));
  505. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description'));
  506. MetaModel::Init_SetZListItems('standard_search', array('name', 'description'));
  507. MetaModel::Init_SetZListItems('list', array('description'));
  508. }
  509. }
  510. class OperatingSystem extends Application
  511. {
  512. public static function Init()
  513. {
  514. $aParams = array
  515. (
  516. "category" => "bizmodel,searchable,configmgmt",
  517. "key_type" => "autoincrement",
  518. "name_attcode" => "name",
  519. "state_attcode" => "",
  520. "reconc_keys" => array("name"),
  521. "db_table" => "application_os",
  522. "db_key_field" => "id",
  523. "db_finalclass_field" => "",
  524. "icon" => "../business/templates/software.png",
  525. );
  526. MetaModel::Init_Params($aParams);
  527. MetaModel::Init_InheritAttributes();
  528. MetaModel::Init_SetZListItems('details', array('name', 'description', 'instance_list'));
  529. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description'));
  530. MetaModel::Init_SetZListItems('standard_search', array('name', 'description'));
  531. MetaModel::Init_SetZListItems('list', array('description'));
  532. }
  533. }
  534. class lnkPatchToCI extends cmdbAbstractObject
  535. {
  536. public static function Init()
  537. {
  538. $aParams = array
  539. (
  540. "category" => "bizmodel,configmgmt",
  541. "key_type" => "autoincrement",
  542. "name_attcode" => "patch_id",
  543. "state_attcode" => "",
  544. "reconc_keys" => array("name"),
  545. "db_table" => "lnkpatchtoci",
  546. "db_key_field" => "id",
  547. "db_finalclass_field" => "",
  548. "display_template" => "",
  549. );
  550. MetaModel::Init_Params($aParams);
  551. MetaModel::Init_InheritAttributes();
  552. 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())));
  553. 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())));
  554. 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())));
  555. 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())));
  556. 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())));
  557. MetaModel::Init_SetZListItems('details', array('patch_id', 'ci_id', 'ci_status'));
  558. MetaModel::Init_SetZListItems('advanced_search', array('patch_id', 'ci_id'));
  559. MetaModel::Init_SetZListItems('standard_search', array('patch_id', 'ci_id'));
  560. MetaModel::Init_SetZListItems('list', array('patch_id', 'ci_id', 'ci_status'));
  561. }
  562. }
  563. abstract class FunctionalCI extends cmdbAbstractObject
  564. {
  565. public static function Init()
  566. {
  567. $aParams = array
  568. (
  569. "category" => "bizmodel,searchable,configmgmt",
  570. "key_type" => "autoincrement",
  571. "name_attcode" => "name",
  572. "state_attcode" => "",
  573. "reconc_keys" => array("name"),
  574. "db_table" => "functionalci",
  575. "db_key_field" => "id",
  576. "db_finalclass_field" => "",
  577. "icon" => "../business/templates/server.png",
  578. );
  579. MetaModel::Init_Params($aParams);
  580. MetaModel::Init_InheritAttributes();
  581. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  582. 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())));
  583. 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())));
  584. 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())));
  585. 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())));
  586. 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())));
  587. 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())));
  588. 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())));
  589. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'contact_list', 'document_list', 'solution_list'));
  590. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance'));
  591. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance'));
  592. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance'));
  593. }
  594. public static function GetRelationQueries($sRelCode)
  595. {
  596. switch ($sRelCode)
  597. {
  598. case "impacts":
  599. $aRels = array(
  600. "contact" => array("sQuery"=>"SELECT Contact AS c JOIN lnkCIToContact AS l1 ON l1.contact_id = c.id WHERE l1.ci_id = :this->id", "bPropagate"=>true, "iDistance"=>3),
  601. "solution" => array("sQuery"=>"SELECT ApplicationSolution AS s JOIN lnkSolutionToCI AS l1 ON l1.solution_id = s.id WHERE l1.ci_id = :this->id", "bPropagate"=>true, "iDistance"=>2),
  602. );
  603. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  604. }
  605. }
  606. }
  607. class ApplicationInstance extends FunctionalCI
  608. {
  609. public static function Init()
  610. {
  611. $aParams = array
  612. (
  613. "category" => "bizmodel,searchable,configmgmt",
  614. "key_type" => "autoincrement",
  615. "name_attcode" => "name",
  616. "state_attcode" => "",
  617. "reconc_keys" => array("name"),
  618. "db_table" => "applicationinstance",
  619. "db_key_field" => "id",
  620. "db_finalclass_field" => "",
  621. "icon" => "../business/templates/application.png",
  622. );
  623. MetaModel::Init_Params($aParams);
  624. MetaModel::Init_InheritAttributes();
  625. 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())));
  626. 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())));
  627. 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())));
  628. 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())));
  629. 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())));
  630. 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())));
  631. MetaModel::Init_AddAttribute(new AttributeString("version", array("allowed_values"=>null, "sql"=>"version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  632. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  633. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  634. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  635. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  636. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'device_id', 'licence_id', 'application_id', 'version', 'description'));
  637. }
  638. public static function GetRelationQueries($sRelCode)
  639. {
  640. switch ($sRelCode)
  641. {
  642. case "impacts":
  643. $aRels = array(
  644. // Actually this should be limited to the ApplicationInstances based on a DBServer Application type...
  645. "db_instances" => array("sQuery"=>"SELECT DatabaseInstance AS db WHERE db.db_server_instance_id = :this->id", "bPropagate"=>true, "iDistance"=>5),
  646. );
  647. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  648. }
  649. }
  650. }
  651. class DatabaseInstance extends FunctionalCI
  652. {
  653. public static function Init()
  654. {
  655. $aParams = array
  656. (
  657. "category" => "bizmodel,searchable,configmgmt",
  658. "key_type" => "autoincrement",
  659. "name_attcode" => "name",
  660. "state_attcode" => "",
  661. "reconc_keys" => array("name"),
  662. "db_table" => "databaseinstance",
  663. "db_key_field" => "id",
  664. "db_finalclass_field" => "",
  665. "icon" => "../business/templates/database-instance.png",
  666. );
  667. MetaModel::Init_Params($aParams);
  668. MetaModel::Init_InheritAttributes();
  669. MetaModel::Init_AddAttribute(new AttributeExternalKey("db_server_instance_id", array("targetclass"=>"ApplicationInstance", "jointype"=>null, "allowed_values"=>new ValueSetObjects('SELECT ApplicationInstance AS DBSrvInstance JOIN DBServer AS DBServerSW ON DBSrvInstance.application_id = DBServerSW.id WHERE DBServerSW.finalclass=\'DBServer\''), "sql"=>"db_server_instance_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  670. MetaModel::Init_AddAttribute(new AttributeExternalField("db_server_instance_name", array("allowed_values"=>null, "extkey_attcode"=>"db_server_instance_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  671. MetaModel::Init_AddAttribute(new AttributeExternalField("db_server_instance_version", array("allowed_values"=>null, "extkey_attcode"=>"db_server_instance_id", "target_attcode"=>"version", "is_null_allowed"=>true, "depends_on"=>array())));
  672. MetaModel::Init_AddAttribute(new AttributePassword("admin_login", array("allowed_values"=>null, "sql"=>"admin_login", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  673. MetaModel::Init_AddAttribute(new AttributePassword("admin_password", array("allowed_values"=>null, "sql"=>"admin_password", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  674. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  675. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'db_server_instance_id', 'db_server_instance_version', 'admin_login', 'admin_password', 'description'));
  676. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'db_server_instance_id', 'db_server_instance_version', 'description'));
  677. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'db_server_instance_id', 'db_server_instance_version', 'description'));
  678. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'db_server_instance_id', 'db_server_instance_version'));
  679. }
  680. }
  681. class ApplicationSolution extends FunctionalCI
  682. {
  683. public static function Init()
  684. {
  685. $aParams = array
  686. (
  687. "category" => "bizmodel,searchable,configmgmt",
  688. "key_type" => "autoincrement",
  689. "name_attcode" => "name",
  690. "state_attcode" => "",
  691. "reconc_keys" => array("name"),
  692. "db_table" => "applicationsolution",
  693. "db_key_field" => "id",
  694. "db_finalclass_field" => "",
  695. "icon" => "../business/templates/solution.png",
  696. );
  697. MetaModel::Init_Params($aParams);
  698. MetaModel::Init_InheritAttributes();
  699. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  700. 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())));
  701. 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())));
  702. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'description', 'ci_list', 'process_list'));
  703. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  704. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  705. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'description'));
  706. }
  707. public static function GetRelationQueries($sRelCode)
  708. {
  709. switch ($sRelCode)
  710. {
  711. case "impacts":
  712. $aRels = array(
  713. "process" => array("sQuery"=>"SELECT BusinessProcess AS p JOIN lnkProcessToSolution AS l1 ON l1.process_id = p.id WHERE l1.solution_id = :this->id", "bPropagate"=>true, "iDistance"=>3),
  714. );
  715. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  716. }
  717. }
  718. }
  719. class BusinessProcess extends FunctionalCI
  720. {
  721. public static function Init()
  722. {
  723. $aParams = array
  724. (
  725. "category" => "bizmodel,searchable,configmgmt",
  726. "key_type" => "autoincrement",
  727. "name_attcode" => "name",
  728. "state_attcode" => "",
  729. "reconc_keys" => array("name"),
  730. "db_table" => "businessprocess",
  731. "db_key_field" => "id",
  732. "db_finalclass_field" => "",
  733. "icon" => "../business/templates/business-process.png",
  734. );
  735. MetaModel::Init_Params($aParams);
  736. MetaModel::Init_InheritAttributes();
  737. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  738. 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())));
  739. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'description', 'solution_list'));
  740. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  741. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'description'));
  742. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'description'));
  743. }
  744. }
  745. abstract class ConnectableCI extends FunctionalCI
  746. {
  747. public static function Init()
  748. {
  749. $aParams = array
  750. (
  751. "category" => "bizmodel,searchable,configmgmt",
  752. "key_type" => "autoincrement",
  753. "name_attcode" => "name",
  754. "state_attcode" => "",
  755. "reconc_keys" => array("name"),
  756. "db_table" => "connectableci",
  757. "db_key_field" => "id",
  758. "db_finalclass_field" => "",
  759. "display_template" => "",
  760. );
  761. MetaModel::Init_Params($aParams);
  762. MetaModel::Init_InheritAttributes();
  763. MetaModel::Init_AddAttribute(new AttributeString("brand", array("allowed_values"=>null, "sql"=>"brand", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  764. MetaModel::Init_AddAttribute(new AttributeString("model", array("allowed_values"=>null, "sql"=>"model", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  765. MetaModel::Init_AddAttribute(new AttributeString("serial_number", array("allowed_values"=>null, "sql"=>"serial_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  766. MetaModel::Init_AddAttribute(new AttributeString("asset_ref", array("allowed_values"=>null, "sql"=>"asset_ref", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  767. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  768. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  769. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  770. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  771. }
  772. }
  773. class NetworkInterface extends ConnectableCI
  774. {
  775. public static function Init()
  776. {
  777. $aParams = array
  778. (
  779. "category" => "bizmodel,searchable,configmgmt",
  780. "key_type" => "autoincrement",
  781. "name_attcode" => "name",
  782. "state_attcode" => "",
  783. "reconc_keys" => array("name"),
  784. "db_table" => "networkinterface",
  785. "db_key_field" => "id",
  786. "db_finalclass_field" => "",
  787. "icon" => "../business/templates/interface.png",
  788. );
  789. MetaModel::Init_Params($aParams);
  790. MetaModel::Init_InheritAttributes();
  791. 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())));
  792. 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())));
  793. 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())));
  794. 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())));
  795. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_address", array("allowed_values"=>null, "sql"=>"ip_address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  796. MetaModel::Init_AddAttribute(new AttributeIPAddress("ip_mask", array("allowed_values"=>null, "sql"=>"ip_mask", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  797. MetaModel::Init_AddAttribute(new AttributeString("mac_address", array("allowed_values"=>null, "sql"=>"mac_address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  798. MetaModel::Init_AddAttribute(new AttributeInteger("speed", array("allowed_values"=>null, "sql"=>"speed", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  799. 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())));
  800. 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())));
  801. 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())));
  802. 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())));
  803. 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'));
  804. 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'));
  805. 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'));
  806. 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'));
  807. }
  808. }
  809. abstract class Device extends ConnectableCI
  810. {
  811. public static function Init()
  812. {
  813. $aParams = array
  814. (
  815. "category" => "bizmodel,searchable,configmgmt",
  816. "key_type" => "autoincrement",
  817. "name_attcode" => "name",
  818. "state_attcode" => "",
  819. "reconc_keys" => array("name"),
  820. "db_table" => "device",
  821. "db_key_field" => "id",
  822. "db_finalclass_field" => "",
  823. "icon" => "../business/templates/server.png",
  824. );
  825. MetaModel::Init_Params($aParams);
  826. MetaModel::Init_InheritAttributes();
  827. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'application_list'));
  828. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  829. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  830. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  831. }
  832. public static function GetRelationQueries($sRelCode)
  833. {
  834. switch ($sRelCode)
  835. {
  836. case "impacts":
  837. $aRels = array(
  838. "applications" => array("sQuery"=>"SELECT ApplicationInstance AS app WHERE app.device_id = :this->id", "bPropagate"=>true, "iDistance"=>5),
  839. );
  840. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  841. }
  842. }
  843. }
  844. class PC extends Device
  845. {
  846. public static function Init()
  847. {
  848. $aParams = array
  849. (
  850. "category" => "bizmodel,searchable,configmgmt",
  851. "key_type" => "autoincrement",
  852. "name_attcode" => "name",
  853. "state_attcode" => "",
  854. "reconc_keys" => array("name"),
  855. "db_table" => "pc",
  856. "db_key_field" => "id",
  857. "db_finalclass_field" => "",
  858. "icon" => "../business/templates/laptop.png",
  859. );
  860. MetaModel::Init_Params($aParams);
  861. MetaModel::Init_InheritAttributes();
  862. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("allowed_values"=>null, "sql"=>"cpu", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  863. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  864. MetaModel::Init_AddAttribute(new AttributeString("hdd", array("allowed_values"=>null, "sql"=>"hdd", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  865. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  866. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  867. 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())));
  868. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("patch_list", array("linked_class"=>"lnkPatchToCI", "ext_key_to_me"=>"ci_id", "ext_key_to_remote"=>"patch_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  869. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version', 'application_list', 'patch_list'));
  870. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', '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', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  872. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'cpu', 'ram', 'hdd', 'os_family', 'os_version'));
  873. }
  874. }
  875. abstract class MobileCI extends Device
  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" => "mobileci",
  887. "db_key_field" => "id",
  888. "db_finalclass_field" => "",
  889. "icon" => "../business/templates/mobile-phone.png",
  890. );
  891. MetaModel::Init_Params($aParams);
  892. MetaModel::Init_InheritAttributes();
  893. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  894. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  895. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  896. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref'));
  897. }
  898. }
  899. class MobilePhone extends MobileCI
  900. {
  901. public static function Init()
  902. {
  903. $aParams = array
  904. (
  905. "category" => "bizmodel,searchable,configmgmt",
  906. "key_type" => "autoincrement",
  907. "name_attcode" => "name",
  908. "state_attcode" => "",
  909. "reconc_keys" => array("name"),
  910. "db_table" => "mobilephone",
  911. "db_key_field" => "id",
  912. "db_finalclass_field" => "",
  913. "icon" => "../business/templates/mobile-phone.png",
  914. );
  915. MetaModel::Init_Params($aParams);
  916. MetaModel::Init_InheritAttributes();
  917. MetaModel::Init_AddAttribute(new AttributeString("number", array("allowed_values"=>null, "sql"=>"number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  918. MetaModel::Init_AddAttribute(new AttributeString("imei", array("allowed_values"=>null, "sql"=>"IMIE", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  919. MetaModel::Init_AddAttribute(new AttributePassword("hw_pin", array("allowed_values"=>null, "sql"=>"hw_pin", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  920. MetaModel::Init_SetZListItems('details', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei', 'hw_pin'));
  921. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei'));
  922. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei'));
  923. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'number', 'imei', 'hw_pin'));
  924. }
  925. }
  926. abstract class InfrastructureCI extends Device
  927. {
  928. public static function Init()
  929. {
  930. $aParams = array
  931. (
  932. "category" => "bizmodel,searchable,configmgmt",
  933. "key_type" => "autoincrement",
  934. "name_attcode" => "name",
  935. "state_attcode" => "",
  936. "reconc_keys" => array("name"),
  937. "db_table" => "infrastructureci",
  938. "db_key_field" => "id",
  939. "db_finalclass_field" => "",
  940. "icon" => "../business/templates/server.png",
  941. );
  942. MetaModel::Init_Params($aParams);
  943. MetaModel::Init_InheritAttributes();
  944. MetaModel::Init_AddAttribute(new AttributeWikiText("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  945. 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())));
  946. 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())));
  947. MetaModel::Init_AddAttribute(new AttributeText("location_details", array("allowed_values"=>null, "sql"=>"location_details", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  948. MetaModel::Init_AddAttribute(new AttributeIPAddress("management_ip", array("allowed_values"=>null, "sql"=>"management_ip", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  949. MetaModel::Init_AddAttribute(new AttributeString("default_gateway", array("allowed_values"=>null, "sql"=>"default_gateway", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  950. 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'));
  951. 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'));
  952. 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'));
  953. MetaModel::Init_SetZListItems('list', array('status', 'owner_id', 'importance', 'brand', 'model', 'serial_number', 'asset_ref', 'description', 'location_id', 'location_details', 'management_ip', 'default_gateway'));
  954. }
  955. }
  956. class NetworkDevice extends InfrastructureCI
  957. {
  958. public static function Init()
  959. {
  960. $aParams = array
  961. (
  962. "category" => "bizmodel,searchable,configmgmt",
  963. "key_type" => "autoincrement",
  964. "name_attcode" => "name",
  965. "state_attcode" => "",
  966. "reconc_keys" => array("name"),
  967. "db_table" => "networkdevice",
  968. "db_key_field" => "id",
  969. "db_finalclass_field" => "",
  970. "display_template" => "",
  971. );
  972. MetaModel::Init_Params($aParams);
  973. MetaModel::Init_InheritAttributes();
  974. 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())));
  975. MetaModel::Init_AddAttribute(new AttributeString("ios_version", array("allowed_values"=>null, "sql"=>"ios_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  976. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  977. MetaModel::Init_AddAttribute(new AttributePassword("snmp_read", array("allowed_values"=>null, "sql"=>"snmp_read", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  978. MetaModel::Init_AddAttribute(new AttributePassword("snmp_write", array("allowed_values"=>null, "sql"=>"snmp_write", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  979. 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'));
  980. 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'));
  981. 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'));
  982. 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'));
  983. }
  984. }
  985. class Server extends InfrastructureCI
  986. {
  987. public static function Init()
  988. {
  989. $aParams = array
  990. (
  991. "category" => "bizmodel,searchable,configmgmt",
  992. "key_type" => "autoincrement",
  993. "name_attcode" => "name",
  994. "state_attcode" => "",
  995. "reconc_keys" => array("name"),
  996. "db_table" => "server",
  997. "db_key_field" => "id",
  998. "db_finalclass_field" => "",
  999. "icon" => "../business/templates/server.png",
  1000. );
  1001. MetaModel::Init_Params($aParams);
  1002. MetaModel::Init_InheritAttributes();
  1003. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("allowed_values"=>null, "sql"=>"cpu", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1004. MetaModel::Init_AddAttribute(new AttributeString("ram", array("allowed_values"=>null, "sql"=>"ram", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1005. MetaModel::Init_AddAttribute(new AttributeString("hdd", array("allowed_values"=>null, "sql"=>"hdd", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1006. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1007. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1008. 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())));
  1009. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("patch_list", array("linked_class"=>"lnkPatchToCI", "ext_key_to_me"=>"ci_id", "ext_key_to_remote"=>"patch_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  1010. 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', 'application_list', 'patch_list'));
  1011. 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'));
  1012. 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'));
  1013. 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'));
  1014. }
  1015. }
  1016. class Printer extends InfrastructureCI
  1017. {
  1018. public static function Init()
  1019. {
  1020. $aParams = array
  1021. (
  1022. "category" => "bizmodel,searchable,configmgmt",
  1023. "key_type" => "autoincrement",
  1024. "name_attcode" => "name",
  1025. "state_attcode" => "",
  1026. "reconc_keys" => array("name"),
  1027. "db_table" => "printer",
  1028. "db_key_field" => "id",
  1029. "db_finalclass_field" => "",
  1030. "icon" => "../business/templates/printer.png",
  1031. );
  1032. MetaModel::Init_Params($aParams);
  1033. MetaModel::Init_InheritAttributes();
  1034. 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())));
  1035. 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())));
  1036. 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'));
  1037. 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'));
  1038. 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'));
  1039. 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'));
  1040. }
  1041. }
  1042. class lnkCIToDoc extends cmdbAbstractObject
  1043. {
  1044. public static function Init()
  1045. {
  1046. $aParams = array
  1047. (
  1048. "category" => "bizmodel,configmgmt",
  1049. "key_type" => "autoincrement",
  1050. "name_attcode" => "ci_id",
  1051. "state_attcode" => "",
  1052. "reconc_keys" => array("name"),
  1053. "db_table" => "lnkcitodoc",
  1054. "db_key_field" => "id",
  1055. "db_finalclass_field" => "",
  1056. "display_template" => "",
  1057. );
  1058. MetaModel::Init_Params($aParams);
  1059. MetaModel::Init_InheritAttributes();
  1060. 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())));
  1061. 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())));
  1062. 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())));
  1063. 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())));
  1064. 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())));
  1065. 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())));
  1066. 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())));
  1067. MetaModel::Init_SetZListItems('details', array('ci_id', 'ci_status', 'document_id', 'document_type', 'document_status'));
  1068. MetaModel::Init_SetZListItems('advanced_search', array('ci_id', 'document_id'));
  1069. MetaModel::Init_SetZListItems('standard_search', array('ci_id', 'document_id'));
  1070. MetaModel::Init_SetZListItems('list', array('ci_id', 'ci_status', 'document_id', 'document_type', 'document_status'));
  1071. }
  1072. }
  1073. class lnkCIToContact extends cmdbAbstractObject
  1074. {
  1075. public static function Init()
  1076. {
  1077. $aParams = array
  1078. (
  1079. "category" => "bizmodel,configmgmt",
  1080. "key_type" => "autoincrement",
  1081. "name_attcode" => "ci_id",
  1082. "state_attcode" => "",
  1083. "reconc_keys" => array("name"),
  1084. "db_table" => "lnkcitocontact",
  1085. "db_key_field" => "id",
  1086. "db_finalclass_field" => "",
  1087. "icon" => "../business/templates/contact.png",
  1088. );
  1089. MetaModel::Init_Params($aParams);
  1090. MetaModel::Init_InheritAttributes();
  1091. 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())));
  1092. 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())));
  1093. 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())));
  1094. 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())));
  1095. 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())));
  1096. 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())));
  1097. MetaModel::Init_AddAttribute(new AttributeString("role", array("allowed_values"=>null, "sql"=>"role", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1098. MetaModel::Init_SetZListItems('details', array('ci_id', 'ci_status', 'contact_id', 'contact_email', 'role'));
  1099. MetaModel::Init_SetZListItems('advanced_search', array('ci_id', 'contact_id', 'role'));
  1100. MetaModel::Init_SetZListItems('standard_search', array('ci_id', 'contact_id', 'role'));
  1101. MetaModel::Init_SetZListItems('list', array('ci_id', 'ci_status', 'contact_id', 'contact_email', 'role'));
  1102. }
  1103. }
  1104. class lnkSolutionToCI extends cmdbAbstractObject
  1105. {
  1106. public static function Init()
  1107. {
  1108. $aParams = array
  1109. (
  1110. "category" => "bizmodel,configmgmt",
  1111. "key_type" => "autoincrement",
  1112. "name_attcode" => "solution_id",
  1113. "state_attcode" => "",
  1114. "reconc_keys" => array("name"),
  1115. "db_table" => "lnksolutiontoci",
  1116. "db_key_field" => "id",
  1117. "db_finalclass_field" => "",
  1118. "display_template" => "",
  1119. );
  1120. MetaModel::Init_Params($aParams);
  1121. MetaModel::Init_InheritAttributes();
  1122. 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())));
  1123. 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())));
  1124. 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())));
  1125. 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())));
  1126. 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())));
  1127. MetaModel::Init_AddAttribute(new AttributeString("utility", array("allowed_values"=>null, "sql"=>"utility", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1128. MetaModel::Init_SetZListItems('details', array('solution_id', 'ci_id', 'ci_status', 'utility'));
  1129. MetaModel::Init_SetZListItems('advanced_search', array('solution_id', 'ci_id', 'utility'));
  1130. MetaModel::Init_SetZListItems('standard_search', array('solution_id', 'ci_id', 'utility'));
  1131. MetaModel::Init_SetZListItems('list', array('solution_id', 'ci_id', 'ci_status', 'utility'));
  1132. }
  1133. }
  1134. class lnkProcessToSolution extends cmdbAbstractObject
  1135. {
  1136. public static function Init()
  1137. {
  1138. $aParams = array
  1139. (
  1140. "category" => "bizmodel,configmgmt",
  1141. "key_type" => "autoincrement",
  1142. "name_attcode" => "solution_id",
  1143. "state_attcode" => "",
  1144. "reconc_keys" => array("name"),
  1145. "db_table" => "lnkprocesstosolution",
  1146. "db_key_field" => "id",
  1147. "db_finalclass_field" => "",
  1148. "display_template" => "",
  1149. );
  1150. MetaModel::Init_Params($aParams);
  1151. MetaModel::Init_InheritAttributes();
  1152. 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())));
  1153. 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())));
  1154. 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())));
  1155. 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())));
  1156. MetaModel::Init_AddAttribute(new AttributeString("reason", array("allowed_values"=>null, "sql"=>"reason", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1157. MetaModel::Init_SetZListItems('details', array('solution_id', 'process_id', 'reason'));
  1158. MetaModel::Init_SetZListItems('advanced_search', array('solution_id', 'process_id', 'reason'));
  1159. MetaModel::Init_SetZListItems('standard_search', array('solution_id', 'process_id', 'reason'));
  1160. MetaModel::Init_SetZListItems('list', array('solution_id', 'process_id', 'reason'));
  1161. }
  1162. }
  1163. //////////////////////////////////////////////////////////////////////////////
  1164. // Menu:
  1165. // +----------------------------------------+
  1166. // | My Module |
  1167. // +----------------------------------------+
  1168. // + All items
  1169. // + ...
  1170. // + ...
  1171. ////////////////////////////////////////////////////////////////////////////////////
  1172. // Create the top-level group. fRank = 1, means it will be inserted after the group '0', which is usually 'Welcome'
  1173. $oAdminMenu = new MenuGroup('DataAdministration', 999);
  1174. $iAdminGroup = $oAdminMenu->GetIndex();
  1175. new WebPageMenuNode('Audit', '../pages/audit.php', $iAdminGroup, 33 /* fRank */);
  1176. $oTypologyNode = new TemplateMenuNode('Catalogs', '', $iAdminGroup, 50 /* fRank */);
  1177. $iTopology = $oTypologyNode->GetIndex();
  1178. new OQLMenuNode('Organization', 'SELECT Organization', $iTopology, 10 /* fRank */);
  1179. new OQLMenuNode('Application', 'SELECT Application', $iTopology, 20 /* fRank */);
  1180. new OQLMenuNode('OperatingSystem', 'SELECT OperatingSystem', $iTopology, 30 /* fRank */);
  1181. new OQLMenuNode('DBServer', 'SELECT DBServer', $iTopology, 40 /* fRank */);
  1182. $oConfigManagementGroup = new MenuGroup('ConfigManagement', 1 /* fRank */);
  1183. // Create an entry, based on a custom template, for the Configuration management overview, under the top-level group
  1184. new TemplateMenuNode('ConfigManagementOverview', '../business/templates/configuration_management_menu.html', $oConfigManagementGroup->GetIndex(), 0 /* fRank */);
  1185. $oContactNode = new TemplateMenuNode('Contact', '../business/templates/contacts_menu.html', $oConfigManagementGroup->GetIndex(), 1 /* fRank */);
  1186. new OQLMenuNode('Person', 'SELECT Person', $oContactNode->GetIndex(), 1 /* fRank */);
  1187. new OQLMenuNode('Team', 'SELECT Team', $oContactNode->GetIndex(), 2 /* fRank */);
  1188. new OQLMenuNode('Document', 'SELECT Document', $oConfigManagementGroup->GetIndex(), 2 /* fRank */);
  1189. new OQLMenuNode('Location', 'SELECT Location', $oConfigManagementGroup->GetIndex(), 3 /* fRank */);
  1190. $oCINode = new TemplateMenuNode('ConfigManagementCI', '../business/templates/configuration_items_menu.html', $oConfigManagementGroup->GetIndex(), 2 /* fRank */);
  1191. new OQLMenuNode('BusinessProcess', 'SELECT BusinessProcess', $oCINode->GetIndex(), 0 /* fRank */);
  1192. new OQLMenuNode('ApplicationSolution', 'SELECT ApplicationSolution', $oCINode->GetIndex(), 1 /* fRank */);
  1193. $oSWNode = new TemplateMenuNode('ConfigManagementSoftware', '', $oCINode->GetIndex(), 2 /* fRank */);
  1194. new OQLMenuNode('Licence', 'SELECT Licence', $oSWNode->GetIndex(), 0 /* fRank */);
  1195. new OQLMenuNode('Patch', 'SELECT Patch', $oSWNode->GetIndex(), 1 /* fRank */);
  1196. new OQLMenuNode('ApplicationInstance', 'SELECT ApplicationInstance', $oSWNode->GetIndex(), 2 /* fRank */);
  1197. new OQLMenuNode('DatabaseInstance', 'SELECT DatabaseInstance', $oSWNode->GetIndex(), 3 /* fRank */);
  1198. $oHWNode = new TemplateMenuNode('ConfigManagementHardware', '', $oCINode->GetIndex(), 3 /* fRank */);
  1199. new OQLMenuNode('Subnet', 'SELECT Subnet', $oHWNode->GetIndex(), 0 /* fRank */);
  1200. new OQLMenuNode('NetworkDevice', 'SELECT NetworkDevice', $oHWNode->GetIndex(), 1 /* fRank */);
  1201. new OQLMenuNode('Server', 'SELECT Server', $oHWNode->GetIndex(), 2 /* fRank */);
  1202. new OQLMenuNode('Printer', 'SELECT Printer', $oHWNode->GetIndex(), 3 /* fRank */);
  1203. new OQLMenuNode('MobilePhone', 'SELECT MobilePhone', $oHWNode->GetIndex(), 4 /* fRank */);
  1204. new OQLMenuNode('PC', 'SELECT PC', $oHWNode->GetIndex(), 5 /* fRank */);
  1205. ?>