My codes :
class stock(osv.osv):
_name = "tt_stock"
_columns = {
'name': fields.char('Code',size=20,required=True),
'ten': fields.char('Name',size=100,required=True),
'loai': fields.char('Kind',size=100,required=True),
'sl': fields.integer('Number',required=True),
'ds':fields.many2one('tt_phieunhap','Danh sách'),
}
stock()
class material(osv.osv):
_name = "tt_material"
_columns = {
'name': fields.many2one('tt_stock','Code',required=True),
'ten': fields.char('Name',size=100),
'loai': fields.char('Kind',size=100),
'sl': fields.integer('Number',required=True),
'ds':fields.many2one('tt_bill','List'),
}
def onchange_nhap(self,cr,uid,ids,name,context=None):
value={}
if name:
record=self.pool.get('tt_stock').browse(cr,uid,name,context=context)
value['ten']=record.ten
value['loai']=record.loai
value['sl']=record.sl
else:
value['ten']=None
value['loai']=None
value['sl']=0
return {'value':value}
material()
class bill(osv.osv):
_name = "tt_bill"
_columns = {
'name': fields.char('Code',size=20,required=True),
'ngay':fields.date('Date'),
'danhsach': fields.one2many('tt_material','ds','Material List'),
}
bill()
When i create a new bill , i will create a list of material needed and after that i have a button to update my number in stock likes this:
Stock - begin
Code || Name || Kind || Number
1 fish food 100
2 ice-cream food 50
3 candy candy 250
Bill
Code : 1a
Date :1/1/2015
List of Material
Code || Name || Kind || Number
1 fish food 10
3 candy candy 500
and after i save its ,it will auto update the number in Stock
Stock - After
Code || Name || Kind || Number
1 fish food 110
2 ice-cream food 50
3 candy candy 750
I'm new in Openerp .Please help me to solve this ,thanks for your help .