import excel csv to databse

//template
<form method="post" action="" enctype="multipart/form-data">
    <input type="file" name="filecsv" value="">
    <input type="submit" id="submit_import" name="submit_import" value="Import Logs" class="themeInputButton">
</form>




//crontroller

 if (count($_POST)>0) {
                //import data
                //$import_logs = $objClsImport_Logs->import_logs($_FILES['filecsv']['tmp_name']);
                $import_logs = $objClsImport_Logs->import_logs2($_FILES['filecsv']['tmp_name']);
            }


//class

    function import_logs2($excel_file_name_with_path){
        $fcontent = file($excel_file_name_with_path);

        $a = 0;
        $arr = array();
        unset($fcontent[0]);
        unset($fcontent[1]);
        unset($fcontent[2]);
        unset($fcontent[3]);
        //printa($fcontent);
        foreach ($fcontent as $fval){
            $data = explode(';',$fval);
            //datetime pag nag error ditong part it means na meron logs na walang date sa calendar
            $datetime = DateTime::createFromFormat("y-m-d",$data[3]);
            $date = $datetime->format("Y-m-d");
            //$time = $datetime->format("H:i");
            //printa($data);die;
            $formatted_data = array(
                "emp_no" => $data[0],
                "firstname" => $data[1],
                "tks_trans_date" => $date,
                "tks_time_in" => $data[5],
                "tks_break_in" => $data[6],
                "tks_break_out" => $data[6],
                "tks_time_out" => $data[6]);

            $arr[] = $formatted_data;
            $a++;

        }

        //printa($arr);die;


        $this->import_array($arr);
        $_SESSION['message'] = "<p style='color: green'>Import Logs Successfull</p>";
        //header('Location:commision_benefits.php?statpos=import_logs');

    }


    function import_array($arr = array()){
        /*printa($arr);die;*/
        $value = array();
        $empnum = array();
        foreach ($arr as $aval){
            $emp_id = $this->getEmployeeIDWithEmpNo($aval['emp_no']);
            $value[] = "('$emp_id','{$aval['emp_no']}', '{$aval['firstname']}', '{$aval['tks_trans_date']}', '{$aval['tks_time_in']}:00', '{$aval['tks_break_in']}:00', '{$aval['tks_break_out']}:00', '{$aval['tks_time_out']}:00')";
            $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval['tks_trans_date']}'";
            $this->conn->Execute($sql1);


            /*if(!empty($emp_id)) {

                if(count($aval) >= 5){
                    $value[] = "($emp_id,'{$aval[0]['emp_no']}', '{$aval[0]['lastname']} {$aval[0]['firstname']}', '{$aval[0]['time']}:00', '{$aval[1]['time']}:00', '{$aval[2]['time']}:00', '{$aval[(count($aval) - 1)]['time']}:00', '{$aval[0]['date']}')";
                    $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval[0]['date']}'";
                    $this->conn->Execute($sql1);
                }

                if (count($aval) == 4) {
                    $value[] = "($emp_id,'{$aval[0]['emp_no']}', '{$aval[0]['lastname']} {$aval[0]['firstname']}', '{$aval[0]['time']}:00', '{$aval[1]['time']}:00', '{$aval[2]['time']}:00', '{$aval[3]['time']}:00', '{$aval[0]['date']}')";
                    $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval[0]['date']}'";
                    $this->conn->Execute($sql1);
                }

                if(count($aval) == 3){
                    $value[] = "($emp_id,'{$aval[0]['emp_no']}', '{$aval[0]['lastname']} {$aval[0]['firstname']}', '{$aval[0]['time']}:00', '{$aval[1]['time']}:00', '', '{$aval[2]['time']}:00', '{$aval[0]['date']}')";
                    $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval[0]['date']}'";
                    $this->conn->Execute($sql1);
                }

                if (count($aval) == 2) {
                    $value[] = "($emp_id,'{$aval[0]['emp_no']}', '{$aval[0]['lastname']} {$aval[0]['firstname']}', '{$aval[0]['time']}:00', '', '', '{$aval[1]['time']}:00', '{$aval[0]['date']}')";
                    $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval[0]['date']}'";
                    $this->conn->Execute($sql1);
                }

                if (count($aval) == 1) {
                    $value[] = "($emp_id,'{$aval[0]['emp_no']}', '{$aval[0]['lastname']} {$aval[0]['firstname']}', '{$aval[0]['time']}:00', '', '', '', '{$aval[0]['date']}')";
                    $sql1 = "delete from dps_hris_db.tks_emp_log where emp_id = $emp_id and tks_trans_date = '{$aval[0]['date']}'";
                    $this->conn->Execute($sql1);
                }


            }else{
                //dito yung data na makikita yung employee na wala sa system pero may log file siya
                $empnum[] = $aval[0]['emp_no'].'  '.$aval[0]['firstname'].'  '.$aval[0]['lastname'];

            }*/
        }

        //printa($empnum);

        $values = implode(",",$value);
       echo $sql = "insert into dps_hris_db.tks_emp_log (emp_id,emp_no,tks_emp_name,tks_trans_date,tks_time_in,tks_break_in,tks_break_out,tks_time_out) values $values";
        echo "<br>";
        //printa($value);die;
        //die;
        $this->conn->Execute($sql);
    }

    function getEmployeeIDWithEmpNo($emp_no){

        $sql = "select emp_id
                from dps_hris_db.hris_emp_masterfile
                where emp_no = '$emp_no'";
        $result = $this->conn->Execute($sql);

        if(!$result->EOF){
            return $result->fields['emp_id'];
        }
    }