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/public_html/crm/crm_2020_11_03/application/modules/backlink/models

Free Space:

3.96 TB

🔧 Quick Actions

✏️ Editing: Backlink_model.php

<?php
Class Backlink_model extends CI_Model {        
    function addRecord($main_table, $data, $customer_id = 0)
    {
		if(isset($data['tbl_website']) && !empty($data['tbl_website'])){
			if(empty($data['tbl_website'][1]['website_url'])){
				unset($data['tbl_website']);
			}
		}
        $user_id = $this->session->userdata(SESSION_LOGIN .'user_id');
        $date    = date('Y-m-d H:i:s');
        foreach ($data as $key => $value) {
            if ($this->Common_model->startsWith($key, 'tbl_')) {
                $table_new                  = str_replace('tbl_', '', $key);
                $sub_table_data[$table_new] = $value;
            } else {
                if (strpos($key, '_date') !== false ) {
                    $date_field      = date("Y-m-d H:i:s", strtotime($data[$key]));
                    $main_data[$key] = $date_field;
                } else {
                    $main_data[$key]         = $value;
                    $main_data['ref_user_id']    = $user_id;
                    $main_data['added_date'] = $date;
                }
            }
        }
        $this->db->insert($main_table, $main_data);
        $last_id = $this->db->insert_id();
        if (isset($sub_table_data) && !empty($sub_table_data)) {
            foreach ($sub_table_data as $key => $value1) {
                $new_table = $key;
                foreach ($value1 as $key => $value) {
                    $value['ref_'.$main_table.'_id'] = $last_id;
                    $value['ref_user_id']    = $user_id;
                    $value['added_date'] = $date;
                    //$value['table_name'] = $main_table;
                    $new_data            = $value;
                    //echo $value['valid_upto'];
                   // echo '<br>';
                    if($new_table == 'client_product'){
						$new_data['valid_upto'] = date("Y-m-d H:i:s", strtotime($value['valid_upto']));
						$new_data['creation_date'] = date("Y-m-d H:i:s", strtotime($value['creation_date']));
					}
                    $this->db->insert($new_table, $new_data);
                }
            }
        }
       
        return $last_id;
    }
    
    
    
    function updateBacklinktoClient( $data ) { 
		$data['ref_user_id'] = $this->session->userdata(SESSION_LOGIN .'user_id');
        $data['added_date']    = date('Y-m-d H:i:s');
		if(empty($data['back_link_url_to_client_id'])){
			
			$this->db->insert('back_link_url_to_client', $data);
			$last_id = $this->db->insert_id();
		}else{
			$this->db->where('back_link_url_to_client_id', $data['back_link_url_to_client_id']);
			$this->db->update('back_link_url_to_client', $data);
		}
		return True;
    }
    
     function changeResponseStatus($status, $id){
		
		$this->db->query("UPDATE back_link_url_to_client set ref_back_link_response_status_id = '".$status."' WHERE  back_link_url_to_client_id = '" . $id . "'");
		return $id;
	}
  
    function removeRecord($main_table,$id_field,$id){
		$data = array();
		$data['delete_status'] = '1';
		$this->db->where($id_field, $id);
		$this->db->update($main_table, $data);
		
	}
	
	 // Get Records from table
	function getRecords($main_table, $where = '', $group_by = '', $order_by = '', $limit = '')
    {
        $table_fields      = $this->Common_model->getTableColumn($main_table);
        $filter_query      = array();
        $sql               = '';
        $filter_sql        = '';
        $join_query        = '';
        $select_fields     = '';
        $filter_data_field = array();
        foreach ($table_fields as $data) {
            if ($this->Common_model->startsWith($data, 'ref_')) {
                $ref_field      = $data;
                $primary_field  = str_replace('ref_', '', $data);
                $table_name     = str_replace('_id', '', $primary_field);
			    if($table_name !='back_link'){
					$ref_data_field = $table_name . "_name";
					$join_query .= " LEFT JOIN $table_name ON $table_name.$primary_field = $main_table.$ref_field ";
					$select_fields .= " , $table_name.$ref_data_field";
				}
            }
        }
        $sql .= "SELECT $main_table.*";
        if (isset($select_fields) && !empty($select_fields)) {
            $sql .= " $select_fields ";
        }
        $sql .= " FROM $main_table ";
        if (isset($join_query) && !empty($join_query)) {
            $sql .= $join_query;
        }
        $sql .= " WHERE ";
        
        if(isset($where) && !empty($where)){
			$sql .= $where." AND ";
		}
		
        $sql .= " $main_table.transaction_id = 0 AND ";
        $sql .= " $main_table.delete_status = 0 ";
        
        if(isset($group_by) && !empty($group_by)){
			$sql .= " GROUP BY ".$group_by;
		}
       
        if (isset($order_by) && !empty($order_by)) {
            $sql .= " ORDER BY ".$order_by;
        }
        
        if (isset($limit) && !empty($limit)) {
            $sql .= " LIMIT ".$limit;
        }
       
         //echo $sql;
        //echo "<br>";
        $query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
    }
	
	
    
    function truncate_string($string){
		$string = strip_tags($string);

if (strlen($string) > 50) {

// truncate string
			$stringCut = substr($string, 0, 50);

// make sure it ends in a word so assassinate doesn't become ass...
			$string = '<a title="'.$string.'">'.$stringCut.' ...</a>'; 
		}
		return $string;
	}
    
    function getSubmittedUrlTotal($back_link_id,$back_link_type_id){

$sql = 'SELECT count(*) AS total FROM back_link_url AS bl  JOIN back_link_url_to_client AS blc ON blc.ref_back_link_url_id = bl.back_link_url_id  WHERE blc.ref_back_link_id = "'.$back_link_id.'" AND bl.ref_back_link_type_id = "'.$back_link_type_id.'" GROUP BY bl.ref_back_link_type_id';
		
		$query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
            return $query->result();
        } else {
            return false;
        }
	}   
	
	
	function getExpiredUrlTotal($back_link_id,$back_link_type_id){

$sql = 'SELECT count(*) AS total FROM back_link_url AS bl  JOIN back_link_url_to_client AS blc ON blc.ref_back_link_url_id = bl.back_link_url_id  WHERE blc.ref_back_link_id = "'.$back_link_id.'" AND bl.ref_back_link_type_id = "'.$back_link_type_id.'" AND blc.ref_back_link_url_status_id = 3 GROUP BY bl.ref_back_link_type_id';
		
		//echo '<br>';
		
		$query = $this->db->query($sql);
        if ($query->num_rows() >= 1) {
             return $query->result();
        } else {
            return false;
        }
	}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Backlink_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation