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/proposal/models

Free Space:

3.55 TB

🔧 Quick Actions

✏️ Editing: Proposal_model.php

<?php
Class Proposal_model extends CI_Model {
    
	 function updateRecord($main_table, $data, $id ) {

$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;
                }
            }
        }

//update Current record 
        $this->db->where($main_table.'_id', $id);
        $this->db->update($main_table, $main_data);
		
		// Sub table data insertion - Mobile number and Email ids
		if(isset($sub_table_data) && !empty($sub_table_data)){
			foreach ($sub_table_data as $key => $value1) {
				$this->db->where('ref_'.$main_table.'_id', $id);
				$this->db->update($key, array('delete_status' => 1));
				$new_table = $key;
				foreach ($value1 as $key => $value) {
					$value['ref_'.$main_table.'_id'] = $id;
					//$value['table_name'] = $main_table;
					$value['ref_user_id'] = $user_id;
					$value['added_date'] = $date;
					$new_data = $value;
					
					$this->db->insert($new_table, $new_data);
				}
			}
		}
		// Ends here
		return $id;
        
    }
    
   
   
	 /*****
     * Remove Proposal items from temprary table 
     * 
     * *****/
     
    function removeTempProposal(){
		$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$query = $this->db->query( " DELETE FROM proposal_details_temp WHERE ref_user_id = '".$ref_user_id."'");
	}
	
	
	function addTempProposalItems($data){
		$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		if(isset($data['proposal_items_static']) && !empty($data['proposal_items_static'])){
			foreach($data['proposal_items_static'] as $val){
				$query = $this->db->query( " INSERT INTO  proposal_details_temp SET category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 1, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
			}
		}
		if(isset($data['proposal_items_dynamic']) && !empty($data['proposal_items_dynamic'])){
			foreach($data['proposal_items_dynamic'] as $val){
				$val['sub_category'] = implode('|||',$val['sub_category']);
				$query = $this->db->query( " INSERT INTO  proposal_details_temp SET category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 2, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
			}
		}
		if(isset($data['proposal_items_others']) && !empty($data['proposal_items_others'])){
			foreach($data['proposal_items_others'] as $val){
				$query = $this->db->query( " INSERT INTO  proposal_details_temp SET category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 3,content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
			}
		}
		if(isset($data['proposal_optional_content']) && !empty($data['proposal_optional_content'])){
			
			$query = $this->db->query( " INSERT INTO  proposal_details_temp SET category_text = '".$data['proposal_optional_content']."', content_type = '2', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
		}
		
		if(isset($data['proposal_note_content']) && !empty($data['proposal_note_content'])){
			foreach($data['proposal_note_content'] as $k => $v){
				$main_data['ref_user_id'] = $ref_user_id;
				$main_data['session_id'] = $_SESSION['session_id'];
				$main_data['content_type'] = 3;
				$main_data['category_text'] = $v;			
				$this->db->insert('proposal_details_temp', $main_data);
			}
		}
		return $this->db->insert_id();
	}
	
	// Move data from Temp to Orginal table(Proposal_details)
	function addProposalDetails($data,$proposal_id){
		if(isset($data) && !empty($data)){
			// Remove Old proposal Itmes
			$this->db->where('ref_proposal_id', $proposal_id);
			$this->db->delete('proposal_details');
			
			$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
			if(isset($data['proposal_items_static']) && !empty($data['proposal_items_static'])){
				foreach($data['proposal_items_static'] as $val){
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 1, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
			if(isset($data['proposal_items_dynamic']) && !empty($data['proposal_items_dynamic'])){
				foreach($data['proposal_items_dynamic'] as $val){
					$val['sub_category'] = implode('|||',$val['sub_category']);
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 2, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
			if(isset($data['proposal_items_others']) && !empty($data['proposal_items_others'])){
				foreach($data['proposal_items_others'] as $val){
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 3,content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
						
			if(isset($data['proposal_note_content']) && !empty($data['proposal_note_content'])){
				foreach($data['proposal_note_content'] as $k => $v){
					$main_data['ref_proposal_id'] = $proposal_id;
					$main_data['ref_user_id'] = $ref_user_id;
					$main_data['session_id'] = $_SESSION['session_id'];
					$main_data['content_type'] = 3;
					$main_data['category_text'] = $v;			
					$this->db->insert('proposal_details', $main_data);
				}
			}
		
		}
		return $this->db->insert_id();
	}
	
	
	function addUpdatedProposalDetails($data,$proposal_id){
		if(isset($data) && !empty($data)){
/*
			echo '<pre>';
			
			print_r($data);
			echo '</pre>';
*/
			//exit;
			// Remove Old proposal Itmes
			$this->db->where('ref_proposal_id', $proposal_id);
			$this->db->delete('proposal_details');
			
			$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
			if(isset($data['proposal_items_static']) && !empty($data['proposal_items_static'])){
				foreach($data['proposal_items_static'] as $val){
					
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 1, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
			if(isset($data['proposal_items_dynamic']) && !empty($data['proposal_items_dynamic'])){
				foreach($data['proposal_items_dynamic'] as $val){
					$val['sub_category'] = implode('|||',$val['sub_category']);
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 2, content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
			if(isset($data['proposal_items_others']) && !empty($data['proposal_items_others'])){
				foreach($data['proposal_items_others'] as $val){
					$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', proposal_details_item_type = 3,content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
				}
			}
						
			if(isset($data['proposal_note_content']) && !empty($data['proposal_note_content'])){
				foreach($data['proposal_note_content'] as $k => $v){
					$main_data['ref_proposal_id'] = $proposal_id;
					$main_data['ref_user_id'] = $ref_user_id;
					$main_data['session_id'] = $_SESSION['session_id'];
					$main_data['content_type'] = 3;
					$main_data['category_text'] = $v;			
					$this->db->insert('proposal_details', $main_data);
				}
			}
		
		}
		
		//exit;
		return $this->db->insert_id();
	}
	
	function addUpdatedProposalDetails_old($data,$proposal_id){
		$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		// Remove Old proposal Itmes
		$this->db->where('ref_proposal_id', $proposal_id);
		$this->db->delete('proposal_details');

/*
		echo '<pre>';
		print_r($data);
		echo '</pre>';
		exit;	
*/

if(isset($data['proposal_items_static']) && !empty($data['proposal_items_static'])){
			foreach($data['proposal_items_static'] as $val){
				$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$val['category']."',sub_category_text = '".$val['sub_category']."', amount = '".$val['amount']."', pages_or_years = '".$val['pages_or_years']."', content_type = '1', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
			}
		}
		if(isset($data['proposal_optional_content']) && !empty($data['proposal_optional_content'])){
			$val['sub_category'] = implode('|||',$val['sub_category']);
			$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$data['proposal_optional_content']."', content_type = '2', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
		}
		
		if(isset($data['proposal_note_content']) && !empty($data['proposal_note_content'])){
			$query = $this->db->query( " INSERT INTO  proposal_details SET ref_proposal_id = '".$proposal_id."', category_text = '".$data['proposal_note_content']."', content_type = '3', ref_user_id = '".$ref_user_id."', session_id = '".$_SESSION['session_id']."'");
		}
		return $this->db->insert_id();
	}
	
	
	
    function getItem($data){
		$query = $this->db->query( "SELECT sc.*,c.proposal_category_name FROM proposal_sub_category AS sc LEFT JOIN proposal_category AS c ON c.proposal_category_id = sc.proposal_category_id
		WHERE  sc.proposal_sub_category_id = '".$data['sub_category_id']."' AND sc.status_id = 1" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	
	function getTempProposalItems(){
		
		$ref_user_id = $this->session->userdata(SESSION_LOGIN . 'user_id');
		$query = $this->db->query( "SELECT * FROM proposal_details_temp  WHERE ref_user_id = '".$ref_user_id."' AND session_id = '".$_SESSION['session_id']."'" );
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	
	function updateStatus($id){
		$query = $this->db->query( " UPDATE  proposal SET proposal_status = '1' WHERE proposal_id = '".$id."'" );
		return $id;
	}

// Get website list based on client Category
	// $id - Client category id
	function getWebsite($id){
		$query = $this->db->query("SELECT cw.*,c.client_name FROM client AS c 
									JOIN client_website AS cw ON cw.ref_client_id = c.client_id
									WHERE c.ref_business_category_id = '".$id."' AND c.	delete_status = 0 AND c.transaction_id = 0");
        if ( $query->num_rows() >= 1 ) {
            return $query->result();
        } else {
            return false;
        }
	}
	
	function getLastProposalNumber()
    {
        $query = $this->db->query("SELECT proposal_no FROM proposal ORDER BY proposal_no DESC LIMIT 1");        
        if ($query->num_rows() >= 1) {
            $result = $query->result();
            $unique_no = $result[0]->proposal_no;
            if ($unique_no != '') {
                $unique_no = $unique_no + 1;
            }
            $unique_no_final = $unique_no;
        } else {
			$unique_no_final = '1';
        }
        return $unique_no_final;
    }
    
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Proposal_model.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation