<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); 
class Model_Whlabellabel extends Lin_Model 
{
	function __construct(){
	parent::__construct();
	$this->load->database();
	$this->table = 'whlabellabel';
    $this->load_table('whlabellabel');
}
	public function get_labelnws($number,$warehouse,$shop)
	{
		return  $this->find("number = '$number' and warehouse = '$warehouse' and shop = '$shop'");	
	}
	public function get_label($label)
	{
		return  $this->find("label = '$label'");	
	}
	public function get_sku($sku)
	{
		return  $this->find("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_numberout($number,$warehouse)
	{
		return  $this->find("state = '0' and number = '$number' and warehouse = '$warehouse'");	
	}
	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_title($title)
	{
		return  $this->find("title like '%$title%'");	
	}
}  //end class