~unifield-team/unifield-wm/us-826

# if prodlot needs to be mandatory, add 'required': ['|', ('hidden_batch_management_mandatory','=',True), ('hidden_perishable_mandatory','=',True)] in attrs

516

'hidden_batch_management_mandatory': fields.boolean(string='Hidden Flag for Batch Management product',),

517

'hidden_perishable_mandatory': fields.boolean(string='Hidden Flag for Perishable product',),

518

'kc_check': fields.function(_get_checks_all, method=True, string='KC', type='boolean', readonly=True, multi="m"),

519

'ssl_check': fields.function(_get_checks_all, method=True, string='SSL', type='boolean', readonly=True, multi="m"),

520

'dg_check': fields.function(_get_checks_all, method=True, string='DG', type='boolean', readonly=True, multi="m"),

521

'np_check': fields.function(_get_checks_all, method=True, string='NP', type='boolean', readonly=True, multi="m"),

522

}

523

524

_constraints = [(_check_batch_management,

525

'You must assign a Batch Number for this product (Batch Number Mandatory)',

526

['prodlot_id']),

527

(_check_perishable,

528

'You must assign an Expiry Date for this product (Expiry Date Mandatory)',

529

['prodlot_id']),

530

(_check_prodlot_need,

531

'The selected product is neither Batch Number Mandatory nor Expiry Date Mandatory',

532

['prodlot_id']),

533

(_check_prodlot_need_batch_management,

534

'The selected product is Batch Number Mandatory while the selected Production Lot corresponds to Expiry Date Mandatory.',

535

['prodlot_id']),

536

(_check_prodlot_need_perishable,

537

'The selected product is Expiry Date Mandatory while the selected Production Lot corresponds to Batch Number Mandatory.',

538

['prodlot_id']),

539

]

540

541

stock_move()

542

543

544

class stock_production_lot(osv.osv):

545

'''

546

productin lot modifications

547

'''

548

_inherit = 'stock.production.lot'

549

550

def fields_view_get(self, cr, uid, view_id=None, view_type='form', context=None, toolbar=False, submenu=False):

551

"""

552

Correct fields in order to have those from account_statement_from_invoice_lines (in case where account_statement_from_invoice is used)

553

"""

554

if context is None:

555

context = {}

556

# warehouse wizards or inventory screen

557

if view_type == 'tree' and ((context.get('expiry_date_check', False) and not context.get('batch_number_check', False)) or context.get('hidden_perishable_mandatory')):

558

view = self.pool.get('ir.model.data').get_object_reference(cr, uid, 'specific_rules', 'view_production_lot_expiry_date_tree')

559

if view:

560

view_id = view[1]

561

result = super(osv.osv, self).fields_view_get(cr, uid, view_id, view_type, context=context, toolbar=toolbar, submenu=submenu)

562

return result

563

564

def copy(self, cr, uid, id, default=None, context=None):

565

'''

566

increase the batch number

567

create a new sequence

568

'''

569

if default is None:

570

default = {}

571

572

# original reference

573

lot_name = self.read(cr, uid, id, ['name'])['name']

574

default.update(name='%s (copy)'%lot_name, date=time.strftime('%Y-%m-%d'))

575

576

return super(stock_production_lot, self).copy(cr, uid, id, default, context=context)

577

578

def copy_data(self, cr, uid, id, default=None, context=None):

579

'''

580

clear the revisions

581

'''

582

if default is None:

583

default = {}

584

default.update(revisions=[])

585

return super(stock_production_lot, self).copy_data(cr, uid, id, default, context=context)

586

587

def create_sequence(self, cr, uid, vals, context=None):

588

"""

589

Create new entry sequence for every new order

590

@param cr: cursor to database

591

@param user: id of current user

592

@param ids: list of record ids to be process

593

@param context: context arguments, like lang, time zone

594

@return: return a result

595

"""

596

seq_pool = self.pool.get('ir.sequence')

597

seq_typ_pool = self.pool.get('ir.sequence.type')

598

599

name = 'Production Lot'

600

code = 'stock.production.lot'

601

602

types = {

603

'name': name,

604

'code': code

605

}

606

seq_typ_pool.create(cr, uid, types)

607

608

seq = {

609

'name': name,

610

'code': code,

611

'prefix': '',

612

'padding': 0,

613

}

614

return seq_pool.create(cr, uid, seq)

615

616

def create(self, cr, uid, vals, context=None):

617

'''

618

create the sequence for the version management

619

'''

620

if context is None:

621

context = {}

622

623

sequence = self.create_sequence(cr, uid, vals, context=context)

624

vals.update({'sequence_id': sequence,})

625

626

if context.get('update_mode') in ['init', 'update']:

627

if not vals.get('life_date'):

628

# default value to today

629

vals.update(life_date=time.strftime('%Y-%m-%d'))

630

631

return super(stock_production_lot, self).create(cr, uid, vals, context=context)

632

633

def write(self, cr, uid, ids, vals, context=None):

634

'''

635

update the sequence for the version management

636

'''

637

if isinstance(ids, (int, long)):

638

ids = [ids]

639

640

revision_obj = self.pool.get('stock.production.lot.revision')

641

642

for lot in self.browse(cr, uid, ids, context=context):

643

# create revision object for each lot

644

version_number = lot.sequence_id.get_id(test='id', context=context)

645

values = {'name': 'Auto Revision Logging',

646

'description': 'The production lot has been modified, this revision log has been created automatically.',

647

'date': time.strftime('%Y-%m-%d'),

648

'indice': version_number,

649

'author_id': uid,

650

'lot_id': lot.id,}

651

revision_obj.create(cr, uid, values, context=context)

652

653

return super(stock_production_lot, self).write(cr, uid, ids, vals, context=context)

654

655

def remove_flag(self, flag, _list):

656

'''

657

if we do not remove the flag, we fall into an infinite loop

658

'''

659

args2 = []

660

for arg in _list:

661

if arg[0] != flag:

662

args2.append(arg)

663

return args2

664

665

def search_check_type(self, cr, uid, obj, name, args, context=None):

666

'''

667

modify the query to take the type of prodlot into account according to product's attributes

668

'Batch Number mandatory' and 'Expiry Date Mandatory'

669

670

if batch management: display only 'standard' lot

671

if expiry and not batch management: display only 'internal' lot

672

else: display normally

673

'''

674

product_obj = self.pool.get('product.product')

675

product_id = context.get('product_id', False)

676

677

# remove flag avoid infinite loop

678

args = self.remove_flag('check_type', args)

679

680

if not product_id:

681

return args

682

683

# check the product

684

product = product_obj.browse(cr, uid, product_id, context=context)

685

686

if product.batch_management:

687

# standard lots

688

args.append(('type', '=', 'standard'))

689

elif product.perishable:

690

# internal lots

691

args.append(('type', '=', 'internal'))

692

693

return args

694

695

def _get_false(self, cr, uid, ids, field_name, arg, context=None):

696

'''

697

return false for each id

698

'''

699

if isinstance(ids,(long, int)):

700

ids = [ids]

701

702

result = {}

703

for id in ids:

704

result[id] = False

705

return result

706

707

def _get_stock(self, cr, uid, ids, field_name, arg, context=None):

708

""" Gets stock of products for locations

709

@return: Dictionary of values

710

"""

711

if context is None:

712

context = {}

713

714

if isinstance(ids, (int, long)):

715

ids = [ids]

716

717

product_obj = self.pool.get('product.product')

718

719

result = {}

720

for id in ids:

721

result[id] = 0.0

722

723

for lot in self.browse(cr, uid, ids, context=context):

724

# because the lot_id changes we have to loop one lot id at a time

725

c = context.copy()

726

# if you remove the coma after done, it will no longer work properly

727

c.update({'what': ('in', 'out'),

728

'prodlot_id': lot.id,

729

#'to_date': time.strftime('%Y-%m-%d %H:%M:%S'),

730

#'warehouse': warehouse_id,

731

#'uom': product_uom_id

732

})

733

734

if field_name == 'stock_available':

735

# available stock

736

c.update(states=('confirmed','waiting','assigned','done'))

737

elif field_name == 'stock_real':

738

# real stock

739

c.update(states=('done',))

740

else:

741

assert False, 'This line should not be reached: field_name: %s'%field_name

742

743

qty = product_obj.get_product_available(cr, uid, [lot.product_id.id], context=c)

744

overall_qty = sum(qty.values())

745

result[lot.id] = overall_qty

746

747

return result

748

749

def _get_checks_all(self, cr, uid, ids, name, arg, context=None):

750

'''

751

function for KC/SSL/DG/NP products

752

'''

753

result = {}

754

for id in ids:

755

result[id] = {}

756

for f in name:

757

