Olu Amey
135 lines
5.4 KiB
PHP
135 lines
5.4 KiB
PHP
<?php
|
|
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Bkoreport extends Bko_Controller {
|
|
/*
|
|
var $template = array(
|
|
'table_open' => "<table class='table table-striped table-hover table-bordered table-condensed'>",
|
|
'thead_open' => '<thead>',
|
|
'thead_close' => '</thead>',
|
|
'heading_row_start' => '<tr>',
|
|
'heading_row_end' => '</tr>',
|
|
'heading_cell_start' => '<th>',
|
|
'heading_cell_end' => '</th>',
|
|
'tbody_open' => '<tbody>',
|
|
'tbody_close' => '</tbody>',
|
|
'row_start' => '<tr>',
|
|
'row_end' => '</tr>',
|
|
'cell_start' => '<td>',
|
|
'cell_end' => '</td>',
|
|
'row_alt_start' => '<tr>',
|
|
'row_alt_end' => '</tr>',
|
|
'cell_alt_start' => '<td>',
|
|
'cell_alt_end' => '</td>',
|
|
'table_close' => '</table>'
|
|
);
|
|
|
|
*
|
|
*/
|
|
public function index() {
|
|
$data["username"] = "";
|
|
$this->load->view('bko/view_bko_login', $data);
|
|
}
|
|
|
|
public function logout() {
|
|
$data['username'] = $data['password'] = '';
|
|
$this->load->view('bko/view_bko_login', $data);
|
|
}
|
|
|
|
public function withdraws() {
|
|
$data["title"] = "Withdraws Report";
|
|
$mysql = "SELECT m.added::date AS date,m.terminatingamount*0.01 AS amount,m.fee*0.01 as fee, "
|
|
. "mm.firstname||' '||mm.lastname||'<br>Email:'||mm.email AS Sender,"
|
|
. "r.firstname||' '||r.lastname||'<br><b>Acc:</b>'||r.account_no||'-'||b.name AS Recitient,mp.confirmation,"
|
|
. "CASE WHEN m.status=1 THEN 'Pending' WHEN m.status=3 THEN 'Cancelled' WHEN m.status=5 THEN 'Completed' ELSE '' END AS Status "
|
|
. "FROM money_transfer m "
|
|
. "LEFT JOIN sendmoney_recipient r ON r.id = m.recipientid "
|
|
. " LEFT JOIN members mm ON mm.id = m.member_id "
|
|
. "LEFT JOIN bank_entity_codes b ON b.code = r.bank_code "
|
|
. "LEFT JOIN members_payments mp ON mp.what_sendmoney = m.id "
|
|
. "WHERE mp.confirmation IS NOT NULL ORDER BY m.id DESC LIMIT 4000";
|
|
|
|
// $query = $this->db->query($mysql);
|
|
// $this->table->set_heading('Date', 'Amount', 'Fee', 'Recipient', 'Confirmation', 'Status')
|
|
//$this->table->set_heading('Date', 'Amount','Fee','Recipient','Confirmation', 'Status');
|
|
|
|
$data['mysql'] = $mysql;
|
|
$this->renderbkoreportpage($data);
|
|
}
|
|
|
|
public function pendpay() {
|
|
$data["title"] = "Pending withdraws Report";
|
|
$mysql = "SELECT * FROM members";
|
|
$data['mysql'] = $mysql;
|
|
$this->renderbkoreportpage($data);
|
|
}
|
|
|
|
public function payments() {
|
|
$data["title"] = "Payment Report";
|
|
$mysql = "SELECT * FROM members_payments";
|
|
$data['mysql'] = $mysql;
|
|
$this->renderbkoreportpage($data);
|
|
}
|
|
|
|
public function signup() {
|
|
$data["title"] = "Signup Report";
|
|
$mysql = "SElECT added::date,username,firstname||' '||lastname AS Name,loc,last_login::date FROM members ORDER BY id DESC LIMIT 7000";
|
|
$data['mysql'] = $mysql;
|
|
$this->renderbkoreportpage($data);
|
|
}
|
|
|
|
public function pendsignup() {
|
|
$data["page_title"] = "Pending Signup Report";
|
|
|
|
$mysql = "SELECT '<b>ADDED:</b>'||added::date||'<br><b>EXPIRE:</b>'||expire::date As Dates,'<b>Username:</b>'||username||'<br> <b>Name:</b>'||firstname||' '||lastname AS Name,"
|
|
. " (CASE WHEN status=1 THEN '<div id=\"btu'||id||'\"><button id=\"acc'||id||'\" class=\"btn btn-info btn-xs\" onclick=\"return resendLink('''||id||''');\" >Resend</button></div>' ELSE ' ' END) AS action ,"
|
|
. " (CASE WHEN status=1 THEN '<div id=\"btu'||id||'\"><button id=\"acc'||id||'\" class=\"btn btn-warning btn-xs\" onclick=\"return resendLink('''||id||''');\" >Del</button></div>' ELSE ' ' END) AS Del "
|
|
. " FROM members_pending WHERE expire> now() AND status = 1"
|
|
. " ORDER BY id desc limit 5000";
|
|
|
|
|
|
// $data['mysql'] = $mysql;
|
|
|
|
|
|
|
|
//$this->renderbkoreportpage($data);
|
|
|
|
//
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
$this->table->set_heading(array('data' => 'Date', 'style' => 'width:180px'), 'Email/Name', array('data' => 'RES', 'style' => 'width:40px; cellpadding:0px;'), array('data' => 'Del', 'style' => 'width:40px; cellpadding:0px;'));
|
|
//$mysql = $ydata['mysql'];
|
|
$query = $this->db->query($mysql);
|
|
$data['pendingsignup_table'] = $this->table->generate($query);
|
|
|
|
|
|
$this->load->view('bko/view_bko_header', $data);
|
|
$this->load->view('bko/view_bko_pendingsignup', $data);
|
|
$this->load->view('bko/view_bko_footer', $data);
|
|
}
|
|
|
|
private function renderbkoreportpage($ydata) {
|
|
$data = array();
|
|
$data["page_title"] = $ydata["title"];
|
|
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
$mysql = "SELECT * FROM money_transfer LIMIT 100";
|
|
|
|
$sdate = '2016-01-01';
|
|
$edate = '2018-01-01';
|
|
|
|
|
|
$mysql = $ydata['mysql'];
|
|
$query = $this->db->query($mysql);
|
|
$data['sendmoney_dash_table'] = $this->table->generate($query);
|
|
|
|
|
|
$this->load->view('bko/view_bko_header', $data);
|
|
$this->load->view('bko/view_bko_report_generic', $data);
|
|
$this->load->view('bko/view_bko_footer', $data);
|
|
}
|
|
|
|
}
|