-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 15, 2023 at 06:14 AM
-- Server version: 8.0.31
-- PHP Version: 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;


/*!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: `expremit_live_db`
--

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

--
-- Table structure for table `tbl_esar`
--

DROP TABLE IF EXISTS `tbl_esar`;
CREATE TABLE IF NOT EXISTS `tbl_esar` (
  `mid` int NOT NULL AUTO_INCREMENT,
  `agt_id` int NOT NULL,
  `sub_agt_id` int NOT NULL,
  `staff_id` varchar(50) DEFAULT NULL,
  `sar_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `sar_date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `trans_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `cust_id` int DEFAULT '0',
  `cust_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `cust_dob` varchar(50) DEFAULT NULL,
  `cust_phone` varchar(50) DEFAULT NULL,
  `cust_address` varchar(250) DEFAULT NULL,
  `suspect_reason` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `suspect_nature` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `suspect_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `agt_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `agt_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `agt_address` varchar(250) DEFAULT NULL,
  `staff_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `staff_position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `doc_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `doc_file` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `report_upd_by` varchar(200) DEFAULT NULL,
  `action_detail` text,
  `case_officer` varchar(50) DEFAULT NULL,
  `char_of_trans` text,
  `other_char_of_trans` text,
  `ind_of_susp` text,
  `other_ind_of_susp` text,
  `further_action` text,
  `other_further_action` text,
  `is_reported` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `reported_no_remarks` text,
  `trans_status` varchar(30) DEFAULT NULL,
  `operration_req` varchar(50) DEFAULT NULL,
  `report_auth` varchar(50) DEFAULT NULL,
  `report_ref` varchar(50) DEFAULT NULL,
  `report_date_time` varchar(50) DEFAULT NULL,
  `report_channel` varchar(50) DEFAULT NULL,
  `pstatus` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `tbl_esar`
--

INSERT INTO `tbl_esar` (`mid`, `agt_id`, `sub_agt_id`, `staff_id`, `sar_no`, `sar_date`, `trans_no`, `cust_id`, `cust_name`, `cust_dob`, `cust_phone`, `cust_address`, `suspect_reason`, `suspect_nature`, `suspect_detail`, `agt_name`, `agt_phone`, `agt_address`, `staff_name`, `staff_position`, `doc_name`, `doc_file`, `report_upd_by`, `action_detail`, `case_officer`, `char_of_trans`, `other_char_of_trans`, `ind_of_susp`, `other_ind_of_susp`, `further_action`, `other_further_action`, `is_reported`, `reported_no_remarks`, `trans_status`, `operration_req`, `report_auth`, `report_ref`, `report_date_time`, `report_channel`, `pstatus`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '0', '4112', '2023-03-15', '0373062632148', 417, 'ABDUL AWAN', '1986-01-20', '07400220023', '9 ORCHARD STREET', 'RUPH BEHAVIOUR', 'CUSTOMER BEHAVIOUR', 'TESTING', 'Active Web Solutions', '000000000000', 'BIRMINGHAM', 'Shahzad Akbar', '', '', NULL, '', '', 'AMIR ALI', 'Computer Intrusion~Terrorist Financing', '', 'Exchange of big amounts of small denomination bills for large denomination bills (refining)~Large or recurrent foreign exchange operations', '', 'Do nothing', '', 'Yes', 'TESTING', 'Completed', 'Money Transfer', 'HMRC', '65456214', '20-02-2023', 'EMAIL', 'Inprocess', '2023-03-15 13:21:36', '2023-06-12 10:45:35'),
(2, 1, 1, '0', '4113', '2023-03-17', '', 0, 'Amir Ali', '01-01-1994', '07400220023', '9 ORCHARD STREET', 'RUPH BEHAVIOUR', 'CUSTOMER BEHAVIOUR', 'TESTING', 'Active Web Solutions', '000000000000', 'BIRMINGHAM', 'Shahzad Akbar', '', 'TESTING', 'esar_1_2.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Pending', '2023-03-17 10:04:24', NULL),
(3, 1, 1, '0', '4114', '2023-06-07', '0373062632186', 1, 'SHAHZAD AKBAR', '01-01-1990', '69753215648', 'KAREEM PLAZA OFFICE #104', 'RUPH BEHAVIOUR', 'CUSTOMER BEHAVIOUR', 'TESTING', 'Active Web Solutions', '000000000000', 'BIRMINGHAM', 'Shahzad Akbar', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Pending', '2023-06-07 11:33:27', NULL);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
