Q5/ws_objects/Ew_datatran.pbl.src/f_init_cttbinfo_2.srf

$PBExportHeader$f_init_cttbinfo_2.srf
global type f_init_cttbinfo_2 from function_object
end type

forward prototypes
global function integer f_init_cttbinfo_2 (datetime arg_ctdt, long arg_bg_int, long arg_ed_int, ref s_yfct s_ctmx[])
end prototypes

global function integer f_init_cttbinfo_2 (datetime arg_ctdt, long arg_bg_int, long arg_ed_int, ref s_yfct s_ctmx[]);//s_ctmx[].etbname  :表英文名
//s_ctmx[].ctbname  :表中文名
//s_ctmx[].wherestr :截数串
//s_ctmx[].checkstr :检查串
//s_ctmx[].delstr   :删除串
//s_ctmx[].fromstr  :
//s_ctmx[].linkstr  :关联串
//s_ctmx[].delid:删除id

//***删除工资月
Long ls_del_wagemth,ls_pdint
Date ls_del_date
DateTime ls_del_wagemth_date

ls_pdint = Long(String(arg_ctdt,'yyyymmdd'))

//**工资删除前月*****************************
ls_del_date = Date(String(arg_ctdt,'yyyy-mm-dd'))
IF Month(ls_del_date) = 1 THEN
	ls_del_wagemth = (Year(ls_del_date) - 1) * 100 + 12
ELSE
	ls_del_wagemth = Year(ls_del_date) * 100 + Month(ls_del_date) - 1
END IF
ls_del_wagemth_date = DateTime(Date(Left(String(ls_del_wagemth),4)+'-'+Right(String(ls_del_wagemth),2)+'-01'),Time(0))

//**结存要后5天*************************
DateTime ll_datetime
Date ll_date
ll_date = RelativeDate (Date(String(arg_ctdt,'yyyy-mm-dd')),5)
ll_datetime = DateTime(ll_date,Time('23:59'))
//**************************************************************

//*********************************************
//s_ctmx[51].etbname = 'u_orderworkgroup_time'
//s_ctmx[51].ctbname = '工组调整时间单表'
//s_ctmx[51].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[51].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[51].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[51].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[51].delid = "billid"
//s_ctmx[51].fromstr =  " from u_orderworkgroup_time"
//s_ctmx[51].linkstr = ""




s_ctmx[51].etbname = 'u_spt_price_changemx'
s_ctmx[51].ctbname = '调价单表明细'
s_ctmx[51].wherestr = " where u_spt_price_change.flag = 1 and u_spt_price_change.ctmint = 0 and u_spt_price_change.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[51].checkstr = " where u_spt_price_change.flag = 0 and u_spt_price_change.ctmint = 0 and u_spt_price_change.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[51].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[51].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[51].delid = "billid"
s_ctmx[51].fromstr = " from u_spt_price_change,u_spt_price_changemx"
s_ctmx[51].linkstr = " and u_spt_price_change.scid = u_spt_price_changemx.scid and u_spt_price_change.billid = u_spt_price_changemx.billid"



s_ctmx[52].etbname = 'u_spt_price_change'
s_ctmx[52].ctbname = '调价单表'
s_ctmx[52].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[52].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[52].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[52].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[52].delid = "billid"
s_ctmx[52].fromstr = " from u_spt_price_change"
s_ctmx[52].linkstr = ""

s_ctmx[53].etbname = 'u_spt_amerce'
s_ctmx[53].ctbname = '罚款单表'
s_ctmx[53].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[53].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[53].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[53].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[53].delid = "billid"
s_ctmx[53].fromstr = " from u_spt_amerce"
s_ctmx[53].linkstr = ""

s_ctmx[54].etbname = 'u_order_wfjg_wasteMx'
s_ctmx[54].ctbname = '损耗单明细表'
s_ctmx[54].wherestr = " where u_order_wfjg_waste.flag = 1 and u_order_wfjg_waste.ctmint = 0 and u_order_wfjg_waste.wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[54].checkstr = " where u_order_wfjg_waste.flag = 0 and u_order_wfjg_waste.ctmint = 0 and u_order_wfjg_waste.wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[54].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[54].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[54].delid = "wasteid"
s_ctmx[54].fromstr = " from u_order_wfjg_waste,u_order_wfjg_wasteMx"
s_ctmx[54].linkstr = " and u_order_wfjg_waste.scid = u_order_wfjg_wasteMx.scid and u_order_wfjg_waste.wasteid = u_order_wfjg_wasteMx.wasteid"

