Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.95 KB	-rwxr-xr-x
FormulaEvaluate.php	14.47 KB	-rwxr-xr-x
MarkEntry-Setup.php	22.02 KB	-rwxr-xr-x
MarkEntry-Setup06062012.php	20.42 KB	-rwxr-xr-x
MarkEntry-Setup140911.php	20.42 KB	-rwxr-xr-x
MarkEntry-Setup26062012.php	21.11 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.87 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.82 KB	-rwxr-xr-x
absent_entry_setup.php	7.83 KB	-rwxr-xr-x
actClass.php	6.38 KB	-rwxr-xr-x
admission_entry_status.php	2.79 KB	-rwxr-xr-x
auto-complete.php	5.04 KB	-rwxr-xr-x
backup_restore.php	8.36 KB	-rwxr-xr-x
backupandrestore.php	10.43 KB	-rwxr-xr-x
cManualMailer.php	2.63 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	35.51 KB	-rwxr-xr-x
candidate-entry_beforeyearexam...	33.84 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
cmailer.php	6.96 KB	-rwxr-xr-x
college_degree_status.php	5.98 KB	-rwxr-xr-x
coutput.php	1.83 KB	-rwxr-xr-x
create_all_grid_files.php	8.8 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	10.18 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.85 KB	-rwxr-xr-x
create_all_popup_files.php	6.08 KB	-rwxr-xr-x
create_all_schema_files.php	4.42 KB	-rwxr-xr-x
create_all_views.php	16.87 KB	-rwxr-xr-x
create_html_files.php	52.9 KB	-rwxr-xr-x
create_html_files_without_tab....	45.23 KB	-rwxr-xr-x
create_module_meta_columns.php	5.26 KB	-rwxr-xr-x
crequestbroker.php	2.58 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	124 B	-rwxr-xr-x
datadictionary.php	4.06 KB	-rwxr-xr-x
display_details_in_grid.php	99.65 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.79 KB	-rwxr-xr-x
display_details_in_grid_studta...	99.65 KB	-rwxr-xr-x
download_upload.php	3.49 KB	-rwxr-xr-x
dynamicmastersdetails.php	120.21 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	122.84 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	122.19 KB	-rwxr-xr-x
entryexitevents.php	3.19 KB	-rwxr-xr-x
execute_query.php	2.59 KB	-rwxr-xr-x
export_import_setup.php	7.8 KB	-rwxr-xr-x
export_import_utility.php	2.75 KB	-rwxr-xr-x
format.php	7.76 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.81 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.83 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.94 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.61 KB	-rwxr-xr-x
general_report_format.php	11.33 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	3.05 KB	-rwxr-xr-x
getdata.php	17.27 KB	-rwxr-xr-x
getdata110911.php	16.47 KB	-rwxr-xr-x
getdata14062012.php	17.27 KB	-rwxr-xr-x
getmoduledetails.php	24.23 KB	-rwxr-xr-x
getnumword.php	7.82 KB	-rwxr-xr-x
getreportdetails.php	3.29 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.43 KB	-rwxr-xr-x
getsearchcondition.php	1.37 KB	-rwxr-xr-x
ggridmodel.php	9.59 KB	-rwxr-xr-x
golden_palm_payslip.php	12.86 KB	-rwxr-xr-x
helptext.php	5.54 KB	-rwxr-xr-x
identify_transactions.php	6.56 KB	-rwxr-xr-x
json.php	34 KB	-rwxr-xr-x
login.php	3.29 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login_old.php	2.92 KB	-rwxr-xr-x
message_board.php	4.81 KB	-rwxr-xr-x
module_setup.php	2.56 KB	-rwxr-xr-x
mregistry.php	45.69 KB	-rwxr-xr-x
mrn_approval.php	9.24 KB	-rwxr-xr-x
report_setup.php	25.56 KB	-rwxr-xr-x
report_tool.php	74.93 KB	-rwxr-xr-x
revaluation.php	8.65 KB	-rwxr-xr-x
sendLoginPassword.php	3.2 KB	-rwxr-xr-x
serchbygrid.php	868 B	-rwxr-xr-x
student_entry.php	31.08 KB	-rwxr-xr-x
system_utility.php	1.89 KB	-rwxr-xr-x
systemsetup.php	78.57 KB	-rwxr-xr-x
transaction-series.php	4.99 KB	-rwxr-xr-x
update_defined_flag.php	3.5 KB	-rwxr-xr-x
uploadmoduledetails.php	40.61 KB	-rwxr-xr-x
usersetup.php	24.63 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