Модуль расчёта ПРИБЫЛИ для PrestaShop™ 1.5.5.0

Jenysan · 10 сен 2013

Здравствуйте ! Ребята , прошу помощи в разработке модуля для статистики, расчёта прибыли . Я плохо разбераюсь в написание модуля для ПШ любая помощь приветствуется любой кусочек программы сделаем модуль БСПЛАТНО . Подскажите с чего начать ? . Планирую сделать вот так . Таблица ,
Картинка товара ,id товара , название товара , количество проданного товара , скидка , доставка , закупачная цена , цена продажи , Прибыль .
Это столбики таблицы !
Кнопка импорта данных статистики прибыли в формате CSV.
Вот образец модуля для продолжения модернизации http://yadi.sk/d/cs2Yr3OM93Eiu

--- Добавлено, 10 сен 2013 ---

<?php

/**
* Statistics
* @category stats
*
* @copyright PrestaShop
* @license http://www.opensource.org/licenses/osl-3.0.php Open-source licence 3.0
* @version 1.5
*/
class StatsProfitMargin extends ModuleGrid
{
private $_html = null;
private $_query = null;
private $_columns = null;
private $_defaultSortColumn = null;
private $_emptyMessage = null;
private $_pagingMessage = null;

function __construct()
{
$this->name = 'statsprofitmargin';
$this->tab = 'Stats';
$this->version = 1.5;

$this->_defaultSortColumn = 'number';
$this->_emptyMessage = $this->l('Empty recordset returned');
$this->_pagingMessage = $this->l('Displaying').' {0} - {1} '.$this->l('of').' {2}';

$this->_columns = array(
array(
'id' => 'number',
'header' => $this->l('ID'),
'dataIndex' => 'number',
'align' => 'left',
'width' => 30
),
array(
'id' => 'total',
'header' => $this->l('Total'),
'dataIndex' => 'total',
'width' => 80,
'align' => 'left'
),
// array(
// 'id' => 'revenue',
// 'header' => $this->l('Revenue'),
// 'dataIndex' => 'revenue',
// 'width' => 100,
// 'align' => 'right'
// ),
array(
'id' => 'shipping',
'header' => $this->l('Shipping'),
'dataIndex' => 'shipping',
'width' => 80,
'align' => 'left'
),
array(
'id' => 'discounts',
'header' => $this->l('Discounts'),
'dataIndex' => 'discounts',
'width' => 80,
'align' => 'left'
),
array(
'id' => 'cost',
'header' => $this->l('Cost'),
'dataIndex' => 'cost',
'width' => 80,
'align' => 'left'
),
array(
'id' => 'profit',
'header' => $this->l('Profit'),
'dataIndex' => 'profit',
'width' => 80,
'align' => 'left'
)
);

parent::__construct();

$this->displayName = $this->l('Profit margins');
$this->description = $this->l('A list of the Profit margins');
}

public function install()
{
return (parent::install() AND $this->registerHook('AdminStatsModules'));
}

public function hookAdminStatsModules($params)
{
$engineParams = array(
'id' => 'id_product',
'title' => $this->displayName,
'columns' => $this->_columns,
'defaultSortColumn' => $this->_defaultSortColumn,
'emptyMessage' => $this->_emptyMessage,
'pagingMessage' => $this->_pagingMessage
);
$currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));

