function mgrid39()
{
$page = $this->input->post("page");
$limit = $this->input->post("rows");
$sidx = $this->input->post("sidx");
$sord = $this->input->post("sord");
if (!$sidx) {
$sidx = 1;
}
$wh = "";
$searchOn = $_REQUEST["_search"];
if ($searchOn == "true") {
$filters = $_REQUEST["filters"];
$obj = json_decode($filters, true);
$arr = $obj["rules"];
foreach ($arr as $field => $data) {
switch ($data["field"]) {
case "diag_kode":
$wh .= " and LOWER(diag_kode) like '%" . strtolower($data["data"]) . "%'";
break;
case "diag_nama":
$wh .= " and LOWER(diag_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "st_diag":
$wh .= " and LOWER(st_diag) like '%" . strtolower($data["data"]) . "%'";
break;
default:
$wh .= " and " . LOWER($data["field"]) . " like '" . strtolower($data["data"]) . "%'";
break;
}
}
}
$sql = "select diag_kode, diag_nama, diag_level,case when diag_aktif=1 then 'aktif' else 'tidak aktif' end \nas st_diag, diag_aktif,diag_id from billing.b_ms_diagnosa where 0=0 {$wh}";
$count = $this->m_global->total_row($sql);
$count > 0 ? $total_pages = ceil($count / $limit) : ($total_pages = 0);
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql = $sql . " order by " . $sidx . " " . $sord . " limit " . $limit . " offset " . $start;
$data1 = $this->m_global->grid_view($sql)->result_array();
$responce = new StdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
$no = 1;
foreach ($data1 as $line) {
$responce->rows[$i]['id'] = array($line['diag_id'], $line['diag_aktif']);
$responce->rows[$i]['cell'] = array($line['diag_kode'], $line['diag_nama'], $line['st_diag']);
$i++;
$no++;
}
echo json_encode($responce);
}
function mgrid07()
{
$page = $this->input->post("page");
$limit = $this->input->post("rows");
$sidx = $this->input->post("sidx");
$sord = $this->input->post("sord");
if (!$sidx) {
$sidx = 1;
}
$wh = "";
$searchOn = $_REQUEST["_search"];
if ($searchOn == "true") {
$filters = $_REQUEST["filters"];
$obj = json_decode($filters, true);
$arr = $obj["rules"];
foreach ($arr as $field => $data) {
switch ($data["field"]) {
case "user_name":
$wh .= " and LOWER(user_name) like '%" . strtolower($data["data"]) . "%'";
break;
case "user_pegawai":
$wh .= " and LOWER(user_pegawai) like '%" . strtolower($data["data"]) . "%'";
break;
case "group_nama":
$wh .= " and LOWER(group_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "st_user":
$wh .= " and LOWER(st_user) like '%" . strtolower($data["data"]) . "%'";
break;
default:
$wh .= " and " . LOWER($data["field"]) . " like '" . strtolower($data["data"]) . "%'";
break;
}
}
}
$sql = "select user_id,user_name,user_pwd,user_group_id, user_pegawai,if(user_aktif=1,'aktif','tidak aktif') st_user,user_aktif,group_id, group_nama from v_user where group_aktif=1 {$wh}";
$count = $this->m_global->total_row($sql);
$count > 0 ? $total_pages = ceil($count / $limit) : ($total_pages = 0);
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql = $sql . " order by " . $sidx . " " . $sord . " limit " . $limit . " offset " . $start;
$data1 = $this->m_global->grid_view($sql)->result_array();
$responce = new StdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
$no = 1;
foreach ($data1 as $line) {
$responce->rows[$i]['id'] = array($line['user_id'], $line['user_group_id'], $line['user_pwd'], $line['user_aktif']);
$responce->rows[$i]['cell'] = array($line['user_name'], $line['user_pegawai'], $line['group_nama'], $line['st_user']);
$i++;
$no++;
}
echo json_encode($responce);
}
function mgrid17()
{
$page = $this->input->post("page");
$limit = $this->input->post("rows");
$sidx = $this->input->post("sidx");
$sord = $this->input->post("sord");
if (!$sidx) {
$sidx = 1;
}
$wh = "";
$searchOn = $_REQUEST["_search"];
if ($searchOn == "true") {
$filters = $_REQUEST["filters"];
$obj = json_decode($filters, true);
$arr = $obj["rules"];
foreach ($arr as $field => $data) {
switch ($data["field"]) {
case "noinduk":
$wh .= " and LOWER(noinduk) like '%" . strtolower($data["data"]) . "%'";
break;
case "pas_nama":
$wh .= " and LOWER(pas_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "pas_tgl_lahir":
$wh .= " and LOWER(pas_tgl_lahir) like '%" . strtolower($data["data"]) . "%'";
break;
case "kun_th":
$wh .= " and LOWER(kun_th) like '%" . strtolower($data["data"]) . "%'";
break;
case "pas_sex":
$wh .= " and LOWER(pas_sex) like '%" . strtolower($data["data"]) . "%'";
break;
case "pas_alamat":
$wh .= " and LOWER(pas_alamat) like '%" . strtolower($data["data"]) . "%'";
break;
case "tujuan_nama":
$wh .= " and LOWER(tujuan_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "unit_nama":
$wh .= " and LOWER(unit_nama) like '%" . strtolower($data["data"]) . "%'";
break;
default:
$wh .= " and " . LOWER($data["field"]) . " like '" . strtolower($data["data"]) . "%'";
break;
}
}
}
$sql = "select pas_no, pas_kode_kk, concat(pas_no,'-',pas_kode_kk) noinduk,\npas_nama, pas_iskk, pas_kk, pas_sex,pas_noktp,pas_pekerjaan_id,pas_tgl_lahir, kun_th, kun_bln, kun_hr,kun_ku_id,\npas_asal, pas_kec_id, pas_desa_id, pas_alamat, pas_rt, pas_rw, \nkun_tujuan_id, kun_kp_id, kun_no_penjamin, kun_karcis,kun_no_seri,kun_unit_id, kun_pustu_id,kun_id, kun_tgl, kun_pas_id, tujuan_nama,\nkec_nama,desa_nama,unit_nama from v_kunjungan where 0=0 {$wh}";
$count = $this->m_global->total_row($sql);
$count > 0 ? $total_pages = ceil($count / $limit) : ($total_pages = 0);
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql = $sql . " order by " . $sidx . " " . $sord . " limit " . $limit . " offset " . $start;
$data1 = $this->m_global->grid_view($sql)->result_array();
$responce = new StdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
$no = 1;
foreach ($data1 as $line) {
$responce->rows[$i]['id'] = array($line['pas_no'], $line['pas_kode_kk'], $line['pas_iskk'], $line['pas_kk'], $line['pas_noktp'], $line['pas_pekerjaan_id'], $line['kun_bln'], $line['kun_hr'], $line['kun_ku_id'], $line['pas_rt'], $line['pas_rw'], $line['pas_asal'], $line['pas_kec_id'], $line['pas_desa_id'], $line['kun_tujuan_id'], $line['kun_kp_id'], $line['kun_no_penjamin'], $line['kun_karcis'], $line['kun_no_seri'], $line['kun_unit_id'], $line['kun_pustu_id'], $line['kun_id'], $line['kun_tgl'], $line['kun_pas_id']);
$responce->rows[$i]['cell'] = array($line['noinduk'], $line['pas_nama'], $line['pas_tgl_lahir'], $line['kun_th'], $line['pas_sex'], $line['pas_alamat'], $line['tujuan_nama'], $line['unit_nama']);
$i++;
$no++;
}
echo json_encode($responce);
}
function mgrid42()
{
$page = $this->input->post("page");
$limit = $this->input->post("rows");
$sidx = $this->input->post("sidx");
$sord = $this->input->post("sord");
if (!$sidx) {
$sidx = 1;
}
$wh = "";
$searchOn = $_REQUEST["_search"];
if ($searchOn == "true") {
$filters = $_REQUEST["filters"];
$obj = json_decode($filters, true);
$arr = $obj["rules"];
foreach ($arr as $field => $data) {
switch ($data["field"]) {
case "per_nama":
$wh .= " and LOWER(per_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "kota_nama":
$wh .= " and LOWER(kota_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "per_alamat":
$wh .= " and LOWER(per_alamat) like '%" . strtolower($data["data"]) . "%'";
break;
case "per_notlp":
$wh .= " and LOWER(per_notlp) like '%" . strtolower($data["data"]) . "%'";
break;
case "per_fax":
$wh .= " and LOWER(per_fax) like '%" . strtolower($data["data"]) . "%'";
break;
case "per_dir":
$wh .= " and LOWER(per_dir) like '%" . strtolower($data["data"]) . "%'";
break;
case "kategori_nama":
$wh .= " and LOWER(kategori_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "seksi_nama":
$wh .= " and LOWER(seksi_nama) like '%" . strtolower($data["data"]) . "%'";
break;
case "parent_utama":
$wh .= " and LOWER(parent_utama) like '%" . strtolower($data["data"]) . "%'";
break;
default:
$wh .= " and " . LOWER($data["field"]) . " like '" . strtolower($data["data"]) . "%'";
break;
}
}
}
$sql = "select perusahaan.per_nama, m_kota.kota_nama, perusahaan.per_alamat, perusahaan.per_notlp, perusahaan.per_fax, perusahaan.per_dir, perusahaan.per_kp, perusahaan.per_jkp, perusahaan.per_notlp_kp, m_kategori.kategori_nama, m_seksi.seksi_nama, m_struktur.parent_utama , perusahaan.per_id,per_kota_id,per_seksi_id,per_kategori_id\nfrom perusahaan left join m_kota on (perusahaan.per_kota_id = m_kota.kota_id) left join m_kategori on (perusahaan.per_kategori_id = m_kategori.kategori_id) left join m_seksi on (perusahaan.per_seksi_id = m_seksi.seksi_id) left join m_struktur on (perusahaan.per_kode = m_struktur.struktur_id)\n where 0=0 {$wh}";
$count = $this->m_global->total_row($sql);
$count > 0 ? $total_pages = ceil($count / $limit) : ($total_pages = 0);
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$sql = $sql . " order by " . $sidx . " " . $sord . " limit " . $limit . " offset " . $start;
$data1 = $this->m_global->grid_view($sql)->result_array();
$responce = new StdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
$no = 1;
foreach ($data1 as $line) {
$responce->rows[$i]['id'] = array($line['per_id'], $line['per_kp'], $line['per_jkp'], $line['per_notlp_kp'], $line['per_kota_id'], $line['per_seksi_id'], $line['per_kategori_id']);
$responce->rows[$i]['cell'] = array($line['per_nama'], $line['kota_nama'], $line['per_alamat'], $line['per_notlp'], $line['per_fax'], $line['per_dir'], $line['kategori_nama'], $line['seksi_nama'], $line['parent_utama']);
$i++;
$no++;
}
echo json_encode($responce);
}
