<?php
function execute_jvzoo_ipn_listner()
{
	global $wpdb;
	
	$TodaysDate = date('Y-m-d H:i:s');
	
	//--> Tracking jvZoo response.
	$page_name = APM_PHYSICAL_PATH."/logs/debug_".date("d-m-Y").".txt";	
	$fp = fopen($page_name, "a");
	$dataArr = print_r($_REQUEST, TRUE);
	fwrite($fp, $dataArr);
	
	if(isset($_REQUEST['cprodtype']) && isset($_REQUEST['ctransaction']) && sanitize_text_field($_REQUEST['cprodtype']) != '' && sanitize_text_field($_REQUEST['ctransaction']) != '')
	{
		//--> Debug Tracking Code
		$new_data_start = "\n\n".'IPN Execution start on : '.$TodaysDate;
		fwrite($fp, $new_data_start);
		
		$customer_ip = '';
		
		//---> This Query Does Duplicate Checking of Same Transaction ID // This was added by kailash because JVZoo IPN was sending duplicate data for same transaction
		$egSql = "SELECT * FROM ".$wpdb->prefix."cso_my_income` WHERE `inc_ctransreceipt` = '".addslashes_gpc(sanitize_text_field($_REQUEST['ctransreceipt']))."'";
		$egRecord = array();
		$egRecord = $wpdb->get_results($egSql, ARRAY_A);
		
		//fwrite($fp, "\n".$egSql);
		
		if(count($egRecord) <= 0)
		{
			$sql = $wpdb->prepare("INSERT INTO `".$wpdb->prefix."cso_my_income`
							 (`inc_caffitid`, `inc_ccustcc`, `inc_ccustemail`, `inc_ccustname`, `inc_ccuststate`, `inc_cproditem`, `inc_cprodtitle`, `inc_cprodtype`, `inc_ctransaction`, `inc_ctransaffiliate`, `inc_ctransamount`, `inc_ctranspaymentmethod`, `inc_ctransreceipt`, `inc_ctranstime`, `inc_ctransvendor`, `inc_cupsellreceipt`, `inc_cvendthru`, `inc_cverify`, `inc_processed`, `income_date`, `inc_ipaddress`, `cron_status`)
							 VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), %s, 'No')",
							 array(addslashes_gpc(sanitize_text_field($_REQUEST['caffitid'])), addslashes_gpc(sanitize_text_field($_REQUEST['ccustcc'])), addslashes_gpc(sanitize_text_field($_REQUEST['ccustemail'])), addslashes_gpc(sanitize_text_field($_REQUEST['ccustname'])), addslashes_gpc(sanitize_text_field($_REQUEST['ccuststate'])), addslashes_gpc(sanitize_text_field($_REQUEST['cproditem'])), addslashes_gpc(sanitize_text_field($_REQUEST['cprodtitle'])), addslashes_gpc(sanitize_text_field($_REQUEST['cprodtype'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctransaction'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctransaffiliate'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctransamount'])) ,addslashes_gpc(sanitize_text_field($_REQUEST['ctranspaymentmethod'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctransreceipt'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctranstime'])), addslashes_gpc(sanitize_text_field($_REQUEST['ctransvendor'])), addslashes_gpc(sanitize_text_field($_REQUEST['cupsellreceipt'])), addslashes_gpc(sanitize_text_field($_REQUEST['cvendthru'])), addslashes_gpc(sanitize_text_field($_REQUEST['cverify'])), 'No', $customer_ip));
			$wpdb->query($sql);
			
			//fwrite($fp, "\n".$sql);
		}
	}
	
	$new_data4 = "\n\n".'======================================================================='."\n\n";
	fwrite($fp, $new_data4);

	//---> This page will be called through IPN so, we can die it.
	exit();
}
?>