PHP countTotals函数代码示例

本文整理汇总了PHP中countTotals函数的典型用法代码示例。如果您正苦于以下问题：PHP countTotals函数的具体用法？PHP countTotals怎么用？PHP countTotals使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了countTotals函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: ExportToExcel

function ExportToExcel()
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj;
    if ($eventObj->exists("ListFetchArray")) {
        $row = $eventObj->ListFetchArray($rs);
    } else {
        $row = db_fetch_array($rs);
    }
    //	if(!$row)
    //		return;
    $arrLabel = array();
    $arrColumnWidth = array();
    $arrTotal = array();
    $arrTotalMessage = array();
    $totals = array();
    $arrFields = array();
    $arrTmpTotal = array();
    $arrFields = GetFieldsList($strTableName);
    $arrTmpTotal = GetTableData($strTableName, ".totalsFields", array());
    foreach ($arrFields as $value) {
        $arrLabel[$value] = label($value, $strTableName);
        $arrColumnWidth[$value] = 10;
        $totals[$value] = 0;
        $totalsType = "";
        foreach ($arrTmpTotal as $tvalue) {
            if ($tvalue["fName"] == $value) {
                $totalsType = $tvalue["totalsType"];
            }
        }
        $totalsFields[] = array('fName' => $value, 'totalsType' => $totalsType, 'viewFormat' => ViewFormat($value, $strTableName));
    }
    // write data rows
    $iNumberOfRows = 0;
    $objPHPExcel = ExportExcelInit($arrLabel, $arrColumnWidth);
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $arrData = array();
        $arrDataType = array();
        foreach ($arrFields as $value) {
            if (GetEditFormat($value, $strTableName) == EDIT_FORMAT_LOOKUP_WIZARD || GetEditFormat($value, $strTableName) == EDIT_FORMAT_RADIO) {
                $values[$value] = "";
                if (strlen($row[$value])) {
                    $values[$value] = DisplayLookupWizard($value, $row[$value], $row, "", MODE_EXPORT);
                }
            } elseif (IsBinaryType(GetFieldType($value, $strTableName))) {
                $values[$value] = $row[$value];
            } else {
                if (ViewFormat($value, $strTableName) != FORMAT_FILE_IMAGE && ViewFormat($value, $strTableName) != FORMAT_FILE && ViewFormat($value, $strTableName) != FORMAT_HYPERLINK && ViewFormat($value, $strTableName) != FORMAT_EMAILHYPERLINK && ViewFormat($value, $strTableName) != FORMAT_CHECKBOX) {
                    $format = ViewFormat($value, $strTableName);
                } else {
                    $format = FORMAT_NONE;
                }
                $values[$value] = GetData($row, $value, $format);
            }
        }
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $arrColumnWidth, $iNumberOfRows + 1, $objPHPExcel);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            $i = 0;
            foreach ($arrFields as $value) {
                if (IsBinaryType(GetFieldType($value, $strTableName))) {
                    $arrDataType[$value] = "binary";
                } elseif (ViewFormat($value, $strTableName) == FORMAT_FILE_IMAGE) {
                    $arrDataType[$value] = "file";
                } elseif (ViewFormat($value, $strTableName) == FORMAT_DATE_SHORT || ViewFormat($value, $strTableName) == FORMAT_DATE_LONG || ViewFormat($value, $strTableName) == FORMAT_DATE_TIME) {
                    $arrDataType[$value] = "date";
                } else {
                    $arrDataType[$value] = "";
                }
                $arrData[$value] = $values[$value];
            }
            ExportExcelRecord($arrData, $arrDataType, $iNumberOfRows, $objPHPExcel);
        }
        if ($eventObj->exists("ListFetchArray")) {
            $row = $eventObj->ListFetchArray($rs);
        } else {
            $row = db_fetch_array($rs);
        }
    }
    if (count($arrTmpTotal)) {
        foreach ($arrFields as $fName) {
            $value = array();
            foreach ($arrTmpTotal as $tvalue) {
                if ($tvalue["fName"] == $fName) {
                    $value = $tvalue;
                }
            }
            $total = "";
            $totalMess = "";
            if ($value["totalsType"]) {
                if ($value["totalsType"] == "COUNT") {
                    $totalMess = "Count" . ": ";
                } elseif ($value["totalsType"] == "TOTAL") {
                    $totalMess = "Total" . ": ";
                } elseif ($value["totalsType"] == "AVERAGE") {
                    $totalMess = "Average" . ": ";
//.........这里部分代码省略.........

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:101，代码来源:export_functions.php

示例2: WriteTableData


//.........这里部分代码省略.........
        echo "<td>" . "Mall Id" . "</td>";
        echo "<td>" . "Cash Register" . "</td>";
        echo "<td>" . "Pelaporan" . "</td>";
        echo "<td>" . "Pembukuan" . "</td>";
        echo "<td>" . "Bandara" . "</td>";
        echo "<td>" . "Wajib Pajak" . "</td>";
        echo "<td>" . "Jumlah Karyawan" . "</td>";
        echo "<td>" . "Tanggal Tutup" . "</td>";
        echo "<td>" . "Parkir Luas" . "</td>";
        echo "<td>" . "Parkir Masuk" . "</td>";
        echo "<td>" . "Parkir Tarif Mobil" . "</td>";
        echo "<td>" . "Parkir Tambahan" . "</td>";
        echo "<td>" . "Parkir Kapasitas Mobil" . "</td>";
        echo "<td>" . "Parkir Mobil Hari" . "</td>";
        echo "<td>" . "Parkir Keluar" . "</td>";
        echo "<td>" . "Parkir Motor Luas" . "</td>";
        echo "<td>" . "Parkir Motor Masuk" . "</td>";
        echo "<td>" . "Parkir Motor Keluar" . "</td>";
        echo "<td>" . "Parkir Tarif Motor" . "</td>";
        echo "<td>" . "Parkir Motor Tambahan" . "</td>";
        echo "<td>" . "Parkir Kapasitas Motor" . "</td>";
        echo "<td>" . "Parkir Motor Hari" . "</td>";
        echo "<td>" . "Kelompok Usaha Id" . "</td>";
        echo "<td>" . "Zona Id" . "</td>";
        echo "<td>" . "Manfaat Id" . "</td>";
        echo "<td>" . "Golongan Id" . "</td>";
        echo "<td>" . "Id Old" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["konterid"] = $pageObject->getViewControl("konterid")->showDBValue($row, "");
        $values["reg_date"] = $pageObject->getViewControl("reg_date")->showDBValue($row, "");
        $values["customer_id"] = $pageObject->getViewControl("customer_id")->showDBValue($row, "");
        $values["usaha_id"] = $pageObject->getViewControl("usaha_id")->showDBValue($row, "");
        $values["so"] = $pageObject->getViewControl("so")->showDBValue($row, "");
        $values["kecamatan_id"] = $pageObject->getViewControl("kecamatan_id")->showDBValue($row, "");
        $values["kelurahan_id"] = $pageObject->getViewControl("kelurahan_id")->showDBValue($row, "");
        $values["notes"] = $pageObject->getViewControl("notes")->showDBValue($row, "");
        $values["enabled"] = $pageObject->getViewControl("enabled")->showDBValue($row, "");
        $values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
        $values["customer_status_id"] = $pageObject->getViewControl("customer_status_id")->showDBValue($row, "");
        $values["aktifnotes"] = $pageObject->getViewControl("aktifnotes")->showDBValue($row, "");
        $values["tmt"] = $pageObject->getViewControl("tmt")->showDBValue($row, "");
        $values["air_zona_id"] = $pageObject->getViewControl("air_zona_id")->showDBValue($row, "");
        $values["air_manfaat_id"] = $pageObject->getViewControl("air_manfaat_id")->showDBValue($row, "");
        $values["def_pajak_id"] = $pageObject->getViewControl("def_pajak_id")->showDBValue($row, "");
        $values["opnm"] = $pageObject->getViewControl("opnm")->showDBValue($row, "");
        $values["opalamat"] = $pageObject->getViewControl("opalamat")->showDBValue($row, "");
        $values["latitude"] = $pageObject->getViewControl("latitude")->showDBValue($row, "");
        $values["longitude"] = $pageObject->getViewControl("longitude")->showDBValue($row, "");
        $values["created"] = $pageObject->getViewControl("created")->showDBValue($row, "");
        $values["updated"] = $pageObject->getViewControl("updated")->showDBValue($row, "");
        $values["update_uid"] = $pageObject->getViewControl("update_uid")->showDBValue($row, "");
        $values["kd_restojmlmeja"] = $pageObject->getViewControl("kd_restojmlmeja")->showDBValue($row, "");
        $values["kd_restojmlkursi"] = $pageObject->getViewControl("kd_restojmlkursi")->showDBValue($row, "");
        $values["kd_restojmltamu"] = $pageObject->getViewControl("kd_restojmltamu")->showDBValue($row, "");
        $values["kd_filmkursi"] = $pageObject->getViewControl("kd_filmkursi")->showDBValue($row, "");
        $values["kd_filmpertunjukan"] = $pageObject->getViewControl("kd_filmpertunjukan")->showDBValue($row, "");
        $values["kd_filmtarif"] = $pageObject->getViewControl("kd_filmtarif")->showDBValue($row, "");
        $values["kd_bilyarmeja"] = $pageObject->getViewControl("kd_bilyarmeja")->showDBValue($row, "");

开发者ID:aagusti，项目名称:padl-tng，代码行数:67，代码来源:pad_pad_customer_usaha_export.php

示例3: WriteTableData

function WriteTableData()
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj;
    if ($eventObj->exists("ListFetchArray")) {
        $row = $eventObj->ListFetchArray($rs);
    } else {
        $row = db_fetch_array($rs);
    }
    //	if(!$row)
    //		return;
    // write header
    echo "<tr>";
    if ($_REQUEST["type"] == "excel") {
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Module_ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Anomaly_Description")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Anomaly_Type")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Date_Time")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Anomalies", "Action_Taken")) . '</td>';
    } else {
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "Module_ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "Anomaly_Description") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "Anomaly_Type") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "Date_Time") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Anomalies", "Action_Taken") . "</td>";
    }
    echo "</tr>";
    $totals["ID"] = 0;
    $totalsFields[] = array('fName' => "ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Module ID"] = 0;
    $totalsFields[] = array('fName' => "Module ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Anomaly Description"] = 0;
    $totalsFields[] = array('fName' => "Anomaly Description", 'totalsType' => '', 'viewFormat' => "");
    $totals["Anomaly Type"] = 0;
    $totalsFields[] = array('fName' => "Anomaly Type", 'totalsType' => '', 'viewFormat' => "");
    $totals["Date Time"] = 0;
    $totalsFields[] = array('fName' => "Date Time", 'totalsType' => '', 'viewFormat' => "Short Date");
    $totals["Action Taken"] = 0;
    $totalsFields[] = array('fName' => "Action Taken", 'totalsType' => '', 'viewFormat' => "");
    $totals = array();
    // write data rows
    $iNumberOfRows = 0;
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $format = "";
        $values["ID"] = GetData($row, "ID", $format);
        $values["Module ID"] = "";
        if (strlen($row["Module ID"])) {
            $values["Module ID"] = DisplayLookupWizard("Module ID", $row["Module ID"], $row, "", MODE_EXPORT);
        }
        $format = "";
        $values["Anomaly Description"] = GetData($row, "Anomaly Description", $format);
        $values["Anomaly Type"] = "";
        if (strlen($row["Anomaly Type"])) {
            $values["Anomaly Type"] = DisplayLookupWizard("Anomaly Type", $row["Anomaly Type"], $row, "", MODE_EXPORT);
        }
        $format = "Short Date";
        $values["Date Time"] = GetData($row, "Date Time", $format);
        $values["Action Taken"] = "";
        if (strlen($row["Action Taken"])) {
            $values["Action Taken"] = DisplayLookupWizard("Action Taken", $row["Action Taken"], $row, "", MODE_EXPORT);
        }
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            $format = "";
            echo htmlspecialchars($values["ID"]);
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["Module ID"]);
            } else {
                echo htmlspecialchars($values["Module ID"]);
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            $format = "";
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["Anomaly Description"]);
            } else {
                echo htmlspecialchars($values["Anomaly Description"]);
            }
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["Anomaly Type"]);
            } else {
                echo htmlspecialchars($values["Anomaly Type"]);
            }