s_ctmx[55].etbname = 'u_order_wfjg_waste'
s_ctmx[55].ctbname = '损耗单表'
s_ctmx[55].wherestr = " where flag = 1 and ctmint = 0 and wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[55].checkstr = " where flag = 0 and ctmint = 0 and wastedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[55].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[55].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[55].delid = "wasteid"
s_ctmx[55].fromstr = " from u_order_wfjg_waste"
s_ctmx[55].linkstr = ""

s_ctmx[56].etbname = 'u_updatecostmx'
s_ctmx[56].ctbname = '仓库成本调整单明细'
s_ctmx[56].wherestr = " where u_updatecost.flag = 1 and u_updatecost.ctmint = 0 and u_updatecost.moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[56].checkstr = " where u_updatecost.flag = 0 and u_updatecost.ctmint = 0 and u_updatecost.moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[56].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[56].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[56].delid = "wareid"
s_ctmx[56].fromstr = " from u_updatecost,u_updatecostmx"
s_ctmx[56].linkstr = " and u_updatecost.scid = u_updatecostmx.scid and u_updatecost.wareid = u_updatecostmx.wareid"

s_ctmx[57].etbname = 'u_updatecost'
s_ctmx[57].ctbname = '仓库成本调整单'
s_ctmx[57].wherestr = " where flag = 1 and ctmint = 0 and moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[57].checkstr = " where flag = 0 and ctmint = 0 and moddate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[57].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[57].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[57].delid = "wareid"
s_ctmx[57].fromstr = " from u_updatecost"
s_ctmx[57].linkstr = ""

//s_ctmx[58].etbname = 'u_saletaskmx_mtrlchange'
//s_ctmx[58].ctbname = '销售订单换料单明细表'
//s_ctmx[58].wherestr = " where (u_saletask.status = 3 or u_saletask.status = 5) and u_saletask.ctmint = 0 and u_saletask.taskdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[58].checkstr = " where (u_saletask.status <> 3 and u_saletask.status <> 5) and u_saletask.ctmint = 0 and u_saletask.taskdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[58].delstr  = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[58].ctstr  = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[58].delid   = "taskid"
//s_ctmx[58].fromstr = " from u_saletaskmx_mtrlchange,u_saletask"
//s_ctmx[58].linkstr = " and u_saletask.scid = u_saletaskmx_mtrlchange.scid and u_saletask.taskid = u_saletaskmx_mtrlchange.taskid"

s_ctmx[59].etbname = 'u_mtrlware_transmx'
s_ctmx[59].ctbname = '客户库存调整单明细表'
s_ctmx[59].wherestr = " where u_mtrlware_trans.flag = 1 and u_mtrlware_trans.ctmint = 0 and u_mtrlware_trans.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[59].checkstr = " where u_mtrlware_trans.flag = 0 and u_mtrlware_trans.ctmint = 0 and u_mtrlware_trans.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[59].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[59].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[59].delid = "billid"
s_ctmx[59].fromstr = " from u_mtrlware_trans,u_mtrlware_transmx"
s_ctmx[59].linkstr = " and u_mtrlware_trans.scid = u_mtrlware_transmx.scid and u_mtrlware_trans.billid = u_mtrlware_transmx.billid"

s_ctmx[60].etbname = 'u_mtrlware_trans'
s_ctmx[60].ctbname = '客户库存调整单表'
s_ctmx[60].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[60].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[60].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[60].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[60].delid = "billid"
s_ctmx[60].fromstr = " from u_mtrlware_trans"
s_ctmx[60].linkstr = ""

s_ctmx[61].etbname = 'u_warepdb'
s_ctmx[61].ctbname = '盘点表'
s_ctmx[61].wherestr = " where ctmint = 0 and pdbdate <> '' and pdbdate<='" + String(ls_pdint)+"'"
s_ctmx[61].checkstr = " where ctmint = 0 and pdbdate <> '' and pdbdate<='" + String(ls_pdint)+"'"
s_ctmx[61].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[61].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[61].delid = "mtrlid"
s_ctmx[61].fromstr = " from u_warepdb"
s_ctmx[61].linkstr = ""

s_ctmx[62].etbname = 'u_quotemx'
s_ctmx[62].ctbname = '报价单明细表'
s_ctmx[62].wherestr = " where u_quote.flag = 1 and u_quote.ctmint = 0 and u_quote.quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[62].checkstr = " where u_quote.flag = 0 and u_quote.ctmint = 0 and u_quote.quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[62].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[62].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[62].delid = "quoteid"
s_ctmx[62].fromstr = " from u_quote,u_quotemx"
s_ctmx[62].linkstr = " and u_quote.scid = u_quotemx.scid and u_quote.quoteid = u_quotemx.quoteid"

