Exemplo n.º 1
0
 /**
  * Fills info in array about grid.
  * For new add row
  * @param array $rowInfoArr array with total info, that assignes grid
  */
 function fillGridShowInfo(&$rowInfoArr)
 {
     $rowInfoArr["data"] = array();
     $editlink = "";
     $copylink = "";
     //	add inline add row
     if ($this->mainPSet->isAllowToAdd($this->mainField) && $this->permis[$this->tName]['add']) {
         $row = array();
         $row["rowclass"] = "gridRowAdd " . $this->makeClassName("hiddenelem");
         $row["rsclass"] = "gridRowSepAdd " . $this->makeClassName("hiddenelem");
         if ($this->listGridLayout == gltVERTICAL) {
             $row["rowattrs"] .= "vertical=\"1\"";
         }
         $record = array();
         $record["edit_link"] = true;
         $record["inlineedit_link"] = true;
         $record["view_link"] = true;
         $record["copy_link"] = true;
         $record["checkbox"] = true;
         $record["checkbox"] = true;
         $record["editlink_attrs"] = "id=\"editLink_add" . $this->id . "\"";
         $record["copylink_attrs"] = "id=\"copyLink_add" . $this->id . "\" name=\"copyLink_add" . $this->id . "\"";
         $record["viewlink_attrs"] = "id=\"viewLink_add" . $this->id . "\" name=\"viewLink_add" . $this->id . "\"";
         $record["checkbox_attrs"] = "id=\"check_add" . $this->id . "\" name=\"selection[]\"";
         //	add container for inline add controls
         $addedInlineAddContainer = false;
         if ($this->permis[$this->tName]['edit'] && $this->isUseInlineEdit) {
             $record["inlineeditlink_attrs"] = "id=\"inlineEdit_add" . $this->id . "\" ";
             $addedInlineAddContainer = true;
         }
         for ($i = 0; $i < count($this->allDetailsTablesArr); $i++) {
             //detail tables
             $dDataSourceTable = $this->allDetailsTablesArr[$i]['dDataSourceTable'];
             $dShortTable = $this->allDetailsTablesArr[$i]['dShortTable'];
             $record[$dShortTable . "_dtable_link"] = $this->permis[$dDataSourceTable]['add'] || $this->permis[$dDataSourceTable]['search'];
             $record[$dShortTable . "_dtablelink_attrs"] = " href=\"" . GetTableLink($dShortTable, "list") . "\" id=\"master_" . $dShortTable . "_add" . $this->id . "\" ";
             if ($this->allDetailsTablesArr[$i]['previewOnList'] == DP_INLINE) {
                 $record[$dShortTable . "_dtablelink_attrs"] = "id = \"" . $dShortTable . "_preview" . $this->id . "\"\n\t\t\t\t\t\tcaption = \"" . GetTableCaption(GoodFieldName($dDataSourceTable)) . "\" \n\t\t\t\t\t\thref = \"" . GetTableLink($dShortTable, "list") . "\"\n\t\t\t\t\t\tstyle = \"display:none;\"";
             }
         }
         $this->addSpansForGridCells('add', $record);
         for ($i = 0; $i < count($this->listFields); $i++) {
             $field = $this->listFields[$i]['fName'];
             $gFieldName = GoodFieldName($field);
             if (!$addedInlineAddContainer) {
                 if ($i == 0 && !($this->permis[$this->tName]['edit'] && $this->isUseInlineEdit)) {
                     $record[$gFieldName . "_value"] .= "<span id=\"inlineEdit_add" . $this->id . "\"></span>";
                 }
             }
             $record[$gFieldName . "_class"] .= $this->fieldClass($field);
             if (isset($this->hiddenColumnClasses[$field])) {
                 $record[$gFieldName . "_class"] .= " " . $this->hiddenColumnClasses[$field];
                 if ($this->listGridLayout != gltHORIZONTAL) {
                     $record[$gFieldName . "_label_class"] = $this->hiddenColumnClasses[$field];
                 }
             }
         }
         if ($this->colsOnPage > 1) {
             $record["endrecord_block"] = true;
         }
         $record["grid_recordheader"] = true;
         $record["grid_vrecord"] = true;
         $row["grid_record"] = array("data" => array());
         //set the $row["grid_record"] value
         $this->setRowsGridRecord($row, $record);
         for ($i = 1; $i < $this->colsOnPage; $i++) {
             $rec = array();
             if ($i < $this->colsOnPage - 1) {
                 $rec["endrecord_block"] = true;
             }
             if ($row["grid_record"]["data"]) {
                 $row["grid_record"]["data"][] = $rec;
             }
         }
         $row["grid_rowspace"] = true;
         $row["grid_recordspace"] = array("data" => array());
         for ($i = 0; $i < $this->colsOnPage * 2 - 1; $i++) {
             $row["grid_recordspace"]["data"][] = true;
         }
         $rowInfoArr["data"][] = $row;
     }
 }
