def post(self, request, format=None):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
login_d = base64.b64decode(login)
usrpwd = request.data["pw"]
usrpwd_d = base64.b64decode(usrpwd)
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d ,port=8069)
user_model = connection.get_model("res.users")
# sale = connection.get_model("sales.activity")
ids = user_model.search([("company_id", "=", 1)])
# # # print ids,"BBBBBBBBBBBBBBBBBBBBB"
# # # if ids:
# # user_info = user_model.read([0])
# test = sale.read([3401,3400])
# print test,"iniii sale order"
# # # print user_info,"----------->>>"
# # name=user_info[0]["name"]
# # else:
# name="gk ada"
# print user_info,"BBBBBBBBBBBBBBBBBBBBBBBBBB"
return Response({"success": True})
def update(request,model):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
# login_d = 'admin'
# usrpwd_d = 'supra'
# 'ids':123
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d,port=8069)
model_erp = connection.get_model(model)
# print "id=",request.data["ids"],"++++ vals =",request.data["vals"]
# idbaru = model_erp.write(3489,{
# 'beforeactualselasa':[(1,4352,{'name':'blanalnla'}),(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'})],
# # 'beforeactualselasa':[],
# # 'beforeactualrabu':[],
# # 'beforeactualkamis':[],
# # 'beforeactualjumat':[],
# })
idbaru = model_erp.write(request.data["ids"],request.data["vals"])
return Response ({"sukses":True})
def GetModel(request,model,mode=None,fields=[]):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
fields = request.data["fields"]
# login_d = 'ricky'
# usrpwd_d = 'ricky'
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d ,port=8069)
# print request.session.session_key,"ini koneksi"
model_erp = connection.get_model(model)
if mode==None:
ids = model_erp.search([],0,100)
elif mode=="ids":
ids =map(int, request.data["ids"])
elif mode=="search":
# searchfield = request.data['searchfield']
# searchoperator = request.data['searchoperator']
# searchcateg = request.data['searchcateg']
# if searchcateg.isdigit():
# searchcateg = int(request.data['searchcateg'])
# {
# 'q':[
# '|',
# ['customer','=',True],
# ['is_company','=',True],
# ]
# }
# ['|',['customer','=',True],['is_company','=',False]]
# domainxxx = request.data['q']
# {
# 'q':[
# ['login','=','Ricky'],
# ['active','=',True]
# ]
# }
# print request.data,"+================================"
ids = model_erp.search(request.data['domain'])
elif mode == "getupdate":
last_id= request.data['ids']
ids = model_erp.search([('id','>',last_id)],0,5)
else:
print "Oops! That was no valid number. Try again..."
if fields ==[]:
read_model = model_erp.read(ids)
else:
read_model = model_erp.read(ids,fields)
return Response ({"sukses":True,"Result":read_model})
def create(request,model):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d,port=8069)
model_erp = connection.get_model(model)
idbaru = model_erp.create(request.data['vals'])
return Response ({"sukses":True})
def GetJson(request,metode):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
# login_d = 'ricky'
# usrpwd_d = 'ricky'
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d ,port=8069)
model_res_user = connection.get_model('res.users')
model_res_partner = connection.get_model('res.partner')
# print request.data,"<<<<<<<<<<<"
data=[]
if metode =="AllData":
jsonrpc = openerplib.json_rpc(
'http://10.36.15.51:8069/sales_activity_plan/Getall',
'Getall',
{'db':db_setting.configrest().database_name()
}
)
for datajson in jsonrpc:
read_model_user = model_res_user.read(datajson[4],['name',"initial"])
read_res_partner=''
if datajson[10]:
read_res_partner = model_res_partner.read(datajson[10],['name'])
read_res_partner = read_res_partner['name']
if datajson[16]==1:
daylight="Before Lunch / Break"
elif datajson[16]==2:
daylight="After Lunch / Break"
else:
daylight=""
# pprint.pprint(datajson[14])
# actual_result=datajson[14].replace("b","c")
if datajson[14]!=' ':
actual_result_partner=read_res_partner
actual_result_location = datajson[11]
actual_result =datajson[14]
else:
actual_result_partner=""
actual_result=""
actual_result_location = ""
data.append({
'daylight':daylight,
'name':datajson[9],
'the_date':datajson[7],
'location':datajson[11],
'user':read_model_user['name'],
'initial':read_model_user['initial'],
'partner':read_res_partner,
'id':datajson[18],
'activity_id':datajson[0],
'user_id':datajson[4],
'dow':datajson[17],
'daylight_num':datajson[16],
'actual_result_partner':actual_result_partner,
'actual_result_location':actual_result_location,
'actual_result':actual_result,
'canceled_plan':datajson[15],
'not_planned_actual':datajson[1],
})
elif metode=="GetUpdate":
# print request.data["idview"],">>>>>>>>>>>>>>"
jsonrpc = openerplib.json_rpc(
'http://10.36.15.51:8069/sales_activity_plan/GetUpdate',
'GetID',{'db':db_setting.configrest().database_name(),
'activity_id':request.data["activity_id"],
'user_id':request.data["user_id"],
'dow':request.data["dow"],
'daylight':request.data["day_ligth"],
'idview':request.data["idview"]
}
)
for datajson in jsonrpc:
read_model_user = model_res_user.read(datajson[4],['name',"initial"])
read_res_partner=''
if datajson[10]:
read_res_partner = model_res_partner.read(datajson[10],['name'])
read_res_partner = read_res_partner['name']
if datajson[16]==1:
daylight="Before Lunch / Break"
elif datajson[16]==2:
daylight="After Lunch / Break"
else:
daylight=""
if datajson[14]!=' ':
actual_result_partner=read_res_partner
actual_result_location = datajson[11]
actual_result =datajson[14]
else:
actual_result_partner=""
actual_result=""
actual_result_location = ""
data.append({
'daylight':daylight,
'name':datajson[9],
'the_date':datajson[7],
'location':datajson[11],
'user':read_model_user['name'],
'partner':read_res_partner,
'id':datajson[18],
'activity_id':datajson[0],
'user_id':datajson[4],
'dow':datajson[17],
'daylight_num':datajson[16],
'actual_result_partner':actual_result_partner,
'actual_result':actual_result,
'canceled_plan':datajson[15],
'actual_result_partner':actual_result_partner,
'actual_result_location':actual_result_location,
'actual_result':actual_result,
'not_planned_actual':datajson[1],
'initial':read_model_user['initial'],
})
elif metode == "search":
params = request.data["params"]
# print params["fields"]
jsonrpc = openerplib.json_rpc(
'http://10.36.15.51:8069/sales_activity_plan/GetSearch',
'GetSearch',
{
'params':{
"db":db_setting.configrest().database_name(),
"fields":params["fields"],
"table":params["table"],
"condition":params["condition"],
"limit":params["limit"],
"offset":params["offset"],
"order":params["order"],
"AndOr":params["AndOr"]
}
}
)
for datajson in jsonrpc:
read_model_user = model_res_user.read(datajson[4],['name',"initial"])
read_res_partner=''
read_res_partner_actual=''
if datajson[10]:
read_res_partner = model_res_partner.read(datajson[10],['name'])
read_res_partner = read_res_partner['name']
read_res_partner_actual = model_res_partner.read(datajson[12],['name'])
read_res_partner_actual = read_res_partner_actual['name']
if datajson[16]==1:
daylight="Before Lunch / Break"
elif datajson[16]==2:
daylight="After Lunch / Break"
else:
daylight=""
# pprint.pprint(datajson[14])
# actual_result=datajson[14].replace("b","c")
data.append({
'partner_actual':read_res_partner_actual,
'location_actual':datajson[13],
'daylight':daylight,
'name':datajson[9],
'the_date':datajson[7],
'location':datajson[11],
'user':read_model_user['name'],
'initial':read_model_user['initial'],
'partner':read_res_partner,
'id':datajson[18],
'activity_id':datajson[0],
'user_id':datajson[4],
'dow':datajson[17],
'daylight_num':datajson[16],
'actual_result':datajson[14],
'canceled_plan':datajson[15],
'not_planned_actual':datajson[1],
})
return Response ({"sukses":True,"data":data})
def salestimeline(request,metode):
# print SalesActivityPlan,"iniiiiiiiiiiiiiiiiiiii",SalesActivityPlan.objects.all()
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
# login_d = 'ricky'
# usrpwd_d = 'ricky'
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d,port=8069)
model_res_user = connection.get_model('res.users')
model_res_partner = connection.get_model('res.partner')
# exp_condition = {
# "location": "Head Office", #location = "Head Office"
# # kalau array lookup = __in
# "the_date":["2015-12-08","2015-12-09"],
# "user_id":[36,53,61],
# "location":['jakarta','bekasi'], #WHERE location in ('jakarta','bekasi')
# "location": {
# "icontains":"Head Office", #location
# "in":["head","office"],
# "startswith":"Head", #location__startswith="Head" ==> location like 'Head%'
# "istartswith":"Head", #location__istartswith="Head" ==> location ilike 'Head%'
# "endswith":"Office", #location__startswith="Head" ==> location like '%Office'
# "iendswith":"Office", #location__istartswith="Head" ==> location ilike '%Office'
# },
# "the_date":{
# "range":["2015-12-01","2015-12-31"], #where the_date beetween '2015-12-01' AND '2015-12-31'
# "gt":"2015-12-01",
# "gte":"2015-12-01",
# "lt":"2015-12-01", #less than
# "lte":"2015-12-01",
# }
# }
# input
# condition = {
# # "user_id":[61,53],
# "the_date":['2015-12-01','2015-11-12']
# }
# proses
print SalesActivityPlan.objects.all(),"iniiiiiiiiiiiiiiii"
kwarg={}
for k, v in (request.data["params"])['condition'].items():
if type(v)==list:
kwarg[k+"__in"]=v
else:
kwarg[k]=v
# print kwarg,"testttttttttttttttttttttt"
# # output
# exp_kwarg = {
# "user_id__in":[61,53],
# 'the_date':'2015-12-01'
# }
if metode == "AllData":
print "aaaaa"
data_sales_act = SalesActivityPlan.objects.filter(**kwarg).order_by('-the_date')[:]
print "test"
elif metode == "GetUpdate":
data_sales_act = SalesActivityPlan.objects.filter(**kwarg)[(request.data["params"])['offset']:(request.data["params"])['limit']]# offset : limit
result =[]
for data in data_sales_act:
read_model_user = model_res_user.read(data.user_id,['name',"initial"])
read_res_partner=""
if data.partner_id:
read_res_partner = model_res_partner.read(data.partner_id,['name'])
read_res_partner = read_res_partner['name']
if data.daylight==1:
daylight="Before Lunch / Break"
elif data.daylight==2:
daylight="After Lunch / Break"
else:
daylight=""
# pprint.pprint(datajson[14])
# actual_result=datajson[14].replace("b","c")
if data.actual_partner_id !=' ':
actual_result_partner=read_res_partner
actual_result_location = data.actual_location
actual_result =data.actual_result
else:
actual_result_partner=""
actual_result=""
actual_result_location = ""
result.append({
'daylight':daylight,
'name':data.name,
'the_date':data.the_date,
'location':data.location,
'user':read_model_user['name'],
'initial':read_model_user['initial'],
'partner':read_res_partner,
'id':data.id,
'activity_id':data.activity_id,
'user_id':data.user_id,
'dow':data.dow,
'daylight_num':data.daylight,
'actual_result_partner':actual_result_partner,
'actual_result_location':actual_result_location,
'actual_result':actual_result,
'canceled_plan':data.canceled_plan,
'not_planned_actual':data.not_planned_actual,
})
# pprint.pprint(a[0])
# pprint.pprint(a[0])
# print "===========",b[0].the_date,"======",len(c),"============",len(d)
# print e[0].the_date,'-->',e[0].user_id
# print (a[0]).activity_id,"iniiiiiiiiiiiiiiiiii"
return Response ({"sukses":True,"data":result})
def createsalesplan(request):
hostname = db_setting.configrest().host()
dbname = db_setting.configrest().database_name()
login = request.data["usn"]
usrpwd = request.data["pw"]
login_d = base64.b64decode(login)
usrpwd_d = base64.b64decode(usrpwd)
# print request.data["vals"],"aaaaaaaaaaaa"
# login_d = 'admin'
# usrpwd_d = 'supra'
connection = openerplib.get_connection(hostname=hostname, database=dbname,login=login_d, password=usrpwd_d ,port=8069)
model_sales_act = connection.get_model('sales.activity')
# idbaru = model_sales_act.create({
# 'user_id':214,
# 'begin':'2016-04-18',
# 'end':'2016-04-24',
# 'beforeplansenin':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah',}),],
# 'afterplansenin':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'beforeplanselasa':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplanselasa':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'beforeplanrabu':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplanrabu':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'beforeplankamis':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplankamis':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'beforeplanjumat':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplanjumat':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ] ,
# 'beforeplansabtu':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplansabtu':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ] ,
# 'beforeplanahad':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ],
# 'afterplanahad':[(0,0,{'partner_id':1023,'location':'sunter','name':'maen dlu ah'}), ] ,
# })
idbaru = model_sales_act.create(request.data['vals'])
sales_activity_plan = model_sales_act.read(idbaru)
# print idbaru,""
modelbps = connection.get_model('before.plan.senin')
modelbas = connection.get_model('before.actual.senin')
for bps in sales_activity_plan['beforeplansenin']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.selasa')
modelbas = connection.get_model('before.actual.selasa')
for bps in sales_activity_plan['beforeplanselasa']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.rabu')
modelbas = connection.get_model('before.actual.rabu')
for bps in sales_activity_plan['beforeplanrabu']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.kamis')
modelbas = connection.get_model('before.actual.kamis')
for bps in sales_activity_plan['beforeplankamis']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.jumat')
modelbas = connection.get_model('before.actual.jumat')
for bps in sales_activity_plan['beforeplanjumat']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.sabtu')
modelbas = connection.get_model('before.actual.sabtu')
for bps in sales_activity_plan['beforeplansabtu']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('before.plan.ahad')
modelbas = connection.get_model('before.actual.ahad')
for bps in sales_activity_plan['beforeplansabtu']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.senin')
modelbas = connection.get_model('after.actual.senin')
for bps in sales_activity_plan['afterplansenin']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.selasa')
modelbas = connection.get_model('after.actual.selasa')
for bps in sales_activity_plan['afterplanselasa']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.rabu')
modelbas = connection.get_model('after.actual.rabu')
for bps in sales_activity_plan['afterplanrabu']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.kamis')
modelbas = connection.get_model('after.actual.kamis')
for bps in sales_activity_plan['afterplankamis']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.jumat')
modelbas = connection.get_model('after.actual.jumat')
for bps in sales_activity_plan['afterplanjumat']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.sabtu')
modelbas = connection.get_model('after.actual.sabtu')
for bps in sales_activity_plan['afterplansabtu']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
modelbps = connection.get_model('after.plan.ahad')
modelbas = connection.get_model('after.actual.ahad')
for bps in sales_activity_plan['afterplanahad']:
val_bps= modelbps.read(bps)
modelbas.create({
'partner_id':val_bps['partner_id'][0],
'location':val_bps['location'],
'name':"",
'plan_id':val_bps['id'],
'activity_id':val_bps['activity_id'][0]
}
)
return Response ({"sukses":True})