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
|