?>
<fieldset class="menuBox">
<div class="menuBoxInner exportIcon">
<?php
echo strtoupper(__('Export Data')) . '<hr />' . __('Export member(s) data to CSV file');
?>
</div>
</fieldset>
<?php
// create new instance
$form = new simbio_form_table('mainForm', $_SERVER['PHP_SELF'] . '', 'post');
$form->submit_button_attr = 'name="doExport" value="' . __('Export Now') . '" class="button"';
// form table attributes
$form->table_attr = 'align="center" class="dataList" cellpadding="5" cellspacing="0"';
$form->table_header_attr = 'class="alterCell" style="font-weight: bold;"';
$form->table_content_attr = 'class="alterCell2"';
/* Form Element(s) */
// field separator
$form->addTextField('text', 'fieldSep', __('Field Separator') . '*', '' . htmlentities(',') . '', 'style="width: 10%;"');
// field enclosed
$form->addTextField('text', 'fieldEnc', __('Field Enclosed With'), '' . htmlentities('"') . '', 'style="width: 10%;"');
// record separator
$rec_sep_options[] = array('NEWLINE', 'NEWLINE');
$rec_sep_options[] = array('RETURN', 'CARRIAGE RETURN');
$form->addSelectList('recordSep', __('Record Separator'), $rec_sep_options);
// number of records to export
$form->addTextField('text', 'recordNum', __('Number of Records To Export (0 for all records)'), '0', 'style="width: 10%;"');
// records offset
$form->addTextField('text', 'recordOffset', __('Start From Record'), '1', 'style="width: 10%;"');
// output the form
echo $form->printOut();
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['item_status_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// item status code
$form->addTextField('text', 'itemStatusID', __('Item Status Code') . '*', $rec_d['item_status_id'], 'style="width: 20%;" maxlength="3"');
// item status name
$form->addTextField('text', 'itemStatus', __('Item Status Name') . '*', $rec_d['item_status_name'], 'style="width: 60%;"');
// item status rules
$form->addCheckbox('rules', __('Rules'), $rules_option, unserialize($rec_d['rules']));
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit Item Status data') . ' : <b>' . $rec_d['item_status_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* ITEM STATUS LIST */
// table spec
$table_spec = 'mst_item_status AS ist';
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['gmd_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// gmd code
$form->addTextField('text', 'gmdCode', __('GMD Code') . '*', $rec_d['gmd_code'], 'style="width: 20%;" maxlength="3"');
// gmd name
$form->addTextField('text', 'gmdName', __('GMD Name') . '*', $rec_d['gmd_name'], 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit gmd data') . ' : <b>' . $rec_d['gmd_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* GMD LIST */
// table spec
$table_spec = 'mst_gmd AS g';
// create datagrid
$datagrid = new simbio_datagrid();
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['supplier_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// supplier name
$form->addTextField('text', 'supplierName', __('Supplier Name') . '*', $rec_d['supplier_name'], 'style="width: 60%;"');
// supplier address
$form->addTextField('textarea', 'supplierPlace', __('Address'), $rec_d['address'], 'style="width: 100%;" rows="2"');
// supplier contact
$form->addTextField('text', 'supplierContact', __('Contact'), $rec_d['contact'], 'style="width: 60%;"');
// supplier phone
$form->addTextField('text', 'supplierPhone', __('Phone Number'), $rec_d['phone'], 'style="width: 60%;"');
// supplier fax
$form->addTextField('text', 'supplierFax', __('Fax Number'), $rec_d['fax'], 'style="width: 60%;"');
// supplier account number
$form->addTextField('text', 'supplierAccount', __('Account Number'), $rec_d['account'], 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit Supplier data') . ' : <b>' . $rec_d['supplier_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
$ctype_options = array();
while ($ctype_data = $ctype_query->fetch_row()) {
$ctype_options[] = array($ctype_data[0], $ctype_data[1]);
}
$ctype_options[] = array('0', __('ALL'));
$form->addSelectList('collTypeID', __('Collection Type'), $ctype_options, $rec_d['coll_type_id'], 'style="width: 50%;"');
// gmd
// get gmd data related to this record from database
$gmd_query = $dbs->query('SELECT gmd_id, gmd_name FROM mst_gmd');
$gmd_options[] = array(0, __('ALL'));
while ($gmd_data = $gmd_query->fetch_row()) {
$gmd_options[] = array($gmd_data[0], $gmd_data[1]);
}
$form->addSelectList('gmdID', __('GMD'), $gmd_options, $rec_d['gmd_id'], 'style="width: 50%;"');
// loan limit
$form->addTextField('text', 'loanLimit', __('Loan Limit'), $rec_d['loan_limit'], 'size="5"');
// loan periode
$form->addTextField('text', 'loanPeriode', __('Loan Period'), $rec_d['loan_periode'], 'size="5"');
// reborrow limit
$form->addTextField('text', 'reborrowLimit', __('Reborrow Limit'), $rec_d['reborrow_limit'], 'size="5"');
// fine each day
$form->addTextField('text', 'fineEachDay', __('Fines Each Day'), $rec_d['fine_each_day']);
// overdue grace periode
$form->addTextField('text', 'gracePeriode', __('Overdue Grace Periode'), $rec_d['grace_periode']);
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit loan rules') . ' : <br />' . __('Last Update') . $rec_d['last_update'] . '</div>' . "\n";
//mfc
}
// print out the form object
echo $form->printOut();
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['place_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// place name
$form->addTextField('text', 'placeName', __('Place Name') . '*', $rec_d['place_name'], 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit place data') . ' : <b>' . $rec_d['place_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* PLACE LIST */
// table spec
$table_spec = 'mst_place AS pl';
// create datagrid
$datagrid = new simbio_datagrid();
if ($can_read and $can_write) {
$datagrid->setSQLColumn('pl.place_id', 'pl.place_name AS \'' . __('Place Name') . '\'', 'pl.last_update AS \'' . __('Last Update') . '\'');
// edit mode flag set
if ($rec_q->num_rows > 0) {
$form->edit_mode = true;
// record ID for delete process
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['period'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// serial date start
$form->addDateField('dateStart', __('Subscription Start') . '*', $rec_d['date_start']);
if (!$form->edit_mode) {
// serial exemplar
$form->addTextField('text', 'exemplar', __('Total Exemplar Expected') . '*', '1');
}
// serial periode name
$form->addTextField('text', 'period', __('Period Name') . '*', $rec_d['period'], 'style="width: 100%;"');
// serial notes
$form->addTextField('textarea', 'notes', __('Subscription Notes'), $rec_d['notes'], 'style="width: 100%;" rows="3"');
// serial gmd
// get gmd data related to this record from database
$gmd_q = $dbs->query('SELECT gmd_id, gmd_name FROM mst_gmd');
$gmd_options = array();
while ($gmd_d = $gmd_q->fetch_row()) {
$gmd_options[] = array($gmd_d[0], $gmd_d[1]);
}
$form->addSelectList('gmdID', __('GMD'), $gmd_options, $rec_d['gmd_id']);
// serial biblio ID
$form->addHidden('biblioID', $biblioID);
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = str_ireplace('label-', '', $rec_d['label_name']);
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// label name
$form->addTextField('text', 'labelName', __('Label Name') . '*', $rec_d['label_name'], 'style="width: 60%;" maxlength="20"');
// label image
if (empty($rec_d['label_image'])) {
$str_input = simbio_form_element::textField('file', 'labelImage');
$str_input .= ' Maximum ' . $sysconf['max_image_upload'] . ' KB. All image will be automatically resized.';
$form->addAnything(__('File Attachment'), $str_input);
} else {
$str_input = '<div><img src="' . SENAYAN_WEB_ROOT_DIR . IMAGES_DIR . '/labels/' . $rec_d['label_image'] . '" align="middle" /> <strong>' . $rec_d['label_image'] . '</strong></div>';
$str_input .= simbio_form_element::textField('file', 'labelImage');
$str_input .= ' Maximum ' . $sysconf['max_image_upload'] . ' KB. All image will be automatically resized.';
$form->addAnything(__('File Attachment'), $str_input);
}
// label desc
$form->addTextField('text', 'labelDesc', __('Label Description'), $rec_d['label_desc'], 'style="width: 100%;" maxlength="50"');
// edit mode messagge
if ($form->edit_mode) {
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['member_type_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// member type name
$form->addTextField('text', 'memberTypeName', __('Member Type Name') . '*', $rec_d['member_type_name'], 'style="width: 100%;"');
// loan limit
$form->addTextField('text', 'loanLimit', __('Loan Limit'), $rec_d['loan_limit'], 'size="5"');
// loan periode
$form->addTextField('text', 'loanPeriode', __('Loan Periode (In Days)'), $rec_d['loan_periode'], 'size="5"');
// enable reserve
$enable_resv_chbox[0] = array('1', __('Enable'));
$enable_resv_chbox[1] = array('0', __('Disable'));
$form->addRadio('enableReserve', __('Reserve'), $enable_resv_chbox, !empty($rec_d['enable_reserve']) ? $rec_d['enable_reserve'] : '1');
// reserve limit
$form->addTextField('text', 'reserveLimit', __('Reserve Limit'), $rec_d['reserve_limit'], 'size="5"');
// membership periode
$form->addTextField('text', 'memberPeriode', __('Membership Periode (In Days)'), $rec_d['member_periode'], 'size="5"');
// reborrow limit
$form->addTextField('text', 'reborrowLimit', __('Reborrow Limit'), $rec_d['reborrow_limit'], 'size="5"');
// fine each day
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['coll_type_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// coll_type_name
$form->addTextField('text', 'collTypeName', __('Collection Type') . '*', $rec_d['coll_type_name'], 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit collection type data') . ' : <b>' . $rec_d['coll_type_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* COLLECTION TYPE LIST */
// table spec
$table_spec = 'mst_coll_type AS ct';
// create datagrid
$datagrid = new simbio_datagrid();
if ($can_read and $can_write) {
$datagrid->setSQLColumn('ct.coll_type_id', 'ct.coll_type_name AS \'' . __('Collection Type') . '\'', 'ct.last_update AS \'' . __('Last Update') . '\'');
// edit mode flag set
if ($rec_q->num_rows > 0) {
$form->edit_mode = true;
// record ID for delete process
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['period'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . lang_sys_common_form_update . '" class="button"';
}
/* Form Element(s) */
// serial date start
$form->addDateField('dateStart', lang_mod_serial_field_date_start . '*', $rec_d['date_start']);
if (!$form->edit_mode) {
// serial exemplar
$form->addTextField('text', 'exemplar', lang_mod_serial_field_exemplar . '*', '1');
}
// serial periode name
$form->addTextField('text', 'period', lang_mod_serial_field_period . '*', $rec_d['period'], 'style="width: 100%;"');
// serial notes
$form->addTextField('textarea', 'notes', lang_mod_serial_field_notes, $rec_d['notes'], 'style="width: 100%;" rows="3"');
// serial gmd
// get gmd data related to this record from database
$gmd_q = $dbs->query('SELECT gmd_id, gmd_name FROM mst_gmd');
$gmd_options = array();
while ($gmd_d = $gmd_q->fetch_row()) {
$gmd_options[] = array($gmd_d[0], $gmd_d[1]);
}
$form->addSelectList('gmdID', lang_mod_biblio_field_gmd, $gmd_options, $rec_d['gmd_id']);
// serial biblio ID
$form->addHidden('biblioID', $biblioID);
// record ID for delete process
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['description'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// holiday date start
$form->addDateField('holDate', __('Holiday Date Start'), $rec_d['holiday_date']);
// holiday date end
if (!$form->edit_mode) {
$form->addDateField('holDateEnd', __('Holiday Date End'), $rec_d['holiday_date']);
}
// holiday description
$form->addTextField('text', 'holDesc', __('Holiday Description') . '*', $rec_d['description'], 'style="width: 100%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit holiday data') . ' : <b>' . $rec_d['description'] . '</b></div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* HOLIDAY LIST */
// table spec
$table_spec = 'holiday';
// create datagrid
$datagrid = new simbio_datagrid();
if ($can_read and $can_write) {
$datagrid->setSQLColumn('holiday_id', "holiday_dayname AS '" . __('Day name') . "'", "holiday_date AS '" . __('Holiday Date Start') . "'", "description AS '" . __('Holiday Description') . "'");
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['group_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// group
$form->addTextField('text', 'groupName', __('Group Name') . '*', $rec_d['group_name'], 'style="width: 60%;"');
// privileges
// get group access data
$priv_data = array();
$rec_q = $dbs->query('SELECT * FROM group_access WHERE group_id=' . (!empty($rec_d['group_id']) ? $rec_d['group_id'] : 0));
while ($access_data = $rec_q->fetch_assoc()) {
$priv_data[$access_data['module_id']]['r'] = $access_data['r'];
$priv_data[$access_data['module_id']]['w'] = $access_data['w'];
}
$priv_table = '';
include 'module_priv_form.inc.php';
$form->addAnything(__('Privileges'), $priv_table);
// edit mode messagge
if ($form->edit_mode) {
// print out the object
echo '<div class="infoBox">' . __('You are going to edit Group data') . ' : <b>' . $rec_d['group_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['location_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// location code
$form->addTextField('text', 'locationID', __('Location Code') . '*', $rec_d['location_id'], 'style="width: 20%;" maxlength="3"');
// location name
$form->addTextField('text', 'locationName', __('Location Name') . '*', $rec_d['location_name'], 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit location data') . ' : <b>' . $rec_d['location_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* LOCATION LIST */
// table spec
$table_spec = 'mst_location AS l';
// create datagrid
$datagrid = new simbio_datagrid();
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['author_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// author name
$form->addTextField('text', 'authorName', __('Author Name') . '*', $rec_d['author_name'], 'style="width: 60%;"');
// authority type
foreach ($sysconf['authority_type'] as $auth_type_id => $auth_type) {
$auth_type_options[] = array($auth_type_id, $auth_type);
}
$form->addSelectList('authorityType', __('Authority Type'), $auth_type_options, $rec_d['authority_type']);
// authority list
$form->addTextField('text', 'authList', __('Authority Files'), $rec_d['auth_list'], 'style="width: 30%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit author data') . ' : <b>' . $rec_d['author_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
$form->table_header_attr = 'class="alterCell" style="font-weight: bold;"';
$form->table_content_attr = 'class="alterCell2"';
// query
$file_attach_q = $dbs->query("SELECT fl.*, batt.* FROM files AS fl\n LEFT JOIN biblio_attachment AS batt ON fl.file_id=batt.file_id\n WHERE batt.biblio_id={$biblioID} AND batt.file_id={$fileID}");
$file_attach_d = $file_attach_q->fetch_assoc();
// edit mode
if ($file_attach_d['biblio_id'] and $file_attach_d['file_id']) {
$form->addHidden('updateBiblioID', $file_attach_d['biblio_id']);
$form->addHidden('updateFileID', $file_attach_d['file_id']);
} else {
if ($biblioID) {
$form->addHidden('updateBiblioID', $biblioID);
}
}
// file title
$form->addTextField('text', 'fileTitle', lang_mod_biblio_attach_form_field_title, $file_attach_d['file_title'], 'style="width: 100%; overflow: auto;"');
// file attachment
if ($file_attach_d['file_name']) {
$form->addAnything('Attachment', $file_attach_d['file_dir'] . '/' . $file_attach_d['file_name']);
} else {
// file upload dir
// create simbio directory object
$repo = new simbio_directory(REPO_BASE_DIR);
$repo_dir_tree = $repo->getDirectoryTree(5);
// sort array by index
ksort($repo_dir_tree);
// loop array
foreach ($repo_dir_tree as $dir) {
$repodir_options[] = array($dir, $dir);
}
$form->addSelectList('fileDir', lang_mod_biblio_attach_form_field_filedir, $repodir_options);
// title
if (!$in_pop_up) {
$str_input = $b_title;
$str_input .= '<div class="makeHidden"><a title="Edit Bibliographic Data" style="font-weight: bold; color: #ff9900;" href="javascript: openWin(\'' . MODULES_WEB_ROOT_DIR . 'bibliography/pop_biblio.php?inPopUp=true&action=detail&itemID=' . $rec_d['biblio_id'] . '&itemCollID=' . $rec_d['item_id'] . '\', \'popBiblio\', 600, 400, true)">Edit Biblographic data</a></div>';
} 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(\'' . SENAYAN_WEB_ROOT_DIR . 'admin/AJAX_check_id.php\', \'item\', \'item_code\', \'msgBox\', \'itemCode\')" style="width: 40%;"');
$str_input .= ' <span id="msgBox"> </span>';
$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");
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['module_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// module
$form->addTextField('text', 'moduleName', __('Module Name') . '*', $rec_d['module_name'], 'style="width: 50%;"');
// module path
$form->addTextField('text', 'modulePath', __('Module Path') . '*', $rec_d['module_path'], 'style="width: 100%;"');
// module desc
$form->addTextField('text', 'moduleDesc', __('Module Description'), $rec_d['module_desc'], 'style="width: 100%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit data') . ' : <b>' . $rec_d['module_name'] . '</b></div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
/* MODULE LIST */
// table spec
$table_spec = 'mst_module AS mdl';
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['language_name'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// language ID
$form->addTextField('text', 'langID', __('Language Code') . '*', $rec_d['language_id'], 'style="width: 20%;" maxlength="5"');
// language_name
$form->addTextField('text', 'langName', __('Language') . '*', $rec_d['language_name'], 'style="width: 60%;"');
// print out the form object
echo '<div class="infoBox">' . __('You are going to edit language data') . ' : <b>' . $rec_d['language_name'] . '</b> <br />' . __('Last Update') . $rec_d['last_update'] . '</div>';
//mfc
echo $form->printOut();
} else {
/* DOCUMENT LANGUAGE LIST */
// table spec
$table_spec = 'mst_language AS l';
// create datagrid
$datagrid = new simbio_datagrid();
if ($can_read and $can_write) {
$datagrid->setSQLColumn('l.language_id', 'l.language_name AS \'' . __('Language') . '\'', 'l.last_update AS \'' . __('Last Update') . '\'');
} else {
$form->table_attr = 'align="center" class="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
$form->record_id = $itemID;
// form record title
$form->record_title = $rec_d['frequency'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// frequency name
$form->addTextField('text', 'frequencyName', __('Frequency') . '*', $rec_d['frequency'], 'style="width: 60%;"');
// frequency language
// get language data related to this record from database
$lang_q = $dbs->query('SELECT language_id, language_name FROM mst_language');
$lang_options = array();
while ($lang_d = $lang_q->fetch_row()) {
$lang_options[] = array($lang_d[0], $lang_d[1]);
}
$form->addSelectList('languagePrefix', __('Language'), $lang_options, $rec_d['language_prefix']);
// frequency time increment
$form->addTextField('text', 'timeIncrement', __('Time Increment') . '*', $rec_d['time_increment'], 'style="width: 10%;"');
// frequency time unit
$unit_options[] = array('day', __('Day'));
$unit_options[] = array('week', __('Week'));
$unit_options[] = array('month', __('Month'));
$unit_options[] = array('year', __('Year'));
utility::jsAlert(__('Stock Taking FAILED to Initialized.\\nNo item to stock take!'));
}
exit;
}
}
}
// create new instance
$form = new simbio_form_table('mainForm', $_SERVER['PHP_SELF'] . '?action=new', 'post');
$form->submit_button_attr = 'name="saveData" value="' . __('Initialize Stock Take') . '" class="button"';
// form table attributes
$form->table_attr = 'align="center" class="dataList" cellpadding="5" cellspacing="0"';
$form->table_header_attr = 'class="alterCell" style="font-weight: bold;"';
$form->table_content_attr = 'class="alterCell2"';
/* Form Element(s) */
// stock take name
$form->addTextField('text', 'name', __('Stock Take Name') . '*', '', 'style="width: 60%;"');
// gmd
// get gmd data related to this record from database
$gmd_q = $dbs->query('SELECT gmd_id, gmd_name FROM mst_gmd');
$gmd_options[] = array('0', __('ALL'));
while ($gmd_d = $gmd_q->fetch_row()) {
$gmd_options[] = array($gmd_d[0], $gmd_d[1]);
}
$form->addSelectList('gmdID', __('GMD'), $gmd_options);
// collection type
// get coll_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('0', __('ALL'));
while ($coll_type_d = $coll_type_q->fetch_row()) {
$coll_type_options[] = array($coll_type_d[0], $coll_type_d[1]);
}
// record ID for delete process
if (!$changecurrent) {
// form record id
$form->record_id = $itemID;
} else {
$form->addHidden('updateRecordID', $itemID);
$form->back_button = false;
}
// form record title
$form->record_title = $rec_d['realname'];
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// user name
$form->addTextField('text', 'userName', __('Login Username') . '*', $rec_d['username'], 'style="width: 50%;"');
// user real name
$form->addTextField('text', 'realName', __('Real Name') . '*', $rec_d['realname'], 'style="width: 50%;"');
// user group
// only appear by user who hold system module privileges
if (!$changecurrent and $can_read and $can_write) {
// add hidden element as a flag that we dont change group data
$form->addHidden('noChangeGroup', '1');
// user group
$group_query = $dbs->query('SELECT group_id, group_name FROM
user_group WHERE group_id != 1');
// initiliaze group options
$group_options = array();
while ($group_data = $group_query->fetch_row()) {
$group_options[] = array($group_data[0], $group_data[1]);
}
// record ID for delete process
$form->record_id = $itemID;
// delete button only showed for admin user
if ($_SESSION['uid'] != 1) {
$form->delete_button = false;
}
// form record title
$form->record_title = 'Fines Detail';
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . __('Update') . '" class="button"';
}
/* Form Element(s) */
// fines dates
$form->addDateField('finesDate', __('Fines Date'), $rec_d['fines_date']);
// fines description
$form->addTextField('text', 'finesDesc', __('Description/Name') . '*', $rec_d['description'], 'style="width: 60%;"');
// fines debet
$form->addTextField('text', 'debet', __('Debit') . '*', !empty($rec_d['debet']) ? $rec_d['debet'] : '0', 'style="width: 60%;"');
// fines credit
$form->addTextField('text', 'credit', __('Credit'), !empty($rec_d['credit']) ? $rec_d['credit'] : '0', 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . __('You are going to edit fines data') . ' : <b>' . $rec_d['description'] . '</b></div>';
//mfc
}
// print out the form object
echo $form->printOut();
} else {
$fines_alert = FALSE;
$total_unpaid_fines = 0;
$_unpaid_fines = $dbs->query('SELECT * FROM fines WHERE member_id=' . $_SESSION['memberID'] . ' AND debet > credit');
// record ID for delete process
$form->record_id = $itemID;
// delete button only showed for admin user
if ($_SESSION['uid'] != 1) {
$form->delete_button = false;
}
// form record title
$form->record_title = 'Fines Detail';
// submit button attribute
$form->submit_button_attr = 'name="saveData" value="' . lang_sys_common_form_update . '" class="button"';
}
/* Form Element(s) */
// fines dates
$form->addDateField('finesDate', lang_mod_circ_fines_field_date, $rec_d['fines_date']);
// fines description
$form->addTextField('text', 'finesDesc', lang_mod_circ_fines_field_description . '*', $rec_d['description'], 'style="width: 60%;"');
// fines debet
$form->addTextField('text', 'debet', lang_mod_circ_fines_field_debit . '*', !empty($rec_d['debet']) ? $rec_d['debet'] : '0', 'style="width: 60%;"');
// fines credit
$form->addTextField('text', 'credit', lang_mod_circ_fines_field_credit, !empty($rec_d['credit']) ? $rec_d['credit'] : '0', 'style="width: 60%;"');
// edit mode messagge
if ($form->edit_mode) {
echo '<div class="infoBox">' . lang_mod_circ_fines_common_info . '<b>' . $rec_d['description'] . '</b></div>';
}
// print out the form object
echo $form->printOut();
} else {
/* FINES LIST */
$memberID = trim($_SESSION['memberID']);
// table spec
$table_spec = 'fines AS f';
$form->table_header_attr = 'class="alterCell" style="font-weight: bold;"';
$form->table_content_attr = 'class="alterCell2"';
// query
$file_attach_q = $dbs->query("SELECT fl.*, batt.* FROM files AS fl\r\n LEFT JOIN biblio_attachment AS batt ON fl.file_id=batt.file_id\r\n WHERE batt.biblio_id={$biblioID} AND batt.file_id={$fileID}");
$file_attach_d = $file_attach_q->fetch_assoc();
// edit mode
if ($file_attach_d['biblio_id'] and $file_attach_d['file_id']) {
$form->addHidden('updateBiblioID', $file_attach_d['biblio_id']);
$form->addHidden('updateFileID', $file_attach_d['file_id']);
} else {
if ($biblioID) {
$form->addHidden('updateBiblioID', $biblioID);
}
}
// file title
$form->addTextField('text', 'fileTitle', __('Title') . '*', $file_attach_d['file_title'], 'style="width: 100%; overflow: auto;"');
// file attachment
if ($file_attach_d['file_name']) {
$form->addAnything('Attachment', $file_attach_d['file_dir'] . '/' . $file_attach_d['file_name']);
} else {
// file upload dir
// create simbio directory object
$repo = new simbio_directory(REPO_BASE_DIR);
$repo_dir_tree = $repo->getDirectoryTree(5);
$repodir_options[] = array('', __('Repository ROOT'));
if (is_array($repo_dir_tree)) {
// sort array by index
ksort($repo_dir_tree);
// loop array
foreach ($repo_dir_tree as $dir) {
$repodir_options[] = array($dir, $dir);
$form->record_id = $itemID;
} else {
$form->addHidden('updateRecordID', $itemID);
$form->addHidden('itemCollID', $_POST['itemCollID']);
$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="button"';
// element visibility class toogle
$visibility = 'makeHidden';
}
/* Form Element(s) */
// biblio title
$form->addTextField('textarea', 'title', __('Title') . '*', $rec_d['title'], 'rows="1" style="width: 100%; overflow: auto;"');
// biblio edition
$form->addTextField('text', 'edition', __('Edition'), $rec_d['edition'], 'style="width: 40%;"');
// biblio specific detail info/area
$form->addTextField('textarea', 'specDetailInfo', __('Specific Detail Info'), $rec_d['spec_detail_info'], 'rows="2" style="width: 100%"');
// biblio item add
if (!$in_pop_up and $form->edit_mode) {
$str_input = '<div class="makeHidden"><a href="javascript: openWin(\'' . MODULES_WEB_ROOT_DIR . 'bibliography/pop_item.php?inPopUp=true&action=detail&biblioID=' . $rec_d['biblio_id'] . '\', \'popItem\', 600, 400, true)">' . __('Add New Items') . '</a></div>';
$str_input .= '<iframe name="itemIframe" id="itemIframe" class="borderAll" style="width: 100%; height: 70px;" src="' . MODULES_WEB_ROOT_DIR . 'bibliography/iframe_item_list.php?biblioID=' . $rec_d['biblio_id'] . '"></iframe>' . "\n";
$form->addAnything('Item(s) Data', $str_input);
}
// biblio authors
$str_input = '<div class="' . $visibility . '"><a href="javascript: openWin(\'' . MODULES_WEB_ROOT_DIR . 'bibliography/pop_author.php?biblioID=' . $rec_d['biblio_id'] . '\', \'popAuthor\', 500, 200, true)">' . __('Add Author(s)') . '</a></div>';
$str_input .= '<iframe name="authorIframe" id="authorIframe" class="borderAll" style="width: 100%; height: 70px;" src="' . MODULES_WEB_ROOT_DIR . 'bibliography/iframe_author.php?biblioID=' . $rec_d['biblio_id'] . '"></iframe>';
$form->addAnything(__('Author(s)'), $str_input);
// biblio gmd
