0
AND tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY)");
$qroa=mysqli_query($con,"SELECT COUNT(custno) as roa FROM pjppersonildetail WHERE kdslm='$_GET[id]' GROUP BY kdslm;");
$qec=mysqli_query($con,"SELECT COUNT(nobukti) as ec FROM somobileheader WHERE kdslm='$_GET[id]' AND tgl<=CURDATE() and netto<>0
AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY);");
$omset = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_GET[id]'
and tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) group by kdslm;");
$omset3 = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_GET[id]'
and tgl<='$tgl[tgl]' AND tgl>='$tgla[tgl1]' group by kdslm;");
$query = mysqli_query($con,"SELECT a.kdslm,a.cabang,a.nmslm,a.alamat1,a.alamat2,a.noidentitas,a.tgl,a.kdgudang,b.keterangan as nmgudang from salesman a,gudang b where a.kdgudang=b.kdgudang and a.kdslm='$_GET[id]';");
$tagih= mysqli_query($con,"select sum(total) as total,sum(totalfaktur) as tfaktur,GROUP_CONCAT(CONCAT(nobukti)) as nolph from tagihanheader where kdslm='$_GET[id]' and tgltagih=curdate();");
} elseif ($jabat=='2') {
$omset = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_GET[id]'
and tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) group by kdslm;");
$omset3 = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_GET[id]'
and tgl<='$tgl[tgl]' AND tgl>='$tgla[tgl1]' group by kdslm;");
$qac=mysqli_query($con,"SELECT COUNT(a.custno) as ac FROM somobileheader a WHERE kdslm='$_GET[id]' and netto<>0
AND tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) GROUP BY custno;");
$qroa=mysqli_query($con,"SELECT COUNT(custno) as roa FROM pjppersonildetail WHERE kdslm='$_GET[id]' GROUP BY custno;");
$qec=mysqli_query($con,"SELECT COUNT(nobukti) as ec FROM somobileheader WHERE kdslm='$_GET[id]' AND tgl<=CURDATE() and netto<>0
AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY);");
$query = mysqli_query($con,"SELECT a.kdslm,a.cabang,a.nmslm,a.alamat1,a.alamat2,a.noidentitas,a.tgl,a.kdgudang,b.keterangan as nmgudang from salesman a,gudang b where a.kdgudang=b.kdgudang and a.kdslm='$_GET[id]';");
$tagih= mysqli_query($con,"select sum(total) as total,sum(totalfaktur) as tfaktur,GROUP_CONCAT(CONCAT(nobukti)) as nolph from tagihanheader where kdslm='$_GET[id]' and tgltagih=curdate();");
} else {
$omset = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_SESSION[yuser]'
and tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) group by kdslm;");
$qac=mysqli_query($con,"SELECT COUNT(custno) as ac FROM somobileheader WHERE kdslm='$_SESSION[yuser]'
AND tgl<=CURDATE() AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) GROUP BY custno;");
$qroa=mysqli_query($con,"SELECT COUNT(custno) as roa FROM pjppersonildetail WHERE kdslm='$_SESSION[yuser]' GROUP BY custno;");
$qec=mysqli_query($con,"SELECT COUNT(nobukti) as ec FROM somobileheader WHERE kdslm='$_SESSION[yuser]' AND tgl<=CURDATE() and netto<>0
AND tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY);");
$query = mysqli_query($con,"SELECT a.kdslm,a.cabang,a.nmslm,a.alamat1,a.alamat2,a.noidentitas,a.tgl,a.kdgudang,b.keterangan as nmgudang from salesman a,gudang b where a.kdgudang=b.kdgudang and a.kdslm='$_SESSION[yuser]';");
$tagih= mysqli_query($con,"select sum(total) as total,sum(totalfaktur) as tfaktur,GROUP_CONCAT(CONCAT(nobukti)) as nolph from tagihanheader where kdslm='$_SESSION[yuser]' and tgltagih=curdate();");
$omset3 = mysqli_query($con,"select sum((qty*hs)-ndisc1-ndisc1a-ndisc2-ndisc2a-ndisc3) as omset from analisapenjualan where kdslm='$_SESSION[yuser]'
and tgl<='$tgl[tgl]' AND tgl>='$tgla[tgl1]' group by kdslm;");
}
$data = mysqli_fetch_array($query);
$omsetjual=0;
$real=0;
$dua=mysqli_num_rows($omset3);
$tiga=mysqli_num_rows($omset);
if($dua>0) {
$data3 = mysqli_fetch_array($omset3);
$omsetjual=$data3['omset'];
}
if($tiga>0) {
$data2 = mysqli_fetch_array($omset);
$real=$data2['omset'];
}
$lph = mysqli_fetch_array($tagih);
$roa=mysqli_fetch_array($qroa);
$ac=mysqli_fetch_array($qac);
$ec=mysqli_fetch_array($qec);
$system="Select cabang,kdgudang from system limit 1";
$dsystem=mysqli_query($con,$system);
$datasystem= mysqli_fetch_array($dsystem);
$_cbg=$datasystem['cabang'];
$_gdg=$datasystem['kdgudang'];
?>
IBS