public function grupitem() { $req = APP::request(); $get = $req->get(); $search = ZiUtil::is_set('search', $get); $query = "item_grup_nama ILIKE '%" . $search . "%'"; $results = ZiUtil::search_result_DB($query, $get, 'ItemGrup'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function dokter() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "pgw_nama ILIKE '%" . $search . "%' AND pgw_jenis_pegawai = 1"; $results = ZiUtil::search_result_DB($query, $params, 'Dokter'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function stockEntries() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $item_kode = ZiUtil::is_set('item_kode', $params); $query = "item ILIKE '%" . $search . "%' AND item_kode ='" . $item_kode . "'"; $results = ZiUtil::search_result_DB($query, $params, 'Batch'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function reg_pasien() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $params["sort"] = "cust_usr_nama"; $params["order"] = "ASC"; $query = "cust_usr_nama ILIKE '%" . $search . "%' OR cust_usr_kode LIKE '%" . $search . "%'"; $results = ZiUtil::search_result_DB($query, $params, 'RegPasien'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function dataset() { $req = APP::request(); if ($req->isPost()) { $params = $req->post(); $search = ZiUtil::is_set('search', $params); $query = "id = '" . $search . "'"; } else { $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "warehouse_nama ILIKE '%" . $search . "%'"; } $results = ZiUtil::search_result_DB($query, $params, 'Warehouse'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function entrytipe() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "entry_tipe_nama ILIKE '%" . $search . "%'"; $results = ZiUtil::search_result_DB($query, $params, 'StokEntryTipe'); return ZiUtil::dataset_json($results['query'], $results['total']); }