<?php


class Appsettings_model extends CI_model
{
    public function getappbyid()
    {
        return $this->db->get_where('app_settings', ['id' => '1'])->row_array();
    }

    public function gettransfer()
    {
        $this->db->select('*');
        $this->db->from('list_bank');
        return $this->db->get()->result_array();
    }

    public function getbankid($id)
    {
        $this->db->select('*');
        $this->db->from('list_bank');
        $this->db->where('id_bank', $id);
        return $this->db->get()->row_array();
    }

    public function ubahdataappsettings($data)
    {
        $this->db->set('app_logo', $data['app_logo']);
        $this->db->set('app_email', $data['app_email']);
        $this->db->set('app_website', $data['app_website']);

        $this->db->set('app_privacy_policy', $data['app_privacy_policy']);
        $this->db->set('app_aboutus', $data['app_aboutus']);
        $this->db->set('app_address', $data['app_address']);
        $this->db->set('app_name', $data['app_name']);
        $this->db->set('app_contact', $data['app_contact']);
        $this->db->set('app_linkgoogle', $data['app_linkgoogle']);
        $this->db->set('app_currency', $data['app_currency']);

        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }

    public function ubahdatarekening($data, $id)
    {
        $this->db->where('id_bank', $id);
        $this->db->update('list_bank', $data);
    }

    public function hapusrekening($id)
    {
        $this->db->where('id_bank', $id);
        $this->db->delete('list_bank');
    }

    public function adddatarekening($data)
    {
        $this->db->insert('list_bank', $data);
    }

    public function ubahdataemail($data)
    {
        $this->db->set('email_subject', $data['email_subject']);
        $this->db->set('email_text1', $data['email_text1']);
        $this->db->set('email_text2', $data['email_text2']);
        $this->db->set('email_subject_confirm', $data['email_subject_confirm']);
        $this->db->set('email_text3', $data['email_text3']);
        $this->db->set('email_text4', $data['email_text4']);

        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }
    
    public function ubahxendit($data)
    {
        $this->db->set('api_keyxendit', $data['api_keyxendit']);
        $this->db->set('apikey_server', $data['apikey_server']);   
        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }
    
    public function ubahdataayopesan($data)
    {
        $this->db->set('api_password', $data['api_password']);
        $this->db->set('harga_pulsa', $data['harga_pulsa']);
        $this->db->set('api_token', $data['api_token']);   
        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }

    public function ubahdatasmtp($data)
    {
        $this->db->set('smtp_host', $data['smtp_host']);
        $this->db->set('smtp_port', $data['smtp_port']);
        $this->db->set('smtp_username', $data['smtp_username']);
        $this->db->set('smtp_password', $data['smtp_password']);
        $this->db->set('smtp_from', $data['smtp_from']);
        $this->db->set('smtp_secure', $data['smtp_secure']);

        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }

    public function ubahdatamobilepulsa($data)
    {
        $this->db->set('mobilepulsa_username', $data['mobilepulsa_username']);
        $this->db->set('mobilepulsa_harga', $data['mobilepulsa_harga']);
        $this->db->set('mobilepulsa_api_key', $data['mobilepulsa_api_key']);
        $this->db->set('mp_status', $data['mp_status']);
        $this->db->set('mp_active', $data['mp_active']);

        $this->db->where('id', '1');
        $this->db->update('app_settings', $data);
    }
}