//.........这里部分代码省略.........

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:101，代码来源:Anomalies_export.php

示例4: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Daftar Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Status Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Date") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Uid") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Keterangan") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Daftar Id" . "</td>";
        echo "<td>" . "Status Id" . "</td>";
        echo "<td>" . "Create Date" . "</td>";
        echo "<td>" . "Create Uid" . "</td>";
        echo "<td>" . "Keterangan" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["daftar_id"] = $pageObject->getViewControl("daftar_id")->showDBValue($row, "");
        $values["status_id"] = $pageObject->getViewControl("status_id")->showDBValue($row, "");
        $values["create_date"] = $pageObject->getViewControl("create_date")->showDBValue($row, "");
        $values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
        $values["keterangan"] = $pageObject->getViewControl("keterangan")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["daftar_id"]);
            } else {
                echo $values["daftar_id"];
            }
            //echo htmlspecialchars($values["daftar_id"]); commented for bug #6823
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["status_id"]);
            } else {
                echo $values["status_id"];
            }
            //echo htmlspecialchars($values["status_id"]); commented for bug #6823
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["create_date"]);
            } else {
                echo $values["create_date"];
            }
            echo '</td>';
            echo '<td>';
            echo $values["create_uid"];
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["keterangan"]);
            } else {
                echo $values["keterangan"];
            }
            echo '</td>';
            echo "</tr>";
        }
        if ($eventObj->exists("ListFetchArray")) {
            $row = $eventObj->ListFetchArray($rs, $pageObject);
        } else {
            $row = $cipherer->DecryptFetchedArray($rs);
        }
    }
}

开发者ID:aagusti，项目名称:padl-tng，代码行数:96，代码来源:pad_pad_daftar_hist_export.php

示例5: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Pajak Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tarif") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Reklame") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Minimal Omset") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tmt") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Created") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Uid") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Updated") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Update Uid") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Pajak Id" . "</td>";
        echo "<td>" . "Tarif" . "</td>";
        echo "<td>" . "Reklame" . "</td>";
        echo "<td>" . "Minimal Omset" . "</td>";
        echo "<td>" . "Tmt" . "</td>";
        echo "<td>" . "Enabled" . "</td>";
        echo "<td>" . "Created" . "</td>";
        echo "<td>" . "Create Uid" . "</td>";
        echo "<td>" . "Updated" . "</td>";
        echo "<td>" . "Update Uid" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["pajak_id"] = $pageObject->getViewControl("pajak_id")->showDBValue($row, "");
        $values["tarif"] = $pageObject->getViewControl("tarif")->showDBValue($row, "");
        $values["reklame"] = $pageObject->getViewControl("reklame")->showDBValue($row, "");
        $values["minimal_omset"] = $pageObject->getViewControl("minimal_omset")->showDBValue($row, "");
        $values["tmt"] = $pageObject->getViewControl("tmt")->showDBValue($row, "");
        $values["enabled"] = $pageObject->getViewControl("enabled")->showDBValue($row, "");
        $values["created"] = $pageObject->getViewControl("created")->showDBValue($row, "");
        $values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
        $values["updated"] = $pageObject->getViewControl("updated")->showDBValue($row, "");
        $values["update_uid"] = $pageObject->getViewControl("update_uid")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["pajak_id"]);
            } else {
                echo $values["pajak_id"];
            }
            //echo htmlspecialchars($values["pajak_id"]); commented for bug #6823
            echo '</td>';
            echo '<td>';
            echo $values["tarif"];
            echo '</td>';
            echo '<td>';
            echo $values["reklame"];
            echo '</td>';
            echo '<td>';
            echo $values["minimal_omset"];
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["tmt"]);
            } else {
                echo $values["tmt"];
            }
            echo '</td>';
            echo '<td>';
            echo $values["enabled"];
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["created"]);
            } else {
                echo $values["created"];
            }
            echo '</td>';
            echo '<td>';
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:pad_pad_tarif_pajak_export.php

示例6: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sspd Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tahun") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sspdno") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Spt Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Old Spt Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Wp") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bunga") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Denda") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bayar") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tgl") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Sspd Id" . "</td>";
        echo "<td>" . "Tahun" . "</td>";
        echo "<td>" . "Sspdno" . "</td>";
        echo "<td>" . "Spt Id" . "</td>";
        echo "<td>" . "Old Spt Id" . "</td>";
        echo "<td>" . "Wp" . "</td>";
        echo "<td>" . "Bunga" . "</td>";
        echo "<td>" . "Denda" . "</td>";
        echo "<td>" . "Bayar" . "</td>";
        echo "<td>" . "Tgl" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["sspd_id"] = $pageObject->getViewControl("sspd_id")->showDBValue($row, "");
        $values["tahun"] = $pageObject->getViewControl("tahun")->showDBValue($row, "");
        $values["sspdno"] = $pageObject->getViewControl("sspdno")->showDBValue($row, "");
        $values["spt_id"] = $pageObject->getViewControl("spt_id")->showDBValue($row, "");
        $values["old_spt_id"] = $pageObject->getViewControl("old_spt_id")->showDBValue($row, "");
        $values["wp"] = $pageObject->getViewControl("wp")->showDBValue($row, "");
        $values["bunga"] = $pageObject->getViewControl("bunga")->showDBValue($row, "");
        $values["denda"] = $pageObject->getViewControl("denda")->showDBValue($row, "");
        $values["bayar"] = $pageObject->getViewControl("bayar")->showDBValue($row, "");
        $values["tgl"] = $pageObject->getViewControl("tgl")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            echo '<td>';
            echo $values["sspd_id"];
            echo '</td>';
            echo '<td>';
            echo $values["tahun"];
            echo '</td>';
            echo '<td>';
            echo $values["sspdno"];
            echo '</td>';
            echo '<td>';
            echo $values["spt_id"];
            echo '</td>';
            echo '<td>';
            echo $values["old_spt_id"];
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["wp"]);
            } else {
                echo $values["wp"];
            }
            echo '</td>';
            echo '<td>';
            echo $values["bunga"];
            echo '</td>';
            echo '<td>';
            echo $values["denda"];
            echo '</td>';
            echo '<td>';
            echo $values["bayar"];
            echo '</td>';
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:pad_tmp_bayar_export.php

示例7: WriteTableData


//.........这里部分代码省略.........
        echo "<td>" . "Create Uid" . "</td>";
        echo "<td>" . "Write Date" . "</td>";
        echo "<td>" . "Write Uid" . "</td>";
        echo "<td>" . "Op Nm" . "</td>";
        echo "<td>" . "Op Alamat" . "</td>";
        echo "<td>" . "Op Usaha Id" . "</td>";
        echo "<td>" . "Op So" . "</td>";
        echo "<td>" . "Op Kecamatan Id" . "</td>";
        echo "<td>" . "Op Kelurahan Id" . "</td>";
        echo "<td>" . "Op Latitude" . "</td>";
        echo "<td>" . "Op Longitude" . "</td>";
        echo "<td>" . "Kd Restojmlmeja" . "</td>";
        echo "<td>" . "Kd Restojmlkursi" . "</td>";
        echo "<td>" . "Kd Restojmltamu" . "</td>";
        echo "<td>" . "Kd Filmkursi" . "</td>";
        echo "<td>" . "Kd Filmpertunjukan" . "</td>";
        echo "<td>" . "Kd Filmtarif" . "</td>";
        echo "<td>" . "Kd Bilyarmeja" . "</td>";
        echo "<td>" . "Kd Bilyartarif" . "</td>";
        echo "<td>" . "Kd Bilyarkegiatan" . "</td>";
        echo "<td>" . "Kd Diskopengunjung" . "</td>";
        echo "<td>" . "Kd Diskotarif" . "</td>";
        echo "<td>" . "Kd Waletvolume" . "</td>";
        echo "<td>" . "Email" . "</td>";
        echo "<td>" . "Op Pajak Id" . "</td>";
        echo "<td>" . "Npwpd" . "</td>";
        echo "<td>" . "Passwd" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["rp"] = $pageObject->getViewControl("rp")->showDBValue($row, "");
        $values["pb"] = $pageObject->getViewControl("pb")->showDBValue($row, "");
        $values["formno"] = $pageObject->getViewControl("formno")->showDBValue($row, "");
        $values["reg_date"] = $pageObject->getViewControl("reg_date")->showDBValue($row, "");
        $values["customernm"] = $pageObject->getViewControl("customernm")->showDBValue($row, "");
        $values["kecamatan_id"] = $pageObject->getViewControl("kecamatan_id")->showDBValue($row, "");
        $values["kelurahan_id"] = $pageObject->getViewControl("kelurahan_id")->showDBValue($row, "");
        $values["kabupaten"] = $pageObject->getViewControl("kabupaten")->showDBValue($row, "");
        $values["alamat"] = $pageObject->getViewControl("alamat")->showDBValue($row, "");
        $values["kodepos"] = $pageObject->getViewControl("kodepos")->showDBValue($row, "");
        $values["telphone"] = $pageObject->getViewControl("telphone")->showDBValue($row, "");
        $values["wpnama"] = $pageObject->getViewControl("wpnama")->showDBValue($row, "");
        $values["wpalamat"] = $pageObject->getViewControl("wpalamat")->showDBValue($row, "");
        $values["wpkelurahan"] = $pageObject->getViewControl("wpkelurahan")->showDBValue($row, "");
        $values["wpkecamatan"] = $pageObject->getViewControl("wpkecamatan")->showDBValue($row, "");
        $values["wpkabupaten"] = $pageObject->getViewControl("wpkabupaten")->showDBValue($row, "");
        $values["wptelp"] = $pageObject->getViewControl("wptelp")->showDBValue($row, "");
        $values["wpkodepos"] = $pageObject->getViewControl("wpkodepos")->showDBValue($row, "");
        $values["pnama"] = $pageObject->getViewControl("pnama")->showDBValue($row, "");
        $values["palamat"] = $pageObject->getViewControl("palamat")->showDBValue($row, "");
        $values["pkelurahan"] = $pageObject->getViewControl("pkelurahan")->showDBValue($row, "");
        $values["pkecamatan"] = $pageObject->getViewControl("pkecamatan")->showDBValue($row, "");
        $values["pkabupaten"] = $pageObject->getViewControl("pkabupaten")->showDBValue($row, "");
        $values["ptelp"] = $pageObject->getViewControl("ptelp")->showDBValue($row, "");
        $values["pkodepos"] = $pageObject->getViewControl("pkodepos")->showDBValue($row, "");
        $values["ijin1"] = $pageObject->getViewControl("ijin1")->showDBValue($row, "");
        $values["ijin1no"] = $pageObject->getViewControl("ijin1no")->showDBValue($row, "");
        $values["ijin1tgl"] = $pageObject->getViewControl("ijin1tgl")->showDBValue($row, "");
        $values["ijin1tglakhir"] = $pageObject->getViewControl("ijin1tglakhir")->showDBValue($row, "");
        $values["ijin2"] = $pageObject->getViewControl("ijin2")->showDBValue($row, "");

开发者ID:aagusti，项目名称:padl-tng，代码行数:67，代码来源:pad_pad_daftar_export.php

示例8: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Nip2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Pejabatnm2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Jabatan2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Golongan2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Pangkat2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tmt2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled2") . '</td>';
    } else {
        echo "<td>" . "Id2" . "</td>";
        echo "<td>" . "Nip2" . "</td>";
        echo "<td>" . "Pejabatnm2" . "</td>";
        echo "<td>" . "Jabatan2" . "</td>";
        echo "<td>" . "Golongan2" . "</td>";
        echo "<td>" . "Pangkat2" . "</td>";
        echo "<td>" . "Tmt2" . "</td>";
        echo "<td>" . "Enabled2" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id2"] = $pageObject->getViewControl("id2")->showDBValue($row, "");
        $values["nip2"] = $pageObject->getViewControl("nip2")->showDBValue($row, "");
        $values["pejabatnm2"] = $pageObject->getViewControl("pejabatnm2")->showDBValue($row, "");
        $values["jabatan2"] = $pageObject->getViewControl("jabatan2")->showDBValue($row, "");
        $values["golongan2"] = $pageObject->getViewControl("golongan2")->showDBValue($row, "");
        $values["pangkat2"] = $pageObject->getViewControl("pangkat2")->showDBValue($row, "");
        $values["tmt2"] = $pageObject->getViewControl("tmt2")->showDBValue($row, "");
        $values["enabled2"] = $pageObject->getViewControl("enabled2")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id2"];
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["nip2"]);
            } else {
                echo $values["nip2"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["pejabatnm2"]);
            } else {
                echo $values["pejabatnm2"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["jabatan2"]);
            } else {
                echo $values["jabatan2"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["golongan2"]);
            } else {
                echo $values["golongan2"];
            }
            echo '</td>';
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:public_tblpejabat2_export.php

示例9: WriteTableData


