Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
OnloadModule.js	603 B	-rwxr-xr-x
PasswordPopup.js	1019 B	-rwxr-xr-x
PreMultipleSaveValidation.js	284 B	-rwxr-xr-x
PreSaveModuleValidation.js	331 B	-rwxr-xr-x
batch_close.js	6.91 KB	-rwxr-xr-x
batch_setup.js	8.76 KB	-rwxr-xr-x
dash_board.js	593 B	-rwxr-xr-x
deviation_report.js	986 B	-rwxr-xr-x
download_upload_mannual.js	1.89 KB	-rwxr-xr-x
evaluation.js	15.24 KB	-rwxr-xr-x
evaluationreport.js	680 B	-rwxr-xr-x
freeze_marks.js	2.88 KB	-rwxr-xr-x
gandhiGridValidation.js	280 B	-rwxr-xr-x
include_js.js	3 B	-rwxr-xr-x
marks_deviation_report.js	1023 B	-rwxr-xr-x
month_year.js	1.48 KB	-rwxr-xr-x
postSaveSchemaGroupDetails.js	252 B	-rwxr-xr-x
practical_entry_freezing.js	12.25 KB	-rwxr-xr-x
practical_entry_freezing_new.j...	12 KB	-rwxr-xr-x
practical_marks.js	8.92 KB	-rwxr-xr-x
practical_marks_mis.js	15.57 KB	-rwxr-xr-x
practical_report_popups.js	3.38 KB	-rwxr-xr-x
preCustomGridEditValidation.js	342 B	-rwxr-xr-x
report_setup.js	19.93 KB	-rwxr-xr-x
report_setup_popup.js	4.43 KB	-rwxr-xr-x
revaluation_report.js	473 B	-rwxr-xr-x
user_report.js	5.05 KB	-rwxr-xr-x

Code Editor : report_setup.js

function CallReportSetup() 
{
	$geditinternalcode=0;
	window.enable_proper_module="CallReportSetup";
	$schema_id='';	
	$('#page_main_div').load("html_modules/pay_report_setup.html",function () {
	document.getElementById('display_module_name').innerHTML = 'Report Setup';
	document.getElementById('module_name_for_save').value = 'reportsetup'; 			
	$greport_setup_emp_names_arr="";
	getenableCriteriaFromDb("");
	getReportEmpDetailsCriteria("")
	getenableEmpFieldsFromDb(0);
	getenableSalFieldsFromDb(0);
	getReportEnableSummaryFields(0);
	enableConditions();
	getReportEnableConditions();
	getDefaultHeadFooterLinks('Report Setup');	  
	});	
 }

