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 [];
});
}
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 [];
});
}