<?php defined('BASEPATH') OR exit('No direct script access allowed');

class ApplicationStatusModel extends CI_Model {

   public $tableName = 'bank_application';

    function create() {
        
        $this->db->where('application_id', $this->input->post('applicationId'));
        $this->db->where('bank_id', $this->session->user_id);
        $this->db->where('status', $this->input->post('status'));
        $sql = $this->db->get($this->tableName);
        if($sql->num_rows() > 0) {
            $this->output->set_status_header(400);
            return json_encode(['message' => 'You already accpted this lead, Please check in Recived bucket list', 'status' => 'failed']);
        }

    
        $arr = array(
            'id'            =>  uniqid(),
            'application_id'	=>  $this->input->post('applicationId'),
            'bank_id'		=>	$this->session->user_id,
            'status'  		=>  $this->input->post('status'),
            'created_at'	=> global_datetime(),
            );
    
        $userdetail = [];
        if(!empty($this->session->company)) {
            $userdetail = (array)$this->session->company;
            unset( $userdetail['password']);
        }
        $arr['created_by'] = json_encode($userdetail);

        $this->db->insert($this->tableName, $arr);
        if( $this->db->affected_rows() > 0 ) {
            return json_encode(['message' => 'Created successfully', 'status' => 'success']);
        } else {
            $this->output->set_status_header(400);
            return json_encode(['message' => 'Unknown Error', 'status' => 'failed']);
        }
    }



    function update() {

        if(empty($this->session->user_id)) {
            $this->output->set_status_header(401);
            return json_encode(['message' => 'Unauthorized action', 'status' => 'failed']); 
        }

        $arr = array(
            'status'  		=>  $this->input->post('status'),
            'loan_number'  	=>  $this->input->post('loan_number'),
            'updated_at'	=> global_datetime(),
            );
    

        $this->db->where('application_id', $this->input->post('applicationId'));
        $this->db->where('bank_id', $this->session->user_id);

        $this->db->update($this->tableName, $arr);

        if( $this->db->affected_rows() > 0 ) {
            return json_encode(['message' => 'Created successfully', 'status' => 'success']);
        } else {
            $this->output->set_status_header(400);
            return json_encode(['message' => 'Unknown Error', 'status' => 'failed']);
        }
    }

}