IBS

Home About Logout

"; if ($jabat=='1') { $query1 = "SELECT '$_SESSION[yuser]' as salesman,a.custno,b.custname,b.alamat1 from pjppersonildetail a left join customer b on a.custno=b.custno and a.cabang=b.cabang where a.kdslm='$_SESSION[yuser]' and UPPER(b.custname) LIKE UPPER('%$cari%')"; } else { $query1 = "SELECT '$_SESSION[salesman]' as salesman,a.custno,b.custname,b.alamat1 from pjppersonildetail a left join customer b on a.custno=b.custno and a.cabang=b.cabang where a.kdslm='$_SESSION[salesman]' and UPPER(b.custname) LIKE UPPER('%$cari%')"; } $sql01 = mysql_query($query1); if ($sql01 >0 ){ $no = 1; // Untuk penomoran tabel, di awal set dengan 1 while($data1 = mysql_fetch_array($sql01)){ $custno1=$data1['custno']; $_SESSION['slm']=$data1['salesman']; if ($jabat=='1') { $status=mysql_query("select '

' as dp, '

' as bl,'OK' as ok,custno,kdslm from customer_log where kdslm='$_SESSION[yuser]' and custno='$custno1' and tgl=curdate();");} else { $status=mysql_query("select '

' as dp, '

' as bl,'OK' as ok,custno,kdslm from customer_log where kdslm='$slm' and custno='$custno1' and tgl=curdate();");} $st=mysql_fetch_array($status); // $nilait=$nilait+$data['jumlah']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $no++; // Tambah 1 setiap kali looping } } else { echo""; } } else { $sql0 = mysql_query($query); if ($sql0 >0 ){ $no = 1; // Untuk penomoran tabel, di awal set dengan 1 while($data = mysql_fetch_array($sql0)){ $custno=$data['custno']; if ($jabat=='1') { $status=mysql_query("select '

' as dp, '

' as bl,'OK' as ok,custno,kdslm from customer_log where kdslm='$_SESSION[yuser]' and custno='$custno' and tgl=curdate();");} else { $status=mysql_query("select '

' as dp, '

' as bl,'OK' as ok,custno,kdslm from customer_log where kdslm='$slm' and custno='$custno' and tgl=curdate();");} $_SESSION['slm']=$data['salesman']; $st=mysql_fetch_array($status); // $nilait=$nilait+$data['jumlah']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $no++; // Tambah 1 setiap kali looping } } else { echo""; } } ?>

Nama	Alamat	Aksi	ST
".$data1['custname']."	".$data1['alamat1']."	Detail	".$st['dp'].$st['ok'].$st['bl']."
Data Pelanggan Not Found.
".$data['custname']."	".$data['alamat1']."	Detail	".$st['dp'].$st['ok'].$st['bl']."
Data Pelanggan Not Found.

Kembali