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';