model.itop-config-mgmt.php 92 KB

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