· 10 years ago · Sep 09, 2016, 07:40 AM
1<form id="wishboneAddForm" class="form-inline" style="">
2 <h2>Dodaj nowÄ… tulejÄ™</h2>
3 <div class="pure-g-r">
4 <div class="pure-u-1-4">
5 <div class="form-group" style="display: block; margin-bottom: 10px;">
6 <label for="exampleInputEmail1" style="display: block;">Numer tulei</label>
7 <input type="text" name="reference" class="form-control">
8 </div>
9 <button type="submit" class="btn" id="saveWishboneAddForm">
10 <i class="fa fa-floppy-o" aria-hidden="true"></i> Zapisz tulejÄ™
11 </button>
12 </div>
13 <div class="wishbones-dimensions pure-u-3-4" style="padding-left: 5%;">
14 <label style="display: block;">Wymiary tulei</label>
15 <div class="row">
16 <div class="form-group">
17 <div class="input-group">
18 <div class="input-group-addon">a</div>
19 <input type="text" name="a" class="form-control">
20 </div>
21 </div>
22 <div class="form-group">
23 <div class="input-group">
24 <div class="input-group-addon">b</div>
25 <input type="text" name="b" class="form-control">
26 </div>
27 </div>
28 <div class="form-group">
29 <div class="input-group">
30 <div class="input-group-addon">c</div>
31 <input type="text" name="c" class="form-control">
32 </div>
33 </div>
34 <div class="form-group">
35 <div class="input-group">
36 <div class="input-group-addon">d</div>
37 <input type="text" name="d" class="form-control">
38 </div>
39 </div>
40 </div>
41 <div class="row">
42 <div class="form-group">
43 <div class="input-group">
44 <div class="input-group-addon">e</div>
45 <input type="text" name="e" class="form-control">
46 </div>
47 </div>
48 <div class="form-group">
49 <div class="input-group">
50 <div class="input-group-addon">f</div>
51 <input type="text" name="f" class="form-control">
52 </div>
53 </div>
54 <div class="form-group">
55 <div class="input-group">
56 <div class="input-group-addon">f2</div>
57 <input type="text" name="f2" class="form-control">
58 </div>
59 </div>
60 <div class="form-group">
61 <div class="input-group">
62 <div class="input-group-addon">g</div>
63 <input type="text" name="g" class="form-control">
64 </div>
65 </div>
66 </div>
67 </div>
68 </div>
69</form>
70
71$('#wishboneAddForm').on('submit', function(e) {
72 $.ajax({
73 type: 'POST',
74 url: '/_add_wishbone',
75 data: $( "#wishboneAddForm" ).serialize(),
76 success: function(response) {
77
78 }
79 });
80 e.preventDefault();
81});
82
83@route('/_add_wishbone', method='POST')
84def add_wishbone(db):
85 for key, value in request.POST.items():
86 print(key, value)
87
88 sql = "INSERT INTO wishbone_dimensions (ref, a, b, c, d, e, f, f2, g) VALUES ('{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}')"
89 sql.format(request.POST.get('reference'), request.POST.get('a'), request.POST.get('b'), request.POST.get('c'), request.POST.get('d'), request.POST.get('e'), request.POST.get('f'), request.POST.get('f2'), request.POST.get('g'))
90 try:
91 db.execute(sql)
92 except:
93 return False
94
95 return
96
97CREATE TABLE IF NOT EXISTS `wishbone_dimensions` (
98 `ref` varchar(8) NOT NULL,
99 `a` float NOT NULL DEFAULT '0',
100 `b` float NOT NULL DEFAULT '0',
101 `c` float NOT NULL DEFAULT '0',
102 `d` float NOT NULL DEFAULT '0',
103 `e` float NOT NULL DEFAULT '0',
104 `f` float NOT NULL DEFAULT '0',
105 `f2` float NOT NULL DEFAULT '0',
106 `g` float NOT NULL DEFAULT '0',
107 UNIQUE KEY `ref` (`ref`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8;