def get_product_template_by_id(*args, **kwargs):
product_id = kwargs["product_id"]
query_params = dict(id=product_id, )
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("Product")
if utils.has_obj(xmlrpcclient, query_params):
[product_obj] = utils.read_obj(xmlrpcclient, query_params)
product_tmpl_id = tuple(product_obj["product_tmpl_id"])[0]
else:
return None
query_params = dict(id=product_tmpl_id, )
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ProductTemplate")
if utils.has_obj(xmlrpcclient, query_params):
product_template_obj = utils.read_obj(xmlrpcclient, query_params)
else:
return None
return product_template_obj[0]
def get_purchase_order_line_list(order_id):
query_params = dict(order_id=order_id, )
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("PurchaseOrderLine")
if utils.has_obj(xmlrpcclient, query_params):
purhase_order_line_list = utils.read_obj(xmlrpcclient, query_params)
return purhase_order_line_list
else:
return []
def get_purchase_order_line_list(order_id):
query_params = dict(
order_id = order_id,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("PurchaseOrderLine")
if utils.has_obj(xmlrpcclient,query_params):
purhase_order_line_list = utils.read_obj(xmlrpcclient,query_params)
return purhase_order_line_list
else :
return []
def get_product_template_by_id(*args,**kwargs):
product_id = kwargs["product_id"]
query_params = dict(
id = product_id,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("Product")
if utils.has_obj(xmlrpcclient,query_params):
[product_obj] = utils.read_obj(xmlrpcclient,query_params)
product_tmpl_id = tuple(product_obj["product_tmpl_id"])[0]
else :
return None
query_params = dict(
id = product_tmpl_id,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ProductTemplate")
if utils.has_obj(xmlrpcclient,query_params):
product_template_obj = utils.read_obj(xmlrpcclient,query_params)
else :
return None
return product_template_obj[0]
def get_shippping_data(*args,**options):
start_time, end_time = utils.get_report_time(delta=options.get("delta", 0))
extra_query_params = dict(
start_time=("create_date", ">=", start_time),
end_time=("create_date", "<=", end_time),
)
query_params = dict()
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiShipping")
shipping_list = utils.read_obj(xmlrpcclient, query_params, extra_query_params)
print shipping_list
return shipping_list
def get_product_template(*args,**kwargs):
sku = kwargs["sku"]
query_params = dict(
sku = sku,
categ_id=settings.PRODUCT_CATEGRAY_ID,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ProductTemplate")
if utils.has_obj(xmlrpcclient, query_params):
result = utils.read_obj(xmlrpcclient,query_params)
else:
good = None
return result[0]
def get_shippping_data(*args, **options):
start_time, end_time = utils.get_report_time(delta=options.get("delta", 0))
extra_query_params = dict(
start_time=("create_date", ">=", start_time),
end_time=("create_date", "<=", end_time),
)
query_params = dict()
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiShipping")
shipping_list = utils.read_obj(xmlrpcclient, query_params,
extra_query_params)
print shipping_list
return shipping_list
def get_product_template(*args, **kwargs):
sku = kwargs["sku"]
query_params = dict(
sku=sku,
categ_id=settings.PRODUCT_CATEGRAY_ID,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ProductTemplate")
if utils.has_obj(xmlrpcclient, query_params):
result = utils.read_obj(xmlrpcclient, query_params)
else:
good = None
return result[0]
def get_purchase_order_list(*args, **kwargs):
start_time, end_time = utils.get_report_time(delta=kwargs.get("delta", 0))
extra_query_params = dict(
start_time=("create_date", ">=", start_time),
end_time=("create_date", "<=", end_time),
)
query_params = dict(partner_id=settings.DHUI_PARTNER_ID, )
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("PurchaseOrder")
purchase_order_list = utils.read_obj(xmlrpcclient, query_params,
extra_query_params)
print purchase_order_list
return purchase_order_list
def get_purchase_order_list(*args,**kwargs):
start_time, end_time = utils.get_report_time(delta=kwargs.get("delta",0))
extra_query_params = dict(
start_time=("create_date",">=", start_time),
end_time=("create_date","<=", end_time),
)
query_params = dict(
partner_id=settings.DHUI_PARTNER_ID,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("PurchaseOrder")
purchase_order_list = utils.read_obj(xmlrpcclient, query_params, extra_query_params)
print purchase_order_list
return purchase_order_list
def get_sale_order_list(*args,**kwargs):
start_time , end_time = utils.get_report_time(datetime.datetime.now(),delta=kwargs.get("delta",0))
extra_query_params = dict(
start_time = ("order_purchase_time",">=",start_time),
end_tme = ("order_purchase_time","<=",end_time),
state=("state", "=", "manual"),
)
query_params = dict(
partner_id=settings.COMMON_CUSTOMER_ID,
user_id=settings.DHUI_MANAGER_USER_ID,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("SaleOrder")
sale_order_list = utils.read_obj(xmlrpcclient,query_params,extra_query_params)
# print sale_order_list
return sale_order_list
def get_sale_order_list(*args, **kwargs):
start_time, end_time = utils.get_report_time(datetime.datetime.now(),
delta=kwargs.get("delta", 0))
extra_query_params = dict(
start_time=("order_purchase_time", ">=", start_time),
end_tme=("order_purchase_time", "<=", end_time),
state=("state", "=", "manual"),
)
query_params = dict(
partner_id=settings.COMMON_CUSTOMER_ID,
user_id=settings.DHUI_MANAGER_USER_ID,
)
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("SaleOrder")
sale_order_list = utils.read_obj(xmlrpcclient, query_params,
extra_query_params)
# print sale_order_list
return sale_order_list
def get_task_list(*args,**options):
user_id = options.get("user_id",None)
if user_id == None :
return []
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ResUsers")
query_params = dict(
user_id = user_id,
)
if utils.has_obj(xmlrpcclient,query_params):
[uid] = xmlrpcclient.search(query_params)
else:
return []
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiTask")
task_id_list = []
query_params = dict(
create_uid = uid,
)
create_id_task_list = xmlrpcclient.search(query_params)
query_params = dict(
user_id = uid,
)
part_id_task_list = xmlrpcclient.search(query_params)
query_params = dict(
reviewer_id = uid,
)
review_id_task_list = xmlrpcclient.search(query_params)
task_id_list.extend(create_id_task_list)
task_id_list.extend(part_id_task_list)
task_id_list.extend(review_id_task_list)
task_id_list = list(set(task_id_list))
query_params = dict(
id_list = task_id_list,
field_list = ["id","create_date","date_end","create_uid","user_id",
"data_start","progress","project_id","description",
"active","name","date_deadline","reviewer_id",
"total_hours","remaining_hours","group_type"]
)
task_list = utils.read_obj(xmlrpcclient,query_params)
return task_list
def get_good_invoice_data(*args,**options):
start_time, end_time = utils.get_report_time(delta=options.get("delta", 0))
invoice_xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiInvoice")
extra_query_params = dict(
start_time=("create_time", ">=", start_time),
end_tme=("create_time", "<=", end_time),
)
query_params = {}
good_invoice_list = utils.read_obj(invoice_xmlrpcclient, query_params, extra_query_params)
good_invoice_data = []
for good_invoice in good_invoice_list :
good_invoice_data.append(dict(
_id=good_invoice["_id"],
create_time=good_invoice["create_time"],
partner_id=good_invoice["partner_id"][1],
deliver_status=u'未发货' if good_invoice["deliver_status"] == False else u'已发货'
))
return good_invoice_data
def get_good_invoice_data(*args, **options):
start_time, end_time = utils.get_report_time(delta=options.get("delta", 0))
invoice_xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiInvoice")
extra_query_params = dict(
start_time=("create_time", ">=", start_time),
end_tme=("create_time", "<=", end_time),
)
query_params = {}
good_invoice_list = utils.read_obj(invoice_xmlrpcclient, query_params,
extra_query_params)
good_invoice_data = []
for good_invoice in good_invoice_list:
good_invoice_data.append(
dict(_id=good_invoice["_id"],
create_time=good_invoice["create_time"],
partner_id=good_invoice["partner_id"][1],
deliver_status=u'未发货'
if good_invoice["deliver_status"] == False else u'已发货'))
return good_invoice_data
def get_task_list(*args, **options):
user_id = options.get("user_id", None)
if user_id == None:
return []
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("ResUsers")
query_params = dict(user_id=user_id, )
if utils.has_obj(xmlrpcclient, query_params):
[uid] = xmlrpcclient.search(query_params)
else:
return []
xmlrpcclient = xmlrpc_client.get_xmlrpcclient("DhuiTask")
task_id_list = []
query_params = dict(create_uid=uid, )
create_id_task_list = xmlrpcclient.search(query_params)
query_params = dict(user_id=uid, )
part_id_task_list = xmlrpcclient.search(query_params)
query_params = dict(reviewer_id=uid, )
review_id_task_list = xmlrpcclient.search(query_params)
task_id_list.extend(create_id_task_list)
task_id_list.extend(part_id_task_list)
task_id_list.extend(review_id_task_list)
task_id_list = list(set(task_id_list))
query_params = dict(id_list=task_id_list,
field_list=[
"id", "create_date", "date_end", "create_uid",
"user_id", "data_start", "progress", "project_id",
"description", "active", "name", "date_deadline",
"reviewer_id", "total_hours", "remaining_hours",
"group_type"
])
task_list = utils.read_obj(xmlrpcclient, query_params)
return task_list