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/invoice/controllers

Free Space:

3.37 TB

🔧 Quick Actions

✏️ Editing: Ajax (copy).php

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Ajax extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model( 
			array( 
				'invoice_model',
				'dashboard/Dashboard_model'
			) 
		);
    }
    
    function getProposalSubcategory(){
		$category_id = $_REQUEST['category_id'];
		$res_sub_category = $this->Common_model->getDetails('proposal_sub_category','proposal_category_id',$category_id);
		$json = array();
		foreach($res_sub_category as $key => $val){
			$json[] = array(
				'sub_category_id' => $val->proposal_sub_category_id,
				'description'	  => $val->proposal_sub_category_name
			);
		}
		echo json_encode($json);
		exit;
	}
	
	function getSacCodeCategory(){
		$sac_code_id = $_REQUEST['sac_code_id'];
		$res_sac_code_category = $this->Common_model->getDetails('sac_code_category','ref_sac_code_id',$sac_code_id);
		$json = array();
		foreach($res_sac_code_category as $key => $val){
			$json[] = array(
				'sac_code_category_id'		 => $val->sac_code_category_id,
				'sac_code_category_name'	 => $val->sac_code_category_name
			);
		}
		echo json_encode($json);
		exit;
	}
	
	function getSacCodeCategoryDetails(){
		$json = array();
		$res_item = array();
		$new_line_code = '&#13;&#10;'; 
		//~ echo '<pre>';
		//~ print_r($_REQUEST);
		//~ echo '</pre>';
		
		
		$res_sac_code_category = $this->Common_model->getDetails('sac_code_category','sac_code_category_id',$_REQUEST['sac_code_category']);
		
		$service_item_description = '';
		// Get Domain Details
		$res_domain_list = $this->Common_model->getDetails('domain_list','domain_list_id',$_REQUEST['domain_list_id']);
		if(isset($res_domain_list[0]->domain_list_no_of_emails) && !empty($res_domain_list[0]->domain_list_no_of_emails)){
			$email_id_count += $res_domain_list[0]->domain_list_no_of_emails;
		}
		
		$res_domain_email_list = $this->Common_model->getDetails('domain_email','ref_domain_list_id',$_REQUEST['domain_list_id']);
		
		//~ echo '<pre>';
		//~ print_r($res_domain_email_list);
		//~ echo '</pre>';
		//~ exit;
		
		$email_pro_rata_charges = '';
		if(isset($res_domain_email_list) && ($res_domain_email_list[0]->domain_email_count)){
			//$res_email_renewal_charge = $this->Dashboard_model->getEmailRenewalCharge($_REQUEST['renewal_type_id']);
			//$email_rate_per_month = 0;
			//$email_rate_per_month = $res_email_renewal_charge[0]->service_rate_name / 12;
			
			foreach($res_domain_email_list as $key => $val){
				$email_id_count += $val->domain_email_count;
				//~ $diff_month = $this->Common_model->CountMonthBetweenDates($val->domain_email_date,$res_domain_list[0]->domain_expiry_date);
				//~ 
				//~ $pro_rata_date_from = '01-'.date('M-Y',strtotime($val->domain_email_date));
				//~ $pro_rata_date_to = '31-March-'.date('Y',strtotime($val->domain_email_date));
				//~ $email_pro_rata_charges = '[ From '.$pro_rata_date_from.' To '.$pro_rata_date_to.' ]';
				//~ //echo '<br>';
				//~ 
				//~ $inv_temp_data['category_text'] = $res_sac_code_category[0]->sac_code_name;
				//~ $inv_temp_data['sub_category_text'] = 'Business Email Hosting PRO-RATA Charges'.$new_line_code.$email_pro_rata_charges;
				//~ $inv_temp_data['amount'] = $row_total;
				//~ $inv_temp_data['session_id'] = $_SESSION['unique_id'];
				//~ $this->Common_model->addRecord('invoice_details_temp',$inv_temp_data);
			}
		}
		//exit;
		
		
			
				
		// Get Renewal year
		$renewal_year = 0;
		$res_renewal_year = $this->Common_model->getDetails('renewal_type','renewal_type_id',$_REQUEST['renewal_type_id']);	
		if(isset($res_renewal_year) && !empty($res_renewal_year)){
			$renewal_year = $res_renewal_year[0]->renewal_year;
		}
		//echo $renewal_year;
		$item_total = 0;
		$row_total = 0;
		$sub_total = 0;
		$sgst_total = 0;
		$cgst_total = 0;
		$round_off_total = 0;
		$net_total = 0;
		$additional_text = '';
		$service_item_description = '';
		if($_REQUEST['service_id'] == 1){ // Domain
			$res_domain_renewal_charge = $this->Dashboard_model->getDomainRenewalCharge($_REQUEST['renewal_type_id'],$res_domain_list[0]->ref_domain_type_id);
			if(isset($res_domain_renewal_charge) && !empty($res_domain_renewal_charge)){
				$row_total = $res_domain_renewal_charge[0]->service_rate_name;
			}
		}
		if($_REQUEST['service_id'] == 2){ // Hosting
			
		}
		if($_REQUEST['service_id'] == 3){ // Email
			if($res_domain_list[0]->domain_email){
				$res_email_renewal_charge = $this->Dashboard_model->getEmailRenewalCharge($_REQUEST['renewal_type_id']);
				if(isset($res_email_renewal_charge) && !empty($res_email_renewal_charge)){
					$item_total = $res_email_renewal_charge[0]->service_rate_name;
					$row_total = $email_id_count * $res_email_renewal_charge[0]->service_rate_name;
				}
				$additional_text = ($email_id_count * 5).' GB for '.$email_id_count.' Email Id with 5 GB space per email id @Rs. '.$item_total;
			}
		}
			
		if($_REQUEST['type_id'] == 1){ // Registration
			
			$service_item_description = str_replace('{type}','Registration',$res_sac_code_category[0]->sac_code_category_name);
			$service_item_description .= ' for '.$res_renewal_year[0]->renewal_type_name;
			$service_item_description .= $new_line_code;
			$service_item_description .= '[ www.'.$res_domain_list[0]->domain_list_name.$res_domain_list[0]->domain_type_name.' ]'.$new_line_code;
			if(!empty($additional_text)){
				$service_item_description .= $additional_text.$new_line_code;
			}			
			$service_item_description .= '[ From '.date('d-M-Y',strtotime($res_domain_list[0]->domain_list_reg_date)).' To '.date('d-M-Y',strtotime($res_domain_list[0]->domain_expiry_date)).' ]';			
			
		}else{ // Renewals	
			$service_item_description = str_replace('{type}','Renewal',$res_sac_code_category[0]->sac_code_category_name);
			$service_item_description .= ' for '.$res_renewal_year[0]->renewal_type_name;
			$service_item_description .= $new_line_code;
			$service_item_description .= '[ www.'.$res_domain_list[0]->domain_list_name.$res_domain_list[0]->domain_type_name.' ]'.$new_line_code;
			if(!empty($additional_text)){
				$service_item_description .= $additional_text.$new_line_code;
			}
			
			$date_from = date('d-M-Y',strtotime("+1 day",strtotime($res_domain_list[0]->domain_expiry_date)));
			$date_to = date('d-M-Y',strtotime("+".$renewal_year." years",strtotime($res_domain_list[0]->domain_expiry_date)));
			$service_item_description .= '[ From '.$date_from.' To '.$date_to.' ]';
		}
		
		$inv_temp_data['category_text'] = $res_sac_code_category[0]->sac_code_name;
		$inv_temp_data['sub_category_text'] = $service_item_description;
		$inv_temp_data['amount'] = $row_total;
		$inv_temp_data['session_id'] = $_SESSION['unique_id'];
		$this->Common_model->addRecord('invoice_details_temp',$inv_temp_data);
		
		
		if($_REQUEST['service_id'] == 3){
			$email_pro_rata_charges = '';
			if(isset($res_domain_email_list) && ($res_domain_email_list[0]->domain_email_count)){
				$res_email_renewal_charge = $this->Dashboard_model->getEmailRenewalCharge($_REQUEST['renewal_type_id']);
				$email_rate_per_month = 0;
				$email_rate_per_month = $res_email_renewal_charge[0]->service_rate_name / 12;
				
				foreach($res_domain_email_list as $key => $val){
					$diff_month = $this->Common_model->CountMonthBetweenDates($val->domain_email_date,$res_domain_list[0]->domain_expiry_date);
					
					$pro_rata_date_from = '01-'.date('M-Y',strtotime($val->domain_email_date));
					$pro_rata_date_to = '31-March-'.date('Y',strtotime($val->domain_email_date));
					$email_pro_rata_charges = '[ From '.$pro_rata_date_from.' To '.$pro_rata_date_to.' ]';
					
					$email_pro_rata_charges .= $new_line_code.($val->domain_email_count * 5).' GB for '.$val->domain_email_count.' Email Id with 5 GB space per email id @Rs. '.$res_email_renewal_charge[0]->service_rate_name;
					
					$row_total = ($email_rate_per_month * $diff_month)*$val->domain_email_count;
					$inv_temp_data['category_text'] = $res_sac_code_category[0]->sac_code_name;
					$inv_temp_data['sub_category_text'] = 'Business Email Hosting PRO-RATA Charges'.$new_line_code.$email_pro_rata_charges;
					$inv_temp_data['amount'] = $row_total;
					$inv_temp_data['session_id'] = $_SESSION['unique_id'];
					$this->Common_model->addRecord('invoice_details_temp',$inv_temp_data);
				}
			}
		}
		
		
		
		$res_invoice_items = $this->Common_model->getDetails('invoice_details_temp','session_id',$_SESSION['unique_id'],'invoice_details_temp_id','ASC');
		$html = '';
		$i = 1;
		$sub_total = 0;
		if(isset($res_invoice_items) && !empty($res_invoice_items)){
			foreach($res_invoice_items as $key => $val){
				$html .= '<tr id="'.$i.'"><td align="center">'.$i.'</td>';
							
				$html .= '<td><div class="form-group"><div class="form-line"><input type="text" name="invoice_items['.$i.'][category]" class="form-control" value="'.$val->category_text.'" placeholder="Category"></div></div></td>';
				
				$html .= '<td><div class="form-group"><div class="form-line"><textarea  name="invoice_items['.$i.'][sub_category]"  id="sub_category_'.$i.'" class="form-control " placeholder="Sub Category" rows="4">'.$val->sub_category_text.'</textarea></div></div></td>';	
									
				$html .= '<td align="right" ><div class="form-group"><div class="form-line"><input type="text" name="invoice_items['.$i.'][amount]" value="'.$val->amount.'" class="form-control text-right"  placeholder="Amount" onkeypress="return isNumber(event);"></td>';
				
				$html .= '<td align="right"><a class="remove_invoice_item btn btn-danger" id="'.$val->invoice_details_temp_id.'"><i class="fa fa-trash-o"></i></a></td></tr>';
				$i++;
				$sub_total += $val->amount;
			}			
		}
		
		$sgst = ($sub_total * 9) / 100; 
		$cgst = ($sub_total * 9) / 100; 
		
		$rounded_val = 0;
		$rounded_val_final = '';
		$total_tax = $sgst + $cgst;
		$net_total = $sub_total + $sgst + $cgst;
		$net_total_final = round($net_total);
		$rounded_val = $net_total_final - $net_total; 
		if($rounded_val > 0)
			$rounded_val_final =  '(+)'.number_format((float)$rounded_val, 2, '.', '');
		else
			$rounded_val_final =  '(-)'.number_format((float)$rounded_val, 2, '.', '');			
			
		echo $html.'|||'.number_format($sub_total).'|||'.$sgst.'|||'.$cgst.'|||'.$total_tax.'|||'.$rounded_val_final.'|||'.number_format($net_total_final);
		//~ foreach($res_sac_code_category as $key => $val){
			//~ //$res_sac_code = $this->Common_model->getDetails('sac_code','sac_code_id',$val->ref_sac_code_id);
			//~ $json[] = array(
				//~ 'id' 			=> $val->sac_code_category_id,
				//~ 'category_id' 	=> $val->ref_sac_code_id,
				//~ 'sub_category_id'=> $val->sac_code_category_id,
				//~ 'category' 		=> $val->sac_code_name,
				//~ 'sub_category'	=> nl2br($service_item_description),
				//~ 'amount' 		=> number_format($row_total),
				//~ 'sort_order' 	=> '',
				//~ 'page'			=> '',
				//~ 'user_group_id' => $user_group_id
			//~ );       
		//~ }
		
		//echo json_encode($json);
		exit;
	}
	
	function deleteInvoiceItem(){
		$id = $_REQUEST['id'];
		$res = $this->Common_model->deleteRecord('invoice_details_temp','invoice_details_temp_id',$id);
		if($res){
			echo json_encode('true');
		}else{
			echo json_encode('false');
		}
		exit;
	}
	
	function getProposalItems(){
		$this->hasPermission( 'invoice_add' );
		//$data['category_id'] = $_REQUEST['category'];
		$data['sub_category_id'] = $_REQUEST['sub_category'];
		
		$json = array();

$res_item = $this->invoice_model->getItem($data);
			
		if(in_array('1',$this->session->userdata(SESSION_LOGIN .'user_group'))){
			$user_group_id = 1;
		}else{
			$user_group_id = 0;
		}
		if(!empty($res_item)){
			foreach($res_item as $key => $val){
				$json[] = array(
					'id' 			=> $val->proposal_sub_category_id,
					'category_id' 	=> $val->proposal_category_id,
					'sub_category_id'=> $val->proposal_sub_category_id,
					'category' 		=> $val->proposal_category_name,
					'sub_category'	=> $val->proposal_sub_category_name,
					'amount' 		=> $val->amount,
					'sort_order' 		=> $val->sort_order,
					'page'			=> $val->pages_or_years,
					'user_group_id' => $user_group_id
				);       
			}
		}
		echo json_encode($json);
		exit;
	}
	
	function getWebsite(){
		
		$res = $this->invoice_model->getWebsite($_POST['id']);
		echo json_encode($res);
		exit;
		
	}
	
	 function getInvoiceTemplate(){
		
		$res = $this->Common_model->getDetails('invoice_basic_type','invoice_basic_type_id',$_POST['invoice_tmp_type_id']);
		echo json_encode($res[0]->invoice_basic_type_content);
		exit;

}
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Ajax (copy).php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation