model.itop-service-mgmt.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558
  1. <?
  2. abstract class Contract extends cmdbAbstractObject
  3. {
  4. public static function Init()
  5. {
  6. $aParams = array
  7. (
  8. "category" => "bizmodel,searchable,servicemgmt",
  9. "key_type" => "autoincrement",
  10. "name_attcode" => "name",
  11. "state_attcode" => "",
  12. "reconc_keys" => array("name"),
  13. "db_table" => "contract",
  14. "db_key_field" => "id",
  15. "db_finalclass_field" => "",
  16. "display_template" => "",
  17. );
  18. MetaModel::Init_Params($aParams);
  19. MetaModel::Init_InheritAttributes();
  20. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  21. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  22. MetaModel::Init_AddAttribute(new AttributeDate("start_date", array("allowed_values"=>null, "sql"=>"start_date", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  23. MetaModel::Init_AddAttribute(new AttributeDate("end_date", array("allowed_values"=>null, "sql"=>"end_date", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  24. MetaModel::Init_AddAttribute(new AttributeInteger("cost", array("allowed_values"=>null, "sql"=>"cost", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  25. MetaModel::Init_AddAttribute(new AttributeEnum("cost_currency", array("allowed_values"=>new ValueSetEnum('dollars,euros'), "sql"=>"cost_currency", "default_value"=>"euros", "is_null_allowed"=>true, "depends_on"=>array())));
  26. MetaModel::Init_AddAttribute(new AttributeString("cost_unit", array("allowed_values"=>null, "sql"=>"cost_unit", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  27. MetaModel::Init_AddAttribute(new AttributeString("billing_frequency", array("allowed_values"=>null, "sql"=>"billing_frequency", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  28. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("contact_list", array("linked_class"=>"lnkContractToContact", "ext_key_to_me"=>"contract_id", "ext_key_to_remote"=>"contact_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  29. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("document_list", array("linked_class"=>"lnkContractToDoc", "ext_key_to_me"=>"contract_id", "ext_key_to_remote"=>"document_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  30. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("ci_list", array("linked_class"=>"lnkContractToCI", "ext_key_to_me"=>"contract_id", "ext_key_to_remote"=>"ci_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  31. MetaModel::Init_SetZListItems('details', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'contact_list', 'document_list', 'ci_list'));
  32. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency'));
  33. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency'));
  34. MetaModel::Init_SetZListItems('list', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency'));
  35. }
  36. }
  37. class ProviderContract extends Contract
  38. {
  39. public static function Init()
  40. {
  41. $aParams = array
  42. (
  43. "category" => "bizmodel,searchable,servicemgmt",
  44. "key_type" => "autoincrement",
  45. "name_attcode" => "name",
  46. "state_attcode" => "",
  47. "reconc_keys" => array("name"),
  48. "db_table" => "providercontract",
  49. "db_key_field" => "id",
  50. "db_finalclass_field" => "",
  51. "display_template" => "",
  52. );
  53. MetaModel::Init_Params($aParams);
  54. MetaModel::Init_InheritAttributes();
  55. MetaModel::Init_AddAttribute(new AttributeExternalKey("provider_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"provider_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  56. MetaModel::Init_AddAttribute(new AttributeExternalField("provider_name", array("allowed_values"=>null, "extkey_attcode"=>"provider_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  57. MetaModel::Init_AddAttribute(new AttributeString("ola", array("allowed_values"=>null, "sql"=>"ola", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  58. MetaModel::Init_AddAttribute(new AttributeString("coverage", array("allowed_values"=>null, "sql"=>"coverage", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  59. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("customer_list", array("linked_class"=>"lnkProviderToCustomer", "ext_key_to_me"=>"provider_id", "ext_key_to_remote"=>"customer_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  60. MetaModel::Init_SetZListItems('details', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'contact_list', 'document_list', 'ci_list', 'provider_id', 'ola', 'coverage', 'customer_list'));
  61. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'provider_id', 'ola', 'coverage'));
  62. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'provider_id', 'ola', 'coverage'));
  63. MetaModel::Init_SetZListItems('list', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'provider_id', 'ola', 'coverage'));
  64. }
  65. }
  66. class CustomerContract extends Contract
  67. {
  68. public static function Init()
  69. {
  70. $aParams = array
  71. (
  72. "category" => "bizmodel,searchable,servicemgmt",
  73. "key_type" => "autoincrement",
  74. "name_attcode" => "name",
  75. "state_attcode" => "",
  76. "reconc_keys" => array("name"),
  77. "db_table" => "customercontract",
  78. "db_key_field" => "id",
  79. "db_finalclass_field" => "",
  80. "display_template" => "",
  81. );
  82. MetaModel::Init_Params($aParams);
  83. MetaModel::Init_InheritAttributes();
  84. MetaModel::Init_AddAttribute(new AttributeExternalKey("customer_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"customer_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  85. MetaModel::Init_AddAttribute(new AttributeExternalField("customer_name", array("allowed_values"=>null, "extkey_attcode"=>"customer_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  86. MetaModel::Init_AddAttribute(new AttributeExternalKey("support_team_id", array("targetclass"=>"Team", "jointype"=>null, "allowed_values"=>null, "sql"=>"support_team_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  87. MetaModel::Init_AddAttribute(new AttributeExternalField("support_team_name", array("allowed_values"=>null, "extkey_attcode"=>"support_team_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  88. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("provider_list", array("linked_class"=>"lnkProviderToCustomer", "ext_key_to_me"=>"customer_id", "ext_key_to_remote"=>"provider_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  89. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("sla_list", array("linked_class"=>"lnkContractToSLA", "ext_key_to_me"=>"contract_id", "ext_key_to_remote"=>"sla_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  90. MetaModel::Init_SetZListItems('details', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'contact_list', 'document_list', 'ci_list', 'customer_id', 'support_team_id', 'provider_list', 'sla_list'));
  91. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'customer_id', 'support_team_id'));
  92. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'customer_id', 'support_team_id'));
  93. MetaModel::Init_SetZListItems('list', array('name', 'description', 'start_date', 'end_date', 'cost', 'cost_currency', 'cost_unit', 'billing_frequency', 'customer_id', 'support_team_id'));
  94. }
  95. }
  96. class lnkProviderToCustomer extends cmdbAbstractObject
  97. {
  98. public static function Init()
  99. {
  100. $aParams = array
  101. (
  102. "category" => "bizmodel,searchable,servicemgmt",
  103. "key_type" => "autoincrement",
  104. "name_attcode" => "provider_id",
  105. "state_attcode" => "",
  106. "reconc_keys" => array("name"),
  107. "db_table" => "lnkprovidertocustomer",
  108. "db_key_field" => "id",
  109. "db_finalclass_field" => "",
  110. "display_template" => "",
  111. );
  112. MetaModel::Init_Params($aParams);
  113. MetaModel::Init_InheritAttributes();
  114. MetaModel::Init_AddAttribute(new AttributeExternalKey("provider_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"provider_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  115. MetaModel::Init_AddAttribute(new AttributeExternalField("provider_name", array("allowed_values"=>null, "extkey_attcode"=>"provider_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  116. MetaModel::Init_AddAttribute(new AttributeExternalKey("customer_id", array("targetclass"=>"Organization", "jointype"=>null, "allowed_values"=>null, "sql"=>"customer_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  117. MetaModel::Init_AddAttribute(new AttributeExternalField("customer_name", array("allowed_values"=>null, "extkey_attcode"=>"customer_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  118. MetaModel::Init_SetZListItems('details', array('provider_id', 'customer_id'));
  119. MetaModel::Init_SetZListItems('advanced_search', array('provider_id', 'customer_id'));
  120. MetaModel::Init_SetZListItems('standard_search', array('provider_id', 'customer_id'));
  121. MetaModel::Init_SetZListItems('list', array('provider_id', 'customer_id'));
  122. }
  123. }
  124. class lnkContractToSLA extends cmdbAbstractObject
  125. {
  126. public static function Init()
  127. {
  128. $aParams = array
  129. (
  130. "category" => "bizmodel,searchable,servicemgmt",
  131. "key_type" => "autoincrement",
  132. "name_attcode" => "contract_id",
  133. "state_attcode" => "",
  134. "reconc_keys" => array("name"),
  135. "db_table" => "lnkcontracttosla",
  136. "db_key_field" => "id",
  137. "db_finalclass_field" => "",
  138. "display_template" => "",
  139. );
  140. MetaModel::Init_Params($aParams);
  141. MetaModel::Init_InheritAttributes();
  142. MetaModel::Init_AddAttribute(new AttributeExternalKey("contract_id", array("targetclass"=>"CustomerContract", "jointype"=>null, "allowed_values"=>null, "sql"=>"contract_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  143. MetaModel::Init_AddAttribute(new AttributeExternalField("contract_name", array("allowed_values"=>null, "extkey_attcode"=>"contract_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  144. MetaModel::Init_AddAttribute(new AttributeExternalKey("sla_id", array("targetclass"=>"SLA", "jointype"=>null, "allowed_values"=>null, "sql"=>"sla_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  145. MetaModel::Init_AddAttribute(new AttributeExternalField("sla_name", array("allowed_values"=>null, "extkey_attcode"=>"sla_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  146. MetaModel::Init_AddAttribute(new AttributeString("coverage", array("allowed_values"=>null, "sql"=>"coverage", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  147. MetaModel::Init_SetZListItems('details', array('contract_id', 'sla_id', 'coverage'));
  148. MetaModel::Init_SetZListItems('advanced_search', array('contract_id', 'sla_id', 'coverage'));
  149. MetaModel::Init_SetZListItems('standard_search', array('contract_id', 'sla_id', 'coverage'));
  150. MetaModel::Init_SetZListItems('list', array('contract_id', 'sla_id', 'coverage'));
  151. }
  152. }
  153. class lnkContractToDoc extends cmdbAbstractObject
  154. {
  155. public static function Init()
  156. {
  157. $aParams = array
  158. (
  159. "category" => "bizmodel,searchable,servicemgmt",
  160. "key_type" => "autoincrement",
  161. "name_attcode" => "contract_id",
  162. "state_attcode" => "",
  163. "reconc_keys" => array("name"),
  164. "db_table" => "lnkcontracttodoc",
  165. "db_key_field" => "id",
  166. "db_finalclass_field" => "",
  167. "display_template" => "",
  168. );
  169. MetaModel::Init_Params($aParams);
  170. MetaModel::Init_InheritAttributes();
  171. MetaModel::Init_AddAttribute(new AttributeExternalKey("contract_id", array("targetclass"=>"Contract", "jointype"=>null, "allowed_values"=>null, "sql"=>"contract_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  172. MetaModel::Init_AddAttribute(new AttributeExternalField("contract_name", array("allowed_values"=>null, "extkey_attcode"=>"contract_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  173. 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())));
  174. 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())));
  175. 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())));
  176. 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())));
  177. MetaModel::Init_SetZListItems('details', array('contract_id', 'document_id', 'document_type', 'document_status'));
  178. MetaModel::Init_SetZListItems('advanced_search', array('contract_id', 'document_id', 'document_type', 'document_status'));
  179. MetaModel::Init_SetZListItems('standard_search', array('contract_id', 'document_id', 'document_type', 'document_status'));
  180. MetaModel::Init_SetZListItems('list', array('contract_id', 'document_id', 'document_type', 'document_status'));
  181. }
  182. }
  183. class lnkContractToContact extends cmdbAbstractObject
  184. {
  185. public static function Init()
  186. {
  187. $aParams = array
  188. (
  189. "category" => "bizmodel,searchable,servicemgmt",
  190. "key_type" => "autoincrement",
  191. "name_attcode" => "contract_id",
  192. "state_attcode" => "",
  193. "reconc_keys" => array("name"),
  194. "db_table" => "lnkcontracttocontact",
  195. "db_key_field" => "id",
  196. "db_finalclass_field" => "",
  197. "display_template" => "",
  198. );
  199. MetaModel::Init_Params($aParams);
  200. MetaModel::Init_InheritAttributes();
  201. MetaModel::Init_AddAttribute(new AttributeExternalKey("contract_id", array("targetclass"=>"Contract", "jointype"=>null, "allowed_values"=>null, "sql"=>"contract_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  202. MetaModel::Init_AddAttribute(new AttributeExternalField("contract_name", array("allowed_values"=>null, "extkey_attcode"=>"contract_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  203. MetaModel::Init_AddAttribute(new AttributeExternalKey("contact_id", array("targetclass"=>"Contact", "jointype"=>null, "allowed_values"=>null, "sql"=>"contact_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  204. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_name", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  205. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_email", array("allowed_values"=>null, "extkey_attcode"=>"contact_id", "target_attcode"=>"email", "is_null_allowed"=>true, "depends_on"=>array())));
  206. MetaModel::Init_SetZListItems('details', array('contract_id', 'contact_id', 'contact_email'));
  207. MetaModel::Init_SetZListItems('advanced_search', array('contract_id', 'contact_id', 'contact_email'));
  208. MetaModel::Init_SetZListItems('standard_search', array('contract_id', 'contact_id', 'contact_email'));
  209. MetaModel::Init_SetZListItems('list', array('contract_id', 'contact_id', 'contact_email'));
  210. }
  211. }
  212. class lnkContractToCI extends cmdbAbstractObject
  213. {
  214. public static function Init()
  215. {
  216. $aParams = array
  217. (
  218. "category" => "bizmodel,searchable,servicemgmt",
  219. "key_type" => "autoincrement",
  220. "name_attcode" => "contract_id",
  221. "state_attcode" => "",
  222. "reconc_keys" => array("name"),
  223. "db_table" => "lnkcontracttoci",
  224. "db_key_field" => "id",
  225. "db_finalclass_field" => "",
  226. "display_template" => "",
  227. );
  228. MetaModel::Init_Params($aParams);
  229. MetaModel::Init_InheritAttributes();
  230. MetaModel::Init_AddAttribute(new AttributeExternalKey("contract_id", array("targetclass"=>"Contract", "jointype"=>null, "allowed_values"=>null, "sql"=>"contract_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  231. MetaModel::Init_AddAttribute(new AttributeExternalField("contract_name", array("allowed_values"=>null, "extkey_attcode"=>"contract_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  232. 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())));
  233. 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())));
  234. 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())));
  235. MetaModel::Init_SetZListItems('details', array('contract_id', 'ci_id', 'ci_status'));
  236. MetaModel::Init_SetZListItems('advanced_search', array('contract_id', 'ci_id', 'ci_status'));
  237. MetaModel::Init_SetZListItems('standard_search', array('contract_id', 'ci_id', 'ci_status'));
  238. MetaModel::Init_SetZListItems('list', array('contract_id', 'ci_id', 'ci_status'));
  239. }
  240. }
  241. class Service extends cmdbAbstractObject
  242. {
  243. public static function Init()
  244. {
  245. $aParams = array
  246. (
  247. "category" => "bizmodel,searchable,servicemgmt",
  248. "key_type" => "autoincrement",
  249. "name_attcode" => "name",
  250. "state_attcode" => "",
  251. "reconc_keys" => array("name"),
  252. "db_table" => "service",
  253. "db_key_field" => "id",
  254. "db_finalclass_field" => "",
  255. "display_template" => "",
  256. );
  257. MetaModel::Init_Params($aParams);
  258. MetaModel::Init_InheritAttributes();
  259. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  260. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  261. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("allowed_values"=>new ValueSetEnum('RequestManagement,IncidentManagement'), "sql"=>"type", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  262. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("allowed_values"=>new ValueSetEnum('design,production,obsolete'), "sql"=>"status", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  263. MetaModel::Init_AddAttribute(new AttributeLinkedSet("subcategory_list", array("linked_class"=>"ServiceSubcategory", "ext_key_to_me"=>"service_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  264. MetaModel::Init_AddAttribute(new AttributeLinkedSet("sla_list", array("linked_class"=>"SLA", "ext_key_to_me"=>"service_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  265. MetaModel::Init_SetZListItems('details', array('name', 'description', 'type', 'status', 'subcategory_list', 'sla_list'));
  266. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'type', 'status'));
  267. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'type', 'status'));
  268. MetaModel::Init_SetZListItems('list', array('name', 'description', 'type', 'status'));
  269. }
  270. }
  271. class ServiceSubcategory extends cmdbAbstractObject
  272. {
  273. public static function Init()
  274. {
  275. $aParams = array
  276. (
  277. "category" => "bizmodel,searchable,servicemgmt",
  278. "key_type" => "autoincrement",
  279. "name_attcode" => "name",
  280. "state_attcode" => "",
  281. "reconc_keys" => array("name"),
  282. "db_table" => "servicesubcategory",
  283. "db_key_field" => "id",
  284. "db_finalclass_field" => "",
  285. "display_template" => "",
  286. );
  287. MetaModel::Init_Params($aParams);
  288. MetaModel::Init_InheritAttributes();
  289. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  290. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  291. MetaModel::Init_AddAttribute(new AttributeExternalKey("service_id", array("targetclass"=>"Service", "jointype"=>null, "allowed_values"=>null, "sql"=>"service_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  292. MetaModel::Init_AddAttribute(new AttributeExternalField("service_name", array("allowed_values"=>null, "extkey_attcode"=>"service_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  293. MetaModel::Init_SetZListItems('details', array('name', 'description', 'service_id'));
  294. MetaModel::Init_SetZListItems('advanced_search', array('name', 'description', 'service_id'));
  295. MetaModel::Init_SetZListItems('standard_search', array('name', 'description', 'service_id'));
  296. MetaModel::Init_SetZListItems('list', array('name', 'description', 'service_id'));
  297. }
  298. }
  299. class SLA extends cmdbAbstractObject
  300. {
  301. public static function Init()
  302. {
  303. $aParams = array
  304. (
  305. "category" => "bizmodel,searchable,servicemgmt",
  306. "key_type" => "autoincrement",
  307. "name_attcode" => "name",
  308. "state_attcode" => "",
  309. "reconc_keys" => array("name"),
  310. "db_table" => "sla",
  311. "db_key_field" => "id",
  312. "db_finalclass_field" => "",
  313. "display_template" => "",
  314. );
  315. MetaModel::Init_Params($aParams);
  316. MetaModel::Init_InheritAttributes();
  317. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  318. MetaModel::Init_AddAttribute(new AttributeExternalKey("service_id", array("targetclass"=>"Service", "jointype"=>null, "allowed_values"=>null, "sql"=>"service_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  319. MetaModel::Init_AddAttribute(new AttributeExternalField("service_name", array("allowed_values"=>null, "extkey_attcode"=>"service_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  320. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("slt_list", array("linked_class"=>"lnkSLTToSLA", "ext_key_to_me"=>"sla_id", "ext_key_to_remote"=>"slt_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  321. MetaModel::Init_SetZListItems('details', array('name', 'service_id', 'slt_list'));
  322. MetaModel::Init_SetZListItems('advanced_search', array('name', 'service_id'));
  323. MetaModel::Init_SetZListItems('standard_search', array('name', 'service_id'));
  324. MetaModel::Init_SetZListItems('list', array('name', 'service_id'));
  325. }
  326. }
  327. class SLT extends cmdbAbstractObject
  328. {
  329. public static function Init()
  330. {
  331. $aParams = array
  332. (
  333. "category" => "bizmodel,searchable,servicemgmt",
  334. "key_type" => "autoincrement",
  335. "name_attcode" => "name",
  336. "state_attcode" => "",
  337. "reconc_keys" => array("name"),
  338. "db_table" => "slt",
  339. "db_key_field" => "id",
  340. "db_finalclass_field" => "",
  341. "display_template" => "",
  342. );
  343. MetaModel::Init_Params($aParams);
  344. MetaModel::Init_InheritAttributes();
  345. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  346. MetaModel::Init_AddAttribute(new AttributeEnum("metric", array("allowed_values"=>new ValueSetEnum('TTO,TTR'), "sql"=>"metric", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  347. MetaModel::Init_AddAttribute(new AttributeEnum("ticket_priority", array("allowed_values"=>new ValueSetEnum('1,2,3'), "sql"=>"ticket_priority", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  348. MetaModel::Init_AddAttribute(new AttributeInteger("value", array("allowed_values"=>null, "sql"=>"value", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  349. MetaModel::Init_AddAttribute(new AttributeEnum("value_unit", array("allowed_values"=>new ValueSetEnum('days,hours,minutes'), "sql"=>"value_unit", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  350. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("sla_list", array("linked_class"=>"lnkSLTToSLA", "ext_key_to_me"=>"slt_id", "ext_key_to_remote"=>"sla_id", "allowed_values"=>null, "count_min"=>0, "count_max"=>0, "depends_on"=>array())));
  351. MetaModel::Init_SetZListItems('details', array('name', 'metric', 'ticket_priority', 'value', 'value_unit', 'sla_list'));
  352. MetaModel::Init_SetZListItems('advanced_search', array('name', 'metric', 'ticket_priority', 'value', 'value_unit'));
  353. MetaModel::Init_SetZListItems('standard_search', array('name', 'metric', 'ticket_priority', 'value', 'value_unit'));
  354. MetaModel::Init_SetZListItems('list', array('name', 'metric', 'ticket_priority', 'value', 'value_unit'));
  355. }
  356. }
  357. class lnkSLTToSLA extends cmdbAbstractObject
  358. {
  359. public static function Init()
  360. {
  361. $aParams = array
  362. (
  363. "category" => "bizmodel,searchable,servicemgmt",
  364. "key_type" => "autoincrement",
  365. "name_attcode" => "sla_id",
  366. "state_attcode" => "",
  367. "reconc_keys" => array("name"),
  368. "db_table" => "lnkslttosla",
  369. "db_key_field" => "id",
  370. "db_finalclass_field" => "",
  371. "display_template" => "",
  372. );
  373. MetaModel::Init_Params($aParams);
  374. MetaModel::Init_InheritAttributes();
  375. MetaModel::Init_AddAttribute(new AttributeExternalKey("sla_id", array("targetclass"=>"SLA", "jointype"=>null, "allowed_values"=>null, "sql"=>"sla_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  376. MetaModel::Init_AddAttribute(new AttributeExternalField("sla_name", array("allowed_values"=>null, "extkey_attcode"=>"sla_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  377. MetaModel::Init_AddAttribute(new AttributeExternalKey("slt_id", array("targetclass"=>"SLT", "jointype"=>null, "allowed_values"=>null, "sql"=>"slt_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  378. MetaModel::Init_AddAttribute(new AttributeExternalField("slt_name", array("allowed_values"=>null, "extkey_attcode"=>"slt_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  379. MetaModel::Init_AddAttribute(new AttributeExternalField("slt_metric", array("allowed_values"=>null, "extkey_attcode"=>"slt_id", "target_attcode"=>"metric", "is_null_allowed"=>true, "depends_on"=>array())));
  380. MetaModel::Init_AddAttribute(new AttributeExternalField("slt_value", array("allowed_values"=>null, "extkey_attcode"=>"slt_id", "target_attcode"=>"value", "is_null_allowed"=>true, "depends_on"=>array())));
  381. MetaModel::Init_AddAttribute(new AttributeExternalField("slt_value_unit", array("allowed_values"=>null, "extkey_attcode"=>"slt_id", "target_attcode"=>"value_unit", "is_null_allowed"=>true, "depends_on"=>array())));
  382. MetaModel::Init_SetZListItems('details', array('sla_id', 'slt_id', 'slt_metric', 'slt_value', 'slt_value_unit'));
  383. MetaModel::Init_SetZListItems('advanced_search', array('sla_id', 'slt_id', 'slt_metric', 'slt_value', 'slt_value_unit'));
  384. MetaModel::Init_SetZListItems('standard_search', array('sla_id', 'slt_id', 'slt_metric', 'slt_value', 'slt_value_unit'));
  385. MetaModel::Init_SetZListItems('list', array('sla_id', 'slt_id', 'slt_metric', 'slt_value', 'slt_value_unit'));
  386. }
  387. }
  388. class lnkServiceToDoc extends cmdbAbstractObject
  389. {
  390. public static function Init()
  391. {
  392. $aParams = array
  393. (
  394. "category" => "bizmodel,searchable,servicemgmt",
  395. "key_type" => "autoincrement",
  396. "name_attcode" => "service_id",
  397. "state_attcode" => "",
  398. "reconc_keys" => array("name"),
  399. "db_table" => "lnkservicetodoc",
  400. "db_key_field" => "id",
  401. "db_finalclass_field" => "",
  402. "display_template" => "",
  403. );
  404. MetaModel::Init_Params($aParams);
  405. MetaModel::Init_InheritAttributes();
  406. MetaModel::Init_AddAttribute(new AttributeExternalKey("service_id", array("targetclass"=>"Service", "jointype"=>null, "allowed_values"=>null, "sql"=>"service_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  407. MetaModel::Init_AddAttribute(new AttributeExternalField("service_name", array("allowed_values"=>null, "extkey_attcode"=>"service_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  408. 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())));
  409. 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())));
  410. 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())));
  411. 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())));
  412. MetaModel::Init_SetZListItems('details', array('service_id', 'document_id', 'document_type', 'document_status'));
  413. MetaModel::Init_SetZListItems('advanced_search', array('service_id', 'document_id', 'document_type', 'document_status'));
  414. MetaModel::Init_SetZListItems('standard_search', array('service_id', 'document_id', 'document_type', 'document_status'));
  415. MetaModel::Init_SetZListItems('list', array('service_id', 'document_id', 'document_type', 'document_status'));
  416. }
  417. }
  418. class lnkServiceToContact extends cmdbAbstractObject
  419. {
  420. public static function Init()
  421. {
  422. $aParams = array
  423. (
  424. "category" => "bizmodel,searchable,servicemgmt",
  425. "key_type" => "autoincrement",
  426. "name_attcode" => "service_id",
  427. "state_attcode" => "",
  428. "reconc_keys" => array("name"),
  429. "db_table" => "lnkservicetocontact",
  430. "db_key_field" => "id",
  431. "db_finalclass_field" => "",
  432. "display_template" => "",
  433. );
  434. MetaModel::Init_Params($aParams);
  435. MetaModel::Init_InheritAttributes();
  436. MetaModel::Init_AddAttribute(new AttributeExternalKey("service_id", array("targetclass"=>"Service", "jointype"=>null, "allowed_values"=>null, "sql"=>"service_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  437. MetaModel::Init_AddAttribute(new AttributeExternalField("service_name", array("allowed_values"=>null, "extkey_attcode"=>"service_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  438. 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())));
  439. 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())));
  440. 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())));
  441. MetaModel::Init_SetZListItems('details', array('service_id', 'contact_id', 'contact_email'));
  442. MetaModel::Init_SetZListItems('advanced_search', array('service_id', 'contact_id', 'contact_email'));
  443. MetaModel::Init_SetZListItems('standard_search', array('service_id', 'contact_id', 'contact_email'));
  444. MetaModel::Init_SetZListItems('list', array('service_id', 'contact_id', 'contact_email'));
  445. }
  446. }
  447. class lnkServiceToCI extends cmdbAbstractObject
  448. {
  449. public static function Init()
  450. {
  451. $aParams = array
  452. (
  453. "category" => "bizmodel,searchable,servicemgmt",
  454. "key_type" => "autoincrement",
  455. "name_attcode" => "service_id",
  456. "state_attcode" => "",
  457. "reconc_keys" => array("name"),
  458. "db_table" => "lnkservicetoci",
  459. "db_key_field" => "id",
  460. "db_finalclass_field" => "",
  461. "display_template" => "",
  462. );
  463. MetaModel::Init_Params($aParams);
  464. MetaModel::Init_InheritAttributes();
  465. MetaModel::Init_AddAttribute(new AttributeExternalKey("service_id", array("targetclass"=>"Service", "jointype"=>null, "allowed_values"=>null, "sql"=>"service_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  466. MetaModel::Init_AddAttribute(new AttributeExternalField("service_name", array("allowed_values"=>null, "extkey_attcode"=>"service_id", "target_attcode"=>"name", "is_null_allowed"=>true, "depends_on"=>array())));
  467. 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())));
  468. 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())));
  469. 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())));
  470. MetaModel::Init_SetZListItems('details', array('service_id', 'ci_id', 'ci_status'));
  471. MetaModel::Init_SetZListItems('advanced_search', array('service_id', 'ci_id', 'ci_status'));
  472. MetaModel::Init_SetZListItems('standard_search', array('service_id', 'ci_id', 'ci_status'));
  473. MetaModel::Init_SetZListItems('list', array('service_id', 'ci_id', 'ci_status'));
  474. }
  475. }
  476. //////////////////////////////////////////////////////////////////////////////
  477. // Menu:
  478. // +----------------------------------------+
  479. // | My Module |
  480. // +----------------------------------------+
  481. // + All items
  482. // + ...
  483. // + ...
  484. ////////////////////////////////////////////////////////////////////////////////////
  485. $oAdminMenu = new MenuGroup('AdminTools', 999);
  486. $iAdminGroup = $oAdminMenu->GetIndex();
  487. //new OQLMenuNode('ServiceType', 'SELECT ServiceType', $iAdminGroup, 25 /* fRank */);
  488. $oServiceManagementGroup = new MenuGroup('ServiceManagement', 2 /* fRank */);
  489. new OQLMenuNode('ProviderContract', 'SELECT ProviderContract', $oServiceManagementGroup->GetIndex(), 1 /* fRank */);
  490. new OQLMenuNode('CustomerContract', 'SELECT CustomerContract', $oServiceManagementGroup->GetIndex(), 2 /* fRank */);
  491. new OQLMenuNode('Service', 'SELECT Service', $oServiceManagementGroup->GetIndex(), 3 /* fRank */);
  492. new OQLMenuNode('ServiceSubcategory', 'SELECT ServiceSubcategory', $oServiceManagementGroup->GetIndex(), 3 /* fRank */);
  493. new OQLMenuNode('SLA', 'SELECT SLA', $oServiceManagementGroup->GetIndex(), 4 /* fRank */);
  494. new OQLMenuNode('SLT', 'SELECT SLT', $oServiceManagementGroup->GetIndex(), 5 /* fRank */);
  495. ?>