#!/bin/bash

DOMAIN="dev.movetronix.com"
CONFIG_FILE="/home/movetronix/$DOMAIN/app/config/parameters.php"
LOG="/home/movetronix/$DOMAIN/alpinesoftware/syncExtraOptionPriceFromProducts/log.log"

# --- Helper Functions ---
log() {
    echo $(date) $1
    echo "[$(date)] $1" >> "$LOG"
}

get_db_value() {
    local key="$1"
    grep "'$key'" "$CONFIG_FILE" | sed "s/.*'$key' => '\([^']*\)'.*/\1/"
}

update_price() {
    local id_attr="$1"
    local new_price="$2"
    local sql="
      UPDATE rlyp_ets_eto_attr
      SET price = $new_price
      WHERE id_ets_eto_attr = $id_attr;
    "
    mariadb -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "$sql" >> "$LOG" 2>&1
    if [ $? -eq 0 ]; then
        log "Updated id_ets_eto_attr=$id_attr to price=$new_price successfully."
    else
        log "Failed to update id_ets_eto_attr=$id_attr."
    fi
}

# --- Main ---
DB_HOST=$(get_db_value "database_host")
DB_NAME=$(get_db_value "database_name")
DB_USER=$(get_db_value "database_user")
DB_PASS=$(get_db_value "database_password")

log "Starting price update on node: $DOMAIN"

# Update example: change option ID 6 to 9.00
update_price 6 12.00

log "Done."