obj_db = $obj_db;
$this->num2show = $int_num_show;
}
/**
* Method to set search criteria
* Extend this method
*
* @param string $str_criteria
* @return void
*/
public function setSQLcriteria($str_criteria) { }
/**
* Method to compile SQL statement based on criteria
*
* @param string $str_criteria
* @return void
*/
protected function compileSQL() { }
/**
* Method to get string of authors data of bibliographic record
*
* @param integer $int_biblio_id
* @return string
*/
public static function getAuthors($obj_db, $int_biblio_id) {
$_authors = '';
$_sql_str = 'SELECT a.author_name, a.author_id FROM biblio_author AS ba
LEFT JOIN biblio AS b ON ba.biblio_id=b.biblio_id
LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE ba.biblio_id='.$int_biblio_id;
// query the author
$_author_q = $obj_db->query($_sql_str);
// concat author data
while ($_author_d = $_author_q->fetch_row()) {
$counter = count ($_author_d);
$_authors .= $_author_d[0];
$_authors .= ' - ';
}
return $_authors;
}
/**
* Method to get list of document IDs of result
*
* @return mixed
*/
public function getDocumentIds() {
$_temp_resultset = $this->resultset;
while ($_biblio_d = $_temp_resultset->fetch_assoc()) { $this->biblio_ids[] = $_biblio_d['biblio_id']; }
unset($_temp_resultset);
return $this->biblio_ids;
}
/**
* Method to print out document records
*
* @param object $obj_db
* @param integer $int_num2show
* @param boolean $bool_return_output
* @return string
*/
public function getDocumentList($bool_return_output = true) {
global $sysconf;
$_sql_str = $this->compileSQL();
// start time
$_start = function_exists('microtime')?microtime(true):time();
// execute query
$this->resultset = $this->obj_db->query($_sql_str);
if ($this->obj_db->error) {
$this->query_error = $this->obj_db->error;
}
// get total number of rows from query
$_total_q = $this->obj_db->query('SELECT FOUND_ROWS()');
$_total_d = $_total_q->fetch_row();
$this->num_rows = $_total_d[0];
// end time
$_end = function_exists('microtime')?microtime(true):time();
$this->query_time = round($_end-$_start, 5);
if ($bool_return_output) {
// return the html result
return $this->makeOutput();
}
}
/**
* Method to make an output of document records
*
* @return string
*/
protected function makeOutput() {
global $sysconf;
// init the result buffer
$_buffer = '';
// keywords from last search
$_keywords = '';
// loop data
$_i = 0;
if (!$this->resultset) {
return '
';
} else if ($_field == 'availability' && !$this->disable_item_data) {
// get total number of this biblio items/copies
$_item_q = $this->obj_db->query('SELECT COUNT(*) FROM item WHERE biblio_id='.$_biblio_d['biblio_id']);
$_item_c = $_item_q->fetch_row();
// get total number of currently borrowed copies
$_borrowed_q = $this->obj_db->query('SELECT COUNT(*) FROM loan AS l INNER JOIN item AS i'
.' ON l.item_code=i.item_code WHERE l.is_lent=1 AND l.is_return=0 AND i.biblio_id='.$_biblio_d['biblio_id']);
$_borrowed_c = $_borrowed_q->fetch_row();
// total available
$_total_avail = $_item_c[0]-$_borrowed_c[0];
if ($_total_avail < 1) {
$_buffer .= '
';
}
}
}
}
// button
$_biblio_d['detail_button'] = ''.__('Record Detail').'';
if ($this->xml_detail) {
$_biblio_d['xml_button'] = 'XML Detail';
} else {
$_biblio_d['xml_button'] = '';
}
// cover images var
$_image_cover = '';
if (!empty($_biblio_d['image']) && !defined('LIGHTWEIGHT_MODE')) {
$_biblio_d['image'] = urlencode($_biblio_d['image']);
$images_loc = 'images/docs/'.$_biblio_d['image'];
#$cache_images_loc = 'images/cache/'.$_biblio_d['image'];
if ($sysconf['tg']['type'] == 'phpthumb') {
$_image_cover = '