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
MarkEntry-Setup.php	20.57 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 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
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	6.91 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_exam_app_form.php	12.08 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.04 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
approve.php	19.63 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_31072017.php	6.59 KB	-rwxr-xr-x
attendance_freez.php	8.46 KB	-rwxr-xr-x
attendance_freez03012017.php	8.37 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.21 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.6 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
batch_close.php	4.29 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	44.23 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-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
challan_entries.php	15.31 KB	-rwxr-xr-x
challan_preparation.php	11.58 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 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.1 KB	-rwxr-xr-x
coutput.php	1.75 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
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	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	105.15 KB	-rwxr-xr-x
display_details_in_grid0812201...	102.95 KB	-rwxr-xr-x
display_details_in_grid22.php	104.89 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.59 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	4.71 KB	-rwxr-xr-x
download_misc_files.php	3.65 KB	-rwxr-xr-x
download_photo.php	4.71 KB	-rwxr-xr-x
download_photo01202017.php	3.58 KB	-rwxr-xr-x
download_uploadsikkim.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.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	8.22 KB	-rwxr-xr-x
freeze_module_at_admin_college...	6.92 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	33.4 KB	-rwxr-xr-x
getdata08052017.php	33.04 KB	-rwxr-xr-x
getdata08122016.php	32.65 KB	-rwxr-xr-x
getdata22.php	32.82 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.12 KB	-rwxr-xr-x
getfeeinformation_24112018.php	6.95 KB	-rwxr-xr-x
getmoduledetails.php	24.56 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
json.php	33.22 KB	-rwxr-xr-x
login.php	7.67 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
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	953 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	89.5 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.08 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
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	15.46 KB	-rwxr-xr-x
room_allotment22.php	14.04 KB	-rwxr-xr-x
room_allotment_.php	15.24 KB	-rwxr-xr-x
room_allotment_12092017.php	15.22 KB	-rwxr-xr-x
room_allotment_20112017.php	15.25 KB	-rwxr-xr-x
room_allotment_datewise.php	15.84 KB	-rwxr-xr-x
room_allotment_datewise_150220...	16.87 KB	-rwxr-xr-x
room_allotment_datewise_151129...	18.29 KB	-rwxr-xr-x
room_allotment_datewise_old.ph...	18.29 KB	-rwxr-xr-x
room_allotment_new16012017.php	14.02 KB	-rwxr-xr-x
room_allotment_newformat120920...	15.25 KB	-rwxr-xr-x
room_allotment_oldd.php	9.24 KB	-rwxr-xr-x
room_allotment_qpcodewise.php	9.56 KB	-rwxr-xr-x
roomdeclaration.php	1.81 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-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_entry.php	32.52 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.94 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	76.51 KB	-rwxr-xr-x
teachers.php	14.63 KB	-rwxr-xr-x
teachersOLD.php	10.33 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
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
usersetup.php	24.35 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.77 KB	-rwxr-xr-x

Code Editor : systemsetup.php

<?php
	function getModuleType($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		$sql_query="select internal_code,value as type 
				from s_ref_type where type='module_type' and active=1 order by 2";	
		$lobj_rs = $aobj_context->mobj_db->GetAll($sql_query);   
		
		$arr[0]=$lobj_rs;
		$sql_query_menu="select internal_code,value as type 
			from s_ref_type where type='sub_menu' and active=1  order by 2";	
		$lobj_rs_menu = $aobj_context->mobj_db->GetAll($sql_query_menu);  
		
		$arr[1]=$lobj_rs_menu;
		include_once("getmoduledetails.php");
			$arr['links_data']= getLinks($aobj_context,"General Master Setup");
		if(count($lobj_rs) != 0)
			print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success")); 
		else
			print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"));
		return;
	}
	
	function getAutoIncrementSourceFields($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		$schema_code=$aobj_context->mobj_data["schema_code"];
		
		$sql_query="select su.internal_code,su.name as value
			from s_user_schema_elements su 
			inner join s_ref_type st on st.internal_code=data_type
			inner join s_ref_type st1 on st1.internal_code=data_type
			where su.ref_s_user_schema_code={$schema_code} and st1.value='Date'";

$lobj_rs = $aobj_context->mobj_db->GetAll($sql_query);

if(count($lobj_rs) != 0)
			print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success")); 
		else
			print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"));
		return;
	}

$lstr_qry = "select s.internal_code,ifnull(display_module_name,module_name) as module_name,
				ifnull(display_module_name,module_name)  as  display_module_name,t.value,
				is_menu_only,if(is_menu_only=1,menu_function,'') as menu_function 
				,IFNULL(main_menu,'0') as main_menu_id,
				REPLACE(module_name,' ','~') as r_module_name,
				IFNULL(mm.value,concat('z',display_module_name)) as main_menu_val from s_user_schema s inner join s_ref_type t
				on t.internal_code=module_type
				left join s_ref_type mm on mm.internal_code=main_menu
				where display_module_name is not null and t.value='{$type}'
				and s.active=1  {$markscol}
				group by s.internal_code order by 
				ifnull(s.sequence,0),main_menu_val,ifnull(display_module_name,module_name)";
				
			}
			else if($lobj_get_user_right[value]=='University' && $lobj_get_user_right[user_type]!= 52)
			{
				$sql_query="select internal_code,menu_name,menu_function,id  from system_menu  	
				where active=1  and system_menu='U' order by ifnull(sequence,1),menu_name";		 
				
				$lstr_qry = "select s.internal_code,ifnull(display_module_name,module_name) as module_name,
				ifnull(display_module_name,module_name)  as  display_module_name,t.value,
				is_menu_only,if(is_menu_only=1,menu_function,'') as menu_function 
				,IFNULL(main_menu,'0') as main_menu_id,
				REPLACE(module_name,' ','~') as r_module_name,
				IFNULL(mm.value,concat('z',display_module_name)) as main_menu_val 
				from s_user_schema s inner join s_ref_type t
				on t.internal_code=module_type
				left join s_ref_type mm on mm.internal_code=main_menu
				where display_module_name is not null and t.value='{$type}'
				and s.active=1 {$markscol}
				group by s.internal_code order by 
				ifnull(s.sequence,0),main_menu_val,ifnull(display_module_name,module_name)";
			}
			else if($lobj_get_user_right[user_type]== 17)
			{	
				$sql_query="select s.internal_code,s.menu_name,s.menu_function,s.id  
				from system_menu s  inner join 	s_ref_type st on st.value=s.id 
				and st.type='module_type' inner join
				s_user_schema us on us.module_type=st.internal_code
				inner join 	user_rights ur on ur.module_id=us.internal_code
				where s.active=1  and ur.is_view=1  and system_menu='F'
				and ref_s_sysdb_code={$user_id}  and college_code='{$college_code}'
				group by s.internal_code
				order by ifnull(s.sequence,1),s.menu_name";	
				
				$lstr_qry = "select s.internal_code,ifnull(display_module_name,module_name) as module_name,  
				ifnull(display_module_name,module_name)  as  display_module_name,
				t.value,is_menu_only,if(is_menu_only=1,menu_function,'') as menu_function 
				,IFNULL(main_menu,'0') as main_menu_id,
				REPLACE(module_name,' ','~') as r_module_name,
				IFNULL(mm.value,concat('z',display_module_name)) as main_menu_val 
				from s_user_schema s inner join s_ref_type t
				on t.internal_code=module_type
				left join s_ref_type mm on mm.internal_code=main_menu
				inner join user_rights ur on ur.module_id=s.internal_code
				where module_name is not null and t.value='{$type}'
				and (is_view=1 or is_add=1 or is_edit=1 or is_del=1)
				and ref_s_sysdb_code={$user_id} and college_code='{$college_code}' 
				and s.active=1 {$markscol}
				group by s.internal_code
				order by  ifnull(s.sequence,0),main_menu_val,ifnull(display_module_name,module_name)";
			}
			else if(strtolower($user_name)=='vkuadmin')
			{
				$sql_query="select internal_code,menu_name,menu_function,id  from system_menu  	
				where active=1  and system_menu='T' order by ifnull(sequence,1),menu_name";

for($m=0;$m<count($lobj_rs);$m++)
			{
				$r_module_name=$lobj_rs[$m][r_module_name];
				$dis_module_name=$lobj_rs[$m][display_module_name];
				$int_code=$lobj_rs[$m][internal_code];
				$call_mod="";
				$call_mod=($lobj_rs[$m]['is_menu_only']=='0')?" getModulesDetails('{$r_module_name}',{$int_code},'Add','{$dis_module_name}') ":$lobj_rs[$m]['menu_function'];
				 
				if($i==0)
				{
					if($main_menu_id>0)
					{
						$html.="<li><a href='#' >{$lobj_rs[$m][main_menu_val]}</a>  \n";
						$html.="<ul> \n";
						$html.="<li><a href='#' onclick=\"{$call_mod};\" >{$lobj_rs[$m][module_name]} </a> </li>\n";
					}
					else
					{
						$html.="<li><a href='#' onclick=\"{$call_mod};\" >{$lobj_rs[$m][module_name]} </a> </li> \n";
					}
					$main_menu_id =   $lobj_rs[$m][main_menu_id];
					$main_menu_val =  $lobj_rs[$m][main_menu_val];
					$i++;
					continue;
				}
				else 
				{
					if($main_menu_id==$lobj_rs[$m][main_menu_id] && $lobj_rs[$m][main_menu_id]>0)
					{
						$html.="<li><a href='#' onclick=\"{$call_mod};\" >{$lobj_rs[$m][module_name]} </a> </li>\n";
						$main_menu_id =   $lobj_rs[$m][main_menu_id];
						$main_menu_val =  $lobj_rs[$m][main_menu_val];
					}
					else if($main_menu_id<>$lobj_rs[$m][main_menu_id] && $lobj_rs[$m][main_menu_id]>0)
					{
							if($lobj_rs[$m-1][main_menu_id]>0) {
							$html.="</ul> \n";
							$html.="</li> \n"; }
							$html.="\t <li><a href='#'>{$lobj_rs[$m][main_menu_val]}</a>   \n";
							$html.="<ul> \n";
							$html.="<li><a href='#' onclick=\"{$call_mod};\" >{$lobj_rs[$m][module_name]}</a> </li>\n";
					}
					else 
					{
						if($lobj_rs[$m-1][main_menu_id]>0)
						{
							$html.="</ul> \n";
							$html.="</li> \n"; 
						}
						$html.=" \t <li><a href='#' onclick=\"{$call_mod};\" >{$lobj_rs[$m][module_name]}</a> </li>\n";	
					}
					$main_menu_id =   $lobj_rs[$m][main_menu_id];
					$main_menu_val =  $lobj_rs[$m][main_menu_val];
				}
			}
			if($lobj_rs[$m-1][main_menu_id]>0)
			{
				$html.="</ul> \n";
				$html.="</li> \n"; 
			}
			$html.="</ul>  \n";	
			$html.="</div>  \n";

}
			  
		$arr['login_cnt'] = $_SESSION['login_cnt'];
		$arr['details'] = $lobj_rs_data;
		$arr['html'] = $html;