result[id].update({f: False})

758

759

for obj in self.browse(cr, uid, ids, context=context):

760

# keep cool

761

if obj.product_id.heat_sensitive_item:

762

result[obj.id]['kc_check'] = True

763

# ssl

764

if obj.product_id.short_shelf_life:

765

result[obj.id]['ssl_check'] = True

766

# dangerous goods

767

if obj.product_id.dangerous_goods:

768

result[obj.id]['dg_check'] = True

769

# narcotic

770

if obj.product_id.narcotic:

771

result[obj.id]['np_check'] = True

772

773

return result

774

775

_columns = {'check_type': fields.function(_get_false, fnct_search=search_check_type, string='Check Type', type="boolean", readonly=True, method=True),

776

'type': fields.selection([('standard', 'Standard'),('internal', 'Internal'),], string="Type"),

777

#'expiry_date': fields.date('Expiry Date'),

778

'name': fields.char('Batch Number', size=1024, required=True, help="Unique production lot, will be displayed as: PREFIX/SERIAL [INT_REF]"),

779

'date': fields.datetime('Auto Creation Date', required=True),

780

'sequence_id': fields.many2one('ir.sequence', 'Lot Sequence', required=True,),

781

'stock_available': fields.function(_get_stock, method=True, type="float", string="Available", select=True,

782

help="Current quantity of products with this Production Lot Number available in company warehouses",

783

digits_compute=dp.get_precision('Product UoM'), readonly=True,),

784

'stock_real': fields.function(_get_stock, method=True, type="float", string="Real", select=True,

785

help="Current quantity of products with this Production Lot Number available in company warehouses",

786

digits_compute=dp.get_precision('Product UoM'), readonly=True,),

787

'kc_check': fields.function(_get_checks_all, method=True, string='KC', type='boolean', readonly=True, multi="m"),

788

'ssl_check': fields.function(_get_checks_all, method=True, string='SSL', type='boolean', readonly=True, multi="m"),

789

'dg_check': fields.function(_get_checks_all, method=True, string='DG', type='boolean', readonly=True, multi="m"),

790

'np_check': fields.function(_get_checks_all, method=True, string='NP', type='boolean', readonly=True, multi="m"),

791

}

792

793

_defaults = {'type': 'standard',

794

'company_id': lambda s,cr,uid,c: s.pool.get('res.company')._company_default_get(cr, uid, 'stock.production.lot', context=c),

795

'name': False,

796

'life_date': False,

797

}

798

799

_sql_constraints = [('name_uniq', 'unique (name)', 'The Batch Number must be unique !'),

800

]

801

802

def search(self, cr, uid, args=[], offset=0, limit=None, order=None, context={}, count=False):

803

'''

804

search function of production lot

805

'''

806

result = super(stock_production_lot, self).search(cr, uid, args, offset, limit, order, context, count)

807

808

return result

809

810

def name_get(self, cr, uid, ids, context=None):

811

if not ids:

812

return []

813

reads = self.read(cr, uid, ids, ['name', 'prefix', 'ref'], context)

814

res = []

815

for record in reads:

816

name = record['name']

817

res.append((record['id'], name))

818

return res

819

820

stock_production_lot()

821

822

823

class stock_production_lot_revision(osv.osv):

824

_inherit = 'stock.production.lot.revision'

825

_order = 'indice desc'

826

827

stock_production_lot_revision()

828

829

830

class stock_inventory(osv.osv):

831

'''

832

override the action_confirm to create the production lot if needed

833

'''

834

_inherit = 'stock.inventory'

835

836

def action_confirm(self, cr, uid, ids, context=None):

837

'''

838

if the line is perishable without prodlot, we create the prodlot

839

'''

840

prodlot_obj = self.pool.get('stock.production.lot')

841

# treat the needed production lot

842

for obj in self.browse(cr, uid, ids, context=context):

843

for line in obj.inventory_line_id:

844

# if perishable product

845

if line.hidden_perishable_mandatory and not line.hidden_batch_management_mandatory:

846

# integrity test

847

assert line.product_id.perishable, 'product is not perishable but line is'

848

assert line.expiry_date, 'expiry date is not set'

849

# if no production lot, we create a new one

850

if not line.prod_lot_id:

851

# double check to find the corresponding prodlot

852

prodlot_ids = prodlot_obj.search(cr, uid, [('life_date', '=', line.expiry_date),

853

('type', '=', 'internal'),

854

('product_id', '=', line.product_id.id)], context=context)

