"; 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 = '
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'].' |