<?php
$root = substr($_SERVER["DOCUMENT_ROOT"], 0, -1);
require_once "{$root}/Class/Database.php";
require_once "{$root}/Function/DataTime.php";
require_once "{$root}/Class/psxlsgen.php";
$d = new Database("localhost", "gestore", "polipo", "gestione");
$r = $d->GetRows("*", "view_call", "", "", "data_att limit 50", 1);
$myxls = new PhpSimpleXlsGen();
$myxls->totalcol = 8;
$myxls->InsertText("N.Call");
$myxls->InsertText("Data Chisura");
$myxls->InsertText("Cliente");
$myxls->InsertText("CITY");
$myxls->InsertText("Tecnico");
$myxls->InsertText("Tipo Call");
$myxls->InsertText("Note");
$myxls->InsertText("Economico");
$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']);
}
$myxls->InsertText($field['n_call']);
$myxls->InsertText(Inverti_Data($field['data_att']));
$myxls->InsertText($field['cliente']);
$myxls->InsertText($field['Comune'] . " (" . $field['Targa'] . ")");
$M_PENDIDIDKAN = $list->getMPendidikan();
$M_KAWIN = array('x' => 'Seluruh Status') + $M_KAWIN;
$M_DUSUN = array('x' => 'Seluruh Dusun') + $M_DUSUN;
$M_AGAMA = array('x' => 'Seluruh Agama') + $M_AGAMA;
$M_KERJA = array('x' => 'Seluruh Pekerjaan') + $M_KERJA;
$M_PENDIDIDKAN = array('x' => 'Seluruh Pendidikan') + $M_PENDIDIDKAN;
foreach ($M_FIELD as $key => $field) {
$fieldOptions[$key] = $field[1];
}
if ($next || $download) {
if (!$errorCode) {
$penduduk = new Penduduk($ADODB);
$result = $penduduk->searchAdvance($kField, $keyword, $limit, $page, $kAgama, $kKerja, $kDusun, $kKawin, $kPendidikan, $download);
if ($download) {
require_once 'component/psxlsgen.php';
$myxls = new PhpSimpleXlsGen();
$myxls->filename = "download";
$myxls->WriteText_pos(0, 0, 'No');
$myxls->WriteText_pos(0, 1, 'NIK');
$myxls->WriteText_pos(0, 2, 'No. KTP');
$myxls->WriteText_pos(0, 3, 'Nama');
$myxls->WriteText_pos(0, 4, 'Agama');
$myxls->WriteText_pos(0, 5, 'Pekerjaan');
$myxls->WriteText_pos(0, 6, 'Alamat');
$myxls->WriteText_pos(0, 7, 'Dusun');
$myxls->WriteText_pos(0, 8, 'No. RT');
$myxls->WriteText_pos(0, 9, 'No. RW');
$myxls->WriteText_pos(0, 10, 'Tempat Lahir');
$myxls->WriteText_pos(0, 11, 'Tanggal Lahir');
$myxls->WriteText_pos(0, 12, 'Umur');
$myxls->WriteText_pos(0, 13, 'Jenis Kelamin');
