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

$PBExportHeader$w_rp_sale_mtrl.srw
forward
global type w_rp_sale_mtrl from w_publ_easyq
end type
type ddlb_flag from dropdownlistbox within w_rp_sale_mtrl
end type
type ddlb_1 from uo_ddlb_storageid within w_rp_sale_mtrl
end type
type tv_1 from uo_tv_mtrltype within w_rp_sale_mtrl
end type
type ddlb_scid from uo_ddlb_scid within w_rp_sale_mtrl
end type
type st_5 from statictext within w_rp_sale_mtrl
end type
type ddlb_2 from dropdownlistbox within w_rp_sale_mtrl
end type
type ddlb_3 from dropdownlistbox within w_rp_sale_mtrl
end type
end forward

global type w_rp_sale_mtrl from w_publ_easyq
integer width = 3538
integer height = 2096
string title = "产品销售汇总表"
ddlb_flag ddlb_flag
ddlb_1 ddlb_1
tv_1 tv_1
ddlb_scid ddlb_scid
st_5 st_5
ddlb_2 ddlb_2
ddlb_3 ddlb_3
end type
global w_rp_sale_mtrl w_rp_sale_mtrl

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

forward prototypes
public function integer wf_dw ()
public subroutine wf_hidecol ()
end prototypes

public function integer wf_dw ();String ls_windowname
ls_windowname = This.ClassName ( )

String ls_old_dwname,ls_new_dwname = ''
ls_old_dwname = dw_1.DataObject
ls_new_dwname = f_get_dwprint_dynamic_chname(ls_old_dwname,ls_windowname)

IF dw_1.DataObject = 'dw_rp_sale_mtrl_pz' THEN 
	dw_1.SetTransObject(sqlca)
	RETURN 1
end if
IF ls_new_dwname = '' THEN
	ls_new_dwname = ls_old_dwname
END IF

dw_1.DataObject = ls_new_dwname
dw_1.SetTransObject(sqlca)
dw_1.uf_read_profile_layout()
//
f_title_change(dw_1)
RETURN 1


end function

public subroutine wf_hidecol ();s_hide_col s_col

s_col.col_1 = 'costamt'

f_hide_col(123,dw_1,s_col)

s_col.col_1 = 'grossprofit'
s_col.col_2 = 'gpr'
f_hide_col(843,dw_1,s_col)

s_col.col_1 = 'costamt'

f_hide_col(490,dw_1,s_col)

s_hide_col s_col_plan
s_col_plan.col_1 = 'u_mtrldef_planprice'
s_col_plan.col_2 = 'enamt_plan'
s_col_plan.col_3 = 'gpamt_plan'
f_hide_col(1451,dw_1,s_col_plan)

s_hide_col s_col_2
s_col_2.col_1 = 'amt'
s_col_2.col_2 = 'enamt2'
s_col_2.col_3 = 'enamt_notax'
s_col_2.col_4 = 'enprice_notax'
s_col_2.col_5 = 'jamt'
s_col_2.col_6 = 'gpamt_notax'
s_col_2.col_7 = 'grossprofit'
s_col_2.col_8 = 'v_temp_storage_v_amt'
f_hide_col(122,dw_1,s_col_2)

end subroutine

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

on w_rp_sale_mtrl.destroy
call super::destroy
destroy(this.ddlb_flag)
destroy(this.ddlb_1)
destroy(this.tv_1)
destroy(this.ddlb_scid)
destroy(this.st_5)
destroy(this.ddlb_2)
destroy(this.ddlb_3)
end on

event resize;call super::resize;tv_1.height=this.height - dw_1.y - 115
end event

event ue_before_openretrieve;s_hide_col s_col1,s_col2
s_col1.col_1 = 'costamt'
f_hide_col(490,dw_1,s_col1)

s_col2.col_1 = 'grossprofit'
f_hide_col(843,dw_1,s_col2)

s_hide_col s_col_mtrlsectype
s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype' 
f_hide_col(1308,dw_1,s_col_mtrlsectype) 

s_hide_col s_col_zxmtrlmode
s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode' 
f_hide_col(1309,dw_1,s_col_zxmtrlmode)


s_hide_col s_col_amt
s_col_amt.col_1 = 'amt'
f_hide_col(122,dw_1,s_col_amt)

s_hide_col s_col_planprice
s_col_planprice.col_1 = 'u_mtrldef_planprice'
f_hide_col(1451,dw_1,s_col_planprice)


end event

event ue_before_open;call super::ue_before_open;EM_1.Text = String(Today(),'YYYY-MM-01')
EM_2.Text = String(Today(),'YYYY-MM-DD')

end event

type cb_func from w_publ_easyq`cb_func within w_rp_sale_mtrl
end type

type cb_exit from w_publ_easyq`cb_exit within w_rp_sale_mtrl
end type

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

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

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

event cb_1::clicked;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
IF sys_power_issuper THEN
	li_option_outrep = 0
ELSE
	li_option_outrep = sys_option_outrep
END IF

dw_1.Retrieve(cur_scid_arr,cur_storageid_arr,first_date,end_date,cur_flag,cur_secflag,sys_areaid,ls_handtype,-1,cur_thflag, sys_user_outrep, li_option_outrep)
wf_hidecol()

parent.TriggerEvent('ue_before_openretrieve')

end event

