123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118 |
- package service
- import (
- "encoding/json"
- "fmt"
- "kpt.xdmy/apiserver/config"
- "time"
- "github.com/pkg/errors"
- log "github.com/sirupsen/logrus"
- _ "github.com/go-sql-driver/mysql"
- "kpt.xdmy/apiserver/model"
- "kpt.xdmy/apiserver/model/http"
- )
- var supplierChan chan error
- // 定时 从sap拉取供应商数据
- // 预留参数;时间、编码,提供给手动调用接口
- func (s *Service) SapSupplier(t time.Time, code string, pastureid int) {
- supplierChan = make(chan error, 10)
- r := new(http.SupplierReq)
- rp := new(http.SupplierResp)
- var e error
- r.Dest.DestID = "EQMAN"
- r.Dest.BussTp = "MM004"
- //r.Dest.Url = "http://192.168.61.117/SAPP0/Common/MM004/QuerySupplier/"
- r.Dest.Url = fmt.Sprintf("%s/Common/MM004/QuerySupplier/", config.Conf.Http.Routing)
- if t.IsZero() {
- t = time.Now()
- }
- r.Data.BudatB = t.Format("20060102")
- r.Data.BudatE = t.Format("20060102")
- //r.Data.BudatB = "20221004"
- //r.Data.BudatE = "20221022"
- //r.Data.CompanyCode = "1004"
- r.Data.CompanyCode = code
- r.Data.Types = []http.ZSORT{{Type: "设备"}, {Type: "服务类"}, {Type: "备品备件类"}, {Type: "工程类"}, {Type: "其他类"}}
- rbyte, _ := json.Marshal(r)
- fmt.Println(string(rbyte))
- if e = s.SyncSap(r, rp, rbyte); e == nil {
- if rp.Dest.Status == "S" {
- log.Infof("sap supplier success : mlen=%d", len(rp.Data.Master))
- } else {
- e = errors.Errorf("sap supplier fail: %s", rp.Dest.MessText)
- }
- } else {
- e = errors.Wrap(e, "sap supplier error:")
- }
- var update error
- var count int
- for _, v := range rp.Data.Master {
- update = nil
- s.updateProvider(&v)
- update = <-supplierChan
- if update != nil {
- log.Error(update)
- count++
- l := model.SapDetailLog{Name: "supplier", Code: v.Code, ErrorText: update.Error()}
- if e := s.d.DB.Create(&l); e != nil {
- log.Errorf("add sapdetail log: %v", e)
- }
- }
- // break
- }
- if e != nil {
- log.Error(e)
- } else if update != nil {
- e = errors.Errorf("supplier update fail sum:%d", count)
- } else {
- log.Infof("supplier update success sum:%d", len(rp.Data.Master)-count)
- }
- s.AddSapLog(r, e)
- return
- }
- // 更新供应商
- func (s *Service) updateProvider(sup *http.Supplier) {
- pv := new(model.Provider)
- if len(sup.UpDate) == 8 {
- sup.UpDate = sup.UpDate[:4] + "-" + sup.UpDate[4:6] + "-" + sup.UpDate[6:]
- }
- if len(sup.UpTime) == 6 {
- sup.UpTime = sup.UpTime[:2] + ":" + sup.UpTime[2:4] + ":" + sup.UpTime[4:]
- }
- if sup.UpTime != "" {
- sup.UpDate = sup.UpDate + " " + sup.UpTime
- }
- if t, e := time.Parse("2006-01-02 15:04:05", sup.UpDate); e != nil {
- supplierChan <- errors.Errorf("time parse : %s, %s", sup.UpDate)
- } else {
- pv.ModifyTime = t
- }
- pv.ProviderIntro = sup.Name
- pv.ProviderName = sup.ShortName
- pv.ProviderNumber = sup.Code
- pv.CompanyCode = sup.CompanyCode
- pv.SortName = sup.ZSORT
- pv.Linkman = sup.Contact
- pv.Email = sup.Mail
- pv.Telphone = sup.Phone
- pv.SapCode = sup.Code
- if sup.Dflag == "" {
- pv.Enable = 1
- }
- fmt.Println(pv)
- if e := s.d.DB.Where(model.Provider{SapCode: sup.Code}).Assign(pv).FirstOrCreate(&pv).Error; e != nil {
- supplierChan <- errors.Wrapf(e, "provider update failed:code =%s", sup.Code)
- } else {
- log.Infof("provider update succeeded:%s,%s,%s", sup.Code, sup.ShortName, sup.CompanyCode)
- supplierChan <- nil
- }
- }
|