本文整理汇总了PHP中xlsWriteLabel函数的典型用法代码示例。如果您正苦于以下问题：PHP xlsWriteLabel函数的具体用法？PHP xlsWriteLabel怎么用？PHP xlsWriteLabel使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了xlsWriteLabel函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: balikTgl
$sql .= "where tgl_update>= '" . balikTgl($_POST["frm"]["tgl_awal"]) . " 00:00:00' and tgl_update<='" . balikTgl($_POST["frm"]["tgl_akhir"]) . " 23:59:59'";
$dataArray = $db_function->selectAllRows($sql);
$row++;
xlsWriteLabel($row, 0, "[debitur_trail]");
$row++;
foreach ($judulArrayTrail as $col => $data) {
xlsWriteLabel($row, $col, $data);
}
$row++;
foreach ($dataArray as $data) {
foreach ($judulArrayTrail as $col => $judul) {
$kata = $data[$col];
if (strlen($kata) > 1000) {
$kata = substr($kata, 0, 1000);
}
xlsWriteLabel($row, $col, $kata);
}
$row++;
}
xlsEOF();
exit;
}
function xlsBOF()
{
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF()
{
echo pack("ss", 0xa, 0x0);
return;
开发者ID:prabhaswara，项目名称:collateral，代码行数:31，代码来源:control_export.php
示例2: header
$tablehead = 1;
//baris berapa data mulai di tulis
$tablebody = 2;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
//xlsWriteLabel(0,0,$judul);
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "ID");
xlsWriteLabel($tablehead, $kolomhead++, "NAK");
xlsWriteLabel($tablehead, $kolomhead++, "NAMA");
xlsWriteLabel($tablehead, $kolomhead++, "NIK");
while ($data = mysql_fetch_array($result)) {
$kolombody = 0;
//gunakan xlsWriteNumber untuk penulisan nomor dan xlsWriteLabel untuk penulisan string
xlsWriteNumber($tablebody, $kolombody++, $data['id']);
xlsWriteLabel($tablebody, $kolombody++, $data['nak']);
xlsWriteLabel($tablebody, $kolombody++, $data['nama']);
xlsWriteLabel($tablebody, $kolombody++, $data['nik']);
$tablebody++;
//$nourut++;
}
xlsEOF();
exit;
开发者ID:rifky1994，项目名称:registrasi，代码行数:31，代码来源:ekspor.php
示例3: xlsBOF
xlsBOF();
/*
Make a top line on your excel sheet at line 1 (starting at 0).
The first number is the row number and the second number is the column, both are start at '0'
*/
xlsWriteLabel(0,0,"Title"); //Top Title
// Make column labels. (at line 3)
xlsWriteLabel(2,0,"Row Name"); // Row Name
$xlsRow = 3;
// Put data records from mysql by while loop.
while($row=mysql_fetch_array($result)){
xlsWriteLabel($xlsRow,0,$row['']); //Each DB Row
$xlsRow++;
}
xlsEOF();
exit();
?>
开发者ID:songolikur，项目名称:bukutamu-bootstrap，代码行数:31，代码来源:ex.php
示例4: print_expenselist_excel
function print_expenselist_excel($array, $groupid)
{
// http://www.appservnetwork.com/modules.php?name=News&file=article&sid=8
$members = get_groupmembers($groupid);
$mcount = count($members);
// construct array to hold all expense id's per member
for ($j = 0; $j < $mcount; $j++) {
$expids[$members[$j]['user_id']] = get_user_expenses_idonly($members[$j]['user_id']);
}
// Send Header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=test.xls ");
header("Content-Transfer-Encoding: binary ");
// XLS Data Cell
$result = mysql_db_query($dbname, "select id,prename,name,sname,grade from appdata where course='{$courseid}' and sec='{$section}'");
xlsBOF();
xlsWriteLabel(0, 0, "ID");
xlsWriteLabel(0, 1, "Date");
xlsWriteLabel(0, 2, "Type");
xlsWriteLabel(0, 3, "Description");
xlsWriteLabel(0, 4, "Amount");
xlsWriteLabel(0, 5, "Paid by");
for ($j = 0; $j < $mcount; $j++) {
if (!empty($members[$j]['username'])) {
$uname = " (" . $members[$j]['username'] . ")";
} else {
$uname = "";
}
xlsWriteLabel(0, 6 + $j, $members[$j]['realname'] . $uname);
}
$xlsRow = 1;
$count = count($array);
for ($i = 0; $i < $count; $i++) {
if (!empty($array[$i]['username'])) {
$uname = " (" . $array[$i]['username'] . ")";
} else {
$uname = "";
}
xlsWriteNumber($xlsRow, 0, $array[$i]['expense_id']);
xlsWriteLabel($xlsRow, 1, $array[$i]['date']);
xlsWriteLabel($xlsRow, 2, $array[$i]['type_name']);
xlsWriteLabel($xlsRow, 3, $array[$i]['description']);
xlsWriteNumber($xlsRow, 4, $array[$i]['amount']);
xlsWriteLabel($xlsRow, 5, $array[$i]['realname'] . $uname);
$x = 0;
for ($j = 0; $j < $mcount; $j++) {
// check number of participants for the expense
if (in_array($array[$i]['expense_id'], $expids[$members[$j]['user_id']])) {
$x += 1;
}
}
for ($j = 0; $j < $mcount; $j++) {
// write expense/person for each member
if (in_array($array[$i]['expense_id'], $expids[$members[$j]['user_id']])) {
xlsWriteNumber($xlsRow, 6 + $j, number_format($array[$i]['amount'] / $x, DECIMALS, DSEP, TSEP));
} else {
xlsWriteLabel($xlsRow, 6 + $j, "");
}
}
$xlsRow++;
}
xlsEOF();
exit;
}
开发者ID:Whiskey24，项目名称:GoingDutchApi，代码行数:69，代码来源:functions.php
示例5: mysql_connect
mysql_connect("localhost", "root", "");
mysql_select_db("sms");
$keyword = $_GET['keyword'];
// query menampilkan semua data
$query = "\nSELECT playsms_featureSurvey.keyword, \n playsms_tblSMSIncoming.in_sender, \n playsms_tblSMSIncoming.in_message, \n playsms_tblSMSIncoming.in_datetime\nFROM playsms_featureSurvey, playsms_tblSMSIncoming\nWHERE playsms_featureSurvey.keyword = playsms_tblSMSIncoming.in_keyword AND \n playsms_featureSurvey.keyword = '{$keyword}'\nORDER BY playsms_tblSMSIncoming.in_datetime DESC\n\n";
$hasil = mysql_query($query);
// nilai awal untuk baris cell
$noBarisCell = 1;
// nilai awal untuk nomor urut data
$noData = 1;
while ($data = mysql_fetch_array($hasil)) {
// menampilkan no. urut data
xlsWriteNumber($noBarisCell, 0, $noData);
// menampilkan data nim
xlsWriteLabel($noBarisCell, 1, $data['keyword']);
// menampilkan data nama mahasiswa
xlsWriteLabel($noBarisCell, 2, $data['in_sender']);
// menampilkan data nilai
xlsWriteLabel($noBarisCell, 3, $data['in_message']);
// menampilkan status kelulusan
xlsWriteLabel($noBarisCell, 4, $data['in_datetime']);
// increment untuk no. baris cell dan no. urut data
$noBarisCell++;
$noData++;
}
// memanggil function penanda akhir file excel
xlsEOF();
exit;
?>
开发者ID:erdincay，项目名称:playSMS-extra-plugin，代码行数:29，代码来源:reportxls.php
示例6: xlsWriteLabel
xlsWriteLabel(0, 10, mb_convert_encoding("聯絡人", "Big5", "UTF-8"));
xlsWriteLabel(0, 11, mb_convert_encoding("電話", "Big5", "UTF-8"));
while ($ly = @mysql_fetch_array($q_mid)) {
$a++;
xlsWriteNumber($a, 0, $a);
xlsWriteLabel($a, 1, $ly[mid]);
xlsWriteLabel($a, 2, $ly[tid]);
xlsWriteLabel($a, 3, $ly[midf]);
xlsWriteLabel($a, 4, $ly[tidf]);
xlsWriteLabel($a, 5, $ly[mcc]);
xlsWriteLabel($a, 6, mb_convert_encoding($ly[sob], "Big5", "UTF-8"));
xlsWriteLabel($a, 7, mb_convert_encoding($ly[webname], "Big5", "UTF-8"));
xlsWriteLabel($a, 8, mb_convert_encoding($ly[weburl], "Big5", "UTF-8"));
xlsWriteLabel($a, 9, $ly[comid]);
xlsWriteLabel($a, 10, mb_convert_encoding($ly[username], "Big5", "UTF-8"));
xlsWriteLabel($a, 11, mb_convert_encoding($ly[phone], "Big5", "UTF-8"));
}
xlsEOF();
exit;
} else {
if ($btm == '匯出csv') {
$Csv_fileName = "taishin_mid_{$hohsn}.csv";
$fpw = mb_convert_encoding("序,mid,tid,分期mid,分期tid,行業別,營業項目,帳單名稱,網址,統編/身份證,聯絡人,電話", "Big5", "UTF-8") . "\r\n";
while ($ly = @mysql_fetch_array($q_mid)) {
$a++;
$body = sprintf("%03d", $a) . ',' . $ly[mid] . ',' . $ly[tid] . ',' . $ly[midf] . ',' . $ly[tidf] . ',' . $ly[mcc] . ',' . $ly[sob] . ',' . $ly[webname] . ',' . $ly[weburl] . ',' . $ly[comid] . ',' . $ly[username] . ',' . $ly[phone];
$fpw .= mb_convert_encoding($body, "Big5", "UTF-8") . "\r\n";
}
header("Content-disposition: attachment; filename={$Csv_fileName}");
header("Content-Type: application/save-as");
echo $fpw;
开发者ID:sac071213，项目名称:allpay_web，代码行数:31，代码来源:mid_taishin_in.php
示例7: excel
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "users.xls";
$judul = "users";
$tablehead = 2;
$tablebody = 3;
$nourut = 1;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, $judul);
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "no");
xlsWriteLabel($tablehead, $kolomhead++, "ip_address");
xlsWriteLabel($tablehead, $kolomhead++, "username");
xlsWriteLabel($tablehead, $kolomhead++, "password");
xlsWriteLabel($tablehead, $kolomhead++, "salt");
xlsWriteLabel($tablehead, $kolomhead++, "email");
xlsWriteLabel($tablehead, $kolomhead++, "activation_code");
xlsWriteLabel($tablehead, $kolomhead++, "forgotten_password_code");
xlsWriteLabel($tablehead, $kolomhead++, "forgotten_password_time");
xlsWriteLabel($tablehead, $kolomhead++, "remember_code");
xlsWriteLabel($tablehead, $kolomhead++, "created_on");
xlsWriteLabel($tablehead, $kolomhead++, "last_login");
xlsWriteLabel($tablehead, $kolomhead++, "active");
xlsWriteLabel($tablehead, $kolomhead++, "sex");
xlsWriteLabel($tablehead, $kolomhead++, "birth_date");
xlsWriteLabel($tablehead, $kolomhead++, "yxdm");
xlsWriteLabel($tablehead, $kolomhead++, "jszw");
xlsWriteLabel($tablehead, $kolomhead++, "jszc");
xlsWriteLabel($tablehead, $kolomhead++, "jsxl");
xlsWriteLabel($tablehead, $kolomhead++, "phone");
xlsWriteLabel($tablehead, $kolomhead++, "jsinfo");
foreach ($this->users_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->ip_address);
xlsWriteLabel($tablebody, $kolombody++, $data->username);
xlsWriteLabel($tablebody, $kolombody++, $data->password);
xlsWriteLabel($tablebody, $kolombody++, $data->salt);
xlsWriteLabel($tablebody, $kolombody++, $data->email);
xlsWriteLabel($tablebody, $kolombody++, $data->activation_code);
xlsWriteLabel($tablebody, $kolombody++, $data->forgotten_password_code);
xlsWriteNumber($tablebody, $kolombody++, $data->forgotten_password_time);
xlsWriteLabel($tablebody, $kolombody++, $data->remember_code);
xlsWriteNumber($tablebody, $kolombody++, $data->created_on);
xlsWriteNumber($tablebody, $kolombody++, $data->last_login);
xlsWriteLabel($tablebody, $kolombody++, $data->active);
xlsWriteLabel($tablebody, $kolombody++, $data->sex);
xlsWriteLabel($tablebody, $kolombody++, $data->birth_date);
xlsWriteLabel($tablebody, $kolombody++, $data->yxdm);
xlsWriteLabel($tablebody, $kolombody++, $data->jszw);
xlsWriteLabel($tablebody, $kolombody++, $data->jszc);
xlsWriteLabel($tablebody, $kolombody++, $data->jsxl);
xlsWriteNumber($tablebody, $kolombody++, $data->phone);
xlsWriteLabel($tablebody, $kolombody++, $data->jsinfo);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
开发者ID:super99199，项目名称:oasystem，代码行数:71，代码来源:Users.php
示例8: pack
{
echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
echo pack("d", $Value);
return;
}
function xlsWriteLabel($Row, $Col, $Value)
{
$L = strlen($Value);
echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
echo $Value;
return;
}
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=Mailing-List.xls");
header("Content-Transfer-Encoding: binary");
xlsBOF();
xlsWriteLabel(0, 0, "#");
xlsWriteLabel(0, 1, "Email");
$query = mysql_query("SELECT * FROM bow_mailinglist_tbl ORDER BY email_ad ASC");
$i = 0;
while ($rows = mysql_fetch_assoc($query)) {
$i++;
xlsWriteLabel($i, 0, $i);
xlsWriteLabel($i, 1, $rows['email_ad']);
}
xlsEOF();
开发者ID:royanonuevo，项目名称:My-Web-Kit，代码行数:31，代码来源:export-to-excel-file.php
示例9: xlsWriteLabel
xlsWriteLabel(0, 6, "Note");
xlsWriteLabel(0, 7, "Economico");
$xlsRow = 1;
$tot_economico = 0;
foreach ($r as $key => $field) {
if ($field['n_pdl'] > "1") {
$economico = floatval($field['econ']) * floatval($field['n_pdl']);
$compenso = floatval($field['prz']) * floatval($field['n_pdl']);
} else {
$economico = floatval($field['econ']);
$compenso = floatval($field['prz']);
}
xlsWriteLabel($xlsRow, 0, $field['n_call']);
xlsWriteLabel($xlsRow, 1, Inverti_Data($field['data_att']));
xlsWriteLabel($xlsRow, 2, $field['cliente']);
xlsWriteLabel($xlsRow, 3, $field['Comune'] . " (" . $field['Targa'] . ")");
xlsWriteLabel($xlsRow, 4, $field['tecnico']);
xlsWriteLabel($xlsRow, 5, $field['tipo']);
xlsWriteLabel($xlsRow, 6, $field['note_call']);
xlsWriteNumber($xlsRow, 7, sprintf("%.2f", $economico));
$tot_economico += $economico;
$xlsRow++;
}
xlsWriteLabel($xlsRow, 0, "Totale: ");
xlsWriteNumber($xlsRow, 1, sprintf("%.2f", $tot_economico));
xlsWriteLabel($xlsRow + 1, 0, "Aaaaaa: ");
xlsWriteNumber($xlsRow + 1, 1, "579,33");
xlsWriteLabel($xlsRow + 2, 0, "float con virgola: ");
xlsWriteNumber($xlsRow + 2, 1, sprintf("%,2f", $tot_economico));
xlsEOF();
exit;
开发者ID:clagiordano，项目名称:weblibs，代码行数:31，代码来源:xls4.php
示例10: do_invoice_download
function do_invoice_download()
{
global $smarty;
global $rpcpbx;
global $friconf;
$rpcres = sendrequest($rpcpbx->base_dbquery("select src,dst,calldate,billsec,cost from billinginvoice where calldate >= '" . $_REQUEST['year'] . "-" . $_REQUEST['month'] . "-01 00:00:00' and calldate <= '" . $_REQUEST['year'] . "-" . $_REQUEST['month'] . "-31 23:59:59' order by calldate desc"), 0);
#CSV FORMAT
if ($_REQUEST['format'] == 'csv') {
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
Header("Content-Type: application/vnd.ms-excel");
Header("Content-Disposition: attachment; filename=billing_invoice.csv");
header("Content-Transfer-Encoding: binary ");
echo "caller,called,calldate,billsec,cost\n";
foreach ($rpcres['result_array'] as $each) {
echo $each['src'] . ',' . $each['dst'] . ',' . $each['calldate'] . ',' . $each['billsec'] . ',' . $each['cost'] . ',' . "\n";
}
exit;
} else {
include "../include/exportxls.php";
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
Header("Content-Type: application/vnd.ms-excel");
Header("Content-Disposition: attachment; filename=billing_invoice.xls");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, "src");
xlsWriteLabel(0, 1, "dst");
xlsWriteLabel(0, 2, "calldate");
xlsWriteLabel(0, 3, "billsec");
xlsWriteLabel(0, 4, "cost");
$xlsRow = 1;
foreach ($rpcres['result_array'] as $each) {
xlsWriteLabel($xlsRow, 0, $each['src']);
xlsWriteLabel($xlsRow, 1, $each['dst']);
xlsWriteLabel($xlsRow, 2, $each['calldate']);
xlsWriteLabel($xlsRow, 3, $each['billsec']);
xlsWriteLabel($xlsRow, 4, $each['cost']);
$xlsRow++;
}
xlsEOF();
exit;
}
exit;
}
开发者ID:ljhcj，项目名称:IRISCC，代码行数:47，代码来源:pbx_billing.php
示例11: excel
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "alumnos.xls";
$judul = "alumnos";
$tablehead = 2;
$tablebody = 3;
$nourut = 1;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, $judul);
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "no");
xlsWriteLabel($tablehead, $kolomhead++, "NOMBRE_ALUMNO");
xlsWriteLabel($tablehead, $kolomhead++, "APELLIDO_PATERNO");
xlsWriteLabel($tablehead, $kolomhead++, "APELLIDO_MATERNO");
xlsWriteLabel($tablehead, $kolomhead++, "EMAIL");
xlsWriteLabel($tablehead, $kolomhead++, "TELEFONO");
xlsWriteLabel($tablehead, $kolomhead++, "DIRECCION");
xlsWriteLabel($tablehead, $kolomhead++, "SEXO");
xlsWriteLabel($tablehead, $kolomhead++, "FECHA_NACIMIENTO");
xlsWriteLabel($tablehead, $kolomhead++, "DNI");
xlsWriteLabel($tablehead, $kolomhead++, "AÑO_INGRESO");
xlsWriteLabel($tablehead, $kolomhead++, "SEMESTRE_INGRESO");
xlsWriteLabel($tablehead, $kolomhead++, "CARRERA_PROFESIONAL");
xlsWriteLabel($tablehead, $kolomhead++, "TURNO");
foreach ($this->model_alumnos->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->NOMBRE_ALUMNO);
xlsWriteLabel($tablebody, $kolombody++, $data->APELLIDO_PATERNO);
xlsWriteLabel($tablebody, $kolombody++, $data->APELLIDO_MATERNO);
xlsWriteLabel($tablebody, $kolombody++, $data->EMAIL);
xlsWriteLabel($tablebody, $kolombody++, $data->TELEFONO);
xlsWriteLabel($tablebody, $kolombody++, $data->DIRECCION);
xlsWriteLabel($tablebody, $kolombody++, $data->SEXO);
xlsWriteNumber($tablebody, $kolombody++, $data->FECHA_NACIMIENTO);
xlsWriteNumber($tablebody, $kolombody++, $data->DNI);
xlsWriteNumber($tablebody, $kolombody++, $data->AÑO_INGRESO);
xlsWriteLabel($tablebody, $kolombody++, $data->SEMESTRE_INGRESO);
xlsWriteLabel($tablebody, $kolombody++, $data->CARRERA_PROFESIONAL);
xlsWriteLabel($tablebody, $kolombody++, $data->TURNO);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
开发者ID:actcux，项目名称:ProyectoNotasQr，代码行数:57，代码来源:Alumnos.php
示例12: xlsWriteLabel
xlsWriteLabel(0, 12, mb_convert_encoding("次特店網址", "Big5", "UTF-8"));
while ($ly = @mysql_fetch_array($q_mid)) {
$a++;
xlsWriteNumber($a, 0, $a);
xlsWriteLabel($a, 1, $ly[mid]);
xlsWriteLabel($a, 2, $ly[tid]);
xlsWriteLabel($a, 3, mb_convert_encoding($ly[day_3d], "Big5", "UTF-8"));
xlsWriteLabel($a, 4, mb_convert_encoding($ly[zip], "Big5", "UTF-8"));
xlsWriteLabel($a, 5, $ly[mcc]);
xlsWriteLabel($a, 6, mb_convert_encoding($ly[webname], "Big5", "UTF-8"));
xlsWriteLabel($a, 7, $ly[ints]);
xlsWriteLabel($a, 8, $ly[red]);
xlsWriteLabel($a, 9, $ly[yes_3d]);
xlsWriteLabel($a, 10, $ly[comid]);
xlsWriteLabel($a, 11, $ly[bossid]);
xlsWriteLabel($a, 12, $ly[weburl]);
}
xlsEOF();
exit;
} else {
if ($btm == '匯出csv') {
$Csv_fileName = "taishin_mid_{$hohsn}.csv";
$fpw = mb_convert_encoding("特店數,次特店代號,端末機代號,3D生效日,區域別,MCC CODE,招牌/對外名稱,分期,紅利,3D,次特店統編,負責人ID,次特店網址", "Big5", "UTF-8") . "\r\n";
while ($ly = @mysql_fetch_array($q_mid)) {
$a++;
$body = $a . ',' . $ly[mid] . ',' . $ly[tid] . ',' . $ly[day_3d] . ',' . $ly[zip] . ',' . $ly[mcc] . ',' . $ly[webname] . ',' . $ly[ints] . ',' . $ly[red] . ',' . $ly[yes_3d] . ',' . $ly[comid] . ',' . $ly[bossid] . ',' . $ly[weburl];
$fpw .= mb_convert_encoding($body, "Big5", "UTF-8") . "\r\n";
}
header("Content-disposition: attachment; filename={$Csv_fileName}");
header("Content-Type: application/save-as");
echo $fpw;
开发者ID:sac071213，项目名称:allpay_web，代码行数:31，代码来源:mid_wantai_in.php
示例13: excel
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "guru.xls";
$judul = "guru";
$tablehead = 0;
$tablebody = 1;
$nourut = 1;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "No");
xlsWriteLabel($tablehead, $kolomhead++, "Nuptk");
xlsWriteLabel($tablehead, $kolomhead++, "Nama Guru");
xlsWriteLabel($tablehead, $kolomhead++, "Tmp Lahir");
xlsWriteLabel($tablehead, $kolomhead++, "Tgl Lahir");
xlsWriteLabel($tablehead, $kolomhead++, "Golongan");
xlsWriteLabel($tablehead, $kolomhead++, "Pend Guru");
xlsWriteLabel($tablehead, $kolomhead++, "Id Matpel");
foreach ($this->Guru_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->nuptk);
xlsWriteLabel($tablebody, $kolombody++, $data->nama_guru);
xlsWriteLabel($tablebody, $kolombody++, $data->tmp_lahir);
xlsWriteLabel($tablebody, $kolombody++, $data->tgl_lahir);
xlsWriteLabel($tablebody, $kolombody++, $data->golongan);
xlsWriteLabel($tablebody, $kolombody++, $data->pend_guru);
xlsWriteNumber($tablebody, $kolombody++, $data->id_matpel);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
开发者ID:rezaple，项目名称:CI_Basecode，代码行数:44，代码来源:Guru.php
示例14: foreach
$row = 0;
// This tells us that we are on the first row
$first = true;
// Ok we are on the first row
// lets make some headers of sorts
if ($first) {
$qcol = $q[$row];
foreach ($qcol as $k => $v) {
// take the key and make label
// make it uppper case and replace _ with ' '
xlsWriteLabel($row, $col, strtoupper(ereg_replace("_", " ", $v)));
$col++;
}
// prepare for the first real data row
$col = 0;
$first = false;
}
for ($i = 1; $i < count($q); $i++) {
$qcol = $q[$i];
// go through the data
foreach ($qcol as $k => $v) {
// write it out
xlsWriteLabel($i, $col, $v);
$col++;
}
// reset col and goto next row
$col = 0;
}
xlsEOF();
exit;
}
开发者ID:indonesia，项目名称:slims5_meranti，代码行数:31，代码来源:xlsoutput.php
示例15: excel
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "jadwal.xls";
$judul = "jadwal";
$tablehead = 0;
$tablebody = 1;
$nourut = 1;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "No");
xlsWriteLabel($tablehead, $kolomhead++, "Id Tes");
xlsWriteLabel($tablehead, $kolomhead++, "Id Kelas");
xlsWriteLabel($tablehead, $kolomhead++, "Tgl Tes");
foreach ($this->Jadwal_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteNumber($tablebody, $kolombody++, $data->id_tes);
xlsWriteNumber($tablebody, $kolombody++, $data->id_kelas);
xlsWriteLabel($tablebody, $kolombody++, $data->tgl_tes);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
开发者ID:rezaple，项目名称:CI_Basecode，代码行数:36，代码来源:Jadwal.php
示例16: header
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteHeader(0, 0, "System Name");
xlsWriteHeader(0, 1, "Usage");
xlsWriteHeader(0, 2, "Model");
xlsWriteHeader(0, 3, "Location");
xlsWriteHeader(0, 4, "Serial Number");
xlsWriteHeader(0, 5, "RFID Tag");
xlsWriteHeader(0, 6, "Asset Number");
xlsWriteHeader(0, 7, "Comments");
// xlsWriteHeader(1,0,"");
// xlsWriteHeader(1,1,"");
// xlsWriteHeader(1,2,"");
// xlsWriteHeader(1,3,"");
// xlsWriteHeader(1,4,"");
// xlsWriteHeader(1,5,"");
// xlsWriteHeader(1,6,"");
// xlsWriteHeader(1,7,"");
$xlsRow = 2;
while ($row = mysql_fetch_array($result)) {
xlsWriteLabel($xlsRow, 0, $row['system_name']);
xlsWriteLabel($xlsRow, 1, $row['system_usage']);
xlsWriteLabel($xlsRow, 2, $row['system_model']);
xlsWriteLabel($xlsRow, 3, $row['data_location_id']);
xlsWriteLabel($xlsRow, 4, $row['system_serial_number']);
xlsWriteLabel($xlsRow, 5, $row['system_rfid_tag']);
xlsWriteLabel($xlsRow, 6, $row['system_asset_number']);
xlsWriteLabel($xlsRow, 7, $row['comments']);
$xlsRow++;
}
xlsEOF();
开发者ID:erickfgb89，项目名称:randomSnippets，代码行数:31，代码来源:export_excel.php
示例17: header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=Name_wise.xls");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, "Name");
xlsWriteLabel(0, 1, "PSRN");
xlsWriteLabel(0, 2, "Book Title");
xlsWriteLabel(0, 3, "Author");
xlsWriteLabel(0, 4, "Edition");
xlsWriteLabel(0, 5, "Barcode");
xlsWriteLabel(0, 6, "Date");
xlsWriteLabel(0, 7, "Due Date");
$xlsRow = 1;
while ($row = mysql_fetch_array($result)) {
xlsWriteLabel($xlsRow, 0, $row['name']);
xlsWriteLabel($xlsRow, 1, $row['bitsid']);
xlsWriteLabel($xlsRow, 2, $row['book_title']);
xlsWriteLabel($xlsRow, 3, $row['author']);
xlsWriteLabel($xlsRow, 4, $row['edition']);
xlsWriteLabel($xlsRow, 5, $row['accession_number']);
xlsWriteLabel($xlsRow, 6, $row['date']);
xlsWriteLabel($xlsRow, 7, $row['due_date']);
$xlsRow++;
}
xlsEOF();
}
开发者ID:pravinsaini，项目名称:bplw，代码行数:31，代码来源:excel.php
示例18: search_excel
//.........这里部分代码省略.........
# get the search details:
if (isset($VAR['search_id'])) {
include_once PATH_CORE . 'search.inc.php';
$search = new CORE_search();
$search->get($VAR['search_id']);
} else {
echo '<BR> The search terms submitted were invalid!';
}
# get the sort order details:
if (isset($VAR['order_by']) && $VAR['order_by'] != "") {
$order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $VAR['order_by'];
$smarty_order = $VAR['order_by'];
} else {
$order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $construct->order_by;
$smarty_order = $search->order_by;
}
# determine the offset & limit
if (isset($VAR['page'])) {
$current_page = $VAR['page'];
} else {
$current_page = '0';
}
# determine the offset & limit
if ($current_page == 0) {
$offset = '0,10000000';
} else {
$offset = $current_page * $search->limit - $search->limit . ',' . $search->limit;
}
# format saved search string
$sql = explode(" WHERE ", $search->sql);
# generate the full query
$q = preg_replace("/%%fieldList%%/i", $field_list, $search->sql);
$q = preg_replace("/%%tableList%%/i", AGILE_DB_PREFIX . $construct->table, $q);
$q = preg_replace("/%%whereList%%/i", "", $q);
$q .= " " . AGILE_DB_PREFIX . $construct->table . ".site_id = '" . DEFAULT_SITE . "'";
$q .= $order_by;
$db =& DB();
# determine the offset & limit
$result = $db->Execute($q);
# error reporting
if ($result === false) {
global $C_debug;
$C_debug->error('core:export.inc.php', 'search_xml', $db->ErrorMsg() . '<br><br>' . $q);
echo "An SQL error has occured!";
return;
}
# put the results into an array
$i = 0;
$class_name = TRUE;
$results = '';
while (!$result->EOF) {
$results[$i] = $result->fields;
$result->MoveNext();
$i++;
}
# get any linked fields
if ($i > 0) {
$this->result = $results;
$db_join = new CORE_database();
$this->result = $db_join->join_fields($results, $this->linked);
} else {
$this->result = $results;
}
/************** END STANDARD EXPORT SEARCH CODE *********************/
# WRITE THE FIRST COLUMN
reset($arr);
$column = 0;
while (list($key, $value) = each($arr)) {
// get the translated field name
$field = $C_translate->translate('field_' . $value, $construct->module, '');
if (gettype($this->result["{$ii}"]["{$key}"]) != "string") {
xlsWriteLabel($row, $column, $field);
}
$column++;
}
# LOOP THROUGH THE RESULTS & DISPLAY AS EXCEL
$row = 1;
for ($ii = 0; $ii < count($this->result); $ii++) {
# get the data for each cell:
reset($arr);
$column = 0;
while (list($key, $value) = each($arr)) {
if ($construct->field["{$value}"][convert] == 'date' || $construct->field["{$value}"][convert] == 'time' || $construct->field["{$value}"][convert] == 'date-now' || $construct->field["{$value}"][convert] == 'date-time') {
$data = date(UNIX_DATE_FORMAT, $this->result["{$ii}"]["{$value}"]);
} else {
$data = $this->result["{$ii}"]["{$value}"];
}
if (is_numeric($data)) {
xlsWriteNumber($row, $column, $data);
} else {
xlsWriteLabel($row, $column, $data);
}
$column++;
}
$row++;
}
# Dispay the output
xlsEOF();
exit;
}
开发者ID:chiranjeevjain，项目名称:agilebill，代码行数:101，代码来源:export.inc.php
示例19: while
// nilai awal untuk nomor urut data
$noData = 1;
while ($data = mysql_fetch_array($hasil))
{
// menampilkan no. urut data
xlsWriteNumber($noBarisCell,0,$noData);
// menampilkan data nim
xlsWriteLabel($noBarisCell,1,$data['kd_barang']);
// menampilkan data nama mahasiswa
xlsWriteLabel($noBarisCell,2,$data['nama']);
// menampilkan data nilai
xlsWriteLabel($noBarisCell,3,$data['expire_date']);
// menentukan status kelulusan
//if ($data['nilai'] >= 60) $status = "LULUS";
//else $status = "TIDAK LULUS";
// menampilkan status kelulusan
xlsWriteNumber($noBarisCell,4,$data['harga_dosp']);
xlsWriteNumber($noBarisCell,5,$data['stok_ms']);
xlsWriteNumber($noBarisCell,6,$data['stok_apt']);
xlsWriteNumber($noBarisCell,7,$data['stok_rj']);
xlsWriteNumber($noBarisCell,8,$data['stok_ri']);
xlsWriteNumber($noBarisCell,9,$data['stok_igd']);
xlsWriteNumber($noBarisCell,10,$data['stok_oca']);
xlsWriteNumber($noBarisCell,11,$data['stok_lab']);
xlsWriteNumber($noBarisCell,12,$data['stok_rad']);
开发者ID:reekoheek，项目名称:srmis，代码行数:31，代码来源:lap_stok_opname.php
示例20: excel
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "facultad.xls";
$judul = "facultad";
$tablehead = 2;
$tablebody = 3;
$nourut = 1;
//penulisan header
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/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=" . $namaFile . "");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, $judul);
$kolomhead = 0;
xlsWriteLabel($tablehead, $kolomhead++, "no");
xlsWriteLabel($tablehead, $kolomhead++, "NOMBRE_FACULTAD");
foreach ($this->model_facultad->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->NOMBRE_FACULTAD);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
开发者ID:actcux，项目名称:ProyectoNotasQr，代码行数:33，代码来源:Facultad.php
注：本文中的xlsWriteLabel函数示例整理自Github/MSD |
客服电话
APP下载
官方微信
请发表评论