Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxrwxrwx
.src_16042016.php	3.61 KB	-rw-r--r--
Dispatch_ans_script_setup.php	5.83 KB	-rwxrwxrwx
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxrwxrwx
Dispatch_ans_script_setup_qp_o...	5.18 KB	-rwxrwxrwx
FormulaEvaluate.php	14.15 KB	-rwxrwxrwx
MarkEntry-Setup.php	21.91 KB	-rwxrwxrwx
MarkEntry-SetupTEST.php	21.01 KB	-rwxrwxrwx
MarkEntry-Setup_TU.php	22.99 KB	-rwxrwxrwx
TAGMAY2013.pdf	331.03 KB	-rwxrwxrwx
TarkaFormatStyles.php	15.37 KB	-rwxrwxrwx
TarkaFormatStyles_old.php	3.71 KB	-rwxrwxrwx
absent_entry_setup.php	8.13 KB	-rwxrwxrwx
absent_entry_setupQp.php	6.93 KB	-rwxrwxrwx
absent_entry_setup_old.php	7.61 KB	-rwxrwxrwx
ack_exam_app_form.php	8.96 KB	-rwxrwxrwx
ack_rv_rt_application.php	7.42 KB	-rwxrwxrwx
actClass.php	6.21 KB	-rwxrwxrwx
admission_entry_status.php	2.73 KB	-rwxrwxrwx
attendance.php	6.14 KB	-rwxrwxrwx
auto-complete.php	4.89 KB	-rwxrwxrwx
backup_restore.php	8.14 KB	-rwxrwxrwx
backupandrestore.php	10.18 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate-entry.php	36.06 KB	-rwxrwxrwx
candidate-entry24082012.php	33.21 KB	-rwxrwxrwx
candidate-entry_220413.php	33.21 KB	-rwxrwxrwx
candidate-entry_without_iapr_i...	34.88 KB	-rwxrwxrwx
candidate-entrybefore yearexam...	34.55 KB	-rwxrwxrwx
candidate-entrykus.php	33.23 KB	-rwxrwxrwx
candidate-entryold.php	34.55 KB	-rwxrwxrwx
cappcontext.php	2.64 KB	-rwxrwxrwx
challan_entries.php	13.38 KB	-rwxrwxrwx
challan_preparation.php	10.28 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
college.php	4.61 KB	-rwxrwxrwx
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxrwxrwx
college_degree_status.php	5.86 KB	-rwxrwxrwx
coutput.php	1.75 KB	-rwxrwxrwx
create_all_grid_files.php	8.57 KB	-rwxrwxrwx
create_all_grid_group_files.ph...	9.94 KB	-rwxrwxrwx
create_all_grid_group_files_ol...	9.61 KB	-rwxrwxrwx
create_all_popup_files.php	5.93 KB	-rwxrwxrwx
create_all_schema_files.php	4.31 KB	-rwxrwxrwx
create_all_views.php	16.52 KB	-rwxrwxrwx
create_html_files.php	52.03 KB	-rwxrwxrwx
create_html_files_without_tab....	44.49 KB	-rwxrwxrwx
create_module_meta_columns.php	5.16 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
custom_mregistry.php	122 B	-rwxrwxrwx
datadictionary.php	3.96 KB	-rwxrwxrwx
degree.php	6.77 KB	-rwxrwxrwx
display_details_in_grid.php	97.18 KB	-rwxrwxrwx
display_details_in_grid_090120...	97.19 KB	-rwxrwxrwx
display_details_in_grid_custom...	2.68 KB	-rwxrwxrwx
display_details_in_grid_studta...	96.56 KB	-rwxrwxrwx
display_details_in_grid_withde...	97.45 KB	-rwxrwxrwx
download_misc_files.php	3.3 KB	-rwxrwxrwx
download_upload.php	3.86 KB	-rwxrwxrwx
dynamicmastersdetails.php	117.45 KB	-rwxrwxrwx
dynamicmastersdetails_23.php	119.99 KB	-rwxrwxrwx
dynamicmastersdetails_one.php	119.35 KB	-rwxrwxrwx
entryexitevents.php	3.09 KB	-rwxrwxrwx
execute_query.php	2.5 KB	-rwxrwxrwx
execute_query27062012.php	2.51 KB	-rwxrwxrwx
export_import_setup.php	7.62 KB	-rwxrwxrwx
export_import_utility.php	2.67 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
freeze_Ad_Cl_Me.php	6.64 KB	-rwxrwxrwx
freeze_module_at_admin_college...	5.9 KB	-rwxrwxrwx
freeze_module_at_university_co...	7.45 KB	-rwxrwxrwx
general_report_format.php	11 KB	-rwxrwxrwx
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxrwxrwx
getdata.php	22.91 KB	-rwxrwxrwx
getdata110911.php	16.03 KB	-rwxrwxrwx
getdata27062012.php	16.8 KB	-rwxrwxrwx
getmoduledetails.php	23.7 KB	-rwxrwxrwx
getnumword.php	7.42 KB	-rwxrwxrwx
getreportdetails.php	3.21 KB	-rwxrwxrwx
getreportfilefordisplay.php	1.37 KB	-rwxrwxrwx
getsearchcondition.php	1.3 KB	-rwxrwxrwx
ggridmodel.php	9.27 KB	-rwxrwxrwx
golden_palm_payslip.php	12.48 KB	-rwxrwxrwx
helptext.php	5.38 KB	-rwxrwxrwx
identify_transactions.php	6.78 KB	-rwxrwxrwx
import_marks.php	4.1 KB	-rwxrwxrwx
json.php	33.22 KB	-rwxrwxrwx
login.php	10.92 KB	-rwxrwxrwx
login.php_1	3.25 KB	-rwxrwxrwx
login27062012.php	2.85 KB	-rwxrwxrwx
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxrwxrwx
login_old.php	3.15 KB	-rwxrwxrwx
message_board.php	4.67 KB	-rwxrwxrwx
module_setup.php	2.48 KB	-rwxrwxrwx
mregistry.php	55.11 KB	-rwxrwxrwx
mregistry_oldtype.php	45.87 KB	-rwxrwxrwx
mrn_approval.php	9 KB	-rwxrwxrwx
receive_rv_rt_application.php	8.08 KB	-rwxrwxrwx
report_marksentry.php	8.83 KB	-rwxrwxrwx
report_setup.php	25.12 KB	-rwxrwxrwx
report_tool.php	73.03 KB	-rwxrwxrwx
revaluation.php	8.45 KB	-rwxrwxrwx
revaluation_oldtype.php	8.45 KB	-rwxrwxrwx
revaluation_withdegree.php	16.77 KB	-rwxrwxrwx
room_allotment.php	7.04 KB	-rwxrwxrwx
sendLoginPassword.php	3.09 KB	-rwxrwxrwx
serchbygrid.php	822 B	-rwxrwxrwx
student_entry.php	35.19 KB	-rwxrwxrwx
student_entry1307.php	37.71 KB	-rwxrwxrwx
student_entry27062012.php	30.47 KB	-rwxrwxrwx
student_entryold.php	30.33 KB	-rwxrwxrwx
subjectList_display.php	10.93 KB	-rwxrwxrwx
subject_freshExam-old.php	21.05 KB	-rwxrwxrwx
subject_freshExam.php	19.36 KB	-rwxrwxrwx
system_utility.php	1.84 KB	-rwxrwxrwx
systemsetup.php	77.01 KB	-rwxrwxrwx
teachers.php	12.88 KB	-rwxrwxrwx
transaction-series.php	4.86 KB	-rwxrwxrwx
updateSection.php	3.79 KB	-rwxrwxrwx
update_defined_flag.php	3.41 KB	-rwxrwxrwx
upload_studentPhoto.php	11.58 KB	-rwxrwxrwx
uploadmoduledetails.php	39.65 KB	-rwxrwxrwx
usersetup.php	25.33 KB	-rwxrwxrwx
usersubj_identification.php	4.49 KB	-rwxrwxrwx
usersubj_identification_090120...	4.53 KB	-rwxrwxrwx

