Open-Source-Python-POS-and-Accounting-Software/newProd.py at master · Peterchama/Open-Source-Python-POS-and-Accounting-Software · GitHub

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
from connectToDb import connectToDB

conn = connectToDB()

import wx
import wx.xrc

class GetData(wx.Dialog):
    def __init__(self, parent, bc):
        wx.Dialog.__init__(self, parent, wx.ID_ANY, "New Product", size= (650,320))
        self.panel = wx.Panel(self,wx.ID_ANY)

        self.lblName = wx.StaticText(self.panel, label="Name", pos=(20,20))
        self.name = wx.TextCtrl(self.panel, value="", pos=(110,20), size=(500,-1))

        self.lblBarcode = wx.StaticText(self.panel, label="Barcode", pos=(20,60))
        self.barcode = wx.TextCtrl(self.panel, value="", pos=(110,60), size=(500,-1))
        self.barcode.SetValue(str(bc))

        self.lblCP = wx.StaticText(self.panel, label="Cost Price", pos=(20,100))
        self.costPrice = wx.TextCtrl(self.panel, value="", pos=(110,100), size=(500,-1))

        self.lblSP = wx.StaticText(self.panel, label="Selling Price", pos=(20,140))
        self.sellingPrice = wx.TextCtrl(self.panel, value="", pos=(110,140), size=(500,-1))

        self.lblQty = wx.StaticText(self.panel, label="Quantity", pos=(20,180))
        self.qty = wx.TextCtrl(self.panel, value="", pos=(110,180), size=(500,-1))

        self.lblmlvl = wx.StaticText(self.panel, label="Minimum Level", pos=(20,220))
        self.minLvl = wx.TextCtrl(self.panel, value="", pos=(110,220), size=(500,-1))


        self.saveButton =wx.Button(self.panel, label="Save", pos=(110,260))
        self.closeButton =wx.Button(self.panel, label="Cancel", pos=(250,260))

        self.saveButton.Bind(wx.EVT_BUTTON, self.SaveConnString)
        self.closeButton.Bind(wx.EVT_BUTTON, self.OnQuit)

        self.Bind(wx.EVT_CLOSE, self.OnQuit)

        self.Show()

    def OnQuit(self, event):
        self.result_name = None
        self.Destroy()

    def SaveConnString(self, event):
        name = self.name.GetValue()
        bc = self.barcode.GetValue()
        cp = self.costPrice.GetValue()
        sp = self.sellingPrice.GetValue()
        qty = self.qty.GetValue()
        minLvl = self.minLvl.GetValue()

        qry = "INSERT INTO `products` (name, type, costPrice, sellingPrice, minLevel, barcode) VALUES ('%s', '3', '%s', '%s', '%s', '%s')" % (name, cp, sp, minLvl, bc)

        conn.cursor().execute(qry)

        i = conn.insert_id()

        qry = "INSERT INTO `currentinventory` (productId, quantity) VALUES ('%s', '%s')" % (i, qty)

        conn.cursor().execute(qry)

        conn.commit()

        self.Destroy()