s_ctmx[63].etbname = 'u_quote'
s_ctmx[63].ctbname = '报价单表'
s_ctmx[63].wherestr = " where flag = 1 and ctmint = 0 and quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[63].checkstr = " where flag = 0 and ctmint = 0 and quotedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[63].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[64].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[63].delid = "quoteid"
s_ctmx[63].fromstr = " from u_quote"
s_ctmx[63].linkstr = ""

//s_ctmx[64].etbname = 'u_scwg_taskwork'
//s_ctmx[64].ctbname = '工作组计件单'
//s_ctmx[64].wherestr = " where Auditingflag = 1 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'"
//s_ctmx[64].checkstr = " where Auditingflag = 0 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'"
//s_ctmx[64].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[64].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[64].delid = "ctmint"
//s_ctmx[64].fromstr = " from u_scwg_taskwork"
//s_ctmx[64].linkstr = ""
//
//s_ctmx[65].etbname = 'u_scwg_taskwork_money'
//s_ctmx[65].ctbname = '工作组计件单工资'
//s_ctmx[65].wherestr = " where Auditingflag = 1 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'"
//s_ctmx[65].checkstr = " where Auditingflag = 0 and ctmint = 0 and wagemth < '" + String(ls_del_wagemth) + "'"
//s_ctmx[65].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[65].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[65].delid = "ctmint"
//s_ctmx[65].fromstr = " from u_scwg_taskwork_money"
//s_ctmx[65].linkstr = ""


//s_ctmx[66].etbname = 'u_spt_wfjgMx'
//s_ctmx[66].ctbname = '加工费分摊单明细表'
//s_ctmx[66].wherestr = " where u_spt_wfjg.flag = 1 and u_spt_wfjg.ctmint = 0 and u_spt_wfjg.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[66].checkstr = " where u_spt_wfjg.flag = 0 and u_spt_wfjg.ctmint = 0 and u_spt_wfjg.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[66].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[66].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[66].delid = "billid"
//s_ctmx[66].fromstr = " from u_spt_wfjg,u_spt_wfjgMx"
//s_ctmx[66].linkstr = " and u_spt_wfjg.scid = u_spt_wfjgMx.scid and u_spt_wfjg.billid = u_spt_wfjgMx.billid"
//
//s_ctmx[67].etbname = 'u_spt_wfjg'
//s_ctmx[67].ctbname = '加工费分摊单表'
//s_ctmx[67].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[67].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[67].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[67].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[67].delid = "billid"
//s_ctmx[67].fromstr = " from u_spt_wfjg"
//s_ctmx[67].linkstr = ""

s_ctmx[68].etbname = 'u_invoicemx'
s_ctmx[68].ctbname = '发票明细表'
s_ctmx[68].wherestr = " where u_invoice.flag = 1 and u_invoice.ctmint = 0 and u_invoice.invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[68].checkstr = " where u_invoice.flag = 0 and u_invoice.ctmint = 0 and u_invoice.invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[68].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[68].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[68].delid = "invoiceid"
s_ctmx[68].fromstr = " from u_invoice,u_invoicemx"
s_ctmx[68].linkstr = " and u_invoice.scid = u_invoicemx.scid and u_invoice.invoiceid = u_invoicemx.invoiceid"

s_ctmx[69].etbname = 'u_invoice'
s_ctmx[69].ctbname = '发票表'
s_ctmx[69].wherestr = " where flag = 1 and ctmint = 0 and invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[69].checkstr = " where flag = 0 and ctmint = 0 and invoicedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[69].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[69].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[69].delid = "invoiceid"
s_ctmx[69].fromstr = " from u_invoice"
s_ctmx[69].linkstr = ""

s_ctmx[70].etbname = 'u_givebackmx'
s_ctmx[70].ctbname = '返利单明细表'
s_ctmx[70].wherestr = " where u_giveback.flag = 1 and u_giveback.ctmint = 0 and u_giveback.givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[70].checkstr = " where u_giveback.flag = 0 and u_giveback.ctmint = 0 and u_giveback.givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[70].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[70].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[70].delid = "givebackid"
s_ctmx[70].fromstr = " from u_giveback,u_givebackmx"
s_ctmx[70].linkstr = " and u_giveback.scid = u_givebackmx.scid and u_giveback.givebackid = u_givebackmx.givebackid"

