PHP GoodFieldName函数代码示例

 function EditControl($field, $pageObject, $id)
 {
     $this->field = $field;
     $this->goodFieldName = GoodFieldName($field);
     $this->setID($id);
     $this->pageObject = $pageObject;
     $this->is508 = isEnableSection508();
     $this->strLabel = $pageObject->pSetEdit->label($field);
     $this->type = $pageObject->pSetEdit->getFieldType($this->field);
     $this->like = "ilike";
     $this->searchOptions[CONTAINS] = "Contains";
     $this->searchOptions[EQUALS] = "Equals";
     $this->searchOptions[STARTS_WITH] = "Starts with";
     $this->searchOptions[MORE_THAN] = "More than";
     $this->searchOptions[LESS_THAN] = "Less than";
     $this->searchOptions[BETWEEN] = "Between";
     $this->searchOptions[EMPTY_SEARCH] = "Empty";
     $this->searchOptions[NOT_CONTAINS] = "Doesn't contain";
     $this->searchOptions[NOT_EQUALS] = "Doesn't equal";
     $this->searchOptions[NOT_STARTS_WITH] = "Doesn't start with";
     $this->searchOptions[NOT_MORE_THAN] = "Is not more than";
     $this->searchOptions[NOT_LESS_THAN] = "Is not less than";
     $this->searchOptions[NOT_BETWEEN] = "Is not between";
     $this->searchOptions[NOT_EMPTY] = "Is not empty";
     $this->init();
 }

	public function FilterControl($fName, $pageObj, $id, $viewControls)
	{
		global $conn;
		
		$this->id = $id;
		$this->conn = $conn;
		$this->fName = $fName;
		$this->gfName = GoodFieldName($this->fName);
		$this->tName = $pageObj->tName;
		
		$this->pSet = $pageObj->pSet;
		$this->cipherer = $pageObj->cipherer;
		
		$this->totalsOptions = array(FT_COUNT => "COUNT", FT_MIN => "MIN", FT_MAX => "MAX");
		$this->totals = $this->pSet->getFilterFieldTotal($fName);
		$this->totalsfName = $this->pSet->getFilterTotalsField($fName);
		if(!$this->totalsfName || $this->totals == FT_COUNT) 
			$this->totalsfName = $this->fName;
		
		$this->useTotals = $this->totals != FT_NONE;
		
		$this->multiSelect = $this->pSet->getFilterFiledMultiSelect($fName);	
		
		$this->whereComponents = $pageObj->getWhereComponents();
		$this->filteredFields = $pageObj->searchClauseObj->filteredFields; 
		$this->fieldType = $this->pSet->getFieldType($this->fName);
		
		if( count($this->filteredFields[ $this->fName ]) )
			$this->filtered = true;
			
		$this->assignViewControls($viewControls);

		$this->showCollapsed = $this->pSet->showCollapsed($this->fName);
	}

    public function showDBValue(&$data, $keylink)
    {
        if ($this->container->forExport) {
            return "LONG BINARY DATA - CANNOT BE DISPLAYED";
        }
        $value = "";
        if (@$data[$this->field] != NULL && $this->container->pageType != PAGE_PRINT) {
            $videoId = 'video_' . GoodFieldName(htmlspecialchars($this->field)) . '_';
            $videoId .= $this->getContainer()->id . "_";
            if ($this->getContainer()->pageType != PAGE_ADD) {
                $videoId .= $this->getContainer()->recId;
            } else {
                $videoId .= postvalue("id");
            }
            $type = 'video/flv';
            $fileName = 'file.flv';
            $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field);
            if ($fileNameF) {
                $fileName = $data[$fileNameF];
                if (!$fileName) {
                    $fileName = 'file.flv';
                } else {
                    $type = getContentTypeByExtension(substr($fileName, strrpos($fileName, '.')));
                }
            }
            $href = "mfhandler.php?filename=" . $fileName . "&table=" . rawurlencode($this->getContainer()->pSet->_table) . "&field=" . rawurlencode($this->field) . "&pageType=" . $this->getContainer()->pageType . $keylink;
            if (isMobileIOS()) {
                $value = '<video width="' . $this->getContainer()->pSet->getVideoWidth($this->field) . '" height="' . $this->getContainer()->pSet->getVideoHeight($this->field) . '" controls="controls">
						  <source src="' . $href . '" type="' . $type . '" />
						  Your browser does not support the video tag.
						</video>';
            } else {
                $vWidth = $this->getContainer()->pSet->getVideoWidth($this->field);
                $vHeight = $this->getContainer()->pSet->getVideoHeight($this->field);
                if ($vWidth == 0) {
                    $vWidth = 300;
                }
                if ($vHeight == 0) {
                    $vHeight = 200;
                }
                $value .= '
					<div style="width:' . $vWidth . 'px; height:' . $vHeight . 'px;">
					<video class="projekktor" width="' . $vWidth . '" height="' . $vHeight . '" id="' . $videoId . '" type="' . $type . '" src="' . $href . '" >
					</video></div>';
            }
            if ($this->pageObject != null) {
                $this->pageObject->controlsMap['video'][] = $videoId;
            }
        } else {
            $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field);
            if ($fileNameF) {
                $fileName = $data[$fileNameF];
                if (!$fileName) {
                    $value = $fileName;
                }
            }
        }
        return $value;
    }

 function simpleSearchFieldCombo($fNamesArr, $selOpt)
 {
     $options = "";
     if (sizeof($this->pSet->getGoogleLikeFields()) != 0) {
         $options = '<option value="" >' . "Any field" . '</option>';
     }
     foreach ($fNamesArr as $fName) {
         $fLabel = GetFieldLabel(GoodFieldName($this->tName), GoodFieldName($fName));
         $options .= '<option value="' . $fName . '" ' . ($selOpt == $fName ? 'selected' : '') . '>' . $fLabel . '</option>';
     }
     return $options;
 }

 function simpleSearchFieldCombo($fNamesArr, $selOpt)
 {
     $options = "";
     if (sizeof(GetTableData($this->tName, ".googleLikeFields", array())) != 0) {
         $options = '<option value="" >' . mlang_message("ANY_FIELD") . '</option>';
     }
     foreach ($fNamesArr as $fName) {
         $fLabel = GetFieldLabel(GoodFieldName($this->tName), GoodFieldName($fName));
         $options .= '<option value="' . $fName . '" ' . ($selOpt == $fName ? 'selected' : '') . '>' . $fLabel . '</option>';
     }
     return $options;
 }

    public function showDBValue(&$data, $keylink)
    {
        $value = "";
        if (@$data[$this->field] != NULL && $this->container->pageType != PAGE_PRINT) {
            $videoId = 'video_' . GoodFieldName(runner_htmlspecialchars($this->field)) . '_';
            $videoId .= $this->getContainer()->id . "_";
            if ($this->getContainer()->pageType != PAGE_ADD) {
                $videoId .= $this->getContainer()->recId;
            } else {
                $videoId .= postvalue("id");
            }
            $type = 'video/mp4';
            $fileName = 'file.mp4';
            $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field);
            if ($fileNameF) {
                $fileName = $data[$fileNameF];
                if (!$fileName) {
                    $fileName = 'file.mp4';
                } else {
                    $type = getContentTypeByExtension(substr($fileName, strrpos($fileName, '.')));
                }
            }
            $href = GetTableLink("mfhandler", "", "filename=" . $fileName . "&table=" . rawurlencode($this->getContainer()->pSet->_table) . "&field=" . rawurlencode($this->field) . "&pageType=" . $this->getContainer()->pageType . $keylink);
            $vWidth = $this->getContainer()->pSet->getVideoWidth($this->field);
            $vHeight = $this->getContainer()->pSet->getVideoHeight($this->field);
            if ($vWidth == 0) {
                $vWidth = 300;
            }
            if ($vHeight == 0) {
                $vHeight = 200;
            }
            $value .= '
				<div style="width:' . $vWidth . 'px; height:' . $vHeight . 'px;">
				<video class="projekktor" width="' . $vWidth . '" height="' . $vHeight . '" id="' . $videoId . '" type="' . $type . '" src="' . $href . '" >
				</video></div>';
            if ($this->pageObject != null) {
                $this->pageObject->controlsMap['video'][] = $videoId;
            }
        } else {
            $fileNameF = $this->getContainer()->pSet->getFilenameField($this->field);
            if ($fileNameF) {
                $fileName = $data[$fileNameF];
                if (!$fileName) {
                    $value = $fileName;
                }
            }
        }
        return $value;
    }

 public function showDBValue(&$data, $keylink)
 {
     if (!$this->pageObject) {
         return htmlspecialchars($data[$this->field]);
     }
     if ($this->pageObject->pageType != PAGE_LIST) {
         $mapData = $this->pageObject->addGoogleMapData($this->field, $data);
     }
     if ($this->pageObject->pageType != PAGE_PRINT && $this->pageObject->pageType != PAGE_RPRINT) {
         return '<div id="littleMap_' . GoodFieldName($this->field) . '_' . $this->pageObject->recId . '" style="width: ' . $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['width'] . 'px; height: ' . $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['height'] . 'px;"></div>';
     } else {
         if ($mapData['markers'][0]['lat'] == "" && $mapData['markers'][0]['lng'] == "") {
             $location = $mapData['markers'][0]['address'];
         } else {
             $location = $mapData['markers'][0]['lat'] . ',' . $mapData['markers'][0]['lng'];
         }
         $src = 'http://maps.googleapis.com/maps/api/staticmap?center=' . $location . '&zoom=' . $mapData['zoom'] . '&size=' . $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['width'] . 'x' . $this->pageObject->googleMapCfg['fieldsAsMap'][$this->field]['height'] . '&maptype=mobile&markers=' . $location . '&sensor=false';
         return '<img border="0" alt="" src="' . $src . '">';
     }
 }

 function EditControl($field, $pageObject, $id, $connection)
 {
     $this->field = $field;
     $this->goodFieldName = GoodFieldName($field);
     $this->setID($id);
     $this->connection = $connection;
     $this->pageObject = $pageObject;
     $this->is508 = isEnableSection508();
     $this->strLabel = $pageObject->pSetEdit->label($field);
     $this->type = $pageObject->pSetEdit->getFieldType($this->field);
     if ($this->connection->dbType == nDATABASE_Oracle) {
         $this->isOracle = true;
     }
     if ($this->connection->dbType == nDATABASE_MSSQLServer) {
         $this->ismssql = true;
     }
     if ($this->connection->dbType == nDATABASE_DB2) {
         $this->isdb2 = true;
     }
     if ($this->connection->dbType == nDATABASE_MySQL) {
         $this->isMysql = true;
     }
     if ($this->connection->dbType == nDATABASE_PostgreSQL) {
         $this->like = "ilike";
     }
     $this->searchOptions[CONTAINS] = "Contiene";
     $this->searchOptions[EQUALS] = "Equivale";
     $this->searchOptions[STARTS_WITH] = "Empieza con";
     $this->searchOptions[MORE_THAN] = "Más que";
     $this->searchOptions[LESS_THAN] = "Menos que";
     $this->searchOptions[BETWEEN] = "Entre";
     $this->searchOptions[EMPTY_SEARCH] = "Vacio";
     $this->searchOptions[NOT_CONTAINS] = "No contiene";
     $this->searchOptions[NOT_EQUALS] = "No es igual";
     $this->searchOptions[NOT_STARTS_WITH] = "No empieza por";
     $this->searchOptions[NOT_MORE_THAN] = "No mayor que";
     $this->searchOptions[NOT_LESS_THAN] = "No menor que";
     $this->searchOptions[NOT_BETWEEN] = "No está entre";
     $this->searchOptions[NOT_EMPTY] = "No está vacío";
     $this->init();
 }

 function EditControl($field, $pageObject, $id, $connection)
 {
     $this->field = $field;
     $this->goodFieldName = GoodFieldName($field);
     $this->setID($id);
     $this->connection = $connection;
     $this->pageObject = $pageObject;
     $this->is508 = isEnableSection508();
     $this->strLabel = $pageObject->pSetEdit->label($field);
     $this->type = $pageObject->pSetEdit->getFieldType($this->field);
     if ($this->connection->dbType == nDATABASE_Oracle) {
         $this->isOracle = true;
     }
     if ($this->connection->dbType == nDATABASE_MSSQLServer) {
         $this->ismssql = true;
     }
     if ($this->connection->dbType == nDATABASE_DB2) {
         $this->isdb2 = true;
     }
     if ($this->connection->dbType == nDATABASE_MySQL) {
         $this->isMysql = true;
     }
     if ($this->connection->dbType == nDATABASE_PostgreSQL) {
         $this->like = "ilike";
     }
     $this->searchOptions[CONTAINS] = "Contains";
     $this->searchOptions[EQUALS] = "Equals";
     $this->searchOptions[STARTS_WITH] = "Starts with";
     $this->searchOptions[MORE_THAN] = "More than";
     $this->searchOptions[LESS_THAN] = "Less than";
     $this->searchOptions[BETWEEN] = "Between";
     $this->searchOptions[EMPTY_SEARCH] = "Empty";
     $this->searchOptions[NOT_CONTAINS] = "Doesn't contain";
     $this->searchOptions[NOT_EQUALS] = "Doesn't equal";
     $this->searchOptions[NOT_STARTS_WITH] = "Doesn't start with";
     $this->searchOptions[NOT_MORE_THAN] = "Is not more than";
     $this->searchOptions[NOT_LESS_THAN] = "Is not less than";
     $this->searchOptions[NOT_BETWEEN] = "Is not between";
     $this->searchOptions[NOT_EMPTY] = "Is not empty";
     $this->init();
 }

	function buildSearchCtrlBlockArr($recId, $fName, $ctrlInd, $opt, $not, $isChached, $val1, $val2, $panelField = false, $flexible = true, $immutable = false)
	{
		$srchCtrlBlock = array();
		
		$postfix = '';
		if($panelField)
			$postfix = '_'.GoodFieldName($fName);
		
		// if the search option isn't set by search params use the user's search option settings
		if($opt == "")
			$opt = $this->pSet->getDefaultSearchOption($fName);
		
		// create the first control
		$renderHidden = strtolower($opt) == 'empty' || strtolower($opt) == 'not empty';
		$srchCtrlBlock['searchcontrol'.$postfix] = $this->getCtrlParamsArr($fName, $recId, $ctrlInd, $val1, $opt, $renderHidden, $isChached);

		$renderHidden = strtolower($opt) != 'between' && strtolower($opt) != 'not between';
		if($flexible || !$renderHidden)
		{
			// create the second control
			$srchCtrlBlock['searchcontrol1'.$postfix] = $this->getSecCtrlParamsArr($fName, $recId, $ctrlInd, $val2, $opt, $renderHidden, $isChached);
		}
		
		// del button
		if( !$immutable )
			$srchCtrlBlock['delCtrlButt'] = $this->getDelButtonHtml($fName, $recId);
		
		// one control with options container attr
		$filterRowId = $this->getFilterRowId($recId, $fName);
		$filterRowAttrs = 'id="'.$filterRowId.'" ';
		if($isChached)
			$filterRowAttrs.= $this->dispNoneStyle;
			
		$srchCtrlBlock['filterRow_attrs'.$postfix] = $filterRowAttrs;
		
		if($immutable)
			$srchCtrlBlock['filterRow_class'.$postfix] = 'rnr-basic-search-field';
		
		$srchCtrlBlock['fName'] = $fName;
		// combo with attrs
		$srchCtrlBlock['searchtype'.$postfix] = $this->getCtrlSearchType($fName, $recId, $ctrlInd, $opt, $not, $flexible);
		// checkbox attrs
		$srchCtrlBlock['notbox'] = $this->getNotBox($fName, $recId, $not);
		$srchCtrlBlock['fLabel'.$postfix] = GetFieldLabel(GoodFieldName($this->tName),GoodFieldName($fName));
		
		return $srchCtrlBlock;
	}

 /**
  * buildFieldLabels
  * Draw arrows near field label if field engaged in sorting and build sorting links
  */
 function buildFieldLabels()
 {
     for ($i = 0; $i < count($this->fieldsList); $i++) {
         $order_field = $this->listObject->pSet->GetFieldByIndex($this->fieldsList[$i]->fieldIndex);
         $orderFieldName = GoodFieldName($order_field);
         $order_dir = $this->fieldsList[$i]->orderDirection == "ASC" ? "a" : "d";
         if ($this->fieldsList[$i]->userDefined) {
             $this->listObject->xt->assign_section($orderFieldName . "_fieldheader", "", "<span data-icon=\"" . ($order_dir == "a" ? "sortasc" : "sortdesc") . "\"></span>");
         }
         // default ASC for key fields
         $orderlinkattrs = $this->listObject->setLinksAttr($orderFieldName, $order_dir, $this->fieldsList[$i]->userDefined);
         $this->listObject->xt->assign($orderFieldName . "_orderlinkattrs", $orderlinkattrs);
     }
 }

