151 files changed, 45277 insertions, 47437 deletions

diff --git a/tvapi/libtv/vpp/CPQdb.cpp b/tvapi/libtv/vpp/CPQdb.cpp
index 83d1bc1..4f11e7f 100644
--- a/tvapi/libtv/vpp/CPQdb.cpp
+++ b/tvapi/libtv/vpp/CPQdb.cpp
@@ -1,1648 +1,1861 @@
-/*

- * CPQdb.cpp

- *

- *  Created on: 2011-12-13

- *      Author: casey

- *

- * change 2015.04

- * showbo

- */

-

-

-#include <stdio.h>

-#include <string.h>

-#include <stdlib.h>

-#include <sys/stat.h>

-#include <errno.h>

-#include "CPQdb.h"

-#include "../tvutils/tvutils.h"

-#include "../tvutils/tvutils.h"

-

-#if (PQ_NO_ANDROID == 0)

-#include <android/log.h>

-

-#define LOG_TAG "CPQdb"

-#include "CTvLog.h"

-#endif

-

-

-#if (PQ_NO_ANDROID == 1)

-using namespace std;

-#endif

-

-//#define CPQDB_DEBUG

-

-#define BRIGHTNESS_ID       0

-#define CONTRAST_ID         1

-#define SATURATION_ID       1

-#define HUE_ID              0

-#define SHARPNESS_ID        1

-

-//static char *str_buf[256];

-

-#define ID_FIELD            "TableID"

-#define NR_LEVEL_NAME       "NRLevel"

-#define CM_LEVEL_NAME       "CMLevel"

-#define LEVEL_NAME          "Level"

-#define ADC_SETTING         "ADC_Settings"

-#define CVD2_SETTING        "CVD2_Settings"

-#define PORT                "Port"

-#define FORMAT              "Format"

-

-

-#define CC_LINE_MAX_LEN             (1024)

-

-#define LOG_TAG "CPQdb"

-//#define CPQDB_DEBUG

-

-

-/*int get_pq_from_file(const char *file_name, const char *screen_size, char *key_str_buf[]) {

-    FILE *fp = NULL;

-    int flag = -1;

-    char *str = NULL;

-    char r_line_buf[CC_LINE_MAX_LEN];

-

-    if (file_name == NULL || screen_size == NULL || key_str_buf == NULL) {

-        return -1;

-    }

-

-    fp = fopen(file_name, "r");

-    if (fp == NULL) {

-        LOGE("%s: open file \"%s\" error(%s).\n", "TV", file_name, strerror(errno));

-        return -1;

-    }

-

-    while (fgets(r_line_buf, CC_LINE_MAX_LEN, fp)) {

-        LOGD("%s, fgets_buf = %s\n","TV", r_line_buf);

-        if(NULL != strstr(r_line_buf, screen_size)){

-            LOGD("%s, screen_size_buf = %s\n","TV", r_line_buf);

-            str = (char*)malloc(strlen(r_line_buf));

-            memset(str, 0, strlen(str));

-            if(NULL != str){

-                strcpy(str, r_line_buf);

-                key_str_buf[0] = str;

-                LOGD("%s, key_str_buf[0] = %s\n","TV", key_str_buf[0]);

-            }

-            flag = 0;

-            break;

-         }

-    }

-

-    if(flag != 0)

-        key_str_buf[0] = NULL;

-

-    fclose(fp);

-    fp = NULL;

-

-    return flag;

-}*/

-

-/*int getFileSizeSystemCall(char * strFileName)

-{

-    struct stat temp;

-    stat(strFileName, &temp);

-    return temp.st_size;

-}*/

-

-CPqData::CPqData()

-{

-	int i = 0, j = 0;

-

-	for (i = 0; i < 15; i++) {

-		pq_bri_data[i].TotalNode = 0;

-		pq_bri_data[i].NodeValue = 0;

-		pq_bri_data[i].IndexValue = 0;

-		pq_bri_data[i].RegValue = 0;

-		pq_bri_data[i].step = 0;

-

-		pq_con_data[i].TotalNode = 0;

-		pq_con_data[i].NodeValue = 0;

-		pq_con_data[i].IndexValue = 0;

-		pq_con_data[i].RegValue = 0;

-		pq_con_data[i].step = 0;

-

-		pq_sat_data[i].TotalNode = 0;

-		pq_sat_data[i].NodeValue = 0;

-		pq_sat_data[i].IndexValue = 0;

-		pq_sat_data[i].RegValue = 0;

-		pq_sat_data[i].step = 0;

-

-		pq_hue_data[i].TotalNode = 0;

-		pq_hue_data[i].NodeValue = 0;

-		pq_hue_data[i].IndexValue = 0;

-		pq_hue_data[i].RegValue = 0;

-		pq_hue_data[i].step = 0;

-	}

-

-	for (i = 0; i < 10; i++) {

-		pq_sharpness_reg_data[i].length = 0;

-		for (j = 0; j < 50; j++) {

-			pq_sharpness_reg_data[i].reg_data[j].TotalNode = 0;

-			pq_sharpness_reg_data[i].reg_data[j].Value.type = 0;

-			pq_sharpness_reg_data[i].reg_data[j].Value.addr = 0;

-			pq_sharpness_reg_data[i].reg_data[j].Value.mask = 0;

-			pq_sharpness_reg_data[i].reg_data[j].Value.val = 0;

-			pq_sharpness_reg_data[i].reg_data[j].NodeValue = 0;

-			pq_sharpness_reg_data[i].reg_data[j].IndexValue = 0;

-			pq_sharpness_reg_data[i].reg_data[j].step = 0;

-		}

-	}

-}

-

-CPqData::~CPqData()

-{

-}

-

-int CPqData::openDB()

-{

-	int rval;

-	project_info_t tmp_info;

-	char *PARAM_PQ = "/param/pq.db";

-	char SYSTEM_PQ[128] = {0};

-	char tmp_buf[128] = {0};

-

-	strcpy(SYSTEM_PQ, "/system/etc/pq.db");

-

-	if (GetProjectInfo(&tmp_info) == 0) {

-		strcpy(tmp_buf, "/system/etc/");

-		strcat(tmp_buf, tmp_info.panel_type);

-		strcat(tmp_buf, ".db");

-		if (access(tmp_buf, 0) == 0) {

-			strncpy(SYSTEM_PQ, tmp_buf, sizeof(SYSTEM_PQ) - 1);

-		}

-	}

-

-	if (access(PARAM_PQ, 0) < 0) {

-		CFile file(SYSTEM_PQ);

-		if (file.copyTo(PARAM_PQ) != 0) {

-			LOGE("%s, copy file \"%s\" to \"%s\" error", __FUNCTION__, SYSTEM_PQ, PARAM_PQ);

-			return -1;

-		} else {

-			LOGD("%s, copy file \"%s\" to \"%s\" ok", __FUNCTION__, SYSTEM_PQ, PARAM_PQ);

-		}

-	}

-

-	closeDb();

-	rval = openDb(PARAM_PQ);

-

-	char *err;

-	bool isOk = integrityCheck();

-	if(!isOk) {

-		CFile file ( SYSTEM_PQ );

-		if ( file.copyTo ( PARAM_PQ ) != 0 ) {

-			LOGE ( "%s, copy file = %s , error", __FUNCTION__, SYSTEM_PQ );

-			return -1;

-		} else {

-			closeDb();

-			rval = openDb(PARAM_PQ);

-			LOGD ( "%s, copy file = %s , ok", __FUNCTION__, SYSTEM_PQ );

-		}

-	}

-	return rval;

-}

-

-int CPqData::getRegValues(tvin_port_t source, tvin_sig_fmt_t signal, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)

-{

-	CSqlite::Cursor c_tablelist, c_reg_list;

-	int iOutRet = 0;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	//first  get table name

-	sprintf(sqlmaster, "select TableName from GeneralCommonTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source, signal, mode);

-	this->select(sqlmaster, c_tablelist);

-	int index_am_reg = 0;

-	if(c_tablelist.moveToFirst()) { //for table list

-		int index_tablename = c_tablelist.getColumnIndex("TableName");

-		do {

-			sprintf(sqlmaster, "select RegType, RegAddr, RegMask, RegValue from %s;", c_tablelist.getString(index_tablename).string());

-			this->select(sqlmaster, c_reg_list);

-			if(c_reg_list.moveToFirst()) { //reg list for each table

-				int index_type =  0;//c_reg_list.getColumnIndex("RegType");

-				int index_addr =  1;//c_reg_list.getColumnIndex("RegAddr");

-				int index_mask =  2;//c_reg_list.getColumnIndex("RegMask");

-				int index_val =  3;//c_reg_list.getColumnIndex("RegValue");

-				do {

-					regs->am_reg[index_am_reg].type = c_reg_list.getInt(index_type);

-					regs->am_reg[index_am_reg].addr = c_reg_list.getInt(index_addr);

-					regs->am_reg[index_am_reg].mask = c_reg_list.getInt(index_mask);

-					regs->am_reg[index_am_reg].val = c_reg_list.getInt(index_val);

-					index_am_reg++;

-				} while(c_reg_list.moveToNext());

-			}

-		} while(c_tablelist.moveToNext());

-	}

-	//

-	regs->length = index_am_reg;

-	LOGD("getRegValues length = %d", regs->length);

-	return index_am_reg;

-}

-

-int CPqData::getRegValuesByValue(const char *name, const char *f_name, const char *f2_name, const int val,

-								 const int val2, am_regs_t *regs)

-{

-	CSqlite::Cursor c_reg_list;

-	char sqlmaster[256];

-	int rval = -1;

-	//first  get table name

-	if((strlen(f2_name) == 0) && (val2 == 0))

-		sprintf(sqlmaster, "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d;", name, f_name, val);

-	else

-		sprintf(sqlmaster, "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d and %s = %d;", name, f_name, val,

-				f2_name, val2);

-

-	rval = this->select(sqlmaster, c_reg_list);

-	int count = c_reg_list.getCount();

-	if(count > 512) {

-		LOGD("getRegValuesByValue regs is too more, in pq.db count = %d", count);

-		return -1;

-	}

-	int index_am_reg = 0;

-	if(c_reg_list.moveToFirst()) { //reg list for each table

-		int index_type =  0;//c_reg_list.getColumnIndex("RegType");

-		int index_addr =  1;//c_reg_list.getColumnIndex("RegAddr");

-		int index_mask =  2;//c_reg_list.getColumnIndex("RegMask");

-		int index_val =  3;//c_reg_list.getColumnIndex("RegValue");

-		do {

-			regs->am_reg[index_am_reg].type = c_reg_list.getInt(index_type);

-			regs->am_reg[index_am_reg].addr = c_reg_list.getInt(index_addr);

-			regs->am_reg[index_am_reg].mask = c_reg_list.getInt(index_mask);

-			regs->am_reg[index_am_reg].val = c_reg_list.getInt(index_val);

-			index_am_reg++;

-		} while(c_reg_list.moveToNext());

-	} else rval = -1;

-	//

-	regs->length = index_am_reg;

-	LOGD("getRegValuesByValue length = %d", regs->length);

-	return rval;

-}

-

-int CPqData::getRegValuesByValue_long(const char *name, const char *f_name, const char *f2_name, const int val, const int val2, am_regs_t *regs, am_regs_t *regs_1)

-{

-	CSqlite::Cursor c_reg_list;

-	char sqlmaster[256];

-	int rval = -1;

-	//first  get table name

-	if((strlen(f2_name) == 0) && (val2 == 0))

-		sprintf(sqlmaster, "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d;", name, f_name, val);

-	else

-		sprintf(sqlmaster, "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d and %s = %d;", name, f_name, val,

-				f2_name, val2);

-

-	rval = this->select(sqlmaster, c_reg_list);

-

-	int index_am_reg = 0;

-	int count = c_reg_list.getCount();

-	if(count > 1024) {

-		LOGD("getRegValuesByValue_long regs is too more, in pq.db count = %d", count);

-		return -1;

-	}

-	if(c_reg_list.moveToFirst()) { //reg list for each table

-		int index_type =  0;//c_reg_list.getColumnIndex("RegType");

-		int index_addr =  1;//c_reg_list.getColumnIndex("RegAddr");

-		int index_mask =  2;//c_reg_list.getColumnIndex("RegMask");

-		int index_val =  3;//c_reg_list.getColumnIndex("RegValue");

-		do {

-			if(index_am_reg < 512) {

-				regs->am_reg[index_am_reg].type = c_reg_list.getInt(index_type);

-				regs->am_reg[index_am_reg].addr = c_reg_list.getInt(index_addr);

-				regs->am_reg[index_am_reg].mask = c_reg_list.getInt(index_mask);

-				regs->am_reg[index_am_reg].val = c_reg_list.getInt(index_val);

-			} else if(index_am_reg >= 512 && index_am_reg  < 1024) {

-				regs_1->am_reg[index_am_reg - 512].type = c_reg_list.getInt(index_type);

-				regs_1->am_reg[index_am_reg - 512].addr = c_reg_list.getInt(index_addr);

-				regs_1->am_reg[index_am_reg - 512].mask = c_reg_list.getInt(index_mask);

-				regs_1->am_reg[index_am_reg - 512].val = c_reg_list.getInt(index_val);

-			} else {

-			}

-			index_am_reg++;

-		} while(c_reg_list.moveToNext());

-	} else rval = -1;

-	//

-	if(count < 512) {

-		regs->length = index_am_reg;

-	} else if(index_am_reg >= 512 && index_am_reg  < 1024) {

-		regs->length = 512;

-		regs_1->length = index_am_reg - 512;

-	}

-	LOGD("getRegValuesByValue length = %d", index_am_reg);

-	return rval;

-}

-int CPqData::PQ_GetBaseColorParams(vpp_color_basemode_t basemode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-	sprintf(sqlmaster, "select TableName from GeneralColormanagementTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		rval = getRegValuesByValue(c.getString(index_TableName), CM_LEVEL_NAME, "", (int)basemode, 0, regs);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetCM2Params(vpp_color_management2_t basemode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-	if(source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {

-		if(source_port != TVIN_PORT_CVBS3) {

-			source_port = TVIN_PORT_CVBS1;

-		}

-	} else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {

-		source_port = TVIN_PORT_HDMI0;

-	} else if(source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {

-		source_port = TVIN_PORT_MPEG0;

-	}

-

-	if(sig_fmt >= TVIN_SIG_FMT_MAX) {

-		sig_fmt = TVIN_SIG_FMT_NULL;

-	}

-

-	sprintf(sqlmaster, "select TableName from GeneralCM2Table where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		rval = getRegValuesByValue(c.getString(index_TableName), CM_LEVEL_NAME, "", (int)basemode, 0, regs);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetNR2Params(vpp_noise_reduction2_mode_t nr_mode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	if(source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {

-		if(source_port != TVIN_PORT_CVBS3) {

-			source_port = TVIN_PORT_CVBS1;

-		}

-	} else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {

-		source_port = TVIN_PORT_HDMI0;

-	} else if(source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {

-		source_port = TVIN_PORT_MPEG0;

-	}

-

-	sprintf(sqlmaster, "select TableName from GeneralNR2Table where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		rval = getRegValuesByValue(c.getString(index_TableName), LEVEL_NAME, "", (int)nr_mode, 0, regs);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetXVYCCParams(vpp_xvycc_mode_t xvycc_mode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs, am_regs_t *regs_1)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	if(source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {

-		if(source_port != TVIN_PORT_CVBS3) {

-			source_port = TVIN_PORT_CVBS1;

-		}

-	} else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {

-		source_port = TVIN_PORT_HDMI0;

-	} else if(source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {

-		source_port = TVIN_PORT_MPEG0;

-	}

-

-	sprintf(sqlmaster, "select TableName from GeneralXVYCCTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		rval = getRegValuesByValue_long(c.getString(index_TableName), LEVEL_NAME, "", (int)xvycc_mode, 0, regs, regs_1);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetMCDIParams(vpp_mcdi_mode_t mcdi_mode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	if(source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {

-		if(source_port != TVIN_PORT_CVBS3) {

-			source_port = TVIN_PORT_CVBS1;

-		}

-	} else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {

-		source_port = TVIN_PORT_HDMI0;

-	} else if(source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {

-		source_port = TVIN_PORT_MPEG0;

-	}

-

-	sprintf(sqlmaster, "select TableName from GeneralMCDITable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		rval = getRegValuesByValue(c.getString(index_TableName), LEVEL_NAME, "", (int)mcdi_mode, 0, regs);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetColorTemperatureParams(vpp_color_temperature_mode_t Tempmode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, tvin_trans_fmt_t trans_fmt,

-		tcon_rgb_ogo_t *params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-

-	int rval = -1;

-

-	//default

-	params->en = 1;

-	params->r_pre_offset = 0;

-	params->g_pre_offset = 0;

-	params->b_pre_offset = 0;

-	params->r_gain = 1024;

-	params->g_gain = 1024;

-	params->b_gain = 1024;

-	params->r_post_offset = 0;

-	params->g_post_offset = 0;

-	params->b_post_offset = 0;

-

-	sprintf(sqlmaster, "select TableName from GeneralWhiteBalanceTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d;",

-			source_port, sig_fmt, trans_fmt);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		sprintf(sqlmaster, "select Enable, R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset  from %s where "

-				"Level = %d and def = 0;", c.getString(index_TableName).string(), (int)Tempmode);

-

-		rval = this->select(sqlmaster, c);

-

-		if(c.moveToFirst()) {

-			params->en = c.getInt(0);//index 0

-			params->r_pre_offset = c.getInt(1);

-			params->g_pre_offset = c.getInt(2);

-			params->b_pre_offset = c.getInt(3);

-			params->r_gain = c.getInt(4);

-			params->g_gain = c.getInt(5);

-			params->b_gain = c.getInt(6);

-			params->r_post_offset = c.getInt(7);

-			params->g_post_offset = c.getInt(8);

-			params->b_post_offset = c.getInt(9);//index 9

-		}

-	}

-	return rval;

-}

-int CPqData::PQ_SetColorTemperatureParams(vpp_color_temperature_mode_t Tempmode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, tvin_trans_fmt_t trans_fmt,

-		tcon_rgb_ogo_t params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	char sql[512];

-

-	int rval = -1;

-

-	sprintf(sqlmaster, "select TableName from GeneralWhiteBalanceTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d;",

-			source_port, sig_fmt, trans_fmt);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		sprintf(sql, "update %s set Enable = %d, "

-				"R_Pre_Offset = %d, G_Pre_Offset = %d, B_Pre_Offset = %d, R_Gain = %d, G_Gain = %d, B_Gain = %d, "

-				"R_Post_Offset = %d, G_Post_Offset = %d, B_Post_Offset = %d  where Level = %d and def = 0;", c.getString(index_TableName).string(),

-				params.en, params.r_pre_offset, params.g_pre_offset, params.b_pre_offset, params.r_gain, params.g_gain,

-				params.b_gain, params.r_post_offset, params.g_post_offset, params.b_post_offset, Tempmode);

-

-		rval = this->exeSql(sql);

-	}

-	return rval;

-}

-

-int CPqData::PQ_ResetAllColorTemperatureParams(void)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[512];

-

-	int rval = -1;

-

-	sprintf(sqlmaster, "select distinct TableName from GeneralWhiteBalanceTable ;");

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		do { //delete

-			sprintf(sqlmaster, "delete from %s where def = 0;"

-					"insert into %s( Level , Enable , R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset, def ) "

-					"select Level, Enable, R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset, 0 from %s where def = 1;",

-					c.getString(index_TableName).string(), c.getString(index_TableName).string(), c.getString(index_TableName).string());

-			rval = this->exeSql(sqlmaster);

-		} while(c.moveToNext());

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetDNLPParams(tvin_port_t source_port, tvin_sig_fmt_t fmt, is_3d_type_t is2dOr3d,

-							  tvin_trans_fmt_t trans_fmt, ve_dnlp_t *params, ve_dnlp_table_t *newParams, int *dnlpFlag)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-	//default

-	params->en    = 0;

-	params->rt    = VE_DNLP_RT_0S;

-	params->rl    = VE_DNLP_RL_01;

-	params->black = VE_DNLP_EXT_00;

-	params->white = VE_DNLP_EXT_00;

-

-	mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);//(status << 16)|trans_fmt;

-

-	sprintf(sqlmaster, "select TableName from GeneralDNLPTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, fmt, mode);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		sprintf(sqlmaster, "select value  from %s ", c.getString(index_TableName).string());

-

-		rval = this->select(sqlmaster, c);

-		int count = c.getCount();

-		if (count == 1) {

-			int val;

-			c.moveToFirst();

-			val = c.getInt(0);//index 0

-			*dnlpFlag = 0;

-			params->en    = (val & 0xf0000000) >> 28;

-			params->rt    =  (ve_dnlp_rt_e)((val & 0x0f000000) >> 24);

-			params->rl    = (ve_dnlp_rl_e)((val & 0x00ff0000) >> 16);

-			params->black =  (ve_dnlp_ext_e)((val & 0x0000ff00) >>  8);

-			params->white = (ve_dnlp_ext_e)((val & 0x000000ff) >>  0);

-		} else if (count > 1) {

-			c.moveToFirst();

-			c.moveToNext();

-			*dnlpFlag = 1;

-			newParams->en = c.getInt(0);

-			c.moveToNext();

-			newParams->method = c.getInt(0);

-			c.moveToNext();

-			newParams->cliprate  = c.getInt(0);

-			c.moveToNext();

-			newParams->lowrange = c.getInt(0);

-			c.moveToNext();

-			newParams->hghrange = c.getInt(0);

-			c.moveToNext();

-			newParams->lowalpha = c.getInt(0);

-			c.moveToNext();

-			newParams->midalpha = c.getInt(0);

-			c.moveToNext();

-			newParams->hghalpha = c.getInt(0);

-		}

-	}

-	return rval;

-}

-

-int CPqData::PQ_SetNoLineAllBrightnessParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_BRIGHTNESS, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllBrightnessParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_BRIGHTNESS, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllBrightnessParams Error %d\n", rval);

-	}

-	return rval;

-

-}

