Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	11.06 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf	0 B	-rwxr-xr-x
MarkEntry-Setup.php	24.41 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	26.92 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
XLSXReader.php	9.31 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.25 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.34 KB	-rwxr-xr-x
ack_adm_application.js	24.67 KB	-rwxr-xr-x
ack_adm_application.php	49.01 KB	-rwxr-xr-x
ack_admentry_application.php	46.51 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.57 KB	-rwxr-xr-x
ack_exam_app_form_oldformat.ph...	12.53 KB	-rwxr-xr-x
ack_registration.php	7.77 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.52 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm_challan_entries.php	13.83 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	9.04 KB	-rwxr-xr-x
admchallanpreparation.php	8.81 KB	-rwxr-xr-x
admission_entry_reg.php	39.89 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admission_sms_push.php	2.26 KB	-rwxr-xr-x
admissionapplist.php	5.06 KB	-rwxr-xr-x
admsumsendsms.php	6.12 KB	-rwxr-xr-x
admuploadexsheet.php	7.82 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	25.94 KB	-rwxr-xr-x
approve.php	36.81 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_freez.php	8.45 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.js	2.73 KB	-rwxr-xr-x
backup.php	2.74 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
basic_old.css	13.33 KB	-rwxr-xr-x
batch_close.php	4.31 KB	-rwxr-xr-x
boeselection.php	1.64 KB	-rwxr-xr-x
bundle_dispatch.php	2.93 KB	-rwxr-xr-x
bundlereceive.php	1.08 KB	-rwxr-xr-x
bundlestatus.php	5.3 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	45.51 KB	-rwxr-xr-x
candidate-entry_new.php	42.85 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.js	39.62 KB	-rwxr-xr-x
cappcontext.php	2.6 KB	-rwxr-xr-x
cconfig_wait.php	1.12 KB	-rwxr-xr-x
challan_entries.php	15.38 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
changeMobile.php	2.12 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.12 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
colldesp_ack.php	4 KB	-rwxr-xr-x
college.php	4.91 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
connect.php	2.11 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createAdmission.php	3.94 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
cronjob_sendsms.php	2.94 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	7.36 KB	-rwxr-xr-x
degree.php	6.49 KB	-rwxr-xr-x
display_details_in_grid.php	105.34 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.61 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.32 KB	-rwxr-xr-x
download_misc_files.php	4.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	4.45 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	5.07 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	34.52 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.03 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.52 KB	-rwxr-xr-x
getmoduledetails.php	23.59 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
index.php	5.06 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
krvw.html	1.5 KB	-rwxr-xr-x
login.php	10.66 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
mcverifydet.php	14.26 KB	-rwxr-xr-x
message_board.php	4.7 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	92.1 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
payment_gateway.php	7.78 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
photoupload.php	9.28 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_hall_ticket.php	11.18 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	9.39 KB	-rwxr-xr-x
room_allotment_datewise.php	21.67 KB	-rwxr-xr-x
room_allotment_old.php	16.44 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.77 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sample.php	2.04 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	760 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	55.85 KB	-rwxr-xr-x
student_14062018.php	43.9 KB	-rwxr-xr-x
student_entry.php	60.71 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_14062018.php	48.28 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	18.98 KB	-rwxr-xr-x
subjectfreez.php	13.2 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.01 KB	-rwxr-xr-x
teachers.php	16.85 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.83 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	10.12 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	9.18 KB	-rwxr-xr-x
usersetup.php	25.06 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.88 KB	-rwxr-xr-x

Code Editor : create_all_views.php

<?php
 