$this->_html = '
<fieldset class="width3"><legend><img src="../modules/'.$this->name.'/logo.gif" /> '.$this->displayName.'</legend>
'.ModuleGrid::engine($engineParams).'
</fieldset>';
$date = $this->getDate();
$totalprofit = $this->getTotalProfit($date) - $this->getTotalDiscounts($date);
$totaldiscount = $this->getTotalDiscounts($date);
$totalshipping = $this->getTotalShipping($date);
$totalproducts = $this->getTotalProducts($date) - $this->getTotalDiscounts($date);
$this->_html .= ''.$this->l('Total profit:').' '.Tools::displayPrice($totalprofit, $currency).'';
$this->_html .= ''.$this->l('Total discount:').' '.Tools::displayPrice($totaldiscount, $currency).'';
$this->_html .= ''.$this->l('Total shipping:').' '.Tools::displayPrice($totalshipping, $currency).'';
$this->_html .= ''.$this->l('Total product sales:').' '.Tools::displayPrice($totalproducts, $currency).'';
$this->_html .= '<a href="profit.csv">'.$this->l('Download CSV').'</a>';
//$this->_html .= ''.$this->l('Date:').' '.$date.'';
return $this->_html;
}

public function getTotalCount($dateBetween)
{
$result = Db::getInstance()->GetRow('
SELECT COUNT(o.`id_order`) as allOrderCount
FROM `'._DB_PREFIX_.'orders` o
LEFT JOIN `'._DB_PREFIX_.'currency` c ON o.id_currency = c.id_currency
'.(intval(Tools::getValue('id_country')) ? 'LEFT JOIN `'._DB_PREFIX_.'address` a ON o.id_address_delivery = a.id_address' : '').'
WHERE o.`invoice_date` BETWEEN '.$dateBetween.'
'.(intval(Tools::getValue('id_country')) ? 'AND a.id_country = '.intval(Tools::getValue('id_country')) : ''));
return $result['allOrderCount'];
}

public function getData()
{
$dateBetween = $this->getDate();
$this->_totalCount = $this->getTotalCount($dateBetween);
$this->_query = '
SELECT o.id_order AS number, ROUND( o.total_paid / c.conversion_rate, 2 ) AS total, ROUND( o.total_discounts / c.conversion_rate, 2 ) AS discounts, ROUND( o.total_shipping / c.conversion_rate, 2 ) AS shipping, ((
SELECT ROUND(SUM(p.wholesale_price * od.product_quantity), 2)
FROM '._DB_PREFIX_.'order_detail od
LEFT JOIN '._DB_PREFIX_.'product p ON od.product_id = p.id_product
WHERE od.id_order = o.`id_order`
) + (
SELECT ROUND(SUM(IFNULL(pa.wholesale_price, 0) * od.product_quantity), 2)
FROM '._DB_PREFIX_.'order_detail od
LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON pa.id_product_attribute = od.product_attribute_id
WHERE od.id_order = o.`id_order`
)) AS cost,
((
SELECT ROUND(o.`total_paid` / c.`conversion_rate` - SUM(p.wholesale_price * od.product_quantity) - o.total_shipping/c.conversion_rate, 2)
FROM '._DB_PREFIX_.'order_detail od
LEFT JOIN '._DB_PREFIX_.'product p ON od.product_id = p.id_product
WHERE od.id_order = o.`id_order`
) - (
SELECT ROUND(SUM(IFNULL(pa.wholesale_price, 0) * od.product_quantity), 2)
FROM '._DB_PREFIX_.'order_detail od
LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON pa.id_product_attribute = od.product_attribute_id
WHERE od.id_order = o.`id_order`
) -
(ROUND( o.total_discounts / c.conversion_rate, 2 )
)) AS profit
FROM `'._DB_PREFIX_.'product` p, `'._DB_PREFIX_.'product_attribute` pa, `'._DB_PREFIX_.'orders` o
LEFT JOIN `'._DB_PREFIX_.'currency` c ON o.id_currency = c.id_currency
WHERE o.valid =1
AND o.total_paid <>0 AND o.`date_add` BETWEEN '.$dateBetween.'
GROUP BY o.`id_order`';

if (Validate::IsName($this->_sort))
{
$this->_query .= ' ORDER BY `'.$this->_sort.'`';
if (isset($this->_direction))
$this->_query .= ' '.$this->_direction;
}
if (($this->_start === 0 OR Validate::IsUnsignedInt($this->_start)) AND Validate::IsUnsignedInt($this->_limit))
$this->_query .= ' LIMIT '.$this->_start.', '.($this->_limit);
$this->_values = Db::getInstance()->ExecuteS($this->_query);

$end = 1;
$fp = fopen('profit.csv', 'w');
fputcsv($fp, array($this->l('ID'), $this->l('Total'), $this->l('Discounts'), $this->l('Shipping'), $this->l('Profit'), '%'), "\t");
foreach ($this->_values as $fields) {
$end++;
$fields = str_replace(".", ",", $fields);
$fields = array_merge($fields, (array)"=(E$end/B$end)*100");;
fputcsv($fp, $fields, "\t");
}
fputcsv($fp, array());
fputcsv($fp, array($this->l('Total'), "=SUM(B2:B$end)", "=SUM(C2:C$end)", "=SUM(D2$end)", "=SUM(E2:E$end)", "=AVERAGE(F2:F$end)"), "\t");
fclose($fp);
}

private function getTotalProfit($dateBetween)
{
$result = Db::getInstance()->getRow('
SELECT SUM((p.price + IFNULL(pa.price,0)) - (IFNULL(pa.wholesale_price,0) * od.product_quantity) + (p.wholesale_price * od.product_quantity)) as totalprofit
FROM '._DB_PREFIX_.'orders o
LEFT JOIN '._DB_PREFIX_.'order_detail od ON od.id_order = o.id_order
LEFT JOIN '._DB_PREFIX_.'product p ON od.product_id = p.id_product
LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON od.product_attribute_id = pa.id_product_attribute
WHERE o.valid = 1 AND o.total_paid <> 0 AND o.date_add BETWEEN '.$dateBetween);
return $result['totalprofit'];
}

private function getTotalDiscounts($dateBetween)
{
$result = Db::getInstance()->getRow('
SELECT SUM(o.total_discounts/c.conversion_rate) as totaldiscounts
FROM '._DB_PREFIX_.'orders o
LEFT JOIN `'._DB_PREFIX_.'currency` c ON o.id_currency = c.id_currency
WHERE o.valid = 1 AND o.`date_add` BETWEEN '.$dateBetween);
return $result['totaldiscounts'];
}

private function getTotalShipping($dateBetween)
{
$result = Db::getInstance()->getRow('
SELECT SUM(o.total_shipping/c.conversion_rate) as totalshipping
FROM '._DB_PREFIX_.'orders o
LEFT JOIN `'._DB_PREFIX_.'currency` c ON o.id_currency = c.id_currency
WHERE o.valid = 1 AND o.`date_add` BETWEEN '.$dateBetween);
return $result['totalshipping'];
}

private function getTotalProducts($dateBetween)
{
$result = Db::getInstance()->getRow('
SELECT SUM((p.price + IFNULL(pa.price,0) - (IFNULL(pa.wholesale_price, p.wholesale_price)) + (IFNULL(pa.wholesale_price, p.wholesale_price))) * od.product_quantity) as totalproducts
FROM '._DB_PREFIX_.'orders o
LEFT JOIN '._DB_PREFIX_.'order_detail od ON od.id_order = o.id_order
LEFT JOIN '._DB_PREFIX_.'product p ON od.product_id = p.id_product
LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON od.product_attribute_id = pa.id_product_attribute
WHERE o.valid = 1 AND o.total_paid <> 0 AND o.date_add BETWEEN '.$dateBetween);
return $result['totalproducts'];
}

}

Jenysan · 12 сен 2013

Точнее кнопка експорта данных статистики прибыли в формате CSV

boltorez · 14 сен 2013

А не проще сделать это немодулем, а отдельным скриптом? Втулить просто кнопку в админку + инпуты даты и передавать постом данные в скрипт...

Jenysan · 15 сен 2013

Как вариянт хороший . Но в статистике смотреться к месту .

Модуль расчёта ПРИБЫЛИ для PrestaShop™ 1.5.5.0

Jenysan

Jenysan

boltorez

Jenysan