VMSCommServer/SRC/VMSCommLib/CDS/CDSImageF.cpp

//---------------------------------------------------------------------------

#pragma hdrstop

#include "CDSImageF.h"
#include "CDSCtlrF.h"
#include "VmsUtilsF.h"
#include "VMSCommLibF.h"

//---------------------------------------------------------------------------

#pragma package(smart_init)

//---------------------------------------------------------------------------
TCDSImageCell::TCDSImageCell()
{
    IsDup = false;
}
//---------------------------------------------------------------------------

TCDSImageCell::~TCDSImageCell()
{
}
//---------------------------------------------------------------------------

//---------------------------------------------------------------------------
TCDSImage::TCDSImage()
{
    IMAG_DATA = NULL;
    IMAG_DATA = new TImage(NULL);
    UPDT_DT   = "-";
}
//---------------------------------------------------------------------------

TCDSImage::~TCDSImage()
{
    Clear();
    SAFE_DELETE(IMAG_DATA);
    FLists.RemoveAll();
}
//---------------------------------------------------------------------------
void TCDSImage::Clear()
{
    if (IMAG_DATA)
    {
        IMAG_DATA->Picture->Bitmap->FreeImage();
        IMAG_DATA->Picture->Assign(NULL);
    }
}
//---------------------------------------------------------------------------


//---------------------------------------------------------------------------
TCDSImageManager *CDSImageManager = NULL;
//---------------------------------------------------------------------------

