autobuild-tools/code/sys_nicmonitor/include/db_api/odb_apiop.h

/*******************************************************************************
ModuleName:   ODB Real Time Database management system
FileName:	  odb_api.h
DESCRIPTION:  general function declaration
FUNCTION LIST:
COMMENT:	  public application
History:
Date          Version     Modifier                Activities
2004-06-25    1.1         						add context_no parameter
2003-05-28    1.0                              modify
================================================================================
2003-05-28    1.0                              created
*******************************************************************************/

#ifndef __ODB_APIOP_H__
#define __ODB_APIOP_H__

#ifndef	__ODB_TABLEOP_H__
#include "db_api/odb_tableop.h"
#endif

#ifdef _WINDOWS64
#ifdef ODB_API_LIB_EXPORTS
#define ODB_API_LIB_API __declspec(dllexport)
#else
#define ODB_API_LIB_API __declspec(dllimport)
#endif
#else
#define ODB_API_LIB_API
#endif

using namespace std;

namespace ODB
{
typedef vector<int>  IntVec;

typedef struct
{
	int slice_no;
	int type;
	CTableOp	*m_pColOp;
	CTableOp	*m_pMenuOp;
	
	string            m_ScenarioName        ;
	int               m_ScenarioInstance    ;
	string            m_SubScenarioName     ;
	int               m_SubScenarioInstance ;
	
} TApiOpPriv;

class ODB_API_LIB_API CApiOp: public CTableBase
{
public:
	CApiOp();
	CApiOp ( const int app_no , const short context_no = 0);
	CApiOp ( const int app_no, const int table_no , const short context_no = 0);
	~CApiOp();

	int Open (const int app_no, const int table_no, const short context_no = 0);
	int Open (const int table_no);
	int SetAppNo (const int app_no, const short context_no = 0);
	int SetScenario(const std::string& scenario_name,
                        const int scenario_inst_name,
                        const std::string& sub_scenario_name,
                        const int sub_scenario_inst_name);
	int SetScenario(const int scenario_no,
                        const int scenario_inst_no,
                        const int sub_scenario_no,
                        const int sub_scenario_inst_no);
	int SetAppNo(const std::string& scenario_name,
                        const int scenario_inst_name,
                        const std::string& sub_scenario_name,
                        const int sub_scenario_inst_name);
	int SetSliceNo(int slice_no);	

public:
	int	MenuRead(const char* menu_name, std::vector<struct MENU_INFO>& vec_menu, const int menu_status=MENU_ON);
	int	MenuRead(const char* menu_name, char** buf_ptr, int& buf_size, const int menu_status=MENU_ON);//obsolete

	//
	int TableReleMenuRead (const int table_no, const int field_no );
	int TableReleMenuRead(const int table_no, const int field_no, std::vector<struct MENU_RELEVANT>& vec_menu);
	int TableReleMenuRead(const int table_no, std::vector<struct MENU_RELEVANT>& vec_menu);

	int TableReleMenuRead(const int table_no, const int field_no, char** buf_ptr, int& buf_size);//obsolete
	int TableReleMenuRead(const int table_no, char** buf_ptr, int& buf_size);//obsolete

	//
	int	GetRefMenuString(const int table_no, std::vector<struct MENU_STRING>& vec_menu);
    int GetRefMenuString(const vector<int> vec_table, std::vector<struct MENU_STRING>& vec_menu);
	int	GetRefMenuString(const int table_no, char*& menu_buf_ptr, int& menu_buf_size);//obsolete

	//
	int GetNameStringByID(const cmnInt64 reference_id, std::string& ref_string);
	int GetNameStringByID(const cmnInt64 reference_id, char*& referenced_namebuf, int& namebuf_size);

	//
	int GetNameStringByID(const std::vector<cmnInt64>& vec_refid, std::vector<std::string>& vec_ref_string);

