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"]); } echo '</td>'; echo '<td>'; $format = "Short Date"; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Date Time"]); } else { echo htmlspecialchars($values["Date Time"]); } echo '</td>'; echo '<td>'; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Action Taken"]); } else { echo htmlspecialchars($values["Action Taken"]); } echo '</td>'; echo "</tr>"; } if ($eventObj->exists("ListFetchArray")) { $row = $eventObj->ListFetchArray($rs); } else { $row = db_fetch_array($rs); } } }
function DisplayMasterTableInfo_Module($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.Module"; //$strSQL = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date] FROM dbo.[Module]"; $sqlHead = "SELECT ID, [Module Type], [Module Status], [Module Condition], [Serial Num], [Entry Date]"; $sqlFrom = "FROM dbo.[Module]"; $sqlWhere = ""; $sqlTail = ""; $where = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterprint", "BoldOrange", "MobileOrange"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterprintheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterprintfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["Module_masterprint"] = $layout; if ($detailtable == "dbo.Anomalies") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Customer Module Assignment") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if ($detailtable == "dbo.Readings") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Export"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT); $xt->assign("ID_mastervalue", $value); // Module Type - $value = ""; $value = DisplayLookupWizard("Module Type", $data["Module Type"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Type_mastervalue", $value); // Module Status - $value = ""; $value = DisplayLookupWizard("Module Status", $data["Module Status"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Status_mastervalue", $value); // Module Condition - $value = ""; $value = DisplayLookupWizard("Module Condition", $data["Module Condition"], $data, $keylink, MODE_PRINT); $xt->assign("Module_Condition_mastervalue", $value); // Serial Num - $value = ""; $value = ProcessLargeText(GetData($data, "Serial Num", ""), "field=Serial+Num" . $keylink, "", MODE_PRINT); $xt->assign("Serial_Num_mastervalue", $value); // Entry Date - Short Date $value = ""; $value = ProcessLargeText(GetData($data, "Entry Date", "Short Date"), "field=Entry+Date" . $keylink, "", MODE_PRINT); $xt->assign("Entry_Date_mastervalue", $value); $xt->display("Module_masterprint.htm"); $strTableName = $oldTableName; }
if ($preload !== false) { $controls["controls"]['preloadData'] = $preload; } $pageObject->fillControlsMap($controls); //fill field tool tips $pageObject->fillFieldToolTips($fName); // fill special settings for timepicker if (GetEditFormat($fName) == 'Time') { $pageObject->fillTimePickSettings($fName, $data[$fName]); } if (ViewFormat($fName) == FORMAT_MAP) { $pageObject->googleMapCfg['isUseGoogleMap'] = true; } if ($detailKeys && in_array($fName, $detailKeys) && array_key_exists($fName, $data)) { if ((GetEditFormat($fName) == EDIT_FORMAT_LOOKUP_WIZARD || GetEditFormat($fName) == EDIT_FORMAT_RADIO) && GetpLookupType($fName) == LT_LOOKUPTABLE) { $value = DisplayLookupWizard($fName, $data[$fName], $data, "", MODE_VIEW); } elseif (NeedEncode($fName)) { $value = ProcessLargeText(GetData($data, $fName, ViewFormat($fName)), "field=" . rawurlencode(htmlspecialchars($fName)), "", MODE_VIEW); } else { $value = GetData($data, $fName, ViewFormat($fName)); } $xt->assign($gfName . "_editcontrol", $value); } } //fill tab groups name and sections name to controls $pageObject->fillCntrlTabGroups(); $pageObject->jsSettings['tableSettings'][$strTableName]["keys"] = $keys; $pageObject->jsSettings['tableSettings'][$strTableName]["prevKeys"] = $prev; $pageObject->jsSettings['tableSettings'][$strTableName]["nextKeys"] = $next; if ($pageObject->lockingObj) { $pageObject->jsSettings['tableSettings'][$strTableName]["sKeys"] = $skeys;
//Record ID - $value = ""; $value = ProcessLargeText(GetData($data, "Record ID", ""), "", "", MODE_VIEW); if ($mainTableOwnerID == "Record ID") { $ownerIdValue = $value; } $xt->assign("Record_ID_value", $value); if (!$pageObject->isAppearOnTabs("Record ID")) { $xt->assign("Record_ID_fieldblock", true); } else { $xt->assign("Record_ID_tabfieldblock", true); } //////////////////////////////////////////// //Module ID - $value = ""; $value = DisplayLookupWizard("Module ID", $data["Module ID"], $data, $keylink, MODE_VIEW); if ($mainTableOwnerID == "Module ID") { $ownerIdValue = $value; } $xt->assign("Module_ID_value", $value); if (!$pageObject->isAppearOnTabs("Module ID")) { $xt->assign("Module_ID_fieldblock", true); } else { $xt->assign("Module_ID_tabfieldblock", true); } //////////////////////////////////////////// //Voltage Red - $value = ""; $value = ProcessLargeText(GetData($data, "Voltage Red", ""), "", "", MODE_VIEW); if ($mainTableOwnerID == "Voltage Red") { $ownerIdValue = $value;
$vals = array($fName => @$defvalues[$fName]); } $preload = $pageObject->fillPreload($fName, $vals); if ($preload !== false) { $controls["controls"]['preloadData'] = $preload; } $pageObject->fillControlsMap($controls); //fill field tool tips $pageObject->fillFieldToolTips($fName); // fill special settings for timepicker if (GetEditFormat($fName) == 'Time') { $pageObject->fillTimePickSettings($fName, @$defvalues[$fName]); } if (($detailKeys && in_array($fName, $detailKeys) || $fName == postvalue("category")) && array_key_exists($fName, $defvalues)) { if ((GetEditFormat($fName) == EDIT_FORMAT_LOOKUP_WIZARD || GetEditFormat($fName) == EDIT_FORMAT_RADIO) && GetpLookupType($fName) == LT_LOOKUPTABLE) { $value = DisplayLookupWizard($fName, $defvalues[$fName], $defvalues, "", MODE_VIEW); } elseif (NeedEncode($fName)) { $value = ProcessLargeText(GetData($defvalues, $fName, ViewFormat($fName)), "field=" . rawurlencode(htmlspecialchars($fName)), "", MODE_VIEW); } else { $value = GetData($defvalues, $fName, ViewFormat($fName)); } $xt->assign($gfName . "_editcontrol", $value); } } //fill tab groups name and sections name to controls $pageObject->fillCntrlTabGroups(); ///////////////////////////////////////////////////////////// if ($pageObject->isShowDetailTables && ($inlineadd == ADD_SIMPLE || $inlineadd == ADD_POPUP) && !isMobile()) { if (count($dpParams['ids'])) { $xt->assign("detail_tables", true); include 'classes/listpage.php';
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["UserID"])); // UserID - $value = ""; $value = ProcessLargeText(GetData($data, "UserID", ""), "field=UserID" . $keylink, "", MODE_PRINT); $record["UserID_value"] = $value; // Password - $value = ""; $value = ProcessLargeText(GetData($data, "Password", ""), "field=Password" . $keylink, "", MODE_PRINT); $record["Password_value"] = $value; // User Name - $value = ""; $value = ProcessLargeText(GetData($data, "User Name", ""), "field=User+Name" . $keylink, "", MODE_PRINT); $record["User_Name_value"] = $value; // Role - $value = ""; $value = DisplayLookupWizard("Role", $data["Role"], $data, $keylink, MODE_PRINT); $record["Role_value"] = $value; if ($col < $colsonpage) { $record["endrecord_block"] = true; } $record["grid_recordheader"] = true; $record["grid_vrecord"] = true; if ($eventObj->exists("BeforeMoveNextPrint")) { $eventObj->BeforeMoveNextPrint($data, $row, $record); } $row["grid_record"]["data"][] = $record; if ($eventObj->exists("ListFetchArray")) { $data = $eventObj->ListFetchArray($rs); } else { $data = db_fetch_array($rs); }
function DisplayMasterTableInfo_Customers($params) { $detailtable = $params["detailtable"]; $keys = $params["keys"]; global $conn, $strTableName; $xt = new Xtempl(); $oldTableName = $strTableName; $strTableName = "dbo.Customers"; //$strSQL = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type] FROM dbo.Customers"; $sqlHead = "SELECT ID, Name, [Father Name], Address, Contact, Location, [Customer Type]"; $sqlFrom = "FROM dbo.Customers"; $sqlWhere = ""; $sqlTail = ""; $where = ""; $mKeys = array(); $showKeys = ""; global $page_styles, $page_layouts, $page_layout_names, $container_styles; $layout = new TLayout("masterlist", "BoldOrange", "MobileOrange"); $layout->blocks["bare"] = array(); $layout->containers["0"] = array(); $layout->containers["0"][] = array("name" => "masterlistheader", "block" => "", "substyle" => 1); $layout->skins["0"] = "empty"; $layout->blocks["bare"][] = "0"; $layout->containers["mastergrid"] = array(); $layout->containers["mastergrid"][] = array("name" => "masterlistfields", "block" => "", "substyle" => 1); $layout->skins["mastergrid"] = "grid"; $layout->blocks["bare"][] = "mastergrid"; $page_layouts["Customers_masterlist"] = $layout; if ($detailtable == "dbo.Customer Module Assignment") { $where .= GetFullFieldName("ID") . "=" . make_db_value("ID", $keys[1 - 1]); $showKeys .= " " . GetFieldLabel("dbo_Customers", "ID") . ": " . $keys[1 - 1]; $xt->assign('showKeys', $showKeys); } if (!$where) { $strTableName = $oldTableName; return; } $str = SecuritySQL("Search"); if (strlen($str)) { $where .= " and " . $str; } $strWhere = whereAdd($sqlWhere, $where); if (strlen($strWhere)) { $strWhere = " where " . $strWhere . " "; } $strSQL = $sqlHead . ' ' . $sqlFrom . $strWhere . $sqlTail; // $strSQL=AddWhere($strSQL,$where); LogInfo($strSQL); $rs = db_query($strSQL, $conn); $data = db_fetch_array($rs); if (!$data) { $strTableName = $oldTableName; return; } $keylink = ""; $keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink); $xt->assign("ID_mastervalue", $value); // Name - $value = ""; $value = ProcessLargeText(GetData($data, "Name", ""), "field=Name" . $keylink); $xt->assign("Name_mastervalue", $value); // Father Name - $value = ""; $value = ProcessLargeText(GetData($data, "Father Name", ""), "field=Father+Name" . $keylink); $xt->assign("Father_Name_mastervalue", $value); // Address - $value = ""; $value = ProcessLargeText(GetData($data, "Address", ""), "field=Address" . $keylink); $xt->assign("Address_mastervalue", $value); // Contact - $value = ""; $value = ProcessLargeText(GetData($data, "Contact", ""), "field=Contact" . $keylink); $xt->assign("Contact_mastervalue", $value); // Location - $value = ""; $value = DisplayLookupWizard("Location", $data["Location"], $data, $keylink, MODE_LIST); $xt->assign("Location_mastervalue", $value); // Customer Type - $value = ""; $value = DisplayLookupWizard("Customer Type", $data["Customer Type"], $data, $keylink, MODE_LIST); $xt->assign("Customer_Type_mastervalue", $value); $xt->display("Customers_masterlist.htm"); $strTableName = $oldTableName; }
$row["Father_Name_value"] = $value; // Address - $value = ""; $value = ProcessLargeText(GetData($data, "Address", ""), "field=Address" . $keylink, "", MODE_PRINT); $row["Address_value"] = $value; // Contact - $value = ""; $value = ProcessLargeText(GetData($data, "Contact", ""), "field=Contact" . $keylink, "", MODE_PRINT); $row["Contact_value"] = $value; // Location - $value = ""; $value = DisplayLookupWizard("Location", $data["Location"], $data, $keylink, MODE_PRINT); $row["Location_value"] = $value; // Customer Type - $value = ""; $value = DisplayLookupWizard("Customer Type", $data["Customer Type"], $data, $keylink, MODE_PRINT); $row["Customer_Type_value"] = $value; $rowinfo[] = $row; } $xt->assign_loopsection("details_row", $rowinfo); } else { } $xt->display("Customers_detailspreview.htm"); if ($mode != "inline") { echo "counterSeparator" . postvalue("counter"); $layout = GetPageLayout(GoodFieldName($strTableName), 'detailspreview'); if ($layout) { $rtl = $xt->getReadingOrder() == 'RTL' ? 'RTL' : ''; echo "counterSeparator" . "styles/" . $layout->style . "/style" . $rtl . "counterSeparator" . "pagestyles/" . $layout->name . $rtl . "counterSeparator" . $layout->style . " page-" . $layout->name; } }
$keylink .= "&key1=" . htmlspecialchars(rawurlencode(@$data["ID"])); // ID - $value = ""; $value = ProcessLargeText(GetData($data, "ID", ""), "field=ID" . $keylink, "", MODE_PRINT); $record["ID_value"] = $value; // Module Type - $value = ""; $value = DisplayLookupWizard("Module Type", $data["Module Type"], $data, $keylink, MODE_PRINT); $record["Module_Type_value"] = $value; // Module Status - $value = ""; $value = DisplayLookupWizard("Module Status", $data["Module Status"], $data, $keylink, MODE_PRINT); $record["Module_Status_value"] = $value; // Module Condition - $value = ""; $value = DisplayLookupWizard("Module Condition", $data["Module Condition"], $data, $keylink, MODE_PRINT); $record["Module_Condition_value"] = $value; // Serial Num - $value = ""; $value = ProcessLargeText(GetData($data, "Serial Num", ""), "field=Serial+Num" . $keylink, "", MODE_PRINT); $record["Serial_Num_value"] = $value; // Entry Date - Short Date $value = ""; $value = ProcessLargeText(GetData($data, "Entry Date", "Short Date"), "field=Entry+Date" . $keylink, "", MODE_PRINT); $record["Entry_Date_value"] = $value; if ($col < $colsonpage) { $record["endrecord_block"] = true; } $record["grid_recordheader"] = true; $record["grid_vrecord"] = true; if ($eventObj->exists("BeforeMoveNextPrint")) {
//Date Time - Short Date $value = ""; $value = ProcessLargeText(GetData($data, "Date Time", "Short Date"), "", "", MODE_VIEW); if ($mainTableOwnerID == "Date Time") { $ownerIdValue = $value; } $xt->assign("Date_Time_value", $value); if (!$pageObject->isAppearOnTabs("Date Time")) { $xt->assign("Date_Time_fieldblock", true); } else { $xt->assign("Date_Time_tabfieldblock", true); } //////////////////////////////////////////// //Action Taken - $value = ""; $value = DisplayLookupWizard("Action Taken", $data["Action Taken"], $data, $keylink, MODE_VIEW); if ($mainTableOwnerID == "Action Taken") { $ownerIdValue = $value; } $xt->assign("Action_Taken_value", $value); if (!$pageObject->isAppearOnTabs("Action Taken")) { $xt->assign("Action_Taken_fieldblock", true); } else { $xt->assign("Action_Taken_tabfieldblock", true); } /*$jsKeysObj = 'window.recKeysObj = {'; $jsKeysObj .= "'".jsreplace("ID")."': '".(jsreplace(@$data["ID"]))."', "; $jsKeysObj = substr($jsKeysObj, 0, strlen($jsKeysObj)-2); $jsKeysObj .= '};'; $pageObject->AddJsCode($jsKeysObj); */
/** * Proccess record values * * @param array $record * @param array $data * @param string $keylink */ function proccessRecordValue(&$data, &$keylink, $listFieldInfo) { $value = ""; if ($listFieldInfo['viewFormat'] == FORMAT_DATABASE_IMAGE) { if (ShowThumbnail($listFieldInfo['fName'], $this->tName)) { $thumbPref = GetThumbnailPrefix($listFieldInfo['fName'], $this->tName); $value .= "<a"; if (IsUseiBox($listFieldInfo['fName'], $this->tName)) { $value .= " rel='ibox'"; } else { $value .= " target=_blank"; } $value .= " href='imager.php?table=" . $this->shortTableName . "&field=" . rawurlencode($listFieldInfo['fName']) . $keylink . "'>"; $value .= "<img border=0"; if ($this->is508) { $value .= " alt=\"Image from DB\""; } $value .= " src='imager.php?table=" . $this->shortTableName . "&field=" . rawurlencode($thumbPref) . "&alt=" . rawurlencode($listFieldInfo['fName']) . $keylink . "'>"; $value .= "</a>"; } else { $value = "<img"; if ($this->is508) { $value .= " alt=\"Image from DB\""; } $imgWidth = GetImageWidth($listFieldInfo['fName'], $this->tName); $value .= $imgWidth ? " width=" . $imgWidth : ""; $imgHeight = GetImageHeight($listFieldInfo['fName'], $this->tName); $value .= $imgHeight ? " height=" . $imgHeight : ""; $value .= " border=0"; $value .= " src='imager.php?table=" . $this->shortTableName . "&field=" . rawurlencode($listFieldInfo['fName']) . $keylink . "'>"; } } else { if ($listFieldInfo['viewFormat'] == FORMAT_FILE_IMAGE) { if (CheckImageExtension($data[$listFieldInfo['fName']])) { if (ShowThumbnail($listFieldInfo['fName'], $this->tName)) { // show thumbnail $thumbPref = GetThumbnailPrefix($listFieldInfo['fName'], $this->tName); $thumbname = $thumbPref . $data[$listFieldInfo['fName']]; if (substr(GetLinkPrefix($listFieldInfo['fName'], $this->tName), 0, 7) != "http://" && !myfile_exists(GetUploadFolder($listFieldInfo['fName']) . $thumbname)) { $thumbname = $data[$listFieldInfo['fName']]; } $value = "<a"; if (IsUseiBox($listFieldInfo['fName'], $this->tName)) { $value .= " rel='ibox'"; } else { $value .= " target=_blank"; } $value .= " href=\"" . htmlspecialchars(AddLinkPrefix($listFieldInfo['fName'], $data[$listFieldInfo['fName']])) . "\">"; $value .= "<img"; if ($thumbname == $data[$listFieldInfo['fName']]) { $imgWidth = GetImageWidth($listFieldInfo['fName'], $this->tName); $value .= $imgWidth ? " width=" . $imgWidth : ""; $imgHeight = GetImageHeight($listFieldInfo['fName'], $this->tName); $value .= $imgHeight ? " height=" . $imgHeight : ""; } $value .= " border=0"; if ($this->is508) { $value .= " alt=\"" . htmlspecialchars($data[$listFieldInfo['fName']]) . "\""; } $value .= " src=\"" . htmlspecialchars(AddLinkPrefix($listFieldInfo['fName'], $thumbname)) . "\"></a>"; } else { $value = "<img"; $imgWidth = GetImageWidth($listFieldInfo['fName'], $this->tName); $value .= $imgWidth ? " width=" . $imgWidth : ""; $imgHeight = GetImageHeight($listFieldInfo['fName'], $this->tName); $value .= $imgHeight ? " height=" . $imgHeight : ""; $value .= " border=0"; if ($this->is508) { $value .= " alt=\"" . htmlspecialchars($data[$listFieldInfo['fName']]) . "\""; } $value .= " src=\"" . htmlspecialchars(AddLinkPrefix($listFieldInfo['fName'], $data[$listFieldInfo['fName']])) . "\">"; } } } else { if ($listFieldInfo['viewFormat'] == FORMAT_DATABASE_FILE) { $fileNameF = GetFilenameField($listFieldInfo['fName'], $this->tName); if ($fileNameF) { $fileName = $data[$fileNameF]; if (!$fileName) { $fileName = "file.bin"; } } else { $fileName = "file.bin"; } if (strlen($data[$listFieldInfo['fName']])) { $value = "<a href='getfile.php?table=" . $this->shortTableName . "&filename=" . rawurlencode($fileName) . "&field=" . rawurlencode($listFieldInfo['fName']) . $keylink . "'>"; $value .= htmlspecialchars($fileName); $value .= "</a>"; } } else { if ($listFieldInfo['viewFormat'] == FORMAT_AUDIO) { $fileName = GetData($data, $listFieldInfo['fName'], FORMAT_NONE); $fieldIsUrl = GetFieldData($this->tName, $listFieldInfo['fName'], "fieldIsVideoUrl", false); if (strlen($fileName)) { $absFileName = ""; if (!$fieldIsUrl && GetFieldData($this->tName, $listFieldInfo['fName'], "Absolute", false)) { $absFileName = GetUploadFolder($listFieldInfo['fName']) . $fileName; } elseif (!$fieldIsUrl) { $absFileName = getabspath(GetUploadFolder($listFieldInfo['fName']) . $fileName); } // if file if ($fieldIsUrl || file_exists($absFileName)) { $titleField = GetFieldData($this->tName, $listFieldInfo['fName'], 'audioTitleField', ""); $title = ""; if ($titleField) { $title = htmlspecialchars(GetData($data, $titleField, ViewFormat($titleField, $titleField))); } if ($fieldIsUrl) { $href = $fileName; } else { $href = 'download.php?table=' . $this->shortTableName . '&field=' . rawurlencode($listFieldInfo['fName']) . $keylink; } $value = '<a class="htrack" type="audio/mpeg" title="' . $title . '" href="' . $href . '">' . $title . '</a>'; } } } else { if ($listFieldInfo['viewFormat'] == FORMAT_DATABASE_AUDIO) { $titleField = GetFieldData($this->tName, $listFieldInfo['fName'], 'audioTitleField', ""); $title = ""; if ($titleField) { $title = htmlspecialchars(GetData($data, $titleField, ViewFormat($titleField, $titleField))); } if (@$data[$listFieldInfo['fName']] != NULL) { $value = '<a class="htrack" type="audio/mpeg" title="' . $title . '" href="getfile.php?table=' . $this->shortTableName . '&field=' . rawurlencode($listFieldInfo['fName']) . $keylink . '">' . $title . '</a>'; } else { $value = $title; } } else { if ($listFieldInfo['viewFormat'] == FORMAT_VIDEO) { $value = ""; $fieldIsUrl = GetFieldData($this->tName, $listFieldInfo['fName'], "fieldIsVideoUrl", false); $fileName = GetData($data, $listFieldInfo['fName'], FORMAT_NONE); if (strlen($fileName)) { $absFileName = ""; if (!$fieldIsUrl && GetFieldData($this->tName, $listFieldInfo['fName'], "Absolute", false)) { $absFileName = GetUploadFolder($listFieldInfo['fName']) . $fileName; } elseif (!$fieldIsUrl) { $absFileName = getabspath(GetUploadFolder($listFieldInfo['fName']) . $fileName); } // if file if ($fieldIsUrl || file_exists($absFileName)) { $videoId = 'video_' . GoodFieldName(htmlspecialchars($listFieldInfo['fName'])) . '_' . $this->recId; if ($fieldIsUrl) { $href = $fileName; } else { $href = 'download.php?table=' . $this->shortTableName . '&field=' . rawurlencode($listFieldInfo['fName']) . $keylink; } $value = '<a href="' . $href . '" style="display:block;width:' . GetFieldData($this->tName, $listFieldInfo['fName'], 'videoWidth', "") . 'px;height:' . GetFieldData($this->tName, $listFieldInfo['fName'], 'videoHeight', "") . 'px;" id="' . $videoId . '"></a>'; $this->controlsMap['video'][] = $videoId; } } } else { if ($listFieldInfo['viewFormat'] == FORMAT_DATABASE_VIDEO) { if (@$data[$listFieldInfo['fName']] != NULL) { $videoId = 'video_' . GoodFieldName(htmlspecialchars($listFieldInfo['fName'])) . '_' . $this->recId; $value = '<a href="getfile.php?table=' . $this->shortTableName . '&field=' . rawurlencode($listFieldInfo['fName']) . $keylink . '" style="display:block;width:' . GetFieldData($this->tName, $listFieldInfo['fName'], 'videoWidth', 0) . 'px;height:' . GetFieldData($this->tName, $listFieldInfo['fName'], 'videoHeight', 0) . 'px;" id="' . $videoId . '"></a>'; $this->controlsMap['video'][] = $videoId; } } else { if ($listFieldInfo['viewFormat'] == FORMAT_MAP) { $value = '<div id="littleMap_' . GoodFieldName($listFieldInfo['fName']) . '_' . $this->recId . '" style="width: ' . $this->googleMapCfg['fieldsAsMap'][$listFieldInfo['fName']]['width'] . 'px; height: ' . $this->googleMapCfg['fieldsAsMap'][$listFieldInfo['fName']]['height'] . 'px;"></div>'; } else { if (($listFieldInfo['editFormat'] == EDIT_FORMAT_LOOKUP_WIZARD || $listFieldInfo['editFormat'] == EDIT_FORMAT_RADIO) && GetLookupType($listFieldInfo['fName'], $this->tName) == LT_LOOKUPTABLE && GetLWLinkField($listFieldInfo['fName'], $this->tName) != GetLWDisplayField($listFieldInfo['fName'], $this->tName)) { $value = DisplayLookupWizard($listFieldInfo['fName'], $data[$listFieldInfo['fName']], $data, $keylink, MODE_LIST); } else { if (NeedEncode($listFieldInfo['fName'], $this->tName)) { $value = ProcessLargeText(GetData($data, $listFieldInfo['fName'], $listFieldInfo['viewFormat']), "field=" . rawurlencode($listFieldInfo['fName']) . $keylink, "", MODE_LIST); } else { $value = GetData($data, $listFieldInfo['fName'], $listFieldInfo['viewFormat']); } } } } } } } } } } // create address field as center link $value = $this->addCenterLink($value, $listFieldInfo['fName']); return $value; }
function labelFormat($fieldName, $data) { $table = $this->sessionPrefix; $strViewFormat = GetFieldData($table, $fieldName, "ViewFormat", ""); $strEditFormat = GetFieldData($table, $fieldName, "EditFormat", ""); if (($strEditFormat == EDIT_FORMAT_LOOKUP_WIZARD || $strEditFormat == EDIT_FORMAT_RADIO) && GetLookupType($fieldName, $table) == LT_LOOKUPTABLE && GetLWLinkField($fieldName, $table) != GetLWDisplayField($fieldName, $table)) { $value = DisplayLookupWizard($fieldName, $data[$fieldName], $data, "", MODE_PRINT); } else { $value = GetData($data, $fieldName, $strViewFormat); } if (strlen($value) > 50) { $value = substr($value, 0, 47) . "..."; } return $this->chart_xmlencode($value); }
function getFormattedRow($value) { $row = array('row_data' => true); $keylink = ""; for ($i = 0; $i < count($this->tKeyFields); $i++) { $keylink .= "&key" . ($i + 1) . "=" . htmlspecialchars(rawurlencode(@$value[$this->tKeyFields[$i]])); } for ($i = 0; $i < count($this->fieldsArr); $i++) { // for change pseudo foreach with condition with PHP for // foreach Fields as @f filter @f.bReportPage && (@TABLE.bReportShowDetails || @TABLE.arrReportGroupFields[strGroupField==@f.strName && nGroupInterval==0].len) order nReportPageOrder $pass = false; for ($j = 0; $j < count($this->repGroupFields); $j++) { if (!$this->fieldsArr[$i]['repPage'] || !($this->repShowDet || $this->repGroupFields[$j]['strGroupField'] == $this->fieldsArr[$i]['name'] && $this->repGroupFields[$j]['groupInterval'] === 0)) { $pass = true; } } if ($pass) { continue; } if ($this->fieldsArr[$i]['viewFormat'] == FORMAT_DATABASE_IMAGE) { if (!$this->forExport) { if ($this->fieldsArr[$i]['showThumb']) { $val .= "<a "; if (IsUseiBox($this->fieldsArr[$i]['name'], $this->tName)) { $val .= " rel='ibox'"; } else { $val .= " target=_blank"; } $val .= " href=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">"; $val .= "<img border=0"; if (isEnableSection508()) { $val .= " alt=\"Image from DB\""; } $val .= " src=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['thumbnail'])) . "&alt=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['repPage'])) . $keylink . "\">"; $val .= "</a>"; } else { $val = "<img"; if ($this->fieldsArr[$i]['imageWidth']) { $val .= " width=" . $this->fieldsArr[$i]['imageWidth']; } if ($this->fieldsArr[$i]['imageHeight']) { $val .= " height=" . $this->fieldsArr[$i]['imageHeight']; } $val .= " border=0"; if (isEnableSection508()) { $val .= " alt=\"Image from DB\""; } $val .= " src=\"imager.php?table=" . $this->shortTName . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">"; } } else { $val = mlang_message("LONG_BINARY"); } } elseif ($this->fieldsArr[$i]['viewFormat'] == FORMAT_FILE_IMAGE) { if (!$this->forExport) { if (CheckImageExtension($value[$this->fieldsArr[$i]['name']])) { if ($this->fieldsArr[$i]['showThumb']) { // show thumbnail $thumbname = $this->fieldsArr[$i]['thumbnail'] . $value[$this->fieldsArr[$i]['name']]; if (substr($this->fieldsArr[$i]['strhlPrefix'], 0, 7) != "http://" && !myfile_exists(getabspath($this->fieldsArr[$i]['strhlPrefix'] . $thumbname))) { $thumbname = $value[$this->fieldsArr[$i]['name']]; } $val = "<a"; if (IsUseiBox($this->fieldsArr[$i]['name'], $this->tName)) { $val .= " rel='ibox'"; } else { $val .= " target=_blank"; } $val .= " href=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']])) . "\">"; $val .= "<img"; if ($thumbname == $value[$this->fieldsArr[$i]['name']]) { if ($this->fieldsArr[$i]['imageWidth']) { $val .= " width=" . $this->fieldsArr[$i]['imageWidth']; } if ($this->fieldsArr[$i]['imageHeight']) { $val .= " height=" . $this->fieldsArr[$i]['imageHeight']; } } $val .= " border=0"; if (isEnableSection508()) { $val .= " alt=\"" . htmlspecialchars($value[$this->fieldsArr[$i]['name']]) . "\""; } $val .= " src=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $thumbname)) . "\"></a>"; } else { $val = "<img"; if ($this->fieldsArr[$i]['imageWidth']) { $val .= " width=" . $this->fieldsArr[$i]['imageWidth']; } if ($this->fieldsArr[$i]['imageHeight']) { $val .= " height=" . $this->fieldsArr[$i]['imageHeight']; } $val .= " border=0"; if (isEnableSection508()) { $val .= " alt=\"" . htmlspecialchars($value[$this->fieldsArr[$i]['name']]) . "\""; } $val .= " src=\"" . htmlspecialchars(AddLinkPrefix($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']])) . "\">"; } } } else { $val = mlang_message("LONG_BINARY"); } } elseif ($this->fieldsArr[$i]['viewFormat'] == FORMAT_DATABASE_FILE) { if (!$this->forExport) { if ($this->fieldsArr[$i]['fileName']) { $filename = $value[$this->fieldsArr[$i]['fileName']]; if (!$filename) { $filename = "file.bin"; } } else { $filename = "file.bin"; } if (strlen($value[$this->fieldsArr[$i]['name']])) { $val = "<a href=\"getfile.php?table=" . $this->shortTName . "&filename=" . rawurlencode($filename) . "&field=" . rawurlencode(htmlspecialchars($this->fieldsArr[$i]['name'])) . $keylink . "\">"; $val .= htmlspecialchars($filename); $val .= "</a>"; } } else { $val = mlang_message("LONG_BINARY"); } } elseif (($this->fieldsArr[$i]['editFormat'] == EDIT_FORMAT_LOOKUP_WIZARD || $this->fieldsArr[$i]['editFormat'] == EDIT_FORMAT_RADIO) && GetLookupType($this->fieldsArr[$i]['name'], $this->tName) == LT_LOOKUPTABLE) { $val = DisplayLookupWizard($this->fieldsArr[$i]['name'], $value[$this->fieldsArr[$i]['name']], $value, $keylink, $this->mode); } elseif (NeedEncode($this->fieldsArr[$i]['name'], $this->tName)) { $val = ProcessLargeText(GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']), "field=" . rawurlencode($this->fieldsArr[$i]['name']) . $keylink, "", $this->mode); } else { //$val = GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']); if ($this->fieldsArr[$i]['viewFormat'] == FORMAT_CHECKBOX && $this->forExport) { $val = GetData($value, $this->fieldsArr[$i]['name'], FORMAT_NONE); } else { $val = GetData($value, $this->fieldsArr[$i]['name'], $this->fieldsArr[$i]['viewFormat']); } } $row[$this->fieldsArr[$i]['goodName'] . "_value"] = $val; } if ($this->repLayout == REPORT_BLOCK) { $row[GoodFieldName('nonewgroup')] = true; } return $row; }
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); $format = ""; $values["PF Red"] = GetData($row, "PF Red", $format); $format = ""; $values["PF Blue"] = GetData($row, "PF Blue", $format); $format = ""; $values["PF Yellow"] = GetData($row, "PF Yellow", $format); $format = ""; $values["Peak Power"] = GetData($row, "Peak Power", $format); $format = "Short Date"; $values["Date Time"] = GetData($row, "Date Time", $format); $format = FORMAT_NONE; $values["IsSync"] = GetData($row, "IsSync", $format); $format = ""; $values["Currunt Readings"] = GetData($row, "Currunt Readings", $format); $eventRes = true; if ($eventObj->exists('BeforeOut')) { $eventRes = $eventObj->BeforeOut($row, $values); } if ($eventRes) { $iNumberOfRows++; echo "<tr>"; echo '<td>'; $format = ""; echo htmlspecialchars($values["Record 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["Voltage Red"]); } else { echo htmlspecialchars($values["Voltage Red"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Voltage Blue"]); } else { echo htmlspecialchars($values["Voltage Blue"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Voltage Yellow"]); } else { echo htmlspecialchars($values["Voltage Yellow"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Currunt Red"]); } else { echo htmlspecialchars($values["Currunt Red"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Currunt Blue"]); } else { echo htmlspecialchars($values["Currunt Blue"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Currunt Yellow"]); } else { echo htmlspecialchars($values["Currunt Yellow"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["PF Red"]); } else { echo htmlspecialchars($values["PF Red"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["PF Blue"]); } else { echo htmlspecialchars($values["PF Blue"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["PF Yellow"]); } else { echo htmlspecialchars($values["PF Yellow"]); } echo '</td>'; if ($_REQUEST["type"] == "excel") { echo '<td x:str>'; } else { echo '<td>'; } $format = ""; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Peak Power"]); } else { echo htmlspecialchars($values["Peak Power"]); } echo '</td>'; echo '<td>'; $format = "Short Date"; if ($_REQUEST["type"] == "excel") { echo PrepareForExcel($values["Date Time"]); } else { echo htmlspecialchars($values["Date Time"]); } echo '</td>'; echo '<td>'; $format = FORMAT_NONE; echo htmlspecialchars($values["IsSync"]); echo '</td>'; echo '<td>'; $format = ""; echo htmlspecialchars($values["Currunt Readings"]); echo '</td>'; echo "</tr>"; } if ($eventObj->exists("ListFetchArray")) { $row = $eventObj->ListFetchArray($rs); } else { $row = db_fetch_array($rs); } } }
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" . ": "; } $total = GetTotals($fName, $totals[$fName], $value["totalsType"], $iNumberOfRows, $value["viewFormat"]); } $arrTotal[$fName] = $total; $arrTotalMessage[$fName] = $totalMess; } } ExportExcelTotals($arrTotal, $arrTotalMessage, ++$iNumberOfRows, $objPHPExcel); $formatExcel = "Excel2007"; $extExcel = ".xlsx"; if (@$_REQUEST["type"] == "excel5") { $formatExcel = "Excel5"; $extExcel = ".xls"; } ExportExcelSave(GoodFieldName($strTableName) . $extExcel, $formatExcel, $objPHPExcel); }