-

-int CPqData::PQ_GetBrightnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params)

-{

-	int val;

-

-	GetNonlinearMapping(TVPQ_DATA_BRIGHTNESS, source_port, level, &val);

-	*params = CaculateLevelParam(pq_bri_data, bri_nodes, val);

-	return 0;

-

-}

-int CPqData::PQ_SetBrightnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params)

-{

-	return 0;

-}

-

-int CPqData::PQ_SetNoLineAllContrastParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_CONTRAST, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllContrastParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_CONTRAST, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllContrastParams Error %d\n", rval);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetContrastParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params)

-{

-	int val;

-	GetNonlinearMapping(TVPQ_DATA_CONTRAST, source_port, level, &val);

-	*params = CaculateLevelParam(pq_con_data, con_nodes, val);

-	return 0;

-}

-int CPqData::PQ_SetContrastParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params)

-{

-	return 0;

-}

-

-int CPqData::PQ_SetNoLineAllSaturationParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_SATURATION, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllSaturationParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_SATURATION, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllSaturationParams Error %d\n", rval);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetSaturationParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params)

-{

-	int val;

-	GetNonlinearMapping(TVPQ_DATA_SATURATION, source_port, level, &val);

-	*params = CaculateLevelParam(pq_sat_data, sat_nodes, val);

-	return 0;

-}

-int CPqData::PQ_SetSaturationParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params)

-{

-	return 0;

-}

-

-int CPqData::PQ_SetNoLineAllHueParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_HUE, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllHueParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_HUE, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllHueParams Error %d\n", rval);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetHueParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params)

-{

-	int val;

-	GetNonlinearMapping(TVPQ_DATA_HUE, source_port, level, &val);

-	*params = CaculateLevelParam(pq_hue_data, hue_nodes, val);

-	return 0;

-}

-int CPqData::PQ_SetHueParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params)

-{

-	return 0;

-}

-

-int CPqData::PQ_SetNoLineAllSharpnessParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_SHARPNESS, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllSharpnessParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_SHARPNESS, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllSharpnessParams Error %d\n", rval);

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetSharpnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, am_regs_t *regs)

-{

-	int val;

-	GetNonlinearMapping(TVPQ_DATA_SHARPNESS, source_port, level, &val);

-	LOGD("val = %d\n", val);

-	*regs = CaculateLevelRegsParam(pq_sharpness_reg_data, val);

-	return 0;

-}

-int CPqData::PQ_GetPLLParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,  am_regs_t *regs)

-{

-	int ret = -1;

-	int i = 0;

-

-	ret = getRegValuesByValue(ADC_SETTING, PORT, FORMAT, source_port, sig_fmt, regs);

-#ifdef  CPQDB_DEBUG

-	if(ret == 0) {

-		for(i = 0; i < regs->length; i++) {

-			LOGD("%s, =================================================", "TV");

-			LOGD("%s, regData.am_reg[%d].type = %d", "TV", i, regs->am_reg[i].type);

-			LOGD("%s, regData.am_reg[%d].addr = %d", "TV", i, regs->am_reg[i].addr);

-			LOGD("%s, regData.am_reg[%d].mask = %d", "TV", i, regs->am_reg[i].mask);

-			LOGD("%s, regData.am_reg[%d].val  = %d", "TV", i, regs->am_reg[i].val);

-		}

-	}

-#endif

-	if(regs->am_reg[0].val == 0 && regs->am_reg[1].val == 0 && regs->am_reg[2].val == 0 && regs->am_reg[3].val == 0) {

-		LOGE("%s,db's value is all zeros, that's not OK!!!\n", "TV");

-		return -1;

-	}

-	return ret;

-}

-int CPqData::PQ_GetCVD2Params(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,  am_regs_t *regs)

-{

-	int ret = -1;

-	int i = 0;

-	ret = getRegValuesByValue(CVD2_SETTING, PORT, FORMAT, source_port, sig_fmt, regs);

-#ifdef  CPQDB_DEBUG

-	if(ret == 0) {

-		for(i = 0; i < regs->length; i++) {

-			LOGD("%s, =================================================", "TV");

-			LOGD("%s, regData.am_reg[%d].type = %d", "TV", i, regs->am_reg[i].type);

-			LOGD("%s, regData.am_reg[%d].addr = %d", "TV", i, regs->am_reg[i].addr);

-			LOGD("%s, regData.am_reg[%d].mask = %d", "TV", i, regs->am_reg[i].mask);

-			LOGD("%s, regData.am_reg[%d].val  = %d", "TV", i, regs->am_reg[i].val);

-		}

-	}

-#endif

-	if(regs->am_reg[0].val == 0 && regs->am_reg[1].val == 0 &&  regs->am_reg[2].val == 0 &&  regs->am_reg[3].val == 0) {

-		LOGE("%s,db's value is all zeros, that's not OK!!!\n", "TV");

-		return -1;

-	}

-

-	return ret;

-}

-int CPqData::PQ_SetSharpnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, am_regs_t regs)

-{

-	return 0;

-}

-

-int CPqData::PQ_SetNoLineAllVolumeParams(tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	return SetNonlinearMapping(TVPQ_DATA_VOLUME, source_type, osd0, osd25, osd50, osd75, osd100);

-}

-int CPqData::PQ_GetNoLineAllVolumeParams(tv_source_input_type_t source_type, int *osd0, int *osd25, int *osd50, int *osd75, int *osd100)

-{

-	int osdvalue[5] = {0};

-	int rval;

-	rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_VOLUME, source_type, osdvalue);

-	*osd0 = osdvalue[0];

-	*osd25 = osdvalue[1];

-	*osd50 = osdvalue[2];

-	*osd75 = osdvalue[3];

-	*osd100 = osdvalue[4];

-	if(rval) {

-		LOGE("PQ_GetNoLineAllSharpnessParams Error %d\n", rval);

-	}

-	return rval;

-}

-

-int CPqData::PQ_SetVolumeParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params)

-{

-	return 0;

-}

-

-

-int CPqData::PQ_ResetAllNoLineParams(void)

-{

-	int rval;

-	char sqlmaster[256];

-	char *err = NULL;

-

-	sprintf(sqlmaster, "delete from NonlinearMapping; "

-			"insert into NonlinearMapping(TVIN_PORT, Item_ID, Level, Value) select TVIN_PORT, Item_ID, Level, Value from NonlinearMapping_Default;");

-

-	rval = this->exeSql(sqlmaster);

-	return rval;

-}

-

-

-int CPqData::PQ_GetNoiseReductionParams(vpp_noise_reduction_mode_t nr_mode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int *params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	sprintf(sqlmaster, "select TableName from GeneralNoiseReductionTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_port, sig_fmt, mode);

-

-	rval =  this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		sprintf(sqlmaster, "select NRValue from %s where NRLevel = %d;" , c.getString(index_TableName).string(), (int)nr_mode);

-

-		rval =  this->select(sqlmaster, c);

-

-		if(c.moveToFirst()) {

-			*params = c.getInt(0);

-		}

-	}

-	return rval;

-}

-

-int CPqData::PQ_SetNoiseReductionParams(vpp_noise_reduction_mode_t nr_mode, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int *params)

-{

-	return 0;

-}

-

-int CPqData::PQ_GetOverscanParams(tv_source_input_type_t source_type, tvin_sig_fmt_t fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, vpp_display_mode_t dmode, tvin_cutwin_t *cutwin_t)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	cutwin_t->hs = 0;

-	cutwin_t->he = 0;

-	cutwin_t->vs = 0;

-	cutwin_t->ve = 0;

-

-	sprintf(sqlmaster, "select Hs, He, Vs, Ve from OVERSCAN where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d and "

-			"TVIN_TRANS_FMT = %d ;",

-			source_type, fmt, mode);

-

-	rval =  this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		cutwin_t->hs = c.getInt(0);

-		cutwin_t->he = c.getInt(1);

-		cutwin_t->vs = c.getInt(2);

