Здравствуйте ! Ребята , прошу помощи в разработке модуля для статистики, расчёта прибыли . Я плохо разбераюсь в написание модуля для ПШ любая помощь приветствуется любой кусочек программы сделаем модуль БСПЛАТНО . Подскажите с чего начать ? . Планирую сделать вот так . Таблица , Картинка товара ,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 .= '<p>'.$this->l('Total profit:').' '.Tools::displayPrice($totalprofit, $currency).'</p>'; $this->_html .= '<p>'.$this->l('Total discount:').' '.Tools::displayPrice($totaldiscount, $currency).'</p>'; $this->_html .= '<p>'.$this->l('Total shipping:').' '.Tools::displayPrice($totalshipping, $currency).'</p>'; $this->_html .= '<p>'.$this->l('Total product sales:').' '.Tools::displayPrice($totalproducts, $currency).'</p>'; $this->_html .= '<p><a href="profit.csv">'.$this->l('Download CSV').'</a></p>'; //$this->_html .= '<p>'.$this->l('Date:').' '.$date.'</p>'; 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']; } }
А не проще сделать это немодулем, а отдельным скриптом? Втулить просто кнопку в админку + инпуты даты и передавать постом данные в скрипт...
