PHP Collection::bindType方法代码示例

 public function getActiveBots()
 {
     $sql = "SELECT id, queue_id, job_id\n\t\t\t\tFROM bots\n\t\t\t\tWHERE oauth_token_id = ?\n\t\t\t\tAND status != 'retired'\n\t\t\t\tORDER BY name";
     $bots = new Collection($sql, array($this->id));
     $bots->bindType('id', 'Bot');
     $bots->bindType('queue_id', 'Queue');
     $bots->bindType('job_id', 'Job');
     return $bots;
 }

 public function pretty()
 {
     $this->assertAdmin();
     $this->setTitle("Latest Completed Jobs");
     $sql = "SELECT id, webcam_image_id FROM jobs WHERE webcam_image_id != 0 AND status = 'complete' ORDER BY finished_time DESC";
     $available = new Collection($sql);
     $available->bindType('id', 'Job');
     $available->bindType('webcam_image_id', 'StorageInterface');
     $this->set('jobs', $available->getRange(0, 24));
 }

 public static function byContentAndType($id, $type)
 {
     if (!array_key_exists($type, self::$types)) {
         $comments = Collection::none();
     } else {
         //look up the comments
         $sql = "SELECT id, user_id\n\t\t\t\tFROM comments\n\t\t\t\tWHERE content_id = ?\n\t\t\t\tAND content_type = ?\n\t\t\t\tORDER BY comment_date ASC\n\t\t\t";
         $comments = new Collection($sql, array($id, $type));
     }
     $comments->bindType('id', 'Comment');
     $comments->bindType('user_id', 'User');
     return $comments;
 }

 public static function byContentAndType($id, $type)
 {
     //some validation
     $id = (int) $id;
     if (!in_array($type, array('job', 'bot'))) {
         return new Comment();
     }
     //look up the comments
     $sql = "SELECT id, user_id\n\t\t\t\tFROM comments\n\t\t\t\tWHERE content_id = ?\n\t\t\t\tAND content_type = ?\n        \t\tORDER BY comment_date ASC\n\t\t\t";
     $comments = new Collection($sql, array($id, $type));
     $comments->bindType('id', 'Comment');
     $comments->bindType('user_id', 'User');
     return $comments;
 }

 public function getChildren()
 {
     $sql = "SELECT id\n\t\t    \tFROM s3_files\n\t\t    \tWHERE parent_id = ?\n\t\t    \tORDER BY id DESC";
     $children = new Collection($sql, array($this->id));
     $children->bindType('id', get_class($this));
     return $children;
 }

 public static function getStream(User $user)
 {
     $sql = "SELECT id\n\t\t\t\tFROM activities\n\t\t\t\tWHERE user_id = ?\n\t\t\t\tORDER BY id DESC\n\t\t\t";
     $stream = new Collection($sql, array($user->id));
     $stream->bindType('id', 'Activity');
     return $stream;
 }

 public function getSliceJobs()
 {
     $sql = "SELECT id\n        \t\tFROM slice_jobs\n        \t\tWHERE slice_config_id = ?\n        \t\tORDER BY id DESC";
     $sliceJobs = new Collection($sql, array($this->id));
     $sliceJobs->bindType('id', 'SliceJob');
     return $sliceJobs;
 }

 public static function getStream(User $user)
 {
     $sql = "SELECT activity, action_date\n\t\t\t\tFROM activities\n\t\t\t\tWHERE user_id = ?\n\t\t\t\tORDER BY id DESC\n\t\t\t";
     $stream = new Collection($sql, array($user->id));
     $stream->bindValue('activity');
     $stream->bindType('action_date', 'DateTime');
     $stream->bindData('user_link', $user->getLink());
     return $stream;
 }

 public static function getMine($all = false)
 {
     if (User::isLoggedIn()) {
         $sql = "SELECT id FROM notifications WHERE id > ? AND (to_user_id = ? or to_user_id IS NULL)";
         $data = array();
         if ($all === false) {
             $data[] = User::$me->get('last_notification');
         } else {
             $data[] = 0;
             // Get all of them
         }
         $data[] = User::$me->id;
         $notifications = new Collection($sql, $data);
         $notifications->bindType('id', 'Notification');
         return $notifications;
     } else {
         // Return empty collection
         return Collection::none();
     }
 }

 public function live()
 {
     $this->assertAdmin();
     $this->setTitle("Live Bots View");
     $sql = "SELECT id, queue_id, job_id FROM bots WHERE webcam_image_id != 0 AND last_seen > NOW() - 3600 ORDER BY last_seen DESC";
     $bots = new Collection($sql);
     $bots->bindType('id', 'Bot');
     $bots->bindType('queue_id', 'Queue');
     $bots->bindType('job_id', 'Job');
     $this->set('bots', $bots->getRange(0, 24));
     $this->set('dashboard_style', 'medium_thumbnails');
 }

 public function getErrorLog()
 {
     $sql = "SELECT id\n\t\t    \tFROM error_log\n\t\t    \tWHERE bot_id = ?\n\t\t    \tORDER BY error_date DESC";
     $logs = new Collection($sql, array($this->id));
     $logs->bindType('id', 'ErrorLog');
     return $logs;
 }

 public function getMyConfigs()
 {
     $sql = "SELECT id\n\t\t    \tFROM slice_configs\n\t\t    \tWHERE engine_id = ?\n\t\t      \tAND (user_id = ? OR id = ?)\n\t\t    \tORDER BY config_name";
     $configs = new Collection($sql, array($this->id, User::$me->id, $this->get('default_config_id')));
     $configs->bindType('id', 'SliceConfig');
     return $configs;
 }

 public static function getJobsRequiringAction()
 {
     $sql = "SELECT id, input_id, job_id\n\t\t    \tFROM slice_jobs\n\t\t    \tWHERE status = 'pending'\n\t\t    \tORDER BY finish_date ASC";
     $jobs = new Collection($sql);
     $jobs->bindType('id', 'SliceJob');
     $jobs->bindType('input_id', STORAGE_METHOD);
     $jobs->bindType('job_id', 'Job');
     return $jobs;
 }

 public function getApps()
 {
     $sql = "SELECT id\n\t\t\t\tFROM oauth_token\n\t\t\t\tWHERE consumer_id = ?\n\t\t\t\tAND user_id = ?";
     $apps = new Collection($sql, array($this->id, User::$me->id));
     $apps->bindType('id', 'OAuthToken');
     return $apps;
 }

 public function getMySliceConfigs()
 {
     $sql = "SELECT id, engine_id\n\t\t\t\tFROM slice_configs\n\t\t\t\tWHERE user_id = ?\n\t\t\t\tORDER BY engine_id DESC";
     $configs = new Collection($sql, array($this->id));
     $configs->bindType('id', 'SliceConfig');
     $configs->bindType('engine_id', 'SliceEngine');
     return $configs;
 }