# coding: utf-8
"""
PyRM - forms
~~~~~~~~~~~~
http://sourceforge.net/projects/pyrm/
:copyright: 2008 by Jens Diemer
:license: GNU GPL v3, see LICENSE.txt for more details.
"""
from __future__ import division, absolute_import
__version__= "$Rev: $"
import posixpath, re, datetime
from django import forms
from django.db import transaction
from django.utils.encoding import smart_str
from django.utils.translation import ugettext as _
from PyLucid.tools.utils import escape
from PyLucid.system.BasePlugin import PyLucidBasePlugin
from PyRM.models import Konto, Kunde, RechnungsPosition, Rechnung
# Datumsformat bei Rechnungserstellung
DATE_FORMAT = _(u"%d.%m.%Y")
# Anzahl der Rechnungen in der Übersicht
DISPLAY_BILL_LIMIT = 5
PARSE_ERROR = "Kann Rechnungspositionen nicht parsen! Fehler in Zeile '%s': %s"
RE_TR = re.compile(r".*?<tr>(.*?)</tr>.*?(?isx)")
RE_TD = re.compile(r".*?<td>(.*?)</td>.*?(?isx)")
class PositionenField(forms.CharField):
# def __init__(self, max_length=None, min_length=None, *args, **kwargs):
# self.max_length, self.min_length = max_length, min_length
# super(CharField, self).__init__(*args, **kwargs)
def clean(self, value):
"""
Parse the tinymce table
"""
# Validates max_length and min_length
value = super(PositionenField, self).clean(value)
result = []
trs = RE_TR.findall(value)[1:]
for tr in trs:
tr = tr.replace(" ", " ")
cells = RE_TD.findall(tr)
cells = [i.strip() for i in cells]
if cells==["","",""]:
# Skip empty lines
continue
anzahl, txt, preis = cells
# Remove html text paragraph formatter
txt = txt.replace("<p>", "")
txt = txt.replace("</p>", "\n")
txt = txt.replace("<br />", "\n")
txt = re.sub("[\r\n]+", "\n", txt)
txt = txt.strip()
if anzahl == "":
anzahl = 0
else:
anzahl = int(anzahl)
if preis == "":
preis = 0
else:
preis = int(preis)
result.append((anzahl, txt, preis,))
return result
BILL_TABLE = """<table width="100%" border="1">
<tbody>
<tr><th>Anzahl</th><th>Beschreibung</th><th>Einzelpreis</th></tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table>"""
class CreateBillForm(forms.Form):
"""
Form for creating a bill.
http://www.djangoproject.com/documentation/newforms/
"""
bestellnummer = forms.IntegerField(required=False)
datum = forms.DateField(
initial=datetime.date.today().strftime(smart_str(DATE_FORMAT)),
input_formats=[DATE_FORMAT]
)
kunde = forms.ModelChoiceField(Konto.objects.all(), required=False)
ggkto = forms.ModelChoiceField(Konto.objects.all(), required=False)
lieferdatum = forms.DateField(input_formats=DATE_FORMAT, required=False)
# anzahl = forms.IntegerField()
# beschreibung = forms.CharField()
# einzelpreis = forms.IntegerField()
positionen = PositionenField(
min_length = 10,
widget=forms.Textarea(attrs={'rows': '10'}),
initial=BILL_TABLE,
help_text=_("Die eizelnen Rechnungspositionen 2"),
)
class PyRM_plugin(PyLucidBasePlugin):
def summary(self):
"""
Übersicht
"""
# Change the global page title:
self.context["PAGE"].title = _(u"PyRM - Übersicht")
self.page_msg(u"Übersicht")
def customers(self):
"""
Kunden
"""
# Change the global page title:
self.context["PAGE"].title = _(u"PyRM - Kunden")
self.page_msg(u"Kunden")
#__________________________________________________________________________
# VIEW BILL
def bills(self):
"""
Rechnungs Übersicht
"""
# Change the global page title:
self.context["PAGE"].title = _(u"PyRM - Rechnungen")
bills = Rechnung.objects.all()[:DISPLAY_BILL_LIMIT]
for bill in bills:
bill.link = self.URLs.methodLink("bill_detail", bill.id)
context = {
"bills": bills,
"count": Rechnung.objects.count(),
"limit": DISPLAY_BILL_LIMIT,
}
self._render_template("bill_summary", context)#, debug=True)
def bill_detail(self, id):
"""
Rechnungsdetails ausgeben
"""
try:
id = id.strip("/")
id = int(id)
bill = Rechnung.objects.get(id = id)
except Exception, e:
self.page_msg.red("Error:", e)
return
# Alle Positionen der Rechnung ermitteln, mit summen Attribut
positionen = bill.positionen.all_with_summ()
context = {
"bill": bill,
"positionen": positionen,
}
self._render_template("bill_detail", context)#, debug=True)
#__________________________________________________________________________
# CREATE BILL
@transaction.commit_manually
def _save_new_bill(self, form_data):
self.page_msg(form_data)
try:
rechnung = Rechnung.objects.create(form_data)
rechnung.save()
self.page_msg.green("Rechnung '%s' erstellt." % rechnung.id)
RechnungsPosition.objects.create_all(
form_data["positionen"], rechnung
)
self.page_msg.green("Rechnungs Positionen erstellt.")
except Exception, e:
self.page_msg.red("Fehler:", e)
transaction.rollback()
else:
transaction.commit()
return self.bills()
def create_bill(self):
"""
Rechnung erstellen
"""
# Change the global page title:
self.context["PAGE"].title = _(u"PyRM - Rechnung erstellen")
context = {}
if self.request.method == 'POST':
#self.page_msg(self.request.POST)
form = CreateBillForm(self.request.POST)
if form.is_valid():
form_data = form.cleaned_data
if "preview" in self.request.POST:
context["preview"] = form_data["positionen"]
self.page_msg(repr(form_data["positionen"]))
else:
return self._save_new_bill(form_data)
else:
form = CreateBillForm()
context["form"] = form
self._add_tiny_mce(js_filename="create_bill_tinymce")
self._render_template("create_bill", context)#, debug=True)
def _add_tiny_mce(self, js_filename):
"""
Activate TinyMCE and load the init js script (js_filename), too.
"""
# url to e.g. /media/PyLucid/tiny_mce/tiny_mce.js
tiny_mce_url = posixpath.join(
self.URLs["PyLucid_media_url"], "tiny_mce", "tiny_mce.js"
)
# url to e.g. .../internal_page/PyRM_plugin/js_filename.js
use_tiny_mce_url = self.internal_page.get_url(
js_filename, slug="js"
)
# Add external media files
for url in (tiny_mce_url, use_tiny_mce_url):
# Add tiny_mce.js to
self.context["js_data"].append({
"plugin_name": self.plugin_name,
"url": url,
})
