Spade
Mini Shell
| Directory:~$ /home/lmsyaran/public_html/joomla4/ |
| [Home] [System Details] [Kill Me] |
index.html000064400000000054151157241550006546 0ustar00<html><body
bgcolor="#FFFFFF"></body></html>massaction_user.php000064400000051560151157241550010471
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
class plgHikashopMassaction_user extends JPlugin
{
var $message = '';
function __construct(&$subject, $config){
parent::__construct($subject, $config);
$this->massaction = hikashop_get('class.massaction');
$this->massaction->datecolumns = array('user_created');
$this->user = hikashop_get('class.user');
$this->db = JFactory::getDBO();
}
function onMassactionTableLoad(&$externalValues){
$obj = new stdClass();
$obj->table ='user';
$obj->value ='user';
$obj->text =JText::_('HIKA_USER');
$externalValues[] = $obj;
}
function onMassactionTableTriggersLoad(&$table, &$triggers,
&$triggers_html, &$loadedData) {
if($table->table != 'user')
return true;
$triggers['onBeforeUserCreate']=JText::_('BEFORE_A_USER_IS_CREATED');
$triggers['onBeforeUserUpdate']=JText::_('BEFORE_A_USER_IS_UPDATED');
$triggers['onBeforeUserDelete']=JText::_('BEFORE_A_USER_IS_DELETED');
$triggers['onAfterUserCreate']=JText::_('AFTER_A_USER_IS_CREATED');
$triggers['onAfterUserUpdate']=JText::_('AFTER_A_USER_IS_UPDATED');
$triggers['onAfterUserDelete']=JText::_('AFTER_A_USER_IS_DELETED');
}
function
onMassactionTableFiltersLoad(&$table,&$filters,&$filters_html,&$loadedData){
if($table->table != 'user')
return true;
$type = 'filter';
$tables = array('user','address');
$filters['haveDontHave']=JText::_('HIKA_HAVE_DONT_HAVE');
$loadedData->massaction_filters['__num__'] = new
stdClass();
$loadedData->massaction_filters['__num__']->type =
'user';
$loadedData->massaction_filters['__num__']->data =
array('have'=>'have','type'=>'','order_status'=>'created');
$loadedData->massaction_filters['__num__']->name =
'haveDontHave';
$loadedData->massaction_filters['__num__']->html =
'';
$this->db->setQuery('SELECT `orderstatus_namekey` FROM
'.hikashop_table('orderstatus'));
$orderStatuses = $this->db->loadObjectList();
foreach($loadedData->massaction_filters as $key => &$value) {
if($value->name != 'haveDontHave' || ($table->table !=
$loadedData->massaction_table && is_int($key)))
continue;
$value->type = 'user';
$output= '<select class="custom-select chzn-done
not-processed"
name="filter['.$table->table.']['.$key.'][haveDontHave][have]"
id="userfilter'.$key.'haveDontHavetype"
onchange="countresults(\''.$table->table.'\','.$key.')">';
$datas =
array('have'=>'HIKA_HAVE','donthave'=>'HIKA_DONT_HAVE');
$display = 'style="display: none;"';
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['have']) $selected =
'selected="selected"';
if($value->data['have'] == 'order_status')
$display = '';
$output.= '<option value="'.$k.'"
'.$selected.'>'.JText::_(''.$data.'').'</option>';
}
$output.= '</select>';
$output.= '<select class="custom-select chzn-done
not-processed"
name="filter['.$table->table.']['.$key.'][haveDontHave][type]"
id="userfilter'.$key.'haveDontHavetype"
onchange="showSubSelect(this.value,'.$key.');
countresults(\''.$table->table.'\','.$key.')">';
$datas =
array('order'=>'HIKASHOP_ORDER','order_status'=>'ORDER_STATUS','address'=>'ADDRESS');
$display = 'style="display: none;"';
foreach($datas as $k => $data){
$selected = '';
if($k == $value->data['type']) $selected =
'selected="selected"';
if($value->data['type'] == 'order_status')
$display = '';
$output.= '<option value="'.$k.'"
'.$selected.'>'.JText::_(''.$data.'').'</option>';
}
$output.= '</select>';
$output .= '<select class="custom-select chzn-done
not-processed"
id="userfilter'.$key.'haveDontHaveorderStatus"
'.$display.'
name="filter['.$table->table.']['.$key.'][haveDontHave][order_status]"
onchange="countresults(\''.$table->table.'\','.$key.')">';
if(is_array($orderStatuses)){
foreach($orderStatuses as $orderStatus){
$selected = '';
if($orderStatus->orderstatus_namekey ==
$value->data['order_status']) $selected =
'selected="selected"';
$output.='<option
value="'.$orderStatus->orderstatus_namekey.'"
'.$selected.'>'.hikashop_orderStatus($orderStatus->orderstatus_namekey).'</option>';
}
}
$output.= '</select>';
$output.= '<input type="hidden"
id="userfilter'.$key.'haveDontHavehide"
name="filter['.$table->table.']['.$key.'][haveDontHave][show]"
value="0"/>';
$filters_html['haveDontHave'] =
$this->massaction->initDefaultDiv($value, $key, $type,
$table->table, $loadedData, $output);
}
$filters_html['haveDontHave'] .= '
<script type="text/javascript">
var d = document;
var hide =
d.getElementById(\'userfilter'.$key.'haveDontHavehide\').value;
if(hide != 0){d.getElementById(hide).style.display =
\'inline-block\';}
function showSubSelect(type, k){
if(type == \'order_status\'){
d.getElementById(\'userfilter\'+k+\'haveDontHaveorderStatus\').style.display
= \'inline-block\';
d.getElementById(\'userfilter\'+k+\'haveDontHavehide\').value
= \'userfilter\'+k+\'haveDontHaveorderStatus\';
}else{
d.getElementById(\'userfilter\'+k+\'haveDontHaveorderStatus\').style.display
= \'none\';
d.getElementById(\'userfilter\'+k+\'haveDontHavehide\').value
= \'0\';
}
}
</script>
';
}
function onProcessUserMassFilterlimit(&$elements,
&$query,$filter,$num){
$query->start = (int)$filter['start'];
$query->value = (int)$filter['value'];
}
function onProcessUserMassFilterordering(&$elements,
&$query,$filter,$num){
if(!empty($filter['value'])){
if(isset($query->ordering['default']))
unset($query->ordering['default']);
$query->ordering[] = $filter['value'];
}
}
function onProcessUserMassFilterdirection(&$elements,
&$query,$filter,$num){
if(empty($query->ordering))
$query->ordering['default'] = 'user_id';
$query->direction = $filter['value'];
}
function
onProcessUserMassFilteruserColumn(&$elements,&$query,$filter,$num){
if(empty($filter['type']) ||
$filter['type']=='all') return;
if(!isset($this->massaction))$this->massaction =
hikashop_get('class.massaction');
if(count($elements)){
foreach($elements as $k => $element){
$filter['type'] =
str_replace('hk_user.','',$filter['type']);
$filter['type'] =
str_replace('joomla_user.','',$filter['type']);
$in = $this->massaction->checkInElement($element, $filter);
if(!$in) unset($elements[$k]);
}
}else{
$db = JFactory::getDBO();
if(!empty($filter['value']) ||
(empty($filter['value']) &&
in_array($filter['operator'],array('IS NULL','IS
NOT NULL')))){
$query->leftjoin['joomla_user'] =
hikashop_table('users',false).' as joomla_user ON
joomla_user.id = hk_user.user_cms_id';
$query->where[] = $this->massaction->getRequest($filter);
}
}
}
function onCountUserMassFilteruserColumn(&$query,$filter,$num){
$elements = array();
$this->onProcessUserMassFilteruserColumn($elements,$query,$filter,$num);
return
JText::sprintf('SELECTED_PRODUCTS',$query->count('hk_user.user_id'));
}
function
onProcessUserMassFilteraddressColumn(&$elements,&$query,$filter,$num){
if(empty($filter['type']) ||
$filter['type']=='all') return;
if(!isset($this->massaction))$this->massaction =
hikashop_get('class.massaction');
$db = JFactory::getDBO();
if(in_array($filter['type'],array('address_state','address_country'))){
$db->setQuery('SELECT zone_namekey FROM
'.hikashop_table('zone').' WHERE zone_name LIKE
'.$db->quote($filter['value']).' OR
zone_name_english LIKE '.$db->quote($filter['value']));
$filter['value'] = $db->loadResult();
}
if(count($elements)){
foreach($elements as $k => $element){
$db->setQuery('SELECT * FROM
'.hikashop_table('address').' WHERE address_user_id =
'.(int)$element->user_id.' GROUP BY address_id');
$results = $db->loadObjectList();
$del = true;
foreach($results as $result){
$in = $this->massaction->checkInElement($result, $filter);
if($in) $del = false;
}
if($del) unset($elements[$k]);
}
}else{
if(!is_null($filter['value']) ||
(is_null($filter['value']) &&
in_array($filter['operator'],array('IS NULL','IS
NOT NULL')))){
$query->select = ' DISTINCT '.$query->select;
$query->leftjoin[] = hikashop_table('address').' as
hk_address ON hk_address.address_user_id = hk_user.user_id';
$query->where[] =
$this->massaction->getRequest($filter,'hk_address');
}else{
$query->leftjoin = '';
$query->where = array('false');
}
}
}
function onCountUserMassFilteraddressColumn(&$query,$filter,$num){
$elements = array();
$this->onProcessUserMassFilteraddressColumn($elements,$query,$filter,$num);
return
JText::sprintf('SELECTED_PRODUCTS',$query->count('hk_user.user_id'));
}
function
onProcessUserMassFilterhaveDontHave(&$elements,&$query,$filter,$num){
if(empty($filter['type']) ||
$filter['type']=='all') return;
if(count($elements)){
foreach($elements as $k => $element){
if($element->$filter['type']!=$filter['value'])
unset($elements[$k]);
}
}else{
$db = JFactory::getDBO();
$ids = null;
$qSearch = 'NOT IN';
if($filter['have'] == 'have')
$qSearch = 'IN';
switch($filter['type']){
case 'order':
$db->setQuery('SELECT order_user_id FROM
'.hikashop_table('order').' GROUP BY
order_user_id');
$ids = $db->loadColumn();
break;
case 'order_status':
$db->setQuery('SELECT order_user_id FROM
'.hikashop_table('order').' WHERE order_status =
'.$db->quote($filter['order_status']).' GROUP BY
order_user_id');
$ids = $db->loadColumn();
if($filter['have'] != 'have'){
$db->setQuery('SELECT order_user_id FROM
'.hikashop_table('order').' GROUP BY
order_user_id');
$allIds = $db->loadColumn();
$ids = array_diff($allIds, $ids);
$qSearch = 'IN';
}
break;
case 'address':
$db->setQuery('SELECT address_user_id FROM
'.hikashop_table('address').' GROUP BY
address_user_id');
$ids = $db->loadColumn();
break;
}
if($ids == null){
$query->where[] = ' 0 = 1';
}else{
$query->where[] = 'hk_user.user_id '.$qSearch.'
('.implode(',',$ids).')';
}
}
}
function onCountUserMassFilterhaveDontHave(&$query,$filter,$num){
$elements = array();
$this->onProcessUserMassFilterhaveDontHave($elements,$query,$filter,$num);
return
JText::sprintf('SELECTED_PRODUCTS',$query->count('hk_user.user_id'));
}
function
onProcessUserMassFilteraccessLevel(&$elements,&$query,$filter,$num){
if(empty($filter['type']) ||
$filter['type']=='all') return;
if(count($elements)){
$user_ids = array();
foreach($elements as $k => $element){
$user_ids[$element->user_id] = (int)$element->user_id;
}
if(count($user_ids)) {
$db = JFactory::getDBO();
$db->setQuery('SELECT user_id, user_cms_id FROM
'.hikashop_table('user').' WHERE user_id IN
('.implode(',', $user_ids).')');
$users = $db->loadObjectList('user_id');
$cms_ids = array();
foreach($users as $u){
$cms_ids[$u->user_cms_id] = (int)$u->user_cms_id;
}
$groups = array();
if(count($cms_ids)) {
$db->setQuery('SELECT user_id FROM
'.hikashop_table('user_usergroup_map',false).' WHERE
user_id IN ('.implode(',', $cms_ids).') AND group_id =
'.(int)$filter['group']);
$groups = $db->loadObjectList('user_id');
}
foreach($elements as $k => $element){
if($filter['type'] == 'IN' &&
(!isset($users[$element->user_id]) ||
!isset($groups[$users[$element->user_id]->user_cms_id])))
unset($elements[$k]);
elseif($filter['type'] == 'NOT IN' &&
isset($users[$element->user_id]) &&
isset($groups[$users[$element->user_id]->user_cms_id]))
unset($elements[$k]);
}
}
}else{
$db = JFactory::getDBO();
$db->setQuery('SELECT user_id FROM
'.hikashop_table('user_usergroup_map',false).' WHERE
group_id = '.(int)$filter['group']);
$users = $db->loadColumn();
if(!empty($users)){
$query->where[] = 'hk_user.user_cms_id'.'
'.$filter['type'].'
('.implode(',',$users).')';
}
}
}
function onCountUserMassFilteraccessLevel(&$query,$filter,$num){
$elements = array();
$this->onProcessUserMassFilteraccessLevel($elements,$query,$filter,$num);
return
JText::sprintf('SELECTED_PRODUCTS',$query->count('hk_user.user_id'));
}
function
onProcessUserMassActiondisplayResults(&$elements,&$action,$k){
$params =
$this->massaction->_displayResults('user',$elements,$action,$k);
$params->action_id = $k;
$js = '';
$app = JFactory::getApplication();
if(hikashop_isClient('administrator') &&
hikaInput::get()->getVar('ctrl','massaction') ==
'massaction'){
echo
hikashop_getLayout('massaction','results',$params,$js);
}
}
function
onProcessUserMassActionexportCsv(&$elements,&$action,$k){
$formatExport = $action['formatExport']['format'];
$path = $action['formatExport']['path'];
$email = $action['formatExport']['email'];
if(!empty($path)){
$url = $this->massaction->setExportPaths($path);
}else{
$url =
array('server'=>'','web'=>'');
ob_get_clean();
}
$app = JFactory::getApplication();
if(hikashop_isClient('administrator') ||
(!hikashop_isClient('administrator') && !empty($path))){
$params->action['user']['user_id'] =
'user_id';
unset($action['formatExport']);
$params =
$this->massaction->_displayResults('user',$elements,$action,$k);
$params->formatExport = $formatExport;
$params->path = $url['server'];
$params =
$this->massaction->sortResult($params->table,$params);
$this->massaction->_exportCSV($params);
}
if(!empty($email) && !empty($path)){
$config = hikashop_config();
$mailClass = hikashop_get('class.mail');
$content = array('type' => 'csv_export');
$mail =
$mailClass->get('massaction_notification',$content);
$mail->subject = JText::_('MASS_CSV_EMAIL_SUBJECT');
$mail->html = '1';
$csv = new stdClass();
$csv->name = basename($path);
$csv->filename = $url['server'];
$csv->url = $url['web'];
$mail->attachments = array($csv);
$mail->dst_name = '';
$mail->dst_email = explode(',',$email);
$mailClass->sendMail($mail);
}
}
function
onProcessUserMassActionupdateValues(&$elements,&$action,$k){
$current = 'user';
$current_id = $current.'_id';
$ids = array();
$column = $action['type'];
foreach($elements as $element){
$ids[] = $element->$current_id;
if(isset($element->$column))
$element->$column = $action['value'];
}
$action['type'] = strip_tags($column);
$alias = explode('_',$action['type']);
$queryTables = array($current);
$possibleTables = array($current,'joomla_users');
if(!isset($this->massaction))$this->massaction =
hikashop_get('class.massaction');
$value =
$this->massaction->updateValuesSecure($action,$possibleTables,$queryTables);
hikashop_toInteger($ids);
$db = JFactory::getDBO();
$max = 500;
if(count($ids) > $max){
$c = ceil((int)count($ids) / $max);
for($i = 0; $i < $c; $i++){
$offset = $max * $i;
$id = array_slice($ids, $offset, $max);
$query = 'UPDATE '.hikashop_table($current).' AS
hk_'.$current.' ';
$queryTables = array_unique($queryTables);
foreach($queryTables as $queryTable){
switch($queryTable){
case 'user':
if(!in_array('joomla_users',$queryTables)){
$query .= 'SET
hk_'.$current.'.'.$action['type'].' =
'.$value.' ';
}
break;
case 'joomla_users':
$action['type'] =
str_replace($queryTable.'_','',$action['type']);
$query .= 'LEFT JOIN
'.hikashop_table('users',false).' AS joomla_users ON
joomla_users.id = hk_user.user_cms_id ';
$query .= 'SET
'.$queryTable.'.'.$action['type'].' =
'.$value.' ';
break;
}
}
$query .= 'WHERE
hk_'.$current.'.'.$current.'_id IN
('.implode(',',$id).')';
$db->setQuery($query);
$db->execute();
}
}else{
$query = 'UPDATE '.hikashop_table($current).' AS
hk_'.$current.' ';
$queryTables = array_unique($queryTables);
foreach($queryTables as $queryTable){
switch($queryTable){
case 'user':
if(!in_array('joomla_users',$queryTables)){
$query .= 'SET
hk_'.$current.'.'.$action['type'].' =
'.$value.' ';
}
break;
case 'joomla_users':
$action['type'] =
str_replace($queryTable.'_','',$action['type']);
$query .= 'LEFT JOIN
'.hikashop_table('users',false).' AS joomla_users ON
joomla_users.id = hk_user.user_cms_id ';
$query .= 'SET
'.$queryTable.'.'.$action['type'].' =
'.$value.' ';
break;
}
}
$query .= 'WHERE
hk_'.$current.'.'.$current.'_id IN
('.implode(',',$ids).')';
$db->setQuery($query);
$db->execute();
}
}
function
onProcessUserMassActiondeleteElements(&$elements,&$action,$k){
$ids = array();
foreach($elements as $element){
$ids[] = $element->user_id;
}
$userClass = hikashop_get('class.user');
$max = 500;
if(count($ids) > $max){
$c = ceil((int)count($ids) / $max);
for($i = 0; $i < $c; $i++){
$offset = $max * $i;
$id = array_slice($ids, $offset, $max);
$result = $userClass->delete($id);
}
}else{
$result = $userClass->delete($ids);
}
}
function
onProcessUserMassActionchangeGroup(&$elements,&$action,$k){
$user_ids = array();
$values = array();
foreach($elements as $element){
$user_ids[] = $element->user_cms_id;
$values[] =
'('.$element->user_cms_id.','.$action['value'].')';
}
$db = JFactory::getDBO();
if($action['type'] != 'add'){
$filters = '';
if($action['type'] == 'remove')
$filters = ' AND group_id =
'.(int)$action['value'];
$db->setQuery('DELETE FROM
'.hikashop_table('user_usergroup_map',false).' WHERE
user_id IN
('.implode(',',$user_ids).')'.$filters);
$db->execute();
}
if($action['type'] != 'remove'){
$db->setQuery('REPLACE INTO
'.hikashop_table('user_usergroup_map',false).' VALUES
'.implode(',',$values));
$db->execute();
}
$app = JFactory::getApplication();
$config = JFactory::getConfig();
$handler = $config->get('session_handler',
'none');
if($handler=='database'){
$db->setQuery('DELETE FROM
'.hikashop_table('session',false).' WHERE client_id=0
AND userid IN ('.implode(',',$user_ids).')');
$db->execute();
}
if(!hikashop_isClient('administrator')){
foreach($user_ids as $user_id){
if($user_id != hikashop_loadUser())
continue;
$app->logout( $data->user_cms_id );
}
}
}
function
onProcessUserMassActionsendEmail(&$elements,&$action,$k){
if(!empty($action['emailAddress'])){
$config = hikashop_config();
$mailClass = hikashop_get('class.mail');
$content = array('elements' => $elements,
'action' => $action, 'type' =>
'user_notification');
$mail =
$mailClass->get('massaction_notification',$content);
$mail->subject =
!empty($mail->subject)?JText::_($action['emailSubject']):JText::_('MASS_NOTIFICATION_EMAIL_SUBJECT');
$mail->body = $action['bodyData'];
$mail->html = '1';
$mail->dst_name = '';
if(!empty($action['emailAddress']))
$mail->dst_email =
explode(',',$action['emailAddress']);
else
$mail->dst_email = $config->get('from_email');
$mailClass->sendMail($mail);
}
}
function onBeforeUserCreate(&$element,&$do){
if(!$do) return;
$elements = array($element);
$this->massaction->trigger('onBeforeUserCreate',$elements);
}
function onBeforeUserUpdate(&$element,&$do){
if(!$do) return;
$getUser = hikashop_copy($this->user->get($element->user_id));
foreach($getUser as $key => $value){
if(isset($element->$key) && $getUser->$key !=
$element->$key){
$getUser->$key = $element->$key;
}
}
$users = array($getUser);
$this->massaction->trigger('onBeforeUserUpdate',$users);
}
function onBeforeUserDelete(&$element,&$do){
$users = array();
if(!is_array($element)) $clone = array($element);
else $clone = $element;
foreach($clone as $id){
$users[] = $this->user->get($id);
}
$this->deletedUser =& $users;
$this->massaction->trigger('onBeforeUserDelete',$users);
}
function onAfterUserCreate(&$element){
$getUser = $this->user->get($element->user_id);
foreach($getUser as $key => $value){
if(isset($element->$key) && $getUser->$key !=
$element->$key){
$getUser->$key = $element->$key;
}
}
$users = array($getUser);
$this->massaction->trigger('onAfterUserCreate',$users);
}
function onAfterUserUpdate(&$element){
$getUser = $this->user->get($element->user_id);
foreach($getUser as $key => $value){
if(isset($element->$key) && $getUser->$key !=
$element->$key){
$getUser->$key = $element->$key;
}
}
$users = array($getUser);
$this->massaction->trigger('onAfterUserUpdate',$users);
}
function onAfterUserDelete(&$element){
$this->massaction->trigger('onAfterUserDelete',$this->deletedUser);
}
}
massaction_user.xml000064400000001265151157241550010477 0ustar00<?xml
version="1.0" encoding="utf-8"?>
<extension type="plugin" version="2.5"
method="upgrade" group="hikashop">
<name>Hikashop Massaction User Plugin</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>This plugin enables you to make massactions on
users</description>
<files>
<filename
plugin="massaction_user">massaction_user.php</filename>
</files>
</extension>