public function formatSocialMediaEnt(InstagramEntity $ent) { $socMedEnt = new SocialMediaEntity(); $socMedEnt->setUsername($ent->getUsername())->setDateCreated(date("Y-m-d H:i:s"))->setBlvdId($ent->getBlvdId())->setLink($ent->getLink())->setMediaHeight(150)->setMediaWidth(150)->setText($ent->getCaption())->setSource('instagram')->setSocialId($ent->getId())->setMediaUrl($ent->getImage()); return $socMedEnt; }
public function updateBlvdWithSocialMediaDatetime(SocialMediaEntity $socEnt) { $update = $this->sql->update(); $update->set(array('last_social_media_datetime' => $socEnt->getDateCreated()))->where(array("id" => $socEnt->getBlvdId()))->where->lessThan("last_social_media_datetime", $socEnt->getDateCreated()); $statement = $this->sql->prepareStatementForSqlObject($update); $result = $statement->execute(); //echo "<br><br>".$update->getSqlString($this->dbAdapter->getPlatform()); if (!$result) { return false; } }
public function insertSocialMedia(SocialMediaEntity $socMedEnt) { $select = $this->sql->select(); $select->where(array("username" => $socMedEnt->getUsername(), "social_id" => $socMedEnt->getSocialId())); $result = $this->hydrateResult(new SocialMediaEntity(), $select); if ($result->count() == 0) { $hydrator = new ClassMethods(); $data = $hydrator->extract($socMedEnt); $action = $this->sql->insert(); $action->values($data); $statement = $this->sql->prepareStatementForSqlObject($action); // echo "<hr>"; echo $action->getSqlString($this->dbAdapter->getPlatform()); echo "<hr>asdf"; $statement->execute(); $sql = new Sql($this->dbAdapter); $sql->setTable('blvd'); $update = $sql->update(); $update->set(array("last_social_media_datetime" => $data['date_created']))->where(array("id" => $socMedEnt->getBlvdId())); $statement = $sql->prepareStatementForSqlObject($update); $r = $statement->execute(); echo $action->getSqlString($this->dbAdapter->getPlatform()); } elseif (false) { $hydrator = new ClassMethods(); $data = $hydrator->extract($socMedEnt); $update = $this->sql->update(); $update->set(array("date_created" => $data['date_created']))->where(array("username" => $socMedEnt->getUsername(), "social_id" => $socMedEnt->getSocialId())); $statement = $this->sql->prepareStatementForSqlObject($update); $r = $statement->execute(); //echo "<hr>"; echo $update->getSqlString($this->dbAdapter->getPlatform()); echo "<hr>asdf"; return $r; } return false; }
public function getMediaWidth() { return $this->utilObj->getSmallMediaWidth(parent::getMediaWidth(), parent::getMediaHeight()); }