*/
class Advanced_Cf7_Db_Admin {
/**
* The ID of this plugin.
*
* @since 1.0.0
* @access private
* @var string $plugin_name The ID of this plugin.
*/
private $plugin_name;
/**
* The version of this plugin.
*
* @since 1.0.0
* @access private
* @var string $version The current version of this plugin.
*/
private $version;
/**
* Initialize the class and set its properties.
*
* @since 1.0.0
* @param string $plugin_name The name of this plugin.
* @param string $version The version of this plugin.
*/
public function __construct( $plugin_name, $version ) {
$this->plugin_name = $plugin_name;
$this->version = $version;
}
/**
* Register the stylesheets for the admin area.
*
* @since 1.0.0
*/
public function enqueue_styles() {
/**
* This function is provided for demonstration purposes only.
*
* An instance of this class should be passed to the run() function
* defined in Advanced_Cf7_Db_Loader as all of the hooks are defined
* in that particular class.
*
* The Advanced_Cf7_Db_Loader will then create the relationship
* between the defined hooks and the functions defined in this
* class.
*/
wp_register_style( 'vsz-cf7-db-admin-css', plugin_dir_url( __FILE__ ) . 'css/advanced-cf7-db-admin.css', array(), $this->version, 'all' );
wp_enqueue_style( 'font_awesome_css', plugin_dir_url( __FILE__ ) . 'css/font-awesome.css', array(), $this->version, 'all' );
wp_register_style( 'jquery-datetimepicker-css', plugin_dir_url( __FILE__ ) . 'css/jquery.datetimepicker.css', array(), $this->version, 'all');
}
/**
* Register the JavaScript for the admin area.
*
* @since 1.0.0
*/
public function enqueue_scripts() {
/**
* This function is provided for demonstration purposes only.
*
* An instance of this class should be passed to the run() function
* defined in Advanced_Cf7_Db_Loader as all of the hooks are defined
* in that particular class.
*
* The Advanced_Cf7_Db_Loader will then create the relationship
* between the defined hooks and the functions defined in this
* class.
*/
wp_enqueue_script( $this->plugin_name, plugin_dir_url( __FILE__ ) . 'js/advanced-cf7-db-admin.js', array( 'jquery' ), $this->version, false );
wp_enqueue_script( 'datepicker-min-js', plugin_dir_url( __FILE__ ) . 'js/jquery.datetimepicker.js', array( 'jquery' ), $this->version, false );
}
////////////// to add admin screens for Contact form Db and Import CSV
function vsz_cf7_plugin_menu(){
///// Menu pages for contact form DB
add_menu_page( "Advanced CF7 DB", "Advanced CF7 DB", "edit_others_pages", "contact-form-listing", array($this,"vsz_contact_form_callback"), 'dashicons-visibility' , 45);
///// Menu pages for Import CSV
add_submenu_page( 'contact-form-listing', __('Import CSV', 'advanced-cf7-db'), __('Import CSV', ' advanced-cf7-db'), 'manage_options', 'import_cf7_csv',array($this,'vsz_import_cf7_csv') );
}
// Callback function for listing screen
function vsz_contact_form_callback(){
//Check current user permission
if (!current_user_can('manage_options')) {
wp_die( __('You do not have sufficient permissions to access this page.') );
}
wp_enqueue_style('vsz-cf7-db-admin-css');
//Define all entry related design in this file
require_once plugin_dir_path( __FILE__ ) . 'partials/contact_form_listing.php';
}
// Callback function for Import CSV screen
function vsz_import_cf7_csv(){
//Check current user permission
if (!current_user_can('manage_options')) {
wp_die( __('You do not have sufficient permissions to access this page.') );
}
//Define import CSV screen design in this file
require_once plugin_dir_path( __FILE__ ) . 'partials/import_cf7_csv.php';
}
//Get form related all fields information here
function vsz_cf7_admin_fields_callback($fields, $fid){
$return = array();
$fid = (int)$fid;
//Get current form related field setting value from option table
$field_settings = get_option('vsz_cf7_settings_field_' . $fid, array());
//Check field settings value empty or not
if ($field_settings == "") {
$field_settings = array();
}
//Check if field setting found then any field entry exist or not
if(count($field_settings) == 0){ //no settings found
//Get form id related contact form object
$obj_form = vsz_cf7_get_the_form_list($fid);
//get pre define form fields information
$arr_form_tag = $obj_form[0]->scan_form_tags();
/**** This functionality Added because when field settings not define then
Fields display as per form design format*/
//Check field exist with form or not
if(!empty($arr_form_tag)){
//Get all fields related information
foreach($arr_form_tag as $key => $arr_type){
//Check if tag type is submit then ignore tag info
if($arr_type['basetype'] == 'submit') continue;
//Check if field name match with form field name or not
if(isset($arr_type['name']) && array_key_exists($arr_type['name'],$fields)){
//If field type match with form field name then set field name in array
$return[$arr_type['name']] = $fields[$arr_type['name']];
//Remove current keys from field array
unset($fields[$arr_type['name']]);
}
}//Close for for each
}//Close if for field check
//Check any fields remaining in field array or not which is not define in Current Form
if(count($fields) > 0){
//Remaining fields add in array
$return = array_merge($return,$fields);
}
}//Close field setting IF
//If fields setting found in option table
else{
//Fetch fields information from array
foreach ($field_settings as $k => $v) {
//Check Current DB fields with setting field name exist or not
if(isset($fields[$k])){
//If field exist with field array then get current field display information
$show = (int)$field_settings[$k]['show'];
//If condition is true then field display on Listing screen and export Sheet.
if ($show == 1){
//Get field label name and set in array
$label = $field_settings[$k]['label'];
$return[$k] = esc_html($label);
}
//Unset current field from fields array
unset($fields[$k]);
}//Close if
}//Close foreach
//Check any field is remaining in array or not
if (count($fields) > 0) {
//Set all remaining fields name in array
foreach ($fields as $k => $v) {
$return[$k] = esc_html($v);
}
}
}//Close else
//return all existing fields information in array format here
return $return;
}//Close function for fields related information
//Define Export option box on form listing screen
function vsz_cf7_after_bulkaction_btn_callback($fid){
$fid = (int)$fid;
?>
To change the Field title, Hide field and change the position of fields using Drag and Drop from here.
scan_form_tags();
//Create nonce values which is validate on SAVE time
$nonce = wp_create_nonce( 'vsz-cf7-setting-nonce-'.$fid );
//Define Design related structure here
?>
scan_form_tags();
$arr_field_type = array();
//Define option field type array
$arr_option_type = array('checkbox','radio','select');
//Check field exist with form or not
if(!empty($arr_form_tag)){
//Get all fields related information
foreach($arr_form_tag as $key => $arr_type){
//Check if tag type is submit then ignore tag info
if($arr_type['basetype'] == 'submit') continue;
//Check if field type match with option values or not
if(isset($arr_type['basetype']) && in_array($arr_type['basetype'],$arr_option_type)){
//If field type is option then get option names and values
$arr_field_type[$arr_type['name']]['basetype'] = $arr_type['basetype'];
$arr_field_type[$arr_type['name']]['labels'] = $arr_type['labels'];
$arr_field_type[$arr_type['name']]['values'] = $arr_type['values'];
}
else{
//get field type information
$arr_field_type[$arr_type['name']]['basetype'] = $arr_type['basetype'];
}
}//Close for for each
}//Close if for field check
//Get form id related database fields information
$fields = vsz_cf7_get_db_fields($form_id);
//Define nonce value which is validate on save time
$nonce = wp_create_nonce( 'vsz-cf7-edit-nonce-'.$form_id );
//Get not editable fields list
$not_editable_field = apply_filters('vsz_cf7_not_editable_fields',array());
//Setup edit form design here
?>
$arrVal){
//sanitize new label name of field
$arr_fields[$key]['label'] = sanitize_text_field($arrVal['label']);
//Get field show or not information
$arr_fields[$key]['show'] = intval($arrVal['show']);
}
}
//Save Settings POPUP information in option table
add_option('vsz_cf7_settings_field_' . $fid, $arr_fields, '', 'no');
update_option('vsz_cf7_settings_field_' . $fid, $arr_fields);
}//close if for save setting information
//Save form information here
if(isset($_POST['vsz_cf7_save_field_value'])){
// check nonce
if(!isset($_POST['vsz_cf7_edit_nonce']) || empty($_POST['vsz_cf7_edit_nonce'])){
return;
}
//Check form id
if(!isset($_POST['fid']) || empty($_POST['fid'])){
return;
}
//Check entry id
if(!isset($_POST['rid']) || empty($_POST['rid'])){
return;
}
//Get form and entry id
$fid = intval($_POST['fid']);
$rid = intval($_POST['rid']);
//Verify nonce value
$nonce = sanitize_text_field($_POST['vsz_cf7_edit_nonce']);
if(!wp_verify_nonce( $nonce, 'vsz-cf7-edit-nonce-'.$fid)){
// This nonce is not valid.
return;
}
$arr_field_type = '';
//Get field type information here
if(isset($_POST['arr_field_type']) && !empty($_POST['arr_field_type'])){
//Decode Json format string here
$arr_field_type = json_decode(wp_unslash($_POST['arr_field_type']),true);
}
//Define option field type array
$arr_option_type = array('checkbox','radio','select');
//Get non editable fields information
$not_editable_field = apply_filters('vsz_cf7_not_editable_fields');
//Get entry related fields information
$arr_exist_keys = get_entry_related_fields_info($fid,$rid);
if(isset($_POST['field']) && !empty($_POST['field'])){
//Fetch all fields information here
foreach ($_POST['field'] as $key => $value){
$key = sanitize_text_field($key);
//Escape loop if key have not editable field
if(!empty($not_editable_field) && in_array($key,$not_editable_field)) continue;
//Escape loop if key have file type value
if(!empty($arr_field_type) && is_array($arr_field_type) && array_key_exists($key,$arr_field_type) && $arr_field_type[$key]['basetype'] == 'file') continue ;
//Check key field have checkbox type or not
if(!empty($arr_field_type) && is_array($arr_field_type) && array_key_exists($key,$arr_field_type) && in_array($arr_field_type[$key]['basetype'],$arr_option_type)){
//Check if field name already exist with entry or not
if(!empty($arr_exist_keys) && in_array($key,$arr_exist_keys)){
//If field name match with current entry then field information update
$wpdb->query($wpdb->prepare("UPDATE ".VSZ_CF7_DATA_ENTRY_TABLE_NAME." SET `value` = %s WHERE `name` = %s AND `data_id` = %d", sanitize_textarea_field($value), $key, $rid));
}
else{
//If field name not match with current entry then new entry insert in DB
$wpdb->query($wpdb->prepare('INSERT INTO '.VSZ_CF7_DATA_ENTRY_TABLE_NAME.'(`cf7_id`, `data_id`, `name`, `value`) VALUES (%d,%d,%s,%s)', $fid, $rid, sanitize_text_field($key), sanitize_textarea_field($value)));
}
}
//Check if field type is text area
else if(!empty($arr_field_type) && is_array($arr_field_type) && array_key_exists($key,$arr_field_type) && $arr_field_type[$key]['basetype'] == 'textarea'){
//Check if field name already exist with entry or not
if(!empty($arr_exist_keys) && in_array($key,$arr_exist_keys)){
//If field name match with current entry then field information update
$wpdb->query($wpdb->prepare("UPDATE ".VSZ_CF7_DATA_ENTRY_TABLE_NAME." SET `value` = %s WHERE `name` = %s AND `data_id` = %d", sanitize_textarea_field($value), $key, $rid));
}
else{
//If field name not match with current entry then new entry insert in DB
$wpdb->query($wpdb->prepare('INSERT INTO '.VSZ_CF7_DATA_ENTRY_TABLE_NAME.'(`cf7_id`, `data_id`, `name`, `value`) VALUES (%d,%d,%s,%s)', $fid, $rid, sanitize_text_field($key), sanitize_textarea_field($value)));
}
}//Close text area else if
else{
//Check if field name already exist with entry or not
if(!empty($arr_exist_keys) && in_array($key,$arr_exist_keys)){
//If field name match with current entry then field information update
$wpdb->query($wpdb->prepare("UPDATE ".VSZ_CF7_DATA_ENTRY_TABLE_NAME." SET `value` = %s WHERE `name` = %s AND `data_id` = %d", sanitize_text_field($value), $key, $rid));
}
else{
//If field name not match with current entry then new entry insert in DB
$wpdb->query($wpdb->prepare('INSERT INTO '.VSZ_CF7_DATA_ENTRY_TABLE_NAME.'(`cf7_id`, `data_id`, `name`, `value`) VALUES (%d,%d,%s,%s)', $fid, $rid, sanitize_text_field($key), sanitize_text_field($value)));
}
}//Close else
}//Close foreach
}//Close if for check field arrray is set or not
}//Close if for save information
//Delete form entry here
if ($current_action = vsz_cf7_current_action()) {
$current_action = sanitize_text_field($current_action);
//Check current action is delete then execute this functionality
if($current_action == 'delete'){
if(isset($_POST['del_id'])){
//Get nonce value
$nonce = sanitize_text_field($_POST['_wpnonce']);
//Verify nonce value
if(!wp_verify_nonce($nonce, 'vsz-cf7-action-nonce')) {
die('Security check');
}
//Get Delete row ID information
$del_id = implode(',', array_map('intval',$_POST['del_id']));
//Get Form ID
$fid = intval($_POST['fid']);
//Delete form ID related row entries from DB
$wpdb->query("DELETE FROM ".VSZ_CF7_DATA_ENTRY_TABLE_NAME." WHERE data_id IN($del_id)");
$wpdb->query("DELETE FROM ".VSZ_CF7_DATA_TABLE_NAME." WHERE id IN($del_id)");
}
}
}//Close if for delete action
//Setup export functionality here
if(isset($_POST['btn_export'])){
//Get form ID
$fid = (int)$_POST['fid'];
//Get export id related information
$ids_export = ((isset($_POST['del_id']) && !empty($_POST['del_id'])) ? implode(',', array_map('intval',$_POST['del_id'])) : '');
///Get export type related information
$type = sanitize_text_field($_POST['vsz-cf7-export']);
//Check type name and execute type related CASE
switch ($type) {
case 'csv':
vsz_cf7_export_to_csv($fid, $ids_export);
break;
case '-1':
return;
break;
default:
return;
break;
}//Close switch
}//Close if for export
}//Close admin_init hook function
//Edit form AJAX call hadle By this function
public function vsz_cf7_edit_form_ajax(){
if(!current_user_can( 'manage_options' )) return;
global $wpdb;
//Check entry id set or not in current request
$rid = ((isset($_POST['rid']) && !empty($_POST['rid'])) ? intval($_POST['rid']) : '');
//If entry not empty
if(!empty($rid)){
//Get entry related all fields information
$sql = $wpdb->prepare("SELECT * FROM ".VSZ_CF7_DATA_ENTRY_TABLE_NAME." WHERE `data_id` = %d", $rid);
$rows = $wpdb->get_results($sql);
$return = array();
//Set all fields name in array
foreach ($rows as $k => $v) {
$return[$v->name] = html_entity_decode(stripslashes($v->value));
}
//All fields encode in JSON format and return in AJAX request
exit(json_encode($return));
}
}//Close Edit Ajax request function
////Define not editable fields name here
public function vsz_cf7_not_editable_fields_callback(){
$cf7_not_editable_fields = array('submit_time','submit_ip','submit_user_id');
return $cf7_not_editable_fields;
}
}//close class
//Generate CSV file here
function vsz_cf7_export_to_csv($fid, $ids_export = ''){
global $wpdb;
$fid = intval($fid);
$fields = vsz_cf7_get_db_fields($fid);
//Get form id related contact form object
$obj_form = vsz_cf7_get_the_form_list($fid);
//get current form title
$form_title = esc_html($obj_form[0]->title());
//Get export data
$data = create_export_query($fid, $ids_export, 'data_id desc');
//Setup export data
$data_sorted = wp_unslash(vsz_cf7_sortdata($data));
//Generate CSV file
header('Content-Type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment;filename="'.$form_title.'.csv";');
$fp = fopen('php://output', 'w');
fputs($fp, "\xEF\xBB\xBF");
fputcsv($fp, array_values(array_map('sanitize_text_field',$fields)));
foreach ($data_sorted as $k => $v){
$temp_value = array();
foreach ($fields as $k2 => $v2){
$temp_value[] = ((isset($v[$k2])) ? htmlspecialchars_decode($v[$k2]) : '');
}
fputcsv($fp, $temp_value);
}
fclose($fp);
exit();
}
//Setup export related query here
function create_export_query($fid,$ids_export,$cf7d_entry_order_by){
global $wpdb;
$fid = intval($fid);
if(isset($_POST['start_date']) && isset($_POST['end_date']) && !empty($_POST['start_date']) && !empty($_POST['end_date'])){
$s_date = date_create_from_format("d/m/Y",sanitize_text_field($_POST['start_date']));
$e_date = date_create_from_format("d/m/Y",sanitize_text_field($_POST['end_date']));
}
else{
$s_date = false;
$e_date = false;
}
//Create Export Query on the basis of Listing screen filter
//Check any search related filter active or not
if(isset($_POST['search_cf7_value']) && !empty($_POST['search_cf7_value']) && isset($_POST['start_date']) && isset($_POST['end_date']) && empty($_POST['start_date']) && empty($_POST['end_date'])){
$search = sanitize_text_field($_POST['search_cf7_value']);
$query = sprintf("SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME.
"` WHERE `cf7_id` = %d AND data_id IN(SELECT * FROM (SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."`
WHERE 1 = 1 AND `cf7_id` = ".$fid." ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : "").' '.
((!empty($ids_export)) ? " AND data_id IN(".$ids_export.")" : '').
" GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." ) temp_table) ORDER BY " . $cf7d_entry_order_by, $fid );
}
//Check date wise filter active or not
else if(isset($_POST['search_cf7_value']) && empty($_POST['search_cf7_value']) && isset($_POST['start_date']) && isset($_POST['end_date']) && !empty($_POST['start_date']) && !empty($_POST['end_date']) && $s_date !== false && $e_date !== false){
//Get start date information
$start_date = date_format($s_date,"Y-m-d");
//Get end date information
$end_date = date_format($e_date,"Y-m-d");
$search_date_query = "AND `name` = 'submit_time' AND value between '".$start_date."' and '".$end_date." 23:59:59'";
$query = sprintf("SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = %d AND data_id IN(SELECT * FROM (SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query.' '. ((!empty($ids_export)) ? " AND data_id IN(".$ids_export.")" : '')." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by.") temp_table) ORDER BY " . $cf7d_entry_order_by, $fid);
}
//Check search and date wise filter active or not
else if(isset($_POST['search_cf7_value']) && !empty($_POST['search_cf7_value']) && isset($_POST['start_date']) && isset($_POST['end_date']) && !empty($_POST['start_date']) && !empty($_POST['end_date']) && $s_date !== false && $e_date !== false){
$search = sanitize_text_field($_POST['search_cf7_value']);
//Get start date information
$start_date = date_format($s_date,"Y-m-d");
//Get end date information
$end_date = date_format($e_date,"Y-m-d").' 23:59:59';
$date_query = sprintf("SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = %d AND `name` = 'submit_time' AND value between '%s' and '%s' GROUP BY `data_id` ORDER BY `data_id` DESC",$fid, $start_date, $end_date);
//print $date_query;
$rs_date = $wpdb->get_results($date_query);
$data_ids = '';
if(!empty($rs_date)){
foreach($rs_date as $objdata_id){
if(!empty($ids_export)){
$arr_ids = array_map('intval',explode(',',$ids_export));
if(!empty($arr_ids) && in_array($objdata_id->data_id,$arr_ids)){
$data_ids .= $objdata_id->data_id .',';
}
}
else{
$data_ids .= $objdata_id->data_id .',';
}
}
$data_ids = rtrim($data_ids,',');
}
$query = sprintf("SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = %d AND data_id IN(SELECT * FROM (SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid." ".$search_date_query." ".((!empty($search)) ? "AND `value` LIKE '%%".$search."%%'" : ""). " AND data_id IN (".$data_ids.") GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." ) temp_table) ORDER BY " . $cf7d_entry_order_by, $fid);
}
//Not active any filter on listing screen
else{
$query = sprintf("SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = %d AND data_id IN(SELECT * FROM (SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid.' '. ((!empty($ids_export)) ? " AND data_id IN(".$ids_export.")" : '')." GROUP BY `data_id` ORDER BY ".$cf7d_entry_order_by." ) temp_table) ORDER BY " . $cf7d_entry_order_by, $fid);
}
//Execuste query
$data = $wpdb->get_results($query);
//Return result set
return $data;
}//Close export query function
).'images/716.gif'; ?>)