modul sistem informasi koperasi

7/29/2019 Modul Sistem Informasi Koperasi

1/44

Sis

(

Ol

Modul

em Informasi Koperasi

SIMPAN PINJAM

ySQL, PHP & JQuery)

eh : Deddy Rusdiansyah,S.Kom

Penguatan Daya Saing (PDS)

PIKSI INPUT SERANG

2012


2/44

2

Modul Sistem Informasi Koperasi

Deddy Rusdiansyah,S.Kom

index.php

12345

67891011121314151617

181920212223242526272829

3031323334353637383940414243444546474849505152

53

Login System

$(document).ready(function() {$(".text").val('');$("#username").focus();

});function validasi(){var username = $("#username").val();

var password = $("#password").val();if (username.length == 0){

alert("Anda belum mengisikan Username.");$("#username").focus();return false();

}if (password.length == 0){

alert("Anda belum mengisikan Password.");$("#password").focus();return false();

}return true();

}.right {

float:right}button {margin: 0; padding: 0;}button {margin: 2px; position: relative; padding: 4px 4px 4px 2px;cursor: pointer; float: left; list-style: none;}button span.ui-icon {float: left; margin: 0 4px;}Username

:


3/44

3



54555657585960

616263646566676869707172

7374757677

Password:

Login

style_login.css

123

4567891011121314151617181920212223242526

27

@charset "utf-8";/* CSS Document */body {

background:url(../images/_bg2.jpg);}.login-inside {

width: 400px;font-family:Verdana, Geneva, sans-serif;font-size:12px;margin: 0px auto;margin-top: 200px;padding: 10px;border:2px solid #F30;/* background-color:#f9f9f9; */background:url(../images/bg_inside.png);-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 4px #aaa;

-webkit-box-shadow:0px 0px 4px #aaa;box-shadow:0px 0px 4px #aaa;

}.login-data {

padding: 40px 0px 25px 0px;color:#F00;font-weight:bold;


4/44

4



28293031323334

35

}button {

-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 4px #aaa;

-webkit-box-shadow:0px 0px 4px #aaa;

box-shadow:0px 0px 4px #aaa;}

inc.koneksi.php

123456

78

cek_login.php

123456

789101112131415161718192021222324252627282930

alert('Sekarang loginnya tidak bisa di injeksi lho.');window.location.href='index.php';

alert('Maaf, Username atau password salah.');window.location.href='index.php';


5/44

5



31323334

logout.php

12345

media.php

12

34567891011121314

151617181920212223242526272829303132333435363738

Sistem Informasi Koperasi Simpan Pinjam

$(document).ready(function(){

$('ul.sf-menu').superfish();});


6/44

6



39404142434445

46474849505152

Copyright PIKSI INPUT SERANG Tahun 2012

menu.php

1

2345678910111213

14151617181920212223242526272829

HomeMasterJenis SimpananAnggotaUsersTransaksi

SimpananPengambilanPinjamanBayar PinjamanLaporanAnggotaSimpananPinjamanKeluar

content.php

1234


7/44

7



567891011

121314151617181920212223

2425262728

echo "Selamat Datang";echo "Hai, $_SESSION[namauser] Selamat datang di Sistem Informasi Koperasi";

}elseif ($mod=='jenis'){

include "modul/jenis/jenis.php";}elseif ($mod=='anggota'){

include "modul/anggota/anggota.php";}//buatlah form user berdasarkan form anggotaelseif ($mod=='simpanan'){

include "modul/simpanan/simpanan.php";}//buatlah form pengambilan berdasarkan form simpananelseif ($mod=='pinjaman'){

include "modul/pinjaman/pinjaman.php";}elseif ($mod=='bayar'){

include "modul/bayar/bayar.php";

}else{

echo "MODUL BELUM ADA ATAU BELUM LENGKAP SILAHKAN BUAT SENDIRI";}?>

style_content.css

123

4567891011121314151617181920212223242526

27

body {font-family:Verdana,Arial,sans-serif;font-size:12px;

}h2,h3{clear:both; text-align:center; font-size:16px;}.box {

width:850px;margin: 0px auto;height:auto;padding:10px;-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 20px #aaa;

-webkit-box-shadow:0px 0px 20px #aaa;box-shadow:0px 0px 20spx #aaa;

}.style {

border: 3px solid #FFFFFF;}.header {

height: 121px;}.menu {

height: 33px;background:#BDD2FF;

font-size:12px;


8/44

8



28293031323334

353637383940414243444546

474849505152

-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 20px #aaa;


}

