Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
imported_files	[ DIR ]	drwxrwxrwx
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.88 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_exam_app_form.php	12.83 KB	-rwxr-xr-x
ack_exam_app_form22.php	12.53 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.28 KB	-rwxr-xr-x
ack_rv_rt_application_02082017...	8.36 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
ack_rv_rt_application_old.php	8.04 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
applicationFormReportSBM.php	14.23 KB	-rwxr-xr-x
approve.php	19.63 KB	-rwxr-xr-x
attendance.php	6.13 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
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	42.12 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-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.php	54.14 KB	-rwxr-xr-x
cappcontext.php	3.19 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	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	3.9 KB	-rwxr-xr-x
download_photo_bfvskub.php	4.82 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.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...	7.85 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.25 KB	-rwxr-xr-x
getdata22.php	32.82 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.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	7.21 KB	-rwxr-xr-x
room_allotment_new.php	15.25 KB	-rwxr-xr-x
roomdeclaration.php	1.8 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	48.07 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	16.83 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	8.02 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 : general_report_format.php

<?php

function displayReport($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
$main_src=$main_src_obj[1];
$format_file=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/src/format.php";
include($format_file);
 $report_id = $aobj_context->mobj_data["report_id"];
 $schema_name = $aobj_context->mobj_data["schema_name"];
 $FromDate = db_date_Format($aobj_context->mobj_data["Fromdate"]);
 $ToDate = db_date_Format($aobj_context->mobj_data["Todate"]);

$a_path=  "http://".$_SERVER["SERVER_NAME"] ."/{$main_src}/app.php?a=getDownloadReportFile&report_id=".$report_id."&FromDate=".$FromDate."&ToDate=".$ToDate;
  $a_pdf_path=  "http://".$_SERVER["SERVER_NAME"] ."/{$main_src}/app.php?a=getDownloadPDFReportFile&report_id=".$report_id."&FromDate=".$FromDate."&ToDate=".$ToDate;

if(!in_array($report_id,$_SESSION['report_ids']))
{
$_SESSION['report_count']=$_SESSION['report_count']+1;
$_SESSION['report_ids'][$_SESSION['report_count']]=$report_id;
}
$get_display_cols="select concat(m_2_ele_7,'-',m_2_ele_8)
					as 'Activity_Code',expense_type as 'Expense_Type',
					amount as Amount from activity_cost a 
					inner join module_2 m on m.internal_code=activity_code
					where 
					from_date>='{$FromDate}'
					and to_date<= '{$ToDate}'    order by 1";
	 
		$lobj_get_display_cols = $aobj_context->mobj_db->GetRow($get_display_cols);
		 
	
		  	$header=array_keys($lobj_get_display_cols);
		$grid_header=''; 
		$grid_header_val=''; 
	 foreach($header as $key=> $value)
   {
   	$grid_header.="'".$header[$key]."',";
	$grid_header_val.="{name:'grid_".$header[$key]."',index:'grid_".$header[$key]."', width:50 } ,";
   }
   $grid_header=substr($grid_header,0,strlen($grid_header)-1);
   $grid_header_val=substr($grid_header_val,0,strlen($grid_header_val)-1);

$lstr="<html> 
	<head> 
		<title>{$schema_name} Report </title> 
			<link rel='stylesheet' type='text/css' media='screen' href='../../jqGrid3/themes/tarka/grid.css' /> 
			<link rel='stylesheet' type='text/css' media='screen' href='../../jqGrid3/themes/jqModal.css' />
			<script src='../../js/index.js' type='text/javascript'></script> 
			<script src='../../jqGrid3/jquery.js' type='text/javascript'></script> 
			<script src='../../jqGrid3/jquery.jqGrid.js' type='text/javascript'></script> 
			<script src='../../jqGrid3/js/jqModal.js' type='text/javascript'></script> 
			<script src='../../jqGrid3/js/jqDnR.js' type='text/javascript'></script> 
			 
			<script type='text/javascript'> 
	 var host_url= \"http://{$_SERVER["SERVER_NAME"]}/{$main_src}/app.php?a=\";
var img_path=\"http://{$_SERVER["SERVER_NAME"]}/{$main_src}/jqGrid3/themes/tarka/images/\";	
function displayReportDetails()
{
document.getElementById('sub_grid_div').innerHTML='';
document.getElementById('main_grid_div').innerHTML='';

}
).navGrid('#sub_grid_div',{edit:false,add:false,del:false});
 jQuery('#vcol').click(function (){ jQuery('#table_grid').setColumns(); });
 
}
		</script> 
	</head>