$lstr_data="internal_code="+$geditinternalcode;
	$lstr_data+="&report_name="+trim($("#report_setup_report_name").val());
	$lstr_data+="&report_freeze_cells="+trim($("#report_freeze_cells").val());
	$lstr_data+="&from_date="+ date_format($("#report_setup_start_date").val());
	$lstr_data+="&to_date="+ date_format($("#report_setup_end_date").val());
	$lstr_data+="&report_setup_cross_tab="+$report_setup_cross_tab;
	$lstr_data+="&report_setup_col_total="+$report_setup_col_total;
	$lstr_data+="&report_setup_row_total="+$report_setup_row_total;
	$lstr_data+="&report_setup_sub_total="+$report_setup_sub_total;
	$lstr_data+="&report_setup_sub_field="+$report_setup_sub_field;
	$lstr_data+="&report_setup_sl_no="+$report_setup_sl_no;
	$.ajax({
			type: "POST",
			//async:false,
			url: $host_url+"saveSalarySetupReportHeader",   
			data:$lstr_data,	
			success:saveSalarySetupReportHeaderResponse
	});
}	
function saveSalarySetupReportHeaderResponse($responce)
 {                                                
    $responce = eval('(' + $responce + ')'); 
	if($responce.error_code==0)
	{
	$last_insert_id=$responce.data.last_insert_id;
	 
	$report_emp_details = new Object();
	$report_sal_details = new Object();
	$report_summary_details = new Object();
	$report_condition_details = new Object();
 
	for($i=0;$i<$g_report_emp_field_data.length;$i++)
	{	
		$emp_field_id=$g_report_emp_field_data[$i].internal_code;
		$report_emp_details[$i]= new Object();
		$report_emp_details[$i]['emp_field_id']=$emp_field_id;
		$report_emp_details[$i]['emp_col_seq']=$("#report_emp_col_seq_"+$emp_field_id).val();
		
		$report_emp_details[$i]['emp_field_name']=$("#report_emp_col_name_"+$emp_field_id).html();
		
		if(document.getElementById('report_emp_select_'+$emp_field_id).checked==true)
			$report_emp_details[$i]['emp_select']='1';
		else $report_emp_details[$i]['emp_select']='0';
		
		if(document.getElementById('report_emp_group_by_'+$emp_field_id).checked==true)
			$report_emp_details[$i]['emp_group_by']='1';
		else $report_emp_details[$i]['emp_group_by']='0'; 
		
		if(document.getElementById('report_emp_order_by_'+$emp_field_id).checked==true)
			$report_emp_details[$i]['emp_order_by']='1';
		else $report_emp_details[$i]['emp_order_by']='0'; 
		
		if(document.getElementById('report_emp_order_type_asc_'+$emp_field_id).checked==true)
			$report_emp_details[$i]['emp_order_type']='asc';
		else $report_emp_details[$i]['emp_order_type']='desc'; 
		
		$report_emp_details[$i]['emp_order_col_seq']=$("#report_emp_order_seq_"+$emp_field_id).val();
	}
	
	for($i=0;$i<$g_report_sal_field_data.length;$i++)
	{	
		$report_sal_details[$i]= new Object();
		$sal_field_id=$g_report_sal_field_data[$i].internal_code;
		$report_sal_details[$i]['sal_field_id']=$sal_field_id;
		$report_sal_details[$i]['sal_col_seq']=$("#report_sal_col_seq_"+$sal_field_id).val();
		
		$report_sal_details[$i]['sal_field_name']=$("#report_sal_col_name_"+$sal_field_id).html();
		
		if(document.getElementById('report_sal_select_'+$sal_field_id).checked==true)
			$report_sal_details[$i]['sal_select']='1';
		else $report_sal_details[$i]['sal_select']='0';
		
		if(document.getElementById('report_sal_order_by_'+$sal_field_id).checked==true)
			$report_sal_details[$i]['sal_order_by']='1';
		else $report_sal_details[$i]['sal_order_by']='0'; 
		
		if(document.getElementById('report_sal_order_type_asc_'+$sal_field_id).checked==true)
			$report_sal_details[$i]['sal_order_type']='asc';
		else $report_sal_details[$i]['sal_order_type']='desc'; 
		
		$report_sal_details[$i]['sal_order_col_seq']=$("#report_sal_order_seq_"+$sal_field_id).val();
		$report_sal_details[$i]['sal_sum_into']=trim($("#report_sal_sum_into_"+$sal_field_id).val());
	}
	for($i=0;$i<$g_report_summary_field_data.length;$i++)
	{	
		$summary_field_id=$g_report_summary_field_data[$i].internal_code;
		$report_summary_details[$i]= new Object();
		$report_summary_details[$i]['summary_field_id']=$summary_field_id;
		$report_summary_details[$i]['summary_col_seq']=$("#report_summary_col_seq_"+$summary_field_id).val();
		
		$report_summary_details[$i]['summary_field_name']=$("#report_summary_col_name_"+$summary_field_id).html();
		
		if(document.getElementById('report_summary_select_'+$summary_field_id).checked==true)
			$report_summary_details[$i]['summary_select']='1';
		else $report_summary_details[$i]['summary_select']='0';
	}
	 var tbl = document.getElementById('mySampleTable');
  // grab how many rows are in the table
	var row_counter =(tbl.rows.length)-1;
	$m=0;
	for($i=1;$i<=row_counter;$i++)
	{	
		if(trim($("#txtbox_"+row_counter).val())!='')
		{
		$report_condition_details[$m]= new Object();
		$report_condition_details[$m]['ele_id']=$("#emp_field_"+$i).val();
		$report_condition_details[$m]['operator']=$("#oper_"+$i).val();
		$report_condition_details[$m]['value']=trim($("#txtbox_"+$i).val());
		$report_condition_details[$m]['and_or']=trim($("#and_or_"+$i).val());
		$m++;
		}
	}
	
	var myJSONEmpText = encodeURIComponent(JSON.stringify($report_emp_details));  
	var myJSONSalText = encodeURIComponent(JSON.stringify($report_sal_details));  
	var myJSONSummaryText = encodeURIComponent(JSON.stringify($report_summary_details));  
	var myJSONConditionText = encodeURIComponent(JSON.stringify($report_condition_details));  
	 //console.log(myJSONConditionText);
	 
	$lstr_data_details="report_id="+$last_insert_id+"&emp_details="+myJSONEmpText+"&sal_details="+myJSONSalText+"&summary_details="+myJSONSummaryText+"&report_conditions="+myJSONConditionText;
     $.ajax({
		type: "POST",
		//async:false,
		url: $host_url+"saveReportSetupResult",   
		data:$lstr_data_details,	
		success:saveReportSetupResultresponse
	});  
	}
	else
	{
	alert($responce.data);
	}
}
function saveReportSetupResultresponse($responce)
{                                                
    $responce = eval('(' + $responce + ')'); 
	alert($responce.data);
}
function ClearSalaryReport()
{
	$("#report_setu_report_name").val('');
	$("#report_setup_start_date").val('');
	$("#report_setup_end_date").val('');
	ReportSetup(); 
}
function displayReportsSetup()
{
$geditinternalcode=0;

$main="<table id='table_grid' class='scroll' ondblclick='getreportsSetupDetails(id);'></table> <div id='sub_grid_div' class='scroll' style='text-align:center;'></div>";
document.getElementById('page_main_div').innerHTML=$main;
var report_setup=jQuery("#table_grid").jqGrid(
	{
	url:$host_url+'displayReportsSetup',
	datatype: "json",
	colNames:['Report Names'],
	colModel:[
	{name:'report_name',index:'report_name', width:115 }],
	rowNum:10,
	rowList:[5,10,15,20,25,30],
	imgpath:$img_path,
	pager: jQuery('#sub_grid_div'),
	sortname: 'id',
	height:'70%',
	viewrecords: true,
	sortorder: "desc",
	multiselect: false,
	cellEdit: true,
	width:'850',
	caption:"Module Details",
	editurl:$host_url+'deletereportSetup'
	
	}).navGrid('#sub_grid_div',{edit:false,add:false,del:true,search:true},{},{},{},{multipleSearch:true})
				.navButtonAdd('#sub_grid_div',{caption:"Toggle",
				buttonicon :'ui-icon-pin-s', onClickButton:function(){ report_setup[0].toggleToolbar() } }).
		navButtonAdd('#sub_grid_div',{caption:"Edit", 
		onClickButton:function()
		{
		getreportsSetupDetails(id);
		}	     
		}); 
	report_setup.filterToolbar(); 		
  }
  
 function getreportsSetupDetails(id)
  { 
  var id=jQuery("#table_grid").getGridParam('selrow'); 
	if(id > 0) 
	{ 	
		CallReportSetup();
		getenableEmpFieldsFromDb(id);
		getenableSalFieldsFromDb(id);
		getReportEnableSummaryFields(id);
		enableConditions();		
		
		$.ajax({
			type: "POST",
			async:false,
			url: $host_url+"getReportSetupName",   
			data:'internal_code='+id,	
			success:getReportSetupNameresponse
		}); 
		$geditinternalcode=id;		
     }    
	else
	{ 
		alert("Please select row");  
	} 
 }
  
function getReportSetupNameresponse($responce)
{                                                
  $responce = eval('(' + $responce + ')');
  $("#report_setup_report_name").val($responce.data.report_name);
  $("#report_setup_start_date").val($responce.data.from_date);
  $("#report_setup_end_date").val($responce.data.to_date);
  $("#report_freeze_cells").val($responce.data.freeze_cells);
	if($responce.data.is_cross_tab==1)
	document.getElementById('report_setup_cross_tab').checked=true;
	
	if($responce.data.is_col_tot==1)
	document.getElementById('report_setup_col_total').checked=true;
	
	if($responce.data.is_row_total==1)
	document.getElementById('report_setup_row_total').checked=true;
	if($responce.data.is_sub_tot==1)
	{
	
	$("#report_setup_sub_total_text").val($responce.data.sub_tot_field);
	document.getElementById('report_setup_sub_total').checked=true;
	}
	else
	document.getElementById('report_setup_sub_total').checked=false;
	getReportEnableConditions();
	
	if($responce.data.is_sl_no==1)
	document.getElementById('report_setup_sl_no').checked=true;		
 
  for($n=1;$n<$responce.data.conditions.length;$n++)
  {
  addReportSetupCondtionsRow();
  }
  //alert('aa');
   $i=1;
	for($k=0;$k<$responce.data.conditions.length;$k++)
	{  
		$("#emp_field_"+$i).val($responce.data.conditions[$k]['ref_ele_code']);
		$("#oper_"+$i).val($responce.data.conditions[$k]['operator']);
		document.getElementById("txtbox_"+$i).value=$responce.data.conditions[$k]['value'];
		$("#and_or_"+$i).val($responce.data.conditions[$k]['and_or']);
		$i++;	
	}	
}