if(count($lobj_rs_data) != 0)
			print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success")); 
		else
			print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"));
		return;
	}

function GetUserSchemaParentGroup($aobj_context)
	{ 
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  	 
		$schema_name =($aobj_context->mobj_data["schema_name"]);
		$get_details="select  internal_code,name as user_schema 
				from s_user_schema_group 
				where ref_s_user_schema_code={$schema_name} order by name";
		$lobj_details = $aobj_context->mobj_db->getAll($get_details); 
		
		$arr['parent_group']=$lobj_details;						
		if( $lobj_details)
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
		else
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
	 }

$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);

$last_inserted_id  = $aobj_context->mobj_db->Insert_ID();
				$get_admin_id="select * from s_sysdb where sysusr='admin'";
				$lobj_get_admin_id = $aobj_context->mobj_db->getRow($get_admin_id); 
				$insert_new_user="insert into user_rights(
							ref_s_sysdb_code,
							module_type,
							module_id,
							is_view,
							is_add,
							is_edit,
							is_del) values
							(
							'{$lobj_get_admin_id[internal_code]}',
							'{$module_type}',
							'{$last_inserted_id}',
							'1',
							'1',
							'1',
							'1'	)";
							$lobj_insert_user = $aobj_context->mobj_db->Execute($insert_new_user);
							
				if($mod_type=='Reports')
				{
					$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
					$main_src=$main_src_obj[1];
					$report_storage_path=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/report_result_".$last_inserted_id.".php";
					$report_format_path=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/src/general_report_format.php";
					file_put_contents($report_storage_path,file_get_contents($report_format_path));  
				}																				
				if($create_table==1 && $mod_type!='Reports' && $is_menu_only=='0')
				{
					$create_table="CREATE TABLE module_".$last_inserted_id.
					"(
						internal_code bigint(20) unsigned NOT NULL auto_increment,
						ref_s_user_schema_code bigint(20),
						created_by  int(11) default NULL,
						created_date  datetime default NULL,
						modified_by  int(11) default NULL,
						modified_date  datetime default NULL,
						PRIMARY KEY  (internal_code)
					) engine INNODB ";		
												
					$lobj_rs = $aobj_context->mobj_db->Execute($create_table);   
					$create_details_table="CREATE TABLE module_".$last_inserted_id."_details".
									"(
									  internal_code bigint(20) unsigned NOT NULL auto_increment,
									  ref_s_user_schema_code bigint(20) ,
									   ref_s_module_code int(11) default NULL,
									  ref_s_user_schema_group_code int(11) default NULL,
									  ref_s_user_schema_elements_code int(11) default NULL,
									  value text collate latin1_general_ci,
									  ref_ref_s_user_schema_code int(11) default NULL,
									   created_by  int(11) default NULL,
									   created_date  datetime default NULL,
									   modified_by  int(11) default NULL,
									   modified_date  datetime default NULL,
									  PRIMARY KEY  (internal_code),
									  KEY NewIndex1 (ref_s_user_schema_code),
									  KEY NewIndex2 (ref_s_module_code),
									  KEY NewIndex3 (ref_s_user_schema_group_code),
									  KEY NewIndex4 (ref_s_user_schema_elements_code)
									   
									) engine INNODB";		
												
					$lobj_rs = $aobj_context->mobj_db->Execute($create_details_table); 
				}
				if($lobj_rs)
				{
					$rdata = "Module Inserted Successfully.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return $rdata;
				}
				else
				{
					$rdata = "insertion Failed.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));  
					return $rdata;			
				}    
			}
			else 	
			{
				$rdata = "Module Name Already Exstis!";
				print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
				return $rdata;
			}
		}
		else  
		{
				$lstr_qry = "update s_user_schema
				set module_name='".$module_name."',
				module_type='".$module_type."',display_module_name='".$user_schema_display_module_name."', 
				main_menu= '{$main_menu}', display_type= '".$display_type."',
				active= {$active} ,is_menu_only='{$is_menu_only}',
				menu_function= '{$module_function_name}',
				include_save= '".$is_save."',include_clear= '".$is_clear."',
				include_download= '".$is_download."',include_view= '".$is_view."',
				include_generate = '".$is_generate."',
				custom_links= \"{$custom_links}\",
				grid_type= '{$module_grid_type}',
				s_col_names= \"{$grid_user_schema_coloum_names}\",
				s_col_model= \"{$grid_user_schema_coloum_models}\",
				s_grid_query= \"{$grid_user_schema_grid_query}\" ,
				s_grid_custom_links= \"{$grid_custom_links}\", 
				grid_default_rows = \"{$user_schema_grid_default_rows}\",
				js_path= '{$user_schema_js_path}'
				where internal_code ={$internal_code}";	
				$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
				
				if($lobj_rs)
				{
					$rdata = "Updated  Successfully.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return;
				}
				else
				{
					$rdata = "Udatation Failed.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));      
				} 
		}            
	}
	
	function GetSchemaDetailsForUpdate($aobj_context)
	{
			$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$internal_code = $aobj_context->mobj_data["internal_code"]; 
			$get_data="select internal_code, module_name, display_module_name, 
					module_type,is_menu_only,ifnull(menu_function,'') as menu_function,main_menu
					,display_type, active,include_save,include_clear,include_download,include_view,
					s_col_names,s_col_model,s_grid_query,grid_type,
					include_generate,include_close,custom_links,
					s_grid_custom_links,js_path,grid_default_rows 
					from s_user_schema where internal_code='".$internal_code."'";	
			$lobj_rs = $aobj_context->mobj_db->GetRow($get_data); 
			if(count($lobj_rs) > 0)
				echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
			else
				echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
			return;
	}

