# it runs audit
def self.r id
    item = Netsuite::Models::AuditQueueItem.where(:entity_id => id).first
    worker = Netsuite::Controllers::Sync::AuditWorker.new
    worker.process_item item
 end


# It will fetch orders having errors 1,1.. and run audit of same again
# ***************************************************************************************************************
aq = Netsuite::Models::AuditQueueItem.where(status:4).select{|a| a.audit_details.map(&:error_code).include?(1)}
aq.each{|aqi|
  begin
    ap "Auditing #{aqi.entity_id}"
    r aqi.entity_id
    ap "Finished auditing #{aqi.entity_id}"
  rescue => e
    ap "Exception occured while auditing #{aqi.entity_id}"
    ap e.backtrace
  end
}
# ******************************************************************************************************************
# It will fetch orders with error 113 , fixes them and run their audit

aq = Netsuite::Models::AuditQueueItem.includes(:audit_details).where(status: 4).joins(:audit_details).where("audit_details.error_code = 113")

def self.delete_sales_order internalId
 Netsuite::Records::Transactions::NsSalesOrder.delete internalId
 Netsuite::Records::Transactions::NsSalesOrder.delete_mysql internalId
end

aq.each do |aqt|
 ad = aqt.audit_details.select{|ad| ad.error_code == 113}.first

 wms = Wms::WmsTransaction.where(tranId: ad.record_id).first
begin
 ap "deleting sales order #{wms.externalId}"
 delete_sales_order wms.internalId
 ap "auditing #{aqt.entity_id}"
 r aqt.entity_id
rescue => e
 ap "#{aqt.entity_id} failed"
end
end
#************************************************************************************************************************