Server : Apache System : Linux webm006.cluster103.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : chryzalihi ( 621211) PHP Version : 8.3.31 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Directory : /home/c/h/r/chryzalihi/www/wp-content/languages/themes/the/ |
chryzalihi/www/wp-contentOLD/plugins/contact-form-maker/admin/models/FMModelGenerete_csv_fmc.php 0000604 00000030443 15244166532 0027754 0 ustar 00 home <?php
class FMModelGenerete_csv_fmc {
////////////////////////////////////////////////////////////////////////////////////////
// Events //
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Constants //
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Variables //
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Constructor & Destructor //
////////////////////////////////////////////////////////////////////////////////////////
public function __construct() {
}
////////////////////////////////////////////////////////////////////////////////////////
// Public Methods //
////////////////////////////////////////////////////////////////////////////////////////
public function get_data() {
global $wpdb;
$is_paypal_info = FALSE;
$params = array();
$group_id_s = array();
$form_id = (int)$_REQUEST['form_id'];
$limitstart = (int)$_REQUEST['limitstart'];
$paypal_info_fields = array('currency', 'ord_last_modified', 'status', 'full_name', 'fax', 'mobile_phone', 'email', 'phone', 'address', 'paypal_info', 'ipn', 'tax', 'shipping');
$paypal_info_labels = array( 'Currency', 'Last modified', 'Status', 'Full Name', 'Fax', 'Mobile phone', 'Email', 'Phone', 'Address', 'Paypal info', 'IPN', 'Tax', 'Shipping');
$query = $wpdb->prepare("SELECT distinct group_id FROM " . $wpdb->prefix . "formmaker_submits where form_id=%d", $form_id);
$group_id_s = $wpdb->get_col($query);
$query = $wpdb->prepare("SELECT distinct element_label FROM " . $wpdb->prefix . "formmaker_submits where form_id=%d",$form_id);
$labels = $wpdb->get_col($query);
$query_lable = $wpdb->prepare("SELECT label_order,title FROM " . $wpdb->prefix . "formmaker where id=%d", $form_id);
$rows_lable = $wpdb->get_results($query_lable);
$ptn = "/[^a-zA-Z0-9_]/";
$rpltxt = "";
$title = isset($rows_lable[0]) ? preg_replace($ptn, $rpltxt, $rows_lable[0]->title) : '';
$sorted_labels_id = array();
$sorted_labels = array();
$label_titles = array();
$label_id = array();
$label_order = array();
$label_order_original = array();
$label_type = array();
if ($labels) {
$label_all = explode('#****#', $rows_lable[0]->label_order);
$label_all = array_slice($label_all, 0, count($label_all) - 1);
foreach ($label_all as $key => $label_each) {
$label_id_each = explode('#**id**#', $label_each);
array_push($label_id, $label_id_each[0]);
$label_oder_each = explode('#**label**#', $label_id_each[1]);
array_push($label_order_original, $label_oder_each[0]);
$label_temp = preg_replace($ptn, $rpltxt, $label_oder_each[0]);
array_push($label_order, $label_temp);
array_push($label_type, $label_oder_each[1]);
}
foreach ($label_id as $key => $label) {
if (in_array($label, $labels) && $label_type[$key] !='type_arithmetic_captcha') {
array_push($sorted_labels, $label_order[$key]);
array_push($sorted_labels_id, $label);
array_push($label_titles, stripslashes($label_order_original[$key]));
}
}
}
$m = count($sorted_labels);
$wpdb->query("SET SESSION group_concat_max_len = 1000000");
$query = $wpdb->prepare("SELECT group_id, ip, date, user_id_wd, GROUP_CONCAT( element_label SEPARATOR ',') as element_label, GROUP_CONCAT( element_value SEPARATOR '*:*el_value*:*') as element_value FROM " . $wpdb->prefix . "formmaker_submits where form_id= %d GROUP BY group_id ORDER BY date ASC limit %d, %d", $form_id, $limitstart, 1000);
$rows = $wpdb->get_results($query, OBJECT_K);
$data = array();
$group_id_s_count = $limitstart + 1000 < count($group_id_s) ? $limitstart + 1000 : count($group_id_s);
for ($www = $limitstart; $www < $group_id_s_count; $www++) {
$i = $group_id_s[$www];
$field_key = array_search($i, $label_id);
if($label_type[$field_key] != 'type_arithmetic_captcha') {
$data_temp = array();
$tt = $rows[$i];
$date = $tt->date;
$ip = $tt->ip;
$user_id = get_userdata($tt->user_id_wd);
$username = $user_id ? $user_id->display_name : "";
$useremail = $user_id ? $user_id->user_email : "";
$data_temp['Submit date'] = $date;
$data_temp['Ip']=$ip;
$data_temp['Submitter\'s Username']=$username;
$data_temp['Submitter\'s Email Address']=$useremail;
$element_labels = explode(',', $tt->element_label);
$element_values = explode('*:*el_value*:*', $tt->element_value);
for ($h = 0; $h < $m; $h++) {
if(isset($data_temp[$label_titles[$h]]))
$label_titles[$h] .= '(1)';
if(in_array($sorted_labels_id[$h], $element_labels)) {
$element_value = $element_values[array_search($sorted_labels_id[$h], $element_labels)];
if (strpos($element_value, "*@@url@@*")) {
$file_names = '';
$new_files = explode("*@@url@@*", $element_value);
foreach ($new_files as $new_file) {
if ($new_file) {
$file_names .= $new_file . ", ";
}
}
$data_temp[stripslashes($label_titles[$h])] = $file_names;
}
elseif (strpos($element_value, "***br***")) {
$element_value = str_replace("***br***", ', ', $element_value);
if (strpos($element_value, "***quantity***")) {
$element_value = str_replace("***quantity***", '', $element_value);
}
if (strpos($element_value, "***property***")) {
$element_value = str_replace("***property***", '', $element_value);
}
if(substr($element_value, -2) == ', ') {
$data_temp[stripslashes($label_titles[$h])]= substr($element_value, 0, -2);
}
else {
$data_temp[stripslashes($label_titles[$h])]= $element_value;
}
}
elseif (strpos($element_value, "***map***")) {
$data_temp[stripslashes($label_titles[$h])] = 'Longitude:' . str_replace("***map***", ', Latitude:', $element_value);
}
elseif (strpos($element_value, "***star_rating***")) {
$element = str_replace("***star_rating***", '', $element_value);
$element = explode("***", $element);
$data_temp[stripslashes($label_titles[$h])] = ' ' . $element[1] . '/' . $element[0];
}
elseif (strpos($element_value, "@@@") || $element_value == "@@@" || $element_value == "@@@@@@@@@") {
$data_temp[stripslashes($label_titles[$h])] = str_replace("@@@", ' ', $element_value);
}
elseif (strpos($element_value, "***grading***")) {
$element = str_replace("***grading***", '', $element_value);
$grading = explode(":", $element);
$items_count = sizeof($grading) - 1;
$items = "";
$total = "";
for ($k = 0; $k < $items_count / 2; $k++) {
$items .= $grading[$items_count / 2 + $k] . ": " . $grading[$k] . ", ";
$total += $grading[$k];
}
$items .= "Total: " . $total;
$data_temp[stripslashes($label_titles[$h])] = $items;
}
elseif (strpos($element_value, "***matrix***")) {
$element = str_replace("***matrix***", '', $element_value);
$matrix_value = explode('***', $element);
$matrix_value = array_slice($matrix_value, 0, count($matrix_value) - 1);
$mat_rows = $matrix_value[0];
$mat_columns = $matrix_value[$mat_rows + 1];
$matrix = "";
$aaa = array();
$var_checkbox = 1;
$selected_value = "";
$selected_value_yes = "";
$selected_value_no = "";
for ($k = 1; $k <= $mat_rows; $k++) {
if ($matrix_value[$mat_rows + $mat_columns + 2] == "radio") {
if ($matrix_value[$mat_rows + $mat_columns + 2 + $k] == 0) {
$checked = "0";
$aaa[1] = "";
}
else {
$aaa = explode("_", $matrix_value[$mat_rows + $mat_columns + 2 + $k]);
}
for ($l = 1; $l <= $mat_columns; $l++) {
$checked = $aaa[1] == $l ? '1' : '0';
$matrix .= '['.$matrix_value[$k].','.$matrix_value[$mat_rows+1+$l].']='.$checked."; ";
}
}
else {
if ($matrix_value[$mat_rows+$mat_columns + 2] == "checkbox") {
for ($l = 1; $l <= $mat_columns; $l++) {
$checked = $matrix_value[$mat_rows+$mat_columns + 2 + $var_checkbox] == 1 ? '1' : '0';
$matrix .= '['.$matrix_value[$k].','.$matrix_value[$mat_rows+1+$l].']='.$checked."; ";
$var_checkbox++;
}
}
else {
if ($matrix_value[$mat_rows+$mat_columns + 2] == "text") {
for ($l = 1; $l <= $mat_columns; $l++) {
$text_value = $matrix_value[$mat_rows+$mat_columns+2+$var_checkbox];
$matrix .='['.$matrix_value[$k].','.$matrix_value[$mat_rows+1+$l].']='.$text_value."; ";
$var_checkbox++;
}
}
else {
for ($l = 1; $l <= $mat_columns; $l++) {
$selected_text = $matrix_value[$mat_rows+$mat_columns + 2 + $var_checkbox];
$matrix .= '['.$matrix_value[$k].','.$matrix_value[$mat_rows + 1 + $l].']='.$selected_text."; ";
$var_checkbox++;
}
}
}
}
}
$data_temp[stripslashes($label_titles[$h])] = $matrix;
}
else {
$val = htmlspecialchars_decode($element_value);
$val = stripslashes(str_replace(''', "'", $val));
$data_temp[stripslashes($label_titles[$h])] = ($element_value ? $val : '');
}
}
else
$data_temp[stripslashes($label_titles[$h])] = '';
}
$query = $wpdb->prepare("SELECT id FROM " . $wpdb->prefix . "formmaker_submits where element_label=%s AND form_id = %d AND group_id=%d",'item_total', $form_id, $i);
$is_paypal = $wpdb->get_results($query);
if($is_paypal) {
$item_total = $wpdb->get_var($wpdb->prepare("SELECT `element_value` FROM " . $wpdb->prefix . "formmaker_submits where group_id=%d AND element_label=%s", $i, 'item_total'));
$total = $wpdb->get_var($wpdb->prepare("SELECT `element_value` FROM " . $wpdb->prefix . "formmaker_submits where group_id=%d AND element_label=%s", $i, 'total'));
$payment_status = $wpdb->get_var($wpdb->prepare("SELECT `element_value` FROM " . $wpdb->prefix . "formmaker_submits where group_id=%d AND element_label=%s", $i, '0'));
$data_temp['Item Total'] = $item_total;
$data_temp['Total'] = $total;
$data_temp['Payment Status'] = $payment_status;
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "formmaker_sessions where group_id=%d",$i);
$paypal_info = $wpdb->get_results($query);
if ($paypal_info) {
$is_paypal_info = TRUE;
}
if ($is_paypal) {
foreach ($paypal_info_fields as $key=>$paypal_info_field) {
if ($paypal_info) {
$data_temp['PAYPAL_'.$paypal_info_labels[$key]]=$paypal_info[0]->$paypal_info_field;
}
else {
$data_temp['PAYPAL_'.$paypal_info_labels[$key]]='';
}
}
}
$data[$i] = $data_temp;
}
}
array_push($params, $data);
array_push($params, $title);
array_push($params, $is_paypal_info);
return $params;
}
////////////////////////////////////////////////////////////////////////////////////////
// Getters & Setters //
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Private Methods //
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Listeners //
////////////////////////////////////////////////////////////////////////////////////////
}