本文整理汇总了PHP中PrepareForExcel函数的典型用法代码示例。如果您正苦于以下问题：PHP PrepareForExcel函数的具体用法？PHP PrepareForExcel怎么用？PHP PrepareForExcel使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了PrepareForExcel函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: 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("Konterid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Reg Date") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Customer Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Usaha Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("So") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kecamatan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kelurahan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Notes") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Uid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Customer Status Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Aktifnotes") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tmt") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Air Zona Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Air Manfaat Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Def Pajak Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Opnm") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Opalamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Latitude") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Longitude") . '</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("Update Uid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmlmeja") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmlkursi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmltamu") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmkursi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmpertunjukan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmtarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyarmeja") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyartarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyarkegiatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Diskopengunjung") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Diskotarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Mall Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Cash Register") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pelaporan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pembukuan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Bandara") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wajib Pajak") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Jumlah Karyawan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tanggal Tutup") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Luas") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Masuk") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Tarif Mobil") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Tambahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Kapasitas Mobil") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Mobil Hari") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Keluar") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Motor Luas") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Motor Masuk") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Motor Keluar") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Tarif Motor") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Motor Tambahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Kapasitas Motor") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Parkir Motor Hari") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kelompok Usaha Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Zona Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Manfaat Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Golongan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Id Old") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Konterid" . "</td>";
echo "<td>" . "Reg Date" . "</td>";
echo "<td>" . "Customer Id" . "</td>";
echo "<td>" . "Usaha Id" . "</td>";
echo "<td>" . "So" . "</td>";
echo "<td>" . "Kecamatan Id" . "</td>";
echo "<td>" . "Kelurahan Id" . "</td>";
echo "<td>" . "Notes" . "</td>";
echo "<td>" . "Enabled" . "</td>";
echo "<td>" . "Create Uid" . "</td>";
echo "<td>" . "Customer Status Id" . "</td>";
echo "<td>" . "Aktifnotes" . "</td>";
echo "<td>" . "Tmt" . "</td>";
echo "<td>" . "Air Zona Id" . "</td>";
echo "<td>" . "Air Manfaat Id" . "</td>";
echo "<td>" . "Def Pajak Id" . "</td>";
echo "<td>" . "Opnm" . "</td>";
echo "<td>" . "Opalamat" . "</td>";
echo "<td>" . "Latitude" . "</td>";
echo "<td>" . "Longitude" . "</td>";
echo "<td>" . "Created" . "</td>";
echo "<td>" . "Updated" . "</td>";
echo "<td>" . "Update Uid" . "</td>";
//.........这里部分代码省略.........
示例2: 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));
//.........这里部分代码省略.........
示例3: 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") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Nilai") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Update Uid") . '</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("Created") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Singkatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kriteria") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Nama" . "</td>";
echo "<td>" . "Nilai" . "</td>";
echo "<td>" . "Update Uid" . "</td>";
echo "<td>" . "Create Uid" . "</td>";
echo "<td>" . "Updated" . "</td>";
echo "<td>" . "Created" . "</td>";
echo "<td>" . "Singkatan" . "</td>";
echo "<td>" . "Kriteria" . "</td>";
echo "<td>" . "Enabled" . "</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"] = $pageObject->getViewControl("nama")->showDBValue($row, "");
$values["nilai"] = $pageObject->getViewControl("nilai")->showDBValue($row, "");
$values["update_uid"] = $pageObject->getViewControl("update_uid")->showDBValue($row, "");
$values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
$values["updated"] = $pageObject->getViewControl("updated")->showDBValue($row, "");
$values["created"] = $pageObject->getViewControl("created")->showDBValue($row, "");
$values["singkatan"] = $pageObject->getViewControl("singkatan")->showDBValue($row, "");
$values["kriteria"] = $pageObject->getViewControl("kriteria")->showDBValue($row, "");
$values["enabled"] = $pageObject->getViewControl("enabled")->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"]);
} else {
echo $values["nama"];
}
echo '</td>';
echo '<td>';
echo $values["nilai"];
echo '</td>';
echo '<td>';
echo $values["update_uid"];
echo '</td>';
echo '<td>';
echo $values["create_uid"];
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["updated"]);
} else {
echo $values["updated"];
}
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["created"]);
} else {
echo $values["created"];
}
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
} else {
echo '<td>';
//.........这里部分代码省略.........
示例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("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>';
//.........这里部分代码省略.........
示例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("Tahun") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Terimano") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Terimatgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Jmlterima") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Customer Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Npwpd") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Nobukti") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Notes") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</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("Write Date") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Write Uid") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Tahun" . "</td>";
echo "<td>" . "Terimano" . "</td>";
echo "<td>" . "Terimatgl" . "</td>";
echo "<td>" . "Jmlterima" . "</td>";
echo "<td>" . "Customer Id" . "</td>";
echo "<td>" . "Npwpd" . "</td>";
echo "<td>" . "Nobukti" . "</td>";
echo "<td>" . "Notes" . "</td>";
echo "<td>" . "Enabled" . "</td>";
echo "<td>" . "Create Date" . "</td>";
echo "<td>" . "Create Uid" . "</td>";
echo "<td>" . "Write Date" . "</td>";
echo "<td>" . "Write 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["tahun"] = $pageObject->getViewControl("tahun")->showDBValue($row, "");
$values["terimano"] = $pageObject->getViewControl("terimano")->showDBValue($row, "");
$values["terimatgl"] = $pageObject->getViewControl("terimatgl")->showDBValue($row, "");
$values["jmlterima"] = $pageObject->getViewControl("jmlterima")->showDBValue($row, "");
$values["customer_id"] = $pageObject->getViewControl("customer_id")->showDBValue($row, "");
$values["npwpd"] = $pageObject->getViewControl("npwpd")->showDBValue($row, "");
$values["nobukti"] = $pageObject->getViewControl("nobukti")->showDBValue($row, "");
$values["notes"] = $pageObject->getViewControl("notes")->showDBValue($row, "");
$values["enabled"] = $pageObject->getViewControl("enabled")->showDBValue($row, "");
$values["create_date"] = $pageObject->getViewControl("create_date")->showDBValue($row, "");
$values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
$values["write_date"] = $pageObject->getViewControl("write_date")->showDBValue($row, "");
$values["write_uid"] = $pageObject->getViewControl("write_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>';
echo $values["tahun"];
echo '</td>';
echo '<td>';
echo $values["terimano"];
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["terimatgl"]);
} else {
echo $values["terimatgl"];
}
echo '</td>';
echo '<td>';
echo $values["jmlterima"];
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["customer_id"]);
} else {
echo $values["customer_id"];
}
//echo htmlspecialchars($values["customer_id"]); commented for bug #6823
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
//.........这里部分代码省略.........
示例6: 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_User_Roles", "Code")) . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel(GetFieldLabel("dbo_User_Roles", "Role")) . '</td>';
} else {
echo "<td>" . GetFieldLabel("dbo_User_Roles", "Code") . "</td>";
echo "<td>" . GetFieldLabel("dbo_User_Roles", "Role") . "</td>";
}
echo "</tr>";
$totals["Code"] = 0;
$totalsFields[] = array('fName' => "Code", 'totalsType' => '', 'viewFormat' => "");
$totals["Role"] = 0;
$totalsFields[] = array('fName' => "Role", 'totalsType' => '', 'viewFormat' => "");
$totals = array();
// write data rows
$iNumberOfRows = 0;
while ((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) {
countTotals($totals, $totalsFields, $row);
$values = array();
$format = "";
$values["Code"] = GetData($row, "Code", $format);
$format = "";
$values["Role"] = GetData($row, "Role", $format);
$eventRes = true;
if ($eventObj->exists('BeforeOut')) {
$eventRes = $eventObj->BeforeOut($row, $values);
}
if ($eventRes) {
$iNumberOfRows++;
echo "<tr>";
echo '<td>';
$format = "";
echo htmlspecialchars($values["Code"]);
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
} else {
echo '<td>';
}
$format = "";
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["Role"]);
} else {
echo htmlspecialchars($values["Role"]);
}
echo '</td>';
echo "</tr>";
}
if ($eventObj->exists("ListFetchArray")) {
$row = $eventObj->ListFetchArray($rs);
} else {
$row = db_fetch_array($rs);
}
}
}示例7: 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") {
//.........这里部分代码省略.........
示例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("Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Usaha Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Nama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Rekening Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Rekening Kd Sub") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Rekdenda Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Masapajak") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Jatuhtempo") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Multiple") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Jalan Kelas Id") . '</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>" . "Usaha Id" . "</td>";
echo "<td>" . "Nama" . "</td>";
echo "<td>" . "Rekening Id" . "</td>";
echo "<td>" . "Rekening Kd Sub" . "</td>";
echo "<td>" . "Rekdenda Id" . "</td>";
echo "<td>" . "Masapajak" . "</td>";
echo "<td>" . "Jatuhtempo" . "</td>";
echo "<td>" . "Multiple" . "</td>";
echo "<td>" . "Jalan Kelas Id" . "</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["usaha_id"] = $pageObject->getViewControl("usaha_id")->showDBValue($row, "");
$values["nama"] = $pageObject->getViewControl("nama")->showDBValue($row, "");
$values["rekening_id"] = $pageObject->getViewControl("rekening_id")->showDBValue($row, "");
$values["rekening_kd_sub"] = $pageObject->getViewControl("rekening_kd_sub")->showDBValue($row, "");
$values["rekdenda_id"] = $pageObject->getViewControl("rekdenda_id")->showDBValue($row, "");
$values["masapajak"] = $pageObject->getViewControl("masapajak")->showDBValue($row, "");
$values["jatuhtempo"] = $pageObject->getViewControl("jatuhtempo")->showDBValue($row, "");
$values["multiple"] = $pageObject->getViewControl("multiple")->showDBValue($row, "");
$values["jalan_kelas_id"] = $pageObject->getViewControl("jalan_kelas_id")->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["usaha_id"]);
} else {
echo $values["usaha_id"];
}
//echo htmlspecialchars($values["usaha_id"]); commented for bug #6823
echo '</td>';
if ($_REQUEST["type"] == "excel") {
echo '<td x:str>';
} else {
echo '<td>';
}
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["nama"]);
} else {
echo $values["nama"];
}
echo '</td>';
echo '<td>';
//.........这里部分代码省略.........
示例9: 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"]);
//.........这里部分代码省略.........
示例10: 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("Rp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pb") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Formno") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Reg Date") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Customernm") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kecamatan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kelurahan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Alamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Telphone") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpnama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpalamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkelurahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkecamatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wptelp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pnama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Palamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkelurahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkecamatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ptelp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</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("Write Date") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Write Uid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Nm") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Alamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Usaha Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op So") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Kecamatan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Kelurahan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Latitude") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Longitude") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmlmeja") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmlkursi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Restojmltamu") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmkursi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmpertunjukan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Filmtarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyarmeja") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyartarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Bilyarkegiatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Diskopengunjung") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Diskotarif") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kd Waletvolume") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Email") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Op Pajak Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Npwpd") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Passwd") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Rp" . "</td>";
echo "<td>" . "Pb" . "</td>";
echo "<td>" . "Formno" . "</td>";
echo "<td>" . "Reg Date" . "</td>";
echo "<td>" . "Customernm" . "</td>";
echo "<td>" . "Kecamatan Id" . "</td>";
echo "<td>" . "Kelurahan Id" . "</td>";
echo "<td>" . "Kabupaten" . "</td>";
echo "<td>" . "Alamat" . "</td>";
echo "<td>" . "Kodepos" . "</td>";
echo "<td>" . "Telphone" . "</td>";
echo "<td>" . "Wpnama" . "</td>";
echo "<td>" . "Wpalamat" . "</td>";
echo "<td>" . "Wpkelurahan" . "</td>";
//.........这里部分代码省略.........
示例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("Parent") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Npwpd") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Rp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pb") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Formno") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Reg Date") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Nama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kecamatan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kelurahan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Alamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Telphone") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpnama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpalamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkelurahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkecamatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wptelp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Wpkodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pnama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Palamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkelurahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkecamatan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkabupaten") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ptelp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pkodepos") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin1tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin2tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin3tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4no") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ijin4tglakhir") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kukuhno") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kukuhnip") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kukuhtgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kukuh Jabat Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kukuhprinted") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Enabled") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Create Uid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tmt") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Customer Status Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kembalitgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kembalioleh") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kartuprinted") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kembalinip") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Penerimanm") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Penerimaalamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Penerimatgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Catatnip") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kirimtgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Batastgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Petugas Jabat Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Pencatat Jabat Id") . '</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("Update Uid") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Npwpd Old") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Id Old") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Parent" . "</td>";
echo "<td>" . "Npwpd" . "</td>";
echo "<td>" . "Rp" . "</td>";
echo "<td>" . "Pb" . "</td>";
echo "<td>" . "Formno" . "</td>";
echo "<td>" . "Reg Date" . "</td>";
echo "<td>" . "Nama" . "</td>";
echo "<td>" . "Kecamatan Id" . "</td>";
echo "<td>" . "Kelurahan Id" . "</td>";
echo "<td>" . "Kabupaten" . "</td>";
echo "<td>" . "Alamat" . "</td>";
echo "<td>" . "Kodepos" . "</td>";
echo "<td>" . "Telphone" . "</td>";
echo "<td>" . "Wpnama" . "</td>";
echo "<td>" . "Wpalamat" . "</td>";
//.........这里部分代码省略.........
示例12: 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") {
//.........这里部分代码省略.........
示例13: 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);
//.........这里部分代码省略.........
示例14: 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("Invoice Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tgl") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tagihan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Denda") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Total Bayar") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Iso Request") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Transmission") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Settlement") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Stan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ntb") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Ntp") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Bank Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Channel Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Bank Ip") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Invoice Id" . "</td>";
echo "<td>" . "Tgl" . "</td>";
echo "<td>" . "Tagihan" . "</td>";
echo "<td>" . "Denda" . "</td>";
echo "<td>" . "Total Bayar" . "</td>";
echo "<td>" . "Iso Request" . "</td>";
echo "<td>" . "Transmission" . "</td>";
echo "<td>" . "Settlement" . "</td>";
echo "<td>" . "Stan" . "</td>";
echo "<td>" . "Ntb" . "</td>";
echo "<td>" . "Ntp" . "</td>";
echo "<td>" . "Bank Id" . "</td>";
echo "<td>" . "Channel Id" . "</td>";
echo "<td>" . "Bank Ip" . "</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["invoice_id"] = $pageObject->getViewControl("invoice_id")->showDBValue($row, "");
$values["tgl"] = $pageObject->getViewControl("tgl")->showDBValue($row, "");
$values["tagihan"] = $pageObject->getViewControl("tagihan")->showDBValue($row, "");
$values["denda"] = $pageObject->getViewControl("denda")->showDBValue($row, "");
$values["total_bayar"] = $pageObject->getViewControl("total_bayar")->showDBValue($row, "");
$values["iso_request"] = $pageObject->getViewControl("iso_request")->showDBValue($row, "");
$values["transmission"] = $pageObject->getViewControl("transmission")->showDBValue($row, "");
$values["settlement"] = $pageObject->getViewControl("settlement")->showDBValue($row, "");
$values["stan"] = $pageObject->getViewControl("stan")->showDBValue($row, "");
$values["ntb"] = $pageObject->getViewControl("ntb")->showDBValue($row, "");
$values["ntp"] = $pageObject->getViewControl("ntp")->showDBValue($row, "");
$values["bank_id"] = $pageObject->getViewControl("bank_id")->showDBValue($row, "");
$values["channel_id"] = $pageObject->getViewControl("channel_id")->showDBValue($row, "");
$values["bank_ip"] = $pageObject->getViewControl("bank_ip")->showDBValue($row, "");
$eventRes = true;
if ($eventObj->exists('BeforeOut')) {
$eventRes = $eventObj->BeforeOut($row, $values, $pageObject);
}
if ($eventRes) {
$iNumberOfRows++;
echo "<tr>";
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["id"]);
} else {
echo $values["id"];
}
//echo htmlspecialchars($values["id"]); commented for bug #6823
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["invoice_id"]);
} else {
echo $values["invoice_id"];
}
//echo htmlspecialchars($values["invoice_id"]); commented for bug #6823
echo '</td>';
echo '<td>';
if ($_REQUEST["type"] == "excel") {
echo PrepareForExcel($values["tgl"]);
} else {
echo $values["tgl"];
}
echo '</td>';
echo '<td>';
echo $values["tagihan"];
echo '</td>';
//.........这里部分代码省略.........
示例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("Spt Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Media Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Kelas Jalan Id") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Panjang") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Lebar") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tinggi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Muka") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Sisi") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Banyak") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Lama") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Nsr") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Alamat") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Update Uid") . '</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("Created") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Status Baliho") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Tambahan") . '</td>';
echo '<td style="width: 100" x:str>' . PrepareForExcel("Jalan Id") . '</td>';
} else {
echo "<td>" . "Id" . "</td>";
echo "<td>" . "Spt Id" . "</td>";
echo "<td>" . "Media Id" . "</td>";
echo "<td>" . "Kelas Jalan Id" . "</td>";
echo "<td>" . "Panjang" . "</td>";
echo "<td>" . "Lebar" . "</td>";
echo "<td>" . "Tinggi" . "</td>";
echo "<td>" . "Muka" . "</td>";
echo "<td>" . "Sisi" . "</td>";
echo "<td>" . "Banyak" . "</td>";
echo "<td>" . "Lama" . "</td>";
echo "<td>" . "Nsr" . "</td>";
echo "<td>" . "Alamat" . "</td>";
echo "<td>" . "Update Uid" . "</td>";
echo "<td>" . "Create Uid" . "</td>";
echo "<td>" . "Updated" . "</td>";
echo "<td>" . "Created" . "</td>";
echo "<td>" . "Status Baliho" . "</td>";
echo "<td>" . "Tambahan" . "</td>";
echo "<td>" . "Jalan Id" . "</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_id"] = $pageObject->getViewControl("spt_id")->showDBValue($row, "");
$values["media_id"] = $pageObject->getViewControl("media_id")->showDBValue($row, "");
$values["kelas_jalan_id"] = $pageObject->getViewControl("kelas_jalan_id")->showDBValue($row, "");
$values["panjang"] = $pageObject->getViewControl("panjang")->showDBValue($row, "");
$values["lebar"] = $pageObject->getViewControl("lebar")->showDBValue($row, "");
$values["tinggi"] = $pageObject->getViewControl("tinggi")->showDBValue($row, "");
$values["muka"] = $pageObject->getViewControl("muka")->showDBValue($row, "");
$values["sisi"] = $pageObject->getViewControl("sisi")->showDBValue($row, "");
$values["banyak"] = $pageObject->getViewControl("banyak")->showDBValue($row, "");
$values["lama"] = $pageObject->getViewControl("lama")->showDBValue($row, "");
$values["nsr"] = $pageObject->getViewControl("nsr")->showDBValue($row, "");
$values["alamat"] = $pageObject->getViewControl("alamat")->showDBValue($row, "");
$values["update_uid"] = $pageObject->getViewControl("update_uid")->showDBValue($row, "");
$values["create_uid"] = $pageObject->getViewControl("create_uid")->showDBValue($row, "");
$values["updated"] = $pageObject->getViewControl("updated")->showDBValue($row, "");
$values["created"] = $pageObject->getViewControl("created")->showDBValue($row, "");
$values["status_baliho"] = $pageObject->getViewControl("status_baliho")->showDBValue($row, "");
$values["tambahan"] = $pageObject->getViewControl("tambahan")->showDBValue($row, "");
$values["jalan_id"] = $pageObject->getViewControl("jalan_id")->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_id"];
echo '</td>';
echo '<td>';
echo $values["media_id"];
echo '</td>';
echo '<td>';
echo $values["kelas_jalan_id"];
//.........这里部分代码省略.........