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 {