Q5/ws_objects/Ew_report.pbl.src/w_rp_sale_saler.srw

$PBExportHeader$w_rp_sale_saler.srw
forward
global type w_rp_sale_saler from w_publ_easyq
end type
type ddlb_flag from dropdownlistbox within w_rp_sale_saler
end type
type ddlb_2 from dropdownlistbox within w_rp_sale_saler
end type
type st_2 from statictext within w_rp_sale_saler
end type
type ddlb_scid from uo_ddlb_scid within w_rp_sale_saler
end type
type st_5 from statictext within w_rp_sale_saler
end type
type ddlb_1 from uo_ddlb_storageid within w_rp_sale_saler
end type
type st_1 from statictext within w_rp_sale_saler
end type
end forward

global type w_rp_sale_saler from w_publ_easyq
string title = "业务员销售统计表"
ddlb_flag ddlb_flag
ddlb_2 ddlb_2
st_2 st_2
ddlb_scid ddlb_scid
st_5 st_5
ddlb_1 ddlb_1
st_1 st_1
end type
global w_rp_sale_saler w_rp_sale_saler

type variables
long cur_flag= -1 //-1：全部，0仓库未审,1仓库已审核
long cur_secflag= -1 //-1：全部，0财务未审
long cur_scid_arr[]
Long cur_storageid_arr[]
long cur_storageid = 0
end variables

forward prototypes
public subroutine wf_hidecol ()
end prototypes

public subroutine wf_hidecol ();IF dw_1.DataObject = 'dw_rp_sale_saler_mx' THEN
	s_hide_col s_col1, s_col2,s_col3
	
	s_col1.col_1 = 'costamt'
	f_hide_col(490,dw_1,s_col1)
	

	
	s_col3.col_1 = 'u_outwaremx_fprice'
	s_col3.col_2 = 'u_outwaremx_rebate'
	s_col3.col_3 = 'u_outwaremx_price'
	s_col3.col_4 = 'amt'
	s_col3.col_5 = 'u_outwaremx_ware_fprice'
	s_col3.col_6 = 'ware_amt'
	s_col3.col_7 = 'u_outware_otheramt'
	f_hide_col(122,dw_1,s_col3)
END IF
	s_col2.col_1 = 'gpamt'
	s_col2.col_2 = 'gpr'
	f_hide_col(843,dw_1,s_col2)
	
		s_col1.col_1 = 'costamt'
	f_hide_col(123,dw_1,s_col1)
	
		s_col1.col_1 = 'costamt'
	f_hide_col(490,dw_1,s_col1)
	
	s_hide_col s_col_plan
s_col_plan.col_1 = 'planprice'
s_col_plan.col_2 = 'enamt_plan'
s_col_plan.col_3 = 'gpamt_plan'
f_hide_col(1451,dw_1,s_col_plan)

end subroutine

on w_rp_sale_saler.create
int iCurrent
call super::create
this.ddlb_flag=create ddlb_flag
this.ddlb_2=create ddlb_2
this.st_2=create st_2
this.ddlb_scid=create ddlb_scid
this.st_5=create st_5
this.ddlb_1=create ddlb_1
this.st_1=create st_1
iCurrent=UpperBound(this.Control)
this.Control[iCurrent+1]=this.ddlb_flag
this.Control[iCurrent+2]=this.ddlb_2
this.Control[iCurrent+3]=this.st_2
this.Control[iCurrent+4]=this.ddlb_scid
this.Control[iCurrent+5]=this.st_5
this.Control[iCurrent+6]=this.ddlb_1
this.Control[iCurrent+7]=this.st_1
end on

on w_rp_sale_saler.destroy
call super::destroy
destroy(this.ddlb_flag)
destroy(this.ddlb_2)
destroy(this.st_2)
destroy(this.ddlb_scid)
destroy(this.st_5)
destroy(this.ddlb_1)
destroy(this.st_1)
end on

type cb_func from w_publ_easyq`cb_func within w_rp_sale_saler
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_sale_saler
end type

type cb_2 from w_publ_easyq`cb_2 within w_rp_sale_saler
boolean bringtotop = true
end type

type cb_psetup from w_publ_easyq`cb_psetup within w_rp_sale_saler
boolean bringtotop = true
end type

type cb_1 from w_publ_easyq`cb_1 within w_rp_sale_saler
boolean bringtotop = true
end type

event cb_1::clicked;Int ls_flag = 0
DateTime first_date,end_date
first_date = DateTime(Date(em_1.Text),Time(0))
end_date = DateTime(Date(em_2.Text),Time('23:59:59'))

IF first_date < sys_showsaledata_mindt THEN first_date= sys_showsaledata_mindt


Int li_option_outrep,li_option_opemp
string ls_option_opemp
IF sys_power_issuper THEN
	li_option_outrep = 0
ELSE
	li_option_outrep = sys_option_outrep
END IF
IF sys_power_issuper THEN
	li_option_opemp = 0
//	ls_option_opemp = publ_operator
ELSE
	li_option_opemp = sys_option_opemp_sale
	ls_option_opemp = publ_operator
END IF

dw_1.Retrieve(cur_scid_arr,cur_storageid_arr,first_date,end_date,cur_flag,cur_secflag,sys_areaid, sys_user_outrep, li_option_outrep,ls_option_opemp,li_option_opemp)







end event

