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);
}