855

# no prodlot, create a new one

856

if not prodlot_ids:

857

vals = {'product_id': line.product_id.id,

858

'life_date': line.expiry_date,

859

'name': self.pool.get('ir.sequence').get(cr, uid, 'stock.lot.serial'),

860

'type': 'internal',

861

}

862

prodlot_id = prodlot_obj.create(cr, uid, vals, context=context)

863

else:

864

prodlot_id = prodlot_ids[0]

865

# update the line

866

line.write({'prod_lot_id': prodlot_id,},)

867

868

# super function after production lot creation - production lot are therefore taken into account at stock move creation

869

result = super(stock_inventory, self).action_confirm(cr, uid, ids, context=context)

870

return result

871

872

stock_inventory()

873

874

875

class stock_inventory_line(osv.osv):

876

'''

877

add mandatory or readonly behavior to prodlot

878

'''

879

_inherit = 'stock.inventory.line'

880

881

def change_lot(self, cr, uid, id, prod_lot_id, context=None):

882

'''

883

prod lot changes, update the expiry date

884

'''

885

prodlot_obj = self.pool.get('stock.production.lot')

886

result = {'value':{}}

887

888

if prod_lot_id:

889

result['value'].update(expiry_date=prodlot_obj.browse(cr, uid, prod_lot_id, context).life_date)

890

else:

891

result['value'].update(expiry_date=False)

892

893

return result

894

895

def change_expiry(self, cr, uid, id, expiry_date, product_id, type_check, context=None):

896

'''

897

expiry date changes, find the corresponding internal prod lot

898

'''

899

prodlot_obj = self.pool.get('stock.production.lot')

900

result = {'value':{}}

901

902

if expiry_date and product_id:

903

prod_ids = prodlot_obj.search(cr, uid, [('life_date', '=', expiry_date),

904

('type', '=', 'internal'),

905

('product_id', '=', product_id)], context=context)

906

if not prod_ids:

907

if type_check == 'in':

908

# the corresponding production lot will be created afterwards

909

result['warning'] = {'title': _('Info'),

910

'message': _('The selected Expiry Date does not exist in the system. It will be created during validation process.')}

911

# clear prod lot

912

result['value'].update(prod_lot_id=False)

913

else:

914

# display warning

915

result['warning'] = {'title': _('Error'),

916

'message': _('The selected Expiry Date does not exist in the system.')}

917

# clear date

918

result['value'].update(expiry_date=False, prod_lot_id=False)

919

else:

920

# return first prodlot

921

result['value'].update(prod_lot_id=prod_ids[0])

922

923

else:

924

# clear expiry date, we clear production lot

925

result['value'].update(prod_lot_id=False,

926

expiry_date=False,

927

)

928

929

return result

930

931

def _get_checks_all(self, cr, uid, ids, name, arg, context=None):

932

'''

933

function for KC/SSL/DG/NP products

934

'''

935

result = {}

936

for id in ids:

937

result[id] = {}

938

for f in name:

939

result[id].update({f: False,})

940

941

for obj in self.browse(cr, uid, ids, context=context):

942

# keep cool

943

if obj.product_id.heat_sensitive_item:

944

result[obj.id]['kc_check'] = True

945

# ssl

946

if obj.product_id.short_shelf_life:

947

result[obj.id]['ssl_check'] = True

948

# dangerous goods

949

if obj.product_id.dangerous_goods:

950

result[obj.id]['dg_check'] = True

951

# narcotic

952

if obj.product_id.narcotic:

953

result[obj.id]['np_check'] = True

954

955

return result

956

957

def _check_batch_management(self, cr, uid, ids, context=None):

958

'''

959

check for batch management

960

'''

961

for obj in self.browse(cr, uid, ids, context=context):

962

if obj.product_id.batch_management:

963

if not obj.prod_lot_id or obj.prod_lot_id.type != 'standard':

964

return False

965

return True

966

967

def _check_perishable(self, cr, uid, ids, context=None):

968

"""

969

check for perishable ONLY

970

"""

971

for obj in self.browse(cr, uid, ids, context=context):

972

if obj.product_id.perishable and not obj.product_id.batch_management:

973

if (not obj.prod_lot_id and not obj.expiry_date) or (obj.prod_lot_id and obj.prod_lot_id.type != 'internal'):

974

return False

975

return True

976

977

