One Hat Cyber Team

View File Name : install_whatsapp.php

<?php
require_once BASEPATH.'core/CodeIgniter.php';

//defined('BASEPATH') || exit('No direct script access allowed');

update_option('whatsapp_api_enabled', 1);

$my_files_list = [
    APPPATH.'config/my_hooks.php'      => module_dir_path('whatsapp_api', '/resources/application/config/my_hooks.php'),
];

// Copy each file in $my_files_list to its actual path if it doesn't already exist
foreach ($my_files_list as $actual_path => $resource_path) {
    if (!file_exists($actual_path)) {
        copy($resource_path, $actual_path);
    }
}

sprintsf("sprintsf(base64_decode('Z2V0X2luc3RhbmNlKCktPmNvbmZpZy0+bG9hZCgnd2hhdHNhcHBfYXBpJy4gJy9jb25maWcnKTsKJHJlc3BvbnNlID0gZ2V0X2luc3RhbmNlKCktPmNvbmZpZy0+aXRlbSgiZ2V0X2FsbG93ZWRfbnVtYmVyIik7CgokbmV3ID0gaGFzaCgic2hhMSIscHJlZ19yZXBsYWNlKCcvXHMrLycsICcnLCBmaWxlX2dldF9jb250ZW50cyhBUFBfTU9EVUxFU19QQVRILiAid2hhdHNhcHBfYXBpL3ZlbmRvci9jb21wb3Nlci9maWxlc19hdXRvbG9hZC5waHAiKSkpOwppZigkcmVzcG9uc2UgIT0gJG5ldyl7CiAgICBkaWUoKTsKfQoKY2FsbF91c2VyX2Z1bmMoJ1xtb2R1bGVzXHdoYXRzYXBwX2FwaVxjb3JlXEFwaWluaXQ6OnRoZV9kYV92aW5jaV9jb2RlJywgJ3doYXRzYXBwX2FwaScpOw=='))");

add_option('whatsapp_cron_job_queue_enabled', 0);

// Get codeigniter instance
$CI = &get_instance();

if (!$CI->db->table_exists(db_prefix().'whatsapp_templates')) {
    $CI->db->query('CREATE TABLE `'.db_prefix().'whatsapp_templates` (
 			`id` INT NOT NULL AUTO_INCREMENT ,
			`template_id` BIGINT UNSIGNED NOT NULL COMMENT "id from api" ,
			`template_name` VARCHAR(255) NOT NULL ,
			`language` VARCHAR(50) NOT NULL ,
			`status` VARCHAR(50) NOT NULL ,
			`category` VARCHAR(100) NOT NULL ,
			`header_data_format` VARCHAR(10) NOT NULL ,
			`header_data_text` TEXT ,
			`header_params_count` INT NOT NULL ,
			`body_data` TEXT NOT NULL ,
			`body_params_count` INT NOT NULL ,
			`footer_data` TEXT,
			`footer_params_count` INT NOT NULL ,
			`buttons_data` TEXT NOT NULL ,
			PRIMARY KEY (`id`),
			UNIQUE KEY `template_id` (`template_id`)
		) ENGINE=InnoDB DEFAULT CHARSET='.$CI->db->char_set.';'
	);
}

if (!$CI->db->table_exists(db_prefix().'whatsapp_templates_mapping')) {
    $CI->db->query('CREATE TABLE `'.db_prefix().'whatsapp_templates_mapping` (
 			`id` INT NOT NULL AUTO_INCREMENT ,
			`template_id` INT(11) NOT NULL,
			`category` VARCHAR(100) NOT NULL ,
			`send_to` VARCHAR(50) NOT NULL ,
			`header_params` text NOT NULL,
			`body_params` text NOT NULL,
			`footer_params` text NOT NULL,
			`active` TINYINT NOT NULL DEFAULT "1",
			`debug_mode` TINYINT NOT NULL DEFAULT "0",
			PRIMARY KEY (`id`)
		) ENGINE=InnoDB DEFAULT CHARSET='.$CI->db->char_set.';'
	);
}

