public function import($file)
{
try {
$users = array();
$params = array(1 => 'user_name', 'user_password', 'user_first_name', 'user_last_name', 'user_email', 'user_group', 'user_vhost');
$excel = new Spreadsheet_Excel_Reader($file);
$rows = $excel->rowcount($sheet_index = 0);
$cols = $excel->colcount($sheet_index = 0);
for ($row = 2; $row <= $rows; $row++) {
if ($cols == 7) {
for ($col = 1; $col <= $cols; $col++) {
$users[$row][$params[$col]] = $excel->val($row, $col);
$users[$row]['user_vhost'] = explode(',', $excel->val($row, 7));
$users[$row]['user_group'] = '';
}
}
}
$this->userimport = new userimport();
$users = $this->userimport->import($users);
$_SESSION['message'] = $this->userimport->get_message();
return $users;
} catch (Exception $e) {
display_page_error();
}
}
/**
* Realiza la inserción o actualización de notas de un estudiante
* @param string
* @param integer
*/
function insertUpdateNotas($archivo, $anio)
{
include_once 'system/application/libraries/excel_reader2.php';
$excel = new Spreadsheet_Excel_Reader("system/excel/notas/{$archivo}");
$alumnos = $this->loadModel('Alumno_model')->getList(array('labelField' => 'id', 'valueField' => 'codigo'));
$materias = $this->loadModel('Materia_model')->getList(array('labelField' => 'id', 'valueField' => 'nombre'));
$i = 2;
$this->errors = array();
$this->db->trans_start();
while (trim($excel->val($i, 1)) != '') {
$codigo = trim($excel->val($i, 1));
if (!isset($alumnos[$codigo])) {
array_push($this->errors, "No existe un alumno con código \"{$codigo}\" fila {$i} del archivo excel");
$i++;
continue;
}
$alumno_id = $alumnos[$codigo];
$materia_nombre = trim($excel->val($i, 2));
if (!isset($materias[$materia_nombre])) {
array_push($this->errors, "No existe la materia \"{$materia_nombre}\" en la fila {$i} del archivo excel");
$i++;
continue;
}
$materia_id = $materias[$materia_nombre];
$this->setNota($alumno_id, $materia_id, $excel, $anio, $i);
$i++;
}
$this->db->trans_complete();
return $this->errors;
}
/**
* Importa la nomina de estudiantes desde una hoja excel
*/
public function import($archivo)
{
include_once 'system/application/libraries/excel_reader2.php';
$excel = new Spreadsheet_Excel_Reader("system/excel/alumnos/{$archivo}");
$i = 2;
$this->db->trans_start();
while (intval($excel->val($i, 1))) {
$codigo = intval($excel->val($i, 1));
$arr = array();
foreach ($this->columnas as $col => $pos) {
$arr[$col] = $excel->val($i, $pos);
}
$arr['sexo'] = intval($arr['sexo']) == 1 ? 'M' : 'F';
if ($alumno = $this->alumnoExiste($codigo)) {
// Actualizar
$arr['id'] = $alumno['id'];
$this->update($arr);
} else {
// Crear
$this->create($arr);
}
$i++;
}
$this->db->trans_complete();
}
function proses()
{
require 'excel_reader.php';
if (isset($_POST['submit'])) {
$target = basename($_FILES['filepegawaiall']['name']);
move_uploaded_file($_FILES['filepegawaiall']['tmp_name'], $target);
$data = new Spreadsheet_Excel_Reader($_FILES['filepegawaiall']['name'], false);
// menghitung jumlah baris file xls
$baris = $data->rowcount($sheet_index = 0);
// jika kosongkan data dicentang jalankan kode berikut
if ($_POST['drop'] == 1) {
// kosongkan tabel pegawai
$truncate = "TRUNCATE TABLE pegawai";
$this->db->query($truncate);
}
// import data excel mulai baris ke-2 (karena tabel xls ada header pada baris 1)
for ($i = 2; $i <= $baris; $i++) {
// membaca data (kolom ke-1 sd terakhir)
$nama = $data->val($i, 1);
$tempat_lahir = $data->val($i, 2);
$tanggal_lahir = $data->val($i, 3);
echo $nama;
echo " ";
echo $tempat_lahir;
echo " ";
echo $tanggal_lahir;
echo " ";
echo "<br>";
// setelah data dibaca, masukkan ke tabel pegawai sql
// $query = "INSERT into pegawai (nama,tempat_lahir,tanggal_lahir)values('$nama','$tempat_lahir','$tanggal_lahir')";
// $hasil = $this->db->query($query);
}
// if(!$hasil){
// jika import gagal
// die(mysql_error());
// }else{
// jika impor berhasil
// echo "Data berhasil diimpor.";
// }
// hapus file xls yang udah dibaca
unlink($_FILES['filepegawaiall']['name']);
}
}
function getMat($fileName)
{
error_reporting(E_ALL ^ E_NOTICE);
require_once "excel_reader2.php";
try {
$data = new Spreadsheet_Excel_Reader($fileName, false);
$mat = $data->val(5, "D", 1);
return $mat;
} catch (Exception $e) {
return "Errore in lettura";
}
}
/**
* Method untuk membaca data pada file excel
*
* @param string $path_file path file excel
* @param integer $baris_mulai_data
* @return array
*/
function data_excel($path_file, $baris_mulai_data = 2)
{
include 'excel_reader2.php';
$file_excel = new Spreadsheet_Excel_Reader($path_file);
# membaca jumlah baris dari data excel
$baris = $file_excel->rowcount($sheet_index = 0);
$kolom = $file_excel->colcount($sheet_index = 0);
$data_return = array();
for ($i = $baris_mulai_data; $i <= $baris; $i++) {
$row_data = array();
for ($k = 1; $k <= $kolom; $k++) {
$row_data[] = $file_excel->val($i, $k);
}
$data_return[] = $row_data;
}
return $data_return;
}
public function import($file)
{
try {
$users = array();
$params = array(1 => 'username', 'password', 'first_name', 'last_name', 'email', 'admin', 'active');
$excel = new Spreadsheet_Excel_Reader($file);
$rows = $excel->rowcount($sheet_index = 0);
$cols = $excel->colcount($sheet_index = 0);
for ($row = 2; $row <= $rows; $row++) {
for ($col = 1; $col <= $cols; $col++) {
$users[$row][$params[$col]] = $excel->val($row, $col);
}
}
$this->userimport = new userimport();
$users = $this->userimport->import($users);
$_SESSION['message'] = $this->userimport->get_message();
return $users;
} catch (Exception $e) {
display_page_error();
}
}
<?php
require_once "koneks.php";
error_reporting(E_ALL ^ E_NOTICE);
require_once 'excel_reader2.php';
$baris = $data->rowcount($sheet_index = 0);
// proses assigning baca data file 'data.xls'
//$data = new Spreadsheet_Excel_Reader("data.xls");
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
//-------- import dari sheet 1 ----------
// baca jumlah baris dalam sheet 1
$jmlbaris = $data->rowcount(0);
for ($i = 2; $i <= $jmlbaris; $i++) {
// baca data pada baris ke-i, kolom ke-1, pada sheet 1
$datakolom1 = $data->val($i, 1, 0);
// baca data pada baris ke-i, kolom ke-2, pada sheet 1
$datakolom2 = $data->val($i, 2, 0);
// insert data ke tabel mhs
$query = "INSERT INTO mhs (nim, namamhs) VALUES ('{$datakolom1}', '{$datakolom2}')";
mysql_query($query);
}
//-------- import dari sheet 2 ----------
// baca jumlah baris dalam sheet 2
$jmlbaris = $data->rowcount(1);
for ($i = 2; $i <= $jmlbaris; $i++) {
// baca data pada baris ke-i, kolom ke-1, pada sheet 2
$datakolom1 = $data->val($i, 1, 1);
// baca data pada baris ke-i, kolom ke-2, pada sheet 2
$datakolom2 = $data->val($i, 2, 1);
// insert data ke tabel dosen
$query = "INSERT INTO dosen (kodedosen, namadosen) VALUES ('{$datakolom1}', '{$datakolom2}')";
if($_GET['aksi']=="import"){
if(isset($_POST['submit'])){
$jenis = $_POST['jenis'];
//nilai awal counter jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
$cell = new Spreadsheet_Excel_Reader($_FILES['upfile']['tmp_name']);
$jum = $cell->rowcount($sheet_index=0);
$i = 2; // dimulai dari ke dua karena baris pertama berisi title
while( $i<=$jum ){
//$cell->val( baris,kolom )
$kode = $cell->val( $i,1 );
$nama = $cell->val( $i,2 );
$jumlah = $cell->val( $i,3 );
$hargabeli = $cell->val( $i,4 );
$hargajual = $cell->val( $i,5 );
$sql ="INSERT INTO `po_produk` (`jenis`,`kode`,`nama`,`jumlah`,`hargabeli`,`hargajual`) VALUES ('$jenis','$kode','$nama','$jumlah','$hargabeli','$hargajual')";
$hasil = mysql_query( $sql );
setsaldoawal($kode);
if($hasil){
$sukses++;
}else{
$gagal++;
}
$i++;
}
function xls_import($id, $returl = '')
{
global $_CAMILA;
require_once CAMILA_DIR . 'datagrid/form.class.php';
require_once CAMILA_DIR . 'datagrid/elements/form/hidden.php';
require_once CAMILA_DIR . 'datagrid/elements/form/filebox.php';
require_once CAMILA_DIR . 'datagrid/elements/form/static_listbox.php';
//if ($returl != '')
// $form3 = new phpform('camilastep4', $returl);
//else
$form3 = new phpform('camilastep4', 'cf_worktable_wizard_step4.php');
$form3->submitbutton = camila_get_translation('camila.wizard.next');
$form3->drawrules = false;
new form_hidden($form3, 'custom', $id);
if ($returl != '') {
new form_hidden($form3, 'returl', $_REQUEST['camila_returl']);
}
new form_filebox($form3, 'filename', camila_get_translation('camila.worktable.xls.choose'), 50, CAMILA_TMP_DIR);
$sheet_list = '';
for ($i = 0; $i < 10; $i++) {
if ($i > 0) {
$sheet_list .= ',';
}
$sheet_list .= $i . ';' . ($i + 1);
}
new form_static_listbox($form3, 'sheetnum', camila_get_translation('camila.worktable.xls.sheetnum'), $sheet_list);
$success = true;
if ($form3->process()) {
$filename = $form3->fields['filename']->value[0];
$sheetnum = $form3->fields['sheetnum']->value;
$result = $_CAMILA['db']->Execute('select short_title, scriptname, tablename, filename, sheetnum from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$table = $result->fields['tablename'];
$worktablename = $result->fields['short_title'];
$worktablescript = $result->fields['scriptname'];
if ($filename == '' && $result->fields['filename'] != '') {
$filename = $result->fields['filename'];
$sheetnum = $result->fields['sheetnum'];
}
if ($filename != '') {
require_once CAMILA_LIB_DIR . 'php-excel-reader/excel_reader2.php';
$data = new Spreadsheet_Excel_Reader(CAMILA_TMP_DIR . '/' . $filename);
$excelColNames = array();
$i = 0;
while ($data->val(1, $i + 1, $sheetnum) != '') {
$name = $data->val(1, $i + 1, $sheetnum);
$excelColNames[$i] = camila_strtoupper_utf8(isUTF8($name) ? $name : utf8_encode($name));
$i++;
}
$result = $_CAMILA['db']->Execute('select * from ' . CAMILA_TABLE_WORKC . ' where (wt_id=' . $_CAMILA['db']->qstr($id) . ' and is_deleted<>' . $_CAMILA['db']->qstr('y') . ') order by sequence');
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$fields = array();
$types = array();
$defVals = array();
$forceCase = array();
$orig_types = array();
$fieldMapping = array();
$forceArr = camila_get_translation_array('camila.worktable.options.force');
$count = 0;
while (!$result->EOF) {
$colName = $result->fields['col_name'];
$name = camila_strtoupper_utf8($result->fields['name']);
$fieldMapping[$colName] = isUTF8($name) ? $name : utf8_encode($name);
$fields[$count] = $colName;
$types[$count] = $result->fields['type'];
$orig_types[$count] = $result->fields['orig_type'];
$defVals[$count] = $result->fields['default_value'];
$forceCase[$count] = $result->fields['force_case'];
$count++;
$result->MoveNext();
}
$successCount = 0;
$failCount = 0;
//db fields
for ($i = 2; $i <= $data->rowcount($sheetnum); $i++) {
$record = array();
$emptyrow = true;
//db fields
reset($fields);
foreach ($fields as $k => $v) {
//k Field position into database
//k2 Position in Excel file
$k2 = array_search($fieldMapping[$v], $excelColNames);
//Is it in Excel file?
if ($k2 !== false) {
$excelColName = camila_strtoupper_utf8($data->value(1, $k2 + 1, $sheetnum));
//$excelColName = $v;
$worktableColName = array_search($excelColName, $fieldMapping);
$worktableColName = $v;
if ($worktableColName != '') {
if ($types[$k] == 'date' && $data->val($i, $k2 + 1, $sheetnum) != '') {
$numValue = $data->sheets[$sheetnum]['cellsInfo'][$i][$k2 + 1]['raw'];
$utcDays = floor($numValue - ($data->nineteenFour ? SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS1904 : SPREADSHEET_EXCEL_READER_UTCOFFSETDAYS));
$utcValue = $utcDays * SPREADSHEET_EXCEL_READER_MSINADAY;
$dateinfo = gmgetdate($utcValue);
$fractionalDay = $numValue - floor($numValue) + 1.0E-7;
// The .0000001 is to fix for php/excel fractional diffs
$totalseconds = floor(SPREADSHEET_EXCEL_READER_MSINADAY * $fractionalDay);
$secs = $totalseconds % 60;
$totalseconds -= $secs;
$hours = floor($totalseconds / (60 * 60));
$mins = floor($totalseconds / 60) % 60;
$dt = date('Y-m-d', mktime($hours, $mins, $secs, $dateinfo["mon"], $dateinfo["mday"], $dateinfo["year"]));
$record[$worktableColName] = $_CAMILA['db']->BindDate($dt);
} elseif ($orig_types[$k] == 'number' && $data->sheets[$sheetnum]['cellsInfo'][$i][$k2 + 1]['raw'] != '') {
$record[$worktableColName] = $data->sheets[$sheetnum]['cellsInfo'][$i][$k2 + 1]['raw'];
} elseif ($types[$k] == 'hyperlink' && $data->hyperlink($i, $k2 + 1, $sheetnum) != '') {
//$record[$worktableColName] = '<a href="' . $data->hyperlink($i, $k2+1, $sheetnum) . '" target="_blank">' . $data->value($i, $k2+1, $sheetnum) . '</a>';
$record[$worktableColName] = $data->hyperlink($i, $k2 + 1, $sheetnum);
} else {
$record[$worktableColName] = $data->value($i, $k2 + 1, $sheetnum);
}
if ($defVals[$k] != '' && $record[$worktableColName] == '') {
$record[$worktableColName] = camila_parse_default_expression($defVals[$k], '_camila_seq_num_', true);
}
if ($record[$worktableColName] != '') {
if ($forceCase[$k] == 'upper') {
$record[$worktableColName] = mb_strtoupper($record[$worktableColName], 'UTF-8');
}
if ($forceCase[$k] == 'lower') {
$record[$worktableColName] = mb_strtolower($record[$worktableColName], 'UTF-8');
}
$emptyrow = false;
}
}
} else {
if ($defVals[$k] != '') {
$record[$fields[$k]] = camila_parse_default_expression($defVals[$k], '_camila_seq_num_', true);
}
}
}
if (!$emptyrow) {
$now = $_CAMILA['db']->BindTimeStamp(gmdate("Y-m-d H:i:s", time()));
$id = $_CAMILA['db']->GenID('worktableseq', 100000);
foreach ($record as $k => $v) {
$record[$k] = str_replace('_camila_seq_num_', $id, $v);
}
$record['id'] = $id;
$record['created'] = $now;
$record['created_by'] = $_CAMILA['user'];
$record['created_src'] = 'import';
$record['created_by_surname'] = $_CAMILA['user_surname'];
$record['created_by_name'] = $_CAMILA['user_name'];
$record['last_upd'] = $now;
$record['last_upd_by'] = $_CAMILA['user'];
$record['last_upd_src'] = 'import';
$record['last_upd_by_surname'] = $_CAMILA['user_surname'];
$record['last_upd_by_name'] = $_CAMILA['user_name'];
$record['mod_num'] = 0;
$insertSQL = $_CAMILA['db']->AutoExecute($table, $record, 'INSERT');
if (!$insertSQL) {
//camila_information_text(camila_get_translation('camila.worktable.db.importerror'));
$failCount++;
$success = false;
} else {
$successCount++;
}
}
}
}
camila_information_text(camila_get_translation('camila.worktable.db.importedrows') . ': ' . $successCount);
camila_information_text(camila_get_translation('camila.worktable.db.skippedrows') . ': ' . $failCount);
@unlink(CAMILA_TMP_DIR . '/' . $filename);
} else {
$result = $_CAMILA['db']->Execute('select tablename, filename, sheetnum from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$filename = $result->fields['filename'];
// if ($filename != '') {
$myText = new CHAW_text(camila_get_translation('camila.wizard.choosefileforimport'));
$_CAMILA['page']->add_text($myText);
$form3->draw();
$success = false;
// }
}
if ($success) {
if ($worktablename != '') {
$myLink = new CHAW_link($worktablename, $worktablescript);
$myLink->set_br(0);
$_CAMILA['page']->add_link($myLink);
$myText = new CHAW_text(' - ' . camila_get_translation('camila.worktable.db.importok'));
$_CAMILA['page']->add_text($myText);
} else {
$myText = new CHAW_text(camila_get_translation('camila.wizard.configurationapplied'));
$_CAMILA['page']->add_text($myText);
}
}
}
$admin .= '<div class="bordermenu2"><a href="admin.php?pilih=importsiswa&mod=yes">Import Siswa</a> | <a href="admin.php?pilih=importsiswa&mod=yes&aksi=delkelas">Hapus Siswa Per Kelas</a> | <a href="admin.php?pilih=importsiswa&mod=yes&aksi=inputsiswa">Input Siswa Satuan</a> | <a href="admin.php?pilih=importsiswa&mod=yes&aksi=daftarsiswa">Siswa tanpa Kelas</a>';
$admin .= '</div>';
$admin .= '<div class="panel panel-info">';
if ($_GET['aksi'] == "") {
if (isset($_POST['submit'])) {
$kelas = $_POST['kelas'];
//nilai awal counter jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
$cell = new Spreadsheet_Excel_Reader($_FILES['upfile']['tmp_name']);
$jumlah = $cell->rowcount($sheet_index = 0);
$i = 2;
// dimulai dari ke dua karena baris pertama berisi title
while ($i <= $jumlah) {
//$cell->val( baris,kolom )
$nama = $cell->val($i, 2);
$username = $cell->val($i, 1);
$password = $cell->val($i, 1);
$password = md5("{$password}");
$nama = addslashes($nama);
if ($username != '' and $password != '') {
$sql = "INSERT INTO `useraura` (`user`,`password`,`nama`) VALUES ('{$username}','{$password}','{$nama}')";
$hasil = mysql_query($sql);
$sql2 = "INSERT INTO `kelas_isi` (`kelas`,`siswa`) VALUES ('{$kelas}','{$username}')";
$hasil2 = mysql_query($sql2);
if ($hasil and $hasil2) {
$sukses++;
} else {
$gagal++;
}
} else {
$source = $_FILES['file']['tmp_name'];
$t = "Subjective" . time() . "" . date('Ymd') . ".xls";
$target = $upload_path . "/" . $t;
$tempUploadedValue = move_uploaded_file($source, $target);
if ($tempUploadedValue) {
/* echo "<script type='text/javascript'> alert('test1'); </script>"; */
if (($handle = fopen($upload_path . '/' . $t, "r")) !== false) {
$_FILES['file']['name'];
$expiryDate = $_POST['expiryDate'];
$data = new Spreadsheet_Excel_Reader($upload_path . '/' . $t);
$data->dump(true, true);
$data_array = array();
for ($i = 1; $i <= $data->rowcount(); $i++) {
$data_array[$i] = array();
for ($j = 1; $j <= $data->colcount(); $j++) {
$data_array[$i][$j] = $data->val($i, $j);
}
// inner For
}
// outer For
$myFile = $t;
$url = "./excelfiles/" . $t;
$newUploadedQuizURL = $newBaseURL . "/excelfiles/" . str_replace(' ', '%20', $myFile);
$newQuizName = $_POST['questionFileName'];
$newQuizFileName = $myFile;
$duration = $_POST['hours'] * 3600 + $_POST['minutes'] * 60;
$questionWeightage = $_POST['questionWeightage'];
$questionQty = $_POST['questionQty'];
$re_exam_date = $_POST['re_exam_date'];
$cut_off = $_POST['cut_off'];
mysql_query("CALL insertUploadedFile1('" . $t . "','" . $url . "','" . $user . "','" . $_POST['questionFileName'] . "','" . $questionWeightage . "','" . $questionQty . "','" . $cut_off . "','" . $duration . "','" . $_POST['expiryDate'] . "','" . $re_exam_date . "','Unpublished','subjective')");
<?php
// menggunakan class phpExcelReader
include "excel_reader2.php";
include "lib/koneksi.php";
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data bcf15 (kolom ke-1)
$idbcf15 = $data->val($i, 1);
$tahun = $data->val($i, 2);
$bcf15no = $data->val($i, 3);
$bcf15tgl = $data->val($i, 4);
$suratpengantarno = $data->val($i, 5);
$perintah = $data->val($i, 6);
$suratperintahno = $data->val($i, 7);
$suratperintahdate = $data->val($i, 8);
$idtp2 = $data->val($i, 9);
$idseksitp2 = $data->val($i, 10);
$pemberitahuan = $data->val($i, 11);
$suratno = $data->val($i, 12);
$suratdate = $data->val($i, 13);
$idtp3 = $data->val($i, 14);
$idseksitp3 = $data->val($i, 15);
$masuk = $data->val($i, 16);
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new PhoneModel();
$message = "";
$errorList = array();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['source_name'], $_POST['group_id'])) {
$fileName = _APP_PATH_ . DS . "data" . DS . "tmp" . DS . $_POST['source_name'];
$group_id = $_POST['group_id'];
//$fileName = "D:\\chacha_cloud\\src\\trunk\chacha\data\\tmp\\20120713170547_phone_list.xls";
try {
require_once 'excel_reader2.php';
$data = new Spreadsheet_Excel_Reader($fileName, true, "UTF-8");
// khoi tao doi tuong doc file excel
$rowsnum = $data->rowcount($sheet_index = 0);
// lay so hang cua sheet
$colsnum = $data->colcount($sheet_index = 0);
// lay so cot cua sheet
for ($i = 2; $i <= $rowsnum; $i++) {
// doc tu hang so 2 vi hang 1 la tieu de roi!
$phoneNum = $data->val($i, 1);
// xuat cot so 1 va cot so 2 tren cung 1 hang
// check so dien thoai xem co dung cua Vinaphone ko
try {
$phoneNum = Formatter::formatPhone($phoneNum);
if (Formatter::isVinaphoneNumber($phoneNum)) {
$model->phone = "{$phoneNum}";
$model->group_id = $group_id;
$model->status = 0;
$model->created_time = date("Y-m-d H:i:s");
var_dump($model->phone);
try {
if ($model->save()) {
$message = yii::t('SpamModule', 'Upload thành công');
} else {
print_r($model->getErrors());
exit;
}
} catch (Exception $exc) {
echo $exc->getTrace();
}
} else {
//echo so dien thoai ko dung
$errorList[] = $phoneNum;
}
} catch (Exception $exc) {
echo $exc->getMessage();
}
}
} catch (Exception $exc) {
echo $exc->getMessage();
}
}
$uploadModel = new XUploadForm();
$tmpArr = GroupModel::model()->findAll();
$smsGroup = array();
foreach ($tmpArr as $smsG) {
$smsGroup[$smsG->id] = $smsG->name;
}
$this->render('create', array('model' => $model, 'uploadModel' => $uploadModel, 'message' => $message, 'smsGroup' => $smsGroup, 'errorList' => $errorList));
}
<?php
// menggunakan class phpExcelReader
include "excel_reader2.php";
include "lib/koneksi.php";
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data bcf15 (kolom ke-1)
$tahun = $data->val($i, 1);
$bcf15no = $data->val($i, 2);
$Batal = $data->val($i, 3);
$SuratBatalNo = $data->val($i, 4);
$SuratBatalDate = $data->val($i, 5);
$Pemohon = $data->val($i, 6);
$AlamatPemohon = $data->val($i, 7);
$ndkonfirmasino = $data->val($i, 8);
$ndkonfirmasino2 = $data->val($i, 9);
$ndkonfirmasidate = $data->val($i, 10);
$ndkonfirmasito = $data->val($i, 11);
$CacahNo = $data->val($i, 12);
$CacahDate = $data->val($i, 13);
$ndkonfirmasi = $data->val($i, 14);
$recordstatuskonf = $data->val($i, 15);
$idseksindkonfirmasi = $data->val($i, 16);
//$p_noreg_unit=$_POST['p_noreg_unit'];
//$noreg=$p_noreg_pemilik.".".$p_noreg_prov.".".$p_noreg_kab.".".$p_noreg_satker.".".$p_noreg_tahun.".".$p_noreg_unit;
// menggunakan class phpExcelReader
include "excel_reader.php";
// membaca file excel yang diupload
//$new_data = new Spreadsheet_Excel_Reader();
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
echo "<br>   <a href='javascript:select(1)' style='font:12px Arial;color:#0066FF;text-decoration:underline;'>\n  Pilih Semua </a> |\n <a href='javascript:select(0)' style='font:12px Arial;color:#0066FF;text-decoration:underline;'>\n  Hapus Semua Pilihan </a>  ";
echo "<form action='proses_kiba_hasil.php' method='post' name='sheet'>";
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
echo "\n<table border=1 cellspacing='0'>\n<thead>\n<tr>\n<th rowspan='3'>SELEKSI</th>\n<th rowspan='3'>NAMA BARANG</th>\n<th colspan='2'>NOMOR</th>\n<th rowspan='3'>KODE LOKASI</th>\n<th rowspan='3'>LUAS(M2)</th>\n<th rowspan='3'>TAHUN <br>PENGADAAN</th>\n<th rowspan='3'>ALAMAT</th>\n<th rowspan='3'>RT/RW</th>\n<th colspan='3'>STATUS TANAH</th>\n<th rowspan='3'>PENGGUNAAN</th>\n<th rowspan='3'>ASAL USUL</th>\n<th rowspan='3'>HARGA <br>(Rp)</th>\n<th rowspan='3'>KETERANGAN</th>\n</tr>\n<tr>\n<th rowspan='2'>KODE BARANG</th>\n<th rowspan='2'>KODE REGISTER</th>\n<th rowspan='2'>HAK</th>\n<th colspan='2'>SERTIFIKAT</th>\n</tr>\n<tr>\n<th>TANGGAL</th>\n<th>NOMOR</th>\n</tr>\n</thead>";
for ($i = 14; $i <= $baris; $i++) {
// membaca data tahun (kolom ke-2)
$nm_brg = $data->val($i, 2);
// membaca data (kolom ke-3)
$kd_brg = $data->val($i, 3);
// membaca data (kolom ke-4)
$p_noreg_unit = $data->val($i, 4);
// membaca data skpd (kolom ke-5)
$luas = $data->val($i, 5);
// membaca data lokasi (kolom ke-6)
$tahun_pengadaan = $data->val($i, 6);
// membaca data nama jenis barang (kolom ke-7)
$alamat = $data->val($i, 7);
// membaca data merk tipe (kolom ke-8)
$rtrw = $data->val($i, 8);
// membaca data merk tipe (kolom ke-9)
$hak = $data->val($i, 9);
// membaca data kode rek (kolom ke-10)
$host = "localhost";
$user = "******";
$pwd = "sitampan";
$conn = mysql_connect($host, $user, $pwd) or die("Koneksi Gagal, karena " . mysql_error());
mysql_select_db("sitampan", $conn);
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data nim (kolom ke-1)
$idbcf15 = $data->val($i, 1);
$tahun = $data->val($i, 2);
$bcf15no = $data->val($i, 3);
$bcf15tgl = $data->val($i, 4);
$bc11no = $data->val($i, 5);
$bc11tgl = $data->val($i, 6);
$bc11pos = $data->val($i, 7);
$bc11subpos = $data->val($i, 8);
$blno = $data->val($i, 9);
$bltgl = $data->val($i, 10);
$saranapengangkut = $data->val($i, 11);
$voy = $data->val($i, 12);
$amountbrg = $data->val($i, 13);
$satuanbrg = $data->val($i, 14);
$diskripsibrg = $data->val($i, 15);
$consignee = $data->val($i, 16);
public function importexcel()
{
if ($this->my_usession->logged_in) {
$fileupload = $_FILES['fileexcel']['tmp_name'];
$namafile = $_FILES['fileexcel']['name'];
$path = 'assets/resources/data/';
$pathfile = $path . $namafile;
if (move_uploaded_file($fileupload, $pathfile)) {
include_once APPPATH . "libraries/excelreader.php";
$data = new Spreadsheet_Excel_Reader($pathfile);
$baris = $data->rowcount($sheet_index = 0) + 1;
$temp_query = array();
for ($a = 2; $a < $baris; $a++) {
$area = array();
if ($data->val($a, 14) == '') {
$area[0] = '1';
} else {
$area = explode(',', $data->val($a, 14));
}
$areaid = $this->device_model->areaonall($area);
$jumar = count($area) - 1;
$savear = array();
$useride = $data->val($a, 1);
if ($useride != '') {
$SN = $this->employe_model->getsn($areaid);
$command = array();
if (isset($SN)) {
foreach ($SN->result() as $esen) {
$command = array('sn' => $esen->sn, 'cmd' => 'DATA USER PIN=' . $data->val($a, 1) . ' Name=' . $data->val($a, 4) . ' Passwd=' . $data->val($a, 5) . ' Card=' . $data->val($a, 6) . ' Grp= TZ= Pri=' . $data->val($a, 7), 'status' => 1, 'submittime' => date("Y-m-d H:i:s"));
$this->db->insert('command', $command);
}
}
$tempaa = array('userid' => (string) $data->val($a, 1), 'badgenumber' => (string) $data->val($a, 2), 'name' => $data->val($a, 3), 'nickname' => $data->val($a, 4), 'password' => $data->val($a, 5), 'card' => $data->val($a, 6), 'privilege' => $data->val($a, 7) != '' ? $data->val($a, 7) : 0, 'deptid' => $data->val($a, 8) != '' ? $data->val($a, 8) : '1', 'title' => $data->val($a, 9), 'gender' => (int) $data->val($a, 10), 'birthdate' => $data->val($a, 11) != '' ? date('Y-m-d', strtotime($data->val($a, 11))) : null, 'hireddate' => $data->val($a, 12) != '' ? date('Y-m-d', strtotime($data->val($a, 12))) : null, 'email' => $data->val($a, 13));
$tempaaupdate = array('badgenumber' => (string) $data->val($a, 2), 'name' => (string) $data->val($a, 3), 'nickname' => $data->val($a, 4), 'password' => $data->val($a, 5), 'card' => $data->val($a, 6), 'privilege' => $data->val($a, 7) != '' ? $data->val($a, 7) : 0, 'deptid' => $data->val($a, 8) != '' ? $data->val($a, 8) : '1', 'title' => $data->val($a, 9), 'gender' => (int) $data->val($a, 10), 'birthdate' => $data->val($a, 11) != '' ? date('Y-m-d', strtotime($data->val($a, 11))) : null, 'hireddate' => $data->val($a, 12) != '' ? date('Y-m-d', strtotime($data->val($a, 12))) : null, 'email' => $data->val($a, 13));
if ($this->db->insert('userinfo', $tempaa)) {
foreach ($area as $aarreeaa) {
$savear = array('userid' => (string) $data->val($a, 1), 'areaid' => $aarreeaa);
if ($this->db->insert('userinfo_attarea', $savear)) {
}
}
} else {
$this->db->where('userid', (string) $data->val($a, 1));
$this->db->update('userinfo', $tempaaupdate);
$userareaactive = array();
$userarea = $this->employe_model->getareauserinfo((string) $data->val($a, 1));
foreach ($userarea->result() as $usea) {
$userareaactive[] = $usea->areaid;
}
$del = array_diff($userareaactive, $area);
$add = array_diff($area, $userareaactive);
foreach ($del as $dele) {
$serialno = $this->employe_model->getsnarea($dele);
if (isset($serialno)) {
foreach ($serialno->result() as $serno) {
$comdev = array('sn' => $serno->sn, 'cmd' => 'DATA DEL_USER PIN=' . $data->val($a, 1), 'status' => 1, 'submittime' => date("Y-m-d H:i:s"));
$this->db->insert('command', $comdev);
}
}
$this->db->delete('userinfo_attarea', array('userid' => (string) $data->val($a, 1), 'areaid' => $dele));
}
foreach ($add as $aarreeaa) {
$savear = array('userid' => (string) $data->val($a, 1), 'areaid' => $aarreeaa);
if ($this->db->insert('userinfo_attarea', $savear)) {
}
}
}
}
}
$actionlog = array('user' => $this->my_usession->userdata('username'), 'ipadd' => $this->ipaddress->get_ip(), 'logtime' => date("Y-m-d H:i:s"), 'logdetail' => 'Import employee data', 'info' => $this->lang->line('message_success'));
$this->db->insert('actionlog', $actionlog);
$hasil = array("responseText" => "success", "success" => true);
echo json_encode($hasil);
} else {
$actionlog = array('user' => $this->my_usession->userdata('username'), 'ipadd' => $this->ipaddress->get_ip(), 'logtime' => date("Y-m-d H:i:s"), 'logdetail' => 'Import employee data', 'info' => 'Failed');
$this->db->insert('actionlog', $actionlog);
$hasil = array("responseText" => "Import failed!", "success" => false);
echo json_encode($hasil);
}
} else {
$hasil = array("success" => false, "responseText" => "notlogin");
echo json_encode($hasil);
}
}
require_once '../../functions/functions.php';
/* get excel file */
require_once '../../functions/excel_reader2.php';
//excel reader 2.21
$data = new Spreadsheet_Excel_Reader('csvupload/import.xls', false);
//get number of rows
$numRows = $data->rowcount(0);
$numRows++;
//get custom fields
$myFields = getCustomFields('ipaddresses');
$myFieldsSize = sizeof($myFields);
//add custom fields
$numRows = $numRows + $myFieldsSize;
//get all to array!
for ($m = 0; $m < $numRows; $m++) {
$outFile[$m] = $data->val($m, 'A') . ',' . $data->val($m, 'B') . ',' . $data->val($m, 'C') . ',' . $data->val($m, 'D') . ',
' . $data->val($m, 'E') . ',' . $data->val($m, 'F') . ',' . $data->val($m, 'G') . ',' . $data->val($m, 'H') . ',
' . $data->val($m, 'I');
//add custom fields
if (sizeof($myFields) > 0) {
$currLett = "J";
foreach ($myFields as $field) {
$outFile[$m] .= "," . $data->val($m, $currLett++);
}
}
}
/* echo $data->dump(false,false); */
}
/*
* print table
*********************/
/* format file */
$outFile = str_replace(array("\r\n", "\r"), "\n", $outFile);
//replace windows and Mac line break
$outFile = explode("\n", $outFile);
} elseif (strtolower($filetype) == "xls") {
# get excel object
require_once '../../../functions/php-excel-reader/excel_reader2.php';
//excel reader 2.21
$data = new Spreadsheet_Excel_Reader(dirname(__FILE__) . '/upload/import.xls', false);
//get number of rows
$numRows = $data->rowcount(0);
$numRows++;
//get all to array!
for ($m = 0; $m < $numRows; $m++) {
//IP must be present!
if (filter_var($data->val($m, 'A'), FILTER_VALIDATE_IP)) {
$outFile[$m] = $data->val($m, 'A') . ',' . $data->val($m, 'B') . ',' . $data->val($m, 'C') . ',' . $data->val($m, 'D') . ',';
$outFile[$m] .= $data->val($m, 'E') . ',' . $data->val($m, 'F') . ',' . $data->val($m, 'G') . ',' . $data->val($m, 'H') . ',';
$outFile[$m] .= $data->val($m, 'I');
//add custom fields
if (sizeof($custom_address_fields) > 0) {
$currLett = "J";
foreach ($custom_address_fields as $field) {
$outFile[$m] .= "," . $data->val($m, $currLett++);
}
}
}
}
} else {
$Result->show('danger', _("Invalid file type"), true);
}
$host = "localhost";
$user = "******";
$pwd = "sitampan";
$conn = mysql_connect($host, $user, $pwd) or die("Koneksi Gagal, karena " . mysql_error());
mysql_select_db("sitampan", $conn);
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data nim (kolom ke-1)
$idcontainer = $data->val($i, 1);
$idbcf15 = $data->val($i, 2);
$nocontainer = $data->val($i, 3);
$idsize = $data->val($i, 4);
$bcf15no = $data->val($i, 5);
$tahun = $data->val($i, 6);
// setelah data dibaca, sisipkan ke dalam tabel mhs
//$query = "INSERT INTO bcf15 VALUES ('$idbcf15', '$tahun', '$bcf15no','$bcf15tgl','$bc11no','$bc11tgl','$bc11pos','$bc11subpos','$blno','$bltgl','$saranapengangkut','$voy','$amountbrg','$satuanbrg','$diskripsibrg','$consignee','$consigneeadrress','$consigneekota','$notify','$notifyadrress','$notifykota','$idtps','$idtpp','$idtypecode','$DokumenCode','$suratpengantarno','$suratpengantartgl','$keterangan','$DokumenNo','$DokumenDate','$Dokumen2Code','$Dokumen2No','$Dokumen2Date','$BatalTarik','$BatalTarikNo','$BatalTarikNo2','$BatalTarikDate','$BatalTarikKet','$masuk','$bamasukno','$bamasukdate','$bamasukdatetrx','$keluar','$BAKeluarDateTrx','$pemberitahuan','$suratno','$idtp3','$suratdate','$idseksitp3','$Pelayaran','$PelayaranNo','$Pelayarandate','$perintah','$suratperintahno','$idtp2','$suratperintahdate','$idseksitp2','$CacahType','$Cacah','$NDCacahNo','$NDCacahDate','$CacahNo','$CacahDate','$NHP','$ReqBatal','$Batal','$SuratBatalNo','$SuratBatalDate','$Pemohon','$AlamatPemohon','$ndkonfirmasito','$ndkonfirmasino','$ndkonfirmasino2','$ndkonfirmasidate','$ndkonfirmasijawaban','$jawabanp2Ket','$jawabanp2','$jawabanp2date','$idp2','$segel','$ndsegelno','$ndsegeldate','$idseksitp2bukgel','$SetujuBatalNo','$SetujuBatalNo2','$SetujuBatalDate','$Date_Trx','$UserName','$UserHost','$Description_Trx','$Pecahpos','$idpelayaran','$PelayaranAddress','$PelayaranAlasan','$NoKep','$recordstatus','$idmanifest','$idseksi','$Status_Akhr','$NoKepStatus_Akhr','$BA_Pemusnahan','$TGL_Pemusnahan','$KetBA_Penarikan','$Tgl_Rekam')";
$strSQL = "INSERT INTO bcfcontainer (\nidcontainer,\nidbcf15,\nbcf15no,\nnocontainer,\nidsize,\ntahun) \n\nVALUES \n( '{$idcontainer}', \n '{$idbcf15}',\n '{$bcf15no}',\n '{$nocontainer}',\n '{$idsize}',\n '{$tahun}');";
$hasil = mysql_query($strSQL) or die(mysql_error());
//
//$hasil = mysql_query($query);
// jika proses insert data sukses, maka counter $sukses bertambah
// jika gagal, maka counter $gagal yang bertambah
if ($hasil) {
$sukses++;
}
$current_timestamp = get_GMT(microtime(true));
$current_time = date("Y-m-d H:i:s", $current_timestamp);
$data = new Spreadsheet_Excel_Reader("mls.xls");
$sheet_count = $data->sheetcount();
for ($sheet_index = 0; $sheet_index < $sheet_count; $sheet_index++) {
$row_count = $data->rowcount($sheet_index);
$col_count = $data->colcount($sheet_index);
echo "Sheet:{$sheet_index}<br/>";
echo "Row Count:" . $row_count . "<br/>";
echo "Column Count:" . $col_count . "<br/>";
for ($row_index = 1; $row_index <= $row_count; $row_index++) {
for ($col_index = 1; $col_index <= $col_count; $col_index++) {
if ($row_index > 1 && $col_index <= 3) {
if ($col_index == 1) {
$month = $data->val($row_index, $col_index, $sheet_index) === '' ? $month : $data->val($row_index, $col_index, $sheet_index);
}
if ($col_index == 2) {
$year = $data->val($row_index, $col_index, $sheet_index) === '' ? $year : $data->val($row_index, $col_index, $sheet_index);
}
if ($col_index == 3) {
$property_type = $data->val($row_index, $col_index, $sheet_index) === '' ? $property_type : $data->val($row_index, $col_index, $sheet_index);
}
} else {
echo "<td>" . $data->val($row_index, $col_index, $sheet_index) . '</td>';
}
}
echo "</tr>";
}
echo "</table>";
}
session_start();
include "../../library/check_login.php";
include "../../config/koneksi.php";
include "../../config/library.php";
//$tabel=$_POST['tabel'];
//$module=$_POST['module'];
// menggunakan class phpExcelReader
include "excel_reader2.php";
$data = new Spreadsheet_Excel_Reader($_FILES['file_excel']['tmp_name']);
$baris = $data->rowcount($sheet_index = 0);
$sukses = 0;
$gagal = 0;
$nu = 1;
for ($i = 2; $i <= $baris; $i++) {
// membaca data no soal (kolom ke-1)
$no = mysql_real_escape_string($data->val($i, 1));
//id
$no1 = mysql_real_escape_string($data->val($i, 2));
//nama
$no2 = mysql_real_escape_string($data->val($i, 3));
//alamat
$no3 = mysql_real_escape_string($data->val($i, 4));
//kd_kelompok
$query = "INSERT INTO `nama_undangan` (`nama`, `alamat`, `kelompok`) VALUES ('{$no1}', '{$no2}', '{$no3}')";
$arb = mysql_query($query);
//echo "$query<br>$format<br>";
$nu++;
// jika proses insert data sukses, maka counter $sukses bertambah
// jika gagal, maka counter $gagal yang bertambah
if ($arb) {
$sukses++;
//$excel->setUTFEncoder('iconv');
//$excel->setOutputEncoding('WINDOWS-1253');
// read spreadsheet data
//$excel->read($xlsfile);
//$xsheets = sizeof($excel->sheets);
//$excel->dump($row_numbers=false,$col_letters=false,$sheet=0,$table_class='excel');
//echo $excel->val(10,9);
//die;
/*
echo "Number of sheets: " . sizeof($excel->sheets) . "<br>";
for ($x=0; $x<$xsheets; $x++) {
echo "Number of rows in sheet " . ($x+1) . ": " . $excel->sheets[$x]["numRows"] . "<br>";
echo "Number of columns in sheet " . ($x+1) . ": " . $excel->sheets[$x]["numCols"] . "<br>";
}
*/
$patient_raw_details = $excel->val(2, 3);
$patient_details = explode(" ", $patient_raw_details);
echo "<h4>Κωδικός ασθενούς: " . $patient_details[1] . ", Ονοματεπώνυμο ασθενούς: " . $patient_details[2] . " " . $patient_details[3] . "</h4>";
?>
<div id="tabs" style="width: 1010px">
<ul>
<li><a href="#exams_bioximikes">Βιοχημικές Εξετάσεις</a></li>
<li><a href="#exams_aimatologikes">Αιματολογικές Εξετάσεις</a></li>
<li><a href="#exams_ourwn">Γενική Ούρων</a></li>
</ul>
<?php
echo "<div id='exams_bioximikes' style='width: 980px'>";
echo "<b>Αριθμός βιοχημικών εξετάσεων που έχουν αναγνωριστεί: <span id='records_bio'></span></b><br><br>";
echo "<table border=0 celspacing=0 cellpadding=0 id='exams_overview' class='display'><thead>\n";
echo "<th>Excel A/A</th><th>Ημερομηνία (Excel)</th><th>Ημερομηνία (AMACS)</th><th>Εξέταση (Excel)</th><th>Εξέταση (AMACS)</th>";
/**
* Import records from Excel file
*
* @param $file
* @param bool $simulate
*/
private function importRecords($file, $simulate = false)
{
global $ilUser, $lng;
include_once "./Modules/DataCollection/libs/ExcelReader/excel_reader2.php";
$warnings = array();
try {
$excel = new Spreadsheet_Excel_Reader($file);
} catch (Exception $e) {
$warnings[] = $lng->txt("dcl_file_not_readable");
}
if (count($warnings)) {
$this->endImport(0, $warnings);
return;
}
$field_names = array();
for ($i = 1; $i <= $excel->colcount(); $i++) {
$field_names[$i] = $excel->val(1, $i);
}
$fields = $this->getImportFieldsFromTitles($field_names, $warnings);
for ($i = 2; $i <= $excel->rowcount(); $i++) {
$record = new ilDataCollectionRecord();
$record->setTableId($this->table_obj->getId());
$record->setOwner($ilUser->getId());
$date_obj = new ilDateTime(time(), IL_CAL_UNIX);
$record->setCreateDate($date_obj->get(IL_CAL_DATETIME));
$record->setTableId($this->table_id);
if (!$simulate) {
$record->doCreate();
}
foreach ($fields as $col => $field) {
$value = $excel->val($i, $col);
$value = utf8_encode($value);
try {
if ($field->getDatatypeId() == ilDataCollectionDatatype::INPUTFORMAT_REFERENCE) {
$old = $value;
$value = $this->getReferenceFromValue($field, $value);
if (!$value) {
$warnings[] = "(" . $i . ", " . $this->getExcelCharForInteger($col) . ") " . $lng->txt("dcl_no_such_reference") . " " . $old;
}
} else {
if ($field->getDatatypeId() == ilDataCollectionDatatype::INPUTFORMAT_DATETIME) {
$value = array('date' => date('Y-m-d', strtotime($value)), 'time' => '00:00:00');
}
}
$field->checkValidity($value, $record->getId());
if (!$simulate) {
$record->setRecordFieldValue($field->getId(), $value);
}
} catch (ilDataCollectionInputException $e) {
$warnings[] = "(" . $i . ", " . $this->getExcelCharForInteger($col) . ") " . $e;
}
}
if (!$simulate) {
$record->doUpdate();
}
if ($i - 1 > $this->max_imports) {
$warnings[] = $lng->txt("dcl_max_import") . ($excel->rowcount() - 1) . " > " . $this->max_imports;
break;
}
}
$this->endImport($i - 2, $warnings);
}
// menggunakan class phpExcelReader
include_once "excel_reader2.php";
// koneksi ke mysql
include_once "../../lib_function.php";
koneksi_db();
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data nip (kolom ke-1)
$nip = $data->val($i, 1);
// membaca data nama (kolom ke-2)
$nama_guru = $data->val($i, 2);
// membaca data jenis kelamin (kolom ke-3)
$jklamin_guru = $data->val($i, 3);
// membaca data password (kolom ke-4)
$password = md5($data->val($i, 4));
// membaca data email (kolom ke-5)
$email = $data->val($i, 5) . "@domain.com";
// membaca data dispict (kolom ke-6)
$dispict = $data->val($i, 6);
// membaca data status (kolom ke-7)
$status = $data->val($i, 7);
// membaca data id kelas (kolom ke-8)
$id_mp = $data->val($i, 8);
// setelah data dibaca, sisipkan ke dalam tabel guru
<body style="width:1250px">
<?
include("../inc/store_function.php");
include("../inc/dbconnection.php");
//$resCpunt=mysql_query("select * from maint_job");
//echo mysql_num_rows($resCpunt);
/*for($col=1;$col<=$xls->colcount();$col++)
{
echo $xls->val(1,$col).'<br />';
}
$xls->rowcount();*/
for ($row=2;$row<=$xls->rowcount();$row++)
{
$arr=array();
$job_code=(int)($xls->val($row,1));
$service_id=(int)$xls->val($row,4);
$machine_id=(int)$xls->val($row,3);
$status=trim($xls->val($row,9));
$remark=addslashes($xls->val($row,7)).' '.addslashes($xls->val($row,8));
$maint_date='';
if($xls->val($row,6)!="")
{
$maint_date=explode('-',$xls->val($row,6));
if(sizeof($maint_date)>0)
$maint_date=date("Y-m-d", mktime(0, 0, 0, (int)$maint_date[1], ((int)$maint_date[0]-1), (int)$maint_date[2]));
else
$maint_date='';
}
$schedule_date='';
if($xls->val($row,2)!="")
if($_GET['aksi']=="import"){
if(isset($_POST['submit'])){
$jenis = $_POST['jenis'];
$jenjang = $_POST['jenjang'];
//nilai awal counter jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
$cell = new Spreadsheet_Excel_Reader($_FILES['upfile']['tmp_name']);
$jum = $cell->rowcount($sheet_index=0);
$i = 2; // dimulai dari ke dua karena baris pertama berisi title
while( $i<=$jum ){
//$cell->val( baris,kolom )
$kode = $cell->val( $i,1 );
$nama = $cell->val( $i,2 );
$hargajual = $cell->val( $i,3 );
$sql ="INSERT INTO `pos_produkjasa` (`jenis`,`jenjang`,`kode`,`nama`,`hargajual`) VALUES ('$jenis','$jenjang','$kode','$nama','$hargajual')";
$hasil = mysql_query( $sql );
if($hasil){
$sukses++;
}else{
$gagal++;
}
$i++;
}
//tampilkan report hasil import
$admin .= "<h3> Proses Import Data Jasa Selesai</h3>";
$admin .= "<p>Jumlah data sukses diimport : ".$sukses."<br>";
<?php
// menggunakan class phpExcelReader
include "../lib/excel_reader2.php";
include "../lib/koneksi.php";
include "../lib/function.php";
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
// nilai awal counter untuk jumlah data yang sukses dan yang gagal diimport
$sukses = 0;
$gagal = 0;
// import data excel mulai baris ke-2 (karena baris pertama adalah nama kolom)
for ($i = 2; $i <= $baris; $i++) {
// membaca data bcf15 (kolom ke-1)
$bmnno = $data->val($i, 1);
$bmntgl = $data->val($i, 2);
$bmntglsql = sql($bmntgl);
$tahunkep = substr($bmntglsql, 0, 4);
$dok_asal = $data->val($i, 3);
$nomordokasal = $data->val($i, 4);
$tglmordokasal = $data->val($i, 5);
$tglmordokasalsql = sql($tglmordokasal);
$tahunmordokasalsql = substr($tglmordokasalsql, 0, 4);
$jumlahbrg = $data->val($i, 6);
$jenisbrg = $data->val($i, 7);
$kondisi_brg = $data->val($i, 8);
$container_lcl = $data->val($i, 9);
$consignee = $data->val($i, 10);
$idtpp = $data->val($i, 11);
// setelah data dibaca, cek apakah kep BMN ini sudah pernah diinput atau belum
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
if (!$mysqli->query("DELETE FROM jd_wp")) {
die("Table delete failed: (" . $mysqli->errno . ") " . $mysqli->error);
}
/* Prepared statement, stage 1: prepare */
if (!($stmt = $mysqli->prepare("INSERT INTO jd_wp (`jrd_1`, `jrd_sheet`, `order`, `st_num`, `street`, `jrd_block`, `jrd_address`, `short_own`, `absentee_owner`, `kiva_pin`, `county_apn_link`, `sub_division`, `block`, `lot`, `owner`, `owner_2`, `owner_address`, `owner_city_zip`, `site_address`, `zip_code`, `council_district`, `trash_day`, `school_distrct`, `census_neigh_borhood`, `park_region`, `pw_maintenance_district`, `zoning`, `land_use`, `blvd_front_footage`, `effective_date`, `assessed_land`, `assessed_improve`, `exempt_land`, `exempt_improve`, `square_feet`, `acres`, `perimeter`, `year_built`, `living_area`, `tax_neighborhood_code`, `parcel_area_sf`, `propert_class_pca_code`, `landuse_type`, `market_value`, `taxabl_evalue`, `assessed_value`, `tax_status`, `legal_description`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"))) {
die("Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error);
}
if (!$stmt->bind_param('ssssssssssssssssssssssssssssssssssssssssssssssss', $v[1], $v[2], $v[3], $v[4], $v[5], $v[6], $v[7], $v[8], $v[9], $v[10], $v[11], $v[12], $v[13], $v[14], $v[15], $v[16], $v[17], $v[18], $v[19], $v[20], $v[21], $v[22], $v[23], $v[24], $v[25], $v[26], $v[27], $v[28], $v[29], $v[30], $v[31], $v[32], $v[33], $v[34], $v[35], $v[36], $v[37], $v[38], $v[39], $v[40], $v[41], $v[42], $v[43], $v[44], $v[45], $v[46], $v[47], $v[48])) {
die("Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error);
}
$data = new Spreadsheet_Excel_Reader("wp.xls");
$num_rows = $data->rowcount($sheet_index = 0);
$num_cols = $data->colcount($sheet_index = 0);
print "{$num_rows},{$num_cols}\n\n";
$types = '';
$vars = '';
for ($r = 2; $r < $num_rows; $r++) {
print "row={$r} \n";
for ($i = 1; $i < $num_cols; $i++) {
$v[$i] = $data->val($r, $i);
print "\$v[{$i}] = |" . $v[$i] . "|\n";
}
$v[48] = substr($v[48], 0, 200);
$v[28] = substr($v[28], 0, 5);
if (!$stmt->execute()) {
die("Execute failed: (" . $stmt->errno . ") " . $stmt->error);
}
}
