Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/kanvakanva.com/public_html/application/models/ |
Upload File : |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Stat_sales_m extends MY_Model { function __construct() { parent::__construct(); } //pagination included function get_sales_days($date) { $this->db->select('SUM(total_amount-shipping_fee) as jumlah_bersih, SUM(total_amount) as jumlah_kotor , CAST(order_date AS DATE) as tgl'); $this->db->from('orders'); $this->db->where(' DATE(order_date) = "'.$date.'" and ( payment_status = 3 or payment_status = 4 or payment_status = 1) '); $query = $this->db->get(); return $query->row(); } function get_product_sales($start_date, $end_date) { $result = $this->db->query(" SELECT * FROM orders_detail WHERE orders_id IN (SELECT id_orders FROM orders WHERE DATE(order_date) >= '".$start_date."' and DATE(order_date) <= '".$end_date."' and ( payment_status = 3 or payment_status = 4 or payment_status = 1) ) ")->result(); return $result; } }