<?php
if (isset($_GET['month']))
    $month = $_GET['month'];
else
    $month = date("m");

if (isset($_GET['year']))
    $year = $_GET['year'];
else
    $year = date("Y");



$month_sql = "YEAR(date) = ".$year." AND MONTH(date) = ".$month;
$sql = "SELECT * FROM `sales` WHERE ".$month_sql." AND `agensi` = '".$agensi."'  ORDER BY `date` ASC  ";
$result = mysqli_query($con,$sql);
$kunjungan = array_fill(0, 35, 0);
$sales_2p = array_fill(0, 35, 0);
$sales_3p = array_fill(0, 35, 0);
$sales_migrasi = array_fill(0, 35, 0);

$sql2 = "SELECT * FROM `sales` WHERE ".$month_sql." AND `userid` = '".$userid."'  ORDER BY `date` ASC  ";
$result2 = mysqli_query($con,$sql2);
$kunjungan2 = array_fill(0, 35, 0);
$sales_2p2 = array_fill(0, 35, 0);
$sales_3p2 = array_fill(0, 35, 0);
$sales_migrasi2 = array_fill(0, 35, 0);

$loop = 1;
while ($row = mysqli_fetch_array($result))
{
    $date = DateTime::createFromFormat("Y-m-d", $row['date']);

    $kunjungan[intval($date->format("d"))]      = $kunjungan[intval($date->format("d"))]        + $row ['kunjungan'];
    $sales_2p[intval($date->format("d"))]       = $sales_2p[intval($date->format("d"))]         + $row ['sales_2p'];
    $sales_3p[intval($date->format("d"))]       = $sales_3p[intval($date->format("d"))]         + $row ['sales_3p'];
    $sales_migrasi[intval($date->format("d"))]  = $sales_migrasi[intval($date->format("d"))]    + $row ['sales_migrasi'];


}

$loop = 1;
while ($row2 = mysqli_fetch_array($result2))
{
    $date = DateTime::createFromFormat("Y-m-d", $row2['date']);

    $kunjungan2[intval($date->format("d"))]         = $kunjungan2[intval($date->format("d"))]       + $row2 ['kunjungan'];
    $sales_2p2[intval($date->format("d"))]          = $sales_2p2[intval($date->format("d"))]        + $row2 ['sales_2p'];
    $sales_3p2[intval($date->format("d"))]          = $sales_3p2[intval($date->format("d"))]        + $row2 ['sales_3p'];
    $sales_migrasi2[intval($date->format("d"))]     = $sales_migrasi2[intval($date->format("d"))]   + $row2 ['sales_migrasi'];


}

$month_day = cal_days_in_month(CAL_GREGORIAN, $month, $year);

$chart_data = '';
for ($loop = 1; $loop<=$month_day; $loop++)
{
    $chart_data .= "{

    \"date\": \"".$loop."\", kunjungan : ".$kunjungan[$loop].",sales_2p : ".$sales_2p[$loop].", sales_3p:".$sales_3p[$loop].", sales_migrasi:".$sales_migrasi[$loop].",
    kunjungan2 : ".$kunjungan2[$loop].",sales_2p2 : ".$sales_2p2[$loop].", sales_3p2:".$sales_3p2[$loop].", sales_migrasi2:".$sales_migrasi2[$loop]."

    }, ";

}
$chart_data = substr($chart_data,0,-2);


?>




<script>
Morris.Line({
 element : 'sales-chart',

 data:[<?php echo $chart_data; ?>],
 xkey:'date',
 ykeys:['kunjungan','sales_2p', 'sales_3p','sales_migrasi','kunjungan2','sales_2p2', 'sales_3p2','sales_migrasi2'],
 labels:['Kunjungan <?php echo $agensi_echo;?>','Sales 2P <?php echo $agensi_echo;?>', 'Sales 3P <?php echo $agensi_echo;?>','Migrasi <?php echo $agensi_echo;?>',
 'Kunjungan <?php echo $userid;?>','Sales 2P <?php echo $userid;?>', 'Sales 3P <?php echo $userid;?>','Migrasi <?php echo $userid;?>'],
 hideHover:'auto',
 stacked:true,
 parseTime: false,
 behaveLikeLine: true,
});
</script>