type st_3 from w_publ_easyq`st_3 within w_rp_sale_mtrl
integer x = 2021
integer y = 212
end type

type st_4 from w_publ_easyq`st_4 within w_rp_sale_mtrl
integer x = 2725
integer y = 212
end type

type em_1 from w_publ_easyq`em_1 within w_rp_sale_mtrl
integer x = 2213
integer taborder = 110
end type

type em_2 from w_publ_easyq`em_2 within w_rp_sale_mtrl
integer x = 2825
integer taborder = 120
end type

type ddlb_yl from w_publ_easyq`ddlb_yl within w_rp_sale_mtrl
integer x = 1637
integer y = 0
end type

type cbx_yl from w_publ_easyq`cbx_yl within w_rp_sale_mtrl
integer x = 1426
integer y = 4
end type

type dw_1 from w_publ_easyq`dw_1 within w_rp_sale_mtrl
integer x = 768
integer y = 300
integer width = 2048
integer height = 1088
string dataobject = "dw_rp_sale_mtrl"
end type

type sle_mtrl from w_publ_easyq`sle_mtrl within w_rp_sale_mtrl
end type

type sle_cust from w_publ_easyq`sle_cust within w_rp_sale_mtrl
end type

type st_mtrl from w_publ_easyq`st_mtrl within w_rp_sale_mtrl
end type

type st_cust from w_publ_easyq`st_cust within w_rp_sale_mtrl
end type

type cbx_loginretr from w_publ_easyq`cbx_loginretr within w_rp_sale_mtrl
boolean visible = true
integer x = 1426
integer y = 100
end type

type pb_em1 from w_publ_easyq`pb_em1 within w_rp_sale_mtrl
integer x = 2629
integer y = 188
end type

type pb_em2 from w_publ_easyq`pb_em2 within w_rp_sale_mtrl
integer x = 3237
integer y = 188
end type

type pb_2 from w_publ_easyq`pb_2 within w_rp_sale_mtrl
integer x = 3346
integer y = 188
end type

type cb_help from w_publ_easyq`cb_help within w_rp_sale_mtrl
end type

type cb_copyself from w_publ_easyq`cb_copyself within w_rp_sale_mtrl
end type

type gb_1 from w_publ_easyq`gb_1 within w_rp_sale_mtrl
end type

type ln_bar from w_publ_easyq`ln_bar within w_rp_sale_mtrl
end type

type ln_bar2 from w_publ_easyq`ln_bar2 within w_rp_sale_mtrl
end type

type r_bar from w_publ_easyq`r_bar within w_rp_sale_mtrl
end type

type ln_1 from w_publ_easyq`ln_1 within w_rp_sale_mtrl
end type

type ln_2 from w_publ_easyq`ln_2 within w_rp_sale_mtrl
end type

type ln_3 from w_publ_easyq`ln_3 within w_rp_sale_mtrl
end type

type ln_4 from w_publ_easyq`ln_4 within w_rp_sale_mtrl
end type

type ddlb_flag from dropdownlistbox within w_rp_sale_mtrl
integer x = 1330
integer y = 192
integer width = 384
integer height = 484
integer taborder = 70
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_1 from uo_ddlb_storageid within w_rp_sale_mtrl
integer x = 635
integer y = 192
integer width = 681
integer height = 1108
integer taborder = 120
boolean bringtotop = true
end type

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

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

type tv_1 from uo_tv_mtrltype within w_rp_sale_mtrl
integer y = 300
integer width = 768
integer height = 1120
integer taborder = 70
boolean bringtotop = true
integer textsize = -9
fontcharset fontcharset = gb2312charset!
fontfamily fontfamily = anyfont!
string facename = "宋体"
end type

event selectionchanged;call super::selectionchanged;ls_handtype = THIS.uo_cur_info.handtype
ls_handtype = ls_handtype + '%'
cb_1.triggerevent(clicked!)

end event

type ddlb_scid from uo_ddlb_scid within w_rp_sale_mtrl
integer x = 137
integer y = 192
integer width = 471
integer height = 620
integer taborder = 110
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_mtrl
integer y = 212
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_2 from dropdownlistbox within w_rp_sale_mtrl
integer x = 1714
integer y = 192
integer width = 283
integer height = 484
integer taborder = 80
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_thflag = -1
ELSEIF Index = 2 THEN
	cur_thflag = 0
ELSEIF Index = 3 THEN
	cur_thflag = 1
END IF

cb_1.TriggerEvent(Clicked!)



end event

type ddlb_3 from dropdownlistbox within w_rp_sale_mtrl
integer x = 2395
integer y = 32
integer width = 759
integer height = 756
integer taborder = 130
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
string item[] = {"按产品汇总","按产品配置","按产品汇总(分仓库)"}
borderstyle borderstyle = stylelowered!
end type

event selectionchanged;IF This.Text = '按产品汇总' THEN
	
	dw_1.DataObject = 'dw_rp_sale_mtrl'
	
ELSEIF This.Text = '按产品配置' THEN
	
	dw_1.DataObject = 'dw_rp_sale_mtrl_pz'
	
	
ELSEIF This.Text = '按产品汇总(分仓库)' THEN
	
	dw_1.DataObject = 'dw_rp_sale_mtrl_storage'
	
END IF
wf_dw()
wf_replacedw()

cb_1.TriggerEvent(Clicked!)

end event