s_ctmx[71].etbname = 'u_giveback'
s_ctmx[71].ctbname = '返利单表'
s_ctmx[71].wherestr = " where flag = 1 and ctmint = 0 and givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[71].checkstr = " where flag = 0 and ctmint = 0 and givebackdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[71].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[71].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[71].delid = "givebackid"
s_ctmx[71].fromstr = " from u_giveback"
s_ctmx[71].linkstr = ""

//s_ctmx[72].etbname = 'u_reissuemx'
//s_ctmx[72].ctbname = '补件单明细表'
//s_ctmx[72].wherestr = " where u_reissue.flag = 1 and u_reissue.ctmint = 0 and u_reissue.reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[72].checkstr = " where u_reissue.flag = 0 and u_reissue.ctmint = 0 and u_reissue.reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[72].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[72].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[72].delid = "reissueid"
//s_ctmx[72].fromstr = " from u_reissue,u_reissuemx"
//s_ctmx[72].linkstr = " and u_reissue.scid = u_reissuemx.scid and u_reissue.reissueid = u_reissuemx.reissueid"
//
//s_ctmx[73].etbname = 'u_reissue'
//s_ctmx[73].ctbname = '补件单表'
//s_ctmx[73].wherestr = " where flag = 1 and ctmint = 0 and reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[73].checkstr = " where flag = 0 and ctmint = 0 and reissuedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
//s_ctmx[73].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[73].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
//s_ctmx[73].delid = "reissueid"
//s_ctmx[73].fromstr = " from u_reissue"
//s_ctmx[73].linkstr = ""

s_ctmx[74].etbname = 'u_buybillmx'
s_ctmx[74].ctbname = '支出单明细表'
s_ctmx[74].wherestr = " where u_buybill.ctmint = 0 and u_buybill.paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[74].checkstr = " where u_buybill.ctmint = 0 and u_buybill.paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[74].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[74].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[74].delid = "buybillid"
s_ctmx[74].fromstr = " from u_buybill,u_buybillmx"
s_ctmx[74].linkstr = " and u_buybill.buybillid = u_buybillmx.buybillid"

s_ctmx[75].etbname = 'u_buybill'
s_ctmx[75].ctbname = '支出单表'
s_ctmx[75].wherestr = " where ctmint = 0 and paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[75].checkstr = " where ctmint = 0 and paydate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[75].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[75].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[75].delid = "buybillid"
s_ctmx[75].fromstr = " from u_buybill"
s_ctmx[75].linkstr = ""

s_ctmx[76].etbname = 'u_salebillmx'
s_ctmx[76].ctbname = '支出单明细表'
s_ctmx[76].wherestr = " where u_salebill.ctmint = 0 and u_salebill.takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[76].checkstr = " where u_salebill.ctmint = 0 and u_salebill.takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[76].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[76].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[76].delid = "salebillid"
s_ctmx[76].fromstr = " from u_salebill,u_salebillmx"
s_ctmx[76].linkstr = " and u_salebill.salebillid = u_salebillmx.salebillid"

s_ctmx[77].etbname = 'u_salebill'
s_ctmx[77].ctbname = '支出单表'
s_ctmx[77].wherestr = " where ctmint = 0 and takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[77].checkstr = " where ctmint = 0 and takedate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[77].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[77].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[77].delid = "salebillid"
s_ctmx[77].fromstr = " from u_salebill"
s_ctmx[77].linkstr = ""

s_ctmx[78].etbname = 'u_inwaremx'
s_ctmx[78].ctbname = '进仓单明细表{采购,加工}'

IF sys_option_use_mstpay = 1 THEN
	s_ctmx[78].wherestr = " where ( billtype = 1 or billtype = 4 ) and u_inware.ctmint = 0 and u_inware.balcflag = 1 and u_inware.flag=1 and u_inware.secflag = 1 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[78].checkstr = " where ( billtype = 1 or billtype = 4 ) and (u_inware.balcflag = 0 or u_inware.flag = 0 or u_inware.secflag = 0 ) and u_inware.ctmint = 0 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
ELSE
	s_ctmx[78].wherestr = " where ( billtype = 1 or billtype = 4 ) and u_inware.ctmint = 0 and u_inware.balcflag = 1 and u_inware.flag=1 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[78].checkstr = " where ( billtype = 1 or billtype = 4 ) and (u_inware.balcflag = 0 or u_inware.flag = 0 ) and u_inware.ctmint = 0 and u_inware.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
