Gecko [ tradesense.co.ke ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
BaseController.php	1.36 KB	-rw-r--r--
Cellulant.php	4.9 KB	-rw-r--r--
EFT.php	8.33 KB	-rw-r--r--
Fund.php	18.05 KB	-rw-r--r--
Home.php	22.43 KB	-rw-r--r--
Interest.php	1 B	-rw-r--r--
Ipay.php	20.66 KB	-rw-r--r--
Mpesa.php	19.37 KB	-rw-r--r--
Profile.php	20.49 KB	-rw-r--r--
User.php	17.17 KB	-rw-r--r--

Code Editor : EFT.php

<?php

namespace App\Controllers;
use CodeIgniter\Session\Session;
use Config\Database;
use App\Models\LoginModel;
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

class EFT extends BaseController
{
     public function eftwithdraw()
    {
        $session = Session();
        $user = $session->get('user');
$fundid=$this->request->getGet('fundid');
$data['fundid'] = $fundid ;
 if ($user) {
    $this->db = Database::connect();
                    $userid= $user['userid'];
                    $number_of_students = "SELECT COUNT(*) as total FROM `notification` WHERE userid ='$userid' AND status = 'Not'";
        $data['number_of_new_offers'] = $this->db->query($number_of_students)->getRow();
 $notification = $this->db->query("SELECT * FROM `notification` WHERE userid ='$userid' ");
        $data['notification'] = $notification->getResultArray();

$queyy = $this->db->query("SELECT * FROM `user` WHERE userid ='$userid'");
        $data['merc'] = $queyy->getResultArray();
          $queyy = $this->db->query("SELECT * FROM `funds` WHERE userid ='$userid' AND fundid = '$fundid'");
        $data['fund'] = $queyy->getResultArray();
          $number_of_totalfund = "SELECT SUM(amount) as total FROM `funds` WHERE userid ='$userid'";
        $data['number_of_newtotl'] = $this->db->query($number_of_totalfund)->getRow();
        echo view('eftwithdraw',$data);

}
        else if (!$user) {        return redirect()->to('/login');

// code...
        }
    }
       public function eftpost()
    { $this->db = Database::connect();
        $session = Session();
         $user = $session->get('user');
          $userid= $user['userid'];
        $model = new LoginModel();

$amount = $this->request->getVar('amount');
                $fundid = $this->request->getVar('fundid');
                $bankname = $this->request->getVar('bankname');
                $branchnumber = $this->request->getVar('branchnumber');
                $accountnumber = $this->request->getVar('accountnumber');
                $bankcode = $this->request->getVar('bankcode');
                $beneficiaryname = $this->request->getVar('beneficiaryname');

$data = $model->where('userid', $userid)->first();
                        $rand=rand(1111111,9999999);

if($data){
             $fullname = $data['fullname'];
              $emailadress = $data['emailadress'];
              $mobilenumber = $data['mobilenumber'];

$paymenttype = 'Pay';
$paymentstatus = 'Not Confirmed';

$invoice = "AMANA-Eft-Withdraw" . $userid. $rand;
                $order_id = $fundid . $amount. $rand;

$data['paymenttype'] = $paymenttype;

$data['fundid'] = $fundid;
                $data['userid'] = $userid;
$data['emailadress'] = $emailadress;
                $data['mobilenumber'] = $mobilenumber;
                $data['invid'] = $invoice;
                $data['orderid'] = $order_id;
                $data['amount'] = $amount;
                $data['bankname'] = $bankname;
                $data['branchnumber'] = $branchnumber;
                $data['accountnumber'] = $accountnumber;

$session->set('activePayment', $data);

$eftModel = new \App\Models\EftModel();

$eftTransaction = [
                    "order_id" => $order_id,
                    "invoice_id" => $invoice,
                    "amount" => $amount,
                    "branchnumber" => $branchnumber,
                    "bankname" => $bankname,
                                        "beneficiaryname" => $beneficiaryname,
                                        "bankcode" => $bankcode,

"accountnumber" => $accountnumber,
                    "fundid" => $fundid,
              "userid" => $userid,
                            "paymenttype" => $paymenttype,

"paymentstatus" => $paymentstatus
                ];
 $number_of_students = "SELECT COUNT(*) as total FROM `notification` WHERE userid ='$userid' AND status = 'Not'";
        $data['number_of_new_offers'] = $this->db->query($number_of_students)->getRow();
 $notification = $this->db->query("SELECT * FROM `notification` WHERE userid ='$userid' ");
        $data['notification'] = $notification->getResultArray();

$queyy = $this->db->query("SELECT * FROM `user` WHERE userid ='$userid'");
        $data['merc'] = $queyy->getResultArray();
          $number_of_totalfund = "SELECT SUM(amount) as total FROM `funds` WHERE userid ='$userid'";
        $data['number_of_newtotl'] = $this->db->query($number_of_totalfund)->getRow();
                $eftModel->insert($eftTransaction);
    $session->set('processingeft', $data);
                return view('/eftconfirmation', $data);
                 // code...
             
                         }else{
           
            $session->setFlashdata('phone', 'NO USER FOUND ');
            return redirect()->to('/eftwithdraw');
        }
    }
      public function eftconfirmation()
    {
        $session = Session();
        $user = $session->get('user');

if ($user) {
    $this->db = Database::connect();
    $fundid=$this->request->getGet('fundid');
$data['fundid'] = $fundid ;
                    $userid= $user['userid'];
                    $number_of_students = "SELECT COUNT(*) as total FROM `notification` WHERE userid ='$userid' AND status = 'Not'";
        $data['number_of_new_offers'] = $this->db->query($number_of_students)->getRow();
 $notification = $this->db->query("SELECT * FROM `notification` WHERE userid ='$userid' ");
        $data['notification'] = $notification->getResultArray();

}
        else if (!$user) {        return redirect()->to('/login');

// code...
        }
    }
     public function eftconfirmationpost()
    {
        $session = Session();
        $user = $session->get('user');

if ($user) {

$this->db = Database::connect();
    $orderid=$this->request->getVar('orderid');
                    $userid= $user['userid'];

$eftModel = new \App\Models\EftModel();
        $eftverify = $eftModel
            ->where('order_id', $orderid)
            ->first();
            if ($eftverify) {
 $amount  = $eftverify['amount'];
 $status = 'Confirmed';
    $fundid  = $eftverify['fundid'];         
     $eft = "UPDATE efttransactions
SET paymentstatus = '$status' WHERE order_id = '$orderid' ";
       $tresulteft= $this->db->query($eft);

if ($tresulteft) {
$session->setFlashdata('confirmed', 'You Have Reinvested ');
                return redirect()->to('/eftstatus?orderid='.$orderid.'');
                       }

}
    }
        else if (!$user) {        return redirect()->to('/login');

// code...
        }
    }
     public function eftstatus()
    {
        $session = Session();
        $user = $session->get('user');

if ($user) {
    $this->db = Database::connect();
    $orderid=$this->request->getGet('orderid');
                    $userid= $user['userid'];
                    $number_of_students = "SELECT COUNT(*) as total FROM `notification` WHERE userid ='$userid' AND status = 'Not'";
        $data['number_of_new_offers'] = $this->db->query($number_of_students)->getRow();
 $notification = $this->db->query("SELECT * FROM `notification` WHERE userid ='$userid' ");
        $data['notification'] = $notification->getResultArray();
 $eftqueyy = $this->db->query("SELECT * FROM `efttransactions` WHERE order_id ='$orderid'");
        $data['eft'] = $eftqueyy->getResultArray();
                     $queyy = $this->db->query("SELECT * FROM `user` WHERE userid ='$userid'");
        $data['merc'] = $queyy->getResultArray();
          $number_of_totalfund = "SELECT SUM(amount) as total FROM `funds` WHERE userid ='$userid'";
        $data['number_of_newtotl'] = $this->db->query($number_of_totalfund)->getRow();
        echo view('eftstatus',$data);

}
        else if (!$user) {        return redirect()->to('/login');

// code...
        }
    }
}

${this.title}

Code Editor : EFT.php