Beispiel #1
0
 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']);
 }
Beispiel #2
0
 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']);
 }
Beispiel #3
0
 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']);
 }
Beispiel #4
0
 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']);
 }
Beispiel #5
0
 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']);
 }
Beispiel #6
0
 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);
 }
Beispiel #7
0
 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);
 }
Beispiel #8
0
 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']);
 }
Beispiel #9
0
 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']);
 }