作者：ryanblanchar
项目：Dashboar
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;
}
作者：samsulpendi
项目：Instant_Appointmen
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;
}
作者：ryanblanchar
项目：Dashboar
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;
}
作者：ryanblanchar
项目：Dashboar
$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();
作者：aagust
项目：padl-tn
$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;
}
}
作者：ryanblanchar
项目：Dashboar
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
//.........这里部分代码省略.........
作者：kcallo
项目：MatchM
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';
}
//.........这里部分代码省略.........
作者：kcallo
项目：MatchM
$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();
作者：samsulpendi
项目：Instant_Appointmen
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);
}
}
}
作者：kcallo
项目：MatchM
$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";
作者：helbertfurbin
项目：sgmofinanceir
// 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;
作者：kcallo
项目：MatchM
$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();
作者：kcallo
项目：MatchM
$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();
作者：samsulpendi
项目：Instant_Appointmen
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;
}
作者：kcallo
项目：MatchM
$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;
作者：ryanblanchar
项目：Dashboar
<attr value="label">' . xmlencode(GetFieldLabel("Top_Grossing_Products_YTD", "SUM_Fact_DiscountValue_")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataTop_Grossing_Products_YTD[".chartXml"] .= '<attr value="10">
<attr value="name">SUM(Fact_GrossProfit)</attr>
<attr value="label">' . xmlencode(GetFieldLabel("Top_Grossing_Products_YTD", "SUM_Fact_GrossProfit_")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataTop_Grossing_Products_YTD[".chartXml"] .= '<attr value="11">
<attr value="name">SUM(Fact_GP)</attr>
<attr value="label">' . xmlencode(GetFieldLabel("Top_Grossing_Products_YTD", "SUM_Fact_GP_")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataTop_Grossing_Products_YTD[".chartXml"] .= '<attr value="12">
<attr value="name">AVG(QOH)</attr>
<attr value="label">' . xmlencode(GetFieldLabel("Top_Grossing_Products_YTD", "AVG_QOH_")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataTop_Grossing_Products_YTD[".chartXml"] .= '</attr>
<attr value="settings">
<attr value="name">Top Grossing Products YTD</attr>
<attr value="short_table_name">Top_Grossing_Products_YTD</attr>
</attr>
</chart>';
$tables_data["Top Grossing Products YTD"] =& $tdataTop_Grossing_Products_YTD;
$field_labels["Top_Grossing_Products_YTD"] =& $fieldLabelsTop_Grossing_Products_YTD;
$fieldToolTips["Top Grossing Products YTD"] =& $fieldToolTipsTop_Grossing_Products_YTD;
$page_titles["Top_Grossing_Products_YTD"] =& $pageTitlesTop_Grossing_Products_YTD;
作者：kayecand
项目：secude
<b><?php
echo GetFieldLabel($itemField);
?>
</b>
<?php
if (GetFieldLabel($itemField) == "Image") {
?>
<input name="<?php
echo GetFieldLabel($itemField);
?>
" type="file"></input>
<?php
} else {
?>
<input name="<?php
echo GetFieldLabel($itemField);
?>
" type="text" value="<?php
echo $item[GetFieldName($itemField)];
?>
"></input>
<?php
}
?>
<?php
}
?>
<br><br>
<?php
}
作者：ryanblanchar
项目：Dashboar
<attr value="linestyle">0</attr>
<attr value="autoupdate">0</attr>
<attr value="autoupmin">60</attr>
<attr value="cscroll">true</attr>
<attr value="maxbarscroll">10</attr>';
$tdataSales_By_Department[".chartXml"] .= '</attr>
<attr value="fields">';
$tdataSales_By_Department[".chartXml"] .= '<attr value="0">
<attr value="name">DepartmentDesc</attr>
<attr value="label">' . xmlencode(GetFieldLabel("Sales_By_Department", "DepartmentDesc")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataSales_By_Department[".chartXml"] .= '<attr value="1">
<attr value="name">MTD Sales</attr>
<attr value="label">' . xmlencode(GetFieldLabel("Sales_By_Department", "MTD_Sales")) . '</attr>
<attr value="search"></attr>
</attr>';
$tdataSales_By_Department[".chartXml"] .= '</attr>
<attr value="settings">
<attr value="name">Sales By Department</attr>
<attr value="short_table_name">Sales_By_Department</attr>
</attr>
</chart>';
$tables_data["Sales By Department"] =& $tdataSales_By_Department;
$field_labels["Sales_By_Department"] =& $fieldLabelsSales_By_Department;
$fieldToolTips["Sales By Department"] =& $fieldToolTipsSales_By_Department;
$page_titles["Sales_By_Department"] =& $pageTitlesSales_By_Department;
作者：samsulpendi
项目：Instant_Appointmen
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"]);
}
//.........这里部分代码省略.........
作者：kcallo
项目：MatchM
$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_CATEGORIA_OCUPACION["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.CATEGORIA_OCUPACION";
$fdata["Label"] = GetFieldLabel("GE_CATEGORIA_OCUPACION", "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();
