model.itop-config-mgmt.php 88 KB

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