-		cutwin_t->ve = c.getInt(3);

-	}

-	return rval;

-}

-int CPqData::PQ_SetOverscanParams(tv_source_input_type_t source_type, tvin_sig_fmt_t fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, tvin_cutwin_t cutwin_t)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);

-	int rval = -1;

-

-	sprintf(sqlmaster, "select * from OVERSCAN where TVIN_PORT = %d and TVIN_SIG_FMT = %d and TVIN_TRANS_FMT = %d;", source_type, fmt, mode);

-

-	rval =  this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		sprintf(sqlmaster, "update OVERSCAN set Hs = %d, He = %d, Vs = %d, Ve = %d where TVIN_PORT = %d and TVIN_SIG_FMT = %d and TVIN_TRANS_FMT = %d;",

-				cutwin_t.hs, cutwin_t.he, cutwin_t.vs, cutwin_t.ve, source_type, fmt, mode);

-	} else {

-		sprintf(sqlmaster, "Insert into OVERSCAN(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, Hs, He, Vs, Ve) values(%d, %d, %d ,%d ,%d, %d, %d);",

-				source_type, fmt, mode, cutwin_t.hs, cutwin_t.he, cutwin_t.vs, cutwin_t.ve);

-	}

-	rval = this->exeSql(sqlmaster);

-

-	return rval;

-}

-

-int CPqData::PQ_ResetAllOverscanParams(void)

-{

-	int rval;

-	char sqlmaster[256];

-

-	sprintf(sqlmaster, "delete from OVERSCAN; insert into OVERSCAN(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, hs, he, vs, ve) select TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, hs, he, vs, ve from OVERSCAN_default;");

-	rval = this->exeSql(sqlmaster);

-

-	return rval;

-}

-

-int CPqData::PQ_GetPQModeParams(tv_source_input_type_t source_type, vpp_picture_mode_t pq_mode, vpp_pq_para_t *params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-

-	int rval = -1;

-

-	sprintf(sqlmaster, "select Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR from Picture_Mode where "

-			"TVIN_PORT = %d and "

-			"Mode = %d ;",

-			source_type, pq_mode);

-

-	rval =  this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		params->brightness = c.getInt(0);

-		params->contrast = c.getInt(1);

-		params->saturation = c.getInt(2);

-		params->hue = c.getInt(3);

-		params->sharpness = c.getInt(4);

-		params->backlight = c.getInt(5);

-		params->nr = c.getInt(6);

-	}

-	return rval;

-}

-int CPqData::PQ_SetPQModeParams(tv_source_input_type_t source_type, vpp_picture_mode_t pq_mode, vpp_pq_para_t *params)

-{

-	int rval;

-	char sql[256];

-

-	sprintf(sql, "update Picture_Mode set Brightness = %d, Contrast = %d, Saturation = %d, Hue = %d, Sharpness = %d, Backlight = %d, NR= %d "

-			" where TVIN_PORT = %d and Mode = %d;",

-			params->brightness, params->contrast, params->saturation,

-			params->hue, params->sharpness, params->backlight, params->nr,

-			source_type, pq_mode);

-	rval = this->exeSql(sql);

-	return 0;

-}

-

-int CPqData::PQ_SetPQModeParamsByName(const char *name, tv_source_input_type_t source_type, vpp_picture_mode_t pq_mode, vpp_pq_para_t *params)

-{

-	int rval;

-	char sql[256];

-

-	sprintf(sql, "insert into %s(TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR)"

-			" values(%d,%d,%d,%d,%d,%d,%d,%d,%d);", name, source_type, pq_mode, params->brightness, params->contrast, params->saturation,

-			params->hue, params->sharpness, params->backlight, params->nr);

-

-	rval = this->exeSql(sql);

-	return 0;

-}

-

-int CPqData::PQ_ResetAllPQModeParams(void)

-{

-	int rval;

-	char sqlmaster[256];

-

-	sprintf(sqlmaster, "delete from picture_mode; insert into picture_mode(TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR) select TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR from picture_mode_default;");

-

-	rval = this->exeSql(sqlmaster);

-	return rval;

-}

-

-int CPqData::PQ_GetGammaSpecialTable(int gammaValue, const char *f_name, tcon_gamma_table_t *gamma_value)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int rval = -1;

-

-	sprintf(sqlmaster, "select %s from GAMMA_%d", f_name, gammaValue);

-

-	rval =  this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index = 0;

-		do {

-			gamma_value->data[index] = c.getInt(0);

-			index++;

-		} while(c.moveToNext());

-	}

-	return rval;

-}

-

-int CPqData::PQ_GetGammaTableR(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt, tcon_gamma_table_t *gamma_r)

-{

-	return PQ_GetGammaTable(panel_id, source_port, fmt, "Red", gamma_r);

-}

-

-int CPqData::PQ_GetGammaTableG(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt, tcon_gamma_table_t *gamma_g)

-{

-	return PQ_GetGammaTable(panel_id, source_port, fmt, "Green", gamma_g);

-}

-

-int CPqData::PQ_GetGammaTableB(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt, tcon_gamma_table_t *gamma_b)

-{

-	return PQ_GetGammaTable(panel_id, source_port, fmt, "Blue", gamma_b);

-}

-

-int CPqData::PQ_GetGammaTable(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt, const char *f_name, tcon_gamma_table_t *val)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-

-	int rval = -1;

-

-	sprintf(sqlmaster, "select TableName from GeneralGammaTable where "

-			"TVIN_PORT = %d and "

-			"TVIN_SIG_FMT = %d;",

-			source_port, fmt);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		int index_TableName =  0;//c.getColumnIndex("TableName");

-		sprintf(sqlmaster, "select %s from %s;", f_name, c.getString(index_TableName).string());

-

-		rval = this->select(sqlmaster, c);

-		if(c.moveToFirst()) {

-			int index = 0;

-			do {

-				val->data[index] = c.getInt(0);

-				index++;

-			} while(c.moveToNext());

-		}

-	}

-	return rval;

-}

-

-

-int CPqData::PQ_GetVGAAjustPara(tvin_sig_fmt_t vga_fmt, tvafe_vga_parm_t *adjparam)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int rval = -1;

-

-	adjparam->clk_step = 0;

-	adjparam->phase = 0;

-	adjparam->hpos_step = 0;

-	adjparam->vpos_step = 0;

-	adjparam->vga_in_clean = 0;

-

-	sprintf(sqlmaster, "select Clk, Phase, HPos, VPos, Vga_in_clean from VGA_AutoParams where TVIN_SIG_FMT = %d", vga_fmt);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		adjparam->clk_step = c.getInt(0);

-		adjparam->phase = c.getInt(1);

-		adjparam->hpos_step = c.getInt(2);

-		adjparam->vpos_step = c.getInt(3);

-		adjparam->vga_in_clean = c.getInt(4);

-	}

-	return rval;

-}

-int CPqData::PQ_SetVGAAjustPara(tvin_sig_fmt_t vga_fmt, tvafe_vga_parm_t adjparam)

-{

-	CSqlite::Cursor c;

-	char sql[256];

-	int rval = -1;

-

-	sprintf(sql, "select * from VGA_AutoParams where TVIN_SIG_FMT = %d;", vga_fmt);

-

-	rval = this->select(sql, c);

-

-	if(c.moveToFirst()) {

-		sprintf(sql, "Insert into VGA_AutoParams(TVIN_SIG_FMT, Clk, Phase, HPos, VPos, Vga_in_clean) values(%d, %d, %d ,%d ,%d, %d);",

-				vga_fmt, adjparam.clk_step, adjparam.phase, adjparam.hpos_step, adjparam.vpos_step, adjparam.vga_in_clean);

-	} else {

-		sprintf(sql, "update VGA_AutoParams set Clk = %d, Phase = %d, HPos = %d, VPos = %d, Vga_in_clean = %d where TVIN_SIG_FMT = %d;",

-				adjparam.clk_step, adjparam.phase, adjparam.hpos_step, adjparam.vpos_step, adjparam.vga_in_clean, vga_fmt);

-	}

-	rval = this->exeSql(sql);

-	return rval;

-}

-

-int CPqData::CaculateLevelParam(tvpq_data_t   *pq_data, int nodes, int level)

-{

-	int i;

-

-	for(i = 0; i < nodes; i++) {

-		if(level < pq_data[i].IndexValue) {

-			break;

-		}

-	}

-

-	if(i == 0) {

-		return pq_data[i].RegValue;

-	} else if(i == nodes) {

-		return pq_data[i - 1].RegValue;

-	} else {

-		return pq_data[i - 1].RegValue + (level - pq_data[i - 1].IndexValue) * pq_data[i - 1].step;

-	}

-}

-

-am_regs_t CPqData::CaculateLevelRegsParam(tvpq_sharpness_regs_t *pq_regs, int level)

-{

-	am_regs_t regs;

-	int i;

-

-	for(i = 0; i < sha_nodes; i++) {

-		if(level < pq_regs[i].reg_data[0].IndexValue) {

-			break;

-		}

-	}

-

-	if(i == 0) {

-		regs.length = pq_regs[i].length;

-		for(int j = 0; j < pq_regs[i].length; j++) {

-			regs.am_reg[j].type = pq_regs[i].reg_data[j].Value.type;

-			regs.am_reg[j].addr = pq_regs[i].reg_data[j].Value.addr;

-			regs.am_reg[j].mask = pq_regs[i].reg_data[j].Value.mask;

-			regs.am_reg[j].val = pq_regs[i].reg_data[j].Value.val;

-		}

-

-	} else if(i == sha_nodes) {

-		regs.length = pq_regs[i - 1].length;

-		for(int j = 0; j < pq_regs[i - 1].length; j++) {

-			regs.am_reg[j].type = pq_regs[i - 1].reg_data[j].Value.type;

-			regs.am_reg[j].addr = pq_regs[i - 1].reg_data[j].Value.addr;

-			regs.am_reg[j].mask = pq_regs[i - 1].reg_data[j].Value.mask;

-			regs.am_reg[j].val = pq_regs[i - 1].reg_data[j].Value.val;

-		}

-	} else {

-		regs.length = pq_regs[i - 1].length;

-		for(int j = 0; j < pq_regs[i - 1].length; j++) {

-			regs.am_reg[j].type = pq_regs[i - 1].reg_data[j].Value.type;

-			regs.am_reg[j].addr = pq_regs[i - 1].reg_data[j].Value.addr;

-			regs.am_reg[j].mask = pq_regs[i - 1].reg_data[j].Value.mask;

-			regs.am_reg[j].val = pq_regs[i - 1].reg_data[j].Value.val + (level - pq_regs[i - 1].reg_data[j].IndexValue) * pq_regs[i - 1].reg_data[j].step;

-		}

-	}

-

-	return regs;

-}

-

-

-int CPqData::GetNonlinearMapping(tvpq_data_type_t data_type, tvin_port_t source_port, int level, int *params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int rval = -1;

-

-	tv_source_input_type_t type;

-	//showboz

-	type = CTvin::Tvin_SourcePortToSourceInputType(source_port);//???

-

-	sprintf(sqlmaster, "select Value from NonlinearMapping where "

-			"TVIN_PORT = %d and "

-			"Item_ID = %d and "

-			"Level = %d ;",

-			type, data_type, level);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		*params = c.getInt(0);

-	}

-	return rval;

-}

-

-int CPqData::GetNonlinearMappingByOSDFac(tvpq_data_type_t data_type, tv_source_input_type_t source_type, int *params)

-{

-	CSqlite::Cursor c;

-	char sqlmaster[256];

-	int rval = -1;

-

-	sprintf(sqlmaster, "select Value from NonlinearMapping where "

-			"TVIN_PORT = %d and "

-			"Item_ID = %d and ("

-			"Level = 0 or Level = 25 or Level = 50 or Level = 75 or Level = 100);",

-			source_type, data_type);

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		params[0] = c.getInt(0);

-		params[1] = c.getInt(1);

-		params[2] = c.getInt(2);

-		params[3] = c.getInt(3);

-		params[4] = c.getInt(4);

-	}

-	return rval;

-}

-

-int CPqData::SetNonlinearMapping(tvpq_data_type_t data_type, tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-

-	int rval;

-	char *err = NULL;

-	int osdvalue[101];

-	double step[4];

-	char sql[256];

-

-	step[0] = (osd25 - osd0) / 25.0;

-	step[1] = (osd50 - osd25) / 25.0;

-	step[2] = (osd75 - osd50) / 25.0;

-	step[3] = (osd100 - osd75) / 25.0;

-

-

-	for(int i = 0; i <= 100; i++) {

-		if(i == 0) {

-			osdvalue[i] = osd0;

-		} else if((i > 0) && (i <= 25)) {

-			osdvalue[i] = osd0 + (int)(i * step[0]);

-		} else if((i > 25) && (i <= 50)) {

-			osdvalue[i] = osd25 + (int)((i - 25) * step[1]);

-		} else if((i > 50) && (i <= 75)) {

-			osdvalue[i] = osd50 + (int)((i - 50) * step[2]);

-		} else if((i > 75) && (i <= 100)) {

-			osdvalue[i] = osd75 + (int)((i - 75) * step[3]);

-		}

-		sprintf(sql, "update NonLinearMapping set Value = %d where TVIN_PORT = %d and Item_ID = %d and Level = %d ;", osdvalue[i], source_type, data_type, i);

-		if(!(this->exeSql(sql))) {

-			return -1;

-		}

-	}

-	return 0;

-}

-

-int CPqData::SetNonlinearMappingByName(const char *name, tvpq_data_type_t data_type, tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100)

-{

-	int rval;

-	char *err = NULL;

-	int osdvalue[101];

-	double step[4];

-	char sql[256];

-

-	step[0] = (osd25 - osd0) / 25.0;

-	step[1] = (osd50 - osd25) / 25.0;

-	step[2] = (osd75 - osd50) / 25.0;

-	step[3] = (osd100 - osd75) / 25.0;

-

-	for(int i = 0; i <= 100; i++) {

-		if(i == 0) {

-			osdvalue[i] = osd0;

-		} else if((i > 0) && (i <= 25)) {

-			osdvalue[i] = osd0 + (int)(i * step[0]);

-		} else if((i > 25) && (i <= 50)) {

-			osdvalue[i] = osd25 + (int)((i - 25) * step[1]);

-		} else if((i > 50) && (i <= 75)) {

-			osdvalue[i] = osd50 + (int)((i - 50) * step[2]);

-		} else if((i > 75) && (i <= 100)) {

-			osdvalue[i] = osd75 + (int)((i - 75) * step[3]);

-		}

-		memset(sql, '\0', 256);

-		sprintf(sql, "insert into %s(TVIN_PORT, Item_ID, Level, Value) values(%d,%d,%d,%d);", name, source_type, data_type, i, osdvalue[i]);

-		if(!(this->exeSql(sql))) {

-			return -1;

-		}

-	}

-	return 0;

-}

-

-int CPqData::LoadPQData(tvpq_data_type_t data_type, tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int flag)

