/** * Fetches specified message * * @param number $id * @return \GitGis\Whatsapp\Model\Message> */ public function fetch($id) { $db = DBConnection::getInstance(); $item = null; if (empty($id)) { return new Message(); } $query = $db->prepare("SELECT * FROM messages WHERE id=:id "); $query->bindParam('id', $id); $query->execute(); $row = $query->fetch(); if (!empty($row)) { $item = new Message(); $item->setId($row['id']); $item->setGroupId($row['group_id']); $item->setSenderId($row['sender_id']); $item->setUserId($row['user_id']); $item->setkind($row['kind']); $item->setTarget($row['target']); $item->setData($row['data']); $item->setCtime($row['ctime']); $item->setStime($row['stime']); } return $item; }
<?php require_once __DIR__ . '/../vendor/autoload.php'; define("MAINDIR", __DIR__ . '/../'); require_once __DIR__ . '/../config.php'; use GitGis\Whatsapp\Model\Message; use GitGis\Whatsapp\Model\MessageDAO; use GitGis\Whatsapp\Model\Group; use GitGis\Whatsapp\Model\GroupDAO; use GitGis\Whatsapp\Model\WhatsappDAO; $groupDao = new GroupDAO(); $group = $groupDao->fetch(1); $messageDao = new MessageDAO(); for ($cnt = 0; $cnt < 200; $cnt++) { $message = new Message(); $message->setKind(Message::KIND_TEXT_MSG); $message->setCtime(time()); $message->setUserId(1); $message->setData('Test ' . $cnt); $message->setStime(time()); $message->setGroupId($group->getId()); $message = $messageDao->save($message); $messageDao->addStatus($message, Message::MESSAGE_STATUS_TO_SEND); }
/** * Creates video message and redirects to edit */ public static function getSendVideo() { $app = \Slim\Slim::getInstance(); $dao = new MessageDAO(); $item = new Message(); $item->setKind(Message::KIND_VIDEO_MSG); $item->setCtime(time()); $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $item->setUserId($user['id']); $item = $dao->save($item); $app->redirect(MAINURL . '/messages/edit/' . $item->getId()); }