INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`) VALUES (1,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20240107-000011','05:14:01 PM','2024 01 07','admin','1','  General','  Cash','56.00','56.00','1',NULL,NULL,NULL,NULL,'07 Jan 2024','2024010717:14:01','%','0','56.00','no','0.00',NULL,'202401071714','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(2,'pistha','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','05:28:19 PM','2024 01 08','admin','1','  General','  Cash','70.00','70.00','2',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010817:28:19','%','0','35.00','no','0.00',NULL,'202401081728','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KING CONES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(3,'strawberry','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','05:28:19 PM','2024 01 08','admin','1','  General','  Cash','70.00','70.00','3',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010817:28:19','%','0','35.00','no','0.00',NULL,'202401081728','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KING CONES','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(4,'orange bar','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','08:11:15 pm','2024 01 08','admin','1','  General','  Upiqr','105.00','105.00','4',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010820:11:15','%','0','10.00','no','0.00',NULL,'202401082011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CANDIES','admin','madmin','0',NULL,'29',NULL,NULL,'','','',''),(5,'rasperry duet','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','08:11:15 pm','2024 01 08','admin','1','  General','  Upiqr','105.00','105.00','5',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010820:11:15','%','0','25.00','no','0.00',NULL,'202401082011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CANDIES','admin','madmin','0',NULL,'24',NULL,NULL,'','','',''),(6,'kitcha kairie bar','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','08:11:15 pm','2024 01 08','admin','1','  General','  Upiqr','105.00','105.00','6',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010820:11:15','%','0','10.00','no','0.00',NULL,'202401082011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CANDIES','admin','madmin','0',NULL,'28',NULL,NULL,'','','',''),(7,'mango duet','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240108-000011','08:11:15 pm','2024 01 08','admin','1','  General','  Upiqr','105.00','105.00','7',NULL,NULL,NULL,NULL,'08 Jan 2024','2024010820:11:15','%','0','25.00','no','0.00',NULL,'202401082011','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CANDIES','admin','madmin','0',NULL,'23',NULL,NULL,'','','',''),(8,'chocolate vanilla','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000012','01:13:10 PM','2024 01 09','admin','1','  General','  Cash','100','100','8',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010913:13:10','%','0','20.00','no','0.00',NULL,'202401091313','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','admin','madmin',NULL,NULL,'14',NULL,NULL,'','','',''),(9,'biscoff','1.0','60.00','60.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000013','01:26:15 PM','2024 01 09','admin','1','  General','  Cash','140','140','9',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010913:26:15','%','0','60.00','no','0.00',NULL,'202401091326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KING CONES','admin','madmin',NULL,NULL,'8',NULL,NULL,'','','',''),(10,'butter scotch king cone','2.0','40.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000013','01:26:15 PM','2024 01 09','admin','1','  General','  Cash','140','140','10',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010913:26:15','%','0','80.00','no','0.00',NULL,'202401091326','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KING CONES','admin','madmin',NULL,NULL,'6',NULL,NULL,'','','',''),(11,'vanilla mini cone','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000014','02:02:24 pm','2024 01 09','user1','1','  General','  Cash','45','45','6',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010914:02:24','%','0','10.00','no','0.00',NULL,'202401091402','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Anji ',NULL,NULL,'11',NULL,NULL,'','','',''),(12,'chocolate mini cone','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000014','02:02:24 pm','2024 01 09','user1','1','  General','  Cash','45','45','7',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010914:02:24','%','0','15.00','no','0.00',NULL,'202401091402','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Anji ',NULL,NULL,'12',NULL,NULL,'','','',''),(13,'chocolate vanilla','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240109-000014','02:02:24 pm','2024 01 09','user1','1','  General','  Cash','45','45','8',NULL,NULL,NULL,NULL,'09 Jan 2024','2024010914:02:24','%','0','20.00','no','0.00',NULL,'202401091402','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Anji ',NULL,NULL,'14',NULL,NULL,'','','',''),(14,'Honeymoon Delight 500ml','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000011','01:49:58 pm','2024 01 30','user1','1','  General','  Cash','255','255','3',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013013:49:58','%','0','200.00','no','0.00',NULL,'202401301349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EXOTIC','user1','Nani',NULL,NULL,'',NULL,NULL,'','','',''),(15,'black forest','1.0','55.00','55.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000011','01:49:58 pm','2024 01 30','user1','1','  General','  Cash','255','255','5',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013013:49:58','%','0','55.00','no','0.00',NULL,'202401301349','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MEGASTAR','user1','Nani',NULL,NULL,'32',NULL,NULL,'','','',''),(16,'strawberry pista','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000012','01:53:52 pm','2024 01 30','user1','1','  General','  Cash','20','20','6',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013013:53:52','%','0','20.00','no','0.00',NULL,'202401301353','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SUNDAE CUPS','user1','Nani',NULL,NULL,'59',NULL,NULL,'','','',''),(17,'black current','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000013','06:27:47 pm','2024 01 30','user1','1','  General','  Cash','40','40','6',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:27:47','%','0','40.00','no','0.00',NULL,'202401301827','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Nani',NULL,NULL,'15',NULL,NULL,'','','',''),(18,'rasperry duet','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000014','06:28:52 pm','2024 01 30','user1','1','  General','  Cash','40','40','7',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:28:52','%','0','25.00','no','0.00',NULL,'202401301828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CANDIES','user1','Nani',NULL,NULL,'24',NULL,NULL,'','','',''),(19,'butter scotch mini cone','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000014','06:28:52 pm','2024 01 30','user1','1','  General','  Cash','40','40','8',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:28:52','%','0','15.00','no','0.00',NULL,'202401301828','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Nani',NULL,NULL,'13',NULL,NULL,'','','',''),(20,'mega sandwichChocolate','2.0','35.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000015','06:29:22 pm','2024 01 30','user1','1','  General','  Cash','70','70','9',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:29:22','%','0','70.00','no','0.00',NULL,'202401301829','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KULFIS','user1','Nani',NULL,NULL,'58',NULL,NULL,'','','',''),(21,'black current','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000016','06:31:06 pm','2024 01 30','user1','1','  General','  Cash','20','20','10',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:31:06','%','0','20.00','no','0.00',NULL,'202401301831','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Nani',NULL,NULL,'15',NULL,NULL,'','','',''),(22,'butter scotch mini cone','2.0','15.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000017','06:40:34 pm','2024 01 30','user1','1','  General','  Cash','180','180','13',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:40:34','%','0','30.00','no','0.00',NULL,'202401301840','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','user1','Nani',NULL,NULL,'13',NULL,NULL,'','','',''),(23,'malai kulfi','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000017','06:40:34 pm','2024 01 30','user1','1','  General','  Cash','180','180','14',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:40:34','%','0','30.00','no','0.00',NULL,'202401301840','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KULFIS','user1','Nani',NULL,NULL,'52',NULL,NULL,'','','',''),(24,'choco brownie king cone','2.0','60.00','120.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000017','06:40:34 pm','2024 01 30','user1','1','  General','  Cash','180','180','15',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013018:40:34','%','0','120.00','no','0.00',NULL,'202401301840','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KING CONES','user1','Nani',NULL,NULL,'10',NULL,NULL,'','','',''),(25,'mega sandwichChocolate','1.0','35.00','35.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000018','07:44:58 pm','2024 01 30','user1','1','  General','  Cash','65','65','16',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013019:44:58','%','0','35.00','no','0.00',NULL,'202401301944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KULFIS','user1','Nani',NULL,NULL,'58',NULL,NULL,'','','',''),(26,'malai kulfi','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000018','07:44:58 pm','2024 01 30','user1','1','  General','  Cash','65','65','17',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013019:44:58','%','0','30.00','no','0.00',NULL,'202401301944','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KULFIS','user1','Nani',NULL,NULL,'52',NULL,NULL,'','','',''),(27,'strawberry pista','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-000019','08:39:11 pm','2024 01 30','user1','1','  General','  Cash','20','20','18',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013020:39:11','%','0','20.00','no','0.00',NULL,'202401302039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SUNDAE CUPS','user1','Nani',NULL,NULL,'59',NULL,NULL,'','','',''),(28,'strawberry pista','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240130-0000110','08:40:55 pm','2024 01 30','user1','1','  General','  Cash','20','20','21',NULL,NULL,NULL,NULL,'30 Jan 2024','2024013020:40:55','%','0','20.00','no','0.00',NULL,'202401302040','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SUNDAE CUPS','user1','Nani',NULL,NULL,'59',NULL,NULL,'','','',''),(29,'strawberry pista','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240131-000011','11:32:21 am','2024 01 31','user1','1','  General','  Cash','20','20','23',NULL,NULL,NULL,NULL,'31 Jan 2024','2024013111:32:21','%','0','20.00','no','0.00',NULL,'202401311132','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SUNDAE CUPS','user1','Nani',NULL,NULL,'59',NULL,NULL,'','','',''),(30,'vanilla mini cone','2.0','10.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20240306-000011','02:05:38 pm','2024 03 06','admin','1','  General','  Upiqr','20','20','1',NULL,NULL,NULL,NULL,'06 Mar 2024','2024030614:05:38','%','0','20.00','no','0.00',NULL,'202403061405','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MINI CONES','admin','madmin','0',NULL,'11',NULL,NULL,'','','',''),(31,'Anjeer Badam 500ml','1.0','200.00','200.00','Item',NULL,NULL,'no',NULL,NULL,'20240306-000012','02:22:10 pm','2024 03 06','admin','1','  General','  Upiqr','520','520','2',NULL,NULL,NULL,NULL,'06 Mar 2024','2024030614:22:10','%','0','200.00','no','0.00',NULL,'202403061422','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NUTTY','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(32,'Anjeer badam 1000ml','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20240306-000012','02:22:10 pm','2024 03 06','admin','1','  General','  Upiqr','520','520','3',NULL,NULL,NULL,NULL,'06 Mar 2024','2024030614:22:10','%','0','320.00','no','0.00',NULL,'202403061422','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NUTTY','admin','madmin','0',NULL,'',NULL,NULL,'','','',''),(33,'Anjeer Badam 500ml','2.0','200.00','400.00','Item',NULL,NULL,'no',NULL,NULL,'20240307-000011','10:55:07 am','2024 03 07','admin','1','  General','  Cash','720','720','4',NULL,NULL,NULL,NULL,'07 Mar 2024','2024030710:55:07','%','0','400.00','no','0.00',NULL,'202403071055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NUTTY','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(34,'Anjeer badam 1000ml','1.0','320.00','320.00','Item',NULL,NULL,'no',NULL,NULL,'20240307-000011','10:55:07 am','2024 03 07','admin','1','  General','  Cash','720','720','5',NULL,NULL,NULL,NULL,'07 Mar 2024','2024030710:55:07','%','0','320.00','no','0.00',NULL,'202403071055','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NUTTY','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(35,'Black forest 500ml','1.0','350.00','350.00','Item',NULL,NULL,'no',NULL,NULL,'20240310-000011','10:26:27 am','2024 03 10','admin','1','  General','  Cash','350','350','6',NULL,NULL,NULL,NULL,'10 Mar 2024','2024031010:26:27','%','0','350.00','no','0.00',NULL,'202403101026','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ICE CREAM CAKE','admin','madmin',NULL,NULL,'',NULL,NULL,'','','',''),(36,'Anjeer badam 1000ml','2.0','320.00','640.00','Item',NULL,NULL,'no',NULL,NULL,'20240310-000012','10:39:25 am','2024 03 10','admin','1','  General','  Cash','640','640','7',NULL,NULL,NULL,NULL,'10 Mar 2024','2024031010:39:25','%','0','640.00','no','0.00',NULL,'202403101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NUTTY','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'1000');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`) VALUES (1,'20240107-000011','56.00','admin','2024 01 07','  Cash','  General','56.00','0.00','0.00','0.0','1','202401071714',NULL,NULL,NULL,NULL,NULL),(2,'20240108-000011','70.00','admin','2024 01 08','  Cash','  General','70.00','0.00','0.00','0.0','2','202401081728',NULL,NULL,NULL,NULL,NULL),(3,'20240109-000011','50.00','admin','2024 01 09','  Cash','  General','50.00','0.00','+ 0.00','0.0','3','202401091308',NULL,NULL,NULL,NULL,NULL),(4,'20240109-000012','100.00','admin','2024 01 09','  Cash','  General','100.00','0.00','+ 0.00','0.0','4','202401091313',NULL,NULL,NULL,NULL,NULL),(5,'20240109-000013','140.00','admin','2024 01 09','  Cash','  General','140.00','0.00','+ 0.00','0.0','5','202401091326',NULL,NULL,NULL,NULL,NULL),(6,'20240109-000014','45.00','user1','2024 01 09','  Cash','  General','45.00','0.00','+ 0.00','0.0','6','202401091402',NULL,NULL,NULL,NULL,NULL),(7,'20240130-000011','255.00','user1','2024 01 30','  Cash','  General','255.00','0.00','+ 0.00','0.0','7','202401301349',NULL,NULL,NULL,NULL,NULL),(8,'20240130-000012','20.00','user1','2024 01 30','  Cash','  General','20.00','0.00','+ 0.00','0.0','8','202401301353',NULL,NULL,NULL,NULL,NULL),(9,'20240130-000013','40.00','user1','2024 01 30','  Cash','  General','40.00','0.00','+ 0.00','0.0','9','202401301827',NULL,NULL,NULL,NULL,NULL),(10,'20240130-000014','40.00','user1','2024 01 30','  Cash','  General','40.00','0.00','+ 0.00','0.0','10','202401301828',NULL,NULL,NULL,NULL,NULL),(11,'20240130-000015','70.00','user1','2024 01 30','  Cash','  General','70.00','0.00','+ 0.00','0.0','11','202401301829',NULL,NULL,NULL,NULL,NULL),(12,'20240130-000016','20.00','user1','2024 01 30','  Cash','  General','20.00','0.00','+ 0.00','0.0','12','202401301831',NULL,NULL,NULL,NULL,NULL),(13,'20240130-000017','180.00','user1','2024 01 30','  Cash','  General','180.00','0.00','+ 0.00','0.0','13','202401301840',NULL,NULL,NULL,NULL,NULL),(14,'20240130-000018','65.00','user1','2024 01 30','  Cash','  General','65.00','0.00','+ 0.00','0.0','14','202401301944',NULL,NULL,NULL,NULL,NULL),(15,'20240130-000019','20.00','user1','2024 01 30','  Cash','  General','20.00','0.00','+ 0.00','0.0','15','202401302039',NULL,NULL,NULL,NULL,NULL),(16,'20240130-0000110','20.00','user1','2024 01 30','  Cash','  General','20.00','0.00','+ 0.00','0.0','16','202401302040',NULL,NULL,NULL,NULL,NULL),(17,'20240131-000011','20.00','user1','2024 01 31','  Cash','  General','20.00','0.00','+ 0.00','0.0','17','202401311132',NULL,NULL,NULL,NULL,NULL),(18,'20240306-000011','20.00','admin','2024 03 06','  Upiqr','  General','20.00','0.00','+ 0.00','0.0','18','202403061405',NULL,NULL,NULL,NULL,NULL),(19,'20240306-000012','520.00','admin','2024 03 06','  Upiqr','  General','520.00','0.00','+ 0.00','0.0','19','202403061422',NULL,NULL,NULL,NULL,NULL),(20,'20240307-000011','720.00','admin','2024 03 07','  Cash','  General','720.00','0.00','+ 0.00','0.0','20','202403071055',NULL,NULL,NULL,NULL,NULL),(21,'20240310-000011','350.00','admin','2024 03 10','  Cash','  General','350.00','0.00','+ 0.00','0.0','21','202403101026',NULL,NULL,NULL,NULL,NULL),(22,'20240310-000012','640.00','admin','2024 03 10','  Cash','  General','640.00','0.00','+ 0.00','0.0','22','202403101039',NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'pistha',35),(2,'strawberry',35),(3,'butter scotch king cone',80),(4,'chocolate mini cone',30),(5,'chocolate vanilla',20),(6,'mini chocobar',50),(7,'vanilla mini cone',10);
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,'1','pistha',35,50,'1','KING CONES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','strawberry',35,50,'1','KING CONES',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'6','butter scotch king cone',80,28,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'12','chocolate mini cone',30,10,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'14','chocolate vanilla',20,7,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20','mini chocobar',50,17,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'11','vanilla mini cone',10,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (2,'KING CONES',70),(3,'CANDIES',50),(4,'KING CONES',140),(5,'MINI CONES',100),(6,'CANDIES',50),(7,'KING CONES',140),(8,'MINI CONES',100);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',70);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',70,100);
