slip_datas = LocalRestaurant::SlipData.where("work_date = '2016-11-30'")
slip_datas.each do |sp|
  bill_course = Bill::BillCourse.find_by_id(sp.bill_course_id)
  if bill_course.blank?
    all_count = LocalRestaurant::SlipData.where(["bill_course_id = ?", sp.bill_course_id]).sum('count').to_f

    course = Course.find_by_id(sp.course_id)

    bill_course = Bill::BillCourse.new
    bill_course.id = SecureRandom.uuid
    bill_course.bill_id = sp.bill_id
    bill_course.course_id = sp.bill_id
    bill_course.course_count = all_count
    bill_course.course_price = course.price
    bill_course.department_id = course.department.id
    bill_course.department_id = course.department.id
    bill_course.restaurant_id = sp.restaurant_id
    bill_course.time_add = sp.time_begin
    bill_course.course_amount = course.price*all_count
    bill_course.course_sale = course.price
    bill_course.save

    sold_sum = Bill::BillCourseSold.where(["bill_id = ? And course_id = ?", sp.bill_id, sp.course_id]).sum('count').to_f
    if sold_sum < all_count
      # insert SOLD
      sold = Bill::BillCourseSold.new
      sold.id = SecureRandom.uuid
      sold.bill_id = sp.bill_id
      sold.course_id = sp.course_id
      sold.count = all_count - sold_sum
      sold.restaurant_id = sp.restaurant_id
      sold.save
    end
  end
end