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 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 = "price_list_nama ILIKE '%" . $search . "%'";
}
$results = ZiUtil::search_result_jq_DB($query, $params, 'PriceList');
return ZiUtil::dataset_json($results['query'], $results['total']);
}
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']);
}
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 detail_penjualan($id)
{
$query = "parent = '" . $id . "'";
$results = SalesApotikDetail::all(array('conditions' => $query));
$total = SalesApotikDetail::count(array('conditions' => $query));
return ZiUtil::dataset_json($results, $total);
}
