<?php

class Sales extends MY_Controller
{

    function getdatas(){
		$prm = $this->sys_input;
		//print_r($prm);
		$this->db_onedev = $this->load->database("onedev", true);
		if($prm['type'] == 'month'){
			$sql = "SELECT COUNT(*) as total
					FROM t_orderheader
					JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND
					ISNULL(T_OrderHeaderAddOnLabNumberOrigin)
					WHERE
					MONTH(T_OrderHeaderDate) = MONTH(NOW()) AND 
					YEAR(T_OrderHeaderDate) = YEAR(NOW())  AND
					T_OrderHeaderIsActive = 'Y'";
			$data_pasien = $this->db_onedev->query($sql)->row()->total;
			$sql = "SELECT ROUND(SUM(IFNULL(T_OrderHeaderTotal,0))/1000000,2) as total
					FROM t_orderheader
					JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND
					ISNULL(T_OrderHeaderAddOnLabNumberOrigin)
					WHERE
					MONTH(T_OrderHeaderDate) = MONTH(NOW()) AND 
					YEAR(T_OrderHeaderDate) = YEAR(NOW())  AND
					T_OrderHeaderIsActive = 'Y'";
			$data_penjualan = $this->db_onedev->query($sql)->row()->total;
		}
		if($prm['type'] == 'day'){
			$sql = "SELECT COUNT(*) as total
					FROM t_orderheader
					JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND
					ISNULL(T_OrderHeaderAddOnLabNumberOrigin)
					WHERE
					DAY(T_OrderHeaderDate) = DAY(NOW()) AND 
					MONTH(T_OrderHeaderDate) = MONTH(NOW()) AND 
					YEAR(T_OrderHeaderDate) = YEAR(NOW())  AND
					T_OrderHeaderIsActive = 'Y'";
			//echo $sql;
			$data_pasien = $this->db_onedev->query($sql)->row()->total;
			$sql = "SELECT ROUND(SUM(IFNULL(T_OrderHeaderTotal,0))/1000000,2) as total
					FROM t_orderheader
					JOIN t_orderheaderaddon ON T_OrderHeaderAddOnT_OrderHeaderID = T_OrderHeaderID AND
					ISNULL(T_OrderHeaderAddOnLabNumberOrigin)
					WHERE
					DAY(T_OrderHeaderDate) = DAY(NOW()) AND 
					MONTH(T_OrderHeaderDate) = MONTH(NOW()) AND 
					YEAR(T_OrderHeaderDate) = YEAR(NOW())  AND
					T_OrderHeaderIsActive = 'Y'";
			$data_penjualan = $this->db_onedev->query($sql)->row()->total;
		}
		
		echo json_encode(array('status'=>'OK','pasien'=>$data_pasien,'penjualan'=>$data_penjualan));
		exit;
    }

}
?>