inbox.db.properties

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

## =============================
## SQL queries for inbox module.
## =============================

## Common variables

get_inbox_table = QX_INBOX


##
## DAOs SQL
##

## Account DAO

get_account =  SELECT AC.PKEY, MP.PROVIDER_NAME, AC.EMAIL_SERVER, AC.EMAIL_SERVER_PORT, AC.EMAIL_SERVER_FOLDER, \
  AC.LOGIN_NAME, AC.EMAIL_PASSWORD, AC.DELAY, AC.MAX_MAIL_SIZE, AC.MAX_INBOX_SIZE, AC.DELETE_EMAIL_FLAG, AC.UNREAD_EMAIL_FLAG, OWNER_ID, WORKGROUP_ID, \
  LASTUID, LASTMESSAGE_DIGEST  \
  FROM QX_ACCOUNT AC, QX_MAIL_PROVIDER MP WHERE AC.PKEY = ? and AC.ACCOUNT_PROVIDER = MP.PKEY

get_all_accounts =  SELECT AC.PKEY, MP.PROVIDER_NAME, AC.EMAIL_SERVER, AC.EMAIL_SERVER_PORT, AC.EMAIL_SERVER_FOLDER, \
  AC.LOGIN_NAME, AC.EMAIL_PASSWORD, AC.DELAY, AC.MAX_MAIL_SIZE, AC.MAX_INBOX_SIZE, AC.DELETE_EMAIL_FLAG, AC.UNREAD_EMAIL_FLAG, OWNER_ID, WORKGROUP_ID, \
  LASTUID, LASTMESSAGE_DIGEST \
  FROM  QX_ACCOUNT AC, QX_MAIL_PROVIDER MP \
  WHERE AC.ACCOUNT_PROVIDER = MP.PKEY

get_all_active_accounts =  SELECT AC.PKEY, MP.PROVIDER_NAME, AC.EMAIL_SERVER, AC.EMAIL_SERVER_PORT, AC.EMAIL_SERVER_FOLDER, \
  AC.LOGIN_NAME, AC.EMAIL_PASSWORD, AC.DELAY, AC.MAX_MAIL_SIZE, AC.MAX_INBOX_SIZE, AC.DELETE_EMAIL_FLAG, AC.UNREAD_EMAIL_FLAG, OWNER_ID, WORKGROUP_ID, \
  LASTUID, LASTMESSAGE_DIGEST \
  FROM QX_ACCOUNT AC, QX_MAIL_PROVIDER MP \
  WHERE AC.ACCOUNT_PROVIDER = MP.PKEY and AC.ACTIVE_ACC = 1 AND (AC.NEXT_CHECK_DATE < ? OR AC.NEXT_CHECK_DATE IS NULL) \
  AND AC.VALID_ACC = 1


get_valid_state = SELECT AC.VALID_ACC FROM QX_ACCOUNT AC WHERE AC.PKEY = ?
get_last_receive_date = SELECT AC.LASTRECEIVE_DATE FROM QX_ACCOUNT AC WHERE AC.PKEY = ?
update_valid_flag = UPDATE QX_ACCOUNT SET VALID_ACC = ? WHERE PKEY = ?
update_last_receive_date = UPDATE QX_ACCOUNT SET LASTRECEIVE_DATE = ?, LASTUID = ?, LASTMESSAGE_DIGEST = ? WHERE PKEY = ?
update_last_message_id = UPDATE QX_ACCOUNT SET LASTUID = ?, LASTMESSAGE_DIGEST = ? WHERE PKEY = ?
update_next_check_date = UPDATE QX_ACCOUNT SET NEXT_CHECK = ? WHERE PKEY = ?

##
## Filters SQL
##

## Reject Filter
get_account_filters = SELECT F.PKEY, F.WORD, F.FROM_ADDRESS, F.TO_ADDRESS, F.SUBJECT, F.BODY \
  FROM QX_FILTER_ACCOUNT AF, QX_EMAIL_FILTER F WHERE AF.EMAIL_FILTER = F.PKEY AND AF.ACCOUNT_ID = ?

## Routing Filter
get_routing_rules = SELECT F.PKEY, F.KEY_WORD, F.FROM_ADDRESS, F.TO_ADDRESS, F.SUBJECT, F.BODY, F.OWNER_ID, \
  F.WORKGROUP_ID, F.AUTOREPLY_ID \
  FROM QX_EMAIL_ROUTING AF, QX_EMAIL_ROUTING_RULES F \
  WHERE AF.ROUTING_RULE = F.PKEY AND AF.ACCOUNT_ID = ? ORDER BY F.PKEY ASC

get_default_routing_info = SELECT OWNER_ID, WORKGROUP_ID FROM QX_ACCOUNT WHERE PKEY = ?

## AutoReply

get_auto_reply = SELECT SUCCESSFUL_SUBJECT, SUCCESSFUL_BODY, UPDATE_SUBJECT, UPDATE_BODY, \
  FAIL_SUBJECT, FAIL_BODY FROM QX_AUTO_REPLY WHERE PKEY = ?