model.itop-config-mgmt.php 87 KB

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