if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_' . $type . '_type', 'id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
// create sql op object
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_topic', 'topic_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
<?php
/* main content */
// topic of removal
if (isset($_GET['removesess'])) {
$idx = $_GET['removesess'];
unset($_SESSION['biblioTopic'][$idx]);
echo '<script type="text/javascript">';
echo 'alert(\'Topic removed!\');';
echo 'location.href = \'iframe_topic.php\';';
echo '</script>';
}
if (isset($_POST['remove'])) {
$id = (int) $_POST['remove'];
$bid = (int) $_POST['bid'];
$sql_op = new simbio_dbop($dbs);
$sql_op->delete('biblio_topic', 'topic_id=' . $id . ' AND biblio_id=' . $bid);
echo '<script type="text/javascript">';
echo 'alert(\'Topic succesfully removed!\');';
echo 'location.href = \'iframe_topic.php?biblioID=' . $bid . '\';';
echo '</script>';
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
// database list
$biblio_topic_q = $dbs->query("SELECT bt.*, t.topic, t.topic_type FROM biblio_topic AS bt\n LEFT JOIN mst_topic AS t ON bt.topic_id=t.topic_id\n WHERE bt.biblio_id={$biblioID} ORDER BY level ASC");
$row = 1;
while ($biblio_topic_d = $biblio_topic_q->fetch_assoc()) {
// alternate the row color
$row_class = $row % 2 == 0 ? 'alterCell' : 'alterCell2';
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array($dbs->escape_string(trim($_POST['itemID'])));
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = $dbs->escape_string(trim($itemID));
if (!$sql_op->delete('mst_item_status', "item_status_id='{$itemID}'")) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
}
}
/* item status update process end */
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// get content data
$content_q = $dbs->query('SELECT content_title FROM content WHERE content_id=' . $itemID);
$content_d = $content_q->fetch_row();
if (!$sql_op->delete('content', "content_id='{$itemID}'")) {
$error_num++;
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' DELETE content (' . $content_d[0] . ')');
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
// create sql op object
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_loan_rules', 'loan_rules_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script language="Javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script language="Javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array($dbs->escape_string(trim($_POST['itemID'])));
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = $dbs->escape_string(trim($itemID));
if (!$sql_op->delete('mst_language', "language_id='{$itemID}'")) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
}
}
/* language_name update process end */
$bid = (int) $_POST['bid'];
$sql_op = new simbio_dbop($dbs);
// check if the item still on loan
$loan_q = $dbs->query('SELECT DISTINCT l.item_code, b.title 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 i.item_id=' . $id . ' AND l.is_lent=1 AND l.is_return=0');
$loan_d = $loan_q->fetch_row();
// send an alert if the member cant be deleted
if ($loan_q->num_rows > 0) {
echo '<script type="text/javascript">';
echo 'alert(\'' . lang_mod_biblio_item_alert_delete_fail_on_loan . '\');';
echo 'self.location.href = \'iframe_item_list.php?biblioID=' . $bid . '\';';
echo '</script>';
} else {
if ($sql_op->delete('item', 'item_id=' . $id)) {
echo '<script type="text/javascript">';
echo 'alert(\'' . lang_mod_biblio_item_alert_remove_success . '\');';
echo 'self.location.href = \'iframe_item_list.php?biblioID=' . $bid . '\';';
echo '</script>';
} else {
echo '<script type="text/javascript">';
echo 'alert(\'' . lang_mod_biblio_item_alert_remove_failed . '\');';
echo 'self.location.href = \'iframe_item_list.php?biblioID=' . $bid . '\';';
echo '</script>';
}
}
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// check if the item still on loan
$loan_q = $dbs->query('SELECT i.item_code, b.title, COUNT(l.loan_id) FROM item AS i
LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id
LEFT JOIN loan AS l ON (i.item_code=l.item_code AND l.is_lent=1 AND l.is_return=0)
WHERE i.item_id=' . $itemID . ' GROUP BY i.item_code');
$loan_d = $loan_q->fetch_row();
// if there is no loan
if ($loan_d[2] < 1) {
if (!$sql_op->delete('item', 'item_id=' . $itemID)) {
$error_num++;
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'] . ' DELETE item data (' . $loan_d[0] . ') with title (' . $loan_d[1] . ')');
}
} else {
$still_on_loan[] = $loan_d[0] . ' - ' . $loan_d[1];
$error_num++;
}
}
if ($still_on_loan) {
$items = '';
foreach ($still_on_loan as $item) {
$items .= $item . "\n";
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// get biblio ID for this subcription
$biblio_q = $dbs->query('SELECT biblio_id FROM serial WHERE serial_id=' . (isset($_POST['itemID'][0]) ? $_POST['itemID'][0] : '0') . ' LIMIT 1');
$biblio_d = $biblio_q->fetch_row();
$biblioID = $biblio_d[0];
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('serial', 'serial_id=' . $itemID)) {
$error_num++;
} else {
// also delete kardex data
$sql_op->delete('kardex', 'serial_id=' . $itemID);
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('Subscription data successfully deleted'));
} else {
utility::jsAlert(__('Subscription data FAILED to deleted!'));
}
}
}
/* RECORD OPERATION END */
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_member_type', 'member_type_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array($dbs->escape_string(trim($_POST['itemID'])));
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = $dbs->escape_string(trim($itemID));
// check if this item data still have an item
$item_q = $dbs->query('SELECT loc.location_name, COUNT(item_id) FROM item AS i
LEFT JOIN mst_location AS loc ON i.location_id=loc.location_id
WHERE i.location_id=\'' . $itemID . '\' GROUP BY i.location_id');
$item_d = $item_q->fetch_row();
if ($item_d[1] < 1) {
if (!$sql_op->delete('mst_location', "location_id='{$itemID}'")) {
$error_num++;
}
} else {
$msg = str_replace('{item_name}', $item_d[0], __('Location ({item_name}) still used by {number_items} item(s)'));
//mfc
$msg = str_replace('{number_items}', $item_d[1], $msg);
$still_have_item[] = $msg;
$error_num++;
}
}
if ($still_have_item) {
$undeleted_locations = '';
foreach ($still_have_item as $location) {
$undeleted_locations .= $location . "\n";
}
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_label', 'label_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// check if this item data still have an item
$item_q = $dbs->query('SELECT ct.coll_type_name, COUNT(item_id) FROM item AS i
LEFT JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id
WHERE i.coll_type_id=' . $itemID . ' GROUP BY i.coll_type_id');
$item_d = $item_q->fetch_row();
if ($item_d[1] < 1) {
if (!$sql_op->delete('mst_coll_type', "coll_type_id={$itemID}")) {
$error_num++;
}
} else {
$msg = str_replace('{item_name}', $item_d[0], __('Location ({item_name}) still used by {number_items} item(s)'));
//mfc
$msg = str_replace('{number_items}', $item_d[1], $msg);
$still_have_item[] = $msg;
$error_num++;
}
}
if ($still_have_item) {
$undeleted_coll_types = '';
foreach ($still_have_item as $coll_type) {
$undeleted_coll_types .= $coll_type . "\n";
}
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_frequency', 'frequency_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_supplier', 'supplier_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_place', 'place_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
$itemID = (int) isset($_GET['itemID']) ? $_GET['itemID'] : 0;
if (isset($_POST['save'])) {
$data['topic_id'] = (int) $_POST['topic_id'];
$data['scope'] = trim($dbs->escape_string(strip_tags($_POST['scope'])));
# create new sql op object
$sql_op = new simbio_dbop($dbs);
if (!empty($_POST['vocabolary_id'])) {
// do update
$save = $sql_op->update('mst_voc_ctrl', $data, 'vocabolary_id=' . $_POST['vocabolary_id']);
} else {
// insert
$save = $sql_op->insert('mst_voc_ctrl', $data);
}
if (isset($_POST['delete'])) {
# create new sql op object
$save = $sql_op->delete('mst_voc_ctrl', 'vocabolary_id=' . $_POST['vocabolary_id']);
}
if ($save) {
$alert_save = '<script type="text/javascript">';
$alert_save .= 'alert(\'' . __('Data saved!') . '\');';
$alert_save .= 'parent.setIframeContent(\'itemIframe\', \'' . MWB . 'master_file/iframe_vocabolary_control.php?itemID=' . $data['topic_id'] . '\');';
$alert_save .= 'top.jQuery.colorbox.close();';
$alert_save .= '</script>';
echo $alert_save;
} else {
utility::jsAlert('Failed save data!');
}
}
// start buffer
ob_start();
// query scope
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_author', 'author_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(lang_mod_masterfile_author_alert_all_delete_ok);
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(lang_mod_masterfile_author_alert_all_delete_fail);
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
// only admin can delete
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('fines', 'fines_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert('Fines data succesfully deleted!');
} else {
utility::jsAlert('Fines data FAILED to delete!');
}
}
}
/* RECORD OPERATION END */
/* header */
?>
<div class="sub_section">
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
$http_query = '';
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// check if this biblio data still have an item
$_sql_biblio_item_q = sprintf('SELECT b.title, COUNT(item_id) FROM biblio AS b
LEFT JOIN item AS i ON b.biblio_id=i.biblio_id
WHERE b.biblio_id=%d GROUP BY title', $itemID);
$biblio_item_q = $dbs->query($_sql_biblio_item_q);
$biblio_item_d = $biblio_item_q->fetch_row();
if ($biblio_item_d[1] < 1) {
if (!$sql_op->delete('biblio', "biblio_id={$itemID}")) {
$error_num++;
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'] . ' DELETE bibliographic data (' . $biblio_item_d[0] . ') with biblio_id (' . $itemID . ')');
// delete related data
$sql_op->delete('biblio_topic', "biblio_id={$itemID}");
$sql_op->delete('biblio_author', "biblio_id={$itemID}");
$sql_op->delete('biblio_attachment', "biblio_id={$itemID}");
// add to http query for UCS delete
$http_query .= "itemID[]={$itemID}&";
}
} else {
$still_have_item[] = substr($biblio_item_d[0], 0, 45) . '... still have ' . $biblio_item_d[1] . ' copies';
$error_num++;
}
// remove session array
unset($_SESSION['biblioAttach'][$idx]);
echo '<script type="text/javascript">';
echo 'alert(\'' . __('Attachment removed!') . '\');';
echo 'location.href = \'iframe_attach.php\';';
echo '</script>';
}
if (isset($_POST['bid']) and isset($_POST['remove'])) {
$bid = (int) $_POST['bid'];
$file = (int) $_POST['remove'];
// query file data from database
$file_q = $dbs->query('SELECT * FROM files WHERE file_id=' . $file);
$file_d = $file_q->fetch_assoc();
// attachment data delete
$sql_op = new simbio_dbop($dbs);
$sql_op->delete('biblio_attachment', "file_id={$file} AND biblio_id={$bid}");
echo '<script type="text/javascript">';
if ($_POST['alsoDeleteFile'] == '1') {
// remove file from repository and filesystem
@unlink(REPO_BASE_DIR . str_replace('/', DIRECTORY_SEPARATOR, $file_d['file_dir']) . DIRECTORY_SEPARATOR . $file_d['file_name']);
echo 'alert(\'Attachment ' . $file_d['file_name'] . ' succesfully removed!\');';
}
echo 'location.href = \'iframe_attach.php?biblioID=' . $bid . '\';';
echo '</script>';
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
// database list
$biblio_attach_q = $dbs->query('SELECT att.*,fl.* FROM biblio_attachment AS att
<?php
/* main content */
// author of removal
if (isset($_GET['removesess'])) {
$idx = $_GET['removesess'];
unset($_SESSION['biblioAuthor'][$idx]);
echo '<script type="text/javascript">';
echo 'alert(\'' . __('Author succesfully removed!') . '\');';
echo 'location.href = \'iframe_author.php\';';
echo '</script>';
}
if (isset($_POST['remove'])) {
$id = (int) $_POST['remove'];
$bid = (int) $_POST['bid'];
$sql_op = new simbio_dbop($dbs);
$sql_op->delete('biblio_author', 'author_id=' . $id . ' AND biblio_id=' . $bid);
echo '<script type="text/javascript">';
echo 'alert(\'' . __('Author removed!') . '\');';
echo 'location.href = \'iframe_author.php?biblioID=' . $bid . '\';';
echo '</script>';
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
// database list
$biblio_author_q = $dbs->query("SELECT ba.*, a.author_name, a.author_year, a.authority_type FROM biblio_author AS ba\n LEFT JOIN mst_author AS a ON ba.author_id=a.author_id\n WHERE ba.biblio_id={$biblioID} ORDER BY level ASC");
$row = 1;
while ($biblio_author_d = $biblio_author_q->fetch_assoc()) {
// alternate the row color
$row_class = $row % 2 == 0 ? 'alterCell' : 'alterCell2';
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// get user data
$user_q = $dbs->query('SELECT username, realname FROM user WHERE user_id=' . $itemID);
$user_d = $user_q->fetch_row();
if (!$sql_op->delete('user', "user_id='{$itemID}'")) {
$error_num++;
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' DELETE user (' . $user_d[1] . ') with username (' . $user_d[0] . ')');
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
}
exit;
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// get group data
$group_q = $dbs->query('SELECT group_name FROM user_group WHERE group_id=' . $itemID);
$group_d = $group_q->fetch_row();
if (!$sql_op->delete('user_group', 'group_id=' . $itemID)) {
$error_num++;
} else {
// also delete all records related to this data
// delete group privileges
$dbs->query('DELETE FROM group_access WHERE group_id=' . $itemID);
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' DELETE group (' . $group_d[0] . ')');
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// get module data
$module_q = $dbs->query('SELECT module_name, module_path FROM mst_module WHERE module_id=' . $itemID);
$module_d = $module_q->fetch_row();
if (!$sql_op->delete('mst_module', "module_id={$itemID}")) {
$error_num++;
} else {
// also delete all records related to this data
// delete group privileges
$dbs->query('DELETE FROM group_access WHERE module_id=' . $itemID);
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' DELETE module (' . $module_d[0] . ') with path (' . $module_d[1] . ')');
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
$error_num = 0;
$still_have_loan = array();
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array($dbs->escape_string(trim($_POST['itemID'])));
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = $dbs->escape_string(trim($itemID));
// check if the member still have loan
$loan_q = $dbs->query('SELECT DISTINCT m.member_id, m.member_name, COUNT(l.loan_id) FROM member AS m
LEFT JOIN loan AS l ON (m.member_id=l.member_id AND l.is_lent=1 AND l.is_return=0)
WHERE m.member_id=\'' . $itemID . '\' GROUP BY m.member_id');
$loan_d = $loan_q->fetch_row();
if ($loan_d[2] < 1) {
if (!$sql_op->delete('member', "member_id='{$itemID}'")) {
$error_num++;
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'membership', $_SESSION['realname'] . ' DELETE member data (' . $loan_d[1] . ') with ID (' . $loan_d[0] . ')');
}
} else {
$still_have_loan[] = $loan_d[0] . ' - ' . $loan_d[1];
$error_num++;
}
}
if ($still_have_loan) {
$members = '';
foreach ($still_have_loan as $mbr) {
$members .= $mbr . "\n";
}
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
// get info about this holiday
$rec_q = $dbs->query('SELECT holiday_date FROM holiday WHERE holiday_id=' . $itemID);
$rec_d = $rec_q->fetch_row();
if (!$sql_op->delete('holiday', 'holiday_id=' . $itemID)) {
$error_num++;
} else {
// remove session for this holiday
unset($_SESSION['holiday_date'][$rec_d[0]]);
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
if (!($can_read and $can_write)) {
die;
}
/* DATA DELETION PROCESS */
$sql_op = new simbio_dbop($dbs);
$failed_array = array();
$error_num = 0;
if (!is_array($_POST['itemID'])) {
// make an array
$_POST['itemID'] = array((int) $_POST['itemID']);
}
// loop array
foreach ($_POST['itemID'] as $itemID) {
$itemID = (int) $itemID;
if (!$sql_op->delete('mst_gmd', 'gmd_id=' . $itemID)) {
$error_num++;
}
}
// error alerting
if ($error_num == 0) {
utility::jsAlert(__('All Data Successfully Deleted'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
} else {
utility::jsAlert(__('Some or All Data NOT deleted successfully!\\nPlease contact system administrator'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?' . $_POST['lastQueryStr'] . '\');</script>';
}
exit;
}
}
/* RECORD OPERATION END */
<?php
/* main content */
// author of removal
if (isset($_GET['removesess'])) {
$idx = $_GET['removesess'];
unset($_SESSION['biblioToBiblio'][$idx]);
echo '<script type="text/javascript">';
echo 'alert(\'' . __('Biblio relation succesfully removed!') . '\');';
echo 'location.href = \'iframe_biblio_rel.php\';';
echo '</script>';
}
if (isset($_POST['remove'])) {
$id = (int) $_POST['remove'];
$bid = (int) $_POST['bid'];
$sql_op = new simbio_dbop($dbs);
$sql_op->delete('biblio_relation', 'biblio_id=' . $bid . ' AND rel_biblio_id=' . $id);
echo '<script type="text/javascript">';
echo 'alert(\'' . __('Biblio relation removed!') . '\');';
echo 'location.href = \'iframe_biblio_rel.php?biblioID=' . $bid . '\';';
echo '</script>';
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
// database list
$biblio_relation_q = $dbs->query("SELECT b2.title, b2.edition, b2.publish_year, ba.rel_biblio_id FROM biblio_relation AS ba\n LEFT JOIN biblio AS b2 ON ba.rel_biblio_id=b2.biblio_id\n WHERE ba.biblio_id={$biblioID} ORDER BY rel_type ASC");
$row = 1;
while (isset($biblio_relation_q->num_rows) && ($biblio_relation_d = $biblio_relation_q->fetch_assoc())) {
// alternate the row color
$row_class = $row % 2 == 0 ? 'alterCell' : 'alterCell2';
