if(new.d_stage!="Won") and (new.d_stage!="lost") THEN
insert into sales_activity(companyname, adminemailid, dateandtime, cont_id, org_id, created_by, created_type, type, subtype, descr, d_name, d_amount, d_month, d_commission_percentage, d_commission_amount, d_descr, d_stage, d_date, d_closedate, d_by) values (companyname1, adminemailid1, new.d_c_datetime, new.cont_id, org_id1, new.d_c_by, new.d_c_type, "deal", "Pending deal", new.d_deal_name, new.d_amount, new.d_month, new.d_commission_percentage, new.d_commission_amount, new.d_descr, new.d_stage, new.d_date, new.d_closedate, new.d_deal_by);
end if;


set companyname1 :=select sales_contact.companyname from sales_contact where sales_contact.cont_id=new.cont_id;
set adminemailid1 :=select sales_contact.adminemailid from sales_contact where sales_contact.cont_id=new.cont_id;
set org_id1 :=select sales_organization.org_id from sales_organization where sales_organization.cont_id=new.cont_id;