<?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>