1#@!#!123s

: / home / schoolcampuserp / lawrencehighschool.in / erp / application / controllers /
Filename : Biometric.php
back
<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class Biometric extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        $this->load->helper('json_output');
        $this->load->model('setting_model');
        $this->load->model('student_model');
        $this->load->model('stuattendence_model');
    }
    
    // /**
    //  * Show me where this controller lives on disk
    //  */
    // public function show_path()
    // {
    //     // 1) Path including filename
    //     $filePath    = __FILE__;
    //     // 2) Directory-only
    //     $dirPath     = __DIR__;
    //     // 3) Canonical absolute path
    //     $canonical   = realpath(__FILE__);
    //     // 4) Using CI constants:
    //     $ciRoot      = FCPATH;      // e.g. /home/user/public_html/
    //     $ciApp       = APPPATH;     // e.g. /home/user/public_html/application/

    //     echo "<pre>";
    //     echo "1) __FILE__    = $filePath\n";
    //     echo "2) __DIR__     = $dirPath\n";
    //     echo "3) realpath()  = $canonical\n";
    //     echo "4) FCPATH      = $ciRoot\n";
    //     echo "5) APPPATH     = $ciApp\n";
    //     echo "</pre>";
    // }
 public function fetchAttendanceLog($device)
{
    // API Endpoint URL
    $url = "https://midapp.in/web/Api_v14/userspunchlog";

    // Prepare the post data as form-data
    $postData = array(
            "device" => $device,
            "start_date" =>date('Y/m/d', strtotime('-1 days')), 
            "end_date" => date('Y/m/d')
    );

    // Initialize cURL
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postData); // Send form-data format

    // Optional: Set headers for form-data
    curl_setopt($ch, CURLOPT_HTTPHEADER, array(
        'Content-Type: multipart/form-data'
    ));

    // Execute the request
    $response = curl_exec($ch);
    //print_r($response);
    // Check for cURL errors
    if (curl_errno($ch)) {
        $error_msg = curl_error($ch);
        curl_close($ch);
        echo json_encode(array("status" => "error", "message" => $error_msg));
        return;
    }

    curl_close($ch);

    // Decode the response
    $result = json_decode($response, true);
    //     if (isset($result['data']) && is_array($result['data'])) {
    //     // Initialize an array to store EnrollmentNo values
    //     $enrollmentNos = [];
    
    //     // Loop through each item in the data array
    //     foreach ($result['data'] as $item) {
    //         // Check if 'EnrollmentNo' exists in the current item
    //         if (isset($item['EnrollmentNo'])) {
    //             // Add the EnrollmentNo to the array
    //             $enrollmentNos[] = $item['EnrollmentNo'];
    //         }
    //     }
    
    //     // Get only unique EnrollmentNo values
    //     $uniqueEnrollmentNos = array_unique($enrollmentNos);
    
    //     // Print unique EnrollmentNo values
    //     foreach ($uniqueEnrollmentNos as $enrollmentNo) {
    //         echo $enrollmentNo . "<br>";
    //     }
        
    // }
    // echo date('Y/m/d');
    return $result;
    // Handle the API response
    // if (isset($result['Status']) && $result['Status'] === "Success") {
    //     echo json_encode(array("status" => "success", "data" => $result['data']));
    // } elseif (isset($result['Status']) && $result['Status'] === "Failed") {
    //     echo json_encode(array("status" => $result['Status'], "message" => $result['Msg']));
    // } else {
    //     echo json_encode(array("status" => "error", "message" => "Failed to fetch data from API."));
    // }
}



    public function index()
    {
        

            $attendence_param = file_get_contents('php://input');
            $params           = json_decode(file_get_contents('php://input'), true);
            $settings         = $this->setting_model->getSchoolDetail();
           // print_r($settings);
            if ($settings->biometric) {
                $devices = array_map('trim', explode(",", $settings->biometric_device));
                 foreach ($devices as $device) { 
                 $attendanceLogResponse = $this->fetchAttendanceLog($device);
                //print_r($attendanceLogResponse);
                // die();
                    if ($attendanceLogResponse['Status'] === "Success") {
                        // Process each attendance entry
                        foreach ($attendanceLogResponse['data'] as $log) {
                            // Check if the record already exists in the database
                            
                            
                            // $existingRecord = $this->checkDuplicateAttendance(
                            //     $log['EnrollmentNo'],
                            //     $log['PunchDateTime']
                            // );

                            if (true) {
                                // Insert only if it's not a duplicate
                                
                                print_r($log);
                                $student = $this->student_model->findByAdmission($log['EnrollmentNo']);
                                if ($student) {
                                    $insert_record = array(
                                        'date'                  => date('Y-m-d', strtotime($log['PunchDateTime'])),
                                        'student_session_id'    => $student->student_session_id,
                                        'attendence_type_id'    => 1,
                                        'biometric_attendence'  => 1,
                                        'remark'                => '',
                                        'created_at'            => $log['PunchDateTime'],
                                        'biometric_device_data' => json_encode($log),
                                    );
                                    $this->stuattendence_model->onlineattendence($insert_record);
                                }
                            }
                        }
                        json_output(200, array('status' => 200, 'message' => 'Attendance logs processed successfully.'));
                        // optionally log to a file as well
    // file_put_contents(__DIR__ . '/biometric_cron.log',
    //     date('[Y-m-d H:i:s] ') . "Finished\n",
    //     FILE_APPEND
    // );
                    } else {
                        json_output(500, array('status' => 500, 'message' => 'Failed to fetch attendance logs.'));
                    }
                
                 }
                
                
                // $total_devices = array_map('trim', explode(",", $settings->biometric_device));
                // if (!empty($params)) {
                //     if ($params['serial_number']) {
                //         if (in_array($params['serial_number'], $total_devices)) {

                //             $student = $this->student_model->findByAdmission($params['user_id']);
                //             if ($student) {
                //                 $insert_record = array(
                //                     'date'                  => date('Y-m-d', strtotime($params['t'])),
                //                     'student_session_id'    => $student->student_session_id,
                //                     'attendence_type_id'    => 1,
                //                     'biometric_attendence'  => 1,
                //                     'remark'                => '',
                //                     'created_at'            => $params['t'],
                //                     'biometric_device_data' => $attendence_param,
                //                 );
                //                 $insert_result = $this->stuattendence_model->onlineattendence($insert_record);
                //                 if ($insert_result) {
                //                     json_output(200, array('status' => 200, 'message' => 'Record Inserted.'));
                //                 } else {
                //                     json_output(200, array('status' => 200, 'message' => 'Something Wrong.'));
                //                 }
                //             }
                //         }
                //     }
                // }
            }
        
    }
    public function checkDuplicateAttendance($enrollmentNo, $punchDateTime)
{
    $this->db->where('student_session_id', $enrollmentNo);
    $this->db->where('created_at', $punchDateTime);
    $query = $this->db->get('student_attendances'); // Replace 'attendance_table' with the actual table name

    return $query->num_rows() > 0; // Returns true if the record exists
}


}