Array
(
[199] => AllevaWrap Order ID
[241] => AllevaWrap Pro Order Number
)
199AllevaWrap Order ID241AllevaWrap Pro Order NumberArray
(
[4] => Waver Vibration Order ID
[5] => Waver Vibration Color
[6] => GDPR Terms & Conditions
[20] => Waver Mini Order ID
[21] => Waver Mini Press Order ID
[26] => Turbo Order ID
[28] => Turbo Press Order ID
[29] => Turbo Boost Order ID
[30] => Hover Order ID
[32] => Rumblex Order ID
[33] => Rhythm Vibrating Platform Order ID
[34] => Rumblex Plus Order ID
[35] => Rumblex Pro Order ID
[36] => Vitalize Order ID
[37] => Vivid Order ID
[39] => Waver Mini Press Color
[40] => Waver Press Color
[41] => Turbo Color
[42] => Turbo Press Color
[43] => Turbo Boost Color
[44] => Hovert Color
[45] => Rumblex Color
[46] => Rumblex Plus Color
[47] => Rumblex Pro Color
[49] => Waver Mini Color
[50] => Dash X Order ID
[51] => Pacer Order ID
[52] => FlexCycle Exercise Bike Orientation Order ID
[53] => Electrostride Order ID
[54] => Swift Order ID
[55] => Pawrunner Order ID
[56] => X-FlexCycle Order ID
[57] => FlexStride Order ID
[58] => FlexStride Pro Order ID
[59] => FlexCycle Exercise Bike Orientation Color
[60] => Infinity Order ID
[61] => Infinity Plus Order ID
[62] => PowerFlow Plus 2 pcs Order ID
[63] => PowerUp Dumbbells Order ID
[67] => Agility Plus Order ID
[69] => Velocity Ball Order ID
[70] => Radiate Leg Compression Order ID
[71] => Radiate Plus Compression Order ID
[72] => Radiate X Compression Order ID
[73] => Verdure Leg Exerciser Order ID
[74] => Legra Hand Massager Order ID
[75] => Legra Plus Order ID
[76] => Marvalax Order ID
[77] => Relaxatilt X Order ID
[78] => Relaxatilt Order ID
[79] => Vibracare Plus Order ID
[80] => Relaxatilt Pro Order ID
[81] => Serenity Order ID
[82] => Relaxify Order ID
[83] => Oculax Order ID
[84] => Surger Pro Order ID
[85] => Vizacure Order ID
[86] => Allevared Order ID
[87] => Horizon Order ID
[88] => Fleximod Order ID
[89] => LumiCure Order ID
[90] => Agility Ball Order ID
[91] => Legra Hand Massager Color
[92] => Legra Plus Color
[93] => Velocity Ball Color
[94] => Relaxatilt X Color
[95] => Relaxatilt Color
[96] => Relaxatilt Pro Color
[97] => Horizon Color
[98] => SonicLX Order ID
[99] => Pulse Order ID
[100] => PulseFX Order ID
[101] => SonicX Order ID
[102] => FusionFX Order ID
[103] => Fusion X Order ID
[104] => DynaFlex Mini Order ID
[105] => DynaFlow Order ID
[106] => DynaLife Order ID
[107] => DynaSphere Order ID
[108] => Sonic Plus Order ID
[109] => Sonic Pro Order ID
[110] => Sonic E Order ID
[111] => DynaMini Order ID
[112] => Sonic LX Color
[113] => Sonic Plus Color
[114] => Sonic E Color
[115] => Sonic Pro Color
[117] => DynaMini Color
[118] => X-FlexCycle Plus Order ID
[119] => X-FlexCycle Pro Order ID
[120] => Sonic M1 Order ID
[121] => Sonic Order ID
[122] => Velocity Vibrating Ball V 2.0 Order ID
[123] => Dyna Mini X Order ID
[124] => Dyna Flex Order ID
[125] => AcuCare Pro Heating + Air Pressure Foot Massager Order ID
[126] => AcuCare Tilt Foot Massager Order ID
[127] => AcuLux Foot Massager Order ID
[128] => Axis Air Compression Massager Order ID
[129] => Charm Neck Massager Order ID
[130] => Embrace Neck Massager Order ID
[132] => Grace Neck Massager Order ID
[133] => Allevaglove Order ID
[134] => Allevared Pro Order ID
[135] => Pearl Hand Massager Order ID
[136] => Plush Hand Massager Order ID
[138] => BioCare Order ID
[139] => Bio Remedy Order ID
[140] => Infraglow Red and Infrared Light Therapy Order ID
[141] => Bio Heal Red Light Panel Order ID
[142] => Bio Lux Light Therapy Wand Order ID
[143] => CryoFrost Compression System Blue Order ID
[144] => Infradome Order ID
[145] => Lumicare Pro Light Therapy Torch Order ID
[146] => MediRipple Foot Massager Order ID
[147] => Rejuvwrap Infrared Sauna Blanket Order ID
[148] => Vibracare Foot Massager Order ID
[149] => TropicCare Steam Foot Massager Order ID
[150] => PowerFlow 1 pc Order ID
[151] => PowerFlow 2 pcs Order ID
[152] => PowerFlow Plus 1 pc Order ID
[153] => Power Flow Max Order ID
[154] => PowerUp Pro Dumbbell Order ID
[155] => PowerFlow Pro Order ID
[156] => Relaxavibe Order ID
[157] => Trimlite Order ID
[158] => WaverMicro VIbration Plate Order ID
[159] => WaverEnhance Vibration Plate Order ID
[160] => Vivid Pro Vibraiton Plate Order ID
[161] => Rumblex Max Order ID
[162] => Rove Elliptical Machine Order ID
[163] => VeloCycle Bike Order ID
[164] => Swirl Yoga Wheels Order ID
[165] => FlexCycle Plus Order ID
[166] => Relaxicare Foot Massager Order ID
[167] => Sonic Mini Order ID
[168] => Surger Plus Vibrating Roller Order ID
[169] => Surger Vibrating Foam Roller Order ID
[170] => Vitalize Plus Leg Massager Order ID
[171] => Aeroflex 4 in 1 Aerobic Step Platform Order ID
[172] => PowerFlow Stand Order ID
[173] => PowerFlow X Order ID
[174] => Sonic S1 Order ID
[175] => SonicFX Order ID
[176] => Radiate Pro Order ID
[177] => Vizacure Plus Order ID
[178] => Flexstride Plus Order ID
[179] => RejuvaCure Order ID
[182] => PowerFlow Pro Stand Order ID
[184] => SculptTrainer Order ID
[186] => GlideMaster Order ID
[188] => SquatPro Order ID
[190] => InclineX Slant Board Order ID
[192] => GluteBlast Order ID
[195] => ShinBlitz Order ID
[197] => BioRemedyColor
[199] => AllevaWrap Order ID
[200] => BioRecover Order ID
[202] => Rejuvawrap X Order ID
[204] => AllevaSole Order ID
[205] => AxisPro Order ID
[206] => InfraZen Order ID
[207] => PowerBank Order ID
[208] => Pacer Mini Color
[209] => Pacer Mini Pro Color
[210] => IntensiFlex Order ID
[211] => IntensiFlex Max Order ID
[212] => PacerMini Order Number
[213] => PacerMini Pro Order Number
[218] => Store
[220] => Other Stores
[221] => InfraZen Mini Order Number
[222] => TriForm System Order Number
[223] => Allevachill Order Number
[224] => Allevachill Color
[226] => RevitaGlow Order Number
[227] => RevitaGlow Pro Order Number
[228] => Sonic M1 Color
[229] => Sonic Gun Color
[230] => AeroFlex Color
[231] => BioRemedy Sizes
[232] => Flexcycle color
[233] => InfraGlow Color
[234] => Custom Field
[235] => Rumblex Color
[236] => SonicPro Color
[237] => TrimLite Color
[238] => Vibracare color
[239] => SquatPro Size
[240] => waver mini color
[241] => AllevaWrap Pro Order Number
[242] => Agility Mini Order Number
[243] => RejuvaGrow Order Number
[244] => MicroRemedy Order Number
[245] => BioHeal Plus Order Number
[246] => HexaPlate Order Number
[247] => RelievaCup Pro Order Number
[248] => RelievaCup Order Number
[249] => ShredForce Order Number
[250] => NordicFlex Order Number
[251] => Lumicure Mini S1 Order Number
[252] => Lumicure Mini R1 Order Number
[254] => HexaPlate color
[257] => HexaPlate Lite color
[258] => AllevaChill Pro Regular color
[261] => AllevaChill Pro Large color
[262] => HexaPlate Lite Order Number
[263] => AllevaChill Pro Regular Order Number
[264] => AllevaChill Pro Large Order Number
[265] => AllevaBody Order Number
[266] => AllevaSole Pro Order Number
[268] => Triform Max Order Number
[270] => TimberTrek Order Number
[278] => SculptTrainer Lite Order Number
[282] => FlexiFit Order Number
[284] => FlexiFit + Order Number
[285] => AllevaGlove Pro Order Number
[286] => GluteBlast Lite Order Number
[287] => TranquilaPure Order Number
[289] => EcoStride Order Number
[290] => OmniFit Order Number
[291] => Luminova Order Number
[292] => Luminova Pro Order Number
[294] => Biorejuvenate Order Number
[296] => CozyWrap Order Number
[298] => Allevared Pro Micro Order Number
[299] => Allevared Pro Elite Order Number
[300] => Allevared Pro Mini Order Number
[303] => ZenZone Order Number
)
// function product_name($id){
// $meta_key = '_accessally_user_contact_id_local';
// global $wpdb;
// $c_id = $wpdb->get_results("SELECT meta_value FROM `wp_usermeta` WHERE `user_id` = '$id' AND `meta_key` = '$meta_key'");
// $contact_id = $c_id[0]->meta_value;
// if (!empty($contact_id)) {
// $tag_ids = $wpdb->get_results("SELECT tag_id FROM `wp_aal_user_tags` WHERE `contact_id` = '$contact_id'");
// $tag = array();
// foreach ($tag_ids as $tag_id) {
// $option_name = '_accessally_tagging_ind_tag_' . $tag_id->tag_id;
// $option_value = get_option($option_name);
// // Check if 'Bioremedy' key exists in the option value, but consider additional words
// // if (!empty($option_value['name']) && stripos($option_value['name'], 'Waver Has Access') !== false) {
// $tag[] = $option_value['name'];
// // }
// }
// if (empty($tag)) {
// $option_value = 'not found';
// } else {
// // If there are multiple product names, concatenate them into a comma-separated string
// $option_value = implode(",", $tag);
// }
// } else {
// $option_value = 'not found';
// }
// return $option_value;
// }
// if (is_user_logged_in()) {
// // Check if the user has the 'manage_options' capability
// if (current_user_can('manage_options')) {
// $data = array(
// array('','Registration Report',''),
// array('User ID', 'Order ID', 'Name', 'Email', 'Phone', 'Registration Date', 'Product Name' ,'Address'),
// );
// $start_date = '2023-12-01 00:00:00'; // Replace with your desired start date
// $end_date = '2023-12-31 23:59:00'; // Current date and time
// // Create a new user query
// $args = array(
// 'role' => 'subscriber', // Set the user role you are interested in
// 'date_query' => array(
// /* array(
// 'after' => '1 months ago', // Set the date range
// 'inclusive' => true,
// ),*/
// array(
// 'column' => 'user_registered',
// 'after' => $start_date,
// 'before' => $end_date,
// 'inclusive' => true,
// ),
// ),
// );
// $user_query = new WP_User_Query($args);
// // Get the results
// $users = $user_query->get_results();
// // Loop through the users and add data to the array
// $counter = 0;
// foreach ($users as $user) {
// $product_name = product_name($user->id);
// // Check if the product name contains "Bioremedy"
// // if (stripos($product_name, 'Waver Has Access') !== false) {
// $udata = get_userdata($user->id);
// //$meta_key = '_accessally_user_contact_id_local';
// $con_id = $wpdb->get_results("SELECT meta_value FROM `wp_usermeta` WHERE `user_id` = '$user->id' AND `meta_key` = '_accessally_user_contact_id_local'");
// $contact_id = $con_id[0]->meta_value;
// //echo "SELECT meta_value FROM `wp_usermeta` WHERE `user_id` = '$user->id' AND `meta_key` = '_accessally_user_contact_id_local'";
// $order_id = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id';");
// $first_name = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'first_name';");
// $last_name = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'last_name';");
// // $email = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'email';");
// $phone = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'phone';");
// $address1 = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'address1';");
// $address2 = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'address2';");
// $city = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'city';");
// $state = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'state';");
// $country = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'country';");
// $zip = $wpdb->get_results("SELECT * FROM `wp_aal_crm_field` WHERE `contact_id` = '$contact_id' AND `field_id` = 'zip';");
// $full_address = $address1[0]->field_value.', '.$address2[0]->field_value.', '.$city[0]->field_value.', '.$state[0]->field_value.', '.$country[0]->field_value.', '.$zip[0]->field_value;
// $name= $first_name[0]->field_value.' '.$last_name[0]->field_value;
// $phone =$phone[0]->field_value;
// $registered = $udata->user_registered;
// $registered_date = date("Y-m-d", strtotime($registered));
// $user_data = array(
// $user->id,
// $order_id[0]->field_value,
// $name,
// $user->user_email,
// $phone,
// $registered_date,
// $product_name,
// $full_address,
// );
// $data[] = $user_data;
// //$kk= count($data1);
// // }
// }
// //$data[] =$data1;
// // Sort the data by registration date
// usort($data, function ($a, $b) {
// return strtotime($a[2]) - strtotime($b[2]);
// });
// // Set the CSV filename
// $csvFileName = 'report.csv';
// // Set headers to prompt a download
// header('Content-Type: text/csv');
// header('Content-Disposition: attachment; filename="' . $csvFileName . '"');
// // Open a temporary file pointer
// $tempFile = fopen('php://temp', 'w');
// // Write data to the temporary file
// foreach ($data as $row) {
// fputcsv($tempFile, $row);
// }
// // Rewind the temporary file pointer
// rewind($tempFile);
// // Output the contents of the temporary file to the browser
// fpassthru($tempFile);
// // Close the temporary file
// fclose($tempFile);
// // Exit to prevent additional output
// //echo 'CSV file created successfully at: ' . $csvFilePath;
// exit();
// } else {
// // User is not an administrator
// echo "You have not permission to download report. Plaese Login as a admin!
";
// }
// } else {
// echo "You are not logedin. Please login first for download report!
";
// }