-{

-	CSqlite::Cursor c;

-	int rval;

-	char sqlmaster[256];

-	int mode = is2dOr3d;

-	tvpq_data_t *pq_data = NULL;

-	int *pq_nodes = NULL;

-

-	switch(data_type) {

-	case TVPQ_DATA_BRIGHTNESS:

-		sprintf(sqlmaster, "select TableName from GeneralContrastBrightnessTable where "

-				"TVIN_PORT = %d and "

-				"TVIN_SIG_FMT = %d and "

-				"TVIN_TRANS_FMT = %d and "

-				"%s = %d;",

-				source_port, sig_fmt, mode, ID_FIELD, BRIGHTNESS_ID);

-		pq_data = pq_bri_data;

-		pq_nodes = &bri_nodes;

-		break;

-	case TVPQ_DATA_CONTRAST:

-		sprintf(sqlmaster, "select TableName from GeneralContrastBrightnessTable where "

-				"TVIN_PORT = %d and "

-				"TVIN_SIG_FMT = %d and "

-				"TVIN_TRANS_FMT = %d and "

-				"%s = %d;",

-				source_port, sig_fmt, mode, ID_FIELD, CONTRAST_ID);

-		pq_data = pq_con_data;

-		pq_nodes = &con_nodes;

-		break;

-	case TVPQ_DATA_HUE:

-		sprintf(sqlmaster, "select TableName from GeneralSaturationHueTable where "

-				"TVIN_PORT = %d and "

-				"TVIN_SIG_FMT = %d and "

-				"TVIN_TRANS_FMT = %d and "

-				"%s = %d;",

-				source_port, sig_fmt, mode, ID_FIELD, HUE_ID);

-		pq_data = pq_hue_data;

-		pq_nodes = &hue_nodes;

-		break;

-	case TVPQ_DATA_SATURATION:

-		sprintf(sqlmaster, "select TableName from GeneralSaturationHueTable where "

-				"TVIN_PORT = %d and "

-				"TVIN_SIG_FMT = %d and "

-				"TVIN_TRANS_FMT = %d and "

-				"%s = %d;",

-				source_port, sig_fmt, mode, ID_FIELD, SATURATION_ID);

-		pq_data = pq_sat_data;

-		pq_nodes = &sat_nodes;

-		break;

-	case TVPQ_DATA_SHARPNESS:

-		//sprintf(sqlmaster, "select TableName from GeneralSharpnessTable where "

-		sprintf(sqlmaster, "select TableName from GeneralSharpnessG9Table where "

-				"TVIN_PORT = %d and "

-				"TVIN_SIG_FMT = %d and "

-				"TVIN_TRANS_FMT = %d and "

-				"%s = %d;",

-				source_port, sig_fmt, mode, ID_FIELD, SHARPNESS_ID);

-		pq_data = NULL;

-		pq_nodes = &sha_nodes;

-		break;

-	default:

-		break;

-	}

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		switch(data_type) {

-		case TVPQ_DATA_BRIGHTNESS:

-		case TVPQ_DATA_CONTRAST:

-		case TVPQ_DATA_HUE:

-		case TVPQ_DATA_SATURATION:

-			sprintf(sqlmaster, "select TotalNode, NodeNumber, IndexValue, RegValue, StepUp from %s order by NodeNumber asc;", c.getString(0).string());

-			break;

-		case TVPQ_DATA_SHARPNESS:

-			sprintf(sqlmaster, "select TotalNode, NodeNumber, RegType, RegAddr, RegMask, IndexValue, RegValue, StepUp from %s order by NodeNumber asc;", c.getString(0).string());

-			break;

-		default:

-			break;

-		}

-	}

-

-	rval = this->select(sqlmaster, c);

-

-	if(c.moveToFirst()) {

-		if(data_type == TVPQ_DATA_SHARPNESS) {

-			*pq_nodes = c.getInt(0);//TotalNode?

-			int length = c.getCount() / (*pq_nodes);

-			int index = 0;

-			for(int i = 0; i < *pq_nodes; i++) {

-				pq_sharpness_reg_data[i].length = length;

-			}

-			do {

-				pq_sharpness_reg_data[index / length].reg_data[index % length].TotalNode = c.getInt(0);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].NodeValue  = c.getInt(1);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].Value.type  = c.getUInt(2);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].Value.addr = c.getUInt(3);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].Value.mask = c.getUInt(4);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].IndexValue = c.getInt(5);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].Value.val = c.getUInt(6);

-				pq_sharpness_reg_data[index / length].reg_data[index % length].step = c.getF(7);

-				index++;

-			} while(c.moveToNext());

-		} else {

-			int index = 0;

-			do {

-				pq_data[index].TotalNode = c.getInt(0);

-				pq_data[index].NodeValue = c.getInt(1);

-				pq_data[index].IndexValue = c.getInt(2);

-				pq_data[index].RegValue = c.getInt(3);

-				pq_data[index].step = c.getF(4);

-				if(flag == 1) {

-					if(data_type == TVPQ_DATA_BRIGHTNESS) {

-						LOGD("%s, bri pq_data[%d].RegValue = %d\n", "TV", index, pq_data[index].RegValue);

-						pq_data[index].RegValue -= 64;

-						LOGD("%s, bri pq_data[%d].RegValue + 64 = %d\n", "TV", index, pq_data[index].RegValue);

-					} else if(data_type == TVPQ_DATA_CONTRAST) {

-						LOGD("%s, con pq_data[%d].RegValue = %d\n", "TV", index, pq_data[index].RegValue);

-						pq_data[index].RegValue += 64;

-						LOGD("%s, con pq_data[%d].RegValue + 64 = %d\n", "TV", index, pq_data[index].RegValue);

-					}

-				}

-				index++;

-			} while(c.moveToNext());

-			*pq_nodes = index;

-		}

-	}

-

-	return rval;

-}

-

-int CPqData::LoadAllPQData(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int flag)

-{

-	int rval = -1;

-	rval = LoadPQData(TVPQ_DATA_BRIGHTNESS, source_port, sig_fmt, is2dOr3d, trans_fmt, flag);

-	if(rval) {

-		return rval;

-	}

-	rval = LoadPQData(TVPQ_DATA_CONTRAST, source_port, sig_fmt, is2dOr3d, trans_fmt, flag);

-	if(rval) {

-		return rval;

-	}

-	rval = LoadPQData(TVPQ_DATA_SATURATION, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);

-	if(rval) {

-		return rval;

-	}

-	rval = LoadPQData(TVPQ_DATA_HUE, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);

-	if(rval) {

-		return rval;

-	}

-	rval = LoadPQData(TVPQ_DATA_SHARPNESS, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);

-	if(rval) {

-		return rval;

-	}

-	return rval;

-}

-

-typedef enum initial_type_e {

-	TYPE_PMode = 0,

-	TYPE_PMode_Default,

-	TYPE_Nonlinear,

-	TYPE_NonLinear_Default,

-	TYPE_VGA_AUTO,

-	TYPE_OVERSCAN,

-} initial_type_t;

-

-const char *Pmode_name[6] = {

-	"Picture_Mode",

-	"Picture_Mode_Default",

-	"NonlinearMapping",

-	"NonlinearMapping_Default",

-	"VGA_AutoParams",

-	"OVERSCAN"

-};

-

-void CPqData::initialTable(int type)

-{

-	vpp_pq_para_t pmode_default;

-

-	pmode_default.backlight = 100;

-	pmode_default.brightness = 50;

-	pmode_default.contrast = 50;

-	pmode_default.hue = 50;

-	pmode_default.nr = 0;

-	pmode_default.saturation = 50;

-	pmode_default.sharpness = 50;

-

-

-	switch(type) {

-	case TYPE_PMode:

-	case TYPE_PMode_Default:

-		for(int i = 0; i < 6; i++ ) {

-			for(int j = 0; j < 4; j++) {

-				PQ_SetPQModeParamsByName(Pmode_name[type], (tv_source_input_type_t) i, (vpp_picture_mode_t)j, &pmode_default);

-			}

-		}

-		break;

-	case TYPE_Nonlinear:

-	case TYPE_NonLinear_Default:

-		for(int i = 0; i < 6; i++ ) {

-			for(int j = 0; j < 5; j++) {

-				SetNonlinearMappingByName(Pmode_name[type], (tvpq_data_type_t) j, (tv_source_input_type_t)i, 0, (int)255 / 4.0, (int)255 * 2 / 4.0, (int)255 * 3 / 4.0, 255);

-			}

-		}

-		break;

-	case TYPE_VGA_AUTO:

-		break;

-	case TYPE_OVERSCAN:

-		break;

-	}

-}

-

-/*void CPqData::transferFixTable()

-{

-    char sql[256];

-    char * err = NULL;

-    char ** rsltReg = NULL;

-    int rval, rows, columns;

-    unsigned int tvin, sig, trans;

-    char tablename[256];

-

-    sprintf(sql, "Select TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, TableName from GeneralSharpnessTable where TableID = 0;");

-

-    rval = sqlite3_get_table(DB, sql, &rsltReg, &rows, &columns, &err);

-

-    if(rval) {

-        if(rsltReg != NULL) {

-            sqlite3_free_table(rsltReg);

-            rsltReg = NULL;

-        }

-        if(err != NULL) {

-            sqlite3_free(err);

-            err = NULL;

-        }

-        return;

-    } else {

-        for(int i=1; i<=rows; i++) {

-            memset(sql,'\0',256);

-

-            sscanf(rsltReg[i*columns], "%u", &tvin);

-            sscanf(rsltReg[i*columns+1], "%u", &sig);

-            sscanf(rsltReg[i*columns+2], "%u", &trans);

-            sscanf(rsltReg[i*columns+3], "%s", tablename);

-

-            sprintf(sql, "insert into GeneralCommonTable(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, TableID, TableName) values(%d,%d,%d,0,\"%s\");",

-                    tvin, sig, trans, tablename);

-            rval = sqlite3_exec(DB, sql, NULL, NULL, &err);

-            if(rval) {

-                if(err != NULL) {

-                    sqlite3_free(err);

-                    err = NULL;

-                }

-                return;

-            }

-            if(err != NULL) {

-                sqlite3_free(err);

-                err = NULL;

-            }

-        }

-        memset(sql,'\0',256);

-        sprintf(sql,  "delete from GeneralSharpnessTable where TableID = 0;");

-        rval = sqlite3_exec(DB, sql, NULL, NULL, &err);

-        if(rval) {

-            if(err != NULL) {

-                sqlite3_free(err);

-                err = NULL;

-            }

-            return;

-        }

-        if(err != NULL) {

-            sqlite3_free(err);

-            err = NULL;

-        }

-    }

-}*/

-

-int CPqData::PQ_GetPhaseArray(am_phase_t *am_phase)

-{

-	CSqlite::Cursor c;

-	int iOutRet = 0;

-	char sqlmaster[256];

-	sprintf(sqlmaster, "select Phase from Phase order by Format ASC; ");

-

-	this->select(sqlmaster, c);

-	int nums = 0;

-	am_phase->length = c.getCount();

-	if(c.moveToFirst()) {

-		do {

-			am_phase->phase[nums] = c.getInt(0);//col index is 0[Phase]

-			nums++;

-		} while(c.moveToNext());

-	}

-	//

-	return nums;

-}

-

