Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-sr-x
Dispatch_ans_script_setup.php	5.95 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.3 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.28 KB	-rwxr-xr-x
ECHblk.php	11.31 KB	-rwxr-xr-x
FormulaEvaluate.php	14.48 KB	-rwxr-xr-x
MarkEntry-Setup.php	26.9 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	27.69 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.87 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.82 KB	-rwxr-xr-x
UpdateCollDet.php	1.71 KB	-rwxr-xr-x
XLSXReader.php	9.62 KB	-rwxr-xr-x
absent_entry_setup.php	8.33 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.46 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.22 KB	-rwxr-xr-x
ack_adm_application.php	56.32 KB	-rwxr-xr-x
ack_admentry_application.php	49.35 KB	-rwxr-xr-x
ack_application.php	7.85 KB	-rwxr-xr-x
ack_exam_app_form.php	16.96 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.87 KB	-rwxr-xr-x
ack_registration.php	7.95 KB	-rwxr-xr-x
ack_report.php	2.34 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.7 KB	-rwxr-xr-x
actClass.php	6.38 KB	-rwxr-xr-x
adm_challan_entries.php	14.13 KB	-rwxr-xr-x
adm_delete_data.php	5.71 KB	-rwxr-xr-x
admapprove.php	9.55 KB	-rwxr-xr-x
admchallanpreparation.php	9.01 KB	-rwxr-xr-x
admission_entry_reg.php	40.87 KB	-rwxr-xr-x
admission_entry_status.php	2.79 KB	-rwxr-xr-x
admission_sms_push.php	2.33 KB	-rwxr-xr-x
admissionapplist.php	9.15 KB	-rwxr-xr-x
admregisterlist.php	14.82 KB	-rwxr-xr-x
admstuddate.php	6.27 KB	-rwxr-xr-x
admsumsendsms.php	6.28 KB	-rwxr-xr-x
admuploadexsheet.php	12.57 KB	-rwxr-xr-x
ansbookcancel.php	9.7 KB	-rwxr-xr-x
answer_book_issued.php	10.56 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	26.67 KB	-rwxr-xr-x
apprCandidReport.php	7.14 KB	-rwxr-xr-x
approve.php	38.33 KB	-rwxr-xr-x
attendance.php	10.44 KB	-rwxr-xr-x
attendance_freez.php	8.65 KB	-rwxr-xr-x
attendance_freez_mth.php	8.42 KB	-rwxr-xr-x
attshort.php	6.45 KB	-rwxr-xr-x
auto-complete.php	5.04 KB	-rwxr-xr-x
backup.php	2.95 KB	-rwxr-xr-x
backup_restore.php	8.36 KB	-rwxr-xr-x
backupandrestore.php	10.43 KB	-rwxr-xr-x
batch_close.php	4.43 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.69 KB	-rwxr-xr-x
bundle_dispatch.php	3.21 KB	-rwxr-xr-x
bundle_rec_ack.php	4.13 KB	-rwxr-xr-x
bundledispatchdatewise.php	12.74 KB	-rwxr-xr-x
bundlereceive.php	1.12 KB	-rwxr-xr-x
bundlestatus.php	5.38 KB	-rwxr-xr-x
cManualMailer.php	2.63 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	44.67 KB	-rwxr-xr-x
cappcontext.php	2.7 KB	-rwxr-xr-x
challan_entries.php	15.65 KB	-rwxr-xr-x
challan_preparation.php	11.91 KB	-rwxr-xr-x
changeDegree.php	1.61 KB	-rwxr-xr-x
changeMobile.php	2.51 KB	-rwxr-xr-x
cmailer.php	6.96 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
code39.php	6.54 KB	-rwxr-xr-x
coll_exam_app_form.php	1014 B	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.08 KB	-rwxr-xr-x
college.php	5.15 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.61 KB	-rwxr-xr-x
college_approve.php	5.71 KB	-rwxr-xr-x
college_degree_status.php	5.76 KB	-rwxr-xr-x
collegebank.php	1.89 KB	-rwxr-xr-x
collfundtransfer.php	2.32 KB	-rwxr-xr-x
connect.php	2.31 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	4.06 KB	-rwxr-xr-x
create_all_grid_files.php	8.8 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	10.18 KB	-rwxr-xr-x
create_all_popup_files.php	6.08 KB	-rwxr-xr-x
create_all_schema_files.php	4.42 KB	-rwxr-xr-x
create_all_views.php	16.87 KB	-rwxr-xr-x
create_html_files.php	52.9 KB	-rwxr-xr-x
create_html_files_without_tab....	45.23 KB	-rwxr-xr-x
create_module_meta_columns.php	5.26 KB	-rwxr-xr-x
crequestbroker.php	2.58 KB	-rwxr-xr-x
cronjob_sendsms.php	3.04 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	124 B	-rwxr-xr-x
database.php	474 B	-rwxr-xr-x
datadictionary.php	4.06 KB	-rwxr-xr-x
daterange.php	8.08 KB	-rwxr-xr-x
degree.php	6.66 KB	-rwxr-xr-x
degreeGroup.php	4 B	-rwxr-xr-x
degstudymat.php	6.45 KB	-rwxr-xr-x
degstudymatdet.php	5.16 KB	-rwxr-xr-x
display_details_in_grid.php	109.22 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 KB	-rwxr-xr-x
display_details_in_grid_studta...	99.65 KB	-rwxr-xr-x
display_details_in_grid_withde...	100.58 KB	-rwxr-xr-x
doc_verify.php	7.31 KB	-rwxr-xr-x
downloadFeeStatement.php	5.47 KB	-rwxr-xr-x
download_misc_files.php	4.72 KB	-rwxr-xr-x
download_photo.php	4.17 KB	-rwxr-xr-x
download_upload.php	3.99 KB	-rwxr-xr-x
dynamicmastersdetails.php	120.21 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	122.19 KB	-rwxr-xr-x
entryexitevents.php	3.19 KB	-rwxr-xr-x
examAppChallan.php	7.92 KB	-rwxr-xr-x
execute_query.php	2.57 KB	-rwxr-xr-x
export_import_setup.php	7.8 KB	-rwxr-xr-x
export_import_utility.php	2.75 KB	-rwxr-xr-x
feepaidreports.php	994 B	-rwxr-xr-x
forgotpassword.php	3.22 KB	-rwxr-xr-x
format.php	7.76 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.79 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.3 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.93 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.99 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.61 KB	-rwxr-xr-x
freezeiaprici.php	10.14 KB	-rwxr-xr-x
general_report_format.php	11.33 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	3.05 KB	-rwxr-xr-x
getMessages.php	11.4 KB	-rwxr-xr-x
getdata.php	36.93 KB	-rwxr-xr-x
getfeeinformation.php	7.28 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.74 KB	-rwxr-xr-x
getmoduledetails.php	23.94 KB	-rwxr-xr-x
getnumword.php	7.8 KB	-rwxr-xr-x
getreportdetails.php	3.29 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.43 KB	-rwxr-xr-x
getsearchcondition.php	1.37 KB	-rwxr-xr-x
ggridmodel.php	9.59 KB	-rwxr-xr-x
golden_palm_payslip.php	12.86 KB	-rwxr-xr-x
helptext.php	5.54 KB	-rwxr-xr-x
identify_transactions.php	6.56 KB	-rwxr-xr-x
import_marks.php	4.27 KB	-rwxr-xr-x
index.php	5.17 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
login.php	18.88 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.33 KB	-rwxr-xr-x
login_old.php	3.23 KB	-rwxr-xr-x
login_wait.php	11.78 KB	-rwxr-xr-x
mascomb.php	10.27 KB	-rwxr-xr-x
mcverifydet.php	14.61 KB	-rwxr-xr-x
message_board.php	4.84 KB	-rwxr-xr-x
messagetext.php	1010 B	-rwxr-xr-x
module_setup.php	2.56 KB	-rwxr-xr-x
mregistry.php	92.4 KB	-rwxr-xr-x
mrn_approval.php	9.24 KB	-rwxr-xr-x
nobleRegn.php	4.08 KB	-rwxr-xr-x
payment_gateway.php	8.01 KB	-rwxr-xr-x
photoupload.php	9.52 KB	-rwxr-xr-x
post.php	5.21 KB	-rwxr-xr-x
printexamform.php	11.87 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.86 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.72 KB	-rwxr-xr-x
remove_exam_ack.php	3.63 KB	-rwxr-xr-x
report_admission_ticket.php	48.07 KB	-rwxr-xr-x
report_hall_ticket.php	11.47 KB	-rwxr-xr-x
report_iamarks_pending.php	12.35 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	12.15 KB	-rwxr-xr-x
report_setup.php	25.56 KB	-rwxr-xr-x
report_tool.php	74.93 KB	-rwxr-xr-x
result.php	5.18 KB	-rwxr-xr-x
resultsheet.php	9.15 KB	-rwxr-xr-x
revaluation.php	17.01 KB	-rwxr-xr-x
revaluation_withdegree.php	17.13 KB	-rwxr-xr-x
room_allotment.php	8.13 KB	-rwxr-xr-x
room_allotment_datewise.php	15.75 KB	-rwxr-xr-x
roomdeclaration.php	1.87 KB	-rwxr-xr-x
rotation.php	634 B	-rwxr-xr-x
rvdates.php	6.58 KB	-rwxr-xr-x
sample.php	2.13 KB	-rwxr-xr-x
sectionwisepermission.php	5.66 KB	-rwxr-xr-x
sendGridMail.php	1.25 KB	-rwxr-xr-x
sendLoginPassword.php	3.2 KB	-rwxr-xr-x
sendnotification.php	6.17 KB	-rwxr-xr-x
sendsmsapi.php	788 B	-rwxr-xr-x
sendusrandpws.php	1.01 KB	-rwxr-xr-x
serchbygrid.php	868 B	-rwxr-xr-x
servfeehead.php	3.97 KB	-rwxr-xr-x
services.php	3.58 KB	-rwxr-xr-x
sfeehead.php	5.62 KB	-rwxr-xr-x
stringspliter.php	731 B	-rwxr-xr-x
stuIAMarksPending.php	6.09 KB	-rwxr-xr-x
student.php	57.31 KB	-rwxr-xr-x
student_entry.php	61.92 KB	-rwxr-xr-x
studentportal_remove.php	6.3 KB	-rwxr-xr-x
subjectList_display.php	11.23 KB	-rwxr-xr-x
subject_freshExam.php	28.5 KB	-rwxr-xr-x
subjectfreez.php	13.52 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	10.21 KB	-rwxr-xr-x
subshort.php	5.83 KB	-rwxr-xr-x
system_utility.php	1.89 KB	-rwxr-xr-x
systemsetup.php	81.71 KB	-rwxr-xr-x
teachOficerEntry.php	7.21 KB	-rwxr-xr-x
teachers.php	15.78 KB	-rwxr-xr-x
transaction-series.php	4.99 KB	-rwxr-xr-x
update.php	720 B	-rwxr-xr-x
updateSection.php	4.87 KB	-rwxr-xr-x
update_defined_flag.php	3.5 KB	-rwxr-xr-x
update_query.php	334 B	-rwxr-xr-x
updateexamcnt.php	3.01 KB	-rwxr-xr-x
upload_studentPhoto.php	10.94 KB	-rwxr-xr-x
uploadmoduledetails.php	40.61 KB	-rwxr-xr-x
uploadzip.php	9.42 KB	-rwxr-xr-x
usersetup.php	25.66 KB	-rwxr-xr-x
usersubj_identification.php	5.71 KB	-rwxr-xr-x