function getModuleNameForGroups($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);    
		$get_module_name="select internal_code,module_name as user_schema 
		from s_user_schema where is_menu_only=0 and active =1 order by module_name";	
		
		$lobj_rs = $aobj_context->mobj_db->GetAll($get_module_name);

function forInsertuserschemagroup($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
		$internal_code=$aobj_context->mobj_data["internal_code"];
		$group_order_by=$aobj_context->mobj_data["user_schema_group_order_by"];
		$grid_default_rows=$aobj_context->mobj_data["user_schema_group_grid_default_rows"];
		$grid_default_rows= (empty($grid_default_rows))?0:$grid_default_rows;
		
		if($internal_code==0)
		{	
			$get_data="select count(*) as group_schema_count from s_user_schema_group 
			where name='". $aobj_context->mobj_data["user_schema_group_name"] ."'"." 
			and ref_s_user_schema_code=".$aobj_context->mobj_data["group_user_schema"];
			$lobj_rs = $aobj_context->mobj_db->GetRow($get_data);
		
			if($lobj_rs['group_schema_count']==0)
			{
				$lstr_qry = "insert into s_user_schema_group(  
					ref_s_user_schema_code,
					name,parent_group_code,sequence,multiple,is_grid_edit,inline_div,col_name,col_model,grid_edit_query,custom_links,on_click_event,group_order_by,group_default_rows) 
					values ( '" .   addslashes($aobj_context->mobj_data["group_user_schema"]) ."','"
							 .   addslashes($aobj_context->mobj_data["user_schema_group_name"])."','"
							 .   addslashes($aobj_context->mobj_data["user_schema_parent_group"])."','"
							 .   addslashes($aobj_context->mobj_data["sequence"])."','"
							 .   addslashes($aobj_context->mobj_data["is_multiple_user_schema_group"])."','"
							 .   addslashes($aobj_context->mobj_data["is_grid_edit_user_schema_group"])."','"
							 .   addslashes($aobj_context->mobj_data["is_inline_div_user_schema_group"])."',\""
							 .   addslashes($aobj_context->mobj_data["user_schema_coloum_names"])."\",\""
							 .   addslashes($aobj_context->mobj_data["user_schema_coloum_models"])."\",\""
							 .   addslashes($aobj_context->mobj_data["user_schema_grid_query"])."\",\""
							 .   addslashes($aobj_context->mobj_data["user_schema_group_custom_links"])."\",\""
							 .   addslashes($aobj_context->mobj_data["user_schema_group_onclick"])."\",
							  '{$group_order_by}',{$grid_default_rows})";
								
				$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);      
				$last_inserted_id  = $aobj_context->mobj_db->Insert_ID();
						
				if($aobj_context->mobj_data["is_multiple_user_schema_group"]==1)
				{ 
					$qry="select CONCAT('user_schema_',ms.INTERNAL_CODE,'_group_',msg.internal_code) as  group_table_name,
					CONCAT('user_schema_',ms.INTERNAL_CODE,'_entry_',msg.internal_code) as  entry_table_name 
					from s_user_schema_group msg inner join s_user_schema ms on ms.internal_code=msg.ref_s_user_schema_code
					where msg.internal_code=$last_inserted_id";
					$lobj_rs = $aobj_context->mobj_db->GetRow($qry);

$create_table="CREATE TABLE ". $lobj_rs['group_table_name'].
					"(
					internal_code bigint(20) unsigned NOT NULL auto_increment,
					ref_s_user_schema_code bigint(20),
					ref_s_user_schema_group_code bigint(20),
					ref_s_ref_data_code bigint(20),
					created_by  int(11) default NULL,
					created_date  datetime default NULL,
					modified_by  int(11) default NULL,
					modified_date  datetime default NULL,
					PRIMARY KEY  (internal_code),
					KEY `ref_s_ref_data_code` (`ref_s_ref_data_code`) 
					)  engine INNODB";
					
					$lobj_create_table = $aobj_context->mobj_db->Execute($create_table);

$create_entry_table="CREATE TABLE {$lobj_rs['entry_table_name']}
					(
					internal_code bigint(20) unsigned NOT NULL auto_increment,
					login_cnt int(11), 
					group_int_code int(11) default 0, 
					ref_s_user_schema_code bigint(20),
					ref_s_user_schema_group_code bigint(20),
					ref_s_ref_data_code bigint(20),
					created_by  int(11) default NULL,
					created_date  datetime default NULL,
					modified_by  int(11) default NULL,
					modified_date  datetime default NULL,
					PRIMARY KEY  (internal_code),
					KEY `login_cnt` (`login_cnt`),
					KEY `group_int_code` (`group_int_code`),
					KEY `ref_s_ref_data_code` (`ref_s_ref_data_code`) 
					)  engine INNODB";

$lobj_create_entry_table = $aobj_context->mobj_db->Execute($create_entry_table);
											
				}
					
					
				$get_module_type="select module_type from s_user_schema where internal_code=".$aobj_context->mobj_data["group_user_schema"];
				$lobj_get_module_type = $aobj_context->mobj_db->getRow($get_module_type);

