60 lines
2.2 KiB
PHP
60 lines
2.2 KiB
PHP
<?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;
|
|
}
|
|
|
|
}
|
|
?>
|