dev-chiefworks
69 lines
2.1 KiB
PHP
69 lines
2.1 KiB
PHP
<?php if (!defined('BASEPATH')) {
|
|
exit('No direct script access allowed');
|
|
}
|
|
|
|
class Test_accounts_model extends CI_Model
|
|
{
|
|
public function __constructor()
|
|
{
|
|
parrent::__constructor();
|
|
}
|
|
|
|
public function getAccountQuery($params = [])
|
|
{
|
|
$whereQuery = ' WHERE 1 = 1 ';
|
|
|
|
if (!empty($params['mid'])) {
|
|
$whereQuery .= " AND t.member_id = " . pg_escape_string(trim($params['mid'])) . " ";
|
|
}
|
|
|
|
if (!empty($params['firstname'])) {
|
|
$whereQuery .= " AND m.firstname ILIKE '%" . pg_escape_string(trim($params['firstname'])) . "%' ";
|
|
}
|
|
|
|
if (!empty($params['lastname'])) {
|
|
$whereQuery .= " AND m.lastname ILIKE '%" . pg_escape_string(trim($params['lastname'])) . "%' ";
|
|
}
|
|
|
|
if (!empty($params['username'])) {
|
|
$whereQuery .= " AND m.email ILIKE '%" . pg_escape_string(trim($params['username'])) . "%' ";
|
|
}
|
|
|
|
if (!empty($params['group'])) {
|
|
$whereQuery .= " AND m.decision_group ILIKE '%" . pg_escape_string(trim($params['group'])) . "%' ";
|
|
}
|
|
|
|
if (isset($params['status']) && $params['status'] != -1) {
|
|
$whereQuery .= " AND t.status = " . pg_escape_string($params['status']) . " ";
|
|
}
|
|
|
|
|
|
|
|
$query = "
|
|
SELECT
|
|
t.member_id,
|
|
m.firstname,
|
|
m.lastname,
|
|
m.email,
|
|
m.decision_group,
|
|
"
|
|
. " '<div id=\"stat_' || t.id || '\">' || (
|
|
CASE WHEN t.status = 1 THEN
|
|
'Active'
|
|
ELSE
|
|
'Disabled'
|
|
END) || '</div>' AS status,
|
|
"
|
|
. " '<button type=\"button\" class=\"btn btn-warning\" onclick=\"removeTest(' || t.id || ');\">Disable</button>' AS action
|
|
FROM
|
|
test_accounts t
|
|
LEFT JOIN members m ON m.id = t.member_id
|
|
" . $whereQuery . "
|
|
ORDER BY
|
|
t.id
|
|
";
|
|
|
|
return $query;
|
|
}
|
|
}
|