<body bgcolor='#EAEAEA' ONLOAD='displayReportDetails();'> 
	<div style=' padding-top:12px; padding-bottom:05px;'><a href='{$a_path}'>Download</a>&nbsp;<a href='{$a_pdf_path}'>Download PDF</a></div>
	<div id='main_grid_div' style=' width:100%; overflow:auto;'>
				<table id='table_grid'  class='scroll'></table> 
				<div id='sub_grid_div' class='scroll' style='text-align:center;'></div> 
				
				</div>
		<div style='padding-top:12px;'><a href='{$a_path}'>Download</a>&nbsp;<a href='{$a_pdf_path}'>Download PDF</a> <a href='#' id='vcol'>Hide/Show Columns</a></div>
	</body> 
</html>";
			  
			  
			 $root_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".html";
			  $root_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".csv";
			file_put_contents($root_file_download,$down_load);
			 
	if(file_put_contents($root_file_name,$lstr))
		{
		$open_path= $_SERVER["SERVER_NAME"]."/{$main_src}/Report_details/output/report_display_".$_SESSION['user_id']."_".$report_id.".html";

echo $aobj_context->mobj_output->ToJSONEnvelope($open_path,0,"success"); 
		
		}
			 
}
 
 
 //ownloadReport1(); 
function downloadReport($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
$report_id = $aobj_context->mobj_data["report_id"];
$FromDate = $aobj_context->mobj_data["FromDate"];
 $ToDate = $aobj_context->mobj_data["ToDate"];
$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
$main_src=$main_src_obj[1];
$excel_writer=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Excel_Writer/Writer.php";
include($excel_writer);	
 $root_xls_file_download=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/output/report".$_SESSION['user_id']."_".$report_id.".xls";
 
$workbook = new Spreadsheet_Excel_Writer($root_xls_file_download);

// sending HTTP headers
//$workbook->send('test.xls');

// Creating a worksheet
$worksheet =& $workbook->addWorksheet('Sheet1');
     
 $get_data="select concat(m_2_ele_7,'-',m_2_ele_8)
					as 'Activity_Code',expense_type as 'Expense_Type',
					amount as Amount from activity_cost a 
					inner join module_2 m on m.internal_code=activity_code
					where 
					from_date>='{$FromDate}'
					and to_date<= '{$ToDate}'   order by 1"; 
   
     $lobj_details = $aobj_context->mobj_db->GetAll($get_data);
	  
   	$header_row=(array_keys($lobj_details[0]));
 
	$header_row_cell_indx=0;
	foreach($header_row as $key=> $value)
   {
    $worksheet->write(0,$header_row_cell_indx,$value);
	$header_row_cell_indx++;	 
   }
      $xlsRow = 1;
     foreach($lobj_details as $key=> $value)
	{
		$xlscol=0;
	    foreach($value as $key1=> $value1)
	    {
		 $worksheet->write($xlsRow,$xlscol,$value1);
	     $xlscol++;
		}
		 $xlsRow++; 
	}	         
 $workbook->close();
  header("Content-type: application/vnd.ms-excel");
        header("Content-Disposition: attachment; filename=report\"$report_id\".xls");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
        header("Pragma: public");
 readfile($root_xls_file_download);
 unlink($root_xls_file_download);
}
function downloadPDFReport($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
 $report_id = $aobj_context->mobj_data["report_id"];
 $FromDate = $aobj_context->mobj_data["FromDate"];
 $ToDate = $aobj_context->mobj_data["ToDate"];
$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
$main_src=$main_src_obj[1];
$pdf_writer_class=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/maya-pdf/cls.pdf.php";
 
include($pdf_writer_class);	
$pdf= new PDF('P','mm','A4');
  
$get_data="select concat(m_2_ele_7,'-',m_2_ele_8)
					as 'Activity_Code',expense_type as 'Expense_Type',
					amount as Amount from activity_cost a 
					inner join module_2 m on m.internal_code=activity_code
					where 
					from_date>='{$FromDate}'
					and to_date<= '{$ToDate}'   order by 1"; 
   
// dnt change order of execution		
// getting data
$lobj_details = $aobj_context->mobj_db->GetAll($get_data); 
// getting Header data
$header_row=(array_keys($lobj_details[0]));

// Setting font style
$pdf->SetFont('courier','',10);
// Adding page
$pdf->AddPage();

// Displaying Header information in the PDF File
 foreach($header_row as $col)
    {
		$pdf->Cell(95,5,$col,1,'','C','true');
		$pdf->SetFillColor(200,220,255);
	}
//Displaying Data in th PDF File   
	foreach($lobj_details as $row)
    {
		$pdf->Ln();
        foreach($row as $col)
            $pdf->Cell(95,5,$col,1);		      
    }
// Downloading file to the Destination using 
// d for downloading without going to next page
// I for viewing the PDF file in the browser itself
// default  for downloading file and display the new page in the browser
$pdf->Output("report_{$report_id}.pdf","d");
}