//.........这里部分代码省略.........
        echo "<td>" . "Ijin4tglakhir" . "</td>";
        echo "<td>" . "Kukuhno" . "</td>";
        echo "<td>" . "Kukuhnip" . "</td>";
        echo "<td>" . "Kukuhtgl" . "</td>";
        echo "<td>" . "Kukuh Jabat Id" . "</td>";
        echo "<td>" . "Kukuhprinted" . "</td>";
        echo "<td>" . "Enabled" . "</td>";
        echo "<td>" . "Create Uid" . "</td>";
        echo "<td>" . "Tmt" . "</td>";
        echo "<td>" . "Customer Status Id" . "</td>";
        echo "<td>" . "Kembalitgl" . "</td>";
        echo "<td>" . "Kembalioleh" . "</td>";
        echo "<td>" . "Kartuprinted" . "</td>";
        echo "<td>" . "Kembalinip" . "</td>";
        echo "<td>" . "Penerimanm" . "</td>";
        echo "<td>" . "Penerimaalamat" . "</td>";
        echo "<td>" . "Penerimatgl" . "</td>";
        echo "<td>" . "Catatnip" . "</td>";
        echo "<td>" . "Kirimtgl" . "</td>";
        echo "<td>" . "Batastgl" . "</td>";
        echo "<td>" . "Petugas Jabat Id" . "</td>";
        echo "<td>" . "Pencatat Jabat Id" . "</td>";
        echo "<td>" . "Created" . "</td>";
        echo "<td>" . "Updated" . "</td>";
        echo "<td>" . "Update Uid" . "</td>";
        echo "<td>" . "Npwpd Old" . "</td>";
        echo "<td>" . "Id Old" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["parent"] = $pageObject->getViewControl("parent")->showDBValue($row, "");
        $values["npwpd"] = $pageObject->getViewControl("npwpd")->showDBValue($row, "");
        $values["rp"] = $pageObject->getViewControl("rp")->showDBValue($row, "");
        $values["pb"] = $pageObject->getViewControl("pb")->showDBValue($row, "");
        $values["formno"] = $pageObject->getViewControl("formno")->showDBValue($row, "");
        $values["reg_date"] = $pageObject->getViewControl("reg_date")->showDBValue($row, "");
        $values["nama"] = $pageObject->getViewControl("nama")->showDBValue($row, "");
        $values["kecamatan_id"] = $pageObject->getViewControl("kecamatan_id")->showDBValue($row, "");
        $values["kelurahan_id"] = $pageObject->getViewControl("kelurahan_id")->showDBValue($row, "");
        $values["kabupaten"] = $pageObject->getViewControl("kabupaten")->showDBValue($row, "");
        $values["alamat"] = $pageObject->getViewControl("alamat")->showDBValue($row, "");
        $values["kodepos"] = $pageObject->getViewControl("kodepos")->showDBValue($row, "");
        $values["telphone"] = $pageObject->getViewControl("telphone")->showDBValue($row, "");
        $values["wpnama"] = $pageObject->getViewControl("wpnama")->showDBValue($row, "");
        $values["wpalamat"] = $pageObject->getViewControl("wpalamat")->showDBValue($row, "");
        $values["wpkelurahan"] = $pageObject->getViewControl("wpkelurahan")->showDBValue($row, "");
        $values["wpkecamatan"] = $pageObject->getViewControl("wpkecamatan")->showDBValue($row, "");
        $values["wpkabupaten"] = $pageObject->getViewControl("wpkabupaten")->showDBValue($row, "");
        $values["wptelp"] = $pageObject->getViewControl("wptelp")->showDBValue($row, "");
        $values["wpkodepos"] = $pageObject->getViewControl("wpkodepos")->showDBValue($row, "");
        $values["pnama"] = $pageObject->getViewControl("pnama")->showDBValue($row, "");
        $values["palamat"] = $pageObject->getViewControl("palamat")->showDBValue($row, "");
        $values["pkelurahan"] = $pageObject->getViewControl("pkelurahan")->showDBValue($row, "");
        $values["pkecamatan"] = $pageObject->getViewControl("pkecamatan")->showDBValue($row, "");
        $values["pkabupaten"] = $pageObject->getViewControl("pkabupaten")->showDBValue($row, "");
        $values["ptelp"] = $pageObject->getViewControl("ptelp")->showDBValue($row, "");
        $values["pkodepos"] = $pageObject->getViewControl("pkodepos")->showDBValue($row, "");
        $values["ijin1"] = $pageObject->getViewControl("ijin1")->showDBValue($row, "");
        $values["ijin1no"] = $pageObject->getViewControl("ijin1no")->showDBValue($row, "");
        $values["ijin1tgl"] = $pageObject->getViewControl("ijin1tgl")->showDBValue($row, "");

开发者ID:aagusti，项目名称:padl-tng，代码行数:67，代码来源:pad_pad_customer_export.php

示例10: WriteTableData

function WriteTableData()
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj;
    if ($eventObj->exists("ListFetchArray")) {
        $row = $eventObj->ListFetchArray($rs);
    } else {
        $row = db_fetch_array($rs);
    }
    //	if(!$row)
    //		return;
    // write header
    echo "<tr>";
    if ($_REQUEST["type"] == "excel") {
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Bill_ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Customer_ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Bill_Month")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Previous_Readings")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Currunt_Readings")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Unit_Consumed")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Bill_Amount")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Month_Billings", "Due_Date")) . '</td>';
    } else {
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Bill_ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Customer_ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Bill_Month") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Previous_Readings") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Currunt_Readings") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Unit_Consumed") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Bill_Amount") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Month_Billings", "Due_Date") . "</td>";
    }
    echo "</tr>";
    $totals["Bill ID"] = 0;
    $totalsFields[] = array('fName' => "Bill ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Customer ID"] = 0;
    $totalsFields[] = array('fName' => "Customer ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Bill Month"] = 0;
    $totalsFields[] = array('fName' => "Bill Month", 'totalsType' => '', 'viewFormat' => "");
    $totals["Previous Readings"] = 0;
    $totalsFields[] = array('fName' => "Previous Readings", 'totalsType' => '', 'viewFormat' => "");
    $totals["Currunt Readings"] = 0;
    $totalsFields[] = array('fName' => "Currunt Readings", 'totalsType' => '', 'viewFormat' => "");
    $totals["Unit Consumed"] = 0;
    $totalsFields[] = array('fName' => "Unit Consumed", 'totalsType' => '', 'viewFormat' => "");
    $totals["Bill Amount"] = 0;
    $totalsFields[] = array('fName' => "Bill Amount", 'totalsType' => '', 'viewFormat' => "");
    $totals["Due Date"] = 0;
    $totalsFields[] = array('fName' => "Due Date", 'totalsType' => '', 'viewFormat' => "");
    $totals = array();
    // write data rows
    $iNumberOfRows = 0;
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $format = "";
        $values["Bill ID"] = GetData($row, "Bill ID", $format);
        $format = "";
        $values["Customer ID"] = GetData($row, "Customer ID", $format);
        $format = "";
        $values["Bill Month"] = GetData($row, "Bill Month", $format);
        $format = "";
        $values["Previous Readings"] = GetData($row, "Previous Readings", $format);
        $format = "";
        $values["Currunt Readings"] = GetData($row, "Currunt Readings", $format);
        $format = "";
        $values["Unit Consumed"] = GetData($row, "Unit Consumed", $format);
        $format = "";
        $values["Bill Amount"] = GetData($row, "Bill Amount", $format);
        $format = "";
        $values["Due Date"] = GetData($row, "Due Date", $format);
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            $format = "";
            echo htmlspecialchars($values["Bill ID"]);
            echo '</td>';
            echo '<td>';
            $format = "";
            echo htmlspecialchars($values["Customer ID"]);
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            $format = "";
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["Bill Month"]);
            } else {
                echo htmlspecialchars($values["Bill Month"]);
            }
            echo '</td>';
            echo '<td>';
            $format = "";
            echo htmlspecialchars($values["Previous Readings"]);