.content {margin:0px auto;margin-top:10px;padding:5px 5px 5px 5px;height:auto;

}.footer {

margin-top:10px;padding:5px 5px 5px 5px;background:#cd152f;color:#fff;-moz-border-radius: 5px 5px 5px 5px;

-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 20px #aaa;


}

style_table.css

12

345678910111213141516171819202122232425

26

@charset "utf-8";/* CSS Document */

#theTable{background:#BDD2FF;font-size:12px;border:3px solid #5c9fe9;-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 20px #aaa;


}#theTable th,td {

color: #000;padding-left : 2px;padding-right : 2px;padding-top : 2px;padding-bottom : 2px;

}#theTable th {

background-color:#5c9fe9;color:#FFF;text-align:center;font:normal 11px Verdana, Geneva, sans-serif;

font-weight:bold;


9/44

9



27282930313233

343536373839404142434445

4647

height:20px;padding-top:5px;

}#theTable td{

border:0px solid #5c9fe9;font:normal 11px Verdana, Geneva, sans-serif;

}

.clickable {cursor:pointer;

}.stripe1 {

background-color:#ecf2f6;}.stripe2 {

background-color:#FFF;}.highlight {

background-color: #ffcc00;

font-weight:bold;}

fungsi_tanggal.php

123456

7891011121314151617

fungsi_koperasi.php

123456789


10/44

10



10111213141516

171819202122232425262728

}else{$hasil = 0;

}return $hasil;

}function sisa($no) {

$sql = "SELECT sum(jumlah_bayar) as total

FROM pinjaman_detailWHERE id_pinjam='$no'";

$data = mysql_fetch_array(mysql_query($sql));$row = mysql_num_rows(mysql_query($sql));if ($row>0){

$hasil = $data['total'];}else{

$hasil = 0;}return $hasil;

}?>

MODUL Jenis Simpanan

jenis.php

1234

5678910111213141516

171819202122232425262728

button {

margin: 2px;

position: relative;padding: 4px 8px 4px 4px;cursor: pointer;list-style: none;

}button span.ui-icon {

float: left;margin: 0 4px;

}


11/44

11



29303132333435

363738394041424344

:Jenis:

Jumlah:";?>

ajax.js

1234567891011

1213141516171819202122232425262728293031323334

35

// JavaScript Document$(document).ready(function(){

$(function(){$('button').hover(

function() { $(this).addClass('ui-state-hover'); },function() { $(this).removeClass('ui-state-hover'); }

);});$('#form_input').dialog({

autoOpen: false,show: "blind",

hide: "blind",width: 450,modal : true,resizable:false,buttons: {

"Simpan": function() {//$(this).dialog("close");simpan();

},"Batal": function() {

$(this).dialog("close");}

}});$("#tampil_data").load('modul/jenis/tampil_data.php');$('#tambah').click(function(){

$(".input").val('');$('#form_input').dialog('open');return false;

});

$("#jml").keypress(function (data) {if(data.which!=8 && data.which!=0 && (data.which57)){

return false;


12/44

12



36373839404142

434445464748495051525354

555657585960616263646566

}});

function simpan(){var id = $("#id").val();var jenis = $("#jenis").val();var jml = $("#jml").val();

if(id.length==0){alert('Maaf, ID tidak boleh kosong');$("#id").focus();return false();

}if(jenis.length==0){

alert('Maaf, Jenis tidak boleh kosong');$("#jenis").focus();return false();

}$.ajax({

type : "POST",url : "modul/jenis/simpan.php",data : "id="+id+

"&jenis="+jenis+"&jml="+jml,

success : function(data){$("#tampil_data").load('modul/jenis/tampil_data.php');$("#form_input").dialog("close");

}});

}});

tampil_data.php

12345678910111213141516171819

20

$(function() {

$("#theTable tr:even").addClass("stripe1");$("#theTable tr:odd").addClass("stripe2");

$("#theTable tr").hover(function() {

$(this).toggleClass("highlight");},function() {

$(this).toggleClass("highlight");}

);});

