Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	9.12 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
cmailer_new.php	3.48 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
coutput_24042018.php	1.75 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
customappcontext.php	2.35 KB	-rwxr-xr-x
db_sync.php	7.54 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
display_details_in_grid.php	71.04 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.67 KB	-rwxr-xr-x
forgot_password.php	3.76 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getnumword.php	6.19 KB	-rwxr-xr-x
header.php	306 B	-rwxr-xr-x
jsmin.php	10.69 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	6.76 KB	-rwxr-xr-x
mregistry.php	2.96 KB	-rwxr-xr-x
sendLoginPassword.php	3.11 KB	-rwxr-xr-x
send_mail.php	2.88 KB	-rwxr-xr-x
system_utility.php	4.71 KB	-rwxr-xr-x

Code Editor : auto-complete.php

<?php
function getAutoCompleteEmpCodeOld($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_code = $aobj_context->mobj_data["part"];

$get_emp_code_id="select table_name,field_id1
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_code_id);

$emp_code_field=$lobj_get_emp_code_id['field_id1'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

$lstr_qry = "SELECT internal_code,{$emp_code_field} as value
from {$emp_table_name} where {$emp_code_field} like '%{$emp_code}%' ";
$lobj_rs = $aobj_context->mobj_db->GetAll($lstr_qry);
if(!empty($lobj_rs))
echo json_encode($lobj_rs);
}
function getAutoCompleteEmpCode($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_code = $aobj_context->mobj_data["q"];

$get_emp_code_id="select table_name,field_id1
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_code_id);

$emp_code_field=$lobj_get_emp_code_id['field_id1'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

$lstr_qry = "SELECT internal_code,{$emp_code_field} as value
from {$emp_table_name} where {$emp_code_field} like '%{$emp_code}%' ";
$lobj_rs = $aobj_context->mobj_db->GetAll($lstr_qry);
if(!empty($lobj_rs))
foreach ($lobj_rs as $key=>$value) {
	 {
		echo $value['value']."|".$value['value']."\n";
	}
}
}
function getAutoCompleteEmpNameold($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_name = $aobj_context->mobj_data["q"];

$get_emp_name_id="select table_name,field_id2
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_name_id);

$emp_name_field=$lobj_get_emp_code_id['field_id2'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

$lstr_qry = "SELECT internal_code,{$emp_name_field} as value
from {$emp_table_name} where {$emp_name_field} like '%{$emp_name}%' ";
 
$lobj_rs = $aobj_context->mobj_db->GetAll($lstr_qry);
if(!empty($lobj_rs))
echo json_encode($lobj_rs);
}
function getAutoCompleteEmpName($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_name = $aobj_context->mobj_data["q"];

$get_emp_name_id="select table_name,field_id2
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_name_id);

$emp_name_field=$lobj_get_emp_code_id['field_id2'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

foreach ($lobj_rs as $key=>$value) {
	 {
		echo $value['value']."|".$value['value']."\n";
	}
}

}
function showAutoCompleteEmployeeName($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_code = $aobj_context->mobj_data["emp_code"];
$get_emp_name_id="select table_name,field_id2,field_id1
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_name_id);

$emp_name_field=$lobj_get_emp_code_id['field_id2'];
$emp_code_field=$lobj_get_emp_code_id['field_id1'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

$lstr_qry = "SELECT internal_code,{$emp_name_field} as value
from {$emp_table_name} where {$emp_code_field} like '%{$emp_code}%' ";
$lobj_rs = $aobj_context->mobj_db->GetRow($lstr_qry);
if($lobj_rs)
				    {
				        $rdata = "Inserted Successfully.";
				        print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"));
				        //return $rdata;
				     }
				    else
				    {
				        $rdata = "Insertion Failed.";
				        print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"));  
						//return $rdata;			
				    }  	
}
function showAutoCompleteEmployeeCode($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$emp_name = $aobj_context->mobj_data["emp_name"];
$get_emp_name_id="select table_name,field_id2,field_id1
from module_meta_columns where module_name='Employee'";
$lobj_get_emp_code_id = $aobj_context->mobj_db->GetRow($get_emp_name_id);

$emp_name_field=$lobj_get_emp_code_id['field_id2'];
$emp_code_field=$lobj_get_emp_code_id['field_id1'];
$emp_table_name=$lobj_get_emp_code_id['table_name'];

$lstr_qry = "SELECT internal_code,{$emp_code_field} as value
from {$emp_table_name} where {$emp_name_field} like '%{$emp_name}%' ";
$lobj_rs = $aobj_context->mobj_db->GetRow($lstr_qry);
if($lobj_rs)
				    {
				        $rdata = "Inserted Successfully.";
				        print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"));
				        //return $rdata;
				     }
				    else
				    {
				        $rdata = "Insertion Failed.";
				        print_r($aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"));  
						//return $rdata;			
				    }  	
}

${this.title}

Code Editor : auto-complete.php