<?php

namespace BitCode\BitForm\Core\Database;

use BitCode\BitForm\Core\Database\Model;
/**
 * Undocumented class
 */

use WP_Error;

class FormEntryLogModel extends Model
{

    public function geLogHistory($form_id, $entry_id)
    {
        $sql =  "SELECT * FROM `{$this->app_db->prefix}bitforms_form_entry_log` where form_entry_id=$entry_id AND form_id=$form_id order By created_at DESC";
        
        $logs = $this->execute($sql)->getResult();
        $response  = ['success' => true, 'data' => [],'integrations'=>[]];   
        $ids=[];
        foreach($logs as $log){
            $ids[] = $log->id;
        }
        if (isset($logs->errors['result_empty'])) {
            wp_send_json($response);
        }else{
            $allLogId = preg_replace('/"/', '', implode(',',$ids));    
            $sql2 = "SELECT * FROM `{$this->app_db->prefix}bitforms_form_log_details` WHERE `log_id` IN ($allLogId)";
            $integrations = $this->execute($sql2)->getResult();
            foreach ($logs as  $key => $log) {
                foreach ($integrations as $integration) {
                    if ( $integration->log_id == $log->id ) {
                        $logs[$key]->integration = true; 
                    }      
                }
            }           
            if(isset($integrations->errors['result_empty'])){
                $integrations=[];
            }
             wp_send_json(['success' => true, 'data' => $logs,'integrations'=>$integrations]);
        }   
           
    }

    public function form_log_insert($data = array())
    {
        if (is_null($data)) {
            return new WP_Error('empty_data', __('Form data is empty', 'bitform'));
        }
        $result = $this->app_db->insert(
            "{$this->app_db->prefix}bitforms_form_entry_log",
            $data
        );
        return $this->getResult($result);
    }

    public function log_history_insert($data = array())
    {
        if (is_null($data)) {
            return new WP_Error('empty_data', __('Form data is empty', 'bitform'));
        }
        $result = $this->app_db->insert(
            "{$this->app_db->prefix}bitforms_form_log_details",
            $data
        );
        return $this->getResult($result);
    }

    public function get_form_value($form_id = "")
    {
        $sql =  "SELECT `meta_key`,`meta_value` FROM `{$this->app_db->prefix}bitforms_form_entrymeta` where bitforms_form_entry_id=$form_id";
        return $this->execute($sql)->getResult();
    }
    public function logUpdate($updateValue, $logID)
    {
        if (empty($logID)) {
            return false;
        }
        $sql = "UPDATE `{$this->app_db->prefix}bitforms_form_entry_log` SET content='$updateValue' WHERE id=$logID";
        return $this->execute($sql)->getResult();
    }
}