function editRow(ID){var id = ID;var pilih = confirm('Data yang akan mengubah = '+id+ '?');if (pilih==true) {$.ajax({

type : "POST",


13/44

13



21222324252627

282930313233343536373839

404142434445464748495051

5253545556575859606162636465666768697071727374

75

url : "modul/jenis/cari.php",data : "id="+id,dataType : "json",success : function(data){

$("#id").val(ID);$("#jenis").val(data.jenis);$("#jml").val(data.jml);

$('#form_input').dialog('open');return false;

}});}

}function deleteRow(ID) {

var id = ID;var pilih = confirm('Data yang akan dihapus = '+id+ '?');

if (pilih==true) {$.ajax({

type : "POST",

url : "modul/jenis/hapus.php",data : "id="+id,success : function(data){

$("#tampil_data").load("modul/jenis/tampil_data.php");}

});}

}


14/44

14



76777879

$no++;}

echo "";?>

cari.php

1234567891011

121314151617181920212223

simpan.php

1234567891011121314151617181920


15/44

15



21222324

mysql_query($input);echo "Data sukses disimpan";

}?>

hapus.php

1234567891011


16/44

16



25262728293031

323334353637383940414243

444546474849505152535455

5657585960616263646566676869707172737475767778

79

text-align:right;}#tampil_data{

margin-top:30px;}


17/44

17



80818283848586

878889909192939495969798

Tanggal Lahir:

Alamat:HP:";?>

ajax.js

12345678

910111213141516171819202122232425262728293031

32



function() { $(this).addClass('ui-state-hover'); },function() { $(this).removeClass('ui-state-hover'); }

);});

$('#form_input').dialog({autoOpen: false,show: "blind",hide: "blind",width: 550,modal : true,resizable:false,buttons: {

"Simpan": function() {//$(this).dialog("close");simpan();

},"Batal": function() {

$(this).dialog("close");}

}});$("#tgl").datepicker({

dateFormat:"dd-mm-yy"});

$("#tampil_data").load('modul/anggota/tampil_data.php');$('#tambah').click(function(){

$(".input").val('');

$("#nomor").attr("disabled",false);


18/44

18



33343536373839

404142434445464748495051

525354555657585960616263

6465666768697071727374757677787980818283848586

87

$("#nomor").focus();$('#form_input').dialog('open');return false;

});

function simpan(){var no = $("#nomor").val();

var id = $("#identitas").val();var nama = $("#anggota").val();var jk = $("#jk").val();var tempat = $("#tempat").val();var tgl = $("#tgl").val();var alamat = $("#alamat").val();var hp = $("#hp").val();

if(no.length==0){alert('Maaf, Nomor Anggota tidak boleh kosong');$("#nomor").focus();return false();

}if(id.length==0){

alert('Maaf, Nomor Identitas tidak boleh kosong');$("#identitas").focus();return false();

}if(nama.length==0){

alert('Maaf, Nama Anggota tidak boleh kosong');$("#anggota").focus();return false();

}$.ajax({

type : "POST",url : "modul/anggota/simpan.php",data : "no="+no+

"&id="+id+"&nama="+nama+"&jk="+jk+"&tempat="+tempat+"&tgl="+tgl+"&alamat="+alamat+"&hp="+hp,

success : function(data){$("#tampil_data").load('modul/anggota/tampil_data.php');$("#form_input").dialog("close");

}});

}$("#cari").click(function(){

var cari = $("#txt_cari").val();cariData(cari);

});

function cariData(e){var cari = e;

$.ajax({


19/44

19



88899091929394

9596

type : "GET",url : "modul/anggota/tampil_data.php",data : "cari="+cari,success : function(data){

$("#tampil_data").html(data);}

});

}});

tampil_data.php

123456

789101112131415161718

1920212223242526272829303132333435363738394041

42

$(function() {

$("#theTable tr:even").addClass("stripe1");$("#theTable tr:odd").addClass("stripe2");$("#theTable tr").hover(

function() {



);});function editRow(ID){

var id = ID;var pilih = confirm('Data yang akan mengubah = '+id+ '?');if (pilih==true) {$.ajax({

type : "POST",url : "modul/anggota/cari.php",data : "id="+id,dataType : "json",success : function(data){

$("#nomor").val(ID);$("#identitas").val(data.id);$("#anggota").val(data.nama);$("#jk").val(data.jk);$("#tempat").val(data.tempat);$("#tgl").val(data.tgl);$("#alamat").val(data.alamat);$("#hp").val(data.hp);

$("#nomor").attr("disabled",true);$('#form_input').dialog('open');return false;

}});}

}function deleteRow(ID) {

var id = ID;

var pilih = confirm('Data yang akan dihapus = '+id+ '?');


20/44

20



43444546474849

505152535455565758596061

626364656667686970717273

747576777879808182838485868788899091929394


type : "POST",url : "modul/anggota/hapus.php",data : "id="+id,success : function(data){

$("#tampil_data").load("modul/anggota/tampil_data.php");

}});

}}


21/44

21



cari.php

12345

67891011121314151617

181920212223242526272829

30

simpan.php

12345678910111213141516171819


22/44

22



20212223242526

27282930313233343536

namaanggota ='$nama',jk ='$jk',tempat_lahir ='$tempat',tgl_lahir ='$tgl',alamat ='$alamat',hp ='$hp'WHERE noanggota= '$no'";

mysql_query($input);echo "Data Sukses diubah";

}else{$input = "INSERT INTO $table

(noanggota,noidentitas,namaanggota,jk,tempat_lahir,tgl_lahir,alamat,hp,pwd)VALUES('$no','$id','$nama','$jk','$tempat','$tgl','$alamat','$hp','$pwd')";

mysql_query($input);echo "Data sukses disimpan";

}?>

hapus.php

12345678

91011


23/44

23



16171819202122

232425262728293031323334

353637383940414243444546

4748495051525354555657585960616263646566676869

70

padding:5px 5px 5px 5px;margin-bottom:20px;

}#tombol-tambah{

float:left;width:250px;

}

#tombol-cari{float:right;width:500px;text-align:right;

}#tampil_data2,#tampil_data3{

margin-top:30px;}#info_anggota{

position:absolute;padding:5px 5px 5px 5px;background-color:#FFF;

width:450px;border:3px solid #5c9fe9;-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;-moz-box-shadow:0px 0px 20px #aaa;


z-index:200px;float:right;left:350px;

}


24/44

24



71727374757677

787980818283848586878889

90919293949596979899100101

102103104105106107108109110111112113114115116117118119120121122123124

125

Jenis Simpanan:-Pilih-";$sql = "SELECT * FROM jenis_simpan";$query = mysql_query($sql);while($rows=mysql_fetch_array($query)){

echo "$rows[id_jenis] - $rows[jenis_simpanan]";}echo "Jumlah:

SimpanBaru

Tanggal s/d CariCari";

?>


25/44

25



ajax.php

123

456789101112131415

161718192021222324252627

282930313233343536373839404142434445464748495051


$(function(){

$('button').hover(function() { $(this).addClass('ui-state-hover'); },function() { $(this).removeClass('ui-state-hover'); }

);});$("#nomor").keyup(function(e){

var isi = $(e.target).val();$(e.target).val(isi.toUpperCase());

});

$('#tabs').tabs();

$("#tgl").datepicker({dateFormat:"dd-mm-yy"

});$("#tgl1").datepicker({


$("#tgl2").datepicker({dateFormat:"dd-mm-yy"

});

$("#jml").keypress(function (data) {if(data.which!=8 && data.which!=0 && (data.which57)){

return false;}

});$("#simpan").click(function(){

simpan();})function simpan(){

var no = $("#nomor").val();var tgl = $("#tgl").val();var jenis = $("#jenis").val();var jml = $("#jml").val();

if(no.length==0){alert('Maaf, Nomor Anggota tidak boleh kosong');$("#nomor").focus();return false();

}if(tgl.length==0){

alert('Maaf, Tanggal tidak boleh kosong');$("#tgl").focus();return false();

}if(jenis.length==0){

alert('Maaf, Jenis Simpanan tidak boleh kosong');


26/44

26



52535455565758

596061626364656667686970

717273747576777879808182

8384858687888990919293949596979899100101102103104105

106

$("#jenis").focus();return false();

}if(jml.length==0){

alert('Maaf, Jumlah tidak boleh kosong');$("#jml").focus();return false();

}

$.ajax({type : "POST",url : "modul/simpanan/simpan.php",data : "no="+no+

"&tgl="+tgl+"&jenis="+jenis+"&jml="+jml,

success : function(data){//$("#tampil_data1").html(data);$("#tampil_data1").load('modul/simpanan/tampil_data1.php?cari='+no);

}});

}$("#baru").click(function(){

var cari ='';$(".input").val('');$("#nomor").focus();cariAnggota(cari);cariSimpananAnggota(cari);

})$("#nomor").keyup(function(){

var cari = $("#nomor").val();

cariAnggota(cari);cariSimpananAnggota(cari);

})function cariAnggota(e){

var cari = e;$.ajax({

type : "POST",url : "modul/simpanan/cari_anggota.php",data : "cari="+cari,success : function(data){

$("#info_anggota").html(data);}

});}function cariSimpananAnggota(e){


type : "GET",url : "modul/simpanan/tampil_data1.php",data : "cari="+cari,success : function(data){

$("#tampil_data1").html(data);}

});


27/44

27



107108109110111112113

114115116117118119120121122123124125

126127128129130131132133134135136137

138139140141142143144145146147148149150151152153154155156157158159160

161

}$("#jenis").change(function(){

var cari = $("#jenis").val();cariJenis(cari);

})

