Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
@@ -0,0 +1,305 @@
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="parameter" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="namars" class="java.lang.String"/>
<parameter name="alamatrs" class="java.lang.String"/>
<parameter name="kotars" class="java.lang.String"/>
<parameter name="propinsirs" class="java.lang.String"/>
<parameter name="kontakrs" class="java.lang.String"/>
<parameter name="emailrs" class="java.lang.String"/>
<parameter name="logo" class="java.io.InputStream"/>
<parameter name="tanggal1" class="java.lang.String"/>
<parameter name="tanggal2" class="java.lang.String"/>
<queryString>
<![CDATA[select resep_obat.no_resep,resep_obat.tgl_peresepan,resep_obat.jam_peresepan,
resep_obat.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,resep_obat.kd_dokter,dokter.nm_dokter,
if(resep_obat.jam_peresepan=resep_obat.jam,'Belum Terlayani','Sudah Terlayani') as status
from resep_obat inner join reg_periksa inner join pasien inner join dokter on resep_obat.no_rawat=reg_periksa.no_rawat
and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and resep_obat.kd_dokter=dokter.kd_dokter where
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_resep like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_rawat like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.no_rkm_medis like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.nm_pasien like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and dokter.nm_dokter like $P{parameter} order by resep_obat.tgl_perawatan,resep_obat.jam]]>
</queryString>
<field name="no_resep" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="tgl_peresepan" class="java.sql.Date">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="jam_peresepan" class="java.sql.Time">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rawat" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rkm_medis" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_pasien" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="kd_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="status" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="84" splitType="Stretch">
<staticText>
<reportElement x="0" y="49" width="555" height="18"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="11" isBold="false"/>
</textElement>
<text><![CDATA[DAFTAR RESEP DOKTER]]></text>
</staticText>
<line>
<reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<textField>
<reportElement x="2" y="14" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="35" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="25" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="0" width="553" height="17"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression>
</textField>
<image scaleImage="FillFrame" onErrorType="Blank">
<reportElement x="0" y="2" width="48" height="45"/>
<imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression>
</image>
<line>
<reportElement x="0" y="48" width="555" height="1"/>
<graphicElement>
<pen lineWidth="2.0" lineStyle="Double"/>
</graphicElement>
</line>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="15" splitType="Stretch">
<staticText>
<reportElement mode="Opaque" x="108" y="0" width="47" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Jam]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="155" y="0" width="74" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Rawat]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="228" y="0" width="40" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.RM]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="268" y="0" width="119" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Nama Pasien]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="387" y="0" width="102" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Dokter]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="489" y="0" width="66" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Status]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="48" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Resep]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="48" y="0" width="61" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Tgl.Peresepan]]></text>
</staticText>
<line>
<reportElement x="0" y="14" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="11" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="2" y="0" width="46" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_resep}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy">
<reportElement mode="Transparent" x="48" y="0" width="61" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="HH:mm:ss">
<reportElement mode="Transparent" x="109" y="0" width="45" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.sql.Time"><![CDATA[$F{jam_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="155" y="0" width="73" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rawat}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="228" y="0" width="40" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rkm_medis}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="268" y="0" width="119" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_pasien}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="387" y="0" width="102" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_dokter}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="489" y="0" width="66" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{status}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="26" splitType="Stretch">
<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
</textField>
<line>
<reportElement x="0" y="0" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<line>
<reportElement x="0" y="23" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
BIN +57.9 KB (100%) dist/SIMRSKhanza.jar
Binary file not shown.
@@ -0,0 +1,305 @@
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="parameter" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="namars" class="java.lang.String"/>
<parameter name="alamatrs" class="java.lang.String"/>
<parameter name="kotars" class="java.lang.String"/>
<parameter name="propinsirs" class="java.lang.String"/>
<parameter name="kontakrs" class="java.lang.String"/>
<parameter name="emailrs" class="java.lang.String"/>
<parameter name="logo" class="java.io.InputStream"/>
<parameter name="tanggal1" class="java.lang.String"/>
<parameter name="tanggal2" class="java.lang.String"/>
<queryString>
<![CDATA[select resep_obat.no_resep,resep_obat.tgl_peresepan,resep_obat.jam_peresepan,
resep_obat.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,resep_obat.kd_dokter,dokter.nm_dokter,
if(resep_obat.jam_peresepan=resep_obat.jam,'Belum Terlayani','Sudah Terlayani') as status
from resep_obat inner join reg_periksa inner join pasien inner join dokter on resep_obat.no_rawat=reg_periksa.no_rawat
and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and resep_obat.kd_dokter=dokter.kd_dokter where
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_resep like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_rawat like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.no_rkm_medis like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.nm_pasien like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and dokter.nm_dokter like $P{parameter} order by resep_obat.tgl_perawatan,resep_obat.jam]]>
</queryString>
<field name="no_resep" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="tgl_peresepan" class="java.sql.Date">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="jam_peresepan" class="java.sql.Time">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rawat" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rkm_medis" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_pasien" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="kd_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="status" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="84" splitType="Stretch">
<staticText>
<reportElement x="0" y="49" width="555" height="18"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="11" isBold="false"/>
</textElement>
<text><![CDATA[DAFTAR RESEP DOKTER]]></text>
</staticText>
<line>
<reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<textField>
<reportElement x="2" y="14" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="35" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="25" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="0" width="553" height="17"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression>
</textField>
<image scaleImage="FillFrame" onErrorType="Blank">
<reportElement x="0" y="2" width="48" height="45"/>
<imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression>
</image>
<line>
<reportElement x="0" y="48" width="555" height="1"/>
<graphicElement>
<pen lineWidth="2.0" lineStyle="Double"/>
</graphicElement>
</line>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="15" splitType="Stretch">
<staticText>
<reportElement mode="Opaque" x="108" y="0" width="47" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Jam]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="155" y="0" width="74" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Rawat]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="228" y="0" width="40" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.RM]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="268" y="0" width="119" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Nama Pasien]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="387" y="0" width="102" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Dokter]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="489" y="0" width="66" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Status]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="48" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Resep]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="48" y="0" width="61" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Tgl.Peresepan]]></text>
</staticText>
<line>
<reportElement x="0" y="14" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="11" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="2" y="0" width="46" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_resep}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy">
<reportElement mode="Transparent" x="48" y="0" width="61" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="HH:mm:ss">
<reportElement mode="Transparent" x="109" y="0" width="45" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.sql.Time"><![CDATA[$F{jam_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="155" y="0" width="73" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rawat}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="228" y="0" width="40" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rkm_medis}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="268" y="0" width="119" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_pasien}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="387" y="0" width="102" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_dokter}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="489" y="0" width="66" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{status}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="26" splitType="Stretch">
<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
</textField>
<line>
<reportElement x="0" y="0" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<line>
<reportElement x="0" y="23" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
@@ -2,6 +2,14 @@
<project-private xmlns="http://www.netbeans.org/ns/project-private/1">
<editor-bookmarks xmlns="http://www.netbeans.org/ns/editor-bookmarks/2" lastBookmarkId="1"/>
<open-files xmlns="http://www.netbeans.org/ns/projectui-open-files/2">
<group/>
<group>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgDaftarPermintaanResep.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgPeresepanDokter.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/setting/DlgUser.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgResepObat.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgCariObat.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/simrskhanza/frmUtama.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/fungsi/var.java</file>
</group>
</open-files>
</project-private>
Binary file not shown.
@@ -0,0 +1,305 @@
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="parameter" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="namars" class="java.lang.String"/>
<parameter name="alamatrs" class="java.lang.String"/>
<parameter name="kotars" class="java.lang.String"/>
<parameter name="propinsirs" class="java.lang.String"/>
<parameter name="kontakrs" class="java.lang.String"/>
<parameter name="emailrs" class="java.lang.String"/>
<parameter name="logo" class="java.io.InputStream"/>
<parameter name="tanggal1" class="java.lang.String"/>
<parameter name="tanggal2" class="java.lang.String"/>
<queryString>
<![CDATA[select resep_obat.no_resep,resep_obat.tgl_peresepan,resep_obat.jam_peresepan,
resep_obat.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,resep_obat.kd_dokter,dokter.nm_dokter,
if(resep_obat.jam_peresepan=resep_obat.jam,'Belum Terlayani','Sudah Terlayani') as status
from resep_obat inner join reg_periksa inner join pasien inner join dokter on resep_obat.no_rawat=reg_periksa.no_rawat
and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and resep_obat.kd_dokter=dokter.kd_dokter where
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_resep like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and resep_obat.no_rawat like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.no_rkm_medis like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and pasien.nm_pasien like $P{parameter} or
resep_obat.tgl_perawatan between $P{tanggal1} and $P{tanggal2} and dokter.nm_dokter like $P{parameter} order by resep_obat.tgl_perawatan,resep_obat.jam]]>
</queryString>
<field name="no_resep" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="tgl_peresepan" class="java.sql.Date">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="jam_peresepan" class="java.sql.Time">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rawat" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="no_rkm_medis" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_pasien" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="kd_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="nm_dokter" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="status" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="84" splitType="Stretch">
<staticText>
<reportElement x="0" y="49" width="555" height="18"/>
<textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="11" isBold="false"/>
</textElement>
<text><![CDATA[DAFTAR RESEP DOKTER]]></text>
</staticText>
<line>
<reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<textField>
<reportElement x="2" y="14" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="35" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="25" width="553" height="14"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="9"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="2" y="0" width="553" height="17"/>
<textElement textAlignment="Center" lineSpacing="Single">
<font fontName="Tahoma" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression>
</textField>
<image scaleImage="FillFrame" onErrorType="Blank">
<reportElement x="0" y="2" width="48" height="45"/>
<imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression>
</image>
<line>
<reportElement x="0" y="48" width="555" height="1"/>
<graphicElement>
<pen lineWidth="2.0" lineStyle="Double"/>
</graphicElement>
</line>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="15" splitType="Stretch">
<staticText>
<reportElement mode="Opaque" x="108" y="0" width="47" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Jam]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="155" y="0" width="74" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Rawat]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="228" y="0" width="40" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.RM]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="268" y="0" width="119" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Nama Pasien]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="387" y="0" width="102" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Dokter]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="489" y="0" width="66" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Status]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="48" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[No.Resep]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="48" y="0" width="61" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
<textElement verticalAlignment="Middle" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Tgl.Peresepan]]></text>
</staticText>
<line>
<reportElement x="0" y="14" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="11" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="2" y="0" width="46" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_resep}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy">
<reportElement mode="Transparent" x="48" y="0" width="61" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="HH:mm:ss">
<reportElement mode="Transparent" x="109" y="0" width="45" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.sql.Time"><![CDATA[$F{jam_peresepan}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="155" y="0" width="73" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rawat}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="228" y="0" width="40" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rkm_medis}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="268" y="0" width="119" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_pasien}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="387" y="0" width="102" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_dokter}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement mode="Transparent" x="489" y="0" width="66" height="10"/>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{status}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="26" splitType="Stretch">
<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Right" lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField pattern="" isBlankWhenNull="false">
<reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
<box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement lineSpacing="Single">
<font fontName="Tahoma" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
</textField>
<line>
<reportElement x="0" y="0" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<line>
<reportElement x="0" y="23" width="555" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
BIN -25 Bytes (100%) resumepasien/UUtama.dcu
Binary file not shown.
@@ -197,7 +197,7 @@ object frmUtama: TfrmUtama
end
object PanelLogin: TsuiGroupBox
Left = 272
Top = 1000
Top = 10
Width = 409
Height = 241
UIStyle = MacOS
@@ -472,7 +472,7 @@ procedure TfrmUtama.btnLoginAdminClick(Sender: TObject);
ZQUser.Open;
if(ZQUser.RecordCount>0)then
begin
btnRegistrasi.Enabled:=StrToBool(ZQUsersidikjari.Value);
btnRegistrasi.Enabled:=StrToBool(ZQUserpasien.Value);
btnLogin.Caption:='Log-Out Admin';
panelfalse;
PanelHome.Visible:=true;
@@ -197,7 +197,7 @@ object frmUtama: TfrmUtama
end
object PanelLogin: TsuiGroupBox
Left = 272
Top = 1000
Top = 10
Width = 409
Height = 241
UIStyle = MacOS
@@ -967,7 +967,7 @@ begin
FinFPVer1.FPLoad(ZQSidikJarino_rkm_medis.AsString,0,ZQSidikJarisidikjari.Value,'MySecretKey');
ZQSidikJari.Next;
end;
pilihanform='Registrasi';
pilihanform:='Registrasi';
FinFPVer1.FPVerificationStart('');
end;

