def getNewNo():
sql = 'select max(no) from goods'
results = DBUtil.select(sql)
maxNo = results[0]['max(no)']
if maxNo != None:
newNo = 'S' + str(int(maxNo.replace('S', '1')) + 1)[1:]
return newNo
else:
# 没有记录，新创建一个
return 'S0001'
def getNewNo():
sql = 'select max(no) from provider'
results = DBUtil.select(sql)
maxNo = results[0]['max(no)']
if maxNo != '':
newNo = 'G' + str(int(maxNo.replace('G', '1')) + 1)[1:]
return newNo
else:
# 没有记录，新创建一个
return 'G00001'
def add(params):
goods = Goods(id=DBUtil.next_id(),
no=getNewNo(),
name=params.name,
guige=params.guige,
unit=params.unit,
conversion=params.conversion,
quantity=params.quantity,
money=float(params.quantity) * float(params.aprice),
aprice=params.aprice)
return goods.insert()
def add(params):
taizhang = Taizhang(id=DBUtil.next_id(),
no=params.no,
time=params.time,
deal_no=params.deal_no,
goods_no=params.goods_no,
goods_name=params.goods_name,
goods_guige=params.goods_guige,
buy_quantity=params.buy_quantity,
buy_price=params.buy_price,
buy_money=params.buy_money,
sale_quantity=params.sale_quantity,
sale_price=params.sale_price,
sale_money=params.sale_money,
store_quantity=params.store_quantity,
store_money=params.store_money,
store_aprice=params.store_aprice,
comment=params.comment)
return taizhang.insert()
def add(params):
provider = Provider(
id=DBUtil.next_id(),
no=getNewNo(),
name=params.name,
code=params.code,
shuiwu=params.shuiwu,
person=params.person,
phone=params.phone,
mobile=params.mobile,
address=params.address,
email=params.email,
url=params.url,
postcode=params.postcode,
fax=params.fax,
comment=params.comment,
creater=params.creater,
createtime=int(time.time() * 1000),
)
return provider.insert()
def add(params):
customer = Customer(
id=DBUtil.next_id(),
no=getNewNo(),
name=params.name,
code=params.code,
shuiwu=params.shuiwu,
person=params.person,
phone=params.phone,
mobile=params.mobile,
address=params.address,
email=params.email,
bank=params.bank,
bank_no=params.bank_no,
postcode=params.postcode,
fax=params.fax,
comment=params.comment,
creater=params.creater,
createtime=int(time.time() * 1000),
)
return customer.insert()
def add(params):
user = User(id=DBUtil.next_id(),
name=params.name,
cnname=params.cnname,
password=params.password)
return user.insert()
# -*- coding:utf8
from conf.config import configs
from server.db import DBUtil
from server.web.urls import *
import web, logging
from server.web.filter.AuthorizeFilter import loginFilter
logging.log_errors = '1'
web.config.debug = True
DBUtil.create_engine(**configs.db)
app = web.application(urls, globals())
print configs.db.host
db = web.database(dbn='mysql',
host=configs.db.host,
port=configs.db.port,
db=configs.db.db,
user=configs.db.user,
pw=configs.db.passwd)
store = web.session.DBStore(db, 'sessions')
session = web.session.Session(app, store, initializer={'count': 0})
#session = web.session.Session(app, web.session.DiskStore('sessions'), initializer={'count': 0})
web.config._session = session
app.add_processor(loginFilter)
if __name__ == '__main__':
print 'run'
app.run()