exit;
} else {
$data['name'] = $dbs->escape_string($server_name);
$data['uri'] = $dbs->escape_string($server_uri);
$data['server_type'] = $dbs->escape_string($_POST['serverType']);
$data['input_date'] = date('Y-m-d H:i:s');
$data['last_update'] = date('Y-m-d H:i:s');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_servers', $data, 'server_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Server Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Server Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
// insert the data
if ($sql_op->insert('mst_servers', $data)) {
utility::jsAlert(__('New Server Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Server Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
utility::jsAlert(__('Group name can\'t be empty'));
//mfc
} else {
$data['group_name'] = $dbs->escape_string($groupName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('user_group', $data, 'group_id=' . $updateRecordID);
if ($update) {
$dbs->query('DELETE FROM group_access WHERE group_id=' . $updateRecordID);
// set group privileges
if (isset($_POST['read'])) {
foreach ($_POST['read'] as $module) {
// check write privileges
$is_write = 0;
if (isset($_POST['write'])) {
foreach ($_POST['write'] as $module_write) {
if ($module_write == $module) {
$is_write = 1;
}
}
}
$dbs->query("INSERT INTO group_access VALUES ({$updateRecordID}, {$module}, 1, {$is_write})");
}
// password confirmation
if ($mpasswd1 and $mpasswd2 and $mpasswd1 === $mpasswd2) {
$data['mpasswd'] = 'literal{MD5(\'' . $mpasswd2 . '\')}';
}
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
$old_member_ID = $updateRecordID;
// update the data
$update = $sql_op->update('member', $data, "member_id='{$updateRecordID}'");
if ($update) {
// update other tables contain this member ID
@$dbs->query('UPDATE loan SET member_id=\'' . $data['member_id'] . '\' WHERE member_id=\'' . $old_member_ID . '\'');
@$dbs->query('UPDATE fines SET member_id=\'' . $data['member_id'] . '\' WHERE member_id=\'' . $old_member_ID . '\'');
utility::jsAlert(__('Member Data Successfully Updated'));
// upload status alert
if (isset($upload_status)) {
if ($upload_status == UPLOAD_SUCCESS) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'membership', $_SESSION['realname'] . ' upload image file ' . $upload->new_filename);
utility::jsAlert(__('Image Uploaded Successfully'));
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'membership', 'ERROR : ' . $_SESSION['realname'] . ' FAILED TO upload image file ' . $upload->new_filename . ', with error (' . $upload->error . ')');
utility::jsAlert(__('Image FAILED to upload'));
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', 'ERROR : ' . $_SESSION['realname'] . ' FAILED TO upload image file ' . $image_upload->new_filename . ', with error (' . $image_upload->error . ')');
utility::jsAlert(__('Image Uploaded Successfully'));
}
}
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update data
$update = $sql_op->update('biblio', $data, 'biblio_id=' . $updateRecordID);
// send an alert
if ($update) {
// update custom data
if (isset($custom_data)) {
// check if custom data for this record exists
$_sql_check_custom_q = sprintf('SELECT biblio_id FROM biblio_custom WHERE biblio_id=%d', $updateRecordID);
$check_custom_q = $dbs->query($_sql_check_custom_q);
if ($check_custom_q->num_rows) {
$update2 = @$sql_op->update('biblio_custom', $custom_data, 'biblio_id=' . $updateRecordID);
} else {
$custom_data['biblio_id'] = $updateRecordID;
@$sql_op->insert('biblio_custom', $custom_data);
}
}
if ($sysconf['bibliography_update_notification']) {
}
}
}
}
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_item_status', $data, 'item_status_id=\'' . $updateRecordID . '\'');
if ($update) {
utility::jsAlert(__('Item Status Data Successfully Updated'));
// update item status ID in item table to keep data integrity
$sql_op->update('item', array('item_status_id' => $data['item_status_id']), 'item_status_id=\'' . $updateRecordID . '\'');
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Item Status Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_item_status', $data);
if ($insert) {
utility::jsAlert(__('New Item Status Data Successfully Saved'));
//mfc
exit;
} else {
$data['place_name'] = $dbs->escape_string($placeName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_place', $data, 'place_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Place Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Place Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_place', $data);
if ($insert) {
utility::jsAlert(__('New Place Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
} else {
$data['author_name'] = $dbs->escape_string($authorName);
$data['authority_type'] = trim($dbs->escape_string(strip_tags($_POST['authorityType'])));
$data['auth_list'] = trim($dbs->escape_string(strip_tags($_POST['authList'])));
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_author', $data, 'author_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(lang_mod_masterfile_author_alert_update_ok);
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(lang_mod_masterfile_author_alert_update_fail . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_author', $data);
if ($insert) {
utility::jsAlert(lang_mod_masterfile_author_alert_new_add_ok);
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
$data['biblio_id'] = $biblioID;
$data['date_start'] = $dateStart;
// $data['date_end'] = $dateEnd;
$data['period'] = $period;
$data['notes'] = trim($_POST['notes']) == '' ? 'literal{NULL}' : trim($dbs->escape_string(strip_tags($_POST['notes'])));
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('serial', $data, 'serial_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Subscription Data Successfully Updated'));
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'serial_control', $_SESSION['realname'] . ' update subcription(' . $updateRecordID . ') ' . $period);
} else {
utility::jsAlert(__('Subscription Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
echo '<script type="text/javascript">self.location.href = \'' . MODULES_WEB_ROOT_DIR . 'serial_control/subscription.php?biblioID=' . $biblioID . '\';</script>';
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('serial', $data);
$serial_id = $sql_op->insert_id;
if ($insert) {
$exemplar = (int) $_POST['exemplar'];
$data['member_periode'] = $_POST['memberPeriode'];
$data['reborrow_limit'] = $_POST['reborrowLimit'];
$data['fine_each_day'] = $_POST['fineEachDay'];
$data['grace_periode'] = $_POST['gracePeriode'];
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_member_type', $data, 'member_type_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Member Type Successfully Updated'));
// update all member expire date
@$dbs->query('UPDATE member AS m SET expire_date=DATE_ADD(register_date,INTERVAL ' . $data['member_periode'] . ' DAY)
WHERE member_type_id=' . $updateRecordID);
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') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_member_type', $data)) {
utility::jsAlert(__('New Member Type Successfully Saved'));
exit;
} else {
$data['location_id'] = $dbs->escape_string($locationID);
$data['location_name'] = $dbs->escape_string($locationName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_location', $data, 'location_id=\'' . $updateRecordID . '\'');
if ($update) {
utility::jsAlert(__('Location Data Successfully Updated'));
// update location ID in item table to keep data integrity
$sql_op->update('item', array('location_id' => $data['location_id']), 'location_id=\'' . $updateRecordID . '\'');
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Location Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_location', $data);
if ($insert) {
utility::jsAlert(__('New Location Data Successfully Saved'));
}
if ($relatedterm === 'UF') {
$_data['rt_id'] = 'U';
}
if ($relatedterm === 'RT') {
$_data['rt_id'] = 'RT';
}
if ($relatedterm === 'BT') {
$_data['rt_id'] = 'NT';
}
if ($relatedterm === 'NT') {
$_data['rt_id'] = 'BT';
}
// update mode
if (isset($_POST['saveData'])) {
$update = $sql_op->update('mst_voc_ctrl', $data, 'vocabolary_id=' . $vocID);
if ($update) {
$alert_update = '<script type="text/javascript">';
$alert_update .= 'alert(\'' . __('Vocabulary update!') . '\');';
$alert_update .= 'parent.setIframeContent(\'itemIframe\', \'' . MWB . 'master_file/iframe_vocabolary_control.php?itemID=' . $itemID . '\');';
$alert_update .= 'top.jQuery.colorbox.close();';
$alert_update .= '</script>';
echo $alert_update;
} else {
utility::jsAlert(__('Subject FAILED to Add. Please Contact System Administrator') . "\n" . $sql_op->error);
}
} else {
// checking if already added
$check_vc = $dbs->query('SELECT count(topic_id) FROM mst_voc_ctrl WHERE topic_id=' . $data['topic_id'] . ' AND related_topic_id=' . $data['related_topic_id']);
$check_dc = $check_vc->fetch_row();
if ($check_dc[0] > 0) {
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', 'ERROR : ' . $_SESSION['realname'] . ' FAILED TO upload label image file ' . $image_upload->new_filename . ', with error (' . $image_upload->error . ')');
utility::jsAlert('FAILED to upload label image! Please see System Log for more detailed information');
}
}
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_label', $data, 'label_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Label Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Label Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_label', $data)) {
utility::jsAlert(__('New Label Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Label Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
utility::jsAlert(__('Collection type name can\'t be empty'));
exit;
} else {
$data['coll_type_name'] = $dbs->escape_string($collTypeName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_coll_type', $data, 'coll_type_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Colllection Type Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Colllection Type Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_coll_type', $data);
if ($insert) {
utility::jsAlert(__('New Colllection Type Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
} else {
$data[$type . '_type'] = $dbs->escape_string($name);
$data['code'] = $dbs->escape_string($code);
$data['code2'] = $dbs->escape_string($code2);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_' . $type . '_type', $data, 'id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_' . $type . '_type', $data)) {
utility::jsAlert(__('New Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
utility::jsAlert(__('Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
$holDesc = trim($dbs->escape_string(strip_tags($_POST['holDesc'])));
if (empty($holDesc)) {
utility::jsAlert('Holiday description can\'t be empty!');
exit;
} else {
$data['holiday_date'] = trim(preg_replace('@\\s[0-9]{2}:[0-9]{2}:[0-9]{2}$@i', '', $_POST['holDate']));
$holiday_start_date = $data['holiday_date'];
$data['holiday_dayname'] = date('D', strtotime($data['holiday_date']));
$data['description'] = $holDesc;
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
if ($sql_op->update('holiday', $data, 'holiday_id=' . $updateRecordID)) {
utility::jsAlert(__('Holiday Data Successfully updated'));
// update holiday_dayname session
$_SESSION['holiday_date'][$data['holiday_date']] = $data['holiday_date'];
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(parent.$.ajaxHistory[0].url);</script>';
exit;
} else {
utility::jsAlert(__('Holiday FAILED to update. Please Contact System Administrator') . "\n" . $sql_op->error);
}
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('holiday', $data)) {
utility::jsAlert(__('New Holiday Successfully Saved'));
// update holiday_dayname session
$_SESSION['holiday_date'][$data['holiday_date']] = $data['holiday_date'];
if (!$data['price_currency']) {
$data['price_currency'] = 'literal{NULL}';
}
$data['price'] = preg_replace('@[.,\\-a-z ]@i', '', strip_tags($_POST['price']));
$data['input_date'] = date('Y-m-d H:i:s');
$data['last_update'] = date('Y-m-d H:i:s');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('item', $data, "item_id=" . $updateRecordID);
if ($update) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'] . ' update item data (' . $data['item_code'] . ') with title (' . $title . ')');
if ($sysconf['bibliography_item_update_notification']) {
utility::jsAlert(__('Item Data Successfully Updated'));
}
if ($in_pop_up) {
echo '<script type="text/javascript">top.setIframeContent(\'itemIframe\', \'' . MODULES_WEB_ROOT_DIR . 'bibliography/iframe_item_list.php?biblioID=' . $data['biblio_id'] . '\');</script>';
echo '<script type="text/javascript">top.closeHTMLpop();</script>';
} else {
echo '<script type="text/javascript">parent.$(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
}
} else {
utility::jsAlert(__('Item Data FAILED to Save. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
$data['frequency'] = $dbs->escape_string($frequency);
$data['language_prefix'] = $dbs->escape_string(strip_tags(trim($_POST['languagePrefix'])));
$data['time_increment'] = $dbs->escape_string(strip_tags(trim($_POST['timeIncrement'])));
$data['time_unit'] = $dbs->escape_string(strip_tags(trim($_POST['timeUnit'])));
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_frequency', $data, 'frequency_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Frequency Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Frequency Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_frequency', $data)) {
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);
$data['phone'] = trim($dbs->escape_string(strip_tags($_POST['supplierPhone'])));
$data['fax'] = trim($dbs->escape_string(strip_tags($_POST['supplierFax'])));
$data['e_mail'] = trim($dbs->escape_string(strip_tags($_POST['supplierEmail'])));
$data['account'] = trim($dbs->escape_string(strip_tags($_POST['supplierAccount'])));
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_supplier', $data, 'supplier_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Supplier Data Successfully Updated'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Supplier Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_supplier', $data);
if ($insert) {
utility::jsAlert(__('New Supplier Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
$data['loan_periode'] = trim($_POST['loanPeriode']);
$data['reborrow_limit'] = trim($_POST['reborrowLimit']);
$data['fine_each_day'] = trim($_POST['fineEachDay']);
$data['grace_periode'] = trim($_POST['gracePeriode']);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_loan_rules', $data, 'loan_rules_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Loan Rules Successfully Updated'));
echo '<script language="Javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Loan Rules FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
$insert = $sql_op->insert('mst_loan_rules', $data);
if ($insert) {
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);
} else {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', 'ERROR : ' . $_SESSION['realname'] . ' FAILED TO upload image file ' . $image_upload->new_filename . ', with error (' . $image_upload->error . ')');
utility::jsAlert(__('Image Uploaded Successfully'));
}
}
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('biblio', $data, 'biblio_id=' . $updateRecordID);
// send an alert
if ($update) {
utility::jsAlert(__('Bibliography Data Successfully Updated'));
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'] . ' update bibliographic data (' . $data['title'] . ') with biblio_id (' . $_POST['itemID'] . ')');
// close window OR redirect main page
if ($in_pop_up) {
$itemCollID = (int) $_POST['itemCollID'];
echo '<script type="text/javascript">parent.opener.setContent(\'mainContent\', parent.opener.getLatestAJAXurl(), \'post\', \'' . ($itemCollID ? 'itemID=' . $itemCollID . '&detail=true' : '') . '\');</script>';
echo '<script type="text/javascript">parent.window.close();</script>';
} else {
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'get\');</script>';
}
} else {
utility::jsAlert(__('Bibliography Data FAILED to Updated. Please Contact System Administrator') . "\n" . $sql_op->error);
exit;
} else {
$data['language_id'] = $dbs->escape_string($langID);
$data['language_name'] = $dbs->escape_string($langName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_language', $data, 'language_id=\'' . $updateRecordID . '\'');
if ($update) {
utility::jsAlert(__('Language Data Successfully Updated'));
// update language ID in biblio table to keep data integrity
$sql_op->update('biblio', array('language_id' => $data['language_id']), 'language_id=\'' . $updateRecordID . '\'');
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Language Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_language', $data);
if ($insert) {
utility::jsAlert(__('New Language Data Successfully Saved'));
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'] . '\');';
$alert_save .= 'top.jQuery.colorbox.close();';
$alert_save .= '</script>';
echo $alert_save;
$data['access_type'] = trim($_POST['accessType']);
$data['access_limit'] = 'literal{NULL}';
// parsing member type data
if ($data['access_type'] == 'public') {
$groups = '';
if (isset($_POST['accLimit']) and count($_POST['accLimit']) > 0) {
$groups = serialize($_POST['accLimit']);
} else {
$groups = 'literal{NULL}';
}
$data['access_limit'] = trim($groups);
}
if (isset($_POST['updateFileID'])) {
$fileID = (int) $_POST['updateFileID'];
// file biblio access update
$update1 = $sql_op->update('biblio_attachment', array('access_type' => $data['access_type'], 'access_limit' => $data['access_limit']), 'biblio_id=' . $updateBiblioID . ' AND file_id=' . $fileID);
// file description update
$update2 = $sql_op->update('files', array('file_title' => $title, 'file_url' => $url, 'file_desc' => $dbs->escape_string(trim($_POST['fileDesc']))), 'file_id=' . $fileID);
if ($update1) {
echo '<script type="text/javascript">';
echo 'alert(\'' . __('File Attachment data updated!') . '\');';
echo 'parent.setIframeContent(\'attachIframe\', \'' . MODULES_WEB_ROOT_DIR . 'bibliography/iframe_attach.php?biblioID=' . $updateBiblioID . '\');';
echo '</script>';
} else {
utility::jsAlert('' . __('File Attachment data FAILED to update!') . '' . "\n" . $sql_op->error);
}
} else {
if ($sql_op->insert('biblio_attachment', $data)) {
echo '<script type="text/javascript">';
echo 'alert(\'' . __('File Attachment uploaded succesfully!') . '\');';
echo 'parent.setIframeContent(\'attachIframe\', \'' . MODULES_WEB_ROOT_DIR . 'bibliography/iframe_attach.php?biblioID=' . $data['biblio_id'] . '\');';
utility::jsAlert('' . __('Value of Credit can not be higher that Debet Value') . '');
} else {
$data['member_id'] = $_SESSION['memberID'];
$data['fines_date'] = trim($dbs->escape_string(strip_tags($_POST['finesDate'])));
$data['description'] = trim($dbs->escape_string(strip_tags($_POST['finesDesc'])));
$data['debet'] = $debet;
$data['credit'] = $credit;
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('fines', $data, 'fines_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Fines Data Successfully Updated'));
} else {
utility::jsAlert(__('Fines Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('fines', $data);
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 {
$data['content_title'] = $dbs->escape_string(strip_tags(trim($contentTitle)));
$data['content_path'] = strtolower($dbs->escape_string(strip_tags(trim($contentPath))));
$data['content_desc'] = $dbs->escape_string(trim($_POST['contentDesc']));
$data['input_date'] = date('Y-m-d H:i:s');
$data['last_update'] = date('Y-m-d H:i:s');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('content', $data, 'content_id=' . $updateRecordID);
if ($update) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['content_title'] . ' update content data (' . $data['content_title'] . ') with contentname (' . $data['contentname'] . ')');
utility::jsAlert(__('Content data updated'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Content data FAILED to update!') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('content', $data)) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' add new content (' . $data['content_title'] . ') with contentname (' . $data['contentname'] . ')');
}
if ($passwd1 and $passwd2 and $passwd1 === $passwd2) {
$data['passwd'] = 'literal{MD5(\'' . $passwd2 . '\')}';
}
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('user', $data, 'user_id=' . $updateRecordID);
if ($update) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' update user data (' . $data['realname'] . ') with username (' . $data['username'] . ')');
utility::jsAlert(__('User Data Successfully Updated'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('User Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('user', $data)) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' add new user (' . $data['realname'] . ') with username (' . $data['username'] . ')');
} else {
$data['topic'] = $dbs->escape_string($topic);
$data['topic_type'] = trim($dbs->escape_string($_POST['subjectType']));
$data['auth_list'] = trim($dbs->escape_string(strip_tags($_POST['authList'])));
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_topic', $data, 'topic_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Subject Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('Subject Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_topic', $data);
if ($insert) {
utility::jsAlert(__('New Subject Data Successfully Saved'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(\'' . $_SERVER['PHP_SELF'] . '\');</script>';
} else {
$data['module_path'] = $dbs->escape_string($modulePath);
// check for module path existance
if (!file_exists(MODULES_BASE_DIR . $data['module_path'] . DIRECTORY_SEPARATOR)) {
utility::jsAlert('Modules path doesn\'t exists! Please check again in module base directory');
exit;
}
$data['module_name'] = $dbs->escape_string($moduleName);
$data['module_desc'] = trim($dbs->escape_string(strip_tags($_POST['moduleDesc'])));
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_module', $data, 'module_id=' . $updateRecordID);
if ($update) {
// write log
utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'system', $_SESSION['realname'] . ' update module data (' . $moduleName . ') with path (' . $modulePath . ')');
utility::jsAlert(__('Module Data Successfully Updated'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('Module Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_module', $data)) {
// insert module privileges for administrator
$module_id = $sql_op->insert_id;
exit;
} else {
$data['gmd_code'] = $dbs->escape_string($gmdCode);
$data['gmd_name'] = $dbs->escape_string($gmdName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = $dbs->escape_string(trim($_POST['updateRecordID']));
// update the data
$update = $sql_op->update('mst_gmd', $data, 'gmd_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('GMD Data Successfully Updated'));
echo '<script type="text/javascript">parent.jQuery(\'#mainContent\').simbioAJAX(parent.jQuery.ajaxHistory[0].url);</script>';
} else {
utility::jsAlert(__('GMD Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
if ($sql_op->insert('mst_gmd', $data)) {
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);
//mfc
exit;
} else {
$data['publisher_name'] = $dbs->escape_string($publisherName);
$data['input_date'] = date('Y-m-d');
$data['last_update'] = date('Y-m-d');
// create sql op object
$sql_op = new simbio_dbop($dbs);
if (isset($_POST['updateRecordID'])) {
/* UPDATE RECORD MODE */
// remove input date
unset($data['input_date']);
// filter update record ID
$updateRecordID = (int) $_POST['updateRecordID'];
// update the data
$update = $sql_op->update('mst_publisher', $data, 'publisher_id=' . $updateRecordID);
if ($update) {
utility::jsAlert(__('Publisher Data Successfully Updated'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', parent.getPreviousAJAXurl(), \'post\');</script>';
} else {
utility::jsAlert(__('PUBLISHER Data FAILED to Updated. Please Contact System Administrator') . "\nDEBUG : " . $sql_op->error);
}
exit;
} else {
/* INSERT RECORD MODE */
// insert the data
$insert = $sql_op->insert('mst_publisher', $data);
if ($insert) {
utility::jsAlert(__('New Publisher Data Successfully Saved'));
echo '<script type="text/javascript">parent.setContent(\'mainContent\', \'' . $_SERVER['PHP_SELF'] . '\', \'post\');</script>';
} else {