Name

Size

Permission

Action

system

[ DIR ]

drwxrwxrwx

.src_16042016.php

3.61 KB

-rw-r--r--

Dispatch_ans_script_setup.php

5.83 KB

-rwxrwxrwx

Dispatch_ans_script_setup_qp.p...

5.18 KB

-rwxrwxrwx

Dispatch_ans_script_setup_qp_o...

5.18 KB

-rwxrwxrwx

FormulaEvaluate.php

14.15 KB

-rwxrwxrwx

MarkEntry-Setup.php

21.91 KB

-rwxrwxrwx

MarkEntry-SetupTEST.php

21.01 KB

-rwxrwxrwx

MarkEntry-Setup_TU.php

22.99 KB

-rwxrwxrwx

TAGMAY2013.pdf

331.03 KB

-rwxrwxrwx

TarkaFormatStyles.php

15.37 KB

-rwxrwxrwx

TarkaFormatStyles_old.php

3.71 KB

-rwxrwxrwx

absent_entry_setup.php

8.13 KB

-rwxrwxrwx

absent_entry_setupQp.php

6.93 KB

-rwxrwxrwx

absent_entry_setup_old.php

7.61 KB

-rwxrwxrwx

ack_exam_app_form.php

8.96 KB

-rwxrwxrwx

ack_rv_rt_application.php

7.42 KB

-rwxrwxrwx

actClass.php

6.21 KB

-rwxrwxrwx

admission_entry_status.php

2.73 KB

-rwxrwxrwx

attendance.php

6.14 KB

-rwxrwxrwx

auto-complete.php

4.89 KB

-rwxrwxrwx

backup_restore.php

8.14 KB

-rwxrwxrwx

backupandrestore.php

10.18 KB

-rwxrwxrwx

cManualMailer.php

1.52 KB

-rwxrwxrwx

caccesscontext.php

1.24 KB

-rwxrwxrwx

candidate-entry.php

36.06 KB

-rwxrwxrwx

candidate-entry24082012.php

33.21 KB

-rwxrwxrwx

candidate-entry_220413.php

33.21 KB

-rwxrwxrwx

candidate-entry_without_iapr_i...

34.88 KB

-rwxrwxrwx

candidate-entrybefore yearexam...

34.55 KB

-rwxrwxrwx

candidate-entrykus.php

33.23 KB

-rwxrwxrwx

candidate-entryold.php

34.55 KB

-rwxrwxrwx

cappcontext.php

2.64 KB

-rwxrwxrwx

challan_entries.php

13.38 KB

-rwxrwxrwx

challan_preparation.php

10.28 KB

-rwxrwxrwx

cmailer.php

6.83 KB

-rwxrwxrwx

college.php

4.61 KB

-rwxrwxrwx

college_BEFORE_LOGINPOPUP.php

3.5 KB

-rwxrwxrwx

college_degree_status.php

5.86 KB

-rwxrwxrwx

coutput.php

1.75 KB

-rwxrwxrwx

create_all_grid_files.php

8.57 KB

-rwxrwxrwx

create_all_grid_group_files.ph...

9.94 KB

-rwxrwxrwx

create_all_grid_group_files_ol...

9.61 KB

-rwxrwxrwx

create_all_popup_files.php

5.93 KB

-rwxrwxrwx

create_all_schema_files.php

4.31 KB

-rwxrwxrwx

create_all_views.php

16.52 KB

-rwxrwxrwx

create_html_files.php

52.03 KB

-rwxrwxrwx

create_html_files_without_tab....

44.49 KB

-rwxrwxrwx

create_module_meta_columns.php

5.16 KB

-rwxrwxrwx

crequestbroker.php

2.49 KB

-rwxrwxrwx

csessions.php

514 B

-rwxrwxrwx

cuser.php

3.41 KB

-rwxrwxrwx

custom_mregistry.php

122 B

-rwxrwxrwx

datadictionary.php

3.96 KB

-rwxrwxrwx

degree.php

6.77 KB

-rwxrwxrwx

display_details_in_grid.php

97.18 KB

-rwxrwxrwx

display_details_in_grid_090120...

97.19 KB

-rwxrwxrwx

display_details_in_grid_custom...

2.68 KB

-rwxrwxrwx

display_details_in_grid_studta...

96.56 KB

-rwxrwxrwx

display_details_in_grid_withde...

97.45 KB

-rwxrwxrwx

