EVOLUTION-NINJA

Edit File: 1506599064accounts.txt

--------------------------------------------------------replace controllers----------------------------------------------------------------------------
 public function add_quotations()
    {
    	$quo_date                 = $this->input->post('quo_date');
    	$amount                   = $this->input->post('amount');
    	$description              = $this->input->post('description');
    	$lead_id                  = $this->input->post('lead_id');
    
    
    	$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
    	$created_at = $date->format('Y-m-d');
    
    	$quotation_details  = array(
    			'lead_id'           => $lead_id,
    			'quo_date'          => date('Y-m-d',strtotime($quo_date)),
    			'amount'   	        => $amount,
    			'description'   	=> $description,
    			'delete_status'     => 'ACTIVE',
    			'created_at'        => $created_at
    	);
    
//     	print_r($quotation_details);
//     	die();
    
    	$result = $this->yaskawa_model->add_new_quotations($quotation_details);
    
    	if($result)
    	{
    		echo json_encode(array('result'=>1,'message'=>"Notes added successfully"));
    	}
    	else
    	{
    		echo json_encode(array('result'=>0,'message'=>"Something went wrong.. try again"));
    	}
    }
-------------------------------------------------------------------------------------------------------------------------------------------------------
// update_quotation
        public function update_quotation()
        {
        	$quo_date            = $this->input->post('quo_date');
        	$invoice_num         = $this->input->post('invoice_num');
        	$invoice_date        = $this->input->post('invoice_date');
        	$invoice_amount      = $this->input->post('invoice_amount');
        	$description         = $this->input->post('description');
        	$lead_id             = $this->input->post('lead_id');
        	$quotation_id        = $this->input->post('quoteid');
        	// print_r($quotation_id);
        	// die();
        	$date       = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
        	$updated_at = $date->format('Y-m-d H:i:s');
        
        	$quotation_details  = array(
        			'lead_id'           => $lead_id,
        			'invoice_num'       => $invoice_num,
        			'invoice_date'     	=> date('Y-m-d', strtotime($invoice_date)),
        			'invoice_amount'    => $invoice_amount,
        			'description'       => $description,
        			'delete_status'     => 'ACTIVE',
        			'convert_status'	=>'CONVERTED',
        			'updated_at'        => $updated_at
        	);
//         print_r($quotation_details);
//         die();
        
        $result = $this->yaskawa_model->update_quotation($quotation_id,$lead_id,$quotation_details);
        
        	if($this->db->affected_rows() > 0)
        	{
        		echo json_encode(array('result'=>1,'message'=>"Updated successfully"));
        	}
        	else
        	{
        		echo json_encode(array('result'=>0,'message'=>"Failed to update. Try again"));
        	}
        }
--------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------replace model---------------------------------------------------------
 public function update_quotation($quotation_id,$lead_id,$quotation_details)
    {
    	$this->db->select('*');
    	$this->db->from('leads');
    	$this->db->join('quotations','leads.lead_id=quotations.lead_id');
    	$this->db->where('quotations.quotation_id',$quotation_id);
    	$this->db->where('quotations.delete_status','ACTIVE');
    	$this->db->update('quotations',$quotation_details);
    }
---------------------------------------------------------------------------------------------------------------------------------------------------