#! /bin/bash

input_file=output_121
backup_file="$input_file-backup"


# backup for backup just in case
if [ -f $backup_file ]; then
    mv $backup_file $backup_file-`date '+%Y-%m-%d_%H:%M:%S'`
fi

while IFS= read -r line; do

    id=$(echo $line | awk '{print $1;}' )
    billsec=$(echo $line | awk '{print $2;}' )

    echo "id [$id] billsec [$billsec]"

    mysql -u root -pkolmisoft m2 -se "SELECT billsec, duration, user_billsec, provider_billsec, hangupcause, user_price, provider_price FROM calls  WHERE id = $id\G" > mysql_result

    db_billsec=$(cat mysql_result | grep ' billsec:' | awk '{print $2}')
    db_duration=$(cat mysql_result | grep 'duration:' | awk '{print $2}')
    db_user_billsec=$(cat mysql_result | grep 'user_billsec:' | awk '{print $2}')
    db_provider_billsec=$(cat mysql_result | grep 'provider_billsec:' | awk '{print $2}')
    db_user_price=$(cat mysql_result | grep 'user_price:' | awk '{print $2}')
    db_provider_price=$(cat mysql_result | grep 'provider_price:' | awk '{print $2}')
    db_hgc=$(cat mysql_result | grep 'hangupcause:' | awk '{print $2}')


    echo "db id: $id, user_price: $db_user_price, prov_price: $db_provider_price, duration: $db_duration, billec: $db_billsec, user_billsec: $db_user_billsec, provider_billsec: $db_provider_billsec, hgc: $db_hgc"

    echo "UPDATE calls SET hangupcause = '$db_hgc', user_price = '$db_user_price', provider_price = '$db_provider_price', duration = '$db_duration', billsec = '$db_billsec', user_billsec = '$db_user_billsec', provider_billsec = '$db_provider_billsec' WHERE id = $id;" >> $backup_file

done < $input_file




echo "Finished."