def _check_prodlot_need(self, cr, uid, ids, context=None):

978

"""

979

If the inv line has a prodlot but does not need one, return False.

980

"""

981

for obj in self.browse(cr, uid, ids, context=context):

982

if obj.prod_lot_id:

983

if not obj.product_id.perishable and not obj.product_id.batch_management:

984

return False

985

return True

986

987

_columns = {'hidden_perishable_mandatory': fields.boolean(string='Hidden Flag for Perishable product',),

988

'hidden_batch_management_mandatory': fields.boolean(string='Hidden Flag for Batch Management product',),

989

'expiry_date': fields.date(string='Expiry Date'),

990

'type_check': fields.char(string='Type Check', size=1024,),

991

'kc_check': fields.function(_get_checks_all, method=True, string='KC', type='boolean', readonly=True, multi="m"),

992

'ssl_check': fields.function(_get_checks_all, method=True, string='SSL', type='boolean', readonly=True, multi="m"),

993

'dg_check': fields.function(_get_checks_all, method=True, string='DG', type='boolean', readonly=True, multi="m"),

994

'np_check': fields.function(_get_checks_all, method=True, string='NP', type='boolean', readonly=True, multi="m"),

995

}

996

997

_defaults = {# in is used, meaning a new prod lot will be created if the specified expiry date does not exist

998

'type_check': 'in',

999

}

1000

1001

_constraints = [(_check_batch_management,

1002

'You must assign a Production Lot which corresponds to Batch Number Mandatory Products.',

1003

['prod_lot_id']),

1004

(_check_perishable,

1005

'You must assign a Production Lot which corresponds to Expiry Date Mandatory Products.',

1006

['prod_lot_id']),

1007

(_check_prodlot_need,

1008

'The selected product is neither Batch Number Mandatory nor Expiry Date Mandatory',

1009

['prod_lot_id']),

1010

]

1011

1012

def on_change_product_id(self, cr, uid, ids, location_id, product, uom=False, to_date=False):

1013

'''

1014

the product changes, set the hidden flag if necessary

1015

'''

1016

result = super(stock_inventory_line, self).on_change_product_id(cr, uid, ids, location_id, product, uom, to_date)

1017

1018

# product changes, prodlot is always cleared

1019

result.setdefault('value', {})['prod_lot_id'] = False

1020

result.setdefault('value', {})['expiry_date'] = False

1021

# reset the hidden flags

1022

result.setdefault('value', {})['hidden_batch_management_mandatory'] = False

1023

result.setdefault('value', {})['hidden_perishable_mandatory'] = False

1024

if product:

1025

product_obj = self.pool.get('product.product').browse(cr, uid, product)

1026

if product_obj.batch_management:

1027

result.setdefault('value', {})['hidden_batch_management_mandatory'] = True

1028

elif product_obj.perishable:

1029

result.setdefault('value', {})['hidden_perishable_mandatory'] = True

1030

1031

return result

1032

1033

def create(self, cr, uid, vals, context=None):

1034

'''

1035

complete info normally generated by javascript on_change function

1036

'''

1037

prod_obj = self.pool.get('product.product')

1038

if vals.get('product_id', False):

1039

# complete hidden flags - needed if not created from GUI

1040

product = prod_obj.browse(cr, uid, vals.get('product_id'), context=context)

1041

if product.batch_management:

1042

vals.update(hidden_batch_management_mandatory=True)

1043

elif product.perishable:

1044

vals.update(hidden_perishable_mandatory=True)

1045

else:

1046

vals.update(hidden_batch_management_mandatory=False,

1047

hidden_perishable_mandatory=False,

1048

)

1049

# complete expiry date from production lot - needed if not created from GUI

1050

prodlot_obj = self.pool.get('stock.production.lot')

1051

if vals.get('prod_lot_id', False):

1052

vals.update(expiry_date=prodlot_obj.browse(cr, uid, vals.get('prod_lot_id'), context=context).life_date)

1053

# call super

1054

result = super(stock_inventory_line, self).create(cr, uid, vals, context=context)

1055

return result

1056

1057

def write(self, cr, uid, ids, vals, context=None):

1058

'''

1059

complete info normally generated by javascript on_change function

1060

'''

1061

prod_obj = self.pool.get('product.product')

1062

if vals.get('product_id', False):

1063

# complete hidden flags - needed if not created from GUI

1064

product = prod_obj.browse(cr, uid, vals.get('product_id'), context=context)