download_misc_files.php

3.3 KB

-rwxrwxrwx

download_upload.php

3.86 KB

-rwxrwxrwx

dynamicmastersdetails.php

117.45 KB

-rwxrwxrwx

dynamicmastersdetails_23.php

119.99 KB

-rwxrwxrwx

dynamicmastersdetails_one.php

119.35 KB

-rwxrwxrwx

entryexitevents.php

3.09 KB

-rwxrwxrwx

execute_query.php

2.5 KB

-rwxrwxrwx

execute_query27062012.php

2.51 KB

-rwxrwxrwx

export_import_setup.php

7.62 KB

-rwxrwxrwx

export_import_utility.php

2.67 KB

-rwxrwxrwx

format.php

7.43 KB

-rwxrwxrwx

freeze_Ad_Cl_Me.php

6.64 KB

-rwxrwxrwx

freeze_module_at_admin_college...

5.9 KB

-rwxrwxrwx

freeze_module_at_university_co...

7.45 KB

-rwxrwxrwx

general_report_format.php

11 KB

-rwxrwxrwx

getAutoCompleteFromFrameWork.p...

2.97 KB

-rwxrwxrwx

getdata.php

22.91 KB

-rwxrwxrwx

getdata110911.php

16.03 KB

-rwxrwxrwx

getdata27062012.php

16.8 KB

-rwxrwxrwx

getmoduledetails.php

23.7 KB

-rwxrwxrwx

getnumword.php

7.42 KB

-rwxrwxrwx

getreportdetails.php

3.21 KB

-rwxrwxrwx

getreportfilefordisplay.php

1.37 KB

-rwxrwxrwx

getsearchcondition.php

1.3 KB

-rwxrwxrwx

ggridmodel.php

9.27 KB

-rwxrwxrwx

golden_palm_payslip.php

12.48 KB

-rwxrwxrwx

helptext.php

5.38 KB

-rwxrwxrwx

identify_transactions.php

6.78 KB

-rwxrwxrwx

import_marks.php

4.1 KB

-rwxrwxrwx

json.php

33.22 KB

-rwxrwxrwx

10.92 KB

-rwxrwxrwx

3.25 KB

-rwxrwxrwx

login27062012.php

2.85 KB

-rwxrwxrwx

login_BEFORE_LOGINPOPUP.php

3.25 KB

-rwxrwxrwx

login_old.php

3.15 KB

-rwxrwxrwx

message_board.php

4.67 KB

-rwxrwxrwx

module_setup.php

2.48 KB

-rwxrwxrwx

mregistry.php

55.11 KB

-rwxrwxrwx

mregistry_oldtype.php

45.87 KB

-rwxrwxrwx

mrn_approval.php

9 KB

-rwxrwxrwx

receive_rv_rt_application.php

8.08 KB

-rwxrwxrwx

report_marksentry.php

8.83 KB

-rwxrwxrwx

report_setup.php

25.12 KB

-rwxrwxrwx

report_tool.php

73.03 KB

-rwxrwxrwx

revaluation.php

8.45 KB

-rwxrwxrwx

revaluation_oldtype.php

8.45 KB

-rwxrwxrwx

revaluation_withdegree.php

16.77 KB

-rwxrwxrwx

room_allotment.php

7.04 KB

-rwxrwxrwx

sendLoginPassword.php

3.09 KB

-rwxrwxrwx

serchbygrid.php

822 B

-rwxrwxrwx

student_entry.php

35.19 KB

-rwxrwxrwx

student_entry1307.php

37.71 KB

-rwxrwxrwx

student_entry27062012.php

30.47 KB

-rwxrwxrwx

student_entryold.php

30.33 KB

-rwxrwxrwx

subjectList_display.php

10.93 KB

-rwxrwxrwx

subject_freshExam-old.php

21.05 KB

-rwxrwxrwx

subject_freshExam.php

19.36 KB

-rwxrwxrwx

system_utility.php

1.84 KB

-rwxrwxrwx

systemsetup.php

77.01 KB

-rwxrwxrwx

teachers.php

12.88 KB

-rwxrwxrwx

transaction-series.php

4.86 KB

-rwxrwxrwx

