"; echo "Today = ".$yestrdaysDate ; die;*/ $transactionTime = date("m-d-Y H:m:s"); $dateVal = date("Y-m-d"); $yearVal = date("Y"); $monthVal = date("m"); $hourVal = date("H"); $TodaySale= todaySales; $YesterdaySale =yesterdaySales; $message = ''; $yesterdaDatemy= date("m");_date("Y"); SELECT SUM(transactionAmountUSD) as TotalSales FROM fx_transaction_detail_01_2020 GROUP BY dateAdded echo $sql="select SUM(transactionAmountUSD) as 'transactionAmountUSD' from `".$DB->pre."transaction_detail_".$monthVal."_".$yearVal."` group by dateAdded"; //$sql="select SUM(transactionAmountUSD) as 'transactionAmountUSD' from `".$DB->pre."transaction_detail_".$monthVal."_".$yearVal."` group by dateAdded"; $sql="SELECT * FROM `".$DB->pre."transaction_detail_".$monthVal."_".$yearVal."` WHERE DATE(transactionTimeConverted) = '".$yestrdaysDate."' AND transactionStatus ='Failed' "; $transactionRess = $DB->dbRows($sql); //sendsms('Ding - 5 Failed','+918379820803'); //digicelmonitor@gmail.com echo '
';print_r($PrepayNation);print_r($dtone);print_r($Ding);//die();
	$message = '';
	//require(ABSPATH."/lib/class.phpmailer.inc.php");
	if(count($PrepayNation) > 0 || count($dtone) > 0 || count($Ding) > 0)
	{
		$message = 'Yesterdays '.$yestrdaysMSGDate.' 00:00:00 to '.$yestrdaysMSGDate.' 11:59:59 sale Report'. PHP_EOL ;
    	if(count($PrepayNation)>0){
    		/*$PrepayNationStr = getDataStr($PrepayNation);
    		
    		sendMailToDistributer($PrepayNationStr,'digicelmonitor@gmail.com','Digicel Monitor',$transactionTime);
    		sendMailToDistributer($PrepayNationStr,'sagarkotak@gmail.com','Sagar Kotak',$transactionTime);
    		sendMailToDistributer($PrepayNationStr,'imran@4fox.in','Imran Rizvi',$transactionTime);*/
    		$message .= "PrepayNation - ".count($PrepayNation)." Failed". PHP_EOL ;
    		////sendsms($message,'+919890372427');
    		
    	}else{
    	    	$message .= "PrepayNation - 0 Failed". PHP_EOL ;
    	}
    	if(count($dtone)>0){
    		/*$dtoneStr = getDataStr($dtone);
    		
    		sendMailToDistributer($dtoneStr,'digicelmonitor@gmail.com','Digicel Monitor',$transactionTime);
    		sendMailToDistributer($dtoneStr,'sagarkotak@gmail.com','Sagar Kotak',$transactionTime);*/
    		$message .= "Dtone - ".count($dtone)." Failed". PHP_EOL ;
    		//sendsms($message,'+919890372427');
    		//sendsmsdtone($message,'+919579668524');
    	}else{
    	    $message .= "Dtone - 0 Failed". PHP_EOL ;
    	}
    	if(count($Ding)>0){
    		/*$DingStr = getDataStr($Ding);
    		
    		sendMailToDistributer($DingStr,'digicelmonitor@gmail.com','Digicel Monitor',$transactionTime);
    		sendMailToDistributer($DingStr,'sagarkotak@gmail.com','Sagar Kotak',$transactionTime);
    		sendMailToDistributer($DingStr,'imran@4fox.in','Imran Rizvi',$transactionTime);*/
    		$message .= "Ding - ".count($Ding)." Failed";
    		//sendsms($message,'+919890372427');
    		//sendsmsding($message,'+919595199225');
    	}else{
    	    	$message .= "Ding - 0 Failed";
    	}
	    //$message = "PrepayNation - 5 Failed". PHP_EOL."Dtone - 1 Failed ". PHP_EOL."Ding - 10 Failed";
	    sendsms($message,'+919595199225');
	}
	/*$_POST['prepayNationDataCount'] = count($PrepayNation);
	$_POST['dtoneDataCount'] = count($dtone);
	$_POST['dingDataCount'] = count($Ding);
	$_POST['cronTime'] = $transactionTime;
	
	$DB->table = $DB->pre."hourly_report_log";		
	$DB->data  = $_POST;
	$DB->dbInsert();*/

}

function getDataStr($strArr){
	$str = '';
	if(count($strArr)>0){
		$str = '';
		foreach($strArr as $r){
			$str .= '';
		}
		$str .= '
Distributor Name Distributor ID Transaction Time Transaction ID Target MSISDN Transaction Amount Error Message
'.$r['distributorName'].' '.$r['distributorOrderId'].' '.$r['transactionTime'].' '.$r['transactionIdDTS'].' '.$r['targetMSISDN'].' '.$r['transactionAmountUSD'].' '.$r['altamiraErrorMessage'].'
'; } return $str; } function sendMailToDistributer($mxgContent,$emailID,$userName,$transactionTime){ $mail = new PHPMailer(); /*$mail->isSMTP(); // Set mailer to use SMTP $mail->Host = '216.198.68.162'; // Specify main and backup SMTP servers $mail->SMTPAuth = true; // Enable SMTP authentication $mail->Username = 'alert@digicel.store.com'; // SMTP username $mail->Password = 'B!N@ry1024'; // SMTP password $mail->SMTPSecure = 'tls'; // Enable TLS encryption, `ssl` also accepted $mail->Port = 25; $mail->From = 'alert@digicel.store.com'; $mail->FromName = "Prismco NOC"; $mail->AddAddress($emailID); $mail->isHTML(true); $mail->Subject = 'Last Hour Failed Report'; */ $mail->From = "topup_noc@prismco.com"; //$mail->From = "sagarkotak@gmail.com"; $mail->FromName = "Prismco NOC"; $mail->AddAddress($emailID,$userName); $mail->Subject = 'Last Hour Failed Report'; $mail->Body = ' Prismco Your Last Hour '.$transactionTime.' Failed Transaction Report '. $mxgContent .' '; $mail->ContentType = "text/html"; if($mail->send()){ $str = 'OK'; } /* print_r($str); die;*/ return $str; } /******************** Code BY Gaurav 2019-10-15 ******************/ function sendsms($messageBody,$toNumber) { $messageBody = $messageBody; $toNumber = $toNumber; include(ABSPATH.'twilio-php-master/sms.php'); } /*function sendsms1($messageBody,$toNumber) { echo $messageBody = $messageBody;echo '
'; echo $toNumber = $toNumber;echo '
'; include(ABSPATH.'twilio-php-master/sms.php'); } function sendsms2($messageBody,$toNumber) { echo $messageBody = $messageBody;echo '
'; echo $toNumber = $toNumber;echo '
'; include(ABSPATH.'twilio-php-master/sms.php'); }*/ /******************** End Code ByGaurav 2019-10-15 *************/ if($_REQUEST["xAction"]){ switch($_REQUEST["xAction"]){ case "getYesterdaysComparison": require("../connectdb.inc.php"); echo getYesterdaysComparison(); break; } } ?>