	/*
	int	GetNameStringByKeyID(const KEY_ID_STRU& keyid_stru, std::string& ref_string);
	int	GetNameStringByKeyID(const std::vector<KEY_ID_STRU>& vec_keyid, std::vector<string>& vec_ref_string);

	int	GetNameStringByKeyID( const KEY_ID_STRU& keyid_stru, char*& referenced_namebuf, int& namebuf_size);
        */
	//
	int	GetNameStringBykey (const char* key_ptr, std::string& ref_string);
	int	GetNameStringBykey(const char* key_ptr, char*& referenced_namebuf, int& namebuf_size );

	//
	int	GetNameStringByAppKeyID( const std::vector<struct APP_KEY_STRU>& vec_appkeyid, std::vector<string>& vec_name_string);
	int	GetNameStringByAppID( const std::vector<APP_ID_STRU>& vec_appid, std::vector<string>& vec_name_string);

        int     GetNameStringByRtdbKeyID( const std::vector<struct RTDB_KEY_STRU>& vec_rtdbkeyid, std::vector<string>& vec_name_string);        
        int     GetNameStringByRtdbKeyID( const RTDB_KEY_STRU& rtdbkeyid_stru, char*& referenced_namebuf, int& namebuf_size);
        int     GetNameStringByRtdbKeyID(const RTDB_KEY_STRU rtdbkeyid_stru, std::string& ref_string);    
 
	//
	int	GetRefFlag (const int table_no, const short field_no); //obsolete
	int	GetRefFlag (const short field_no);

public:
	int	GetFacNameByKeyNo(const int table_no, const char* key_ptr, std::string& ref_string);
	int	GetFacNameByFacID(char* fac_name, const RTDB_KEY_STRU fac_id);
	int	GetFacNameByFacNo (char* fac_name, const int fac_no);

	int	GetFacIDByFacName(RTDB_KEY_STRU& fac_id, const char* fac_name);
	int   GetFacNoByFacName (int&  fac_no, const char* fac_name);

	int   GetFacIDByFacNo(RTDB_KEY_STRU& fac_id, const int fac_no);
	int   GetFacNoByFacID(int& fac_no, const RTDB_KEY_STRU fac_id);
public:
	//int ColMeasType ( const KEY_ID_STRU keyid , int& col_prop );
	int ColMeasType ( const int table_no, const int col_id , int& col_prop );

	//int ColMeasType( const std::vector<KEY_ID_STRU> vec_keyid , std::vector<int>& vec_col_prop );

public:
	//
	int GraphGetAppInfo(const struct GRAPH_ORDER_KEY_REQ& graph_req, struct GRAPH_ORDER_KEY_RSP& graph_rsp);
	int GraphGetValue();

public:
	int GetAppNameByNo(char* app_name, const int app_no) { return 0;}
	int GetAppNoByName(int& app_no, const char* app_name) { return 0;}

	int GetTableNameByNo(char* table_name, const int table_no, const bool is_eng=true) { return 0;}
	int GetTableNoByName(int& table_no, const char* table_name, const bool is_eng=true) { return 0;}

