<?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)) {