forked from PrestaShop/statsstock
-
Notifications
You must be signed in to change notification settings - Fork 0
/
statsstock.php
164 lines (150 loc) · 7.17 KB
/
statsstock.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
<?php
/*
* 2007-2015 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [email protected] so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <[email protected]>
* @copyright 2007-2015 PrestaShop SA
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
if (!defined('_PS_VERSION_')) {
exit;
}
class statsstock extends Module
{
private $html = '';
public function __construct()
{
$this->name = 'statsstock';
$this->tab = 'analytics_stats';
$this->version = '2.0.0';
$this->author = 'PrestaShop';
$this->need_instance = 0;
parent::__construct();
$this->displayName = $this->trans('Available quantities', array(), 'Modules.Statsstock.Admin');
$this->description = $this->trans('Enrich the ‘Stats’ section of your back office, add a tab showing the available quantities of products left for sale.', array(), 'Modules.Statsstock.Admin');
$this->ps_versions_compliancy = array('min' => '1.7.1.0', 'max' => _PS_VERSION_);
}
public function install()
{
return parent::install() && $this->registerHook('AdminStatsModules');
}
public function hookAdminStatsModules()
{
if (Tools::isSubmit('submitCategory')) {
$this->context->cookie->statsstock_id_category = Tools::getValue('statsstock_id_category');
}
$ru = AdminController::$currentIndex.'&module='.$this->name.'&token='.Tools::getValue('token');
$currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));
$filter = ((int)$this->context->cookie->statsstock_id_category ? ' AND p.id_product IN (SELECT cp.id_product FROM '._DB_PREFIX_.'category_product cp WHERE cp.id_category = '.(int)$this->context->cookie->statsstock_id_category.')' : '');
$sql = 'SELECT p.id_product, p.reference, pl.name,
IFNULL((
SELECT AVG(product_attribute_shop.wholesale_price)
FROM '._DB_PREFIX_.'product_attribute pa
'.Shop::addSqlAssociation('product_attribute', 'pa').'
WHERE p.id_product = pa.id_product
AND product_attribute_shop.wholesale_price != 0
), product_shop.wholesale_price) as wholesale_price,
IFNULL(stock.quantity, 0) as quantity
FROM '._DB_PREFIX_.'product p
'.Shop::addSqlAssociation('product', 'p').'
INNER JOIN '._DB_PREFIX_.'product_lang pl
ON (p.id_product = pl.id_product AND pl.id_lang = '.(int)$this->context->language->id.Shop::addSqlRestrictionOnLang('pl').')
'.Product::sqlStock('p', 0).'
WHERE 1 = 1
'.$filter;
$products = Db::getInstance()->executeS($sql);
foreach ($products as $key => $p) {
$products[$key]['stockvalue'] = $p['wholesale_price'] * $p['quantity'];
}
$this->html .= '
<script type="text/javascript">$(\'#calendar\').slideToggle();</script>
<div class="panel-heading">'
.$this->trans('Evaluation of available quantities for sale', array(), 'Modules.Statsstock.Admin').
'</div>
<form action="'.Tools::safeOutput($ru).'" method="post" class="form-horizontal">
<div class="row row-margin-bottom">
<label class="control-label col-lg-3">'.$this->trans('Category', array(), 'Admin.Global').'</label>
<div class="col-lg-6">
<select name="statsstock_id_category" onchange="this.form.submit();">
<option value="0">- '.$this->trans('All', array(), 'Admin.Global').' -</option>';
foreach (Category::getSimpleCategories($this->context->language->id) as $category) {
$this->html .= '<option value="'.(int)$category['id_category'].'" '.
($this->context->cookie->statsstock_id_category == $category['id_category'] ? 'selected="selected"' : '').'>'.
$category['name'].'
</option>';
}
$this->html .= '
</select>
<input type="hidden" name="submitCategory" value="1" />
</div>
</div>
</form>';
if (!count($products)) {
$this->html .= '<p>'.$this->trans('Your catalog is empty.', array(), 'Modules.Statsstock.Admin').'</p>';
} else {
$rollup = array('quantity' => 0, 'wholesale_price' => 0, 'stockvalue' => 0);
$this->html .= '
<table class="table">
<thead>
<tr>
<th><span class="title_box active">'.$this->trans('ID', array(), 'Admin.Global').'</span></th>
<th><span class="title_box active">'.$this->trans('Ref.', array(), 'Modules.Statsstock.Admin').'</span></th>
<th><span class="title_box active">'.$this->trans('Item', array(), 'Admin.Global').'</span></th>
<th><span class="title_box active">'.$this->trans('Available quantity for sale', array(), 'Admin.Global').'</span></th>
<th><span class="title_box active">'.$this->trans('Price*', array(), 'Modules.Statsstock.Admin').'</span></th>
<th><span class="title_box active">'.$this->trans('Value', array(), 'Admin.Global').'</span></th>
</tr>
</thead>
<tbody>';
foreach ($products as $product) {
$rollup['quantity'] += $product['quantity'];
$rollup['wholesale_price'] += $product['wholesale_price'];
$rollup['stockvalue'] += $product['stockvalue'];
$this->html .= '<tr>
<td>'.$product['id_product'].'</td>
<td>'.$product['reference'].'</td>
<td>'.$product['name'].'</td>
<td>'.$product['quantity'].'</td>
<td>'.Tools::displayPrice($product['wholesale_price'], $currency).'</td>
<td>'.Tools::displayPrice($product['stockvalue'], $currency).'</td>
</tr>';
}
$this->html .= '
</tbody>
<tfoot>
<tr>
<th colspan="3"></th>
<th><span class="title_box active">'.$this->trans('Total quantities', array(), 'Modules.Statsstock.Admin').'</span></th>
<th><span class="title_box active">'.$this->trans('Average price', array(), 'Admin.Global').'</span></th>
<th><span class="title_box active">'.$this->trans('Total value', array(), 'Modules.Statsstock.Admin').'</span></th>
</tr>
<tr>
<td colspan="3"></td>
<td>'.$rollup['quantity'].'</td>
<td>'.Tools::displayPrice($rollup['wholesale_price'] / count($products), $currency).'</td>
<td>'.Tools::displayPrice($rollup['stockvalue'], $currency).'</td>
</tr>
</tfoot>
</table>
<i class="icon-asterisk"></i> '.$this->trans('This section corresponds to the default wholesale price according to the default supplier for the product. An average price is used when the product has attributes.', array(), 'Modules.Statsstock.Admin');
return $this->html;
}
}
}