function cariJenis(e){


type : "POST",url : "modul/simpanan/cari_jenis.php",data : "cari="+cari,dataType: "json",success : function(data){

$("#jml").val(data.jml);}

});}

$("#cari2").click(function(){var tgl1 = $("#tgl1").val();var tgl2 = $("#tgl2").val();

if(tgl1.length==0){alert('Maaf, Tanggal tidak boleh kosong');$("#tgl1").focus();return false();

}if(tgl2.length==0){

alert('Maaf, Tanggal tidak boleh kosong');$("#tgl2").focus();

return false();}

cariData2(tgl1,tgl2);});

function cariData2(e1,e2){var tgl1 = e1;var tgl2 = e2;

$.ajax({type : "POST",url : "modul/simpanan/tampil_data2.php",data : "tgl1="+tgl1+"&tgl2="+tgl2,success : function(data){


});}$("#cari3").click(function(){

var cari = $("#txt_cari").val();cariData3(cari);

});


28/44

28



162163164165166167168

169170171172173

function cariData3(e){var cari = e;$.ajax({

type : "POST",url : "modul/simpanan/tampil_data3.php",data : "cari="+cari,success : function(data){


});}

});

cari_anggota.php

123

456789101112131415

16171819202122232425262728293031323334353637


29/44

29



cari_jenis.php

12345

67891011121314151617

18

tampil_data1.php

1234567

8910111213141516171819202122232425262728293031

$(function() {





);});function deleteRow(ID) {

var id = ID;var cari = $("#nomor").val();

var pilih = confirm('Data yang akan dihapus = '+id+ '?');if (pilih==true) {

$.ajax({type : "POST",url : "modul/simpanan/hapus.php",data : "id="+id,success : function(data){

$("#tampil_data1").load("modul/simpanan/tampil_data1.php?cari="+cari);}

});}

}


30/44

30



32333435363738

394041424344454647484950

515253545556575859606162

636465666768697071

include '../../inc/inc.koneksi.php';include '../../inc/fungsi_tanggal.php';$cari = $_GET['cari'];$where = " WHERE noanggota='$cari'";echo "

No

TanggalSimpananJumlahHapus

";$sql = "SELECT a.*,b.jenis_simpanan

FROM simpanan as aJOIN jenis_simpan as bON a.id_jenis=b.id_jenis$whereORDER BY a.id_simpanan DESC";

$query = mysql_query($sql);

$no=1;while($rows=mysql_fetch_array($query)){

echo "$no".jin_date_str($rows[tgl])."$rows[jenis_simpanan]".number_format($rows[jumlah])."Hapus

";

$no++;$gtotal = $gtotal+$rows[jumlah];}

echo "

Total".number_format($gtotal)."

";?>

tampil_data2.php

12345678910

11

$(function() {

$("#theTable.dua tr:even").addClass("stripe1");$("#theTable.dua tr:odd").addClass("stripe2");

$("#theTable.dua tr").hover(function() {


$(this).toggleClass("highlight");


31/44

31



12131415161718

192021222324252627282930

313233343536373839404142

434445464748495051525354

});

});


32/44

32



9101112131415