Code Editor : getmoduledetails.php

<?php

function getGeneralUserSchemaDetails($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$schema_name = $aobj_context->mobj_data["schema_name"];	 
	$is_multiple = $aobj_context->mobj_data["is_multiple"];	
	$login_cnt = $aobj_context->mobj_data["login_cnt"];	
	$is_module_for_new_or_edit= $aobj_context->mobj_data["is_module_for_new_or_edit"];
	session_start();
	$user_id=$_SESSION['user_id'];
	$user_type=$_SESSION['user_type'];
	$get_file_id="select s.internal_code,t.value as system_menu_name,module_type
	from s_user_schema s inner join s_ref_type t on t.internal_code=s.module_type
	WHERE module_name='{$schema_name}'";
	$lobj_get_file_id = $aobj_context->mobj_db->GetRow($get_file_id);
	$schema_id=$lobj_get_file_id[internal_code];
	$module_type=$lobj_get_file_id[module_type];
	$system_menu_name=$lobj_get_file_id[system_menu_name];
	$_SESSION['g_file_id'] =$lobj_get_file_id[internal_code];
	$add_right=1;
	if(strtolower($user_type)!='admin')
	{
		$add_rights_data="select is_add from user_rights where 
					module_id='{$schema_id}' and module_type='{$module_type}' and ref_s_sysdb_code='{$user_id}'";
		$lobj_add_rights_data = $aobj_context->mobj_db->GetRow($add_rights_data);
		
		$add_right=$lobj_add_rights_data[is_add];
			
	}
	if($is_multiple==0)
	$order_by="order by ifnull(ug.sequence,0),ue.sequence,ue.internal_code";
	else 
		$order_by= "group by group_name";
			//ifnull(is_right_exstis,0) as
	$lstr_qry = "select a.*,ifnull(doc_root,0) as doc_root,ifnull(doc_root_mapped_id,0) as doc_root_mapped_id,
	1 is_right_exstis,1 as is_module_for_new_or_edit from (select 
	ue.internal_code,ifnull(u.grid_type,'Normal') as grid_type ,
	ue.name as element_name,ifnull(s2.value,'none') as module_parent_menu,
	s.value as Type,	ifnull(js_path,'') as js_path,
	ifnull(ug.name,'0None') as group_name,system_name,
	if(ug.internal_code is null,u.internal_code,concat(u.internal_code,'_',ug.internal_code)) as user_right_group,
	description,s1.value as meta_data,decimals,
	if(s1.value='Meta',concat('m_',u.internal_code,'_ele_',ue.internal_code),'') as meta_field,
	default_value,ifnull(ue.is_ref_module_code_lov,0) as is_ref_module_code_lov,
	optional,list_of_values,
	u.internal_code as ref_s_user_schema_code,
	ue.ref_module_code ,is_read_only,
	IFNULL(ug.internal_code,0) as ref_s_user_schema_group_code,ifnull(multiple,0) as multiple,
	concat('user_schema_',u.internal_code ,'_group_',IFNULL(ug.internal_code,0)) as table_id,
	ifnull(suffix,'None') as suffix,width*9 as width,linked_field,source_field,
	Replace(if(on_enter='',0,ifnull(on_enter,0)),' ','~') as on_enter
	,Replace(if(on_exit='',0,ifnull(on_exit,0)),' ','~') as on_exit
	from s_user_schema_elements ue
	inner join s_user_schema u on u.internal_code=ue.ref_s_user_schema_code
	left join s_user_schema_group ug on ug.internal_code=ref_s_user_schema_group_code 
	left join s_ref_type s on s.internal_code=ue.data_type
	left join s_ref_type s1 on s1.internal_code=ue.s_ref_type_meta
	left join s_ref_type s2 on s2.internal_code=u.main_menu
	where u.module_name= '".$schema_name."' and  is_multiple_group={$is_multiple}
	and (ug.parent_group_code is null or  ug.parent_group_code=0)
	and is_visible=1 and ifnull(ue.is_defined,1)=1
	{$order_by} )a
	left join # for Auto Increment Values
	(select internal_code as doc_root,GROUP_CONCAT(ele_id) as doc_root_mapped_id  from (select su.internal_code,su.name as value
	from s_user_schema_elements su 
	inner join s_ref_type st1 on st1.internal_code=data_type
	where su.ref_s_user_schema_code={$schema_id} and st1.value='Date')a
	inner JOIN
	(select su.internal_code as ele_id,su.name,source_field  
	from s_user_schema_elements su 
	inner join s_ref_type st1 on st1.internal_code=data_type
	where su.ref_s_user_schema_code={$schema_id} and st1.value='Auto Increment' and source_field>0)b 
	on a.internal_code=b.source_field
	group by internal_code) c on  c.doc_root=a.internal_code
		";
 				
	$lobj_schema_details = $aobj_context->mobj_db->GetAll($lstr_qry);
  	$grid_type= $lobj_schema_details[0]['grid_type'];
	$get_html_ids="select t.value as data_type,su.internal_code,
				concat('details_',su.internal_code) as id,su.system_name,
					ifnull(su.is_visible,1) as is_visible,su.source_field,
					ifnull(ug.name,'None') as group_name,
					ifnull(su.is_defined,1) as is_defined,ref_module_code,
					su.db_field,
					default_value,
					case when default_value='today'
					then date_format(current_date(),'%d/%m/%Y')
					when default_value='yesterday'
					then date_format(date_add(current_date(),interval -1 day),'%d/%m/%Y')
					when default_value='tomarrow'
					then date_format(date_add(current_date(),interval 1 day),'%d/%m/%Y')
					when default_value='bom'
					then date_format(current_date(),'%01/%m/%Y')
					else '00/00/0000'
					end as dates,
					date_format(current_date(),'%Y') as curr_year,
					date_format(current_date(),'%m') as curr_month,
					ifnull(su.is_ref_module_code_lov,0) as is_ref_module_code_lov
					from s_user_schema_elements  su 
					inner join s_ref_type t on 
					t.internal_code=su.data_type 
						left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code 
					  where 
					su.ref_s_user_schema_code={$schema_id}";
				
	$lobj_get_html_ids = $aobj_context->mobj_db->GetAll($get_html_ids);	
 
	$system_date=date("d/m/Y");
	 
	$html_id_arr=array();	
	$html_id_criteria_arr=array();	
	$html_id_data_type_arr=array();	
	$visible_defined_arr=array();	
	$is_ref_module_code_lov_flag=0;
	$is_update_visible_field=0;
	$is_image_flag=0;
	$employee_list_flag=0;
	$is_date_field_exists=0;
	$is_auto_increment_update_flag=0;
	 $date_fields_date_array=array();
	 $grid_fields_array=array();
	 
	 $d=0;
	 $a=0;
	for($h=0;$h<count($lobj_get_html_ids);$h++)
	{
		 $system_name=$lobj_get_html_ids[$h][system_name];
		 $db_field=$lobj_get_html_ids[$h][db_field];
		 $grid_fields_array[$system_name]=$db_field;
		 $internal_code=$lobj_get_html_ids[$h][internal_code];
		 if(strtolower($lobj_get_html_ids[$h][group_name])!='criteria')
		$html_id_arr[$lobj_get_html_ids[$h][system_name]]=$lobj_get_html_ids[$h][id];
		 else
		$html_id_criteria_arr[$lobj_get_html_ids[$h][system_name]]=$lobj_get_html_ids[$h][id];
		
		$html_id_data_type_arr[$lobj_get_html_ids[$h][system_name]]=$lobj_get_html_ids[$h][data_type];
		if($lobj_get_html_ids[$h][is_ref_module_code_lov]=='1') $is_ref_module_code_lov_flag=1;
		if($lobj_get_html_ids[$h][is_visible]=='0') $is_update_visible_field=1;
		if($lobj_get_html_ids[$h][Type]=='Image') $is_image_flag=1;
		if($lobj_get_html_ids[$h][data_type]=='Date') 
		{
			if(strtolower($lobj_get_html_ids[$h][default_value]!='eom'))
			{
				$date_fields_date_array[$d]['id']=$internal_code;
				$date_fields_date_array[$d]['val']=$lobj_get_html_ids[$h][dates];
			}
			else
			{	
				$curr_month=$lobj_get_html_ids[$h][curr_month];
				$curr_year=$lobj_get_html_ids[$h][curr_year];
				$days_in_a_month=cal_days_in_month(CAL_GREGORIAN, $curr_month, $curr_year);
				$date_val="{$days_in_a_month}/{$curr_month}/{$curr_year}";
				$date_fields_date_array[$d]['id']=$internal_code;
				$date_fields_date_array[$d]['val']=$date_val;
			}			
			$d++;
		}
		else if($lobj_get_html_ids[$h][data_type]=='Reference Data' &&!empty($lobj_get_html_ids[$h][default_value])) 
		{
			$def_val=$lobj_get_html_ids[$h][default_value]; 	
			$ref_module_code=$lobj_get_html_ids[$h][ref_module_code]; 	
			$select_module_ids="select table_name,field_id1,field_id2 from module_meta_columns where module_id={$ref_module_code}"; 
			$lobj_select_module_ids = $aobj_context->mobj_db->GetRow($select_module_ids);	
			$field_id1=$lobj_select_module_ids[field_id1];
			$field_id2=$lobj_select_module_ids[field_id2];
			$field_id2_val=(!empty($field_id2))?"  or {$field_id2}='{$def_val}'  ":"";
			$table_name=$lobj_select_module_ids[table_name];
			$get_ref_data="select internal_code from {$table_name} 
						where {$field_id1}='{$def_val}' {$field_id2_val} limit 1";
					 
			$lobj_get_ref_data = $aobj_context->mobj_db->GetRow($get_ref_data);	
			if(!empty($lobj_get_ref_data))
			{	
				$ref_data_default_val[$internal_code]['default_val']=$def_val;
				$ref_data_default_val[$internal_code]['int_code']=$lobj_get_ref_data[internal_code];
			}
			$d++;
			 
		}
		if($lobj_get_html_ids[$h][source_field]>0) 
		{
			$is_auto_increment_update_flag=1;
		}
		if($lobj_get_html_ids[$h][is_visible]=='1')
		array_push($visible_defined_arr,$lobj_get_html_ids[$h][internal_code]);
		if($lobj_get_html_ids[$h][data_type]=='Employee List') 
		{
		$employee_list_flag=1;
		}
		
	}
	 
	 
	 $select_distinct_group_names="select internal_code,name,ifnull(multiple,0) as multiple,
								concat('user_schema_',ref_s_user_schema_code,'_entry_',internal_code) as 
								table_name,
								ifnull(is_grid_edit,0) as is_grid_edit,
								ifnull(multiple,0) as  multiple,
								ifnull(parent_group_code,0) as parent_group_code 
								from s_user_schema_group 
							where ref_s_user_schema_code={$schema_id}
							 ";
		 $lobj_select_distinct_group_names = $aobj_context->mobj_db->GetAll($select_distinct_group_names);	
		 $g=0;
		 $m=0;
		foreach($lobj_select_distinct_group_names as $gk=>$gv)
		{
			$table_name =$gv["table_name"];	
			$group_name =$gv["name"];
			if($gv[multiple]=='1')
			{
				$is_child_exists=0;
				$is_child_multiple_group=0;
					
				$parent_group =$gv["parent_group_code"];	
				$str_desc = "desc $table_name";
				$obj_desc=$aobj_context->mobj_db->GetAll($str_desc);
				$chek_child_exstis="select * from s_user_schema_group 
									where parent_group_code={$gv[internal_code]}";
				 $lobj_chek_child_exstis = $aobj_context->mobj_db->GetRow($chek_child_exstis);
				 if($lobj_chek_child_exstis[internal_code])
				 $is_child_exists=1;
				 if($lobj_chek_child_exstis[multiple])
				 $is_child_multiple_group=1;
				$ref_s_ref_data_code=0;
				//popudating insert command
				$insert_qry="insert into $table_name(internal_code,login_cnt,group_int_code,ref_s_user_schema_code,ref_s_user_schema_group_code,ref_s_ref_data_code,";
				$id='';
				$i=-5;
				foreach ($obj_desc as $key=>$value)
				{
					if($value['Field']!='internal_code' && $value['Field']!='ref_s_user_schema_code' &&
					$value['Field']!='ref_s_user_schema_group_code' && $value['Field']!='ref_s_ref_data_code' &&
					$value['Field']!='login_cnt' &&
					$value['Field']!='created_by' && $value['Field']!='created_date' &&
					$value['Field']!='modified_by' && $value['Field']!='modified_date')
					{
					$ele_id=explode('ele_',$value['Field']);
					if(!in_array($ele_id[1],$visible_defined_arr)) continue;
					$id.=$ele_id[1].",";
					$insert_qry.=$value['Field'].",";
					}
					$i++;
				}
		
				$insert_qry.="created_by,created_date,modified_by,modified_date) values (";
				
				$schema_code=explode('user_schema_',$table_name);
				$all_code=explode('_entry_',$schema_code[1]);
				$insert_qry.=$all_code[0].",".$all_code[1].",";
				$id= substr($id,0,strlen($id) - 1);
				$get_name="select su.internal_code,name,system_name,
					value as Type,is_visible,ifnull(su.is_defined,1) as is_defined,
					is_read_only,
					case when s.value='Date' and  default_value='today'
					then date_format(current_date(),'%d/%m/%Y')
					when s.value='Date' and  default_value='yesterday'
					then date_format(date_add(current_date(),interval -1 day),'%d/%m/%Y')
					when s.value='Date' and  default_value='tomarrow'
					then date_format(date_add(current_date(),interval 1 day),'%d/%m/%Y')

else  default_value
					end as default_value,ifnull(is_ref_module_code_lov,0) as is_ref_module_code_lov,
					optional,su.ref_module_code,list_of_values,db_field,
					linked_field,source_field,suffix,width*9 as width from 
						s_user_schema_elements su left join  s_ref_type s on s.internal_code=su.data_type
						where su.internal_code in (".$id.")
						and ifnull(is_visible,1)=1  and ifnull(is_defined,1)=1
						order by su.internal_code";
				 
		  		$lobj_get_name =  $aobj_context->mobj_db->GetAll($get_name);
				$all_multi_groups[$g]['group_id']=$gv[internal_code];
				$all_multi_groups[$g]['group_name']=$gv[name];
				$all_multi_groups[$g]['group_table_name']=$table_name;
				 
				$multi_group[$table_name]['table_name'] = $table_name;
				$multi_group[$table_name]['group_name'] = $group_name;
				$multi_group[$table_name]['insert_qry'] = $insert_qry;
				$multi_group[$table_name]['elements'] = $lobj_get_name;
				$multi_group[$table_name]['ref_s_ref_data_code'] = $ref_s_ref_data_code;
				$multi_group[$table_name]['parent_group'] = $parent_group;
				$multi_group[$table_name]['is_child_exists'] =  $is_child_exists;
				$multi_group[$table_name]['group_id'] =  $gv[internal_code];
				$multi_group[$table_name]['is_grid_edit'] =  $gv[is_grid_edit];
				$multi_group[$table_name]['is_child_multiple_group'] =  $is_child_multiple_group;
			 
				if($is_module_for_new_or_edit=='Add')
				{
				$delete_from_group_table="delete from {$table_name} where login_cnt={$login_cnt}";
				 $lobj_delete_from_group_table =  $aobj_context->mobj_db->Execute($delete_from_group_table);
				 }
				$g++;
			}
			else
			{
				 $all_non_multi_groups[$m]['group_id']=$gv[internal_code];
				 $all_non_multi_groups[$m]['group_name']=$gv[name];
				 $m++;
			}
		}
		$get_rights="";
			 $arr[1]=$lobj_schema_details;
			 $arr['multi_group']=$multi_group;
			 $arr['add_right']=$add_right;
			 $arr['schema_name']=$schema_name;
			 $arr['module_id']=$schema_id;
			 $arr['grid_type']=$grid_type;
			 $arr['all_multi_groups']=$all_multi_groups;
			 $arr['all_non_multi_groups']=$all_non_multi_groups;
			 $arr['links_data']= getLinks($aobj_context,$schema_name);
			 $arr['html_id_arr']= $html_id_arr;
			 $arr['html_id_criteria_arr']= $html_id_criteria_arr;
			 $arr['html_id_data_type_arr']= $html_id_data_type_arr;
			 $arr['is_ref_module_code_lov_flag']= $is_ref_module_code_lov_flag;
			 $arr['is_image_flag']= $is_image_flag;
			 $arr['is_update_visible_field']= $is_update_visible_field;
			 $arr['system_date']= $system_date;
			 $arr['date_fields_date_array']= $date_fields_date_array;
			 $arr['system_menu_name']= $system_menu_name;
			 $arr['is_auto_increment_update_flag']= $is_auto_increment_update_flag;
			 $arr['ref_data_default_val']= $ref_data_default_val;
			 $arr['grid_fields_array']= $grid_fields_array;
			 $arr['employee_list_flag']= $employee_list_flag;
			  
			
	    if(!empty($lobj_schema_details))
		{
		
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		
		}
		 else
		{	
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		
		}
}

