truncate table david_account;

/* 商户资料更新时更新终端 */

DELIMITER |

CREATE TRIGGER

    bankChange

AFTER UPDATE

    ON david_bank

FOR EACH ROW

    BEGIN

        /*

        declare termC int;

        set termC = (select count(*) as nums from david_terminal where mer_id=new.mer_id);

        if termC<=1 then

            update david_terminal set

                main_tel = new.main_tel,

                sale_type_id = new.sale_type_id

            where mer_id=new.mer_id;

        end if;

        */

        update david_account set

            bank_name = new.name

        where bank_id=new.cut_no;

        if(new.channel_no = '') then

            insert into rpt_charge set `month`=new.`month`,channel_no = new.channel_no,term_no=new.term_no;

        elseif(new.channel_no = '') then

            insert into rpt_charge set channel_no = new.channel_no,term_no=new.term_no;

        end if;

    END

|

DELIMITER ;