function CreateView($aobj_context)
{ 
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$schema_id =$aobj_context->mobj_data["schema_id"];
		$schema_cond='';
	 
		if(!($schema_id==0 or $schema_id=='0'))
		{
			$schema_cond=" and s.internal_code={$schema_id} ";
		}	
		if($schema_id==1)
		{
		$schema_cond="";// and s.internal_code=39 
		}		
				$get_schema_id="SELECT s.internal_code,s.module_name 
							from s_user_schema s inner join s_ref_type t
							on t.internal_code=s.module_type
							where is_menu_only=0   and value<>'Reports'
							{$schema_cond}   
							  order by 1
							";
				
				//echo $get_schema_id;
               // die();				
				$lobj_get_schema_id = $aobj_context->mobj_db->GetAll($get_schema_id);
				 
		foreach($lobj_get_schema_id as $key1=>$schema_value)
			{
				$module_id=$schema_value['internal_code'];
				$module_name=$schema_value['module_name'];
				CreateGeneralMasterView($aobj_context,$module_id,$module_name);
				CreateGroupView($aobj_context,$module_id,$module_name);
			}
			 
	if(($schema_id==0 or $schema_id=='0'))
		{
		$data="Views Created Successfully";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 	
		return;	  
		}			
}
function getViewName($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",".");
	$view_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$view_name);
}
function CreateGeneralMasterView($aobj_context,$schema_id,$module_name)
{ 
	 
	$view_name =getViewName($module_name);
  	$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");
	$aobj_context->mobj_db->execute("set @a:=0");
	$table_name="module_{$schema_id}";
		$select_ref_module_code="select 
			GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
			(select   @a:=@a+1,ref_module_code,
			concat(' left join module_',ref_module_code, ' as module_',ref_module_code,'_',internal_code,' on module_',ref_module_code,'_',internal_code,'.internal_code =module_',ref_s_user_schema_code,'.m_',ref_s_user_schema_code, '_ele_',internal_code) as join_table_name
			from s_user_schema_elements
			where ref_s_user_schema_code={$schema_id}
			and is_multiple_group=0 and ref_module_code>0)j";
		$obj_select_ref_module_code =  $aobj_context->mobj_db->GetRow($select_ref_module_code);
				 
		$join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:'';
			
		$get_display_cols="select GROUP_CONCAT(field_name) as field_name  from 
								(select table_name,name,field_name as grid_field_name,
								if(ref_module_code=0,
								concat('module_',internal_code,'.',field_name,' as ', name),
								concat(\"concat(\",f1,f2,\") as \",name,',module_',internal_code,'.',field_name, ' as ref_',name,'_code')) as field_name
								,ref_module_code from 
								(select  s.internal_code, su.internal_code as ele_id,
								ref_module_code,concat('module_',s.internal_code) as table_name ,
								field_id,	
								if(ifnull(field_id1,'')!='',concat('module_',ref_module_code,'_',su.internal_code,'.',field_id1),'') as f1,
								if(ifnull(field_id2,'')!='',concat(',\'-\',module_',ref_module_code,'_',su.internal_code,'.',field_id2),'') as f2,
								LCASE(REPLACE(REPLACE(REPLACE(REPLACE(su.system_name,' ','_'),'.','_'),'&','_'),'/','_')) as name
								,
								ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,
								concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name 
								from s_user_schema s inner join s_user_schema_elements su on 
								su.ref_s_user_schema_code=s.internal_code
								inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
								left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code
								left join module_meta_columns mmc on mmc.module_id=su.ref_module_code
								where s.internal_code={$schema_id} and t.value='Meta'
								 and (ug.parent_group_code is null or ug.parent_group_code=0)
								order by ug.sequence,su.sequence,su.internal_code ) l 
								where   multiple=0 
								) a ";
			 
			 
		$lobj_get_display_cols = $aobj_context->mobj_db->GetRow($get_display_cols);
		$field_name=$lobj_get_display_cols[field_name];

$SQL = " create view  {$view_name} as select {$table_name}.internal_code,{$field_name},
						{$table_name}.created_by,
						{$table_name}.created_date,
						{$table_name}.modified_by,
						{$table_name}.modified_date		
						from  {$table_name}  {$join_qry}";			
		//if($table_name == 'module_30')
			 
		$drop_view="DROP VIEW IF EXISTS {$view_name}";
		
		$lobj_drop_view = $aobj_context->mobj_db->Execute($drop_view);	
					
		$lobj_SQL= $aobj_context->mobj_db->Execute($SQL);	
		
		//echo mysql_error();
}
function CreateGroupView_old($aobj_context,$schema_id,$module_name)
{
	 
	
		$get_groups="select internal_code,name 
						from s_user_schema_group
						where ref_s_user_schema_code={$schema_id}
						and multiple=1";
					 
		$lobj_get_groups = $aobj_context->mobj_db->GetAll($get_groups);
		foreach($lobj_get_groups as $key=>$val)
		{
			 $fields='';
			 $join_qry='';
			$group_id=$val[internal_code];
			$group_name=$val[name];
			$group_view_name=getViewName($module_name."_".$group_name);
			$entry_view_name=getViewName($module_name."_".$group_name."_entry");
			$group_table_name="user_schema_{$schema_id}_group_{$group_id}";
			$entry_table_name="user_schema_{$schema_id}_entry_{$group_id}";
						$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
						$select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
									(select  ref_module_code,
									concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,
									concat(' left join module_',ref_module_code, ' on module_',ref_module_code,'.internal_code =u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as join_table_name
									from s_user_schema_elements
									where ref_s_user_schema_code={$schema_id} 
									and ref_s_user_schema_group_code={$group_id} and ref_module_code>0)j";
							$obj_select_ref_module_code =  $aobj_context->mobj_db->GetRow($select_ref_module_code);
							 $join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:'';
							// to form the fields   dynamically 
							 
							$select_field_ids="select 
									concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,
										LCASE(REPLACE(REPLACE(REPLACE(REPLACE(system_name,' ','_'),'.','_'),'&','_'),'/','_')) as name, 
									ref_module_code from 
									s_user_schema_elements	
									where ref_s_user_schema_code={$schema_id} 
									and ref_s_user_schema_group_code={$group_id} 
									order by internal_code";
							$lobj_select_field_ids =  $aobj_context->mobj_db->GetAll($select_field_ids);
							
							foreach($lobj_select_field_ids as $key =>$value)
							{
								if($value[ref_module_code]=='0')
								{
								$fields.=$value[field_id]." as $value[name],";
								}
								else
								{
								$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
								$qry=" select concat('module_',schema_id) as table_name,GROUP_CONCAT(name SEPARATOR '-ele-') as name,
									GROUP_CONCAT(field_name separator ',\'-\',') as field_name from 
									(select * from 
									(select s.internal_code as schema_id,su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,
									concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name 
									from s_user_schema s inner join s_user_schema_elements su on 
									su.ref_s_user_schema_code=s.internal_code
									inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
									left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code
									where s.internal_code=$value[ref_module_code] and t.value='Meta' 
									order by ug.sequence,su.sequence,su.internal_code ) l where   multiple=0 limit 2) a group by schema_id"; 
															 
									$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
								$fields.="concat(".$lobj_rs[field_name].") as {$value[name]}".", {$value[field_id]} as ref_{$value[name]}_code ,";
								}
							}
						$fields=substr($fields,0,strlen($fields)-1); 
						$create_group_view=" create view  {$group_view_name} as
								select {$group_table_name}.internal_code ,ref_s_ref_data_code,{$fields}
								from 	
								{$group_table_name}
								{$join_qry}";	
						$drop_view="DROP VIEW IF EXISTS {$group_view_name}";
						$lobj_drop_view = $aobj_context->mobj_db->Execute($drop_view);	
						$lobj_SQL= $aobj_context->mobj_db->Execute($create_group_view);
					
						$create_entry_view=" create view  {$entry_view_name} as
								select {$entry_table_name}.internal_code ,login_cnt,group_int_code,
								ref_s_ref_data_code,{$fields}
								from 	
								{$entry_table_name}
								{$join_qry}";	
						 
						$drop_entry_view="DROP VIEW IF EXISTS {$entry_view_name}";
						$lobj_drop_view = $aobj_context->mobj_db->Execute($drop_entry_view);	
						$lobj_SQL= $aobj_context->mobj_db->Execute($create_entry_view);
						 
		}					 
}
function CreateGroupView($aobj_context,$schema_id,$module_name)
{
	 
	
		$get_groups="select internal_code,name 
						from s_user_schema_group
						where ref_s_user_schema_code={$schema_id}
						and multiple=1";
					 
		$lobj_get_groups = $aobj_context->mobj_db->GetAll($get_groups);
		foreach($lobj_get_groups as $key=>$val)
		{
			 $fields='';
			 $join_qry='';
			$group_id=$val[internal_code];
			 
			$group_name=$val[name];
			$group_view_name=getViewName($module_name."_".$group_name);
			$entry_view_name=getViewName($module_name."_".$group_name."_entry");
			$group_table_name="user_schema_{$schema_id}_group_{$group_id}";
			$entry_table_name="user_schema_{$schema_id}_entry_{$group_id}";
						$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
						/* $select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
									(select  ref_module_code,
									concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,
									concat(' left join module_',ref_module_code, ' on module_',ref_module_code,'.internal_code =u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as join_table_name
									from s_user_schema_elements
									where ref_s_user_schema_code={$schema_id} 
									and ref_s_user_schema_group_code={$group_id} and ref_module_code>0)j";
							$obj_select_ref_module_code =  $aobj_context->mobj_db->GetRow($select_ref_module_code);
							 $join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:'';
							// to form the fields   dynamically 
							 
							$select_field_ids="select 
									concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,
										LCASE(REPLACE(REPLACE(REPLACE(REPLACE(system_name,' ','_'),'.','_'),'&','_'),'/','_')) as name, 
									ref_module_code from 
									s_user_schema_elements	
									where ref_s_user_schema_code={$schema_id} 
									and ref_s_user_schema_group_code={$group_id} 
									order by internal_code";
							$lobj_select_field_ids =  $aobj_context->mobj_db->GetAll($select_field_ids);
							
							foreach($lobj_select_field_ids as $key =>$value)
							{
								if($value[ref_module_code]=='0')
								{
								$fields.=$value[field_id]." as $value[name],";
								}
								else
								{
								$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
								$qry=" select concat('module_',schema_id) as table_name,GROUP_CONCAT(name SEPARATOR '-ele-') as name,
									GROUP_CONCAT(field_name separator ',\'-\',') as field_name from 
									(select * from 
									(select s.internal_code as schema_id,su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,
									concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name 
									from s_user_schema s inner join s_user_schema_elements su on 
									su.ref_s_user_schema_code=s.internal_code
									inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
									left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code
									where s.internal_code=$value[ref_module_code] and t.value='Meta' 
									order by ug.sequence,su.sequence,su.internal_code ) l where   multiple=0 limit 2) a group by schema_id"; 
															 
									$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
								$fields.="concat(".$lobj_rs[field_name].") as {$value[name]}".", {$value[field_id]} as ref_{$value[name]}_code ,";
								}
							}
						$fields=substr($fields,0,strlen($fields)-1);  */
						$group_qry=getGroupDetailsViewQry($aobj_context,$schema_id,$group_id,$group_table_name);
						$create_group_view=" create view  {$group_view_name} as
								select {$group_table_name}.internal_code ,ref_s_ref_data_code,{$group_qry}";
 			
						$drop_view="DROP VIEW IF EXISTS {$group_view_name}";
						$lobj_drop_view = $aobj_context->mobj_db->Execute($drop_view);	
						$lobj_SQL= $aobj_context->mobj_db->Execute($create_group_view);
						 
						$entry_group_qry=getGroupDetailsViewQry($aobj_context,$schema_id,$group_id,$entry_table_name);
						
						$create_entry_view=" create view  {$entry_view_name} as
								select {$entry_table_name}.internal_code ,login_cnt,group_int_code,
								ref_s_ref_data_code,{$entry_group_qry}
								";	
						   
						$drop_entry_view="DROP VIEW IF EXISTS {$entry_view_name}";
						$lobj_drop_view = $aobj_context->mobj_db->Execute($drop_entry_view);	
						$lobj_SQL= $aobj_context->mobj_db->Execute($create_entry_view);
						 
		}					 
}

$qry = "{$lobj_get_display_cols[field_name]},
								{$table_name}.created_by,
								{$table_name}.created_date,
								{$table_name}.modified_by,
								{$table_name}.modified_date  from 
				{$table_name}  {$join_qry}";
 
return 	$qry;			
}		   		   
?>

${this.title}

Code Editor : create_all_views.php