public function searchSipTrace($id = null)
{
include_once OPENBIZ_BIN . "/easy/SearchHelper.php";
$searchRule = "";
foreach ($this->m_DataPanel as $element) {
if (!$element->m_FieldName) {
continue;
}
$value = BizSystem::clientProxy()->getFormInputs($element->m_Name);
if ($element->m_FuzzySearch == "Y") {
$value = "*{$value}*";
}
if ($value) {
$searchStr = inputValToRule($element->m_FieldName, $value, $this);
if ($searchRule == "") {
$searchRule .= $searchStr;
} else {
$searchRule .= " AND " . $searchStr;
}
}
}
$searchRuleBindValues = QueryStringParam::getBindValues();
$listFormObj = BizSystem::getObject($this->localListForm);
$listFormObj->setSearchRule($searchRule, $searchRuleBindValues);
$listFormObj->rerender();
}
public function SwitchSearchFieldForm($switchForm, $fieldName, $fieldValue)
{
include_once OPENBIZ_BIN . "/easy/SearchHelper.php";
$this->switchForm($switchForm);
$listFormObj = BizSystem::getObject($switchForm);
QueryStringParam::reset();
$searchRule = inputValToRule($fieldName, $fieldValue, $this);
$searchRuleBindValues = QueryStringParam::getBindValues();
$listFormObj->setSearchRule($searchRule, $searchRuleBindValues);
$listFormObj->rerender();
}
/**
* Insert record using given input record array
*
* @param array $recArr - associated array whose keys are field names of this BizDataObj
* @return boolean - if return false, the caller can call getErrorMessage to get the error.
**/
public function insertRecord($recArr)
{
if ($this->_isNeedGenerateId($recArr)) {
$recArr["Id"] = $this->generateId();
}
// for certain cases, id is generated before insert
$this->m_BizRecord->setInputRecord($recArr);
if (!$this->validateInput()) {
return false;
}
$db = $this->getDBConnection();
try {
$sql = $this->getSQLHelper()->buildInsertSQL($this, $joinValues);
if ($sql) {
$bindValues = QueryStringParam::getBindValues();
$bindValueString = QueryStringParam::getBindValueString();
BizSystem::log(LOG_DEBUG, "DATAOBJ", "Insert Sql = {$sql}" . "; BIND: {$bindValueString}");
QueryStringParam::reset();
$db->query($sql, $bindValues);
}
//$mainId = $db->lastInsertId();
if ($this->_isNeedGenerateId($recArr)) {
$mainId = $this->generateId(false);
$recArr["Id"] = $mainId;
}
BizSystem::log(LOG_DEBUG, "DATAOBJ", "New record Id is " . $recArr["Id"]);
} catch (Exception $e) {
BizSystem::log(LOG_ERR, "DATAOBJ", "Query Error : " . $e->getMessage());
$this->m_ErrorMessage = $this->getMessage("DATA_ERROR_QUERY") . ": " . $sql . ". " . $e->getMessage();
throw new BDOException($this->m_ErrorMessage);
return null;
}
$this->m_BizRecord->setInputRecord($recArr);
if ($this->_postUpdateLobFields($recArr) === false) {
$this->m_ErrorMessage = $db->ErrorMsg();
return false;
}
$this->cleanCache();
$this->m_RecordId = $recArr["Id"];
$this->m_CurrentRecord = null;
$this->_postInsertRecord($recArr);
return true;
}
/**
* Get the number of records according the Select SQL
*
* @param object $db database connection
* @param string $sql SQL string
* @return int number of records
*/
private function _getNumberRecords($db, $sql)
{
if (preg_match("/^\\s*SELECT\\s+DISTINCT/is", $sql) || preg_match('/\\s+GROUP\\s+BY\\s+/is', $sql)) {
// ok, has SELECT DISTINCT or GROUP BY so see if we can use a table alias
$rewritesql = preg_replace('/(\\sORDER\\s+BY\\s.*)/is', '', $sql);
$rewritesql = "SELECT COUNT(*) FROM ({$rewritesql}) _TABLE_ALIAS_";
} else {
// now replace SELECT ... FROM with SELECT COUNT(*) FROM
$rewritesql = preg_replace('/^\\s*SELECT\\s.*\\s+FROM\\s/Uis', 'SELECT COUNT(*) FROM ', $sql);
// Because count(*) and 'order by' fails with mssql, access and postgresql.
// Also a good speedup optimization - skips sorting!
$rewritesql = preg_replace('/(\\sORDER\\s+BY\\s.*)/is', '', $rewritesql);
}
try {
$bindValues = QueryStringParam::getBindValues();
$bindValueString = QueryStringParam::getBindValueString();
if ($this->m_CacheLifeTime > 0) {
$cache_id = md5($this->m_Name . $rewritesql . serialize($bindValues));
//try to process cache service.
$cacheSvc = BizSystem::getService(CACHE_SERVICE);
$cacheSvc->init($this->m_Name, $this->m_CacheLifeTime);
if ($cacheSvc->test($cache_id)) {
//BizSystem::log(LOG_DEBUG, "DATAOBJ", ". Query Sql = ".$rewritesql." BIND: $bindValueString");
$resultArray = $cacheSvc->load($cache_id);
} else {
BizSystem::log(LOG_DEBUG, "DATAOBJ", "Query Sql = " . $rewritesql . " BIND: {$bindValueString}");
$result = $db->query($rewritesql, $bindValues);
$resultArray = $result->fetch();
$cacheSvc->save($resultArray, $cache_id);
}
} else {
$resultSet = $db->query($rewritesql, $bindValues);
$resultArray = $resultSet->fetch();
}
} catch (Exception $e) {
BizSystem::log(LOG_ERR, "DATAOBJ", "Query Error: " . $e->getMessage());
$this->m_ErrorMessage = $this->getMessage("DATA_ERROR_QUERY") . ": " . $sql . ". " . $e->getMessage();
throw new BDOException($this->m_ErrorMessage);
return 0;
}
return $resultArray[0];
}
/**
* Run Search
*
* @return void
*/
public function runSearch()
{
include_once OPENBIZ_BIN . "/easy/SearchHelper.php";
$searchRule = "";
foreach ($this->m_SearchPanel as $element) {
if (!$element->m_FieldName) {
continue;
}
$value = BizSystem::clientProxy()->getFormInputs($element->m_Name);
if ($element->m_FuzzySearch == "Y") {
$value = "*{$value}*";
}
if ($value) {
$searchStr = inputValToRule($element->m_FieldName, $value, $this);
if ($searchRule == "") {
$searchRule .= $searchStr;
} else {
$searchRule .= " AND " . $searchStr;
}
}
}
$this->m_SearchRule = $searchRule;
$this->m_SearchRuleBindValues = QueryStringParam::getBindValues();
$this->m_RefreshData = true;
$this->m_CurrentPage = 1;
BizSystem::log(LOG_DEBUG, "FORMOBJ", $this->m_Name . "::runSearch(), SearchRule=" . $this->m_SearchRule);
$this->runEventLog();
$this->rerender();
}