var confirmBox = confirm('Are you sure to remove selected item?' + "\n" + 'Once deleted, it can\'t be restored!');
if (confirmBox) {
// set hidden element value
document.hiddenActionForm.bid.value = int_biblio_id;
document.hiddenActionForm.remove.value = int_item_id;
// submit form
document.hiddenActionForm.submit();
}
}
</script>
<?php
/* main content */
if (isset($_POST['remove'])) {
$id = (int) $_POST['remove'];
$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 '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Subject Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
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) {
</script>
<?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
</script>
<?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
$author_cache = array();
$subject_cache = array();
$input_date = date('Y-m-d H:i:s');
// record counter
$r = 0;
foreach ($_POST['p2precord'] as $id) {
// construct full XML URI
$detail_uri = $p2pserver . "/index.php?p=show_detail&inXML=true&id=" . $id;
// parse XML
$data = modsXMLsenayan($detail_uri, 'uri');
// get record detail
$record = $data['records'][0];
// insert record to database
if ($record) {
// create dbop object
$sql_op = new simbio_dbop($dbs);
// escape all string value
foreach ($record as $field => $content) {
if (is_string($content)) {
$biblio[$field] = $dbs->escape_string(trim($content));
}
}
// gmd
$biblio['gmd_id'] = utility::getID($dbs, 'mst_gmd', 'gmd_id', 'gmd_name', $record['gmd'], $gmd_cache);
unset($biblio['gmd']);
// publisher
$biblio['publisher_id'] = utility::getID($dbs, 'mst_publisher', 'publisher_id', 'publisher_name', $record['publisher'], $publ_cache);
unset($biblio['publisher']);
// publish place
$biblio['publish_place_id'] = utility::getID($dbs, 'mst_place', 'place_id', 'place_name', $record['publish_place'], $place_cache);
unset($biblio['publish_place']);
utility::jsAlert(__('New Language Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Language Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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) {
}
// check for file ID in url
$fileID = 0;
if (isset($_GET['fileID']) and $_GET['fileID']) {
$fileID = (int) $_GET['fileID'];
}
// start the output buffer
ob_start();
/* main content */
// biblio topic save proccess
if (isset($_POST['upload']) and trim(strip_tags($_POST['fileTitle'])) != '') {
$uploaded_file_id = 0;
$title = trim(strip_tags($_POST['fileTitle']));
$url = trim(strip_tags($_POST['fileURL']));
// create new sql op object
$sql_op = new simbio_dbop($dbs);
// FILE UPLOADING
if (isset($_FILES['file2attach']) and $_FILES['file2attach']['size']) {
// create upload object
$file_dir = trim($_POST['fileDir']);
$file_upload = new simbio_file_upload();
$file_upload->setAllowableFormat($sysconf['allowed_file_att']);
$file_upload->setMaxSize($sysconf['max_upload'] * 1024);
$file_upload->setUploadDir(REPO_BASE_DIR . DIRECTORY_SEPARATOR . str_replace('/', DIRECTORY_SEPARATOR, $file_dir));
$file_upload_status = $file_upload->doUpload('file2attach');
if ($file_upload_status === UPLOAD_SUCCESS) {
$file_ext = substr($file_upload->new_filename, strrpos($file_upload->new_filename, '.') + 1);
$fdata['uploader_id'] = $_SESSION['uid'];
$fdata['file_title'] = $dbs->escape_string($title);
$fdata['file_name'] = $dbs->escape_string($file_upload->new_filename);
$fdata['file_url'] = $dbs->escape_string($url);
$_q = $dbs->query('SELECT topic_id FROM mst_topic WHERE topic=\'' . $str_subject . '\'');
if ($_q->num_rows > 0) {
$_d = $_q->fetch_row();
// return the subject/topic ID
return $_d[0];
}
return false;
}
// start the output buffer
ob_start();
/* main content */
// biblio topic save proccess
if (isset($_POST['save']) and (isset($_POST['topicID']) or trim($_POST['search_str']))) {
$subject = trim($dbs->escape_string(strip_tags($_POST['search_str'])));
// create new sql op object
$sql_op = new simbio_dbop($dbs);
// check if biblioID POST var exists
if (isset($_POST['biblioID']) and !empty($_POST['biblioID'])) {
$data['biblio_id'] = (int) $_POST['biblioID'];
// check if the topic select list is empty or not
if (!empty($_POST['topicID'])) {
$data['topic_id'] = $_POST['topicID'];
} else {
if ($subject and empty($_POST['topicID'])) {
// check subject
$subject_id = checkSubject($subject);
if ($subject_id !== false) {
$data['topic_id'] = $subject_id;
} else {
// adding new topic
$topic_data['topic'] = $subject;
require SB . 'admin/default/session_check.inc.php';
require SIMBIO . 'simbio_GUI/table/simbio_table.inc.php';
require SIMBIO . 'simbio_GUI/form_maker/simbio_form_table_AJAX.inc.php';
require SIMBIO . 'simbio_GUI/paging/simbio_paging.inc.php';
require SIMBIO . 'simbio_DB/datagrid/simbio_dbgrid.inc.php';
require SIMBIO . 'simbio_DB/simbio_dbop.inc.php';
// privileges checking
$can_read = utility::havePrivilege('master_file', 'r');
$can_write = utility::havePrivilege('master_file', 'w');
// GET ID FROM URL
$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'] . '\');';
$_q = $dbs->query('SELECT author_id FROM mst_author WHERE author_name=\'' . $str_author_name . '\' AND authority_type=\'' . $str_author_type . '\'');
if ($_q->num_rows > 0) {
$_d = $_q->fetch_row();
// return the author ID
return $_d[0];
}
return false;
}
// start the output buffer
ob_start();
/* main content */
// biblio author save proccess
if (isset($_POST['save']) and (isset($_POST['authorID']) or trim($_POST['search_str']))) {
$author_name = trim($dbs->escape_string(strip_tags($_POST['search_str'])));
// create new sql op object
$sql_op = new simbio_dbop($dbs);
// check if biblioID POST var exists
if (isset($_POST['biblioID']) and !empty($_POST['biblioID'])) {
$data['biblio_id'] = intval($_POST['biblioID']);
// check if the author select list is empty or not
if (isset($_POST['authorID']) and !empty($_POST['authorID'])) {
$data['author_id'] = $_POST['authorID'];
} else {
if ($author_name and empty($_POST['authorID'])) {
// check author
$author_id = checkAuthor($author_name, $_POST['type']);
if ($author_id !== false) {
$data['author_id'] = $author_id;
} else {
// adding new author
$author_data['author_name'] = $author_name;
/**
* LDAP/Active directory login
*
* @return boolean
*/
protected function ldapLogin() {
global $ldap_configs;
if (!function_exists('ldap_connect')) {
$this->errors = 'LDAP library is not installed yet!';
return false;
}
// connect to Directory Server
$_ds = $ldap_configs['ldap_port']?ldap_connect($ldap_configs['ldap_server'], $ldap_configs['ldap_port']):ldap_connect($ldap_configs['ldap_server']);
// check LDAP options
if ($ldap_configs['ldap_options']) {
foreach ($ldap_configs['ldap_options'] as $_opt) {
@ldap_set_option($_ds, $_opt[0], $_opt[1]);
}
}
// LDAP Connection check
if (!$_ds) {
$this->errors = 'Failed to connect to LDAP server';
return false;
}
// LDAP binding
// for Active Directory Server login active line below
// $_bind = ldap_bind($_ds, ( $ldap_configs['ldap_suffix']?$this->username.'@'.$ldap_configs['ldap_suffix']:$this->username ), $this->password);
$_bind = @ldap_bind($_ds,
str_ireplace('#loginUserName', $this->username, $ldap_configs['ldap_bind_dn']),
$this->password);
if (!$_bind) {
$this->errors = 'Failed to bind to directory server!';
return false;
}
$_filter = str_ireplace('#loginUserName', $this->username, $ldap_configs['ldap_search_filter']);
// run query
$_search = @ldap_search($_ds, $ldap_configs['ldap_base_dn'], $_filter);
if (!$_search) {
$this->errors = 'LDAP search failed because of error!';
return false;
}
// get query entry
$_entries = @ldap_get_entries($_ds, $_search);
if ($_entries) {
$this->user_info['member_id'] = $_entries[0]['uid'][0];
// check member in database
$_check_q = $this->obj_db->query('SELECT m.member_id, m.member_name, m.inst_name,
m.member_email, m.expire_date, m.register_date, m.is_pending,
m.member_type_id, mt.member_type_name
FROM member AS m LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id
WHERE m.member_id=\''.$this->user_info['member_id'].'\'');
if ($_check_q->num_rows < 1) {
$_curr_date = date('Y-m-d H:i:s');
// insert member data to database
$this->user_info['member_id'] = $_entries[0]['uid'][0];
$this->user_info['member_name'] = $_entries[0]['cn'][0];
$this->user_info['gender'] = '1';
$this->user_info['inst_name'] = 'New registered member';
$this->user_info['member_email'] = $_entries[0]['mail'][0];
$this->user_info['expire_date'] = '0000-00-00';
$this->user_info['register_date'] = '0000-00-00';
$this->user_info['is_pending'] = '1';
$this->user_info['member_type_id'] = '1';
$this->user_info['input_date'] = $_curr_date;
$this->user_info['last_update'] = $_curr_date;
// include database operation library
require_once SIMBIO_BASE_DIR.'simbio_DB/simbio_dbop.inc.php';
$_dbop = new simbio_dbop($this->obj_db);
$_insert = $_dbop->insert('member', $this->user_info);
if (!$_insert) {
$this->errors = 'Member insertion error because of: '.$_dbop->error;
}
$this->user_info['member_type_name'] = 'None';
} else {
$this->user_info = $_check_q->fetch_assoc();
}
} else {
$this->errors = 'LDAP Record not found!';
return false;
}
// closing connection
ldap_close($_ds);
return true;
}
utility::jsAlert(__('New Supplier Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Supplier Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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) {
// check if there is any active stock take proccess
$stk_q = $dbs->query('SELECT * FROM stock_take WHERE is_active=1');
if ($stk_q->num_rows) {
echo '<div class="errorBox">' . __('There is already stock taking proccess running!') . '</div>';
} else {
// add new stock take
if (isset($_POST['saveData']) and empty($_POST['name'])) {
utility::jsAlert(__('Stock Take Name must be filled!'));
exit;
} else {
if (isset($_POST['saveData']) and !empty($_POST['name'])) {
$data['stock_take_name'] = trim($dbs->escape_string(strip_tags($_POST['name'])));
$data['start_date'] = date('Y-m-d H:i:s');
$data['init_user'] = $_SESSION['realname'];
$data['is_active'] = 1;
$sql_op = new simbio_dbop($dbs);
if ($sql_op->insert('stock_take', $data)) {
// get latest stock take id
$stock_take_id = $sql_op->insert_id;
// criteria
$criteria = ' WHERE item_id IS NOT NULL ';
// gmd
if ($_POST['gmdID'] != '0') {
$criteria .= ' AND b.gmd_id=' . intval($_POST['gmdID']) . ' ';
}
// collection type
if ($_POST['collTypeID'] != '0') {
$criteria .= ' AND i.coll_type_id=\'' . intval($_POST['collTypeID']) . '\' ';
}
// location
if ($_POST['location'] != '0') {
}
} else {
utility::jsAlert(__('Item Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
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;
$still_on_loan = array();
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');
utility::jsAlert(__('New Loan Rules Successfully Saved'));
echo '<script language="Javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Loan Rules FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
exit;
} else {
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
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) {
if ($insert) {
utility::jsAlert(__('New Fines Data Successfully Saved'));
} else {
utility::jsAlert(__('Fines Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
}
}
}
} else {
if ($_SESSION['uid'] == 1 && isset($_POST['itemID']) && !empty($_POST['itemID']) && isset($_POST['itemAction'])) {
// 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(lang_mod_masterfile_author_alert_new_add_ok);
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(lang_mod_masterfile_author_alert_add_fail . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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) {
@unlink(REPO_BASE_DIR . str_replace('/', DIRECTORY_SEPARATOR, $_SESSION['biblioAttach'][$idx]['file_dir']) . DIRECTORY_SEPARATOR . $_SESSION['biblioAttach'][$idx]['file_name']);
// 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
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . MODULES_WEB_ROOT_DIR . 'bibliography/index.php\', {method: \'post\', addData: \'itemID=' . $last_biblio_id . '&detail=true\'});</script>';
} else {
utility::jsAlert(__('Bibliography Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
if (isset($_POST['itemID']) and !empty($_POST['itemID']) and isset($_POST['itemAction'])) {
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;
$still_have_item = array();
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);
} else {
utility::jsAlert(__('User Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
}
}
exit;
} else {
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;
// 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 {
utility::jsAlert(__('New Item Status Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Item Status Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
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(__('New Module Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Module Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
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;
// 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 {
utility::jsAlert(__('Content data saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Content data FAILED to save!') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
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;
// 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 {
}
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '?mode=special\');</script>';
exit;
} else {
utility::jsAlert(__('Holiday FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
}
}
exit;
} else {
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;
// 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 {
}
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' add new group (' . $groupName . ')');
utility::jsAlert(__('New Group Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
utility::jsAlert(__('Group Data FAILED to Save. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
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 {
utility::jsAlert(__('New Frequency Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Frequency Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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) {
$mtype_d = $mtype_q->fetch_row();
$expire_date = simbio_date::getNextDate($mtype_d[0], $curr_date);
@$dbs->query('UPDATE member SET expire_date=\'' . $expire_date . '\' WHERE member_id=\'' . $memberID . '\'');
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'membership', $_SESSION['realname'] . ' extends membership for member (' . $mtype_d[1] . ') with ID (' . $memberID . ')');
$num_extended++;
}
header('Location: ' . MODULES_WEB_ROOT_DIR . 'membership/index.php?expire=true&numExtended=' . $num_extended);
exit;
} else {
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;
$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();
utility::jsAlert(__('New Place Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Place Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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(__('New GMD Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('GMD Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
}
}
exit;
} else {
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(__('New Member Type Successfully Saved'));
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Member Type Data FAILED to Save/Update. Please Contact System Administrator') . "\n" . $sql_op->error);
}
exit;
}
}
exit;
} else {
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) {
