15 |
|
|
16 |
<%session scope="global"> |
<%session scope="global"> |
17 |
std::string userName; |
std::string userName; |
|
bool isAdmin; |
|
18 |
</%session> |
</%session> |
19 |
|
|
20 |
<%args> |
<%args> |
21 |
int id; |
int id; |
22 |
</%args> |
</%args> |
23 |
|
|
24 |
|
<{ |
25 |
|
if (userName.size() == 0) |
26 |
|
{ |
27 |
|
reply.setHeader("Location", "index"); |
28 |
|
return HTTP_MOVED_TEMPORARILY; |
29 |
|
} |
30 |
|
}> |
31 |
|
|
32 |
|
|
33 |
<&header title="Customer Administration"> |
<&header title="Customer Administration"> |
34 |
</&header> |
</&header> |
35 |
|
|
36 |
|
|
|
|
|
37 |
<{ |
<{ |
38 |
|
|
|
if (userName.size() == 0) |
|
|
{ |
|
|
reply.setHeader("Refresh", "0; url=login"); |
|
|
return HTTP_OK; |
|
|
} |
|
|
|
|
39 |
if (id == -1) |
if (id == -1) |
40 |
reply.out() << "<h2>New Customer</h2>\n"; |
reply.out() << "<h2>New Customer</h2>\n"; |
41 |
else |
else |
51 |
std::string submit = qparam.param("submit"); |
std::string submit = qparam.param("submit"); |
52 |
if (submit == "1") |
if (submit == "1") |
53 |
{ |
{ |
54 |
std::string form_name = qparam.param("name"); |
std::string form_name = trim(qparam.param("name")); |
55 |
std::string form_address = qparam.param("address"); |
std::string form_address = trim(qparam.param("address")); |
56 |
std::string form_phone = qparam.param("phone"); |
std::string form_phone = trim(qparam.param("phone")); |
57 |
std::string form_contact = qparam.param("contact"); |
std::string form_contact = trim(qparam.param("contact")); |
58 |
|
|
59 |
|
|
60 |
if (id == -1) |
if (id == -1) |
65 |
|
|
66 |
//tntdb::Value v = conn.selectValue("SELECT lastval()"); //get the auto-generated id |
//tntdb::Value v = conn.selectValue("SELECT lastval()"); //get the auto-generated id |
67 |
//id = v.getInt(); |
//id = v.getInt(); |
68 |
reply.setHeader("Refresh", "0; url=adm_customer_list"); |
|
69 |
return HTTP_OK; |
reply.setHeader("Location", "adm_customer_list"); |
70 |
|
return HTTP_MOVED_TEMPORARILY; |
71 |
} |
} |
72 |
else |
else |
73 |
{ |
{ |
74 |
tntdb::Statement st = conn.prepare("UPDATE customer SET name=:v1, address=:v2, phonenr=:v3, contactperson=:v4 WHERE id=:v5"); |
tntdb::Statement st = conn.prepare("UPDATE customer SET name=:v1, address=:v2, phonenr=:v3, contactperson=:v4 WHERE id=:v5"); |
75 |
st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact).setInt("v5", id); |
st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact).setInt("v5", id); |
76 |
st.execute(); |
st.execute(); |
77 |
|
|
78 |
|
reply.out() << "<i>Customer updated</i><br>\n"; |
79 |
} |
} |
80 |
|
|
81 |
} |
} |