//.........这里部分代码省略.........

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:101，代码来源:Month_Billings_export.php

示例11: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Rekening Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Status Anggaran") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Target") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan1") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan3") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan4") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan5") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan6") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan7") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan8") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan9") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan10") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan11") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bulan12") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Jumlah") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Created") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Updated") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Uid") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Update Uid") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tahun") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Rekening Id" . "</td>";
        echo "<td>" . "Status Anggaran" . "</td>";
        echo "<td>" . "Target" . "</td>";
        echo "<td>" . "Bulan1" . "</td>";
        echo "<td>" . "Bulan2" . "</td>";
        echo "<td>" . "Bulan3" . "</td>";
        echo "<td>" . "Bulan4" . "</td>";
        echo "<td>" . "Bulan5" . "</td>";
        echo "<td>" . "Bulan6" . "</td>";
        echo "<td>" . "Bulan7" . "</td>";
        echo "<td>" . "Bulan8" . "</td>";
        echo "<td>" . "Bulan9" . "</td>";
        echo "<td>" . "Bulan10" . "</td>";
        echo "<td>" . "Bulan11" . "</td>";
        echo "<td>" . "Bulan12" . "</td>";
        echo "<td>" . "Jumlah" . "</td>";
        echo "<td>" . "Created" . "</td>";
        echo "<td>" . "Updated" . "</td>";
        echo "<td>" . "Create Uid" . "</td>";
        echo "<td>" . "Update Uid" . "</td>";
        echo "<td>" . "Tahun" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["rekening_id"] = $pageObject->getViewControl("rekening_id")->showDBValue($row, "");
        $values["status_anggaran"] = $pageObject->getViewControl("status_anggaran")->showDBValue($row, "");
        $values["target"] = $pageObject->getViewControl("target")->showDBValue($row, "");
        $values["bulan1"] = $pageObject->getViewControl("bulan1")->showDBValue($row, "");
        $values["bulan2"] = $pageObject->getViewControl("bulan2")->showDBValue($row, "");
        $values["bulan3"] = $pageObject->getViewControl("bulan3")->showDBValue($row, "");
        $values["bulan4"] = $pageObject->getViewControl("bulan4")->showDBValue($row, "");
        $values["bulan5"] = $pageObject->getViewControl("bulan5")->showDBValue($row, "");
        $values["bulan6"] = $pageObject->getViewControl("bulan6")->showDBValue($row, "");
        $values["bulan7"] = $pageObject->getViewControl("bulan7")->showDBValue($row, "");
        $values["bulan8"] = $pageObject->getViewControl("bulan8")->showDBValue($row, "");
        $values["bulan9"] = $pageObject->getViewControl("bulan9")->showDBValue($row, "");
        $values["bulan10"] = $pageObject->getViewControl("bulan10")->showDBValue($row, "");
        $values["bulan11"] = $pageObject->getViewControl("bulan11")->showDBValue($row, "");
        $values["bulan12"] = $pageObject->getViewControl("bulan12")->showDBValue($row, "");
        $values["jumlah"] = $pageObject->getViewControl("jumlah")->showDBValue($row, "");
        $values["created"] = $pageObject->getViewControl("created")->showDBValue($row, "");
        $values["updated"] = $pageObject->getViewControl("updated")->showDBValue($row, "");
        $values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
        $values["update_uid"] = $pageObject->getViewControl("update_uid")->showDBValue($row, "");
        $values["tahun"] = $pageObject->getViewControl("tahun")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            echo '<td>';
            if ($_REQUEST["type"] == "excel") {
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:pad_pad_anggaran_export.php

示例12: WriteTableData

function WriteTableData()
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj;
    if ($eventObj->exists("ListFetchArray")) {
        $row = $eventObj->ListFetchArray($rs);
    } else {
        $row = db_fetch_array($rs);
    }
    //	if(!$row)
    //		return;
    // write header
    echo "<tr>";
    if ($_REQUEST["type"] == "excel") {
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Record_ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Module_ID")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Voltage_Red")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Voltage_Blue")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Voltage_Yellow")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Currunt_Red")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Currunt_Blue")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Currunt_Yellow")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "PF_Red")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "PF_Blue")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "PF_Yellow")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Peak_Power")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Date_Time")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "IsSync")) . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_Readings", "Currunt_Readings")) . '</td>';
    } else {
        echo "<td>" . GetFieldLabel("dbo_Readings", "Record_ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Module_ID") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Voltage_Red") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Voltage_Blue") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Voltage_Yellow") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Currunt_Red") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Currunt_Blue") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Currunt_Yellow") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "PF_Red") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "PF_Blue") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "PF_Yellow") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Peak_Power") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Date_Time") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "IsSync") . "</td>";
        echo "<td>" . GetFieldLabel("dbo_Readings", "Currunt_Readings") . "</td>";
    }
    echo "</tr>";
    $totals["Record ID"] = 0;
    $totalsFields[] = array('fName' => "Record ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Module ID"] = 0;
    $totalsFields[] = array('fName' => "Module ID", 'totalsType' => '', 'viewFormat' => "");
    $totals["Voltage Red"] = 0;
    $totalsFields[] = array('fName' => "Voltage Red", 'totalsType' => '', 'viewFormat' => "");
    $totals["Voltage Blue"] = 0;
    $totalsFields[] = array('fName' => "Voltage Blue", 'totalsType' => '', 'viewFormat' => "");
    $totals["Voltage Yellow"] = 0;
    $totalsFields[] = array('fName' => "Voltage Yellow", 'totalsType' => '', 'viewFormat' => "");
    $totals["Currunt Red"] = 0;
    $totalsFields[] = array('fName' => "Currunt Red", 'totalsType' => '', 'viewFormat' => "");
    $totals["Currunt Blue"] = 0;
    $totalsFields[] = array('fName' => "Currunt Blue", 'totalsType' => '', 'viewFormat' => "");
    $totals["Currunt Yellow"] = 0;
    $totalsFields[] = array('fName' => "Currunt Yellow", 'totalsType' => '', 'viewFormat' => "");
    $totals["PF Red"] = 0;
    $totalsFields[] = array('fName' => "PF Red", 'totalsType' => '', 'viewFormat' => "");
    $totals["PF Blue"] = 0;
    $totalsFields[] = array('fName' => "PF Blue", 'totalsType' => '', 'viewFormat' => "");
    $totals["PF Yellow"] = 0;
    $totalsFields[] = array('fName' => "PF Yellow", 'totalsType' => '', 'viewFormat' => "");
    $totals["Peak Power"] = 0;
    $totalsFields[] = array('fName' => "Peak Power", 'totalsType' => '', 'viewFormat' => "");
    $totals["Date Time"] = 0;
    $totalsFields[] = array('fName' => "Date Time", 'totalsType' => '', 'viewFormat' => "Short Date");
    $totals["IsSync"] = 0;
    $totalsFields[] = array('fName' => "IsSync", 'totalsType' => '', 'viewFormat' => "Checkbox");
    $totals["Currunt Readings"] = 0;
    $totalsFields[] = array('fName' => "Currunt Readings", 'totalsType' => '', 'viewFormat' => "");
    $totals = array();
    // write data rows
    $iNumberOfRows = 0;
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $format = "";
        $values["Record ID"] = GetData($row, "Record ID", $format);
        $values["Module ID"] = "";
        if (strlen($row["Module ID"])) {
            $values["Module ID"] = DisplayLookupWizard("Module ID", $row["Module ID"], $row, "", MODE_EXPORT);
        }
        $format = "";
        $values["Voltage Red"] = GetData($row, "Voltage Red", $format);
        $format = "";
        $values["Voltage Blue"] = GetData($row, "Voltage Blue", $format);
        $format = "";
        $values["Voltage Yellow"] = GetData($row, "Voltage Yellow", $format);
        $format = "";
        $values["Currunt Red"] = GetData($row, "Currunt Red", $format);
        $format = "";
        $values["Currunt Blue"] = GetData($row, "Currunt Blue", $format);
        $format = "";
        $values["Currunt Yellow"] = GetData($row, "Currunt Yellow", $format);
