function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false)
{
$SearchSqlTranslator = new SJB_GuestAlertSearchSQLTranslator($this->table_prefix);
$sql_string = $SearchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, $sorting_fields, $this->inner_join);
if ($this->sorting_field !== false && $this->sorting_order !== false) {
$sql_string .= ' ORDER BY ' . $this->sorting_field . ' ' . $this->sorting_order . ' ';
}
SJB_DB::queryExec($sql_string);
$affectedRows = SJB_DB::getAffectedRows();
if ($this->limit !== false) {
if (isset($this->limit['limit'])) {
$sql_string .= 'limit ' . $this->limit['limit'] . ', ' . $this->limit['num_rows'];
} else {
$sql_string .= 'limit ' . $this->limit . ', 100';
}
}
$sql_results = SJB_DB::query($sql_string);
$result = array();
foreach ($sql_results as $sql_result) {
if ($this->valid_criterion_number == 0 || $sql_result['countRows'] == $this->valid_criterion_number) {
$result[]['object_sid'] = $sql_result['object_sid'];
}
}
$this->affectedRows = $affectedRows - (SJB_DB::getAffectedRows() - count($result));
return $result;
}
function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false)
{
$searchSqlTranslator = new SJB_SearchSqlTranslator($this->table_prefix);
$sql_string = $searchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, array($this->sorting_field => $this->sorting_order), $this->inner_join);
SJB_DB::query($sql_string);
$this->affectedRows = SJB_DB::getAffectedRows();
if ($this->limit !== false) {
if (isset($this->limit['limit'])) {
$sql_string .= " limit " . $this->limit['limit'] . ", " . $this->limit['num_rows'];
} else {
$sql_string .= " limit " . $this->limit . ", 100";
}
}
return SJB_DB::query($sql_string);
}
function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false)
{
$searchSqlTranslator = new SJB_InvoiceSearchSQLTranslator($this->table_prefix);
$sqlString = $searchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, $sorting_fields, $this->inner_join);
$where = '';
if ($this->sorting_field !== false && $this->sorting_order !== false) {
$sqlString .= $where . "ORDER BY " . $this->sorting_field . " " . $this->sorting_order . " ";
}
SJB_DB::queryExec($sqlString);
$this->affectedRows = SJB_DB::getAffectedRows();
if ($this->limit !== false) {
if (isset($this->limit['limit'])) {
$sqlString .= "limit " . $this->limit['limit'] . ", " . $this->limit['num_rows'];
} else {
$sqlString .= "limit " . $this->limit . ", 100";
}
}
return SJB_DB::query($sqlString);
}
function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false)
{
if (isset($this->inner_join['contracts'])) {
$this->searchSqlTranslator->setDistinct(true);
}
$sql_string = $this->searchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, $sorting_fields, $this->inner_join);
$where = '';
$groupBy = '';
if ($this->sorting_field !== false && $this->sorting_order !== false) {
$sorting = '';
if ($this->inner_join) {
foreach ($this->inner_join as $key => $val) {
if (isset($val['sort_field'])) {
if (isset($val['noPresix'])) {
$this->sorting_field = $val['sort_field'];
} else {
$this->sorting_field = "`" . $key . "`." . $val['sort_field'];
}
}
if (isset($val['where'])) {
$where .= " {$val['where']} ";
}
if (isset($val['groupBy'])) {
$groupBy .= " GROUP BY {$val['groupBy']} ";
}
if (isset($val['join']) && $val['join'] != 'INNER JOIN') {
$this->searchSqlTranslator->setDistinct(true);
}
}
}
if (is_array($this->sorting_field)) {
$i = 0;
foreach ($this->sorting_field as $sorting_field) {
$sorting .= " {$sorting_field} {$this->sorting_order}";
if ($i == 0) {
$sorting .= ', ';
}
$i++;
}
} else {
$sorting = $this->sorting_field . " " . $this->sorting_order;
}
$sql_string .= $where . " {$groupBy} ORDER BY {$sorting} ";
}
$affectedRows = 0;
if ($this->limit !== false) {
SJB_DB::queryExec($sql_string);
$affectedRows = SJB_DB::getAffectedRows();
if (isset($this->limit['limit'])) {
$sql_string .= "limit " . $this->limit['limit'] . ", " . $this->limit['num_rows'];
} else {
$sql_string .= "limit " . $this->limit . ", 100";
}
}
$sql_results = SJB_DB::query($sql_string);
if ($this->limit === false) {
$affectedRows = SJB_DB::getAffectedRows();
}
$result = array();
foreach ($sql_results as $sql_result) {
if ($this->valid_criterion_number == 0 || $sql_result['countRows'] == $this->valid_criterion_number) {
$result[]['object_sid'] = $sql_result['object_sid'];
}
}
$this->affectedRows = $affectedRows - (SJB_DB::getAffectedRows() - count($result));
// TODO написала это потому что в browseCompany неправильно считается общее количество компаний. Например по факту находится одна компания, но пишется, что найдено 16.
if ($this->limitByPHP !== false) {
$newArr = $result;
$result = array();
for ($i = $this->limitByPHP['limit']; $i < $this->limitByPHP['limit'] + $this->limitByPHP['num_rows']; $i++) {
if (!isset($newArr[$i])) {
break;
}
$result[$i] = $newArr[$i];
}
}
return $result;
}
function getObjectInfo($sorting_fields, $inner_join = false, $relevance = false)
{
$SearchSqlTranslator = new SJB_PaymentLogSearchSQLTranslator($this->table_prefix);
$sql_string = $SearchSqlTranslator->buildSqlQuery($this->criteria, $this->valid_criterion_number, array($this->sorting_field => $this->sorting_order));
SJB_DB::query($sql_string);
$this->affectedRows = SJB_DB::getAffectedRows();
$paging_offset = ($this->current_page - 1) * $this->items_per_page;
$sql_string .= " LIMIT {$paging_offset}, {$this->items_per_page}";
return SJB_DB::query($sql_string);
}
