def import_supplier(payment1):
print "insert supplier"
DBSession.add_all([
Supplier(name = u'中深翔', display_name = u'中深翔', address = u'布吉丹竹头金鹏物流园A区A栋18-20号', mobile = '13600432849', contact_person = u'全总', remark = u'上海', payment = payment1),
Supplier(name = u'深中联', display_name = u'深中联', address = u'布吉丹竹头金鹏物流园A栋5-6号', mobile = '13392826777,18902480211', contact_person = u'王总，丁小姐', remark = u'温州、台州、温岭、临海、黄岩', payment = payment1),
Supplier(name = u'旺平达', display_name = u'旺平达', address = u'龙华明治大道华通源物流中心B2栋263-266号', mobile = '15099917300', contact_person = u'李飞章', remark = u'苏州、无锡、昆山、张家港、宜兴、常熟、太仓、吴江', payment = payment1),
Supplier(name = u'顺福', display_name = u'顺福', address = u'丹竹头白泥坑宇达物流园3栋301-318号', phone = '89575677', mobile = '13316895558', contact_person = u'陈老板', remark = u'徐州、南通、淮安、盐城、连云港、启东', payment = payment1),
Supplier(name = u'鑫金叶', display_name = u'鑫金叶', address = u'布吉李朗东西干道南岭大龙山物流园G栋1-3号', mobile = '13906667228', contact_person = u'金经理 ', remark = u'温州苍南', payment = payment1),
Supplier(name = u'华发', display_name = u'华发', address = u'金鹏物流园B区9栋7-12号', mobile = '15999677737', contact_person = u' 陈老板', remark = u'南京、常州、扬州、泰州、镇江、靖江', payment = payment1),
Supplier(name = u'京鹏', display_name = u'京鹏', address = u'华通源物流中心C4栋138-152号', mobile = '13066815788,13066815788', contact_person = u'老板娘 傅总', remark = u'杭州、上虞、湖州、德清、临安、丽水、桐乡、长兴、云南省', payment = payment1),
Supplier(name = u'凯林瑞', display_name = u'凯林瑞', address = u'龙岗区丹竹头金鹏物流园B区D栋41-42号', phone = '0755-82432843', mobile = '', contact_person = u'杨总', remark = u'浙江嘉兴', payment = payment1),
Supplier(name = u'海联', display_name = u'海联', address = u'华通源物流中心', mobile = '18688838882', contact_person = u'李老板', remark = u'宁波、义乌、绍兴、衢州、诸暨、金华、慈溪、余姚、舟山、奉化', payment = payment1),
Supplier(name = u'荣晖', display_name = u'荣晖', address = u'金鹏A区B栋15-18号,40-42号', mobile = '13631528080', contact_person = u'胡总', remark = u'南昌、赣州、新余、吉安、九江、萍乡、宜春、鹰潭', payment = payment1),
Supplier(name = u'深湘', display_name = u'深湘', address = u'长城货代市场83档', mobile = '13902485137', contact_person = u'丘总', remark = u'长沙、常德、衡阳、株洲、湘阴、岳阳、怀化、湘潭', payment = payment1),
Supplier(name = u'澳跃', display_name = u'澳跃', address = u'金鹏', mobile = '13902311565', contact_person = u'肖总', remark = u'武汉、黄冈、黄石、荆州、咸宁、孝感、襄樊、恩施、十堰、襄阳', payment = payment1),
Supplier(name = u'金鹏行', display_name = u'金鹏行', address = u'', mobile = '18926534999', contact_person = u'俞总', remark = u'合肥、淮南、黄山、桐城、芜湖、宣城、安庆、铜陵、涡阳、滁州、怀远', payment = payment1),
Supplier(name = u'京鹏', display_name = u'京鹏', address = u'华通源物流中心C4栋138-152号', mobile = '13066815788', contact_person = u'傅小姐', remark = u'昆明、大理、曲靖、景洪', payment = payment1),
Supplier(name = u'鑫辉', display_name = u'鑫辉', address = u'布吉丹平路闽鹏程货运市场11栋1-4号', mobile = '13925234059', contact_person = u'刘先生', remark = u'龙岩、三明', payment = payment1),
Supplier(name = u'广运物流', display_name = u'广运物流', address = u'龙岗丹竹头闽鹏程货运市场5栋29-30号', mobile = '18923724600', contact_person = u'徐先生', remark = u'顺德', payment = payment1),
Supplier(name = u'金华航', display_name = u'金华航', address = u'华通源物流园', phone = '0755-23022756', mobile = '', contact_person = u'刘先生', remark = u'中山', payment = payment1),
Supplier(name = u'速速达', display_name = u'速速达', address = u'龙岗区布吉上李朗方鑫路22号速速达物流', phone = None, mobile = '13392831936', contact_person = u'王晓刚', remark = u'南宁、桂林、柳州、钦州', payment = payment1),
Supplier(name = u'盛丰', display_name = u'盛丰', address = u'龙岗区南湾街道吉厦社区早禾坑工业区15号A栋', phone = None, mobile = '13798363667', contact_person = u'周总', remark = u'泉州、福州、莆田、福清', payment = payment1),
Supplier(name = u'美泰', display_name = u'美泰', address = u'龙岗布吉大龙山物流园F栋10号美泰物流', phone = None, mobile = '18926795962', contact_person = u'毛主管', remark = u'广州', payment = payment1),
Supplier(name = u'凯利', display_name = u'凯利', address = u'布吉单竹头金鹏物流园B区E栋1-5号 ', phone = '61217611,61217600', mobile = '', contact_person = u'熊小姐', remark = u'三亚、海口、琼海、万宁', payment = payment1),
Supplier(name = u'骏兴顺', display_name = u'骏兴顺', address = u'龙华民治大道华通源物流中心C1栋58-60号', phone = None, mobile = '15914055308', contact_person = u'曾经理', remark = u'贵阳、金沙、安顺', payment = payment1),
Supplier(name = u'澳跃', display_name = u'澳跃', address = u'金鹏A区栋13-15号', phone = None, mobile = '18923411132', contact_person = u'李峰', remark = u'漳州', payment = payment1),
Supplier(name = u'勤威', display_name = u'勤威', address = u'金鹏B区C栋33号', phone = None, mobile = '13728866595', contact_person = u'石总', remark = u'厦门', payment = payment1),
])
DBSession.commit()
def import_weiqian_targets(weiqian):
print 'import weiqian targets'
t1 = CustomerTarget(customer = weiqian, name = u'深圳市味来道贸易有限公司Ａ', province_id = 19, city_id = 290)
DBSession.flush()
t1_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t1.id, name = u'邓梦成', mobile = '13410716458', phone = '0755-89538779,83742178', address = u'南山区沙河西路深宝路交界处白沙物流旁（深圳市粮食集团曙光冷库）', remark = u'深圳代理商')
t2 = CustomerTarget(customer = weiqian, name = u'广州白云沪苏贸易经营部', province_id = 19, city_id = 290)
DBSession.flush()
t2_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t2.id, name = u'吴煌龙', mobile = '13798313454', phone = '0755-28273934', address = u'布吉莲花路莲山庄五村内围42号', remark = u'深圳代理商')
t3 = CustomerTarget(customer = weiqian, name = u'香港港丰控股有限公司', province_id = 33, city_id = None)
DBSession.flush()
t3_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t3.id, name = u'刘德基', mobile = None, phone = '0085292678917,0085225167033', email = '*****@*****.**', address = u'新界将军澳工业村 骏光街9号（惠康超市）- 牛奶公司冷藏货收货区', remark = u'香港代理商')
t4 = CustomerTarget(customer = weiqian, name = u'深圳市味来道贸易有限公司Ｂ', province_id = 19, city_id = 290)
DBSession.flush()
t4_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t4.id, name = u'邓梦成', mobile = None, phone = '0755-89538779,83472178', email = None, address = u'龙岗区坪山镇坑梓工业园沃尔玛中心配送仓', remark = u'深圳代理商')
t5 = CustomerTarget(customer = weiqian, name = u'深圳市农批华兴经营部', province_id = 19, city_id = 290)
DBSession.flush()
t5_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t5.id, name = u'邓老板', mobile = '13823636826', phone = None, email = None, address = u'龙岗区布路布吉警署后松园新村', remark = u'深圳代理商')
t6 = CustomerTarget(customer = weiqian, name = u'深圳市金满源贸易有限公司', province_id = 19, city_id = 290)
DBSession.flush()
t6_c1 = CustomerContact(customer = weiqian, type = 'T', refer_id = t6.id, name = u'罗发财', mobile = '18926455915', phone = None, email = None, address = u'布吉镇坂田街道岗头风门坳村亚洲工业园15号', remark = u'深圳代理商')
t6_c2 = CustomerContact(customer = weiqian, type = 'T', refer_id = t6.id, name = u'王进云', mobile = '13423967408', phone = '0755-29001027', email = '*****@*****.**', address = u'布吉镇坂田街道岗头风门坳村亚洲工业园15号', remark = u'深圳代理商')
t7 = CustomerTarget(customer = weiqian, name = u'成都永盛食品有限责任公司', province_id = 23, city_id = 326)
DBSession.flush()
t7_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t7.id, name = u'蒋志英', mobile = '18980019806', phone = '028-85354318', email = '*****@*****.**', address = u'锦江区琉璃场径天中路上东家园77路公交车总站', remark = u'成都代理商')
t8 = CustomerTarget(customer = weiqian, name = u'湘潭市兴盛贸易有限公司', province_id = 18, city_id = 27)
DBSession.flush()
t8_c1 = CustomerContact(customer = weiqian, type = 'T', refer_id = t8.id, name = u'谭冰艳', mobile = '18608489007', phone = None, email = None, address = u'雨湖区草塘路61号', remark = u'湘潭代现商')
t8_c2 = CustomerContact(customer = weiqian, type = 'T', refer_id = t8.id, name = u'周卫星', mobile = '13317425511', phone = '0731-55578399', email = None, address = u'雨湖区草塘路61号', remark = u'湘潭代现商')
t9 = CustomerTarget(customer = weiqian, name = u'惠州市三林贸易有限公司', province_id = 19, city_id = 298)
DBSession.flush()
t9_c1 = CustomerContact(customer = weiqian, type = 'T', refer_id = t9.id, name = u'张君', mobile = None, phone = '0752-2695370', email = None, address = u'惠城区镇隆镇皇后村委斜对面', remark = u'惠州代理商')
t9_c2 = CustomerContact(customer = weiqian, type = 'T', refer_id = t9.id, name = u'徐三林', mobile = '18688335596', phone = '0752-2695370', email = '*****@*****.**', address = u'惠城区镇隆镇皇后村委斜对面', remark = u'惠州代理商')
t10 = CustomerTarget(customer = weiqian, name = u'佛山顺德区瑞驰贸易有限公司', province_id = 19, city_id = 293)
DBSession.flush()
t10_c1 = CustomerContact(customer = weiqian, type = 'T', refer_id = t10.id, name = u'梁友鸿', mobile = '13702622982', phone = '0757-2229201', email = None, address = u'顺德区大良大门小湾村为民街8号', remark = u'顺德代理商')
t10_c2 = CustomerContact(customer = weiqian, type = 'T', refer_id = t10.id, name = u'温风涛', mobile = None, phone = None, email = None, address = u'顺德区大良大门小湾村为民街8号', remark = u'顺德代理商')
t11 = CustomerTarget(customer = weiqian, name = u'东莞市良云贸易有限公司', province_id = 19, city_id = 304)
DBSession.flush()
t11_c1 = CustomerContact(customer = weiqian, type = 'T', refer_id = t11.id, name = u'钟丽情', mobile = '13431268281', phone = '0769-22467285', email = None, address = u'南城区白马翠园街西二环巷8号', remark = u'东莞代理商')
t11_c2 = CustomerContact(customer = weiqian, type = 'T', refer_id = t11.id, name = u'朱小毛', mobile = '13728275577', phone = '0769-76922467285', email = '*****@*****.**', address = u'南城区白马翠园街西二环巷8号', remark = u'东莞代理商')
t12 = CustomerTarget(customer = weiqian, name = u'厦门恒顺联商贸有限公司', province_id = 19, city_id = 288)
DBSession.flush()
t12_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t12.id, name = u'朱蔚', mobile = '18927843611', phone = None, email = '*****@*****.**', address = u'白云区沙太北路大源南路自编33号', remark = u'广州代理商')
t13 = CustomerTarget(customer = weiqian, name = u'广州市领隆贸易有限公司', province_id = 19, city_id = 288)
DBSession.flush()
t13_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t13.id, name = u'曹领', mobile = '15989152636', phone = '020-84265759', email = '*****@*****.**', address = u'广州市白云区沙太北路大源南路自编33号', remark = u'广州代理商')
t14 = CustomerTarget(customer = weiqian, name = u'广州沃奥贸易有限公司', province_id = 19, city_id = 288)
DBSession.flush()
t14_c = CustomerContact(customer = weiqian, type = 'T', refer_id = t14.id, name = u'林奇峰', mobile = '15989152636', phone = '020-81795981', email = None, address = u'白云区增槎路东旺市场南二排42档', remark = u'广州代理商')
DBSession.add_all([
t1, t1_c, t2, t2_c, t3, t3_c, t4, t4_c, t5, t5_c, t6, t6_c1, t6_c2, t7, t7_c, t8, t8_c1, t8_c2, t9, t9_c1, t9_c2, t10, t10_c1, t10_c2,
t11, t11_c1, t11_c2, t12, t12_c, t13, t13_c, t14, t14_c
])
def init():
try:
print "create tables"
metadata.drop_all(engine, checkfirst = True)
metadata.create_all(engine)
print "insert default value"
#add the default value here
uAdmin = User(name = 'admin', email = '*****@*****.**', password = '******')
# uKinlong = User(name = u'kinlong', email = '*****@*****.**', password = '******')
# uWeiqian = User(name = u'weiqian', email = '*****@*****.**', password = '******')
uKefua = User(name = u'kefu1', email = '*****@*****.**', password = '******')
uWha = User(name = u'wh1', email = '*****@*****.**', password = '******')
uFina = User(name = u'fin1', email = '*****@*****.**', password = '******')
uUser1 = User(name = u'罗凌云', email = '*****@*****.**', password = '******')
uUser2 = User(name = u'陈龙', email = '*****@*****.**', password = '******')
# uUser3 = User(name = u'邓二', email = '*****@*****.**', password = '******')
uUser4 = User(name = u'刘坤', email = '*****@*****.**', password = '******')
uUser5 = User(name = u'何灿明', email = '*****@*****.**', password = '******')
# uUser6 = User(name = u'黄燕琴', email = '*****@*****.**', password = '******')
uUser7 = User(name = u'吴丽玲', email = '*****@*****.**', password = '******')
uUser8 = User(name = u'徐腾芳', email = '*****@*****.**', password = '******')
uUser9 = User(name = u'黄霄莹', email = '*****@*****.**', password = '******')
uUser10 = User(name = u'林凤', email = '*****@*****.**', password = '******')
# uUser11 = User(name = u'吴秋梅', email = '*****@*****.**', password = '******')
uUser12 = User(name = u'林秀贤', email = '*****@*****.**', password = '******')
uUser13 = User(name = u'曾德莲', email = '*****@*****.**', password = '******')
uUser14 = User(name = u'李时坚', email = '*****@*****.**', password = '******')
uUser15 = User(name = u'深福合力', email = '*****@*****.**', password = '******')
pAdminManage = Permission(name = 'AMIN_MANAGE', desc = u'进入管理员控制台')
pCreateUser = Permission(name = 'CREATE_USER', desc = u'创建新用户')
pUpdateUser = Permission(name = 'UPDATE_USER', desc = u'更新用户信息')
pDeleteUser = Permission(name = 'DELETE_USER', desc = u'删除用户')
pSearchUser = Permission(name = 'SEARCH_USER', desc = u'查询用户')
pManageUser = Permission(name = 'MANAGE_USER', desc = u'管理所有用户')
pCreateGroup = Permission(name = 'CREATE_GROUP', desc = u'删除组')
pUpdateGroup = Permission(name = 'UPDATE_GROUP', desc = u'更新组信息')
pDeleteGroup = Permission(name = 'DELETE_GROUP', desc = u'删除组')
pSearchGroup = Permission(name = 'SEARCH_GROUP', desc = u'查询所在组')
pManageGroup = Permission(name = 'MANAGE_GROUP', desc = u'管理所有组')
pCreatePermission = Permission(name = 'CREATE_PERMISSION', desc = u'创建新权限')
pUpdatePermission = Permission(name = 'UPDATE_PERMISSION', desc = u'更新权限')
pDeletePermission = Permission(name = 'DELETE_PERMISSION', desc = u'删除权限')
pSearchPermission = Permission(name = 'SEARCH_PERMISSION', desc = u'查询所在权限')
pManagePermission = Permission(name = 'MANAGE_PERMISSION', desc = u'管理所在权限')
pCreateMaster = Permission(name = 'CREATE_MASTER', desc = u'创建新的系统设置')
pUpdateMaster = Permission(name = 'UPDATE_MASTER', desc = u'更新现有的系统设置')
pDeleteMaster = Permission(name = 'DELETE_MASTER', desc = u'删除系统设置')
pSearchMaster = Permission(name = 'SEARCH_MASTER', desc = u'查询所有的系统设置')
pManageMaster = Permission(name = 'MANAGE_MASTER', desc = u'进入系统设置控制台')
pCreateOrder = Permission(name = 'CREATE_ORDER', desc = u'创建新的订单')
pUpdateOrder = Permission(name = 'UPDATE_ORDER', desc = u'更新订单信息')
pDeleteOrder = Permission(name = 'DELETE_ORDER', desc = u'删除订单')
pSearchOrder = Permission(name = 'SEARCH_ORDER', desc = u'查询订单')
pManageOrder = Permission(name = 'MANAGE_ORDER', desc = u'管理所有的订单')
pSearchAllOrder = Permission(name = 'SEARCH_ALL_ORDER', desc = u'查询所有的订单')
pCreateDeliver = Permission(name = 'CREATE_DELIVER', desc = u'创建新的送货单')
pUpdateDeliver = Permission(name = 'UPDATE_DELIVER', desc = u'更新送货单信息')
pDeleteDeliver = Permission(name = 'DELETE_DELIVER', desc = u'删除送货单信息')
pSearchDeliver = Permission(name = 'SEARCH_DELIVER', desc = u'查询所在的送货单')
pManageDeliver = Permission(name = 'MANAGE_DELIVER', desc = u'进入送货单管理控制台')
pSearchAllDeliver = Permission(name = 'SEARCH_ALL_ELIVER', desc = u'查询所有的送货单')
pCreateCustomer = Permission(name = 'CREATE_CUSTOMER', desc = u'创建新的客户')
pUpdateCustomer = Permission(name = 'UPDATE_CUSTOMER', desc = u'更新客户信息')
pDeleteCustomer = Permission(name = 'DELETE_CUSTOMER', desc = u'删除客户')
pSearchCustomer = Permission(name = 'SEARCH_CUSTOMER', desc = u'查询所有的客户')
pCreateSupplier = Permission(name = 'CREATE_SUPPLIER', desc = u'创建新的承运商')
pUpdateSupplier = Permission(name = 'UPDATE_SUPPLIER', desc = u'更新承运商信息')
pDeleteSupplier = Permission(name = 'DELETE_SUPPLIER', desc = u'删除承运商信息')
pSearchSupplier = Permission(name = 'SEARCH_SUPPLIER', desc = u'查询所有的承运商信息')
pCreateWarehouse = Permission(name = 'CREATE_WAREHOUSE', desc = u'创建新的仓存地点')
pUpdateWarehouse = Permission(name = 'UPDATE_WAREHOUSE', desc = u'更新仓存地点信息')
pDeleteWarehouse = Permission(name = 'DELETE_WAREHOUSE', desc = u'删除仓存地点')
pSearchWarehouse = Permission(name = 'SEARCH_WAREHOUSE', desc = u'查询所有仓存地点')
pManageFin = Permission(name = 'MANAGE_FIN', desc = u'进入财务管理控制台')
pFinSearch = Permission(name = 'FIN_SEARCH', desc = u'查询订单信息')
pFinApprove = Permission(name = 'FIN_APPROVE', desc = u'审核通过订单信息')
pFinPaid = Permission(name = 'FIN_PAID', desc = u'确认客户是否已付款')
pFinSupplierPaid = Permission(name = 'FIN_SUPPLIER_PAID', desc = u'确认是否已付款予承运商')
gAdmin = Group(name = u'管理员组', display_name = u'管理员组', type = 0)
gAdmin.permissions = [pAdminManage, pCreateUser, pUpdateUser, pDeleteUser, pSearchUser, pManageUser,
pCreateGroup, pUpdateGroup, pDeleteGroup, pSearchGroup, pManageGroup,
pCreatePermission, pUpdatePermission, pDeletePermission, pSearchPermission, pManagePermission,
pCreateMaster, pUpdateMaster, pDeleteMaster, pSearchMaster, pManageMaster,
pCreateOrder, pUpdateOrder, pDeleteOrder, pSearchOrder, pSearchAllOrder, pManageOrder,
pCreateDeliver, pUpdateDeliver, pDeleteDeliver, pSearchDeliver, pSearchAllDeliver, pManageDeliver,
pCreateCustomer, pUpdateCustomer, pDeleteCustomer, pSearchCustomer,
pCreateSupplier, pUpdateSupplier, pDeleteSupplier, pSearchSupplier,
pCreateWarehouse, pUpdateWarehouse, pDeleteWarehouse, pSearchWarehouse,
pManageFin, pFinSearch, pFinApprove, pFinPaid, pFinSupplierPaid
]
gAdmin.users = [uAdmin, ]
gCustomer = Group(name = u'客户组', display_name = u'客户组', type = 0)
gCustomer.permissions = [pCreateOrder, pUpdateOrder, pDeleteOrder, pSearchOrder, ]
gKinlongGroup = Group(name = 'KINLONG_GROUP', display_name = 'KINLONG GROUP', type = 1)
gWeiqianGroup = Group(name = 'WEIQIAN_GROUP', display_name = 'WEIQIAN GROUP', type = 1)
gOfficer = Group(name = u'客服组', display_name = u'客服组', type = 0)
gOfficer.permissions = [
pCreateMaster, pUpdateMaster, pDeleteMaster, pSearchMaster, pManageMaster,
pCreateOrder, pUpdateOrder, pDeleteOrder, pSearchOrder, pSearchAllOrder, pManageOrder,
pCreateDeliver, pUpdateDeliver, pDeleteDeliver, pSearchDeliver, pManageDeliver, pSearchAllDeliver,
]
gOfficer.users = [uKefua, uUser7, uUser9, uUser10, uUser13 ]
gFin = Group(name = u'财务组', display_name = u'财务组', type = 0)
gFin.permissions = [
pCreateMaster, pUpdateMaster, pDeleteMaster, pSearchMaster, pManageMaster,
pCreateOrder, pUpdateOrder, pDeleteOrder, pSearchOrder, pSearchAllOrder, pManageOrder,
pCreateDeliver, pUpdateDeliver, pDeleteDeliver, pSearchDeliver, pSearchAllDeliver, pManageDeliver,
pCreateCustomer, pUpdateCustomer, pDeleteCustomer, pSearchCustomer,
pCreateSupplier, pUpdateSupplier, pDeleteSupplier, pSearchSupplier,
pCreateWarehouse, pUpdateWarehouse, pDeleteWarehouse, pSearchWarehouse,
pManageFin, pFinSearch, pFinApprove, pFinPaid, pFinSupplierPaid
]
gFin.users = [uFina, uUser1, uUser2, uUser4, uUser5, uUser12, uUser15]
gSupplier = Group(name = u'承运商组', display_name = u'承运商组', type = 0)
gSupplier.permissions = [pUpdateDeliver, pSearchDeliver ]
# gSupplier.users = [uSupplier]
gSupplier1 = Group(name = 'SUPPLIER_1', display_name = 'Supplier1', type = 1)
# gSupplier1.users = [uSupplier]
gWarehouse = Group(name = u'仓库组', display_name = u'仓库组', type = 0)
gWarehouse.permissions = [pUpdateOrder, pSearchOrder, pSearchAllOrder, pManageOrder,
pCreateDeliver, pUpdateDeliver, pSearchDeliver, pSearchAllDeliver, pManageDeliver ]
gWarehouse.users = [uWha, uUser8, uUser14]
DBSession.add_all([
uAdmin, uKefua, uFina, uWha,
# uKefu2, uSupplier, uWarehouse,
uUser1, uUser2, uUser4, uUser5, uUser7, uUser8, uUser9, uUser10, uUser12, uUser13, uUser14, uUser15,
pCreateUser, pUpdateUser, pDeleteUser, pSearchUser, pManageUser,
pCreateGroup, pUpdateGroup, pDeleteGroup, pSearchGroup, pManageGroup,
pCreatePermission, pUpdatePermission, pDeletePermission, pSearchPermission, pManagePermission,
pCreateMaster, pUpdateMaster, pDeleteMaster, pSearchMaster, pManageMaster,
pCreateOrder, pUpdateOrder, pDeleteOrder, pSearchOrder, pSearchAllOrder, pManageOrder,
pCreateDeliver, pUpdateDeliver, pDeleteDeliver, pSearchDeliver, pSearchAllDeliver, pManageDeliver,
pCreateCustomer, pUpdateCustomer, pDeleteCustomer, pSearchCustomer,
pCreateSupplier, pUpdateSupplier, pDeleteSupplier, pSearchSupplier,
pCreateWarehouse, pUpdateWarehouse, pDeleteWarehouse, pSearchWarehouse,
gAdmin, gCustomer, gOfficer, gSupplier, gWarehouse,
gKinlongGroup, gWeiqianGroup,
])
for n, en, tn in [(u'米', u'meter', u'米'), (u'分米', u'dm', u'分米'), (u'厘米', u'cm', u'釐米'), (u'吨', u'ton', u'噸'), (u'千克', u'kg', u'千克'), (u'克', u'g', u'克'),
(u'箱', u'box', u'箱'), (u'瓶', u'bottle', u'瓶'), (u'只', u'pic', u'只'), (u'打', u'dozen', u'打'), ]:
DBSession.add(ItemUnit(name = n, english_name = en, tradition_name = tn))
for n, en, tn in [(u'吨', u'ton', u'噸'), (u'千克', u'kg', u'千克'), (u'克', u'g', u'克'), ]:
DBSession.add(WeightUnit(name = n, english_name = en, tradition_name = tn))
# location1 = InventoryLocation(name = u"深圳仓库", address = u"仓库地址 1", manager = "李先生", full_path = u"深圳仓库")
# location1_A = InventoryLocation(name = u"A区", address = u"仓库地址 1", manager = "李先生", full_path = u"A区", parent = location1)
# location1_B = InventoryLocation(name = u"B区", address = u"仓库地址 1", manager = "李先生", full_path = u"B区", parent = location1)
# location1_C = InventoryLocation(name = u"C区", address = u"仓库地址 1", manager = "李先生", full_path = u"C区", parent = location1)
# location2 = InventoryLocation(name = u"东莞仓库", address = u"仓库地址 2", manager = "林先生", full_path = u"东莞仓库")
# location2_A = InventoryLocation(name = u"A区", address = u"仓库地址 2", manager = "林先生", full_path = u"A区", parent = location2)
# location2_B = InventoryLocation(name = u"B区", address = u"仓库地址 2", manager = "林先生", full_path = u"B区", parent = location2)
# location2_C = InventoryLocation(name = u"C区", address = u"仓库地址 2", manager = "林先生", full_path = u"C区", parent = location2)
#
# DBSession.add_all([location1, location1_A, location1_B, location1_C,
# location2, location2_A, location2_B, location2_C,
# ])
# location1.full_path_ids = location1.id
# location2.full_path_ids = location2.id
DBSession.flush()
DBSession.add(ShipmentType(name = u"陆运"))
# DBSession.add(ShipmentType(name = u"水运"))
# DBSession.add(ShipmentType(name = u"空运"))
payment1 = Payment(name = u"月付")
payment2 = Payment(name = u"到付")
payment3 = Payment(name = u"现付")
DBSession.add_all([payment1, payment2, payment3])
DBSession.add(Ratio(type = "QTY", value = 10))
DBSession.add(Ratio(type = "VOL", value = 0.33))
DBSession.add(Ratio(type = "WEIGHT", value = 0.5))
DBSession.add(PickupType(name = u"自提"))
DBSession.add(PickupType(name = u"送货"))
DBSession.add(PickupType(name = u"司机直送"))
DBSession.add(PickupType(name = u"送货上门"))
DBSession.add(PickupType(name = u"送货上楼"))
DBSession.add(PackType(name = u"纸箱"))
DBSession.add(PackType(name = u"袋装"))
DBSession.add(PackType(name = u"桶装"))
DBSession.add(PackType(name = u"林架"))
DBSession.add(Item(name = u"五金"))
DBSession.add(Item(name = u"食品"))
DBSession.add(Item(name = u"器材"))
DBSession.add(Item(name = u"木料"))
DBSession.add(Item(name = u"器具"))
DBSession.add(Item(name = u"家具"))
print 'insert diqu'
province_f = open('sys2do/sql/master_province.sql')
province_sql = "".join(province_f.readlines())
province_f.close()
city_f = open('sys2do/sql/master_city.sql')
city_sql = "".join(city_f.readlines())
city_f.close()
conn = DBSession.connection()
conn.execute(province_sql)
conn.execute(city_sql)
DBSession.commit()
receiver1 = Receiver(code = u'粤BIP092', name = u'黄司机', tel = None, mobile = '15976884544',)
receiver2 = Receiver(code = u'粤BQ4225', name = '叶司机', tel = None, mobile = '13682553458',)
receiver3 = Receiver(code = u'粤BJU706', name = u'张司机', tel = None, mobile = '15813808186',)
receiver4 = Receiver(code = u'粤BJX667', name = u'李司机', tel = None, mobile = '13590435287',)
receiver5 = Receiver(code = u'粤BPY286', name = u'杨司机', tel = None, mobile = '13554881765',)
receiver6 = Receiver(code = u'粤BVQ582', name = u'杨司机', tel = None, mobile = '13724255912',)
receiver7 = Receiver(code = u'粤B2X846', name = u'巍司机', tel = None, mobile = '13410189026',)
DBSession.add_all([receiver1, receiver2, receiver3, receiver4, receiver5, receiver6, receiver7])
note1 = Note(code = '0001191-1', name = u'坚朗', province_id = 19, city_id = 290, apply_person_id = 1, apply_time = '2012-08-23',
begin_no = '1188000', end_no = '1188599', remark = u'坚朗专用二本')
note2 = Note(code = '1001191-1', name = u'味千', province_id = 19, city_id = 290, apply_person_id = 1, apply_time = '2012-08-23',
begin_no = '2188000', end_no = '2188599', remark = u'味千专用一本')
DBSession.add_all([
note1,
])
kinlong = Customer(name = u"广东坚朗五金制品股份有限公司", display_name = u'坚朗', province_id = 19, city_id = 304,
address = u"塘厦镇大坪村工业区卢地坑路3号", phone = "0769-82166666", contact_person = u'陈先生',
mobile = '12800138999', note = note1)
kinlong_source1 = CustomerSource(customer = kinlong, name = u"坚朗一厂", province_id = 19, city_id = 304, payment = payment1) #东莞
kinlong_source2 = CustomerSource(customer = kinlong, name = u"坚朗二厂", province_id = 19, city_id = 304, payment = payment1) #东莞
kinlong_source3 = CustomerSource(customer = kinlong, name = u"坚朗三厂", province_id = 19, city_id = 304, payment = payment1) #东莞
DBSession.add_all([
kinlong, kinlong_source1, kinlong_source2, kinlong_source3,
])
DBSession.flush()
kinlong_source1_c1 = CustomerContact(customer = kinlong, type = 'S', refer_id = kinlong_source1.id, name = u'李小明', mobile = u'13880138111', phone = u'1234561', address = u'厚街', is_default = 1)
kinlong_source1_c2 = CustomerContact(customer = kinlong, type = 'S', refer_id = kinlong_source1.id, name = u'张三', mobile = u'13880138112', phone = u'1234562', address = u'长安',)
kinlong_source2_c1 = CustomerContact(customer = kinlong, type = 'S', refer_id = kinlong_source2.id, name = u'王二', mobile = u'13880138113', phone = u'1234563', address = u'常平',)
kinlong_source2_c2 = CustomerContact(customer = kinlong, type = 'S', refer_id = kinlong_source2.id, name = u'王小川', mobile = u'13880138114', phone = u'1234563', address = u'虎门',)
kinlong_source3_c2 = CustomerContact(customer = kinlong, type = 'S', refer_id = kinlong_source3.id, name = u'钟远', mobile = u'13880138116', phone = u'1234563', address = u'大岭山',)
DBSession.add_all([
kinlong_source1_c1, kinlong_source1_c2, kinlong_source2_c1, kinlong_source2_c2, kinlong_source3_c2,
])
#import the kinlong target contact
import_kinlong_target(kinlong)
#import the supplier
import_supplier(payment1)
weiqian = Customer(name = u"味千(中国)控投有限公司", display_name = u'味千', province_id = 19, city_id = 290,
address = u"福田区金田路3037号金中环商务大厦主楼23号", phone = "0755-8280 5333", contact_person = None,
mobile = None, note = note2)
weiqian_source1 = CustomerSource(customer = weiqian, name = u"味千一厂", province_id = 19, city_id = 290, payment = payment1)
DBSession.add_all([
weiqian, weiqian_source1
])
DBSession.flush()
weiqian_source1_c1 = CustomerContact(customer = weiqian, type = 'S', refer_id = weiqian_source1.id, name = u'陆先生', mobile = u'13880138111', phone = u'1234561', address = u'福田', is_default = 1)
DBSession.add_all([
weiqian_source1_c1,
])
import_weiqian_targets(weiqian)
DBSession.commit()
print "finish init!"
except:
traceback.print_exc()
DBSession.rollback()
def import_kinlong_target(kinlong):
print "insert kinlong target"
d = open('kinlong_contact.txt')
for line in d:
location, name, mobile = line.strip().split("|")
location = unicode(location)
try:
c = DBSession.query(City).filter(City.name.op('like')('%%%s%%' % location[:2])).one()
t = CustomerTarget(customer = kinlong, name = location, province_id = c.parent().id, city_id = c.id)
DBSession.add(t)
DBSession.flush()
contact = CustomerContact(customer = kinlong, type = 'T', refer_id = t.id, name = name, mobile = mobile, phone = None, address = None)
DBSession.add(contact)
except:
pass
d.close()
hangkou = CustomerTarget(customer = kinlong, name = u'汉口办(公共)', province_id = 17, city_id = 261)
DBSession.flush()
hangkou_c = CustomerContact(customer = kinlong, type = 'T', refer_id = hangkou.id, name = u'张明洋', mobile = '13407191121', phone = None, address = u'汉口')
wuchang = CustomerTarget(customer = kinlong, name = u'武昌办公共、商用建筑销售部', province_id = 17, city_id = 261)
shanghai = CustomerTarget(customer = kinlong, name = u'上海住宅开发部', province_id = 9, city_id = None)
DBSession.flush()
shanghai_c = CustomerContact(customer = kinlong, type = 'T', refer_id = shanghai.id, name = u'李金虎', mobile = '13774413112', phone = None, address = None)
fuqing = CustomerTarget(customer = kinlong, name = u'福清销售点', province_id = 13, city_id = 207)
DBSession.flush()
fuqing_c = CustomerContact(customer = kinlong, type = 'T', refer_id = fuqing.id, name = u'陈文峰', mobile = '18259122060', phone = None, address = u'福清')
huadu = CustomerTarget(customer = kinlong, name = u'花都办', province_id = 19, city_id = 288)
DBSession.flush()
huadu_c = CustomerContact(customer = kinlong, type = 'T', refer_id = huadu.id, name = u'彭双林', mobile = '13060809011', phone = None, address = u'花都')
changshu = CustomerTarget(customer = kinlong, name = u'常熟办', province_id = 10, city_id = 170)
DBSession.flush()
changshu_c = CustomerContact(customer = kinlong, type = 'T', refer_id = changshu.id, name = u'梅陈赓', mobile = '15951100335', phone = None, address = u'常熟')
kunshang = CustomerTarget(customer = kinlong, name = u'昆山销售点', province_id = 10, city_id = 170)
DBSession.flush()
kunshang_c = CustomerContact(customer = kinlong, type = 'T', refer_id = kunshang.id, name = u'肖杰', mobile = '13616218299', phone = None, address = u'昆山')
wujiang = CustomerTarget(customer = kinlong, name = u'吴江销售点', province_id = 10, city_id = 170)
DBSession.flush()
wujiang_c = CustomerContact(customer = kinlong, type = 'T', refer_id = wujiang.id, name = u'向武将', mobile = '13862105593', phone = None, address = u'吴江')
zjg = CustomerTarget(customer = kinlong, name = u'张家港销售点', province_id = 10, city_id = 170)
DBSession.flush()
zjg_c = CustomerContact(customer = kinlong, type = 'T', refer_id = zjg.id, name = u'胡伟', mobile = '15850181896', phone = None, address = u'张家港')
yx = CustomerTarget(customer = kinlong, name = u'宜兴办', province_id = 10, city_id = 167)
DBSession.flush()
yx_c = CustomerContact(customer = kinlong, type = 'T', refer_id = yx.id, name = u'王伟', mobile = '13347926039', phone = None, address = u'宜兴')
cx = CustomerTarget(customer = kinlong, name = u'慈溪销售点', province_id = 11, city_id = 180)
DBSession.flush()
cx_c = CustomerContact(customer = kinlong, type = 'T', refer_id = cx.id, name = u'刘晓', mobile = '13566087866', phone = None, address = u'慈溪')
zj = CustomerTarget(customer = kinlong, name = u'诸暨销售点', province_id = 11, city_id = 184)
DBSession.flush()
zj_c = CustomerContact(customer = kinlong, type = 'T', refer_id = zj.id, name = u'叶坦', mobile = '13575559619', phone = None, address = u'诸暨')
cn = CustomerTarget(customer = kinlong, name = u'苍南销售点', province_id = 11, city_id = 181)
DBSession.flush()
cn_c = CustomerContact(customer = kinlong, type = 'T', refer_id = cn.id, name = u'李志坚', mobile = '13646536682', phone = None, address = u'苍南')
wl = CustomerTarget(customer = kinlong, name = u'温岭销售点', province_id = 11, city_id = 188)
DBSession.flush()
wl_c = CustomerContact(customer = kinlong, type = 'T', refer_id = wl.id, name = u'彭学江', mobile = '13957677975', phone = None, address = u'温岭')
yw = CustomerTarget(customer = kinlong, name = u'义乌销售点', province_id = 11, city_id = 185)
DBSession.flush()
yw_c = CustomerContact(customer = kinlong, type = 'T', refer_id = yw.id, name = u'贡健', mobile = '15057840176', phone = None, address = u'义乌')
DBSession.add_all([
hangkou, hangkou_c, wuchang, shanghai, shanghai_c, fuqing, fuqing_c, huadu, huadu_c, changshu, changshu_c, kunshang, kunshang_c,
wujiang, wujiang_c, zjg, zjg_c, yx, yx_c, cx, cx_c, zj, zj_c, cn, cn_c, wl, wl_c, yw, yw_c,
])
def in_note_save_new(self):
params = {
"customer_id" : _g('customer_id'),
"so" : _g('so'),
"po" : _g('po'),
"dn" : _g('dn'),
"ref" : _g('ref'),
"remark" : _g('remark'),
}
try:
header = InventoryInNote(**params)
DBSession.add(header)
DBSession.flush()
total_qty = total_area = total_weight = 0
item_json = _g('item_json', '')
for item in json.loads(item_json):
if item['item_id']:
dbItem = DBSession.query(InventoryItem).get(item['item_id'])
try:
locationItem = DBSession.query(InventoryLocationItem).filter(and_(
InventoryLocationItem.active == 0,
InventoryLocationItem.item_id == item['item_id'],
InventoryLocationItem.location_id == item['location_id'],
)).with_lockmode("update").one()
except:
locationItem = InventoryLocationItem(item = dbItem, location_id = item['location_id'],)
DBSession.add(locationItem)
DBSession.flush()
else:
dbItem = InventoryItem(name = item['item_name'], desc = item['desc'])
locationItem = InventoryLocationItem(item = dbItem, location_id = item['location_id'],)
DBSession.add_all([dbItem, locationItem])
DBSession.flush()
d = InventoryNoteDetail(header_id = header.id, type = 'IN' , item = dbItem,
desc = item['desc'], qty = item['qty'] or 0, weight = item['weight'] or 0,
area = item['area'] or 0, remark = item['remark'],
location_id = item['location_id'],
)
DBSession.add(d)
if d.qty :
total_qty += int(d.qty)
locationItem.qty += int(d.qty)
locationItem.exp_qty += int(d.qty)
if d.area :
total_area += float(d.area)
locationItem.area += float(d.area)
locationItem.exp_area += float(d.area)
if d.weight :
total_weight += float(d.weight)
locationItem.weight += float(d.weight)
locationItem.exp_weight += float(d.weight)
header.no = getInNoteNo(header.id)
header.qty = total_qty
header.weight = total_weight
header.area = total_area
DBSession.commit()
flash(MSG_SAVE_SUCC, MESSAGE_INFO)
return redirect(url_for(".view", action = "in_note_review", id = header.id))
except:
DBSession.rollback()
_error(traceback.print_exc())
flash(MSG_SERVER_ERROR, MESSAGE_ERROR)
return redirect(url_for(".view", action = "in_note"))
