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`, `item_online`, `old_total_indiv`) VALUES (1,'Tomato Country 1KG','1.56','40.00','62.40','Item',NULL,NULL,'no',NULL,NULL,'20240830-000011','04:42:25 pm','2024 08 30','admin','1','  General','  Cash','56','56','1',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083016:42:25','%','10','56.16','yes','6.24',NULL,'202408301642','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'62.40','','','','',NULL,'40.00'),(2,'Tomato Country 1KG','0.56','45.00','25.20','Item',NULL,NULL,'no',NULL,NULL,'20240830-000012','04:44:17 pm','2024 08 30','admin','1','  General','  Cash','23.00','23','2',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083016:44:17','%','10','22.68','yes','2.52',NULL,'202408301644','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','ladmin',NULL,NULL,'',NULL,'25.20','','','','',NULL,'45.00'),(3,'Tomato Country 1KG','0.85','45.00','38.25','Item',NULL,NULL,'no',NULL,NULL,'20240830-000013','04:50:44 pm','2024 08 30','admin','1','  General','  Cash','34.00','34','3',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083016:50:44','%','10','34.42','yes','3.82',NULL,'202408301650','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','user1','User1',NULL,NULL,'',NULL,'38.25','','','','',NULL,'45.00'),(4,'Tomato Country 1KG','0.55','45.00','24.75','Item',NULL,NULL,'no',NULL,NULL,'20240830-000014','04:59:10 PM','2024 08 30','admin','1','  General','  Cash','22.00','22','4',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083016:59:10','%','10','22.27','yes','2.47',NULL,'202408301659','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','device 1',NULL,NULL,'',NULL,'24.75','','','','',NULL,'45.00'),(5,'Tomato Country 1KG','2.42','45.00','108.90','Item',NULL,NULL,'no',NULL,NULL,'20240830-000015','05:05:27 pm','2024 08 30','admin','1','  General','  Cash','98.00','98','5',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083017:05:27','%','10','98.01','yes','10.89',NULL,'202408301705','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','device 1',NULL,NULL,'',NULL,'108.90','','','','',NULL,'45.00'),(6,'Tomato Country 1KG','1.00','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20240830-000016','05:10:03 pm','2024 08 30','ladmin','1','  General','  Cash','40.00','40','6',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083017:10:03','%','10','40.50','yes','4.50',NULL,'202408301710','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','device 1',NULL,NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(7,'Tomato Country 1KG','5.00','45.00','225.00','Item',NULL,NULL,'no',NULL,NULL,'20240830-000017','05:11:33 pm','2024 08 30','admin','1','  General','  Pay Later','202.00','202','7',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083017:11:33','%','10','202.50','yes','22.50',NULL,'202408301711','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','ladmin','device 1','202',NULL,'',NULL,'225.00','','','','',NULL,'45.00'),(8,'Tomato Country 1KG','7.80','45.00','351.00','Item',NULL,NULL,'no',NULL,NULL,'20240830-000018','05:27:57 pm','2024 08 30','admin','1','  General','  Pay Later','316.00','316','8',NULL,NULL,NULL,NULL,'30 Aug 2024','2024083017:27:57','%','10','315.90','yes','35.10',NULL,'202408301727','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'None','user1','User1','140',NULL,'',NULL,'351.00','','','','',NULL,'45.00');
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`, `order_id`) VALUES (1,'20240830-000011','56','admin','2024 08 30','  Cash','  General','56.16','0.00','- 0.16','0.0','1','202408301642',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20240830-000012','23.00','admin','2024 08 30','  Cash','  General','22.68','0.00','+ 0.32','0.0','2','202408301644',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20240830-000013','34.00','admin','2024 08 30','  Cash','  General','34.42','0.00','- 0.42','0.0','3','202408301650',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20240830-000014','22.00','admin','2024 08 30','  Cash','  General','22.27','0.00','- 0.27','0.0','4','202408301659',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20240830-000015','98.00','admin','2024 08 30','  Cash','  General','98.01','0.00','- 0.01','0.0','5','202408301705',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20240830-000016','40.00','ladmin','2024 08 30','  Cash','  General','40.50','0.00','- 0.50','0.0','6','202408301710',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20240830-000017','202.00','admin','2024 08 30','  Pay Later','  General','202.50','0.00','- 0.50','0.0','7','202408301711',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20240830-000018','316.00','admin','2024 08 30','  Pay Later','  General','315.90','0.00','+ 0.10','0.0','8','202408301727',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
