The direction of page is changed after exporting to word (.doc) file!

[ebrahim]

hi all …

the page and table is orientation RTL and when i export the page to word (.doc) … becomes the direction of the table LTR !!
how can i solve it ?

my page

[php]

<?php @ini_set("display_errors","1"); @ini_set("display_startup_errors","1"); include("include/dbcommon.php"); include("classes/searchclause.php"); include("classes/sql.php"); session_cache_limiter("none"); include("include/employees_variables.php"); if(!CheckTablePermissions($strTableName, "P")) HeaderRedirect("menu"); $layout = new TLayout("export2", "MetroCity", "MobileCity"); $layout->version = 2; $layout->blocks["top"] = array(); $layout->containers["export"] = array(); $layout->containers["export"][] = array("name"=>"exportheader", "block"=>"", "substyle"=>2 ); $layout->containers["export"][] = array("name"=>"wrapper", "block"=>"", "substyle"=>1 , "container"=>"range" ); $layout->containers["range"] = array(); $layout->containers["range"][] = array("name"=>"exprange", "block"=>"range_block", "substyle"=>1 ); $layout->skins["range"] = "fields"; $layout->containers["export"][] = array("name"=>"wrapper", "block"=>"", "substyle"=>1 , "container"=>"fields" ); $layout->containers["fields"] = array(); $layout->containers["fields"][] = array("name"=>"expoutput", "block"=>"", "substyle"=>1 ); $layout->skins["fields"] = "fields"; $layout->containers["export"][] = array("name"=>"expbuttons", "block"=>"", "substyle"=>2 ); $layout->skins["export"] = "1"; $layout->blocks["top"][] = "export"; $page_layouts["employees_export"] = $layout; $layout->skinsparams = array(); $layout->skinsparams["empty"] = array("button"=>"button1"); $layout->skinsparams["menu"] = array("button"=>"button1"); $layout->skinsparams["hmenu"] = array("button"=>"button1"); $layout->skinsparams["undermenu"] = array("button"=>"button1"); $layout->skinsparams["fields"] = array("button"=>"button1"); $layout->skinsparams["form"] = array("button"=>"button1"); $layout->skinsparams["1"] = array("button"=>"button1"); $layout->skinsparams["2"] = array("button"=>"button1"); $layout->skinsparams["3"] = array("button"=>"button1"); // Modify query: remove blob fields from fieldlist. // Blob fields on an export page are shown using imager.php (for example). // They don't need to be selected from DB in export.php itself. //$gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices()); $cipherer = new RunnerCipherer($strTableName); $strWhereClause = ""; $strHavingClause = ""; $strSearchCriteria = "and"; $selected_recs = array(); $options = "1"; header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); include('include/xtempl.php'); include('classes/runnerpage.php'); $xt = new Xtempl(); $id = postvalue("id") != "" ? postvalue("id") : 1; $phpVersion = (int)substr(phpversion(), 0, 1); if($phpVersion > 4) { include("include/export_functions.php"); $xt->assign("groupExcel", true); } else $xt->assign("excel", true); //array of params for classes $params = array("pageType" => PAGE_EXPORT, "id" => $id, "tName" => $strTableName); $params["xt"] = &$xt; if(!$eventObj->exists("ListGetRowCount") && !$eventObj->exists("ListQuery")) $params["needSearchClauseObj"] = false; $pageObject = new RunnerPage($params); $pageObject->init(); // Before Process event if($eventObj->exists("BeforeProcessExport")) $eventObj->BeforeProcessExport($conn, $pageObject); if (@$_REQUEST["a"]!="") { $options = ""; $sWhere = "1=0"; // process selection $selected_recs = array(); if (@$_REQUEST["mdelete"]) { foreach(@$_REQUEST["mdelete"] as $ind) { $keys=array(); $keys["emp_no"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]); $selected_recs[] = $keys; } } elseif(@$_REQUEST["selection"]) { foreach(@$_REQUEST["selection"] as $keyblock) { $arr=explode("&",refine($keyblock)); if(count($arr)<1) continue; $keys = array(); $keys["emp_no"] = urldecode($arr[0]); $selected_recs[] = $keys; } } foreach($selected_recs as $keys) { $sWhere = $sWhere . " or "; $sWhere.=KeyWhere($keys); } $strSQL = $gQuery->gSQLWhere($sWhere); $strWhereClause=$sWhere; $_SESSION[$strTableName."_SelectedSQL"] = $strSQL; $_SESSION[$strTableName."_SelectedWhere"] = $sWhere; $_SESSION[$strTableName."_SelectedRecords"] = $selected_recs; } if ($_SESSION[$strTableName."_SelectedSQL"]!="" && @$_REQUEST["records"]=="") { $strSQL = $_SESSION[$strTableName."_SelectedSQL"]; $strWhereClause = @$_SESSION[$strTableName."_SelectedWhere"]; $selected_recs = $_SESSION[$strTableName."_SelectedRecords"]; } else { $strWhereClause = @$_SESSION[$strTableName."_where"]; $strHavingClause = @$_SESSION[$strTableName."_having"]; $strSearchCriteria = @$_SESSION[$strTableName."_criteria"]; $joinFromPart = @$_SESSION[$strTableName."_joinFromPart"]; //$strSQL = $gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL = SQLQuery::gSQLWhere_having($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); } $mypage = 1; if(@$_REQUEST["type"]) { // order by $strOrderBy = $_SESSION[$strTableName."_order"]; if(!$strOrderBy) $strOrderBy = $gstrOrderBy; $strSQL.=" ".trim($strOrderBy); $strSQLbak = $strSQL; if($eventObj->exists("BeforeQueryExport")) $eventObj->BeforeQueryExport($strSQL,$strWhereClause,$strOrderBy, $pageObject); // Rebuild SQL if needed if($strSQL!=$strSQLbak) { // changed $strSQL - old style $numrows=GetRowCount($strSQL); } else { //$strSQL = $gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL = SQLQuery::gSQLWhere_having($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL.=" ".trim($strOrderBy); $rowcount=false; if($eventObj->exists("ListGetRowCount")) { $masterKeysReq=array(); for($i = 0; $i < count($pageObject->detailKeysByM); $i ++) $masterKeysReq[] = $_SESSION[$strTableName."_masterkey".($i + 1)]; $rowcount = $eventObj->ListGetRowCount($pageObject->searchClauseObj,$_SESSION[$strTableName."_mastertable"],$masterKeysReq,$selected_recs, $pageObject); } if($rowcount !== false) $numrows = $rowcount; else { //$numrows = $gQuery->gSQLRowCount($strWhereClause,$strHavingClause,$strSearchCriteria); $numrows = SQLQuery::gSQLRowCount_int($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); } } LogInfo($strSQL); // Pagination: $nPageSize = 0; if(@$_REQUEST["records"]=="page" && $numrows) { $mypage = (integer)@$_SESSION[$strTableName."_pagenumber"]; $nPageSize = (integer)@$_SESSION[$strTableName."_pagesize"]; if(!$nPageSize) $nPageSize = $gSettings->getInitialPageSize(); if($nPageSize<0) $nPageSize = 0; if($nPageSize>0) { if($numrows<=($mypage-1)*$nPageSize) $mypage = ceil($numrows/$nPageSize); if(!$mypage) $mypage = 1; $strSQL.=" limit ".(($mypage-1)*$nPageSize).",".$nPageSize; } } $listarray = null; if($eventObj->exists("ListQuery")) { $arrFieldForSort = array(); $arrHowFieldSort = array(); require_once getabspath('classes/orderclause.php'); $fieldList = unserialize($_SESSION[$strTableName."_orderFieldsList"]); for($i = 0; $i < count($fieldList); $i++) { $arrFieldForSort[] = $fieldList[$i]->fieldIndex; $arrHowFieldSort[] = $fieldList[$i]->orderDirection; } $listarray = $eventObj->ListQuery($pageObject->searchClauseObj, $arrFieldForSort, $arrHowFieldSort, $_SESSION[$strTableName."_mastertable"], $masterKeysReq, $selected_recs, $nPageSize, $mypage, $pageObject); } if($listarray != null) { $rs = $listarray; } elseif($nPageSize>0) { $rs = db_query($strSQL,$conn); } else $rs = db_query($strSQL,$conn); if(!ini_get("safe_mode")) set_time_limit(300); if(substr(@$_REQUEST["type"],0,5)=="excel") { // remove grouping $locale_info["LOCALE_SGROUPING"]="0"; $locale_info["LOCALE_SMONGROUPING"]="0"; if($phpVersion > 4) ExportToExcel($rs, $nPageSize, $eventObj, $cipherer, $pageObject); else ExportToExcel_old($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="word") { ExportToWord($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="xml") { ExportToXML($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="csv") { $locale_info["LOCALE_SGROUPING"]="0"; $locale_info["LOCALE_SDECIMAL"]="."; $locale_info["LOCALE_SMONGROUPING"]="0"; $locale_info["LOCALE_SMONDECIMALSEP"]="."; ExportToCSV($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } db_close($conn); return; } // add button events if exist $pageObject->addButtonHandlers(); if($options) { $xt->assign("rangeheader_block",true); $xt->assign("range_block",true); } $xt->assign("exportlink_attrs", 'id="saveButton'.$pageObject->id.'"'); $pageObject->body["begin"] .= GetBaseScriptsForPage(false); $pageObject->fillSetCntrlMaps(); $pageObject->body['end'] .= ''; $pageObject->body["end"] .= "\r\n"; $pageObject->addCommonJs(); $pageObject->body["end"] .= ""; $xt->assignbyref("body",$pageObject->body); $pageObject->display(GetTemplateName("employees", "export")); $table["direction"] = "rtl"; function ExportToExcel_old($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject) { global $cCharset; header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".xls"); echo ""; echo ""; echo ""; echo ""; echo ""; WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); echo ""; echo ""; echo ""; } function ExportToWord($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject) { global $cCharset; header("Content-Type: application/vnd.ms-word"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".doc"); echo ""; echo ""; echo ""; echo ""; WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); echo ""; echo ""; echo ""; } function ExportToXML($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject) { global $cCharset; header("Content-Type: text/xml"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".xml"); if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs); //if(!$row) // return; echo "<?xml version=\"1.0\" encoding=\"".$cCharset."\" standalone=\"yes\"?>\r\n";

