co，注册，jbo

这是历时最长的一份sql语句，保存你经常查询的语句

-- 字典 --

select * from code_library where itemname="男"select * from code_library where codeno="PartnerType";select * from code_library where itemname like '%锁定%'select * from code_library where itemno="2003012"-- 2003012select * from code_library where codeno like "%APP%";

-- CProjectType

select projecttype from partner_project_info where partnerid="2016123000000008";-- getitemname('BailUseType',status)-- getitemname('BailUseType',usetype)

-- 自动生成id存储表

select * from object_maxsn-- UPDATE tb_name SET score=189 WHERE id=2;

-- 错误表

select * from webservice_error;

-- 配置服务表

select * from webservice_uddi where methodid like 'member.ticket.checkticket';select * from webservice_uddi where methodid like "partner.c%";

-- 验签

-- md5key,92394sdfjsdf8fdhfsd7hf-- whxchasdhsdhgasd-- hfkmpartnerselect * from webservice_merchant_translist;select * from webservice_merchant_info;select * from webservice_merchant_translist where merchantid="hfkmpartner";select * from webservice_uddi where methodid like 'partner.merchantinfo';select * from webservice_merchant_translist where methodid like 'partner.merchantinfo'; 

-- 注册

select * from webservice_uddi where methodid like 'partner.resysuserpassword%';select * from webservice_merchant_translist where methodid like 'loan.confirmapply';-- {"input":{ "check":[{"name":"loanserialno","desc":"前端贷款申请编号","required":"true"},{"name":"userid","desc":"前端用户编号","required":"true"}]},-- "transfer":"loan.submitcombined"}-- select * from o where a='' and b='';

-- 2016.11.25--


-- 数据模板管理

select * from awe_do_LIBRARY where dono="UserList";-- TradeObjectColumn 有字段注释select * from awe_do_CATALOG where dono="UserList";-- TradeObjectCatalog 类里有字段说明

-- 发送短信相关

select * from PHONE_MSG_CODE order by expirytime desc;

-- 2016.12.1-

select * from DATAOBJECT_CATALOG;select * from DATAOBJECT_GROUP;select * from DATAOBJECT_LIBRARY;

--  流程

select * from flow_catalog;-- '阶段属性,phaseattributeselect flowno,phaseno,phasedescribe,phaseattribute from flow_model;-- 2016122300000010select * from BUSINESS_APPLY where serialno="20161223160024222785994446232";-- 新增，初始化流程select * from flow_object;select * from flow_model;-- 流程流水select * from flow_task where flowno ='TicaketVerifyFlow';select * from flow_object where flowno ='TicaketVerifyFlow' order by endtime desc;-- 初始化select * from FLOW_OPINION;select * from flow_task where objectno ="20161223155459425061430146231";select * from flow_object where objectno ="20161223155459425061430146231";

--流程 模板配置

select * from BUSINESS_APPLY o,FLOW_TASK ftwhere o.serialno=ft.objectno and ft.objecttype="001"and ft.flowno="LightAmountFlow" and ft.phaseno="0010" and (ft.endtime IS NULL);-- 流水--select *  from FLOW_TASK ft where ft.objecttype="001"and ft.flowno="LightAmountFlow" and ft.phaseno="0010" and (ft.endtime IS not NULL);select * from FLOW_TASK ft where ft.objectno="20161229172623424737576535144";select * from BUSINESS_APPLY where serialno="20161229172623424737576535144";

-- 保证金

-- partner_bail，partner_bail_log，partner_bail_recordselect * from partner_bail_record,;-- relativeserialnoselect * from partner_bail_log;select * from partner_bail;-- 保证金最低限额,产品select * from product_comp_detail where compid="minbail";-- producttype,2016121500000003select * from business_type where typeno="2016121500000003";select * from PARTNER_PROJECT_INFO;

-- 2016.12.28


-- 前端贷款信息,jbo.trade

-- are.xml ,表单初始化服务

select * from LOAN_INFO;-- 额度详情select * from partner_bail;select * from BUSINESS_APPLY;select * from BUSINESS_CONTRACT;select * from partner_salesman;select bailid,inputuser, from partner_bail;

-- 2016.12.28
-- JBO配置
--  现在trade的JBO配置已经不再采用文件配置的方法了
-- 修改表结构等操作都不用管，
-- 只有新增数据表或者配置的时候需要去配置下

select * from jbo_class_define;-- inf_newsselect * from jbo_class_define where classname="ACCT_LOAN";select * from jbo_class_define where package ="jbo.partner";select * from jbo_class_define where classname="website_ticket_info";

2017/01/05 15:42:50

-- 菜单

select * from partner_menu_roleselect * from partner_menu-- 用户。角色select * from partner_userselect * from partner_roleselect * from partner_user_role

-- 12.30--
-- 商户

-- 上传图片--

select * from document_files;select * from user_account where userid="20161125130020791770190850259";-- 13113113113select * from account_detail where userid="20161125130020791770190850259";select * from document_files;delete from document_files where typeno="ShapePicImage";select typeno from partner_ticket_product o,document_files fp where ticketid="2017010600000009" and o.ticketid=fp.businessno;

-- 机构用户角色,下级机构--

-- 前端交易通知日志--

select * from LOAN_NOTICE_LOG;-- 服务地址配置--select * from are_common_property;-- http://localhost:8080/kmtrade/service/TradeService-- //本地路径--  //are.xml--  <Property name="ADMIN_TO_TRADE_URL1" value="http://localhost:8080/hf-km_trade/service/TradeService" />--  //相关表--  select * from are_common_property;-- 

-- 查询电子券和相关图像信息
-- "APPTicketImage","8004",ticketbatchid,merchantId,"01");

select *,df.filename from WEBSITE_TICKET_INFO o left join document_files dfon o.ticketbatchid=df.businessno and df.typeno="APPTicketImage" and df.treeid="8004" and df.status='1'where ticketbatchid="" and merchantid="" and status="01";select * from WEBSITE_TICKET_INFO;select * from document_files where typeno ="APPTicketImage" and treeid="8004" and status="1";select *,df.filename from WEBSITE_TICKET_INFO o left join document_files dfon o.ticketbatchid=df.businessno;

-- 这是个啥？

select substring('13345678987',1,4),concat(substring('13345678987',0,4),concat('****',substring('13345678987',7,11))) from dual;select *  from  loan_notice_log order by inputtime desc; select pb.lowerpartnerid from partner_belong pb,partner_user pu where pb.partnerid=pu.partnerid;

-- 批量轮询

select * from amartask_controller where taskid="TASK_KMBATCH";-- PutOutTicket_UNITselect * from amartask_unit where unitid="PutOutTicket_UNIT";select * from amartask_route where routeid="7";select * from amartask_route where taskid="TASK_KMBATCH" and unitid="PutOutTicket_UNIT";