type st_3 from w_publ_easyq`st_3 within w_rp_sale_saler
integer x = 2075
integer y = 204
integer width = 210
alignment alignment = left!
end type

type st_4 from w_publ_easyq`st_4 within w_rp_sale_saler
integer x = 2789
integer y = 204
end type

type em_1 from w_publ_easyq`em_1 within w_rp_sale_saler
integer x = 2277
integer y = 188
integer taborder = 120
end type

type em_2 from w_publ_easyq`em_2 within w_rp_sale_saler
integer x = 2894
integer y = 188
integer taborder = 130
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_sale_saler
integer x = 1563
integer y = 4
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_sale_saler
integer x = 1353
integer y = 8
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_sale_saler
integer y = 288
integer width = 2665
integer height = 1044
string dataobject = "dw_rp_sale_saler_mx"
end type

event dw_1::doubleclicked;call super::doubleclicked;IF dw_1.DataObject = 'dw_rp_sale_saler_mx' or dw_1.DataObject = 'dw_rp_sale_saler_mx_b'  THEN
	IF row > 0 THEN
		String ls_code
		Long ll_scid
//		Int li_thflag
		
		ll_scid = THIS.Object.u_outware_scid[row]
		ls_code = THIS.Object.u_outware_outwarecode[row]
//		li_thflag = THIS.Object.u_outware_thflag[row]
		f_open_win(ll_scid,ls_code)
	END IF
END IF

end event

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_sale_saler
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_sale_saler
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_sale_saler
end type

type st_cust from w_publ_easyq`st_cust within w_rp_sale_saler
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_sale_saler
boolean visible = true
integer x = 1353
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_sale_saler
integer x = 2693
integer y = 188
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_sale_saler
integer x = 3310
integer y = 188
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_sale_saler
integer x = 3419
integer y = 188
end type

type cb_help from w_publ_easyq`cb_help within w_rp_sale_saler
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_sale_saler
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_sale_saler
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_sale_saler
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_sale_saler
end type

type r_bar from w_publ_easyq`r_bar within w_rp_sale_saler
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_sale_saler
integer beginy = 280
integer endy = 280
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_sale_saler
integer beginy = 284
integer endy = 284
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_sale_saler
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_sale_saler
end type

type ddlb_flag from dropdownlistbox within w_rp_sale_saler
integer x = 1609
integer y = 188
integer width = 457
integer height = 484
integer taborder = 90
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
string text = "[全部]"
boolean sorted = false
boolean vscrollbar = true
string item[] = {"[全部]","待仓库审核","待财务审核","审核完毕"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;if index=1 then
	cur_flag=-1
	cur_secflag= -1
elseif index=2 then
	cur_flag= 0 
	cur_secflag= -1
elseif index=3 then
	cur_flag= 1	
	cur_secflag= 0
elseif index=4 then
	cur_flag= 1	
	cur_secflag= 1
end if

cb_1.triggerevent(clicked!)


end event

type ddlb_2 from dropdownlistbox within w_rp_sale_saler
integer x = 1961
integer y = 48
integer width = 411
integer height = 448
integer taborder = 90
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
string text = "明细表"
boolean sorted = false
boolean vscrollbar = true
string item[] = {"明细表","汇总表","销售额排名"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;dw_1.uf_save_profile_layout()
IF ddlb_2.Text = '明细表' THEN
//	IF sys_version = 802001 THEN //商业版
//		dw_1.DataObject = 'dw_rp_sale_saler_mx_b'
//	ELSE //工业版
		dw_1.DataObject = 'dw_rp_sale_saler_mx'
//	END IF
ELSEIF ddlb_2.Text = '汇总表' THEN
	dw_1.DataObject = 'dw_rp_sale_saler_hz'
ELSEIF ddlb_2.Text = '销售额排名' THEN
	dw_1.DataObject = 'dw_rp_sale_saler_hz_1'
END IF

wf_replacedw()

cb_1.TriggerEvent(Clicked!)


end event

type st_2 from statictext within w_rp_sale_saler
integer x = 1467
integer y = 204
integer width = 128
integer height = 48
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 134217739
string text = "状态"
alignment alignment = right!
boolean focusrectangle = false
end type

type ddlb_scid from uo_ddlb_scid within w_rp_sale_saler
integer x = 142
integer y = 188
integer width = 480
integer height = 620
integer taborder = 150
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_scid_arr = THIS.uo_scid_arr
end event

event selectionchanged;call super::selectionchanged;
cur_scid_arr = THIS.uo_scid_arr
cb_1.triggerevent(clicked!)
end event

type st_5 from statictext within w_rp_sale_saler
integer x = 5
integer y = 204
integer width = 128
integer height = 48
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 134217739
string text = "分部"
alignment alignment = right!
boolean focusrectangle = false
end type

type ddlb_1 from uo_ddlb_storageid within w_rp_sale_saler
integer x = 795
integer y = 188
integer width = 681
integer height = 1108
integer taborder = 30
boolean bringtotop = true
end type

event constructor;call super::constructor;cur_storageid_arr = this.uo_storageid_arr
cur_storageid = this.uo_storageid
end event

event selectionchanged;call super::selectionchanged;cur_storageid_arr = this.uo_storageid_arr
cur_storageid = this.uo_storageid
cb_1.triggerevent(clicked!)
end event

type st_1 from statictext within w_rp_sale_saler
integer x = 622
integer y = 208
integer width = 146
integer height = 48
boolean bringtotop = true
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
long backcolor = 134217739
string text = "仓库"
alignment alignment = right!
boolean focusrectangle = false
end type