orig_query = $str_criteria;
$_queries = simbio_tokenizeCQL($str_criteria, $this->searchable_fields, $this->stop_words, $this->queries_word_num_allowed);
// echo ''; var_dump($_queries); echo '
';
if (count($_queries) < 1) {
return null;
}
// loop each query
foreach ($_queries as $_num => $_query) {
// field
$_field = $_query['f'];
// boolean
if ($_title_buffer == '' && $_field != 'boolean') {
$_sql_criteria .= " $_boolean ";
}
// break the loop if we meet `cql_end` field
if ($_field == 'cql_end') { break; }
// boolean mode
$_b = isset($_query['b'])?$_query['b']:$_query;
if ($_b == '*') {
$_boolean = 'OR';
} else { $_boolean = 'AND'; }
// search value
$_q = @$this->obj_db->escape_string($_query['q']);
// searched fields flag set
$_searched_fields[$_field] = 1;
$_previous_field = $_field;
switch ($_field) {
case 'location' :
if (!$this->disable_item_data) {
if ($_b == '-') {
$_sql_criteria .= " biblio.location NOT LIKE '%$_q%'";
} else { $_sql_criteria .= " biblio.location LIKE '%$_q%'"; }
}
break;
case 'colltype' :
if (!$this->disable_item_data) {
if ($_b == '-') {
$_sql_criteria .= " biblio.collection_types NOT LIKE '%$_q%'";
} else { $_sql_criteria .= " biblio.collection_types NOT LIKE ($_subquery)"; }
}
break;
case 'itemcode' :
if (!$this->disable_item_data) {
if ($_b == '-') {
$_sql_criteria .= " biblio.items NOT LIKE '%$_q%'";
} else { $_sql_criteria .= " biblio.items LIKE '%$_q%'"; }
}
break;
case 'callnumber' :
if ($_b == '-') {
$_sql_criteria .= ' biblio.call_number NOT LIKE \''.$_q.'%\'';
} else { $_sql_criteria .= ' biblio.call_number LIKE \''.$_q.'%\''; }
break;
case 'itemcallnumber' :
if (!$this->disable_item_data) {
if ($_b == '-') {
$_sql_criteria .= ' item.call_number NOT LIKE \''.$_q.'%\'';
} else { $_sql_criteria .= ' item.call_number LIKE \''.$_q.'%\''; }
}
break;
case 'class' :
if ($_b == '-') {
$_sql_criteria .= ' biblio.classification NOT LIKE \''.$_q.'%\'';
} else { $_sql_criteria .= ' biblio.classification LIKE \''.$_q.'%\''; }
break;
case 'isbn' :
if ($_b == '-') {
$_sql_criteria .= ' biblio.isbn_issn!=\''.$_q.'\'';
} else { $_sql_criteria .= ' biblio.isbn_issn=\''.$_q.'\''; }
break;
case 'publisher' :
$_subquery = 'SELECT publisher_id FROM mst_publisher WHERE publisher_name LIKE \'%'.$_q.'%\'';
if ($_b == '-') {
$_sql_criteria .= " biblio.publisher_id NOT IN ($_subquery)";
} else { $_sql_criteria .= " biblio.publisher_id IN ($_subquery)"; }
break;
case 'publishyear' :
if ($_b == '-') {
$_sql_criteria .= ' biblio.publish_year!=\''.$_q.'\'';
} else { $_sql_criteria .= ' biblio.publish_year=\''.$_q.'\''; }
break;
case 'gmd' :
$_subquery = 'SELECT gmd_id FROM mst_gmd WHERE gmd_name=\''.$_q.'\'';
if ($_b == '-') {
$_sql_criteria .= " biblio.gmd_id NOT IN ($_subquery)";
} else { $_sql_criteria .= " biblio.gmd_id IN ($_subquery)"; }
break;
case 'notes' :
$_q = isset($_query['is_phrase'])?'"'.$_q.'"':$_q;
if ($_b == '-') {
$_sql_criteria .= " NOT (MATCH (biblio.notes) AGAINST ('".$_q."' IN BOOLEAN MODE))";
} else { $_sql_criteria .= " (MATCH (biblio.notes) AGAINST ('".$_q."' IN BOOLEAN MODE))"; }
break;
}
}
// remove boolean's logic symbol prefix and suffix
$_sql_criteria = preg_replace('@^(AND|OR|NOT)\s*|\s+(AND|OR|NOT)$@i', '', trim($_sql_criteria));
// below for debugging purpose only
// echo "$_sql_criteria
";
$this->criteria = array('sql_criteria' => $_sql_criteria, 'searched_fields' => $_searched_fields);
return $this->criteria;
}
/**
* Method to print out document records
*
* @param object $obj_db
* @param integer $int_num2show
* @param boolean $bool_return_output
* @return string
*/
public function compileSQL() {
global $sysconf;
// get page number from http get var
if (!isset($_GET['page']) OR $_GET['page'] < 1){
$_page = 1;
} else{
$_page = (integer)$_GET['page'];
}
$this->current_page = $_page;
// count the row offset
if ($_page <= 1) {
$_offset = 0;
} else {
$_offset = ($_page*$this->num2show) - $this->num2show;
}
// init sql string
$_sql_str = 'SELECT SQL_CALC_FOUND_ROWS biblio.biblio_id, biblio.title, biblio.image, biblio.isbn_issn,
biblio.publish_year, pbl.publisher_name AS `publisher`, pplc.place_name AS `publish_place`, biblio.labels, biblio.input_date';
// checking custom frontpage fields file
$custom_frontpage_record_file = SB.$sysconf['template']['dir'].'/'.$sysconf['template']['theme'].'/custom_frontpage_record.inc.php';
if (file_exists($custom_frontpage_record_file)) {
include $custom_frontpage_record_file;
$this->enable_custom_frontpage = true;
$this->custom_fields = $custom_fields;
foreach ($this->custom_fields as $_field => $_field_opts) {
if ($_field_opts[0] == 1 && !in_array($_field, array('availability', 'isbn_issn'))) {
$_sql_str .= ", biblio.$_field";
}
}
}
// additional SQL string
$_add_sql_str = ' LEFT JOIN mst_publisher AS pbl ON biblio.publisher_id=pbl.publisher_id ';
$_add_sql_str .= ' LEFT JOIN mst_place AS pplc ON biblio.publish_place_id=pplc.place_id ';
// location
if ($this->criteria) {
if (isset($this->criteria['searched_fields']['location']) || isset($this->criteria['searched_fields']['colltype'])) {
if (!$this->disable_item_data) {
$_add_sql_str .= ' LEFT JOIN item ON biblio.biblio_id=item.biblio_id ';
}
}
}
$_add_sql_str .= ' WHERE opac_hide=0 ';
// promoted flag
if ($this->only_promoted) { $_add_sql_str .= ' AND promoted=1'; }
// main search criteria
if ($this->criteria) {
$_add_sql_str .= ' AND ('.$this->criteria['sql_criteria'].') ';
}
$_sql_str .= ' FROM biblio '.$_add_sql_str.' ORDER BY biblio.last_update DESC LIMIT '.$_offset.', '.$this->num2show;
// for debugging purpose only
// echo "$_sql_str
";
return $_sql_str;
}
}