echo "<table>\r\n";
$i = 0;
$pageObject->viewControls->forExport = "xml";
while((!$nPageSize || $i<$nPageSize) && $row)
{
	$values = array();
		$values["emp_no"] = $pageObject->getExportValue("emp_no", $row);
		$values["birth_date"] = $pageObject->getExportValue("birth_date", $row);
		$values["first_name"] = $pageObject->getExportValue("first_name", $row);
		$values["last_name"] = $pageObject->getExportValue("last_name", $row);
		$values["gender"] = $pageObject->getExportValue("gender", $row);
		$values["hire_date"] = $pageObject->getExportValue("hire_date", $row);
	
	$eventRes = true;
	if ($eventObj->exists('BeforeOut'))
		$eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
	
	if ($eventRes)
	{
		$i++;
		echo "<row>\r\n";
		foreach ($values as $fName => $val)
		{
			$field = runner_htmlspecialchars(XMLNameEncode($fName));
			echo "<".$field.">";
			echo $values[$fName];
			echo "</".$field.">\r\n";
		}
		echo "</row>\r\n";
	}
	
	
	if($eventObj->exists("ListFetchArray"))
		$row = $eventObj->ListFetchArray($rs, $pageObject);
	else
		$row = $cipherer->DecryptFetchedArray($rs);
}
echo "</table>\r\n";

}