$module_type=$lobj_get_module_type["module_type"];
				$module_id=$aobj_context->mobj_data["group_user_schema"]."_".$last_inserted_id;
				$insert_rights="insert into user_rights(
				ref_s_sysdb_code,
				module_type,
				module_id,
				is_view,
				is_add,
				is_edit,
				is_del) values
				(1,{$module_type},'{$module_id}',1,1,1,1)";
				
				$lobj_insert_rights = $aobj_context->mobj_db->Execute($insert_rights);    	
				if($lobj_rs)
				{
					$rdata = "Group Name inserted successfully.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return $rdata;
				 }
				else
				{
					$rdata = "insertion Failed.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));  
					return $rdata;			
				}    			
			}
			else 	
			{
				 $rdata = "Group Name Already Exstis!";
				print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
				return $rdata;
			}
		}
		else
		{
			$group_table="select internal_code,ref_s_user_schema_code,multiple, 
					concat('user_schema_',ref_s_user_schema_code,'_group_',internal_code)
					as table_name from s_user_schema_group where internal_code=".$internal_code;
					$lobj_rs_row = $aobj_context->mobj_db->GetRow($group_table);
			if($aobj_context->mobj_data["is_multiple_user_schema_group"]==0)
			{
				$drop_non_multiple="drop table if EXISTS user_schema_".$aobj_context->mobj_data["group_user_schema"]."_group_".$aobj_context->mobj_data["internal_code"];
				$drop_obj=$aobj_context->mobj_db->Execute($drop_non_multiple);
			}
			else if($lobj_rs_row["multiple"]==0 && $aobj_context->mobj_data["is_multiple_user_schema_group"]==1)
			{	
				$create_table="CREATE TABLE user_schema_".$aobj_context->mobj_data["group_user_schema"]."_group_".$internal_code.
								"(
									internal_code bigint(20) unsigned NOT NULL auto_increment,
									ref_s_user_schema_code bigint(20),
									ref_s_user_schema_group_code bigint(20),
									ref_s_ref_data_code bigint(20),
									created_by  int(11) default NULL,
									created_date  datetime default NULL,
									modified_by  int(11) default NULL,
									modified_date  datetime default NULL,
									PRIMARY KEY  (internal_code)
								)";
				$lobj_create_table = $aobj_context->mobj_db->Execute($create_table); 
				$create_entry_table="CREATE TABLE ". $lobj_rs['entry_table_name'].
									"(
										internal_code bigint(20) unsigned NOT NULL auto_increment,
										login_cnt int(11), 
										group_int_code int(11) default 0,
										ref_s_user_schema_code bigint(20),
										ref_s_user_schema_group_code bigint(20),
										ref_s_ref_data_code bigint(20),
										created_by  int(11) default NULL,
										created_date  datetime default NULL,
										modified_by  int(11) default NULL,
										modified_date  datetime default NULL,
										PRIMARY KEY  (internal_code),
										KEY `login_cnt` (`login_cnt`),
										KEY `group_int_code` (`group_int_code`)
									)  ";
				$lobj_create_entry_table = $aobj_context->mobj_db->Execute($create_entry_table); 	
			}
				$lstr_qry = "update s_user_schema_group
				set ref_s_user_schema_code='".trim($aobj_context->mobj_data["group_user_schema"]) ."',".
				"name='".$aobj_context->mobj_data["user_schema_group_name"] ."',".
				"parent_group_code='".$aobj_context->mobj_data["user_schema_parent_group"] ."',".
				"multiple='".$aobj_context->mobj_data["is_multiple_user_schema_group"] ."',
				sequence=".trim($aobj_context->mobj_data["sequence"]) .",
				is_grid_edit=".trim($aobj_context->mobj_data["is_grid_edit_user_schema_group"]) .",
				inline_div=".trim($aobj_context->mobj_data["is_inline_div_user_schema_group"]) .",
				col_name=\"".trim($aobj_context->mobj_data["user_schema_coloum_names"]) ."\",
				col_model=\"".trim($aobj_context->mobj_data["user_schema_coloum_models"]) ."\",
				grid_edit_query=\"".trim($aobj_context->mobj_data["user_schema_grid_query"]) ."\",
				custom_links=\"".trim($aobj_context->mobj_data["user_schema_group_custom_links"]) ."\",
				on_click_event=\"".trim($aobj_context->mobj_data["user_schema_group_onclick"]) ."\",
				group_order_by='{$group_order_by}',
				group_default_rows={$grid_default_rows}
				where internal_code =".$aobj_context->mobj_data["internal_code"];
				
				$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
				if($lobj_rs)
				{
					$rdata = "Updated  Successfully.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return;
				}
				else
				{
					$rdata = "Udatation Failed.";
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));      
				} 
		}		 
	}