161718192021222324252627

282930313233343536373839

40414243444546

},function() {


);});


33/44

33



1415

echo "Data sukses disimpan";?>

hapus.php

1

234567891011


34/44

34



33343536373839

404142434445464748495051

525354555657585960616263

6465666768697071727374757677787980818283848586

87

padding:5px 5px 5px 5px;background-color:#FFF;width:450px;border:3px solid #5c9fe9;-moz-border-radius: 5px 5px 5px 5px;-webkit-border-radius: 5px 5px 5px 5px;border-radius: 5px 5px 5px 5px;

-moz-box-shadow:0px 0px 20px #aaa;-webkit-box-shadow:0px 0px 20px #aaa;box-shadow:0px 0px 20spx #aaa;

z-index:200px;float:right;left:350px;

}


35/44

35



88899091929394

9596979899100101102103104105106

107108109110111112113114115116117118

119120121122123124125126127128129130131132133

: %Jumlah:

SimpanTutup

TambahTanggal s/d Cari

Ketentuan :

Setiap Anggota meminjam harus memenuhi persyaratan sebagai berikut
Foto Copy KTP Suami/IstriTidak Memiliki Tunggakan Sebelumnya";?>


36/44

36



ajax.js

12345

67891011121314151617

181920212223242526272829

3031323334353637383940414243444546474849505152

53



function() { $(this).addClass('ui-state-hover'); },

function() { $(this).removeClass('ui-state-hover'); });

});$("#nomor").keyup(function(e){

var isi = $(e.target).val();$(e.target).val(isi.toUpperCase());

});$('#tabs').tabs();$("#tgl").datepicker({


$("#tgl1").datepicker({


$("#tgl2").datepicker({dateFormat:"dd-mm-yy"

});$("#jml").keypress(function (data) {

if(data.which!=8 && data.which!=0 && (data.which57)){return false;

}});$("#bunga").keypress(function (data) {

if(data.which!=8 && data.which!=0 && (data.which57)){

return false;}

});$("#form_isian").hide();$("#tampil_data1").load('modul/pinjaman/tampil_data1.php');function buatNomor(){

var no = '0001';$.ajax({

type : "POST",url : "modul/pinjaman/cari_nomor.php",data : "no="+no,dataType : "json",success : function(data){

$("#no").val(data.no);}

});}$("#tambah").click(function(){

$("#form_isian").show();$("#menu-tombol1").hide();$("#nomor").focus();buatNomor();var no = $("#no").val();

$("#tampil_data1").load('modul/pinjaman/tampil_data_cicilan.php?cari='+no);


37/44

37



54555657585960

616263646566676869707172

737475767778798081828384

858687888990919293949596979899100101102103104105106107

108

})$("#simpan").click(function(){

simpanHeader();})function simpanHeader(){

var no = $("#no").val();var nomor = $("#nomor").val();

var tgl = $("#tgl").val();var lama = $("#lama").val();var jml = $("#jml").val();var bunga = $("#bunga").val();if(no.length==0){

alert('Maaf, Nomor Anggota tidak boleh kosong');$("#no").focus();return false();

}if(nomor.length==0){

alert('Maaf, Nomor Anggota tidak boleh kosong');$("#nomor").focus();

return false();}if(tgl.length==0){

alert('Maaf, Tanggal tidak boleh kosong');$("#tgl").focus();return false();

}if(lama.length==0){

alert('Maaf, Lama Pinjaman tidak boleh kosong');$("#lama").focus();return false();

}

if(jml.length==0){alert('Maaf, Jumlah tidak boleh kosong');$("#jml").focus();return false();

}if(bunga.length==0){

alert('Maaf, Bunga tidak boleh kosong');$("#bunga").focus();return false();

}$.ajax({

type : "POST",url : "modul/pinjaman/simpan_header.php",data : "no="+no+

"&nomor="+nomor+"&tgl="+tgl+"&lama="+lama+"&bunga="+bunga+"&jml="+jml,

success : function(data){simpanDetail();$("#tampil_data1").load('modul/pinjaman/tampil_data_cicilan.php?cari='+no);

}

});


38/44

38



109110111112113114115

116117118119120121122123124125126127

128129130131132133134135136137138139

140141142143144145146147148149150151152153154155156157158159160161162

163

}function simpanDetail(){

var no = $("#no").val();var lama = $("#lama").val();var jml = $("#jml").val();var bunga = $("#bunga").val();var angsuran = parseInt(jml)/parseInt(lama);

var t_bunga = (parseInt(angsuran)*parseInt(bunga))/100;for (var i = 1; i


39/44

39



164165166167168169170

171172173174175176177178179180181182

183184185186187188189190191192193194

195196197198199200201202203204205206

cariJenis(cari);})function cariJenis(e){


type : "POST",url : "modul/pinjaman/cari_jenis.php",

data : "cari="+cari,dataType: "json",success : function(data){

$("#jml").val(data.jml);}

});}$("#cari2").click(function(){

var tgl1 = $("#tgl1").val();var tgl2 = $("#tgl2").val();if(tgl1.length==0){

alert('Maaf, Tanggal tidak boleh kosong');

$("#tgl1").focus();return false();

}if(tgl2.length==0){

alert('Maaf, Tanggal tidak boleh kosong');$("#tgl2").focus();return false();

}cariData2(tgl1,tgl2);

});function cariData2(e1,e2){

var tgl1 = e1;

var tgl2 = e2;

$.ajax({type : "POST",url : "modul/pinjaman/tampil_data2.php",data : "tgl1="+tgl1+"&tgl2="+tgl2,success : function(data){


});}

});

cari_nomor.php

1234567

8


40/44

40



9101112131415

1617181920

if ($row>0){$r=mysql_fetch_array($sql);$noakhir = (int) substr($r[noakhir], 2, 4);$noakhir++;$no = 'P'. sprintf("%04s",$noakhir);$data['no'] = $no;echo json_encode($data);

}else{$data['no'] = 'P0001';echo json_encode($data);

}?>

cari_anggota.php

12345

67891011121314151617

1819202122232425262728293031323334353637383940


41/44

41



Tampil_data1.php

12345

67891011121314151617

181920212223242526272829

3031323334353637383940414243444546474849505152

53

$(function() {

$("#theTable.satu tr:even").addClass("stripe1");$("#theTable.satu tr:odd").addClass("stripe2");

$("#theTable.satu tr").hover(function() {



);});function deleteRow(ID) {

var id = ID;var pilih = confirm('Data yang akan dihapus = '+id+ '?');


type : "POST",url : "modul/pinjaman/hapus.php",data : "id="+id,success : function(data){

$("#tampil_data1").load("modul/pinjaman/tampil_data1.php");}

});}

}


