GalleryModel.php 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. <?php namespace App\Models;
  2. use CodeIgniter\Database\ConnectionInterface;
  3. use CodeIgniter\Model;
  4. class GalleryModel extends Model
  5. {
  6. protected $table = 'gallery';
  7. protected $primaryKey = 'Id';
  8. protected $allowedFields = ['image','imageTitle','slug'];
  9. protected $limit;
  10. protected $offset;
  11. protected $Id;
  12. protected $imageTitle;
  13. protected $slug;
  14. protected $category;
  15. protected $info;
  16. protected $db;
  17. public function getIt($Id)
  18. {
  19. return $this->asArray()
  20. ->where(['Id' => $Id])
  21. ->first();
  22. }
  23. public function isEmptyGallery()
  24. {
  25. $db = \Config\Database::connect();
  26. $query = $db->query("SELECT COUNT(*) FROM gallery ");
  27. $count = $query->getRowArray();
  28. return $count;
  29. }
  30. public function getAllDo2()
  31. {
  32. $db = \Config\Database::connect();
  33. $query = $db->query("SELECT * FROM gallery ");
  34. return $query->getResult('array');
  35. }
  36. public function getAllDo()
  37. {
  38. $db = \Config\Database::connect();
  39. $query = $this->db->query("SELECT * FROM gallery ");
  40. $result= $query->getResultObject();
  41. return $result;
  42. }
  43. public function getAll()
  44. {
  45. $this->db = \Config\Database::connect();
  46. return $this->findAll();
  47. //return $this->orderBy('Id', 'desc')->Res();
  48. }
  49. public function count()
  50. {
  51. return $this->db->countAll();
  52. }
  53. public function getOneToDel($id)
  54. {
  55. return $this->find($id);
  56. // return $this->asArray()
  57. // ->where(['Id'=>$id]);
  58. }
  59. public function getOneToDel2($id)
  60. {
  61. $db = \Config\Database::connect();
  62. $query = $db->query("SELECT * FROM gallery where Id =$id ");
  63. $result = $query->getRowArray();
  64. return $result;
  65. }
  66. public function delOneGallery($Id)
  67. {
  68. $builder = $this->db->table('gallery');
  69. $builder->where('Id', $Id);
  70. $logic= $builder->delete();
  71. return $logic;
  72. }
  73. public function insertGallery($image,$imageTitle,$slug)
  74. {
  75. $query = $this->db->query("SELECT * FROM gallery ");
  76. $query= $this->db->query("INSERT into gallery (image,imageTitle,slug) values('$image','$imageTitle','$slug')");
  77. }
  78. public function deleteOne($id)
  79. {
  80. $this->where('Id',$id )->delete();
  81. //need to get name image associated with blog and unlink it
  82. return True;
  83. }
  84. public function isEmptyLadies()
  85. {
  86. $db = \Config\Database::connect("default");
  87. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Ladies' ");
  88. $count = $query->getRowArray();
  89. return $count;
  90. }
  91. public function isEmptyMens()
  92. {
  93. $db = \Config\Database::connect("default");
  94. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Mens' ");
  95. $count = $query->getRowArray();
  96. return $count;
  97. }
  98. public function isEmptyBoys()
  99. {
  100. $db = \Config\Database::connect("default");
  101. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Boys' ");
  102. $count = $query->getRowArray();
  103. return $count;
  104. }
  105. public function isEmptyGirls()
  106. {
  107. $db = \Config\Database::connect("default");
  108. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Girls' ");
  109. $count = $query->getRowArray();
  110. return $count;
  111. }
  112. public function isEmptyBaby()
  113. {
  114. $db = \Config\Database::connect("default");
  115. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Baby' ");
  116. $count = $query->getRowArray();
  117. return $count;
  118. }
  119. public function isEmptyAccessory()
  120. {
  121. $db = \Config\Database::connect("default");
  122. $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Accessory' ");
  123. $count = $query->getRowArray();
  124. return $count;
  125. }
  126. public function mens()
  127. {
  128. return $this->where('category', 'Mens')
  129. ->findAll();
  130. }
  131. }