def middleCollect(self):
'''中间回收'''
#左边
new_distri_id = getNextVal(self.oracle)
split_tax_end_nbr = addZero(len(self.tax_begin_nbr),
int(self.tax_begin_nbr)-1)
insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id =
self.distri_id, staff_id = self.hold_staff_id, tax_begin_nbr =
self.hold_tax_begin_nbr , tax_end_nbr = split_tax_end_nbr)
insertDistriLog(oracle = self.oracle, distri_id = new_distri_id,
oper_staff_id = self.oper_staff_id, oper = 'split collect', state =
'hold')
#右边
new_distri_id = getNextVal(self.oracle)
split_tax_begin_nbr = addZero(len(self.tax_end_nbr),
int(self.tax_end_nbr)+1)
insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id =
self.distri_id, staff_id = self.hold_staff_id, tax_begin_nbr =
split_tax_begin_nbr , tax_end_nbr = self.hold_tax_end_nbr)
insertDistriLog(oracle = self.oracle, distri_id = new_distri_id,
oper_staff_id = self.oper_staff_id, oper = 'split collect',state =
'hold')
def insertNewDistri(self):
#回收
new_distri_id = getNextVal(self.oracle)
insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id,
distri_id = self.distri_id, staff_id = self.oper_staff_id,
tax_begin_nbr = self.tax_begin_nbr, tax_end_nbr = self.tax_end_nbr)
insertDistriLog(oracle = self.oracle, distri_id = new_distri_id,
oper_staff_id = self.oper_staff_id, oper = 'collect', state = 'hold')
def leftCollect(self):
'''右回收'''
#拆分生成原持有左边剩下的
new_distri_id = getNextVal(self.oracle)
split_tax_end_nbr = addZero(len(self.tax_begin_nbr),
int(self.tax_begin_nbr)-1)
insertDistriAsSplit(self.oracle, new_distri_id = new_distri_id, distri_id =
self.distri_id, staff_id = self.hold_staff_id,
tax_begin_nbr = self.hold_tax_begin_nbr, tax_end_nbr =
split_tax_end_nbr)
insertDistriLog(oracle = self.oracle, distri_id = new_distri_id,
oper_staff_id = self.oper_staff_id, oper = 'split collect', state =
'hold')
def allCollect(oracle, distri_id, oper_staff_id):
'''全部回收'''
update_dic = {'state':'out','state_date':'/sysdate'}
where_dic = {'distri_id':distri_id}
update(oracle, 'distri', update_dic, where_dic)
insertDistriLog(oracle = oracle, distri_id = distri_id, oper_staff_id =
oper_staff_id, oper = 'be collect',state = 'out')
new_distri_id = getNextVal(oracle)
insertDistriAsSplit(oracle, new_distri_id = new_distri_id, distri_id =
distri_id, staff_id = oper_staff_id)
insertDistriLog(oracle = oracle, distri_id = new_distri_id, oper_staff_id =
oper_staff_id, oper = 'collect',state = 'hold')