Spade
Mini Shell
| Directory:~$ /home/lmsyaran/public_html/joomla4/ |
| [Home] [System Details] [Kill Me] |
hikashopmassaction.php000064400000261610151162042500011147
0ustar00<?php
/**
* @package HikaShop for Joomla!
* @version 4.4.1
* @author hikashop.com
* @copyright (C) 2010-2021 HIKARI SOFTWARE. All rights reserved.
* @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
*/
defined('_JEXEC') or die('Restricted access');
?><?php
if(!defined('DS'))
define('DS',DIRECTORY_SEPARATOR);
jimport('joomla.plugin.plugin');
class plgSystemHikashopmassaction extends JPlugin {
function __construct(&$subject, $config){
parent::__construct($subject, $config);
if(!isset($this->params)){
$plugin = JPluginHelper::getPlugin('system',
'hikashopmassaction');
$this->params = new JRegistry(@$plugin->params);
}
}
function onMassactionTableTriggersLoad(&$table, &$triggers,
&$triggers_html, &$loadedData) {
$triggers['onHikashopCronTriggerMinutes']=JText::_('EVERY_MINUTES');
$triggers['onHikashopCronTriggerHours']=JText::_('EVERY_HOURS');
$triggers['onHikashopCronTriggerDays']=JText::_('EVERY_DAYS');
$triggers['onHikashopCronTriggerWeeks']=JText::_('EVERY_WEEKS');
$triggers['onHikashopCronTriggerMonths']=JText::_('EVERY_MONTHS');
$triggers['onHikashopCronTriggerYears']=JText::_('EVERY_YEARS');
}
function
onMassactionTableFiltersLoad(&$table,&$filters,&$filters_html,&$loadedData){
$db = JFactory::getDBO();
$operators = hikashop_get('type.operators');
$cid = hikashop_getCID();
$tables = array();
$custom = '';
$type = 'filter';
$massactionClass = hikashop_get('class.massaction');
if(empty($loadedData->massaction_filters)){
$loadedData->massaction_filters = array();
}
if(!HIKASHOP_J30){
$fieldsTable = $db->getTableFields('#__hikashop_user');
$hkUsers = reset($fieldsTable);
$fieldsTable = $db->getTableFields('#__users');
$jUsers = reset($fieldsTable);
} else {
$hkUsers = $db->getTableColumns('#__hikashop_user');
$jUsers = $db->getTableColumns('#__users');
}
ksort($hkUsers);
ksort($jUsers);
if($table->table == 'address')
$tables = array('address','user');
if($table->table == 'category')
$tables = array('category','parent_category');
if($table->table == 'order')
$tables =
array('order','order_product','address','user');
if($table->table == 'product')
$tables =
array('product','price','category','characteristic','product_related','product_option');
if($table->table == 'user')
$tables = array('user','address');
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->type =
$table->table;
$loadedData->massaction_filters['__num__']->data =
array();
$loadedData->massaction_filters['__num__']->data['type']
= '';
$loadedData->massaction_filters['__num__']->data['operator']
= '';
$loadedData->massaction_filters['__num__']->data['value']
= '';
$loadedData->massaction_filters['__num__']->name =
'';
$loadedData->massaction_filters['__num__']->html =
'';
foreach($loadedData->massaction_filters as $key => &$value) {
if(!isset($value->data['type']))
$value->data['type'] = '';
if(!isset($value->data['operator']))
$value->data['operator'] = '=';
if(!isset($value->data['value']))
$value->data['value'] = '';
if(!isset($value->data['address']))
$value->data['address'] = '';
if(!empty($tables)){
if(!is_array($tables)) $tables = array($tables);
foreach($tables as $relatedTable){
$column = $relatedTable.'Column';
$loadedData->massaction_filters['__num__']->name =
$column;
$filters[$column]=JText::_(''.strtoupper($relatedTable).'_COLUMN');
if($relatedTable == 'product_option') $relatedTable =
'product_related';
if($relatedTable == 'parent_category') $relatedTable =
'category';
if(!HIKASHOP_J30){
$fieldsTable =
$db->getTableFields('#__hikashop_'.$relatedTable);
$fields = reset($fieldsTable);
} else {
$fields =
$db->getTableColumns('#__hikashop_'.$relatedTable);
}
ksort($fields);
$typeField = array();
if(!empty($fields)) {
foreach($fields as $oneField => $fieldType){
$typeField[] =
JHTML::_('select.option',$oneField,$oneField);
}
}
$user = '<select class="custom-select chzn-done
not-processed"
name="filter['.$table->table.']['.$key.'][userColumn][type]"
onchange="countresults(\''.$table->table.'\','.$key.')"
>';
$user .='<optgroup label="HIKA_USER">';
foreach($hkUsers as $key2 => $hkUser){
$tmpVal =
str_replace('hk_user.','',$value->data['type']);
if($key2 == $tmpVal)
$user .= '<option
value="hk_user.'.$key2.'"
selected="selected">'.$key2.'</option>';
else
$user .= '<option
value="hk_user.'.$key2.'">'.$key2.'</option>';
}
$user .= '</optgroup>';
$user .='<optgroup label="JOOMLA_USER">';
foreach($jUsers as $key2 => $jUser){
$tmpVal =
str_replace('joomla_user.','',$value->data['type']);
if($key2 == $tmpVal)
$user .= '<option
value="joomla_user.'.$key2.'"
selected="selected">'.$key2.'</option>';
else
$user .= '<option
value="joomla_user.'.$key2.'">'.$key2.'</option>';
}
$user .= '</optgroup>';
$user .= '</select>';
switch($table->table){
case 'product':
if($relatedTable == 'characteristic'){
$db->setQuery('SELECT * FROM
'.hikashop_table('characteristic').' WHERE
characteristic_parent_id = 0');
$characteristics = $db->loadObjectList();
if(is_array($characteristics)){
$custom = '<select class="custom-select chzn-done
not-processed"
name="filter['.$table->table.']['.$key.'][characteristicColumn][type]"
onchange="countresults('.$table->table.','.$key.')"
>';
foreach($characteristics as $charact){
$selected = '';
if($charact->characteristic_value ==
$value->data['type']) $selected =
'selected="selected"';
$custom .= '<option
value="'.$charact->characteristic_value.'"
'.$selected.'>'.$charact->characteristic_value.'</option>';
}
$custom .= '</select>';
}
}
elseif(in_array($relatedTable,
array('product_related','product_option'))){
if(!HIKASHOP_J30){
$fieldsTable =
$db->getTableFields('#__hikashop_product');
$fields = reset($fieldsTable);
} else {
$fields =
$db->getTableColumns('#__hikashop_product');
}
ksort($fields);
$typeField = array();
if(!empty($fields)) {
foreach($fields as $oneField => $fieldType){
$typeField[] =
JHTML::_('select.option',$oneField,$oneField);
}
}
$custom = JHTML::_('select.genericlist', $typeField,
"filter[".$table->table."][$key][".$column."][type]",
'class="custom-select chzn-done not-processed"
onchange="countresults(\''.$table->table.'\','.$key.')"
size="1"', 'value',
'text',$value->data['type']);
}else{
$custom = '';
}
break;
case 'category':
$custom = '';
break;
case 'order':
if($relatedTable == 'address'){
$datas = array('both' =>
'DISPLAY_BOTH','bill' =>
'HIKASHOP_BILLING_ADDRESS','ship' =>
'HIKASHOP_SHIPPING_ADDRESS');
$custom = '<select class="custom-select chzn-done
not-processed"
onchange="countresults(\''.$table->table.'\','.$key.')"
name="filter['.$table->table.']['.$key.'][addressColumn][address]"
>';
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['address']) $selected =
'selected="selected"';
$custom .= '<option value="'.$k.'"
'.$selected.'>'.JText::sprintf(''.$data.'').'</option>';
}
$custom .= '</select>';
}elseif($relatedTable == 'user'){
$custom = $user;
}else{
$custom = '';
}
break;
case 'user':
if($relatedTable == 'user'){
$custom = $user;
}else{
$custom = '';
}
break;
case 'address':
if($relatedTable == 'user'){
$custom = $user;
}else{
$custom = '';
}
break;
}
if($value->name != $column || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = $relatedTable;
$output = $custom;
if(!in_array($relatedTable,
array('characteristic','product_related','user'))){
$output .= JHTML::_('select.genericlist', $typeField,
"filter[".$table->table."][".$key."][".$column."][type]",
'class="custom-select chzn-done not-processed"
onchange="countresults(\''.$table->table.'\',\''.$key.'\')"
size="1"', 'value', 'text',
$value->data['type']);
}
$operators->extra =
'onchange="countresults(\''.$table->table.'\',\''.$key.'\')"';
$output .=
$operators->display('filter['.$table->table.']['.$key.']['.$column.'][operator]',$value->data['operator'],
"chzn-done not-processed");
$output .= ' <input class="inputbox"
type="text"
name="filter['.$table->table.']['.$key.']['.$column.'][value]"
size="50"
value="'.htmlspecialchars($value->data['value'],
ENT_COMPAT, 'UTF-8').'"
onchange="countresults(\''.$table->table.'\',\''.$key.'\')"
/>';
$filters_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
}
}
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->name =
'limit';
$loadedData->massaction_filters['__num__']->type =
$table->table;
$loadedData->massaction_filters['__num__']->data =
array();
$loadedData->massaction_filters['__num__']->data['start']
= '0';
$loadedData->massaction_filters['__num__']->data['value']
= '500';
$loadedData->massaction_filters['__num__']->html =
'';
foreach($loadedData->massaction_filters as $key => &$value)
{
if($value->name != 'limit' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = $table->table;
if(!isset($value->data['start']))
$value->data['start'] = 0;
if(!isset($value->data['value']))
$value->data['value'] = 500;
$output = '<div
id="'.$table->table.'filter'.$key.'limit">'.JText::_('HIKA_START').'
: <input type="text"
name="filter['.$table->table.']['.$key.'][limit][start]"
value="'.$value->data['start'].'" />
'.JText::_('VALUE').' : <input type="text"
name="filter['.$table->table.']['.$key.'][limit][value]"
value="'.$value->data['value'].'"/>'.'</div>';
$filters_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$filters['ordering']=JText::_('ORDERING');
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->name =
'ordering';
$loadedData->massaction_filters['__num__']->type =
$table->table;
$loadedData->massaction_filters['__num__']->data =
array();
$loadedData->massaction_filters['__num__']->data['value']
= '';
$loadedData->massaction_filters['__num__']->html =
'';
foreach($loadedData->massaction_filters as $key => &$value)
{
if($value->name != 'ordering' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = $table->table;
if(!isset($value->data['value']))
$value->data['value'] = $table->table.'_id';
if(!HIKASHOP_J30) {
$fieldsTable =
$db->getTableFields('#__hikashop_'.$table->table);
$fields = reset($fieldsTable);
} else {
$fields =
$db->getTableColumns('#__hikashop_'.$table->table);
}
ksort($fields);
if(!isset($value->data['value']))
$value->data['value'] = $table->table.'_id';
$output = '<div
id="'.$table->table.'filter'.$key.'ordering">'.JText::_('VALUE').'
: ';
$output .= '<select class="custom-select chzn-done
not-processed"
name="filter['.$table->table.']['.$key.'][ordering][value]">';
foreach($fields as $field => $fieldType){
$selected = '';
if($value->data['value'] == $field)
$selected = 'selected="selected"';
$output .= '<option value="'.$field.'"
'.$selected.'>'.$field.'</option>';
}
$output .= '</select></div>';
$filters_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$filters['direction']=JText::_('MASSACTION_ORDERING_DIRECTION');
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->name =
'direction';
$loadedData->massaction_filters['__num__']->type =
$table->table;
$loadedData->massaction_filters['__num__']->data =
array();
$loadedData->massaction_filters['__num__']->data['value']
= '';
$loadedData->massaction_filters['__num__']->html =
'';
foreach($loadedData->massaction_filters as $key => &$value)
{
if($value->name != 'direction' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = $table->table;
if(!isset($value->data['value']))
$value->data['value'] = 'ASC';
$output = '<div
id="'.$table->table.'filter'.$key.'direction">'.JText::_('VALUE').'
: <select class="custom-select chzn-done not-processed"
name="filter['.$table->table.']['.$key.'][direction][value]">';
$values = array('ASC','DESC');
foreach($values as $oneValue){
$selected = '';
if($value->data['value'] == $oneValue)
$selected = 'selected="selected"';
$output .= '<option value="'.$oneValue.'"
'.$selected.'>'.$oneValue.'</option>';
}
$output .= '</select>'.'</div>';
$filters_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
if(hikashop_level(2)){
if(in_array($table->table,array('product','category'))){
$filters['accessLevel']=JText::_('ACCESS_LEVEL');
}else{
$filters['accessLevel']=JText::_('USER_WITH_ACL');
}
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->name =
'accessLevel';
$loadedData->massaction_filters['__num__']->type =
$table->table;
$loadedData->massaction_filters['__num__']->data =
array();
$loadedData->massaction_filters['__num__']->data['type']
= '';
$loadedData->massaction_filters['__num__']->data['group']
= '';
$loadedData->massaction_filters['__num__']->html =
'';
$db = JFactory::getDBO();
$db->setQuery('SELECT a.*, a.title as text, a.id as value FROM
#__usergroups AS a ORDER BY a.lft ASC');
$groups = $db->loadObjectList('id');
foreach($groups as $id => $group){
if(isset($groups[$group->parent_id])){
$groups[$id]->level =
intval(@$groups[$group->parent_id]->level) + 1;
$groups[$id]->text = str_repeat('- -
',$groups[$id]->level).$groups[$id]->text;
}
}
$inoperator = hikashop_get('type.operatorsin');
foreach($loadedData->massaction_filters as $key => &$value)
{
if($value->name != 'accessLevel' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = $table->table;
$inoperator->js =
'onchange="countresults(\''.$table->table.'\','.$key.')"';
$output =
$inoperator->display("filter[".$table->table."][$key][accessLevel][type]",$value->data['type'],
'chzn-done not-processed').'
'.JHTML::_('select.genericlist', $groups,
"filter[".$table->table."][$key][accessLevel][group]",
'class="custom-select chzn-done not-processed"
size="1"
onchange="countresults(\''.$table->table.'\','.$key.')"',
'value', 'text',$value->data['group']);
$filters_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
}
?>
<script type="text/javascript">
function hikashop_verifycsvcolumns(k){
var target = "productfilter"+k+"csvImport_verify";
var url = "<?php echo
hikashop_completeLink('massaction&task=displayassociate&tmpl=component',false,false,true);
?>";
var data = "cid=<?php echo hikashop_getCID();
?>¤t_filter="+k+"&csv_path=" +
encodeURIComponent(document.getElementById("productfilter"+k+"csvImport_path_value").value);
if(data != ""){
window.Oby.xRequest(url, {update: target, mode: "POST", data:
data});
}
}
function hikashop_switchmode(el,k) {
var d = document, v = el.value, modes =
['upload','path'], e = null;
for(var i = 0; i < modes.length; i++) {
mode = modes[i];
e =
d.getElementById('productfilter'+k+'csvImport_'+mode);
if(!e) continue;
if(v == mode) {
e.style.display = '';
} else {
e.style.display = 'none';
}
if(v != 'upload'){
d.getElementById('productfilter'+k+'csvImport_path').style.display
= '';
d.getElementById('productfilter'+k+'csvImport_upload').style.display
= 'none';
}else{
d.getElementById('productfilter'+k+'csvImport_path').style.display
= 'none';
d.getElementById('productfilter'+k+'csvImport_upload').style.display
= '';
}
}
}
</script>
<?php
}
function
onMassactionTableActionsLoad(&$table,&$actions,&$actions_html,&$loadedData){
$db = JFactory::getDBO();
$dispTables = array();
$updTables = array();
$customCheckboxes = '';
$database = JFactory::getDBO();
$type = 'action';
if(empty($loadedData->massaction_filters)){
$loadedData->massaction_filters = array();
}
$massactionClass = hikashop_get('class.massaction');
$nameboxType = hikashop_get('type.namebox');
$actions['displayResults']=JText::_('DISPLAY_RESULTS');
$actions['exportCsv']=JText::_('EXPORT_CSV');
$actions['updateValues']=JText::_('UPDATE_VALUES');
$actions['deleteElements']=JText::_('DELETE_ELEMENTS');
$actions['sendEmail']=JText::_('MASS_SEND_EMAIL');
switch($table->table){
case 'product':
$dispTables =
array('product','price','category');
$updTables = array('product','price');
$actions['updateCategories']=JText::_('UPDATE_CATEGORIES');
$actions['updateRelateds']=JText::_('UPDATE_RELATEDS');
$actions['updateOptions']=JText::_('UPDATE_OPTIONS');
$actions['updateCharacteristics']=JText::_('UPDATE_CHARACTERISTICS');
$actions['setCanonical']=JText::_('HK_SET_CANONICAL');
break;
case 'category':
$dispTables = array('category');
$updTables = array('category');
break;
case 'order':
$dispTables =
array('order','order_product','address','user','joomla_users');
$updTables = array('order','order_product');
$actions['changeStatus']=JText::_('CHANGE_STATUS');
$actions['addProduct']=JText::_('ADD_EXISTING_PRODUCT');
$actions['changeGroup']=JText::_('CHANGE_USER_GROUP');
break;
case 'user':
$dispTables =
array('user','joomla_users','address');
$updTables = array('user','joomla_users');
$actions['changeGroup']=JText::_('CHANGE_USER_GROUP');
break;
case 'address':
$dispTables =
array('address','user','joomla_users');
$updTables = array('address');
break;
case 'user':
$dispTables =
array('user','joomla_users','address');
$updTables = array('user','joomla_users');
default:
return false;
break;
}
$actions['mysqlQuery']=JText::_('RUN_MYSQL_QUERY');
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->data =
array('type' => '','value' =>
'','operation' => '');
$loadedData->massaction_actions['__num__']->name =
'mysqlQuery';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'mysqlQuery' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$output = ' <textarea
name="action['.$table->table.']['.$key.'][mysqlQuery][query]"
rows="15" cols="100">'.
htmlspecialchars(@$value->data['query'], ENT_COMPAT,
'UTF-8').'</textarea>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
if(is_array($dispTables)){
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->data =
array();
$loadedData->massaction_actions['__num__']->name =
'displayResults';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'displayResults' || ($table->table
!= $loadedData->massaction_table && is_int($key)))
continue;
$value->type = $dispTables[0];
$margin = '';
$output = '';
$customCheckboxes='';
foreach($dispTables as $relatedTable){
if(!HIKASHOP_J30){
if(preg_match('/joomla_/',$relatedTable)) $fieldsTable =
$db->getTableFields('#__'.str_replace('joomla_','',$relatedTable));
else $fieldsTable =
$db->getTableFields('#__hikashop_'.$relatedTable);
$fields = reset($fieldsTable);
} else {
if(preg_match('/joomla_/',$relatedTable)) $fields =
$db->getTableColumns('#__'.str_replace('joomla_','',$relatedTable));
else $fields =
$db->getTableColumns('#__hikashop_'.$relatedTable);
}
if(!empty($fields)) {
$output .= '<div
id="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_div"
class="hika_massaction_checkbox"> <a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a>
<br/>';
foreach($fields as $key2 => $field){
if($key2 == 'address_state'){
$fields['zone_state_name'] = $field;
$fields['zone_state_name_english'] = $field;
$fields['zone_state_code_2'] = $field;
$fields['zone_state_code_3'] = $field;
}elseif($key2 == 'address_country'){
$fields['zone_country_name'] = $field;
$fields['zone_country_name_english'] = $field;
$fields['zone_country_code_2'] = $field;
$fields['zone_country_code_3'] = $field;
}
}
ksort($fields);
foreach($fields as $key2 => $field){
$checked='';
if(isset($value->data[$relatedTable]) &&
isset($value->data[$relatedTable][$key2])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'"
name="action['.$table->table.']['.$key.'][displayResults]['.$relatedTable.']['.$key2.']"
value="'.$key2.'" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'">'.$key2.'</label><br/>';
}
if($relatedTable == 'order'){
$key2 = 'order_tax_amount';
$checked='';
if(isset($value->data[$relatedTable]) &&
isset($value->data[$relatedTable][$key2])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'"
name="action['.$table->table.']['.$key.'][displayResults]['.$relatedTable.']['.$key2.']"
value="'.$key2.'" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'">'.$key2.'</label><br/>';
$key2 = 'order_tax_namekey';
$checked='';
if(isset($value->data[$relatedTable]) &&
isset($value->data[$relatedTable][$key2])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'"
name="action['.$table->table.']['.$key.'][displayResults]['.$relatedTable.']['.$key2.']"
value="'.$key2.'" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_'.$relatedTable.'Column_'.$key2.'">'.$key2.'</label><br/>';
}
$output .= '</div>';
$margin = 'margin-left: 20px;';
}
}
switch($table->table){
case 'product':
$db->setQuery('SELECT * FROM
'.hikashop_table('characteristic').' WHERE
characteristic_parent_id = 0');
$characteristics = $db->loadObjectList();
if(is_array($characteristics)){
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_displayResults_characteristicColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_characteristicColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_characteristicColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/>';
foreach($characteristics as $characteristic){
$checked='';
if(isset($value->data['characteristic'][$characteristic->characteristic_value])){
$checked='checked="checked"';
}
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_characteristicColumn_'.$characteristic->characteristic_value.'"
name="action['.$table->table.']['.$key.'][displayResults][characteristic]['.$characteristic->characteristic_value.']"
value="'.$characteristic->characteristic_value.'"
/><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_characteristicColumn_'.$characteristic->characteristic_value.'">'.$characteristic->characteristic_value.'</label><br/>';
}
$customCheckboxes .= '</div>';
}
$db->setQuery('SELECT * FROM
'.hikashop_table('product_related'));
$relateds = $db->loadObjectList();
if(is_array($relateds)){
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_displayResults_relatedColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_relatedColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_displayResults_relatedColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/>';
$displayed = array();
foreach($relateds as $related){
$checked='';
if(isset($value->data['related'][$related->product_related_type])){
$checked='checked="checked"';
}
if(!in_array($related->product_related_type, $displayed))
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_relatedColumn_'.$related->product_related_type.'"
name="action['.$table->table.']['.$key.'][displayResults][related]['.$related->product_related_type.']"
value="'.$related->product_related_type.'"
/><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_relatedColumn_'.$related->product_related_type.'">'.$related->product_related_type.'</label><br/>';
$displayed[] = $related->product_related_type;
}
$customCheckboxes .= '</div>';
}
break;
case 'user':
$checked='';
if(isset($value->data['usergroups'])){
$checked='checked="checked"';
}
$customCheckboxes .= '<div
class="hika_massaction_checkbox">';
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_displayResults_usergroupsColumn_title"
name="action['.$table->table.']['.$key.'][displayResults][usergroups][title]"
value="usergroups" /><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_displayResults_usergroupsColumn_title">'.JText::_('GROUP_NAME').'</label><br/>';
$customCheckboxes .= '</div>';
break;
}
$output .= $customCheckboxes;
$output .= '<div
style="clear:both;"></div>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->data =
array('path'=>'');
$loadedData->massaction_actions['__num__']->name =
'exportCsv';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'exportCsv' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
if(!isset($value->data['formatExport']['path']))
$value->data['formatExport']['path'] =
'';
if(!isset($value->data['formatExport']['email']))
$value->data['formatExport']['email'] =
'';
$output='';
$margin = '';
$customCheckboxes='';
foreach($dispTables as $relatedTable){
if(!HIKASHOP_J30){
if(preg_match('/joomla_/',$relatedTable)) $fieldsTable =
$db->getTableFields('#__'.str_replace('joomla_','',$relatedTable));
else $fieldsTable =
$db->getTableFields('#__hikashop_'.$relatedTable);
$fields = reset($fieldsTable);
} else {
if(preg_match('/joomla_/',$relatedTable)) $fields =
$db->getTableColumns('#__'.str_replace('joomla_','',$relatedTable));
else $fields =
$db->getTableColumns('#__hikashop_'.$relatedTable);
}
if(!empty($fields)) {
$output .= '<div
id="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_div"
class="hika_massaction_checkbox"> <a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a>
<br/>';
foreach($fields as $key2 => $field){
if($key2 == 'address_state'){
$fields['zone_state_name'] = $field;
$fields['zone_state_name_english'] = $field;
$fields['zone_state_code_2'] = $field;
$fields['zone_state_code_3'] = $field;
}elseif($key2 == 'address_country'){
$fields['zone_country_name'] = $field;
$fields['zone_country_name_english'] = $field;
$fields['zone_country_code_2'] = $field;
$fields['zone_country_code_3'] = $field;
}
}
ksort($fields);
foreach($fields as $key2 => $field){
$checked='';
if(isset($value->data[$relatedTable]) &&
isset($value->data[$relatedTable][$key2])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_'.$key2.'"
name="action['.$table->table.']['.$key.'][exportCsv]['.$relatedTable.']['.$key2.']"
value="'.$key2.'" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_'.$key2.'">'.$key2.'</label><br/>';
}
if($relatedTable == 'order'){
$key2 = 'order_full_tax';
$checked='';
if(isset($value->data[$relatedTable]) &&
isset($value->data[$relatedTable][$key2])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_'.$key2.'"
name="action['.$table->table.']['.$key.'][exportCsv]['.$relatedTable.']['.$key2.']"
value="'.$key2.'" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_'.$key2.'">'.$key2.'</label><br/>';
}
if($relatedTable == 'price'){
$checked='';
if(isset($value->data[$relatedTable]) &&
!empty($value->data[$relatedTable]['price_value_with_tax'])){
$checked='checked="checked"';
}
$output .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_price_value_with_tax"
name="action['.$table->table.']['.$key.'][exportCsv]['.$relatedTable.'][price_value_with_tax]"
value="price_value_with_tax" /><label style="width:
100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_'.$relatedTable.'Column_price_value_with_tax">price_value_with_tax</label><br/>';
}
$output .= '</div>';
$margin = 'margin-left: 20px;';
}
}
switch($table->table){
case 'product':
$db->setQuery('SHOW COLUMNS FROM
'.hikashop_table('file'));
$imageColumns = $db->loadObjectList();
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_exportCsv_filesColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_filesColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_filesColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/><b>'.JText::_('FILES').'</b><br/>';
foreach($imageColumns as $imageColumn){
$checked='';
if(isset($value->data['files'][$imageColumn->Field])){
$checked='checked="checked"';
}
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_filesColumn_'.$imageColumn->Field.'"
name="action['.$table->table.']['.$key.'][exportCsv][files]['.$imageColumn->Field.']"
value="'.$imageColumn->Field.'" /><label
style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_filesColumn_'.$imageColumn->Field.'">'.$imageColumn->Field.'</label><br/>';
}
$customCheckboxes .= '</div>';
$db->setQuery('SHOW COLUMNS FROM
'.hikashop_table('file'));
$imageColumns = $db->loadObjectList();
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_exportCsv_imagesColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_imagesColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_imagesColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/><b>'.JText::_('HIKA_IMAGES').'</b><br/>';
foreach($imageColumns as $imageColumn){
$checked='';
if(isset($value->data['images'][$imageColumn->Field])){
$checked='checked="checked"';
}
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_imagesColumn_'.$imageColumn->Field.'"
name="action['.$table->table.']['.$key.'][exportCsv][images]['.$imageColumn->Field.']"
value="'.$imageColumn->Field.'" /><label
style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_imagesColumn_'.$imageColumn->Field.'">'.$imageColumn->Field.'</label><br/>';
}
$customCheckboxes .= '</div>';
$db->setQuery('SELECT * FROM
'.hikashop_table('characteristic').' WHERE
characteristic_parent_id = 0');
$characteristics = $db->loadObjectList();
if(is_array($characteristics)){
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_exportCsv_characteristicColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_characteristicColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_characteristicColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/>';
foreach($characteristics as $characteristic){
$checked='';
if(isset($value->data['characteristic'][$characteristic->characteristic_value])){
$checked='checked="checked"';
}
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_characteristicColumn_'.$characteristic->characteristic_value.'"
name="action['.$table->table.']['.$key.'][exportCsv][characteristic]['.$characteristic->characteristic_value.']"
value="'.$characteristic->characteristic_value.'"
/><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_characteristicColumn_'.$characteristic->characteristic_value.'">'.$characteristic->characteristic_value.'</label><br/>';
}
$customCheckboxes .= '</div>';
}
$db->setQuery('SELECT * FROM
'.hikashop_table('product_related'));
$relateds = $db->loadObjectList();
if(is_array($relateds)){
$customCheckboxes .= '<div
id="action_'.$table->table.'_'.$key.'_exportCsv_relatedColumn_div"
class="hika_massaction_checkbox"><a style="cursor:
pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_relatedColumn_div\',\'check\');">'.JText::_('SELECT_ALL').'</a>
/ <a style="cursor: pointer;"
onclick="checkAll(\'action_'.$table->table.'_'.$key.'_exportCsv_relatedColumn_div\',\'uncheck\');">'.JText::_('UNSELECT_ALL').'</a><br/>';
$displayed = array();
foreach($relateds as $related){
$checked='';
if(isset($value->data['related'][$related->product_related_type])){
$checked='checked="checked"';
}
if(!in_array($related->product_related_type, $displayed))
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_relatedColumn_'.$related->product_related_type.'"
name="action['.$table->table.']['.$key.'][exportCsv][related]['.$related->product_related_type.']"
value="'.$related->product_related_type.'"
/><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_relatedColumn_'.$related->product_related_type.'">'.$related->product_related_type.'</label><br/>';
$displayed[] = $related->product_related_type;
}
$customCheckboxes .= '</div>';
}
break;
case 'user':
$checked='';
if(isset($value->data['usergroups'])){
$checked='checked="checked"';
}
$customCheckboxes .= '<div
class="hika_massaction_checkbox">';
$customCheckboxes .= '<input type="checkbox"
'.$checked.'
id="action_'.$table->table.'_'.$key.'_exportCsv_usergroupsColumn_title"
name="action['.$table->table.']['.$key.'][exportCsv][usergroups][title]"
value="usergroups" /><label style="width: 100%;"
for="action_'.$table->table.'_'.$key.'_exportCsv_usergroupsColumn_title">'.JText::_('GROUP_NAME').'</label><br/>';
$customCheckboxes .= '</div>';
break;
}
$output .= $customCheckboxes;
$output .= '<div
style="clear:both;"></div>';
$checked='';
if(isset($value->data['formatExport']['format'])
&&
$value->data['formatExport']['format']=='xls')
$checked='checked="checked"';
$output .='<input type="radio"
id="action'.$table->table.''.$key.'exportCsvformatExportformatcsv"
name="action['.$table->table.']['.$key.'][exportCsv][formatExport][format]"
checked value="csv"> <label
for="action'.$table->table.''.$key.'exportCsvformatExportformatcsv">'.JText::_('CSV').'</label>
<input type="radio"
id="action'.$table->table.''.$key.'exportCsvformatExportformatxls"
name="action['.$table->table.']['.$key.'][exportCsv][formatExport][format]"
'.$checked.' value="xls"> <label
for="action'.$table->table.''.$key.'exportCsvformatExportformatxls">'.JText::_('XLS').'</label>';
if($table->table == 'order') {
$checked='';
if(isset($value->data['formatExport']['oneProductPerRow']))
$checked='checked="checked"';
$output .= '<br/>'.'<input
type="checkbox"
id="action'.$table->table.''.$key.'exportCsvOneProductPerRow"
name="action['.$table->table.']['.$key.'][exportCsv][formatExport][oneProductPerRow]"
'. $checked.' value="1"> <label
for="action'.$table->table.''.$key.'exportCsvOneProductPerRow">'.JText::_('ONE_PRODUCT_PER_ROW').'</label>';
}
$output .=
'<br/>'.JText::_('EXPORT_PATH').': <input
type="text"
name="action['.$table->table.']['.$key.'][exportCsv][formatExport][path]"
value="'.$value->data['formatExport']['path'].'"
/>';
$output .=
'<br/>'.JText::_('TO_ADDRESS').': <input
type="text"
name="action['.$table->table.']['.$key.'][exportCsv][formatExport][email]"
value="'.$value->data['formatExport']['email'].'"
/> '.JText::_('FILL_PATH_TO_USE_EMAIL');
$output .= '<div
style="clear:both;"></div>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->data =
array('type' => '','value' =>
'','operation' => '');
$loadedData->massaction_actions['__num__']->name =
'updateValues';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'updateValues' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$output='';
$typeField = array();
foreach($updTables as $relatedTable){
if(!HIKASHOP_J30){
if(preg_match('/joomla_/',$relatedTable)){
$fieldsTable =
$db->getTableFields('#__'.str_replace('joomla_','',$relatedTable));
$fields = reset($fieldsTable);
foreach($fields as $key2 => $field){
$fields[$relatedTable.'_'.$key2] = $fields[$key2];
unset($fields[$key2]);
}
$fieldsTable = $fields;
}
else{
$fieldsTable =
$db->getTableFields('#__hikashop_'.$relatedTable);
$fields = reset($fieldsTable);
}
} else {
if(preg_match('/joomla_/',$relatedTable)){
$fields =
$db->getTableColumns('#__'.str_replace('joomla_','',$relatedTable));
foreach($fields as $key2 => $field){
$fields[$relatedTable.'_'.$key2] = $fields[$key2];
unset($fields[$key2]);
}
}
else $fields =
$db->getTableColumns('#__hikashop_'.$relatedTable);
}
ksort($fields);
$typeField[] = JHTML::_('select.option',
'<OPTGROUP>',JText::_(strtoupper($relatedTable)));
if(!empty($fields)) {
foreach($fields as $key2 => $field){
$typeField[] = JHTML::_('select.option',$key2,$key2);
}
}
$typeField[] = JHTML::_('select.option',
'</OPTGROUP>');
}
$selected1='';$selected2='';$selected3='';$selected4='';
$operations=array('int', 'float',
'string', 'operation');
$options='';
foreach($operations as $op){
$selected='';
if($op==$value->data['operation'])
$selected='selected="selected"';
$options .='<option '.$selected.'
value="'.$op.'">'.JText::_(strtoupper($op)).'</option>';
}
$output .= JHTML::_('select.genericlist', $typeField,
"action[".$table->table."][".$key."][updateValues][type]",
'class="custom-select chzn-done not-processed"
size="1"', 'value', 'text',
$value->data['type']);
$output .= ' = <select class="custom-select chzn-done
not-processed" onchange="if(this.value ==
\'operation\'){document.getElementById(\'updateValues_message\').style.display
= \'inline\';}"
name="action['.$table->table.']['.$key.'][updateValues][operation]">
'.$options.'
</select>';
$output .= ' <input class="inputbox"
type="text"
name="action['.$table->table.']['.$key.'][updateValues][value]"
size="50" value="'.
htmlspecialchars($value->data['value'], ENT_COMPAT,
'UTF-8').'" />';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'deleteElements';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'deleteElements' || ($table->table
!= $loadedData->massaction_table && is_int($key)))
continue;
$output = JText::_('DELETE_FILTERED_ELEMENTS'); //'This
will delete all the elements returned in the filter.';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->data =
array('emailAddress' => '','emailSubject'
=> '','bodyData' => '');
$loadedData->massaction_actions['__num__']->name =
'sendEmail';
$loadedData->massaction_actions['__num__']->html =
'';
foreach($loadedData->massaction_actions as $key => &$value) {
if($value->name != 'sendEmail' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
if(!isset($value->data['emailAddress']))
$value->data['emailAddress'] = '';
if(!isset($value->data['emailSubject']))
$value->data['emailSubject'] = '';
if(!isset($value->data['bodyData']))
$value->data['bodyData'] = '';
$output .=
'<br/>'.JText::_('TO_ADDRESS').': <input
type="text"
name="action['.$table->table.']['.$key.'][sendEmail][emailAddress]"
value="'.$value->data['emailAddress'].'"
/>';
$output .=
'<br/>'.JText::_('EMAIL_SUBJECT').':
<input type="text"
name="action['.$table->table.']['.$key.'][sendEmail][emailSubject]"
value="'.$value->data['emailSubject'].'"
/>';
$output .=
'<br/>'.JText::_('MASS_EMAIL_BODY_DATA').':
<textarea
name="action['.$table->table.']['.$key.'][sendEmail][bodyData]">'.$value->data['bodyData'].'</textarea>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
if($loadedData->massaction_table == 'order'){
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'changeStatus';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'notify' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if(($value->name != 'changeStatus' || ($table->table
!= $loadedData->massaction_table && is_int($key))))
continue;
$db->setQuery('SELECT `orderstatus_namekey` FROM
'.hikashop_table('orderstatus'));
$orderStatuses = $db->loadObjectList();
$output='<div
id="'.$table->table.'action'.$key.'changeStatus">';
$output.= JText::_('NEW_ORDER_STATUS').': <select
class="custom-select chzn-done not-processed"
id="action_'.$table->table.'_'.$key.'_changeStatus_value"
name="action['.$table->table.']['.$key.'][changeStatus][value]">';
if(is_array($orderStatuses)){
foreach($orderStatuses as $orderStatus){
$orderStatus = $orderStatus->orderstatus_namekey;
$selected='';
if($orderStatus==@$value->data['value']){
$selected='selected="selected"';
}
$output.='<option '.$selected.'
value="'.$orderStatus.'">'.hikashop_orderStatus($orderStatus).'</option>';
}
}
$checked='';
if(isset($value->data['notify']) &&
$value->data['notify']==1){
$checked='checked="checked"';
}
$output.='</select><input type="checkbox"
'.$checked.' value="1"
id="action_'.$table->table.'_'.$key.'_changeStatus_notify"
name="action['.$table->table.']['.$key.'][changeStatus][notify]"/><label
for="action_'.$table->table.'_'.$key.'_changeStatus_notify">'.JText::_('SEND_NOTIFICATION_EMAIL').'</label></div>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'addProduct';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'', 'quantity' => '1');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'addProduct' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
if(!isset($value->data['type']))
$value->data['type'] = 'add';
$products=array();
if(!empty($value->data) &&
!empty($value->data['value'])){
hikashop_toInteger($value->data['value']);
$query = 'SELECT product_id,product_name FROM
'.hikashop_table('product').' WHERE product_id IN
('.implode(',',$value->data['value']).')';
$database->setQuery($query);
$products = $database->loadColumn();
}
if(!isset($value->data['quantity']))
$value->data['quantity'] = '1';
$productSelect = $nameboxType->display(
'action['.$table->table.']['.$key.'][addProduct][value]',
$products,
hikashopNameboxType::NAMEBOX_MULTIPLE,
'product',
array(
'delete' => true,
'default_text' =>
'<em>'.JText::_('HIKA_NONE').'</em>',
)
);
$output ='<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_addProduct_type"
name="action['.$table->table.']['.$key.'][addProduct][type]">';
$datas = array('add'=>'ADD',
'remove'=>'REMOVE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select>';
$output .='<input class="inputbox"
type="text"
name="action['.$table->table.']['.$key.'][addProduct][quantity]"
size="10"
value="'.$value->data['quantity'].'"
/> '.JText::_('PRODUCTS');
$output .= $productSelect;
if(isset($value->data['update'])) $checked =
'checked="checked"';
else $checked = '';
$output .= '<input type="checkbox"
value="update"
id="action_'.$table->table.'_'.$key.'_addProduct_update"
name="action['.$table->table.']['.$key.'][addProduct][update]"
'.$checked.'/><label
for="action_'.$table->table.'_'.$key.'_addProduct_update">'.JText::_('UPDATE_PRODUCT_STOCK').'</label>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
}
if($loadedData->massaction_table == 'product'){
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'updateCategories';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'updateCategories' ||
($table->table != $loadedData->massaction_table &&
is_int($key)))
continue;
if(empty($value->data['type']))
$value->data['type'] = 'add';
$categories=array();
if(!empty($value->data) &&
!empty($value->data['value'])){
$query = 'SELECT category_id, category_name FROM
'.hikashop_table('category').' WHERE category_id IN
('.implode($value->data['value'],',').')';
$database->setQuery($query);
$categories = $database->loadColumn();
}
$categorySelect = $nameboxType->display(
'action['.$table->table.']['.$key.'][updateCategories][value]',
$categories,
hikashopNameboxType::NAMEBOX_MULTIPLE,
'category',
array(
'delete' => true,
'default_text' =>
'<em>'.JText::_('HIKA_NONE').'</em>',
)
);
$output ='<select
id="action_'.$table->table.'_'.$key.'_updateCategories_type"
class="custom-select select-listing chzn-done not-processed"
name="action['.$table->table.']['.$key.'][updateCategories][type]">';
$datas = array('add'=>'ADD',
'replace'=>'REPLACE','remove'=>'REMOVE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select>';
$output .= $categorySelect;
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'updateRelateds';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'updateRelateds' || ($table->table
!= $loadedData->massaction_table && is_int($key)))
continue;
$products=array();
if(!empty($value->data) &&
!empty($value->data['value'])){
hikashop_toInteger($value->data['value']);
$query = 'SELECT product_id,product_name FROM
'.hikashop_table('product').' WHERE product_id IN
('.implode(',',$value->data['value']).')';
$database->setQuery($query);
$products = $database->loadColumn();
}
$productSelect = $nameboxType->display(
'action['.$table->table.']['.$key.'][updateRelateds][value]',
$products,
hikashopNameboxType::NAMEBOX_MULTIPLE,
'product',
array(
'delete' => true,
'default_text' =>
'<em>'.JText::_('HIKA_NONE').'</em>',
)
);
$output ='<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_updateRelateds_type"
name="action['.$table->table.']['.$key.'][updateRelateds][type]">';
$datas = array('add'=>'ADD',
'replace'=>'REPLACE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select>';
$output .= $productSelect;
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'updateOptions';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'updateOptions' || ($table->table
!= $loadedData->massaction_table && is_int($key)))
continue;
$options=array();
if(!empty($value->data) &&
!empty($value->data['value'])){
hikashop_toInteger($value->data['value']);
$query = 'SELECT product_id,product_name FROM
'.hikashop_table('product').' WHERE product_id IN
('.implode($value->data['value'],',').')';
$database->setQuery($query);
$options = $database->loadColumn();
}
$productSelect = $nameboxType->display(
'action['.$table->table.']['.$key.'][updateOptions][value]',
$options,
hikashopNameboxType::NAMEBOX_MULTIPLE,
'product',
array(
'delete' => true,
'default_text' =>
'<em>'.JText::_('HIKA_NONE').'</em>',
)
);
$output ='<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_updateOptions_type"
name="action['.$table->table.']['.$key.'][updateOptions][type]">';
$datas = array('add'=>'ADD',
'replace'=>'REPLACE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select>';
$output .= $productSelect;
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'updateCharacteristics';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'updateCharacteristics' ||
($table->table != $loadedData->massaction_table &&
is_int($key)))
continue;
$characteristics=array();
$query = 'SELECT * FROM
'.hikashop_table('characteristic').' WHERE
characteristic_parent_id = 0';
$database->setQuery($query);
$characteristics = $database->loadObjectList();
if(!empty($characteristics)){
$output ='<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_updateCharacteristics_type"
name="action['.$table->table.']['.$key.'][updateCharacteristics][type]">';
$datas = array('add'=>'ADD',
'delete'=>'HIKA_DELETE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select><br/><div
class="hika_massaction_checkbox" >';
if(!isset($value->data['value']))
$value->data['value'] = '';
if(!is_array($value->data['value']))
$value->data['value'] =
(array)$value->data['value'];
foreach($characteristics as $characteristic){
$checked = '';
if(in_array($characteristic->characteristic_id,$value->data['value']))
$checked = 'checked="checked"';
$output .= '<br/><input type="checkbox"
name="action['.$table->table.']['.$key.'][updateCharacteristics][value][]"
'.$checked.'
value="'.$characteristic->characteristic_id.'"
/>'.$characteristic->characteristic_value;
}
$output .= '</div>';
}else{
$output = '<div
class="alert">'.JText::_('MASSACTION_NO_CHARACTERISTICS').'</div>';
}
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'setCanonical';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'setCanonical' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
if(!isset($value->data['value']))
$value->data['value'] = '';
$output = '<input type="text"
id="action_'.$table->table.'_'.$key.'_setCanonical_value"
name="action['.$table->table.']['.$key.'][setCanonical][value]"
value="'.$value->data['value'].'">';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
}
if($loadedData->massaction_table == 'order' ||
$loadedData->massaction_table == 'user'){
$loadedData->massaction_actions['__num__'] = new
stdClass();
$loadedData->massaction_actions['__num__']->type =
$table->table;
$loadedData->massaction_actions['__num__']->name =
'changeGroup';
$loadedData->massaction_actions['__num__']->html =
'';
$loadedData->massaction_actions['__num__']->data =
array('value' => '', 'type' =>
'');
foreach($loadedData->massaction_actions as $key => &$value)
{
if($value->name != 'changeGroup' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
if(!isset($value->data['type']))
$value->data['type'] = 'add';
if(!isset($value->data['value']))
$value->data['value'] = '1';
$query = 'SELECT * FROM
'.hikashop_table('usergroups',false);
$database->setQuery($query);
$groups = $database->loadObjectList();
$output ='<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_changeGroup_type"
name="action['.$table->table.']['.$key.'][changeGroup][type]">';
$datas = array('add'=>'ADD',
'replace'=>'REPLACE','remove'
=>'REMOVE');
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
$output .='<option value="'.$k.'"
'.$selected.'>'.JText::_($data).'</option>';
}
$output .='</select>';
$output .= '<select class="custom-select chzn-done
not-processed"
id="action_'.$table->table.'_'.$key.'_changeGroup_value"
name="action['.$table->table.']['.$key.'][changeGroup][value]">';
// categories
foreach($groups as $group){
$selected = '';
if($group->id == $value->data['value']) $selected =
'selected="selected"';
$output .='<option
value="'.$group->id.'"
'.$selected.'>'.JText::_($group->title).'</option>';
}
$output .= '</select>';
$actions_html[$value->name] =
$massactionClass->initDefaultDiv($value, $key, $type, $table->table,
$loadedData, $output);
}
}
}else{
$actions_html['displayResults'] = '<div
id="'.$table->table.'action__num__displayResults"></div>';
$actions_html['exportCsv'] = '<div
id="'.$table->table.'action__num__exportCsv"></div>';
$actions_html['updateValues'] = '<div
id="'.$table->table.'action__num__updateValues"></div>';
}
$js="
function checkAll(id, type){
var toCheck =
document.getElementById(id).getElementsByTagName('input');
for (i = 0 ; i < toCheck.length ; i++) {
if (toCheck[i].type == 'checkbox') {
if(type == 'check'){
toCheck[i].checked = true;
}else{
toCheck[i].checked = false;
}
}
}
}";
$doc = JFactory::getDocument();
$doc->addScriptDeclaration(
"<!--\n".$js."\n//-->\n" );
}
function onReloadPageMassActionAfterEdition(&$reload){
$reload['category']['category_id']='category_id';
$reload['price']['price_product_id']='price_product_id';
$reload['price']['price_currency_id']='price_currency_id';
$reload['product']['product_dimension_unit']='product_dimension_unit';
$reload['address']['address_id']='address_id';
$reload['product'][]='';
$reload['product'][]='';
}
function
onSaveEditionSquareMassAction($data,$data_id,$table,$column,$value,$id,$type){
$database = JFactory::getDBO();
switch($data){
case 'product':
$class = hikashop_get('class.product');
switch($table){
case 'category':
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
$query = 'SELECT category_id';
$query .= ' FROM
'.hikashop_table('product_category');
$query .= ' WHERE
product_id='.$database->Quote($data_id).' AND category_id
!='.$database->Quote($id);
$database->setQuery($query);
$tmp = $database->loadObjectList();
$categories[$value] = $value;
foreach($tmp as $val){
$categories[$val->category_id] = $val->category_id;
}
unset($object->alias);
$object->categories = $categories;
$class->updateCategories($object,$data_id);
break;
case 'price':
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
$query = 'SELECT *';
$query .= ' FROM '.hikashop_table('price');
$query .= ' WHERE
price_product_id='.$database->Quote($data_id);
$database->setQuery($query);
$prices = $database->loadObjectList();
foreach($prices as $price){
if($price->price_id == $id){
$price->$column = $value;
}
}
unset($object->alias);
$object->prices = $prices;
$class->updatePrices($object,$data_id);
break;
case 'characteristic':
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
$characteristics = array();
$query = 'SELECT c1.characteristic_id as
\'default_id\',c2.characteristic_id,c1.characteristic_parent_id,v2.ordering,c2.characteristic_value';
$query .= ' FROM
'.hikashop_table('variant').' AS v1';
$query .= ' INNER JOIN
'.hikashop_table('characteristic').' AS c1 ON
c1.characteristic_id = v1.variant_characteristic_id';
$query .= ' INNER JOIN
'.hikashop_table('variant').' AS v2 ON
c1.characteristic_parent_id = v2.variant_characteristic_id';
$query .= ' INNER JOIN
'.hikashop_table('characteristic').' AS c2 ON
c2.characteristic_parent_id = c1.characteristic_parent_id';
$query .= ' WHERE c1.characteristic_parent_id!=0 AND
v1.variant_product_id='.$database->Quote($data_id);
$database->setQuery($query);
$results = $database->loadObjectList();
foreach($results as $result){
$test = false;
foreach($characteristics as $charac){
if($charac->characteristic_id ==
$result->characteristic_parent_id){
$charac->values[$result->characteristic_id] =
$result->characteristic_value;
if($result->characteristic_value == $value){
$charac->default_id = $result->characteristic_id;
}
$test = true;
}
}
if(!$test){
$tmp = new stdClass();
$tmp->characteristic_id = $result->characteristic_parent_id;
$tmp->ordering = $result->ordering;
if($result->characteristic_value == $value){
$tmp->default_id = $result->characteristic_id;
}else{
$tmp->default_id = $result->default_id;
}
$tmp->values[$result->characteristic_id] =
$result->characteristic_value;
$characteristics[] = $tmp;
$object->oldCharacteristics[] =
$result->characteristic_parent_id;
}
}
foreach($characteristics as $characteristic){
foreach($characteristic->values as $v=>$k){
if($v == $value){
$characteristic->default_id = $value;
}
}
}
$object->characteristics = $characteristics;
$class->updateCharacteristics($object,$data_id);
break;
case 'product' :
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
unset($object->alias);
$object->$column = $value;
$class->save($object);
break;
case 'related' :
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
unset($object->alias);
$query = 'SELECT product_related_id';
$query .= ' FROM
'.hikashop_table('product_related');
$query .= ' WHERE
product_id='.$database->Quote($data_id).' AND
product_related_type = \'related\'';
$database->setQuery($query);
$results = $database->loadObjectList();
$related = array();
foreach($results as $result){
if($result->product_related_id != $id){
$related[$result->product_related_id] = new stdClass();
$related[$result->product_related_id]->product_related_id =
$result->product_related_id;
$related[$result->product_related_id]->product_related_ordering
= 0;
}
}
$related[$value] = new stdClass();
$related[$value]->product_related_id = $value;
$related[$value]->product_related_ordering = 0;
$object->related = $related;
$class->updateRelated($object,$data_id,'related');
break;
case 'options' :
if($class->getProducts($data_id)){
$object = $class->get($data_id);
}
unset($object->alias);
$query = 'SELECT product_related_id';
$query .= ' FROM
'.hikashop_table('product_related');
$query .= ' WHERE
product_id='.$database->Quote($data_id).' AND
product_related_type = \'options\'';
$database->setQuery($query);
$results = $database->loadObjectList();
$options = array();
foreach($results as $result){
if($result->product_related_id != $id){
$options[$result->product_related_id] = new stdClass();
$options[$result->product_related_id]->product_related_id =
$result->product_related_id;
$options[$result->product_related_id]->product_related_ordering
= 0;
}
}
$options[$value] = new stdClass();
$options[$value]->product_related_id = $value;
$options[$value]->product_related_ordering = 0;
$object->options = $options;
$class->updateRelated($object,$data_id,'options');
break;
}
break;
case 'category':
$class = hikashop_get('class.category');
switch($table){
case 'category':
$object = $class->get($data_id);
if($object){
$object->$column = $value;
$class->save($object);
}
break;
}
break;
case 'user':
$class = hikashop_get('class.user');
switch($table){
case 'user':
$object = $class->get($data_id);
foreach($object as $key=>$element){
if(!strstr($key,'user_')){
unset($object->$key);
}
}
if($object){
$object->$column = $value;
$class->save($object);
}
break;
case 'address':
$address = hikashop_get('class.address');
$object = $address->get($id);
$object->$column = $value;
$address->save($object);
break;
case 'usergroup':
die('Never');
break;
case 'joomla_users':
if($column == 'joomla_users_id'){
$column = 'id';
}
$user = JFactory::getUser($id);
if(!empty($user)){
$user->$column = $value;
$user->save();
}
break;
}
break;
case 'order':
$class = hikashop_get('class.order');
switch($table){
case 'address':
$order = $class->get($data_id);
$address = hikashop_get('class.address');
$object = $address->get($id);
$object->$column = $value;
if($order->order_shipping_address_id == $id &&
$order->order_billing_address_id == $id){
$address->save($object);
$class->save($order);
}else if($order->order_shipping_address_id == $id){
$order->order_shipping_address_id =
$address->save($object,$data_id,'shipping');
$class->save($order);
}else if($order->order_billing_address_id == $id){
$order->order_billing_address_id =
$address->save($object,$data_id,'billing');
$class->save($order);
}
break;
case 'order_product':
$info = $class->get($data_id);
$query = 'SELECT *';
$query .= ' FROM
'.hikashop_table('order_product');
$query .= ' WHERE
order_product_id='.$database->Quote($id);
$database->setQuery($query);
$row = $database->loadObject();
$object = new stdClass();
$object->order_id = $data_id;
$object->product = $row;
$object->product->$column = $value;
$history = new stdClass();
$history->history_reason =
JText::sprintf('MODIFICATION_USERS');
$history->history_notified = '0';
$history->history_type = 'modification';
$object->history = $history;
$class->save($object);
break;
case 'order' :
$object = $class->get($data_id);
if($object){
if(isset($_POST['checkbox'])){
$history->history_reason =
JText::sprintf('MODIFICATION_USERS');
$history->history_notified = '1';
$history->history_type = 'modification';
}
$object->$column = $value;
$class->save($object);
}
break;
case 'payment':
$query = 'SELECT payment_type';
$query .= ' FROM '.hikashop_table('payment');
$query .= ' WHERE
payment_id='.$database->Quote($value);
$database->setQuery($query);
$row = $database->loadObject();
$object = $class->get($data_id);
$object->order_payment_id = $value;
$object->order_payment_method = $row->payment_type;
$history = new stdClass();
$history->history_reason =
JText::sprintf('MODIFICATION_USERS');
$history->history_notified = '0';
$history->history_type = 'modification';
$object->history = $history;
$class->save($object);
break;
case 'shipping':
$query = 'SELECT shipping_type';
$query .= ' FROM '.hikashop_table('shipping');
$query .= ' WHERE
shipping_id='.$database->Quote($value);
$database->setQuery($query);
$row = $database->loadObject();
$object = $class->get($data_id);
$object->order_shipping_id = $value;
$object->order_shipping_method = $row->shipping_type;
$history = new stdClass();
$history->history_reason =
JText::sprintf('MODIFICATION_USERS');
$history->history_notified = '0';
$history->history_type = 'modification';
$object->history = $history;
$class->save($object);
break;
case 'user':
die('Never');
break;
case 'joomla_users':
die('Never');
break;
}
break;
case 'address':
$class = hikashop_get('class.address');
switch($table){
case 'address':
$object = $class->get($data_id);
$object->$column = $value;
$class->save($object);
break;
case 'user':
$user = hikashop_get('class.user');
$object = $user->get($id);
foreach($object as $key=>$element){
if(!strstr($key,'user_')){
unset($object->$key);
}
}
if($object){
$object->$column = $value;
$user->save($object,true);
}
break;
case 'joomla_users':
if($column == 'joomla_users_id'){
$column = 'id';
}
$user = JFactory::getUser($id);
if(!empty($user)){
$user->$column = $value;
$user->save();
}
break;
}
break;
}
}
function
onLoadDatatMassActionBeforeEdition($data,$data_id,$table,$column,$type,$ids,&$query,&$view){
$database = JFactory::getDBO();
hikashop_toInteger($ids);
switch($type){
case 'price':
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'joomla_users':
if($column == 'jommla_users_id'){
$column = 'id';
}
$query = 'SELECT DISTINCT '.$column.', id as
\'joomla_users_id\'';
$query .= ' FROM '.hikashop_table('users',false);
$query .= ' WHERE id IN
('.implode(',',$ids).')';
break;
case 'layout':
$layout = hikashop_get('type.layout');
$view->assignRef('layout',$layout);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'method_name':
$query = 'SELECT
'.$column.','.$table.'_id,'.$table.'_type';
$query .= ' FROM '.hikashop_table($table);
break;
case 'usergroups':
$query = 'SELECT DISTINCT title, id as
\'usergroups_id\'';
$query .= ' FROM
'.hikashop_table('usergroups',false);
break;
case 'status':
$status = hikashop_get('type.categorysub');
$status->type = 'status';
$view->assignRef('status',$status);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'yesno':
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'currency':
$types = hikashop_get('type.currency');
$view->assignRef('types',$types);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'dimension':
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'dimension_unit':
$volume = hikashop_get('type.volume');
$view->assignRef('volume',$volume);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'weight':
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'weight_unit':
$weight = hikashop_get('type.weight');
$view->assignRef('weight',$weight);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
break;
case 'characteristic':
$query = 'SELECT DISTINCT c1.characteristic_id,
c1.characteristic_value';
$query .= ' FROM
'.hikashop_table('characteristic').' AS c1';
$query .= ' INNER JOIN
'.hikashop_table('characteristic').' AS c2 ON
c1.characteristic_parent_id = c2.characteristic_id';
$query .= ' WHERE
c2.characteristic_value='.$database->Quote($column);
break;
case 'related' :
$query = 'SELECT DISTINCT p.product_id as
\'related_id\',p.product_name';
$query .= ' FROM '.hikashop_table('product').'
AS p';
break;
case 'options' :
$query = 'SELECT DISTINCT p.product_id as
\'options_id\',p.product_name';
$query .= ' FROM '.hikashop_table('product').'
AS p';
break;
case 'parent':
$query = 'SELECT '.$column.','.$table.'_id,
'.$table.'_name';
$query .= ' FROM '.hikashop_table($table);
$view->assignRef('ids', $ids);
break;
case 'id':
$query = 'SELECT '.$column;
if($table != 'price' &&
$table!='address'){
$query .= ','.$table.'_name';
}
$query .= ' FROM '.hikashop_table($table);
if($table == 'category'){
$query .= ' WHERE category_type = \'product\' ';
}
$view->assignRef('ids', $ids);
break;
case 'sub_id':
if(strstr($column, '_')!==false){
$a = explode("_", $column);
}
if(strstr($column, 'partner')===false){
foreach($a as $k=>$chaine){
if($chaine === $table || $chaine === 'id'){
unset($a[$k]);
}
}
$table_tmp = implode('_',$a);
}else{
$table_tmp = 'user';
}
$column_tmp = $table_tmp.'_id';
$query = 'SELECT '.$column_tmp.' as '.$column;
$query .= ' FROM '.hikashop_table($table_tmp);
$view->assignRef('ids', $ids);
$view->table = 'order';
break;
default:
$joomlaTable = true;
if(preg_match('/joomla_/',$table)){
$table = str_replace('joomla_','',$table);
$joomlaTable = false;
}
if(strpos($type,'custom_') === 0){
$f = substr_replace($view->type,'',0,7);
$fields = hikashop_get('class.field');
$view->assignRef('fields',$fields);
$query = 'SELECT *';
$query .= ' FROM '.hikashop_table($table,$joomlaTable);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
$database->setQuery($query);
$elements = $database->loadObjectList();
if($elements == null){
die('Undefined row');
}
$view->assignRef('elements',$elements);
$allFields = array();
$column_id = $view->table.'_id';
foreach($elements as $element){
$f =
$fields->getFields('backend',$element,$table,'user&task=state');
if(preg_match('/joomla_users_/',$column_id)){
$column_id =
str_replace('joomla_users_','',$column_id);
}
$f['id'] = $element->$column_id;
$allFields[] = $f;
}
$view->assignRef('allFields',$allFields);
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table,$joomlaTable);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
}else if(!$joomlaTable){
$query = 'SELECT '.$column.',id';
$query .= ' FROM '.hikashop_table($table,$joomlaTable);
$query .= ' WHERE id IN
('.implode(',',$ids).')';
$view->assignRef('ids', $ids);
}else{
$query = 'SELECT
'.$column.','.$table.'_id';
$query .= ' FROM '.hikashop_table($table);
$query .= ' WHERE '.$table.'_id IN
('.implode(',',$ids).')';
$view->assignRef('ids', $ids);
}
break;
}
}
function
onLoadResultMassActionAfterEdition($data,$data_id,$table,$column,$type,$id,$value,&$query){
$database = JFactory::getDBO();
switch($data){
case 'product':
switch($table){
case 'product':
$query = 'SELECT
'.$column.',product_id,product_dimension_unit';
$query .= ' FROM '.hikashop_table('product');
$query .= ' WHERE product_id = '.$database->Quote($id);
break;
case 'price':
$query = 'SELECT '.$column.',price_currency_id,
price_product_id, price_id';
$query .= ' FROM '.hikashop_table('price');
$query .= ' WHERE price_id ='.$database->Quote($id);
break;
case 'category':
$query = 'SELECT
'.hikashop_table('category').'.'.$column.','.hikashop_table('product_category').'.product_id,'.hikashop_table('category').'.category_id';
$query .= ' FROM '.hikashop_table('category');
$query .= ' INNER JOIN
'.hikashop_table('product_category').' ON
'.hikashop_table('product_category').'.category_id =
'.hikashop_table('category').'.category_id';
$query .= ' WHERE product_id = '.$database->Quote($id);
break;
case 'characteristic':
$query = 'SELECT
c1.characteristic_value,c1.characteristic_id';
$query .= ' FROM
'.hikashop_table('characteristic').' as c1';
$query .= ' WHERE c1.characteristic_id
='.$database->Quote($value);
break;
case 'related':
$query = 'SELECT p.product_id as
\'related_id\',product_name,r.product_related_type';
$query .= ' FROM
'.hikashop_table('product').' AS p';
$query .= ' INNER JOIN
'.hikashop_table('product_related').' AS r ON
r.product_related_id = p.product_id';
$query .= ' WHERE r.product_id =
'.$database->Quote($data_id).' AND r.product_related_type =
\'related\'';
$database->setQuery($query);
$query = $database->loadObjectList();
break;
case 'options':
$query = 'SELECT p.product_id as
\'options_id\',product_name,r.product_related_type';
$query .= ' FROM
'.hikashop_table('product').' AS p';
$query .= ' INNER JOIN
'.hikashop_table('product_related').' AS r ON
r.product_related_id = p.product_id';
$query .= ' WHERE r.product_id =
'.$database->Quote($data_id).' AND r.product_related_type =
\'options\'';
$database->setQuery($query);
$query = $database->loadObjectList();
break;
}
break;
case 'user':
switch($table){
case 'user':
$query = 'SELECT '.$column.',user_id';
$query .= ' FROM '.hikashop_table('user');
$query .= ' WHERE user_id = '.$database->Quote($id);
break;
case 'joomla_users':
$query = 'SELECT DISTINCT '.$column.', id as
\'joomla_users_id\'';
$query .= ' FROM
'.hikashop_table('users',false);
$query .= ' WHERE id = '.$database->Quote($id);
break;
case 'usergroups':
$query = 'SELECT DISTINCT usergroups.title, hk_user.user_id,
usergroups.id as \'usergroups_id\'';
$query .= ' FROM
'.hikashop_table('usergroups',false).' AS
usergroups';
$query .= ' INNER JOIN
'.hikashop_table('user_usergroup_map',false).' AS
user_usergroup ON usergroups.id = user_usergroup.group_id';
$query .= ' INNER JOIN
'.hikashop_table('users',false).' AS user ON user.id =
user_usergroup.user_id';
$query .= ' INNER JOIN
'.hikashop_table('user').' AS hk_user ON user.id =
hk_user.user_cms_id';
$query .= ' WHERE usergroups.id =
'.$database->Quote($id);
break;
case 'address':
$query = 'SELECT '.$column.', address_user_id,
address_id';
$query .= ' FROM '.hikashop_table('address');
$query .= ' WHERE address_id = '.$database->Quote($id);
break;
}
break;
case 'category':
switch($table){
case 'category':
$query = 'SELECT '.$column.',category_id';
$query .= ' FROM '.hikashop_table('category');
$query .= ' WHERE category_id =
'.$database->Quote($id);
break;
}
case 'order':
switch($table){
case 'order':
$query = 'SELECT '.$column.',
order_id,order_currency_id,order_partner_currency_id';
$query .= ' FROM '.hikashop_table('order');
$query .= ' WHERE order_id = '.$database->Quote($id);
break;
case 'order_product':
$query = 'SELECT '.$column.', order_id,
order_product_id';
$query .= ' FROM
'.hikashop_table('order_product');
$query .= ' WHERE order_id = '.$database->Quote($id);
break;
case 'payment':
$query = 'SELECT o.order_id,p.payment_name, p.payment_id';
$query .= ' FROM '.hikashop_table('order').'
as o';
$query .= ' LEFT JOIN
'.hikashop_table('payment').' as p ON
o.order_payment_id = p.payment_id';
$query .= ' WHERE p.payment_id =
'.$database->Quote($value);
break;
case 'shipping':
$query = 'SELECT o.order_id,s.shipping_name,
s.shipping_id';
$query .= ' FROM '.hikashop_table('order').'
as o';
$query .= ' LEFT JOIN
'.hikashop_table('shipping').' as s ON
o.order_shipping_id = s.shipping_id';
$query .= ' WHERE s.shipping_id =
'.$database->Quote($value);
break;
case 'address':
$query = 'SELECT '.$column.', address_id';
$query .= ' FROM '.hikashop_table('address');
$query .= ' WHERE address_id ='.$database->Quote($id);
break;
}
break;
case 'address':
switch($table){
case 'user':
$query = 'SELECT '.$column.', user_id,
address_id';
$query .= ' FROM '.hikashop_table('user').'
AS user';
$query .= ' INNER JOIN
'.hikashop_table('address').' AS address ON
user.user_id = address.address_user_id';
$query .= ' WHERE user.user_id =
'.$database->Quote($id);
break;
case 'joomla_users':
$query = 'SELECT user.'.$column.', id as
\'joomla_users_id\', address.address_id';
$query .= ' FROM
'.hikashop_table('users',false).' AS user';
$query .= ' INNER JOIN
'.hikashop_table('user').' AS hk_user ON user.id =
hk_user.user_cms_id';
$query .= ' INNER JOIN
'.hikashop_table('address').' AS address ON
hk_user.user_id = address.address_user_id';
$query .= ' WHERE user.id = '.$database->Quote($id);
break;
case 'address':
$query = 'SELECT a.'.$column.', a.address_id';
$query .= ' FROM
'.hikashop_table('address').' as a';
$query .= ' WHERE a.address_id
='.$database->Quote($data_id);
break;
}
}
}
function onBeforeMassactionUpdate(&$element){
if(!empty($element->massaction_filters)){
foreach($element->massaction_filters as $k => $filter){
if($filter->name == 'csvImport'){
if($element->massaction_filters[$k]->data['pathType']
== 'upload'){
$importFile =
hikaInput::get()->files->getVar('filter_product_'.$k.'_csvImport_upload',
array(), 'array');
$importHelper = hikashop_get('helper.import');
$element->massaction_filters[$k]->data['path'] =
$importHelper->importFromFile($importFile, false);
$element->massaction_filters[$k]->data['pathType'] =
'path';
}
}
}
}
}
function onHikashopCronTrigger(&$messages){
$config =& hikashop_config();
$periods =
array('minutes','hours','days','weeks','months','years');
$massactionClass = hikashop_get('class.massaction');
foreach($periods as $period){
$last_trigger =
$config->get('massaction_last_trigger_'.$period);
$next_trigger = strtotime('+1 '.$period,(int)$last_trigger);
if(time()<$next_trigger) continue;
$pref = new stdClass();
$key = 'massaction_last_trigger_'.$period;
$pref->$key = time();
$config->save($pref);
$massactionClass->_trigger('onHikashopCronTrigger'.ucfirst($period));
}
if(count($massactionClass->report)) $messages =
array_merge($messages,$massactionClass->report);
}
function
onProcessOrderMassActionmysqlQuery(&$elements,&$action,$k) {
$this->_processSQL($elements,$action);
}
function
onProcessProductMassActionmysqlQuery(&$elements,&$action,$k){
$this->_processSQL($elements,$action);
}
function
onProcessAddressMassActionmysqlQuery(&$elements,&$action,$k){
$this->_processSQL($elements,$action);
}
function
onProcessUserMassActionmysqlQuery(&$elements,&$action,$k){
$this->_processSQL($elements,$action);
}
function
onProcessCategoryMassActionmysqlQuery(&$elements,&$action,$k){
$this->_processSQL($elements,$action);
}
function _processSQL(&$elements, &$action) {
if(!empty($action['query'])) {
$db = JFactory::getDBO();
foreach($elements as $e) {
$attributes = get_object_vars($e);
$query = $action['query'];
foreach($attributes as $key => $value) {
if(is_object($value) || is_array($value))
continue;
$query = str_replace('{'.$key.'}', $value,
$query);
}
$db->setQuery($query);
$db->execute();
}
}
}
}
hikashopmassaction.xml000064400000001622151162042500011153 0ustar00<?xml
version="1.0" encoding="utf-8"?>
<extension version="2.5" type="plugin"
group="system" method="upgrade">
<name>System - HikaShop Mass Action</name>
<creationDate>12 février 2021</creationDate>
<version>4.4.1</version>
<author>HikaShop</author>
<authorEmail>dev@hikashop.com</authorEmail>
<authorUrl>http://www.hikashop.com</authorUrl>
<copyright>(C) 2010-2021 HIKARI SOFTWARE. All rights
reserved.</copyright>
<license>http://www.gnu.org/licenses/gpl-2.0.html
GNU/GPL</license>
<description>HikaShop System plugin to handle mass action
triggers</description>
<files>
<filename
plugin="hikashopmassaction">hikashopmassaction.php</filename>
</files>
<params addpath="/components/com_hikashop/params">
</params>
<config>
<fields name="params"
addfieldpath="/components/com_hikashop/fields">
<fieldset name="basic">
</fieldset>
</fields>
</config>
</extension>
index.html000064400000000054151162042500006534 0ustar00<html><body
bgcolor="#FFFFFF"></body></html>