public function dataset() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "uom_nama ILIKE '%" . $search . "%'"; $results = ZiUtil::search_result_jq_DB($query, $params, 'UOM'); return ZiUtil::dataset_json($results['query'], $results['total']); }
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 dataset() { $req = APP::request(); $get = $req->get(); $search = ZiUtil::is_set('search', $get); $query = "nama ILIKE '%" . $search . "%'"; $results = ZiUtil::search_result_jq_DB($query, $get, 'Principal'); 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 = "price_list_nama ILIKE '%" . $search . "%'"; } $results = ZiUtil::search_result_jq_DB($query, $params, 'PriceList'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function filter() { $grid["folder"] = "Stock"; $grid["title"] = "Daftar Item Price"; $cols[] = json_decode('{"field": "state", "checkbox": true}'); $cols[] = json_decode('{ "title": "Kode Item", "field": "item_kode"}'); $cols[] = json_decode('{ "title": "Tanggal Berakhir", "field": "expiry_date"}'); $cols[] = json_decode('{ "title": "", "field": "id"}'); $req = APP::request(); if ($req->isPost()) { $params = $req->post(); $grid["anchor"] = $params['anchor']; $grid["value"] = $params['value']; } $grid["url_add"] = App::urlFor("batch.a001"); $grid["url_edit"] = App::urlFor("batch.v005"); $grid["url_remove"] = App::urlFor("batch.d011"); $grid["source_url"] = App::urlFor("batch.dataset"); $grid["method"] = "POST"; $grid["cols"] = json_encode($cols); APP::render('batch/grid_batch', $grid); }
public function filter() { $grid["folder"] = "Stock"; $grid["title"] = "Daftar Item Price"; $cols[] = json_decode('{"field": "state", "checkbox": true}'); $cols[] = json_decode('{ "title": "Kode Item", "field": "item_kode"}'); $cols[] = json_decode('{ "title": "Price List", "field": "price_list"}'); $cols[] = json_decode('{ "title": "Harga", "field": "price_list_rate"}'); $cols[] = json_decode('{ "title": "", "field": "id", "visible": false}'); $req = APP::request(); if ($req->isPost()) { $params = $req->post(); $grid["anchor"] = $params['anchor']; $grid["value"] = $params['value']; } $grid["url_add"] = App::urlFor("itemprice.a001"); $grid["url_edit"] = App::urlFor("itemprice.v005"); $grid["url_remove"] = App::urlFor("itemprice.d011"); $grid["source_url"] = App::urlFor("itemprice.dataset"); $grid["method"] = "POST"; $grid["cols"] = json_encode($cols); APP::render('itemprice/grid_itemprice', $grid); }
public function dataset_stock_ledger() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "item_kode ILIKE '%" . $search . "%'"; $results = ZiUtil::search_result_jq_DB($query, $params, 'VStokLedger'); return ZiUtil::dataset_json($results['query'], $results['total']); }
public function dataset_penjualan() { $req = APP::request(); $params = $req->get(); $search = ZiUtil::is_set('search', $params); $query = "pasien_nama ILIKE '%" . $search . "%' and is_canceled = 0"; $results = ZiUtil::search_result_jq_DB($query, $params, 'SalesApotik'); return ZiUtil::dataset_json($results['query'], $results['total']); }