function cp_calculatedfieldsf_export_csv()
{
$toExclude = array('fcommentarea', 'fsectionbreak', 'fpagebreak', 'fsummary', 'fmedia', 'ffieldset', 'fdiv', 'fbutton');
if (!is_admin()) {
return;
}
global $wpdb;
if (!defined('CP_CALCULATEDFIELDSF_ID')) {
define('CP_CALCULATEDFIELDSF_ID', intval($_GET["cal"]));
}
$headers = array("Form ID", "Submission ID", "Time", "IP Address", "email", "Paid", "Final Price", "Coupon");
$fields = array(0, 1, 2, 3, 4, 5, 6, 7);
$values = array();
$form_data = cp_calculatedfieldsf_get_option('form_structure', CP_CALCULATEDFIELDSF_DEFAULT_form_structure);
$fields_list = cp_calculatedfieldsf_sorting_fields_in_containers($form_data[0]);
// Get headers and fields
for ($i = 0; $i < count($fields_list); $i++) {
$field = $fields_list[$i];
$fieldType = strtolower($field->ftype);
if (!in_array($fieldType, $toExclude)) {
$fields[] = $field->name;
$headers[] = !empty($field->shortlabel) ? $field->shortlabel : (!empty($field->title) ? $field->title : $field->name);
}
}
// Get rows
$cond = '';
if ($_GET["search"] != '') {
$cond .= " AND (data like '%" . esc_sql($_GET["search"]) . "%' OR paypal_post LIKE '%" . esc_sql($_GET["search"]) . "%')";
}
if ($_GET["dfrom"] != '') {
$cond .= " AND (`time` >= '" . esc_sql($_GET["dfrom"]) . "')";
}
if ($_GET["dto"] != '') {
$cond .= " AND (`time` <= '" . esc_sql($_GET["dto"]) . " 23:59:59')";
}
if (CP_CALCULATEDFIELDSF_ID != 0) {
$cond .= " AND formid=" . CP_CALCULATEDFIELDSF_ID;
}
$events_query = "SELECT * FROM " . CP_CALCULATEDFIELDSF_POSTS_TABLE_NAME . " WHERE 1=1 " . $cond . " ORDER BY `time` DESC";
/**
* Allows modify the query of messages, passing the query as parameter
* returns the new query
*/
$events_query = apply_filters('cpcff_csv_query', $events_query);
$events = $wpdb->get_results($events_query);
foreach ($events as $item) {
$data = array();
$data = @unserialize($item->paypal_post);
if ($data === false) {
continue;
}
$value = array($item->formid, $item->id, $item->time, $item->ipaddr, $item->notifyto, $item->paid ? "Yes" : "No", @$data["final_price"], @$data["coupon"]);
unset($data["final_price"]);
unset($data["coupon"]);
$value = array_merge($value, $data);
$values[] = $value;
}
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=export.csv");
// Print headers
foreach ($headers as $header) {
echo '"' . str_replace('"', '""', $header) . '",';
}
echo "\n";
// Print rows
foreach ($values as $item) {
foreach ($fields as $field) {
if (!isset($item[$field])) {
$item[$field] = '';
}
if (is_array($item[$field])) {
$item[$field] = implode($item[$field], ',');
}
echo '"' . str_replace('"', '""', $item[$field]) . '",';
}
echo "\n";
}
exit;
}
function cp_calculatedfieldsf_get_public_form($id)
{
global $wpdb, $cpcff_default_texts_array;
global $CP_CFF_global_form_count;
global $CP_CFF_global_form_count_number;
$CP_CFF_global_form_count_number++;
$CP_CFF_global_form_count = "_" . $CP_CFF_global_form_count_number;
if (!defined('CP_AUTH_INCLUDE')) {
define('CP_AUTH_INCLUDE', true);
}
if ($id != '') {
$myrows = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . CP_CALCULATEDFIELDSF_FORMS_TABLE . " WHERE id=%d", $id));
} else {
$myrows = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . CP_CALCULATEDFIELDSF_FORMS_TABLE);
}
$previous_label = cp_calculatedfieldsf_get_option('vs_text_previousbtn', 'Previous', $id);
$previous_label = $previous_label == '' ? 'Previous' : $previous_label;
$next_label = cp_calculatedfieldsf_get_option('vs_text_nextbtn', 'Next', $id);
$next_label = $next_label == '' ? 'Next' : $next_label;
$cpcff_texts_array = cp_calculatedfieldsf_get_option('vs_all_texts', $cpcff_default_texts_array, $id);
$cpcff_texts_array = array_replace_recursive($cpcff_default_texts_array, is_string($cpcff_texts_array) && is_array(unserialize($cpcff_texts_array)) ? unserialize($cpcff_texts_array) : (is_array($cpcff_texts_array) ? $cpcff_texts_array : array()));
$page_of_label = $cpcff_texts_array['page_of_text']['text'];
if (CP_CALCULATEDFIELDSF_DEFAULT_DEFER_SCRIPTS_LOADING) {
wp_deregister_script('query-stringify');
wp_register_script('query-stringify', plugins_url('/js/jQuery.stringify.js', __FILE__));
wp_deregister_script('cp_calculatedfieldsf_validate_script');
wp_register_script('cp_calculatedfieldsf_validate_script', plugins_url('/js/jquery.validate.js', __FILE__));
wp_enqueue_script('cp_calculatedfieldsf_buikder_script', cp_calculatedfieldsf_get_site_url() . (strpos(cp_calculatedfieldsf_get_site_url(), '?') === false ? '/?' : '&') . 'cp_cff_resources=public', array("jquery", "jquery-ui-core", "jquery-ui-button", "jquery-ui-datepicker", "jquery-ui-widget", "jquery-ui-position", "jquery-ui-tooltip", "query-stringify", "cp_calculatedfieldsf_validate_script", "jquery-ui-slider"), false, true);
if ($id == '') {
$id = $myrows[0]->id;
}
wp_localize_script('cp_calculatedfieldsf_buikder_script', 'cp_calculatedfieldsf_fbuilder_config' . $CP_CFF_global_form_count, array('obj' => '{"pub":true,"identifier":"' . $CP_CFF_global_form_count . '","messages": {
"required": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_is_required', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_is_required, $id)) . '",
"email": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_is_email', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_is_email, $id)) . '",
"datemmddyyyy": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_datemmddyyyy', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_datemmddyyyy, $id)) . '",
"dateddmmyyyy": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_dateddmmyyyy', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_dateddmmyyyy, $id)) . '",
"number": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_number', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_number, $id)) . '",
"digits": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_digits', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_digits, $id)) . '",
"max": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_max', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_max, $id)) . '",
"min": "' . str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_min', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_min, $id)) . '",
"previous": "' . str_replace(array('"'), array('\\"'), $previous_label) . '",
"next": "' . str_replace(array('"'), array('\\"'), $next_label) . '",
"pageof": "' . str_replace(array('"'), array('\\"'), $page_of_label) . '"
}}'));
} else {
wp_enqueue_script("jquery");
wp_enqueue_script("jquery-ui-core");
wp_enqueue_script("jquery-ui-datepicker");
wp_enqueue_script("jquery-ui-slider");
}
$codes = $wpdb->get_results($wpdb->prepare('SELECT * FROM ' . CP_CALCULATEDFIELDSF_DISCOUNT_CODES_TABLE_NAME . ' WHERE `form_id`=%d', $id));
@(include dirname(__FILE__) . '/cp_calculatedfieldsf_public_int.inc.php');
if (!CP_CALCULATEDFIELDSF_DEFAULT_DEFER_SCRIPTS_LOADING) {
// This code won't be used in most cases. This code is for preventing problems in wrong WP themes and conflicts with third party plugins.
$plugin_url = plugins_url('', __FILE__);
$prefix_ui = '';
if (@file_exists(dirname(_FILE_) . '/../../../wp-includes/js/jquery/ui/jquery.ui.core.min.js')) {
$prefix_ui = 'jquery.ui.';
}
?>
<script> if( typeof jQuery != 'undefined' ) var jQueryBK = jQuery.noConflict(); </script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/jquery.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'core.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'datepicker.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'widget.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'position.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'tooltip.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'mouse.min.js';
?>
'></script>
<script type='text/javascript' src='<?php
echo $plugin_url . '/../../../wp-includes/js/jquery/ui/' . $prefix_ui . 'slider.min.js';
?>
'></script>
<script>
var fbuilderjQuery = jQuery.noConflict( );
if( typeof jQueryBK != 'undefined' ) jQuery = jQueryBK;
</script>
<script type='text/javascript' src='<?php
echo plugins_url('js/jQuery.stringify.js', __FILE__);
?>
'></script>
<script type='text/javascript' src='<?php
echo plugins_url('js/jquery.validate.js', __FILE__);
?>
'></script>
<script type='text/javascript'>
/* <![CDATA[ */
var cp_calculatedfieldsf_fbuilder_config<?php
echo $CP_CFF_global_form_count;
?>
= {"obj":"{\"pub\":true,\"identifier\":\"<?php
echo $CP_CFF_global_form_count;
?>
\",\"messages\": {\n \t \t\"required\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_is_required', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_is_required, $id));
?>
\",\n \t \t\"email\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_is_email', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_is_email, $id));
?>
\",\n \t \t\"datemmddyyyy\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_datemmddyyyy', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_datemmddyyyy, $id));
?>
\",\n \t \t\"dateddmmyyyy\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_dateddmmyyyy', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_dateddmmyyyy, $id));
?>
\",\n \t \t\"number\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_number', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_number, $id));
?>
\",\n \t \t\"digits\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_digits', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_digits, $id));
?>
\",\n \t \t\"max\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_max', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_max, $id));
?>
\",\n \t \t\"min\": \"<?php
echo str_replace(array('"'), array('\\"'), cp_calculatedfieldsf_get_option('vs_text_min', CP_CALCULATEDFIELDSF_DEFAULT_vs_text_min, $id));
?>
\",\"previous\": \"<?php
echo str_replace(array('"'), array('\\"'), $previous_label);
?>
\",\"next\": \"<?php
echo str_replace(array('"'), array('\\"'), $next_label);
?>
\",\"pageof\": \"<?php
echo str_replace(array('"'), array('\\"'), $page_of_label);
?>
\"\n \t }}"};
/* ]]> */
</script>
<script type='text/javascript' src='<?php
echo cp_calculatedfieldsf_get_site_url() . (strpos(cp_calculatedfieldsf_get_site_url(), '?') === false ? '/?' : '&') . 'cp_cff_resources=public';
?>
'></script>
<?php
}
}
/**
* Display the form associated to the product
*/
public function display_form()
{
global $post, $woocommerce;
if ($this->apply_addon()) {
$product = null;
if (function_exists('get_product')) {
$product = get_product($post->ID);
} else {
$product = new WC_Product($post->ID);
}
$form_content = cp_calculatedfieldsf_filter_content($this->form);
// Initialize form fields
if (!empty($_SESSION['cp_cff_form_data']) && !empty($_REQUEST['cp_calculatedfieldsf_id']) && !empty($_REQUEST['cp_calculatedfieldsf_pform_psequence'])) {
global $wpdb;
$result = $wpdb->get_row($wpdb->prepare("SELECT form_data.paypal_post AS paypal_post FROM " . CP_CALCULATEDFIELDSF_POSTS_TABLE_NAME . " AS form_data WHERE form_data.id=%d AND form_data.formid=%d", $_SESSION['cp_cff_form_data'], $_REQUEST['cp_calculatedfieldsf_id']));
if (!is_null($result)) {
$arr = array();
$submitted_data = unserialize($result->paypal_post);
foreach ($submitted_data as $key => $val) {
if (preg_match('/^fieldname\\d+$/', $key)) {
$arr[$key . $_REQUEST['cp_calculatedfieldsf_pform_psequence']] = $val;
}
}
?>
<script>
cpcff_default = ( typeof cpcff_default != 'undefined' ) ? cpcff_default : {};
cpcff_default[ 'form_structure<?php
echo $_REQUEST['cp_calculatedfieldsf_pform_psequence'];
?>
' ] = <?php
echo json_encode($arr);
?>
;
</script>
<?php
}
}
unset($_SESSION['cp_cff_form_data']);
// Remove the form tags
if (preg_match('/<form[^>]*>/', $form_content, $match)) {
$form_content = str_replace($match[0], '', $form_content);
$form_content = preg_replace('/<\\/form>/', '', $form_content);
}
$tmp = get_post_meta($post->ID, 'woocommerce_cpcff_calculate_price', true);
$request_cost = !empty($tmp) ? cp_calculatedfieldsf_get_option('request_cost', false, $this->form['id']) : false;
echo '<div class="cpcff-woocommerce-wrapper">' . $form_content . (method_exists($woocommerce, 'nonce_field') ? $woocommerce->nonce_field('add_to_cart') : '') . '<input type="hidden" name="woocommerce_cpcff_product" value="' . $post->ID . '" />' . ($request_cost ? '<input type="hidden" name="woocommerce_cpcff_field" value="' . $request_cost . '" /><input type="hidden" name="woocommerce_cpcff_form" value="' . $this->form['id'] . '">' : '') . '</div>';
$add_to_cart_value = '';
if ($product->is_type('variable')) {
$add_to_cart_value = 'variation';
} elseif ($product->has_child()) {
$add_to_cart_value = 'group';
} else {
$add_to_cart_value = $product->id;
}
if (!function_exists('get_product')) {
//1.x only
if (method_exists($woocommerce, 'nonce_field')) {
$woocommerce->nonce_field('add_to_cart');
}
echo '<input type="hidden" name="add-to-cart" value="' . $add_to_cart_value . '" />';
} else {
echo '<input type="hidden" name="add-to-cart" value="' . $post->ID . '" />';
}
}
echo '<div class="clear"></div>';
}
echo $pitem;
?>
<br />
<?php
}
?>
</div>
<div class="clearer"></div>
</div>
<?php
}
?>
</div>
<?php
if (cp_calculatedfieldsf_get_option('enable_submit', '', $id) == '') {
?>
<div id="cp_subbtn<?php
echo $CP_CFF_global_form_count;
?>
" class="cp_subbtn"><?php
_e($button_label);
?>
</div>
<?php
}
?>
<div class="clearer"></div>
</div>
<?php
}
if (!defined('CP_AUTH_INCLUDE')) {
echo 'Direct access not allowed.';
exit;
}
?>
<link href="<?php
echo plugins_url('css/stylepublic.css', __FILE__);
?>
" type="text/css" rel="stylesheet" />
<link href="<?php
echo plugins_url('css/cupertino/jquery-ui-1.8.20.custom.css', __FILE__);
?>
" type="text/css" rel="stylesheet" />
<?php
$raw_form_str = str_replace("\r", " ", str_replace("\n", " ", cp_calculatedfieldsf_cleanJSON(cp_calculatedfieldsf_get_option('form_structure', CP_CALCULATEDFIELDSF_DEFAULT_form_structure, $id))));
$form_data = json_decode($raw_form_str);
if (is_null($form_data)) {
$json = new JSON();
$form_data = $json->unserialize($raw_form_str);
}
if (!is_null($form_data) && isset($form_data[1]) && isset($form_data[1][0]) && isset($form_data[1][0]->formtemplate)) {
$templatelist = cp_calculatedfieldsf_available_templates();
if (isset($templatelist[$form_data[1][0]->formtemplate])) {
print '<link href="' . esc_attr(esc_url($templatelist[$form_data[1][0]->formtemplate]['file'])) . '" type="text/css" rel="stylesheet" />';
if (isset($templatelist[$form_data[1][0]->formtemplate]['js'])) {
print '<script src="' . esc_attr(esc_url($templatelist[$form_data[1][0]->formtemplate]['js'])) . '"></script>';
}
}
}
$raw_form_str = str_replace('"', '"', esc_attr($raw_form_str));
?>
>Font 1</option>
<option value="font-2.ttf"<?php
if ("font-2.ttf" == cp_calculatedfieldsf_get_option('cv_font', CP_CALCULATEDFIELDSF_DEFAULT_cv_font)) {
echo " selected";
}
?>
>Font 2</option>
<option value="font-3.ttf"<?php
if ("font-3.ttf" == cp_calculatedfieldsf_get_option('cv_font', CP_CALCULATEDFIELDSF_DEFAULT_cv_font)) {
echo " selected";
}
?>
>Font 3</option>
<option value="font-4.ttf"<?php
if ("font-4.ttf" == cp_calculatedfieldsf_get_option('cv_font', CP_CALCULATEDFIELDSF_DEFAULT_cv_font)) {
echo " selected";
}
?>
>Font 4</option>
</select>
</td>
</tr>
</table>
</div>
</div>
<?php
global $cpcff_addons_objs_list, $cpcff_addons_active_list;
if (count($cpcff_addons_active_list)) {
_e('<h2>Add-Ons Settings:</h2><hr />', 'calculated-fields-form');
