<?php
    include_once("../../cfg/db.php");

    //execute per hour
    // 1224485629880750

    // SECURITY
	if(isset($argv[1])){
		parse_str($argv[1], $params);
		
		if(isset($params['apiKey']) && $params['apiKey'] === '1224485629880750'){
            $get_request_id = $db->sql_query("SELECT request_id FROM request_status");
            foreach($get_request_id AS $data){
                $request_id = $data['request_id'];

                $count_first = $db->select("SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = $request_id"); //check if request is existing
                //echo $count; exit;
                if($count_first > 0){
                    $count = $db->select("SELECT COUNT(*) FROM `txtblast_sms_service_approved` WHERE `request_id` = $request_id AND `status` = -1"); //check if there is still pending

                    if($count == 0){
                        $checks = $db->sql_query("SELECT status FROM request_status WHERE `request_id` = $request_id"); $status = "";
                        foreach($checks AS $check){
                            $status = $check['status'];
                        }
    
                        if($status != 2){ // 2 is denied, cannot be considered
                            $db->sql_query("UPDATE request_status SET `status` = 3 WHERE `request_id` = '$request_id'"); //closed
                            $db->sql_query("UPDATE request_status_summary SET status = 3 WHERE `request_id` = '$request_id'"); //closed
                        }
                    }
                }
            }
            
		   	return; //always execute this 
		}
	}
?>