userrightsprofile.class.inc.php 37 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001
  1. <?php
  2. // Copyright (C) 2010 Combodo SARL
  3. //
  4. // This program is free software; you can redistribute it and/or modify
  5. // it under the terms of the GNU General Public License as published by
  6. // the Free Software Foundation; version 3 of the License.
  7. //
  8. // This program is distributed in the hope that it will be useful,
  9. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  10. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  11. // GNU General Public License for more details.
  12. //
  13. // You should have received a copy of the GNU General Public License
  14. // along with this program; if not, write to the Free Software
  15. // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  16. /**
  17. * UserRightsProfile
  18. * User management Module, basing the right on profiles and a matrix (similar to UserRightsMatrix, but profiles and other decorations have been added)
  19. *
  20. * @author Erwan Taloc <erwan.taloc@combodo.com>
  21. * @author Romain Quetiez <romain.quetiez@combodo.com>
  22. * @author Denis Flaven <denis.flaven@combodo.com>
  23. * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL
  24. */
  25. define('ADMIN_PROFILE_NAME', 'Administrator');
  26. define('PORTAL_PROFILE_NAME', 'Portal user');
  27. class UserRightsBaseClassGUI extends cmdbAbstractObject
  28. {
  29. // Whenever something changes, reload the privileges
  30. protected function AfterInsert()
  31. {
  32. UserRights::FlushPrivileges();
  33. }
  34. protected function AfterUpdate()
  35. {
  36. UserRights::FlushPrivileges();
  37. }
  38. protected function AfterDelete()
  39. {
  40. UserRights::FlushPrivileges();
  41. }
  42. }
  43. class UserRightsBaseClass extends DBObject
  44. {
  45. // Whenever something changes, reload the privileges
  46. protected function AfterInsert()
  47. {
  48. UserRights::FlushPrivileges();
  49. }
  50. protected function AfterUpdate()
  51. {
  52. UserRights::FlushPrivileges();
  53. }
  54. protected function AfterDelete()
  55. {
  56. UserRights::FlushPrivileges();
  57. }
  58. }
  59. class URP_Profiles extends UserRightsBaseClassGUI
  60. {
  61. public static function Init()
  62. {
  63. $aParams = array
  64. (
  65. "category" => "addon/userrights",
  66. "key_type" => "autoincrement",
  67. "name_attcode" => "name",
  68. "state_attcode" => "",
  69. "reconc_keys" => array(),
  70. "db_table" => "priv_urp_profiles",
  71. "db_key_field" => "id",
  72. "db_finalclass_field" => "",
  73. "display_template" => "",
  74. );
  75. MetaModel::Init_Params($aParams);
  76. //MetaModel::Init_InheritAttributes();
  77. MetaModel::Init_AddAttribute(new AttributeString("name", array("allowed_values"=>null, "sql"=>"name", "default_value"=>null, "is_null_allowed"=>false, "depends_on"=>array())));
  78. MetaModel::Init_AddAttribute(new AttributeString("description", array("allowed_values"=>null, "sql"=>"description", "default_value"=>null, "is_null_allowed"=>false, "depends_on"=>array())));
  79. MetaModel::Init_AddAttribute(new AttributeLinkedSetIndirect("user_list", array("linked_class"=>"URP_UserProfile", "ext_key_to_me"=>"profileid", "ext_key_to_remote"=>"userid", "allowed_values"=>null, "count_min"=>1, "count_max"=>0, "depends_on"=>array())));
  80. // Display lists
  81. MetaModel::Init_SetZListItems('details', array('name', 'description', 'user_list')); // Attributes to be displayed for the complete details
  82. MetaModel::Init_SetZListItems('list', array('description')); // Attributes to be displayed for a list
  83. // Search criteria
  84. MetaModel::Init_SetZListItems('standard_search', array('name')); // Criteria of the std search form
  85. MetaModel::Init_SetZListItems('advanced_search', array('name')); // Criteria of the advanced search form
  86. }
  87. protected $m_bCheckReservedNames = true;
  88. protected function DisableCheckOnReservedNames()
  89. {
  90. $this->m_bCheckReservedNames = false;
  91. }
  92. protected static $m_aActions = array(
  93. UR_ACTION_READ => 'Read',
  94. UR_ACTION_MODIFY => 'Modify',
  95. UR_ACTION_DELETE => 'Delete',
  96. UR_ACTION_BULK_READ => 'Bulk Read',
  97. UR_ACTION_BULK_MODIFY => 'Bulk Modify',
  98. UR_ACTION_BULK_DELETE => 'Bulk Delete',
  99. );
  100. protected static $m_aCacheActionGrants = null;
  101. protected static $m_aCacheStimulusGrants = null;
  102. protected static $m_aCacheProfiles = null;
  103. public static function DoCreateProfile($sName, $sDescription, $bReservedName = false)
  104. {
  105. if (is_null(self::$m_aCacheProfiles))
  106. {
  107. self::$m_aCacheProfiles = array();
  108. $oFilterAll = new DBObjectSearch('URP_Profiles');
  109. $oSet = new DBObjectSet($oFilterAll);
  110. while ($oProfile = $oSet->Fetch())
  111. {
  112. self::$m_aCacheProfiles[$oProfile->Get('name')] = $oProfile->GetKey();
  113. }
  114. }
  115. $sCacheKey = $sName;
  116. if (isset(self::$m_aCacheProfiles[$sCacheKey]))
  117. {
  118. return self::$m_aCacheProfiles[$sCacheKey];
  119. }
  120. $oNewObj = MetaModel::NewObject("URP_Profiles");
  121. $oNewObj->Set('name', $sName);
  122. $oNewObj->Set('description', $sDescription);
  123. if ($bReservedName)
  124. {
  125. $oNewObj->DisableCheckOnReservedNames();
  126. }
  127. $iId = $oNewObj->DBInsertNoReload();
  128. self::$m_aCacheProfiles[$sCacheKey] = $iId;
  129. return $iId;
  130. }
  131. public static function DoCreateActionGrant($iProfile, $iAction, $sClass, $bPermission = true)
  132. {
  133. $sAction = self::$m_aActions[$iAction];
  134. if (is_null(self::$m_aCacheActionGrants))
  135. {
  136. self::$m_aCacheActionGrants = array();
  137. $oFilterAll = new DBObjectSearch('URP_ActionGrant');
  138. $oSet = new DBObjectSet($oFilterAll);
  139. while ($oGrant = $oSet->Fetch())
  140. {
  141. self::$m_aCacheActionGrants[$oGrant->Get('profileid').'-'.$oGrant->Get('action').'-'.$oGrant->Get('class')] = $oGrant->GetKey();
  142. }
  143. }
  144. $sCacheKey = "$iProfile-$sAction-$sClass";
  145. if (isset(self::$m_aCacheActionGrants[$sCacheKey]))
  146. {
  147. return self::$m_aCacheActionGrants[$sCacheKey];
  148. }
  149. $oNewObj = MetaModel::NewObject("URP_ActionGrant");
  150. $oNewObj->Set('profileid', $iProfile);
  151. $oNewObj->Set('permission', $bPermission ? 'yes' : 'no');
  152. $oNewObj->Set('class', $sClass);
  153. $oNewObj->Set('action', $sAction);
  154. $iId = $oNewObj->DBInsertNoReload();
  155. self::$m_aCacheActionGrants[$sCacheKey] = $iId;
  156. return $iId;
  157. }
  158. public static function DoCreateStimulusGrant($iProfile, $sStimulusCode, $sClass)
  159. {
  160. if (is_null(self::$m_aCacheStimulusGrants))
  161. {
  162. self::$m_aCacheStimulusGrants = array();
  163. $oFilterAll = new DBObjectSearch('URP_StimulusGrant');
  164. $oSet = new DBObjectSet($oFilterAll);
  165. while ($oGrant = $oSet->Fetch())
  166. {
  167. self::$m_aCacheStimulusGrants[$oGrant->Get('profileid').'-'.$oGrant->Get('stimulus').'-'.$oGrant->Get('class')] = $oGrant->GetKey();
  168. }
  169. }
  170. $sCacheKey = "$iProfile-$sStimulusCode-$sClass";
  171. if (isset(self::$m_aCacheStimulusGrants[$sCacheKey]))
  172. {
  173. return self::$m_aCacheStimulusGrants[$sCacheKey];
  174. }
  175. $oNewObj = MetaModel::NewObject("URP_StimulusGrant");
  176. $oNewObj->Set('profileid', $iProfile);
  177. $oNewObj->Set('permission', 'yes');
  178. $oNewObj->Set('class', $sClass);
  179. $oNewObj->Set('stimulus', $sStimulusCode);
  180. $iId = $oNewObj->DBInsertNoReload();
  181. self::$m_aCacheStimulusGrants[$sCacheKey] = $iId;
  182. return $iId;
  183. }
  184. /*
  185. * Create the built-in Administrator profile with its reserved name
  186. */
  187. public static function DoCreateAdminProfile()
  188. {
  189. self::DoCreateProfile(ADMIN_PROFILE_NAME, 'Has the rights on everything (bypassing any control)', true /* reserved name */);
  190. }
  191. /*
  192. * Overload the standard behavior to preserve reserved names
  193. */
  194. public function DoCheckToWrite()
  195. {
  196. parent::DoCheckToWrite();
  197. if ($this->m_bCheckReservedNames)
  198. {
  199. $aChanges = $this->ListChanges();
  200. if (array_key_exists('name', $aChanges))
  201. {
  202. if ($this->GetOriginal('name') == ADMIN_PROFILE_NAME)
  203. {
  204. $this->m_aCheckIssues[] = "The name of the Administrator profile must not be changed";
  205. }
  206. elseif ($this->Get('name') == ADMIN_PROFILE_NAME)
  207. {
  208. $this->m_aCheckIssues[] = ADMIN_PROFILE_NAME." is a reserved to the built-in Administrator profile";
  209. }
  210. elseif ($this->GetOriginal('name') == PORTAL_PROFILE_NAME)
  211. {
  212. $this->m_aCheckIssues[] = "The name of the User Portal profile must not be changed";
  213. }
  214. elseif ($this->Get('name') == PORTAL_PROFILE_NAME)
  215. {
  216. $this->m_aCheckIssues[] = PORTAL_PROFILE_NAME." is a reserved to the built-in User Portal profile";
  217. }
  218. }
  219. }
  220. }
  221. function GetGrantAsHtml($oUserRights, $sClass, $sAction)
  222. {
  223. $iGrant = $oUserRights->GetProfileActionGrant($this->GetKey(), $sClass, $sAction);
  224. if (!is_null($iGrant))
  225. {
  226. return '<span style="background-color: #ddffdd;">'.Dict::S('UI:UserManagement:ActionAllowed:Yes').'</span>';
  227. }
  228. else
  229. {
  230. return '<span style="background-color: #ffdddd;">'.Dict::S('UI:UserManagement:ActionAllowed:No').'</span>';
  231. }
  232. }
  233. function DoShowGrantSumary($oPage)
  234. {
  235. if ($this->GetRawName() == "Administrator")
  236. {
  237. // Looks dirty, but ok that's THE ONE
  238. $oPage->p(Dict::S('UI:UserManagement:AdminProfile+'));
  239. return;
  240. }
  241. // Note: for sure, we assume that the instance is derived from UserRightsProfile
  242. $oUserRights = UserRights::GetModuleInstance();
  243. $aDisplayData = array();
  244. foreach (MetaModel::GetClasses('bizmodel') as $sClass)
  245. {
  246. // Skip non instantiable classes
  247. if (MetaModel::IsAbstract($sClass)) continue;
  248. $aStimuli = array();
  249. foreach (MetaModel::EnumStimuli($sClass) as $sStimulusCode => $oStimulus)
  250. {
  251. $oGrant = $oUserRights->GetClassStimulusGrant($this->GetKey(), $sClass, $sStimulusCode);
  252. if (is_object($oGrant) && ($oGrant->Get('permission') == 'yes'))
  253. {
  254. $aStimuli[] = '<span title="'.$sStimulusCode.': '.htmlentities($oStimulus->GetDescription(), ENT_QUOTES, 'UTF-8').'">'.htmlentities($oStimulus->GetLabel(), ENT_QUOTES, 'UTF-8').'</span>';
  255. }
  256. }
  257. $sStimuli = implode(', ', $aStimuli);
  258. $aDisplayData[] = array(
  259. 'class' => MetaModel::GetName($sClass),
  260. 'read' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Read'),
  261. 'bulkread' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Bulk Read'),
  262. 'write' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Modify'),
  263. 'bulkwrite' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Bulk Modify'),
  264. 'delete' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Delete'),
  265. 'bulkdelete' => $this->GetGrantAsHtml($oUserRights, $sClass, 'Bulk Delete'),
  266. 'stimuli' => $sStimuli,
  267. );
  268. }
  269. $aDisplayConfig = array();
  270. $aDisplayConfig['class'] = array('label' => Dict::S('UI:UserManagement:Class'), 'description' => Dict::S('UI:UserManagement:Class+'));
  271. $aDisplayConfig['read'] = array('label' => Dict::S('UI:UserManagement:Action:Read'), 'description' => Dict::S('UI:UserManagement:Action:Read+'));
  272. $aDisplayConfig['bulkread'] = array('label' => Dict::S('UI:UserManagement:Action:BulkRead'), 'description' => Dict::S('UI:UserManagement:Action:BulkRead+'));
  273. $aDisplayConfig['write'] = array('label' => Dict::S('UI:UserManagement:Action:Modify'), 'description' => Dict::S('UI:UserManagement:Action:Modify+'));
  274. $aDisplayConfig['bulkwrite'] = array('label' => Dict::S('UI:UserManagement:Action:BulkModify'), 'description' => Dict::S('UI:UserManagement:Action:BulkModify+'));
  275. $aDisplayConfig['delete'] = array('label' => Dict::S('UI:UserManagement:Action:Delete'), 'description' => Dict::S('UI:UserManagement:Action:Delete+'));
  276. $aDisplayConfig['bulkdelete'] = array('label' => Dict::S('UI:UserManagement:Action:BulkDelete'), 'description' => Dict::S('UI:UserManagement:Action:BulkDelete+'));
  277. $aDisplayConfig['stimuli'] = array('label' => Dict::S('UI:UserManagement:Action:Stimuli'), 'description' => Dict::S('UI:UserManagement:Action:Stimuli+'));
  278. $oPage->table($aDisplayConfig, $aDisplayData);
  279. }
  280. function DisplayBareRelations(WebPage $oPage, $bEditMode = false)
  281. {
  282. parent::DisplayBareRelations($oPage, $bEditMode);
  283. if (!$bEditMode)
  284. {
  285. $oPage->SetCurrentTab(Dict::S('UI:UserManagement:GrantMatrix'));
  286. $this->DoShowGrantSumary($oPage);
  287. }
  288. }
  289. }
  290. class URP_UserProfile extends UserRightsBaseClassGUI
  291. {
  292. public static function Init()
  293. {
  294. $aParams = array
  295. (
  296. "category" => "addon/userrights",
  297. "key_type" => "autoincrement",
  298. "name_attcode" => "userid",
  299. "state_attcode" => "",
  300. "reconc_keys" => array(),
  301. "db_table" => "priv_urp_userprofile",
  302. "db_key_field" => "id",
  303. "db_finalclass_field" => "",
  304. "display_template" => "",
  305. );
  306. MetaModel::Init_Params($aParams);
  307. //MetaModel::Init_InheritAttributes();
  308. MetaModel::Init_AddAttribute(new AttributeExternalKey("userid", array("targetclass"=>"User", "jointype"=> "", "allowed_values"=>null, "sql"=>"userid", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  309. MetaModel::Init_AddAttribute(new AttributeExternalField("userlogin", array("allowed_values"=>null, "extkey_attcode"=> 'userid', "target_attcode"=>"login")));
  310. MetaModel::Init_AddAttribute(new AttributeExternalKey("profileid", array("targetclass"=>"URP_Profiles", "jointype"=> "", "allowed_values"=>null, "sql"=>"profileid", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  311. MetaModel::Init_AddAttribute(new AttributeExternalField("profile", array("allowed_values"=>null, "extkey_attcode"=> 'profileid', "target_attcode"=>"name")));
  312. MetaModel::Init_AddAttribute(new AttributeString("reason", array("allowed_values"=>null, "sql"=>"description", "default_value"=>null, "is_null_allowed"=>true, "depends_on"=>array())));
  313. // Display lists
  314. MetaModel::Init_SetZListItems('details', array('userid', 'profileid', 'reason')); // Attributes to be displayed for the complete details
  315. MetaModel::Init_SetZListItems('list', array('userid', 'profileid', 'reason')); // Attributes to be displayed for a list
  316. // Search criteria
  317. MetaModel::Init_SetZListItems('standard_search', array('userid', 'profileid')); // Criteria of the std search form
  318. MetaModel::Init_SetZListItems('advanced_search', array('userid', 'profileid')); // Criteria of the advanced search form
  319. }
  320. public function GetName()
  321. {
  322. return Dict::Format('UI:UserManagement:LinkBetween_User_And_Profile', $this->Get('userlogin'), $this->Get('profile'));
  323. }
  324. }
  325. class URP_UserOrg extends UserRightsBaseClassGUI
  326. {
  327. public static function Init()
  328. {
  329. $aParams = array
  330. (
  331. "category" => "addon/userrights",
  332. "key_type" => "autoincrement",
  333. "name_attcode" => "userid",
  334. "state_attcode" => "",
  335. "reconc_keys" => array(),
  336. "db_table" => "priv_urp_userorg",
  337. "db_key_field" => "id",
  338. "db_finalclass_field" => "",
  339. "display_template" => "",
  340. );
  341. MetaModel::Init_Params($aParams);
  342. //MetaModel::Init_InheritAttributes();
  343. MetaModel::Init_AddAttribute(new AttributeExternalKey("userid", array("targetclass"=>"User", "jointype"=> "", "allowed_values"=>null, "sql"=>"userid", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  344. MetaModel::Init_AddAttribute(new AttributeExternalField("userlogin", array("allowed_values"=>null, "extkey_attcode"=> 'userid', "target_attcode"=>"login")));
  345. MetaModel::Init_AddAttribute(new AttributeExternalKey("allowed_org_id", array("targetclass"=>"Organization", "jointype"=> "", "allowed_values"=>null, "sql"=>"allowed_org_id", "is_null_allowed"=>false, "on_target_delete"=>DEL_AUTO, "depends_on"=>array())));
  346. MetaModel::Init_AddAttribute(new AttributeExternalField("allowed_org_name", array("allowed_values"=>null, "extkey_attcode"=> 'allowed_org_id', "target_attcode"=>"name")));
  347. MetaModel::Init_AddAttribute(new AttributeString("reason", array("allowed_values"=>null, "sql"=>"reason", "default_value"=>null, "is_null_allowed"=>true, "depends_on"=>array())));
  348. // Display lists
  349. MetaModel::Init_SetZListItems('details', array('userid', 'allowed_org_id', 'reason')); // Attributes to be displayed for the complete details
  350. MetaModel::Init_SetZListItems('list', array('allowed_org_id', 'reason')); // Attributes to be displayed for a list
  351. // Search criteria
  352. MetaModel::Init_SetZListItems('standard_search', array('userid', 'allowed_org_id')); // Criteria of the std search form
  353. MetaModel::Init_SetZListItems('advanced_search', array('userid', 'allowed_org_id')); // Criteria of the advanced search form
  354. }
  355. public function GetName()
  356. {
  357. return Dict::Format('UI:UserManagement:LinkBetween_User_And_Org', $this->Get('userlogin'), $this->Get('allowed_org_name'));
  358. }
  359. }
  360. class URP_ActionGrant extends UserRightsBaseClass
  361. {
  362. public static function Init()
  363. {
  364. $aParams = array
  365. (
  366. "category" => "addon/userrights",
  367. "key_type" => "autoincrement",
  368. "name_attcode" => "profileid",
  369. "state_attcode" => "",
  370. "reconc_keys" => array(),
  371. "db_table" => "priv_urp_grant_actions",
  372. "db_key_field" => "id",
  373. "db_finalclass_field" => "",
  374. "display_template" => "",
  375. );
  376. MetaModel::Init_Params($aParams);
  377. //MetaModel::Init_InheritAttributes();
  378. // Common to all grant classes (could be factorized by class inheritence, but this has to be benchmarked)
  379. MetaModel::Init_AddAttribute(new AttributeExternalKey("profileid", array("targetclass"=>"URP_Profiles", "jointype"=> "", "allowed_values"=>null, "sql"=>"profileid", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  380. MetaModel::Init_AddAttribute(new AttributeExternalField("profile", array("allowed_values"=>null, "extkey_attcode"=> 'profileid', "target_attcode"=>"name")));
  381. MetaModel::Init_AddAttribute(new AttributeClass("class", array("class_category"=>"", "more_values"=>"", "sql"=>"class", "default_value"=>null, "is_null_allowed"=>false, "depends_on"=>array())));
  382. MetaModel::Init_AddAttribute(new AttributeEnum("permission", array("allowed_values"=>new ValueSetEnum('yes,no'), "sql"=>"permission", "default_value"=>"yes", "is_null_allowed"=>false, "depends_on"=>array())));
  383. MetaModel::Init_AddAttribute(new AttributeString("action", array("allowed_values"=>null, "sql"=>"action", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  384. // Display lists
  385. MetaModel::Init_SetZListItems('details', array('profileid', 'class', 'permission', 'action')); // Attributes to be displayed for the complete details
  386. MetaModel::Init_SetZListItems('list', array('class', 'permission', 'action')); // Attributes to be displayed for a list
  387. // Search criteria
  388. MetaModel::Init_SetZListItems('standard_search', array('profileid', 'class', 'permission', 'action')); // Criteria of the std search form
  389. MetaModel::Init_SetZListItems('advanced_search', array('profileid', 'class', 'permission', 'action')); // Criteria of the advanced search form
  390. }
  391. }
  392. class URP_StimulusGrant extends UserRightsBaseClass
  393. {
  394. public static function Init()
  395. {
  396. $aParams = array
  397. (
  398. "category" => "addon/userrights",
  399. "key_type" => "autoincrement",
  400. "name_attcode" => "profileid",
  401. "state_attcode" => "",
  402. "reconc_keys" => array(),
  403. "db_table" => "priv_urp_grant_stimulus",
  404. "db_key_field" => "id",
  405. "db_finalclass_field" => "",
  406. "display_template" => "",
  407. );
  408. MetaModel::Init_Params($aParams);
  409. //MetaModel::Init_InheritAttributes();
  410. // Common to all grant classes (could be factorized by class inheritence, but this has to be benchmarked)
  411. MetaModel::Init_AddAttribute(new AttributeExternalKey("profileid", array("targetclass"=>"URP_Profiles", "jointype"=> "", "allowed_values"=>null, "sql"=>"profileid", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  412. MetaModel::Init_AddAttribute(new AttributeExternalField("profile", array("allowed_values"=>null, "extkey_attcode"=> 'profileid', "target_attcode"=>"name")));
  413. MetaModel::Init_AddAttribute(new AttributeClass("class", array("class_category"=>"", "more_values"=>"", "sql"=>"class", "default_value"=>null, "is_null_allowed"=>false, "depends_on"=>array())));
  414. MetaModel::Init_AddAttribute(new AttributeEnum("permission", array("allowed_values"=>new ValueSetEnum('yes,no'), "sql"=>"permission", "default_value"=>"yes", "is_null_allowed"=>false, "depends_on"=>array())));
  415. MetaModel::Init_AddAttribute(new AttributeString("stimulus", array("allowed_values"=>null, "sql"=>"action", "default_value"=>"", "is_null_allowed"=>false, "depends_on"=>array())));
  416. // Display lists
  417. MetaModel::Init_SetZListItems('details', array('profileid', 'class', 'permission', 'stimulus')); // Attributes to be displayed for the complete details
  418. MetaModel::Init_SetZListItems('list', array('class', 'permission', 'stimulus')); // Attributes to be displayed for a list
  419. // Search criteria
  420. MetaModel::Init_SetZListItems('standard_search', array('profileid', 'class', 'permission', 'stimulus')); // Criteria of the std search form
  421. MetaModel::Init_SetZListItems('advanced_search', array('profileid', 'class', 'permission', 'stimulus')); // Criteria of the advanced search form
  422. }
  423. }
  424. class URP_AttributeGrant extends UserRightsBaseClass
  425. {
  426. public static function Init()
  427. {
  428. $aParams = array
  429. (
  430. "category" => "addon/userrights",
  431. "key_type" => "autoincrement",
  432. "name_attcode" => "actiongrantid",
  433. "state_attcode" => "",
  434. "reconc_keys" => array(),
  435. "db_table" => "priv_urp_grant_attributes",
  436. "db_key_field" => "id",
  437. "db_finalclass_field" => "",
  438. "display_template" => "",
  439. );
  440. MetaModel::Init_Params($aParams);
  441. //MetaModel::Init_InheritAttributes();
  442. MetaModel::Init_AddAttribute(new AttributeExternalKey("actiongrantid", array("targetclass"=>"URP_ActionGrant", "jointype"=> "", "allowed_values"=>null, "sql"=>"actiongrantid", "is_null_allowed"=>false, "on_target_delete"=>DEL_MANUAL, "depends_on"=>array())));
  443. MetaModel::Init_AddAttribute(new AttributeString("attcode", array("allowed_values"=>null, "sql"=>"attcode", "default_value"=>null, "is_null_allowed"=>false, "depends_on"=>array())));
  444. // Display lists
  445. MetaModel::Init_SetZListItems('details', array('actiongrantid', 'attcode')); // Attributes to be displayed for the complete details
  446. MetaModel::Init_SetZListItems('list', array('attcode')); // Attributes to be displayed for a list
  447. // Search criteria
  448. MetaModel::Init_SetZListItems('standard_search', array('actiongrantid', 'attcode')); // Criteria of the std search form
  449. MetaModel::Init_SetZListItems('advanced_search', array('actiongrantid', 'attcode')); // Criteria of the advanced search form
  450. }
  451. }
  452. class UserRightsProfile extends UserRightsAddOnAPI
  453. {
  454. static public $m_aActionCodes = array(
  455. UR_ACTION_READ => 'read',
  456. UR_ACTION_MODIFY => 'modify',
  457. UR_ACTION_DELETE => 'delete',
  458. UR_ACTION_BULK_READ => 'bulk read',
  459. UR_ACTION_BULK_MODIFY => 'bulk modify',
  460. UR_ACTION_BULK_DELETE => 'bulk delete',
  461. );
  462. // Installation: create the very first user
  463. public function CreateAdministrator($sAdminUser, $sAdminPwd, $sLanguage = 'EN US')
  464. {
  465. // Create a change to record the history of the User object
  466. $oChange = MetaModel::NewObject("CMDBChange");
  467. $oChange->Set("date", time());
  468. $oChange->Set("userinfo", "Initialization");
  469. $iChangeId = $oChange->DBInsert();
  470. $iContactId = 0;
  471. // Support drastic data model changes: no organization class (or not writable)!
  472. if (MetaModel::IsValidClass('Organization') && !MetaModel::IsAbstract('Organization'))
  473. {
  474. $oOrg = new Organization();
  475. $oOrg->Set('name', 'My Company/Department');
  476. $oOrg->Set('code', 'SOMECODE');
  477. $iOrgId = $oOrg->DBInsertTrackedNoReload($oChange, true /* skip security */);
  478. // Support drastic data model changes: no Person class (or not writable)!
  479. if (MetaModel::IsValidClass('Person') && !MetaModel::IsAbstract('Person'))
  480. {
  481. $oContact = new Person();
  482. $oContact->Set('name', 'My last name');
  483. $oContact->Set('first_name', 'My first name');
  484. if (MetaModel::IsValidAttCode('Person', 'org_id'))
  485. {
  486. $oContact->Set('org_id', $iOrgId);
  487. }
  488. if (MetaModel::IsValidAttCode('Person', 'phone'))
  489. {
  490. $oContact->Set('phone', '+00 000 000 000');
  491. }
  492. $oContact->Set('email', 'my.email@foo.org');
  493. $iContactId = $oContact->DBInsertTrackedNoReload($oChange, true /* skip security */);
  494. }
  495. }
  496. $oUser = new UserLocal();
  497. $oUser->Set('login', $sAdminUser);
  498. $oUser->Set('password', $sAdminPwd);
  499. if (MetaModel::IsValidAttCode('UserLocal', 'contactid') && ($iContactId != 0))
  500. {
  501. $oUser->Set('contactid', $iContactId);
  502. }
  503. $oUser->Set('language', $sLanguage); // Language was chosen during the installation
  504. // Add this user to the very specific 'admin' profile
  505. $oAdminProfile = MetaModel::GetObjectFromOQL("SELECT URP_Profiles WHERE name = :name", array('name' => ADMIN_PROFILE_NAME), true /*all data*/);
  506. if (is_object($oAdminProfile))
  507. {
  508. $oUserProfile = new URP_UserProfile();
  509. //$oUserProfile->Set('userid', $iUserId);
  510. $oUserProfile->Set('profileid', $oAdminProfile->GetKey());
  511. $oUserProfile->Set('reason', 'By definition, the administrator must have the administrator profile');
  512. //$oUserProfile->DBInsertTrackedNoReload($oChange, true /* skip security */);
  513. $oSet = DBObjectSet::FromObject($oUserProfile);
  514. $oUser->Set('profile_list', $oSet);
  515. }
  516. $iUserId = $oUser->DBInsertTrackedNoReload($oChange, true /* skip security */);
  517. return true;
  518. }
  519. public function Init()
  520. {
  521. }
  522. protected $m_aAdmins; // id of users being linked to the well-known admin profile
  523. protected $m_aPortalUsers; // id of users being linked to the well-known admin profile
  524. protected $m_aProfiles; // id -> object
  525. protected $m_aUserProfiles; // userid,profileid -> object
  526. protected $m_aUserOrgs; // userid -> orgid
  527. // Those arrays could be completed on demand (inheriting parent permissions)
  528. protected $m_aClassActionGrants = null; // profile, class, action -> actiongrantid (or false if NO, or null/missing if undefined)
  529. protected $m_aClassStimulusGrants = array(); // profile, class, stimulus -> permission
  530. // Built on demand, could be optimized if necessary (doing a query for each attribute that needs to be read)
  531. protected $m_aObjectActionGrants = array();
  532. protected function GetUserOrgs($oUser, $sClass)
  533. {
  534. return @$this->m_aUserOrgs[$oUser->GetKey()];
  535. }
  536. public function ResetCache()
  537. {
  538. // Loaded by Load cache
  539. $this->m_aProfiles = null;
  540. $this->m_aUserProfiles = null;
  541. $this->m_aUserOrgs = null;
  542. $this->m_aAdmins = null;
  543. $this->m_aPortalUsers = null;
  544. // Loaded on demand (time consuming as compared to the others)
  545. $this->m_aClassActionGrants = null;
  546. $this->m_aClassStimulusGrants = null;
  547. $this->m_aObjectActionGrants = array();
  548. }
  549. // Separate load: this cache is much more time consuming while loading
  550. // Thus it is loaded iif required
  551. // Could be improved by specifying the profile id
  552. public function LoadActionGrantCache()
  553. {
  554. if (!is_null($this->m_aClassActionGrants)) return;
  555. $oKPI = new ExecutionKPI();
  556. $oFilter = DBObjectSearch::FromOQL_AllData("SELECT URP_ActionGrant AS p WHERE p.permission = 'yes'");
  557. $aGrants = $oFilter->ToDataArray();
  558. foreach($aGrants as $aGrant)
  559. {
  560. $this->m_aClassActionGrants[$aGrant['profileid']][$aGrant['class']][strtolower($aGrant['action'])] = $aGrant['id'];
  561. }
  562. $oKPI->ComputeAndReport('Load of action grants');
  563. }
  564. public function LoadCache()
  565. {
  566. if (!is_null($this->m_aProfiles)) return;
  567. // Could be loaded in a shared memory (?)
  568. $oKPI = new ExecutionKPI();
  569. $oProfileSet = new DBObjectSet(DBObjectSearch::FromOQL_AllData("SELECT URP_Profiles"));
  570. $this->m_aProfiles = array();
  571. while ($oProfile = $oProfileSet->Fetch())
  572. {
  573. $this->m_aProfiles[$oProfile->GetKey()] = $oProfile;
  574. }
  575. $oUserProfileSet = new DBObjectSet(DBObjectSearch::FromOQL_AllData("SELECT URP_UserProfile"));
  576. $this->m_aUserProfiles = array();
  577. $this->m_aAdmins = array();
  578. $this->m_aPortalUsers = array();
  579. while ($oUserProfile = $oUserProfileSet->Fetch())
  580. {
  581. $this->m_aUserProfiles[$oUserProfile->Get('userid')][$oUserProfile->Get('profileid')] = $oUserProfile;
  582. if ($oUserProfile->Get('profile') == ADMIN_PROFILE_NAME)
  583. {
  584. $this->m_aAdmins[] = $oUserProfile->Get('userid');
  585. }
  586. elseif ($oUserProfile->Get('profile') == PORTAL_PROFILE_NAME)
  587. {
  588. $this->m_aPortalUsers[] = $oUserProfile->Get('userid');
  589. }
  590. }
  591. $oUserOrgSet = new DBObjectSet(DBObjectSearch::FromOQL_AllData("SELECT URP_UserOrg"));
  592. $this->m_aUserOrgs = array();
  593. while ($oUserOrg = $oUserOrgSet->Fetch())
  594. {
  595. $this->m_aUserOrgs[$oUserOrg->Get('userid')][] = $oUserOrg->Get('allowed_org_id');
  596. }
  597. $this->m_aClassStimulusGrants = array();
  598. $oStimGrantSet = new DBObjectSet(DBObjectSearch::FromOQL_AllData("SELECT URP_StimulusGrant"));
  599. $this->m_aStimGrants = array();
  600. while ($oStimGrant = $oStimGrantSet->Fetch())
  601. {
  602. $this->m_aClassStimulusGrants[$oStimGrant->Get('profileid')][$oStimGrant->Get('class')][$oStimGrant->Get('stimulus')] = $oStimGrant;
  603. }
  604. $oKPI->ComputeAndReport('Load of user management cache (excepted Action Grants)');
  605. /*
  606. echo "<pre>\n";
  607. print_r($this->m_aProfiles);
  608. print_r($this->m_aUserProfiles);
  609. print_r($this->m_aUserOrgs);
  610. print_r($this->m_aClassActionGrants);
  611. print_r($this->m_aClassStimulusGrants);
  612. echo "</pre>\n";
  613. exit;
  614. */
  615. return true;
  616. }
  617. public function IsAdministrator($oUser)
  618. {
  619. $this->LoadCache();
  620. if (in_array($oUser->GetKey(), $this->m_aAdmins))
  621. {
  622. return true;
  623. }
  624. else
  625. {
  626. return false;
  627. }
  628. }
  629. public function IsPortalUser($oUser)
  630. {
  631. $this->LoadCache();
  632. if (in_array($oUser->GetKey(), $this->m_aPortalUsers))
  633. {
  634. return true;
  635. }
  636. else
  637. {
  638. return false;
  639. }
  640. }
  641. public function GetSelectFilter($oUser, $sClass)
  642. {
  643. $this->LoadCache();
  644. $aObjectPermissions = $this->GetUserActionGrant($oUser, $sClass, UR_ACTION_READ);
  645. if ($aObjectPermissions['permission'] == UR_ALLOWED_NO)
  646. {
  647. return false;
  648. }
  649. // Determine how to position the objects of this class
  650. //
  651. $aCallSpec = array($sClass, 'MapContextParam');
  652. if (($sClass == 'Organization') || is_subclass_of($sClass, 'Organization'))
  653. {
  654. $sAttCode = 'id';
  655. }
  656. elseif (is_callable($aCallSpec))
  657. {
  658. $sAttCode = call_user_func($aCallSpec, 'org_id'); // Returns null when there is no mapping for this parameter
  659. if ($sAttCode == null)
  660. {
  661. return true;
  662. }
  663. if (!MetaModel::IsValidAttCode($sClass, $sAttCode))
  664. {
  665. // Skip silently. The data model checker will tell you something about this...
  666. return true;
  667. }
  668. }
  669. elseif(MetaModel::IsValidAttCode($sClass, 'org_id'))
  670. {
  671. $sAttCode = 'org_id';
  672. }
  673. else
  674. {
  675. // The objects of this class are not positioned in this dimension
  676. // All of them are visible
  677. return true;
  678. }
  679. // Position the user
  680. //
  681. $aUserOrgs = $this->GetUserOrgs($oUser, $sClass);
  682. if (is_null($aUserOrgs) || count($aUserOrgs) == 0)
  683. {
  684. // No position means 'Everywhere'
  685. return true;
  686. }
  687. $oExpression = new FieldExpression($sAttCode, $sClass);
  688. $oFilter = new DBObjectSearch($sClass);
  689. $oListExpr = ListExpression::FromScalars($aUserOrgs);
  690. // Check if the condition points to a hierarchical key
  691. $bConditionAdded = false;
  692. if ($sAttCode == 'id')
  693. {
  694. // Filtering on the objects themselves
  695. $sHierarchicalKeyCode = MetaModel::IsHierarchicalClass($sClass);
  696. if ($sHierarchicalKeyCode !== false)
  697. {
  698. $oRootFilter = new DBObjectSearch($sClass);
  699. $oCondition = new BinaryExpression($oExpression, 'IN', $oListExpr);
  700. $oRootFilter->AddConditionExpression($oCondition);
  701. $oFilter->AddCondition_PointingTo($oRootFilter, $sHierarchicalKeyCode, TREE_OPERATOR_BELOW); // Use the 'below' operator by default
  702. $bConditionAdded = true;
  703. }
  704. }
  705. else
  706. {
  707. $oAttDef = MetaModel::GetAttributeDef($sClass, $sAttCode);
  708. if ($oAttDef->IsExternalKey())
  709. {
  710. $sHierarchicalKeyCode = MetaModel::IsHierarchicalClass($oAttDef->GetTargetClass());
  711. if ($sHierarchicalKeyCode !== false)
  712. {
  713. $oRootFilter = new DBObjectSearch($oAttDef->GetTargetClass());
  714. $oExpression = new FieldExpression('id', $oAttDef->GetTargetClass());
  715. $oCondition = new BinaryExpression($oExpression, 'IN', $oListExpr);
  716. $oRootFilter->AddConditionExpression($oCondition);
  717. $oHKFilter = new DBObjectSearch($oAttDef->GetTargetClass());
  718. $oHKFilter->AddCondition_PointingTo($oRootFilter, $sHierarchicalKeyCode, TREE_OPERATOR_BELOW); // Use the 'below' operator by default
  719. $oFilter->AddCondition_PointingTo($oHKFilter, $sAttCode);
  720. $bConditionAdded = true;
  721. }
  722. }
  723. }
  724. if (!$bConditionAdded)
  725. {
  726. $oCondition = new BinaryExpression($oExpression, 'IN', $oListExpr);
  727. $oFilter->AddConditionExpression($oCondition);
  728. }
  729. return $oFilter;
  730. }
  731. // This verb has been made public to allow the development of an accurate feedback for the current configuration
  732. public function GetProfileActionGrant($iProfile, $sClass, $sAction)
  733. {
  734. $this->LoadActionGrantCache();
  735. // Note: action is forced lowercase to be more flexible (historical bug)
  736. $sAction = strtolower($sAction);
  737. if (isset($this->m_aClassActionGrants[$iProfile][$sClass][$sAction]))
  738. {
  739. return $this->m_aClassActionGrants[$iProfile][$sClass][$sAction];
  740. }
  741. // Recursively look for the grant record in the class hierarchy
  742. $sParentClass = MetaModel::GetParentPersistentClass($sClass);
  743. if (empty($sParentClass))
  744. {
  745. $iGrant = null;
  746. }
  747. else
  748. {
  749. // Recursively look for the grant record in the class hierarchy
  750. $iGrant = $this->GetProfileActionGrant($iProfile, $sParentClass, $sAction);
  751. }
  752. $this->m_aClassActionGrants[$iProfile][$sClass][$sAction] = $iGrant;
  753. return $iGrant;
  754. }
  755. protected function GetUserActionGrant($oUser, $sClass, $iActionCode)
  756. {
  757. $this->LoadCache();
  758. // load and cache permissions for the current user on the given class
  759. //
  760. $iUser = $oUser->GetKey();
  761. $aTest = @$this->m_aObjectActionGrants[$iUser][$sClass][$iActionCode];
  762. if (is_array($aTest)) return $aTest;
  763. $sAction = self::$m_aActionCodes[$iActionCode];
  764. $iPermission = UR_ALLOWED_NO;
  765. $aAttributes = array();
  766. if (isset($this->m_aUserProfiles[$iUser]))
  767. {
  768. foreach($this->m_aUserProfiles[$iUser] as $iProfile => $oProfile)
  769. {
  770. $iGrant = $this->GetProfileActionGrant($iProfile, $sClass, $sAction);
  771. if (is_null($iGrant) || !$iGrant)
  772. {
  773. continue; // loop to the next profile
  774. }
  775. else
  776. {
  777. $iPermission = UR_ALLOWED_YES;
  778. // update the list of attributes with those allowed for this profile
  779. //
  780. $oSearch = DBObjectSearch::FromOQL_AllData("SELECT URP_AttributeGrant WHERE actiongrantid = :actiongrantid");
  781. $oSet = new DBObjectSet($oSearch, array(), array('actiongrantid' => $iGrant));
  782. $aProfileAttributes = $oSet->GetColumnAsArray('attcode', false);
  783. if (count($aProfileAttributes) == 0)
  784. {
  785. $aAllAttributes = array_keys(MetaModel::ListAttributeDefs($sClass));
  786. $aAttributes = array_merge($aAttributes, $aAllAttributes);
  787. }
  788. else
  789. {
  790. $aAttributes = array_merge($aAttributes, $aProfileAttributes);
  791. }
  792. }
  793. }
  794. }
  795. $aRes = array(
  796. 'permission' => $iPermission,
  797. 'attributes' => $aAttributes,
  798. );
  799. $this->m_aObjectActionGrants[$iUser][$sClass][$iActionCode] = $aRes;
  800. return $aRes;
  801. }
  802. public function IsActionAllowed($oUser, $sClass, $iActionCode, $oInstanceSet = null)
  803. {
  804. $this->LoadCache();
  805. // Note: The object set is ignored because it was interesting to optimize for huge data sets
  806. // and acceptable to consider only the root class of the object set
  807. $aObjectPermissions = $this->GetUserActionGrant($oUser, $sClass, $iActionCode);
  808. return $aObjectPermissions['permission'];
  809. }
  810. public function IsActionAllowedOnAttribute($oUser, $sClass, $sAttCode, $iActionCode, $oInstanceSet = null)
  811. {
  812. $this->LoadCache();
  813. // Note: The object set is ignored because it was interesting to optimize for huge data sets
  814. // and acceptable to consider only the root class of the object set
  815. $aObjectPermissions = $this->GetUserActionGrant($oUser, $sClass, $iActionCode);
  816. $aAttributes = $aObjectPermissions['attributes'];
  817. if (in_array($sAttCode, $aAttributes))
  818. {
  819. return $aObjectPermissions['permission'];
  820. }
  821. else
  822. {
  823. return UR_ALLOWED_NO;
  824. }
  825. }
  826. // This verb has been made public to allow the development of an accurate feedback for the current configuration
  827. public function GetClassStimulusGrant($iProfile, $sClass, $sStimulusCode)
  828. {
  829. $this->LoadCache();
  830. if (isset($this->m_aClassStimulusGrants[$iProfile][$sClass][$sStimulusCode]))
  831. {
  832. return $this->m_aClassStimulusGrants[$iProfile][$sClass][$sStimulusCode];
  833. }
  834. else
  835. {
  836. return null;
  837. }
  838. }
  839. public function IsStimulusAllowed($oUser, $sClass, $sStimulusCode, $oInstanceSet = null)
  840. {
  841. $this->LoadCache();
  842. // Note: this code is VERY close to the code of IsActionAllowed()
  843. $iUser = $oUser->GetKey();
  844. // Note: The object set is ignored because it was interesting to optimize for huge data sets
  845. // and acceptable to consider only the root class of the object set
  846. $iPermission = UR_ALLOWED_NO;
  847. if (isset($this->m_aUserProfiles[$iUser]))
  848. {
  849. foreach($this->m_aUserProfiles[$iUser] as $iProfile => $oProfile)
  850. {
  851. $oGrantRecord = $this->GetClassStimulusGrant($iProfile, $sClass, $sStimulusCode);
  852. if (!is_null($oGrantRecord))
  853. {
  854. // no need to fetch the record, we've requested the records having permission = 'yes'
  855. $iPermission = UR_ALLOWED_YES;
  856. }
  857. }
  858. }
  859. return $iPermission;
  860. }
  861. public function FlushPrivileges()
  862. {
  863. $this->ResetCache();
  864. }
  865. }
  866. UserRights::SelectModule('UserRightsProfile');
  867. ?>