package common;

import java.awt.Color;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import javax.swing.JCheckBox;

import javax.swing.JComponent;

import com.linuxense.javadbf.DBFField;

import database.SqlReservWords;

import database.SqlType;

/** îáúåêò, êîòîðûé èíêàïñóëèðóåò âñå äàííûå îá ïîëÿõ â áàçå */

public class Field {

private int position;

private DBFField field;

private SqlType sqlType=SqlType.VARCHAR;

private String sqlFieldName;

private int sqlTypeLength=100;

private JComponent visualComponent=null;

public Field(DBFField field, int position){

this.field=field;

this.position=position;

// âîçìîæíî, íåîáõîäèìî êîíâåðòèðîâàíèå ïîëåé èç òàáëèöû

this.sqlFieldName=this.replaceSqlFieldName(this.field.getName());

this.visualComponent=createJComponent();

}

public SqlType getSqlType(){

return this.sqlType;

}

public int getSqlLength(){

return sqlTypeLength;

}

private String replaceSqlFieldName(String sqlName){

if(SqlReservWords.isSqlOperator(sqlName)){

sqlName=sqlName+"_";

}

return sqlName;

}

private JComponent createJComponent(){

return new JCheckBox(this.sqlFieldName,true);

}

public void setComponentBackground(Color color){

this.visualComponent.setBackground(color);

}

public JComponent getJComponent(){

return this.visualComponent;

}

public DBFField getDbfField(){

return this.field;

}

public int getFieldPosition(){

return this.position;

}

public String getSqlFieldName(){

return this.sqlFieldName;

}

/** êîíâåðòèðîâàòü òèï DBF ôàéëà â òèï SQL*/

public String getSqlTypeFromDbfType(){

if(field.getDataType()==DBFField.FIELD_TYPE_D){

// Date

this.sqlType=SqlType.TIMESTAMP;

this.sqlTypeLength=0;

return "TIMESTAMP";

}

if(field.getDataType()==DBFField.FIELD_TYPE_F){

// Double

this.sqlType=SqlType.DOUBLE;

this.sqlTypeLength=0;

return "FLOAT";

}

if(field.getDataType()==DBFField.FIELD_TYPE_L){

// Logical

this.sqlType=SqlType.VARCHAR;

this.sqlTypeLength=5;

return "VARCHAR(5)";

}

if(field.getDataType()==DBFField.FIELD_TYPE_M){

return "VARCHAR("+field.getFieldLength()+")";

}

if(field.getDataType()==DBFField.FIELD_TYPE_N){

// Numeric // INTEGER

this.sqlTypeLength=0;

this.sqlType=SqlType.DOUBLE;

return "FLOAT";

}

if(field.getDataType()==DBFField.FIELD_TYPE_C){

// Character

this.sqlTypeLength=field.getFieldLength();

this.sqlType=SqlType.VARCHAR;

return "VARCHAR("+field.getFieldLength()+")";

}

this.sqlType=SqlType.VARCHAR;

this.sqlTypeLength=field.getFieldLength();

return "VARCHAR("+field.getFieldLength()+")";

}

public Object getObjectForSql(Object object) {

if(object==null){

return null;

}

if(this.sqlType==SqlType.DOUBLE){

try{

return new Double(object.toString());

}catch(Exception ex){

return new Double(0);

}

}

if(this.sqlType==SqlType.TIMESTAMP){

try{

java.sql.Date returnValue=new java.sql.Date(((java.util.Date)(object)).getTime());

return returnValue;

}catch(Exception ex){

java.sql.Date returnValue=new java.sql.Date( (new java.util.Date(0)).getTime());

return returnValue;

}

}

if(this.sqlType==SqlType.INTEGER){

try{

Double value=new Double(object.toString());

int intValue=value.intValue();

return new Integer(intValue);

}catch(Exception ex){

return new Integer(0);

}

}

if(this.sqlType==SqlType.VARCHAR){

try{

return (String)(object.toString());

}catch(Exception ex){

return "";

}

}

return object;

}

/** ïðåîáðàçîâàíèå ïðî÷èòàííûõ äàííûõ èç DBF â "íîðìàëüíîå" ïðåäñòàâëåíèå ðóññêèõ áóêâ */

public static String convertDosString(String value){

StringBuffer returnValue=new StringBuffer();

for(int counter=0;counter<value.length();counter++){

returnValue.append(getCharFromInteger(Integer.valueOf(value.charAt(counter)),value.charAt(counter)));

}

return returnValue.toString();

}

public static PreparedStatement getPreparedStatement(Connection connection, String tableName, Field[] fields) throws SQLException{

StringBuffer query=new StringBuffer();

query.append("INSERT INTO "+tableName+" (");

for(int counter=0;counter<fields.length;counter++){

query.append(fields[counter].getSqlFieldName());

if(counter!=(fields.length-1)){

query.append(", ");

}

}

query.append(")");

query.append(" VALUES(");

for(int counter=0;counter<fields.length;counter++){

query.append("?");

if(counter!=(fields.length-1)){

query.append(", ");

}

}

query.append(")");

return connection.prepareStatement(query.toString());

}

/** ïðåîáðàçîâàíèå ðóññêèõ ñèìâîëîâ â "íîðìàëüíîå îòîáðàæåíèå "*/

private static char getCharFromInteger(int value,char defaultValue){

if(value==(128))return 'À';

if(value==(129))return 'Á';

if(value==(130))return 'Â';

if(value==(131))return 'Ã';

if(value==(132))return 'Ä';

if(value==(133))return 'Å';

if(value==(134))return 'Æ';

if(value==(135))return 'Ç';

if(value==(136))return 'È';

if(value==(137))return 'É';

if(value==(138))return 'Ê';

if(value==(139))return 'Ë';

if(value==(140))return 'Ì';

if(value==(141))return 'Í';

if(value==(142))return 'Î';

if(value==(143))return 'Ï';

if(value==(144))return 'Ð';

if(value==(145))return 'Ñ';

if(value==(146))return 'Ò';

if(value==(147))return 'Ó';

if(value==(148))return 'Ô';

if(value==(149))return 'Õ';

if(value==(150))return 'Ö';

if(value==(151))return '×';

if(value==(152))return 'Ø';

if(value==(153))return 'Ù';

if(value==(154))return 'Ú';

if(value==(155))return 'Û';

if(value==(156))return 'Ü';

if(value==(157))return 'Ý';

if(value==(158))return 'Þ';

if(value==(159))return 'ß';

if(value==(160))return 'à';

if(value==(161))return 'á';

if(value==(162))return 'â';

if(value==(163))return 'ã';

if(value==(164))return 'ä';

if(value==(165))return 'å';

if(value==(166))return 'æ';

if(value==(167))return 'ç';

if(value==(168))return 'è';

if(value==(169))return 'é';

if(value==(170))return 'ê';

if(value==(171))return 'ë';

if(value==(172))return 'ì';

if(value==(173))return 'í';

if(value==(174))return 'î';

if(value==(175))return 'ï';

if(value==(224))return 'ð';

if(value==(225))return 'ñ';

if(value==(226))return 'ò';

if(value==(227))return 'ó';

if(value==(228))return 'ô';

if(value==(229))return 'õ';

if(value==(230))return 'ö';

if(value==(231))return '÷';

if(value==(232))return 'ø';

if(value==(233))return 'ù';

if(value==(234))return 'ú';

if(value==(235))return 'û';

if(value==(236))return 'ü';

if(value==(237))return 'ý';

if(value==(238))return 'þ';

if(value==(239))return 'ÿ';

//if(value==())return '_';

if(value==(240))return '¨';

if(value==(242))return 'ª';

if(value==(244))return '¯';

//if(value==())return '_';

//if(value==())return '_';

//if(value==())return '_';

if(value==(241))return '¸';

if(value==(252))return '¹';

if(value==(243))return 'º';

//if(value==())return '_';

//if(value==())return '_';

//if(value==())return '_';

if(value==(245))return '¿';

return defaultValue;

}

public static String getSqlCreateTable(String tableName,Field[] fields){

StringBuffer sql=new StringBuffer();

sql.append("CREATE TABLE ");

sql.append(tableName);

sql.append(" ( ");

for(int counter=0;counter<fields.length;counter++){

sql.append(fields[counter].getSqlFieldName());

sql.append(" ");

sql.append(fields[counter].getSqlTypeFromDbfType());

if(counter!=(fields.length-1)){

sql.append(", ");

}

}

sql.append(" ) ");

return sql.toString();

}

public boolean isSelected(){

try{

return ((JCheckBox)this.visualComponent).isSelected();

}catch(Exception ex){

return false;

}

}

}