//.........这里部分代码省略.........

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:101，代码来源:Readings_export.php

示例13: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Spt Type Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Usaha Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sptnm") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sknm") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Nhnm") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sspdnm") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Stpnm") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Kartudtnm") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Spt Type Id" . "</td>";
        echo "<td>" . "Usaha Id" . "</td>";
        echo "<td>" . "Sptnm" . "</td>";
        echo "<td>" . "Sknm" . "</td>";
        echo "<td>" . "Nhnm" . "</td>";
        echo "<td>" . "Sspdnm" . "</td>";
        echo "<td>" . "Stpnm" . "</td>";
        echo "<td>" . "Kartudtnm" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["spt_type_id"] = $pageObject->getViewControl("spt_type_id")->showDBValue($row, "");
        $values["usaha_id"] = $pageObject->getViewControl("usaha_id")->showDBValue($row, "");
        $values["sptnm"] = $pageObject->getViewControl("sptnm")->showDBValue($row, "");
        $values["sknm"] = $pageObject->getViewControl("sknm")->showDBValue($row, "");
        $values["nhnm"] = $pageObject->getViewControl("nhnm")->showDBValue($row, "");
        $values["sspdnm"] = $pageObject->getViewControl("sspdnm")->showDBValue($row, "");
        $values["stpnm"] = $pageObject->getViewControl("stpnm")->showDBValue($row, "");
        $values["kartudtnm"] = $pageObject->getViewControl("kartudtnm")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            echo '<td>';
            echo $values["spt_type_id"];
            echo '</td>';
            echo '<td>';
            echo $values["usaha_id"];
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["sptnm"]);
            } else {
                echo $values["sptnm"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["sknm"]);
            } else {
                echo $values["sknm"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["nhnm"]);
            } else {
                echo $values["nhnm"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:pad_pad_report_export.php

示例14: WriteTableData

 /**
  * @param Mixed rs
  * @param Number nPageSize
  */
 protected function WriteTableData($rs, $nPageSize)
 {
     $exportFields = $this->pSet->getExportFields();
     $totalFieldsData = $this->pSet->getTotalsFields();
     if ($this->eventsObject->exists("ListFetchArray")) {
         $row = $this->eventsObject->ListFetchArray($rs, $this);
     } else {
         $row = $this->cipherer->DecryptFetchedArray($this->connection->fetch_array($rs));
     }
     // write header
     echo "<tr>";
     if ($_REQUEST["type"] == "excel") {
         foreach ($exportFields as $field) {
             echo '<td style="width: 100" x:str>' . PrepareForExcel($this->pSet->label($field)) . '</td>';
         }
     } else {
         foreach ($exportFields as $field) {
             echo "<td>" . $this->pSet->label($field) . "</td>";
         }
     }
     echo "</tr>";
     $totals = array();
     $totalsFields = array();
     foreach ($totalFieldsData as $data) {
         if (!in_array($data["fName"], $exportFields)) {
             continue;
         }
         $totals[$data["fName"]] = array("value" => 0, "numRows" => 0);
         $totalsFields[] = array('fName' => $data["fName"], 'totalsType' => $data["totalsType"], 'viewFormat' => $this->pSet->getViewFormat($data["fName"]));
     }
     // write data rows
     $iNumberOfRows = 0;
     $this->viewControls->forExport = "export";
     while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
         countTotals($totals, $totalsFields, $row);
         $values = array();
         foreach ($exportFields as $field) {
             $fType = $this->pSet->getFieldType($field);
             if (IsBinaryType($fType)) {
                 $values[$field] = "código binario demasiado grande – no puede ser desplegado";
             } else {
                 $values[$field] = $this->getViewControl($field)->getExportValue($row, "");
             }
         }
         $eventRes = true;
         if ($this->eventsObject->exists('BeforeOut')) {
             $eventRes = $this->eventsObject->BeforeOut($row, $values, $this);
         }
         if ($eventRes) {
             $iNumberOfRows++;
             echo "<tr>";
             foreach ($exportFields as $field) {
                 $fType = $this->pSet->getFieldType($field);
                 if (IsCharType($fType)) {
                     if ($_REQUEST["type"] == "excel") {
                         echo '<td x:str>';
                     } else {
                         echo '<td>';
                     }
                 } else {
                     echo '<td>';
                 }
                 $editFormat = $this->pSet->getEditFormat($field);
                 if ($editFormat == EDIT_FORMAT_LOOKUP_WIZARD) {
                     if ($this->pSet->NeedEncode($field)) {
                         if ($_REQUEST["type"] == "excel") {
                             echo PrepareForExcel($values[$field]);
                         } else {
                             echo $values[$field];
                         }
                     } else {
                         echo $values[$field];
                     }
                 } elseif (IsBinaryType($fType)) {
                     echo $values[$field];
                 } else {
                     if ($editFormat == FORMAT_CUSTOM || $this->pSet->isUseRTE($field)) {
                         echo $values[$field];
                     } elseif (NeedQuotes($field)) {
                         if ($_REQUEST["type"] == "excel") {
                             echo PrepareForExcel($values[$field]);
                         } else {
                             echo $values[$field];
                         }
                     } else {
                         echo $values[$field];
                     }
                 }
                 echo '</td>';
             }
             echo "</tr>";
         }
         if ($this->eventsObject->exists("ListFetchArray")) {
             $row = $this->eventsObject->ListFetchArray($rs, $this);
         } else {
             $row = $this->cipherer->DecryptFetchedArray($this->connection->fetch_array($rs));
//.........这里部分代码省略.........

开发者ID:kcallow，项目名称:MatchMe，代码行数:101，代码来源:exportpage.php

示例15: WriteTableData

function WriteTableData($cipherer)
{
    global $rs, $nPageSize, $strTableName, $conn, $eventObj, $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("Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Nama Wp") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Alamat Wp") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Npwpd") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Bayar") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Periode 1") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Periode 2") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Keterangan") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Spt Id Old") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Judul") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Lokasi") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("J") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("P") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("L") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("T") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Sspd Id") . '</td>';
        echo '<td style="width: 100" x:str>' . PrepareForExcel("Tanggal") . '</td>';
    } else {
        echo "<td>" . "Id" . "</td>";
        echo "<td>" . "Nama Wp" . "</td>";
        echo "<td>" . "Alamat Wp" . "</td>";
        echo "<td>" . "Npwpd" . "</td>";
        echo "<td>" . "Bayar" . "</td>";
        echo "<td>" . "Periode 1" . "</td>";
        echo "<td>" . "Periode 2" . "</td>";
        echo "<td>" . "Keterangan" . "</td>";
        echo "<td>" . "Spt Id Old" . "</td>";
        echo "<td>" . "Judul" . "</td>";
        echo "<td>" . "Lokasi" . "</td>";
        echo "<td>" . "J" . "</td>";
        echo "<td>" . "P" . "</td>";
        echo "<td>" . "L" . "</td>";
        echo "<td>" . "T" . "</td>";
        echo "<td>" . "Sspd Id" . "</td>";
        echo "<td>" . "Tanggal" . "</td>";
    }
    echo "</tr>";
    // write data rows
    $iNumberOfRows = 0;
    $pageObject->viewControls->forExport = "export";
    while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
        countTotals($totals, $totalsFields, $row);
        $values = array();
        $values["id"] = $pageObject->getViewControl("id")->showDBValue($row, "");
        $values["nama_wp"] = $pageObject->getViewControl("nama_wp")->showDBValue($row, "");
        $values["alamat_wp"] = $pageObject->getViewControl("alamat_wp")->showDBValue($row, "");
        $values["npwpd"] = $pageObject->getViewControl("npwpd")->showDBValue($row, "");
        $values["bayar"] = $pageObject->getViewControl("bayar")->showDBValue($row, "");
        $values["periode_1"] = $pageObject->getViewControl("periode_1")->showDBValue($row, "");
        $values["periode_2"] = $pageObject->getViewControl("periode_2")->showDBValue($row, "");
        $values["keterangan"] = $pageObject->getViewControl("keterangan")->showDBValue($row, "");
        $values["spt_id_old"] = $pageObject->getViewControl("spt_id_old")->showDBValue($row, "");
        $values["judul"] = $pageObject->getViewControl("judul")->showDBValue($row, "");
        $values["lokasi"] = $pageObject->getViewControl("lokasi")->showDBValue($row, "");
        $values["j"] = $pageObject->getViewControl("j")->showDBValue($row, "");
        $values["p"] = $pageObject->getViewControl("p")->showDBValue($row, "");
        $values["l"] = $pageObject->getViewControl("l")->showDBValue($row, "");
        $values["t"] = $pageObject->getViewControl("t")->showDBValue($row, "");
        $values["sspd_id"] = $pageObject->getViewControl("sspd_id")->showDBValue($row, "");
        $values["tanggal"] = $pageObject->getViewControl("tanggal")->showDBValue($row, "");
        $eventRes = true;
        if ($eventObj->exists('BeforeOut')) {
            $eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
        }
        if ($eventRes) {
            $iNumberOfRows++;
            echo "<tr>";
            echo '<td>';
            echo $values["id"];
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
                echo PrepareForExcel($values["nama_wp"]);
            } else {
                echo $values["nama_wp"];
            }
            echo '</td>';
            if ($_REQUEST["type"] == "excel") {
                echo '<td x:str>';
            } else {
                echo '<td>';
            }
            if ($_REQUEST["type"] == "excel") {
//.........这里部分代码省略.........

开发者ID:aagusti，项目名称:padl-tng，代码行数:101，代码来源:public_tmp_bank2_export.php

注：本文中的countTotals函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。