function displayGridReportDetails($aobj_context)
{
$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
$main_src=$main_src_obj[1];
$search_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/src/getsearchcondition.php";
 $FromDate = $aobj_context->mobj_data["FromDate"];
 $ToDate = $aobj_context->mobj_data["ToDate"];
include($search_file_name);			
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
include("/JSON.php");
$data_qry="select a.internal_code  ,concat(m_2_ele_7,'-',m_2_ele_8)
					as 'Activity_Code',expense_type as 'Expense_Type',
					amount as Amount from activity_cost a 
					inner join module_2 m on m.internal_code=activity_code 
					where from_date>='{$FromDate}'
					and to_date<= '{$ToDate}'    ";
		 
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];

if(!$sidx)
$sidx =1;
else
$indx=explode("grid_",$sidx);
 
$sidx=empty($indx[1])?'1':$indx[1];
$table_name=$_GET['table_name'];
$table_field_name=stripcslashes($_GET['field_name']);
$details_array=$_GET['details_array'];

// to take th e parameters from Search field
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$field_name_value=explode('grid_',$_GET['searchField']);
$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
$cond=$final_value[0];
$value=$final_value[1];
}
$field_name=$field_name_value[1];
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$count_id="select count(*) as count from ({$data_qry}) a where $field_name $cond$value";

}
else
{
$count_id="select count(*) as count from ({$data_qry}) a";
}
$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$SQL="select * from ({$data_qry} )a where $field_name $cond$value
ORDER BY $sidx $sord LIMIT $start,$limit";
//echo $SQL;
}
else
{
$SQL = " {$data_qry}
ORDER BY $sidx $sord LIMIT $start , $limit";
}
 
 
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count; 
$lobj_rs =$aobj_context->mobj_db->GetAll($SQL);
   
foreach($lobj_rs as $key =>$value)
{
$val='';
$responce->rows[$key]['id']=$value[internal_code];
$l=0;
 	foreach($value as $key1 =>$value1)
	{	 
		if($key1!='internal_code'){ 
	    $val[$l]=$value[$key1];
		 $l++; 
		}
	} 
$responce->rows[$key]['cell']=($val);
}  
echo $json->encode($responce);
}

${this.title}

Code Editor : general_report_format.php