package com.reallinkbilling.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import com.reallinkbilling.db.GetDBConnection;

public class InsertNewSettingForEachShop {
	
	public static void main(String[] args) {
		Connection connection = null;
		PreparedStatement preparedStatement= null;
		ResultSet  resultSet = null;
		
		try
		{
			
			
			
			String sql = "";
			String db = "reallinkshop";
			
			connection = GetDBConnection.getDBConnection(db);
			sql = "SELECT shop_id,"
					+ "shop_code "
					+ "FROM "
					+ "shop_info_master";
			
			Map<String,String> shopDetailsMap = new HashMap<String,String>();
			
			preparedStatement = connection.prepareStatement(sql);
			
			resultSet = preparedStatement.executeQuery();
			
			while(resultSet.next())
			{
				shopDetailsMap.put(resultSet.getString(1), resultSet.getString(2));
			}
			
			
			if(resultSet != null)
			{
				resultSet.close();
				resultSet = null;
			}
			if(preparedStatement != null)
			{
				preparedStatement.close();
				preparedStatement = null;
			}
			
			for(String shopId : shopDetailsMap.keySet())
			{
				System.out.println("Shop Id : "+shopId+",Shop Code : "+shopDetailsMap.get(shopId));
				
				sql = "INSERT INTO "
						+ "`shop_settings` "
						+ "(`shop_id`, `shop_code`, `setting_name`, `setting_value`) "
						+ "VALUES ('"+shopId+"', '"+shopDetailsMap.get(shopId)+"', 'defaultWhatsAppNumber', '9999999999') "
						+ "ON DUPLICATE KEY UPDATE setting_value = setting_value";
				preparedStatement = connection.prepareStatement(sql);
				
				int i = preparedStatement.executeUpdate();
				
				if(i > 0)
				{
					System.out.println("defaultWhatsAppNumber Inserted");
				}
				
				if(preparedStatement != null)
				{
					preparedStatement.close();
					preparedStatement = null;
				}
				
				sql = "INSERT INTO "
						+ "`shop_settings` "
						+ "(`shop_id`, `shop_code`, `setting_name`, `setting_value`) "
						+ "VALUES ('"+shopId+"', '"+shopDetailsMap.get(shopId)+"', 'sendWhatsAppMessage', 'TRUE') "
						+ "ON DUPLICATE KEY UPDATE setting_value = setting_value";
				preparedStatement = connection.prepareStatement(sql);
				
				int k = preparedStatement.executeUpdate();
				if(k > 0)
				{
					System.out.println("sendWhatsAppMessage Inserted");
				}
				
				if(preparedStatement != null)
				{
					preparedStatement.close();
					preparedStatement = null;
				}
				
				sql = "INSERT INTO "
						+ "`shop_settings` "
						+ "(`shop_id`, `shop_code`, `setting_name`, `setting_value`) "
						+ "VALUES ('"+shopId+"', '"+shopDetailsMap.get(shopId)+"', 'sendWhatsAppMessageType', 'WITH_PDF') "
						+ "ON DUPLICATE KEY UPDATE setting_value = setting_value";
				preparedStatement = connection.prepareStatement(sql);
				
				int m = preparedStatement.executeUpdate();
				if(m > 0)
				{
					System.out.println("sendWhatsAppMessageType Inserted");
				}
			}
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}finally {
			if(resultSet !=null)
			{
				try {resultSet.close(); resultSet = null;} catch (SQLException e) {}
			}
			if(preparedStatement != null)
			{
				try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
			}
			if(connection != null)
			{
				
				try {connection.close();
				 connection = null;
				}catch (SQLException e) {}
			}
		}
		
		
	}

}
