<?php

/**
 * UserIdentificationModel class file
 *
 * PHP Version 7.2
 *
 * @category Model
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

namespace App\Models;
  
use Illuminate\Database\Eloquent\Model;
use DB;

/**
 * UserIdentificationModel class
 *
 * The class manage User Identification related queries
 *
 * @category UserIdentificationModel
 * @package  Ez
 * @author   Imenso Software <admin@imensosoftware.com>
 * @license  http://imensosoftware/license.php GNU Public License
 * @link     http://imensosoftware.com/recipes
 */

class UserIdentification extends Model
{
    public $table = "user_identifications";
    public $fillable = ['user_id','photo_proof_type_id','photo_proof_file','photo_proof_status_id',
        'address_proof_type_id','address_proof_file','address_proof_status_id',];

    /**
     * GetUserIdentification function gets the identification information
     * of a specified user and return it.
     *
     * @param  array data
     * @return \App\Models\UserIdentification
     */
    public static function getUserIdentification($data)
    {
        $user_id = $data['user_id'];
        $userIdentification = UserIdentification::
        select(
            'user_identifications.user_id',
            'user_identifications.photo_proof_type_id',
            'user_identifications.photo_proof_file',
            'user_identifications.photo_proof_status_id',
            'user_identifications.address_proof_type_id',
            'user_identifications.address_proof_file',
            'user_identifications.address_proof_status_id',
            'photo_proof_types.photo_proof_type',
            'address_proof_types.address_proof_type',
            'photo_proof_status.status_urv as photo_proof_status',
            'address_proof_status.status_urv as address_proof_status',
            'profiles.info_status',
            'profiles.skill_status',
            'profiles.evaluation_status'
        )
            ->leftJoin(
                'photo_proof_types',
                'photo_proof_types.id',
                '=',
                'user_identifications.photo_proof_type_id'
            )
            ->leftJoin(
                'address_proof_types',
                'address_proof_types.id',
                '=',
                'user_identifications.address_proof_type_id'
            )
            ->leftJoin(
                'status as photo_proof_status',
                'photo_proof_status.id',
                '=',
                'user_identifications.photo_proof_status_id'
            )
            ->leftJoin(
                'status as address_proof_status',
                'address_proof_status.id',
                '=',
                'user_identifications.address_proof_status_id'
            )
            ->leftJoin('profiles', 'profiles.user_id', '=', 'user_identifications.user_id')
            ->where('user_identifications.user_id', $user_id)->first();
        return $userIdentification;
    }
}