def save(self, force_insert=False, force_update=False, using=None, update_fields=None):
super(LowInventory, self).save(force_insert, force_update, using, update_fields)
sql = 'SELECT name_id from assets_lowinventorytmp WHERE name_id = %s'
params = [self.id]
if not generic.selectdate(sql, params):
sql = 'INSERT INTO assets_lowinventorytmp (name_id, is_recycled, inventory, recycled, lose, broken, total_prices, description)' \
' VALUE (%s,%s,%s,%s,%s,%s,%s,%s);'
params = [self.id,self.is_recycled,self.inventory,self.recycled,self.lose,self.broken,self.total_prices,self.description]
generic.update(sql, params)
def save(self, force_insert=False, force_update=False, using=None, update_fields=None):
super(Assets, self).save(force_insert, force_update, using, update_fields)
if not self.num:
sql = 'INSERT INTO assets_allocate (status,allocate_date,num_id,use_department_id,user_id,description,create_time,modified_time) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)'
params = [self.status, self.purchase_date, self.id, 10, self.purchaser_id, self.description,self.create_time, self.create_time]
generic.update(sql, params)
self.num = 'OY%06d' % (self.id)
self.residual_value = '%s' % self.purchase_price
self.save()
def save(self,
force_insert=False,
force_update=False,
using=None,
update_fields=None):
super(UserProfile, self).save(force_insert, force_update, using,
update_fields)
sql = 'UPDATE auth_user SET first_name = %s,email = %s WHERE id=%s'
params = [self.name, self.email, self.user_id]
generic.update(sql, params)
def save(self, force_insert=False, force_update=False, using=None, update_fields=None):
super(Allocate, self).save(force_insert, force_update, using, update_fields)
if self.status == '归还':
sql = 'UPDATE assets_assets SET status = %s, use_department_id = Null, user_id = Null WHERE id=%s'
params = [self.status, self.num_id]
generic.update(sql, params)
elif self.status != '归还':
sql = 'UPDATE assets_assets SET status = %s, use_department_id = %s, user_id = %s WHERE id=%s'
params = [self.status, self.use_department_id, self.user_id, self.num_id]
generic.update(sql, params)
def save(self,
force_insert=False,
force_update=False,
using=None,
update_fields=None):
super(WrokOrders, self).save(force_insert, force_update, using,
update_fields)
if not self.org_dept:
sql = 'UPDATE itmanager_wrokorders SET org_dept_id = (SELECT department_id from usermanager_userprofile WHERE user_id = %s) WHERE id=%s'
params = [self.org_user_id, self.id]
generic.update(sql, params)
def save(self, force_insert=False, force_update=False, using=None, update_fields=None):
super(LowAllocate, self).save(force_insert, force_update, using, update_fields)
if self.status == '入库':
#库存 = 临时表库存 + 调拨数量
sql11 = 'UPDATE assets_lowinventory SET ' \
'inventory = (SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) + %s, ' \
'total_prices = ((SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) + %s * %s) ' \
'WHERE id = %s'
params11 = [self.name_id, self.nums, self.name_id, self.unit_price, self.nums, self.name_id ]
generic.update(sql11, params11)
# 更新临时表库存、回收、丢失、报废、总价
sql12 = 'UPDATE assets_lowinventorytmp SET ' \
'inventory = (SELECT inventory FROM assets_lowinventory WHERE id = %s), ' \
'recycled = (SELECT recycled FROM assets_lowinventory WHERE id = %s), ' \
'lose = (SELECT lose FROM assets_lowinventory WHERE id = %s), ' \
'broken = (SELECT broken FROM assets_lowinventory WHERE id = %s), ' \
'total_prices = (SELECT total_prices FROM assets_lowinventory WHERE id = %s) ' \
'WHERE name_id = %s'
params12 = [self.name_id, self.name_id, self.name_id, self.name_id, self.name_id, self.name_id]
generic.update(sql12, params12)
elif self.status == '领用':
if self.is_recycled == False:
#条件 回收 = 0
#库存 = 临时表库存 - 调拨数量
#总价 = 临时表总价 - （临时表总价/临时表库存）* 调拨数量
sql21 = 'UPDATE assets_lowinventory SET ' \
'inventory = ((SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) - %s), ' \
'total_prices = ((SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) - ' \
'(SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) /' \
'(SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) * %s) ' \
'WHERE id=%s AND recycled = 0'
params21 = [self.name_id, self.nums, self.name_id, self.name_id, self.name_id, self.nums, self.name_id]
generic.update(sql21, params21)
# 条件 回收 > 0
# 回收 = 临时表回收 - 调拨数量
sql22 = 'UPDATE assets_lowinventory SET ' \
'recycled = ((SELECT recycled FROM assets_lowinventorytmp WHERE name_id = %s) - %s) ' \
'WHERE id=%s AND recycled > 0'
params22 = [self.name_id, self.nums, self.name_id]
generic.update(sql22, params22)
elif self.is_recycled == True:
sql23 = 'UPDATE assets_lowinventory SET ' \
'inventory = ((SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) - %s), ' \
'total_prices = ((SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) - ' \
'(SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) /' \
'(SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) * %s) ' \
'WHERE id=%s'
params23 = [self.name_id, self.nums, self.name_id, self.name_id, self.name_id, self.nums, self.name_id]
generic.update(sql23, params23)
# 使用价值 = 原使用价值 + （临时表总价/临时表库存 * 调拨数量)
import datetime
year = datetime.datetime.now().year
month = datetime.datetime.now().month
sql25 = 'SELECT use_department_id from assets_lowprice WHERE use_department_id = %s AND year =%s AND month = %s '
params25 = [self.use_department_id, year, month]
if not generic.selectdate(sql25, params25):
sql26 = 'INSERT INTO assets_lowprice (use_department_id, year,month,useful_value) VALUE (%s,%s,%s,%s);'
params26 = [self.use_department_id, year, month, 0]
generic.update(sql26, params26)
sql27 = 'INSERT INTO assets_lowpricetmp (use_department_id, year,month,useful_value) VALUE (%s,%s,%s,%s);'
params27 = [self.use_department_id, year, month, 0]
generic.update(sql27, params27)
sql28 = 'UPDATE assets_lowprice SET ' \
'useful_value = ((SELECT useful_value FROM assets_lowpricetmp WHERE use_department_id = %s) + ' \
'(SELECT total_prices FROM assets_lowinventorytmp WHERE name_id = %s) /' \
'(SELECT inventory FROM assets_lowinventorytmp WHERE name_id = %s) * %s) ' \
'WHERE use_department_id = %s AND year =%s AND month = %s'
params28 = [self.use_department_id, self.name_id, self.name_id, self.nums, self.use_department_id, year,
month]
generic.update(sql28, params28)
sql29 = 'UPDATE assets_lowpricetmp SET ' \
'useful_value = (SELECT useful_value FROM assets_lowprice WHERE use_department_id = %s)' \
'WHERE use_department_id = %s AND year =%s AND month = %s'
params29 = [self.use_department_id, self.use_department_id, year, month]
generic.update(sql29, params29)
# 更新临时表库存、回收、丢失、报废、总价
sql24 = 'UPDATE assets_lowinventorytmp SET ' \
'inventory = (SELECT inventory FROM assets_lowinventory WHERE id = %s), ' \
'recycled = (SELECT recycled FROM assets_lowinventory WHERE id = %s), ' \
'lose = (SELECT lose FROM assets_lowinventory WHERE id = %s), ' \
'broken = (SELECT broken FROM assets_lowinventory WHERE id = %s), ' \
'total_prices = (SELECT total_prices FROM assets_lowinventory WHERE id = %s) ' \
'WHERE name_id = %s'
params24 = [self.name_id, self.name_id, self.name_id, self.name_id, self.name_id, self.name_id]
generic.update(sql24, params24)
elif self.status == '归还':
#库存归还 = 临时表归还 + 调拨数量
sql31 = 'UPDATE assets_lowinventory SET ' \
'recycled = ((SELECT recycled FROM assets_lowinventorytmp WHERE name_id = %s) + %s) ' \
'WHERE id = %s'
params31 = [self.name_id, self.nums, self.name_id]
generic.update(sql31, params31)
# 更新临时表库存、回收、丢失、报废、总价
sql32 = 'UPDATE assets_lowinventorytmp SET ' \
'inventory = (SELECT inventory FROM assets_lowinventory WHERE id = %s), ' \
'recycled = (SELECT recycled FROM assets_lowinventory WHERE id = %s), ' \
'lose = (SELECT lose FROM assets_lowinventory WHERE id = %s), ' \
'broken = (SELECT broken FROM assets_lowinventory WHERE id = %s), ' \
'total_prices = (SELECT total_prices FROM assets_lowinventory WHERE id = %s) ' \
'WHERE name_id = %s'
params32 = [self.name_id, self.name_id, self.name_id, self.name_id, self.name_id, self.name_id]
generic.update(sql32, params32)
elif self.status == '报废':
#库存报废 = 临时表报废 + 调拨数量
sql41 = 'UPDATE assets_lowinventory SET ' \
'broken = ((SELECT broken FROM assets_lowinventorytmp WHERE name_id = %s) + %s) ' \
'WHERE id = %s'
params41 = [self.name_id, self.nums, self.name_id]
generic.update(sql41, params41)
# 更新临时表库存、回收、丢失、报废、总价
sql42 = 'UPDATE assets_lowinventorytmp SET ' \
'inventory = (SELECT inventory FROM assets_lowinventory WHERE id = %s), ' \
'recycled = (SELECT recycled FROM assets_lowinventory WHERE id = %s), ' \
'lose = (SELECT lose FROM assets_lowinventory WHERE id = %s), ' \
'broken = (SELECT broken FROM assets_lowinventory WHERE id = %s), ' \
'total_prices = (SELECT total_prices FROM assets_lowinventory WHERE id = %s) ' \
'WHERE name_id = %s'
params42 = [self.name_id, self.name_id, self.name_id, self.name_id, self.name_id, self.name_id]
generic.update(sql42, params42)
elif self.status == '丢失':
#库存丢失=临时表丢失 + 调拨数量
sql51 = 'UPDATE assets_lowinventory SET ' \
'lose = ((SELECT lose FROM assets_lowinventorytmp WHERE name_id = %s) + %s) ' \
'WHERE id = %s'
params51 = [self.name_id, self.nums, self.name_id]
generic.update(sql51, params51)
#更新临时表库存、回收、丢失、报废、总价
sql52 = 'UPDATE assets_lowinventorytmp SET ' \
'inventory = (SELECT inventory FROM assets_lowinventory WHERE id = %s), ' \
'recycled = (SELECT recycled FROM assets_lowinventory WHERE id = %s), ' \
'lose = (SELECT lose FROM assets_lowinventory WHERE id = %s), ' \
'broken = (SELECT broken FROM assets_lowinventory WHERE id = %s), ' \
'total_prices = (SELECT total_prices FROM assets_lowinventory WHERE id = %s) ' \
'WHERE name_id = %s'
params52 = [self.name_id, self.name_id, self.name_id, self.name_id, self.name_id, self.name_id]
generic.update(sql52, params52)