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 : uploadmoduledetails.php

<?php
function getModuleDetailsHeaders($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$schema_id = $aobj_context->mobj_data["schema_id"];
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	$excel_writer=$aobj_context->main_src."/Excel_Writer/Writer.php";
	require_once($excel_writer);
	$tarka_format_file=$aobj_context->main_src."/custom_src/TarkaFormatStyles.php";
	require_once($tarka_format_file);	
	$objfrmt =& new FormatStyle();  
 
	$workbook = new Spreadsheet_Excel_Writer();
	$Title_Center =& $workbook->addFormat($objfrmt->Title_Center);
	$worksheet =& $workbook->addWorksheet();
	
	$get_headers="(select 
				ue.internal_code,
				ue.name as element_name,
				s.value as Type,
				ifnull(ug.name,'0None') as group_name,
				s1.value as meta_data,decimals,
				 
				optional,list_of_values,
				u.internal_code as ref_s_user_schema_code,
				ue.ref_module_code  
				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
				where u.internal_code= {$schema_id}
				 and  is_multiple_group=0 order by ifnull(ug.sequence,0),ue.sequence,ue.internal_code )";
				 $lobj_details = $aobj_context->mobj_db->GetAll($get_headers);
   
	$row=0;
	$cell=1;
	  $worksheet->write($row,0, "internal_code");
  foreach($lobj_details as $key=> $value)
   {
	if($value[optional]==1)
	{
    $worksheet->write($row,$cell, $value[element_name]);
	}
	else
	{
	 $worksheet->write($row,$cell, $value[element_name],$Title_Center);
	}
    $cell++; 		                
	}

$workbook->send($schema_id.'.xls','D');	
	$workbook->close();  
          
 
}

$workbook->send($schema_id.'.xls','D');	
	$workbook->close();  
          
 
}

