services.db.properties

CRM源码This file describes some issues that should be implemented in future and how it should be imple

## ===================================
## SQL queries for services DAO class.
## ===================================

select_script = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPT WHERE SCRIPT_ID = ?
select_script_by_name = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPT WHERE SCRIPT_NAME = ?
select_all_script = SELECT SCRIPT_ID, SCRIPT_NAME, SCRIPT_CLASS_NAME, SCRIPT_DESCRIPTION FROM QX_SCRIPT
select_script_parameters = SELECT SCRIPT_PARAM_NAME, DEF_VALUE, REQUIRED, SCRIPT_PARAM_TYPE_ID FROM QX_SCRIPT_PARAM WHERE SCRIPT_ID = ?

delete_task = DELETE FROM QX_TASK WHERE TASK_ID = ?
update_task = UPDATE QX_TASK SET TASK_STATUS_ID = ?, NEXT_START = ? WHERE TASK_ID = ?
select_task = SELECT TASK_ID, SCRIPT_ID, TASK_NAME, TASK_STATUS_ID, DELAY, TASK_DELAYUNIT_ID, REPEAT_SIGN, AUTO_START, FIRST_START, NEXT_START FROM QX_TASK WHERE TASK_ID = ?
select_all_task = SELECT TASK_ID, SCRIPT_ID, TASK_NAME, TASK_STATUS_ID, DELAY, TASK_DELAYUNIT_ID, REPEAT_SIGN, AUTO_START, FIRST_START, NEXT_START FROM QX_TASK
select_task_parameters = SELECT SP.SCRIPT_PARAM_NAME, TP.VALUE, SP.REQUIRED, SP.SCRIPT_PARAM_TYPE_ID FROM QX_SCRIPT_PARAM SP, QX_TASK_PARAM TP WHERE TP.TASK_ID = ? AND TP.SCRIPT_PARAM_ID = SP.SCRIPT_PARAM_ID