<?php
require_once("../../class/page.php");
$tmp = new page();

include "../../reference/libchart/libchart/classes/libchart.php";
header('Content-type: image/png');
$rs = $tmp->QueryDB('select',"SELECT KDCAB FROM m_branch WHERE kdcab=1201");
$row = mysqli_fetch_array($rs)

$chart = new LineChart();
$date = gmdate("Y-m-j");
$year = substr($date,0,4);
$month = substr($date,5,2);
$day = substr($date,8,1);
$tanggal = $year."-".$month;

$table_name = "report_".$year.$month."_".$row[0];

$serie1 = new XYDataSet("");
$rs1 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='1' AND kdcab ='$row[0]' LIMIT 6");
while($row1 = mysqli_fetch_array($rs1)){
$serie1->addPoint(new Point(substr($row1[0],-5), $row1[2]));
}

$serie2 = new XYDataSet();
$rs2 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='2' AND kdcab ='$row[0]' LIMIT 6");
while($row2 = mysqli_fetch_array($rs2)){
$serie2->addPoint(new Point(substr($row2[0],-5), $row2[2]));
}

$serie3 = new XYDataSet();
$rs3 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='3' AND kdcab ='$row[0]' LIMIT 6");
while($row3 = mysqli_fetch_array($rs3)){
$serie3->addPoint(new Point(substr($row3[0],-5), $row3[2]));
}

$serie4 = new XYDataSet();
$rs4 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='4' AND kdcab ='$row[0]' LIMIT 6");
while($row4 = mysqli_fetch_array($rs4)){
$serie4->addPoint(new Point(substr($row4[0],-5), $row4[2]));
}

$dataSet = new XYSeriesDataSet();
$dataSet->addSerie("Taking Order", $serie1);
$dataSet->addSerie("Delivery & Collection ", $serie2);
$dataSet->addSerie("Critics & Advice", $serie3);
$dataSet->addSerie("Customer Register", $serie4);

$chart->setDataSet($dataSet);

$chart->setTitle("Ticket for $tanggal ($row[0])");
$chart->getPlot()->setGraphCaptionRatio(0.62);

$chart->render("../../images/generated/$table_name.png");
?>

<?php
require_once("../../class/page.php");
$tmp = new page();

include "../../reference/libchart/libchart/classes/libchart.php";
header('Content-type: image/png');

#ini saya kasih while nya
$rs = $tmp->QueryDB('select',"SELECT KDCAB FROM m_branch");
while($row = mysqli_fetch_array($rs)){

$chart = new LineChart();
$date = gmdate("Y-m-j");
$year = substr($date,0,4);
$month = substr($date,5,2);
$day = substr($date,8,1);
$tanggal = $year."-".$month;
$table_name = "report_".$year.$month."_".$row[0];

$serie1 = new XYDataSet("");
$rs1 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='1' AND kdcab ='$row[0]' LIMIT 6");
while($row1 = mysqli_fetch_array($rs1)){
$serie1->addPoint(new Point(substr($row1[0],-5), $row1[2]));
}

$serie2 = new XYDataSet();
$rs2 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='2' AND kdcab ='$row[0]' LIMIT 6");
while($row2 = mysqli_fetch_array($rs2)){
$serie2->addPoint(new Point(substr($row2[0],-5), $row2[2]));
}

$serie3 = new XYDataSet();
$rs3 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='3' AND kdcab ='$row[0]' LIMIT 6");
while($row3 = mysqli_fetch_array($rs3)){
$serie3->addPoint(new Point(substr($row3[0],-5), $row3[2]));
}

$serie4 = new XYDataSet();
$rs4 = $tmp->QueryDB('select',"SELECT * FROM $table_name WHERE tanggal LIKE '$tanggal%' AND category ='4' AND kdcab ='$row[0]' LIMIT 6");
while($row4 = mysqli_fetch_array($rs4)){
$serie4->addPoint(new Point(substr($row4[0],-5), $row4[2]));
}

$dataSet = new XYSeriesDataSet();
$dataSet->addSerie("Taking Order", $serie1);
$dataSet->addSerie("Delivery & Collection ", $serie2);
$dataSet->addSerie("Critics & Advice", $serie3);
$dataSet->addSerie("Customer Register", $serie4);

$chart->setDataSet($dataSet);

$chart->setTitle("Ticket for $tanggal ($row[0])");
$chart->getPlot()->setGraphCaptionRatio(0.62);

$chart->render("../../images/generated/$table_name.png");
}
?>