Navigation

    Odoo 中文社区

    • Register
    • Login
    • Search
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Odoo中文社区可以通过以下两个域名访问:shine-it.net , odoo.net.cn

    由于系统升迁的原因,本论坛部分较早期的内容存在格式和链接损坏失效的问题,并非本论坛系统本身的缺陷,望谅解

    本社区没有维护任何QQ群讨论组,任何与本社区同名的QQ群讨论组的言论与本社区无关!

    开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

    如果您登录系统碰到问题,请在微信公众号留言:

    建立trigger解决odoo 11 安装应用后web页面为空的问题

    Odoo 安装指南
    2
    3
    3630
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • W
      wenrongjing last edited by digitalsatori

      CREATE OR REPLACE FUNCTION fix_mimetype
      (
      )
      RETURNS TRIGGER AS $$
              BEGIN
              	IF  NEW.mimetype = 'text/plain'
              	    AND NEW.datas_fname LIKE '%.js'
              	THEN
              		UPDATE
              			ir_attachment
              		SET
              			mimetype = 'text/javascript'
              		WHERE
              			id = NEW.id;
              	END IF;
              	
              	RETURN NULL;
              END;
      
      $$language plpgsql;
      
      CREATE TRIGGER mimetype_changed AFTER INSERT OR UPDATE
      ON ir_attachment FOR EACH ROW EXECUTE PROCEDURE fix_mimetype();
      
      digitalsatori 1 Reply Last reply Reply Quote 0
      • digitalsatori
        digitalsatori 管理员 @wenrongjing last edited by

        @wenrongjing 感谢分享,帮你把代码用```包了一下

        W 1 Reply Last reply Reply Quote 0
        • W
          wenrongjing @digitalsatori last edited by

          @digitalsatori thanks a lot

          1 Reply Last reply Reply Quote 0
          • First post
            Last post