kesbong.pehape

    <?php
//  include 'header.php';
    include 'koneksi.php';
    ?>
    <div id="kodingphp">
    <center>
    <form name="kasbon" method="post" action="kasbon2.php">
        <table>
            <tr><td colspan="2" align="center"><h1>Form Tambah Kasbon</h1></td></tr>
            <tr><td>Id Karyawan</td><td>

            <?php
            $query = "select a.*,(select sum(b.pinjam - b.bayar) from mast_kasbon as b where b.Id_karyawan=a.Id_karyawan) as sisa from mast_karyawan as a";
            $result_karyawan = mysql_query(query);
//          $result_karyawan = mysql_query("select * from mast_karyawan");
            $jsArray_karyawan = "var prdName_karyawan = new Array();\n";

            echo '<select name="Id_karyawan" onchange="changeValue(this.value)">';
            echo '<option value=xxxx>--pilih-</option>';

            while ($row_karyawan = mysql_fetch_array($result_karyawan)){
            echo '<option value="' . $row_karyawan['Id_karyawan'] . '">' . $row_karyawan['Id_karyawan'] . '</option>';
            $jsArray_karyawan .= "prdName_karyawan['" . $row_karyawan['Id_karyawan'] . "'] = {name:'" . addslashes($row_karyawan['Nama']) . "',sisa:'".addslashes($row_karyawan['sisa'])."'};\n";
            }
            echo '</select>';
            ?>

            </tr>
            <tr><td>Nama Karyawan</td><td> <input type="text" name="Nama_karyawan" id="Nama_karyawan" readonly></td></tr>
            <tr><td>Total Kasbon Yang Belum Dibayar</td><td> <input type="text" name="Belum_bayar" id="Belum_bayar" readonly></td></tr>
            <tr><td>Tanggal Kasbon</td><td><input type="text" size="20" name="Tgl_kasbon" title="dd-mm-yyyy" /><a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.kasbon.Tgl_kasbon);return false;" ><img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="22" border="0" alt=""></td></tr>
            <tr><td>Nominal Kasbon</td><td> <input type="text" name="Nominal_kasbon"><input type="text" name="Bayar" value="0" hidden /></td></tr>
            <tr><td><input type="submit" value="simpan"></td></tr>
        </table>
    </form>
    </center>
    </div>

    <?php
//  include 'footer.php';
    ?>

    <script type="text/javascript">
        <?php echo $jsArray_karyawan; ?>
        prdName_karyawan['xxxx'] = {name:'',sisa:''};
        function changeValue(id){
        document.getElementById('Nama_karyawan').value = prdName_karyawan[id].name;
        document.getElementById('Belum_bayar').value = prdName_karyawan[id].sisa;
        };

    </script>

    <iframe width=174 height=189 name="gToday:normal:calender/normal.js" id="gToday:normal:calender/normal.js" src="calender/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:absolute; top:-500px; left:-500px;">
    </iframe>