{"action":"opened","issue":{"url":"https://api.github.com/repos/kingofhawks/yycoin/issues/146","labels_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/146/comments","events_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/146/events","html_url":"https://github.com/kingofhawks/yycoin/issues/146","id":123193706,"number":146,"title":"自动发送宁波银行发货信息邮件功能","user":{"login":"kingofhawks","id":45868,"avatar_url":"https://avatars.githubusercontent.com/u/45868?v=3","gravatar_id":"","url":"https://api.github.com/users/kingofhawks","html_url":"https://github.com/kingofhawks","followers_url":"https://api.github.com/users/kingofhawks/followers","following_url":"https://api.github.com/users/kingofhawks/following{/other_user}","gists_url":"https://api.github.com/users/kingofhawks/gists{/gist_id}","starred_url":"https://api.github.com/users/kingofhawks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kingofhawks/subscriptions","organizations_url":"https://api.github.com/users/kingofhawks/orgs","repos_url":"https://api.github.com/users/kingofhawks/repos","events_url":"https://api.github.com/users/kingofhawks/events{/privacy}","received_events_url":"https://api.github.com/users/kingofhawks/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-21T01:02:25Z","updated_at":"2015-12-21T01:02:25Z","closed_at":null,"body":"\r\n一．\t概述\r\n根据宁波银行的发货要求，在发货前和发货后分别将发货信息发送至银行总部，因此需要在17：00与23：00分别将发货信息明细发送至相关邮箱。\r\n\r\n二．\t功能\r\n1.\t每天23点，统计当天截止时间t_center_package表中邮件发送标识为空，且status字段值为2的，且客户名称为 宁波银行XXXX    的CK单\r\n2.\t在out_import表中增加一列“宁波银行订单编号”\r\n3.\t根据符合条件的CK单号到t_center_package_item表中找到具体的CK单对应的商品明细，再根据outid到表t_center_out_import表中找对应的OANO字段值相同的行\r\n4.\t将统计结果明细转为excel格式的附件分送，发送后，将邮件发送标识置为1\r\n5.\t具体邮件附件字段如下：\r\n字段名\t取值逻辑\t备注\r\n供应商id\t2015120215260025\t固定内容\r\n供应商名称\t永银文化\t固定内容\r\n机构id\t取out_import表中对应的“联行网点号”\t\r\n机构名称\t取out_import表中对应的“网点名称”\t\r\n发货单号（供应商提供）\t取ck单对应的快递单号\t\r\n订单编号\t到out_import中对应的OANO行对应的“宁波银行订单编号”字段值\t\r\n快递单号\t取ck单对应的快递单号\t\r\n产品id\t取out_import表中对应的银行产品编码\t\r\n产品名称\t取out_import表中对应的银行产品名称\t\r\n产品类型\t工艺金\t\r\n产品数量\t取CK单中商品的数量\t\r\n\r\n\r\n\r\n     5.每天17：00点，按以上逻辑发一份状态为t_center_package表中邮件发送标识为空，且客户名称为 宁波银行XXXX    的CK单对应的数据，\r\n\r\n邮件统一发送至：renxiaoyu@nbcb.cn\r\n\r\n测试系统邮件先发至  zhousudong@yycoin.com,时间间隔5分钟\r\n"}}