public function post() { $db = JFactory::getDBO(); require_once dirname(__FILE__) . DS . 'helper.php'; //get date from app $startdate = JRequest::getVar('startdate'); $enddate = JRequest::getVar('enddate'); $startdate .= ' 00:00:00'; $enddate .= ' 23:59:59'; $sdate = $startdate; $edate = $enddate; //get offset value $config =& JFactory::getConfig(); $offset = $config->getValue('config.offset'); $startdate =& JFactory::getDate($startdate, $offset); $enddate =& JFactory::getDate($enddate, $offset); $startdate = $startdate->toFormat('%F %T'); $enddate = $enddate->toFormat('%F %T'); //query for product details $query = "SELECT a.ad_id,a.ad_title AS product_name,SUM(b.ad_amount)AS product_sales \n\t\t \t\t\t\tFROM #__ad_data AS a,#__ad_payment_info AS b WHERE a.ad_id \n\t\t\t\t\t \tIN (SELECT c.ad_id FROM #__ad_payment_info AS c\n\t\t \tWHERE status='1' AND b.mdate \n\t\t \tBETWEEN '" . $startdate . "'AND '" . $enddate . "')\n\t\t \tAND a.ad_id = b.ad_id\n\t\t \tGROUP BY a.ad_title ORDER BY product_sales DESC"; $db->setQuery($query); $details['data'] = array($db->loadObjectList()); $i = 0; while (count($details['data'][0]) >= $i) { $value = $details['data'][0][$i]->product_sales; $value = number_format($value, 2, '.', ''); if ($details['data'][0][$i]->product_sales > 9999) { $value = $details['data'][0][$i]->product_sales / 1000; $value = number_format($value, 2, '.', ''); $value .= 'K'; $details['data'][0][$i]->product_sales = $value; } $i++; } $total = Sale_Data::total($startdate, $enddate); $projected_sale = Sale_Data::projected_sale($sdate, $edate, $total); $total = Sale_Data::compress($total); $projected_sale = Sale_Data::compress($projected_sale); $details['total'] = array("total" => $total); $details['projected_sale'] = array("projected_sale" => $projected_sale); $this->plugin->setResponse($details); //$this->plugin->setResponse( 'This is a post request.' ); }
public function post() { $db = JFactory::getDBO(); require_once dirname(__FILE__) . DS . 'helper.php'; //get date from app $startdate = JRequest::getVar('startdate'); $enddate = JRequest::getVar('enddate'); $startdate .= ' 00:00:00'; $enddate .= ' 23:59:59'; $sdate = $startdate; $edate = $enddate; //get offset value $config =& JFactory::getConfig(); $offset = $config->getValue('config.offset'); $startdate =& JFactory::getDate($startdate, $offset); $enddate =& JFactory::getDate($enddate, $offset); $startdate = $startdate->toFormat('%F %T'); $enddate = $enddate->toFormat('%F %T'); //query for product details $query = "SELECT a.order_item_sku AS product_sku,b.product_name,SUM(a.product_quantity)AS quantity,\n\t\t\t\t\t SUM(a.product_final_price) AS product_sales\n\t\t\t\t\t FROM #__redshop_order_item AS a,#__redshop_product AS b WHERE a.product_id=b.product_id\n\t\t\t\t\t AND a.order_id IN (SELECT order_id FROM #__redshop_orders \n\t\t WHERE order_status='S' AND order_payment_status='Paid')\n\t\t AND FROM_UNIXTIME(a.mdate)\n\t\t BETWEEN '{$startdate}' AND '{$enddate}' \n\t\t GROUP BY a.order_item_sku ORDER BY product_sales DESC"; $db->setQuery($query); $details['data'] = array($db->loadObjectList()); $i = 0; while (count($details['data'][0]) >= $i) { if ($details['data'][0][$i]->product_sales > 9999) { $value = $details['data'][0][$i]->product_sales / 1000; $value = number_format($value, 2, '.', ''); $value .= 'K'; $details['data'][0][$i]->product_sales = $value; } $i++; } $total = Sale_Data::total($startdate, $enddate); $projected_sale = Sale_Data::projected_sale($sdate, $edate, $total); $total = Sale_Data::compress($total); $projected_sale = Sale_Data::compress($projected_sale); $details['total'] = array("total" => $total); $details['projected_sale'] = array("projected_sale" => $projected_sale); $this->plugin->setResponse($details); }