/extremedating/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/extremedating/trunk

« back to all changes in this revision

Viewing changes to php/showlunchsuggestions.php

  • Committer: Gustav Hatvigsson
  • Date: 2013-04-14 10:57:07 UTC
  • Revision ID: gustav.hartvigsson@gmail.com-20130414105707-em0j7arcpfvhf8y9
forgot the file...

Show diffs side-by-side

added added

removed removed

Lines of Context:
php/showlunchsuggestions.php
 
1
<?PHP
 
2
        $lunchSuggestionArray = $db->query("SELECT user2 from planLunch WHERE user1='$username'");
 
3
        $lunchSuggestionQuery = $lunchSuggestionArray->fetchAll();
 
4
        foreach ($lunchSuggestionQuery as $lunchSuggestion) {
 
5
                $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchSuggestion[0]'");
 
6
                $self = $userinfo->fetchAll();
 
7
                $firstName = $self [0]['firstName'];
 
8
                $userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchSuggestion[0]'");
 
9
                $self = $userinfo->fetchAll();
 
10
                $surName = $self [0]['surName'];
 
11
                
 
12
                $userinfo = $db->query("SELECT date from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
 
13
                $self = $userinfo->fetchAll();
 
14
                $datetime = $self [0]['date'];
 
15
                $userinfo = $db->query("SELECT message from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
 
16
                $self = $userinfo->fetchAll();
 
17
                $message = $self [0]['message'];
 
18
                $userinfo = $db->query("SELECT accepted from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");
 
19
                $self = $userinfo->fetchAll();
 
20
                $accepted = $self [0]['accepted'];
 
21
                if ($accepted=='true') {
 
22
      ?>
 
23
                        <div class="dinnerwraps">
 
24
                        <p>Du har bokat lunch med <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
 
25
                        <p> <?php echo $message; ?></p>
 
26
      <form method="post" action="./removedate.php">
 
27
        <input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />
 
28
        <input type="hidden" name="user2remove" id="user2remove" value="<?php echo $username; ?>" />
 
29
        <button id="remove" name="remove" value="remove">remove</button>
 
30
      </form>
 
31
                        </div>
 
32
      <?php
 
33
                } else {
 
34
      ?>
 
35
                        <div class="dinnerwraps">
 
36
                        <p>Du har föreslagit lunch med <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
 
37
                        <p> <?php echo $message; ?></p>
 
38
      <form method="post" action="./removedate.php">
 
39
        <input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />
 
40
        <input type="hidden" name="user2remove" id="user2remove" value="<?php echo $username; ?>" />
 
41
        <button id="remove" name="remove" value="remove">remove</button>
 
42
      </form>
 
43
                        </div>
 
44
      <?php
 
45
                }
 
46
        }
 
47
        $lunchAcceptionArray = $db->query("SELECT user1 from planLunch WHERE user2='$username'");
 
48
        $lunchAcceptionQuery = $lunchAcceptionArray->fetchAll();
 
49
        foreach ($lunchAcceptionQuery as $lunchAcception) {
 
50
                $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchAcception[0]'");
 
51
                $self = $userinfo->fetchAll();
 
52
                $firstName = $self [0]['firstName'];
 
53
                $userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchAcception[0]'");
 
54
                $self = $userinfo->fetchAll();
 
55
                $surName = $self [0]['surName'];
 
56
                
 
57
                $userinfo = $db->query("SELECT date from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
 
58
                $self = $userinfo->fetchAll();
 
59
                $datetime = $self [0]['date'];
 
60
                $userinfo = $db->query("SELECT message from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
 
61
                $self = $userinfo->fetchAll();
 
62
                $message = $self [0]['message'];
 
63
                $userinfo = $db->query("SELECT accepted from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
 
64
                $self = $userinfo->fetchAll();
 
65
                $accepted = $self [0]['accepted'];
 
66
                if ($accepted=='true') {
 
67
      ?>
 
68
                        <div class="dinnerwraps">
 
69
                        <p>Du har bokat lunch med ' <?php echo $firstName; ?>  <?php echo $surName; ?>  den <?php echo $datetime; ?> </p>
 
70
                        <p><?php echo $message; ?>  </p>
 
71
                        <form method="POST" action="">
 
72
                        <input type="hidden" name="user1_2" value="<?php echo $lunchAcception[0]; ?>"/>
 
73
                        <button type="Submit" name="AcceptLunch">Avboka</button>
 
74
                        </form>';
 
75
                        </div>';
 
76
                        <?php
 
77
                        if (isset($_POST['user1_2'])) {
 
78
                                $luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
 
79
                                $lunchinfo = $luncharray->fetchAll();
 
80
                                $lunchquery = $lunchinfo[0];
 
81
                                if($lunchquery[0] == 'true') {
 
82
                                        $db->exec("UPDATE planLunch SET accepted='false' WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
 
83
                                        header("Location:profile.php?uid=" . $_POST['user1_2']);
 
84
                                }
 
85
                        }
 
86
                        
 
87
                } else {
 
88
      ?>
 
89
                        <div class="dinnerwraps">
 
90
                        <p> <?php echo $firstName; ?> <?php echo $surName; ?> har föreslagit lunch med dig den <?php echo $datetime; ?></p>
 
91
                        <p> <?php $message ?> </p>
 
92
                        <form method="POST" action="">
 
93
                        <input type="hidden" name="user1" value="<?php echo $lunchAcception[0]; ?>"/>
 
94
      <button type="Submit" name="AcceptLunch">Acceptera</button>
 
95
                        </form>';
 
96
                        </div>';
 
97
      <?php
 
98
                        if (isset($_POST['user1'])) {
 
99
                                $luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1']}')");
 
100
                                $lunchinfo = $luncharray->fetchAll();
 
101
                                $lunchquery = $lunchinfo[0];
 
102
                                if($lunchquery[0] == 'false') {
 
103
                                        $db->exec("UPDATE planLunch SET accepted='true' WHERE(user2='$username' AND user1='{$_POST['user1']}')");
 
104
                                        header("Location:profile.php?uid=" . $_POST['user1']);
 
105
                                }
 
106
                        }
 
107
                }
 
108
        }
 
109
?>