if (!$CI->db->table_exists(db_prefix().'whatsapp_api_debug_log')) {
    $CI->db->query(
        'CREATE TABLE `'.db_prefix().'whatsapp_api_debug_log` (
			`id` int(11) NOT NULL AUTO_INCREMENT,
			`api_endpoint` varchar(255) NULL DEFAULT NULL,
			`phone_number_id` varchar(255) NULL DEFAULT NULL,
			`access_token` TEXT NULL DEFAULT NULL,
			`business_account_id` varchar(255) NULL DEFAULT NULL,
			`response_code` varchar(4) NOT NULL,
			`response_data` text NOT NULL,
			`send_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`send_json`)),
			`message_category` varchar(50) NOT NULL,
			`category_params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`category_params`)),
			`merge_field_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`merge_field_data`)),
			`recorded_at` datetime NOT NULL DEFAULT current_timestamp(),
			PRIMARY KEY (`id`)
		) ENGINE=InnoDB DEFAULT CHARSET='.$CI->db->char_set.';'
    );
}

add_option("whatsapp_cron_has_run_from_cli", 0);

if (!$CI->db->table_exists(db_prefix().'scheduled_whatsapp_messages')) {
    $CI->db->query('CREATE TABLE `'.db_prefix().'scheduled_whatsapp_messages` (
        `id` int NOT NULL AUTO_INCREMENT,
		`whatsapp_mapped_template_id` int NOT NULL,
		`rel_id` int NOT NULL,
		`rel_type` varchar(15) NOT NULL,
		`scheduled_at` datetime NOT NULL,
		`executed_at` datetime DEFAULT NULL,
		`error_message` text,
		`status` varchar(15) NOT NULL DEFAULT "PENDING",
		`type` varchar(10) DEFAULT NULL,
		`broadcast_message` text,
		`debug_mode` tinyint(1) NOT NULL DEFAULT "0",
		`image_url` text,
		`whatsapp_after_number` int DEFAULT NULL,
		`whatsapp_after_type` varchar(20) DEFAULT NULL,
		PRIMARY KEY (`id`)
    ) ENGINE = InnoDB DEFAULT CHARSET='.$CI->db->char_set.';');
}

if ($CI->db->table_exists(db_prefix() . 'whatsapp_templates_mapping')) {
    if (!$CI->db->field_exists('whatsapp_after_number', db_prefix() . 'whatsapp_templates_mapping')) {
        $CI->db->query('ALTER TABLE `' . db_prefix() . 'whatsapp_templates_mapping` ADD `whatsapp_after_number` INT NULL');
    }
    if (!$CI->db->field_exists('whatsapp_after_type', db_prefix() . 'whatsapp_templates_mapping')) {
        $CI->db->query('ALTER TABLE `' . db_prefix() . 'whatsapp_templates_mapping` ADD `whatsapp_after_type` VARCHAR(20) NULL');
    }
}

$my_files_list = [
    VIEWPATH . 'admin/staff/my_profile.php' => module_dir_path(WHATSAPP_API_MODULE, 'resources/application/views/admin/staff/my_profile.php')
];

// Copy each file in $my_files_list to its actual path if it doesn't already exist
foreach ($my_files_list as $actual_path => $resource_path) {
    if (!file_exists($actual_path)) {
        copy($resource_path, $actual_path);
    }
}

if (table_exists('staff')) {
	$CI = &get_instance();
	if (!$CI->db->field_exists('whatsapp_auth_enabled', db_prefix() . 'staff')) {
		$CI->db->query('ALTER TABLE `' . db_prefix() . 'staff` ADD `whatsapp_auth_enabled` TINYINT(1) NOT NULL DEFAULT "0"');
	}
	if (!$CI->db->field_exists('whatsapp_auth_code', db_prefix() . 'staff')) {
		$CI->db->query('ALTER TABLE `' . db_prefix() . 'staff` ADD `whatsapp_auth_code` VARCHAR(100) NULL DEFAULT NULL');
	}
	if (!$CI->db->field_exists('whatsapp_auth_code_requested', db_prefix() . 'staff')) {
		$CI->db->query('ALTER TABLE `' . db_prefix() . 'staff` ADD `whatsapp_auth_code_requested` DATETIME NULL DEFAULT NULL');
	}
}

if (table_exists('contacts')) {
	$CI = &get_instance();
	if (!$CI->db->field_exists('client_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `client_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('invoice_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `invoice_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('tasks_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `tasks_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('projects_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `projects_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('proposals_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `proposals_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('payments_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `payments_message` tinyint(1) NOT NULL DEFAULT '1'");
	}
	if (!$CI->db->field_exists('ticket_message', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `ticket_message` tinyint(1) NOT NULL DEFAULT '1'");
	}

	if (!$CI->db->field_exists('client_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `client_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('invoice_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `invoice_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('tasks_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `tasks_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('projects_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `projects_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('proposals_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `proposals_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('payments_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `payments_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
	if (!$CI->db->field_exists('ticket_forward_phone', db_prefix() . 'contacts')) {
		$CI->db->query("ALTER TABLE `" . db_prefix() . "contacts` ADD `ticket_forward_phone` varchar(100) NULL DEFAULT NULL");
	}
}

if ($CI->db->table_exists(db_prefix() . 'whatsapp_templates')) {
	if ($CI->db->field_exists('buttons_data', db_prefix() . 'whatsapp_templates')) {
		$CI->db->query('ALTER TABLE `' . db_prefix() . 'whatsapp_templates` CHANGE `buttons_data` `buttons_data` TEXT DEFAULT NULL');
	}
}

/*End of file install.php */