如何重算营业员提成？

请执行前请先备份数据库，执行完语句后重新至软件中计算提成核实报表数据
use isszmv10
go

–重算商品档案提成（判断是金额提成还是提成率）
—清除提成数据
update t_rm_saleflow set acc_num=0,shift_no=0,clss_rate=0
—金额
update t_rm_saleflow set t_rm_saleflow.shift_no=case when b.dpfm_type=1 and b.return_rate>1 then b.return_rate
when b.dpfm_type=1 and b.return_rate<1 then b.return_rate else 0 end
from t_bd_item_info b
where b.item_no=t_rm_saleflow.item_no
–比例
update t_rm_saleflow set t_rm_saleflow.acc_num=case when b.dpfm_type=0 and b.return_rate<1 then b.return_rate  else 0 end
from t_bd_item_info b
where b.item_no=t_rm_saleflow.item_no

–重算类别提成
update t_rm_saleflow set clss_rate=c.return_rate from
(
select b.item_no,a.return_rate from t_Bd_item_cls a,t_bd_item_info b
where a.item_clsno=b.item_clsno
) c where c.item_no=t_rm_saleflow.item_no

–重算品牌提成
update t_rm_saleflow set Brand_rate=c.return_rate from
(
select b.item_no,a.return_rate from t_bd_item_brand a,t_bd_item_info b
where a.item_brandno=b.item_brand
 )c where c.item_no=t_rm_saleflow.item_no

–重算营业员提成
update t_rm_saleflow  set t_rm_saleflow.sale_rate=r.return_rate from
(
 select * from t_rm_saleman
 )r where t_rm_saleflow.sale_man=r.sale_id

 
 –重算营业员职务提成
update t_rm_saleflow  set t_rm_saleflow.sale_duty_rate=r.sale_duty_rate from
(
 select * from t_rm_saleman
 )r where t_rm_saleflow.sale_man=r.sale_id