<?php
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../link/function.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../class/clsDepartmentPE.php";
include_once "../class/clsPersonPE.php";

$oCc = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EPERSON'], $GLOBALS['DBUSER_EPERSON'], $GLOBALS['DBPASS_EPERSON']);
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);


$oDP = new Department($oC);
$oPS = new person($oC);

$oDPp = new departmentPE($oCc);
$oDPp2 = new departmentPE($oCc);
$oPSp = new PersonPE($oCc);

if($method == "upload_file") {
    $rootdir = "uploadfile"; //กำหนด directory สำหรับเก็บ file ที่จะ upload เข้าไป
    $limitfile = 70000; //กำหนด ขนาด file ที่อนุญาติให้โหลดเข้ามาเก็บได้ (ต่อ 1 file) หน่วยเป็น byte
    $fileName = date('dmY_His');
    $docPath = "$rootdir/".$fileName.".csv";
    if($uploadfile_size > $limitfile) {
            echo "<meta http-equiv='refresh' content='0; URL=ImportPsExcel.php?c=1'>";
    }
    else if(substr($uploadfile_name, -3) != 'csv') {
            echo "<meta http-equiv='refresh' content='0; URL=ImportPsExcel.php?c=2'>";
    }
    else {
            copy($uploadfile, $docPath);    
            echo "<meta http-equiv='refresh' content='0; URL=ImportPsExcel.php?c=3&n=$fileName.csv&s=$uploadfile_size'>";
    }
}else if($method=="delete"){
    $delfile="uploadfile/".$filename;
    unlink($delfile);
    echo "<meta http-equiv='refresh' content='0; URL=addperson_e.php'>";
}
?>