<script>
function saveCsv(){
var tag = $('#posSelect').val();
$.ajaxFileUpload({
url:'/admmeeting/explore',
secureuri:false,
fileElementId:'file_upload',
data:{iId:tag},
dataType: 'json',
success: function (data, status) //服务器成功响应处理函数
{
if(data.success){
alert('导入成功');
return;
}else{
alert(data.msg);
}
}
})
}
</script>
public function postExplore(){
if(Input::has('iId')){
$iId = trim(intval(Input::get('iId')));
$oYuzhiDic = RepresentMeetingYuzhi::find($iId);
if($oYuzhiDic){
$op = $oYuzhiDic->op;
}else{
echo json_encode(array('success'=>false,'msg'=>'该主题不存在'));
exit;
}
}else{
echo json_encode(array('success'=>false,'msg'=>'请选择主题'));
exit;
}
if(Input::hasFile('file_upload')){
setlocale(LC_ALL, 'zh_CN');
ini_set('max_execution_time', '600');
$file = Input::file('file_upload');
$fileType = strtolower($file->getClientOriginalExtension());
if($fileType=='csv'){
$reName = md5(date('YmdHis')).'.csv';
$file->move(public_path('uploadfile/meetingyuzhi/'),$reName);
$fh = fopen(public_path('uploadfile/meetingyuzhi/'.$reName), 'r');
$data = NULL;
$insertUser = array();
$data = fgetcsv($fh);
$user = array();
$oRep = Represent::whereNull('deleted_at')->get();
$aUser = array();
foreach($oRep as $rep){
$aUser[$rep->cwid] = array($rep->id,$rep->name,$rep->region_id,$rep->area_id,$rep->cwid,$op);
}
while($data = fgetcsv($fh)){
if(isset($aUser[$data[0]])&&!empty($data[0])){
$oUserActiv = DB::table('power_users')->where('op',$op)->where('cwid',$data[0])->first();
if(!$oUserActiv){
$user['uid'] = $aUser[$data[0]][0];
$user['name'] = $aUser[$data[0]][1];
$user['region_id'] =$aUser[$data[0]][2];
$user['area_id'] = $aUser[$data[0]][3];
$user['cwid'] = $aUser[$data[0]][4];
$user['op'] = $aUser[$data[0]][5];
$insertUser[] = $user;
if(count($insertUser) == 1000){
try{
DB::table('power_users')->insert($insertUser);
}catch(Exception $e){
echo json_encode(array('success'=>false,'msg'=>'部分数据格式不正确,或者已经存在'));
exit;
}
$insertUser = array();
}
}
}
}dd($insertUser);die;
try{
if(count($insertUser)>0){
DB::table('power_users')->insert($insertUser);
}
}catch(Exception $e){
echo json_encode(array('success'=>false,'msg'=>'部分数据格式不正确,或者已经存在'));
exit;
}
echo json_encode(array('success'=>true));
}else{
echo json_encode(array('success'=>false,'msg'=>'请选择csv格式文件'));
}
}else{
echo json_encode(array('success'=>false,'msg'=>'请选择文件'));
}
}