model.itop-config-mgmt.php 103 KB

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