1065

if product.batch_management:

1066

vals.update(hidden_batch_management_mandatory=True)

1067

elif product.perishable:

1068

vals.update(hidden_perishable_mandatory=True)

1069

else:

1070

vals.update(hidden_batch_management_mandatory=False,

1071

hidden_perishable_mandatory=False,

1072

)

1073

# complete expiry date from production lot - needed if not created from GUI

1074

prodlot_obj = self.pool.get('stock.production.lot')

1075

if vals.get('prod_lot_id', False):

1076

vals.update(expiry_date=prodlot_obj.browse(cr, uid, vals.get('prod_lot_id'), context=context).life_date)

1077

1078

# call super

1079

result = super(stock_inventory_line, self).write(cr, uid, ids, vals, context=context)

1080

return result

1081

1082

stock_inventory_line()

1083

1084

class report_stock_inventory(osv.osv):

1085

'''

1086

UF-565: add group by expired_date

1087

'''

1088

_inherit = "report.stock.inventory"

1089

1090

def init(self, cr):

1091

tools.drop_view_if_exists(cr, 'report_stock_inventory')

1092

cr.execute("""

1093

CREATE OR REPLACE view report_stock_inventory AS (

1094

(SELECT

1095

min(m.id) as id, m.date as date,

1096

m.expired_date as expired_date,

1097

m.address_id as partner_id, m.location_id as location_id,

1098

m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,

1099

m.company_id,

1100

m.state as state, m.prodlot_id as prodlot_id,

1101

coalesce(sum(-pt.standard_price * m.product_qty)::decimal, 0.0) as value,

1102

CASE when pt.uom_id = m.product_uom

1103

THEN

1104

coalesce(sum(-m.product_qty)::decimal, 0.0)

1105

ELSE

1106

coalesce(sum(-m.product_qty * pu.factor)::decimal, 0.0) END as product_qty

1107

FROM

1108

stock_move m

1109

LEFT JOIN stock_picking p ON (m.picking_id=p.id)

1110

LEFT JOIN product_product pp ON (m.product_id=pp.id)

1111

LEFT JOIN product_template pt ON (pp.product_tmpl_id=pt.id)

1112

LEFT JOIN product_uom pu ON (pt.uom_id=pu.id)

1113

LEFT JOIN product_uom u ON (m.product_uom=u.id)

1114

LEFT JOIN stock_location l ON (m.location_id=l.id)

1115

GROUP BY

1116

m.id, m.product_id, m.product_uom, pt.categ_id, m.address_id, m.location_id, m.location_dest_id,

1117

m.prodlot_id, m.expired_date, m.date, m.state, l.usage, m.company_id,pt.uom_id

1118

) UNION ALL (

1119

SELECT

1120

-m.id as id, m.date as date,

1121

m.expired_date as expired_date,

1122

m.address_id as partner_id, m.location_dest_id as location_id,

1123

m.product_id as product_id, pt.categ_id as product_categ_id, l.usage as location_type,

1124

m.company_id,

1125

m.state as state, m.prodlot_id as prodlot_id,

1126

coalesce(sum(pt.standard_price * m.product_qty )::decimal, 0.0) as value,

1127

CASE when pt.uom_id = m.product_uom

1128

THEN

1129

coalesce(sum(m.product_qty)::decimal, 0.0)

1130

ELSE

1131

coalesce(sum(m.product_qty * pu.factor)::decimal, 0.0) END as product_qty

1132

FROM

1133

stock_move m

1134

LEFT JOIN stock_picking p ON (m.picking_id=p.id)

1135

LEFT JOIN product_product pp ON (m.product_id=pp.id)

1136

LEFT JOIN product_template pt ON (pp.product_tmpl_id=pt.id)

1137

LEFT JOIN product_uom pu ON (pt.uom_id=pu.id)

1138

LEFT JOIN product_uom u ON (m.product_uom=u.id)

1139

LEFT JOIN stock_location l ON (m.location_dest_id=l.id)

1140

GROUP BY

1141

m.id, m.product_id, m.product_uom, pt.categ_id, m.address_id, m.location_id, m.location_dest_id,

1142

m.prodlot_id, m.expired_date, m.date, m.state, l.usage, m.company_id,pt.uom_id

1143

)

1144

);

1145

""")

1146

1147

_columns = {'expired_date': fields.date(string='Expiry Date'),

1148

}

1149

1150

report_stock_inventory()

Older »