Hi Django users,
I am having some dilemma over converting simple admin page Template
(without having to use the built in django-admin functionality) by
using forms, and not templates, I have the following sample Admin page
that allows users to add, edit and delete record per row to Forms:
(Edit and Delete will be links that will be directed to designated
forms)
table.html: (/timetable)
Booking ID Golf Club Status
1 Country Golf Pending Edit Delete
2 Pacific Harbour Cancelled Edit Delete
3 Pacific Dunes Booked Edit Delete
4 Peninsula Booked Edit Delete
-----------------------
Model:
class Booking(models.Model):
bookingId = models.AutoField(primary_key=True)
golfClubName = models.CharField(max_length=50)
status = models.CharField(max_length=20)
views.py
def book_tee_delete(request, object_id):
conn = psycopg2.connect("dbname=my_db user=postgres password=sa
host=localhost")
cur = conn.cursor()
sql = "delete from booking where bookingId = '%s'"% (object_id)
cur.execute(sql)
conn.commit()
conn.close()
return HttpResponseRedirect("/timetable")
def edit_book_tee(request, object_id, model):
booking = Booking.objects.get(pk=int(object_id))
template_name = 'edit_form.html'
t = loader.get_template(template_name)
c = RequestContext(request, {"obj": booking, "id":object_id})
return HttpResponse(t.render(c))
def save_edit(request):
time_format = "%Y-%m-%d %H:%M"
if request.POST['submit'] == 'Save':
bookingid = request.POST['id']
golfclubname = request.POST['golfclubname1']
status = request.POST['status1']
conn = psycopg2.connect("dbname=my_db user=postgres
password=sa host=localhost")
cur = conn.cursor()
sql = "UPDATE booking SET golfClubName='%s', status='%s WHERE
bookingId='%s'" %(golfclubname,status,bookingid)
cur.execute(sql)
conn.commit()
conn.close()
else: #for delete
bookingid = request.POST['id']
conn = psycopg2.connect("dbname=my_db user=postgres
password=sa host=localhost")
cur = conn.cursor()
sql = "delete from chasingbirdies_booking where bookingId =
'%s'" % (bookingid)
cur.execute(sql)
conn.commit()
conn.close()
return HttpResponseRedirect("/timetable")
table.html: (Template)
{% extends "base.html" %}
{% load i18n %}
{% block content %}
<table id='gradient-style' align="center"><thead>
<tr>
<th scope='col'>Booking ID</th>
<th scope='col'>Golf Club</th>
<th scope='col'>Status</th>
<th scope='col'></th>
<th scope='col'></th>
</tr>
</thead><tbody>
{% if teetime_list%}
{% for res in teetime_list %}
<tr>
<td class="tdstyle1">{{ res.bookingId}}</td>
<td class="tdstyle1">{{ res.golfClubName }}</td>
<td class="tdstyle1">{{ res.status }}</td>
<td class="editCol"><a href="/EditBook/
{{ res.bookingId }}">Edit</a></td>
<td class="editCol"><a href="/DeleteBook/
{{ res.bookingId }}">Delete</a></td>
</tr>
{% endfor %}
{% else %}
<p>No lists available.</p>
{% endif %}
</tbody></table>
{% endblock %}
edit.html (Template)
<html>
<div id="bodyContent">
{% if error_message %}<p><strong>{{ error_message }}</strong></
p>{% endif %}
{% csrf_token %}
<form id="edit-point" method="POST" enctype="multipart/form-
data" action="/timetable/">
<fieldset style="width:600px;">
<legend>Edit Teetime</legend>
<br>
<table>
<tr>
<td><label>Booking ID</label></td>
<td align="left"><input type="text" size="15"
readonly="readonly" name="id" value='{{ obj.bookingId }}'></
td>
</tr>
<tr>
<td><label>Golf Club</label></td>
<td colspan="3" align="left"><input size="55" type="text"
name="golfclubname1" value='{{ obj.golfClubName }}'></td>
</tr>
<tr>
<td><label>Status</label></td>
<td colspan="3" align="left"><input size="55"
readonly="readonly" name="status1" value='{{ obj.status }}'></td>
</tr>
</table>
<br>
<input type="submit" name="submit" value="Save">
<input type="submit" name="submit" value="Delete"></form>
<div class="form_block_right">
<form action="/timetable/" method="post">
<input type="submit" class="button"
value="Cancel" /></form>
</div>
</fieldset>
<br><br>
</html>
---------------
My question would be, how do I transform templates on the Edit/Delete
link into Forms, (my other question would be, is there any way I could
show my css using templates on Edit?)?
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