$tdataFact_SalesTransaction["Fact_Salescol"] = $fdata;
$tables_data["Fact_SalesTransaction"] =& $tdataFact_SalesTransaction;
$field_labels["Fact_SalesTransaction"] =& $fieldLabelsFact_SalesTransaction;
$fieldToolTips["Fact_SalesTransaction"] =& $fieldToolTipsFact_SalesTransaction;
$page_titles["Fact_SalesTransaction"] =& $pageTitlesFact_SalesTransaction;
// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["Fact_SalesTransaction"] = array();
//	GroupMaster
$dIndex = 0;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "GroupMaster";
$detailsParam["dOriginalTable"] = "GroupMaster";
$detailsParam["dType"] = PAGE_LIST;
$detailsParam["dShortTable"] = "GroupMaster";
$detailsParam["dCaptionTable"] = GetTableCaption("GroupMaster");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = false;
$detailsParam["previewOnList"] = 1;
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 0;
$detailsTablesData["Fact_SalesTransaction"][$dIndex] = $detailsParam;
$detailsTablesData["Fact_SalesTransaction"][$dIndex]["masterKeys"] = array();
$detailsTablesData["Fact_SalesTransaction"][$dIndex]["masterKeys"][] = "GroupID";
$detailsTablesData["Fact_SalesTransaction"][$dIndex]["detailKeys"] = array();
$detailsTablesData["Fact_SalesTransaction"][$dIndex]["detailKeys"][] = "Groupid";
// tables which are master tables for current table (detail)
$masterTablesData["Fact_SalesTransaction"] = array();
Exemplo n.º 3
0
 function getDefaultValue($series, $row)
 {
     if ($this->chrt_array["chart_type"]["type"] == "ohlc" || $this->chrt_array["chart_type"]["type"] == "candlestick") {
         $res = "O: " . $this->formatCurrency("{%Open}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
         $res .= "H: " . $this->formatCurrency("{%High}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
         $res .= "L: " . $this->formatCurrency("{%Low}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
         $res .= "C: " . $this->formatCurrency("{%Close}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
     } elseif ($this->chrt_array["chart_type"]["type"] == "bubble") {
         $res = "Series: {%SeriesName}" . "\r";
         $res .= "Point Name: " . $this->labelFormat($this->strLabel, $row) . "" . "\r";
         $res .= "Value: " . $this->formatCurrency("{%Value}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
         $res .= "Bubble Size: {%BubbleSize}" . "\r";
     } elseif ($this->chrt_array["chart_type"]["type"] == "2d_bar" || $this->chrt_array["chart_type"]["type"] == "2d_column" || $this->chrt_array["chart_type"]["type"] == "area" || $this->chrt_array["chart_type"]["type"] == "funnel") {
         $res = $this->labelFormat($this->strLabel, $row) . " - " . $this->formatCurrency("{%YValue}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series);
     } elseif ($this->chrt_array["chart_type"]["type"] == "line" || $this->chrt_array["chart_type"]["type"] == "combined") {
         $res = "Series: {%SeriesName}" . "\r";
         $res .= "Point Name: " . $this->labelFormat($this->strLabel, $row) . "\r";
         $res .= "Value: " . $this->formatCurrency("{%Value}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
     } elseif ($this->chrt_array["chart_type"]["type"] == "2d_pie" || $this->chrt_array["chart_type"]["type"] == "2d_doughnut") {
         $res = $this->labelFormat($this->strLabel, $row) . " - " . $this->formatCurrency("{%YValue}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series) . "\r";
         $res .= "Percent: {%YPercentOfSeries}{numDecimals:" . $this->arrFormatDecimal[$series] . "}%";
     } else {
         $res = $this->formatCurrency("{%YValue}{numDecimals:" . $this->arrFormatDecimal[$series] . "}", $series);
     }
     if (count($this->detailTablesData)) {
         $tableCaption = GetTableCaption($this->detailTablesData[0]['dDataSourceTable']);
         $tableCaption = $tableCaption ? $tableCaption : runner_htmlspecialchars($this->detailTablesData[0]['dDataSourceTable']);
         $res .= "\r Click to see " . $tableCaption . " details";
     }
     return $res;
 }
Exemplo n.º 4
0
 /**
  * Proccess master-details on list grid
  *
  * @param array $record
  * @param array $data
  */
 function proccessDetailGridInfo(&$record, &$data, $gridRowInd)
 {
     for ($i = 0; $i < count($this->allDetailsTablesArr); $i++) {
         $dDataSourceTable = $this->allDetailsTablesArr[$i]['dDataSourceTable'];
         $dShortTable = $this->allDetailsTablesArr[$i]['dShortTable'];
         $masterquery = "mastertable=" . rawurlencode($this->tName);
         $this->controlsMap['gridRows'][$gridRowInd]['masterKeys'][$dDataSourceTable] = array();
         $detailid = array();
         foreach ($this->masterKeysByD[$i] as $idx => $m) {
             $d = $this->detailKeysByD[$i][$idx];
             $masterquery .= "&masterkey" . ($idx + 1) . "=" . rawurlencode($data[$m]);
             // Don't need to use here make_db_value func, it use in countDetailsRecsNoSubQ func
             $detailid[] = $data[$m];
             $this->controlsMap['gridRows'][$gridRowInd]['masterKeys'][$dDataSourceTable]["masterkey" . ($idx + 1)] = $data[$m];
         }
         //	add count of child records to SQL
         if (($this->allDetailsTablesArr[$i]['dispChildCount'] || $this->allDetailsTablesArr[$i]['hideChild']) && (!$this->subQueriesSupp || !$this->subQueriesSupAccess || $this->theSameFieldsType)) {
             $data[$dDataSourceTable . "_cnt"] = $this->countDetailsRecsNoSubQ($i, $detailid);
         }
         //detail tables
         $record[$dShortTable . "_dtable_link"] = $this->permis[$dDataSourceTable]['add'] || $this->permis[$dDataSourceTable]['search'];
         if ($this->allDetailsTablesArr[$i]['dispChildCount']) {
             if ($data[$dDataSourceTable . "_cnt"] + 0) {
                 $record[$dShortTable . "_childcount"] = true;
             }
             $record[$dShortTable . "_childnumber"] = $data[$dDataSourceTable . "_cnt"];
             $record[$dShortTable . "_childnumber_attr"] = " id='cntDet_" . $dShortTable . "_" . $this->recId . "'";
             $this->controlsMap['gridRows'][$gridRowInd]['childNum'] = $data[$dDataSourceTable . "_cnt"];
         }
         //if($this->pSet->getDPType($dDataSourceTable) == DP_POPUP)
         //	$record[$dShortTable."_dtablelink_attrs"].= " onmouseover=\"RollDetailsLink.showPopup(this,'".$dShortTable."_detailspreview.php'+this.href.substr(this.href.indexOf('?')));\" onmouseout=\"RollDetailsLink.hidePopup();\"";
         if ($this->pSet->getDPType($dDataSourceTable) == DP_INLINE) {
             $record[$dShortTable . "_dtablelink_attrs"] = "\r\n\t\t\t\t\tid = \"" . $dShortTable . "_preview" . $this->recId . "\" \r\n\t\t\t\t\tcaption = \"" . htmlspecialchars(GetTableCaption(GoodFieldName($dDataSourceTable))) . "\"" . "href = \"" . $dShortTable . "_list.php?" . $masterquery . "\"";
         } else {
             $record[$dShortTable . "_dtablelink_attrs"] = "id=\"master_" . $dShortTable . "_" . $this->recId . "\" href=\"" . $dShortTable . "_list.php?" . $masterquery . "\"";
         }
         if ($this->allDetailsTablesArr[$i]['hideChild']) {
             if (!($data[$dDataSourceTable . "_cnt"] + 0)) {
                 $record[$dShortTable . "_dtablelink_attrs"] .= " class=\"runner-hiddenelem\"";
             }
         }
     }
 }
Exemplo n.º 5
0
function xt_caption($params)
{
    echo GetTableCaption($params["custom1"]);
}
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 1;
$detailsTablesData["calendar_table"][$dIndex] = $detailsParam;
$detailsTablesData["calendar_table"][$dIndex]["masterKeys"] = array();
$detailsTablesData["calendar_table"][$dIndex]["masterKeys"][] = "dt";
$detailsTablesData["calendar_table"][$dIndex]["detailKeys"] = array();
$detailsTablesData["calendar_table"][$dIndex]["detailKeys"][] = "TranDate";
//	Current Year Sales
$dIndex = 1;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "Current Year Sales";
$detailsParam["dOriginalTable"] = "Fact_SalesTransaction";
$detailsParam["dType"] = PAGE_CHART;
$detailsParam["dShortTable"] = "Current_Year_Sales";
$detailsParam["dCaptionTable"] = GetTableCaption("Current_Year_Sales");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = false;
$detailsParam["previewOnList"] = 0;
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 1;
$detailsTablesData["calendar_table"][$dIndex] = $detailsParam;
$detailsTablesData["calendar_table"][$dIndex]["masterKeys"] = array();
$detailsTablesData["calendar_table"][$dIndex]["masterKeys"][] = "dt";
$detailsTablesData["calendar_table"][$dIndex]["detailKeys"] = array();
$detailsTablesData["calendar_table"][$dIndex]["detailKeys"][] = "TranDate";
// tables which are master tables for current table (detail)
$masterTablesData["calendar_table"] = array();
Exemplo n.º 7
0
 /**
  * Get the default page's title template
  * @param String page
  * @param String table				A good table name
  * @param ProjectSettings pSet	 
  * @return STring
  */
 protected function getDefaultPageTitle($page, $table, $pSet)
 {
     if ($page == "add") {
         return GetTableCaption($table) . ", " . "Add new record";
     }
     if ($page == "edit") {
         return GetTableCaption($table) . ", " . "Edit record" . " [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "view") {
         return GetTableCaption($table) . ", " . "View record" . " [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "export") {
         return "Export";
     }
     if ($page == "import") {
         return GetTableCaption($table) . ", " . "Import";
     }
     if ($page == "search") {
         return GetTableCaption($table) . " - " . "Advanced search";
     }
     if ($page == "print") {
         return GetTableCaption($table);
     }
     if ($page == "rprint") {
         return GetTableCaption($table);
     }
     if ($page == "list") {
         return GetTableCaption($table);
     }
     if ($page == "masterlist") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "masterchart") {
         return GetTableCaption($table);
     }
     if ($page == "masterreport") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "masterprint") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "login") {
         return "Login";
     }
     if ($page == "register") {
         return "Register";
     }
     if ($page == "changepwd") {
         return "Change password";
     }
     if ($page == "remind") {
         return "Password reminder";
     }
     if ($page == "chart") {
         return GetTableCaption($table);
     }
     if ($page == "report") {
         return GetTableCaption($table);
     }
     if ($page == "dashboard") {
         return GetTableCaption($table);
     }
     if ($page == "menu") {
         return "Menu";
     }
 }
Exemplo n.º 8
0
$tdataDimDept["DepartmentDesc"] = $fdata;
$tables_data["DimDept"] =& $tdataDimDept;
$field_labels["DimDept"] =& $fieldLabelsDimDept;
$fieldToolTips["DimDept"] =& $fieldToolTipsDimDept;
$page_titles["DimDept"] =& $pageTitlesDimDept;
// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["DimDept"] = array();
//	Fact_SalesTransaction
$dIndex = 0;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "Fact_SalesTransaction";
$detailsParam["dOriginalTable"] = "Fact_SalesTransaction";
$detailsParam["dType"] = PAGE_LIST;
$detailsParam["dShortTable"] = "Fact_SalesTransaction";
$detailsParam["dCaptionTable"] = GetTableCaption("Fact_SalesTransaction");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = false;
$detailsParam["previewOnList"] = 1;
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 0;
$detailsTablesData["DimDept"][$dIndex] = $detailsParam;
$detailsTablesData["DimDept"][$dIndex]["masterKeys"] = array();
$detailsTablesData["DimDept"][$dIndex]["masterKeys"][] = "DeptID";
$detailsTablesData["DimDept"][$dIndex]["detailKeys"] = array();
$detailsTablesData["DimDept"][$dIndex]["detailKeys"][] = "TranDept";
// tables which are master tables for current table (detail)
$masterTablesData["DimDept"] = array();
Exemplo n.º 9
0
$tdatacompany["coy_city"] = $fdata;
$tables_data["company"] =& $tdatacompany;
$field_labels["company"] =& $fieldLabelscompany;
$fieldToolTips["company"] =& $fieldToolTipscompany;
$page_titles["company"] =& $pageTitlescompany;
// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["company"] = array();
//	StockMaster
$dIndex = 0;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "StockMaster";
$detailsParam["dOriginalTable"] = "StockMaster";
$detailsParam["dType"] = PAGE_LIST;
$detailsParam["dShortTable"] = "StockMaster";
$detailsParam["dCaptionTable"] = GetTableCaption("StockMaster");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = false;
$detailsParam["previewOnList"] = 1;
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 1;
$detailsTablesData["company"][$dIndex] = $detailsParam;
$detailsTablesData["company"][$dIndex]["masterKeys"] = array();
$detailsTablesData["company"][$dIndex]["masterKeys"][] = "coy_id";
$detailsTablesData["company"][$dIndex]["masterKeys"][] = "grp_id";
$detailsTablesData["company"][$dIndex]["detailKeys"] = array();
$detailsTablesData["company"][$dIndex]["detailKeys"][] = "Coy_Id";
$detailsTablesData["company"][$dIndex]["detailKeys"][] = "Grp_id";
Exemplo n.º 10
0
 function RunnerPage(&$params)
 {
     global $locale_info, $cCharset, $page_layouts;
     // copy properties to object
     RunnerApply($this, $params);
     $this->pSet = new ProjectSettings($this->tName, $this->pageType);
     $this->pSetEdit = $this->pSet;
     $this->cipherer = new RunnerCipherer($this->tName, $this->pSet);
     include_once getabspath("classes/controls/EditControlsContainer.php");
     $this->controls = new EditControlsContainer($this);
     include_once getabspath("classes/controls/ViewControlsContainer.php");
     $this->viewControls = new ViewControlsContainer($this->pSet, $this->pageType, $this);
     $this->gQuery = $this->pSet->getSQLQuery();
     //set google map configuration
     $this->googleMapCfg = array('markerAsLinkToView' => true, 'isUseMainMaps' => false, 'isUseFieldsMaps' => false, 'isUseGoogleMap' => false, 'APIcode' => GetGlobalData("apiGoogleMapsCode", ""), 'mainMapIds' => array(), 'fieldMapsIds' => array(), 'mapsData' => array());
     $this->debugJSMode = false;
     if ($this->flyId < $this->id + 1) {
         $this->flyId = $this->id + 1;
     }
     // get permissions
     if ($this->tName) {
         $this->permis[$this->tName] = $this->getPermissions();
         $this->eventsObject =& getEventObject($this->tName);
     }
     if (!$this->sessionPrefix) {
         $this->sessionPrefix = $this->tName;
     }
     $this->setSessionVariables();
     //	get locking object
     $this->lockingObj = GetLockingObject($this->tName);
     $this->is508 = isEnableSection508();
     $this->isEncryptionEnabled = isEncryptionEnabled();
     $this->isEncryptionByPHPEnabled = isEncryptionByPHPEnabled();
     $this->isUseVideo = $this->pSet->isUseVideo();
     $this->isUseAudio = $this->pSet->isUseAudio();
     $this->strCaption = GetTableCaption(GoodFieldName($this->tName));
     $this->isTableType = $this->pSet->isTableType();
     $this->isAddWebRep = GetGlobalData("isAddWebRep", false);
     //	get details keys by master table
     $this->detailKeysByM = $this->pSet->getDetailKeysByMasterTable($this->masterTable);
     $this->isDynamicPerm = GetGlobalData("isDynamicPerm", false);
     $this->shortTableName = $this->pSet->getShortTableName();
     $this->showAddInPopup = $this->pSet->isShowAddInPopup();
     $this->showEditInPopup = $this->pSet->isShowEditInPopup();
     $this->showViewInPopup = $this->pSet->isShowViewInPopup();
     $this->isResizeColumns = $this->pSet->isResizeColumns();
     $this->isUseAjaxSuggest = $this->pSet->isUseAjaxSuggest();
     $this->useDetailsPreview = $this->pSet->isUseDetailsPreview();
     $this->isShowDetailTables = displayDetailsOn($this->tName, $this->pageType);
     //	get all details table for current table
     $this->allDetailsTablesArr = $this->pSet->getDetailTablesArr();
     //	set template file
     $this->setTemplateFile();
     //	init jsSettings
     $this->jsSettings["tableSettings"][$this->tName] = array();
     $this->jsSettings["tableSettings"][$this->tName]["proxy"] = array("proxy" => "");
     $this->jsSettings["tableSettings"][$this->tName]['fieldSettings'] = array();
     $this->settingsMap["globalSettings"] = array();
     $this->settingsMap["globalSettings"]["ext"] = "php";
     $this->settingsMap["globalSettings"]["charSet"] = $cCharset;
     $this->settingsMap["globalSettings"]["debugMode"] = $this->debugJSMode;
     $this->settingsMap["globalSettings"]["googleMapsApiCode"] = $this->googleMapCfg['APIcode'];
     $this->settingsMap["globalSettings"]["shortTNames"][$this->tName] = $this->shortTableName;
     //isMobile
     $this->settingsMap["globalSettings"]["isMobile"] = isMobile();
     // s508 must be in global settings
     $this->settingsMap['globalSettings']['s508'] = $this->is508;
     $this->settingsMap["globalSettings"]["locale"]["dateFormat"] = $locale_info["LOCALE_IDATE"];
     $this->settingsMap["globalSettings"]["locale"]["startWeekDay"] = $locale_info["LOCALE_IFIRSTDAYOFWEEK"];
     $this->settingsMap["globalSettings"]["locale"]["dateDelimiter"] = $locale_info["LOCALE_SDATE"];
     $this->settingsMap["tableSettings"] = array();
     $this->settingsMap['tableSettings']['hasEvents'] = array("default" => false, "jsName" => "hasEvents");
     $this->settingsMap["tableSettings"]["listIcons"] = array("default" => false, "jsName" => "listIcons");
     $this->settingsMap["tableSettings"]["strCaption"] = array("default" => "", "jsName" => "strCaption");
     $this->settingsMap["tableSettings"]["isUseAudio"] = array("default" => false, "jsName" => "isUseAudio");
     $this->settingsMap["tableSettings"]["isUseVideo"] = array("default" => false, "jsName" => "isUseVideo");
     $this->settingsMap['tableSettings']['isVerLayout'] = array("default" => false, "jsName" => "isVertLayout");
     $this->settingsMap["tableSettings"]["rowHighlite"] = array("default" => false, "jsName" => "isUseHighlite");
     $this->settingsMap["tableSettings"]["isUseToolTips"] = array("default" => false, "jsName" => "isUseToolTips");
     $this->settingsMap['tableSettings']['recsPerRowList'] = array("default" => 1, "jsName" => "recsPerRowList");
     $this->settingsMap["tableSettings"]["showAddInPopup"] = array("default" => false, "jsName" => "showAddInPopup");
     $this->settingsMap["tableSettings"]["showEditInPopup"] = array("default" => false, "jsName" => "showEditInPopup");
     $this->settingsMap["tableSettings"]["showViewInPopup"] = array("default" => false, "jsName" => "showViewInPopup");
     $this->settingsMap["tableSettings"]["isResizeColumns"] = array("default" => false, "jsName" => "isUseResize");
     $this->settingsMap["tableSettings"]["isUseAjaxSuggest"] = array("default" => true, "jsName" => "ajaxSuggest");
     $this->settingsMap["tableSettings"]["useDetailsPreview"] = array("default" => false, "jsName" => "isUseDP");
     $this->settingsMap['tableSettings']['isUsebuttonHandlers'] = array("default" => false, "jsName" => "isUseButtons");
     if ($this->pageType == PAGE_REGISTER || $this->pageType == PAGE_CHANGEPASS) {
         $layout = GetPageLayout('', $this->pageType);
     } else {
         $layout = GetPageLayout($this->shortTableName, $this->pageType);
     }
     if ($layout) {
         $rtl = $this->xt->getReadingOrder() == 'RTL' ? 'RTL' : '';
         $this->jsSettings['tableSettings'][$this->tName]['pageCSS'] = "styles/" . $layout->style . '/style' . $rtl . ".css";
         $this->jsSettings['tableSettings'][$this->tName]['pageLayout'] = "pagestyles/" . $layout->name . $rtl . ".css";
         $this->jsSettings['tableSettings'][$this->tName]['pageSkinStyle'] = $layout->style . " page-" . $layout->name;
     }
     $this->settingsMap["fieldSettings"]["UseTimestamp"] = array("default" => false, "jsName" => "isUseTimeStamp");
     $this->settingsMap["fieldSettings"]["strName"] = array("default" => "", "jsName" => "strName");
     $this->settingsMap["fieldSettings"]["ShowTime"] = array("default" => false, "jsName" => "showTime");
     $this->settingsMap["fieldSettings"]["EditFormat"] = array("default" => "", "jsName" => "editFormat");
     $this->settingsMap["fieldSettings"]["DateEditType"] = array("default" => EDIT_DATE_SIMPLE, "jsName" => "dateEditType");
     $this->settingsMap["fieldSettings"]["RTEType"] = array("default" => "", "jsName" => "RTEType");
     $this->settingsMap["fieldSettings"]["ViewFormat"] = array("default" => "", "jsName" => "viewFormat");
     $this->settingsMap["fieldSettings"]["validateAs"] = array("default" => null, "jsName" => "validation");
     $this->settingsMap["fieldSettings"]["strEditMask"] = array("default" => null, "jsName" => "mask");
     $this->settingsMap["fieldSettings"]["LastYearFactor"] = array("default" => 10, "jsName" => "lastYear");
     $this->settingsMap["fieldSettings"]["InitialYearFactor"] = array("default" => 100, "jsName" => "initialYear");
     $this->jsSettings["tableSettings"][$this->tName]["strCaption"] = $this->strCaption;
     $this->jsSettings["tableSettings"][$this->tName]["pageMode"] = $this->mode;
     if ($this->listAjax) {
         $this->jsSettings['tableSettings'][$this->tName]['pageMode'] = LIST_AJAX;
     }
     if ($this->lockingObj) {
         $this->jsSettings['tableSettings'][$this->tName]['locking'] = true;
     }
     //If current table has detail tables
     if (count($this->allDetailsTablesArr)) {
         if ($this->pageType == PAGE_LIST) {
             $this->jsSettings['tableSettings'][$this->tName]['detailTables'] = array();
         }
         $this->jsSettings['tableSettings'][$this->tName]['isShowDetails'] = $this->isShowDetailTables;
         for ($i = 0; $i < count($this->allDetailsTablesArr); $i++) {
             $this->settingsMap["globalSettings"]['shortTNames'][$this->allDetailsTablesArr[$i]['dDataSourceTable']] = $this->allDetailsTablesArr[$i]['dShortTable'];
             if ($this->pageType == PAGE_LIST) {
                 $this->jsSettings['tableSettings'][$this->tName]['detailTables'][$this->allDetailsTablesArr[$i]['dDataSourceTable']] = array('dispChildCount' => $this->allDetailsTablesArr[$i]['dispChildCount'], 'hideChild' => $this->allDetailsTablesArr[$i]['hideChild'], 'listShowType' => $this->allDetailsTablesArr[$i]['previewOnList'], 'addShowType' => $this->allDetailsTablesArr[$i]['previewOnAdd'], 'editShowType' => $this->allDetailsTablesArr[$i]['previewOnEdit'], 'viewShowType' => $this->allDetailsTablesArr[$i]['previewOnView']);
                 if ($this->allDetailsTablesArr[$i]['previewOnList'] == DP_POPUP) {
                     $this->jsSettings['tableSettings'][$this->tName]['isUsePopUp'] = true;
                 }
                 // field names of master keys of current table for passed details table name
                 $this->masterKeysByD[$i] = $this->pSet->getMasterKeysByDetailTable($this->allDetailsTablesArr[$i]['dDataSourceTable']);
             }
         }
         if (($this->pageType == PAGE_ADD || $this->pageType == PAGE_EDIT) && $this->isShowDetailTables) {
             $this->controlsMap["dControlsMap"] = array();
         }
     }
     $this->controlsMap["video"] = array();
     $this->controlsMap['toolTips'] = array();
     $this->addLookupSettings();
     $this->addMultiUploadSettings();
     if ($this->mode != LIST_DETAILS) {
         $this->controlsMap["controls"] = array();
         if (!$this->pageAddLikeInline && !$this->pageEditLikeInline) {
             $this->controlsMap["search"] = array();
             $this->controlsMap["search"]["searchBlocks"] = array();
             $this->controlsMap["search"]["panelSearchFields"] = $this->pSet->GetPanelSearchFields();
             $this->controlsMap["search"]["allSearchFields"] = $this->pSet->getAllSearchFields();
             $this->controlsMap["search"]["googleLikeFields"] = $this->pSet->getGoogleLikeFields();
             if ($this->pageType != PAGE_SEARCH) {
                 $this->controlsMap["search"]["submitPageType"] = $this->pageType;
             } else {
                 if (postvalue("rname")) {
                     $this->controlsMap["search"]["submitPageType"] = "dreport";
                     $this->controlsMap["search"]["baseParams"]["rname"] = postvalue("rname");
                     if ($_SESSION["crossLink"]) {
                         if (substr($_SESSION["crossLink"], 0, 1) == "&") {
                             $_SESSION["crossLink"] = substr($_SESSION["crossLink"], 1);
                         }
                         $alink = explode("&", $_SESSION["crossLink"]);
                         foreach ($alink as $param) {
                             $arrtmp = explode("=", $param);
                             $this->controlsMap["search"]["baseParams"][$arrtmp[0]] = $arrtmp[1];
                         }
                     }
                 } elseif (postvalue("cname")) {
                     $this->controlsMap["search"]["submitPageType"] = "dchart";
                     $this->controlsMap["search"]["baseParams"]["cname"] = postvalue("cname");
                 } else {
                     $this->controlsMap["search"]["submitPageType"] = $this->isTableType;
                 }
             }
         }
     }
     $this->timepicker = $this->timepicker || $this->pSet->isUseTimeForSearch();
     $this->isUseToolTips = $this->isUseToolTips || $this->pSet->isUseToolTips();
     $this->googleMapCfg["APIcode"] = "";
     if ($this->xt) {
         $this->xt->assign("pagetitle", $this->getPageTitle());
     }
 }
    $menuNode["title"] = GetTableCaption("dbo_User_Roles");
    $menuNodes[] = $menuNode;
    $menuNode = array();
    $menuNode["id"] = "16";
    $menuNode["name"] = "";
    $menuNode["href"] = "mypage.htm";
    $menuNode["type"] = "Leaf";
    $menuNode["table"] = "dbo.System Users";
    $menuNode["style"] = "";
    $menuNode["params"] = "";
    $menuNode["parent"] = "0";
    $menuNode["nameType"] = "Text";
    $menuNode["linkType"] = "Internal";
    $menuNode["pageType"] = "List";
    $menuNode["openType"] = "None";
    $menuNode["title"] = GetTableCaption("dbo_System_Users");
    $menuNodes[] = $menuNode;
    if ($pageType == PAGE_MENU && IsAdmin()) {
    }
} else {
    //Admin Area menu items
    $xt->assign("adminAreaTypeMenu", true);
}
// need to predefine vars
$nullParent = NULL;
$rootInfoArr = array("id" => 0, "href" => "");
// create treeMenu instance
$menuRoot = new MenuItem($rootInfoArr, $menuNodes, $nullParent);
// call xtempl assign, set session params
$menuRoot->setMenuSession();
$menuRoot->assignMenuAttrsToTempl($xt);
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 0;
$detailsTablesData["GroupMaster"][$dIndex] = $detailsParam;
$detailsTablesData["GroupMaster"][$dIndex]["masterKeys"] = array();
$detailsTablesData["GroupMaster"][$dIndex]["masterKeys"][] = "Groupid";
$detailsTablesData["GroupMaster"][$dIndex]["detailKeys"] = array();
$detailsTablesData["GroupMaster"][$dIndex]["detailKeys"][] = "GroupID";
//	CompanyMaster
$dIndex = 1;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "CompanyMaster";
$detailsParam["dOriginalTable"] = "CompanyMaster";
$detailsParam["dType"] = PAGE_LIST;
$detailsParam["dShortTable"] = "CompanyMaster";
$detailsParam["dCaptionTable"] = GetTableCaption("CompanyMaster");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = false;
$detailsParam["previewOnList"] = 1;
$detailsParam["previewOnAdd"] = 0;
$detailsParam["previewOnEdit"] = 0;
$detailsParam["previewOnView"] = 0;
$detailsTablesData["GroupMaster"][$dIndex] = $detailsParam;
$detailsTablesData["GroupMaster"][$dIndex]["masterKeys"] = array();
$detailsTablesData["GroupMaster"][$dIndex]["masterKeys"][] = "Groupid";
$detailsTablesData["GroupMaster"][$dIndex]["detailKeys"] = array();
$detailsTablesData["GroupMaster"][$dIndex]["detailKeys"][] = "GroupID";
// tables which are master tables for current table (detail)
$masterTablesData["GroupMaster"] = array();
Exemplo n.º 13
0
 /**
  * Get the default page's title template
  * @param String page
  * @param String table				A good table name
  * @param ProjectSettings pSet	 
  * @return STring
  */
 protected function getDefaultPageTitle($page, $table, $pSet)
 {
     if ($page == "add") {
         return GetTableCaption($table) . ", " . "Añadir nuevo registro";
     }
     if ($page == "edit") {
         return GetTableCaption($table) . ", " . "Editar registro" . " [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "view") {
         return GetTableCaption($table) . ", " . "Ver registro" . " [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "export") {
         return "Exportar";
     }
     if ($page == "import") {
         return GetTableCaption($table) . ", " . "Importar";
     }
     if ($page == "search") {
         return GetTableCaption($table) . " - " . "Búsqueda avanzada";
     }
     if ($page == "print") {
         return GetTableCaption($table);
     }
     if ($page == "list") {
         return GetTableCaption($table);
     }
     if ($page == "masterlist") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "masterchart") {
         return GetTableCaption($table);
     }
     if ($page == "masterreport") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "masterprint") {
         return GetTableCaption($table) . ": [" . $this->getKeysTitleTemplate($table, $pSet) . "]";
     }
     if ($page == "login") {
         return "Conectar";
     }
     if ($page == "register") {
         return "Registrar";
     }
     if ($page == "changepwd") {
         return "Cambiar contraseña";
     }
     if ($page == "remind") {
         return "Recordador de contraseña";
     }
     if ($page == "chart") {
         return GetTableCaption($table);
     }
     if ($page == "report") {
         return GetTableCaption($table);
     }
     if ($page == "dashboard") {
         return GetTableCaption($table);
     }
     if ($page == "menu") {
         return "Menu";
     }
 }
Exemplo n.º 14
0
 /**
  * Fills info in array about grid.
  * For new add row
  * @param array $rowInfoArr array with total info, that assignes grid
  */
 function fillGridShowInfo(&$rowInfoArr)
 {
     $rowInfoArr["data"] = array();
     $editlink = "";
     $copylink = "";
     //	add inline add row
     //print('$this->mainTable = '.$this->mainTable.'<br>');
     $mainPSet = $this->pSet->getTable($this->mainTable);
     if ($mainPSet->isAllowToAdd($this->mainField) && $this->permis[$this->tName]['add']) {
         $row = array();
         $row["rowclass"] = "gridRowAdd runner-hiddenelem";
         if ($this->isVerLayout) {
             $row["rowattrs"] .= "vertical=\"1\"";
             $row["rowclass"] = 'class="' . $row["rowclass"] . '"';
             $row["rsclass"] = "gridRowSepAdd runner-hiddenelem";
         }
         $record = array();
         $record["edit_link"] = true;
         $record["inlineedit_link"] = true;
         $record["view_link"] = true;
         $record["copy_link"] = true;
         $record["checkbox"] = true;
         $record["checkbox"] = true;
         $record["editlink_attrs"] = "id=\"editLink_add" . $this->id . "\"";
         //for list icons instead of list links
         $this->countWidthListIcons('add');
         $record["copylink_attrs"] = "id=\"copyLink_add" . $this->id . "\" name=\"copyLink_add" . $this->id . "\"";
         $record["viewlink_attrs"] = "id=\"viewLink_add" . $this->id . "\" name=\"viewLink_add" . $this->id . "\"";
         $record["checkbox_attrs"] = "id=\"check_add" . $this->id . "\" name=\"selection[]\"";
         //	add container for inline add controls
         $addedInlineAddContainer = false;
         if ($this->permis[$this->tName]['edit'] && $this->isUseInlineEdit) {
             $record["inlineeditlink_attrs"] = "id=\"inlineEdit_add" . $this->id . "\" ";
             $addedInlineAddContainer = true;
         }
         for ($i = 0; $i < count($this->allDetailsTablesArr); $i++) {
             //detail tables
             $dDataSourceTable = $this->allDetailsTablesArr[$i]['dDataSourceTable'];
             $dShortTable = $this->allDetailsTablesArr[$i]['dShortTable'];
             $record[$dShortTable . "_dtable_link"] = $this->permis[$dDataSourceTable]['add'] || $this->permis[$dDataSourceTable]['search'];
             $record[$dShortTable . "_dtablelink_attrs"] = " href=\"" . $dShortTable . "_list.php?\" id=\"master_" . $dShortTable . "_add" . $this->id . "\" ";
             if ($this->allDetailsTablesArr[$i]['previewOnList'] == DP_INLINE) {
                 $record[$dShortTable . "_dtablelink_attrs"] = "id = \"" . $dShortTable . "_preview" . $this->id . "\"\r\n\t\t\t\t\t\tcaption = \"" . GetTableCaption(GoodFieldName($dDataSourceTable)) . "\" \r\n\t\t\t\t\t\thref = \"" . $dShortTable . "_list.php?\"\r\n\t\t\t\t\t\tstyle = \"display:none;\"";
             }
         }
         $this->addSpansForGridCells('add', $record);
         for ($i = 0; $i < count($this->listFields); $i++) {
             if (!$addedInlineAddContainer) {
                 if ($i == 0 && !($this->permis[$this->tName]['edit'] && $this->isUseInlineEdit)) {
                     $record[GoodFieldName($this->listFields[$i]['fName']) . "_value"] .= "<span id=\"inlineEdit_add" . $this->id . "\"></span>";
                 }
             }
             $record[GoodFieldName($this->listFields[$i]['fName']) . "_class"] .= $this->fieldClass($this->listFields[$i]['fName']);
         }
         if ($this->colsOnPage > 1) {
             $record["endrecord_block"] = true;
         }
         $record["grid_recordheader"] = true;
         $record["grid_vrecord"] = true;
         $row["grid_record"] = array("data" => array());
         $row["grid_record"]["data"][] = $record;
         for ($i = 1; $i < $this->colsOnPage; $i++) {
             $rec = array();
             if ($i < $this->colsOnPage - 1) {
                 $rec["endrecord_block"] = true;
             }
             $row["grid_record"]["data"][] = $rec;
         }
         $row["grid_rowspace"] = true;
         $row["grid_recordspace"] = array("data" => array());
         for ($i = 0; $i < $this->colsOnPage * 2 - 1; $i++) {
             $row["grid_recordspace"]["data"][] = true;
         }
         $rowInfoArr["data"][] = $row;
     }
 }
Exemplo n.º 15
0
$tdatagroup["Groupcol"] = $fdata;
$tables_data["group"] =& $tdatagroup;
$field_labels["group"] =& $fieldLabelsgroup;
$fieldToolTips["group"] =& $fieldToolTipsgroup;
$page_titles["group"] =& $pageTitlesgroup;
// -----------------start  prepare master-details data arrays ------------------------------//
// tables which are detail tables for current table (master)
$detailsTablesData["group"] = array();
//	company
$dIndex = 0;
$detailsParam = array();
$detailsParam["dDataSourceTable"] = "company";
$detailsParam["dOriginalTable"] = "company";
$detailsParam["dType"] = PAGE_LIST;
$detailsParam["dShortTable"] = "company";
$detailsParam["dCaptionTable"] = GetTableCaption("company");
$detailsParam["masterKeys"] = array();
$detailsParam["detailKeys"] = array();
$detailsParam["dispChildCount"] = "1";
$detailsParam["hideChild"] = true;
$detailsParam["previewOnList"] = 1;
$detailsParam["previewOnAdd"] = 1;
$detailsParam["previewOnEdit"] = 1;
$detailsParam["previewOnView"] = 1;
$detailsTablesData["group"][$dIndex] = $detailsParam;
$detailsTablesData["group"][$dIndex]["masterKeys"] = array();
$detailsTablesData["group"][$dIndex]["masterKeys"][] = "GRP_ID";
$detailsTablesData["group"][$dIndex]["detailKeys"] = array();
$detailsTablesData["group"][$dIndex]["detailKeys"][] = "grp_id";
// tables which are master tables for current table (detail)
$masterTablesData["group"] = array();