当前位置: 首页>>代码示例>>PHP>>正文


PHP Konek::getJml方法代码示例

本文整理汇总了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
开发者ID:reekoheek,项目名称:srmis,代码行数:67,代码来源:rajal.php

示例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
//.........这里部分代码省略.........
开发者ID:reekoheek,项目名称:srmis,代码行数:101,代码来源:kunjungan.modal.php

示例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;
	}
开发者ID:reekoheek,项目名称:srmis,代码行数:44,代码来源:pemulangan.modal.php

示例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;
开发者ID:reekoheek,项目名称:srmis,代码行数:67,代码来源:kunjungan.modal.php

示例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,
开发者ID:reekoheek,项目名称:srmis,代码行数:67,代码来源:pendaftaran.php


注:本文中的Konek::getJml方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。