function downloadModuleData($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$schema_id = $aobj_context->mobj_data["schema_id"];
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	$excel_writer=$aobj_context->main_src."/Excel_Writer/Writer.php";
	require_once($excel_writer);
	$workbook = new Spreadsheet_Excel_Writer();
	$workbook->setVersion(8);

$worksheet =& $workbook->addWorksheet('sheet 1');
	
	$get_data_type="SELECT name,t.value
					from 
					s_user_schema_elements s
					inner join s_ref_type t
					on t.internal_code=data_type
					where ref_s_user_schema_code={$schema_id}";
	$obj_get_data_type =  $aobj_context->mobj_db->GetAll($get_data_type);
		 $data_type_arr= array();		
		for($k=0;$k<count($obj_get_data_type);$k++)
		{
		$data_type_arr[$obj_get_data_type[$k]['name']]=$obj_get_data_type[$k]['value'];
		}
		 
	$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");
	$aobj_context->mobj_db->execute("set @a:=0");
 		$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]:'';
	$group_table=" select GROUP_CONCAT(group_table  SEPARATOR ' ') as group_table from 
						(select concat(' left join user_schema_',ref_s_user_schema_code,'_group_',internal_code, ' as ug_',internal_code,' on ',' ug_',internal_code,'.ref_s_ref_data_code=module_',ref_s_user_schema_code,'.internal_code') as group_table
						 from s_user_schema_group where ref_s_user_schema_code={$schema_id} and multiple=1)d";
						 
	$obj_group_table =  $aobj_context->mobj_db->GetRow($group_table);	
	
		if(!is_null($obj_group_table[group_table]))
		{
		$group_table_join_qry=$obj_group_table[group_table];
		$get_group_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('ug_',group_int_code,'.',field_name,' as ',\"'\",name,\"'\"),
									concat('module_',ref_module_code,'_',ele_ic_code,'.',field_id1,' as ',\"'\",name,\"'\")) as field_name
									,ref_module_code from 
									(select  s.internal_code, ref_module_code,concat('module_',s.internal_code) as table_name ,
									field_id1,ref_s_user_schema_group_code as group_int_code,su.internal_code as ele_ic_code,
									su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,
									db_field 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'
									 order by ug.sequence,su.sequence,su.internal_code ) l 
									 where   multiple=1
									 ) a ";
		 				 		 
		$lobj_get_group_display_cols = $aobj_context->mobj_db->GetRow($get_group_display_cols);
		 $group_table_dis_cols=','.$lobj_get_group_display_cols[field_name];
		
		$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000");
		$aobj_context->mobj_db->execute("set @a:=0");
	 	$select_group_table_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
		(select   ref_module_code,
		concat(' left join module_',ref_module_code, ' as module_',ref_module_code,'_',sus.internal_code,' on module_',ref_module_code,'_',sus.internal_code,'.internal_code =ug_',ref_s_user_schema_group_code,'.',db_field) as join_table_name
		from s_user_schema_elements sus
		inner join s_user_schema s on s.internal_code=sus.ref_s_user_schema_code
		where s.internal_code={$schema_id}
		and is_multiple_group=1 and ref_module_code>0)j";
		$obj_select_group_table_ref_module_code =  $aobj_context->mobj_db->GetRow($select_group_table_ref_module_code);
		$group_table_ref_module= (!is_null($obj_select_group_table_ref_module_code[qry]))?$obj_select_group_table_ref_module_code[qry]:'';
		}
		else
		{
		$group_table_join_qry='';
		$group_table_dis_cols='';
		}
	
	$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(\"concat(\",f1,f2,\") as \",'\'',name,'\''),
							if(data_type='Date',
							concat('DATE_FORMAT(','module_',internal_code,'.',field_name,',\'%d-%b-%Y\') as  \'',name,'\''),
											
							concat('module_',internal_code,'.',field_name,' as \"', name,'\"'))) as field_name
							,ref_module_code from 
							(select  s.internal_code, su.internal_code as ele_id,t1.value as data_type,
							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,
							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
							inner join s_ref_type t1 on t1.internal_code=data_type
							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'
							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);
		 //echo $get_display_cols; die();
		ini_set("memory_limit",-1);
	ini_set('max_execution_time', 1400);
		$select_data="(select  module_{$schema_id}.internal_code as internal_code,
							{$lobj_get_display_cols[field_name]} {$group_table_dis_cols}
							from   module_{$schema_id} {$join_qry} {$group_table_join_qry} {$group_table_ref_module} ) ";
		//echo $select_data; die();					
	 	$lobj_details = $aobj_context->mobj_db->GetAll($select_data);	
		 
 	  
	$header_row=(array_keys($lobj_details[0]));
 	$header_row_cell_indx=0;
	foreach($header_row as $key1=> $value1)
   {
    $worksheet->write(0,$header_row_cell_indx,$value1);
	$header_row_cell_indx++;	 
   }
      $xlsRow = 1;
	  
     foreach($lobj_details as $key=> $value)
	{
		$xlscol=0;
	 
	    foreach($value as $key1=> $value1)
	    {
		if($data_type_arr[$key1]=='Number' or $key1=='internal_code' or $data_type_arr[$key1]=='Date')
		 $worksheet->write($xlsRow,$xlscol,$value1);
		else
		 $worksheet->writeString($xlsRow,$xlscol,$value1);
	     $xlscol++;
		}
		 $xlsRow++; 
	}	         
	$workbook->close();	
$workbook->send("report_{$schema_id}.xls");	
}

$lobj_insert_bill_group_details = $aobj_context->mobj_db->execute($insert_bill_group_details); 
		  		 
		 
		 }
	   }
    }
	
	 unlink($root_file_name);
	 unset($_FILES);
	 
	$lobj_get_ids = 'Successfully Uploaded' ;
	 
    echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_ids,0,"success");  
 }
 
function getStageCode($aobj_context,$obj_master,$stage)
 {
      $find_stgae_code = "select internal_code
					           from {$obj_master->stage_master_table} where {$obj_master->stage_master_name} = '{$stage}'";
												
	  $lobj_find_stgae_code = $aobj_context->mobj_db->GetRow($find_stgae_code);
	   
	  return  $lobj_find_stgae_code[internal_code];

}

$data_str.=" if (file_exists('$validation_file_name')) {
					require_once('$validation_file_name');
					}
						require_once('$format_file');	";
			
				$data_str.="\$s_ref_error_flag=0; \n";
				$data_str.="\$validate_ref_error_flag=0; \n";
				$data_str.="  {$input_fields_arr} \n";
				$data_str.="\$original_value=''; \n";
				$data_str.="\$error_msg=''; \n";
				$data_str.="\$down_load_value=''; \n";
				$data_str.="\$validation=''; \n";
				$data_str.="\$header_value='Following Records are not inserted'.\"\\n\"; \n";
			 	$data_str.="for (\$i = 2; \$i <= \$data->sheets[0]['numRows']; \$i++) 
				{
				\$values='';
				\$original_value='';
				\$validation='' \n;
				\$error_msg='';
				\$validate_ref_error_flag=0;
				\$s_ref_error_flag=0;
					for (\$j = 1; \$j <= \$data->sheets[0]['numCols']; \$j++) {
					if(\$i==2)
					{
					\$header_value.=\$data->sheets[0]['cells'][1][\$j].\",\";
					} \n
					";
					//To Map Internal_code
			$data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('internal_code')) { \n ";
					$data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n";
					$data_str.="\$internal_code=trim(\$data->sheets[0]['cells'][\$i][\$j]); \n";
					$data_str.="\$internal_code=empty(\$internal_code)?0:\$internal_code; \n
					}";
					
				$cell_row=1;
			 foreach ($lobj_get_name as $key=>$value)
			{
				if(1)
				{
					if($value[is_unique]==1)
					{
					$update_cond.="{$value[field_id]} = '{\$".$value[field_id]."}' and ";
					}
					if($value[ref_module_code]!=0 && $value[meta_data]=='Meta')
					{
					$qry=" select table_name,field_name as name,field_id1 ,field_id2 
					from module_meta_columns WHERE module_id={$value[ref_module_code]}"; 
			  
					$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
					$data_str.="\$where_cond1='';\$where_cond2='';\$concat_cond='';";
					 
					 $data_str.="\n if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) \n { \n";
					 $data_str.="\$cell_value=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n";
					 $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n";
					 $data_str.="\$where_cond1=\"{$lobj_rs[field_id1]} like '{\$cell_value}'\"; \n";
					//$where_cond1= $data[".$k."] ;
					
					 
					if(!empty($lobj_rs[field_id2]))
					{
					$data_str.="\$where_cond2=\" or  {$lobj_rs[field_id2]} like '{\$cell_value}'\"; \n";
					$data_str.="\$concat_cond=\" or  concat({$lobj_rs[field_id1]},' - ',{$lobj_rs[field_id2]})  like '{\$cell_value}'\"; \n";
					}
					$data_str.="\$select_ref_data_{$value[ref_module_code]}=\"select internal_code from {$value[ref_table_name]} where {\$where_cond1}  {\$where_cond2} {\$concat_cond}\"; \n";
					 $data_str.="\$obj_select_ref_data_{$value[ref_module_code]} =  \$aobj_context->mobj_db->GetRow(\$select_ref_data_{$value[ref_module_code]}); \n";
					if($value[optional]=='0')
					{
					$data_str.=" if(empty(\$cell_value)) \n
							{ \n
							\$s_ref_error_flag=1; \n
							\$error_msg.='{$value[element_name]} is Mandatory:'; \n
							} \n";
					}
					$data_str.=" if(empty(\$obj_select_ref_data_{$value[ref_module_code]}) && !empty(\$data->sheets[0]['cells'][\$i][\$j])) \n
							{ \n
							\$s_ref_error_flag=1; \n
							\$error_msg.='{$value[element_name]} not Found:'; \n
							} \n";
					 $data_str.="$".$value[field_id]."  = empty(\$obj_select_ref_data_{$value[ref_module_code]}[internal_code])?0:\$obj_select_ref_data_{$value[ref_module_code]}[internal_code]; \n ";
							$data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~';";
							$data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};";
							$data_str.=" } \n ";
					$insert_value.="'{\$".$value[field_id]."}',";
					$update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , ";
					 
					$k++;
					}
					else if($value[Type]=='List Of Values' && $value[meta_data]=='Meta')
					{
					
					$data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					$data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).','; \n";
					 $data_str.="\$lov_val= \$data->sheets[0]['cells'][\$i][\$j];";
					 
					 $data_str.="$".$value[field_id]."  = (empty(\$lov_val))?'".$value[first_lov]."':\$lov_val;\n ";
					 $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n";
					 $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};";
					  $data_str.=" } \n";
					 $insert_value.="'{\$".$value[field_id]."}',";
					 $update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , ";
					 
					$k++;
					}
					else if($value[Type]=='Date' && $value[meta_data]=='Meta' )
					{					 
					 $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					 $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n";
					 $data_str.="\$date_obj  = addslashes(\$data->sheets[0]['cells'][\$i][\$j]) ; \n  \n";
					 if($value[optional]=='0')
						{
						$data_str.=" if(empty(\$date_obj)) \n
								{ \n
								\$s_ref_error_flag=1; \n
								\$error_msg.='{$value[element_name]} is Mandatory:'; \n
								} \n";
						}
						
					 $data_str.="if(empty(\$date_obj))
						{
						\${$value[field_id]}='0000-00-00';
						}
						else {
						";
					
					 $data_str.="$".$value[field_id]."  = GetDbDateFormatFromExcel(\$date_obj);}\n";
					  $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n";
					  $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};";
					 $data_str.="}";
					$insert_value.="'{\$".$value[field_id]."}',";
					$update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , ";
				 
					$k++;
					}
					else if($value[meta_data]=='Meta' && $value[Type]=='Number')
					{					 
					 $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					 $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n";
					 $data_str.="$".$value[field_id]."  = addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n ";
					  if($value[optional]=='0')
						{
						$data_str.=" if(empty(\${$value[field_id]})) \n
								{ \n
								\$s_ref_error_flag=1; \n
								\$error_msg.='{$value[element_name]} is Mandatory:'; \n
								} \n";
						}
						
					 $data_str.="\${$value[field_id]}=empty(\${$value[field_id]})?0:\${$value[field_id]};";
					 $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n";
					 $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};";
					 $data_str.=" } \n";
					$insert_value.="'{\$".$value[field_id]."}',";
					$update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , ";
					 
					$k++;
					}else if($value[meta_data]=='Meta' && ($value[Type]=='Text' or $value[Type]=='Large Text'))
					{					 
					 $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					 $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n";
					 $data_str.="$".$value[field_id]."  = addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n ";
					  if($value[optional]=='0')
						{
						$data_str.=" if(empty(\${$value[field_id]})) \n
								{ \n
								\$s_ref_error_flag=1; \n
								\$error_msg.='{$value[element_name]} is Mandatory:'; \n
								} \n";
						}
					 $data_str.="\$validation.=\"{$value[field_id]}->\".\${$value[field_id]}.'~'; \n";
					  $data_str.="\$input_fields_arr['{$value[field_id]}']=\${$value[field_id]};";
					 $data_str.=" } \n";
					$insert_value.="'{\$".$value[field_id]."}',";
					$update_cond_value.=$value[field_id]."= '{\$".$value[field_id]."}' , ";
					 
					$k++;
					}
					// User Checking Starts Here
					else if( $value[meta_data]=='User' && $value[Type]=='List Of Values' )
					{ 
				
					 $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					$data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).',';  \n";
					 $data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n";
					  $data_str.="\$pos1 = stripos(\"{$value[list_of_values]}\", \$data->sheets[0]['cells'][\$i][\$j]);
					  \n if(\$pos1===false)
						{ \n
							\$s_ref_error_flag=1; \n
							} \n else \n";
					 $data_str.="\$user_details_array[{$m}][value]=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n } \n";
					 
					$m++;  
					$k++;
					}
					else if( $value[meta_data]=='User' && $value[ref_module_code]!=0 )
					{ 
					
					 
					 $qry=" select table_name,field_name as name,field_id1 ,field_id2 
					from module_meta_columns WHERE module_id={$value[ref_module_code]}"; 
			  
					$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
					
					 
					 $data_str.="\n if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) \n { \n";
					$data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).',';  \n";
					$data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n";
					 $data_str.="\$where_cond1=\"{$lobj_rs[field_id1]} like '{\$data->sheets[0]['cells'][\$i][\$j]}'\"; \n";
					//$where_cond1= $data[".$k."] ;
					
					 
					if(!empty($lobj_rs[field_id2]))
					$data_str.="\$where_cond2=\" or  {$lobj_rs[field_id2]} like '{\$data->sheets[0]['cells'][\$i][\$j]}'\"; \n";
					
					$data_str.="\$select_ref_data_{$value[ref_module_code]}=\"select internal_code from {$value[ref_table_name]} where {\$where_cond1}  {\$where_cond2}\"; \n";
					 $data_str.="\$obj_select_ref_data_{$value[ref_module_code]} =  \$aobj_context->mobj_db->GetRow(\$select_ref_data_{$value[ref_module_code]}); \n";
					$data_str.=" if(empty(\$obj_select_ref_data_{$value[ref_module_code]})) \n
							{ \n
							\$s_ref_error_flag=1; \n
							} \n";
					 $data_str.="\$user_details_array[{$m}][value] = \$obj_select_ref_data_{$value[ref_module_code]}[internal_code]; \n } \n ";
					 
					  
					$m++;  
					$k++;
					}
					else if( $value[meta_data]=='User' && $value[Type]!='List Of Values'  && $value[ref_module_code]==0)
					{ 
					 $data_str.="if(strtolower(\$data->sheets[0]['cells'][1][\$j])==strtolower('{$value[element_name]}')) { \n ";
					 $data_str.="\$original_value.=(\$data->sheets[0]['cells'][\$i][\$j]).\",\"; \n";
					 $data_str.="\$user_details_array[{$m}][element_name]='$value[element_name]' ; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_code]=$value[ref_s_user_schema_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_group_code]=$value[ref_s_user_schema_group_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_s_user_schema_elements_code]=$value[internal_code]; \n";
					 $data_str.="\$user_details_array[{$m}][ref_ref_s_user_schema_code]=$value[ref_module_code]; \n";
					 $data_str.="\$user_details_array[{$m}][value]=addslashes(\$data->sheets[0]['cells'][\$i][\$j]); \n } \n";
					$m++;  
					$k++;
					}
					
			 	}
				
				 				
			}
			 
			
 			$update_cond_value=substr($update_cond_value,0,strlen($update_cond_value)-2) ;
			$final_update_qry.=" update {$table_name}  set ".$update_cond_value."\n"; 
			$who_fields_update=" ,modified_by=".$_SESSION['user_id'].",modified_date=now()";
			$update_cond=substr($update_cond,0,strlen($update_cond)-4) ;
			  $final_update_through_internal_code= $final_update_qry.$who_fields_update." where internal_code={\$internal_code}";  
			  
			  $final_update_qry.=$who_fields_update." where ".$update_cond;  
			  	  
				$insert_value=substr($insert_value,0,strlen($insert_value)-1);
				$who_fields=",".$_SESSION['user_id'].",now(),".$_SESSION['user_id'].",now() ";
				$data_str.="\n }   ";
				$data_str.=" \n \$validate_ref_error_flag=0; 
						  if (function_exists('validate'))
							{
							 \$aobj_context->mobj_data['save_schema_details_arr']='';
							 \$aobj_context->mobj_data['save_schema_details_arr']=\$input_fields_arr;\n
							 \$aobj_context->mobj_data['internal_code']=\$internal_code;\n
								validate(\$aobj_context,'upload');\n
								\$valide_arr=validate(\$aobj_context,'upload');\n
							 \$validate_ref_error_flag=empty(\$valide_arr['validate_ref_error_flag'])?0:\$valide_arr['validate_ref_error_flag'];
							 \$error_msg.= \$valide_arr['error_msg'];		
							};  ";
				$data_str.="if(\$s_ref_error_flag==0 && \$validate_ref_error_flag==0) \n
					{ \n  if(\$internal_code==0 ){ \n";
				
				$data_str.="\$insert_qry=\"".$module_meta_insert_qry.$insert_value.$who_fields.")\"; \n";
 							$data_str.="\$obj_qry =  \$aobj_context->mobj_db->Execute(\$insert_qry); \n 
						
							\$mysql_error=mysql_error();
							 
								 \$last_inserted_id  = \$aobj_context->mobj_db->Insert_ID(); \n 
								 	
							if(\$mysql_error !='') \n
						{ \n
						\$pos=strpos(\$mysql_error,'Duplicate');
						if(\$pos===false) 
						 {
						  \$down_load_value.=\$original_value.\",\".\$mysql_error .\"\\n\";
						 }
						 else
						{
						\$get_update_int_code=\"select internal_code from module_{$schema_id}  where {$update_cond}\";
						 \$obj_get_update_int_code =  \$aobj_context->mobj_db->getRow(\$get_update_int_code); \n 
						 \$last_inserted_id= \$obj_get_update_int_code[internal_code];
						 \$update_qry=\" {$final_update_qry} \"; \n 
						  \$obj_qry =  \$aobj_context->mobj_db->Execute(\$update_qry); \n 
						} \n  
						} \n
						} \n
						else
						{
						// TO CHECK USER 	RIGHT PERMINSSIONS
						   \$get_created_by_id=\" select created_by from module_{$schema_id} where 
						   internal_code=\$internal_code \"; \n 
						     \$obj_get_created_by_id =  \$aobj_context->mobj_db->GetRow(\$get_created_by_id); \n 
						   \$created_by_id=  \$obj_get_created_by_id[created_by];
						   \$edit_right=getUserEditRights(\$aobj_context, \$created_by_id);
						   if( \$edit_right=='1')
						   {
						   
						 \$update_qry=\" {$final_update_through_internal_code} \"; \n 
						  \$obj_qry =  \$aobj_context->mobj_db->Execute(\$update_qry); \n 
						   \$last_inserted_id =\$internal_code;
						   }
						   else
						   {
						   	\$original_value.=\"You Dont have a right to update this record\\n\";
						\$down_load_value.=\$original_value \n;
						   }
						}
						
						\n 
						  if (function_exists('postSave'))
							{
							 
								postSave(\$aobj_context,\$last_inserted_id,\$internal_code); 
							}
						if(\$last_inserted_id >0 && !empty(\$user_details_array))
						{
						\$insert_who_fields_for_details_table=\" ,\". \$_SESSION['user_id'].\", now(),\" . \$_SESSION['user_id'].\", now()\";	
						\$delete_qry=\"delete from module_{$schema_id}_details where ref_s_module_code=\$last_inserted_id\";
						 \$obj_delete_qry =  \$aobj_context->mobj_db->Execute(\$delete_qry); \n 
						foreach(\$user_details_array as \$k=>\$v)
							{
							 
									
							\$user_insert_qry=\"{$module_user_insert_qry} 
								'{\$v[ref_s_user_schema_code]}',
								'\$last_inserted_id',
								'{\$v[ref_s_user_schema_group_code]}',
								'{\$v[ref_s_user_schema_elements_code]}',
								'{\$v[value]}',
								'{\$v[ref_ref_s_user_schema_code]}' {\$insert_who_fields_for_details_table}) \";
							 \$obj_user_insert_qry =  \$aobj_context->mobj_db->Execute(\$user_insert_qry);   \n 
							//echo \$user_insert_qry;
							}
						}
						}";
				$data_str.="			
						else
					{
					\$original_value.=\",\$error_msg\\n\";
					\$down_load_value.=\$original_value \n;
					} \n";	
					
			$data_str.=" } "; 
			$data_str.=" if(!empty(\$down_load_value)) \n
			{ \n
			header(\"Content-type:application/csv\"); \n
			header(\"Content-Disposition:attachment;filename=error_log.csv\");   \n
			echo \$header_value.\"\\n\".\$down_load_value; \n
			return; \n
			}
			
			else \n
			echo \"<script type='text/javascript'> alert('File has been uploaded.');</script>\";";
		
			$data_str.=getUserRightsString($schema_id)." ?>";
			$tmp_root_file_name=$aobj_context->main_src."/imported_files/upload_module_details_qry_".$_SESSION['user_id'].".php";
			  file_put_contents($tmp_root_file_name,$data_str);
			require_once($tmp_root_file_name);
			    unlink($tmp_root_file_name);
			 unlink($root_file_name);
			unset($_FILES);
			}
			else 
			echo "cannot move the files";exit;
		}
}
function getUserRightsString($schema_id)
{
	$edit_right_str="
	function getUserEditRights(\$aobj_context, \$created_by_id)
	{
				\$edit_right=1;
				session_start();
					\$user_type=\$_SESSION['user_type'];
					\$user_id=\$_SESSION['user_id'];
					\$user_dept=\$_SESSION['user_dept'];
					if(strtolower(\$user_type)!='admin')
					{
					\$get_rights=\"select   is_edit,is_edit_group_records,is_edit_dep_records,is_edit_all_records
							from user_rights where ref_s_sysdb_code={\$user_id}
							and module_id={$schema_id}\";
							 
						 \$obj_get_rights = \$aobj_context->mobj_db->GetRow(\$get_rights);	
						 \$own=\$obj_get_rights[is_edit];
						 \$group=\$obj_get_rights[is_edit_group_records];
						 \$dep=\$obj_get_rights[is_edit_dep_records];
						\$all=\$obj_get_rights[is_edit_all_records];
						if(strtolower(\$user_type)=='admin' || \$all=='1')
						{
						\$edit_right=1;
						}
						else if(\$own=='1' && \$dep=='0') //checks for Own Records Only
						 {
							if(\$created_by_id==\$user_id)
							\$edit_right=1;
							else \$edit_right=0;
							 \$get_own_created_by_id=\"select created_by from {\$table} 
												where internal_code in ({\$lstr_ids})\";
							 \$obj_get_own_created_by_id = \$aobj_context->mobj_db->GetRow(\$get_own_created_by_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}
									and ref_user_code={\$created_by_id}\";
								\$obj_u_dep = \$aobj_context->mobj_db->GetRow(\$get_users_of_department);	
								  if(\$obj_u_dep)
									\$edit_right=1;else \$edit_right=0;						  
						}	 
					}
	return \$edit_right;				
	}";
return $edit_right_str;
	}
	
?>

${this.title}

Code Editor : uploadmoduledetails.php