public function execute()
{
$action_id = waRequest::get('id', null, waRequest::TYPE_STRING_TRIM);
if (!$action_id) {
throw new waException('No action id given.');
}
$chunk_size = 100;
$offset = (int) waRequest::get('offset');
$workflow = new shopWorkflow();
$order_model = new shopOrderModel();
// collect orders under which has performed actions
$updated_orders_ids = array();
$hash = $this->getHash();
if ($hash === null) {
return;
}
$collection = new shopOrdersCollection($hash);
$total_count = $collection->count();
$orders = $collection->getOrders('*', $offset, $chunk_size);
foreach ($orders as $order) {
$actions = $workflow->getStateById($order['state_id'])->getActions();
if (isset($actions[$action_id])) {
$actions[$action_id]->run($order['id']);
$updated_orders_ids[] = $order['id'];
}
}
if (!$updated_orders_ids) {
return;
}
$this->response = array('offset' => $offset + count($orders), 'total_count' => $total_count);
// sidebar counters
if ($this->response['offset'] >= $this->response['total_count']) {
$order_model = new shopOrderModel();
$state_counters = $order_model->getStateCounters();
$pending_count = (!empty($state_counters['new']) ? $state_counters['new'] : 0) + (!empty($state_counters['processing']) ? $state_counters['processing'] : 0) + (!empty($state_counters['paid']) ? $state_counters['paid'] : 0);
$this->response['state_counters'] = $state_counters;
$this->response['pending_count'] = $pending_count;
}
$collection = new shopOrdersCollection('id/' . implode(',', $updated_orders_ids));
$total_count = $collection->count();
$orders = $collection->getOrders('*,contact', 0, $total_count);
// orders for update items in table
shopHelper::workupOrders($orders);
$this->response['orders'] = array_values($orders);
}
public function execute()
{
$id = waRequest::request('id', null, waRequest::TYPE_INT);
$contact = new waContact($id);
$contact->getName();
// Customer orders
$im = new shopOrderItemsModel();
$orders_collection = new shopOrdersCollection('search/contact_id=' . $id);
$orders = $orders_collection->getOrders('*,items,params', 0, 500);
shopHelper::workupOrders($orders);
foreach ($orders as &$o) {
$o['total_formatted'] = waCurrency::format('%{s}', $o['total'], $o['currency']);
$o['shipping_name'] = ifset($o['params']['shipping_name'], '');
$o['payment_name'] = ifset($o['params']['payment_name'], '');
}
$this->view->assign('orders', $orders);
$this->view->assign('contact', $contact);
$this->view->assign('def_cur_tmpl', str_replace('0', '%s', waCurrency::format('%{s}', 0, wa()->getConfig()->getCurrency())));
}
public function execute()
{
$modelNotifierConfig = new shopNotifierConfigModel();
$modelNotifierLog = new shopNotifierLogModel();
$n_date = array('w' => 'week', 'd' => 'days', 'm' => 'hour', 'h' => 'minute');
$all_notifications = $modelNotifierConfig->getAll();
foreach ($all_notifications as $notification) {
$last_event_date = strtotime($modelNotifierLog->getLastDateByConfigId($notification['id']));
$last_event = strtotime('+' . $notification['repeat_number_time'] . ' ' . $n_date[$notification['repeat_period']], $last_event_date);
if (date('Y-m-d H:i:s', $last_event) < date('Y-m-d H:i:s')) {
$states = (array) json_decode($notification['state_name']);
$last_time = strtotime('-' . $notification['number_time'] . ' ' . $n_date[$notification['period']], $last_event_date);
$orders = array();
$orders_new = array();
foreach ($states as $s) {
if ($s == 'new') {
$collection = new shopOrdersCollection('search/state_id=new&create_datetime<' . date('Y-m-d H:i:s', $last_time));
$orders_new = $collection->getOrders('*,params,items,contact');
} else {
$states_without_new[] = $s;
}
}
$state_for_collection = is_array($states_without_new) ? implode('||', $states_without_new) : $states_without_new[0];
$collection = new shopOrdersCollection('search/state_id=' . $state_for_collection . '&update_datetime<' . date('Y-m-d H:i:s', $last_time));
$orders = $collection->getOrders('*,params,items,contact');
if (is_array($orders_new)) {
$orders = array_merge($orders, $orders_new);
}
$emails = array();
$notification['data_contact'] = json_decode($notification['data_contact']);
foreach ($notification['data_contact']->contact as $contact) {
$user = new waContact($contact);
// $email = array();
$email = $user->get('email');
$emails[$email[0]['value']] = $user->get('name');
}
if (!empty($notification['data_contact']->group)) {
$modelContactCategory = new waContactCategoryModel();
foreach ($notification['data_contact']->group as $group) {
$contacts = $modelContactCategory->getByField('category_id', $group);
// ->query("SELECT * FROM wa_contact_categories WHERE category_id = '".$gr."'")->fetchAll('contact_id');
foreach ($contacts as $key => $contact) {
$user = new waContact($key);
$email = array();
$email = $user->get('email');
$emails[$email[0]['value']] = $user->get('name');
}
}
}
$view = wa()->getView();
$shop_config = $general = wa('shop')->getConfig()->getGeneralSettings();
$from = $shop_config['email'];
if (!$from) {
$from = '*****@*****.**';
}
if (!empty($notification['send_email']) && self::isValidEmail($notification['send_email'])) {
$from = $notification['send_email'];
}
$body = file_get_contents(shopNotifierPlugin::path($notification['template']));
//TODO: File read error
if ($notification['group_senders'] == 1) {
if ($notification['save_to_order_log'] == 1) {
$order_log_model = new shopOrderLogModel();
foreach ($orders as $order) {
$order_log_model->add(array('order_id' => $order['id'], 'contact_id' => wa()->getUser()->getId(), 'before_state_id' => $order['state_id'], 'after_state_id' => $order['state_id'], 'text' => 'Отправлено уведомление на адреса из оповещания ' . $notification['config_name'], 'action_id' => 'comment'));
}
}
$view->clearAllAssign();
$view->assign('orders', $orders);
$subject_string = 'Обратите внимание на заказы';
$subject = $view->fetch('string:' . $subject_string);
$body = $view->fetch('string:' . $body);
$message = new waMailMessage($subject, $body);
$message->setTo($emails);
$message->setFrom($from);
$message->send();
} else {
foreach ($orders as $order) {
if ($notification['save_to_order_log'] == 1) {
$order_log_model = new shopOrderLogModel();
$order_log_model->add(array('order_id' => $order['id'], 'contact_id' => wa()->getUser()->getId(), 'before_state_id' => $order['state_id'], 'after_state_id' => $order['state_id'], 'text' => 'Отослано уведомление на емайлы из оповещания ' . $notification['config_name'], 'action_id' => 'comment'));
}
$view->clearAllAssign();
$view->assign('order', $order);
$subject_string = 'Заказ ' . shopHelper::encodeOrderId($order['id']);
$subject = $view->fetch('string:' . $subject_string);
$body = $view->fetch('string:' . $body);
$message = new waMailMessage($subject, $body);
$message->setTo($emails);
$message->setFrom($from);
$message->send();
}
}
$modelNotifierLog->add(array('config_id' => $notification['id']));
}
}
}
public function execute()
{
$id = waRequest::request('id', null, waRequest::TYPE_INT);
$scm = new shopCustomerModel();
$customer = $scm->getById($id);
try {
$contact = new waContact($id);
$contact->getName();
} catch (waException $e) {
// !!! What to do when shop_customer exists, but no wa_contact found?
throw $e;
}
$ccsm = new waContactCategoriesModel();
$contact_categories = $ccsm->getContactCategories($id);
$contacts_url = wa()->getAppUrl('contacts');
// Info above tabs
$top = array();
foreach (array('email', 'phone', 'im') as $f) {
if ($v = $contact->get($f, 'top,html')) {
$top[] = array('id' => $f, 'name' => waContactFields::get($f)->getName(), 'value' => is_array($v) ? implode(', ', $v) : $v);
}
}
// Get photo
$photo = $contact->get('photo');
$config = $this->getConfig();
$use_gravatar = $config->getGeneralSettings('use_gravatar');
$gravatar_default = $config->getGeneralSettings('gravatar_default');
if (!$photo && $use_gravatar) {
$photo = shopHelper::getGravatar($contact->get('email', 'default'), 96, $gravatar_default);
} else {
$photo = $contact->getPhoto(96);
}
$contact['photo'] = $photo;
// Customer orders
$im = new shopOrderItemsModel();
$orders_collection = new shopOrdersCollection('search/contact_id=' . $id);
$total_count = $orders_collection->count();
$orders = $orders_collection->getOrders('*,items,params', 0, $total_count);
shopHelper::workupOrders($orders);
foreach ($orders as &$o) {
$o['total_formatted'] = waCurrency::format('%{s}', $o['total'], $o['currency']);
$o['shipping_name'] = ifset($o['params']['shipping_name'], '');
$o['payment_name'] = ifset($o['params']['payment_name'], '');
// !!! TODO: shipping and payment icons
}
// Customer reviews
$prm = new shopProductReviewsModel();
$reviews = $prm->getList('*,is_new,product', array('escape' => false, 'where' => array('contact_id' => $id), 'limit' => false));
// Customer affiliate transactions history
$atm = new shopAffiliateTransactionModel();
$affiliate_history = $atm->getByContact($id);
$this->view->assign('top', $top);
$this->view->assign('orders', $orders);
$this->view->assign('reviews', $reviews);
$this->view->assign('contact', $contact);
$this->view->assign('customer', $customer);
$this->view->assign('contacts_url', $contacts_url);
$this->view->assign('affiliate_history', $affiliate_history);
$this->view->assign('contact_categories', $contact_categories);
$this->view->assign('def_cur_tmpl', str_replace('0', '%s', waCurrency::format('%{s}', 0, wa()->getConfig()->getCurrency())));
$this->view->assign('point_rate', str_replace(',', '.', (double) str_replace(',', '.', wa()->getSetting('affiliate_usage_rate'))));
$fields = waContactFields::getAll('person');
if (isset($fields['name'])) {
unset($fields['name']);
}
$this->view->assign('fields', $fields);
$this->view->assign('orders_default_view', $config->getOption('orders_default_view'));
/*
* @event backend_customer
* @return array[string]array $return[%plugin_id%] array of html output
* @return array[string][string]string $return[%plugin_id%]['info_section'] html output
* @return array[string][string]string $return[%plugin_id%]['name_suffix'] html output
* @return array[string][string]string $return[%plugin_id%]['header'] html output
* @return array[string][string]string $return[%plugin_id%]['action_link'] html output
*/
$this->view->assign('backend_customer', wa()->event('backend_customer', $customer));
}
public function getTotalCount()
{
//return $this->model->countByField($this->getFilterParams());
return $this->collection->count();
}