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`, `person`) VALUES (1,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20230214-000011','02:59:45 PM','2023 02 14','admin','1','  General','  Cash','306.00','306.00','1',NULL,NULL,NULL,NULL,'14 Feb 2023','2023021414:59:45','%','0','56.00','no','0.00',NULL,'202302141459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(2,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20230214-000011','02:59:45 PM','2023 02 14','admin','1','  General','  Cash','306.00','306.00','2',NULL,NULL,NULL,NULL,'14 Feb 2023','2023021414:59:45','%','0','250.00','no','0.00',NULL,'202302141459','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(3,'cucumbers kg','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:22:39 pm','2023 06 01','user5','1','  General','  Cash','305.00','305.00','1',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:22:39','%','0','80.00','no','0.00',NULL,'202306012022','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(4,'carrots kg','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:22:39 pm','2023 06 01','user5','1','  General','  Cash','305.00','305.00','2',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:22:39','%','0','210.00','no','0.00',NULL,'202306012022','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(5,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:22:39 pm','2023 06 01','user5','1','  General','  Cash','305.00','305.00','3',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:22:39','%','0','15.00','no','0.00',NULL,'202306012022','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(6,'cucumbers kg','4.0','20.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:23:55 pm','2023 06 01','user2','1','  General','  Cash','360.00','360.00','1',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:23:55','%','0','80.00','no','0.00',NULL,'202306012023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(7,'carrots kg','3.0','70.00','210.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:23:55 pm','2023 06 01','user2','1','  General','  Cash','360.00','360.00','2',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:23:55','%','0','210.00','no','0.00',NULL,'202306012023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(8,'sweet corn piece','2.0','15.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:23:55 pm','2023 06 01','user2','1','  General','  Cash','360.00','360.00','3',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:23:55','%','0','30.00','no','0.00',NULL,'202306012023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(9,'onions big kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20230601-000012','08:23:55 pm','2023 06 01','user2','1','  General','  Cash','360.00','360.00','4',NULL,NULL,NULL,NULL,'01 Jun 2023','2023060120:23:55','%','0','40.00','no','0.00',NULL,'202306012023','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(10,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20231204-000012','04:15:54 PM','2023 12 04','admin','1','  General','  Cash','651.00','651.00','10',NULL,NULL,NULL,NULL,'04 Dec 2023','2023120416:15:54','%','0','250.00','no','0.00',NULL,'202312041615','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(11,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-000011','07:21:45 PM','2023 12 05','admin','1','  General','  Cash','306.00','306.00','11',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120519:21:45','%','0','56.00','no','0.00',NULL,'202312051921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(12,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20231205-000011','07:21:45 PM','2023 12 05','admin','1','  General','  Cash','306.00','306.00','12',NULL,NULL,NULL,NULL,'05 Dec 2023','2023120519:21:45','%','0','250.00','no','0.00',NULL,'202312051921','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL),(13,'Khadirarishtam','1.0','130.00','130.00','Item',NULL,NULL,'no',NULL,NULL,'20240903-000011','10:17:34 AM','2024 09 03','admin','1','  General','  Cash','130.00','130.00','1',NULL,NULL,NULL,NULL,'03 Sep 2024','2024090310:17:34','%','0','130.00','no','0.00',NULL,'202409031017','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Arishtasavams','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','','2');
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
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`, `guide`, `vehicle`) VALUES (1,'20230214-000011','306.00','admin','2023 02 14','  Cash','  General','306.00','0.00','0.00','0.0','1','202302141459',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20230309-000012','15.00','admin','2023 03 09','  Upiqr','  General','15.00','0.00','0.00','0.0','2','202303091739',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'20230602-000013','170.00','user2','2023 06 02','  Cash','  General','170.00','0.00','0.00','0.0','3','202306021247',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'20230602-000014','170.00','user1','2023 06 02','  Cash','  General','170.00','0.00','0.00','0.0','4','202306021251',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'20230602-000015','306.00','user1','2023 06 02','  Cash','  General','306.00','0.00','0.00','0.0','5','202306021253',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'20230602-000016','80.00','user4','2023 06 02','  Cash','  General','80.00','0.00','0.00','0.0','6','202306021255',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'20230602-000017','70.00','user1','2023 06 02','  Cash','  General','70.00','0.00','0.00','0.0','7','202306021256',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'20231218-000011','58.80','admin','2023 12 18','  Cash','  General','58.80','2.80','0','0.0','1','202312181200',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'20240903-000011','130.00','admin','2024 09 03','  Cash','  General','130.00','0.00','0.00','0.0','1','202409031017',NULL,NULL,NULL,NULL,NULL,'','');
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,'rohith','9581497872','krrohith934@gmail.com','bangalore',250,'0.0',NULL,NULL,NULL);
INSERT INTO `discountdetails` (`_id`, `date`, `time`, `billno`, `Discountcodeno`, `Discount_percent`, `Billamount_rupess`, `Discount_rupees`, `date1`, `original_amount`, `billcount`, `datetimee_new`, `paymentmethod`) VALUES (1,'2024 12 19','11:19:54 AM','20241219-000012','Pushpanjali Coupon','100.00','0.00','1.00','19 Dec 2024','1.00',NULL,'202412191119',NULL),(2,'2024 12 19','11:20:30 AM','20241219-000013','Pushpanjali Coupon','28.00','180.00','70.00','19 Dec 2024','250.00',NULL,'202412191120',NULL),(3,'2024 12 19','11:32:39 AM','20241219-000015','Pushpanjali Coupon','28.00','180.00','70.00','19 Dec 2024','250.00','5','202412191132',NULL),(4,'2024 12 19','11:56:24 AM','20241219-000017','Pushpanjali Coupon','28.00','180.00','70.00','19 Dec 2024','250.00','7','202412191156',NULL);
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'sona masoori raw rice 1kg',56),(2,'tata urad dal whole white 1kg',250),(3,'sweet corn piece',15),(4,'tata urad dal whole white 1kg',250),(5,'tata urad dal whole white 1kg',250),(6,'tata urad dal whole white 1kg',500),(7,'tomatoes kg',25);
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','sona masoori raw rice 1kg',294,100,'5','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'2','tata urad dal whole white 1kg',500,66,'2','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'2','tata urad dal whole white 1kg',500,86,'2','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (3,'dals pulses',250),(4,'rice whole grains',56),(5,'fruits and vegetables',110),(6,'fruits and vegetables',415),(7,'branded foods',170),(8,'fruits and vegetables',45),(11,'branded foods',680),(12,'fruits and vegetables',45),(21,'branded foods',680),(22,'dals pulses',250),(23,'fruits and vegetables',45),(24,'rice whole grains',56),(25,'branded foods',680),(26,'dals pulses',250),(27,'fruits and vegetables',125),(28,'rice whole grains',56),(29,'dals pulses',250),(30,'fruits and vegetables',134),(31,'rice whole grains',56),(32,'dals pulses',500),(33,'fruits and vegetables',479),(34,'rice whole grains',112),(35,'dals pulses',500),(36,'fruits and vegetables',479),(37,'rice whole grains',112),(38,'dals pulses',250),(39,'fruits and vegetables',155),(40,'rice whole grains',176),(41,'rice whole grains',58),(42,'rice whole grains',294),(43,'rice whole grains',588),(44,'dals pulses',500),(45,'rice whole grains',3),(46,'dals pulses',500),(47,'fruits and vegetables',28),(48,'rice whole grains',56),(49,'rice whole grains',3),(52,'dals pulses',750),(53,'rice whole grains',2),(54,'dals pulses',1250),(55,'rice whole grains',2);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',306),(2,'user2',170),(3,'user4',80);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',306,100),(2,'User5',110,100),(3,'User4',80,7);