END IF


s_ctmx[78].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[78].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[78].delid = "inwareid"
s_ctmx[78].fromstr = " from u_inwaremx,u_inware"
s_ctmx[78].linkstr = " and u_inwaremx.scid = u_inware.scid and u_inwaremx.inwareid = u_inware.inwareid"


s_ctmx[79].etbname = 'u_inware'
s_ctmx[79].ctbname = '进仓单表{采购,加工}'

IF sys_option_use_mstpay = 1 THEN
	s_ctmx[79].wherestr = " where ( billtype = 1 or billtype = 4 ) and ctmint = 0 and balcflag = 1 and flag=1 and secflag = 1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[79].checkstr = " where ( billtype = 1 or billtype = 4 ) and (balcflag = 0 or flag = 0 or secflag = 0) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
ELSE
	s_ctmx[79].wherestr = " where ( billtype = 1 or billtype = 4 ) and  ctmint = 0 and balcflag = 1 and flag=1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[79].checkstr = " where ( billtype = 1 or billtype = 4 ) and (balcflag = 0 or flag = 0) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
END IF
s_ctmx[79].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[79].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[79].delid = "inwareid"
s_ctmx[79].fromstr = " from u_inware"
s_ctmx[79].linkstr = ""

s_ctmx[80].etbname = 'u_outwaremx'
s_ctmx[80].ctbname = '出仓单明细表{领料}'
s_ctmx[80].wherestr = " where u_outware.billtype =3 and u_outware.ctmint = 0 and u_outware.balcflag = 1 and u_outware.flag = 1 and u_outware.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[80].checkstr = " where u_outware.billtype =3 and (u_outware.balcflag = 0 or u_outware.flag = 0) and u_outware.ctmint = 0 and u_outware.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[80].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[80].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[80].delid = "outwareid"
s_ctmx[80].fromstr = " from u_outwaremx,u_outware"
s_ctmx[80].linkstr = " and u_outwaremx.scid = u_outware.scid and u_outwaremx.outwareid = u_outware.outwareid"

s_ctmx[81].etbname = 'u_outware'
s_ctmx[81].ctbname = '出仓单表{领料}'
s_ctmx[81].wherestr = " where billtype =3 and ctmint = 0 and balcflag = 1 and flag = 1 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[81].checkstr = " where billtype =3 and (balcflag = 0 or flag = 0 ) and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[81].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[81].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[81].delid = "outwareid"
s_ctmx[81].fromstr = " from u_outware"
s_ctmx[81].linkstr = ""



s_ctmx[82].etbname = 'ow_wfjgmx_out'
s_ctmx[82].ctbname = '外协出仓单明细表'
s_ctmx[82].wherestr = " where ow_wfjg_out.ctmint = 0 and ow_wfjg_out.balcflag = 1 and ow_wfjg_out.flag = 1 and ow_wfjg_out.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[82].checkstr = " where (ow_wfjg_out.flag = 0 or ow_wfjg_out.balcflag = 0 ) and ow_wfjg_out.ctmint = 0 and ow_wfjg_out.outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[82].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[82].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[82].delid = "outwareid"
s_ctmx[82].fromstr = " from ow_wfjgmx_out,ow_wfjg_out"
s_ctmx[82].linkstr = " and ow_wfjgmx_out.scid = ow_wfjg_out.scid and ow_wfjgmx_out.outwareid = ow_wfjg_out.outwareid"

s_ctmx[83].etbname = 'ow_wfjg_out'
s_ctmx[83].ctbname = '外协出仓单表'
s_ctmx[83].wherestr = " where ctmint = 0 and balcflag = 1 and flag = 1 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[83].checkstr = " where (flag = 0 or balcflag=0 ) and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[83].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[83].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[83].delid = "outwareid"
s_ctmx[83].fromstr = " from ow_wfjg_out"
s_ctmx[83].linkstr = ""

s_ctmx[84].etbname = 'ow_wfjgmx_in_aft'
s_ctmx[84].ctbname = '外协进仓单(收货)明细表'
IF sys_option_use_mstpay = 1 THEN
	s_ctmx[84].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.secflag = 1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[84].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.secflag = 0 or ow_wfjg_in.balcflag= 0 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
ELSE
	s_ctmx[84].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[84].checkstr = " where (ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag= 0) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
