您好,登錄后才能下訂單哦!
本篇內(nèi)容介紹了“Dwz與thinkphp整合下的數(shù)據(jù)怎么導(dǎo)出到Excel”的有關(guān)知識(shí),在實(shí)際案例的操作過(guò)程中,不少人都會(huì)遇到這樣的困境,接下來(lái)就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
本文實(shí)例講述了Dwz與thinkphp整合下的數(shù)據(jù)導(dǎo)出到Excel的方法。分享給大家供大家參考。具體方法如下:
jquery代碼如下:
復(fù)制代碼 代碼如下:
$(function(){
//_getIds方法就是獲取已選的要導(dǎo)出的數(shù)據(jù)的ID,設(shè)了兩個(gè)參數(shù)selectedIds--已選id的input名稱,targetType-->碎片模式,默認(rèn)是navTab,如果是dialog的自行修改
function _getIds(selectedIds,targetType){
var ids="";
var $box=targetType=="dialog"?$.pdialog.getCurrent():navTab.getCurrentPanel();
$box.find("input:checked").filter("[name='"+selectedIds+"']").each(function(i){
var val=$(this).val();
ids+=i==0?val:","+val;});
return ids;
}
//導(dǎo)出excel的按鈕 class=iconn,click時(shí)觸發(fā)
$(".iconn").click(
function(){
//因?yàn)檫@個(gè)方法直運(yùn)用到導(dǎo)出到excel 所以這里所需的參數(shù)變量我直接寫死了
var targetType="navTab";
var selectedIds="ids";
var postType="string";//批量選擇的話,以文本的形式獲取
var ids=_getIds(selectedIds,targetType);
if(!ids){
alertMsg.error($(".iconn").attr("warn"));
return false;
//alert("請(qǐng)選擇要導(dǎo)出的數(shù)據(jù)!");
}else{
//將獲取到的ids 傳給后臺(tái)處理
window.open("__URL__/memberExport/ids/"+ids);
}
});
});
PHP代碼如下:
復(fù)制代碼 代碼如下:
//member成員信息導(dǎo)出到excel
public function memberExport(){
$id=$_REQUEST['ids'];//獲取已選數(shù)據(jù)的ID
//echo $id;
//在這里導(dǎo)出到excel我沒(méi)有用到phpexcel,是自己寫的,很簡(jiǎn)單,相信大家都明白是什么意思,根據(jù)自己需要自行修改就行了
$filename=date('Y-m-d');
header("Pragma:public");
header("Expires:0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl;charset=gb2312");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header('Content-Disposition:attachment;filename="'.$filename.'.xls"');
header("Content-Transfer-Encoding:binary");
if(!$id){
$this->error('非法操作!');
}else{
$map['id']=array('in',$id);
$title="用戶名\t 姓名\t 部門\t 職務(wù)\t 身份證\t 職稱\t 學(xué)歷\t 畢業(yè)時(shí)間\t 錄用時(shí)間";
$title=iconv('utf-8','gbk',$title);
echo $title;
set_time_limit(0);
$offset= 0;
$length=100;
$Member = M('Member');
$list=$Member->where($map)->order('id desc')->select();
if(!$list){
$this->error('操作錯(cuò)誤!');
}else{
foreach($list as $key=>$row){
echo "\n";
echo iconv('utf-8','gbk',$row['username'])."\t";
echo iconv('utf-8','gbk',$row['name'])."\t";
echo iconv('utf-8','gbk',$row['department'])."\t";
echo iconv('utf-8','gbk',$row['zhiwu'])."\t";
echo iconv('utf-8','gbk',$row['sfz'])."\t";
echo iconv('utf-8','gbk',$row['zhicheng'])."\t";
echo iconv('utf-8','gbk',$row['xueli'])."\t";
echo iconv('utf-8','gbk',$row['bytime'])."\t";
echo iconv('utf-8','gbk',$row['lytime'])."\t";
}
$offset+=$length;
}
}
}
“Dwz與thinkphp整合下的數(shù)據(jù)怎么導(dǎo)出到Excel”的內(nèi)容就介紹到這里了,感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注億速云網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實(shí)用文章!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。