https://t.me/RX1948
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //var/www/kanvakanva.com/public_html/application/models/Stat_sales_m.php
<?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;
	}

	
	
}

https://t.me/RX1948 - 2025