model.itop-config-mgmt.php 78 KB

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