maatify/cron-email

PHP library for Cron Email handler, known by our team

1.0.0033 2024-11-05 08:34 UTC

Requires

• php: >=8.0
• ext-openssl: *
• maatify/db-model-v3: ^1.2
• maatify/functions: ^1.2
• maatify/json: ^1.1
• maatify/logger: ^1.0
• maatify/mailer: ^1.1
• maatify/open-ssl: ^1.0
• maatify/post-validator-v2: ^1.1
• maatify/queue-manager: ^1.0

proprietary

• Mohamed Abdulalim
• Ahmed Fawzy
• Mohaned Saeed Sami
• Ahmed Abdullah
• Elmokhtar Ahmed

• php
• email
• cron
• handler
• maatify.dev
• Cron Email handler

README

Installation

composer require maatify/cron-email

Database Structure

--
-- Database: `maatify`
--

-- --------------------------------------------------------

--
-- Table structure for table `cron_email`
--

CREATE TABLE `cron_email` (
      `cron_id` int(11) NOT NULL,
      `type_id` int(11) NOT NULL DEFAULT '1' COMMENT '1=messge; 2=confirm; 3=promotion',
      `ct_id` int(11) NOT NULL DEFAULT '0',
      `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
      `email` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
      `message` mediumtext COLLATE utf8mb4_unicode_ci,
      `subject` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
      `record_time` datetime NOT NULL DEFAULT '1900-01-01 00:00:00',
      `status` tinyint(1) NOT NULL DEFAULT '0',
      `sent_time` datetime NOT NULL DEFAULT '1900-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------

--
-- Table structure for table `cron_email_block`
--

CREATE TABLE `cron_email_block` (
  `block_id` int NOT NULL,
  `ct_id` int NOT NULL DEFAULT '0',
  `email` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `time` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
  `admin_id` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cron_email_off`
--

CREATE TABLE `cron_email_off` (
  `off_id` int NOT NULL,
  `ct_id` int NOT NULL DEFAULT '0',
  `email` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `time` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
  `admin_id` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cron_email`
--
ALTER TABLE `cron_email`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cron_email_block`
--
ALTER TABLE `cron_email_block`
  ADD PRIMARY KEY (`block_id`);

--
-- Indexes for table `cron_email_off`
--
ALTER TABLE `cron_email_off`
  ADD PRIMARY KEY (`off_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cron_email`
--
ALTER TABLE `cron_email`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_email_block`
--
ALTER TABLE `cron_email_block`
  MODIFY `block_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cron_email_off`
--
ALTER TABLE `cron_email_off`
  MODIFY `off_id` int NOT NULL AUTO_INCREMENT;
COMMIT;