function getFieldNamesByHeaders($fields)
{
    global $strTableName, $conn, $strOriginalTableName, $ext;
    // check fields in column headers
    // check that we have labes in column headers
    $fieldsNotFoundArr = array();
    $fNamesArr = array();
    $fNamesFromQuery = GetFieldsList($strTableName);
    $fieldLabelError = false;
    $labelFieldsNotFoundArr = array();
    for ($j = 0; $j < count($fields); $j++) {
        $labelNotFound = true;
        for ($i = 0; $i < count($fNamesFromQuery); $i++) {
            if ($ext == ".CSV") {
                $label = GoodFieldName($fNamesFromQuery[$i]);
            } else {
                $label = GetFieldLabel(GoodFieldName($strTableName), GoodFieldName($fNamesFromQuery[$i]));
            }
            if ($fields[$j] == $label) {
                $fNamesArr[$j] = $fNamesFromQuery[$i];
                $labelNotFound = false;
                break;
            }
        }
        if ($labelNotFound) {
            $fieldLabelError = true;
            $labelFieldsNotFoundArr[] = $fields[$j];
        }
    }
    // if field names are not labels, than compare them with fields from query
    $fieldsListError = false;
    $queryFieldsNotFoundArr = array();
    if ($fieldLabelError) {
        $fieldFromListNotFound = true;
        $fNamesArr = array();
        for ($j = 0; $j < count($fields); $j++) {
            $fieldNotFound = true;
            for ($i = 0; $i < count($fNamesFromQuery); $i++) {
                if ($fields[$j] == $fNamesFromQuery[$i]) {
                    $fNamesArr[$j] = $fNamesFromQuery[$i];
                    $fieldNotFound = false;
                    $fieldFromListNotFound = false;
                    break;
                }
            }
            if ($fieldNotFound) {
                $fieldsListError = true;
                $queryFieldsNotFoundArr[] = $fields[$j];
            }
        }
    }
    // if field list not lables or fields from query, than compare fields from DB
    $fieldsDbError = false;
    $dbFieldsNotFoundArr = array();
    if ($fieldLabelError && $fieldsListError) {
        $fNamesArr = array();
        $strSQL = "select * from " . AddTableWrappers($strOriginalTableName);
        $rs = db_query($strSQL, $conn);
        $dbFieldNum = db_numfields($rs);
        for ($j = 0; $j < count($fields); $j++) {
            $fieldFromDBNotFound = true;
            for ($i = 0; $i < $dbFieldNum; $i++) {
                $fNameFromDB = db_fieldname($rs, $i);
                if ($fields[$j] == $fNameFromDB) {
                    $fNamesArr[$j] = $fNameFromDB;
                    $fieldFromDBNotFound = false;
                    break;
                }
            }
            if ($fieldFromDBNotFound) {
                $fieldsDbError = true;
                $dbFieldsNotFoundArr[] = $fields[$j];
            }
        }
    }
    // if fields are not labels, fields from list and fields from table
    if ($fieldLabelError && $fieldsListError && $fieldsDbError) {
        if (count($labelFieldsNotFoundArr) < count($dbFieldsNotFoundArr) && count($labelFieldsNotFoundArr) < count($queryFieldsNotFoundArr)) {
            $fieldsNotFoundArr = $labelFieldsNotFoundArr;
        } elseif (count($dbFieldsNotFoundArr) < count($labelFieldsNotFoundArr) && count($dbFieldsNotFoundArr) < count($queryFieldsNotFoundArr)) {
            $fieldsNotFoundArr = $dbFieldsNotFoundArr;
        } elseif (count($queryFieldsNotFoundArr) < count($labelFieldsNotFoundArr) && count($queryFieldsNotFoundArr) < count($dbFieldsNotFoundArr)) {
            $fieldsNotFoundArr = $queryFieldsNotFoundArr;
        } elseif (count($queryFieldsNotFoundArr) == count($labelFieldsNotFoundArr) && count($queryFieldsNotFoundArr) == count($dbFieldsNotFoundArr)) {
            $fieldsNotFoundArr = $dbFieldsNotFoundArr;
        }
        echo "Import didn't succeed, couldn't find followind fields: " . implode(", ", $fieldsNotFoundArr);
        exit;
    } else {
        return $fNamesArr;
    }
}

