$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; $pageObject->jsSettings['tableSettings'][$strTableName]["enableCtrls"] = $enableCtrlsForEditing;
function DisplayLookupWizard($field, $value, $data, $keylink, $mode) { global $conn, $strTableName; if (!strlen($value)) { return ""; } $LookupSQL = "SELECT "; $LookupSQL .= GetLWDisplayField($field); $LookupSQL .= " FROM " . AddTableWrappers(GetLookupTable($field)) . " WHERE "; $where = ""; $lookupvalue = $value; $iquery = "field=" . htmlspecialchars(rawurlencode($field)) . $keylink; $out = ""; if (Multiselect($field)) { $arr = splitvalues($value); $numeric = true; $type = GetLWLinkFieldType($field); if (!$type) { foreach ($arr as $val) { if (strlen($val) && !is_numeric($val)) { $numeric = false; break; } } } else { $numeric = !NeedQuotes($type); } $in = ""; foreach ($arr as $val) { if ($numeric && !strlen($val)) { continue; } if (strlen($in)) { $in .= ","; } if ($numeric) { $in .= $val + 0; } else { $in .= db_prepare_string($val); } } if (strlen($in)) { $LookupSQL .= GetLWLinkField($field) . " in (" . $in . ")"; $where = GetLWWhere($field); if (strlen($where)) { $LookupSQL .= " and (" . $where . ")"; } LogInfo($LookupSQL); $rsLookup = db_query($LookupSQL, $conn); $found = false; while ($lookuprow = db_fetch_numarray($rsLookup)) { $lookupvalue = $lookuprow[0]; if ($found) { $out .= ","; } $found = true; $out .= GetDataInt($lookupvalue, $data, $field, ViewFormat($field)); } if ($found) { if (NeedEncode($field) && $mode != MODE_EXPORT) { return ProcessLargeText($out, $iquery, "", $mode, GetEditFormat($field)); } else { return $out; } } } } else { $strdata = make_db_value($field, $value); $LookupSQL .= GetLWLinkField($field) . " = " . $strdata; $where = GetLWWhere($field); if (strlen($where)) { $LookupSQL .= " and (" . $where . ")"; } LogInfo($LookupSQL); $rsLookup = db_query($LookupSQL, $conn); if ($lookuprow = db_fetch_numarray($rsLookup)) { $lookupvalue = $lookuprow[0]; } } if (!$out) { $out = GetDataInt($lookupvalue, $data, $field, ViewFormat($field)); } if (NeedEncode($field) && $mode != MODE_EXPORT) { $value = ProcessLargeText($out, $iquery, "", $mode, GetEditFormat($field)); } else { $value = $out; } return $value; }
function proccessRecordValue(&$data, &$keylink, $listFieldInfo) { if (NeedEncode($listFieldInfo['fName'], $this->tName) && $this->customField == $listFieldInfo['fName']) { $value = ProcessLargeText(GetData($data, $this->linkField, $listFieldInfo['viewFormat']), "field=" . rawurlencode($listFieldInfo['fName']) . $keylink, "", MODE_LIST); } else { $value = parent::proccessRecordValue($data, $keylink, $listFieldInfo); } if ($this->lookupSelectField == $listFieldInfo['fName']) { $value = '<a href="#" type="lookupSelect' . $this->id . '">' . $value . "</a>"; } return $value; }
/** * 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 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; }