<?php
class M_form extends CI_Model{
 	
	function insertcustomer($data)
	{
		$this->db->insert('customer',$data);
		return $this->db->insert_id();
	}
	
	function insertvisit($data)
	{
		$this->db->insert('visit',$data);
		return $this->db->insert_id();
	}
	
	function insertvehicle($data)
	{
		$this->db->insert('customer_vehicle',$data);
		return $this->db->affected_rows();
	}
	
	function insertrecommended($data)
	{
		$this->db->insert('recommendation',$data);
		return $this->db->affected_rows();
	}
	
	function insertpurchase($data)
	{
		$this->db->insert('purchase',$data);
		return $this->db->affected_rows();
	}
	
	function getFormSaved()
	{
		$query=$this->db->query("SELECT * FROM  `visit` WHERE  `isApprove` =  '1' ORDER BY id DESC");
        return $query->result();
	}
	
	function getFormPending()
	{
		$query=$this->db->query("SELECT * FROM  `visit` WHERE  `isApprove` =  '0' ORDER BY id DESC");
        return $query->result();
	}
	
	function getVisit($id)
	{
		$q="SELECT * FROM  visit WHERE id='$id'";
        $query=$this->db->query($q);
        return $query->row();
	}
	
	function getCust($id)
	{
		$sql="SELECT * FROM  customer WHERE id = (SELECT id_customer FROM visit WHERE id='$id')";
		$query=$this->db->query($sql);
        return $query->row();
	}
	
	function getVehicle($id)
	{
		$sql="SELECT * FROM  customer_vehicle WHERE id_visit='$id'";
        //$query=$this->db->query($q);
		$sql = mysql_query($sql);
		while ($array = mysql_fetch_assoc($sql)) {
    		$rs[] = $array;
		}
		if (empty($rs))
		{
			$rs = '';
		} 
		return $rs;
        //return $query->row();
	}
	
	function getPurchase($id)
	{
		$sql="SELECT * FROM  purchase WHERE id_visit='$id'";
        //$query=$this->db->query($q);
		$sql = mysql_query($sql);
		while ($array = mysql_fetch_assoc($sql)) {
    		$rs[] = $array;
		}
		if (empty($rs))
		{
			$rs = '';
		} 
		return $rs;
        //return $query->row();
	}
	
	function getRecommendation($id)
	{
		$sql="SELECT * FROM  recommendation WHERE id_visit='$id'";
        //$query=$this->db->query($q);
		$sql = mysql_query($sql);
		while ($array = mysql_fetch_assoc($sql)) {
    		$rs[] = $array;
		}
		if (empty($rs))
		{
			$rs = '';
		} 
		return $rs;
        //return $query->row();
	}
	
	function getPictures($id)
	{
		$sql="SELECT * FROM pictures WHERE id_visit='$id'";
        //$query=$this->db->query($q);
		$sql = mysql_query($sql);
		while ($array = mysql_fetch_assoc($sql)) {
    		$rs[] = $array;
		}
		if (empty($rs))
		{
			$rs = '';
		} 
		return $rs;
	}
	
	function isApprove($data, $id)
	{
		
		$idc = $this->getCustomer($id);
		$this->updateCustomer($idc['id_customer'],$data['id_customer']);
		$this->db->where('id', $id);
		$this->db->update('visit', $data);
	}
	
	function getCustomer($id)
	{
		$sql="SELECT id_customer FROM  visit WHERE id='$id'";
		$sql = mysql_query($sql);
		//echo $sql;
		$rs = mysql_fetch_assoc($sql);
		return $rs;
	}
	
	function updateCustomer($idc,$id)
	{
		$data = array (
			'id_customer'	=> $id
		);
		$this->db->where('id', $idc);
		$this->db->update('customer', $data);
	}
	
	function searchcustomer($clue)
	{
		$sql="SELECT id,nama FROM  customer WHERE nama like '%$clue%'";
        //$query=$this->db->query($q);
		$sql = mysql_query($sql);
		while ($array = mysql_fetch_assoc($sql)) {
    		$rs[] = $array;
		}
		if (empty($rs))
		{
			$rs = '';
		} 
		return $rs;
	}
	
	function newUser($data)
	{
		$this->db->insert('user',$data);
		return $this->db->affected_rows();
	}
	
	function getUser()
	{
		$query=$this->db->query("SELECT * FROM  `user`");
        return $query->result();
	}
	
	function delete_user($id)
    {
        $query=$this->db->query("DELETE FROM user WHERE username='$id'");
    }
    
	function getSellout()
	{
		$query=$this->db->query("SELECT * FROM  `sellingout`");
        return $query->result();
	}
	
	function newSellout($data)
	{
		$this->db->insert('sellingout',$data);
		return $this->db->affected_rows();
	}
	
	function getVolume()
	{
		$query=$this->db->query("SELECT * FROM  `volume`");
        return $query->result();
	}
	
	function newVolume($data)
	{
		$this->db->insert('volume',$data);
		return $this->db->affected_rows();
	}

	function getWilayah()
	{
		$query=$this->db->query("SELECT * FROM  `wilayah`");
        return $query->result();
	}
}