function ExportToCSV($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject)
{
header(“Content-Type: application/csv”);
header(“Content-Disposition: attachment;Filename=”.GetTableURL($strTableName).".csv");
echo “\xEF\xBB\xBF”;

if($eventObj->exists("ListFetchArray"))
	$row = $eventObj->ListFetchArray($rs, $pageObject);
else
	$row = $cipherer->DecryptFetchedArray($rs);

// write header
$outstr = “”;
if($outstr!="")
$outstr.=",";
$outstr.= ““emp_no””;
if($outstr!="")
$outstr.=",";
$outstr.= ““birth_date””;
if($outstr!="")
$outstr.=",";
$outstr.= ““first_name””;
if($outstr!="")
$outstr.=",";
$outstr.= ““last_name””;
if($outstr!="")
$outstr.=",";
$outstr.= ““gender””;
if($outstr!="")
$outstr.=",";
$outstr.= ““hire_date””;
echo $outstr;
echo “\r\n”;

// write data rows
$iNumberOfRows = 0;
$pageObject->viewControls->forExport = “csv”;
while((!$nPageSize || $iNumberOfRows < $nPageSize) && $row)
{
$values = array();
$values[“emp_no”] = $pageObject->getViewControl(“emp_no”)->getExportValue($row, “”);
$values[“birth_date”] = $pageObject->getViewControl(“birth_date”)->getExportValue($row, “”);
$values[“first_name”] = $pageObject->getViewControl(“first_name”)->getExportValue($row, “”);
$values[“last_name”] = $pageObject->getViewControl(“last_name”)->getExportValue($row, “”);
$values[“gender”] = $pageObject->getViewControl(“gender”)->getExportValue($row, “”);
$values[“hire_date”] = $pageObject->getViewControl(“hire_date”)->getExportValue($row, “”);

	$eventRes = true;
	if ($eventObj->exists('BeforeOut'))
	{
		$eventRes = $eventObj->BeforeOut($row,$values, $pageObject);
	}
	if ($eventRes)
	{
		$outstr="";
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["emp_no"]).'"';
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["birth_date"]).'"';
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["first_name"]).'"';
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["last_name"]).'"';
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["gender"]).'"';
		if($outstr!="")
			$outstr.=",";
		$outstr.='"'.str_replace('"', '""', $values["hire_date"]).'"';
		echo $outstr;
	}
	
	$iNumberOfRows++;
	if($eventObj->exists("ListFetchArray"))
		$row = $eventObj->ListFetchArray($rs, $pageObject);
	else
		$row = $cipherer->DecryptFetchedArray($rs);
		
	if(((!$nPageSize || $iNumberOfRows<$nPageSize) && $row) && $eventRes)
		echo "\r\n";
}

}

function WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject)
{
if($eventObj->exists(“ListFetchArray”))
$row = $eventObj->ListFetchArray($rs, $pageObject);
else
$row = $cipherer->DecryptFetchedArray($rs);
// if(!$row)
// return;
// write header
echo “

”;
if($_REQUEST[“type”]==“excel”)
{
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“emp_no”)).’’;
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“birth_date”)).’’;
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“first_name”)).’’;
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“last_name”)).’’;
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“gender”)).’’;
echo ‘’.PrepareForExcel(GetFieldLabel(“employees”,“hire_date”)).’’;
}
else
{
echo “”.GetFieldLabel(“employees”,“emp_no”)."";
echo “”.GetFieldLabel(“employees”,“birth_date”)."";
echo “”.GetFieldLabel(“employees”,“first_name”)."";
echo “”.GetFieldLabel(“employees”,“last_name”)."";
echo “”.GetFieldLabel(“employees”,“gender”)."";
echo “”.GetFieldLabel(“employees”,“hire_date”)."";
}
echo “”;

// write data rows
$iNumberOfRows = 0;
$pageObject->viewControls->forExport = “export”;
while((!$nPageSize || $iNumberOfRows<$nPageSize) && $row)
{
countTotals($totals, $totalsFields, $row);

	$values = array();

				$values["emp_no"] = $pageObject->getViewControl("emp_no")->getExportValue($row, "");
				$values["birth_date"] = $pageObject->getViewControl("birth_date")->getExportValue($row, "");
				$values["first_name"] = $pageObject->getViewControl("first_name")->getExportValue($row, "");
				$values["last_name"] = $pageObject->getViewControl("last_name")->getExportValue($row, "");
				$values["gender"] = $pageObject->getViewControl("gender")->getExportValue($row, "");
				$values["hire_date"] = $pageObject->getViewControl("hire_date")->getExportValue($row, "");
	
	$eventRes = true;
	if ($eventObj->exists('BeforeOut'))
	{
		$eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
	}
	if ($eventRes)
	{
		$iNumberOfRows++;
		echo "<tr>";
	
						echo '<td>';
		
								echo $values["emp_no"];
		echo '</td>';
						echo '<td>';
		
								if($_REQUEST["type"]=="excel")
					echo PrepareForExcel($values["birth_date"]);
				else
					echo $values["birth_date"];
		echo '</td>';
						if($_REQUEST["type"]=="excel")
				echo '<td x:str>';
			else
				echo '<td>';
		
								if($_REQUEST["type"]=="excel")
					echo PrepareForExcel($values["first_name"]);
				else
					echo $values["first_name"];
		echo '</td>';
						if($_REQUEST["type"]=="excel")
				echo '<td x:str>';
			else
				echo '<td>';
		
								if($_REQUEST["type"]=="excel")
					echo PrepareForExcel($values["last_name"]);
				else
					echo $values["last_name"];
		echo '</td>';
						if($_REQUEST["type"]=="excel")
				echo '<td x:str>';
			else
				echo '<td>';
		
								if($_REQUEST["type"]=="excel")
					echo PrepareForExcel($values["gender"]);
				else
					echo $values["gender"];
		echo '</td>';
						echo '<td>';
		
								if($_REQUEST["type"]=="excel")
					echo PrepareForExcel($values["hire_date"]);
				else
					echo $values["hire_date"];
		echo '</td>';
		echo "</tr>";
	}
	
	
	if($eventObj->exists("ListFetchArray"))
		$row = $eventObj->ListFetchArray($rs, $pageObject);
	else
		$row = $cipherer->DecryptFetchedArray($rs);
}

}
?>
[/php]

[Topcoder]

In MS word on your PC, I think you need to set it up to enable RTL.

Using right-to-left languages in Office