<?php
        $start_time = time();

        $username = $argv[1];
        $password = $argv[2];

        $local_db_conn = new mysqli("localhost", $username, $password);

        if($local_db_conn->connect_errno) {
                printf("Connect to veneno  $local_ip failed: %s", $mysqli->connect_error);
                exit();
        }

        $org_query_sql = "SELECT DISTINCT org_id FROM data_cleanup.voucher_campaign_users";

        echo "org query sql $org_query_sql\n";

        $org_query_result = $local_db_conn->query($org_query_sql);

        echo "org query result ".print_r($org_query_result, true);

        while($i = mysqli_fetch_assoc($org_query_result)) {

                $final_cleanup_voucher = "UPDATE campaigns.voucher v join data_cleanup.voucher_campaign_users l ON v.org_id = ".$i['org_id']." AND v.voucher_series_id = l.voucher_series_id AND v.issued_to = l.user_id SET v.group_id = l.group_id WHERE date(v.created_date) = l.inbox_date ";

                echo "final cleanup voucher query result $final_cleanup_voucher\n";

                $local_db_conn->query($final_cleanup_voucher);

        }

?>