TCDSImageManager::TCDSImageManager()
{
}
//---------------------------------------------------------------------------
TCDSImageManager::~TCDSImageManager()
{
    FLists.RemoveAll();
}
//---------------------------------------------------------------------------
int TCDSImageManager::LoadVmsSymbolInfo(TADOConnection *ADbConn)
{
    String     sQry;
    TADOQuery *pADO = NULL;
    TStream   *pStream = NULL;
    int        nSelCnt = 0;
    int        ii;

    DDBSTART;

    //SYMB_TYPE: 심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상,SBT4:대기환경등급)

    sQry = "SELECT A.*                    \r\n"
           "  FROM TB_VMS_SYMB_LIB A      \r\n"
           " WHERE A.DEL_YN = 'N'         \r\n";

    try
    {
        TCDSImage *pVmsImg;
        try
        {
            pADO = new TADOQuery(NULL);
            pADO->Connection = ADbConn;

			SQLText(pADO, sQry, true);

			SQLOpen(pADO);
            for( ; !pADO->Eof; pADO->Next())
            {
                AnsiString SYMB_LIB_NMBR = pADO->FieldByName("SYMBLIB_NMBR")->AsString;
                AnsiString UPDT_DT       = pADO->FieldByName("UPDT_DT")->AsString.Trim();
                AnsiString SYMB_TYPE     = pADO->FieldByName("SYMB_TYPE")->AsString.Trim(); //심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상,SBT4:대기환경등급)
                AnsiString sSymbolNmbr   = SYMB_LIB_NMBR + "0";                             //소통정보이미지 때문에 이미지번호에 "0" 을 추가하여 이미지번호로 사용함

				pVmsImg = FLists.Find(sSymbolNmbr);
                if (!pVmsImg)
                {
                    pVmsImg = new TCDSImage();
                    pVmsImg->SYMB_LIB_NMBR = sSymbolNmbr;
                    FLists.Push(pVmsImg->SYMB_LIB_NMBR, pVmsImg);
                }

                if (SYMB_TYPE == "SBT4")    // 대기환경등급 이미지
                {
                    TStringList *sl = new TStringList;
                    try
                    {
                        sl->Delimiter = '^';
                        sl->StrictDelimiter = true;
                        sl->DelimitedText   = pADO->FieldByName("SYMB_EXPL")->AsString.Trim();

                        for (ii = 0; ii < sl->Count; ii++)
                        {
                            if (ii < MAX_GRADE_SYNB)
                            {
                                pVmsImg->GRAD_SYMB_LIB_NMBR[ii] = sl->Strings[ii].Trim() + "0";
                            }
                        }

                        if (sl) delete sl;
                        sl = NULL;
                    }
                    catch(Exception &e)
                    {
                    }
                }
                nSelCnt++;

                AnsiString LocalFileName = "";
                AnsiString SYMB_FILE_NM  = "";
                if (SYMB_TYPE == "SBT3")
                {
                    //동영상
                    SYMB_FILE_NM = pADO->FieldByName("SYMB_FILE_NM")->AsString.Trim();
                }
                else
                {
                    SYMB_FILE_NM = pVmsImg->SYMB_LIB_NMBR;
                    switch(pVmsImg->Type)
                    {
                    case vms_image_type_bmp: SYMB_FILE_NM += ".bmp"; break;
                    case vms_image_type_gif: SYMB_FILE_NM += ".gif"; break;
                    case vms_image_type_jpg: SYMB_FILE_NM += ".jpg"; break;
                    default: break;
                    }
                }
                LocalFileName = g_sFtpImageDir + SYMB_FILE_NM;

                if (FileExists(LocalFileName) && pVmsImg->UPDT_DT == UPDT_DT)
                {
                    //심볼 파일이 로컬 경로에 존재하지 않거나
                    //심볼 업데이트 시각이 다른 경우에만
                    //심볼울 로컬 디렉토리에 저장한다.
                    continue;
                }

                pVmsImg->Type         = vms_image_type_bmp;
                pVmsImg->UPDT_DT      = UPDT_DT;
                pVmsImg->SYMB_TYPE    = SYMB_TYPE;
                pVmsImg->SYMB_FILE_NM = SYMB_FILE_NM;                                       //동영상인 경우 동영상 파일명
                pVmsImg->IMAG_SIZE    = pADO->FieldByName("IMAG_SIZE")->AsInteger;          //	N	NUMBER(10)	    Y	0		이미지 사이즈
                pVmsImg->PLAY_TM      = pADO->FieldByName("PLAY_TM")->AsInteger;            //	N	NUMBER(10)	    Y	0		동영상 플레이 시간
                pVmsImg->LocalFileName = "";     // 이미지저장명 초기화
                pVmsImg->FtpFileName   = "";     // Ftp 다운로드 명을 초기화


                pVmsImg->Clear();
                pVmsImg->FLists.RemoveAll();

                TStream *pStream = NULL;
                try
                {
                    try
                    {
                        pStream = pADO->CreateBlobStream(pADO->FieldByName("IMAG_DATA"), bmRead);
                        if (pStream && pStream->Size > 0)
                        {
                            pStream->Position = 0;
                            bool bRes = true;
                            switch(pVmsImg->Type)
                            {
                            case vms_image_type_bmp: bRes = AssignBmp(pVmsImg->IMAG_DATA, pStream); break;
                            case vms_image_type_gif: bRes = AssignGif(pVmsImg->IMAG_DATA, pStream); break;
                            case vms_image_type_jpg: bRes = AssignJpg(pVmsImg->IMAG_DATA, pStream); break;
                            default: break;
                            }

                            pVmsImg->SYMB_FILE_NM = pVmsImg->SYMB_LIB_NMBR;

                            switch(pVmsImg->Type)
                            {
                            case vms_image_type_bmp: pVmsImg->SYMB_FILE_NM += ".bmp"; break;
                            case vms_image_type_gif: pVmsImg->SYMB_FILE_NM += ".gif"; break;
                            case vms_image_type_jpg: pVmsImg->SYMB_FILE_NM += ".jpg"; break;
                            default: break;
                            }

                            pVmsImg->LocalFileName = g_sFtpImageDir + pVmsImg->SYMB_FILE_NM;
                            pVmsImg->FtpFileName   = AnsiString(FTP_IMAGE) + "\\" + pVmsImg->SYMB_FILE_NM;
                            AnsiString BackupFileName = pVmsImg->LocalFileName+".bak";
                            if (FileExists(pVmsImg->LocalFileName))
                            {
                                try {
                                    DeleteFile(pVmsImg->LocalFileName);
                                    //MoveFile(pVmsImg->LocalFileName.c_str(), BackupFileName.c_str());
                                } catch(Exception &) {}
                            }

                            switch(pVmsImg->Type)
                            {
                            case vms_image_type_bmp: bRes = SaveToFileBmp(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                            case vms_image_type_gif: bRes = SaveToFileGif(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                            case vms_image_type_jpg: bRes = SaveToFileJpg(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                            default: break;
                            }

                            if (!bRes)
                            {
                                //if (FileExists(BackupFileName))
                                //{
                                //    MoveFile(BackupFileName.c_str(), pVmsImg->LocalFileName.c_str());
                                //}
                                pVmsImg->LocalFileName = "";
                                pVmsImg->FtpFileName   = "";
                            }
                        }
                    }
                    catch(Exception &e)
                    {
                        pVmsImg->LocalFileName = "";
                        pVmsImg->FtpFileName   = "";
                    }
                }
                __finally
                {
                    SAFE_DELETE(pStream);
                }

                if (pVmsImg->SYMB_TYPE == "SBT3")    //심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상)
                {
                    //위에서 이미지저장하기 위해 파일명을 변경하기 때문에 여기서 동영상 파일명을 다시 읽어온다
                    pVmsImg->SYMB_FILE_NM  = pADO->FieldByName("SYMB_FILE_NM")->AsString.Trim(); //동영상인 경우 동영상 파일명
                    pVmsImg->LocalFileName = g_sFtpVideoDir + pVmsImg->SYMB_FILE_NM;
                    pVmsImg->FtpFileName   = AnsiString(FTP_VIDEO) + "\\" + pVmsImg->SYMB_FILE_NM; // Ftp 다운로드 명을 설정
#if 0
                    if (FileExists(pVmsImg->LocalFileName))
                    {
                        try {
                        //    DeleteFile(pVmsImg->LocalFileName);
                        } catch(Exception &) {}
                    }
                    else
                    {
                        TMemoryStream *Stream1 = (TMemoryStream *)pADO->CreateBlobStream(pADO->FieldByName("AVI_DATA"), bmRead);
                        try
                        {
                            try {
                                Stream1->SaveToFile(pVmsImg->LocalFileName);
                            } catch(Exception &) {
                                pVmsImg->FtpFileName = "";
                            }
                        }
                        __finally
                        {
                            SAFE_DELETE(pStream);
                        }
                    }
#endif
                }
                else
                if (pVmsImg->SYMB_TYPE == "SBT2")    //심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상)
                {
                    //소통정보 등급에 따른 이미지를 새롭게 추가한다.
                    for (int nTrf = 1; nTrf <= 3; nTrf++)
                    {
                        sSymbolNmbr = SYMB_LIB_NMBR + AnsiString(nTrf);

                        //좌표가 바뀌더라도 셀정보에서 업데이트 한다. 이미지내용이 바뀌는 경우는 없다
                        //여기서는 일단 메모리에만 이미지정보를 생성한후 셀좌표에 따른 색깔을  LoadVmsSymbolCellInfo 함수에서 입힌후
                        //마지막에 파일로 저장한다.
                        TCDSImage* pTmpImg = FLists.Find(sSymbolNmbr);
                        if (pTmpImg) continue;  // 있으면 처리하지 않음

                        pTmpImg = new TCDSImage();
                        pTmpImg->SYMB_LIB_NMBR = sSymbolNmbr;
                        FLists.Push(pTmpImg->SYMB_LIB_NMBR, pTmpImg);

                        pTmpImg->Type         = pVmsImg->Type;
                        //pTmpImg->UPDT_DT      = pVmsImg->UPDT_DT;     //여기는 셀정보를 업데이트할때 사용하기 위해 설정하지 않는다
                        pTmpImg->SYMB_TYPE    = pVmsImg->SYMB_TYPE;
                        pTmpImg->SYMB_FILE_NM = pVmsImg->SYMB_FILE_NM; //동영상인 경우 동영상 파일명
                        pTmpImg->IMAG_SIZE    = pVmsImg->IMAG_SIZE;    //	N	NUMBER(10)	    Y	0		이미지 사이즈
                        pTmpImg->PLAY_TM      = pVmsImg->PLAY_TM;      //	N	NUMBER(10)	    Y	0		동영상 플레이 시간
                        pTmpImg->LocalFileName = "";     // 이미지저장명 초기화
                        pTmpImg->FtpFileName   = "";     // Ftp 다운로드 명을 초기화

                        pTmpImg->Clear();
                        pTmpImg->FLists.RemoveAll();

                        TStream *pTrfStream = NULL;
                        try
                        {
                            try
                            {
                                pTrfStream = pADO->CreateBlobStream(pADO->FieldByName("IMAG_DATA"), bmRead);
                                if (pTrfStream && pTrfStream->Size > 0)
                                {
                                    pTrfStream->Position = 0;
                                    switch(pTmpImg->Type)
                                    {
                                    case vms_image_type_bmp: AssignBmp(pTmpImg->IMAG_DATA, pTrfStream); break;
                                    case vms_image_type_gif: AssignGif(pTmpImg->IMAG_DATA, pTrfStream); break;
                                    case vms_image_type_jpg: AssignJpg(pTmpImg->IMAG_DATA, pTrfStream); break;
                                    default: break;
                                    }

                                    pTmpImg->SYMB_FILE_NM = pTmpImg->SYMB_LIB_NMBR;
                                    switch(pTmpImg->Type)
                                    {
                                    case vms_image_type_bmp: pTmpImg->SYMB_FILE_NM += ".bmp"; break;
                                    case vms_image_type_gif: pTmpImg->SYMB_FILE_NM += ".gif"; break;
                                    case vms_image_type_jpg: pTmpImg->SYMB_FILE_NM += ".jpg"; break;
                                    default: break;
                                    }

                                    pTmpImg->LocalFileName = g_sFtpImageDir + pTmpImg->SYMB_FILE_NM;
                                    pTmpImg->FtpFileName   = AnsiString(FTP_IMAGE) + "\\" + pTmpImg->SYMB_FILE_NM;
                                }
                            }
                            catch(Exception &e)
                            {
                                pTmpImg->LocalFileName = "";
                                pTmpImg->FtpFileName   = "";
                            }
                        }
                        __finally
                        {
                            SAFE_DELETE(pTrfStream);
                        }
                    }
                }
            }
        }
        catch(EDatabaseError &E)
        {
            DBERROR(String(E.ClassName()), E.Message, sQry);
            return -1;
        }
        catch(Exception &e)
        {
            DBERROR(String(e.ClassName()), e.Message, sQry);
            return -1;
        }
    }
    __finally
    {
        SQLFree(pADO);
    }

    if (LoadVmsSymbolCellInfo(ADbConn) < 0)
    {
        return -1;
    }

#if 0
    //FTP로 다운로드 해야 하기 때문에 파일로 저장해야 한다.
    //소통정보 이미지 같은 경우 디비에는 하나만 등록하고 읽어서 처리할때 소통등급별 이미지를 만들어서
    //소통등급별로 이미지를 만든다.
    //모든 이미지는 최초 한번만 로컬에 파일로 저장하도록 하고 소통정보 이미지인 경우에만 셀정보가 바뀔수 있기 때문에
    //새롭게 저장하도록 하자
    FOR_STL(TCDSImage*, pVmsImg, FLists)
    {
        MINFO("DCOM IMAGE: %s, %s, %s", pVmsImg->SYMB_LIB_NMBR.c_str(), pVmsImg->LocalFileName.c_str(), pVmsImg->FtpFileName.c_str());

        if (pVmsImg->SYMB_TYPE != "SBT2") continue; // 소통정보 이미지가 아닌경우 이미 위에서 저장 했음

        if (pVmsImg->SYMB_LIB_NMBR.ToIntDef(0) % 10)    // <== 요거는 원본 이미지가 아닌경우, 마지막심벌자리가 0(원본), 1(원활), 2(지체), 3(정체) 로 저장됨
        {
            //소통정보 원본 이미지는 이미 저장했으니까 소통등급에 따른 이미지만 여기서 저장
            bool bFail = false;
            try
            {
                //기존에 있으면 삭제한다.
                AnsiString BackupFileName = pVmsImg->LocalFileName+".bak";
                if (FileExists(pVmsImg->LocalFileName))
                {
                    try {
                        //DeleteFile(pVmsImg->LocalFileName);
                        MoveFile(pVmsImg->LocalFileName.c_str(), BackupFileName.c_str());
                    } catch(Exception &) {}
                }

                bool bRes = true;
                switch(pVmsImg->Type)
                {
                case vms_image_type_bmp: bRes = SaveToFileBmp(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                case vms_image_type_gif: bRes = SaveToFileGif(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                case vms_image_type_jpg: bRes = SaveToFileJpg(pVmsImg->IMAG_DATA, pVmsImg->LocalFileName); break;
                default: break;
                }

                if (!bRes)
                {
                    if (FileExists(BackupFileName))
                    {
                        MoveFile(BackupFileName.c_str(), pVmsImg->LocalFileName.c_str());
                    }
                }
            }
            catch(Exception &e)
            {
                pVmsImg->LocalFileName = "";
                pVmsImg->FtpFileName   = "";
                bFail = true;
            }

            if (bFail)
            {
                if (FileExists(pVmsImg->LocalFileName))
                {
                    try {
                        DeleteFile(pVmsImg->LocalFileName);
                    } catch(Exception &) {}
                }
            }
        }
    }
#endif

    CtlrItr it;
    for(it=CDSCtlrManager->FLists.FObjects.begin(); it != CDSCtlrManager->FLists.FObjects.end(); ++it)
    {
        TCDSCtlr *pObj = (TCDSCtlr*)it->second;

        pObj->FSymbolDownload = true;
    }

    IDBSTOP(nSelCnt);
    return nSelCnt;
}
//---------------------------------------------------------------------------
int TCDSImageManager::LoadVmsSymbolCellInfo(TADOConnection *ADbConn)
{
    String     sQry;
    TADOQuery *pADO = NULL;
    int        nSelCnt = 0;

    DDBSTART;

    sQry = "SELECT B.*, A.UPDT_DT                     \r\n"
           "  FROM TB_VMS_SYMB_LIB  A,                \r\n"
           "       TB_VMS_SYMB_IFSC B                 \r\n"
           " WHERE A.SYMBLIB_NMBR = B.SYMBLIB_NMBR    \r\n"
           " ORDER BY B.SYMBLIB_NMBR, B.CELL_ID       \r\n";

    try
    {
        TCDSImage     *pVmsImg;
        TCDSImageCell *pImgCell;
        try
        {
            pADO = new TADOQuery(NULL);
            pADO->Connection = ADbConn;

			SQLText(pADO, sQry, true);

			SQLOpen(pADO);
            for( ; !pADO->Eof; pADO->Next())
            {
                AnsiString UPDT_DT       = pADO->FieldByName("UPDT_DT")->AsString.Trim();
                AnsiString SYMB_LIB_NMBR = pADO->FieldByName("SYMBLIB_NMBR")->AsString.Trim();
                AnsiString sSymbolNmbr   = SYMB_LIB_NMBR + "0";   //소통정보이미지 때문에 이미지번호에 "0" 을 추가하여 이미지번호로 사용함

				pVmsImg = CDSImageManager->FLists.Find(sSymbolNmbr);
                if (!pVmsImg)
                {
                    continue;
                }

                pImgCell = new TCDSImageCell();

                pImgCell->SYMB_LIB_NMBR = sSymbolNmbr;
                pImgCell->CELL_ID       = pADO->FieldByName("CELL_ID")->AsInteger;
                pImgCell->POSX          = pADO->FieldByName("POSX")->AsInteger;
                pImgCell->POSY          = pADO->FieldByName("POSY")->AsInteger;
                pImgCell->VMS_IFSC_ID   = pADO->FieldByName("VMS_IFSC_ID")->AsString;
                pImgCell->IsDup         = false;

                FOR_STL(TCDSImageCell*, pDup, pVmsImg->FLists)
                {
                    if (pDup->VMS_IFSC_ID == pImgCell->VMS_IFSC_ID)
                    {
                        pImgCell->IsDup = true;
                        break;
                    }
                }
                pVmsImg->FLists.Push(pImgCell->CELL_ID, pImgCell);

                //소통정보 이미지인 경우(원활,지체,정체 이미지 생성)
                if (pVmsImg->SYMB_TYPE == "SBT2") //심벌 유형(SBT0:일반심벌이미지,SBT1:소통정보배경,SBT2:소통정보이미지,SBT3:동영상,SBT4:대기환경등급)
                {
                    for (int nTrf = 1; nTrf <= 3; nTrf++)
                    {
                        sSymbolNmbr = SYMB_LIB_NMBR + AnsiString(nTrf);

                        TCDSImage *pTmpImg = CDSImageManager->FLists.Find(sSymbolNmbr);
                        if (!pTmpImg) continue;

                        if (FileExists(pTmpImg->LocalFileName) && pTmpImg->UPDT_DT == UPDT_DT)
                        {
                            //변경된게 없으므로 저장하지 않는다.
                            continue;
                        }

                        pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->Lock();
                        try
                        {
                            pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->Brush->Color = GradeToFillColor(nTrf);
                            TColor clColor = pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->Pixels[pImgCell->POSX][pImgCell->POSY];
                            if (clColor == clWhite)
                            {
                                pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->Brush->Color = clWhite;
                            }
                            pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->FloodFill(pImgCell->POSX, pImgCell->POSY, clColor, fsSurface);
                        }
                        __finally
                        {
                            pTmpImg->IMAG_DATA->Picture->Bitmap->Canvas->Unlock();
                        }

                        //소통정보 소통등급 이미지를 로컬에 저장한다.
                        bool bRes = true;
                        AnsiString BackupFileName = pTmpImg->LocalFileName+".bak";
                        if (FileExists(pTmpImg->LocalFileName))
                        {
                            try {
                                DeleteFile(pTmpImg->LocalFileName);
                                //MoveFile(pTmpImg->LocalFileName.c_str(), BackupFileName.c_str());
                            } catch(Exception &) {}
                        }

                        switch(pTmpImg->Type)
                        {
                        case vms_image_type_bmp: bRes = SaveToFileBmp(pTmpImg->IMAG_DATA, pTmpImg->LocalFileName); break;
                        case vms_image_type_gif: bRes = SaveToFileGif(pTmpImg->IMAG_DATA, pTmpImg->LocalFileName); break;
                        case vms_image_type_jpg: bRes = SaveToFileJpg(pTmpImg->IMAG_DATA, pTmpImg->LocalFileName); break;
                        default: break;
                        }

                        if (bRes)
                        {
                            pTmpImg->UPDT_DT = UPDT_DT;
                        }
                        else
                        {
                            if (FileExists(BackupFileName))
                            {
                                MoveFile(BackupFileName.c_str(), pTmpImg->LocalFileName.c_str());
                            }
                            pTmpImg->LocalFileName = "";
                            pTmpImg->FtpFileName   = "";
                        }
                    }
                }
                pVmsImg->UPDT_DT = UPDT_DT;

                nSelCnt++;
            }
        }
        catch(EDatabaseError &E)
        {
            DBERROR(String(E.ClassName()), E.Message, sQry);
            return -1;
        }
        catch(Exception &e)
        {
            DBERROR(String(e.ClassName()), e.Message, sQry);
            return -1;
        }
    }
    __finally
    {
        SQLFree(pADO);
    }

    IDBSTOP(nSelCnt);
    return nSelCnt;
}
//---------------------------------------------------------------------------