foreach($link_arr as $ak=>$av)
			{
				$header_link.=$link_details_arr[$ak]['header'];
				$footer_link.=$link_details_arr[$ak]['footer'];
				if($i!=count($link_arr)) 
				{
				$header_link.=" |</a> ";
				$footer_link.=" |</a> ";
				}
				else
				{
				$header_link.=" </a>";
				$footer_link.=" </a>";
				}
				$i++;
			}
			
 		$link_id="";

if(!empty($lobj_get_links_from_module[custom_links]))
			{
				$split_by_pipe=explode("|",$lobj_get_links_from_module[custom_links]);
				//print_r($split_by_pipe);
				//echo count($split_by_pipe);
				for($split=0;$split<count($split_by_pipe);$split++)
				{
					$function_split=explode("~",$split_by_pipe[$split]);
					$name=$function_split[0];	
					$id=getlinkId($name);
					$link_id.=$id.",";
					$fun=$function_split[1];
					
					if($split==count($split_by_pipe)-1)
					$pipe="";
					else
					$pipe=" | ";
				$header_link.=" <a href='#'  class='anchor-header-footer ElementCount' id='header_{$id}' onclick=\"javascript:{$fun};\">{$name}{$pipe}</a>";
				$footer_link.=" <a href='#'  class='anchor-header-footer ElementCount' id='footer_{$id}' onclick= \"javascript:{$fun};\">{$name}{$pipe}</a>";
				}
				 
			}
			 
	 $arr['header_link']=$header_link;		
	 $arr['footer_link']=$footer_link;		
	 $arr['link_data']=$lobj_get_links_from_module;		
	 $arr['link_id']=$link_id;		
	  
	 return $arr;	
}
function getViewLinks($aobj_context,$schema_name)
{
	$get_links_from_module="select 
						0 as include_save,
						ifnull(include_clear,1) as include_clear,
						ifnull(include_download,1) as include_download,
						0 as include_view,
						ifnull(include_generate,0) as include_generate,
						ifnull(custom_links,'') as custom_links
						from s_user_schema where module_name='{$schema_name}'";
			
									
			$lobj_get_links_from_module =  $aobj_context->mobj_db->GetRow($get_links_from_module);
			//print_r($lobj_get_links_from_module);
			 foreach($lobj_get_links_from_module as $k=>$v)
			 {
				if($k!='custom_links')
				{
				if($v=='1')
				 $link_arr[$k]=$v;
				}
			 }
			 if(!empty($lobj_get_links_from_module['custom_links']))
			 $link_arr['custom_links']=$lobj_get_links_from_module['custom_links'];
			// print_r($link_arr);
			$link_details_arr['include_save']['header']="<a href='#' class='anchor-header-footer' id='header_finish_row' onclick='javascript:saveRecords();'>Save";
			$link_details_arr['include_save']['footer']="<a href='#' class='anchor-header-footer' id='footer_finish_row' onclick='javascript:saveRecords();'>Save";
			
			$link_details_arr['include_clear']['header']=" <a href='#' class='anchor-header-footer' id='header_clear_row' onclick='javascript:Clearfields();'>New";
			$link_details_arr['include_clear']['footer']=" <a href='#' class='anchor-header-footer' id='footer_clear_row' onclick='javascript:Clearfields();'>New";
			
			$link_details_arr['include_download']['header']=" <a href='#' class='anchor-header-footer' id='header_upload_row' onclick='javascript:UploadRecords();'>Download";
			$link_details_arr['include_download']['footer']="  <a href='#' class='anchor-header-footer' id='footer_upload_row' onclick='javascript:UploadRecords();'>Download";
			
			$link_details_arr['include_view']['header']=" <a href='#' class='anchor-header-footer' id='header_view_row' onclick='javascript:view_records();'>View";
			$link_details_arr['include_view']['footer']="<a href='#' class='anchor-header-footer' id='footer_view_row' onclick='javascript:view_records();'>View";
			
			$link_details_arr['include_generate']['header']="<a href='#' class='anchor-header-footer' id='header_generate_row' onclick='javascript:GenerateFiles();'>Generate";
			$link_details_arr['include_generate']['footer']="<a href='#' class='anchor-header-footer' id='footer_generate_row' onclick='javascript:GenerateFiles();'>Generate";
			
			$link_details_arr['include_help']['header']="<a href='#' class='anchor-header-footer' id='header_help_row' onclick='javascript:GetModuleHelpText();'>Help";
			$link_details_arr['include_help']['footer']="<a href='#' class='anchor-header-footer' id='footer_help_row' onclick='javascript:GetModuleHelpText();'>Help";
			
			$i=1;

foreach($link_arr as $ak=>$av)
			{
			$header_link.=$link_details_arr[$ak]['header'];
			$footer_link.=$link_details_arr[$ak]['footer'];
				if($i!=count($link_arr)) 
				{
				$header_link.=" |</a> ";
				$footer_link.=" |</a> ";
				}
				else
				{
				$header_link.=" </a>";
				$footer_link.=" </a>";
				}
				$i++;
			}
			
 		$link_id="";

function getlinkId($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",".");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

function getDefaultHeadFooterLinks($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	include_once($aobj_context->main_src."//src/getmoduledetails.php");
	$module_name=$aobj_context->mobj_data["module_name"];
	$arr['links_data']= getLinks($aobj_context,$module_name);
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
}
?>

${this.title}

Code Editor : getmoduledetails.php