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})