'Message',
'First_Name' => 'First Name',
'Last_Name' => 'Last Name',
'Full_Name' => 'Full Name',
'IP_Address' => 'IP address',
'Company_Name' => 'Company Name',
'Seconday_Phone' => 'Secondary Phone',
'Address' => 'Address',
'Address2' => 'Address 2',
'City' => 'City',
'State' => 'State',
'Zip' => 'Zip',
'Country' => 'Country',
'Best_Time_To_Contact' => 'Best time to contact',
'Relationship' => 'Relationship',
'Landing_Page' => 'Landing Page',
'HTTP_Referer' => 'HTTP Referer',
'HTTP_User_Agent' => 'HTTP User Agent',
'UTM_Content' => 'UTM Content',
'UTM_Source' => 'UTM Source',
'UTM_Medium' => 'UTM Medium',
'UTM_Campaign' => 'UTM Campaign',
'UTM_Term' => 'UTM Term',
'Generic_Field_1' => 'Generic Field 1',
'Generic_Field_2' => 'Generic Field 2',
'Generic_Field_3' => 'Generic Field 3',
'Generic_Field_4' => 'Generic Field 4',
'Generic_Field_5' => 'Generic Field 5',
'Generic_Field_6' => 'Generic Field 6',
'Generic_Field_7' => 'Generic Field 7',
'Generic_Field_8' => 'Generic Field 8',
'Generic_Field_9' => 'Generic Field 9',
'Generic_Field_10' => 'Generic Field 10'
);
private $cf7class;
// just the constructor for the action settings
public function __construct(){
// initialize something here :)
add_action('admin_menu', array(&$this, 'cf7_cloud_database_menu'));
add_action('admin_print_scripts', array(&$this, 'Load_scripts'));
add_action('admin_print_scripts', array(&$this, 'Load_styles'));
// contact form 7 hooks/actions binding
add_action("wpcf7_before_send_mail", array(&$this, 'wpcf7_cloud_send_all'));
add_action( 'wpcf7_admin_after_form', array(&$this, 'show_cf7cloud_metabox') );
$cf7_cloud_activated = get_option('cf7_cloud_database_active');
add_action( 'wpcf7_after_save', array(&$this, 'cf7cloud_save_form' ));
// if user already signed/logged to ContactUs then show CF7 extension.
if( $cf7_cloud_activated == 1){
add_action( 'wpcf7_admin_before_subsubsub', array(&$this, 'add_cf7cloud_meta') );
}
add_filter( "plugin_action_links", array($this, 'cf7cloud_plugin_action_links'), 10, 4 );
}
/**
* This should create the setting button in plugin CF7 cloud database
**/
function cf7cloud_plugin_action_links( $links, $file ) {
$plugin_file = 'contact-form-7-cloud-database/cf7-cloud-database.php';
//make sure it is our plugin we are modifying
if ( $file == $plugin_file ) {
$settings_link = '' .
__( 'Settings', 'contact-form-7-cloud-database' ) . '';
array_unshift( $links, $settings_link );
}
return $links;
}
/**
* Private method to create the required options in database
* @params none
* @return none
* @since 0.1
**/
private function create_cf7_cloud_options(){
// set options to be used along the system
update_option('cf7_cloud_db_version', $this->cf7_cloud_db_version);
update_option('cf7_cloud_version', $this->cf7_cloud_version);
update_option('cf7_cloud_database_active', 0); // this is to know if user has signup/login to CU API system
}
/**
* Method en charge to create DB tables and version control options
* @params none
* @return none
* @since 0.1
**/
public function activate()
{
// Perform any databases modifications related to plugin activation here, if necessary
require_once (ABSPATH.'wp-admin/includes/upgrade.php');
global $wpdb;
/******************************** START PLUGIN SQL *************************************/
/*$sql= "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix."cf7_cloud_database` (
`field_id` bigint(22) unsigned NOT NULL AUTO_INCREMENT,
`field_name` varchar(100) NOT NULL,
PRIMARY KEY (`id_field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
dbDelta($sql);
$sql = "INSERT INTO `".$wpdb->prefix."cf7_cloud_database` (`field_id`, `field_name`) VALUES
(1, 'Message'),
(1, 'First'),
";
dbDelta($sql);*/
/******************************** END PLUGIN SQL *************************************/
// create plugin in options table.
$this->create_cf7_cloud_options();
}
/**
* Method to deactive the plugin, we will not delete DB tables nor reset options.
* @params none;
* @return none;
* @since 0.1
*/
public function deactivate() {
//$the_data = get_option('CU_cf7cloud_database_data_'.$_GET['post']);
delete_option('cUsCloud_settings_userCredentials');
delete_option('cUsCloud_settings_form_key');
delete_option('cf7_cloud_database_active');
delete_option('cUsCloud_settings_userData');
//delete_option('cUsCloud_FORM_settings');
delete_option('cUsCloud_settings_form_keys');
delete_option('cf7_cloud_db_version');
delete_option('cf7_cloud_version');
delete_option('cf7_cloud_db_version');
delete_option('cf7_cloud_version');
delete_option('cf7_cloud_database_active'); // this is to know if user has signup/login to the system
}
/*
* create main menu and its options for CF7 Extension
* @params none
* @since 0.1
* @return html that conforms the menus for the sidebar
*/
public function cf7_cloud_database_menu() {
add_menu_page('CF7 Cloud DB', 'CF7 Cloud DB', 0, 'cf7-cloud-database', array($this, 'cf7_cloud_settings'), WP_PLUGIN_URL.'/contact-form-7-cloud-database/assets/images/logo-cu.png', 3 );
//add_submenu_page('menusuperior', __('Settings'), __('Settings'), 'edit_themes', 'settings', array($this, 'cf7_cloud_settings'));
}
/***************************************/
/* THE REST OF PLUGIN RELATED METHODS */
public function Load_scripts(){
wp_register_script('my-scripts', WP_PLUGIN_URL.'/contact-form-7-cloud-database/assets/js/scripts.js');
// now registered , enqueue.
wp_enqueue_script('my-scripts');
}
public function Load_styles(){
wp_enqueue_style('cf7_cloud-styles', WP_PLUGIN_URL.'/contact-form-7-cloud-database/assets/css/styles.css' );
//wp_enqueue_style('thickbox');
}
/*
* display admin page to manage requisitions
* @params none
* @since 0.1
*/
public function cf7_cloud_settings(){
require_once('controllers/settings.php');
}
/**
* This is the method in charge to create the metabox for integration with Contact Form 7
* @params none
* @since 0.1
* return null
**/
function add_cf7cloud_meta (){
if ( wpcf7_admin_has_edit_cap() ) {
add_meta_box( 'cf7cf7clouddiv', __( 'ContactUs.com Analytics', 'wpcf7' ),
array($this, 'wpcf7_cf7cloud_add_contactus_analytics'), 'cf7clouddatabase', 'cf7_cf7cloud', 'core',
array(
'id' => 'wpcf7-cf7-cloud-database',
'name' => 'cf7_cf7cloud',
'use' => __( 'Use ContactUs.com Analytics', 'wpcf7' ) ) );
}
}
function show_cf7cloud_metabox($cf){
do_meta_boxes( 'cf7clouddatabase', 'cf7_cf7cloud', $cf );
}
function wpcf7_cf7cloud_add_contactus_analytics($args)
{
//print_r($args); exit;
?>
/>
'.$_GET['cf7cloud_errors'].'
');
}
?>
>
To integrate analytics with your ContactUs.com account you must provide the Contact Form 7 field names to the following inputs:
Input name for EMAIL field:
Select input name for NAME field:
$value ){
//echo $key;
?>
Select Contact Form 7 field:
Select ContactUs.com field to associate:
CU_API_fields); exit;
?>
$value ){
$the_values[] = explode(" ", $value);
$the_names[$key] = str_replace(']', '', $the_values[$key][1]);
}
array_pop( $the_names );
return $the_names;
}
/*
* Method in charge to save the relationships between contact form 7 and CU cloud Database
* @params Array all the actual editing form data being submitted
* @since 0.1
* @returns Null
*/
function cf7cloud_save_form($args)
{
// create an option for the custom_cf7_fields that come
$cf7_customs = $this->_get_cf7_inputs($args->form);
//print_r( $cf7_customs ); exit;
$prev_url = $_SERVER["HTTP_REFERER"];
$error_customs = 'The following CF7 fields were detected duplicates in your selects: ';
$error_CUapi = 'The following ContactUs.com fields were detected duplicate in your selects: ';
$string_error = '';
//print_r( $cf7_customs ); exit;
//print_r( $_POST['cf7cloud_custom_field_name'] ); exit;
if( (int)$_POST['wpcf7-cf7cloud-active'] == 1 ){
// **************************
// THIS IS TO AVOID DUPLICATES IN CF7 FIELDS.
//$counts = array_count_values( $_POST['cf7cloud_custom_field_name'] );
$cf7_customs_duplicate = array_flip(array_filter( array_count_values($_POST['cf7cloud_custom_field_name']), create_function('$x', 'return $x > 1;')));
// check if duplicates for cf7 customs
if( count($cf7_customs_duplicate) > 0 ){
foreach($cf7_customs_duplicate as $key => $value)
$string_error .= urlencode($value.', ');
header('Location:'.$prev_url.'&cf7cloud_errors='.$error_customs.$string_error.urlencode(' only one field for relationship allowed')."#cf7cloud_errors");
exit;
}
// **************************
// THIS IS TO AVOID DUPLICATES IN CUAPI FIELDS.
//$counts = array_count_values( $_POST['cf7cloud_custom_field_name'] );
$cf7_CUapi_duplicate = array_flip(array_filter( array_count_values($_POST['cf7cloud_custom_field_select']), create_function('$x', 'return $x > 1;')));
// check if duplicates for cf7 customs
if( count($cf7_CUapi_duplicate) > 0 ){
foreach($cf7_CUapi_duplicate as $key => $value)
$string_error .= urlencode($value.', ');
header('Location:'.$prev_url.'&cf7cloud_errors='.$error_CUapi.$string_error.urlencode(' only one field for relationship allowed')."#cf7cloud_errors");
exit;
}
$the_data = array(); // array to store data as option for each form.
$the_data['Full_Name'] = esc_sql($_POST['cf7cloud_name']);
$the_data['Email'] = esc_sql($_POST['cf7cloud_email']);
//$the_data['Primary_Phone'] = esc_sql($_POST['cf7cloud_phone']);
// echo( $cf7_fields_quantity ); exit;
// echo $cf7_customs[2]; exit;
// $field_count = 0;
//echo count($cf7_customs); exit;
// ********************************
// check first if custom fields have been created
if( isset($_POST['cf7cloud_custom_field_name']) && isset($_POST['cf7cloud_custom_field_select']) ){
//print_r( get_option('CU_cf7_cloud_mapped_fields_'.$_POST['post_ID'] ) ); exit;
foreach( $_POST['cf7cloud_custom_field_name'] as $xkey => $xvalue ){
//if( $xvalue != 'your-name' && $xvalue != 'your-email' ){
$the_data['customs'][$xvalue] = (isset($_POST['cf7cloud_custom_field_select'][$xkey])?esc_sql($_POST['cf7cloud_custom_field_select'][$xkey]):'' );
//$field_count++;
//}
}
// $xx = get_option('CU_cf7cloud_database_data_'.$_POST['post_ID']);
// print_r( $cf7_customs );
// print_r( $xx );
// exit;
// print_r( get_option('CU_cf7cloud_database_data_'.$_POST['post_ID']) );
// print_r( get_option('CU_cf7_cloud_mapped_fields_'.$_POST['post_ID']) );
// exit;
// check to see if no other fields have been added to CF7 textarea
$actual_amount = get_option( 'CU_cf7cloud_database_data_'.$_POST['post_ID'].'_amount' );
// get the number of fields in CF7 textarea
$cf7_fields_quantity = count( $cf7_customs );
if( $cf7_fields_quantity > $actual_amount ){
// check what is the new field.
/*foreach(){
}*/
}
}else{ // ***** this else will create the customs fields for the first time ********
foreach( $cf7_customs as $xkey => $xvalue ){
if( $xvalue != 'your-name' && $xvalue != 'your-email' ){
$the_data['customs'][$xvalue] = $xvalue;
//$field_count++;
}
}
}
//print_r($the_data); exit;
update_option( 'CU_cf7cloud_database_data_'.$_POST['post_ID'], $the_data );
update_option('CU_cf7_cloud_mapped_fields_'.$_POST['post_ID'], $cf7_customs );
update_option( 'CU_cf7cloud_database_data_'.$_POST['post_ID'].'_amount', count($cf7_customs) ); // the number of actual stored custom fields.
// print_r( get_option('CU_cf7_cloud_mapped_fields_'.$_POST['post_ID']) ); exit;
}
}
/*
* This is the method in charge to pre-process CF7 submitted data
* @params none
* @since 0.1
* @returns void
*/
public function wpcf7_cloud_send_all(&$wpcf7) {
$data = '';
//print_r($wpcf7->posted_data); exit;
// get the option for this specific form and see which fields to send to CU API
$cf7cloud_data = get_option('CU_cf7cloud_database_data_'.$wpcf7->posted_data['_wpcf7']);
// first check if this form has any Analytics associated
if( $cf7cloud_data && is_array($cf7cloud_data) ){
// print_r( $cf7cloud_data); exit;
$CU_string = '';
// check if this form has any CF7 Cloud database analytics associated to it
foreach( $cf7cloud_data as $key => $value ){
if( !is_array($value) ) // avoid using arrays customs
if( array_key_exists($value, $wpcf7->posted_data) ){
$CU_string .= $key."=".urlencode($wpcf7->posted_data[$value]).'&';
}
}
// now check for custom fields.
foreach( $cf7cloud_data['customs'] as $key => $value ){
if( array_key_exists($value, $wpcf7->posted_data) ){
$CU_string .= $key."=".urlencode($wpcf7->posted_data[$value]).'&';
}
}
// remove last character
$CU_string = substr_replace($CU_string ,"",-1);
//$CU_string = urlencode($CU_string);
$ch = curl_init();
$strCURLOPT = 'http://test.contactus.com/api2.php?';
// $strCURLOPT = 'http://admin.contactus.com/api2.php?';
$thekey = get_option('cUsCloud_settings_form_key');
$credentials = get_option('cUsCloud_settings_userCredentials');
$strCURLOPT .= 'API_Account='.$credentials['API_Account']; // constants defined in config.php
$strCURLOPT .= '&API_Key='.$credentials['API_Key']; // constants defined in config.php
$strCURLOPT .= '&API_Action=postSubmitLead';
$strCURLOPT .= '&Form_Key='.$thekey.'&'; // constants defined in config.php
$strCURLOPT = trim($strCURLOPT.$CU_string);
//echo $strCURLOPT; exit;
//curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
curl_setopt($ch, CURLOPT_URL, $strCURLOPT );
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$content = curl_exec($ch);
curl_close($ch);
}
// return $content;
// echo $content;
// exit;
}
} // end class definition
/* CF7 Cloud Database loader */
$CF7_cloud_loader = new CF7_cloud_loader();