public function getLastNikEmployee() { $sql_id = " SELECT SUBSTR(EmployeeID,3,3) as id FROM employee ORDER BY ABS(employee_id) DESC "; $q = $this->db->query($sql_id); $row = $q->row_array(); if ($row) { $id = autocode(number_format($row['id'], 0) + 1); } else { $id = autocode(0); } return substr(date('Y'), 2, 2) . $id; }
<?php /** * Created by PhpStorm. * User: master * Date: 2016/1/25 * Time: 15:14 */ require "includes/init.php"; require 'includes/lib_user.php'; require 'lang/' . $_SESSION['lang'] . '/user.php'; $nowtime = time(); $token = rawurldecode($_GET['token']); $token = autocode($token, 'DECODE', constant('KEY')); preg_match_all("/:([^:!]+)!/", $token, $match); $username = $match[1][0]; $password = md5($match[1][1]); $email = $match[1][2]; $regtime = $match[1][3]; $token_exptime = $regtime + 60 * 60 * 24; //过期时间为24小时后 if ($nowtime > $token_exptime) { $msg = $_LANG['overTime']; } else { $sql = "select id from admin.users where name='" . $username . "'"; $rst = $GLOBALS['db']->getOne($sql); if (!empty($rst)) { $msg = $_LANG['alreadyActive']; } else { $sql = "insert into admin.users(`name`,`password`,`email`,`regtime`)"; $sql .= " values ('{$username}', '{$password}','{$email}','{$regtime}')";