-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `Bionick_pharma`
--

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

--
-- Table structure for table `admin_product_approval`
--

CREATE TABLE `admin_product_approval` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `variation` text DEFAULT NULL,
  `type` enum('add','edit','variation') DEFAULT 'variation',
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin_product_approval`
--

INSERT INTO `admin_product_approval` (`id`, `product_id`, `product_name`, `variation`, `type`, `status`, `created_at`) VALUES
(1, 79, 'Amlodipine/Valsartan/Hydroclorithazide 5mg/160mg/12.5mg Tabs', '{\"product_name\":\"Amlodipine\\/Valsartan\\/Hydroclorithazide 5mg\\/160mg\\/12.5mg Tabs\",\"generic_name\":\"Paracetamol 500mg\",\"brand_name\":\"\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-30\",\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-05-02\",\"registration_exp_date\":\"2026-05-03\",\"renewal_process_start\":null,\"qty\":\"100\",\"country_id\":\"11\",\"units_per_packet\":\"10\",\"price_per_packet\":\"100.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 11:45:24'),
(2, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 12:02:45'),
(3, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 12:06:52'),
(4, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"sxsc\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 12:17:31'),
(5, 57, 'Dolo 650', '{\"product_name\":\"Dolo 650\",\"generic_name\":\"Paracetamol 650mg\",\"brand_name\":\"Micro Labs\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"1\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"147\",\"country_id\":\"11\",\"units_per_packet\":\"30\",\"price_per_packet\":\"600.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 12:24:42'),
(6, 56, 'Paracip 500', '{\"product_name\":\"Paracip 500\",\"generic_name\":\"Paracetamol 500mg\",\"brand_name\":\"Cipla\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"24 months\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":\"2026-04-15\",\"renewal_process_start\":null,\"qty\":\"50\",\"country_id\":\"11\",\"units_per_packet\":\"20\",\"price_per_packet\":\"200.00\",\"gst_percent\":\"5\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-29 12:29:41'),
(7, 59, 'Azee 500', '{\"product_name\":\"Azee 500\",\"generic_name\":\"Azithromycin 500mg\",\"brand_name\":\"Cipla\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"DOSS-2026-001\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"zcxsc\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"67\",\"country_id\":\"11\",\"units_per_packet\":\"20\",\"price_per_packet\":\"300.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 04:33:45'),
(8, 0, 'Amlodipine/Valsartan/Hydroclorithazide 5mg/160mg/12.5mg Tabs', '{\"product_name\":\"Amlodipine\\/Valsartan\\/Hydroclorithazide 5mg\\/160mg\\/12.5mg Tabs\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"sdsc\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 04:45:27'),
(9, 0, 'Amlodipine/Valsartan/Hydroclorithazide 5mg/160mg/12.5mg Tabs', '{\"product_name\":\"Amlodipine\\/Valsartan\\/Hydroclorithazide 5mg\\/160mg\\/12.5mg Tabs\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"sdsc\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 04:58:02'),
(10, 0, 'Paracip 500', '{\"product_name\":\"Paracip 500\",\"generic_name\":\"Paracetamol 500mg\",\"brand_name\":\"Cipla\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":\"2026-04-15\",\"renewal_process_start\":null,\"qty\":\"50\",\"country_id\":\"11\",\"units_per_packet\":\"20\",\"price_per_packet\":\"200.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 05:05:28'),
(11, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"gst_percent\":\"12\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 05:17:20'),
(12, 56, 'Paracip 700', '{\"product_name\":\"Paracip 700\",\"generic_name\":\"Paracetamol 500mg\",\"brand_name\":\"Cipla\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":\"2026-04-15\",\"renewal_process_start\":null,\"qty\":\"50\",\"country_id\":\"11\",\"units_per_packet\":\"20\",\"price_per_packet\":\"200.00\",\"gst_percent\":\"5\",\"tax_percent\":\"0.00\"}', 'edit', 'approved', '2026-04-30 05:45:40'),
(13, 80, 'Amlodipine/Valsartan', '{\"product_name\":\"Amlodipine\\/Valsartan\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"sdsc\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\"}', 'edit', 'approved', '2026-04-30 06:39:45'),
(14, 80, 'Amlodipine/Valsa', '{\"product_name\":\"Amlodipine\\/Valsa\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\"}', 'edit', 'approved', '2026-04-30 07:07:57'),
(15, 80, 'Amlodipine/Valsartan', '{\"product_name\":\"Amlodipine\\/Valsartan\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"hsn_no\":\"524158\"}', 'edit', 'approved', '2026-04-30 09:53:17'),
(16, 80, 'Amlodipine/Valsa', '{\"product_name\":\"Amlodipine\\/Valsa\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"hsn_no\":\"1212121\"}', 'edit', 'approved', '2026-04-30 09:57:42'),
(17, 80, 'Amlodipine/Valsa', '{\"product_name\":\"Amlodipine\\/Valsa\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"hsn_no\":\"1211212\"}', 'edit', 'approved', '2026-04-30 10:13:23'),
(18, 80, 'Amlodipine/Valsa', '{\"product_name\":\"Amlodipine\\/Valsa\",\"generic_name\":\"AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP \",\"brand_name\":\"ZYOVAN 10\",\"standards\":\"In House\",\"strength\":\"10 mg\",\"volume\":\"scsc\",\"dosage_form\":\"oral powder\",\"indication\":\"for Women UTI\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"sssd\",\"marketed_by\":\"scscsc\",\"distributed_by\":\"scscsc\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":\"2026-04-15\",\"query_received_on\":\"2026-04-16\",\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-04-15\",\"qty\":\"0\",\"country_id\":\"11\",\"units_per_packet\":\"100\",\"price_per_packet\":\"10.00\",\"hsn_no\":\"12121\"}', 'edit', 'approved', '2026-04-30 10:18:55'),
(19, 76, 'combiflame11', '{\"product_name\":\"combiflame11\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"hsn_no\":\"\"}', 'edit', 'pending', '2026-04-30 10:19:52'),
(20, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"hsn_no\":\"327642487954\"}', 'edit', 'pending', '2026-04-30 12:10:38'),
(21, 76, 'combiflame1', '{\"product_name\":\"combiflame1\",\"generic_name\":\"combiflame\",\"brand_name\":\"combi\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":\"2026-04-28\",\"registration_exp_date\":null,\"renewal_process_start\":null,\"qty\":\"199\",\"country_id\":\"11\",\"units_per_packet\":\"11\",\"price_per_packet\":\"50.00\",\"hsn_no\":\"\"}', 'edit', 'pending', '2026-04-30 13:24:18'),
(22, 57, 'Dolo 650', '{\"product_name\":\"Dolo 650\",\"generic_name\":\"Paracetamol 650mg\",\"brand_name\":\"Micro Labs\",\"standards\":\"\",\"strength\":\"\",\"volume\":\"\",\"dosage_form\":\"\",\"indication\":\"\",\"primary_packing\":\"\",\"secondary_packing\":\"\",\"shelf_life\":\"\",\"manufactured_by\":\"\",\"marketed_by\":\"\",\"distributed_by\":\"\",\"samples_batch_no\":\"\",\"samples_manufacturing_date\":null,\"samples_expiry_date\":null,\"samples_submitted_on\":null,\"samples_coa_file\":\"\",\"samples_tracking_no\":\"\",\"samples_qty\":\"\",\"samples_sent_to\":\"\",\"samples_destination_address\":\"\",\"ws_batch_no\":\"\",\"ws_manufacturing_date\":null,\"ws_expiry_date\":null,\"ws_submitted_on\":null,\"ws_coa_file\":\"\",\"ws_tracking_no\":\"\",\"ws_qty\":\"\",\"ws_sent_to\":\"\",\"ws_destination_address\":\"\",\"dossier_number\":\"\",\"submitted_to\":\"\",\"dossier_sent_on\":null,\"query_received_on\":null,\"query_submitted_on\":null,\"dossier_submitted_in_moh_on\":null,\"moh_comments_received_on\":null,\"moh_comments\":\"\",\"moh_comments_submitted_on\":null,\"registration_number\":\"\",\"registration_date\":null,\"registration_exp_date\":null,\"renewal_process_start\":\"2026-05-02\",\"qty\":\"147\",\"country_id\":\"11\",\"units_per_packet\":\"30\",\"price_per_packet\":\"600.00\",\"hsn_no\":\"\"}', 'edit', 'pending', '2026-04-30 14:00:48'),
(23, 0, 'Esomeprazole 40 mg tablet', '{\"product_name\":\"Esomeprazole 40 mg tablet\",\"generic_name\":\"NA\",\"brand_name\":\"Espriza 40\",\"standards\":\"BP\",\"strength\":\"40 mg\",\"volume\":\"200\",\"dosage_form\":\"Tablet\",\"shelf_life\":\"\",\"indication\":\"PPI\",\"packing\":\"3 x 10\",\"manufactured_by\":\"Uniza Lifecare Pvt Ltd\",\"marketed_by\":\"Zyonis Healthcare Pvt Ltd\",\"distributed_by\":\"EPS\",\"country_id\":15,\"dossier_type\":\"new\"}', 'add', 'pending', '2026-05-19 12:29:06');

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

--
-- Table structure for table `alerts`
--

CREATE TABLE `alerts` (
  `id` int(11) NOT NULL,
  `bill_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `is_read` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bills`
--

CREATE TABLE `bills` (
  `id` int(11) NOT NULL,
  `customer_name` varchar(150) DEFAULT NULL,
  `customer_gst` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `discount_percent` decimal(5,2) DEFAULT 0.00,
  `subtotal` decimal(10,2) NOT NULL,
  `taxable_amount` decimal(10,2) NOT NULL,
  `sgst_amount` decimal(10,2) NOT NULL,
  `cgst_amount` decimal(10,2) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `payment_status` enum('paid','unpaid','advance') DEFAULT 'paid',
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `advance_amount` decimal(10,2) DEFAULT 0.00,
  `due_amount` decimal(10,2) DEFAULT 0.00,
  `due_date` date DEFAULT NULL,
  `unpaid` tinyint(1) NOT NULL DEFAULT 0,
  `unpaid_due_date` date DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT 0.00,
  `mr_id` int(11) DEFAULT NULL,
  `port_of_loading` varchar(255) DEFAULT NULL,
  `port_of_discharge` varchar(255) DEFAULT NULL,
  `country_of_destination` varchar(255) DEFAULT NULL,
  `pack_size` varchar(100) DEFAULT NULL,
  `insurance` varchar(100) DEFAULT NULL,
  `freight` varchar(100) DEFAULT NULL,
  `consignee_name` text DEFAULT NULL,
  `consignee_address` text DEFAULT NULL,
  `consignee_contact` text DEFAULT NULL,
  `consignee_phone` varchar(50) DEFAULT NULL,
  `buyer_name` text DEFAULT NULL,
  `buyer_address` text DEFAULT NULL,
  `buyer_contact` text DEFAULT NULL,
  `buyer_phone` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bills`
--

INSERT INTO `bills` (`id`, `customer_name`, `customer_gst`, `phone`, `discount_percent`, `subtotal`, `taxable_amount`, `sgst_amount`, `cgst_amount`, `total_amount`, `payment_status`, `created_by`, `created_at`, `advance_amount`, `due_amount`, `due_date`, `unpaid`, `unpaid_due_date`, `paid_amount`, `mr_id`, `port_of_loading`, `port_of_discharge`, `country_of_destination`, `pack_size`, `insurance`, `freight`, `consignee_name`, `consignee_address`, `consignee_contact`, `consignee_phone`, `buyer_name`, `buyer_address`, `buyer_contact`, `buyer_phone`) VALUES
(88, NULL, NULL, '8320775403', 0.00, 400.00, 400.00, 12.00, 12.00, 424.00, 'paid', 24, '2026-04-30 10:19:53', 424.00, 0.00, '0000-00-00', 0, NULL, 424.00, 24, NULL, NULL, NULL, NULL, NULL, NULL, 'yash', 'b-104', 'yash@bionick.co.in', NULL, 'vishal', 'd-001', 'vishal@bionick.co.in', NULL),
(89, NULL, NULL, '', 0.00, 300.00, 300.00, 18.00, 18.00, 336.00, 'paid', 24, '2026-04-30 10:20:12', 336.00, 0.00, '0000-00-00', 0, NULL, 336.00, 24, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', '', '', NULL),
(90, NULL, NULL, NULL, 0.00, 300.00, 300.00, 18.00, 18.00, 336.00, 'paid', 24, '2026-04-30 10:30:24', 336.00, 0.00, '0000-00-00', 0, NULL, 336.00, 24, NULL, NULL, NULL, NULL, NULL, NULL, 'yash', 'b-104 jwdqfjhdfhjehwef wdfhqiwfhwefjwbef wfjh', 'yash@bionick.co.in', NULL, 'vishal', 'b-001jwdqfjhdfhjehwef wdfhqiwfhwefjwbef wfjh', 'yash@bionick.co.in', NULL),
(91, NULL, NULL, NULL, 0.00, 400.00, 400.00, 12.00, 12.00, 424.00, 'paid', 24, '2026-04-30 10:40:20', 424.00, 0.00, '0000-00-00', 0, NULL, 424.00, 24, NULL, NULL, NULL, NULL, NULL, NULL, 'sccs', 'sccsac', 'acacs', '8320775403', 'yash', 'cjJD', 'CHJHWKDS', '9979933932'),
(92, NULL, NULL, NULL, 0.00, 400.00, 400.00, 12.00, 12.00, 424.00, 'paid', 26, '2026-04-30 10:45:35', 424.00, 0.00, '0000-00-00', 0, NULL, 424.00, 26, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', '', ''),
(93, NULL, NULL, NULL, 0.00, 300.00, 300.00, 18.00, 18.00, 336.00, 'unpaid', 26, '2026-04-30 10:49:39', 0.00, 336.00, '2026-05-01', 1, '2026-05-01', 0.00, 26, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', '', ''),
(94, NULL, NULL, NULL, 0.00, 300.00, 300.00, 18.00, 18.00, 336.00, 'unpaid', 26, '2026-04-30 12:33:47', 0.00, 336.00, '2026-05-02', 1, '2026-05-02', 0.00, 26, NULL, NULL, NULL, NULL, NULL, NULL, 'yash', 'nsdcjsacjscx', 'yash@bionick.co.in', '8320775403', 'vishal', 'sdccsx', 'vishal@bionick.co.in', '9979933932'),
(95, NULL, NULL, NULL, 0.00, 300.00, 300.00, 18.00, 18.00, 336.00, 'advance', 26, '2026-04-30 12:44:02', 100.00, 236.00, '2026-05-01', 0, NULL, 100.00, 26, NULL, NULL, NULL, NULL, NULL, NULL, 'yash', 'sadcdcs', 'yash@', '8320775403', 'vishal', 'xcasxcacx', 'vishal@', '9979933932'),
(96, NULL, NULL, NULL, 0.00, 400.00, 400.00, 12.00, 12.00, 424.00, 'paid', 26, '2026-05-19 10:39:13', 424.00, 0.00, '0000-00-00', 0, NULL, 424.00, 26, NULL, NULL, NULL, NULL, NULL, NULL, 'trueholsalller', 'b-011 sidhivinayak tower', 'sanjay sharma', '9227111655', 'trueholsalller', 'b-111 sidhivinayak tower', 'sanjay sharma', '9227111655');

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

--
-- Table structure for table `bill_items`
--

CREATE TABLE `bill_items` (
  `id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `sgst` decimal(10,2) DEFAULT 0.00,
  `cgst` decimal(10,2) DEFAULT 0.00,
  `discount` decimal(10,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bill_items`
--

INSERT INTO `bill_items` (`id`, `bill_id`, `product_id`, `product_name`, `qty`, `price`, `total`, `sgst`, `cgst`, `discount`) VALUES
(87, 88, 61, 'Augmentin 625', 1.00, 400.00, 400.00, 0.00, 0.00, 0.00),
(88, 89, 59, 'Azee 500', 1.00, 300.00, 300.00, 0.00, 0.00, 0.00),
(89, 90, 59, 'Azee 500', 1.00, 300.00, 300.00, 0.00, 0.00, 0.00),
(90, 91, 61, 'Augmentin 625', 1.00, 400.00, 400.00, 0.00, 0.00, 0.00),
(91, 92, 61, 'Augmentin 625', 1.00, 400.00, 400.00, 0.00, 0.00, 0.00),
(92, 93, 59, 'Azee 500', 1.00, 300.00, 300.00, 0.00, 0.00, 0.00),
(93, 94, 59, 'Azee 500', 1.00, 300.00, 300.00, 0.00, 0.00, 0.00),
(94, 95, 59, 'Azee 500', 1.00, 300.00, 300.00, 0.00, 0.00, 0.00),
(95, 96, 61, 'Augmentin 625', 1.00, 400.00, 400.00, 0.00, 0.00, 0.00);

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `gst` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `country_name` varchar(100) NOT NULL,
  `iso_code` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `country_name`, `iso_code`) VALUES
(11, 'India', NULL),
(12, 'Australia', NULL),
(13, 'Germany', NULL),
(14, 'Argentina', NULL),
(15, 'Angola', NULL),
(16, 'Azerbaijan', NULL);

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

--
-- Table structure for table `discount_settings`
--

CREATE TABLE `discount_settings` (
  `id` int(11) NOT NULL,
  `discount_percent` decimal(5,2) NOT NULL DEFAULT 0.00,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `doctors`
--

CREATE TABLE `doctors` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `specialization` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `doctors`
--

INSERT INTO `doctors` (`id`, `name`, `mobile`, `city`, `specialization`, `created_at`) VALUES
(2, 'Dr. Rajesh Sharma', '9876543210', 'Ahmedabad', 'Cardiologist', '2026-04-16 09:31:49'),
(3, 'Dr. Priya Mehta', '9825012345', 'Mumbai', 'Dermatologist', '2026-04-16 09:32:19'),
(5, 'Dr.Aklesh Parekh', '7858251425', 'Ahmedabad', 'gyno', '2026-04-16 11:05:36');

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

--
-- Table structure for table `doctor_assignments`
--

CREATE TABLE `doctor_assignments` (
  `id` int(11) NOT NULL,
  `doctor_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `meeting_date` date DEFAULT NULL,
  `follow_up_date` date DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `doctor_samples`
--

CREATE TABLE `doctor_samples` (
  `id` int(11) NOT NULL,
  `doctor_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `doctor_samples`
--

INSERT INTO `doctor_samples` (`id`, `doctor_id`, `product_id`, `quantity`, `created_at`) VALUES
(2, 3, 13, 10, '2026-04-29 07:27:50'),
(3, 2, 13, 10, '2026-04-29 07:33:53'),
(4, 5, 10, 1, '2026-04-29 07:36:01'),
(5, 3, 13, 1, '2026-04-29 07:43:14'),
(6, 2, 13, 1, '2026-04-29 07:43:14'),
(7, 5, 13, 1, '2026-04-29 07:43:14'),
(8, 3, 13, 5, '2026-04-29 07:44:15'),
(9, 2, 13, 5, '2026-04-29 07:44:15'),
(10, 5, 13, 5, '2026-04-29 07:44:15');

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

--
-- Table structure for table `doctor_visits`
--

CREATE TABLE `doctor_visits` (
  `id` int(11) NOT NULL,
  `doctor_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `visit_status` enum('visited','not_visited') NOT NULL,
  `visit_datetime` datetime NOT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `moh_submissions`
--

CREATE TABLE `moh_submissions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `department` varchar(200) DEFAULT NULL,
  `dossier_number` varchar(100) DEFAULT NULL,
  `submission_date` date DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `attachment_path` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `rejection_reason` text DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `moh_submissions`
--

INSERT INTO `moh_submissions` (`id`, `user_id`, `title`, `department`, `dossier_number`, `submission_date`, `notes`, `attachment_path`, `created_at`, `status`, `rejection_reason`, `approved_by`, `approved_at`) VALUES
(1, 17, 'product', 'Ministry of Health', 'DOSS-2026-001', '2026-04-30', 'cxaCDCXACX', NULL, '2026-04-30 13:18:08', 'pending', NULL, NULL, NULL);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `role` enum('admin','sales_manager','sales_executive') DEFAULT NULL,
  `message` text NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `bill_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `mr_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `notes` text DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `mr_id`, `product_id`, `qty`, `notes`, `status`, `created_at`) VALUES
(1, 26, 80, 250, 'urgent', 'Approved', '2026-05-20 11:29:23'),
(2, 26, 65, 500, 'next month', 'Approved', '2026-05-20 12:01:24');

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

--
-- Table structure for table `pharmacies`
--

CREATE TABLE `pharmacies` (
  `id` int(11) NOT NULL,
  `pharmacy_name` varchar(255) NOT NULL,
  `owner_name` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `pincode` varchar(20) DEFAULT NULL,
  `assigned_mr_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pharmacy_visits`
--

CREATE TABLE `pharmacy_visits` (
  `id` int(11) NOT NULL,
  `pharmacy_id` int(11) NOT NULL,
  `mr_id` int(11) NOT NULL,
  `visit_date` datetime DEFAULT current_timestamp(),
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `generic_name` varchar(255) DEFAULT NULL,
  `brand_name` varchar(255) DEFAULT NULL,
  `country` varchar(100) NOT NULL,
  `standards` varchar(100) DEFAULT NULL,
  `strength` varchar(100) DEFAULT NULL,
  `volume` varchar(100) DEFAULT NULL,
  `dosage_form` varchar(100) DEFAULT NULL,
  `indication` text DEFAULT NULL,
  `primary_packing` varchar(255) DEFAULT NULL,
  `secondary_packing` varchar(255) DEFAULT NULL,
  `shelf_life` varchar(100) DEFAULT NULL,
  `manufactured_by` varchar(255) DEFAULT NULL,
  `marketed_by` varchar(255) DEFAULT NULL,
  `distributed_by` varchar(255) DEFAULT NULL,
  `dossier_number` varchar(100) DEFAULT NULL,
  `dossier_sent_on` date DEFAULT NULL,
  `submitted_to` varchar(255) DEFAULT NULL,
  `samples_batch_no` varchar(255) DEFAULT NULL,
  `samples_manufacturing_date` date DEFAULT NULL,
  `samples_expiry_date` date DEFAULT NULL,
  `submitted_on` date DEFAULT NULL,
  `samples_submitted_on` date DEFAULT NULL,
  `samples_coa_file` varchar(500) DEFAULT NULL,
  `samples_tracking_no` varchar(255) DEFAULT NULL,
  `samples_qty` int(11) DEFAULT NULL,
  `samples_sent_to` varchar(255) DEFAULT NULL,
  `samples_destination_address` text DEFAULT NULL,
  `samples_batch_no_expiry` varchar(255) DEFAULT NULL,
  `ws_batch_no` varchar(255) DEFAULT NULL,
  `ws_manufacturing_date` date DEFAULT NULL,
  `ws_expiry_date` date DEFAULT NULL,
  `ws_submitted_on` date DEFAULT NULL,
  `ws_coa_file` varchar(500) DEFAULT NULL,
  `ws_tracking_no` varchar(255) DEFAULT NULL,
  `ws_qty` int(11) DEFAULT NULL,
  `ws_sent_to` varchar(255) DEFAULT NULL,
  `ws_destination_address` text DEFAULT NULL,
  `query_received_on` date DEFAULT NULL,
  `query_submitted_on` date DEFAULT NULL,
  `dossier_submitted_in_moh_on` date DEFAULT NULL,
  `moh_comments_received_on` date DEFAULT NULL,
  `moh_comments` text DEFAULT NULL,
  `moh_comments_submitted_on` date DEFAULT NULL,
  `query_sent_on` date DEFAULT NULL,
  `submitted_to_fda_on` date DEFAULT NULL,
  `fda_query_received_on` date DEFAULT NULL,
  `fda_query_submitted_on` date DEFAULT NULL,
  `result_comments` text DEFAULT NULL,
  `registration_number` varchar(100) DEFAULT NULL,
  `registration_details` text DEFAULT NULL,
  `purchase_name` varchar(255) DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `registration_exp_date` date DEFAULT NULL,
  `renewal_process_start` date DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `approved_by` int(11) DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT 0,
  `units_per_packet` int(11) DEFAULT NULL,
  `price_per_packet` decimal(10,2) DEFAULT NULL,
  `gst_percent` decimal(5,2) DEFAULT 0.00,
  `tax_percent` decimal(5,2) DEFAULT 0.00,
  `country_id` int(11) DEFAULT 1,
  `dossier_type` enum('new','renewal') DEFAULT NULL,
  `low_stock_limit` int(11) DEFAULT 10,
  `variation_submitted` date DEFAULT NULL,
  `variation_approval_date` date DEFAULT NULL,
  `notify_ra` tinyint(4) DEFAULT 1,
  `hsn_no` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `product_name`, `generic_name`, `brand_name`, `country`, `standards`, `strength`, `volume`, `dosage_form`, `indication`, `primary_packing`, `secondary_packing`, `shelf_life`, `manufactured_by`, `marketed_by`, `distributed_by`, `dossier_number`, `dossier_sent_on`, `submitted_to`, `samples_batch_no`, `samples_manufacturing_date`, `samples_expiry_date`, `submitted_on`, `samples_submitted_on`, `samples_coa_file`, `samples_tracking_no`, `samples_qty`, `samples_sent_to`, `samples_destination_address`, `samples_batch_no_expiry`, `ws_batch_no`, `ws_manufacturing_date`, `ws_expiry_date`, `ws_submitted_on`, `ws_coa_file`, `ws_tracking_no`, `ws_qty`, `ws_sent_to`, `ws_destination_address`, `query_received_on`, `query_submitted_on`, `dossier_submitted_in_moh_on`, `moh_comments_received_on`, `moh_comments`, `moh_comments_submitted_on`, `query_sent_on`, `submitted_to_fda_on`, `fda_query_received_on`, `fda_query_submitted_on`, `result_comments`, `registration_number`, `registration_details`, `purchase_name`, `registration_date`, `registration_exp_date`, `renewal_process_start`, `file_path`, `created_by`, `created_at`, `status`, `approved_by`, `approved_at`, `user_id`, `qty`, `units_per_packet`, `price_per_packet`, `gst_percent`, `tax_percent`, `country_id`, `dossier_type`, `low_stock_limit`, `variation_submitted`, `variation_approval_date`, `notify_ra`, `hsn_no`) VALUES
(56, 'Paracip 700', 'Paracetamol 500mg', 'Cipla', 'india', '', '', '', '', '', NULL, '', '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, '2026-04-15', NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:14', NULL, 50, 20, 200.00, 0.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(57, 'Dolo 650', 'Paracetamol 650mg', 'Micro Labs', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:15', NULL, 147, 30, 600.00, 5.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(58, 'Crocin Advance', 'Paracetamol', 'GSK', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:16', NULL, 108, 15, 500.00, 0.00, 0.00, 12, NULL, 10, NULL, NULL, 1, NULL),
(59, 'Azee 500', 'Azithromycin 500mg', 'Cipla', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:16', NULL, 62, 20, 300.00, 12.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(60, 'Azithral 500', 'Azithromycin', 'Alembic', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:18', NULL, 57, 20, 250.00, 5.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(61, 'Augmentin 625', 'Amoxicillin + Clavulanic Acid', 'GSK', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:17', NULL, 126, 15, 400.00, 0.00, 6.00, 12, NULL, 10, NULL, NULL, 1, NULL),
(62, 'Moxikind CV', 'Amoxicillin + Clavulanic Acid', 'Mankind', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 11:07:49', NULL, 58, 30, 150.00, 12.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(63, 'Zerodol SP', 'Aceclofenac + Paracetamol + Serratiopeptidase', 'Ipca', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 11:07:51', NULL, 110, 20, 170.00, 5.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(64, 'Hifenac SP', 'Aceclofenac + Paracetamol + Serratiopeptidase', 'Intas', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:23', NULL, 89, 10, 100.00, 0.00, 5.00, 12, NULL, 10, NULL, NULL, 1, NULL),
(65, 'Pantocid D', 'Pantoprazole + Domperidone', 'Sun Pharma', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16 09:45:16', 'approved', 1, '2026-04-16 10:25:24', NULL, 698, 25, 110.00, 5.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(76, 'combiflame1', 'combiflame', 'combi', '', '', '', '', '', '', NULL, '', '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '2026-04-28', NULL, NULL, NULL, 17, '2026-04-16 11:06:54', 'approved', 1, '2026-04-16 11:07:49', 17, 199, 11, 50.00, 12.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(78, 'Amlodipine/Valsartan/Hydroclorithazide 5mg/160mg/12.5mg Tabs', 'AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP ', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, '2026-04-30', NULL, 'uploads/products/vendor.zip', 17, '2026-04-27 08:31:55', 'approved', 1, '2026-04-27 12:10:37', 17, 98, 10, 100.00, 12.00, 0.00, 11, NULL, 10, NULL, NULL, 1, NULL),
(79, 'Amlodipine/Valsartan/Hydroclorithazide 5mg/160mg/12.5mg Tabs', 'Paracetamol 500mg', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '2026-05-02', '2026-05-03', NULL, NULL, 1, '2026-04-27 10:00:34', 'approved', 1, '2026-04-27 12:10:35', 1, 100, 10, 100.00, 12.00, 0.00, 11, 'new', 10, NULL, NULL, 1, NULL),
(80, 'Amlodipine/Valsa', 'AMLODIPINE, VALSARTAN AND HYDROCHLOROTHIAZIDE TABLETS USP ', 'ZYOVAN 10', '', 'In House', '10 mg', 'scsc', 'oral powder', 'for Women UTI', NULL, NULL, '', 'sssd', 'scscsc', 'scscsc', '', '2026-04-15', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '2026-04-15', NULL, 1, '2026-04-27 12:27:59', '', NULL, NULL, 1, 0, 100, 10.00, 0.00, 0.00, 11, NULL, 10, NULL, NULL, 1, '12121');

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

--
-- Table structure for table `product_requests`
--

CREATE TABLE `product_requests` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `submitted_to` varchar(255) DEFAULT NULL,
  `dossier_number` varchar(255) DEFAULT NULL,
  `submitted_on` date DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `product_variations`
--

CREATE TABLE `product_variations` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `variation_no` int(11) NOT NULL,
  `variation_type` varchar(255) NOT NULL,
  `variation_description` text DEFAULT NULL,
  `submission_date` date DEFAULT NULL,
  `approval_date` date DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `document_file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(20) DEFAULT 'Pending',
  `requested_by` int(11) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `sample_products`
--

CREATE TABLE `sample_products` (
  `id` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `generic_name` varchar(255) DEFAULT NULL,
  `brand_name` varchar(255) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `packet_qty` int(11) DEFAULT NULL,
  `units_packet` int(11) DEFAULT NULL,
  `price_packet` decimal(10,2) DEFAULT NULL,
  `gst` decimal(5,2) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `gst_percent` decimal(5,2) DEFAULT NULL,
  `tax_percent` decimal(5,2) DEFAULT NULL,
  `packing` varchar(255) DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `manufacturing_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `manufactured_by` varchar(255) DEFAULT NULL,
  `received_on` date DEFAULT NULL,
  `received_by` varchar(255) DEFAULT NULL,
  `received_qty` int(11) DEFAULT 0,
  `sent_on` date DEFAULT NULL,
  `sent_by` varchar(255) DEFAULT NULL,
  `sent_to` varchar(255) DEFAULT NULL,
  `sent_qty` int(11) DEFAULT 0,
  `remaining_qty` int(11) DEFAULT 0,
  `tracking_number` varchar(255) DEFAULT NULL,
  `comments` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sample_products`
--

INSERT INTO `sample_products` (`id`, `product_name`, `generic_name`, `brand_name`, `country`, `packet_qty`, `units_packet`, `price_packet`, `gst`, `document`, `created_at`, `gst_percent`, `tax_percent`, `packing`, `batch_no`, `manufacturing_date`, `expiry_date`, `manufactured_by`, `received_on`, `received_by`, `received_qty`, `sent_on`, `sent_by`, `sent_to`, `sent_qty`, `remaining_qty`, `tracking_number`, `comments`) VALUES
(10, 'Telma 40', 'Telmisartan', 'Glenmark', 'India', 100, 10, 150.00, NULL, '', '2026-04-16 10:02:51', 12.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL),
(11, 'Telma H', 'Telmisartan + Hydrochlorothiazide', 'Glenmark', 'India', 50, 10, 200.00, NULL, '', '2026-04-16 10:04:19', 5.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL),
(12, 'Glycomet 500', 'Metformin', 'USV', 'India', 50, 10, 50.00, NULL, '', '2026-04-16 10:05:23', 5.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL),
(13, 'Amaryl 1', 'Glimepiride', 'Sanofi', 'Australia', 150, 20, 400.00, NULL, '', '2026-04-16 10:07:12', 0.00, 7.00, '', '', '0000-00-00', '0000-00-00', '', '0000-00-00', '', 0, '0000-00-00', '', '', 0, 0, '', '');

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

--
-- Table structure for table `stock_ledger`
--

CREATE TABLE `stock_ledger` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `type` enum('IN','OUT') NOT NULL,
  `qty` int(11) NOT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `stock_limits`
--

CREATE TABLE `stock_limits` (
  `id` int(11) NOT NULL,
  `stock_limit` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `stock_limit_settings`
--

CREATE TABLE `stock_limit_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(50) NOT NULL,
  `limit_qty` int(11) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_limit_settings`
--

INSERT INTO `stock_limit_settings` (`id`, `setting_key`, `limit_qty`, `created_by`, `created_at`, `updated_at`) VALUES
(7, 'commercial_stock', 50, 1, '2026-04-20 05:05:12', NULL),
(8, 'sample_stock', 50, 1, '2026-04-20 05:09:29', NULL);

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

--
-- Table structure for table `terms_conditions`
--

CREATE TABLE `terms_conditions` (
  `id` int(11) NOT NULL,
  `admin_email` varchar(255) DEFAULT NULL,
  `term_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wholesaler`
--

CREATE TABLE `wholesaler` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `sale_month` varchar(20) NOT NULL,
  `initial_stock` int(11) NOT NULL DEFAULT 0,
  `month_sales` int(11) NOT NULL DEFAULT 0,
  `balance_stock` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wholesaler`
--

INSERT INTO `wholesaler` (`id`, `product_id`, `sale_month`, `initial_stock`, `month_sales`, `balance_stock`, `created_at`) VALUES
(3, 57, '2026-04', 1000, 800, 200, '2026-05-22 06:01:32');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `bill_items`
--
ALTER TABLE `bill_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bill_id` (`bill_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

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

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

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

--
-- Indexes for table `product_requests`
--
ALTER TABLE `product_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

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

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

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

--
-- Indexes for table `stock_limit_settings`
--
ALTER TABLE `stock_limit_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_product_approval`
--
ALTER TABLE `admin_product_approval`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `alerts`
--
ALTER TABLE `alerts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bills`
--
ALTER TABLE `bills`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `bill_items`
--
ALTER TABLE `bill_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `discount_settings`
--
ALTER TABLE `discount_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doctors`
--
ALTER TABLE `doctors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `doctor_assignments`
--
ALTER TABLE `doctor_assignments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `doctor_samples`
--
ALTER TABLE `doctor_samples`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `doctor_visits`
--
ALTER TABLE `doctor_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `moh_submissions`
--
ALTER TABLE `moh_submissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `pharmacies`
--
ALTER TABLE `pharmacies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pharmacy_visits`
--
ALTER TABLE `pharmacy_visits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `product_requests`
--
ALTER TABLE `product_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_variations`
--
ALTER TABLE `product_variations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sample_products`
--
ALTER TABLE `sample_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `stock_ledger`
--
ALTER TABLE `stock_ledger`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_limits`
--
ALTER TABLE `stock_limits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `stock_limit_settings`
--
ALTER TABLE `stock_limit_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `terms_conditions`
--
ALTER TABLE `terms_conditions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `wholesaler`
--
ALTER TABLE `wholesaler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bill_items`
--
ALTER TABLE `bill_items`
  ADD CONSTRAINT `bill_items_ibfk_1` FOREIGN KEY (`bill_id`) REFERENCES `bills` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `product_requests`
--
ALTER TABLE `product_requests`
  ADD CONSTRAINT `product_requests_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_variations`
--
ALTER TABLE `product_variations`
  ADD CONSTRAINT `product_variations_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

