| | mas Gunawan Mujur Wibisono ini syntak sy mas. kira2 apa yang salah <?php
$dbS[0] = "mysql:dbname=alir_sopp;host=localhost";
$dbS[1] = "root";
$dbS[2] = "";
$dbC[0] = "mssql:dbname=CIS;host=192.168.45.146";
$dbC[1] = "";
$dbC[2] = "";
try {
$db = new PDO($dbS[0],$dbS[1],$dbS[2]);
echo("berhasil terhubung ke server");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $err){
echo( $err->getMessage());
echo("gagal terhubung ke server");
$db = false;
}
if($db){
try {
$que = "SELECT pel_no,
pel_nama,
pel_alamat,
dkd_kd,
kar_id,
tgl_baca,
rek_nomor,
rek_bln,
rek_thn,
rek_tgl,
rek_gol,
rek_stanlalu,
rek_stankini,
rek_uangair,
rek_adm,
rek_meter,
rek_angsuran,
rek_denda,
rek_materai,
rek_total,
rek_sts,
rek_byr_sts,
rek_ket
FROM tm_rekening where rek_sts='1' AND rek_byr_sts='0' and rek_bln='8' and rek_thn='2013' ORDER BY pel_no";
$i = 0;
foreach ($db->query($que) as $row) {
$kunci = array_keys($row);
for($j=0;$j<count($kunci);$j++){
$data[$i][$kunci[$j]] = $row[$kunci[$j]];
}
$i++;
}
echo("ditemukan ".$i." Piutang Pelanggan ".date('Ym'));
$db = null;
}
catch (PDOException $err){
echo($err->getMessage());
echo("gagal terhubung ke server SOPP");
}
}
$next = false;
if(isset($data)){
if(count($data)>0){
try {
$db = new PDO($dbC[0],$dbC[1],$dbC[2]);
echo "berhasil terhubung ke server <br/>";
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$next = true;
}
catch (PDOException $err){
echo "gagal terhubung ke server <br/>";
$next = false;
}
}
else{
$next = false;
}
}
if($next){
$que = "INSERT INTO plgtransfer(pel_no
rek_no,
rek_bln,
rek_thn,
rek_tgl,
rek_stanlalu,
rek_stankini,
rek_uangair,
rek_adm,
rek_meter,
rek_denda,
rek_materai,
rek_total,rek_sts,
rek_byr_sts)
VALUES(:pel_no,
:rek_nomor,
:rek_bln,
:rek_thn,
:rek_tgl,
:rek_stanlalu,
:rek_stankini,
:rek_uangair,
:rek_adm,
:rek_meter,
:rek_denda,
:rek_materai,
:rek_total,
:rek_sts,
:rek_byr_sts)";
$stmt = $db->prepare($que);
$l = 0;
for($k=0;$k<count($data);$k++){
$kunci = array_keys($data[$k]);
for($m=0;$m<count($kunci);$m++){
$kunci[$m] = $data[$k][$kunci[$m]];
}
if(isset($n[$rek_thn][$rek_bln]))
$n[$rek_thn][$rek_bln]++;
else
$n[$rek_thn][$rek_bln] = 1;
$o = $n[$rek_thn][$rek_bln];
$dkd_kd = substr($pel_no,0,2);
$rek_nomor = $rek_thn.$rek_bln.$dkd_kd.str_repeat('0',7-strlen($o)).$o;
$rek_tgl = date('Y-m-d H:i:s');
$rek_total = $rek_uangair + $rek_adm + $rek_meter + $rek_angsuran;
$idLog = $pel_no.".".str_repeat(0,2-strlen($rek_bln)).$rek_bln.$rek_thn;
if($rek_angsuran>0){
$rek_ket = "cicilan ke-".$rek_ket;
}
else{
$rek_ket = "NONE";
}
try {
$stmt -> bindParam(':pel_no', $pel_no);
$stmt -> bindParam(':rek_nomor', $rek_nomor);
$stmt -> bindParam(':rek_tgl', $rek_tgl);
$stmt -> bindParam(':rek_bln', $rek_bln);
$stmt -> bindParam(':rek_thn', $rek_thn);
$stmt -> bindParam(':rek_tgl', $rek_tgl);
$stmt -> bindParam(':rek_stanlalu', $rek_stanlalu);
$stmt -> bindParam(':rek_stankini', $rek_stankini);
$stmt -> bindParam(':rek_uangair', $rek_uangair);
$stmt -> bindParam(':rek_angsuran', $rek_angsuran);
$stmt -> bindParam(':rek_adm', $rek_adm);
$stmt -> bindParam(':rek_meter', $rek_meter);
$stmt -> bindParam(':rek_denda', $rek_denda);
$stmt -> bindParam(':rek_materai', $rek_materai);
$stmt -> bindParam(':rek_total', $rek_total);
$stmt -> bindParam(':rek_sts', $rek_sts);
$stmt -> bindParam(':rek_byr_sts', $rek_byr_sts);
$stmt -> execute();
if($stmt -> rowCount()>0){
echo("insert data tagihan ");
$l++;
}
}
catch (PDOException $err){
echo($err->getMessage());
echo("gagal insert data tagihan ");
}
}
$db = null;
echo($l." baris data tagihan di server telah diperbaharui");
}
/* eksekusi peruahan **/
else{
echo("transfer data piutang belum bisa");
}
?> |
| | //..
$stmt -> bindParam(':rek_angsuran', $rek_angsuran);//<--??
//
secara:
//..
$que = "INSERT INTO plgtransfer(pel_no
rek_no,
rek_bln,
rek_thn,
rek_tgl,
rek_stanlalu,
rek_stankini,
rek_uangair,
rek_adm,
rek_meter,
rek_denda,
rek_materai,
rek_total,rek_sts,
rek_byr_sts)
VALUES(:pel_no,
:rek_nomor,
:rek_bln,
:rek_thn,
:rek_tgl,
:rek_stanlalu,
:rek_stankini,
:rek_uangair,
:rek_adm,
:rek_meter,
:rek_denda,
:rek_materai,
:rek_total,
:rek_sts,
:rek_byr_sts)";
//..
where is my angsuran? |
Tidak ada komentar:
Posting Komentar