BIN +0 Bytes (100%) resumepasien/resume.exe
Binary file not shown.
154 sik.sql

Large diffs are not rendered by default.

@@ -56,7 +56,7 @@ public final class var {
mutasi_berkas=false,akun_piutang=false,harian_kso=false,bulanan_kso=false,harian_menejemen=false,bulanan_menejemen=false,inhealth_cek_eligibilitas=false,
inhealth_referensi_jenpel_ruang_rawat=false,inhealth_referensi_poli=false,inhealth_referensi_faskes=false,inhealth_sjp=false,piutang_ralan=false,
piutang_ranap=false,detail_piutang_penjab=false,lama_pelayanan_ralan=false,catatan_pasien=false,rl4b=false,rl4asebab=false,rl4bsebab=false,
data_HAIs=false,harian_HAIs=false,bulanan_HAIs=false,hitung_bor=false,perusahaan_pasien=false;
data_HAIs=false,harian_HAIs=false,bulanan_HAIs=false,hitung_bor=false,perusahaan_pasien=false,resep_dokter=false;

public static void setData(String user, String pass) {
try {
@@ -318,6 +318,7 @@ public static void setData(String user, String pass) {
var.bulanan_HAIs=true;
var.hitung_bor=true;
var.perusahaan_pasien=true;
var.resep_dokter;
}else */
if(rs.getRow()>=1){
var.kode="Admin Utama";
@@ -561,6 +562,7 @@ public static void setData(String user, String pass) {
var.bulanan_HAIs=true;
var.hitung_bor=true;
var.perusahaan_pasien=true;
var.resep_dokter=true;
}else if(rs2.getRow()>=1){
rs2.beforeFirst();
rs2.next();
@@ -805,6 +807,7 @@ public static void setData(String user, String pass) {
var.bulanan_HAIs=rs2.getBoolean("bulanan_HAIs");
var.hitung_bor=rs2.getBoolean("hitung_bor");
var.perusahaan_pasien=rs2.getBoolean("perusahaan_pasien");
var.resep_dokter=rs2.getBoolean("resep_dokter");
}else if((rs.getRow()==0)&&(rs2.getRow()==0)){
var.kode="";
var.penyakit= false;
@@ -1047,6 +1050,7 @@ public static void setData(String user, String pass) {
var.bulanan_HAIs=false;
var.hitung_bor=false;
var.perusahaan_pasien=false;
var.resep_dokter=false;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
@@ -1335,4 +1339,5 @@ public static void setData(String user, String pass) {
public static boolean getbulanan_HAIs(){return var.bulanan_HAIs;}
public static boolean gethitung_bor(){return var.hitung_bor;}
public static boolean getperusahaan_pasien(){return var.perusahaan_pasien;}
public static boolean getresep_dokter(){return var.resep_dokter;}
}
@@ -571,7 +571,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="07-10-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -38,7 +38,6 @@
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import simrskhanza.DlgCariBangsal;
import simrskhanza.DlgResepObat;
import widget.Button;

/**
@@ -57,7 +56,7 @@ public final class DlgCariObat extends javax.swing.JDialog {
private boolean[] pilih;
private double[] jumlah,harga,eb,ts,stok,beli;
private String[] kodebarang,namabarang,kodesatuan,letakbarang,namajenis,aturan,industri;
private String bangsal="",bangsaldefault=Sequel.cariIsi("select kd_bangsal from set_lokasi limit 1"),tampilkan_ppnobat_ralan="";
private String noresep="",bangsal="",bangsaldefault=Sequel.cariIsi("select kd_bangsal from set_lokasi limit 1"),tampilkan_ppnobat_ralan="";
private DlgCariBangsal caribangsal=new DlgCariBangsal(null,false);
public DlgBarang barang=new DlgBarang(null,false);
public DlgAturanPakai aturanpakai=new DlgAturanPakai(null,false);
@@ -554,7 +553,7 @@ public void itemStateChanged(java.awt.event.ItemEvent evt) {

DTPTgl.setEditable(false);
DTPTgl.setForeground(new java.awt.Color(50, 70, 50));
DTPTgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09-09-2017" }));
DTPTgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09-10-2017" }));
DTPTgl.setDisplayFormat("dd-MM-yyyy");
DTPTgl.setName("DTPTgl"); // NOI18N
DTPTgl.setOpaque(false);
@@ -994,6 +993,9 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
}
tbObat.setValueAt("",i,1);
}
if(!noresep.equals("")){
Sequel.mengedit("resep_obat","no_resep='"+noresep+"'","tgl_perawatan='"+Valid.SetTgl(DTPTgl.getSelectedItem()+"")+"',jam='"+cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem()+"'");
}
koneksi.setAutoCommit(true);
LTotal.setText("0");
LPpn.setText("0");
@@ -1056,7 +1058,9 @@ private void formWindowActivated(java.awt.event.WindowEvent evt) {//GEN-FIRST:ev
}//GEN-LAST:event_formWindowActivated

private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened
tampilobat();
if(noresep.equals("")){
tampilobat();
}
}//GEN-LAST:event_formWindowOpened

private void ChkNoResepItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_ChkNoResepItemStateChanged
@@ -1381,6 +1385,194 @@ public void tampilobat() {
System.out.println("Notifikasi : "+e);
}
}

public void tampilobat2(String no_resep) {
this.noresep=no_resep;
ChkNoResep.setSelected(false);
z=0;
for(i=0;i<tbObat.getRowCount();i++){
if(!tbObat.getValueAt(i,0).toString().equals("")){
z++;
}
}

pilih=null;
pilih=new boolean[z];
jumlah=null;
jumlah=new double[z];
harga=null;
harga=new double[z];
eb=null;
eb=new double[z];
ts=null;
ts=new double[z];
stok=null;
stok=new double[z];
kodebarang=null;
kodebarang=new String[z];
namabarang=null;
namabarang=new String[z];
kodesatuan=null;
kodesatuan=new String[z];
letakbarang=null;
letakbarang=new String[z];
namajenis=null;
namajenis=new String[z];
aturan=null;
aturan=new String[z];
industri=null;
industri=new String[z];
beli=null;
beli=new double[z];
z=0;
for(i=0;i<tbObat.getRowCount();i++){
if(!tbObat.getValueAt(i,1).toString().equals("")){
pilih[z]=Boolean.parseBoolean(tbObat.getValueAt(i,0).toString());
try {
jumlah[z]=Double.parseDouble(tbObat.getValueAt(i,1).toString());
} catch (Exception e) {
jumlah[z]=0;
}
kodebarang[z]=tbObat.getValueAt(i,2).toString();
namabarang[z]=tbObat.getValueAt(i,3).toString();
kodesatuan[z]=tbObat.getValueAt(i,4).toString();
letakbarang[z]=tbObat.getValueAt(i,5).toString();
try {
harga[z]=Double.parseDouble(tbObat.getValueAt(i,6).toString());
} catch (Exception e) {
harga[z]=0;
}
namajenis[z]=tbObat.getValueAt(i,7).toString();
try {
eb[z]=Double.parseDouble(tbObat.getValueAt(i,8).toString());
} catch (Exception e) {
eb[z]=0;
}
try {
ts[z]=Double.parseDouble(tbObat.getValueAt(i,9).toString());
} catch (Exception e) {
ts[z]=0;
}
try {
stok[z]=Double.parseDouble(tbObat.getValueAt(i,10).toString());
} catch (Exception e) {
stok[z]=0;
}
aturan[z]=tbObat.getValueAt(i,11).toString();
industri[z]=tbObat.getValueAt(i,12).toString();
try {
beli[z]=Double.parseDouble(tbObat.getValueAt(i,13).toString());
} catch (Exception e) {
beli[z]=0;
}
z++;
}
}

Valid.tabelKosong(tabModeobat);

for(i=0;i<z;i++){
tabModeobat.addRow(new Object[] {
pilih[i],jumlah[i],kodebarang[i],namabarang[i],kodesatuan[i],letakbarang[i],harga[i],namajenis[i],eb[i],ts[i],stok[i],aturan[i],industri[i],beli[i]
});
}

try {
psobat=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama, "+
"databarang.kode_sat,databarang.karyawan,databarang.ralan,"+
"databarang.beliluar,databarang.letak_barang,databarang.utama,"+
"industrifarmasi.nama_industri,databarang.h_beli,resep_dokter.jml, "+
"resep_dokter.aturan_pakai from databarang inner join jenis "+
" inner join industrifarmasi inner join resep_dokter on databarang.kdjns=jenis.kdjns "+
" and industrifarmasi.kode_industri=databarang.kode_industri "+
" and resep_dokter.kode_brng=databarang.kode_brng "+
" where resep_dokter.no_resep=? and databarang.status='1' and databarang.kode_brng like ? or "+
" resep_dokter.no_resep=? and databarang.status='1' and databarang.nama_brng like ? or "+
" resep_dokter.no_resep=? and databarang.status='1' and jenis.nama like ? order by databarang.nama_brng");
psobatasuransi=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama, "+
"databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,"+
" databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli, "+
" resep_dokter.jml, resep_dokter.aturan_pakai from databarang inner join jenis "+
" inner join industrifarmasi inner join resep_dokter on databarang.kdjns=jenis.kdjns "+
" and industrifarmasi.kode_industri=databarang.kode_industri "+
" and resep_dokter.kode_brng=databarang.kode_brng "+
" where resep_dokter.no_resep=? and databarang.status='1' and databarang.kode_brng like ? or "+
" resep_dokter.no_resep=? and databarang.status='1' and databarang.nama_brng like ? or "+
" resep_dokter.no_resep=? and databarang.status='1' and jenis.nama like ? order by databarang.nama_brng");
try{
if(kenaikan>0){
psobatasuransi.setDouble(1,kenaikan);
psobatasuransi.setString(2,no_resep);
psobatasuransi.setString(3,"%"+TCari.getText().trim()+"%");
psobatasuransi.setString(4,no_resep);
psobatasuransi.setString(5,"%"+TCari.getText().trim()+"%");
psobatasuransi.setString(6,no_resep);
psobatasuransi.setString(7,"%"+TCari.getText().trim()+"%");
rsobat=psobatasuransi.executeQuery();
while(rsobat.next()){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("harga"),100),
rsobat.getString("nama"),0,0,0,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("h_beli")
});
}
}else{
psobat.setString(1,no_resep);
psobat.setString(2,"%"+TCari.getText().trim()+"%");
psobat.setString(3,no_resep);
psobat.setString(4,"%"+TCari.getText().trim()+"%");
psobat.setString(5,no_resep);
psobat.setString(6,"%"+TCari.getText().trim()+"%");
rsobat=psobat.executeQuery();
while(rsobat.next()){
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("karyawan"),100),
rsobat.getString("nama"),0,0,0,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("h_beli")
});
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("ralan"),100),
rsobat.getString("nama"),0,0,0,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("h_beli")
});
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("beliluar"),100),
rsobat.getString("nama"),0,0,0,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("h_beli")
});
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("utama"),100),
rsobat.getString("nama"),0,0,0,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("h_beli")
});
}
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}

if(psobat != null){
psobat.close();
}

if(psobatasuransi != null){
psobatasuransi.close();
}
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
}
}

public void emptTeksobat() {
Kd2.setText("");
@@ -1432,6 +1624,7 @@ public void isCek(){

public void setNoRm(String norwt,String tanggal, String jam) {
TNoRw.setText(norwt);
noresep="";
Tanggal.setText(tanggal);
Jam.setText(jam);
KdPj.setText(Sequel.cariIsi("select kd_pj from reg_periksa where no_rawat=?",norwt));
@@ -38,7 +38,6 @@
import javax.swing.table.TableColumn;
import keuangan.Jurnal;
import simrskhanza.DlgCariBangsal;
import simrskhanza.DlgResepObat;

/**
*

Large diffs are not rendered by default.

Large diffs are not rendered by default.

@@ -50,7 +50,6 @@
import keuangan.Jurnal;
import simrskhanza.DlgCariObatPenyakit;
import simrskhanza.DlgPasien;
import simrskhanza.DlgResepObat;

/**
*

Large diffs are not rendered by default.

Large diffs are not rendered by default.

@@ -322,7 +322,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="14-09-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -351,7 +351,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="14-09-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -583,7 +583,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="14-09-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -9,7 +9,7 @@
* Created on 31 Mei 10, 11:27:40
*/

package simrskhanza;
package inventory;
import fungsi.WarnaTable;
import fungsi.batasInput;
import fungsi.koneksiDB;
@@ -36,6 +36,7 @@
import javax.swing.event.DocumentEvent;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import simrskhanza.DlgCariDokter;


/**
@@ -368,7 +369,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23-02-2017" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09-10-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -383,7 +384,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23-02-2017" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09-10-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -514,7 +515,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPBeri.setEditable(false);
DTPBeri.setForeground(new java.awt.Color(50, 70, 50));
DTPBeri.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23-02-2017" }));
DTPBeri.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09-10-2017" }));
DTPBeri.setDisplayFormat("dd-MM-yyyy");
DTPBeri.setName("DTPBeri"); // NOI18N
DTPBeri.setOpaque(false);
@@ -615,10 +616,11 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
}else if(NoResep.getText().trim().equals("")){
Valid.textKosong(NoResep,"No.Resep");
}else{
Sequel.menyimpan("resep_obat","?,?,?,?,?","Nomer Resep",5,new String[]{
Sequel.menyimpan("resep_obat","?,?,?,?,?,?,?","Nomer Resep",7,new String[]{
NoResep.getText(),Valid.SetTgl(DTPBeri.getSelectedItem()+""),
cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),
TNoRw.getText(),KdDokter.getText()
TNoRw.getText(),KdDokter.getText(),Valid.SetTgl(DTPBeri.getSelectedItem()+""),
cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem()
});
tampil();
emptTeks();
@@ -70,7 +70,7 @@ public DlgUser(java.awt.Frame parent, boolean modal) {
"[G]Rekap Parkir Bulanan","[A]Informasi Kamar","[H]Harian Dokter Poli","[H]Obat Per Poli","[H]Obat Per Kamar",
"[H]Obat Per Dokter Ralan","[H]Obat Per Dokter Ranap","[H]Harian Dokter","[H]Bulanan Dokter","[H]Harian Paramedis",
"[H]Bulanan Paramedis","[H]Pembayaran Ralan","[H]Pembayaran Ranap","[H]Rekap Pembayaran Ralan","[H]Rekap Pembayaran Ranap",
"[H]Tagihan Masuk","[H]Tambahan Biaya","[H]Potongan Biaya","[A]Resep Obat","[L]Riwayat Perawatan","[I]Frekuensi Penyakit Ralan","[I]Frekuensi Penyakit Ranap",
"[H]Tagihan Masuk","[H]Tambahan Biaya","[H]Potongan Biaya","[A]No.Resep","[L]Riwayat Perawatan","[I]Frekuensi Penyakit Ralan","[I]Frekuensi Penyakit Ranap",
"[J]Kamar","[J]Tarif Ralan","[J]Tarif Ranap","[J]Tarif Lab","[J]Tarif Radiologi","[J]Tarif Operasi","[J]Akun Rekening","[J]Rekening Tahun",
"[J]Posting Jurnal","[J]Buku Besar","[J]Cash Flow","[J]Keuangan","[J]Pengeluaran Harian","[N]Set P.J. Unit Penunjang","[N]Set Oto Lokasi","[N]Set Kamar Inap",
"[N]Set Embalase & Tuslah","[N]Tracer Login","[N]Display Antrian","[N]Set Harga Obat","[N]Set Penggunaan Tarif","[N]Set Oto Ralan","[N]Biaya Harian Kamar",
@@ -91,7 +91,7 @@ public DlgUser(java.awt.Frame parent, boolean modal) {
"[K]Klaim Baru Otomatis INACBG","[K]Klaim Baru Manual INACBG","[K]Coder NIK INACBG","[L]Mutasi Berkas RM","[J]Akun Piutang","[H]Harian KSO","[H]Bulanan KSO",
"[H]Harian Menejemen","[H]Bulanan Menejemen","[K]Cek Eligibilitas Inhealth","[K]Referensi Ruang Rawat Inhealth","[K]Referensi Poli Inhealth","[K]Referensi Faskes Inhealth",
"[K]Data Bridging SJP Inhealth","[H]Piutang Ralan","[H]Piutang Ranap","[J]Piutang Per Cara Bayar","[I]Lama Pelayanan Ralan","[L]Catatan Pasien","[I]RL 4B Sebab Morbiditas Ralan",
"[I]RL 4A Morbiditas Ralan","[I]RL 4B Morbiditas Ralan","[L]Data HAIs","[I]Harian HAIs","[I]Bulanan HAIs","[I]Hitung BOR","[L]Instansi/Perusahaan Pasien"
"[I]RL 4A Morbiditas Ralan","[I]RL 4B Morbiditas Ralan","[L]Data HAIs","[I]Harian HAIs","[I]Bulanan HAIs","[I]Hitung BOR","[L]Instansi/Perusahaan Pasien","[D]Resep Dokter"
};

tabMode=new DefaultTableModel(null,row){
@@ -181,7 +181,7 @@ public Class getColumnClass(int columnIndex) {
tbUser.setPreferredScrollableViewportSize(new Dimension(500,500));
tbUser.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

for (i = 0; i < 239;i++) {
for (i = 0; i < 240;i++) {
TableColumn column = tbUser.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(150);
@@ -295,6 +295,8 @@ public Class getColumnClass(int columnIndex) {
column.setPreferredWidth(80);
}else if(i==238){
column.setPreferredWidth(155);
}else if(i==239){
column.setPreferredWidth(90);
}else{
column.setPreferredWidth(120);
}
@@ -729,7 +731,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
tampil();
emptTeks();
}
@@ -1011,7 +1013,8 @@ private void BtnEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST
"harian_HAIs='"+tbUser.getValueAt(i,235).toString()+"',"+
"bulanan_HAIs='"+tbUser.getValueAt(i,236).toString()+"',"+
"hitung_bor='"+tbUser.getValueAt(i,237).toString()+"',"+
"perusahaan_pasien='"+tbUser.getValueAt(i,238).toString()+"'");
"perusahaan_pasien='"+tbUser.getValueAt(i,238).toString()+"',"+
"resep_dokter='"+tbUser.getValueAt(i,239).toString()+"'");
}
tampil();
emptTeks();
@@ -1263,8 +1266,8 @@ private void tampil() {
"aplicare_ketersediaan_kamar,inacbg_klaim_baru_otomatis,inacbg_klaim_baru_manual,inacbg_coder_nik,mutasi_berkas, "+
"akun_piutang,harian_kso,bulanan_kso,harian_menejemen,bulanan_menejemen,inhealth_cek_eligibilitas,inhealth_referensi_jenpel_ruang_rawat, "+
"inhealth_referensi_poli,inhealth_referensi_faskes,inhealth_sjp,piutang_ralan,piutang_ranap,detail_piutang_penjab, "+
"lama_pelayanan_ralan,catatan_pasien,rl4b,rl4asebab,rl4bsebab,data_HAIs,harian_HAIs,bulanan_HAIs,hitung_bor,perusahaan_pasien "+
" from user order by AES_DECRYPT(id_user,'nur')");
"lama_pelayanan_ralan,catatan_pasien,rl4b,rl4asebab,rl4bsebab,data_HAIs,harian_HAIs,bulanan_HAIs,hitung_bor,perusahaan_pasien, "+
"resep_dokter from user order by AES_DECRYPT(id_user,'nur')");
try {
rs=ps.executeQuery();
while(rs.next()){
@@ -1513,7 +1516,8 @@ private void tampil() {
rs.getBoolean("harian_HAIs"),
rs.getBoolean("bulanan_HAIs"),
rs.getBoolean("hitung_bor"),
rs.getBoolean("perusahaan_pasien")
rs.getBoolean("perusahaan_pasien"),
rs.getBoolean("resep_dokter")
});
}
} catch (Exception e) {
@@ -1754,7 +1758,8 @@ private void tampil() {
rs.getBoolean("harian_HAIs"),
rs.getBoolean("bulanan_HAIs"),
rs.getBoolean("hitung_bor"),
rs.getBoolean("perusahaan_pasien")
rs.getBoolean("perusahaan_pasien"),
rs.getBoolean("resep_dokter")
});
}
}
@@ -11,6 +11,7 @@
*/

package simrskhanza;
import inventory.DlgResepObat;
import inventory.DlgPemberianObat;
import bridging.BPJSDataSEP;
import laporan.DlgFrekuensiPenyakitRalan;
@@ -11,6 +11,7 @@
*/

package simrskhanza;
import inventory.DlgResepObat;
import laporan.DlgDataHAIs;
import bridging.BPJSDataSEP;
import laporan.DlgDiagnosaPenyakit;
@@ -146,6 +146,32 @@
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="MnPeriksaRadiologiActionPerformed"/>
</Events>
</MenuItem>
<MenuItem class="javax.swing.JMenuItem" name="MnResepDOkter">
<Properties>
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="ff" green="ff" red="ff" type="rgb"/>
</Property>
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor">
<Font name="Tahoma" size="11" style="0"/>
</Property>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="50" red="3c" type="rgb"/>
</Property>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/category.png"/>
</Property>
<Property name="text" type="java.lang.String" value="Input Resep Dokter"/>
<Property name="horizontalAlignment" type="int" value="2"/>
<Property name="horizontalTextPosition" type="int" value="4"/>
<Property name="name" type="java.lang.String" value="MnResepDOkter" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[220, 26]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="MnResepDOkterActionPerformed"/>
</Events>
</MenuItem>
<MenuItem class="javax.swing.JMenuItem" name="MnNoResep">
<Properties>
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
@@ -2848,7 +2874,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="07-10-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -2877,7 +2903,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="07-10-2017"/>
<StringItem index="0" value="09-10-2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1,4 +1,5 @@
package simrskhanza;
import inventory.DlgResepObat;
import inventory.DlgPemberianObat;
import laporan.DlgDiagnosaPenyakit;
import keuangan.DlgBilingRalan;
@@ -9,6 +10,7 @@
import fungsi.validasi;
import fungsi.var;
import inventory.DlgPenjualan;
import inventory.DlgPeresepanDokter;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.event.KeyEvent;
@@ -270,6 +272,7 @@ private void initComponents() {
MnKamarInap = new javax.swing.JMenuItem();
MnPeriksaLab = new javax.swing.JMenuItem();
MnPeriksaRadiologi = new javax.swing.JMenuItem();
MnResepDOkter = new javax.swing.JMenuItem();
MnNoResep = new javax.swing.JMenuItem();
MnObatLangsung = new javax.swing.JMenuItem();
MnOperasi = new javax.swing.JMenuItem();
@@ -484,6 +487,22 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
});
jPopupMenu1.add(MnPeriksaRadiologi);

MnResepDOkter.setBackground(new java.awt.Color(255, 255, 255));
MnResepDOkter.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
MnResepDOkter.setForeground(new java.awt.Color(60, 80, 50));
MnResepDOkter.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
MnResepDOkter.setText("Input Resep Dokter");
MnResepDOkter.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
MnResepDOkter.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
MnResepDOkter.setName("MnResepDOkter"); // NOI18N
MnResepDOkter.setPreferredSize(new java.awt.Dimension(220, 26));
MnResepDOkter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
MnResepDOkterActionPerformed(evt);
}
});
jPopupMenu1.add(MnResepDOkter);

MnNoResep.setBackground(new java.awt.Color(255, 255, 255));
MnNoResep.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
MnNoResep.setForeground(new java.awt.Color(60, 80, 50));
@@ -2052,7 +2071,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
panelGlass8.add(jLabel15);

DTPCari1.setEditable(false);
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "19-09-2017" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "07-10-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -2071,7 +2090,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {
panelGlass8.add(jLabel17);

DTPCari2.setEditable(false);
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "19-09-2017" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "07-10-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -3556,6 +3575,26 @@ private void MnMeninggalActionPerformed(java.awt.event.ActionEvent evt) {//GEN-F
}
}//GEN-LAST:event_MnMeninggalActionPerformed

private void MnResepDOkterActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_MnResepDOkterActionPerformed
if(TNoRw.getText().trim().equals("")){
JOptionPane.showMessageDialog(null,"Maaf, Silahkan anda pilih dulu pasien...!!!");
tbKasirRalan.requestFocus();
}else{
if(Sequel.cariInteger("select count(no_rawat) from kamar_inap where no_rawat=?",TNoRw.getText())>0){
JOptionPane.showMessageDialog(null,"Maaf, Pasien sudah masuk Kamar Inap. Gunakan billing Ranap..!!!");
}else {
DlgPeresepanDokter resep=new DlgPeresepanDokter(null,false);
resep.setSize(internalFrame1.getWidth()-40,internalFrame1.getHeight()-40);
resep.setLocationRelativeTo(internalFrame1);
resep.isCek();
resep.setNoRm(TNoRw.getText(),DTPCari1.getDate(),Jam.getText().substring(0,2),Jam.getText().substring(3,5),Jam.getText().substring(6,8),
tbKasirRalan.getValueAt(tbKasirRalan.getSelectedRow(),0).toString(),tbKasirRalan.getValueAt(tbKasirRalan.getSelectedRow(),1).toString());
resep.tampilobat();
resep.setVisible(true);
}
}
}//GEN-LAST:event_MnResepDOkterActionPerformed

/**
* @param args the command line arguments
*/
@@ -3659,6 +3698,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private javax.swing.JMenuItem MnRekapHarianObat;
private javax.swing.JMenuItem MnRekapHarianParamedis;
private javax.swing.JMenuItem MnRekapHarianPoli;
private javax.swing.JMenuItem MnResepDOkter;
private javax.swing.JMenuItem MnRujuk;
private javax.swing.JMenu MnStatus;
private javax.swing.JMenuItem MnSudah;
@@ -3861,6 +3901,7 @@ public void isCek(){
MnPemberianObat.setEnabled(var.getberi_obat());
MnKamarInap.setEnabled(var.getkamar_inap());
MnPeriksaLab.setEnabled(var.getperiksa_lab());
MnResepDOkter.setEnabled(var.getresep_dokter());
MnPeriksaRadiologi.setEnabled(var.getperiksa_radiologi());
MnOperasi.setEnabled(var.getoperasi());
MnNoResep.setEnabled(var.getresep_obat());
@@ -11,6 +11,7 @@
*/

package simrskhanza;
import inventory.DlgResepObat;
import inventory.DlgPemberianObat;
import bridging.BPJSDataSEP;
import bridging.InhealthDataSJP;
@@ -916,7 +916,7 @@
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/48x48/stock_task.png"/>
</Property>
<Property name="text" type="java.lang.String" value="Resep Obat"/>
<Property name="text" type="java.lang.String" value="No. Resep"/>
<Property name="iconTextGap" type="int" value="0"/>
<Property name="name" type="java.lang.String" value="btnResepObat" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
@@ -5145,6 +5145,25 @@
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="btnPerusahaanActionPerformed"/>
</Events>
</Component>
<Component class="widget.ButtonBig" name="btnDaftarPermintaanResep">
<Properties>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="32" green="46" red="28" type="rgb"/>
</Property>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/48x48/1360485894_add-notes.png"/>
</Property>
<Property name="text" type="java.lang.String" value="Daftar Resep Dokter"/>
<Property name="iconTextGap" type="int" value="0"/>
<Property name="name" type="java.lang.String" value="btnDaftarPermintaanResep" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[200, 90]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="btnDaftarPermintaanResepActionPerformed"/>
</Events>
</Component>
</SubComponents>
</Container>
</SubComponents>
@@ -5161,7 +5180,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="07/10/2017"/>
<StringItem index="0" value="09/10/2017"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd/MM/yyyy"/>
@@ -12,6 +12,7 @@

package simrskhanza;

import inventory.DlgResepObat;
import laporan.DlgDataHAIs;
import bridging.AplicareCekReferensiKamar;
import bridging.AplicareKetersediaanKamar;
@@ -174,6 +175,7 @@
import keuangan.DlgRekeningTahun;
import bridging.ReklasifikasiRalan;
import bridging.ReklasifikasiRanap;
import inventory.DlgDaftarPermintaanResep;
import inventory.DlgRiwayatBarangMedis;
import java.awt.event.KeyListener;
import javax.swing.event.DocumentEvent;
@@ -628,6 +630,7 @@ private void initComponents() {
btnBulananHAIs = new widget.ButtonBig();
btnHitungBor = new widget.ButtonBig();
btnPerusahaan = new widget.ButtonBig();
btnDaftarPermintaanResep = new widget.ButtonBig();
tanggal = new widget.Tanggal();
btnDataPenjualan = new widget.ButtonBig();
btnInputPenjualan = new widget.ButtonBig();
@@ -1155,7 +1158,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

btnResepObat.setForeground(new java.awt.Color(40, 70, 50));
btnResepObat.setIcon(new javax.swing.ImageIcon(getClass().getResource("/48x48/stock_task.png"))); // NOI18N
btnResepObat.setText("Resep Obat");
btnResepObat.setText("No. Resep");
btnResepObat.setIconTextGap(0);
btnResepObat.setName("btnResepObat"); // NOI18N
btnResepObat.setPreferredSize(new java.awt.Dimension(200, 90));
@@ -4052,6 +4055,19 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
});
Panelmenu.add(btnPerusahaan);