/* function assignReportSetupFieldId($field_id)
 {
window.$reportsetupfieldid=$field_id;
 } */
 function GenerateFinalReportSetupDetails()
 {
 $report_id=$geditinternalcode;
 $schema_id=$g_report_crieteria_field_data[0].schema_id;
 $cond='';
 	for($i=0;$i<$g_report_crieteria_field_data.length;$i++)
	{	
		$emp_field_id=$g_report_crieteria_field_data[$i].internal_code;
		$emp_field_value=encodeURIComponent(trim($("#emp_report_criteria_"+$emp_field_id).val()));
	 	if($emp_field_value!='')
		{
		$cond+=" and m_"+$schema_id+"_ele_"+$emp_field_id+"='"+$emp_field_value+"'";
		}
	}
	 $emp_ids=0;  		  	
	 for($i=0;$i<$greport_setup_emp_names_arr.length;$i++)
	 {
	 $int_code=$greport_setup_emp_names_arr[$i].internal_code; 
		if(document.getElementById("emp_sal_process_int_code_"+$int_code).checked) 
		{
		$emp_ids+= $int_code+",";
		}
	 }
	  
	$data="&emp_ids="+$emp_ids+'&schema_id='+$schema_id+'&report_id='+$report_id+'&cond='+$cond+"&from_date="+date_format($("#report_setup_start_date").val())+"&to_date="+date_format($("#report_setup_end_date").val());	
	 window.location.href=$host_url+"GenerateFinalReportSetupDetails"+$data;
	
 }

// if there's no header row in the table (there should be, code at least one 
  //manually!), then iteration = lastRow + 1
  var iteration = lastRow;
  var counter=iteration-1;
    /* if(trim($("#txtbox_"+counter).val())=='')
  {
  alert('Please enter the Value');
  $("#txtbox_"+counter).focus();
  return;
  }   */
  
  // creates a new row
  var row = tbl.insertRow(lastRow);

//Field
  	var cellLeft = row.insertCell(0);
	var sel = document.createElement('select');
   sel.id = 'emp_field_' + iteration;
   for($i=0;$i < $g_emp_cond_fields['fields'].length;$i++)                                  
		{         
		sel.options[$i] = new Option($g_emp_cond_fields['fields'][$i]['ele_name'], $g_emp_cond_fields['fields'][$i]['internal_code']);
		} 
   cellLeft.appendChild(sel);
  
  document.getElementById('emp_field_' + iteration).style.width="120px"; 
  
  // Operator
	var cellRightSel = row.insertCell(1);
	var sel = document.createElement('select');
   sel.id = 'oper_' + iteration;
  	for($i=0;$i < $g_emp_cond_fields['oper'].length;$i++)                                  
		{         
		sel.options[$i] = new Option($g_emp_cond_fields['oper'][$i]['operator'], $g_emp_cond_fields['oper'][$i]['operator']);
		} 
   cellRightSel.appendChild(sel); 
   document.getElementById('oper_' + iteration).style.width="70px"; 
  
// TExt Box  
  var cellRightSel = row.insertCell(2);
  var el = document.createElement('input');
   el.type='text';
   el.id='txtbox_'+ iteration;;
   cellRightSel.appendChild(el);  
 document.getElementById('txtbox_' + iteration).style.width="165px"; 
 
 
var cellRightSel = row.insertCell(3);
 var sel = document.createElement('select');
   sel.id = 'and_or_' + iteration;
   sel.options[0] = new Option('And', 'And');
   sel.options[1] = new Option('Or', 'Or');
   cellRightSel.appendChild(sel); 	
return;   
}

function removeReportSetupCondtionsRow()
{
  // grab the element again!
  var tbl = document.getElementById('mySampleTable');
  // grab the length!
  var lastRow = tbl.rows.length;
  // delete the last row if there is more than one row!
  if (lastRow > 2) tbl.deleteRow(lastRow - 1);
}

${this.title}

Code Editor : report_setup.js