Tag: send

I did create a cron job with custom sql query. I want something like if postal_code lower than 1. It will send an email notification to our support team. Can someone tell me what I can insert for this case to send out email?

    <?php
    namespace ABCCheckAddressCron;
    
    use PsrLogLoggerInterface;
    
    class Test {
        protected $logger;
    
        public function __construct(LoggerInterface $logger) {
            $this->logger = $logger;
        }
    
       /**
        * Write to system.log
        *
        * @return void
        */
        public function execute() {
            //$this->logger->info('Cron Works');
            
             $objectManager = MagentoFrameworkAppObjectManager::getInstance(); 
             $resource = $objectManager->get('MagentoFrameworkAppResourceConnection');
             $connection = $resource->getConnection();
             $tableName = $resource->getTableName('sales_order_payment');
             $attribute_information = "SELECT sales_order_payment.additional_information FROM sales_order LEFT JOIN 
                sales_order_payment ON sales_order.entity_id = sales_order_payment.parent_id 
                WHERE sales_order_payment.method = 'ABCpayment' AND sales_order.updated_at >= NOW() - INTERVAL 1 MONTH";
            // fetchOne it return the one value
        //  $results = $connection->fetchOne($attribute_information);
            $results = $connection->fetchAll($attribute_information);
    
            $writer = new ZendLogWriterStream(BP . '/var/log/ABC.log');
            $logger = new ZendLogLogger();
            $logger->addWriter($writer);   
    
    
        foreach ($results as $result) {
            $json_array = implode($result);
                $data = json_decode($json_array); 
                $address_verification_json = $data->shipping_address_verification; 
                $data2 = json_decode($address_verification_json);
                $postal_code = $data2->postal_code;
            
            if ($postal_code < 1) {
                
                //$logger->info('postal_code LOWER THAN 1'); 
//SEND EMAIL TO CUSTOMER SERVICE    
                
            }
                //$logger->info('THIS IS LOWER THAN 1');  
           
                $logger->info('Flexiti');  
                $logger->info($result);  
                $logger->info($json_array);   
                $logger->info($address_verification);  
                $logger->info($postal_code);  
         
        }
    
    
    
    
            
    
        }
    }