本文整理汇总了PHP中GetFieldLabel函数的典型用法代码示例。如果您正苦于以下问题:PHP GetFieldLabel函数的具体用法?PHP GetFieldLabel怎么用?PHP GetFieldLabel使用的例子?那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了GetFieldLabel函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: simpleSearchFieldCombo
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;
}
示例2: simpleSearchFieldCombo
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;
}
示例3: displaySearchControl
public function displaySearchControl()
{
$this->searchControlBuilder = new PanelSearchControl($this->searchControllerId, $this->tName, $this->searchClauseObj, $this);
$defaultValue = $this->pSet->getDefaultValue($this->ctrlField);
$ctrlBlockArr = $this->searchControlBuilder->buildSearchCtrlBlockArr($this->id, $this->ctrlField, 0, '', false, true, $defaultValue, '');
// build array for encode
$resArr = array();
$resArr['control1'] = trim($this->xt->call_func($ctrlBlockArr['searchcontrol']));
$resArr['control2'] = trim($this->xt->call_func($ctrlBlockArr['searchcontrol1']));
$resArr['comboHtml'] = trim($ctrlBlockArr['searchtype']);
$resArr['delButt'] = trim($ctrlBlockArr['delCtrlButt']);
$resArr['delButtId'] = trim($this->searchControlBuilder->getDelButtonId($this->ctrlField, $this->id));
$resArr['divInd'] = trim($this->id);
$resArr['fLabel'] = GetFieldLabel(GoodFieldName($this->tName), GoodFieldName($this->ctrlField));
$resArr['ctrlMap'] = $this->controlsMap['controls'];
if (postvalue('isNeedSettings') == 'true') {
$this->fillSettings();
$resArr['settings'] = $this->jsSettings;
}
// return JSON
echo printJSON($resArr);
exit;
}
示例4: array
$fdata["EditFormats"]["search"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between");
// the end of search options settings
$tdataFact_StockTransaction_Report["LastSoldDays"] = $fdata;
// DESCRIP
// Custom field settings
$fdata = array();
$fdata["Index"] = 15;
$fdata["strName"] = "DESCRIP";
$fdata["GoodName"] = "DESCRIP";
$fdata["ownerTable"] = "SMAST";
$fdata["Label"] = GetFieldLabel("Fact_StockTransaction_Report", "DESCRIP");
$fdata["FieldType"] = 200;
// report field settings
// end of report field settings
$fdata["bListPage"] = true;
$fdata["bViewPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "DESCRIP";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "SMAST.DESCRIP";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
示例5: my_json_encode
$pageObject->body['end'] .= "window.settings = " . my_json_encode($pageObject->jsSettings) . ";";
$pageObject->body['end'] .= '</script>';
$pageObject->body['end'] .= "<script language=\"JavaScript\" src=\"include/runnerJS/RunnerAll.js\"></script>\r\n";
$pageObject->body["end"] .= "<script>" . $pageObject->PrepareJs() . "</script>";
$xt->assignbyref("body", $pageObject->body);
$xt->display($templatefile);
exit;
} else {
if ($mode == SEARCH_LOAD_CONTROL) {
$searchControlBuilder = new PanelSearchControl($searchControllerId, $strTableName, $pageObject->searchClauseObj, $pageObject);
$ctrlField = postvalue('ctrlField');
$ctrlBlockArr = $searchControlBuilder->buildSearchCtrlBlockArr($id, $ctrlField, 0, '', false, true, '', '');
// build array for encode
$resArr = array();
$resArr['control1'] = trim($xt->call_func($ctrlBlockArr['searchcontrol']));
$resArr['control2'] = trim($xt->call_func($ctrlBlockArr['searchcontrol1']));
$resArr['comboHtml'] = trim($ctrlBlockArr['searchtype']);
$resArr['delButt'] = trim($ctrlBlockArr['delCtrlButt']);
$resArr['delButtId'] = trim($searchControlBuilder->getDelButtonId($ctrlField, $id));
$resArr['divInd'] = trim($id);
$resArr['fLabel'] = GetFieldLabel(GoodFieldName($strTableName), GoodFieldName($ctrlField));
$resArr['ctrlMap'] = $pageObject->controlsMap['controls'];
if (postvalue('isNeedSettings') == 'true') {
$pageObject->fillSettings();
$resArr['settings'] = $pageObject->jsSettings;
}
// return JSON
echo my_json_encode($resArr);
exit;
}
}
示例6: DisplayMasterTableInfo_BranchMaster
function DisplayMasterTableInfo_BranchMaster($params)
{
global $cman;
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$xt = new Xtempl();
$tName = "BranchMaster";
$xt->eventsObject = getEventObject($tName);
$settings = new ProjectSettings($tName, PAGE_LIST);
$cipherer = new RunnerCipherer($tName);
$connection = $cman->byTable($tName);
$masterQuery = $settings->getSQLQuery();
$viewControls = new ViewControlsContainer($settings, PAGE_LIST);
$where = "";
$keysAssoc = array();
$showKeys = "";
if ($detailtable == "Fact_SalesTransaction") {
$keysAssoc["GroupID"] = $keys[1 - 1];
$keysAssoc["CompanyID"] = $keys[2 - 1];
$where .= RunnerPage::_getFieldSQLDecrypt("GroupID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("GroupID", $keys[1 - 1], "", true);
$keyValue = $viewControls->showDBValue("GroupID", $keysAssoc);
$showKeys .= " " . GetFieldLabel("BranchMaster", "GroupID") . ": " . $keyValue;
$where .= " and ";
$showKeys .= " , ";
$where .= RunnerPage::_getFieldSQLDecrypt("CompanyID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("CompanyID", $keys[2 - 1], "", true);
$keyValue = $viewControls->showDBValue("CompanyID", $keysAssoc);
$showKeys .= " " . GetFieldLabel("BranchMaster", "CompanyID") . ": " . $keyValue;
$xt->assign('showKeys', $showKeys);
}
if (!$where) {
return;
}
$str = SecuritySQL("Search", $tName);
if (strlen($str)) {
$where .= " and " . $str;
}
$strWhere = whereAdd($masterQuery->WhereToSql(), $where);
if (strlen($strWhere)) {
$strWhere = " where " . $strWhere . " ";
}
$strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql();
LogInfo($strSQL);
$data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc());
if (!$data) {
return;
}
// reassign pagetitlelabel function adding extra params
$xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings));
$keylink = "";
$xt->assign("BranchCloudFolder_mastervalue", $viewControls->showDBValue("BranchCloudFolder", $data, $keylink));
$format = $settings->getViewFormat("BranchCloudFolder");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchCloudFolder"))) {
$class = ' rnr-field-number';
}
$xt->assign("BranchCloudFolder_class", $class);
// add class for field header as field value
$xt->assign("BranchLastSyncDate_mastervalue", $viewControls->showDBValue("BranchLastSyncDate", $data, $keylink));
$format = $settings->getViewFormat("BranchLastSyncDate");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("BranchLastSyncDate"))) {
$class = ' rnr-field-number';
}
$xt->assign("BranchLastSyncDate_class", $class);
// add class for field header as field value
$xt->assign("l_mastervalue", $viewControls->showDBValue("l", $data, $keylink));
$format = $settings->getViewFormat("l");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("l"))) {
$class = ' rnr-field-number';
}
$xt->assign("l_class", $class);
// add class for field header as field value
//.........这里部分代码省略.........
示例7: DisplayMasterTableInfo_GE_ESTADO_CIVIL
function DisplayMasterTableInfo_GE_ESTADO_CIVIL($params)
{
global $cman;
$detailtable = $params["detailtable"];
$keys = $params["keys"];
$xt = new Xtempl();
$tName = "GE.ESTADO_CIVIL";
$settings = new ProjectSettings($tName, PAGE_LIST);
$cipherer = new RunnerCipherer($tName);
$connection = $cman->byTable($tName);
$masterQuery = $settings->getSQLQuery();
$viewControls = new ViewControlsContainer($settings, PAGE_LIST);
$where = "";
$keysAssoc = array();
$showKeys = "";
if ($detailtable == "GE.PERSONA_DISPONIBLE") {
$keysAssoc["ESTADO_CIVIL_ID"] = $keys[1 - 1];
$where .= RunnerPage::_getFieldSQLDecrypt("ESTADO_CIVIL_ID", $connection, $settings, $cipherer) . "=" . $cipherer->MakeDBValue("ESTADO_CIVIL_ID", $keys[1 - 1], "", true);
$keyValue = $viewControls->showDBValue("ESTADO_CIVIL_ID", $keysAssoc);
$showKeys .= " " . GetFieldLabel("GE_ESTADO_CIVIL", "ESTADO_CIVIL_ID") . ": " . $keyValue;
$xt->assign('showKeys', $showKeys);
}
if (!$where) {
return;
}
$str = SecuritySQL("Search");
if (strlen($str)) {
$where .= " and " . $str;
}
$strWhere = whereAdd($masterQuery->WhereToSql(), $where);
if (strlen($strWhere)) {
$strWhere = " where " . $strWhere . " ";
}
$strSQL = $masterQuery->HeadToSql() . ' ' . $masterQuery->FromToSql() . $strWhere . $masterQuery->TailToSql();
LogInfo($strSQL);
$data = $cipherer->DecryptFetchedArray($connection->query($strSQL)->fetchAssoc());
if (!$data) {
return;
}
// reassign pagetitlelabel function adding extra params
$xt->assign_function("pagetitlelabel", "xt_pagetitlelabel", array("record" => $data, "settings" => $settings));
$keylink = "";
$keylink .= "&key1=" . runner_htmlspecialchars(rawurlencode(@$data["ESTADO_CIVIL_ID"]));
$xt->assign("ESTADO_CIVIL_ID_mastervalue", $viewControls->showDBValue("ESTADO_CIVIL_ID", $data, $keylink));
$format = $settings->getViewFormat("ESTADO_CIVIL_ID");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("ESTADO_CIVIL_ID"))) {
$class = ' rnr-field-number';
}
$xt->assign("ESTADO_CIVIL_ID_class", $class);
// add class for field header as field value
$xt->assign("NOMBRE_mastervalue", $viewControls->showDBValue("NOMBRE", $data, $keylink));
$format = $settings->getViewFormat("NOMBRE");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("NOMBRE"))) {
$class = ' rnr-field-number';
}
$xt->assign("NOMBRE_class", $class);
// add class for field header as field value
$xt->assign("FEC_CREACION_mastervalue", $viewControls->showDBValue("FEC_CREACION", $data, $keylink));
$format = $settings->getViewFormat("FEC_CREACION");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
if ($format == FORMAT_AUDIO) {
$class = ' rnr-field-audio';
}
if ($format == FORMAT_CHECKBOX) {
$class = ' rnr-field-checkbox';
}
if ($format == FORMAT_NUMBER || IsNumberType($settings->getFieldType("FEC_CREACION"))) {
$class = ' rnr-field-number';
}
$xt->assign("FEC_CREACION_class", $class);
// add class for field header as field value
$xt->assign("USUARIO_CREACION_mastervalue", $viewControls->showDBValue("USUARIO_CREACION", $data, $keylink));
$format = $settings->getViewFormat("USUARIO_CREACION");
$class = " rnr-field-text";
if ($format == FORMAT_FILE) {
$class = ' rnr-field-file';
}
//.........这里部分代码省略.........
示例8: array
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between");
// the end of search options settings
$tdataGE_COLOR_PELO["FEC_ULTIMA_MOD"] = $fdata;
// USUARIO_ULTIMA_MOD
// Custom field settings
$fdata = array();
$fdata["Index"] = 6;
$fdata["strName"] = "USUARIO_ULTIMA_MOD";
$fdata["GoodName"] = "USUARIO_ULTIMA_MOD";
$fdata["ownerTable"] = "GE.COLOR_PELO";
$fdata["Label"] = GetFieldLabel("GE_COLOR_PELO", "USUARIO_ULTIMA_MOD");
$fdata["FieldType"] = 200;
$fdata["bListPage"] = true;
$fdata["bInlineAdd"] = true;
$fdata["bInlineEdit"] = true;
$fdata["bViewPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "USUARIO_ULTIMA_MOD";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "USUARIO_ULTIMA_MOD";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
示例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_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);
}
}
}
示例10: array
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Empty");
// the end of search options settings
$tdataGE_PERSONA_DISPONIBLE["USUARIO_ULTIMA_MOD"] = $fdata;
// TIPO_RELACION_ID
// Custom field settings
$fdata = array();
$fdata["Index"] = 20;
$fdata["strName"] = "TIPO_RELACION_ID";
$fdata["GoodName"] = "TIPO_RELACION_ID";
$fdata["ownerTable"] = "GE.PERSONA_DISPONIBLE";
$fdata["Label"] = GetFieldLabel("GE_PERSONA_DISPONIBLE", "TIPO_RELACION_ID");
$fdata["FieldType"] = 14;
$fdata["bListPage"] = true;
$fdata["bAddPage"] = true;
$fdata["bInlineAdd"] = true;
$fdata["bEditPage"] = true;
$fdata["bInlineEdit"] = true;
$fdata["bViewPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "TIPO_RELACION_ID";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "TIPO_RELACION_ID";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
示例11: array
// the default search options list
$fdata["searchOptionsList"] = array("Contains", "Equals", "Empty");
// the end of search options settings
$tdatawebreport_users["password"] = $fdata;
// email
// Custom field settings
$fdata = array();
$fdata["Index"] = 4;
$fdata["strName"] = "email";
$fdata["GoodName"] = "email";
$fdata["ownerTable"] = "webreport_users";
$fdata["Label"] = GetFieldLabel("webreport_users","email");
$fdata["FieldType"] = 200;
$fdata["bListPage"] = true;
$fdata["bAddPage"] = true;
$fdata["bInlineAdd"] = true;
$fdata["bEditPage"] = true;
$fdata["bInlineEdit"] = true;
$fdata["bViewPage"] = true;
示例12: array
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between");
// the end of search options settings
$tdataGE_SALARIO["FEC_ULTIMA_MOD"] = $fdata;
// USUARIO_ULTIMA_MOD
// Custom field settings
$fdata = array();
$fdata["Index"] = 6;
$fdata["strName"] = "USUARIO_ULTIMA_MOD";
$fdata["GoodName"] = "USUARIO_ULTIMA_MOD";
$fdata["ownerTable"] = "GE.SALARIO";
$fdata["Label"] = GetFieldLabel("GE_SALARIO", "USUARIO_ULTIMA_MOD");
$fdata["FieldType"] = 200;
$fdata["bListPage"] = true;
$fdata["bInlineAdd"] = true;
$fdata["bInlineEdit"] = true;
$fdata["bViewPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "USUARIO_ULTIMA_MOD";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "USUARIO_ULTIMA_MOD";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
示例13: array
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between");
// the end of search options settings
$tdataGE_CIUDAD["FEC_ULTIMA_MOD"] = $fdata;
// USUARIO_ULTIMA_MOD
// Custom field settings
$fdata = array();
$fdata["Index"] = 7;
$fdata["strName"] = "USUARIO_ULTIMA_MOD";
$fdata["GoodName"] = "USUARIO_ULTIMA_MOD";
$fdata["ownerTable"] = "GE.CIUDAD";
$fdata["Label"] = GetFieldLabel("GE_CIUDAD", "USUARIO_ULTIMA_MOD");
$fdata["FieldType"] = 200;
$fdata["bListPage"] = true;
$fdata["bInlineAdd"] = true;
$fdata["bInlineEdit"] = true;
$fdata["bViewPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "USUARIO_ULTIMA_MOD";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "USUARIO_ULTIMA_MOD";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
示例14: DisplayMasterTableInfo_Customers
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;
}
示例15: array
$fdata["EditFormats"]["edit"] = $edata;
// End Edit Formats
$fdata["isSeparate"] = false;
// the field's search options settings
// the default search options list
$fdata["searchOptionsList"] = array("Equals", "More than", "Less than", "Between");
// the end of search options settings
$tdataGE_PERSONA_DISPONIBLEXEJERCICIO["FEC_ULTIMA_MOD"] = $fdata;
// USUARIO_ULTIMA_MOD
// Custom field settings
$fdata = array();
$fdata["Index"] = 7;
$fdata["strName"] = "USUARIO_ULTIMA_MOD";
$fdata["GoodName"] = "USUARIO_ULTIMA_MOD";
$fdata["ownerTable"] = "GE.PERSONA_DISPONIBLEXEJERCICIO";
$fdata["Label"] = GetFieldLabel("GE_PERSONA_DISPONIBLEXEJERCICIO", "USUARIO_ULTIMA_MOD");
$fdata["FieldType"] = 200;
$fdata["bListPage"] = true;
$fdata["bAdvancedSearch"] = true;
$fdata["bPrinterPage"] = true;
$fdata["bExportPage"] = true;
$fdata["strField"] = "USUARIO_ULTIMA_MOD";
$fdata["isSQLExpression"] = true;
$fdata["FullName"] = "USUARIO_ULTIMA_MOD";
$fdata["FieldPermissions"] = true;
$fdata["UploadFolder"] = "files";
// Begin View Formats
$fdata["ViewFormats"] = array();
$vdata = array("ViewFormat" => "");
$vdata["NeedEncode"] = true;
$fdata["ViewFormats"]["view"] = $vdata;