SqlConfig.java
7.61 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
package com.pipi.qa.sql;
public class SqlConfig {
public static final String Yy_userDao_userId = "select user_id from t_user_passport where mobile =?;";
public static final String Yy_password = "select password from t_user_passport where mobile =?;";
public static final String Yy_userDao_realName = "select real_name from yy_personal_info where user_id= ?;";
public static final String Yy_userDao_idcardNO = "select idcard_no from yy_personal_info where user_id =?;";
public static final String Yy_credit_center_add = "INSERT t_credit_auth (user_id, username, phone, idcard, source, channel, soc_status, soc_auth_time, mobile_status, mobile_auth_time, create_time) VALUES (?, ?, ?, ?, 'YourCredit', '有钱用','1',now(),1,now(),now());";
public static final String update_t_credit_auth = "update t_credit_auth t set mobile_status='1' where t.phone = ?;";
public static final String Yy_credit_center_count = "select count(1) from t_credit_auth t where t.phone = ? and t.mobile_status = 1;";
public static final String base_t_sms_send_SMS_CONTENT = "SELECT SMS_CONTENT FROM t_sms_send t where t.ID =(select max(ID) from t_sms_send where RECEIVE_MOBILE = ? )";
public static final String loan_apply_update = "update loan_apply set status = 5 where id = (select id from (select max(id) id from loan_apply where phone = ? ) la);";
public static final String delete_wechat_binding_open_id = "DELETE FROM wechat_binding WHERE open_id = ?;";
public static final String get_assistant_id="SELECT oa_id from m_outlet_assistant where oa_phone_number=?;";
public static final String del_wechat_binding_sale = "DELETE FROM yy_wechat_bound WHERE assistant_id = ?;";
public static final String business_putoutUpdate = "update business_putout bp set bp.PUTOUTSTATUS='05' WHERE bp.CONTRACTSERIALNO= ?;";
public static final String loan_apply_contract_no = "select contract_no from loan_apply t where t.id = (select id from (select max(id) id from loan_apply where phone = ? ) la);";
public static final String trade_order_contract_no = "select contract_no from t_order t where t.order_id = (select id from (select max(order_id) id from t_order where user_id = ? ) la);";
public static final String loan_apply_id = "select id from loan_apply t where t.id = (select id from (select max(id) id from loan_apply where phone = ? ) la);";
public static final String loan_apply_request_id = "select request_id from loan_apply t where t.id = (select id from (select max(id) id from loan_apply where user_id = ? ) la);";
public static final String business_contractUpdate = "UPDATE business_contract SET CONTRACTSTATUS = '3002' WHERE serialno=?;";
public static final String audit_work_orderUpdate_single ="update audit_work_order t set status = -1 where id = (select id from (select max(id) id from audit_work_order where user_id = ? ) la);";
public static final String ext_order_requestUpdate_single ="update ext_order_request t set request_status = -1 where id = (select id from (select max(id) id from ext_order_request where mobile = ? ) la);";
public static final String audit_work_orderUpdate ="update audit_work_order t set status = -1 where user_id = ?;";
public static final String findaudit_order_id ="select id from audit_work_order where request_id=?;";
public static final String ext_order_requestUpdate ="update ext_order_request t set request_status = -1 where user_id = ?;";
public static final String trade_order_update ="update t_order set order_status = 1030, contract_status = 3002 where user_id = ?;";
public static final String cl_collection_task_01 ="INSERT INTO `cl_collection_task_01` (`col_id`, `route_id`, `client_idno`, `ref_id`, `owner`, `client_name`, `col_status`, `pause_reason`, `col_priority`, `group_id`, `staff_id`, `start_htime`, `act_group_id`, `modify_version`, `remark`, `create_date`, `create_by`, `update_date`, `update_by`) VALUES ('412259781660409874', '1', ?, '500237198610147973', '0', '王安禹', '1', '0', '0', '51da4a951906cac6', 'test', '2018-02-07 14:55:01', '104', '1', 'new', '2018-02-07 14:53:34', '172.28.3.25', '2018-02-07 14:55:01', 'test');";
public static final String cl_collection_task_01_del ="DELETE FROM `cl_collection_task_01` WHERE `client_idno`=?;";
public static final String CU_PROJECT_PROJ_ID = "SELECT MAX(proj_id) \"proj_id\" FROM cus_project ORDER BY create_time DESC;";
public static final String test_service_info = "select before_service from testManagement.test_service_info t where t.after_service = ? and t.service_type = 'sc' and status = 1";
public static final String test_service_info_all = "select before_service from test_tmp.test_service_info t where t.service_type = 'sc' and status = 1";
public static final String BURIED_POINT_DATA_ADD = "INSERT INTO buried_point_data(api_name,api_path,execution_result,create_time,platform_value_code,content) VALUES(?,?,?,?,?,?);";
public static final String T_PROJECT_RESPONSE_ADD = "INSERT INTO t_project_response(request_json,execution_result,create_time,category,demId,executionRecord,user) VALUES(?,?,?,?,?,?,?);";
public static final String T_PROJECT_RESPONSE_SELECT = "SELECT * FROM `t_project_response` WHERE category = ? ORDER BY create_time DESC LIMIT ?,?;";
public static final String T_PROJECT_RESPONSE_SELECT_project = "SELECT * FROM `t_project_response` WHERE category = ? and demId like ? ORDER BY create_time DESC LIMIT ?,?;";
public static final String T_PROJECT_RESPONSE_TOTAL = "SELECT COUNT(*) AS total FROM t_project_response WHERE category = ?;";
public static final String T_PROJECT_RESPONSE_DEMID_TOTAL = "SELECT COUNT(*) AS total FROM t_project_response WHERE category = ? and demId like ?;";
public static final String to8to_members_select = "SELECT t.`account_id` FROM to8to.to8to_members t WHERE t.uid = ?";
public static final String to8to_jj_smt_zb_select = "SELECT zid FROM to8to.to8to_jj_smt_zb WHERE yid = ?";
public static final String to8to_jj_smt_zb_cost_select = "SELECT COUNT(*) FROM to8to.to8to_jj_smt_zb_cost WHERE zid = ?";
public static final String to8to_jj_smt_zb_cost_insert = "INSERT INTO `to8to`.`to8to_jj_smt_zb_cost` ( `zid`,`lbfy`,`status`,`tjjftime`,`jftime`,`qftime`,`kflevel`,`realcost`,`demo`,`uplbfy`,`fy_fcom`,`fy_kf`,`status_confirm`,`pid`,`service_source`) VALUES(?,'0', '3','0','0','0', '0', '0', '分配时间在2017年3月15号以后的项目，生成免费记录，由新版进行收取','0','0','0','0', '', '0');";
public static final String T_PROJECT_EXECUTION_RECORD_ADD = "UPDATE t_project_response SET executionRecord = ? WHERE demId = ?;";
public static final String t8t_fi_acc_select = "select * from t8t_fi_acc.`acc_account` where user_id=? and user_type_code = ? and account_type_name in(?,?,?,?)";
public static final String to8to_members_select_indentity = "SELECT indentity FROM to8to.to8to_members where uid = ?";
public static final String account_insert = "INSERT INTO `t8t_fi_acc`.`acc_account` (`organization_id`, `financial_id`, `user_id`, `parent_user_id`, `user_name`, `account_config_id`, `balance`, `self_overdraft_credit`, `overdraft_credit`, `status`, `update_user`, `update_time`, `create_user`, `create_time`, `create_by`, `create_name`, `update_by`, `update_name`, `user_type_code`, `account_type_name`, `parent_account_type_name`, `parent_user_type_code`, `frozen_balance`) VALUES ( '1', '1', ?, '0', '系统添加', ?, ?, '0.00', '0.00', '1', '172178928', '1611301348', '11282793', '1584948292', 'System', 'System', 'System', 'System', ?,?, '', '', '0.00');";
public static final String account_update = "UPDATE t8t_fi_acc.acc_account SET balance= ? WHERE user_type_code = ? AND user_id = ? AND account_type_name = ?";
}