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

<?php
function GetReportNames($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$sql_query="select s.internal_code,module_name as report_names from s_user_schema s
                inner join s_ref_type t on t.internal_code=s.module_type
                where t.value='Reports'  order by module_name;";		
	//echo $sql_query; die();
	$lobj_rs = $aobj_context->mobj_db->GetAll($sql_query);   	
	$arr['rpt']=$lobj_rs;		
	
	include_once("getmoduledetails.php");
	$arr['links_data']= getLinks($aobj_context,"Report Setup");
    if( $lobj_rs)
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	       
}

function getParameterDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$ref_s_user_schema_code =($aobj_context->mobj_data["ref_s_user_schema_code"]);
$main_report_names =($aobj_context->mobj_data["main_report_names"]);

$get_para="select GROUP_CONCAT(replace(name,' ',''))  as ele_field_name from s_user_schema_elements
           where ref_s_user_schema_code='{$ref_s_user_schema_code}'";  
$lobj_para_rs = $aobj_context->mobj_db->GetRow($get_para);   		  
$arr['parameter']=$lobj_para_rs;
$arr['header']='';
$arr['details_html']='';
$get_header="select * from report_setup_header where report_id={$ref_s_user_schema_code} and ifnull(report_name,'') = '{$main_report_names}' ";
//echo $get_header; die();
$lobj_get_header = $aobj_context->mobj_db->GetRow($get_header);
if(!empty($lobj_get_header))
{
$report_header_code=$lobj_get_header[internal_code];
$arr['header']=$lobj_get_header;
$get_details="select * from report_setup_details where ref_report_setup_header_code={$report_header_code}
order by ifnull(col,0),internal_code";
$lobj_get_details = $aobj_context->mobj_db->GetAll($get_details);
$query_columns.="<div class='ui-widget-header ui-corner-all sub-tab-header' align='left' style='padding: 2px; font-size: 1.4em; height:15px; width:838px;'>Query Columns</div>";
$query_columns.="<table align='center' cellspacing='0' style='font-size: 1.4em;' cellpadding='0' border='0' width='100%'>";
$query_columns.="<tr colspan='16' class='ui-state-default ui-jqgrid-hdiv'>";
$query_columns.="<td align='center' style='padding:2px; width:190px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Columns</td>";
$query_columns.="<td align='center'  style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Hide</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Total</td>";
$query_columns.="<td align='center' style='padding:2px; width:120px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Picture</td>";
$query_columns.="<td align='center' style='padding:2px; width:120px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Subtotal</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Row</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Col</td>";
$query_columns.="<td align='center' style='padding:2px; width:100px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Style</td>";
$query_columns.="<td align='center'  style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>UL</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Bold</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Alignment</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Width</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Title</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Alias</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Sep.Len</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Sep.Text</td>";
$query_columns.="</tr>";
$counter=0;
$k=0;
foreach($lobj_get_details as $key=> $value)
    {
	if($k%2==0)
	$class='tbl_row';
	else
	$class='tbl_row1';

$is_hide_checked='';
	$is_total_checked='';
	$is_ul_checked='';
	$is_bold_checked='';
	$is_title_checked='';
	
	if($value[hide]==1)
	$is_hide_checked='checked';
	if($value[total]==1)
	$is_total_checked='checked';
	if($value[ul]==1)
	$is_ul_checked='checked';
	if($value[bold]==1)
	$is_bold_checked='checked';
	if($value[title]==1)
	$is_title_checked='checked';
	
	$is_selected_total1='';
	$is_selected_total2='';
	$is_selected_total3='';
	if($value[sub_total]==1)
	$is_selected_total1=" selected ";
	elseif($value[sub_total]==2)
	$is_selected_total2=" selected ";
	elseif($value[sub_total]==3)
	$is_selected_total3=" selected ";
	
	$is_selected_style1='';
	$is_selected_style2='';
	$is_selected_style3='';
	$is_selected_style4='';
	if($value[style]=='Normal')
	$is_selected_style1=" selected ";
	elseif($value[style]=='Compress')
	$is_selected_style2=" selected ";
	elseif($value[style]=='Medium')
	$is_selected_style3=" selected ";
	elseif($value[style]=='Wide')
	$is_selected_style4=" selected ";	
	
	$is_selected_alignment1='';
	$is_selected_alignment2='';
	$is_selected_alignment3='';	
	if($value[alignment]=='Left')
	$is_selected_alignment1=" selected ";
	elseif($value[alignment]=='Center')
	$is_selected_alignment2=" selected ";
	elseif($value[alignment]=='Right')
	$is_selected_alignment3=" selected ";
	
		$query_columns.="<tr>";
		$query_columns.="<td  class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='report_setup_row_column_{$counter}' style='width: 50px;'>{$value[query_columns]}</td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input {$is_hide_checked} id='report_setup_row_hide_{$counter}' value='{$value[hide]}' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input {$is_total_checked} id='report_setup_row_total_{$counter}' value='{$value[total]}' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_picture_{$counter}'value='{$value[picture]}' type='text' style='width: 60px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_sub_total_{$counter}' value='{$value[sub_total]}' style='width: 80px;'><option value='0'>Select</option><option value='1' {$is_selected_total1}>1</option><option value='2' {$is_selected_total2}>2</option><option value='3' {$is_selected_total3}>3</option></select></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_row_{$counter}' value='{$value[row]}' type='text' style='width: 26px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_col_{$counter}' value='{$value[col]}' type='text' style='width: 26px;'></td>";
	    $query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_style_{$counter}' value='{$value[style]}' style='width: 80px;'><option {$is_selected_style1}>Normal</option><option {$is_selected_style2}>Compress</option><option {$is_selected_style3}>Medium </option><option {$is_selected_style4}>Wide</option></select></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input {$is_ul_checked} id='report_setup_row_ul_{$counter}' value='{$value[ul]}' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input {$is_bold_checked} id='report_setup_row_bold_{$counter}' value='{$value[bold]}' type='checkbox' style='width: 20px;'></td>";						
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_alignment_{$counter}' value='{$value[alignment]}' style='width: 80px;'><option value='0'>Select</option><option {$is_selected_alignment1}>Left</option><option {$is_selected_alignment2}>Center</option><option {$is_selected_alignment3}>Right</option></select></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_width_{$counter}' value='{$value[width]}' type='text' style='width: 26px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input {$is_title_checked} id='report_setup_row_title_{$counter}' value='{$value[title]}' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_alias_name_{$counter}'value='{$value[alias_name]}' type='text' style='width: 50px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;' ><input  id='report_setup_row_sep_len_{$counter}'value='{$value[sep_len]}' type='text' style='width: 50px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_sep_text_{$counter}'value='{$value[sep_text]}' type='text' style='width: 50px;'></td>";
		$query_columns.="</tr>";
		$counter++;
		$k++;
      }
$query_columns.="</table>";	  
$arr['counter']=$counter;
$arr['details_html']=$query_columns;	 	
}
echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success");	
}

function GetReportSetupColumnDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$input_qry= stripslashes(trim($aobj_context->mobj_data["input_qry"]));

$lobj_input_qry = $aobj_context->mobj_db->GetRow($input_qry);

$header_row=array_keys($lobj_input_qry);

$query_columns.="<div class='ui-widget-header ui-corner-all sub-tab-header' align='left' style='padding: 2px; font-size: 1.4em; height:15px; width:838px;'>Query Columns</div>";
$query_columns.="<table align='center' cellspacing='0' style='font-size: 1.4em;' cellpadding='0' border='0' width='100%'>";
$query_columns.="<tr colspan='16' class='ui-state-default ui-jqgrid-hdiv'>";
$query_columns.="<td align='center' style='padding:2px; width:190px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Columns</td>";
$query_columns.="<td align='center'  style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Hide</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Total</td>";
$query_columns.="<td align='center' style='padding:2px; width:120px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Picture</td>";
$query_columns.="<td align='center' style='padding:2px; width:120px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Subtotal</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Row</td>";
$query_columns.="<td align='center' style='padding:2px; width:84px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Col</td>";
$query_columns.="<td align='center' style='padding:2px; width:100px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Style</td>";
$query_columns.="<td align='center'  style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>UL</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Bold</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Alignment</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Width</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Title</td>";
$query_columns.="<td align='center' style='padding:2px; width:110px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Alias</td>";
$query_columns.="<td align='center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Sep.Len</td>";
$query_columns.="<td align=' center' style='padding:2px; width:90px; border-left:px solid #C5DBEC; border-right:1px solid #C5DBEC;'>Sep.Test</td>";
$query_columns.="</tr>";
$counter=0;
$col_ctr=1;
$k=0;
foreach($header_row as $key=> $value)
  {
	if($k%2==0)
	$class='tbl_row';
	else
	$class='tbl_row1';	
	    $query_columns.="<tr>";
		$query_columns.="<td style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='report_setup_row_column_{$counter}' style='width: 50px;'>{$value}</td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_hide_{$counter}' value='' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_total_{$counter}' value='' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_picture_{$counter}' type='text' style='width: 60px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_sub_total_{$counter}' style='width: 80px;'><option value='0'>Select</option><option value='1'>1</option><option value='2'>2</option><option value='3'>3</option></select></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_row_{$counter}' value='1'  type='text' style='width: 26px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_col_{$counter}' value='{$col_ctr}' type='text' style='width: 26px;'></td>";
	    $query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_style_{$counter}' style='width: 80px;'><option>Normal</option><option>Compress</option><option>Medium</option><option>Wide</option></select></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_ul_{$counter}' value ='' type='checkbox' style='width: 20px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_bold_{$counter}' value ='' type='checkbox' style='width: 20px;'></td>";						
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><select  id='report_setup_row_alignment_{$counter}' value='' style='width: 80px;'><option value='0'>Select</option><option>Left</option><option>Center</option><option>Right</option></select></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_width_{$counter}' value='' type='text' style='width: 26px;'></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input id='report_setup_row_title_{$counter}' value='' type='checkbox' style='width: 20px;'></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_alias_name_{$counter}'value='Value' type='text' style='width: 50px;'></td>";		
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_sep_len_{$counter}'value='' type='text' style='width: 50px;'></td>";
		$query_columns.="<td  class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;'><input  id='report_setup_row_sep_text_{$counter}'value='' type='text' style='width: 50px;'></td>"; 		
		$query_columns.="</tr>";	
		$counter++;
		$col_ctr++;
		$k++;
   }   
$query_columns.="</table>";	  
$arr['counter']=$counter;
$arr['html']=$query_columns;
echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success");	  	
}

function saveReportSetupDetails($aobj_context)
{
include_once("/JSON.php"); 
$json = new Services_JSON();
$internal_code=stripslashes(trim($aobj_context->mobj_data["internal_code"]));
$report_id=stripslashes(trim($aobj_context->mobj_data["report_setup_report_names"]));
$main_report_names=trim($aobj_context->mobj_data["main_report_names"]);
$report_setup_report_title1=stripslashes(trim($aobj_context->mobj_data["report_setup_report_title1"]));
$report_setup_report_title2=stripslashes(trim($aobj_context->mobj_data["report_setup_report_title2"]));
$report_setup_report_query=stripslashes(trim($aobj_context->mobj_data["report_setup_report_query"]));
//new fileds
$report_setup_page_orientation=stripslashes(trim($aobj_context->mobj_data["report_setup_page_orientation"]));
$report_setup_print_scale=stripslashes(trim($aobj_context->mobj_data["report_setup_print_scale"]));
$report_setup_header_report_x=stripslashes(trim($aobj_context->mobj_data["report_setup_header_report_x"]));
$report_setup_header_report_y=stripslashes(trim($aobj_context->mobj_data["report_setup_header_report_y"]));
$report_setup_hide_grid_lines=stripslashes(trim($aobj_context->mobj_data["report_setup_hide_grid_lines"]));
$report_setup_freez_panes=stripslashes(trim($aobj_context->mobj_data["report_setup_freez_panes"]));
$report_setup_print_row_column_header=stripslashes(trim($aobj_context->mobj_data["report_setup_print_row_column_header"]));
$report_setup_page_sizes=stripslashes(trim($aobj_context->mobj_data["report_setup_page_sizes"]));

$lstr_param = stripslashes($aobj_context->mobj_data["report_setup_data"]);
$mobj_jsondata = $json->decode($lstr_param);
$larr_report_setup_data = get_object_vars($mobj_jsondata);

$get_int_code="select internal_code from report_setup_header where report_id='{$report_id}' and report_name = '{$main_report_names}' "; 
  
 $lobj_get_int_code = $aobj_context->mobj_db->GetRow($get_int_code); 
 $internal_code_rpt_header= $lobj_get_int_code['internal_code'];

$del_report="delete from report_setup_header where report_id='{$report_id}' and report_name = '{$main_report_names}' ";
 $lobj_del_report = $aobj_context->mobj_db->Execute($del_report); 
	
  
	$insert_report_setup_header="insert into report_setup_header(
					report_name,
					report_id,
					title_1,
					title_2,
					query,
					page_orientation,
					print_scale,
					header_report_x,
					header_report_y,
					hide_grid_lines,
					freeze_panes,
					print_row_col_header,
					page_size
					) values
					(
					\"{$main_report_names}\",
					\"{$report_id}\",
					\"{$report_setup_report_title1}\",
					\"{$report_setup_report_title2}\",			
					\"{$report_setup_report_query}\",
					 \"{$report_setup_page_orientation}\",
					 \"{$report_setup_print_scale}\",
					 \"{$report_setup_header_report_x}\",
					 \"{$report_setup_header_report_y}\",
					 \"{$report_setup_hide_grid_lines}\",
					 \"{$report_setup_freez_panes}\",
					 \"{$report_setup_print_row_column_header}\",
					 \"{$report_setup_page_sizes}\"
					)";	
  // echo 	$insert_report_setup_header; die();					
	$lobj_insert_report_setup_header = $aobj_context->mobj_db->Execute($insert_report_setup_header);
	//echo $insert_report_setup_header; die();
	$last_inserted_id  = $aobj_context->mobj_db->Insert_ID();

