修改附件

19626

2023-07-21 e53fdfdd78538a21cddd45b9d3faa1a7e9e37a0a

 force-app/main/default/pages/ConsumApplyQR.page

@@ -16,14 +16,12 @@
            // var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Consum_Apply__c.Id}\' and name = \'QRCode-{!Consum_Apply__c.Name}\'");
            var record = sforce.connection.query("select ContentDocumentId from ContentDocumentLink where LinkedEntityId = \'{!Consum_Apply__c.Id}\'");
            // 不存在qr文件时，新生成一个，并连到申请单上
            console.log(record.size);
            if(record.size > 0){
                var records = record.getArray("records");
                var idList = records.map(obj => "'" + obj.ContentDocumentId + "'").join(",");
                record = sforce.connection.query("select Id from ContentDocument where Id in (" + idList + ") and Title = \'QRCode-{!Consum_Apply__c.Name}\'");
                console.log("select Id from ContentDocument where Id in (" + idList + ") and Title = \'QRCode-{!Consum_Apply__c.Name}\'");
            }
            console.log(record.size);
            if (record.size == 0) {
                // var atta = new sforce.SObject("Attachment");
                // atta.Name = "QRCode-{!Consum_Apply__c.Name}";
@@ -37,11 +35,8 @@
                version.ContentLocation = "s";
                version.PathOnClient = "QRCode-{!Consum_Apply__c.Name}.jpg";
                var result = sforce.connection.create([version]);
                console.log(result[0].id);
                version = sforce.connection.query("select ContentDocumentId from ContentVersion where Id = \'" + result[0].id + "\'");
                console.log(version);
                version = sforce.connection.query("select Id,ContentDocumentId from ContentVersion where Id = \'" + result[0].id + "\'");
                version = version.getArray("records"); 
                console.log(version);
                var link = new sforce.SObject("ContentDocumentLink");
                link.LinkedEntityId = "{!Consum_Apply__c.Id}";
                link.ContentDocumentId = version[0].ContentDocumentId;
@@ -51,16 +46,19 @@

                var es = new sforce.SObject("Consum_Apply__c");
                es.Id = "{!Consum_Apply__c.Id}";
                es.QRId__c = version[0].ContentDocumentId;
                es.QRId__c = version[0].Id;
                result = sforce.connection.update([es]);
            }
            else {
                var records = record.getArray("records");
                var version = new sforce.SObject("ContentVersion");
                version = sforce.connection.query("select Id,ContentDocumentId from ContentVersion where ContentDocumentId = \'" + records[0].Id + "\'");
                version = version.getArray("records"); 
                // 存在qr时，绑到申请单上
                if(records[0].Id != "{!Consum_Apply__c.QRId__c}"){
                if(version[0].Id != "{!Consum_Apply__c.QRId__c}"){
                    var es = new sforce.SObject("Consum_Apply__c");
                    es.Id = "{!Consum_Apply__c.Id}";
                    es.QRId__c = records[0].Id;
                    es.QRId__c = version[0].Id;
                    result = sforce.connection.update([es]);
                }
            }