'.__('You are not authorized to view this section').''); } $in_pop_up = false; // check if we are inside pop-up window if (isset($_GET['inPopUp'])) { $in_pop_up = true; } /* RECORD OPERATION */ if (isset($_POST['saveData']) AND $can_read AND $can_write) { $itemCode = trim(strip_tags($_POST['itemCode'])); if (empty($itemCode)) { utility::jsAlert(__('Item Code can\'t be empty!')); exit(); } else { // biblio title $title = trim($_POST['biblioTitle']); $data['biblio_id'] = $_POST['biblioID']; $data['item_code'] = $dbs->escape_string($itemCode); $data['call_number'] = trim($dbs->escape_string($_POST['callNumber'])); // check inventory code $inventoryCode = trim($_POST['inventoryCode']); if ($inventoryCode) { $data['inventory_code'] = $inventoryCode; } else { $data['inventory_code'] = 'literal{NULL}'; } $data['location_id'] = $_POST['locationID']; $data['site'] = trim($dbs->escape_string(strip_tags($_POST['itemSite']))); $data['coll_type_id'] = intval($_POST['collTypeID']); $data['item_status_id'] = $dbs->escape_string($_POST['itemStatusID']); $data['source'] = $_POST['source']; $data['order_no'] = trim($dbs->escape_string(strip_tags($_POST['orderNo']))); $data['order_date'] = $_POST['ordDate']; $data['received_date'] = $_POST['recvDate']; $data['supplier_id'] = $_POST['supplierID']; $data['invoice'] = $_POST['invoice']; $data['invoice_date'] = $_POST['invcDate']; $data['price_currency'] = trim($dbs->escape_string(strip_tags($_POST['priceCurrency']))); 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 = (integer)$_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 ''; echo ''; } else { echo ''; } } else { utility::jsAlert(__('Item Data FAILED to Save. Please Contact System Administrator')."\nDEBUG : ".$sql_op->error); } exit(); } else { /* INSERT RECORD MODE */ // insert the data $insert = $sql_op->insert('item', $data); if ($insert) { // write log utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'].' insert item data ('.$data['item_code'].') with title ('.$title.')'); utility::jsAlert(__('New Item Data Successfully Saved')); if ($in_pop_up) { echo ''; echo ''; } else { echo ''; } } else { utility::jsAlert(__('Item Data FAILED to Save. Please Contact System Administrator')."\nDEBUG : ".$sql_op->error); } exit(); } } exit(); } else if (isset($_POST['itemID']) AND !empty($_POST['itemID']) AND isset($_POST['itemAction'])) { if (!($can_read AND $can_write)) { die(); } /* DATA DELETION PROCESS */ // create sql op object $sql_op = new simbio_dbop($dbs); $failed_array = array(); $error_num = 0; $still_on_loan = array(); if (!is_array($_POST['itemID'])) { // make an array $_POST['itemID'] = array((integer)$_POST['itemID']); } // loop array foreach ($_POST['itemID'] as $itemID) { $itemID = (integer)$itemID; // check if the item still on loan $loan_q = $dbs->query('SELECT i.item_code, b.title, COUNT(l.loan_id) FROM item AS i LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id LEFT JOIN loan AS l ON (i.item_code=l.item_code AND l.is_lent=1 AND l.is_return=0) WHERE i.item_id='.$itemID.' GROUP BY i.item_code'); $loan_d = $loan_q->fetch_row(); // if there is no loan if ($loan_d[2] < 1) { if (!$sql_op->delete('item', 'item_id='.$itemID)) { $error_num++; } else { // write log utility::writeLogs($dbs, 'staff', $_SESSION['uid'], 'bibliography', $_SESSION['realname'].' DELETE item data ('.$loan_d[0].') with title ('.$loan_d[1].')'); } } else { $still_on_loan[] = $loan_d[0].' - '.$loan_d[1]; $error_num++; } } if ($still_on_loan) { $items = ''; foreach ($still_on_loan as $item) { $items .= $item."\n"; } utility::jsAlert(__('Item data can not be deleted because still on hold by members')." : \n".$items); echo ''; exit(); } // error alerting if ($error_num == 0) { utility::jsAlert(__('Item succesfully removed!')); echo ''; } else { utility::jsAlert(__('Item FAILED to removed!')); echo ''; } exit(); } /* RECORD OPERATION END */ if (!$in_pop_up) { /* search form */ ?>
'.__('You are not authorized to view this section').''); } /* RECORD FORM */ // try query $itemID = (integer)isset($_POST['itemID'])?$_POST['itemID']:0; $rec_q = $dbs->query('SELECT item.*, b.biblio_id, b.title, s.supplier_name FROM item LEFT JOIN biblio AS b ON item.biblio_id=b.biblio_id LEFT JOIN mst_supplier AS s ON item.supplier_id=s.supplier_id WHERE item_id='.$itemID); $rec_d = $rec_q->fetch_assoc(); // create new instance $form = new simbio_form_table_AJAX('mainForm', $_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'], 'post'); $form->submit_button_attr = 'name="saveData" value="'.__('Save').'" class="btn btn-default"'; // form table attributes $form->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $form->table_header_attr = 'class="alterCell" style="font-weight: bold;"'; $form->table_content_attr = 'class="alterCell2"'; // edit mode flag set if ($rec_q->num_rows > 0) { $form->edit_mode = true; // record ID for delete process if (!$in_pop_up) { $form->record_id = $itemID; } else { $form->addHidden('updateRecordID', $itemID); $form->back_button = false; } // form record title $form->record_title = $rec_d['title']; // submit button attribute $form->submit_button_attr = 'name="saveData" value="'.__('Update').'" class="btn btn-default"'; // default biblio title and biblio ID $b_title = $rec_d['title']; $b_id = $rec_d['biblio_id']; if (trim($rec_d['call_number']) == '') { $biblio_q = $dbs->query('SELECT call_number FROM biblio WHERE biblio_id='.$rec_d['biblio_id']); $biblio_d = $biblio_q->fetch_assoc(); $rec_d['call_number'] = $biblio_d['call_number']; } } else { // get biblio title and biblio ID from database if we are not on edit mode $biblioID = 0; if (isset($_GET['biblioID'])) { $biblioID = (integer)$_GET['biblioID']; } $biblio_q = $dbs->query('SELECT biblio_id, title, call_number FROM biblio WHERE biblio_id='.$biblioID); $biblio_d = $biblio_q->fetch_assoc(); $b_title = $biblio_d['title']; $b_id = $biblio_d['biblio_id']; $def_call_number = $biblio_d['call_number']; } /* Form Element(s) */ // title if (!$in_pop_up) { $str_input = $b_title; $str_input .= ''; } else { $str_input = $b_title; } $form->addAnything(__('Title'), $str_input); $form->addHidden('biblioTitle', $b_title); $form->addHidden('biblioID', $b_id); // item code $str_input = simbio_form_element::textField('text', 'itemCode', $rec_d['item_code'], 'onblur="ajaxCheckID(\''.SWB.'admin/AJAX_check_id.php\', \'item\', \'item_code\', \'msgBox\', \'itemCode\')" style="width: 40%;"'); $str_input .= ' '; $form->addAnything(__('Item Code'), $str_input); // call number $form->addTextField('text', 'callNumber', __('Call Number'), isset($rec_d['call_number'])?$rec_d['call_number']:$def_call_number, 'style="width: 40%;"'); // inventory code $form->addTextField('text', 'inventoryCode', __('Inventory Code'), $rec_d['inventory_code'], 'style="width: 100%;"'); // item location // get location data related to this record from database $location_q = $dbs->query("SELECT location_id, location_name FROM mst_location"); $location_options = array(); while ($location_d = $location_q->fetch_row()) { $location_options[] = array($location_d[0], $location_d[1]); } $form->addSelectList('locationID', __('Location'), $location_options, $rec_d['location_id']); // item site $form->addTextField('text', 'itemSite', __('Shelf Location'), $rec_d['site'], 'style="width: 40%;"'); // collection type // get collection type data related to this record from database $coll_type_q = $dbs->query("SELECT coll_type_id, coll_type_name FROM mst_coll_type"); $coll_type_options = array(); while ($coll_type_d = $coll_type_q->fetch_row()) { $coll_type_options[] = array($coll_type_d[0], $coll_type_d[1]); } $form->addSelectList('collTypeID', __('Collection Type'), $coll_type_options, $rec_d['coll_type_id']); // item status // get item status data from database $item_status_q = $dbs->query("SELECT item_status_id, item_status_name FROM mst_item_status"); $item_status_options[] = array('0', __('Available')); while ($item_status_d = $item_status_q->fetch_row()) { $item_status_options[] = array($item_status_d[0], $item_status_d[1]); } $form->addSelectList('itemStatusID', __('Item Status'), $item_status_options, $rec_d['item_status_id']); // order number $form->addTextField('text', 'orderNo', __('Order Number'), $rec_d['order_no'], 'style="width: 40%;"'); // order date $form->addDateField('ordDate', __('Order Date'), $rec_d['order_date']?$rec_d['order_date']:date('Y-m-d')); // received date $form->addDateField('recvDate', __('Receiving Date'), $rec_d['received_date']?$rec_d['received_date']:date('Y-m-d')); // item supplier // get item status data from database $supplier_q = $dbs->query("SELECT supplier_id, supplier_name FROM mst_supplier"); $supplier_options[] = array('0', __('Not Applicable')); while ($supplier_d = $supplier_q->fetch_row()) { $supplier_options[] = array($supplier_d[0], $supplier_d[1]); } $form->addSelectList('supplierID', __('Supplier'), $supplier_options, $rec_d['supplier_id']); // item source $source_options[] = array('1', __('Buy')); $source_options[] = array('2', __('Prize/Grant')); $form->addRadio('source', __('Source'), $source_options, !empty($rec_d['source'])?$rec_d['source']:'1'); // item invoice $form->addTextField('text', 'invoice', __('Invoice'), $rec_d['invoice'], 'style="width: 100%;"'); // invoice date $form->addDateField('invcDate', __('Invoice Date'), $rec_d['invoice_date']?$rec_d['invoice_date']:date('Y-m-d')); // price $str_input = simbio_form_element::textField('text', 'price', !empty($rec_d['price'])?$rec_d['price']:'0', 'style="width: 40%;"'); $str_input .= simbio_form_element::selectList('priceCurrency', $sysconf['currencies'], $rec_d['price_currency']);; $form->addAnything(__('Price'), $str_input); // edit mode messagge if ($form->edit_mode) { echo '