{"action":"closed","issue":{"url":"https://api.github.com/repos/kingofhawks/yycoin/issues/281","repository_url":"https://api.github.com/repos/kingofhawks/yycoin","labels_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/281/labels{/name}","comments_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/281/comments","events_url":"https://api.github.com/repos/kingofhawks/yycoin/issues/281/events","html_url":"https://github.com/kingofhawks/yycoin/issues/281","id":167767803,"number":281,"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":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":16,"created_at":"2016-07-27T04:29:33Z","updated_at":"2016-09-09T01:10:28Z","closed_at":"2016-09-09T01:10:28Z","body":"在10.10.10.99服务器的同步数据库(root,root)，建了两张表 t_center_olout,与  t_center_olbase,分别为线下订单的抬头与行项目，需要OA系统定时检查这两张表，根据olout表的不同状态位判断是否抓取数据在OA中生成相应类型的订单，具体判断条件如下：\r\n1.status=0  and pricestatus=1 and ibmostatus=1 and oano=\"\"同时满足这三个条件的订单被抓取生成OA订单\r\n2.type,stafferid,staffername,customerid,customername,description,emergency几个字段值直接取为oa的OUT表对应的字段值\r\noa的out 表中的outtime,podate取当前日期，total根据olfullid到表olbase中取对outid相同的行项目的，amount*price的合计\r\nindustryid,2,3几个字段根据stafferid到表oastaffer表取对应值\r\n\r\n3.OLOUT表中的express\\expresscompany\\expresspay分别对应oa表t_center_discription 中的shipping,transport1/transport2,expresspay,快递和货运要判断到写入哪个字段\r\nprovinceid\\cityid\\address\\receiver\\写入对应同名字段，telephone写入mobile\r\n\r\n4.olbase表中的字段写入OA的 base表中的对应同名字段，value取对应商品的amount*price\r\n\r\n永银周苏东 2016/7/27 10:06:07\r\n5.生成OA订单后，回写OA单号至olout与olbase表的OANO字段\r\n\r\n10:06:42\r\n永银周苏东 2016/7/27 10:06:42\r\n6.在生成OA订单时，把olfullid写入订单备注\r\n11:12:47\r\n永银周苏东 2016/7/27 11:12:47\r\n有不清楚的随时和我确认，这个比较急，争取这两天搞定，过会再写个退库单的逻辑给你\r\n12:27:32\r\n不在电脑前？没关系，QQ手机版让你随时随地接收消息！立刻安装\r\n\r\nsmartman 2016/7/27 12:28:27\r\n你帮忙把这两张表的数据导一份给我呢，我本地要建立一个开发环境\r\n"}}
{"actor":{"display_login":"kingofhawks"}}