123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256 |
- <?php namespace App\Models;
- use CodeIgniter\Database\ConnectionInterface;
- use CodeIgniter\Model;
- class GalleryModel extends Model
- {
- protected $table = 'gallery';
- protected $primaryKey = 'Id';
- protected $allowedFields = ['image','imageTitle','slug'];
- protected $limit;
- protected $offset;
- protected $Id;
- protected $imageTitle;
- protected $slug;
- protected $category;
- protected $info;
- protected $db;
- public function getIt($Id)
- {
- return $this->asArray()
- ->where(['Id' => $Id])
- ->first();
- }
- public function isEmptyGallery()
-
- {
-
- $db = \Config\Database::connect();
-
- $query = $db->query("SELECT COUNT(*) FROM gallery ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function getAllDo2()
- {
- $db = \Config\Database::connect();
- $query = $db->query("SELECT * FROM gallery ");
- return $query->getResult('array');
- }
- public function getAllDo()
- {
- $db = \Config\Database::connect();
- $query = $this->db->query("SELECT * FROM gallery ");
- $result= $query->getResultObject();
- return $result;
- }
-
- public function getAll()
- {
- $this->db = \Config\Database::connect();
-
- return $this->findAll();
- //return $this->orderBy('Id', 'desc')->Res();
- }
-
-
- public function count()
- {
-
- return $this->db->countAll();
-
-
-
-
-
- }
- public function getOneToDel($id)
- {
-
- return $this->find($id);
-
- // return $this->asArray()
- // ->where(['Id'=>$id]);
-
- }
-
- public function getOneToDel2($id)
-
- {
- $db = \Config\Database::connect();
- $query = $db->query("SELECT * FROM gallery where Id =$id ");
- $result = $query->getRowArray();
- return $result;
- }
-
- public function delOneGallery($Id)
-
- {
- $builder = $this->db->table('gallery');
- $builder->where('Id', $Id);
- $logic= $builder->delete();
- return $logic;
- }
-
- public function insertGallery($image,$imageTitle,$slug)
- {
- $query = $this->db->query("SELECT * FROM gallery ");
-
- $query= $this->db->query("INSERT into gallery (image,imageTitle,slug) values('$image','$imageTitle','$slug')");
-
- }
- public function deleteOne($id)
- {
- $this->where('Id',$id )->delete();
- //need to get name image associated with blog and unlink it
-
- return True;
-
-
- }
-
-
- public function isEmptyLadies()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Ladies' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function isEmptyMens()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Mens' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function isEmptyBoys()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Boys' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function isEmptyGirls()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Girls' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function isEmptyBaby()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Baby' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function isEmptyAccessory()
-
- {
- $db = \Config\Database::connect("default");
- $query = $db->query("SELECT COUNT(*) FROM portfolio where category='Accessory' ");
- $count = $query->getRowArray();
- return $count;
-
- }
- public function mens()
- {
- return $this->where('category', 'Mens')
- ->findAll();
- }
- }
|