require_dependency "lib/comm_logistics/list_controllers/shipping_shorts_lists_controller.rb"
class ShippingShortsListsController
  class ShippingShortsSearch
    def get_columns_and_tables_with_operate_date(tab, join_lists, params, str_vals)
      str_cols, str_tab, str_vals = get_columns_and_tables_without_operate_date(tab, join_lists, params, str_vals)
      str_tab = str_tab.sub("FROM shipping_details AS sd LEFT JOIN shippings AS s ON sd.shipping_id=s.id", 
                            ",ac.operate_date FROM shipping_details AS sd LEFT JOIN shippings AS s ON sd.shipping_id=s.id LEFT JOIN accept_orders AS ac ON s.accept_order_id=ac.id ")
      str_cols = str_cols.sub("sh.message_note", "sh.message_note, sh.operate_date ");
      return str_cols, str_tab, str_vals
    end
    alias_method_chain :get_columns_and_tables, :operate_date
  end
end