Model_whlabel_stockup.php 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2. class Model_Whlabel_stockup extends Lin_Model
  3. {
  4. function __construct(){
  5. parent::__construct();
  6. $this->load->database();
  7. $this->table = 'whlabel_stockup';
  8. $this->load_table('whlabel_stockup');
  9. }
  10. public function get_supplier($supplier)
  11. {
  12. return $this->find("supplier = '$supplier'");
  13. }
  14. public function get_sku($sku)
  15. {
  16. return $this->find("sku = '$sku'");
  17. }
  18. public function get_cpid($cpid)
  19. {
  20. return $this->find("cpid = '$cpid'");
  21. }
  22. public function get_features($features)
  23. {
  24. return $this->find("features = '$features'");
  25. }
  26. public function get_warehousesku($warehouse,$sku)
  27. {
  28. return $this->find("warehouse = '$warehouse' and sku = '$sku'");
  29. }
  30. public function get_enter($enter)
  31. {
  32. return $this->find("enter = '$enter'");
  33. }
  34. public function get_number($number)
  35. {
  36. return $this->find("number = '$number'");
  37. }
  38. public function get_cxzd($number,$zd)
  39. {
  40. return $this->find("number = '$number' and zd = '$zd'");
  41. }
  42. public function get_numberout($number,$warehouse)
  43. {
  44. return $this->find("state = '0' and number = '$number' and warehouse = '$warehouse'");
  45. }
  46. public function get_labelnumberout($shop,$number,$warehouse)
  47. {
  48. return $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and zd = ''");
  49. }
  50. public function get_labelnumberout_purchase($shop,$number,$warehouse,$purchase)
  51. {
  52. return $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and purchase = '$purchase' and zd = ''");
  53. }
  54. public function get_labelnumberout_purchase_nopur($shop,$number,$warehouse)
  55. {
  56. return $this->find("state = '0' and shop = '$shop' and number = '$number' and warehouse = '$warehouse' and zd = ''");
  57. }
  58. public function get_numberret($number,$warehouse,$orderinfo,$waybill)
  59. {
  60. return $this->find("state = 1 and number = '$number' and warehouse = '$warehouse' and orderinfo = '$orderinfo' and waybill = '$waybill'");
  61. }
  62. public function get_label($label)
  63. {
  64. return $this->find("label = '$label'");
  65. }
  66. public function get_title($title)
  67. {
  68. return $this->find("title like '%$title%'");
  69. }
  70. } //end class