Files
Ontime/backendpanel/application/models/Appsettings_model.php
2026-03-11 15:29:37 +07:00

117 lines
3.9 KiB
PHP
Executable File

<?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);
}
}