19626
2023-07-21 e53fdfdd78538a21cddd45b9d3faa1a7e9e37a0a
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変わる可能性あり、upsertにします