END IF
s_ctmx[84].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[84].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[84].delid = "inwareid"
s_ctmx[84].fromstr = " from ow_wfjgmx_in_aft,ow_wfjg_in"
s_ctmx[84].linkstr = " and ow_wfjgmx_in_aft.scid = ow_wfjg_in.scid and ow_wfjgmx_in_aft.inwareid = ow_wfjg_in.inwareid"

s_ctmx[85].etbname = 'ow_wfjgmx_in_bef'
s_ctmx[85].ctbname = '外协进仓单(库存)明细表'
IF sys_option_use_mstpay = 1 THEN
	s_ctmx[85].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.secflag = 1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[85].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag=1 or ow_wfjg_in.secflag = 0 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
ELSE
	s_ctmx[85].wherestr = " where ow_wfjg_in.ctmint = 0 and ow_wfjg_in.balcflag=1 and ow_wfjg_in.flag=1 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[85].checkstr = " where ( ow_wfjg_in.flag = 0 or ow_wfjg_in.balcflag=1 ) and ow_wfjg_in.ctmint = 0 and ow_wfjg_in.indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
END IF
s_ctmx[85].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[85].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[85].delid = "inwareid"
s_ctmx[85].fromstr = " from ow_wfjgmx_in_bef,ow_wfjg_in"
s_ctmx[85].linkstr = " and ow_wfjgmx_in_bef.scid = ow_wfjg_in.scid and ow_wfjgmx_in_bef.inwareid = ow_wfjg_in.inwareid"


s_ctmx[86].etbname = 'ow_wfjg_in'
s_ctmx[86].ctbname = '外协进仓单表'
IF sys_option_use_mstpay = 1 THEN
	s_ctmx[86].wherestr = " where ctmint = 0 and balcflag = 1 and flag=1 and secflag = 1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[86].checkstr = " where ( flag = 0 or secflag = 0 or balcflag=0 ) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
ELSE
	s_ctmx[86].wherestr = " where ctmint = 0 and balcflag = 1 and flag=1 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
	s_ctmx[86].checkstr = " where ( flag = 0   or balcflag=0 ) and ctmint = 0 and indate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
END IF
s_ctmx[86].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[86].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[86].delid = "inwareid"
s_ctmx[86].fromstr = " from ow_wfjg_in"
s_ctmx[86].linkstr = ""

s_ctmx[87].etbname = 'ow_wfjgbalc'
s_ctmx[87].ctbname = '外协结存表'
s_ctmx[87].wherestr = " where balcdate<='" + String(ll_datetime,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[87].checkstr = " where balcdate<='" + String(ll_datetime,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[87].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[87].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[87].delid = "mtrlid"
s_ctmx[87].fromstr = " from ow_wfjgbalc"
s_ctmx[87].linkstr = ""

s_ctmx[88].etbname = 'u_warepdb_billmx'
s_ctmx[88].ctbname = '盘点单明细表'
s_ctmx[88].wherestr = " where u_warepdb_bill.flag = 1 and u_warepdb_bill.ctmint = 0 and u_warepdb_bill.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[88].checkstr = " where u_warepdb_bill.flag = 0 and u_warepdb_bill.ctmint = 0 and u_warepdb_bill.billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[88].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[88].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[88].delid = "billid"
s_ctmx[88].fromstr = " from u_warepdb_bill,u_warepdb_billmx"
s_ctmx[88].linkstr = " and u_warepdb_bill.scid = u_warepdb_billmx.scid and u_warepdb_bill.billid = u_warepdb_billmx.billid"

s_ctmx[89].etbname = 'u_warepdb_bill'
s_ctmx[89].ctbname = '盘点单表'
s_ctmx[89].wherestr = " where flag = 1 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[89].checkstr = " where flag = 0 and ctmint = 0 and billdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[89].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[89].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[89].delid = "billid"
s_ctmx[89].fromstr = " from u_warepdb_bill"
s_ctmx[89].linkstr = ""


s_ctmx[90].etbname = 'u_income_expenses'
s_ctmx[90].ctbname = '其他收入支出单'
s_ctmx[90].wherestr = " where flag = 1 and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[90].checkstr = " where flag = 0 and ctmint = 0 and outdate<='" + String(arg_ctdt,'yyyy-mm-dd hh:mm') + "'"
s_ctmx[90].delstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[90].ctstr = " where ctmint >= " + String(arg_bg_int) + " and ctmint <= " + String(arg_ed_int)+" "
s_ctmx[90].delid = "billid"
s_ctmx[90].fromstr = " from u_income_expenses"
s_ctmx[90].linkstr = ""



RETURN 1




end function