itop.business.class.inc.php 102 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721
  1. <?php
  2. require_once('../application/cmdbabstract.class.inc.php');
  3. require_once('../application/template.class.inc.php');
  4. /**
  5. * itop.business.class.inc.php
  6. * User defined objects, implements the business need
  7. *
  8. * @package iTopBizModelSamples
  9. * @author Romain Quetiez <romainquetiez@yahoo.fr>
  10. * @author Denis Flaven <denisflave@free.fr>
  11. * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
  12. * @link www.itop.com
  13. * @since 1.0
  14. * @version 1.1.1.1 $
  15. */
  16. /**
  17. * Possible values for the statuses of objects
  18. */
  19. define('STANDARD_STATUSES', 'production,implementation,obsolete');
  20. /**
  21. * Relation graphs
  22. */
  23. MetaModel::RegisterRelation("impacts", array("description"=>"objects being functionaly impacted", "verb_down"=>"impacts", "verb_up"=>"is impacted by"));
  24. ////////////////////////////////////////////////////////////////////////////////////
  25. /**
  26. * An organization that owns some objects
  27. *
  28. * An organization "owns" some persons (its employees) but also some other objects
  29. * (its assets) like buildings, computers, furniture...
  30. * the services that they provides, the contracts/OLA they have signed as customer
  31. *
  32. * Organization ownership might be used to manage the R/W access to the object
  33. */
  34. ////////////////////////////////////////////////////////////////////////////////////
  35. /**
  36. * itop.business.class.inc.php
  37. * User defined objects, implements the business need
  38. *
  39. * @package iTopBizModelSamples
  40. * @author Erwan Taloc <taloche@yahoo.fr>
  41. * @author Denis Flaven <denisflave@free.fr>
  42. * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
  43. * @link www.itop.com
  44. * @since 1.0
  45. * @version 1.1.1.1 $
  46. */
  47. class bizOrganization extends cmdbAbstractObject
  48. {
  49. public static function Init()
  50. {
  51. global $oAllowedStatuses;
  52. $aParams = array
  53. (
  54. "category" => "bizmodel,searchable",
  55. "name" => "Organization",
  56. "description" => "Organizational structure: can be Company and/or Department",
  57. "key_type" => "autoincrement",
  58. "key_label" => "id",
  59. "name_attcode" => "name",
  60. "state_attcode" => "",
  61. "reconc_keys" => array("name"),
  62. "db_table" => "organizations",
  63. "db_key_field" => "id",
  64. "db_finalclass_field" => "",
  65. "display_template" => "../business/templates/default.html",
  66. );
  67. MetaModel::Init_Params($aParams);
  68. MetaModel::Init_AddAttribute(new AttributeString("name", array("label"=>"Name", "description"=>"Common name", "allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array() )));
  69. MetaModel::Init_AddAttribute(new AttributeString("code", array("label"=>"Code", "description"=>"Organization code (Siret, DUNS,...)", "allowed_values"=>null, "sql"=>"code", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array() )));
  70. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum(STANDARD_STATUSES), "sql"=>"status", "default_value"=>"implementation", "is_null_allowed"=>false, "depends_on"=>array())));
  71. MetaModel::Init_AddAttribute(new AttributeExternalKey("parent_id", array("targetclass"=>"bizOrganization", "label"=>"Parent", "description"=>"Parent organization", "allowed_values"=>null, "sql"=>"parent_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  72. MetaModel::Init_AddAttribute(new AttributeExternalField("parent_name", array("label"=>"Parent Name", "description"=>"Name of the parent organization", "allowed_values"=>null, "extkey_attcode"=> 'parent_id', "target_attcode"=>"name")));
  73. MetaModel::Init_AddFilterFromAttribute("name");
  74. MetaModel::Init_AddFilterFromAttribute("code");
  75. MetaModel::Init_AddFilterFromAttribute("status");
  76. // Display lists
  77. MetaModel::Init_SetZListItems('details', array('name', 'code', 'status', 'parent_id')); // Attributes to be displayed for the complete details
  78. MetaModel::Init_SetZListItems('list', array('name', 'status', 'parent_id')); // Attributes to be displayed for a list
  79. // Search criteria
  80. MetaModel::Init_SetZListItems('standard_search', array('name', 'code', 'status')); // Criteria of the std search form
  81. MetaModel::Init_SetZListItems('advanced_search', array('name', 'code', 'status')); // Criteria of the advanced search form
  82. }
  83. public function Generate(cmdbDataGenerator $oGenerator)
  84. {
  85. //$this->SetKey($oGenerator->GetOrganizationCode());
  86. $this->Set('name', $oGenerator->GetOrganizationName());
  87. $this->Set('code', $oGenerator->GetOrganizationCode());
  88. $this->Set('status', 'implementation');
  89. $this->Set('parent_id', 1);
  90. }
  91. }
  92. ////////////////////////////////////////////////////////////////////////////////////
  93. /**
  94. * Class of objects owned by some organization
  95. *
  96. * This is the root class of all the objects that can be "owned" by an organization
  97. *
  98. * A Real Object
  99. * can be supported by Contacts, having a specific role (same contact with multiple roles?)
  100. * can be documented by Documents
  101. */
  102. ////////////////////////////////////////////////////////////////////////////////////
  103. /**
  104. * itop.business.class.inc.php
  105. * User defined objects, implements the business need
  106. *
  107. * @package iTopBizModelSamples
  108. * @author Erwan Taloc <taloche@yahoo.fr>
  109. * @author Denis Flaven <denisflave@free.fr>
  110. * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
  111. * @link www.itop.com
  112. * @since 1.0
  113. * @version 1.1.1.1 $
  114. */
  115. class logRealObject extends cmdbAbstractObject
  116. {
  117. public static function Init()
  118. {
  119. $aParams = array
  120. (
  121. "category" => "bizmodel,searchable",
  122. "name" => "Object",
  123. "description" => "Any CMDB object",
  124. "key_type" => "autoincrement",
  125. "key_label" => "id",
  126. "name_attcode" => "name",
  127. "state_attcode" => "",
  128. "reconc_keys" => array("name"),
  129. "db_table" => "objects",
  130. "db_key_field" => "id",
  131. "db_finalclass_field" => "obj_class",
  132. "display_template" => "../business/templates/default.html",
  133. );
  134. MetaModel::Init_Params($aParams);
  135. MetaModel::Init_AddAttribute(new AttributeString("name", array("label"=>"Name", "description"=>"Common name", "allowed_values"=>null, "sql"=>"name", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  136. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('production,implementation,obsolete,off,left company,available'), "sql"=>"status", "default_value"=>"implementation", "is_null_allowed"=>false, "depends_on"=>array())));
  137. MetaModel::Init_AddAttribute(new AttributeExternalKey("org_id", array("targetclass"=>"bizOrganization", "label"=>"Organization", "description"=>"ID of the object owner organization", "allowed_values"=>null, "sql"=>"org_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  138. MetaModel::Init_AddAttribute(new AttributeExternalField("org_name", array("label"=>"Organization", "description"=>"Company / Department owning this object", "allowed_values"=>null, "extkey_attcode"=> 'org_id', "target_attcode"=>"name")));
  139. MetaModel::Init_AddFilterFromAttribute("name");
  140. MetaModel::Init_AddFilterFromAttribute("status");
  141. MetaModel::Init_AddFilterFromAttribute("org_id");
  142. MetaModel::Init_AddFilterFromAttribute("org_name");
  143. // Display lists
  144. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id')); // Attributes to be displayed for the complete details
  145. MetaModel::Init_SetZListItems('list', array('finalclass', 'name', 'status', 'org_id')); // Attributes to be displayed for a list
  146. // Search criteria
  147. MetaModel::Init_SetZListItems('standard_search', array('name', 'status')); // Criteria of the std search form
  148. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id')); // Criteria of the advanced search form
  149. }
  150. public function Generate(cmdbDataGenerator $oGenerator)
  151. {
  152. $this->Set('org_id', $oGenerator->GetOrganizationId());
  153. $this->Set('name', "<overload in derived class>");
  154. $this->Set('status', $oGenerator->GenerateString("enum(implementation,production)"));
  155. }
  156. }
  157. ////////////////////////////////////////////////////////////////////////////////////
  158. /**
  159. * Any kind of thing that can be contacted (person, team, hotline...)
  160. * A contact can:
  161. * be linked to any Real Object with a role
  162. * be part of a GroupContact
  163. */
  164. ////////////////////////////////////////////////////////////////////////////////////
  165. class bizContact extends logRealObject
  166. {
  167. public static function Init()
  168. {
  169. $aParams = array
  170. (
  171. "category" => "bizmodel,searchable",
  172. "name" => "Contact",
  173. "description" => "Contact",
  174. "key_type" => "",
  175. "key_label" => "id",
  176. "name_attcode" => "name",
  177. "state_attcode" => "",
  178. "reconc_keys" => array("org_id", "name"), // inherited attributes
  179. "db_table" => "contacts",
  180. "db_key_field" => "id",
  181. "db_finalclass_field" => "",
  182. "display_template" => "../business/templates/default.html",
  183. );
  184. MetaModel::Init_Params($aParams);
  185. MetaModel::Init_InheritAttributes();
  186. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('off,left company,available'), "sql"=>"status", "default_value"=>"available", "is_null_allowed"=>false, "depends_on"=>array())));
  187. MetaModel::Init_AddAttribute(new AttributeExternalField("org_name", array("label"=>"Organization", "description"=>"Company / Department of the contact", "allowed_values"=>null, "extkey_attcode"=> 'org_id', "target_attcode"=>"name")));
  188. MetaModel::Init_AddAttribute(new AttributeEmailAddress("email", array("label"=>"eMail", "description"=>"Email address", "allowed_values"=>null, "sql"=>"email", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  189. MetaModel::Init_AddAttribute(new AttributeString("phone", array("label"=>"Phone", "description"=>"Telephone", "allowed_values"=>null, "sql"=>"telephone", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  190. MetaModel::Init_AddAttribute(new AttributeExternalKey("location_id", array("targetclass"=>"bizLocation", "label"=>"Location", "description"=>"Id of the location where the contact is located", "allowed_values"=>new ValueSetObjects('SELECT bizLocation AS p WHERE p.org_id = :this->org_id'), "sql"=>"location_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  191. MetaModel::Init_AddAttribute(new AttributeExternalField("location_name", array("label"=>"Location Name", "description"=>"Name of the location where the contact is located", "allowed_values"=>null, "extkey_attcode"=> 'location_id', "target_attcode"=>"name")));
  192. MetaModel::Init_InheritFilters();
  193. MetaModel::Init_AddFilterFromAttribute("org_name");
  194. MetaModel::Init_AddFilterFromAttribute("email");
  195. MetaModel::Init_AddFilterFromAttribute("phone");
  196. MetaModel::Init_AddFilterFromAttribute("location_id");
  197. MetaModel::Init_AddFilterFromAttribute("location_name");
  198. // Display lists
  199. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'location_id', 'phone')); // Attributes to be displayed for the complete details
  200. MetaModel::Init_SetZListItems('list', array('finalclass', 'name', 'status', 'org_id', 'email', 'location_id', 'phone')); // Attributes to be displayed for a list
  201. // Search criteria
  202. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'email', 'location_id', 'phone')); // Criteria of the std search form
  203. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id')); // Criteria of the advanced search form
  204. }
  205. public function Generate(cmdbDataGenerator $oGenerator)
  206. {
  207. $this->Set('org_id', $oGenerator->GetOrganizationId());
  208. $this->Set('name', "<overload in derived classes>");
  209. $this->Set('email', "<overload in derived classes>");
  210. $this->Set('phone', $oGenerator->GenerateString("enum(+1,+33,+44,+49,+421)| |number(100-999)| |number(000-999)"));
  211. $this->Set('location_id', $oGenerator->GenerateKey("bizLocation", array('org_id' =>$oGenerator->GetOrganizationId() )));
  212. }
  213. }
  214. ////////////////////////////////////////////////////////////////////////////////////
  215. /**
  216. * Physical person only
  217. */
  218. ////////////////////////////////////////////////////////////////////////////////////
  219. class bizPerson extends bizContact
  220. {
  221. public static function Init()
  222. {
  223. $aParams = array
  224. (
  225. "category" => "bizmodel,searchable",
  226. "name" => "Person",
  227. "description" => "Person",
  228. "key_type" => "",
  229. "key_label" => "id",
  230. "name_attcode" => "name",
  231. "state_attcode" => "",
  232. "reconc_keys" => array("org_id", "first_name", "name"), // comment en définir plusieurs
  233. // "reconc_keys" => array("org_id", "employee_number"),
  234. "db_table" => "persons", // Can it use the same physical DB table as any contact ?
  235. "db_key_field" => "id",
  236. "db_finalclass_field" => "",
  237. "display_template" => "../business/templates/person.html",
  238. );
  239. MetaModel::Init_Params($aParams);
  240. MetaModel::Init_InheritAttributes();
  241. MetaModel::Init_AddAttribute(new AttributeString("first_name", array("label"=>"First Name", "description"=>"First name", "allowed_values"=>null, "sql"=>"first_name", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  242. MetaModel::Init_AddAttribute(new AttributeString("employee_number", array("label"=>"Employee Number", "description"=>"employee number", "allowed_values"=>null, "sql"=>"employee_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  243. MetaModel::Init_InheritFilters();
  244. MetaModel::Init_AddFilterFromAttribute("first_name");
  245. MetaModel::Init_AddFilterFromAttribute("employee_number");
  246. // Display lists
  247. MetaModel::Init_SetZListItems('details', array('first_name', 'name', 'status', 'org_id', 'email', 'location_id', 'phone', 'employee_number')); // Attributes to be displayed for the complete details
  248. MetaModel::Init_SetZListItems('list', array('first_name', 'name', 'status', 'org_id', 'email', 'location_id', 'phone')); // Attributes to be displayed for a list
  249. // Search criteria
  250. MetaModel::Init_SetZListItems('standard_search', array('first_name', 'name', 'status', 'email', 'location_id', 'phone', 'employee_number')); // Criteria of the std search form
  251. MetaModel::Init_SetZListItems('advanced_search', array('first_name', 'name', 'status', 'email', 'location_id', 'phone', 'employee_number')); // Criteria of the advanced search form
  252. }
  253. public function Generate(cmdbDataGenerator $oGenerator)
  254. {
  255. parent::Generate($oGenerator);
  256. $this->Set('name', $oGenerator->GenerateLastName());
  257. $this->Set('first_name', $oGenerator->GenerateFirstName());
  258. $this->Set('email', $oGenerator->GenerateEmail($this->Get('first_name'), $this->Get('name')));
  259. $this->Set('phone', $oGenerator->GenerateString("enum(+1,+33,+44,+49,+421)| |number(100-999)| |number(000-999)"));
  260. }
  261. }
  262. ////////////////////////////////////////////////////////////////////////////////////
  263. /**
  264. * A team is basically a contact which is also a group of contacts
  265. * (and thus a team can contain other teams)
  266. */
  267. ////////////////////////////////////////////////////////////////////////////////////
  268. class bizTeam extends bizContact
  269. {
  270. public static function Init()
  271. {
  272. $aParams = array
  273. (
  274. "category" => "bizmodel,searchable",
  275. "name" => "Team",
  276. "description" => "A group of contacts",
  277. "key_type" => "",
  278. "key_label" => "id",
  279. "name_attcode" => "name",
  280. "state_attcode" => "",
  281. "reconc_keys" => array("org_id", "name"), // inherited attributes
  282. "db_table" => "teams",
  283. "db_key_field" => "id",
  284. "db_finalclass_field" => "",
  285. "display_template" => "../business/templates/team.html",
  286. );
  287. MetaModel::Init_Params($aParams);
  288. MetaModel::Init_InheritAttributes();
  289. MetaModel::Init_InheritFilters();
  290. // Display lists
  291. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'email', 'location_id', 'phone')); // Attributes to be displayed for the complete details
  292. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'email', 'location_id', 'phone')); // Attributes to be displayed for a list
  293. // Search criteria
  294. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'email', 'location_id', 'phone')); // Criteria of the std search form
  295. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id')); // Criteria of the advanced search form
  296. }
  297. }
  298. ////////////////////////////////////////////////////////////////////////////////////
  299. /**
  300. * n-n link between any Object and a contact
  301. */
  302. ////////////////////////////////////////////////////////////////////////////////////
  303. class lnkContactTeam extends cmdbAbstractObject
  304. {
  305. public static function Init()
  306. {
  307. $aParams = array
  308. (
  309. "category" => "bizmodel,searchable",
  310. "name" => "TeamsLinks",
  311. "description" => "A link between a contact and a Team",
  312. "key_type" => "autoincrement",
  313. "key_label" => "link_id",
  314. "name_attcode" => "role",
  315. "state_attcode" => "",
  316. "reconc_keys" => array("contact_id", "team_name"),
  317. "db_table" => "teams_links",
  318. "db_key_field" => "link_id",
  319. "db_finalclass_field" => "",
  320. "display_template" => "../business/templates/default.html",
  321. );
  322. MetaModel::Init_Params($aParams);
  323. MetaModel::Init_AddAttribute(new AttributeExternalKey("contact_id", array("targetclass"=>"bizPerson", "label"=>"Contact", "description"=>"The contact", "allowed_values"=>null, "sql"=>"contact_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  324. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_name", array("label"=>"Contact Name", "description"=>"name of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"name")));
  325. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_phone", array("label"=>"Phone", "description"=>"Phone number of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"phone")));
  326. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_email", array("label"=>"eMail", "description"=>"eMail address of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"email")));
  327. MetaModel::Init_AddAttribute(new AttributeExternalKey("team_id", array("targetclass"=>"bizTeam", "label"=>"Team", "description"=>"Team linked", "allowed_values"=>null, "sql"=>"team_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  328. MetaModel::Init_AddAttribute(new AttributeExternalField("team_name", array("label"=>"Team", "description"=>"name of the Team", "allowed_values"=>null, "extkey_attcode"=> 'team_id', "target_attcode"=>"name")));
  329. MetaModel::Init_AddAttribute(new AttributeString("role", array("label"=>"Role", "description"=>"Role of the contact", "allowed_values"=>null, "sql"=>"role", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  330. MetaModel::Init_AddFilterFromAttribute("contact_id");
  331. MetaModel::Init_AddFilterFromAttribute("contact_name");
  332. MetaModel::Init_AddFilterFromAttribute("team_id");
  333. MetaModel::Init_AddFilterFromAttribute("team_name");
  334. MetaModel::Init_AddFilterFromAttribute("role");
  335. // Display lists
  336. MetaModel::Init_SetZListItems('details', array('contact_id', 'contact_phone', 'contact_email', 'team_id', 'role')); // Attributes to be displayed for the complete details
  337. MetaModel::Init_SetZListItems('list', array('contact_id', 'contact_phone', 'contact_email', 'team_id', 'role')); // Attributes to be displayed for a list
  338. }
  339. }
  340. ////////////////////////////////////////////////////////////////////////////////////
  341. /**
  342. * An electronic document, with version tracking
  343. */
  344. ////////////////////////////////////////////////////////////////////////////////////
  345. class bizDocument extends logRealObject
  346. {
  347. public static function Init()
  348. {
  349. $aParams = array
  350. (
  351. "category" => "bizmodel,searchable",
  352. "name" => "Document",
  353. "description" => "Document",
  354. "key_type" => "",
  355. "key_label" => "id",
  356. "name_attcode" => "name",
  357. "state_attcode" => "",
  358. "reconc_keys" => array("org_id", "name"), // inherited attributes
  359. "db_table" => "documents",
  360. "db_key_field" => "id",
  361. "db_finalclass_field" => "",
  362. "display_template" => "../business/templates/document.html",
  363. );
  364. MetaModel::Init_Params($aParams);
  365. MetaModel::Init_InheritAttributes();
  366. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('production,implementation,obsolete'), "sql"=>"status", "default_value"=>"implementation", "is_null_allowed"=>false, "depends_on"=>array())));
  367. MetaModel::Init_AddAttribute(new AttributeExternalField("org_name", array("label"=>"Organization", "description"=>"Company / Department owning the document", "allowed_values"=>null, "extkey_attcode"=> 'org_id', "target_attcode"=>"name")));
  368. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("label"=>"type", "description"=>"usage of the document", "allowed_values"=>new ValueSetEnum("documentation,contract,working instructions,network map,white paper,presentation,training"), "sql"=>"type", "default_value"=>"documentation", "is_null_allowed"=>false, "depends_on"=>array())));
  369. MetaModel::Init_AddAttribute(new AttributeText("description", array("label"=>"Description", "description"=>"Service Description", "allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  370. MetaModel::Init_AddAttribute(new AttributeBlob("contents", array("label"=>"Contents", "description"=>"File content", "depends_on"=>array())));
  371. MetaModel::Init_InheritFilters();
  372. MetaModel::Init_AddFilterFromAttribute("type");
  373. MetaModel::Init_AddFilterFromAttribute("description");
  374. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'type', 'description', 'contents')); // Attributes to be displayed for the complete details
  375. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'type', 'contents')); // Attributes to be displayed for a list
  376. // Search criteria
  377. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'type')); // Criteria of the std search form
  378. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'type')); // Criteria of the advanced search form
  379. }
  380. }
  381. ////////////////////////////////////////////////////////////////////////////////////
  382. /**
  383. * n-n link between any Object and a Document
  384. */
  385. ////////////////////////////////////////////////////////////////////////////////////
  386. class lnkDocumentRealObject extends cmdbAbstractObject
  387. {
  388. public static function Init()
  389. {
  390. $aParams = array
  391. (
  392. "category" => "bizmodel,searchable",
  393. "name" => "DocumentsLinks",
  394. "description" => "A link between a document and another object",
  395. "key_type" => "autoincrement",
  396. "key_label" => "link_id",
  397. "name_attcode" => "link_type",
  398. "state_attcode" => "",
  399. "reconc_keys" => array("doc_id", "object_name"),
  400. "db_table" => "documents_links",
  401. "db_key_field" => "link_id",
  402. "db_finalclass_field" => "",
  403. "display_template" => "../business/templates/default.html",
  404. );
  405. MetaModel::Init_Params($aParams);
  406. MetaModel::Init_AddAttribute(new AttributeExternalKey("doc_id", array("targetclass"=>"bizDocument", "label"=>"Document", "description"=>"id of the Document", "allowed_values"=>null, "sql"=>"doc_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  407. MetaModel::Init_AddAttribute(new AttributeExternalField("doc_name", array("label"=>"Document Name", "description"=>"name of the document", "allowed_values"=>null, "extkey_attcode"=> 'doc_id', "target_attcode"=>"name")));
  408. MetaModel::Init_AddAttribute(new AttributeExternalKey("object_id", array("targetclass"=>"logRealObject", "label"=>"Object", "description"=>"Object linked", "allowed_values"=>null, "sql"=>"object_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  409. MetaModel::Init_AddAttribute(new AttributeExternalField("object_name", array("label"=>"Object Name", "description"=>"name of the linked object", "allowed_values"=>null, "extkey_attcode"=> 'object_id', "target_attcode"=>"name")));
  410. MetaModel::Init_AddAttribute(new AttributeString("link_type", array("label"=>"Link Type", "description"=>"More information", "allowed_values"=>null, "sql"=>"link_type", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  411. MetaModel::Init_AddFilterFromAttribute("doc_id");
  412. MetaModel::Init_AddFilterFromAttribute("doc_name");
  413. MetaModel::Init_AddFilterFromAttribute("object_id");
  414. MetaModel::Init_AddFilterFromAttribute("object_name");
  415. MetaModel::Init_AddFilterFromAttribute("link_type");
  416. // Display lists
  417. MetaModel::Init_SetZListItems('details', array('doc_id', 'object_id', 'link_type')); // Attributes to be displayed for the complete details
  418. MetaModel::Init_SetZListItems('list', array('doc_id', 'object_id', 'link_type')); // Attributes to be displayed for a list
  419. }
  420. }
  421. ////////////////////////////////////////////////////////////////////////////////////
  422. /**
  423. * n-n link between any Object and a contact
  424. */
  425. ////////////////////////////////////////////////////////////////////////////////////
  426. class lnkContactRealObject extends cmdbAbstractObject
  427. {
  428. public static function Init()
  429. {
  430. $aParams = array
  431. (
  432. "category" => "bizmodel,searchable",
  433. "name" => "ContactsLinks",
  434. "description" => "A link between a contact and another object",
  435. "key_type" => "autoincrement",
  436. "key_label" => "link_id",
  437. "name_attcode" => "role",
  438. "state_attcode" => "",
  439. "reconc_keys" => array("contact_id", "object_name"),
  440. "db_table" => "contacts_links",
  441. "db_key_field" => "link_id",
  442. "db_finalclass_field" => "",
  443. "display_template" => "../business/templates/default.html",
  444. );
  445. MetaModel::Init_Params($aParams);
  446. MetaModel::Init_AddAttribute(new AttributeExternalKey("contact_id", array("targetclass"=>"bizContact", "label"=>"Contact", "description"=>"The contact", "allowed_values"=>null, "sql"=>"contact_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  447. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_name", array("label"=>"Contact Name", "description"=>"name of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"name")));
  448. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_phone", array("label"=>"Phone", "description"=>"Phone number of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"phone")));
  449. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_email", array("label"=>"eMail", "description"=>"eMail address of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"email")));
  450. MetaModel::Init_AddAttribute(new AttributeExternalKey("object_id", array("targetclass"=>"logRealObject", "label"=>"Object", "description"=>"Object linked", "allowed_values"=>null, "sql"=>"object_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  451. MetaModel::Init_AddAttribute(new AttributeExternalField("object_name", array("label"=>"Object Name", "description"=>"name of the linked object", "allowed_values"=>null, "extkey_attcode"=> 'object_id', "target_attcode"=>"name")));
  452. MetaModel::Init_AddAttribute(new AttributeString("role", array("label"=>"Role", "description"=>"Role of the contact", "allowed_values"=>null, "sql"=>"role", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  453. MetaModel::Init_AddFilterFromAttribute("contact_id");
  454. MetaModel::Init_AddFilterFromAttribute("contact_name");
  455. MetaModel::Init_AddFilterFromAttribute("object_id");
  456. MetaModel::Init_AddFilterFromAttribute("object_name");
  457. MetaModel::Init_AddFilterFromAttribute("role");
  458. // Display lists
  459. MetaModel::Init_SetZListItems('details', array('contact_id', 'contact_phone', 'contact_email', 'object_id', 'role')); // Attributes to be displayed for the complete details
  460. MetaModel::Init_SetZListItems('list', array('contact_id', 'contact_phone', 'contact_email', 'object_id', 'role')); // Attributes to be displayed for a list
  461. }
  462. }
  463. ////////////////////////////////////////////////////////////////////////////////////
  464. /**
  465. * Any Infrastructure object (bizLocation, bizDevice, bizApplication, bizCircuit, bizInterface)
  466. * An infrastructure object:
  467. * can be covered by an OLA
  468. * can support the delivery of a Service
  469. * can be part of an GroupInfra
  470. */
  471. ////////////////////////////////////////////////////////////////////////////////////
  472. class logInfra extends logRealObject
  473. {
  474. public static function Init()
  475. {
  476. $aParams = array
  477. (
  478. "category" => "bizmodel,searchable",
  479. "name" => "Infra",
  480. "description" => "Infrastructure real object",
  481. "key_type" => "",
  482. "key_label" => "id",
  483. "name_attcode" => "name",
  484. "state_attcode" => "",
  485. "reconc_keys" => array("org_id", "name"), // inherited attributes
  486. "db_table" => "infra",
  487. "db_key_field" => "id",
  488. "db_finalclass_field" => "",
  489. "display_template" => "../business/templates/default.html",
  490. );
  491. MetaModel::Init_Params($aParams);
  492. MetaModel::Init_InheritAttributes();
  493. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('production,implementation,obsolete'), "sql"=>"status", "default_value"=>"implementation", "is_null_allowed"=>false, "depends_on"=>array())));
  494. MetaModel::Init_AddAttribute(new AttributeEnum("severity", array("label"=>"Business Criticity", "description"=>"Severity for this infrastructure", "allowed_values"=>new ValueSetEnum("high,medium,low"), "sql"=>"severity", "default_value"=>"low", "is_null_allowed"=>false, "depends_on"=>array())));
  495. MetaModel::Init_InheritFilters();
  496. MetaModel::Init_AddFilterFromAttribute("severity");
  497. }
  498. }
  499. ////////////////////////////////////////////////////////////////////////////////////
  500. /**
  501. * n-n link between any Object and a contact
  502. */
  503. ////////////////////////////////////////////////////////////////////////////////////
  504. class lnkContactInfra extends cmdbAbstractObject
  505. {
  506. public static function Init()
  507. {
  508. $aParams = array
  509. (
  510. "category" => "bizmodel,searchable",
  511. "name" => "ContactsInfraLinks",
  512. "description" => "A link between a contact and an infrastructure",
  513. "key_type" => "autoincrement",
  514. "key_label" => "link_id",
  515. "name_attcode" => "role",
  516. "state_attcode" => "",
  517. "reconc_keys" => array("contact_id", "infra_id"),
  518. "db_table" => "contacts_infra_links",
  519. "db_key_field" => "link_id",
  520. "db_finalclass_field" => "",
  521. "display_template" => "../business/templates/default.html",
  522. );
  523. MetaModel::Init_Params($aParams);
  524. MetaModel::Init_AddAttribute(new AttributeExternalKey("contact_id", array("targetclass"=>"bizContact", "label"=>"Contact", "description"=>"The contact", "allowed_values"=>null, "sql"=>"contact_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  525. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_name", array("label"=>"Contact Name", "description"=>"name of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"name")));
  526. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_phone", array("label"=>"Phone", "description"=>"Phone number of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"phone")));
  527. MetaModel::Init_AddAttribute(new AttributeExternalField("contact_email", array("label"=>"eMail", "description"=>"eMail address of the contact", "allowed_values"=>null, "extkey_attcode"=> 'contact_id', "target_attcode"=>"email")));
  528. MetaModel::Init_AddAttribute(new AttributeExternalKey("infra_id", array("targetclass"=>"logInfra", "label"=>"Infrastructure", "description"=>"Infrastructure linked", "allowed_values"=>null, "sql"=>"infra_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  529. MetaModel::Init_AddAttribute(new AttributeExternalField("infra_name", array("label"=>"Infrastructure", "description"=>"name of the linked infrastructure", "allowed_values"=>null, "extkey_attcode"=> 'infra_id', "target_attcode"=>"name")));
  530. MetaModel::Init_AddAttribute(new AttributeString("role", array("label"=>"Role", "description"=>"Role of the contact", "allowed_values"=>null, "sql"=>"role", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  531. MetaModel::Init_AddFilterFromAttribute("contact_id");
  532. MetaModel::Init_AddFilterFromAttribute("contact_name");
  533. MetaModel::Init_AddFilterFromAttribute("infra_id");
  534. MetaModel::Init_AddFilterFromAttribute("infra_name");
  535. MetaModel::Init_AddFilterFromAttribute("role");
  536. // Display lists
  537. MetaModel::Init_SetZListItems('details', array('contact_id', 'contact_phone', 'contact_email', 'infra_id', 'role')); // Attributes to be displayed for the complete details
  538. MetaModel::Init_SetZListItems('list', array('contact_id', 'contact_phone', 'contact_email', 'infra_id', 'role')); // Attributes to be displayed for a list
  539. }
  540. }
  541. ////////////////////////////////////////////////////////////////////////////////////
  542. /**
  543. * bizLocation (Region, Country, City, Site, Building, Floor, Room, Rack,...)
  544. * pourrait être mis en plusieurs sous objects, puisqu'une adresse sur region n'a pas trop de sens
  545. *
  546. */
  547. ////////////////////////////////////////////////////////////////////////////////////
  548. class bizLocation extends logInfra
  549. {
  550. public static function Init()
  551. {
  552. $aParams = array
  553. (
  554. "category" => "bizmodel,searchable",
  555. "name" => "Location",
  556. "description" => "Any type of location: Region, Country, City, Site, Building, Floor, Room, Rack,...",
  557. "key_type" => "",
  558. "key_label" => "id",
  559. "name_attcode" => "name",
  560. "state_attcode" => "",
  561. "reconc_keys" => array("org_id", "name"), // inherited attributes
  562. "db_table" => "location",
  563. "db_key_field" => "id",
  564. "db_finalclass_field" => "",
  565. "display_template" => "../business/templates/location.html",
  566. );
  567. MetaModel::Init_Params($aParams);
  568. MetaModel::Init_InheritAttributes();
  569. MetaModel::Init_AddAttribute(new AttributeText("address", array("label"=>"Address", "description"=>"The postal address of the location", "allowed_values"=>null, "sql"=>"address", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  570. MetaModel::Init_AddAttribute(new AttributeString("country", array("label"=>"Country", "description"=>"Country of the location", "allowed_values"=>null, "sql"=>"country", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  571. MetaModel::Init_AddAttribute(new AttributeExternalKey("parent_location_id", array("targetclass"=>"bizLocation", "label"=>"Parent Location", "description"=>"where is the real object physically located", "allowed_values"=>null, "sql"=>"parent_location_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  572. MetaModel::Init_AddAttribute(new AttributeExternalField("parent_location_name", array("label"=>"Parent location (Name)", "description"=>"name of the parent location", "allowed_values"=>null, "extkey_attcode"=> 'parent_location_id', "target_attcode"=>"name")));
  573. // on veut pouvoir rechercher une location qui soit un descendant (pas obligatoirement direct) d'une Location, on fait comment ?
  574. MetaModel::Init_InheritFilters();
  575. MetaModel::Init_AddFilterFromAttribute("country");
  576. MetaModel::Init_AddFilterFromAttribute("address");
  577. MetaModel::Init_AddFilterFromAttribute("parent_location_id");
  578. MetaModel::Init_AddFilterFromAttribute("parent_location_name");
  579. // Display lists
  580. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'address', 'country', 'parent_location_id')); // Attributes to be displayed for the complete details
  581. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'country')); // Attributes to be displayed for a list
  582. // Search criteria
  583. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'country', 'parent_location_name')); // Criteria of the std search form
  584. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'address', 'country', 'parent_location_id', 'org_id')); // Criteria of the advanced search form
  585. }
  586. public function ComputeValues()
  587. {
  588. /*
  589. $this->Set("location_id", $this->GetKey());
  590. // Houston, I've got an issue, as this field is calculated, I should reload the object... ?
  591. $this->Set("location_name", "abc (to be finalized)");
  592. */
  593. }
  594. function DisplayDetails(WebPage $oPage)
  595. {
  596. parent::DisplayDetails($oPage);
  597. /*
  598. parent::DisplayDetails($oPage);
  599. $oSearchFilter = new CMDBSearchFilter('bizServer');
  600. $oSearchFilter->AddCondition('location_id', $this->GetKey(), '=');
  601. $oSet = new CMDBObjectSet($oSearchFilter);
  602. $count = $oSet->Count();
  603. if ($count > 0)
  604. {
  605. $oPage->SetCurrentTab("Servers");
  606. $oPage->p("$count server(s) at this location:");
  607. $this->DisplaySet($oPage, $oSet);
  608. }
  609. $oSearchFilter = new CMDBSearchFilter('bizNetworkDevice');
  610. $oSearchFilter->AddCondition('location_id', $this->GetKey(), '=');
  611. $oSet = new CMDBObjectSet($oSearchFilter);
  612. $count = $oSet->Count();
  613. if ($count > 0)
  614. {
  615. $oPage->SetCurrentTab("Network Devices");
  616. $oPage->p("$count Network Device(s) at this location:");
  617. $this->DisplaySet($oPage, $oSet);
  618. }
  619. $oSearchFilter = new CMDBSearchFilter('bizPC');
  620. $oSearchFilter->AddCondition('location_id', $this->GetKey(), '=');
  621. $oSet = new CMDBObjectSet($oSearchFilter);
  622. $count = $oSet->Count();
  623. if ($count > 0)
  624. {
  625. $oPage->SetCurrentTab("PCs");
  626. $oPage->p("$count PC(s) at this location:");
  627. $this->DisplaySet($oPage, $oSet);
  628. }
  629. $oSearchFilter = new CMDBSearchFilter('bizPerson');
  630. $oSearchFilter->AddCondition('location_id', $this->GetKey(), '=');
  631. $oSet = new CMDBObjectSet($oSearchFilter);
  632. $count = $oSet->Count();
  633. if ($count > 0)
  634. {
  635. $oPage->SetCurrentTab("Contacts");
  636. $oPage->p("$count person(s) located to this location:");
  637. $this->DisplaySet($oPage, $oSet);
  638. }
  639. $oSearchFilter = new CMDBSearchFilter('lnkDocumentRealObject');
  640. $oSearchFilter->AddCondition('object_id', $this->GetKey(), '=');
  641. $oSet = new CMDBObjectSet($oSearchFilter);
  642. $count = $oSet->Count();
  643. if ($count > 0)
  644. {
  645. $oPage->SetCurrentTab("Details");
  646. $oPage->p("$count Document(s) linked to this location:");
  647. $this->DisplaySet($oPage, $oSet);
  648. }
  649. */
  650. }
  651. public function Generate(cmdbDataGenerator $oGenerator)
  652. {
  653. parent::Generate($oGenerator);
  654. $sLastName = $oGenerator->GenerateLastName();
  655. $sCityName = $oGenerator->GenerateCityName();
  656. $this->Set('name', $sCityName);
  657. $this->Set('country', $oGenerator->GenerateCountryName());
  658. $this->Set('address', $oGenerator->GenerateString("number(1-999)| |enum(rue,rue,rue,place,avenue,av.,route de)| |$sLastName| |number(0000-9999)|0 |$sCityName"));
  659. $this->Set('parent_location_id', 1);
  660. }
  661. }
  662. ////////////////////////////////////////////////////////////////////////////////////
  663. /**
  664. * Circuit (one end only)
  665. */
  666. ////////////////////////////////////////////////////////////////////////////////////
  667. class bizCircuit extends logInfra
  668. {
  669. public static function Init()
  670. {
  671. $aParams = array
  672. (
  673. "category" => "bizmodel,searchable",
  674. "name" => "Circuit",
  675. "description" => "Any type of circuit",
  676. "key_type" => "",
  677. "key_label" => "id",
  678. "name_attcode" => "name",
  679. "state_attcode" => "",
  680. "reconc_keys" => array("org_id", "provider_id", "carrier_ref", "name"), // inherited attributes
  681. "db_table" => "circuits",
  682. "db_key_field" => "id",
  683. "db_finalclass_field" => "",
  684. "display_template" => "../business/templates/Circuits.html",
  685. );
  686. MetaModel::Init_Params($aParams);
  687. MetaModel::Init_InheritAttributes();
  688. MetaModel::Init_AddAttribute(new AttributeString("speed", array("label"=>"speed", "description"=>"speed of the circuit", "allowed_values"=>null, "sql"=>"speed", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  689. MetaModel::Init_AddAttribute(new AttributeExternalKey("location1_id", array("targetclass"=>"bizLocation", "label"=>"Location 1", "description"=>"Id of the location 1", "allowed_values"=>new ValueSetObjects('SELECT bizLocation AS p WHERE p.org_id = :this->org_id'), "sql"=>"location1_id", "is_null_allowed"=>false,"on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  690. MetaModel::Init_AddAttribute(new AttributeExternalField("location1_name", array("label"=>"Location 1", "description"=>"Name of the location", "allowed_values"=>null, "extkey_attcode"=> 'location1_id', "target_attcode"=>"name")));
  691. MetaModel::Init_AddAttribute(new AttributeExternalKey("location2_id", array("targetclass"=>"bizLocation", "label"=>"Location 2", "description"=>"Id of the location 2", "allowed_values"=>new ValueSetObjects('SELECT bizLocation AS p WHERE p.org_id = :this->org_id'), "sql"=>"location2_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL,"depends_on"=>array("org_id"))));
  692. MetaModel::Init_AddAttribute(new AttributeExternalField("location2_name", array("label"=>"Location 2", "description"=>"Name of the location", "allowed_values"=>null, "extkey_attcode"=> 'location2_id', "target_attcode"=>"name")));
  693. MetaModel::Init_AddAttribute(new AttributeExternalKey("interface1_id", array("targetclass"=>"bizInterface", "label"=>"Interface 1", "description"=>"id of the interface 1", "allowed_values"=>new ValueSetObjects('SELECT bizInterface AS p WHERE p.org_id = :this->org_id'), "sql"=>"interface1_id", "is_null_allowed"=>false,"on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  694. MetaModel::Init_AddAttribute(new AttributeExternalField("interface1_name", array("label"=>"Interface", "description"=>"Name of the interface 1", "allowed_values"=>null, "extkey_attcode"=> 'interface1_id', "target_attcode"=>"name")));
  695. MetaModel::Init_AddAttribute(new AttributeExternalField("device1_name", array("label"=>"Device 1", "description"=>"Name of the device 1", "allowed_values"=>null, "extkey_attcode"=> 'interface1_id', "target_attcode"=>"device_name")));
  696. MetaModel::Init_AddAttribute(new AttributeExternalKey("interface2_id", array("targetclass"=>"bizInterface", "label"=>"Interface 2", "description"=>"id of the interface 2", "allowed_values"=>new ValueSetObjects('SELECT bizInterface AS p WHERE p.org_id = :this->org_id'), "sql"=>"interface2_id", "is_null_allowed"=>false,"on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  697. MetaModel::Init_AddAttribute(new AttributeExternalField("interface2_name", array("label"=>"Interface", "description"=>"Name of the interface 2", "allowed_values"=>null, "extkey_attcode"=> 'interface2_id', "target_attcode"=>"name")));
  698. MetaModel::Init_AddAttribute(new AttributeExternalField("device2_name", array("label"=>"Interface", "description"=>"Name of the device 2", "allowed_values"=>null, "extkey_attcode"=> 'interface2_id', "target_attcode"=>"device_name")));
  699. MetaModel::Init_AddAttribute(new AttributeExternalKey("provider_id", array("targetclass"=>"bizOrganization", "label"=>"Carrier ID", "description"=>"Organization ID of the provider of the Circuit", "allowed_values"=>null, "sql"=>"provider_id", "is_null_allowed"=>false,"on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  700. MetaModel::Init_AddAttribute(new AttributeExternalField("carrier_name", array("label"=>"Carrier", "description"=>"Name of the carrier", "allowed_values"=>null, "extkey_attcode"=> 'provider_id', "target_attcode"=>"name")));
  701. MetaModel::Init_AddAttribute(new AttributeString("carrier_ref", array("label"=>"Carrier reference", "description"=>"reference of the circuit used by the carrier", "allowed_values"=>null, "sql"=>"carrier_ref", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  702. MetaModel::Init_InheritFilters();
  703. MetaModel::Init_AddFilterFromAttribute("speed");
  704. MetaModel::Init_AddFilterFromAttribute("location1_id");
  705. MetaModel::Init_AddFilterFromAttribute("location2_id");
  706. MetaModel::Init_AddFilterFromAttribute("interface1_id");
  707. MetaModel::Init_AddFilterFromAttribute("interface2_id");
  708. MetaModel::Init_AddFilterFromAttribute("provider_id");
  709. MetaModel::Init_AddFilterFromAttribute("carrier_ref");
  710. // Display lists
  711. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'speed', 'location1_id','interface1_id','device1_name','location2_id','interface2_id','device2_name','provider_id', 'carrier_ref')); // Attributes to be displayed for the complete details
  712. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'provider_id', 'carrier_ref', 'speed')); // Attributes to be displayed for a list
  713. // Search criteria
  714. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'location1_id','location2_id','carrier_ref', 'speed', 'provider_id')); // Criteria of the std search form
  715. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'location1_id','location2_id','carrier_ref', 'speed', 'provider_id')); // Criteria of the advanced search form
  716. }
  717. public function ComputeValues()
  718. {
  719. /*
  720. $oLocatedObject = MetaModel::GetObject("Located Object", $this->Get("located_object_id"));
  721. $this->Set("location_id", $oLocatedObject->Get("location_id"));
  722. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  723. $this->Set("location_name", "abc (to be finalized)");
  724. $this->Set("device_id", $oLocatedObject->Get("device_id"));
  725. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  726. $this->Set("device_name", "abc (to be finalized)");
  727. $this->Set("interface_id", $oLocatedObject->Get("interface_id"));
  728. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  729. $this->Set("interface_name", "abc (to be finalized)");
  730. */
  731. }
  732. }
  733. ////////////////////////////////////////////////////////////////////////////////////
  734. /**
  735. * Any Device Network Interface
  736. */
  737. ////////////////////////////////////////////////////////////////////////////////////
  738. class bizInterface extends logInfra
  739. {
  740. public static function Init()
  741. {
  742. $aParams = array
  743. (
  744. "category" => "bizmodel,searchable",
  745. "name" => "Interface",
  746. "description" => "Interface",
  747. "key_type" => "",
  748. "key_label" => "id",
  749. "name_attcode" => "name",
  750. "state_attcode" => "",
  751. "reconc_keys" => array("org_id", "device_id", "name"),
  752. "db_table" => "interfaces",
  753. "db_key_field" => "id",
  754. "db_finalclass_field" => "",
  755. "display_template" => "../business/templates/interface.html",
  756. );
  757. MetaModel::Init_Params($aParams);
  758. MetaModel::Init_InheritAttributes();
  759. MetaModel::Init_AddAttribute(new AttributeExternalKey("device_id", array("targetclass"=>"bizDevice", "label"=>"Device", "description"=>"Device on which the interface is physically located", "allowed_values"=>null, "sql"=>"device_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  760. MetaModel::Init_AddAttribute(new AttributeExternalField("device_name", array("label"=>"Device", "description"=>"name of the device on which the interface is located", "allowed_values"=>null, "extkey_attcode"=> 'device_id', "target_attcode"=>"name")));
  761. MetaModel::Init_AddAttribute(new AttributeExternalField("device_location_id", array("label"=>"Device location", "description"=>"location of the device on which the interface is located", "allowed_values"=>null, "extkey_attcode"=> 'device_id', "target_attcode"=>"location_id")));
  762. MetaModel::Init_AddAttribute(new AttributeExternalField("device_location_name", array("label"=>"Device location", "description"=>"name of the location of the device on which the interface is located", "allowed_values"=>null, "extkey_attcode"=> 'device_id', "target_attcode"=>"location_name")));
  763. MetaModel::Init_AddAttribute(new AttributeEnum("logical_type", array("label"=>"Logical type", "description"=>"Logical type of interface", "allowed_values"=>new ValueSetEnum("primary,secondary,backup,port,logical"), "sql"=>"logical_type", "default_value"=>"port", "is_null_allowed"=>false, "depends_on"=>array())));
  764. MetaModel::Init_AddAttribute(new AttributeEnum("physical_type", array("label"=>"Physical type", "description"=>"Physical type of interface", "allowed_values"=>new ValueSetEnum("ethernet,framerelay,atm,vlan"), "sql"=>"physical_type", "default_value"=>"ethernet", "is_null_allowed"=>false, "depends_on"=>array())));
  765. MetaModel::Init_AddAttribute(new AttributeString("ip_address", array("label"=>"IP address", "description"=>"address IP for this interface", "allowed_values"=>null, "sql"=>"ip_address", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  766. MetaModel::Init_AddAttribute(new AttributeString("mask", array("label"=>"Subnet Mask", "description"=>"Subnet mask for this interface", "allowed_values"=>null, "sql"=>"mask", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  767. MetaModel::Init_AddAttribute(new AttributeString("mac", array("label"=>"MAC address", "description"=>"MAC address for this interface", "allowed_values"=>null, "sql"=>"mac", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  768. MetaModel::Init_AddAttribute(new AttributeString("speed", array("label"=>"Speed (Kb/s)", "description"=>"speed of this interface", "allowed_values"=>null, "sql"=>"speed", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  769. MetaModel::Init_AddAttribute(new AttributeEnum("duplex", array("label"=>"Duplex", "description"=>"Duplex configured for this interface", "allowed_values"=>new ValueSetEnum("half,full,unknown"), "sql"=>"duplex", "default_value"=>"unknown", "is_null_allowed"=>true, "depends_on"=>array())));
  770. MetaModel::Init_AddAttribute(new AttributeExternalKey("if_connected_id", array("targetclass"=>"bizInterface", "label"=>"Connected interface", "description"=>"interface connected to this one", "allowed_values"=>null, "sql"=>"ext_if_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  771. MetaModel::Init_AddAttribute(new AttributeExternalField("if_connected_name", array("label"=>"Connected interface", "description"=>"name of the interface connected to this one", "allowed_values"=>null, "extkey_attcode"=> 'if_connected_id', "target_attcode"=>"name")));
  772. MetaModel::Init_AddAttribute(new AttributeExternalField("if_connected_device", array("label"=>"Connected device", "description"=>"name of the device connected to this interface", "allowed_values"=>null, "extkey_attcode"=> 'if_connected_id', "target_attcode"=>"device_name")));
  773. MetaModel::Init_InheritFilters();
  774. MetaModel::Init_AddFilterFromAttribute("device_id");
  775. MetaModel::Init_AddFilterFromAttribute("device_name");
  776. MetaModel::Init_AddFilterFromAttribute("device_location_id");
  777. MetaModel::Init_AddFilterFromAttribute("logical_type");
  778. MetaModel::Init_AddFilterFromAttribute("physical_type");
  779. MetaModel::Init_AddFilterFromAttribute("ip_address");
  780. MetaModel::Init_AddFilterFromAttribute("mac");
  781. MetaModel::Init_AddFilterFromAttribute("if_connected_id");
  782. // Display lists
  783. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'device_id', 'device_location_id','severity','logical_type','physical_type','ip_address','mask','mac','speed','duplex','if_connected_name','if_connected_device')); // Attributes to be displayed for the complete details
  784. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'device_id','severity')); // Attributes to be displayed for a list
  785. // Search criteria
  786. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'ip_address','mac','device_id')); // Criteria of the std search form
  787. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'device_id', 'org_id')); // Criteria of the advanced search form
  788. }
  789. function DisplayDetails(WebPage $oPage)
  790. {
  791. parent::DisplayDetails($oPage);
  792. /*
  793. $oSearchFilter = new CMDBSearchFilter('lnkInterfaces');
  794. $oSearchFilter->AddCondition('interface1_id', $this->GetKey(), '=');
  795. $oSet = new CMDBObjectSet($oSearchFilter);
  796. $count = $oSet->Count();
  797. if ($count > 0)
  798. {
  799. $oPage->SetCurrentTab("Connected interfaces");
  800. $oPage->p("$count interface(s) connected to this device:");
  801. $this->DisplaySet($oPage, $oSet);
  802. }
  803. */
  804. }
  805. public function ComputeValues()
  806. {
  807. /*
  808. // my location is the location of my device
  809. $oDevice = MetaModel::GetObject("bizDevice", $this->Get("device_id"));
  810. $this->Set("location_id", $oDevice->Get("location_id"));
  811. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  812. $this->Set("location_name", "abc (to be finalized)");
  813. // my device is given by my Creator
  814. // my interface is myself
  815. $this->Set("interface_id", $this->GetKey());
  816. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  817. $this->Set("interface_name", "abc (to be finalized)");
  818. */
  819. }
  820. }
  821. ////////////////////////////////////////////////////////////////////////////////////
  822. /**
  823. * A subnet
  824. */
  825. ////////////////////////////////////////////////////////////////////////////////////
  826. class bizSubnet extends logInfra
  827. {
  828. public static function Init()
  829. {
  830. $aParams = array
  831. (
  832. "category" => "bizmodel,searchable",
  833. "name" => "Subnet",
  834. "description" => "Logical or physical subnet",
  835. "key_type" => "",
  836. "key_label" => "id",
  837. "name_attcode" => "name",
  838. "state_attcode" => "",
  839. "reconc_keys" => array("org_id", "name"), // inherited attributes
  840. "db_table" => "subnets",
  841. "db_key_field" => "id",
  842. "db_finalclass_field" => "",
  843. "display_template" => "",
  844. );
  845. MetaModel::Init_Params($aParams);
  846. MetaModel::Init_InheritAttributes();
  847. MetaModel::Init_AddAttribute(new AttributeString("ip", array("label"=>"IP", "description"=>"IP", "allowed_values"=>null, "sql"=>"ip", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  848. MetaModel::Init_AddAttribute(new AttributeString("mask", array("label"=>"IP mask", "description"=>"IP mask", "allowed_values"=>null, "sql"=>"mask", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  849. MetaModel::Init_InheritFilters();
  850. MetaModel::Init_AddFilterFromAttribute("ip");
  851. MetaModel::Init_AddFilterFromAttribute("mask");
  852. // Display lists
  853. MetaModel::Init_SetZListItems('details', array('name', 'ip','mask')); // Attributes to be displayed for the complete details
  854. MetaModel::Init_SetZListItems('list', array('name', 'ip', 'mask')); // Attributes to be displayed for a list
  855. // Search criteria
  856. MetaModel::Init_SetZListItems('standard_search', array('name', 'ip','mask')); // Criteria of the std search form
  857. MetaModel::Init_SetZListItems('advanced_search', array('name', 'ip','mask')); // Criteria of the advanced search form
  858. }
  859. function DisplayBareRelations(WebPage $oPage)
  860. {
  861. parent::DisplayBareRelations($oPage);
  862. $oPage->SetCurrentTabContainer('Related Objects');
  863. $oPage->SetCurrentTab('IP Usage');
  864. $bit_ip = ip2long($this->Get('ip'));
  865. $bit_mask = ip2long($this->Get('mask'));
  866. $sIPMin = long2ip($bit_ip & $bit_mask);
  867. $sIPMax = long2ip(($bit_ip | (~$bit_mask)) - 1);
  868. $oPage->p("Interfaces having an IP in the range: <em>$sIPMin</em> to <em>$sIPMax</em>");
  869. $oIfSet = new CMDBObjectSet(DBObjectSearch::FromOQL("SELECT bizInterface AS if WHERE INET_ATON(if.ip_address) >= INET_ATON('$sIPMin') AND INET_ATON(if.ip_address) <= INET_ATON('$sIPMax')"));
  870. self::DisplaySet($oPage, $oIfSet);
  871. $iCountUsed = $oIfSet->Count();
  872. $iCountRange = ip2long($sIPMax) - ip2long($sIPMin);
  873. $iFreeCount = $iCountRange - $iCountUsed;
  874. $oPage->SetCurrentTab('Free IPs');
  875. $oPage->p("Free IPs: $iFreeCount");
  876. $oPage->p("Here is an extract of 10 free IP addresses");
  877. $aUsedIPs = $oIfSet->GetColumnAsArray('ip_address', false);
  878. $i = 0;
  879. while ($i < min($iFreeCount, 10))
  880. {
  881. $i++;
  882. $iAnIP = ip2long($sIPMin) + $i;
  883. if (in_array($iAnIP, $aUsedIPs)) continue;
  884. $sAnIP = long2ip($iAnIP);
  885. $oPage->p($sAnIP);
  886. }
  887. }
  888. }
  889. ////////////////////////////////////////////////////////////////////////////////////
  890. /**
  891. * Any electronic device
  892. */
  893. ////////////////////////////////////////////////////////////////////////////////////
  894. class bizDevice extends logInfra
  895. {
  896. public static function Init()
  897. {
  898. $aParams = array
  899. (
  900. "category" => "bizmodel,searchable",
  901. "name" => "Device",
  902. "description" => "Electronic devices",
  903. "key_type" => "",
  904. "key_label" => "id",
  905. "name_attcode" => "name",
  906. "state_attcode" => "",
  907. "reconc_keys" => array("org_id", "name"), // inherited attributes
  908. "db_table" => "devices",
  909. "db_key_field" => "id",
  910. "db_finalclass_field" => "",
  911. "display_template" => "../business/templates/default.html",
  912. );
  913. MetaModel::Init_Params($aParams);
  914. MetaModel::Init_InheritAttributes();
  915. MetaModel::Init_AddAttribute(new AttributeExternalKey("location_id", array("targetclass"=>"bizLocation", "label"=>"Location", "description"=>"where is the located object physically located", "allowed_values"=>new ValueSetObjects('SELECT bizLocation AS p WHERE p.org_id = :this->org_id'), "sql"=>"location_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  916. MetaModel::Init_AddAttribute(new AttributeExternalField("location_name", array("label"=>"Location Name", "description"=>"name of the location", "allowed_values"=>null, "extkey_attcode"=> 'location_id', "target_attcode"=>"name")));
  917. MetaModel::Init_AddAttribute(new AttributeExternalField("country", array("label"=>"Country", "description"=>"country where the device is located", "allowed_values"=>null, "extkey_attcode"=> 'location_id', "target_attcode"=>"country")));
  918. MetaModel::Init_AddAttribute(new AttributeString("brand", array("label"=>"Brand", "description"=>"The manufacturer of the device", "allowed_values"=>null, "sql"=>"brand", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  919. MetaModel::Init_AddAttribute(new AttributeString("model", array("label"=>"Model", "description"=>"The model number of the device", "allowed_values"=>null, "sql"=>"model", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  920. MetaModel::Init_AddAttribute(new AttributeString("serial_number", array("label"=>"Serial Number", "description"=>"The serial number of the device", "allowed_values"=>null, "sql"=>"serial_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  921. MetaModel::Init_AddAttribute(new AttributeString("mgmt_ip", array("label"=>"Mgmt IP", "description"=>"Management IP", "allowed_values"=>null, "sql"=>"mgmt_ip", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  922. MetaModel::Init_InheritFilters();
  923. MetaModel::Init_AddFilterFromAttribute("location_id");
  924. MetaModel::Init_AddFilterFromAttribute("country");
  925. MetaModel::Init_AddFilterFromAttribute("brand");
  926. MetaModel::Init_AddFilterFromAttribute("model");
  927. MetaModel::Init_AddFilterFromAttribute("serial_number");
  928. MetaModel::Init_AddFilterFromAttribute("mgmt_ip");
  929. }
  930. public static function GetRelationQueries($sRelCode)
  931. {
  932. switch ($sRelCode)
  933. {
  934. case "impacts":
  935. $aRels = array(
  936. // commented out, because lnkInterfaces does not exist anymore
  937. // "connected device" => array("sQuery"=>"bizDevice: PKEY IS device_id IN (bizInterface: PKEY IS interface2_id IN (lnkInterfaces: interface1_id IN (bizInterface: device_id = \$[this.pkey::])))", "bPropagate"=>true, "iDistance"=>3),
  938. "hosted app" => array("sQuery"=>"bizApplication: infra_id = \$[this.pkey::]", "bPropagate"=>true, "iDistance"=>3),
  939. );
  940. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  941. }
  942. }
  943. public function ComputeValues()
  944. {
  945. /*
  946. // my location is the location of my device (external field)
  947. $this->Set("location_id", $this->Get("device_location_id"));
  948. // Houston, I've got an issue, as this field is calculated, I should reload the object...
  949. $this->Set("location_name", "abc (to be finalized)");
  950. // my device is myself
  951. $this->Set("device_id", $this->GetKey());
  952. // my interface is "nothing"
  953. $this->Set("interface_id", null);
  954. */
  955. }
  956. }
  957. ////////////////////////////////////////////////////////////////////////////////////
  958. /**
  959. * A personal computer
  960. */
  961. ////////////////////////////////////////////////////////////////////////////////////
  962. class bizPC extends bizDevice
  963. {
  964. public static function Init()
  965. {
  966. $aParams = array
  967. (
  968. "category" => "bizmodel,searchable",
  969. "name" => "PC",
  970. "description" => "Personal Computers",
  971. "key_type" => "",
  972. "key_label" => "id",
  973. "name_attcode" => "name",
  974. "state_attcode" => "",
  975. "reconc_keys" => array("org_id", "name"), // inherited attributes
  976. "db_table" => "pcs",
  977. "db_key_field" => "id",
  978. "db_finalclass_field" => "",
  979. "display_template" => "../business/templates/pc.html",
  980. );
  981. MetaModel::Init_Params($aParams);
  982. MetaModel::Init_InheritAttributes();
  983. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("label"=>"Type", "description"=>"Type of computer", "allowed_values"=>new ValueSetEnum("desktop PC,laptop"), "sql"=>"type", "default_value"=>"desktop PC", "is_null_allowed"=>false, "depends_on"=>array())));
  984. MetaModel::Init_AddAttribute(new AttributeString("memory_size", array("label"=>"Memory Size", "description"=>"Size of the memory", "allowed_values"=>null, "sql"=>"memory_size", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  985. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("label"=>"CPU", "description"=>"CPU type", "allowed_values"=>null, "sql"=>"cpu_type", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  986. MetaModel::Init_AddAttribute(new AttributeString("hdd_size", array("label"=>"HDD Size", "description"=>"Size of the hard drive", "allowed_values"=>null, "sql"=>"hdd_size", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  987. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("label"=>"OS Family", "description"=>"Type of operating system", "allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  988. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("label"=>"OS Version", "description"=>"Detailed version number of the operating system", "allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  989. MetaModel::Init_AddAttribute(new AttributeString("shipment_number", array("label"=>"Shipment Code", "description"=>"Number for tracking shipment", "allowed_values"=>null, "sql"=>"shipment_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  990. MetaModel::Init_AddAttribute(new AttributeString("default_gateway", array("label"=>"Default Gateway", "description"=>"Default Gateway for this device", "allowed_values"=>null, "sql"=>"default_gateway", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  991. MetaModel::Init_InheritFilters();
  992. MetaModel::Init_AddFilterFromAttribute("type");
  993. MetaModel::Init_AddFilterFromAttribute("memory_size");
  994. MetaModel::Init_AddFilterFromAttribute("cpu");
  995. MetaModel::Init_AddFilterFromAttribute("hdd_size");
  996. MetaModel::Init_AddFilterFromAttribute("os_family");
  997. MetaModel::Init_AddFilterFromAttribute("os_version");
  998. // Display lists
  999. MetaModel::Init_SetZListItems('details', array('name', 'status','severity', 'org_id', 'location_id', 'brand', 'model','os_family','os_version','mgmt_ip','default_gateway','shipment_number','serial_number', 'type', 'cpu', 'memory_size', 'hdd_size')); // Attributes to be displayed for the complete details
  1000. MetaModel::Init_SetZListItems('list', array('name', 'status', 'severity', 'org_id', 'location_id', 'brand', 'model', 'type')); // Attributes to be displayed for a list
  1001. // Search criteria
  1002. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'severity','type', 'brand', 'model','os_family','mgmt_ip')); // Criteria of the std search form
  1003. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'type', 'brand', 'model', 'cpu', 'memory_size', 'hdd_size')); // Criteria of the advanced search form
  1004. }
  1005. function DisplayDetails(WebPage $oPage)
  1006. {
  1007. parent::DisplayDetails($oPage);
  1008. /*
  1009. parent::DisplayDetails($oPage);
  1010. $oSearchFilter = new CMDBSearchFilter('lnkContactRealObject');
  1011. $oSearchFilter->AddCondition('object_id', $this->GetKey(), '=');
  1012. $oSet = new CMDBObjectSet($oSearchFilter);
  1013. $count = $oSet->Count();
  1014. if ($count > 0)
  1015. {
  1016. $oPage->SetCurrentTab("Contacts");
  1017. $oPage->p("$count contact(s) linked to this PC:");
  1018. $this->DisplaySet($oPage, $oSet);
  1019. }
  1020. $oSearchFilter = new CMDBSearchFilter('bizInterface');
  1021. $oSearchFilter->AddCondition('device_id', $this->GetKey(), '=');
  1022. $oSet = new CMDBObjectSet($oSearchFilter);
  1023. $count = $oSet->Count();
  1024. if ($count > 0)
  1025. {
  1026. $oPage->SetCurrentTab("Interfaces");
  1027. $oPage->p("$count interface(s) for this device:");
  1028. $this->DisplaySet($oPage, $oSet);
  1029. }
  1030. */
  1031. }
  1032. public function Generate(cmdbDataGenerator $oGenerator)
  1033. {
  1034. $this->Set('org_id', $oGenerator->GetOrganizationId());
  1035. $this->Set('location_id', $oGenerator->GenerateKey("bizLocation", array('org_id' =>$oGenerator->GetOrganizationId() )));
  1036. $this->Set('name', $oGenerator->GenerateString("enum(pc,pc,pc,pc,pc,win,redhat,linux,srv,workstation)|number(000-999)|.|domain()"));
  1037. $this->Set('brand', $oGenerator->GenerateString("enum(Hewlett-Packard,Dell,Compaq,Siemens,Packard Bell,IBM,Gateway,Medion,Sony)"));
  1038. $this->Set('model', $oGenerator->GenerateString("enum(Vectra,Deskpro,Dimension,Optiplex,Latitude,Precision,Vaio)"));
  1039. $this->Set('serial_number', $oGenerator->GenerateString("enum(FR,US,TW,CH)|number(000000-999999)"));
  1040. $this->Set('memory_size', $oGenerator->GenerateString("enum(128,256,384,512,768,1024,1536,2048)"));
  1041. $this->Set('cpu', $oGenerator->GenerateString("enum(Pentium III,Pentium 4, Pentium M,Core Duo,Core 2 Duo,Celeron,Opteron,Thurion,Athlon)"));
  1042. $this->Set('hdd_size', $oGenerator->GenerateString("enum(40,60,80,120,200,300)"));
  1043. }
  1044. }
  1045. ////////////////////////////////////////////////////////////////////////////////////
  1046. /**
  1047. * A server
  1048. */
  1049. ////////////////////////////////////////////////////////////////////////////////////
  1050. class bizServer extends bizDevice
  1051. {
  1052. public static function Init()
  1053. {
  1054. $aParams = array
  1055. (
  1056. "category" => "bizmodel,searchable",
  1057. "name" => "Server",
  1058. "description" => "Computer Servers",
  1059. "key_type" => "",
  1060. "key_label" => "id",
  1061. "name_attcode" => "name",
  1062. "state_attcode" => "status",
  1063. "state_attcode" => "",
  1064. "reconc_keys" => array("org_id", "name"), // inherited attributes
  1065. "db_table" => "servers",
  1066. "db_key_field" => "id",
  1067. "db_finalclass_field" => "",
  1068. "display_template" => "../business/templates/server.html",
  1069. );
  1070. MetaModel::Init_Params($aParams);
  1071. MetaModel::Init_InheritAttributes();
  1072. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Status of the server", "allowed_values"=>new ValueSetEnum("InStore,Shipped,Plugged,ProductionCandidate,InProduction,BeingDeconfigured,Obsolete"), "sql"=>"status", "default_value"=>"InStore", "is_null_allowed"=>false, "depends_on"=>array())));
  1073. MetaModel::Init_AddAttribute(new AttributeString("memory_size", array("label"=>"Memory Size", "description"=>"Size of the memory", "allowed_values"=>null, "sql"=>"memory_size", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1074. MetaModel::Init_AddAttribute(new AttributeString("cpu", array("label"=>"CPU type", "description"=>"CPU type", "allowed_values"=>null, "sql"=>"cpu_type", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1075. MetaModel::Init_AddAttribute(new AttributeString("number_of_cpus", array("label"=>"Number of CPUs", "description"=>"Number of CPUs", "allowed_values"=>null, "sql"=>"number_of_cpus", "default_value"=>"1", "is_null_allowed"=>true, "depends_on"=>array())));
  1076. MetaModel::Init_AddAttribute(new AttributeString("hdd_size", array("label"=>"HDD Size", "description"=>"Size of the hard drive", "allowed_values"=>null, "sql"=>"hdd_size", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1077. MetaModel::Init_AddAttribute(new AttributeString("hdd_free_size", array("label"=>"Free HDD Size", "description"=>"Size of the free space on the hard drive(s)", "allowed_values"=>null, "sql"=>"hdd_free_size", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1078. MetaModel::Init_AddAttribute(new AttributeString("os_family", array("label"=>"OS Family", "description"=>"Type of operating system", "allowed_values"=>null, "sql"=>"os_family", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1079. MetaModel::Init_AddAttribute(new AttributeString("os_version", array("label"=>"OS Version", "description"=>"Detailed version number of the operating system", "allowed_values"=>null, "sql"=>"os_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1080. MetaModel::Init_AddAttribute(new AttributeString("shipment_number", array("label"=>"Shipment number", "description"=>"Number for tracking shipment", "allowed_values"=>null, "sql"=>"shipment_number", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1081. MetaModel::Init_AddAttribute(new AttributeString("default_gateway", array("label"=>"Default Gateway", "description"=>"Default Gateway for this device", "allowed_values"=>null, "sql"=>"default_gateway", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1082. MetaModel::Init_InheritFilters();
  1083. MetaModel::Init_AddFilterFromAttribute("status");
  1084. MetaModel::Init_AddFilterFromAttribute("memory_size");
  1085. MetaModel::Init_AddFilterFromAttribute("cpu");
  1086. MetaModel::Init_AddFilterFromAttribute("number_of_cpus");
  1087. MetaModel::Init_AddFilterFromAttribute("hdd_size");
  1088. MetaModel::Init_AddFilterFromAttribute("hdd_free_size");
  1089. MetaModel::Init_AddFilterFromAttribute("os_family");
  1090. MetaModel::Init_AddFilterFromAttribute("os_version");
  1091. /*
  1092. // Life cycle
  1093. MetaModel::Init_DefineState("InStore", array("label"=>"InStore", "description"=>"Device in store", "attribute_inherit"=>null,
  1094. "attribute_list"=>array()));
  1095. MetaModel::Init_DefineState("Shipped", array("label"=>"Shipped", "description"=>"The device had been shipped to future location", "attribute_inherit"=>null,
  1096. "attribute_list"=>array("location_id"=>OPT_ATT_MANDATORY,"serial_number"=>OPT_ATT_MANDATORY,"shipment_number"=>OPT_ATT_MANDATORY)));
  1097. MetaModel::Init_DefineState("Plugged", array("label"=>"Plugged", "description"=>"The device is connected to the network", "attribute_inherit"=>null,
  1098. "attribute_list"=>array("location_id"=>OPT_ATT_MANDATORY,"mgmt_ip"=>OPT_ATT_MANDATORY,"name"=>OPT_ATT_MANDATORY)));
  1099. MetaModel::Init_DefineState("ProductionCandidate", array("label"=>"Pre-Production", "description"=>"The device is ready to be move to production", "attribute_inherit"=>null,
  1100. "attribute_list"=>array()));
  1101. MetaModel::Init_DefineState("InProduction", array("label"=>"Production", "description"=>"The device is on production", "attribute_inherit"=>null,
  1102. "attribute_list"=>array()));
  1103. MetaModel::Init_DefineState("BeingDeconfigured", array("label"=>"BeingDeconfigured", "description"=>"The device is about to be removed from is current location", "attribute_inherit"=>null,
  1104. "attribute_list"=>array()));
  1105. MetaModel::Init_DefineState("Obsolete", array("label"=>"Obsolete", "description"=>"The device is no more used", "attribute_inherit"=>null,
  1106. "attribute_list"=>array()));
  1107. MetaModel::Init_DefineStimulus("ev_store", new StimulusUserAction(array("label"=>"Store this server", "description"=>"This server is move to storage")));
  1108. MetaModel::Init_DefineStimulus("ev_ship", new StimulusUserAction(array("label"=>"Ship this server", "description"=>"This server is shipped to futur location")));
  1109. MetaModel::Init_DefineStimulus("ev_plug", new StimulusUserAction(array("label"=>"Plug this server", "description"=>"The server is pluuged on the network")));
  1110. MetaModel::Init_DefineStimulus("ev_configuration_finished", new StimulusUserAction(array("label"=>"Configuration finished", "description"=>"The device is ready to move to production evaluation")));
  1111. MetaModel::Init_DefineStimulus("ev_val_failed", new StimulusUserAction(array("label"=>"Review configuration", "description"=>"The configuration for this server is not completed")));
  1112. MetaModel::Init_DefineStimulus("ev_mtp", new StimulusUserAction(array("label"=>"Move to Production", "description"=>"The server is moved to production")));
  1113. MetaModel::Init_DefineStimulus("ev_decommission", new StimulusUserAction(array("label"=>"Decommission", "description"=>"The server is being decommissioned")));
  1114. MetaModel::Init_DefineStimulus("ev_obsolete", new StimulusUserAction(array("label"=>"Obsolete", "description"=>"The server is no more used")));
  1115. MetaModel::Init_DefineStimulus("ev_recycle", new StimulusUserAction(array("label"=>"Recycle this server", "description"=>"The server is move back to deconfiguration")));
  1116. MetaModel::Init_DefineTransition("InStore", "ev_ship", array("target_state"=>"Shipped", "actions"=>array(), "user_restriction"=>null));
  1117. MetaModel::Init_DefineTransition("InStore", "ev_plug", array("target_state"=>"Plugged", "actions"=>array(), "user_restriction"=>null));
  1118. MetaModel::Init_DefineTransition("Shipped", "ev_store", array("target_state"=>"InStore", "actions"=>array(), "user_restriction"=>null));
  1119. MetaModel::Init_DefineTransition("Shipped", "ev_plug", array("target_state"=>"Plugged", "actions"=>array(), "user_restriction"=>null));
  1120. MetaModel::Init_DefineTransition("Plugged", "ev_ship", array("target_state"=>"Shipped", "actions"=>array(), "user_restriction"=>null));
  1121. MetaModel::Init_DefineTransition("Plugged", "ev_store", array("target_state"=>"InStore", "actions"=>array(), "user_restriction"=>null));
  1122. MetaModel::Init_DefineTransition("Plugged", "ev_configuration_finished", array("target_state"=>"ProductionCandidate", "actions"=>array(), "user_restriction"=>null));
  1123. MetaModel::Init_DefineTransition("ProductionCandidate", "ev_val_failed", array("target_state"=>"Plugged", "actions"=>array(), "user_restriction"=>null));
  1124. MetaModel::Init_DefineTransition("ProductionCandidate", "ev_mtp", array("target_state"=>"InProduction", "actions"=>array(), "user_restriction"=>null));
  1125. MetaModel::Init_DefineTransition("InProduction", "ev_obsolete", array("target_state"=>"Obsolete", "actions"=>array(), "user_restriction"=>null));
  1126. MetaModel::Init_DefineTransition("InProduction", "ev_decommission", array("target_state"=>"BeingDeconfigured", "actions"=>array(), "user_restriction"=>null));
  1127. MetaModel::Init_DefineTransition("BeingDeconfigured", "ev_ship", array("target_state"=>"Shipped", "actions"=>array(), "user_restriction"=>null));
  1128. MetaModel::Init_DefineTransition("BeingDeconfigured", "ev_plug", array("target_state"=>"Plugged", "actions"=>array(), "user_restriction"=>null));
  1129. MetaModel::Init_DefineTransition("BeingDeconfigured", "ev_store", array("target_state"=>"InStore", "actions"=>array(), "user_restriction"=>null));
  1130. MetaModel::Init_DefineTransition("BeingDeconfigured", "ev_obsolete", array("target_state"=>"Obsolete", "actions"=>array(), "user_restriction"=>null));
  1131. MetaModel::Init_DefineTransition("Obsolete", "ev_recycle", array("target_state"=>"BeingDeconfigured", "actions"=>array(), "user_restriction"=>null));
  1132. */
  1133. // Display lists
  1134. MetaModel::Init_SetZListItems('details', array('name', 'status', 'mgmt_ip','default_gateway', 'severity','org_id', 'location_id', 'brand', 'model', 'os_family', 'os_version','serial_number','shipment_number', 'cpu', 'number_of_cpus', 'memory_size', 'hdd_size', 'hdd_free_size')); // Attributes to be displayed for the complete details
  1135. MetaModel::Init_SetZListItems('list', array('name', 'status','severity', 'org_id', 'location_id', 'brand', 'model', 'os_family', 'os_version')); // Attributes to be displayed for a list
  1136. // Search criteria
  1137. MetaModel::Init_SetZListItems('standard_search', array('name', 'status','severity', 'brand', 'model', 'os_family', 'location_id')); // Criteria of the std search form
  1138. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status','brand', 'model', 'os_family', 'os_version', 'location_id', 'cpu', 'number_of_cpus', 'memory_size', 'hdd_size', 'hdd_free_size')); // Criteria of the advanced search form
  1139. }
  1140. function DisplayDetails(WebPage $oPage)
  1141. {
  1142. parent::DisplayDetails($oPage);
  1143. /*
  1144. parent::DisplayDetails($oPage);
  1145. $oSearchFilter = new CMDBSearchFilter('lnkContactRealObject');
  1146. $oSearchFilter->AddCondition('object_id', $this->GetKey(), '=');
  1147. $oSet = new CMDBObjectSet($oSearchFilter);
  1148. $count = $oSet->Count();
  1149. if ($count > 0)
  1150. {
  1151. $oPage->SetCurrentTab("Contacts");
  1152. $oPage->p("$count contact(s) for this server:");
  1153. $this->DisplaySet($oPage, $oSet);
  1154. }
  1155. $oSearchFilter = new CMDBSearchFilter('bizInterface');
  1156. $oSearchFilter->AddCondition('device_id', $this->GetKey(), '=');
  1157. $oSet = new CMDBObjectSet($oSearchFilter);
  1158. $count = $oSet->Count();
  1159. if ($count > 0)
  1160. {
  1161. $oPage->SetCurrentTab("Interfaces");
  1162. $oPage->p("$count interface(s) for this server:");
  1163. $this->DisplaySet($oPage, $oSet);
  1164. }
  1165. $oSearchFilter = new CMDBSearchFilter('Application');
  1166. $oSearchFilter->AddCondition('infra_id', $this->GetKey(), '=');
  1167. $oSet = new CMDBObjectSet($oSearchFilter);
  1168. $count = $oSet->Count();
  1169. if ($count > 0)
  1170. {
  1171. $oPage->SetCurrentTab("Installed applications");
  1172. $oPage->p("$count application(s) installed on this server:");
  1173. $this->DisplaySet($oPage, $oSet);
  1174. }
  1175. $oSearchFilter = new CMDBSearchFilter('bizPatch');
  1176. $oSearchFilter->AddCondition('infra_id', $this->GetKey(), '=');
  1177. $oSet = new CMDBObjectSet($oSearchFilter);
  1178. $count = $oSet->Count();
  1179. if ($count > 0)
  1180. {
  1181. $oPage->SetCurrentTab("Installed patches");
  1182. $oPage->p("$count patch(s) installed on this server:");
  1183. $this->DisplaySet($oPage, $oSet);
  1184. }
  1185. */
  1186. }
  1187. public function Generate(cmdbDataGenerator $oGenerator)
  1188. {
  1189. $this->Set('org_id', $oGenerator->GetOrganizationId());
  1190. $this->Set('location_id', $oGenerator->GenerateKey("bizLocation", array('org_id' =>$oGenerator->GetOrganizationId() )));
  1191. $this->Set('name', $oGenerator->GenerateString("enum(pc,pc,pc,pc,pc,win,redhat,linux,srv,workstation)|number(000-999)|.|domain()"));
  1192. $this->Set('brand', $oGenerator->GenerateString("enum(Hewlett-Packard,Dell,Compaq,Siemens,Packard Bell,IBM,Gateway,Medion,Sony)"));
  1193. $this->Set('model', $oGenerator->GenerateString("enum(Vectra,Deskpro,Dimension,Optiplex,Latitude,Precision,Vaio)"));
  1194. $this->Set('serial_number', $oGenerator->GenerateString("enum(FR,US,TW,CH)|number(000000-999999)"));
  1195. $this->Set('memory_size', $oGenerator->GenerateString("enum(512,1024,2048,4096,2048,4096,8192,8192,8192,16384,32768)"));
  1196. $this->Set('cpu', $oGenerator->GenerateString("enum(Pentium III,Pentium 4,Pentium M,Core Duo,Core 2 Duo,Celeron,Opteron,Thurion,Athlon)"));
  1197. $this->Set('number_of_cpu', $oGenerator->GenerateString("enum(1,1,2,2,2,2,2,4,4,8)"));
  1198. $this->Set('hdd_size', $oGenerator->GenerateString("enum(500,1024,500,1024,500,1024,2048)"));
  1199. $this->Set('hdd_free_size', $this->Get('hdd_size')*$oGenerator->GenerateString("number(20-80)"));
  1200. $this->Set('os_family', $oGenerator->GenerateString("enum(Windows,Windows,Windows,Linux,Windows,Linux,Windows,Linux,Linux,HP-UX,Solaris,AIX)"));
  1201. $this->Set('os_version', $oGenerator->GenerateString("enum(XP,XP,XP,RH EL 4,RH EL 5,SuSE 10.3,SuSE 10.4,11.11,11.11i)"));
  1202. }
  1203. }
  1204. ////////////////////////////////////////////////////////////////////////////////////
  1205. /**
  1206. * A network device
  1207. */
  1208. ////////////////////////////////////////////////////////////////////////////////////
  1209. class bizNetworkDevice extends bizDevice
  1210. {
  1211. public static function Init()
  1212. {
  1213. $aParams = array
  1214. (
  1215. "category" => "bizmodel,searchable",
  1216. "name" => "Network Device",
  1217. "description" => "A network device",
  1218. "key_type" => "",
  1219. "key_label" => "id",
  1220. "name_attcode" => "name",
  1221. "state_attcode" => "",
  1222. "reconc_keys" => array("org_id", "name"), // inherited attributes
  1223. "db_table" => "network_devices",
  1224. "db_key_field" => "id",
  1225. "db_finalclass_field" => "",
  1226. "display_template" => "../business/templates/network.device.html",
  1227. );
  1228. MetaModel::Init_Params($aParams);
  1229. MetaModel::Init_InheritAttributes();
  1230. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("label"=>"Type", "description"=>"Type of device", "allowed_values"=>new ValueSetEnum("switch,router,firewall,load balancer,hub,WAN accelerator"), "sql"=>"type", "default_value"=>"switch", "is_null_allowed"=>false, "depends_on"=>array())));
  1231. MetaModel::Init_AddAttribute(new AttributeString("default_gateway", array("label"=>"Default Gateway", "description"=>"Default Gateway for this device", "allowed_values"=>null, "sql"=>"default_gateway", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1232. MetaModel::Init_AddAttribute(new AttributeString("ios_version", array("label"=>"IOS version", "description"=>"IOS (software) version", "allowed_values"=>null, "sql"=>"ios_version", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1233. MetaModel::Init_AddAttribute(new AttributeString("memory", array("label"=>"Memory", "description"=>"Memory description", "allowed_values"=>null, "sql"=>"memory", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1234. MetaModel::Init_AddAttribute(new AttributeString("snmp_read", array("label"=>"SNMP Community (Read)", "description"=>"SNMP Read Community String", "allowed_values"=>null, "sql"=>"snmp_read", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1235. MetaModel::Init_AddAttribute(new AttributeString("snmp_write", array("label"=>"SNMP Community (Write)", "description"=>"SNMP Write Community String", "allowed_values"=>null, "sql"=>"snmp_write", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1236. MetaModel::Init_InheritFilters();
  1237. MetaModel::Init_AddFilterFromAttribute("type");
  1238. MetaModel::Init_AddFilterFromAttribute("ios_version");
  1239. // Display lists
  1240. MetaModel::Init_SetZListItems('details', array('name', 'status','severity','org_id', 'location_id', 'brand','model','type','mgmt_ip','default_gateway','serial_number','ios_version','memory','snmp_read','snmp_write')); // Attributes to be displayed for the complete details
  1241. MetaModel::Init_SetZListItems('list', array('name', 'status','brand','model','type','mgmt_ip')); // Attributes to be displayed for a list
  1242. // Search criteria
  1243. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'location_id', 'brand','model','type','mgmt_ip')); // Criteria of the std search form
  1244. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'org_id', 'location_id', 'brand','model','type','mgmt_ip','serial_number','ios_version','snmp_read','snmp_write')); // Criteria of the advanced search form
  1245. }
  1246. public function Generate(cmdbDataGenerator $oGenerator)
  1247. {
  1248. $this->Set('org_id', $oGenerator->GetOrganizationId());
  1249. $this->Set('location_id', $oGenerator->GenerateKey("bizLocation", array('org_id' =>$oGenerator->GetOrganizationId() )));
  1250. $this->Set('name', $oGenerator->GenerateString("enum(sw,swi,switch,rout,rtr,gw)|number(000-999)|.|domain()"));
  1251. $this->Set('brand', $oGenerator->GenerateString("enum(Hewlett-Packard,Cisco,3Com,Avaya,Alcatel,Cabletron,Extrem Networks,Juniper,Netgear,Synopitcs,Xylan)"));
  1252. $this->Set('model', $oGenerator->GenerateString("enum(Procurve ,Catalyst ,Multiswitch ,C)|enum(25,26,36,40,65)|enum(00,09,10,50)"));
  1253. $this->Set('serial_number', $oGenerator->GenerateString("enum(FAA,AGA,PAD,COB,DFE)|number(0000-9999)|enum(M,X,L)"));
  1254. $this->Set('ip_address', $oGenerator->GenerateString("number(10-248)|.|number(1-254)|.|number(1-254)|.|number(1-254)"));
  1255. $this->Set('ios_version', $oGenerator->GenerateString("enum(9,10,12)|.|enum(0,1,2)|enum(,,,,XP,.5.1)"));
  1256. $this->Set('snmp_read', $oGenerator->GenerateString("enum(Ew,+0,**,Ps)|number(00-99)|enum(+,=,],;, )|enum(Aze,Vbn,Bbn,+9+,-9-,#)"));
  1257. $this->Set('snmp_write', $oGenerator->GenerateString("enum(M3,l3,$,*,Zz,Ks,jh)|number(00-99)|enum(A*e,V%n,Bbn,+,-,#)|number(0-9)"));
  1258. }
  1259. }
  1260. ////////////////////////////////////////////////////////////////////////////////////
  1261. /**
  1262. * A "Solution"
  1263. */
  1264. ////////////////////////////////////////////////////////////////////////////////////
  1265. class bizInfraGroup extends logInfra
  1266. {
  1267. public static function Init()
  1268. {
  1269. $aParams = array
  1270. (
  1271. "category" => "bizmodel,searchable",
  1272. "name" => "Infra Group",
  1273. "description" => "A group of infrastructure elements",
  1274. "key_type" => "",
  1275. "key_label" => "id",
  1276. "name_attcode" => "name",
  1277. "state_attcode" => "",
  1278. "reconc_keys" => array("org_id", "name"), // inherited attributes
  1279. "db_table" => "infra_group",
  1280. "db_key_field" => "id",
  1281. "db_finalclass_field" => "",
  1282. "display_template" => "../business/templates/group.html",
  1283. );
  1284. MetaModel::Init_Params($aParams);
  1285. MetaModel::Init_InheritAttributes();
  1286. MetaModel::Init_AddAttribute(new AttributeEnum("type", array("label"=>"Type", "description"=>"Type of groupe", "allowed_values"=>new ValueSetEnum("Monitoring,Reporting,list"), "sql"=>"type", "default_value"=>"list", "is_null_allowed"=>true, "depends_on"=>array())));
  1287. MetaModel::Init_AddAttribute(new AttributeString("description", array("label"=>"Description", "description"=>"usage of the Group", "allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1288. MetaModel::Init_AddAttribute(new AttributeExternalKey("parent_group_id", array("targetclass"=>"bizInfraGroup", "label"=>"Parent Group", "description"=>"including group", "allowed_values"=>null, "sql"=>"parent_group_id", "is_null_allowed"=>true, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  1289. MetaModel::Init_AddAttribute(new AttributeExternalField("parent_group_name", array("label"=>"Parent Group (Name)", "description"=>"name of the parent group", "allowed_values"=>null, "extkey_attcode"=> 'parent_group_id', "target_attcode"=>"name")));
  1290. MetaModel::Init_InheritFilters();
  1291. MetaModel::Init_AddFilterFromAttribute("type");
  1292. MetaModel::Init_AddFilterFromAttribute("parent_group_id");
  1293. MetaModel::Init_AddFilterFromAttribute("parent_group_name");
  1294. // Display lists
  1295. MetaModel::Init_SetZListItems('details', array('name', 'status', 'org_id', 'type', 'description','parent_group_id')); // Attributes to be displayed for a list
  1296. MetaModel::Init_SetZListItems('list', array('name', 'status', 'org_id', 'type', 'description')); // Attributes to be displayed for a list
  1297. // Search criteria
  1298. MetaModel::Init_SetZListItems('standard_search', array('name', 'status', 'type')); // Criteria of the std search form
  1299. MetaModel::Init_SetZListItems('advanced_search', array('name', 'status', 'type', 'description', 'org_id')); // Criteria of the advanced search form
  1300. }
  1301. function DisplayDetails(WebPage $oPage)
  1302. {
  1303. parent::DisplayDetails($oPage);
  1304. /*
  1305. $oSearchFilter = new CMDBSearchFilter('lnkInfraGrouping');
  1306. $oSearchFilter->AddCondition('infra_group_id', $this->GetKey(), '=');
  1307. $oSet = new CMDBObjectSet($oSearchFilter);
  1308. $count = $oSet->Count();
  1309. if ($count > 0)
  1310. {
  1311. $oPage->SetCurrentTab("RelatedInfrastructure");
  1312. $oPage->p("Infrastructure Link to this group:");
  1313. $this->DisplaySet($oPage, $oSet);
  1314. }
  1315. $oSearchFilter = new CMDBSearchFilter('lnkContactRealObject');
  1316. $oSearchFilter->AddCondition('object_id', $this->GetKey(), '=');
  1317. $oSet = new CMDBObjectSet($oSearchFilter);
  1318. $count = $oSet->Count();
  1319. if ($count > 0)
  1320. {
  1321. $oPage->SetCurrentTab("TeamLinks");
  1322. $oPage->p("People concerned by this group:");
  1323. $this->DisplaySet($oPage, $oSet);
  1324. }
  1325. */
  1326. }
  1327. public function Generate(cmdbDataGenerator $oGenerator)
  1328. {
  1329. $this->Set('org_id', $oGenerator->GetOrganizationId());
  1330. $this->Set('name', $oGenerator->GenerateString("enum(ov_nnm_,ovpi_,vitalnet_,datacenter_,web_farm_)|number(000-999)"));
  1331. $this->Set('type', $oGenerator->GenerateString("enum(Application,Infrastructure)"));
  1332. }
  1333. }
  1334. ////////////////////////////////////////////////////////////////////////////////////
  1335. //**
  1336. //* An application is an instance of a software install on a PC or Server
  1337. //*
  1338. ////////////////////////////////////////////////////////////////////////////////////
  1339. class bizApplication extends logInfra
  1340. {
  1341. public static function Init()
  1342. {
  1343. $aParams = array
  1344. (
  1345. "category" => "bizmodel,searchable",
  1346. "name" => "Application",
  1347. "description" => "General application",
  1348. "key_type" => "",
  1349. "key_label" => "id",
  1350. "name_attcode" => "name",
  1351. "state_attcode" => "",
  1352. "reconc_keys" => array("device_id", "name"), // inherited attributes
  1353. "db_table" => "applications",
  1354. "db_key_field" => "id",
  1355. "db_finalclass_field" => "",
  1356. "display_template" => "../business/templates/application.html",
  1357. );
  1358. MetaModel::Init_Params($aParams);
  1359. MetaModel::Init_InheritAttributes();
  1360. MetaModel::Init_AddAttribute(new AttributeExternalKey("device_id", array("targetclass"=>"bizDevice", "jointype"=> '', "label"=>"Hosting device", "description"=>"The device where application is installed", "allowed_values"=>new ValueSetObjects('SELECT bizDevice AS p WHERE p.org_id = :this->org_id'), "sql"=>"device_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  1361. MetaModel::Init_AddAttribute(new AttributeExternalField("device_name", array("label"=>"Hosting device", "description"=>"Name of the device where application is installed", "allowed_values"=>null, "extkey_attcode"=> 'device_id', "target_attcode"=>"name")));
  1362. MetaModel::Init_AddAttribute(new AttributeDate("install_date", array("label"=>"Installation Date", "description"=>"Date when application was installed", "allowed_values"=>null, "sql"=>"install_date", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  1363. MetaModel::Init_AddAttribute(new AttributeString("version", array("label"=>"Version", "description"=>"Application version", "allowed_values"=>null, "sql"=>"version", "default_value"=>"undefined", "is_null_allowed"=>false, "depends_on"=>array())));
  1364. MetaModel::Init_AddAttribute(new AttributeString("function", array("label"=>"Function", "description"=>"Function provided by this application", "allowed_values"=>null, "sql"=>"function", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  1365. MetaModel::Init_InheritFilters();
  1366. MetaModel::Init_AddFilterFromAttribute("function");
  1367. MetaModel::Init_AddFilterFromAttribute("version");
  1368. MetaModel::Init_AddFilterFromAttribute("device_id");
  1369. MetaModel::Init_AddFilterFromAttribute("device_name");
  1370. // Display lists
  1371. MetaModel::Init_SetZListItems('details', array('name','device_id','org_id','status','install_date', 'version','function')); // Attributes to be displayed for the complete details
  1372. MetaModel::Init_SetZListItems('list', array('name','device_id', 'version', 'function')); // Attributes to be displayed for a list
  1373. // Search criteria
  1374. MetaModel::Init_SetZListItems('standard_search', array('name', 'device_id','version','function')); // Criteria of the std search form
  1375. MetaModel::Init_SetZListItems('advanced_search', array('name', 'device_id','version','function')); // Criteria of the advanced search form
  1376. }
  1377. public static function GetRelationQueries($sRelCode)
  1378. {
  1379. switch ($sRelCode)
  1380. {
  1381. case "impacts":
  1382. $aRels = array(
  1383. "client app" => array("sQuery"=>"bizApplication: PKEY IS client_id IN (lnkClientServer: server_id = \$[this.pkey::])", "bPropagate"=>true, "iDistance"=>3),
  1384. );
  1385. return array_merge($aRels, parent::GetRelationQueries($sRelCode));
  1386. }
  1387. }
  1388. function DisplayDetails(WebPage $oPage)
  1389. {
  1390. parent::DisplayDetails($oPage);
  1391. /*
  1392. $oSearchFilter = new CMDBSearchFilter('lnkClientServer');
  1393. $oSearchFilter->AddCondition('server_id', $this->GetKey(), '=');
  1394. $oSet = new CMDBObjectSet($oSearchFilter);
  1395. $count = $oSet->Count();
  1396. if ($count > 0)
  1397. {
  1398. $oPage->SetCurrentTab("Connected clients");
  1399. $oPage->p("Client applications impacted when down:");
  1400. $this->DisplaySet($oPage, $oSet);
  1401. }
  1402. */
  1403. }
  1404. }
  1405. ////////////////////////////////////////////////////////////////////////////////////
  1406. /**
  1407. * n-n link between any Infra and a Group
  1408. */
  1409. ////////////////////////////////////////////////////////////////////////////////////
  1410. class lnkInfraGrouping extends cmdbAbstractObject
  1411. {
  1412. public static function Init()
  1413. {
  1414. $aParams = array
  1415. (
  1416. "category" => "bizmodel,searchable",
  1417. "name" => "Infra Grouping",
  1418. "description" => "Infra part of an Infra Group",
  1419. "key_type" => "autoincrement",
  1420. "key_label" => "link_id",
  1421. "name_attcode" => "impact",
  1422. "state_attcode" => "",
  1423. "reconc_keys" => array(""),
  1424. "db_table" => "infra_grouping",
  1425. "db_key_field" => "link_id",
  1426. "db_finalclass_field" => "",
  1427. "display_template" => "../business/templates/default.html",
  1428. );
  1429. MetaModel::Init_Params($aParams);
  1430. MetaModel::Init_AddAttribute(new AttributeExternalKey("infra_id", array("targetclass"=>"logInfra", "jointype"=> '', "label"=>"Infrastructure", "description"=>"Infrastructure part of the group", "allowed_values"=>null, "sql"=>"infra_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1431. MetaModel::Init_AddAttribute(new AttributeExternalField("infra_name", array("label"=>"Infrastructure Name", "description"=>"Name of the impacted infrastructure", "allowed_values"=>null, "extkey_attcode"=> 'infra_id', "target_attcode"=>"name")));
  1432. MetaModel::Init_AddAttribute(new AttributeExternalField("infra_status", array("label"=>"Status", "description"=>"Status of the impacted infrastructure", "allowed_values"=>null, "extkey_attcode"=> 'infra_id', "target_attcode"=>"status")));
  1433. MetaModel::Init_AddAttribute(new AttributeExternalKey("infra_group_id", array("targetclass"=>"bizInfraGroup", "jointype"=> '', "label"=>"Group", "description"=>"Name of the group", "allowed_values"=>null, "sql"=>"infra_group_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1434. MetaModel::Init_AddAttribute(new AttributeExternalField("group_name", array("label"=>"Group Name", "description"=>"Name of the group containing infrastructure", "allowed_values"=>null, "extkey_attcode"=> 'infra_group_id', "target_attcode"=>"name")));
  1435. MetaModel::Init_AddAttribute(new AttributeString("impact", array("label"=>"Relation", "description"=>"Relation between this group and infra", "allowed_values"=>null, "sql"=>"impact", "default_value"=>"none", "is_null_allowed"=>true, "depends_on"=>array())));
  1436. // impact should modelized: enum (eg: if the group si dead when infra is dead)
  1437. MetaModel::Init_AddFilterFromAttribute("infra_id");
  1438. MetaModel::Init_AddFilterFromAttribute("infra_group_id");
  1439. MetaModel::Init_AddFilterFromAttribute("impact");
  1440. // Display lists
  1441. MetaModel::Init_SetZListItems('details', array('infra_id','infra_status', 'impact', 'infra_group_id')); // Attributes to be displayed for a list
  1442. MetaModel::Init_SetZListItems('list', array('infra_id','infra_status', 'impact', 'infra_group_id')); // Attributes to be displayed for a list
  1443. // Search criteria
  1444. MetaModel::Init_SetZListItems('standard_search', array('infra_id', 'infra_group_id', 'impact')); // Criteria of the std search form
  1445. MetaModel::Init_SetZListItems('advanced_search', array('infra_id', 'infra_group_id', 'impact')); // Criteria of the advanced search form
  1446. }
  1447. public function Generate(cmdbDataGenerator $oGenerator)
  1448. {
  1449. $this->Set('infra_id', $oGenerator->GenerateKey("logInfra", array('org_id' =>$oGenerator->GetOrganizationId() )));
  1450. $this->Set('infra_group_id', $oGenerator->GenerateKey("bizInfraGroup", array('org_id' =>$oGenerator->GetOrganizationId() )));
  1451. $this->Set('impact', $oGenerator->GenerateString("enum(none,mandatory,partial)"));
  1452. }
  1453. }
  1454. ////////////////////////////////////////////////////////////////////////////////////
  1455. /**
  1456. * n-n link between two applications, one is the server side and the scond one the client*/
  1457. ////////////////////////////////////////////////////////////////////////////////////
  1458. class lnkClientServer extends logRealObject
  1459. {
  1460. public static function Init()
  1461. {
  1462. $aParams = array
  1463. (
  1464. "category" => "bizmodel,searchable",
  1465. "name" => "ClientServerLinks",
  1466. "description" => "Link between client server application",
  1467. "key_type" => "autoincrement",
  1468. "key_label" => "link_id",
  1469. "name_attcode" => "relation", // ????
  1470. "state_attcode" => "",
  1471. "reconc_keys" => array("relation"), // ????
  1472. "db_table" => "clientserver_links",
  1473. "db_key_field" => "link_id",
  1474. "db_finalclass_field" => "",
  1475. "display_template" => "../business/templates/default.html",
  1476. );
  1477. MetaModel::Init_Params($aParams);
  1478. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('production,implementation,obsolete'), "sql"=>"status", "default_value"=>"production", "is_null_allowed"=>false, "depends_on"=>array())));
  1479. MetaModel::Init_AddAttribute(new AttributeExternalKey("client_id", array("targetclass"=>"bizApplication", "jointype"=> '', "label"=>"Client", "description"=>"The client part of the link", "allowed_values"=>null, "sql"=>"client_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1480. MetaModel::Init_AddAttribute(new AttributeExternalField("client_name", array("label"=>"Client", "description"=>"Name of the client", "allowed_values"=>null, "extkey_attcode"=> 'client_id', "target_attcode"=>"name")));
  1481. MetaModel::Init_AddAttribute(new AttributeExternalKey("server_id", array("targetclass"=>"bizApplication", "jointype"=> '', "label"=>"Server", "description"=>"the server part of the link", "allowed_values"=>null, "sql"=>"server_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  1482. MetaModel::Init_AddAttribute(new AttributeExternalField("server_name", array("label"=>"Server", "description"=>"Name of the server", "allowed_values"=>null, "extkey_attcode"=> 'server_id', "target_attcode"=>"name")));
  1483. MetaModel::Init_AddAttribute(new AttributeString("relation", array("label"=>"Relation", "description"=>"Type of relation between both application", "allowed_values"=>null, "sql"=>"relation", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1484. MetaModel::Init_AddFilterFromAttribute("client_id");
  1485. MetaModel::Init_AddFilterFromAttribute("server_id");
  1486. // Display lists
  1487. MetaModel::Init_SetZListItems('details', array('client_id', 'server_id', 'relation')); // Attributes to be displayed for a list
  1488. MetaModel::Init_SetZListItems('list', array('client_id', 'server_id', 'relation')); // Attributes to be displayed for a list
  1489. // Search criteria
  1490. MetaModel::Init_SetZListItems('standard_search', array('client_id', 'server_id')); // Criteria of the std search form
  1491. MetaModel::Init_SetZListItems('advanced_search', array('client_id', 'server_id')); // Criteria of the advanced search form
  1492. }
  1493. }
  1494. ////////////////////////////////////////////////////////////////////////////////////
  1495. //**
  1496. //* A patch is an application or OS fixe for an infrastructure
  1497. //*
  1498. ////////////////////////////////////////////////////////////////////////////////////
  1499. class bizPatch extends logRealObject
  1500. {
  1501. public static function Init()
  1502. {
  1503. $aParams = array
  1504. (
  1505. "category" => "bizmodel,searchable",
  1506. "name" => "Patch",
  1507. "description" => "Patch installed on infrastucture",
  1508. "key_type" => "",
  1509. "key_label" => "id",
  1510. "name_attcode" => "name",
  1511. "state_attcode" => "",
  1512. "reconc_keys" => array("device_id", "name"), // inherited attributes
  1513. "db_table" => "patches",
  1514. "db_key_field" => "id",
  1515. "db_finalclass_field" => "",
  1516. "display_template" => "../business/templates/default.html",
  1517. );
  1518. MetaModel::Init_Params($aParams);
  1519. MetaModel::Init_InheritAttributes();
  1520. MetaModel::Init_AddAttribute(new AttributeEnum("status", array("label"=>"Status", "description"=>"Lifecycle status", "allowed_values"=>new ValueSetEnum('production,obsolete'), "sql"=>"status", "default_value"=>"production", "is_null_allowed"=>false, "depends_on"=>array())));
  1521. MetaModel::Init_AddAttribute(new AttributeExternalKey("device_id", array("targetclass"=>"bizDevice", "jointype"=> '', "label"=>"Device", "description"=>"The Device where patch is installed", "allowed_values"=>new ValueSetObjects('SELECT bizDevice AS p WHERE p.org_id = :this->org_id'), "sql"=>"device_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array("org_id"))));
  1522. MetaModel::Init_AddAttribute(new AttributeExternalField("device_name", array("label"=>"Device Name", "description"=>"Name of the impacted device", "allowed_values"=>null, "extkey_attcode"=> 'device_id', "target_attcode"=>"name")));
  1523. MetaModel::Init_AddAttribute(new AttributeDate("install_date", array("label"=>"Installation Date", "description"=>"Date when application was installed", "allowed_values"=>null, "sql"=>"install_date", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  1524. MetaModel::Init_AddAttribute(new AttributeText("description", array("label"=>"Description", "description"=>"description du patch", "allowed_values"=>null, "sql"=>"description", "default_value"=>"", "is_null_allowed"=>true, "depends_on"=>array())));
  1525. MetaModel::Init_AddAttribute(new AttributeString("patch_type", array("label"=>"Type", "description"=>"type de patch", "allowed_values"=>new ValueSetEnum("OS,Application"), "sql"=>"patch_type", "default_value"=>"OS", "is_null_allowed"=>false, "depends_on"=>array())));
  1526. MetaModel::Init_InheritFilters();
  1527. MetaModel::Init_AddFilterFromAttribute("patch_type");
  1528. MetaModel::Init_AddFilterFromAttribute("device_id");
  1529. // Display lists
  1530. MetaModel::Init_SetZListItems('details', array('name','device_id', 'install_date', 'patch_type','description')); // Attributes to be displayed for the complete details
  1531. MetaModel::Init_SetZListItems('list', array('name','device_id', 'patch_type','install_date')); // Attributes to be displayed for a list
  1532. // Search criteria
  1533. MetaModel::Init_SetZListItems('standard_search', array('name', 'device_id','patch_type')); // Criteria of the std search form
  1534. MetaModel::Init_SetZListItems('advanced_search', array('name', 'device_id','patch_type')); // Criteria of the advanced search form
  1535. }
  1536. }
  1537. /*** Insert here all modules requires for ITOP application ***/
  1538. require_once('incidentMgmt.business.php');
  1539. require_once('ServiceMgmt.business.php');
  1540. require_once('ChangeMgmt.business.php');
  1541. require_once('KEDB.business.php');
  1542. require_once('ServiceDesk.business.php');
  1543. ?>