SpeedNumCube/sncprojects/lib/SNCDataBase/sncdatabase.h

#ifndef SNCDATABASE_H
#define SNCDATABASE_H
#include <QtCore>
#include "sncdatabase_global.h"

class SNCDATABASESHARED_EXPORT SNCDataBase {
public:
    SNCDataBase();
    static bool createConnection(QString password,QString path);

    static QString getProductName();
    static QString getAppName();
    static QString getAppVersion();
    static QString getAppVersion2();
    static QString getSegVersion();
    static QString getLocalBannerAd();
    static QString getLocalBannerTopAd();
    static QString getLocalBannerBottomAd();
    static QString getCMCC();
    static QString getCUTC();
    static QString getCTCC();
    static QString getExportDir();
    static QString getAppConfigUrl();
    static QString getDataConfigUrl();
    static QString getImportDir();
    static QString getLocalCachePath();
    static QString getClientDefaultHost();
    static QString getClientDefaultPort();
    static QString getSplashTextColor();
    static QString getUpdateAppName();
    static QString getResourceName();
    static QString getSplashImageName();
    static QString getQssName();
    static QString getWebsiteUrl();
    static QString getWebsiteTitle();
    static QString getHelpmeUrl();
    static QString getRiddleUrl();
    static QString getZxshUrl();
    static QString getAppHash();
    static QString getJSJCpnumMinSize();
    static QString getJSJCpnumMaxSize();
    static QString getJSJCmonthMaxNumFree();
    static QString getJSJCmonthMaxNumPay();
    static QString getSSORegUrl();
    static QString getSSOAccountUrl();
    static QString getSSOPayUrl();
    static QString getDefaultNumchkCorp();
    static void updateSSORegUrl(QString url);
    static void updateSSOAccountUrl(QString url);
    static void updateSSOPayUrl(QString url);
    static void updateAppHash(QString apphash);
    static void updateDefaultNumchkCorp(QString corp);
    static QMap<QString,QString> getLocalTextAds();
    static QMap<QString,QString> getLocalPageAds();
    static QMap<QString,QStringList> getLocalClientConfigs();
    static QStringList getConfigServerUrls();
    static void updateBannerAd(QString banner_ad);
    static void updateBannerTopAd(QString banner_ad);
    static void updateBannerBottomAd(QString banner_ad);
    static void updateHelpmeUrl(QString helpme_url);
    static void updateWebsiteUrl(QString website_url);
    static void updateWebsiteTitle(QString website_title);
    static void updateRiddleUrl(QString url);
    static void updateTextAd(QMap<QString,QString> ads);
    static void updatePageAd(QMap<QString,QString> ads);
    static void updateClientConfig(QMap<QString,QStringList> configs,QString default_host,QString default_port);
    static void updateCorpPrefix(QMap<QString,QString> prefixes);
    static void updateConfigUrls(QStringList config_urls);
    static void updateExportDir(QString dir);
    static void updateImportDir(QString dir);
    static void updateSegInfo(QString version,QString baseSegFile,QString dynamicSegFile);
    static void updateBaseSegInfo(QString version,QString dynamicSegFile);
    static void updateDynamicSegInfo(QString checkdate,QString areacode,QString dynamicSegFile);

    static void updateDynamicSegInfo(QString checkdate,QStringList list);
        static void updateSegRecInfo(QString SegFile);// BY XXW ON 2014-9-20 FOR SEG RECOMMEND;

    static QString getAreaCodeByCityName(QString city);
    static QString getCitySegLastCheckDate(QString areacode);
    static QList<QStringList> getRegionInfo();
    static QStringList getSegmentByCityAll(QString city);
    static QStringList getSegmentByCityAndCorp(QString city,QString corp);
    static QStringList getSegmentByCityAndRange(QString city,QString start,QString end);

    static QStringList getSegmentDynamicByCityAll(QString city);
    static QStringList getSegmentDynamicByCityAndCorp(QString city,QString corp);
    static QStringList getSegmentDynamicByCityAndRange(QString city,QString start,QString end);
    static QStringList getSegmentDynamic(QString city,QString corp,int days);

    static QMap<QString,QString> groupSegmentIntoCity(QStringList segments);
    static QMap<QString,QString> groupSegmentIntoProvince(QStringList segments);
    static QMap<int ,QString> getSysSolutions();
    static QMap<int ,QString> getUserSolutions();
    static QMap<int ,QString> getAllRuleNames();
    static QList<int> getRuleIdBySysSlnID(int id);
    static QList<int> getRuleIdByUserSlnID(int id);
    static QStringList getRulesBySysSlnID(int id);
    static QStringList getRulesByUserSlnID(int id);

