-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy patheditar.php
More file actions
93 lines (57 loc) · 6.53 KB
/
Copy patheditar.php
File metadata and controls
93 lines (57 loc) · 6.53 KB
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
<?php
require_once 'php/structure.php';
$conn = create_connection();
$isOn = false;
$html = "Erro: Um erro ocorreu.";
if(isset($_SESSION['isOn'])) {
$isOn = $_SESSION['isOn'];
}
if($isOn){
if($_GET['id']) {
$id = $_GET['id'];
$sql = "SELECT * FROM Encomendas WHERE id = $id;";
$result = $conn->query($sql);
if ($result->num_rows === 1) {
$html = '<a href="ver.php">Voltar</a><br><br>';
$row = $result->fetch_assoc();
$nome = $row['nome_cliente'];
$data = $row['data'];
$hora = $row['hora'];
$html = $html . '<div id="encomendadiv"><form action="editar_encomenda.php" method="post" name="encomendaaddform" id="encomendaaddform">
<input type="submit" name="submit" id="submitEdit" value="Editar"><br>
<input name="eId" id="eId" type="hidden" value="'.$id.'">
Nome do cliente:<br>
<input type="text" class="finput" name="nomec" id="nomec" value="'.$nome.'"><br>
Data:<br>
<input type="date" class="finput" name="data" id="data" value="'.$data.'"><br>
Hora:<br>
<input type="time" class="finput" name="hora" id="hora" value="'.$hora.'"><br>
Bolos:<br>';
$sqlInd = "SELECT bolo,quantidade,comentario FROM `Bolos` WHERE id_enc = $id";
$resultInd = $conn->query($sqlInd);
if ($resultInd->num_rows > 0) {
while ($rowInd = $resultInd->fetch_assoc()) {
$bolo = $rowInd['bolo'];
$quantInd = $rowInd['quantidade'];
$com = $rowInd['comentario'];
//$html = $html . "<br> - $bolo: $quantInd ($com)";
$html = $html . '<select name="cNum[]"><option value="'.$quantInd.'">'.$quantInd.'</option><option value="0">0</option><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option><option value="21">21</option><option value="22">22</option><option value="23">23</option><option value="24">24</option><option value="25">25</option><option value="26">26</option><option value="27">27</option><option value="28">28</option><option value="29">29</option><option value="30">30</option><option value="31">31</option><option value="32">32</option><option value="33">33</option><option value="34">34</option><option value="35">35</option><option value="36">36</option><option value="37">37</option><option value="38">38</option><option value="39">39</option><option value="40">40</option><option value="41">41</option><option value="42">42</option><option value="43">43</option><option value="44">44</option><option value="45">45</option><option value="46">46</option><option value="47">47</option><option value="48">48</option><option value="49">49</option><option value="50">50</option><option value="51">51</option><option value="52">52</option><option value="53">53</option><option value="54">54</option><option value="55">55</option><option value="56">56</option><option value="57">57</option><option value="58">58</option><option value="59">59</option><option value="60">60</option><option value="61">61</option><option value="62">62</option><option value="63">63</option><option value="64">64</option><option value="65">65</option><option value="66">66</option><option value="67">67</option><option value="68">68</option><option value="69">69</option><option value="70">70</option><option value="71">71</option><option value="72">72</option><option value="73">73</option><option value="74">74</option><option value="75">75</option><option value="76">76</option><option value="77">77</option><option value="78">78</option><option value="79">79</option><option value="80">80</option><option value="81">81</option><option value="82">82</option><option value="83">83</option><option value="84">84</option><option value="85">85</option><option value="86">86</option><option value="87">87</option><option value="88">88</option><option value="89">89</option><option value="90">90</option><option value="91">91</option><option value="92">92</option><option value="93">93</option><option value="94">94</option><option value="95">95</option><option value="96">96</option><option value="97">97</option><option value="98">98</option><option value="99">99</option><option value="100">100</option><option value="101">101</option><option value="102">102</option><option value="103">103</option><option value="104">104</option><option value="105">105</option><option value="106">106</option><option value="107">107</option><option value="108">108</option><option value="109">109</option><option value="110">110</option><option value="111">111</option><option value="112">112</option><option value="113">113</option><option value="114">114</option><option value="115">115</option><option value="116">116</option><option value="117">117</option><option value="118">118</option><option value="119">119</option><option value="120">120</option></select>';
$html = $html . '<select name="cBolo[]"><option value="'.$bolo.'">'.$bolo.'</option><option value="Doce Fino">Doce Fino</option><option value="Queijinhos">Queijinhos</option><option value="Animais">Animais</option><option value="D. Rodrigo">D. Rodrigo</option><option value="Morgadinho">Morgadinho</option><option value="Papo-seco">Papo-seco</option><option value="Almendrado">Almendrado</option><option value="KG Doce Fino">KG Doce Fino</option><option value="KG Morgado">KG Morgado</option><option value="KG Torta Doce Fino">KG Torta Doce Fino</option><option value="KG Massa">KG Massa</option><option value="KG Fios de Ovos">KG Fios de Ovos</option></select>';
$html = $html . '<br><input class="cBolo" name="cCom[]" type="text" value="'.$com.'"><br>';
}
}
$html = $html . '<input type="hidden" id="end" name="end">
</form><button id="add">+</button><br><br><br><br><a href="sair.php">Terminar sessão</a></div>';
}else{
$html = "Encomenda não encontrada";
}
}else{
$html = "Erro: Esta encomenda não existe.";
}
}else{
$html = "Erro: Acesso negado";
}
$conn->close();
create_header();
create_content($html);
create_footer();