#!/usr/bin/php -q
<?

### DO THIS FIRST:
require_once("/BANGK!/master_config.php");

## simple password protection + cron accesses over https
 
if($_GET['cron_password'] != $master_config_cron_password) {
 	// ?cron_password=l3mm3thru
 	echo "404 - File Not Found";
 	exit;
}
 
require_once($master_config_root_path . "shared/functions.shared");


$session_is_cron_or_system_service = "YES";
require_once($master_config_root_path . "shared/session.shared");


### START SESSION VERIFICATION (ALWAYS LAST B4 REST OF PAGES):
$verified_member = "no";
$verified_business = "no";
$verified_transaction = "no";
$verified_banned = "no";
$verified_acccess = "no";
$verified_permissions = "no";
include($_SESSION['template']['company']['file_path'] . "shared/start_verified_session.shared");
#
#
#
### START REMAINING PAGES:


logger3("


#######################################################################################################
#######################################################################################################)
### START: [/images/service_scripts/CALL_transaction_courtesy_followup.php]




");


### SET THIS ###########################

$minutes_to_alert = "10080"; // 7 days, as minutes
//$minutes_to_alert = "30240"; // 21 days, as minutes
logger3("hours_to_alert",$minutes_to_alert);

########################################





$minutes_to_alert_start = $minutes_to_alert;
$minutes_to_alert_end = $minutes_to_alert + 1;

$tmp_datetime = datetime();
$tmp_qualified_transactionid_start = date("Y-m-d H:i:s",strtotime("-" . $minutes_to_alert_start . " minutes"));
$tmp_qualified_transactionid_end = date("Y-m-d H:i:s",strtotime("-" . $minutes_to_alert_end . " minutes"));


$tmp_sql = "SELECT * FROM `transactions` 
WHERE `requested_datetime` <= '".$tmp_qualified_transactionid_start."' 
AND `requested_datetime` > '".$tmp_qualified_transactionid_end."' 
AND `description` = 'DEPOSIT'
AND (status = 'APPROVED' OR status = 'COMPLETED')
AND (`return_datetime` IS NULL OR `return_datetime` = '')
AND (`week_1_followup_status` = '')
;";

logger3("tmp_sql",$tmp_sql);

$transaction_array = "";
$transaction_array = array();
$transaction_array = arrayTHECASHIER($tmp_sql);
logger3("0. transaction_array",$transaction_array);


// TESTING ONLY
//$testing_mode = "ON"; // sets everything to call NSDB
if($testing_mode == "ON") {
	$transaction_array = "";
	$transaction_array[0] = "4720";
	logger3("1. transaction_array",$transaction_array);
}






foreach($transaction_array as $key => $transactionid) {



	$_SESSION['transaction'] = $transaction_details = transaction($transactionid);
	logger3("transaction_details",$transaction_details);
	
	
	### SET' NSDB's ID FOR TESTING (UNcomment for LIVE)
	//if($testing_mode == "ON") $transaction_details['accountid'] = "2";
	
	$_SESSION['account'] = $customer_account_account_details = account($transaction_details['accountid']);
	logger3("customer_account_account_details",$customer_account_account_details);
	
	
	$_SESSION['member'] = $customer_member_details = member($customer_account_account_details['creator_memberid']);
	logger3("customer_member_details",$customer_member_details);
	
	# $authorization_number = authorization_number($customer_account_account_details['creator_memberid']);
	# logger3("authorization_number",$authorization_number);




	############################################################################################
	############################################################################################
	### START: DB/STATUS UPDATE 

	
	### GET THE TRANSACTION BATCH DETAILS
	$transaction_batch = get_the_three_transactions($transaction_details['transactionid']);
	logger3("transaction_batch",$transaction_batch);
	
	
	### CHECK to SEE IF THIS EFFORT ALREADY EXISTS:
	$tmp_sql = "SELECT * FROM `transaction_followup` WHERE transactionid = '".$transaction_details['transactionid']."';";
	logger3("tmp_sql",$tmp_sql);
	$already_exists = readTHECASHIER($tmp_sql);
	logger3("already_exists",$already_exists);
	
	
	### SET NEW EFFORT
	if(empty($already_exists)) {
		
		/// set some vars:
		$already_exists = "SET";
		$followup_status = "CALLING";
	
		$tmp_sql = "INSERT INTO `transaction_followup`
					(
						`followupid`
						, `transactionid`
						, `business_accountid`
						, `customer_accountid`
						
						, `week_1_attempt`
						, `week_1_status`
						
						, `datetime_created`
						, `datetime_updated`
					) VALUES (
						'".$followupid_blank."'
						,'".$transaction_hash = $transaction_batch['deposit']['transactionid']."'
						,'".$business_accountid = $transaction_batch['incoming']['accountid']."'
						,'".$customer_accountid = $transaction_batch['deposit']['accountid']."'
						
						,'" . $attempt = 1 . "'
						,'".$status = $followup_status."'
						
						,'".$datetime_created = datetime()."'
						,'".$datetime_updated = datetime()."'
					)";
		logger3("tmp_sql",$tmp_sql);
		$insert_results = insertTHECASHIER($tmp_sql);
		logger3("insert_results",$insert_results);
	
		
	### UPDATE EXISTING EFFORT
	} else if(
	(!empty($transaction_details['transactionid'])) &&
	(!empty($followup_status))
	) {
		
		$new_attempt = $already_exists->attempt + 1;
		
		$tmp_sql = "UPDATE `transaction_followup` 
					SET 
					`week_1_attempt` = '".$new_attempt."'
					,`datetime_updated` = '".datetime()."'
					WHERE 
					transactionid = '".$transaction_details['transactionid']."';
					";
		$insert_results = updateTHECASHIER($tmp_sql);
		logger3("insert_results",$insert_results);
	}
	### END: DB/STATUS UPDATE 
	############################################################################################
	############################################################################################


	### MAX THREE ATTEMPTS:
	//if($new_attempt < 1) {
	### SET AUTHORIZATION SESSION
	include($_SESSION['template']['company']['file_path'] . "authorizations/set_authorization_session.authi");
	$_SESSION['authorization']['filename'] = $tmp_transaction['authorization'];
	$_SESSION['authorization']['type'] = "CALL_payment_courtesy_followup";
	logger3("_SESSION['authorization']",$_SESSION['authorization']);
	
	//exit;
	
	#### MAKE THE CALL
	include($_SESSION['template']['company']['file_path'] . "authorizations/freeswitch.auth");
	logger3("CALL: origination_uuid",$origination_uuid);
	//}
	
}



echo "OK: " . $tmp_datetime;


### END VERRIFIED SESSION
#
#
#
include($_SESSION['template']['company']['file_path'] . "shared/end_verified_session.shared");
?>