kk Blog —— 通用基础

public function testEmail()
{
	$to = "1@qq.com";
	$subject = "test email";
	$message = "test email msg";
	$headers = array(
		'From' => '2@qq.cn'
	);

	if (mail($to, $subject, $message, $headers)) {
		echo "send ok";
	} else {
		echo "send fail";
	}
}

composer require phpmailer

require_once "tools/composer/vendor/autoload.php";

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;

$mail->addAttachment('path/to/file.pdf');

// 不认证
public function testEmail2()
{
	$mail = new PHPMailer();
	$mail->isSMTP();
	$mail->Host = '192.168.100.41';
	$mail->Port = 25;

	$mail->setFrom('2@qq.cn', 'secure');
	$mail->addAddress('1@qq.com', 'kk');
	$mail->Subject = 'Email Subject';
	$mail->Body = 'Email Body';
	$mail->AltBody = 'Email Body in Plain Text';

//    $mail->addAttachment('path/to/file.pdf');

	if(!$mail->send()) {
		echo "error " . $mail->ErrorInfo;
	} else {
		echo "ok";
	}
}

// SASL 认证
public function testEmail3()
{
	$mail = new PHPMailer();
	$mail->isSMTP();
	$mail->Host = '192.168.100.41';
	$mail->Port = 25;
// TODO tls ?
//    $mail->Port = 587;
//    $mail->SMTPSecure = 'tls';

// user 1
	$mail->SMTPAuth = true;
	$mail->Username = '3@qq.cn';
	$mail->Password = '123456';

	$mail->setFrom('2@qq.cn', 'secure');
	$mail->addAddress('1@qq.com', 'kk');
	$mail->Subject = 'Email Subject';
	$mail->Body = 'Email Body';
	$mail->AltBody = 'Email Body in Plain Text';

//    $mail->addAttachment('path/to/file.pdf');

	if(!$mail->send()) {
		echo "error " . $mail->ErrorInfo;
	} else {
		echo "ok";
	}
}

十进制   0 1 ... 9 10 11 ... 100 101
按十进制 A B ... Z BA BB ... BAA BAB // Z=26  ZZ=26*26        ZZZ=26*26*26
实际上   A B ... Z AA AB ... AAA AAB // Z=26  ZZ=26*26 + 26   ZZZ=26*26*26 + 26*26 + 26
	//                    转成公式  Z=26  ZZ=(Z)*26 + 26  ZZZ=(ZZ)*26 + 26

function id_to_xls($id)
{
	$k = '';
	while (true) {
		$k = chr($id % 26 + ord('A')) . $k;
		$id -= 26;
		if ($id < 0)
			break;
		$id = (int)($id / 26);
	}
	return $k;
}

function xls_to_id($xlsCol)
{
	$hh = 0;
	for ($i = 0; $i < strlen($xlsCol); $i ++) {    // ZZ = 26*26 + 26
		$hh = $hh * 26;               //      26*26
		$hh += ord($xlsCol[$i]) - ord('A') + 1; //      26
	}
	return $hh - 1;
}


for ($i = 0; $i < 26*26*26 + 26*26 + 26 + 10; $i ++) {
	$k = id_to_xls($i);
	$id = xls_to_id($k);
	echo $i, "\t", $k, "\t", $id, "\n";
}

$code = $sheet->getCell('A'.$y)->getValue();
if (strstr($code, '=') == true) {
	$code = $sheet->getCell('A'.$y)->getOldCalculatedValue();
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$l, $code);