'.__('You are not authorized to view this section').''); } if (isset($_POST['doExport'])) { // check for form validity if (empty($_POST['fieldSep']) OR empty($_POST['fieldEnc'])) { utility::jsAlert(__('Required fields (*) must be filled correctly!')); exit(); } else { // set PHP time limit set_time_limit(0); // create local function to fetch values function getValues($obj_db, $str_query) { // make query from database $_value_q = $obj_db->query($str_query); if ($_value_q->num_rows > 0) { $_value_buffer = ''; while ($_value_d = $_value_q->fetch_row()) { if ($_value_d[0]) { $_value_buffer .= '<'.$_value_d[0].'>'; } } return $_value_buffer; } return null; } // limit $sep = trim($_POST['fieldSep']); $encloser = trim($_POST['fieldEnc']); $limit = intval($_POST['recordNum']); $offset = intval($_POST['recordOffset']); if ($_POST['recordSep'] === 'NEWLINE') { $rec_sep = "\n"; } else if ($_POST['recordSep'] === 'RETURN') { $rec_sep = "\r"; } else { $rec_sep = trim($_POST['recordSep']); } // fetch all data from item table $sql = "SELECT i.item_code, i.call_number, ct.coll_type_name, i.inventory_code, i.received_date, spl.supplier_name, i.order_no, loc.location_name, i.order_date, st.item_status_name, i.site, i.source, i.invoice, i.price, i.price_currency, i.invoice_date, i.input_date, i.last_update, b.title FROM item AS i LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id LEFT JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id LEFT JOIN mst_supplier AS spl ON i.supplier_id=spl.supplier_id LEFT JOIN mst_item_status AS st ON i.item_status_id=st.item_status_id LEFT JOIN mst_location AS loc ON i.location_id=loc.location_id "; if ($limit > 0) { $sql .= ' LIMIT '.$limit; } if ($offset > 1) { if ($limit > 0) { $sql .= ' OFFSET '.($offset-1); } else { $sql .= ' LIMIT '.($offset-1).',99999999999'; } } // for debugging purpose only // die($sql); $all_data_q = $dbs->query($sql); if ($dbs->error) { utility::jsAlert(__('Error on query to database, Export FAILED!'.$dbs->error)); } else { if ($all_data_q->num_rows > 0) { header('Content-type: text/plain'); header('Content-Disposition: attachment; filename="senayan_item_export.csv"'); while ($item_d = $all_data_q->fetch_row()) { $buffer = null; foreach ($item_d as $idx => $fld_d) { $fld_d = $dbs->escape_string($fld_d); // data $buffer .= stripslashes($encloser.$fld_d.$encloser); // field separator $buffer .= $sep; } echo substr_replace($buffer, '', -1); echo $rec_sep; } exit(); } else { utility::jsAlert(__('There is no record in item database yet, Export FAILED!')); } } } exit(); } ?> submit_button_attr = 'name="doExport" value="'.__('Export Now').'" 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"'; /* Form Element(s) */ // field separator $form->addTextField('text', 'fieldSep', __('Field Separator').'*', ''.htmlentities(',').'', 'style="width: 10%;" maxlength="3"'); // 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();