$selected_year = (int) $_GET['year'];
} else {
$selected_year = date('Y') - 1;
}
$reportgrid->setSQLCriteria($criteria);
// callback function to show overdued list
function showUsage($obj_db, $array_data, $int_current_field_num)
{
global $selected_year;
$_usage_q = $obj_db->query('SELECT COUNT(*) FROM loan AS l
WHERE l.item_code=\'' . $array_data[0] . '\' AND l.loan_date LIKE \'' . $selected_year . '-' . $array_data[$int_current_field_num] . '%\'');
$_usage_d = $_usage_q->fetch_row();
return $_usage_d[0] == '0' ? '<span style="color: #ff0000;">0</span>' : '<strong>' . $_usage_d[0] . '</strong>';
}
// modify column value
$reportgrid->modifyColumnContent(2, 'callback{showUsage}');
$reportgrid->modifyColumnContent(3, 'callback{showUsage}');
$reportgrid->modifyColumnContent(4, 'callback{showUsage}');
$reportgrid->modifyColumnContent(5, 'callback{showUsage}');
$reportgrid->modifyColumnContent(6, 'callback{showUsage}');
$reportgrid->modifyColumnContent(7, 'callback{showUsage}');
$reportgrid->modifyColumnContent(8, 'callback{showUsage}');
$reportgrid->modifyColumnContent(9, 'callback{showUsage}');
$reportgrid->modifyColumnContent(10, 'callback{showUsage}');
$reportgrid->modifyColumnContent(11, 'callback{showUsage}');
$reportgrid->modifyColumnContent(12, 'callback{showUsage}');
$reportgrid->modifyColumnContent(13, 'callback{showUsage}');
// no sort column
$reportgrid->disableSort(__('Jan'), __('Feb'), __('Mar'), __('Apr'), __('May'), __('Jun'), __('Jul'), __('Aug'), __('Sep'), __('Oct'), __('Nov'), __('Dec'));
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
// author name query
$_biblio_q = $obj_db->query('SELECT b.title, a.author_name FROM biblio AS b
LEFT JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id
LEFT JOIN mst_author AS a ON ba.author_id=a.author_id
WHERE b.biblio_id=' . $array_data[0]);
$_authors = '';
while ($_biblio_d = $_biblio_q->fetch_row()) {
$_title = $_biblio_d[0];
$_authors .= $_biblio_d[1] . ' - ';
}
$_authors = substr_replace($_authors, '', -3);
$_output = $_title . '<br /><i>' . $_authors . '</i>' . "\n";
return $_output;
}
// modify column value
$reportgrid->modifyColumnContent(1, 'callback{showTitleAuthors}');
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$xlsquery = 'SELECT b.biblio_id, b.title AS \'' . __('Title') . '\'' . ', COUNT(item_id) AS \'' . __('Copies') . '\'' . ', pl.place_name AS \'' . __('Publishing Place') . '\'' . ', pb.publisher_name AS \'' . __('Publisher') . '\'' . ', b.isbn_issn AS \'' . __('ISBN/ISSN') . '\', b.call_number AS \'' . __('Call Number') . '\' FROM ' . $table_spec . ' WHERE ' . $outer_criteria . ' group by b.biblio_id';
// echo $xlsquery;
unset($_SESSION['xlsdata']);
$_SESSION['xlsquery'] = $xlsquery;
$_SESSION['tblout'] = "title_list";
echo '<a href="../xlsoutput.php" class="button">' . __('Export to spreadsheet format') . '</a>';
$content = ob_get_clean();
// include the page template
require SB . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
if (isset($_GET['recsEachPage'])) {
$recsEachPage = (int) $_GET['recsEachPage'];
$num_recs_show = $recsEachPage >= 20 && $recsEachPage <= 200 ? $recsEachPage : $num_recs_show;
}
$reportgrid->setSQLCriteria($criteria);
// callback function to show title and authors
function loanStatus($obj_db, $array_data)
{
if ($array_data[6] == 0) {
return '<strong>' . lang_mod_biblio_item_common_status_onloan . '</strong>';
} else {
return lang_mod_biblio_item_common_status_returned;
}
}
// modify column value
$reportgrid->modifyColumnContent(6, 'callback{loanStatus}');
// set table and table header attributes
$reportgrid->table_attr = 'align="center" id="dataListPrinted" cellpadding="3" cellspacing="1"';
$reportgrid->table_header_attr = 'class="dataListHeaderPrinted"';
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'pagingBox\').update(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/notemplate_page_tpl.php';
}
?>
$_buffer .= '<div style="color: black; font-size: 10pt; margin-bottom: 3px;">' . $member_mail_address . '</div>';
$_buffer .= '<div style="font-size: 10pt; margin-bottom: 3px;"><div id="' . $array_data[0] . 'emailStatus"></div>' . __('E-mail') . ': <a href="mailto:' . $member_d[1] . '">' . $member_d[1] . '</a> - <a class="usingAJAX" href="' . MODULES_WEB_ROOT_DIR . 'membership/overdue_mail.php' . '" postdata="memberID=' . $array_data[0] . '" loadcontainer="' . $array_data[0] . 'emailStatus">Send Notification e-mail</a> - ' . __('Phone Number') . ': ' . $member_d[2] . '</div>';
$_buffer .= '<table width="100%" cellspacing="0">';
while ($ovd_title_d = $ovd_title_q->fetch_assoc()) {
$_buffer .= '<tr>';
$_buffer .= '<td valign="top" width="10%">' . $ovd_title_d['item_code'] . '</td>';
$_buffer .= '<td valign="top" width="40%">' . $ovd_title_d['title'] . '<div>' . __('Price') . ': ' . $ovd_title_d['price'] . ' ' . $ovd_title_d['price_currency'] . '</div></td>';
$_buffer .= '<td width="20%">' . __('Overdue') . ': ' . $ovd_title_d['Overdue Days'] . ' ' . __('day(s)') . '</td>';
$_buffer .= '<td width="30%">' . __('Loan Date') . ': ' . $ovd_title_d['loan_date'] . ' ' . __('Due Date') . ': ' . $ovd_title_d['due_date'] . '</td>';
$_buffer .= '</tr>';
}
$_buffer .= '</table>';
return $_buffer;
}
// modify column value
$reportgrid->modifyColumnContent(0, 'callback{showOverduedList}');
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show);
?>
<script type="text/javascript" src="<?php
echo JS_WEB_ROOT_DIR . 'jquery.js';
?>
"></script>
<script type="text/javascript" src="<?php
echo JS_WEB_ROOT_DIR . 'updater.js';
?>
"></script>
<script type="text/javascript">
// registering event for send email button
$(document).ready(function() {
parent.$('#pagingBox').html('<?php
{
global $start_date, $until_date;
$_count_q = $obj_db->query('SELECT COUNT(log_id) FROM system_log WHERE log_location=\'membership\' AND log_type=\'staff\'
AND log_msg LIKE \'%add new member%\' AND id=\'' . $array_data['4'] . '\' AND TO_DAYS(log_date) BETWEEN TO_DAYS(\'' . $start_date . '\') AND TO_DAYS(\'' . $until_date . '\')');
$_count_d = $_count_q->fetch_row();
return $_count_d[0];
}
function showCirculation($obj_db, $array_data)
{
global $start_date, $until_date;
$_user = $obj_db->escape_string($array_data[0]);
$_count_q = $obj_db->query('SELECT COUNT(log_id) FROM system_log WHERE log_location=\'circulation\' AND log_type=\'member\'
AND (log_msg LIKE \'' . $_user . '%transaction with member%\' OR log_msg LIKE \'' . $_user . '%Quick Return%\') AND TO_DAYS(log_date) BETWEEN TO_DAYS(\'' . $start_date . '\') AND TO_DAYS(\'' . $until_date . '\')');
$_count_d = $_count_q->fetch_row();
return $_count_d[0];
}
// columns modification settings
$reportgrid->column_width = array(0 => '10%', 1 => '10%');
$reportgrid->modifyColumnContent(2, 'callback{showBiblioEntries}');
$reportgrid->modifyColumnContent(3, 'callback{showItemEntries}');
$reportgrid->modifyColumnContent(4, 'callback{showMemberEntries}');
$reportgrid->modifyColumnContent(5, 'callback{showCirculation}');
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
unset($member_q);
$ovd_title_q = $obj_db->query('SELECT l.item_code,
b.title, l.loan_date, l.due_date
FROM loan AS l
LEFT JOIN item AS i ON l.item_code=i.item_code
LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id
WHERE (l.is_lent=1 AND l.is_return=0) AND l.member_id=\'' . $array_data[0] . '\'' . (!empty($date_criteria) ? $date_criteria : ''));
$_buffer = '<div style="font-weight: bold; color: black; font-size: 10pt; margin-bottom: 3px;">' . $member_name . ' (' . $array_data[0] . ')</div>';
$_buffer .= '<div style="font-size: 10pt; margin-bottom: 3px;">' . __('E-mail') . ': <a href="mailto:' . $member_d[1] . '">' . $member_d[1] . '</a> - ' . __('Phone Number') . ': ' . $member_d[2] . '</div>';
$_buffer .= '<table width="100%" cellspacing="0">';
while ($ovd_title_d = $ovd_title_q->fetch_assoc()) {
$_buffer .= '<tr>';
$_buffer .= '<td valign="top" width="10%">' . $ovd_title_d['item_code'] . '</td>';
$_buffer .= '<td valign="top" width="60%">' . $ovd_title_d['title'] . '</td>';
$_buffer .= '<td width="30%">' . __('Loan Date') . ': ' . $ovd_title_d['loan_date'] . ' ' . __('Due Date') . ': ' . $ovd_title_d['due_date'] . '</td>';
$_buffer .= '</tr>';
}
$_buffer .= '</table>';
return $_buffer;
}
// modify column value
$reportgrid->modifyColumnContent(0, 'callback{showLoanList}');
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
$_count_q = $obj_db->query('SELECT COUNT(log_id) FROM system_log WHERE log_location=\'circulation\' AND log_type=\'member\'
AND (log_msg LIKE \'' . $_user . '%return item%\' OR \'' . $_user . '%Quick Return%\') AND TO_DAYS(log_date) BETWEEN TO_DAYS(\'' . $start_date . '\') AND TO_DAYS(\'' . $until_date . '\')');
$_count_d = $_count_q->fetch_row();
return $_count_d[0];
}
function showCirculation_Extends($obj_db, $array_data)
{
global $start_date, $until_date;
$_user = $obj_db->escape_string($array_data[0]);
$_count_q = $obj_db->query('SELECT COUNT(log_id) FROM system_log WHERE log_location=\'circulation\' AND log_type=\'member\'
AND (log_msg LIKE \'' . $_user . '%extend loan%\') AND TO_DAYS(log_date) BETWEEN TO_DAYS(\'' . $start_date . '\') AND TO_DAYS(\'' . $until_date . '\')');
$_count_d = $_count_q->fetch_row();
return $_count_d[0];
}
// columns modification settings
$reportgrid->column_width = array(0 => '10%', 1 => '10%');
$reportgrid->modifyColumnContent(2, 'callback{showBiblioEntries}');
$reportgrid->modifyColumnContent(3, 'callback{showItemEntries}');
$reportgrid->modifyColumnContent(4, 'callback{showMemberEntries}');
$reportgrid->modifyColumnContent(5, 'callback{showCirculation_Loan}');
$reportgrid->modifyColumnContent(6, 'callback{showCirculation_Return}');
$reportgrid->modifyColumnContent(7, 'callback{showCirculation_Extends}');
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SB . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