$del_qry="delete from report_setup_details where ref_report_setup_header_code={$internal_code_rpt_header}";

$lobj_del_qry = $aobj_context->mobj_db->Execute($del_qry);

for( $i = 0; $i < count($larr_report_setup_data); $i++ )
	{	
		$report_setup_row_sep_len=empty($larr_report_setup_data[$i]->report_setup_row_sep_len)?0:$larr_report_setup_data[$i]->report_setup_row_sep_len;	
		$report_setup_row_width=empty($larr_report_setup_data[$i]->report_setup_row_width)?10:$larr_report_setup_data[$i]->report_setup_row_width;	
		
		$insert_report_setup_details="insert into report_setup_details(
					ref_report_setup_header_code,
					query_columns,
					hide,
					total,
					picture,
					sub_total,
					row,
					col,
					style,
					ul,
					bold,alignment,width,
					title,alias_name, 
					sep_len,sep_text)
					values
					(
					{$last_inserted_id},			
					'{$larr_report_setup_data[$i]->report_setup_row_column}',
					'{$larr_report_setup_data[$i]->report_setup_row_hide}',
					'{$larr_report_setup_data[$i]->report_setup_row_total}',
					'{$larr_report_setup_data[$i]->report_setup_row_picture}',
					'{$larr_report_setup_data[$i]->report_setup_row_sub_total}',
					'{$larr_report_setup_data[$i]->report_setup_row_row}',
					'{$larr_report_setup_data[$i]->report_setup_row_col}',
					'{$larr_report_setup_data[$i]->report_setup_row_style}',
					'{$larr_report_setup_data[$i]->report_setup_row_ul}',
					'{$larr_report_setup_data[$i]->report_setup_row_bold}', 
					'{$larr_report_setup_data[$i]->report_setup_row_alignment}', 
					'{$report_setup_row_width}', 
					'{$larr_report_setup_data[$i]->report_setup_row_title}', 
					'{$larr_report_setup_data[$i]->report_setup_row_alias_name}', 
					'{$report_setup_row_sep_len}', 
					'{$larr_report_setup_data[$i]->report_setup_row_sep_text}'
					)";					
	      
	  $lobj_insert_report_setup_details = $aobj_context->mobj_db->Execute($insert_report_setup_details);
 
	   }
	
	            if($lobj_insert_report_setup_header)
				    {
				        $rdata = "Report Setup Details 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;			
				    }    			
       }			           	  		
	   
	//popup reportsetup
 function  showGridForReportSetup($aobj_context)
 { 
    $json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	$report_id = $_GET['report_id'];
	//echo $report_id ; die();
	if(!$sidx) 
	$sidx =1; 
	$search =$aobj_context->mobj_data["_search"];

$filter_toolbal_cond="";
	if($search)
	{
	 
	$grid_report_name=$aobj_context->mobj_data["grid_report_name"];	
	
	if(isset($grid_report_name) && !empty($grid_report_name))
		$filter_toolbal_cond.=" and grid_report_name like '{$grid_report_name}%'"; 
	} 
	 	
	if($search)
	{		
		$count_id="select count(*) as count  from 
		(select internal_code as id, report_name as grid_report_name
			from report_setup_header where report_id={$report_id})a 
			where 1=1  {$filter_toolbal_cond}";
		
	}
	else
	{
	$count_id="select count(*) as count from
			  report_setup_header";
	}	
			$result = mysql_query($count_id);
			$row = mysql_fetch_array($result,MYSQL_ASSOC);
			$count = $row['count'];
 
 // calculation of total pages for the query 
	if( $count >0 ) 
	{ 
		$total_pages = ceil($count/$limit); 
	} 
	else 
	{ 
		$total_pages = 0; 
	} 
	if ($page > $total_pages) 
	$page=$total_pages; 
	$start = $limit*$page - $limit; 
	
	if($start <0) 
	$start = 0; 
	// the actual query for the grid data 
	if($search)
	{
			
		$SQL="select * from (select internal_code as id, report_name as grid_report_name
			from report_setup_header where report_id={$report_id} )a 
			where  1=1  {$filter_toolbal_cond}
			ORDER BY $sidx $sord LIMIT $start,$limit";
	  
			
	}
	else
	{
	$SQL = "select internal_code as id, report_name as grid_report_name
			from report_setup_header where report_id='{$report_id}'	        			
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
			//echo $SQL;  die();	
	}
	//echo $SQL;
		$result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count;

$i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ $responce->rows[$i]['id']=$row[id]; //id
	$responce->rows[$i]['cell']=array($row[grid_report_name]); 
	$i++; 
	} 
	echo json_encode($responce);

}	
 
 function getReportSetupValue($aobj_context) 
 {
 $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
 $ref_report_id=$aobj_context->mobj_data["internal_code"];
 
 $get_report_name="select internal_code, report_name as value
			       from report_setup_header  where internal_code='{$ref_report_id}'";
				 
 $lobj_get_report_name = $aobj_context->mobj_db->GetRow($get_report_name); 
 $arr['rpt_setup']=$lobj_get_report_name;
 
	if($lobj_get_report_name)	
	  print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success")); 
	 else
	  print_r($aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"));
	return;

}
	   
?>

${this.title}

Code Editor : report_setup.php