Example #1
0
 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.' );
 }
Example #2
0
 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);
 }
Example #3
0
 public function post()
 {
     //query to get daily, weekly, mohthly & yearly sales
     $db = JFactory::getDBO();
     require_once dirname(__FILE__) . DS . 'helper.php';
     $current_date = JRequest::getVar('current_date');
     //for log record
     jimport('joomla.error.log');
     $options = array('format' => "{DATE}\t{TIME}\t{USER_ID}\t{COMMENT}\t{CDATE}\t{}");
     $log =& JLog::getInstance('com_api.log.php');
     $log->setOptions($options);
     $user =& JFactory::getUser();
     $userId = $user->get('id');
     $log->addEntry(array('user_id' => $userId, 'comment' => 'This is the comment', 'cdate' => $current_date));
     //set offset & date for server
     $config =& JFactory::getConfig();
     $offset = $config->getValue('config.offset');
     $offset = '';
     $current_date =& JFactory::getDate($current_date, $offset);
     $current_date = $current_date->toFormat('%F %T');
     //daily data
     $day_start = date_create($current_date)->format('Y-m-d');
     $day_start .= ' 00:00:00';
     $daily = Sale_Data::total($day_start, $current_date);
     $daily = Sale_Data::compress($daily);
     if (!$daily) {
         $daily = 0;
     }
     list($year, $month, $day) = split('[/.-]', $current_date);
     //weekly data
     $db = JFactory::getDBO();
     $query = "SELECT WEEKDAY('" . $current_date . "')";
     $db->setQuery($query);
     $wstart = $db->loadResult();
     $wday = $day - $wstart;
     $wdate = $year . "-" . $month . "-" . $wday;
     $weekly = Sale_Data::total($wdate, $current_date);
     $weekly = Sale_Data::compress($weekly);
     if (!$weekly) {
         $weekly = 0;
     }
     // monthly data
     $mdate = $year . "-" . $month . "-01 00:00:00";
     $monthly = Sale_Data::total($mdate, $current_date);
     $monthly = Sale_Data::compress($monthly);
     if (!$monthly) {
         $monthly = 0;
     }
     //quarterly data
     $query = "SELECT QUARTER('" . $current_date . "')";
     $db->setQuery($query);
     $res = $db->loadResult();
     $query = "SELECT YEAR('" . $current_date . "')";
     $db->setQuery($query);
     $year = $db->loadResult();
     switch ($res) {
         case 1:
             $qrt = $year . "-01-01";
             break;
         case 2:
             $qrt = $year . "-04-01";
             break;
         case 3:
             $qrt = $year . "-07-01";
             break;
         case 4:
             $qrt = $year . "-10-01";
             break;
     }
     $quarterly = Sale_Data::total($qrt, $current_date);
     $quarterly = Sale_Data::compress($quarterly);
     if (!$quarterly) {
         $quarterly = 0;
     }
     // calender Yearly data
     $ydate = $year . "-01-01 00:00:00";
     $yearly = Sale_Data::total($ydate, $current_date);
     $yearly = Sale_Data::compress($yearly);
     if (!$yearly) {
         $year = 0;
     }
     // financial Yearly data
     $fdate = $year . "-4-1 00:00:00";
     $fyearly = Sale_Data::total($fdate, $current_date);
     $fyearly = Sale_Data::compress($fyearly);
     if (!$fyearly) {
         $fyear = 0;
     }
     // Currency
     require JPATH_SITE . DS . "administrator" . DS . "components" . DS . "com_socialads" . DS . "config" . DS . "config.php";
     $currency = $socialads_config['currency'];
     switch ($currency) {
         case "INR":
             $currency = "₹";
             break;
         case "USD":
             $currency = "\$";
             break;
         case "GBP" || "UKP":
             $currency = "£";
             break;
         case "JPY":
             $currency = "¥";
             break;
         case "ITL":
             $currency = "£";
             break;
         case "EUR":
             $currency = "€";
             break;
         case "CNY":
             $currency = "¥";
             break;
         case "ZAR":
             $currency = "R";
             break;
         case "AUD":
             $currency = "\$";
             break;
     }
     //send result
     $result = array();
     $result['summary'] = array("daily" => $daily, "weekly" => $weekly, "monthly" => $monthly, "quarterly" => $quarterly, "financial_yearly" => $fyearly, "calender_yearly" => $yearly);
     $result['attribs'] = array("currency" => $currency);
     $this->plugin->setResponse($result);
 }