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,'parrys sugar 5kg','3.0','325.00','975.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','1',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','975.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'975.00','','','','',NULL,'325.00'),(2,'sugar 1kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','2',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','45.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'45.00','','','','',NULL,'45.00'),(3,'sugar 2kg','7.0','90.00','630.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','3',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','630.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'630.00','','','','',NULL,'90.00'),(4,'akar salt crystal 1kg','2.0','17.00','34.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','4',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','34.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'34.00','','','','',NULL,'17.00'),(5,'parrys sugar jar 2kg','1.0','140.00','140.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','5',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','140.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'140.00','','','','',NULL,'140.00'),(6,'catch table salt 200g','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20251009-000011','05:43:39 PM','2025 10 09','admin','1','  General','  Card','1849.00','1849.00','6',NULL,NULL,NULL,NULL,'09 Oct 2025','2025100917:43:39','%','0','25.00','no','0.00',NULL,'202510091743','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'salt and sugar','admin','madmin','0',NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(7,'english muffins 100g','1.0','69.00','69.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','4',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','69.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,'69.00','','','','',NULL,'69.00'),(8,'daily bread milk bread 400g','1.0','30.00','30.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','5',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','30.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,'30.00','','','','',NULL,'30.00'),(9,'parle rusk real elaichi 200g','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','6',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','25.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,'25.00','','','','',NULL,'25.00'),(10,'radish white kg','1.0','24.00','24.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','7',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','24.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'24.00','','','','',NULL,'24.00'),(11,'cucumbers kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','8',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','40.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,'40.00','','','','',NULL,'20.00'),(12,'loreal sampoo 640ml','2.0','370.00','740.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','9',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','740.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'740.00','','','','',NULL,'370.00'),(13,'loreal total 180ml','2.0','147.00','294.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','10',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','294.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'294.00','','','','',NULL,'147.00'),(14,'pantene sampoo 180ml','2.0','132.00','264.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','11',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','264.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'264.00','','','','',NULL,'132.00'),(15,'koleston haircolor creme','1.0','147.00','147.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','12',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','147.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'147.00','','','','',NULL,'147.00'),(16,'comfort fabric 200ml','1.0','48.00','48.00','Item',NULL,NULL,'no',NULL,NULL,'20260628-000011','06:26:43 PM','2026 06 28','admin','1','  General','  Cash','1681.00','1681.00','13',NULL,NULL,NULL,NULL,'28 Jun 2026','2026062818:26:43','%','0','48.00','no','0.00',NULL,'202606281826','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,'48.00','','','','',NULL,'48.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`, `transaction_id`, `transaction_id_org`, `source`, `source1`) VALUES (1,'20251009-000011','1849.00','admin','2025 10 09','  Card','  General','1849.00','0.00','0.00','0.0','1','202510091743',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'20260628-000011','1681.00','admin','2026 06 28','  Cash','  General','1681.00','0.00','0.00','0.0','1','202606281826',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
