Hitung

<?php
/**
 * @author H.T (089660522887)
 * @link http://kuota123.com
 * @copyright 2017 - 2018
 */
defined('BASEPATH') or exit('No direct script access allowed');

class Hitung extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();
        ini_set('display_errors', '0');

    }


    function trx()
    {
        $komisi = "25"; // edit komisinya

        $sql ="SELECT
                    b.us_upline,count(b.us_upline) * ".$komisi." as bonus, DATE_FORMAT(DATE_SUB(DATE_FORMAT(NOW(),'%Y-%m-%d'),INTERVAL 1 day),'%d %b %Y') as tanggal
                FROM
                    transaksi a
                LEFT JOIN users b on a.us_id=b.us_id
                WHERE
                    a.tr_harga > 20000 and a.tr_status = 'sukses' and a.us_id <> '0'
                AND a.tr_tanggal BETWEEN unix_timestamp(DATE_SUB(DATE_FORMAT(NOW(),'%Y-%m-%d 00:00:00'),INTERVAL 1 day))
                AND unix_timestamp(DATE_SUB(DATE_FORMAT(NOW(),'%Y-%m-%d 23:59:59'),INTERVAL 1 day)) and us_upline is not null  GROUP BY b.us_upline
                ";

                $rows = $this->db->query($sql)->result();

                foreach ($rows as $row) {
                    $info = "Bonus Downline ".$row->tanggal."";
                    $id = $row->us_upline;
                    $bonus = $row->bonus;

                    $balance = $this->db->get_where('users', array('us_id'=>$id))->row()->us_balance;

                    $sql="select * from balance_history where info ='".$info."' and us_id='".$id."'";
                    $cek = $this->db->query($sql)->num_rows();
                    if ($cek == 0) {
                        $this->db->set('us_id', $id);
                        $this->db->set('debet', '0');
                        $this->db->set('kredit', $bonus);
                        $this->db->set('saldo_akhir', $balance+$bonus);
                        $this->db->set('info', $info);
                        $this->db->set('tanggal', time());
                        $this->db->insert('balance_history');

                        $this->db->set('us_balance', $balance+$bonus);
                        $this->db->where('us_id', $id);
                        $this->db->update('users');
                    }
                }

                echo "Hitung Komisi Sukses";
    }


}