<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); 
class Model_Whlabel_stockup extends Lin_Model 
{
	function __construct(){
	parent::__construct();
	$this->load->database();
	$this->table = 'whlabel_stockup';
    $this->load_table('whlabel_stockup');
}
	public function get_supplier($supplier)
	{
		return  $this->find("supplier = '$supplier'");	
	}
	public function get_sku($sku)
	{
		return  $this->find("sku = '$sku'");	
	}
	public function get_cpid($cpid)
	{
		return  $this->find("cpid = '$cpid'");	
	}
	public function get_features($features)
	{
		return  $this->find("features = '$features'");	
	}
	public function get_warehousesku($warehouse,$sku)
	{
		return  $this->find("warehouse = '$warehouse' and sku = '$sku'");	
	}
	public function get_enter($enter)
	{
		return  $this->find("enter = '$enter'");	
	}
	public function get_number($number)
	{
		return  $this->find("number = '$number'");	
	}
	public function get_cxzd($number,$zd)
	{
		return  $this->find("number = '$number' and zd = '$zd'");	
	}
	public function get_numberout($number,$warehouse)
	{
		return  $this->find("state = '0' and number = '$number' and warehouse = '$warehouse'");	
	}
	public function get_labelnumberout($shop,$number,$warehouse)
	{
		return  $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and zd = ''");	
	}
	public function get_labelnumberout_purchase($shop,$number,$warehouse,$purchase)
	{
		return  $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and purchase = '$purchase' and zd = ''");	
	}
	public function get_labelnumberout_purchase_nopur($shop,$number,$warehouse)
	{
		return  $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and zd = ''");	
	}
	public function get_numberret($number,$warehouse,$orderinfo,$waybill)
	{
		return  $this->find("state = 1 and number = '$number' and warehouse = '$warehouse' and orderinfo = '$orderinfo' and waybill = '$waybill'");	
	}
	public function get_label($label)
	{
		return  $this->find("label = '$label'");	
	}
	public function get_title($title)
	{
		return  $this->find("title like '%$title%'");	
	}
}  //end class