function cw_review_prepare_and_send_reminder($params, $return) { global $tables, $config; // Follow up email notifications if (!empty($config['estore_products_review']['amount_days_order_review_product'])) { $count_days = $config['estore_products_review']['amount_days_order_review_product']; $count_seconds = SECONDS_PER_DAY * $count_days; $check_seconds = cw_core_get_time() - $count_seconds; $status_remind = $config['estore_products_review']['order_status_start_reminder']; $not_reviews_products = cw_query("\n SELECT DISTINCT di.product_id, ui.customer_id\n FROM {$tables['docs']} d\n LEFT JOIN {$tables['docs_items']} di ON di.doc_id = d.doc_id\n LEFT JOIN {$tables['docs_user_info']} ui ON ui.doc_info_id = d.doc_info_id\n LEFT JOIN {$tables['products_reviews']} r ON r.product_id = di.product_id\n LEFT JOIN {$tables['products_reviews_reminder']} rr ON rr.product_id = di.product_id\n AND ui.customer_id = rr.customer_id\n WHERE d.status_change < {$check_seconds} AND d.type = 'O' AND d.status = '{$status_remind}'\n AND ui.customer_id <> 0 AND r.product_id IS NULL\n AND rr.product_id IS NULL AND di.product_id IS NOT NULL\n ORDER BY d.doc_id\n "); if (!empty($not_reviews_products) && is_array($not_reviews_products)) { $customer_products = array(); foreach ($not_reviews_products as $_r) { $customer_products[$_r['customer_id']][] = $_r['product_id']; } cw_review_send_order_review_reminder_email($customer_products); } } return $return; }
<?php if (constant('IS_AJAX') && is_numeric($doc_id)) { global $tables; $remind_products = cw_query("\n SELECT DISTINCT di.product_id, ui.customer_id\n FROM {$tables['docs']} d\n LEFT JOIN {$tables['docs_items']} di ON di.doc_id = d.doc_id\n LEFT JOIN {$tables['docs_user_info']} ui ON ui.doc_info_id = d.doc_info_id\n WHERE d.doc_id = {$doc_id}\n "); if (!empty($remind_products) && is_array($remind_products)) { $customer_products = array(); foreach ($remind_products as $_r) { $customer_products[$_r['customer_id']][] = $_r['product_id']; } cw_review_send_order_review_reminder_email($customer_products); $lbl_name = 'lbl_email_sent_successfully'; } else { $lbl_name = 'lbl_email_not_sent'; } cw_add_ajax_block(array('id' => 'additional_doc_action', 'action' => 'update', 'content' => cw_get_langvar_by_name($lbl_name, NULL, FALSE, TRUE))); }