FM / admin

/home/techb158/balacoffee.com/wp-content/plugins/chaty/views/admin/

/home/techb158/balacoffee.com/wp-content/plugins/chaty/views/admin

Name	Size	Mode	Actions
admin.php	21444	0644	edit dl rm
channel.php	107759	0644	edit dl rm
channels-section.php	14977	0644	edit dl rm
chatway-notice.php	12257	0644	edit dl rm
chatway-setting.php	30983	0644	edit dl rm
chatway.php	23169	0644	edit dl rm
chaty-admin-integration.php	8084	0644	edit dl rm
chaty-deactivate-form.php	8700	0644	edit dl rm
chaty-popup.php	2611	0644	edit dl rm
chatyway-info-popup.php	21218	0644	edit dl rm
chaty_widget.php	4101	0644	edit dl rm
contact-form-feed.php	21302	0644	edit dl rm
custom-tags.php	9396	0644	edit dl rm
customize-widget-section.php	80432	0644	edit dl rm
dashboard.php	41159	0644	edit dl rm
email-signup.php	17310	0644	edit dl rm
first-popup.php	9536	0644	edit dl rm
help.php	19915	0644	edit dl rm
install-chatway.php	25865	0644	edit dl rm
popup.php	23721	0644	edit dl rm
pro_analytics.php	7286	0644	edit dl rm
recommended-plugins.php	25590	0644	edit dl rm
review-popup.php	17052	0644	edit dl rm
trigger-and-target.php	50751	0644	edit dl rm
upgrade.php	53684	0644	edit dl rm

Edit: /home/techb158/balacoffee.com/wp-content/plugins/chaty/views/admin/contact-form-feed.php (21302B)

<?php
/**
 * Contact form leads
 *
 * @author  : Premio <contact@premio.io>
 * @license : GPL2
 * */

if (defined('ABSPATH') === false) {
    exit;
}

global $wpdb;
$tableName = $wpdb->prefix.'chaty_contact_form_leads';

$paged   = filter_input(INPUT_GET, 'paged');
$current = isset($paged)&&!empty($paged)&&is_numeric($paged)&&$paged > 0 ? $paged : 1;
$current = intval($current);

$searchFor  = "all_time";
$searchList = [
    'today'        => esc_html__('Today', 'chaty'),
    'yesterday'    => esc_html__('Yesterday', 'chaty'),
    'last_7_days'  => esc_html__('Last 7 Days', 'chaty'),
    'last_30_days' => esc_html__('Last 30 Days', 'chaty'),
    'this_week'    => esc_html__('This Week', 'chaty'),
    'this_month'   => esc_html__('This Month', 'chaty'),
    'all_time'     => esc_html__('All Time', 'chaty'),
    'custom'       => esc_html__('Custom Date', 'chaty')
];

$searchFor = filter_input(INPUT_GET, 'search_for');
if (isset($searchFor) && !empty($searchFor) && isset($searchList[$searchFor])) {
    $searchFor = esc_attr($searchFor);
} else {
    $searchFor = "all_time";
}

$startDate = "";
$endDate   = "";
if ($searchFor == "today") {
    $startDate = gmdate("Y-m-d");
    $endDate   = gmdate("Y-m-d");
} else if ($searchFor == "yesterday") {
    $startDate = gmdate("Y-m-d", strtotime("-1 days"));
    $endDate   = gmdate("Y-m-d", strtotime("-1 days"));
} else if ($searchFor == "last_7_days") {
    $startDate = gmdate("Y-m-d", strtotime("-7 days"));
    $endDate   = gmdate("Y-m-d");
} else if ($searchFor == "last_30_days") {
    $startDate = gmdate("Y-m-d", strtotime("-30 days"));
    $endDate   = gmdate("Y-m-d");
} else if ($searchFor == "this_week") {
    $startDate = gmdate("Y-m-d", strtotime('monday this week'));
    $endDate   = gmdate("Y-m-d");
} else if ($searchFor == "this_month") {
    $startDate = gmdate("Y-m-01");
    $endDate   = gmdate("Y-m-d");
} else if ($searchFor == "custom") {
    $startDate = filter_input(INPUT_GET, 'start_date');
    if (!empty($startDate)) {
        $startDate = esc_attr($startDate);
    } else {
        $startDate = "";
    }

$endDate = filter_input(INPUT_GET, 'end_date');
    if (!empty($endDate)) {
        $endDate = esc_attr($endDate);
    } else {
        $endDate = "";
    }
}//end if

