public function sellerpoolimport($channeltype,$res){ if($channeltype=='') return '通道类型为空'; if(!is_array($res)) return 'l数据为空'; $tool = D('Tool'); $mysql = M(); // 得到数据库连接 ini_set('memory_limit','3072M'); // 临时设置最大内存占用为3G set_time_limit(0); //设置不超时 return tryStartTrans(function () use ($tool,$mysql,$res){ $txt ='insert into yi_card_list (status,createTime,accountNo,accountPwd) values '; $num_sql = ''; foreach ($res['num'] as $k => $v) { $num = explode('|', $v); if (!is_numeric($num[0])) tryException('txt文件数据格式错误,号码不是纯数字'.$num[0]); $num_sql .= $num[0].','; } $num_sql = substr($num_sql,0,strlen($num_sql)-1); $data['res'] = $mysql->table('yi_card_list')->where(['accountNo' =>['in',$num_sql]])->select(); if (!empty($data['res'])) tryException('数据表或者txt文件存在重复号码,请重新整理号码段txt文件导入'); foreach ($res['num'] as $k => $v) { $num = explode('|', $v); $data['status'] = 10; $data['createTime'] = date("Y-m-d H:i:s"); $data['accountNo'] = $num[0]; $data['accountPwd'] =$tool->encryptToken(trim('abcdefghij'.$num[1])); $txt .= '(\''.$data['status'].'\',\''.$data['createTime'].'\',\''. $data['accountNo'].'\', \''.$data['accountPwd'].'\'),'; unset($data); } $newstr = substr($txt,0,strlen($txt)-1).';'; if(!is_numeric($mysql->execute($newstr))) tryException('导入失败,错误代码:-3'); return []; }); }