From e53fdfdd78538a21cddd45b9d3faa1a7e9e37a0a Mon Sep 17 00:00:00 2001
From: 19626 <1962676589@qq.com>
Date: 星期五, 21 七月 2023 13:36:24 +0800
Subject: [PATCH] 修改附件

---
 force-app/main/default/pages/AssetQR.page |   12 +++++-------
 1 files changed, 5 insertions(+), 7 deletions(-)

diff --git a/force-app/main/default/pages/AssetQR.page b/force-app/main/default/pages/AssetQR.page
index b5d3a21..ca6c362 100644
--- a/force-app/main/default/pages/AssetQR.page
+++ b/force-app/main/default/pages/AssetQR.page
@@ -10,9 +10,7 @@
             var img = div.getElementsByTagName("img");
             var src = img[0].src;
             src = src.substring(22, src.length);
-
             sforce.connection.sessionId = '{!GETSESSIONID()}';
-
             // var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Asset.Id}\' and name = \'QRCode\'");
             var record = sforce.connection.query("SELECT ContentDocumentId from ContentDocumentLink where LinkedEntityId =\'{!Asset.Id}\'");
             var records;
@@ -46,7 +44,7 @@
 
                 var es = new sforce.SObject("Asset");
                 es.Id = "{!Asset.Id}";
-                es.QRId__c = result[0].ContentDocumentId;
+                es.QRId__c = versionResult[0].id;
                 es.Fixture_QRCode_Text__c = "{!Asset.Fixture_QRCode__c}";
                 result = sforce.connection.update([es]);
             } else if ("{!Asset.QRId__c}" == null || "{!Asset.QRId__c}" == '' || "{!Asset.Fixture_QRCode__c}" != "{!Asset.Fixture_QRCode_Text__c}"){
@@ -59,9 +57,9 @@
                 // var result = sforce.connection.update([atta]);
 
 
-                var result = sforce.connection.query("SELECT Id from ContentDocumentLink where ContentDocumentId =" + record[0].Id);
-                var version = sforce.connection.query("SELECT Id from ContentVersion where ContentDocumentId =" + record[0].Id);
-                var versions = version.getArray("versions");
+                var result = sforce.connection.query("SELECT Id from ContentDocumentLink where ContentDocumentId = \'" + records[0].ContentDocumentId + "\'");
+                var version = sforce.connection.query("SELECT Id from ContentVersion where ContentDocumentId = \'" + records[0].ContentDocumentId  + "\'");
+                var versions = version.getArray("records");
                 var atta = new sforce.SObject("ContentVersion");
                 atta.VersionData = src;
                 atta.Id = versions[0].Id;
@@ -69,7 +67,7 @@
                 records = result.getArray("records");
                 var es = new sforce.SObject("Asset");
                 es.Id = "{!Asset.Id}";
-                es.QRId__c = records[0].Id;
+                es.QRId__c = atta.Id;
                 es.Fixture_QRCode_Text__c = "{!Asset.Fixture_QRCode__c}";
                 result = sforce.connection.update([es]);
                 // TODO Name澶夈倧銈嬪彲鑳芥�с亗銈娿�乽psert銇仐銇俱仚

--
Gitblit v1.9.1