$hasSearch = filter_input(INPUT_GET, 'search');
$hasSearch = isset($hasSearch)&&!empty($hasSearch) ? $hasSearch : false;

$query  = "SELECT count(id) as total_records FROM ".$tableName;
$search = "";

$condition      = "";
$conditionArray = [];
if ($hasSearch !== false) {
    $search           = $hasSearch;
    $hasSearch        = '%'.esc_sql($hasSearch).'%';
    $condition       .= " (name LIKE %s OR email LIKE %s OR phone_number LIKE %s OR message LIKE %s)";
    $conditionArray[] = $hasSearch;
    $conditionArray[] = $hasSearch;
    $conditionArray[] = $hasSearch;
    $conditionArray[] = $hasSearch;
}

$startDate = esc_attr($startDate);
$endDate   = esc_attr($endDate);
if (!empty($startDate) && !empty($endDate)) {
    if (!empty($condition)) {
        $condition .= " AND ";
    }

$cStartDate       = gmdate("Y-m-d 00:00:00", strtotime($startDate));
    $cEndDate         = gmdate("Y-m-d 23:59:59", strtotime($endDate));
    $condition       .= " created_on >= %s AND created_on <= %s";
    $conditionArray[] = $cStartDate;
    $conditionArray[] = $cEndDate;
}

if (!empty($condition)) {
    $query .= " WHERE ".$condition;
}

$query .= " ORDER BY ID DESC";

if (!empty($conditionArray)) {
    $query = $wpdb->prepare($query, $conditionArray);
}

$totalRecords = $wpdb->get_var($query);
$perPage      = 15;
$totalPages   = ceil($totalRecords / $perPage);

$query = "SELECT * FROM ".$tableName;
if (!empty($condition)) {
    $query .= " WHERE ".$condition;
}

if ($current > $totalPages) {
    $current = 1;
}

$startFrom = (($current - 1) * $perPage);

$query .= " ORDER BY ID DESC";
$query .= " LIMIT $startFrom, $perPage";

if (!empty($conditionArray)) {
    $query = $wpdb->prepare($query, $conditionArray);
}
?>
<div class="wrap">
    <?php
    $result = $wpdb->get_results($query);
    ?>
    <div>
        <?php if ($result || !empty($search) || $searchFor != 'all_time') { ?>
        
        <div class="flex flex-wrap justify-between pt-5">
            <a href="<?php echo esc_url( $this->getDashboardUrl() ) ?>">
                <img class="w-32" src="<?php echo esc_url(CHT_PLUGIN_URL.'admin/assets/images/logo-color.svg'); ?>" alt="Chaty">
            </a>
            <span class="mt-3 sm:mt-0 font-primary text-3xl text-cht-gray-150"><?php esc_html_e('Contact Form Leads', 'chaty') ?></span>
        </div>

<div class="flex flex-wrap gap-3 justify-between items-center contact-form-leads-header mt-4 pb-2">
            <div>
                <?php if ($result) { ?>
                    <div>
                        <div class="alignleft actions bulkactions flex items-center">
                            <select name="action" id="bulk-action-selector-top">
                                <option value=""><?php esc_html_e('Bulk Actions', 'chaty') ?></option>
                                <option value="delete_message"><?php esc_html_e('Delete', 'chaty') ?></option>
                            </select>
                            <input type="submit" id="doaction" class="action btn cursor-pointer" value="<?php esc_html_e("Apply", "chaty") ?>" >
                        </div>
                    </div>
                <?php } ?>
            </div>

<form class="flex items-center flex-wrap gap-3" action="<?php echo esc_url(admin_url("admin.php")) ?>" method="get">
                <label class="screen-reader-text" for="post-search-input"><?php esc_html_e("Search:", "chaty") ?></label>
                <select class="search-input mr-5" name="search_for" style="" id="date-range">
                    <?php foreach ($searchList as $key => $value) { ?>
                        <option <?php selected($key, $searchFor) ?> value="<?php echo esc_attr($key) ?>"><?php echo esc_attr($value) ?></option>
                    <?php } ?>
                </select>
                <input type="search" class="search-input" name="search" value="<?php echo esc_attr($search) ?>" class="">
                <input type="submit" class="cursor-pointer btn" id="search-submit" class="button" value="<?php esc_html_e("Search", "chaty") ?>">
                <input type="hidden" name="page" value="chaty-contact-form-feed" />
                <div class="date-range <?php echo ($searchFor == "custom" ? "active" : "") ?>">
                    <input type="search" class="search-input" name="start_date" id="start_date" value="<?php echo esc_attr($startDate) ?>" autocomplete="off" placeholder="Start date">
                    <input type="search" class="search-input" name="end_date" id="end_date" value="<?php echo esc_attr($endDate) ?>" autocomplete="off" placeholder="End date">
                </div>
            </form>
        </div>

<?php }//end if
        ?>
        <form action="" method="post" class="responsive-table contact-form-lead">
            <?php if ($result) { ?>
            <table border="0" cellspacing="0" cellpadding="0" class="border-separate w-full rounded-lg border border-cht-gray-50 mb-5" id="contact-feed">
                <thead>
                    <tr>
                        <th class="rounded-tl-lg text-cht-gray-150 text-sm font-semibold font-primary py-3 px-2 bg-cht-primary-50" style="width:1%"><?php esc_html_e('Bulk', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('ID', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Widget Name', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Name', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Email', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Phone number', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Message', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('IP Address', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('Date', 'chaty');?></th>
                        <th class="text-center text-cht-gray-150 text-sm font-semibold font-primary py-3 px-5 bg-cht-primary-50"><?php esc_html_e('URL', 'chaty');?></th>
                        <th class="rounded-tr-lg text-cht-gray-150 text-sm font-semibold font-primary py-3 px-2 bg-cht-primary-50"><?php esc_html_e('Delete', 'chaty');?></th>
                    </tr>
                </thead>
                <tbody>
                <?php
                    foreach ($result as $res) {
                        if ($res->widget_id == 0) {
                            $widgetName = "Default";
                        } else {
                            $widgetName = get_option("cht_widget_title_".$res->widget_id);
                            if (empty($widgetName)) {
                                $widgetName = "Widget #".($res->widget_id + 1);
                            }
                        }
                        $socialIcons = get_option('cht_social_Contact_Us');
                        ?>
                    <tr data-id="<?php echo esc_attr($res->id) ?>">
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r">
                            <div class="checkbox">
                                <label for="checkbox_<?php echo esc_attr($res->id) ?>" class="chaty-checkbox text-cht-gray-150 text-base items-center">
                                    <input class="sr-only" type="checkbox" id="checkbox_<?php echo esc_attr($res->id) ?>" name="chaty_leads[]" value="<?php echo esc_attr($res->id) ?>" />
                                    <span></span>
                                </label>
                            </div>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('ID', 'chaty');?>">
                            <?php echo esc_attr($res->id) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Widget Name', 'chaty');?>">
                            <?php echo esc_attr(stripslashes($widgetName)) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Name', 'chaty');?>">
                            <?php echo esc_attr(stripslashes($res->name)) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Email', 'chaty');?>">
                            <?php echo esc_attr(stripslashes($res->email)) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Phone number', 'chaty');?>">
                            <?php echo esc_attr(stripslashes($res->phone_number)) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Message', 'chaty');?>">
                            <?php echo nl2br(esc_attr(stripslashes($res->message))) ?>
                        </td>
                        <td
                            class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t"
                            data-title="<?php esc_html_e('IP Address', 'chaty');?>">
                            <?php
                            if(isset($socialIcons['capture_ip_address']) && $socialIcons['capture_ip_address'] == "yes") {
                                echo nl2br(esc_attr(stripslashes($res->ip_address)));
                            } else {
                                echo "";
                            }
                            ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('Date', 'chaty');?>">
                            <?php echo esc_attr($res->created_on) ?>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center border-r border-t" data-title="<?php esc_html_e('URL', 'chaty');?>">
                            <a class="url" target="_blank" href="<?php echo esc_url($res->ref_page) ?>">
                                <span class="dashicons dashicons-external"></span>
                            </a>
                        </td>
                        <td class="bg-white py-3.5 px-5 text-cht-gray-150 font-primary text-sm text-center">
                            <a class="remove-record" href="#">
                                <span class="dashicons dashicons-trash"></span>
                            </a>
                        </td>
                    </tr>
                    <?php }//end foreach
                        ?>
                </tbody>
            </table>
                <?php
                if ($totalPages > 1) {
                    $baseURL = admin_url("admin.php?paged=%#%&page=chaty-contact-form-feed");
                    if (!empty($search)) {
                        $baseURL .= "&search=".esc_attr($search);
                    }

echo '<div class="custom-pagination">';
                    echo paginate_links(
                        [
                            'base'         => $baseURL,
                            'total'        => $totalPages,
                            'current'      => $current,
                            'format'       => '?paged=%#%',
                            'show_all'     => false,
                            'type'         => 'list',
                            'end_size'     => 3,
                            'mid_size'     => 1,
                            'prev_next'    => true,
                            'prev_text'    => sprintf('%1$s', '<span class="dashicons dashicons-arrow-left-alt2"></span>'),
                            'next_text'    => sprintf('%1$s', '<span class="dashicons dashicons-arrow-right-alt2"></span>'),
                            'add_args'     => false,
                            'add_fragment' => '',
                        ]
                    );
                    echo "</div>";
                }//end if
                ?>
            <div class="leads-buttons flex items-center gap-3 flex-wrap">
                <a href="<?php echo esc_url(admin_url("?download_chaty_file=chaty_contact_leads&nonce=".wp_create_nonce("download_chaty_contact_leads"))) ?>" class="btn rounded-lg inline-block" id="wpappp_export_to_csv" value="Export to CSV"><?php esc_html_e('Download & Export to CSV', 'chaty') ?></a>
                <input type="button" class="inline-block cursor-pointer rounded-lg bg-transparent border-red-500 text-red-500 hover:bg-red-500/10 focus:bg-red-500/10 hover:text-red-500 btn btn-primary" id="chaty_delete_all_leads" value="Delete All Data">
            </div>
            <?php  } else if (!empty($search) || $searchFor != "all_time") { ?>
            <div class="chaty-updates-form pt-7">
                <div class="testimonial-error-message max-w-screen-sm font-primary mx-auto">
                    <p class="px-5 text-2xl text-center"><?php esc_html_e('No records are found', 'chaty') ?></p>
                </div>
            </div>
            <?php } else { ?>
                <div class="container mt-12">
                    <div class="chaty-table no-widgets py-20 bg-cover rounded-lg border border-cht-gray-50">
                        <img class="mx-auto w-60" src="<?php echo esc_url(CHT_PLUGIN_URL . "/admin/assets/images/stars-image.png") ?>" />
                        <div class="text-center">
                            <div class="update-title text-cht-gray-150 text-3xl sm:text-4xl pb-5"><?php esc_html('Contact Form Leads', 'chaty') ?></div>
                            <p class="font-primary text-base text-cht-gray-150 -mt-2 max-w-screen-sm px-5 mx-auto">
                                <?php esc_html_e("Your contact form leads will appear here once you get some leads. Please make sure you've added the contact form channel to your Chaty channels in order to collect leads", 'chaty') ?>
                            </p>
                        </div>
                    </div>
                </div>
            <?php }//end if
            ?>
            <input type="hidden" name="remove_chaty_leads" value="<?php echo esc_attr(wp_create_nonce("remove_chaty_leads")) ?>">
            <input type="hidden" name="paged" value="<?php echo esc_attr($current) ?>">
            <input type="hidden" name="search" value="<?php echo esc_attr($search) ?>">
        </form>
    </div>
</div>

if (jQuery("#end_date").val() == "") {
                    jQuery("#end_date").val(jQuery("#start_date").val());
                }
            }
        });
    }
    if (jQuery("#end_date").length) {
        jQuery("#end_date").datepicker({
            dateFormat: 'yy-mm-dd',
            altFormat: 'yy-mm-dd',
            maxDate: 0,
            minDate: 0,
            onSelect: function(d, i) {
                if (jQuery("#start_date").val() == "") {
                    jQuery("#start_date").val(jQuery("#end_date").val());
                }
            }
        });
    }
});
</script>

