33 lines
1.1 KiB
Plaintext
33 lines
1.1 KiB
Plaintext
<?php
|
|
|
|
class Sales extends MY_Controller
|
|
{
|
|
|
|
function getdatas() {
|
|
$this->db_onedev = $this->load->database("onedev", true);
|
|
|
|
$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;
|
|
echo json_encode(array('status'=>'OK','pasien'=>$data_pasien,'penjualan'=>$data_penjualan));
|
|
exit;
|
|
}
|
|
|
|
}
|
|
?>
|