public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "tbl_kelompok.xls";
$judul = "tbl_kelompok";
$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++, "Nidn");
xlsWriteLabel($tablehead, $kolomhead++, "Dpl");
xlsWriteLabel($tablehead, $kolomhead++, "Lokasi");
xlsWriteLabel($tablehead, $kolomhead++, "Jumlah");
foreach ($this->Daftar_kelompok->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->nidn);
xlsWriteLabel($tablebody, $kolombody++, $data->dpl);
xlsWriteLabel($tablebody, $kolombody++, $data->lokasi);
xlsWriteNumber($tablebody, $kolombody++, $data->jumlah);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
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;
}
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;
}
function Create_Excel_File($ExcelFile, $Data)
{
header('Content-type: application/x-msexcel');
header("Content-Disposition: attachment; filename={$ExcelFile}");
function xlsBOF()
{
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF()
{
echo pack("ss", 0xa, 0x0);
return;
}
function xlsWriteNumber($Row, $Col, $Value)
{
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;
}
xlsBOF();
for ($i = 0; $i < count($Data[0]); $i++) {
for ($j = 0; $j < count($Data); $j++) {
$v = $Data[$j][$i];
xlsWriteLabel($j, $i, $v);
}
}
xlsEOF();
}
function Create_Excel_File($ExcelFile, $Data)
{
header("meta http-equiv='content-type' content='text/html' charset='gb2312'");
header('Content-type: application/x-msexcel');
header("Content-Disposition: attachment; filename={$ExcelFile}");
function xlsBOF()
{
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF()
{
echo pack("ss", 0xa, 0x0);
return;
}
function xlsWriteNumber($Row, $Col, $Value)
{
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 iconv('UTF-8','GB2312',$Value);
echo hebrevc($Value);
return;
}
xlsBOF();
error_log(print_r($Data, true) . "\n", 3, 'error.log');
for ($i = 0; $i < count($Data[0]); $i++) {
for ($j = 0; $j < count($Data); $j++) {
$v = $Data[$j][$i];
xlsWriteLabel($j, $i, $v);
}
}
xlsEOF();
}
function search_excel($VAR, $construct, $type)
{
global $C_translate;
# set the field list for this method:
$arr = $construct->method["{$type}"];
$filename = 'Export.xls';
# determine what action to take:
# inline display, download, email, web save
if ($VAR["type"] == "display") {
header('Content-type: application/x-msexcel');
header("Content-Disposition: inline; filename={$filename}");
header("Content-Description: PHP/INTERBASE Generated Data");
} else {
if ($VAR["type"] == "download") {
header("Content-Disposition: attachment; filename={$filename}");
} else {
if ($VAR["type"] == "email") {
echo "Email exports not supported yet!";
exit;
} else {
if ($VAR["type"] == "email") {
echo "Saving exports not supported yet!";
exit;
}
}
}
}
# Start the Excel Stream
xlsBOF();
/************** BEGIN STANDARD EXPORT SEARCH CODE *********************/
# set the field list for this method:
$arr = $construct->method["{$type}"];
# loop through the field list to create the sql queries
$arr = $construct->method[$type];
$field_list = '';
$i = 0;
while (list($key, $value) = each($arr)) {
if ($i == 0) {
$field_var = $construct->table . '_' . $value;
$field_list .= AGILE_DB_PREFIX . $construct->table . '.' . $value;
// determine if this record is linked to another table/field
if ($construct->field[$value]["asso_table"] != "") {
$this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
}
} else {
$field_var = $construct->table . '_' . $value;
$field_list .= "," . AGILE_DB_PREFIX . $construct->table . "." . $value;
// determine if this record is linked to another table/field
if ($construct->field[$value]["asso_table"] != "") {
$this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
}
}
$i++;
}
# 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;
}
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;
}
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;
}
function do_record_download()
{
global $smarty;
global $rpcpbx;
global $friconf;
//禁止使用因为某些条件
if (trim($_REQUEST['start_date']) == '' && trim($_REQUEST['end_date']) == '' && trim($_REQUEST['id']) == "") {
error_popbox(601, null, null, null, null, 'submit_failed');
}
//格式化条件
$sqlwhere = '';
//取出当前要显示的类型
if ($_REQUEST['dcontext'] == 'trunk') {
$sqlwhere .= " and dcontext like 'from-trunk%'";
} elseif ($_REQUEST['dcontext'] == 'exten') {
$sqlwhere .= " and dcontext like 'from-exten%'";
}
//取出
if (trim($_REQUEST['start_date']) != '' && trim($_REQUEST['end_date']) != '') {
$sqlwhere .= " and calldate >= '" . $_REQUEST['start_date'] . " 00:00:00' and calldate <= '" . $_REQUEST['end_date'] . " 23:59:59'";
}
if (trim($_REQUEST['src']) != '') {
$sqlwhere .= " and src like '" . preg_replace("/\\*/", "%", $_REQUEST['src']) . "'";
$smarty->assign("src", $_REQUEST['src']);
}
if (trim($_REQUEST['dst']) != '') {
$sqlwhere .= " and dst like '" . preg_replace("/\\*/", "%", $_REQUEST['dst']) . "'";
$smarty->assign("dst", $_REQUEST['dst']);
}
//如果发现了ID覆盖其他参数
if (trim($_REQUEST['id']) != "") {
$sqlwhere = "id = '" . $_REQUEST['id'] . "'";
$smarty->assign("id", $_REQUEST['id']);
}
//最后生成
$sqlwhere = preg_replace("/^ and/", "", $sqlwhere);
if (trim($sqlwhere) != '') {
$sqlwhere = 'where ' . $sqlwhere;
}
//取出所有数据
$rpcres = sendrequest($rpcpbx->base_dbquery("select * from cdr " . $sqlwhere . " order by calldate desc"), 0);
//输出
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=record.xls");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 0, "Calling Record Statistical");
xlsWriteLabel(1, 1, "calltype " . $_REQUEST['dcontext']);
xlsWriteLabel(2, 0, "Date Range " . $_REQUEST['start_date'] . " To " . $_REQUEST['end_date']);
xlsWriteLabel(3, 0, "Call From " . $_REQUEST['src'] . " To " . $_REQUEST['dst']);
// xlsWriteLabel(4,0,"calltype");
xlsWriteLabel(4, 0, "");
xlsWriteLabel(4, 1, "src");
xlsWriteLabel(4, 2, "dst");
xlsWriteLabel(4, 3, "disposition");
xlsWriteLabel(4, 4, "duration");
xlsWriteLabel(4, 5, "billsec");
xlsWriteLabel(4, 6, "calldate");
$xlsRow = 5;
foreach ($rpcres['result_array'] as $each) {
// if (preg_match("/trunk/",$each['dcontext'])) {
// xlsWriteLabel($xlsRow,0,'trunk');
// } elseif (preg_match("/exten/",$each['dcontext'])) {
// xlsWriteLabel($xlsRow,0,'exten');
// } else {
xlsWriteLabel($xlsRow, 0, '');
// }
xlsWriteLabel($xlsRow, 1, $each['src']);
xlsWriteLabel($xlsRow, 2, $each['dst']);
xlsWriteLabel($xlsRow, 3, $each['disposition']);
xlsWriteLabel($xlsRow, 4, $each['duration']);
xlsWriteLabel($xlsRow, 5, $each['billsec']);
xlsWriteLabel($xlsRow, 6, $each['calldate']);
$xlsRow++;
}
xlsEOF();
exit;
}
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "m_admin.xls";
$judul = "m_admin";
$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++, "Username");
xlsWriteLabel($tablehead, $kolomhead++, "Password");
xlsWriteLabel($tablehead, $kolomhead++, "Level");
xlsWriteLabel($tablehead, $kolomhead++, "Kon Id");
foreach ($this->Admin_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->username);
xlsWriteLabel($tablebody, $kolombody++, $data->password);
xlsWriteLabel($tablebody, $kolombody++, $data->level);
xlsWriteNumber($tablebody, $kolombody++, $data->kon_id);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "tbl_daftar_kkm.xls";
$judul = "tbl_daftar_kkm";
$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++, "Nama");
xlsWriteLabel($tablehead, $kolomhead++, "Jenis Kelamin");
xlsWriteLabel($tablehead, $kolomhead++, "Tempat Tanggal Lahir");
xlsWriteLabel($tablehead, $kolomhead++, "Fakultas");
xlsWriteLabel($tablehead, $kolomhead++, "Jurusan");
xlsWriteLabel($tablehead, $kolomhead++, "Semester");
xlsWriteLabel($tablehead, $kolomhead++, "Alamat Asal");
xlsWriteLabel($tablehead, $kolomhead++, "Alamat Sekarang");
xlsWriteLabel($tablehead, $kolomhead++, "No Telp");
xlsWriteLabel($tablehead, $kolomhead++, "Keterangan Khusus");
xlsWriteLabel($tablehead, $kolomhead++, "Persyaratan");
xlsWriteLabel($tablehead, $kolomhead++, "Foto");
xlsWriteLabel($tablehead, $kolomhead++, "Id Kelompok");
xlsWriteLabel($tablehead, $kolomhead++, "Dpl");
xlsWriteLabel($tablehead, $kolomhead++, "Surat Keterangan Kuliah");
xlsWriteLabel($tablehead, $kolomhead++, "Bukti Lunas Spp");
xlsWriteLabel($tablehead, $kolomhead++, "Formulir Pendaftaran");
foreach ($this->Daftar_peserta_kkm->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->nama);
xlsWriteLabel($tablebody, $kolombody++, $data->jenis_kelamin);
xlsWriteLabel($tablebody, $kolombody++, $data->tempat_tanggal_lahir);
xlsWriteLabel($tablebody, $kolombody++, $data->fakultas);
xlsWriteLabel($tablebody, $kolombody++, $data->jurusan);
xlsWriteLabel($tablebody, $kolombody++, $data->semester);
xlsWriteLabel($tablebody, $kolombody++, $data->alamat_asal);
xlsWriteLabel($tablebody, $kolombody++, $data->alamat_sekarang);
xlsWriteLabel($tablebody, $kolombody++, $data->no_telp);
xlsWriteLabel($tablebody, $kolombody++, $data->keterangan_khusus);
xlsWriteLabel($tablebody, $kolombody++, $data->persyaratan);
xlsWriteLabel($tablebody, $kolombody++, $data->foto);
xlsWriteNumber($tablebody, $kolombody++, $data->id_kelompok);
xlsWriteLabel($tablebody, $kolombody++, $data->dpl);
xlsWriteLabel($tablebody, $kolombody++, $data->surat_keterangan_kuliah);
xlsWriteLabel($tablebody, $kolombody++, $data->bukti_lunas_spp);
xlsWriteLabel($tablebody, $kolombody++, $data->formulir_pendaftaran);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "mahasiswa.xls";
$judul = "mahasiswa";
$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++, "Nama");
xlsWriteLabel($tablehead, $kolomhead++, "Jenis Kelamin");
xlsWriteLabel($tablehead, $kolomhead++, "Id Agama");
xlsWriteLabel($tablehead, $kolomhead++, "Hoby");
xlsWriteLabel($tablehead, $kolomhead++, "Alamat");
xlsWriteLabel($tablehead, $kolomhead++, "Tanggal Lahir");
foreach ($this->Mahasiswa_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->nama);
xlsWriteLabel($tablebody, $kolombody++, $data->jenis_kelamin);
xlsWriteNumber($tablebody, $kolombody++, $data->id_agama);
xlsWriteLabel($tablebody, $kolombody++, $data->hoby);
xlsWriteLabel($tablebody, $kolombody++, $data->alamat);
xlsWriteLabel($tablebody, $kolombody++, $data->tanggal_lahir);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "notas.xls";
$judul = "notas";
$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++, "CODIGO_NOTA");
xlsWriteLabel($tablehead, $kolomhead++, "CODIGO_ALUMNO");
xlsWriteLabel($tablehead, $kolomhead++, "CODIGO_ASIGNATURA");
xlsWriteLabel($tablehead, $kolomhead++, "PRIMER_PARCIAL");
xlsWriteLabel($tablehead, $kolomhead++, "SEGUNDA_PARCIAL");
xlsWriteLabel($tablehead, $kolomhead++, "NOTA_FINAL");
xlsWriteLabel($tablehead, $kolomhead++, "FECHA_ING_NOTAS");
xlsWriteLabel($tablehead, $kolomhead++, "SEMESTRE");
foreach ($this->model_notas->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteNumber($tablebody, $kolombody++, $data->CODIGO_NOTA);
xlsWriteLabel($tablebody, $kolombody++, $data->CODIGO_ALUMNO);
xlsWriteLabel($tablebody, $kolombody++, $data->CODIGO_ASIGNATURA);
xlsWriteNumber($tablebody, $kolombody++, $data->PRIMER_PARCIAL);
xlsWriteNumber($tablebody, $kolombody++, $data->SEGUNDA_PARCIAL);
xlsWriteNumber($tablebody, $kolombody++, $data->NOTA_FINAL);
xlsWriteNumber($tablebody, $kolombody++, $data->FECHA_ING_NOTAS);
xlsWriteLabel($tablebody, $kolombody++, $data->SEMESTRE);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
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;
}
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;
}
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "mahasiswa.xls";
$judul = "mahasiswa";
$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++, "th_akademik");
xlsWriteLabel($tablehead, $kolomhead++, "kd_prodi");
xlsWriteLabel($tablehead, $kolomhead++, "nama_mhs");
xlsWriteLabel($tablehead, $kolomhead++, "sex");
xlsWriteLabel($tablehead, $kolomhead++, "tempat_lahir");
xlsWriteLabel($tablehead, $kolomhead++, "tanggal_lahir");
xlsWriteLabel($tablehead, $kolomhead++, "alamat");
xlsWriteLabel($tablehead, $kolomhead++, "kota");
xlsWriteLabel($tablehead, $kolomhead++, "hp");
xlsWriteLabel($tablehead, $kolomhead++, "email");
xlsWriteLabel($tablehead, $kolomhead++, "nama_ayah");
xlsWriteLabel($tablehead, $kolomhead++, "nama_ibu");
xlsWriteLabel($tablehead, $kolomhead++, "alamat_ortu");
xlsWriteLabel($tablehead, $kolomhead++, "hp_ortu");
xlsWriteLabel($tablehead, $kolomhead++, "password");
xlsWriteLabel($tablehead, $kolomhead++, "file_foto");
xlsWriteLabel($tablehead, $kolomhead++, "status");
xlsWriteLabel($tablehead, $kolomhead++, "tgl_insert");
xlsWriteLabel($tablehead, $kolomhead++, "tgl_update");
foreach ($this->mahasiswa_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteLabel($tablebody, $kolombody++, $data->th_akademik);
xlsWriteLabel($tablebody, $kolombody++, $data->kd_prodi);
xlsWriteLabel($tablebody, $kolombody++, $data->nama_mhs);
xlsWriteLabel($tablebody, $kolombody++, $data->sex);
xlsWriteLabel($tablebody, $kolombody++, $data->tempat_lahir);
xlsWriteLabel($tablebody, $kolombody++, $data->tanggal_lahir);
xlsWriteLabel($tablebody, $kolombody++, $data->alamat);
xlsWriteLabel($tablebody, $kolombody++, $data->kota);
xlsWriteLabel($tablebody, $kolombody++, $data->hp);
xlsWriteLabel($tablebody, $kolombody++, $data->email);
xlsWriteLabel($tablebody, $kolombody++, $data->nama_ayah);
xlsWriteLabel($tablebody, $kolombody++, $data->nama_ibu);
xlsWriteLabel($tablebody, $kolombody++, $data->alamat_ortu);
xlsWriteLabel($tablebody, $kolombody++, $data->hp_ortu);
xlsWriteLabel($tablebody, $kolombody++, $data->password);
xlsWriteLabel($tablebody, $kolombody++, $data->file_foto);
xlsWriteLabel($tablebody, $kolombody++, $data->status);
xlsWriteLabel($tablebody, $kolombody++, $data->tgl_insert);
xlsWriteLabel($tablebody, $kolombody++, $data->tgl_update);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}
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;
}
$data['nama_siswa'][] = $res['nama_siswa'];
$data['nis'][] = $res['nis'];
$data['kelamin'][] = $res['kelamin'];
$data['alamat'][] = $res['alamat'];
$data['telpon'][] = $res['telpon'];
}
$jm = sizeof($data['id_siswa']);
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=file_siswa.xls ");
header("Content-Transfer-Encoding: binary ");
xlsBOF();
xlsWriteLabel(0, 3, "Data Siswa");
xlsWriteLabel(2, 0, "Nomor");
xlsWriteLabel(2, 1, "Nama Siswa");
xlsWriteLabel(2, 2, "NIS");
xlsWriteLabel(2, 3, "Kelamin");
xlsWriteLabel(2, 4, "Alamat");
xlsWriteLabel(2, 5, "Telpon");
$xlsRow = 3;
for ($y = 0; $y < $jm; $y++) {
++$i;
xlsWriteNumber($xlsRow, 0, "{$i}");
xlsWriteLabel($xlsRow, 1, $data['nama_siswa'][$y]);
xlsWriteLabel($xlsRow, 2, $data['nis'][$y]);
xlsWriteLabel($xlsRow, 3, $data['kelamin'][$y]);
xlsWriteLabel($xlsRow, 4, $data['alamat'][$y]);
public function excel()
{
$this->load->helper('exportexcel');
$namaFile = "m_soal.xls";
$judul = "m_soal";
$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 Guru");
xlsWriteLabel($tablehead, $kolomhead++, "Id Mapel");
xlsWriteLabel($tablehead, $kolomhead++, "Bobot");
xlsWriteLabel($tablehead, $kolomhead++, "Gambar");
xlsWriteLabel($tablehead, $kolomhead++, "Soal");
xlsWriteLabel($tablehead, $kolomhead++, "Opsi A");
xlsWriteLabel($tablehead, $kolomhead++, "Opsi B");
xlsWriteLabel($tablehead, $kolomhead++, "Opsi C");
xlsWriteLabel($tablehead, $kolomhead++, "Opsi D");
xlsWriteLabel($tablehead, $kolomhead++, "Opsi E");
xlsWriteLabel($tablehead, $kolomhead++, "Jawaban");
xlsWriteLabel($tablehead, $kolomhead++, "Tgl Input");
foreach ($this->Soal_model->get_all() as $data) {
$kolombody = 0;
//ubah xlsWriteLabel menjadi xlsWriteNumber untuk kolom numeric
xlsWriteNumber($tablebody, $kolombody++, $nourut);
xlsWriteNumber($tablebody, $kolombody++, $data->id_guru);
xlsWriteNumber($tablebody, $kolombody++, $data->id_mapel);
xlsWriteNumber($tablebody, $kolombody++, $data->bobot);
xlsWriteLabel($tablebody, $kolombody++, $data->gambar);
xlsWriteLabel($tablebody, $kolombody++, $data->soal);
xlsWriteLabel($tablebody, $kolombody++, $data->opsi_a);
xlsWriteLabel($tablebody, $kolombody++, $data->opsi_b);
xlsWriteLabel($tablebody, $kolombody++, $data->opsi_c);
xlsWriteLabel($tablebody, $kolombody++, $data->opsi_d);
xlsWriteLabel($tablebody, $kolombody++, $data->opsi_e);
xlsWriteLabel($tablebody, $kolombody++, $data->jawaban);
xlsWriteLabel($tablebody, $kolombody++, $data->tgl_input);
$tablebody++;
$nourut++;
}
xlsEOF();
exit;
}