| | |
|---|
| | | src = srcNew.substring(22, srcNew.length); |
|---|
| | | sforce.connection.sessionId = '{!GETSESSIONID()}'; |
|---|
| | | |
|---|
| | | var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Rental_Apply__c.Id}\' and name = \'BRCode-{!Rental_Apply__c.Name_No__c}\'"); |
|---|
| | | // var record = sforce.connection.query("select id from Attachment where ParentId = \'{!Rental_Apply__c.Id}\' and name = \'BRCode-{!Rental_Apply__c.Name_No__c}\'"); |
|---|
| | | var record = sforce.connection.query("select ContentDocumentId from ContentDocumentLink where LinkedEntityId = \'{!Rental_Apply__c.Id}\'"); |
|---|
| | | console.log("333333333333",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 = \'BRCode-{!Rental_Apply__c.Name_No__c}\'"); |
|---|
| | | } |
|---|
| | | // 既にあれば無視 |
|---|
| | | if (record.size == 0) { |
|---|
| | | var atta = new sforce.SObject("Attachment"); |
|---|
| | | atta.Name = "BRCode-{!Rental_Apply__c.Name_No__c}"; |
|---|
| | | atta.ParentId = "{!Rental_Apply__c.Id}"; |
|---|
| | | atta.Body = src; |
|---|
| | | var result = sforce.connection.create([atta]); |
|---|
| | | var version = new sforce.SObject("ContentVersion"); |
|---|
| | | version.VersionData = src; |
|---|
| | | version.Title = "BRCode-{!Rental_Apply__c.Name_No__c}"; |
|---|
| | | version.ContentLocation = 's'; |
|---|
| | | version.PathOnClient= "BRCode-{!Rental_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 = "{!Rental_Apply__c.Id}"; |
|---|
| | | link.ShareType = 'I'; |
|---|
| | | link.Visibility = 'AllUsers'; |
|---|
| | | var result = sforce.connection.create([link]); |
|---|
| | | |
|---|
| | | // var atta = new sforce.SObject("Attachment"); |
|---|
| | | // atta.Name = "BRCode-{!Rental_Apply__c.Name_No__c}"; |
|---|
| | | // atta.ParentId = "{!Rental_Apply__c.Id}"; |
|---|
| | | // atta.Body = src; |
|---|
| | | // var result = sforce.connection.create([atta]); |
|---|
| | | |
|---|
| | | var es = new sforce.SObject("Rental_Apply__c"); |
|---|
| | | es.Id = "{!Rental_Apply__c.Id}"; |
|---|
| | | es.BRId__c = result[0].id; |
|---|
| | | es.BRId__c = versionResult[0].id; |
|---|
| | | result = sforce.connection.update([es]); |
|---|
| | | //申请书更新失败的话再次更新 |
|---|
| | | } else if ("{!Rental_Apply__c.BRId__c}" == '' || "{!Rental_Apply__c.BRId__c}" == null) { |
|---|
| | | var records = record.getArray("records"); |
|---|
| | | var es = new sforce.SObject("Rental_Apply__c"); |
|---|
| | | es.Id = "{!Rental_Apply__c.Id}"; |
|---|
| | | es.BRId__c = records[0].Id; |
|---|
| | | result = sforce.connection.update([es]); |
|---|
| | | // var records = record.getArray("records"); |
|---|
| | | // var es = new sforce.SObject("Rental_Apply__c"); |
|---|
| | | // es.Id = "{!Rental_Apply__c.Id}"; |
|---|
| | | // es.BRId__c = records[0].Id; |
|---|
| | | // result = sforce.connection.update([es]); |
|---|
| | | // TODO Name変わる可能性あり、upsertにします |
|---|
| | | 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"); |
|---|
| | | if(version[0].Id != "{!Rental_Apply__c.QRId__c}"){ |
|---|
| | | var es = new sforce.SObject("Rental_Apply__c"); |
|---|
| | | es.Id = "{!Rental_Apply__c.Id}"; |
|---|
| | | es.QRId__c = version[0].id; |
|---|
| | | result = sforce.connection.update([es]); |
|---|
| | | } |
|---|
| | | } else { |
|---|
| | | alert(record[0].id); |
|---|
| | | // alert(record[0].id); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // BRcode生成後、Attachmentを作成 |
|---|