btnDaftarPermintaanResep.setForeground(new java.awt.Color(40, 70, 50));
btnDaftarPermintaanResep.setIcon(new javax.swing.ImageIcon(getClass().getResource("/48x48/1360485894_add-notes.png"))); // NOI18N
btnDaftarPermintaanResep.setText("Daftar Resep Dokter");
btnDaftarPermintaanResep.setIconTextGap(0);
btnDaftarPermintaanResep.setName("btnDaftarPermintaanResep"); // NOI18N
btnDaftarPermintaanResep.setPreferredSize(new java.awt.Dimension(200, 90));
btnDaftarPermintaanResep.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnDaftarPermintaanResepActionPerformed(evt);
}
});
Panelmenu.add(btnDaftarPermintaanResep);

scrollPane2.setViewportView(Panelmenu);

panelMenu.add(scrollPane2, java.awt.BorderLayout.CENTER);
@@ -4060,7 +4076,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {

tanggal.setEditable(false);
tanggal.setForeground(new java.awt.Color(50, 70, 50));
tanggal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01/10/2017" }));
tanggal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "09/10/2017" }));
tanggal.setDisplayFormat("dd/MM/yyyy");
tanggal.setName("tanggal"); // NOI18N
tanggal.setOpaque(false);
@@ -8604,6 +8620,18 @@ private void btnPerusahaanActionPerformed(java.awt.event.ActionEvent evt) {//GEN

}//GEN-LAST:event_btnPerusahaanActionPerformed

private void btnDaftarPermintaanResepActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnDaftarPermintaanResepActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
DlgDaftarPermintaanResep daftar=new DlgDaftarPermintaanResep(null,false);
daftar.emptTeks();
daftar.isCek();
daftar.setSize(PanelUtama.getWidth(),PanelUtama.getHeight());
daftar.setLocationRelativeTo(PanelUtama);
daftar.setVisible(true);
DlgHome.dispose();
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_btnDaftarPermintaanResepActionPerformed

/**
* @param args the command line arguments
*/
@@ -8692,6 +8720,7 @@ public static void main(String args[]) {
private widget.ButtonBig btnCekInhealthFaskes;
private widget.ButtonBig btnCekInhealthPoli;
private widget.ButtonBig btnClosingKasir;
private widget.ButtonBig btnDaftarPermintaanResep;
private widget.ButtonBig btnDaruratStok;
private widget.ButtonBig btnDataHAIs;
private widget.ButtonBig btnDataPenjualan;
@@ -9444,6 +9473,11 @@ private void isCombo() {
Panelmenu.add(btnPenjualan);
jmlmenu++;
}

if(var.getberi_obat()==true){
Panelmenu.add(btnDaftarPermintaanResep);
jmlmenu++;
}

if(var.getpiutang_obat()==true){
Panelmenu.add(btnPiutang);
@@ -10655,6 +10689,11 @@ private void isCariKosong() {
jmlmenu++;
}

if(var.getberi_obat()==true){
Panelmenu.add(btnDaftarPermintaanResep);
jmlmenu++;
}

if(var.getpiutang_obat()==true){
Panelmenu.add(btnPiutang);
jmlmenu++;
@@ -11948,6 +11987,13 @@ private void isCariIsi() {
jmlmenu++;
}
}

if(var.getberi_obat()==true){
if(btnDaftarPermintaanResep.getText().toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())){
Panelmenu.add(btnDaftarPermintaanResep);
jmlmenu++;
}
}

if(var.getpiutang_obat()==true){
if(btnPiutang.getText().toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())){