PHP simbio_dbop::update方法代码示例

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