/** * */ public function store($preventUpdate = false) { // Set date if none exist if ($preventUpdate != true) { $now = new JDate(); $this->created = $now->toMySQL(); $this->updated = $now->toMySQL(); } return parent::store(); }
function savePayment() { $orderid = JRequest::getVar('orderid'); $Itemid = JRequest::getVar('Itemid'); $order = JTable::getInstance('OrdersTable', 'JTheFactory'); if (!$order->load($orderid)) { $app = JFactory::getApplication(); $app->redirect('index.php?option=' . APP_EXTENSION . '&Itemid=' . $Itemid, JText::_("FACTORY_ORDER_DOES_NOT_EXIST")); return; } $paylog = JTable::getInstance('PaymentLogTable', 'JTheFactory'); $date = new JDate(); $paylog->date = $date->toMySQL(); $paylog->amount = $order->order_total; $paylog->currency = $order->order_currency; $paylog->refnumber = JRequest::getVar('customer_note'); $paylog->invoice = $orderid; $paylog->ipn_response = print_r($_REQUEST, true); $paylog->ipn_ip = $_SERVER['REMOTE_ADDR']; $paylog->status = 'manual_check'; $paylog->userid = $order->userid; $paylog->orderid = $order->id; $paylog->payment_method = $this->name; $paylog->store(); $order->paylogid = $paylog->id; $order->store(); }
function processIPN() { $model = JModel::getInstance('Gateways', 'JTheFactoryModel'); $params = $model->loadGatewayParams($this->name); $test_mode = $params->get('test_mode', 0); $x_login = $params->get('x_login', ''); $paylog = JTable::getInstance('PaymentLogTable', 'JTheFactory'); $date = new JDate(); $paylog->date = $date->toMySQL(); $paylog->amount = JRequest::getVar('x_amount'); $paylog->currency = ''; //JRequest::getVar(''); $paylog->refnumber = JRequest::getVar('x_trans_id'); $paylog->invoice = JRequest::getVar('x_invoice_num'); $paylog->ipn_response = print_r($_REQUEST, true); $paylog->ipn_ip = $_SERVER['REMOTE_ADDR']; $paylog->status = 'error'; $paylog->userid = null; $paylog->orderid = JRequest::getVar('x_invoice_num'); $paylog->payment_method = $this->name; $receiver_email = JRequest::getVar('receiver_email'); $payment_status = JRequest::getVar('x_2checked'); if ($payment_status == 'Y') { $paylog->status = 'ok'; } else { $paylog->status = 'error'; } $paylog->store(); return $paylog; }
public function store() { $now = new JDate(); // Always update the stream last updated time $this->updated = $now->toMySQL(); return parent::store(); }
function getList(&$params) { global $mainframe; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $userId = (int) $user->get('id'); $count = (int) $params->get('count', 5); $catid = trim($params->get('catid')); $secid = trim($params->get('secid')); $show_front = $params->get('show_front', 1); $aid = $user->get('aid', 0); $contentConfig =& JComponentHelper::getParams('com_content'); $access = !$contentConfig->get('shownoauth'); $nullDate = $db->getNullDate(); jimport('joomla.utilities.date'); $date = new JDate(); $now = $date->toMySQL(); $where = 'a.state = 1' . ' AND ( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )' . ' AND ( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'; // User Filter switch ($params->get('user_id')) { case 'by_me': $where .= ' AND (created_by = ' . (int) $userId . ' OR modified_by = ' . (int) $userId . ')'; break; case 'not_me': $where .= ' AND (created_by <> ' . (int) $userId . ' AND modified_by <> ' . (int) $userId . ')'; break; } // Ordering switch ($params->get('ordering')) { case 'm_dsc': $ordering = 'a.modified DESC, a.created DESC'; break; case 'c_dsc': default: $ordering = 'a.created DESC'; break; } if ($catid) { $ids = explode(',', $catid); JArrayHelper::toInteger($ids); $catCondition = ' AND (cc.id=' . implode(' OR cc.id=', $ids) . ')'; } if ($secid) { $ids = explode(',', $secid); JArrayHelper::toInteger($ids); $secCondition = ' AND (s.id=' . implode(' OR s.id=', $ids) . ')'; } // Content Items only $query = 'SELECT a.*, ' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ($show_front == '0' ? ' LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id' : '') . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE ' . $where . ' AND s.id > 0' . ($access ? ' AND a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid . ' AND s.access <= ' . (int) $aid : '') . ($catid ? $catCondition : '') . ($secid ? $secCondition : '') . ($show_front == '0' ? ' AND f.content_id IS NULL ' : '') . ' AND s.published = 1' . ' AND cc.published = 1' . ' ORDER BY ' . $ordering; $db->setQuery($query, 0, $count); $rows = $db->loadObjectList(); $i = 0; $lists = array(); foreach ($rows as $row) { $lists[$i]->link = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid)); $lists[$i]->text = htmlspecialchars($row->title); $i++; } return $lists; }
function apply() { JRequest::checkToken() or jexit('Invalid Token'); $applicant = JRequest::get('POST'); jimport('joomla.utilities.date'); $now = new JDate(); if ($applicant['job_id'] != 0) { $unsol_id = $applicant['id']; $applicant['id'] = false; $applicant['request_date'] = $now->toMySQL(); $record =& JTable::getInstance('Applicant', 'Table'); if (!$record->save($applicant)) { // uh oh failed to save JError::raiseError('500', JTable::getError()); } $unsol =& JTable::getInstance('Unsolicited', 'Table'); if (!$unsol->delete($unsol_id)) { // uh oh failed to delete JError::raiseError('500', JTable::getError()); } $this->extendApply($applicant); } else { $applicant['last_updated'] = $now->toMySQL(); $unsol_record =& JTable::getInstance('Unsolicited', 'Table'); if (!$unsol_record->save($applicant)) { // uh oh failed to save JError::raiseError('500', JTable::getError()); } $this->extendApply($applicant); } }
function __construct(&$_db) { parent::__construct('#__banner', 'bid', $_db); jimport('joomla.utilities.date'); $now = new JDate(); $this->set('date', $now->toMySQL()); }
function save($data) { $row =& JTable::getInstance('Articles', 'Table'); $id = $data['id']; if (!$id) { jimport('joomla.utilities.date'); $dateNow = new JDate(); $dateMySql = $dateNow->toMySQL(); $data['createdate'] = $dateMySql; $data['addedby'] = 'server'; $data['author'] = 'Administrator'; } if (!$row->bind($data)) { JError::raiseError(500, $row->getError()); return false; } if (!$row->check()) { JError::raiseError(500, $row->getError()); } if (!$row->store()) { JError::raiseError(500, $row->getError()); return false; } return true; }
function save($data) { $row =& JTable::getInstance('codefile', 'Table'); $id = $data['id']; if (!$id) { jimport('joomla.utilities.date'); $dateNow = new JDate(); $dateMySql = $dateNow->toMySQL(); $data['creationdate'] = $dateMySql; $data['addedby'] = 'server'; } if (!$row->bind($data)) { JError::raiseError(500, $row->getError()); return false; } if (!$row->check()) { JError::raiseError(500, $row->getError()); } if (!$row->store()) { JError::raiseError(500, $row->getError()); return false; } else { if (!$id) { $row->load($row->{$id}); } if ($_FILES['cfile']['size']) { $this->fileupdload($row->id); } } return true; }
function &getData() { if (empty($this->_data)) { $query = ' SELECT * FROM #__fst_comments ' . ' WHERE id = ' . FSTJ3Helper::getEscaped($this->_db, $this->_id); $this->_db->setQuery($query); $this->_data = $this->_db->loadObject(); } if (!$this->_data) { $this->_data = new stdClass(); $this->_data->id = 0; $this->_data->ident = 5; // $this->_data->itemid = 0; $this->_data->body = null; $this->_data->email = null; $this->_data->name = null; $this->_data->website = null; $this->_data->published = 1; $current_date = new JDate(); if (FSTJ3Helper::IsJ3()) { $mySQL_conform_date = $current_date->toSql(); } else { $mySQL_conform_date = $current_date->toMySQL(); } $this->_data->created = $mySQL_conform_date; } return $this->_data; }
public function store($updateNulls = false) { $now = new JDate(); if ($this->created == null) { $this->created = $now->toMySQL(); } return parent::store($updateNulls); }
public function store($updateNulls = false) { $now = new JDate(); if ($this->created == null) { $this->created = $now->toMySQL(); } $this->_generatePreview(); $this->params = $this->_params->toString(); return parent::store(); }
private function PurgeExpiredSessions() { //$app = JFactory::getApplication(); //global $app; //$lifetime = $app->getCfg("lifetime"); $lifetime = JFactory::$config->get("lifetime"); $date = new JDate("-" . $lifetime . " minute"); $sql = "DELETE FROM #__" . $GLOBALS["ext_name"] . "_sessions WHERE birth < '" . $date->toMySQL() . "';"; $this->db->setQuery($sql); $this->db->query(); }
public function getList($params) { $db = JFactory::getDBO(); $user = JFactory::getUser(); $aid = $user->get('aid', 0); $items = (int) $params->get('items', 0); $order = $params->get('order', 'o_asc'); $noauth = !JComponentHelper::getParams('com_content')->get('shownoauth'); if (!($catid = $params->get('catid', 0))) { return array(); } $nullDate = $db->getNullDate(); jimport('joomla.utilities.date'); $date = new JDate(); $now = $date->toMySQL(); // Ordering $direction = null; switch ($params->get('order')) { case 'random': $ordering = 'RAND()'; break; case 'date': $ordering = 'a.created'; break; case 'rdate': $ordering = 'a.created DESC'; break; case 'alpha': $ordering = 'a.title'; break; case 'ralpha': $ordering = 'a.title DESC'; break; case 'hits': $ordering = 'a.hits'; break; case 'rhits': $ordering = 'a.hits DESC'; break; case 'ordering': default: $ordering = 'a.ordering'; break; } $parts = explode(':', $catid); $section = array_shift($parts); $category = array_shift($parts); // Query to determine article count $query = 'SELECT a.*,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE a.state = 1 ' . ($noauth ? ' AND a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid . ' AND s.access <= ' . (int) $aid : '') . ' AND (a.publish_up = "' . $nullDate . '" OR a.publish_up <= "' . $now . '" ) ' . ' AND (a.publish_down = "' . $nullDate . '" OR a.publish_down >= "' . $now . '" )' . ($category ? ' AND cc.id = ' . (int) $category : '') . ' AND cc.section = ' . (int) $section . ' AND cc.published = 1' . ' AND s.published = 1' . ' ORDER BY ' . $ordering . ' LIMIT 0,' . (int) $items; $db->setQuery($query); return $db->loadObjectList(); }
function getList($params) { global $mainframe; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $option = JRequest::getCmd('option'); $view = JRequest::getCmd('view'); $temp = JRequest::getString('id'); $temp = explode(':', $temp); $id = $temp[0]; $showDate = $params->get('showDate', 0); $nullDate = $db->getNullDate(); jimport('joomla.utilities.date'); $date = new JDate(); $now = $date->toMySQL(); $related = array(); if ($option == 'com_content' && $view == 'article' && $id) { // select the meta keywords from the item $query = 'SELECT metakey' . ' FROM #__content' . ' WHERE id = ' . (int) $id; $db->setQuery($query); if ($metakey = trim($db->loadResult())) { // explode the meta keys on a comma $keys = explode(',', $metakey); $likes = array(); // assemble any non-blank word(s) foreach ($keys as $key) { $key = trim($key); if ($key) { $likes[] = $db->getEscaped($key); } } if (count($likes)) { // select other items based on the metakey field 'like' the keys found $query = 'SELECT a.id, a.title, DATE_FORMAT(a.created, "%Y-%m-%d") AS created, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id' . ' LEFT JOIN #__categories AS cc ON cc.id = a.catid' . ' LEFT JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE a.id != ' . (int) $id . ' AND a.state = 1' . ' AND a.access <= ' . (int) $user->get('aid', 0) . ' AND ( a.metakey LIKE "%' . implode('%" OR a.metakey LIKE "%', $likes) . '%" )' . ' AND ( a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' )' . ' AND ( a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )'; $db->setQuery($query); $temp = $db->loadObjectList(); if (count($temp)) { foreach ($temp as $row) { if (($row->cat_state == 1 || $row->cat_state == '') && ($row->sec_state == 1 || $row->sec_state == '') && ($row->cat_access <= $user->get('aid', 0) || $row->cat_access == '') && ($row->sec_access <= $user->get('aid', 0) || $row->sec_access == '')) { $row->route = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid)); $related[] = $row; } } } unset($temp); } } } return $related; }
function loadChartData() { $db = $this->getDBO(); $type = JRequest::getCmd('type'); switch ($type) { case 'sales': jimport('joomla.utilities.date'); $date = JFactory::getDate(); $interval = JRequest::getInt('interval', '14'); $today = $date->toFormat('%Y-%m-%d'); $startDate = strtotime('-' . $interval . ' day', strtotime($today)); $startDate = new JDate($startDate); $query = "SELECT COUNT(virtuemart_order_id) AS sales, DATE(created_on) as `date` FROM #__virtuemart_orders WHERE created_on > " . $db->Quote($startDate->toMySQL()) . " GROUP BY `date` ORDER BY `date`"; $db->setQuery($query); $rows = $db->loadObjectList(); $data = array(); foreach ($rows as $row) { $data[$row->date] = (int) $row->sales; } $today = $date->toUnix(); for ($time = $startDate->toUnix(); $time <= $today; $time += 86400) { $date = date('Y', $time) . '-' . date('m', $time) . '-' . date('d', $time); if (!array_key_exists($date, $data)) { $data[$date] = 0; } } ksort($data); $startYear = $startDate->toFormat('%Y'); $startMonth = $startDate->toFormat('%m') - 1; $startDay = $startDate->toFormat('%d'); $script = "\r\n k2martSalesChartOptions.title.text = '" . JText::_('K2MART_TOTAL_SALES', true) . "';\r\n k2martSalesChartOptions.subtitle.text = '* " . JText::_('K2MART_CLICK_AND_DRAG_IN_THE_PLOT_AREA_TO_ZOOM_IN', true) . "';\r\n k2martSalesChartOptions.yAxis.title.text = '" . JText::_('K2MART_SALES', true) . "';\r\n k2martSalesChartOptions.series[0].pointStart=Date.UTC(" . $startYear . ", " . $startMonth . ", " . $startDay . "); \r\n k2martSalesChartOptions.series[0].data=[" . implode(',', $data) . "];\r\n "; break; case 'products': $limit = JRequest::getInt('limit', '20'); $query = "SELECT product.product_sales, productData.product_name FROM #__virtuemart_products AS product \r\n LEFT JOIN #__virtuemart_products_" . VMLANG . " AS productData ON product.virtuemart_product_id = productData.virtuemart_product_id\r\n WHERE product.product_sales > 0 ORDER BY product.product_sales DESC LIMIT 0, {$limit}"; $db->setQuery($query); $rows = $db->loadObjectList(); $data = array(); $categories = array(); foreach ($rows as $row) { $data[] = (int) $row->product_sales; $categories[] = "'" . $row->product_name . "'"; } $script = "\r\n k2martProductsChartOptions.title.text = '" . JText::_('K2MART_TOP_SELLING_PRODUCTS', true) . "';\r\n k2martProductsChartOptions.yAxis.title.text = '" . JText::_('K2MART_SALES', true) . "';\r\n k2martProductsChartOptions.xAxis.categories =[" . implode(',', $categories) . "]; \r\n k2martProductsChartOptions.series[0].data=[" . implode(',', $data) . "];\r\n "; break; } $script .= "k2martChartType = '{$type}';"; echo $script; }
function processIPN() { $model = JModel::getInstance('Gateways', 'JTheFactoryModel'); $params = $model->loadGatewayParams($this->name); $paypal_address = $params->get('paypalemail', ''); $paylog = JTable::getInstance('PaymentLogTable', 'JTheFactory'); $date = new JDate(); $paylog->date = $date->toMySQL(); $paylog->amount = JRequest::getVar('mc_gross'); $paylog->currency = JRequest::getVar('mc_currency'); $paylog->refnumber = JRequest::getVar('txn_id'); $paylog->invoice = JRequest::getVar('invoice'); $paylog->ipn_response = print_r($_REQUEST, true); $paylog->ipn_ip = $_SERVER['REMOTE_ADDR']; $paylog->status = 'error'; $paylog->userid = null; $paylog->orderid = JRequest::getVar('invoice'); $paylog->payment_method = $this->name; $receiver_email = JRequest::getVar('receiver_email'); $payment_status = JRequest::getVar('payment_status'); switch ($payment_status) { case "Completed": case "Processed": $paylog->status = 'ok'; break; case "Failed": case "Denied": case "Canceled-Reversal": case "Canceled_Reversal": case "Expired": case "Voided": case "Reversed": case "Refunded": $paylog->status = 'error'; break; default: case "In-Progress": case "Pending": $paylog->status = 'manual_check'; break; } if (!$this->validate_ipn() || $receiver_email != $paypal_address) { $paylog->status = 'error'; } elseif (!$params->get('auto_accept', 1)) { $paylog->status = 'manual_check'; } $paylog->store(); return $paylog; }
function check() { // make published by default and get a new order no if (!$this->id) { if ($this->created == "") { $current_date = new JDate(); if (FSSJ3Helper::IsJ3()) { $mySQL_conform_date = $current_date->toSql(); } else { $mySQL_conform_date = $current_date->toMySQL(); } $this->set('created', $mySQL_conform_date); } } return true; }
function markAsSent($blogId) { $posts = EB::table('TwitterPosts'); $posts->load($blogId); $date = new JDate(); $now = $date->toMySQL(); if (empty($posts->id)) { $posts->created = $now; } $posts->modified = $now; if ($posts->store()) { return true; } else { return false; } }
function addVisitor($ip) { $data = array(); $dateNow = new JDate(); $data['ipaddress'] = $ip; $data['accesstime'] = $dateNow->toMySQL(); $row =& JTable::getInstance('visitor', 'Table'); if (!$row->bind($data)) { JError::raiseError(500, $row->getError()); return false; } if (!$row->store()) { JError::raiseError(500, $row->getError()); return false; } return true; }
function saveuser($data) { $dateNow = new JDate(); $data['registrationdate'] = $dateNow->toMySQL(); $data['password'] = sha1($data['password']); $data['addedbyip'] = $_SERVER['REMOTE_ADDR']; $data['published'] = 0; $row =& JTable::getInstance('user', 'Table'); if (!$row->bind($data)) { JError::raiseError(500, $row->getError()); return false; } if (!$row->store()) { JError::raiseError(500, $row->getError()); return false; } return true; }
function update_null_dates($redirect = true) { global $mainframe; // Get all the attachment IDs $db =& JFactory::getDBO(); $query = "SELECT * FROM #__attachments"; $db->setQuery($query); $rows = $db->loadObjectList(); if (count($rows) == 0) { return 0; } // Update the dates for all the attachments $numUpdated = 0; foreach ($rows as $row) { // Update the new create and update dates if they are null $updated = false; $create_date = $row->create_date; if (is_null($create_date) || $create_date == '') { jimport('joomla.utilities.date'); $cdate = new JDate(filemtime($row->filename_sys), $mainframe->getCfg('offset')); $create_date = $cdate->toMySQL(); $updated = true; } $mod_date = $row->modification_date; if (is_null($mod_date) || $mod_date == '') { jimport('joomla.utilities.date'); $mdate = new JDate(filemtime($row->filename_sys), $mainframe->getCfg('offset')); $mod_date = $mdate->toMySQL(); $updated = true; } // Update the record if ($updated) { $query = "UPDATE #__attachments set modification_date='{$mod_date}', create_date='{$create_date}' WHERE id='{$row->id}'"; $db->setQuery($query); if (!$db->query()) { echo "Error updating {$row->filename}: " . $db->stderr(); } $numUpdated++; } } return $numUpdated; }
function getList(&$params, &$access) { global $mainframe; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $aid = $user->get('aid', 0); $catid = (int) $params->get('catid', 0); $items = (int) $params->get('items', 0); $contentConfig =& JComponentHelper::getParams('com_content'); $noauth = !$contentConfig->get('shownoauth'); jimport('joomla.utilities.date'); $date = new JDate(); $now = $date->toMySQL(); $nullDate = $db->getNullDate(); // query to determine article count $query = 'SELECT a.*,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE a.state = 1 ' . ($noauth ? ' AND a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid . ' AND s.access <= ' . (int) $aid : '') . ' AND (a.publish_up = ' . $db->Quote($nullDate) . ' OR a.publish_up <= ' . $db->Quote($now) . ' ) ' . ' AND (a.publish_down = ' . $db->Quote($nullDate) . ' OR a.publish_down >= ' . $db->Quote($now) . ' )' . ' AND cc.id = ' . (int) $catid . ' AND cc.section = s.id' . ' AND cc.published = 1' . ' AND s.published = 1' . ' ORDER BY a.ordering'; $db->setQuery($query, 0, $items); $rows = $db->loadObjectList(); return $rows; }
function saveCatg() { require JPATH_COMPONENT_ADMINISTRATOR . DS . 'config.datsogallery.php'; $is_admin = array(7, 8); $db = JFactory::getDBO(); $user = JFactory::getUser(); $userGroups = JAccess::getGroupsByUser($user->id, true); $post = JRequest::get('post'); //$post['description'] = JRequest::getVar('description', '', 'post', 'string', JREQUEST_ALLOWRAW); $row = new DatsoCategories($db); if (!array_intersect($is_admin, $userGroups)) { $category = explode(',', $ad_category); $getfirst = array_shift($category); $db->setQuery('SELECT cid' . ' FROM #__datsogallery_catg' . ' WHERE user_id = ' . (int) $user->id . ' AND parent = ' . $ad_category); $result = $db->loadResult(); $row->parent = $result ? $result : $ad_category; $row->ordering = $row->getNextOrder('parent = ' . $row->parent); } else { $row->ordering = $row->getNextOrder('parent = 0'); } $row->user_id = $user->id; $row->approved = !$user_categories_approval || array_intersect($is_admin, $userGroups) ? 1 : 0; $row->published = 1; jimport('joomla.utilities.date'); $dtz = new DateTimeZone(JFactory::getApplication()->getCfg('offset')); $date = new JDate($row->date); $date->setTimezone($dtz); $row->date = $date->toMySQL(true); if (!$row->bind($post)) { JError::raiseError(500, $row->getError()); } if (!$row->check()) { JError::raiseError(500, $row->getError()); } if (!$row->store()) { JError::raiseError(500, $row->getError()); } if ($ad_category_notify && !array_intersect($is_admin, $userGroups)) { categoryNotify($user->username, $post['name']); } }
function getList(&$params, &$access) { global $mainframe; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $aid = $user->get('aid', 0); $catid = (int) $params->get('catid', 0); $items = (int) $params->get('items', 0); $order = $params->get('order', 'o_asc'); $contentConfig =& JComponentHelper::getParams('com_content'); $noauth = !$contentConfig->get('shownoauth'); $nullDate = $db->getNullDate(); jimport('joomla.utilities.date'); $date = new JDate(); $now = $date->toMySQL(); // Ordering switch ($order) { case 'm_dsc': $ordering = 'a.modified DESC, a.created DESC'; break; case 'h_dsc': $ordering = 'a.hits DESC, a.created DESC'; break; case 'c_dsc': $ordering = 'a.created DESC'; break; case 'o_asc': default: $ordering = 'a.ordering'; break; } // Query to determine article count $query = 'SELECT a.*,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE a.state = 1 ' . ($noauth ? ' AND a.access <= ' . (int) $aid . ' AND cc.access <= ' . (int) $aid . ' AND s.access <= ' . (int) $aid : '') . ' AND (a.publish_up = "' . $nullDate . '" OR a.publish_up <= "' . $now . '" ) ' . ' AND (a.publish_down = "' . $nullDate . '" OR a.publish_down >= "' . $now . '" )' . ' AND cc.id = ' . $catid . ' AND cc.section = s.id' . ' AND cc.published = 1' . ' AND s.published = 1' . ' ORDER BY ' . $ordering; $db->setQuery($query); $rows = $db->loadObjectList(); if ($order == 'rnd') { shuffle($rows); } return array_slice($rows, 0, $items); }
function processIPN() { $model = JModel::getInstance('Gateways', 'JTheFactoryModel'); $params = $model->loadGatewayParams($this->name); $paypal_address = $params->get('paypalemail', ''); $paylog = JTable::getInstance('PaymentLogTable', 'JTheFactory'); $date = new JDate(); $paylog->date = $date->toMySQL(); $paylog->amount = JRequest::getVar('mb_amount'); $paylog->currency = JRequest::getVar('mb_currency'); $paylog->refnumber = JRequest::getVar('mb_transaction_id'); $paylog->invoice = JRequest::getVar('transaction_id'); $paylog->ipn_response = print_r($_REQUEST, true); $paylog->ipn_ip = $_SERVER['REMOTE_ADDR']; $paylog->status = 'error'; $paylog->userid = null; $paylog->orderid = JRequest::getVar('mb_transaction_id'); $paylog->payment_method = $this->name; $receiver_email = JRequest::getVar('pay_to_email'); $payment_status = JRequest::getVar('status'); switch ($payment_status) { case "2": $paylog->status = 'ok'; break; case "-1": case "-2": case "-3": $paylog->status = 'error'; break; default: case "0": $paylog->status = 'manual_check'; break; } if ($receiver_email != $paypal_address) { $paylog->status = 'error'; } $paylog->store(); return $paylog; }
/** * Retturn list of all event that start with the given month/year */ public function getMonthEvent($month, $year) { $db = JFactory::getDbo(); // Filter event up to 24 hours earlier $date = new JDate(); $date->setOffset(-24); // Select pending event and uncompleted milestone $where = '( (' . $db->nameQuote('type') . '=' . $db->Quote('event') . ' AND ' . $db->nameQuote('start_date') . '>' . $db->Quote($date->toMySQL()) . ')' . ' OR ' . '(' . $db->nameQuote('type') . '=' . $db->Quote('milestone') . ' AND ' . $db->nameQuote('status') . '=' . $db->Quote('0') . ')' . ')'; $where = $db->nameQuote('start_date') . '>= DATE(' . $db->Quote($year . '-' . $month . '-1') . ') '; $where .= ' AND ' . $db->nameQuote('start_date') . '<= DATE_ADD( DATE(' . $db->Quote($year . '-' . $month . '-1') . ') , INTERVAL 1 MONTH ) '; $where2 = $db->nameQuote('end_date') . '>= DATE(' . $db->Quote($year . '-' . $month . '-1') . ') '; $where2 .= ' AND ' . $db->nameQuote('end_date') . '<= DATE_ADD( DATE(' . $db->Quote($year . '-' . $month . '-1') . ') , INTERVAL 1 MONTH ) '; $where2 .= ' AND ' . $db->nameQuote('type') . '=' . $db->Quote('todo'); $my = JXFactory::getUser(); $userGroups = $my->getParam('groups_member'); $where = '( ' . $where . ') AND (' . $db->nameQuote('access') . "=" . $db->Quote(0); if (!empty($userGroups)) { $where .= ' OR ' . $db->nameQuote('group_id') . 'IN (' . $userGroups . ') )'; } else { $where .= ')'; } $where2 = '( ' . $where2 . ') AND (' . $db->nameQuote('access') . "=" . $db->Quote(0); if (!empty($userGroups)) { $where2 .= ' OR ' . $db->nameQuote('group_id') . 'IN (' . $userGroups . ') )'; } else { $where2 .= ')'; } $query = 'SELECT * FROM #__stream WHERE ' . $where . ' UNION SELECT * FROM #__stream WHERE ' . $where2 . ' ORDER BY ' . $db->nameQuote('start_date') . ' ASC'; $db->setQuery($query); $result = $db->loadObjectList(); $rows = array(); if (!empty($result)) { foreach ($result as $row) { $obj = JTable::getInstance('Stream', 'StreamTable'); $obj->bind($row); $rows[] = $obj; } } return $rows; }
/** * Method to get a hello * @return object with data */ function &getData() { // Load the data if (empty($this->_data)) { $query = ' SELECT * FROM #__fussball_spiel ' . ' WHERE id = ' . $this->_id; $this->_db->setQuery($query); $this->_data = $this->_db->loadObject(); } if (!$this->_data) { $now = new JDate(); $this->_data = new stdClass(); $this->_data->id = 0; $this->_data->idMannschaft1 = 0; $this->_data->idMannschaft2 = 0; $this->_data->tore1 = 0; $this->_data->tore2 = 0; $this->_data->datum = $now->toMySQL(); $this->_data->spielbeschreibung = ''; $this->_data->idSpiel_typ = 0; } return $this->_data; }
/** * Onload, we try to load existing data, if any. If not, query from Google */ public function load($address) { // lowercase the incoming address $address = JString::strtolower($address); $db =& JFactory::getDBO(); $query = 'SELECT * FROM ' . $db->nameQuote('#__community_location_cache'); $query .= ' WHERE '; $query .= $db->nameQuote('address') . '= ' . $db->quote($address); $query .= ' LIMIT 1'; $db->setQuery($query); $obj = $db->loadObject(); if ($obj) { $this->bind($obj); } else { CFactory::load('libraries', 'mapping'); $data = CMapping::getAddressData($address); $this->address = $address; $this->latitude = COMMUNITY_LOCATION_NULL; $this->longitude = COMMUNITY_LOCATION_NULL; $this->data = ''; $this->status = 'ZERO_RESULTS'; if ($data != null) { require_once AZRUL_SYSTEM_PATH . DS . 'pc_includes' . DS . 'JSON.php'; $json = new Services_JSON(); $content = $json->encode($data); if ($data->status == 'OK') { $this->latitude = $data->results[0]->geometry->location->lat; $this->longitude = $data->results[0]->geometry->location->lng; $this->data = $content; $this->status = $data->status; } } $date = new JDate(); $this->created = $date->toMySQL(true); $this->store(); } return true; }
public function addReply() { $msgId = JRequest::getVar('msgid', '', 'POST'); $reply = JRequest::getVar('reply', '', 'POST'); $attachment = JRequest::getVar('attachment', array(), 'POST', 'array'); $my = JXFactory::getUser(); $messagingModel = MessagingFactory::getModel('inbox'); $message = $messagingModel->getMessage($msgId); if ($my->id == 0) { return; } $now = new JDate(); $obj = new stdClass(); $obj->id = null; $obj->from = $my->id; $obj->posted_on = $now->toMySQL(); $obj->from_name = $my->name; $obj->subject = 'RE:' . $message->subject; $obj->body = $reply; $obj->attachment = implode(', ', $attachment); $messagingModel->sendReply($obj, $msgId); $deleteLink = JRoute::_('index.php?option=com_community&view=inbox&task=remove&msgid=' . $obj->id); $authorLink = JRoute::_('index.php?option=com_community&view=profile&userid=' . $my->id); $this->_addAttachments($obj->id); $attachments = $messagingModel->getAttachments($obj); $tmpl = new MessagingTemplate(); $tmpl->set('user', JXFactory::getUser($obj->from)); $tmpl->set('msg', $obj); $tmpl->set('removeLink', $deleteLink); $tmpl->set('authorLink', $authorLink); $tmpl->set('attachments', $attachments); $html = $tmpl->fetch('inbox.message'); $data = array(); $data['html'] = $html; header('Content-Type: text/json'); echo json_encode($data); exit; }