function GetUserSchemaGroupDetailsForUpdate($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
		$internal_code = $aobj_context->mobj_data["internal_code"]; 
		
		$qry="select * from s_user_schema_group where internal_code=$internal_code";
		$lobj_rs = $aobj_context->mobj_db->GetRow($qry); 
						 
		if(count($lobj_rs) != 0)
		  echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
		else
		  echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
		return;
	}

function getUserSchemaElementType($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$sql_query="select internal_code, type,value  
				from s_ref_type  	
				where type in('data_type','element_type') 
				order by type,value";

$lobj_rs = $aobj_context->mobj_db->GetAll($sql_query);        
		if(count($lobj_rs) != 0)
			print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success")); 
		else
			print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"));
		return;
	}

function getUserSchemaElementReferenceData($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		$module_name=$aobj_context->mobj_data["module_name"];
		$qry=" select internal_code,module_name  
		from s_user_schema where is_menu_only=0 and active =1 order by module_name"; 
		$lobj_rs = $aobj_context->mobj_db->GetAll($qry);
		//echo $qry;
		print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"));
		return $lobj_rs;
	}

function getUserSchemaGroup($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		
		$sql_query="select internal_code,name as user_schema_group  
					from s_user_schema_group where 
					ref_s_user_schema_code=".$aobj_context->mobj_data["elemenmt_user_schema"]." order by name";	
		$lobj_rs = $aobj_context->mobj_db->GetAll($sql_query);        
		
		$select_max_seq="select round(ifnull(max(sequence),0)+1) as sequence 
						from s_user_schema_elements 					
						where ref_s_user_schema_code=".$aobj_context->mobj_data["elemenmt_user_schema"];
		$lobj_select_max_seq = $aobj_context->mobj_db->GetRow($select_max_seq); 
		$sequence=	$lobj_select_max_seq['sequence'];
		$arr[0]=$lobj_rs;
		$arr[1]=$sequence;
		if(count($lobj_rs) != 0)
			print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success")); 
		else
			print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"));
		return;
	}

}				$aobj_context->mobj_data["schema_id"]=$schema_id;
					include_once(dirname(__FILE__)."/create_all_grid_files.php");
					populateAllGridFiles($aobj_context);
					include(dirname(__FILE__)."/create_module_meta_columns.php");
					createModuleMetaColumns($aobj_context);
					include(dirname(__FILE__)."/create_all_grid_group_files.php");
					populateAllGridGroupFiles($aobj_context); 
					include(dirname(__FILE__)."/create_html_files.php");
					CreateModuleHtmlFiles($aobj_context);
					include(dirname(__FILE__)."/create_all_popup_files.php");
					populateAllPopupGridFiles($aobj_context);
					include(dirname(__FILE__)."/update_defined_flag.php");
					UpdateDefinedFlag($aobj_context);
				 if($lobj_rs)
				{
					$rdata[0] = "Updated  Successfully.";
					 $rdata[1] = $max_seq;
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
					return;
				 }
				else
				{
					$rdata[0] = "Udatation Failed.";
					 $rdata[1] = $max_seq;
					print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));      
				 } 
	}
	
	function UpdateDbField($aobj_context,$schema_id)
	{
		$update_db_value=" update s_user_schema_elements suse,
				(select  suse.internal_code as db_field_ic_code, 
				case when t.value in('User','Meta')  and ref_s_user_schema_group_code>0 and 
				(is_multiple_group=1 or ug.parent_group_code<>0)
				then 
				if(suse.is_multiple_group=1,
				concat('u_',suse.ref_s_user_schema_code,'_g_',ref_s_user_schema_group_code,'_ele_',suse.internal_code),
				concat('u_',suse.ref_s_user_schema_code,'_g_',ug.parent_group_code,'_ele_',suse.internal_code)
				)
				when t.value='Meta' and ref_s_user_schema_group_code=0
				then
				concat('m_',suse.ref_s_user_schema_code,'_ele_',suse.internal_code)
				when t.value='Meta' and ref_s_user_schema_group_code>0 and is_multiple_group=0
				then
				concat('m_',suse.ref_s_user_schema_code,'_ele_',suse.internal_code)
				else ''
				end as db_fields_s_user_schema_elements
				from s_user_schema_elements suse 
				left join s_user_schema_group ug on ug.internal_code=ref_s_user_schema_group_code
				inner join s_ref_type t on t.internal_code=s_ref_type_meta
				 where suse.ref_s_user_schema_code={$schema_id}
				) a
				set db_field=db_fields_s_user_schema_elements
				where db_field_ic_code=suse.internal_code";
		$lobj_rs_update_db_value = $aobj_context->mobj_db->Execute($update_db_value); 
	}
	
	function updateUserSchemaElementDbField($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		
		$update_db_value=" update s_user_schema_elements suse,
		(select  suse.internal_code as db_field_ic_code, 
		case when t.value in('User','Meta')  and ref_s_user_schema_group_code>0 and 
		(is_multiple_group=1 or ug.parent_group_code<>0)
		then 
		if(suse.is_multiple_group=1,
		concat('u_',suse.ref_s_user_schema_code,'_g_',ref_s_user_schema_group_code,'_ele_',suse.internal_code),
		concat('u_',suse.ref_s_user_schema_code,'_g_',ug.parent_group_code,'_ele_',suse.internal_code)
		)
		when t.value='Meta' and ref_s_user_schema_group_code=0
		then
		concat('m_',suse.ref_s_user_schema_code,'_ele_',suse.internal_code)
		when t.value='Meta' and ref_s_user_schema_group_code>0 and is_multiple_group=0
		then
		concat('m_',suse.ref_s_user_schema_code,'_ele_',suse.internal_code)
		else ''
		end as db_fields_s_user_schema_elements
		from s_user_schema_elements suse 
		left join s_user_schema_group ug on ug.internal_code=ref_s_user_schema_group_code
		inner join s_ref_type t on t.internal_code=s_ref_type_meta
		#where suse.ref_s_user_schema_code={$schema_id}
		) a
		set db_field=db_fields_s_user_schema_elements
		where db_field_ic_code=suse.internal_code";

$lobj_rs_update_db_value = $aobj_context->mobj_db->Execute($update_db_value);
		$rdata = "Udatation Done.";
		print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"Success"));      
	}

function GetUserSchemaElementsRefModuleFilterDetails($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		$schema_id=$aobj_context->mobj_data["schema_id"];
		$ref_module_code =$aobj_context->mobj_data["ref_module_code"];		
		
		$select_ref_module_field_names="select internal_code,name
								from s_user_schema_elements 
								where ref_s_user_schema_code={$ref_module_code}"; 
		
		$lobj_select_ref_module_field_names = $aobj_context->mobj_db->GetAll($select_ref_module_field_names);

$select_schema_field_names="select internal_code,name 
							from s_user_schema_elements
							where ref_s_user_schema_code={$schema_id}";
		
		$lobj_select_schema_field_names = $aobj_context->mobj_db->GetAll($select_schema_field_names);
		
		$rdata['ref_module_fields']=$lobj_select_ref_module_field_names;
		$rdata['schema_fields']=$lobj_select_schema_field_names;
		print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
	}	
?>

${this.title}

Code Editor : systemsetup.php