| Server IP : 84.32.84.151 / Your IP : 216.73.216.163 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/IDI/noperlu/ |
Upload File : |
<?php ob_start(); session_start();
if (!isset($_SESSION["npm"])) {
header("location:login.php");
}
$level=$_SESSION["level"];
if ($level!=admin) {
echo "Anda tidak punya akses pada halaman admin";
header("location:login.php");
exit;
}
$id_user=$_SESSION["npm"];
$username=$_SESSION["level"];
?>
<?php include "menu3.php"; ?>
<?php include "koneksi.php"; ?><title>Lead Journal</title>
<style type="text/css">
<!--
.style2 {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
<p> </p>
<div class="container">
<div class="panel panel-primary">
<div class="panel-body">
<center>
<img src="assets/img/agung.jpg" alt="..." width="100" height="150" class="img-thumbnail">
<head>
<link rel="icon" href="./assets/img/idilogo.png">
<script type="text/javascript" src="Chart.js"></script>
<style type="text/css">
<!--
.style1 {font-size: 14px}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<p>
<style type="text/css">
body{
font-family: roboto;
}
table{
margin: 0px auto;
}
</style>
</p>
<center><h4>GRAFIK JOURNAL LEADS
<br/>
<br/>
<span class="style2"><br/>
<?php
//$koneksi = mysqli_connect("localhost","bhaktiag_sales","cleosa2020","bhaktiag_sales");
//$koneksi = mysqli_connect("localhost","root","","agdsales");
?>
<div style="width: 800px;margin: 0px auto;">
<canvas id="myChart"></canvas>
</div>
<div style="width: 350px;margin: 0px auto;">
<canvas id="myChart2"></canvas>
</div>
<div class="panel-body">
<div align="center">
</br>
</div>
<center><h4>Agung Development Project
</br>
</br>
<table class="demo-table responsive" >
<thead>
<tr>
<th>No</th>
<th>Project</th>
<th>Total Leads</th>
<th>Total Leads + Followup</th>
<th>Closing</th>
<th>Hot Prospek</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
// $data2 = mysqli_query($konek, "SELECT tb_project.gambar2,tb_project.project
// FROM mahasiswa JOIN tb_project ON tb_project.npm = mahasiswa.npm where mahasiswa.npm='$_SESSION[npm]' ");
//$ds=mysqli_fetch_array($data2);
//$project= $ds['project'];
//(SELECT id, nama, judul, pesan, tanggal, '0' as is_spam FROM bukutamu)
//UNION
//(SELECT id, nama, judul, pesan, tanggal, '1' as is_spam FROM spam)
//ORDER BY tanggal DESC;
$data = mysqli_query($konek,"select mahasiswa.gambar2,count(distinct(d_reg.nmlead)) as lead,count((IF(d_reg.kode='Closing',0,NULL))) as total,count((IF(d_reg.kode='Hot Prospek',0,NULL))) as hot,d_reg.project,d_reg.nmlead, d_reg.npm ,count(d_reg.project) as jumlah,mahasiswa.nama_mhs from d_reg INNER JOIN mahasiswa ON d_reg.npm=mahasiswa.npm group by project ");
// $data = mysqli_query($konek, "SELECT tb_project.gambar2,d_nonspp.project ,count(distinct(d_nonspp.nmlead)) as lead, 0 as hot, 0 as total
// FROM mahasiswa
//JOIN tb_project ON tb_project.npm = mahasiswa.npm
//JOIN d_nonspp ON d_nonspp.project = mahasiswa.project
//GROUP BY tb_project.project ");
while($d=mysqli_fetch_array($data)){
?>
<tr>
<td data-header='No'><?php echo $no++; ?></td>
<td data-header='Project'><img src=./file/<?php echo $d['gambar2']; ?> width='50' height='50'class="img-thumbnail> "; </br>
<a href='./grafik/grafikproject.php?project=<?php echo $d['project']; ?>'><?php echo $d['project']; ?></a></td>
<td data-header='Total Input Leads'><?php echo $d['lead']; ?></td>
<td data-header='Total Input Leads'><?php echo $d['jumlah']; ?></td>
<td data-header='Closing'><?php echo $d['total']; ?></td>
<td data-header='Hot Prospek'><?php echo $d['hot']; ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div align="center">
<?php
$produk = mysqli_query($konek,"select d_reg.project,count(d_reg.nmlead) as total from d_reg INNER JOIN mahasiswa ON d_reg.npm=mahasiswa.npm where d_reg.kode <> 'Close' group by project order by project ");
while($row = mysqli_fetch_array($produk)){
$nama_produk[] = $row['project'];
$total[] = $row['total'];
}
?>
<script>
var ctx = document.getElementById("myChart").getContext('2d');
var myChart = new Chart(ctx, {
type: 'bar',
data: {
labels: <?php echo json_encode($nama_produk); ?>,
datasets: [{
label: 'Grafik Followup Leads',
data: <?php echo json_encode($total); ?>,
backgroundColor: [
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)',
'rgba(153, 102, 255, 0.2)',
'rgba(255, 159, 64, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)',
'rgba(153, 102, 255, 0.2)',
'rgba(255, 159, 64, 0.2)'
],
borderColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(153, 102, 255, 1)',
'rgba(255, 159, 64, 1)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)',
'rgba(153, 102, 255, 0.2)',
'rgba(255, 159, 64, 0.2)'
],
borderWidth: 1
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero:true
}
}]
}
}
});
</script>
</div>
<?php
$produk = mysqli_query($konek,"select count((IF(d_reg.kode='Closing',0,NULL))) as total,count(d_reg.kode) as hot,d_reg.kode from d_reg where kode <> 'Close' AND kode <> 'Non' AND kode <> 'Prospek' group by kode ");
//$produk = mysqli_query($konek,"select kode,count((IF(kode='Hot Prospek',0,NULL))) as total from d_nonspp where kode <> 'Close' group by project order by kode ");
while($row2 = mysqli_fetch_array($produk)){
$nama_produk2[] = $row2['kode'];
$total2[] = $row2['hot'];
$total3[] = $row2['total'];
}
?>
0
<script>
var ctx = document.getElementById("myChart2").getContext('2d');
var myChart = new Chart(ctx, {
type: 'pie',
data: {
labels: <?php echo json_encode($nama_produk2); ?>,
datasets: [{
label: 'Grafik Closing - Hot Prospek Leads',
data: <?php echo json_encode($total2); ?>,
backgroundColor: [
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(25, 206, 86, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(255, 99, 132, 0.2)',
'rgba(255, 206, 86, 0.2)',
'rgba(25, 206, 86, 0.2)',
'rgba(75, 192, 192, 0.2)'
],
borderColor: [
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)',
'rgba(255,99,132,1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 206, 86, 1)',
'rgba(25, 206, 86, 1)',
'rgba(75, 192, 192, 1)'
],
borderWidth: 1
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero:true
}
}]
}
}
});
</script>
</div>
<p>
</p>
<center> <a href="data_sales.php"><span class="glyphicon glyphicon-user"></span> Data Sales</a></center>
<p> </p>
<?php include "footer.php"; ?>
</div>
</body>
</html>