model.itop-config-mgmt.php 93 KB

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