Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/models

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: Setting_model.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
/***************************************************************
    Purpose : To handle all the settings database details
    Date    : 04-10-2018 
****************************************************************/
class Setting_model extends CI_Model
{
	function __construct()
    {
        parent::__construct();
        date_default_timezone_set('Asia/Calcutta'); 
    }
 /* ************************************************************************************
                        Purpose : To handle General Setting Functions
            **********************************************************************/
// To get general settings details
public function get_general_settings_details(){

//$this->db->reconnect();
    $query  = $this->db->query("call general_settings_dedatils()");
    $result = $query->row();
    //$this->db->close();
    return $result;
     
}
// To get date formats details
public function date_format_list(){

//$this->db->reconnect();
    $query  = $this->db->query("call date_format_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
     
}
// To get country details
public function country_list(){

//$this->db->reconnect();
    $query  = $this->db->query("call country_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
     
}

// To get state details
public function state_list($countryId){

//$this->db->reconnect();
    $query  = $this->db->query("call state_list('".$countryId."')");
    $result = $query->result();
    //$this->db->close();
    return $result;
}

// To get city details
public function city_list($stateId){

//$this->db->reconnect();
    $query  = $this->db->query("call city_list('".$stateId."')");
    $result = $query->result();
    //$this->db->close();
    return $result;
     
}

// To update the general settings details
public function  general_setting_update($gen_settings, $id)
{

if($query = $this->db->query("call general_setting_update(
    '".trim($gen_settings['product_logo'])."',   
    '".trim($gen_settings['favicon'])."',
    '".trim($gen_settings['product_title'])."',
    '".trim($gen_settings['contact_person_name'])."',
    '".trim($gen_settings['contact_person_email_id'])."',
    '".trim($gen_settings['website'])."',
    '".trim($gen_settings['address'])."',
    '".trim($gen_settings['country'])."',
    '".trim($gen_settings['state'])."',
    '".trim($gen_settings['city'])."',
    '".trim($gen_settings['pincode'])."',
    '".trim($id)."',
    '".trim($gen_settings['date_format'])."',
    '".trim($gen_settings['esi_percent'])."',
    '".trim($gen_settings['epf_percent'])."'

)"))
       {  return true; }else{ return false; }
}

/**********************************************************************************************************
                            Purpose : To handle Email Configuration Function
    *****************************************************************************************/
// To update email configuration details
public function email_configuration_update($data, $id)
{
    if($query = $this->db->query("call email_configuration_update(
    '".trim($data['smtp_host_name'])."',   
    '".trim($data['smtp_user_name'])."',
    '".trim($data['smtp_password'])."',
    '".trim($data['from_mail'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}
/**********************************************************************************************************
                            Purpose : To handle SMS Configuration Function
    *****************************************************************************************/
// To update SMS configuration details
public function sms_configuration_update($data, $id)
{
    if($query = $this->db->query("call sms_configuration_update(
    '".trim($data['sms_sender_id'])."',   
    '".trim($data['sms_auth_key'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}
/**********************************************************************************************************
                            Purpose : To handle Whatsapp Configuration Function
    *****************************************************************************************/
// To update Whatsapp configuration details
public function whatsapp_configuration_update($data, $id)
{
    if($query = $this->db->query("call whatsapp_configuration_update(
    '".trim($data['whatsapp_no'])."',   
    '".trim($data['whatsapp_api_key'])."',
    '".trim($id)."', 
    '".trim($data['is_whatsapp_enable'])."'
    )"))
       {  return true; }else{ return false; }
}
/**********************************************************************************************************
                            Purpose : To handle Email Template Function
    *****************************************************************************************/
// To list email templates
public function email_template_list()
{
    //$this->db->reconnect();
    $query  = $this->db->query("call email_template_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
}

// To update email template status
public function email_template_change_status($data, $id)
{
    if($query = $this->db->query("call email_template_change_status(
    '".trim($data['status'])."',   
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

// To get email templatey id
public function email_template_by_id($id)
{
    //$this->db->reconnect();
    $query  = $this->db->query("call email_template_by_id('".$id."')");
    $result = $query->row();
    //$this->db->close();
    return $result;
}

// To update email template by
public function email_template_update($data, $id)
{
    if($query = $this->db->query("call email_template_update(
    '".trim($data['email_name'])."',   
    '".trim($data['email_subject'])."',
    '".trim($data['email_content'])."',
    '".trim($data['modified_by'])."',
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

/**********************************************************************************************************
                            Purpose : To handle SMS Template Function
    *****************************************************************************************/
// To list sms templates
public function sms_template_list()
{
    //$this->db->reconnect();
    $query  = $this->db->query("call sms_template_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
}

// To get sms templatey id
public function sms_template_by_id($id)
{
    //$this->db->reconnect();
    $query  = $this->db->query("call sms_template_by_id('".$id."')");
    $result = $query->row();
    //$this->db->close();
    return $result;
}

// To update sms template by
public function sms_template_update($data, $id)
{
    if($query = $this->db->query("call sms_template_update(
    '".trim($data['sms_template_name'])."',   
    '".trim($data['sms_content'])."',
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

// To update sms template status
public function sms_template_change_status($data, $id)
{
    if($query = $this->db->query("call sms_template_change_status(
    '".trim($data['status'])."',   
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

/**********************************************************************************************************
                            Purpose : To handle Whatsapp Template Function
    *****************************************************************************************/
// To list Whatsapp templates
public function whatsapp_template_list()
{
    //$this->db->reconnect();
    $query  = $this->db->query("call whatsapp_template_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
}

// To get Whatsapp templatey id
public function whatsapp_template_by_id($id)
{
    //$this->db->reconnect();
    $query  = $this->db->query("call whatsapp_template_by_id('".$id."')");
    $result = $query->row();
    //$this->db->close();
    return $result;
}

// To update Whatsapp template by
public function whatsapp_template_update($data, $id)
{
    if($query = $this->db->query("call whatsapp_template_update(
    '".trim($data['whatsapp_template_name'])."',   
    '".trim($data['whatsapp_content'])."',
    '".trim($data['modified_by'])."',
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

// To update Whatsapp template status
/*public function sms_template_change_status($data, $id)
{
    if($query = $this->db->query("call sms_template_change_status(
    '".trim($data['status'])."',   
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}*/

/**********************************************************************************************************
                            Purpose : To handle Department Template Function
    *****************************************************************************************/

public function get_dept_list()
{
    //$this->db->reconnect();
    $query  = $this->db->query("call department_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
}
public function dept_delete($id)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL delete_dept(".$id.")");
    //$this->db->close();
    return $result;
}
public function unique_dept($name)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL dept_unique('".$name['val']."')")->row();
    //$this->db->close();
    return $result;
}
public function unique_dept_edit($name)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL dept_unique_edit('".$name['val']."',".$name['id'].")")->row();
    //$this->db->close();
    return $result;
}
public function create_dept($data)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL create_dept('".$data['department']."',".$data['status'].")");
    //$this->db->close();
    return $result;
}
public function get_dept($data)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL get_dept_details(".$data.")")->row();
    //$this->db->close();
    return $result;
}
public function update_dept($data)
{
    //$this->db->reconnect();
    $result = $this->db->query("CALL update_dept('".$data['department']."',".$data['id'].")");
    //$this->db->close();
    return $result;
}

/**********************************************************************************************************
                            Purpose : To handle T&C Function
    *****************************************************************************************/
// To list T&C
public function terms_and_conditions_list()
{
    //$this->db->reconnect();
    $query  = $this->db->query("call terms_and_conditions_list()");
    $result = $query->result();
    //$this->db->close();
    return $result;
}

// To get T&C by id
public function terms_and_conditions_by_id($id)
{
    //$this->db->reconnect();
    $query  = $this->db->query("call terms_and_conditions_by_id('".$id."')");
    $result = $query->row();
    //$this->db->close();
    return $result;
}

// To update T&C
public function terms_and_conditions_update($data, $id)
{
    if($query = $this->db->query("call terms_and_conditions_update(  
    '".trim($data['terms_and_conditions'])."',
    '".trim($data['modified_by'])."',
    '".trim($data['modified_on'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

// To update T&C status
public function terms_and_conditions_change_status($data, $id)
{
    if($query = $this->db->query("call terms_and_conditions_change_status(
    '".trim($data['status'])."',   
    '".trim($data['modified_on'])."',  
    '".trim($data['modified_by'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}
/**********************************************************************************************************
                            Purpose : To handle Invoice Discount Function
    *****************************************************************************************/
// To update Invoice Discount details
public function invoice_discount_update($data, $id)
{
    if($query = $this->db->query("call invoice_discount_update(
    '".trim($data['invoice_disc_percent'])."',   
    '".trim($data['otp_message_mobile'])."',
    '".trim($id)."'
    )"))
       {  return true; }else{ return false; }
}

} // class end
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Setting_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation