2.0系统使用操作-倍全开发系统配置

1、在Order创建一新表ecm_order_money(10)unsignedNOTNULL(10)unsignedDEFAULT(10)unsignedDEFAULT(10)unsignedDEFAULT11在Order创建一新表ecm_order_money(10)unsignedNOTNULL(10)unsignedDEFAULT(10)unsignedDEFAULT(10)unsignedDEFAULT11为订单总价提 1年-月-31(10)unsignedDEFAULTtype(1)unsignedDEFAULTamountfloat(10,2)unsignedDEFAULT(10)u

2、nsignedDEFAULTus(1)unsignedNOTPRIMARYKEY号selectcount(*)count fromecm_memberwhereparentidin( uin) selectcount(*)count from(10)unsignedDEFAULTtype(1)unsignedDEFAULTamountfloat(10,2)unsignedDEFAULT(10)unsignedDEFAULTus(1)unsignedNOTPRIMARYKEY号selectcount(*)count fromecm_memberwhereparentidin( uin) sele

3、ctcount(*)count fromecm_orderwherebuyer_idin(selectuser_idecm_memberwhereparentidinuin) andus=40andand selectcount(*)count from(SELECT*from(SELECT*fromecm_orderbuyer_idin(selectuser_idfromecm_memberwhereparentidinuin)id andorder_amount首笔订单提成条件 us=40 andBYfinished_timeasc)astgroupbybuyer_id)asfwhere

4、selectcount(*)count fromecm_memberwhereparentiduin) selectcount(*)count fromecm_orderwherebuyer_idin(selectuser_idecm_memberwhereparentidinuin) andus=40andand selectcount(*)count from(SELECT*from(SELECT*fromecm_orderbuyer_idin(selectuser_idfromecm_memberwhereparentidinuin)id andorder_amount首笔订单提成条件

5、us=40 andBYfinished_timeasc)astgroupbybuyer_id)asfselectcount(*)count fromecm_memberwhereparentiduin) selectcount(*)count fromecm_orderwherebuyer_idin(selectuser_idecm_memberwhereparentidinuin)andus=40andselectcount(*)count fromecm_memberwhereparentiduin) selectcount(*)count fromecm_orderwherebuyer_

6、idin(selectuser_idecm_memberwhereparentidinuin)andus=40andand date_format(from_unixtime(finished_time),%Y-selectcount(*)count from(SELECT*from(SELECT*fromecm_orderbuyer_idin(selectuser_idfromecm_memberwhereparentidinuin)id andorder_amount首笔订单提成条件 us=40 andBYfinished_timeasc)astgroupbybuyer_id)asfselect*fromecm_member whereparentidinuin)(now()orderby(2015-01-01)andselect * from ecm_orderwherebuyer_idin(selectuser_idfrom w