/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-13 09:17:45 UTC
  • Revision ID: gustav.hartvigsson@gmail.com-20130413091745-j6ehpt2wc708q5jt
added the general structure.

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
 
                        </div>
27
 
      <?php
28
 
                } else {
29
 
      ?>
30
 
                        <div class="dinnerwraps">
31
 
                        <p>Du har föreslagit lunch med <?php echo $firstName; ?> <?php echo $surName; ?> den <?php echo $datetime; ?> </p>
32
 
                        <p> <?php echo $message; ?></p>
33
 
                        </div>';
34
 
      <?php
35
 
                }
36
 
        }
37
 
        $lunchAcceptionArray = $db->query("SELECT user1 from planLunch WHERE user2='$username'");
38
 
        $lunchAcceptionQuery = $lunchAcceptionArray->fetchAll();
39
 
        foreach ($lunchAcceptionQuery as $lunchAcception) {
40
 
                $userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchAcception[0]'");
41
 
                $self = $userinfo->fetchAll();
42
 
                $firstName = $self [0]['firstName'];
43
 
                $userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchAcception[0]'");
44
 
                $self = $userinfo->fetchAll();
45
 
                $surName = $self [0]['surName'];
46
 
                
47
 
                $userinfo = $db->query("SELECT date from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
48
 
                $self = $userinfo->fetchAll();
49
 
                $datetime = $self [0]['date'];
50
 
                $userinfo = $db->query("SELECT message from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
51
 
                $self = $userinfo->fetchAll();
52
 
                $message = $self [0]['message'];
53
 
                $userinfo = $db->query("SELECT accepted from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");
54
 
                $self = $userinfo->fetchAll();
55
 
                $accepted = $self [0]['accepted'];
56
 
                if ($accepted=='true') {
57
 
      ?>
58
 
                        <div class="dinnerwraps">
59
 
                        <p>Du har bokat lunch med ' <?php echo $firstName; ?>  <?php echo $surName; ?>  den <?php echo $datetime; ?> </p>
60
 
                        <p><?php echo $message; ?>  </p>
61
 
                        <form method="POST" action="">
62
 
                        <input type="hidden" name="user1_2" value="<?php echo $lunchAcception[0]; ?>"/>
63
 
                        <button type="Submit" name="AcceptLunch">Avboka</button>
64
 
                        </form>';
65
 
                        </div>';
66
 
                        <?php
67
 
                        if (isset($_POST['user1_2'])) {
68
 
                                $luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
69
 
                                $lunchinfo = $luncharray->fetchAll();
70
 
                                $lunchquery = $lunchinfo[0];
71
 
                                if($lunchquery[0] == 'true') {
72
 
                                        $db->exec("UPDATE planLunch SET accepted='false' WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");
73
 
                                        header("Location:profile.php?uid=" . $_POST['user1_2']);
74
 
                                }
75
 
                        }
76
 
                        
77
 
                } else {
78
 
      ?>
79
 
                        <div class="dinnerwraps">
80
 
                        <p> <?php echo $firstName; ?> <?php echo $surName; ?> har föreslagit lunch med dig den <?php echo $datetime; ?></p>
81
 
                        <p> <?php $message ?> </p>
82
 
                        <form method="POST" action="">
83
 
                        <input type="hidden" name="user1" value="<?php echo $lunchAcception[0]; ?>"/>
84
 
      <button type="Submit" name="AcceptLunch">Acceptera</button>
85
 
                        </form>';
86
 
                        </div>';
87
 
      <?php
88
 
                        if (isset($_POST['user1'])) {
89
 
                                $luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1']}')");
90
 
                                $lunchinfo = $luncharray->fetchAll();
91
 
                                $lunchquery = $lunchinfo[0];
92
 
                                if($lunchquery[0] == 'false') {
93
 
                                        $db->exec("UPDATE planLunch SET accepted='true' WHERE(user2='$username' AND user1='{$_POST['user1']}')");
94
 
                                        header("Location:profile.php?uid=" . $_POST['user1']);
95
 
                                }
96
 
                        }
97
 
                }
98
 
        }
99
 
?>