-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: pending_vaccinations
-- ------------------------------------------------------
-- Server version	10.1.26-MariaDB

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `call_closing_record`
--

DROP TABLE IF EXISTS `call_closing_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `call_closing_record` (
  `recid` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(11) NOT NULL,
  `call_status` int(11) NOT NULL,
  `action_by` varchar(30) NOT NULL,
  `action_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`recid`)
) ENGINE=MyISAM AUTO_INCREMENT=263 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `call_closing_record`
--

LOCK TABLES `call_closing_record` WRITE;
/*!40000 ALTER TABLE `call_closing_record` DISABLE KEYS */;
INSERT INTO `call_closing_record` VALUES (1,3835,1,'lhr.sehat','2015-05-14 11:44:16'),(2,3852,1,'lhr.sehat','2015-05-16 04:42:58'),(3,3806,1,'lhr.sehat','2015-05-16 05:28:07'),(4,3871,1,'lhr.sehat','2015-05-18 07:12:30'),(5,3870,1,'lhr.sehat','2015-05-18 07:52:19'),(6,3907,1,'lhr.sehat','2015-05-20 13:08:26'),(7,3919,1,'lhr.sehat','2015-05-21 10:55:46'),(8,3919,2,'anjum.javed','2015-05-22 04:41:40'),(9,3934,1,'lhr.sehat','2015-05-22 11:51:42'),(10,3933,1,'lhr.sehat','2015-05-23 11:14:28'),(11,3989,1,'lhr.sehat','2015-05-26 05:37:34'),(12,3991,1,'khi.sehat','2015-05-26 09:02:42'),(13,3978,1,'lhr.sehat','2015-05-26 10:10:47'),(14,4145,1,'anjum.javed','2015-06-01 08:45:51'),(15,4213,1,'khi.sehat','2015-06-02 11:11:33'),(16,4273,1,'lhr.sehat','2015-06-03 11:54:17'),(17,4330,1,'lhr.sehat','2015-06-04 09:41:21'),(18,4377,1,'anjum.javed','2015-06-05 05:36:48'),(19,4380,1,'anjum.javed','2015-06-05 07:34:00'),(20,4662,1,'lhr.sehat','2015-06-12 07:03:36'),(21,5283,1,'lhr.sehat','2015-06-18 06:52:58'),(22,5291,1,'lhr.sehat','2015-06-18 09:21:44'),(23,5658,1,'lhr.sehat','2015-07-02 10:27:39'),(24,6074,1,'lhr.sehat','2015-07-25 06:43:11'),(25,6075,1,'lhr.sehat','2015-07-25 06:43:54'),(26,6075,2,'support','2015-07-25 06:48:00'),(27,6075,2,'support','2015-07-25 06:48:10'),(28,6166,1,'khi.sehat','2015-07-30 10:14:25'),(29,6336,1,'lhr.sehat','2015-08-10 06:19:17'),(30,6480,1,'lhr.sehat','2015-08-19 07:04:28'),(31,6608,1,'lhr.sehat','2015-08-26 07:32:04'),(32,6650,1,'lhr.sehat','2015-08-29 05:04:51'),(33,6754,1,'lhr.sehat','2015-09-04 06:27:16'),(34,6871,1,'lhr.sehat','2015-09-09 09:58:37'),(35,6925,1,'lhr.sehat','2015-09-11 10:21:03'),(36,6949,1,'lhr.sehat','2015-09-12 05:32:52'),(37,6984,1,'lhr.sehat','2015-09-12 06:31:58'),(38,7027,1,'khi.sehat','2015-09-15 10:15:27'),(39,7001,1,'lhr.sehat','2015-09-16 05:41:47'),(40,7039,1,'lhr.sehat','2015-09-16 10:11:03'),(41,7056,1,'lhr.sehat','2015-09-17 04:57:38'),(42,7070,1,'lhr.sehat','2015-09-17 07:18:46'),(43,7116,1,'lhr.sehat','2015-09-21 06:50:38'),(44,7157,1,'lhr.sehat','2015-09-22 10:07:49'),(45,7225,1,'lhr.sehat','2015-09-29 04:48:09'),(46,7276,1,'lhr.sehat','2015-10-01 06:11:53'),(47,7404,1,'lhr.sehat','2015-10-07 06:42:22'),(48,7437,1,'lhr.sehat','2015-10-08 09:55:37'),(49,7514,1,'lhr.sehat','2015-10-12 10:24:44'),(50,7546,1,'lhr.sehat','2015-10-14 05:34:16'),(51,7537,1,'lhr.sehat','2015-10-14 06:55:21'),(52,7557,1,'lhr.sehat','2015-10-14 11:02:40'),(53,7558,1,'khi.sehat','2015-10-14 12:14:23'),(54,7548,1,'khi.sehat','2015-10-14 12:41:33'),(55,7572,1,'khi.sehat','2015-10-15 08:15:40'),(56,7596,1,'lhr.sehat','2015-10-16 05:44:21'),(57,7616,1,'lhr.sehat','2015-10-17 06:04:58'),(58,7620,1,'lhr.sehat','2015-10-17 10:16:26'),(59,7619,1,'lhr.sehat','2015-10-17 10:17:17'),(60,7690,1,'lhr.sehat','2015-10-19 12:10:49'),(61,7722,1,'lhr.sehat','2015-10-20 12:28:19'),(62,7724,1,'lhr.sehat','2015-10-20 12:33:14'),(63,7831,1,'lhr.sehat','2015-10-27 05:03:54'),(64,7873,1,'lhr.sehat','2015-10-27 12:17:42'),(65,7892,1,'lhr.sehat','2015-10-29 05:02:05'),(66,7905,1,'lhr.sehat','2015-10-29 06:38:53'),(67,7911,1,'lhr.sehat','2015-10-29 12:22:17'),(68,7931,1,'lhr.sehat','2015-11-02 05:46:07'),(69,7996,1,'lhr.sehat','2015-11-03 06:18:29'),(70,8007,1,'lhr.sehat','2015-11-03 06:22:05'),(71,8015,1,'lhr.sehat','2015-11-04 05:17:27'),(72,8014,1,'lhr.sehat','2015-11-04 05:53:56'),(73,8025,1,'lhr.sehat','2015-11-04 06:35:11'),(74,8057,1,'lhr.sehat','2015-11-06 07:24:00'),(75,8120,1,'lhr.sehat','2015-11-10 11:18:05'),(76,8141,1,'lhr.sehat','2015-11-11 09:17:19'),(77,8161,1,'khi.sehat','2015-11-12 08:02:58'),(78,8158,1,'lhr.sehat','2015-11-12 10:14:51'),(79,8194,1,'lhr.sehat','2015-11-14 08:10:22'),(80,8200,1,'lhr.sehat','2015-11-14 11:55:06'),(81,8221,1,'lhr.sehat','2015-11-17 04:43:14'),(82,8271,1,'lhr.sehat','2015-11-18 11:01:11'),(83,8262,1,'rwp.sehat','2015-11-18 11:28:26'),(84,8287,1,'lhr.sehat','2015-11-19 07:45:04'),(85,8280,1,'lhr.sehat','2015-11-19 09:58:20'),(86,8301,1,'lhr.sehat','2015-11-20 05:11:04'),(87,8435,1,'lhr.sehat','2015-11-27 06:51:35'),(88,8469,1,'lhr.sehat','2015-11-28 05:58:51'),(89,8469,1,'lhr.sehat','2015-11-28 05:59:10'),(90,8518,1,'rwp.sehat','2015-12-01 10:06:54'),(91,8520,1,'lhr.sehat','2015-12-01 10:20:47'),(92,8544,1,'lhr.sehat','2015-12-02 05:18:56'),(93,8530,1,'lhr.sehat','2015-12-02 12:16:26'),(94,8590,1,'khi.sehat','2015-12-07 06:38:02'),(95,8629,1,'lhr.sehat','2015-12-07 07:29:29'),(96,8659,1,'lhr.sehat','2015-12-08 09:12:15'),(97,8689,1,'lhr.sehat','2015-12-09 09:20:01'),(98,8750,1,'lhr.sehat','2015-12-12 05:01:12'),(99,8761,1,'lhr.sehat','2015-12-12 06:37:48'),(100,8802,1,'lhr.sehat','2015-12-14 11:00:04'),(101,8777,1,'lhr.sehat','2015-12-15 06:53:44'),(102,8863,1,'lhr.sehat','2015-12-17 10:16:23'),(103,8957,1,'lhr.sehat','2015-12-23 09:03:19'),(104,8984,1,'lhr.sehat','2015-12-26 06:18:24'),(105,8989,1,'lhr.sehat','2015-12-26 10:25:18'),(106,9136,1,'lhr.sehat','2016-01-02 09:07:21'),(107,9172,1,'lhr.sehat','2016-01-04 09:00:20'),(108,8778,1,'lhr.sehat','2016-01-06 08:03:08'),(109,9343,1,'lhr.sehat','2016-01-12 10:07:42'),(110,9365,1,'khi.sehat','2016-01-13 10:35:18'),(111,9364,1,'lhr.sehat','2016-01-13 10:46:50'),(112,8779,1,'lhr.sehat','2016-01-14 09:27:32'),(113,9430,1,'lhr.sehat','2016-01-16 07:42:09'),(114,9434,1,'rwp.sehat','2016-01-16 09:22:41'),(115,9493,1,'khi.sehat','2016-01-20 04:41:21'),(116,9526,1,'lhr.sehat','2016-01-21 05:23:46'),(117,9519,1,'lhr.sehat','2016-01-21 09:55:01'),(118,9581,1,'rwp.sehat','2016-01-25 11:11:46'),(119,9635,1,'khi.sehat','2016-01-27 05:47:14'),(120,9647,1,'lhr.sehat','2016-01-28 05:44:16'),(121,9658,1,'lhr.sehat','2016-01-28 09:15:17'),(122,9651,1,'lhr.sehat','2016-01-28 09:16:02'),(123,9698,1,'lhr.sehat','2016-01-29 05:37:20'),(124,9723,1,'lhr.sehat','2016-01-30 08:38:46'),(125,9730,1,'lhr.sehat','2016-01-30 11:39:55'),(126,9810,1,'anjum.javed','2016-02-04 09:08:20'),(127,9810,1,'anjum.javed','2016-02-04 09:08:25'),(128,9825,1,'lhr.sehat','2016-02-04 09:09:44'),(129,9825,1,'lhr.sehat','2016-02-04 09:09:49'),(130,9826,1,'lhr.sehat','2016-02-04 09:10:23'),(131,9827,1,'lhr.sehat','2016-02-04 09:10:38'),(132,9832,1,'lhr.sehat','2016-02-04 09:21:27'),(133,9779,1,'khi.sehat','2016-02-08 05:12:49'),(134,10152,1,'khi.sehat','2016-02-18 08:57:17'),(135,10180,1,'rwp.sehat','2016-02-23 04:49:17'),(136,10317,1,'lhr.sehat','2016-02-25 04:53:40'),(137,10479,1,'lhr.sehat','2016-03-03 09:15:53'),(138,10481,1,'lhr.sehat','2016-03-04 07:48:01'),(139,10482,1,'lhr.sehat','2016-03-05 09:33:48'),(140,8780,1,'lhr.sehat','2016-03-10 05:18:39'),(141,10760,1,'khi.sehat','2016-03-15 05:13:02'),(142,10753,1,'lhr.sehat','2016-03-16 08:30:25'),(143,10986,1,'lhr.sehat','2016-03-24 07:51:17'),(144,11179,1,'lhr.sehat','2016-03-31 06:29:46'),(145,11472,1,'lhr.sehat','2016-04-12 08:37:28'),(146,11880,1,'lhr.sehat','2016-04-29 04:44:24'),(147,12093,1,'khi.sehat','2016-05-07 05:32:54'),(148,12408,1,'khi.sehat','2016-05-18 08:12:10'),(149,12436,1,'lhr.sehat','2016-05-19 09:42:24'),(150,12591,1,'lhr.sehat','2016-05-27 12:20:24'),(151,12592,1,'lhr.sehat','2016-05-28 09:56:50'),(152,12747,1,'rwp.sehat','2016-06-06 08:31:41'),(153,14553,1,'lhr.sehat','2016-08-26 05:05:46'),(154,14698,1,'lhr.sehat','2016-08-31 06:02:23'),(155,14900,1,'lhr.sehat','2016-09-06 05:27:41'),(156,15291,1,'lhr.sehat','2016-09-19 05:48:17'),(157,15574,1,'lhr.sehat','2016-09-26 05:58:46'),(158,15698,1,'lhr.sehat','2016-09-30 05:16:10'),(159,15856,1,'lhr.sehat','2016-10-05 12:34:06'),(160,15958,1,'lhr.sehat','2016-10-08 10:23:22'),(161,15997,1,'lhr.sehat','2016-10-10 09:33:36'),(162,16077,1,'support','2016-10-13 08:55:31'),(163,16085,1,'lhr.sehat','2016-10-14 07:16:33'),(164,16183,1,'lhr.sehat','2016-10-15 06:21:20'),(165,16179,1,'lhr.sehat','2016-10-15 06:47:10'),(166,16279,1,'lhr.sehat','2016-10-18 11:12:09'),(167,16318,1,'lhr.sehat','2016-10-19 10:36:50'),(168,16346,1,'lhr.sehat','2016-10-20 07:20:54'),(169,16355,1,'lhr.sehat','2016-10-20 09:24:28'),(170,16393,1,'lhr.sehat','2016-10-22 06:51:49'),(171,16481,1,'lhr.sehat','2016-10-24 06:50:32'),(172,16503,1,'lhr.sehat','2016-10-26 05:34:45'),(173,16713,1,'lhr.sehat','2016-10-31 09:47:17'),(174,16817,1,'lhr.sehat','2016-11-04 04:35:48'),(175,16834,1,'lhr.sehat','2016-11-04 06:24:11'),(176,17191,1,'lhr.sehat','2016-11-16 09:50:32'),(177,17241,1,'lhr.sehat','2016-11-17 12:05:06'),(178,17455,1,'lhr.sehat','2016-11-29 07:25:08'),(179,17937,1,'lhr.sehat','2016-12-14 06:03:59'),(180,18005,1,'lhr.sehat','2016-12-16 05:26:37'),(181,18109,1,'lhr.sehat','2016-12-20 09:41:06'),(182,18223,1,'lhr.sehat','2016-12-26 09:02:23'),(183,18562,1,'lhr.sehat','2017-01-10 04:53:22'),(184,19151,1,'lhr.sehat','2017-01-28 10:30:38'),(186,30841,1,'Shakeel.ahmed','2018-01-25 12:53:21'),(187,31079,1,'Shakeel.ahmed','2018-02-01 10:53:49'),(188,32027,1,'Shakeel.ahmed','2018-02-21 06:27:56'),(189,49427,1,'Shakeel.ahmed','2019-04-08 12:39:41'),(190,49505,1,'Shakeel.ahmed','2019-04-11 05:01:25'),(191,50018,1,'Shakeel.ahmed','2019-04-25 06:20:15'),(192,55371,1,'Shakeel.ahmed','2019-10-02 10:01:30'),(193,55674,1,'Shakeel.ahmed','2019-10-09 08:54:04'),(194,56101,1,'Shakeel.ahmed','2019-10-22 04:34:10'),(195,56562,1,'Shakeel.ahmed','2019-11-06 07:53:17'),(196,57102,1,'Shakeel.ahmed','2019-11-16 06:01:27'),(197,57394,1,'Shakeel.ahmed','2019-11-22 09:31:41'),(198,57394,1,'Shakeel.ahmed','2019-11-22 09:32:21'),(199,57394,1,'Shakeel.ahmed','2019-11-22 09:33:07'),(200,58137,1,'Shakeel.ahmed','2019-12-21 07:18:48'),(201,58137,1,'Shakeel.ahmed','2019-12-21 07:19:23'),(202,58578,1,'Shakeel.ahmed','2020-01-04 06:13:56'),(203,73009,1,'Shakeel.ahmed','2020-10-09 12:07:33'),(204,73228,1,'Shakeel.ahmed','2020-10-15 08:07:14'),(205,73453,1,'Shakeel.ahmed','2020-10-22 12:37:09'),(206,73505,1,'Shakeel.ahmed','2020-10-26 08:06:22'),(207,73502,1,'Shakeel.ahmed','2020-10-26 08:07:31'),(208,73657,1,'Shakeel.ahmed','2020-10-31 04:47:51'),(209,73878,1,'Shakeel.ahmed','2020-11-05 04:49:26'),(210,73878,1,'Shakeel.ahmed','2020-11-05 09:02:06'),(211,73970,1,'Shakeel.ahmed','2020-11-07 07:54:43'),(212,73970,1,'Shakeel.ahmed','2020-11-07 07:55:14'),(213,73975,1,'Shakeel.ahmed','2020-11-09 04:57:19'),(214,74015,1,'Shakeel.ahmed','2020-11-09 05:21:01'),(215,74067,1,'Shakeel.ahmed','2020-11-11 05:13:42'),(216,74216,1,'Shakeel.ahmed','2020-11-13 10:37:38'),(217,74654,1,'Shakeel.ahmed','2020-11-24 12:00:36'),(218,75497,1,'Shakeel.ahmed','2020-12-15 09:05:51'),(219,75403,1,'Shakeel.ahmed','2020-12-15 09:05:53'),(220,75403,1,'Shakeel.ahmed','2020-12-15 09:05:55'),(221,75403,1,'Shakeel.ahmed','2020-12-15 09:05:57'),(222,75403,1,'Shakeel.ahmed','2020-12-15 09:06:00'),(223,75403,1,'Shakeel.ahmed','2020-12-15 09:06:02'),(224,75403,1,'Shakeel.ahmed','2020-12-15 09:06:04'),(225,75382,1,'Shakeel.ahmed','2020-12-15 09:06:06'),(226,75403,1,'Shakeel.ahmed','2020-12-15 09:06:09'),(227,75497,1,'Shakeel.ahmed','2020-12-15 09:06:39'),(228,75403,1,'Shakeel.ahmed','2020-12-15 09:06:41'),(229,75401,1,'Shakeel.ahmed','2020-12-15 09:12:13'),(230,75401,1,'Shakeel.ahmed','2020-12-15 09:12:15'),(231,75401,1,'Shakeel.ahmed','2020-12-15 09:12:17'),(232,75401,1,'Shakeel.ahmed','2020-12-15 09:12:19'),(233,75401,1,'Shakeel.ahmed','2020-12-15 09:12:21'),(234,75401,1,'Shakeel.ahmed','2020-12-15 09:12:24'),(235,75493,1,'Shakeel.ahmed','2020-12-15 09:13:37'),(236,75449,1,'Shakeel.ahmed','2020-12-17 04:40:47'),(237,75449,1,'Shakeel.ahmed','2020-12-17 04:40:49'),(238,75449,1,'Shakeel.ahmed','2020-12-17 04:40:51'),(239,75449,1,'Shakeel.ahmed','2020-12-17 04:40:54'),(240,75538,1,'Shakeel.ahmed','2020-12-17 08:16:08'),(241,75538,1,'Shakeel.ahmed','2020-12-17 08:17:21'),(242,75449,1,'Shakeel.ahmed','2020-12-17 08:17:24'),(243,75538,1,'Shakeel.ahmed','2020-12-17 08:18:41'),(244,75449,1,'Shakeel.ahmed','2020-12-17 08:18:43'),(245,75570,1,'Shakeel.ahmed','2020-12-17 08:44:33'),(246,75474,1,'Shakeel.ahmed','2020-12-18 06:19:30'),(247,75474,1,'Shakeel.ahmed','2020-12-18 06:19:32'),(248,75482,1,'Shakeel.ahmed','2020-12-18 06:25:56'),(249,75484,1,'Shakeel.ahmed','2020-12-18 06:27:03'),(250,75436,1,'Shakeel.ahmed','2020-12-21 05:23:58'),(251,75436,1,'Shakeel.ahmed','2020-12-21 05:24:00'),(252,75700,1,'Shakeel.ahmed','2020-12-21 05:29:12'),(253,75741,1,'Shakeel.ahmed','2020-12-21 10:45:51'),(254,75755,1,'Shakeel.ahmed','2020-12-22 11:37:53'),(255,75797,1,'Shakeel.ahmed','2020-12-23 09:09:31'),(256,75826,1,'Shakeel.ahmed','2020-12-23 09:44:13'),(257,75827,1,'Shakeel.ahmed','2020-12-24 04:57:05'),(258,75903,1,'Shakeel.ahmed','2020-12-24 11:32:16'),(259,78547,1,'Shakeel.ahmed','2021-01-11 10:47:41'),(260,78500,1,'Shakeel.ahmed','2021-01-12 05:47:04'),(261,80808,1,'Shakeel.ahmed','2021-03-11 09:12:32'),(262,83761,1,'Shakeel.ahmed','2021-05-18 10:19:36');
/*!40000 ALTER TABLE `call_closing_record` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_remarks`
--

DROP TABLE IF EXISTS `order_remarks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_remarks` (
  `recid` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(5) NOT NULL,
  `remarks` varchar(250) NOT NULL,
  `call_made_by` varchar(35) DEFAULT NULL,
  `date_callmade` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`recid`)
) ENGINE=MyISAM AUTO_INCREMENT=615 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_remarks`
--

LOCK TABLES `order_remarks` WRITE;
/*!40000 ALTER TABLE `order_remarks` DISABLE KEYS */;
INSERT INTO `order_remarks` VALUES (1,3806,'call on his cell but not attended','lhr.sehat','2015-05-12 12:21:59'),(2,3806,'no answer again','lhr.sehat','2015-05-12 12:26:26'),(3,3806,'disconnecting the line from his cell','lhr.sehat','2015-05-12 12:32:48'),(4,3806,'no answer again','lhr.sehat','2015-05-12 12:37:03'),(5,3806,'disconnected again','anjum.javed','2015-05-12 12:50:33'),(6,3806,'no answer again','lhr.sehat','2015-05-12 12:52:21'),(7,3806,'customer want vaccination at saturday evening. He said call on saturday for the confirmation of vaccination time','lhr.sehat','2015-05-13 04:23:57'),(8,3835,'call on his cell but not attended','lhr.sehat','2015-05-14 11:17:08'),(9,3835,'ap[pointment confirm between 12 pm to 1 pm tomorrow.','lhr.sehat','2015-05-14 11:32:03'),(10,3835,'confirm','lhr.sehat','2015-05-14 11:44:16'),(11,3835,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-14 11:44:17'),(12,3852,'at 11 am confirmed','lhr.sehat','2015-05-16 04:42:58'),(13,3852,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-16 04:42:59'),(14,3806,'he said that he will call back to confirm the appointment','lhr.sehat','2015-05-16 04:46:14'),(15,3806,'appointment confirm on Monday(18-5-2015) between 5 to 6 pm','lhr.sehat','2015-05-16 05:26:55'),(16,3806,'confirmed appointment','lhr.sehat','2015-05-16 05:28:07'),(17,3806,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-16 05:28:08'),(18,3871,'appointment confirm 1 pm','lhr.sehat','2015-05-18 07:12:30'),(19,3871,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-18 07:12:31'),(20,3870,'no answer','lhr.sehat','2015-05-18 07:14:43'),(21,3870,'Patient is same of order no. 3871 so cancel this order','lhr.sehat','2015-05-18 07:52:19'),(22,3870,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-18 07:52:20'),(23,3907,'Appoint conferm on friday at 5:00 pm','lhr.sehat','2015-05-20 13:08:26'),(24,3907,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-20 13:08:27'),(25,3919,'Appoint confirm at  (22-05-2015)Tomorrow 7 pm ','lhr.sehat','2015-05-21 10:55:46'),(26,3919,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-21 10:55:47'),(27,3919,'Call ReOpened by user \"anjum.javed\".','anjum.javed','2015-05-22 04:41:40'),(28,3934,'appointment confirm from 6 to 7 pm','lhr.sehat','2015-05-22 11:51:41'),(29,3934,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-22 11:51:43'),(30,3933,'today\"s appontment of  6 to 7pm. It will be reconfirmed at 4 pm','lhr.sehat','2015-05-23 05:09:25'),(31,3933,'confirmed from 6 to 7 pm today','lhr.sehat','2015-05-23 11:14:28'),(32,3933,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-23 11:14:29'),(33,3989,'Appoint conferm  at 5:00 pm','lhr.sehat','2015-05-26 05:37:34'),(34,3989,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-26 05:37:35'),(35,3991,'Today i called Mr.Shameem Ibrahim for vaccination. He said that i am not available today. Please come tomorrow at 7:00pm ','khi.sehat','2015-05-26 08:08:29'),(36,3991,'cal at 01:00pm order confirm at tomorrow at 07:00pm','khi.sehat','2015-05-26 09:02:42'),(37,3991,'Call closed by user \"khi.sehat\"','khi.sehat','2015-05-26 09:02:43'),(38,3978,'appointment confirm at  6 to 7 pm','lhr.sehat','2015-05-26 10:10:47'),(39,3978,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-05-26 10:10:48'),(40,4145,' appointment confirm at 2:30pm today','anjum.javed','2015-06-01 08:45:51'),(41,4145,'Call closed by user \"anjum.javed\"','anjum.javed','2015-06-01 08:45:52'),(42,4213,'today cal mr mohd azam khan and order confirm for tpmorrow 5pm','khi.sehat','2015-06-02 11:11:33'),(43,4213,'Call closed by user \"khi.sehat\"','khi.sehat','2015-06-02 11:11:34'),(44,4273,'appointment confirm Order no ; 4273','lhr.sehat','2015-06-03 11:54:17'),(45,4273,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-06-03 11:54:18'),(46,4330,'Appoint conferm today at 3:30 pm','lhr.sehat','2015-06-04 09:41:21'),(47,4330,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-06-04 09:41:22'),(48,4377,'appointment confirm Order no ; 4377 at:7:00 to 8:00 Pm','anjum.javed','2015-06-05 05:36:48'),(49,4377,'Call closed by user \"anjum.javed\"','anjum.javed','2015-06-05 05:36:49'),(50,4380,'Appoint conferm today  at 3:30 pm','anjum.javed','2015-06-05 07:34:00'),(51,4380,'Call closed by user \"anjum.javed\"','anjum.javed','2015-06-05 07:34:01'),(52,4662,'Customer is not answering','anjum.javed','2015-06-10 09:56:46'),(53,4662,'Call made by Vaccinator Ihsan Shafiq','anjum.javed','2015-06-10 09:58:46'),(54,4662,'Appointment Conferm Order No 4662 at 5:00pm','lhr.sehat','2015-06-12 07:03:36'),(55,4662,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-06-12 07:03:37'),(56,5283,'Customer is not answering','lhr.sehat','2015-06-18 05:34:22'),(57,5283,'appointment confirm between1:00 pm to 2:00 Pm','lhr.sehat','2015-06-18 06:52:58'),(58,5283,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-06-18 06:52:59'),(59,5291,'appointment confirm at 3 pm today','lhr.sehat','2015-06-18 09:21:44'),(60,5291,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-06-18 09:21:45'),(61,5658,'appointment confirm at 4 pm','lhr.sehat','2015-07-02 10:27:39'),(62,5658,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-07-02 10:27:40'),(63,6074,'appointment confirm at 12:30 pm','lhr.sehat','2015-07-25 06:43:11'),(64,6074,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-07-25 06:43:12'),(65,6075,'appointment confirm at 12:30 pm today','lhr.sehat','2015-07-25 06:43:54'),(66,6075,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-07-25 06:43:55'),(67,6075,'Call ReOpened by user \"support\".','support','2015-07-25 06:48:00'),(68,6075,'Call ReOpened by user \"support\".','support','2015-07-25 06:48:10'),(69,6166,'today cal at 3;15pm order confirm for tomorrow at 12pm','khi.sehat','2015-07-30 10:14:25'),(70,6166,'Call closed by user \"khi.sehat\"','khi.sehat','2015-07-30 10:14:26'),(71,6223,'customer say that his dr advise him that take this vaccine after 15 days','khi.sehat','2015-08-03 05:03:28'),(72,6223,'Today i cal the customar at 11:35Am. customar give some information dr name Sher ali usmani. private clinic name. Usmani clinic.','khi.sehat','2015-08-05 06:38:02'),(73,6336,'Customer is asking for vaccination certificate for this vaccination.','lhr.sehat','2015-08-10 05:06:52'),(74,6336,'Appointment confirmed 4 pm to 5 pm today.','lhr.sehat','2015-08-10 06:19:17'),(75,6336,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-08-10 06:19:18'),(76,6480,'Customer is not answering','lhr.sehat','2015-08-19 04:41:32'),(77,6480,'Appointment Conferm  at 5:00pm today','lhr.sehat','2015-08-19 07:04:28'),(78,6480,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-08-19 07:04:29'),(79,6608,'appointment confirm  at 1:00 pm to 1:30pm','lhr.sehat','2015-08-26 07:32:04'),(80,6608,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-08-26 07:32:05'),(81,6650,'Appointment Conferm  at 5:00pm today','lhr.sehat','2015-08-29 05:04:51'),(82,6650,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-08-29 05:04:52'),(83,6754,'Appointment Conferm  at 5:00pm today','lhr.sehat','2015-09-04 06:27:16'),(84,6754,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-04 06:27:17'),(85,6871,'He has not prescription but today he will arrange it. Therefore he said me to call again tomorow  after 10 am for the confirmation of the vaccination appointment ','lhr.sehat','2015-09-09 05:19:12'),(86,6871,'Appointment Conferm  at 6:00pm today','lhr.sehat','2015-09-09 09:58:37'),(87,6871,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-09 09:58:39'),(88,6925,'call on his cell but not attended','anjum.javed','2015-09-11 05:01:38'),(89,6925,'call on his both contacts but no reply','lhr.sehat','2015-09-11 05:27:11'),(90,6925,'at 12:30pm Customer has given appointment of 6 pm and we will reconfirm it after Juma prayer','lhr.sehat','2015-09-11 07:54:08'),(91,6925,'Appointment Conferm  at 6:00pm today','lhr.sehat','2015-09-11 10:21:03'),(92,6925,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-11 10:21:04'),(93,6949,'appointment confirm at 4 pm','lhr.sehat','2015-09-12 05:32:52'),(94,6949,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-12 05:32:53'),(95,6984,'appointment confirm  at 12:30 pm today','lhr.sehat','2015-09-12 06:31:58'),(96,6984,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-12 06:31:59'),(97,7001,'Custemer tell me to call on Wenesday(16-9-2015) morning at 10 am for Veccination Appoinment','lhr.sehat','2015-09-14 09:14:44'),(98,7027,'cal at 03;15pm today order confirm from tomorrow at 12pm','khi.sehat','2015-09-15 10:15:27'),(99,7027,'Call closed by user \"khi.sehat\"','khi.sehat','2015-09-15 10:15:29'),(100,7001,'appointment confirm at 11:30 am today','lhr.sehat','2015-09-16 05:41:47'),(101,7001,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-16 05:41:48'),(102,7039,'appointment confirm Between 5 :oo To 6:00 Pm today','lhr.sehat','2015-09-16 10:11:03'),(103,7039,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-16 10:11:04'),(104,7056,'Appointment Conferm  at 2:30pm today','lhr.sehat','2015-09-17 04:57:37'),(105,7056,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-17 04:57:39'),(106,7070,'appointment confirm 1 pm. ','lhr.sehat','2015-09-17 07:18:46'),(107,7070,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-17 07:18:47'),(108,7116,'He said to call on Monday (21-09-2015) morning for the appointment.','lhr.sehat','2015-09-19 07:46:22'),(109,7116,'Appointment Conferm  at 5:00pm To   6 : 00 Tomaro','lhr.sehat','2015-09-21 06:50:38'),(110,7116,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-21 06:50:39'),(111,7157,'Appointment Conferm  at 4:00pm Tomorrow','lhr.sehat','2015-09-22 10:07:49'),(112,7157,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-22 10:07:50'),(113,7225,'Appointment Conferm  at 8:00pm today','lhr.sehat','2015-09-29 04:48:09'),(114,7225,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-09-29 04:48:10'),(115,7276,'appointment confirm 5:30 pm today','lhr.sehat','2015-10-01 06:11:53'),(116,7276,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-01 06:11:54'),(117,7404,'appointment Conferm at  5:30 Pm Today','lhr.sehat','2015-10-07 06:42:22'),(118,7404,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-07 06:42:23'),(119,7437,'appointment confirm at 4:00Pm','lhr.sehat','2015-10-08 09:55:37'),(120,7437,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-08 09:55:38'),(121,7514,' appointment confirm at 7 : 30 Pm today ','lhr.sehat','2015-10-12 10:24:44'),(122,7514,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-12 10:24:45'),(123,7546,' appointment confirm at 4 : 00 Pm today ','lhr.sehat','2015-10-14 05:34:16'),(124,7546,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-14 05:34:17'),(125,7537,'Appointment confirm at 9:30 AM Tomorrow (15-10-2015)','lhr.sehat','2015-10-14 06:55:21'),(126,7537,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-14 06:55:22'),(127,7557,'appointment confirm at 7:00 PM Today','lhr.sehat','2015-10-14 11:02:40'),(128,7557,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-14 11:02:41'),(129,7548,'Today i call the patient at 04:30pm but patient not recieve the call','khi.sehat','2015-10-14 11:26:01'),(130,7548,'Recall the patient at 5pm but patient not recieve the call','khi.sehat','2015-10-14 12:04:14'),(131,7558,'Today i call the patient at 05:15pm order confirm for tommorrow at 4pm','khi.sehat','2015-10-14 12:14:23'),(132,7558,'Call closed by user \"khi.sehat\"','khi.sehat','2015-10-14 12:14:24'),(133,7548,'Today i call the patient at 05:45pm and order confirm for tommorrow','khi.sehat','2015-10-14 12:41:33'),(134,7548,'Call closed by user \"khi.sehat\"','khi.sehat','2015-10-14 12:41:34'),(135,7572,'Today i call the patient at 01:15pm order confirm from tommorrow','khi.sehat','2015-10-15 08:15:40'),(136,7572,'Call closed by user \"khi.sehat\"','khi.sehat','2015-10-15 08:15:42'),(137,7596,'Appointment confirm at 4:00 PM Today','lhr.sehat','2015-10-16 05:44:21'),(138,7596,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-16 05:44:22'),(139,7616,'Appointment Confirmed 12:00PM Today','lhr.sehat','2015-10-17 06:04:58'),(140,7616,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-17 06:04:59'),(141,7620,' Appointment confirm at 6:00 PM today ','lhr.sehat','2015-10-17 10:16:26'),(142,7620,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-17 10:16:27'),(143,7619,' Appointment confirm at 6:00 PM today ','lhr.sehat','2015-10-17 10:17:17'),(144,7619,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-17 10:17:18'),(145,7690,' Appointment confirm at 6:00 PM today ','lhr.sehat','2015-10-19 12:10:49'),(146,7690,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-19 12:10:50'),(147,7722,'  Appointment confirm at 6:00 PM Tomarrow','lhr.sehat','2015-10-20 12:28:19'),(148,7722,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-20 12:28:20'),(149,7724,'As per instruction Mr.Faheem to confirm his appointment at 3:00 PM without calling him.','lhr.sehat','2015-10-20 12:33:14'),(150,7724,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-20 12:33:15'),(151,7765,'He Intimate that he will be vaccinated later because now he is Suffering from Flu. Therefore we will call him on Monday 26-10-2015','lhr.sehat','2015-10-22 10:27:48'),(152,7765,'He is still suffering from flu and tell that call him on next Monday(2-11-2015) for the appointment','anjum.javed','2015-10-26 06:35:37'),(153,7831,'Appointment confirm at 9:30 am tomorrow (28-10-2015)','lhr.sehat','2015-10-27 05:03:54'),(154,7831,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-27 05:03:55'),(155,7873,'appointment confirm at 6:30 PM Today','lhr.sehat','2015-10-27 12:17:42'),(156,7873,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-27 12:17:43'),(157,7892,'appointment confirm at 1 : 00pm','lhr.sehat','2015-10-29 05:02:05'),(158,7892,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-29 05:02:06'),(159,7902,'call 4 times but still busy, secondary number not in use','rwp.sehat','2015-10-29 06:12:04'),(160,7905,' Appointment Confirm at 7 : 00 Pm today ','lhr.sehat','2015-10-29 06:38:53'),(161,7905,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-29 06:38:54'),(162,7902,'call at 11.46 but busy','rwp.sehat','2015-10-29 06:43:00'),(163,7911,' Appointment confirm at 5:00 PM Saturday on 31-10-2015','lhr.sehat','2015-10-29 12:22:17'),(164,7911,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-10-29 12:22:18'),(165,7931,'Tomorrow(21-10-2015) Customer will confirm the appointment of Monday (2-11-2015)','lhr.sehat','2015-10-30 11:27:46'),(166,7931,'Customer\"s Primary Number is not responding.','lhr.sehat','2015-10-31 06:39:15'),(167,7931,'Customer\"s Secondry number is not attended.','lhr.sehat','2015-10-31 06:42:25'),(168,7931,' Appointment confirm at 3:00 PM today ','lhr.sehat','2015-11-02 05:46:07'),(169,7931,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-02 05:46:08'),(170,7765,'Dial his nomber But no reply','lhr.sehat','2015-11-02 05:52:33'),(171,7996,'Number is not responding','lhr.sehat','2015-11-03 06:07:23'),(172,7765,'He is still suffering from flu. He want this vaccination in next week therefore did not cancel the order and said to call for the confirmation of appointment on Monday (9-11-2015).','lhr.sehat','2015-11-03 06:12:00'),(173,7996,' Appointment confirm at 5:00 PM today ','lhr.sehat','2015-11-03 06:18:29'),(174,7996,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-03 06:18:30'),(175,8007,' Appointment confirm at 12:30 PM today ','lhr.sehat','2015-11-03 06:22:05'),(176,8007,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-03 06:22:06'),(177,8015,'Appointment confirm at 9:30 AM Tomorrow','lhr.sehat','2015-11-04 05:17:27'),(178,8015,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-04 05:17:28'),(179,8014,' Appointment confirm at 4:00 PM today ','lhr.sehat','2015-11-04 05:53:56'),(180,8014,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-04 05:53:57'),(181,8025,' Appointment confirm at 6:00 PM today ','lhr.sehat','2015-11-04 06:35:11'),(182,8025,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-04 06:35:12'),(183,8057,' Appointment confirm at 5:00 PM today','lhr.sehat','2015-11-06 07:24:00'),(184,8057,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-06 07:24:01'),(185,7765,'He is still suffering from flu. Therefore he decided to cancel this order because he is waiting the complete cure from his existing flu. ','lhr.sehat','2015-11-09 04:45:46'),(186,8120,'Tomorrow (12-11-2015) from 3 pm to 4 pm','lhr.sehat','2015-11-10 11:18:05'),(187,8120,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-10 11:18:06'),(188,8141,' Appointment confirm at 5:OO 6:00 PM today ','lhr.sehat','2015-11-11 09:17:19'),(189,8141,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-11 09:17:20'),(190,8161,'today i cal to patient at 1:00pm order comform tomorrom at 12:00pm','khi.sehat','2015-11-12 08:02:58'),(191,8161,'Call closed by user \"khi.sehat\"','khi.sehat','2015-11-12 08:02:59'),(192,8158,'Appointment confirm at 5:00 PM To  6:00 PM today','lhr.sehat','2015-11-12 10:14:51'),(193,8158,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-12 10:14:52'),(194,8194,' Appointment confirm at 4:30  PM To 6:00 PM   today ','lhr.sehat','2015-11-14 08:10:22'),(195,8194,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-14 08:10:23'),(196,8200,'appointment 5:30 PM today','lhr.sehat','2015-11-14 11:55:06'),(197,8200,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-14 11:55:07'),(198,8221,'Mr.Faheem (our pharmacist) passsed the instruction from the customer that he want the vaccination tomorrow evening between 5:00Pm to 6:00PM','anjum.javed','2015-11-16 07:49:48'),(199,8221,'Appointment Confirm 5:00PM to 6:00PM today','lhr.sehat','2015-11-17 04:43:14'),(200,8221,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-17 04:43:15'),(201,8262,'no answer','rwp.sehat','2015-11-18 07:00:34'),(202,8262,'Customer will confirm the appointment later','rwp.sehat','2015-11-18 10:11:57'),(203,8271,'Appointment confirm from 5 PM to 6 PM today','lhr.sehat','2015-11-18 11:01:11'),(204,8271,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-18 11:01:13'),(205,8262,'appoinment confirm from 3:30 PM to 4:00 PM tomorrow (19-11-2015)','rwp.sehat','2015-11-18 11:28:26'),(206,8262,'Call closed by user \"rwp.sehat\"','rwp.sehat','2015-11-18 11:28:27'),(207,8287,'Appointment confirm at 1:00 PM To  1:30 PM today','lhr.sehat','2015-11-19 07:45:04'),(208,8287,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-19 07:45:05'),(209,8280,'Appointment confirm i.e 5 PM to 6 PM today','lhr.sehat','2015-11-19 09:58:20'),(210,8280,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-19 09:58:21'),(211,8301,' Appointment Confirm at 4:30 Pm To 5:30 Today','lhr.sehat','2015-11-20 05:11:04'),(212,8301,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-20 05:11:05'),(213,8435,'customer said he will confirm the appointment tomorrow(27-11-2015) morning.','lhr.sehat','2015-11-26 12:09:54'),(214,8435,'Appointment confirm at 5:00 PM To  6:00 PM today','lhr.sehat','2015-11-27 06:51:35'),(215,8435,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-27 06:51:36'),(216,8469,'Customer has not attended the call.','lhr.sehat','2015-11-28 05:47:58'),(217,8469,' Appointment confirm at 2:00 Pm today ','lhr.sehat','2015-11-28 05:58:51'),(218,8469,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-28 05:58:52'),(219,8469,' Appointment confirm at 2:00 Pm today ','lhr.sehat','2015-11-28 05:59:10'),(220,8469,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-11-28 05:59:11'),(221,8518,'appoinment confirm at 4:00 PM tomorrow (02-12-2015)','rwp.sehat','2015-12-01 10:06:54'),(222,8518,'Call closed by user \"rwp.sehat\"','rwp.sehat','2015-12-01 10:06:55'),(223,8520,'appointment confirm at 5 PM today','lhr.sehat','2015-12-01 10:20:47'),(224,8520,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-01 10:20:48'),(225,8544,' Appointment confirm at 11:00 AM to 12:00 PM today ','lhr.sehat','2015-12-02 05:18:56'),(226,8544,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-02 05:18:57'),(227,8530,'Appointment Confirm at 9:30 AM Tomorrow(3-12-2015) ','lhr.sehat','2015-12-02 12:13:52'),(228,8530,'Appointment Confirm at 9:30 AM Tomorrow(3-12-2015)	','lhr.sehat','2015-12-02 12:16:26'),(229,8530,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-02 12:16:27'),(230,8590,'We called  Mr.Shahzad Farooq of Vikor Karachi. He confirmed that Vikor Karachi is close today.','anjum.javed','2015-12-05 05:01:19'),(231,8590,'called the customer but he did not receive the call at 10:30 AM','khi.sehat','2015-12-07 05:32:24'),(232,8590,'called the customer but he did not receive the call at 11:15 AM','khi.sehat','2015-12-07 06:07:40'),(233,8590,'called the customer at 11:45 Am order confirm for tomorrow at 07:00 PM','khi.sehat','2015-12-07 06:38:02'),(234,8590,'Call closed by user \"khi.sehat\"','khi.sehat','2015-12-07 06:38:03'),(235,8629,'Appointment confirm at 5:00 PM To  6:00 PM today','lhr.sehat','2015-12-07 07:29:29'),(236,8629,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-07 07:29:30'),(237,8632,'Customer said the patient is 2 year baby to whom it will be vaccinated.','rwp.sehat','2015-12-07 11:36:59'),(238,8632,'I informed him that this medicine is not available yet and tell him the I shall call later. Then I informed Mr.Anjum about the age of the patient','rwp.sehat','2015-12-07 11:38:40'),(239,8632,'I called the customer and tell him that we can not vaccinate the baby of 2 year. I suggest him to place a regular cold chain order and cancel this one (8632)','anjum.javed','2015-12-07 11:40:59'),(240,8659,'called the customer but his No is off.','anjum.javed','2015-12-08 09:07:11'),(241,8659,'Apointment time is 6PM today','lhr.sehat','2015-12-08 09:12:15'),(242,8659,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-08 09:12:16'),(243,8689,'Appointment confirm at 4 PM today','lhr.sehat','2015-12-09 09:20:01'),(244,8689,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-09 09:20:02'),(245,8750,'Appointment Confirm at 5:00 PM Today','lhr.sehat','2015-12-12 05:01:12'),(246,8750,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-12 05:01:13'),(247,8761,'Appointment Confirm at 9:30 AM On Monday (14-12-2015)','lhr.sehat','2015-12-12 06:37:48'),(248,8761,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-12 06:37:49'),(249,8802,'Appointment confirm at 9:15AM to 9:30AM','lhr.sehat','2015-12-14 11:00:04'),(250,8802,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-14 11:00:05'),(251,8777,'customer said to call again after 15 minutes','lhr.sehat','2015-12-15 06:36:09'),(252,8777,'Appointment confirm between 5:00PM to 6:00PM today','lhr.sehat','2015-12-15 06:53:44'),(253,8777,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-15 06:53:45'),(254,8863,'Appointment Confirmed at 8:30 AM Tomorrow','lhr.sehat','2015-12-17 10:16:23'),(255,8863,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-17 10:16:24'),(256,8957,' Appointment confirm at 4:00 PM to 5:00  PM today ','lhr.sehat','2015-12-23 09:03:19'),(257,8957,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-23 09:03:20'),(258,8984,' Appointment confirm at 2:00 PM today ','lhr.sehat','2015-12-26 06:18:24'),(259,8984,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-26 06:18:25'),(260,8989,' Appointment confirm at 5:00 PM today ','lhr.sehat','2015-12-26 10:25:18'),(261,8989,'Call closed by user \"lhr.sehat\"','lhr.sehat','2015-12-26 10:25:19'),(262,9136,' Appointment Confirm at 4:00 PM 5:00 PM today ','lhr.sehat','2016-01-02 09:07:21'),(263,9136,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-02 09:07:22'),(264,9170,'i call to the patient at 12.57pm he ask me that call me after 1 hour after prescription clearence.','rwp.sehat','2016-01-04 08:19:27'),(265,9170,'I called customer and asked about the prescription. He said he has no prescription and let him contact to his physician for a valid prescription. I will call him after an hour','rwp.sehat','2016-01-04 08:34:33'),(266,9172,' Appointment confirm at 3:30 PM today ','lhr.sehat','2016-01-04 09:00:20'),(267,9172,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-04 09:00:21'),(268,9170,'i call him again, He said that he has no prescription and let him contact to his physician for a valid prescription. I will call him tomorrow.','rwp.sehat','2016-01-04 09:04:21'),(269,9170,'customer told that his throat is infected and asked to contect two days later.','rwp.sehat','2016-01-05 05:34:28'),(270,8778,'Appointment confirm at 5:00PM today','lhr.sehat','2016-01-06 08:03:08'),(271,8778,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-06 08:03:09'),(272,9170,'customer told that as per docter advise ten days required curity of my infected throat, i asked him to cancel the order and again give order after alright.','rwp.sehat','2016-01-07 05:49:22'),(273,9343,' Appointment confirm at 5:00 PM today ','lhr.sehat','2016-01-12 10:07:42'),(274,9343,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-12 10:07:43'),(275,9365,'Today i call the customer order confirm for tomorrow at 2pm','khi.sehat','2016-01-13 10:35:18'),(276,9365,'Call closed by user \"khi.sehat\"','khi.sehat','2016-01-13 10:35:19'),(277,9364,' Appointment confirm at 5:00 PM today ','lhr.sehat','2016-01-13 10:46:50'),(278,9364,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-13 10:46:51'),(279,8779,'Patient will confirm the appointment by tomorrow','lhr.sehat','2016-01-13 10:48:19'),(280,8779,'  Appointment confirm at 5:00 PM today ','lhr.sehat','2016-01-14 09:27:32'),(281,8779,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-14 09:27:33'),(282,9430,'Appointment confirm at 8:30PM Today','lhr.sehat','2016-01-16 07:42:09'),(283,9430,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-16 07:42:10'),(284,9434,'Appointment confirm at 4:00 PM Today','rwp.sehat','2016-01-16 09:22:41'),(285,9434,'Call closed by user \"rwp.sehat\"','rwp.sehat','2016-01-16 09:22:42'),(286,9493,'Appointment confirm at 5:30Pm today.','khi.sehat','2016-01-20 04:41:21'),(287,9493,'Call closed by user \"khi.sehat\"','khi.sehat','2016-01-20 04:41:22'),(288,9526,' Appointment confirm at 5:00 PM today ','lhr.sehat','2016-01-21 05:23:46'),(289,9526,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-21 05:23:47'),(290,9519,'Appointment Confirm at 10:30AM tomorrow Friday (22-01-2016)','lhr.sehat','2016-01-21 09:55:01'),(291,9519,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-21 09:55:02'),(292,9581,'call connfirm at 11.00 am tomorrow','rwp.sehat','2016-01-25 11:11:46'),(293,9581,'Call closed by user \"rwp.sehat\"','rwp.sehat','2016-01-25 11:11:47'),(294,9635,'Call the patient today at 10:10AM not recieve.','khi.sehat','2016-01-27 05:01:57'),(295,9635,'Call at 10:55Am Order confirm for today at 05:30PM','khi.sehat','2016-01-27 05:47:14'),(296,9635,'Call closed by user \"khi.sehat\"','khi.sehat','2016-01-27 05:47:15'),(297,9647,'Appointment is of 12:00 PM tomorrow. Vacinator will call tomorrow morning to reconfirm the time.','anjum.javed','2016-01-27 09:29:36'),(298,9647,'Appointment confirm at 12:00PM today','lhr.sehat','2016-01-28 05:44:16'),(299,9647,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-28 05:44:17'),(300,9658,'Appointment confirm at 3:00 PM Tomorrow ','lhr.sehat','2016-01-28 09:15:17'),(301,9658,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-28 09:15:18'),(302,9651,'Appointment confirm at 3:00 PM Tomorrow','lhr.sehat','2016-01-28 09:16:02'),(303,9651,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-28 09:16:03'),(304,9698,'Appointment confirm at 11:30 AM Today','lhr.sehat','2016-01-29 05:37:20'),(305,9698,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-29 05:37:21'),(306,9723,'Appointment is Confirmed at 2:30PM today','lhr.sehat','2016-01-30 08:38:46'),(307,9723,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-30 08:38:47'),(308,9730,' Appointment confirm at 9:00 PM today','lhr.sehat','2016-01-30 11:39:55'),(309,9730,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-01-30 11:39:56'),(310,9779,'We called the customer Mr. Shahid Ali. He said that his doctor scheduel the Prevenar Vaccine on 9th Feb,2016 so we will take appointment on 8th Feb for vaccination. ','khi.sehat','2016-02-02 09:50:36'),(311,9810,'Vaccinated yesturday in the camp','lhr.sehat','2016-02-04 09:05:50'),(312,9810,'Vaccinated In the Nestle Camp Yesterday.','anjum.javed','2016-02-04 09:08:20'),(313,9810,'Call closed by user \"anjum.javed\"','anjum.javed','2016-02-04 09:08:21'),(314,9810,'Vaccinated In the Nestle Camp Yesterday.','anjum.javed','2016-02-04 09:08:25'),(315,9810,'Call closed by user \"anjum.javed\"','anjum.javed','2016-02-04 09:08:26'),(316,9825,'Vaccinated In Nestle Camp Yesterday','lhr.sehat','2016-02-04 09:09:44'),(317,9825,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-04 09:09:45'),(318,9825,'Vaccinated In Nestle Camp Yesterday','lhr.sehat','2016-02-04 09:09:49'),(319,9825,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-04 09:09:50'),(320,9826,'Vaccinated In Nestle Camp Yesterday','lhr.sehat','2016-02-04 09:10:23'),(321,9826,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-04 09:10:24'),(322,9827,'Vaccinated In Nestle Camp Yesterday','lhr.sehat','2016-02-04 09:10:38'),(323,9827,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-04 09:10:39'),(324,9832,'Appoinntment confirm at 3:30 to 4:00PM today','lhr.sehat','2016-02-04 09:21:27'),(325,9832,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-04 09:21:28'),(326,9779,'call the customer at 10:25AM order for tomorrow at 2:30PM','khi.sehat','2016-02-08 05:12:49'),(327,9779,'Call closed by user \"khi.sehat\"','khi.sehat','2016-02-08 05:12:50'),(328,10152,'Today i call the customer at 02:00Pm order confirm for today at 05:30Pm.','khi.sehat','2016-02-18 08:57:16'),(329,10152,'Call closed by user \"khi.sehat\"','khi.sehat','2016-02-18 08:57:18'),(330,10180,'customer want the vaccination on wednesday 24.02.2016. I will call on tuesday 23.02.2016 and get confirmation.','rwp.sehat','2016-02-20 05:11:43'),(331,10180,'call confirm. patient told to arrive at 12:30 tomorrow for vaccination, so I will go by tomorrow as directed.','rwp.sehat','2016-02-23 04:49:17'),(332,10180,'Call closed by user \"rwp.sehat\"','rwp.sehat','2016-02-23 04:49:18'),(333,10317,' Appointment confirm at 10:30 PM today ','lhr.sehat','2016-02-25 04:53:40'),(334,10317,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-02-25 04:53:41'),(335,8780,'Customer\"s Primary Number is not responding.','lhr.sehat','2016-03-03 06:54:21'),(336,8780,'Customer\"s Primary Number is not responding','lhr.sehat','2016-03-03 09:11:37'),(337,8780,'Customer\"s Primary Number is not responding','lhr.sehat','2016-03-03 09:11:56'),(338,8780,'Customer\"s Primary Number is not responding','lhr.sehat','2016-03-03 09:12:28'),(339,10479,' Appointment confirm at 3:00 PM today ','lhr.sehat','2016-03-03 09:15:53'),(340,10479,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-03 09:15:54'),(341,8780,'Customer\"s Primary Number is not responding	','lhr.sehat','2016-03-04 05:01:45'),(342,8780,'Customer\"s Primary Number is not responding','lhr.sehat','2016-03-04 06:50:22'),(343,8780,' Customer\"s Primary Number is not responding','lhr.sehat','2016-03-04 07:14:29'),(344,10481,'Appointmnt Confirm at 3Pm today','lhr.sehat','2016-03-04 07:48:01'),(345,10481,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-04 07:48:02'),(346,10482,' Appointment confirm at 3:00 PM today ','lhr.sehat','2016-03-05 09:33:48'),(347,10482,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-05 09:33:50'),(348,8780,'The customer\"s number is still not responding','lhr.sehat','2016-03-07 05:27:19'),(349,8780,'The contact number is switched off.','anjum.javed','2016-03-08 04:41:10'),(350,8780,'The contact number is switched off.','lhr.sehat','2016-03-08 07:06:24'),(351,8780,'The contact number is switched off.','lhr.sehat','2016-03-08 07:08:04'),(352,8780,'The contact number is switched off.','lhr.sehat','2016-03-09 05:05:25'),(353,8780,'The contact number is switched off.','lhr.sehat','2016-03-09 09:04:15'),(354,8780,'The contact number is switched off.','lhr.sehat','2016-03-09 09:59:39'),(355,8780,'The contact number is switched off.','lhr.sehat','2016-03-09 10:00:09'),(356,8780,'The contact number is switched off.','lhr.sehat','2016-03-09 10:23:48'),(357,8780,' The contact number is switched off.	','lhr.sehat','2016-03-09 11:08:07'),(358,8780,' The contact number is switched off.','lhr.sehat','2016-03-09 12:22:54'),(359,8780,'   The contact number is not responding','lhr.sehat','2016-03-10 04:26:21'),(360,8780,' Appointment confirm at 5:00 PM today ','lhr.sehat','2016-03-10 05:18:39'),(361,8780,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-10 05:18:41'),(362,10760,'Today i call at 10:52AM order confirm for tommorrow at 09:00AM','khi.sehat','2016-03-15 05:13:02'),(363,10760,'Call closed by user \"khi.sehat\"','khi.sehat','2016-03-15 05:13:03'),(364,10753,' Appointment confirm Between 3:00  to 4:00PM today ','lhr.sehat','2016-03-16 08:30:25'),(365,10753,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-16 08:30:26'),(366,10986,' Appointment confirm at 2:00 PM today ','lhr.sehat','2016-03-24 07:51:17'),(367,10986,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-24 07:51:18'),(368,11179,' Appointment confirm at12:30 PM today','lhr.sehat','2016-03-31 06:29:45'),(369,11179,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-03-31 06:29:47'),(370,11472,' Appointment confirm at 5:00 PM today ','lhr.sehat','2016-04-12 08:37:28'),(371,11472,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-04-12 08:37:29'),(372,11880,' Appointment confirm at 2:00 PM today ','lhr.sehat','2016-04-29 04:44:24'),(373,11880,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-04-29 04:44:25'),(374,12093,'Today i call the customer at 03:00PM but customer phone off. 2nd No attend his father he says please call in Evening.','khi.sehat','2016-05-06 10:04:40'),(375,12093,'Today i call the customer at 09:45AM customer says i call u back order not confirm','khi.sehat','2016-05-07 05:26:59'),(376,12093,'Order confirm today at 02:00PM','khi.sehat','2016-05-07 05:32:54'),(377,12093,'Call closed by user \"khi.sehat\"','khi.sehat','2016-05-07 05:32:55'),(378,12408,'Today call the customer at 01:20PM order confirm for today at 06:00PM','khi.sehat','2016-05-18 08:12:10'),(379,12408,'Call closed by user \"khi.sehat\"','khi.sehat','2016-05-18 08:12:11'),(380,12436,'Appoint conferm Between 3:00 to 4:00 Pm today','lhr.sehat','2016-05-19 09:42:24'),(381,12436,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-05-19 09:42:25'),(382,12591,'Appointment confermed at 6:00 Pm Today','lhr.sehat','2016-05-27 12:20:24'),(383,12591,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-05-27 12:20:25'),(384,12592,'Appointment Conferm Between 3:00 Pm Today','lhr.sehat','2016-05-28 09:56:50'),(385,12592,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-05-28 09:56:51'),(386,12747,'i call to customer at 2:56pm. she said that,she will contect on monday after dialysis.','rwp.sehat','2016-06-04 10:15:30'),(387,12747,'Today i call to customer at 09:07am, she told me when her patient will stable.Patinet his already in pain.','rwp.sehat','2016-06-06 04:21:10'),(388,12747,'today i call to cutomer at 09:07am she told me that, she will inform me when her patient will stable, patient is already in pain.   ','rwp.sehat','2016-06-06 05:48:53'),(389,12747,'call confirm at 01:15pm','rwp.sehat','2016-06-06 08:31:41'),(390,12747,'Call closed by user \"rwp.sehat\"','rwp.sehat','2016-06-06 08:31:42'),(391,14553,'Appoinntment confirm at 4:30 PM today','lhr.sehat','2016-08-26 05:05:46'),(392,14553,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-08-26 05:05:47'),(393,14698,'Appoinntment confirm at 12:30 PM today','lhr.sehat','2016-08-31 06:02:23'),(394,14698,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-08-31 06:02:24'),(395,14900,'Appointment confirm at 4:00 PM today ','lhr.sehat','2016-09-06 05:27:41'),(396,14900,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-09-06 05:27:42'),(397,15291,'Appointment confirm at 11:30 AM today','lhr.sehat','2016-09-19 05:48:17'),(398,15291,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-09-19 05:48:18'),(399,15574,'Appoinntment Confirm at 5:00 PM today','lhr.sehat','2016-09-26 05:58:46'),(400,15574,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-09-26 05:58:47'),(401,15698,'Appoinntment Confirm at 4:00 PM today','lhr.sehat','2016-09-30 05:16:10'),(402,15698,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-09-30 05:16:11'),(403,15856,'Appointment Confirm at 6:00 PM today ','lhr.sehat','2016-10-05 12:34:06'),(404,15856,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-05 12:34:07'),(405,15958,'Appointment Confirm at 4:30 PM today ','lhr.sehat','2016-10-08 10:23:22'),(406,15958,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-08 10:23:23'),(407,15997,'Appointment Confirmed at 3PM today','lhr.sehat','2016-10-10 09:33:36'),(408,15997,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-10 09:33:37'),(409,16077,'today time 6pm. order confirmed ','support','2016-10-13 08:55:31'),(410,16077,'Call closed by user \"support\"','support','2016-10-13 08:55:32'),(411,16085,'Appoinntment confirm at 5:30 PM today','lhr.sehat','2016-10-14 07:16:33'),(412,16085,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-14 07:16:34'),(413,16183,'Appointment Confirm at 2:30 PM today','lhr.sehat','2016-10-15 06:21:20'),(414,16183,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-15 06:21:21'),(415,16179,'Appointment Confirm at 1:00 PM today','lhr.sehat','2016-10-15 06:47:10'),(416,16179,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-15 06:47:11'),(417,16279,'Appointment Confirm at 8:00 PM today','lhr.sehat','2016-10-18 11:10:54'),(418,16279,'Appointment Confirm at 8:00 PM today','lhr.sehat','2016-10-18 11:12:09'),(419,16279,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-18 11:12:11'),(420,16318,'Appointment Confirm at 5:00 PM tomorrow.','lhr.sehat','2016-10-19 10:36:50'),(421,16318,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-19 10:36:51'),(422,16346,'Appointment Confirm at 6:00 PM today.','lhr.sehat','2016-10-20 07:20:54'),(423,16346,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-20 07:20:56'),(424,16355,'Appointment Confirm at 5:00 PM today','lhr.sehat','2016-10-20 09:24:28'),(425,16355,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-20 09:24:29'),(426,16393,'Appointment Confirm at 5:00 PM today','lhr.sehat','2016-10-22 06:51:49'),(427,16393,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-22 06:51:50'),(428,16481,'Appointment Confirm at 5:00 PM today','lhr.sehat','2016-10-24 06:50:32'),(429,16481,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-24 06:50:33'),(430,16503,'he said that he will call back to confirm the appointment','lhr.sehat','2016-10-25 06:00:46'),(431,16503,'Patient will confirm the appointment by tomorrow morning.','lhr.sehat','2016-10-25 07:15:25'),(432,16503,'Appointment Confirm at 4:00 PM today','lhr.sehat','2016-10-26 05:34:45'),(433,16503,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-26 05:34:46'),(434,16713,'Appointment Confirm at 5:30 PM today','lhr.sehat','2016-10-31 09:47:17'),(435,16713,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-10-31 09:47:18'),(436,16817,'Appointment Confirm at 5:30 PM today','lhr.sehat','2016-11-04 04:35:48'),(437,16817,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-11-04 04:35:49'),(438,16834,'Appointment Confirm at 12:00 PM today','lhr.sehat','2016-11-04 06:24:11'),(439,16834,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-11-04 06:24:12'),(440,17191,'Appointment Confirm at 4:30 PM today','lhr.sehat','2016-11-16 09:50:32'),(441,17191,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-11-16 09:50:33'),(442,17241,'Appointment confermed at 11:00 AM Tomorrow','lhr.sehat','2016-11-17 12:05:06'),(443,17241,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-11-17 12:05:07'),(444,17455,'Appointment Confirm at 4:30 PM today','lhr.sehat','2016-11-29 07:25:08'),(445,17455,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-11-29 07:25:09'),(446,17937,'Appointment Confirm at 4:15 PM today','lhr.sehat','2016-12-14 06:03:59'),(447,17937,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-12-14 06:04:00'),(448,18005,'Appointment Confirm at 4:00 PM today','lhr.sehat','2016-12-16 05:26:37'),(449,18005,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-12-16 05:26:38'),(450,18109,'Appointment Confirm at 6:15 PM today','lhr.sehat','2016-12-20 09:41:06'),(451,18109,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-12-20 09:41:07'),(452,18223,'Appointment Confirm at 4:00 PM today','lhr.sehat','2016-12-26 09:02:23'),(453,18223,'Call closed by user \"lhr.sehat\"','lhr.sehat','2016-12-26 09:02:24'),(454,18562,'Appointment Confirm at 11:00 AM today','lhr.sehat','2017-01-10 04:53:22'),(455,18562,'Call closed by user \"lhr.sehat\"','lhr.sehat','2017-01-10 04:53:23'),(456,19151,'Appointment Confirm at 5:00 PM Tomorrow (Monday)','lhr.sehat','2017-01-28 10:30:38'),(457,19151,'Call closed by user \"lhr.sehat\"','lhr.sehat','2017-01-28 10:30:39'),(461,30841,'on 26 Friday 2018  at 11:30 am','Shakeel.ahmed','2018-01-25 12:53:21'),(462,30841,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2018-01-25 12:53:22'),(463,31079,'firday 02/02/2108  11am','Shakeel.ahmed','2018-02-01 10:53:49'),(464,31079,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2018-02-01 10:53:50'),(465,32027,'12 pm to dalvre','Shakeel.ahmed','2018-02-21 06:27:56'),(466,32027,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2018-02-21 06:27:57'),(467,49427,'manday 6pm','Shakeel.ahmed','2019-04-08 12:39:41'),(468,49427,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-04-08 12:39:42'),(469,49505,'appointment confirm at 11-am today ','Shakeel.ahmed','2019-04-11 05:01:25'),(470,49505,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-04-11 05:01:26'),(471,50018,'Appointment confirm at 2 pm today','Shakeel.ahmed','2019-04-25 06:20:15'),(472,50018,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-04-25 06:20:16'),(473,55371,'Appointment Confirm at.5.30 pm','Shakeel.ahmed','2019-10-02 10:01:30'),(474,55371,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-10-02 10:01:31'),(475,55674,'appointment confirm at.2.30 pm','Shakeel.ahmed','2019-10-09 08:54:04'),(476,55674,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-10-09 08:54:05'),(477,56101,'Appointment confir at.2 pm ','Shakeel.ahmed','2019-10-22 04:34:10'),(478,56101,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-10-22 04:34:11'),(479,56562,'Appointment confir at.2 pm ','Shakeel.ahmed','2019-11-06 07:53:17'),(480,56562,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-11-06 07:53:18'),(481,57102,'appointment confirm at.12.30 ','Shakeel.ahmed','2019-11-16 06:01:27'),(482,57102,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-11-16 06:01:28'),(483,57394,'Appointment confir at.3 pm','Shakeel.ahmed','2019-11-22 09:31:41'),(484,57394,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-11-22 09:31:42'),(485,57394,'Appointment confir at.3 pm','Shakeel.ahmed','2019-11-22 09:32:21'),(486,57394,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-11-22 09:32:22'),(487,57394,'Appointment confir at.3 pm','Shakeel.ahmed','2019-11-22 09:33:07'),(488,57394,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-11-22 09:33:08'),(489,58137,'appointment confirm at.2.30 pm','Shakeel.ahmed','2019-12-21 07:18:48'),(490,58137,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-12-21 07:18:49'),(491,58137,'appointment confirm at.2.30 pm','Shakeel.ahmed','2019-12-21 07:19:23'),(492,58137,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2019-12-21 07:19:24'),(493,58578,'Appointment Confir Monday 4.30pm','Shakeel.ahmed','2020-01-04 06:13:56'),(494,58578,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-01-04 06:13:57'),(495,73009,'Appointment Confirm towmaro 10.30 am','Shakeel.ahmed','2020-10-09 12:07:33'),(496,73009,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-09 12:07:34'),(497,73228,'Appointment confir at.4. pm ','Shakeel.ahmed','2020-10-15 08:07:14'),(498,73228,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-15 08:07:15'),(499,73453,'Appointment Confir friday 4.30pm','Shakeel.ahmed','2020-10-22 12:37:09'),(500,73453,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-22 12:37:10'),(501,73505,'appointment confirm at.6.00 pm','Shakeel.ahmed','2020-10-26 08:06:22'),(502,73505,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-26 08:06:23'),(503,73502,'appointment confirm at.4.30 pm','Shakeel.ahmed','2020-10-26 08:07:31'),(504,73502,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-26 08:07:32'),(505,73657,'Appointment confir at.3 pm','Shakeel.ahmed','2020-10-31 04:47:51'),(506,73657,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-10-31 04:47:52'),(507,73878,'Appointment confir at.3.30 pm','Shakeel.ahmed','2020-11-05 04:49:26'),(508,73878,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-05 04:49:27'),(509,73878,'Appointment confir at.3.30 pm','Shakeel.ahmed','2020-11-05 09:02:06'),(510,73878,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-05 09:02:07'),(511,73970,'Appointment confir at.4.30 pm','Shakeel.ahmed','2020-11-07 07:54:42'),(512,73970,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-07 07:54:44'),(513,73970,'Appointment confir at.4.30 pm','Shakeel.ahmed','2020-11-07 07:55:14'),(514,73970,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-07 07:55:15'),(515,73975,'Appointment confir at.1.30 pm','Shakeel.ahmed','2020-11-09 04:57:19'),(516,73975,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-09 04:57:20'),(517,74015,'Appointment confir at.4.30 pm','Shakeel.ahmed','2020-11-09 05:21:01'),(518,74015,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-09 05:21:02'),(519,74067,'Appointment confir at.11.30 am','Shakeel.ahmed','2020-11-11 05:13:42'),(520,74067,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-11 05:13:43'),(521,74216,'Appointment Confirm at.4.30 pm','Shakeel.ahmed','2020-11-13 10:37:38'),(522,74216,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-13 10:37:39'),(523,74654,'Appointment confir tomaro at.12 pm ','Shakeel.ahmed','2020-11-24 12:00:36'),(524,74654,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-11-24 12:00:37'),(525,75497,'Appointment conffirm at- 5.30 p m','Shakeel.ahmed','2020-12-15 09:05:51'),(526,75497,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:05:52'),(527,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:05:53'),(528,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:05:54'),(529,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:05:55'),(530,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:05:56'),(531,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:05:57'),(532,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:05:58'),(533,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:06:00'),(534,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:01'),(535,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:06:02'),(536,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:03'),(537,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:06:04'),(538,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:05'),(539,75382,'Appointment confirm at 6.30 pm','Shakeel.ahmed','2020-12-15 09:06:06'),(540,75382,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:07'),(541,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:06:09'),(542,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:10'),(543,75497,'Appointment conffirm at- 5.30 p m','Shakeel.ahmed','2020-12-15 09:06:39'),(544,75497,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:40'),(545,75403,'Appointment confirm  6.00 pm','Shakeel.ahmed','2020-12-15 09:06:41'),(546,75403,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:06:42'),(547,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:13'),(548,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:14'),(549,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:15'),(550,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:16'),(551,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:17'),(552,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:18'),(553,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:19'),(554,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:20'),(555,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:21'),(556,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:22'),(557,75401,'Appointment confirm at 4.30 pm','Shakeel.ahmed','2020-12-15 09:12:24'),(558,75401,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:12:25'),(559,75493,'Appointment confirm at .3.00 P m','Shakeel.ahmed','2020-12-15 09:13:37'),(560,75493,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-15 09:13:38'),(561,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 04:40:46'),(562,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 04:40:48'),(563,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 04:40:49'),(564,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 04:40:50'),(565,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 04:40:51'),(566,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 04:40:52'),(567,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 04:40:54'),(568,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 04:40:55'),(569,75538,'Appointment conffirm at- 2.45 p m','Shakeel.ahmed','2020-12-17 08:16:08'),(570,75538,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:16:09'),(571,75538,'Appointment conffirm at- 2.45 p m','Shakeel.ahmed','2020-12-17 08:17:21'),(572,75538,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:17:22'),(573,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 08:17:24'),(574,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:17:25'),(575,75538,'Appointment conffirm at- 2.45 p m','Shakeel.ahmed','2020-12-17 08:18:41'),(576,75538,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:18:42'),(577,75449,'Appointment canfirm at  11.30 am','Shakeel.ahmed','2020-12-17 08:18:43'),(578,75449,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:18:44'),(579,75570,'Appointment confirm tomaro at 12.15 pm','Shakeel.ahmed','2020-12-17 08:44:33'),(580,75570,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-17 08:44:34'),(581,75474,'Appointment confirm at..3.00pm','Shakeel.ahmed','2020-12-18 06:19:30'),(582,75474,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-18 06:19:31'),(583,75474,'Appointment confirm at..3.00pm','Shakeel.ahmed','2020-12-18 06:19:32'),(584,75474,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-18 06:19:33'),(585,75482,'Appointment conffirm at- 2.45 p m','Shakeel.ahmed','2020-12-18 06:25:56'),(586,75482,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-18 06:25:57'),(587,75484,'Appointment confir at.11.55 pm','Shakeel.ahmed','2020-12-18 06:27:03'),(588,75484,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-18 06:27:04'),(589,75436,'Appointment Confirm at 11.15 Am','Shakeel.ahmed','2020-12-21 05:23:58'),(590,75436,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-21 05:23:59'),(591,75436,'Appointment Confirm at 11.15 Am','Shakeel.ahmed','2020-12-21 05:24:00'),(592,75436,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-21 05:24:01'),(593,75700,'Appointment confir at.11.30 am','Shakeel.ahmed','2020-12-21 05:29:12'),(594,75700,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-21 05:29:13'),(595,75741,'Appointment confir at.3 pm','Shakeel.ahmed','2020-12-21 10:45:51'),(596,75741,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-21 10:45:52'),(597,75755,'Appointment confir at.3 pm','Shakeel.ahmed','2020-12-22 11:37:53'),(598,75755,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-22 11:37:54'),(599,75797,'Appointment confirm at .6.00 P m','Shakeel.ahmed','2020-12-23 09:09:31'),(600,75797,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-23 09:09:32'),(601,75826,'Appointment conffirm at- 4.30 p m','Shakeel.ahmed','2020-12-23 09:44:13'),(602,75826,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-23 09:44:14'),(603,75827,'Appointment confir at.10.15 am','Shakeel.ahmed','2020-12-24 04:57:05'),(604,75827,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-24 04:57:06'),(605,75903,'Appointment confir at.5.30 pm','Shakeel.ahmed','2020-12-24 11:32:16'),(606,75903,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2020-12-24 11:32:17'),(607,78547,'Appointment confir at.6 pm ','Shakeel.ahmed','2021-01-11 10:47:41'),(608,78547,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2021-01-11 10:47:42'),(609,78500,'Appointment confir at.1. pm','Shakeel.ahmed','2021-01-12 05:47:04'),(610,78500,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2021-01-12 05:47:05'),(611,80808,'Appointment confir at.6 pm','Shakeel.ahmed','2021-03-11 09:12:32'),(612,80808,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2021-03-11 09:12:33'),(613,83761,'Appointment Confirm towmaro 6.00pm','Shakeel.ahmed','2021-05-18 10:19:36'),(614,83761,'Call closed by user \"Shakeel.ahmed\"','Shakeel.ahmed','2021-05-18 10:19:37');
/*!40000 ALTER TABLE `order_remarks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_status`
--

DROP TABLE IF EXISTS `order_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_status` (
  `recid` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(11) NOT NULL,
  `close_call` int(1) NOT NULL DEFAULT '0' COMMENT '0 = show order in ''pending order'' window   |   1 = Do not list order in ''pending orders'' window.',
  `ord_city` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`recid`)
) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_status`
--

LOCK TABLES `order_status` WRITE;
/*!40000 ALTER TABLE `order_status` DISABLE KEYS */;
INSERT INTO `order_status` VALUES (1,3806,1,'Lahore'),(2,3835,1,'Lahore'),(3,3852,1,'Lahore'),(4,3871,1,'Lahore'),(5,3870,1,'Lahore'),(6,3907,1,'Lahore'),(7,3919,0,'Lahore'),(8,3934,1,'Lahore'),(9,3933,1,'Lahore'),(10,3989,1,'Lahore'),(11,3991,1,'Karachi'),(12,3978,1,'Lahore'),(13,4145,1,'Lahore'),(14,4213,1,'Karachi'),(15,4273,1,'Lahore'),(16,4330,1,'Lahore'),(17,4377,1,'Lahore'),(18,4380,1,'Lahore'),(19,4662,1,'Lahore'),(20,5283,1,'Lahore'),(21,5291,1,'Lahore'),(22,5658,1,'Lahore'),(23,6074,1,'Lahore'),(24,6075,0,'Lahore'),(25,6166,1,'Karachi'),(26,6223,0,'Karachi'),(27,6336,1,'Lahore'),(28,6480,1,'Lahore'),(29,6608,1,'Lahore'),(30,6650,1,'Lahore'),(31,6754,1,'Lahore'),(32,6871,1,'Lahore'),(33,6925,1,'Lahore'),(34,6949,1,'Lahore'),(35,6984,1,'Lahore'),(36,7001,1,'Lahore'),(37,7027,1,'Karachi'),(38,7039,1,'Lahore'),(39,7056,1,'Lahore'),(40,7070,1,'Lahore'),(41,7116,1,'Lahore'),(42,7157,1,'Lahore'),(43,7225,1,'Lahore'),(44,7276,1,'Lahore'),(45,7404,1,'Lahore'),(46,7437,1,'Lahore'),(47,7514,1,'Lahore'),(48,7546,1,'Lahore'),(49,7537,1,'Lahore'),(50,7557,1,'Lahore'),(51,7548,1,'Karachi'),(52,7558,1,'Karachi'),(53,7572,1,'Karachi'),(54,7596,1,'Lahore'),(55,7616,1,'Lahore'),(56,7620,1,'Lahore'),(57,7619,1,'Lahore'),(58,7690,1,'Lahore'),(59,7722,1,'Lahore'),(60,7724,1,'Lahore'),(61,7765,0,'Lahore'),(62,7831,1,'Lahore'),(63,7873,1,'Lahore'),(64,7892,1,'Lahore'),(65,7902,0,'Rawalpindi'),(66,7905,1,'Lahore'),(67,7911,1,'Lahore'),(68,7931,1,'Lahore'),(69,7996,1,'Lahore'),(70,8007,1,'Lahore'),(71,8015,1,'Lahore'),(72,8014,1,'Lahore'),(73,8025,1,'Lahore'),(74,8057,1,'Lahore'),(75,8120,1,'Lahore'),(76,8141,1,'Lahore'),(77,8161,1,'Karachi'),(78,8158,1,'Lahore'),(79,8194,1,'Lahore'),(80,8200,1,'Lahore'),(81,8221,1,'Lahore'),(82,8262,1,'Rawalpindi'),(83,8271,1,'Lahore'),(84,8287,1,'Lahore'),(85,8280,1,'Lahore'),(86,8301,1,'Lahore'),(87,8435,1,'Lahore'),(88,8469,1,'Lahore'),(89,8518,1,'Islamabad'),(90,8520,1,'Lahore'),(91,8544,1,'Lahore'),(92,8530,1,'Lahore'),(93,8590,1,'Karachi'),(94,8629,1,'Lahore'),(95,8632,0,'Islamabad'),(96,8659,1,'Lahore'),(97,8689,1,'Lahore'),(98,8750,1,'Lahore'),(99,8761,1,'Lahore'),(100,8802,1,'Lahore'),(101,8777,1,'Lahore'),(102,8863,1,'Lahore'),(103,8957,1,'Lahore'),(104,8984,1,'Lahore'),(105,8989,1,'Lahore'),(106,9136,1,'Lahore'),(107,9170,0,'Islamabad'),(108,9172,1,'Lahore'),(109,8778,1,'Lahore'),(110,9343,1,'Lahore'),(111,9365,1,'Karachi'),(112,9364,1,'Lahore'),(113,8779,1,'Lahore'),(114,9430,1,'Lahore'),(115,9434,1,'Islamabad'),(116,9493,1,'Karachi'),(117,9526,1,'Lahore'),(118,9519,1,'Lahore'),(119,9581,1,'Islamabad'),(120,9635,1,'Karachi'),(121,9647,1,'Lahore'),(122,9658,1,'Lahore'),(123,9651,1,'Lahore'),(124,9698,1,'Lahore'),(125,9723,1,'Lahore'),(126,9730,1,'Lahore'),(127,9779,1,'Karachi'),(128,9810,1,'Lahore'),(129,9825,1,'Lahore'),(130,9826,1,'Lahore'),(131,9827,1,'Lahore'),(132,9832,1,'Lahore'),(133,10152,1,'Karachi'),(134,10180,1,'Islamabad'),(135,10317,1,'Lahore'),(136,8780,1,'Lahore'),(137,10479,1,'Lahore'),(138,10481,1,'Lahore'),(139,10482,1,'Lahore'),(140,10760,1,'Karachi'),(141,10753,1,'Lahore'),(142,10986,1,'Lahore'),(143,11179,1,'Lahore'),(144,11472,1,'Lahore'),(145,11880,1,'Lahore'),(146,12093,1,'Karachi'),(147,12408,1,'Karachi'),(148,12436,1,'Lahore'),(149,12591,1,'Lahore'),(150,12592,1,'Lahore'),(151,12747,1,'Islamabad'),(152,14553,1,'Lahore'),(153,14698,1,'Lahore'),(154,14900,1,'Lahore'),(155,15291,1,'Lahore'),(156,15574,1,'Lahore'),(157,15698,1,'Lahore'),(158,15856,1,'Lahore'),(159,15958,1,'Lahore'),(160,15997,1,'Lahore'),(161,16077,1,'Lahore'),(162,16085,1,'Lahore'),(163,16183,1,'Lahore'),(164,16179,1,'Lahore'),(165,16279,1,'Lahore'),(166,16318,1,'Lahore'),(167,16346,1,'Lahore'),(168,16355,1,'Lahore'),(169,16393,1,'Lahore'),(170,16481,1,'Lahore'),(171,16503,1,'Lahore'),(172,16713,1,'Lahore'),(173,16817,1,'Lahore'),(174,16834,1,'Lahore'),(175,17191,1,'Lahore'),(176,17241,1,'Lahore'),(177,17455,1,'Lahore'),(178,17937,1,'Lahore'),(179,18005,1,'Lahore'),(180,18109,1,'Lahore'),(181,18223,1,'Lahore'),(182,18562,1,'Lahore'),(183,19151,1,'Lahore'),(185,30841,1,'Lahore'),(186,31079,1,'Lahore'),(187,32027,1,'Lahore'),(188,49427,1,'Lahore'),(189,49505,1,'Lahore'),(190,50018,1,'Lahore'),(191,55371,1,'Lahore'),(192,55674,1,'Lahore'),(193,56101,1,'Lahore'),(194,56562,1,'Lahore'),(195,57102,1,'Lahore'),(196,57394,1,'Lahore'),(197,58137,1,'Lahore'),(198,58578,1,'Lahore'),(199,73009,1,'Lahore'),(200,73228,1,'Lahore'),(201,73453,1,'Lahore'),(202,73505,1,'Lahore'),(203,73502,1,'Lahore'),(204,73657,1,'Lahore'),(205,73878,1,'Lahore'),(206,73970,1,'Lahore'),(207,73975,1,'Lahore'),(208,74015,1,'Lahore'),(209,74067,1,'Lahore'),(210,74216,1,'Lahore'),(211,74654,1,'Lahore'),(212,75497,1,'Lahore'),(213,75403,1,'Lahore'),(214,75382,1,'Lahore'),(215,75401,1,'Lahore'),(216,75493,1,'Lahore'),(217,75449,1,'Lahore'),(218,75538,1,'Lahore'),(219,75570,1,'Lahore'),(220,75474,1,'Lahore'),(221,75482,1,'Lahore'),(222,75484,1,'Lahore'),(223,75436,1,'Lahore'),(224,75700,1,'Lahore'),(225,75741,1,'Lahore'),(226,75755,1,'Lahore'),(227,75797,1,'Lahore'),(228,75826,1,'Lahore'),(229,75827,1,'Lahore'),(230,75903,1,'Lahore'),(231,78547,1,'Lahore'),(232,78500,1,'Lahore'),(233,80808,1,'Lahore'),(234,83761,1,'Lahore');
/*!40000 ALTER TABLE `order_status` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-04-27 17:19:09
