| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 | 
							- <?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
 
 
  |