+/*
+ * CPQdb.cpp
+ *
+ *  d on: 2011-12-13
+ *      Author: casey
+ *
+ * change 2015.04
+ * showbo
+ */
+
+#include <stdio.h>
+#include <string.h>
+#include <stdlib.h>
+#include <sys/stat.h>
+#include <errno.h>
+#include <xxxconfig.h>
+#include "CPQdb.h"
+#include "../tvutils/tvutils.h"
+#include "../tvconfig/tvconfig.h"
+
+#if (PQ_NO_ANDROID == 0)
+#include <android/log.h>
+#define LOG_TAG "CPQdb"
+#include "CTvLog.h"
+#endif
+
+#if (PQ_NO_ANDROID == 1)
+using namespace std;
+#endif
+
+//#define CPQDB_DEBUG
+
+#define BRIGHTNESS_ID       0
+#define CONTRAST_ID         1
+#define SATURATION_ID       1
+#define HUE_ID              0
+#define SHARPNESS_ID        1
+
+//static char *str_buf[256];
+
+#define ID_FIELD            "TableID"
+#define NR_LEVEL_NAME       "NRLevel"
+#define CM_LEVEL_NAME       "CMLevel"
+#define LEVEL_NAME          "Level"
+#define ADC_SETTING         "ADC_Settings"
+#define CVD2_SETTING        "CVD2_Settings"
+#define PORT                "Port"
+#define FORMAT              "Format"
+
+#define CC_LINE_MAX_LEN             (1024)
+
+#define LOG_TAG "CPQdb"
+//#define CPQDB_DEBUG
+
+
+/*int get_pq_from_file(const char *file_name, const char *screen_size, char *key_str_buf[]) {
+ FILE *fp = NULL;
+ int flag = -1;
+ char *str = NULL;
+ char r_line_buf[CC_LINE_MAX_LEN];
+
+ if (file_name == NULL || screen_size == NULL || key_str_buf == NULL) {
+ return -1;
+ }
+
+ fp = fopen(file_name, "r");
+ if (fp == NULL) {
+ LOGE("%s: open file \"%s\" error(%s).\n", "TV", file_name, strerror(errno));
+ return -1;
+ }
+
+ while (fgets(r_line_buf, CC_LINE_MAX_LEN, fp)) {
+ LOGD("%s, fgets_buf = %s\n","TV", r_line_buf);
+ if (NULL != strstr(r_line_buf, screen_size)) {
+ LOGD("%s, screen_size_buf = %s\n","TV", r_line_buf);
+ str = (char*)malloc(strlen(r_line_buf));
+ memset(str, 0, strlen(str));
+ if (NULL != str) {
+ strcpy(str, r_line_buf);
+ key_str_buf[0] = str;
+ LOGD("%s, key_str_buf[0] = %s\n","TV", key_str_buf[0]);
+ }
+ flag = 0;
+ break;
+ }
+ }
+
+ if (flag != 0)
+ key_str_buf[0] = NULL;
+
+ fclose(fp);
+ fp = NULL;
+
+ return flag;
+ }*/
+
+/*int getFileSizeSystemCall(char * strFileName)
+ {
+ struct stat temp;
+ stat(strFileName, &temp);
+ return temp.st_size;
+ }*/
+
+CPqData::CPqData() {
+    int i = 0, j = 0;
+
+    for (i = 0; i < 15; i++) {
+        pq_bri_data[i].TotalNode = 0;
+        pq_bri_data[i].NodeValue = 0;
+        pq_bri_data[i].IndexValue = 0;
+        pq_bri_data[i].RegValue = 0;
+        pq_bri_data[i].step = 0;
+
+        pq_con_data[i].TotalNode = 0;
+        pq_con_data[i].NodeValue = 0;
+        pq_con_data[i].IndexValue = 0;
+        pq_con_data[i].RegValue = 0;
+        pq_con_data[i].step = 0;
+
+        pq_sat_data[i].TotalNode = 0;
+        pq_sat_data[i].NodeValue = 0;
+        pq_sat_data[i].IndexValue = 0;
+        pq_sat_data[i].RegValue = 0;
+        pq_sat_data[i].step = 0;
+
+        pq_hue_data[i].TotalNode = 0;
+        pq_hue_data[i].NodeValue = 0;
+        pq_hue_data[i].IndexValue = 0;
+        pq_hue_data[i].RegValue = 0;
+        pq_hue_data[i].step = 0;
+    }
+
+    for (i = 0; i < 10; i++) {
+        pq_sharpness_reg_data[i].length = 0;
+        pq_sharpness_reg_data_1[i].length = 0;
+        for (j = 0; j < 50; j++) {
+            pq_sharpness_reg_data[i].reg_data[j].TotalNode = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].TotalNode = 0;
+            pq_sharpness_reg_data[i].reg_data[j].Value.type = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].Value.type = 0;
+            pq_sharpness_reg_data[i].reg_data[j].Value.addr = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].Value.addr = 0;
+            pq_sharpness_reg_data[i].reg_data[j].Value.mask = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].Value.mask = 0;
+            pq_sharpness_reg_data[i].reg_data[j].Value.val = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].Value.val = 0;
+            pq_sharpness_reg_data[i].reg_data[j].NodeValue = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].NodeValue = 0;
+            pq_sharpness_reg_data[i].reg_data[j].IndexValue = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].IndexValue = 0;
+            pq_sharpness_reg_data[i].reg_data[j].step = 0;
+            pq_sharpness_reg_data_1[i].reg_data[j].step = 0;
+        }
+    }
+}
+
+CPqData::~CPqData() {
+}
+
+int CPqData::openPqDB(const char *db_path) {
+    int rval;
+    project_info_t tmp_info;
+    char SYSTEM_PQ[128] = { 0 };
+    char tmp_buf[128] = { 0 };
+
+    strcpy(PQ_DB_PATH, db_path);
+    strcpy(SYSTEM_PQ, "/system/etc/pq.db");
+
+    if (GetProjectInfo(&tmp_info) == 0) {
+        strcpy(tmp_buf, "/system/etc/");
+        strcat(tmp_buf, tmp_info.panel_type);
+        strcat(tmp_buf, ".db");
+        if (access(tmp_buf, 0) == 0) {
+            strncpy(SYSTEM_PQ, tmp_buf, sizeof(SYSTEM_PQ) - 1);
+        }
+    }
+
+    LOGD("openPqDB path = %s   = %s", db_path, PQ_DB_PATH);
+    if (access(PQ_DB_PATH, 0) < 0) {
+        CFile file(SYSTEM_PQ);
+        if (file.copyTo(PQ_DB_PATH) != 0) {
+            LOGE("%s, copy file \"%s\" to \"%s\" error", __FUNCTION__, SYSTEM_PQ, PQ_DB_PATH);
+            return -1;
+        } else {
+            LOGD("%s, copy file \"%s\" to \"%s\" ok", __FUNCTION__, SYSTEM_PQ, PQ_DB_PATH);
+        }
+    }
+
+    closeDb();
+    rval = openDb(PQ_DB_PATH);
+
+    char *err;
+    bool isOk = integrityCheck();
+    if (!isOk) {
+        CFile file(SYSTEM_PQ);
+        if (file.copyTo(PQ_DB_PATH) != 0) {
+            LOGE("%s, copy file = %s , error", __FUNCTION__, SYSTEM_PQ);
+            return -1;
+        } else {
+            closeDb();
+            rval = openDb(PQ_DB_PATH);
+            LOGD("%s, copy file = %s , ok", __FUNCTION__, SYSTEM_PQ);
+        }
+    }
+    return rval;
+}
+int CPqData::reopenDB()
+{
+    int  rval = openDb(PQ_DB_PATH);
+    return rval;
+}
+
+int CPqData::getRegValues(const char *table_name, tvin_port_t source, tvin_sig_fmt_t signal,
+    is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)
+{
+    CSqlite::Cursor c_tablelist, c_reg_list;
+    int index_am_reg = 0;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    if (table_name == NULL || !strlen(table_name)) {
+        LOGE("%s, table_name is null\n", __FUNCTION__);
+        return index_am_reg;
+    }
+
+    getSqlParams(__FUNCTION__, sqlmaster,
+        "select TableName from %s where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", table_name, source, signal, mode);
+    this->select(sqlmaster, c_tablelist);
+    if (c_tablelist.moveToFirst()) { //for table list
+        do {
+            getSqlParams(__FUNCTION__, sqlmaster,
+                "select RegType, RegAddr, RegMask, RegValue from %s;",
+                c_tablelist.getString(0).string());
+            this->select(sqlmaster, c_reg_list);
+
+            if (c_reg_list.moveToFirst()) { //reg list for each table
+                int index_type = 0;//c_reg_list.getColumnIndex("RegType");
+                int index_addr = 1;//c_reg_list.getColumnIndex("RegAddr");
+                int index_mask = 2;//c_reg_list.getColumnIndex("RegMask");
+                int index_val = 3;//c_reg_list.getColumnIndex("RegValue");
+                do {
+                    regs->am_reg[index_am_reg].type = c_reg_list.getUInt(index_type);
+                    regs->am_reg[index_am_reg].addr = c_reg_list.getUInt(index_addr);
+                    regs->am_reg[index_am_reg].mask = c_reg_list.getUInt(index_mask);
+                    regs->am_reg[index_am_reg].val = c_reg_list.getUInt(index_val);
+                    index_am_reg++;
+                } while (c_reg_list.moveToNext());
+            }
+        } while (c_tablelist.moveToNext());
+    }
+    //
+    regs->length = index_am_reg;
+    LOGD("%s, length = %d", __FUNCTION__, regs->length);
+    return index_am_reg;
+}
+
+int CPqData::getRegValuesByValue(const char *name, const char *f_name, const char *f2_name,
+        const int val, const int val2, am_regs_t *regs) {
+    CSqlite::Cursor c_reg_list;
+    char sqlmaster[256];
+    int rval = -1;
+    //first  get table name
+    if ((strlen(f2_name) == 0) && (val2 == 0))
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d;", name, f_name,
+                val);
+    else
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d and %s = %d;",
+                name, f_name, val, f2_name, val2);
+
+    rval = this->select(sqlmaster, c_reg_list);
+    int count = c_reg_list.getCount();
+    if (count > REGS_MAX_NUMBER) {
+        LOGD("%s, regs is too more, in pq.db count = %d", __FUNCTION__, count);
+        return -1;
+    }
+    int index_am_reg = 0;
+    if (c_reg_list.moveToFirst()) { //reg list for each table
+        int index_type = 0;//c_reg_list.getColumnIndex("RegType");
+        int index_addr = 1;//c_reg_list.getColumnIndex("RegAddr");
+        int index_mask = 2;//c_reg_list.getColumnIndex("RegMask");
+        int index_val = 3;//c_reg_list.getColumnIndex("RegValue");
+        do {
+            regs->am_reg[index_am_reg].type = c_reg_list.getUInt(index_type);
+            regs->am_reg[index_am_reg].addr = c_reg_list.getUInt(index_addr);
+            regs->am_reg[index_am_reg].mask = c_reg_list.getUInt(index_mask);
+            regs->am_reg[index_am_reg].val = c_reg_list.getUInt(index_val);
+            index_am_reg++;
+        } while (c_reg_list.moveToNext());
+    } else
+        rval = -1;
+    //
+    regs->length = index_am_reg;
+    LOGD("%s, length = %d", __FUNCTION__, regs->length);
+    return rval;
+}
+
+int CPqData::getRegValuesByValue_long(const char *name, const char *f_name, const char *f2_name,
+        const int val, const int val2, am_regs_t *regs, am_regs_t *regs_1) {
+    CSqlite::Cursor c_reg_list;
+    char sqlmaster[256];
+    int rval = -1;
+    //first  get table name
+    if ((strlen(f2_name) == 0) && (val2 == 0))
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d;", name, f_name,
+                val);
+    else
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select RegType, RegAddr, RegMask, RegValue from %s where %s = %d and %s = %d;",
+                name, f_name, val, f2_name, val2);
+
+    rval = this->select(sqlmaster, c_reg_list);
+
+    int index_am_reg = 0;
+    int count = c_reg_list.getCount();
+    if (count > 1024) {
+        LOGD("%s, regs is too more, in pq.db count = %d", __FUNCTION__, count);
+        return -1;
+    }
+    if (c_reg_list.moveToFirst()) { //reg list for each table
+        int index_type = 0;//c_reg_list.getColumnIndex("RegType");
+        int index_addr = 1;//c_reg_list.getColumnIndex("RegAddr");
+        int index_mask = 2;//c_reg_list.getColumnIndex("RegMask");
+        int index_val = 3;//c_reg_list.getColumnIndex("RegValue");
+        do {
+            if (index_am_reg < 512) {
+                regs->am_reg[index_am_reg].type = c_reg_list.getUInt(index_type);
+                regs->am_reg[index_am_reg].addr = c_reg_list.getUInt(index_addr);
+                regs->am_reg[index_am_reg].mask = c_reg_list.getUInt(index_mask);
+                regs->am_reg[index_am_reg].val = c_reg_list.getUInt(index_val);
+            } else if (index_am_reg >= 512 && index_am_reg < 1024) {
+                regs_1->am_reg[index_am_reg - 512].type = c_reg_list.getUInt(index_type);
+                regs_1->am_reg[index_am_reg - 512].addr = c_reg_list.getUInt(index_addr);
+                regs_1->am_reg[index_am_reg - 512].mask = c_reg_list.getUInt(index_mask);
+                regs_1->am_reg[index_am_reg - 512].val = c_reg_list.getUInt(index_val);
+            } else {
+            }
+            index_am_reg++;
+        } while (c_reg_list.moveToNext());
+    } else
+        rval = -1;
+    //
+    if (count < 512) {
+        regs->length = index_am_reg;
+    } else if (index_am_reg >= 512 && index_am_reg < 1024) {
+        regs->length = 512;
+        regs_1->length = index_am_reg - 512;
+    }
+    LOGD("%s, length = %d", __FUNCTION__, index_am_reg);
+    return rval;
+}
+int CPqData::PQ_GetBaseColorParams(vpp_color_basemode_t basemode, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+    getSqlParams(__FUNCTION__, sqlmaster,
+            "select TableName from GeneralColormanagementTable where "
+                "TVIN_PORT = %d and "
+                "TVIN_SIG_FMT = %d and "
+                "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        rval = getRegValuesByValue(c.getString(index_TableName), CM_LEVEL_NAME, "", (int) basemode,
+                0, regs);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetCM2Params(vpp_color_management2_t basemode, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+    if (source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {
+        if (source_port != TVIN_PORT_CVBS3) {
+            source_port = TVIN_PORT_CVBS1;
+        }
+    } else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {
+        source_port = TVIN_PORT_HDMI0;
+    } else if (source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {
+        source_port = TVIN_PORT_MPEG0;
+    }
+
+    if (sig_fmt >= TVIN_SIG_FMT_MAX) {
+        sig_fmt = TVIN_SIG_FMT_NULL;
+    }
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralCM2Table where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        rval = getRegValuesByValue(c.getString(index_TableName), CM_LEVEL_NAME, "", (int) basemode,
+                0, regs);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetNR2Params(vpp_noise_reduction2_mode_t nr_mode, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    if (source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {
+        if (source_port != TVIN_PORT_CVBS3) {
+            source_port = TVIN_PORT_CVBS1;
+        }
+    } else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {
+        source_port = TVIN_PORT_HDMI0;
+    } else if (source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {
+        source_port = TVIN_PORT_MPEG0;
+    }
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralNR2Table where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        rval = getRegValuesByValue(c.getString(index_TableName), LEVEL_NAME, "", (int) nr_mode, 0,
+                regs);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetXVYCCParams(vpp_xvycc_mode_t xvycc_mode, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs,
+        am_regs_t *regs_1) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    if (source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {
+        if (source_port != TVIN_PORT_CVBS3) {
+            source_port = TVIN_PORT_CVBS1;
+        }
+    } else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {
+        source_port = TVIN_PORT_HDMI0;
+    } else if (source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {
+        source_port = TVIN_PORT_MPEG0;
+    }
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralXVYCCTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        rval = getRegValuesByValue_long(c.getString(index_TableName), LEVEL_NAME, "",
+                (int) xvycc_mode, 0, regs, regs_1);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetMCDIParams(vpp_mcdi_mode_t mcdi_mode, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    if (source_port >= TVIN_PORT_CVBS0 && source_port <= TVIN_PORT_CVBS7) {
+        if (source_port != TVIN_PORT_CVBS3) {
+            source_port = TVIN_PORT_CVBS1;
+        }
+    } else if (source_port >= TVIN_PORT_HDMI0 && source_port <= TVIN_PORT_HDMI7) {
+        source_port = TVIN_PORT_HDMI0;
+    } else if (source_port > TVIN_PORT_DTV || source_port < TVIN_PORT_NULL) {
+        source_port = TVIN_PORT_MPEG0;
+    }
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralMCDITable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        rval = getRegValuesByValue(c.getString(index_TableName), LEVEL_NAME, "", (int) mcdi_mode,
+                0, regs);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetDeblockParams(vpp_deblock_mode_t deb_mode, tvin_port_t source_port,
+    tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, am_regs_t *regs)
+{
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralDeblockTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, is2dOr3d);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        rval = getRegValuesByValue(c.getString(0), LEVEL_NAME, "", (int)deb_mode, 0, regs);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetColorTemperatureParams(vpp_color_temperature_mode_t Tempmode,
+        tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, tvin_trans_fmt_t trans_fmt,
+        tcon_rgb_ogo_t *params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+
+    int rval = -1;
+
+    //default
+    params->en = 1;
+    params->r_pre_offset = 0;
+    params->g_pre_offset = 0;
+    params->b_pre_offset = 0;
+    params->r_gain = 1024;
+    params->g_gain = 1024;
+    params->b_gain = 1024;
+    params->r_post_offset = 0;
+    params->g_post_offset = 0;
+    params->b_post_offset = 0;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralWhiteBalanceTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d;", source_port, sig_fmt, trans_fmt);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        getSqlParams(
+                __FUNCTION__,
+                sqlmaster,
+                "select Enable, R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset  from %s where "
+                    "Level = %d and def = 0;", c.getString(index_TableName).string(),
+                (int) Tempmode);
+
+        rval = this->select(sqlmaster, c);
+
+        if (c.moveToFirst()) {
+            params->en = c.getInt(0);//index 0
+            params->r_pre_offset = c.getInt(1);
+            params->g_pre_offset = c.getInt(2);
+            params->b_pre_offset = c.getInt(3);
+            params->r_gain = c.getInt(4);
+            params->g_gain = c.getInt(5);
+            params->b_gain = c.getInt(6);
+            params->r_post_offset = c.getInt(7);
+            params->g_post_offset = c.getInt(8);
+            params->b_post_offset = c.getInt(9);//index 9
+        }
+    }
+    return rval;
+}
+int CPqData::PQ_SetColorTemperatureParams(vpp_color_temperature_mode_t Tempmode,
+        tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, tvin_trans_fmt_t trans_fmt,
+        tcon_rgb_ogo_t params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    char sql[512];
+
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralWhiteBalanceTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d;", source_port, sig_fmt, trans_fmt);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        getSqlParams(
+                __FUNCTION__,
+                sql,
+                "update %s set Enable = %d, "
+                    "R_Pre_Offset = %d, G_Pre_Offset = %d, B_Pre_Offset = %d, R_Gain = %d, G_Gain = %d, B_Gain = %d, "
+                    "R_Post_Offset = %d, G_Post_Offset = %d, B_Post_Offset = %d  where Level = %d and def = 0;",
+                c.getString(index_TableName).string(), params.en, params.r_pre_offset,
+                params.g_pre_offset, params.b_pre_offset, params.r_gain, params.g_gain,
+                params.b_gain, params.r_post_offset, params.g_post_offset, params.b_post_offset,
+                Tempmode);
+
+        rval = this->exeSql(sql);
+    }
+    return rval;
+}
+
+int CPqData::PQ_ResetAllColorTemperatureParams(void) {
+    CSqlite::Cursor c;
+    char sqlmaster[512];
+
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster,
+            "select distinct TableName from GeneralWhiteBalanceTable ;");
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        do { //delete
+            getSqlParams(
+                    __FUNCTION__,
+                    sqlmaster,
+                    "delete from %s where def = 0;"
+                        "insert into %s( Level , Enable , R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset, def ) "
+                        "select Level, Enable, R_Pre_Offset, G_Pre_Offset, B_Pre_Offset, R_Gain, G_Gain, B_Gain, R_Post_Offset, G_Post_Offset, B_Post_Offset, 0 from %s where def = 1;",
+                    c.getString(index_TableName).string(), c.getString(index_TableName).string(),
+                    c.getString(index_TableName).string());
+            rval = this->exeSql(sqlmaster);
+        } while (c.moveToNext());
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetDNLPParams(tvin_port_t source_port, tvin_sig_fmt_t fmt, is_3d_type_t is2dOr3d,
+        tvin_trans_fmt_t trans_fmt, ve_dnlp_t *params, ve_dnlp_table_t *newParams, int *dnlpFlag) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+    //default
+    params->en = 0;
+    params->rt = VE_DNLP_RT_0S;
+    params->rl = VE_DNLP_RL_01;
+    params->black = VE_DNLP_EXT_00;
+    params->white = VE_DNLP_EXT_00;
+
+    mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);//(status << 16)|trans_fmt;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralDNLPTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        getSqlParams(__FUNCTION__, sqlmaster, "select value  from %s ",
+                c.getString(index_TableName).string());
+
+        rval = this->select(sqlmaster, c);
+        int count = c.getCount();
+        if (count == 1) {
+            int val;
+            c.moveToFirst();
+            val = c.getInt(0);//index 0
+            *dnlpFlag = 0;
+            params->en = (val & 0xf0000000) >> 28;
+            params->rt = (ve_dnlp_rt_e)((val & 0x0f000000) >> 24);
+            params->rl = (ve_dnlp_rl_e)((val & 0x00ff0000) >> 16);
+            params->black = (ve_dnlp_ext_e)((val & 0x0000ff00) >> 8);
+            params->white = (ve_dnlp_ext_e)((val & 0x000000ff) >> 0);
+        } else if (count > 1) {
+            c.moveToFirst();
+            c.moveToNext();
+            *dnlpFlag = 1;
+            newParams->en = c.getInt(0);
+            c.moveToNext();
+            newParams->method = c.getInt(0);
+            c.moveToNext();
+            newParams->cliprate = c.getInt(0);
+            c.moveToNext();
+            newParams->lowrange = c.getInt(0);
+            c.moveToNext();
+            newParams->hghrange = c.getInt(0);
+            c.moveToNext();
+            newParams->lowalpha = c.getInt(0);
+            c.moveToNext();
+            newParams->midalpha = c.getInt(0);
+            c.moveToNext();
+            newParams->hghalpha = c.getInt(0);
+            c.moveToNext();
+            newParams->adj_level = c.getInt(0);
+            c.moveToNext();
+            newParams->new_adj_level = c.getInt(0);
+            c.moveToNext();
+            newParams->new_mvreflsh = c.getInt(0);
+            c.moveToNext();
+            newParams->new_gmma_rate = c.getInt(0);
+            c.moveToNext();
+            newParams->new_lowalpha = c.getInt(0);
+            c.moveToNext();
+            newParams->new_hghalpha = c.getInt(0);
+            c.moveToNext();
+            newParams->new_sbgnbnd = c.getInt(0);
+            c.moveToNext();
+            newParams->new_sendbnd = c.getInt(0);
+            c.moveToNext();
+            newParams->new_clashBgn = c.getInt(0);
+            c.moveToNext();
+            newParams->new_clashEnd = c.getInt(0);
+            c.moveToNext();
+            newParams->new_cliprate = c.getInt(0);
+            c.moveToNext();
+            newParams->new_mtdbld_rate = c.getInt(0);
+            c.moveToNext();
+            newParams->new_blkgma_rate = c.getInt(0);
+        }
+    }
+    return rval;
+}
+
+int CPqData::PQ_SetNoLineAllBrightnessParams(tv_source_input_type_t source_type, int osd0,
+        int osd25, int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_BRIGHTNESS, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllBrightnessParams(tv_source_input_type_t source_type, int *osd0,
+        int *osd25, int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_BRIGHTNESS, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllBrightnessParams Error %d\n", rval);
+    }
+    return rval;
+
+}
+
+int CPqData::PQ_GetBrightnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params) {
+    int val;
+
+    GetNonlinearMapping(TVPQ_DATA_BRIGHTNESS, source_port, level, &val);
+    *params = CaculateLevelParam(pq_bri_data, bri_nodes, val);
+    return 0;
+
+}
+int CPqData::PQ_SetBrightnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params) {
+    return 0;
+}
+
+int CPqData::PQ_SetNoLineAllContrastParams(tv_source_input_type_t source_type, int osd0, int osd25,
+        int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_CONTRAST, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllContrastParams(tv_source_input_type_t source_type, int *osd0,
+        int *osd25, int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_CONTRAST, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllContrastParams Error %d\n", rval);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetContrastParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params) {
+    int val;
+    GetNonlinearMapping(TVPQ_DATA_CONTRAST, source_port, level, &val);
+    *params = CaculateLevelParam(pq_con_data, con_nodes, val);
+    return 0;
+}
+int CPqData::PQ_SetContrastParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params) {
+    return 0;
+}
+
+int CPqData::PQ_SetNoLineAllSaturationParams(tv_source_input_type_t source_type, int osd0,
+        int osd25, int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_SATURATION, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllSaturationParams(tv_source_input_type_t source_type, int *osd0,
+        int *osd25, int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_SATURATION, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllSaturationParams Error %d\n", rval);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetSaturationParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params) {
+    int val;
+    GetNonlinearMapping(TVPQ_DATA_SATURATION, source_port, level, &val);
+    *params = CaculateLevelParam(pq_sat_data, sat_nodes, val);
+    return 0;
+}
+int CPqData::PQ_SetSaturationParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params) {
+    return 0;
+}
+
+int CPqData::PQ_SetNoLineAllHueParams(tv_source_input_type_t source_type, int osd0, int osd25,
+        int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_HUE, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllHueParams(tv_source_input_type_t source_type, int *osd0, int *osd25,
+        int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_HUE, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllHueParams Error %d\n", rval);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetHueParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int *params) {
+    int val;
+    GetNonlinearMapping(TVPQ_DATA_HUE, source_port, level, &val);
+    *params = CaculateLevelParam(pq_hue_data, hue_nodes, val);
+    return 0;
+}
+int CPqData::PQ_SetHueParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params) {
+    return 0;
+}
+
+int CPqData::PQ_SetNoLineAllSharpnessParams(tv_source_input_type_t source_type, int osd0,
+        int osd25, int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_SHARPNESS, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllSharpnessParams(tv_source_input_type_t source_type, int *osd0,
+        int *osd25, int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_SHARPNESS, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllSharpnessParams Error %d\n", rval);
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetSharpnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, am_regs_t *regs, am_regs_t *regs_l) {
+    int val;
+    GetNonlinearMapping(TVPQ_DATA_SHARPNESS, source_port, level, &val);
+    LOGD("val = %d\n", val);
+    *regs = CaculateLevelRegsParam(pq_sharpness_reg_data, val, 0);
+    if (sha_diff_flag == 6) {
+        *regs_l = CaculateLevelRegsParam(pq_sharpness_reg_data_1, val, 1);
+    }
+    return 0;
+}
+int CPqData::PQ_GetPLLParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, am_regs_t *regs) {
+    int ret = -1;
+    int i = 0;
+
+    ret = getRegValuesByValue(ADC_SETTING, PORT, FORMAT, source_port, sig_fmt, regs);
+#ifdef  CPQDB_DEBUG
+    if (ret == 0) {
+        for (i = 0; i < regs->length; i++) {
+            LOGD("%s, =================================================", "TV");
+            LOGD("%s, regData.am_reg[%d].type = %d", "TV", i, regs->am_reg[i].type);
+            LOGD("%s, regData.am_reg[%d].addr = %d", "TV", i, regs->am_reg[i].addr);
+            LOGD("%s, regData.am_reg[%d].mask = %d", "TV", i, regs->am_reg[i].mask);
+            LOGD("%s, regData.am_reg[%d].val  = %d", "TV", i, regs->am_reg[i].val);
+        }
+    }
+#endif
+    if (regs->am_reg[0].val == 0 && regs->am_reg[1].val == 0 && regs->am_reg[2].val == 0
+            && regs->am_reg[3].val == 0) {
+        LOGE("%s,db's value is all zeros, that's not OK!!!\n", "TV");
+        return -1;
+    }
+    return ret;
+}
+int CPqData::PQ_GetCVD2Params(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, am_regs_t *regs) {
+    int ret = -1;
+    int i = 0;
+    ret = getRegValuesByValue(CVD2_SETTING, PORT, FORMAT, source_port, sig_fmt, regs);
+#ifdef  CPQDB_DEBUG
+    if (ret == 0) {
+        for (i = 0; i < regs->length; i++) {
+            LOGD("%s, =================================================", "TV");
+            LOGD("%s, regData.am_reg[%d].type = %d", "TV", i, regs->am_reg[i].type);
+            LOGD("%s, regData.am_reg[%d].addr = %d", "TV", i, regs->am_reg[i].addr);
+            LOGD("%s, regData.am_reg[%d].mask = %d", "TV", i, regs->am_reg[i].mask);
+            LOGD("%s, regData.am_reg[%d].val  = %d", "TV", i, regs->am_reg[i].val);
+        }
+    }
+#endif
+    if (regs->am_reg[0].val == 0 && regs->am_reg[1].val == 0 && regs->am_reg[2].val == 0
+            && regs->am_reg[3].val == 0) {
+        LOGE("%s,db's value is all zeros, that's not OK!!!\n", "TV");
+        return -1;
+    }
+
+    return ret;
+}
+int CPqData::PQ_SetSharpnessParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, am_regs_t regs) {
+    return 0;
+}
+
+int CPqData::PQ_SetNoLineAllVolumeParams(tv_source_input_type_t source_type, int osd0, int osd25,
+        int osd50, int osd75, int osd100) {
+    return SetNonlinearMapping(TVPQ_DATA_VOLUME, source_type, osd0, osd25, osd50, osd75, osd100);
+}
+int CPqData::PQ_GetNoLineAllVolumeParams(tv_source_input_type_t source_type, int *osd0, int *osd25,
+        int *osd50, int *osd75, int *osd100) {
+    int osdvalue[5] = { 0 };
+    int rval;
+    rval = GetNonlinearMappingByOSDFac(TVPQ_DATA_VOLUME, source_type, osdvalue);
+    *osd0 = osdvalue[0];
+    *osd25 = osdvalue[1];
+    *osd50 = osdvalue[2];
+    *osd75 = osdvalue[3];
+    *osd100 = osdvalue[4];
+    if (rval) {
+        LOGE("PQ_GetNoLineAllSharpnessParams Error %d\n", rval);
+    }
+    return rval;
+}
+
+int CPqData::PQ_SetVolumeParams(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int level, int params) {
+    return 0;
+}
+
+int CPqData::PQ_ResetAllNoLineParams(void) {
+    int rval;
+    char sqlmaster[256];
+    char *err = NULL;
+
+    getSqlParams(
+            __FUNCTION__,
+            sqlmaster,
+            "delete from NonlinearMapping; "
+                "insert into NonlinearMapping(TVIN_PORT, Item_ID, Level, Value) select TVIN_PORT, Item_ID, Level, Value from NonlinearMapping_Default;");
+
+    rval = this->exeSql(sqlmaster);
+    return rval;
+}
+
+int CPqData::PQ_GetNoiseReductionParams(vpp_noise_reduction_mode_t nr_mode,
+        tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d,
+        tvin_trans_fmt_t trans_fmt, int *params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralNoiseReductionTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_port, sig_fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        getSqlParams(__FUNCTION__, sqlmaster, "select NRValue from %s where NRLevel = %d;",
+                c.getString(index_TableName).string(), (int) nr_mode);
+
+        rval = this->select(sqlmaster, c);
+
+        if (c.moveToFirst()) {
+            *params = c.getInt(0);
+        }
+    }
+    return rval;
+}
+
+int CPqData::PQ_SetNoiseReductionParams(vpp_noise_reduction_mode_t nr_mode,
+        tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d,
+        tvin_trans_fmt_t trans_fmt, int *params) {
+    return 0;
+}
+
+int CPqData::PQ_GetOverscanParams(tv_source_input_type_t source_type, tvin_sig_fmt_t fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, vpp_display_mode_t dmode,
+        tvin_cutwin_t *cutwin_t) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    cutwin_t->hs = 0;
+    cutwin_t->he = 0;
+    cutwin_t->vs = 0;
+    cutwin_t->ve = 0;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select Hs, He, Vs, Ve from OVERSCAN where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d and "
+        "TVIN_TRANS_FMT = %d ;", source_type, fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        cutwin_t->hs = c.getInt(0);
+        cutwin_t->he = c.getInt(1);
+        cutwin_t->vs = c.getInt(2);
+        cutwin_t->ve = c.getInt(3);
+    }
+    return rval;
+}
+int CPqData::PQ_SetOverscanParams(tv_source_input_type_t source_type, tvin_sig_fmt_t fmt,
+        is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, tvin_cutwin_t cutwin_t) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int mode = is2dOr3d;//Check2Dor3D(status, trans_fmt);
+    int rval = -1;
+
+    getSqlParams(
+            __FUNCTION__,
+            sqlmaster,
+            "select * from OVERSCAN where TVIN_PORT = %d and TVIN_SIG_FMT = %d and TVIN_TRANS_FMT = %d;",
+            source_type, fmt, mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        getSqlParams(
+                __FUNCTION__,
+                sqlmaster,
+                "update OVERSCAN set Hs = %d, He = %d, Vs = %d, Ve = %d where TVIN_PORT = %d and TVIN_SIG_FMT = %d and TVIN_TRANS_FMT = %d;",
+                cutwin_t.hs, cutwin_t.he, cutwin_t.vs, cutwin_t.ve, source_type, fmt, mode);
+    } else {
+        getSqlParams(
+                __FUNCTION__,
+                sqlmaster,
+                "Insert into OVERSCAN(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, Hs, He, Vs, Ve) values(%d, %d, %d ,%d ,%d, %d, %d);",
+                source_type, fmt, mode, cutwin_t.hs, cutwin_t.he, cutwin_t.vs, cutwin_t.ve);
+    }
+    rval = this->exeSql(sqlmaster);
+
+    return rval;
+}
+
+int CPqData::PQ_ResetAllOverscanParams(void) {
+    int rval;
+    char sqlmaster[256];
+
+    getSqlParams(
+            __FUNCTION__,
+            sqlmaster,
+            "delete from OVERSCAN; insert into OVERSCAN(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, hs, he, vs, ve) select TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, hs, he, vs, ve from OVERSCAN_default;");
+    rval = this->exeSql(sqlmaster);
+
+    return rval;
+}
+
+int CPqData::PQ_GetPQModeParams(tv_source_input_type_t source_type, vpp_picture_mode_t pq_mode,
+        vpp_pq_para_t *params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster,
+            "select Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR from Picture_Mode where "
+                "TVIN_PORT = %d and "
+                "Mode = %d ;", source_type, pq_mode);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        params->brightness = c.getInt(0);
+        params->contrast = c.getInt(1);
+        params->saturation = c.getInt(2);
+        params->hue = c.getInt(3);
+        params->sharpness = c.getInt(4);
+        params->backlight = c.getInt(5);
+        params->nr = c.getInt(6);
+    }
+    return rval;
+}
+int CPqData::PQ_SetPQModeParams(tv_source_input_type_t source_type, vpp_picture_mode_t pq_mode,
+        vpp_pq_para_t *params) {
+    int rval;
+    char sql[256];
+
+    getSqlParams(
+            __FUNCTION__,
+            sql,
+            "update Picture_Mode set Brightness = %d, Contrast = %d, Saturation = %d, Hue = %d, Sharpness = %d, Backlight = %d, NR= %d "
+                " where TVIN_PORT = %d and Mode = %d;", params->brightness, params->contrast,
+            params->saturation, params->hue, params->sharpness, params->backlight, params->nr,
+            source_type, pq_mode);
+    rval = this->exeSql(sql);
+    return 0;
+}
+
+int CPqData::PQ_SetPQModeParamsByName(const char *name, tv_source_input_type_t source_type,
+        vpp_picture_mode_t pq_mode, vpp_pq_para_t *params) {
+    int rval;
+    char sql[256];
+
+    getSqlParams(__FUNCTION__, sql,
+            "insert into %s(TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR)"
+                " values(%d,%d,%d,%d,%d,%d,%d,%d,%d);", name, source_type, pq_mode,
+            params->brightness, params->contrast, params->saturation, params->hue,
+            params->sharpness, params->backlight, params->nr);
+
+    rval = this->exeSql(sql);
+    return 0;
+}
+
+int CPqData::PQ_ResetAllPQModeParams(void) {
+    int rval;
+    char sqlmaster[256];
+
+    getSqlParams(
+            __FUNCTION__,
+            sqlmaster,
+            "delete from picture_mode; insert into picture_mode(TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR) select TVIN_PORT, Mode, Brightness, Contrast, Saturation, Hue, Sharpness, Backlight, NR from picture_mode_default;");
+
+    rval = this->exeSql(sqlmaster);
+    return rval;
+}
+
+int CPqData::PQ_GetGammaSpecialTable(int gammaValue, const char *f_name,
+        tcon_gamma_table_t *gamma_value) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select %s from GAMMA_%d", f_name, gammaValue);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index = 0;
+        do {
+            gamma_value->data[index] = c.getInt(0);
+            index++;
+        } while (c.moveToNext());
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetGammaTableR(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt,
+        tcon_gamma_table_t *gamma_r) {
+    return PQ_GetGammaTable(panel_id, source_port, fmt, "Red", gamma_r);
+}
+
+int CPqData::PQ_GetGammaTableG(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt,
+        tcon_gamma_table_t *gamma_g) {
+    return PQ_GetGammaTable(panel_id, source_port, fmt, "Green", gamma_g);
+}
+
+int CPqData::PQ_GetGammaTableB(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt,
+        tcon_gamma_table_t *gamma_b) {
+    return PQ_GetGammaTable(panel_id, source_port, fmt, "Blue", gamma_b);
+}
+
+int CPqData::PQ_GetGammaTable(int panel_id, tvin_port_t source_port, tvin_sig_fmt_t fmt,
+        const char *f_name, tcon_gamma_table_t *val) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select TableName from GeneralGammaTable where "
+        "TVIN_PORT = %d and "
+        "TVIN_SIG_FMT = %d;", source_port, fmt);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        int index_TableName = 0;//c.getColumnIndex("TableName");
+        getSqlParams(__FUNCTION__, sqlmaster, "select %s from %s;", f_name,
+                c.getString(index_TableName).string());
+
+        rval = this->select(sqlmaster, c);
+        if (c.moveToFirst()) {
+            int index = 0;
+            do {
+                val->data[index] = c.getInt(0);
+                index++;
+            } while (c.moveToNext());
+        }
+    }
+    return rval;
+}
+
+int CPqData::PQ_GetVGAAjustPara(tvin_sig_fmt_t vga_fmt, tvafe_vga_parm_t *adjparam) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int rval = -1;
+
+    adjparam->clk_step = 0;
+    adjparam->phase = 0;
+    adjparam->hpos_step = 0;
+    adjparam->vpos_step = 0;
+    adjparam->vga_in_clean = 0;
+
+    getSqlParams(
+            __FUNCTION__,
+            sqlmaster,
+            "select Clk, Phase, HPos, VPos, Vga_in_clean from VGA_AutoParams where TVIN_SIG_FMT = %d",
+            vga_fmt);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        adjparam->clk_step = c.getInt(0);
+        adjparam->phase = c.getInt(1);
+        adjparam->hpos_step = c.getInt(2);
+        adjparam->vpos_step = c.getInt(3);
+        adjparam->vga_in_clean = c.getInt(4);
+    }
+    return rval;
+}
+int CPqData::PQ_SetVGAAjustPara(tvin_sig_fmt_t vga_fmt, tvafe_vga_parm_t adjparam) {
+    CSqlite::Cursor c;
+    char sql[256];
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sql, "select * from VGA_AutoParams where TVIN_SIG_FMT = %d;",
+            vga_fmt);
+
+    rval = this->select(sql, c);
+
+    if (c.moveToFirst()) {
+        getSqlParams(
+                __FUNCTION__,
+                sql,
+                "Insert into VGA_AutoParams(TVIN_SIG_FMT, Clk, Phase, HPos, VPos, Vga_in_clean) values(%d, %d, %d ,%d ,%d, %d);",
+                vga_fmt, adjparam.clk_step, adjparam.phase, adjparam.hpos_step, adjparam.vpos_step,
+                adjparam.vga_in_clean);
+    } else {
+        getSqlParams(
+                __FUNCTION__,
+                sql,
+                "update VGA_AutoParams set Clk = %d, Phase = %d, HPos = %d, VPos = %d, Vga_in_clean = %d where TVIN_SIG_FMT = %d;",
+                adjparam.clk_step, adjparam.phase, adjparam.hpos_step, adjparam.vpos_step,
+                adjparam.vga_in_clean, vga_fmt);
+    }
+    rval = this->exeSql(sql);
+    return rval;
+}
+
+int CPqData::CaculateLevelParam(tvpq_data_t *pq_data, int nodes, int level) {
+    int i;
+
+    for (i = 0; i < nodes; i++) {
+        if (level < pq_data[i].IndexValue) {
+            break;
+        }
+    }
+
+    if (i == 0) {
+        return pq_data[i].RegValue;
+    } else if (i == nodes) {
+        return pq_data[i - 1].RegValue;
+    } else {
+        return pq_data[i - 1].RegValue + (level - pq_data[i - 1].IndexValue) * pq_data[i - 1].step;
+    }
+}
+
+am_regs_t CPqData::CaculateLevelRegsParam(tvpq_sharpness_regs_t *pq_regs, int level, int flag) {
+    am_regs_t regs;
+    int i;
+    int *pq_nodes = NULL;
+    if (flag && sha_diff_flag == 6) {
+        pq_nodes = &sha_nodes_1;
+    } else {
+        pq_nodes = &sha_nodes;
+    }
+
+    for (i = 0; i < *pq_nodes; i++) {
+        if (level < pq_regs[i].reg_data[0].IndexValue) {
+            break;
+        }
+    }
+
+    if (i == 0) {
+        regs.length = pq_regs[i].length;
+        for (int j = 0; j < pq_regs[i].length; j++) {
+            regs.am_reg[j].type = pq_regs[i].reg_data[j].Value.type;
+            regs.am_reg[j].addr = pq_regs[i].reg_data[j].Value.addr;
+            regs.am_reg[j].mask = pq_regs[i].reg_data[j].Value.mask;
+            regs.am_reg[j].val = pq_regs[i].reg_data[j].Value.val;
+        }
+
+    } else if (i == *pq_nodes) {
+        regs.length = pq_regs[i - 1].length;
+        for (int j = 0; j < pq_regs[i - 1].length; j++) {
+            regs.am_reg[j].type = pq_regs[i - 1].reg_data[j].Value.type;
+            regs.am_reg[j].addr = pq_regs[i - 1].reg_data[j].Value.addr;
+            regs.am_reg[j].mask = pq_regs[i - 1].reg_data[j].Value.mask;
+            regs.am_reg[j].val = pq_regs[i - 1].reg_data[j].Value.val;
+        }
+    } else {
+        regs.length = pq_regs[i - 1].length;
+        for (int j = 0; j < pq_regs[i - 1].length; j++) {
+            regs.am_reg[j].type = pq_regs[i - 1].reg_data[j].Value.type;
+            regs.am_reg[j].addr = pq_regs[i - 1].reg_data[j].Value.addr;
+            regs.am_reg[j].mask = pq_regs[i - 1].reg_data[j].Value.mask;
+            regs.am_reg[j].val = pq_regs[i - 1].reg_data[j].Value.val + (level
+                    - pq_regs[i - 1].reg_data[j].IndexValue) * pq_regs[i - 1].reg_data[j].step;
+        }
+    }
+
+    return regs;
+}
+
+int CPqData::GetNonlinearMapping(tvpq_data_type_t data_type, tvin_port_t source_port, int level,
+        int *params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int rval = -1;
+
+    tv_source_input_type_t type;
+    //showboz
+    type = CTvin::Tvin_SourcePortToSourceInputType(source_port);//???
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select Value from NonlinearMapping where "
+        "TVIN_PORT = %d and "
+        "Item_ID = %d and "
+        "Level = %d ;", type, data_type, level);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        *params = c.getInt(0);
+    }
+    return rval;
+}
+
+int CPqData::GetNonlinearMappingByOSDFac(tvpq_data_type_t data_type,
+        tv_source_input_type_t source_type, int *params) {
+    CSqlite::Cursor c;
+    char sqlmaster[256];
+    int rval = -1;
+
+    getSqlParams(__FUNCTION__, sqlmaster, "select Value from NonlinearMapping where "
+        "TVIN_PORT = %d and "
+        "Item_ID = %d and ("
+        "Level = 0 or Level = 25 or Level = 50 or Level = 75 or Level = 100);", source_type,
+            data_type);
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        params[0] = c.getInt(0);
+        params[1] = c.getInt(1);
+        params[2] = c.getInt(2);
+        params[3] = c.getInt(3);
+        params[4] = c.getInt(4);
+    }
+    return rval;
+}
+
+int CPqData::SetNonlinearMapping(tvpq_data_type_t data_type, tv_source_input_type_t source_type,
+        int osd0, int osd25, int osd50, int osd75, int osd100) {
+
+    int rval;
+    char *err = NULL;
+    int osdvalue[101];
+    double step[4];
+    char sql[256];
+
+    step[0] = (osd25 - osd0) / 25.0;
+    step[1] = (osd50 - osd25) / 25.0;
+    step[2] = (osd75 - osd50) / 25.0;
+    step[3] = (osd100 - osd75) / 25.0;
+
+    for (int i = 0; i <= 100; i++) {
+        if (i == 0) {
+            osdvalue[i] = osd0;
+        } else if ((i > 0) && (i <= 25)) {
+            osdvalue[i] = osd0 + (int) (i * step[0]);
+        } else if ((i > 25) && (i <= 50)) {
+            osdvalue[i] = osd25 + (int) ((i - 25) * step[1]);
+        } else if ((i > 50) && (i <= 75)) {
+            osdvalue[i] = osd50 + (int) ((i - 50) * step[2]);
+        } else if ((i > 75) && (i <= 100)) {
+            osdvalue[i] = osd75 + (int) ((i - 75) * step[3]);
+        }
+        getSqlParams(
+                __FUNCTION__,
+                sql,
+                "update NonLinearMapping set Value = %d where TVIN_PORT = %d and Item_ID = %d and Level = %d ;",
+                osdvalue[i], source_type, data_type, i);
+        if (!(this->exeSql(sql))) {
+            return -1;
+        }
+    }
+    return 0;
+}
+
+int CPqData::SetNonlinearMappingByName(const char *name, tvpq_data_type_t data_type,
+        tv_source_input_type_t source_type, int osd0, int osd25, int osd50, int osd75, int osd100) {
+    int rval;
+    char *err = NULL;
+    int osdvalue[101];
+    double step[4];
+    char sql[256];
+
+    step[0] = (osd25 - osd0) / 25.0;
+    step[1] = (osd50 - osd25) / 25.0;
+    step[2] = (osd75 - osd50) / 25.0;
+    step[3] = (osd100 - osd75) / 25.0;
+
+    for (int i = 0; i <= 100; i++) {
+        if (i == 0) {
+            osdvalue[i] = osd0;
+        } else if ((i > 0) && (i <= 25)) {
+            osdvalue[i] = osd0 + (int) (i * step[0]);
+        } else if ((i > 25) && (i <= 50)) {
+            osdvalue[i] = osd25 + (int) ((i - 25) * step[1]);
+        } else if ((i > 50) && (i <= 75)) {
+            osdvalue[i] = osd50 + (int) ((i - 50) * step[2]);
+        } else if ((i > 75) && (i <= 100)) {
+            osdvalue[i] = osd75 + (int) ((i - 75) * step[3]);
+        }
+        memset(sql, '\0', 256);
+        getSqlParams(__FUNCTION__, sql,
+                "insert into %s(TVIN_PORT, Item_ID, Level, Value) values(%d,%d,%d,%d);", name,
+                source_type, data_type, i, osdvalue[i]);
+        if (!(this->exeSql(sql))) {
+            return -1;
+        }
+    }
+    return 0;
+}
+int CPqData::getSharpnessFlag() {
+    return sha_diff_flag;
+}
+
+int CPqData::loadSharpnessData(char *sqlmaster, char *table_name) {
+    LOGD("%s, table_name: %s, sqlmaster: %s\n", __FUNCTION__, table_name, sqlmaster);
+    CSqlite::Cursor c;
+    int rval;
+    int *pq_nodes = NULL;
+    int temp_flag = 0;
+
+    if (!strncmp("Sharpness_0", table_name, 11)) {//for gxtvbb:Sharpness_0_***
+        sha_diff_flag = sha_diff_flag | 2;
+        pq_nodes = &sha_nodes;
+        temp_flag = 2;
+    } else if (!strncmp("Sharpness_1", table_name, 11)) {//for gxtvbb:Sharpness_1_***
+        sha_diff_flag = sha_diff_flag | 4;
+        pq_nodes = &sha_nodes_1;
+        temp_flag = 4;
+    } else {//for g9:Sharpness_G9_***
+        sha_diff_flag = 1;
+        pq_nodes = &sha_nodes;
+        temp_flag = 1;
+    }
+    LOGD("%s, sha_diff_flag: %d, temp_flag: %d\n", __FUNCTION__, sha_diff_flag, temp_flag);
+
+    rval = this->select(sqlmaster, c);
+    int length = 0;
+    int index = 0;
+    if ((temp_flag == 1) || (temp_flag == 2)) {
+        if (c.moveToFirst()) {
+            *pq_nodes = c.getInt(0);//TotalNode?
+            length = c.getCount() / (*pq_nodes);
+            for (int i = 0; i < *pq_nodes; i++) {
+                pq_sharpness_reg_data[i].length = length;
+            }
+            do {
+                pq_sharpness_reg_data[index / length].reg_data[index % length].TotalNode
+                        = c.getInt(0);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].NodeValue
+                        = c.getInt(1);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].Value.type
+                        = c.getUInt(2);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].Value.addr
+                        = c.getUInt(3);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].Value.mask
+                        = c.getUInt(4);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].IndexValue
+                        = c.getInt(5);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].Value.val
+                        = c.getUInt(6);
+                pq_sharpness_reg_data[index / length].reg_data[index % length].step = c.getF(7);
+                index++;
+            } while (c.moveToNext());
+        }
+    } else if (temp_flag == 4) {
+        if (c.moveToFirst()) {
+            *pq_nodes = c.getInt(0);//TotalNode?
+            length = c.getCount() / (*pq_nodes);
+            for (int i = 0; i < *pq_nodes; i++) {
+                pq_sharpness_reg_data_1[i].length = length;
+            }
+            do {
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].TotalNode
+                        = c.getInt(0);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].NodeValue
+                        = c.getInt(1);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].Value.type
+                        = c.getUInt(2);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].Value.addr
+                        = c.getUInt(3);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].Value.mask
+                        = c.getUInt(4);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].IndexValue
+                        = c.getInt(5);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].Value.val
+                        = c.getUInt(6);
+                pq_sharpness_reg_data_1[index / length].reg_data[index % length].step = c.getF(7);
+                index++;
+            } while (c.moveToNext());
+        }
+    }
+    return rval;
+}
+
+int CPqData::LoadPQData(tvpq_data_type_t data_type, tvin_port_t source_port,
+        tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d, tvin_trans_fmt_t trans_fmt, int flag) {
+    CSqlite::Cursor c;
+    int rval;
+    char sqlmaster[256];
+    char table_name[128];
+    int mode = is2dOr3d;
+    tvpq_data_t *pq_data = NULL;
+    int *pq_nodes = NULL;
+
+    switch (data_type) {
+    case TVPQ_DATA_BRIGHTNESS:
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select TableName from GeneralContrastBrightnessTable where "
+                    "TVIN_PORT = %d and "
+                    "TVIN_SIG_FMT = %d and "
+                    "TVIN_TRANS_FMT = %d and "
+                    "%s = %d;", source_port, sig_fmt, mode, ID_FIELD, BRIGHTNESS_ID);
+        pq_data = pq_bri_data;
+        pq_nodes = &bri_nodes;
+        break;
+    case TVPQ_DATA_CONTRAST:
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select TableName from GeneralContrastBrightnessTable where "
+                    "TVIN_PORT = %d and "
+                    "TVIN_SIG_FMT = %d and "
+                    "TVIN_TRANS_FMT = %d and "
+                    "%s = %d;", source_port, sig_fmt, mode, ID_FIELD, CONTRAST_ID);
+        pq_data = pq_con_data;
+        pq_nodes = &con_nodes;
+        break;
+    case TVPQ_DATA_HUE:
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select TableName from GeneralSaturationHueTable where "
+                    "TVIN_PORT = %d and "
+                    "TVIN_SIG_FMT = %d and "
+                    "TVIN_TRANS_FMT = %d and "
+                    "%s = %d;", source_port, sig_fmt, mode, ID_FIELD, HUE_ID);
+        pq_data = pq_hue_data;
+        pq_nodes = &hue_nodes;
+        break;
+    case TVPQ_DATA_SATURATION:
+        getSqlParams(__FUNCTION__, sqlmaster,
+                "select TableName from GeneralSaturationHueTable where "
+                    "TVIN_PORT = %d and "
+                    "TVIN_SIG_FMT = %d and "
+                    "TVIN_TRANS_FMT = %d and "
+                    "%s = %d;", source_port, sig_fmt, mode, ID_FIELD, SATURATION_ID);
+        pq_data = pq_sat_data;
+        pq_nodes = &sat_nodes;
+        break;
+    case TVPQ_DATA_SHARPNESS:
+        //sprintf(sqlmaster, "select TableName from GeneralSharpnessTable where "
+        getSqlParams(__FUNCTION__,sqlmaster,
+                "select TableName from GeneralSharpnessG9Table where "
+                "TVIN_PORT = %d and "
+                "TVIN_SIG_FMT = %d and "
+                "TVIN_TRANS_FMT = %d and "
+                "%s = %d;", source_port, sig_fmt, mode, ID_FIELD, SHARPNESS_ID);
+        pq_data = NULL;
+        pq_nodes = &sha_nodes;
+        break;
+    default:
+        break;
+    }
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        switch (data_type) {
+        case TVPQ_DATA_BRIGHTNESS:
+        case TVPQ_DATA_CONTRAST:
+        case TVPQ_DATA_HUE:
+        case TVPQ_DATA_SATURATION:
+            getSqlParams(
+                    __FUNCTION__,
+                    sqlmaster,
+                    "select TotalNode, NodeNumber, IndexValue, RegValue, StepUp from %s order by NodeNumber asc;",
+                    c.getString(0).string());
+            break;
+        case TVPQ_DATA_SHARPNESS:
+            do {
+                getSqlParams(__FUNCTION__, sqlmaster,
+                    "select TotalNode, NodeNumber, RegType, RegAddr, RegMask,"
+                    "IndexValue, RegValue, StepUp from %s order by NodeNumber asc;",
+                    c.getString(0).string());
+                c.getString(table_name, 0);
+                rval = loadSharpnessData(sqlmaster, table_name);
+            } while (c.moveToNext());
+            return rval;
+        default:
+            break;
+        }
+    }
+
+    rval = this->select(sqlmaster, c);
+
+    if (c.moveToFirst()) {
+        if (data_type != TVPQ_DATA_SHARPNESS) {
+            int index = 0;
+            do {
+                pq_data[index].TotalNode = c.getInt(0);
+                pq_data[index].NodeValue = c.getInt(1);
+                pq_data[index].IndexValue = c.getInt(2);
+                pq_data[index].RegValue = c.getInt(3);
+                pq_data[index].step = c.getF(4);
+                if (flag == 1) {
+                    if (data_type == TVPQ_DATA_BRIGHTNESS) {
+                        LOGD("%s, bri pq_data[%d].RegValue = %d\n", "TV", index,
+                                pq_data[index].RegValue);
+                        pq_data[index].RegValue -= 64;
+                        LOGD("%s, bri pq_data[%d].RegValue + 64 = %d\n", "TV", index,
+                                pq_data[index].RegValue);
+                    } else if (data_type == TVPQ_DATA_CONTRAST) {
+                        LOGD("%s, con pq_data[%d].RegValue = %d\n", "TV", index,
+                                pq_data[index].RegValue);
+                        pq_data[index].RegValue += 64;
+                        LOGD("%s, con pq_data[%d].RegValue + 64 = %d\n", "TV", index,
+                                pq_data[index].RegValue);
+                    }
+                }
+                index++;
+            } while (c.moveToNext());
+            *pq_nodes = index;
+        }
+    }
+
+    return rval;
+}
+
+int CPqData::LoadAllPQData(tvin_port_t source_port, tvin_sig_fmt_t sig_fmt, is_3d_type_t is2dOr3d,
+        tvin_trans_fmt_t trans_fmt, int flag) {
+    int rval = -1;
+    rval = LoadPQData(TVPQ_DATA_BRIGHTNESS, source_port, sig_fmt, is2dOr3d, trans_fmt, flag);
+    if (rval) {
+        return rval;
+    }
+    rval = LoadPQData(TVPQ_DATA_CONTRAST, source_port, sig_fmt, is2dOr3d, trans_fmt, flag);
+    if (rval) {
+        return rval;
+    }
+    rval = LoadPQData(TVPQ_DATA_SATURATION, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);
+    if (rval) {
+        return rval;
+    }
+    rval = LoadPQData(TVPQ_DATA_HUE, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);
+    if (rval) {
+        return rval;
+    }
+    rval = LoadPQData(TVPQ_DATA_SHARPNESS, source_port, sig_fmt, is2dOr3d, trans_fmt, -1);
+    if (rval) {
+        return rval;
+    }
+    return rval;
+}
+
+typedef enum initial_type_e {
+    TYPE_PMode = 0,
+    TYPE_PMode_Default,
+    TYPE_Nonlinear,
+    TYPE_NonLinear_Default,
+    TYPE_VGA_AUTO,
+    TYPE_OVERSCAN,
+} initial_type_t;
+
+const char *Pmode_name[6] = { "Picture_Mode", "Picture_Mode_Default", "NonlinearMapping",
+        "NonlinearMapping_Default", "VGA_AutoParams", "OVERSCAN" };
+
+void CPqData::initialTable(int type) {
+    vpp_pq_para_t pmode_default;
+
+    pmode_default.backlight = 100;
+    pmode_default.brightness = 50;
+    pmode_default.contrast = 50;
+    pmode_default.hue = 50;
+    pmode_default.nr = 0;
+    pmode_default.saturation = 50;
+    pmode_default.sharpness = 50;
+
+    switch (type) {
+    case TYPE_PMode:
+    case TYPE_PMode_Default:
+        for (int i = 0; i < 6; i++) {
+            for (int j = 0; j < 4; j++) {
+                PQ_SetPQModeParamsByName(Pmode_name[type], (tv_source_input_type_t) i,
+                        (vpp_picture_mode_t) j, &pmode_default);
+            }
+        }
+        break;
+    case TYPE_Nonlinear:
+    case TYPE_NonLinear_Default:
+        for (int i = 0; i < 6; i++) {
+            for (int j = 0; j < 5; j++) {
+                SetNonlinearMappingByName(Pmode_name[type], (tvpq_data_type_t) j,
+                        (tv_source_input_type_t) i, 0, (int) 255 / 4.0, (int) 255 * 2 / 4.0,
+                        (int) 255 * 3 / 4.0, 255);
+            }
+        }
+        break;
+    case TYPE_VGA_AUTO:
+        break;
+    case TYPE_OVERSCAN:
+        break;
+    }
+}
+
+/*
+ void CPqData::transferFixTable()
+ {
+ char sql[256];
+ char *err = NULL;
+ char **rsltReg = NULL;
+ int rval, rows, columns;
+ unsigned int tvin, sig, trans;
+ char tablename[256];
+
+ sprintf(sql, "Select TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, TableName from GeneralSharpnessTable where TableID = 0;");
+
+ rval = sqlite3_get_table(DB, sql, &rsltReg, &rows, &columns, &err);
+
+ if (rval) {
+ if (rsltReg != NULL) {
+ sqlite3_free_table(rsltReg);
+ rsltReg = NULL;
+ }
+ if (err != NULL) {
+ sqlite3_free(err);
+ err = NULL;
+ }
+ return;
+ } else {
+ for (int i = 1; i <= rows; i++) {
+ memset(sql, '\0', 256);
+
+ sscanf(rsltReg[i * columns], "%u", &tvin);
+ sscanf(rsltReg[i * columns + 1], "%u", &sig);
+ sscanf(rsltReg[i * columns + 2], "%u", &trans);
+ sscanf(rsltReg[i * columns + 3], "%s", tablename);
+
+ sprintf(sql, "insert into GeneralCommonTable(TVIN_PORT, TVIN_SIG_FMT, TVIN_TRANS_FMT, TableID, TableName) values(%d,%d,%d,0,\"%s\");",
+ tvin, sig, trans, tablename);
+ rval = sqlite3_exec(DB, sql, NULL, NULL, &err);
+ if (rval) {
+ if (err != NULL) {
+ sqlite3_free(err);
+ err = NULL;
+ }
+ return;
+ }
+ if (err != NULL) {
+ sqlite3_free(err);
+ err = NULL;
+ }
+ }
+ memset(sql, '\0', 256);
+ sprintf(sql,  "delete from GeneralSharpnessTable where TableID = 0;");
+ rval = sqlite3_exec(DB, sql, NULL, NULL, &err);
+ if (rval) {
+ if (err != NULL) {
+ sqlite3_free(err);
+ err = NULL;
+ }
+ return;
+ }
+ if (err != NULL) {
+ sqlite3_free(err);
+ err = NULL;
+ }
+ }
+ }
+ */
+
+int CPqData::replacePqDb(const char *newFilePath) {
+
+    CFile::delFile( PQ_DB_PATH);
+    if (newFilePath == NULL) {
+        return 0;
+    } else {
+        LOGD("path = %s", newFilePath);
+        CFile file(newFilePath);
+        int ret = file.copyTo(PQ_DB_PATH);
+        system("sync");
+        return ret;
+    }
+}
+int CPqData::PQ_GetPhaseArray(am_phase_t *am_phase) {
+    CSqlite::Cursor c;
+    int iOutRet = 0;
+    char sqlmaster[256];
+    getSqlParams(__FUNCTION__, sqlmaster, "select Phase from Phase order by Format ASC; ");
+
+    this->select(sqlmaster, c);
+    int nums = 0;
+    am_phase->length = c.getCount();
+    if (c.moveToFirst()) {
+        do {
+            am_phase->phase[nums] = c.getInt(0);//col index is 0[Phase]
+            nums++;
+        } while (c.moveToNext());
+    }
+    //
+    return nums;
+}
+