<?php
require_once('DB.php');

class CompanyCharts extends DB {

	private $dbServer;
    private $dbUser;
    private $dbPass;
    private $dbName;
    private $conn;
    private $dbSelect;
    public $db;

	public function __construct() {
        $this->dbServer = "localhost";
        $this->dbUser = "root";
        $this->dbPass = "";
        $this->dbName = "lms";
        parent::__construct($this->dbServer, $this->dbUser, $this->dbPass, $this->dbName);
    }


	public function leads_chart(){


		$lead_chart = array();
		$pie_data = array();
		$lead_chart['type']  = 'pie';
		$lead_chart['name']  = 'Leads Summary';
		$lead_chart['innerSize']  = '10%';


		$sql = "SELECT status  as project_type , COUNT(*) as project_ratio FROM  lead GROUP BY status;";

		$data = parent::query($sql);

		// print_r($data);

		$result_data  = array();
		foreach ($data as $_key => $_value) {
			$result = array();
			switch ($_value['project_type']) {
					case '-1':
						$result['0'] ="rejected" ;
						$result['1'] = $_value['project_ratio'];
						break;

					case '1':
						$result['0'] ="accepted" ;
						$result['1'] = $_value['project_ratio'];
						// $result[]['accepted'] = $_value['project_ratio'];
						break;

					case '0':
						$result['0'] ="pending" ;
						$result['1'] = $_value['project_ratio'];
						// $result[]['pending'] =$_value['project_ratio'];
						break;
				}
				 array_push($result_data, $result);
				// echo $_value['project_type'] . ' => ' . $_value['project_ratio'] . "<br>";
		}
			// print_r($result) ;

	 	 $lead_chart['data'] = $result_data;
		// // $result['data'] = $pie_data;
		 array_reverse($lead_chart);
		return (json_encode(array($lead_chart)));
	}



}

$cc = new CompanyCharts();
echo $cc->leads_chart();