gridphp · June 14, 2020 20:04
diff --git a/PHPExcel-from-template.php b/PHPExcel-from-template.php
 <?php 
 /**
 * PHP Grid Component
 *
 * @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */
 
 // include db config
 include_once("../../config.php");

 // include and create object
 include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

 // Database config file to be passed in phpgrid constructor
 $db_conf = array( 	
 					"type" 		=> PHPGRID_DBTYPE, 
 					"server" 	=> PHPGRID_DBHOST,
 					"user" 		=> PHPGRID_DBUSER,
 					"password" 	=> PHPGRID_DBPASS,
 					"database" 	=> PHPGRID_DBNAME
 				);

 $g = new jqgrid($db_conf);

 $grid["caption"] = "Clients"; // caption of grid
 $grid["autowidth"] = true; // expand grid to screen width
 $grid["multiselect"] = false; // allow you to multi-select through checkboxes

 // export to excel parameters - range could be "all" or "filtered"
 $grid["export"] = array("format"=>"xls", "filename"=>"my-file", "heading"=>"Export to Excel Test", "range" => "filtered");

 $g->set_options($grid);

 $g->set_actions(array(	
 						"add"=>false, // allow/disallow add
 						"edit"=>false, // allow/disallow edit
 						"delete"=>true, // allow/disallow delete
 						"rowactions"=>true, // show/hide row wise edit/del/save option
 						"export"=>true, // show/hide export to excel option
 						"autofilter" => true, // show/hide autofilter for search
 						"search" => "advance" // show single/multi field search condition (e.g. simple or advance)
 					) 
 				);

 // this db table will be used for add,edit,delete
 $g->table = "invheader";
 		
 // customize phpexcel settings
 $e["on_render_excel"] = array("custom_export", null);
 $g->set_events($e);

 // custom on_export callback function
 function custom_export($param)
 {
 	global $g;
 	
 	// $objPHPExcel = $param["phpexcel"];
 	
 	$objPHPExcel = PHPExcel_IOFactory::load("./test.xlsx");
 	
 	$arr = $param["data"];

 	// column formatting using phpexcel 
 	for($r=1;$r<count($arr);$r++)
 	{
 		$cell = $r+1;
 		$data = 'Client: '.$arr[$r]["client_id"];
 		
 		// making hyperlink (clientid : column C)
 		$objPHPExcel->setActiveSheetIndex(0)
 					->getCell("C$cell")
 					->getHyperlink()
 					->setUrl('https://www.google.com/search?q='.$data);
 		
 		// format column D as decimal 0.00
 		$objPHPExcel->setActiveSheetIndex(0)->getStyle("D$r")->getNumberFormat()->setFormatCode('0.00'); 
 					
 		$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C$cell", $data);
 	}

 	// write excel2007 standard xlsx
 	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
 	$filename = $g->options["export"]["filename"];

 	header('Content-Type: application/vnd.ms-excel');
 	header('Content-Disposition: attachment;filename="'.$filename.'.xlsx"');

 	// if ssl and IE, remove above cache-control and add following
 	if ( (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") || $_SERVER["SERVER_PORT"] == "443" )
 	{
 		header('Cache-Control: private');
 		header('Pragma: token');
 	}		
 	else
 	{
 		header('Cache-Control: max-age=0');
 	}
 	
 	$objWriter->save('php://output');	
 	die;
 }

 // generate grid output, with unique grid name as 'list1'
 $out = $g->render("list1");
 ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 <html>
 <head>
 	<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>	
 	<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>	
 	
 	<script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
 	<script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
 	<script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>	
 	<script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
 </head>
 <body>
 	<div style="margin:10px">
 	<?php echo $out?>
 	</div>
 </body>
 </html>
	<?php
	/**
	* PHP Grid Component
	*
	* @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
	* @version 2.0.0
	* @license: see license.txt included in package
	*/

	// include db config
	include_once("../../config.php");

	// include and create object
	include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

	// Database config file to be passed in phpgrid constructor
	$db_conf = array(
	"type" => PHPGRID_DBTYPE,
	"server" => PHPGRID_DBHOST,
	"user" => PHPGRID_DBUSER,
	"password" => PHPGRID_DBPASS,
	"database" => PHPGRID_DBNAME
	);

	$g = new jqgrid($db_conf);

	$grid["caption"] = "Clients"; // caption of grid
	$grid["autowidth"] = true; // expand grid to screen width
	$grid["multiselect"] = false; // allow you to multi-select through checkboxes

	// export to excel parameters - range could be "all" or "filtered"
	$grid["export"] = array("format"=>"xls", "filename"=>"my-file", "heading"=>"Export to Excel Test", "range" => "filtered");

	$g->set_options($grid);

	$g->set_actions(array(
	"add"=>false, // allow/disallow add
	"edit"=>false, // allow/disallow edit
	"delete"=>true, // allow/disallow delete
	"rowactions"=>true, // show/hide row wise edit/del/save option
	"export"=>true, // show/hide export to excel option
	"autofilter" => true, // show/hide autofilter for search
	"search" => "advance" // show single/multi field search condition (e.g. simple or advance)
	)
	);

	// this db table will be used for add,edit,delete
	$g->table = "invheader";

	// customize phpexcel settings
	$e["on_render_excel"] = array("custom_export", null);
	$g->set_events($e);

	// custom on_export callback function
	function custom_export($param)
	{
	global $g;

	// $objPHPExcel = $param["phpexcel"];

	$objPHPExcel = PHPExcel_IOFactory::load("./test.xlsx");

	$arr = $param["data"];

	// column formatting using phpexcel
	for($r=1;$r<count($arr);$r++)
	{
	$cell = $r+1;
	$data = 'Client: '.$arr[$r]["client_id"];

	// making hyperlink (clientid : column C)
	$objPHPExcel->setActiveSheetIndex(0)
	->getCell("C$cell")
	->getHyperlink()
	->setUrl('https://www.google.com/search?q='.$data);

	// format column D as decimal 0.00
	$objPHPExcel->setActiveSheetIndex(0)->getStyle("D$r")->getNumberFormat()->setFormatCode('0.00');

	$objPHPExcel->setActiveSheetIndex(0)->setCellValue("C$cell", $data);
	}

	// write excel2007 standard xlsx
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$filename = $g->options["export"]["filename"];

	header('Content-Type: application/vnd.ms-excel');
	header('Content-Disposition: attachment;filename="'.$filename.'.xlsx"');

	// if ssl and IE, remove above cache-control and add following
	if ( (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") \|\| $_SERVER["SERVER_PORT"] == "443" )
	{
	header('Cache-Control: private');
	header('Pragma: token');
	}
	else
	{
	header('Cache-Control: max-age=0');
	}

	$objWriter->save('php://output');
	die;
	}

	// generate grid output, with unique grid name as 'list1'
	$out = $g->render("list1");
	?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
	<html>
	<head>
	<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
	<link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>

	<script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
	<script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
	<script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
	<script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
	</head>
	<body>
	<div style="margin:10px">
	<?php echo $out?>
	</div>
	</body>
	</html>
No results found