    static void addUserSolution(QString name,QStringList ruleids);
    static void delUserSolution(int sln_id);
    static void delUserBuildSolution(int build_id);
    static void delAllUserBuildSolution();
    static void addBuildSolution(QString build_date,QString region,int total,
                                 QString segments,QString rule_ids);
    static QList<QStringList> getAllBuildHistory();
    static QStringList getRuleContensByRuleIDs(QStringList ids);
    static QString getSegmentsGroupCount(QVariantList vars,int len);//此方法效率较低，不建议使用
    static QStringList getCityBySegment(QString segment);

    static QMap<QString,QString > getSrvParam(QString srvid);
    static void updateSrvParam(QString srvid,QMap<QString,QString> para);
    static int getSegCount();
    static QString getAuthCodeSeg();
    static QString getAuthCodeSrvtime();
    static QString getAuthCodeUrl();
    static QString getAuthCodeSyspara();
    static QString getAuthCodeEncrpt();

    //自动上传模块所需要的数据库访问接口
    static int addFileUpload(QString moduleID,QString clientID,QString userCode,QString fileName,
                             QString filePath,QString fileType,QString taskType,QString fileMemo);
    static int updateFileUploadState(int fileID,int state) ;
    static int updateFileUploadState(int fileID,int state,QString errMsg,QString errDetail);
    static int updateFileUploadSrvInfo(int fileID,QString srvID,QString srvRTime);
    static int updateFileUploadPercent(int fileID,double percent);
    static int clearFileUpload(QString moduleID,QString clientID,QString userCode);
    static int deleteFileByFileID(int fileID);
    static QMultiMap<QString,QString> getAllUpload(QString moduleID,QString clientID,QString userCode);
    static int updateFileUploadOutdateDataBySrvIDs(QString moduleID,QString clientID,QString userCode,QStringList ids);
    //实号快检模块所需要的数据库访问接口
    static int updateShkjCheckInfos(QMultiMap<QString,QString> maps,QString userCode);
        //add-on-2014-11-08 for sync zxsh-task
    static int updateZxshTaskInfos(QMultiMap<QString,QString> maps,QString userCode);
    static QMultiMap<QString,QString> getShkjCheckInfos(QString userCode);
    static QMultiMap<QString,QString> getShkjCheckInfos(QString userCode,QString dealstatus);
    static int getShkjToDown(QString userCode);
    static int updateShkjCachePath(QString srvID,QString cachePath);
    static QString getShkjCachePath(QString srvID);
    static int delShkjByID(QString srvID);
    static QMultiMap<QString,QString> getShkjZxshTasks(QString userCode,QString dealstatus);
    static QMultiMap<QString,QString> getShkjZxshTasksByUser(QString userCode);
    static int addShkjZxshTask(QString ssid, QString userCode, QString province,QString city,
                               QString inserttime,QString updatedays, QString isp, QString seg, int neednum);
    //自动登录所需要的数据库访问接口
    static int updateLoginInfo(QString userCode,QString password,QString isAuto,QString isRemember,QString lastLoginTime);
    static QMultiMap<QString,QString> getDefaultLoginInfo();

    //标准检测模块所需要的数据库访问接口
    static int updateBzjcCheckDealInfos(QMultiMap<QString,QString> maps,QString userCode,QString clientID);
    static int updateBzjcCheckFinishInfos(QMultiMap<QString,QString> maps,QString userCode,QString clientID);
    static QMultiMap<QString,QString> getBzjcCheckFinishInfos(QString userCode,QString clientID,QString isdeliver);
    static QMultiMap<QString,QString> getBzjcCheckDealingInfos(QString userCode,QString clientID);
    static int getBzjcToDown(QString userCode,QString clientID);
    static int delBzjcByID(QString srvID);
    static int updateBzjcCachePath(QString srvID,QString cachePath);
    static QString getBzjcCachePath(QString srvID);
     static int deleteBzjcFinishExceptSrvIDs(QString clientID,QString userCode,QStringList ids);
     //号码推荐获取检测接口
      static QMultiMap<QString,QString> getSegRecInfos();
      static QMultiMap<QString,QString> getSegRecInfosByCity(QString city);
      static QMultiMap<QString,QString> getSegRecInfosByProvince(QString province);
      static QStringList getSegAreaCodes();
      static QStringList getRecSegs();
};

#endif // SNCDATABASE_H