예제 #1
0
    def addSale():
        #Don't forget to check for the values before you submit

        customerID = customerNamesVar.get()
        SKU = varSKU.get()
        amount = AmountEntry.get()
        cc = ccButtonValue.get()
        result = pos.addSale(customerID ,SKU , cc , amount)
        if(result['error']==True):
            resultLabel.configure(fg="red" , text=result['message'])
        else:
            resultLabel.configure(fg="green" , text=result['message'])
예제 #2
0
def intialize():
    if not os.path.exists("settings.ini"):
        configure.createConfig()

    config = ConfigParser()
    config.read("settings.ini")

    dbPath = config.get("database", "url")
    isDBInstalled = config.get("firsttime", "db-installed")
    if isDBInstalled == "0":
        conn = sqlite3.connect(dbPath)
        conn.execute(""" DROP TABLE  IF EXISTS PRODUCT; """)
        conn.execute(""" DROP TABLE  IF EXISTS CUSTOMER; """)
        conn.execute(""" DROP TABLE  IF EXISTS SALE; """)

        conn.execute(
            "CREATE  TABLE PRODUCT (SKU CHAR(50) PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, PRICE INT NOT NULL);"
        )
        conn.execute(
            "CREATE  TABLE CUSTOMER  (customerID CHAR(50) PRIMARY KEY     NOT NULL, customerName  TEXT  NOT NULL);"
        )
        conn.execute(
            "CREATE  TABLE SALE (ID INTEGER PRIMARY KEY AUTOINCREMENT, paymethod CHAR(50) NOT NULL, customerID CHAR(50) NOT NULL, productID CHAR(50) NOT NULL, total    INT NOT NULL ,sdate DATETIME DEFAULT CURRENT_TIMESTAMP);"
        )

        defaultCustomer = Customer(0, "Default Customer")
        Customer(1, "Monica")
        Customer(2, "I")
        Customer(3, "Carmen")
        Customer(4, "Begum")

        p1 = Product(123, "Stripes Shirt", 10)
        p2 = Product(1234, "Plain Shirt with Contrasting Collar", 20)
        p3 = Product(12345, "zapatooos i love the word zapatos btw ", 30)

        pos.addSale(customerID=1, productSKU=123, cc=0, amount=1)
        pos.addSale(customerID=2, productSKU=1234, cc=1, amount=1)
        pos.addSale(customerID=2, productSKU=12345, cc=1, amount=1)
        pos.addSale(customerID=2, productSKU=1234, cc=0, amount=1)
        conn.close()

        config.set("firsttime", "db-installed", "1")

        # write changes back to the config file
        with open("settings.ini", "w") as config_file:
            config.write(config_file)