INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `cusotmer_activity_temp_top3` (`_id`, `name`, `phone_no`, `email`, `addr`, `total_amount`, `balance`, `discount_value`, `discount_type`, `approval_rate`) VALUES (2,'jabbar khan','9845477580','','hpt',320,'320.0',NULL,NULL,NULL);
INSERT INTO `customerdetails` (`_id`, `name`, `phoneno`, `emailid`, `address`, `rupees`, `billnumber`, `date1`, `time1`, `date`, `total`, `deposit`, `cashout`, `credit`, `charges`, `authentication_pin`, `otp`, `dob`, `refunds`, `total_amount`, `cashout_type`, `credit_default`, `commission_charges`, `commission_charges_type`, `commission_charges_status`, `authentication_pin_status`, `dob_alaram`, `default_discount_status`, `default_discount_amount`, `default_discount_value`, `default_discount_type`, `notes`, `cust_account_no`, `cust_ifsc_code`, `cust_account_holder_name`, `cust_bank_name`, `datetimee_new`, `user_id`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax_selection`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `proceedings`, `SaleType`, `Cheque_num`, `CreditAmount`, `SaleTime`, `SaleDate`, `Transaction_ID`, `Card_Type`, `Card_Num`, `RRN`, `pincode`, `limit_status`, `limit_value`, `limit_present_value`, `write_off`, `loyal_points`) VALUES (1,'naveed','7353912503','','','60.00','20250722-000014','22 Jul 2025','12:05:48 am','2025 07 22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202507220005','z',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','off','off','off','off','off','off','off','off','off','','no limit','','',NULL,'0'),(2,'jabbar khan','9845477580','','hpt','320.00','20250909-000019','09 Sep 2025','08:51:58 pm','2025 09 09',NULL,NULL,NULL,'320',NULL,NULL,NULL,NULL,NULL,'320.00',NULL,'off',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'202509092051','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'All',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'off','  Pay Later','0','off','off','09 Sep 2025','off','off','off','off','','no limit','','',NULL,'0');
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2025 08 26','08:17:12 pm','20250826-000015','qqqq','8.33','220.00','20','26 Aug 2025','240.00',NULL,'202508262017',NULL);
INSERT INTO `expenses_sales` (`_id`, `expensename`, `price`, `category`, `counterperson_username`, `counterperson_name`, `date`, `time`, `datetimee_new`) VALUES (1,'coal','510','Utilities','madmin','madmin','27 Aug 2025','06:56 PM','202508271856'),(2,'egg','160','Utilities','madmin','madmin','27 Aug 2025','06:56 PM','202508271856'),(3,'chicken ','5715','Utilities','madmin','madmin','27 Aug 2025','07:02 PM','202508271902'),(4,'curd','62','Utilities','madmin','madmin','27 Aug 2025','07:03 PM','202508271903');
INSERT INTO `generalorderlistascdesc1` (`_id`, `date`, `time`, `user`, `billno`, `billdetails`, `sales`, `discountamount`, `paymentmethod`, `billtype`, `itemname`, `quan`, `tableid`, `individualprice`, `date1`, `datetimee`, `cardnumber`, `individualtotal`, `billcount`, `hsn_code`, `itemtax_name`, `itemtax_per`, `itemtax_rs`, `globaltax_rs`, `itemtax_name2`, `itemtax_rs2`, `itemtax_name3`, `itemtax_rs3`, `itemtax_name4`, `itemtax_rs4`, `itemtax_name5`, `itemtax_rs5`) VALUES (1,'26 Aug 2025','08:06:10 pm','madmin','20250826-000011',NULL,240,'0','  Upiqr','  Dine-in','Zaika Special Shawarma','2.0','1','120.00',NULL,'20250826200610','','240.00','27','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(2,'26 Aug 2025','08:07:26 PM','madmin','20250826-000012',NULL,240,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','3.0','1','80.00',NULL,'20250826200726','','240.00','28','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(3,'26 Aug 2025','08:07:55 PM','madmin','20250826-000013',NULL,360,'0','  Upiqr','  Dine-in','Zaika Special Shawarma','3.0','1','120.00',NULL,'20250826200755','','360.00','29','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(4,'26 Aug 2025','08:16:10 pm','madmin','20250826-000014',NULL,500,'0','  Upiqr','  Dine-in','Zaika Special Shawarma','5.0','1','120.00',NULL,'20250826201610','','600.00','30','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(5,'26 Aug 2025','08:17:12 pm','madmin','20250826-000015',NULL,220,'20','  Upiqr','  Dine-in','Zaika Special Shawarma','2.0','1','120.00',NULL,'20250826201712','','240.00','31','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(6,'26 Aug 2025','08:18:44 pm','madmin','20250826-000016',NULL,200,'0','  Upiqr','  Dine-in','Zaika Special Shawarma','1.0','1','120.00',NULL,'20250826201844','','120.00','32','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(7,'26 Aug 2025','08:18:44 pm','madmin','20250826-000016',NULL,200,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','1.0','1','80.00',NULL,'20250826201844','','80.00','32','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(8,'26 Aug 2025','08:20:51 PM','madmin','20250826-000017',NULL,240,'0','  Cash','  Dine-in','Regular Chicken Shawarma(regular)','3.0','1','80.00',NULL,'20250826202051','','240.00','33','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(9,'26 Aug 2025','08:27:31 pm','madmin','20250826-000018',NULL,80,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','1.0','1','80.00',NULL,'20250826202731','','80.00','34','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(10,'26 Aug 2025','08:20:51 PM','madmin','20250826-000017',NULL,240,'0','  Cash','  Dine-in','Regular Chicken Shawarma(regular)','3.0','1','80.00',NULL,'20250826202051','','240.00','33','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(11,'26 Aug 2025','08:27:31 pm','madmin','20250826-000018',NULL,80,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','1.0','1','80.00',NULL,'20250826202731','','80.00','34','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(12,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Alfaham Chicken Half','1.0','1','300.00',NULL,'20250826215135','','300.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(13,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','3.0','1','80.00',NULL,'20250826215135','','240.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(14,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Chicken Double Chees Shawarma','1.0','1','140.00',NULL,'20250826215135','','140.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(15,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Alfaham Chicken Half','1.0','1','300.00',NULL,'20250826215135','','300.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(16,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Regular Chicken Shawarma(regular)','3.0','1','80.00',NULL,'20250826215135','','240.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(17,'26 Aug 2025','09:51:35 pm','madmin','20250826-000019',NULL,680,'0','  Upiqr','  Dine-in','Chicken Double Chees Shawarma','1.0','1','140.00',NULL,'20250826215135','','140.00','35','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(18,'04 Sep 2025','08:54:55 pm','M Naveed','20250904-000019',NULL,120,'0','  Upiqr','  Dine-in','Zaika Special Shawarma','1.0','1','120.00',NULL,'20250904205455','','120.00','98','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Regular Chicken Shawarma(regular)',80),(2,'Zaika Special Shawarma',120),(3,'Regular Chicken Shawarma(regular)',1040),(4,'Zaika Special Shawarma',1560),(5,'Zaika Special Shawarma',1680),(6,'Regular Chicken Shawarma(regular)',2320),(7,'Tandoori Chicken Half',300),(8,'Zaika Special Shawarma',3120);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'Shawarma',1680,100,'16'),(2,NULL,'Tikka Chicken',150,12,'1');
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,NULL,'Regular Chicken Shawarma(regular)',80,100,'1','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','Zaika Special Shawarma',120,43,'1','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'4','Regular Chicken Shawarma(regular)',1040,32,'13','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'2','Zaika Special Shawarma',1560,48,'13','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'2','Zaika Special Shawarma',1680,46,'14','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'14','Regular Chicken Shawarma(regular)',2320,32,'29','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'6','Tandoori Chicken Half',300,4,'1','Tandoori Chicken',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'2','Zaika Special Shawarma',3120,43,'26','Shawarma',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'Shawarma',80),(2,'Shawarma',280),(3,'Shawarma',520),(4,'Shawarma',840),(5,'Shawarma',840),(6,'Shawarma',1680),(7,'Shawarma',2120),(8,'Shawarma',2200),(9,'Shawarma',2200),(10,'Alfaham Chicken',600),(11,'Shawarma',2740),(12,'Alfaham Chicken',600),(13,'Shawarma',2860),(14,'Tandoori Chicken',300),(15,'Alfaham Chicken',600),(16,'Shawarma',2940),(17,'Tandoori Chicken',300),(18,'Alfaham Chicken',600),(19,'Shawarma',3460),(20,'Tandoori Chicken',300),(22,'Shawarma',200),(23,'Shawarma',440),(25,'Shawarma',440),(28,'Shawarma',440),(32,'Alfaham Chicken',560),(33,'Shawarma',1080),(34,'Tikka Chicken',130),(38,'Alfaham Chicken',560),(39,'Shawarma',2000),(40,'Tikka Chicken',130),(41,'Alfaham Chicken',560),(42,'Shawarma',2000),(43,'Tikka Chicken',280),(44,'Alfaham Chicken',560),(45,'Shawarma',2000),(46,'Tikka Chicken',280),(47,'Alfaham Chicken',560),(48,'Shawarma',2120),(49,'Tikka Chicken',280),(50,'Alfaham Chicken',1160),(51,'Shawarma',5580),(52,'Tandoori Chicken',300),(53,'Tikka Chicken',280),(54,'Shawarma',1240),(55,'Shawarma',480),(56,'Shawarma',480),(57,'Shawarma',1920),(58,'Shawarma',2000),(59,'Shawarma',400),(60,'Kalmi Chicken',160),(61,'Shawarma',640),(62,'Tikka Chicken',130),(63,'Kalmi Chicken',160),(64,'Shawarma',800),(65,'Tikka Chicken',130),(68,'Shawarma',920),(69,'Shawarma',200),(70,'Shawarma',600),(71,'Shawarma',600),(81,'Shawarma',2220),(83,'Shawarma',2620),(84,'Shawarma',2620),(85,'Shawarma',2780),(87,'Shawarma',400),(88,'Shawarma',1680),(90,'Shawarma',1760),(93,'None',20),(94,'Shawarma',3090),(116,'None',10),(117,'Shawarma',2160),(136,'Shawarma',320),(197,'Shawarma',1640),(222,'None',20),(223,'Shawarma',880),(224,'Shawarma',1240),(225,'Shawarma',1480),(226,'Shawarma',1800),(227,'Shawarma',1800),(228,'Shawarma',2120),(229,'Shawarma',160),(241,'Shawarma',1200),(263,'Shawarma',1240),(264,'Shawarma',1000),(287,'Shawarma',720),(292,'Shawarma',1950),(295,'None',90),(296,'Shawarma',2420),(297,'Shawarma',400),(298,'Shawarma',560),(299,'Shawarma',840),(304,'None',20),(305,'Shawarma',1400),(306,'Shawarma',1040),(311,'Shawarma',2280),(312,'None',10),(313,'Shawarma',1680),(314,'Alfaham Chicken',560),(315,'Shawarma',640),(316,'Alfaham Chicken',560),(317,'Shawarma',1240),(318,'Tandoori Chicken',150),(319,'Shawarma',1380),(320,'Tandoori Chicken',300),(321,'Alfaham Chicken',300),(322,'Shawarma',1380),(323,'Tandoori Chicken',300),(324,'Alfaham Chicken',300),(325,'Shawarma',1380),(326,'Tandoori Chicken',300),(332,'None',20),(333,'Shawarma',1030),(334,'None',10),(335,'Shawarma',1360),(338,'Alfaham Chicken',1420),(339,'None',70),(340,'Shawarma',15600),(341,'Tandoori Chicken',450),(343,'Shawarma',700),(344,'Shawarma',1100),(351,'Shawarma',1000),(353,'Shawarma',1360),(354,'Shawarma',380),(355,'Shawarma',840),(366,'None',200),(367,'Shawarma',33859),(368,'Shawarma',1750),(369,'Shawarma',1830),(372,'Shawarma',1000),(373,'Shawarma',1400),(374,'Shawarma',600),(375,'Shawarma',710),(376,'Shawarma',400),(377,'Shawarma',1470),(378,'Shawarma',1630),(380,'Shawarma',720),(381,'Shawarma',1200),(382,'Shawarma',720),(383,'Shawarma',800),(384,'Shawarma',800),(385,'Shawarma',960),(386,'Shawarma',960),(387,'Shawarma',400),(388,'Shawarma',920),(389,'Shawarma',480),(390,'Shawarma',1110),(391,'Shawarma',2030),(392,'Shawarma',1160),(393,'Shawarma',1160),(394,'Shawarma',360),(395,'Shawarma',1040),(396,'Shawarma',1040),(399,'None',20),(400,'Shawarma',2120),(401,'None',20),(402,'Shawarma',2280),(403,'None',20),(404,'Shawarma',2280),(405,'Shawarma',840),(406,'Shawarma',360),(408,'None',30),(409,'Shawarma',27810),(410,'Shawarma',700),(411,'Shawarma',1340),(412,'Shawarma',240),(413,'None',30),(414,'Shawarma',1600),(415,'None',30),(416,'Shawarma',1600),(419,'None',10),(420,'Shawarma',720);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',80);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',80,100);
