home/autoph/public_html/projects/Rating-AutoHub/app/Models/User.php 0000644 00000004531 15025015637 0021361 0 ustar 00
*/
protected $fillable = [
'asa_id',
'f_name',
'l_name',
'email',
'password',
'comp_id',
'type'
];
/**
* The attributes that should be hidden for serialization.
*
* @var array
*/
protected $hidden = [
'password',
'remember_token',
];
/**
* The attributes that should be cast.
*
* @var array
*/
protected $casts = [
'email_verified_at' => 'datetime',
];
public function getUsersQuery(){
$id = Auth::user()->id;
return "SELECT %s
FROM `users`
WHERE 1
AND `id` != $id
%s
%s
%s
%s
";
}
public function getUsers($array_data){
$fields = " `users`.`id`, `users`.`f_name`, `users`.`l_name` ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
$array_data['search'],
$array_data['where'],
$array_data['sort'],
$array_data['offset_limit']
);
return DB::select($query);
}
public function getUsersCount($array_data){
$fields = " COUNT(1) as Count ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
'',
$array_data['where'],
'',
''
);
return DB::select($query);
}
public function getUsersFilteredCount($array_data){
$fields = " COUNT(1) as FilteredCount ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
$array_data['search'],
$array_data['where'],
'',
''
);
return DB::select($query);
}
}
home/autoph/public_html/projects/golf/app/Models/User.php 0000644 00000101141 15031453111 0017500 0 ustar 00 runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getPlayer($array_data)
{
$query = "SELECT p.*,
t.name as team_name,
c.name as course_name,
d.name as division_name,
d.name as division_name,
e.name as event_name,
CONCAT(u.firstname,' ',u.lastname) as partner_name,
CONCAT(un.firstname,' ',un.lastname) as player_name
FROM golf_players p
LEFT OUTER JOIN golf_courses c
ON p.course_id = c.id
LEFT OUTER JOIN golf_teams t
ON p.team_id = t.id
LEFT OUTER JOIN golf_divisions d
ON p.division_id = d.id
LEFT OUTER JOIN golf_users u
ON p.partner_id = u.id
LEFT OUTER JOIN golf_users un
ON p.user_id = un.id
LEFT OUTER JOIN golf_events e
ON p.event_id = e.id
WHERE 1
AND p.event_id = ?
AND p.user_id = ?
AND p.status = 1
";
$paramType = "ii";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getPlayerData($array_data)
{
$query = "SELECT p.*,
t.name as team_name,
c.name as course_name,
d.name as division_name,
d.name as division_name,
e.name as event_name,
CONCAT(u.firstname,' ',u.lastname) as partner_name,
CONCAT(un.firstname,' ',un.lastname) as player_name
FROM golf_players p
LEFT OUTER JOIN golf_courses c
ON p.course_id = c.id
LEFT OUTER JOIN golf_teams t
ON p.team_id = t.id
LEFT OUTER JOIN golf_divisions d
ON p.division_id = d.id
LEFT OUTER JOIN golf_users u
ON p.partner_id = u.id
LEFT OUTER JOIN golf_users un
ON p.user_id = un.id
LEFT OUTER JOIN golf_events e
ON p.event_id = e.id
WHERE 1
AND p.id = ?
AND p.status = 1
";
$paramType = "i";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getUsers()
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND status = 1 AND active = 1 ";
return Database::connect()->runBaseQuery($query);
}
public function getPlayers()
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND status = 1 AND active = 1 AND is_admin IS NULL ";
return Database::connect()->runBaseQuery($query);
}
public function getPlayersGroupByMobile()
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND status = 1 AND active = 1 AND is_admin IS NULL GROUP BY mobile";
return Database::connect()->runBaseQuery($query);
}
public function getEventPlayersGroupByMobileQuery()
{
return "SELECT u.* FROM `golf_users` u
LEFT OUTER JOIN golf_players p
ON u.id = p.user_id
/*LEFT OUTER JOIN golf_player_attendance pa
ON p.id = pa.player_id*/
WHERE 1
AND u.status = 1
AND u.active = 1
AND p.status = 1
AND u.is_admin IS NULL
%s ";
}
public function getEventPlayersGroupByMobile($array_data)
{
$query = sprintf($this->getEventPlayersGroupByMobileQuery(), "
AND p.registration_status = 'registered'
AND p.event_id = ?
");
$paramType = "i";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function getEventPlayersGroupByMobile2($filters)
{
$query = sprintf($this->getEventPlayersGroupByMobileQuery(), $filters);
return Database::connect()->runBaseQuery($query);
}
public function getUserByEmail($array_data)
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND `email` = ?";
$paramType = "s";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getUserByUsername($array_data)
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND `username` = ?";
$paramType = "s";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getUserStatus($array_data)
{
$query = "SELECT * FROM `golf_users` WHERE 1 AND `id` = ? AND status = 1 AND active = 1";
$paramType = "i";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function createLoginToken($array_data)
{
$query = "INSERT INTO `golf_users_login_session_token`(`user_id`, `token`, `updated_at`,`status`) VALUES (?,?,NOW(),1) ON DUPLICATE KEY UPDATE
token = VALUES (token),
updated_at = VALUES(updated_at),
status = VALUES(status)
";
$paramType = "is";
$insertId = Database::connect()->insert($query, $paramType, $array_data);
return $insertId;
}
public function createLastLoginDate($array_data)
{
$query = "UPDATE golf_users SET last_login = NOW() WHERE id = ?";
$paramType = "i";
Database::connect()->update($query, $paramType, $array_data);
}
public function getUserIdBySessionToken($array_data)
{
$query = "SELECT user_id FROM golf_users_login_session_token WHERE token = ? AND status = 1";
$paramType = "s";
return Database::connect()->select($query, $paramType, $array_data);
}
public function createUser($array_data)
{
$query = "
INSERT INTO `golf_users`
(
`firstname`,
`middlename`,
`lastname`,
`suffix`,
`mobile`,
`email`,
`other_mobile`,
`other_email`,
`phone`,
`username`,
`password`,
`is_admin`,
`created_at`,
`updated_at`,
`last_login`,
`company_id`,
`position_id`,
`unhs_id`,
`club_id`,
`handicap`,
`active`,
`status`)
VALUES
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ON DUPLICATE KEY UPDATE
firstname = VALUES (firstname),
lastname = VALUES(lastname),
suffix = VALUES(suffix),
email = VALUES(email),
company_id = VALUES(company_id),
position_id = VALUES(position_id),
unhs_id = VALUES(unhs_id),
club_id = VALUES(club_id),
handicap = VALUES(handicap),
other_email = VALUES(other_email),
other_mobile = VALUES(other_mobile),
phone = VALUES(phone),
updated_at = NOW()
";
$paramType = "sssssssssssisssiisisii";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function updateUser($array_data)
{
$query = "
UPDATE `golf_users`
SET
`firstname` = ? ,
`middlename` = ? ,
`lastname` = ? ,
`suffix` = ? ,
`mobile` = ? ,
`email` = ? ,
`other_mobile` = ? ,
`other_email` = ? ,
`phone` = ? ,
`username` = ? ,
`password` = ? ,
`is_admin` = ? ,
`created_at` = ? ,
`updated_at` = ? ,
`last_login` = ? ,
`company_id` = ? ,
`position_id` = ? ,
`unhs_id` = ? ,
`club_id` = ? ,
`handicap` = ? ,
`active` = ? ,
`status` =?
WHERE
id = ?
";
$paramType = "sssssssssssisssiisisiii";
return Database::connect()->update($query, $paramType, $array_data);
}
public function getCompany($array_data)
{
$query = "SELECT * FROM `golf_companies` WHERE 1 AND `name` = ?";
$paramType = "s";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function createCompany($array_data)
{
$query = "INSERT INTO `golf_companies`
(
`name`,
`status`)
VALUES
(
?,
1);
";
$paramType = "s";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getPosition($array_data)
{
$query = "SELECT * FROM `golf_positions` WHERE 1 AND `name` = ?";
$paramType = "s";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function createPosition($array_data)
{
$query = "INSERT INTO `golf_positions`
(
`name`,
`status`)
VALUES
(
?,
1);
";
$paramType = "s";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getClub($array_data)
{
$query = "SELECT * FROM `golf_clubs` WHERE 1 AND `name` = ?";
$paramType = "s";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function getTeam($array_data)
{
$query = "SELECT * FROM `golf_teams` WHERE 1 AND event_id = ? AND `name` = ? ";
$paramType = "is";
$response = Database::connect()->runQuery($query, $paramType, $array_data);
return count($response) > 0 ? $response[0] : $response;
}
public function createClub($array_data)
{
$query = "INSERT INTO `golf_clubs`
(
`name`,
`status`)
VALUES
(
?,
1);
";
$paramType = "s";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getUserQuery()
{
return "SELECT %s FROM `golf_users` u
WHERE 1
AND u.status = 1
AND u.active = 1
AND u.is_admin IS NULL
%s /*filters*/
%s /*order*/
%s /*limit*/
";
}
public function getUsersList($array_data)
{
$fields = " u.*,CONCAT(u.firstname,' ',u.lastname) as name ";
$query = sprintf($this->getUserQuery(), $fields, $array_data['filters'], $array_data['sort'], $array_data['offset_limit']);
$paramType = "s";
$paramValue = array(
$array_data['search_keyword'],
);
return Database::connect()->runQuery($query, $paramType, $paramValue);
}
public function getUsersListCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getUserQuery(),
$fields,
'AND ?',
'',
''
);
$paramType = "s";
$paramValue = array("1");
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getUsersListFilteredCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getUserQuery(),
$fields,
$array_data['filters'],
'',
''
);
$paramType = "s";
$paramValue = array(
$array_data['search_keyword'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getDashboard($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getEventUserQuery(),
$fields,
$array_data['filters'],
$array_data['where'],
'',
''
);
$paramType = "i";
$paramValue = array(
$array_data['id'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getEventUserQuery()
{
return "SELECT %s FROM `golf_users` u
LEFT OUTER JOIN golf_players p
ON u.id = p.user_id
LEFT OUTER JOIN golf_player_attendance pa
ON p.id = pa.player_id
WHERE 1
AND u.status = 1
AND u.active = 1
AND p.status = 1
AND u.is_admin IS NULL
AND p.event_id = ?
%s /*filters*/
%s /*where*/
%s /*order*/
%s /*limit*/
";
}
public function getEventUsersList($array_data)
{
$fields = " u.*,pa.created_at as attendance,
CONCAT(u.firstname,' ',u.lastname) as name,
p.id as player_id,p.registration_status,p.event_id,p.registration_type,p.registration_date,p.created_at as p_created_at ";
$query = sprintf($this->getEventUserQuery(), $fields, $array_data['filters'], $array_data['where'], $array_data['sort'], $array_data['offset_limit']);
// echo $query;
// exit;
$paramType = "is";
$paramValue = array(
$array_data['id'],
$array_data['search_keyword'],
);
return Database::connect()->runQuery($query, $paramType, $paramValue);
}
public function checkPlayerAttendance($array_data)
{
$query = "SELECT created_at as attendance FROM golf_player_attendance WHERE player_id=".$array_data;
return Database::connect()->runQueries($query);
}
public function getEventUsersListCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getEventUserQuery(),
$fields,
'AND ?',
$array_data['where'],
'',
''
);
$paramType = "is";
$paramValue = array(
$array_data['id'],
"1",
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getEventListFilteredCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getEventUserQuery(),
$fields,
$array_data['filters'],
$array_data['where'],
'',
''
);
$paramType = "is";
$paramValue = array(
$array_data['id'],
$array_data['search_keyword'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getTeamUserQuery()
{
return "SELECT %s FROM `golf_users` u
LEFT OUTER JOIN golf_players p
ON u.id = p.user_id
LEFT OUTER JOIN golf_courses c
ON p.course_id = c.id
LEFT OUTER JOIN golf_teams t
ON p.team_id = t.id
LEFT OUTER JOIN golf_divisions d
ON p.division_id = d.id
LEFT OUTER JOIN golf_player_attendance pa
ON p.id = pa.player_id
LEFT OUTER JOIN golf_users fm
ON p.partner_id = fm.id
WHERE 1
AND u.status = 1
AND u.active = 1
AND p.status = 1
AND u.is_admin IS NULL
AND p.event_id = ?
/*AND p.team_id = ?*/
%s /*all filter merge where */
%s /*filters*/
%s /*group*/
%s /*order*/
%s /*limit*/
";
}
public function getTeamUsersList($array_data)
{
$fields = " u.*,
CONCAT(u.firstname,' ',u.lastname) as name,
p.id as player_id,p.registration_status,p.event_id,p.registration_type,p.registration_date,p.created_at as p_created_at,
CONCAT(p.course,p.flight) as course_flight,
p.course as course_n,
p.flight as flight_n,
t.name as team,
c.name as course,
d.name as division,
pa.created_at as attendance,
CONCAT(fm.firstname,' ',fm.lastname) as partner
";
$query = sprintf($this->getTeamUserQuery(), $fields, $array_data['where'], $array_data['filters'], '', $array_data['sort'], $array_data['offset_limit']);
// echo $query;
// exit;
$paramType = "is";
$paramValue = array(
$array_data['event_id'],
$array_data['search_keyword'],
);
return Database::connect()->runQuery($query, $paramType, $paramValue);
}
public function getTeamUsersListSame($array_data, $field)
{
$fields = $field;
$query = sprintf($this->getTeamUserQuery(), $fields, $array_data['where'], $array_data['filters'], ' GROUP BY ' . $field, $array_data['sort'], $array_data['offset_limit']);
// echo $query;
// exit;
$paramType = "is";
$paramValue = array(
$array_data['event_id'],
$array_data['search_keyword'],
);
return Database::connect()->runQuery($query, $paramType, $paramValue);
}
public function getTeamUsersListCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getTeamUserQuery(),
$fields,
'AND ?',
'',
'',
'',
''
);
$paramType = "is";
$paramValue = array(
$array_data['event_id'],
"1",
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getTeamListFilteredCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getTeamUserQuery(),
$fields,
$array_data['filters'],
$array_data['where'],
'',
'',
''
);
$paramType = "is";
$paramValue = array(
$array_data['event_id'],
$array_data['search_keyword'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function updateUserStatus($array_data)
{
$query = "UPDATE golf_users SET status = ?,active = ? WHERE id = ?";
$paramType = "iii";
return Database::connect()->update($query, $paramType, $array_data);
}
public function updateUserEventStatus($array_data)
{
$query = "UPDATE golf_players SET status = ? WHERE id = ?";
$paramType = "ii";
return Database::connect()->update($query, $paramType, $array_data);
}
public function removeUserFromTeam($array_data)
{
$query = "UPDATE golf_players SET team_id = null WHERE id = ?";
$paramType = "i";
return Database::connect()->update($query, $paramType, $array_data);
}
public function getAdminQuery()
{
return "SELECT %s FROM golf_users u
WHERE 1
AND u.status = 1
AND u.is_admin = 1
%s /*filters*/
%s /*adminfilter*/
%s /*order*/
%s /*limit*/
";
}
public function getAdmins($array_data)
{
$fields = " u.*,CONCAT(u.firstname,' ',u.lastname) as name";
$query = sprintf($this->getAdminQuery(), $fields, $array_data['filters'], $array_data['admin_filter'], $array_data['sort'], $array_data['offset_limit']);
$paramType = "si";
$paramValue = array(
$array_data['search_keyword'],
$array_data['admin_id'],
);
return Database::connect()->runQuery($query, $paramType, $paramValue);
}
public function getAdminsCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getAdminQuery(),
$fields,
'AND ?',
$array_data['admin_filter'],
'',
''
);
$paramType = "si";
$paramValue = array(
"1",
$array_data['admin_id'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getAdminsFilteredCount($array_data)
{
$fields = " COUNT(1) ";
$query = sprintf(
$this->getAdminQuery(),
$fields,
$array_data['filters'],
$array_data['admin_filter'],
'',
''
);
$paramType = "si";
$paramValue = array(
$array_data['search_keyword'],
$array_data['admin_id'],
);
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getDivision()
{
$query = "SELECT * FROM `golf_divisions` WHERE 1 AND status = 1";
return Database::connect()->runBaseQuery($query);
}
public function getCourse()
{
$query = "SELECT * FROM `golf_courses` WHERE 1 AND status = 1";
return Database::connect()->runBaseQuery($query);
}
public function getCourseIdByName($paramValue)
{
$query = "SELECT id FROM `golf_courses` WHERE 1 AND name = ? AND status = 1";
$paramType = "s";
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getMate($paramValue)
{
$query = "SELECT p.partner_id FROM golf_players p
WHERE 1
AND p.event_id = ?
AND p.user_id = ?
AND p.status = 1";
$paramType = "ii";
return Database::connect()->select($query, $paramType, $paramValue);
}
public function getMateData($paramValue)
{
$query = "SELECT * FROM
SELECT * FROM golf_players p
WHERE 1
AND p.event_id = ?
AND p.user_id = ?
AND p.status = 1";
$paramType = "ii";
return Database::connect()->select($query, $paramType, $paramValue);
}
public function createTeam($array_data)
{
$query = "INSERT INTO `golf_teams` (`event_id`,`name`,`created_at`,`status`) VALUES (?,?,?,?) ON DUPLICATE KEY UPDATE created_at = NOW()";
$paramType = "issi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function createPlayer($array_data)
{
$query = "INSERT INTO `golf_players`
(
`event_id`,
`course_id`,
`team_id`,
`division_id`,
`user_id`,
`course`,
`flight`,
`partner_id`,
`registration_status`,
`registration_type`,
`registration_date`,
`created_at`,
`status`)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)
ON DUPLICATE KEY UPDATE
course_id = VALUES (course_id),
team_id = VALUES(team_id),
division_id = VALUES(division_id),
course = VALUES(course),
flight = VALUES(flight),
partner_id = VALUES(partner_id),
registration_status = VALUES(registration_status),
registration_type = VALUES(registration_type),
registration_date = VALUES(registration_date),
partner_id = VALUES(partner_id),
status = VALUES(status),
updated_at = NOW()
";
$paramType = "iiiiississssi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getUserOptions($array_data)
{
$query = "SELECT u.id,CONCAT(u.firstname,' ',u.lastname) as text FROM golf_users u
WHERE 1
AND CONCAT(u.lastname,', ',u.firstname,' ',u.lastname,' ',u.firstname) LIKE ?
AND u.status = 1
AND u.active = 1
AND u.is_admin IS NULL
AND u.id NOT IN (?)
ORDER BY `text` ASC
LIMIT ?";
$paramType = "sii";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function getUserMateOptions($array_data)
{
$query = "SELECT u.id,CONCAT(u.firstname,' ',u.lastname) as text FROM golf_users u
INNER JOIN golf_players p
ON u.id = p.user_id
WHERE 1
AND CONCAT(u.lastname,', ',u.firstname,' ',u.lastname,' ',u.firstname) LIKE ?
AND u.status = 1
AND u.active = 1
AND u.is_admin IS NULL
AND u.id NOT IN (?)
AND p.event_id = ?
AND p.course = ?
AND p.flight = ?
AND p.course_id = ?
AND p.status = 1
ORDER BY `text` ASC
LIMIT ?";
$paramType = "siissii";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function getUserEventTeamOptions($array_data)
{
$query = "SELECT u.id,CONCAT(u.firstname,' ',u.lastname) as text FROM golf_users u
LEFT OUTER JOIN golf_players p
ON u.id = p.user_id
WHERE 1
AND CONCAT(u.lastname,', ',u.firstname,' ',u.lastname,' ',u.firstname) LIKE ?
AND u.status = 1
AND u.active = 1
AND u.is_admin IS NULL
AND (SELECT COUNT(1) FROM (
(SELECT id FROM golf_players WHERE status = 1 AND team_id = ? AND user_id = p.user_id GROUP BY user_id)
) t1) = 0
/*AND ((p.team_id NOT IN (?) OR p.team_id IS NULL) OR (p.event_id NOT IN (?) OR p.event_id IS NULL))*/
GROUP BY u.id
ORDER BY `text` ASC
LIMIT ?";
// echo $query;
// exit;
$paramType = "sii";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function getTeamOptions($array_data)
{
$query = "SELECT t.id,t.name as text FROM golf_teams t
WHERE 1
AND name LIKE ?
AND t.event_id = ?
AND t.status = 1
ORDER BY `text` ASC
LIMIT ?";
$paramType = "sii";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function getTeamFilterOptions($array_data)
{
$query = "SELECT t.id,t.name as text FROM golf_teams t
WHERE 1
AND (SELECT COUNT(1) FROM `golf_users` u
LEFT OUTER JOIN golf_players p
ON u.id = p.user_id
LEFT OUTER JOIN golf_teams tsub
ON p.team_id = tsub.id
WHERE 1
AND u.status = 1
AND u.active = 1
AND p.status = 1
AND p.course IS NOT NULL
AND p.flight IS NOT NULL
AND p.course_id IS NOT NULL
AND tsub.id = t.id
AND u.is_admin IS NULL
AND p.event_id = t.event_id) > 0
AND name LIKE ?
AND t.event_id = ?
AND t.status = 1
ORDER BY `text` ASC
LIMIT ?";
$paramType = "sii";
return Database::connect()->runQuery($query, $paramType, $array_data);
}
public function createReward($array_data)
{
$query = "INSERT INTO `golf_rewards`
(
`event_id`,
`user_id`,
`player_id`,
`created_at`,
`status`)
VALUES
(?,?,?,?,?)
";
$paramType = "iiisi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function createRewardQR($array_data)
{
$query = "INSERT INTO `golf_rewards`
(
`event_id`,
`player_id`,
`created_at`,
`status`)
VALUES
(?,?,?,?)
";
$paramType = "iisi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getRewardCount($array_data)
{
$query = "SELECT COUNT(1) FROM golf_rewards WHERE 1 AND `event_id` = ? AND player_id = ? AND status = 1";
$paramType = "ii";
return Database::connect()->select($query, $paramType, $array_data);
}
public function getMulliganCount($array_data)
{
$query = "SELECT mulligan FROM golf_mulligans WHERE 1 AND `event_id` = ? AND player_id = ? AND status = 1 ";
$paramType = "ii";
return Database::connect()->select($query, $paramType, $array_data);
}
public function updateMulligan($array_data)
{
$query = "INSERT INTO `golf_mulligans`
(
`event_id`,
`mulligan`,
`user_id`,
`player_id`,
`updated_at`,
`status`)
VALUES
(?,?,?,?,?,?) ON DUPLICATE KEY UPDATE
mulligan = VALUES (mulligan),
updated_at = VALUES(updated_at),
user_id = VALUES(user_id)
";
$paramType = "iiiisi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function updateMulliganQR($array_data)
{
$query = "INSERT INTO `golf_mulligans`
(
`event_id`,
`mulligan`,
`player_id`,
`updated_at`,
`status`)
VALUES
(?,?,?,?,?) ON DUPLICATE KEY UPDATE
mulligan = VALUES (mulligan),
updated_at = VALUES(updated_at)
";
$paramType = "iiisi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function getDeviceIds()
{
$query = "SELECT * FROM `golf_devices` WHERE 1 AND status = 1";
return Database::connect()->runBaseQuery($query);
}
public function getPlayerAttendance($array_data)
{
$query = "SELECT COUNT(1) FROM golf_player_attendance WHERE 1 AND `player_id` = ? AND status = 1 ";
$paramType = "i";
return Database::connect()->select($query, $paramType, $array_data);
}
public function setPlayerAttendance($array_data)
{
$query = "INSERT INTO `golf_player_attendance`
(
`player_id`,
`created_at`,
`status`)
VALUES (?,?,?)";
$paramType = "isi";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function removePlayerAttendance($array_data)
{
$query = "DELETE FROM `golf_player_attendance` WHERE player_id = ?";
$paramType = "i";
return Database::connect()->insert($query, $paramType, $array_data);
}
public function inserBootClaimed($array_data)
{
$query = "INSERT IGNORE INTO `event_booth_player`
(
`event_id`,
`player_id`,
`booth_id`,
`created_at`,
`is_claim`)
VALUES (?,?,?,NOW(),1)";
$paramType = "iii";
Database::transBegin();
$res = (Database::connect()->insert($query, $paramType, $array_data) > 0 ? true : false);
($res ? Database::transCommit() : Database::transRollback());
return $res;
}
public function updateBootClaim($array_data)
{
// $query = "UPDATE `event_booth_player` SET active =0 WHERE event_id =".$array_data[0]." AND player_id=".$array_data[1]." AND booth_id=".$array_data[2]." AND active =1";
// return Database::connect()->runQueries($query);
// Database::transBegin();
// $res = (Database::connect()->runQueries($query) ? true :false);
// ($res ? Database::transCommit() : Database::transRollback());
// return $res;
$query = "UPDATE `event_booth_player` SET active =0 WHERE event_id =? AND player_id=? AND booth_id=? AND active =1";
$paramType = "iii";
Database::transBegin();
$res = (Database::connect()->update($query, $paramType, $array_data) ==1 ? true : false);
($res ? Database::transCommit() : Database::transRollback());
return $res;
}
public function createDevice($array_data)
{
$query = "INSERT IGNORE INTO `golf_devices`
(
`device_id`,
`description`,
`created_at`)
VALUES (?,?,NOW())";
$paramType = "ss";
return Database::connect()->insert($query, $paramType, $array_data);
}
}