updateSection.php

3.79 KB

-rwxrwxrwx

update_defined_flag.php

3.41 KB

-rwxrwxrwx

upload_studentPhoto.php

11.58 KB

-rwxrwxrwx

uploadmoduledetails.php

39.65 KB

-rwxrwxrwx

usersetup.php

25.33 KB

-rwxrwxrwx

usersubj_identification.php

4.49 KB

-rwxrwxrwx

usersubj_identification_090120...

4.53 KB

-rwxrwxrwx

Code Editor : entryexitevents.php

<?php
function leaveEntryExitNoOfDays($aobj_context)
{
	require("excludeweekdays.php");	
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$from_date = $aobj_context->mobj_data["from_date"];
	$to_date = $aobj_context->mobj_data["to_date"];

$days= date_difference($aobj_context,$from_date,$to_date);
	
	$get_ids="select  (suse.internal_code)  as ids from s_user_schema_elements suse
	inner join s_user_schema s on s.internal_code=ref_s_user_schema_code
	where module_name='Leave Entry' and suse.name='No Of Days'";
	$lobj_get_ids = $aobj_context->mobj_db->GetRow($get_ids);
	if($from_date !='undefined-undefined-')
{
	$arr[days]=$days;
	$arr[ids]=$lobj_get_ids[ids];
	 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
}	
else
{
$arr[days]=0;
	$arr[ids]=$lobj_get_ids[ids];
	 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
} 
	
	
}
function leaveEntryExitBalanceLeaves($aobj_context)
{
	 
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$emp_code = $aobj_context->mobj_data["emp_code"];
	$leave_type = $aobj_context->mobj_data["leave_type"];
 
	 
	if($emp_code>0 && $leave_type>0)
	{
	$get_ids="select   concat('module_',ref_s_user_schema_code) as table_name,(suse.internal_code)  as ids,
			name,db_field from s_user_schema_elements suse
			inner join s_user_schema s on s.internal_code=ref_s_user_schema_code
			where module_name='Employee Leave Balance' ";
	$lobj_get_ids = $aobj_context->mobj_db->GetAll($get_ids);
	 
	foreach($lobj_get_ids as $key=>$val)
		{
		if($val[name]=='Employee Code')
		$ref_emp_code=$val[db_field];
		else if($val[name]=='Leave Type')
		$ref_leave_type=$val[db_field];
		else if($val[name]=='Opening Balance')
		$opeing_balance=$val[db_field];
		else if($val[name]=='Closing Balance')
		$closing_balance=$val[db_field];
		else if($val[name]=='Financial Year')
		$fin_year=$val[db_field];
		$table_name=$val[table_name];
		}
		
		$get_balance_leaves="select 
			{$ref_emp_code} as ref_emp_code,
			{$ref_leave_type} as ref_leave_type,
			{$opeing_balance} as opeing_balance,
			{$closing_balance} as closing_balance,
			SUBSTRING({$fin_year} ,7,4) as st_year,
			SUBSTRING({$fin_year} ,18,4) as end_year FROM
			{$table_name} where 
			{$ref_leave_type}={$leave_type} and 
			{$ref_emp_code}={$emp_code} and YEAR(CURRENT_DATE) BETWEEN SUBSTRING({$fin_year} ,7,4)  AND SUBSTRING({$fin_year} ,18,4)";
			
		$obj_get_balance_leaves = $aobj_context->mobj_db->GetRow($get_balance_leaves);
 
	$get_html_field_id="select  (suse.internal_code)  as ids from s_user_schema_elements suse
	inner join s_user_schema s on s.internal_code=ref_s_user_schema_code
	where module_name='Leave Entry' and suse.name='Balance Leaves'";
	$get_html_field_id = $aobj_context->mobj_db->GetRow($get_html_field_id);
	
		if(!empty($obj_get_balance_leaves))
		{
			$arr[days]=$obj_get_balance_leaves[closing_balance];
			$arr[ids]=$get_html_field_id[ids];
			 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		}	
		else
		{
		$arr[days]=0;
			$arr[ids]= $get_html_field_id[ids];
			 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		} 
		 
	}
	
 
	
	
}

${this.title}

Code Editor : entryexitevents.php