PHP ZiUtil::search_result_jq_DB Examples

Example #1

File: UnitOM.php Project: suryakencana/tekkadan

 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']);
 }

Example #2

File: Principal.php Project: suryakencana/tekkadan

 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']);
 }

Example #3

File: Item.php Project: suryakencana/tekkadan

 public function dataset()
 {
     $req = APP::request();
     if ($req->isPost()) {
         $params = $req->post();
         $search = ZiUtil::is_set('search', $params);
         $query = "item_kode = '" . $search . "'";
     } else {
         $params = $req->get();
         $search = ZiUtil::is_set('search', $params);
         $query = "item_nama ILIKE '%" . $search . "%'";
     }
     $results = ZiUtil::search_result_jq_DB($query, $params, 'Item');
     return ZiUtil::dataset_json($results['query'], $results['total']);
 }

Example #4

File: Itemprice.php Project: suryakencana/tekkadan

 public function dataset()
 {
     $req = APP::request();
     if ($req->isPost()) {
         $params = json_decode($req->getBody(), 1);
         $anchor = $params['anchor'];
         $value = $params['value'];
         $query = "{$anchor} = '{$value}'";
     } else {
         $params = $req->get();
         $search = ZiUtil::is_set('search', $params);
         $query = "item_nama ILIKE '%" . $search . "%'";
     }
     $results = ZiUtil::search_result_jq_DB($query, $params, 'ItemPriceList');
     return ZiUtil::dataset_json($results['query'], $results['total']);
 }

Example #5

File: Stok.php Project: suryakencana/tekkadan

 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']);
 }

Example #6

File: Selling.php Project: suryakencana/tekkadan

 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']);
 }