protected function insertObject()
{
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__vc_paymentsessions"))->set($this->db->quoteName("user_id") . "=" . (int) $this->user_id)->set($this->db->quoteName("currency_id") . "=" . (int) $this->currency_id)->set($this->db->quoteName("amount") . "=" . $this->db->quote($this->amount));
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__crowdf_rewards"))->set($this->db->quoteName("title") . "=" . $this->db->quote($this->title))->set($this->db->quoteName("description") . "=" . $this->db->quote($this->description))->set($this->db->quoteName("amount") . "=" . $this->db->quote($this->amount))->set($this->db->quoteName("number") . "=" . (int) $this->number)->set($this->db->quoteName("distributed") . "=" . (int) $this->distributed)->set($this->db->quoteName("delivery") . "=" . $this->db->quote($this->delivery))->set($this->db->quoteName("shipping") . "=" . $this->db->quote($this->shipping))->set($this->db->quoteName("image") . "=" . $this->db->quote($this->image))->set($this->db->quoteName("image_thumb") . "=" . $this->db->quote($this->image_thumb))->set($this->db->quoteName("image_square") . "=" . $this->db->quote($this->image_square))->set($this->db->quoteName("published") . "=" . $this->db->quote($this->published))->set($this->db->quoteName("project_id") . "=" . (int) $this->project_id);
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$recordDate = !$this->record_date ? "NULL" : $this->db->quote($this->record_date);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__crowdf_payment_sessions"))->set($this->db->quoteName("user_id") . "=" . $this->db->quote($this->user_id))->set($this->db->quoteName("project_id") . "=" . $this->db->quote($this->project_id))->set($this->db->quoteName("reward_id") . "=" . $this->db->quote($this->reward_id))->set($this->db->quoteName("record_date") . "=" . $recordDate)->set($this->db->quoteName("txn_id") . "=" . $this->db->quote($this->txn_id))->set($this->db->quoteName("token") . "=" . $this->db->quote($this->token))->set($this->db->quoteName("gateway") . "=" . $this->db->quote($this->gateway))->set($this->db->quoteName("auser_id") . "=" . $this->db->quote($this->auser_id))->set($this->db->quoteName("intention_id") . "=" . $this->db->quote($this->intention_id));
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$created = !$this->created ? "NULL" : $this->db->quote($this->created);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__crowdf_projects"))->set($this->db->quoteName("title") . "=" . $this->db->quote($this->title))->set($this->db->quoteName("alias") . "=" . $this->db->quote($this->alias))->set($this->db->quoteName("short_desc") . "=" . $this->db->quote($this->short_desc))->set($this->db->quoteName("description") . "=" . $this->db->quote($this->description))->set($this->db->quoteName("image") . "=" . $this->db->quote($this->image))->set($this->db->quoteName("image_square") . "=" . $this->db->quote($this->image_square))->set($this->db->quoteName("image_small") . "=" . $this->db->quote($this->image_small))->set($this->db->quoteName("location") . "=" . $this->db->quote($this->location))->set($this->db->quoteName("goal") . "=" . $this->db->quote($this->goal))->set($this->db->quoteName("funded") . "=" . $this->db->quote($this->funded))->set($this->db->quoteName("funding_type") . "=" . $this->db->quote($this->funding_type))->set($this->db->quoteName("funding_start") . "=" . $this->db->quote($this->funding_start))->set($this->db->quoteName("funding_end") . "=" . $this->db->quote($this->funding_end))->set($this->db->quoteName("funding_days") . "=" . $this->db->quote($this->funding_days))->set($this->db->quoteName("pitch_video") . "=" . $this->db->quote($this->pitch_video))->set($this->db->quoteName("pitch_image") . "=" . $this->db->quote($this->pitch_image))->set($this->db->quoteName("hits") . "=" . (int) $this->hits)->set($this->db->quoteName("created") . "=" . $created)->set($this->db->quoteName("featured") . "=" . $this->db->quote($this->featured))->set($this->db->quoteName("published") . "=" . $this->db->quote($this->published))->set($this->db->quoteName("approved") . "=" . $this->db->quote($this->approved))->set($this->db->quoteName("ordering") . "=" . $this->db->quote($this->ordering))->set($this->db->quoteName("catid") . "=" . (int) $this->catid)->set($this->db->quoteName("type_id") . "=" . (int) $this->type_id)->set($this->db->quoteName("user_id") . "=" . (int) $this->user_id);
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$txnDate = !$this->txn_date ? "NULL" : $this->db->quote($this->txn_date);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__vc_transactions"))->set($this->db->quoteName("units") . "=" . $this->db->quote($this->units))->set($this->db->quoteName("txn_id") . "=" . $this->db->quote($this->txn_id))->set($this->db->quoteName("txn_amount") . "=" . $this->db->quote($this->txn_amount))->set($this->db->quoteName("txn_currency") . "=" . $this->db->quote($this->txn_currency))->set($this->db->quoteName("txn_status") . "=" . $this->db->quote($this->txn_status))->set($this->db->quoteName("txn_date") . "=" . $txnDate)->set($this->db->quoteName("service_provider") . "=" . $this->db->quote($this->service_provider))->set($this->db->quoteName("currency_id") . "=" . $this->db->quote($this->currency_id))->set($this->db->quoteName("sender_id") . "=" . $this->db->quote($this->sender_id))->set($this->db->quoteName("receiver_id") . "=" . $this->db->quote($this->receiver_id));
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$note = !$this->note ? "NULL" : $this->db->quote($this->note);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__vc_accounts"))->set($this->db->quoteName("amount") . "=" . $this->db->quote($this->amount))->set($this->db->quoteName("note") . "=" . $note)->set($this->db->quoteName("user_id") . "=" . (int) $this->user_id)->set($this->db->quoteName("currency_id") . "=" . (int) $this->currency_id);
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$description = !$this->description ? "NULL" : $this->db->quote($this->description);
$params = !$this->params ? "NULL" : $this->db->quote($this->params);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__vc_currencies"))->set($this->db->quoteName("title") . "=" . $this->db->quote($this->title))->set($this->db->quoteName("description") . "=" . $description)->set($this->db->quoteName("code") . "=" . (int) $this->code)->set($this->db->quoteName("symbol") . "=" . (int) $this->symbol)->set($this->db->quoteName("params") . "=" . $params);
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
// Prepare extra data value.
$extraData = !$this->extra_data ? "NULL" : $this->db->quote($this->extra_data);
$txnDate = !$this->txn_date ? "NULL" : $this->db->quote($this->txn_date);
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__crowdf_transactions"))->set($this->db->quoteName("txn_date") . "=" . $txnDate)->set($this->db->quoteName("txn_amount") . "=" . $this->db->quote($this->txn_amount))->set($this->db->quoteName("txn_currency") . "=" . $this->db->quote($this->txn_currency))->set($this->db->quoteName("txn_status") . "=" . $this->db->quote($this->txn_status))->set($this->db->quoteName("txn_id") . "=" . $this->db->quote($this->txn_id))->set($this->db->quoteName("parent_txn_id") . "=" . $this->db->quote($this->parent_txn_id))->set($this->db->quoteName("extra_data") . "=" . $extraData)->set($this->db->quoteName("status_reason") . "=" . $this->db->quote($this->status_reason))->set($this->db->quoteName("project_id") . "=" . $this->db->quote($this->project_id))->set($this->db->quoteName("reward_id") . "=" . $this->db->quote($this->reward_id))->set($this->db->quoteName("investor_id") . "=" . $this->db->quote($this->investor_id))->set($this->db->quoteName("receiver_id") . "=" . $this->db->quote($this->receiver_id))->set($this->db->quoteName("service_provider") . "=" . $this->db->quote($this->service_provider))->set($this->db->quoteName("reward_state") . "=" . $this->db->quote($this->reward_state));
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
/**
* Store information about activity.
*
* <code>
* $userId = 1;
* $content = "...";
*
* $activity = new Prism\Integration\Activity\JomSocial($userId, $content);
* $activity->setDb(JFactory::getDbo());
* $activity->store();
* </code>
*
* @throws \RuntimeException
*/
public function store()
{
if (!$this->app) {
throw new \RuntimeException(\JText::_('LIB_PRISM_ERROR_INVALID_JOMSOCIAL_APP'));
}
$query = $this->db->getQuery(true);
$date = new \JDate();
$query->insert($this->db->quoteName('#__community_activities'))->set($this->db->quoteName('actor') . '=' . (int) $this->actorId)->set($this->db->quoteName('content') . '=' . $this->db->quote($this->content))->set($this->db->quoteName('archived') . '=' . $this->db->quote($this->archived))->set($this->db->quoteName('app') . '=' . $this->db->quote($this->app))->set($this->db->quoteName('created') . '=' . $this->db->quote($date->toSql()));
$this->db->setQuery($query);
$this->db->execute();
// Get the ID of the record.
$this->id = $this->db->insertid();
}
/**
* Store information about activity.
*
* <code>
* $userId = 1;
* $content = "...";
*
* $activity = new ITPrismIntegrateActivityJomSocial($userId, $content);
* $activity->setDb(JFactory::getDbo());
* $activity->store();
* </code>
*
* @param string $content
*
* @throws Exception
*/
public function store($content = "")
{
if (!empty($content)) {
$this->content = $content;
}
if (!$this->app) {
throw new Exception(JText::_("LIB_ITPRISM_ERROR_INVALID_JOMSOCIAL_APP"));
}
$query = $this->db->getQuery(true);
$date = new JDate();
$query->insert("#__community_activities")->set($this->db->quoteName("actor") . "=" . (int) $this->actorId)->set($this->db->quoteName("content") . "=" . $this->db->quote($this->content))->set($this->db->quoteName("archived") . "=" . $this->db->quote($this->archived))->set($this->db->quoteName("app") . "=" . $this->db->quote($this->app))->set($this->db->quoteName("created") . "=" . $this->db->quote($date->toSql()));
$this->db->setQuery($query);
$this->db->execute();
// Get the ID of the record.
$this->id = $this->db->insertid();
}
/**
* Store a notification to database.
*
* <code>
* $userId = 1;
* $content = "....";
*
* $notification = new ITPrismIntegrateNotificationEasySocial($userId, $content);
* $notification->setDb(JFactory::getDbo());
*
* $notification->send();
* </code>
*
* @param string $content
*/
public function send($content = "")
{
if (!empty($content)) {
$this->content = $content;
}
$query = $this->db->getQuery(true);
$date = new JDate();
$query->insert($this->db->quoteName("#__social_notifications"))->set($this->db->quoteName("uid") . "=" . (int) $this->uid)->set($this->db->quoteName("actor_id") . "=" . (int) $this->actorId)->set($this->db->quoteName("actor_type") . "=" . $this->db->quote($this->actorType))->set($this->db->quoteName("target_id") . "=" . (int) $this->targetId)->set($this->db->quoteName("target_type") . "=" . $this->db->quote($this->targetType))->set($this->db->quoteName("content") . "=" . $this->db->quote($this->content))->set($this->db->quoteName("cmd") . "=" . $this->db->quote($this->cmd))->set($this->db->quoteName("type") . "=" . $this->db->quote($this->type))->set($this->db->quoteName("url") . "=" . $this->db->quote($this->url))->set($this->db->quoteName("state") . "=" . (int) $this->state)->set($this->db->quoteName("created") . "=" . $this->db->quote($date->toSql()));
if (!empty($this->image)) {
$query->set($this->db->quoteName("image") . "=" . $this->db->quote($this->image));
}
if (!empty($this->title)) {
$query->set($this->db->quoteName("title") . "=" . $this->db->quote($this->title));
}
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
/**
* Store a notification to database.
*
* <code>
* $userId = 1;
* $content = "....";
*
* $notification = new Prism\Integration\Notification\EasySocial($userId, $content);
* $notification->setDb(JFactory::getDbo());
*
* $notification->send();
* </code>
*
* @param string $content
*/
public function send($content = '')
{
if (\JString::strlen($content) > 0) {
$this->content = $content;
}
$query = $this->db->getQuery(true);
$date = new \JDate();
$query->insert($this->db->quoteName('#__social_notifications'))->set($this->db->quoteName('uid') . '=' . (int) $this->uid)->set($this->db->quoteName('actor_id') . '=' . (int) $this->actorId)->set($this->db->quoteName('actor_type') . '=' . $this->db->quote($this->actorType))->set($this->db->quoteName('target_id') . '=' . (int) $this->targetId)->set($this->db->quoteName('target_type') . '=' . $this->db->quote($this->targetType))->set($this->db->quoteName('content') . '=' . $this->db->quote($this->content))->set($this->db->quoteName('cmd') . '=' . $this->db->quote($this->cmd))->set($this->db->quoteName('type') . '=' . $this->db->quote($this->type))->set($this->db->quoteName('url') . '=' . $this->db->quote($this->url))->set($this->db->quoteName('state') . '=' . (int) $this->state)->set($this->db->quoteName('created') . '=' . $this->db->quote($date->toSql()));
if ($this->image !== null) {
$query->set($this->db->quoteName('image') . '=' . $this->db->quote($this->image));
}
if ($this->title !== null) {
$query->set($this->db->quoteName('title') . '=' . $this->db->quote($this->title));
}
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
protected function insertObject()
{
$filename = !$this->filename ? "NULL" : $this->db->quote($this->filename);
$private = !$this->private ? "NULL" : $this->db->quote($this->private);
$public = !$this->public ? "NULL" : $this->db->quote($this->public);
$note = !$this->note ? "NULL" : $this->db->quote($this->note);
if (!$this->meta_data) {
$metaData = "NULL";
} else {
if (is_array($this->meta_data)) {
$metaData = json_encode($this->meta_data);
$metaData = $this->db->quote($metaData);
} else {
$metaData = $this->db->quote($this->meta_data);
}
}
$query = $this->db->getQuery(true);
$query->insert($this->db->quoteName("#__identityproof_files"))->set($this->db->quoteName("title") . "=" . $this->db->quote($this->title))->set($this->db->quoteName("filename") . "=" . $filename)->set($this->db->quoteName("private") . "=" . $private)->set($this->db->quoteName("public") . "=" . $public)->set($this->db->quoteName("meta_data") . "=" . $metaData)->set($this->db->quoteName("state") . "=" . $this->db->quote($this->state))->set($this->db->quoteName("note") . "=" . $note)->set($this->db->quoteName("user_id") . "=" . (int) $this->user_id);
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
/**
* Store a notification to database.
*
* <code>
* $userId = 1;
* $content = "....";
*
* $notification = new ITPrismIntegrateNotificationJomSocial($userId, $content);
* $notification->setDb(JFactory::getDbo());
*
* $notification->send();
* </code>
*
* @param string $content
*/
public function send($content = "")
{
if (!empty($content)) {
$this->content = $content;
}
$query = $this->db->getQuery(true);
if (!empty($this->image)) {
$params["image"] = $this->image;
}
if (!empty($this->url)) {
$params["url"] = $this->url;
}
$date = new JDate();
$query->insert($this->db->quoteName("#__community_notifications"))->set($this->db->quoteName("actor") . "=" . (int) $this->actorId)->set($this->db->quoteName("target") . "=" . (int) $this->targetId)->set($this->db->quoteName("content") . "=" . $this->db->quote($this->content))->set($this->db->quoteName("cmd_type") . "=" . $this->db->quote($this->cmdType))->set($this->db->quoteName("type") . "=" . $this->db->quote($this->type))->set($this->db->quoteName("status") . "=" . (int) $this->status)->set($this->db->quoteName("created") . "=" . $this->db->quote($date->toSql()));
if (!empty($params)) {
$params = json_encode($params);
$query->set($this->db->quoteName("params") . "=" . $this->db->quote($params));
}
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
/**
* Store a notification to database.
*
* <code>
* $userId = 1;
* $content = "....";
*
* $notification = new Prism\Integration\Notification\JomSocial($userId, $content);
* $notification->setDb(\JFactory::getDbo());
*
* $notification->send();
* </code>
*
* @param string $content
*/
public function send($content = '')
{
if (\JString::strlen($content) > 0) {
$this->content = $content;
}
$query = $this->db->getQuery(true);
$params = array();
if ($this->image !== null) {
$params['image'] = $this->image;
}
if ($this->url !== null) {
$params['url'] = $this->url;
}
$date = new \JDate();
$query->insert($this->db->quoteName('#__community_notifications'))->set($this->db->quoteName('actor') . '=' . (int) $this->actorId)->set($this->db->quoteName('target') . '=' . (int) $this->targetId)->set($this->db->quoteName('content') . '=' . $this->db->quote($this->content))->set($this->db->quoteName('cmd_type') . '=' . $this->db->quote($this->cmdType))->set($this->db->quoteName('type') . '=' . $this->db->quote($this->type))->set($this->db->quoteName('status') . '=' . (int) $this->status)->set($this->db->quoteName('created') . '=' . $this->db->quote($date->toSql()));
if (count($params) > 0) {
$params = json_encode($params);
$query->set($this->db->quoteName('params') . '=' . $this->db->quote($params));
}
$this->db->setQuery($query);
$this->db->execute();
$this->id = $this->db->insertid();
}
/**
* Returns the insert_id() from Mysql
*
* @return int
*/
public function insertid()
{
return $this->_db->insertid();
}
