from odoo import models, api, fields
import logging
import requests
import json

_logger = logging.getLogger(__name__)


class IpLookup(models.Model):
    _name = 'ip.lookup'

    date_from = fields.Date(string='Date From', required=True)
    date_to = fields.Date(string='Date To', required=True)
    lookup_line = fields.One2many('ip.lookup.line', 'ip_lookup_id', string='Lookup Lines', auto_join=True)

    def generate_ip_lookup(self):
        query = [
            ('create_date', '>=', self.date_from),
            ('create_date', '<=', self.date_to),
            ('ip_address', '!=', False)
        ]
        logss = self.env['user.activity.log'].search(query)
        ips = []
        for log in logss:
            ips.append(log.ip_address)
        logs = list(dict.fromkeys(ips))

        count = 0
        for log in logs:
            self.env['ip.lookup.line'].create([{
                'ip_lookup_id': self.id,
                'ip_address': log
            }])
            count += 1
        _logger.info('IP Lookup Generated %s' % count)

    def _load_ip_address_lookup(self):
        domain = [
            ('lookup', '=', False),
        ]
        logs = self.env['ip.lookup.line'].search(domain, limit=45, order='create_date asc')
        for log in logs:
            try:
                query = [
                    ('ip_address', '=', log.ip_address),
                    ('lookup', '!=', False)
                ]
                last_data = self.env['ip.lookup.line'].search(query, limit=1)
                if last_data:
                    log.lookup = last_data.lookup
                    country = json.loads(last_data.lookup)['country']
                    timezone = json.loads(last_data.lookup)['timezone']
                    _logger.info('Parsing IP using last data %s' % log.id)
                else:
                    ipinfo = requests.get('http://ip-api.com/json/%s' % log.ip_address).json()
                    del ipinfo['status']
                    lookup_json = json.dumps(ipinfo, indent=4, sort_keys=True) 
                    log.lookup = lookup_json
                    country = json.loads(lookup_json)['country']
                    timezone = json.loads(lookup_json)['timezone']
                    _logger.info('Parsing IP using API JSON %s' % log.id)
                log.country = country
                log.timezone = timezone
                log.continent = timezone.split('/')[0]
            except:
                # log.lookup = ''
                _logger.info('Failed parsing IP Lookup Line %s' % log.id)

    def _load_info_address_lookup(self):
        lines = self.env['ip.lookup.line'].search([('country', '=', False), ('lookup', '!=', False)], limit=500)
        for line in lines:
            line.country = json.loads(line.lookup)['country']
            timezone = json.loads(line.lookup)['timezone']
            continent = timezone.split('/')[0]
            line.timezone = timezone
            line.continent = continent
            _logger.info('Success parsing ip lookup line id %s' % line.id)

class IpLookupLine(models.Model):
    _name = 'ip.lookup.line'

    ip_lookup_id = fields.Many2one('ip.lookup', string='Lookup Ref', required=True, ondelete='cascade', index=True,
                                 copy=False)
    ip_address = fields.Char(string='IP Address')
    lookup = fields.Char(string='Lookup')
    country = fields.Char(string='Country')
    timezone = fields.Char(string='Timezone')
    continent = fields.Char(string='Continent', help='diparsing dari field timezone')