public function fetchData()
{
if ($this->activeRecord != null) {
return $this->activeRecord;
}
$dataObj = $this->getDataObj();
if ($dataObj == null) {
return;
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
}
$dataObj->setSearchRule($searchRule);
QueryStringParam::setBindValues($this->searchRuleBindValues);
$resultRecords = $dataObj->fetch();
foreach ($resultRecords as $record) {
$settingRecord["_" . $record['name']] = $record["value"];
}
$this->recordId = $resultRecords[0]['Id'];
$this->setActiveRecord($settingRecord);
QueryStringParam::ReSet();
return $settingRecord;
}
public function fetchDataSet()
{
$dataObj = $this->getDataObj();
if (!$dataObj) {
return null;
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
} else {
$searchRule = $this->searchRule;
}
$dataObj->setSearchRule($searchRule);
if ($this->startItem > 1) {
$dataObj->setLimit($this->range, $this->startItem);
} else {
$dataObj->setLimit($this->range, ($this->currentPage - 1) * $this->range);
}
//$resultRecords = $dataObj->fetch();
$resultRecordTree = $dataObj->fetchTree($this->rootSearchRule, $this->treeDepth);
if (is_array($resultRecordTree)) {
foreach ($resultRecordTree as $resultRecordTreeNode) {
$this->tree2array($resultRecordTreeNode, $resultRecords);
}
}
$this->totalRecords = $dataObj->count();
if ($this->range && $this->range > 0) {
$this->totalPages = ceil($this->totalRecords / $this->range);
}
$selectedIndex = 0;
$this->getDataObj()->setActiveRecord($resultRecords[$selectedIndex]);
QueryStringParam::ReSet();
return $resultRecords;
}
public function fetchData()
{
if ($this->activeRecord != null) {
return $this->activeRecord;
}
$dataObj = $this->getDataObj();
if ($dataObj == null) {
return;
}
if (!$this->fixSearchRule && !$this->searchRule) {
return array();
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
}
$dataObj->setSearchRule($searchRule);
QueryStringParam::setBindValues($this->searchRuleBindValues);
$resultRecords = $dataObj->fetch();
foreach ($resultRecords as $record) {
$prefRecord["_" . $record['name']] = $record["value"];
}
if ($prefRecord["_siteurl"] == "") {
if ($_SERVER["HTTPS"]) {
$prefRecord["_siteurl"] = "https://" . $_SERVER["SERVER_NAME"] . OPENBIZ_APP_URL;
} else {
$prefRecord["_siteurl"] = "http://" . $_SERVER["SERVER_NAME"] . OPENBIZ_APP_URL;
}
}
$this->recordId = $resultRecords[0]['Id'];
$this->setActiveRecord($prefRecord);
QueryStringParam::ReSet();
return $prefRecord;
}
public function fetchData()
{
if ($this->activeRecord != null) {
return $this->activeRecord;
}
$dataObj = $this->getDataObj();
if ($dataObj == null) {
return;
}
$this->fixSearchRule = "[user_id]='0'";
if (!$this->fixSearchRule && !$this->searchRule) {
return array();
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
}
$dataObj->setSearchRule($searchRule);
QueryStringParam::setBindValues($this->searchRuleBindValues);
$resultRecords = $dataObj->fetch();
foreach ($resultRecords as $record) {
$prefRecord["_" . $record['name']] = $record["value"];
}
$prefRecord["_siteurl"] = SITE_URL;
$prefRecord["_system_name"] = OPENBIZ_DEFAULT_SYSTEM_NAME;
$this->recordId = $resultRecords[0]['Id'];
$this->setActiveRecord($prefRecord);
QueryStringParam::ReSet();
return $prefRecord;
}
public function fetchDataGroup()
{
//get group list first
$dataObj = $this->getDataObj();
if (!$dataObj) {
return null;
}
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
if (strpos($this->groupBy, ":")) {
preg_match("/\\[(.*?):(.*?)\\]/si", $this->groupBy, $match);
$GroupFieldName = $match[1];
$GroupField = $match[2];
} else {
$GroupField = str_replace("[", "", $this->groupBy);
$GroupField = str_replace("]", "", $GroupField);
}
$GroupSQLRule = "GROUP BY [{$GroupField}]";
$dataObj->setOtherSQLRule($GroupSQLRule);
//within each group, search records like before
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
} else {
$searchRule = $this->searchRule;
}
$dataObj->setSearchRule($searchRule);
$resultRecords = $dataObj->fetch();
$this->totalRecords = $dataObj->count();
if ($this->range && $this->range > 0) {
$this->totalPages = ceil($this->totalRecords / $this->range);
}
$this->totalPagesBak = $this->totalPages;
QueryStringParam::ReSet();
//looping
$i = 0;
$results = array();
foreach ($resultRecords as $record) {
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
$group_val = $record[$GroupField];
if ($this->fixSearchRule) {
if ($this->searchRule) {
$searchRule = $this->searchRule . " AND " . $this->fixSearchRule;
} else {
$searchRule = $this->fixSearchRule;
}
} else {
$searchRule = $this->searchRule;
}
if ($group_val) {
if ($searchRule != "") {
$searchRule = $searchRule . " AND [{$GroupField}]='{$group_val}'";
} else {
$searchRule = " [{$GroupField}]='{$group_val}'";
}
} else {
if ($searchRule != "") {
$searchRule = $searchRule . " AND [{$GroupField}] is NULL";
} else {
$searchRule = " [{$GroupField}] is NULL";
}
}
$dataObj->setOtherSQLRule("");
$dataObj->setLimit(0, 0);
$dataObj->setSearchRule($searchRule);
$resultRecords_grouped = $dataObj->fetch();
//renderTable
$resultRecords_grouped_table = $this->dataPanel->renderTable($resultRecords_grouped);
if ($record[$GroupField]) {
if ($GroupFieldName) {
$results[$record[$GroupFieldName]] = $resultRecords_grouped_table;
} else {
$results[$record[$GroupField]] = $resultRecords_grouped_table;
}
} else {
$results["Empty"] = $resultRecords_grouped_table;
}
$i++;
QueryStringParam::ReSet();
}
//set active records
$selectedIndex = 0;
$this->getDataObj()->setActiveRecord($resultRecords[$selectedIndex]);
return $results;
}
