FMModelGenerete_csv.php

/wp-content/plugins/form-maker/admin/models/FMModelGenerete_csv.php

https://gitlab.com/ezgonzalez/integral
PHP | 270 lines | 241 code | 14 blank | 15 comment | 41 complexity | caff0555fe685214cbba32192c675f29 MD5 | raw file

<?php



class FMModelGenerete_csv {

  ////////////////////////////////////////////////////////////////////////////////////////

  // 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['Submission ID'] = $i;

				$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('&#039;', "'", $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                                                                          //

  ////////////////////////////////////////////////////////////////////////////////////////

}