<?php
if (!isset($_POST['download'])) {
?>
<div class="wrap">
<div id="icon-users" class="icon32"><br/></div>
<h2>Exportar Envíos</h2>
<form method="post" id="export-filters">
<div style="background:#ECECEC;border:1px solid #CCC;padding:0 10px;margin-top:5px;border-radius:5px;-moz-border-radius:5px;-webkit-border-radius:5px;">
<p>La exportación de Envíos se realiza en formato Excel (xls).</p>
</div>
<p class="submit">
<?php
wp_nonce_field('ie-export');
?>
<input type="hidden" name="download" value="true" />
<button id="submit" class="button button-primary">Descargar el archivo de exportación </button>
</p>
</form>
</div>
<?php
} elseif (check_admin_referer('ie-export')) {
require_once 'classes/ExportXLS.php';
$xls = new ExportXLS();
$xls->export();
}
function export_xls()
{
ini_set('memory_limit', '-1');
require "../assets/export-xls.class.modif.php";
$filename = 'LIST_INDIVIDUAL_' . date('Ymd_His') . '.xls';
$xls = new ExportXLS($filename);
$header[] = "NO";
$header[] = "INDIVIDUAL CODE";
$header[] = "CAMPAIGN";
$header[] = "MOP ID";
$header[] = "FIRSTNAME";
$header[] = "LASTNAME";
$header[] = "NICKNAME";
$header[] = "SEX";
$header[] = "DAY OF BIRTH";
$header[] = "ID TYPE";
$header[] = "ID NUMBER";
$header[] = "TELEPHONE";
$header[] = "EMAIL";
$header[] = "FB";
$header[] = "TW";
$header[] = "ADDRESS";
$header[] = "CITY";
$header[] = "POS CODE";
$header[] = "BRAND";
$header[] = "BRAND 2";
$header[] = "SOURCE TYPE";
$header[] = "SOURCE USER";
$header[] = "SOURCE EMAIL";
$header[] = "SURVEY DATE";
$header[] = "UPLOAD DATE";
$header[] = "ENTRY DATE";
$header[] = "VERIFIKASI DATE";
$header[] = "REFERRED BY";
$header[] = "DRN NUMBER";
$header[] = "STATUS VERIFIKASI";
$header[] = "AGE";
$xls->addHeader($header);
$result = $this->mdl_individual->export()->result();
$i = 1;
foreach ($result as $r) {
$row[] = $i++;
$row[] = $r->id;
$row[] = $r->campaign_id;
$row[] = $r->mop_id;
$row[] = $r->firstname;
$row[] = $r->lastname;
$row[] = $r->nickname;
$row[] = $r->sex;
$row[] = format_tanggal_excel($r->dob);
$row[] = $r->id_type;
$row[] = $r->id_number;
$row[] = $r->tlp;
$row[] = $r->email;
$row[] = $r->fb;
$row[] = $r->tw;
$row[] = $r->address;
$row[] = $r->city;
$row[] = $r->pos_code;
$row[] = $r->brand;
$row[] = $r->brand_;
$row[] = $r->source_type;
$row[] = $this->mdl_sba->get_sba_name($r->source_user);
$row[] = $r->source_user;
$row[] = format_tanggal_excel($r->survey_date);
$row[] = format_tanggal_excel($r->upload_date);
$row[] = format_tanggal_excel($r->entry_date);
$row[] = format_tanggal_excel($r->verifikasi_date);
$row[] = $r->referred;
$row[] = $r->drn_number;
$row[] = $r->status_verifikasi;
$row[] = get_age($r->dob);
$xls->addRow($row);
unset($row);
}
$xls->sendFile();
}
}
//output to xlsx
$writer = new XLSXWriter();
$writer->setAuthor($default_institutionName);
$writer->writeSheet($dataAbbottResults,"abbott",$headerAbbottResults);
$writer->writeSheet($dataRocheResults,"roche",$headerRocheResults);
$writer->writeToStdOut();
break;
case "clinicalrequestformsexcel":
//filename of the excel file to be downloaded
$filename=0;
$filename="excel.clinical.request.forms.".getFormattedDateCRB($datetime).".xls";
//create an instance of the class
$xls = new ExportXLS($filename);
//period
$from=0;
$from="$fromYear-$fromMonth-$fromDay";
$to=0;
$to="$toYear-$toMonth-$toDay";
$query=0;
if($fromYear && $fromMonth && $fromDay && $toYear && $toMonth && $toDay) {
$query=mysqlquery("select * from vl_forms_clinicalrequest where date(created)>='$from' and date(created)<='$to' order by created");
} else {
$query=mysqlquery("select * from vl_forms_clinicalrequest order by created");
}
if(mysqlnumrows($query)) {
