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

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 ?

the php code
http://www.4shared.com/file/iCEjzg3zce/mypage.html

 

It's the first time I have had anyone share a html file via 4shared on this forum

Anyways, feel free to post the code here so that we can help you, you can use the

[code]

Code (markup):

tags

 

this is first time i add topic hear ..

Incidentally I'm not talking fluent English so forgive me if it did not explain what I mean well

<?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'] .= '<script>';
$pageObject->body['end'] .= "window.controlsMap = ".my_json_encode($pageObject->controlsHTMLMap).";";
$pageObject->body['end'] .= "window.viewControlsMap = ".my_json_encode($pageObject->viewControlsHTMLMap).";";
$pageObject->body['end'] .= "window.settings = ".my_json_encode($pageObject->jsSettings).";";
$pageObject->body['end'] .= '</script>';
$pageObject->body["end"] .= "<script language=\"JavaScript\" src=\"".GetRootPathForResources("include/runnerJS/RunnerAll.js")."\"></script>\r\n";
$pageObject->addCommonJs();

$pageObject->body["end"] .= "<script>".$pageObject->PrepareJS()."</script>";
$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 "<html>";
    echo "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">";
   
    echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=".$cCharset."\">";
    echo "<body>";
    echo "<table border=1>";

    WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject);

    echo "</table>";
    echo "</body>";
    echo "</html>";
}

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 "<html>";
    echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=".$cCharset."\">";
    echo "<body>";
    echo "<table border=1>";

    WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject);

    echo "</table>";
    echo "</body>";
    echo "</html>";
}

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 "<tr>";
    if($_REQUEST["type"]=="excel")
    {
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","emp_no")).'</td>';   
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","birth_date")).'</td>';   
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","first_name")).'</td>';   
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","last_name")).'</td>';   
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","gender")).'</td>';   
        echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","hire_date")).'</td>';   
    }
    else
    {
        echo "<td>".GetFieldLabel("employees","emp_no")."</td>";
        echo "<td>".GetFieldLabel("employees","birth_date")."</td>";
        echo "<td>".GetFieldLabel("employees","first_name")."</td>";
        echo "<td>".GetFieldLabel("employees","last_name")."</td>";
        echo "<td>".GetFieldLabel("employees","gender")."</td>";
        echo "<td>".GetFieldLabel("employees","hire_date")."</td>";
    }
    echo "</tr>";
   
// 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:

 

Is the TLayout class from a framework/library? Do you know which?

I would recommend using PHPExcel https://phpexcel.codeplex.com/

It has detailed examples where you can set the value of each cell which would be easy to do by looping through your sql result http://phpexcel.codeplex.com/wikipage?title=Examples

Your example seems overly complicated, can you tell us what it is related to or maybe explain what you think you might have done wrong to cause the issue?

 

thank you i will your PHPExcel .. hop so to help me