CHIEFSOFT\ameye
199 lines
8.4 KiB
PHP
199 lines
8.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 offers() {
|
|
$data["title"] = "Pending Offers";
|
|
//$mysql = "SElECT added::date,username,firstname||' '||lastname AS Name,loc,last_login::date FROM members ORDER BY id DESC LIMIT 7000";
|
|
$mysql = "SELECT o.id,
|
|
o.expire||'<br>'||o.offer_code AS expire_offer,
|
|
o.job_description,
|
|
mo.firstname AS client,
|
|
mw.firstname AS owner,
|
|
o.reminder_date,
|
|
o.status,
|
|
o.uid,
|
|
'<div id=\"btu'||o.uid||'\"><button id=\"acc'||o.uid||'\" class=\"btn btn-info btn-xs\" onclick=\"return resendOfferMessage('''||o.uid||''');\" >Resend</button></div>' AS Resend
|
|
FROM members_jobs_offer o
|
|
LEFT JOIN members mo ON mo.id = o.client_id
|
|
LEFT JOIN members mw ON mw.id = o.member_id
|
|
WHERE o.status=1 AND o.expire> now() AND o.public_view = 0 ORDER BY o.id DESC limit 40";
|
|
$data['mysql'] = $mysql;
|
|
$this->renderbkoreportpage($data);
|
|
}
|
|
|
|
public function jobacts() {
|
|
|
|
|
|
$this->load->library('table');
|
|
|
|
$mysql = "SELECT m.firstname,m.lastname,j.title,i.added::date
|
|
FROM members_offer_interest i
|
|
LEFT JOIN members_jobs_offer o ON o.id=i.offer_id
|
|
LEFT JOIN members_jobs j ON j.id = o.job_id
|
|
LEFT JOIN members m ON m.id=i.member_id
|
|
WHERE i.status=1 ORDER BY i.id DESC LIMIT 20";
|
|
|
|
$this->table->set_template($this->template);
|
|
$query = $this->db->query($mysql);
|
|
$data['interest_table'] = $this->table->generate($query);
|
|
|
|
$mysql2 ="SELECT m.job_id,j.title,m.expire::date
|
|
FROM members_jobs_offer m LEFT JOIN members_jobs j ON j.id =m.job_id
|
|
WHERE m.public_view = 1 AND m.expire > now()
|
|
ORDER BY m.id DESC LIMIT 20";
|
|
$this->table->set_template($this->template);
|
|
$query = $this->db->query($mysql2);
|
|
$data['jobs_table'] = $this->table->generate($query);
|
|
|
|
$mysql2 ="SELECT added::date,msg,memo FROM members_messages WHERE msg_type='JOB' ORDER BY id DESC LIMIT 20";
|
|
$this->table->set_template($this->template);
|
|
$query = $this->db->query($mysql2);
|
|
$data['jobs_message'] = $this->table->generate($query);
|
|
|
|
|
|
|
|
$this->load->view('bko/view_bko_header', $data);
|
|
$this->load->view('bko/view_bko_jobsactivities', $data);
|
|
$this->load->view('bko/view_bko_footer', $data);
|
|
}
|
|
|
|
public function recent() {
|
|
$data["title"] = "Recent Signup Report";
|
|
//$mysql = "SElECT added::date,username,firstname||' '||lastname AS Name,loc,last_login::date FROM members ORDER BY id DESC LIMIT 7000";
|
|
$mysql = "SElECT added::date,username,firstname||' '||lastname AS Name,loc,country,last_login::date FROM members WHERE account_type='FULL' ORDER BY id DESC LIMIT 50";
|
|
|
|
$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);
|
|
}
|
|
|
|
}
|