public static function getJumlahPerJenis() { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $tRumahSakit =& wbModule::getModel('bds', 'd_rumahsakit'); $jumlah = $tRumahSakit->getJumlahPerJenis($item['param_id']); $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $jumlah; return $data; }
public static function getJumlahPerKecamatan() { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $tPuskesmas =& wbModule::getModel('bds', 'd_puskesmas'); $jumlah = $tPuskesmas->getJumlahPerKecamatan($item['wilayah_id']); $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $jumlah; return $data; }
public static function getItem() { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $tTernak =& wbModule::getModel('bds', 't_ternak'); $itemTernak = $tTernak->getItem($item['tahun'], $item['param_id']); $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $itemTernak; return $data; }
public static function getItem() { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $tArmada =& wbModule::getModel('bds', 't_armada'); $itemArmada = $tArmada->getItem($item['tahun'], $item['trayek_id']); $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $itemArmada; return $data; }
public static function getProduksiKomoditas() { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $tProduksi =& wbModule::getModel('bds', 't_agr_komod_prod'); $itemProduksi = $tProduksi->getProduksiKomoditas($item['tahun'], $item['d_agr_komiditas_id']); $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $itemProduksi; return $data; }
function ws_proccess($search, $getParams, $controller, $postParams, $jsonItems, $start, $limit) { $GLOBALS["Webi_PageTime"] = microtime(true); include 'lib/bootstrap.php'; /* Load Webi Core */ sys::import('webi.core'); wbCore::init(); $_GET['jsonItems'] = $jsonItems; if (!empty($getParams)) { $getParams =& wbUtil::jsonDecode($getParams); } else { $getParams = array(); } if (json_decode($postParams) > 0) { $postParams = json_decode($postParams); } else { $postParams = array(); } $controller =& wbUtil::jsonDecode($controller); $type = $controller['type']; if (!empty($getParams)) { foreach ($getParams as $key => $value) { $_GET[$key] = $value; } } if (!empty($postParams)) { foreach ($postParams as $key => $value) { $_POST[$key] = $value; } } $_GET['module'] = $controller['module']; $_GET['class'] = $controller['class']; $_GET['method'] = $controller['method']; list($module, $class, $method) = wbRequest::getController(); $callback = wbRequest::getVarClean('callback'); if (!wbModule::isAvailable($module, $class, $type)) { header("HTTP/1.1 400 Bad Request"); return; } try { $result = wbModule::call($module, $class, $method, array(), $type); } catch (Exception $e) { $result = array('items' => array(), 'total' => 0, 'success' => false, 'message' => $e->getMessage()); } $return = array(); $return['success'] = $result['success']; $return['message'] = $result['message']; $return['total'] = (int) $result['total']; $return['data'] = $result['items']; $return['current'] = (int) $result['current']; $return['rowCount'] = (int) $result['rowCount']; $return = base64_encode(serialize($return)); return $return; }
public static function getCountByPendidikanID() { $tWarga =& wbModule::getModel('bds', 'd_warga'); $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $jumlah = $tWarga->getCountByAge($item['param_id']); $jumlah_l = $tWarga->getCountByAge($item['param_id'], 6); $jumlah_p = $tWarga->getCountByAge($item['param_id'], 7); $itemJumlah = array(); $itemJumlah['jumlah'] = $jumlah; $itemJumlah['jumlah_l'] = $jumlah_l; $itemJumlah['jumlah_p'] = $jumlah_p; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); $data['items'] = $itemJumlah; return $data; }
public static function submitRegistration($args = array()) { // Security check //if (!wbSecurity::check('DHotel')) return; // Get arguments from argument array $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); try { $ws_client = self::getNusoap(); $params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 't_vat_registration', 'method' => 'destroy', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit); $ws_data = self::getResultData($ws_client, $params); $data['items'] = $ws_data['data']; $data['total'] = $ws_data['total']; $data['message'] = $ws_data['message']; $data['success'] = $ws_data['success']; } catch (Exception $e) { $data['message'] = $e->getMessage(); } return $data; }
public static function upload_excel($args = array()) { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 'smp_detail'); $table->actionType = 'CREATE'; $items = $item['items']; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { $errorMessage = ''; /* cek data sd */ $tahunAjaranSMPExist = $table->isExistTahunAjaran($items[0]['smp_id'], $items[0]['smp_det_thn_ajaran']); if (!$tahunAjaranSMPExist) { $items[0][$table->pkey] = $table->GenID(); $table->setRecord($items[0]); $table->create(); } else { $errorMessage .= '- Data SMP Tahun Ajaran ' . $items[0]['smp_det_thn_ajaran'] . ' tidak dapat diinput karena sudah ada <br>'; } /* cek data mi */ $tahunAjaranMTSExist = $table->isExistTahunAjaran($items[1]['smp_id'], $items[1]['smp_det_thn_ajaran']); if (!$tahunAjaranMTSExist) { $items[1][$table->pkey] = $table->GenID(); $table->setRecord($items[1]); $table->create(); } else { $errorMessage .= '- Data MTS Tahun Ajaran ' . $items[1]['smp_det_thn_ajaran'] . ' tidak dapat diinput karena sudah ada <br>'; } if (empty($errorMessage)) { return $data; } else { throw new Exception($errorMessage); } } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }
/** * update * controler for remove item */ public static function destroy($args = array()) { // Security check //if (!wbSecurity::check('DHotel')) return; // Get arguments from argument array $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); try { $ws_client = self::getNusoap(); $params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 't_cust_order_legal_doc', 'method' => 'destroy', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit); $ws_data = self::getResultData($ws_client, $params); if ($ws_data['data']['single']) { if ($ws_data['success']) { $r = $ws_data['data']['old_row']; if (!empty($r['origin_file_name']) && is_file(self::imurl() . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); if (is_file(self::imurl() . 'th_' . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . 'th_' . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); } if (is_file(self::imurl() . 'view_' . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . 'view_' . $ws_data['data']['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); } } } } else { if ($ws_data['success']) { foreach ($ws_data['data'] as $item) { $r = $item['old_row']; if (!empty($r['origin_file_name']) && is_file(self::imurl() . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); if (is_file(self::imurl() . 'th_' . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . 'th_' . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); } if (is_file(self::imurl() . 'view_' . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name'])) { @unlink(self::imurl() . 'view_' . $item['deleted']['t_cust_order_legal_doc_id'] . '_' . $r['origin_file_name']); } } } } } $data['items'] = $ws_data['data']; $data['total'] = $ws_data['total']; $data['message'] = $ws_data['message']; $data['success'] = $ws_data['success']; } catch (Exception $e) { $data['message'] = $e->getMessage(); } return $data; }
public static function upload_excel($args = array()) { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 't_modern_mart'); $table->actionType = 'CREATE'; $parameter =& wbModule::getModel('bds', 'p_parameter'); $items = $item['items']; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { $errorMessage = ''; /* cek data */ foreach ($items as $rec) { $errorMessage .= $table->cekValid(trim($rec['param_name']), $rec['mmart_tahun']); } if (!empty($errorMessage)) { throw new Exception('Input data gagal, dikarenakan : <br>' . $errorMessage); } foreach ($items as $rec) { $rec[$table->pkey] = $table->GenID(); $rec['type_id'] = $parameter->getIDbyName(trim($rec['param_name'])); $table->setRecord($rec); $table->create(); } return $data; } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }
/** * update * controler for remove item */ public static function destroy($args = array()) { // Security check //wbSecurity::check('RolePermission', ACCESS_DELETE); // Get arguments from argument array //extract($args); $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); try { $ws_client = self::getNusoap(); $params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'base', 'class' => 'roles.role_permission', 'method' => 'destroy', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit); $ws_data = self::getResultData($ws_client, $params); $data['items'] = $ws_data['data']; $data['total'] = $ws_data['total']; $data['message'] = $ws_data['message']; $data['success'] = $ws_data['success']; } catch (Exception $e) { $data['message'] = $e->getMessage(); } return $data; }
/** * update * controler for remove item */ public static function destroy($args = array()) { // Security check wbSecurity::check('PRoleMenu', ACCESS_DELETE); // Get arguments from argument array extract($args); $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); $table =& wbModule::getModel('bds', 'p_role_menu'); try { $table->dbconn->BeginTrans(); if (is_array($items)) { foreach ($items as $key => $value) { if (empty($value)) { throw new Exception('Empty parameter'); } $keys = explode('.', $value); if (empty($keys[0]) || empty($keys[1])) { throw new Exception('Invalid Role Permission ID'); } $table->remove($keys[0], $keys[1]); $data['items'][] = array('p_role_menu_id' => $value); $data['total']++; } } else { if (empty($items)) { throw new Exception('Empty parameter'); } $keys = explode('.', $items); if (empty($keys[0]) || empty($keys[1])) { throw new Exception('Invalid Role Permission ID'); } $table->remove($keys[0], $keys[1]); $data['items'][] = array('p_role_menu_id' => $items); $data['total'] = 1; } $data['success'] = true; $data['message'] = $data['total'] . ' Data berhasil dihapus'; $table->dbconn->CommitTrans(); } catch (Exception $e) { $table->dbconn->RollbackTrans(); $data['message'] = $e->getMessage(); $data['items'] = array(); $data['total'] = 0; } return $data; }
public static function upload_excel($args = array()) { $jsonItems = wbRequest::getVarClean('jsonItems', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 'p_vat_type_dtl'); $table->actionType = 'CREATE'; $items = $item['items']; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { foreach ($items as $rec) { $rec[$table->pkey] = $table->GenID(); $table->setRecord($rec); $table->create(); } return $data; } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }
public static function upload_excel($args = array()) { include 'lib/excel/reader.php'; $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); global $_FILES; try { if (empty($_FILES['excel_file']['name'])) { throw new Exception('File tidak boleh kosong'); } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } $jsonItems = wbRequest::getVarClean('items', 'str', ''); $smp_tahun_ajaran = wbRequest::getVarClean('smp_tahun_ajaran', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); if (!is_array($items)) { $data['message'] = 'Invalid items parameter'; return $data; } $file_name = $_FILES['excel_file']['name']; $file_location = 'var/uploadexcel/' . $file_name; if (!move_uploaded_file($_FILES['excel_file']['tmp_name'], $file_location)) { throw new Exception("Upload file gagal"); } $xl_reader =& new Spreadsheet_Excel_Reader(); $res = $xl_reader->_ole->read($file_location); if ($res === false) { if ($xl_reader->_ole->error == 1) { $data['message'] = 'Harus File Excel'; echo json_encode($data); session_write_close(); exit; } } try { $xl_reader->read($file_location); $firstColumn = $xl_reader->sheets[0]['cells'][1][1]; if (strtoupper($firstColumn) != 'DATA SEKOLAH MENENGAH PERTAMA') { throw new Exception('Format Table Salah'); } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } /* insert data */ $recInsert = array(); $items = array(); try { //----------------------- // SMP //----------------------- $items[0]['smp_id'] = 1; $items[0]['smp_det_thn_ajaran'] = $smp_tahun_ajaran; $items[0]['smp_det_jmlsekolah'] = $xl_reader->sheets[0]['cells'][6][3]; $items[0]['smp_det_siswabaru'] = $xl_reader->sheets[0]['cells'][7][3]; $items[0]['smp_det_siwa_lt_13_thn'] = $xl_reader->sheets[0]['cells'][9][3]; $items[0]['smp_det_siswa_13_15_thn'] = $xl_reader->sheets[0]['cells'][10][3]; $items[0]['smp_det_siswa_gt_15_thn'] = $xl_reader->sheets[0]['cells'][11][3]; $items[0]['smp_det_siswa_laki'] = $xl_reader->sheets[0]['cells'][13][3]; $items[0]['smp_det_siswa_perempuan'] = $xl_reader->sheets[0]['cells'][17][3]; $items[0]['smp_det_jml_siswa_negeri'] = $xl_reader->sheets[0]['cells'][22][3]; $items[0]['smp_det_jml_siswa_swasta'] = $xl_reader->sheets[0]['cells'][23][3]; $items[0]['smp_det_jml_kelas7'] = $xl_reader->sheets[0]['cells'][25][3]; $items[0]['smp_det_jml_kelas8'] = $xl_reader->sheets[0]['cells'][26][3]; $items[0]['smp_det_jml_kelas9'] = $xl_reader->sheets[0]['cells'][27][3]; $items[0]['smp_det_ulang_kelas7'] = $xl_reader->sheets[0]['cells'][33][3]; $items[0]['smp_det_ulang_kelas8'] = $xl_reader->sheets[0]['cells'][34][3]; $items[0]['smp_det_ulang_kelas9'] = $xl_reader->sheets[0]['cells'][35][3]; $items[0]['smp_det_putus_kelas7'] = $xl_reader->sheets[0]['cells'][37][3]; $items[0]['smp_det_putus_kelas8'] = $xl_reader->sheets[0]['cells'][38][3]; $items[0]['smp_det_putus_kelas9'] = $xl_reader->sheets[0]['cells'][39][3]; //------------------------ // MTS //------------------------ $items[1]['smp_id'] = 2; $items[1]['smp_det_thn_ajaran'] = $smp_tahun_ajaran; $items[1]['smp_det_jmlsekolah'] = $xl_reader->sheets[0]['cells'][6][4]; $items[1]['smp_det_siswabaru'] = $xl_reader->sheets[0]['cells'][7][4]; $items[1]['smp_det_siwa_lt_13_thn'] = $xl_reader->sheets[0]['cells'][9][4]; $items[1]['smp_det_siswa_13_15_thn'] = $xl_reader->sheets[0]['cells'][10][4]; $items[1]['smp_det_siswa_gt_15_thn'] = $xl_reader->sheets[0]['cells'][11][4]; $items[1]['smp_det_siswa_laki'] = $xl_reader->sheets[0]['cells'][13][4]; $items[1]['smp_det_siswa_perempuan'] = $xl_reader->sheets[0]['cells'][17][4]; $items[1]['smp_det_jml_siswa_negeri'] = $xl_reader->sheets[0]['cells'][22][4]; $items[1]['smp_det_jml_siswa_swasta'] = $xl_reader->sheets[0]['cells'][23][4]; $items[1]['smp_det_jml_kelas7'] = $xl_reader->sheets[0]['cells'][25][4]; $items[1]['smp_det_jml_kelas8'] = $xl_reader->sheets[0]['cells'][26][4]; $items[1]['smp_det_jml_kelas9'] = $xl_reader->sheets[0]['cells'][27][4]; $items[1]['smp_det_ulang_kelas7'] = $xl_reader->sheets[0]['cells'][33][4]; $items[1]['smp_det_ulang_kelas8'] = $xl_reader->sheets[0]['cells'][34][4]; $items[1]['smp_det_ulang_kelas9'] = $xl_reader->sheets[0]['cells'][35][4]; $items[1]['smp_det_putus_kelas7'] = $xl_reader->sheets[0]['cells'][37][4]; $items[1]['smp_det_putus_kelas8'] = $xl_reader->sheets[0]['cells'][38][4]; $items[1]['smp_det_putus_kelas9'] = $xl_reader->sheets[0]['cells'][39][4]; $ws_client = self::getNusoap(); $params = array('search' => '', 'controller' => json_encode(array('module' => 'bds', 'class' => 'smp', 'method' => 'upload_excel', 'type' => 'json')), 'jsonItems' => json_encode(array('items' => $items))); $ws_data = self::getResultData($ws_client, $params); if (!empty($ws_data['message'])) { throw new Exception($ws_data['message']); } $data['success'] = true; $data['message'] = 'Data berhasil disimpan'; $data['items'] = $items; } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } echo json_encode($data); session_write_close(); exit; }
public static function upload_excel($args = array()) { include 'lib/excel/reader.php'; $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); global $_FILES; try { if (empty($_FILES['excel_file']['name'])) { throw new Exception('File tidak boleh kosong'); } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } $jsonItems = wbRequest::getVarClean('items', 'str', ''); $industri_tahun = wbRequest::getVarClean('industri_tahun', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); if (!is_array($items)) { $data['message'] = 'Invalid items parameter'; return $data; } $file_name = $_FILES['excel_file']['name']; $file_location = 'var/uploadexcel/' . $file_name; if (!move_uploaded_file($_FILES['excel_file']['tmp_name'], $file_location)) { throw new Exception("Upload file gagal"); } $xl_reader =& new Spreadsheet_Excel_Reader(); $res = $xl_reader->_ole->read($file_location); if ($res === false) { if ($xl_reader->_ole->error == 1) { $data['message'] = 'Harus File Excel'; echo json_encode($data); session_write_close(); exit; } } try { $xl_reader->read($file_location); $firstColumn = $xl_reader->sheets[0]['cells'][1][1]; if (strtoupper($firstColumn) != 'DINAS KOPERASI, UKM, PERINDUSTRIAN DAN PERDAGANGAN') { throw new Exception('Format Table Salah'); } /* pengecekkan semua data */ for ($i = 8; $i <= $xl_reader->sheets[0]['numRows']; $i++) { $no = $xl_reader->sheets[0]['cells'][$i][1]; $param_name = $xl_reader->sheets[0]['cells'][$i][2]; $industri_jml_unit = $xl_reader->sheets[0]['cells'][$i][3]; $industri_jml_naker = $xl_reader->sheets[0]['cells'][$i][4]; if (strtoupper($no) == 'JUMLAH' or empty($no)) { break; } if (empty($param_name)) { throw new Exception('Jenis Industri (Kolom 2) pada baris ' . ($i - 1) . ' Tidak boleh kosong'); } } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } /* insert data */ $recInsert = array(); $items = array(); try { for ($i = 8; $i <= $xl_reader->sheets[0]['numRows']; $i++) { $no = $xl_reader->sheets[0]['cells'][$i][1]; $param_name = $xl_reader->sheets[0]['cells'][$i][2]; $industri_jml_unit = $xl_reader->sheets[0]['cells'][$i][3]; $industri_jml_naker = $xl_reader->sheets[0]['cells'][$i][4]; if (strtoupper($no) == 'JUMLAH' or empty($no)) { break; } $recInsert['industri_tahun'] = $industri_tahun; $recInsert['param_name'] = $param_name; $recInsert['industri_jml_unit'] = $industri_jml_unit; $recInsert['industri_jml_naker'] = $industri_jml_naker; $items[] = $recInsert; } $ws_client = self::getNusoap(); $params = array('search' => '', 'controller' => json_encode(array('module' => 'bds', 'class' => 't_industri', 'method' => 'upload_excel', 'type' => 'json')), 'jsonItems' => json_encode(array('items' => $items))); $ws_data = self::getResultData($ws_client, $params); if (!empty($ws_data['message'])) { throw new Exception($ws_data['message']); } $data['success'] = true; $data['message'] = 'Data berhasil disimpan'; $data['items'] = $items; } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } echo json_encode($data); session_write_close(); exit; }
public static function upload_excel($args = array()) { include 'lib/excel/reader.php'; $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); global $_FILES; try { if (empty($_FILES['excel_file']['name'])) { throw new Exception('File tidak boleh kosong'); } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); if (!is_array($items)) { $data['message'] = 'Invalid items parameter'; return $data; } $file_name = $_FILES['excel_file']['name']; $file_location = 'var/uploadexcel/' . $file_name; if (!move_uploaded_file($_FILES['excel_file']['tmp_name'], $file_location)) { throw new Exception("Upload file gagal"); } $xl_reader =& new Spreadsheet_Excel_Reader(); $res = $xl_reader->_ole->read($file_location); if ($res === false) { if ($xl_reader->_ole->error == 1) { $data['message'] = 'Harus File Excel'; echo json_encode($data); session_write_close(); exit; } } try { $xl_reader->read($file_location); $firstColumn = $xl_reader->sheets[0]['cells'][1][1]; if ($firstColumn != 'Kode Hotel') { throw new Exception('Format Table Salah'); } /* pengecekkan semua data */ for ($i = 2; $i <= $xl_reader->sheets[0]['numRows']; $i++) { $kode_hotel = $xl_reader->sheets[0]['cells'][$i][1]; $nama_hotel = $xl_reader->sheets[0]['cells'][$i][2]; if (empty($kode_hotel) or $kode_hotel == 'Keterangan') { break; } if (empty($nama_hotel)) { throw new Exception('Nama Hotel (Kolom 2) pada baris ' . ($i - 1) . ' Tidak boleh kosong'); } } } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } /* insert data */ $recInsert = array(); $items = array(); try { for ($i = 2; $i <= $xl_reader->sheets[0]['numRows']; $i++) { $kode_hotel = $xl_reader->sheets[0]['cells'][$i][1]; $nama_hotel = $xl_reader->sheets[0]['cells'][$i][2]; $kelas = $xl_reader->sheets[0]['cells'][$i][3]; $jumlah_kamar = $xl_reader->sheets[0]['cells'][$i][4]; $alamat = $xl_reader->sheets[0]['cells'][$i][5]; $kota = $xl_reader->sheets[0]['cells'][$i][6]; $kode_pos = $xl_reader->sheets[0]['cells'][$i][7]; $telepon = $xl_reader->sheets[0]['cells'][$i][8]; $website = $xl_reader->sheets[0]['cells'][$i][9]; if (empty($kode_hotel) or $kode_hotel == 'Keterangan') { break; } $recInsert['code'] = $kode_hotel; $recInsert['hotel_name'] = $nama_hotel; $recInsert['kelas_id'] = $kelas; $recInsert['jml_kamar'] = $jumlah_kamar; $recInsert['address_1'] = $alamat; $recInsert['kota'] = $kota; $recInsert['kode_pos'] = $kode_pos; $recInsert['phone_no'] = $telepon; $recInsert['website'] = $website; //$table->setRecord($recInsert); //$table->create(); $items[] = $recInsert; } $ws_client = self::getNusoap(); $params = array('search' => '', 'controller' => json_encode(array('module' => 'bds', 'class' => 'cust_acc_trans', 'method' => 'upload_excel', 'type' => 'json')), 'jsonItems' => json_encode(array('items' => $items))); $ws_data = self::getResultData($ws_client, $params); $data['success'] = true; $data['message'] = 'Data berhasil disimpan'; $data['items'] = $items; } catch (Exception $e) { $data['message'] = $e->getMessage(); echo json_encode($data); session_write_close(); exit; } echo json_encode($data); session_write_close(); exit; }
public static function submitSptpd($args = array()) { $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 't_vat_settlement'); $table->actionType = 'CREATE'; //$items = $item['items']; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { $user_name = wbSession::getVar('user_name'); foreach ($items as $item) { $sql = "select sikp.f_first_submit_engine(501," . $item['t_customer_order_id'] . ",'" . $user_name . "')"; $message = $table->dbconn->GetOne("{$sql}"); } $data['success'] = true; $data['message'] = $message; return $data; } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }
public static function deleteDSR($args = array()) { $jsonItems = wbRequest::getVarClean('items', 'str', ''); $item = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 'cust_acc_trans'); //$table->actionType = 'DELETE'; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { $user_name = wbSession::getVar('user_name'); $sql = "DELETE FROM t_cust_acc_dtl_trans a\r\n\t\t\t\t\tWHERE a.t_cust_account_id = " . $item['t_cust_account_id'] . "\r\n\t\t\t\t\tand not exists (select 1 from t_vat_setllement_dtl x where x.t_cust_acc_dtl_trans_id = a.t_cust_acc_dtl_trans_id)"; $items = $table->dbconn->GetItem($sql); $data['items'] = $item; $data['message'] = 'Berhasil'; $data['success'] = true; $data['items'] = $items; return $data; } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }
/** * update * controler for remove item */ public static function destroy($args = array()) { // Security check if (!wbSecurity::check('PWilayahPerson')) { return; } // Get arguments from argument array extract($args); $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items =& wbUtil::jsonDecode($jsonItems); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); $table =& wbModule::getModel('bds', 'p_wilayah_person'); try { $table->dbconn->BeginTrans(); if (is_array($items)) { foreach ($items as $key => $value) { if (empty($value)) { throw new Exception('Empty parameter'); } $table->remove($value); $data['items'][] = array($table->pkey => $value); $data['total']++; } } else { $items = (int) $items; if (empty($items)) { throw new Exception('Empty parameter'); } $table->remove($items); $data['items'][] = array($table->pkey => $items); $data['total'] = 1; } $data['success'] = true; $data['message'] = $data['total'] . ' Data berhasil dihapus'; $table->dbconn->CommitTrans(); } catch (Exception $e) { $table->dbconn->RollbackTrans(); $data['message'] = $e->getMessage(); $data['items'] = array(); $data['total'] = 0; } return $data; }
public static function submitSptpd($args = array()) { $jsonItems = wbRequest::getVarClean('items', 'str', ''); $items = wbUtil::jsonDecode($jsonItems); $table =& wbModule::getModel('bds', 't_vat_settlement'); $table->actionType = 'CREATE'; //$items = $item['items']; $data = array('items' => array(), 'total' => 0, 'success' => true, 'message' => ''); try { $data['success'] = false; $user_name = wbSession::getVar('user_name'); //f_before_submit_sptpd_wp(in_vat_setlement_id in number, i_user_name in varchar2) return varchar2 //foreach($items as $item){ //$sql="select sikp.f_first_submit_engine(501,".$item['t_customer_order_id'].",'".$user_name."')"; $sql = "select sikp.f_before_submit_sptpd_wp(" . $items['t_vat_setllement_id'] . ",'" . $user_name . "')"; $message = $table->dbconn->GetOne($sql); if (trim($message) == 'OK') { $sql = "select o_result_msg from sikp.f_first_submit_engine(501," . $items['t_customer_order_id'] . ",'" . $user_name . "')"; $message = $table->dbconn->GetOne($sql); if ($message == 'OK') { $sql = "select f_gen_vat_dtl_trans(" . $items['t_vat_setllement_id'] . ",'" . $user_name . "')"; $message = $table->dbconn->GetItem($sql); } $data['success'] = true; } //} $data['items'] = $items; $data['msg'] = $message; $data['message'] = $message; return $data; } catch (Exception $e) { $data['success'] = false; $data['message'] = $e->getMessage(); return $data; } }