/**
* 以XML的方式渲染数据并输出
*
* @param boolean $show
* @return string
*/
public function render($show = true)
{
ob_start();
//这里显示菜单
//这里显示主体部分
//parent::render( true );
reset($this->_data);
echo '<?xml version="1.0" encoding="' . $this->_charSet . '"?>' . "\n";
echo Watt_Util_Array::varToXml($this->_data);
//这里显示底部
$out = ob_get_clean();
if ($show) {
header("Content-type: text/xml; charset=" . $this->_charSet);
echo $out;
}
//如果输出debug信息， XML会报错
Watt_Debug::getDefaultDebug()->clearDebugInfo();
return $out;
}
/**
* @param boolean $expressMode
* @return Watt_Util_Grid
*/
public function excuteAndReturnGrid($expressMode = false)
{
//支持导出报表，如果是导出报表，设置为不使用分页
if (isset($_REQUEST['searchFormExport']) && $_REQUEST['searchFormExport']) {
//导出报表
$this->_usePager = false;
}
// if($this->_sql && isset($_REQUEST['searchFormExport']) && $_REQUEST['searchFormExport']){//导出报表
// //导出报表
// $file=Watt_Util_Export::ExporttoCsv($datas,"baobiao");
// if($file){
// $this->_exportfile = $file;
// }
// }
Watt_Db::startUseReadonlyDb();
// 设置“开始使用只读数据库服务器”。Watt_Db 和 Propel 在执行操作时将检测此设置，如果“使用只读数据库”则强制连接到只读数据库服务器
try {
if ($this->_sql) {
// if($this->_viewandor){
//
// print "<pre>";
// print_r($this->_searchs);
// print "</pre>";
// }
$this->toCriteria();
//这是为了执行 autoGetRequestVar
$datas = $this->_getAllWithSql();
} elseif ($this->_omPeerName) {
if ($expressMode) {
$datas = Watt_Util_Array::doSelectPeerToArray($this->_omPeerName, $this->toCriteria(), $this->_con);
} else {
eval("\$datas = Watt_Util_Array::toArray(" . $this->_omPeerName . "::" . $this->_selectMethod . "(\$this->toCriteria(), \$this->_con, \$this->_otherParam));");
}
}
if (isset($datas) && is_array($datas)) {
/**
* 增加小计
* @author terry
* Tue Jun 12 10:49:46 CST 2007
*/
if (is_array($this->_sumCols) && count($this->_sumCols)) {
$rowSum = current($datas);
if (is_array($rowSum)) {
foreach ($rowSum as $key => $val) {
$rowSum[$key] = null;
}
for ($i = 0; $i < count($datas); $i++) {
foreach ($this->_sumCols as $colName) {
$rowSum[$colName] += $datas[$i][$colName];
}
}
if ($this->_sumFormat) {
foreach ($this->_sumCols as $colName) {
$rowSum[$colName] = sprintf($this->_sumFormat, $rowSum[$colName]);
}
}
}
$datas[self::DEF_SUM] = $rowSum;
}
/**
* 增加合计
* 只有Sql模式才提供合计
* @author terry
* Tue Jun 12 10:49:54 CST 2007
*/
if ($this->_sql && is_array($this->_totalCols) && count($this->_totalCols)) {
$rowTotal = current($datas);
if (is_array($rowTotal)) {
foreach ($rowTotal as $key => $val) {
$rowTotal[$key] = null;
}
$totalCols = "";
foreach ($this->_totalCols as $colName) {
$colName1 = str_replace('+', '_tpma', $colName);
$colName1 = str_replace('-', '_tpmb', $colName1);
$colName1 = str_replace('*', '_tpmc', $colName1);
$colName1 = str_replace('/', '_tpmd', $colName1);
$totalCols .= "sum({$colName}) as {$colName1},";
}
$totalCols = trim($totalCols, ',');
$totalSql = str_replace("count(*)", $totalCols, $this->_getCountSql());
$rowTotalFromSelect = Watt_Db::getDb()->getRow($totalSql);
foreach ($this->_totalCols as $colName) {
$colName1 = str_replace('+', '_tpma', $colName);
$colName1 = str_replace('-', '_tpmb', $colName1);
$colName1 = str_replace('*', '_tpmc', $colName1);
$colName1 = str_replace('/', '_tpmd', $colName1);
$rowTotal[$colName] = @$rowTotalFromSelect[$colName1];
}
if ($this->_totalFormat) {
foreach ($this->_totalCols as $colName) {
$rowTotal[$colName] = sprintf($this->_totalFormat, $rowTotal[$colName]);
}
}
}
$datas[self::DEF_TOTAL] = $rowTotal;
}
} else {
//如无 data ，则也无需小计合计
$datas = array();
}
$grid = new Watt_Util_Grid($datas);
$searchsArray = $this->toArray();
//增加分组数据
if ($this->_sql && is_array($this->_searchgroup) && count($this->_searchgroup)) {
//$searchsArray[self::DEF_SEARCHGROUP] = $this->_searchgroup;
//$grid->setSearchgroup($this->_searchgroup);
$searchsArray[self::DEF_SEARCHS][self::DEF_SEARCHGROUP] = $this->_searchgroup;
}
//增加导出报表标识
//生成报表,设置下载
// if($this->_sql && isset($_REQUEST['searchFormExport']) && $_REQUEST['searchFormExport']){//导出报表
// //导出报表
// $file=Watt_Util_Export::ExporttoCsv($datas,"baobiao");
// if($file){
// $this->_exportfile = $file;
// }
// }
$grid->setSearchs($searchsArray[self::DEF_SEARCHS]);
$grid->setOrderBys($searchsArray[self::DEF_ORDERBYS]);
if ($this->_usePager) {
$grid->setPager($searchsArray[self::DEF_PAGERINFO]);
}
if ($this->_export) {
$grid->setExport($this->_export);
}
if ($this->_exportfile) {
$grid->setExportfile($this->_exportfile);
}
if ($this->_exportfile_name) {
$grid->setExportfileName($this->_exportfile_name);
}
if ($this->_export_col) {
$grid->setExportCol($this->_export_col);
}
if ($this->_export_format) {
$grid->setExportFormat($this->_export_format);
}
Watt_Db::endUseReadonlyDb();
// 设置“停止使用只读数据库服务器”
} catch (Exception $e) {
Watt_Db::endUseReadonlyDb();
throw $e;
}
return $grid;
}