$array){ if(is_array($array)){ $input[$key] = $this->array_change_key_case_recursive($array, $case); } } return $input; } public function __construct(\Zend\Db\Adapter\Adapter $adapter, $config = array()) { parent::__construct($adapter, $config); /* get conn instance */ $this->_conn = $adapter->getDriver()->getConnection()->getResource(); //print_r($config); if (isset($config['tables'])) { $tables = $config['tables']; foreach ($tables as $key => $value) { if (array_key_exists($key, $this->_tables) && $value) { $this->_tables[$key] = $this->_($value); } } } } public function fetchAll(\Zend\Db\Sql\Select $select, $raw = true){ $statement = $this->_sql->prepareStatementForSqlObject($select); if ($result = $statement->execute()) { $resultset = new \Zend\Db\ResultSet\ResultSet(); $data = $resultset->initialize($result)->toArray(); return $data; } return false; } public function deleteGlobal($tabel, $where){ $stmt = $this->_db->query("delete from $tabel where $where "); return $stmt->execute(); } public function saveGlobal($atribut, $table){ $insert = $this->_sql->insert() ->into($table) ->values($atribut); $result = $this->execute($insert); return $result; } public function updateGlobal($tabel, $data, $where){ $update = $this->_sql->update() ->table($tabel) ->set($data) ->where($where); // echo str_replace('"','',$update->getSqlString());die; $result = $this->execute($update); return $result; } public function getLastSeqPostgree($tabel, $column){ $result = new Result(); $sql = " select max($column) as total from $tabel "; $stmt = $this->_db->query($sql); $proced = $stmt->execute(); $seq = $proced->current(); if ($seq) { $result->code = 0; $result->info = 'OK'; $result->data = $seq; } else { $result->code = 1; $result->info = 'Seq error'; } return $result; } /* cek duplikasi data */ public function checkDuplicateData($table, $column, $value, $msg){ $result = new Result(); try { $select = $this->select() ->from($table) ->where(array($column => $value)); //echo str_replace('"','',$select->getSqlString());die; $return = $this->fetchAll($select); if ($return) { $result->code = 100; $result->info = 'DUPLICATE "'.$msg.'" '; $result->data = $return; } else { $result->code = 0; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); } catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadParam($paramtype = NULL, $param_val3 = null, $param_parent = null){ $result = new Result(); try { $select = $this->select() ->from(array('' => 'master_parameter')); if($paramtype){ $select->where(array($this->_('param_type', '') . " = '" .$paramtype."'")); } if($param_val3){ $select->where(array($this->_('param_val3', '') . " = '" .$param_val3."'")); } if($param_parent){ $select->where(array($this->_('param_parent', '') . " = '" .$param_parent."'")); } $select->order(array('idm_parameter ASC')); // echo str_replace('"','',$select->getSqlString());die; $return = $this->fetchAll($select); if ($return) { $result->code = 0; $result->info = 'OK'; $result->data = $return; } else { $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); } catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } /* load data mitra */ public function loadProfileMap($role) { $result = new Result(); try { $sql = " select am.map_id, ua.access_name, ua.access_code, am.access_status from user_data_access ua, user_data_map am where ua.access_code=am.access_code and am.role_code='$role' "; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } /* get data tag */ public function getTypepost(){ $result = new Result(); try{ $select = $this->select() ->from(self::DATAUserexTYPE); if($data = $this->fetchAll($select)){ $result->code = 0; $result->info = 'OK'; $result->data = array_change_key_case($data); }else{ $result->code = 1; $result->info = 'not found'; $result->data = array_change_key_case($data); } }catch (\Exception $ex) { $result->code = 2; $result->info = 'Error:' . $ex->getMessage(); $result->data = $ex->getMessage(); } return $result; } /* load data user */ public function getUserData($tipe = null, $id = null){ $result = new Result(); try { $sql = " SELECT CASE concat ( 'Regional ', A.regional_id ) WHEN 'Regional ' THEN '-' ELSE concat ( 'Regional ', A.regional_id ) END Regional, A.*, b.NAME role_name, dw.divisi_witel_name witel FROM user_data_header A LEFT JOIN user_data_role b ON A.ROLE = b.access_role_code LEFT JOIN divisi_witel dw ON A.witel_id = dw.divisi_witel_id WHERE iduser IS NOT NULL"; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } /* load data user */ public function loadUserData($id = null){ $result = new Result(); try { $sql = " SELECT antrian_pasien.nama, antrian_pasien.no_antrian, dokter.nama_dokter, poli.nama_poli , dokter.kode_dokter FROM antrian_pasien -- INNER JOIN pasien -- ON pasien.id_pasien = pasien.id_pasien INNER JOIN dokter ON antrian_pasien.id_dokter = dokter.id_dokter INNER JOIN poli ON antrian_pasien.id_poli = poli.id_poli"; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } // print_r($listdata);die; if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadMaxCounter(){ $result = new Result(); try { $sql = " SELECT coalesce(MAX(id_pasien), 0) AS maxid FROM antrian_pasien "; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); $res = $resdata->current(); array_push($listdata,$res); if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata[0]['maxid'] + 1; } else { $result->code = 1; $result->info = 'failed get max number counter'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); } catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadRegisterPoli($id = null){ $result = new Result(); try { $sql = " SELECT * FROM poli"; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadRegisterDokter($id = null){ $result = new Result(); try { $sql = " SELECT * FROM dokter"; if ($id){ $sql .= " WHERE id_poli=$id AND id_condition='1'"; } $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadRegisterRuang($id = null){ $result = new Result(); try { $sql = " SELECT * FROM ruang"; if ($id){ $sql .= " WHERE id_poli=$id AND id_condition='1'"; } $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadCondition($id = null){ $result = new Result(); try { $sql = " SELECT * FROM condition"; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadRegisterAntrianData($id = null){ $result = new Result(); try { $sql = " SELECT register_dokter.id_register, dokter.nama_dokter, poli.nama_poli, ruang.nama_ruang,register_dokter.antrian_all,register_dokter.antrian_awal,register_dokter.antrian_akhir,register_dokter.waktu_antrian, register_dokter.create_date,register_dokter.jam_mulai FROM register_dokter INNER JOIN poli ON register_dokter.id_poli = poli.id_poli INNER JOIN dokter ON register_dokter.id_dokter = dokter.id_dokter INNER JOIN ruang ON register_dokter.id_ruang = ruang.id_ruang "; if($id){ $sql .= "WHERE register_dokter.id_register= $id AND register_dokter.id_register IS NOT NULL" ; } $sql .= " ORDER BY poli.nama_poli asc , register_dokter.create_date"; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadkelolapoli($id = null){ $result = new Result(); try { $sql = " SELECT * FROM poli"; if($id){ $sql .= " WHERE id_poli = $id "; } $sql .= " ORDER BY nama_poli ASC"; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadkeloladokter($id = null){ $result = new Result(); try { $sql = " SELECT dokter.id_dokter, dokter.nama_dokter, dokter.kode_dokter , poli.id_poli, poli.nama_poli, condition.condition,condition.id_condition FROM dokter INNER JOIN poli ON dokter.id_poli = poli.id_poli INNER JOIN condition ON condition.id_condition = dokter.id_condition "; if($id){ $sql .= " Where dokter.id_dokter = $id"; } $sql .= " ORDER BY nama_poli ASC"; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadkelolaruang($id = null){ $result = new Result(); try { $sql = "SELECT ruang.id_ruang, ruang.nama_ruang, poli.nama_poli,poli.id_poli, condition.condition,condition.id_condition FROM RUANG INNER JOIN poli ON ruang.id_poli = poli.id_poli INNER JOIN condition ON condition.id_condition = ruang.id_condition"; if($id){ $sql .= " WHERE ruang.id_ruang = $id "; } $sql .= " ORDER BY nama_poli ASC"; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadkelolaantrian($id){ $result = new Result(); try { $sql = "SELECT antrian_pasien.no_antrian,antrian_pasien.id_pasien, antrian_pasien.nama, dokter.kode_dokter , dokter.nama_dokter, dokter.id_dokter,poli.kode_poli, poli.nama_poli ,counter_status.status_code, counter_status.status_name FROM antrian_pasien INNER JOIN poli ON poli.id_poli = antrian_pasien.id_poli INNER JOIN dokter ON dokter.id_dokter = antrian_pasien.id_dokter INNER JOIN counter_status ON counter_status.status_code = antrian_pasien.status_code WHERE antrian_pasien.id_pasien IS NOT NULL AND antrian_pasien.status_code=60 "; $sql .= " ORDER BY poli.nama_poli asc , antrian_pasien.no_antrian asc" ; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function updatekelolaantrian($idpasien = null,$iddok = null){ $result = new Result(); try { $sql = "SELECT antrian_pasien.no_antrian,antrian_pasien.id_pasien, antrian_pasien.nama, dokter.kode_dokter , dokter.nama_dokter, dokter.id_dokter,poli.kode_poli, poli.nama_poli , counter_status.status_name FROM antrian_pasien INNER JOIN poli ON poli.id_poli = antrian_pasien.id_poli INNER JOIN dokter ON dokter.id_dokter = antrian_pasien.id_dokter INNER JOIN counter_status ON counter_status.status_code = antrian_pasien.status_code WHERE antrian_pasien.id_dokter=$iddok and antrian_pasien.id_pasien=$idpasien " ; // print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadPoli($id = null){ $result = new Result(); try { $sql = " SELECT poli.id_poli, poli.nama_poli FROM antrian_pasien INNER JOIN poli ON antrian_pasien.id_poli = poli.id_poli GROUP BY poli.id_poli"; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadDokter($id = null){ $result = new Result(); try { $sql = " SELECT * FROM dokter "; if ($id){ $sql .= " where id_poli=$id and id_condition='2' "; } $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function tampildokter(){ $result = new Result(); try { $sql = "SELECT dokter.id_dokter,dokter.image, dokter.nama_dokter , poli.nama_poli FROM dokter INNER JOIN poli ON dokter.id_poli = poli.id_poli ORDER BY nama_poli ASC "; // $sql .= " ORDER BY jumlah DESC"; //print_r($sql);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } // print_r($listdata);die; if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadPilihAntrian($iddok ){ $result = new Result(); try { $sql = "SELECT antrian_pasien.no_antrian, antrian_pasien.id_pasien, register_dokter.waktu_antrian , register_dokter.jam_mulai, antrian_pasien.status_code FROM antrian_pasien INNER JOIN register_dokter on antrian_pasien.id_dokter = register_dokter.id_dokter WHERE antrian_pasien.id_dokter= $iddok ORDER BY no_antrian ASC" ; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } // print_r($listdata); if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadAntrianAdmin($id = null){ $result = new Result(); try { $sql = "SELECT antrian_pasien.no_antrian, antrian_pasien.nama, dokter.kode_dokter , dokter.nama_dokter, dokter.id_dokter,poli.kode_poli, poli.nama_poli , counter_status.status_name FROM antrian_pasien INNER JOIN poli ON poli.id_poli = antrian_pasien.id_poli INNER JOIN dokter ON dokter.id_dokter = antrian_pasien.id_dokter INNER JOIN counter_status ON counter_status.status_code = antrian_pasien.status_code " ; if ($id){ $sql .= "WHERE antrian_pasien.id_pasien IS NOT NULL AND dokter.id_dokter = $id AND antrian_pasien.status_code=10 ORDER BY no_antrian ASC "; } $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } // print_r($listdata); if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadAntrian($id = null){ $result = new Result(); try { $sql = " SELECT DISTINCT on (idd.id_dokter) idd.id_dokter,idd.no_antrian,dok.nama_dokter,pol.nama_poli,dok.kode_dokter,rur.nama_ruang FROM antrian_pasien idd LEFT JOIN dokter dok on idd.id_dokter = dok.id_dokter LEFT JOIN poli pol on idd.id_poli = pol.id_poli LEFT JOIN ruang rur on idd.id_ruang = rur.id_ruang WHERE idd.id_pasien is not null and status_code=20 or status_code=30 or status_code =40"; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadNoAntrian($id = null ){ $result = new Result(); try { $sql = "SELECT antrian_pasien.no_antrian, antrian_pasien.id_dokter, dokter.kode_dokter, counter_status.status_name,counter_status.status_code FROM antrian_pasien INNER JOIN counter_status ON counter_status.status_code = antrian_pasien.status_code INNER JOIN dokter ON dokter.id_dokter = antrian_pasien.id_dokter " ; if ($id){ $sql .= "WHERE antrian_pasien.id_pasien IS NOT NULL AND dokter.id_dokter = $id AND antrian_pasien.status_code=10 or dokter.id_dokter = $id and antrian_pasien.status_code=30 or dokter.id_dokter = $id and antrian_pasien.status_code=40 ORDER BY no_antrian ASC"; } $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); foreach($resdata as $val){ // print_r($val);die; array_push($listdata, $val); } // print_r($listdata); if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; }else{ $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); }catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } public function loadUserCounter($status = null, $iddok = null, $no_antrian = null, $id_poli = null){ $result = new Result(); try { $sql = " SELECT antrian_pasien.no_antrian, dokter.nama_dokter , poli.nama_poli , counter_status.status_name FROM antrian_pasien INNER JOIN poli ON poli.id_poli = antrian_pasien.id_poli INNER JOIN dokter ON dokter.id_dokter = antrian_pasien.id_dokter INNER JOIN counter_status ON counter_status.status_code = antrian_pasien.status_code "; $sql .= " WHERE antrian_pasien.id_pasien IS NOT NULL AND dokter.id_dokter = $iddok ORDER BY no_antrian ASC LIMIT 1 " ; //print_r($mode);die; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); while($resdata->next()){ $res = $resdata->current(); array_push($listdata,$res); } //print_r($listdata);die; if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; } else { $result->code = 1; $result->info = 'failed load user counter'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); } catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } }