success = false;
$multiple = isset($_REQUEST['multiple'])? $_REQUEST['multiple']: null;
$delete_sql;$mResults;
if($multiple) {
$item_ids = implode(",", array_map( 'intval', $_POST['item_ids'] ));
$delete_sql = "DELETE FROM ".ASL_PREFIX."leads WHERE id IN (".$item_ids.")";
$mResults = $wpdb->get_results("SELECT * FROM ".ASL_PREFIX."leads WHERE id IN (".$item_ids.")");
}
else {
$item_id = intval($_REQUEST['lead_id']);
$delete_sql = "DELETE FROM ".ASL_PREFIX."leads WHERE id = ".$item_id;
$mResults = $wpdb->get_results("SELECT * FROM ".ASL_PREFIX."leads WHERE id = ".$item_id );
}
if(count($mResults) != 0) {
if($wpdb->query($delete_sql)) {
$response->success = true;
}
else
{
$response->error = esc_attr__('Error occurred while deleting record','asl_locator');
$response->msg = $wpdb->show_errors();
}
}
else
{
$response->error = esc_attr__('Error occurred while deleting record','asl_locator');
}
if($response->success)
$response->msg = ($multiple)?__('Leads deleted successfully.','asl_locator'):esc_attr__('Lead deleted successfully.','asl_locator');
return $this->send_response($response);
}
/**
* [update_lead update lead with icon]
* @return [type] [description]
*/
public function update_lead() {
global $wpdb;
$response = new \stdclass();
$response->success = false;
$data = $_REQUEST['data'];
// Lead Update Parameter
$data_params = array('lead_name' => trim(sanitize_text_field($data['lead_name'])));
// Execute the Update Query
$wpdb->update(ASL_PREFIX."leads", $data_params, array('id' => sanitize_text_field($data['lead_id'])));
$response->msg = esc_attr__('Lead Updated Successfully.','asl_locator');
$response->success = true;
return $this->send_response($response);
}
/**
* [export_dealers Export the CSV file the dealers]
* @return [type] [description]
*/
public function export_dealers() {
global $wpdb;
$duration = isset( $_REQUEST['sl-duration'])?$_REQUEST['sl-duration']: null;
list($start_date, $end_date) = explode('-', $duration);
// Trim dates
$start_date = date('Y-m-d', strtotime((trim($start_date)))).' 00:00:00';
$end_date = date('Y-m-d', strtotime((trim($end_date)))).' 23:59:00';
// leads Data
//$leads = $wpdb->get_results($wpdb->prepare("SELECT `l`.`id`, `l`.`name`, `l`.`phone`, `l`.`postal_code`, `l`.`email`, `l`.`message`, s.`title`, s.`street`, s.`city` FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id WHERE l.created_on >= %s AND l.created_on <= %s", $start_date, $end_date ));
$leads = $wpdb->get_results($wpdb->prepare("SELECT COUNT(*) AS 'total', s.`title` as 'Store Name', s.`street` as 'Store Street', s.`city` as 'Store City' FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id WHERE l.created_on between %s AND %s AND `l`.`store_id` > 0 GROUP BY l.store_id", $start_date, $end_date ));
$csv = new \AgileStoreLocator\Admin\CSV\Reader();
// Rows to be exported
$all_rows = [];
// Just send the headers for empty
if(!$leads) {
$leads = [['Total' => '', 'Store Name' => '', 'Street'=> '', 'City' => '']];
}
// Loop over the stores data
foreach ($leads as $value) {
//unset($value->id);
// Push into rows collection
$all_rows[] = $value;
}
$csv->setRows($all_rows);
$csv->write(\AgileStoreLocator\Admin\CSV\Reader::DOWNLOAD, 'dealers-export.csv');;
die;
}
/**
* [export_leads Export the leads filter by duration]
* @return [type] [description]
*/
public function export_leads() {
global $wpdb;
$duration = isset( $_REQUEST['sl-duration'])?$_REQUEST['sl-duration']: null;
list($start_date, $end_date) = explode('-', $duration);
// Trim dates
$start_date = date('Y-m-d', strtotime((trim($start_date)))).' 00:00:00';
$end_date = date('Y-m-d', strtotime((trim($end_date)))).' 23:59:00';
// leads Data
//$leads = $wpdb->get_results($wpdb->prepare("SELECT `l`.`id`, `l`.`name`, `l`.`phone`, `l`.`postal_code`, `l`.`email`, `l`.`message`, s.`title`, s.`street`, s.`city` FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id WHERE l.created_on >= %s AND l.created_on <= %s", $start_date, $end_date ));
$leads = $wpdb->get_results($wpdb->prepare("SELECT `l`.`id`, `l`.`name` as 'Lead Name', `l`.`phone` as 'Lead Phone', `l`.`postal_code` as 'Lead Postal Code', `l`.`email` as 'Lead Email', `l`.`message` as 'Message', `l`.`created_on` as 'Dated', s.`title` as 'Store Name', s.`street` as 'Store Street', s.`city` as 'Store City' FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id WHERE l.created_on between %s AND %s", $start_date, $end_date ));
// Just send the headers for empty
if(!$leads) {
$leads = [['id' => '', 'Name' => '' , 'Phone' => '', 'Postal Code' => '', 'Email' => '', 'Message' =>'']];
}
$csv = new \AgileStoreLocator\Admin\CSV\Reader();
// Rows to be exported
$all_rows = [];
// Loop over the stores data
foreach ($leads as $value) {
//unset($value->id);
// Push into rows collection
$all_rows[] = $value;
}
$csv->setRows($all_rows);
$csv->write(\AgileStoreLocator\Admin\CSV\Reader::DOWNLOAD, 'leads-export.csv');;
die;
}
/**
* [get_leads GET the Leads List]
* @return [type] [description]
*/
public function get_leads() {
global $wpdb;
$start = isset( $_REQUEST['iDisplayStart'])?$_REQUEST['iDisplayStart']:0;
$params = isset($_REQUEST)?$_REQUEST:null;
$acolumns = array(
'l.id','l.id','l.name','l.phone', 'l.email', 'l.postal_code', 's.title', 'l.created_on'
);
$columnsFull = $acolumns;
$clause = array();
if(isset($_REQUEST['filter'])) {
foreach($_REQUEST['filter'] as $key => $value) {
if($value != '') {
$value = sanitize_text_field($value);
$key = sanitize_text_field($key);
$clause[] = "$key like '%{$value}%'";
}
}
}
//iDisplayStart::Limit per page
$sLimit = "";
if ( isset( $_REQUEST['iDisplayStart'] ) && $_REQUEST['iDisplayLength'] != '-1' )
{
$sLimit = "LIMIT ".intval( $_REQUEST['iDisplayStart'] ).", ".
intval( $_REQUEST['iDisplayLength'] );
}
/*
* Ordering
*/
$sOrder = "";
if ( isset( $_REQUEST['iSortCol_0'] ) )
{
$sOrder = "ORDER BY ";
for ( $i=0 ; $i < intval( $_REQUEST['iSortingCols'] ) ; $i++ )
{
if (isset($_REQUEST['iSortCol_'.$i]))
{
$sort_dir = (isset($_REQUEST['sSortDir_0']) && $_REQUEST['sSortDir_0'] == 'asc')? 'ASC': 'DESC';
$sOrder .= "".$acolumns[ intval( $_REQUEST['iSortCol_'.$i] ) ]." ".$sort_dir;
break;
}
}
//$sOrder = substr_replace( $sOrder, "", -2 );
if ( $sOrder == "ORDER BY" )
{
$sOrder = "";
}
}
$sWhere = implode(' AND ',$clause);
if($sWhere != '')$sWhere = ' WHERE '.$sWhere;
$fields = implode(',', $columnsFull);
###get the fields###
$sql = "SELECT `l`.`id`, `l`.`name`, `l`.`phone`, `l`.`postal_code`, `l`.`email`, `l`.`message`, `l`.`created_on`, s.`title` FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id";
$sqlCount = "SELECT count(*) 'count' FROM ".ASL_PREFIX."leads as l LEFT JOIN ".ASL_PREFIX."stores as s ON s.id = l.store_id";
/*
* SQL queries
* Get data to display
*/
$sQuery = "{$sql} {$sWhere} {$sOrder} {$sLimit}";
$data_output = $wpdb->get_results($sQuery);
/* Data set length after filtering */
$sQuery = "{$sqlCount} {$sWhere}";
$r = $wpdb->get_results($sQuery);
$iFilteredTotal = $r[0]->count;
$iTotal = $iFilteredTotal;
/*
* Output
*/
$sEcho = isset($_REQUEST['sEcho'])?intval($_REQUEST['sEcho']):1;
$output = array(
"sEcho" => intval($_REQUEST['sEcho']),
//"test" => $sQuery,
"iTotalRecords" => $iTotal,
"iTotalDisplayRecords" => $iFilteredTotal,
"aaData" => array()
);
foreach($data_output as $aRow) {
$row = $aRow;
$row->dated = strtotime($row->created_on);
$row->check = '';
$row->action = '';
$output['aaData'][] = $row;
}
return $this->send_response($output);
}
/**
* [get_lead_by_id get lead by id]
* @return [type] [description]
*/
public function get_lead_by_id() {
global $wpdb;
$response = new \stdclass();
$response->success = false;
$store_id = isset($_REQUEST['lead_id'])? intval($_REQUEST['lead_id']): 0;
$response->list = $wpdb->get_results( "SELECT * FROM ".ASL_PREFIX."leads WHERE id = ".$store_id);
if(count($response->list)!=0){
$response->success = true;
}
else{
$response->error = esc_attr__('Error occurred while geting record','asl_locator');
}
return $this->send_response($response);
}
}