本文整理汇总了PHP中Konek::getJml方法的典型用法代码示例。如果您正苦于以下问题:PHP Konek::getJml方法的具体用法?PHP Konek::getJml怎么用?PHP Konek::getJml使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Konek
的用法示例。
在下文中一共展示了Konek::getJml方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: xajaxResponse
//.........这里部分代码省略.........
$kon->execute();
$id_pasien = $last_id;
//$objResponse->addAssign("debug", "innerHTML", $id_pasien);
} else {
$sql1 = "
UPDATE pasien SET
nama= '".$value[nama]."',
tempat_lahir = '".$value[tempat_lahir]."',
tgl_lahir= '".$value[tgl_lahir_thn]."-".$value[tgl_lahir_bln]."-".$value[tgl_lahir_tgl]."',
gol_darah = NULLIF('".$value[gol_darah_id]."', ''),
sex= '".$value[sex]."',
agama= '".$value[agama]."',
pendidikan_id= '".$value[pendidikan_id]."',
pekerjaan_id= '".$value[pekerjaan_id]."',
status_nikah= '".$value[status_nikah]."',
alamat= '".$value[alamat]."',
rt= '".$value[rt]."',
rw= '".$value[rw]."',
desa_id= '".$value[desa_id]."',
telp= '".$value[telp]."',
nama_ayah='".$value[nama_ayah]."',
nama_ibu='".$value[nama_ibu]."',
nama_suami='".$value[nama_suami]."',
nama_istri='".$value[nama_istri]."',
no_ktp_sim='".$value[no_ktp_sim]."',
update_user='".$_SESSION[username]."',
update_time=NOW(),
kode_petugas='".$value[nama_petugas]."' WHERE id = '".$value[id_pasien]."'";
$kon->sql = $sql1;
$kon->execute();
//$afek = $kon->affected_rows;
$afek = $kon->getJml();
//$afek = -1;
$last_id = $value[id];
$sql = "SELECT p.id as id, CONCAT_WS('-', SUBSTRING(p.id, 1,2), SUBSTRING(p.id, 3,2), SUBSTRING(p.id, 5,2), SUBSTRING(p.id, 7,2)) as id_display FROM pasien p WHERE id='".$value[id_pasien]."'";
$kon->sql = $sql;
$kon->execute();
$data = $kon->getOne();
//update no rekam medis
$sql = "UPDATE pasien SET no_rm ='".$data[id_display]."' WHERE id = '".$value[id_pasien]."'";
$kon->sql = $sql;
$kon->execute();
$id = $value[id];
//$objResponse->addAssign("debug", "innerHTML",$id);
}
if($afek < 0) {
$objResponse->addAlert("Data Tidak Dapat Disimpan.\nCek kembali Nomor Rekam Medis.");
//$objResponse->addAssign("debug", "innerHTML", $afek);
$objResponse->addScriptCall("fokus", "id");
} else {
//$objResponse->addAssign("debug", "innerHTML", $sql);
/*
tambah data kunjungan
*/
$sql_kunjungan_ke = "
SELECT
CASE
示例2: NULLIF
function simpan_kunjungan($value) {
$cleaner = new FormCleaner;
$cleaner->setValue($value);
$cleaner->clean();
$val = $cleaner->getValue();
$kon = new Konek;
if($val[beri_resep]==1){
$resep="YA";
}else{
$resep="TIDAK";
}
//update beri resep
$sql = "
UPDATE
kunjungan
SET
resep='".$resep."'
WHERE
id = '".$val[input_id_kunjungan]."'
";
$kon->sql = $sql;
$kon->execute();
//update
$sql = "
UPDATE
kunjungan_kamar
SET
dokter_id = NULLIF('".$val[input_dokter_id]."', ''),
diagnosa_utama_id = NULLIF('".$val[input_diagnosa_utama]."', '')
WHERE
id = '".$val[input_id_kunjungan_kamar]."'
";
$kon->sql = $sql;
$kon->execute();
//$afek = $kon->affected_rows;
$afek = $kon->getJml();
$temp = $sql;
$objResponse = new xajaxResponse();
//$objResponse->addAlert($temp);
//$objResponse->addAlert(print_r($val));
//$objResponse->addAppend("debug", "innerHTML", $mampu_bayar);
//INSERT UPDATE KARCIS
for($i=0;$i<sizeof($val[input_karcis]);$i++) {
$kunci = key($val[input_karcis]);
//get
/* BAGI BAYAR => BHP+JASA */
$biaya_bhp = 0;
$biaya_jasa = 0;
$selisih_biaya = 0;
$biaya_bhp = round($val[input_karcis_biaya_bhp][$kunci]);
$biaya_jasa = round($val[input_karcis_biaya_jasa][$kunci]);
$selisih_biaya = $val[input_karcis_biaya][$kunci]-$biaya_bhp-$biaya_jasa;
$biaya_jasa += $selisih_biaya;
$bayar_bhp = 0;
$bayar_jasa = 0;
$selisih_bayar = 0;
$bayar_bhp = round($val[input_karcis_biaya_bhp][$kunci]);
$bayar_jasa = round($val[input_karcis_biaya_jasa][$kunci]);
$selisih_bayar = $val[input_karcis_bayar][$kunci]-$bayar_bhp-$bayar_jasa;
$bayar_jasa += $selisih_bayar;
if(!$val[input_kunjungan_karcis_id][$kunci]) {
//insert
$sql = "
INSERT INTO
kunjungan_bayar (
nama,
kunjungan_kamar_id,
karcis_id,
hak_id,
biaya_bhp,
biaya_jasa,
jumlah,
bayar_bhp,
bhp_p,
bhp_rs,
bhp_rs_adm,
bhp_rs_op,
bayar_jasa,
jasa_p,
jasa_rs,
jasa_rs_op,
jasa_rs_kembang,
jasa_rs_adm,
jasa_rs_sdm,
spesialis,
spesialis_pendamping,
ugp,
grabaf,
perawat,
penunjang,
zakat,
pajak,
tgl
//.........这里部分代码省略.........
示例3: xajaxResponse
function simpan_kunjungan($value) {
$cleaner = new FormCleaner;
$cleaner->setValue($value);
$cleaner->clean();
$val = $cleaner->getValue();
$kon = new Konek;
//update
$kon->sql = "
UPDATE
kunjungan
SET
keadaan_keluar = '".$val[input_keadaan_keluar]."'
WHERE
id = '".$val[input_id_kunjungan]."'
";
$kon->execute();
$sql = "
UPDATE
kunjungan_kamar
SET
kelanjutan = '".$val[input_kelanjutan]."',
tgl_keluar = '".$val[input_tgl_keluar_thn]."-".$val[input_tgl_keluar_bln]."-".$val[input_tgl_keluar_tgl]." ".$val[input_tgl_keluar_jam].":".$val[input_tgl_keluar_mnt].":00'
WHERE
id = '".$val[input_id_kunjungan_kamar]."'
";
//}
$kon->sql = $sql;
$kon->execute();
$afek = $kon->getJml();
$objResponse = new xajaxResponse();
//$objResponse->addAssign("debug", "innerHTML", $sql);
if($afek < 0) {
$objResponse->addAlert("Data Pemulangan Tidak Dapat Disimpan\nHubungi Bagian SIM.");
} else {
$objResponse->addScriptCall("list_data", "0");
$objResponse->addScriptCall("xajax_tutup_kunjungan");
$objResponse->addScriptCall("show_status_simpan");
}
return $objResponse;
}
示例4: simpan_kunjungan
//.........这里部分代码省略.........
$kon->sql = $sql;
//$objResponse->addAppend("debug", "innerHTML", $sql);
$kon->execute();}
}else{
//update
$kon->sql = "
UPDATE
kunjungan
SET
keadaan_keluar = '".$val[input_keadaan_keluar]."',resep = '".$resep."'
WHERE
id = '".$val[input_id_kunjungan]."'
";
$kon->execute();
//update
$sql = "
UPDATE
kunjungan_kamar
SET
status_periksa = 1,
dokter_id = NULLIF('".$val[input_dokter_id]."', ''),
kelanjutan = NULLIF('".$val[input_kelanjutan]."',''),
diagnosa_utama_id = NULLIF('".$val[input_diagnosa_utama]."', '')
WHERE
id = '".$val[input_id_kunjungan_kamar]."'
";
$kon->sql = $sql;
$kon->execute();
}
//$afek = $kon->affected_rows;
$afek = $kon->getJml();
$objResponse = new xajaxResponse();
//$objResponse->addAlert(print_r($val));
//$objResponse->addAppend("debug", "innerHTML", $mampu_bayar);
//INSERT UPDATE KARCIS
for($i = 0; $i < sizeof($val[input_karcis]); $i++) {
$kunci = key($val[input_karcis]);
//get
/*
* $kon->sql = "SELECT * FROM karcis WHERE id = '".$val[input_karcis][$kunci]."'";
* $kon->execute();
* $data_karcis[$i] = $kon->getOne();
* $jasa_p[$i] = $data_karcis[$i][jasa_p] * $val[input_karcis_bayar][$kunci];
* $jasa_rs[$i] = $data_karcis[$i][jasa_rs] * $val[input_karcis_bayar][$kunci];
* $jasa_rs_op[$i] = $data_karcis[$i][jasa_rs_op] * $val[input_karcis_bayar][$kunci];
* $jasa_rs_kembang[$i] = $data_karcis[$i][jasa_rs_kembang] * $val[input_karcis_bayar][$kunci];
* $jasa_rs_adm[$i] = $data_karcis[$i][jasa_rs_adm] * $val[input_karcis_bayar][$kunci];
* $jasa_rs_sdm[$i] = $data_karcis[$i][jasa_rs_sdm] * $val[input_karcis_bayar][$kunci];
* $spesialis[$i] = $data_karcis[$i][spesialis] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $spesialis_pendamping[$i] = $data_karcis[$i][spesialis_pendamping] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $ugp[$i] = $data_karcis[$i][ugp] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $grabaf[$i] = $data_karcis[$i][grabaf] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $perawat[$i] = $data_karcis[$i][perawat] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $penunjang[$i] = $data_karcis[$i][penunjang] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $zakat[$i] = $data_karcis[$i][zakat] * $val[input_karcis_bayar][$kunci] * $data_karcis[$i][netto];
* $pajak[$i] = $data_karcis[$i][pajak] * ($val[input_karcis_bayar][$kunci] - ($jasa_p[$i] + $jasa_rs_op[$i] + $jasa_rs_kembang[$i] + $jasa_rs_adm[$i] + $jasa_rs_sdm[$i]));
* //$objResponse->addAlert("pajak : " . $pajak[$i]);
*/
/* BAGI BAYAR => BHP+JASA */
$biaya_bhp = 0;
示例5: xajaxResponse
//.........这里部分代码省略.........
$kon->sql = $sql;
$kon->execute();
$id_pasien = $last_id;
} else {
$sql1 = "
UPDATE pasien SET
nama= '".$value[nama]."',
tempat_lahir = '".$value[tempat_lahir]."',
tgl_lahir= '".$value[tgl_lahir_thn]."-".$value[tgl_lahir_bln]."-".$value[tgl_lahir_tgl]."',
gol_darah = NULLIF('".$value[gol_darah_id]."', ''),
sex= '".$value[sex]."',
agama= '".$value[agama]."',
pendidikan_id= '".$value[pendidikan_id]."',
pekerjaan_id= '".$value[pekerjaan_id]."',
status_nikah= '".$value[status_nikah]."',
alamat= '".$value[alamat]."',
rt= '".$value[rt]."',
rw= '".$value[rw]."',
desa_id= '".$value[desa_id]."',
telp= '".$value[telp]."',
nama_ayah='".$value[nama_ayah]."',
nama_ibu='".$value[nama_ibu]."',
nama_suami='".$value[nama_suami]."',
nama_istri='".$value[nama_istri]."',
no_ktp_sim='".$value[no_ktp_sim]."',
update_user='".$_SESSION[username]."',
update_time=NOW(),
kode_petugas='".$value[nama_petugas]."' WHERE id = '".$value[id_pasien]."'";
$kon->sql = $sql1;
$kon->execute();
//$afek = $kon->affected_rows;
$afek = $kon->getJml();
//$afek = -1;
$last_id = $value[id];
$sql = "SELECT p.id as id, CONCAT_WS('-', SUBSTRING(p.id, 1,2), SUBSTRING(p.id, 3,2), SUBSTRING(p.id, 5,2), SUBSTRING(p.id, 7,2)) as id_display FROM pasien p WHERE id='".$value[id_pasien]."'";
$kon->sql = $sql;
$kon->execute();
$data = $kon->getOne();
//update no rekam medis
$sql = "UPDATE pasien SET no_rm ='".$data[id_display]."' WHERE id = '".$value[id_pasien]."'";
$kon->sql = $sql;
$kon->execute();
$id = $value[id];
}
if($afek < 0) {
$objResponse->addAlert("Data Tidak Dapat Disimpan.\nCek kembali Nomor Rekam Medis.");
//$objResponse->addAssign("debug", "innerHTML", $sql);
$objResponse->addScriptCall("fokus", "id");
} else {
$sql_kunjungan = "
INSERT INTO
radio_kunjungan(
pasien_id,
kelas,
tgl_daftar,
tgl_periksa,
pengirim,
cara_masuk,
cara_bayar,