42/44

42



54555657585960

616263646566676869707172

737475767778798081828384

8586878889909192939495

SisaHapus

";$sql = "SELECT a.*,b.namaanggota,b.jk

FROM pinjaman_header as aJOIN anggota as bON a.noanggota=b.noanggota

$whereORDER BY a.id_pinjam DESC";

$query = mysql_query($sql);$no=1;while($rows=mysql_fetch_array($query)){

$jml_bayar= jmlBayar($rows[id_pinjam]);$jml_cicilan = sisa($rows[id_pinjam]);$sisa = $jml_bayar - $jml_cicilan;echo "

$no$rows[id_pinjam]".jin_date_str($rows[tgl])."

$rows[noanggota]$rows[namaanggota]$rows[jk]$rows[lama]".number_format($rows[jumlah])."$rows[bunga]".number_format($jml_bayar)."".number_format($jml_cicilan)."".number_format($sisa)."Hapus

";

$no++;$gtotal = $gtotal+$rows[jumlah];}

echo "

Total".number_format($gtotal)."

";?>

Tampil_data_cicilan.php

12345678

9

$(function() {



$(this).toggleClass("highlight");

},


43/44

43



10111213141516

171819202122232425262728

293031323334353637383940

4142434445464748495051525354555657585960616263

64

function() {$(this).toggleClass("highlight");

});

});function deleteRow(ID) {

var id = ID;

var cari = $("#nomor").val();var pilih = confirm('Data yang akan dihapus = '+id+ '?');


type : "POST",url : "modul/simpanan/hapus.php",data : "id="+id,success : function(data){

$("#tampil_data1").load("modul/simpanan/tampil_data1.php?cari="+cari);}

});}

}


44/44

6566

";?>

Simpan_header.php

123

456789101112131415

1617

modul sistem informasi koperasi

Documents