aDriv4 website!

Linux premium157.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
LiteSpeed
162.0.235.222

ResultModel.php

<?php

namespace App\Models;

use CodeIgniter\Model;

class ResultModel extends Model
{
    protected $table            = 'result_togel';
    protected $primaryKey       = 'ID';
    protected $returnType       = 'array';
    protected $allowedFields    = [];

public function getResult($start = 0, $length = 0, $limit = 1, $sDate = '', $eDate = '', $pool = '', $prize = '')
    {
        $SQL = "SELECT A.*,B.Name,ROW_NUMBER() OVER (ORDER BY A.Date DESC) AS Number FROM result_togel A
        LEFT JOIN pools B on A.Pool = B.ID WHERE 1";

if ($sDate <> '' and $eDate <> '') {
            $SQL = $SQL . " and Date between '" . $sDate . " 00:00:00' and '" . $eDate . " 23:59:59'";
        } else if ($sDate <> '') {
            $SQL = $SQL . " and Date between '" . $sDate . " 00:00:00' and '" . $sDate . " 23:59:59'";
        } else if ($eDate <> '') {
            $SQL = $SQL . " and Date between '" . $eDate . " 00:00:00' and '" . $eDate . " 23:59:59'";
        }

if ($pool <> '') {
            $SQL = $SQL . " and B.ID =" . $pool;
        }

if ($prize <> '') {
            $SQL = $SQL . " and Prize like '%" . $prize . "%'";
        }

$SQL = $SQL . " order by A.Date Desc";

if ($limit) {
            if ($start <> 0 or $length <> 0) {
                $SQL = $SQL . " LIMIT " . $start . ", " . $length;
            }
        }
        return $this->query($SQL)->getResultArray();
    }

public function summaryResult($sDate = '', $eDate = '', $pool = '', $prize = '')
    {
        $SQL = "SELECT COUNT(A.ID) AS Total FROM result_togel A
        LEFT JOIN pools B on A.Pool = B.ID WHERE 1";

if ($pool <> '') {
            $SQL = $SQL . " and B.ID =" . $pool;
        }

if ($prize <> '') {
            $SQL = $SQL . " and Prize like '%" . $prize . "%'";
        }

return $this->query($SQL)->getResultArray();
    }

public function newResult($data)
    {
        $this->db->query('START TRANSACTION');

if (!($this->db->table($this->table)->insert($data))) {
            $this->db->query('ROLLBACK');
            return false;
        };

$this->db->query('COMMIT');
        return true;
    }

public function editResult($data, $where)
    {
        $this->db->query('START TRANSACTION');

if (!($this->db->table($this->table)->update($data, $where))) {
            $this->db->query('ROLLBACK');
            return false;
        };

$this->db->query('COMMIT');
        return true;
    }

public function deleteResult($where)
    {
        $this->db->query('START TRANSACTION');

if (!($this->db->table($this->table)->delete($where))) {
            $this->db->query('ROLLBACK');
            return false;
        };

$this->db->query('COMMIT');
        return true;
    }

public function checkdate($date, $pool)
    {
        $SQL = "SELECT * FROM result_togel WHERE DATE(Date) = '$date' AND Pool = $pool";

return $this->query($SQL)->getResultArray();
    }

public function getDataResultTogel($id = '')
    {
        if ($id) {
            $SQL = "SELECT * FROM pools WHERE ID = ?";
            return $this->query($SQL, [$id])->getResultArray();
        } else {
            $SQL = "SELECT A.ID, A.Name, A.Logo, SUBSTRING_INDEX(B.Prize, ',', 1) AS Prize, B.Date
                    FROM pools A
                    INNER JOIN (
                        SELECT Pool, Prize, Date
                        FROM result_togel
                        WHERE (Pool, Date) IN (
                            SELECT Pool, MAX(Date) AS Date
                            FROM result_togel WHERE Date(Date) <= Date(NOW())
                            GROUP BY Pool
                        )
                    ) AS B ON A.ID = B.Pool ORDER BY B.Date DESC;";
            return $this->query($SQL)->getResultArray();
        }
    }

public function getLivedraw($id)
    {
        $SQL = "SELECT A.ID, B.Prize AS Prize, B.Date 
        FROM pools A 
        LEFT JOIN result_togel B ON A.ID = B.Pool 
        WHERE A.ID = $id AND B.Date <= CURDATE() 
        ORDER BY B.Date DESC";
        return $this->query($SQL)->getResultArray();
    }

public function getAllDataResult($id = '')
    {
        $SQL = "SELECT A.ID, A.Name,A.Logo, B.Prize AS Prize, B.Date, A.ResultTime
        FROM pools A 
        LEFT JOIN result_togel B ON A.ID = B.Pool";
        if ($id) {
            $SQL .= " WHERE A.ID = $id AND Date(B.Date) <= Date(NOW())";
        }
        $SQL .= " ORDER BY B.Date DESC";
        return $this->query($SQL)->getResultArray();
    }

public function getResultTogel($idpool)
    {
        $SQL = "SELECT B.ClosingTime,B.ResultTime,B.Name,A.Date,SUBSTRING_INDEX(A.Prize, ',', 1) AS Prize FROM result_togel A LEFT JOIN pools B ON A.Pool = B.ID
        WHERE A.Pool = $idpool and DATE(A.Date) <= DATE(NOW()) ORDER BY A.DATE DESC";
        return $this->query($SQL)->getResultArray();
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	linkwbay/linkwbay	0755	2025-07-31 08:53:01
..	dir	-	linkwbay/linkwbay	0755	2025-07-31 08:53:01
.gitkeep	application/x-empty	0 B	linkwbay/linkwbay	0644	2025-05-13 12:15:40
.htaccess	text/plain	127 B	linkwbay/linkwbay	0444	2025-07-31 08:53:01
BannerModel.php	text/x-php	2.06 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
FaqsModel.php	text/x-php	1.78 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
KeluhanModel.php	text/x-php	1.51 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
MenuModel.php	text/x-php	343 B	linkwbay/linkwbay	0644	2025-05-13 12:15:40
MimpiModel.php	text/x-php	2.26 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
PanduanModel.php	text/x-php	2.85 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
PoolsModel.php	text/x-php	2.23 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
PredictionModel.php	text/x-php	3.34 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
ResultModel.php	text/x-php	5.43 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40
SettingModel.php	text/x-php	939 B	linkwbay/linkwbay	0644	2025-05-13 12:15:40
UserModel.php	text/x-php	2.7 KB	linkwbay/linkwbay	0644	2025-05-13 12:15:40

For more Private tool come to me!

https://t.me/aDriv4vz