<?php

include 'connection.php';
include 'functions.php';
if (!isset($_GET['user_id'])) {
    echo "Error in user_id";
    return;
}
$user_id = $_GET['user_id'];
$query = "select * from user where user_id in (select support_id from user_support where user_id= {$user_id})";
echo_results_as_json($query, $connection);
Ejemplo n.º 2
0
     return;
 }
 $result = $stmt->fetch();
 $mom_id = $result[0];
 $sql = "select user_name from user where user_id={$user_id}";
 $stmt = $connection->prepare($sql);
 $res = $stmt->execute();
 $count = $stmt->rowCount();
 if ($count == 0) {
     echo "Error in server";
     return;
 }
 $result = $stmt->fetch();
 $user_name = $result[0];
 $sql = "select ch.chore_name, cha.options, cha.message, cht.assigned_to, cht.chore_activity_track_id from chore ch, chore_activity cha, chore_activity_track cht WHERE ch.chore_id = cha.chore_id AND cha.chore_activity_id = cht.chore_activity_id AND cha.user_id = {$mom_id} AND cht.assigned_to in ({$user_id},0) ORDER BY cht.assigned_to ASC";
 echo_results_as_json($sql, $connection);
 //Send a notification to the mom...
 $query = "select gcm_token from situation_aware_db.user where user_id = {$mom_id}";
 $tokens = array();
 foreach ($connection->query($query) as $v) {
     $tokens[] = $v[0];
 }
 send_notification($tokens, "{$user_name} accepted a task.", "M");
 $query = "select gcm_token from situation_aware_db.user where user_id in (select support_id from user_support where user_id = {$mom_id} and support_id != {$user_id}) and gcm_token is NOT NULL";
 $tokens = array();
 foreach ($connection->query($query) as $v) {
     $tokens[] = $v[0];
 }
 send_notification($tokens, "{$user_name} accepted a task.", "H");
 //Send updated date to all the other helpers...
 /*$query = "select gcm_token,user_id from situation_aware_db.user where user_id in (select support_id from user_support where user_id = $mom_id and support_id != $user_id) and gcm_token is NOT NULL";