接口日志不同步处理

lazhen

2024-08-23 a4fc5084c9e83b1457af33bf6876faa9cfb8321e

接口日志不同步处理

 _Main/BL/EDI/Broker_IL_InterfaceLogInfoMiddlesBroker.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,68 @@
Quintiq file version 2.0
#parent: #root
EDIBroker IL_InterfaceLogInfoMiddlesBroker
{
  MDSDefinition: InterfaceDataset
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination DestinationInterfaceLogInfoMiddles
  {
    EDIMLTable InterfaceLoginfoMiddle
    {
      PrimaryKeyColumns: ID
      TargetType: InterfaceLoginfoMiddle
      TypeIndex: InterfaceLoginfoMiddleTypeIndex
      EDIMLColumn FinishTime { Attribute: FinishTime ValueType: DateTime }
      EDIMLColumn ID { Attribute: ID ValueType: Number }
      EDIMLColumn Name { Attribute: Name ValueType: String }
      EDIMLColumn Response { Attribute: Response ValueType: String }
    }
  }
  EDIODBCLink.Source SourceInterfaceLogInfoMiddles
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.vwed'
    EDIODBCLinkTable InterfaceLoginfoMiddle
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      PrimaryKeyColumns: ID
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn FinishTime
      {
        OthersMayUpdateColumn: true
        ValueType: DateTime
      }
      EDIODBCLinkColumn ID
      {
        OthersMayUpdateColumn: true
        ValueType: Number
      }
      EDIODBCLinkColumn Name
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn Response
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
    }
  }
  EDITransformation.Transformation TransformationInterfaceLogInfoMiddles
  {
    EDITableTransformation
    {
      InputTable: InterfaceLoginfoMiddle
      OutputTable: InterfaceLoginfoMiddle
      EDIColumnMatch { InputColumn: FinishTime OutputColumn: FinishTime }
      EDIColumnMatch { InputColumn: ID OutputColumn: ID }
      EDIColumnMatch { InputColumn: Name OutputColumn: Name }
      EDIColumnMatch { InputColumn: Response OutputColumn: Response }
    }
  }
}

 _Main/BL/Relations/Relation_InterfaceLoginfoMiddle_InterfaceDataset_InterfaceDataset_InterfaceL.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation InterfaceLoginfoMiddle_InterfaceDataset_InterfaceDataset_InterfaceLoginfoMiddle
{
  #keys: '1[415136.0.1035642038]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide InterfaceDataset
  {
    #keys: '3[415136.0.1035642040][415136.0.1035642039][415136.0.1035642041]'
    Cardinality: '0to1'
    ObjectDefinition: InterfaceLoginfoMiddle
    OwningSide: 'Reference'
  }
  RelationSide.RightSide InterfaceLoginfoMiddle
  {
    #keys: '3[415136.0.1035642043][415136.0.1035642042][415136.0.1035642044]'
    Cardinality: '1toN'
    ObjectDefinition: InterfaceDataset
    OwningSide: 'Owned'
  }
}

 _Main/BL/Type_CustomerDemandPPAIDS/StaticMethod_GenerateData.qbl

@@ -22,15 +22,15 @@
      interfaceDataset.CustomerDemandPPAIDS( relflush );
    }
    nowdate                := DateTime::ActualTime();
    loginfo                := interfaceDataset.InterfaceLoginfo( relnew, ExecuteUser := executor
                                                                 , Name := Translations::InterfaceDataset_CustomerDemandPPAIDS_Name()
                                                                 , InterfaceDateTime := nowdate
                                                                 , Message := '客户需求（PPA+IDS）数据推送'
                                                                 , IsShow := false
                                                                 , Last := true
                                                                 , ReturnSuccess := true
                                                                 , ReturnMsg := 'Success'
                                                                 , Success := true
    loginfo                := interfaceDataset.InterfaceLoginfo( relnew, ExecuteUser         := executor
                                                                 , Name                      := Translations::InterfaceDataset_CustomerDemandPPAIDS_Name()
                                                                 , InterfaceDateTime         := nowdate
                                                                 , Message                   := '客户需求（PPA+IDS）数据推送'
                                                                 , Last                      := true
                                                                 , IsShow                    := false
                                                                 , ReturnSuccess             := true
                                                                 , ReturnMsg                 := 'Success'
                                                                 , Success                   := true
                                                                  );
    traverse( macroplan, SalesDemand.astype( Forecast ), forecast ){
      cd                  :=interfaceDataset.CustomerDemandPPAIDS( relnew, Product           := forecast.ProductID()

 _Main/BL/Type_InterfaceLoginfo/DefaultValue_IsShow.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_InterfaceLoginfo/StaticMethod_SyncMiddle.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod SyncMiddle (
  InterfaceDataset owner
)
{
  TextBody:
  [*
    // ç”„兰鸽 Aug-23-2024 (created)
    owner.IL_InterfaceLogInfoMiddlesBroker().Execute();
    // æ¸…空临时数据库
    owner.IL_InterfaceLogInfoMiddlesBroker().Source().FlatQuery( "truncate table A_InterfaceLogInfoMiddle" );
    traverse( owner, InterfaceLoginfoMiddle, middle ){
      loginfo := selectobject( owner, InterfaceLoginfo, loginfo, loginfo.Name() = middle.Name() and loginfo.IsShow() = false and loginfo.Last() = true );
      loginfo.FinishTime( middle.FinishTime() );
      loginfo.Response( middle.Response() );
      loginfo.IsShow( false );
      middle.Delete();
    }
  *]
}

 _Main/BL/Type_InterfaceLoginfoMiddle/Attribute_FinishTime.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute FinishTime
{
  #keys: '3[415136.0.1035642031][415136.0.1035642030][415136.0.1035642032]'
  Description: '完成时间'
  ValueType: DateTime
}

 _Main/BL/Type_InterfaceLoginfoMiddle/Attribute_ID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ID
{
  #keys: '3[415136.0.1035643101][415136.0.1035643100][415136.0.1035643102]'
  IsReadOnly: true
  ValueType: Number
}

 _Main/BL/Type_InterfaceLoginfoMiddle/Attribute_Name.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute Name
{
  #keys: '3[415136.0.1035642019][415136.0.1035642018][415136.0.1035642020]'
  Description: '接口名称'
  ValueType: String
}

 _Main/BL/Type_InterfaceLoginfoMiddle/Attribute_Response.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute Response
{
  #keys: '3[415136.0.1035642035][415136.0.1035642034][415136.0.1035642036]'
  Description: '接口返回数据'
  ValueType: String
}

 _Main/BL/Type_InterfaceLoginfoMiddle/DefaultValue_Name.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,6 @@
Quintiq file version 2.0
#parent: #root
DefaultValue
{
  TargetAttribute: Name
}

 _Main/BL/Type_InterfaceLoginfoMiddle/DefaultValue_Response.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,6 @@
Quintiq file version 2.0
#parent: #root
DefaultValue
{
  TargetAttribute: Response
}

 _Main/BL/Type_InterfaceLoginfoMiddle/TypeIndex_InterfaceLoginfoMiddleTypeIndex.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
Quintiq file version 2.0
#parent: #root
TypeIndex InterfaceLoginfoMiddleTypeIndex
{
  Attributes:
  [
    TypeIndexAttribute
    {
      ModelElement: ID
    }
  ]
}

 _Main/BL/Type_InterfaceLoginfoMiddle/_ROOT_Type_InterfaceLoginfoMiddle.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type InterfaceLoginfoMiddle
{
  #keys: '5[415136.0.1035642012][415136.0.1035642010][0.0.0][415136.0.1035642011][415136.0.1035642013]'
  BaseType: Object
  Description: '接口日志中间临时表'
  StructuredName: 'InterfaceLoginfoMiddles'
}

 _Main/UI/MacroPlannerWebApp/Component_FormInterfaceLoginfo/Component_ListInterfaceLoginfo.def

@@ -11,7 +11,8 @@
      BaseType: 'WebDataExtractor'
      Properties:
      [
        DataType: 'external[InterfaceDataset]'
        DataType: 'InterfaceDataset'
        FixedFilter: 'object.IsShow()'
        Source: 'InterfaceDataset'
        Taborder: 0
        Transformation: 'InterfaceLoginfo'