/**
 * Created by PhpStorm.
 * User: Wu
 * Date: 12/22/15
 * Time: 1:45 PM
 */
require_once "Security.php";
$startdate = $_GET["startdate"];
$enddate = $_GET["enddate"];
function fix_keys($array)
{
    foreach ($array as $k => $val) {
        if (is_array($val)) {
            $array[$k] = fix_keys($val);
        }
        //recurse
    }
    return array_values($array);
}
require_once "DataBaseEngine.php";
$db = new DataBaseEngine();
$stmt = $db->selectSumData($startdate, $enddate);
$data2 = array();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $org = $row['org'];
    $money = $row['summoney'];
    array_push($data2, array($org, $money));
}
$data3["data"] = fix_keys($data2);
echo json_encode($data3);