Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define('CLAIMS', true);
- require_once 'includes/inc.core.php';
- $data = array('success' => false);
- if($_GET['action'] == 'scores')
- {
- $query = 'SELECT
- Hole1,
- Hole2,
- Hole3,
- Hole4,
- Hole5,
- Hole6,
- Hole7,
- Hole8,
- Hole9,
- Putts1,
- Putts2,
- Putts3,
- Putts4,
- Putts5,
- Putts6,
- Putts7,
- Putts8,
- Putts9,
- TotalPutts,
- Gross,
- AttendanceOnly
- FROM
- tblScores
- WHERE
- PlayerID = :player_id AND
- GroupValue = :group_id AND
- SeasonYear = :year AND
- PlayDate = :date
- LIMIT 1';
- $stmt = $database->prepare($query);
- $stmt->execute(array(
- ':player_id' => $_GET['player_id'],
- ':group_id' => $_GET['group_id'],
- ':year' => $_GET['year'],
- ':date' => $_GET['date']
- ));
- $data['success'] = true;
- $scores = $stmt->fetch(PDO::FETCH_ASSOC);
- array_walk($scores, function(&$data) {
- if($data == null)
- $data = 0;
- });
- $data += $scores;
- }
- else if($_GET['action'] == 'list_members')
- {
- $query = 'SELECT
- CONCAT(l.field_user_last_value, ", ", f.field_user_first_value) AS name,
- u.uid AS id,
- s.GroupValue AS group_id
- FROM
- dr_users AS u
- JOIN
- (dr_users_roles AS ur
- JOIN
- dr_role AS r
- ON
- ur.rid = r.rid AND
- r.name = "player"
- )
- ON
- ur.uid = u.uid
- JOIN
- dr_field_data_field_user_first AS f
- ON
- f.entity_id = u.uid AND
- f.entity_type = "user"
- JOIN
- dr_field_data_field_user_last AS l
- ON
- l.entity_id = u.uid AND
- l.entity_type = "user"
- LEFT OUTER JOIN
- tblScores AS s
- ON
- s.PlayerID = u.uid AND
- s.SeasonYear = "' . $_SESSION['event']['year'] . '" AND
- s.PlayDate = "' . $_SESSION['event']['date'] . '"';
- $stmt = $database->query($query);
- $players = $stmt->fetchAll(PDO::FETCH_ASSOC);
- $data['aaData'] = array();
- $data['success'] = true;
- foreach($players as $player)
- {
- $data['aaData'][] = array(
- $player['id'],
- $player['name'],
- $player['group_id'],
- '<span class="addPlayer"><a href="#" onclick="addToGroup(this); return false">Add to Group</a></span><span class="removePlayer"><a href="#" onclick="removeFromGroup(this); return false">Remove from Group</a></span>'
- );
- }
- }
- header('Content-type: application/json');
- echo json_encode($data);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement