ActiveRecord::Base.transaction do
  hkid = "G0135517"
  current_user = User.find_by(mobile:"62029026")
  return nil unless current_user.hkid == hkid
  duplicate_user = Profile.where(hkid: hkid).where.not(user_id: current_user.id).first.try(:user)
  loan = duplicate_user.loans.first
  if loan && !loan.rejected?
    loan.cancel
    loan.update(state_reason: "C7. Others", user: current_user)
  end

  current_user.credit_reports << duplicate_user.credit_reports if duplicate_user.credit_reports.any?
  current_user.tu_pull_logs << duplicate_user.tu_pull_logs if duplicate_user.tu_pull_logs.any?
  current_user.loans << duplicate_user.loans if duplicate_user.loans.any?
  current_user.merchant_orders << duplicate_user.merchant_orders if duplicate_user.merchant_orders.any?
  current_user.rate_enquiries << duplicate_user.rate_enquiries if duplicate_user.rate_enquiries.any?
  current_user.documents << duplicate_user.documents if duplicate_user.documents.any?
  current_user.whats_app_users << duplicate_user.whats_app_users if duplicate_user.whats_app_users.any?
  current_user.loan_analytics << duplicate_user.loan_analytics if duplicate_user.loan_analytics.any?
  current_user.prizes << duplicate_user.prizes if duplicate_user.prizes.any?
  current_user.gift_redemptions << duplicate_user.gift_redemptions if duplicate_user.gift_redemptions.any?
  current_user.text_messages << duplicate_user.text_messages if duplicate_user.text_messages.any?
  current_user.email_sents << duplicate_user.email_sents if duplicate_user.email_sents.any?
  current_user.save
  duplicate_user.destroy
end

#deleted user
#<User id: 6033, member_id: "35865591", email: "joeli888hk@yahoo.com.hk", created_at: "2014-05-15 15:15:06", updated_at: "2016-09-06 09:35:32", blocked: nil, to_receive_newsletter: true, language: "tc", email_delivery_status: nil, mobile: "98048031", sign_up_key: "email", mobile_network: "45416", dda_form_received_at: nil, tracker_id: "c068f4ca-bafd-4c3a-a19c-8963ce36a319", authentication_token: "2EDeRhGWS9FWxqsjT2P74pZG", whats_app_validated: false, push_notifications: {}, dda_letter_issue_date: nil, optout_dda: false, registered_with_sms_dnc: false, registered_with_pre_recorded_dnc: false, sms_dnc_regstration_created_at: nil, pre_recorded_dnc_regstration_created_at: nil, access_token: nil, access_token_created_at: nil, dda_letter_requested_by: nil, dda_letter_requested_date: nil>