function FieldSubmitted($field)
{
    return in_assoc_array("type_" . GoodFieldName($field), $_POST) || in_assoc_array("value_" . GoodFieldName($field), $_POST) || in_assoc_array("value_" . GoodFieldName($field), $_FILES);
}

             $listPageObject->fillSetCntrlMaps();
             $pageObject->jsSettings['tableSettings'][$strTableName] = $listPageObject->jsSettings['tableSettings'][$strTableName];
             $dControlsMap[$strTableName] = $listPageObject->controlsMap;
             $dViewControlsMap[$strTableName] = $listPageObject->viewControlsMap;
             foreach ($listPageObject->jsSettings['global']['shortTNames'] as $keySet => $val) {
                 if (!array_key_exists($keySet, $pageObject->settingsMap["globalSettings"]['shortTNames'])) {
                     $pageObject->settingsMap["globalSettings"]['shortTNames'][$keySet] = $val;
                 }
             }
             //Add detail's js files to master's files
             $pageObject->copyAllJSFiles($listPageObject->grabAllJSFiles());
             //Add detail's css files to master's files
             $pageObject->copyAllCSSFiles($listPageObject->grabAllCSSFiles());
             $xtParams = array("method" => 'showPage', "params" => false);
             $xtParams['object'] = $listPageObject;
             $xt->assign("displayDetailTable_" . GoodFieldName($listPageObject->tName), $xtParams);
             $pageObject->controlsMap['dpTablesParams'][] = array('tName' => $strTableName, 'id' => $options['id']);
         }
     }
     $pageObject->controlsMap['dControlsMap'] = $dControlsMap;
     $pageObject->viewControlsMap['dViewControlsMap'] = $dViewControlsMap;
     $strTableName = "pad.pad_customer";
 }
 //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 //Begin prepare for Next Prev button
 if (!@$_SESSION[$strTableName . "_noNextPrev"] && !$inlineview && !$pdf) {
     $pageObject->getNextPrevRecordKeys($data, "Search", $next, $prev);
 }
 //End prepare for Next Prev button
 //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 if ($pageObject->googleMapCfg['isUseGoogleMap']) {

function db_fld_value(&$data, $field) {
    global $rpt_array;
    if (is_wr_db())
	return $data[GoodFieldName($field)];
    return $data[$field];
}