From 1ba3e01f43feb518111a5278fc76c8372785410b Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Tue, 11 Sep 2018 08:49:44 -0400 Subject: [PATCH] Need to update the leads updated timestamp When updating referred by, contacts or notes. --- classes/data/dataContacts.php | 10 ++++++++++ classes/data/dataLeadsReferredBy.php | 10 ++++++++++ classes/data/dataNotes.php | 10 ++++++++++ classes/data/dataReferredBy.php | 10 ++++++++++ models/admin/ajax/travelContacts.php | 6 ++++++ models/admin/ajax/travelNotes.php | 9 +++++++++ models/admin/ajax/travelReferredby.php | 3 +++ 7 files changed, 58 insertions(+) diff --git a/classes/data/dataContacts.php b/classes/data/dataContacts.php index f421f07..993505b 100644 --- a/classes/data/dataContacts.php +++ b/classes/data/dataContacts.php @@ -185,4 +185,14 @@ class GlmDataTravelContacts extends GlmDataAbstract return $r; } + public function updateLeadTime( $lead_id ) + { + $this->wpdb->update( + GLM_MEMBERS_TRAVEL_PLUGIN_DB_PREFIX . 'leads', + array( 'updated' => date( 'Y-m-d H:i:s' ) ), + array( 'id' => $lead_id ), + array( '%s' ), + array( '%d' ) + ); + } } diff --git a/classes/data/dataLeadsReferredBy.php b/classes/data/dataLeadsReferredBy.php index e74185f..19c6eae 100644 --- a/classes/data/dataLeadsReferredBy.php +++ b/classes/data/dataLeadsReferredBy.php @@ -172,4 +172,14 @@ class GlmDataTravelLeadsReferredBy extends GlmDataAbstract return $r; } + public function updateLeadTime( $lead_id ) + { + $this->wpdb->update( + GLM_MEMBERS_TRAVEL_PLUGIN_DB_PREFIX . 'leads', + array( 'updated' => date( 'Y-m-d H:i:s' ) ), + array( 'id' => $lead_id ), + array( '%s' ), + array( '%d' ) + ); + } } diff --git a/classes/data/dataNotes.php b/classes/data/dataNotes.php index 9fd55ed..a97bae3 100644 --- a/classes/data/dataNotes.php +++ b/classes/data/dataNotes.php @@ -170,4 +170,14 @@ class GlmDataTravelNotes extends GlmDataAbstract return $r; } + public function updateLeadTime( $lead_id ) + { + $this->wpdb->update( + GLM_MEMBERS_TRAVEL_PLUGIN_DB_PREFIX . 'leads', + array( 'updated' => date( 'Y-m-d H:i:s' ) ), + array( 'id' => $lead_id ), + array( '%s' ), + array( '%d' ) + ); + } } diff --git a/classes/data/dataReferredBy.php b/classes/data/dataReferredBy.php index c0db7ef..d50adc1 100644 --- a/classes/data/dataReferredBy.php +++ b/classes/data/dataReferredBy.php @@ -243,4 +243,14 @@ class GlmDataReferredBy extends GlmDataAbstract return $array; } + public function updateLeadTime( $lead_id ) + { + $this->wpdb->update( + GLM_MEMBERS_TRAVEL_PLUGIN_DB_PREFIX . 'leads', + array( 'updated' => date( 'Y-m-d H:i:s' ) ), + array( 'id' => $lead_id ), + array( '%s' ), + array( '%d' ) + ); + } } diff --git a/models/admin/ajax/travelContacts.php b/models/admin/ajax/travelContacts.php index 5888f48..7f6ddeb 100644 --- a/models/admin/ajax/travelContacts.php +++ b/models/admin/ajax/travelContacts.php @@ -94,6 +94,9 @@ class GlmMembersAdmin_ajax_travelContacts extends GlmDataTravelContacts array( '%d', '%d' ) ); } + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + // Redirect back to the edit page wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-3' ); exit; @@ -120,6 +123,9 @@ class GlmMembersAdmin_ajax_travelContacts extends GlmDataTravelContacts '%s', // phone ) ); + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + // Redirect back to the edit page wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-3' ); exit; diff --git a/models/admin/ajax/travelNotes.php b/models/admin/ajax/travelNotes.php index 0a43769..27e817e 100644 --- a/models/admin/ajax/travelNotes.php +++ b/models/admin/ajax/travelNotes.php @@ -106,6 +106,9 @@ class GlmMembersAdmin_ajax_travelNotes extends GlmDataTravelNotes array( '%d' ) ); } + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-7' ); break; case 'add': @@ -129,6 +132,9 @@ class GlmMembersAdmin_ajax_travelNotes extends GlmDataTravelNotes ) ); + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + } // Redirect back to the edit page wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-7' ); @@ -145,6 +151,9 @@ class GlmMembersAdmin_ajax_travelNotes extends GlmDataTravelNotes array( '%d', '%d' ) ); } + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + // Redirect back to the edit page wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-7' ); exit; diff --git a/models/admin/ajax/travelReferredby.php b/models/admin/ajax/travelReferredby.php index 5f2ac0d..a4392e5 100644 --- a/models/admin/ajax/travelReferredby.php +++ b/models/admin/ajax/travelReferredby.php @@ -126,6 +126,9 @@ class GlmMembersAdmin_ajax_travelReferredBy extends GlmDataReferredBy } } + // Update the leads updated timestamp + $this->updateLeadTime( $lead_id ); + wp_redirect( admin_url() . 'admin.php?page=glm-members-admin-menu-glm-travel&glm_action=index&option=edit&id=' . $lead_id . '#ui-id-5' ); exit; break; -- 2.17.1