JAVASCRIPT BUTTON CODE :

{!REQUIRESCRIPT("/soap/ajax/24.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/24.0/apex.js")} 

try{ 
var query = "SELECT Id,Opportunity__r.StageName,Forecast_MCA_Revenue__c	,Group_Travel_Offer__c,Forecast_Group_Booking_Expenditure__c,Reason_for_Discount__c ,Proposal_Start_Date__c,Proposal_End_Date__c,Name,Account__c,Commercial_TC__c,RecordTypeId,Domestic_Annual_Share__c,Charter_Price__c,International_Annual_Share__c,Legal_TC__c,Opportunity__c,Contact__c,Qantas_Annual_Expenditure__c,Qantas_Club_Join_Discount_Offer__c,Status__c,Valid_From_Date__c,Valid_To_Date__c,Standard__c,Deal_Type__c,MCA_Routes_Annual_Share__c,Agent_Name__c,Agent_Fax__c,Agent_Email__c,Agent_Address__c,Frequent_Flyer_Status_Upgrade__c,Frequent_Flyer_Status_Upgrade_Offer__c,Qantas_Club_Discount__c,Qantas_Club_Discount_Offer__c,TMC_Code__c,Travel_Fund__c,Travel_Fund_Amount__c,Type__c,NAM_Approved1__c,Pricing_Approved1__c,DO_Approved__c,Approval_Required_Others__c,Leadership_Rejected__c,TeamLead_Approved__c,SBD_Approved__c,QIS_Approved__c,QIS_Rejected__c,Additional_Change_Details__c,(SELECT Id, Route_Origin__c,Route_Destination__c,FareStructure__c, Comment__c, Discount__c, Discount_Threshold_AM__c, Discount_Threshold_NAM__c,Approved_by_NAM__c,Approved_by_Pricing__c,Cabin__c,Category__c,Fare_Combination__c,Market__c,Network__c,Proposal_Type__c,Qantas_Published_Airfare__c,QBS_Deafualt_Discount__c,Segment__c,TeamLead_Approved__c,DO_Approved__c FROM Fare_Structure_Lists__r),(SELECT Id,Contract_Agreement__c,Aircraft_Type__c,ETD__c,Flight_Date__c,Flight_Number__c,Seating_Space__c,Sector__c,Useable_Seats__c FROM Charter_Flight_Information__r),(SELECT Id,Amount__c,Contract_Agreement__c,Paid_As__c,Payment_Criteria__c,Payment_Frequency__c,Proposal__c,Type__c FROM Contract_Payments__r),(SELECT Market__c,Proposal__c,Aligned_with_EK_sales__c,Cost_of_sale_Incremental_opportunity__c,Current_performance_in_the_route_s__c,What_else_have_you_considered__c,How_did_you_arrive_with_this_proposal__c,Is_there_competitive_MI__c,Requested_routes__c,Supplementary_Materials_Sharepoint_Link__c,What_is_the_current_booking_mix__c FROM Justifications__r)FROM Proposal__c where Active__c=true AND Id=\'"+'{!Proposal__c.Id}'+"\' limit 1"; 

var records = sforce.connection.query(query); 
var records1 = records.getArray('records'); 

if(records1.length>0){ 

if(records1[0].Opportunity__r.StageName != 'Closed - Accepted' && records1[0].Opportunity__r.StageName != 'Closed - Not Accepted'){ 
// Contract Creation 

var proposal = new sforce.SObject("Proposal__c"); 

proposal.Name = records1[0].Name; 
proposal.Account__c = records1[0].Account__c; 
proposal.Active__c = true; 
proposal.Charter_Price__c = records1[0].Charter_Price__c; 
proposal.Commercial_TC__c = records1[0].Commercial_TC__c; 
proposal.Contact__c = records1[0].Contact__c; 
proposal.Domestic_Annual_Share__c = records1[0].Domestic_Annual_Share__c; 
proposal.International_Annual_Share__c = records1[0].International_Annual_Share__c; 
proposal.Legal_TC__c = records1[0].Legal_TC__c; 
proposal.Opportunity__c = records1[0].Opportunity__c; 
proposal.Qantas_Annual_Expenditure__c = records1[0].Qantas_Annual_Expenditure__c; 
proposal.Valid_From_Date__c = records1[0].Valid_From_Date__c; 
proposal.Type__c = records1[0].Type__c; 
proposal.Travel_Fund__c = records1[0].Travel_Fund__c; 
proposal.Travel_Fund_Amount__c = records1[0].Travel_Fund_Amount__c; 
proposal.Standard__c = records1[0].Standard__c; 
proposal.Additional_Change_Details__c = records1[0].Additional_Change_Details__c; 
proposal.Deal_Type__c = records1[0].Deal_Type__c; 
proposal.MCA_Routes_Annual_Share__c = records1[0].MCA_Routes_Annual_Share__c; 
proposal.Agent_Name__c = records1[0].Agent_Name__c; 
proposal.Agent_Fax__c = records1[0].Agent_Fax__c; 
proposal.Agent_Email__c = records1[0].Agent_Email__c; 
proposal.Agent_Address__c = records1[0].Agent_Address__c; 
proposal.Frequent_Flyer_Status_Upgrade__c = records1[0].Frequent_Flyer_Status_Upgrade__c; 
proposal.Frequent_Flyer_Status_Upgrade_Offer__c = records1[0].Frequent_Flyer_Status_Upgrade_Offer__c; 
proposal.Qantas_Club_Discount__c = records1[0].Qantas_Club_Discount__c; 
proposal.Qantas_Club_Discount_Offer__c = records1[0].Qantas_Club_Discount_Offer__c; 
proposal.TMC_Code__c = records1[0].TMC_Code__c; 
proposal.Qantas_Club_Join_Discount_Offer__c = records1[0].Qantas_Club_Join_Discount_Offer__c; 
proposal.Forecast_MCA_Revenue__c = records1[0].Forecast_MCA_Revenue__c; 
proposal.Reason_for_Discount__c	= records1[0].Reason_for_Discount__c; 
proposal.Proposal_Start_Date__c=records1[0].Proposal_Start_Date__c; 
proposal.Proposal_End_Date__c	=records1[0].Proposal_End_Date__c; 
proposal.Forecast_Group_Booking_Expenditure__c	=records1[0].Forecast_Group_Booking_Expenditure__c; 
proposal.Group_Travel_Offer__c	=records1[0].Group_Travel_Offer__c; 


proposal.NAM_Approved1__c = records1[0].NAM_Approved1__c; 
proposal.Pricing_Approved1__c = records1[0].Pricing_Approved1__c; 
proposal.DO_Approved__c = records1[0].DO_Approved__c; 
if(records1[0].Status__c == 'Rejected - Internal' && records1[0].Leadership_Rejected__c == 'true'){ 
proposal.Approval_Required_Others__c = true; 
}else{ 
proposal.Approval_Required_Others__c = records1[0].Approval_Required_Others__c; 
} 

if(records1[0].QIS_Rejected__c != 'true'){ 
proposal.TeamLead_Approved__c = records1[0].TeamLead_Approved__c; 

proposal.SBD_Approved__c = records1[0].SBD_Approved__c; 
proposal.QIS_Approved__c = records1[0].QIS_Approved__c; 
} 
var rtype; 
if(records1[0].Type__c == 'Qantas Business Savings'){ 
rtype = 'QBS - Draft'; 
}else if(records1[0].Type__c == 'Corporate Airfares'){ 
rtype = 'CA - Draft'; 
}else if(records1[0].Type__c == 'Adhoc'){ 
rtype = 'Adhoc Charter - Approval Required - Customer'; 
}else if(records1[0].Type__c == 'Scheduled'){ 
rtype = 'Adhoc Charter - Approval Required - Customer'; 
} 
var queryC = "SELECT Id, Name FROM RecordType where Name like '%"+rtype+"%' AND sObjectType='Proposal__c' limit 1"; 
var rtypes = sforce.connection.query(queryC); 
var rtypes1 = rtypes.getArray('records'); 
proposal.RecordTypeId = rtypes1[0].Id; 

var result = sforce.connection.create([proposal]); 

if(result[0].success){ 

var discounts = records1[0].Fare_Structure_Lists__r; 

if(discounts != null){ 

// Discount List Creation 
var conDiscounts1 = discounts.getArray("records"); 
var discounts = []; 
for(var i=0; i<conDiscounts1.length; i++){ 
var discount = new sforce.SObject("Discount_List__c"); 
discount.Approval_Comment_NAM__c = conDiscounts1[i].Approval_Comment_NAM__c; 
discount.Approval_Comment_Pricing__c = conDiscounts1[i].Approval_Comment_Pricing__c; 
discount.FareStructure__c = conDiscounts1[i].FareStructure__c; 
discount.Comment__c = conDiscounts1[i].Comment__c; 
discount.Proposal__c = result[0].id; 
discount.Route_Origin__c =conDiscounts1[i].Route_Origin__c; 
discount.Route_Destination__c=conDiscounts1[i].Route_Destination__c; 
discount.Discount__c = conDiscounts1[i].Discount__c; 
discount.Discount_Threshold_AM__c = conDiscounts1[i].Discount_Threshold_AM__c; 
discount.Discount_Threshold_NAM__c = conDiscounts1[i].Discount_Threshold_NAM__c; 
discount.Qantas_Published_Airfare__c = conDiscounts1[i].Qantas_Published_Airfare__c; 
discount.Approved_by_NAM__c = conDiscounts1[i].Approved_by_NAM__c; 
discount.Approved_by_Pricing__c = conDiscounts1[i].Approved_by_Pricing__c; 
discount.DO_Approved__c = conDiscounts1[i].DO_Approved__c; 
discount.Segment__c = conDiscounts1[i].Segment__c; 
discount.Category__c = conDiscounts1[i].Category__c; 
discount.Cabin__c = conDiscounts1[i].Cabin__c; 
discount.Fare_Combination__c = conDiscounts1[i].Fare_Combination__c; 
discount.Market__c = conDiscounts1[i].Market__c; 
discount.Network__c = conDiscounts1[i].Network__c; 
discount.Proposal_Type__c = conDiscounts1[i].Proposal_Type__c; 
discount.Qantas_Published_Airfare__c = conDiscounts1[i].Qantas_Published_Airfare__c; 
discount.QBS_Deafualt_Discount__c = conDiscounts1[i].QBS_Deafualt_Discount__c; 
if(records1[0].QIS_Rejected__c != 'true' && records1[0].Status__c != 'Rejected - Internal' ){ 

discount.TeamLead_Approved__c = conDiscounts1[i].TeamLead_Approved__c; 
} 

discounts.push(discount); 
} 
var result1 = sforce.connection.create(discounts); 
} 
var charters = records1[0].Charter_Flight_Information__r; 

if(charters != null){ 
//Charters creation 
var charters1 = charters.getArray("records"); 

var charterValues = []; 

for(var i=0; i<charters1.length; i++){ 
var charterValue = new sforce.SObject("Charter_Flight_Information__c"); 
charterValue.Proposal__c = result[0].id; 
charterValue.Aircraft_Type__c = charters1[i].Aircraft_Type__c; 
charterValue.ETD__c = charters1[i].ETD__c; 
charterValue.Flight_Date__c = charters1[i].Flight_Date__c; 
charterValue.Flight_Number__c = charters1[i].Flight_Number__c; 
charterValue.Seating_Capacity__c = charters1[i].Seating_Capacity__c; 
charterValue.Sector__c = charters1[i].Sector__c; 

charterValues.push(charterValue); 
} 
var result2 = sforce.connection.create(charterValues); 

} 

var payments = records1[0].Contract_Payments__r; 

if(payments != null){ 
//Contract Payment creation 
var payments1 = payments.getArray("records"); 

var paymentValues = []; 

for(var i=0; i<payments1.length; i++){ 
var paymentValue = new sforce.SObject("Contract_Payments__c"); 
paymentValue.Proposal__c = result[0].id; 
paymentValue.Amount__c = payments1[i].Amount__c; 
paymentValue.Contract_Agreement__c = payments1[i].Contract_Agreement__c; 
paymentValue.Paid_As__c = payments1[i].Paid_As__c; 
paymentValue.Payment_Criteria__c = payments1[i].Payment_Criteria__c; 
paymentValue.Payment_Frequency__c = payments1[i].Payment_Frequency__c; 
paymentValue.Type__c = payments1[i].Type__c; 

paymentValues.push(paymentValue); 
} 
var result3 = sforce.connection.create(paymentValues); 

} 

var business = records1[0].Justifications__r; 
if(business != null){ 
//Business Case creation 
var business1 = business.getArray("records"); 
var businessValues = []; 

for(var i=0; i<business1.length; i++){ 
var businessValue = new sforce.SObject("Business_Case__c"); 
businessValue.Proposal__c = result[0].id; 
businessValue.Aligned_with_EK_sales__c	= business1[i].Aligned_with_EK_sales__c; 
businessValue.Cost_of_sale_Incremental_opportunity__c = business1[i].Cost_of_sale_Incremental_opportunity__c; 
businessValue.Current_performance_in_the_route_s__c = business1[i].Current_performance_in_the_route_s__c; 
businessValue.What_else_have_you_considered__c = business1[i].What_else_have_you_considered__c; 
businessValue.How_did_you_arrive_with_this_proposal__c = business1[i].How_did_you_arrive_with_this_proposal__c; 
businessValue.Is_there_competitive_MI__c = business1[i].Is_there_competitive_MI__c; 
businessValue.Market__c = business1[i].Market__c; 
businessValue.Requested_routes__c = business1[i].Requested_routes__c; 
businessValue.Supplementary_Materials_Sharepoint_Link__c = business1[i].Supplementary_Materials_Sharepoint_Link__c; 
businessValue.What_is_the_current_booking_mix__c = business1[i].What_is_the_current_booking_mix__c; 


businessValues.push(businessValue); 
} 
var result4 = sforce.connection.create(businessValues); 

} 

var query1 = "SELECT Id, ParentId, Body, OwnerId, Title FROM Note WHERE ParentId=\'"+'{!Proposal__c.Id}'+"\'";
var recordstypes = sforce.connection.query(query1); 
var recordsnote = records.getArray('recordstypes'); 

if(recordsnote.length>0){ 
var noteobj = new sforce.SObject("Note")
noteobj.ParentId = records1[0].Id; 
noteobj.Body = recordsnote[0].Body; 
noteobj.Title = recordsnote[0].Title; 
var result = sforce.connection.create([noteobj]); 


}
window.location.href = '/'+result[0].id+'/e?retURL='+result[0].id; 
} 

} else{ 
alert('Please note that you cannot create a proposal for a closed opportunity.'); 
} 
}else if(records1.length==0){ 
alert("You can't clone in active Proposal."); 
} 

} 
catch(e){ 
alert('An Error has Occured. Error:' +e); 
}