// Author:        Ricardas Stoma
// Company:       Kolmisoft
// Year:          2017
// About:         Script inserts current active calls count to database


#define SCRIPT_VERSION      "1.0"
#define SCRIPT_NAME         "m2_active_calls_data"
#define OVERWRITE_LOG_FILE  1

#include "m2_functions.c"

int main(int argc, char *argv[]) {

    MYSQL_RES *result;
    MYSQL_ROW row;

    int active_calls = 0;
    char sqlcmd[2048] = "";

    // starting sript
    m2_init("Starting M2 Active Calls Data script\n");

    // get activecalls
    if (!m2_mysql_query("SELECT COUNT(*) FROM activecalls WHERE active = 1")) {
        result = mysql_store_result(&mysql);
        if (result) {
            if (mysql_num_rows(result)) {
                row = mysql_fetch_row(result);
                if (row[0]) active_calls = atoi(row[0]);
            }
        }
        mysql_free_result(result);
    }

    m2_log("Active calls: %d\n", active_calls);

    // insert active calls
    sprintf(sqlcmd, "INSERT INTO active_calls_data(time, count) VALUES(NOW(), %d)", active_calls);
    m2_mysql_query(sqlcmd);

    // delete old data
    mysql_query(&mysql, "DELETE FROM active_calls_data WHERE time < DATE_SUB(NOW(), INTERVAL 2 DAY)");

    m2_log("Script completed\n");

    return 0;

}