Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
TarkaFormatStyles.php	10.35 KB	-rwxr-xr-x
batch_wise_details.php	12.99 KB	-rwxr-xr-x
custom_mregistry.php	3.17 KB	-rwxr-xr-x
dash_board.php	1.38 KB	-rwxr-xr-x
error_message.ini	2.73 KB	-rwxr-xr-x
evaluation.php	15.84 KB	-rwxr-xr-x
execute_query.php	754 B	-rwxr-xr-x
freeze_marks.php	4.7 KB	-rwxr-xr-x
getMapAtEmployeeIdQuery.php	4.24 KB	-rwxr-xr-x
getRightValuesForLoggedinUser....	2.26 KB	-rwxr-xr-x
get_fm_emp_list.php	3.19 KB	-rwxr-xr-x
get_search_conditon.php	2.03 KB	-rwxr-xr-x
ggridGetQuery.php	1.55 KB	-rwxr-xr-x
month_year.php	2.59 KB	-rwxr-xr-x
parseini.php	777 B	-rwxr-xr-x
practical_entry_freezing witho...	9.3 KB	-rwxr-xr-x
practical_entry_freezing.php	11.32 KB	-rwxr-xr-x
practical_entry_freezing_02112...	10.41 KB	-rwxr-xr-x
practical_marks_details.php	11.37 KB	-rwxr-xr-x
practical_marks_details0211201...	12.17 KB	-rwxr-xr-x
practical_marks_details_080520...	10.15 KB	-rwxr-xr-x
practical_marks_details_old.ph...	10.04 KB	-rwxr-xr-x
practical_marks_misc.php	10.02 KB	-rwxr-xr-x
report_practical_misc.php	5.76 KB	-rwxr-xr-x
report_setup.php	86.43 KB	-rwxr-xr-x
transactions.php	50.14 KB	-rwxr-xr-x
user_report.php	6.21 KB	-rwxr-xr-x

Code Editor : getRightValuesForLoggedinUser.php

<?php
  /*
            Author :  Natesha S
	 Date : 2009-10-24
	 Module : Righths Permission

*/  
  
  
  class GetRightValues
	{
	public $aobj_context;
	public $user_id;
	public $schema_id;
	public $table_name;
    
       //Start :  Constructor
	           function __construct($aobj_context)
	              {
		              session_start();
		              $this->aobj_context=$aobj_context;
		              $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
					  $this->user_id = $_SESSION['user_id'];
		              					  
		           }
		//End : Constructor 
		
	  
	function getViewCondition()
		{
			session_start();
			$user_type=$_SESSION['user_type'];
			$user_id=$_SESSION['user_id'];
			$user_dept=$_SESSION['user_dept'];
			
			$get_rights="select  is_view,is_view_group_records,is_view_dep_records,is_view_all_records
			from user_rights where ref_s_sysdb_code={$user_id}
			and module_id={$schema_id}";
			
			$obj_get_rights = $this->aobj_context->mobj_db->GetRow($get_rights);

$own=$obj_get_rights[is_view];
			$group=$obj_get_rights[is_view_group_records];
			$dep=$obj_get_rights[is_view_dep_records];
			$all=$obj_get_rights[is_view_all_records];
			$view_cond="";
			if(strtolower($user_type)=='admin' || $all=='1')
			{
				$view_cond=" where 1=1 ";
			}	 
			else
			{					
				if($own=='0')
				{
					$view_cond=" where {$table_name}.created_by=0 ";
				}
				else if($own=='1' && $dep=='0') //checks for Own Records Only
				{
					$view_cond=" where {$table_name}.created_by={$user_id} ";							 
				}
				else if($dep=='1')//checks for Department Records Only
				{
					$get_users_of_department="select GROUP_CONCAT(ref_user_code) as dep_users
					from dept_user_mapping where ref_dept_code={$user_dept}";
					$obj_u_dep = $this->aobj_context->mobj_db->GetRow($get_users_of_department);	
					$dep_users= $obj_u_dep[dep_users];
					$view_cond=" where {$table_name}.created_by in ({$dep_users}) ";
				}
			}

return $view_cond;			 
	}
}

function getViewCondition($aobj_context,$schema_id,$table_name)
  {
    $class_obj=new GetRightValues($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj->schema_id=$schema_id;	
	$class_obj->table_name=$table_name;	
	return $class_obj->getViewCondition();
	 
  }
 
 
     
?>

${this.title}

Code Editor : getRightValuesForLoggedinUser.php