class TruckingNotesListsController < CommLogistics::Base::Controller::ListController
  def get_record_list
    @control_keys = 'trucking_notes_lists'
    
    ss = TruckingNotesSearch.new
    
    ss.table_alias = {'trucking_notes' => 't',
                      'shippings' => 't'}
    # sortテーブルの置き換えに使用
    #join_mcls = []
    ss.table_alias = {'trucking_notes' => 't',
                      'shippings' => 't'}
    join_mcls = [{:tab => 'trucking_notes',
                  :cols => TruckingNote.column_names},
                  {:tab => 'shippings',
                  :cols => Shipping.column_names}]
    ars = ss.search(FLAG_ON, TruckingNote, join_mcls, params)
    return ars
  end
  
  class TruckingNotesSearch < Comm::Tool::SqlSearch
    include CommLogistics::Const::Code
    def get_columns_and_tables(tab, join_lists, params, str_vals)
      str_cols = ' * '
      
      str_tab =  " FROM ( SELECT a.*
                   FROM trucking_notes AS a 
                   LEFT JOIN shippings as b ON a.shipping_id = b.id
                   ) AS t "
      return str_cols, str_tab, str_vals
    end
    #def set_additional_where(str_where, params)
    #  add_str_where(str_where, "")
    #end
    #から実装
    def set_target_date_to_where(tab, params, str_where)
    end
  end
end