	int GetFieldNameByNo(char* field_name, const int field_no, const bool is_eng=true) { return 0;}
	int GetFieldNoByName(int& field_no, const char* field_name, const bool is_eng=true) { return 0;}

public:
	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct INT_VALUE_STATUS >  &KeyIdValVec);  //ym

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct FLOAT_VALUE_STATUS> & KeyIdValVec); //yc

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct CHAR_VALUE_STATUS > & KeyIdValVec); //yx

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct LONG_VALUE_STATUS > & KeyIdValVec); //long

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct UNION_VALUE_STATUS> & KeyIdValVec  );//union type

		//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct INT_VALUE_STATUS >  &KeyIdValVec, bool order);  //ym

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct FLOAT_VALUE_STATUS> & KeyIdValVec, bool order); //yc

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct CHAR_VALUE_STATUS > & KeyIdValVec, bool order); //yx

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct LONG_VALUE_STATUS > & KeyIdValVec, bool order); //long

	//int GetValueAndStatus(const std::vector<KEY_ID_STRU> &struVec , std::vector< struct UNION_VALUE_STATUS> & KeyIdValVec, bool order);//union type
	
	int GetValueAndStatus(const std::vector<struct KEY_ID_STA_STRU > &staStruVec , std::vector< struct INT_VALUE_STATUS> & KeyIdValVec);//ym

	int GetValueAndStatus(const std::vector<struct KEY_ID_STA_STRU > &staStruVec , std::vector< struct FLOAT_VALUE_STATUS> & KeyIdValVec);//yc
	int GetValueAndStatus(const std::vector<struct KEY_ID_STA_STRU> &staStruVec , std::vector< struct CHAR_VALUE_STATUS > & KeyIdValVec); //yx
	int GetValueAndStatus(const std::vector<struct KEY_ID_STA_STRU> &staStruVec , std::vector< struct LONG_VALUE_STATUS > & KeyIdValVec); //long
	int GetValueAndStatus(const std::vector<struct KEY_ID_STA_STRU> &staStruVec , std::vector< struct UNION_VALUE_STATUS> & KeyIdValVec  );//union type
	//int GetFieldNoFromKeyId(const std::vector<KEY_ID_STRU> &struVec , std::vector<int> &FieldNoVec);

        int ColMeasType( const RTDB_KEY_STRU rtdbkeyid , int& col_prop );
        int ColMeasType( const std::vector<RTDB_KEY_STRU> vec_rtdbkeyid , std::vector<int>& vec_col_prop );
        int GetFieldNoFromRtdbKeyId(const std::vector<RTDB_KEY_STRU> &struVec , std::vector<int> &FieldNoVec);
        int GetValueAndStatus(const std::vector<RTDB_KEY_STRU> &struVec , std::vector< struct INT_VALUE_STATUS >  &KeyIdValVec);  //ym
        int GetValueAndStatus(const std::vector<RTDB_KEY_STRU> &struVec , std::vector< struct FLOAT_VALUE_STATUS> & KeyIdValVec); //yc
        int GetValueAndStatus(const std::vector<RTDB_KEY_STRU> &struVec , std::vector< struct CHAR_VALUE_STATUS > & KeyIdValVec);  //yx
        int GetValueAndStatus(const std::vector<RTDB_KEY_STRU> &struVec , std::vector< struct LONG_VALUE_STATUS > & KeyIdValVec);  //long
private:

	int GetFieldValueByNo(char** field_value_ptr, int& field_length, const char* record_ptr, const int field_no);
	int GetFieldValueByName(char** field_value_ptr, int& field_length, const char* record_ptr, const char* field_name);

	int GetRecordInfo(char** buf_ptr, short& field_num, int& record_num, int& record_size);
	int GetRecordInfoByKey(char** buf_ptr, short& field_num, int& record_num, int& record_size, const char* key_ptr);

	int GetMenuStringByValue(const char* menu_name, const int menu_val, const int menu_type, char*& menu_string, int& string_len);	

	int get_string(char* total_namestring, const char* read_record_ptr, const struct STDB_FIELD_TAB* mov_field_ptr);
	int GetNameString(std::string& total_namestring, const char* read_record_ptr, const struct STDB_FIELD_TAB* mov_field_ptr);

	int Start();
	int SetContext (const short context_no);

	//int GetPosFromKeyIdStru(const std::vector<KEY_ID_STRU> &struVec , vector<int> &errPosVec , vector<IntVec> &posVec);

private:
	CApiOp (const CApiOp&);
	CApiOp& operator= (const CApiOp&);

private:
	enum
	{
		TABLE_COLUMN_INFO   = 100002,
		TABLE_MENU_INFO     = 100005,
		TABLE_RELEVANT_MENU = 6,
		TABLE_FAC_INFO      = 405,
	};

	short		m_ContextNo;
	int          	m_AppNo;
	int         	m_TableNo;

	CTableOp*    	m_TableOp;
	//CTableOp*	m_ColOp;

	TApiOpPriv	*m_pPrvStru;
};
}


#endif