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()
{
$roleId = $this->getRoleId();
if ($this->searchRuleBindValues) {
QueryStringParam::setBindValues($this->searchRuleBindValues);
}
// fetch acl_action records
$aclActionDO = Openbiz::getObject("system.do.AclActionDO", 1);
//var_dump($this->searchRuleBindValues);
$aclActionDO->setQueryParameters($this->queryParams);
$aclActionDO->setLimit($this->range, ($this->currentPage - 1) * $this->range);
$rs = $aclActionDO->fetch()->toArray();
//echo '<pre>';
//DebugLine::show(__METHOD__.__LINE__);
//DebugLine::show(var_dump($rs));
//return;
$this->totalRecords = $aclActionDO->count();
if ($this->range && $this->range > 0) {
$this->totalPages = ceil($this->totalRecords / $this->range);
}
// fetch role and access
//$this->getDataObj()->searchRule .= "[role_id]=$roleId ";
$this->getDataObj()->setSearchRule("[role_id]={$roleId}");
if ($this->searchRule) {
$this->getDataObj()->setSearchRule($this->searchRule);
}
//DebugLine::show(' -- ' . $this->searchRule);
//return;
$rs1 = $this->getDataObj()->fetch();
$this->getDataObj()->clearSearchRule();
foreach ($rs1 as $rec) {
$actionRoleAccess[$rec['action_id']] = $rec;
}
//print_r($actionRoleAccess);
// merge 2 rs
for ($i = 0; $i < count($rs); $i++) {
$actionId = $rs[$i]['Id'];
$rs[$i]['access_level'] = "";
if (isset($actionRoleAccess[$actionId])) {
$rs[$i]['access_level'] = $actionRoleAccess[$actionId]['access_level'];
}
}
return $rs;
}
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;
}
protected function fetchDatasetByColumn()
{
$this->chartCategory = array();
$this->chartDataAttrset = array();
$this->chartDataset = array();
$this->chartDataDescset = array();
$this->chartDataIdset = array();
$this->chartColorset = array();
// query recordset first
$dataObj = $this->getDataObj();
QueryStringParam::setBindValues($this->searchRuleBindValues);
if ($this->isRefreshData) {
$dataObj->resetRules();
} else {
$dataObj->clearSearchRule();
}
//echo "search rule is $this->searchRule"; exit;
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);
}
QueryStringParam::setBindValues($this->searchRuleBindValues);
$resultRecords = $dataObj->fetch();
$this->totalRecords = $dataObj->count();
if ($this->range && $this->range > 0) {
$this->totalPages = ceil($this->totalRecords / $this->range);
}
//$resultRecords = $dataObj->directFetch($searchRule);
$counter = 0;
while (true) {
$arr = $resultRecords[$counter];
if (!$arr) {
break;
}
foreach ($this->dataPanel as $element) {
$element->value = $arr[$element->fieldName];
$value = $element->getValue();
if ($element->fieldName && isset($value)) {
switch ($element->className) {
case "chart.lib.ChartColor":
$this->chartColorset[] = $value;
break;
case "chart.lib.ChartDataId":
$this->chartIdset[] = $value;
break;
case "chart.lib.ChartDescription":
$this->chartDescset[] = $value;
break;
case "chart.lib.ChartColor":
$this->chartColorset[] = $value;
break;
case "chart.lib.ChartCategory":
$this->chartCategory[] = $value;
break;
case "chart.lib.ChartData":
$this->chartDataset[$element->key][] = $value;
$this->chartDataAttrset[$element->key] = $element->attrs;
break;
}
}
}
$counter++;
}
}
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;
}
