gistfile1.txt

    def get_bins(self, cr, uid, bin_selection, storage_type, list_exclusions, qty_dict, context=None):

        base_sql = "SELECT DISTINCT bin.id " \
                "\nFROM stock_location_bin bin " \
                "\nLEFT JOIN stock_inventory stock ON stock.bin_id = bin.id"

        first = True

        if bin_selection == 'empty':
            if first:
                first = False
                operator = ' WHERE'
            else:
                operator = ' AND'
            base_sql += "\n%s stock.bin_id IS NULL" % operator

        elif bin_selection == 'not_empty':
            if first:
                first = False
                operator = ' WHERE'
            else:
                operator = ' AND'
            base_sql += "\n%s stock.bin_id IS NOT NULL" % operator

        if storage_type and storage_type != 'all':
            if first:
                first = False
                operator = ' WHERE'
            else:
                operator = ' AND'
            base_sql += " \n%s bin.storage_type = '%s'" % (operator, storage_type)

        if list_exclusions and list_exclusions != []:
            if len(list_exclusions) == 1:
                query += "\nAND bin.id != %s" % str(list_exclusions[0])
            else:
                query += "\nAND bin.id NOT IN %s" % str(tuple(list_exclusions))

        if qty_dict:
            if first:
                first = False
                operator = ' WHERE'
            else:
                operator = ' AND'

            base_sql += "\n%s stock.qty_onhand %s %s" % (operator, qty_dict['operator'], qty_dict['value'])


        return base_sql