e_electro/view-order.php at master · mmedbenmansour/e_electro · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
session_start();
if (!isset($_SESSION['customer']) & empty($_SESSION['customer'])) {
    header('location: login.php');
}

include  'inc/header.php';
include  'inc/nav.php';

$uid = $_SESSION['customerid'];

if (isset($_GET['id']) & !empty($_GET['id'])) {
    $oid = $_GET['id'];
} else {
    header('location: my-account.php');
}
?>

<section id="content">
    <div class="content-blog content-account">
        <div class="container">
            <div class="row">
            <?php

				$orditmresql = "SELECT p.LIBELLE,i.QUANTITE,i.PRIX,c.PRIXTOTAL FROM commande c,produit p,commandeitem i WHERE c.IDCOMMANDE=i.IDCOMMANDE AND i.PRODUIT_IDPRODUIT=p.IDPRODUIT AND c.IDCLIENT=$uid AND c.IDCOMMANDE=$oid";
				$orditmres = loadMultiple($orditmresql);
                $ordrsql="SELECT c.PRIXTOTAL,c.STATUT,c.DATECOMMANDE FROM commande c WHERE c.IDCOMMANDE=$oid";
                $ordr=loadOne($ordrsql);
				if ($orditmres!=null && $ordr!=null) {
			?>
                <div class="page_header text-center">
                    <h2>Commande #<?php echo $oid; ?></h2>
                </div>
                <div class="col-md-12">
                    <h3>Commande récentes</h3>
                    <br>
                    <table class="cart-table account-table table table-bordered">
                        <thead>
                            <tr>
                                <th>Nom du produit</th>
                                <th>Quantité</th>
                                <th>Prix</th>
                                <th>Prix Total</th>
                            </tr>
                        </thead>
                        <tbody>

                        <?php foreach ($orditmres as $orditmr) { ?>
                            <tr>
                                <td>
                                     <?php echo substr($orditmr['LIBELLE'], 0, 25); ?>
                                </td>
                                <td>
                                    <?php echo $orditmr['QUANTITE']; ?>
                                </td>
                                <td>
                                    <?php echo $orditmr['PRIX']; ?>
                                </td>
                                <td>
                                    <?php echo $orditmr['PRIX']*$orditmr['QUANTITE']; ?>
                                </td>
                            </tr>
                        <?php } ?>
                            <tr>
                                <td colspan="3">
                                    <b>Total du commande</b>
                                </td>
                                <td>
                                    <?php echo $ordr['PRIXTOTAL']; ?>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="3" >
                                    <b>Statut</b>
                                </td>
                                <td>
                                    <?php echo $ordr['STATUT']; ?>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="3">
                                    <b>date de commande</b>
                                </td>
                                <td>
                                    <?php echo $ordr['DATECOMMANDE']; ?>
                                </td>
                            </tr>
                        </tbody>
                    </table>
            <?php } else { ?>
                <div class="page_header text-center">
                    <h2>Accès limité</h2>
                </div>
                <div class="col-md-12">
                    <h3>Vous n'avez pas le droit d'accéder aux details de cette commande. svp contacter le service clientèle</h3>
                </div>
                <div class="clearfix"></div>
            <?php } ?>
                    <br>
                    <br>
                    <br>

                    <div class="ma-address">
                        <h3>Mon adresse</h3>
                        <p>cette adresse sera utilisée pour l'enregistrement.</p>

                        <div class="row">
                            <div class="col-md-6">
                                <h4>Mon adresse <a href="edit-address.php">Edit</a></h4>
                                <?php
                                $query = "SELECT c.NOM, c.PRENOM, c.TEL, a.COMPL, a.AVENUE ,a.VILLE FROM client c JOIN compladresse a  WHERE c.COMPLADRESSE_IDCOMPLADRESSE=a.IDCOMPLADRESSE AND c.IDCLIENT=".$uid;
                                $cr =loadOne($query);
                                echo "<p>".$cr['NOM'] ." ". $cr['PRENOM'] ."</p>";
                                echo "<p>".$cr['TEL'] ."</p>";
                                echo "<p>".$cr['COMPL'] ."</p>";
                                echo "<p>".$cr['AVENUE'] ."</p>";
                                echo "<p>".$cr['VILLE'] ."</p>";
                                ?>
                            </div>

                            <div class="col-md-6">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<?php include'inc/footer.php'; ?>