model.itop-config-mgmt.php 96 KB

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