def get_nuisanceless_product(credit_code):
"""
获取无公害产品
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_nuisanceless_product t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for nuisanceless_product in data:
obj = {}
obj['id'] = nuisanceless_product[0]
obj['proposer'] = nuisanceless_product[2] # 申请人全称
obj['license_number'] = nuisanceless_product[3] # 证书编号
obj['license_time'] = nuisanceless_product[4] # 证书有效期
obj['firm_name'] = nuisanceless_product[5] # 行业名称
obj['product_type'] = nuisanceless_product[6] # 产品类别名称
obj['compartment'] = nuisanceless_product[7] # 区划
obj['process_scale'] = nuisanceless_product[8] # 生产规模
obj['annual_output'] = nuisanceless_product[9] # 年产量（吨）
obj['annual_turnover'] = nuisanceless_product[10] # 年销售额（万元）
obj['origin_number'] = nuisanceless_product[11] # 认定产地证书编号
obj['origin_address'] = nuisanceless_product[12] # 认定产地地址
obj['company_type'] = nuisanceless_product[13] # 单位性质
obj['add_date'] = nuisanceless_product[14].__str__() # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_green_food(credit_code):
"""
获取绿色产品
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_green_food t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for geeen_food in data:
obj = {}
obj['id'] = geeen_food[0]
obj['company_name'] = geeen_food[2] # 企业名称
obj['product_name'] = geeen_food[3] # 产品名称
obj['brand_name'] = geeen_food[4] # 商标名称
obj['license_number'] = geeen_food[5] # 证书编号
obj['license_time'] = geeen_food[6] # 证书有效期
obj['business_type'] = geeen_food[7] # 业务类型
obj['enterprise_code'] = geeen_food[8] # 企业信息码
obj['compartment'] = geeen_food[9] # 区划
obj['agricultural_cooperative'] = geeen_food[10] # 农业合作社
obj['army'] = geeen_food[11] # 军队
obj['bibcock_logo'] = geeen_food[12] # 龙头企业标识
obj['add_date'] = geeen_food[13].__str__() # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_supervise_examine_case_register(credit_code):
"""
监督检查（案件登记）
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_supervise_examine_case_register t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for case_register in data:
obj = {}
obj['id'] = case_register[0]
obj['case_number'] = case_register[2] # 案件编号
obj['case_name'] = case_register[3] # 案件名称
obj['case_money'] = case_register[4] # 涉案金额
obj['start_case_time'] = case_register[5] # 立案时间
obj['end_case_time'] = case_register[6] # 结束时间
obj['penalty'] = case_register[7] # 罚款金额
obj['illegal_fact'] = case_register[8] # 违法事实
obj['judgment_basis'] = case_register[9] # 判定依据
obj['law_enforcement'] = case_register[9] # 执法单位
obj['law_enforcement_person'] = case_register[9] # 执法人员
obj['add_date'] = case_register[9] # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_administrative_supervision(credit_code):
"""
获得行政监管
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_ad_supervision t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for supervision in data:
obj = {}
obj['id'] = supervision[0]
obj['title'] = supervision[2]
obj['file_no'] = supervision[3]
obj['file_number'] = supervision[4]
obj['file_property'] = supervision[5]
obj['issuer'] = supervision[6]
obj['pubdate'] = supervision[7]
obj['file_content'] = supervision[8]
obj['add_date'] = supervision[10].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_red_black_list(credit_code):
"""
获得红黑榜
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_red_black_list t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s" order by t.is_red_black
""" % credit_code
data = utils.sql_helper(sql)
result = []
for red_black_list in data:
obj = {}
obj['id'] = red_black_list[0]
obj['is_red_black'] = red_black_list[2] # 红榜或者黑榜
obj['rank_list'] = red_black_list[3] # 上榜主体
obj['contant'] = red_black_list[4] # 联系人
obj['contant_number'] = red_black_list[5] # 联系电话
obj['year'] = red_black_list[6] # 年度
obj['rank_time'] = red_black_list[7] # 上榜时间
obj['is_repeal'] = red_black_list[8] # 是否撤销
obj['is_intranet'] = red_black_list[9] # 是否内网公示
obj['is_outer_net'] = red_black_list[10] # 是否外网公示
obj['rank_reason'] = red_black_list[11] # 上榜理由
obj['remark'] = red_black_list[12] # 备注
obj['add_date'] = red_black_list[13].__str__() # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_qualification_certificate(credit_code):
"""
获得资质证照
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_qualification_certificate t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for qualification in data:
obj = {}
obj['id'] = qualification[0]
obj['title'] = qualification[2]
obj['file_no'] = qualification[3]
obj['file_type'] = qualification[4]
obj['issuer'] = qualification[5]
obj['pubdate'] = qualification[6]
obj['valid_time'] = qualification[7]
obj['licence_content'] = qualification[8]
obj['img_url'] = qualification[9]
obj['add_date'] = qualification[10].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_registration_right(credit_code):
"""
获得双公示
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_registration_right t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for registration in data:
obj = {}
obj['id'] = registration[0]
obj['file_no'] = registration[2]
obj['file_number'] = registration[3]
obj['author'] = registration[4]
obj['pubdate'] = registration[5]
obj['file_type'] = registration[6]
obj['img_url'] = registration[7]
obj['add_date'] = registration[8].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_employee_evaluation(credit_code):
"""
获得员工评价
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_employee_evaluation t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for registration in data:
obj = {}
obj['id'] = registration[0]
obj['title'] = registration[2]
obj['file_property'] = registration[3]
obj['content'] = registration[4]
obj['general_evaluation'] = registration[5]
obj['pubdate'] = registration[6]
obj['employee'] = registration[7]
obj['add_date'] = registration[9].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_trademark_info(credit_code):
"""
获得商标信息
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_trademark t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for trademark in data:
obj = {}
obj['id'] = trademark[0]
obj['title'] = trademark[2]
obj['file_no'] = trademark[3]
obj['file_number'] = trademark[4]
obj['mark_applicant'] = trademark[5]
obj['pubdate'] = trademark[6]
obj['file_type'] = trademark[7]
obj['img_url'] = trademark[8]
obj['add_date'] = trademark[9].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_patent_info(credit_code):
"""
获得专利信息
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_patent t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for patent in data:
obj = {}
obj['id'] = patent[0]
obj['title'] = patent[2]
obj['file_no'] = patent[3]
obj['file_number'] = patent[4]
obj['patent_holder'] = patent[5]
obj['pubdate'] = patent[6]
obj['file_type'] = patent[7]
obj['authority_state'] = patent[8]
obj['img_url'] = patent[9]
obj['add_date'] = patent[10].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_media_evaluation(credit_code):
"""
获得双公示
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_media_evaluation t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for evaluation in data:
obj = {}
obj['id'] = evaluation[0]
obj['title'] = evaluation[2]
obj['file_no'] = evaluation[3]
obj['file_property'] = evaluation[4]
obj['release_media'] = evaluation[5]
obj['pubdate'] = evaluation[6]
obj['file_content'] = evaluation[7]
obj['relate_url'] = evaluation[9]
obj['add_date'] = evaluation[10].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_geography_product(credit_code):
"""
获取地理标志产品
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_geography_product t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for geography_product in data:
obj = {}
obj['id'] = geography_product[0]
obj['product_name'] = geography_product[2] # 产品名称
obj['register_time'] = geography_product[3] # 登记时间
obj['register_number'] = geography_product[4] # 登记证号
obj['add_date'] = geography_product[5] # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_supervise_examine_log(credit_code):
"""
监督检查（执法日志，巡查日志）
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_supervise_examine_log t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s" order by t.log_type
""" % credit_code
data = utils.sql_helper(sql)
result = []
for examine_log in data:
obj = {}
obj['id'] = examine_log[0]
obj['law_time'] = examine_log[2] # 执法时间
obj['law_enforcement'] = examine_log[3] # 执法单位
obj['law_enforcement_person'] = examine_log[4] # 执法人
obj['check_situation'] = examine_log[5] # 检查情况与处理意见
obj['scene_photo'] = examine_log[6] # 现场照片
obj['log_type'] = examine_log[7] # 监督检查日志类型：执法日志，巡查日志
obj['add_date'] = examine_log[8].__str__() # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_double_publicity(credit_code):
"""
获得双公示
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_double_publicity t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for publicity in data:
obj = {}
obj['id'] = publicity[0]
obj['license_number'] = publicity[2]
obj['audit_category'] = publicity[3]
obj['item_name'] = publicity[4]
obj['decide_date'] = publicity[5]
obj['limit_date'] = publicity[6]
obj['licence_content'] = publicity[7]
obj['license_authority'] = publicity[8]
obj['add_date'] = publicity[10].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_certificate_qualification(credit_code):
"""
获取合格证信息
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_certificate_qualification t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for traceability in data:
obj = {}
obj['id'] = traceability[0]
obj['company_name'] = traceability[2] # 企业名称
obj['business_license'] = traceability[3] # 营业执照
obj['compartment'] = traceability[4] # 区划
obj['contant'] = traceability[5] # 联系人
obj['contant_number'] = traceability[6] # 联系电话
obj['company_address'] = traceability[7] # 企业详细地址
obj['product_name'] = traceability[8] # 产品名称
obj['weight'] = traceability[9] # 重量
obj['issue_date'] = traceability[10] # 开具日期
obj['certificates_number'] = traceability[11] # 合格证张数
obj['certificates_preview'] = traceability[12] # 合格证预览
obj['add_date'] = traceability[13] # 添加日期
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_quality_check(credit_code):
"""
获得质量检查
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_quality_check t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for check in data:
obj = {}
obj['id'] = check[0]
obj['title'] = check[2]
obj['product_name'] = check[3]
obj['file_no'] = check[4]
obj['file_property'] = check[5]
obj['file_number'] = check[6]
obj['file_content'] = check[7]
obj['issuer'] = check[8]
obj['pubdate'] = check[9]
obj['relate_product'] = check[10]
obj['add_date'] = check[11].__str__()
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0
def get_traceability_info(credit_code):
"""
获取溯源信息
:param credit_code:
:return:
"""
try:
sql = """
select t.* from t_pc_traceability_info t
left join t_pc_base_info a on t.pc_id = a.id
where a.credit_code = "%s"
""" % credit_code
data = utils.sql_helper(sql)
result = []
for traceability in data:
obj = {}
obj['id'] = traceability[0]
obj['product_name'] = traceability[2] # 产品名称
obj['product_logo'] = traceability[3] # 产品logo
obj['ipo_time'] = traceability[4] # 上市时间
obj['production_unit'] = traceability[5] # 生产单位
obj['contact_phone'] = traceability[6] # 联系方式
obj['duty_person'] = traceability[7] # 责任人
obj['trace_code'] = traceability[8] # 追溯码
obj['main_name'] = traceability[9] # 主体名称
obj['phone'] = traceability[10] # 联系电话/手机
obj['postcode'] = traceability[11] # 邮编
obj['address'] = traceability[12] # 详细地址
obj['process_scale'] = traceability[13] # 生产规模
obj['leading_product'] = traceability[14] # 主导产品
obj['main_introduction'] = traceability[15] # 主体简介
obj['add_date'] = traceability[16] # 添加时间
result.append(obj)
return result, len(result)
except Exception, e:
return [], 0