<?php

class Mapplication extends CI_Model {
    
	function __construct(){
        parent::__construct();
    }
	
	function selectQuery($query) {
		return $this->db->query($query);
	}
	
	function get_application_payment_info($condn = null)
	{
		$this->db->select('payment_info.*, application.*, industrial_park_master.park_name');
		$this->db->from('payment_info');
		$this->db->join('application', 'payment_info.application_id = application.application_id', 'LEFT');
		$this->db->join('industrial_park_master', 'application.industrial_park_id = industrial_park_master.industrial_park_id', 'LEFT');
		foreach ($condn as $key => $value)
			$this->db->where($key, $value);
		$this->db->order_by('payment_id','DESC');
        $query=$this->db->get();
        //echo nl2br($this->db->last_query());die;
        return $query->row_array();
	}
	
	function update_application_to_failed($order_id) {
		$sql = "INSERT INTO payment_info_failed SELECT * FROM payment_info WHERE order_id = '".$order_id."' ";
		$rs = $this->db->query($sql);
		if($rs){
			$sql_del = "DELETE FROM payment_info WHERE order_id = '".$order_id."' ";
			$rs_del = $this->db->query($sql_del);
			
			$sql_insrt = "INSERT INTO application_failed SELECT * FROM application WHERE order_id = '".$order_id."' ";
			$rs_insrt = $this->db->query($sql_insrt);
			
			if($rs_insrt){
				$sql_app = "DELETE FROM application WHERE order_id = '".$order_id."' ";
				$rs_app_del = $this->db->query($sql_app);
			}
		}
	}
	
}