def ES_apartment_contract(self):
"""
ES出租合同列表数据更新
:param number:
:return:
"""
base.consoleLog('ES出租合同列表数据更新。刷新起始日：' + base.now_time(self.number) +
" 00:00:01")
url = "http://isz.ishangzu.com/isz_base/EsController/update.action"
data = {
"time": base.now_time(self.number) + " 00:00:01",
"index": "apartment_contract_type"
}
result = interface.myRequest(url, str(data))
if result['code'] == 0:
base.consoleLog("出租合同列表ES数据查询成功！")
return
else:
base.consoleLog("出租合同列表ES数据查询不成功，结果返回：" + str(result))
return "出租合同列表ES数据查询不成功，结果返回：" + str(result)
def confirmation_down_payment(self, breach_money="2000"):
"""
违约
:param breach_money: 违约金额
:return:
"""
base.consoleLog('下定违约。房源编号：' + self.apartment_code + ' 违约金额：' +
breach_money)
# 查询定金编号id
url = "http://isz.ishangzu.com/isz_contract/EarnestController/searchEarnestList.action"
data = {
"residential_name_object_code_search": self.apartment_code,
"pageNumber": 1,
"pageSize": 50,
"sort": "create_time",
"order": "DESC",
"current_dep_id": "00000000000000000000000000000000"
}
result = interface.myRequest(url, data)["obj"]["rows"][0]
earnest_id = result["earnest_id"]
# 确认定金
url = "http://isz.ishangzu.com/isz_contract/EarnestController/confirmEarnest.action"
data = {
"receipt_date": base.now_time(),
"earnest_id": earnest_id,
"earnest_money": result["earnest_money"],
"payment_way": "BANKTRANSFER",
"receipt_name": "收据姓名",
"company": "ISZTECH"
}
results = interface.myRequest(url, data)
if results['code'] != 0:
return results['msg']
# 违约
url = "http://isz.ishangzu.com/isz_contract/EarnestController/saveEarnestBreach.action"
data = {
"breach_reason": "auto违约原因",
"breach_money": breach_money,
"earnest_id": earnest_id,
"earnest_money": result["earnest_money"]
}
result = interface.myRequest(url, data)
if result['code'] != 0:
base.consoleLog('下定违约接口执行失败！')
return result['msg']
base.consoleLog('下定违约接口执行成功！')
return
def __init__(self,contract_num,value=True):
"""
:param contract_num: 委托合同号
:param value: 是否需要交房
"""
self.now_times = base.now_time(1)
self.contract_num = contract_num
self.url = 'http://decorate.ishangzu.com/isz_decoration/DecorationFileController/uploadPhoto' #工程管理上传图片地址
for i in range(5):
try:
sql = 'SELECT project_id from new_decoration_project where info_id = (SELECT info_id from decoration_house_info where contract_num = "%s")' % self.contract_num
print(sql)
self.project_id = base.searchSQL(sql, db="isz_decoration")[0][0]
print(self.project_id)
except Exception as e:
base.consoleLog("查询委托工程信息sql报错，sql:" + sql + "错误返回：" + str(e),'e')
sleep(1)
pass
self.value = value
def decoration_list(self):
"""
硬装清单提交及验证
:return:
"""
base.consoleLog('硬装清单提交及验证')
#制定物品清单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/preview'
commonData = [
{
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "家具安装",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "10",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "100.00",
"unit_id": None,
"unit_name": "件",
"unit_price": 10,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"type_index": 0,
"fun_index": 0
}, {
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "嵌入式天花灯-改造",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "11",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "264.00",
"unit_id": None,
"unit_name": "个",
"unit_price": 24,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"fun_index": 1,
"type_index": 1
}, {
"acceptance_num": None,
"acceptance_num_this": 0,
"acceptance_time": None,
"create_time": base.time_time('second'),
"create_uid": base.get_conf('loginUser','user_id'),
"data_type": "成品安装",
"data_type_len": 26,
"decoration_detial": "明装筒灯-改造",
"deleted": 0,
"function_zone": "甲",
"function_zone_len": 100,
"hard_deliver_audit_status": None,
"order_type": None,
"predict_delivery_date": None,
"project_id": self.project_id,
"purchase_num": "12",
"purchase_order_no": None,
"remark": None,
"remark_accept": None,
"remark_detail": "",
"remark_return": None,
"replacement_order": None,
"return_name": None,
"return_num": None,
"return_num_this": 0,
"stuff_fees_change_reason": None,
"stuff_list_id": None,
"stuff_list_status": "DRAFT",
"submit_time": None,
"supplier_id": None,
"supplier_name": None,
"total_account": None,
"total_paid": "403.20",
"unit_id": None,
"unit_name": "个",
"unit_price": 33.6,
"update_time": base.time_time('second'),
"update_uid": base.get_conf('loginUser','user_id'),
"zone_type": None,
"fun_index": 1,
"type_index": 1
}
]
result = interface.myRequest(url,commonData)
if result['code'] != 0:
return result['msg']
#提交硬装清单
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/saveStuffLists'
sql = """SELECT
b.address,
a.config_order_no,
b.contract_id,
b.contract_num,
b.create_time,
b.entrust_end_date,
b.entrust_start_date,
b.house_code,
b.housekeep_mange_uid,
b.info_id,
a.project_no,
b.sign_date,
b.city_code,
b.city_name
FROM
decoration_house_info b
INNER JOIN new_decoration_project a ON a.info_id = b.info_id
AND a.project_id = '%s' """ % self.project_id
projectInfo = base.searchSQL(sql,db='isz_decoration')[0]
data = {
"newStuffList": commonData,
"project": {
"address": projectInfo[0],
"build_area": "120.00",
"cable_laying_type": "INNERPIPEINNERLINE",
"cable_laying_type_name": None,
"city_code": "330100",
"city_name": "杭州市",
"closed_water_test_result": "Y",
"complete_two_nodes": "[\"VOLUME_SCORE\",\"SURVEY_PROPERTY_DELIVERY\",\"WATER_CLOSED_TEST\",\"PROJECT_PLAN\",\"GOODS_CONFIG_LIST\"]",
"complete_two_nodes_list": ["VOLUME_SCORE", "SURVEY_PROPERTY_DELIVERY", "WATER_CLOSED_TEST",
"PROJECT_PLAN", "GOODS_CONFIG_LIST"],
"config_list_status": "CHECKED",
"config_list_status_name": "已验收",
"config_order_no": projectInfo[1],
"config_progress": "WAIT_DESIGN",
"config_progress_name": "待设计",
"config_submit_time": '%s 13:35:00' % self.now_times,
"config_submit_uid": base.get_conf('loginUser','user_id'),
"config_submit_uname": base.get_conf('loginUser','user_name'),
"construct_uid": "1610",
"construct_uname": "徐经纬",
"construct_uname_phone": "徐经纬/13105715060",
"contract_id": projectInfo[2],
"contract_num": projectInfo[3],
"contract_type": "NEWSIGN",
"contract_type_name": "新签",
"create_time": str(projectInfo[4]),
"create_uid": "8AEF8688600F30F30160257579287F96",
"current_one_node": "PROJECT_PLAN",
"decoration_style": "WUSHE_BREEZE",
"decoration_style_name": "随寓和风",
"deleted": 0,
"deliver_room_date": "1970-01-02 00:00:00.0",
"dispach_remark": "测试",
"entrust_end_date": str(projectInfo[5]),
"entrust_start_date": str(projectInfo[6]),
"entrust_type_fact": "SHARE",
"entrust_type_fact_name": "合租",
"grade": 20,
"hidden_check_date": "1970-01-02 00:00:00.0",
"house_code": projectInfo[7],
"housekeep_mange_name": None,
"housekeep_mange_uid": projectInfo[8],
"info_id": projectInfo[9],
"is_active": "Y",
"is_active_name": "是",
"one_level_nodes": "[\"PLACE_ORDER\",\"DISPATCH_ORDER\",\"SURVEY\",\"PROJECT_PLAN\",\"CONSTRUCTING\",\"PROJECT_CHECK\",\"PROJECT_COMPLETION\"]",
"order_status_name": "进程中",
"order_type_name": "新收配置订单",
"overall_check_date": "1970-01-02 00:00:00.0",
"phone": "18815286582",
"place_order_date": "2018-03-20 20:47:38",
"place_order_dep": "",
"place_order_dep_name": None,
"place_order_reason": "测试",
"place_order_uid": base.get_conf('loginUser','user_id'),
"place_order_uname": base.get_conf('loginUser','user_name'),
"plumbing_type": "INNERPIPE",
"plumbing_type_name": None,
"predict_complete_date": "",
"predict_days": 0,
"predict_hidden_check_date": '%s 00:00:00' % base.now_time(2),
"predict_overall_check_date": '%s 00:00:00' % base.now_time(2),
"predict_stuff_check_date": '%s 00:00:00' % base.now_time(2),
"predict_survey_date": '%s 09:00:00' % base.now_time(2),
"project_id": self.project_id,
"project_no": projectInfo[10],
"project_order_status": "INPROCESS",
"project_order_type": "NEW_COLLECT_ORDER",
"reform_way": "OLDRESTYLE",
"reform_way_fact": "OLDRESTYLE",
"reform_way_fact_name": "老房全装",
"reform_way_name": "老房全装",
"remark": "",
"room_toilet": "3/2",
"sign_date": str(projectInfo[11]),
"sign_name": None,
"sign_uid": "8A2152435DC1AEAA015DDE96F9276279",
"sign_user_phone": None,
"start_time": '%s 00:00:00' % base.now_time(2),
"stuff_check_date": "1970-01-02 00:00:00.0",
"stuff_list_status": "DRAFT",
"stuff_list_status_name": "待下单",
"stuff_order_no": "",
"stuff_submit_time": "1970-01-02 00:00:00.0",
"stuff_submit_uid": "",
"stuff_submit_uname": "",
"supplier_id": "8A2152435FBAEFC3015FBAEFC3000000",
"supplier_name": "测试专用硬装供应商",
"supplier_uid": "8AB398CA5FBAF072015FBB26338A0002",
"supplier_uname": "测试专用硬装员工",
"supplier_uname_phone": "测试专用硬装员工/18815286582",
"timeMap": None,
"total_paid": 0,
"two_level_nodes": "[\"VOLUME_SCORE\",\"SURVEY_PROPERTY_DELIVERY\",\"WATER_CLOSED_TEST\",\"DECORATION_CONFIG_LIST\",\"GOODS_CONFIG_LIST\",\"PROJECT_PLAN\",\"CONCEALMENT_ACCEPTANCE\",\"HARD_ACCEPTANCE\",\"ACCEPTANCE_PROPERTY_DELIVERY\",\"COST_SETTLEMENT\",\"OVERALL_ACCEPTANCE\",\"HOUSE_DELIVERY\",\"INDOOR_PICTURE\"]",
"update_time": '%s 13:35:00' % self.now_times,
"update_uid": "8AEF8688600F30F30160257579287F96",
"wall_condition": "OLDHOUSE",
"wall_condition_name": None
}
}
result = interface.myRequest(url,data)
if result['code'] != 0:
return result['msg']
#装修清单验收
geturl = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/getSuffList/%s' % self.project_id
result = interface.myRequest(geturl, method='get')
if result['code'] != 0:
return result['msg']
url = 'http://decorate.ishangzu.com/isz_decoration/NewDecorationStuffController/acceptanceAll'
acceptance_time = base.time_time('second')
data = result['obj']['newStuffList']
for stufflist in data:
stufflist['acceptance_time'] = acceptance_time
stufflist['acceptance_num_this'] = stufflist['purchase_num']
result = interface.myRequest(url, data)
if result['code'] != 0:
base.consoleLog('硬装清单提交验收接口执行失败！')
return result['msg']
base.consoleLog('硬装清单提交验收接口执行成功！')
return
def apartment_contract_collecting_money(self, value=True):
"""
出租合同首期款全部收钱
:param contract_num:
:param value:如果为真，收齐，否则收一种
:return:
"""
base.consoleLog('出租合同收首期款。出租合同号：' + self.contract_num)
try:
sql = "select contract_id from apartment_contract where contract_num = '%s'" % self.contract_num
contract_id = base.searchSQL(sql)[0][0]
except Exception as e:
base.consoleLog("查询出租合同sql报错，sql:" + sql + "错误返回" + str(e), 'e')
return str(e)
try:
sql = """SELECT
receivable_id,receivable_money
FROM
apartment_contract_receivable
WHERE
money_type IN (
"FRIST_RENT",
"FIRST_MANAGE_SERVER_FEE",
"DEPOSIT"
)
AND contract_id = '%s' and end_status = 'NOTGET'""" % contract_id
receivable_id_tuple = base.searchSQL(sql)
except Exception as e:
base.consoleLog("查询出租合同sql报错，sql:" + sql + "错误返回" + str(e), 'e')
return str(e)
if receivable_id_tuple == ():
base.consoleLog("该出租合同首期款都是已收状态")
return u"该出租合同首期款都是已收状态"
#收首期款
url = "http://isz.ishangzu.com/isz_finance/ApartmentContractReceiptsController/saveOrUpdateNewReceipts.action"
for i in range(len(receivable_id_tuple)):
if value:
data = {
"receipts_date": base.now_time(),
"company": "ISZTECH",
"bank_name": "ABC",
"bank_card_last_four": "3714",
"operation_total": float(receivable_id_tuple[i][1]),
"remark": "出租合同实收",
"receipts_money": float(receivable_id_tuple[i][1]),
"receivable_id": receivable_id_tuple[i][0],
"contract_id": contract_id,
"receipts_type": "BANKTRANSFER"
}
result = interface.myRequest(url, data)
if result['code'] != 0:
base.consoleLog('出租合同所有首期款支付接口执行失败！')
return result['msg']
else:
if i == 0:
pass
else:
data = {
"receipts_date": base.now_time(),
"company": "ISZTECH",
"bank_name": "ABC",
"bank_card_last_four": "3714",
"operation_total": int(receivable_id_tuple[i][1]),
"remark": "出租合同实收",
"receipts_money": int(receivable_id_tuple[i][1]),
"receivable_id": receivable_id_tuple[i][0],
"contract_id": contract_id,
"receipts_type": "BANKTRANSFER"
}
result = interface.myRequest(url, data)
if result['code'] != 0:
base.consoleLog('出租合同所有首期款支付接口执行失败！')
return result['msg']
base.consoleLog('出租合同收齐首期款接口执行成功!')
return