修改附件7.17

19626

2023-07-17 254ea442ff0e0a7a97e9f481e9f127a782cba840

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

@@ -53,18 +53,39 @@
            src = srcNew.substring(22, srcNew.length);
            sforce.connection.sessionId = '{!GETSESSIONID()}';

            var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Consum_Apply__c.Id}\' and name = \'BRCode-{!Consum_Apply__c.Name_No__c}\'");
            // var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Consum_Apply__c.Id}\' and name = \'BRCode-{!Consum_Apply__c.Name_No__c}\'");

            var record = sforce.connection.query("select Id,ContentDocumentId from ContentDocumentLink where LinkedEntityId = \'{!Consum_Apply__c.Id}\'");
            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 = \'BRCode-{!Consum_Apply__c.Name_No__c}\'");
            }
            // 既にあれば無視
            if (record.size == 0) {
                var atta = new sforce.SObject("Attachment");
                atta.Name = "BRCode-{!Consum_Apply__c.Name_No__c}";
                atta.ParentId = "{!Consum_Apply__c.Id}";
                atta.Body = src;
                var result = sforce.connection.create([atta]);
                // var atta = new sforce.SObject("Attachment");
                // atta.Name = "BRCode-{!Consum_Apply__c.Name_No__c}";
                // atta.ParentId = "{!Consum_Apply__c.Id}";
                // atta.Body = src;
                // var result = sforce.connection.create([atta]);
                var version = new sforce.SObject("ContentVersion");
                version.VersionData = src;
                version.Title = "BRCode-{!Consum_Apply__c.Name_No__c}";
                version.ContentLocation = 's';
                version.PathOnClient= "BRCode-{!Consum_Apply__c.Name_No__c}.jpg";
                var versionResult = sforce.connection.create([version]);
                record = sforce.connection.query("SELECT ContentDocumentId FROM ContentVersion WHERE Id =\'" + versionResult[0].id + "\'");
                var records = record.getArray("records");
                var link = new sforce.SObject("ContentDocumentLink");
                link.ContentDocumentId = records[0].ContentDocumentId;
                link.LinkedEntityId = "{!Consum_Apply__c.Id}";
                link.ShareType = 'I';
                link.Visibility = 'AllUsers';
                var result = sforce.connection.create([link]);

                var es = new sforce.SObject("Consum_Apply__c");
                es.Id = "{!Consum_Apply__c.Id}";
                es.BRId__c = result[0].id;
                es.BRId__c = records[0].ContentDocumentId;
                result = sforce.connection.update([es]);
            //申请书更新失败的话再次更新
            } else if ("{!Consum_Apply__c.BRId__c}" == '' || "{!Consum_Apply__c.BRId__c}" == null) {
@@ -75,7 +96,8 @@
                result = sforce.connection.update([es]);
                // TODO Name変わる可能性あり、upsertにします
            } else {
                alert(record[0].id);
                var records = record.getArray("records");
                // alert(records[0].Id);
            }
        }
        // BRcode生成後、Attachmentを作成