public static function delete_quote($quote_id)
{
$quote_id = (int) $quote_id;
if (_DEMO_MODE && $quote_id == 1) {
return;
}
if ((int) $quote_id > 0) {
$original_quote_data = self::get_quote($quote_id);
if (!$original_quote_data || $original_quote_data['quote_id'] != $quote_id) {
return false;
}
} else {
return false;
}
if (!self::can_i('delete', 'Quotes')) {
return false;
}
$sql = "DELETE FROM " . _DB_PREFIX . "quote WHERE quote_id = '" . $quote_id . "' LIMIT 1";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "quote_tax WHERE quote_id = '" . $quote_id . "'";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "quote_task WHERE quote_id = '" . $quote_id . "'";
$res = query($sql);
if (class_exists('module_file', false)) {
$sql = "UPDATE " . _DB_PREFIX . "file SET quote_id = 0 WHERE quote_id = '" . $quote_id . "'";
query($sql);
}
if (class_exists('module_group', false)) {
module_group::delete_member($quote_id, 'quote');
}
if (class_exists('module_note', false) && module_note::is_plugin_enabled()) {
module_note::note_delete("quote", $quote_id);
}
if (class_exists('module_extra', false) && module_extra::is_plugin_enabled()) {
module_extra::delete_extras('quote', 'quote_id', $quote_id);
}
hook_handle_callback('quote_delete', $quote_id);
module_cache::clear('quote');
}
public static function delete_job($job_id)
{
$job_id = (int) $job_id;
if (_DEMO_MODE && $job_id == 1) {
return;
}
if ((int) $job_id > 0) {
$original_job_data = self::get_job($job_id);
if (!$original_job_data || $original_job_data['job_id'] != $job_id) {
return false;
}
}
if (!self::can_i('delete', 'Jobs')) {
return false;
}
$sql = "DELETE FROM " . _DB_PREFIX . "job WHERE job_id = '" . $job_id . "' LIMIT 1";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "task WHERE job_id = '" . $job_id . "'";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "task_log WHERE job_id = '" . $job_id . "'";
$res = query($sql);
$sql = "UPDATE " . _DB_PREFIX . "job SET renew_job_id = NULL WHERE renew_job_id = '" . $job_id . "'";
$res = query($sql);
if (class_exists('module_file', false)) {
$sql = "UPDATE " . _DB_PREFIX . "file SET job_id = 0 WHERE job_id = '" . $job_id . "'";
query($sql);
}
if (class_exists('module_group', false)) {
module_group::delete_member($job_id, 'job');
}
foreach (module_invoice::get_invoices(array('job_id' => $job_id)) as $val) {
// only delete this invoice if it has no tasks left
// it could be a combined invoice with other jobs now.
$invoice_items = module_invoice::get_invoice_items($val['invoice_id']);
if (!count($invoice_items)) {
module_invoice::delete_invoice($val['invoice_id']);
}
}
if (class_exists('module_note', false) && module_note::is_plugin_enabled()) {
module_note::note_delete("job", $job_id);
}
if (class_exists('module_extra', false) && module_extra::is_plugin_enabled()) {
module_extra::delete_extras('job', 'job_id', $job_id);
}
hook_handle_callback('job_delete', $job_id);
module_cache::clear('job');
}
public function external_hook($hook)
{
switch ($hook) {
case 'subscribe_form':
// handle subscriptions to the member database and also the newsletter system.
// todo - tie in with "subscription" module to allow users to select which subscription they want as well.
// handle subscriptions to the member database and also the newsletter system.
// todo - tie in with "subscription" module to allow users to select which subscription they want as well.
case 'subscribe':
$member = isset($_REQUEST['member']) && is_array($_REQUEST['member']) ? $_REQUEST['member'] : false;
$provided_member_id = isset($_REQUEST['i']) ? (int) $_REQUEST['i'] : false;
$hash = isset($_REQUEST['hash']) ? trim($_REQUEST['hash']) : false;
$member_id = false;
if ($member) {
if (isset($member['email']) && $member['email']) {
// proceed with signup
$email = filter_var(strtolower(trim($member['email'])), FILTER_VALIDATE_EMAIL);
if (strlen($email) > 3) {
$adding_new_member = true;
// are we adding a new member to the system or updating an old one
if ($provided_member_id && $hash) {
$real_hash = $this->link_public_details($provided_member_id, true);
if ($real_hash == $hash) {
$existing_member = get_single('member', 'email', $email);
if ($existing_member && $existing_member['member_id'] != $provided_member_id) {
// this user is trying to update their email address to a user who exists in the system already
$template = module_template::get_template_by_key('member_subscription_error');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('message' => _l('The email address %s is already linked to another member.', htmlspecialchars($email))));
echo $template->render('pretty_html');
exit;
}
$adding_new_member = false;
// updating details in the system.
update_insert("member_id", $provided_member_id, "member", $member);
$member_id = $provided_member_id;
// update extra fields...
}
}
if (!$member_id) {
// add member to system.
$existing_member = get_single('member', 'email', $email);
if ($existing_member && $existing_member['member_id'] > 0) {
// todo: give them link to change details.
$template = module_template::get_template_by_key('member_subscription_error');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('message' => _l('The email address %s is already a member. Please click the link in our newsletter to modify your details.', htmlspecialchars($email))));
echo $template->render('pretty_html');
exit;
}
// todo - sanatise input here, this will allow anyone to insert member details:
$member_id = update_insert("member_id", 'new', "member", $member);
}
if ($member_id) {
// save extra fields against member.
$extra_fields = module_extra::get_defaults('member');
$extra_values = array();
foreach ($extra_fields as $extra_field) {
// check if this field was submitted.
if (isset($member[$extra_field['key']])) {
$extra_values[$extra_field['key']] = array('val' => $member[$extra_field['key']], 'key' => $extra_field['key']);
}
}
if (count($extra_values)) {
$_REQUEST['extra_member_field'] = $extra_values;
module_extra::save_extras('member', 'member_id', $member_id, false);
}
if (class_exists('module_newsletter', false)) {
$newsletter_member_id = module_newsletter::member_from_email(array('email' => $email, 'member_id' => $member_id, 'data_callback' => 'module_member::get_newsletter_recipient', 'data_args' => $member_id), true, true);
module_newsletter::subscribe_member($email, $newsletter_member_id);
// now add thsi member to the grups they have selected.
if (isset($member['group']) && is_array($member['group'])) {
$group_items = module_group::get_groups('newsletter_subscription');
$public_group_ids = array();
foreach ($group_items as $group_item) {
$public_group_ids[$group_item['group_id']] = true;
// remove user group all these groups.
module_group::delete_member($member_id, 'newsletter_subscription');
}
//print_r($member['group']);print_r($public_group_ids);exit;
foreach ($member['group'] as $group_id => $tf) {
if ($tf && isset($public_group_ids[$group_id])) {
// add member to group - but only public group ids!
module_group::add_to_group($group_id, $member_id);
}
}
}
}
// is the newsletter module giving us a subscription redirection?
if ($adding_new_member) {
if (module_config::c('newsletter_subscribe_redirect', '')) {
redirect_browser(module_config::c('newsletter_subscribe_redirect', ''));
}
$template = module_template::get_template_by_key('member_subscription_success');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('email' => $email));
echo $template->render('pretty_html');
exit;
} else {
if (module_config::c('newsletter_update_details_redirect', '')) {
redirect_browser(module_config::c('newsletter_update_details_redirect', ''));
}
$template = module_template::get_template_by_key('member_update_details_success');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('email' => $email));
echo $template->render('pretty_html');
exit;
}
} else {
echo 'database failure.. please try again.';
}
} else {
$template = module_template::get_template_by_key('member_subscription_error');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('message' => _l('Sorry please go back and complete all required fields (especially email address)')));
echo $template->render('pretty_html');
exit;
}
} else {
$template = module_template::get_template_by_key('member_subscription_error');
$template->page_title = htmlspecialchars(_l('Subscription'));
$template->assign_values(array('message' => _l('Sorry please go back and complete all required fields')));
echo $template->render('pretty_html');
exit;
}
} else {
$template = module_template::get_template_by_key('member_subscription_form');
$template->page_title = htmlspecialchars(_l('Subscription'));
// we also treat this as a subscription modification form.
$newsletter_subscriptions = array();
$member = array('email' => '', 'first_name' => '', 'last_name' => '', 'business' => '', 'phone' => '', 'mobile' => '');
// extra fields:
$extra_fields = module_extra::get_defaults('member');
foreach ($extra_fields as $extra_field) {
$member[$extra_field['key']] = '';
}
if ($provided_member_id && $hash) {
$real_hash = $this->link_public_details($provided_member_id, true);
if ($real_hash == $hash) {
// we can load these details into the forum successfully.
$member = array_merge($member, $this->get_member($provided_member_id));
// get their fields:
$extra_fields = module_extra::get_extras(array('owner_table' => 'member', 'owner_id' => $provided_member_id));
foreach ($extra_fields as $extra_field) {
$member[$extra_field['extra_key']] = $extra_field['extra'];
}
// find out what newsletter subscriptions this member has.
if (class_exists('module_newsletter', false)) {
$newsletter_member_id = module_newsletter::member_from_email($member, true, true);
$newsletter_subscriptions = module_group::get_member_groups('newsletter_subscription', $provided_member_id);
}
}
}
$template->assign_values($member);
if (class_exists('module_newsletter', false)) {
$group_items = module_group::get_groups('newsletter_subscription');
ob_start();
foreach ($group_items as $group_item) {
?>
<div class="group_select">
<input type="checkbox" name="member[group][<?php
echo $group_item['group_id'];
?>
]" value="1"<?php
foreach ($newsletter_subscriptions as $newsletter_subscription) {
if ($newsletter_subscription['group_id'] == $group_item['group_id']) {
echo ' checked';
}
}
?>
> <?php
echo htmlspecialchars($group_item['name']);
?>
</div>
<?php
}
$template->assign_values(array('newsletter_options' => ob_get_clean()));
} else {
$template->assign_values(array('newsletter_options' => ''));
}
echo $template->render('pretty_html');
exit;
}
break;
}
}
public function delete_customer($customer_id, $remove_linked_data = true)
{
$customer_id = (int) $customer_id;
if ($customer_id > 0) {
if (_DEMO_MODE && $customer_id == 1) {
set_error('Sorry this is a Demo Customer. It cannot be changed.');
redirect_browser(self::link_open($customer_id));
}
$customer = self::get_customer($customer_id);
if ($customer && $customer['customer_id'] == $customer_id) {
// todo: Delete emails (wack these in this customer_deleted hook)
hook_handle_callback('customer_deleted', $customer_id, $remove_linked_data);
if (class_exists('module_group', false)) {
// remove the customer from his groups
module_group::delete_member($customer_id, 'customer');
}
if (class_exists('module_extra', false)) {
module_extra::delete_extras('customer', 'customer_id', $customer_id);
}
// remove the contacts from this customer
foreach (module_user::get_contacts(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
module_user::delete_user($val['user_id']);
}
}
// remove staff
delete_from_db('customer_user_rel', 'customer_id', $customer_id);
if (class_exists('module_note', false)) {
module_note::note_delete("customer", 'customer_id', $customer_id);
}
handle_hook("address_delete", $this, 'all', "customer", 'customer_id', $customer_id);
// todo, check the 'delete' permission on each one of these 'delete' method calls
// do that better when we remove each of these and put them into the customer delete hook
if ($remove_linked_data) {
if (class_exists('module_website', false) && module_website::is_plugin_enabled()) {
foreach (module_website::get_websites(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
module_website::delete_website($val['website_id']);
}
}
}
if (class_exists('module_job', false) && module_job::is_plugin_enabled()) {
foreach (module_job::get_jobs(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
module_job::delete_job($val['job_id']);
}
}
}
if (class_exists('module_invoice', false) && module_invoice::is_plugin_enabled()) {
foreach (module_invoice::get_invoices(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
module_invoice::delete_invoice($val['invoice_id']);
}
}
}
if (class_exists('module_quote', false) && module_quote::is_plugin_enabled()) {
foreach (module_quote::get_quotes(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
module_quote::delete_quote($val['quote_id']);
}
}
}
//handle_hook("file_delete",$this,"customer",'customer_id',$customer_id);
} else {
// instead of deleting these records we just update them to customer_id = 0
if (class_exists('module_website', false) && module_website::is_plugin_enabled()) {
foreach (module_website::get_websites(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
update_insert('website_id', $val['website_id'], 'website', array('customer_id' => 0));
}
}
}
if (class_exists('module_job', false) && module_job::is_plugin_enabled()) {
foreach (module_job::get_jobs(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
update_insert('job_id', $val['job_id'], 'job', array('customer_id' => 0));
}
}
}
if (class_exists('module_invoice', false) && module_invoice::is_plugin_enabled()) {
foreach (module_invoice::get_invoices(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
update_insert('invoice_id', $val['invoice_id'], 'invoice', array('customer_id' => 0));
}
}
}
if (class_exists('module_quote', false) && module_quote::is_plugin_enabled()) {
foreach (module_quote::get_quotes(array('customer_id' => $customer_id)) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
update_insert('quote_id', $val['quote_id'], 'quote', array('customer_id' => 0));
}
}
}
if (class_exists('module_file', false) && module_file::is_plugin_enabled()) {
foreach (module_file::get_files(array('owner_id' => $customer_id, 'owner_table' => 'customer')) as $val) {
if ($val['customer_id'] && $val['customer_id'] == $customer_id) {
update_insert('file_id', $val['file_id'], 'file', array('owner_id' => 0, 'owner_table' => ''));
}
}
}
}
// finally delete the main customer record
// (this is so the above code works with its sql joins)
$sql = "DELETE FROM " . _DB_PREFIX . "customer WHERE customer_id = '" . $customer_id . "' LIMIT 1";
query($sql);
}
}
}
public function delete_vendor($vendor_id, $remove_linked_data = true)
{
$vendor_id = (int) $vendor_id;
if ($vendor_id > 0) {
if (_DEMO_MODE && $vendor_id == 1) {
set_error('Sorry this is a Demo Vendor. It cannot be changed.');
redirect_browser(self::link_open($vendor_id));
}
$vendor = self::get_vendor($vendor_id);
if ($vendor && $vendor['vendor_id'] == $vendor_id) {
// todo: Delete emails (wack these in this vendor_deleted hook)
hook_handle_callback('vendor_deleted', $vendor_id, $remove_linked_data);
if (class_exists('module_group', false)) {
// remove the vendor from his groups
module_group::delete_member($vendor_id, 'vendor');
}
if (class_exists('module_extra', false)) {
module_extra::delete_extras('vendor', 'vendor_id', $vendor_id);
}
// remove the contacts from this vendor
foreach (module_user::get_contacts(array('vendor_id' => $vendor_id)) as $val) {
if ($val['vendor_id'] && $val['vendor_id'] == $vendor_id) {
module_user::delete_user($val['user_id']);
}
}
if (class_exists('module_note', false)) {
module_note::note_delete("vendor", 'vendor_id', $vendor_id);
}
handle_hook("address_delete", $this, 'all', "vendor", 'vendor_id', $vendor_id);
// finally delete the main vendor record
// (this is so the above code works with its sql joins)
$sql = "DELETE FROM " . _DB_PREFIX . "vendor WHERE vendor_id = '" . $vendor_id . "' LIMIT 1";
query($sql);
}
}
}
public static function delete_website($website_id)
{
$website_id = (int) $website_id;
if (_DEMO_MODE && $website_id == 1) {
set_error('Sorry this is a Demo Website. It cannot be deleted.');
return;
}
if ((int) $website_id > 0) {
$original_website_data = self::get_website($website_id);
if (!$original_website_data || $original_website_data['website_id'] != $website_id) {
return false;
}
}
if (!self::can_i('delete', 'Websites')) {
return false;
}
hook_handle_callback('website_deleted', $website_id);
$sql = "DELETE FROM " . _DB_PREFIX . "website WHERE website_id = '" . $website_id . "' LIMIT 1";
query($sql);
if (class_exists('module_group', false)) {
module_group::delete_member($website_id, 'website');
}
foreach (module_job::get_jobs(array('website_id' => $website_id)) as $val) {
module_job::delete_job($val['website_id']);
}
module_note::note_delete("website", $website_id);
module_extra::delete_extras('website', 'website_id', $website_id);
}
public static function delete_ticket($ticket_id)
{
$ticket_id = (int) $ticket_id;
$sql = "DELETE FROM " . _DB_PREFIX . "ticket WHERE ticket_id = '" . $ticket_id . "' LIMIT 1";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "ticket_message WHERE ticket_id = '" . $ticket_id . "'";
$res = query($sql);
$sql = "DELETE FROM " . _DB_PREFIX . "ticket_message_attachment WHERE ticket_id = '" . $ticket_id . "'";
$res = query($sql);
if (class_exists('module_group', false)) {
module_group::delete_member($ticket_id, 'ticket');
}
module_cache::clear('ticket');
// module_note::note_delete("ticket",$ticket_id);
// module_extra::delete_extras('ticket','ticket_id',$ticket_id);
}
