#!/bin/bash
source $HOME/.gamerc

[ "$1" == "" ] && exec echo "Usage: $0 <Environment (TEST => 0, LIVE => 1)>"

SCRIPT_NAME=$(basename "$0")
LOCK_FILE="/tmp/.${SCRIPT_NAME}.lock"

exec 200>"${LOCK_FILE}"
flock -n 200 || {
                echo "${SCRIPT_NAME} is running. Exiting."
    exit 1
}

if ! type function_loaded &> /dev/null; then
	. ./additional_functions
fi

if ! type send_messages &> /dev/null; then
	send_messages_cmd="./send_messages"
else
	send_messages_cmd="send_messages"
fi

env=$1
ENV_TAG=$(get_env_tag_output ${env})
table_name="growthfund"
table_name_output="${table_name} (成長基金表)"
output_filename="/tmp/${table_name}_vs_powerupitem_item_id_monitor.log"

stop_check=$(check_table_uploading $table_name)
while true; do
	if [ "${stop_check}" -eq 0 ]; then
		echo "Waiting ${table_name_output} ..."
		stop_check=$(check_table_uploading $table_name)
	elif [ "${stop_check}" -eq -1 ]; then
		echo "Quit ${table_name_output} ..."
		break
	elif [ "${stop_check}" -eq 1 ]; then
		echo "Checking ${table_name_output} ..."
		
		# 獎勵道具ID1
		COUNT1=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id1 AS item_id FROM ${table_name} WHERE reward_item_id1 <> 0 AND reward_item_id1 NOT IN (SELECT item_id FROM powerupitem) ORDER BY reward_item_id1) SELECT COUNT(item_id) FROM t1) TO STDOUT;")

		# 獎勵道具ID2
		COUNT2=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id2 AS item_id FROM ${table_name} WHERE reward_item_id2 <> 0 AND reward_item_id2 NOT IN (SELECT item_id FROM powerupitem) ORDER BY reward_item_id2) SELECT COUNT(item_id) FROM t1) TO STDOUT;")

		# 獎勵道具ID3
		COUNT3=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id3 AS item_id FROM ${table_name} WHERE reward_item_id3 <> 0 AND reward_item_id3 NOT IN (SELECT item_id FROM powerupitem) ORDER BY reward_item_id3) SELECT COUNT(item_id) FROM t1) TO STDOUT;")

		# 獎勵道具ID4
		COUNT4=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id4 AS item_id FROM ${table_name} WHERE reward_item_id4 <> 0 AND reward_item_id4 NOT IN (SELECT item_id FROM powerupitem) ORDER BY reward_item_id4) SELECT COUNT(item_id) FROM t1) TO STDOUT;")

		# 獎勵道具ID5
		COUNT5=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id5 AS item_id FROM ${table_name} WHERE reward_item_id5 <> 0 AND reward_item_id5 NOT IN (SELECT item_id FROM powerupitem) ORDER BY reward_item_id5) SELECT COUNT(item_id) FROM t1) TO STDOUT;")

		if [ "${COUNT1}" -ne 0 ]; then
			OUTPUT=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id1 AS item_id FROM ${table_name} WHERE reward_item_id1 <> 0 AND reward_item_id1 NOT IN (SELECT item_id FROM powerupitem)) SELECT item_id FROM t1 ORDER BY item_id) TO '${output_filename}' CSV HEADER")
			$send_messages_cmd ERROR ${table_name}_vs_powerupitem_item_id "${ENV_TAG} ${table_name_output}獎勵道具ID1 設定版本內未包含的道具ID品項"
		fi

		if [ "${COUNT2}" -ne 0 ]; then
			OUTPUT=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id2 AS item_id FROM ${table_name} WHERE reward_item_id2 <> 0 AND reward_item_id2 NOT IN (SELECT item_id FROM powerupitem)) SELECT item_id FROM t1 ORDER BY item_id) TO '${output_filename}' CSV HEADER")
			$send_messages_cmd ERROR ${table_name}_vs_powerupitem_item_id "${ENV_TAG} ${table_name_output}獎勵道具ID2 設定版本內未包含的道具ID品項"
		fi

		if [ "${COUNT3}" -ne 0 ]; then
			OUTPUT=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id3 AS item_id FROM ${table_name} WHERE reward_item_id3 <> 0 AND reward_item_id3 NOT IN (SELECT item_id FROM powerupitem)) SELECT item_id FROM t1 ORDER BY item_id) TO '${output_filename}' CSV HEADER")
			$send_messages_cmd ERROR ${table_name}_vs_powerupitem_item_id "${ENV_TAG} ${table_name_output}獎勵道具ID3 設定版本內未包含的道具ID品項"
		fi

		if [ "${COUNT4}" -ne 0 ]; then
			OUTPUT=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id4 AS item_id FROM ${table_name} WHERE reward_item_id4 <> 0 AND reward_item_id4 NOT IN (SELECT item_id FROM powerupitem)) SELECT item_id FROM t1 ORDER BY item_id) TO '${output_filename}' CSV HEADER")
			$send_messages_cmd ERROR ${table_name}_vs_powerupitem_item_id "${ENV_TAG} ${table_name_output}獎勵道具ID4 設定版本內未包含的道具ID品項"
		fi

		if [ "${COUNT5}" -ne 0 ]; then
			OUTPUT=$(psql -U postgres ${ACCOUNT_DB_NAME} -c "COPY (WITH t1 AS (SELECT DISTINCT reward_item_id5 AS item_id FROM ${table_name} WHERE reward_item_id5 <> 0 AND reward_item_id5 NOT IN (SELECT item_id FROM powerupitem)) SELECT item_id FROM t1 ORDER BY item_id) TO '${output_filename}' CSV HEADER")
			$send_messages_cmd ERROR ${table_name}_vs_powerupitem_item_id "${ENV_TAG} ${table_name_output}獎勵道具ID5 設定版本內未包含的道具ID品項"
		fi

		break
	fi
done
