-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 25, 2026 at 08:49 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `gooyachat`
--
DROP DATABASE IF EXISTS `gooyachat`;
CREATE DATABASE IF NOT EXISTS `gooyachat` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci;
USE `gooyachat`;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_access`
--
DROP TABLE IF EXISTS `gooyaacc_chat_access`;
CREATE TABLE `gooyaacc_chat_access` (
`user_id` int(11) NOT NULL,
`is_enabled` tinyint(1) NOT NULL DEFAULT 0,
`chat_role` enum('user','operator','admin') NOT NULL DEFAULT 'user',
`can_start_direct` tinyint(1) NOT NULL DEFAULT 1,
`display_name` varchar(150) DEFAULT NULL,
`avatar_path` varchar(255) DEFAULT NULL,
`is_online` tinyint(1) NOT NULL DEFAULT 0,
`last_seen_at` datetime DEFAULT NULL,
`enabled_by` int(11) DEFAULT NULL,
`enabled_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_access`
--
INSERT IGNORE INTO `gooyaacc_chat_access` (`user_id`, `is_enabled`, `chat_role`, `can_start_direct`, `display_name`, `avatar_path`, `is_online`, `last_seen_at`, `enabled_by`, `enabled_at`, `updated_at`) VALUES
(1, 1, 'admin', 1, 'حسین فغان پور', NULL, 1, '2026-08-17 15:01:15', NULL, '2026-08-10 14:10:15', '2026-08-10 14:10:15'),
(2, 1, 'user', 1, 'علی محمدی', NULL, 1, '2026-08-11 11:26:34', 1, NULL, '2026-08-11 11:26:34'),
(3, 1, 'user', 1, 'سارا احمدی', NULL, 1, '2026-08-11 11:26:34', 1, NULL, '2026-08-11 11:26:34'),
(4, 1, 'user', 1, 'رضا کریمی', NULL, 0, NULL, 1, NULL, '2026-08-11 11:26:34'),
(5, 0, 'user', 1, 'عیسی زارع', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(6, 0, 'user', 1, 'رضا محمدیان', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(7, 0, 'user', 1, 'علی کریمی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(8, 0, 'user', 1, 'نیما قاسمی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(9, 0, 'user', 1, 'زهرا مرادی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(10, 0, 'user', 1, 'امیر صادقی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(11, 0, 'user', 1, 'سارا احمدی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(12, 0, 'user', 1, 'فاطمه کاظمی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(13, 0, 'user', 1, 'سینا یوسفی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(14, 0, 'user', 1, 'الهام جعفری', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(15, 0, 'user', 1, 'حسن رضایی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(16, 0, 'user', 1, 'بهرام اکبری', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(17, 0, 'user', 1, 'نگار شریفی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(18, 0, 'user', 1, 'پیمان بابایی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(19, 0, 'user', 1, 'مریم حسینی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(20, 0, 'user', 1, 'مینا رستمی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(21, 0, 'user', 1, 'کیان عباسی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(22, 0, 'user', 1, 'رها نادری', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(23, 0, 'user', 1, 'کاوه نوری', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(24, 0, 'user', 1, 'آرش فلاحی', NULL, 0, NULL, 1, NULL, '2026-08-10 14:46:50'),
(25, 0, 'user', 1, 'سحر زارع', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15'),
(26, 0, 'user', 1, 'وحید محمودی', NULL, 0, NULL, NULL, NULL, '2026-08-10 14:10:15');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_archive_attachments`
--
DROP TABLE IF EXISTS `gooyaacc_chat_archive_attachments`;
CREATE TABLE `gooyaacc_chat_archive_attachments` (
`id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`room_id` int(11) NOT NULL,
`storage_attachment_id` bigint(20) UNSIGNED NOT NULL,
`kind` enum('file','image','voice') NOT NULL DEFAULT 'file',
`orig_name` varchar(255) DEFAULT NULL,
`ext` varchar(12) DEFAULT NULL,
`mime` varchar(120) DEFAULT NULL,
`size_bytes` bigint(20) NOT NULL DEFAULT 0,
`duration_sec` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`sha256` char(64) DEFAULT NULL,
`storage_status` enum('pending','ready','deleted','failed') NOT NULL DEFAULT 'pending',
`created_at` datetime DEFAULT NULL,
`archive_run_id` int(11) NOT NULL,
`archived_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_archive_messages`
--
DROP TABLE IF EXISTS `gooyaacc_chat_archive_messages`;
CREATE TABLE `gooyaacc_chat_archive_messages` (
`id` int(11) NOT NULL,
`room_id` int(11) NOT NULL,
`sender_id` int(11) NOT NULL,
`msg_type` enum('text','file','image','voice','system') NOT NULL DEFAULT 'text',
`body` text DEFAULT NULL,
`reply_to_id` int(11) DEFAULT NULL,
`client_uid` varchar(40) DEFAULT NULL,
`is_edited` tinyint(1) NOT NULL DEFAULT 0,
`edited_at` datetime DEFAULT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`deleted_by` int(11) DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`archive_run_id` int(11) NOT NULL,
`archived_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_archive_runs`
--
DROP TABLE IF EXISTS `gooyaacc_chat_archive_runs`;
CREATE TABLE `gooyaacc_chat_archive_runs` (
`id` int(11) NOT NULL,
`run_type` enum('auto','manual') NOT NULL DEFAULT 'manual',
`cutoff_date` date NOT NULL,
`months_setting` int(11) NOT NULL DEFAULT 6,
`rooms_count` int(11) NOT NULL DEFAULT 0,
`messages_count` int(11) NOT NULL DEFAULT 0,
`attachments_count` int(11) NOT NULL DEFAULT 0,
`bytes_moved` bigint(20) NOT NULL DEFAULT 0,
`status` enum('running','done','failed','rolled_back') NOT NULL DEFAULT 'running',
`error_text` text DEFAULT NULL,
`cloud_export_status` enum('pending','exporting','ready','failed','disabled') NOT NULL DEFAULT 'pending',
`cloud_file_id` bigint(20) UNSIGNED DEFAULT NULL,
`cloud_attachment_id` bigint(20) UNSIGNED DEFAULT NULL,
`cloud_sha256` char(64) DEFAULT NULL,
`cloud_exported_at` datetime DEFAULT NULL,
`cloud_error_text` text DEFAULT NULL,
`run_by` int(11) DEFAULT NULL,
`started_at` datetime DEFAULT NULL,
`finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_attachments`
--
DROP TABLE IF EXISTS `gooyaacc_chat_attachments`;
CREATE TABLE `gooyaacc_chat_attachments` (
`id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`room_id` int(11) NOT NULL,
`storage_attachment_id` bigint(20) UNSIGNED NOT NULL,
`kind` enum('file','image','voice') NOT NULL DEFAULT 'file',
`orig_name` varchar(255) DEFAULT NULL,
`ext` varchar(12) DEFAULT NULL,
`mime` varchar(120) DEFAULT NULL,
`size_bytes` bigint(20) NOT NULL DEFAULT 0,
`duration_sec` int(11) DEFAULT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`sha256` char(64) DEFAULT NULL,
`storage_status` enum('pending','ready','deleted','failed') NOT NULL DEFAULT 'pending',
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_attachments`
--
INSERT IGNORE INTO `gooyaacc_chat_attachments` (`id`, `message_id`, `room_id`, `storage_attachment_id`, `kind`, `orig_name`, `ext`, `mime`, `size_bytes`, `duration_sec`, `width`, `height`, `sha256`, `storage_status`, `created_at`) VALUES
(28, 102, 1, 2569, 'voice', 'voice-1786437748206.webm', 'webm', 'video/webm', 162737, 11, NULL, NULL, 'bed146fcc639b657c990b79f0b72d1cda716c81c198e6b25b8b7d60c373c2e7b', 'ready', '2026-08-11 12:12:28'),
(29, 106, 1, 2714, 'voice', 'voice-1786962651679.webm', 'webm', 'video/webm', 67893, 5, NULL, NULL, 'cb1d8980229345f533233ed70a7032c2dd25a2d873788ce58f67acfed9d507e8', 'ready', '2026-08-17 14:00:52');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_log`
--
DROP TABLE IF EXISTS `gooyaacc_chat_log`;
CREATE TABLE `gooyaacc_chat_log` (
`id` int(11) NOT NULL,
`actor_id` int(11) DEFAULT NULL,
`action` varchar(50) NOT NULL,
`room_id` int(11) DEFAULT NULL,
`message_id` int(11) DEFAULT NULL,
`target_user_id` int(11) DEFAULT NULL,
`detail` varchar(500) DEFAULT NULL,
`ip` varchar(45) DEFAULT NULL,
`ua` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_log`
--
INSERT IGNORE INTO `gooyaacc_chat_log` (`id`, `actor_id`, `action`, `room_id`, `message_id`, `target_user_id`, `detail`, `ip`, `ua`, `created_at`) VALUES
(34, 1, 'update_settings', NULL, NULL, NULL, '{\"chat_globally_enabled\":1,\"allow_direct_chat\":1,\"max_file_size_mb\":10,\"archive_mode\":\"auto\",\"archive_after_months\":6,\"archive_hour\":2,\"retain_attachments_on_archive\":1}', '', 'GooyaChat admin', '2026-08-11 09:21:41'),
(316, 1, 'archive_export', NULL, NULL, NULL, '{\"run_id\":1,\"cloud_file_id\":114,\"sha256\":\"fdebce7a8c1b076ebbf3a16f712b35ce984fe8170615d35dec8f69c2fb093dc6\",\"format\":\"zip-jsonl-v1\"}', '', 'GooyaChat archive', '2026-08-11 11:29:24'),
(317, 1, 'archive_restore', NULL, NULL, NULL, '{\"run_id\":1,\"messages\":1,\"attachments\":1}', '', 'GooyaChat archive', '2026-08-11 11:29:24'),
(319, 1, 'archive_purge', NULL, NULL, NULL, '{\"run_id\":2,\"attachments\":1,\"via\":\"GooyaStorage\"}', '', 'GooyaChat archive', '2026-08-11 11:29:25'),
(375, 1, 'archive_export', NULL, NULL, NULL, '{\"run_id\":7,\"cloud_file_id\":115,\"sha256\":\"eaff99c75d9cad08e13fcfee2ca0f40cecf571a1b9ebf75cfd7bda29ad685ee3\",\"format\":\"zip-jsonl-v1\"}', '', 'GooyaChat archive', '2026-08-11 11:56:42'),
(376, 1, 'archive_restore', NULL, NULL, NULL, '{\"run_id\":7,\"messages\":1,\"attachments\":1}', '', 'GooyaChat archive', '2026-08-11 11:56:42'),
(378, 1, 'archive_export', NULL, NULL, NULL, '{\"run_id\":8,\"cloud_file_id\":116,\"sha256\":\"cbad4f5d5f11aeb2b55334f811d22dc88b73eb1095926727ca163807279331c1\",\"format\":\"zip-jsonl-v1\"}', '', 'GooyaChat archive', '2026-08-11 11:56:43'),
(379, 1, 'archive_purge', NULL, NULL, NULL, '{\"run_id\":8,\"attachments\":1,\"via\":\"GooyaStorage\"}', '', 'GooyaChat archive', '2026-08-11 11:56:43'),
(425, 1, 'archive_export', NULL, NULL, NULL, '{\"run_id\":9,\"cloud_file_id\":117,\"sha256\":\"588588d78b4325d4fdcf31ab6a39151fe6e3ead533b8ae126113f7cae04bd181\",\"format\":\"zip-jsonl-v1\"}', '', 'GooyaChat archive', '2026-08-11 11:57:07'),
(426, 1, 'archive_restore', NULL, NULL, NULL, '{\"run_id\":9,\"messages\":1,\"attachments\":1}', '', 'GooyaChat archive', '2026-08-11 11:57:07'),
(428, 1, 'archive_export', NULL, NULL, NULL, '{\"run_id\":10,\"cloud_file_id\":118,\"sha256\":\"68b3f303abc6415e24aff2dd17f08d9c0de2a66791dfca4414e3cf36b1065d93\",\"format\":\"zip-jsonl-v1\"}', '', 'GooyaChat archive', '2026-08-11 11:57:09'),
(429, 1, 'archive_purge', NULL, NULL, NULL, '{\"run_id\":10,\"attachments\":1,\"via\":\"GooyaStorage\"}', '', 'GooyaChat archive', '2026-08-11 11:57:09'),
(439, 1, 'send_attachment', 1, 102, NULL, '{\"storage_attachment_id\":2569,\"kind\":\"voice\",\"sha256\":\"bed146fcc639b657c990b79f0b72d1cda716c81c198e6b25b8b7d60c373c2e7b\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', '2026-08-11 12:12:28'),
(447, 1, 'send_attachment', 1, 106, NULL, '{\"storage_attachment_id\":2714,\"kind\":\"voice\",\"sha256\":\"cb1d8980229345f533233ed70a7032c2dd25a2d873788ce58f67acfed9d507e8\"}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', '2026-08-17 14:00:52');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_members`
--
DROP TABLE IF EXISTS `gooyaacc_chat_members`;
CREATE TABLE `gooyaacc_chat_members` (
`id` int(11) NOT NULL,
`room_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`member_role` enum('member','operator','owner') NOT NULL DEFAULT 'member',
`last_read_message_id` int(11) NOT NULL DEFAULT 0,
`unread_count` int(11) NOT NULL DEFAULT 0,
`is_muted` tinyint(1) NOT NULL DEFAULT 0,
`is_pinned` tinyint(1) NOT NULL DEFAULT 0,
`joined_at` datetime DEFAULT NULL,
`left_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_members`
--
INSERT IGNORE INTO `gooyaacc_chat_members` (`id`, `room_id`, `user_id`, `member_role`, `last_read_message_id`, `unread_count`, `is_muted`, `is_pinned`, `joined_at`, `left_at`) VALUES
(1, 1, 1, 'operator', 106, 0, 0, 0, '2026-08-10 14:10:15', NULL),
(2, 2, 1, 'operator', 0, 0, 0, 0, '2026-08-10 14:10:15', NULL),
(12, 1, 24, 'operator', 0, 0, 0, 0, '2026-08-10 14:29:39', '2026-08-10 14:46:50'),
(13, 2, 24, 'operator', 0, 0, 0, 0, '2026-08-10 14:29:39', '2026-08-10 14:46:50'),
(546, 1, 2, 'member', 0, 5, 0, 0, '2026-08-11 11:26:34', NULL),
(547, 2, 2, 'member', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL),
(549, 108, 2, 'owner', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL),
(551, 1, 3, 'member', 0, 5, 0, 0, '2026-08-11 11:26:34', NULL),
(552, 2, 3, 'member', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL),
(554, 109, 3, 'owner', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL),
(556, 1, 4, 'member', 0, 5, 0, 0, '2026-08-11 11:26:34', NULL),
(557, 2, 4, 'member', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL),
(559, 110, 4, 'owner', 0, 0, 0, 0, '2026-08-11 11:26:34', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_messages`
--
DROP TABLE IF EXISTS `gooyaacc_chat_messages`;
CREATE TABLE `gooyaacc_chat_messages` (
`id` int(11) NOT NULL,
`room_id` int(11) NOT NULL,
`sender_id` int(11) NOT NULL,
`msg_type` enum('text','file','image','voice','system') NOT NULL DEFAULT 'text',
`body` text DEFAULT NULL,
`reply_to_id` int(11) DEFAULT NULL,
`client_uid` varchar(40) DEFAULT NULL,
`is_edited` tinyint(1) NOT NULL DEFAULT 0,
`edited_at` datetime DEFAULT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`deleted_by` int(11) DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_messages`
--
INSERT IGNORE INTO `gooyaacc_chat_messages` (`id`, `room_id`, `sender_id`, `msg_type`, `body`, `reply_to_id`, `client_uid`, `is_edited`, `edited_at`, `deleted`, `deleted_by`, `deleted_at`, `created_at`) VALUES
(100, 1, 1, 'text', 'سلام', NULL, 'b9e583e4f5b244d49b0ff0bae7ec1fc3', 0, NULL, 0, NULL, NULL, '2026-08-11 12:10:07'),
(101, 1, 1, 'text', 'سیسیس', 100, '72e34a1d6d9849da9baf02e5b5f53734', 0, NULL, 0, NULL, NULL, '2026-08-11 12:11:05'),
(102, 1, 1, 'voice', 'voice-1786437748206.webm', NULL, '49e3a412659747fd9b903d73cdaae496', 0, NULL, 0, NULL, NULL, '2026-08-11 12:12:28'),
(105, 1, 1, 'text', 'cvcvcvcvc', NULL, '031d30d9ed604e088e35cbcafabc36ff', 0, NULL, 0, NULL, NULL, '2026-08-17 13:59:57'),
(106, 1, 1, 'voice', 'voice-1786962651679.webm', NULL, 'dd8d88da1c324aae987d674114cf1037', 0, NULL, 0, NULL, NULL, '2026-08-17 14:00:52');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_receipts`
--
DROP TABLE IF EXISTS `gooyaacc_chat_receipts`;
CREATE TABLE `gooyaacc_chat_receipts` (
`message_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`delivered_at` datetime DEFAULT NULL,
`read_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_receipts`
--
INSERT IGNORE INTO `gooyaacc_chat_receipts` (`message_id`, `user_id`, `delivered_at`, `read_at`) VALUES
(100, 2, NULL, NULL),
(100, 3, NULL, NULL),
(100, 4, NULL, NULL),
(101, 2, NULL, NULL),
(101, 3, NULL, NULL),
(101, 4, NULL, NULL),
(102, 2, NULL, NULL),
(102, 3, NULL, NULL),
(102, 4, NULL, NULL),
(105, 2, NULL, NULL),
(105, 3, NULL, NULL),
(105, 4, NULL, NULL),
(106, 2, NULL, NULL),
(106, 3, NULL, NULL),
(106, 4, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_rooms`
--
DROP TABLE IF EXISTS `gooyaacc_chat_rooms`;
CREATE TABLE `gooyaacc_chat_rooms` (
`id` int(11) NOT NULL,
`room_type` enum('public','support','direct') NOT NULL,
`title` varchar(200) DEFAULT NULL,
`slug` varchar(100) DEFAULT NULL,
`description` varchar(500) DEFAULT NULL,
`owner_user_id` int(11) DEFAULT NULL,
`dm_key` varchar(40) DEFAULT NULL,
`is_readonly` tinyint(1) NOT NULL DEFAULT 0,
`status` enum('open','closed') NOT NULL DEFAULT 'open',
`assigned_op_id` int(11) DEFAULT NULL,
`is_archived` tinyint(1) NOT NULL DEFAULT 0,
`last_message_id` int(11) DEFAULT NULL,
`last_message_at` datetime DEFAULT NULL,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`created_by` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_rooms`
--
INSERT IGNORE INTO `gooyaacc_chat_rooms` (`id`, `room_type`, `title`, `slug`, `description`, `owner_user_id`, `dm_key`, `is_readonly`, `status`, `assigned_op_id`, `is_archived`, `last_message_id`, `last_message_at`, `deleted`, `created_by`, `created_at`) VALUES
(1, 'public', 'گفتگوی عمومی', 'general', 'کانال عمومی همهٔ همکاران', NULL, NULL, 0, 'open', NULL, 0, 106, '2026-08-17 14:00:52', 0, 1, '2026-08-10 14:10:15'),
(2, 'public', 'اطلاعیهها', 'announcements', 'اطلاعیههای مدیریت — فقط خواندنی', NULL, NULL, 1, 'open', NULL, 0, NULL, NULL, 0, 1, '2026-08-10 14:10:15');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_settings`
--
DROP TABLE IF EXISTS `gooyaacc_chat_settings`;
CREATE TABLE `gooyaacc_chat_settings` (
`skey` varchar(64) NOT NULL,
`svalue` text DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_settings`
--
INSERT IGNORE INTO `gooyaacc_chat_settings` (`skey`, `svalue`, `updated_at`) VALUES
('allow_direct_chat', '1', '2026-08-11 09:21:41'),
('allowed_ext', 'jpg,jpeg,png,gif,webp,pdf,doc,docx,xls,xlsx,ppt,pptx,csv,zip', '2026-08-10 14:10:15'),
('archive_after_months', '6', '2026-08-11 09:21:41'),
('archive_chunk_size', '5000', '2026-08-10 14:10:15'),
('archive_cloud_folder_name', 'آرشیو چتهای گویا', '2026-08-10 14:10:15'),
('archive_cloud_format', 'zip-jsonl-v1', '2026-08-10 14:10:15'),
('archive_cloud_owner_user_id', '0', '2026-08-10 14:10:15'),
('archive_cloud_public_links', '0', '2026-08-11 09:21:41'),
('archive_hour', '2', '2026-08-11 09:21:41'),
('archive_mode', 'auto', '2026-08-11 09:21:41'),
('archive_package_encryption_required', '1', '2026-08-11 09:21:41'),
('archive_to_gooya_cloud', '1', '2026-08-11 09:21:41'),
('chat_globally_enabled', '1', '2026-08-11 11:26:34'),
('edit_window_seconds', '300', '2026-08-10 14:10:15'),
('max_file_size', '10485760', '2026-08-11 09:21:41'),
('poll_idle_ms', '20000', '2026-08-10 14:10:15'),
('poll_interval_ms', '4000', '2026-08-10 14:10:15'),
('rate_messages_per_min', '30', '2026-08-10 14:10:15'),
('rate_uploads_per_min', '10', '2026-08-10 14:10:15'),
('retain_attachments_on_archive', '1', '2026-08-11 09:21:41'),
('schema_version', '2.0-contract', '2026-08-10 14:10:15'),
('storage_gateway', 'GooyaStorage', '2026-08-11 09:21:41'),
('storage_source_module', 'GooyaChat', '2026-08-10 14:10:15'),
('typing_1', '{\"room_id\":0,\"typing\":0,\"at\":1786962596}', '2026-08-17 13:59:56'),
('user_sync_ttl_minutes', '60', '2026-08-10 14:10:15'),
('voice_ext', 'webm,ogg,oga,m4a,mp3,wav', '2026-08-10 14:10:15'),
('voice_max_seconds', '120', '2026-08-10 14:10:15'),
('voice_max_size', '5242880', '2026-08-10 14:10:15');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_chat_users`
--
DROP TABLE IF EXISTS `gooyaacc_chat_users`;
CREATE TABLE `gooyaacc_chat_users` (
`user_id` int(11) NOT NULL,
`user_name` varchar(100) DEFAULT NULL,
`first_name` varchar(100) DEFAULT NULL,
`last_name` varchar(100) DEFAULT NULL,
`full_name` varchar(220) DEFAULT NULL,
`email` varchar(180) DEFAULT NULL,
`is_crm_admin` tinyint(1) NOT NULL DEFAULT 0,
`crm_status` varchar(25) DEFAULT NULL,
`crm_deleted` tinyint(1) NOT NULL DEFAULT 0,
`synced_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_chat_users`
--
INSERT IGNORE INTO `gooyaacc_chat_users` (`user_id`, `user_name`, `first_name`, `last_name`, `full_name`, `email`, `is_crm_admin`, `crm_status`, `crm_deleted`, `synced_at`) VALUES
(1, 'admin', 'فرهاد', 'داداشی', 'فرهاد داداشی', '', 1, 'Active', 0, '2026-08-25 09:46:59'),
(2, 'ali', 'خانم', 'حسنی', 'خانم حسنی', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(3, 'sara', 'خانم', 'رمضانپور', 'خانم رمضانپور', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(4, 'reza', 'خانم', 'تقی پور', 'خانم تقی پور', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(5, 'a.zare', 'خانم', 'رامی', 'خانم رامی', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(6, 'kpiseed_mgr', 'خانم', 'سعادتی', 'خانم سعادتی', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(7, 'kpiseed_sup1', 'خانم', 'صادق نیا', 'خانم صادق نیا', '', 0, 'Active', 0, '2026-08-25 09:46:59'),
(8, 'kpiseed_emp1', 'نیما', 'قاسمی', 'نیما قاسمی', 'kpiseed_emp1@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(9, 'kpiseed_emp2', 'زهرا', 'مرادی', 'زهرا مرادی', 'kpiseed_emp2@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(10, 'kpiseed_emp3', 'امیر', 'صادقی', 'امیر صادقی', 'kpiseed_emp3@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(11, 'kpiseed_sup2', 'سارا', 'احمدی', 'سارا احمدی', 'kpiseed_sup2@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(12, 'kpiseed_emp4', 'فاطمه', 'کاظمی', 'فاطمه کاظمی', 'kpiseed_emp4@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(13, 'kpiseed_emp5', 'سینا', 'یوسفی', 'سینا یوسفی', 'kpiseed_emp5@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(14, 'kpiseed_emp6', 'الهام', 'جعفری', 'الهام جعفری', 'kpiseed_emp6@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(15, 'kpiseed_sup3', 'حسن', 'رضایی', 'حسن رضایی', 'kpiseed_sup3@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(16, 'kpiseed_emp7', 'بهرام', 'اکبری', 'بهرام اکبری', 'kpiseed_emp7@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(17, 'kpiseed_emp8', 'نگار', 'شریفی', 'نگار شریفی', 'kpiseed_emp8@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(18, 'kpiseed_emp9', 'پیمان', 'بابایی', 'پیمان بابایی', 'kpiseed_emp9@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(19, 'kpiseed_sup4', 'مریم', 'حسینی', 'مریم حسینی', 'kpiseed_sup4@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(20, 'kpiseed_emp10', 'مینا', 'رستمی', 'مینا رستمی', 'kpiseed_emp10@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(21, 'kpiseed_emp11', 'کیان', 'عباسی', 'کیان عباسی', 'kpiseed_emp11@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(22, 'kpiseed_emp12', 'رها', 'نادری', 'رها نادری', 'kpiseed_emp12@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(23, 'kpiseed_sup5', 'کاوه', 'نوری', 'کاوه نوری', 'kpiseed_sup5@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(24, 'kpiseed_emp13', 'آرش', 'فلاحی', 'آرش فلاحی', 'kpiseed_emp13@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(25, 'kpiseed_emp14', 'سحر', 'زارع', 'سحر زارع', 'kpiseed_emp14@example.local', 0, 'Active', 0, '2026-08-25 09:46:59'),
(26, 'kpiseed_emp15', 'وحید', 'محمودی', 'وحید محمودی', 'kpiseed_emp15@example.local', 0, 'Active', 0, '2026-08-25 09:46:59');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `gooyaacc_chat_access`
--
ALTER TABLE `gooyaacc_chat_access`
ADD PRIMARY KEY (`user_id`),
ADD KEY `idx_enabled` (`is_enabled`),
ADD KEY `idx_role` (`chat_role`);
--
-- Indexes for table `gooyaacc_chat_archive_attachments`
--
ALTER TABLE `gooyaacc_chat_archive_attachments`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_archive_storage_attachment` (`storage_attachment_id`),
ADD KEY `idx_run` (`archive_run_id`),
ADD KEY `idx_msg` (`message_id`),
ADD KEY `idx_room` (`room_id`),
ADD KEY `idx_storage_status` (`storage_status`);
--
-- Indexes for table `gooyaacc_chat_archive_messages`
--
ALTER TABLE `gooyaacc_chat_archive_messages`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_run` (`archive_run_id`),
ADD KEY `idx_room` (`room_id`,`id`),
ADD KEY `idx_created` (`created_at`),
ADD KEY `idx_sender` (`sender_id`);
--
-- Indexes for table `gooyaacc_chat_archive_runs`
--
ALTER TABLE `gooyaacc_chat_archive_runs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_cloud_file` (`cloud_file_id`),
ADD KEY `idx_status` (`status`),
ADD KEY `idx_cutoff` (`cutoff_date`),
ADD KEY `idx_cloud_export` (`cloud_export_status`);
--
-- Indexes for table `gooyaacc_chat_attachments`
--
ALTER TABLE `gooyaacc_chat_attachments`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_storage_attachment` (`storage_attachment_id`),
ADD KEY `idx_msg` (`message_id`),
ADD KEY `idx_room` (`room_id`),
ADD KEY `idx_kind` (`kind`),
ADD KEY `idx_storage_status` (`storage_status`);
--
-- Indexes for table `gooyaacc_chat_log`
--
ALTER TABLE `gooyaacc_chat_log`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_actor` (`actor_id`),
ADD KEY `idx_action` (`action`),
ADD KEY `idx_created` (`created_at`);
--
-- Indexes for table `gooyaacc_chat_members`
--
ALTER TABLE `gooyaacc_chat_members`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_room_user` (`room_id`,`user_id`),
ADD KEY `idx_user` (`user_id`),
ADD KEY `idx_unread` (`user_id`,`unread_count`);
--
-- Indexes for table `gooyaacc_chat_messages`
--
ALTER TABLE `gooyaacc_chat_messages`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_client` (`room_id`,`client_uid`),
ADD KEY `idx_room_id` (`room_id`,`id`),
ADD KEY `idx_created` (`created_at`),
ADD KEY `idx_sender` (`sender_id`);
--
-- Indexes for table `gooyaacc_chat_receipts`
--
ALTER TABLE `gooyaacc_chat_receipts`
ADD PRIMARY KEY (`message_id`,`user_id`),
ADD KEY `idx_user` (`user_id`);
--
-- Indexes for table `gooyaacc_chat_rooms`
--
ALTER TABLE `gooyaacc_chat_rooms`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_slug` (`slug`),
ADD UNIQUE KEY `uq_dm` (`dm_key`),
ADD KEY `idx_type` (`room_type`),
ADD KEY `idx_owner` (`owner_user_id`),
ADD KEY `idx_last` (`last_message_at`),
ADD KEY `idx_arch` (`is_archived`);
--
-- Indexes for table `gooyaacc_chat_settings`
--
ALTER TABLE `gooyaacc_chat_settings`
ADD PRIMARY KEY (`skey`);
--
-- Indexes for table `gooyaacc_chat_users`
--
ALTER TABLE `gooyaacc_chat_users`
ADD PRIMARY KEY (`user_id`),
ADD KEY `idx_active` (`crm_deleted`,`crm_status`),
ADD KEY `idx_admin` (`is_crm_admin`),
ADD KEY `idx_name` (`full_name`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `gooyaacc_chat_archive_runs`
--
ALTER TABLE `gooyaacc_chat_archive_runs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `gooyaacc_chat_attachments`
--
ALTER TABLE `gooyaacc_chat_attachments`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `gooyaacc_chat_log`
--
ALTER TABLE `gooyaacc_chat_log`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=448;
--
-- AUTO_INCREMENT for table `gooyaacc_chat_members`
--
ALTER TABLE `gooyaacc_chat_members`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=881;
--
-- AUTO_INCREMENT for table `gooyaacc_chat_messages`
--
ALTER TABLE `gooyaacc_chat_messages`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;
--
-- AUTO_INCREMENT for table `gooyaacc_chat_rooms`
--
ALTER TABLE `gooyaacc_chat_rooms`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;
--
-- Database: `gooyanegar`
--
DROP DATABASE IF EXISTS `gooyanegar`;
CREATE DATABASE IF NOT EXISTS `gooyanegar` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_persian_ci;
USE `gooyanegar`;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_access`
--
DROP TABLE IF EXISTS `gooyaacc_negar_access`;
CREATE TABLE `gooyaacc_negar_access` (
`user_id` int(11) NOT NULL,
`is_enabled` tinyint(1) NOT NULL DEFAULT 0,
`access_role` enum('user','secretary','manager','admin') NOT NULL DEFAULT 'user',
`view_scope` enum('own','org_unit','assigned','all') NOT NULL DEFAULT 'own',
`can_create` tinyint(1) NOT NULL DEFAULT 1,
`can_send` tinyint(1) NOT NULL DEFAULT 0,
`can_register` tinyint(1) NOT NULL DEFAULT 0,
`can_approve` tinyint(1) NOT NULL DEFAULT 0,
`can_sign` tinyint(1) NOT NULL DEFAULT 0,
`can_manage_templates` tinyint(1) NOT NULL DEFAULT 0,
`can_view_confidential` tinyint(1) NOT NULL DEFAULT 0,
`can_use_ai` tinyint(1) NOT NULL DEFAULT 0,
`can_export` tinyint(1) NOT NULL DEFAULT 0,
`can_manage_archive` tinyint(1) NOT NULL DEFAULT 0,
`can_purge` tinyint(1) NOT NULL DEFAULT 0,
`can_view_audit` tinyint(1) NOT NULL DEFAULT 0,
`can_manage_users` tinyint(1) NOT NULL DEFAULT 0,
`max_file_size_bytes` bigint(20) UNSIGNED DEFAULT NULL,
`enabled_by` int(11) DEFAULT NULL,
`enabled_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`temporary_substitute_user_id` int(11) DEFAULT NULL,
`temporary_substitute_from` datetime DEFAULT NULL,
`temporary_substitute_until` datetime DEFAULT NULL,
`temporary_substitute_set_by` int(11) DEFAULT NULL,
`temporary_substitute_reason` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_access`
--
INSERT IGNORE INTO `gooyaacc_negar_access` (`user_id`, `is_enabled`, `access_role`, `view_scope`, `can_create`, `can_send`, `can_register`, `can_approve`, `can_sign`, `can_manage_templates`, `can_view_confidential`, `can_use_ai`, `can_export`, `can_manage_archive`, `can_purge`, `can_view_audit`, `can_manage_users`, `max_file_size_bytes`, `enabled_by`, `enabled_at`, `updated_at`, `temporary_substitute_user_id`, `temporary_substitute_from`, `temporary_substitute_until`, `temporary_substitute_set_by`, `temporary_substitute_reason`) VALUES
(1, 1, 'admin', 'all', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, '2026-08-15 10:57:24', '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(2, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(3, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(4, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(5, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(6, 1, 'manager', 'own', 1, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, NULL, 1, '2026-08-15 10:57:24', '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(7, 1, 'user', 'own', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 1, '2026-08-15 10:57:24', '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(8, 1, 'user', 'own', 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 1, '2026-08-15 10:57:24', '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(9, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(10, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(11, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(12, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(13, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(14, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(15, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(16, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(17, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(18, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(19, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(20, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(21, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(22, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(23, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(24, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(25, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL),
(26, 0, 'user', 'own', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '2026-08-25 09:48:21', NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_ai_audit`
--
DROP TABLE IF EXISTS `gooyaacc_negar_ai_audit`;
CREATE TABLE `gooyaacc_negar_ai_audit` (
`id` bigint(20) UNSIGNED NOT NULL,
`request_uuid` char(36) NOT NULL,
`letter_id` bigint(20) UNSIGNED DEFAULT NULL,
`version_id` bigint(20) UNSIGNED DEFAULT NULL,
`user_id` int(11) NOT NULL,
`operation` enum('draft','rewrite','grammar','shorten','expand','subject','summary','action_extract','reply') NOT NULL,
`provider_name` varchar(100) DEFAULT NULL,
`model_name` varchar(120) DEFAULT NULL,
`data_policy` enum('internal','external_allowed','blocked_confidential') NOT NULL DEFAULT 'internal',
`prompt_sha256` char(64) DEFAULT NULL,
`input_sha256` char(64) DEFAULT NULL,
`output_sha256` char(64) DEFAULT NULL,
`input_tokens` int(10) UNSIGNED NOT NULL DEFAULT 0,
`output_tokens` int(10) UNSIGNED NOT NULL DEFAULT 0,
`request_status` enum('pending','completed','failed','blocked','cancelled') NOT NULL DEFAULT 'pending',
`error_code` varchar(80) DEFAULT NULL,
`error_message` varchar(500) DEFAULT NULL,
`created_at` datetime NOT NULL,
`finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_archive_runs`
--
DROP TABLE IF EXISTS `gooyaacc_negar_archive_runs`;
CREATE TABLE `gooyaacc_negar_archive_runs` (
`id` bigint(20) UNSIGNED NOT NULL,
`idempotency_key` varchar(120) NOT NULL,
`operation` enum('archive','export','backup','restore_drill','purge') NOT NULL DEFAULT 'archive',
`run_mode` enum('manual','cron') NOT NULL DEFAULT 'manual',
`cutoff_date` date DEFAULT NULL,
`retention_months` smallint(5) UNSIGNED DEFAULT NULL,
`letters_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`attachments_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`bytes_total` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`run_status` enum('pending','running','completed','failed','rolled_back') NOT NULL DEFAULT 'pending',
`cloud_export_status` enum('disabled','pending','exporting','ready','failed') NOT NULL DEFAULT 'disabled',
`cloud_file_id` bigint(20) UNSIGNED DEFAULT NULL,
`cloud_attachment_id` bigint(20) UNSIGNED DEFAULT NULL,
`cloud_sha256` char(64) DEFAULT NULL,
`manifest_sha256` char(64) DEFAULT NULL,
`encryption_key_id` varchar(120) DEFAULT NULL,
`cloud_exported_at` datetime DEFAULT NULL,
`verified_at` datetime DEFAULT NULL,
`restore_drill_at` datetime DEFAULT NULL,
`error_message` text DEFAULT NULL,
`run_by` int(11) DEFAULT NULL,
`started_at` datetime DEFAULT NULL,
`finished_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_attachments`
--
DROP TABLE IF EXISTS `gooyaacc_negar_attachments`;
CREATE TABLE `gooyaacc_negar_attachments` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED DEFAULT NULL,
`version_id` bigint(20) UNSIGNED DEFAULT NULL,
`attachment_kind` enum('attachment','draft_pdf','final_pdf','letterhead') NOT NULL DEFAULT 'attachment',
`storage_attachment_id` bigint(20) UNSIGNED DEFAULT NULL,
`display_name` varchar(255) NOT NULL,
`extension` varchar(16) DEFAULT NULL,
`mime_type` varchar(150) DEFAULT NULL,
`size_bytes` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`checksum_sha256` char(64) DEFAULT NULL,
`visibility` enum('all_recipients','primary_only','internal_only') NOT NULL DEFAULT 'all_recipients',
`storage_status` enum('pending','ready','quarantined','deleted','failed') NOT NULL DEFAULT 'pending',
`purge_status` enum('none','pending','purged','failed') NOT NULL DEFAULT 'none',
`created_by` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`deleted_by` int(11) DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_attachments`
--
INSERT IGNORE INTO `gooyaacc_negar_attachments` (`id`, `letter_id`, `version_id`, `attachment_kind`, `storage_attachment_id`, `display_name`, `extension`, `mime_type`, `size_bytes`, `checksum_sha256`, `visibility`, `storage_status`, `purge_status`, `created_by`, `created_at`, `deleted_by`, `deleted_at`) VALUES
(74, 102, 111, 'final_pdf', 2700, 'official-GNT-1405-000001.pdf', 'pdf', 'application/pdf', 129557, '3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22', 'all_recipients', 'ready', 'none', 6, '2026-08-15 10:57:25', NULL, NULL),
(75, 102, 111, 'final_pdf', 2701, 'registry-GNT-1405-000001.pdf', 'pdf', 'application/pdf', 130709, 'da73b4ad8f4b5b13f14565c07d59a4c75db43e6b1cc290436f8406ee4553d4c2', 'internal_only', 'ready', 'none', 6, '2026-08-15 10:57:25', NULL, NULL),
(76, 103, 112, 'final_pdf', 2702, 'official-GNT-1405-000002.pdf', 'pdf', 'application/pdf', 128980, '3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef', 'all_recipients', 'ready', 'none', 6, '2026-08-15 10:57:26', NULL, NULL),
(77, 103, 112, 'final_pdf', 2703, 'registry-GNT-1405-000002.pdf', 'pdf', 'application/pdf', 129776, 'b9708296490b6487bf83c2163880061dc69d11b74197ca3b1409fb78adfc462e', 'internal_only', 'ready', 'none', 6, '2026-08-15 10:57:26', NULL, NULL),
(78, 104, 113, 'attachment', 2704, 'پیوست-آزمایشی-گویانگار.txt', 'txt', 'text/plain', 80, 'd850c79103b2fb0dffc3b1512e0bae1e5e5acd17a6d2a05248f5c774ea64ddf8', 'all_recipients', 'ready', 'none', 1, '2026-08-15 10:57:26', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_audit_log`
--
DROP TABLE IF EXISTS `gooyaacc_negar_audit_log`;
CREATE TABLE `gooyaacc_negar_audit_log` (
`id` bigint(20) UNSIGNED NOT NULL,
`event_uuid` char(36) NOT NULL,
`actor_user_id` int(11) DEFAULT NULL,
`action` varchar(100) NOT NULL,
`outcome` enum('success','denied','failed') NOT NULL DEFAULT 'success',
`letter_id` bigint(20) UNSIGNED DEFAULT NULL,
`version_id` bigint(20) UNSIGNED DEFAULT NULL,
`recipient_id` bigint(20) UNSIGNED DEFAULT NULL,
`referral_id` bigint(20) UNSIGNED DEFAULT NULL,
`target_user_id` int(11) DEFAULT NULL,
`request_id` varchar(100) DEFAULT NULL,
`ip_address` varchar(45) DEFAULT NULL,
`user_agent_sha256` char(64) DEFAULT NULL,
`detail_json` mediumtext DEFAULT NULL,
`previous_hash` char(64) DEFAULT NULL,
`event_hash` char(64) NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_audit_log`
--
INSERT IGNORE INTO `gooyaacc_negar_audit_log` (`id`, `event_uuid`, `actor_user_id`, `action`, `outcome`, `letter_id`, `version_id`, `recipient_id`, `referral_id`, `target_user_id`, `request_id`, `ip_address`, `user_agent_sha256`, `detail_json`, `previous_hash`, `event_hash`, `created_at`) VALUES
(686, '8ef5401d-2341-4b88-87e0-0b91e4c7f4c7', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '8ef5401d-2341-4b88-87e0-0b91e4c7f4c7', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', '0000000000000000000000000000000000000000000000000000000000000000', '0f07948e60c444a0042b8f1b1c3e829287998440445ca8395176a055d062b5c5', '2026-08-15 06:14:43'),
(687, 'f81907fa-bb29-4e02-94cb-2c3da7c3ac71', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, 'f81907fa-bb29-4e02-94cb-2c3da7c3ac71', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', '0f07948e60c444a0042b8f1b1c3e829287998440445ca8395176a055d062b5c5', 'e57573113e7a5523dd90f4f7dfdcccd8d93bc38946a00d93b729f76ca452d347', '2026-08-15 06:25:58'),
(695, '74867044-1e5f-4b21-94e0-b4747d4e8d70', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '74867044-1e5f-4b21-94e0-b4747d4e8d70', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', 'e57573113e7a5523dd90f4f7dfdcccd8d93bc38946a00d93b729f76ca452d347', '8408e66e2f778225a96a571b2888d48627383a2cea16ae6f33285ea8d583cbc4', '2026-08-15 06:30:14'),
(696, '08be3278-6e02-4cff-b641-8e32d89fccc9', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '08be3278-6e02-4cff-b641-8e32d89fccc9', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', '8408e66e2f778225a96a571b2888d48627383a2cea16ae6f33285ea8d583cbc4', '06965ac08e0832cb57b4aa6fc76b4eb8c07ae240b35ccb76b3ee63a40ac190d7', '2026-08-15 06:31:27'),
(697, '04de62c4-292e-4778-afa7-ff45c9d8b191', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '04de62c4-292e-4778-afa7-ff45c9d8b191', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"create\",\"reason\":\"module_disabled\"}', '06965ac08e0832cb57b4aa6fc76b4eb8c07ae240b35ccb76b3ee63a40ac190d7', '20be1e8d4b1a06aae5cb17880f029502717454be612f9923aebf0a9b48ed6fa7', '2026-08-15 06:31:31'),
(698, '593eca93-e72d-4b73-9c67-a09d9231da5d', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '593eca93-e72d-4b73-9c67-a09d9231da5d', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', '20be1e8d4b1a06aae5cb17880f029502717454be612f9923aebf0a9b48ed6fa7', '15596b55cb25296098bf60a305460f90956be14f09478e2992469659b4a75686', '2026-08-15 06:43:05'),
(699, '0f2a57f7-b75e-4b9a-8e06-a65c71eed6f7', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '0f2a57f7-b75e-4b9a-8e06-a65c71eed6f7', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"create\",\"reason\":\"module_disabled\"}', '15596b55cb25296098bf60a305460f90956be14f09478e2992469659b4a75686', 'f2e4eb58ba7eb7ddc27241f67535862ee331af6f34c838a13a5537bd259cfde4', '2026-08-15 06:43:07'),
(700, 'bdad0654-69c5-4df3-90a4-1b29ce2d45a8', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, 'bdad0654-69c5-4df3-90a4-1b29ce2d45a8', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', 'f2e4eb58ba7eb7ddc27241f67535862ee331af6f34c838a13a5537bd259cfde4', '50e0fcddf4949187df450e7df8135063a8a139e6f509bc8f3cd9c3d111f684b1', '2026-08-15 06:48:52'),
(863, '1c9e2bdf-ee72-4667-bdb6-79e82c9d7d1e', 1, 'access_denied', 'denied', NULL, NULL, NULL, NULL, NULL, '1c9e2bdf-ee72-4667-bdb6-79e82c9d7d1e', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capability\":\"view\",\"reason\":\"module_disabled\"}', '50e0fcddf4949187df450e7df8135063a8a139e6f509bc8f3cd9c3d111f684b1', 'ccb1cecbdd41de86ae951761e60aa0f19e02f33d787ae80bf2cd01bc0fcb6212', '2026-08-15 07:18:08'),
(864, '12411d2b-1b79-43ca-bb78-bd206d54dd5e', 6, 'signature_register', 'success', NULL, NULL, NULL, NULL, 6, '12411d2b-1b79-43ca-bb78-bd206d54dd5e', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"auth_method\":\"password\",\"checksum_sha256\":\"9cf6793740d9b53764b0393e1db65f3e33440408ba1a72455c0d5e9712640779\",\"storage_attachment_id\":2699,\"version_no\":1}', 'ccb1cecbdd41de86ae951761e60aa0f19e02f33d787ae80bf2cd01bc0fcb6212', '8e0e056b2bb7362c7e2957840bb372a6a086e2581f6b9accf52eb66db76aec60', '2026-08-15 07:27:24'),
(865, '5ae5e690-c4cf-4161-bc5c-60cb253fd73f', 1, 'draft_created', 'success', 102, 111, NULL, NULL, NULL, '5ae5e690-c4cf-4161-bc5c-60cb253fd73f', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"content_sha256\":\"bf28d4f286e51b984fe0fddf6c7210ad3b72386d7cc2462b52c8e2907b00dab9\",\"link_count\":0,\"recipient_count\":3,\"row_version\":1,\"save_reason\":\"manual\"}', '8e0e056b2bb7362c7e2957840bb372a6a086e2581f6b9accf52eb66db76aec60', '523e0af5283e0ac598757a017e336ebf55da1eae39a7e2c011909a768c8928f6', '2026-08-15 07:27:25'),
(866, 'e770b98b-0895-44d2-8f9a-395396d467f1', 1, 'workflow_review_requested', 'success', 102, 111, NULL, NULL, 1, 'e770b98b-0895-44d2-8f9a-395396d467f1', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"due_at\":null,\"step_id\":150}', '523e0af5283e0ac598757a017e336ebf55da1eae39a7e2c011909a768c8928f6', 'ea0aa975d3002ea72b3cf150256b21e7507369fa3b354f0a196a9923d348e659', '2026-08-15 07:27:25'),
(867, '9599fe1d-c4db-446e-a4c2-490accdd34dc', 1, 'workflow_review_approved', 'success', 102, 111, NULL, NULL, 1, '9599fe1d-c4db-446e-a4c2-490accdd34dc', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"next_step_id\":151,\"note\":\"\",\"principal_user_id\":1}', 'ea0aa975d3002ea72b3cf150256b21e7507369fa3b354f0a196a9923d348e659', '0c87f0858ddc572bbc706eaa65b237e2467bdf4adc5b8f4cf72ade38428ac26f', '2026-08-15 07:27:25'),
(868, '2430a37f-2569-4713-9c71-82b5f8f4f09a', 1, 'workflow_approved', 'success', 102, 111, NULL, NULL, 1, '2430a37f-2569-4713-9c71-82b5f8f4f09a', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"note\":\"\",\"principal_user_id\":1}', '0c87f0858ddc572bbc706eaa65b237e2467bdf4adc5b8f4cf72ade38428ac26f', '463f95979031a46fbcdf5dee313e2d6e3599e21a9fbb81e4b33b878c51ec06ae', '2026-08-15 07:27:25'),
(869, '92facca2-e789-4a1c-87e1-0cf772830f2b', 1, 'workflow_registration_requested', 'success', 102, NULL, NULL, NULL, 1, '92facca2-e789-4a1c-87e1-0cf772830f2b', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"step_id\":152}', '463f95979031a46fbcdf5dee313e2d6e3599e21a9fbb81e4b33b878c51ec06ae', 'f01a90d1d0da44e54abf2bf21ae10979495112a5c4d85952727cef3255ac228c', '2026-08-15 07:27:25'),
(870, 'c142bc95-8210-4ff1-942a-58511e89dca1', 1, 'letter_registered', 'success', 102, 111, NULL, NULL, 1, 'c142bc95-8210-4ff1-942a-58511e89dca1', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"letter_no\":\"GNT-1405-000001\",\"principal_user_id\":1,\"sequence_id\":24,\"transaction_attempt\":1}', 'f01a90d1d0da44e54abf2bf21ae10979495112a5c4d85952727cef3255ac228c', '1a8e540ff764ba873b0e6627c6ed9edefcb4a8fcfcedd6726348fc5b3addf53e', '2026-08-15 07:27:25'),
(871, '335c7a73-9e5a-4eda-9ee2-45407b24c5a1', 1, 'workflow_signature_requested', 'success', 102, NULL, NULL, NULL, 6, '335c7a73-9e5a-4eda-9ee2-45407b24c5a1', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"step_id\":153}', '1a8e540ff764ba873b0e6627c6ed9edefcb4a8fcfcedd6726348fc5b3addf53e', 'cb6a39c009c38130630ee6d00e1ebebc4b02c3e79d10595ef5239b3bb4bc5362', '2026-08-15 07:27:25'),
(872, '1dfb0df5-d5c6-4e7d-9697-9a9d5aa16a10', 6, 'letter_final_pdf_created', 'success', 102, 111, NULL, NULL, 6, '1dfb0df5-d5c6-4e7d-9697-9a9d5aa16a10', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"blind_copy_count\":1,\"public_attachment_id\":74,\"public_sha256\":\"3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22\",\"public_storage_attachment_id\":2700,\"registry_attachment_id\":75,\"registry_sha256\":\"da73b4ad8f4b5b13f14565c07d59a4c75db43e6b1cc290436f8406ee4553d4c2\",\"renderer\":\"TCPDF 6.10.0\"}', 'cb6a39c009c38130630ee6d00e1ebebc4b02c3e79d10595ef5239b3bb4bc5362', 'a535dff9119576e109504ba7bb7643628b6e551f2aa57ddbfb3fafd4c688c118', '2026-08-15 07:27:25'),
(873, '69841c61-abe0-4acf-90a2-1fa693320a27', 6, 'letter_signed', 'success', 102, 111, NULL, NULL, 6, '69841c61-abe0-4acf-90a2-1fa693320a27', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"acceptance_path\":true,\"auth_method\":\"password\",\"final_pdf_sha256\":\"3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22\",\"signature_checksum\":\"9cf6793740d9b53764b0393e1db65f3e33440408ba1a72455c0d5e9712640779\",\"signature_id\":33}', 'a535dff9119576e109504ba7bb7643628b6e551f2aa57ddbfb3fafd4c688c118', '49c2b8bdeba3657f94ca502ac99c68911a2151dbb9b308f3cd89d1fbfbc764a0', '2026-08-15 07:27:25'),
(874, '7329d898-b12f-41e7-8ca9-d2f863597293', 1, 'letter_sent_final', 'success', 102, 111, NULL, NULL, NULL, '7329d898-b12f-41e7-8ca9-d2f863597293', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"final_pdf_sha256\":\"3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22\",\"letter_no\":\"GNT-1405-000001\",\"sms_copy_enabled\":0,\"sms_queued\":1}', '49c2b8bdeba3657f94ca502ac99c68911a2151dbb9b308f3cd89d1fbfbc764a0', 'dfa8b5a322677a71fc7c018388270a9faac89d9f791255b4d30e79be697e98a2', '2026-08-15 07:27:25'),
(875, '7742ba9d-d9d9-4b94-a3d3-469bc131025b', 6, 'letter_viewed_full', 'success', 102, 111, 140, NULL, 6, '7742ba9d-d9d9-4b94-a3d3-469bc131025b', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"session_fingerprint\":\"d8796e00b03e2a41\",\"session_id_sha256\":\"d8796e00b03e2a418eea2aeee09f9ad66428980d5eec6130c93738aaa7e8156a\"}', 'dfa8b5a322677a71fc7c018388270a9faac89d9f791255b4d30e79be697e98a2', 'e008aa135974ac17a55f0b2a4b338d48040ef29190098bf46d4caa326c342ca1', '2026-08-15 07:27:25'),
(876, '733e9293-eb32-4a85-a906-7f83e7159b16', 6, 'letter_receipt_acknowledged', 'success', 102, NULL, 140, NULL, 6, '733e9293-eb32-4a85-a906-7f83e7159b16', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '[]', 'e008aa135974ac17a55f0b2a4b338d48040ef29190098bf46d4caa326c342ca1', '3991f72ad18190a036ec0b8b8bdf4773bf8f5155ef9bb0ad0be69421d54afa85', '2026-08-15 07:27:25'),
(877, 'a2769b70-faa4-4c47-8d83-a636e6d40851', 1, 'draft_created', 'success', 103, 112, NULL, NULL, NULL, 'a2769b70-faa4-4c47-8d83-a636e6d40851', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"content_sha256\":\"704423af465b20a501252a631dc5f31b34134a1f4898f54f03df803a3ac75002\",\"link_count\":0,\"recipient_count\":3,\"row_version\":1,\"save_reason\":\"manual\"}', '3991f72ad18190a036ec0b8b8bdf4773bf8f5155ef9bb0ad0be69421d54afa85', '82d578332296ac0f7a77ac69409281072e6af76303fdf4e4257d675e9a7eb60d', '2026-08-15 07:27:25'),
(878, '0b6a1b65-12c2-44a5-9b48-6b87d4218fe5', 1, 'workflow_review_requested', 'success', 103, 112, NULL, NULL, 1, '0b6a1b65-12c2-44a5-9b48-6b87d4218fe5', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"due_at\":null,\"step_id\":155}', '82d578332296ac0f7a77ac69409281072e6af76303fdf4e4257d675e9a7eb60d', '6ae6b554b2ee4ab85ee295a09a7f7a8f2bd75dfdd353ac391dc6eea56b248e9c', '2026-08-15 07:27:25'),
(879, 'fbbc8593-da93-4325-b5af-e988f121c7e7', 1, 'workflow_review_approved', 'success', 103, 112, NULL, NULL, 1, 'fbbc8593-da93-4325-b5af-e988f121c7e7', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"next_step_id\":156,\"note\":\"\",\"principal_user_id\":1}', '6ae6b554b2ee4ab85ee295a09a7f7a8f2bd75dfdd353ac391dc6eea56b248e9c', 'c1941b6ebff99ac7726f956a8a976812606f74fa9e5d020fd74ef0fa9fa35a6c', '2026-08-15 07:27:26'),
(880, 'e0a0534a-0452-460b-9105-c79a535e762a', 1, 'workflow_approved', 'success', 103, 112, NULL, NULL, 1, 'e0a0534a-0452-460b-9105-c79a535e762a', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"note\":\"\",\"principal_user_id\":1}', 'c1941b6ebff99ac7726f956a8a976812606f74fa9e5d020fd74ef0fa9fa35a6c', 'cf5bd2e5e565b274428c2064d7ec25caa66426f41cb3f4db4a9ef6bc5415dae1', '2026-08-15 07:27:26'),
(881, '93b169f5-ab8a-4ae0-9d76-b49540a74eed', 1, 'workflow_registration_requested', 'success', 103, NULL, NULL, NULL, 1, '93b169f5-ab8a-4ae0-9d76-b49540a74eed', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"step_id\":157}', 'cf5bd2e5e565b274428c2064d7ec25caa66426f41cb3f4db4a9ef6bc5415dae1', '70666d90eaadd0d7584a747c1e7a23deb6fafbe814da37966b4cc2125bfdf88a', '2026-08-15 07:27:26'),
(882, '86fced0e-571d-4161-ac3b-8062db8000f5', 1, 'letter_registered', 'success', 103, 112, NULL, NULL, 1, '86fced0e-571d-4161-ac3b-8062db8000f5', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"delegated\":false,\"letter_no\":\"GNT-1405-000002\",\"principal_user_id\":1,\"sequence_id\":24,\"transaction_attempt\":1}', '70666d90eaadd0d7584a747c1e7a23deb6fafbe814da37966b4cc2125bfdf88a', '83a5ad71e7976903d5f2721cc2488824c17cfe0c4ec40e4cfa45cc3dd1c9a226', '2026-08-15 07:27:26'),
(883, '70822187-337e-4167-afc2-aaf4d91553b0', 1, 'workflow_signature_requested', 'success', 103, NULL, NULL, NULL, 6, '70822187-337e-4167-afc2-aaf4d91553b0', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"step_id\":158}', '83a5ad71e7976903d5f2721cc2488824c17cfe0c4ec40e4cfa45cc3dd1c9a226', '9ceaca0cac9c00b91a8d37b79050801b0c4840e8b2f320c2950cd01f75a05133', '2026-08-15 07:27:26'),
(884, 'beac2ed8-aa43-4e28-91ab-8912cbd63558', 6, 'letter_final_pdf_created', 'success', 103, 112, NULL, NULL, 6, 'beac2ed8-aa43-4e28-91ab-8912cbd63558', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"blind_copy_count\":1,\"public_attachment_id\":76,\"public_sha256\":\"3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef\",\"public_storage_attachment_id\":2702,\"registry_attachment_id\":77,\"registry_sha256\":\"b9708296490b6487bf83c2163880061dc69d11b74197ca3b1409fb78adfc462e\",\"renderer\":\"TCPDF 6.10.0\"}', '9ceaca0cac9c00b91a8d37b79050801b0c4840e8b2f320c2950cd01f75a05133', 'aaea5529f632568ce05f163ba118bfaf4f431b0897ace41d32660669d23ae82b', '2026-08-15 07:27:26'),
(885, '882ca028-1211-4e40-b85d-a17e72e2be87', 6, 'letter_signed', 'success', 103, 112, NULL, NULL, 6, '882ca028-1211-4e40-b85d-a17e72e2be87', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"acceptance_path\":true,\"auth_method\":\"password\",\"final_pdf_sha256\":\"3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef\",\"signature_checksum\":\"9cf6793740d9b53764b0393e1db65f3e33440408ba1a72455c0d5e9712640779\",\"signature_id\":33}', 'aaea5529f632568ce05f163ba118bfaf4f431b0897ace41d32660669d23ae82b', 'e41795bc692e5026e61d03a2a41af01a7770092b9e48c73ca477d977b2c5e22d', '2026-08-15 07:27:26'),
(886, '21d3e397-bfc3-4877-ae61-528c30f9b805', 1, 'letter_sent_final', 'success', 103, 112, NULL, NULL, NULL, '21d3e397-bfc3-4877-ae61-528c30f9b805', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"final_pdf_sha256\":\"3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef\",\"letter_no\":\"GNT-1405-000002\",\"sms_copy_enabled\":0,\"sms_queued\":0}', 'e41795bc692e5026e61d03a2a41af01a7770092b9e48c73ca477d977b2c5e22d', 'cc76808a2c8afe8c906c2ec90d93555de69265519c5256ca13c94310b9ac87bb', '2026-08-15 07:27:26'),
(887, '3f1f6465-3067-4d03-b594-ddbf49aad400', 1, 'draft_created', 'success', 104, 113, NULL, NULL, NULL, '3f1f6465-3067-4d03-b594-ddbf49aad400', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"content_sha256\":\"0925bd121aaf1efc78122dccbf38c8b344267a4f7123557dd77630058d91977e\",\"link_count\":0,\"recipient_count\":1,\"row_version\":1,\"save_reason\":\"manual\"}', 'cc76808a2c8afe8c906c2ec90d93555de69265519c5256ca13c94310b9ac87bb', '51c1f6c7b6157f1afa943c352a175c988b76dfb6a2d88895a22b5fddb02fbc59', '2026-08-15 07:27:26'),
(888, '4827d6fe-6aa9-49f5-9490-8df76de1ffab', 1, 'draft_attachment_uploaded', 'success', 104, 113, NULL, NULL, NULL, '4827d6fe-6aa9-49f5-9490-8df76de1ffab', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"checksum_sha256\":\"d850c79103b2fb0dffc3b1512e0bae1e5e5acd17a6d2a05248f5c774ea64ddf8\",\"display_name\":\"پیوست-آزمایشی-گویانگار.txt\",\"mime_type\":\"text/plain\",\"size_bytes\":80,\"visibility\":\"all_recipients\"}', '51c1f6c7b6157f1afa943c352a175c988b76dfb6a2d88895a22b5fddb02fbc59', '5765b51e56e0159c687751d75098234cc2c3518a2facb94236090a89f502dfff', '2026-08-15 07:27:27'),
(889, '6f783294-3e6a-4bda-a74a-e30cd8debf0f', 1, 'letter_viewed_full', 'success', 102, 111, NULL, NULL, 1, '6f783294-3e6a-4bda-a74a-e30cd8debf0f', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"session_fingerprint\":\"0cd5592725ff7e80\",\"session_id_sha256\":\"0cd5592725ff7e8024248685bc0635a82da118cbd704d9da7e130dc453bef1e8\"}', '5765b51e56e0159c687751d75098234cc2c3518a2facb94236090a89f502dfff', '374ebc715d39089825f844aed1ec5c196ad62c351462edfceb7c0c3fb06b3b4e', '2026-08-15 07:33:26'),
(890, '4164449a-55ce-46b9-96b8-b7426723908c', 1, 'letter_viewed_full', 'success', 103, 112, NULL, NULL, 1, '4164449a-55ce-46b9-96b8-b7426723908c', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"session_fingerprint\":\"0cd5592725ff7e80\",\"session_id_sha256\":\"0cd5592725ff7e8024248685bc0635a82da118cbd704d9da7e130dc453bef1e8\"}', '374ebc715d39089825f844aed1ec5c196ad62c351462edfceb7c0c3fb06b3b4e', 'ba24076669d4fe67932cc84e980b6574e540df9ac23636f639693f4e90cb99a1', '2026-08-15 07:33:31'),
(891, '35a4e7d8-435d-46d2-8fd5-177f395145a0', 1, 'letter_pdf_accessed', 'success', 103, 112, NULL, NULL, 1, '35a4e7d8-435d-46d2-8fd5-177f395145a0', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"sha256\":\"3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef\",\"variant\":\"official\"}', 'ba24076669d4fe67932cc84e980b6574e540df9ac23636f639693f4e90cb99a1', '54be6f1a91f84ca5cc4f65a8e018617456437dc8d423e539b3118ad3e312e5be', '2026-08-15 07:33:50'),
(892, 'd8825b10-a7d4-49cd-9565-307f555812ba', 1, 'letter_viewed_full', 'success', 102, 111, NULL, NULL, 1, 'd8825b10-a7d4-49cd-9565-307f555812ba', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"session_fingerprint\":\"0cd5592725ff7e80\",\"session_id_sha256\":\"0cd5592725ff7e8024248685bc0635a82da118cbd704d9da7e130dc453bef1e8\"}', '54be6f1a91f84ca5cc4f65a8e018617456437dc8d423e539b3118ad3e312e5be', 'def7fdc549666d38372f28f5fd5b1213a5cb92cbbf4ad06d595cb6b09f334acf', '2026-08-15 07:34:32'),
(893, '460f4e40-0cde-434b-8fb9-d1d221f952d5', 1, 'letter_viewed_full', 'success', 102, 111, NULL, NULL, 1, '460f4e40-0cde-434b-8fb9-d1d221f952d5', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"session_fingerprint\":\"0cd5592725ff7e80\",\"session_id_sha256\":\"0cd5592725ff7e8024248685bc0635a82da118cbd704d9da7e130dc453bef1e8\"}', 'def7fdc549666d38372f28f5fd5b1213a5cb92cbbf4ad06d595cb6b09f334acf', '0166c027b9ace4a58634d6dbe1aa443ac2056883801f4c342333e8facfecb98c', '2026-08-15 07:34:48'),
(894, 'edabd0de-d04d-4a9f-b42c-68215fcfbe9d', 1, 'letter_pdf_accessed', 'success', 102, 111, NULL, NULL, 1, 'edabd0de-d04d-4a9f-b42c-68215fcfbe9d', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"sha256\":\"3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22\",\"variant\":\"official\"}', '0166c027b9ace4a58634d6dbe1aa443ac2056883801f4c342333e8facfecb98c', 'f0acd0e288ffd1ffe23ca3471ccc172e04099a9b804be878f1541df53fea782f', '2026-08-15 07:35:16'),
(895, 'a99dbf5b-bc00-47e6-b9ae-3381a3805290', 1, 'admin_enable_user', 'success', NULL, NULL, NULL, NULL, 1, 'a99dbf5b-bc00-47e6-b9ae-3381a3805290', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"capabilities\":{\"can_approve\":1,\"can_create\":1,\"can_export\":1,\"can_manage_archive\":1,\"can_manage_templates\":1,\"can_manage_users\":1,\"can_purge\":0,\"can_register\":1,\"can_send\":1,\"can_sign\":1,\"can_use_ai\":0,\"can_view_audit\":1,\"can_view_confidential\":1},\"max_file_size_mb\":0,\"role\":\"admin\",\"scope\":\"all\"}', 'f0acd0e288ffd1ffe23ca3471ccc172e04099a9b804be878f1541df53fea782f', '53075dbf979064584cd363f413ea22a5b5f5c66990e6a8a749ca29999ab20778', '2026-08-15 07:37:19'),
(896, '3c5b4977-91c4-4617-820a-e8346d89acbc', 1, 'letter_pdf_accessed', 'success', 102, 111, NULL, NULL, 1, '3c5b4977-91c4-4617-820a-e8346d89acbc', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"sha256\":\"3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22\",\"variant\":\"official\"}', '53075dbf979064584cd363f413ea22a5b5f5c66990e6a8a749ca29999ab20778', '0c69729e4ff0cdd6f02ae9def2ca1d3808b22c7915a7c1ea44b574f69486f0ab', '2026-08-15 07:37:28'),
(922, 'cfaa7120-a305-4d30-b876-90173a1471ad', NULL, 'sms_sent', 'success', 102, NULL, 140, NULL, 6, 'cfaa7120-a305-4d30-b876-90173a1471ad', '', '1b58e7c73ad6e179d8dc924dcec823f8ff4ec0cb80c7453bfcb5a045301515db', '{\"attempt\":1,\"provider_message_id_sha256\":\"75c90caa7fed24b8358206d5ca430bb5a020c0e38b2759eaf1d20843bd73979b\"}', '0c69729e4ff0cdd6f02ae9def2ca1d3808b22c7915a7c1ea44b574f69486f0ab', '95e9eda7150f6ba3f6c26ab13acf241f4294fd97497a32cd0da1f1348468db0d', '2026-08-15 09:54:38'),
(930, '0af6ae82-e1dc-4d0e-ac0f-890ee9cb8e59', 1, 'letter_viewed_full', 'success', 103, 112, NULL, NULL, 1, '0af6ae82-e1dc-4d0e-ac0f-890ee9cb8e59', '::1', '6235d36597d64fc0e0c3883911a8fb2f9451d0254ab3379d980f5a3426585d87', '{\"session_fingerprint\":\"0cd5592725ff7e80\",\"session_id_sha256\":\"0cd5592725ff7e8024248685bc0635a82da118cbd704d9da7e130dc453bef1e8\"}', '95e9eda7150f6ba3f6c26ab13acf241f4294fd97497a32cd0da1f1348468db0d', '55960a471f4514e63f62e4ae29c41c2883acae37abf1c20ac685abb3a44c954a', '2026-08-15 10:12:33'),
(937, 'ea9d229f-ee3c-45ca-9806-de3e78acd3b6', 1, 'identity_password_verify', 'success', NULL, NULL, NULL, NULL, NULL, 'ea9d229f-ee3c-45ca-9806-de3e78acd3b6', '::1', '40956f08f6c9af83802ecd226385c678a06f995e8a19f59cd575a9a4c6acc287', '{\"purpose\":\"manage_signature\"}', '55960a471f4514e63f62e4ae29c41c2883acae37abf1c20ac685abb3a44c954a', 'a3e798fb7c4bd1842c1ddb44058343d701693320fccec90bae2dc8f4ac3132f3', '2026-08-17 10:39:36'),
(938, '6d4003d9-d9bc-4935-98b9-6da24630780f', 1, 'signature_register', 'success', NULL, NULL, NULL, NULL, 1, '6d4003d9-d9bc-4935-98b9-6da24630780f', '::1', '40956f08f6c9af83802ecd226385c678a06f995e8a19f59cd575a9a4c6acc287', '{\"auth_method\":\"password\",\"checksum_sha256\":\"c0d3d67c84871e19ea43668806c39fa6c80f5db5d602f0388704fb51ff97626a\",\"storage_attachment_id\":2716,\"version_no\":1}', 'a3e798fb7c4bd1842c1ddb44058343d701693320fccec90bae2dc8f4ac3132f3', '2708fefc69bd40fc55f91841f3020805396a1ac64f2bacfa72edee0be81bbdf4', '2026-08-17 10:39:37');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_letters`
--
DROP TABLE IF EXISTS `gooyaacc_negar_letters`;
CREATE TABLE `gooyaacc_negar_letters` (
`id` bigint(20) UNSIGNED NOT NULL,
`public_uuid` char(36) NOT NULL,
`direction` enum('internal','incoming','outgoing') NOT NULL DEFAULT 'internal',
`status` enum('draft','pending_review','changes_requested','pending_approval','approved','rejected','pending_registration','registered','pending_signature','signed','sent','closed','archived','cancelled') NOT NULL DEFAULT 'draft',
`confidentiality` enum('normal','confidential','secret') NOT NULL DEFAULT 'normal',
`priority` enum('normal','urgent','immediate') NOT NULL DEFAULT 'normal',
`org_unit_id` int(11) DEFAULT NULL,
`sender_user_id` int(11) NOT NULL,
`sender_name_snapshot` varchar(220) NOT NULL,
`sender_title_snapshot` varchar(180) DEFAULT NULL,
`subject` varchar(500) NOT NULL,
`sequence_id` bigint(20) UNSIGNED DEFAULT NULL,
`letter_year` smallint(5) UNSIGNED DEFAULT NULL,
`letter_no` varchar(100) DEFAULT NULL,
`registered_at` datetime DEFAULT NULL,
`current_version_id` bigint(20) UNSIGNED DEFAULT NULL,
`final_pdf_attachment_id` bigint(20) UNSIGNED DEFAULT NULL,
`final_pdf_sha256` char(64) DEFAULT NULL,
`requires_ack` tinyint(1) NOT NULL DEFAULT 0,
`due_at` datetime DEFAULT NULL,
`signed_at` datetime DEFAULT NULL,
`sent_at` datetime DEFAULT NULL,
`closed_at` datetime DEFAULT NULL,
`archived_at` datetime DEFAULT NULL,
`legal_hold` tinyint(1) NOT NULL DEFAULT 0,
`draft_deleted_at` datetime DEFAULT NULL,
`cancelled_by` int(11) DEFAULT NULL,
`cancelled_at` datetime DEFAULT NULL,
`cancellation_reason` varchar(1000) DEFAULT NULL,
`row_version` int(10) UNSIGNED NOT NULL DEFAULT 1,
`created_by` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
`sender_starred` tinyint(1) NOT NULL DEFAULT 0,
`sender_personal_archived_at` datetime DEFAULT NULL,
`sender_follow_up_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_letters`
--
INSERT IGNORE INTO `gooyaacc_negar_letters` (`id`, `public_uuid`, `direction`, `status`, `confidentiality`, `priority`, `org_unit_id`, `sender_user_id`, `sender_name_snapshot`, `sender_title_snapshot`, `subject`, `sequence_id`, `letter_year`, `letter_no`, `registered_at`, `current_version_id`, `final_pdf_attachment_id`, `final_pdf_sha256`, `requires_ack`, `due_at`, `signed_at`, `sent_at`, `closed_at`, `archived_at`, `legal_hold`, `draft_deleted_at`, `cancelled_by`, `cancelled_at`, `cancellation_reason`, `row_version`, `created_by`, `created_at`, `updated_at`, `sender_starred`, `sender_personal_archived_at`, `sender_follow_up_at`) VALUES
(102, '960cb303-bbd7-4575-a381-4a66f2c854f4', 'internal', 'sent', 'normal', 'urgent', 2, 1, 'حسین فغان پور', '', '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] نامه رسمی امضاشده و مشاهدهشده', 24, 1405, 'GNT-1405-000001', '2026-08-15 10:57:25', 111, 2700, '3be3cd442e2be50de77e94fe301ef352fc20f71014b008f6728b1d13acefed22', 1, NULL, '2026-08-15 10:57:25', '2026-08-15 10:57:25', NULL, NULL, 0, NULL, NULL, NULL, NULL, 6, 1, '2026-08-15 10:57:24', '2026-08-15 10:57:25', 0, NULL, NULL),
(103, 'ca18d983-8673-463c-a5b6-93e72591c416', 'internal', 'sent', 'confidential', 'normal', 2, 1, 'حسین فغان پور', '', '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] نامه خواندهنشده با رونوشت', 24, 1405, 'GNT-1405-000002', '2026-08-15 10:57:26', 112, 2702, '3af060413a62adcdc2a100a349de8fbeef11159fb3f60141820d49f609542fef', 0, NULL, '2026-08-15 10:57:26', '2026-08-15 10:57:26', NULL, NULL, 0, NULL, NULL, NULL, NULL, 6, 1, '2026-08-15 10:57:25', '2026-08-15 10:57:26', 0, NULL, NULL),
(104, '2df4eecb-6174-4f03-bf74-4ba20dcaf50b', 'internal', 'draft', 'normal', 'normal', 2, 1, 'حسین فغان پور', '', '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] پیشنویس دارای پیوست', NULL, NULL, NULL, NULL, 113, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 1, 1, '2026-08-15 10:57:26', '2026-08-15 10:57:26', 0, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_letter_versions`
--
DROP TABLE IF EXISTS `gooyaacc_negar_letter_versions`;
CREATE TABLE `gooyaacc_negar_letter_versions` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED NOT NULL,
`version_no` int(10) UNSIGNED NOT NULL,
`subject` varchar(500) NOT NULL,
`summary` text DEFAULT NULL,
`greeting` varchar(500) DEFAULT NULL,
`body_html` longtext NOT NULL,
`body_text` longtext NOT NULL,
`closing_text` varchar(500) DEFAULT NULL,
`content_sha256` char(64) NOT NULL,
`change_reason` varchar(1000) DEFAULT NULL,
`is_final` tinyint(1) NOT NULL DEFAULT 0,
`immutable_at` datetime DEFAULT NULL,
`created_by` int(11) NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_letter_versions`
--
INSERT IGNORE INTO `gooyaacc_negar_letter_versions` (`id`, `letter_id`, `version_no`, `subject`, `summary`, `greeting`, `body_html`, `body_text`, `closing_text`, `content_sha256`, `change_reason`, `is_final`, `immutable_at`, `created_by`, `created_at`) VALUES
(111, 102, 1, '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] نامه رسمی امضاشده و مشاهدهشده', '', '', 'با سلام و احترام
\n
\nاین نامه برای آزمون عملی چرخه کامل مکاتبات سازمانی گویانگار ایجاد شده است. لطفاً دریافت، مشاهده و وضعیت پیگیری آن بررسی شود.
\n
\nبا احترام', 'با سلام و احترام\n\nاین نامه برای آزمون عملی چرخه کامل مکاتبات سازمانی گویانگار ایجاد شده است. لطفاً دریافت، مشاهده و وضعیت پیگیری آن بررسی شود.\n\nبا احترام', '', 'bf28d4f286e51b984fe0fddf6c7210ad3b72386d7cc2462b52c8e2907b00dab9', 'manual', 1, '2026-08-15 10:57:25', 1, '2026-08-15 10:57:24'),
(112, 103, 1, '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] نامه خواندهنشده با رونوشت', '', '', 'با سلام
\n
\nاین نامه برای بررسی صندوق ورودی، رونوشت دریافتی و وضعیت خواندهنشده ایجاد شده است.
\n
\nبا احترام', 'با سلام\n\nاین نامه برای بررسی صندوق ورودی، رونوشت دریافتی و وضعیت خواندهنشده ایجاد شده است.\n\nبا احترام', '', '704423af465b20a501252a631dc5f31b34134a1f4898f54f03df803a3ac75002', 'manual', 1, '2026-08-15 10:57:25', 1, '2026-08-15 10:57:25'),
(113, 104, 1, '[آزمون عملی گویانگار ۱۴۰۵/۰۵/۲۴] پیشنویس دارای پیوست', '', '', 'این پیشنویس برای آزمون ویرایش خودکار، Drag & Drop و پیوست متمرکز نگهداری شده است.', 'این پیشنویس برای آزمون ویرایش خودکار، Drag & Drop و پیوست متمرکز نگهداری شده است.', '', '0925bd121aaf1efc78122dccbf38c8b344267a4f7123557dd77630058d91977e', 'manual', 0, NULL, 1, '2026-08-15 10:57:26');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_links`
--
DROP TABLE IF EXISTS `gooyaacc_negar_links`;
CREATE TABLE `gooyaacc_negar_links` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED NOT NULL,
`link_type` enum('reply_to','parent_letter','related_letter','crm_record') NOT NULL,
`related_letter_id` bigint(20) UNSIGNED DEFAULT NULL,
`crm_module` varchar(80) DEFAULT NULL,
`crm_record_id` varchar(100) DEFAULT NULL,
`label_snapshot` varchar(255) DEFAULT NULL,
`created_by` int(11) NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_org_members`
--
DROP TABLE IF EXISTS `gooyaacc_negar_org_members`;
CREATE TABLE `gooyaacc_negar_org_members` (
`id` bigint(20) UNSIGNED NOT NULL,
`org_unit_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`member_role` enum('member','manager','secretary') NOT NULL DEFAULT 'member',
`is_primary` tinyint(1) NOT NULL DEFAULT 0,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`valid_from` datetime DEFAULT NULL,
`valid_until` datetime DEFAULT NULL,
`synced_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_org_members`
--
INSERT IGNORE INTO `gooyaacc_negar_org_members` (`id`, `org_unit_id`, `user_id`, `member_role`, `is_primary`, `is_active`, `valid_from`, `valid_until`, `synced_at`) VALUES
(1, 2, 1, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(2, 2, 5, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(3, 3, 4, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(4, 3, 8, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(5, 3, 13, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(6, 3, 14, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(7, 3, 17, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(8, 3, 18, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(9, 3, 19, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(10, 3, 20, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(11, 5, 7, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(12, 5, 9, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(13, 5, 10, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(14, 5, 12, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(15, 5, 16, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(16, 5, 24, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(17, 5, 25, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(18, 5, 26, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(19, 6, 2, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(20, 6, 3, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(21, 6, 6, 'member', 1, 0, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(22, 6, 11, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(23, 6, 15, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(24, 6, 21, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(25, 6, 22, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(26, 6, 23, 'member', 1, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(27, 10, 1, 'member', 0, 1, '2026-08-11 13:43:04', NULL, '2026-08-25 09:48:21'),
(279, 4, 2, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21'),
(280, 4, 6, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21'),
(293, 7, 5, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21'),
(294, 8, 3, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21'),
(295, 8, 4, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21'),
(296, 8, 7, 'member', 1, 1, '2026-08-25 09:45:26', NULL, '2026-08-25 09:48:21');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_org_units`
--
DROP TABLE IF EXISTS `gooyaacc_negar_org_units`;
CREATE TABLE `gooyaacc_negar_org_units` (
`id` int(11) NOT NULL,
`external_key` varchar(100) NOT NULL,
`source_kind` enum('crm_role','crm_group','manual') NOT NULL DEFAULT 'manual',
`parent_id` int(11) DEFAULT NULL,
`unit_code` varchar(50) DEFAULT NULL,
`unit_name` varchar(180) NOT NULL,
`manager_user_id` int(11) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`synced_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_org_units`
--
INSERT IGNORE INTO `gooyaacc_negar_org_units` (`id`, `external_key`, `source_kind`, `parent_id`, `unit_code`, `unit_name`, `manager_user_id`, `is_active`, `synced_at`, `created_at`, `updated_at`) VALUES
(1, 'role:H1', 'crm_role', NULL, 'H1', 'Organization', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(2, 'role:H2', 'crm_role', 1, 'H2', 'مدیرعامل', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(3, 'role:H29', 'crm_role', 1, 'H29', 'آزمون گویا - مجاز - 20260801-073004', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(4, 'role:H3', 'crm_role', 2, 'H3', 'مدیر پروژه', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(5, 'role:H30', 'crm_role', 1, 'H30', 'آزمون گویا - ارثبری - 20260801-073004', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(6, 'role:H31', 'crm_role', 1, 'H31', 'آزمون گویا - محدود - 20260801-073004', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(7, 'role:H4', 'crm_role', 2, 'H4', 'سرپرست و مدیر دفتر', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(8, 'role:H5', 'crm_role', 2, 'H5', 'کارشناس', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(9, 'group:2', 'crm_group', NULL, '2', 'Team Selling', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(10, 'group:3', 'crm_group', NULL, '3', 'Marketing Group', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21'),
(11, 'group:4', 'crm_group', NULL, '4', 'Support Group', NULL, 1, '2026-08-25 09:48:21', '2026-08-11 13:43:04', '2026-08-25 09:48:21');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_recipients`
--
DROP TABLE IF EXISTS `gooyaacc_negar_recipients`;
CREATE TABLE `gooyaacc_negar_recipients` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED NOT NULL,
`recipient_user_id` int(11) NOT NULL,
`selected_org_unit_id` int(11) DEFAULT NULL,
`recipient_type` enum('primary','copy','blind_copy') NOT NULL DEFAULT 'primary',
`recipient_name_snapshot` varchar(220) NOT NULL,
`recipient_title_snapshot` varchar(180) DEFAULT NULL,
`copy_purpose` enum('none','information','action','review','archive','custom') NOT NULL DEFAULT 'none',
`purpose_text` varchar(500) DEFAULT NULL,
`delivery_status` enum('pending','queued','sent','failed','cancelled') NOT NULL DEFAULT 'pending',
`delivered_at` datetime DEFAULT NULL,
`first_opened_at` datetime DEFAULT NULL,
`last_opened_at` datetime DEFAULT NULL,
`open_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
`acknowledged_at` datetime DEFAULT NULL,
`sms_status` enum('not_required','pending','sending','sent','delivered','failed') NOT NULL DEFAULT 'not_required',
`sms_attempts` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
`sms_last_attempt_at` datetime DEFAULT NULL,
`sms_next_attempt_at` datetime DEFAULT NULL,
`sms_sent_at` datetime DEFAULT NULL,
`sms_delivered_at` datetime DEFAULT NULL,
`sms_provider_message_id` varchar(150) DEFAULT NULL,
`sms_last_error` varchar(500) DEFAULT NULL,
`created_at` datetime NOT NULL,
`is_starred` tinyint(1) NOT NULL DEFAULT 0,
`personal_archived_at` datetime DEFAULT NULL,
`follow_up_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_recipients`
--
INSERT IGNORE INTO `gooyaacc_negar_recipients` (`id`, `letter_id`, `recipient_user_id`, `selected_org_unit_id`, `recipient_type`, `recipient_name_snapshot`, `recipient_title_snapshot`, `copy_purpose`, `purpose_text`, `delivery_status`, `delivered_at`, `first_opened_at`, `last_opened_at`, `open_count`, `acknowledged_at`, `sms_status`, `sms_attempts`, `sms_last_attempt_at`, `sms_next_attempt_at`, `sms_sent_at`, `sms_delivered_at`, `sms_provider_message_id`, `sms_last_error`, `created_at`, `is_starred`, `personal_archived_at`, `follow_up_at`) VALUES
(140, 102, 6, NULL, 'primary', 'رضا محمدیان', '', 'none', '', 'sent', '2026-08-15 10:57:25', '2026-08-15 10:57:25', '2026-08-15 10:57:25', 1, '2026-08-15 10:57:25', 'sent', 1, '2026-08-15 13:24:37', NULL, '2026-08-15 13:24:38', NULL, '27535007', NULL, '2026-08-15 10:57:24', 0, NULL, NULL),
(141, 102, 7, NULL, 'copy', 'علی کریمی', '', 'information', '', 'sent', '2026-08-15 10:57:25', NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:25', 0, NULL, NULL),
(142, 102, 8, NULL, 'blind_copy', 'نیما قاسمی', '', 'archive', '', 'sent', '2026-08-15 10:57:25', NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:25', 0, NULL, NULL),
(143, 103, 7, NULL, 'primary', 'علی کریمی', '', 'none', '', 'sent', '2026-08-15 10:57:26', NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:25', 0, NULL, NULL),
(144, 103, 6, NULL, 'copy', 'رضا محمدیان', '', 'action', '', 'sent', '2026-08-15 10:57:26', NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:25', 0, NULL, NULL),
(145, 103, 8, NULL, 'blind_copy', 'نیما قاسمی', '', 'review', '', 'sent', '2026-08-15 10:57:26', NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:25', 0, NULL, NULL),
(146, 104, 6, NULL, 'primary', 'رضا محمدیان', '', 'none', '', 'pending', NULL, NULL, NULL, 0, NULL, 'not_required', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-15 10:57:26', 0, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_referrals`
--
DROP TABLE IF EXISTS `gooyaacc_negar_referrals`;
CREATE TABLE `gooyaacc_negar_referrals` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED NOT NULL,
`parent_referral_id` bigint(20) UNSIGNED DEFAULT NULL,
`from_user_id` int(11) NOT NULL,
`to_user_id` int(11) DEFAULT NULL,
`to_org_unit_id` int(11) DEFAULT NULL,
`instruction_text` text NOT NULL,
`priority` enum('normal','urgent','immediate') NOT NULL DEFAULT 'normal',
`referral_status` enum('new','opened','in_progress','completed','returned','cancelled') NOT NULL DEFAULT 'new',
`due_at` datetime DEFAULT NULL,
`first_opened_at` datetime DEFAULT NULL,
`last_opened_at` datetime DEFAULT NULL,
`result_text` text DEFAULT NULL,
`completed_by` int(11) DEFAULT NULL,
`completed_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`is_starred` tinyint(1) NOT NULL DEFAULT 0,
`personal_archived_at` datetime DEFAULT NULL,
`follow_up_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_sequences`
--
DROP TABLE IF EXISTS `gooyaacc_negar_sequences`;
CREATE TABLE `gooyaacc_negar_sequences` (
`id` bigint(20) UNSIGNED NOT NULL,
`org_unit_id` int(11) NOT NULL DEFAULT 0,
`calendar_year` smallint(5) UNSIGNED NOT NULL,
`direction` enum('internal','incoming','outgoing') NOT NULL,
`prefix` varchar(40) NOT NULL DEFAULT '',
`number_pattern` varchar(120) NOT NULL DEFAULT '{prefix}-{year}-{number}',
`current_no` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`lock_version` int(10) UNSIGNED NOT NULL DEFAULT 0,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`updated_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_sequences`
--
INSERT IGNORE INTO `gooyaacc_negar_sequences` (`id`, `org_unit_id`, `calendar_year`, `direction`, `prefix`, `number_pattern`, `current_no`, `lock_version`, `is_active`, `updated_by`, `updated_at`) VALUES
(24, 2, 1405, 'internal', 'GNT', '{prefix}-{year}-{number}', 2, 2, 1, NULL, '2026-08-15 10:57:26');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_settings`
--
DROP TABLE IF EXISTS `gooyaacc_negar_settings`;
CREATE TABLE `gooyaacc_negar_settings` (
`skey` varchar(80) NOT NULL,
`svalue` text DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_settings`
--
INSERT IGNORE INTO `gooyaacc_negar_settings` (`skey`, `svalue`, `updated_by`, `updated_at`) VALUES
('ai_enabled', '0', 0, '2026-08-11 13:43:03'),
('allowed_extensions', 'pdf,doc,docx,xls,xlsx,ppt,pptx,jpg,jpeg,png,webp,txt', 0, '2026-08-11 13:43:03'),
('archive_cloud_folder_name', 'آرشیو گویانگار', 0, '2026-08-11 13:43:03'),
('archive_cloud_public_links', '0', 0, '2026-08-11 13:43:03'),
('archive_enabled', '0', 0, '2026-08-11 13:43:03'),
('archive_to_gooya_cloud', '1', 0, '2026-08-11 13:43:03'),
('backup_enabled', '0', 0, '2026-08-11 13:43:03'),
('default_retention_months', '12', 0, '2026-08-11 13:43:03'),
('max_file_size_bytes', '20971520', 0, '2026-08-11 13:43:03'),
('module_enabled', '1', 1, '2026-08-15 10:57:24'),
('purge_enabled', '0', 0, '2026-08-11 13:43:03'),
('schema_version', '1.0-contract', 0, '2026-08-11 13:43:03'),
('signed_url_ttl_seconds', '180', 0, '2026-08-11 13:43:03'),
('sms_confidential_content', '0', 0, '2026-08-11 13:43:03'),
('sms_confidential_template', 'شما از طرف «{sender}» یک نامه سازمانی محرمانه جدید در سامانه گویا دارید. شماره نامه: {number}', 1, '2026-08-13 13:24:51'),
('sms_copy_enabled', '0', 1, '2026-08-15 10:57:24'),
('sms_letter_template', 'شما از طرف «{sender}» یک نامه سازمانی جدید در سامانه گویا دارید. شماره نامه: {number}', 1, '2026-08-13 13:24:51'),
('sms_max_attempts', '3', 1, '2026-08-13 13:24:51'),
('sms_notifications_enabled', '1', 1, '2026-08-15 10:57:26'),
('sms_retry_minutes', '5', 1, '2026-08-13 13:24:51'),
('storage_gateway', 'GooyaStorage', 0, '2026-08-11 13:43:03'),
('storage_source_module', 'GooyaNegar', 0, '2026-08-11 13:43:03'),
('supported_directions', 'internal,incoming,outgoing', 0, '2026-08-11 13:43:03'),
('user_sync_ttl_minutes', '60', 0, '2026-08-11 13:43:03');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_signatures`
--
DROP TABLE IF EXISTS `gooyaacc_negar_signatures`;
CREATE TABLE `gooyaacc_negar_signatures` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`version_no` int(10) UNSIGNED NOT NULL,
`storage_attachment_id` bigint(20) UNSIGNED NOT NULL,
`mime_type` varchar(100) NOT NULL DEFAULT 'image/png',
`size_bytes` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`checksum_sha256` char(64) NOT NULL,
`canvas_width` int(10) UNSIGNED DEFAULT NULL,
`canvas_height` int(10) UNSIGNED DEFAULT NULL,
`signature_status` enum('active','replaced','revoked') NOT NULL DEFAULT 'active',
`registered_auth` enum('password','otp','password_otp') NOT NULL,
`verified_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
`replaced_at` datetime DEFAULT NULL,
`revoked_by` int(11) DEFAULT NULL,
`revoked_at` datetime DEFAULT NULL,
`revoke_reason` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_signatures`
--
INSERT IGNORE INTO `gooyaacc_negar_signatures` (`id`, `user_id`, `version_no`, `storage_attachment_id`, `mime_type`, `size_bytes`, `checksum_sha256`, `canvas_width`, `canvas_height`, `signature_status`, `registered_auth`, `verified_at`, `created_at`, `replaced_at`, `revoked_by`, `revoked_at`, `revoke_reason`) VALUES
(33, 6, 1, 2699, 'image/png', 1701, '9cf6793740d9b53764b0393e1db65f3e33440408ba1a72455c0d5e9712640779', 520, 210, 'active', 'password', '2026-08-15 10:57:24', '2026-08-15 10:57:24', NULL, NULL, NULL, NULL),
(39, 1, 1, 2716, 'image/png', 13101, 'c0d3d67c84871e19ea43668806c39fa6c80f5db5d602f0388704fb51ff97626a', 828, 306, 'active', 'password', '2026-08-17 14:09:37', '2026-08-17 14:09:37', NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_templates`
--
DROP TABLE IF EXISTS `gooyaacc_negar_templates`;
CREATE TABLE `gooyaacc_negar_templates` (
`id` bigint(20) UNSIGNED NOT NULL,
`template_code` varchar(80) NOT NULL,
`template_name` varchar(180) NOT NULL,
`org_unit_id` int(11) DEFAULT NULL,
`direction` enum('internal','incoming','outgoing','any') NOT NULL DEFAULT 'any',
`template_type` enum('body','letterhead','full') NOT NULL DEFAULT 'full',
`header_html` mediumtext DEFAULT NULL,
`body_html` longtext DEFAULT NULL,
`footer_html` mediumtext DEFAULT NULL,
`print_css` mediumtext DEFAULT NULL,
`letterhead_storage_attachment_id` bigint(20) UNSIGNED DEFAULT NULL,
`version_no` int(10) UNSIGNED NOT NULL DEFAULT 1,
`is_active` tinyint(1) NOT NULL DEFAULT 1,
`created_by` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_users`
--
DROP TABLE IF EXISTS `gooyaacc_negar_users`;
CREATE TABLE `gooyaacc_negar_users` (
`user_id` int(11) NOT NULL,
`user_name` varchar(100) DEFAULT NULL,
`first_name` varchar(100) DEFAULT NULL,
`last_name` varchar(100) DEFAULT NULL,
`full_name` varchar(220) DEFAULT NULL,
`email` varchar(180) DEFAULT NULL,
`mobile` varchar(40) DEFAULT NULL,
`job_title` varchar(180) DEFAULT NULL,
`is_crm_admin` tinyint(1) NOT NULL DEFAULT 0,
`crm_status` varchar(25) DEFAULT NULL,
`crm_deleted` tinyint(1) NOT NULL DEFAULT 0,
`synced_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_users`
--
INSERT IGNORE INTO `gooyaacc_negar_users` (`user_id`, `user_name`, `first_name`, `last_name`, `full_name`, `email`, `mobile`, `job_title`, `is_crm_admin`, `crm_status`, `crm_deleted`, `synced_at`) VALUES
(1, 'admin', 'فرهاد', 'داداشی', 'فرهاد داداشی', '', '09111007370', 'مدیرعامل', 1, 'Active', 0, '2026-08-25 09:48:21'),
(2, 'ali', 'خانم', 'حسنی', 'خانم حسنی', '', '', 'مدیر پروژه', 0, 'Active', 0, '2026-08-25 09:48:21'),
(3, 'sara', 'خانم', 'رمضانپور', 'خانم رمضانپور', '', '', 'کارشناس', 0, 'Active', 0, '2026-08-25 09:48:21'),
(4, 'reza', 'خانم', 'تقی پور', 'خانم تقی پور', '', '', 'کارشناس', 0, 'Active', 0, '2026-08-25 09:48:21'),
(5, 'a.zare', 'خانم', 'رامی', 'خانم رامی', '', '', 'سرپرست و مدیر دفتر', 0, 'Active', 0, '2026-08-25 09:48:21'),
(6, 'kpiseed_mgr', 'خانم', 'سعادتی', 'خانم سعادتی', '', '', 'مدیر پروژه', 0, 'Active', 0, '2026-08-25 09:48:21'),
(7, 'kpiseed_sup1', 'خانم', 'صادق نیا', 'خانم صادق نیا', '', '', 'کارشناس', 0, 'Active', 0, '2026-08-25 09:48:21'),
(8, 'kpiseed_emp1', 'نیما', 'قاسمی', 'نیما قاسمی', 'kpiseed_emp1@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(9, 'kpiseed_emp2', 'زهرا', 'مرادی', 'زهرا مرادی', 'kpiseed_emp2@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(10, 'kpiseed_emp3', 'امیر', 'صادقی', 'امیر صادقی', 'kpiseed_emp3@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(11, 'kpiseed_sup2', 'سارا', 'احمدی', 'سارا احمدی', 'kpiseed_sup2@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(12, 'kpiseed_emp4', 'فاطمه', 'کاظمی', 'فاطمه کاظمی', 'kpiseed_emp4@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(13, 'kpiseed_emp5', 'سینا', 'یوسفی', 'سینا یوسفی', 'kpiseed_emp5@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(14, 'kpiseed_emp6', 'الهام', 'جعفری', 'الهام جعفری', 'kpiseed_emp6@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(15, 'kpiseed_sup3', 'حسن', 'رضایی', 'حسن رضایی', 'kpiseed_sup3@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(16, 'kpiseed_emp7', 'بهرام', 'اکبری', 'بهرام اکبری', 'kpiseed_emp7@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(17, 'kpiseed_emp8', 'نگار', 'شریفی', 'نگار شریفی', 'kpiseed_emp8@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(18, 'kpiseed_emp9', 'پیمان', 'بابایی', 'پیمان بابایی', 'kpiseed_emp9@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(19, 'kpiseed_sup4', 'مریم', 'حسینی', 'مریم حسینی', 'kpiseed_sup4@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(20, 'kpiseed_emp10', 'مینا', 'رستمی', 'مینا رستمی', 'kpiseed_emp10@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(21, 'kpiseed_emp11', 'کیان', 'عباسی', 'کیان عباسی', 'kpiseed_emp11@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(22, 'kpiseed_emp12', 'رها', 'نادری', 'رها نادری', 'kpiseed_emp12@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(23, 'kpiseed_sup5', 'کاوه', 'نوری', 'کاوه نوری', 'kpiseed_sup5@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(24, 'kpiseed_emp13', 'آرش', 'فلاحی', 'آرش فلاحی', 'kpiseed_emp13@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(25, 'kpiseed_emp14', 'سحر', 'زارع', 'سحر زارع', 'kpiseed_emp14@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21'),
(26, 'kpiseed_emp15', 'وحید', 'محمودی', 'وحید محمودی', 'kpiseed_emp15@example.local', '09119090378', '', 0, 'Active', 0, '2026-08-25 09:48:21');
-- --------------------------------------------------------
--
-- Table structure for table `gooyaacc_negar_workflow_steps`
--
DROP TABLE IF EXISTS `gooyaacc_negar_workflow_steps`;
CREATE TABLE `gooyaacc_negar_workflow_steps` (
`id` bigint(20) UNSIGNED NOT NULL,
`letter_id` bigint(20) UNSIGNED NOT NULL,
`step_no` int(10) UNSIGNED NOT NULL,
`step_type` enum('review','approval','registration','signature','dispatch','acknowledgement','close') NOT NULL,
`assigned_user_id` int(11) DEFAULT NULL,
`assigned_org_unit_id` int(11) DEFAULT NULL,
`step_status` enum('pending','in_progress','approved','rejected','changes_requested','completed','cancelled','skipped') NOT NULL DEFAULT 'pending',
`is_required` tinyint(1) NOT NULL DEFAULT 1,
`decision_note` varchar(2000) DEFAULT NULL,
`signature_id` bigint(20) UNSIGNED DEFAULT NULL,
`due_at` datetime DEFAULT NULL,
`acted_by` int(11) DEFAULT NULL,
`acted_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`is_starred` tinyint(1) NOT NULL DEFAULT 0,
`personal_archived_at` datetime DEFAULT NULL,
`follow_up_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
--
-- Dumping data for table `gooyaacc_negar_workflow_steps`
--
INSERT IGNORE INTO `gooyaacc_negar_workflow_steps` (`id`, `letter_id`, `step_no`, `step_type`, `assigned_user_id`, `assigned_org_unit_id`, `step_status`, `is_required`, `decision_note`, `signature_id`, `due_at`, `acted_by`, `acted_at`, `created_at`, `is_starred`, `personal_archived_at`, `follow_up_at`) VALUES
(150, 102, 1, 'review', 1, NULL, 'approved', 1, NULL, NULL, NULL, 1, '2026-08-15 10:57:25', '2026-08-15 10:57:25', 0, NULL, NULL),
(151, 102, 2, 'approval', 1, NULL, 'approved', 1, NULL, NULL, NULL, 1, '2026-08-15 10:57:25', '2026-08-15 10:57:25', 0, NULL, NULL),
(152, 102, 3, 'registration', 1, NULL, 'completed', 1, 'شماره GNT-1405-000001', NULL, NULL, 1, '2026-08-15 10:57:25', '2026-08-15 10:57:25', 0, NULL, NULL),
(153, 102, 4, 'signature', 6, NULL, 'completed', 1, 'امضا با احراز هویت password', 33, NULL, 6, '2026-08-15 10:57:25', '2026-08-15 10:57:25', 0, NULL, NULL),
(154, 102, 5, 'dispatch', 1, NULL, 'completed', 1, 'ارسال نهایی', NULL, NULL, 1, '2026-08-15 10:57:25', '2026-08-15 10:57:25', 0, NULL, NULL),
(155, 103, 1, 'review', 1, NULL, 'approved', 1, NULL, NULL, NULL, 1, '2026-08-15 10:57:26', '2026-08-15 10:57:25', 0, NULL, NULL),
(156, 103, 2, 'approval', 1, NULL, 'approved', 1, NULL, NULL, NULL, 1, '2026-08-15 10:57:26', '2026-08-15 10:57:26', 0, NULL, NULL),
(157, 103, 3, 'registration', 1, NULL, 'completed', 1, 'شماره GNT-1405-000002', NULL, NULL, 1, '2026-08-15 10:57:26', '2026-08-15 10:57:26', 0, NULL, NULL),
(158, 103, 4, 'signature', 6, NULL, 'completed', 1, 'امضا با احراز هویت password', 33, NULL, 6, '2026-08-15 10:57:26', '2026-08-15 10:57:26', 0, NULL, NULL),
(159, 103, 5, 'dispatch', 1, NULL, 'completed', 1, 'ارسال نهایی', NULL, NULL, 1, '2026-08-15 10:57:26', '2026-08-15 10:57:26', 0, NULL, NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `gooyaacc_negar_access`
--
ALTER TABLE `gooyaacc_negar_access`
ADD PRIMARY KEY (`user_id`),
ADD KEY `idx_negar_access_enabled` (`is_enabled`,`access_role`),
ADD KEY `idx_negar_access_substitute` (`temporary_substitute_user_id`,`temporary_substitute_from`,`temporary_substitute_until`);
--
-- Indexes for table `gooyaacc_negar_ai_audit`
--
ALTER TABLE `gooyaacc_negar_ai_audit`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_ai_request` (`request_uuid`),
ADD KEY `idx_negar_ai_letter` (`letter_id`,`created_at`),
ADD KEY `idx_negar_ai_user` (`user_id`,`created_at`),
ADD KEY `idx_negar_ai_status` (`request_status`,`created_at`);
--
-- Indexes for table `gooyaacc_negar_archive_runs`
--
ALTER TABLE `gooyaacc_negar_archive_runs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_archive_idempotency` (`idempotency_key`),
ADD UNIQUE KEY `uq_negar_archive_cloud_file` (`cloud_file_id`),
ADD KEY `idx_negar_archive_status` (`run_status`,`cloud_export_status`),
ADD KEY `idx_negar_archive_cutoff` (`cutoff_date`);
--
-- Indexes for table `gooyaacc_negar_attachments`
--
ALTER TABLE `gooyaacc_negar_attachments`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_storage_attachment` (`storage_attachment_id`),
ADD KEY `idx_negar_attachment_letter` (`letter_id`,`attachment_kind`,`storage_status`),
ADD KEY `idx_negar_attachment_version` (`version_id`),
ADD KEY `idx_negar_attachment_purge` (`purge_status`,`deleted_at`);
--
-- Indexes for table `gooyaacc_negar_audit_log`
--
ALTER TABLE `gooyaacc_negar_audit_log`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_audit_event` (`event_uuid`),
ADD KEY `idx_negar_audit_letter` (`letter_id`,`created_at`),
ADD KEY `idx_negar_audit_actor` (`actor_user_id`,`created_at`),
ADD KEY `idx_negar_audit_action` (`action`,`created_at`),
ADD KEY `idx_negar_audit_hash` (`event_hash`);
--
-- Indexes for table `gooyaacc_negar_letters`
--
ALTER TABLE `gooyaacc_negar_letters`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_letter_uuid` (`public_uuid`),
ADD UNIQUE KEY `uq_negar_registered_number` (`sequence_id`,`letter_year`,`letter_no`),
ADD KEY `idx_negar_letter_box` (`sender_user_id`,`status`,`sent_at`),
ADD KEY `idx_negar_letter_org` (`org_unit_id`,`status`,`created_at`),
ADD KEY `idx_negar_letter_subject` (`subject`(191)),
ADD KEY `idx_negar_letter_archive` (`status`,`archived_at`),
ADD KEY `idx_negar_sender_personal` (`sender_user_id`,`sender_starred`,`sender_personal_archived_at`,`sender_follow_up_at`);
--
-- Indexes for table `gooyaacc_negar_letter_versions`
--
ALTER TABLE `gooyaacc_negar_letter_versions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_letter_version` (`letter_id`,`version_no`),
ADD KEY `idx_negar_version_hash` (`content_sha256`),
ADD KEY `idx_negar_version_creator` (`created_by`,`created_at`);
--
-- Indexes for table `gooyaacc_negar_links`
--
ALTER TABLE `gooyaacc_negar_links`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_negar_link_letter` (`letter_id`,`link_type`),
ADD KEY `idx_negar_link_related` (`related_letter_id`),
ADD KEY `idx_negar_link_crm` (`crm_module`,`crm_record_id`);
--
-- Indexes for table `gooyaacc_negar_org_members`
--
ALTER TABLE `gooyaacc_negar_org_members`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_org_member_role` (`org_unit_id`,`user_id`,`member_role`),
ADD KEY `idx_negar_org_member_user` (`user_id`,`is_active`),
ADD KEY `idx_negar_org_member_unit` (`org_unit_id`,`is_active`);
--
-- Indexes for table `gooyaacc_negar_org_units`
--
ALTER TABLE `gooyaacc_negar_org_units`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_org_external` (`external_key`),
ADD UNIQUE KEY `uq_negar_org_code` (`unit_code`),
ADD KEY `idx_negar_org_parent` (`parent_id`),
ADD KEY `idx_negar_org_active` (`is_active`);
--
-- Indexes for table `gooyaacc_negar_recipients`
--
ALTER TABLE `gooyaacc_negar_recipients`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_recipient_user` (`letter_id`,`recipient_user_id`),
ADD KEY `idx_negar_recipient_inbox` (`recipient_user_id`,`delivery_status`,`delivered_at`),
ADD KEY `idx_negar_recipient_sms` (`sms_status`,`sms_next_attempt_at`),
ADD KEY `idx_negar_recipient_opened` (`letter_id`,`first_opened_at`),
ADD KEY `idx_negar_recipient_personal` (`recipient_user_id`,`is_starred`,`personal_archived_at`,`follow_up_at`);
--
-- Indexes for table `gooyaacc_negar_referrals`
--
ALTER TABLE `gooyaacc_negar_referrals`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_negar_referral_user` (`to_user_id`,`referral_status`,`due_at`),
ADD KEY `idx_negar_referral_unit` (`to_org_unit_id`,`referral_status`),
ADD KEY `idx_negar_referral_letter` (`letter_id`,`created_at`),
ADD KEY `idx_negar_referral_personal` (`to_user_id`,`is_starred`,`personal_archived_at`,`follow_up_at`);
--
-- Indexes for table `gooyaacc_negar_sequences`
--
ALTER TABLE `gooyaacc_negar_sequences`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_sequence` (`org_unit_id`,`calendar_year`,`direction`,`prefix`),
ADD KEY `idx_negar_sequence_active` (`is_active`);
--
-- Indexes for table `gooyaacc_negar_settings`
--
ALTER TABLE `gooyaacc_negar_settings`
ADD PRIMARY KEY (`skey`);
--
-- Indexes for table `gooyaacc_negar_signatures`
--
ALTER TABLE `gooyaacc_negar_signatures`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_signature_version` (`user_id`,`version_no`),
ADD UNIQUE KEY `uq_negar_signature_storage` (`storage_attachment_id`),
ADD KEY `idx_negar_signature_active` (`user_id`,`signature_status`);
--
-- Indexes for table `gooyaacc_negar_templates`
--
ALTER TABLE `gooyaacc_negar_templates`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_template_code_version` (`template_code`,`version_no`),
ADD KEY `idx_negar_template_active` (`is_active`,`org_unit_id`,`direction`);
--
-- Indexes for table `gooyaacc_negar_users`
--
ALTER TABLE `gooyaacc_negar_users`
ADD PRIMARY KEY (`user_id`),
ADD KEY `idx_negar_users_active` (`crm_deleted`,`crm_status`),
ADD KEY `idx_negar_users_name` (`full_name`);
--
-- Indexes for table `gooyaacc_negar_workflow_steps`
--
ALTER TABLE `gooyaacc_negar_workflow_steps`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `uq_negar_workflow_step` (`letter_id`,`step_no`),
ADD KEY `idx_negar_workflow_assignee` (`assigned_user_id`,`step_status`,`due_at`),
ADD KEY `idx_negar_workflow_letter` (`letter_id`,`step_status`),
ADD KEY `idx_negar_workflow_personal` (`assigned_user_id`,`is_starred`,`personal_archived_at`,`follow_up_at`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `gooyaacc_negar_ai_audit`
--
ALTER TABLE `gooyaacc_negar_ai_audit`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_archive_runs`
--
ALTER TABLE `gooyaacc_negar_archive_runs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_attachments`
--
ALTER TABLE `gooyaacc_negar_attachments`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_audit_log`
--
ALTER TABLE `gooyaacc_negar_audit_log`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=939;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_letters`
--
ALTER TABLE `gooyaacc_negar_letters`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_letter_versions`
--
ALTER TABLE `gooyaacc_negar_letter_versions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_links`
--
ALTER TABLE `gooyaacc_negar_links`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_org_members`
--
ALTER TABLE `gooyaacc_negar_org_members`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=352;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_org_units`
--
ALTER TABLE `gooyaacc_negar_org_units`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_recipients`
--
ALTER TABLE `gooyaacc_negar_recipients`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_referrals`
--
ALTER TABLE `gooyaacc_negar_referrals`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_sequences`
--
ALTER TABLE `gooyaacc_negar_sequences`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_signatures`
--
ALTER TABLE `gooyaacc_negar_signatures`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_templates`
--
ALTER TABLE `gooyaacc_negar_templates`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `gooyaacc_negar_workflow_steps`
--
ALTER TABLE `gooyaacc_negar_workflow_steps`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;
--
-- Database: `vtigercrm`
--
DROP DATABASE IF EXISTS `vtigercrm`;
CREATE DATABASE IF NOT EXISTS `vtigercrm` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `vtigercrm`;
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflows`
--
DROP TABLE IF EXISTS `com_vtiger_workflows`;
CREATE TABLE `com_vtiger_workflows` (
`workflow_id` int(11) NOT NULL,
`module_name` varchar(100) DEFAULT NULL,
`summary` varchar(400) NOT NULL,
`test` text NOT NULL,
`execution_condition` int(11) NOT NULL,
`defaultworkflow` int(1) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`filtersavedinnew` int(1) DEFAULT NULL,
`schtypeid` int(10) DEFAULT NULL,
`schdayofmonth` varchar(100) DEFAULT NULL,
`schdayofweek` varchar(100) DEFAULT NULL,
`schannualdates` varchar(500) DEFAULT NULL,
`schtime` varchar(50) DEFAULT NULL,
`nexttrigger_time` datetime DEFAULT NULL,
`status` tinyint(1) DEFAULT 1,
`workflowname` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `com_vtiger_workflows`
--
INSERT IGNORE INTO `com_vtiger_workflows` (`workflow_id`, `module_name`, `summary`, `test`, `execution_condition`, `defaultworkflow`, `type`, `filtersavedinnew`, `schtypeid`, `schdayofmonth`, `schdayofweek`, `schannualdates`, `schtime`, `nexttrigger_time`, `status`, `workflowname`) VALUES
(1, 'Invoice', 'UpdateInventoryProducts On Every Save', '[{\"fieldname\":\"subject\",\"operation\":\"does not contain\",\"value\":\"`!`\"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'UpdateInventoryProducts On Every Save'),
(2, 'Accounts', 'Send Email to user when Notifyowner is True', '[{\"fieldname\":\"notify_owner\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 2, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to user when Notifyowner is True'),
(3, 'Contacts', 'Send Email to user when Notifyowner is True', '[{\"fieldname\":\"notify_owner\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 2, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to user when Notifyowner is True'),
(4, 'Contacts', 'Send Email to user when Portal User is True', '[{\"fieldname\":\"portal\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"email\",\"operation\":\"is not empty\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Send Email to user when Portal User is True'),
(5, 'Potentials', 'Send Email to users on Potential creation', '[]', 1, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to users on Potential creation'),
(6, 'Contacts', 'Workflow for Contact Creation or Modification', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Contact Creation or Modification'),
(7, 'HelpDesk', 'Ticket Creation From Portal : Send Email to Record Owner and Contact', '[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":1,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Ticket Creation From Portal : Send Email to Record Owner and Contact'),
(9, 'HelpDesk', 'Send Email to Contact on Ticket Update', '[{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Contact on Ticket Update'),
(10, 'Events', 'Workflow for Events when Send Notification is True', '[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Events when Send Notification is True'),
(11, 'Calendar', 'Workflow for Calendar Todos when Send Notification is True', '[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Calendar Todos when Send Notification is True'),
(12, 'Potentials', 'Calculate or Update forecast amount', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Calculate or Update forecast amount'),
(13, 'Events', 'Workflow for Events when Send Notification is True', '[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Events when Send Notification is True'),
(14, 'Calendar', 'Workflow for Calendar Todos when Send Notification is True', '[{\"fieldname\":\"sendnotification\",\"operation\":\"is\",\"value\":\"true:boolean\"}]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Workflow for Calendar Todos when Send Notification is True'),
(15, 'HelpDesk', 'Comment Added From CRM : Send Email to Organization', '[{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From CRM : Send Email to Organization'),
(16, 'PurchaseOrder', 'Update Inventory Products On Every Save', '[]', 3, 1, 'basic', 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Update Inventory Products On Every Save'),
(17, 'HelpDesk', 'Comment Added From Portal : Send Email to Record Owner', '[{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Comment Added From Portal : Send Email to Record Owner'),
(18, 'HelpDesk', 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User', '[{\"fieldname\":\"(contact_id : (Contacts) portal)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User'),
(19, 'HelpDesk', 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User', '[{\"fieldname\":\"(contact_id : (Contacts) portal)\",\"operation\":\"is\",\"value\":\"1\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"_VT_add_comment\",\"operation\":\"is added\",\"value\":\"\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User'),
(20, 'HelpDesk', 'Send Email to Record Owner on Ticket Update', '[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"assigned_user_id\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Record Owner on Ticket Update'),
(21, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Record Owner', '[{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Record Owner'),
(22, 'HelpDesk', 'Send Email to Organization on Ticket Update', '[{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":0,\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":0},{\"fieldname\":\"ticketstatus\",\"operation\":\"has changed to\",\"value\":\"Closed\",\"valuetype\":\"rawtext\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"solution\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"},{\"fieldname\":\"description\",\"operation\":\"has changed\",\"value\":\"\",\"valuetype\":\"\",\"joincondition\":\"or\",\"groupjoin\":\"and\",\"groupid\":\"1\"}]', 3, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Send Email to Organization on Ticket Update'),
(23, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Organization', '[{\"fieldname\":\"(parent_id : (Accounts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Organization'),
(24, 'HelpDesk', 'Ticket Creation From CRM : Send Email to Contact', '[{\"fieldname\":\"(contact_id : (Contacts) emailoptout)\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"and\",\"groupjoin\":\"and\",\"groupid\":\"0\"},{\"fieldname\":\"from_portal\",\"operation\":\"is\",\"value\":\"0\",\"valuetype\":\"rawtext\",\"joincondition\":\"\",\"groupjoin\":\"and\",\"groupid\":\"0\"}]', 1, 1, 'basic', 6, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'Ticket Creation From CRM : Send Email to Contact');
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflows_seq`
--
DROP TABLE IF EXISTS `com_vtiger_workflows_seq`;
CREATE TABLE `com_vtiger_workflows_seq` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `com_vtiger_workflows_seq`
--
INSERT IGNORE INTO `com_vtiger_workflows_seq` (`id`) VALUES
(24);
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflowtasks`
--
DROP TABLE IF EXISTS `com_vtiger_workflowtasks`;
CREATE TABLE `com_vtiger_workflowtasks` (
`task_id` int(11) NOT NULL,
`workflow_id` int(11) DEFAULT NULL,
`summary` varchar(400) NOT NULL,
`task` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `com_vtiger_workflowtasks`
--
INSERT IGNORE INTO `com_vtiger_workflowtasks` (`task_id`, `workflow_id`, `summary`, `task`) VALUES
(1, 1, '', 'O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:1;s:7:\"summary\";s:0:\"\";s:6:\"active\";b:1;s:10:\"methodName\";s:15:\"UpdateInventory\";s:2:\"id\";i:1;}'),
(2, 2, 'An account has been created ', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"2\";s:7:\"summary\";s:28:\"An account has been created \";s:6:\"active\";s:1:\"1\";s:10:\"methodName\";s:11:\"NotifyOwner\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:26:\"Regarding Account Creation\";s:7:\"content\";s:297:\"An Account has been assigned to you on Gouya
Details of account are :
AccountId:$account_no
AccountName:$accountname
Rating:$rating
Industry:$industry
AccountType:$accounttype
Description:$description
Thank You
Admin\";s:2:\"id\";s:1:\"2\";}'),
(3, 3, 'An contact has been created ', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"3\";s:7:\"summary\";s:28:\"An contact has been created \";s:6:\"active\";s:1:\"1\";s:10:\"methodName\";s:11:\"NotifyOwner\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:26:\"Regarding Contact Creation\";s:7:\"content\";s:301:\"An Contact has been assigned to you on Gouya
Details of Contact are :
Contact Id:$contact_no
LastName:$lastname
FirstName:$firstname
Lead Source:$leadsource
Department:$department
Description:$description
Thank You
Admin\";s:2:\"id\";s:1:\"3\";}'),
(4, 4, 'Email Customer Portal Login Details', 'O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:4;s:7:\"summary\";s:35:\"Email Customer Portal Login Details\";s:6:\"active\";b:1;s:10:\"methodName\";s:22:\"SendPortalLoginDetails\";s:2:\"id\";i:4;}'),
(5, 5, 'An Potential has been created ', 'O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"5\";s:7:\"summary\";s:30:\"An Potential has been created \";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:30:\"Regarding Potential Assignment\";s:7:\"content\";s:338:\"An Potential has been assigned to you on Gouya
Details of Potential are :
Potential No:$potential_no
Potential Name:$potentialname
Amount:$amount
Expected Close Date:$closingdate ($_DATE_FORMAT_)
Type:$opportunity_type
Description :$description
Thank You
Admin\";s:2:\"id\";s:1:\"5\";}'),
(6, 6, 'An contact has been created ', 'O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:1:\"6\";s:7:\"summary\";s:28:\"An contact has been created \";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:28:\"Regarding Contact Assignment\";s:7:\"content\";s:380:\"An Contact has been assigned to you on Gouya
Details of Contact are :
Contact Id:$contact_no
LastName:$lastname
FirstName:$firstname
Lead Source:$leadsource
Department:$department
Description:$description
And CustomerPortal Login Details is sent to the EmailID :-$email
Thank You
Admin\";s:2:\"id\";s:1:\"6\";}'),
(7, 7, 'Notify Related Contact when Ticket is created from Portal', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:57:\"Notify Related Contact when Ticket is created from Portal\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:1:\"7\";s:10:\"workflowId\";s:1:\"7\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:93:\"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:158:\"Ticket No : $ticket_no
\n Ticket ID : $(general : (__VtigerMeta__) recordId)
\n Ticket Title : $ticket_title
\n $description\";}'),
(10, 9, 'Send Email to Contact on Ticket Update', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:38:\"Send Email to Contact on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"10\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:624:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";s:10:\"workflowId\";s:1:\"9\";}'),
(13, 12, 'update forecast amount', 'O:18:\"VTUpdateFieldsTask\":7:{s:18:\"executeImmediately\";b:1;s:43:\"\0VTUpdateFieldsTask\0referenceFieldFocusList\";a:0:{}s:10:\"workflowId\";i:12;s:7:\"summary\";s:22:\"update forecast amount\";s:6:\"active\";b:1;s:19:\"field_value_mapping\";s:95:\"[{\"fieldname\":\"forecast_amount\",\"valuetype\":\"expression\",\"value\":\"amount * probability / 100\"}]\";s:2:\"id\";i:13;}'),
(14, 13, 'Send Notification Email to Record Owner', 'O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:2:\"13\";s:7:\"summary\";s:39:\"Send Notification Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:17:\"Event : $subject\";s:7:\"content\";s:771:\"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,
Activity Notification Details:
Subject : $subject
Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))
End date and time : $due_date ($(general : (__VtigerMeta__) usertimezone))
Status : $eventstatus
Priority : $taskpriority
Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname)
Contacts List : $contact_id
Location : $location
Description : $description\";s:2:\"id\";s:2:\"14\";}'),
(15, 14, 'Send Notification Email to Record Owner', 'O:11:\"VTEmailTask\":8:{s:18:\"executeImmediately\";s:0:\"\";s:10:\"workflowId\";s:2:\"14\";s:7:\"summary\";s:39:\"Send Notification Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:9:\"recepient\";s:36:\"$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:16:\"Task : $subject\";s:7:\"content\";s:689:\"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,
Task Notification Details:
Subject : $subject
Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))
End date and time : $due_date ($_DATE_FORMAT_)
Status : $taskstatus
Priority : $taskpriority
Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname)
Contacts List : $contact_id
Description : $description\";s:2:\"id\";s:2:\"15\";}'),
(18, 16, 'Update Inventory Products', 'O:18:\"VTEntityMethodTask\":6:{s:18:\"executeImmediately\";b:1;s:10:\"workflowId\";i:16;s:7:\"summary\";s:25:\"Update Inventory Products\";s:6:\"active\";b:1;s:10:\"methodName\";s:15:\"UpdateInventory\";s:2:\"id\";i:18;}'),
(19, 17, 'Comment Added From Portal : Send Email to Record Owner', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:54:\"Comment Added From Portal : Send Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"19\";s:10:\"workflowId\";s:2:\"17\";s:9:\"fromEmail\";s:112:\"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(contact_id : (Contacts) email)>\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:92:\"Respond to Ticket ID## $(general : (__VtigerMeta__) recordId) ## in Customer Portal - URGENT\";s:7:\"content\";s:325:\"Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),
\n Customer has provided the following additional information to your reply:
\n $lastComment
\n Kindly respond to above ticket at the earliest.
\n Regards
Support Administrator\";}'),
(20, 18, 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:82:\"Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"20\";s:10:\"workflowId\";s:2:\"18\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:514:\"Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";}'),
(21, 19, 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:76:\"Comment Added From CRM : Send Email to Contact, where Contact is Portal User\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"21\";s:10:\"workflowId\";s:2:\"19\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:547:\"Ticket No : $ticket_no
\n Ticket Id : $(general : (__VtigerMeta__) recordId)
\n Subject : $ticket_title
\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),
\n There is a reply to $ticket_title in the \"Customer Portal\" at VTiger.\n You can use the following link to view the replies made:
\n Ticket Details
\n Thanks
$(general : (__VtigerMeta__) supportName)\";}'),
(22, 15, 'Comment Added From CRM : Send Email to Organization', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:51:\"Comment Added From CRM : Send Email to Organization\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"22\";s:10:\"workflowId\";s:2:\"15\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:34:\",$(parent_id : (Accounts) email1),\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(parent_id : (Accounts) accountname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";}'),
(23, 7, 'Notify Record Owner when Ticket is created from Portal', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:54:\"Notify Record Owner when Ticket is created from Portal\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"23\";s:10:\"workflowId\";s:1:\"7\";s:9:\"fromEmail\";s:124:\"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:93:\"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:158:\"Ticket No : $ticket_no
\n Ticket ID : $(general : (__VtigerMeta__) recordId)
\n Ticket Title : $ticket_title
\n $description\";}'),
(24, 20, 'Send Email to Record Owner on Ticket Update', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:43:\"Send Email to Record Owner on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"24\";s:10:\"workflowId\";s:2:\"20\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:40:\"Ticket Number : $ticket_no $ticket_title\";s:7:\"content\";s:596:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution\n $allComments
\n Regards
Support Administrator\";}'),
(25, 21, 'Ticket Creation From CRM : Send Email to Record Owner', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:53:\"Ticket Creation From CRM : Send Email to Record Owner\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"25\";s:10:\"workflowId\";s:2:\"21\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:37:\",$(assigned_user_id : (Users) email1)\";s:7:\"subject\";s:40:\"Ticket Number : $ticket_no $ticket_title\";s:7:\"content\";s:596:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution\n $allComments
\n Regards
Support Administrator\";}'),
(26, 22, 'Send Email to Organization on Ticket Update', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:43:\"Send Email to Organization on Ticket Update\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"26\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(parent_id : (Accounts) email1)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(parent_id : (Accounts) accountname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";s:10:\"workflowId\";s:2:\"22\";}'),
(27, 23, 'Ticket Creation From CRM : Send Email to Organization', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:53:\"Ticket Creation From CRM : Send Email to Organization\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"27\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(parent_id : (Accounts) email1)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:589:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(parent_id : (Accounts) accountname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";s:10:\"workflowId\";s:2:\"23\";}'),
(28, 24, 'Ticket Creation From CRM : Send Email to Contact', 'O:11:\"VTEmailTask\":9:{s:18:\"executeImmediately\";s:1:\"0\";s:7:\"summary\";s:48:\"Ticket Creation From CRM : Send Email to Contact\";s:6:\"active\";s:1:\"1\";s:2:\"id\";s:2:\"28\";s:9:\"fromEmail\";s:93:\"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>\";s:9:\"recepient\";s:33:\",$(contact_id : (Contacts) email)\";s:7:\"subject\";s:79:\"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title\";s:7:\"content\";s:624:\"Ticket ID : $(general : (__VtigerMeta__) recordId)
Ticket Title : $ticket_title
\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),
\n The Ticket is replied the details are :
\n Ticket No : $ticket_no
\n Status : $ticketstatus
\n Category : $ticketcategories
\n Severity : $ticketseverities
\n Priority : $ticketpriorities
\n Description :
$description
\n Solution :
$solution
\n The comments are :
\n $allComments
\n Regards
Support Administrator\";s:10:\"workflowId\";s:2:\"24\";}');
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod`
--
DROP TABLE IF EXISTS `com_vtiger_workflowtasks_entitymethod`;
CREATE TABLE `com_vtiger_workflowtasks_entitymethod` (
`workflowtasks_entitymethod_id` int(11) NOT NULL,
`module_name` varchar(100) DEFAULT NULL,
`method_name` varchar(100) DEFAULT NULL,
`function_path` varchar(400) DEFAULT NULL,
`function_name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod`
--
INSERT IGNORE INTO `com_vtiger_workflowtasks_entitymethod` (`workflowtasks_entitymethod_id`, `module_name`, `method_name`, `function_path`, `function_name`) VALUES
(1, 'SalesOrder', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel'),
(2, 'Invoice', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel'),
(3, 'Contacts', 'SendPortalLoginDetails', 'modules/Contacts/ContactsHandler.php', 'Contacts_sendCustomerPortalLoginDetails'),
(4, 'HelpDesk', 'NotifyOnPortalTicketCreation', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_nofifyOnPortalTicketCreation'),
(5, 'HelpDesk', 'NotifyOnPortalTicketComment', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyOnPortalTicketComment'),
(6, 'HelpDesk', 'NotifyOwnerOnTicketChange', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyOwnerOnTicketChange'),
(7, 'HelpDesk', 'NotifyParentOnTicketChange', 'modules/HelpDesk/HelpDeskHandler.php', 'HelpDesk_notifyParentOnTicketChange'),
(8, 'ModComments', 'CustomerCommentFromPortal', 'modules/ModComments/ModCommentsHandler.php', 'CustomerCommentFromPortal'),
(9, 'ModComments', 'TicketOwnerComments', 'modules/ModComments/ModCommentsHandler.php', 'TicketOwnerComments'),
(10, 'PurchaseOrder', 'UpdateInventory', 'include/InventoryHandler.php', 'handleInventoryProductRel');
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflowtasks_entitymethod_seq`
--
DROP TABLE IF EXISTS `com_vtiger_workflowtasks_entitymethod_seq`;
CREATE TABLE `com_vtiger_workflowtasks_entitymethod_seq` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `com_vtiger_workflowtasks_entitymethod_seq`
--
INSERT IGNORE INTO `com_vtiger_workflowtasks_entitymethod_seq` (`id`) VALUES
(10);
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflowtasks_seq`
--
DROP TABLE IF EXISTS `com_vtiger_workflowtasks_seq`;
CREATE TABLE `com_vtiger_workflowtasks_seq` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `com_vtiger_workflowtasks_seq`
--
INSERT IGNORE INTO `com_vtiger_workflowtasks_seq` (`id`) VALUES
(28);
-- --------------------------------------------------------
--
-- Table structure for table `com_vtiger_workflowtask_queue`
--
DROP TABLE IF EXISTS `com_vtiger_workflowtask_queue`;
CREATE TABLE `com_vtiger_workflowtask_queue` (
`task_id` int(11) DEFAULT NULL,
`entity_id` varchar(100) DEFAULT NULL,
`do_after` int(11) DEFAULT NULL,
`relatedinfo` varchar(255) DEFAULT NULL,
`task_contents` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `com_vtiger_workflowtask_queue`
--
INSERT IGNORE INTO `com_vtiger_workflowtask_queue` (`task_id`, `entity_id`, `do_after`, `relatedinfo`, `task_contents`) VALUES
(6, '12x11', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"hujiko Administrator\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON1<\\/b>
LastName:\\u0632\\u0627\\u0631\\u0639<\\/b>
FirstName:\\u0639\\u06cc\\u0633\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-
Thank You
Admin
\"}'),
(5, '13x2046', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Potential Assignment\",\"content\":\"An Potential has been assigned to you on vtigerCRM
Details of Potential are :
Potential No:POT9<\\/b>
Potential Name:\\u062a\\u0633\\u062a \\u0633\\u06cc\\u0633\\u062a\\u0645 - \\u0641\\u0631\\u0635\\u062a \\u06af\\u0648\\u06cc\\u0627<\\/b>
Amount:$45,000,000<\\/b>
Expected Close Date:07-27-2026 (mm-dd-yyyy)<\\/b>
Type:<\\/b>
Description :
Thank You
Admin
\"}'),
(5, '13x2049', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Potential Assignment\",\"content\":\"An Potential has been assigned to you on vtigerCRM
Details of Potential are :
Potential No:POT12<\\/b>
Potential Name:\\u0646\\u0645\\u0648\\u0646\\u0647 \\u062a\\u0633\\u062a B - \\u0641\\u0631\\u0648\\u0634 \\u0645\\u0648\\u0641\\u0642 \\u062a\\u06cc\\u0631<\\/b>
Amount:$60,000,000<\\/b>
Expected Close Date:07-11-2026 (mm-dd-yyyy)<\\/b>
Type:\\u0645\\u0634\\u062a\\u0631\\u06cc \\u0645\\u0648\\u062c\\u0648\\u062f \\/ \\u062a\\u0645\\u062f\\u06cc\\u062f<\\/b>
Description :
Thank You
Admin
\"}'),
(5, '13x2050', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Potential Assignment\",\"content\":\"An Potential has been assigned to you on vtigerCRM
Details of Potential are :
Potential No:POT13<\\/b>
Potential Name:\\u0646\\u0645\\u0648\\u0646\\u0647 \\u062a\\u0633\\u062a C - \\u0633\\u0631\\u0631\\u0633\\u06cc\\u062f \\u06af\\u0630\\u0634\\u062a\\u0647<\\/b>
Amount:$33,000,000<\\/b>
Expected Close Date:05-31-2026 (mm-dd-yyyy)<\\/b>
Type:<\\/b>
Description :\\u0646\\u0645\\u0648\\u0646\\u0647 \\u0628\\u0631\\u0627\\u06cc \\u062a\\u0633\\u062a \\u0647\\u0634\\u062f\\u0627\\u0631 \\u0633\\u0631\\u0631\\u0633\\u06cc\\u062f
Thank You
Admin
\"}'),
(6, '12x2066', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON2<\\/b>
LastName:\\u0645\\u062d\\u0645\\u062f\\u06cc<\\/b>
FirstName:\\u0639\\u0644\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-
Thank You
Admin
\"}'),
(6, '12x2067', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON3<\\/b>
LastName:\\u0627\\u062d\\u0645\\u062f\\u06cc<\\/b>
FirstName:\\u0633\\u0627\\u0631\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-
Thank You
Admin
\"}'),
(6, '12x2068', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON4<\\/b>
LastName:\\u06a9\\u0631\\u06cc\\u0645\\u06cc<\\/b>
FirstName:\\u0631\\u0636\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-
Thank You
Admin
\"}'),
(6, '12x2069', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON5<\\/b>
LastName:\\u0645\\u062d\\u0645\\u062f\\u06cc\\u0627\\u0646<\\/b>
FirstName:\\u0631\\u0636\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_mgr@example.local
Thank You
Admin
\"}'),
(6, '12x2070', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON6<\\/b>
LastName:\\u06a9\\u0631\\u06cc\\u0645\\u06cc<\\/b>
FirstName:\\u0639\\u0644\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_sup1@example.local
Thank You
Admin
\"}'),
(6, '12x2071', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON7<\\/b>
LastName:\\u0642\\u0627\\u0633\\u0645\\u06cc<\\/b>
FirstName:\\u0646\\u06cc\\u0645\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp1@example.local
Thank You
Admin
\"}'),
(6, '12x2072', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON8<\\/b>
LastName:\\u0645\\u0631\\u0627\\u062f\\u06cc<\\/b>
FirstName:\\u0632\\u0647\\u0631\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp2@example.local
Thank You
Admin
\"}'),
(6, '12x2073', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON9<\\/b>
LastName:\\u0635\\u0627\\u062f\\u0642\\u06cc<\\/b>
FirstName:\\u0627\\u0645\\u06cc\\u0631<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp3@example.local
Thank You
Admin
\"}'),
(6, '12x2074', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON10<\\/b>
LastName:\\u06a9\\u0627\\u0638\\u0645\\u06cc<\\/b>
FirstName:\\u0641\\u0627\\u0637\\u0645\\u0647<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp4@example.local
Thank You
Admin
\"}'),
(6, '12x2075', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON11<\\/b>
LastName:\\u06cc\\u0648\\u0633\\u0641\\u06cc<\\/b>
FirstName:\\u0633\\u06cc\\u0646\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp5@example.local
Thank You
Admin
\"}'),
(6, '12x2076', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON12<\\/b>
LastName:\\u062c\\u0639\\u0641\\u0631\\u06cc<\\/b>
FirstName:\\u0627\\u0644\\u0647\\u0627\\u0645<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp6@example.local
Thank You
Admin
\"}'),
(6, '12x2077', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON13<\\/b>
LastName:\\u0631\\u0636\\u0627\\u06cc\\u06cc<\\/b>
FirstName:\\u062d\\u0633\\u0646<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_sup3@example.local
Thank You
Admin
\"}'),
(6, '12x2078', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON14<\\/b>
LastName:\\u0627\\u06a9\\u0628\\u0631\\u06cc<\\/b>
FirstName:\\u0628\\u0647\\u0631\\u0627\\u0645<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp7@example.local
Thank You
Admin
\"}'),
(6, '12x2079', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON15<\\/b>
LastName:\\u0634\\u0631\\u06cc\\u0641\\u06cc<\\/b>
FirstName:\\u0646\\u06af\\u0627\\u0631<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp8@example.local
Thank You
Admin
\"}'),
(6, '12x2080', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON16<\\/b>
LastName:\\u0628\\u0627\\u0628\\u0627\\u06cc\\u06cc<\\/b>
FirstName:\\u067e\\u06cc\\u0645\\u0627\\u0646<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp9@example.local
Thank You
Admin
\"}'),
(6, '12x2081', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON17<\\/b>
LastName:\\u062d\\u0633\\u06cc\\u0646\\u06cc<\\/b>
FirstName:\\u0645\\u0631\\u06cc\\u0645<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_sup4@example.local
Thank You
Admin
\"}'),
(6, '12x2082', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON18<\\/b>
LastName:\\u0631\\u0633\\u062a\\u0645\\u06cc<\\/b>
FirstName:\\u0645\\u06cc\\u0646\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp10@example.local
Thank You
Admin
\"}'),
(6, '12x2083', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON19<\\/b>
LastName:\\u0639\\u0628\\u0627\\u0633\\u06cc<\\/b>
FirstName:\\u06a9\\u06cc\\u0627\\u0646<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp11@example.local
Thank You
Admin
\"}'),
(6, '12x2084', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON20<\\/b>
LastName:\\u0646\\u0627\\u062f\\u0631\\u06cc<\\/b>
FirstName:\\u0631\\u0647\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp12@example.local
Thank You
Admin
\"}'),
(6, '12x2085', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON21<\\/b>
LastName:\\u0646\\u0648\\u0631\\u06cc<\\/b>
FirstName:\\u06a9\\u0627\\u0648\\u0647<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_sup5@example.local
Thank You
Admin
\"}'),
(6, '12x2086', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON22<\\/b>
LastName:\\u0641\\u0644\\u0627\\u062d\\u06cc<\\/b>
FirstName:\\u0622\\u0631\\u0634<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp13@example.local
Thank You
Admin
\"}'),
(6, '12x2087', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON23<\\/b>
LastName:\\u0632\\u0627\\u0631\\u0639<\\/b>
FirstName:\\u0633\\u062d\\u0631<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp14@example.local
Thank You
Admin
\"}'),
(6, '12x2088', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON24<\\/b>
LastName:\\u0645\\u062d\\u0645\\u0648\\u062f\\u06cc<\\/b>
FirstName:\\u0648\\u062d\\u06cc\\u062f<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_emp15@example.local
Thank You
Admin
\"}'),
(6, '12x2089', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON25<\\/b>
LastName:\\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631<\\/b>
FirstName:\\u062d\\u0633\\u06cc\\u0646<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1 [user:admin]<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-hossein.fgh@gmail.com
Thank You
Admin
\"}'),
(6, '12x2090', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON26<\\/b>
LastName:\\u0627\\u062d\\u0645\\u062f\\u06cc<\\/b>
FirstName:\\u0633\\u0627\\u0631\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SYNC_FROM_USERS v1 [user:kpiseed_sup2]<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-kpiseed_sup2@example.local
Thank You
Admin
\"}'),
(6, '12x2091', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON27<\\/b>
LastName:\\u0645\\u062d\\u0645\\u062f\\u06cc (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u062e\\u0627\\u0646\\u0645 \\u0627\\u0641\\u0631\\u0648\\u0632<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-afrooz@test.com
Thank You
Admin
\"}'),
(25, '17x2092', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"your-support name\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\",hossein.fgh@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Ticket Number : TT1 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u067e\\u0634\\u062a\\u06cc\\u0628\\u0627\\u0646\\u06cc \\u0646\\u0635\\u0628 (\\u0645\\u062b\\u0627\\u0644)\",\"content\":\"Ticket ID : 2092
Ticket Title : \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u067e\\u0634\\u062a\\u06cc\\u0628\\u0627\\u0646\\u06cc \\u0646\\u0635\\u0628 (\\u0645\\u062b\\u0627\\u0644)
\\n\\t\\t\\t\\t\\t\\t\\t\\tDear \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631 \\u062d\\u0633\\u06cc\\u0646,
\\n\\t\\t\\t\\t\\t\\t\\t\\tThe Ticket is replied the details are :
\\n\\t\\t\\t\\t\\t\\t\\t\\tTicket No : TT1
\\n\\t\\t\\t\\t\\t\\t\\t\\tStatus : Open
\\n\\t\\t\\t\\t\\t\\t\\t\\tCategory :
\\n\\t\\t\\t\\t\\t\\t\\t\\tSeverity :
\\n\\t\\t\\t\\t\\t\\t\\t\\tPriority : High
\\n\\t\\t\\t\\t\\t\\t\\t\\tDescription :
SEED_GOOYA_TICKETS v1
\\n\\t\\t\\t\\t\\t\\t\\t\\tSolution :
\\n\\t\\t\\t\\t\\t\\t\\t\\t
\\n\\t\\t\\t\\t\\t\\t\\t\\tRegards
Support Administrator
\"}'),
(6, '12x2093', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON28<\\/b>
LastName:\\u0646\\u06cc\\u06a9 \\u0631\\u0641\\u062a\\u0627\\u0631 (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u062e\\u0627\\u0646\\u0645 \\u0631\\u0648\\u06cc\\u0627<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-roya@test.com
Thank You
Admin
\"}'),
(6, '12x2095', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON29<\\/b>
LastName:\\u0642\\u0627\\u0636\\u06cc (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0645\\u0647\\u0646\\u062f\\u0633<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-ghazi@test.com
Thank You
Admin
\"}'),
(6, '12x2096', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON30<\\/b>
LastName:\\u0641\\u0631\\u0648\\u0632\\u0634 (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0622\\u0642\\u0627\\u06cc \\u0645\\u0647\\u062f\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-forouzesh@test.com
Thank You
Admin
\"}'),
(25, '17x2097', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"your-support name\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\",hossein.fgh@gmail.com,a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Ticket Number : TT3 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u0622\\u0645\\u0648\\u0632\\u0634 \\u06a9\\u0627\\u0631\\u0628\\u0631\\u06cc (\\u0645\\u062b\\u0627\\u0644)\",\"content\":\"Ticket ID : 2097
Ticket Title : \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u0622\\u0645\\u0648\\u0632\\u0634 \\u06a9\\u0627\\u0631\\u0628\\u0631\\u06cc (\\u0645\\u062b\\u0627\\u0644)
\\n\\t\\t\\t\\t\\t\\t\\t\\tDear \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631,\\u0632\\u0627\\u0631\\u0639 \\u062d\\u0633\\u06cc\\u0646,\\u0639\\u06cc\\u0633\\u06cc,
\\n\\t\\t\\t\\t\\t\\t\\t\\tThe Ticket is replied the details are :
\\n\\t\\t\\t\\t\\t\\t\\t\\tTicket No : TT3
\\n\\t\\t\\t\\t\\t\\t\\t\\tStatus : Wait For Response
\\n\\t\\t\\t\\t\\t\\t\\t\\tCategory :
\\n\\t\\t\\t\\t\\t\\t\\t\\tSeverity :
\\n\\t\\t\\t\\t\\t\\t\\t\\tPriority : Normal
\\n\\t\\t\\t\\t\\t\\t\\t\\tDescription :
SEED_GOOYA_TICKETS v1
\\n\\t\\t\\t\\t\\t\\t\\t\\tSolution :
\\n\\t\\t\\t\\t\\t\\t\\t\\t
\\n\\t\\t\\t\\t\\t\\t\\t\\tRegards
Support Administrator
\"}'),
(6, '12x2098', 0, 'false', '{\"fromEmail\":\"kpiseed_mgr@example.local\",\"fromName\":\"\\u062d\\u0633\\u06cc\\u0646 \\u0641\\u063a\\u0627\\u0646 \\u067e\\u0648\\u0631\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"kpiseed_mgr@example.local\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON31<\\/b>
LastName:\\u06a9\\u0627\\u0628\\u06cc\\u0646\\u06cc (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0622\\u0642\\u0627\\u06cc \\u0645\\u062d\\u0645\\u062f<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-ayini@test.com
Thank You
Admin
\"}'),
(6, '12x2100', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON32<\\/b>
LastName:\\u0632\\u0627\\u0645\\u06cc\\u0627\\u062f (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0645\\u0647\\u0646\\u062f\\u0633<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-zamyad@test.com
Thank You
Admin
\"}'),
(6, '12x2102', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON33<\\/b>
LastName:\\u0639\\u0628\\u0627\\u0633\\u06cc (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0622\\u0642\\u0627\\u06cc \\u063a\\u0644\\u0627\\u0645\\u0639\\u0644\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-abbasi@test.com
Thank You
Admin
\"}'),
(25, '17x2101', 0, 'false', '{\"fromEmail\":\"hossein.fgh@gmail.com\",\"fromName\":\"your-support name\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\",a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Ticket Number : TT5 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u06af\\u0632\\u0627\\u0631\\u0634 \\u0627\\u062e\\u062a\\u0635\\u0627\\u0635\\u06cc (\\u0645\\u062b\\u0627\\u0644)\",\"content\":\"Ticket ID : 2101
Ticket Title : \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u06af\\u0632\\u0627\\u0631\\u0634 \\u0627\\u062e\\u062a\\u0635\\u0627\\u0635\\u06cc (\\u0645\\u062b\\u0627\\u0644)
\\n\\t\\t\\t\\t\\t\\t\\t\\tDear \\u0632\\u0627\\u0631\\u0639 \\u0639\\u06cc\\u0633\\u06cc,
\\n\\t\\t\\t\\t\\t\\t\\t\\tThe Ticket is replied the details are :
\\n\\t\\t\\t\\t\\t\\t\\t\\tTicket No : TT5
\\n\\t\\t\\t\\t\\t\\t\\t\\tStatus : Open
\\n\\t\\t\\t\\t\\t\\t\\t\\tCategory :
\\n\\t\\t\\t\\t\\t\\t\\t\\tSeverity :
\\n\\t\\t\\t\\t\\t\\t\\t\\tPriority : \\u067e\\u0627\\u06cc\\u06cc\\u0646
\\n\\t\\t\\t\\t\\t\\t\\t\\tDescription :
SEED_GOOYA_TICKETS v1
\\n\\t\\t\\t\\t\\t\\t\\t\\tSolution :
\\n\\t\\t\\t\\t\\t\\t\\t\\t
\\n\\t\\t\\t\\t\\t\\t\\t\\tRegards
Support Administrator
\"}'),
(6, '12x2103', 0, 'false', '{\"fromEmail\":\"a@gmail.com\",\"fromName\":\"\\u0639\\u06cc\\u0633\\u06cc \\u0632\\u0627\\u0631\\u0639\",\"replyTo\":\"hossein.fgh@gmail.com\",\"toEmail\":\"a@gmail.com\",\"ccEmail\":\"\",\"bccEmail\":\"\",\"subject\":\"Regarding Contact Assignment\",\"content\":\"An Contact has been assigned to you on vtigerCRM
Details of Contact are :
Contact Id:CON34<\\/b>
LastName:\\u0645\\u062d\\u0645\\u062f\\u0622\\u0628\\u0627\\u062f\\u06cc (\\u0645\\u062b\\u0627\\u0644)<\\/b>
FirstName:\\u0622\\u0642\\u0627\\u06cc<\\/b>
Lead Source:<\\/b>
Department:<\\/b>
Description:SEED_GOOYA_CONTACTS v1<\\/b>
And CustomerPortal Login Details<\\/b> is sent to the EmailID :-mohammadabadi@test.com