* @license : GPL2 * */ if (defined('ABSPATH') === false) { exit; } global $wpdb; $tableName = $wpdb->prefix.'chaty_contact_form_leads'; $paged = filter_input(INPUT_GET, 'paged'); $current = isset($paged)&&!empty($paged)&&is_numeric($paged)&&$paged > 0 ? $paged : 1; $current = intval($current); $searchFor = "all_time"; $searchList = [ 'today' => esc_html__('Today', 'chaty'), 'yesterday' => esc_html__('Yesterday', 'chaty'), 'last_7_days' => esc_html__('Last 7 Days', 'chaty'), 'last_30_days' => esc_html__('Last 30 Days', 'chaty'), 'this_week' => esc_html__('This Week', 'chaty'), 'this_month' => esc_html__('This Month', 'chaty'), 'all_time' => esc_html__('All Time', 'chaty'), 'custom' => esc_html__('Custom Date', 'chaty') ]; $searchFor = filter_input(INPUT_GET, 'search_for'); if (isset($searchFor) && !empty($searchFor) && isset($searchList[$searchFor])) { $searchFor = esc_attr($searchFor); } else { $searchFor = "all_time"; } $startDate = ""; $endDate = ""; if ($searchFor == "today") { $startDate = gmdate("Y-m-d"); $endDate = gmdate("Y-m-d"); } else if ($searchFor == "yesterday") { $startDate = gmdate("Y-m-d", strtotime("-1 days")); $endDate = gmdate("Y-m-d", strtotime("-1 days")); } else if ($searchFor == "last_7_days") { $startDate = gmdate("Y-m-d", strtotime("-7 days")); $endDate = gmdate("Y-m-d"); } else if ($searchFor == "last_30_days") { $startDate = gmdate("Y-m-d", strtotime("-30 days")); $endDate = gmdate("Y-m-d"); } else if ($searchFor == "this_week") { $startDate = gmdate("Y-m-d", strtotime('monday this week')); $endDate = gmdate("Y-m-d"); } else if ($searchFor == "this_month") { $startDate = gmdate("Y-m-01"); $endDate = gmdate("Y-m-d"); } else if ($searchFor == "custom") { $startDate = filter_input(INPUT_GET, 'start_date'); if (!empty($startDate)) { $startDate = esc_attr($startDate); } else { $startDate = ""; } $endDate = filter_input(INPUT_GET, 'end_date'); if (!empty($endDate)) { $endDate = esc_attr($endDate); } else { $endDate = ""; } }//end if $hasSearch = filter_input(INPUT_GET, 'search'); $hasSearch = isset($hasSearch)&&!empty($hasSearch) ? $hasSearch : false; $query = "SELECT count(id) as total_records FROM ".$tableName; $search = ""; $condition = ""; $conditionArray = []; if ($hasSearch !== false) { $search = $hasSearch; $hasSearch = '%'.esc_sql($hasSearch).'%'; $condition .= " (name LIKE %s OR email LIKE %s OR phone_number LIKE %s OR message LIKE %s)"; $conditionArray[] = $hasSearch; $conditionArray[] = $hasSearch; $conditionArray[] = $hasSearch; $conditionArray[] = $hasSearch; } $startDate = esc_attr($startDate); $endDate = esc_attr($endDate); if (!empty($startDate) && !empty($endDate)) { if (!empty($condition)) { $condition .= " AND "; } $cStartDate = gmdate("Y-m-d 00:00:00", strtotime($startDate)); $cEndDate = gmdate("Y-m-d 23:59:59", strtotime($endDate)); $condition .= " created_on >= %s AND created_on <= %s"; $conditionArray[] = $cStartDate; $conditionArray[] = $cEndDate; } if (!empty($condition)) { $query .= " WHERE ".$condition; } $query .= " ORDER BY ID DESC"; if (!empty($conditionArray)) { $query = $wpdb->prepare($query, $conditionArray); } $totalRecords = $wpdb->get_var($query); $perPage = 15; $totalPages = ceil($totalRecords / $perPage); $query = "SELECT * FROM ".$tableName; if (!empty($condition)) { $query .= " WHERE ".$condition; } if ($current > $totalPages) { $current = 1; } $startFrom = (($current - 1) * $perPage); $query .= " ORDER BY ID DESC"; $query .= " LIMIT $startFrom, $perPage"; if (!empty($conditionArray)) { $query = $wpdb->prepare($query, $conditionArray); } ?>

get_results($query); ?>

" >

widget_id == 0) { $widgetName = "Default"; } else { $widgetName = get_option("cht_widget_title_".$res->widget_id); if (empty($widgetName)) { $widgetName = "Widget #".($res->widget_id + 1); } } $socialIcons = get_option('cht_social_Contact_Us'); ?>


	id) ?>		name)) ?>	email)) ?>	phone_number)) ?>	message))) ?>	ip_address))); } else { echo ""; } ?>	created_on) ?>

1) { $baseURL = admin_url("admin.php?paged=%#%&page=chaty-contact-form-feed"); if (!empty($search)) { $baseURL .= "&search=".esc_attr($search); } echo '

'; echo paginate_links( [ 'base' => $baseURL, 'total' => $totalPages, 'current' => $current, 'format' => '?paged=%#%', 'show_all' => false, 'type' => 'list', 'end_size' => 3, 'mid_size' => 1, 'prev_next' => true, 'prev_text' => sprintf('%1$s', ''), 'next_text' => sprintf('%1$s', ''), 'add_args' => false, 'add_fragment' => '', ] ); echo "

"; }//end if ?>

" class="btn rounded-lg inline-block" id="wpappp_export_to_csv" value="Export to CSV">

" />