// Grp_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Grp_id", $data, $keylink); $row["Grp_id_value"] = $value; $format = $pSet->getViewFormat("Grp_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($pSet->getFieldType("Grp_id"))) { $class = ' rnr-field-number'; } $row["Grp_id_class"] = $class; // StockCode - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("StockCode", $data, $keylink); $row["StockCode_value"] = $value; $format = $pSet->getViewFormat("StockCode"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
continue; } if ($masterTablesInfoArr[$i]['dispInfo']) { $detailKeys = $masterTablesInfoArr[$i]['detailKeys']; for ($j = 0; $j < count($detailKeys); $j++) { $masterWhere .= " and " . $controls->getControl($detailKeys[$j])->getSuggestWhere('Equals', @$_SESSION[$strTableName . "_masterkey" . ($j + 1)]); } } break; } } $result = array(); // traversing searchable fields foreach ($allSearchFields as $f) { // filter fields by type $fType = $pSet->getFieldType($f); if (!IsCharType($fType) && !IsNumberType($fType) && !IsGuid($fType) || in_array($f, $detailKeys)) { continue; } if ($_connection->dbType == nDATABASE_Oracle && IsTextType($fType)) { continue; } if ($searchField != '' && $searchField != GoodFieldName($f) || !$pSet->checkFieldPermissions($f)) { continue; } $fieldControl = $controls->getControl($f); $isAggregateField = $pSet->isAggregateField($f); $where = $fieldControl->getSuggestWhere($searchOpt, $searchFor, $isAggregateField); $having = $fieldControl->getSuggestHaving($searchOpt, $searchFor, $isAggregateField); if (!strlen($where) && !strlen($having)) { continue;
function LogDelete($str_table, $values, $keys) { global $globalEvents; $retval = true; $table = $str_table; $pSet = new ProjectSettings($str_table); $arr = array(); if ($globalEvents->exists("OnAuditLog")) { $retval = $globalEvents->OnAuditLog($this->strDelete, $this->params, $table, $keys, $values, $arr); } if ($retval) { if (count($keys) > 0) { $key = ""; foreach ($keys as $idx => $val) { if ($key != "") { $key .= ","; } $key .= $val; } } $fp = $this->CreateLogFile(); $str = format_datetime_custom(db2time(now()), "MMM dd,yyyy") . chr(9) . format_datetime_custom(db2time(now()), "HH:mm:ss") . chr(9) . $this->params[0] . chr(9) . $this->params[1] . chr(9) . $table . chr(9) . $this->strDelete . chr(9) . $key; $str_add = ""; if ($this->logValueEnable($str_table)) { foreach ($values as $idx => $val) { $v = ""; if (IsBinaryType($pSet->getFieldType($idx))) { $v = "<binary value>"; } else { $v = str_replace(array("\r\n", "\n", "\t"), " ", $val); if (strlen($v) > $this->maxFieldLength) { $v = substr($v, 0, $this->maxFieldLength); } } if ($fp) { $str_add .= $str . chr(9) . $idx . chr(9) . $v . "\r\n"; } } } else { $str_add = $str . "\r\n"; } if ($fp) { fputs($fp, $str_add); fclose($fp); } } return $retval; }
function WRCustomGetFieldType($table, $field) { global $conn; if (is_wr_project()) { $pSet = new ProjectSettings($_SESSION['webreports']['tables'][0]); $type = $pSet->getFieldType($field); if ($type) { return $type; } } if (is_wr_db()) { global $wr_is_standalone; if (!$wr_is_standalone) { global $dal; if ($dal->Table($table)) { return $dal->GetFieldType($table, $field); } } return dbinfoFieldsType($table, $field); } if (is_wr_custom()) { $res = ""; $sql = $_SESSION["object_sql"]; if ($sql) { //The default connection is temporary used #9875 $connection = getDefaultConnection(); $arr = $connection->getFieldsList($sql); foreach ($arr as $val) { if ($val["fieldname"] == $field) { $res = $val["type"]; } } } return $res; } }
function GetFieldType($field, $table = "") { global $pageObject; if ($table != "" || !isset($pageObject)) { if ($table == "") { global $strTableName; $table = $strTableName; } $newSet = new ProjectSettings($table); return $newSet->getFieldType($field); } else { return $pageObject->pSet->getFieldType($field); } }
// Groupid - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("Groupid", $data, $keylink); $row["Groupid_value"] = $value; $format = $pSet->getViewFormat("Groupid"); $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($pSet->getFieldType("Groupid"))) { $class = ' rnr-field-number'; } $row["Groupid_class"] = $class; // GroupName - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("GroupName", $data, $keylink); $row["GroupName_value"] = $value; $format = $pSet->getViewFormat("GroupName"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
{ $flag=true; $i=0; $fields_type=array(); if(is_wr_custom()) $fields_type=WRGetAllCustomFieldType(); while(($data=db_fetch_array($rs)) && $i<$num_rows) { $i++; if ($flag) { foreach( array_keys($data) as $key ) { if(is_wr_project()) { if(IsBinaryType($gSettings->getFieldType($key))) continue; } elseif(is_wr_custom()) { if(IsBinaryType($fields_type[$key])) continue; } if($gSettings) $gKey = $gSettings->label($key); else $gKey = $key; $res_head .= "<th>" . runner_htmlspecialchars($gKey) . "</th>"; } }
function GetType() { $pSet = new ProjectSettings($this->m_strTable); return $pSet->getFieldType($this->m_strName); }
// grp_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("grp_id", $data, $keylink); $row["grp_id_value"] = $value; $format = $pSet->getViewFormat("grp_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($pSet->getFieldType("grp_id"))) { $class = ' rnr-field-number'; } $row["grp_id_class"] = $class; // coy_id - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("coy_id", $data, $keylink); $row["coy_id_value"] = $value; $format = $pSet->getViewFormat("coy_id"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
// ID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("ID", $data, $keylink); $row["ID_value"] = $value; $format = $pSet->getViewFormat("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($pSet->getFieldType("ID"))) { $class = ' rnr-field-number'; } $row["ID_class"] = $class; // GroupID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("GroupID", $data, $keylink); $row["GroupID_value"] = $value; $format = $pSet->getViewFormat("GroupID"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
/** * Add span val for lookup fields, and average|total|count totals */ function addSpanVal($fName, &$data) { global $strTableName; $pSet = new ProjectSettings($strTableName, PAGE_LIST); $type = $pSet->getFieldType($fName); if ((@$this->arrFieldSpanVal[$fName] == 2 || @$this->arrFieldSpanVal[$fName] == 1) && !IsBinaryType($type)) { return "val=\"" . runner_htmlspecialchars($data[$fName]) . "\" "; } }
// GroupID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("GroupID", $data, $keylink); $row["GroupID_value"] = $value; $format = $pSet->getViewFormat("GroupID"); $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($pSet->getFieldType("GroupID"))) { $class = ' rnr-field-number'; } $row["GroupID_class"] = $class; // CompanyID - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("CompanyID", $data, $keylink); $row["CompanyID_value"] = $value; $format = $pSet->getViewFormat("CompanyID"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
/** * Get filter's WHERE clause condition basing on the filter's type * * @param String filterType A string representing the filter's type * @param String fName * @param String fValue * @return String */ function getFilterWhereByType($filterType, $fName, $fValue, $sValue, $parentValues) { $pSet = new ProjectSettings($this->tName, PAGE_SEARCH); $fullFieldName = $pSet->getFullFieldNameCiph($fName, $this->cipherer); $fieldType = $pSet->getFieldType($fName); $dateField = IsDateFieldType($fieldType); $timeField = IsTimeType($fieldType); if($dateField || $timeField) { include_once getabspath("classes/controls/FilterControl.php"); include_once getabspath("classes/controls/FilterIntervalSlider.php"); include_once getabspath("classes/controls/FilterIntervalDateSlider.php"); } switch($filterType) { case 'interval': $intervalData = $pSet->getFilterIntervalDatabyIndex($fName, $fValue); if( !count($intervalData) ) return ""; include_once getabspath("classes/controls/FilterControl.php"); include_once getabspath("classes/controls/FilterIntervalList.php"); return FilterIntervalList::getIntervalFilterWhere($fName, $intervalData, $pSet, $this->cipherer, $this->tName); case 'equals': if( !count($parentValues) ) return $fullFieldName."=".$this->cipherer->MakeDBValue($fName, $fValue, "", "", true); $wheres = array(); $wheres[] = $fullFieldName."=".$this->cipherer->MakeDBValue($fName, $fValue, "", "", true); $parentFiltersNames = $pSet->getParentFiltersNames($fName); foreach( $parentFiltersNames as $key => $parentName ) { $wheres[] = $pSet->getFullFieldNameCiph($parentName, $this->cipherer)."=".$this->cipherer->MakeDBValue($parentName, $parentValues[$key], "", "", true); } return "(".implode(" AND ", $wheres).")"; case 'checked': if($fValue != "on" && $fValue != "off") return ""; $bNeedQuotes = NeedQuotes($fieldType); include_once getabspath("classes/controls/Control.php"); include_once getabspath("classes/controls/CheckboxField.php"); return CheckboxField::constructFieldWhere($fullFieldName, $bNeedQuotes, $fValue == "on"); case 'slider': if($dateField) return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); if($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $this->cipherer->MakeDBValue($fName, $fValue, "", "", true)."<=".$fullFieldName." AND ".$fullFieldName."<=".$this->cipherer->MakeDBValue($fName, $sValue, "", "", true); case 'moreequal': if($dateField) return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); if($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $this->cipherer->MakeDBValue($fName, $fValue, "", "", true)."<=".$fullFieldName; case 'lessequal': if($dateField) return FilterIntervalDateSlider::getDateSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); if($timeField) { include_once getabspath("classes/controls/FilterIntervalTimeSlider.php"); return FilterIntervalTimeSlider::getTimeSliderWhere($fName, $pSet, $this->cipherer, $this->tName, $fValue, $sValue, $filterType, $fullFieldName); } return $fullFieldName."<=".$this->cipherer->MakeDBValue($fName, $fValue, "", "", true); default: return ""; } }
// BranchCloudFolder - $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("BranchCloudFolder", $data, $keylink); $row["BranchCloudFolder_value"] = $value; $format = $pSet->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($pSet->getFieldType("BranchCloudFolder"))) { $class = ' rnr-field-number'; } $row["BranchCloudFolder_class"] = $class; // BranchLastSyncDate - Short Date $viewContainer->recId = $recordsCounter; $value = $viewContainer->showDBValue("BranchLastSyncDate", $data, $keylink); $row["BranchLastSyncDate_value"] = $value; $format = $pSet->getViewFormat("BranchLastSyncDate"); $class = "rnr-field-text"; if ($format == FORMAT_FILE) { $class = ' rnr-field-file'; } if ($format == FORMAT_AUDIO) { $class = ' rnr-field-audio'; }
function WRCustomGetFieldType($table,$field) { global $conn; if(is_wr_project()) { $pSet = new ProjectSettings($_SESSION['webreports']['tables'][0]); $type = $pSet->getFieldType($field); if($type) return $type; } if(is_wr_db()) { global $wr_is_standalone; if(!$wr_is_standalone) { global $dal; if($dal->Table($table)) return $dal->GetFieldType($table,$field); } return dbinfoFieldsType($table,$field); } if(is_wr_custom()) { $res=""; $sql=$_SESSION["object_sql"]; if($sql) { $arr=db_getfieldslist($sql); foreach($arr as $val) if($val["fieldname"]==$field) $res=$val["type"]; } return $res; } }