Odoo ERP Consultant
WA: 085678-11230

PT Proweb Indonesia
The City Tower Level 12 Unit 1-N, Jakarta Pusat

Filtering Recordset pada Pemrograman Odoo 17

Mar 5, 2025 | Odoo 17 Development

Dalam melakukan pemrograman Odoo 17 mungkin ingin melakukan filtering dengan kondisi tertentu. Di sini kita akan membahas filtering recordset.

Filtering recordset pada pemrograman Odoo 17 adalah seperti pada contoh berikut ini

  1. Start SSH filesystem
  2. Model asrama.room

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    import logging
    from odoo import fields, models, api
    from odoo.exceptions import ValidationError, UserError
    from odoo.tools.translate import _
     
    _logger = logging.getLogger(__name__)
     
    class BaseArchive(models.AbstractModel):
        _name = 'base.archive'
        active = fields.Boolean(default=True)
         
        def do_archive(self):
            for record in self:
                record.active = not record.active
     
    class AsramaRoom(models.Model):
        _name = 'asrama.room'
        _inherit = ['base.archive']
        _description = 'Informasi Kamar Asrama'
        _rec_name = 'room_no'
     
        name = fields.Char('Nama kamar',required=True)
        room_no = fields.Char('No kamar',required=True)
        floor_no = fields.Integer('No Lantai',default=1, help='No Lantai')
        currency_id = fields.Many2one('res.currency',string='Mata uang')
        rent_amount = fields.Monetary('Harga sewa',help='Masukkan harga sewa')
     
        hostel_id = fields.Many2one('asrama.hostel','Hostel', help='Nama hostel')   
     
        student_per_room = fields.Integer('Jml pelajar per kamar',required=True,
            help='Jml yang dialokasikan per kamar')
     
        @api.depends('student_per_room','student_ids')
        def _compute_check_availability(self):
            """Mengecek ketersediaan"""
            for rec in self:
                rec.availability = rec.student_per_room - len (rec.student_ids.ids)
         
        availability = fields.Float(compute='_compute_check_availability',store=True,
            string='Ketersediaan',help='Ketersediaan kamar pada asrama')
     
        student_ids = fields.One2many('asrama.student','room_id','Daftar pelajar',
            help='Pelajar-pelajar dalam room ini')
     
        asrama_amenities_ids = fields.Many2many('asrama.amenities',
            'asrama_amenities_rel','room_id','amenity_id',
            string='Amenities', domain="[('active','=',True)]",
            help='Pilih fasilitas room'
        )
     
        _sql_constraints = [('room_no_unique','unique(room_no)','Nomor room harus unik!')]
     
        @api.constrains('rent_amount')
        def _check_rent_amount(self):
            """Constraint pada nilai negatif"""
            if self.rent_amount < 0:
                raise ValidationError(_('Nilai rental tidak boleh negatif'))
         
        room_rating = fields.Float('Rata-rata Rating dari Room',digits=(14,4))
        state = fields.Selection([
                ('draft','Unavailable'),
                ('available','Available'),
                ('closed','Closed')
            ],
            'State',
            default='draft'
        )
     
        @api.model
        def is_allowed_transition(self,old_state,new_state):
            allowed = [
                 ('draft','available'),
                 ('available','closed'),
                 ('closed','draft')            
            ]
            return (old_state,new_state) in allowed
         
        def change_state(self,new_state):
            for room in self:
                if room.is_allowed_transition(room.state, new_state):
                    room.state = new_state
                else:
                    msg = _('Pindah dari %s ke %s tidak diperbolehkan!') % (room.state,new_state)
                    raise UserError(msg)
     
        def make_available(self):
            self.change_state('available')
         
        def make_closed(self):
            self.change_state('closed')
     
        def log_all_room_members(self):
            asrama_student_obj = self.env['asrama.student']
            all_members = asrama_student_obj.search([])
            print('Semua anggota',all_members)
            return True
         
        def create_categories(self):
            categ1 = {
                'name': 'Child category 1',
                'description': 'Description for child 1'             
            }
            categ2 = {
                'name': 'Child category 2',
                'description':  'Description child 2'
            }
            parent_category_val = {
                'name': 'Parent category',
                'description': 'Description for parent category',
                'child_ids': [
                    (0,0,categ1),
                    (0,0,categ2),
                ]
            }
     
            record = self.env['asrama.category'].create(parent_category_val)
            return True
     
        def update_room_no(self):
            self.ensure_one()
            self.room_no = 'RM2772'
         
        def find_room(self):
            domain = [
                '|',
                    '&',('name','ilike','bunga'),
                        ('hostel_id.name','=','Kemayoran'),
                    '&',('name','ilike','galo'),
                        ('hostel_id.name','=','BSD')
            ]
            rooms = self.search(domain)
            #_logger.info('Room ditemukan %s',rooms)
            print('Room ditemukan %s',rooms)
            return True
     
        def filter_members(self):
            all_rooms = self.search([])
            filtered_rooms = self.rooms_with_multiple_members(all_rooms)
            #_logger.info('Filtered Rooms: %s',filtered_rooms)
            print('Filtered Rooms:', filtered_rooms)
         
        def rooms_with_multiple_members(self, all_rooms):
            def predicate(room):
                if (len(room.student_ids))>1:
                    return True
            return all_rooms.filtered(predicate)
  3. View asrama_room

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    <?xml version='1.0' encoding='utf-8'?>
    <odoo>
        <!-- asrama.room tree view -->
        <record id="asrama_room_view_tree" model="ir.ui.view">
            <field name="name">asrama.room.view.tree</field>
            <field name="model">asrama.room</field>
            <field name="arch" type="xml">
                <tree string='Room'>
                    <field name="name"/>
                    <field name="room_no" />
                    <field name="floor_no" />
                </tree>
            </field>
        </record>
     
        <!-- asrama.room form view -->
        <record id="asrama_room_view_form" model="ir.ui.view">
            <field name="name">asrama.room.view.form</field>
            <field name="model">asrama.room</field>
            <field name="arch" type="xml">
                <form string="Room">
                    <sheet>
                        <header>
                            <field name="state" widget='statusbar'/>
                        </header>
                        <header>
                            <button name="make_available"  string="Make Available" type="object"/>
                            <button name="make_closed"  string="Make Closed" type="object"/>
                            <button name="log_all_room_members"  string="Log semua kamar members" type="object"/>
                        </header>
                        <header>
                            <button name="create_categories"  string="Create categories" type="object"/>
                            <button name="update_room_no"  string="Update Room No" type="object"/>
                            <button name="find_room"  string="Find Room" type="object"/>
                            <button name="filter_members"  string="Filter Members" type="object"/>
                        </header>
                        <group>
                            <group description='Kamar'>
                                <field name="name" />
                                <field name="room_no" />
                                <field name="hostel_id" required="1"/>
                                <field name="floor_no" />
                                <field name="active" />
                            </group>
                            <group description='Harga'>
                                <field name="student_per_room"/>
                                <field name="availability"/>
                                <field name="rent_amount" />
                                <field name="currency_id" />
                            </group>
                        </group>
                        <notebook>
                            <page name="room_studennt" string="Para Pelajar">
                                <field name="student_ids"/>
                            </page>
                            <page name="asrama_amenities" string="Room Amenities">
                                <group>
                                    <field name="asrama_amenities_ids" widget="many2many_tags"/>
                                </group>
                            </page>
                        </notebook>
                    </sheet>
                </form>
            </field>
        </record>
     
        <!-- asrama.room action window -->
        <record id="asrama_room_action" model="ir.actions.act_window">
            <field name="name">Room</field>
            <field name="type">ir.actions.act_window</field>
            <field name="res_model">asrama.room</field>
            <field name="view_mode">tree,form</field>
            <field name="domain">[]</field>
            <field name="context">{}</field>
            <field name="help" type="html">
                <p class="oe_view_nocontent_create">
                    Tambah kamar
                </p>
            </field>
        </record>
     
        <!-- This Menu Item must have a parent and an action -->
        <menuitem id="asrama_room_menu" name="Room Asrama" parent="hostel_main_menu" action="asrama_room_action" sequence="2"/>
     
    </odoo>
  4. Start Odoo dengan logfile

  5. Tampilan Odoo
  6. Tampilan console

Kunjungi www.proweb.co.id/implementasi-odoo/ untuk menambah wawasan implementasi Odoo ERP.

Odoo 17 Development:

Odoo ERP merupakan aplikasi lengkap untuk otomatisasi proses bisnis perusahaan anda.
Jika anda tertarik dengan Odoo ERP silahkan mengisi form di bawah ini